function GetCetakGeneralHTML($param_arr)
{
$output = '';
$output .= '<table id="table-piutang" class="grid-table-container" border="0" cellspacing="0" cellpadding="0" width="70%" style="margin-left:10px;padding:5px 5px 5px 5px;">
<tr>
<td valign="top">';
$output .= '<table class="grid-table" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="HeaderLeft"><img border="0" alt="" src="../Styles/sikp/Images/Spacer.gif"></td>
<td class="th"><strong>LAPORAN TARGET DAN REALISASI</strong></td>
<td class="HeaderRight"><img border="0" alt="" src="../Styles/sikp/Images/Spacer.gif"></td>
</tr>
</table>';
//$output .= '<div align="right"><a href="#" onClick="downloadGeneral();"> Download Excel </a></div>';
$output .= '<h3>BIDANG PAJAK PENDAFTARAN & PAJAK PENETAPAN</h3>';
$output .= '<h3>PERIODE : ' . $param_arr["pajak_periode"] . ' s.d ' . $param_arr["pajak_periode1"] . '</h3> <br/>';
$output .= '<table class="report" cellspacing="0" cellpadding="4px" width="100%">
<tr style="background:#498CD6;color:#FFFFFF;">';
$output .= '<th width="150">JENIS PAJAK</th>';
$output .= '<th width="150">TARGET</th>';
$output .= '<th width="150">REALISASI</th>';
//$output .= '<th width="150">PIUTANG</th>';
$output .= '<th width="150">KETERANGAN SELISIH</th>';
$output .= '</tr>';
$date_awal = getDateAwal($param_arr['p_finance_period_id']);
$date_akhir = getDateAkhir($param_arr['p_finance_period_id1']);
$dbConn = new clsDBConnSIKP();
$query = "SELECT a.p_vat_type_id, upper(a.vat_code) AS jenis_pajak, upper(substring(a.vat_code from 7)) as pajak_text, b.vat_code, b.p_vat_type_dtl_id\r\n\t\t\t\tFROM p_vat_type AS a \r\n\t\t\t\tLEFT JOIN p_vat_type_dtl as b ON a.p_vat_type_id = b.p_vat_type_id\r\n\t\t\t\tWHERE a.p_vat_type_id NOT IN (7,9) AND b.p_vat_type_dtl_id NOT IN (12, 23, 30, 31, 42, 43)\r\n\t\t\t\tORDER BY a.p_vat_type_id ASC, b.vat_code ASC";
$dbConn->query($query);
$data = array();
while ($dbConn->next_record()) {
$data["p_vat_type_id"][] = $dbConn->f("p_vat_type_id");
$data["jenis_pajak"][] = $dbConn->f("jenis_pajak");
$data["pajak_text"][] = $dbConn->f("pajak_text");
$data["vat_code"][] = $dbConn->f("vat_code");
$data["p_vat_type_dtl_id"][] = $dbConn->f("p_vat_type_dtl_id");
$data["date_awal"][] = $date_awal;
$data["date_akhir"][] = $date_akhir;
}
$dbConn->close();
$pajak_text = '';
$pajak_text = $data['pajak_text'][0];
$item = array();
$total_target_ = 0;
$total_realisasi_ = 0;
$total_piutang_ = 0;
$total_selisih_ = 0;
$grand_total_target_ = 0;
$grand_total_realisasi_ = 0;
$grand_total_selisih_ = 0;
$grand_total_piutang_ = 0;
for ($i = 0; $i < count($data['vat_code']); $i++) {
$item = getDataRow($param_arr['p_year_period_id'], $data['p_vat_type_id'][$i], $data['date_awal'][$i], $data['date_akhir'][$i], $data['p_vat_type_dtl_id'][$i]);
if ($pajak_text == $data['pajak_text'][$i]) {
if ($data['p_vat_type_id'][$i] == 1 or $data['p_vat_type_id'][$i] == 2 or $data['p_vat_type_id'][$i] == 3) {
$output .= '<tr>';
$output .= '<td>' . $data['vat_code'][$i] . '</td>';
$output .= '<td align="right">' . number_format($item['target'], 0, ',', '.') . ' </td>';
$output .= '<td align="right">' . number_format($item['realisasiDanPiutang'], 0, ',', '.') . '</td>';
//$output .= '<td align="right">'.number_format($item['realisasi'], 0, ',', '.').'</td>';
//$output .= '<td align="right">'.number_format($item['piutang'], 0, ',', '.').'</td>';
$output .= '<td align="right">' . number_format($item['selisih'], 0, ',', '.') . '</td>';
$output .= '</tr>';
}
$total_target_ += $item['target'];
$total_realisasi_ += $item['realisasiDanPiutang'];
//$total_realisasi_ += $item['realisasi'];
//$total_piutang_ += $item['piutang'];
$total_selisih_ += $item['selisih'];
} else {
$output .= '<tr style="background:#498CD6;font-weight:bold;color:#FFFFFF;">';
$output .= '<td style="padding-left:20px;"> JUMLAH ' . $pajak_text . '</td>';
$output .= '<td align="right"> ' . number_format($total_target_, 0, ',', '.') . ' </td>';
$output .= '<td align="right"> ' . number_format($total_realisasi_, 0, ',', '.') . '</td>';
//$output .= '<td align="right"> '.number_format($total_piutang_, 0, ',', '.').'</td>';
$output .= '<td align="right"> ' . number_format($total_selisih_, 0, ',', '.') . ' </td>';
$output .= '</tr>';
/*GRAND TOTATL */
$grand_total_target_ += $total_target_;
$grand_total_realisasi_ += $total_realisasi_;
$grand_total_piutang_ += $total_piutang_;
$grand_total_selisih_ += $total_selisih_;
/*END GRAND TOTAL */
$pajak_text = $data['pajak_text'][$i];
$total_target_ = 0;
$total_realisasi_ = 0;
$total_piutang_ = 0;
$total_selisih_ = 0;
if ($data['p_vat_type_id'][$i] == 1 or $data['p_vat_type_id'][$i] == 2 or $data['p_vat_type_id'][$i] == 3) {
$output .= '<tr>';
$output .= '<td>' . $data['vat_code'][$i] . '</td>';
$output .= '<td align="right">' . number_format($item['target'], 0, ',', '.') . ' </td>';
$output .= '<td align="right">' . number_format($item['realisasiDanPiutang'], 0, ',', '.') . '</td>';
//$output .= '<td align="right">'.number_format($item['realisasi'], 0, ',', '.').'</td>';
//$output .= '<td align="right">'.number_format($item['piutang'], 0, ',', '.').'</td>';
$output .= '<td align="right">' . number_format($item['selisih'], 0, ',', '.') . '</td>';
$output .= '</tr>';
}
$total_target_ += $item['target'];
$total_realisasi_ += $item['realisasiDanPiutang'];
//$total_realisasi_ += $item['realisasi'];
//$total_piutang_ += $item['piutang'];
$total_selisih_ += $item['selisih'];
}
}
$output .= '<tr style="background:#498CD6;font-weight:bold;color:#FFFFFF;">';
$output .= '<td style="padding-left:20px;"> JUMLAH ' . $pajak_text . '</td>';
$output .= '<td align="right"> ' . number_format($total_target_, 0, ',', '.') . ' </td>';
$output .= '<td align="right"> ' . number_format($total_realisasi_, 0, ',', '.') . '</td>';
//$output .= '<td align="right"> '.number_format($total_piutang_, 0, ',', '.').'</td>';
$output .= '<td align="right"> ' . number_format($total_selisih_, 0, ',', '.') . ' </td>';
$output .= '</tr>';
$itemReklame = getDataRowReklame($param_arr['p_year_period_id'], $date_awal, $date_akhir);
$output .= '<tr style="background:#498CD6;font-weight:bold;color:#FFFFFF;">';
$output .= '<td style="padding-left:20px;"> JUMLAH REKLAME </td>';
$output .= '<td align="right"> ' . number_format($itemReklame['target'], 0, ',', '.') . ' </td>';
$output .= '<td align="right"> ' . number_format($itemReklame['realisasiDanPiutang'], 0, ',', '.') . '</td>';
//$output .= '<td align="right"> '.number_format($itemReklame['realisasi'], 0, ',', '.').'</td>';
//$output .= '<td align="right"> '.number_format($itemReklame['piutang'], 0, ',', '.').'</td>';
$output .= '<td align="right"> ' . number_format($itemReklame['selisih'], 0, ',', '.') . ' </td>';
$output .= '</tr>';
/*GRAND TOTATL */
$grand_total_target_ += $total_target_ + $itemReklame['target'];
$grand_total_realisasi_ += $total_realisasi_ + $itemReklame['realisasiDanPiutang'];
//$grand_total_realisasi_ += $total_realisasi_ + $itemReklame['realisasi'];
//$grand_total_piutang_ += $total_piutang_ + $itemReklame['piutang'];
$grand_total_selisih_ += $total_selisih_ + $itemReklame['selisih'];
/*END GRAND TOTAL */
$output .= '<tr style="background:#000000;font-weight:bold;font-size:14px;color:#FFFFFF;">';
$output .= '<td style="padding-left:20px;"> JUMLAH TOTAL </td>';
$output .= '<td align="right"> ' . number_format($grand_total_target_, 0, ',', '.') . ' </td>';
$output .= '<td align="right"> ' . number_format($grand_total_realisasi_, 0, ',', '.') . '</td>';
//$output .= '<td align="right"> '.number_format($grand_total_piutang_, 0, ',', '.').'</td>';
$output .= '<td align="right"> ' . number_format($grand_total_selisih_, 0, ',', '.') . ' </td>';
$output .= '</tr>';
$output .= '</table>';
$output .= '</td></tr>';
$output .= '</table>';
return $output;
}
function GetCetakGeneralHTML($param_arr)
{
$output = '';
$output .= '<table id="table-piutang" class="grid-table-container" border="0" cellspacing="0" cellpadding="0" width="70%" style="margin-left:10px;padding:5px 5px 5px 5px;">
<tr>
<td valign="top">';
$output .= '<table class="grid-table" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="HeaderLeft"><img border="0" alt="" src="../Styles/sikp/Images/Spacer.gif"></td>
<td class="th"><strong>LAPORAN TARGET DAN REALISASI</strong></td>
<td class="HeaderRight"><img border="0" alt="" src="../Styles/sikp/Images/Spacer.gif"></td>
</tr>
</table>';
//$output .= '<div align="right"><a href="#" onClick="downloadGeneral();"> Download Excel </a></div>';
$output .= '<h3>BIDANG PAJAK PENDAFTARAN & PAJAK PENETAPAN</h3>';
$output .= '<h3>PERIODE : ' . $param_arr["pajak_periode"] . ' s.d ' . $param_arr["pajak_periode1"] . '</h3> <br/>';
$output .= '<table class="report" cellspacing="0" cellpadding="4px" width="100%">
<tr style="background:#498CD6;color:#FFFFFF;">';
$output .= '<th width="150">JENIS PAJAK</th>';
$output .= '<th width="150">TARGET</th>';
$output .= '<th width="150">REALISASI</th>';
//$output .= '<th width="150">DENDA</th>';
$output .= '<th width="150">KETERANGAN SELISIH</th>';
$output .= '</tr>';
$date_awal = getDateAwal($param_arr['p_finance_period_id']);
$date_akhir = getDateAkhir($param_arr['p_finance_period_id1']);
$dbConn = new clsDBConnSIKP();
$query = "SELECT a.p_vat_type_id, upper(a.vat_code) AS jenis_pajak, upper(substring(a.vat_code from 7)) as pajak_text \r\n\t\t\t\tFROM p_vat_type AS a\r\n\t\t\t\tWHERE a.p_vat_type_id NOT IN (7) \r\n\t\t\t\tORDER BY a.p_vat_type_id ASC";
$dbConn->query($query);
$data = array();
while ($dbConn->next_record()) {
$data["p_vat_type_id"][] = $dbConn->f("p_vat_type_id");
$data["jenis_pajak"][] = $dbConn->f("jenis_pajak");
$data["pajak_text"][] = $dbConn->f("pajak_text");
$data["date_awal"][] = $date_awal;
$data["date_akhir"][] = $date_akhir;
}
$dbConn->close();
$pajak_text = '';
$pajak_text = $data['pajak_text'][0];
$item = array();
$total_target_ = 0;
$total_realisasi_ = 0;
$total_piutang_ = 0;
$total_selisih_ = 0;
$total_denda_ = 0;
$grand_total_target_ = 0;
$grand_total_realisasi_ = 0;
$grand_total_selisih_ = 0;
$grand_total_piutang_ = 0;
$grand_total_denda_ = 0;
for ($i = 0; $i < count($data['jenis_pajak']); $i++) {
$result = array();
/*$output .= '<tr>';
$output .= '<td>'.$data['jenis_pajak'][$i].'</td>';
$output .= '<td align="right">target</td>';
$output .= '<td align="right">realisasi</td>';
$output .= '<td align="right">denda</td>';
$output .= '<td align="right">selisih</td>';
$output .= '</tr>';*/
$result = getDataRow($param_arr['p_year_period_id'], $data['p_vat_type_id'][$i], $data['date_awal'][$i], $data['date_akhir'][$i]);
//print_r($result);exit;
$item['realisasiDanPiutang'] = 0;
$item['denda'] = 0;
$item['target'] = 0;
$ayat_sebelum = $result[0]['p_vat_type_dtl_id'];
$ayat_sebelum_kode = $result[0]['ayat'];
//echo count($result);exit;
for ($counter = 0; $counter < count($result); $counter++) {
if ($result[$counter]['p_vat_type_dtl_id'] != $ayat_sebelum) {
if ($data["p_vat_type_id"][$i] == 1 || $data["p_vat_type_id"][$i] == 2 || $data["p_vat_type_id"][$i] == 3 || $data["p_vat_type_id"][$i] == 4) {
$output .= '<tr>';
$output .= '<td>' . $ayat_sebelum_kode . '</td>';
$output .= '<td align="right">' . number_format($item['target'], 0, ',', '.') . ' </td>';
$output .= '<td align="right">' . number_format($item['realisasiDanPiutang'], 0, ',', '.') . '</td>';
$output .= '<td align="right">' . number_format($item['realisasiDanPiutang'] + $item['denda'] - $item['target'], 0, ',', '.') . '</td>';
$output .= '</tr>';
}
$total_target_ = $total_target_ + $item['target'];
$total_realisasi_ = $total_realisasi_ + $item['realisasiDanPiutang'];
$total_selisih_ = $total_selisih_ + ($item['realisasiDanPiutang'] - $item['target']);
$item['realisasiDanPiutang'] = $result[$counter]['realisasi_amt'] + $result[$counter]['debt_amt'];
$item['denda'] = $result[$counter]['denda_pokok'] + $result[$counter]['denda_piutang'];
$item['target'] = $result[$counter]['target_amount'];
$ayat_sebelum = $result[$counter]['p_vat_type_dtl_id'];
$ayat_sebelum_kode = $result[$counter]['ayat'];
$item['target'] = $result[$counter]['target_amount'];
} else {
$item['realisasiDanPiutang'] = $item['realisasiDanPiutang'] + $result[$counter]['realisasi_amt'] + $result[$counter]['debt_amt'];
$item['denda'] = $item['denda'] + $result[$counter]['denda_pokok'] + $result[$counter]['denda_piutang'];
$item['target'] = $item['target'] + $result[$counter]['target_amount'];
}
}
//AYAT TERAKHIR
if ($data["p_vat_type_id"][$i] == 1 || $data["p_vat_type_id"][$i] == 2 || $data["p_vat_type_id"][$i] == 3 || $data["p_vat_type_id"][$i] == 4) {
$output .= '<tr>';
$output .= '<td>' . $ayat_sebelum_kode . '</td>';
$output .= '<td align="right">' . number_format($item['target'], 0, ',', '.') . ' </td>';
$output .= '<td align="right">' . number_format($item['realisasiDanPiutang'], 0, ',', '.') . '</td>';
$output .= '<td align="right">' . number_format($item['realisasiDanPiutang'] + $item['denda'] - $item['target'], 0, ',', '.') . '</td>';
$output .= '</tr>';
}
//DENDA
if ($data["p_vat_type_id"][$i] == 1 || $data["p_vat_type_id"][$i] == 2 || $data["p_vat_type_id"][$i] == 3 || $data["p_vat_type_id"][$i] == 4) {
$output .= '<tr>';
$output .= '<td>DENDA</td>';
$output .= '<td align="right">' . number_format(0, 0, ',', '.') . ' </td>';
$output .= '<td align="right">' . number_format($item['denda'], 0, ',', '.') . '</td>';
$output .= '<td align="right">' . number_format($item['denda'] - 0, 0, ',', '.') . '</td>';
$output .= '</tr>';
}
$total_target_ = $total_target_ + $item['target'];
$total_realisasi_ = $total_realisasi_ + $item['realisasiDanPiutang'] + $item['denda'];
$total_selisih_ = $total_selisih_ + ($item['realisasiDanPiutang'] + $item['denda'] - $item['target']);
//TOTAL PER JENIS PAJAK
$output .= '<tr style="background:#498CD6;font-weight:bold;color:#FFFFFF;">';
$output .= '<td style="padding-left:20px;"> JUMLAH ' . $data["pajak_text"][$i] . '</td>';
$output .= '<td align="right"> ' . number_format($total_target_, 0, ',', '.') . ' </td>';
$output .= '<td align="right"> ' . number_format($total_realisasi_, 0, ',', '.') . '</td>';
$output .= '<td align="right"> ' . number_format($total_selisih_, 0, ',', '.') . ' </td>';
$output .= '</tr>';
$grand_total_target_ = $grand_total_target_ + $total_target_;
$grand_total_realisasi_ = $grand_total_realisasi_ + $total_realisasi_;
$grand_total_selisih_ = $grand_total_selisih_ + $total_selisih_;
$item['realisasiDanPiutang'] = $result[$counter]['realisasi_amt'] + $result[$counter]['debt_amt'];
$item['denda'] = $result[$counter]['denda_pokok'] + $result[$counter]['denda_piutang'];
$item['target'] = $result[$counter]['target_amount'];
$ayat_sebelum = $result[$counter]['p_vat_type_dtl_id'];
$ayat_sebelum_kode = $result[$counter]['ayat'];
$item['target'] = $result[$counter]['target_amount'];
$total_target_ = 0;
$total_realisasi_ = 0;
$total_selisih_ = 0;
}
$output .= '<tr style="background:#000000;font-weight:bold;font-size:14px;color:#FFFFFF;">';
$output .= '<td style="padding-left:20px;"> JUMLAH TOTAL </td>';
$output .= '<td align="right"> ' . number_format($grand_total_target_, 0, ',', '.') . ' </td>';
$output .= '<td align="right"> ' . number_format($grand_total_realisasi_, 0, ',', '.') . '</td>';
$output .= '<td align="right"> ' . number_format($grand_total_selisih_, 0, ',', '.') . ' </td>';
$output .= '</tr>';
$output .= '</table>';
return $output;
}
