protected function _multiDelete($id)
{
$query = new Daq_Db_Query();
$total = $query->select("COUNT(*) AS cnt")->from("Wpjb_Model_Job")->where("job_type = ?", $id)->fetchColumn();
if ($total > 0) {
$err = __("Cannot delete job type identified by ID #{id}. There are still jobs using this type.", WPJB_DOMAIN);
$err = str_replace("{id}", $id, $err);
$this->view->_flash->addError($err);
return false;
}
try {
$model = new Wpjb_Model_JobType($id);
$model->delete();
return true;
} catch (Exception $e) {
// log error
return false;
}
}
protected static function _getJobTypeId($title)
{
$slug = sanitize_title_with_dashes($title);
$query = new Daq_Db_Query();
$result = $query->select("*")->from("Wpjb_Model_JobType t")->where("t.title LIKE ?", "%" . $title . "%")->orWhere("t.slug LIKE ?", "%" . $slug . "%")->execute();
if (count($result) > 0) {
$jobType = $result[0];
return $jobType->getId();
} else {
$jobType = new Wpjb_Model_JobType();
$jobType->title = $title;
$jobType->slug = $slug;
$jobType->save();
return $jobType->getId();
}
}
