| Server IP : 104.21.37.246 / Your IP : 172.71.28.146 [ 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/expire/ |
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"> phone number expire/ซิมรายเดือน หมดอายุ</a><span class="divider">»</span></li>
<li class="active">List</li>
</ul>
<div class="row-fluid">
<div class="span12">
<div class="widget-block">
<div class="widget-head">
<?php
$date_d = 1;//date('d');
$date_dend = date('t');
$date_m = date('m');
$date_y = date('Y');
$year = $date_y + 543;
$month = $date_m;
if($_POST['year'] <> '')
{
$date_y = $_POST['year']-543;
$year = $_POST['year'];
}
if($_POST['month'] <> '')
{
$month = $_POST['month'];
$date_dend = date( "t", strtotime($date_y."-".$month."-01") );
}
$date_from = $date_y.'-'.$month.'-01';
$date_to = $date_y.'-'.$month.'-'.$date_dend;
$secrch = " typenumber = 1 AND expirationdate >= '".$date_from."' AND expirationdate <= '".$date_to."'";
$list = array('table'=>$name_table,'where'=>$secrch,'order'=> "ORDER BY expirationdate ASC");
$view = $view_db->view($list);
$result = $view_db->q_re($view);
$num_rows = mysql_num_rows($result);
$month_thai = array('1'=>"January / มกราคม","February / กุมภาพันธ์","March / มีนาคม","April / เมษายน",
"May / พฤษภาคม","June / มิถุนายน","July / กรกฎาคม","August / สิงหาคม","September / กันยายน",
"October / ตุลาคม","November / พฤศจิกายน","December / ธันวาคม");
?>
<h5>list : of the month <?php echo $month_thai[$month] . ' ' . $year; ?> </h5>
<div class="widget-control pull-right">
</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
}
?>
<form action="list.php" method="post">
<div style="padding:15px">
Search :
<select name="month">
<?php
for($i=1;$i<=12;$i++)
{
?><option value="<?php echo $i ?>" <?php if($month == $i){?>selected<?php }?>><?php echo $month_thai[$i]?></option><?php
}
?>
</select>
<?php $date_y_th1 = $year + 2;?>
<select name="year">
<?php
for($i=1;$i<=5;$i++)
{
?><option value="<?php echo $date_y_th1-$i ?>" <?php if($year == $date_y_th1-$i){?>selected<?php }?>><?php echo $date_y_th1-$i ?></option><?php
}
?>
</select>
<input type="submit" class="btn" value="search" style="margin-top:-9px;">
</div>
</form>
<div style="padding:15px;color:#F00;">Item number : <?php echo $num_rows;?> list</div>
<table class="data-tbl-boxy table" style="font-size:12px;border:0px solid #F00;">
<thead>
<tr>
<th width="5%">
No.
</th>
<th width="9%">
phone number
</th>
<th width="9%">
Type number
</th>
<th width="9%">
sale price
</th>
<th width="7%">
system
</th>
<th width="7%">
status
</th>
<th width="7%">
status price
</th>
<th width="5%">
status publish
</th>
<th width="5%">
By
</th>
<th width="5%">
expire date
</th>
<th width="5%">
Date
</th>
<th width="5%">
management
</th>
</tr>
</thead>
<tbody>
<?php
$num=1;
while($row = $view_db->q_ro($result))
{
?>
<tr>
<td><?php echo $num; ?>.</td>
<td><?php echo $row['phonenumber']; ?></td>
<td>
<?php if($row['typenumber'] == 1){?>Prepaid / แบบเติมเงิน<?php }?>
<?php if($row['typenumber'] == 2){?>Monthly / แบบรายเดือน<?php }?>
</td>
<td><?php echo $row['price']; ?> ฿ </td>
<td><?php
$sql_nw = array('table'=>'mobilenetwork','where'=>"id = '".$row['mobilenetwork']."'");
$view_nw = $view_db->view($sql_nw);
$row_nw = $view_db->q($view_nw);
?>
<img src="../../upload/mobilenetwork/<?php echo $row_nw['image'] ?>"></td>
<td>
<?php
if($row['status_number'] == 1)
{
?>blank/ ว่าง<?php
}
if($row['status_number'] == 2)
{
?>Sold / ขายแล้ว<?php
}
if($row['status_number'] == 3)
{
?>Are booked / กำลังถูกจอง<?php
}
?>
</td>
<td>
<?php
if($row['statusprice'] == 1)
{
?> <a href="statusprice.php?id=<?php echo $row['id']?>&s=2" title="publish">
<i class="dashboard-icons-colors check_sl"></i></a><?php
}
else
{
?> <a href="statusprice.php?id=<?php echo $row['id']?>&s=1" title="Stop publish">
<i class="dashboard-icons-colors busy_sl"></i></a><?php
}
?>
</td>
<td>
<?php
if($row['status'] == 1)
{
?> <a href="status.php?id=<?php echo $row['id']?>&s=0" title="publish">
<i class="dashboard-icons-colors check_sl"></i></a><?php
}
else
{
?> <a href="status.php?id=<?php echo $row['id']?>&s=1" title="Stop publish">
<i class="dashboard-icons-colors busy_sl"></i></a><?php
}
?>
</td>
<?php
if($_SESSION["admin_cn_type"] == 3)
{
}
else
{
?>
<td>
<?php
$sql_adt = array('table'=>'admin,admin_type','where'=>"admin_type.id = admin.type AND admin.id = '".$row['by_admin']."'");
$view_adt = $view_db->view($sql_adt);
$row_adt = $view_db->q($view_adt);
echo $row_adt['name'] .' / '. $row_adt['username'];
?></td>
<?php
}
?>
<td><?php echo $util_class->day_th_re($row['expirationdate']) ?></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>
</td>
</tr>
<?php
$num++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php unset($_SESSION['er']);?>
<?php require_once("../include/footer_js.php");?>
</body>
</html>