/** * 简历列表 */ public function resumeList() { $db = V('resume'); $db->view = array('user_info' => array('type' => 'inner', 'on' => 'resume.uid=user_info.uid', 'field' => 'name')); $cond = array(); if (isset($_GET['resume_name'])) { $cond[] = 'resume_name like "%' . $_GET['resume_name'] . '%"'; } if (isset($_GET['name'])) { $cond[] = 'name like "%' . $_GET['name'] . '%"'; } if (isset($_GET['created'])) { $cond['created'] = array('gt' => strtotime($_GET['created']), 'lt' => time()); } if (isset($_GET['updated'])) { $cond['updated'] = array('gt' => strtotime($_GET['updated']), 'lt' => time()); } if (isset($_GET['verify'])) { $cond['verify'] = $_GET['verify']; } $nums = $db->where($cond)->count(); $page = new page($nums, 13); $resumes = $db->where($cond)->findall($page->limit()); $this->assign('resumes', $resumes); $this->assign('page', $page->show()); $this->display(); }
public function index(){ $total = $this->db->totalShop(); $page = new page($total,1); $data = $this->db->getShop($page->limit()); $this->assign('page',$page->show()); $this->assign('data',$data); $this->display(); }
/** * 显示结果 */ public function word($word) { $where = "uuid like '%" . intval($word) . "%'"; $count = $this->where($where)->count(); $page = new page($count, 10, 4, 2); $union = $this->where($where)->select($page->limit()); return array("union" => $union, "count" => $count, "page" => $page->show()); }
public function lists_select($where = "") { if ($where) { $page = new page($this->where($where)->count(), 10, 5, 1); $video = $this->field("vid,cnname,uploadtime,py_video.cid,username,cntitle,entitle,pid,uuid")->where($where)->order(array("uploadtime" => "desc"))->select($page->limit()); } else { $page = new page($this->count(), 10, 5, 1); $video = $this->field("vid,cnname,uploadtime,py_video.cid,username,cntitle,entitle,pid,uuid")->order(array("uploadtime" => "desc"))->select($page->limit()); } return array($video, $page->show()); }
public function check() { $db = M('wish'); $page = new page($db->count(), 5, 4, 2); $this->assign('page', $page->show()); $wish = $db->select($page->limit()); foreach ($wish as $k => $v) { $wish[$k]['content'] = $this->change_face($v['content']); } $this->assign('wish', $wish); $this->display(); }
function backup($table) { $tables = (include $this->path . '/backup_tables.php'); if (empty($tables)) { //没有要备份的表 $this->error = "要备份的数据表为空!"; return FALSE; } if (!isset($tables[$table])) { return TRUE; //'操作完成' } $this->table = $tables[$table]; //需要操作的表 $this->db = M($this->table, TRUE); $nums = $this->db->count() + 1; $this->Copyright = "-- 该程序通过HDPHP框架构建\n-- Copyright :后盾网-张博\n-- version 2012.09\n-- http://www.houdunwang.com\n-- 主机: " . __WEB__ . "\n-- 备份日期: " . date('Y-m-d H:i:s') . "\n-- 服务器版本: " . $this->db->db->link->server_info . "\n-- PHP 版本: " . phpversion() . "\n\n"; $page = new page($nums, $this->limit); $wfile = $_GET['file']; //分卷文件标识 $file_plus = ''; $file_path = $this->path . '/sql_' . date('Ymd') . '_' . $wfile . '.sql'; $handle = fopen($file_path, 'ab'); if (filesize($file_path) > $this->filesize) { $wfile += 1; $file_plus = '/file/' . $wfile; } if ($table == 0 && $_GET['page'] == 1) { //fwrite($handle, $this->Copyright);//写入版权信息 } if ($_GET['page'] == 1) { //写入建表语句 fwrite($handle, $this->getCreateTableSyntax()); } $data = $this->db->findall($page->limit()); if ($_GET['page'] <= $page->total_page && $data) { // fwrite($handle, $this->db->get_last_sql()."\n");//写入SQL查询语句 fwrite($handle, $this->getInsertSyntax($data)); //写入插入数据语句 go(url_remove_param('page') . '/page/' . ($_GET['page'] + 1) . $file_plus); //fclose($handle); } else { //开始备份下一张表 $_GET['page'] = 1; //将page还原为1 go(url_remove_param('table') . '/table/' . ($_GET['table'] + 1)); } }
function interview() { $db = M('interview'); $con = 'uid=' . $_SESSION['uid']; $count = $db->where($con)->count(); $page = new page($count, 15); $views = $db->where($con)->findall($page->limit()); $this->assign('views', $views); $this->assign('page', $page->show()); $this->display('profile/interview'); }
public function feedback() { $type = array(1 => '建议', 2 => '咨询', 3 => '举报', 4 => '求助'); $this->assign('type', $type); $db = M('feedback'); $nums = $db->count(); $page = new page($nums, 15); $fbs = $db->order('process')->findall($page->limit()); $this->assign('fbs', $fbs); $this->assign('type', $type); $this->assign('page', $page->show()); $this->display(); }
public function resume() { $auth = new auth(); if (!$auth->is_logged_in()) { $this->error(L('please_login'), 'auth/index'); } if (!$auth->check_uri_permissions()) { $this->error($auth->error); } $db = M('model_field'); $filterCond = array(); //处理选项搜索字段 $switch_field = $db->field('title,field_name')->where('field_type="switch" and join_index=1 and dmid=6')->findall(); $model_struct = (include PATH_ROOT . '/caches/model/field/m_resume_basic.php'); foreach ($switch_field as $value) { $filterCond['switchs'][$value['field_name']] = $model_struct[$value['field_name']]['data']; } //处理选项联动搜索字段 $linkage_filed = $db->field('title,field_name,lcgid')->where('field_type="linkage" and join_index=1 and dmid=6')->findall(); foreach ($linkage_filed as $value) { $data = $db->table('linkage')->cache(86400)->field('laid,title')->where('lcgid=' . $value['lcgid'])->findall(); $filterCond['linkages'][$value['field_name']] = array('title' => $value['title'], 'data' => $data); } //处理选项地区搜索字段 $filterCond['address'] = $db->table('city')->cache(86400)->field('id,name,direct')->where('pid=0')->findall(); //地区 if (isset($_GET['address'])) { $filterCond['sonAddress'] = $db->table('city')->cache(86400)->field('id,name')->where('pid=' . $_GET['address'])->findall(); //地区子类 } $where = array('open' => 1, 'verify' => 1); //resume表的条件:公开已验证 if (isset($_GET['address'])) { //地址 $where[] = 'hope_provice=' . intval($_GET['address']); } if (isset($_GET['city'])) { //地址 $where[] = 'hope_city=' . intval($_GET['city']); } if (isset($_GET['work_exp'])) { //工作经验 $where[] = 'work_exp=' . intval($_GET['work_exp']); } if (isset($_GET['updated'])) { //更新时间 $where['updated'] = 'updated >' . strtotime('-' . $_GET['updated'] . 'days'); } $keywords = array(); if (!empty($_GET['keywords'])) { //关键字 $_GET['keywords'] = strip_tags($_GET['keywords']); $keywords = array_keys(string::split_word($_GET['keywords'])); $keyword_cond = ''; foreach ($keywords as $value) { $keyword_cond .= 'resume_name LIKE "%' . $value . '%" OR '; } $keyword_cond = rtrim($keyword_cond, 'OR '); $where[] = $keyword_cond; } $db = V('resume'); $db->view = array('resume_basic' => array('type' => 'INNER', 'on' => 'resume.resume_id=resume_basic.resume_id')); $nums = $db->where($where)->count(); $page = new page($nums, 10); $resumes = $db->where($where)->findall($page->limit()); if ($resumes) { $data_class = new data('resume_basic'); foreach ($resumes as $key => $value) { $resumes[$key] = $data_class->convert($value); } } $this->assign('resumes', $resumes); $this->assign('filterCond', $filterCond); $this->assign('page', $page->show()); $this->display('search-resume'); }
/** * 查看收藏简历 */ public function viewFav() { $db = M('favorite'); $nums = $db->where('type=2 AND company_id=' . $_SESSION['uid'])->count(); $page = new page($nums, 15); $favorites = $db->where('type=2 AND company_id=' . $_SESSION['uid'])->order('created desc')->findall($page->limit()); $this->assign('favorites', $favorites); $this->assign('page', $page->show()); $this->display('company/viewFav'); }
/** * 企业收到的投递简历 */ public function receiveDelivers($cond, $field = '', $order = 'sendtime desc') { $data = array(); $db = V('deliver'); $db->view = array('resume_basic' => array('type' => "INNER", 'on' => 'deliver.resume_id=resume_basic.resume_id', 'field' => 'name')); $nums = $db->field($field)->where($cond)->count(); $page = new page($nums, 13); $data['deliver'] = $db->field($field)->where($cond)->order($order)->findall($page->limit()); $data['page'] = $page->show(); return $data; }
public function hotKeyword() { $db = M('keywords'); $nums = $db->count(); $page = new page($nums, 12); $keywords = $db->order('nums desc')->findall($page->limit()); $this->assign('keywords', $keywords); $this->assign('page', $page->show()); $this->display(); }
/** * 取得联动数据,一级一级显示 */ function getLinkageData($condition) { $data = array(); $nums = $this->linkage_model->where($condition)->count(); $page = new page($nums, 10, 6); //传入总记录数,用于计算出分页 $data['page'] = $page->show(); //显示分页页码 $cache_name = 'linkage_' . $condition['lcgid'] . '_' . $condition['pid']; //配置缓存名称 $cache_dir = $this->cache_dir . 'linkage'; $data['data'] = $this->linkage_model->where($condition)->order('sort')->findall($page->limit()); return $data; }
/** * 招聘列表 */ public function recruitList() { $db = M('recruit'); //组合条件 $cond = array(); if (isset($_GET['recruit_name'])) { $cond[] = 'recruit_name like "%' . $_GET['recruit_name'] . '%"'; } if (isset($_GET['company_name'])) { $cond[] = 'company_name like "%' . $_GET['company_name'] . '%"'; } if (isset($_GET['created'])) { $cond['created'] = array('gt' => strtotime($_GET['created']), 'lt' => time()); } if (isset($_GET['refresh_date'])) { $cond['refresh_date'] = array('gt' => strtotime($_GET['refresh_date']), 'lt' => time()); } if (isset($_GET['state'])) { if ($_GET['state'] == 2) { //已过期 $cond[] = 'expiration_time <' . time(); } else { $cond['state'] = $_GET['state']; } } if (isset($_GET['verify'])) { $cond['verify'] = $_GET['verify']; } //组合条件 $field = 'recruit_id,recruit_name,created,refresh_date,company_name,state,verify,expiration_time,views'; $nums = $db->where($cond)->count(); $page = new page($nums, 15); $recruits = $db->field($field)->where($cond)->order('created desc')->findall($page->limit()); $this->assign('recruits', $recruits); $this->assign('page', $page->show()); $this->display(); }
function userList($cond = array()) { if (!empty($cond['group'])) { //如果有用户组条件 $db = V('user'); $db->view = array('user_role' => array('type' => 'inner', 'on' => 'user.uid =user_role.uid'), 'role' => array('type' => 'inner', 'on' => 'user_role.rid=role.rid')); $nums = $db->where($cond['user'], $cond['group'])->count(); $page = new page($nums, 12); $users = array(); $users['user'] = $db->where($cond['user'], $cond['group'])->findall(); $users['page'] = $page->show(); } else { $nums = $this->user_r_model->where($cond['user'])->count(); $page = new page($nums, 12); $users = array(); $users['user'] = $this->user_r_model->where($cond['user'])->order('created desc')->findall($page->limit()); $users['page'] = $page->show(); } return $users; }
/** * 企业操作日志 */ public function optLog($cond) { $db = M('opt_log'); $nums = $db->where($cond)->count(); $page = new page($nums, 15); $logs = array(); $logs['log'] = $db->where($cond)->order('created desc')->findall($page->limit()); $logs['page'] = $page->show(); return $logs; }