| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667 |
- <?php
- //decode by http://dezend.qiling.org QQ 2859470
- define('CURSCRIPT', 'group_signin');
- require_once dirname(__FILE__) . '/global.php';
- require_once MYMPS_INC . '/db.class.php';
- (!defined('IN_ADMIN') || !defined('IN_MYMPS')) && exit('Access Denied');
- $part = $part ? trim($part) : 'list';
- $id = isset($id) ? intval($id) : '';
- chk_admin_purview('purview_报名管理');
- require_once MYMPS_DATA . '/group_signin_status.inc.php';
- if (!submit_check(CURSCRIPT . '_submit')) {
- if ($part == 'list') {
- $name = isset($name) ? trim($name) : '';
- $userid = isset($userid) ? trim($userid) : '';
- $begindate = isset($begindate) ? intval(strtotime($begindate)) : '';
- $enddate = isset($enddate) ? intval(strtotime($enddate)) : '';
- $cate_id = isset($cate_id) ? intval($cate_id) : '';
- $areaid = isset($areaid) ? intval($areaid) : '';
- $where = ' WHERE 1';
- $where .= $name != '' ? ' AND a.sname LIKE \'%' . $name . '%\'' : '';
- $where .= $userid != '' ? ' AND b.userid = \'' . $userid . '\'' : '';
- $where .= $begindate != '' ? ' AND b.dateline > \'' . $begindate . '\'' : '';
- $where .= $enddate != '' ? ' AND b.dateline < \'' . $enddate . '\'' : '';
- $rows_num = $db->getOne('SELECT COUNT(signid) FROM `' . $db_mymps . 'group_signin` AS a LEFT JOIN `' . $db_mymps . 'group` AS b ON a.groupid = b.groupid ' . $where);
- $param = setParam(array('part', 'name', 'userid', 'dateline'));
- $group = page1('SELECT a.*,b.gname,b.userid FROM `' . $db_mymps . 'group_signin` AS a LEFT JOIN `' . $db_mymps . 'group` AS b ON a.groupid = b.groupid ' . $where . ' ORDER BY dateline DESC');
- $begindate = !$begindate ? '' : date('Y-m-d', $begindate);
- $enddate = !$enddate ? '' : date('Y-m-d', $enddate);
- } else {
- if ($part == 'view') {
- if (empty($id)) {
- write_msg('报名编号不能为空!');
- }
- $view = $db->getRow('SELECT a.*,b.gname FROM `' . $db_mymps . 'group_signin` AS a LEFT JOIN `' . $db_mymps . 'group` AS b ON a.groupid = b.groupid WHERE a.signid = \'' . $id . '\'');
- }
- }
- $here = '团购报名管理';
- include mymps_tpl('group_signin_' . $part);
- } else {
- if (empty($selectedids)) {
- write_msg('您没有选中任何一个报名记录!');
- }
- $create_in = create_in($selectedids);
- if (!$action || !in_array($action, array('delall', 'status0', 'status1'))) {
- write_msg('您尚未指定处理动作!');
- }
- if ($action == 'delall') {
- $db->query('DELETE FROM `' . $db_mymps . 'group_signin` WHERE signid ' . $create_in);
- } else {
- if (in_array($action, array('status0', 'status1'))) {
- switch ($action) {
- case 'status0':
- $action = 0;
- break;
- case 'status1':
- $action = 1;
- break;
- }
- $db->query('UPDATE `' . $db_mymps . 'group_signin` SET status = \'' . $action . '\' WHERE signid ' . $create_in);
- unset($action);
- }
- }
- write_msg('操作成功!', $url ? $url : '??part=list');
- unset($create_in);
- }
- unset($status);
|