public function setup()
{
$this->setWidgets(array('idDirectori' => new sfWidgetFormInputHidden(), 'Pare' => new sfWidgetFormChoice(array('choices' => AppDocumentsDirectorisPeer::getSelectDirectoris($this->getOption('IDS'))), array()), 'Nom' => new sfWidgetFormInputText(array(), array('style' => 'width:200px'))));
$this->setValidators(array('idDirectori' => new sfValidatorPropelChoice(array('model' => 'AppDocumentsDirectoris', 'column' => 'idDirectori', 'required' => false)), 'Nom' => new sfValidatorString(array('required' => true)), 'Pare' => new sfValidatorPass(array('required' => true))));
$this->widgetSchema->setNameFormat('app_documents_directoris[%s]');
$this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema);
}
public static function initialize($idD, $idS)
{
$O = AppDocumentsDirectorisPeer::retrieveByPK($idD);
if (!$O instanceof AppDocumentsDirectoris) {
$O = new AppDocumentsDirectoris();
$O->setSiteId($idS);
$O->setActiu(true);
}
return new AppDocumentsDirectorisForm($O, array('IDS' => $idS));
}
public function setup()
{
$this->setWidgets(array('idUsuari' => new sfWidgetFormSelect(array('choices' => UsuarisAppsPeer::getSelectUsuarisPermis($this->getOption('app'), $this->getOption('IDS')))), 'idDirectori' => new sfWidgetFormSelect(array('choices' => AppDocumentsDirectorisPeer::getSelectDirectoris($this->getOption('IDS')))), 'idNivell' => new sfWidgetFormSelect(array('choices' => NivellsPeer::getSelectPermisos($this->getOption('IDS'))))));
$this->setValidators(array('idUsuari' => new sfValidatorPropelChoice(array('model' => 'Usuaris', 'column' => 'UsuariID', 'required' => false)), 'idDirectori' => new sfValidatorPropelChoice(array('model' => 'AppDocumentsDirectoris', 'column' => 'idDirectori', 'required' => false)), 'idNivell' => new sfValidatorPropelChoice(array('model' => 'Nivells', 'column' => 'idNivells', 'required' => false))));
$this->widgetSchema->setNameFormat('app_documents_permisos_dir[%s]');
$this->setDefault('idDirectori', $this->getOption('IDD'));
$this->setDefault('idNivell', 6);
$this->widgetSchema->setLabels(array('idUsuari' => 'Usuari: ', 'idDirectori' => 'Directori: ', 'idNivell' => 'Permisos: '));
$this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema);
}
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');
}
public function getRutaActual()
{
$RET = $this->getNom();
$ODIR = $this;
$FI = true;
while ($FI) {
$PARE = $ODIR->getPare();
$ODIR = AppDocumentsDirectorisPeer::retrieveByPK($PARE);
if ($ODIR instanceof AppDocumentsDirectoris) {
$RET = $ODIR->getNom() . ' / ' . $RET;
} else {
$FI = false;
}
}
return $RET;
}
/**
* Selects a collection of AppDocumentsPermisosDir objects pre-filled with all related objects except Nivells.
*
* @param Criteria $criteria
* @param PropelPDO $con
* @param String $join_behavior the type of joins to use, defaults to Criteria::LEFT_JOIN
* @return array Array of AppDocumentsPermisosDir objects.
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function doSelectJoinAllExceptNivells(Criteria $criteria, $con = null, $join_behavior = Criteria::LEFT_JOIN)
{
$criteria = clone $criteria;
// Set the correct dbName if it has not been overridden
// $criteria->getDbName() will return the same object if not set to another value
// so == check is okay and faster
if ($criteria->getDbName() == Propel::getDefaultDB()) {
$criteria->setDbName(self::DATABASE_NAME);
}
AppDocumentsPermisosDirPeer::addSelectColumns($criteria);
$startcol2 = AppDocumentsPermisosDirPeer::NUM_COLUMNS - AppDocumentsPermisosDirPeer::NUM_LAZY_LOAD_COLUMNS;
UsuarisPeer::addSelectColumns($criteria);
$startcol3 = $startcol2 + (UsuarisPeer::NUM_COLUMNS - UsuarisPeer::NUM_LAZY_LOAD_COLUMNS);
AppDocumentsDirectorisPeer::addSelectColumns($criteria);
$startcol4 = $startcol3 + (AppDocumentsDirectorisPeer::NUM_COLUMNS - AppDocumentsDirectorisPeer::NUM_LAZY_LOAD_COLUMNS);
$criteria->addJoin(AppDocumentsPermisosDirPeer::IDUSUARI, UsuarisPeer::USUARIID, $join_behavior);
$criteria->addJoin(AppDocumentsPermisosDirPeer::IDDIRECTORI, AppDocumentsDirectorisPeer::IDDIRECTORI, $join_behavior);
// symfony_behaviors behavior
foreach (sfMixer::getCallables(self::getMixerPreSelectHook(__FUNCTION__)) as $sf_hook) {
call_user_func($sf_hook, 'BaseAppDocumentsPermisosDirPeer', $criteria, $con);
}
$stmt = BasePeer::doSelect($criteria, $con);
$results = array();
while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
$key1 = AppDocumentsPermisosDirPeer::getPrimaryKeyHashFromRow($row, 0);
if (null !== ($obj1 = AppDocumentsPermisosDirPeer::getInstanceFromPool($key1))) {
// We no longer rehydrate the object, since this can cause data loss.
// See http://propel.phpdb.org/trac/ticket/509
// $obj1->hydrate($row, 0, true); // rehydrate
} else {
$cls = AppDocumentsPermisosDirPeer::getOMClass(false);
$obj1 = new $cls();
$obj1->hydrate($row);
AppDocumentsPermisosDirPeer::addInstanceToPool($obj1, $key1);
}
// if obj1 already loaded
// Add objects for joined Usuaris rows
$key2 = UsuarisPeer::getPrimaryKeyHashFromRow($row, $startcol2);
if ($key2 !== null) {
$obj2 = UsuarisPeer::getInstanceFromPool($key2);
if (!$obj2) {
$cls = UsuarisPeer::getOMClass(false);
$obj2 = new $cls();
$obj2->hydrate($row, $startcol2);
UsuarisPeer::addInstanceToPool($obj2, $key2);
}
// if $obj2 already loaded
// Add the $obj1 (AppDocumentsPermisosDir) to the collection in $obj2 (Usuaris)
$obj2->addAppDocumentsPermisosDir($obj1);
}
// if joined row is not null
// Add objects for joined AppDocumentsDirectoris rows
$key3 = AppDocumentsDirectorisPeer::getPrimaryKeyHashFromRow($row, $startcol3);
if ($key3 !== null) {
$obj3 = AppDocumentsDirectorisPeer::getInstanceFromPool($key3);
if (!$obj3) {
$cls = AppDocumentsDirectorisPeer::getOMClass(false);
$obj3 = new $cls();
$obj3->hydrate($row, $startcol3);
AppDocumentsDirectorisPeer::addInstanceToPool($obj3, $key3);
}
// if $obj3 already loaded
// Add the $obj1 (AppDocumentsPermisosDir) to the collection in $obj3 (AppDocumentsDirectoris)
$obj3->addAppDocumentsPermisosDir($obj1);
}
// if joined row is not null
$results[] = $obj1;
}
$stmt->closeCursor();
return $results;
}
/**
* Retrieve multiple objects by pkey.
*
* @param array $pks List of primary keys
* @param PropelPDO $con the connection to use
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function retrieveByPKs($pks, PropelPDO $con = null)
{
if ($con === null) {
$con = Propel::getConnection(AppDocumentsDirectorisPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(AppDocumentsDirectorisPeer::DATABASE_NAME);
$criteria->add(AppDocumentsDirectorisPeer::IDDIRECTORI, $pks, Criteria::IN);
$objs = AppDocumentsDirectorisPeer::doSelect($criteria, $con);
}
return $objs;
}
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);
}
<TD colspan="3" class="CONTINGUT_ADMIN">
<?php
include_partial('breadcumb', array('text' => 'DOCUMENTS'));
?>
<form action="<?php
echo url_for('gestio/gDocuments');
?>
" method="POST" id="FCERCA">
<DIV class="REQUADRE">
<DIV class="TITOL">Escull un directori: </DIV>
<table class="FORMULARI">
<?php
echo select_tag('IDD', options_for_select(AppDocumentsDirectorisPeer::getSelectDirectoris($IDS), $IDD));
?>
<tr>
<td colspan="2">
<input type="submit" name="B_VEURE_PERMISOS" value="Veure permisos" />
<input type="submit" name="B_NOU" value="Nou directori" />
<input type="submit" name="B_EDITA_DIRECTORI" value="Edita directori" />
</td>
</tr>
</table>
</DIV>
</form>
<?php
if ($MODE == 'CONSULTA') {
/**
* Get the associated AppDocumentsDirectoris object
*
* @param PropelPDO Optional Connection object.
* @return AppDocumentsDirectoris The associated AppDocumentsDirectoris object.
* @throws PropelException
*/
public function getAppDocumentsDirectoris(PropelPDO $con = null)
{
if ($this->aAppDocumentsDirectoris === null && $this->iddirectori !== null) {
$this->aAppDocumentsDirectoris = AppDocumentsDirectorisPeer::retrieveByPk($this->iddirectori);
/* The following can be used additionally to
guarantee the related object contains a reference
to this object. This level of coupling may, however, be
undesirable since it could result in an only partially populated collection
in the referenced object.
$this->aAppDocumentsDirectoris->addAppDocumentsPermisosDirs($this);
*/
}
return $this->aAppDocumentsDirectoris;
}
/**
* 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 = AppDocumentsDirectorisPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setIddirectori($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setNom($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setPare($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]]);
}
}
