$wheresql .= " AND a.addtime>" . $settr_val; } $perpage = 10; $total_sql = "SELECT COUNT(*) AS num FROM " . table('view_jobs') . " AS a {$wheresql} "; $total_val = $db->get_total($total_sql); $page = new page(array('total' => $total_val, 'perpage' => $perpage)); $offset = ($page->nowindex - 1) * $perpage; $smarty->assign('title', '浏览记录 - 个人会员中心 - ' . $_CFG['site_name']); $smarty->assign('jobs_list', get_view_jobs($offset, $perpage, $joinsql . $wheresql)); if ($total_val > $perpage) { $smarty->assign('page', $page->show(3)); } $smarty->display('member_personal/personal_my_attention.htm'); } elseif ($act == 'del_view_jobs') { $yid = !empty($_REQUEST['y_id']) ? $_REQUEST['y_id'] : showmsg("你没有选择项目!", 1); if ($n = del_view_jobs($yid, $_SESSION['uid'])) { showmsg("删除成功!共删除 {$n} 行", 2); } else { showmsg("删除失败!", 0); } } elseif ($act == 'attention_me') { require_once QISHI_ROOT_PATH . 'include/page.class.php'; $joinsql = " LEFT JOIN " . table('resume') . " AS r ON a.resumeid=r.id "; $resume = get_auditresume_list($_SESSION['uid']); foreach ($resume as $k => $v) { $rid[] = $v['id']; } if (!empty($rid)) { $rid_str = implode(",", $rid); $total_sql = "SELECT COUNT(*) AS num FROM " . table('view_resume') . " AS a where resumeid in (" . $rid_str . ")"; $total_val = $db->get_total($total_sql);
} $perpage = 10; $total_sql = "SELECT COUNT(*) AS num FROM " . table('view_jobs') . " {$wheresql} "; $total_val = $db->get_total($total_sql); $page = new page(array('total' => $total_val, 'perpage' => $perpage)); $offset = ($page->nowindex - 1) * $perpage; $smarty->assign('title', '浏览记录 - 企业会员中心 - ' . $_CFG['site_name']); $smarty->assign('jobs', get_my_jobs($_SESSION['uid'], true)); $smarty->assign('user_list', get_view_users($offset, $perpage, $wheresql)); if ($total_val > $perpage) { $smarty->assign('page', $page->show(3)); } $smarty->display('member_company/company_view_jobs.htm'); } elseif ($act == 'del_view_jobs') { $yid = !empty($_REQUEST['y_id']) ? $_REQUEST['y_id'] : showmsg("你没有选择项目!", 1); if (!del_view_jobs($yid)) { showmsg("删除失败!", 0); } else { showmsg("删除成功!", 2); } } elseif ($act == "refresh_appointment") { /* 判断套餐 */ if ($_CFG['operation_mode'] == "3") { $setmeal = get_user_setmeal($_SESSION['uid']); if ($_CFG['setmeal_to_points'] == "1") { $add_mode = 1; } else { $add_mode = 2; } } elseif ($_CFG['operation_mode'] == "2") { $add_mode = 2;
} $perpage = 10; $total_sql = "SELECT COUNT(*) AS num FROM " . table('view_jobs') . " AS a {$wheresql} "; $page = new page(array('total' => $db->get_total($total_sql), 'perpage' => $perpage)); $offset = ($page->nowindex - 1) * $perpage; $smarty->assign('total_val', $total_val); $smarty->assign('total_seven_val', $total_seven_val); $smarty->assign('total_fourteen_val', $total_fourteen_val); $smarty->assign('title', '浏览记录 - 个人会员中心 - ' . $_CFG['site_name']); $smarty->assign('jobs_list', get_view_jobs($offset, $perpage, $joinsql . $wheresql)); $smarty->assign('page', $page->show(3)); $smarty->display('member_personal/personal_my_attention.htm'); } elseif ($act == 'del_view_jobs') { $yid = !empty($_REQUEST['y_id']) ? $_REQUEST['y_id'] : showmsg("你没有选择项目!", 1); $delete = $_POST['delete']; $delete ? !del_view_jobs($yid, $_SESSION['uid']) ? showmsg("删除失败!", 0) : showmsg("删除成功!", 2) : showmsg("删除失败!", 0); } elseif ($act == 'attention_me') { require_once QISHI_ROOT_PATH . 'include/page.class.php'; $joinsql = " LEFT JOIN " . table('resume') . " AS r ON a.resumeid=r.id "; $resume = get_auditresume_list($_SESSION['uid']); foreach ($resume as $k => $v) { $rid[] = $v['id']; } if (!empty($rid)) { $rid_str = implode(",", $rid); $total_sql = "SELECT COUNT(*) AS num FROM " . table('view_resume') . " AS a where resumeid in (" . $rid_str . ")"; $total_val = $db->get_total($total_sql); $wheresql = " where a.resumeid in (" . $rid_str . ") "; } else { $total_val = 0; }