<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="../wallpaper/list.php"><span class="white-icons image_2"></span> Wallpaper</a></li>
        <li><a href="../banner/list.php"><span class="white-icons image_2"></span> Banner</a></li>
        <li><a href="../zodiac/list.php"><span class="white-icons image_2"></span> ราศี</a></li>
        <li><a href="../element/list.php"><span class="white-icons image_2"></span> ธาตุ</a></li>
        <li><a href="../category/list.php"><span class="white-icons image_2"></span> หมวดหมู่</a></li>
        <li><a href="../category_supplement/list.php"><span class="white-icons image_2"></span> หมวดหมู่เสริม</a></li>
        <li><a href="../number/list.php"><span class="white-icons image_2"></span> ชุดตัวเลข</a></li>

        <li><a href="../order/list.php"><span class="white-icons image_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="../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="../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>