File "update_delivery_address.php"
Full path: /home/stellafo/public_html/api/update_delivery_address.php
File
size: 5.9 B
MIME-type: text/x-php
Charset: utf-8
Download Open Edit Advanced Editor Back
<?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."<br>"; 169 delivery address
echo $data[2]->customer_id."<br>";
echo $data[2]->default_email."<br>";
echo $data[2]->default_telephone."<br>";
{
"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."<br>";
}
} // check
}
/*echo "<b>Customer Id</b>:".$data->id;
echo "<br><b>Reference</b>:".$data->reference;
echo "<br><b>Name</b>:".$data->name;
echo "<br><b>Balance</b>:".$data->balance;
echo "<br><b>On hold</b>:".$data->on_hold;
echo "<br><b>Short name</b>:".$data->short_name;
echo "<br><b>Account status type</b>:".$data->account_status_type;
echo "<br><b>Currency id</b>:".$data->currency_id;
echo "<br><b>Exchange rate type</b>:".$data->exchange_rate_type;
echo "<br><b>Telephone country code</b>:".$data->telephone_country_code;
echo "<br><b>Telephone area code</b>:".$data->telephone_area_code;
echo "<br><b>Telephone subscriber number</b>:".$data->telephone_subscriber_number;
echo "<br><b>Fax country code</b>:".$data->fax_country_code;
echo "<br><b>Fax subscriber number</b>:".$data->fax_subscriber_number;
echo "<br><b>Website</b>:".$data->website;
echo "<br><b>Credit limit</b>:".$data->credit_limit;
echo "<br><b>Fax area code</b>:".$data->fax_area_code;
echo "<br><b>Country code id</b>:".$data->country_code_id;
echo "<br><b>Default tax code_id</b>:".$data->default_tax_code_id;
echo "<br><b>Vat number</b>:".$data->vat_number;
echo "<br><b>Duns code</b>:".$data->duns_code;
echo "<br><b>Value of current orders in sop</b>:".$data->value_of_current_orders_in_sop;
echo "<br><b>Date time updated</b>:".$data->date_time_updated;
}*/
?>