<?php
date_default_timezone_set("Asia/Bangkok");

$month = array('','มกราคม','กุมภาพันธ์','มีนาคม','เมษายน','พฤษภาคม','มิถุนายน','กรกฎาคม','สิงหาคม','กันยายน','ตุลาคม','พฤศจิกายน','ธันวาคม');
$month2 = array('','ม.ค.','ก.พ.','มี.ค.','เม.ย.','พ.ค.','ม.ย.','ก.ค.','ส.ค.','ก.ย.','ต.ค.','พ.ย.','ธ.ค.');

$date_d = $_GET['d'];
$today = date('Y-m-d');
$day_j = date('j');
$month_n = date('n');
$year_y =date('Y');

$secrcht = " `code` =  '".@$date_d."'";
$sqlt = array('table'=>$name_table,'where'=>$secrcht);
$view_sqlt = $view_db->view($sqlt);
$rowt = $view_db->q($view_sqlt);
//echo $rowt['datetime'];
$secrchtt = " `datetime` <= '".@$rowt['datetime']."'";
$listtt = array('table'=>$name_table,'where'=>$secrchtt,'order'=> "ORDER BY `datetime` DESC LIMIT 0,24");
$viewtt = $view_db->view($listtt);
$resulttt = $view_db->q_re($viewtt);
$num=0;
while($rowttt = $view_db->q_ro($resulttt))
{
  $dt2 = explode(" ",$rowttt['datetime']);
  $dt2 = explode("-",$dt2[0]);

  $secrch = " `code` = '".@$rowttt['code']."' AND  `type` = '1'";
  $list = array('table'=>$name_table2,'where'=>$secrch,'order'=> "ORDER BY `type` ASC");
  $view = $view_db->view($list);
  $result = $view_db->q_re($view);
  $res[$num]['dt1']['0'] = '';
  $res[$num]['dt2']['0'] = 'fail1.png';
  $res[$num]['dt3']['0'] = '';
  $res[$num]['dt4']['0'] = 'fail1.png';
  while($rowf = $view_db->q_ro($result))
  {
    $r=0;
    $res[$num]['id'] = $rowf['code'];
    $res[$num]['dt1']['0'] = $rowf['description'];

  }

  $secrch = " `code` = '".@$rowttt['code']."' AND  `type` = '2'";
  $list = array('table'=>$name_table2,'where'=>$secrch,'order'=> "ORDER BY type ASC");
  $view = $view_db->view($list);
  $result = $view_db->q_re($view);
  while($rowf = $view_db->q_ro($result))
  {
    $r=0;
    $res[$num]['id'] = $rowf['code'];
    if($rowf['image']==''){$img='fail1.png';}else{$img=$rowf['image'];}
    $res[$num]['dt2']['0'] = $img;
    $res[$num]['dt2']['1'] = $rowf['description'];

    }


    $res[$num]['dt3'][0] = $rowttt['code2'];
    $res[$num]['title'] = $rowttt['title'];


  $secrch = " `code` = '".@$rowttt['code']."' AND  `type` = '4'";
  $list = array('table'=>$name_table2,'where'=>$secrch);
  $view = $view_db->view($list);
  $result = $view_db->q_re($view);

  $r=0;
  while($rowf = $view_db->q_ro($result))
  {
    $res[$num]['id'] = $rowf['code'];
    $res[$num]['dt4'][$r] = $rowf['image'];
    $r++;
  }
    $res[$num]['date'] = $dt2[2];
    $res[$num]['m'] = $month2[intval($dt2[1])];
    $res[$num]['m2'] = $month[intval($dt2[1])];
    $res[$num]['y'] = $dt2[0] +543;;

  $num++;
}


 ?>