← All changes | inc/Databases/class-lp-user-item-meta-db.php +128 -128 4.3.9 → 4.4.8 View file →

		@@ -1,128 +1,128 @@
1		-<?php
2		-
3		-/**
4		- * Class LP_User_Item_Meta_DB
5		- *
6		- * @since 4.2.5
7		- * @version 1.0.0
8		- * @author tungnx
9		- */
10		-class LP_User_Item_Meta_DB extends LP_Database {
11		- private static $_instance;
12		-
13		- protected function __construct() {
14		- parent::__construct();
15		- }
16		-
17		- public static function getInstance() {
18		- if ( is_null( self::$_instance ) ) {
19		- self::$_instance = new self();
20		- }
21		-
22		- return self::$_instance;
23		- }
24		-
25		- /**
26		- * Get user item metas
27		- *
28		- * @return array|null|int|string
29		- * @throws Exception
30		- * @since 4.2.5
31		- * @version 1.0.0
32		- */
33		- public function get_user_item_metas( LP_User_Item_Meta_Filter $filter, int &$total_rows = 0 ) {
34		- $filter->fields = array_merge( $filter->all_fields, $filter->fields );
35		-
36		- if ( empty( $filter->collection ) ) {
37		- $filter->collection = $this->tb_lp_user_itemmeta;
38		- }
39		-
40		- if ( empty( $filter->collection_alias ) ) {
41		- $filter->collection_alias = 'uim';
42		- }
43		-
44		- if ( ! empty( $filter->meta_id ) ) {
45		- $filter->where[] = $this->wpdb->prepare( 'AND uim.meta_id = %d', $filter->meta_id );
46		- }
47		-
48		- if ( ! empty( $filter->learnpress_user_item_id ) ) {
49		- $filter->where[] = $this->wpdb->prepare( 'AND uim.learnpress_user_item_id = %d', $filter->learnpress_user_item_id );
50		- }
51		-
52		- if ( ! empty( $filter->meta_key ) ) {
53		- $filter->where[] = $this->wpdb->prepare( 'AND uim.meta_key = %s', $filter->meta_key );
54		- }
55		-
56		- if ( ! empty( $filter->meta_value ) ) {
57		- $filter->where[] = $this->wpdb->prepare( 'AND uim.meta_value = %s', $filter->meta_value );
58		- }
59		-
60		- if ( ! empty( $filter->extra_value ) ) {
61		- $filter->where[] = $this->wpdb->prepare( 'AND uim.extra_value = %s', $filter->extra_value );
62		- }
63		-
64		- $filter = apply_filters( 'lp/user_item_meta/query/filter', $filter );
65		-
66		- return $this->execute( $filter, $total_rows );
67		- }
68		-
69		-
70		- /**
71		- * Insert data
72		- *
73		- * @param array $data [ learnpress_user_item_id, meta_key, meta_value, extra_value ]
74		- *
75		- * @return int
76		- * @throws Exception
77		- * @version 1.0.1
78		- * @since 4.2.5
79		- */
80		- public function insert_data( array $data ): int {
81		- $filter = new LP_User_Item_Meta_Filter();
82		- foreach ( $data as $col_name => $value ) {
83		- if ( ! in_array( $col_name, $filter->all_fields ) ) {
84		- unset( $data[ $col_name ] );
85		- }
86		- }
87		-
88		- unset( $data['meta_id'] );
89		- $result = $this->wpdb->insert( $this->tb_lp_user_itemmeta, $data );
90		- $this->check_execute_has_error();
91		-
92		- return $this->wpdb->insert_id;
93		- }
94		-
95		- /**
96		- * Update data
97		- *
98		- * @param array $data [ meta_id, learnpress_user_item_id, meta_key, meta_value, extra_value ]
99		- *
100		- * @return bool
101		- *
102		- * @throws Exception
103		- * @since 4.2.5
104		- * @version 1.0.0
105		- */
106		- public function update_data( array $data ): bool {
107		- if ( empty( $data['meta_id'] ) ) {
108		- throw new Exception( __( 'Invalid meta id!', 'learnpress' ) . ' | ' . __METHOD__ );
109		- }
110		-
111		- $filter = new LP_User_Item_Meta_Filter();
112		- $filter->collection = $this->tb_lp_user_itemmeta;
113		- foreach ( $data as $col_name => $value ) {
114		- if ( ! in_array( $col_name, $filter->all_fields ) ) {
115		- continue;
116		- }
117		-
118		- $filter->set[] = $this->wpdb->prepare( $col_name . ' = %s', $value );
119		- }
120		- $filter->where[] = $this->wpdb->prepare( 'AND meta_id = %d', $data['meta_id'] );
121		- $this->update_execute( $filter );
122		-
123		- return true;
124		- }
125		-}
126		-
127		-LP_User_Item_Meta_DB::getInstance();
128		-
	1	+<?php
	2	+
	3	+/**
	4	+ * Class LP_User_Item_Meta_DB
	5	+ *
	6	+ * @since 4.2.5
	7	+ * @version 1.0.0
	8	+ * @author tungnx
	9	+ */
	10	+class LP_User_Item_Meta_DB extends LP_Database {
	11	+ private static $_instance;
	12	+
	13	+ protected function __construct() {
	14	+ parent::__construct();
	15	+ }
	16	+
	17	+ public static function getInstance() {
	18	+ if ( is_null( self::$_instance ) ) {
	19	+ self::$_instance = new self();
	20	+ }
	21	+
	22	+ return self::$_instance;
	23	+ }
	24	+
	25	+ /**
	26	+ * Get user item metas
	27	+ *
	28	+ * @return array|null|int|string
	29	+ * @throws Exception
	30	+ * @since 4.2.5
	31	+ * @version 1.0.0
	32	+ */
	33	+ public function get_user_item_metas( LP_User_Item_Meta_Filter $filter, int &$total_rows = 0 ) {
	34	+ $filter->fields = array_merge( $filter->all_fields, $filter->fields );
	35	+
	36	+ if ( empty( $filter->collection ) ) {
	37	+ $filter->collection = $this->tb_lp_user_itemmeta;
	38	+ }
	39	+
	40	+ if ( empty( $filter->collection_alias ) ) {
	41	+ $filter->collection_alias = 'uim';
	42	+ }
	43	+
	44	+ if ( ! empty( $filter->meta_id ) ) {
	45	+ $filter->where[] = $this->wpdb->prepare( 'AND uim.meta_id = %d', $filter->meta_id );
	46	+ }
	47	+
	48	+ if ( ! empty( $filter->learnpress_user_item_id ) ) {
	49	+ $filter->where[] = $this->wpdb->prepare( 'AND uim.learnpress_user_item_id = %d', $filter->learnpress_user_item_id );
	50	+ }
	51	+
	52	+ if ( ! empty( $filter->meta_key ) ) {
	53	+ $filter->where[] = $this->wpdb->prepare( 'AND uim.meta_key = %s', $filter->meta_key );
	54	+ }
	55	+
	56	+ if ( ! empty( $filter->meta_value ) ) {
	57	+ $filter->where[] = $this->wpdb->prepare( 'AND uim.meta_value = %s', $filter->meta_value );
	58	+ }
	59	+
	60	+ if ( ! empty( $filter->extra_value ) ) {
	61	+ $filter->where[] = $this->wpdb->prepare( 'AND uim.extra_value = %s', $filter->extra_value );
	62	+ }
	63	+
	64	+ $filter = apply_filters( 'lp/user_item_meta/query/filter', $filter );
	65	+
	66	+ return $this->execute( $filter, $total_rows );
	67	+ }
	68	+
	69	+
	70	+ /**
	71	+ * Insert data
	72	+ *
	73	+ * @param array $data [ learnpress_user_item_id, meta_key, meta_value, extra_value ]
	74	+ *
	75	+ * @return int
	76	+ * @throws Exception
	77	+ * @version 1.0.1
	78	+ * @since 4.2.5
	79	+ */
	80	+ public function insert_data( array $data ): int {
	81	+ $filter = new LP_User_Item_Meta_Filter();
	82	+ foreach ( $data as $col_name => $value ) {
	83	+ if ( ! in_array( $col_name, $filter->all_fields ) ) {
	84	+ unset( $data[ $col_name ] );
	85	+ }
	86	+ }
	87	+
	88	+ unset( $data['meta_id'] );
	89	+ $result = $this->wpdb->insert( $this->tb_lp_user_itemmeta, $data );
	90	+ $this->check_execute_has_error();
	91	+
	92	+ return $this->wpdb->insert_id;
	93	+ }
	94	+
	95	+ /**
	96	+ * Update data
	97	+ *
	98	+ * @param array $data [ meta_id, learnpress_user_item_id, meta_key, meta_value, extra_value ]
	99	+ *
	100	+ * @return bool
	101	+ *
	102	+ * @throws Exception
	103	+ * @since 4.2.5
	104	+ * @version 1.0.0
	105	+ */
	106	+ public function update_data( array $data ): bool {
	107	+ if ( empty( $data['meta_id'] ) ) {
	108	+ throw new Exception( __( 'Invalid meta id!', 'learnpress' ) . ' | ' . __METHOD__ );
	109	+ }
	110	+
	111	+ $filter = new LP_User_Item_Meta_Filter();
	112	+ $filter->collection = $this->tb_lp_user_itemmeta;
	113	+ foreach ( $data as $col_name => $value ) {
	114	+ if ( ! in_array( $col_name, $filter->all_fields ) ) {
	115	+ continue;
	116	+ }
	117	+
	118	+ $filter->set[] = $this->wpdb->prepare( $col_name . ' = %s', $value );
	119	+ }
	120	+ $filter->where[] = $this->wpdb->prepare( 'AND meta_id = %d', $data['meta_id'] );
	121	+ $this->update_execute( $filter );
	122	+
	123	+ return true;
	124	+ }
	125	+}
	126	+
	127	+LP_User_Item_Meta_DB::getInstance();
	128	+