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

		@@ -7,88 +7,87 @@
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=$entry_id AND form_id=$form_id order By created_at DESC";
20	18
21		- $logs = $this->execute($sql)->getResult();
22		- $response = ['success' => true, 'data' => [], 'integrations' => []];
23		- $ids = [];
24		- foreach ($logs as $log) {
25		- $ids[] = $log->id;
	19	+ $logs = $this->execute($sql)->getResult();
	20	+ $response = ['success' => true, 'data' => [], 'integrations' => []];
	21	+ $ids = [];
	22	+ foreach ($logs as $log) {
	23	+ $ids[] = $log->id;
	24	+ }
	25	+ if (isset($logs->errors['result_empty'])) {
	26	+ wp_send_json($response);
	27	+ } else {
	28	+ $allLogId = preg_replace('/"/', '', implode(',', $ids));
	29	+ $sql2 = "SELECT * FROM `{$this->app_db->prefix}bitforms_form_log_details` WHERE `log_id` IN ($allLogId)";
	30	+ $integrations = $this->execute($sql2)->getResult();
	31	+ foreach ($logs as $key => $log) {
	32	+ foreach ($integrations as $integration) {
	33	+ if ($integration->log_id === $log->id) {
	34	+ $logs[$key]->integration = true;
	35	+ }
26	36	}
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		- }
39		- }
40		- if (isset($integrations->errors['result_empty'])) {
41		- $integrations = [];
42		- }
43		- wp_send_json(['success' => true, 'data' => $logs, 'integrations' => $integrations]);
44		- }
	37	+ }
	38	+ if (isset($integrations->errors['result_empty'])) {
	39	+ $integrations = [];
	40	+ }
	41	+ wp_send_json(['success' => true, 'data' => $logs, 'integrations' => $integrations]);
45	42	}
	43	+ }
46	44
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";
	45	+ public function entryLogCheck($entry_id, $integ_id)
	46	+ {
	47	+ if (is_null($entry_id)) {
	48	+ return new WP_Error('empty_data', __('Form data is empty', 'bit-form'));
	49	+ }
	50	+ $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	51
54		- return $this->app_db->get_results($sql);
	52	+ return $this->app_db->get_results($sql);
	53	+ }
	54	+
	55	+ public function form_log_insert($data = [])
	56	+ {
	57	+ if (is_null($data)) {
	58	+ return new WP_Error('empty_data', __('Form data is empty', 'bit-form'));
55	59	}
	60	+ $result = $this->app_db->insert(
	61	+ "{$this->app_db->prefix}bitforms_form_entry_log",
	62	+ $data
	63	+ );
	64	+ return $this->getResult($result);
	65	+ }
56	66
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);
	67	+ public function log_history_insert($data = [])
	68	+ {
	69	+ if (is_null($data)) {
	70	+ return new WP_Error('empty_data', __('Form data is empty', 'bit-form'));
67	71	}
	72	+ $result = $this->app_db->insert(
	73	+ "{$this->app_db->prefix}bitforms_form_log_details",
	74	+ $data
	75	+ );
	76	+ return $this->getResult($result);
	77	+ }
68	78
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		- }
	79	+ public function get_form_value($form_id = '')
	80	+ {
	81	+ $sql = "SELECT `meta_key`,`meta_value` FROM `{$this->app_db->prefix}bitforms_form_entrymeta` where bitforms_form_entry_id=$form_id";
	82	+ return $this->execute($sql)->getResult();
	83	+ }
80	84
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	+ public function logUpdate($updateValue, $logID)
	86	+ {
	87	+ if (empty($logID)) {
	88	+ return false;
85	89	}
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		- }
	90	+ $sql = "UPDATE `{$this->app_db->prefix}bitforms_form_entry_log` SET content='$updateValue' WHERE id=$logID";
	91	+ return $this->execute($sql)->getResult();
	92	+ }
94	93	}