www.gusucode.com > 08CMS空白站群系统 3.3 繁体 UTF-8 > upload/adminm/fconsults.inc.php

    <?php
load_cache('grouptypes,currencys,fcatalogs,fchannels');
include_once M_ROOT."./include/farcedit.cls.php";
!defined('M_COM') && exit('No Permission');
$fcaidsarr = $fchidsarr = array();
foreach($fcatalogs as $k => $v){
	if($v['cumode']){
		$fcaidsarr[$k] = $v['title'];
		$fchidsarr[$v['chid']] = $fchannels[$v['chid']]['cname'];
	}
}
empty($fcaidsarr) && mcmessage(lang('confirmadd consult message coclass'));
$qstatearr = array(
'new' => lang('nosettle'),
'dealing' => lang('dealing0'),
'end' => lang('settled'),
'close' => lang('closed'),
);
$aid = empty($aid) ? 0 : max(0,intval($aid));
if(!$aid){
	m_guide(22);
	$page = !empty($page) ? max(1, intval($page)) : 1;
	submitcheck('bfilter') && $page = 1;
	$viewdetail = empty($viewdetail) ? '' : $viewdetail;
	$caid = empty($caid) ? 0 : $caid;
	$qstate = empty($qstate) ? '' : $qstate;
	$checked = isset($checked) ? $checked : '-1';
	$subject = empty($subject) ? '' : $subject;
	$indays = empty($indays) ? 0 : max(0,intval($indays));
	$outdays = empty($outdays) ? 0 : max(0,intval($outdays));
	$filterstr = '';
	foreach(array('viewdetail','caid','qstate','checked','subject','indays','outdays') as $k){
		$filterstr .= "&$k=".rawurlencode($$k);
	}
	$wheresql = "WHERE mid=$memberid";
	if($caid){
		$wheresql .= " AND caid='$caid'";
	}else $wheresql .= " AND caid IN (".mimplode(array_keys($fcaidsarr)).")";
	if($qstate) $wheresql .= " AND qstate='$qstate'";
	if($checked != '-1') $wheresql .= " AND checked='$checked'";
	if($subject) $wheresql .= " AND subject LIKE '%".str_replace(array(' ','*'),'%',addcslashes($subject,'%_'))."%'";
	if($indays) $wheresql .= " AND createdate>'".($timestamp - 86400 * $indays)."'";
	if($outdays) $wheresql .= " AND createdate<'".($timestamp - 86400 * $outdays)."'";
	if(!submitcheck('bfarchivesedit')){
		$caidsarr = array('0' => lang('all coclass')) + $fcaidsarr;
		$checkedarr = array('-1' => lang('nolimit'),'0' => lang('nocheck message'),'1' => lang('checked message'));
		tabheader(lang('filter0 consult message').viewcheck('viewdetail',$viewdetail,'tbodyfilter').'&nbsp; &nbsp; '.strbutton('bfilter','filter0'),'farchivesedit',"?action=fconsults&page=$page");
		echo "<tbody id=\"tbodyfilter\" style=\"display: ".(empty($viewdetail) ? 'none' : '')."\">";
		trbasic(lang('belong coclass'),'caid',makeoption($caidsarr,$caid),'select');
		trbasic(lang('deal state'),'',makeradio('qstate',array('' => lang('all state')) + $qstatearr,$qstate),'');
		trbasic(lang('check state'),'',makeradio('checked',$checkedarr,$checked),'');
		trbasic(lang('search title'),'subject',$subject,'text',lang('agsearchkey'));
		trrange(lang('add date'),array('outdays',empty($outdays) ? '' : $outdays,'','&nbsp; '.lang('day before').'&nbsp; -&nbsp; ',5),array('indays',empty($indays) ? '' : $indays,'','&nbsp; '.lang('day in'),5));
		echo "</tbody>";
		tabfooter();

		$pagetmp = $page;
		do{
			$query = $db->query("SELECT * FROM {$tblprefix}farchives $wheresql ORDER BY aid DESC LIMIT ".(($pagetmp - 1) * $mrowpp).",$mrowpp");
			$pagetmp--;
		}while(!$db->num_rows($query) && $pagetmp);
		$itemstr = '';
		while($farchive = $db->fetch_array($query)){
			$catalogstr = $fcatalogs[$farchive['caid']]['title'];
			$farchive['createdate'] = date('y-m-d H:i', $farchive['createdate']);
			$farchive['updatedate'] = date('y-m-d H:i', $farchive['updatedate']);
			$checkedstr = $farchive['checked'] ? "Y" : '-';
			$consultstr = "<a href=\"?action=fconsults&deal=consult&aid=$farchive[aid]\">".($farchive['qstate'] != 'end' ? '<b>'.lang('look').'</b>' : lang('look'))."</a>";
			$editstr = (!$farchive['checked'] || $fcatalogs[$farchive['caid']]['allowupdate']) ? "<a href=\"?action=farchivesedit&aid=$farchive[aid]\">".lang('modify')."</a>" : '-';
			$itemstr .= "<tr><td align=\"center\" class=\"item1\" width=\"30\"><input class=\"checkbox\" type=\"checkbox\" name=\"selectid[$farchive[aid]]\" value=\"$farchive[aid]\">\n".
				"<td class=\"item2\">".mhtmlspecialchars($farchive['subject'])."</td>\n".
				"<td align=\"center\" class=\"item1\">$catalogstr</td>\n".
				"<td align=\"center\" class=\"item2\" width=\"90\">$farchive[createdate]</td>\n".
				"<td align=\"center\" class=\"item1\" width=\"90\">$farchive[updatedate]</td>\n".
				"<td align=\"center\" class=\"item2\" width=\"30\">$checkedstr</td>\n".
				"<td align=\"center\" class=\"item1\">".$qstatearr[$farchive['qstate']]."</td>\n".
				"<td align=\"center\" class=\"item2\" width=\"30\">$consultstr</td>\n".
				"<td align=\"center\" class=\"item1\" width=\"30\">$editstr</td></tr>\n";
		}
		$counts = $db->result_one("SELECT count(*) FROM {$tblprefix}farchives $wheresql");
		$multi = multi($counts,$mrowpp,$page,"?action=fconsults$filterstr");
	
		tabheader(lang('consult message list')."&nbsp;&nbsp;&nbsp;&nbsp;<input class=\"checkbox\" type=\"checkbox\" name=\"select_all\" value=\"1\">&nbsp;".lang('selectallpage'),'','',10);
		trcategory(array("<input class=\"checkbox\" type=\"checkbox\" name=\"chkall\" class=\"category\" onclick=\"checkall(this.form, 'selectid', 'chkall')\">",lang('message title'),lang('coclass'),lang('add time'),lang('update time'),lang('check'),lang('state'),lang('consult'),lang('edit')));
		echo $itemstr;
		tabfooter();
		echo $multi;
		echo "<input class=\"button\" type=\"submit\" name=\"bfarchivesedit\" value=\"".lang('delete')."\"></form>\n";	

	}else{
		if(empty($selectid) && empty($select_all)) mcmessage(lang('confirmselect message'),"?action=fconsults&page=$page$filterstr");
		if(!empty($select_all)){
			$selectid = array();
			$npage = empty($npage) ? 1 : $npage;
			if(empty($pages)){
				$counts = $db->result_one("SELECT count(*) FROM {$tblprefix}farchives $wheresql");
				$pages = @ceil($counts / $mrowpp);
			}
			if($npage <= $pages){
				$fromstr = empty($fromid) ? "" : "aid<$fromid";
				$nwheresql = !$wheresql ? ($fromstr ? "WHERE $fromstr" : "") : ($wheresql.($fromstr ? " AND " : "").$fromstr);
				$query = $db->query("SELECT aid FROM {$tblprefix}farchives $nwheresql ORDER BY aid DESC LIMIT 0,$mrowpp");
				while($item = $db->fetch_array($query)){
					$selectid[] = $item['aid'];
				}
			}
		}

		$aedit = new cls_farcedit;
		foreach($selectid as $aid){
			$aedit->set_aid($aid);
			$aedit->arc_delete(1);
			$aedit->init();
		}
		unset($aedit);
		if(!empty($select_all)){
			$npage ++;
			if($npage <= $pages){
				$fromid = min($selectid);
				$transtr = '';
				$transtr .= "&select_all=1";
				$transtr .= "&pages=$pages";
				$transtr .= "&npage=$npage";
				$transtr .= "&bfarchivesedit=1";
				$transtr .= "&fromid=$fromid";
				mcmessage(lang('operating')."<br>
						".lang('all')." $pages ".lang('page0')."，".lang('dealing')." $npage ".lang('page0')."<br><br>
						<a href=\"?action=fconsults&page=$page$filterstr\">>>".lang('pause')."</a>",
						"?action=fconsults&page=$page$filterstr$transtr",
						500);
			}
		}
		mcmessage(lang('message operate finish'),"?action=fconsults&page=$page$filterstr");
	}
}elseif($deal == 'consult'){
	$forward = empty($forward) ? M_REFERER : $forward;
	$aedit = new cls_farcedit;
	$aedit->set_aid($aid);
	$aedit->basic_data();
	(!$aedit->aid || $aedit->archive['mid'] != $memberid) && mcmessage(lang('confirmchoose message'),$forward);
	!$aedit->archive['checked'] && mcmessage(lang('nocheck message'),$forward);
	$chid = $aedit->archive['chid'];
	$caid = $aedit->archive['caid'];
	if(!($fcatalog = read_cache('fcatalog',$caid)) || !$fcatalog['cumode']) mcmessage(lang('please point consult coclass'),$forward);
	if(!submitcheck('bfconsultadd')){
		tabheader(lang('consult based message'));
		trbasic(lang('consult title'),'',$aedit->archive['subject']."&nbsp;&nbsp;<a href=\"?action=farchivesedit&aid=".$aedit->archive['aid']."\">>>".lang('detail')."</a>",'');
		trbasic(lang('message coclass'),'',$fcatalog['title'],'');
		trbasic(lang('consult add time'),'',date("$dateformat $timeformat",$aedit->archive['createdate']),'');
		tabfooter();
		tabheader(lang('consult commu list').'&nbsp; -- &nbsp;'.$qstatearr[$aedit->archive['qstate']]);
		trcategory(array(lang('based message'),lang('consult and reply content')));
		$query = $db->query("SELECT * FROM {$tblprefix}consults WHERE aid='$aid'");
		while($item = $db->fetch_array($query)){
			$cid = $item['cid'];
			trbasic('<b>'.$item['mname'].'</b>&nbsp; &nbsp; '.(empty($item['reply']) ? lang('consult') : lang('reply')).'&nbsp; :<br>'.date("$dateformat $timeformat",$item['createdate']),'','<br>'.$item['content'].'<br>&nbsp;','');
		}
		tabfooter();
		if($aedit->archive['qstate'] != 'close'){
			tabheader(lang('continue consult'),'fconsultadd','?action=fconsults&deal=consult&aid='.$aid.'&forward='.urlencode($forward));
			trbasic(lang('consult content'),'contentadd','','btextarea');
			tabfooter('bfconsultadd');
		}
	}elseif(submitcheck('bfconsultadd')){
		$aedit->archive['qstate'] == 'close' && mcmessage(lang('this consult item closed'),M_REFERER);
		$contentadd = empty($contentadd) ? '' : trim($contentadd);
		empty($contentadd) && mcmessage(lang('data missing'),M_REFERER);
		$fcatalog['culength'] && $contentadd = cutstr($contentadd,$fcatalog['culength']);
		$contentadd = mnl2br(mhtmlspecialchars($contentadd));
		$db->query("INSERT INTO {$tblprefix}consults SET
					 aid='$aid', 
					 content='$contentadd', 
					 mid='$memberid', 
					 mname='".$curuser->infos['mname']."', 
					 createdate='$timestamp'
					 ");
		$db->query("UPDATE {$tblprefix}farchives SET qstate='new',updatedate='$timestamp' WHERE aid='$aid'");
		mcmessage(lang('add consult succeed'),$forward);
	}
}
?>