Severity: Notice
Message: Undefined index: idmarca
Filename: controllers/Marcas.php
Line Number: 521
Backtrace:
File: /home/soydali1/public_html/application/controllers/Marcas.php
Line: 521
Function: _error_handler
File: /home/soydali1/public_html/index.php
Line: 315
Function: require_once
Severity: Notice
Message: Undefined index: idcategoria
Filename: controllers/Marcas.php
Line Number: 522
Backtrace:
File: /home/soydali1/public_html/application/controllers/Marcas.php
Line: 522
Function: _error_handler
File: /home/soydali1/public_html/index.php
Line: 315
Function: require_once
Severity: Notice
Message: Undefined index: next
Filename: controllers/Marcas.php
Line Number: 523
Backtrace:
File: /home/soydali1/public_html/application/controllers/Marcas.php
Line: 523
Function: _error_handler
File: /home/soydali1/public_html/index.php
Line: 315
Function: require_once
Severity: Notice
Message: Undefined index: prev
Filename: controllers/Marcas.php
Line Number: 524
Backtrace:
File: /home/soydali1/public_html/application/controllers/Marcas.php
Line: 524
Function: _error_handler
File: /home/soydali1/public_html/index.php
Line: 315
Function: require_once
Severity: Notice
Message: Undefined index: offset
Filename: controllers/Marcas.php
Line Number: 525
Backtrace:
File: /home/soydali1/public_html/application/controllers/Marcas.php
Line: 525
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/Marcas_model.php
Line: 403
Function: get
File: /home/soydali1/public_html/application/controllers/Marcas.php
Line: 534
Function: inventario_marca_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 '-16, 16' at line 20
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`.`descripcion`, `codigos`.`id_producto`, `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` 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 `marcas` ON `marcas`.`id` = `productos`.`id_marca` JOIN `presentaciones` ON `presentaciones`.`id` = `codigos`.`id_presentacion` JOIN `unidades` ON `unidades`.`id` = `presentaciones`.`id_unidad` 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 `productos`.`id_marca` IS NULL AND `productos`.`id_categoria` IS NULL AND `productos`.`status` = 1 AND `categorias`.`status` = 1 GROUP BY `inventario`.`id_codigo` ORDER BY `productos`.`producto` ASC LIMIT -16, 16
Filename: models/Marcas_model.php
Line Number: 403