<?php

require_once '../../../../config/config.php';
die_login();
//die_app('A');
die_mod('A06');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$status_otorisasi = isset($_REQUEST['status_otorisasi']) ? clean($_REQUEST['status_otorisasi']) : '';
$field1 = isset($_REQUEST['field1']) ? clean($_REQUEST['field1']) : '';
$search1 = isset($_REQUEST['search1']) ? clean($_REQUEST['search1']) : '';
$tgl = f_tgl(date("Y-m-d"));
$query_search = '';
$query_batas = "(SELECT BATAS_DISTRIBUSI FROM CS_PARAMETER_MARK)";
if ($search1 != '') {
    $query_search .= " AND {$field1} LIKE '%{$search1}%' ";
}
/* Pagination */
$query = "\nSELECT \n\tCOUNT(*) AS TOTAL\nFROM \n\tSPP\nWHERE\n\tCONVERT(DATETIME,'{$tgl}',105) > DATEADD(dd,{$query_batas},TANGGAL_SPP)\n\tAND STATUS_SPP = 2\n{$query_search}\n";
$total_data = $conn->execute($query)->fields['TOTAL'];
$total_page = ceil($total_data / $per_page);
$page_num = $page_num > $total_page ? $total_page : $page_num;
$page_start = ($page_num - 1) * $per_page;
/* End Pagination */
?>

<table id="pagging-1" class="t-control w60">
<tr>
	<td>
        $conn->begintrans();
        ex_ha('PM03', 'D');
        $act = array();
        $cb_data = $_REQUEST['cb_data'];
        ex_empty($cb_data, 'Pilih data yang akan dihapus.');
        foreach ($cb_data as $id_del) {
            if ($conn->Execute("DELETE FROM FAKTOR WHERE KODE_FAKTOR = '{$id_del}'")) {
                $act[] = $id_del;
            } else {
                $error = TRUE;
            }
        }
        $msg = $error ? 'Sebagian data gagal dihapus.' : 'Data faktor strategis berhasil dihapus.';
        $conn->committrans();
    } catch (Exception $e) {
        $msg = $e->getmessage();
        $error = TRUE;
        if ($conn) {
            $conn->rollbacktrans();
        }
    }
    close($conn);
    $json = array('error' => $error, 'msg' => $msg);
    echo json_encode($json);
    exit;
}
die_login();
die_app('M');
die_mod('M05');
$conn = conn($sess_db);
die_conn($conn);
Example #3
0
    /*
    # Pelaporan
    case 'C01_proyeksi_penagihan' 		: die_mod('COP01'); die_ha('COP01', 'R'); include('ppjb/laporan/daftar_ppjb/daftar_ppjb_setup.php');break;
    case 'C01_umur_piutang'				: die_mod('COP02'); die_ha('COP02', 'R'); include('ppjb/laporan/daftar_belum_ppjb/daftar_belum_ppjb_setup.php');break;
    case 'C01_spp_lunas_tahunan' 		: die_mod('COP07'); die_ha('COP07', 'R'); include('ppjb/laporan/daftar_ppjb/daftar_ppjb_setup.php');break;
    case 'C01_pembebasan_denda'			: die_mod('COP03'); die_ha('COP03', 'R'); include('ppjb/laporan/daftar_belum_ppjb/daftar_belum_ppjb_setup.php');break;
    case 'C01_pembatalan_spp'	 		: die_mod('COP04'); die_ha('COP04', 'R'); include('ppjb/laporan/daftar_ppjb/daftar_ppjb_setup.php');break;
    case 'C01_status_surat_penagihan'	: die_mod('COP05'); die_ha('COP05', 'R'); include('ppjb/laporan/daftar_belum_ppjb/daftar_belum_ppjb_setup.php');break;
    case 'C01_laporan_tanda_jadi' 		: die_mod('COP06'); die_ha('COP06', 'R'); include('ppjb/laporan/daftar_ppjb/daftar_ppjb_setup.php');break;
    case 'C01_laporan_lain_lain'		: die_mod('COP06'); die_ha('COP06', 'R'); include('ppjb/laporan/daftar_belum_ppjb/daftar_belum_ppjb_setup.php');break;
    */
    # Lain-lain
    case 'C01_parameter_program':
        die_mod('COL01');
        die_ha('COL01', 'R');
        include 'collection_tunai/lain/parameter/parameter_setup.php';
        break;
    case 'C01_registrasi_user':
        die_mod('COL02');
        die_ha('COL02', 'R');
        include 'collection_tunai/lain/registrasi_user/users_setup.php';
        break;
    case 'C01_nomor_surat':
        die_mod('COL03');
        die_ha('COL03', 'R');
        include 'collection_tunai/lain/nomor_surat/nomor_surat_setup.php';
        break;
    case 'C01_spp_tidak_valid':
        include 'collection_tunai/lain/spp_tidak_valid/spp_tidak_valid_setup.php';
        break;
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    try {
        ex_login();
        ex_app('M');
        ex_mod('M13');
        $conn = conn($sess_db);
        ex_conn($conn);
        $conn->begintrans();
        ex_ha('M13', 'U');
        ex_empty($nomor_id, 'Nomor id harus diisi.');
        $query = "\n\t\t\tDELETE FROM CLUB_PERSONAL\n\t\t\tWHERE\n\t\t\t\tNOMOR_ID = '{$id}' AND JABATAN_KLUB = '5'\n\t\t\t";
        ex_false($conn->Execute($query), $query);
        $msg = 'Data Club personal berhasil dihapus.';
        $conn->committrans();
    } catch (Exception $e) {
        $msg = $e->getmessage();
        $error = TRUE;
        if ($conn) {
            $conn->rollbacktrans();
        }
    }
    close($conn);
    $json = array('error' => $error, 'msg' => $msg);
    echo json_encode($json);
    exit;
}
die_login();
die_app('M');
die_mod('M13');
$conn = conn($sess_db);
die_conn($conn);
Example #5
0
                }
            }
            $msg = $error ? 'Sebagian data gagal dihapus.' : 'Data Jenis PAIJB berhasil dihapus.';
        }
        $conn->committrans();
    } catch (Exception $e) {
        $msg = $e->getmessage();
        $error = TRUE;
        if ($conn) {
            $conn->rollbacktrans();
        }
    }
    close($conn);
    $json = array('act' => $act, 'error' => $error, 'msg' => $msg);
    echo json_encode($json);
    // echo json_encode($val);
    // echo $msg;
    exit;
}
die_login();
// die_app('P');
die_mod('P04');
$conn = conn($sess_db);
die_conn($conn);
if ($act == 'Ubah') {
    $query = "SELECT * FROM CS_JENIS_PAIJB WHERE KODE_JENIS = '{$id}'";
    $obj = $conn->execute($query);
    $kode_jenis = $obj->fields['KODE_JENIS'];
    $nama_jenis = $obj->fields['NAMA_JENIS'];
    $nama_file = $obj->fields['NAMA_FILE'];
}
<?php

