Tiny File Manager

Back Back Up Advanced Editor

<?php
error_reporting(0);
session_start();
//include('../admin/inc/check.php'); update_delivery_address.php
include('../admin/inc/connection.php');
$query_select = "SELECT * FROM `stf_token_tbl` ";
$res_select = mysqli_query($conn,$query_select);
$num_row = mysqli_num_rows($res_select);
$row_select = mysqli_fetch_array($res_select);
$bearer_token = $row_select['access_token'];

$curl = curl_init();
curl_setopt_array($curl, array(
 CURLOPT_URL => "https://api.columbus.sage.com/uk/sage200extra/accounts/v1/customer_delivery_addresses?\$top=5000",
 CURLOPT_RETURNTRANSFER => true,
 CURLOPT_ENCODING => "",
 CURLOPT_MAXREDIRS => 10,
 CURLOPT_TIMEOUT => 0,
 CURLOPT_FOLLOWLOCATION => true,
 CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
 CURLOPT_CUSTOMREQUEST => "GET",
 CURLOPT_HTTPHEADER => array(
 "Ocp-Apim-Subscription-Key: b0ddd2a6467940bdbeb82740b1845b7a",
 "Authorization: Bearer ".$bearer_token,
 "X-Site: c68c7cf9-92d9-4a28-bce2-7cc86cfd6696",
 "X-Company: 2",
 "Cookie: ajs_group_id=null; ajs_anonymous_id=%22c6adc42c-7623-44fe-9ce2-db246e82fe1b%22; __cfduid=d59933855970d0ba88c2518e5499f2b0a1593093332; AzureAppProxyAnalyticCookie_f654ecf6-90d5-4999-b343-976f0861c5c0_1.3=3|mpcG4iwywCbT4MhO5q9/Q/GVTMhlUCQ80Y7dY35YTytIHsOWh++W7vMwAQaYRAfTfbW7GDykOPMpoDb4BbrqRH030F5KHvNw2SBZE+712IywrN8cwndT2Q76J8x8lhNC7+6JK9jkjzgl98p4s7JOgw=="
 ),
));
$response = curl_exec($curl);
curl_close($curl);
//echo $response;
$data = json_decode($response);
//echo count($data);
/*echo $data[2]->id." "; 169 delivery address 
echo $data[2]->customer_id." ";
echo $data[2]->default_email." ";
echo $data[2]->default_telephone." ";
 {
 "contact": "",
 "country": "",
 "customer_id": 19045,
 "description": "AJAY BESPOKE FURNITURE",
 "email": "",
 "fax": "",
 "is_default": true,
 "postal_name": "AJAY BESPOKE FURNITURE",
 "tax_code_id": 1002,
 "tax_number": "",
 "telephone": "",
 "id": 27692,
 "address_1": "UNIT B1C",
 "address_2": "NEPTUNE INDUSTRIAL ESTATE",
 "address_3": "NEPTUNE ROAD",
 "address_4": "HARROW, MIDDLESEX",
 "city": "",
 "county": "",
 "postcode": "HA1 4HX",
 "address_country_code_id": 0,
 "date_time_updated": "2017-01-07T14:02:24.53"
 }*/

for($i = 0; $i < count($data); $i++){
	$query_delivery = "SELECT * FROM `stf_user` WHERE `customer_id` = '".$data[$i]->customer_id."'";
	$query_res = mysqli_query($conn,$query_delivery);
	$num_delivery = mysqli_num_rows($query_res);
	if($num_delivery > 0){
	$row_delivery = mysqli_fetch_assoc($query_res);	
	//if($row_delivery['delivery_address_1'] == ""){
		$address_1 = mysqli_real_escape_string($conn,$data[$i]->address_1);
	$insert_sage_query = "UPDATE `stf_user` SET `delivery_address_1`='".$address_1."' WHERE `customer_id` = '".$data[$i]->customer_id."'";
 $res = mysqli_query($conn,$insert_sage_query);
 //	}
	
	//if($row_delivery['delivery_address_2'] == ""){
		$address_2 = mysqli_real_escape_string($conn,$data[$i]->address_2);
	$insert_sage_query = "UPDATE `stf_user` SET `delivery_address_2`='".$address_2."' WHERE `customer_id` = '".$data[$i]->customer_id."'";
 $res = mysqli_query($conn,$insert_sage_query);
	//}
	
	//if($row_delivery['delivery_address_3'] == ""){
			$address_3 = mysqli_real_escape_string($conn,$data[$i]->address_3);
	$insert_sage_query = "UPDATE `stf_user` SET `delivery_address_3`='".$address_3."' WHERE `customer_id` = '".$data[$i]->customer_id."'";
 $res = mysqli_query($conn,$insert_sage_query);
	//}
	
	//if($row_delivery['delivery_address_4'] == ""){
		$address_4 = mysqli_real_escape_string($conn,$data[$i]->address_4);
	$insert_sage_query = "UPDATE `stf_user` SET `delivery_address_4`='".$address_4."' WHERE `customer_id` = '".$data[$i]->customer_id."'";
 $res = mysqli_query($conn,$insert_sage_query);
	//}
	
	//if($row_delivery['delivery_city'] == ""){
			$city = mysqli_real_escape_string($conn,$data[$i]->city);
	$insert_sage_query = "UPDATE `stf_user` SET `delivery_city`='".$city."' WHERE `customer_id` = '".$data[$i]->customer_id."'";
 $res = mysqli_query($conn,$insert_sage_query);
	//}
	
	//if($row_delivery['delivery_postcode'] == ""){
		$postcode = mysqli_real_escape_string($conn,$data[$i]->postcode);
	$insert_sage_query = "UPDATE `stf_user` SET `delivery_postcode`='".$postcode."' WHERE `customer_id` = '".$data[$i]->customer_id."'";
 $res = mysqli_query($conn,$insert_sage_query);
	//}

if($res){
}else{
echo $insert_sage_query." ";
}
} // check 
}

/*echo "Customer Id:".$data->id;
echo " Reference:".$data->reference;
echo " Name:".$data->name;
echo " Balance:".$data->balance;
echo " On hold:".$data->on_hold;
echo " Short name:".$data->short_name;
echo " Account status type:".$data->account_status_type;
echo " Currency id:".$data->currency_id;
echo " Exchange rate type:".$data->exchange_rate_type;
echo " Telephone country code:".$data->telephone_country_code;
echo " Telephone area code:".$data->telephone_area_code;
echo " Telephone subscriber number:".$data->telephone_subscriber_number;
echo " Fax country code:".$data->fax_country_code;
echo " Fax subscriber number:".$data->fax_subscriber_number;
echo " Website:".$data->website;
echo " Credit limit:".$data->credit_limit;
echo " Fax area code:".$data->fax_area_code;
echo " Country code id:".$data->country_code_id;
echo " Default tax code_id:".$data->default_tax_code_id;
echo " Vat number:".$data->vat_number;
echo " Duns code:".$data->duns_code;
echo " Value of current orders in sop:".$data->value_of_current_orders_in_sop;
echo " Date time updated:".$data->date_time_updated;

}*/
	?>