<?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="../orderdetail/list.php"><?php echo ucfirst('order') ?></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">
                        
							<table class="data-tbl-boxy table" style="font-size:12px;">
							<thead>
							<tr>
								<th width="7%">
									 ลำดับ
								</th>
								<th width="15%">
									 เบอร์
								</th>
                                <th width="15%">
									 ราคา
								</th>
                                <th width="12%">
									 สถานะ
								</th>
                                <th width="15%">
									วันที่ซื้อ
								</th>
							</tr>
							</thead>
							<tbody>
                            <?php
							$secrch = " orders.id = order_detail.id_order AND order_detail.id_pho = phonenumber.id AND orders.status = 4 AND phonenumber.by_admin = '".$_SESSION["admin_cn_id"]."'";
                            $list = array('table'=>'orders,order_detail,phonenumber','where'=>$secrch,'order'=> "ORDER BY orders.id DESC");				  
							$view = $view_db->view($list);
							$result = $view_db->q_re($view);
							
							
							$num=1;
							while($row = $view_db->q_ro($result))
							{
								?>
                                <tr>
                                    <td><?php echo $num; ?>. </td>
                                   
                                    <td><?php echo $row['phonenumber']; ?></td>
                                     <td><?php echo $row['price']; ?> ฿</td>
                                    <td>
                                   <?php
                                   echo 'ขายแล้ว';
								   ?>
                                    </td>
                                    <td><?php echo $util_class->day_m_th_re($row['up_date']) ?></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>