require_once '../../../../../config/config.php';
die_login();
// die_app('C');
die_mod('K11');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$field1 = isset($_REQUEST['field1']) ? clean($_REQUEST['field1']) : '';
$search1 = isset($_REQUEST['search1']) ? clean($_REQUEST['search1']) : '';
$query_search = '';
if ($search1 != '') {
    $query_search .= " WHERE {$field1} LIKE '%{$search1}%' ";
}
/* Pagination */
$query = "\nSELECT \n\tCOUNT(*) AS TOTAL\nFROM \n\tSPP\n{$query_search}\n";
$total_data = $conn->execute($query)->fields['TOTAL'];
$total_page = ceil($total_data / $per_page);
$page_num = $page_num > $total_page ? $total_page : $page_num;
$page_start = ($page_num - 1) * $per_page;
/* End Pagination */
?>

<table id="pagging-1" class="t-control w60">
<tr>
	<td>
		<input type="button" id="bank" value=" Bank ">
	</td>
	<td class="text-right">
Example #7
0
<?php

require_once '../../../../config/config.php';
die_login();
die_app('M');
die_mod('M02');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$s_opf1 = isset($_REQUEST['s_opf1']) ? clean($_REQUEST['s_opf1']) : '';
$s_opv1 = isset($_REQUEST['s_opv1']) ? clean($_REQUEST['s_opv1']) : '';
$query_search = '';
if ($s_opv1 != '') {
    $query_search .= " WHERE {$s_opf1} LIKE '%{$s_opv1}%' ";
}
# Pagination
$query = "\nSELECT \n\tCOUNT(KODE_DESA) AS TOTAL\nFROM \n\tDESA\n{$query_search}\n";
$total_data = $conn->Execute($query)->fields['TOTAL'];
$total_page = ceil($total_data / $per_page);
$page_num = $page_num > $total_page ? $total_page : $page_num;
$page_start = ($page_num - 1) * $per_page;
# End Pagination
?>

<table id="pagging-1" class="t-control w40">
<tr>
	<td>
		<input type="button" id="tambah" value=" Tambah ">
	</td>
	
<?php

require_once '../../../../../../config/config.php';
die_login();
// die_app('C');
die_mod('C25');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$tgl = '02-12-2006';
$query_blok_lunas = '';
$query_pemb_jt = '';
$query_tglmerah = '';
$query_libur = '';
$query_blok_lunas .= "(SELECT A.KODE_BLOK,B.SUMOFREALISASI,A.SUMOFPLAN,(B.SUMOFREALISASI-A.SUMOFPLAN) AS REMAIN FROM (\n\tSELECT SUM (A.NILAI) as SUMOFPLAN, A.KODE_BLOK from( \n\tselect A.KODE_BLOK,A.TANGGAL_TANDA_JADI AS TANGGAL,ISNULL(A.TANDA_JADI,0) AS NILAI from spp A where A.KODE_BLOK is not null\n\tUNION ALL\n\tSELECT A.KODE_BLOK,A.TANGGAL,ISNULL(A.NILAI,0) FROM RENCANA A WHERE A.KODE_BLOK IS NOT NULL)a GROUP BY a.KODE_BLOK) A LEFT\n\tJOIN (\n\tSELECT SUM(A.NILAI) AS SUMOFREALISASI,A.KODE_BLOK FROM REALISASI A GROUP BY  A.KODE_BLOK)B ON A.KODE_BLOK=B.KODE_BLOK\n\twhere (B.SUMOFREALISASI-A.SUMOFPLAN)>=0)C";
$query_pemb_jt .= "(SELECT PEMB_JATUH_TEMPO FROM CS_PARAMETER_COL)";
$query_tglmerah = "SELECT COUNT(*) FROM CS_HARI_LIBUR a WHERE a.tanggal_awal<=@CUR_DATE AND @CUR_DATE<=a.tanggal_akhir)";
$query_pemby_terakhir = "(SELECT KODE_BLOK, MAX(TANGGAL) AS TGL FROM RENCANA GROUP BY KODE_BLOK ) c";
# Pagination
$query = "\nSELECT COUNT(*) AS TOTAL FROM SPP \nWHERE \n(select dbo.kurang_tgl(TGL_SRT_PEMBERITAHUAN_SPK_TLK,14)) = CONVERT(DATETIME,'{$tgl}',105) \n";
$total_data = $conn->execute($query)->fields['TOTAL'];
$total_page = ceil($total_data / $per_page);
$page_num = $page_num > $total_page ? $total_page : $page_num;
$page_start = ($page_num - 1) * $per_page;
# End Pagination
?>

