public function getFotosEspais()
{
$OE = $this->getObject();
$LOM = MultimediaPeer::getFotosEspais($OE->getEspaiid(), $OE->getSiteId());
$RET = array();
$i = 0;
foreach ($LOM as $OM) {
$RET[] = MultimediaPeer::initialize($OM->getMultimediaId(), $OM->getSiteId(), EspaisPeer::TABLE_NAME, $OE->getEspaiid(), $i++);
}
return $RET;
}
public static function initialize($idM, $idS, $taula, $idExtern, $i = 0)
{
$OM = MultimediaPeer::retrieveByPK($idM);
if (!$OM instanceof Multimedia) {
$OM = new Multimedia();
$OM->setTaula($taula);
$OM->setIdextern($idExtern);
$OM->setSiteId($idS);
$OM->setActiu(true);
}
return new MultimediaForm($OM, array('I' => $i, 'IDS' => $idS));
}
/**
* 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(MultimediaPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(MultimediaPeer::DATABASE_NAME);
$criteria->add(MultimediaPeer::MULTIMEDIA_ID, $pks, Criteria::IN);
$objs = MultimediaPeer::doSelect($criteria, $con);
}
return $objs;
}
/**
* 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 = MultimediaPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setMultimediaId($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setTaula($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setUrl($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]]);
}
if (array_key_exists($keys[5], $arr)) {
$this->setIdExtern($arr[$keys[5]]);
}
}
public function executeGConfig(sfWebRequest $request)
{
$this->setLayout('gestio');
$this->IDS = $this->getUser()->getSessionPar('idS');
$this->accio = $request->getParameter('accio', 'C');
$ROPTIONS = $request->getParameter('options', array('option_id' => '0'));
$RESPAIS = $request->getParameter('espais', array('EspaiID' => '0'));
$RMATERIAL = $request->getParameter('materialgeneric', array('idMaterialGeneric' => ''));
$RDESCOMPTE = $request->getParameter('descomptes', array('idDescompte' => '0'));
$this->FOPTIONS = OptionsPeer::initialize($ROPTIONS['option_id'], $this->IDS, false);
$this->FESPAIS = EspaisPeer::initialize($RESPAIS['EspaiID'], $this->IDS);
$this->FMATERIAL = MaterialgenericPeer::initialize($RMATERIAL['idMaterialGeneric'], $this->IDS);
$this->FENTITAT = SitesPeer::initialize($this->IDS);
//$this->FDESCOMPTE = DescomptesPeer::initialize( $RDESCOMPTE['idDescompte'] , $this->IDS );
//Agafem el codi de facebook de l'usuari
$this->FBI = UsuarisPeer::getUserFbCode($this->getUser()->getSessionPar('idU'));
$this->PARS = array();
$this->PARS = myUser::f_FbAuth(false, $this->getController()->genUrl('@fb_link', true));
//Carreguem les dades del facebook.
$this->ERROR = "";
if ($request->hasParameter('BNEWOPTION')) {
$this->accio = 'NEW_OPTION';
}
if ($request->hasParameter('BSAVEOPTION')) {
$this->accio = 'SAVE_OPTION';
}
if ($request->hasParameter('BSAVEESPAI')) {
$this->accio = 'SAVE_ESPAI';
}
if ($request->hasParameter('BDELETEESPAI')) {
$this->accio = 'DELETE_ESPAI';
}
if ($request->hasParameter('BSAVEMATERIAL')) {
$this->accio = 'SAVE_MATERIAL';
}
if ($request->hasParameter('BDELETEMATERIAL')) {
$this->accio = 'DELETE_MATERIAL';
}
if ($request->hasParameter('BSAVESITE')) {
$this->accio = 'SAVE_SITE';
}
if ($request->hasParameter('BSAVEDESCOMPTE')) {
$this->accio = 'SAVE_DESCOMPTE';
}
switch ($this->accio) {
case 'AJAX_OPCIO':
return $this->renderText(OptionsPeer::getString($request->getParameter('IDO'), $this->IDS));
break;
case 'NEW_OPTION':
$this->FOPTIONS = OptionsPeer::initialize($ROPTIONS['option_id'], $this->IDS, true);
break;
case 'SAVE_OPTION':
$this->FOPTIONS->bind($ROPTIONS);
if ($this->FOPTIONS->isValid()) {
$this->FOPTIONS->save();
$this->getUser()->addLogAction($this->accio, 'gConfig', $this->FOPTIONS->getObject());
$this->FOPTIONS = OptionsPeer::initialize($this->FOPTIONS->getObject()->getOptionId(), $this->IDS, false);
}
break;
case 'SAVE_ESPAI':
//Si entrem un espai que és 0, llavors vol dir que fem un nou espai
if ($RESPAIS['EspaiID'] == 0) {
unset($RESPAIS['EspaiID']);
}
$this->FESPAIS->bind($RESPAIS, $request->getFiles('espais'));
if ($this->FESPAIS->isValid()) {
$this->FESPAIS->save();
$this->getUser()->addLogAction($this->accio, 'gConfig', $this->FESPAIS->getObject());
$this->FESPAIS = EspaisPeer::initialize($this->FESPAIS->getObject()->getEspaiid(), $this->IDS);
}
//Agafem els multimèdia dels paràmetres
$AMR = $request->getParameter('multimedia');
$FMR = $request->getFiles('multimedia');
foreach ($AMR as $K => $MR) {
if ($MR['accio'] == 1 || $MR['accio'] == 0) {
//És nou o una modificació
$FM = MultimediaPeer::initialize($MR['multimedia_id'], $MR['site_id'], $MR['taula'], $MR['id_extern'], $K);
$FM->bind($MR, $FMR[$K]);
$FM->saveNewUpdate();
} elseif ($MR['accio'] == 2) {
//S'ha d'esborrar
$FM = MultimediaPeer::initialize($MR['multimedia_id'], $MR['site_id'], $MR['taula'], $MR['id_extern'], $K);
$FM->delete();
}
}
break;
case 'DELETE_ESPAI':
$this->FESPAIS->getObject()->setActiu(false)->save();
$this->getUser()->addLogAction($this->accio, 'gConfig', $this->FESPAIS->getObject());
$this->FESPAIS = EspaisPeer::initialize(0, $this->IDS);
break;
case 'SAVE_MATERIAL':
//Si entrem un espai que és 0, llavors vol dir que fem un nou espai
if ($RMATERIAL['idMaterialGeneric'] == 0) {
unset($RMATERIAL['idMaterialGeneric']);
}
$this->FMATERIAL->bind($RMATERIAL);
if ($this->FMATERIAL->isValid()) {
$this->FMATERIAL->save();
$this->getUser()->addLogAction($this->accio, 'gConfig', $this->FMATERIAL->getObject());
$this->FMATERIAL = MaterialgenericPeer::initialize($this->FMATERIAL->getObject()->getIdmaterialgeneric(), $this->IDS);
}
break;
case 'DELETE_MATERIAL':
$this->FMATERIAL->getObject()->setInactiu();
$this->getUser()->addLogAction($this->accio, 'gConfig', $this->FMATERIAL->getObject());
$this->FMATERIAL = MaterialgenericPeer::initialize(0, $this->IDS);
break;
//Vincula l'usuari del facebook
//Vincula l'usuari del facebook
case 'FB_LINK':
$idU = $this->getUser()->getSessionPar('idU');
$OU = UsuarisPeer::retrieveByPK($idU);
$FB_ID = $this->PARS['user']['id'];
//Mirem si el número de facebook està associat a un altre usuari. Si és així, no fem res però emetem error.
$OUF = UsuarisPeer::getUserFromFacebook($FB_ID);
if ($OUF instanceof Usuaris) {
$this->ERROR = 'El compte de facebook actual està vinculat a un altre usuari. <br />Si us plau comuniqui-ho a informatica@casadecultura.org o bé entri al seu usuari de facebook i torni-ho a provar.';
} elseif ($OU instanceof Usuaris) {
$OU->setFacebookid($this->PARS['user']['id']);
$OU->save();
}
$this->FBI = UsuarisPeer::getUserFbCode($this->getUser()->getSessionPar('idU'));
break;
//Desvincula l'usuari del facebook
//Desvincula l'usuari del facebook
case 'FB_UNLINK':
$idU = $this->getUser()->getSessionPar('idU');
$OU = UsuarisPeer::retrieveByPK($idU);
$OU->setFacebookid(NULL);
$OU->save();
$this->FBI = UsuarisPeer::getUserFbCode($this->getUser()->getSessionPar('idU'));
break;
//Guardem els canvis a una entitat
//Guardem els canvis a una entitat
case 'SAVE_SITE':
$RS = $request->getParameter('sites');
$this->FENTITAT->bind($RS, $request->getFiles('sites'));
if ($this->FENTITAT->isValid()) {
$this->FENTITAT->save();
$this->getUser()->addLogAction($this->accio, 'gConfig', $this->FENTITAT->getObject());
$this->FENTITAT = SitesPeer::initialize($this->IDS);
}
break;
case 'SAVE_DESCOMPTE':
//Si entrem un descompte que és 0, vol dir que creem un nou descompte
$this->FDESCOMPTE->bind($RDESCOMPTE);
if ($this->FDESCOMPTE->isValid()) {
$this->FDESCOMPTE->save();
$this->getUser()->addLogAction($this->accio, 'gConfig', $this->FDESCOMPTE->getObject());
$this->FDESCOMPTE = DescomptesPeer::initialize($this->FDESCOMPTE->getObject()->getIddescompte(), $this->IDS);
}
break;
}
}
/**
* Espais Tab
* */
function EspaisTab($FESPAIS = "")
{
$RET = '
<form id="FESPAIS" action="' . url_for('gestio/gConfig') . '" method="POST" enctype="multipart/form-data">
<table class="FORMULARI">
' . $FESPAIS . '
</table>';
$LFMultimedia = $FESPAIS->getFotosEspais();
$RET .= '<div style="margin-top:20px;">';
foreach ($LFMultimedia as $FMultimedia) {
$RET .= '<div style="float:left; margin-left:100px;">' . $FMultimedia . '</div>';
}
$OE = $FESPAIS->getObject();
$RET .= '<div style="float:left; margin-left:100px;">' . MultimediaPeer::initialize(-1, $OE->getSiteId(), EspaisPeer::TABLE_NAME, $OE->getEspaiid(), sizeof($LFMultimedia) + 1) . '</div>';
$RET .= '</div><div style="clear:both;"></div>';
$RET .= '
<div style="text-align:right; margin-top:20px;">
<button style="margin-top:10px;" name="EDIT" class="BOTO_ACTIVITAT">
' . image_tag('template/find.png') . ' Consulta
</BUTTON>
<button type="submit" name="BSAVEESPAI" class="BOTO_ACTIVITAT" onClick="return confirm(\'Segur que vols guardar els canvis?\')">
' . image_tag('template/disk.png') . ' Guardar i sortir
</button>
<button type="submit" name="BDELETEESPAI" class="BOTO_PERILL" onClick="return confirm(\'Segur que vols esborrar-lo?\')">
' . image_tag('tango/16x16/status/user-trash-full.png') . ' Eliminar
</button>
</div>
</form>';
return $RET;
}
public function getFotos()
{
return MultimediaPeer::getFotosEspais($this->getEspaiid(), $this->getSiteId());
}
