DBok

<?php
/**
 * Export to PHP Array plugin for PHPMyAdmin
 * @version 4.9.4
 */

/**
 * Database `fotall67_dbproject1`
 */

/* `fotall67_dbproject1`.`tbAttachment` */
$tbAttachment = array(
  array('ID_attch' => '2','filename' => 'DSUM.txt','Field1' => '#C:\\Users\\Dino\\Documents\\Access\\DSUM.txt#'),
  array('ID_attch' => '4','filename' => '','Field1' => NULL)
);

/* `fotall67_dbproject1`.`tblDoctype` */
$tblDoctype = array(
  array('ID_doctype' => '1','Doctype' => 'SK Pejabat Pengadaan Barang/Jasa'),
  array('ID_doctype' => '2','Doctype' => 'Survey Harga'),
  array('ID_doctype' => '3','Doctype' => 'Penyusunan Harga Hasil Survey'),
  array('ID_doctype' => '4','Doctype' => 'Nota Dinas PPK'),
  array('ID_doctype' => '5','Doctype' => 'Undangan Penawaran'),
  array('ID_doctype' => '6','Doctype' => 'Penyampaian/Pemasukan Penawaran'),
  array('ID_doctype' => '7','Doctype' => 'Surat Penawaran'),
  array('ID_doctype' => '8','Doctype' => 'Evaluasi Penawaran, Klarifikasi Teknis dan Negosiasi Harga'),
  array('ID_doctype' => '9','Doctype' => 'Berita Acara Hasil Pengadaan Langsung'),
  array('ID_doctype' => '10','Doctype' => 'Surat Penetapan'),
  array('ID_doctype' => '11','Doctype' => 'Pengumuman dan Laporan'),
  array('ID_doctype' => '12','Doctype' => 'Laporan Hasil Pengadaan Langsung'),
  array('ID_doctype' => '13','Doctype' => 'Surat Perintah Kerja (SPK)'),
  array('ID_doctype' => '14','Doctype' => 'Jangka Waktu Pelaksanaan'),
  array('ID_doctype' => '15','Doctype' => 'Tempat dan Tanggal Penyerahan'),
  array('ID_doctype' => '16','Doctype' => 'Pemeriksaan dan Serah Terima Pekerjaan'),
  array('ID_doctype' => '17','Doctype' => 'Berita Acara Pembayaran'),
  array('ID_doctype' => '18','Doctype' => 'SPBY'),
  array('ID_doctype' => '19','Doctype' => 'Permintaan Pembayaran'),
  array('ID_doctype' => '20','Doctype' => 'Kwitansi'),
  array('ID_doctype' => '21','Doctype' => 'Faktur'),
  array('ID_doctype' => '22','Doctype' => 'Ringkasan Kontrak'),
  array('ID_doctype' => '23','Doctype' => 'SPTJM PPK'),
  array('ID_doctype' => '24','Doctype' => 'SPTJM Penyedia'),
  array('ID_doctype' => '25','Doctype' => 'Invoice')
);

/* `fotall67_dbproject1`.`tblDoctype1` */
$tblDoctype1 = array(
  array('ID_DocType' => '1','ID_Tahap' => '1','Doc' => 'E-KATALOG/CETAK PESANAN','Keterangan' => NULL),
  array('ID_DocType' => '2','ID_Tahap' => '1','Doc' => 'KONTRAK DAN ADENDUM','Keterangan' => 'Jika Ada'),
  array('ID_DocType' => '3','ID_Tahap' => '1','Doc' => 'SK CP/CL','Keterangan' => 'LENGKAP BERIKUT NIK, NO HP dan TITIK KORDINAT DROPING'),
  array('ID_DocType' => '4','ID_Tahap' => '1','Doc' => 'PURCHASE ORDER','Keterangan' => NULL),
  array('ID_DocType' => '5','ID_Tahap' => '1','Doc' => 'SURAT JAMINAN UANG MUKA','Keterangan' => 'JIKA DIBUTUHKAN DALAM KONTRAK'),
  array('ID_DocType' => '6','ID_Tahap' => '2','Doc' => 'DELIVERY ORDER & TRANSFER ANTAR GUDANG','Keterangan' => NULL),
  array('ID_DocType' => '7','ID_Tahap' => '2','Doc' => 'SERTIFIKAT UJI BENIH ASAL/LHU','Keterangan' => NULL),
  array('ID_DocType' => '8','ID_Tahap' => '2','Doc' => 'SERTIFIKAT KARANTINA KT12 atau KT9','Keterangan' => NULL),
  array('ID_DocType' => '9','ID_Tahap' => '2','Doc' => 'SERTIFIKAT UJI BENIH TUHUAN DARI BPSB','Keterangan' => NULL),
  array('ID_DocType' => '10','ID_Tahap' => '2','Doc' => 'SURAT JALAN EKSPEDISI','Keterangan' => NULL),
  array('ID_DocType' => '11','ID_Tahap' => '3','Doc' => 'BASTB','Keterangan' => NULL),
  array('ID_DocType' => '12','ID_Tahap' => '3','Doc' => 'SURAT JALAN','Keterangan' => NULL),
  array('ID_DocType' => '13','ID_Tahap' => '3','Doc' => 'KTP','Keterangan' => NULL),
  array('ID_DocType' => '14','ID_Tahap' => '3','Doc' => 'OPEN CAMERA','Keterangan' => NULL),
  array('ID_DocType' => '15','ID_Tahap' => '3','Doc' => 'SURAT KEWAJIBAN KELOMPOK TANI','Keterangan' => NULL),
  array('ID_DocType' => '16','ID_Tahap' => '3','Doc' => 'SURAT PPERNYATAAN MENANAM','Keterangan' => NULL),
  array('ID_DocType' => '17','ID_Tahap' => '3','Doc' => 'INVOICE & KWITANSI ONGKOS KIRIM PER KELOMPOK TANI','Keterangan' => NULL),
  array('ID_DocType' => '18','ID_Tahap' => '4','Doc' => 'FOTOCOPY RINGKASAN KONTRAK, KONTRAK, SSUK & SSKK,','Keterangan' => NULL),
  array('ID_DocType' => '19','ID_Tahap' => '4','Doc' => 'NPWP','Keterangan' => NULL),
  array('ID_DocType' => '20','ID_Tahap' => '4','Doc' => 'FOTOCOPY REKENING PERUSAHAAN','Keterangan' => NULL),
  array('ID_DocType' => '21','ID_Tahap' => '4','Doc' => 'FAKTUR PAJAK ELEKTONIK','Keterangan' => NULL),
  array('ID_DocType' => '22','ID_Tahap' => '4','Doc' => 'SSP PPH 22','Keterangan' => NULL),
  array('ID_DocType' => '23','ID_Tahap' => '4','Doc' => 'SURAT PERMOHONAN PEMBAYARAN DARI PENYEDIA','Keterangan' => NULL),
  array('ID_DocType' => '24','ID_Tahap' => '4','Doc' => 'BERITA ACARA SERAH TERIMA HASIL PEKERJAAN','Keterangan' => NULL),
  array('ID_DocType' => '25','ID_Tahap' => '4','Doc' => 'BERITA ACARA HASIL PEMERIKSAAN','Keterangan' => NULL),
  array('ID_DocType' => '26','ID_Tahap' => '4','Doc' => 'BERITA ACARA HASIL PEMERIKSAAN ADMINISTRATIF','Keterangan' => NULL),
  array('ID_DocType' => '27','ID_Tahap' => '4','Doc' => 'HASIL VERIFIKASI PEMBAYARAN OLEH TIM VERIFIKASI','Keterangan' => NULL),
  array('ID_DocType' => '28','ID_Tahap' => '4','Doc' => 'REKAP BASTB','Keterangan' => NULL),
  array('ID_DocType' => '29','ID_Tahap' => '4','Doc' => 'BERITA ACARA SERAH TERIMA BARANG','Keterangan' => NULL),
  array('ID_DocType' => '30','ID_Tahap' => '4','Doc' => 'HASIL PEMERIKSAAN/UJI BENIH OLEH BPSB','Keterangan' => NULL),
  array('ID_DocType' => '31','ID_Tahap' => '4','Doc' => 'KWITANSI/FAKTUR ONGKOS KIRIM','Keterangan' => NULL)
);

