group_signin.php 3.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667
  1. <?php
  2. //decode by http://dezend.qiling.org QQ 2859470
  3. define('CURSCRIPT', 'group_signin');
  4. require_once dirname(__FILE__) . '/global.php';
  5. require_once MYMPS_INC . '/db.class.php';
  6. (!defined('IN_ADMIN') || !defined('IN_MYMPS')) && exit('Access Denied');
  7. $part = $part ? trim($part) : 'list';
  8. $id = isset($id) ? intval($id) : '';
  9. chk_admin_purview('purview_报名管理');
  10. require_once MYMPS_DATA . '/group_signin_status.inc.php';
  11. if (!submit_check(CURSCRIPT . '_submit')) {
  12. if ($part == 'list') {
  13. $name = isset($name) ? trim($name) : '';
  14. $userid = isset($userid) ? trim($userid) : '';
  15. $begindate = isset($begindate) ? intval(strtotime($begindate)) : '';
  16. $enddate = isset($enddate) ? intval(strtotime($enddate)) : '';
  17. $cate_id = isset($cate_id) ? intval($cate_id) : '';
  18. $areaid = isset($areaid) ? intval($areaid) : '';
  19. $where = ' WHERE 1';
  20. $where .= $name != '' ? ' AND a.sname LIKE \'%' . $name . '%\'' : '';
  21. $where .= $userid != '' ? ' AND b.userid = \'' . $userid . '\'' : '';
  22. $where .= $begindate != '' ? ' AND b.dateline > \'' . $begindate . '\'' : '';
  23. $where .= $enddate != '' ? ' AND b.dateline < \'' . $enddate . '\'' : '';
  24. $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);
  25. $param = setParam(array('part', 'name', 'userid', 'dateline'));
  26. $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');
  27. $begindate = !$begindate ? '' : date('Y-m-d', $begindate);
  28. $enddate = !$enddate ? '' : date('Y-m-d', $enddate);
  29. } else {
  30. if ($part == 'view') {
  31. if (empty($id)) {
  32. write_msg('报名编号不能为空!');
  33. }
  34. $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 . '\'');
  35. }
  36. }
  37. $here = '团购报名管理';
  38. include mymps_tpl('group_signin_' . $part);
  39. } else {
  40. if (empty($selectedids)) {
  41. write_msg('您没有选中任何一个报名记录!');
  42. }
  43. $create_in = create_in($selectedids);
  44. if (!$action || !in_array($action, array('delall', 'status0', 'status1'))) {
  45. write_msg('您尚未指定处理动作!');
  46. }
  47. if ($action == 'delall') {
  48. $db->query('DELETE FROM `' . $db_mymps . 'group_signin` WHERE signid ' . $create_in);
  49. } else {
  50. if (in_array($action, array('status0', 'status1'))) {
  51. switch ($action) {
  52. case 'status0':
  53. $action = 0;
  54. break;
  55. case 'status1':
  56. $action = 1;
  57. break;
  58. }
  59. $db->query('UPDATE `' . $db_mymps . 'group_signin` SET status = \'' . $action . '\' WHERE signid ' . $create_in);
  60. unset($action);
  61. }
  62. }
  63. write_msg('操作成功!', $url ? $url : '??part=list');
  64. unset($create_in);
  65. }
  66. unset($status);