public function executeGEstadistiques(sfWebRequest $request) { $this->setLayout('gestio'); $this->IDS = $this->getUser()->getSessionPar('idS'); $this->CERCA = $request->getParameter('cerca', $this->CERCA); $this->CERCA = $this->getCercaEstadistiquesComplet($this->CERCA); if ($request->hasParameter('BCERCA_ESP')) { $this->ESPAIS = EspaisPeer::select($this->IDS); $dit = mktime(0, 0, 0, $this->CERCA['MES'], 1, $this->CERCA['ANY']); $month = date('m', $dit); $year = date('Y', $dit); $site = $this->IDS; $Espais = $this->CERCA['ESPAI']; if (empty($this->CERCA['ESPAI'])) { foreach ($this->ESPAIS as $K => $V) { $Espais[$K] = $K; } } $this->DATA = mktime(0, 0, 0, $month, 1, $year); $this->OCUPACIO_ESPAIS = EspaisPeer::getEstadistiquesEspais($Espais, $site, $month, $year); } elseif ($request->hasParameter('BCERCA_MAT')) { $this->MATERIAL = MaterialPeer::selectGeneric($this->CERCA['MATERIAL_GENERIC'], $this->IDS, null); $dit = mktime(0, 0, 0, $this->CERCA['MES'], 1, $this->CERCA['ANY']); $month = date('m', $dit); $year = date('Y', $dit); $site = $this->IDS; $this->OCUPACIO_MATERIAL = MaterialPeer::getEstadistiquesMaterial($this->CERCA['MATERIAL'], $site, $month, $year); } }