public function executeNew_group_cbo(sfWebRequest $request)
{
$name_group = $request->getParameter('name');
$user = $this->getUser()->getAttribute(sfConfig::get('app_session_current_user'), null);
if ($user != null) {
$grupoBean = new GrupoTrabajoSc();
$grupoBean->setName($name_group);
$grupoBean->setOwnerId($user->getId());
$grupoBean->setFlag(1);
$grupoBean->setCreateAt(time());
$grupoBean->setUpdateAt(time());
$grupoBean->setHumanFlag(1);
$grupoBean->setHumanHigher('off');
$grupoBean->setHumanLower('on');
$grupoBean->setHumanMe('off');
$grupoBean->save();
$newDetalle = new DetalleGrupoTrabajoSc();
$newDetalle->setEmail($user->getEmail());
$newDetalle->setUserId($user->getId());
$newDetalle->setGrupoId($grupoBean->getId());
$newDetalle->save();
$criterio_busqueda = new Criteria();
$criterio_busqueda->add(GrupoTrabajoScPeer::OWNER_ID, $user->getId());
$criterio_busqueda->add(GrupoTrabajoScPeer::FLAG, 1);
$listado = GrupoTrabajoScPeer::doSelect($criterio_busqueda);
$this->list = $listado;
return sfView::SUCCESS;
} else {
return sfView::ERROR;
}
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param PropelPDO $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(PropelPDO $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their coresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aGrupoTrabajoSc !== null) {
if ($this->aGrupoTrabajoSc->isModified() || $this->aGrupoTrabajoSc->isNew()) {
$affectedRows += $this->aGrupoTrabajoSc->save($con);
}
$this->setGrupoTrabajoSc($this->aGrupoTrabajoSc);
}
if ($this->aTreeSc !== null) {
if ($this->aTreeSc->isModified() || $this->aTreeSc->isNew()) {
$affectedRows += $this->aTreeSc->save($con);
}
$this->setTreeSc($this->aTreeSc);
}
if ($this->aIndicatorsSc !== null) {
if ($this->aIndicatorsSc->isModified() || $this->aIndicatorsSc->isNew()) {
$affectedRows += $this->aIndicatorsSc->save($con);
}
$this->setIndicatorsSc($this->aIndicatorsSc);
}
if ($this->aUserSc !== null) {
if ($this->aUserSc->isModified() || $this->aUserSc->isNew()) {
$affectedRows += $this->aUserSc->save($con);
}
$this->setUserSc($this->aUserSc);
}
if ($this->isNew()) {
$this->modifiedColumns[] = AsignacionScPeer::ID;
}
// If this object has been modified, then save it to the database.
if ($this->isModified()) {
if ($this->isNew()) {
$pk = AsignacionScPeer::doInsert($this, $con);
$affectedRows += 1;
// we are assuming that there is only 1 row per doInsert() which
// should always be true here (even though technically
// BasePeer::doInsert() can insert multiple rows).
$this->setId($pk);
//[IMV] update autoincrement primary key
$this->setNew(false);
} else {
$affectedRows += AsignacionScPeer::doUpdate($this, $con);
}
$this->resetModified();
// [HL] After being saved an object is no longer 'modified'
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
public function executeCreate_tree(sfWebRequest $request)
{
$request->setRequestFormat('json');
$title = $request->getParameter('item_title');
$grupo = $request->getParameter('grupo');
$periodo = $request->getParameter('periodo');
$typeSave = $request->getParameter('typeSave');
$nameGroup = $request->getParameter('newgrupo');
$user = $this->getUser()->getAttribute(sfConfig::get('app_session_current_user'), null);
if ($user != null) {
try {
$conn = Propel::getConnection();
$conn->beginTransaction();
$tree_bean = new TreeSc();
$tree_bean->setName($title);
$tree_bean->setUserId($user->getId());
$tree_bean->setConfigureFlag('');
$tree_bean->setConfigureDesign('');
$tree_bean->setCreateAt(time());
$tree_bean->setUpdateAt(time());
$tree_bean->setPeriodoId($periodo);
/*voy verificar si esta enviando un grupo para grabar*/
$grupoBean = null;
if ($typeSave == "true") {
$grupoBean = new GrupoTrabajoSc();
$grupoBean->setName($nameGroup);
$grupoBean->setOwnerId($user->getId());
$grupoBean->setFlag(1);
$grupoBean->setCreateAt(time());
$grupoBean->setUpdateAt(time());
$grupoBean->setHumanFlag(1);
$grupoBean->setHumanHigher('off');
$grupoBean->setHumanLower('on');
$grupoBean->setHumanMe('off');
$grupoBean->save();
$newDetalle = new DetalleGrupoTrabajoSc();
$newDetalle->setEmail($user->getEmail());
$newDetalle->setUserId($user->getId());
$newDetalle->setGrupoId($grupoBean->getId());
$newDetalle->save();
$tree_bean->setGrupoTrabajoId($grupoBean->getId());
} else {
$tree_bean->setGrupoTrabajoId($grupo);
}
$tree_bean->setFlag(1);
$tree_bean->setValorDeseado(0);
$tree_bean->setValorMinimo(0);
$tree_bean->setResponsableId($user->getId());
$tree_bean->setEmailResponsable($user->getEmail());
$tree_bean->setProduccion('not');
$tree_bean->save();
$tree_user_bean = new TreeUser();
$tree_user_bean->setUserId($tree_bean->getUserId());
$tree_user_bean->setTreeId($tree_bean->getId());
$tree_user_bean->save();
$conn->commit();
$this->message = 'success';
$this->treepk = 't-' . $tree_bean->getId();
$this->treeId = $tree_bean->getId();
$this->title = $tree_bean->getName();
$this->type = $typeSave;
$this->group = $grupoBean;
return sfView::SUCCESS;
} catch (Exception $e) {
$this->message = $e->getMessage();
$conn->rollBack();
return sfView::ERROR;
}
} else {
$this->message = 'session expired';
return sfView::ERROR;
}
}