Severity: Notice
Message: Undefined index: idcat
Filename: controllers/Categorias.php
Line Number: 194
Backtrace:
File: /home/soydali1/public_html/application/controllers/Categorias.php
Line: 194
Function: _error_handler
File: /home/soydali1/public_html/index.php
Line: 315
Function: require_once
Severity: Notice
Message: Undefined index: next
Filename: controllers/Categorias.php
Line Number: 195
Backtrace:
File: /home/soydali1/public_html/application/controllers/Categorias.php
Line: 195
Function: _error_handler
File: /home/soydali1/public_html/index.php
Line: 315
Function: require_once
Severity: Notice
Message: Undefined index: prev
Filename: controllers/Categorias.php
Line Number: 196
Backtrace:
File: /home/soydali1/public_html/application/controllers/Categorias.php
Line: 196
Function: _error_handler
File: /home/soydali1/public_html/index.php
Line: 315
Function: require_once
Severity: Notice
Message: Undefined index: offset
Filename: controllers/Categorias.php
Line Number: 197
Backtrace:
File: /home/soydali1/public_html/application/controllers/Categorias.php
Line: 197
Function: _error_handler
File: /home/soydali1/public_html/index.php
Line: 315
Function: require_once
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /home/soydali1/public_html/system/core/Exceptions.php:271)
Filename: core/Common.php
Line Number: 564
Backtrace:
File: /home/soydali1/public_html/application/models/Productos_model.php
Line: 51
Function: get
File: /home/soydali1/public_html/application/controllers/Categorias.php
Line: 205
Function: inventario_categoria
File: /home/soydali1/public_html/index.php
Line: 315
Function: require_once
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-15, 15' at line 17
SELECT `codigos`.`precio3` `precio_venta`, sum(if(inventario.id_detalle_venta = 0 and inventario.anulada = 0, `inventario`.`item`, 0)) inventario, `inventario`.`id_codigo`, `codigos`.`id` `idcodigo`, `codigos`.`codigo`, `codigos`.`id_producto`, `codigos`.`descripcion`, `codigos`.`imagen_nueva`, `codigos`.`descuento`, `codigos`.`descuento`, `codigos`.`oferta`, `codigos`.`precio1`, `codigos`.`precio2`, `codigos`.`precio3`, `codigos`.`precio4`, `productos`.`id` `idprod`, `productos`.`id_categoria`, `productos`.`producto`, `categorias`.`id` `idcat`, `categorias`.`categoria`, `presentaciones`.`id` `idpres`, `presentaciones`.`id_categoria` `catpres`, `presentaciones`.`id_unidad`, `presentaciones`.`medida`, `unidades`.`id` `iduni`, `unidades`.`unidad`, `marcas`.`id` `idmarca`, `marcas`.`marca`, `marcas`.`status` FROM `inventario` JOIN `codigos` ON `codigos`.`id` = `inventario`.`id_codigo` JOIN `productos` ON `productos`.`id` = `codigos`.`id_producto` JOIN `categorias` ON `categorias`.`id` = `productos`.`id_categoria` JOIN `presentaciones` ON `presentaciones`.`id` = `codigos`.`id_presentacion` JOIN `unidades` ON `unidades`.`id` = `presentaciones`.`id_unidad` JOIN `marcas` ON `marcas`.`id` = `productos`.`id_marca` WHERE `inventario`.`precio_venta` = 0 AND `inventario`.`status` = 1 AND `inventario`.`id_tienda` = 1 AND `inventario`.`anulada` = 0 AND `inventario`.`id_detalle_venta` = 0 AND `categorias`.`id` IS NULL GROUP BY `inventario`.`id_codigo` ORDER BY `productos`.`producto` ASC LIMIT -15, 15
Filename: models/Productos_model.php
Line Number: 51