public function indexAction()
{
$this->_delete();
$this->_multi();
$page = (int) $this->_request->get("page", 1);
if ($page < 1) {
$page = 1;
}
$perPage = $this->_getPerPage();
$qstring = array();
$sq1 = new Daq_Db_Query();
$sq1->select("count(*) AS `c_all`")->from("Wpjb_Model_Job t2")->where("t2.job_category=t1.id");
$query = new Daq_Db_Query();
$query->select("*");
$query->from("Wpjb_Model_Application t");
$query->join("t.job t2");
$query->order("is_rejected ASC, applied_at DESC");
$query->limitPage($page, $perPage);
if ($this->_request->get("job") > 0) {
$jId = $this->_request->get("job");
$query->where("job_id = ?", $jId);
$this->view->job = new Wpjb_Model_Job($jId);
$qstring["job"] = $jId;
}
$result = $query->execute();
$total = (int) $query->select("COUNT(*) as `total`")->limit(1)->fetchColumn();
$this->view->current = $page;
$this->view->total = ceil($total / $perPage);
$this->view->data = $result;
$qs = "";
foreach ($qstring as $k => $v) {
$qs .= $k . "/" . esc_html((string) $v);
}
$this->view->qstring = $qs;
}
public function addAdminMenu()
{
$ini = Daq_Config::parseIni($this->path("app_config") . "/admin-menu.ini", $this->path("user_config") . "/admin-menu.ini", true);
$logo = site_url() . "/wp-content/plugins/wpjobboard";
$logo .= $this->pathRaw("admin_public") . "/wpjb-mini.png";
if (!$this->conf("cv_enabled")) {
unset($ini['resumes_manage']);
}
$query = new Daq_Db_Query();
$query->select("COUNT(*) AS cnt")->from("Wpjb_Model_Job t1");
$query->join("t1.category t2");
$query->join("t1.type t3");
$query->where("t1.is_approved = 0");
$query->where("t1.is_active = 0");
$pending = $query->fetchColumn();
if (isset($ini["jobs"]["page_title"])) {
$warning = __("jobs awaiting approval", WPJB_DOMAIN);
$ini["jobs"]["menu_title"] = $ini["jobs"]["page_title"];
$ini["jobs"]["menu_title"] .= "<span class='update-plugins wpjb-bubble-jobs count-{$pending}' title='{$warning}'><span class='update-count'>" . $pending . "</span></span>";
}
$query = new Daq_Db_Query();
$query->select();
$query->from("Wpjb_Model_Employer t")->join("t.users u")->select("COUNT(*) AS cnt")->limit(1);
$pending = $query->where("t.is_active=?", 2)->fetchColumn();
if (isset($ini["companies"]["page_title"])) {
$warning = __("employers requesting approval", WPJB_DOMAIN);
$ini["companies"]["menu_title"] = $ini["companies"]["page_title"];
$ini["companies"]["menu_title"] .= "<span class='update-plugins wpjb-bubble-companies count-{$pending}' title='{$warning}'><span class='update-count'>" . $pending . "</span></span>";
}
$query = new Daq_Db_Query();
$query->select()->from("Wpjb_Model_Resume t")->join("t.users t2")->order("t.updated_at DESC");
$query->select("COUNT(*) AS cnt")->limit(1);
$pending = $query->where("t.is_approved=?", Wpjb_Model_Resume::RESUME_PENDING)->fetchColumn();
if (isset($ini["resumes_manage"]["page_title"])) {
$warning = __("resumes pending approval", WPJB_DOMAIN);
$ini["resumes_manage"]["menu_title"] = $ini["resumes_manage"]["page_title"];
$ini["resumes_manage"]["menu_title"] .= "<span class='update-plugins wpjb-bubble-resumes count-{$pending}' title='{$warning}'><span class='update-count'>" . $pending . "</span></span>";
}
foreach ($ini as $key => $conf) {
if (isset($conf['parent'])) {
if (isset($conf["menu_title"])) {
$menu_title = $conf["menu_title"];
} else {
$menu_title = $conf["page_title"];
}
add_submenu_page("wpjb" . $ini[$conf['parent']]['handle'], $conf['page_title'], $menu_title, $conf['access'], "wpjb" . $conf['handle'], array($this, "dispatch"));
} else {
add_menu_page($conf['page_title'], $conf['page_title'], $conf['access'], "wpjb" . $conf['handle'], array($this, "dispatch"), $logo);
}
}
}
