private void CostosProduccionToolStripMenuItem_Click(object sender, EventArgs e)
{
Polizas.Polizas poliza = new Polizas.Polizas();
poliza.Show();
poliza.MdiParent = this;
poliza.AsignarQuery(
"select 'COSTO PRIMO' as cuenta , (SELECT round(sum( DISTINCT cp.costo_unitario_producto),3) from costos_produccion cp where cp.fecha BETWEEN 'FechaI' and 'FechaF') as debe ,'0' as haber UNION ALL select 'MANO DE OBRA DIRECTA' as cuenta, (SELECT round(sum(DISTINCT cp.suma_costo_mo), 3) from costos_produccion cp where cp.fecha BETWEEN 'FechaI' and 'FechaF') as debe , '0' as haber UNION ALL select 'MATERIA PRIMA' as cuenta , (SELECT round(sum(DISTINCT cp.suma_costo_mp), 3) from costos_produccion cp where cp.fecha BETWEEN 'FechaI' and 'FechaF') as debe ,'0' as haber UNION ALL SELECT 'CAJA' as cuenta, '0' as debe, round(sum(DISTINCT cp.suma_costo_mp) + SUM(DISTINCT cp.suma_costo_mo) + SUM(DISTINCT cp.costo_unitario_producto), 3) as haber from costos_produccion cp where cp.fecha BETWEEN 'FechaI' and 'FechaF' ; ");
poliza.AsignarColores(Color.FromArgb(165, 132, 197), Color.Black);
}
private void PólizaToolStripMenuItem_Click(object sender, EventArgs e)
{
Polizas.Polizas poliza = new Polizas.Polizas();
poliza.MdiParent = this;
poliza.Show();
poliza.AsignarQuery(
"SELECT 'BANCOS' AS Cuenta, (SELECT ROUND(COALESCE(SUM(A.`saldo`),'0'),2) FROM `cuentas_bancarias` A, `modulos` B " +
"WHERE A.`estado`=1 AND A.`id_modulo` = B.`id_modulo` AND A.fecha_apertura " +
"BETWEEN 'FechaI' AND 'FechaF') AS Debe, '0' AS Haber UNION ALL " +
"SELECT(concat_ws(' ', 'Cuenta No.', cb.no_cuenta_bancaria)) AS Cuenta, ('0') AS Debe, (cb.`saldo`) AS Haber " +
"FROM cuentas_bancarias cb, modulos md WHERE md.id_modulo = cb.id_modulo AND cb.fecha_apertura " +
"BETWEEN 'FechaI' AND 'FechaF' AND cb.estado = 1 GROUP BY cb.no_cuenta_bancaria;");
poliza.AsignarColores(Color.Firebrick, Color.White);
}
private void polizaToolStripMenuItem_Click(object sender, EventArgs e)
{
Polizas.Polizas poliza = new Polizas.Polizas();
poliza.MdiParent = this;
poliza.Show();
poliza.AsignarQuery(
" SELECT 'SUELDOS' AS Cuenta, (SELECT round(COALESCE(sum(detalle_planilla.total_liquido), 0), 2) AS Sueldos FROM detalle_planilla INNER JOIN planilla ON planilla.id_planilla = detalle_planilla.id_planilla WHERE planilla.fecha_inicio >= 'FechaI' AND planilla.fecha_fin <= 'FechaF') AS Debe, '0' AS Haber UNION ALL SELECT 'BANCOS' AS Cuenta, '0' AS Debe, (SELECT round(COALESCE(sum(detalle_planilla.total_liquido), 0), 2) AS Sueldos FROM detalle_planilla INNER JOIN planilla ON planilla.id_planilla = detalle_planilla.id_planilla WHERE planilla.fecha_inicio >= 'FechaI' AND planilla.fecha_fin <= 'FechaF') AS Haber;");
/**/
/**/
poliza.AsignarColores(Color.Blue, Color.White);
}
