SISTEM INFORMASI MANAJEMEN ZAKAT, INFAK, DAN SEDEKAH PADA BADAN AMIL ZAKAT NASIONAL

1 SISTEM INFORMASI MANAJEMEN ZAKAT, INFAK, DAN SEDEKAH PADA BADAN AMIL ZAKAT NASIONAL Disusun Oleh: AGUNG PANDU DWIPRATAMA NIM: PROGRAM STUDI SISTEM I...
Author:  Inge Budiono

110 downloads 545 Views 3MB Size

Recommend Documents



username if (!isset($_SESSION['username'])) { include ('login.php'); exit; } else { include ('header.php'); } $meta_mustahiq = sanitizeOne($_GET['meta'], array( 'text' => 'plain'));

Penerimaan zakat maal
$query = "SELECT * FROM `mustahiq` WHERE `metadata` = '$meta_mustahiq' LIMIT 0 , 30 "; $hasil = mysql_query($query) or die("Error"); $data = mysql_fetch_array($hasil); ?>
Rincian Mustahiq Perorangan

Sukses menambah data mustahik
Gagal menambah data mustahik
Kategori Mustahik
Nama Mustahik
Pendapatan
" target="_blank">


// mengecek ada tidaknya session untuk username if (!isset($_SESSION['username'])) { include ('login.php'); exit; } else { include ('header.php');} if ($_POST['aksi'] == 'simpan') { $sql_GetFactor = "select rate from cat_zakatmaal where Id = $_POST[tipe_zakat];"; $sql_execGetFactor = mysql_query($sql_GetFactor); $sql_dataGetFactorRate = mysql_fetch_array($sql_execGetFactor); $zmaal_totalPay = sanitizeOne($_POST['txtPenerimaan'], array( 'txtPenerimaan' => 'int') ); $factor_rate = $sql_dataGetFactorRate['rate']; $z_TotalAmount = ($zmaal_totalPay / $factor_rate) * 100; $zMetaID = sha1("$_POST[metadata]" . time()); $profNumber = "$_POST[txtTanggalPenerimaan]/ZMAAL/00000" . rand(1, rand(4, 40) * 12) ; // sample match like this: 25/10/2010/Langsung/000003 $sql_saving = "INSERT INTO `zakat_mal_reception` (`zmaal_id` ,`zmaal_entryIn` ,`zmaal_totalAmount` ,`zmaal_totalPay` , `zmaal_MetaID`, `zmaal_catID` , `zmaal_muzakiMetaData`, `zmaal_status`) VALUES (NULL , '$_POST[txtTanggalPenerimaan]', '$z_TotalAmount', '$zmaal_totalPay', '$zMetaID', '$_POST[tipe_zakat]', '$_POST[metadata]', 'UNAPPROVED');"; $hasil_saving = mysql_query($sql_saving) or die("Error on saving data."); $sql_saving = "INSERT INTO `penerimaan_ziswaf` (`id_FundDistribution` ,`tanggal` ,`proofNumber` ,`jumlahUang` ,`tipe_pembayaran`, `tipe_penerimaan`, `IsPrinted`, `IdAkunBank`, `deskripsi` ,`tipe_status` , `metadata_user`, `UserAprovedBy`, `zMetaID`) VALUES (NULL , '$_POST[txtTanggalPenerimaan]', '$profNumber', '$_POST[txtPenerimaan]', '$_POST[cboCaraPenerimaan]', 'ZAKAT_MAAL', 'NO', '$_POST[cboNoRekening]', 'Pembayaran Zakat Maal untuk $_POST[namamuzaki] ', 'UNAPPROVED',

205