/* `fotall67_dbproject1`.`tblFile` */
$tblFile = array(
  array('ID_file' => '1','ID_perus' => '1','ID_ProName' => '1','ID_doctype' => '1','No_Surat' => '222222','Tgl_Surat' => '2019-02-14 00:00:00','Image' => '#C:\\Users\\Dino\\Documents\\Access\\DSUM.txt#'),
  array('ID_file' => '2','ID_perus' => NULL,'ID_ProName' => NULL,'ID_doctype' => NULL,'No_Surat' => NULL,'Tgl_Surat' => NULL,'Image' => NULL)
);

/* `fotall67_dbproject1`.`tblFile1` */
$tblFile1 = array(
  array('ID_File' => '1','ID_perus' => '1','Provinsi' => NULL,'ID_ProName' => NULL)
);

/* `fotall67_dbproject1`.`tblFile2` */
$tblFile2 = array(
  array('ID_File' => '1','ID_perus' => '1','ID_prov' => '1','ID_ProName' => NULL),
  array('ID_File' => '2','ID_perus' => '1','ID_prov' => '2','ID_ProName' => NULL)
);

/* `fotall67_dbproject1`.`tblFile3` */
$tblFile3 = array(
  array('ID_File' => '4','ID_ProName' => '14','ID_Tahap' => '1','ID_DocType' => '1','Keterangan' => NULL,'File' => '','Status' => '0'),
  array('ID_File' => '5','ID_ProName' => NULL,'ID_Tahap' => '1','ID_DocType' => NULL,'Keterangan' => NULL,'File' => '','Status' => '0'),
  array('ID_File' => '6','ID_ProName' => NULL,'ID_Tahap' => '3','ID_DocType' => '11','Keterangan' => NULL,'File' => '','Status' => '0'),
  array('ID_File' => '7','ID_ProName' => '16','ID_Tahap' => '3','ID_DocType' => '11','Keterangan' => NULL,'File' => '','Status' => '0'),
  array('ID_File' => '1','ID_ProName' => '1','ID_Tahap' => '1','ID_DocType' => '1','Keterangan' => NULL,'File' => '','Status' => '0'),
  array('ID_File' => '2','ID_ProName' => '1','ID_Tahap' => '1','ID_DocType' => '2','Keterangan' => NULL,'File' => '','Status' => '0'),
  array('ID_File' => '3','ID_ProName' => '1','ID_Tahap' => '3','ID_DocType' => '11','Keterangan' => NULL,'File' => '','Status' => '0')
);

