CHECK THE TIME: " . date("D, d M Y H:i:s e") . ""; ?> array( 'method'=>'GET', 'header'=>"Authorization: bearer ".$access_token."\r\n" ) ) ); } function ca_api_POST ($url,$data,$access_token) { return ca_api_CALL( $url, array( 'http' => array( 'method' =>'POST', 'content'=>json_encode($data), 'header' =>"Authorization: bearer ".$access_token."\r\n". "Content-Type: application/json\r\n". "Accept: application/json\r\n" ) ) ); } function ca_api_get_token ($application_id,$shared_secret,$refresh_token) { $fields = [ 'grant_type' => 'refresh_token', 'refresh_token' => $refresh_token ]; $url="https://".CA_API_ENDPOINT."/oauth2/token"; $access_token=ca_REST($url,$application_id,$shared_secret,$fields); if($access_token===false) return false; return json_decode($access_token,true)["access_token"]; } function ca_api_get_profile_id ($account_name,$access_token) { $url="https://".CA_API_ENDPOINT."/v1/Profiles"; $result=ca_api_GET($url,$access_token); /* ?>

value AS $profile) { if($profile->AccountName==$account_name) return $profile->ID; } return null; } function ca_api_get_cleared_orders ($access_token, $not_managed_by, $payed_after_date, $payed_before_date, $flag_id, $profile_id) { $payment_status = "PaymentStatus eq 'Cleared'"; $not_managed_by = $not_managed_by ? " and DistributionCenterTypeRollup ne '" . $not_managed_by . "'" : ""; // SellerManaged | ExternallyManaged | Mixed $payed_after_date = $payed_after_date ? " and PaymentDateUtc ge " . $payed_after_date . "" : ""; $payed_before_date = $payed_before_date ? " and PaymentDateUtc le " . $payed_before_date . "" : ""; $flag_id = $flag_id ? " and FlagID eq " . $flag_id . "" : ""; $profile_id = $profile_id ? " and ProfileID eq " . $profile_id . "" : ""; $url="https://".CA_API_ENDPOINT."/v1/Orders"."?\$filter=".urlencode($payment_status.$not_managed_by.$payed_after_date.$payed_before_date.$flag_id.$profile_id)."&\$expand=".urlencode("Items(\$expand=FulfillmentItems,Promotions,Adjustments,BundleComponents),Fulfillments(\$expand=Items),Adjustments,CustomFields")."&\$orderby=".urlencode("PaymentDateUtc asc"); ########################## /* echo "

".$url."

"; exit(); */ ########################## while($url!=null && $url!="") { if(!($result = ca_api_GET($url,$access_token)) || !is_array($result->value)) break; /* Bodge because CA doesnt report UK FBA Shipping including the Shipping TAX */ if(DistributionCenterTypeRollup=="ExternallyManaged" && SiteName=="Amazon UK") { $result->value->TotalShippingPrice+=$result->value->TotalShippingTaxPrice; } $orders = (is_array($orders) ? array_merge($orders,$result->value) : $result->value); $url = get_object_vars($result)['@odata.nextLink']; } ########################## /* ?>


PaymentDateUtc);	if(is_array($PaymentDateUtc)) $order->PaymentDateUtc=$PaymentDateUtc[0];
			$PaymentDateUtc = explode("Z",$order->PaymentDateUtc);	if(is_array($PaymentDateUtc)) $order->PaymentDateUtc=$PaymentDateUtc[0];
			$sql = "INSERT INTO __ca_orders SET ID='".addslashes($order->ID)."', DistributionCenterTypeRollup='".addslashes($order->DistributionCenterTypeRollup)."', OrderTags='".addslashes($order->OrderTags)."', FlagID='".addslashes($order->FlagID)."', FlagDescription='".addslashes($order->FlagDescription)."', CheckoutStatus='".addslashes($order->CheckoutStatus)."', PaymentStatus='".addslashes($order->PaymentStatus)."', ShippingStatus='".addslashes($order->ShippingStatus)."', PaymentDateUtc='".addslashes($order->PaymentDateUtc)."', SiteName='".addslashes($order->SiteName)."', SiteOrderID='".addslashes($order->SiteOrderID)."', SecondarySiteOrderID='".addslashes($order->SecondarySiteOrderID)."', PaymentMethod='".addslashes($order->PaymentMethod)."', SpecialInstructions='".addslashes($order->SpecialInstructions)."', TotalTaxPrice='".addslashes($order->TotalTaxPrice)."', TotalShippingPrice='".addslashes($order->TotalShippingPrice)."', TotalShippingTaxPrice='".addslashes($order->TotalShippingTaxPrice)."', TotalInsurancePrice='".addslashes($order->TotalInsurancePrice)."', AdditionalCostOrDiscount='".addslashes($order->AdditionalCostOrDiscount)."', TotalPrice='".addslashes($order->TotalPrice)."', BuyerUserId='".addslashes($order->BuyerUserId)."', BuyerEmailAddress='".addslashes($order->BuyerEmailAddress)."', BillingTitle='".addslashes($order->BillingTitle)."', BillingFirstName='".addslashes($order->BillingFirstName)."', BillingLastName='".addslashes($order->BillingLastName)."', BillingSuffix='".addslashes($order->BillingSuffix)."', BillingCompanyJobTitle='".addslashes($order->BillingCompanyJobTitle)."', BillingCompanyName='".addslashes($order->BillingCompanyName)."', BillingAddressLine1='".addslashes($order->BillingAddressLine1)."', BillingAddressLine2='".addslashes($order->BillingAddressLine2)."', BillingCity='".addslashes($order->BillingCity)."', BillingStateOrProvinceName='".addslashes($order->BillingStateOrProvinceName)."', BillingPostalCode='".addslashes($order->BillingPostalCode)."', BillingCountry='".addslashes($order->BillingCountry)."', BillingDaytimePhone='".addslashes($order->BillingDaytimePhone)."', BillingEveningPhone='".addslashes($order->BillingEveningPhone)."', ShippingTitle='".addslashes($order->ShippingTitle)."', ShippingFirstName='".addslashes($order->ShippingFirstName)."', ShippingLastName='".addslashes($order->ShippingLastName)."', ShippingSuffix='".addslashes($order->ShippingSuffix)."', ShippingCompanyJobTitle='".addslashes($order->ShippingCompanyJobTitle)."', ShippingCompanyName='".addslashes($order->ShippingCompanyName)."', ShippingAddressLine1='".addslashes($order->ShippingAddressLine1)."', ShippingAddressLine2='".addslashes($order->ShippingAddressLine2)."', ShippingCity='".addslashes($order->ShippingCity)."', ShippingStateOrProvinceName='".addslashes($order->ShippingStateOrProvinceName)."', ShippingPostalCode='".addslashes($order->ShippingPostalCode)."', ShippingCountry='".addslashes($order->ShippingCountry)."', ShippingDaytimePhone='".addslashes($order->ShippingDaytimePhone)."', ShippingEveningPhone='".addslashes($order->ShippingEveningPhone)."', PrivateNotes='".addslashes($order->PrivateNotes)."'";
			/*$insert_order_result = $mysqli->query($sql);*/
			?>">