'$_POST[metadata]', '$_SESSION[username]', '$zMetaID');"; $hasil_saving = mysql_query($sql_saving) or die("Error on saving data."); if ($hasil_saving) { echo "<meta http-equiv='Refresh' content='0; url=trans_zmaal.php?status=sukses&metadata=$_POST [metadata]'>\n "; }} if ($_GET['aksi'] == 'hapus') { $sql_delZMaalTrans = "DELETE FROM `zakat_mal_reception` WHERE `zakat_mal_reception`.`zmaal_MetaID` = '$_GET[metazmaal]' LIMIT 1"; $hasil_delZMaalTrans = mysql_query($sql_delZMaalTrans) or die("Error on saving data."); $sql_delZMaalTrans = "DELETE FROM `penerimaan_ziswaf` WHERE `penerimaan_ziswaf`.`zMetaID` = '$_GET[metazmaal]' LIMIT 1"; $hasil_delZMaalTrans = mysql_query($sql_delZMaalTrans) or die("Error on saving data."); if ($hasil_delZMaalTrans) { echo "<meta http-equiv='Refresh' content='0; url=trans_zmaal.php?status=sukses&metadata=$_GET[ metadata]'>\n "; } } elseif ($_GET['aksi'] == 'update') { $sql_updateZMaalTrans = "UPDATE `zakat_mal_reception` SET `zmaal_status` = 'APPROVED' WHERE `zakat_mal_reception`.`zmaal_muzakiMetaData` = '$_GET[metadata]';"; $hasil_updateZMaalTrans = mysql_query($sql_updateZMaalTrans) or die("Error on updating data."); $sql_updateZMaalTrans = "UPDATE `penerimaan_ziswaf` SET `tipe_status` = 'APPROVED' WHERE `penerimaan_ziswaf`.`tipe_penerimaan` = 'ZAKAT_MAAL' AND `penerimaan_ziswaf`.`metadata_user` = '$_GET[metadata]';"; $hasil_updateZMaalTrans = mysql_query($sql_updateZMaalTrans) or die("Error on updating data."); if ($hasil_updateZMaalTrans) { echo "<meta http-equiv='Refresh' content='0; url=trans_ZiswafAndProgramReceiption.php?status=su kses'>\n "; }} $m_data = sanitizeOne($_GET['metadata'], array( 'metadata' => 'plain') ); $query = "SELECT * FROM `muzaki` where metadata = '$m_data' LIMIT 1;"; $hasil = mysql_query($query) or die("Error"); $data = mysql_fetch_array($hasil); $sql_NoRek = "select * from muzaki_account where id_muzaki = '$data[id_muzaki]'"; $sql_HasilNoRek = mysql_query($sql_NoRek); ?>
Tambah Pembayaran Zakat Maal


