mailin / model / model-users.php

model-users.php in Brevo – Email, SMS, Web Push, Chat, and more. 3.1.95, at model/model-users.php

283 lines 8.0 KB

Raw Download Zip

1	<?php
2	/**
3	* Model class <i>SIB_Model_Users</i> represents account
4	*
5	* @package SIB_Model
6	*/
7	class SIB_Model_Users {
8
9	/**
10	* Tab table name
11	*/
12	const TABLE_NAME = 'sib_model_users';
13
14	/**
15	* Holds found campaign count
16	*
17	* @var $found_count
18	*/
19	static $found_count;
20
21	/**
22	* Holds all campaign count
23	*
24	* @var $all_count
25	*/
26	static $all_count;
27
28	/** Create Table */
29	public static function createTable() {
30	global $wpdb;
31	// create list table.
32	$creation_query =
33	'CREATE TABLE IF NOT EXISTS ' . $wpdb->prefix . self::TABLE_NAME . ' (
34	`id` int(20) NOT NULL AUTO_INCREMENT,
35	`email` varchar(255),
36	`code` varchar(100),
37	`listIDs` longtext,
38	`redirectUrl` varchar(255),
39	`info` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci,
40	`frmid` int(2),
41	`user_added_date` DATETIME NOT NULL,
42	PRIMARY KEY (`id`)
43	);';
44	require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
45	$wpdb->query($creation_query);
46	}
47
48	/**
49	* Remove table
50	*/
51	public static function removeTable() {
52	global $wpdb;
53	$query = 'DROP TABLE IF EXISTS ' . $wpdb->prefix . self::TABLE_NAME . ';';
54	$wpdb->query( $query ); // db call ok; no-cache ok.
55	}
56
57	/**
58	* Get data by id
59	*
60	* @param int $id - user id.
61	* @return bool\|mixed
62	*/
63	public static function get_data( $id ) {
64	global $wpdb;
65	$query = $wpdb->prepare("SELECT * from " . $wpdb->prefix . self::TABLE_NAME . " where id = %d",array(esc_sql($id)));
66	$results = $wpdb->get_results( $query, ARRAY_A ); // db call ok; no-cache ok.
67
68	if ( is_array( $results ) ) {
69	return $results[0];
70	} else {
71	return false;
72	}
73	}
74
75	/**
76	* Get data by code
77	*
78	* @param string $code - code.
79	* @return array\|bool\|null\|object\|void
80	*/
81	public static function get_data_by_code( $code ) {
82	global $wpdb;
83	$query = $wpdb->prepare("SELECT * from " . $wpdb->prefix . self::TABLE_NAME . " where code like %s",array(esc_sql($code)));
84	$results = $wpdb->get_row( $query,ARRAY_A ); // db call ok; no-cache ok.
85
86	if ( is_array( $results ) && count( $results ) > 0 ) {
87	return $results;
88	} else {
89	return false;
90	}
91	}
92
93	/**
94	* Get code by email.
95	*
96	* @param string $email - email.
97	* @param int $formID - form ID.
98	* @return array\|bool\|null\|object\|void
99	*/
100	public static function get_data_by_email( $email, $formID ) {
101	global $wpdb;
102	$query = $wpdb->prepare("SELECT * from " . $wpdb->prefix . self::TABLE_NAME . " where email = %s and frmid = %d",array(esc_sql($email),esc_sql($formID)));
103	$results = $wpdb->get_row( $query,ARRAY_A ); // db call ok; no-cache ok.
104
105	if ( is_array( $results ) && count( $results ) > 0 ) {
106	return $results;
107	} else {
108	return false;
109	}
110	}
111
112	/**
113	* Add record
114	*
115	* @param array $data - record data.
116	* @return null\|string
117	*/
118	public static function add_record( $data ) {
119	global $wpdb;
120
121	foreach ($data as $key => $value) {
122	if(!in_array($key, array("listIDs","info")))
123	$data[$key] = esc_sql($value);
124	}
125
126	$query = $wpdb->prepare('INSERT INTO ' . $wpdb->prefix . self::TABLE_NAME . ' (email,code,info,frmid,listIDs,redirectUrl,user_added_date) VALUES (%s, %s, %s, %d, %s, %s, %s) ',array( $data["email"], $data["code"], $data["info"], $data["frmid"], $data["listIDs"], $data["redirectUrl"], $data["user_added_date"] ));
127	$wpdb->query( $query ); // db call ok; no-cache ok.
128	$index = $wpdb->get_var( 'SELECT LAST_INSERT_ID();' ); // db call ok; no-cache ok.
129
130	return $index;
131	}
132
133	/**
134	* Check email exist
135	*
136	* @param string $email - email.
137	* @param string $id - id.
138	* @return bool
139	*/
140	public static function is_exist_same_email( $email, $id = '' ) {
141	global $wpdb;
142
143	$query = $wpdb->prepare("SELECT * from " . $wpdb->prefix . self::TABLE_NAME . " where email like %s",array(esc_sql($email)));
144	$results = $wpdb->get_results( $query, ARRAY_A ); // db call ok; no-cache ok.
145
146	if ( is_array( $results ) && (count( $results ) > 0) ) {
147	if ( '' === $id ) {
148	return true;
149	}
150	if ( isset( $results ) && is_array( $results ) ) {
151	foreach ( $results as $result ) {
152	if ( $result['id'] != $id ) {
153	return true;
154	}
155	}
156	}
157	}
158
159	return false;
160	}
161
162	/**
163	* Remove guest
164	*
165	* @param int $id - id.
166	*/
167	public static function remove_record( $id ) {
168	global $wpdb;
169
170	$query = $wpdb->prepare("DELETE from " . $wpdb->prefix . self::TABLE_NAME . " where id = %d",array(esc_sql($id)));
171	$wpdb->query( $query ); // db call ok; no-cache ok.
172	}
173
174	/**
175	* Get all guests by pagenum, per_page
176	*
177	* @param string $orderby - ORDER BY.
178	* @param string $order - sort order.
179	* @param int $pagenum - page number.
180	* @param int $per_page - count per page.
181	* @return array\|null\|object
182	*/
183	public static function get_all( $orderby = 'email', $order = 'asc', $pagenum = 1, $per_page = 15 ) {
184	global $wpdb;
185
186	$limit = ($pagenum - 1) * $per_page;
187	$query = 'SELECT * FROM ' . $wpdb->prefix . self::TABLE_NAME . ' ORDER BY %s %s LIMIT %d,%d';
188	$query = $wpdb->prepare($query,array(esc_sql($orderby), esc_sql($order), esc_sql($limit), esc_sql($per_page)));
189
190
191	$results = $wpdb->get_results( $query, ARRAY_A ); // db call ok; no-cache ok.
192	self::$found_count = self::get_count_element();
193
194	if ( ! is_array( $results ) ) {
195	$results = array();
196	return $results;
197	}
198
199	return $results;
200	}
201
202	/** Get all records of table */
203	public static function get_all_records() {
204	global $wpdb;
205
206	$query = $wpdb->prepare('select * from ' . $wpdb->prefix . self::TABLE_NAME . ' order by %s %s;', array("email","asc"));
207	$results = $wpdb->get_results( $query, ARRAY_A ); // db call ok; no-cache ok.
208
209	if ( ! is_array( $results ) ) {
210	$results = array();
211	return $results;
212	}
213
214	return $results;
215	}
216
217	/** Get count of row */
218	public static function get_count_element() {
219	global $wpdb;
220
221	$query = 'Select count(*) from ' . $wpdb->prefix . self::TABLE_NAME . ';';
222
223	$count = $wpdb->get_var( $query ); // db call ok; no-cache ok.
224
225	return $count;
226	}
227
228	/** Add prefix to the table */
229	public static function add_prefix() {
230	global $wpdb;
231	if ( $wpdb->get_var( "SHOW TABLES LIKE '" . self::TABLE_NAME . "'" ) == self::TABLE_NAME ) {
232	$query = 'ALTER TABLE ' . self::TABLE_NAME . ' RENAME TO ' . $wpdb->prefix . self::TABLE_NAME . ';';
233	$wpdb->query( $query ); // db call ok; no-cache ok.
234	}
235	}
236
237	/** Add column to the table */
238	public static function add_user_added_date_column() {
239	global $wpdb;
240	$user_added = 'user_added_date';
241	$result = $wpdb->query( $wpdb->prepare( 'SHOW COLUMNS FROM ' . $wpdb->prefix . self::TABLE_NAME . ' LIKE %s ', $user_added ) ); // db call ok; no-cache ok.
242
243	if ( empty( $result ) ) {
244	$query = 'ALTER TABLE ' . $wpdb->prefix . self::TABLE_NAME . ' ADD COLUMN user_added_date DATETIME NOT NULL';
245	$wpdb->query( $query );
246	}
247	}
248
249	/**
250	* add new column to the table which will reflect sent DOI flag
251	*/
252	public static function add_flag_doi_sent() {
253	global $wpdb;
254	$doi_sent = 'doi_sent';
255	$result = $wpdb->query( $wpdb->prepare( 'SHOW COLUMNS FROM ' . $wpdb->prefix . self::TABLE_NAME . ' LIKE %s ', $doi_sent ) ); // db call ok; no-cache ok.
256
257	if ( empty( $result ) ) {
258	$query = 'ALTER TABLE ' . $wpdb->prefix . self::TABLE_NAME . ' ADD COLUMN ' . $doi_sent . ' int(20) NOT NULL DEFAULT 0';
259	$wpdb->query( $query );
260	}
261	}
262
263	/** Update user data to the table */
264	public static function update_element( $data ) {
265	global $wpdb;
266	$query = $wpdb->prepare( 'update ' . $wpdb->prefix . self::TABLE_NAME . ' set info= %s where id= %d;', array( $data['info'], esc_sql( $data['id'] ) ) );
267	$wpdb->query( $query );
268
269	return true;
270	}
271
272	/**
273	* update to mark the DOI sent
274	*/
275	public static function make_doi_sent($email) {
276	global $wpdb;
277	$query = $wpdb->prepare('update ' . $wpdb->prefix . self::TABLE_NAME . ' set doi_sent= %d where email= %s;', array(esc_sql(1), esc_sql($email) ));
278	$wpdb->query($query);
279
280	return true;
281	}
282	}
283