//ReportID: 704 //TipeID: 3 //LastChanged: 19.05.2011 08:45:34 //Description: SPECIFIKACIJA UZ PORESKU PRIJAVU (Uz obrazac PP OPJ) //LinkRepID: 704 QRPorezNaFond(TQuickRep)=qryRekap&poPortrait@Default[2100x2970,45x45]Arial»0@10[]1#1{0}!|<>\?/^0000/0&1@psSolid« qryRekap(TpFIBDataSet)=57[IBMastData.FIBDataBase]{110} { SELECT O.ISPLATAID, K.OPSTINAID, OPS.NAZIV, OPS.UPLRAC, OPS.UPL_MODUL, OPS.UPL_POZNABROJ, SUM(IZE1.VREDNOST) AS BRUTO_ZARADA, ROUNDDEC(SUM(IZE2.VREDNOST), 0) AS NETO_POREZ, SUM(IZE3.VREDNOST) AS NETO_POREZ_UM, SUM(IZE4.VREDNOST) AS BRUTO_ZARADA_AKONT, ROUNDDEC(SUM(IZE5.VREDNOST), 0) AS NETO_POREZ_AKONT, SUM(IZE6.VREDNOST) AS NETO_POREZ_UM_AKONT FROM PL_OBRACUN O JOIN PL_KADAR K ON O.ZAPID = K.ZAPID LEFT JOIN PL_ISPLATA I ON O.ISPLATAID = I.ISPLATAID LEFT JOIN PL_MP MP ON K.MPID = MP.MPID LEFT JOIN PL_OPSTINA OPS ON OPS.OPSTINAID = K.OPSTINAID LEFT JOIN PL_ISPLZAPELEM IZE1 ON IZE1.ISPLATAID = O.ISPLATAID AND IZE1.VRSTAZARADEID = O.VRSTAZARADEID AND IZE1.ZAPID = O.ZAPID AND IZE1.OZID = 'BRUTO ZARADA' LEFT JOIN PL_ISPLZAPELEM IZE2 ON IZE2.ISPLATAID = O.ISPLATAID AND IZE2.VRSTAZARADEID = O.VRSTAZARADEID AND IZE2.ZAPID = O.ZAPID AND IZE2.OZID = 'NETO POREZ' LEFT JOIN PL_ISPLZAPELEM IZE3 ON IZE3.ISPLATAID = O.ISPLATAID AND IZE3.VRSTAZARADEID = O.VRSTAZARADEID AND IZE3.ZAPID = O.ZAPID AND IZE3.OZID = 'OBR_POR_UMA' LEFT JOIN PL_ISPLZAPELEM IZE4 ON IZE4.ISPLATAID = I.LINKISPLATAID AND IZE4.VRSTAZARADEID = O.VRSTAZARADEID AND IZE4.ZAPID = O.ZAPID AND IZE4.OZID = 'BRUTO ZARADA' LEFT JOIN PL_ISPLZAPELEM IZE5 ON IZE5.ISPLATAID = I.LINKISPLATAID AND IZE5.VRSTAZARADEID = O.VRSTAZARADEID AND IZE5.ZAPID = O.ZAPID AND IZE5.OZID = 'NETO POREZ' LEFT JOIN PL_ISPLZAPELEM IZE6 ON IZE6.ISPLATAID = I.LINKISPLATAID AND IZE6.VRSTAZARADEID = O.VRSTAZARADEID AND IZE6.ZAPID = O.ZAPID AND IZE6.OZID = 'OBR_POR_UMA' WHERE O.ISPLATAID = :ISPLATAID AND O.VRSTAZARADEID = :VZID AND K.STATUS BETWEEN :STAT1 AND :STAT2 AND MP.UMANJENJE_POREZA = 0 GROUP BY O.ISPLATAID, K.OPSTINAID, OPS.NAZIV, OPS.UPLRAC, OPS.UPL_MODUL, OPS.UPL_POZNABROJ ORDER BY OPS.NAZIV } DetailBand1(TQRBand)=rbDetail[18]$16777215{00001}!^0000/0&1@psSolid« ColumnHeaderBand1(TQRBand)=rbColumnHeader[88]$16777215{00001}!^0000/0&1@psSolid« PageHeaderBand1(TQRBand)=rbPageHeader[35]$16777215{00001}!^0000/&@« SummaryBand1(TQRBand)=rbSummary[100]$16777215{00001}!^0000/0&1@psSolid« PageFooterBand1(TQRBand)=rbPageFooter[24]$16777215{00001}!^0000/0&1@psSolid« txtNaziv(TQRDBText)=DetailBand1@50,0[250x15]Arial»0@8[fsBold]1#taLeftJustify${00011}qryRekap%NAZIV!^0000/0&1@psSolid« lblNaslov(TQRLabel)=ColumnHeaderBand1@10,8[764x20]Arial»0@14[fsBold]1#taCenter${01101}SPECIFIKACIJA UZ PORESKU PRIJAVU (Uz obrazac PP OPJ)!^0000/0&1@psSolid« QRShape1(TQRShape)=ColumnHeaderBand1@1,84[763x4]&@#&bsClear$qrsHorLine{00011}!^0000/0&1@psSolid« lblNazivOpstine(TQRLabel)=ColumnHeaderBand1@50,66[250x17]Arial»0@8[]1#taLeftJustify${00101}Sifra i naziv opstine!^0000/0&1@psSolid« QRDBText9(TQRDBText)=PageHeaderBand1@6,6[299x23]Arial»0@14[fsBold]1#taLeftJustify${00101}IBMastData.Firma%NAZIV!^0000/0&1@psSolid« QRSysData2(TQRSysData)=PageFooterBand1@304,6[74x15]Arial»0@8[]1#taLeftJustify$Strana {10001}qrsPageNumber!^0000/&@« dbtIsplata(TQRDBText)=PageHeaderBand1@467,9[299x20]Arial»0@10[]1#taRightJustify${00001}qryRekap%ISPLATAID!dlgIzborIzvestaja.IsplataNazivPrint^0000/0&1@psSolid« shpLinija2(TQRShape)=SummaryBand1@1,-3[763x3]&@psDot#&$qrsHorLine{00011}!^0000/0&1@psSolid« shpLinija(TQRShape)=DetailBand1@1,-3[763x3]&@psDot#&$qrsHorLine{00011}!^0000/0&1@psSolid« lblPorezNaDohodak(TQRLabel)=ColumnHeaderBand1@300,66[110x17]Arial»0@8[]1#taRightJustify${00101}Porez na dohodak!^0000/0&1@psSolid« dbtPorezNaDohodak(TQRDBText)=DetailBand1@411,0[13x15]Arial»0@8[]1#taRightJustify$###,###,##0.00{00010}qryRekap%NETO_POREZ!^0000/0&1@psSolid« expPorezNaDohodak(TQRExpr)=SummaryBand1&QRIsplatnaLista@300,8[110x16]#taRightJustify$###,###,##0.00{000111}SUM(NETO_POREZ - NETO_POREZ_AKONT)!^0000/0&1@psSolid« shpLinijaUkupno(TQRShape)=SummaryBand1@1,2[763x4]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid« lblPIB(TQRLabel)=ColumnHeaderBand1@10,35[120x17]Arial»0@12[]1#taLeftJustify${00101}PIB isplatioca:!^0000/0&1@psSolid« dbtPIB(TQRDBText)=ColumnHeaderBand1@130,35[150x17]Arial»0@12[fsBold]1#taLeftJustify${00101}IBMastData.Firma%PIB!^0000/0&1@psSolid« lblRB(TQRLabel)=ColumnHeaderBand1@6,66[40x17]Arial»0@8[]1#taRightJustify${00101}Red.br.!^0000/0&1@psSolid« lblUkupno(TQRLabel)=SummaryBand1@200,8[100x16]Arial»0@10[]1#taLeftJustify${00101}UKUPNO:!^0000/0&1@psSolid« sysRecNo(TQRSysData)=DetailBand1@10,2[24x15]Arial»@7[]#taRightJustify${00011}qrsDetailNo!^0000/0&1@psSolid« dbtUplRac(TQRDBText)=DetailBand1@425,0[120x15]Arial»0@8[]1#taLeftJustify${00011}qryRekap%UPLRAC!^0000/0&1@psSolid« dbtUplModul(TQRDBText)=DetailBand1@550,0[50x15]Arial»0@8[]1#taLeftJustify${00011}qryRekap%UPL_MODUL!^0000/0&1@psSolid« dbtUplPozNaBroj(TQRDBText)=DetailBand1@605,0[120x15]Arial»0@8[]1#taLeftJustify${00011}qryRekap%UPL_POZNABROJ!^0000/0&1@psSolid« lblPUplRac(TQRLabel)=ColumnHeaderBand1@425,66[120x17]Arial»0@8[]1#taLeftJustify${00101}Uplatni racun!^0000/0&1@psSolid« lblModel(TQRLabel)=ColumnHeaderBand1@550,66[50x17]Arial»0@8[]1#taLeftJustify${00101}Model!^0000/0&1@psSolid« lblPozivNaBroj(TQRLabel)=ColumnHeaderBand1@605,66[120x17]Arial»0@8[]1#taLeftJustify${00101}Poziv na broj!^0000/0&1@psSolid« lblOL(TQRLabel)=SummaryBand1@6,66[100x17]Arial»0@8[]1#taRightJustify${00101}Odgovorno lice:!^0000/0&1@psSolid« expPorezNaDohodakOpstine(TQRExpr)=DetailBand1&QRIsplatnaLista@300,0[110x15]#taRightJustify$###,###,##0.00{000111}(NETO_POREZ - NETO_POREZ_UM) - (NETO_POREZ_AKONT - NETO_POREZ_UM_AKONT)!^0000/0&1@psSolid«