* @param string $job_type
* @param string $job_color
* @return int $job_id
*/
public static function create($job_name, $job_type, $job_color)
{
$query = "INSERT INTO `codev_job_table` (`name`, `type`, `color`) VALUES ('{$job_name}','{$job_type}','{$job_color}');";
$result = SqlWrapper::getInstance()->sql_query($query);
if (!$result) {
echo "<span style='color:red'>ERROR: Query FAILED</span>";
exit;
}
return SqlWrapper::getInstance()->sql_insert_id();
}
/**
* @static
* @param int $project_id
* @param int $job_id
*/
public static function addJobProjectAssociation($project_id, $job_id)
{
$query = "INSERT INTO `codev_project_job_table` (`project_id`, `job_id`) VALUES ('{$project_id}','{$job_id}');";
$result = SqlWrapper::getInstance()->sql_query($query);
if (!$result) {
echo "<span style='color:red'>ERROR: Query FAILED</span>";
exit;
}
}
}
Jobs::staticInit();
