\'' . $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);