<?php
require_once("../include/class.php");
include('../include/connect.php');
date_default_timezone_set("Asia/Bangkok");
$date = date("Y-m-d");
$date2 = date("Y-m-d H:i:s");
//print_r($_SESSION);
if (isset($_POST['function']) && $_POST['function'] == 'noti') {
  $t=0;$m=0;$w=0;
$name_table = 'orders';
$strSQL4 = "SELECT * FROM `payment_notification` WHERE `referenceNo1` = '".@$_SESSION['order'][0]['BillPayment_Reference1']."' AND  `referenceNo2` = '".@$_SESSION['order'][0]['BillPayment_Reference2']."'";
$objQuery4 = mysqli_query($objCon,$strSQL4);
$objResult4 = mysqli_fetch_array($objQuery4);

$strSQL3 = "SELECT * FROM `payment` WHERE `BillPayment_Reference1` = '".@$_SESSION['order'][0]['BillPayment_Reference1']."' AND `BillPayment_Reference2` = '".@$_SESSION['order'][0]['BillPayment_Reference2']."'";
$objQuery3 = mysqli_query($objCon,$strSQL3);
$objResult3 = mysqli_fetch_array($objQuery3);
 $objResult3['BillPayment_Reference1']. $objResult4['referenceNo1'].'<br>';
 $objResult3['BillPayment_Reference2']. $objResult4['referenceNo2'].'<br>';
if(@$objResult4){

  if($objResult3['BillPayment_Reference1'] == $objResult4['referenceNo1'] && $objResult3['BillPayment_Reference2'] == $objResult4['referenceNo2']){



    $strSQLcheckerX ="UPDATE `payment_notification` SET `id-order`='".@$objResult3['id_order']."' WHERE `referenceNo1` = '".@$objResult3['BillPayment_Reference1']."' AND `referenceNo2` = '".@$objResult3['BillPayment_Reference2']."' AND `referenceNo3` = '".@$objResult3['BillPayment_Reference3']."'";
    $objQuerycheckerX = mysqli_query($objCon,$strSQLcheckerX);

    echo $data = $objResult4['ResponseCode'];

    $list = array(
      'table'=>$name_table,
      'Oid'=>@$_SESSION['order'][0]['id'],
      'Pmid'=>'12',
      'Ostatus'=>'OnlinePayment',
      'Olastdate'=>date("Y-m-d H:i:s")
    );
    $add = $actiondata_db->edit_db($list);

    $list_x = array(
      'table'=>'order_transfer',
      'id'=>'NULL',
      'Oid'=>"'".@$objResult3['id_order']."'",
      'Ostatus'=>'OnlinePayment',
      'Odatetime'=>"'".$date2."'",
    );

    $add2_x = $actiondata_db->add_db($list_x);

    unset($_SESSION['order']);


  }
}

}


 ?>