1));
}
//调用核心类
include 'source/plugin/xj_event/include/core.class.php';
$eventcore = new xj_eventcore();
include DISCUZ_ROOT . './source/plugin/xj_event/include/func.php';
$tid = intval($_GET['tid']);
//权限限制
$thread = DB::fetch_first("SELECT authorid,userfield,setting,subject,starttime,event_address FROM " . DB::table('forum_thread') . " A," . DB::table('xj_event') . " B WHERE A.tid='$tid' and A.tid = B.tid");
$setting = unserialize($thread['setting']);
$event_starttime = dgmdate($thread['starttime'], 'dt');
//判断是不是管理团队
$event_admin = false;
if (in_array($_G['username'], $setting['event_admin'])) {
$event_admin = true;
}
if ($_G['groupid'] > 1 && $_G['uid'] != $thread['authorid'] && !$event_admin) {
showmessage('quickclear_noperm');
}
if ($_GET['action'] == 'verify' and $_GET['applyid']) {
if (!submitcheck('jmsubmit')) {
showmessage('submit_invalid');
}
$applyids = implode(',', $_GET['applyid']);
if ($_GET['verifyaction'] == 1) {
$checknum = DB::result_first("SELECT SUM(applynumber) FROM " . DB::table('xj_eventapply') . " WHERE applyid in($applyids)"); //本次验证人数
$applynum = DB::result_first("SELECT SUM(applynumber) FROM " . DB::table('xj_eventapply') . " WHERE tid='$tid' and verify=1"); //已报名人数
$applycountnum = DB::result_first("SELECT event_number FROM " . DB::table('xj_event') . " WHERE tid='$tid'"); //活动总人数
if ($checknum <= ($applycountnum - $applynum) or $applycountnum == 0) {
$applys = DB::fetch_all("SELECT uid,tid,fromuid FROM " . DB::table('xj_eventapply') . " WHERE applyid in($applyids)");
foreach ($applys as $value) {
DB::query("UPDATE " . DB::table('xj_eventapply') . " SET verify = 1 WHERE uid=" . $value['uid'] . " AND tid=" . $value['tid']);
}
//DB::query("UPDATE ".DB::table('xj_eventapply')." SET verify = 1 WHERE applyid in($applyids)");
//分享奖励处理
if (file_exists(DISCUZ_ROOT . './source/plugin/xj_event/module/invitation/event_yqjl.php')) {
if ($setting['yqjl_jfs'] > 0) {
$selectlist = DB::fetch_all("SELECT uid,tid,fromuid FROM " . DB::table('xj_eventapply') . " WHERE applyid in($applyids)");
foreach ($selectlist as $value) {
$value['applynumber'] = DB::result_first("SELECT SUM(applynumber) FROM " . DB::table('xj_eventapply') . " WHERE tid=" . $value['tid'] . " AND uid=" . $value['uid']);
if ($value['fromuid'] > 0) {
$yqjl = array();
$yqjl['tid'] = $value['tid'];
$yqjl['fromuid'] = $value['fromuid'];
$yqjl['applyuid'] = $value['uid'];
$yqjl['jfs'] = $setting['yqjl_jfs'] * $value['applynumber'];
$yqjl['jflx'] = $setting['yqjl_jflx'];
$yqjl['dateline'] = $_G['timestamp'];
DB::insert('xj_event_yqjl_log', $yqjl);
updatemembercount($yqjl['fromuid'], array($yqjl['jflx'] => +$yqjl['jfs']));
$applyusername = DB::result_first("SELECT username FROM " . DB::table('common_member') . " WHERE uid=" . $yqjl['applyuid']);
notification_add($yqjl['fromuid'], 'system', $applyusername . lang('plugin/xj_event', 'beiniyaoqinbaomincanjiale') . ' ' . $thread['subject'] . ' ' . lang('plugin/xj_event', 'huodonghuode') . $yqjl['jfs'] . $_G['setting']['extcredits'][$yqjl['jflx']]['title'] . lang('plugin/xj_event', 'jiangli'));
}
}
}
}
//发手机短信
if ($setting['seccode'] == 1) {
include 'include/sms_func.php';
$selectlist = DB::fetch_all("SELECT uid,mobile,applynumber,seccode FROM " . DB::table('xj_eventapply') . " WHERE applyid in($applyids)");
foreach ($selectlist as $value) {
$message = cutstr($thread['subject'], 30) . lang('plugin/xj_event', 'hdbmcgrs') . ':' . $value['applynumber'] . lang('plugin/xj_event', 'renyanzhengma') . ':' . $value['seccode'] . lang('plugin/xj_event', 'huodongshijian') . ' :' . $event_starttime;
//xjsendsms(array($value['mobile']),$message,lang('plugin/xj_event', 'maomyzmdx'));
sendsms_vcode($value['mobile'], $thread['subject'], $value['applynumber'], $value['seccode']);
sendpm($value['uid'], '', $message, $_G['uid']);
}
} elseif ($setting['success_sms'] == 1) {
include 'include/sms_func.php';
$selectlist = DB::fetch_all("SELECT uid,mobile,applynumber,seccode FROM " . DB::table('xj_eventapply') . " WHERE applyid in($applyids)");
foreach ($selectlist as $value) {
sendsms_success($value['mobile'], $thread['subject'], $event_starttime);
//易活动短信
//$smsuid = DB::result_first("SELECT uid FROM ".DB::table('common_member')." WHERE username='".$setting['event_admin'][0]."'");
//$smsmobile = DB::result_first("SELECT mobile FROM ".DB::table('common_member_profile')." WHERE uid=$smsuid");
//sendsms_notice_yhd($value['mobile'],$thread['subject'],$event_starttime,$thread['event_address'],$smsmobile);
}
}
//发送通知
$query = DB::query("SELECT uid FROM " . DB::table('xj_eventapply') . " WHERE applyid in($applyids)");
while ($value = DB::fetch($query)) {
notification_add($value['uid'], 'system', lang('plugin/xj_event', 'ningbmcjd') . ' ' . $thread['subject'] . ' ' . lang('plugin/xj_event', 'yishenghtg'), array(), 0);
//微信消息
if($_G['cache']['plugin']['xj_wxmessage']['wxlogin']){
require_once DISCUZ_ROOT . './source/plugin/xj_wxmessage/class/core.class.php';
$xj_wxmessagecore = new xj_wxmessagecore();
$xj_wxmessagecore->send_eventmessage($value['uid'],$tid,1);
}
}
} else {
$onerror = lang('plugin/xj_event', 'mebgwfsh');
}
} elseif ($_GET['verifyaction'] == 2) {
$applys = DB::fetch_all("SELECT uid,tid FROM " . DB::table('xj_eventapply') . " WHERE applyid in($applyids)");
foreach ($applys as $value) {
DB::query("UPDATE " . DB::table('xj_eventapply') . " SET verify = 0 WHERE uid=" . $value['uid'] . " AND tid=" . $value['tid']);
//邀请奖励的取消奖励
if (file_exists(DISCUZ_ROOT . './source/plugin/xj_event/module/invitation/event_yqjl.php')) {
if ($setting['yqjl_jfs'] > 0) {
$yqjl = DB::fetch_first("SELECT * FROM " . DB::table('xj_event_yqjl_log') . " WHERE tid=" . $value['tid'] . " AND applyuid=" . $value['uid']);
if ($yqjl['jfs'] > 0) {
updatemembercount($yqjl['fromuid'], array($yqjl['jflx'] => -$yqjl['jfs']));
DB::delete('xj_event_yqjl_log', "tid=" . $value['tid'] . " AND applyuid=" . $value['uid']);
$applyusername = DB::result_first("SELECT username FROM " . DB::table('common_member') . " WHERE uid=" . $yqjl['applyuid']);
notification_add($yqjl['fromuid'], 'system', '[' . $thread['subject'] . '] ' . $applyusername . lang('plugin/xj_event', 'beiglqxbmndyqjlsh') . ' -' . $yqjl['jfs'] . $_G['setting']['extcredits'][$yqjl['jflx']]['title']);
}
}
}
}
//DB::query("UPDATE ".DB::table('xj_eventapply')." SET verify = 0 WHERE applyid in($applyids)");
} elseif ($_GET['verifyaction'] == 3) {
$items = DB::fetch_first("SELECT userfield,setting,use_extcredits_num,use_extcredits FROM " . DB::table('xj_event') . " WHERE tid = '$tid'");
if ($items['use_extcredits_num'] > 0) {
$query = DB::query("SELECT uid FROM " . DB::table('xj_eventapply') . " WHERE applyid in($applyids)");
/*
while($value = DB::fetch($query)){
updatemembercount($value['uid'],array($items['use_extcredits']=>$items['use_extcredits_num']));
}
*/
}
$applys = DB::fetch_all("SELECT uid,tid FROM " . DB::table('xj_eventapply') . " WHERE applyid in($applyids)");
foreach ($applys as $value) {
DB::query("DELETE FROM " . DB::table('xj_eventapply') . " WHERE uid=" . $value['uid'] . " AND tid=" . $value['tid']);
//邀请奖励的取消奖励
if (file_exists(DISCUZ_ROOT . './source/plugin/xj_event/module/invitation/event_yqjl.php')) {
if ($setting['yqjl_jfs'] > 0) {
$yqjl = DB::fetch_first("SELECT * FROM " . DB::table('xj_event_yqjl_log') . " WHERE tid=" . $value['tid'] . " AND applyuid=" . $value['uid']);
if ($yqjl['jfs'] > 0) {
updatemembercount($yqjl['fromuid'], array($yqjl['jflx'] => -$yqjl['jfs']));
DB::delete('xj_event_yqjl_log', "tid=" . $value['tid'] . " AND applyuid=" . $value['uid']);
$applyusername = DB::result_first("SELECT username FROM " . DB::table('common_member') . " WHERE uid=" . $yqjl['applyuid']);
notification_add($yqjl['fromuid'], 'system', '[' . $thread['subject'] . '] ' . $applyusername . lang('plugin/xj_event', 'beiglqxbmndyqjlsh') . ' -' . $yqjl['jfs'] . $_G['setting']['extcredits'][$yqjl['jflx']]['title']);
}
}
}
}
}
}
//活动报名字段
$selectuserfield = unserialize($thread['userfield']);
$sysuserfield = unserialize($_G['setting']['activityfield']);
//新的报名字段
if($setting['myuserfield']){
$myuserfield = $eventcore->GetUserField($setting['myuserfield']);
}
$listcount = DB::result_first("SELECT COUNT(*) FROM " . DB::table('xj_eventapply') . " WHERE tid='$tid'");
$perpage = 15; //每页数
$page = $_GET['page'] ? $_GET['page'] : 1;
if (@ceil($listcount / $perpage) < $page) {
$page = 1;
}
$start_limit = ($page - 1) * $perpage;
$multipage = multi($listcount, $perpage, $page, "plugin.php?id=xj_event:event_joinmanage&tid=$tid", 0, 10, false, true, false, 'joinlist_display');
$query = DB::query("SELECT * FROM " . DB::table('xj_eventapply') . " A," . DB::table('common_member') . " B WHERE A.uid = B.uid and A.tid = '$tid' ORDER BY A.verify,A.dateline DESC,A.first DESC LIMIT $start_limit,$perpage");
$joinlist = array();
require_once libfile('function/profile');
loadcache('profilesetting');
$i = 1;
//签到
if (file_exists(DISCUZ_ROOT . './source/plugin/xj_event/module/signed/wsq_signed.php')) {
$signed_enable = true;
}
while ($value = DB::fetch($query)) {
$value['dateline'] = dgmdate($value['dateline'], 'u'); //date('Y-m-d H:i:s',$value['dateline']);
$value['ufielddata'] = unserialize($value['ufielddata']);
//多种报名费用
foreach ($setting['cost'] as $costvalue) {
$value['cost' . $costvalue['id']] = $value['ufielddata']['cost' . $costvalue['id']];
}
$value['costclass'] = $value['ufielddata']['costclass'];
$data = '';
$ufielddata = array();
foreach ($value['ufielddata'] as $key => $fieldid) {
if (strpos($key, 'myfield')===false) {
$data = profile_show($key, $value['ufielddata']);
if ($_G['cache']['profilesetting'][$key]['formtype'] == 'file') {
$data = '' . lang('forum/misc', 'activity_viewimg') . '';
}
if ($key == 'birthday') {
$ufielddata[$key]['value'] = $fieldid;
} else {
$ufielddata[$key]['value'] = $data;
}
if ($key == 'qq') {
$ufielddata[$key]['value'] = '
' . $fieldid;
}
}else{
$ufielddata[$key]['value'] = $fieldid;
}
}
$value['ufielddata'] = $ufielddata;
$value['No'] = $i;
//签到
if ($signed_enable) {
$signed = DB::fetch_first("SELECT * FROM " . DB::table('xj_event_signed') . " WHERE tid='$tid' AND uid=" . $value['uid']);
if ($signed) {
$value['signed_dateline'] = dgmdate($signed['dateline']);
}
}
//支付情况
if ($setting['eventpay']) {
$paylog = DB::fetch_first("SELECT * FROM " . DB::table('xj_eventpay_log') . " WHERE applyid=" . $value['applyid'] . " ORDER BY create_time DESC");
$value['paytype'] = $paylog['paytype'];
$value['price'] = $paylog['total_fee'];
}
$joinlist[] = $value;
$i++;
}
include template('xj_event:join_manage');