bit-form / includes / Core / Database / FormEntryLogModel.php

FormEntryLogModel.php in Bit Form – Contact Form, Payment Forms, Multi Step Forms, Calculator & Custom Form Builder 2.2.3, at includes/Core/Database/FormEntryLogModel.php

94 lines 3.0 KB

Raw Download Zip

1	<?php
2
3	namespace BitCode\BitForm\Core\Database;
4
5	use WP_Error;
6
7	/**
8	* Undocumented class
9	*/
10
11	class FormEntryLogModel extends Model
12	{
13	protected static $table = 'bitforms_form_log_details';
14
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";
18
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	}
36	}
37	}
38	if (isset($integrations->errors['result_empty'])) {
39	$integrations = [];
40	}
41	wp_send_json(['success' => true, 'data' => $logs, 'integrations' => $integrations]);
42	}
43	}
44
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";
51
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'));
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	}
66
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'));
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	}
78
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	}
84
85	public function logUpdate($updateValue, $logID)
86	{
87	if (empty($logID)) {
88	return false;
89	}
90	$sql = "UPDATE `{$this->app_db->prefix}bitforms_form_entry_log` SET content='$updateValue' WHERE id=$logID";
91	return $this->execute($sql)->getResult();
92	}
93	}
94