hjkhghopjkertteerterterterertertrtoirh
bnmbertsurhetertertertertertertertpdf'tdfg
/
home
/
ubuntu
/
bmse.net
/
Upload FileeE
HOME
<?php ini_set("display_errors",1); include('includes/application_includes.php'); $accessToken= '1000.f67627d18fb716be47395f74e9124301.1cd4db5b08da1ef504eccc285bfde501'; $recordCount = $db->getOne('SELECT count(*) FROM `bmse_zoho_records` WHERE `itemtype`="becomeexhibitor" and `account_status`="update"'); echo $recordCount; #getRecords $records = $db->getRows('SELECT `id`, `itemtype`, `itempkid`, `zoho_tags`, `email`, `company` from `bmse_zoho_records` WHERE `itemtype`="becomeexhibitor" and `account_status`="update" order by `id` DESC limit 10'); /*$records = $db->getRows('SELECT `id`, `itemtype`, `itempkid`, `zoho_tags`, `email`, `company` from `bmse_zoho_records` WHERE `id` in (68,95)'); */ ArrayDisplay($records); //exit; if (!empty($records)) { $data['Event_Booth_Purchases']=''; $searchResponse['data']=''; foreach ($records as $record) { /*$comp=str_replace(" ","%20",$record['company']); $comp1=str_replace("&","%26",$comp); $comp2=str_replace("|","%7C",$comp1); $comp3=str_replace("-","%2D",$comp2);*/ $compa = urlencode($record['company']); $itempkid=$compa; echo 'https://www.zohoapis.com/crm/v2/Accounts/search?criteria=(Account_Name:equals:'.$itempkid.')'; $searchRecord = callAPI('GET', 'https://www.zohoapis.com/crm/v2/Accounts/search?criteria=(Account_Name:equals:'.$itempkid.')', '', $accessToken); $searchResponse = json_decode($searchRecord, true); echo "yes"; ArrayDisplay($searchResponse); //ArrayDisplay($searchResponse['data']); //$record_id=$searchResponse['data'][0]['id']; echo "hi"; // echo $record_id; if (!empty($searchResponse['data'])) { foreach($searchResponse['data'] as $data) { ArrayDisplay($data); if (!empty($data['Event_Booth_Purchases'])) { $record_idSports = array_push($data['Event_Booth_Purchases'], $record['zoho_tags']); } else { $data['Event_Booth_Purchases']=array($record['zoho_tags']); } echo $data['id']; echo "<br/>"; ArrayDisplay($data['Event_Booth_Purchases']); if ($data['id']) { $dataArray = array( "data" => array( array( "id" => $data['id'], "Event_Booth_Purchases" => $data['Event_Booth_Purchases'] )), "trigger" =>array( "approval" ) ); $updateRecord = callAPI('PUT', 'https://www.zohoapis.com/crm/v2/Accounts/'.$data['id'].'', json_encode($dataArray), $accessToken); $updateRecordresp = json_decode($updateRecord, true); //ArrayDisplay($updateRecordresp); } } } $db->query('UPDATE `bmse_zoho_records` SET `account_status`="updated" WHERE `id`='.$record['id'].''); } } ?>