zijia/source/plugin/xj_event/admin_paymanage.inc.php

<?php
if(!defined('IN_DISCUZ') || !defined('IN_ADMINCP')) {
	exit('Access Denied');
}
include 'source/plugin/xj_event/include/core.class.php';
$eventcore = new xj_eventcore();



if($_GET['act'] == 'search'){
	$keyword = addslashes($_GET['keyword']);
	$sqlstr = " AND (D.subject like '%".str_replace(array('%', '*', '_'), array('\%', '%', '\_'), $keyword)."%' OR C.username like '%".str_replace(array('%', '*', '_'), array('\%', '%', '\_'), $keyword)."%')";
	$extra = "&keyword=".$_GET['keyword']."&act=search";
}



showsubmenu(lang('plugin/xj_event', 'huodongbaomingzhifuguanli'));
echo '<div><form name="form1" method="post" action="'.ADMINSCRIPT.'?action=plugins&operation=config&do=$pluginid&identifier=xj_event&pmod=admin_paymanage&act=search">'.lang('plugin/xj_event', 'guanjianzi').'<input type="text" name="keyword" value=""> <input type="submit" name="button" id="button" value="'.lang('plugin/xj_event', 'chazhao').'" /></form></div>';
showtableheader(lang('plugin/xj_event', 'huodonggl'));
showtablerow('',array(),array('ID',lang('plugin/xj_event', 'huodongmingcheng'),lang('plugin/xj_event', 'yonghuming'),lang('plugin/xj_event', 'baomingrs'),lang('plugin/xj_event', 'zhifujine'),lang('plugin/xj_event', 'baomingsj'),lang('plugin/xj_event', 'zhifuleixing'),lang('plugin/xj_event','dindanhao'),lang('plugin/xj_event', 'zhifushijian'),''),'');
$ppp = 15;   //ÿÌìÊýÁ¿
$page = $_GET['page']?intval($_GET['page']):1;
$count = DB::result_first("SELECT COUNT(*) FROM ".DB::table('xj_eventapply')." A LEFT JOIN ".DB::table('xj_eventpay_log')." B ON A.applyid=B.applyid LEFT JOIN ".DB::table('common_member')." C ON A.uid=C.uid LEFT JOIN ".DB::table('forum_thread')." D ON A.tid=D.tid WHERE A.first=1 AND B.paystate=3 ".$sqlstr);
$query = DB::query("SELECT A.*,B.*,C.username,D.subject FROM ".DB::table('xj_eventapply')." A LEFT JOIN ".DB::table('xj_eventpay_log')." B ON A.applyid=B.applyid LEFT JOIN ".DB::table('common_member')." C ON A.uid=C.uid LEFT JOIN ".DB::table('forum_thread')." D ON A.tid=D.tid WHERE A.first=1 AND B.paystate=3 $sqlstr ORDER BY dateline DESC LIMIT ".(($page - 1) * $ppp).",$ppp");
while($value = DB::fetch($query)) {
	if($value['tid']){
		$value['subject'] = DB::result_first("SELECT subject FROM ".DB::table('forum_thread')." WHERE tid=".$value['tid']);
	}
	$value['applynumber'] = $eventcore->GetEventApply($value['tid'],$value['uid']);
	if($value['paytype'] == 'alipay'){
		$value['paytype'] = lang('plugin/xj_event', 'zhifubao');
	}elseif($value['paytype'] == 'wxpay'){
		$value['paytype'] = lang('plugin/xj_event', 'weixzf');
	}elseif($value['paytype'] == 'tenpay'){
		$value['paytype'] = lang('plugin/xj_event', 'caifutong');
	}elseif($value['paytype'] == 'appwxpay'){
		$value['paytype'] = 'APP'.lang('plugin/xj_event', 'weixzf');
	}
	
	showtablerow('', array('class="td25"', 'class="td28"'), array($value['eid'],$value['subject'],$value['username'],$value['applynumber'],$value['total_fee'],dgmdate($value['dateline']),$value['paytype'],$value['tradeno'],dgmdate($value['notify_time'])));
}

showtablefooter();



echo multi($count, $ppp, $page, ADMINSCRIPT."?action=plugins&operation=config&do=$pluginid&identifier=xj_event&pmod=admin_paymanage$extra");
//showsubmit('picsubmit', 'delete', $detail ? 'del' : '', '', $multi);
?>