File: /home/pengthai/domains/pengthaicurry.com/public_html/admin/contact/category.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/chksession.php");
include("../include/connect.php");
include("config.inc.php");
include("../include/title.php");
?>
<meta name="keywords" content="www.baanwebsite.com" />
<meta name="description" content="www.baanwebsite.com" />
<meta name="distribution" content="Thailand" />
<meta name="revisit-after" content="7 days" />
<meta name="copyright" content="© 2015 http://www.baanwebsite.com" />
<meta name="robots" content="index,follow" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1">
<link rel="shortcut icon" href="http://www.baanwebsite.com/images/baanwebsite.ico" />
<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(){
//CHECK ALL PRODUCR
$('#all-record').click(function(){
var checkBox = $('input[type=checkbox]');
var recordRow = $('.record-list').find('tr').not('tr:first');
if($(this).is(":checked") == true )
{
checkBox.prop( "checked",true );
recordRow.addClass('warning');
}
else
{
checkBox.prop( "checked",false );
recordRow.removeClass('warning');
}
});
//CHECK PRODUCR LIST
$('input[type=checkbox]').not('#all-record').change(function(){
var recordRow = $(this).parents('tr');
if($(this).is(":checked") == true )
recordRow.addClass('warning');
else
recordRow.removeClass('warning');
});
//SAVE RECORD
$('.bt-add').click(function(){
if($('input[name="cate_name"]').val()=="")
{
$('input[name="cate_name"]').focus();
return false;
}
if($('input[name="cate_name_en"]').val()=="")
{
$('input[name="cate_name_en"]').focus();
return false;
}
$('#form1').submit();
});
//DELETE RECORD
$(".del-cate").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") + "," ;
}
});
console.log(data);
if (data != ''){
$.ajax({
type: "POST",
url:"fn_save.php",
data: {del:data, action:"del-cate"},
dataType: "json",
success: function(data){
if (data.stat == 1)
{
alert(data.txt);
location.reload();
}
else
alert(data.txt);
}
});
}
return false;
});
$('.sort_input').blur(function(){
var no = $(this).val();
var id = $(this).parent().prev().find('.chk_del').attr("data-id");
$.ajax({
type: "POST",
url:"fn_save.php",
data: {id:id, action:"edit-cate", no:no},
dataType: "json",
success: function(data){
if (data.stat == 1)
{
alert(data.txt);
location.reload();
}
else
alert(data.txt);
}
});
});
//delect image
$('.bt-del-image').click(function(){
var id = $(this).attr("data-id");
var file = $(this).attr("data-file");
if( confirm('หากต้องการลบ กรุณายืนยันอีกครั้ง')==false )
{
return false;
}
$.ajax({
type: "POST",
url:"fn_save.php",
data : {id:id, file:file, action:"del-cate-image"},
dataType: "json",
success: function(data){
alert(data.txt);
if (parseInt(data.stat) == 1)
location.reload();
}
});
});
//script Browes files Images
var $fileImages =$('.browes-image');
$('.add-img').click(function(){
$('input[name="add_image[]"]').click()
});
$('input[name="add_image[]"]').change(function(){
show_image(this);
});
//script Browes files PDF
$('.add-pdf').click(function(){
$('input[name="file_array1"]').click()
});
$('input[name="file_array1"]').change(function(){
show_PDF(this);
});
//script Browes files PDF
function show_image(inputFile) {
if(inputFile.files && inputFile.files[0]) {
$('.add-img').parent().find('.review-pic').remove();
for($i=0;$i<inputFile.files.length;$i++){
var reader_file = new FileReader();
reader_file.onload = function (e) {
$('.add-img').find('img').remove()
$('.add-img').append("<img src='"+e.target.result+"' width='100%'/>");
$('.add-img').find('.text').text("เปลี่ยนรูป")
$('.add-img').css({"padding-top":0, "padding-bottom":0}).find('img').attr('src', e.target.result).removeClass('hidden').width('100%').siblings('span').hide();
};
reader_file.readAsDataURL(inputFile.files[$i]);
}
}
}
//CHANGE CLASS SELECT PUBLUSHED
$('.select-publushed').change(function(){
var $publushed = $(this).parent();
var value = $(this).val();
var id = $(this).attr("data-id");
var tb = $(this).attr("data-tb");
$.ajax({
type: "POST",
url:"fn_save.php",
data : {id:id, value:value, tb:tb,action:"save-show"},
dataType: "json",
success: function(data){
if (parseInt(data.stat) == 1)
{
if(value=='1')
$publushed.removeClass('unpublushed').addClass('publushed');
else
$publushed.removeClass('publushed').addClass('unpublushed');
// alert(data.txt);
location.reload();
}
}
});
});
});
</script>
</head>
<body>
<div id="header" class="row">
<div class="col-xs-12 col-sm-6 col-md-6">
<?
include("config.inc.php");
$current_page= $current_page ;
include("../include/header-left-menu.inc.php");
$id=$_GET['id'];
?>
</div>
</div>
<div class="h20"></div>
<div id="main-content" class="page-product">
<div class="title"><?=$topic_titlecate?> </div>
<ol class="breadcrumb margin0">
<li><i class="<?=$icon_main?>"></i> <a href="<?=$server_name?>/dashboard.php"><?=$topic_main?></a></li>
<!--<li><i class="<?=$icon_system?>"></i> <a href="<?=$server_name?>/<?=$path_system?>/list.php"><?=$topic_system?></a></li>-->
<li class="active"><i class="<?=$icon_category?>"></i> <?=$topic_titlecate?> </li>
</ol>
<div class="col-xs-12 col-sm-12 col-md-4 col-lg-4">
<div class="widget-box-turquoise">
<div class="widget-title" lang="th"><i class="fa-cubes"></i> <? if(empty($id)) echo "เพิ่ม"; else echo "แก้ไข"; ?><?=$topic_catemainobj?></div>
<ul class="widget-tool navbar-right">
<li><i class="fa-caret-up show-hide-widget"></i></li>
</ul>
<div class="widget-inbox">
<form action="fn_save.php" method="post" id="form1" enctype="multipart/form-data">
<?php
if(!empty($id))
{
$sql="SELECT * FROM $table_cate WHERE cate_id='$id' ";
$result=mysql_queryx($sql);
$r=mysql_fetch_arrayx($result);
$cate_name=$r['cate_name'];
$cate_name_en=$r['cate_name_en'];
$cate_main=$r['cate_main'];
$cate_images=$r['cate_images'];
$cate_show=$r['cate_show'];
$cate_showhome=$r['cate_showhome'];
$cate_type=$r['cate_type'];
$cate_name_en = str_replace("′","'",$cate_name_en);//single coil
//$cate_name_en = str_replace('"','"',$cate_name_en);//double coil
$cate_name = str_replace("′","'",$cate_name);//single coil
//$cate_name = str_replace('"','"',$cate_name);//double coil
}
?>
<div class="form-box">
<div class="form-group">
<label class="control-labe">ชื่อหมวดหมู่ <span class="lang">TH</span> </label>
<input type="text" class="form-control" placeholder="" name="cate_name" value="<?=$cate_name?>">
</div>
<div class="cleaner"></div>
<div class="form-group">
<label class="control-labe">ชื่อหมวดหมู่ <span class="lang">EN</span> </label>
<input type="text" class="form-control" placeholder="" name="cate_name_en" value="<?=$cate_name_en?>">
</div>
<div class="cleaner"></div>
<div class="form-group">
<ul class="main-cate">
<li class="padding5">แสดงหน้าเว็บไซต์ :
<div class="switch">
<input id="cmn-toggle-1" class="cmn-toggle cmn-toggle-round-flat" type="checkbox" value="1" name="status" <? if($cate_show==1||$cate_show=="") echo"checked"; ?>>
<label for="cmn-toggle-1"></label>
</div>
</li>
<li class="padding5">แสดงหน้าแรก:
<div class="switch">
<input id="cmn-toggle-2" class="cmn-toggle cmn-toggle-round-flat" type="checkbox" value="1" name="status_show" <? if($cate_showhome==1||$cate_showhome=="") echo"checked"; ?>>
<label for="cmn-toggle-2"></label>
</div>
</li>
</ul>
</div>
<div class="form-group display-none">
<label class="control-labe">รูปแบบการแสดงผล </label>
<select class="form-control" name="cate_type">
<option value="1" <?php if($cate_type == "1"){echo "selected";} ?>>บทความ</option>
<option value="2" <?php if($cate_type == "2"){echo "selected";} ?>>ฟอร์ม</option>
<option value="3" <?php if($cate_type == "3"){echo "selected";} ?>>FAQ</option>
</select>
</div>
<div class="cleaner"></div>
<!--<div class="form-group">
<label class="control-labe">รูปภาพหมวดหมู่ </label>
<div class="product-images">
<div class="add-img">
<span><i class="fa-image"></i><a class="text">เลือกรูปภาพ</a></span>
</div>
<?php
if(!empty($id)){
if($cate_images!="")
echo "<div class='del-image bg_pic' data-id='$imag_id'>
<i class='fa fa-remove bt-del-image' data-id='$id' data-file='$cate_images'></i>
<img src='../../album/category/small/$cate_images' width='100%' alt='$gall_name'/>
<span class='index'>$imag_sort</>
</div>";
else
echo "<div class='del-image bg_pic' data-id='$imag_id'>
<i class='fa fa-remove bt-del-image' data-id='$imag_id' data-file='$imag_file'></i>
<img src='../../images/nopic.png' width='100%' alt='nopic'/>
</div>";
}
?>
<input class="browes-image hidden" name='add_image[]' type="file">
<div class="cleaner h10"></div>
</div>
</div>-->
<div class="cleaner h10"></div>
<input type="hidden" name="action" value="add-cate"/>
<input type="hidden" name="id" value="<?=$id?>"/>
<!-- <input type="hidden" name="showindex" value="<?=$cate_showhome?>"/>-->
<?php
if(!empty($id))
{
echo "<div class='form-box'><a class='bt-add bt-edit2'>แก้ไข</a> ";
echo " <a href='category.php' class='bt-new'>เพิ่มใหม่</a></div>";
}
else
echo "<div class='form-box'><a class='bt-add'>+ เพิ่ม</a></div>";
?>
<div class="clearfix"></div>
</div>
</form>
</div><!--widget-inbox-->
</div><!--widget-box-->
</div>
<div class="col-xs-12 col-sm-12 col-md-8 col-lg-8">
<div class="widget-box-grey">
<div class="widget-title" lang="th"><i class="fa-list"></i> <?=$topic_listcatemainobj?></div>
<ul class="widget-tool navbar-right">
<li><i class="fa-trash del-cate"></i></li>
<li><i class="fa-caret-up show-hide-widget"></i></li>
</ul>
<div class="widget-inbox">
<div class="scroll-y">
<table class="table table-bordered record-list">
<tr>
<th width="5%"><input type="checkbox" name="all-record" id="all-record" class="css-checkbox" /><label for="all-record" class="css-label"></label></th>
<th width="8%">อันดับ</th>
<!--<th width="15%">รูปภาพ</th>-->
<th width="30%">ชื่อหมวดหมู่ <!--<span class="lang">TH</span>--> </th>
<!--<th width="30%">ชื่อหมวดหมู่ <span class="lang">EN</span> </th>
<th width="15%">หมวดหมู่ย่อย</th>-->
<th align="center" width="10%">แสดงผล </th>
<th align="center" width="10%">แสดงหน้าแรก </th>
<th width="10%"><!--แก้ไข--><?=$main_admin['edit']?></th>
</tr>
<?
$sql="SELECT *, IF(cate_sort=0,999999,cate_sort) AS sort FROM $table_cate WHERE cate_main = 0 ORDER BY sort";
$result=mysql_queryx($sql);
$count=1;
while($result && $r=mysql_fetch_arrayx($result))
{
$cate_id=sprintf("%d",$r['cate_id']);
$cate_name=$r['cate_name'];
$cate_name_en=$r['cate_name_en'];
$cate_sort=$r['cate_sort'];
$cate_images=$r['cate_images'];
$cate_status=$r['cate_show'];
$cate_showhome=$r['cate_showhome'];
$cate_name_en = str_replace("′","'",$cate_name_en);//single coil
//$cate_name_en = str_replace('"','"',$cate_name_en);//double coil
$cate_name = str_replace("′","'",$cate_name);//single coil
//$cate_name = str_replace('"','"',$cate_name);//double coil
if($cate_status==1)
$publushed="publushed";
else
$publushed="unpublushed";
if($cate_showhome==1)
$publushedhome="publushed";
else
$publushedhome="unpublushed";
if($cate_status ==1){
$option_show = "
<option value='1' class='black' selected>ใช้งาน</option>
<option value='0' class='black' >ไม่ใช้งาน</option>
";
}else{
$option_show = "
<option value='1' class='black' >ใช้งาน</option>
<option value='0' class='black' selected>ไม่ใช้งาน</option>
";
}
if($cate_showhome ==1){
$option_showhome = "
<option value='1' class='black' selected>ใช้งาน</option>
<option value='0' class='black' >ไม่ใช้งาน</option>
";
}else{
$option_showhome = "
<option value='1' class='black' >ใช้งาน</option>
<option value='0' class='black' selected>ไม่ใช้งาน</option>
";
}
if($cate_images!=""){
$images = "<img src='../../album/category/large/$cate_images' width='100%' alt='$gall_name'/>";
}else{
$images = "<img src='../../images/logo.png' width='100%' alt='$gall_name'/>";
}
echo "<tr>
<td><input type='checkbox' name='maincate-$count' id='maincate-$count' class='css-checkbox chk_del' data-id='$cate_id' />
<label for='maincate-$count' class='css-label'></label></td>
<td align='center'><span class='sort_text hide'>$cate_sort</span><input class='sort_input form-control text-center' value='$cate_sort'/></td>
<!--<td style='background:#9a9a9a;'>$images</td>-->
<td><span class='name_text'><span class='lang'>TH</span> : <strong>$cate_name</strong></span><input class='name_input form-control hide' value='$cate_name'/>
<br><span class='name_text'><span class='lang'>EN</span> : <strong>$cate_name_en</strong></span><input class='name_input form-control hide' value='$cate_name_en'/>
</td>
<!--<td><span class='name_text'><strong>$cate_name_en</strong></span><input class='name_input form-control hide' value='$cate_name_en'/></td>-->
<td align='center'>
<div class='$publushed'>
<select class='select-publushed chk_show' data-id='$cate_id' data-tb='cate'>
$option_show
</select>
</div>
</td>
<td align='center'>
<div class='$publushedhome'>
<select class='select-publushed chk_showhome' data-id='$cate_id' data-tb='cate'>
$option_showhome
</select>
</div>
</td>
<!--<td align='center'><a href='category_sub.php?id=$cate_id' class='bt-sub'><i class='fa-plus-circle'></i> เพิ่ม </a></td>-->
<td><a href='category.php?id=$cate_id' class='bt-edit'><i class='fa-pencil'></i> แก้ไข</a></td>
</tr>";
$count++;
}
?>
</table>
</div>
</div><!--widget-inbox-->
</div>
</div>
</div><!--main-content-->
</body>
</html>