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

$sql_s = 'activate = "1" AND status_op = "1" AND status = "1"'; 

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

$all_array =  array('table'=>'professor','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'=>'professor','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-9" style="margin-top:30px;">
		
            <div class="row">
            <div class="col-md-6" style="margin-bottom:5px;">
                <p class="HeadTextL">อาจารย์ทำนายเบอร์</p>
            </div>
            
            <div class="col-md-6 BerDedToday-page">
			<?php
            if($total_rows_num > 0)
            {
                page_news($page_number,$total_pages,'index.php','');
            }
            ?>
              </div>
            </div>
            
            <div class="row" >
            <?php
            while($row_shi = $view_db->q_ro($result))
            {
              ?>
              <div class="col-md-6">
              <div class="BoxRecom">
                	<div class="row BoxRecom-div">
                      <div class="col-xs-12" style="margin-bottom:15px;"><span class="" style="font-size:30px;">
					   <a href="<?php echo $Url_shop.'prophecy/'.$row_shi['code']?>" target="_blank" style="color:#333;"> 
					   <?php echo $row_shi['nameprophecy']?>
                       </a></span></div>
                        <div class="col-xs-4 PredictProfile" style="padding-left:15px;padding-top:15px">
                         
                        <a href="<?php echo $Url_shop.'prophecy/'.$row_shi['code']?>" target="_blank" style="color:#333;"> 
                        	<?php
							if($row_shi['image_profile']){ $url_imgpro =  $row_shi['image_profile']; }else{ $url_imgpro =  '';}
							?>
                            <?php echo imgprofile_pro($url_imgpro,'100'); ?>
                        </a>
                        </div>
                        <?php
						$txt_phonenumber =  $Phone_class->phonecomma($row_shi['phone']);
						?>
                      <div class="col-xs-8">
                      	<div style="color:#ff0000;font-size:18px;">โทร : <?php echo $txt_phonenumber?></div>
                        <div style="color:#00a651;font-size:18px;">Line : <?php echo $row_shi['lineid'];?></div>
                        <div style="min-height:60px;">
                            <?php echo $util_class->sub_str($row_shi['title'],90)?>
                        </div>
                        <div style="color:#0248bb;"> ดูไปแล้ว : <?php echo number_format($row_shi['view'])?> </div>
                      </div>
                       <div class="col-xs-8" style="margin-top:15px;">
                            <div class="row">
                            <div class="col-xs-2" style="text-align:left;padding-top:5px;" align="left"><img src="../images/b2.jpg" width="34" height="34"></div>
                        	<div class="col-xs-10" align="left">
                                <div style="font-size:18px;"><?php echo $row_shi['nameprophecy']?> </div>
                                <div>เบอร์ติดต่อ <?php echo $txt_phonenumber?> </div>
                            </div>
                            </div>
                        </div>
                        <div class="col-xs-4" style="margin-top:15px;padding-top:15px;" align="right">
                        	<!--ร้านโปรด <img src="../images/icon_Ulike.png" width="24" height="24">-->
                        </div>  
                    </div>
              </div>
              
              </div>
              <?php
            }
            ?>
            <div class="row">
                    <div class="col-md-12 BerDedToday-page">
                         <?php
						if($total_rows_num > 0)
						{
							page_news($page_number,$total_pages,'index.php','');	
						}
						?>
                                        
                    </div>
            </div>
            </div>
        </div>
        <div class="col-md-3" style="margin-top:30px;">
         <?php  include('../themes/banner.php'); ?>
            <?php  include('../themes/teacherpredict.php'); ?> 
            <?php
			  include('../themes/shopright.php');
			  include('../themes/totalnumber.php');
			  include('../themes/price.php');
			  include('../themes/mobilenetwork.php');
			  include('../themes/article.php');
			  include('../themes/facebookpage.php');
		  ?>   
        </div>
      </div><!--/row-->
    </div><!--/.container-->
    
<?php 
include('../themes/footer.php');
include('../include/footer_js.php');
?>