getRow('SELECT * FROM `' . $db_mymps . 'group` WHERE groupid = \'' . $id . '\''); if (empty($edit['groupid'])) { write_msg('该团购活动已不存在!'); } $edit['des'] = de_textarea_post_change($edit['des']); $edit['othercontent'] = de_textarea_post_change($edit['othercontent']); $acontent = get_editor('content', '', $edit['content'], '100%', '400'); $meetdate = $edit['meetdate'] ? date('Y-m-d', $edit['meetdate']) : ''; $enddate = $edit['enddate'] ? date('Y-m-d', $edit['enddate']) : ''; } else { $gname = isset($gname) ? trim($gname) : ''; $userid = isset($userid) ? trim($userid) : ''; $meetdate = isset($meetdate) ? intval(strtotime($meetdate)) : ''; $enddate = isset($enddate) ? intval(strtotime($enddate)) : ''; $cate_id = isset($cate_id) ? intval($cate_id) : ''; $areaid = isset($areaid) ? intval($areaid) : ''; $where = ' WHERE 1'; $where .= $gname != '' ? ' AND gname LIKE \'%' . $gname . '%\'' : ''; $where .= $userid != '' ? ' AND userid = \'' . $userid . '\'' : ''; $where .= $meetdate != '' ? ' AND meetdate >= \'' . $meetdate . '\'' : ''; $where .= $enddate != '' ? ' AND enddate <= \'' . $enddate . '\'' : ''; $where .= !empty($cate_id) ? ' AND cate_id = \'' . $cate_id . '\'' : ''; $where .= !empty($areaid) ? ' AND areaid = \'' . $areaid . '\'' : ''; $rows_num = $db->getOne('SELECT COUNT(groupid) FROM `' . $db_mymps . 'group` ' . $where); $param = setParam(array('part', 'gname', 'userid', 'meetdate', 'enddate', 'cate_id', 'areaid')); $meetdate = !$meetdate ? '' : date('Y-m-d', $meetdate); $enddate = !$enddate ? '' : date('Y-m-d', $meetdate); $group = page1('SELECT * FROM `' . $db_mymps . 'group` ' . $where . ' ORDER BY displayorder DESC'); } include mymps_tpl('group_' . $part); } else { if ($part == 'list') { if (empty($selectedids)) { write_msg('您没有选中任何一个团购活动!'); } $create_in = create_in($selectedids); if (!$action || !in_array($action, array('delall', 'glevel0', 'glevel1', 'glevel2', 'glevel3', 'glevel4'))) { write_msg('您尚未指定处理动作!'); } if ($action == 'delall') { $query = $db->query('SELECT * FROM `' . $db_mymps . 'group` WHERE groupid ' . $create_in); while ($row = $db->fetchRow($query)) { $delete[$row['id']]['picture'] = $row['picture']; $delete[$row['id']]['pre_picture'] = $row['pre_picture']; } foreach ($delete as $k => $v) { @unlink(MYMPS_ROOT . $v['picture']); @unlink(MYMPS_ROOT . $v['pre_picture']); } $db->query('DELETE FROM `' . $db_mymps . 'group` WHERE groupid ' . $create_in); unset($delete); unset($row); unset($query); unset($create_in); } else { if (in_array($action, array('glevel0', 'glevel1', 'glevel2', 'glevel3', 'glevel4'))) { switch ($action) { case 'glevel0': $action = 0; break; case 'glevel1': $action = 1; break; case 'glevel2': $action = 2; break; case 'glevel3': $action = 3; break; case 'glevel4': $action = 4; break; } $db->query('UPDATE `' . $db_mymps . 'group` SET glevel = \'' . $action . '\' WHERE groupid ' . $create_in); unset($create_in); unset($action); } } } else { if ($part == 'edit') { if (empty($id)) { write_msg('团购活动编号不能为空!'); } if (empty($gname)) { write_msg('活动名称不能为空!'); } if (empty($gaddress)) { write_msg('活动地点不能为空!'); } if (empty($des)) { write_msg('活动简短说明不能为空!'); } if (empty($meetdate)) { write_msg('集合时间不能为空!'); } if (empty($enddate)) { write_msg('截止时间不能为空!'); } $name_file = 'group_image'; $meetdate = intval(strtotime($meetdate)); $enddate = intval(strtotime($enddate)); $des = textarea_post_change($des); $othercontent = textarea_post_change($othercontent); $cate_id = intval($cate_id); $areaid = intval($areaid); $gaddress = trim($gaddress); $signintotal = intval($signintotal); $masterqq = intval($masterqq); $displayorder = intval($displayorder); if ($_FILES[$name_file]['name']) { require_once MYMPS_INC . '/upfile.fun.php'; $destination = '/group/' . date('Ym') . '/'; $mymps_image = start_upload($name_file, $destination, 0, $mymps_mymps['cfg_group_limit']['width'], $mymps_mymps['cfg_group_limit']['height'], $picture, $pre_picture); $picture = $mymps_image[0]; $pre_picture = $mymps_image[1]; unset($mymps_image); } unset($name_file); $db->query('UPDATE `' . $db_mymps . 'group` SET gname=\'' . $gname . '\',des=\'' . $des . '\',content=\'' . $content . '\',cate_id=\'' . $cate_id . '\',areaid=\'' . $areaid . '\',gaddress=\'' . $gaddress . '\',picture=\'' . $picture . '\',pre_picture=\'' . $pre_picture . '\',meetdate=\'' . $meetdate . '\',enddate=\'' . $enddate . '\',dateline=\'' . $timestamp . '\',mastername=\'' . $mastername . '\',masterqq=\'' . $masterqq . '\',glevel=\'' . $glevel . '\',signintotal=\'' . $signintotal . '\',glevel=\'' . $glevel . '\',commenturl=\'' . $commenturl . '\',biztype=\'' . $biztype . '\',othercontent=\'' . $othercontent . '\',displayorder=\'' . $displayorder . '\' WHERE groupid = \'' . $id . '\''); $url = '?part=edit&id=' . $id; } } write_msg('操作成功!', $url ? $url : '?part=list'); }