<?php
$date = date("Ymd");
$list_c = array('table'=>'today_phone','where'=>'1','order'=> "ORDER BY date DESC LIMIT 0,1");				  
$view_c = $view_db->view($list_c);
$row_c = $view_db->q($view_c);
$date_arr =  explode('-',$row_c['date']);
$date_c = @$date_arr[0].@$date_arr[1].@$date_arr[2];

$sum_number_good = '';

$list_cc = array('table'=>'today_phone,phonenumber','where'=>'phonenumber.id = today_phone.id AND (phonenumber.status_number = 3 OR phonenumber.status_number = 2)','order'=> "ORDER BY phonenumber.status_number DESC LIMIT 0,1");				 
$view_cc = $view_db->view($list_cc);
$row_cc = $view_db->q($view_cc);
$status_number = $row_cc['status_number'];



if($date_c < $date || $status_number > 1)
{
	$date_to = date("Y-m-d");
	
	$sql = 'DELETE FROM today_phone';
	$row = $view_db->q($sql);
	
	
	$list = array('table'=>'phonenumber','where'=>'status = 1 AND status_number = 1 AND category_type = 2 AND expirationdate >= "'.$date_to.'" '." AND REPLACE(  `price` ,  ',',  '' ) <= 5000",
	'order'=> "ORDER BY `price` ASC , RAND() LIMIT 2");				  
	$view = $view_db->view($list);
	$result = $view_db->q_re($view);
	while($row = $view_db->q_ro($result))
	{
		$list = array(	
				'table'=>'today_phone',
				'id'=>"'".@$row['id']."'",
				'type'=>'99',//highlight
				'date'=>"'".date("Y-m-d")."'"
				
			);
		$add = $actiondata_db->add_db($list);
	}
	
	$list2 = array('table'=>'phonenumber','where'=>'status = 1 AND status_number = 1  AND category_type = 2 AND expirationdate >= "'.$date_to.'" '." AND REPLACE(  `price` ,  ',',  '' ) > 10000 AND REPLACE(  `price` ,  ',',  '' ) <= 50000",'order'=> "ORDER BY `price` ASC , RAND() LIMIT 2");				  
	$view2 = $view_db->view($list2);
	$result2 = $view_db->q_re($view2);
	while($row2 = $view_db->q_ro($result2))
	{
		$list = array(	
				'table'=>'today_phone',
				'id'=>"'".@$row2['id']."'",
				'type'=>'99',//highlight
				'date'=>"'".date("Y-m-d")."'"
				
			);
		$add = $actiondata_db->add_db($list);
	}
	
	
	$list3 = array('table'=>'phonenumber','where'=>'status = 1 AND status_number = 1  AND category_type = 2 AND expirationdate >= "'.$date_to.'" '." AND REPLACE(  `price` ,  ',',  '' ) > 50000 ",
	'order'=> "ORDER BY `price` ASC , RAND() LIMIT 2");				  
	$view3 = $view_db->view($list3);
	$result3 = $view_db->q_re($view3);
	while($row3 = $view_db->q_ro($result3))
	{
		$list = array(	
				'table'=>'today_phone',
				'id'=>"'".@$row3['id']."'",
				'type'=>'99',//highlight
				'date'=>"'".date("Y-m-d")."'"
				
			);
		$add = $actiondata_db->add_db($list);
	}
	
	
	
	
	$list = array('table'=>'phonenumber','where'=>'status = 1 AND status_number = 1 AND category_type = 1 AND expirationdate >= "'.$date_to.'"','order'=> "ORDER BY RAND() LIMIT 9");//เบอร์สวย				  
	$view = $view_db->view($list);
	$result = $view_db->q_re($view);
	while($row = $view_db->q_ro($result))
	{
		$list = array(	
				'table'=>'today_phone',
				'id'=>"'".@$row['id']."'",
				'type'=>'88',//เบอร์สวย
				'date'=>"'".date("Y-m-d")."'"
				
			);
		$add = $actiondata_db->add_db($list);

	}
	
	$list_d = array('table'=>'category','where'=>'status = 1 ORDER BY id ASC');				  
	$view_d = $view_db->view($list_d);
	$result_d = $view_db->q_re($view_d);
	while($row_d = $view_db->q_ro($result_d))
	{
		$sql_cat =  $Phone_class->cat_number($row_d['id']);
		$list = array(
		'table'=>'phonenumber',
		//'where'=>'status = 1 AND status_number = 1 AND category_type	 = 2 AND category LIKE "%'.$row_d['id'].'%" AND expirationdate >= "'.$date_to.'" ',
		'where'=>'status = 1 AND status_number = 1 AND category_type	 = 2 AND expirationdate >= "'.$date_to.'" AND '.$sql_cat,
		'order'=> "ORDER BY RAND() LIMIT 9");			  
		$view = $view_db->view($list);
		$result = $view_db->q_re($view);
		while($row = $view_db->q_ro($result))
		{
			$list2 = array(	
					'table'=>'today_phone',
					'id'=>"'".@$row['id']."'",
					'type'=>"'".$row_d['id']."'",
					'date'=>"'".date("Y-m-d")."'"
					
				);
			$add = $actiondata_db->add_db($list2);
			//print_r($list2);
		}
		
	}	
	//ขนาดหมวดต่างๆๆ	
}
?>