$joinsql = " LEFT JOIN " . table('members') . " AS i ON p.msgfromuid=i.uid "; $orderby = " order by p.pmid desc"; if ($new > 0) { $wheresql .= " AND p.`new`='{$new}' "; } if ($msgtype > 0) { $wheresql .= " AND p.msgtype='{$msgtype}' "; } $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); if (!empty($pmid)) { $db->query("UPDATE " . table('pms') . " SET `new`='2' WHERE new=1 AND msgtouid='{$uid}' and pmid in (" . $pmid . ")"); } else { $db->query("UPDATE " . table('pms') . " SET `new`='2' WHERE new=1 AND msgtouid='{$uid}'"); } get_pms_no_num(); $smarty->assign('pms', get_pms($offset, $perpage, $sql)); $smarty->assign('total1', $db->get_total("SELECT COUNT(*) AS num FROM " . table('pms') . " WHERE (msgfromuid='{$uid}' OR msgtouid='{$uid}') AND `new`='1' ")); $smarty->assign('total2', $db->get_total("SELECT COUNT(*) AS num FROM " . table('pms') . " WHERE (msgfromuid='{$uid}' OR msgtouid='{$uid}') AND `msgtype`='1'")); $smarty->assign('total3', $db->get_total("SELECT COUNT(*) AS num FROM " . table('pms') . " WHERE (msgfromuid='{$uid}' OR msgtouid='{$uid}') AND `msgtype`='2'")); $smarty->assign('title', '短消息 - 会员中心 - ' . $_CFG['site_name']); $smarty->assign('page', $page->show(3)); $smarty->assign('uid', $uid); $smarty->display('member_train/train_user_pm.htm'); } elseif ($act == 'pm_del') {
$smarty->assign('title', '账号绑定 - 会员中心 - ' . $_CFG['site_name']); $smarty->display('member_company/company_binding.htm'); } 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)); $currenpage = $page->nowindex; $offset = ($currenpage - 1) * $perpage; $sql = "SELECT p.* FROM " . table('pms') . ' AS p' . $joinsql . $wheresql . $orderby; $db->query("UPDATE " . table('pms') . " SET `new`='2' WHERE new=1 AND msgtouid='{$uid}' and pmid in (" . update_pms_read($offset, $perpage, $sql) . ")"); get_pms_no_num(); $smarty->assign('pms', get_pms($offset, $perpage, $sql)); $smarty->assign('total', $db->get_total("SELECT COUNT(*) AS num FROM " . table('pms') . " WHERE (msgfromuid='{$uid}' OR msgtouid='{$uid}') AND `new`='1'")); $smarty->assign('title', '短消息 - 会员中心 - ' . $_CFG['site_name']); $smarty->assign('page', $page->show(3)); $smarty->assign('uid', $uid); // $db->query("UPDATE ".table('pms')." SET `new`='2' WHERE new=1 AND msgtouid='{$uid}'"); // 3.5.2 $smarty->display('member_company/company_user_pm.htm'); } elseif ($act == 'pm_del') { $pmid = intval($_GET['pmid']); $uid = intval($_SESSION['uid']); $pms = $db->getone("select * from " . table('pms') . " where pmid = '{$pmid}' AND (msgfromuid='{$uid}' OR msgtouid='{$uid}') LIMIT 1"); if (!empty($pms)) { $db->query("Delete from " . table('pms') . " WHERE pmid='{$pms['pmid']}'");