zh_tcwq/inc/web/qggoodall.inc.php

<?php
global $_GPC, $_W;
$GLOBALS['frames'] = $this->getMainMenu();
$type2=isset($_GPC['type'])?$_GPC['type']:'all';

$where=" WHERE a.uniacid=:uniacid";
$data[':uniacid']=$_W['uniacid'];
if($_GPC['keywords']){
    $where .=" and (a.name LIKE :name || c.store_name LIKE :name)";
    $op=$_GPC['keywords'];
    $data[':name']="%$op%";      
}
if($_GPC['type_id']){
  $where .=" and a.type_id=:type_id";
  $data[':type_id']=$_GPC['type_id'];
}
if($_GPC['is_shelves2']){
    $where .=" and a.state=:cid";
    $data[':cid']=$_GPC['is_shelves2'];
}
if($_GPC['is_tg']){
      $where.=" and a.is_tg={$_GPC['is_tg']} ";  
}

$pageindex = max(1, intval($_GPC['page']));
$pagesize=10;
$sql="select a.* ,b.name as type_name,c.store_name from " . tablename("zhtc_qggoods") . " a"  . " left join " . tablename("zhtc_qgtype") . " b on b.id=a.type_id left join " . tablename("zhtc_store") . " c on c.id=a.store_id ".$where."  order by num asc";
$select_sql =$sql." LIMIT " .($pageindex - 1) * $pagesize.",".$pagesize;
$list = pdo_fetchall($select_sql,$data);	   
$total=pdo_fetchcolumn("select count(*) from " . tablename("zhtc_qggoods") . " a"  . " left join " . tablename("zhtc_qgtype") . " b on b.id=a.type_id left join " . tablename("zhtc_store") . " c on c.id=a.store_id ".$where,$data);
$pager = pagination($total, $pageindex, $pagesize);


$type=pdo_getall('zhtc_qgtype',array('uniacid'=>$_W['uniacid']));
if($_GPC['op']=='del'){
    $res=pdo_delete('zhtc_qggoods',array('id'=>$_GPC['id']));
    if($res){
        message('删除成功',$this->createWebUrl('qggoodall',array()),'success');
    }else{
        message('删除失败','','error');
    }
}
if($_GPC['state']){
    $res=pdo_update('zhtc_qggoods',array('state'=>$_GPC['state']),array('id'=>$_GPC['id']));
    if($res){
        message('编辑成功',$this->createWebUrl('qggoodall',array()),'success');
    }else{
        message('编辑失败','','error');
    }
}
if($_GPC['state2']){
    $res=pdo_update('zhtc_qggoods',array('state2'=>$_GPC['state2']),array('id'=>$_GPC['id']));
    if($res){
        message('编辑成功',$this->createWebUrl('qggoodall',array()),'success');
    }else{
        message('编辑失败','','error');
    }
}
if($_GPC['sh']){
    $res=pdo_update('zhtc_qggoods',array('is_tg'=>$_GPC['sh']),array('id'=>$_GPC['id']));
    if($res){
        message('编辑成功',$this->createWebUrl('qggoodall',array()),'success');
    }else{
        message('编辑失败','','error');
    }
}
include $this->template('web/qggoodall');