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

    <?
!defined('M_COM') && exit('No Permission');
load_cache('channels,acatalogs,currencys');
$catalogs = &$acatalogs;
$page = empty($page) ? 1 : max(1, intval($page));
$caid = empty($caid) ? '0' : $caid;
$chid = empty($chid) ? '0' : $chid;
$viewdetail = empty($viewdetail) ? '' : $viewdetail;
$subject = empty($subject) ? '' : $subject;
$indays = empty($indays) ? 0 : max(0,intval($indays));
$outdays = empty($outdays) ? 0 : max(0,intval($outdays));
$filterstr = '';
foreach(array('viewdetail','subject','caid','chid','indays','outdays') as $k){
	$filterstr .= "&$k=".rawurlencode($$k);
}
$wheresql = "WHERE c.mid=$memberid AND c.oid>0";
if(!empty($caid)){
	$caids = array($caid);
	$tempids = array();
	$tempids = son_ids($catalogs,$caid,$tempids);
	$caids = array_merge($caids,$tempids);
	$wheresql .= " AND a.caid IN (".mimplode($caids).")";
}
if(!empty($chid)) $wheresql .= " AND a.chid='$chid'";
if(!empty($aids)) $wheresql .= " AND c.aid IN (".mimplode(array_filter(explode(',',$aids))).")";
if(!empty($indays)) $wheresql .= " AND c.createdate>'".($timestamp - 86400 * $indays)."'";
if(!empty($outdays)) $wheresql .= " AND c.createdate<'".($timestamp - 86400 * $outdays)."'";

m_guide(25);
$caidsarr = array('0' => lang('all catalog')) + caidsarr();
$chidsarr = array('0' => lang('all channel')) + chidsarr();
tabheader(lang('filter0 goods').viewcheck('viewdetail',$viewdetail,'tbodyfilter').'&nbsp; &nbsp; '.strbutton('bfilter','filter0'),'purchasesedit',"?action=purchases");
echo "<tbody id=\"tbodyfilter\" style=\"display: ".(empty($viewdetail) ? 'none' : '')."\">";
trbasic(lang('belong catalog'),'caid',makeoption($caidsarr,$caid),'select');
trbasic(lang('belong channel'),'chid',makeoption($chidsarr,$chid),'select');
trbasic(lang('archive title'),'subject',$subject);
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></form>";
tabfooter();

$pagetmp = $page;
do{
	$query = $db->query("SELECT c.*,a.sid,a.arcurl,a.caid,a.chid,a.subject FROM {$tblprefix}purchases c LEFT JOIN {$tblprefix}archives a ON (a.aid=c.aid) $wheresql ORDER BY c.cid DESC LIMIT ".(($pagetmp - 1) * $mrowpp).",$mrowpp");
	$pagetmp--;
} while(!$db->num_rows($query) && $pagetmp);
$itemstr = '';
$i = $pagetmp * $mrowpp;
while($item = $db->fetch_array($query)){
	$i ++;
	$item['arcurl'] = view_arcurl($item);
	$item['catalog'] = empty($catalogs[$item['caid']]) ? lang('nocata') : $catalogs[$item['caid']]['title'];
	$item['createdate'] = date("$dateformat", $item['createdate']);
	$item['checkedstr'] = $item['oid'] ? 'Y' : '-';
	$item['orderstr'] = $item['oid'] ? "<a href=\"?action=orders&oid=$item[oid]\">".lang('look')."</a>" : '-';
	$itemstr .= "<tr><td align=\"center\" class=\"item1\" width=\"30\">$i</td>\n".
		"<td class=\"item2\"><a href=\"$item[arcurl]\" target=\"_blank\">".mhtmlspecialchars($item['subject'])."</a></td>\n".
		"<td align=\"center\" class=\"item1\" width=\"80\">$item[catalog]</td>\n".
		"<td align=\"center\" class=\"item2\" width=\"40\">$item[nums]</td>\n".
		"<td align=\"center\" class=\"item1\" width=\"40\">$item[price]</td>\n".
		"<td align=\"center\" class=\"item2\" width=\"40\">$item[orderstr]</td>\n".
		"<td align=\"center\" class=\"item1\" width=\"70\">$item[createdate]</td></tr>\n";
}
$counts = $db->result_one("SELECT count(*) FROM {$tblprefix}purchases c LEFT JOIN {$tblprefix}archives a ON (a.aid=c.aid) $wheresql");
$multi = multi($counts, $mrowpp, $page, "?action=purchases$filterstr");

tabheader(lang('purchased goods list'),'','',9);
trcategory(array(lang('sn'),lang('goods cname'),lang('catalog'),lang('amount'),lang('price'),lang('orders'),lang('purchase date')));
echo $itemstr;
tabfooter();
echo $multi;
?>