function getComandesEstadistiques($idSessio, $TipusPagament = '-', $TipusComanda = '-', $Totals = 'S', $LlocCompra = '-', $Mesi = array(), $Mesf = array()) { $W = array(); $SQL = array(); $SQL[] = "SELECT c.*, l.*, e.*, s.* \n FROM comandes c \n INNER JOIN localitats l on l.l_idComanda = c.co_idComanda\n INNER JOIN sessions s on l.l_idSessio = s.s_id\n INNER JOIN espectacles e on e.e_id = s.s_idEspectacle\n WHERE c.co_estat in ('P')"; if ($idSessio > 0) { $W['idSessio'] = filter_var($idSessio, FILTER_SANITIZE_NUMBER_INT); $SQL[] = " AND l.l_idSessio = :idSessio"; } if ($TipusPagament != '-') { $W['TipusPagament'] = $TipusPagament; $SQL[] = " AND c.co_TipusPagament = :TipusPagament"; } if ($TipusComanda != '-') { $W['TipusComanda'] = $TipusComanda; $SQL[] = " AND c.co_TipusComanda = :TipusComanda"; } if ($LlocCompra != '-') { $W['LlocCompra'] = $LlocCompra; $SQL[] = " AND c.co_LlocCompra = :LlocCompra"; } if (!$Mesi->isEmpty()) { $W['Datai'] = $Mesi->getUnixTimestamp(true); $SQL[] = " AND s.s_DataHora >= :Datai"; } if (!$Mesf->isEmpty()) { $W['Dataf'] = $Mesf->getUnixTimestamp(false); $SQL[] = " AND s.s_DataHora <= :Dataf"; } $SQL[] = " ORDER BY c.co_data desc"; //Surt per espectacle, quantes n'hi ha de cada... $LlistatComandesSeients = $this->db->select(implode(" ", $SQL), $W); $Detall = array(); $Totals = array(); $TotalDia = array(); //Si no vull totals, només vull un llistat de totes les compres que hi ha hagut últimament foreach ($LlistatComandesSeients as $ComandaSeient) { //************** Càlcul de detall ********************** $CTO = new ComandaTableObject($ComandaSeient, ComandaTableObject::FROM_BDD); $LTO = new LocalitatTableObject($ComandaSeient, LocalitatTableObject::FROM_BDD); $STO = new SessioTableObject($ComandaSeient, SessioTableObject::FROM_BDD); $ETO = new EspectacleTableObject($ComandaSeient, EspectacleTableObject::FROM_BDD); $idC = $ComandaSeient['co_idComanda']; $idS = $ComandaSeient['l_idSessio']; $OP = $LTO->getPreu(); if (!isset($Detall[$idC])) { $Detall[$idC]['Comanda'] = $CTO; } $Detall[$idC]['Localitats'][] = $LTO; if (!isset($Detall[$idC]['Sessions'][$idS])) { $Detall[$idC]['Sessions'][$idS] = array('sessio' => $STO, 'espectacle' => $ETO); } //************** Càlcul de totals ********************** $Dia = date('d-m-Y', $CTO->comanda['co_data']); if (!isset($TotalDia[$Dia])) { $TotalDia[$Dia] = array('dia' => $Dia, 'TS' => array()); } if (!isset($TotalDia[$Dia]['TS'][$idS])) { $TotalDia[$Dia]['TS'][$idS] = array('sessio' => $STO, 'espectacle' => $ETO, 'co_TipusComanda' => array(), 'co_TipusPagament' => array(), 'co_LlocCompra' => array(), 'l_idPreu' => array('Total' => array('nom' => 'Total', 'quantitat' => 0, 'import' => 0))); } if (!isset($Totals[$idS])) { $Totals[$idS] = array('sessio' => $STO, 'espectacle' => $ETO, 'co_TipusComanda' => array(), 'co_TipusPagament' => array(), 'co_LlocCompra' => array(), 'l_idPreu' => array('Total' => array('nom' => 'Total', 'quantitat' => 0, 'import' => 0))); } $name = "co_TipusComanda"; $valor = $ComandaSeient[$name]; if (!isset($Totals[$idS][$name][$valor])) { $Totals[$idS][$name][$valor] = array('text' => $CTO->getTipusComandaString(), 'total' => 0); } if (!isset($TotalDia[$Dia]['TS'][$idS][$name][$valor])) { $TotalDia[$Dia]['TS'][$idS][$name][$valor] = array('text' => $CTO->getTipusComandaString(), 'total' => 0); } $Totals[$idS][$name][$valor]['total']++; $TotalDia[$Dia]['TS'][$idS][$name][$valor]['total']++; if ($LTO->localitat['l_estat'] == LocalitatTableObject::ESTAT_OCUPADA) { $name = "co_LlocCompra"; $valor = $ComandaSeient[$name]; if (!isset($Totals[$idS][$name][$valor])) { $Totals[$idS][$name][$valor] = array('text' => $CTO->getTipusLlocCompraString(), 'total' => 0); } if (!isset($TotalDia[$Dia]['TS'][$idS][$name][$valor])) { $TotalDia[$Dia]['TS'][$idS][$name][$valor] = array('text' => $CTO->getTipusLlocCompraString(), 'total' => 0); } $Totals[$idS][$name][$valor]['total']++; $TotalDia[$Dia]['TS'][$idS][$name][$valor]['total']++; $name = "co_TipusPagament"; $valor = $ComandaSeient[$name]; if (!isset($Totals[$idS][$name][$valor])) { $Totals[$idS][$name][$valor] = array('text' => $CTO->getTipusPagamentString(), 'total' => 0); } if (!isset($TotalDia[$Dia]['TS'][$idS][$name][$valor])) { $TotalDia[$Dia]['TS'][$idS][$name][$valor] = array('text' => $CTO->getTipusPagamentString(), 'total' => 0); } $Totals[$idS][$name][$valor]['total']++; $TotalDia[$Dia]['TS'][$idS][$name][$valor]['total']++; $name = "l_idPreu"; $valor = $OP->preu['nom']; if (!isset($Totals[$idS][$name][$valor])) { $Totals[$idS][$name][$valor] = array('nom' => $OP->preu['nom'], 'quantitat' => 0, 'import' => 0); } if (!isset($TotalDia[$Dia]['TS'][$idS][$name][$valor])) { $TotalDia[$Dia]['TS'][$idS][$name][$valor] = array('nom' => $OP->preu['nom'], 'quantitat' => 0, 'import' => 0); } $Totals[$idS][$name][$valor]['import'] += $OP->preu['import']; $Totals[$idS][$name][$valor]['quantitat']++; $Totals[$idS][$name]['Total']['import'] += $OP->preu['import']; $Totals[$idS][$name]['Total']['quantitat']++; $TotalDia[$Dia]['TS'][$idS][$name][$valor]['import'] += $OP->preu['import']; $TotalDia[$Dia]['TS'][$idS][$name][$valor]['quantitat']++; $TotalDia[$Dia]['TS'][$idS][$name]['Total']['import'] += $OP->preu['import']; $TotalDia[$Dia]['TS'][$idS][$name]['Total']['quantitat']++; } } $RET = array('Detall' => $Detall, 'Totals' => $Totals, 'TotalDia' => $TotalDia); return $RET; }