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);
}