Items AS $item) {
                $sql = "INSERT INTO __ca_order_items SET ID = '".addslashes($item->ID)."', OrderID = '".addslashes($item->OrderID)."', Sku = '".addslashes($item->Sku)."', Title = '".addslashes($item->Title)."', Quantity = '".addslashes($item->Quantity)."', UnitPrice = '".addslashes($item->UnitPrice)."', GiftPrice = '".addslashes($item->GiftPrice)."', GiftTaxPrice = '".addslashes($item->GiftTaxPrice)."', ShippingPrice = '".addslashes($item->ShippingPrice)."', ShippingTaxPrice = '".addslashes($item->ShippingTaxPrice)."', TaxPrice = '".addslashes($item->TaxPrice)."'";
				/*$insert_order_item_result = $mysqli->query($sql);*/
				?>">
FulfillmentItems AS $fulfillmentitem) { 
                    $sql = "INSERT INTO __ca_order_item_fulfillmentitems SET ID = '".addslashes($fulfillmentitem->ID)."', OrderID = '".addslashes($fulfillmentitem->OrderID)."', FulfillmentID = '".addslashes($fulfillmentitem->FulfillmentID)."', OrderItemID = '".addslashes($fulfillmentitem->OrderItemID)."', Quantity = '".addslashes($fulfillmentitem->Quantity)."'";
					/*$insert_order_item_result = $mysqli->query($sql);*/
					?>">
Fulfillments AS $fulfillment) {
                $sql = "INSERT INTO __ca_order_fulfillments SET ID = '".addslashes($fulfillment->ID)."', OrderID = '".addslashes($fulfillment->OrderID)."', DistributionCenterID = '".addslashes($fulfillment->DistributionCenterID)."', ShippingClass = '".addslashes($fulfillment->ShippingClass)."'";
				/*$insert_order_item_result = $mysqli->query($sql);*/
				?>">