<?php
include('../include/class.php');
date_default_timezone_set("Asia/Bangkok");
$date = date("YmdHis");
$date2 = date("Y-m-d");

$q = $_REQUEST["q"];
$max_id=0;
$sql = array('table'=>'wal_code','where'=>'code = "'.$q.'" AND status = "1"','order'=>'ORDER BY `wal_code`.`id` DESC');
$view_sql = $view_db->view($sql);
$row = $view_db->q($view_sql);
$code_t =  strnatcmp($q,$row['code']);
//print_r($view_sql);
//echo $row['id'];
if($row['id']){
  if($code_t==0){
    $date1=date_create($date2);
    $date2=date_create($row['expirationdate']);
    $diff=date_diff($date1,$date2);
    $diff = $diff->format("%R%a");
    $diff = (int)$diff;
    //echo $diff;
    if($diff>=0){
      //$sql = array('table'=>'wal_log_code','count'=>'MAX(id) AS max_id','where'=>'code = "'.$q.'"');
      $sql = array('table'=>'wal_log_code','count'=>'COUNT(id) AS max_id','where'=>'code = "'.$q.'" AND id_code = "'.$row['id'].'"');
      $view_sql = $view_db->view($sql);
      $row1 = $view_db->q($view_sql);
      $max_id = $row1['max_id'];

      if($row['max'] > (int)$max_id){
        $data = array(
          'code' => $row['code'],
          'id_code' => $row['id'],
          'max' => $row['max'],
          'max_use' => $max_id,
          'length' => $row['max']-$max_id,
          'type' => $row['type'],
          'money'=> $row['money'],
          'status' => 'yes'
        );
      }else{
        $data = array(
          'status' => 'max'
        );
      }

    }else{
      $data = array(
        'status' => 'expire'
      );
    }

  }else{
    $data = array(
      'status' => 'false'
    );
  }
}else{
  $data = array(
    'status' => 'false'
  );
}
echo json_encode($data, JSON_UNESCAPED_UNICODE);
//print_r($data);
 ?>