Tiny File Manager

Back Back Up Advanced Editor

<?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. ' -7 days')); //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_orders?\$count=true&\$filter=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);

$curl = curl_init();
curl_setopt_array($curl, array(
  CURLOPT_URL => "https://api.columbus.sage.com/uk/sage200extra/accounts/v1/sop_orders?\$top=".$response1."&\$filter=document_date%20gt%20".$c_date."&\$expand=lines&\$orderby=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=d2f8c061ca8ce4337452ea4262e4741d91590390519; AzureAppProxyAnalyticCookie_f654ecf6-90d5-4999-b343-976f0861c5c0_1.3=3|rp6Q6anr2+YxnT0pgqOIl0l568Cp3ZLaMBCYuOzY19CODUbhJYDpittTaAsGfz04kuPT6dkTqlLvbvrxAFMZ9pprazK9x479A+vOkI2HSu4ASzK601hh6B1iu4s6JH/nV4ykfi6L3XsLt1TKli97Mw=="
  ),
));
 $response = curl_exec($curl);
curl_close($curl);

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

$data = json_decode($response);

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

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

for($i = 0; $i < count($data); $i++){
	 $analysis_code_1 = mysqli_real_escape_string($conn,$data[$i]->analysis_code_1);
	 $document_date = date('Y-m-d H:i:s',strtotime($data[$i]->document_date));
	 $document_no = $data[$i]->document_no;
 $customer_document_no = mysqli_real_escape_string($conn,$data[$i]->customer_document_no);
	 
	 $curl2 = curl_init();
curl_setopt_array($curl2, array(
 CURLOPT_URL => "https://api.columbus.sage.com/uk/sage200extra/accounts/v1/sales_transaction_views?\$filter=second_reference%20eq%20'".$document_no."'",
 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=d2f8c061ca8ce4337452ea4262e4741d91590390519; AzureAppProxyAnalyticCookie_f654ecf6-90d5-4999-b343-976f0861c5c0_1.3=3|rp6Q6anr2+YxnT0pgqOIl0l568Cp3ZLaMBCYuOzY19CODUbhJYDpittTaAsGfz04kuPT6dkTqlLvbvrxAFMZ9pprazK9x479A+vOkI2HSu4ASzK601hh6B1iu4s6JH/nV4ykfi6L3XsLt1TKli97Mw=="
 ),
));
$response2 = curl_exec($curl2);
curl_close($curl2);
$data2 = json_decode($response2);
$invoice_no = $data2[0]->reference;	 
 
				
				$query_select = "SELECT * FROM `stf_order_tbl` WHERE order_id = '".$data[$i]->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_order_tbl`(`id`, `order_id`,`customer_document_no`, `invoice_no`, `order_date`, `order_no`, `order_status`, `total_net_value`, `total_tax_value`, `total_gross_value`, `document_discount_percent`, `system`, `customer_id`) 
VALUES (NULL,'".$data[$i]->id."','".$customer_document_no."','".$invoice_no."','".$document_date."','".$data[$i]->document_no."','".$analysis_code_1."','".$data[$i]->total_net_value."'
,'".$data[$i]->total_tax_value."','".$data[$i]->total_gross_value."','".$data[$i]->document_discount_percent."','1','".$data[$i]->customer_id."')";
$res = mysqli_query($conn,$insert_sage_query);
if($res){
}else{
echo $insert_sage_query." ";
}
}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`='".$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." ";
}
}

$lines = $data[$i]->lines;

// echo count($lines); echo " ";
 for($k = 0; $k < count($lines); $k++){
	 $description = mysqli_real_escape_string($conn,$lines[$k]->description);
	 
	 	$query_product = "SELECT * FROM `stf_order_details_tbl` WHERE api_order_id = '".$lines[$k]->id."' ";
				$res_select_pro = mysqli_query($conn,$query_product);
				$num_row_pro = mysqli_num_rows($res_select_pro);
				if($num_row_pro == 0){
$product_query = "INSERT INTO `stf_order_details_tbl`(`id`, `order_id`, `api_order_id`, `line_number`, `code`, `description`, 
`line_quantity`, `selling_unit_description`, `selling_unit_price`, `unit_discount_percent`, `unit_discount_value`, `line_total_value`, `line_tax_value`)
 VALUES (NULL,'".$lines[$k]->sop_order_id."','".$lines[$k]->id."','".$lines[$k]->line_number."','".$lines[$k]->code."','".$description."',
 '".$lines[$k]->line_quantity."','".$lines[$k]->selling_unit_description."','".$lines[$k]->selling_unit_price."','".$lines[$k]->unit_discount_percent."','".$lines[$k]->unit_discount_value."',
'".$lines[$k]->line_total_value."','".$lines[$k]->line_tax_value."')";

$product_res1 = mysqli_query($conn,$product_query);
if($product_res1){
	//echo "Yes"; http://s835709564.websitehome.co.uk/api/current_order_api.php
}else{
echo $product_query." ";
}

}else{
$product_query = "UPDATE `stf_order_details_tbl` SET `line_number`='".$lines[$k]->line_number."',`code`='".$lines[$k]->code."',`description`='".$description."',`line_quantity`='".$lines[$k]->line_quantity."',
`selling_unit_description`='".$lines[$k]->selling_unit_description."',`selling_unit_price`='".$lines[$k]->selling_unit_price."',`unit_discount_percent`='".$lines[$k]->unit_discount_percent."',
`unit_discount_value`='".$lines[$k]->unit_discount_value."',`line_total_value`='".$lines[$k]->line_total_value."',`line_tax_value`='".$lines[$k]->line_tax_value."' WHERE api_order_id = '".$lines[$i]->id."' AND api_order_id <> 0";
$res1_p = mysqli_query($conn,$product_query);
if($res1_p){
	//echo "Yes";
}else{
echo $product_query." ";
}

}