🌹🏠🌹？》《》？《》？<?php

include "../include/inicio.php";

set_time_limit(0);

//tomo la grilla filtrada
$filtrada = $_SESSION['grilla']['ingresosDeposito']['sqlFiltrada'];
if(!$filtrada)$filtrada = $sqlDatos;
                                     
$partes = sql2array($filtrada);
if( empty( trim( $partes['where'] ) ) ) $partes['where'] = ' 1 = 1 ';

$nuevoFrom = $partes['from'];

//calculo los nuevos campos
$groupby = ( empty( trim( $partes['groupby'] ) ) ) ? '' : " GROUP BY {$partes['groupby']} ";
$sqlNuevo = "SELECT DISTINCT b.nro_rem remitos, '' a_imagen FROM ".$nuevoFrom." WHERE ".$partes['where'].$groupby;
$cant_remitos = number_format( (float)count($db->resultado($sqlNuevo)), 0);

$sqlNuevo = "SELECT SUM(b.bultos) bultos FROM ".$nuevoFrom." WHERE ".$partes['where'];
$cant_bultos = number_format( (float)$db->campos($sqlNuevo, 'bultos'), 0);

$sqlNuevo = "SELECT SUM(b.unidades) unidades FROM ".$nuevoFrom." WHERE ".$partes['where'];
$cant_unidades = number_format( (float)$db->campos($sqlNuevo, 'unidades'), 0);

$sqlNuevo = "SELECT SUM(b.volumen) volumen FROM ".$nuevoFrom." WHERE ".$partes['where'];
$cant_volumen = number_format( (float)$db->campos($sqlNuevo, 'volumen'), 2);

echo $cant_remitos."@".$cant_bultos."@".$cant_unidades."@".$cant_volumen;

?>