<?php
include('../include/header.php');
include('../themes/menu.php');


$sql_s = 'status = 1';

$max_rows = 8; // แสดงจำนวนแถวต่อหน้า
$page_number = 0;
if(isset($_GET['page_number']))
{
	 $page_number = $_GET['page_number'];
}

$all_array =  array('table'=>'article','where'=>$sql_s);
$start_row = $page_number * $max_rows;
$all_sql = $view_db->view($all_array);
$all_result = $view_db->q_re($all_sql);
$total_rows = $view_db->q_nr($all_result);
$total_rows_num = mysql_num_rows($all_result);
$total_pages = ceil($total_rows/$max_rows)-1;
////////////////////////////////////////
$list = array('table'=>'article','where'=>$sql_s, 'limit'=> "$start_row,$max_rows",'order'=> "ORDER BY id DESC");
$view = $view_db->view($list);
$result = $view_db->q_re($view);
$num_tr = 1;
$num = 1+($page_number*$max_rows);
?>


    <div class="container">
      <div class="row">
        <div class="col-md-12">

          <div style="margin-top:30px;">
            <div class="row">
                <div class="col-md-12" style="margin-bottom:5px;">
                    <p class="HeadTextL">บทความ</p>
                </div>
            </div>

            <div class="row">
                <div class="col-md-6" style="margin-bottom:5px;">
                    <p style="font-size:22px;">พบทั้งหมด <?php echo number_format($total_rows_num);?> บทความ</p>
                </div>


              <!--  <div class="col-md-6 BerDedToday-page" align="right">
                    <?php
                   /* if($total_rows_num > 0)
                    {
                       page_news($page_number,$total_pages,'index.php','');
                    }*/
                    ?>
                  </div>-->

            </div>
            <?php
            while($row = $view_db->q_ro($result))
            {
              ?>
              <div class="col-md-12" style="margin-top:15px;">
                <div class="row">
                  <div class="col-md-12">
                    <div class="DivprofileR-Head"> หัวข้อ : <?php echo $row['title'];?> </div>
                    <div class="DivprofileR-Detail">
                    	<p style="font-size:22px;"></p>
                        <span>
                        	<?php echo $util_class->sub_str($row['detail'],200);?>
                            <br>
                        </span>
                        <div style="border-top:1px solid #c8ac52;margin:20px 5px 0px 5px;font-size:12px;">
                        	<div class="row">
                              <div class="col-md-5" align="left" style="padding-top:15px;">
                              	<img src="../images/icon_eye.png" width="40" height="25" /> &nbsp; 50 view &nbsp; &nbsp;
                              	<img src="../images/icon_time.png" width="29" height="25" />&nbsp; <?php echo  $util_class->timedmy_th($row['up_date']); ?>
                              </div>
                              <?php
                                $list_sh = array('table'=>'shop','where'=>'id = "'.$row['id_shop'].'"');
								$view_sh = $view_db->view($list_sh);
								$row_sh = $view_db->q($view_sh);

								$img =  imgprofile_shop($row_sh['image_profile'],'34');
								$txt_phonenumber =  $Phone_class->phonecomma($row_sh['phone']);
							  ?>
                              <div class="col-md-7">
                              	<div class="row">
                                  <div class="col-xs-12 col-md-8"  style="padding:0px;padding-top:5px;">
                                        <div class="col-xs-10" align="right">
                                            <div style="font-size:20px;"><?php echo $row_sh['nameShop']?> </div>
                                            <div>สั่งซื้อเบอร์ติดต่อ <?php echo $txt_phonenumber; ?> </div>
                                        </div>
                                        <div class="col-xs-2" style="text-align:left;padding:0px;padding-top:5px;" align="left">
                                            <?php echo $img; ?>
                                        </div>
                                   </div>
                                   <div class="col-xs-12 col-md-4" align="right"  style="padding:0px;padding-top:10px;padding-right:15px;">
                                    <a href="detail.php?id=<?php echo $row['id']?>" class="btn btn-primary btn_read">Read More</a>
                                   </div>
                                 </div>
                              </div>
                            </div>

                    	</div>
                  	</div>

                  </div>
                </div>
              </div>
              <?php
            }
            ?>
            <br>
            <div class="row" align="right" style="padding-top:25px;">
                <div class="col-md-12">
                    <div class="BerDedToday-page" style="margin-top:20px;">
                        <?php
						if($total_rows_num > 0)
						{
							page_news2($page_number,$total_pages,'index.php','');
						}
						?>
                      </div>
                </div>
            </div>


            </div>

        </div>

      </div><!--/row-->
    </div><!--/.container-->


<?php
include('../themes/footer.php');
include('../include/footer_js.php');
?>