| Server IP : 172.67.216.113 / 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/www/homhuan.com/product/ |
Upload File : |
<?php include('../include/meta.php');?>
<?php include('../include/head.php');?>
<?php $menu = 'product'; ?>
<?php include('../include/menu.php');?>
<link rel="stylesheet" href="../include/infiniteajaxscroll/default.min.css">
<?php
$search = '';
if($_GET['type']=='men'){ $search = 'AND product.type_id = "1"';$num_type = 'ผู้ชาย'; }
if($_GET['type']=='female'){ $search = 'AND product.type_id = "2"';$num_type = 'ผู้หญิง'; }
if($_GET['type']=='nun'){ $search = 'AND product.type_id = "3"';$num_type = 'แม่ชี'; }
if($_GET['type']=='child'){ $search = 'AND product.type_id = "4"';$num_type = 'เด็ก'; }
if($_GET['type']=='another'){ $search = 'AND product.type_id = "5"';$num_type = 'อื่น'; }
if($_GET['type']=='mohom'){ $search = 'AND product.type_id = "6"';$num_type = 'หม้อฮ่อม'; }
if( @$_POST['pro_cat'] <> ''){ $search = $search . ' AND product.category_id = "'.$_POST['pro_cat'].'"'; $pro_cat = '&pro_cat='.$_POST['pro_cat'];}
if( @$_POST['pro_tt'] <> ''){ $search = $search . ' AND product.texture_id = "'.$_POST['pro_tt'].'"'; $pro_tt = '&pro_tt='.$_POST['pro_tt'];}
?>
<div class="container div_main p_top40">
<div class="row">
<div class="col-md-12">
<div><span style="color:#5d6a99;">หน้าหลัก</span> / สินค้า<?php echo $num_type;?></div>
</div>
</div>
</div>
<div class="container div_main p_top40">
<div class="row">
<div class="col-md-12" align="center">
<div class="text_header_48_b">สินค้า<?php echo $num_type;?></div>
<div><a href="#" class="font_pro_all"> สินค้าทั้งหมด</a></div>
</div>
</div>
</div>
<div class="container div_main p_top20">
<?php $url="https://".$_SERVER['HTTP_HOST'].$_SERVER['SCRIPT_NAME']."?".$_SERVER['QUERY_STRING'];?>
<form action='<?php echo $url;?>' method="post" name='fm_type_pro' >
<div class="row">
<div class="col-md-3 col-md-offset-3 p_top20 div_type_pro_1">
<select name="pro_cat" class="select_type_pro" OnChange="document.fm_type_pro.submit()">
<option value="">เลือกหมวดสินค้า</option>
<?php
$sql_cat = array('table'=>'category','where'=>"status = '1' order by sort ASC");
$view_cat = $view_db->view($sql_cat);
$result_cat = $view_db->q_re($view_cat);
while($row_cat = $view_db->q_ro($result_cat))
{
?>
<option value="<?php echo @$row_cat['id']; ?>" <?php if(@$_POST['pro_cat'] == $row_cat['id']){ ?>selected<?php }?>><?php echo $row_cat['name']; ?></option>
<?php } ?>
</select>
</div>
<div class="col-md-3 p_top20 div_type_pro_2" id="se_type_pro">
<?php
if(@$_POST['pro_cat'] == '')
{
$sql_tt = array('table'=>'texture','where'=>"status = '1' order by sort ASC");
}
else
{
$sql_tt = array('table'=>'texture,product','count'=>'DISTINCT texture.id AS id , texture.name AS name','where'=>"product.category_id = '".$_POST['pro_cat']."' AND texture.id = product.texture_id " .$search." AND texture.status = '1' AND product.status = '1' order by texture.sort ASC");
}
$view_tt = $view_db->view($sql_tt);
$result_tt = $view_db->q_re($view_tt);
?>
<select name="pro_tt" class="select_type_pro" OnChange="document.fm_type_pro.submit();">
<option value="">เลือกหมวดเนื้อผ้า</option>
<?php
while($row_tt = $view_db->q_ro($result_tt))
{
?>
<option value="<?php echo @$row_tt['id']; ?>" <?php if(@$_POST['pro_tt'] == $row_tt['id']){ ?>selected<?php }?>><?php echo $row_tt['name']; ?></option>
<?php } ?>
</select>
</div>
</div>
</form>
</div>
<style>
.text_sale_promotion {
border: 0px solid #F00;
height: 40px;
margin-top: -40px;
position: relative;
background-color: #F00;
padding-top: 5px;
background: rgba(240, 110, 170, 0.8);
}
</style>
<div class="container div_main container_2" style="padding-top:40px;">
<div class="row">
<?php
$sql_pro = array(
'table'=>'product,category',
'count'=>'product.id as id ,
product.name as name,
product.code as code ,
product.image as image ,
product.texture_id as texture_id,
product.sort as sort,
product.text_sale as text_sale,
product.type_id as type_id,
product.shows as shows ',
'where'=>"product.category_id = category.id AND product.status = '1' ". $search . "
order by product.shows DESC , category.sort ASC , product.sort DESC LIMIT 0,8 "
);
//print_r($sql_pro);
$view_pro = $view_db->view($sql_pro);
$result_pro = $view_db->q_re($view_pro);
$num_rows = mysqli_num_rows($result_pro);
if($num_rows == 0)
{
?>
<div style="color:#F00;text-align:center;"> ไม่พบรายการที่ค้นหา </div>
<?php }
$num = 1;
$num_all = 1;
$date_today = date('Y-m-d');
$sql_pmo4 = array('table'=>'promotion','where'=>"type = 4 AND status = '1' AND ( from_date <= '".$date_today."' AND to_date >= '".$date_today."' ) order by id ASC");
$view_pmo4 = $view_db->view($sql_pmo4);
$row_pmo4 = $view_db->q($view_pmo4);
while($row_pro = $view_db->q_ro($result_pro))
{
/*
echo '<pre>';
print_r($row_pro);
echo '</pre>';
*/
if($num == 1){ ?> <div class="row"> <?php }
?>
<div class="col-md-3 col-sm-6 col-xs-6 item" style="height:430px;">
<div class="col-md-11">
<div class="pro_img">
<a href="productdetail.php?id=<?php echo $row_pro['id']?>" style="text-decoration:none;color:#FFF;">
<img src="../redbag/product/<?php echo $row_pro['image']?>" width="207" class="img_res img_nocopy">
<?php
if($row_pmo4['id_texture'] == $row_pro['texture_id']) {
$arr_type_promp = explode(',',$row_pmo4['id_type']);
if (in_array($row_pro['type_id'], $arr_type_promp)) {
?>
<div class="text_sale">
<div style="color:#FFF;"><?php echo $row_pmo4['text_sale'];?></div>
</div>
<?php
}
}
else if($row_pro['text_sale']<>'')
{
?>
<div class="text_sale">
<div style="color:#FFF;"><?php echo $row_pro['text_sale'];?></div>
</div>
<?php
}
else if ($row_pro['shows'] == 2 )
{
?>
<div class="text_sale_new">
<div style="color:#FFF;">สินค้าใหม่</div>
</div>
<?php
}
else if ($row_pro['shows'] == 3 )
{
?>
<div class="text_sale_good">
<div style="color:#FFF;">สินค้าขายดี</div>
</div>
<?php
}
else if ($row_pro['shows'] == 4 )
{
?>
<div class="text_sale_hi">
<div style="color:#FFF;">สินค้าแนะนำ</div>
</div>
<?php
}
else if ($row_pro['shows'] == 5 )
{
?>
<div class="text_sale_promotion">
<div style="color:#FFF;">สินค้าโปรโมชั่น</div>
</div>
<?php
}
?>
</a>
</div>
<div class="text_name_pro"><?php echo $row_pro['name']?></div>
<div class="text_name_ty_pro" style="color:#5d81c2;"><div> รหัสสินค้า <?php echo $row_pro['code']?></div></div>
<?php
$sql_tt2 = array('table'=>'texture','where'=>"status = '1' AND id = '".$row_pro['texture_id']."' order by id ASC");
$view_tt2 = $view_db->view($sql_tt2);
$row_tt2 = $view_db->q($view_tt2);
?>
<div class="text_name_ty_pro" ><?php echo $row_tt2['name']?></div>
</div>
</div>
<?php
if($num == 4 || $num_rows == $num_all){ ?> </div> <?php $num = 0; }
$num++; $num_all++;
}
?>
</div>
</div>
<script src="../include/infiniteajaxscroll/jquery.min.js"></script>
<script type="text/javascript" src="../include/infiniteajaxscroll/jquery-ias.min.js"></script>
<?php
$list = array('table'=>'product,category','count'=>'product.id as id , product.name as name , product.image as image , product.texture_id as texture_id, product.sort as sort ','where'=>"product.category_id = category.id AND product.status = '1' ". $search . " order by category.sort ASC , product.sort DESC ");
$view = $view_db->view($list);
$result = $view_db->q_re($view);
$rowcount = mysqli_num_rows($result);
$row_page = $rowcount/8;
$row_page = ceil( $row_page);
?>
<ul id="pagination" style="color:#000;">
<?php
for($i=1;$i<=$row_page;$i++)
{
if($i==1){?><li><a href="../product/product.php">1</a></li><?php }
else
{
?>
<li <?php if($i==2){ ?>class="next"<?php }?>>
<a href="../product/product_load.php?p=<?php echo $i; ?>&type=<?php echo $_GET['type'] . $pro_cat . $pro_tt;?>">2</a>
</li>
<?php
}
}
?>
</ul>
<script type="text/javascript">
var ias = $.ias({
container: ".container_2",
item: ".item",
pagination: "#pagination",
next: ".next a"
});
ias.extension(new IASSpinnerExtension());
ias.extension(new IASTriggerExtension({offset: 10}));
ias.extension(new IASNoneLeftExtension({text: ''}));
</script>
<?php include('../themes/tap_footer.php');?>
<?php include('../themes/footer.php');?>
<?php include('../include/footer_js.php');?>