<table id="pagging-1" class="t-control">
<tr>
	<td>
        $conn->committrans();
    } catch (Exception $e) {
        $msg = $e->getmessage();
        $error = TRUE;
        if ($conn) {
            $conn->rollbacktrans();
        }
    }
    close($conn);
    $json = array('act' => $act, 'error' => $error, 'msg' => $msg);
    echo json_encode($json);
    exit;
}
die_login();
// die_app('C');
die_mod('C03');
$conn = conn($sess_db);
die_conn($conn);
if ($act == 'Detail') {
    $query = "\n\tSELECT *\n\tFROM\n\t\tSPP a \n\t\tLEFT JOIN STOK b ON a.KODE_BLOK = b.KODE_BLOK\n\t\tLEFT JOIN TIPE c ON b.KODE_TIPE = c.KODE_TIPE\n\t\tLEFT JOIN HARGA_TANAH d ON b.KODE_SK_TANAH = d.KODE_SK\n\t\tLEFT JOIN HARGA_BANGUNAN e ON b.KODE_SK_BANGUNAN = e.KODE_SK\n\t\tLEFT JOIN FAKTOR f ON b.KODE_FAKTOR = f.KODE_FAKTOR\n\tWHERE \n\t\ta.KODE_BLOK = '{$id}'";
    $obj = $conn->execute($query);
    $kode_blok = $obj->fields['KODE_BLOK'];
    $nama_pembeli = $obj->fields['NAMA_PEMBELI'];
    $alamat = $obj->fields['ALAMAT_RUMAH'];
    $tlp1 = $obj->fields['TELP_RUMAH'];
    $tanggal_spp = kontgl(tgltgl(date("d M Y", strtotime($obj->fields['TANGGAL_SPP']))));
    $no_identitas = $obj->fields['NO_IDENTITAS'];
    $npwp = $obj->fields['NPWP'];
    $luas_tanah = $obj->fields['LUAS_TANAH'];
    $luas_bangunan = $obj->fields['LUAS_BANGUNAN'];
    $nomor_customer = $obj->fields['NOMOR_CUSTOMER'];
<?php

require_once '../../../../../config/config.php';
die_login();
// die_app('C');
die_mod('C28');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$nama_bulan = isset($_REQUEST['nama_bulan']) ? clean($_REQUEST['nama_bulan']) : '';
$page_num = isset($_REQUEST['page_num']) ? clean($_REQUEST['page_num']) : 1;
$tahun = isset($_REQUEST['tahun']) ? clean($_REQUEST['tahun']) : '';
$array_bulan = array(1 => 'Januari', 'Februari', 'Maret', 'April', 'Mei', 'Juni', 'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember');
$query_blok_lunas = "SELECT C.KODE_BLOK FROM ( SELECT A.KODE_BLOK,B.SUMOFREALISASI,A.SUMOFPLAN,(B.SUMOFREALISASI-A.SUMOFPLAN) AS REMAIN FROM \n( SELECT SUM (A.NILAI) as SUMOFPLAN, A.KODE_BLOK from ( select A.KODE_BLOK,A.TANGGAL_TANDA_JADI AS TANGGAL,ISNULL(A.TANDA_JADI,0) \nAS NILAI from spp A where A.KODE_BLOK is not null UNION ALL SELECT A.KODE_BLOK,A.TANGGAL,ISNULL(A.NILAI,0) FROM RENCANA A WHERE A.KODE_BLOK IS NOT NULL\n)a GROUP BY a.KODE_BLOK ) A LEFT JOIN (SELECT SUM(A.NILAI) AS SUMOFREALISASI,A.KODE_BLOK FROM REALISASI A GROUP BY  A.KODE_BLOK)B \nON A.KODE_BLOK=B.KODE_BLOK where (B.SUMOFREALISASI-A.SUMOFPLAN)>=0 )C LEFT JOIN SPP D ON C.KODE_BLOK = D.KODE_BLOK\nWHERE C.REMAIN - (ISNULL(D.NILAI_CAIR_KPR,0)) >= 0\n";
$tahun_depan = $tahun + 1;
/* Pagination */
$query = "\nSELECT COUNT(*) AS TOTAL\nFROM \n\tSPP a JOIN REALISASI b \n\tON a.KODE_BLOK = b.KODE_BLOK\nWHERE\n\ta.KODE_BLOK IN ({$query_blok_lunas}) \n\tAND b.TANGGAL >= CONVERT(DATETIME,'{$tahun}',105) \n\tAND b.TANGGAL < CONVERT(DATETIME,'{$tahun_depan}',105)\n";
$total_data = $conn->execute($query)->fields['TOTAL'];
$total_page = ceil($total_data / $per_page);
$set_jrp = '
<tr><td colspan="8" class="nb text-center"><b> LAPORAN DAFTAR SPP LUNAS TAHUNAN </b></td></tr>
<tr><td colspan="8" class="nb text-center"> Periode Lunas Tahun ' . $tahun . ' </td></tr>
<tr>
	<td colspan="6" class="nb">
	</td>
	<td colspan="2" class="nb">Halaman 
';
$set_th = '
	dari ' . $total_page . '</td>
</tr>
<?php

require_once '../../../../../../config/config.php';
die_login();
// die_app('C');
die_mod('C23');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$tgl = f_tgl(date("Y-m-d"));
$query_blok_lunas = '';
$query_pemb_jt = '';
$query_tglmerah = '';
$query_libur = '';
$query_blok_lunas .= "(SELECT A.KODE_BLOK,B.SUMOFREALISASI,A.SUMOFPLAN,(B.SUMOFREALISASI-A.SUMOFPLAN) AS REMAIN FROM (\n\tSELECT SUM (A.NILAI) as SUMOFPLAN, A.KODE_BLOK from( \n\tselect A.KODE_BLOK,A.TANGGAL_TANDA_JADI AS TANGGAL,ISNULL(A.TANDA_JADI,0) AS NILAI from spp A where A.KODE_BLOK is not null\n\tUNION ALL\n\tSELECT A.KODE_BLOK,A.TANGGAL,ISNULL(A.NILAI,0) FROM RENCANA A WHERE A.KODE_BLOK IS NOT NULL)a GROUP BY a.KODE_BLOK) A LEFT\n\tJOIN (\n\tSELECT SUM(A.NILAI) AS SUMOFREALISASI,A.KODE_BLOK FROM REALISASI A GROUP BY  A.KODE_BLOK)B ON A.KODE_BLOK=B.KODE_BLOK\n\twhere (B.SUMOFREALISASI-A.SUMOFPLAN)>=0)C";
$query_pemb_jt .= "(SELECT PEMB_JATUH_TEMPO FROM CS_PARAMETER_COL)";
$query_tglmerah = "SELECT COUNT(*) FROM CS_HARI_LIBUR a WHERE a.tanggal_awal<=@CUR_DATE AND @CUR_DATE<=a.tanggal_akhir)";
$query_pemby_terakhir = "(SELECT KODE_BLOK, MAX(TANGGAL) AS TGL FROM RENCANA GROUP BY KODE_BLOK ) c";
# Pagination
$query = "\nSELECT COUNT(*) AS TOTAL FROM SPP \nWHERE \n(select dbo.kurang_tgl(TGL_SRT_PERUBAHAN_PLAFON,14))= CONVERT(DATETIME,'{$tgl}',105) \n";
$total_data = $conn->execute($query)->fields['TOTAL'];
$total_page = ceil($total_data / $per_page);
$page_num = $page_num > $total_page ? $total_page : $page_num;
$page_start = ($page_num - 1) * $per_page;
# End Pagination
?>

<table id="pagging-1" class="t-control">
<tr>
	<td>
<?php

require_once '../../../../../config/config.php';
die_login();
// die_app('C');
die_mod('C37');
$conn = conn($sess_db);
die_conn($conn);
$query = "SELECT * FROM CS_PARAMETER_COL";
$obj = $conn->Execute($query);
?>

<table class="t-popup pad wauto">
<tr class="input_label">
<tr>
      <td>Tanggal Efektif Program (Cut Off) </td>
      <td><input class="text-right" type="text" name="tanggal_efektif_prog" id="tanggal_efektif_prog" size="15" class="apply dd-mm-yyyy" value="<?php 
echo tgltgl(date("d-m-Y", strtotime($obj->fields['TANGGAL_EFEKTIF_PROG'])));
?>
"></td></td>
</tr>
<tr>
      <td>Nilai Sisa Tagihan dianggap Lunas s/d </td>
      <td><input type="text" class="text-right" name="nilai_sisa_tagihan" id="nilai_sisa_tagihan" size="10" value="<?php 
echo to_money($obj->fields['NILAI_SISA_TAGIHAN']);
?>
"></td></td>
</tr>
<tr>
      <td>Masa Berlaku Denda </td>
      <td><input type="text" class="text-right" name="masa_berlaku_denda" id="masa_berlaku_denda" size="10" value="<?php 
<?php

require_once '../../../../../config/config.php';
die_login();
// die_app('C');
die_mod('C05');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$status_otorisasi = isset($_REQUEST['status_otorisasi']) ? clean($_REQUEST['status_otorisasi']) : '';
$field1 = isset($_REQUEST['field1']) ? clean($_REQUEST['field1']) : '';
$search1 = isset($_REQUEST['search1']) ? clean($_REQUEST['search1']) : '';
$query_search = '';
if ($search1 != '') {
    $query_search .= " AND {$field1} LIKE '%{$search1}%' ";
}
/* Pagination */
$query = "\nSELECT \n\tCOUNT(*) AS TOTAL\nFROM \n\tSPP\nWHERE STATUS_WANPRESTASI = '1'\n{$query_search}\n";
$total_data = $conn->execute($query)->fields['TOTAL'];
$total_page = ceil($total_data / $per_page);
$page_num = $page_num > $total_page ? $total_page : $page_num;
$page_start = ($page_num - 1) * $per_page;
/* End Pagination */
?>

<table id="pagging-1" class="t-control w60">
<tr>
	<td>
		<input type="button" id="pemulihan" value=" Pemulihan Wanprestasi ">
	</td>
<?php

require_once '../../../../../config/config.php';
die_login();
// die_app('C');
die_mod('C26');
$conn = conn($sess_db);
die_conn($conn);
$per_page = 100000000000.0;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$periode_awal = isset($_REQUEST['periode_awal']) ? clean($_REQUEST['periode_awal']) : '';
$periode_akhir = isset($_REQUEST['periode_akhir']) ? clean($_REQUEST['periode_akhir']) : '';
$field1 = isset($_REQUEST['field1']) ? clean($_REQUEST['field1']) : '';
$search1 = isset($_REQUEST['search1']) ? clean($_REQUEST['search1']) : '';
$tanggal = f_tgl(date("Y-m-d"));
$pecah_tanggal = explode("-", $tanggal);
$tgl = $pecah_tanggal[0];
$bln = $pecah_tanggal[1];
$thn = $pecah_tanggal[2];
$array_bulan = array(1 => 'Januari', 'Februari', 'Maret', 'April', 'Mei', 'Juni', 'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember');
$array_bulan[0] = 'Desember';
$a = 0;
while ($a < 6) {
    $next_bulan = $bln + 1 + $a;
    $next_tahun = $thn;
    if ($next_bulan > 12) {
        $next_bulan = $next_bulan % 12;
        $next_tahun = $thn + 1;
    }
    $proyeksi_bulan[$a] = $array_bulan[$next_bulan] . ' ' . $next_tahun;
    $a++;
Example #15
0
        $conn->committrans();
    } catch (Exception $e) {
        $msg = $e->getmessage();
        $error = TRUE;
        if ($conn) {
            $conn->rollbacktrans();
        }
    }
    close($conn);
    $json = array('act' => $act, 'error' => $error, 'msg' => $msg);
    echo json_encode($json);
    exit;
}
die_login();
die_app('M');
die_mod('M18');
$conn = conn($sess_db);
die_conn($conn);
if ($act == 'Ubah') {
    $query = "SELECT * FROM SPP WHERE KODE_BLOK = '{$id}'";
    $obj = $conn->execute($query);
    $tgl_spp = tgltgl(f_tgl($obj->fields['TANGGAL_SPP']));
    $no_spp = $obj->fields['NOMOR_SPP'];
    $nama = $obj->fields['NAMA_PEMBELI'];
    $alamat_rumah = $obj->fields['ALAMAT_RUMAH'];
    $alamat_surat = $obj->fields['ALAMAT_SURAT'];
    $alamat_npwp = $obj->fields['ALAMAT_NPWP'];
    $email = $obj->fields['ALAMAT_EMAIL'];
    $tlp_rumah = $obj->fields['TELP_RUMAH'];
    $tlp_kantor = $obj->fields['TELP_KANTOR'];
    $tlp_lain = $obj->fields['TELP_LAIN'];
<?php

require_once '../../../../config/config.php';
die_login();
die_app('M');
die_mod('M11');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$s_opf1 = isset($_REQUEST['s_opf1']) ? clean($_REQUEST['s_opf1']) : '';
$s_opv1 = isset($_REQUEST['s_opv1']) ? clean($_REQUEST['s_opv1']) : '';
$query_search = '';
if ($s_opv1 != '') {
    $query_search .= " WHERE {$s_opf1} LIKE '%{$s_opv1}%' ";
}
# Pagination
$query = "\nSELECT \n\tCOUNT(KODE_BAYAR) AS TOTAL\nFROM \n\tJENIS_PEMBAYARAN \n{$query_search}\n";
$total_data = $conn->Execute($query)->fields['TOTAL'];
$total_page = ceil($total_data / $per_page);
$page_num = $page_num > $total_page ? $total_page : $page_num;
$page_start = ($page_num - 1) * $per_page;
# End Pagination
?>

<table id="pagging-1" class="t-control w40">
<tr>
	<td>
		<input type="button" id="tambah" value=" Tambah ">
		<input type="button" id="hapus" value=" Hapus ">
	</td>
                } else {
                    $error = TRUE;
                }
            }
            $msg = $error ? 'Sebagian data gagal dihapus.' : 'Data hari libur berhasil dihapus.';
        }
        $conn->committrans();
    } catch (Exception $e) {
        $msg = $e->getmessage();
        $error = TRUE;
        if ($conn) {
            $conn->rollbacktrans();
        }
    }
    close($conn);
    $json = array('act' => $act, 'error' => $error, 'msg' => $msg);
    echo json_encode($json);
    exit;
}
die_login();
// die_app('C');
die_mod('C02');
$conn = conn($sess_db);
die_conn($conn);
if ($act == 'Ubah') {
    $query = "SELECT * FROM CS_HARI_LIBUR WHERE TANGGAL_AWAL = CONVERT(DATETIME,'{$id}',105)";
    $obj = $conn->execute($query);
    $tanggal_awal = tgltgl(date("d-m-Y", strtotime($obj->fields['TANGGAL_AWAL'])));
    $tanggal_akhir = tgltgl(date("d-m-Y", strtotime($obj->fields['TANGGAL_AKHIR'])));
    $keterangan = $obj->fields['KETERANGAN'];
}
<?php

