File "quotes_api.php"

Full path: /home/stellafo/public_html/api/quotes_api.php
File size: 5.38 B
MIME-type: text/x-php
Charset: utf-8

Download   Open   Edit   Advanced Editor   Back

<?php
error_reporting(0);
session_start();
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'];

	  date_default_timezone_set('Europe/London');
		 //$c_date = date('Y-m-d');
		// $c_date = date('Y-m-d', strtotime($c_date. ' -30 days'));
		//$year = date('Y') - 1;
        // $c_date = $year."-01-01";
		 $c_date = date("Y-m-d", strtotime("first day of previous month"));
//invoice_api_list.php 8149403
$curl1 = curl_init();
curl_setopt_array($curl1, array(
  CURLOPT_URL => "https://api.columbus.sage.com/uk/sage200extra/accounts/v1/sop_quote_line_views?\$count=true&\$filter=sop_quote_document_date%20gt%20".$c_date,
  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: 6f9900cac2a44c60bfa1ff4434098453",
    "Authorization: Bearer ".$bearer_token,
    "X-Site: 94658409-de78-44cb-bb79-01eb3005ce1f",
    "X-Company: 2"),
));

 $response1 = curl_exec($curl1);
curl_close($curl1);

//echo "https://api.columbus.sage.com/uk/sage200extra/accounts/v1/sop_quote_line_views?\$top=".$response1."&\$filter=sop_quote_document_date%20gt%20".$c_date."&\$orderby=sop_quote_document_date%20desc";

$curl = curl_init();

curl_setopt_array($curl, array(
  CURLOPT_URL => "https://api.columbus.sage.com/uk/sage200extra/accounts/v1/sop_quote_line_views?\$top=".$response1."&\$filter=sop_quote_document_date%20gt%20".$c_date."&\$orderby=sop_quote_document_date%20asc",
  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: 6f9900cac2a44c60bfa1ff4434098453",
    "Authorization: Bearer ".$bearer_token,
    "X-Site: 94658409-de78-44cb-bb79-01eb3005ce1f",
    "X-Company: 2",
    "Cookie: ajs_group_id=null; ajs_anonymous_id=%22c6adc42c-7623-44fe-9ce2-db246e82fe1b%22; __cfduid=d17c83d520b0441fa02eac13005c351751601615514; AzureAppProxyAnalyticCookie_f654ecf6-90d5-4999-b343-976f0861c5c0_1.3=3|m/mNQBxP2YAEITNeULcM6/6+PxxM4IxZTm4vWcPbEQNTqWi/TvyMSdXRKowGgOVWOKqsXae324VHV1/ep2W9H2PU87Lss4/CBdyfebYkhCdCKq6OhfPOHXfb+10XiEu1Z30iC/D/CVOChbsbP0N40Q=="
  ),
));
 $response = curl_exec($curl);

curl_close($curl);

//echo "Result showing first ".$response1." of total result - ".$response1;

$data = json_decode($response);
print_r($data);
//$data = json_decode($response);
//echo count($data);

//echo $data[0]->document_no; echo "<br>";
//echo $data[0]->customer_id; count($data)


for($i = 0; $i < count($data); $i++){
	 $product_name  = mysqli_real_escape_string($conn,$data[$i]->sop_quote_line_product_description);
	 $customer_name  = mysqli_real_escape_string($conn,$data[$i]->customer_name);
	 echo $data[$i]->save_quote_reference.'<br>';
	 
				
				$query_select = "SELECT * FROM `stf_quotes_tbl` WHERE sop_quote_line_id = '".$data[$i]->sop_quote_line_id."' ";
				$res_select = mysqli_query($conn,$query_select);
				$num_row = mysqli_num_rows($res_select);
				if($num_row == 0){
$insert_sage_query = "INSERT INTO `stf_quotes_tbl`(`id`, `sop_quote_document_no`, `sop_quote_document_date`, `sop_quote_line_id`, `sop_quote_line_number`,
 `sop_quote_line_quantity`, `sop_quote_line_selling_unit_description`, `sop_quote_line_selling_unit_price`, `sop_quote_line_unit_discount_value`,
 `sop_quote_line_total_value`, `sop_quote_line_line_tax_value`, `system`, `customer_id`, `customer_reference`, `customer_name`, `product_id`,
 `product_code`, `product_name`, `save_quote_reference`) VALUES (NULL,'".$data[$i]->sop_quote_document_no."','".$data[$i]->sop_quote_document_date."','".$data[$i]->sop_quote_line_id."',
 '".$data[$i]->sop_quote_line_number."','".$data[$i]->sop_quote_line_quantity."','".$data[$i]->sop_quote_line_selling_unit_description."',
 '".$data[$i]->sop_quote_line_selling_unit_price."','".$data[$i]->sop_quote_line_unit_discount_value."','".$data[$i]->sop_quote_line_total_value."','".$data[$i]->sop_quote_line_line_tax_value."',
 '1','".$data[$i]->customer_id."','".$data[$i]->customer_reference."','".$customer_name."',
 '".$data[$i]->product_id."','".$data[$i]->product_code."','".$product_name."','".$data[$i]->save_quote_reference."')";
$res = mysqli_query($conn,$insert_sage_query);
if($res){
}else{
echo $insert_sage_query."<br>";
}
}/*else{
$update_sage_query = "UPDATE `stf_order_tbl` SET `invoice_no`= '".$invoice_no."',`order_date`= '".$document_date."',`order_no`='".$data[$i]->document_no."',`order_status`='".$analysis_code_1."',`total_net_value` = '".$data[$i]->total_net_value."',`total_tax_value`='".$data[$i]->total_tax_value."',`total_gross_value`='".$data[$i]->total_gross_value."',`customer_document_no`='".$data[$i]->customer_document_no."',
`document_discount_percent`='".$data[$i]->document_discount_percent."' WHERE `order_id` = '".$data[$i]->id."'";
$res1 = mysqli_query($conn,$update_sage_query);
if($res1){
	//echo "Yes";
}else{
echo $update_sage_query."<br>";
}
}*/

}


?>