public function execute() { $db = Daq_Db::getInstance()->getDb(); $db->query("ALTER TABLE `wpjb_field_value` DROP FOREIGN KEY `wpjb_field_value_ibfk_2`"); $db->query("ALTER TABLE `wpjb_discount` ADD `used` INT( 11 ) NOT NULL ,ADD `max_uses` INT( 11 ) NOT NULL "); $db->query("ALTER TABLE `wpjb_job` ADD `discount_id` INT( 11 ) NOT NULL DEFAULT 0"); }
public function execute() { $this->_sql($this->getVersion()); set_time_limit(0); $query = new Daq_Db_Query(); $query->select()->from("Wpjb_Model_Job t")->joinLeft("t.search s")->where("is_active = 1")->where("s.job_id IS NULL"); foreach ($query->execute() as $job) { Wpjb_Model_JobSearch::createFrom($job); } $db = Daq_Db::getInstance(); $wpdb = $db->getDb(); $config = Wpjb_Project::getInstance(); $config->setConfigParam("front_template", "twentyten"); $config->saveConfig(); if (!Wpjb_Project::getInstance()->conf("link_jobs")) { $jId = wp_insert_post(array('post_type' => 'page', 'post_status' => 'publish', 'post_title' => 'Jobs', 'comment_status' => 'closed', 'ping_status' => 'closed')); $config->setConfigParam("link_jobs", $jId); $config->saveConfig(); } if (!Wpjb_Project::getInstance()->conf("link_resumes")) { $rId = wp_insert_post(array('post_type' => 'page', 'post_status' => 'publish', 'post_title' => 'Resumes', 'comment_status' => 'closed', 'ping_status' => 'closed')); $config->setConfigParam("link_resumes", $rId); $config->saveConfig(); } return; }
public function execute() { $db = Daq_Db::getInstance()->getDb(); $db->query("ALTER TABLE `wpjb_job` ADD `job_expires_at` DATETIME NOT NULL AFTER `job_created_at`"); $db->query("UPDATE `wpjb_job` SET `job_expires_at` = DATE_ADD(`job_created_at`, INTERVAL `job_visible` DAY)"); $db->query("ALTER TABLE `wpjb_additional_field` ADD `field_for` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1' COMMENT '1:job; 2:job apply, 3:resume'"); $db->query("UPDATE `wpjb_additional_field` SET field_for = 1"); wp_schedule_event(time(), "daily", "wpjb_event_counter"); }
protected function _sql($version) { $file = Wpjb_List_Path::getPath("install") . "/install-" . $version . ".sql"; $queries = explode("; --", file_get_contents($file)); $db = Daq_Db::getInstance(); $wpdb = $db->getDb(); foreach ($queries as $query) { $wpdb->query($query); } }
public function execute() { $config = Wpjb_Project::getInstance(); $config->setConfigParam("api_twitter_username", ""); $config->setConfigParam("api_twitter_password", ""); $config->saveConfig(); $db = Daq_Db::getInstance()->getDb(); $db->query("DELETE FROM `wpjb_field_value` WHERE (SELECT `wpjb_job`.`id` FROM `wpjb_job` WHERE `wpjb_job`.`id`=`job_id` LIMIT 1) IS NULL"); $db->query("ALTER TABLE `wpjb_field_value` ADD FOREIGN KEY ( `job_id` ) REFERENCES `wpjb_job` (`id`) ON DELETE CASCADE ON UPDATE CASCADE"); // SELECT wpjb_field_value.id, wpjb_job.id FROM `wpjb_field_value` LEFT JOIN `wpjb_job` ON `wpjb_job`.`id`=`job_id` return; }
public function editAction() { $form = new Wpjb_Form_Admin_AdditionalField($this->_request->getParam("id")); $object = $form->getObject(); $oldType = $object->type; if ($this->isPost()) { $isValid = $form->isValid($this->_request->getAll()); if ($isValid) { $this->_addInfo(__("Form saved.", WPJB_DOMAIN)); $form->save(); if ($this->_request->getParam("type") == 4) { $id = $form->getObject()->getId(); $opt = $this->_request->getParam("option"); $this->_saveOptions($id, $opt); } if ($oldType == 4 && $this->_request->getParam("type") != 4) { $temp = new Wpjb_Model_FieldOption(); $table = $temp->tableName(); Daq_Db::getInstance()->delete($table, "field_id=" . $object->getId()); } } else { $this->_addError(__("There are errors in your form.", WPJB_DOMAIN)); } } $this->view->option = "{}"; if ($object->getId() > 0) { $query = new Daq_Db_Query(); $optionList = $query->select("t.*")->from("Wpjb_Model_FieldOption t")->where("field_id = ?", $object->getId())->execute(); $json = array(); foreach ($optionList as $option) { $obj = new stdClass(); $obj->id = $option->id; $obj->value = $option->value; $json[] = $obj; } $this->view->option = json_encode($json); } $this->view->typeValue = $object->type; $this->view->form = $form; }
public function execute() { $db = Daq_Db::getInstance()->getDb(); $db->query("ALTER TABLE `wpjb_field_value` CHANGE `value` `value` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL"); return; }
public function __construct($id = null) { $db = Daq_Db::getInstance()->getDb(); $this->_name = $db->users; parent::__construct($id); }
public function getDb() { return Daq_Db::getInstance()->getDb(); }
public function cleanupAction() { $db = Daq_Db::getInstance()->getDb(); // SELECT * FROM `wpjb_employer` LEFT JOIN `wp_users` on `user_id`=`wp_users`.`ID` WHERE `wp_users`.`ID` IS NULL // cleanup dirs: apply, tmp }
public function install() { global $wpdb, $wp_rewrite; if (stripos(PHP_OS, "win") !== false || true) { $mods = explode(",", $wpdb->get_var("SELECT @@session.sql_mode")); $mods = array_map("trim", $mods); $invalid = array("STRICT_TRANS_TABLES", "STRICT_ALL_TABLES", "TRADITIONAL"); foreach ($invalid as $m) { if (in_array($m, $mods)) { $wpdb->query("SET @@session.sql_mode='' "); break; } } } $db = Daq_Db::getInstance(); if ($db->getDb() === null) { $db->setDb($wpdb); } wp_clear_scheduled_hook("wpjb_event_counter"); wp_schedule_event(time(), "daily", "wpjb_event_counter"); $instance = self::getInstance(); $appj = $instance->getApplication("frontend"); $appr = $instance->getApplication("resumes"); $config = $instance; $wp_rewrite->flush_rules(); if ($appj->getPage() === null) { // link new page /* @var $appj Wpjb_Application_Frontend */ $jId = wp_insert_post(array('post_type' => 'page', 'post_status' => 'publish', 'post_title' => 'Jobs', 'comment_status' => 'closed', 'ping_status' => 'closed', 'post_content' => $appj->getOption("shortcode"))); $config->setConfigParam("link_jobs", $jId); $config->saveConfig(); } if ($appr->getPage() === null) { // link new page $rId = wp_insert_post(array('post_type' => 'page', 'post_status' => 'publish', 'post_title' => 'Resumes', 'comment_status' => 'closed', 'ping_status' => 'closed', 'post_content' => $appr->getOption("shortcode"))); $config->setConfigParam("link_resumes", $rId); $config->saveConfig(); } update_usermeta(wp_get_current_user()->ID, "is_employer", 1); if ($this->conf("front_template") !== null) { return true; } $config->setConfigParam("front_show_related_jobs", 1); $config->setConfigParam("cv_enabled", 1); $config->saveConfig(); $file = $this->path("install") . "/install.sql"; $queries = explode("; --", file_get_contents($file)); foreach ($queries as $query) { $wpdb->query($query); } $email = get_option("admin_email"); $query = new Daq_Db_Query(); $result = $query->select("*")->from("Wpjb_Model_Email t")->execute(); foreach ($result as $r) { if ($r->mail_from == "") { $r->mail_from = $email; $r->save(); } } $config = Wpjb_Project::getInstance(); $config->setConfigParam("front_template", "twentyten"); $config->saveConfig(); Wpjb_Upgrade_Manager::upgrade(); $wp_rewrite->flush_rules(); return true; }
public function execute() { $db = Daq_Db::getInstance()->getDb(); $db->query("UPDATE wpjb_employer SET jobs_posted=0"); $db->query("UPDATE wpjb_employer SET jobs_posted=(SELECT COUNT(*) FROM wpjb_job WHERE wpjb_job.employer_id=wpjb_employer.id)"); }
public function delete() { Daq_Db::getInstance()->delete($this->tableName(), "id=" . $this->getId()); if (mysql_errno() > 0) { throw new Daq_Db_Exception(); } return true; }
} if (version_compare(PHP_VERSION, "5.1.6", "<")) { die("<b>Cannot activate:</b> WPJobBoard requires at least PHP 5.1.6, your PHP version is " . PHP_VERSION); } define("WPJB_DOMAIN", "wp-job-board-locale"); $basepath = dirname(__FILE__); if (is_file($basepath . "/overload.php")) { include_once $basepath . "/overload.php"; } if (!class_exists("Daq_Loader")) { require_once $basepath . "/framework/Loader.php"; } Daq_Loader::registerFramework($basepath . "/framework"); Daq_Loader::registerAutoloader(); $request = Daq_Request::getInstance(); $db = Daq_Db::getInstance(); $db->setDb($wpdb); $wpjbIni = Daq_Config::parseIni($basepath . "/application/config/project.ini"); $wpjbPaths = Daq_Config::parseIni($basepath . "/application/config/paths.ini"); Daq_Loader::registerLibrary($wpjbIni["prefix_class"], $basepath . "/application/libraries"); $wpjb = Wpjb_Project::getInstance(); $wpjb->loadPaths($wpjbPaths); $wpjb->setUrl(rtrim(get_bloginfo("url"), "/")); $wpjb->setBaseDir($basepath); foreach ($wpjbIni as $wpjbk => $wpjbv) { $wpjb->setEnv($wpjbk, $wpjbv); } Daq_Helper::registerAll(); $routes = Daq_Config::parseIni($wpjb->path("app_config") . "/frontend-routes.ini", $wpjb->path("user_config") . "/frontend-routes.ini", true); $wpjbbase = $wpjb->path("templates") . "/"; include_once $wpjbbase . "functions.php";
public function execute() { $db = Daq_Db::getInstance()->getDb(); $db->query("UPDATE wpjb_job SET stat_apply=0"); $db->query("UPDATE wpjb_job SET stat_apply=(SELECT COUNT(*) FROM wpjb_application WHERE wpjb_job.id=wpjb_application.job_id)"); }