<?php
require_once 'config.php';
error_reporting(E_ALL);
ini_set('display_errors', 1);
include 'dbconfig.php';
$loginurl = TOKEN_URL;

$params = "grant_type=password"
. "&client_id=" . CLIENT_ID
. "&client_secret=" . CLIENT_SECRET
. "&username=" . USERNAME
. "&password=" . PASSWORD;
$curl = curl_init($loginurl);
curl_setopt($curl, CURLOPT_HEADER, false);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
curl_setopt ($curl, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt ($curl, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($curl, CURLOPT_POST, true);
curl_setopt($curl, CURLOPT_POSTFIELDS, $params);

$json_response = curl_exec($curl);

$status = curl_getinfo($curl, CURLINFO_HTTP_CODE);

if ( $status != 200 ) {
    $txt = "Error: call to URL $url failed with status $status, response $json_response, curl_error " . curl_error($curl) . ", curl_errno " . curl_errno($curl);
    $LogFile = file_put_contents('log_'.date("Ymd").'.txt', $txt.PHP_EOL , FILE_APPEND);
    die;
}
$response = json_decode($json_response, true);
$access_token = $response['access_token'];
$instance_url = $response['instance_url'];

$ArrayLocation = array();
$ArrayUsername = array();
$ArrayPassword = array();
$ArrayCorporateCode = array();
$ArraySiteIdSiteCode = array();
$query = "SELECT Id,  Corporate_Sitelink_Username__c, Corporate_Sitelink_Password__c, Corporate_Code__c, Location_Code__c from Vendor__c WHERE Type__c = 'Management Account' LIMIT 1000";

$url = "$instance_url/services/data/v29.0/query?q=" . urlencode($query);
$curl = curl_init($url);
curl_setopt($curl, CURLOPT_HEADER, false);
curl_setopt ($curl, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt ($curl, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
curl_setopt($curl, CURLOPT_HTTPHEADER,
        array("Authorization: OAuth $access_token",
            "Content-type: application/json"));
$json_response = curl_exec($curl);
curl_close($curl);
$response = json_decode($json_response, true);

echo '<pre>';
print_r($response);

$count = 0;
foreach ((array) $response['records'] as $record) 
{
  if(isset($record['Corporate_Code__c']) && isset($record['Corporate_Sitelink_Username__c']) && isset($record['Location_Code__c']))
  { 
    if($record['Corporate_Sitelink_Username__c'] != "")
    {
      $ArrayLocation[$record['Location_Code__c']]  =   $record['Id'];
      $ArrayUsername[$record['Location_Code__c']] = $record['Corporate_Sitelink_Username__c'];
      $ArrayPassword[$record['Location_Code__c']] = $record['Corporate_Sitelink_Password__c'];
      $ArrayCorporateCode[$record['Location_Code__c']] = $record['Corporate_Code__c'];
      
        $CorpCode =  $record['Corporate_Code__c'];
        $LocaCode =  $record['Location_Code__c'];
    // if($record['Location_Code__c'] != 'L022'){continue;}  
        $LastPolled = "636451405780000000"; 
        $result = mysql_query("SELECT  LastPolled FROM unit_last_log WHERE CorpCode ='$CorpCode' and LocaCode = '$LocaCode' ");
       
        if( mysql_num_rows($result) > 0) {
          $value = mysql_fetch_object($result);
         $LastPolled =  $value->LastPolled;
         
        }

        $client = new SoapClient( "https://api.smdservers.net/CCWs_3.5/CallCenterWs.asmx?WSDL" );
        $params = new stdClass();
        $params->sCorpCode = $record['Corporate_Code__c'];
        $params->sLocationCode = $record['Location_Code__c'] ;
        $params->sCorpUserName = $record['Corporate_Sitelink_Username__c']  . ":::ACAPLLC4K398DJ39GK2H";
        $params->sCorpPassword = $record['Corporate_Sitelink_Password__c'];
      
        $params->lngLastTimePolled = $LastPolled;

        
        try
        {
            $UnitInfo = $client->UnitsInformation_v2( $params );
            $UnitInfoResult = $UnitInfo->UnitsInformation_v2Result->any;
        }
        catch (Exception $e ) {
            $txt = "Unit Information Sitelink Error: " . $e->getMessage();
            $LogFile = file_put_contents('log_'.date("Ymd").'.txt', $txt.PHP_EOL , FILE_APPEND); 
        }
        $xml = simplexml_load_string($UnitInfoResult);
        $json = json_encode($xml);
        $UnitInfoResultArray = json_decode($json,TRUE);
     
        
        $NewLastTimePolled = "";
        $url = "$instance_url/services/data/v29.0/sobjects/Unit__c/";
        var_dump($UnitInfoResultArray);    
        if(!isset($UnitInfoResultArray['NewDataSet']['Table']))
        {continue;}
        
        $UnitInfoArray = $UnitInfoResultArray['NewDataSet']['Table'];
        $LastTimePollArray = $UnitInfoResultArray['NewDataSet']['Table1'];
        $NewLastTimePolled =  $LastTimePollArray["lngLastTimePolled"];
        
        if( mysql_num_rows($result) > 0) 
        {
            if($NewLastTimePolled != "")
            {
              mysql_query("UPDATE unit_last_log SET LastPolled = '$NewLastTimePolled' WHERE CorpCode ='$CorpCode' and LocaCode = '$LocaCode' ");
            }
        }
        else
        {
            mysql_query("INSERT INTO unit_last_log (CorpCode, LocaCode, LastPolled) VALUES ('$CorpCode', '$LocaCode', '$NewLastTimePolled') ");
        }
        
        if($LastPolled == $NewLastTimePolled)
        {
          echo "Skip last polled at same time";
          continue;
        }
       
       foreach($UnitInfoArray as $UnitInfoKey=>$UnitInfoItem)
       {
          
          if(!isset($UnitInfoItem["UnitID"]))
          {continue;}
       
          $StoreId =   $record['Id'];
          $content = json_encode(array("Store__c" => $record['Id'],
          "Name" =>   $UnitInfoItem["sUnitName"], 
          "iADA__c" => isset($UnitInfoItem["iADA"]) ? $UnitInfoItem["iADA"] : "", 
          "bAlarm__c" =>  isset($UnitInfoItem["bAlarm"]) ? $UnitInfoItem["bAlarm"] : "", 
          "dcBoardRate__c" => isset($UnitInfoItem["dcBoardRate"]) ? $UnitInfoItem["dcBoardRate"] : "", 
          "bClimate__c" => isset($UnitInfoItem["bClimate"]) ? $UnitInfoItem["bClimate"] : "", 
          "bCorporate__c" =>   isset($UnitInfoItem["bCorporate"]) ? $UnitInfoItem["bCorporate"] : "", 
          "dMovedOut__c" => isset($UnitInfoItem["dMovedOut"]) ? $UnitInfoItem["dMovedOut"] : "", 
          "iDefLeaseNum__c" =>  isset($UnitInfoItem["iDefLeaseNum"]) ? $UnitInfoItem["iDefLeaseNum"] : "",
          "dDeleted__c" =>  isset($UnitInfoItem["dDeleted"]) ? $UnitInfoItem["dDeleted"] : "", 
          "iDoorType__c" =>  isset($UnitInfoItem["iDoorType"]) ? $UnitInfoItem["iDoorType"] : "",  
          "iEntryLoc__c" =>  isset($UnitInfoItem["iEntryLoc"]) ? $UnitInfoItem["iEntryLoc"] : "",
          "iFloor__c" =>  isset($UnitInfoItem["iFloor"]) ? $UnitInfoItem["iFloor"] : "",
          "bInside__c" =>  isset($UnitInfoItem["bInside"]) ? $UnitInfoItem["bInside"] : "",
          "dcLength__c" =>  isset($UnitInfoItem["dcLength"]) ? $UnitInfoItem["dcLength"] : "",
          "dcMapLeft__c" =>  $UnitInfoItem["dcMapLeft"],
          "bMapReversWL__c" =>  isset($UnitInfoItem["bPower"]) ? $UnitInfoItem["bPower"] : "",
          "dCreated__c" => date("Y-m-d") . "T00:00:00",
          //"dcMapTheta__c" =>  $UnitInfoItem["dcMapTheta"],
         "dcMapTop__c" =>  $UnitInfoItem["dcMapTop"],
          "bPower__c" =>  isset($UnitInfoItem["bPower"]) ? $UnitInfoItem["bPower"] : "",
          "dcPushRate__c" =>  isset($UnitInfoItem["dcPushRate"]) ? $UnitInfoItem["dcPushRate"] : "",
          "bRentable__c" =>  isset($UnitInfoItem["bRentable"]) ? $UnitInfoItem["bRentable"] : "",
          "bRented__c" =>  isset($UnitInfoItem["bRented"]) ? $UnitInfoItem["bRented"] : "",
          "dcStdRate__c" =>  isset($UnitInfoItem["dcStdRate"]) ? $UnitInfoItem["dcStdRate"] : "",
           "dcTax1Rate__c" =>  isset($UnitInfoItem["dcTax1Rate"]) ? $UnitInfoItem["dcTax1Rate"] : "",
           "dcTax2Rate__c" =>  isset($UnitInfoItem["dcTax2Rate"]) ? $UnitInfoItem["dcTax2Rate"] : "",
           "sTypeName__c" =>  isset($UnitInfoItem["sTypeName"]) ? $UnitInfoItem["sTypeName"] : "",
           "UnitID_Representative__c" =>  $UnitInfoItem["UnitID"],
           "sUnitDesc__c" =>   isset($UnitInfoItem["sUnitDesc"]) ? $UnitInfoItem["sUnitDesc"] : "",     
           "UnitTypeID__c" =>  isset($UnitInfoItem["UnitTypeID"]) ? $UnitInfoItem["UnitTypeID"] : "",
           "bWaitingListReserved__c" => isset($UnitInfoItem["bWaitingListReserved"]) ? $UnitInfoItem["bWaitingListReserved"] : "",
           "dcWidth__c" =>  $UnitInfoItem["dcWidth"],
           "sSize__c" =>  $UnitInfoItem["dcWidth"] . "X" . $UnitInfoItem["dcLength"]
              
          ));

          
          try
          {
          
             $UnitRecordId = GetUnitRecordId($UnitInfoItem["UnitID"], $access_token, $instance_url, $StoreId);
              if($UnitRecordId != "")
              {
                $url = "$instance_url/services/data/v29.0/sobjects/Unit__c/" . $UnitRecordId;
                
                $content = json_encode(array(
                "Name" =>   $UnitInfoItem["sUnitName"], 
                "iADA__c" => isset($UnitInfoItem["iADA"]) ? $UnitInfoItem["iADA"] : "", 
                "bAlarm__c" =>  isset($UnitInfoItem["bAlarm"]) ? $UnitInfoItem["bAlarm"] : "", 
                "dcBoardRate__c" => isset($UnitInfoItem["dcBoardRate"]) ? $UnitInfoItem["dcBoardRate"] : "", 
                "bClimate__c" => isset($UnitInfoItem["bClimate"]) ? $UnitInfoItem["bClimate"] : "", 
                "bCorporate__c" =>   isset($UnitInfoItem["bCorporate"]) ? $UnitInfoItem["bCorporate"] : "", 
                "dMovedOut__c" => isset($UnitInfoItem["dMovedOut"]) ? $UnitInfoItem["dMovedOut"] : "", 
                "iDefLeaseNum__c" =>  isset($UnitInfoItem["iDefLeaseNum"]) ? $UnitInfoItem["iDefLeaseNum"] : "",
                "dDeleted__c" =>  isset($UnitInfoItem["dDeleted"]) ? $UnitInfoItem["dDeleted"] : "", 
                "iDoorType__c" =>  isset($UnitInfoItem["iDoorType"]) ? $UnitInfoItem["iDoorType"] : "",  
                "iEntryLoc__c" =>  isset($UnitInfoItem["iEntryLoc"]) ? $UnitInfoItem["iEntryLoc"] : "",
                "iFloor__c" =>  isset($UnitInfoItem["iFloor"]) ? $UnitInfoItem["iFloor"] : "",
                "bInside__c" =>  isset($UnitInfoItem["bInside"]) ? $UnitInfoItem["bInside"] : "",
                "dcLength__c" =>  isset($UnitInfoItem["dcLength"]) ? $UnitInfoItem["dcLength"] : "",
                "dcMapLeft__c" =>  $UnitInfoItem["dcMapLeft"],
                "bMapReversWL__c" =>  isset($UnitInfoItem["bPower"]) ? $UnitInfoItem["bPower"] : "",
                //"dcMapTheta__c" =>  $UnitInfoItem["dcMapTheta"],
                "dcMapTop__c" =>  $UnitInfoItem["dcMapTop"],
                "bPower__c" =>  isset($UnitInfoItem["bPower"]) ? $UnitInfoItem["bPower"] : "",
                "dcPushRate__c" =>  isset($UnitInfoItem["dcPushRate"]) ? $UnitInfoItem["dcPushRate"] : "",
                "bRentable__c" =>  isset($UnitInfoItem["bRentable"]) ? $UnitInfoItem["bRentable"] : "",
                "bRented__c" =>  isset($UnitInfoItem["bRented"]) ? $UnitInfoItem["bRented"] : "",
                "dcStdRate__c" =>  isset($UnitInfoItem["dcStdRate"]) ? $UnitInfoItem["dcStdRate"] : "",
                 "dcTax1Rate__c" =>  isset($UnitInfoItem["dcTax1Rate"]) ? $UnitInfoItem["dcTax1Rate"] : "",
                 "dcTax2Rate__c" =>  isset($UnitInfoItem["dcTax2Rate"]) ? $UnitInfoItem["dcTax2Rate"] : "",
                 "sTypeName__c" =>  isset($UnitInfoItem["sTypeName"]) ? $UnitInfoItem["sTypeName"] : "",
                 "UnitID_Representative__c" =>  $UnitInfoItem["UnitID"],
                 "sUnitDesc__c" =>   isset($UnitInfoItem["sUnitDesc"]) ? $UnitInfoItem["sUnitDesc"] : "",     
                 "UnitTypeID__c" =>  isset($UnitInfoItem["UnitTypeID"]) ? $UnitInfoItem["UnitTypeID"] : "",
                 "bWaitingListReserved__c" => isset($UnitInfoItem["bWaitingListReserved"]) ? $UnitInfoItem["bWaitingListReserved"] : "",
                 "dcWidth__c" =>  $UnitInfoItem["dcWidth"],
                 "sSize__c" =>  $UnitInfoItem["dcWidth"] . "X" . $UnitInfoItem["dcLength"] 
                ));
              }
              $curl = curl_init($url);
              curl_setopt($curl, CURLOPT_HEADER, false);
              curl_setopt ($curl, CURLOPT_SSL_VERIFYPEER, 0);
              curl_setopt ($curl, CURLOPT_SSL_VERIFYHOST, 0);
              curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
              curl_setopt($curl, CURLOPT_HTTPHEADER,
                      array("Authorization: OAuth $access_token",
                          "Content-type: application/json"));
              if($UnitRecordId != "")
              {
                curl_setopt($curl, CURLOPT_CUSTOMREQUEST, "PATCH");
              }
              else
              {
              
                curl_setopt($curl, CURLOPT_POST, true);

              }
              curl_setopt($curl, CURLOPT_POSTFIELDS, $content);
                            
                      
             $json_response = curl_exec($curl);
          
              $status = curl_getinfo($curl, CURLINFO_HTTP_CODE);
          
              if ( $status != 201 ) {
                 $txt = "Error: call to URL $url failed with status $status, response $json_response, curl_error " . curl_error($curl) . ", curl_errno " . curl_errno($curl);
                  $LogFile = file_put_contents('log_'.date("Ymd").'.txt', $txt.PHP_EOL , FILE_APPEND);
                  
              }

              curl_close($curl);
          
              $response = json_decode($json_response, true);
var_dump($response);
              $UnitId = $response["id"];   

             // if($UnitRecordId == "")
              //{
               // UpdateTenantRateObject($UnitInfoItem["sUnitName"], $UnitId, $access_token, $instance_url, $StoreId);
               // UpdateVarianceObject($UnitInfoItem["sUnitName"], $UnitId, $access_token, $instance_url, $StoreId);
               // UpdateAuctionObject($UnitInfoItem["sUnitName"], $UnitId, $access_token, $instance_url, $StoreId);  
              //}
             
          }
          catch (Exception $e) 
          {
              $txt = "Unit Info Error: " . $e->getMessage();
               echo  $txt;
              $LogFile = file_put_contents('log_'.date("Ymd").'.txt', $txt.PHP_EOL , FILE_APPEND);
          }
          
           
           
        }
         $count++;

    }
  }
  
}

function GetTenantSFId($TenantId, $access_token, $instance_url, $StoreId)
{
  $query = "SELECT Id from Customer__c WHERE TenantID__c = " .  $TenantId  . " AND Store__c = '" . $StoreId . "'";
  $TenantSFId = "";  
  $GetUrl = "$instance_url/services/data/v29.0/query?q=" . urlencode($query);
  $TenantListCurl = curl_init($GetUrl);
  curl_setopt($TenantListCurl, CURLOPT_HEADER, false);
  curl_setopt ($TenantListCurl, CURLOPT_SSL_VERIFYPEER, 0);
  curl_setopt ($TenantListCurl, CURLOPT_SSL_VERIFYHOST, 0);
  curl_setopt($TenantListCurl, CURLOPT_RETURNTRANSFER, true);
  curl_setopt($TenantListCurl, CURLOPT_HTTPHEADER, array("Authorization: OAuth $access_token", "Content-type: application/json"));
  $JsonTenantListResponse = curl_exec($TenantListCurl);
  curl_close($TenantListCurl);
  $TenantResponseList = json_decode($JsonTenantListResponse, true);

  $ArrayTenantRate = (array) $TenantResponseList['records'];

   foreach($ArrayTenantRate as  $TenantRateKey=>$TenantRateItem)
   {

     $TenantSFId = $TenantRateItem["Id"];
  }
    return $TenantSFId;
}


function GetLeaseRecordId($UnitId, $TenantId, $access_token, $instance_url, $StoreId)
{
   $LeaseRecordId  = "";
   $query = "SELECT Id from Lease__c WHERE TenantID__c = " .  $TenantId  . " AND Unit__c = '"  .  $UnitId .  "' AND Store__c = '" . $StoreId . "'";
    
  $GetUrl = "$instance_url/services/data/v29.0/query?q=" . urlencode($query);
  $LeaseListCurl = curl_init($GetUrl);
  curl_setopt($LeaseListCurl, CURLOPT_HEADER, false);
  curl_setopt ($LeaseListCurl, CURLOPT_SSL_VERIFYPEER, 0);
  curl_setopt ($LeaseListCurl, CURLOPT_SSL_VERIFYHOST, 0);
  curl_setopt($LeaseListCurl, CURLOPT_RETURNTRANSFER, true);
  curl_setopt($LeaseListCurl, CURLOPT_HTTPHEADER, array("Authorization: OAuth $access_token", "Content-type: application/json"));
  $JsonUnitListResponse = curl_exec($LeaseListCurl);
  curl_close($LeaseListCurl);
  $LeaseResponseList = json_decode($JsonUnitListResponse, true);

  $ArrayLease = (array) $LeaseResponseList['records'];

   foreach($ArrayLease as  $LeaseKey=>$LeaseItem)
   {
        $LeaseRecordId =     $LeaseItem["Id"];
   }
   
   return $LeaseRecordId;
}

function GetUnitRecordId($UnitId, $access_token, $instance_url, $StoreId)
{
   $UnitRecordId  = "";
   $query = "SELECT Id from Unit__c WHERE UnitID_Representative__c = '" .  $UnitId  . "' AND Store__c = '" . $StoreId . "'";
     
  $GetUrl = "$instance_url/services/data/v29.0/query?q=" . urlencode($query);
  $UnitListCurl = curl_init($GetUrl);
  curl_setopt($UnitListCurl, CURLOPT_HEADER, false);
  curl_setopt ($UnitListCurl, CURLOPT_SSL_VERIFYPEER, 0);
  curl_setopt ($UnitListCurl, CURLOPT_SSL_VERIFYHOST, 0);
  curl_setopt($UnitListCurl, CURLOPT_RETURNTRANSFER, true);
  curl_setopt($UnitListCurl, CURLOPT_HTTPHEADER, array("Authorization: OAuth $access_token", "Content-type: application/json"));
  $JsonUnitListResponse = curl_exec($UnitListCurl);
  curl_close($UnitListCurl);
  $UnitResponseList = json_decode($JsonUnitListResponse, true);
  $ArrayUnitRate = (array) $UnitResponseList['records'];
//var_dump($UnitResponseList);
   foreach($ArrayUnitRate as  $UnitKey=>$UnitItem)
   {
        $UnitRecordId =     $UnitItem["Id"];
   }
   return $UnitRecordId;
}

function UpdateTenantRateObject($UnitName, $UnitId, $access_token, $instance_url, $StoreId)
{
  $query = "SELECT Id from Tenant_Rate_Management__c WHERE Unit__c = '" .  $UnitName  . "' AND Store__c = '" . $StoreId . "'";
    
  $GetUrl = "$instance_url/services/data/v29.0/query?q=" . urlencode($query);
  $TenantListCurl = curl_init($GetUrl);
  curl_setopt($TenantListCurl, CURLOPT_HEADER, false);
  curl_setopt ($TenantListCurl, CURLOPT_SSL_VERIFYPEER, 0);
  curl_setopt ($TenantListCurl, CURLOPT_SSL_VERIFYHOST, 0);
  curl_setopt($TenantListCurl, CURLOPT_RETURNTRANSFER, true);
  curl_setopt($TenantListCurl, CURLOPT_HTTPHEADER, array("Authorization: OAuth $access_token", "Content-type: application/json"));
  $JsonTenantListResponse = curl_exec($TenantListCurl);
  curl_close($TenantListCurl);
  $TenantResponseList = json_decode($JsonTenantListResponse, true);

  $ArrayTenantRate = (array) $TenantResponseList['records'];

   foreach($ArrayTenantRate as  $TenantRateKey=>$TenantRateItem)
   {

      $TenantUrl = "$instance_url/services/data/v29.0/sobjects/Tenant_Rate_Management__c/" . $TenantRateItem["Id"];
      
      $TenantCurl = curl_init($TenantUrl);
      curl_setopt($TenantCurl, CURLOPT_HEADER, false);
      curl_setopt ($TenantCurl, CURLOPT_SSL_VERIFYPEER, 0);
      curl_setopt ($TenantCurl, CURLOPT_SSL_VERIFYHOST, 0);
      curl_setopt($TenantCurl, CURLOPT_RETURNTRANSFER, true);
      curl_setopt($TenantCurl, CURLOPT_HTTPHEADER,
              array("Authorization: OAuth $access_token",
                  "Content-type: application/json"));
      curl_setopt($TenantCurl, CURLOPT_CUSTOMREQUEST, "PATCH");
      curl_setopt($TenantCurl, CURLOPT_POSTFIELDS, '{"sUnit__c" : "'.$UnitId.'"}');
      $TenantRateResponse = curl_exec($TenantCurl);

      curl_close($TenantCurl);
  }

}



function UpdateVarianceObject($UnitName, $UnitId, $access_token, $instance_url, $StoreId)
{
  $query = "SELECT Id from Rent_Scrub__c WHERE Unit__c = '" .  $UnitName  . "' AND Store__c = '" . $StoreId . "'";
    
  $GetUrl = "$instance_url/services/data/v29.0/query?q=" . urlencode($query);
  $VarianceListCurl = curl_init($GetUrl);
  curl_setopt($VarianceListCurl, CURLOPT_HEADER, false);
  curl_setopt ($VarianceListCurl, CURLOPT_SSL_VERIFYPEER, 0);
  curl_setopt ($VarianceListCurl, CURLOPT_SSL_VERIFYHOST, 0);
  curl_setopt($VarianceListCurl, CURLOPT_RETURNTRANSFER, true);
  curl_setopt($VarianceListCurl, CURLOPT_HTTPHEADER, array("Authorization: OAuth $access_token", "Content-type: application/json"));
  $JsonVarianceListResponse = curl_exec($VarianceListCurl);
  curl_close($VarianceListCurl);
  $VarianceResponseList = json_decode($JsonVarianceListResponse, true);
 
  $ArrayVariance = (array) $VarianceResponseList['records'];

   foreach($ArrayVariance as  $VarianceKey=>$VarianceItem)
   {

      $VarianceUrl = "$instance_url/services/data/v29.0/sobjects/Rent_Scrub__c/" . $VarianceItem["Id"];
      
      $VarianceCurl = curl_init($VarianceUrl);
      curl_setopt($VarianceCurl, CURLOPT_HEADER, false);
      curl_setopt ($VarianceCurl, CURLOPT_SSL_VERIFYPEER, 0);
      curl_setopt ($VarianceCurl, CURLOPT_SSL_VERIFYHOST, 0);
      curl_setopt($VarianceCurl, CURLOPT_RETURNTRANSFER, true);
      curl_setopt($VarianceCurl, CURLOPT_HTTPHEADER,
              array("Authorization: OAuth $access_token",
                  "Content-type: application/json"));
      curl_setopt($VarianceCurl, CURLOPT_CUSTOMREQUEST, "PATCH");
      curl_setopt($VarianceCurl, CURLOPT_POSTFIELDS, '{"sUnit__c" : "'.$UnitId.'"}');
      $VarianceResponse = curl_exec($VarianceCurl);

      curl_close($VarianceCurl);
  }

}


function UpdateAuctionObject($UnitName, $UnitId, $access_token, $instance_url, $StoreId)
{
  $query = "SELECT Id from Auction__c WHERE Unit__c = '" .  $UnitName  . "' AND Store__c = '" . $StoreId . "'";
    
  $GetUrl = "$instance_url/services/data/v29.0/query?q=" . urlencode($query);
  $AuctionListCurl = curl_init($GetUrl);
  curl_setopt($AuctionListCurl, CURLOPT_HEADER, false);
  curl_setopt ($AuctionListCurl, CURLOPT_SSL_VERIFYPEER, 0);
  curl_setopt ($AuctionListCurl, CURLOPT_SSL_VERIFYHOST, 0);
  curl_setopt($AuctionListCurl, CURLOPT_RETURNTRANSFER, true);
  curl_setopt($AuctionListCurl, CURLOPT_HTTPHEADER, array("Authorization: OAuth $access_token", "Content-type: application/json"));
  $JsonAuctionListResponse = curl_exec($AuctionListCurl);
  curl_close($AuctionListCurl);
  $AuctionResponseList = json_decode($JsonAuctionListResponse, true);
 
  $ArrayAuction = (array) $AuctionResponseList['records'];

   foreach($ArrayAuction as  $AuctionKey=>$AuctionItem)
   {

      $AuctionUrl = "$instance_url/services/data/v29.0/sobjects/Rent_Scrub__c/" . $VarianceItem["Id"];
      
      $AuctionCurl = curl_init($AuctionUrl);
      curl_setopt($AuctionCurl, CURLOPT_HEADER, false);
      curl_setopt ($AuctionCurl, CURLOPT_SSL_VERIFYPEER, 0);
      curl_setopt ($AuctionCurl, CURLOPT_SSL_VERIFYHOST, 0);
      curl_setopt($AuctionCurl, CURLOPT_RETURNTRANSFER, true);
      curl_setopt($AuctionCurl, CURLOPT_HTTPHEADER,
              array("Authorization: OAuth $access_token",
                  "Content-type: application/json"));
      curl_setopt($AuctionCurl, CURLOPT_CUSTOMREQUEST, "PATCH");
      curl_setopt($AuctionCurl, CURLOPT_POSTFIELDS, '{"sUnit__c" : "'.$UnitId.'"}');
      $AuctionResponse = curl_exec($AuctionCurl);

      curl_close($AuctionCurl);
  }

}

?>