/* `fotall67_dbproject1`.`tblKab` */
$tblKab = array(
  array('ID_Kab' => '1','ID_prov' => '1','Nama_Kab' => 'Kabupaten Aceh Barat'),
  array('ID_Kab' => '2','ID_prov' => '1','Nama_Kab' => 'Kabupaten Aceh Barat Daya'),
  array('ID_Kab' => '3','ID_prov' => '1','Nama_Kab' => 'Kabupaten Aceh Besar'),
  array('ID_Kab' => '4','ID_prov' => '1','Nama_Kab' => 'Kabupaten Aceh Jaya'),
  array('ID_Kab' => '5','ID_prov' => '1','Nama_Kab' => 'Kabupaten Aceh Selatan'),
  array('ID_Kab' => '6','ID_prov' => '1','Nama_Kab' => 'Kabupaten Aceh Singkil'),
  array('ID_Kab' => '7','ID_prov' => '1','Nama_Kab' => 'Kabupaten Aceh Tamiang'),
  array('ID_Kab' => '8','ID_prov' => '1','Nama_Kab' => 'Kabupaten Aceh Tengah'),
  array('ID_Kab' => '9','ID_prov' => '1','Nama_Kab' => 'Kabupaten Aceh Tenggara'),
  array('ID_Kab' => '10','ID_prov' => '1','Nama_Kab' => 'Kabupaten Aceh Timur'),
  array('ID_Kab' => '11','ID_prov' => '1','Nama_Kab' => 'Kabupaten Aceh Utara'),
  array('ID_Kab' => '12','ID_prov' => '1','Nama_Kab' => 'Kabupaten Bener Meriah'),
  array('ID_Kab' => '13','ID_prov' => '1','Nama_Kab' => 'Kabupaten Bireuen'),
  array('ID_Kab' => '14','ID_prov' => '1','Nama_Kab' => 'Kabupaten Gayo Lues'),
  array('ID_Kab' => '15','ID_prov' => '1','Nama_Kab' => 'Kabupaten Nagan Raya'),
  array('ID_Kab' => '16','ID_prov' => '1','Nama_Kab' => 'Kabupaten Pidie'),
  array('ID_Kab' => '17','ID_prov' => '1','Nama_Kab' => 'Kabupaten Pidie Jaya'),
  array('ID_Kab' => '18','ID_prov' => '1','Nama_Kab' => 'Kabupaten Simeulue'),
  array('ID_Kab' => '19','ID_prov' => '1','Nama_Kab' => 'Kota Banda Aceh'),
  array('ID_Kab' => '20','ID_prov' => '1','Nama_Kab' => 'Kota Langsa'),
  array('ID_Kab' => '21','ID_prov' => '1','Nama_Kab' => 'Kota Lhokseumawe'),
  array('ID_Kab' => '22','ID_prov' => '1','Nama_Kab' => 'Kota Sabang'),
  array('ID_Kab' => '23','ID_prov' => '1','Nama_Kab' => 'Kota Subulussalam'),
  array('ID_Kab' => '24','ID_prov' => '2','Nama_Kab' => 'Kabupaten Asahan'),
  array('ID_Kab' => '25','ID_prov' => '2','Nama_Kab' => 'Kabupaten Batu Bara'),
  array('ID_Kab' => '26','ID_prov' => '2','Nama_Kab' => 'Kabupaten Dairi'),
  array('ID_Kab' => '27','ID_prov' => '2','Nama_Kab' => 'Kabupaten Deli Serdang'),
  array('ID_Kab' => '28','ID_prov' => '2','Nama_Kab' => 'Kabupaten Humbang Hasundutan'),
  array('ID_Kab' => '29','ID_prov' => '2','Nama_Kab' => 'Kabupaten Karo'),
  array('ID_Kab' => '30','ID_prov' => '2','Nama_Kab' => 'Kabupaten Labuhanbatu'),
  array('ID_Kab' => '31','ID_prov' => '2','Nama_Kab' => 'Kabupaten Labuhanbatu Selatan'),
  array('ID_Kab' => '32','ID_prov' => '2','Nama_Kab' => 'Kabupaten Labuhanbatu Utara'),
  array('ID_Kab' => '33','ID_prov' => '2','Nama_Kab' => 'Kabupaten Langkat'),
  array('ID_Kab' => '34','ID_prov' => '2','Nama_Kab' => 'Kabupaten Mandailing Natal'),
  array('ID_Kab' => '35','ID_prov' => '2','Nama_Kab' => 'Kabupaten Nias'),
  array('ID_Kab' => '36','ID_prov' => '2','Nama_Kab' => 'Kabupaten Nias Barat'),
  array('ID_Kab' => '37','ID_prov' => '2','Nama_Kab' => 'Kabupaten Nias Selatan'),
  array('ID_Kab' => '38','ID_prov' => '2','Nama_Kab' => 'Kabupaten Nias Utara'),
  array('ID_Kab' => '39','ID_prov' => '2','Nama_Kab' => 'Kabupaten Padang Lawas'),
  array('ID_Kab' => '40','ID_prov' => '2','Nama_Kab' => 'Kabupaten Padang Lawas Utara'),
  array('ID_Kab' => '41','ID_prov' => '2','Nama_Kab' => 'Kabupaten Pakpak Bharat'),
  array('ID_Kab' => '42','ID_prov' => '2','Nama_Kab' => 'Kabupaten Samosir'),
  array('ID_Kab' => '43','ID_prov' => '2','Nama_Kab' => 'Kabupaten Serdang Bedagai'),
  array('ID_Kab' => '44','ID_prov' => '2','Nama_Kab' => 'Kabupaten Simalungun'),
  array('ID_Kab' => '45','ID_prov' => '2','Nama_Kab' => 'Kabupaten Tapanuli Selatan'),
  array('ID_Kab' => '46','ID_prov' => '2','Nama_Kab' => 'Kabupaten Tapanuli Tengah'),
  array('ID_Kab' => '47','ID_prov' => '2','Nama_Kab' => 'Kabupaten Tapanuli Utara'),
  array('ID_Kab' => '48','ID_prov' => '2','Nama_Kab' => 'Kabupaten Toba Samosir'),
  array('ID_Kab' => '49','ID_prov' => '2','Nama_Kab' => 'Kota Binjai'),
  array('ID_Kab' => '50','ID_prov' => '2','Nama_Kab' => 'Kota Gunungsitoli'),
  array('ID_Kab' => '51','ID_prov' => '2','Nama_Kab' => 'Kota Medan'),
  array('ID_Kab' => '52','ID_prov' => '2','Nama_Kab' => 'Kota Padangsidempuan'),
  array('ID_Kab' => '53','ID_prov' => '2','Nama_Kab' => 'Kota Pematangsiantar'),
  array('ID_Kab' => '54','ID_prov' => '2','Nama_Kab' => 'Kota Sibolga'),
  array('ID_Kab' => '55','ID_prov' => '2','Nama_Kab' => 'Kota Tanjungbalai'),
  array('ID_Kab' => '56','ID_prov' => '2','Nama_Kab' => 'Kota Tebing Tinggi'),
  array('ID_Kab' => '57','ID_prov' => '3','Nama_Kab' => 'Kabupaten Agam'),
  array('ID_Kab' => '58','ID_prov' => '3','Nama_Kab' => 'Kabupaten Dharmasraya'),
  array('ID_Kab' => '59','ID_prov' => '3','Nama_Kab' => 'Kabupaten Kepulauan Mentawai'),
  array('ID_Kab' => '60','ID_prov' => '3','Nama_Kab' => 'Kabupaten Lima Puluh Kota'),
  array('ID_Kab' => '61','ID_prov' => '3','Nama_Kab' => 'Kabupaten Padang Pariaman'),
  array('ID_Kab' => '62','ID_prov' => '3','Nama_Kab' => 'Kabupaten Pasaman'),
  array('ID_Kab' => '63','ID_prov' => '3','Nama_Kab' => 'Kabupaten Pasaman Barat'),
  array('ID_Kab' => '64','ID_prov' => '3','Nama_Kab' => 'Kabupaten Pesisir Selatan'),
  array('ID_Kab' => '65','ID_prov' => '3','Nama_Kab' => 'Kabupaten Sijunjung'),
  array('ID_Kab' => '66','ID_prov' => '3','Nama_Kab' => 'Kabupaten Solok'),
  array('ID_Kab' => '67','ID_prov' => '3','Nama_Kab' => 'Kabupaten Solok Selatan'),
  array('ID_Kab' => '68','ID_prov' => '3','Nama_Kab' => 'Kabupaten Tanah Datar'),
  array('ID_Kab' => '69','ID_prov' => '3','Nama_Kab' => 'Kota Bukittinggi'),
  array('ID_Kab' => '70','ID_prov' => '3','Nama_Kab' => 'Kota Padang'),
  array('ID_Kab' => '71','ID_prov' => '3','Nama_Kab' => 'Kota Padangpanjang'),
  array('ID_Kab' => '72','ID_prov' => '3','Nama_Kab' => 'Kota Pariaman'),
  array('ID_Kab' => '73','ID_prov' => '3','Nama_Kab' => 'Kota Payakumbuh'),
  array('ID_Kab' => '74','ID_prov' => '3','Nama_Kab' => 'Kota Sawahlunto'),
  array('ID_Kab' => '75','ID_prov' => '3','Nama_Kab' => 'Kota Solok'),
  array('ID_Kab' => '76','ID_prov' => '4','Nama_Kab' => 'Kabupaten Bengkalis'),
  array('ID_Kab' => '77','ID_prov' => '4','Nama_Kab' => 'Kabupaten Indragiri Hilir'),
  array('ID_Kab' => '78','ID_prov' => '4','Nama_Kab' => 'Kabupaten Indragiri Hulu'),
  array('ID_Kab' => '79','ID_prov' => '4','Nama_Kab' => 'Kabupaten Kampar'),
  array('ID_Kab' => '80','ID_prov' => '4','Nama_Kab' => 'Kabupaten Kepulauan Meranti'),
  array('ID_Kab' => '81','ID_prov' => '4','Nama_Kab' => 'Kabupaten Kuantan Singingi'),
  array('ID_Kab' => '82','ID_prov' => '4','Nama_Kab' => 'Kabupaten Pelalawan'),
  array('ID_Kab' => '83','ID_prov' => '4','Nama_Kab' => 'Kabupaten Rokan Hilir'),
  array('ID_Kab' => '84','ID_prov' => '4','Nama_Kab' => 'Kabupaten Rokan Hulu'),
  array('ID_Kab' => '85','ID_prov' => '4','Nama_Kab' => 'Kabupaten Siak'),
  array('ID_Kab' => '86','ID_prov' => '4','Nama_Kab' => 'Kota Dumai'),
  array('ID_Kab' => '87','ID_prov' => '4','Nama_Kab' => 'Kota Pekanbaru'),
  array('ID_Kab' => '88','ID_prov' => '5','Nama_Kab' => 'Kabupaten Bintan'),
  array('ID_Kab' => '89','ID_prov' => '5','Nama_Kab' => 'Kabupaten Karimun'),
  array('ID_Kab' => '90','ID_prov' => '5','Nama_Kab' => 'Kabupaten Kepulauan Anambas'),
  array('ID_Kab' => '91','ID_prov' => '5','Nama_Kab' => 'Kabupaten Lingga'),
  array('ID_Kab' => '92','ID_prov' => '5','Nama_Kab' => 'Kabupaten Natuna'),
  array('ID_Kab' => '93','ID_prov' => '5','Nama_Kab' => 'Kota Batam'),
  array('ID_Kab' => '94','ID_prov' => '5','Nama_Kab' => 'Kota Tanjung Pinang'),
  array('ID_Kab' => '95','ID_prov' => '6','Nama_Kab' => 'Kabupaten Batanghari'),
  array('ID_Kab' => '96','ID_prov' => '6','Nama_Kab' => 'Kabupaten Bungo'),
  array('ID_Kab' => '97','ID_prov' => '6','Nama_Kab' => 'Kabupaten Kerinci'),
  array('ID_Kab' => '98','ID_prov' => '6','Nama_Kab' => 'Kabupaten Merangin'),
  array('ID_Kab' => '99','ID_prov' => '6','Nama_Kab' => 'Kabupaten Muaro Jambi'),
  array('ID_Kab' => '100','ID_prov' => '6','Nama_Kab' => 'Kabupaten Sarolangun'),
  array('ID_Kab' => '101','ID_prov' => '6','Nama_Kab' => 'Kabupaten Tanjung Jabung Barat'),
  array('ID_Kab' => '102','ID_prov' => '6','Nama_Kab' => 'Kabupaten Tanjung Jabung Timur'),
  array('ID_Kab' => '103','ID_prov' => '6','Nama_Kab' => 'Kabupaten Tebo'),
  array('ID_Kab' => '104','ID_prov' => '6','Nama_Kab' => 'Kota Jambi'),
  array('ID_Kab' => '105','ID_prov' => '6','Nama_Kab' => 'Kota Sungaipenuh'),
  array('ID_Kab' => '106','ID_prov' => '7','Nama_Kab' => 'Kabupaten Bengkulu Selatan'),
  array('ID_Kab' => '107','ID_prov' => '7','Nama_Kab' => 'Kabupaten Bengkulu Tengah'),
  array('ID_Kab' => '108','ID_prov' => '7','Nama_Kab' => 'Kabupaten Bengkulu Utara'),
  array('ID_Kab' => '109','ID_prov' => '7','Nama_Kab' => 'Kabupaten Kaur'),
  array('ID_Kab' => '110','ID_prov' => '7','Nama_Kab' => 'Kabupaten Kepahiang'),
  array('ID_Kab' => '111','ID_prov' => '7','Nama_Kab' => 'Kabupaten Lebong'),
  array('ID_Kab' => '112','ID_prov' => '7','Nama_Kab' => 'Kabupaten Mukomuko'),
  array('ID_Kab' => '113','ID_prov' => '7','Nama_Kab' => 'Kabupaten Rejang Lebong'),
  array('ID_Kab' => '114','ID_prov' => '7','Nama_Kab' => 'Kabupaten Seluma'),
  array('ID_Kab' => '115','ID_prov' => '7','Nama_Kab' => 'Kota Bengkulu'),
  array('ID_Kab' => '116','ID_prov' => '8','Nama_Kab' => 'Kabupaten Banyuasin'),
  array('ID_Kab' => '117','ID_prov' => '8','Nama_Kab' => 'Kabupaten Empat Lawang'),
  array('ID_Kab' => '118','ID_prov' => '8','Nama_Kab' => 'Kabupaten Lahat'),
  array('ID_Kab' => '119','ID_prov' => '8','Nama_Kab' => 'Kabupaten Muara Enim'),
  array('ID_Kab' => '120','ID_prov' => '8','Nama_Kab' => 'Kabupaten Musi Banyuasin'),
  array('ID_Kab' => '121','ID_prov' => '8','Nama_Kab' => 'Kabupaten Musi Rawas'),
  array('ID_Kab' => '122','ID_prov' => '8','Nama_Kab' => 'Kabupaten Musi Rawas Utara'),
  array('ID_Kab' => '123','ID_prov' => '8','Nama_Kab' => 'Kabupaten Ogan Ilir'),
  array('ID_Kab' => '124','ID_prov' => '8','Nama_Kab' => 'Kabupaten Ogan Komering Ilir'),
  array('ID_Kab' => '125','ID_prov' => '8','Nama_Kab' => 'Kabupaten Ogan Komering Ulu'),
  array('ID_Kab' => '126','ID_prov' => '8','Nama_Kab' => 'Kabupaten Ogan Komering Ulu Selatan'),
  array('ID_Kab' => '127','ID_prov' => '8','Nama_Kab' => 'Kabupaten Ogan Komering Ulu Timur'),
  array('ID_Kab' => '128','ID_prov' => '8','Nama_Kab' => 'Kabupaten Penukal Abab Lematang Ilir'),
  array('ID_Kab' => '129','ID_prov' => '8','Nama_Kab' => 'Kota Lubuklinggau'),
  array('ID_Kab' => '130','ID_prov' => '8','Nama_Kab' => 'Kota Pagar Alam'),
  array('ID_Kab' => '131','ID_prov' => '8','Nama_Kab' => 'Kota Palembang'),
  array('ID_Kab' => '132','ID_prov' => '8','Nama_Kab' => 'Kota Prabumulih'),
  array('ID_Kab' => '133','ID_prov' => '9','Nama_Kab' => 'Kabupaten Bangka'),
  array('ID_Kab' => '134','ID_prov' => '9','Nama_Kab' => 'Kabupaten Bangka Barat'),
  array('ID_Kab' => '135','ID_prov' => '9','Nama_Kab' => 'Kabupaten Bangka Selatan'),
  array('ID_Kab' => '136','ID_prov' => '9','Nama_Kab' => 'Kabupaten Bangka Tengah'),
  array('ID_Kab' => '137','ID_prov' => '9','Nama_Kab' => 'Kabupaten Belitung'),
  array('ID_Kab' => '138','ID_prov' => '9','Nama_Kab' => 'Kabupaten Belitung Timur'),
  array('ID_Kab' => '139','ID_prov' => '9','Nama_Kab' => 'Kota Pangkal Pinang'),
  array('ID_Kab' => '140','ID_prov' => '10','Nama_Kab' => 'Kabupaten Lampung Barat'),
  array('ID_Kab' => '141','ID_prov' => '10','Nama_Kab' => 'Kabupaten Lampung Selatan'),
  array('ID_Kab' => '142','ID_prov' => '10','Nama_Kab' => 'Kabupaten Lampung Tengah'),
  array('ID_Kab' => '143','ID_prov' => '10','Nama_Kab' => 'Kabupaten Lampung Timur'),
  array('ID_Kab' => '144','ID_prov' => '10','Nama_Kab' => 'Kabupaten Lampung Utara'),
  array('ID_Kab' => '145','ID_prov' => '10','Nama_Kab' => 'Kabupaten Mesuji'),
  array('ID_Kab' => '146','ID_prov' => '10','Nama_Kab' => 'Kabupaten Pesawaran'),
  array('ID_Kab' => '147','ID_prov' => '10','Nama_Kab' => 'Kabupaten Pesisir Barat'),
  array('ID_Kab' => '148','ID_prov' => '10','Nama_Kab' => 'Kabupaten Pringsewu'),
  array('ID_Kab' => '149','ID_prov' => '10','Nama_Kab' => 'Kabupaten Tanggamus'),
  array('ID_Kab' => '150','ID_prov' => '10','Nama_Kab' => 'Kabupaten Tulang Bawang'),
  array('ID_Kab' => '151','ID_prov' => '10','Nama_Kab' => 'Kabupaten Tulang Bawang Barat'),
  array('ID_Kab' => '152','ID_prov' => '10','Nama_Kab' => 'Kabupaten Way Kanan'),
  array('ID_Kab' => '153','ID_prov' => '10','Nama_Kab' => 'Kota Bandar Lampung'),
  array('ID_Kab' => '154','ID_prov' => '10','Nama_Kab' => 'Kota Metro'),
  array('ID_Kab' => '155','ID_prov' => '11','Nama_Kab' => 'Kabupaten Lebak'),
  array('ID_Kab' => '156','ID_prov' => '11','Nama_Kab' => 'Kabupaten Pandeglang'),
  array('ID_Kab' => '157','ID_prov' => '11','Nama_Kab' => 'Kabupaten Serang'),
  array('ID_Kab' => '158','ID_prov' => '11','Nama_Kab' => 'Kabupaten Tangerang'),
  array('ID_Kab' => '159','ID_prov' => '11','Nama_Kab' => 'Kota Cilegon'),
  array('ID_Kab' => '160','ID_prov' => '11','Nama_Kab' => 'Kota Serang'),
  array('ID_Kab' => '161','ID_prov' => '11','Nama_Kab' => 'Kota Tangerang'),
  array('ID_Kab' => '162','ID_prov' => '11','Nama_Kab' => 'Kota Tangerang Selatan'),
  array('ID_Kab' => '163','ID_prov' => '12','Nama_Kab' => 'Kabupaten Bandung'),
  array('ID_Kab' => '164','ID_prov' => '12','Nama_Kab' => 'Kabupaten Bandung Barat'),
  array('ID_Kab' => '165','ID_prov' => '12','Nama_Kab' => 'Kabupaten Bekasi'),
  array('ID_Kab' => '166','ID_prov' => '12','Nama_Kab' => 'Kabupaten Bogor'),
  array('ID_Kab' => '167','ID_prov' => '12','Nama_Kab' => 'Kabupaten Ciamis'),
  array('ID_Kab' => '168','ID_prov' => '12','Nama_Kab' => 'Kabupaten Cianjur'),
  array('ID_Kab' => '169','ID_prov' => '12','Nama_Kab' => 'Kabupaten Cirebon'),
  array('ID_Kab' => '170','ID_prov' => '12','Nama_Kab' => 'Kabupaten Garut'),
  array('ID_Kab' => '171','ID_prov' => '12','Nama_Kab' => 'Kabupaten Indramayu'),
  array('ID_Kab' => '172','ID_prov' => '12','Nama_Kab' => 'Kabupaten Karawang'),
  array('ID_Kab' => '173','ID_prov' => '12','Nama_Kab' => 'Kabupaten Kuningan'),
  array('ID_Kab' => '174','ID_prov' => '12','Nama_Kab' => 'Kabupaten Majalengka'),
  array('ID_Kab' => '175','ID_prov' => '12','Nama_Kab' => 'Kabupaten Pangandaran'),
  array('ID_Kab' => '176','ID_prov' => '12','Nama_Kab' => 'Kabupaten Purwakarta'),
  array('ID_Kab' => '177','ID_prov' => '12','Nama_Kab' => 'Kabupaten Subang'),
  array('ID_Kab' => '178','ID_prov' => '12','Nama_Kab' => 'Kabupaten Sukabumi'),
  array('ID_Kab' => '179','ID_prov' => '12','Nama_Kab' => 'Kabupaten Sumedang'),
  array('ID_Kab' => '180','ID_prov' => '12','Nama_Kab' => 'Kabupaten Tasikmalaya'),
  array('ID_Kab' => '181','ID_prov' => '12','Nama_Kab' => 'Kota Bandung'),
  array('ID_Kab' => '182','ID_prov' => '12','Nama_Kab' => 'Kota Banjar'),
  array('ID_Kab' => '183','ID_prov' => '12','Nama_Kab' => 'Kota Bekasi'),
  array('ID_Kab' => '184','ID_prov' => '12','Nama_Kab' => 'Kota Bogor'),
  array('ID_Kab' => '185','ID_prov' => '12','Nama_Kab' => 'Kota Cimahi'),
  array('ID_Kab' => '186','ID_prov' => '12','Nama_Kab' => 'Kota Cirebon'),
  array('ID_Kab' => '187','ID_prov' => '12','Nama_Kab' => 'Kota Depok'),
  array('ID_Kab' => '188','ID_prov' => '12','Nama_Kab' => 'Kota Sukabumi'),
  array('ID_Kab' => '189','ID_prov' => '12','Nama_Kab' => 'Kota Tasikmalaya'),
  array('ID_Kab' => '190','ID_prov' => '13','Nama_Kab' => 'Kabupaten Administrasi Kepulauan Seribu'),
  array('ID_Kab' => '191','ID_prov' => '13','Nama_Kab' => 'Kota Administrasi Jakarta Barat'),
  array('ID_Kab' => '192','ID_prov' => '13','Nama_Kab' => 'Kota Administrasi Jakarta Pusat'),
  array('ID_Kab' => '193','ID_prov' => '13','Nama_Kab' => 'Kota Administrasi Jakarta Selatan'),
  array('ID_Kab' => '194','ID_prov' => '13','Nama_Kab' => 'Kota Administrasi Jakarta Timur'),
  array('ID_Kab' => '195','ID_prov' => '13','Nama_Kab' => 'Kota Administrasi Jakarta Utara'),
  array('ID_Kab' => '196','ID_prov' => '14','Nama_Kab' => 'Kabupaten Banjarnegara'),
  array('ID_Kab' => '197','ID_prov' => '14','Nama_Kab' => 'Kabupaten Banyumas'),
  array('ID_Kab' => '198','ID_prov' => '14','Nama_Kab' => 'Kabupaten Batang'),
  array('ID_Kab' => '199','ID_prov' => '14','Nama_Kab' => 'Kabupaten Blora'),
  array('ID_Kab' => '200','ID_prov' => '14','Nama_Kab' => 'Kabupaten Boyolali'),
  array('ID_Kab' => '201','ID_prov' => '14','Nama_Kab' => 'Kabupaten Brebes'),
  array('ID_Kab' => '202','ID_prov' => '14','Nama_Kab' => 'Kabupaten Cilacap'),
  array('ID_Kab' => '203','ID_prov' => '14','Nama_Kab' => 'Kabupaten Demak'),
  array('ID_Kab' => '204','ID_prov' => '14','Nama_Kab' => 'Kabupaten Grobogan'),
  array('ID_Kab' => '205','ID_prov' => '14','Nama_Kab' => 'Kabupaten Jepara'),
  array('ID_Kab' => '206','ID_prov' => '14','Nama_Kab' => 'Kabupaten Karanganyar'),
  array('ID_Kab' => '207','ID_prov' => '14','Nama_Kab' => 'Kabupaten Kebumen'),
  array('ID_Kab' => '208','ID_prov' => '14','Nama_Kab' => 'Kabupaten Kendal'),
  array('ID_Kab' => '209','ID_prov' => '14','Nama_Kab' => 'Kabupaten Klaten'),
  array('ID_Kab' => '210','ID_prov' => '14','Nama_Kab' => 'Kabupaten Kudus'),
  array('ID_Kab' => '211','ID_prov' => '14','Nama_Kab' => 'Kabupaten Magelang'),
  array('ID_Kab' => '212','ID_prov' => '14','Nama_Kab' => 'Kabupaten Pati'),
  array('ID_Kab' => '213','ID_prov' => '14','Nama_Kab' => 'Kabupaten Pekalongan'),
  array('ID_Kab' => '214','ID_prov' => '14','Nama_Kab' => 'Kabupaten Pemalang'),
  array('ID_Kab' => '215','ID_prov' => '14','Nama_Kab' => 'Kabupaten Purbalingga'),
  array('ID_Kab' => '216','ID_prov' => '14','Nama_Kab' => 'Kabupaten Purworejo'),
  array('ID_Kab' => '217','ID_prov' => '14','Nama_Kab' => 'Kabupaten Rembang'),
  array('ID_Kab' => '218','ID_prov' => '14','Nama_Kab' => 'Kabupaten Semarang'),
  array('ID_Kab' => '219','ID_prov' => '14','Nama_Kab' => 'Kabupaten Sragen'),
  array('ID_Kab' => '220','ID_prov' => '14','Nama_Kab' => 'Kabupaten Sukoharjo'),
  array('ID_Kab' => '221','ID_prov' => '14','Nama_Kab' => 'Kabupaten Tegal'),
  array('ID_Kab' => '222','ID_prov' => '14','Nama_Kab' => 'Kabupaten Temanggung'),
  array('ID_Kab' => '223','ID_prov' => '14','Nama_Kab' => 'Kabupaten Wonogiri'),
  array('ID_Kab' => '224','ID_prov' => '14','Nama_Kab' => 'Kabupaten Wonosobo'),
  array('ID_Kab' => '225','ID_prov' => '14','Nama_Kab' => 'Kota Magelang'),
  array('ID_Kab' => '226','ID_prov' => '14','Nama_Kab' => 'Kota Pekalongan'),
  array('ID_Kab' => '227','ID_prov' => '14','Nama_Kab' => 'Kota Salatiga'),
  array('ID_Kab' => '228','ID_prov' => '14','Nama_Kab' => 'Kota Semarang'),
  array('ID_Kab' => '229','ID_prov' => '14','Nama_Kab' => 'Kota Surakarta'),
  array('ID_Kab' => '230','ID_prov' => '14','Nama_Kab' => 'Kota Tegal'),
  array('ID_Kab' => '231','ID_prov' => '15','Nama_Kab' => 'Kabupaten Bantul'),
  array('ID_Kab' => '232','ID_prov' => '15','Nama_Kab' => 'Kabupaten Gunungkidul'),
  array('ID_Kab' => '233','ID_prov' => '15','Nama_Kab' => 'Kabupaten Kulon Progo'),
  array('ID_Kab' => '234','ID_prov' => '15','Nama_Kab' => 'Kabupaten Sleman'),
  array('ID_Kab' => '235','ID_prov' => '15','Nama_Kab' => 'Kota Yogyakarta'),
  array('ID_Kab' => '236','ID_prov' => '16','Nama_Kab' => 'Kabupaten Bangkalan'),
  array('ID_Kab' => '237','ID_prov' => '16','Nama_Kab' => 'Kabupaten Banyuwangi'),
  array('ID_Kab' => '238','ID_prov' => '16','Nama_Kab' => 'Kabupaten Blitar'),
  array('ID_Kab' => '239','ID_prov' => '16','Nama_Kab' => 'Kabupaten Bojonegoro'),
  array('ID_Kab' => '240','ID_prov' => '16','Nama_Kab' => 'Kabupaten Bondowoso'),
  array('ID_Kab' => '241','ID_prov' => '16','Nama_Kab' => 'Kabupaten Gresik'),
  array('ID_Kab' => '242','ID_prov' => '16','Nama_Kab' => 'Kabupaten Jember'),
  array('ID_Kab' => '243','ID_prov' => '16','Nama_Kab' => 'Kabupaten Jombang'),
  array('ID_Kab' => '244','ID_prov' => '16','Nama_Kab' => 'Kabupaten Kediri'),
  array('ID_Kab' => '245','ID_prov' => '16','Nama_Kab' => 'Kabupaten Lamongan'),
  array('ID_Kab' => '246','ID_prov' => '16','Nama_Kab' => 'Kabupaten Lumajang'),
  array('ID_Kab' => '247','ID_prov' => '16','Nama_Kab' => 'Kabupaten Madiun'),
  array('ID_Kab' => '248','ID_prov' => '16','Nama_Kab' => 'Kabupaten Magetan'),
  array('ID_Kab' => '249','ID_prov' => '16','Nama_Kab' => 'Kabupaten Malang'),
  array('ID_Kab' => '250','ID_prov' => '16','Nama_Kab' => 'Kabupaten Mojokerto'),
  array('ID_Kab' => '251','ID_prov' => '16','Nama_Kab' => 'Kabupaten Nganjuk'),
  array('ID_Kab' => '252','ID_prov' => '16','Nama_Kab' => 'Kabupaten Ngawi'),
  array('ID_Kab' => '253','ID_prov' => '16','Nama_Kab' => 'Kabupaten Pacitan'),
  array('ID_Kab' => '254','ID_prov' => '16','Nama_Kab' => 'Kabupaten Pamekasan'),
  array('ID_Kab' => '255','ID_prov' => '16','Nama_Kab' => 'Kabupaten Pasuruan'),
  array('ID_Kab' => '256','ID_prov' => '16','Nama_Kab' => 'Kabupaten Ponorogo'),
  array('ID_Kab' => '257','ID_prov' => '16','Nama_Kab' => 'Kabupaten Probolinggo'),
  array('ID_Kab' => '258','ID_prov' => '16','Nama_Kab' => 'Kabupaten Sampang'),
  array('ID_Kab' => '259','ID_prov' => '16','Nama_Kab' => 'Kabupaten Sidoarjo'),
  array('ID_Kab' => '260','ID_prov' => '16','Nama_Kab' => 'Kabupaten Situbondo'),
  array('ID_Kab' => '261','ID_prov' => '16','Nama_Kab' => 'Kabupaten Sumenep'),
  array('ID_Kab' => '262','ID_prov' => '16','Nama_Kab' => 'Kabupaten Trenggalek'),
  array('ID_Kab' => '263','ID_prov' => '16','Nama_Kab' => 'Kabupaten Tuban'),
  array('ID_Kab' => '264','ID_prov' => '16','Nama_Kab' => 'Kabupaten Tulungagung'),
  array('ID_Kab' => '265','ID_prov' => '16','Nama_Kab' => 'Kota Batu'),
  array('ID_Kab' => '266','ID_prov' => '16','Nama_Kab' => 'Kota Blitar'),
  array('ID_Kab' => '267','ID_prov' => '16','Nama_Kab' => 'Kota Kediri'),
  array('ID_Kab' => '268','ID_prov' => '16','Nama_Kab' => 'Kota Madiun'),
  array('ID_Kab' => '269','ID_prov' => '16','Nama_Kab' => 'Kota Malang'),
  array('ID_Kab' => '270','ID_prov' => '16','Nama_Kab' => 'Kota Mojokerto'),
  array('ID_Kab' => '271','ID_prov' => '16','Nama_Kab' => 'Kota Pasuruan'),
  array('ID_Kab' => '272','ID_prov' => '16','Nama_Kab' => 'Kota Probolinggo'),
  array('ID_Kab' => '273','ID_prov' => '16','Nama_Kab' => 'Kota Surabaya'),
  array('ID_Kab' => '274','ID_prov' => '17','Nama_Kab' => 'Kabupaten Badung'),
  array('ID_Kab' => '275','ID_prov' => '17','Nama_Kab' => 'Kabupaten Bangli'),
  array('ID_Kab' => '276','ID_prov' => '17','Nama_Kab' => 'Kabupaten Buleleng'),
  array('ID_Kab' => '277','ID_prov' => '17','Nama_Kab' => 'Kabupaten Gianyar'),
  array('ID_Kab' => '278','ID_prov' => '17','Nama_Kab' => 'Kabupaten Jembrana'),
  array('ID_Kab' => '279','ID_prov' => '17','Nama_Kab' => 'Kabupaten Karangasem'),
  array('ID_Kab' => '280','ID_prov' => '17','Nama_Kab' => 'Kabupaten Klungkung'),
  array('ID_Kab' => '281','ID_prov' => '17','Nama_Kab' => 'Kabupaten Tabanan'),
  array('ID_Kab' => '282','ID_prov' => '17','Nama_Kab' => 'Kota Denpasar'),
  array('ID_Kab' => '283','ID_prov' => '18','Nama_Kab' => 'Kabupaten Bima'),
  array('ID_Kab' => '284','ID_prov' => '18','Nama_Kab' => 'Kabupaten Dompu'),
  array('ID_Kab' => '285','ID_prov' => '18','Nama_Kab' => 'Kabupaten Lombok Barat'),
  array('ID_Kab' => '286','ID_prov' => '18','Nama_Kab' => 'Kabupaten Lombok Tengah'),
  array('ID_Kab' => '287','ID_prov' => '18','Nama_Kab' => 'Kabupaten Lombok Timur'),
  array('ID_Kab' => '288','ID_prov' => '18','Nama_Kab' => 'Kabupaten Lombok Utara'),
  array('ID_Kab' => '289','ID_prov' => '18','Nama_Kab' => 'Kabupaten Sumbawa'),
  array('ID_Kab' => '290','ID_prov' => '18','Nama_Kab' => 'Kabupaten Sumbawa Barat'),
  array('ID_Kab' => '291','ID_prov' => '18','Nama_Kab' => 'Kota Bima'),
  array('ID_Kab' => '292','ID_prov' => '18','Nama_Kab' => 'Kota Mataram'),
  array('ID_Kab' => '293','ID_prov' => '19','Nama_Kab' => 'Kabupaten Alor'),
  array('ID_Kab' => '294','ID_prov' => '19','Nama_Kab' => 'Kabupaten Belu'),
  array('ID_Kab' => '295','ID_prov' => '19','Nama_Kab' => 'Kabupaten Ende'),
  array('ID_Kab' => '296','ID_prov' => '19','Nama_Kab' => 'Kabupaten Flores Timur'),
  array('ID_Kab' => '297','ID_prov' => '19','Nama_Kab' => 'Kabupaten Kupang'),
  array('ID_Kab' => '298','ID_prov' => '19','Nama_Kab' => 'Kabupaten Lembata'),
  array('ID_Kab' => '299','ID_prov' => '19','Nama_Kab' => 'Kabupaten Malaka'),
  array('ID_Kab' => '300','ID_prov' => '19','Nama_Kab' => 'Kabupaten Manggarai'),
  array('ID_Kab' => '301','ID_prov' => '19','Nama_Kab' => 'Kabupaten Manggarai Barat'),
  array('ID_Kab' => '302','ID_prov' => '19','Nama_Kab' => 'Kabupaten Manggarai Timur'),
  array('ID_Kab' => '303','ID_prov' => '19','Nama_Kab' => 'Kabupaten Ngada'),
  array('ID_Kab' => '304','ID_prov' => '19','Nama_Kab' => 'Kabupaten Nagekeo'),
  array('ID_Kab' => '305','ID_prov' => '19','Nama_Kab' => 'Kabupaten Rote Ndao'),
  array('ID_Kab' => '306','ID_prov' => '19','Nama_Kab' => 'Kabupaten Sabu Raijua'),
  array('ID_Kab' => '307','ID_prov' => '19','Nama_Kab' => 'Kabupaten Sikka'),
  array('ID_Kab' => '308','ID_prov' => '19','Nama_Kab' => 'Kabupaten Sumba Barat'),
  array('ID_Kab' => '309','ID_prov' => '19','Nama_Kab' => 'Kabupaten Sumba Barat Daya'),
  array('ID_Kab' => '310','ID_prov' => '19','Nama_Kab' => 'Kabupaten Sumba Tengah'),
  array('ID_Kab' => '311','ID_prov' => '19','Nama_Kab' => 'Kabupaten Sumba Timur'),
  array('ID_Kab' => '312','ID_prov' => '19','Nama_Kab' => 'Kabupaten Timor Tengah Selatan'),
  array('ID_Kab' => '313','ID_prov' => '19','Nama_Kab' => 'Kabupaten Timor Tengah Utara'),
  array('ID_Kab' => '314','ID_prov' => '19','Nama_Kab' => 'Kota Kupang')
);

