bit-form / includes / Core / Integration / GoogleSheet / RecordApiHelper.php

RecordApiHelper.php in Bit Form – Contact Form, Payment Forms, Multi Step Forms, Calculator & Custom Form Builder 2.0, at includes/Core/Integration/GoogleSheet/RecordApiHelper.php

110 lines 3.9 KB

Raw Download Zip

1	<?php
2
3	/**
4	* ZohoRecruit Record Api
5	*
6	*/
7
8	namespace BitCode\BitForm\Core\Integration\GoogleSheet;
9
10	use BitCode\BitForm\Core\Database\FormEntryLogModel;
11	use BitCode\BitForm\Core\Util\ApiResponse as UtilApiResponse;
12	use BitCode\BitForm\Core\Util\HttpHelper;
13
14	/**
15	* Provide functionality for Record insert,upsert
16	*/
17	class RecordApiHelper {
18	private $_defaultHeader;
19
20	private $_integrationID;
21
22	private $_logID;
23
24	private $_logResponse;
25
26	private $_entryID;
27
28	public function __construct($tokenDetails, $integId, $logID, $entryID) {
29	$this->_defaultHeader['Authorization'] = "Bearer {$tokenDetails->access_token}";
30	$this->_defaultHeader['Content-Type'] = 'application/json';
31	$this->_integrationID = $integId;
32	$this->_logID = $logID;
33	$this->_logResponse = new UtilApiResponse();
34	$this->_entryID = $entryID;
35	}
36
37	public function insertRecord($spreadsheetsId, $worksheetName, $header, $headerRow, $data) {
38	$insertRecordEndpoint = "https://sheets.googleapis.com/v4/spreadsheets/{$spreadsheetsId}/values/{$worksheetName}!{$headerRow}:append?valueInputOption=USER_ENTERED";
39	return HttpHelper::post($insertRecordEndpoint, $data, $this->_defaultHeader);
40	}
41
42	public function updateRecord($spreadsheetId, $worksheetInfo, $data) {
43	$updateRecordEndpoint = "https://sheets.googleapis.com/v4/spreadsheets/{$spreadsheetId}/values/{$worksheetInfo}?valueInputOption=USER_ENTERED";
44	return HttpHelper::request($updateRecordEndpoint, 'put', $data, $this->_defaultHeader);
45	}
46
47	public function executeRecordApi($spreadsheetId, $worksheetName, $headerRow, $header, $actions, $defaultConf, $fieldValues, $fieldMap) {
48	$fieldData = [];
49	$allHeaders = $defaultConf->headers->{$spreadsheetId}->{$worksheetName}->{$headerRow};
50
51	foreach ($fieldMap as $fieldPair) {
52	if (!empty($fieldPair->googleSheetField)) {
53	if ('custom' === $fieldPair->formField && isset($fieldPair->customValue)) {
54	$fieldData[$fieldPair->googleSheetField] = $fieldPair->customValue;
55	} else {
56	$fieldData[$fieldPair->googleSheetField] = $fieldValues[$fieldPair->formField];
57	}
58	}
59	}
60
61	$values = [];
62
63	foreach ($allHeaders as $googleSheetHeader) {
64	if (!empty($fieldData[$googleSheetHeader])) {
65	if ('array' === gettype($fieldData[$googleSheetHeader])) {
66	$values[] = implode(', ', $fieldData[$googleSheetHeader]);
67	} else {
68	$values[] = $fieldData[$googleSheetHeader];
69	}
70	} else {
71	$values[] = '';
72	}
73	}
74
75	$data = [];
76	$data['range'] = "{$worksheetName}!$headerRow";
77	$data['majorDimension'] = "{$header}";
78	$data['values'][] = $values;
79
80	$model = new FormEntryLogModel();
81	$recordApiResponse = null;
82	if ($this->_entryID) {
83	$result = $model->entryLogCheck($this->_entryID, $this->_integrationID);
84	if (!count($result) \|\| isset($result->errors['result_empty'])) {
85	$recordApiResponse = $this->insertRecord($spreadsheetId, $worksheetName, $header, $headerRow, wp_json_encode($data));
86	$type = 'insert';
87	} else {
88	$result = json_decode($result[0]->response_obj);
89
90	if (isset($result->updates)) {
91	$worksheetInfo = $result->updates->updatedRange;
92	} else {
93	$worksheetInfo = $result->updatedRange;
94	}
95	$spreadsheetId = $result->spreadsheetId;
96	unset($data['range']);
97	$recordApiResponse = $this->updateRecord($spreadsheetId, $worksheetInfo, wp_json_encode($data));
98	$type = 'update';
99	}
100	if (isset($recordApiResponse->error)) {
101	$this->_logResponse->apiResponse($this->_logID, $this->_integrationID, ['type' => 'record', 'type_name' => $type], 'error', $recordApiResponse);
102	} else {
103	$this->_logResponse->apiResponse($this->_logID, $this->_integrationID, ['type' => 'record', 'type_name' => $type], 'success', $recordApiResponse);
104	}
105	}
106
107	return $recordApiResponse;
108	}
109	}
110