<?php include('../include/class.php');?>
 <link href="../css/style.css" rel="stylesheet">
<link rel="stylesheet" href="../include/infiniteajaxscroll/default.min.css">

<div class="container_2">

<?php
$g_page = $_GET['p'];
$limit = ($g_page-1)*30;
/**/
$secrch = 'status = 1 AND status_number = 1 AND category_type =  2'. ' AND expirationdate >= "'.date("Y-m-d").'"';

$list = array('table'=>'phonenumber','where'=>$secrch,'order'=> "ORDER BY id DESC LIMIT ".$limit.",30");
$view = $view_db->view($list);
$result = $view_db->q_re($view);
$num = 1;
while($row_sb = $view_db->q_ro($result))
{

	?>
		<div class="col-md-4 col-sm-6 col-xs-6 item_search" style="margin-bottom:10px;border:0px solid #FFF;min-height:123px;">
        <div class="box_ber">
         <a href='../reading/detail.php?phonenumber=<?php echo $row_sb['phonenumber']?>' style="color:#FFF;text-decoration:none;" target="_blank">
            <table width="100%" border="1" class="tb_ber">
              <tr>
                <td colspan="4" style="font-size:20px;font-weight:bold;background-color:#372459;" align="center"><?php echo $Phone_class->phonenumber($row_sb['phonenumber']);?></td>
              </tr>
              <tr>
              <?php $element = $Phone_class->element_text_img($row_sb['element_id']);?>
                <td> ธาตุ<?php echo $element['name']?></td>
                <td><img src="../redbag/element/<?php echo $element['img']?>" width="20" height="20"></td>
                <td>ผลรวม</td>
                <td>(<?php echo $row_sb['sum_number']?>)</td>
              </tr>
              <tr>
                <td colspan="3" style="padding-left:15px;">
                <?php
                    if($row_sb['category_type']==2)
                    {
                        $short_number = $Phone_class->catshort_number($id_cat,$row_sb['phonenumber']);
                        echo $short_number;
                    }
                    else
                    {
                        echo 'เบอร์สวย';
                    }
                ?>
                </td>

                <td><img src="../redbag/mobilenetwork/<?php echo $Phone_class->mobilenetwork_img($row_sb['mobilenetwork']);?>" width="38" height="19"></td>
              </tr>
              <tr>
               <?php
              if($row_sb['statusprice'] == 1)
              {
                 $price = $row_sb['price'];
              }
              else
              {
                  $price = 'xxxx';
              }
              ?>
              <td colspan="3" class="tb_ber_price"><?php echo $price;?> บาท</td>
              <td colspan="3" class="tb_ber_next" style="cursor:pointer" title="รายละเอียด" onClick="location.href='../reading/detail.php?phonenumber=<?php echo $row_sb['phonenumber']?>'"> >> </td>
              </tr>
            </table>
            </a>
        </div>
        </div>
	<?php

}
?>
</div>

<?php
$list = array('table'=>'phonenumber','where'=>$secrch,'order'=> "ORDER BY id DESC");
$view = $view_db->view($list);
$result = $view_db->q_re($view);
$rowcount = mysqli_num_rows($result);
$row_page = $rowcount/30;
$row_page = ceil( $row_page);
?><ul id="pagination" style="display:none;"><?php
for($i=1;$i<=$row_page;$i++)
{
	if($i==1){?><li><a href="../phonenumber/index.php">2</a></li><?php }
	else
	{
		?><li <?php if($i==$_GET['p']+1){ ?>class="next_search"<?php }?>><a href="../phonenumber/phonenumber_load.php?p=<?php echo $i; ?>">2</a></li><?php
	}
}

?>
</ul>
<script src="../include/infiniteajaxscroll/jquery.min.js"></script>
  <script type="text/javascript" src="../include/infiniteajaxscroll/jquery-ias.min.js"></script>
  <script type="text/javascript">
    var ias = $.ias({
      container: ".container_2",
      item: ".item_search",
      pagination: "#pagination",
      next: ".next_search a"
    });

    ias.extension(new IASSpinnerExtension());
    ias.extension(new IASTriggerExtension({offset: 50}));
    ias.extension(new IASNoneLeftExtension({text: ''}));
  </script>