File: /home/pengthai/domains/pengthaicurry.com/public_html/admin/products/index.php
<!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");
?>
<link rel="stylesheet" type="text/css" href="../css/dataTables.bootstrap.min.css"/>
<link rel="stylesheet" type="text/css" href="../css/style.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 src="../js/tinymce/tinymce.min.js"></script>
<script src="../js/jquery.dataTables.min.js"></script>
<script src="../js/dataTables.bootstrap.min.js"></script>
<script src="../js/bws.js"></script>
<style>
.input-sm {
padding: 2px 10px;
}
</style>
<script>
$(function(){
$('#Addpd').DataTable();
$('.bt-save').click(function(){
if($(".maincate:checked").length==0){ // ถ้าไม่มีการเลือก checkbox ใดๆ เลย
alert("กรุณาเลือกหมวดหมู่");
return false;
}
if($('input[name="name_th"]').val()=="")
{
alert("กรุณากรอกชื่อด้วยค่ะ");
$('input[name="name_th"]').focus();
return false;
}
$('#Form1').submit();
});
//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-image"},
dataType: "json",
success: function(data){
alert(data.txt);
if (parseInt(data.stat) == 1)
location.reload();
}
});
});
//delect PDF
$('.del-pdf').click(function(){
var id = $(this).attr("data-id");
var file = $(this).attr("data-file");
var column = $(this).attr("data-column");
var lang = $(this).attr("data-lang");
if(confirm('หากต้องการลบ กรุณายืนยันอีกครั้ง')==false){
return false;
}
$.ajax({
type: "POST",
url:"fn_save.php",
data : {id:id, file:file, lang:lang, column:column,action:"del-pdf"},
dataType: "json",
success: function(data){
alert(data.txt);
if(parseInt(data.stat) == 1)
location.reload();
}
});
});
//SORT IMAGE
var $sortimg = $(".product-images");
$sortimg.sortable({
items: '>:not(.add-img):not(.review-pic)',
update: function(event, ui) {
var arr ="";
$sortimg.children(".del-image").each(function(index, element) {
var number =index+1;
$(this).find(".index").text(number);
if (index == 0 ){
$(this).parent().find('.default').removeClass('default');
$(this).addClass('default');
}
arr += $(this).attr("data-id") + ","+ number + "||";
});
$.ajax({
url: "fn_save.php", //ปลายทาง
data:{action:"move" , data : arr}, //ส่งข้อมูล
type: 'POST', //ประเภทการส่ง
dataType: "json", //รูปแแบ callback
success: function(data){
if(parseInt(data.stat)==1)
{
//ul_ProdSize.children("li").remove();
}
else if(parseInt(data.stat)==0){
location.reload();
}
}
});
}
});
//delect image all
$('.fa-trash').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") + "," ;
}
});
// alert(data);
//exit();
if (data != ''){
$.ajax({
type: "POST",
url:"fn_save.php",
data: {del:data, action:"del-img-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;
});
//CHECK ALL PRODUCT
$('#all-product').click(function(){
var checkBox = $('input[type=checkbox].chk_del');
if ($("#all-product").hasClass("fa-check-square-o")==true){
// alert("has");
checkBox.prop( "checked",true );
document.getElementById('all-product').title = 'ไม่เลือกภาพทั้งหมด';
$('#all-product').removeClass('fa-check-square-o');
$('#all-product').addClass('fa-square');
} else {
checkBox.prop( "checked",false );
document.getElementById('all-product').title = 'เลือกภาพทั้งหมด';
$('#all-product').removeClass('fa-square');
$('#all-product').addClass('fa-check-square-o');
}
// exit();
});
$('#editNameModal').on('show.bs.modal', function (event) {
var button = $(event.relatedTarget)
var id = button.data('id')
var name = button.data('name')
var name_en = button.data('nameen')
var action = button.data('action')
var modal = $(this)
/* modal.find('.modal-title').text('New message to ' + recipient)*/
//modal.find('textarea').val("aaa")
//$(this).find('textarea').val("aaa")
//modal.find('.descript').val(name)
modal.find('.modal-body input[name="imag_action"]').val(action)
modal.find('.modal-body input[name="imag_name"]').val(name)
modal.find('.modal-body input[name="imag_name_en"]').val(name_en)
modal.find('.modal-body input[name="id_img"]').val(id)
})
$('.btn-primary').click(function(){
//alert("0000");
var id = $('input[name="id_img"]').val();
var name = $('input[name="imag_name"]').val();
var name_en = $('input[name="imag_name_en"]').val();
var action = $('input[name="imag_action"]').val();
// alert(id);
// exit();
$.ajax({
type: "POST",
url:"fn_save.php",
data : {id:id, name:name, name_en:name_en, action:action},
dataType: "json",
success: function(data){
alert(data.txt);
if (parseInt(data.stat) == 1)
location.reload();
}
});
});
/****************************************/
$('.add-accessories').click(function(){
var id = $(this).attr("data-id");
var main = $(this).attr("data-main");
var Idacc = $(this).attr("data-Idacc");
/*if( confirm('หากต้องการลบ กรุณายืนยันอีกครั้ง')==false )
{
return false;
}*/
$.ajax({
type: "POST",
url:"fn_save.php",
data : {id:id, main:main, Idacc:Idacc ,action:"add-acces"},
dataType: "json",
success: function(data){
alert(data.txt);
if (parseInt(data.stat) == 1)
location.reload();
}
});
});
/**************************************/
$('.clear-accessories').click(function(){
var id = $(this).attr("data-id");
var main = $(this).attr("data-main");
var Idacc = $(this).attr("data-Idacc");
if( confirm('หากต้องการยกเลิก กรุณายืนยันอีกครั้ง')==false )
{
return false;
}
$.ajax({
type: "POST",
url:"fn_save.php",
data : {id:id, main:main, Idacc:Idacc ,action:"del-acces"},
dataType: "json",
success: function(data){
alert(data.txt);
if (parseInt(data.stat) == 1)
location.reload();
}
});
});
/**************************************/
});
</script>
</head>
<body>
<div id="header" class="row">
<div class="col-xs-12 col-sm-6 col-md-6">
<?php
$current_page= $current_page ;
include("../include/header-left-menu.inc.php");
include("../include/function.php");
?>
</div>
</div>
<div class="h20"></div>
<div id="main-content" class="page-product">
<?php
if(!empty($_GET['id']))
$topic_index = $topic_edit ;
else
$topic_index = $topic_add ;
?>
<div class="title"><?=$topic_index?>
<ul class="tool">
<li><a href="index.php"><button class="bt-clear">เริ่มใหม่</button></a></li>
<li><button class="bt-save">บันทึก</button></li>
</ul>
</div>
<form action="fn_save.php" method="post" id="Form1" enctype="multipart/form-data">
<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_add?>"></i> <?=$topic_index?></li>
</ol>
<div class="alert alert-warning " role="alert">
<span class="red">* <!--สามารถเลือกรูปภาพหลายรูปภาพพร้อมกันได้ โดยการกด Ctrl ค้างไว้แล้วเลือกรูปภาพ (ควรใช้รูปภาพขนาดเท่ากันทุกรูป) -->ขนาดรูปที่แนะนำ 1,313 x 876 pixels และควรมีขนาดไม่เกิน 3MB</span>
</div>
<?php
$id=$_GET['id'];
if(!empty($id)){
$sql="SELECT * FROM $table_main WHERE data_id=$id ";
$result=mysql_queryx($sql);
$r=mysql_fetch_arrayx($result);
$data_code=$r['data_code'];
$data_name_th=$r['data_name_th'];
$data_name_en=$r['data_name_en'];
$data_title_th=$r['data_title_th'];
$data_title_en=$r['data_title_en'];
$data_detail_th=$r['data_detail_th'];
$data_detail_en=$r['data_detail_en'];
$data_main_cate=$r['data_main_cate'];
$data_sub_cate=$r['data_sub_cate'];
$data_sub_cate2=$r['data_sub2_cate'];
$data_status=$r['data_status'];
$data_status2=$r['data_status2'];
$data_show=$r['data_show'];
$data_pdf=$r['data_pdf'];
$data_pdf_en=$r['data_pdf_en'];
$data_capacity_th=$r['data_capacity_th'];
$data_capacity_en=$r['data_capacity_en'];
$data_color_th=$r['data_color_th'];
$data_color_en=$r['data_color_en'];
$data_size_th=$r['data_size_th'];
$data_size_en=$r['data_size_en'];
$data_weight_th=$r['data_weight_th'];
$data_weight_en=$r['data_weight_en'];
$data_logo_th=$r['data_logo_th'];
$data_logo_en=$r['data_logo_en'];
$data_vdo=$r['data_vdo'];
$data_vdo_en=$r['data_vdo_en'];
$data_date=$r['data_date'];
$data_url=$r['data_url'];
$data_type=$r['data_type'];
$data_type=explode(",",$data_type);
$data_main_cate=explode(",",$data_main_cate);
$data_sub_cate=explode(",",$data_sub_cate);
$data_sub_cate2=explode(",",$data_sub_cate2);
$data_name_th = str_replace("′","'",$data_name_th);//single coil
$data_name_en = str_replace("′","'",$data_name_en);//single coil
$data_detail_th = str_replace("′","'",$data_detail_th);//single coil
$data_detail_en = str_replace("′","'",$data_detail_en);//single coil
if (empty($data_date)) {
$data_date = date("Y-m-d");
}
}
?>
<div class="col-xs-12 col-sm-12 col-md-8 col-lg-8">
<input type="hidden" name="action" value="add">
<input type="hidden" name="id" value="<?=$id?>">
<ul class="nav nav-tabs">
<!--<li><a data-toggle="tab" href="#home">ข้อมูล </a></li>-->
<li class="active"><a data-toggle="tab" href="#cont-th">ข้อมูล TH</a></li>
<li><a data-toggle="tab" href="#cont-en">ข้อมูล EN</a></li>
</ul>
<div class="tab-content">
<div id="home" class="tab-pane fade in display-none">
<div class="widget-box-blue">
<div class="widget-title" lang="th"><i class="fa-info"></i> ข้อมูล </div>
<ul class="widget-tool navbar-right"><li><i class="fa-caret-up show-hide-widget"></i></li></ul>
<div class="widget-inbox">
<div class="form-box">
<div class="form-group display-none">
<label class="col-xs-12 col-sm-4 col-md-4 col-lg-3 control-labe text-right">วันที่ : </label>
<div class="col-xs-12 col-sm-8 col-md-8 col-lg-9"><input type="date" class="form-control" data-date-format="yyyy-mm-dd" placeholder="" name="date_today" value="<?=$data_date?>"></div>
</div>
<div class="form-group display-none">
<label class="col-xs-12 col-sm-4 col-md-4 col-lg-3 control-labe text-right">URL : </label>
<div class="col-xs-12 col-sm-8 col-md-8 col-lg-9"><input type="text" class="form-control" placeholder="" name="data_url" value="<?=$data_url?>"></div>
</div>
<div class="clearfix"></div>
<div class="form-group ">
<label class="col-xs-12 col-sm-4 col-md-4 col-lg-3 control-labe text-right"> รหัสสินค้า : </label>
<div class="col-xs-12 col-sm-8 col-md-8 col-lg-9"><input type="text" class="form-control" placeholder="" name="code" value="<?=$data_code?>"></div>
</div>
<div class="clearfix"></div>
<!-- <div class="form-group ">
<label class="col-xs-12 col-sm-4 col-md-4 col-lg-3 control-labe text-right"> ประเภทสินค้า : </label>
<div class="col-xs-12 col-sm-8 col-md-8 col-lg-9">
<select class="form-control" name="prod_type">
<option <?php if($data_type == '0'){echo 'selected';}?> value="">---กรุณาเลือกประเภทสินค้า---</option>
<?php
$sqltype="SELECT * ,if(cate_sort=0,99999,cate_sort) AS sort FROM tb_products_type WHERE cate_show = '1' ORDER BY sort ASC ,cate_id ";
$resulttype=mysql_queryx($sqltype);
while($resulttype && $rtype=mysql_fetch_arrayx($resulttype)){
$cateid=sprintf("%d",$rtype['cate_id']);
$catename = $rtype['cate_name'];
if($data_type == $cateid){
echo '<option value="'.$cateid.'" selected>'.$catename .'</option>';
}else{
echo '<option value="'.$cateid.'">'.$catename .'</option>';
}
}
?>
</select>
</div>
</div>
<div class="clearfix"></div>-->
</div>
</div><!--widget-inbox-->
</div><!--widget-box-->
</div>
<div id="cont-th" class="tab-pane fade in active">
<div class="widget-box-blue">
<div class="widget-title" lang="th"><i class="fa-info"></i> ข้อมูล </div>
<ul class="widget-tool navbar-right"><li><i class="fa-caret-up show-hide-widget"></i></li></ul>
<div class="widget-inbox">
<div class="form-box">
<div class="form-group">
<label class="col-xs-12 col-sm-4 col-md-4 col-lg-3 control-labe text-right">ชื่อ<?=$title_main?> <span class="lang">TH</span> : </label>
<div class="col-xs-12 col-sm-8 col-md-8 col-lg-9"><input type="text" class="form-control" name="name_th" value="<?=$data_name_th?>"></div>
</div>
<div class="clearfix"></div>
<div class="form-group display-none">
<label class="col-xs-12 col-sm-4 col-md-4 col-lg-3 control-labe text-right">รายละเอียด <span class="lang">TH</span> : </label>
<div class="col-xs-12 col-sm-8 col-md-8 col-lg-9"><textarea class="form-control textarea" placeholder="" name="detail_th" rows="8"><?=$data_detail_th?></textarea></div>
</div>
<div class="clearfix"></div>
<div class="form-group display-none">
<label class="col-xs-12 col-sm-4 col-md-4 col-lg-3 control-labe text-right">ไฟล์เอกสาร <span class="lang">TH</span> : </label>
<div class="col-xs-12 col-sm-8 col-md-8 col-lg-9">
<div class="product-images">
<?php
if(!empty($data_pdf))
echo "<div class='file-pdf'>
<span><a href='../../album/$folder_main/pdf/$data_pdf' class='text' target='_blank'><i class='fa-file-pdf-o'></i>เปิดไฟล์เอกสาร</a></span>
<i class='fa-times-circle del-pdf' data-id='$id' data-file='$data_pdf' data-lang='th' data-column='data_pdf' ></i>
</div>";
else
echo "<div class='add-pdf'>
<span><span><i class='fa-file-pdf-o'></i><a class='text'>เลือกไฟล์เอกสาร</a></span>
</div>";
?>
<input class="hidden" type="file" name="file_array1">
</div>
</div>
</div>
<div class="clearfix"></div>
</div>
</div><!--widget-inbox-->
</div><!--widget-box-->
<div class="col-md-12 display-none">
<div class="widget-box-violet">
<div class="widget-title" lang="th"><i class="fa-film"></i> Vdo Youtube</div>
<ul class="widget-tool navbar-right">
<li><i class="fa-caret-up show-hide-widget"></i></li>
</ul>
<div class="widget-inbox">
<div class="form-group">
<label class="col-xs-12 col-sm-4 col-md-4 col-lg-4 control-labe text-right"> URL <span class="lang">TH</span> : </label>
<div class="col-xs-12 col-sm-8 col-md-8 col-lg-8">
<input type="text" class="form-control" placeholder="" name="vdo" value="<?=$data_vdo?>">
<?php if(!empty($data_vdo)) { ?>
<div class="cleaner h10"></div>
<div>
<object>
<embed src='http://www.youtube.com/v/<?=$data_vdo?>?fs=1&hl=en_US' type='application/x-shockwave-flash' allowscriptaccess='always' allowfullscreen='true' width='250' height='150'></embed>
</object>
</div><!--center-->
<? } ?>
<small class="red">*ตัวอย่างในการใส่ลิงก์ : https://www.youtube.com/watch?v=k18eUTN3cNk </small>
</div>
</div>
<div class="cleaner"></div>
</div><!--widget-inbox-->
</div><!--widget-box-->
</div>
</div>
<div id="cont-en" class="tab-pane fade">
<div class="widget-box-blue">
<div class="widget-title" lang="th"><i class="fa-info"></i> ข้อมูล </div>
<ul class="widget-tool navbar-right">
<li><i class="fa-caret-up show-hide-widget"></i></li>
</ul>
<div class="widget-inbox">
<div class="form-box">
<div class="form-group">
<label class="col-xs-12 col-sm-4 col-md-4 col-lg-3 control-labe text-right">ชื่อ<?=$title_main?><span class="lang">EN</span> : </label>
<div class="col-xs-12 col-sm-8 col-md-8 col-lg-9"><input type="text" class="form-control" name="name_en" value="<?=$data_name_en?>"></div>
</div>
<div class="clearfix"></div>
<div class="form-group display-none">
<label class="col-xs-12 col-sm-4 col-md-4 col-lg-3 control-labe text-right">รายละเอียด <span class="lang">EN</span> : </label>
<div class="col-xs-12 col-sm-8 col-md-8 col-lg-9"><textarea class="form-control textarea" name="detail_en" rows="8"><?=$data_detail_en?></textarea></div>
</div>
<div class="clearfix"></div>
<div class="form-group display-none">
<label class="col-xs-12 col-sm-4 col-md-4 col-lg-3 control-labe text-right"> ไฟล์เอกสาร <span class="lang">EN</span> : </label>
<div class="col-xs-12 col-sm-8 col-md-8 col-lg-9">
<div class="product-images">
<?php
if(!empty($data_pdf_en))
echo "<div class='file-pdf'>
<span><a href='../../album/$folder_main/pdf/$data_pdf_en' class='text' target='_blank'><i class='fa-file-pdf-o'></i>เปิดไฟล์เอกสาร </a></span>
<i class='fa-times-circle del-pdf' data-id='$id' data-file='$data_pdf_en' data-lang='en' data-column='data_pdf_en'></i>
</div>";
else
echo "<div class='add-pdf_en'>
<span><span><i class='fa-file-pdf-o'></i><a class='text'>เลือกไฟล์เอกสาร </a></span>
</div>";
?>
<input class="hidden" type="file" name="file_arrayen1">
</div>
</div>
</div>
<div class="clearfix"></div>
</div>
</div><!--widget-inbox-->
</div><!--widget-box-->
<div class="col-md-12 display-none">
<div class="widget-box-violet">
<div class="widget-title" lang="th"><i class="fa-film"></i> Vdo Youtube</div>
<ul class="widget-tool navbar-right">
<li><i class="fa-caret-up show-hide-widget"></i></li>
</ul>
<div class="widget-inbox">
<div class="form-group">
<label class="col-xs-12 col-sm-4 col-md-4 col-lg-4 control-labe text-right"> URL <span class="lang">EN</span> : </label>
<div class="col-xs-12 col-sm-8 col-md-8 col-lg-8">
<input type="text" class="form-control" placeholder="" name="vdo_en" value="<?=$data_vdo_en?>">
<?php if(!empty($data_vdo_en)) { ?>
<div class="cleaner h10"></div>
<div>
<object>
<embed src='http://www.youtube.com/v/<?=$data_vdo_en?>?fs=1&hl=en_US' type='application/x-shockwave-flash' allowscriptaccess='always' allowfullscreen='true' width='250' height='150'></embed>
</object>
</div><!--center-->
<? } ?>
<small class="red">*ตัวอย่างในการใส่ลิงก์ : https://www.youtube.com/watch?v=k18eUTN3cNk </small>
</div>
</div>
<div class="cleaner"></div>
</div><!--widget-inbox-->
</div><!--widget-box-->
</div>
</div>
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-4 col-lg-4">
<div class="widget-box-orange">
<div class="widget-title" lang="th"><i class="fa-heart"></i> สถานะ</div>
<ul class="widget-tool navbar-right">
<li><i class="fa-caret-up show-hide-widget"></i></li>
</ul>
<div class="widget-inbox">
<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($data_status==1||$data_status=="") echo"checked"; ?>>
<label for="cmn-toggle-1"></label>
</div>
</li>
<li class="padding5 display-none">สถานะสินค้า : <select class="select-tag" name="status2"><?=CallStatus($data_status2)?></select></li>
<li class="padding5 display-none">แสดงหน้าแรก:
<div class="switch">
<input id="cmn-toggle-2" class="cmn-toggle cmn-toggle-round-flat" type="checkbox" value="1" name="status_show" <? if($data_show==1||$data_show=="") echo"checked"; ?>>
<label for="cmn-toggle-2"></label>
</div>
</li>
</ul>
</div><!--widget-inbox-->
</div><!--widget-box-->
<div class="widget-box-green">
<div class="widget-title" lang="th"><i class="fa-sitemap"></i> หมวดหมู่</div>
<ul class="widget-tool navbar-right"><li><i class="fa-caret-up show-hide-widget"></i></li></ul>
<div class="widget-inbox">
<div class="widget-inbox-cate">
<ul class="main-cate">
<?php
$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 = 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(is_array($data_main_cate))
{
if (in_array($cate_id, $data_main_cate))
$checked="checked";
else
$checked="";
}
else
$checked="";
echo "<li>
<input type='checkbox' name='main-cate[]' value='$cate_id' data-main='$cate_id' id='main-".$cate_id."' class='css-checkbox maincate' $checked/>
<label for='main-".$cate_id."' class='css-label'>$cate_name $cate_name_en</label>
</li>";
/*echo "<li>
<input type='checkbox' name='main-cate[]' value='$cate_id' data-main='$count' id='main-".$cate_id."' class='css-checkbox maincate' $checked/>
<label for='main-".$cate_id."' class='css-label'>$cate_name</label>
</li>"*/;
$sql="SELECT * FROM $table_cate WHERE cate_main='$cate_id' AND cate_mainsub1 =0";
$result_s=mysql_queryx($sql);
$count_s=1;
while($result_s && $r_s=mysql_fetch_arrayx($result_s))
{
$cate_idsub1=sprintf("%d",$r_s['cate_id']);
$cate_namesub1=$r_s['cate_name'];
if(is_array($data_sub_cate))
{
if (in_array($cate_idsub1, $data_sub_cate))
$checked="checked";
else
$checked="";
}
else
$checked="";
echo "<li class='space20'>
<input type='checkbox' name='sub-cate[]' value='$cate_idsub1' data-main='$cate_id' data-id='$cate_idsub1' id='sub-".$cate_id."-".$cate_idsub1."' class='css-checkbox subcate sub1-$cate_id ' $checked/>
<label for='sub-".$cate_id."-".$cate_idsub1."' class='css-label'>$cate_namesub1</label>
</li>";
$sql_sub2="SELECT * FROM $table_cate WHERE cate_main='$cate_id' AND cate_mainsub1='$cate_idsub1' ";
$result_s2=mysql_queryx($sql_sub2);
$count_s2=1;
while($result_s2 && $r_s=mysql_fetch_arrayx($result_s2))
{
$cate_idsub2=sprintf("%d",$r_s['cate_id']);
$cate_namesub2=$r_s['cate_name'];
if(is_array($data_sub_cate))
{
if (in_array($cate_idsub2, $data_sub_cate2))
$checked="checked";
else
$checked="";
}
else
$checked="";
echo "<li class='space40'>
<input type='checkbox' name='sub-cate2[]' value='$cate_idsub2' data-main='$cate_id' data-sub='$cate_idsub1' id='sub2-".$cate_idsub1."-".$cate_idsub2."' class='css-checkbox subcate2 sub1-$cate_id sub2-$cate_idsub1' $checked/>
<label for='sub2-".$cate_idsub1."-".$cate_idsub2."' class='css-label'>$cate_namesub2</label>
</li>";
$count_s2++;
}
/*echo "<li class='space20'>
<input type='checkbox' name='sub-cate[]' value='$cate_idsub1' data-main='$count' id='sub-".$cate_id."-".$cate_idsub1."' class='css-checkbox subcate sub1-$cate_id' $checked/>
<label for='sub-".$cate_id."-".$cate_idsub1."' class='css-label'>$cate_namesub1</label>
</li>";*/
//////////////////////////////////////////////////////////////////
// $sql_sub2="SELECT * FROM $table_cate WHERE cate_main='$cate_id' AND cate_mainsub1='$cate_idsub1' ";
// $result_s2=mysql_queryx($sql_sub2);
// $count_s2=1;
// while($result_s2 && $r_s=mysql_fetch_arrayx($result_s2))
// {
// $cate_idsub2=sprintf("%d",$r_s['cate_id']);
// $cate_namesub2=$r_s['cate_name'];
//
// if(is_array($data_sub_cate))
// {
// if (in_array($cate_idsub2, $data_sub_cate2))
// $checked="checked";
// else
// $checked="";
// }
// else
// $checked="";
//
// echo "<li class='space40'>
// <input type='checkbox' name='sub-cate2[]' value='$cate_idsub2' data-main='".$cate_id."-".$cate_idsub1."' id='sub2-".$cate_idsub1."-".$cate_idsub2."' class='css-checkbox subcate2 sub2-$cate_idsub1' $checked/>
// <label for='sub2-".$cate_idsub1."-".$cate_idsub2."' class='css-label'>$cate_namesub2</label>
// </li>";
//
// $count_s2++;
// }
///////////////////////////////////////////////////////////
$count_s++;
}
$count++;
}
?>
</ul>
</div><!--widget-inbox-cate-->
</div><!--widget-inbox-->
</div><!--widget-box-->
<div class="widget-box-violet display-none">
<div class="widget-title" lang="th"><i class="fa-cube"></i> ประเภทสินค้า</div>
<ul class="widget-tool navbar-right"><li><i class="fa-caret-up show-hide-widget"></i></li></ul>
<div class="widget-inbox">
<div class="widget-inbox-cate">
<ul class="main-cate">
<?php
$sqltype="SELECT *, IF(cate_sort=0,999999,cate_sort) AS sort FROM tb_products_type WHERE cate_main = 0 ORDER BY sort";
$resulttype=mysql_queryx($sqltype);
$countype=1;
while($resulttype && $rtype=mysql_fetch_arrayx($resulttype))
{
$catet_id=sprintf("%d",$rtype['cate_id']);
$catet_name=$rtype['cate_name'];
$catet_name_en = str_replace("′","'",$catet_name_en);//single coil
$catet_name = str_replace("′","'",$catet_name);//single coil
if(is_array($data_type)){
if(in_array($catet_id, $data_type)){$checkedt="checked";}else{$checkedt="";}
}else{
$checkedt="";
}
echo "<li>
<input type='checkbox' name='main-type[]' value='$catet_id' data-type='$cate_id' id='type-".$catet_id."' class='css-checkbox maintype' $checkedt/>
<label for='type-".$catet_id."' class='css-label'>".$catet_name."</label>
</li>";
$countype++;
}
?>
</ul>
</div>
</div>
</div>
<div class="widget-box-turquoise">
<div class="widget-title" lang="th"><i class="fa-photo"></i> รูปภาพ</div>
<ul class="widget-tool navbar-right">
<?php
if (!empty($id)) {
$sql="SELECT *, if(imag_sort=0,99999,imag_sort) AS order2 FROM $table_img WHERE imag_mainID=$id ORDER BY order2 ASC";
$result=mysql_queryx($sql);
$num = mysql_num_rowsx($result);
if ($num>0) {
?>
<li class="text-center"><i class="fa-check-square-o" id="all-product" title="เลือกภาพทั้งหมด"></i></li>
<li><i class="fa-trash" data-id='<?=$id?>' data-action='del-all-image' title="ลบภาพทั้งหมด"></i></li>
<?php
}
}
?>
<li><i class="fa-caret-up show-hide-widget"></i></li>
</ul>
<div class="widget-inbox">
<!--<p class="red">* สามารถเลือกรูปภาพหลายรูปภาพพร้อมกันได้ โดยการกด Ctrl ค้างไว้แล้วเลือกรูปภาพ (ควรใช้รูปภาพขนาดเท่ากันทุกรูป)</p>-->
<p class="red">* ขนาดรูปที่แนะนำ 1,313 x 876 pixels และควรมีขนาดไม่เกิน 3MB</p>
<?php
/*if(!empty($id))
echo"<p class='red'>*** จัดเรียงรูปภาพได้โดยการคลิกค้างที่รูปภาพ แล้วลากไปตำแหน่งที่ต้องการ (รูปภาพลำดับที่ 1 จะเป็นรูปภาพหน้าปกเสมอ)</p>";*/
?>
<div class="product-images">
<div class="add-img">
<span><i class="fa-image"></i><a class="text">เลือกรูปภาพ</a></span>
</div>
<?php
if(!empty($id))
{
$count=1;
while($result && $r=mysql_fetch_arrayx($result))
{
$imag_id=sprintf("%d",$r['imag_id']);
$imag_file=$r['imag_file'];
$imag_name=$r['imag_name'];
$imag_name_en=$r['imag_name_en'];
$imag_sort=$r['imag_sort'];
if($imag_file!="")
echo "<div class='del-image' data-id='$imag_id'>
<input type='checkbox' name='product-".$count."' id='product-".$count."' class='chk_del css-checkbox' data-id='$imag_id' value='$imag_id' />
<label for='product-".$count."' class='css-label'></label>
<i class='fa fa-remove bt-del-image' data-id='$imag_id' data-file='$imag_file' data-action='del-image' ></i>
<img src='../../album/$path_system/small/$imag_file' width='100%' alt='$port_name'/>
<span class='index'>$imag_sort</span>
<!--<div class='cleaner h30'></div>
<a href='#' class='bt_edit' data-toggle='modal' data-target='#editNameModal' data-id ='$imag_id' data-name='$imag_name' data-nameen='$imag_name_en' data-action='add-descript'>
<input type='button' name='bt' class='bt_edit name' value='เพิ่มคำบรรยาย' ><div class='cleaner'></div>
</a>-->
</div>
";
else
echo "<div class='del-image' data-id='$imag_id'>
<i class='fa fa-remove bt-del-image' data-id='$imag_id' data-file='$imag_file' data-action='del-image' ></i>
<img src='../../images/nopic.png' width='100%' alt='nopic'/>
</div>";
$count ++;
}
}
?>
<input class="browes-image hidden" name='add_image[]' type='file' multiple>
</div>
<div class="cleaner"></div>
</div><!--widget-inbox-->
</div><!--widget-box-->
</div>
</form>
<div class="tool-bottom col-xs-12">
<ul>
<li><button class="bt-save">บันทึก</button></li>
<!--<li><a href="index.php"><button class="bt-clear">เริ่มใหม่</button></a></li>-->
</ul>
</div>
</div><!--main-content-->
<!--/////-----Dialog Edit Name-----//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////--->
<div class="modal fade" id="editNameModal" tabindex="-1" role="dialog" aria-labelledby="ModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title" id="ModalLabel">แก้ไขคำบรรยายภาพ</h4>
</div>
<!--<form action="fn_portfolio.php" method="post" id="Form1" enctype="multipart/form-data">-->
<div class="modal-body">
<div class="form-box">
<div class="form-group">
<label for="recipient-name" class="control-label">คำบรรยายภาพ <span class="lang">TH</span> :</label>
<input type="text" class="form-control descript" id="recipient-name" name="imag_name" >
<label for="recipient-name" class="control-label">คำบรรยายภาพ <span class="lang">EN</span> : </label>
<input type="text" class="form-control descript" id="recipient-name" name="imag_name_en" >
<!-- <textarea class="form-control descript" id="recipient-name" name="imag_name"></textarea>
<textarea class="form-control descript" id="recipient-name" name="imag_name"></textarea>-->
<input type="hidden" class="form-control" name="id_img" >
<input type="hidden" class="form-control" name="imag_action" >
<input type="hidden" class="form-control" name="id_img" >
<input type="hidden" class="form-control" name="id" value="<?=$id?>" >
<!--<input type="hidden" class="form-control" name="action" value="add-descript">-->
<input type="hidden" class="form-control" name="action" value="add-descript">
</div>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">ยกเลิก</button>
<button type="submit" class="btn btn-primary"><i class="fa fa-save"></i> บันทึก</button>
</div>
<!-- </form>-->
</div>
</div>
</div>
<!--//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////--->
</body>
</html>