<?php
//session_start();
require_once("../include/class.php");
include('../include/connect.php');
$id = $_POST['id'];
$id_order = $_POST['id_order'];
$ref1 = $_POST['ref1'];
$ref2 = $_POST['ref2'];
$ref3 = $_POST['ref3'];
//print_r($_POST);
$strSQLw2 = "SELECT * FROM `payment_notification` WHERE `TransactionID` = '".@$id."'";
$objQueryw2 = mysqli_query($objCon,$strSQLw2);
$objResultw2 = mysqli_fetch_array($objQueryw2,MYSQLI_ASSOC);
date_default_timezone_set("Asia/Bangkok");
$date = date("Y-m-d H:i:s");
$date2 = date("Y-m-d H:i:s");
$name_table = 'orders';
if(!@$objResultw2['id-order']){
   $strSQLorder3 = "INSERT INTO `payment_notification`(`id`,`id-order`,`TransactionID`, `TransactionDateTime`, `SystemCode`, `ServiceName`, `ChannelID`, `OriginalResponseCode`, `OriginalResponseMessage`, `ResponseCode`, `ResponseMessage`, `referenceNo1`, `referenceNo2`, `referenceNo3`, `dt_update`, `json`)
   VALUES (NULL,'','$id','','','','','','','BGW-I-0000','','".$ref1."','".$ref2."','".$ref3."','".$date."', 'test')";
  $objQueryorder3 = mysqli_query($objCon,$strSQLorder3);
  if($objQueryorder3){
    echo "BGW-I-0000";
    $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'=>"'".@$id_order."'",
      'Ostatus'=>'OnlinePayment',
      'Odatetime'=>"'".$date2."'",
    );

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

  //   unset($_SESSION['order']);
  }
}
 ?>