<?php
//session_start();
header("Content-Type: application/vnd.ms-excel");
header('Content-Disposition: attachment; filename="Laporan permohonan SIUP.xls"');
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Pragma: public");
//include_once("../includes/class_ez_sql.php");
//include_once('../includes/class_permohonan.php');
//include_once('../includes/class_string.php');
$string = new fstring();
$permohonan = new permohonan();
$tglawal = isset($_GET['tgl1']) && !empty($_GET['tgl1']) ? date("Y-m-d", strtotime($_GET['tgl1'])) . " 00:00:00" : date("Y-m-d") . " 00:00:00";
$tglakhir = isset($_GET['tgl2']) && !empty($_GET['tgl2']) ? date("Y-m-d", strtotime($_GET['tgl2'])) . " 23:59:59" : date("Y-m-d") . " 23:59:00";
$jsiup = isset($_GET['jsiup']) ? $_GET['jsiup'] : -1;
$kecamatan = isset($_GET['kec']) ? $_GET['kec'] : 1;
$desa = isset($_GET['desa']) ? $_GET['desa'] : 1;
$filter = "";
$filter .= " AND a.tglpermohonan >= '{$tglawal}' AND a.tglpermohonan <= '{$tglakhir}'";
$filter .= $kecamatan > 0 ? " AND d.kecamatan_id = '{$kecamatan}'" : "";
$filter .= $desa > 0 ? " AND d.desa_id = '{$desa}'" : "";
$filter .= $jsiup == 1 ? " AND c.modal <= 200000000" : "";
$filter .= $jsiup == 2 ? " AND c.modal > 200000000 AND c.modal <=500000000" : "";
$filter .= $jsiup == 3 ? " AND c.modal > 500000000 AND c.modal <= 10000000000" : "";
$filter .= $jsiup == 4 ? " AND c.modal > 10000000000" : "";
$sql = "\tSELECT a.tglpermohonan,f.status AS spermohonan,a.tglsk,a.nosk,c.nama AS perusahaan,d.nama AS pemilik, c.alamat AS alamat2,c.rt AS rt2,c.rw AS rw2,\r\n\t\t\t\tc.desa AS desa2,c.kecamatan AS kecamatan2,e.bidang, d.alamat AS alamat1,d.rt AS rt1,d.rw AS rw1,\r\n\t\t\t\td.desa AS desa1,d.kecamatan AS kecamatan1,d.nama \r\n\t\t\t\tFROM permohonan a \r\n\t\t\t\tINNER JOIN siup b ON a.id=b.permohonan_id \r\n\t\t\t\tLEFT OUTER JOIN\r\n\t\t\t\t(\r\n\t\t\t\t\tSELECT a.id,a.kualifikasi_id,a.nama,a.kecamatan_id,a.desa_id,a.alamat,a.rt,a.rw,b.kecamatan,c.desa,a.modal \r\n\t\t\t\t\tFROM perusahaan a \r\n\t\t\t\t\tLEFT OUTER JOIN kecamatan b ON a.kecamatan_id=b.id \r\n\t\t\t\t\tLEFT OUTER JOIN desa c ON a.desa_id=c.id \r\n\t\t\t\t) c ON b.perusahaan_id=c.id \t\t\t\t\t\t\t\t\r\n\t\t\t\tLEFT OUTER JOIN \r\n\t\t\t\t(\r\n\t\t\t\t\t\tSELECT a.*,b.kecamatan,c.desa,d.warga \r\n\t\t\t\t\t\tFROM pemohon a \r\n\t\t\t\t\t\tLEFT OUTER JOIN kecamatan b ON a.kecamatan_id=b.id \r\n\t\t\t\t\t\tLEFT OUTER JOIN desa c ON a.desa_id=c.id \r\n\t\t\t\t\t\tLEFT OUTER JOIN warga d ON a.warga_id=d.id \t\t\t\t\t\t \r\n\t\t\t\t) d ON a.pemohon_id=d.id \r\n\t\t\t\tLEFT OUTER JOIN busaha e ON b.busaha_id=e.id \r\n\t\t\t\tLEFT OUTER JOIN spermohonan f ON a.spermohonan_id=f.id \r\n\t\t\t\tWHERE a.ijin_id='4' AND a.spermohonan_id > 1 AND a.spermohonan_id <> 6 {$filter}\r\n\t\t\t\tORDER BY a.tglpermohonan, a.nosk ASC";
//echo $sql;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
function UpdatePermohonan($catatan_bo = '', $id, $jpermohonan_id, $tahun, $noregistrasi, $ijin_id, $tglpermohonan, $nosk, $tglsk, $tglexpired, $pejabat, $nip, $jabatan, $atasnama, $statusbayar, $tglbayar, $retribusi, $jumlahbibit = 0, $namabibit = '', $noagenda = '', $tglmohon = '', $ketbayar = '')
{
global $db;
$string = new fstring();
$tglpermohonan = !empty($tglpermohonan) ? $tglpermohonan : '0000-00-00 00:00:00';
$tglsk = !empty($tglsk) ? $tglsk : '0000-00-00 00:00:00';
$tglexpired = !empty($tglexpired) ? $tglexpired : '0000-00-00 00:00:00';
$tglbayar = !empty($tglbayar) ? $tglbayar : '0000-00-00 00:00:00';
$tglmohon = !empty($tglmohon) ? $tglmohon : '0000-00-00 00:00:00';
if ($ijin_id != '1') {
$retribusi = $string->FormatMoney1($retribusi);
}
//echo $ijin_id;
$tglmohon = $string->IsEmpty($tglmohon) ? '0000-00-00 00:00:00' : ",tglpermohonan='{$tglmohon}'";
$jumlahbibit = is_numeric($jumlahbibit) ? $jumlahbibit : 0;
$sql = "\tUPDATE permohonan \r\n\t\t\t\tSET jpermohonan_id='{$jpermohonan_id}', catatan_bo='{$catatan_bo}', tahun='{$tahun}', noregistrasi='{$noregistrasi}', ijin_id='{$ijin_id}', \r\n\t\t\t\tnosk='{$nosk}', tglsk='{$tglsk}',tglexpired='{$tglexpired}',sbayar='{$statusbayar}',tglbayar='{$tglbayar}',retribusi='{$retribusi}',\r\n\t\t\t\tjumlah_bibit={$jumlahbibit},nama_bibit='{$namabibit}',no_agenda='{$noagenda}',ketbayar='{$ketbayar}' {$tglmohon}\r\n\t\t\t\tWHERE MD5(id)='{$id}'";
//echo $sql;
$db->get_results($sql);
if ($db->get_error()) {
return false;
} else {
return true;
}
}
