<?php
 require 'bigcommerce.php';
 require 'config.php';

$query=mysql_query("select MAX(order_id) AS O_ID from order_track ");
$val=mysql_fetch_assoc($query);
$t=$val['O_ID'];

use Bigcommerce\Api\Client as Bigcommerce;
Bigcommerce::configure(array(
    'store_url' => 'https://www.123realhealth.com/',
    'username'  => 'rohit_api',
    'api_key'   => 'c017e80c5c7542f38b31a3c649e92c9b7f66d94d'
));
$filter=array("limit"=>250,"min_id"=>$t);
$orders = Bigcommerce::getOrders($filter);
$arr= array();
foreach($orders as $order) {
$arr[]=$order->id;
} 
	$filtered = array_filter($arr, function ($x) { return $x > $t; });
	
foreach($orders as $order)
{ 
$v=2;
if($order->status=='Awaiting Fulfillment')
{ $v=0;
}
elseif($order->status=='Awaiting Shipment')
{ $v=1;
}
if (in_array($order->id, $filtered)) {
mysql_query("insert into  order_track(order_id,status,statchk) values('".$order->id."','".$order->status."',$v)");
}
}
$quer=mysql_query("select * from order_track where  statchk=0 and order_id>$t");
while($row=mysql_fetch_assoc($quer))
{
$arr2=array();
$custom = Bigcommerce::getOrderscustom($row['order_id']);
$arr4= array();
$count=0;
 foreach($custom as $order1)
{ 
if (strpos($order1->sku,'-EE') !== false) {
   

$tr=str_replace("-EE","",$order1->sku);
$arr4[$count]['ItemId']=$tr;
$arr4[$count]['Quantity']=$order1->quantity;
$count++;
}
}
$str= json_encode($arr4);
 $linedata=str_replace("}", ",}",$str);
 $linedata1=str_replace("},{", "}{",$linedata);
foreach($orders as $order)
{ 
      if($order->id==$row['order_id'])
    {
      $query=mysql_query("select * from  Region");
     $code='1';
     $val=$order->shipping_addresses[0]->state;
     while($row1=mysql_fetch_assoc($query))
     {
     if (strcasecmp($val, $row1['rname']) == 0) {
     $code=$row1['rcode'];
     break;
     }
     }

$arr2['Line1']=$order->shipping_addresses[0]->street_1;
$arr2['CountryName']=$order->shipping_addresses[0]->country;
$arr2['RegionName']=$order->shipping_addresses[0]->state;
$arr2['PostalCode']=$order->shipping_addresses[0]->zip;
$arr2['FullName']="Supplement Your Health";
$arr2['phone']=$order->shipping_addresses[0]->phone;
$arr2['CountryCode']=$order->shipping_addresses[0]->country_iso2;
$arr2['City']=$order->shipping_addresses[0]->city;
$arr2['RegionCode']=$code;
   }

}
$address=json_encode($arr2);

$header = array('Content-Type: application/json','X-HTTP-Method-Override: PUT');
		$data='{
  "userName": "schwarzwc",
  "password": "78bf71",
  "apiKey": "{ce7cf8f8-3a2c-46e3-928c-f50f61842bab}",
  "order": {
    "LineItems": '.$linedata1.',
    "ShipToAddress": '.$address.',
	"ShippingMethod":"Standard",
	"PaymentIdentifier":"{6afc8da8-8005-46fc-8060-1ba31bc28f56}"

  },
  "apiRequestType":3
}';
	
$ch = curl_init();
$curlConfig = array(
    CURLOPT_URL            => "https://api.emersonecologics.com/4.3/OrderService.svc/json/SubmitOrder",
    CURLOPT_POST           => 1,
    CURLOPT_RETURNTRANSFER => 1,
	CURLOPT_HTTPHEADER=> $header,
    CURLOPT_POSTFIELDS=>$data,
);
curl_setopt_array($ch, $curlConfig);
$result = curl_exec($ch);
curl_close($ch);
$arr6=json_decode($result, true);
$ordernum='';
if(!empty($arr6['OrderGuid']))
{ 
$var=$arr6['OrderGuid'];
/*  $response2=file_get_contents("https://api.emersonecologics.com/4.0/OrderService.svc/json/GetOrderNumber?userName=123rhealth&password=password1&apiKey={86696957-04fb-4e39-a601-cbbf6d3028be}&orderGuid={$var}");
$arr7=json_decode($response2, true);
$ordernum=$arr7['OrderNumber']; */
mysql_query("update order_track  set GUIDNo='$var' , status='Awaiting Shipment' ,statchk=1 where order_id='".$row['order_id']."'");
 $o = array('status_id'=>9);
 
   $var1 = Bigcommerce::updateOrder($row['order_id'], $o);
    if($var1)
   {echo "success";
   }
   
}
else
{
mail('pamala@schwarzwc.com','Error in order id:'.$row['order_id'],$arr6['Errors']);
}

}


?>