require_once '../../../../../../config/config.php';
die_login();
// die_app('C');
die_mod('C14');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$tgl = f_tgl(date("Y-m-d"));
$query_blok_lunas = '';
$query_pemb_jt = '';
$query_tglmerah = '';
$query_libur = '';
$query_blok_lunas = "SELECT C.KODE_BLOK FROM ( SELECT A.KODE_BLOK,B.SUMOFREALISASI,A.SUMOFPLAN,(B.SUMOFREALISASI-A.SUMOFPLAN) AS REMAIN FROM \n( SELECT SUM (A.NILAI) as SUMOFPLAN, A.KODE_BLOK from ( select A.KODE_BLOK,A.TANGGAL_TANDA_JADI AS TANGGAL,ISNULL(A.TANDA_JADI,0) \nAS NILAI from spp A where A.KODE_BLOK is not null UNION ALL SELECT A.KODE_BLOK,A.TANGGAL,ISNULL(A.NILAI,0) FROM RENCANA A WHERE A.KODE_BLOK IS NOT NULL\n)a GROUP BY a.KODE_BLOK ) A LEFT JOIN (SELECT SUM(A.NILAI) AS SUMOFREALISASI,A.KODE_BLOK FROM REALISASI A GROUP BY  A.KODE_BLOK)B \nON A.KODE_BLOK=B.KODE_BLOK where (B.SUMOFREALISASI-A.SUMOFPLAN)>=0 )C LEFT JOIN SPP D ON C.KODE_BLOK = D.KODE_BLOK\nWHERE C.REMAIN - (ISNULL(D.NILAI_CAIR_KPR,0)) >= 0\n";
$query_pemb_jt .= "(SELECT PEMB_JATUH_TEMPO FROM CS_PARAMETER_COL)";
$query_tglmerah = "SELECT COUNT(*) FROM CS_HARI_LIBUR a WHERE a.tanggal_awal<=@CUR_DATE AND @CUR_DATE<=a.tanggal_akhir)";
$query_pemby_terakhir = "(SELECT KODE_BLOK, MAX(TANGGAL) AS TGL FROM RENCANA GROUP BY KODE_BLOK ) c";
# Pagination
$query = "\nSELECT COUNT(*) AS TOTAL\nFROM \n\t{$query_pemby_terakhir} \nwhere \n\t(select dbo.kurang_tgl(c.TGL,30))= CONVERT(DATETIME,'{$tgl}',105) AND \n\tc.KODE_BLOK NOT IN({$query_blok_lunas})\n";
echo $query . '<br>' . $query_blok_lunas;
$total_data = $conn->execute($query)->fields['TOTAL'];
$total_page = ceil($total_data / $per_page);
$page_num = $page_num > $total_page ? $total_page : $page_num;
$page_start = ($page_num - 1) * $per_page;
# End Pagination
?>

