| Server IP : 172.67.216.113 / Your IP : 172.71.28.145 [ Web Server : Apache System : Linux cpanel01wh.bkk1.cloud.z.com 2.6.32-954.3.5.lve1.4.59.el6.x86_64 #1 SMP Thu Dec 6 05:11:00 EST 2018 x86_64 User : cp648411 ( 1354) PHP Version : 7.2.34 Disable Function : NONE Domains : 0 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home2/cp648411/public_html/simded.com/mybackend/phonenumber/ |
Upload File : |
<?php require_once("../include/class.php");?>
<?php require_once("../include/header.php");?>
<?php require_once("../include/nav_top.php");?>
<?php require_once("../include/sidebar.php");?>
<?php include("table_name.php");?>
<div id="main-content">
<div class="container-fluid">
<ul class="breadcrumb">
<li><a href="../<?php echo $name_folder; ?>/list.php"><?php echo ucfirst($name_table) ?></a><span class="divider">»</span></li>
<li class="active">List <a href="add.php"><i class="icon-plus"></i> Add New</a></li>
</ul>
<div class="row-fluid">
<div class="span12">
<div class="widget-block">
<div class="widget-head">
<h5>List</h5>
<div class="widget-control pull-right">
<a href="../<?php echo $name_folder ?>/list.php" data-toggle="dropdown" class="btn dropdown-toggle"><i class="icon-cog"></i><b class="caret"></b></a>
<ul class="dropdown-menu">
<li><a href="add.php"><i class="icon-plus"></i> Add New</a></li>
<!--<li><a href="addcsv.php"><i class="icon-plus"></i> Add file.csv</a></li>-->
</ul>
</div>
</div>
<div class="widget-content">
<div class="widget-box">
<?php
if($_SESSION['er']=='true')
{
?>
<div class="alert alert-success fade in">
<button data-dismiss="alert" class="close" type="button">×</button>
<strong>Save</strong>
</div>
<?php
}
if($_SESSION['er']=='de_true')
{
?>
<div class="alert alert-success fade in">
<button data-dismiss="alert" class="close" type="button">×</button>
<strong>Clear </strong>
</div>
<?php
}
if($_SESSION['er']=='false')
{
?>
<div class="alert alert-error fade in">
<button data-dismiss="alert" class="close" type="button">×</button>
<strong>system crashes</strong>
</div>
<?php
}
?>
<?php
$max_rows = 12; // แสดงจำนวนแถวต่อหน้า
$page_number = 0;
if(isset($_GET['page_number']))
{
$page_number = $_GET['page_number'];
}
$sql_s = ' id > 0';
if(@$_GET['ferret']!=''){
$sql_nw1 = array('table'=>'mobilenetwork','where'=>"name = '".@$_GET['ferret']."'");
$view_nw1 = $view_db->view($sql_nw1);
$result_nw1 = $view_db->q_re($view_nw1);
$total__nw1 = $view_db->q_nr($all_result);
$row_nw1 = $view_db->q($view_nw1);
if($result_nw1>0){
$sql_s = $sql_s. ' AND mobilenetwork = "'.@$row_nw1['id'].'"';
}else {
$sql_s = $sql_s. ' AND phonenumber LIKE "%'.@$_GET['ferret'].'%" ';
}
}
$all_array = array('table'=>$name_table,'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 = $view_db->q_nr($all_result);
$total_pages = ceil($total_rows/$max_rows)-1;
////////////////////////////////////////
$list = array('table'=>$name_table,'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);
$num_o=1;
/*
echo $all_sql;
echo '<br>';
echo $view;
*/
?>
<form class="" action="list.php" method="get">
<div class="form-header-search">
<div style="padding:15px;color:#F00;">Item number : <?php echo $total_rows_num;?> list</div>
<div style="margin-right: 18px;">
<input type="text" name="ferret" class="form-control" placeholder="Search" style="margin-bottom: 0px;">
<button type="submit" class="btn btn-success">Search</button>
<button type="button" class="btn btn-danger">Clear</button>
</div>
</div>
</form>
<div class="table-responsive">
<table class="table table-hover" style="font-size:12px;">
<thead>
<tr>
<th width="5%">
No.
</th>
<th width="15%">
หมายเลขโทรศัพท์
</th>
<th width="5%">
เครือข่าย
</th>
<th width="10%">
ราคา
</th>
<th width="10%">
By
</th>
<th width="7%">
วันที่
</th>
<th width="7%">
การจัดการ
</th>
</tr>
</thead>
<tbody>
<?php
while($row = $view_db->q_ro($result))
{
$phonenumber = $Phone_class->format_phonenumber($row['phonenumber'],$row['format']);
$list_shr = array('table'=>'shop','where'=>'id = "'.$row['id_shop'].'" ');
$view_shr = $view_db->view($list_shr);
$row_shr = $view_db->q($view_shr);
?>
<tr>
<td><?php echo $num; ?>. </td>
<td><?php echo $phonenumber; ?> (<?php echo $row['total']; ?>)</td>
<td>
<?php
$row_mobilenetwork = $actiondata_db->q_one('mobilenetwork','id = "'.$row['mobilenetwork'].'"','image');
?>
<img src="<?php echo $upload ?>mobilenetwork/<?php echo $row_mobilenetwork ?>" width="30">
</td>
<td><?php echo number_format($row['price'])?> ฿ </td>
<td>
<?php echo $row_shr['nameShop']; ?>
<img src="<?php echo $upload ?>file_manage/<?php echo $row_shr['image_profile'] ?>" width="30">
</td>
<td><?php echo $util_class->day_m_th_re($row['up_date']) ?></td>
<td>
<a href="edit.php?id=<?php echo $row['id']?>" title="Edit<?php echo $num; ?>"><i class="black-icons pencil"></i></a>
<a onClick="if(!confirm('Confirm the deletion permanent ?')){return false;}" href="delete.php?id=<?php echo $row['id']?>" title="Delete<?php echo $row['name_th']; ?>"><i class="black-icons trashcan"></i></a>
</td>
</tr>
<?php
$num++;
}
?>
</tbody>
</table>
<div >
<div class="row" align="center" style="margin-top:30px;">
<div class="col-md-12 BerDedToday-page">
<?php
if($total_rows_num > 0)
{
$get = (@$_GET['ferret']!='')?'&ferret='.@$_GET['ferret']:'';
page_news($page_number,$total_pages,'list.php',$get);
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php unset($_SESSION['er']);?>
<?php require_once("../include/footer_js.php");?>
</body>
</html>