public CierreDeCaja() { InitializeComponent(); string query = "SELECT 'Total Efectivo' as 'Titulo', sum(pagosparciales.monto) as Monto FROM pagosparciales WHERE medio_de_pago = 1 AND date(pagosparciales.fecha) = CURRENT_DATE"; ControlAdministracion.construirTablaPagos(dgv_tabla_efectivo, query); query = "SELECT 'Total Crédito/Débito' as 'Titulo', sum(pagosparciales.monto) as Monto FROM pagosparciales WHERE (medio_de_pago = 3 OR medio_de_pago = 4) AND date(pagosparciales.fecha) = CURRENT_DATE"; ControlAdministracion.construirTablaPagos(dgv_tabla_tarjeta, query); query = "SELECT v.remito as Titulo,monto as Monto FROM pagosparciales p INNER JOIN venta v on p.id_venta = v.id WHERE (p.medio_de_pago = 3 OR p.medio_de_pago = 4) AND date(p.fecha) = CURRENT_DATE"; ControlAdministracion.construirTablaPagos(dgv_tabla_detalle_tarjetas, query); query = "SELECT v.remito as Titulo,monto as Monto FROM pagosparciales p INNER JOIN venta v on p.id_venta = v.id WHERE (p.medio_de_pago = 3 OR p.medio_de_pago = 4) AND date(p.fecha) = CURRENT_DATE"; ControlAdministracion.construirTablaPagos(dgv_tabla_detalle_tarjetas, query); query = "SELECT r.remito as Titulo,monto as Monto FROM pagosparciales p INNER JOIN reparaciones r on p.id_reparacion = r.id WHERE (p.medio_de_pago = 3 OR p.medio_de_pago = 4) AND date(p.fecha) = CURRENT_DATE"; ControlAdministracion.construirTablaPagos(dgv_tabla_detalle_tarjetas_reparaciones, query); query = "SELECT round(sum(pagosparciales.monto),2) as Monto, 'Total Cheques' as 'Titulo' FROM pagosparciales WHERE medio_de_pago = 5 AND date(fecha) = CURRENT_DATE"; ControlAdministracion.construirTablaPagos(dgv_tabla_cheques, query); query = "SELECT CONCAT(razon_social, ' ', banco, ' ',comprobante) as Titulo,monto as Monto FROM pagosparciales WHERE medio_de_pago = 5 AND date(fecha) = CURRENT_DATE"; ControlAdministracion.construirTablaPagos(dgv_tabla_detalle_cheque, query); query = "SELECT round(sum(pagosparciales.monto),2) as Monto, 'Total Transferencias' as 'Titulo' FROM pagosparciales WHERE medio_de_pago = 6 AND date(fecha) = CURRENT_DATE"; ControlAdministracion.construirTablaPagos(dgv_tabla_transferencia, query); query = "SELECT CONCAT(banco, ' ',comprobante) as Titulo,monto as Monto FROM pagosparciales WHERE medio_de_pago = 6 AND date(fecha) = CURRENT_DATE"; ControlAdministracion.construirTablaPagos(dgv_tabla_transferencia_detalle, query); query = "SELECT round(sum(monto),2) as Monto, 'Total' as Titulo FROM pagosparciales WHERE date(fecha) = CURRENT_DATE"; ControlAdministracion.construirTablaPagos(dgv_tabla_total, query); }