<table id="pagging-1" class="t-control">
<tr>
Example #19
0
<?php

require_once '../../../../config/config.php';
die_login();
die_app('M');
die_mod('M16');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$field1 = isset($_REQUEST['field1']) ? clean($_REQUEST['field1']) : '';
$search1 = isset($_REQUEST['search1']) ? clean($_REQUEST['search1']) : '';
$field2 = isset($_REQUEST['field2']) ? clean($_REQUEST['field2']) : '';
$periode = isset($_REQUEST['periode']) ? clean($_REQUEST['periode']) : date('d-m-Y');
$status_otorisasi = isset($_REQUEST['status_otorisasi']) ? clean($_REQUEST['status_otorisasi']) : '';
$tombol = isset($_REQUEST['tombol']) ? clean($_REQUEST['tombol']) : '';
$nama_tombol = isset($_REQUEST['nama_tombol']) ? clean($_REQUEST['nama_tombol']) : '';
$query_search = '';
$query_batas = "(SELECT BATAS_DISTRIBUSI FROM CS_PARAMETER_MARK)";
if ($status_otorisasi == 0) {
    $query_search .= "WHERE OTORISASI = '0' ";
} else {
    if ($status_otorisasi == 1) {
        $query_search .= "WHERE OTORISASI = '1' ";
    } else {
        if ($status_otorisasi == 2) {
            $query_search .= "WHERE KODE_BLOK != '' ";
        }
    }
}
if ($search1 != '') {
Example #20
0
<?php

require_once '../../../../config/config.php';
die_login();
die_app('M');
die_mod('M04');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$s_opf1 = isset($_REQUEST['s_opf1']) ? clean($_REQUEST['s_opf1']) : '';
$s_opv1 = isset($_REQUEST['s_opv1']) ? clean($_REQUEST['s_opv1']) : '';
$query_search = '';
if ($s_opv1 != '') {
    $query_search .= " WHERE {$s_opf1} LIKE '%{$s_opv1}%' ";
}
# Pagination
$query = "\nSELECT \n\tCOUNT(KODE_TIPE) AS TOTAL\nFROM \n\tTIPE\n{$query_search}\n";
$total_data = $conn->Execute($query)->fields['TOTAL'];
$total_page = ceil($total_data / $per_page);
$page_num = $page_num > $total_page ? $total_page : $page_num;
$page_start = ($page_num - 1) * $per_page;
# End Pagination
?>

<table id="pagging-1" class="t-control w40">
<tr>
	<td>
		<input type="button" id="tambah" value=" Tambah ">
		<input type="button" id="hapus" value=" Hapus ">
	</td>
<?php

require_once '../../../../config/config.php';
die_login();
die_app('A01');
die_mod('PT02');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$s_opf1 = isset($_REQUEST['s_opf1']) ? clean($_REQUEST['s_opf1']) : '';
$s_opv1 = isset($_REQUEST['s_opv1']) ? clean($_REQUEST['s_opv1']) : '';
$query_search = '';
if ($s_opv1 != '') {
    $query_search .= "WHERE {$s_opf1} LIKE '%{$s_opv1}%' ";
}
# Pagination
$query = "\nSELECT  \n\tCOUNT(KODE_BLOK) AS TOTAL\nFROM \n\tRESERVE\n{$query_search}\n";
$total_data = $conn->Execute($query)->fields['TOTAL'];
$total_page = ceil($total_data / $per_page);
$page_num = $page_num > $total_page ? $total_page : $page_num;
$page_start = ($page_num - 1) * $per_page;
# End Pagination
?>

<table id="pagging-1" class="t-control">
<tr>
	<td class="text-right">
		<input type="button" id="prev_page" value=" < ">
		Hal : <input type="text" name="page_num" size="5" class="page_num apply text-center" value="<?php 
echo $page_num;
<?php

require_once '../../../../../config/config.php';
die_login();
// die_app('C');
die_mod('C30');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$periode_awal = isset($_REQUEST['periode_awal']) ? clean($_REQUEST['periode_awal']) : '';
$periode_akhir = isset($_REQUEST['periode_akhir']) ? clean($_REQUEST['periode_akhir']) : '';
$query_search = '';
if ($periode_awal != '' || $periode_akhir != '') {
    $query_search .= "AND TANGGAL_MEMO >= CONVERT(DATETIME,'{$periode_awal}',105) AND TANGGAL_MEMO <= CONVERT(DATETIME,'{$periode_akhir}',105)";
}
/* Pagination */
$query = "\nSELECT \n\tCOUNT(NOMOR_MEMO) AS TOTAL_DATA\n\tFROM CS_MEMO_PEMBATALAN\n\tWHERE NOMOR_MEMO != ' ' {$query_search}\n\tGROUP BY NOMOR_MEMO\t\n";
$total_data = $conn->execute($query)->fields['TOTAL_DATA'];
$total_page = ceil($total_data / $per_page);
$page_num = $page_num > $total_page ? $total_page : $page_num;
$page_start = ($page_num - 1) * $per_page;
/* End Pagination */
?>

<table id="pagging-1" class="t-control w60">
<tr>
	<td>
		<input type="button" id="excel" value=" Excel ">
		<input type="button" id="print" value=" Print ">
	</td>
<?php

require_once '../../../../../config/config.php';
die_login();
// die_app('P');
die_mod('P09');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$field1 = isset($_REQUEST['field1']) ? clean($_REQUEST['field1']) : '';
$search1 = isset($_REQUEST['search1']) ? clean($_REQUEST['search1']) : '';
$query_search = '';
if ($search1 != '') {
    $query_search .= " WHERE {$field1} LIKE '%{$search1}%' ";
}
/* Pagination */
$query = "\nSELECT \n\tCOUNT(*) AS TOTAL\nFROM \n\tCS_PENGALIHAN_HAK\n{$query_search}\n";
$total_data = $conn->execute($query)->fields['TOTAL'];
$total_page = ceil($total_data / $per_page);
$page_num = $page_num > $total_page ? $total_page : $page_num;
$page_start = ($page_num - 1) * $per_page;
/* End Pagination */
?>

<table id="pagging-1" class="t-control w60">
<tr>
	<td>
		<input type="button" id="tambah" value=" Pengalihan Hak ">
	</td>
	<td class="text-right">
Example #24
0
<?php

require_once '../../../../../config/config.php';
die_login();
// die_app('P');
die_mod('P06');
$conn = conn($sess_db);
die_conn($conn);
$act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : '';
$id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : '';
?>

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<!-- CSS -->
<link type="text/css" href="../../../../../config/css/style.css" rel="stylesheet">
<link type="text/css" href="../../../../../plugin/css/zebra/default.css" rel="stylesheet">

<link type="text/css" href="../../../../../plugin/window/themes/default.css" rel="stylesheet">
<link type="text/css" href="../../../../../plugin/window/themes/mac_os_x.css" rel="stylesheet">

<!-- JS -->
<script type="text/javascript" src="../../../../../plugin/js/jquery-1.10.2.min.js"></script>
<script type="text/javascript" src="../../../../../plugin/js/jquery-migrate-1.2.1.min.js"></script>
<script type="text/javascript" src="../../../../../plugin/js/jquery.inputmask.custom.js"></script>
<script type="text/javascript" src="../../../../../plugin/js/keymaster.js"></script>
<script type="text/javascript" src="../../../../../plugin/js/zebra_datepicker.js"></script>
<script type="text/javascript" src="../../../../../config/js/main.js"></script>
        $conn->committrans();
    } catch (Exception $e) {
        $msg = $e->getmessage();
        $error = TRUE;
        if ($conn) {
            $conn->rollbacktrans();
        }
    }
    close($conn);
    $json = array('act' => $act, 'error' => $error, 'msg' => $msg);
    echo json_encode($json);
    exit;
}
die_login();
// die_app('C');
die_mod('C01');
$conn = conn($sess_db);
die_conn($conn);
if ($act == 'Ubah') {
    $query = "\n\tSELECT *\n\tFROM\n\t\tSPP a\n\t\tLEFT JOIN STOK b ON a.KODE_BLOK = b.KODE_BLOK \n\t\tLEFT JOIN TIPE c ON b.KODE_TIPE = c.KODE_TIPE\n\t\tLEFT JOIN HARGA_TANAH d ON b.KODE_SK_TANAH = d.KODE_SK\n\t\tLEFT JOIN HARGA_BANGUNAN e ON b.KODE_SK_BANGUNAN = e.KODE_SK\n\t\tLEFT JOIN FAKTOR f ON b.KODE_FAKTOR = f.KODE_FAKTOR\n\n\tWHERE a.KODE_BLOK = '{$id}'";
    $obj = $conn->execute($query);
    $tgl_spp = tgltgl(f_tgl($obj->fields['TANGGAL_SPP']));
    $no_spp = $obj->fields['NOMOR_SPP'];
    $costumer_id = $obj->fields['COSTUMER_ID'];
    $no_customer = $obj->fields['NOMOR_CUSTOMER'];
    $nama = $obj->fields['NAMA_PEMBELI'];
    $alamat_rumah = $obj->fields['ALAMAT_RUMAH'];
    $alamat_surat = $obj->fields['ALAMAT_SURAT'];
    $alamat_npwp = $obj->fields['ALAMAT_NPWP'];
    $email = $obj->fields['ALAMAT_EMAIL'];
    $tlp_rumah = $obj->fields['TELP_RUMAH'];
Example #26
0
<?php

require_once '../../../../config/config.php';
die_login();
die_app('M');
die_mod('M01');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$s_opf1 = isset($_REQUEST['s_opf1']) ? clean($_REQUEST['s_opf1']) : '';
$s_opv1 = isset($_REQUEST['s_opv1']) ? clean($_REQUEST['s_opv1']) : '';
$query_search = '';
if ($s_opv1 != '') {
    $query_search .= " WHERE {$s_opf1} LIKE '%{$s_opv1}%' ";
}
# Pagination
$query = "\nSELECT \n\tCOUNT(KODE_LOKASI) AS TOTAL\nFROM \n\tLOKASI \n{$query_search}\n";
$total_data = $conn->Execute($query)->fields['TOTAL'];
$total_page = ceil($total_data / $per_page);
$page_num = $page_num > $total_page ? $total_page : $page_num;
$page_start = ($page_num - 1) * $per_page;
# End Pagination
?>

<table id="pagging-1" class="t-control w40">
<tr>
	<td>
		<input type="button" id="tambah" value=" Tambah ">
		<input type="button" id="hapus" value=" Hapus ">
	</td>
        $conn->committrans();
    } catch (Exception $e) {
        $msg = $e->getmessage();
        $error = TRUE;
        if ($conn) {
            $conn->rollbacktrans();
        }
    }
    close($conn);
    $json = array('act' => $act, 'error' => $error, 'msg' => $msg);
    echo json_encode($json);
    exit;
}
die_login();
die_app('M');
die_mod('M15');
$conn = conn($sess_db);
die_conn($conn);
if ($act == 'Ubah') {
    $obj = $conn->Execute("\n\t\tSELECT  \n\t\ts.NO_VA,\n\t\ts.KODE_BLOK,\n\t\ts.LUAS_BANGUNAN,\n\t\ts.STATUS_STOK,\n\t\ts.TERJUAL,\n\t\ts.KODE_PENJUALAN,\n\t\tt.TIPE_BANGUNAN,\n\t\ths.KODE_SK,\n\t\ths.HARGA_CASH_KERAS,\n\t\ths.CB36X,\n\t\ths.CB48X,\n\t\ths.KPA24X,\n\t\ths.KPA36X,\n\t\th.*,\n\t\tju.*,\n\t\tt.*,\n\t\tp.*\n\t\tFROM \n\t\tSTOK s\n\t\tLEFT JOIN TIPE t ON s.KODE_TIPE = t.KODE_TIPE\n\t\tLEFT JOIN HARGA_SK hs ON s.KODE_SK = hs.KODE_SK AND s.KODE_BLOK = hs.KODE_BLOK\n\t\tLEFT JOIN LOKASI h ON s.KODE_LOKASI = h.KODE_LOKASI\n\t\tLEFT JOIN JENIS_UNIT ju ON s.KODE_UNIT = ju.KODE_UNIT\n\t\tLEFT JOIN JENIS_PENJUALAN p ON s.KODE_PENJUALAN = p.KODE_JENIS\n\t\tWHERE\t\t\n\t\ts.KODE_BLOK = '{$id}'");
    $no_va = $obj->fields['NO_VA'];
    $kode_blok = $obj->fields['KODE_BLOK'];
    $kode_lokasi = $obj->fields['KODE_LOKASI'];
    $kode_unit = $obj->fields['KODE_UNIT'];
    $kode_tipe = $obj->fields['KODE_TIPE'];
    $kode_penjualan = $obj->fields['KODE_PENJUALAN'];
    $kode_sk = $obj->fields['KODE_SK'];
    $lokasi = $obj->fields['LOKASI'];
    $jenis_unit = $obj->fields['JENIS_UNIT'];
    $tipe_bangunan = $obj->fields['TIPE_BANGUNAN'];
    $jenis_penjualan = $obj->fields['JENIS_PENJUALAN'];
    try {
        ex_login();
        ex_app('M');
        ex_mod('M08');
        $conn = conn($sess_db);
        ex_conn($conn);
        $conn->begintrans();
        ex_ha('M08', 'U');
        ex_empty($kode_bank, 'Kode bank harus diisi.');
        ex_empty($nama_bank, 'Nama bank harus diisi.');
        $query = "\n\t\t\tDELETE FROM BANK \n\t\t\tWHERE\n\t\t\t\tKODE_BANK = '{$id}'\n\t\t\t";
        ex_false($conn->Execute($query), $query);
        $msg = 'Data lembaga keuangan berhasil dihapus.';
        $conn->committrans();
    } catch (Exception $e) {
        $msg = $e->getmessage();
        $error = TRUE;
        if ($conn) {
            $conn->rollbacktrans();
        }
    }
    close($conn);
    $json = array('error' => $error, 'msg' => $msg);
    echo json_encode($json);
    exit;
}
die_login();
die_app('M');
die_mod('M08');
$conn = conn($sess_db);
die_conn($conn);
Example #29
0
<?php