/* `fotall67_dbproject1`.`tblNamaProject` */
$tblNamaProject = array(
  array('ID_ProName' => '1','NoKontrak' => 'PPH01012020','ID_perus' => '1','ID_proj' => '1','ID_prov' => '1','ID_Kab' => '1','ID_pemb' => '1','ProName' => 'Test 1','NilPro' => '0','Tgl_Mulai' => '2018-02-06 00:00:00','Tgl_Akhir' => '2018-05-30 00:00:00'),
  array('ID_ProName' => '6','NoKontrak' => 'PPH02012021','ID_perus' => '1','ID_proj' => '1','ID_prov' => '2','ID_Kab' => '25','ID_pemb' => '2','ProName' => NULL,'NilPro' => '0','Tgl_Mulai' => NULL,'Tgl_Akhir' => NULL),
  array('ID_ProName' => '7','NoKontrak' => 'PPH04012022','ID_perus' => '1','ID_proj' => '2','ID_prov' => '5','ID_Kab' => '89','ID_pemb' => '2','ProName' => NULL,'NilPro' => '0','Tgl_Mulai' => NULL,'Tgl_Akhir' => NULL),
  array('ID_ProName' => '8','NoKontrak' => 'SKN01012030','ID_perus' => '2','ID_proj' => '2','ID_prov' => '7','ID_Kab' => '107','ID_pemb' => '1','ProName' => NULL,'NilPro' => '0','Tgl_Mulai' => NULL,'Tgl_Akhir' => NULL),
  array('ID_ProName' => '9','NoKontrak' => 'PPH0303000','ID_perus' => '1','ID_proj' => '1','ID_prov' => '13','ID_Kab' => '191','ID_pemb' => '2','ProName' => NULL,'NilPro' => '0','Tgl_Mulai' => NULL,'Tgl_Akhir' => NULL),
  array('ID_ProName' => '12','NoKontrak' => 'PPH700','ID_perus' => '1','ID_proj' => '1','ID_prov' => '14','ID_Kab' => '198','ID_pemb' => '2','ProName' => NULL,'NilPro' => '0','Tgl_Mulai' => NULL,'Tgl_Akhir' => NULL),
  array('ID_ProName' => '14','NoKontrak' => 'PPH20202021110','ID_perus' => '1','ID_proj' => '1','ID_prov' => '14','ID_Kab' => '198','ID_pemb' => '1','ProName' => 'Benih Jagung Hybrida','NilPro' => '2000000','Tgl_Mulai' => '2020-06-01 00:00:00','Tgl_Akhir' => '2020-07-06 00:00:00'),
  array('ID_ProName' => '16','NoKontrak' => '170620PPH','ID_perus' => '1','ID_proj' => '1','ID_prov' => '11','ID_Kab' => '156','ID_pemb' => '1','ProName' => 'Jagung Banten','NilPro' => '0','Tgl_Mulai' => NULL,'Tgl_Akhir' => NULL)
);

