Root Explorer PHP

Editing: functions.inc.php

<?php
function pr($arr){
    echo 'pre';
    print_r($arr);
}
function prx ($arr){
    echo 'pre';
    print_r($arr);
    die();
}
function get_safe_value($con,$str){
	if($str!=''){
		$str=trim($str);
		return mysqli_real_escape_string($con,$str);
	}
}
function productSoldQtyByProductId($con,$pid){
	$sql="select sum(order_detail.qty) as qty from order_detail,`order` where `order`.id=order_detail.order_id and order_detail.product_id=$pid and `order`.order_status!=4";
	$res=mysqli_query($con,$sql);
	$row=mysqli_fetch_assoc($res);
	return $row['qty'];
}

$total_price=$row_order['total_price'];
	$res=mysqli_query($con,"select order_detail.*,product.name from order_detail,product where product.id=order_detail.product_id and order_detail.order_id='$order_id'");
	$html='';
	
	while($row=mysqli_fetch_assoc($res)){
		$sku=rand(111111,999999);
		$html.='{
		  "name": "'.$row['name'].'",
		  "sku": "'.$sku.'",
		  "units": '.$row['qty'].',
		  "selling_price": "'.$row['price'].'",
		  "discount": "",
		  "tax": "",
		  "hsn": ""
		},';
	}
	$html=rtrim($html,",");
	
	$curl = curl_init();
	  curl_setopt_array($curl, array(
		CURLOPT_URL => "https://apiv2.shiprocket.in/v1/external/orders/create/adhoc",
		CURLOPT_RETURNTRANSFER => true,
		CURLOPT_ENCODING => "",
		CURLOPT_MAXREDIRS => 10,
		CURLOPT_TIMEOUT => 0,
		CURLOPT_FOLLOWLOCATION => true,
		CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
		CURLOPT_CUSTOMREQUEST => "POST",
		CURLOPT_POSTFIELDS =>'{"order_id": "'.$order_id.'",
	  "order_date": "'.$order_date.'",
	  "pickup_location": "bharat jangra",
	  "billing_customer_name": "'.$name.'",
	  "billing_last_name": "",
	  "billing_address": "'.$address.'",
	  "billing_address_2": "",
	  "billing_city": "'.$city.'",
	  "billing_pincode": "'.$pincode.'",
	  "billing_state": "Delhi",
	  "billing_country": "India",
	  "billing_email": "'.$email.'",
	  "billing_phone": "'.$mobile.'",
	  "shipping_is_billing": true,
	  "shipping_customer_name": "",
	  "shipping_last_name": "",
	  "shipping_address": "",
	  "shipping_address_2": "",
	  "shipping_city": "",
	  "shipping_pincode": "",
	  "shipping_country": "",
	  "shipping_state": "",
	  "shipping_email": "",
	  "shipping_phone": "",
	  "order_items": [
		'.$html.'
	  ],
	  "payment_method": "'.$payment_type.'",
	  "shipping_charges": 0,
	  "giftwrap_charges": 0,
	  "transaction_charges": 0,
	  "total_discount": 0,
	  "sub_total": "'.$total_price.'",
	  "length": '.$length.',
	  "breadth": '.$breadth.',
	  "height": '.$height.',
	  "weight": '.$weight.'
		}',
    CURLOPT_HTTPHEADER => array(
      "Content-Type: application/json",
	   "Authorization: Bearer $token"
    ),
  ));
  $SR_login_Response = curl_exec($curl);
  curl_close($curl);
  $SR_login_Response_out = json_decode($SR_login_Response,true);
  // prx($SR_login_Response_out);
  if(isset($SR_login_Response_out['order_id']) && isset($SR_login_Response_out['shipment_id'])){
	  $ship_order_id=$SR_login_Response_out['order_id'];
	  $ship_shipment_id=$SR_login_Response_out['shipment_id'];
	  mysqli_query($con,"update `order` set ship_order_id='$ship_order_id', ship_shipment_id='$ship_shipment_id' where id='$order_id'");
	  echo "<div class='shiprocket_error'>Order id:-".$ship_order_id."</div>";
	  echo "<div class='shiprocket_error'>Shipment id:-".$ship_shipment_id."</div>";
  }else{
	  $errroHTML='';
	  if(isset($SR_login_Response_out['errors'])){
		  foreach($SR_login_Response_out['errors'] as $key=>$val){
			  $errroHTML.=$key.' : '.$val[0].'<br/>';
		  }
	  }else{
		  $errroHTML="Shiprocket API: Someting went wrong";
	  }
	  echo "<div class='shiprocket_error'>".$errroHTML."</div>";
	  
  }
}
function cancelShipRocketOrder($token,$ship_order_id){
	$curl = curl_init();

curl_setopt_array($curl, array(
  CURLOPT_URL => "https://apiv2.shiprocket.in/v1/external/orders/cancel",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 0,
  CURLOPT_FOLLOWLOCATION => true,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS =>"{\n  \"ids\": [".$ship_order_id."]\n}",
  CURLOPT_HTTPHEADER => array(
    "Content-Type: application/json",
    "Authorization: Bearer $token"
  ),
));
	$response = curl_exec($curl);
	curl_close($curl);
}

function isAdmin(){
	if(!isset($_SESSION['ADMIN_LOGIN'])){
	?>
		<script>
		window.location.href='login ';
		</script>
		<?php
	}
	if($_SESSION['ADMIN_ROLE']==1){
		?>
		<script>
		window.location.href='product ';
		</script>
		<?php
	}
}
?>

[ CANCEL ]

Name	Type	Actions
.. (Parent Directory)
📄 connection.inc.php	FILE	[EDIT]
📄 functions.inc.php	FILE	[EDIT]
📄 head.inc.php	FILE	[EDIT]
📄 top.inc.php	FILE	[EDIT]

[ Root System Explorer ]

Editing: functions.inc.php