zh_tcwq/inc/web/dlinzxpinglun.inc.php

<?php
global $_GPC, $_W;
$action = 'start';
$GLOBALS['frames'] = $this->getNaveMenu($_COOKIE['cityname'], $action);
$operation = !empty($_GPC['op']) ? $_GPC['op'] : 'fieldset_display';
$pageindex = max(1, intval($_GPC['page']));
$pagesize=10;
$where=" WHERE a.uniacid=:uniacid  and b.cityname=:cityname";

if(!empty($_GPC['keywords'])){
    $where.=" and  a.content LIKE  concat('%', :name,'%') ";
    $data[':name']=$_GPC['keywords'];   
}	
$type=isset($_GPC['type'])?$_GPC['type']:'wait';
$status=isset($_GPC['status'])?$_GPC['status']:'1';
if($type=='wait'||$type=='ok'){
    $where.=" and  a.status=:state";
     $data[':state']=$status; 
}
$data[':uniacid']=$_W['uniacid'];
$data[':cityname']=$_COOKIE["cityname"];
$sql="select a.* ,b.title from " . tablename("zhtc_zx_assess") . " a"  . " inner join " . tablename("zhtc_zx") . " b on a.zx_id=b.id ".$where;
$total=pdo_fetchcolumn("select count(*) from " . tablename("zhtc_zx_assess") . " a"  . " inner join " . tablename("zhtc_zx") . " b on a.zx_id=b.id".$where,$data);
	$select_sql =$sql." LIMIT " .($pageindex - 1) * $pagesize.",".$pagesize;
	$list=pdo_fetchall($select_sql,$data);
	$pager = pagination($total, $pageindex, $pagesize);

	if($operation=='info'){
		$sql="select a.* ,b.name from " . tablename("zhtc_zx_assess") ." a" . " left join " . tablename("zhjd_user") . " b on b.id=a.user_id where a.uniacid=:uniacid and a.id=:id";
		$list=pdo_fetch($sql, array(':uniacid'=>$_W['uniacid'],':id'=>$_GPC['id']));
		include $this->template('web/pingluninfo');
	}
	if(checksubmit('submit2')){
		//保存回复
		$result = pdo_update('zhtc_zx_assess', array('reply' => $_GPC['reply'],'status'=>2,'reply_time'=>date("Y-m-d H:i:s")), array('id' =>  $_GPC['id']));
		if($result){
			message('回复成功',$this->createWebUrl2('dlinzxpinglun',array()),'success');
		}else{
			message('回复失败','','error');
		}
	}


	if($operation=='delete'){
		$res=pdo_delete('zhtc_zx_assess',array('id'=>$_GPC['id']));
		if($res){
			message('删除成功',$this->createWebUrl2('dlinzxpinglun',array()),'success');
		}else{
			message('删除失败','','error');
		}
	}


include $this->template('web/dlinzxpinglun');