getRow('SELECT * FROM `' . $db_mymps . 'coupon` WHERE id = \'' . $id . '\''); if (empty($edit['id'])) { write_msg('该优惠券已不存在!'); } $edit['des'] = de_textarea_post_change($edit['des']); $acontent = get_editor('content', '', $edit['content'], '100%', '300'); $begindate = $edit['begindate'] ? date('Y-m-d', $edit['begindate']) : ''; $enddate = $edit['enddate'] ? date('Y-m-d', $edit['enddate']) : ''; } else { $title = isset($title) ? trim($title) : ''; $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) : ''; $status = $status == 'yes' || !$status ? 1 : 0; $where = ' WHERE 1'; $where .= $title != '' ? ' AND title LIKE \'%' . $title . '%\'' : ''; $where .= $userid != '' ? ' AND userid = \'' . $userid . '\'' : ''; $where .= $begindate != '' ? ' AND begindate >= \'' . $begindate . '\'' : ''; $where .= $enddate != '' ? ' AND enddate <= \'' . $enddate . '\'' : ''; $where .= !empty($cate_id) ? ' AND cate_id = \'' . $cate_id . '\'' : ''; $where .= !empty($areaid) ? ' AND areaid = \'' . $areaid . '\'' : ''; $where .= ' AND status = \'' . $status . '\''; $rows_num = $db->getOne('SELECT COUNT(id) FROM `' . $db_mymps . 'coupon` ' . $where); $param = setParam(array('part', 'title', 'userid', 'begindate', 'enddate', 'cate_id', 'areaid', 'status')); $begindate = !$begindate ? '' : date('Y-m-d', $begindate); $enddate = !$enddate ? '' : date('Y-m-d', $begindate); $status = empty($status) ? 'no' : 'yes'; $coupon = page1('SELECT * FROM `' . $db_mymps . 'coupon` ' . $where . ' ORDER BY dateline DESC'); } include mymps_tpl('coupon_' . $part); } else { if ($part == 'list') { if (empty($selectedids)) { write_msg('您没有选中任何一个优惠券!'); } $create_in = create_in($selectedids); if (!$action || !in_array($action, array('delall', 'grade0', 'grade1', 'grade2'))) { echo $action; write_msg('您尚未指定处理动作!'); } if ($action == 'delall') { $query = $db->query('SELECT * FROM `' . $db_mymps . 'coupon` WHERE id ' . $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 . 'coupon` WHERE id ' . $create_in); unset($delete); unset($row); unset($query); unset($create_in); } else { if (in_array($action, array('grade0', 'grade1', 'grade2'))) { switch ($action) { case 'grade0': $action = 0; break; case 'grade1': $action = 1; break; case 'grade2': $action = 2; break; } $db->query('UPDATE `' . $db_mymps . 'coupon` SET grade = \'' . $action . '\' WHERE id ' . $create_in); unset($create_in); } } } else { if ($part == 'edit') { if (empty($id)) { write_msg('优惠券编号不能为空!'); } if (empty($title)) { write_msg('优惠券标题不能为空!'); } $name_file = 'coupon_image'; $begindate = intval(strtotime($begindate)); $enddate = intval(strtotime($enddate)); $des = textarea_post_change($des); if ($_FILES[$name_file]['name']) { require_once MYMPS_INC . '/upfile.fun.php'; $destination = '/coupon/' . date('Ym') . '/'; $mymps_image = start_upload($name_file, $destination, 0, $mymps_mymps['cfg_coupon_limit']['width'], $mymps_mymps['cfg_coupon_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 . 'coupon` SET title = \'' . $title . '\',des = \'' . $des . '\',content = \'' . $content . '\',cate_id = \'' . $cate_id . '\',areaid = \'' . $areaid . '\',picture=\'' . $picture . '\',pre_picture=\'' . $pre_picture . '\',begindate = \'' . $begindate . '\',enddate = \'' . $enddate . '\',dateline = \'' . $timestamp . '\' , ctype = \'' . $ctype . '\' , sup = \'' . $sup . '\' , status = \'' . $status . '\',grade=\'' . $grade . '\' WHERE id = \'' . $id . '\''); $url = '?part=edit&id=' . $id; } } write_msg('操作成功!', $url ? $url : '?part=list'); }