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);
}
}