Entry data / perubahan sukses, silakan simpan atau entry data yang lainnya.
"; } elseif (($_POST['aksi'] == 'simpan') && !($hasil_saving)) { echo "
Entry data transaksi gagal.
"; }} ?>
Nama
<strong>NPWZ
Jenis Muzaki
Cara Penerimaan
<select name="cboCaraPenerimaan" id="cboCaraPenerimaan"> 0) { ?>
Nomor Rekening
<select name="cboNoRekening" id="cboNoRekening"> $sql_dataNoRek [rekening_namabank] $sql_dataNoRek[rekening_nomor]";} ?>
Tanggal Pembayaran <span class="style1">*
setIcon("calendar/images/iconCalendar.gif"); $myCalendar->setPath("calendar/"); $myCalendar->setDate(date('d'), date('m'), date('Y')); $myCalendar->setYearInterval(1950, 2020); $myCalendar->dateAllow('1950-01-01', '2020-12-31'); $myCalendar->setDateFormat('j F Y'); $myCalendar->writeScript(); ?>
Jenis Zakat
<select name="tipe_zakat" id="tipe_zakat">
206

while ($sql_data = mysql_fetch_array($sql_hasil)) { echo "";} ?>
Total Penerimaan <span class="style1">*
 

* tidak boleh kosong

0) { ?>


Detail Pembayaran Zakat Maal
<strong>Jenis Zakat
<strong>Dasar Pengenaan Zakat
<strong>Kadar (%)
<strong>Jumlah Zakat
<strong>Status
<strong>Aksi
UNAPPROVED

Penyaluran Langsung
207

$exec_update = mysql_query($sql_update); } elseif ($_GET['aksi'] == "terima") { $sql_update = "UPDATE `distribusi_dana` SET `MetaDataModifiedDate` = NOW( ) , `SubmissionStatusType` = 'APPROVED' WHERE `distribusi_dana`.`FundDistributionID`= '$_GET[id_dana]' LIMIT 1"; $exec_update = mysql_query($sql_update); } elseif ($_GET['aksi'] == "tolak") { $sql_update = "UPDATE `distribusi_dana` SET `MetaDataModifiedDate` = NOW( ) , `SubmissionStatusType` = 'UNAPPROVE' WHERE `distribusi_dana`.`FundDistributionID`= '$_GET[id_dana]' LIMIT 1"; $exec_update = mysql_query($sql_update); } if ($_POST['aksi'] == 'cari') { if ($_POST['cboTipeAsnaf'] != 'all') { $p_tAsnaf = " AND distribusi_dana.AsnafType = '$_POST[cboTipeAsnaf]' "; } else { $p_tAsnaf = "";} if ($_POST['cboPenerimaan'] != 'all') { $p_tPenerimaan = " AND distribusi_dana.FundDistributionType = '$_POST[cboPenerimaan]' "; } else { $p_tPenerimaan = "";} if ($_POST['cboStatus'] != 'all') { $p_tStatus = " AND distribusi_dana.SubmissionStatusType = '$_POST[cboStatus]' "; } else { $p_tStatus = "";} if ($_POST['cboJenisDana'] != 'all') { $p_tJenisDana = " AND distribusi_dana.SubProgramID = '$_POST[cboJenisDana]'"; } else { $p_tJenisDana = "";} $query = "Select zakat_sub_program.nama_subprogram, distribusi_dana.ProofNumber, distribusi_dana.FundSourceType, distribusi_dana.AsnafType, distribusi_dana.AmountOfMoney, distribusi_dana.Description, distribusi_dana.SubmissionStatusType, distribusi_dana.TransactionDate, distribusi_dana.FundDistributionID, distribusi_dana.FundDistributionType, distribusi_dana.SubProgramID From zakat_sub_program Inner Join distribusi_dana On zakat_sub_program.Id = distribusi_dana.SubProgramID Where distribusi_dana.TransactionDate Between '$_POST[txtDari]' And '$_POST[txtSampai]'"; $query = $query . $p_tAsnaf . $p_tPenerimaan . $p_tStatus . $p_tJenisDana; } else { $query = "Select zakat_sub_program.nama_subprogram, distribusi_dana.ProofNumber, distribusi_dana.FundSourceType, distribusi_dana.AsnafType, distribusi_dana.AmountOfMoney, distribusi_dana.Description, distribusi_dana.SubmissionStatusType, distribusi_dana.TransactionDate, distribusi_dana.FundDistributionID, distribusi_dana.FundDistributionType, distribusi_dana.SubProgramID From zakat_sub_program Inner Join distribusi_dana On zakat_sub_program.Id = distribusi_dana.SubProgramID";

} $hasil = mysql_query($query) or die("Error"); ?>
Kriteria Pencarian Transaksi Penyaluran
Sukses mengupdate data!
Gagal update data!
Tipe Asnaf
\
Pencarian Data Penerimaan ZIS
Tipe Penyaluran
: <select name="cboPenerimaan" id="cboPenerimaan">
Status
: <select name="cboStatus" id="cboStatus">
: <select name="cboTipeAsnaf" id="cboTipeAsnaf"> 0) { ?>
Jenis Dana
: € <select name="cboJenisDana" id="cboJenisDana">

208

0) { ?>
Periode
setIcon("calendar/images/iconCalendar.gif"); $myCalendar->setPath("calendar/"); $myCalendar->setDate(date('d'), date('m'), date('Y')); $myCalendar->setYearInterval(1950, 2020); $myCalendar->dateAllow('1950-01-01', '2020-12-31'); $myCalendar->setDateFormat('j F Y'); $myCalendar->writeScript(); ?>setIcon("calendar/images/iconCalendar.gif"); $myCalendar->setPath("calendar/"); $myCalendar->setDate(date('d'), date('m'), date('Y')); $myCalendar->setYearInterval(1950, 2020); $myCalendar->dateAllow('1950-01-01', '2020-12-31'); $myCalendar->setDateFormat('j F Y'); $myCalendar->writeScript(); ?>
 
0) { ?>


Hasil Pencarian Laporan Penyaluran ()
<strong>Nomor
<strong>Tipe &
Subprogram
<strong>Jenis Dana
<strong>Asnaf
<strong>Jumlah Dana
<strong>Deskripsi
<strong>Status
<strong>Tanggal
<strong>Aksi

35) { echo substr($data['Description'],0,34) . '...'; } else { echo $data['Description']; }?>
<select name="select" id="select">
Data transaksi tidak ada.

 



209

LAMPIRAN TAMPILAN APLIKASI Muka

Login

210

Form Pendaftaran Muzakki

Daftar Muzakki

211

Data Detail Muzakki

Input Nomor Rekening Muzakki

212

Data Rekening Muzakki

Form Pembayaran Zakat Fitrah

213

Form Pembayaran Zakat Maal

Form Pembayaran Infak

214

Data Transaksi Penerimaan

Data Rincian Penerimaan Zakat Maal

215

Bukti Setor Zakat Maal

Laporan Penerimaan

216

Rekening Koran

Form Pendaftaran Mustahik

217

Data Detail Mustahik

Daftar Mustahik

218

Penyaluran Langsung

Penyaluran Program

219

Data Transaksi Penyaluran

Data Detail Penyaluran

220

Bukti Salur

Laporan Penyaluran

221

Daftar Program Penyaluran Utama

Daftar Sub Program Penyaluran

222

Daftar Kategori Zakat Maal

Daftar Kategori Mustahik

223