search

TeamSQL / desktop-app

This repository is currently being used for hosting the official issue & bug tracker of TeamSQL Desktop App.
102 stars 6 forks source link

[BUG] Document Format Doesn't Work #484

Open Bubblebug17 opened 5 years ago

Bubblebug17 commented 5 years ago

OS: Linux x64 4.9.0-8-amd64 VERSION: 4.0.379

Database: MYSQL I have the following query, but when i want to format it, nothing happen.

SELECT g.id_grupo, g.grupo, (SELECT sum(det.precio_total) FROM tb_documento_det det LEFT JOIN tb_documento doc on det.id_documento = doc.id_documento AND doc.impuesto_total < 1 LEFT JOIN tb_articulo_sucursal arts on det.id_art_sucursal = arts.id_art_sucursal LEFT JOIN tb_articulo art on arts.id_articulo = art.id_articulo LEFT JOIN tb_subfamilia subf on art.id_subfamilia = subf.id_subfamilia LEFT JOIN tb_familia fam on subf.id_familia = fam.id_familia LEFT JOIN tb_grupo gg on fam.id_grupo = gg.id_grupo LEFT JOIN tb_articulo_sucu_impuesto artigv ON artigv.id_art_sucursal=arts.id_art_sucursal AND artigv.id_impuesto=3 AND artigv.id_tipo_igv <> 2 WHERE gg.id_grupo = g.id_grupo AND doc.id_tipomovimiento = 1 AND date(doc.fecha_ingreso) >= '2018-08-01' AND date(doc.fecha_ingreso) <= '2019-01-17' and doc.id_empresa=4 and gg.id_empresa = doc.id_empresa AND artigv.id_art_impuesto is not null) as compras_totales, g.estado estado FROM tb_grupo g WHERE g.id_empresa = '4' HAVING compras_totales is not null or estado = 1 ORDER BY compras_totales DESC