<?php
$arr_month = array('1'=>"มกราคม","กุมภาพันธ์","มีนาคม","เมษายน","พฤษภาคม","มิถุนายน","กรกฎาคม","สิงหาคม","กันยายน","ตุลาคม","พฤศจิกายน","ธันวาคม");

//$today = date('Ynj');
$day_j = date('j');
$month_n = date('n');
$year_y =date('Y');



if($month_n == 1)
{
	$list = array('table'=>'update_m','where'=>'month = "'.$month_n.'"');				  
	$view = $view_db->view($list);
	$row = $view_db->q($view);
	
	if($day_j <= $row['day'])
	{
		$day_num  = $row['day'];
		
		if($day_j > $row['day'] && $row['status'] == 0)
		{
			$list = array(	
				'table'=>'update_m',
				'id'=>$row['id'] ,
				'status'=>1,
			  );
			  $edit_db = $actiondata_db->edit_db($list);
		}
	}
	else
	{
		$month_n = $month_n+1;
		$list2 = array('table'=>'update_m','where'=>'name = "'.$month_n.'/1'.'" AND month = "'.$month_n.'"');				  
		$view2 = $view_db->view($list2);
		$row2 = $view_db->q($view2);
		$day_num  = $row2['day'];
	}
}
else if($month_n == 12)
{
	$list = array('table'=>'update_m','where'=>'name = "'.$month_n.'/1'.'" AND month = "'.$month_n.'"');				  
	$view = $view_db->view($list);
	$row = $view_db->q($view);
	
	$list2 = array('table'=>'update_m','where'=>'name = "'.$month_n.'/2'.'" AND month = "'.$month_n.'"');				  
	$view2 = $view_db->view($list2);
	$row2 = $view_db->q($view2);
	
	$list3 = array('table'=>'update_m','where'=>'name = "'.$month_n.'/3'.'" AND month = "'.$month_n.'"');				  
	$view3 = $view_db->view($list3);
	$row3 = $view_db->q($view3);
	
	if($day_j > $row['day'] && $day_j <= $row2['day'])
	{
		$day_num  = $row2['day'];
	}
	else if($day_j > $row2['day']&& $day_j <= $row3['day'])
	{
		$day_num  = $row3['day'];
	}	
	else if($day_j > $row3['day'])
	{
		$month_n = 1;
		$list4 = array('table'=>'update_m','where'=>'name = "'.$month_n.'/2'.'" AND month = "'.$month_n.'"');				  
		$view4 = $view_db->view($list4);
		$row4 = $view_db->q($view4);
		$day_num  = $row4['day'];
	}	
	else
	{
		$day_num  = $row['day'];
	}
}
else
{
	$list = array('table'=>'update_m','where'=>'name = "'.$month_n.'/1'.'" AND month = "'.$month_n.'"');				  
	$view = $view_db->view($list);
	$row = $view_db->q($view);
	
	$list2 = array('table'=>'update_m','where'=>'name = "'.$month_n.'/2'.'" AND month = "'.$month_n.'"');				  
	$view2 = $view_db->view($list2);
	$row2 = $view_db->q($view2);
	
	if($day_j > $row['day'] && $day_j <= $row2['day'])
	{
		$day_num  = $row2['day'];
	}
	else if($day_j > $row2['day'])
	{		
		$month_n = $month_n+1;
		$list = array('table'=>'update_m','where'=>'name = "'.$month_n.'/1'.'" AND month = "'.$month_n.'"');				  
		$view = $view_db->view($list);
		$row = $view_db->q($view);
		$day_num  = $row['day'];
	}	
	else
	{
		$day_num  = $row['day'];
	}
	
}
$year_th  = $year_y + 543;
//$day_num = str_pad($arr_d2[0], 2, "0", STR_PAD_LEFT);
$text_daty =  $day_num . ' ' . $arr_month[$month_n] . ' ' . $year_th;
$sql_date =  $year_y.'-'.$month_n.'-'.$day_num;
$sql_date_M =  $year_y.$month_n.$day_num;
?>