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_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");
}
/**
* Returns instance of Daq_Db
*
* @return Daq_Db
*/
public static function getInstance()
{
if (self::$_instance === null) {
self::$_instance = new self();
}
return self::$_instance;
}
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)");
}
