<?php require_once("../include/class.php");?>
<?php require_once("../include/header.php");?>
<?php require_once("../include/nav_top.php");?>
<?php require_once("../include/sidebar.php");?>
<?php include("table_name.php");?>

<div id="main-content">
  <div class="container-fluid">
  
    <ul class="breadcrumb">
      <li><a href="../<?php echo $name_folder; ?>/list.php"><?php echo ucfirst($name_table) ?></a><span class="divider">&raquo;</span></li>
      <li class="active">List</li>
    </ul>
    
    <div class="row-fluid">
			<div class="span12">
				<div class="widget-block">
					<div class="widget-head">
                   
						<h5>List</h5>
						
					</div>
                     
					<div class="widget-content">
						<div class="widget-box">
                      
                        <div style="padding:20px;">
                        <?php
                        $today_calendar = date('d-m-Y');
						if(isset($_POST['dmy_getnumber']))
						{
							 $today_calendar = $_POST['dmy_getnumber'];
						}
						?>
                        <form action="list.php" method="post">
                        <div class="input-append date" id="datepicker" data-date="<?php echo $today_calendar; ?>" data-date-format="dd-mm-yyyy">
                                    <div class="control-group">
                                        <label class="control-label"> ดูย้อนหลัง </label>
                                        <div class="controls">
                                            <div class="input-append">
                                                <input size="16" type="text"  name="dmy_getnumber" value="<?php echo $today_calendar; ?>">
                                                <span class="add-on margin-fix"><i class="icon-th"></i></span>
                                            </div>
                                        </div>
                                       
                                    </div>
                                </div>
                                
                        <div class="control-group">
                        <label class="control-label"> ประเภท </label>
                       
                            <select name="type">
                                <option value="" <?php if($_POST['type'] ==''){?>selected<?php }?> >ทั้งหมด</option>
                                <option value="1" <?php if($_POST['type'] =='1'){?>selected<?php }?> >เบอร์โทรศัพท์</option>
                                <option value="2" <?php  if($_POST['type'] =='2'){?>selected<?php }?> >เลขบัตรประชาชน</option>
                            </select>
                      
                        </div>
                          
                        <input type="submit" class="btn" value="ค้าหา">
                        </form>
                        </div>
                        <?php
						$f_day =  mktime(0, 0, 0, date("n"), date("d"), date("Y"));
						$t_day =  mktime(23, 59, 59, date("n"), date("d"), date("Y"));
						if(isset($_POST['dmy_getnumber']))
						{
							$arr_getnumber = explode('-',$_POST["dmy_getnumber"]);
							
							$f_day =  mktime(0, 0, 0, $arr_getnumber[1], $arr_getnumber[0], $arr_getnumber[2]);
							$t_day =  mktime(23, 59, 59, $arr_getnumber[1], $arr_getnumber[0], $arr_getnumber[2]);
						}
					
							 if(!$_POST['type'] == '')
							 {
								 $sql_ty = ' AND type = "'.$_POST['type'].'"';
							 }
						
						$secrch = "createtime_U >= ".$f_day." AND createtime_U <= ".$t_day . $sql_ty ;
						$list = array('table'=>$name_table,'where'=>$secrch,'order'=> "ORDER BY createtime_U DESC");				  
						$view = $view_db->view($list);
						$result = $view_db->q_re($view);
						$num_rows = mysqli_num_rows($result);
						
						
						$list1 = array('table'=>$name_table,'count'=>'COUNT(phonenumber) AS count_ty1','where'=>$secrch . ' AND type = 1');				  
						$view1 = $view_db->view($list1);	
						$row1 = $view_db->q($view1);
						
						$list2 = array('table'=>$name_table,'count'=>'COUNT(phonenumber) AS count_ty2','where'=>$secrch . ' AND type = 2');				  
						$view2 = $view_db->view($list2);	
						$row2 = $view_db->q($view2);
						?>
                        <div style="padding:10px;"><?php echo 'จำนวนข้อมูลเบอร์ : ' . $row1['count_ty1'];?></div>
                        <div style="padding:10px;"><?php echo 'จำนวนข้อมูลบัตรประชาชน : ' . $row2['count_ty2'];?></div>
                        
							<table class="data-tbl-boxy table" style="font-size:12px;">
							<thead>
							<tr>
								<th width="5%">
									 ลำดับ
								</th>
								<th>
									 เบอร์
								</th>
                                <th width="15%">
									วันที่
								</th>
								
							</tr>
							</thead>
							<tbody>
                            <?php
							
							
							
							$num=1;
							while($row = $view_db->q_ro($result))
							{
								?>
                                <tr>
                                    <td><?php echo $num; ?>. </td>
                                   
                                    <td><?php echo $row['phonenumber']; ?></td>
                                    
                                    <td><?php echo $util_class->day_m_th_re($row['createtime']) ?></td> 
                                   
							</tr>
                                <?php
								$num++;
							}
							?>
							</tbody>
							</table>
						</div>
					</div>
				</div>
			</div>
		</div>
    
    
  </div>
</div>
<?php unset($_SESSION['er']);?>
<?php require_once("../include/footer_js.php");?>
</body>
</html>