[19-Jun-2025 09:02:35 America/Lima] ⚠️ No se encontraron compras con esos filtros.
[27-Jun-2025 18:10:51 America/Lima] PHP Warning:  Trying to access array offset on value of type null in /home/sicse/public_html/mkj.sicsemkj.com/api/caja/llenar_operacionesX.php on line 18
[27-Jun-2025 18:10:51 America/Lima] PHP Fatal error:  Uncaught TypeError: mysqli_query(): Argument #1 ($mysql) must be of type mysqli, PDO given in /home/sicse/public_html/mkj.sicsemkj.com/api/caja/llenar_operacionesX.php:20
Stack trace:
#0 /home/sicse/public_html/mkj.sicsemkj.com/api/caja/llenar_operacionesX.php(20): mysqli_query(Object(PDO), 'SELECT * from o...')
#1 {main}
  thrown in /home/sicse/public_html/mkj.sicsemkj.com/api/caja/llenar_operacionesX.php on line 20
[28-Jun-2025 00:35:46 America/Lima] ❌ Error en Listar_MovCaja: Se esperaban 7 parámetros.
[28-Jun-2025 01:27:44 America/Lima] ⚠️ No se encontraron compras con esos filtros.
[28-Jun-2025 01:43:50 America/Lima] ⚠️ No se encontraron compras con esos filtros.
[28-Jun-2025 01:47:24 America/Lima] ⚠️ No se encontraron compras con esos filtros.
[28-Jun-2025 02:55:25 America/Lima] PHP Warning:  Trying to access array offset on value of type null in /home/sicse/public_html/mkj.sicsemkj.com/api/caja/llenar_operacionesX.php on line 18
[28-Jun-2025 02:55:25 America/Lima] PHP Fatal error:  Uncaught TypeError: mysqli_query(): Argument #1 ($mysql) must be of type mysqli, PDO given in /home/sicse/public_html/mkj.sicsemkj.com/api/caja/llenar_operacionesX.php:20
Stack trace:
#0 /home/sicse/public_html/mkj.sicsemkj.com/api/caja/llenar_operacionesX.php(20): mysqli_query(Object(PDO), 'SELECT * from o...')
#1 {main}
  thrown in /home/sicse/public_html/mkj.sicsemkj.com/api/caja/llenar_operacionesX.php on line 20
