Manager

Back Back Up Advanced Editor

<?php

session_start();

include('../../config/database.php');

$orderId        = $_POST['orderId'];

$receiptId      = $_POST['receiptId'];

$distributorid  = $_POST['distributorid'];

$receive_amount = $_POST['receive_amount'];

$receive_date   = date('y-m-d',strtotime($_POST['receive_date']));

$orderRemark    = mysqli_real_escape_string($cn,$_POST['orderRemark']);

if(!empty($orderId) || !empty($receiptId))

{

if($orderId>0)

{

mysqli_query($cn,"update `tbl_order` SET `verify_status`=1, `verify_remark`='$orderRemark' where `order_id`='$orderId'");

}

else

{

mysqli_query($cn,"update `tbl_order` SET `verify_status`=1, `verify_remark`='$orderRemark' where `receipt_id`='$receiptId'");

}

if($receive_amount>0)

{

mysqli_query($cn,"insert into `tbl_payment` SET `distributor_id`='".$distributorid."', `order_id`='".$orderId."',`amount`='".$receive_amount."', `receive_date`='".$receive_date."', `remark`='".$orderRemark."', `added_by`='".$_SESSION['harsh_id']."', `date`=Now();");

}

$arr    = array("status"=>1, 'SuccessMsg'=>"Order Verify SuccessFully");

echo json_encode($arr);