require_once '../../../../../config/config.php';
die_login();
// die_app('C');
die_mod('C08');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$tgl = f_tgl(date("Y-m-d"));
$query_blok_lunas = '';
$query_pemb_jt = '';
$query_tglmerah = '';
$query_libur = '';
$query_blok_lunas = "SELECT C.KODE_BLOK FROM ( SELECT A.KODE_BLOK,B.SUMOFREALISASI,A.SUMOFPLAN,(B.SUMOFREALISASI-A.SUMOFPLAN) AS REMAIN FROM \n( SELECT SUM (A.NILAI) as SUMOFPLAN, A.KODE_BLOK from ( select A.KODE_BLOK,A.TANGGAL_TANDA_JADI AS TANGGAL,ISNULL(A.TANDA_JADI,0) \nAS NILAI from spp A where A.KODE_BLOK is not null UNION ALL SELECT A.KODE_BLOK,A.TANGGAL,ISNULL(A.NILAI,0) FROM RENCANA A WHERE A.KODE_BLOK IS NOT NULL\n)a GROUP BY a.KODE_BLOK ) A LEFT JOIN (SELECT SUM(A.NILAI) AS SUMOFREALISASI,A.KODE_BLOK FROM REALISASI A GROUP BY  A.KODE_BLOK)B \nON A.KODE_BLOK=B.KODE_BLOK where (B.SUMOFREALISASI-A.SUMOFPLAN)>=0 )C LEFT JOIN SPP D ON C.KODE_BLOK = D.KODE_BLOK\nWHERE C.REMAIN - (ISNULL(D.NILAI_CAIR_KPR,0)) >= 0\n";
$query_pemb_jt .= "(SELECT PEMB_JATUH_TEMPO FROM CS_PARAMETER_COL)";
$query_tglmerah = "SELECT COUNT(*) FROM CS_HARI_LIBUR a WHERE a.tanggal_awal<=@CUR_DATE AND @CUR_DATE<=a.tanggal_akhir)";
# Pagination
$query = "\nSELECT \n\tCOUNT(TANGGAL) AS TOTAL\nFROM \n\tRENCANA \nWHERE\n\tTANGGAL = CONVERT(DATETIME,'{$tgl}',105) AND \n\tKODE_BLOK NOT IN({$query_blok_lunas})\n";
$total_data = $conn->execute($query)->fields['TOTAL'];
$total_page = ceil($total_data / $per_page);
$page_num = $page_num > $total_page ? $total_page : $page_num;
$page_start = ($page_num - 1) * $per_page;
# End Pagination
?>

