zh_tcwq/inc/web/carinfo.inc.php

<?php

global $_GPC, $_W;
$GLOBALS['frames'] = $this->getMainMenu();
$where="WHERE  uniacid=:uniacid ";
if(!empty($_GPC['keywords'])){
    $op=$_GPC['keywords'];
      $where.=" and (start_place LIKE  concat('%', :name,'%') or end_place LIKE  concat('%', :name,'%'))";  
       $data[':name']=$op;
}
if(!empty($_GPC['time'])){
   $start=strtotime($_GPC['time']['start']);
   $end=strtotime($_GPC['time']['end']);
  $where.=" and time >={$start} and time<={$end}";

}
$state=$_GPC['state'];
$pageindex = max(1, intval($_GPC['page']));
$pagesize=10;
$type=isset($_GPC['type'])?$_GPC['type']:'all';
 $data[':uniacid']=$_W['uniacid'];
if($type=='all'){   
  $sql="select * from" . tablename("zhtc_car") .$where."  order by top,time desc ";
  $total=pdo_fetchcolumn("select count(*)  from " . tablename("zhtc_car") .$where,$data);
}else{
    $where.= " and state=$state";
   $sql="select * from" . tablename("zhtc_car") .$where."  order by top,time desc ";  
     $total=pdo_fetchcolumn("select count(*)  from " . tablename("zhtc_car") .$where,$data);
}
$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_car',array('id'=>$_GPC['id']));
    if($res){
         message('删除成功！', $this->createWebUrl('carinfo'), 'success');
        }else{
              message('删除失败！','','error');
        }
}
if($_GPC['op']=='tg'){
    $res=pdo_update('zhtc_car',array('state'=>2,'sh_time'=>time()),array('id'=>$_GPC['id']));
    if($res){
          message('通过成功！', $this->createWebUrl('carinfo'), 'success');
        }else{
          message('通过失败！','','error');
        }
}
if($_GPC['op']=='jj'){
    $res=pdo_update('zhtc_car',array('state'=>3,'sh_time'=>time()),array('id'=>$_GPC['id']));
    if($res){
         message('拒绝成功！', $this->createWebUrl('carinfo'), 'success');
        }else{
         message('拒绝失败！','','error');
        }
}
include $this->template('web/carinfo');