learnpress / inc / Databases / class-lp-user-item-meta-db.php

class-lp-user-item-meta-db.php in LearnPress – WordPress LMS Plugin for Create and Sell Online Courses 4.4.2, at inc/Databases/class-lp-user-item-meta-db.php

129 lines 3.1 KB

Raw Download Zip

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
129