/* `fotall67_dbproject1`.`tblPembiayaan` */
$tblPembiayaan = array(
  array('ID_pemb' => '1','Pembiayaan' => 'APBN'),
  array('ID_pemb' => '2','Pembiayaan' => 'APBN2')
);

/* `fotall67_dbproject1`.`tblProject` */
$tblProject = array(
  array('ID_proj' => '1','Project' => 'Jagung'),
  array('ID_proj' => '2','Project' => 'Padi')
);

/* `fotall67_dbproject1`.`tblProv` */
$tblProv = array(
  array('ID_prov' => '1','NameProv' => 'Aceh'),
  array('ID_prov' => '2','NameProv' => 'Sumatera Utara'),
  array('ID_prov' => '3','NameProv' => 'Sumatera Barat'),
  array('ID_prov' => '4','NameProv' => 'Riau'),
  array('ID_prov' => '5','NameProv' => 'Kepulauan Riau'),
  array('ID_prov' => '6','NameProv' => 'Jambi'),
  array('ID_prov' => '7','NameProv' => 'Bengkulu'),
  array('ID_prov' => '8','NameProv' => 'Sumatera Selatan'),
  array('ID_prov' => '9','NameProv' => 'Kepulauan Bangka Belitung'),
  array('ID_prov' => '10','NameProv' => 'Lampung'),
  array('ID_prov' => '11','NameProv' => 'Banten'),
  array('ID_prov' => '12','NameProv' => 'Jawa Barat'),
  array('ID_prov' => '13','NameProv' => 'DKI Jakarta'),
  array('ID_prov' => '14','NameProv' => 'Jawa Tengah'),
  array('ID_prov' => '15','NameProv' => 'DI Yogyakarta'),
  array('ID_prov' => '16','NameProv' => 'Jawa Timur'),
  array('ID_prov' => '17','NameProv' => 'Bali'),
  array('ID_prov' => '18','NameProv' => 'Nusa Tenggara Barat'),
  array('ID_prov' => '19','NameProv' => 'Nusa Tenggara Timur'),
  array('ID_prov' => '20','NameProv' => 'Kalimantan Utara'),
  array('ID_prov' => '21','NameProv' => 'Kalimantan Barat'),
  array('ID_prov' => '22','NameProv' => 'Kalimantan Tengah'),
  array('ID_prov' => '23','NameProv' => 'Kalimantan Selatan'),
  array('ID_prov' => '24','NameProv' => 'Kalimantan Timur'),
  array('ID_prov' => '25','NameProv' => 'Gorontalo'),
  array('ID_prov' => '26','NameProv' => 'Sulawesi Utara'),
  array('ID_prov' => '27','NameProv' => 'Sulawesi Barat'),
  array('ID_prov' => '28','NameProv' => 'Sulawesi Tengah'),
  array('ID_prov' => '29','NameProv' => 'Sulawesi Selatan'),
  array('ID_prov' => '30','NameProv' => 'Sulawesi Tenggara'),
  array('ID_prov' => '31','NameProv' => 'Maluku Utara'),
  array('ID_prov' => '32','NameProv' => 'Maluku'),
  array('ID_prov' => '33','NameProv' => 'Papua Barat'),
  array('ID_prov' => '34','NameProv' => 'Papua')
);

