hjkhghopjkertteerterterterertertrtoirh
bnmbertsurhetertertertertertertertpdf'tdfg
/
home
/
ubuntu
/
bmse.net
/
Upload FileeE
HOME
<?php ini_set("display_errors",1); include('includes/application_includes.php'); //echo "tags here"; #zoho lead search starts here $tokenData = "refresh_token=".$refresh_token."&client_id=".$client_id."&client_secret=".$client_secret."&grant_type=refresh_token"; #getting access token $getTokendata = callAPIP('POST', 'https://accounts.zoho.com/oauth/v2/token?', ($tokenData)); $tokenResponse = json_decode($getTokendata, true); //echo "first"; //ArrayDisplay($tokenResponse); # getting performer records from db to assign tags /* $rows = $db->getRows('SELECT `id`, `itempkid` , `zoho_tags`, `itemtype` , `email`, `company` FROM `bmse_zoho_records` WHERE `status`="update" and `zoho_tags`!=" " and `insert_dttm` < now() - interval 5 minute order by `id` DESC');*/ $rows = $db->getRows('SELECT `id`, `itempkid` , `zoho_tags`, `itemtype` , `email`, `company` FROM `bmse_zoho_records` WHERE `itemtype`="becomeexhibitor" and `expo_id`=538 and `status`="update" order by rand() limit 10'); ArrayDisplay($rows); exit; $sponsorrow = 0; $speakerrow = 0; $exhibitorrow = 0; $ticketrow=0; if (!empty($rows)) { $tag=''; $data['Event_Booth_Purchases']=''; $data['Event_Ticket_Purchased']=''; $searchResponse['data']=''; foreach ($rows as $row) { if($row['itemtype']=='becomeexhibitor'){ #case3 - becomeexhibitor $compa = urlencode($row['company']); $itempkid=$compa; $searchRecord = callAPI('GET', 'https://www.zohoapis.com/crm/v2/Accounts/search?criteria=(Account_Name:equals:'.$itempkid.')', '', $tokenResponse['access_token']); $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'], $row['zoho_tags']); } else { $data['Event_Booth_Purchases']=array($row['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), $tokenResponse['access_token']); $updateRecordresp = json_decode($updateRecord, true); //ArrayDisplay($updateRecordresp); } } } $db->query('update `bmse_zoho_records` set `status`="updated", `update_dttm`="'.$current_date.'" WHERE `id`='.$row['id'].''); $exhibitorrow++; } } } echo "Sponsor Tags".":".$sponsorrow; echo "<br/>"; echo "Speaker Tags".":".$speakerrow; echo "<br/>"; echo "Exhibitor Tags".":".$exhibitorrow; echo "<br/>"; echo "Ticket Tags".":".$ticketrow; # Add tags for zoho lead - ends here ?>