|
Server IP : 127.0.0.1 / Your IP : 127.0.0.1 Web Server : Apache/2.4.10 (Win32) OpenSSL/1.0.1i PHP/5.6.3 System : Windows NT WIN-R7LTCC7BPLI 6.3 build 9200 (Windows Server 2012 R2 Datacenter Edition) i586 User : GerbangSIPAD ( 0) PHP Version : 5.6.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF Directory (0777) : C:/xampp5/htdocs/bphtb/report/InformasiNJOP/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Informasi NPOP" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="3fe4ed43-0dde-4c37-80f3-397c3910a87f">
<property name="ireport.zoom" value="1.9965000000000006"/>
<property name="ireport.x" value="131"/>
<property name="ireport.y" value="624"/>
<parameter name="nip" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="tahun" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="njop" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select
a.*,
$P{njop} as njop,
x.njop_bumi,
x.njop_bng,
x.total_luas_bumi,
x.total_luas_bng,
x.pbb,
x.nm_wp,
x.jalan_wp,
x.jalan_op
from (
select
$P{tahun} as tahun,
upper(nama_org) as nama_org, upper(nama_dinas) as nama_dinas, upper(alamat_dinas) as alamat_dinas,
concat(
upper(ibu_kota),
to_char(current_timestamp, ', DD '),
case extract(month from now()) when 1 then 'Januari'
when 2 then 'Februari'
when 3 then 'Maret'
when 4 then 'April'
when 5 then 'Mei'
when 6 then 'Juni'
when 7 then 'Juli'
when 8 then 'Agustus'
when 9 then 'September'
when 10 then 'Oktober'
when 11 then 'November'
when 12 then 'Desember'
end,
' ',
extract(year from now())
) as ttg,
concat(jenis_pem, ' ',nama_kab) as kab,
(select upper(nama_pjb) from bphtb.pejabat
where trim(both ' ' from nip) = trim(both ' ' from $P{nip})) as nama,
(select concat('NP. ', trim(both ' ' from nip)) from bphtb.pejabat
where trim(both ' ' from nip) = trim(both ' ' from $P{nip})) as np,
(select upper(pangkat) from bphtb.pejabat
where trim(both ' ' from nip) = trim(both ' ' from $P{nip})) as pangkat,
(select upper(nama_jab) from bphtb.pejabat b left join bphtb.jabatan c on c.kode_jab = b.kode_jab
where trim(both ' ' from nip) = trim(both ' ' from $P{nip})) as jabatan
from bphtb.organisasi
) a
left join (
select
$P{tahun} as tahun,
to_char( c.njop_bumi, '999G999G990D00') as njop_bumi,
to_char( c.njop_bng, '999G999G990D00') as njop_bng,
c.total_luas_bumi,
c.total_luas_bng,
to_char( c.njop_bumi + c.njop_bng, '999G999G990D00') as pbb,
d.nm_wp,
d.jalan_wp,
c.jalan_op
from DAT_OBJEK_PAJAK c
left join dat_subjek_pajak d on d.subjek_pajak_id = c.subjek_pajak_id
where
c.KD_PROPINSI = substring($P{njop} from 1 for 2) and
c.KD_DATI2 = substring($P{njop} from 3 for 2) and
c.KD_KECAMATAN = substring($P{njop} from 5 for 3) and
c.KD_KELURAHAN = substring($P{njop} from 8 for 3) and
c.KD_BLOK = substring($P{njop} from 11 for 3) and
c.no_URUT = substring($P{njop} from 14 for 4) and
c.kd_jns_op = substring($P{njop} from 18 for 1)) x on x.tahun = a.tahun]]>
</queryString>
<field name="tahun" class="java.lang.String"/>
<field name="nama_org" class="java.lang.String"/>
<field name="nama_dinas" class="java.lang.String"/>
<field name="alamat_dinas" class="java.lang.String"/>
<field name="ttg" class="java.lang.String"/>
<field name="kab" class="java.lang.String"/>
<field name="nama" class="java.lang.String"/>
<field name="np" class="java.lang.String"/>
<field name="pangkat" class="java.lang.String"/>
<field name="jabatan" class="java.lang.String"/>
<field name="njop" class="java.lang.String"/>
<field name="njop_bumi" class="java.lang.String"/>
<field name="njop_bng" class="java.lang.String"/>
<field name="total_luas_bumi" class="java.lang.Long"/>
<field name="total_luas_bng" class="java.lang.Long"/>
<field name="pbb" class="java.lang.String"/>
<field name="nm_wp" class="java.lang.String"/>
<field name="jalan_wp" class="java.lang.String"/>
<field name="jalan_op" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="79" splitType="Stretch">
<textField>
<reportElement uuid="b5ca6559-7600-40b5-ae18-0c112912e80f" x="73" y="12" width="409" height="14"/>
<textElement textAlignment="Center">
<font fontName="SansSerif"/>
</textElement>
<textFieldExpression><![CDATA[$F{nama_org}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="07214919-aa56-4dda-bfae-9e24dcbc3c04" x="73" y="27" width="409" height="15"/>
<textElement textAlignment="Center">
<font fontName="SansSerif" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{nama_dinas}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="e03f7233-e28e-4728-b6e3-f2cf7bfc7382" x="73" y="44" width="409" height="15"/>
<textElement textAlignment="Center">
<font fontName="SansSerif"/>
</textElement>
<textFieldExpression><![CDATA[$F{alamat_dinas}]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="dc11ea88-8395-42fc-9e30-29a941e00f4c" x="0" y="68" width="555" height="1"/>
</line>
</band>
</title>
<pageHeader>
<band height="1" splitType="Stretch"/>
</pageHeader>
<columnHeader>
<band splitType="Stretch"/>
</columnHeader>
<detail>
<band height="554" splitType="Stretch">
<staticText>
<reportElement uuid="166cd111-80bb-4be4-bfef-e5f21ad983cb" x="197" y="0" width="169" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[INFORMASI NILAI OBJEK PAJAK]]></text>
</staticText>
<staticText>
<reportElement uuid="166cd111-80bb-4be4-bfef-e5f21ad983cb" x="197" y="0" width="169" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[INFORMASI NILAI OBJEK PAJAK]]></text>
</staticText>
<staticText>
<reportElement uuid="256f0d1f-24c3-4139-9e30-c265c6b711db" x="46" y="45" width="125" height="20"/>
<textElement/>
<text><![CDATA[NOP :]]></text>
</staticText>
<staticText>
<reportElement uuid="39e1220d-3973-468c-b84d-ff51bf700fe3" x="325" y="45" width="88" height="20"/>
<textElement/>
<text><![CDATA[TAHUN :]]></text>
</staticText>
<staticText>
<reportElement uuid="38d442e2-b855-4423-aa93-1b602d4b790f" x="46" y="88" width="125" height="20"/>
<textElement>
<font isBold="true"/>
</textElement>
<text><![CDATA[DATA SUBJEK ]]></text>
</staticText>
<staticText>
<reportElement uuid="fb418e2f-25ba-4709-b05c-5154bea5fb24" x="46" y="107" width="125" height="20"/>
<textElement/>
<text><![CDATA[NAMA PEMILIK :]]></text>
</staticText>
<staticText>
<reportElement uuid="b954d7bc-94f1-4c48-b0ef-8b808068a144" x="46" y="127" width="125" height="20"/>
<textElement/>
<text><![CDATA[ALAMAT PEMILIK :]]></text>
</staticText>
<staticText>
<reportElement uuid="6dcbb0a7-5613-4d6f-8997-dfa613d16b4c" x="46" y="147" width="125" height="20"/>
<textElement/>
<text><![CDATA[ALAMAT OBJEK PAJAK :]]></text>
</staticText>
<staticText>
<reportElement uuid="ae03f34a-8ee3-4041-9ec4-28984d83ac24" x="46" y="192" width="151" height="20"/>
<textElement>
<font isBold="true"/>
</textElement>
<text><![CDATA[DATA OBJEK PAJAK]]></text>
</staticText>
<staticText>
<reportElement uuid="f7217262-4d33-4103-876b-8e865bb67b46" x="46" y="212" width="151" height="20"/>
<textElement/>
<text><![CDATA[NJOP BUMI : Rp.]]></text>
</staticText>
<staticText>
<reportElement uuid="547a679f-0e96-40ea-94a5-eafac4e8cbab" x="46" y="232" width="151" height="20"/>
<textElement/>
<text><![CDATA[NJOP BANGUNAN : Rp.]]></text>
</staticText>
<staticText>
<reportElement uuid="258fc9f0-7776-4c57-9a2f-fec01d22a383" x="46" y="272" width="151" height="20"/>
<textElement/>
<text><![CDATA[LUAS BANGUNAN : ]]></text>
</staticText>
<staticText>
<reportElement uuid="d604d12d-4127-4a90-a1a7-b62ead950fdf" x="46" y="292" width="151" height="20"/>
<textElement/>
<text><![CDATA[PAJAK PBB : Rp.]]></text>
</staticText>
<textField>
<reportElement uuid="0cc59f4d-415d-4671-9ebd-d7f4219ef1bc" x="360" y="332" width="195" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{ttg}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="33506c4d-7ff0-43a0-a308-12360ba89fa3" x="360" y="352" width="195" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[AN. KEPALA DINAS PENDAPATAN aTA]]></text>
</staticText>
<textField>
<reportElement uuid="07a76213-2b74-4081-bafc-953f351137cb" x="360" y="372" width="195" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{kab}]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="a1b93ed5-20de-441c-8b62-b6f47c89eada" x="360" y="486" width="195" height="1"/>
</line>
<textField>
<reportElement uuid="585785d3-a1cf-4452-b07a-95b148271037" x="360" y="487" width="195" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{pangkat}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="c43a9712-39ff-46e0-9f09-1f205c171f8b" x="360" y="392" width="195" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{jabatan}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="fe3f8c8b-ac16-4bf0-a1de-5d1b1008065f" x="360" y="507" width="195" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{np}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="78f19799-03e5-4109-8a11-eca898c95419" x="360" y="466" width="195" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{nama}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="e672415f-59cd-4cf2-a62e-a8a22ec78cbf" x="413" y="45" width="69" height="20"/>
<textElement verticalAlignment="Top"/>
<textFieldExpression><![CDATA[$F{tahun}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="e7b8b096-277f-413e-be52-5823a97989d1" x="171" y="45" width="100" height="20"/>
<textElement verticalAlignment="Top"/>
<textFieldExpression><![CDATA[$F{njop}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="dc7cfafa-6807-40d5-83c6-6a8dbea7790f" x="171" y="107" width="100" height="20"/>
<textElement verticalAlignment="Top"/>
<textFieldExpression><![CDATA[$F{nm_wp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="e2807ce3-be9a-40f0-ab14-2c216ed83604" x="171" y="127" width="195" height="20"/>
<textElement verticalAlignment="Top"/>
<textFieldExpression><![CDATA[$F{jalan_wp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="6c645bc4-ccec-4658-ae33-5a145f45bd4a" x="171" y="147" width="195" height="20"/>
<textElement verticalAlignment="Top"/>
<textFieldExpression><![CDATA[$F{jalan_op}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="9ad241ec-0103-49d6-b810-99a0c4479404" x="197" y="212" width="74" height="20"/>
<textElement textAlignment="Right" verticalAlignment="Top"/>
<textFieldExpression><![CDATA[$F{njop_bumi}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="8c26b18d-6a57-4d20-aa27-51cf2c280d36" x="197" y="232" width="74" height="20"/>
<textElement textAlignment="Right" verticalAlignment="Top"/>
<textFieldExpression><![CDATA[$F{njop_bng}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="8a6a61b1-2b74-4ef9-9244-4f1ab528c430" x="197" y="272" width="62" height="20"/>
<textElement textAlignment="Right" verticalAlignment="Top"/>
<textFieldExpression><![CDATA[$F{total_luas_bng}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="c7a07e18-c10f-47c9-ac9a-b44baf816bf5" x="198" y="292" width="74" height="20"/>
<textElement textAlignment="Right" verticalAlignment="Top"/>
<textFieldExpression><![CDATA[$F{pbb}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="a9e0691d-1e10-44ad-a3dc-73e1bb4a4a9a" x="46" y="252" width="151" height="20"/>
<textElement/>
<text><![CDATA[LUAS BUMI : ]]></text>
</staticText>
<textField>
<reportElement uuid="72dac142-b20e-47d2-80db-d1d5eb484f0c" x="197" y="252" width="62" height="20"/>
<textElement textAlignment="Right" verticalAlignment="Top"/>
<textFieldExpression><![CDATA[$F{total_luas_bumi}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="87724d8b-17ee-4343-9427-9b41fdfb8f75" x="262" y="272" width="18" height="20"/>
<textElement/>
<text><![CDATA[M2]]></text>
</staticText>
<staticText>
<reportElement uuid="9977fdbe-e34e-44d9-8948-310603870d8d" x="262" y="252" width="18" height="20"/>
<textElement/>
<text><![CDATA[M2]]></text>
</staticText>
</band>
</detail>
<columnFooter>
<band height="45" splitType="Stretch"/>
</columnFooter>
<pageFooter>
<band height="54" splitType="Stretch"/>
</pageFooter>
<summary>
<band height="42" splitType="Stretch"/>
</summary>
</jasperReport>