'.lang('plugin/xj_event', 'guanjianzi').'

'; 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); ?>