<table id="pagging-1" class="t-control">
<tr>
	<td>
		<input type="button" id="print" value=" Cetak Data ">
<?php

require_once '../../../../../config/config.php';
die_login();
// die_app('C');
die_mod('C06');
$conn = conn($sess_db);
die_conn($conn);
$per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20;
$page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1;
$search = isset($_REQUEST['no_va']) ? clean($_REQUEST['no_va']) : '';
$query_search = '';
if ($search != '') {
    $query_search .= " AND NOMOR_MEMO LIKE '%{$search}%'";
}
# Pagination
$query = "\nSELECT \n\tCOUNT(NOMOR_MEMO) AS TOTAL_DATA\n\tFROM CS_MEMO_PEMBATALAN\n\tWHERE NOMOR_MEMO != ' ' {$query_search}\n\tGROUP BY NOMOR_MEMO\t\n";
$total_data = $conn->execute($query)->fields['TOTAL_DATA'];
$total_page = ceil($total_data / $per_page);
$page_num = $page_num > $total_page ? $total_page : $page_num;
$page_start = ($page_num - 1) * $per_page;
# End Pagination
?>

<table id="pagging-1" class="t-control w50">
<tr>
	<td>
		<input type="button" id="tambah" value=" Tambah ">
		<input type="button" id="hapus" value=" Hapus ">
	</td>
	<td class="text-right">