PHP Decode

<?php 
 
require 'vendor/autoload.php'; 
 
// 
$dbc = mysqli_connect('127.0.0.1','root','St000123','crm') or die(''); 
 
//**** id 
function qufen($mokuai,$map){ 
	#$mokuai   
	#$map  
	foreach ($map as $key => $value) { 
		if ($value instanceof ZCRMRecord){ 
			if($key==$mokuai){ 
				return $value->getEntityId(); 
			} 
		} 
	} 
 
} 
//**** id end 
// 
ZCRMRestClient::initialize(); 
/* 
$oAuthClient = ZohoOAuth::getClientInstance(); 
$grantToken = "1000.56dff510b8740dc5f6e0d96c81a027ef.cf3a2fdb3ebdf25179de75cbd7901a96"; 
$oAuthTokens = $oAuthClient->generateAccessToken($grantToken); 
*/ 
/* 
// 
$oAuthClient = ZohoOAuth::getClientInstance(); 
$refreshToken = "1000.8c6a3de25eb5bf053849975646098ae6.66bba115631fad61dfe5c31744ee42ea"; 
$userIdentifier = "[email protected]"; 
$oAuthTokens = $oAuthClient->generateAccessTokenFromRefreshToken($refreshToken,$userIdentifier); 
*/ 
 
 
// 
$today = date('Ymd'); 
// 
$yesday = date('Ymd',strtotime("-1 day")); 
$tom = date('Ymd',strtotime("-2 day")); 
 
// 
// 
$x=0; 
 
$moduleIns = ZCRMRestClient::getInstance()->getModuleInstance("Potentials"); // To get module instance 
//$criteria="((khrmbye:starts_with:-0) or (khrmbye:starts_with:-1) or (khrmbye:starts_with:-2) or (khrmbye:starts_with:-3) or (khrmbye:starts_with:-4) or (khrmbye:starts_with:-5) or (khrmbye:starts_with:-6) or (khrmbye:starts_with:-7) or (khrmbye:starts_with:-8) or (khrmbye:starts_with:-9))";//criteria to search for 
 
$criteria="(khlc:equals:-) AND (dh:starts_with:202005)";//criteria to search for 
$criteria="((last_order_time:starts_with:$today) or (last_order_time:starts_with:$yesday) or (last_order_time:starts_with:$tom))and (khlc:equals:-)"; 
 
$criteria="(last_order_time:starts_with:2020)"; 
$page=1;//page number 
$perPage=200;//records per page 
$response = $moduleIns->searchRecordsByCriteria($criteria, $page, $perPage); // To get module records//string $searchWord word to be searched//number $page to get the list of records from the respective pages. Default value for page is 1.//number $perPage To get the list of records available per page. Default value for per page is 200. 
$records = $response->getData(); // To get response data 
 
//print_R($records); 
$nums = count($records); 
//echo $nums; 
 