/* `fotall67_dbproject1`.`tblPrsh` */
$tblPrsh = array(
  array('ID_perus' => '1','NameCo' => 'PT Pelangi Permata Hasada'),
  array('ID_perus' => '2','NameCo' => 'PT Sadaya Karunia Nuansa'),
  array('ID_perus' => '3','NameCo' => 'CV Sinar Aras'),
  array('ID_perus' => '4','NameCo' => 'Mitra Multi Komunika')
);

/* `fotall67_dbproject1`.`tblTahap` */
$tblTahap = array(
  array('ID_Tahap' => '1','Tahapan' => 'Penerimaan Order'),
  array('ID_Tahap' => '2','Tahapan' => 'Pengiriman Ke Gudang'),
  array('ID_Tahap' => '3','Tahapan' => 'Dropping'),
  array('ID_Tahap' => '4','Tahapan' => 'Penagihan')
);

/* `fotall67_dbproject1`.`tblThn` */
$tblThn = array(
  array('ID_thn' => '1','YearProj' => '2012'),
  array('ID_thn' => '2','YearProj' => '2013'),
  array('ID_thn' => '3','YearProj' => '2014'),
  array('ID_thn' => '4','YearProj' => '2015'),
  array('ID_thn' => '5','YearProj' => '2016'),
  array('ID_thn' => '6','YearProj' => '2017'),
  array('ID_thn' => '7','YearProj' => '2018'),
  array('ID_thn' => '8','YearProj' => '2019'),
  array('ID_thn' => '9','YearProj' => '2020')
);

/* `fotall67_dbproject1`.`tblTkpel` */
$tblTkpel = array(
  array('ID_tkpel' => '1','Tk_Pelaksanan' => 'Provinsi'),
  array('ID_tkpel' => '2','Tk_Pelaksanan' => 'Kabupaten')
);

Write a Reply or Comment

Your email address will not be published.

TOP