//ReportID: 514
//TipeID: 11
//LastChanged: 16.03.2020 14:21:51
//Description: Stampa kartice partnera
//LinkRepID: 121
//BrojKolona: 0
//BrojRedova: 0
QRKartObjekta(TQuickRep)=qryData&poPortrait@Default[2100x2970,100x100,100x100]Arial»-16777208@14[]1#1{1}Kartica objekta!|<frmDMKartica.KarticaPPBeforePrint>\?/^0000/0&1@psSolid«~
qryData(TpFIBDataSet)=757[IBMastData.FIBDatabase]{110}
{
SELECT OC.*,  
  OC.STANJE - OC.PRETHODNO_STANJE as POTROSENO,
  OC.STANJE - OC.PRETHODNO_STANJE + OC.ZAJEDNICKA_POTROSNJA as UKUPNA_POTROSNJA,
  D.POPUST1DANA,
  P.NAZIV as VLASNIK, 
  O.PROSTOR_ID, O.VRSTA, O.POVRSINA_M2, O.NADREDJENI_ID, O.BROJ_MERILA, O.PROSTOR_ID,  O.ELABORAT,
  NADO.PROSTOR_ID AS NADREDJENI_PROSTOR_ID
FROM OBJEKAT_OCITAVANJA OC
  LEFT JOIN DOKUMENT D ON D.VRDOK = 60 AND D.BRDOK = OC.BRDOK
  LEFT JOIN OBJEKAT O ON OC.OBJEKAT_ID = O.ID
  LEFT JOIN PARTNER P ON O.PPID = P.PPID
  LEFT JOIN OBJEKAT NADO ON O.NADREDJENI_ID = NADO.ID
WHERE OC.OBJEKAT_ID = :OBJEKAT_ID  and   OC.DATUM >= :DATUM_OD and OC.DATUM <= :DATUM_DO
ORDER BY OC.DATUM
}
DetailBand1(TQRBand)=rbDetail[25]Arial»-16777208@8[]1$16777215{000011}frmDMKartica.DetailBand1AfterPrint!^0000/0&1@psSolid«
PageFooterBand1(TQRBand)=rbPageFooter[16]$16777215{00001}!^0000/0&1@psSolid«
ColumnHeaderBand1(TQRBand)=rbColumnHeader[40]$16777215{000011}!^0000/0&1@psSolid«
PageHeaderBand1(TQRBand)=rbPageHeader[115]$16777215{000011}!^0000/0&1@psSolid«
SummaryBand1(TQRBand)=rbSummary[80]$16777215{000011}!^0000/0&1@psSolid«
dbDatum(TQRDBText)=DetailBand1@5,3[60x16]Arial»-16777208@8[]1#taLeftJustify${00101}qryData%DATUM!^0000/0&1@psSolid«
dbBrDok(TQRDBText)=DetailBand1@70,3[40x15]Arial»-16777208@8[]1#taRightJustify${00101}qryData%BRDOK!^0000/0&1@psSolid«
dbPotrosnja(TQRDBText)=DetailBand1@330,3[100x15]Arial»-16777208@8[]1#taRightJustify$###,###,##0{00101}qryData%POTROSENO!frmDMKartica.dbIzlazPrint^0000/0&1@psSolid«
dbStanje(TQRDBText)=DetailBand1@225,3[100x15]Arial»-16777208@8[]1#taRightJustify$###,###,##0{00101}qryData%STANJE!frmDMKartica.dbUlazPrint^0000/0&1@psSolid«
dbZajPot(TQRDBText)=DetailBand1@435,3[100x15]Arial»-16777208@8[]1#taRightJustify$###,###,##0.00#{00101}qryData%ZAJEDNICKA_POTROSNJA!frmDMKartica.dbUplacenoPrint^0000/0&1@psSolid«
sdStrana(TQRSysData)=PageFooterBand1@8,1[705x14]Arial»-16777208@8[]1#taCenter$Strana {00001}qrsPageNumber!^0000/0&1@psSolid«
shLinija1(TQRShape)=ColumnHeaderBand1@2,35[714x4]&2@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
lblDatum(TQRLabel)=ColumnHeaderBand1@9,4[57x32]Arial»-16777208@8[]1#taLeftJustify${01101}Datum očitavanja!^0000/0&1@psSolid«
lblBroj(TQRLabel)=ColumnHeaderBand1@70,7[40x16]Arial»-16777208@8[]1#taRightJustify${00101}Broj!^0000/0&1@psSolid«
lblStanje(TQRLabel)=ColumnHeaderBand1@225,4[100x32]Arial»-16777208@8[]1#taRightJustify${01101}Stanje (kW)!^0000/0&1@psSolid«
lblPotroseno(TQRLabel)=ColumnHeaderBand1@330,4[100x32]Arial»-16777208@8[]238#taRightJustify${01101}Potrošeno (kW)!^0000/0&1@psSolid«
lblZajednickaPotr(TQRLabel)=ColumnHeaderBand1@435,4[100x32]Arial»-16777208@8[]238#taRightJustify${01101}Zajednička potrošnja (kW)!^0000/0&1@psSolid«
lblNaslov(TQRLabel)=PageHeaderBand1@6,28[705x20]Arial»-16777208@10[fsBold]238#taLeftJustify${01101}KARTICA OBJEKTA!^0000/0&1@psSolid«
lblFirma(TQRDBText)=PageHeaderBand1@412,2[299x23]Arial»-16777208@12[fsBold]238#taRightJustify${00101}IBMastData.Firma%NAZIV!^0000/0&1@psSolid«
QRShape2(TQRShape)=SummaryBand1@174,0[542x5]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
lblUkupno(TQRLabel)=SummaryBand1@174,6[92x16]Arial»-16777208@9[]1#taLeftJustify${00101}Ukupno kW:!^0000/0&1@psSolid«
expPotroseno(TQRExpr)=SummaryBand1&@330,7[100x15]Arial»-16777208@8[]1#taRightJustify$###,###,##0.00{001011}SUM(qryData.POTROSENO)!frmDMKartica.expIzlazPrint^0000/0&1@psSolid«
expZajPotrosnja(TQRExpr)=SummaryBand1&@435,7[100x15]Arial»-16777208@8[]1#taRightJustify$###,###,##0.00{001011}SUM(qryData.ZAJEDNICKA_POTROSNJA)!frmDMKartica.expUplacenoPrint^0000/0&1@psSolid«
dbtPretStanje(TQRDBText)=DetailBand1@120,3[100x15]Arial»-16777208@8[]1#taRightJustify$###,###,##0{00101}qryData%PRETHODNO_STANJE!^0000/0&1@psSolid«
lblPretStanje(TQRLabel)=ColumnHeaderBand1@120,4[100x32]Arial»-16777208@8[]1#taRightJustify${01101}Prethodno stanje (kW)!^0000/0&1@psSolid«
dbUkPotrosnja(TQRDBText)=DetailBand1@540,3[100x15]Arial»-16777208@8[]1#taRightJustify$###,###,##0.00#{00101}qryData%UKUPNA_POTROSNJA!frmDMKartica.dbUplacenoPrint^0000/0&1@psSolid«
lblUkPotrosnja(TQRLabel)=ColumnHeaderBand1@540,4[100x32]Arial»-16777208@8[]238#taRightJustify${01101}Ukupna potrošnja (kW)!^0000/0&1@psSolid«
expUkPotrosnja(TQRExpr)=SummaryBand1&@540,7[100x15]Arial»-16777208@8[]1#taRightJustify$###,###,##0.00{001011}SUM(qryData.UKUPNA_POTROSNJA)!frmDMKartica.expUplacenoPrint^0000/0&1@psSolid«
dbtVlasnik(TQRDBText)=PageHeaderBand1@248,65[261x15]Arial»-16777208@8[fsBold]1#taLeftJustify${00101}qryData%VLASNIK!^0000/0&1@psSolid«
dbtPobrsinaM2(TQRDBText)=PageHeaderBand1@248,80[50x15]Arial»-16777208@8[fsBold]1#taLeftJustify${00101}qryData%POVRSINA_M2!^0000/0&1@psSolid«
shLinija11(TQRShape)=ColumnHeaderBand1@2,0[714x4]&2@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
shLinija12(TQRShape)=DetailBand1@2,19[714x4]&1@psDot#&$qrsHorLine{00011}!^0000/0&1@psSolid«
QRShape21(TQRShape)=SummaryBand1@174,23[542x5]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
lblVlasnik(TQRLabel)=PageHeaderBand1@157,65[40x15]Arial»-16777208@8[]1#taLeftJustify${00101}Vlasnik:!^0000/0&1@psSolid«
lblM2(TQRLabel)=PageHeaderBand1@157,80[89x15]Arial»-16777208@8[]1#taLeftJustify${00101}Površina m2:!^0000/0&1@psSolid«
lblElaborat(TQRLabel)=PageHeaderBand1@157,95[89x15]Arial»-16777208@8[]1#taLeftJustify${00101}Elaborat:!^0000/0&1@psSolid«
dbtElaborat(TQRDBText)=PageHeaderBand1@248,95[50x15]Arial»-16777208@8[fsBold]1#taLeftJustify${00101}qryData%ELABORAT!^0000/0&1@psSolid«
lblID(TQRLabel)=PageHeaderBand1@7,50[33x15]Arial»-16777208@8[]1#taLeftJustify${00101}ID:!^0000/0&1@psSolid«
dbtID(TQRDBText)=PageHeaderBand1@41,50[50x15]Arial»-16777208@8[fsBold]1#taRightJustify${00101}qryData%PROSTOR_ID!^0000/0&1@psSolid«
dbtIDM(TQRDBText)=PageHeaderBand1@248,50[50x15]Arial»-16777208@8[fsBold]1#taRightJustify${00101}qryData%BROJ_MERILA!^0000/0&1@psSolid«
lblIDM(TQRLabel)=PageHeaderBand1@157,50[90x15]Arial»-16777208@8[]1#taLeftJustify${00101}Broj merila:!^0000/0&1@psSolid«
lblMaxPotrosnja(TQRLabel)=SummaryBand1@174,29[200x15]Arial»-16777208@8[]238#taLeftJustify${00101}Max potrosnja!^0000/0&1@psSolid«
lblMinPotrosnja(TQRLabel)=SummaryBand1@174,44[200x15]Arial»-16777208@8[]238#taLeftJustify${00101}Max potrosnja!^0000/0&1@psSolid«
lblMaxPotrosnjaPoM2(TQRLabel)=SummaryBand1@376,29[200x15]Arial»-16777208@8[]238#taLeftJustify${00101}Max potrosnja!^0000/0&1@psSolid«
lblMinPotrosnjaPoM2(TQRLabel)=SummaryBand1@376,44[200x15]Arial»-16777208@8[]238#taLeftJustify${00101}Max potrosnja!^0000/0&1@psSolid«
lblProsPotrosnja(TQRLabel)=SummaryBand1@174,59[200x15]Arial»-16777208@8[]238#taLeftJustify${00101}Max potrosnja!^0000/0&1@psSolid«
lblProsPotrosnjaPoM2(TQRLabel)=SummaryBand1@376,59[200x15]Arial»-16777208@8[]238#taLeftJustify${00101}Max potrosnja!^0000/0&1@psSolid«