99// lcFiltroTipoTicket += " HAVING sum(COALESCE(Tk.ENTREGA,0) - COALESCE(Tk.CAMBIO,0)) - sum(COALESCE(Gd.importe,0)) != 0 AND max(Tc.TIPO_DOC) = 1 ";
100// }
101// }
102
103
104// lcSql = "SELECT max(coalesce(NULLIF(Tc.caja,''),'SIN CAJA')) as caja, max(coalesce(NULLIF(Cj.Nombre,''),'SIN CAJA')) as nombrecaja"
105// + ", max(coalesce(NULLIF(Gc.operario,''),'SIN OPERARIO')) as operario, max(coalesce(NULLIF(Toperario.nombre,''),'SIN OPERARIO')) as nombreoperario"
106// + ", max(Gc.vendedor) as vendedor, max(Vd.nombre) as nombrevendedor "
107// + ", max(Tc.letra) as serie, max(Tc.numero) as documento, max(Gc.fecha) as fecha, Sum(" + lcImporte + ") as importe, Sum(Gd.importediv) as importediv"
108// + ", sum(Tk.ENTREGA - Tk.CAMBIO) as entrega, MAX(Tk.IMPORTE) AS credito, max(Gc.CLIENTE) as cliente, max(coalesce(NULLIF(Tc.nomcli,''),Cl.Nombre)) as nombrecliente"
110// + " INNER JOIN " + DB.SQLDatabase("GESTION", "c_albven") + " Gc ON (Tc.empresa=Gc.empresa AND Tc.numero=Gc.numero AND Tc.letra=Gc.letra) "
111// + " INNER JOIN " + DB.SQLDatabase("GESTION", "d_albven") + " Gd ON (Tc.empresa=Gd.empresa AND Tc.numero=Gd.numero AND Tc.letra=Gd.letra) "
112// + " LEFT JOIN " + DB.SQLDatabase("COMUNES", "operario") + " Toperario ON Gc.operario = Toperario.codigo "
113// + " LEFT JOIN " + DB.SQLDatabase("TPV", "cajas") + " Cj ON Tc.caja = Cj.codigo "
114// + " LEFT JOIN " + DB.SQLDatabase("GESTION", "vendedor") + " Vd ON Gc.vendedor = Vd.codigo "
115// + " LEFT JOIN " + DB.SQLDatabase("GESTION", "articulo") + " Ar ON Gd.ARTICULO=Ar.CODIGO"
116// + " LEFT JOIN " + DB.SQLDatabase("GESTION", "clientes") + " Cl ON Gc.CLIENTE=Cl.CODIGO"
117// + " LEFT JOIN " + DB.SQLDatabase("TPV", "tikets") + " Tk ON (Tc.ejercicio=Tk.EJERCICIO AND Tc.empresa=Tk.EMPRESA AND Tc.LETRA=Tk.LETRA AND Tc.numero=Tk.numero) "
118// + " AND (Tk.TIPO = 1 OR Tk.TIPO = 2 OR Tk.TIPO = 10)" //Filtrem els tiquets de cobro i de factures
119// + " WHERE " + EW_GLOBAL._Consolida("Tc.Empresa") + " AND coalesce(Tc.ejercicio," + lcAny + ") = " + lcAny
120// + lcFiltros + lcFiltroTipoDoc
121// + " GROUP BY GC.fecha, Tc.EMPRESA, Tc.NUMERO, Tc.LETRA"
122// + lcFiltroTipoTicket
123// + " ORDER BY GC.fecha, Tc.EMPRESA, Tc.NUMERO, Tc.LETRA";
124
125
126// // Verifico si hay que ejecutar la consulta en varios ejercicios o en el actual
127// if (toEjercicios != null && toEjercicios.Length > 0)