//ReportID: 146
//TipeID: 11
//LastChanged: 13.10.2014 11:46:01
//Description: Stampa dokumenta ponude
//LinkRepID: 146
//BrojKolona: 0
//BrojRedova: 0
QRPonudaForm(TQuickRep)=qryStav&poPortrait@Default[2100x2970,99x61]Arial»8@10[]1#1{1}Stampa!|<frmDocPonuda.BeforePrint>\?/^0000/0&1@psSolid«
qryStav(TpFIBDataSet)=325[IBMastData.FIBDataBase]{110}
{
SELECT S.ROBAID, S.KOLICINA, S.NIVKOL as ISPORUCENO, 
               S.STAVKAID, S.PRODAJNACENA, S.NAZIV, S.RABAT, S.VRSTA,
               S.ZVEZDICA, S.DEVPRODCENA, 
               ROUND2(S.PRODAJNACENA * S.KOLICINA) as BezRabata,
               ROUND2(S.PRODAJNACENA * S.RABAT/100.00 * S.KOLICINA) as IznosRabata,
               ROUND2(ROUND2(S.PRODAJNACENA * (100.00 - S.RABAT)/100.00) * S.KOLICINA) as ProVrednost,
               ROUND2(S.DEVPRODCENA * S.KOLICINA) as BezRabataDev,
               ROUND2(S.DEVPRODCENA * S.RABAT/100.00 * S.KOLICINA) as IznosRabataDev,
               ROUND2(S.DEVPRODCENA * (100.00 - S.RABAT)/100.00 * S.KOLICINA) as ProVrednostDev,
              R.KATBR, R.KATBRPRO,  R.NAZIV AS NAZIVROBE,  R.JM
FROM STAVKA S left join ROBA R on  S.ROBAID = R.ROBAID 
WHERE S.VRDOK = :VRDOK AND
               S.BRDOK = :BRDOK
ORDER BY S.VRSTA, S.STAVKAID
}
qryDelovi(TpFIBDataSet)=326[IBMastData.FIBDataBase]{011}
{
SELECT SS.ROBAID, SS.KOLICINA, SS.NABAVNACENA, 
               SS.PRODAJNACENA, SS.ZVEZDICA,
               R.KATBR, R.KATBRPRO, R.NAZIV, R.JM
FROM SUBSTAV SS left join ROBA R on SS.ROBAID = R.ROBAID
WHERE SS.STAVKAID = :STAVKAID
ORDER BY SS.SUBSTAVID
}
QRStavke(TQRBand)=rbDetail[17]$16777215{000011}frmDocPonuda.QRStavkeAfterPrint!frmDocPonuda.QRStavkeBeforePrint^0000/0&1@psSolid«
PageFooterBand1(TQRBand)=rbPageFooter[18]$16777215{00001}!^0000/0&1@psSolid«
PageHeaderBand1(TQRBand)=rbPageHeader[125]$16777215{00001}!^0000/0&1@psSolid«
SummaryBand1(TQRBand)=rbSummary[120]$16777215{00001}!^0000/0&1@psSolid«
QRFooterVrsta(TQRBand)=rbGroupFooter[60]${00000}!^0000/0&1@psSolid«
QRPodStavke(TQRSubDetail)=,&QRPonudaForm@qryDelovi[20]$16777215{0000011}%!^0000/0&1@psSolid«
QRGroupVrsta(TQRGroup)=QRFooterVrsta[20]#qryStav.VRSTA${000000}!^0000/0&1@psSolid«
ChildBand(TQRChildBand)=QRStavke[16]${000011}!frmDocPonuda.ChildStavkaBeforePrint^0000/0&1@psSolid«
dbtKatBr(TQRDBText)=QRStavke@31,1[100x15]Arial»8@8[]1#taLeftJustify${00001}qryStav%KATBR!^0000/0&1@psSolid«
dbtNaziv(TQRDBText)=QRStavke@228,1[260x15]Arial»8@8[]1#taLeftJustify${01101}qryStav%NAZIVROBE!^0000/0&1@psSolid«
dbtKatBrPro(TQRDBText)=QRStavke@135,1[90x15]Arial»8@8[]1#taLeftJustify${00001}qryStav%KATBRPRO!^0000/0&1@psSolid«
dbtKolicina(TQRDBText)=QRStavke@587,1[35x15]Arial»8@8[]1#taRightJustify$###,###,##0.####{00101}qryStav%KOLICINA!^0000/0&1@psSolid«
expCount(TQRExpr)=QRStavke&QRPonudaForm@2,1[24x15]Arial»-2147483640@8[]1#taRightJustify$###{001001}COUNT!^0000/0&1@psSolid«
QRLabel1(TQRLabel)=QRStavke@26,1[4x15]Arial»-2147483640@8[]1#taLeftJustify${00101}.!^0000/0&1@psSolid«
dbtCena(TQRDBText)=QRStavke@489,1[62x15]Arial»8@8[]1#taRightJustify$###,###,##0.00##{00101}qryStav%PRODAJNACENA!^0000/0&1@psSolid«
dbtZvezdica(TQRDBText)=QRStavke@708,1[24x15]Arial»8@8[]1#taCenter${00101}qryStav%ZVEZDICA!^0000/0&1@psSolid«
sysPage(TQRSysData)=PageFooterBand1@659,1[71x15]Arial»-2147483640@8[]1#taLeftJustify$Strana {10001}qrsPageNumber!^0000/0&1@psSolid«
sysVreme(TQRSysData)=PageFooterBand1@4,2[72x15]Arial»-2147483640@8[]1#taLeftJustify$Vreme : {10001}qrsTime!^0000/0&1@psSolid«
dbtFirma(TQRDBText)=PageHeaderBand1@6,3[48x20]Arial»-2147483640@12[fsBold]1#taLeftJustify${10101}IBMastData.Firma%NAZIV!^0000/&@«
lblNaslov(TQRLabel)=PageHeaderBand1@211,77[78x19]Arial»-2147483640@11[fsBold]1#taRightJustify${10101}Ponuda br:!^0000/0&1@psSolid«
LinijaHeader(TQRShape)=PageHeaderBand1@2,120[726x2]#$qrsHorLine{00011}!^0000/0&1@psSolid«
lblKatBroj(TQRLabel)=PageHeaderBand1@32,102[81x18]Arial»-2147483640@10[]1#taLeftJustify${00101}Kataloski broj!^0000/0&1@psSolid«
lblKolicina(TQRLabel)=PageHeaderBand1@590,102[28x18]Arial»8@10[]1#taRightJustify${00101}Kol.!^0000/0&1@psSolid«
dbtPartner(TQRDBText)=PageHeaderBand1@480,4[246x19]Arial»-2147483640@11[fsBold]1#taRightJustify${00101}frmDocPonuda.qryPP%NAZIV!^0000/&@«
lblOd(TQRLabel)=PageHeaderBand1@440,77[26x19]Arial»-2147483640@11[fsBold]1#taRightJustify${00101}od:!^0000/0&1@psSolid«
dbtBrDok(TQRDBText)=PageHeaderBand1@294,77[67x19]Arial»-2147483640@11[fsBold]1#taLeftJustify${00101}frmDocPonuda.qryDokument%BRDOK!QRF.QRDocBrDokPrint^0000/&@«
dbtDatum(TQRDBText)=PageHeaderBand1@470,77[75x19]Arial»-2147483640@11[fsBold]1#taLeftJustify${00101}frmDocPonuda.qryDokument%DATUM!^0000/&@«
lblRBr(TQRLabel)=PageHeaderBand1@6,102[18x18]Arial»-2147483640@10[]1#taCenter${00101}#!^0000/0&1@psSolid«
dbtAdresa(TQRDBText)=PageHeaderBand1@6,24[61x19]Arial»-2147483640@11[fsBold]1#taLeftJustify${10101}IBMastData.Firma%ADRESA!^0000/&@«
dbtTelefon(TQRDBText)=PageHeaderBand1@6,43[60x17]Arial»-2147483640@10[fsBold]1#taLeftJustify${10101}IBMastData.Firma%TELEFON!^0000/&@«
dbtEmail(TQRDBText)=PageHeaderBand1@6,61[41x17]Arial»-2147483640@10[fsBold]1#taLeftJustify${10101}IBMastData.Firma%EMAIL!^0000/0&1@psSolid«
lblNaziv(TQRLabel)=PageHeaderBand1@228,102[65x18]Arial»8@10[]1#taLeftJustify${00101}Naziv!^0000/0&1@psSolid«
lblCena(TQRLabel)=PageHeaderBand1@487,102[62x18]Arial»8@10[]1#taRightJustify${00101}Prod.cena!^0000/0&1@psSolid«
imgLogo(TQRImage)=PageHeaderBand1@200,0[274x76]#${01111}!^0000/0&1@psSolid«
dbtIntBroj(TQRDBText)=PageHeaderBand1@365,79[71x15]Arial»-2147483640@8[fsItalic]0#taRightJustify${00101}frmDocPonuda.qryDokument%INTBROJ!QRF.QRDocIntBrojPrint^0000/&@«
lblKatBrPro(TQRLabel)=PageHeaderBand1@135,102[81x18]Arial»8@10[]1#taLeftJustify${00101}Kat. broj proizv.!^0000/0&1@psSolid«
dbtAdresaKupca(TQRDBText)=PageHeaderBand1@480,23[246x19]Arial»8@10[fsBold]1#taRightJustify${00101}frmDocPonuda.qryPP%ADRESA!^0000/0&1@psSolid«
dbtMestoKupca(TQRDBText)=PageHeaderBand1@504,42[222x19]Arial»-2147483640@10[fsBold]1#taRightJustify${00101}frmDocPonuda.qryPP%MESTOID!frmDocPonuda.dbtMestoKupcaPrint^0000/&@«
lblKomentar(TQRLabel)=SummaryBand1@8,75[47x15]Arial»8@8[]1#taLeftJustify${10101}Komentar!QRF.QRDoclblKomentarPrint^0000/0&1@psSolid«
memKomentar(TQRMemo)=SummaryBand1@8,92[355x25]Arial»8@8[]1#taLeftJustify${01101}!^0000/0&1@psSolid«
dbtNapomena(TQRDBText)=SummaryBand1@6,55[722x17]Arial»8@10[]1#taLeftJustify${00101}%KUPAC!^0000/0&1@psSolid«
lblProdVred(TQRLabel)=SummaryBand1@479,36[116x15]Arial»8@10[]1#taLeftJustify${10101}Uk.prodajna vrednost:!^0000/0&1@psSolid«
LinijaFooter(TQRShape)=SummaryBand1@3,0[728x3]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
dbtPotrazuje(TQRDBText)=SummaryBand1@601,36[105x15]Arial»8@10[fsBold]1#taRightJustify${00101}frmDocPonuda.qryDokument%DODPOREZ!^0000/0&1@psSolid«
dbtRobaID(TQRDBText)=QRPodStavke@60,0[145x15]Arial»8@8[]1#taLeftJustify${00101}qryDelovi%ROBAID!frmDocPonuda.dbtRobaIDPrint^0000/0&1@psSolid«
dbtNazivDela(TQRDBText)=QRPodStavke@207,0[325x15]Arial»8@8[]1#taLeftJustify${00101}qryDelovi%NAZIV!^0000/0&1@psSolid«
dbtKolDela(TQRDBText)=QRPodStavke@563,0[28x15]Arial»8@8[]1#taRightJustify${00101}qryDelovi%KOLICINA!^0000/0&1@psSolid«
dbtJM(TQRDBText)=QRPodStavke@533,0[27x15]Arial»8@8[]1#taLeftJustify${00101}qryDelovi%JM!^0000/0&1@psSolid«
LinijicaHor(TQRShape)=QRPodStavke@26,7[28x1]#$qrsHorLine{00011}!^0000/0&1@psSolid«
LinijicaVert(TQRShape)=QRPodStavke@25,0[1x8]#$qrsVertLine{00011}!^0000/0&1@psSolid«
dbtZvezdicaDela(TQRDBText)=QRPodStavke@595,0[22x15]Arial»8@8[]1#taLeftJustify${00101}qryDelovi%ZVEZDICA!^0000/0&1@psSolid«
dbtRabat(TQRDBText)=QRStavke@555,1[30x15]Arial»8@8[]1#taRightJustify$##0.##%{00101}qryStav%RABAT!^0000/0&1@psSolid«
lblRabat(TQRLabel)=PageHeaderBand1@551,102[36x18]Arial»8@10[]1#taRightJustify${00101}Rabat!^0000/0&1@psSolid«
lblIznosRabata(TQRLabel)=SummaryBand1@479,20[116x15]Arial»8@10[]1#taLeftJustify${10101}Iznos rabata:!^0000/0&1@psSolid«
lblBezRabata(TQRLabel)=SummaryBand1@479,4[116x15]Arial»8@10[]1#taLeftJustify${10101}Vrednost:!^0000/0&1@psSolid«
expIznosRabata(TQRExpr)=SummaryBand1&QRPonudaForm@601,20[105x15]Arial»@10[fsBold]#taRightJustify$###,###,##0.00{000111}SUM(qryStav.IznosRabataDev)!^0000/0&1@psSolid«
expBezRabata(TQRExpr)=SummaryBand1&QRPonudaForm@601,4[105x15]Arial»@10[fsBold]#taRightJustify$###,###,##0.00{000111}SUM(qryStav.BezRabataDev)!^0000/0&1@psSolid«
dbtRobaUsluga(TQRDBText)=QRGroupVrsta@7,1[82x17]#taLeftJustify${00101}qryStav%VRSTA!QRFFaktura.FakturadbtRobaUslugaPrint^0000/0&1@psSolid«
lblBezRabata1(TQRLabel)=QRFooterVrsta@479,4[112x15]Arial»8@8[]1#taLeftJustify${10101}Vrednost:!^0000/0&1@psSolid«
lblIznosRabata1(TQRLabel)=QRFooterVrsta@479,20[112x15]Arial»8@8[]1#taLeftJustify${10101}Iznos rabata:!^0000/0&1@psSolid«
lblProdVred1(TQRLabel)=QRFooterVrsta@479,36[112x15]Arial»8@8[]1#taLeftJustify${10101}Uk.prodajna vrednost:!^0000/0&1@psSolid«
expBezRabata1(TQRExpr)=QRFooterVrsta&QRPonudaForm@601,4[105x15]Arial»@8[fsBold]#taRightJustify$###,###,##0.00{000111}SUM(qryStav.BezRabataDev)!^0000/0&1@psSolid«
expIznosRabata1(TQRExpr)=QRFooterVrsta&QRPonudaForm@601,20[105x15]Arial»@8[fsBold]#taRightJustify$###,###,##0.00{000111}SUM(qryStav.IznosRabataDev)!^0000/0&1@psSolid«
LinijaFooter1(TQRShape)=QRFooterVrsta@230,1[500x3]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
lblUkupnoGrupa(TQRLabel)=QRFooterVrsta@364,4[110x15]Arial»8@8[]1#taRightJustify${00101}Ukupno za grupu:!^0000/0&1@psSolid«
lblUkupno(TQRLabel)=SummaryBand1@364,4[110x15]Arial»8@10[]1#taRightJustify${00101}Ukupno:!^0000/0&1@psSolid«
expUkupnoGrupa(TQRExpr)=QRFooterVrsta&QRPonudaForm@601,36[105x15]Arial»@8[fsBold]#taRightJustify$###,###,##0.00{000111}SUM(qryStav.ProVrednostDev)!^0000/0&1@psSolid«
dbtVrednost(TQRDBText)=QRStavke@624,1[82x15]Arial»8@8[]1#taRightJustify$###,###,##0.00##{00101}qryStav%ProVrednost!^0000/0&1@psSolid«
lblVrednost(TQRLabel)=PageHeaderBand1@624,102[82x18]Arial»8@10[]1#taRightJustify${00101}Vrednost!^0000/0&1@psSolid«
lblIntKomentar(TQRLabel)=SummaryBand1@370,75[50x15]Arial»8@8[]1#taLeftJustify${10101}Komentar!QRF.QRDoclblIntKomentarPrint^0000/0&1@psSolid«
memIntKomentar(TQRMemo)=SummaryBand1@370,92[355x25]Arial»8@8[]1#taLeftJustify${01101}!^0000/0&1@psSolid«
lblSlovimaNaslov(TQRLabel)=SummaryBand1@9,15[41x17]Arial»8@8[]1#taLeftJustify${10111}Slovima:!^0000/0&1@psSolid«
lblSlovima(TQRLabel)=SummaryBand1@9,35[330x17]Arial»8@8[]1#taLeftJustify${01111}Slovima!^0000/0&1@psSolid«
memOperacije(TQRMemo)=ChildBand@60,0[300x14]Arial»@8[]#taLeftJustify${01011}!^0000/0&1@psSolid«