public function saveAppDocumentsPermisosDirList($con = null)
{
if (!$this->isValid()) {
throw $this->getErrorSchema();
}
if (!isset($this->widgetSchema['app_documents_permisos_dir_list'])) {
// somebody has unset this widget
return;
}
if (null === $con) {
$con = $this->getConnection();
}
$c = new Criteria();
$c->add(AppDocumentsPermisosDirPeer::IDDIRECTORI, $this->object->getPrimaryKey());
AppDocumentsPermisosDirPeer::doDelete($c, $con);
$values = $this->getValue('app_documents_permisos_dir_list');
if (is_array($values)) {
foreach ($values as $value) {
$obj = new AppDocumentsPermisosDir();
$obj->setIddirectori($this->object->getPrimaryKey());
$obj->setIdusuari($value);
$obj->save();
}
}
}
public static function initialize($idU, $idD, $idS, $idN = NivellsPeer::CAP)
{
$O = AppDocumentsPermisosDirPeer::retrieveByPK($idU, $idD);
if (!$O instanceof AppDocumentsPermisosDir) {
$O = new AppDocumentsPermisosDir();
$O->setidusuari($idU);
$O->setIddirectori($idD);
$O->setIdnivell($idN);
$O->setSiteId($idS);
$O->setActiu(true);
}
return new AppDocumentsPermisosDirForm($O, array('app' => AppsPeer::APP_DOCUMENTS, 'IDS' => $idS));
}
public static function getDirectoris($IDU = null, $idS)
{
$RET = array();
$C = new Criteria();
$C = self::getCriteriaActiu($C, $idS);
$C = AppDocumentsPermisosDirPeer::getCriteriaActiu($C, $idS);
if (!is_null($IDU)) {
$C->add(AppDocumentsPermisosDirPeer::IDUSUARI, $IDU);
$C->addJoin(AppDocumentsPermisosDirPeer::IDDIRECTORI, self::IDDIRECTORI);
}
foreach (self::doSelect($C) as $DIR) {
$RET[$DIR->getPare()][$DIR->getIddirectori()] = $DIR->getNom();
}
return $RET;
}
public function executeGDocuments(sfWebRequest $request)
{
$this->IDS = $this->getUser()->getSessionPar('idS');
$IDU = $this->getUser()->getSessionPar('idU');
$IDD = $this->getUser()->ParReqSesForm($request, 'IDD', 1);
$IDA = $this->getUser()->ParReqSesForm($request, 'IDA', null);
$accio = $this->getUser()->ParReqSesForm($request, 'accio', 'CD');
$this->MODE = "CONSULTA";
if ($request->hasParameter('B_SAVE_UPLOAD')) {
$accio = 'SAVE_UPLOAD';
}
$this->getUser()->setSessionPar('accio', $accio);
switch ($accio) {
//Mostrem el dià leg d'upload
case 'UPLOAD':
$this->FUPLOAD = AppDocumentsArxiusPeer::initialize($IDA, $IDD, $this->IDS);
$this->MODE = 'UPLOAD';
break;
//Guardem un arxiu que hem carregat.
//Guardem un arxiu que hem carregat.
case 'SAVE_UPLOAD':
$RP = $request->getParameter('app_documents_arxius');
$this->FUPLOAD = AppDocumentsArxiusPeer::initialize($IDA, 0, $this->IDS);
$this->FUPLOAD->bind($RP, $request->getFiles('app_documents_arxius'));
if ($this->FUPLOAD->isValid()) {
$this->FUPLOAD->save();
$this->redirect('apps/gDocuments?accio=CD');
}
$this->MODE = 'UPLOAD';
break;
//Esborrem un arxiu guardat prèviament
//Esborrem un arxiu guardat prèviament
case 'DELETE':
$this->FUPLOAD = AppDocumentsArxiusPeer::initialize($IDA, 0, $this->IDS)->setInactiu();
$this->redirect('apps/gDocuments?accio=CD');
break;
//Fem un canvi de directori o tornem a una pantalla anterior i inicialitzem
//Fem un canvi de directori o tornem a una pantalla anterior i inicialitzem
case 'CD':
$this->getUser()->setAttribute('IDA', null);
break;
}
$this->ACTUAL = AppDocumentsDirectorisPeer::initialize($IDD, $this->IDS)->getObject();
$this->getUser()->setAttribute('IDD', 1);
$this->DIRECTORIS = AppDocumentsDirectorisPeer::getDirectoris($IDU, $this->IDS);
$this->PERMISOS_AL_DIR = AppDocumentsPermisosDirPeer::getPermis($IDU, $IDD, $this->IDS);
$this->setLayout('gestio_apps');
}
/**
* This is a method for emulating ON DELETE CASCADE for DBs that don't support this
* feature (like MySQL or SQLite).
*
* This method is not very speedy because it must perform a query first to get
* the implicated records and then perform the deletes by calling those Peer classes.
*
* This method should be used within a transaction if possible.
*
* @param Criteria $criteria
* @param PropelPDO $con
* @return int The number of affected rows (if supported by underlying database driver).
*/
protected static function doOnDeleteCascade(Criteria $criteria, PropelPDO $con)
{
// initialize var to track total num of affected rows
$affectedRows = 0;
// first find the objects that are implicated by the $criteria
$objects = UsuarisPeer::doSelect($criteria, $con);
foreach ($objects as $obj) {
// delete related AppDocumentsPermisos objects
$criteria = new Criteria(AppDocumentsPermisosPeer::DATABASE_NAME);
$criteria->add(AppDocumentsPermisosPeer::IDUSUARI, $obj->getUsuariid());
$affectedRows += AppDocumentsPermisosPeer::doDelete($criteria, $con);
// delete related AppDocumentsPermisosDir objects
$criteria = new Criteria(AppDocumentsPermisosDirPeer::DATABASE_NAME);
$criteria->add(AppDocumentsPermisosDirPeer::IDUSUARI, $obj->getUsuariid());
$affectedRows += AppDocumentsPermisosDirPeer::doDelete($criteria, $con);
// delete related Cessio objects
$criteria = new Criteria(CessioPeer::DATABASE_NAME);
$criteria->add(CessioPeer::USUARI_ID, $obj->getUsuariid());
$affectedRows += CessioPeer::doDelete($criteria, $con);
// delete related Factures objects
$criteria = new Criteria(FacturesPeer::DATABASE_NAME);
$criteria->add(FacturesPeer::VALIDAUSUARI, $obj->getUsuariid());
$affectedRows += FacturesPeer::doDelete($criteria, $con);
// delete related Matricules objects
$criteria = new Criteria(MatriculesPeer::DATABASE_NAME);
$criteria->add(MatriculesPeer::USUARIS_USUARIID, $obj->getUsuariid());
$affectedRows += MatriculesPeer::doDelete($criteria, $con);
// delete related Missatges objects
$criteria = new Criteria(MissatgesPeer::DATABASE_NAME);
$criteria->add(MissatgesPeer::USUARIS_USUARIID, $obj->getUsuariid());
$affectedRows += MissatgesPeer::doDelete($criteria, $con);
// delete related Personal objects
$criteria = new Criteria(PersonalPeer::DATABASE_NAME);
$criteria->add(PersonalPeer::IDUSUARI, $obj->getUsuariid());
$affectedRows += PersonalPeer::doDelete($criteria, $con);
// delete related Reservaespais objects
$criteria = new Criteria(ReservaespaisPeer::DATABASE_NAME);
$criteria->add(ReservaespaisPeer::USUARIS_USUARIID, $obj->getUsuariid());
$affectedRows += ReservaespaisPeer::doDelete($criteria, $con);
// delete related UsuarisApps objects
$criteria = new Criteria(UsuarisAppsPeer::DATABASE_NAME);
$criteria->add(UsuarisAppsPeer::USUARI_ID, $obj->getUsuariid());
$affectedRows += UsuarisAppsPeer::doDelete($criteria, $con);
// delete related UsuarisMenus objects
$criteria = new Criteria(UsuarisMenusPeer::DATABASE_NAME);
$criteria->add(UsuarisMenusPeer::USUARI_ID, $obj->getUsuariid());
$affectedRows += UsuarisMenusPeer::doDelete($criteria, $con);
// delete related UsuarisSites objects
$criteria = new Criteria(UsuarisSitesPeer::DATABASE_NAME);
$criteria->add(UsuarisSitesPeer::USUARI_ID, $obj->getUsuariid());
$affectedRows += UsuarisSitesPeer::doDelete($criteria, $con);
// delete related Usuarisllistes objects
$criteria = new Criteria(UsuarisllistesPeer::DATABASE_NAME);
$criteria->add(UsuarisllistesPeer::USUARIS_USUARISID, $obj->getUsuariid());
$affectedRows += UsuarisllistesPeer::doDelete($criteria, $con);
}
return $affectedRows;
}
/**
* Retrieve object using using composite pkey values.
* @param int $idusuari
* @param int $iddirectori
* @param PropelPDO $con
* @return AppDocumentsPermisosDir
*/
public static function retrieveByPK($idusuari, $iddirectori, PropelPDO $con = null)
{
$key = serialize(array((string) $idusuari, (string) $iddirectori));
if (null !== ($obj = AppDocumentsPermisosDirPeer::getInstanceFromPool($key))) {
return $obj;
}
if ($con === null) {
$con = Propel::getConnection(AppDocumentsPermisosDirPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$criteria = new Criteria(AppDocumentsPermisosDirPeer::DATABASE_NAME);
$criteria->add(AppDocumentsPermisosDirPeer::IDUSUARI, $idusuari);
$criteria->add(AppDocumentsPermisosDirPeer::IDDIRECTORI, $iddirectori);
$v = AppDocumentsPermisosDirPeer::doSelect($criteria, $con);
return !empty($v) ? $v[0] : null;
}
public function executeGDocuments(sfWebRequest $request)
{
$this->setLayout('gestio');
$this->IDS = $this->getUser()->getSessionPar('idS');
$this->MISSATGE = array();
$this->IDD = $request->getParameter('IDD', 0);
$accio = $this->getUser()->ParReqSesForm($request, 'accio', 'GP');
$this->MODE = 'CERCA';
if ($request->isMethod('POST')) {
if ($request->hasParameter('B_VEURE_PERMISOS')) {
$accio = 'VP';
} elseif ($request->hasParameter('B_NOU')) {
$accio = 'ND';
} elseif ($request->hasParameter('B_SAVE_NOU')) {
$accio = 'SD';
} elseif ($request->hasParameter('B_UPDATE_PERMISOS')) {
$accio = 'SAVE_UPDATE_PERMISOS';
} elseif ($request->hasParameter('B_NEW_USER')) {
$accio = 'NUP';
} elseif ($request->hasParameter('B_NOU_USUARI_PERMISOS')) {
$accio = 'SAVE_NOU_USUARI_PERMISOS';
} elseif ($request->hasParameter('B_EDITA_DIRECTORI')) {
$accio = 'ND';
} elseif ($request->hasParameter('B_SAVE_EDITA_DIRECTORI')) {
$accio = 'SD';
} elseif ($request->hasParameter('B_DELETE_DIRECTORI')) {
$accio = 'DELETE_DIRECTORI';
}
}
//Aquest petit bloc és per si es modifica amb un POST el que s'ha enviat per GET
$this->getUser()->setSessionPar('accio', $accio);
switch ($accio) {
case 'GP':
$this->getUser()->addLogAction('inside', 'gDocuments');
break;
//Visualitza permisos que tenen els usuaris en el directori
//Visualitza permisos que tenen els usuaris en el directori
case 'VP':
$this->LLISTAT_PERMISOS = AppDocumentsPermisosDirPeer::getLlistatPermisos($this->IDD, $this->IDS);
$this->MODE = "CONSULTA";
break;
//Crea un directori nou
//Crea un directori nou
case 'ND':
$this->FDir = AppDocumentsDirectorisPeer::initialize($this->IDD, $this->IDS);
$this->MODE = "NOU";
break;
//Guarda un directori
//Guarda un directori
case 'SD':
$RP = $request->getParameter('app_documents_directoris');
$this->FDir = AppDocumentsDirectorisPeer::initialize($RP['idDirectori'], $this->IDS);
$this->FDir->bind($RP);
if ($this->FDir->isValid()) {
$this->FDir->save();
$IDU = $this->getUser()->getSessionPar('idU');
$idD = $this->FDir->getObject()->getIddirectori();
$this->getUser()->addLogAction($accio, 'gDocuments', $this->FDir->getObject());
//A més donem permisos a l'usuari que l'ha creat perquè pugui accedir-hi
if (AppDocumentsPermisosDirPeer::addUser($IDU, $idD, $this->IDS)) {
$this->getUser()->addLogAction($accio, 'gDocuments', $this->IDD);
$this->MODE = "CONSULTA";
} else {
$this->MISSATGE = array("Hi ha hagut algun error afegint l'usuari.");
$this->MODE = "NOU";
}
} else {
$this->MISSATGE = array("Hi ha hagut algun error.");
$this->MODE = "NOU";
}
break;
//Esborra un directori
//Esborra un directori
case 'DELETE_DIRECTORI':
$RP = $request->getParameter('app_documents_directoris');
$this->IDD = $RP['idDirectori'];
$this->FDir = AppDocumentsDirectorisPeer::initialize($this->IDD, $this->IDS);
$this->FDir->getObject()->setActiu(false)->save();
$this->getUser()->addLogAction($accio, 'gDocuments', $this->FDir->getObject());
break;
//Actualitza un directori
//Actualitza un directori
case 'UD':
$this->MODE = "NOU";
break;
//Guarda els nous permisos
//Guarda els nous permisos
case 'SAVE_UPDATE_PERMISOS':
foreach ($request->getParameter('nivell') as $idU => $idN) {
if (!AppDocumentsPermisosDirPeer::addUser($idU, $this->IDD, $this->IDS, $idN)) {
$this->MISSATGE[] = "Problema guardant els permisos dels usuaris.";
}
}
$this->getUser()->addLogAction($accio, 'gDocuments', $request->getParameter('nivell'));
$this->redirect('gestio/gDocuments?accio=VP&IDD=' . $this->IDD);
break;
case 'SAVE_NOU_USUARI_PERMISOS':
$RP = $request->getParameter('app_documents_permisos_dir');
$this->FPERMISOS = AppDocumentsPermisosDirPeer::initialize($RP['idUsuari'], $RP['idDirectori'], $this->IDS);
$this->FPERMISOS->bind($RP);
if ($this->FPERMISOS->isValid()) {
$this->FPERMISOS->save();
$this->getUser()->addLogAction($accio, 'gDocuments', $this->FPERMISOS->getObject());
$this->redirect('gestio/gDocuments?accio=VP&IDD=' . $this->IDD);
} else {
$this->MISSATGE[] = "Hi ha hagut algun problema guardant els permisos";
}
$this->MODE = 'NOU_USUARI';
break;
//Afegim un usuari a un directori
//Afegim un usuari a un directori
case 'NUP':
$this->FPERMISOS = AppDocumentsPermisosDirPeer::initialize($this->IDU, $this->IDD, $this->IDS);
$this->MODE = "NOU_USUARI";
break;
}
$this->LLISTAT_PERMISOS = AppDocumentsPermisosDirPeer::getLlistatPermisos($this->IDD, $this->IDS);
}
/**
* Method to invalidate the instance pool of all tables related to nivells
* by a foreign key with ON DELETE CASCADE
*/
public static function clearRelatedInstancePool()
{
// invalidate objects in AppDocumentsPermisosPeer instance pool, since one or more of them may be deleted by ON DELETE CASCADE rule.
AppDocumentsPermisosPeer::clearInstancePool();
// invalidate objects in AppDocumentsPermisosDirPeer instance pool, since one or more of them may be deleted by ON DELETE CASCADE rule.
AppDocumentsPermisosDirPeer::clearInstancePool();
}
/**
* If this collection has already been initialized with
* an identical criteria, it returns the collection.
* Otherwise if this Nivells is new, it will return
* an empty collection; or if this Nivells has previously
* been saved, it will retrieve related AppDocumentsPermisosDirs from storage.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in Nivells.
*/
public function getAppDocumentsPermisosDirsJoinAppDocumentsDirectoris($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN)
{
if ($criteria === null) {
$criteria = new Criteria(NivellsPeer::DATABASE_NAME);
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collAppDocumentsPermisosDirs === null) {
if ($this->isNew()) {
$this->collAppDocumentsPermisosDirs = array();
} else {
$criteria->add(AppDocumentsPermisosDirPeer::IDNIVELL, $this->idnivells);
$this->collAppDocumentsPermisosDirs = AppDocumentsPermisosDirPeer::doSelectJoinAppDocumentsDirectoris($criteria, $con, $join_behavior);
}
} else {
// the following code is to determine if a new query is
// called for. If the criteria is the same as the last
// one, just return the collection.
$criteria->add(AppDocumentsPermisosDirPeer::IDNIVELL, $this->idnivells);
if (!isset($this->lastAppDocumentsPermisosDirCriteria) || !$this->lastAppDocumentsPermisosDirCriteria->equals($criteria)) {
$this->collAppDocumentsPermisosDirs = AppDocumentsPermisosDirPeer::doSelectJoinAppDocumentsDirectoris($criteria, $con, $join_behavior);
}
}
$this->lastAppDocumentsPermisosDirCriteria = $criteria;
return $this->collAppDocumentsPermisosDirs;
}
/**
* This is a method for emulating ON DELETE CASCADE for DBs that don't support this
* feature (like MySQL or SQLite).
*
* This method is not very speedy because it must perform a query first to get
* the implicated records and then perform the deletes by calling those Peer classes.
*
* This method should be used within a transaction if possible.
*
* @param Criteria $criteria
* @param PropelPDO $con
* @return int The number of affected rows (if supported by underlying database driver).
*/
protected static function doOnDeleteCascade(Criteria $criteria, PropelPDO $con)
{
// initialize var to track total num of affected rows
$affectedRows = 0;
// first find the objects that are implicated by the $criteria
$objects = AppDocumentsDirectorisPeer::doSelect($criteria, $con);
foreach ($objects as $obj) {
// delete related AppDocumentsPermisosDir objects
$criteria = new Criteria(AppDocumentsPermisosDirPeer::DATABASE_NAME);
$criteria->add(AppDocumentsPermisosDirPeer::IDDIRECTORI, $obj->getIddirectori());
$affectedRows += AppDocumentsPermisosDirPeer::doDelete($criteria, $con);
}
return $affectedRows;
}
/**
* Populates the object using an array.
*
* This is particularly useful when populating an object from one of the
* request arrays (e.g. $_POST). This method goes through the column
* names, checking to see whether a matching key exists in populated
* array. If so the setByName() method is called for that column.
*
* You can specify the key type of the array by additionally passing one
* of the class type constants BasePeer::TYPE_PHPNAME, BasePeer::TYPE_STUDLYPHPNAME,
* BasePeer::TYPE_COLNAME, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_NUM.
* The default key type is the column's phpname (e.g. 'AuthorId')
*
* @param array $arr An array to populate the object from.
* @param string $keyType The type of keys the array uses.
* @return void
*/
public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
{
$keys = AppDocumentsPermisosDirPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setIdusuari($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setIddirectori($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setIdnivell($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setSiteId($arr[$keys[3]]);
}
if (array_key_exists($keys[4], $arr)) {
$this->setActiu($arr[$keys[4]]);
}
}
