=now()-interval 2 month order by order_date_time desc");
while($set_main = mysqli_fetch_assoc($get_main)){
$get_ord = mysqli_query($conn, "SELECT SUM(totprice) as amount from tbl_order where orderid='".$set_main['orid']."'");
$set_ord = mysqli_fetch_assoc($get_ord);
if($set_main['offer'] == 0 || $set_main['offer'] == ''){
$amount = $set_ord['amount'];
}else{
$discount = $set_main['offer'];
$amount = $set_ord['amount'] - (($set_ord['amount'] * $discount) / 100);
}
$url='';
if($set_main['company_name'] == 'Energy Foods' && $set_main['varstatus']!='Cash')
{
$url=''.$set_main['refid'].'';
}elseif($set_main['company_name'] == 'Energy Foods' && $set_main['varstatus']=='Cash'){
$url=''.$set_main['refid'].'';
}elseif($set_main['company_name'] == 'Anbu Phaarmaa' && $set_main['varstatus']!='Cash'){
$url=''.$set_main['refid'].'';
}elseif($set_main['company_name'] == 'Anbu Phaarmaa' && $set_main['varstatus']=='Cash'){
$url=''.$set_main['refid'].'';
}
$data[] = array('sl_no' => ++$i,'order_no'=>$url, 'order_date' => date('d-m-y', strtotime($set_main['order_date_time'])),'amount'=>round($amount));
}
if(!empty($data))
{
echo json_encode(array(
"aaData"=>$data));
}
else
{
echo json_encode(array('aaData'=>[]));
}
?>