zh_tcwq/inc/web/dlinstore.inc.php

<?php
global $_GPC, $_W;
$action = 'start';
$GLOBALS['frames'] = $this->getNaveMenu($_COOKIE['cityname'], $action);
$where=" where a.uniacid=:uniacid and a.cityname=:cityname";
$data[':uniacid']=$_W['uniacid'];
$data[':cityname']= $_COOKIE['cityname'];
$type=isset($_GPC['type'])?$_GPC['type']:'wait';
$state=$_GPC['state'];
if($type=='wait'){
  $state=1;
}
if(isset($_GPC['keywords'])){
  $where.=" and a.store_name LIKE  concat('%', :name,'%') ";
  $data[':name']=$_GPC['keywords'];  
 $type='all'; 
}else{
  if($state){
  $where.=" and  a.state=:state ";
  $data[':state']=$state;   
}
}


$pageindex = max(1, intval($_GPC['page']));
$pagesize=10;


$sql="SELECT a.*,b.type as typename FROM ".tablename('zhtc_store'). " a"  . " left join " . tablename("zhtc_in") . " b on b.id=a.type".$where." ORDER BY a.id DESC";
$total=pdo_fetchcolumn("select count(*) from " .tablename('zhtc_store'). " a"  . " left join " . tablename("zhtc_in") . " b on b.id=a.type".$where,$data);
//echo $sql;die;
$select_sql =$sql." LIMIT " .($pageindex - 1) * $pagesize.",".$pagesize;

$list=pdo_fetchall($select_sql,$data);

$pager = pagination($total, $pageindex, $pagesize);
if($_GPC['op']=='delete'){
    $res=pdo_delete('zhtc_store',array('id'=>$_GPC['id']));
    if($res){
         message('删除成功！', $this->createWebUrl2('dlinstore'), 'success');
        }else{
              message('删除失败！','','error');
        }
}
if($_GPC['op']=='tg'){
  $rst=pdo_get('zhtc_store',array('id'=>$_GPC['id']));
  if(!$rst['sh_time']){//增加
      if($rst['type']==1){
        $time=24*60*60*7;
      }
      if($rst['type']==2){
        $time=24*182*60*60;
      }
      if($rst['type']==3){
        $time=24*365*60*60;
      }
  $time2=time();
   $res=pdo_update('zhtc_store',array('state'=>2,'sh_time'=>$time2,'dq_time'=>time()+$time),array('id'=>$_GPC['id']));
  }else{//修改
     $res=pdo_update('zhtc_store',array('state'=>2),array('id'=>$_GPC['id']));

  }
    if($res){
        message('通过成功！', $this->createWebUrl2('dlinstore'), 'success');
    }else{
        message('通过失败！','','error');
    }
}
if($_GPC['op']=='jj'){
    $res=pdo_update('zhtc_store',array('state'=>3,'sh_time'=>time()),array('id'=>$_GPC['id']));
    if($res){
     message('拒绝成功！', $this->createWebUrl2('dlinstore'), 'success');
    }else{
          message('拒绝失败！','','error');
    }
}
include $this->template('web/dlinstore');