hjkhghopjkertteerterterterertertrtoirh
bnmbertsurhetertertertertertertertpdf'tdfg
/
home
/
ubuntu
/
bmse.net
/
Upload FileeE
HOME
<?php ini_set("display_errors",1); include('includes/application_includes.php'); $accessToken= '1000.32db58b567814b1d877fe73f8810fa8e.b91c8e83607429b34c4373c53f168597'; $recordCount = $db->getOne('SELECT count(*) FROM `bmse_zoho_ex_records` WHERE `itemtype`="becomeexhibitor" and `updated`="no"'); echo $recordCount; echo "<br/>"; #getRecords $records = $db->getRows('SELECT `id`, `itemtype`, `itempkid`, `zoho_tags`, `email`, `company` from `bmse_zoho_ex_records` WHERE `itemtype`="becomeexhibitor" and `updated`="no" order by `id` DESC limit 15'); /*$records = $db->getRows('SELECT `id`, `itemtype`, `itempkid`, `zoho_tags`, `email`, `company` from `bmse_zoho_ex_records` WHERE `id` in (68,95)'); */ ArrayDisplay($records); //exit; if (!empty($records)) { $data['Event_Booth_Purchases']=''; $searchResponse['data']=''; foreach ($records as $record) { echo $record['id']; echo "<br/>"; /*$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_ex_records` SET `updated`="yes" WHERE `id`='.$record['id'].''); } } ?>