[28-Jun-2025 03:10:12 America/Lima] ❌ Error en Listar_MovCaja: Se esperaban 7 parámetros.
[28-Jun-2025 07:04:42 America/Lima] ⚠️ No se encontraron compras con esos filtros.
[28-Jun-2025 07:13:59 America/Lima] ⚠️ No se encontraron compras con esos filtros.
[29-Jun-2025 09:41:51 America/Lima] ⚠️ No se encontraron compras con esos filtros.
[29-Jun-2025 09:50:33 America/Lima] ⚠️ No se encontraron compras con esos filtros.
[29-Jun-2025 09:52:16 America/Lima] ⚠️ No se encontraron compras con esos filtros.
[03-Oct-2025 20:29:37 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[06-Oct-2025 16:57:01 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[06-Oct-2025 17:24:55 America/Lima] ❌ Error en Listar_MovCaja: SQLSTATE[42803]: Grouping error: 7 ERROR:  column "dp.cobranza_id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 26:     dp.cobranza_id,
             ^
QUERY:  CREATE TEMP TABLE tmp_detcaja ON COMMIT DROP AS
        SELECT 
            dc.id, dc.tipo_movcaja, dc.nrecibo, dc.fecha_operacion, dc.operacion_id,
            dc.cuenta_id, dc.nombre, dc.docfiscal_id, dc.nserie, dc.ndocumento,
            dc.fecha_emision, dc.ingreso, dc.egreso, dc.partida_id, dc.nombre_partida,
            dc.moneda, dc.tipo_cambio, dc.movimiento_id, dc.operacion, dc.offsystem,
            dc.banco, dc.cuenta_corriente, dc.lugar, dc.operacion_banco,
            CAST(
                CASE 
                    WHEN dc.operacion = 'VTA' AND pagos.formas_pago IS NOT NULL THEN
                        COALESCE(dc.observacion || E'\n💵 Pagado con: ' || pagos.formas_pago, dc.observacion)
                    ELSE 
                        dc.observacion
                END
            AS varchar) AS observacion,
            dc.afecta_cajasunat, dc.anulado, dc.ventaref_id, dc.compraref_id,
            dc.sucursal_id, dc.empresa_id,
            NULL::varchar AS operacion_caja,
            dc.destino_cobranza,
            COALESCE(pagos.pagos_electronicos, 0)::numeric AS pagos_electronicos
        FROM detcaja dc
        LEFT JOIN operaciones_caja oc ON oc.id = dc.operacion_id
        LEFT JOIN (
            SELECT 
                dp.venta_id,
				dp.cobranza_id,
                -- Solo necesitamos el total no-efectivo para la salida final
                SUM(dp.monto_pago) FILTER (WHERE UPPER(dp.descripcion_pago) <> 'EFECTIVO') AS pagos_electronicos,
                -- Opcional: mantener formas_pago para decorar observación
                STRING_AGG(
                    DISTINCT dp.descripcion_pago || ' (' || TO_CHAR(dp.monto_pago, 'FM999,999,990.00') || ')',
                    ' + '
                ) AS formas_pago
            FROM despacho_pago dp
            WHERE dp.activo = false
              AND dp.empresa_id = cIdEmpresa
              AND dp.sucursal_id = cIdSucursal
            GROUP BY dp.venta_id
        ) pagos 
		  ON (dc.operacion = 'VTA' AND pagos.venta_id = dc.movimiento_id)
          OR (dc.operacion = 'COB' AND pagos.cobranza_id = dc.movimiento_id)
        WHERE dc.empresa_id = cIdEmpresa
          AND dc.sucursal_id = cIdSucursal
          AND dc.cuenta_id = cIdCaja
          AND dc.fecha_operacion BETWEEN cFechaIni AND cFechaFin
          AND (
              cValor = '' OR 
              dc.nombre_partida ILIKE '%' || cValor || '%' OR 
              oc.nombre ILIKE '%' || cValor || '%'
          )
CONTEXT:  PL/pgSQL function listar_movcaja(integer,integer,integer,date,date,character varying,character varying) line 4 at SQL statement
[07-Oct-2025 17:30:35 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[09-Oct-2025 09:57:50 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[10-Oct-2025 09:45:27 America/Lima] ⚠️ No se encontraron compras con esos filtros.
[17-Oct-2025 11:11:36 America/Lima] ⚠️ No se encontraron compras con esos filtros.
[17-Oct-2025 11:19:21 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[08-Nov-2025 12:47:11 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[10-Nov-2025 10:28:19 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[11-Nov-2025 12:24:56 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[12-Nov-2025 19:12:48 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[13-Nov-2025 10:58:15 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[14-Nov-2025 00:25:33 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[15-Nov-2025 00:42:14 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[24-Nov-2025 15:47:55 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[28-Nov-2025 13:57:13 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[02-Dec-2025 07:15:04 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[03-Dec-2025 19:40:04 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[03-Dec-2025 20:48:14 America/Lima] ⚠️ No se encontraron compras con esos filtros.
[10-Dec-2025 07:39:13 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[11-Dec-2025 17:28:09 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[13-Dec-2025 22:48:26 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[14-Dec-2025 00:05:42 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[17-Dec-2025 16:10:43 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[19-Dec-2025 15:54:14 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[22-Dec-2025 09:55:14 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[23-Dec-2025 09:57:26 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[24-Dec-2025 18:06:29 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[25-Dec-2025 13:36:56 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[29-Dec-2025 09:07:12 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[30-Dec-2025 10:20:03 America/Lima] ⚠️ No se encontraron compras con esos filtros.
[31-Dec-2025 07:53:07 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[02-Jan-2026 09:41:03 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[03-Jan-2026 11:25:46 America/Lima] PHP Warning:  Undefined array key "nregistros" in /home/sicse/public_html/mkj.sicsemkj.com/api_comercial/caja/cierre.php on line 37
[07-Jan-2026 13:46:06 America/Lima] ⚠️ No se encontraron compras con esos filtros.