do { 
	$response = $moduleIns->searchRecordsByCriteria($criteria, $page, $perPage); // To get module records//string $searchWord word to be searched//number $page to get the list of records from the respective pages. Default value for page is 1.//number $perPage To get the list of records available per page. Default value for per page is 200. 
	$records = $response->getData(); // To get response data 
	$nums = count($records); 
	 
	echo $page; echo '<br>'; 
	echo $nums; echo '<br>'; 
	 
	$page=$page+1;//page number 
	 
	foreach($records as $record){ 
		$x=$x+1; 
		echo $entityId=$record->getEntityId(); echo '<br>'; 
		echo $Deal_Name=$record->getFieldValue('Deal_Name');echo '<br>'; 
		echo $ptdlm=$record->getFieldValue('ptdlm');echo '<br>'; 
		echo $zhlx=$record->getFieldValue('zhlx');echo '<br>'; 
		echo $password=$record->getFieldValue('password');echo '<br>'; 
		echo $field2=$record->getFieldValue('field2');echo '<br>'; 
		echo $zsj=$record->getFieldValue('zsj');echo '<br>'; 
		echo $bdsj=$record->getFieldValue('bdsj');echo '<br>'; 
		echo $khyyzz=$record->getFieldValue('khyyzz');echo '<br>'; 
		echo $gydf=$record->getFieldValue('gydf');echo '<br>'; 
		echo $zhye=$record->getFieldValue('zhye');echo '<br>'; 
	//	echo $sseddk=$record->getFieldValue('sseddk');echo '<br>'; 
		$map = $record->getData(); // To get record data as map 
		echo "".$eddk_id=qufen('sseddk',$map);echo '<br>'; 
		echo 'gys'.$gys_id=qufen('gys',$map); echo '<br>'; 
		echo 'kh'.$kh_id=qufen('Account_Name',$map); echo '<br>'; 
		echo 'ssghxy'.$shxy_id=qufen('ssghxy',$map); echo '<br>'; 
 
		echo $khym=$record->getFieldValue('khym');echo '<br>'; 
		echo $jxym=$record->getFieldValue('jxym');echo '<br>'; 
		echo $ymdqsj=$record->getFieldValue('ymdqsj');echo '<br>'; 
		echo $qzjxip=$record->getFieldValue('qzjxip');echo '<br>'; 
		echo $sjtgwz=$record->getFieldValue('sjtgwz');echo '<br>'; 
		echo $sfxh=$record->getFieldValue('sfxh');echo '<br>'; 
		echo $hy=$record->getFieldValue('hy');echo '<br>'; 
		echo $tgcp=$record->getFieldValue('tgcp');echo '<br>'; 
		echo $khlc=$record->getFieldValue('khlc');echo '<br>'; 
		echo $zhzt=$record->getFieldValue('zhzt');echo '<br>'; 
		echo $ggpt=$record->getFieldValue('ggpt');echo '<br>'; 
		echo $ssmjz=$record->getFieldValue('ssmjz');echo '<br>'; 
		echo $cehz=$record->getFieldValue('cehz');echo '<br>'; 
		echo $Modified_By=$record->getFieldValue('Modified_By');echo '<br>'; 
		echo $Created_By=$record->getFieldValue('Created_By');echo '<br>'; 
		echo $ddsl=$record->getFieldValue('ddsl');echo '<br>'; 
		echo $yx=$record->getFieldValue('yx');echo '<br>'; 
		 
		 
		// 
		$Owner = $record->getOwner();echo '<br>'; 
		// 
		echo $Owner_id=$Owner->getId(); echo '<br>'; 
		//ID 
		echo $Owner_name=$Owner->getName();echo '<br>'; // To get user_id who created the record 
		echo $CreatedTime=$record->getCreatedTime();echo '<br>'; // To get record created time 
		echo $ModifiedTime=$record->getModifiedTime();echo '<br>'; // To get record modified time 
	  if(empty($sfxh)){ 
	  	$sfxh=0; 
	  } 
	  if(empty($zhye)){ 
	  	$zhye=0; 
	  } 
	  if(empty($yx)){ 
	  	$yx=0; 
	  } 
	  if(empty($cehz)){ 
	  	$cehz=0; 
	  } 
	  if(empty($ddsl)){ 
	  	$ddsl=0; 
	  } 
	  if(empty($eddk_id)) 
	  	{$eddk_id=0;  
	  	 } 
if(empty($gys_id)) 
	{$gys_id=0;  
	 } 
if(empty($kh_id)) 
	{$kh_id=0;  
	} 
if(empty($shxy_id)) 
	{$shxy_id=0;  
	 } 
 
	   $sql = "INSERT IGNORE INTO `potentials`(`pid`,`zhmc`,`ptdlmc`,`zhlx`,`zhsyz`,`zhsyzid`,`password`,`dlpassword`,`zsj`,`bdsj`,`khyyzz`,`gydf`,`zhye`,`szseddk`,`szseddkid`,`khym`,`jxxym`,`ymdqjsj`,`qzjxxip`,`sjtgwz`,`sfxh`,`hy`,`tgcp`,`khlc`,`zhzt`,`ggpt`,`khmc`,`khid`,`ssmjz`,`gys`,`gysid`,`ssghxy`,`ssghxyid`,`cehz`,`xgz`,`cjz`,`ddsl`,`yxf`,`creat_time`,`modify_time`)value(".$entityId.",'".$Deal_Name."','".$ptdlm."','".$zhlx."','".$Owner_name."',".$Owner_id.",'".$password."','".$field2."','".$zsj."','".$bdsj."','".$khyyzz."','".$gydf."',".$zhye.",'".$sseddk."',".$eddk_id.",'".$khym."','".$jxym."','".$ymdqsj."','".$qzjxip."','".$sjtgwz."',".$sfxh.",'".$hy."','".$tgcp."','".$khlc."','".$zhzt."','".$ggpt."','".$Account_Name."',".$kh_id.",'".$ssmjz."','".$gys."',".$gys_id.",'".$ssghxy."',".$shxy_id.",".$cehz.",'".$Modified_By."','".$Created_By."',".$ddsl.",".$yx.",'".$CreatedTime."','".$ModifiedTime."') ON DUPLICATE KEY UPDATE  `zhmc`='".$Deal_Name."',`ptdlmc`='".$ptdlm."',`zhlx`='".$zhlx."',`zhsyz`='".$Owner_name."',`zhsyzid`=".$Owner_id.",`password`='".$password."',`dlpassword`='".$field2."',`zsj`='".$zsj."',`bdsj`='".$bdsj."',`khyyzz`='".$khyyzz."',`gydf`='".$gydf."',`zhye`=".$zhye.",`szseddk`='".$sseddk."',`szseddkid`=".$eddk_id.",`khym`='".$khym."',`jxxym`='".$jxym."',`ymdqjsj`='".$ymdqsj."',`qzjxxip`='".$qzjxip."',`sjtgwz`='".$sjtgwz."',`sfxh`=".$sfxh.",`hy`='".$hy."',`tgcp`='".$tgcp."',`khlc`='".$khlc."',`zhzt`='".$zhzt."',`ggpt`='".$ggpt."',`khmc`='".$Account_Name."',`khid`=".$kh_id.",`ssmjz`='".$ssmjz."',`gys`='".$gys."',`gysid`=".$gys_id.",`ssghxy`='".$ssghxy."',`ssghxyid`=".$shxy_id.",`cehz`=".$cehz.",`xgz`='".$Modified_By."',`cjz`='".$Created_By."',`ddsl`=".$ddsl.",`yxf`=".$yx.",`creat_time`='".$CreatedTime."',`modify_time`='".$ModifiedTime."'"; 
 
	   echo $sql; 
 
		$date = mysqli_query($dbc,$sql) or die(''); 
		 
		echo '<b style="color:#ff0000;">'.$x.' </b>';echo '<br>'; 
	} 
 
} while ($nums==200); 
 
 
mysqli_close($dbc); 
 
$myfile = fopen("log/Potentials.log", "a+"); 
 
$txt = date('Ymd h:i:s')." 
"; 
 
fwrite($myfile, $txt); 
 
fclose($myfile); ?>