<?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';


    $search2 = "BillPayment_Reference1 = '".@$_SESSION['order'][0]['BillPayment_Reference1']."' AND  BillPayment_Reference2 = '".@$_SESSION['order'][0]['BillPayment_Reference2']."'";

    $list_ord = array('table'=>'payment','where'=> @$search2, "order"=>"ORDER BY `payment`.`id` ASC");
  	$view_ord = $view_db->view($list_ord);
  	$result_ord = $view_db->q_re($view_ord);
   //print_r($view_ord);
  	while($row_ord = $view_db->q_ro($result_ord))
  	{
      $search = "referenceNo1 = '".@$_SESSION['order'][0]['BillPayment_Reference1']."' AND  referenceNo2 = '".@$_SESSION['order'][0]['BillPayment_Reference2']."'";
      $sql_or = array('table'=>'payment_notification','where'=> @$search);
    	$view_or = $view_db->view($sql_or);
    	$row_or = $view_db->q($view_or);
      //echo $row_or['referenceNo1']." ".$row_ord['BillPayment_Reference1'] ." ".$row_or['referenceNo2']." ".$row_ord['BillPayment_Reference2'];
      if($row_or['referenceNo1']==$row_ord['BillPayment_Reference1'] && $row_or['referenceNo2']==$row_ord['BillPayment_Reference2']){


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

         $strSQLcheckerX;
        echo $data = $row_or['ResponseCode'];
        if($objQuerycheckerX){
          @$search2 = "Biid = '".@$row_ord['id_order']."'";
          $list_ord2 = array('table'=>'order_bill','where'=> @$search2, "order"=>"ORDER BY id ASC");
        	$view_ord2 = $view_db->view($list_ord2);
        	$result_ord2 = $view_db->q_re($view_ord2);
          while($row_ord2 = $view_db->q_ro($result_ord2))
        	{

            $pm=12;
            $stt='OnlinePayment';
            $list = array(
              'table'=>$name_table,
              'Oid'=>@$row_ord2['Oid'],
              'Pmid'=>$pm,
              'Ostatus'=>$stt,
              'Olastdate'=>date("Y-m-d H:i:s")
            );
            $add = $actiondata_db->edit_db($list);
            //print_r($list);

            $list_x = array(
              'table'=>'order_transfer',
              'Oid'=>"'".@$row_ord2['Oid']."'",
              'Ostatus'=>"'".$stt."'",
              'Odatetime'=>"'".$date2."'",
            );

            $add2_x = $actiondata_db->add_db($list_x);
            //print_r($list);

          }

          unset($_SESSION['order']);
          unset($_SESSION['shop_x']);
          /*
          */
        }

      }

    }



}


 ?>