File: /home/pengthai/domains/pengthaicurry.com/public_html/admin/banner/list.php
<?php @session_start(); ?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<?php
include("../include/connect.php");
include("config.inc.php");
include("../include/title.php");
include("../include/chksession.php");
?>s
<link href="../css/style.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" type="text/css" href="../css/bootstrap-theme.css"/>
<link rel="stylesheet" type="text/css" href="../css/bootstrap.css"/>
<link rel="stylesheet" type="text/css" href="../css/font-awesome.css">
<link rel="stylesheet" type="text/css" href="../css/component.css"/>
<script type="text/javascript" src="../js/jquery-1.8.3.js"></script>
<script type="text/javascript" src="../js/bootstrap.js"></script>
<script src="../js/jquery.easing.1.3.js"></script>
<script type="text/javascript" src="../js/modernizr.custom.js"></script>
<script src="../js/jquery-ui-1.9.2.custom.js"></script>
<script>
$(function(){
//INPUT FOCUS
$('.product-list input').not('input[type=checkbox]')
.focus(function(){
$(this).parents('tr').addClass('info');
})
.blur(function(){
$(this).parents('tr').removeClass('info');
});
//CHECK ALL PRODUCR
$('#all-product').click(function(){
var checkBox = $('input[type=checkbox]');
var productRow = $('.product-list').find('tr').not('tr:first');
if($(this).is(":checked") == true )
{
checkBox.prop( "checked",true );
productRow.addClass('warning');
}
else
{
checkBox.prop( "checked",false );
productRow.removeClass('warning');
}
});
//CHECK PRODUCR LIST
$('input[type=checkbox]').not('#all-product').change(function(){
var productRow = $(this).parents('tr');
if($(this).is(":checked") == true )
productRow.addClass('warning');
else
productRow.removeClass('warning');
});
//ADD PRODUCT CATE
$('.add-cate').click(function(){
var cateBox = $(this).parent('.widget-select').next('.widget-inbox-cate');
var addCateBox =cateBox.next('.add-cate-box');
if(cateBox.css('display')=='block')
{
cateBox.hide();
addCateBox.hide();
}
else
{
cateBox.show();
addCateBox.show();
}
});
//CHANGE CLASS SELECT PUBLUSHED
$('.select-publushed').change(function(){
var $publushed = $(this).parent();
var value = $(this).val();
if(value=='1')
$publushed.removeClass('unpublushed').addClass('publushed');
else
$publushed.removeClass('publushed').addClass('unpublushed');
});
//DELETE RECORD
$(".bt-clear").click(function(){
if( confirm('หากต้องการลบ กรุณายืนยันอีกครั้ง')==false )
{
return false;
}
var $chkdel = $(".chk_del");
data = "";
$chkdel.each(function(index, value){
if ($(this).is(":checked")) {
data += $(this).attr("data-id") + "," ;
}
});
if (data != ''){
$.ajax({
type: "POST",
url:"fn_banner.php",
data: {del:data, action:"del-list"},
/* data: $(this).serialize(),*/
dataType: "json",
success: function(data){
if(parseInt(data.stat) == 1){
alert(data.txt);
location.reload();
}
else
alert(data.txt);
}
});
}
return false;
});
//SAVE RECORD
$(".bt-save").click(function(){
var param ="";
var need_id ;
var need_sort ;
var need_show;
var need_name;
$(".chk_show").each(function(index){
need_id = $(this).attr("data-id");
need_show = $(this).val();
need_sort =$(".bann_sort").eq(index).val();
need_name =$(".bann_name").eq(index).val();
param += need_id + ";;";
param += need_sort + ";;";
param += need_show + ";;";
param += need_name + "||";
});
if (param != ''){
$.ajax({
type: "POST",
url:"fn_banner.php",
data : {save:param, action:"save-list"},
dataType: "json",
success: function(data){
alert(data.txt);
if (parseInt(data.stat) == 1)
location.reload();
}
});
}
});
//เปลี่ยนจำนวนการแสดงสินค้าต่อหน้า
$('.show-rec-no').change(function(){
var value = $(this).val();
window.location.href = value;
});
});
</script>
</head>
<body>
<div id="header" class="row">
<div class="col-xs-12 col-sm-6 col-md-6">
<?php
include("../include/header-left-menu.inc.php");
include("../include/function.php");
?>
</div>
</div>
<div id="main-content" class="page-product">
<div class="title">
<?=$obj_item?>
<ul class="tool">
<li><button class="bt-clear"><i class="fa-trash"></i> ลบ</button></li>
<li><button class="bt-save">บันทึก</button></li>
</ul>
</div>
<ol class="breadcrumb margin0">
<li><?=$obj_list_main?></li>
<li><?=$obj_list_system?></li>
<li><?=$obj_list_item?></li>
</ol>
<!-- <div class="alert alert-warning" role="alert"> บลา บลา บลา .... </div>-->
<?php
$noPg = $_GET['no-pg'];
if(empty($noPg))
$noPg=10;
$numrec_per_page = $noPg; //กำหนดแสดงกี่เรคคอร์ดต่อ 1 หน้า
$showpage = $_GET[pg];
if( $showpage == "" or $showpage <= 0 )
$showpage = 1;
$start = ($showpage-1)*$numrec_per_page;
$search_status=$_GET['search_status'];
$search_title=$_GET['search_title'];
if($search_title!="" || $search_status!="")
{
$where =" where ";
if($search_title!="")
$where .=" bann_name_th LIKE '%$search_title%' OR bann_name_en LIKE '%$search_title%' and";
if($search_status!="")
$where .=" bann_status='$search_status' and ";
$where = substr($where, 0, strrpos($where, "and"));
}
$sql="SELECT *, IF(bann_sort=0,99999,bann_sort) AS order2 FROM tb_banner $where ORDER BY order2 LIMIT $numrec_per_page OFFSET $start";
$sqlall="SELECT * FROM tb_banner $where";
$result=mysql_queryx($sql);
$rec=mysql_num_rowsx($result);
$resultall=mysql_queryx($sqlall);
$allrec=mysql_num_rowsx($resultall);
?>
<div class="h10"></div>
<div class="alert alert-info list-search" role="alert">
<form action="list.php" method="get" id="Form1" enctype="multipart/form-data">
<input name="no-pg" type="hidden" value="<?=$noPg?>"/>
<i class="fa-caret-square-o-right"></i> <strong>ชื่อ </strong> : <input type="text" name="search_title" value="<?=$search_title?>"> |
<i class="fa-heart"></i> สถานะ </strong> :
<select name="search_status"><option value="">ทุกสถานะ</option>
<option value="1" <? if($search_status==1) echo"selected"; ?>>ใช้งาน</option>
<option value="0" <? if($search_status=='0') echo"selected"; ?>>ไม่ใช้งาน</option>
</select> |
<button class="bt-search"><strong><i class="fa-search"></i> ค้นหา</strong></button>
</form>
</div>
<ul class="records-info">
<li><a href="index.php"><button class="btn btn-info">เพิ่มแบนเนอร์</button></a> </li>
<?php
$post_param="&search_status=$search_status&search_title=$search_title";
$allnumpage = ceil($allrec/$numrec_per_page); //ceil ปัดเศษขึ้นเสมอ
echo "<li>".$main_admin['page']." </li>";
//ถอยหลังทีละหนึ่งหน้า
$prevpage = $showpage-1;
if( $prevpage <= 0 )
echo " <a class='bt-prev'><i class='fa-caret-left'></i></a> ";
else
echo " <a href='list.php?pg=$prevpage$post_param&no-pg=$noPg' class='bt-prev'><i class='fa-caret-left'></i></a> ";
//แสดงตัวเลขหน้า + - 3 หน้า
$runpagestart = $showpage-0;
if( $runpagestart <= 0 )
$runpagestart = 1;
$runpagestop = $showpage+0;
if( $runpagestop > $allnumpage )
$runpagestop = $allnumpage;
//echo $runpagestart; echo $runpagestop;
for( $x=0 ; $x < ($runpagestop-$runpagestart+1) ; $x++ )
{
$count = $x+$runpagestart;
if( $count==$showpage )
{
echo '<input type="text" size="3" value="'.$count.'" disabled/>';
}
else
{
echo '<input type="text" size="3" value="'.$count.'" disabled/>';
}
}
//เดินหน้าทีละหนึ่งหน้า
$nextpage = $showpage+1;
if( ($showpage*$numrec_per_page) >= $allrec )
echo " <a class='bt-next'><i class='fa-caret-right'></i></a> ";
else
echo " <a href='list.php?pg=$nextpage$post_param&no-pg=$noPg' class='bt-next'><i class='fa-caret-right'></i></a>";
echo " จาก $allnumpage หน้า";
?>
<li> <strong>|</strong> </li>
<li> หน้าละ
<select class="show-rec-no">
<option value="list.php?pg=<?=$count.$post_param?>&no-pg=10" <? if($noPg=='10') echo "selected"; else echo""; ?>>10</option>
<option value="list.php?pg=<?=$count.$post_param?>&no-pg=20" <? if($noPg=='20') echo "selected"; else echo""; ?>>20</option>
<option value="list.php?pg=<?=$count.$post_param?>&no-pg=50" <? if($noPg=='50') echo "selected"; else echo""; ?>>50</option>
<option value="list.php?pg=<?=$count.$post_param?>&no-pg=100" <? if($noPg=='100') echo "selected"; else echo""; ?>>100</option>
</select> แถว </li>
<li> <strong>|</strong> </li>
<li>พบทั้งหมด <strong><?=$allrec?></strong> รายการ</li>
</ul>
<div class="h10"></div>
<div class="scroll-x">
<table class="table table-bordered product-list">
<tr>
<th width="40px"><input type="checkbox" name="all-product" id="all-product" class="css-checkbox" /><label for="all-product" class="css-label"></label></th>
<th width="8%">อันดับ</th>
<th>รูปภาพ <span class="lang">TH</span></th>
<th>รูปภาพ <span class="lang">EN</span></th>
<!--<th width="25%">ชื่อ</th>-->
<th width="45%">ลิงก์</th>
<!--<th width="25%">แก้ไขล่าสุด</th>-->
<th width="10%">สถานะ</th>
<th width="10%">แก้ไข</th>
</tr>
<?
$count=1;
while($result && $r=mysql_fetch_arrayx($result))
{
$bann_id=sprintf("%d",$r['bann_id']);
$bann_name_th=$r['bann_name_th'];
$bann_name_en=$r['bann_name_en'];
$bann_link=$r['bann_link'];
$bann_link_en=$r['bann_link_en'];
$bann_image=$r['bann_image'];
$bann_image_en=$r['bann_image_en'];
$bann_status=$r['bann_status'];
$bann_sort=$r['bann_sort'];
if($bann_status==1)
$publushed="publushed";
else
$publushed="unpublushed";
?>
<tr>
<td>
<input type="checkbox" name="product-<?=$count?>" id="product-<?=$count?>" class="chk_del css-checkbox <?=$class_hidden?>" data-id='<?=$bann_id?>' value='<?=$bann_id?>'/>
<label for="product-<?=$count?>" class="css-label <?=$class_hidden?>"></label>
</td>
<td align="center"><input name="sort" value="<?=$bann_sort?>" size="3" class="text-center bann_sort"/></td>
<td align="center">
<?php
if($bann_image!="")
echo"<img src='../../album/banner/$bann_image' width='200px'/>";
else
echo"ไม่มีรูปภาพ";
?>
</td>
<td align="center">
<?php
if($bann_image_en!="")
echo"<img src='../../album/banner/$bann_image_en' width='200px'/>";
else
echo"ไม่มีรูปภาพ";
?>
</td>
<td>
<div><span class="lang">TH</span> : <?=$bann_link?></div>
<div><span class="lang">EN</span> : <?=$bann_link_en?></div>
</td>
<td align="center">
<div class="<?=$publushed?>">
<select class="select-publushed chk_show" data-id='<?=$bann_id?>'>
<option value="1" class="black" <? if($bann_status==1) echo "selected";?>>ใช้งาน</option>
<option value="0" class="black" <? if($bann_status==0) echo "selected";?>>ไม่ใช้งาน</option>
</select>
</div>
</td>
<td colspan='6' align='center'><a href="index.php?id=<?=$bann_id?>" class="bt-edit"><i class="fa-pencil"></i> แก้ไข</a></td>
</tr>
<?
$count++;
}
if($allrec=='0')
echo"<tr><td colspan='9' align='center'>ไม่พบข้อมูล</td></tr>";
?>
</table>
</div>
<ul class="records-info records-info-bottom">
<?
$allnumpage = ceil($allrec/$numrec_per_page); //ceil ปัดเศษขึ้นเสมอ
echo "<li>".$main_admin['page']." </li>";
//ถอยหลังทีละหนึ่งหน้า
$prevpage = $showpage-1;
if( $prevpage <= 0 )
echo " <a class='bt-prev'><i class='fa-caret-left'></i></a> ";
else
echo " <a href='list.php?pg=$prevpage&search_cate=$search_cate&search_status=$search_status&search_title=$search_title&no-pg=$noPg' class='bt-prev'><i class='fa-caret-left'></i></a> ";
//แสดงตัวเลขหน้า + - 3 หน้า
$runpagestart = $showpage-0;
if( $runpagestart <= 0 )
$runpagestart = 1;
$runpagestop = $showpage+0;
if( $runpagestop > $allnumpage )
$runpagestop = $allnumpage;
//echo $runpagestart; echo $runpagestop;
for( $x=0 ; $x < ($runpagestop-$runpagestart+1) ; $x++ )
{
$count = $x+$runpagestart;
if( $count==$showpage )
{
echo '<input type="text" size="3" value="'.$count.'" disabled/>';
}
else
{
echo '<input type="text" size="3" value="'.$count.'" disabled/>';
}
}
//เดินหน้าทีละหนึ่งหน้า
$nextpage = $showpage+1;
if( ($showpage*$numrec_per_page) >= $allrec )
echo " <a class='bt-next'><i class='fa-caret-right'></i></a> ";
else
echo " <a href='list.php?pg=$nextpage&search_cate=$search_cate&search_status=$search_status&search_title=$search_title&no-pg=$noPg' class='bt-next'><i class='fa-caret-right'></i></a>";
echo " จาก $allnumpage หน้า";
?>
<li> <strong>|</strong> </li>
<li> หน้าละ
<select class="show-rec-no">
<option value="list.php?pg=<?=$count.$post_param?>&no-pg=10" <? if($noPg=='10') echo "selected"; else echo""; ?>>10</option>
<option value="list.php?pg=<?=$count.$post_param?>&no-pg=20" <? if($noPg=='20') echo "selected"; else echo""; ?>>20</option>
<option value="list.php?pg=<?=$count.$post_param?>&no-pg=50" <? if($noPg=='50') echo "selected"; else echo""; ?>>50</option>
<option value="list.php?pg=<?=$count.$post_param?>&no-pg=100" <? if($noPg=='100') echo "selected"; else echo""; ?>>100</option>
</select> แถว </li>
<li> <strong>|</strong> </li>
<li>พบทั้งหมด <strong><?=$allrec?></strong> รายการ</li>
</ul>
<div class="tool-bottom col-xs-12">
<ul>
<li><button class="bt-save">บันทึก</button></li>
<li><button class="bt-clear"><i class="fa-trash"></i> ลบ</button></li>
</ul>
</div>
</div><!--main-content-->
</body>
</html>