//ReportID: 142
//TipeID: 1
//LastChanged: 17.07.2017 10:32:29
//Description: Stampa naloga za pakovanje
//LinkRepID: 142
//BrojKolona: 0
//BrojRedova: 0
QROdsecnica(TQuickRep)=QRFFaktura.RxNalogPak&poPortrait@Default[2100x2970,100x60,100x100]Arial»8@10[]1#1{0}!QRF.QRNalogZaPakovanjeAfterPrint|<QRFFaktura.OdsecnicaBeforePrint>\?/^0000/0&1@psSolid«
qryStavka(TpFIBDataSet)=318[IBMastData.FIBDatabase]{010}
{
SELECT S.VRDOK, S.BRDOK, S.VRSTA, S.ROBAID, S.MAGACINID, R.KATBR, R.KATBRPRO, R.PROID, R.JM,  R.TRPAK, R.TRKOL, R.TRDECPAK, R.ALTJM, R.ALTKOL, R.ALTNEDELJIVA,  R.NAZIV as ROBANAZIV, R.NAZIVZASTAMPU,
              SUM(S.KOLICINA) AS KOLICINA, S.NAZIV,
              AVG(S.PRODAJNACENA) AS PRODAJNACENA,
              AVG(S.POREZ) AS POREZ, 
              AVG(S.RABAT) AS RABAT, S.ZVEZDICA,
             SUM(ROUNDDEC(R.X3*R.Y3*R.Z3/1000000, 6) * PG.TEZINA) AS TEZINA_STAVKE
FROM STAVKA S left join ROBA R on S.ROBAID = R.ROBAID
LEFT JOIN PODGRUPA PG ON R.GRUPAID = PG.GRUPAID AND R.PODGRUPA = PG.PODGRUPAID
WHERE S.VRDOK = :VRDOK AND S.BRDOK = :BRDOK AND S.VRSTA IN (1, 3)
GROUP BY S.VRDOK, S.BRDOK, S.VRSTA, S.ROBAID, S.MAGACINID, R.KATBR, R.KATBRPRO, R.PROID, R.JM, R.TRPAK, R.TRKOL, R.TRDECPAK, R.ALTJM, R.ALTKOL, R.ALTNEDELJIVA, R.NAZIVZASTAMPU,R.NAZIV, S.NAZIV, S.ZVEZDICA
ORDER BY S.NAZIV
}
qryStavRok(TpFIBDataSet)=319[IBMastData.FIBDatabase]{011}
{
SELECT DATUM, SERIJA, ROUNDDEC(SUM(KOLICINA), 3)  AS STANJE
FROM STAVROK
WHERE ROBAID = :ROBAID AND 
               VRDOK = :VRDOK AND BRDOK = :BRDOK
GROUP BY DATUM, SERIJA
ORDER BY DATUM, SERIJA
}
qryDokument(TpFIBDataSet)=320[IBMastData.FIBDatabase]{010}
{
SELECT D.*, V.NAZIVDOK, M.NAZIV as MAGNAZIV
FROM DOKUMENT D LEFT JOIN VRSTADOK V ON D.VRDOK = 
V.VRDOK
                                     LEFT JOIN MAGACIN M ON D.MAGACINID = M.MAGACINID
WHERE D.VRDOK = :VRDOK AND D.BRDOK = :BRDOK
}
qryPP(TpFIBDataSet)=321[IBMastData.FIBDatabase]{010}
{
select PP.NAZIV, PP.ADRESA, PP.POSTA, M.NAZIV as MESTONAZIV
from PARTNER PP left join MESTA M on PP.MESTOID = M.MESTOID
where PP.PPID = :PPID
}
qryDodatni(TpFIBDataSet)=322[IBMastData.FIBDatabase]{010}
{
SELECT RR.ROBAID, 
               R.KATBR, R.KATBRPRO, R.NAZIV, R.JM, R.PROID,
               R.TRPAK, R.TRKOL, R.TRDECPAK, R.ALTJM, R.ALTKOL, 
               R.ALTNEDELJIVA, R.NAZIVZASTAMPU,
               RR.KOLICINA
FROM ROBA_ROBA RR LEFT JOIN ROBA R ON RR.ROBAID = R.ROBAID
WHERE RR.LROBAID = :LROBAID
ORDER BY R.NAZIV
}
qryPozicije(TpFIBDataSet)=467[IBMastData.FIBDatabase]{010}
{
SELECT G.*, P.NAZIV as POZICIJANAZIV
FROM GDEUMAGACINU G left join POZICIJA P on G.MAGACINID = P.MAGACINID and G.POZICIJA = P.POZICIJAID
WHERE G.ROBAID = :ROBAID AND G.MAGACINID = :MAGACINID
ORDER BY G.MAGACINID, G.POZICIJA
}
DetailBand1(TQRBand)=rbDetail[18]$16777215{000011}!QRFFaktura.OdsecnicaDetailBand1BeforePrint^0000/0&1@psSolid«
GroupFooterBand1(TQRBand)=rbSummary[150]$16777215{00001}!^0000/0&1@psSolid«
GroupHeaderBand1(TQRBand)=rbTitle[32]$16777215{000011}!^0000/0&1@psSolid«
PageHeaderBand1(TQRBand)=rbPageHeader[175]$16777215{00001}!^0000/0&1@psSolid«
QRSubDetail1(TQRSubDetail)=,&QROdsecnica@qryStavRok[16]$16777215{0000001}%!QRFFaktura.OdsecnicaQRSubDetail1BeforePrint^0000/0&1@psSolid«
ChildBand(TQRChildBand)=DetailBand1[16]${000001}!QRFFaktura.OdsecnicaChildBandBeforePrint^0000/0&1@psSolid«
LinijaRokVert(TQRShape)=QRSubDetail1@458,2[4x9]#$qrsVertLine{00011}!^0000/0&1@psSolid«
LinijaRokHor(TQRShape)=QRSubDetail1@459,8[10x4]#$qrsHorLine{00011}!^0000/0&1@psSolid«
dbtStanje(TQRDBText)=QRSubDetail1@474,1[62x14]Arial»8@8[]238#taRightJustify$###,###,##0.####{00101}qryStavRok%STANJE!^0000/0&1@psSolid«
dbtDatumRoka(TQRDBText)=QRSubDetail1@545,1[62x14]Arial»8@8[]1#taLeftJustify$dd.mm.yyyy{00101}qryStavRok%DATUM!^0000/0&1@psSolid«
lblTacka(TQRLabel)=DetailBand1@31,2[4x14]Arial»-2147483640@8[]1#taLeftJustify${00101}.!^0000/0&1@psSolid«
dbtNaziv(TQRDBText)=DetailBand1@113,2[272x14]Arial»8@8[]238#taLeftJustify${00101}QRFFaktura.RxNalogPak%NAZIV!^0000/0&1@psSolid«
dbtProizvodjac(TQRDBText)=DetailBand1@388,2[31x14]Arial»8@8[]238#taLeftJustify${00101}QRFFaktura.RxNalogPak%PROID!^0000/0&1@psSolid«
dbtKolicina(TQRDBText)=DetailBand1@422,2[55x14]Arial»8@8[]238#taRightJustify$###,###,##0.####{00101}QRFFaktura.RxNalogPak%KOLICINA!^0000/0&1@psSolid«
dbtJM(TQRDBText)=DetailBand1@482,2[32x14]Arial»8@8[]238#taLeftJustify${00101}QRFFaktura.RxNalogPak%JM!^0000/0&1@psSolid«
dbtCena(TQRDBText)=DetailBand1@518,2[93x14]Arial»8@8[]238#taRightJustify$###,###,##0.00{00101}QRFFaktura.RxNalogPak%PRODAJNACENA!QRFFaktura.OdsecnicadbtCenaPrint^0000/0&1@psSolid«
dbtIznos(TQRDBText)=DetailBand1@613,2[92x14]Arial»8@8[]238#taRightJustify$###,###,##0.00{00101}QRFFaktura.RxNalogPak%IZNOS!QRFFaktura.OdsecnicadbtIznosPrint^0000/0&1@psSolid«
dbtZvezdica(TQRDBText)=DetailBand1@708,2[22x14]Arial»8@8[]1#taCenter${00001}QRFFaktura.RxNalogPak%ZVEZDICA!^0000/0&1@psSolid«
sysRBr(TQRSysData)=DetailBand1@2,0[27x17]#taRightJustify${00001}qrsDetailNo!^0000/0&1@psSolid«
dbtKatBroj(TQRDBText)=DetailBand1@38,2[73x14]Arial»8@8[]238#taLeftJustify${00101}QRFFaktura.RxNalogPak%KATBR!^0000/0&1@psSolid«
LinijaUkupno(TQRShape)=GroupFooterBand1@2,2[728x5]&2@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
lblUkupno(TQRLabel)=GroupFooterBand1@507,13[68x17]Arial»0@10[fsBold]238#taLeftJustify${00101}UKUPNO : !^0000/0&1@psSolid«
expUkupno(TQRExpr)=GroupFooterBand1&GroupFooterBand1@588,12[120x17]Arial»0@10[fsBold]238#taRightJustify$###,###,##0.00{001011}!QRFFaktura.OdsecnicaexpUkupnoPrint^0000/0&1@psSolid«
lblKomentar(TQRLabel)=GroupFooterBand1@2,29[56x17]Arial»8@8[]238#taLeftJustify${10101}Komentar : !QRF.QRDoclblKomentarPrint^0000/0&1@psSolid«
LinijaFooter(TQRShape)=GroupFooterBand1@4,115[722x8]#$qrsHorLine{00011}!^0000/0&1@psSolid«
lblPripremio(TQRLabel)=GroupFooterBand1@19,130[88x16]Arial»-2147483640@8[]238#taLeftJustify${00101}Robu pripremio:!^0000/0&1@psSolid«
lblKontrolisao(TQRLabel)=GroupFooterBand1@259,130[88x16]Arial»-2147483640@8[]238#taLeftJustify${00101}Robu kontrolisao:!^0000/0&1@psSolid«
lblIzdao(TQRLabel)=GroupFooterBand1@501,130[68x16]Arial»-2147483640@8[]238#taLeftJustify${00101}Robu izdao:!^0000/0&1@psSolid«
memKomentar(TQRMemo)=GroupFooterBand1@4,48[718x61]Arial»-2147483640@8[]1#taLeftJustify${00101}!^0000/0&1@psSolid«
LinijaHeader(TQRShape)=GroupHeaderBand1@2,24[728x7]&2@#$qrsHorLine{00011}!^0000/0&1@psSolid«
lblKatBroj(TQRLabel)=GroupHeaderBand1@41,8[71x17]Arial»-2147483640@8[]238#taLeftJustify${00101}Kataloski broj!^0000/0&1@psSolid«
lblNaziv(TQRLabel)=GroupHeaderBand1@114,8[272x17]Arial»-2147483640@8[]238#taLeftJustify${00101}Naziv artikla!^0000/0&1@psSolid«
lblKolicina(TQRLabel)=GroupHeaderBand1@428,8[48x17]Arial»8@8[]238#taRightJustify${00101}Kolicina!^0000/0&1@psSolid«
lblJM(TQRLabel)=GroupHeaderBand1@482,8[14x17]Arial»8@8[]238#taLeftJustify${10101}JM!^0000/0&1@psSolid«
lblRBr(TQRLabel)=GroupHeaderBand1@3,8[31x17]Arial»-2147483640@8[]238#taLeftJustify${00101}R.br!^0000/0&1@psSolid«
lblCena(TQRLabel)=GroupHeaderBand1@538,8[72x17]Arial»-2147483640@8[]238#taRightJustify${00101}Cena!^0000/0&1@psSolid«
lblIznos(TQRLabel)=GroupHeaderBand1@638,8[70x17]Arial»-2147483640@8[]238#taRightJustify${00101}Iznos!^0000/0&1@psSolid«
lblProizv(TQRLabel)=GroupHeaderBand1@389,8[31x17]Arial»-2147483640@8[]238#taLeftJustify${00101}Proizv.!^0000/0&1@psSolid«
LinijaZgalavlje(TQRShape)=PageHeaderBand1@2,73[727x5]&2@#$qrsHorLine{00011}!^0000/0&1@psSolid«
dbtReferent(TQRDBText)=PageHeaderBand1@129,51[39x17]Arial»8@10[]238#taLeftJustify${10101}qryDokument%REFID!QRFFaktura.OdsecnicadbtReferentPrint^0000/0&1@psSolid«
lblDatumStampe(TQRLabel)=PageHeaderBand1@4,10[43x17]Arial»8@10[]238#taLeftJustify${10101}Datum:!^0000/0&1@psSolid«
lblVremeStampe(TQRLabel)=PageHeaderBand1@4,28[43x17]Arial»-2147483640@10[]238#taLeftJustify${10101}Vreme:!^0000/0&1@psSolid«
lblReferent(TQRLabel)=PageHeaderBand1@4,50[57x18]Arial»-2147483640@10[]238#taLeftJustify${10101}Referent :!^0000/0&1@psSolid«
sysDatumStampe(TQRSysData)=PageHeaderBand1@67,10[36x17]Arial»-2147483640@10[]238#taLeftJustify${10001}qrsDate!^0000/0&1@psSolid«
sysVremeStampe(TQRSysData)=PageHeaderBand1@67,28[37x17]Arial»-2147483640@10[]238#taLeftJustify${10001}qrsTime!^0000/0&1@psSolid«
dbtRefID(TQRDBText)=PageHeaderBand1@76,51[39x17]Arial»8@10[]238#taLeftJustify${10101}qryDokument%REFID!^0000/0&1@psSolid«
lblDatum(TQRLabel)=PageHeaderBand1@5,86[46x18]Arial»0@10[]238#taLeftJustify${00101}Datum:!^0000/0&1@psSolid«
dbtDatum(TQRDBText)=PageHeaderBand1@65,86[86x18]Arial»0@10[]238#taLeftJustify${00101}qryDokument%DATUM!^0000/0&1@psSolid«
lblNaslov(TQRLabel)=PageHeaderBand1@2,128[275x24]Arial»0@13[fsBold]238#taRightJustify${00101}Nalog za pakovanje br.!^0000/0&1@psSolid«
dbtBrDok(TQRDBText)=PageHeaderBand1@283,130[72x21]Arial»0@13[]238#taLeftJustify${00101}qryDokument%BRDOK!^0000/0&1@psSolid«
dbtPPID(TQRDBText)=PageHeaderBand1@365,130[65x21]Arial»0@13[]238#taRightJustify${00101}qryDokument%PPID!^0000/0&1@psSolid«
LinijaKupac(TQRShape)=PageHeaderBand1@436,87[4x62]#$qrsVertLine{00011}!^0000/0&1@psSolid«
dbtKupac(TQRDBText)=PageHeaderBand1@443,89[284x18]Arial»0@10[]238#taLeftJustify${00101}Caller.qryPP%NAZIV!^0000/0&1@psSolid«
dbtAdresa(TQRDBText)=PageHeaderBand1@443,109[284x18]Arial»0@10[]238#taLeftJustify${00101}qryPP%ADRESA!^0000/0&1@psSolid«
dbtPosta(TQRDBText)=PageHeaderBand1@443,128[60x18]Arial»0@10[]238#taLeftJustify${00101}qryPP%POSTA!^0000/0&1@psSolid«
dbtMestoKupca(TQRDBText)=PageHeaderBand1@508,128[207x18]Arial»0@10[]238#taLeftJustify${00101}qryPP%MESTONAZIV!^0000/0&1@psSolid«
lblMagacin(TQRLabel)=PageHeaderBand1@5,106[52x18]Arial»0@10[]238#taLeftJustify${00101}Magacin:!^0000/0&1@psSolid«
dbtMagacin(TQRDBText)=PageHeaderBand1@65,106[363x18]Arial»0@10[]238#taLeftJustify${00101}qryDokument%MAGNAZIV!^0000/0&1@psSolid«
lblIsporuka(TQRLabel)=GroupFooterBand1@4,10[70x15]Arial»8@8[]1#taLeftJustify${10101}Isporuka robe : !^0000/0&1@psSolid«
dbtIsporuka(TQRDBText)=GroupFooterBand1@85,9[200x17]Arial»0@10[]0#taLeftJustify${00101}qryDokument%PREVOZROBE!QRFFaktura.OdsecnicadbtIsporukaPrint^0000/0&1@psSolid«
dbtVerifikovan(TQRDBText)=PageHeaderBand1@500,10[150x16]Arial»@10[]#taLeftJustify${00011}qryDokument%FLAG!QRFFaktura.OdsecnicadbtVerifikovanPrint^0000/0&1@psSolid«
dbtVrstaDok(TQRDBText)=PageHeaderBand1@283,154[200x18]Arial»0@10[]238#taLeftJustify${00101}qryDokument%NAZIVDOK!^0000/0&1@psSolid«
dbtSerija(TQRDBText)=QRSubDetail1@620,1[100x14]Arial»8@8[]1#taLeftJustify${00101}qryStavRok%SERIJA!^0000/0&1@psSolid«
lblPozicijeNaslov(TQRLabel)=ChildBand@31,0[75x16]Arial»@8[]#taRightJustify${00011}Pozicije:!^0000/0&1@psSolid«
lblPozicije(TQRLabel)=ChildBand@113,0[350x16]Arial»@8[]#taLeftJustify${00011}Pozicije:!^0000/0&1@psSolid«
dbtIntBroj(TQRDBText)=PageHeaderBand1@191,151[72x21]Arial»0@13[]238#taLeftJustify${00101}qryDokument%INTBROJ!^0000/0&1@psSolid«