public static function setJobProjectIds($jobs, $projectId)
{
$c1 = new Criteria();
$c2 = new Criteria();
$c1->add(JobPeer::ID, $jobs, Criteria::IN);
$c2->add(JobPeer::PROJECT_ID, $projectId);
BasePeer::doUpdate($c1, $c2, Propel::getConnection());
$project = ProjectPeer::retrieveByPK($projectId);
foreach ($jobs as $id) {
$logEntry = new Log();
$logEntry->setWhen(time());
$logEntry->setPropelClass("Job");
$logEntry->setSfGuardUserProfileId(sfContext::getInstance()->getUser()->getUserId());
$logEntry->setMessage("Moved job to project" . $project->getName());
$logEntry->setLogMessageTypeId(sfConfig::get("app_log_type_move_to_project"));
$logEntry->setPropelId($id);
$logEntry->save();
}
}
public function getProject($con = null)
{
if ($this->aProject === null && $this->project_id !== null) {
include_once 'lib/model/om/BaseProjectPeer.php';
$this->aProject = ProjectPeer::retrieveByPK($this->project_id, $con);
}
return $this->aProject;
}
public function executeAddProject(sfWebRequest $request)
{
$obj = json_decode($request->getParameter("obj"), true);
$jobs = $obj["jobs"];
$addProjectId = $obj["addProjectId"];
$projectName = $obj["projectName"];
$createNew = $obj["createNew"];
$removeFromProject = $obj["removeFromProject"];
if (!$removeFromProject) {
if ($createNew) {
$project = new Project();
$project->setName($projectName);
$project->save();
} else {
$project = ProjectPeer::retrieveByPK($addProjectId);
}
$projectId = $project->getId();
} else {
$projectId = null;
}
if ($removeFromProject || !is_null($projectId)) {
JobPeer::setJobProjectIds($jobs, $projectId);
}
$this->setTemplate("reload");
if ($this->createCriteria() == sfView::NONE) {
return sfView::NONE;
}
}