Details | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 1 | espaco | 1 | SELECT |
| 2 | SUM(D.DIA01) AS dia01, |
||
| 3 | SUM(D.DIA02) AS dia02, |
||
| 4 | SUM(D.DIA03) AS dia03, |
||
| 5 | SUM(D.DIA04) AS dia04, |
||
| 6 | SUM(D.DIA05) AS dia05, |
||
| 7 | SUM(D.DIA06) AS dia06, |
||
| 8 | SUM(D.DIA07) AS dia07, |
||
| 9 | SUM(D.DIA08) AS dia08, |
||
| 10 | SUM(D.DIA09) AS dia09, |
||
| 11 | SUM(D.DIA10) AS dia10, |
||
| 12 | SUM(D.DIA11) AS dia11, |
||
| 13 | SUM(D.DIA12) AS dia12, |
||
| 14 | SUM(D.DIA13) AS dia13, |
||
| 15 | SUM(D.DIA14) AS dia14, |
||
| 16 | SUM(D.DIA15) AS dia15, |
||
| 17 | SUM(D.DIA16) AS dia16, |
||
| 18 | SUM(D.DIA17) AS dia17, |
||
| 19 | SUM(D.DIA18) AS dia18, |
||
| 20 | SUM(D.DIA19) AS dia19, |
||
| 21 | SUM(D.DIA20) AS dia20, |
||
| 22 | SUM(D.DIA21) AS dia21, |
||
| 23 | SUM(D.DIA22) AS dia22, |
||
| 24 | SUM(D.DIA23) AS dia23, |
||
| 25 | SUM(D.DIA24) AS dia24, |
||
| 26 | SUM(D.DIA25) AS dia25, |
||
| 27 | SUM(D.DIA26) AS dia26, |
||
| 28 | SUM(D.DIA27) AS dia27, |
||
| 29 | SUM(D.DIA28) AS dia28, |
||
| 30 | SUM(D.DIA29) AS dia29, |
||
| 31 | SUM(D.DIA30) AS dia30, |
||
| 32 | SUM(D.DIA31) AS dia31 |
||
| 33 | FROM |
||
| 34 | ( |
||
| 35 | SELECT |
||
| 36 | CASE DATE(v.dth_venda) WHEN '2015-01-01' THEN SUM(p.val_valor) END AS DIA01, |
||
| 37 | CASE DATE(v.dth_venda) WHEN '2015-01-02' THEN SUM(p.val_valor) END AS DIA02, |
||
| 38 | CASE DATE(v.dth_venda) WHEN '2015-01-03' THEN SUM(p.val_valor) END AS DIA03, |
||
| 39 | CASE DATE(v.dth_venda) WHEN '2015-01-04' THEN SUM(p.val_valor) END AS DIA04, |
||
| 40 | CASE DATE(v.dth_venda) WHEN '2015-01-05' THEN SUM(p.val_valor) END AS DIA05, |
||
| 41 | CASE DATE(v.dth_venda) WHEN '2015-01-06' THEN SUM(p.val_valor) END AS DIA06, |
||
| 42 | CASE DATE(v.dth_venda) WHEN '2015-01-07' THEN SUM(p.val_valor) END AS DIA07, |
||
| 43 | CASE DATE(v.dth_venda) WHEN '2015-01-08' THEN SUM(p.val_valor) END AS DIA08, |
||
| 44 | CASE DATE(v.dth_venda) WHEN '2015-01-09' THEN SUM(p.val_valor) END AS DIA09, |
||
| 45 | CASE DATE(v.dth_venda) WHEN '2015-01-10' THEN SUM(p.val_valor) END AS DIA10, |
||
| 46 | CASE DATE(v.dth_venda) WHEN '2015-01-11' THEN SUM(p.val_valor) END AS DIA11, |
||
| 47 | CASE DATE(v.dth_venda) WHEN '2015-01-12' THEN SUM(p.val_valor) END AS DIA12, |
||
| 48 | CASE DATE(v.dth_venda) WHEN '2015-01-13' THEN SUM(p.val_valor) END AS DIA13, |
||
| 49 | CASE DATE(v.dth_venda) WHEN '2015-01-14' THEN SUM(p.val_valor) END AS DIA14, |
||
| 50 | CASE DATE(v.dth_venda) WHEN '2015-01-15' THEN SUM(p.val_valor) END AS DIA15, |
||
| 51 | CASE DATE(v.dth_venda) WHEN '2015-01-16' THEN SUM(p.val_valor) END AS DIA16, |
||
| 52 | CASE DATE(v.dth_venda) WHEN '2015-01-17' THEN SUM(p.val_valor) END AS DIA17, |
||
| 53 | CASE DATE(v.dth_venda) WHEN '2015-01-18' THEN SUM(p.val_valor) END AS DIA18, |
||
| 54 | CASE DATE(v.dth_venda) WHEN '2015-01-19' THEN SUM(p.val_valor) END AS DIA19, |
||
| 55 | CASE DATE(v.dth_venda) WHEN '2015-01-20' THEN SUM(p.val_valor) END AS DIA20, |
||
| 56 | CASE DATE(v.dth_venda) WHEN '2015-01-21' THEN SUM(p.val_valor) END AS DIA21, |
||
| 57 | CASE DATE(v.dth_venda) WHEN '2015-01-22' THEN SUM(p.val_valor) END AS DIA22, |
||
| 58 | CASE DATE(v.dth_venda) WHEN '2015-01-23' THEN SUM(p.val_valor) END AS DIA23, |
||
| 59 | CASE DATE(v.dth_venda) WHEN '2015-01-24' THEN SUM(p.val_valor) END AS DIA24, |
||
| 60 | CASE DATE(v.dth_venda) WHEN '2015-01-25' THEN SUM(p.val_valor) END AS DIA25, |
||
| 61 | CASE DATE(v.dth_venda) WHEN '2015-01-26' THEN SUM(p.val_valor) END AS DIA26, |
||
| 62 | CASE DATE(v.dth_venda) WHEN '2015-01-27' THEN SUM(p.val_valor) END AS DIA27, |
||
| 63 | CASE DATE(v.dth_venda) WHEN '2015-01-28' THEN SUM(p.val_valor) END AS DIA28, |
||
| 64 | CASE DATE(v.dth_venda) WHEN '2015-01-29' THEN SUM(p.val_valor) END AS DIA29, |
||
| 65 | CASE DATE(v.dth_venda) WHEN '2015-01-30' THEN SUM(p.val_valor) END AS DIA30, |
||
| 66 | CASE DATE(v.dth_venda) WHEN '2015-01-31' THEN SUM(p.val_valor) END AS DIA31 |
||
| 67 | FROM sc_sec.sec_parcela p, sc_sec.sec_venda v, sc_sec.sec_conta_a_receber c |
||
| 68 | WHERE v.seq_venda = c.seq_venda AND p.seq_conta_a_receber = c.seq_conta_a_receber |
||
| 69 | GROUP BY DATE(v.dth_venda) |
||
| 70 | ) AS D |