//ReportID: 678
//TipeID: 11
//LastChanged: 12.01.2016 15:01:48
//Description: Stampa dokumenta: Otpremnica
//LinkRepID: 222
//BrojKolona: 0
//BrojRedova: 0
QRExpKarticaKupca(TQuickRep)=qryStavka&poLandscape@Default[2970x2100,100x60,100x100]Arial»8@10[]238#1{1}Otpremnica!|<>\?/^0000/0&1@psSolid«
qryStavka(TpFIBDataSet)=622[IBMastData.FIBDataBase]{110}
{
select d.datum, p.ppid, p.naziv as kupac, p.kontakt, p.sdel, m.naziv as Mesto,
          d.brdok, d.duguje, d.potrazuje, d.porez, d.uplaceno, d.duguje - d.uplaceno as Razlika,
          case when d.duguje - d.uplaceno > 0 then '-' else '+' end as PlusRazlika,
         case when popust1dana = 1 then '+' else '-' end as PlusPopust,
         'Komitent: ' || p.naziv || ', ' || m.naziv as NazivIMesto
from dokument d
   left join partner p on d.ppid = p.ppid
   left join mesta m on p.mestoid = m.mestoid
where d.vrdok = 13 and d.ppid = :PPID and d.datum >= :DATUM_OD and d.datum <= :DATUM_DO
union
select cast(i.datum as date) as datum, p.ppid, p.naziv as kupac, p.kontakt, p.sdel, m.naziv as Mesto,
          i.brdok || '/' || extract(year from i.datum) as brdok, -i. iznos as duguje, 0.00 as potrazuje, 0.00 as porez,
          case when pps.ps_ulaz is null then 0 else pps.ps_ulaz end as uplaceno,
          case when pps.ps_ulaz is null then -i.iznos else -i.iznos - pps.ps_ulaz end as Razlika,
          case when pps.ps_ulaz is null then '-' else case when -i.iznos - pps.ps_ulaz > 0 then '-' else '+' end end as PlusRazlika,
         case when poc_staid = 1 then '+' else '-' end as PlusPopust,
         'Komitent: ' || p.naziv || ', ' || m.naziv as NazivIMesto
from istupl i
   left join ISTUPL_PS_POV_KOZ(i.ppid, i.vrdok, i.brdok, i.io, i.mtid) pps on 1 = 1
   left join partner p on i.ppid = p.ppid
   left join mesta m on p.mestoid = m.mestoid
where i.a = -1 and i.ppid = :PPID
order by 1
}
GroupFooterBand1(TQRBand)=rbSummary[50]»0@[]238$16777215{000011}!^0000/0&1@psSolid«
Zaglavlje(TQRBand)=rbPageHeader[100]»0@[]238$16777215{000011}!^0000/0&1@psSolid«
DetailBand(TQRBand)=rbDetail[20]238${000011}!^0000/0&1@psSolid«
dbtNaziv(TQRDBText)=DetailBand@99,4[247x14]Arial»8@8[fsBold]238#taLeftJustify${01101}qryStavka%KUPAC!^0000/0&1@psSolid«
dbtVPVrednost(TQRDBText)=DetailBand@539,4[90x14]Arial»8@8[]238#taRightJustify$###,###,##0.00{00101}qryStavka%POTRAZUJE!^0000/0&1@psSolid«
dbtBRDOK(TQRDBText)=DetailBand@470,4[66x14]Arial»8@8[]238#taLeftJustify${00101}qryStavka%BRDOK!^0000/0&1@psSolid«
dbtSDEL(TQRDBText)=DetailBand@46,4[49x14]Arial»8@8[]238#taLeftJustify${00101}qryStavka%SDEL!^0000/0&1@psSolid«
LinijaHeader1(TQRShape)=GroupFooterBand1@2,1[1050x3]&1@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
dbtPDV(TQRDBText)=DetailBand@631,4[90x14]Arial»8@8[]238#taRightJustify$###,###,##0.00{00101}qryStavka%POREZ!^0000/0&1@psSolid«
dbtRazlika(TQRDBText)=DetailBand@906,4[90x14]Arial»8@8[]238#taRightJustify$###,###,##0.00{00101}qryStavka%RAZLIKA!^0000/0&1@psSolid«
LinijaHeader11(TQRShape)=DetailBand@2,0[1050x3]&1@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
expUkVrednost(TQRExpr)=GroupFooterBand1&QRExpKarticaKupca@906,5[90x16]Arial»@8[fsBold]#taRightJustify$###,###,##0.00{000111}SUM(qryStavka.RAZLIKA)!^0000/0&1@psSolid«
lblNaslov(TQRLabel)=Zaglavlje@835,2[211x17]Arial»0@12[fsBold]238#taRightJustify${00101}DNEVNIK KNJIŽENJA!^0000/0&1@psSolid«
dbtFirma(TQRDBText)=Zaglavlje@3,2[269x23]Arial Black»0@13[fsBold]238#taLeftJustify${00101}IBMastData.Firma%NAZIV!^0000/&@«
dbtAdresa(TQRDBText)=Zaglavlje@4,26[301x17]Arial»0@10[]238#taLeftJustify${00101}IBMastData.Firma%ADRESA!^0000/0&1@psSolid«
lblPeriod(TQRLabel)=Zaglavlje@786,20[260x15]Arial»0@10[]238#taRightJustify${00101}Period!frmDEExpEvidUplata.lblPeriodPrint^0000/0&1@psSolid«
dbtNazivIMesto(TQRDBText)=Zaglavlje@786,35[260x17]Arial»0@10[]238#taRightJustify${00011}qryStavka%NAZIVIMESTO!^0000/0&1@psSolid«
lblRbr(TQRLabel)=Zaglavlje@8,80[29x17]Arial»8@10[]238#taLeftJustify${00101}R.br!^0000/0&1@psSolid«
lblKomitent(TQRLabel)=Zaglavlje@46,80[150x17]Arial»8@10[]238#taRightJustify${10101}KOMITENT!^0000/0&1@psSolid«
lblKatBr(TQRLabel)=Zaglavlje@348,80[77x17]Arial»8@10[]238#taLeftJustify${10101}MESTO!^0000/0&1@psSolid«
lblBrDok(TQRLabel)=Zaglavlje@470,80[66x17]Arial»8@10[]238#taLeftJustify${00101}BR.RAC!^0000/0&1@psSolid«
lblPDV(TQRLabel)=Zaglavlje@631,80[90x17]Arial»8@8[]238#taRightJustify${00101}PDV!^0000/0&1@psSolid«
lblMPVrednost(TQRLabel)=Zaglavlje@722,80[90x17]Arial»8@8[]238#taRightJustify${00101}MP VREDNOST!^0000/0&1@psSolid«
lblPlaceno(TQRLabel)=Zaglavlje@813,80[90x17]Arial»8@8[]238#taRightJustify${00101}PLACENO!^0000/0&1@psSolid«
lblRazlika(TQRLabel)=Zaglavlje@906,80[90x17]Arial»8@8[]238#taRightJustify${00101}RAZLIKA!^0000/0&1@psSolid«
New_TQRExpr1(TQRExpr)=DetailBand&QRSubDetail@6,4[30x14]Arial»@8[]#taRightJustify${000101}COUNT!^0000/0&1@psSolid«
lblTacka1(TQRLabel)=DetailBand@37,4[4x14]Arial»8@8[]238#taLeftJustify${00101}.!^0000/0&1@psSolid«
lblVPVrednost(TQRLabel)=Zaglavlje@539,80[90x17]Arial»8@8[]238#taRightJustify${00101}VP VREDNOST!^0000/0&1@psSolid«
dbtJM1(TQRDBText)=DetailBand@1002,4[20x14]Arial»8@10[]238#taCenter${00101}qryStavka%PlusRazlika!^0000/0&1@psSolid«
dbtJM11(TQRDBText)=DetailBand@1026,4[20x13]Arial»8@10[]238#taCenter${00101}qryStavka%PlusPopust!^0000/0&1@psSolid«
dbtPlaceno(TQRDBText)=DetailBand@813,4[90x14]Arial»8@8[]238#taRightJustify$###,###,##0.00{00101}qryStavka%UPLACENO!^0000/0&1@psSolid«
dbtMPVrednost(TQRDBText)=DetailBand@722,4[90x14]Arial»8@8[]238#taRightJustify$###,###,##0.00{00101}qryStavka%DUGUJE!^0000/0&1@psSolid«
dbtMesto(TQRDBText)=DetailBand@348,4[121x14]Arial»8@8[]238#taLeftJustify${00101}qryStavka%MESTO!^0000/0&1@psSolid«
expUkVrednost1(TQRExpr)=GroupFooterBand1&QRExpKarticaKupca@813,5[90x16]Arial»@8[fsBold]#taRightJustify$###,###,##0.00{000111}SUM(qryStavka.UPLACENO)!^0000/0&1@psSolid«
expUkVrednost2(TQRExpr)=GroupFooterBand1&QRExpKarticaKupca@722,5[90x16]Arial»@8[fsBold]#taRightJustify$###,###,##0.00{000111}SUM(qryStavka.DUGUJE)!^0000/0&1@psSolid«
expUkVrednost3(TQRExpr)=GroupFooterBand1&QRExpKarticaKupca@631,5[90x16]Arial»@8[fsBold]#taRightJustify$###,###,##0.00{000111}SUM(qryStavka.POREZ)!^0000/0&1@psSolid«
expUkVrednost4(TQRExpr)=GroupFooterBand1&QRExpKarticaKupca@539,5[90x16]Arial»@8[fsBold]#taRightJustify$###,###,##0.00{000111}SUM(qryStavka.POTRAZUJE)!^0000/0&1@psSolid«
dbtAdresa1(TQRDBText)=Zaglavlje@4,44[301x17]Arial»0@10[]238#taLeftJustify${00101}IBMastData.Firma%NAZIV2!^0000/0&1@psSolid«
lblNeplaceni(TQRLabel)=Zaglavlje@786,53[260x16]Arial»0@10[]238#taRightJustify${00100}SAMO NEPLAĆENI!^0000/0&1@psSolid«