$list = get_feedback_list($offset, $perpage, $wheresql); $smarty->assign('pageheader', "意见和建议"); $smarty->assign('infotype', $_GET['infotype']); $smarty->assign('perpage', $perpage); $smarty->assign('list', $list); //列表 if ($total_val > $perpage) { $smarty->assign('page', $page->show(3)); //分页符 } $smarty->display('feedback/admin_feedback_suggest_list.htm'); } elseif ($act == 'del_feedback') { check_token(); check_permissions($_SESSION['admin_purview'], "suggest_del"); $id = !empty($_REQUEST['id']) ? $_REQUEST['id'] : adminmsg("你没有选择项目!", 1); if ($num = del_feedback($id)) { write_log("删除意见建议,共删除" . $num . "行", $_SESSION['admin_name'], 3); adminmsg("删除成功!共删除" . $num . "行", 2); } else { adminmsg("删除失败!", 0); } } elseif ($act == 'report_list') { get_token(); check_permissions($_SESSION['admin_purview'], "report_show"); $type = intval($_GET['type']) == 0 ? 1 : intval($_GET['type']); require_once QISHI_ROOT_PATH . 'include/page.class.php'; $oederbysql = " order BY r.id DESC "; if (!empty($_GET['settr'])) { $settr = strtotime("-" . intval($_GET['settr']) . " day"); $wheresql = empty($wheresql) ? " WHERE r.addtime> " . $settr : $wheresql . " AND r.addtime> " . $settr; }
$get_feedback = get_feedback($_SESSION['uid']); if (count($get_feedback) >= 5) { showmsg('反馈信息不能超过5条!', 1); exit; } $setsqlarr['infotype'] = intval($_POST['infotype']); $setsqlarr['feedback'] = trim($_POST['feedback']) ? trim($_POST['feedback']) : showmsg('请填写内容!', 1); $setsqlarr['uid'] = $_SESSION['uid']; $setsqlarr['usertype'] = $_SESSION['utype']; $setsqlarr['username'] = $_SESSION['username']; $setsqlarr['addtime'] = $timestamp; write_memberslog($_SESSION['uid'], 2, 7001, $_SESSION['username'], "添加反馈信息"); !$db->inserttable(table('feedback'), $setsqlarr) ? showmsg("添加失败!", 0) : showmsg("添加成功,请等待管理员回复!", 2); } elseif ($act == 'del_feedback') { $id = intval($_GET['id']); del_feedback($id, $_SESSION['uid']) ? showmsg('删除成功!', 2) : showmsg('删除失败!', 1); } elseif ($act == 'pm') { require_once QISHI_ROOT_PATH . 'include/page.class.php'; $perpage = 10; $uid = intval($_SESSION['uid']); $wheresql = " WHERE (p.msgfromuid='{$uid}' OR p.msgtouid='{$uid}') "; $joinsql = " LEFT JOIN " . table('members') . " AS i ON p.msgfromuid=i.uid "; $orderby = " order by p.pmid desc"; $total_sql = "SELECT COUNT(*) AS num FROM " . table('pms') . ' AS p ' . $wheresql; $total_val = $db->get_total($total_sql); $page = new page(array('total' => $total_val, 'perpage' => $perpage, 'getarray' => $_GET)); $currenpage = $page->nowindex; $offset = ($currenpage - 1) * $perpage; $sql = "SELECT p.* FROM " . table('pms') . ' AS p' . $joinsql . $wheresql . $orderby; //获取所查看消息的pmid , 并且将其修改为已读 $pmid = update_pms_read($offset, $perpage, $sql);