include 'sess.php'; $gen = $_REQUEST["gen"] ?? ""; if($gen == "excel") { require_once('dbase.php'); $mys = ConexDB(); $result = Query($mys, "select ir1.carga, i.name, i.bcode, i.refference, i.cia, ir1.warehouse, SUM(ir1.dispatch), ir1.check_registred, GROUP_CONCAT(ir1.user), GROUP_CONCAT(ir1.comments), IFNULL(ir2.warehouse, '-'), IFNULL(ir2.received, 0), IFNULL(ir2.check_registred, '-'), IFNULL(ir2.user, '-'), IFNULL(ir2.comments, '-'), IFNULL(ir2.difference, SUM(ir1.difference)) from InventoryRegistry ir1 JOIN Inventory i ON ir1.prod_id = i.id LEFT JOIN InventoryRegistry ir2 ON ir1.carga = ir2.carga AND ir1.prod_id = ir2.prod_id AND ir2.type = 'IN' WHERE ir1.type = 'OUT' GROUP BY ir1.carga, ir1.prod_id;", array()); if(!$result || count($result) == 0) { echo "Error al intentar generar el documento!"; die(); } require_once('/Aplicacion_inventario/libs/xlsx/SimpleXLSXGen.php'); $excl = [['