← All changes | includes/Core/Database/FormEntryLogModel.php +69 -68 1.4 → 2.21.4 View file →

		@@ -7,88 +7,89 @@
7	7	/**
8	8	* Undocumented class
9	9	*/
10	10
11		-use BitCode\BitForm\Core\Database\Model;
12		-
13	11	class FormEntryLogModel extends Model
14	12	{
15		- protected static $table = 'bitforms_form_log_details';
	13	+ protected static $table = 'bitforms_form_log_details';
16	14
17		- public function geLogHistory($form_id, $entry_id)
18		- {
19		- $sql = "SELECT * FROM `{$this->app_db->prefix}bitforms_form_entry_log` where form_entry_id=$entry_id AND form_id=$form_id order By created_at DESC";
	15	+ public function geLogHistory($form_id, $entry_id)
	16	+ {
	17	+ $sql = "SELECT * FROM `{$this->app_db->prefix}bitforms_form_entry_log` where form_entry_id=%d AND form_id=%d order By created_at DESC";
	18	+ $logs = $this->execute($sql, [$entry_id, $form_id])->getResult();
	19	+ $response = ['success' => true, 'data' => [], 'integrations' => []];
	20	+ $ids = [];
	21	+ foreach ($logs as $log) {
	22	+ $ids[] = (int) $log->id;
	23	+ }
	24	+ if (isset($logs->errors['result_empty'])) {
	25	+ wp_send_json($response);
	26	+ } else {
	27	+ $allLogId = preg_replace('/"/', '', implode(',', $ids));
	28	+ $sql2 = "SELECT * FROM `{$this->app_db->prefix}bitforms_form_log_details` WHERE `log_id` IN ($allLogId)";
	29	+ $integrations = $this->execute($sql2)->getResult();
20	30
21		- $logs = $this->execute($sql)->getResult();
22		- $response = ['success' => true, 'data' => [], 'integrations' => []];
23		- $ids = [];
24		- foreach ($logs as $log) {
25		- $ids[] = $log->id;
26		- }
27		- if (isset($logs->errors['result_empty'])) {
28		- wp_send_json($response);
29		- } else {
30		- $allLogId = preg_replace('/"/', '', implode(',', $ids));
31		- $sql2 = "SELECT * FROM `{$this->app_db->prefix}bitforms_form_log_details` WHERE `log_id` IN ($allLogId)";
32		- $integrations = $this->execute($sql2)->getResult();
33		- foreach ($logs as $key => $log) {
34		- foreach ($integrations as $integration) {
35		- if ($integration->log_id == $log->id) {
36		- $logs[$key]->integration = true;
37		- }
38		- }
	31	+ if (isset($integrations->errors['result_empty'])) {
	32	+ $integrations = [];
	33	+ } else {
	34	+ foreach ($logs as $key => $log) {
	35	+ foreach ($integrations as $integration) {
	36	+ if ($integration->log_id === $log->id) {
	37	+ $logs[$key]->integration = true;
39	38	}
40		- if (isset($integrations->errors['result_empty'])) {
41		- $integrations = [];
42		- }
43		- wp_send_json(['success' => true, 'data' => $logs, 'integrations' => $integrations]);
	39	+ }
44	40	}
	41	+ }
	42	+
	43	+ wp_send_json(['success' => true, 'data' => $logs, 'integrations' => $integrations]);
45	44	}
	45	+ }
46	46
47		- public function entryLogCheck($entry_id, $integ_id)
48		- {
49		- if (is_null($entry_id)) {
50		- return new WP_Error('empty_data', __('Form data is empty', 'bitform'));
51		- }
52		- $sql = "SELECT api_type, response_obj FROM `{$this->app_db->prefix}bitforms_form_entry_log` as el JOIN `{$this->app_db->prefix}bitforms_form_log_details` as ld ON ld.log_id = el.id WHERE form_entry_id = {$entry_id} AND integration_id = {$integ_id} AND ld.response_type = 'success' ORDER BY el.id DESC LIMIT 1";
	47	+ public function entryLogCheck($entry_id, $integ_id)
	48	+ {
	49	+ if (is_null($entry_id)) {
	50	+ return new WP_Error('empty_data', __('Form data is empty', 'bit-form'));
	51	+ }
	52	+ $sql = "SELECT api_type, response_obj FROM `{$this->app_db->prefix}bitforms_form_entry_log` as el JOIN `{$this->app_db->prefix}bitforms_form_log_details` as ld ON ld.log_id = el.id WHERE form_entry_id = {$entry_id} AND integration_id = {$integ_id} AND ld.response_type = 'success' ORDER BY el.id DESC LIMIT 1";
53	53
54		- return $this->app_db->get_results($sql);
	54	+ return $this->app_db->get_results($sql);
	55	+ }
	56	+
	57	+ public function form_log_insert($data = [])
	58	+ {
	59	+ if (is_null($data)) {
	60	+ return new WP_Error('empty_data', __('Form data is empty', 'bit-form'));
55	61	}
	62	+ $result = $this->app_db->insert(
	63	+ "{$this->app_db->prefix}bitforms_form_entry_log",
	64	+ $data
	65	+ );
	66	+ return $this->getResult($result);
	67	+ }
56	68
57		- public function form_log_insert($data = array())
58		- {
59		- if (is_null($data)) {
60		- return new WP_Error('empty_data', __('Form data is empty', 'bitform'));
61		- }
62		- $result = $this->app_db->insert(
63		- "{$this->app_db->prefix}bitforms_form_entry_log",
64		- $data
65		- );
66		- return $this->getResult($result);
	69	+ public function log_history_insert($data = [])
	70	+ {
	71	+ if (is_null($data)) {
	72	+ return new WP_Error('empty_data', __('Form data is empty', 'bit-form'));
67	73	}
	74	+ $result = $this->app_db->insert(
	75	+ "{$this->app_db->prefix}bitforms_form_log_details",
	76	+ $data
	77	+ );
	78	+ return $this->getResult($result);
	79	+ }
68	80
69		- public function log_history_insert($data = array())
70		- {
71		- if (is_null($data)) {
72		- return new WP_Error('empty_data', __('Form data is empty', 'bitform'));
73		- }
74		- $result = $this->app_db->insert(
75		- "{$this->app_db->prefix}bitforms_form_log_details",
76		- $data
77		- );
78		- return $this->getResult($result);
79		- }
	81	+ public function get_form_value($form_id = '')
	82	+ {
	83	+ $sql = "SELECT `meta_key`,`meta_value` FROM `{$this->app_db->prefix}bitforms_form_entrymeta` where bitforms_form_entry_id=$form_id";
	84	+ return $this->execute($sql)->getResult();
	85	+ }
80	86
81		- public function get_form_value($form_id = "")
82		- {
83		- $sql = "SELECT `meta_key`,`meta_value` FROM `{$this->app_db->prefix}bitforms_form_entrymeta` where bitforms_form_entry_id=$form_id";
84		- return $this->execute($sql)->getResult();
	87	+ public function logUpdate($updateValue, $logID)
	88	+ {
	89	+ if (empty($logID)) {
	90	+ return false;
85	91	}
86		- public function logUpdate($updateValue, $logID)
87		- {
88		- if (empty($logID)) {
89		- return false;
90		- }
91		- $sql = "UPDATE `{$this->app_db->prefix}bitforms_form_entry_log` SET content='$updateValue' WHERE id=$logID";
92		- return $this->execute($sql)->getResult();
93		- }
	92	+ $sql = "UPDATE `{$this->app_db->prefix}bitforms_form_entry_log` SET content='$updateValue' WHERE id=$logID";
	93	+ return $this->execute($sql)->getResult();
	94	+ }
94	95	}