<div id="sidebar">
  <ul class="side-nav accordion_mnu collapsible">
     <li><a href="../main/index.php"><span class="white-icons home"></span> Home</a></li>
	<?php
    if($_SESSION["admin_cn_type"] == 1)
	{
		?>
        <li><a href="../banner/list.php"><span class="white-icons image_2"></span> Banner</a></li>
        <li><a href="../element/list.php"><span class="white-icons refresh_2"></span> ธาตุ</a></li>
        <li><a href="../category/list.php"><span class="white-icons tags_2"></span> หมวดหมู่</a></li>
        <li><a href="../mobilenetwork/list.php"><span class="white-icons wifi_signal"></span> ค่ายมือถือ</a></li>
        <li><a href="../phonenumber/list.php"><span class="white-icons iphone_3g"></span> เบอร์มือถือ</a></li>
        <!--<li><a href="../sumnumber/list.php"><span class="white-icons note_book"></span> ผลรวมของเบอร์</a></li>-->
        <li><a href="../meaningnumber/list.php"><span class="white-icons books"></span> ความหมายของตัวเลข2หลัก</a></li>
        <li><a href="../article/list.php"><span class="white-icons create_write"></span> บทความ</a></li>
        <li><a href="../faq/list.php"><span class="white-icons speech_bubbles"></span> ถาม-ตอบ</a></li>
        <li><a href="../orders/list.php"><span class="white-icons shopping_cart_3"></span> Order</a></li>
        <!--<li><a href="../transfer/list.php"><span class="white-icons money_2"></span> ยืนยันการโอนเงิน</a></li>-->
        <li><a href="../aboutus/list.php"><span class="white-icons table"></span> เกี่ยวกับเรา</a></li>
        <li><a href="../contactus/list.php"><span class="white-icons phone"></span> ติดต่อเรา</a></li>
        <li><a href="../code/list.php"><span class="white-icons price_tags"></span> รหัสส่วนลด</a></li>
        <li><a href="../expire/list.php"><span class="white-icons month_calendar"></span> ซิมเติมเงินหมดอายุ</a></li>
        <li><a href="../dealerprices/list.php"><span class="white-icons money"></span> ราคา Dealer</a></li>
        <li><a href="../log_reading/list.php"><span class="white-icons file_cabinet"></span> Log ทำนายเบอร์</a></li>
        <li><a href="../member/list.php"><span class="white-icons user"></span> สมาชิก</a></li>
        <li><a href="../admin/list.php"><span class="white-icons admin_user"></span> Admin</a></li>
        <?php
	}
	if($_SESSION["admin_cn_type"] == 2)
	{
		?>
        <li><a href="../phonenumber/list.php"><span class="white-icons iphone_3g"></span> เบอร์มือถือ</a></li>
        <li><a href="../expire/list.php"><span class="white-icons month_calendar"></span> ซิมเติมเงินหมดอายุ</a></li>
        <li><a href="../orderdetail/list.php"><span class="white-icons shopping_cart_3"></span> Order</a></li>
        <?php
	}
	?>
  </ul>
  <?php
    if($_SESSION["admin_cn_type"] == 1)
	{
		?>
        <div id="side-accordion">
    <div class="accordion-group">
      <div class="accordion-header"> <a class="accordion-toggle" data-toggle="collapse" data-parent="#side-accordion" href="#collapseOne"><i class="nav-icon month_calendar"></i> Today's event</a> </div>
      <div id="collapseOne" class="collapse in">
        <div class="accordion-content">
          <ul class="event-list">
            <li>
            <?php
            $day = date('d');
			$today_month = date('n');
			
			
			$today = date("Y-m-d");
			$date = date_create(date("Y-m-d"));
			//date_modify($date, '+5 day');
			//$date5 = date_format($date, 'Y-m-d');
			$day5 = date_format($date, 'j');
			
			if($_SESSION['admin_cn_type'] == 1)
			{
				$search_or = "status = 1 AND date_time >= '".$today." 00:00:00' AND date_time <= '".$today." 23:00:00' ORDER BY id DESC";
				$search_tr = "date_time >= '".$today." 00:00:00' AND date_time <= '".$today." 23:00:00' ORDER BY id DESC";
			}
			
			
			
			?>
              <div class="evnt-date"><?php echo $day; ?><span><?php echo $util_class->m_th_re($today_month); ?></span> </div>
              <?php
				$sql_or = array('table'=>'orders','where'=>$search_or);
				$view_or = $view_db->view($sql_or);
				$result_or = $view_db->q_re($view_or);
				while($row_or = $view_db->q_ro($result_or))
				{
					?>
                     <div class="event-info"> <span><i class="icon-time"></i> <?php echo $util_class->time_h_s($row_or['date_time'])?></span>
                        <p>ใบสั่งซื้อสินค้าเลขที่ &nbsp;#<?php echo substr($row_or['id'],5,6);?> &nbsp; ราคา : <?php echo number_format($row_or['total'], 2, '.', ',');?> ฿</p>
                      </div>
                    <?php
				}
			  ?>
              
               <?php
				$sql_tr = array('table'=>'transfer','where'=>$search_tr);
				$view_tr = $view_db->view($sql_tr);
				$result_tr = $view_db->q_re($view_tr);
				while($row_tr = $view_db->q_ro($result_tr))
				{
					?>
                     <div class="event-info"> <span><i class="icon-time"></i> <?php echo $util_class->time_h_s($row_tr['date_time'])?></span>
                        <p>ยืนยันการโอนเงิน &nbsp;คุณ <?php echo $row_or['name']." ".$row_or['lastname'];?></p>
                      </div>
                    <?php
				}
			  ?>
            </li>
            
          </ul>
          
        </div>
      </div>
    </div>
    
  </div>
        <?php	
	}
  ?>
  
  
</div>