function prepareVariables($variables)
{
if ($variables["type"] == "percent") {
$variables["value"] = (double) str_replace("%", "", $variables["percentvalue"]);
} else {
$variables["value"] = currencyToNumber($variables["amountvalue"]);
}
return $variables;
}
function print_rekap_bank()
{
$search = array('id' => '', 'tanggal' => get_safe('tanggal'), 'kode' => get_safe('nokode'), 'nobukti' => get_safe('nobukti'), 'keterangan' => get_safe('uraian'), 'nominal' => currencyToNumber(get_safe('nominal')), 'jenis' => get_safe('jenis_transaksi'));
$data = $this->m_transaksi->get_list_penerimaan_banks(NULL, NULL, $search);
$data['attr'] = $this->m_laporan->data_header();
$display = get_safe('cetak');
if ($display === 'printer') {
$this->load->view('laporan/print-rekap-bank', $data);
} else {
$this->load->view('laporan/excel/rekap-bank', $data);
}
}
function update($variables)
{
if (!isset($variables["creditlimit"])) {
$variables["creditlimit"] = 0;
} else {
$variables["creditlimit"] = currencyToNumber($variables["creditlimit"]);
}
if (!isset($variables["hascredit"])) {
$variables["hascredit"] = 0;
$variables["creditlimit"] = 0;
}
$variables["hascredit"] = (int) $variables["hascredit"];
$updatestatement = "\n\t\t\t\tUPDATE\n\t\t\t\t\tclients\n\t\t\t\tSET\n\t\t\t\t\thascredit = " . $variables["hascredit"] . ",\n\t\t\t\t\tcreditlimit = " . $variables["creditlimit"] . "\n\t\t\t\tWHERE\n\t\t\t\t\tid =" . $this->id;
$this->db->query($updatestatement);
return true;
}
}
mysql_query($sql);
$result['status'] = TRUE;
die(json_encode($result));
}
if ($method === 'delete_in_out_uang') {
$id = $_GET['id'];
mysql_query("delete from arus_kas where id = '{$id}'");
}
if ($method === 'save_billing') {
session_start();
$id_pasien = $_POST['id_pasien'];
$id_daftar = $_POST['id_pendaftaran'];
$pembayaran = currencyToNumber($_POST['pembayaran']);
$total = currencyToNumber($_POST['total_tagihan']);
$nominal = currencyToNumber($_POST['serahuang']);
$id_bank = $_POST['bank'] !== '' ? $_POST['bank'] : 'NULL';
$nokartu = $_POST['nokartu'];
$cara_bayar = $_POST['cara_bayar'];
$diskon = $_POST['diskon'];
$sql = "insert into pembayaran_billing set\n id_pendaftaran = '{$id_daftar}',\n tanggal = NOW(),\n waktu = NOW(),\n total = '{$total}',\n bayar = '{$pembayaran}',\n diskon = '{$diskon}',\n uang_serah = '{$nominal}',\n cara_bayar = '{$cara_bayar}',\n id_bank = {$id_bank},\n no_kartu = '{$nokartu}'";
mysql_query($sql);
$id = mysql_insert_id();
$upt = "update pendaftaran set is_bayar = '1' where id = '{$id_daftar}'";
mysql_query($upt);
$qyr = mysql_query("select p.id, p.total \n FROM penjualan p \n join resep r on (p.id_resep = r.id) \n where r.id_pendaftaran = '{$id_daftar}'");
while ($row = mysql_fetch_object($qyr)) {
$query = "insert into arus_kas set \n transaksi = 'Penjualan Resep',\n id_transaksi = '" . $row->id . "',\n id_users = '" . $_SESSION['id_user'] . "',\n waktu = NOW(),\n masuk = '" . $row->total . "',\n diskon = '" . $row->total * ($diskon / 100) . "'";
mysql_query($query);
}
$qwe = mysql_query("select t.id, t.nominal \n from tindakan t\n join pemeriksaan pm on (t.id_pemeriksaan = pm.id_auto)\n join pendaftaran pdf on (pm.id_pendaftaran = pdf.id)\n where pm.id_pendaftaran = '{$id_daftar}'");
function pencairan_post()
{
$data_array = array('id' => post_safe('id'), 'tanggal' => date2mysql(post_safe('tanggal')), 'tanggal_kegiatan' => date2mysql(post_safe('tanggal_kegiatan')), 'id_rka' => post_safe('nokode'), 'no_bukti' => post_safe('nobukti'), 'uraian' => post_safe('uraian'), 'satuan' => post_safe('satuan'), 'volume' => post_safe('volume'), 'nominal' => currencyToNumber(post_safe('nominal')), 'penerima' => post_safe('penerima'), 'id_tahun_anggaran' => $this->id_tahun_anggaran);
$data = $this->m_transaksi->save_pencairan($data_array);
$this->response($data, 200);
}
function pembayaranadd()
{
if (isset($_POST['save'])) {
$data = array('id_transaksi' => $this->input->post('id_transaksi'), 'jml_tagihan' => $this->input->post('tagihan'), 'tgl_bayar' => date("Y-m-d"), 'jml_bayar' => currencyToNumber($this->input->post('jml_pembayaran')), 'kd_kasir' => $this->session->userdata('id_user'));
$this->db->insert('pembayaran', $data);
redirect('transaksi/kasir/msg/ok');
}
}
function save_pendaftaran_sumb()
{
$this->db->trans_begin();
$data_array = array('no_pendaftaran' => $this->create_no_daftar('SUMB'), 'tahun_ajaran' => post_safe('tahun_ajaran'), 'nama' => post_safe('nama_lengkap'), 'tempat' => post_safe('tempat_lahir'), 'tanggal_lahir' => date2mysql(post_safe('tanggal_lahir')), 'agama' => post_safe('agama'), 'jekel' => post_safe('jenis_kelamin'), 'alamat' => post_safe('alamat_rumah'), 'rt' => post_safe('rt'), 'rw' => post_safe('rw'), 'kabupaten' => post_safe('kabupaten'), 'kecamatan' => post_safe('kecamatan'), 'desa' => post_safe('desa'), 'id_desa' => NULL, 'telp' => post_safe('telp'), 'nama_ayah' => post_safe('nama_ayah'), 'nama_ibu' => post_safe('nama_ibu'), 'pekerjaan_ayah' => post_safe('pekerjaan_ayah'), 'pekerjaan_ibu' => post_safe('pekerjaan_ibu'), 'penghasilan_ayah' => currencyToNumber(post_safe('penghasilan_ayah')), 'penghasilan_ibu' => currencyToNumber(post_safe('penghasilan_ibu')), 'pembiaya' => post_safe('biayai'), 'nama_wali' => post_safe('nama_wali'), 'hubungan_wali' => post_safe('hubungan_wali'), 'penghasilan_wali' => currencyToNumber(post_safe('penghasilan_wali')), 'alamat_wali' => post_safe('alamat_wali'), 'asal_sekolah' => post_safe('asal_sekolah'), 'jurusan' => post_safe('jurusan'), 'status_sekolah' => post_safe('status_sekolah'), 'alamat_sekolah' => post_safe('alamat_sekolah'), 'telp_sekolah' => post_safe('telp_sekolah'), 'prodi_pil_1' => post_safe('pilihan1'), 'prodi_pil_2' => post_safe('pilihan2'), 'jenis_daftar' => 'SUMB');
$this->db->insert('tb_pendaftaran', $data_array);
$result['id'] = $this->db->insert_id();
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
$result['status'] = FALSE;
} else {
$this->db->trans_commit();
$result['status'] = TRUE;
}
$UploadDirectory = 'assets/img/pendaftaran/';
//Upload Directory, ends with slash & make sure folder exist
$NewFileName = "";
if (!@file_exists($UploadDirectory)) {
//destination folder does not exist
die('No upload directory');
}
if (isset($_FILES['ijasah']['name'])) {
$FileName = strtolower($_FILES['ijasah']['name']);
//uploaded file name
$ImageExt = substr($FileName, strrpos($FileName, '.'));
//file extension
$FileType = $_FILES['ijasah']['type'];
//file type
$RandNumber = rand(0, 99999);
//Random number to make each filename unique.
switch (strtolower($FileType)) {
//allowed file types
case 'image/png':
//png file
//png file
case 'image/gif':
//gif file
//gif file
case 'image/jpeg':
//jpeg file
break;
default:
die('Unsupported File!');
//output error
}
//File Title will be used as new File name
$NewFileName = preg_replace(array('/\\s/', '/\\.[\\.]+/', '/[^\\w_\\.\\-]/'), array('_', '.', ''), strtolower($data_array['no_pendaftaran']));
$NewFileName = $NewFileName . '_' . $RandNumber . $ImageExt;
//Rename and save uploded file to destination folder.
if (move_uploaded_file($_FILES['ijasah']["tmp_name"], $UploadDirectory . $NewFileName)) {
$this->db->where('id', $result['id']);
$this->db->update('tb_pendaftaran', array('ijasah' => $NewFileName));
} else {
die('error uploading File!');
}
}
if (isset($_FILES['hasil_un']['name'])) {
$FileName = strtolower($_FILES['hasil_un']['name']);
//uploaded file name
$ImageExt = substr($FileName, strrpos($FileName, '.'));
//file extension
$FileType = $_FILES['hasil_un']['type'];
//file type
$RandNumber = rand(0, 99999);
//Random number to make each filename unique.
switch (strtolower($FileType)) {
//allowed file types
case 'image/png':
//png file
//png file
case 'image/gif':
//gif file
//gif file
case 'image/jpeg':
//jpeg file
break;
default:
die('Unsupported File!');
//output error
}
//File Title will be used as new File name
$NewFileName = preg_replace(array('/\\s/', '/\\.[\\.]+/', '/[^\\w_\\.\\-]/'), array('_', '.', ''), strtolower($data_array['no_pendaftaran']));
$NewFileName = $NewFileName . '_' . $RandNumber . $ImageExt;
//Rename and save uploded file to destination folder.
if (move_uploaded_file($_FILES['hasil_un']["tmp_name"], $UploadDirectory . $NewFileName)) {
$this->db->where('id', $result['id']);
$this->db->update('tb_pendaftaran', array('hasil_un' => $NewFileName));
} else {
die('error uploading File!');
}
}
if (isset($_FILES['bukti1']['name'])) {
$FileName = strtolower($_FILES['bukti1']['name']);
//uploaded file name
$ImageExt = substr($FileName, strrpos($FileName, '.'));
//file extension
$FileType = $_FILES['bukti1']['type'];
//file type
$RandNumber = rand(0, 99999);
//Random number to make each filename unique.
switch (strtolower($FileType)) {
//allowed file types
case 'image/png':
//png file
//png file
case 'image/gif':
//gif file
//gif file
case 'image/jpeg':
//jpeg file
break;
default:
die('Unsupported File!');
//output error
}
//File Title will be used as new File name
$NewFileName = preg_replace(array('/\\s/', '/\\.[\\.]+/', '/[^\\w_\\.\\-]/'), array('_', '.', ''), strtolower($data_array['no_pendaftaran']));
$NewFileName = $NewFileName . '_' . $RandNumber . $ImageExt;
//Rename and save uploded file to destination folder.
if (move_uploaded_file($_FILES['bukti1']["tmp_name"], $UploadDirectory . $NewFileName)) {
$this->db->where('id', $result['id']);
$this->db->update('tb_pendaftaran', array('bukti1' => $NewFileName));
} else {
die('error uploading File!');
}
}
if (isset($_FILES['bukti2']['name'])) {
$FileName = strtolower($_FILES['bukti2']['name']);
//uploaded file name
$ImageExt = substr($FileName, strrpos($FileName, '.'));
//file extension
$FileType = $_FILES['bukti2']['type'];
//file type
$RandNumber = rand(0, 99999);
//Random number to make each filename unique.
switch (strtolower($FileType)) {
//allowed file types
case 'image/png':
//png file
//png file
case 'image/gif':
//gif file
//gif file
case 'image/jpeg':
//jpeg file
break;
default:
die('Unsupported File!');
//output error
}
//File Title will be used as new File name
$NewFileName = preg_replace(array('/\\s/', '/\\.[\\.]+/', '/[^\\w_\\.\\-]/'), array('_', '.', ''), strtolower($data_array['no_pendaftaran']));
$NewFileName = $NewFileName . '_' . $RandNumber . $ImageExt;
//Rename and save uploded file to destination folder.
if (move_uploaded_file($_FILES['bukti2']["tmp_name"], $UploadDirectory . $NewFileName)) {
$this->db->where('id', $result['id']);
$this->db->update('tb_pendaftaran', array('bukti2' => $NewFileName));
} else {
die('error uploading File!');
}
}
if (isset($_FILES['bukti3']['name'])) {
$FileName = strtolower($_FILES['bukti3']['name']);
//uploaded file name
$ImageExt = substr($FileName, strrpos($FileName, '.'));
//file extension
$FileType = $_FILES['bukti3']['type'];
//file type
$RandNumber = rand(0, 99999);
//Random number to make each filename unique.
switch (strtolower($FileType)) {
//allowed file types
case 'image/png':
//png file
//png file
case 'image/gif':
//gif file
//gif file
case 'image/jpeg':
//jpeg file
break;
default:
die('Unsupported File!');
//output error
}
//File Title will be used as new File name
$NewFileName = preg_replace(array('/\\s/', '/\\.[\\.]+/', '/[^\\w_\\.\\-]/'), array('_', '.', ''), strtolower($data_array['no_pendaftaran']));
$NewFileName = $NewFileName . '_' . $RandNumber . $ImageExt;
//Rename and save uploded file to destination folder.
if (move_uploaded_file($_FILES['bukti3']["tmp_name"], $UploadDirectory . $NewFileName)) {
$this->db->where('id', $result['id']);
$this->db->update('tb_pendaftaran', array('bukti3' => $NewFileName));
} else {
die('error uploading File!');
}
}
if (isset($_FILES['bukti4']['name'])) {
$FileName = strtolower($_FILES['bukti4']['name']);
//uploaded file name
$ImageExt = substr($FileName, strrpos($FileName, '.'));
//file extension
$FileType = $_FILES['bukti4']['type'];
//file type
$RandNumber = rand(0, 99999);
//Random number to make each filename unique.
switch (strtolower($FileType)) {
//allowed file types
case 'image/png':
//png file
//png file
case 'image/gif':
//gif file
//gif file
case 'image/jpeg':
//jpeg file
break;
default:
die('Unsupported File!');
//output error
}
//File Title will be used as new File name
$NewFileName = preg_replace(array('/\\s/', '/\\.[\\.]+/', '/[^\\w_\\.\\-]/'), array('_', '.', ''), strtolower($data_array['no_pendaftaran']));
$NewFileName = $NewFileName . '_' . $RandNumber . $ImageExt;
//Rename and save uploded file to destination folder.
if (move_uploaded_file($_FILES['bukti4']["tmp_name"], $UploadDirectory . $NewFileName)) {
$this->db->where('id', $result['id']);
$this->db->update('tb_pendaftaran', array('bukti4' => $NewFileName));
} else {
die('error uploading File!');
}
}
return $result;
}
?>
</td>
<td align="right"><?php
echo rupiah($sisa->sisa);
?>
</td>
<td align="right"><?php
echo rupiah($data->diskon);
?>
</td>
</tr>
<?php
$total_masuk = $total_masuk + $data->masuk;
$total_keluar = $total_keluar + $data->keluar;
$total_diskon = $total_diskon + currencyToNumber(rupiah($data->diskon));
}
?>
</tbody>
<tfoot>
<tr>
<td colspan="4" align="right"><b>TOTAL</b></td>
<td align="right"><b><?php
echo rupiah($total_masuk);
?>
</b></td>
<td align="right"><b><?php
echo rupiah($total_keluar);
?>
</b></td>
<td align="right"><b><?php
function _commonPrepareVariables($variables)
{
if (!isset($variables["unitprice"])) {
$variables["thumchange"] = 0;
}
if (!isset($variables["unitcost"])) {
$variables["thumchange"] = 0;
}
$variables["unitprice"] = currencyToNumber($variables["unitprice"]);
$variables["unitcost"] = currencyToNumber($variables["unitcost"]);
if (!isset($variables["thumbchange"])) {
$variables["thumbchange"] = NULL;
}
if ($variables["thumbchange"]) {
if ($variables["thumbchange"] == "upload") {
$variables["thumbnail"] = $this->getPicture("thumbnailupload");
$variables["thumbnailmime"] = $_FILES['thumbnailupload']['type'];
} else {
//delete
$variables["thumbnail"] = NULL;
$variables["thumbnailmime"] = NULL;
}
}
// end thumbnail picture change if
if (!isset($variables["picturechange"])) {
$variables["picturechange"] = NULL;
}
if ($variables["picturechange"]) {
if ($variables["picturechange"] == "upload") {
$variables["picture"] = $this->getPicture("pictureupload");
$variables["picturemime"] = $_FILES['pictureupload']['type'];
} else {
//delete
$variables["picture"] = NULL;
$variables["picturemime"] = NULL;
}
}
//end main picture change if
if (!isset($variables["addcats"])) {
$variables["addcats"] = array();
}
if ($variables["catschanged"]) {
$variables["addcats"] = stripslashes($variables["addcats"]);
$variables["addcats"] = json_decode($variables["addcats"], true);
}
//end if
return $variables;
}
function save_penerimaan()
{
$id = post_safe('id');
$data_array = array('id_parent' => post_safe('parent') !== '' ? post_safe('parent') : NULL, 'kode' => post_safe('judul'), 'nama_program' => post_safe('isi'), 'nominal' => currencyToNumber(post_safe('nominal')), 'id_tahun_anggaran' => post_safe('id_tahun_anggaran'));
if ($id === '') {
$this->db->insert('tb_master_penerimaan', $data_array);
$result['act'] = 'add';
$result['id'] = $this->db->insert_id();
} else {
$this->db->where('id', $id);
$this->db->update('tb_master_penerimaan', $data_array);
$result['act'] = 'edit';
$result['id'] = $id;
}
return $result;
}
function prepareVariables($variables)
{
$variables["amount"] = currencyToNumber($variables["amount"]);
if ($variables["ccnumber_old"] == $variables["ccnumber"]) {
unset($variables["ccnumber"]);
}
if ($variables["ccexpiration_old"] == $variables["ccexpiration"]) {
unset($variables["ccexpiration"]);
}
if ($variables["ccverification_old"] == $variables["ccverification"]) {
unset($variables["ccverification"]);
}
if ($variables["accountnumber_old"] == $variables["accountnumber"]) {
unset($variables["accountnumber"]);
}
if ($variables["routingnumber_old"] == $variables["routingnumber"]) {
unset($variables["routingnumber"]);
}
if ($variables["itemschanged"]) {
$variables["itemslist"] = stripslashes($variables["itemslist"]);
$variables["itemslist"] = json_decode($variables["itemslist"], true);
}
//end if
return $variables;
}
function save_import_pembayaran_mahasiswa()
{
$this->db->trans_begin();
$id = post_safe('id');
$UploadDirectory = 'assets/images/company/';
//Upload Directory, ends with slash & make sure folder exist
$NewFileName = "";
//die($UploadDirectory);
// replace with your mysql database details
if (!@file_exists($UploadDirectory)) {
//destination folder does not exist
die('No upload directory');
}
if ($id === '') {
if (isset($_FILES['mFile']['name'])) {
$foto = post_safe('foto');
$FileName = strtolower($_FILES['mFile']['name']);
//uploaded file name
$FileTitle = 'slide';
$ImageExt = substr($FileName, strrpos($FileName, '.'));
//file extension
$FileType = $_FILES['mFile']['type'];
//file type
//$FileSize = $_FILES['mFile']["size"]; //file size
$RandNumber = rand(0, 9999999999);
//Random number to make each filename unique.
//$uploaded_date = date("Y-m-d H:i:s");
if ($foto !== '') {
@unlink('assets/img/content/' . $foto);
}
switch (strtolower($FileType)) {
//allowed file types
case 'application/wps-office.xls':
//ms excel file
break;
default:
die('Unsupported File!');
//output error
}
//File Title will be used as new File name
$NewFileName = preg_replace(array('/\\s/', '/\\.[\\.]+/', '/[^\\w_\\.\\-]/'), array('_', '.', ''), strtolower($FileTitle));
$NewFileName = $NewFileName . '_' . $RandNumber . $ImageExt;
//Rename and save uploded file to destination folder.
/*if(move_uploaded_file($_FILES['mFile']["tmp_name"], $UploadDirectory . $NewFileName ))
{
//die('Success! File Uploaded.');
}else{
//die('error uploading File!');
}*/
}
// membaca file excel yang diupload
$data = new Spreadsheet_Excel_Reader($_FILES['mFile']['tmp_name']);
// membaca jumlah baris dari data excel
$baris = $data->rowcount($sheet_index = 0);
for ($i = 2; $i <= $baris; $i++) {
$nim = trim($data->val($i, 1));
$tanggal = $data->val($i, 3);
$transaksi = $data->val($i, 4);
$jumlah = $data->val($i, 5);
$norek = $data->val($i, 6);
//echo $nim.'#'.$tanggal.'#'.$transaksi.'#'.$jumlah.'#'.$norek.'<br/>';
$get = $this->db->query("select row_id from tb_mahasiswa where k_mhs = '{$nim}'")->row();
$get2 = $this->db->query("select id from tb_jenis_penerimaan where nama = '{$transaksi}'")->row();
$get3 = $this->db->query("select id from tb_bank where no_rekening = '{$norek}'")->row();
$array = array('tanggal' => date2mysql($tanggal), 'id_jenis_penerimaan' => $get2->id, 'id_mhs' => $get->row_id, 'nominal' => currencyToNumber($jumlah), 'id_bank' => $get3->id);
$this->db->insert('tb_pembayaran', $array);
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
$result['status'] = FALSE;
}
}
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
$result['status'] = FALSE;
} else {
$this->db->trans_commit();
$result['status'] = TRUE;
}
}
return $result;
}
function profile_buku_post()
{
$param = array('id' => post_safe('id'), 'kd_profile' => post_safe('kode'), 'nama' => post_safe('nama'), 'hrg_sewa' => currencyToNumber(post_safe('harga')), 'waktu' => post_safe('lama'), 'status' => post_safe('status'), 'ket' => post_safe('keterangan'));
$data = $this->m_masterdata->save_profile_buku($param);
$this->response($data, 200);
}
function prepareVariables($variables)
{
$variables["totaltni"] = currencyToNumber($variables["totaltni"]);
$variables["discountamount"] = currencyToNumber($variables["discountamount"]);
$variables["totaltaxable"] = (double) $variables["totaltaxable"];
$variables["totalti"] = currencyToNumber($variables["totalti"]);
$variables["shipping"] = currencyToNumber($variables["shipping"]);
$variables["tax"] = currencyToNumber($variables["tax"]);
$variables["amountpaid"] = currencyToNumber($variables["amountpaid"]);
if ($variables["type"] == "Invoice" && $variables["invoicedate"] == "") {
$variables["invoicedate"] = dateToString(mktime());
}
if ($variables["taxpercentage"] == "" or $variables["taxpercentage"] == "0" or $variables["taxpercentage"] == "0.0") {
$variables["taxpercentage"] = "NULL";
}
$variables["taxpercentage"] = str_replace("%", "", $variables["taxpercentage"]);
if ($variables["type"] == "VOID") {
$variables["totaltni"] = 0;
$variables["totalti"] = 0;
$variables["amountpaid"] = 0;
}
if (!isset($therecord["iscreditmemo"])) {
$therecord["iscreditmemo"] = 0;
}
if ($variables["ccnumber_old"] == $variables["ccnumber"]) {
unset($variables["ccnumber"]);
}
if ($variables["ccexpiration_old"] == $variables["ccexpiration"]) {
unset($variables["ccexpiration"]);
}
if ($variables["ccverification_old"] == $variables["ccverification"]) {
unset($variables["ccverification"]);
}
if ($variables["accountnumber_old"] == $variables["accountnumber"]) {
unset($variables["accountnumber"]);
}
if ($variables["routingnumber_old"] == $variables["routingnumber"]) {
unset($variables["routingnumber"]);
}
/**
* Lineitems are formated in JSON format, and need to be converted
* to a php array.
*/
if ($variables["lineitemschanged"] == 1) {
$variables["thelineitems"] = stripslashes($variables["thelineitems"]);
$variables["thelineitems"] = json_decode($variables["thelineitems"], true);
}
//endif
return $variables;
}
function updateSettings($variables)
{
if (!isset($variables["default_hascredit"])) {
$variables["default_hascredit"] = 0;
}
if (!isset($variables["prospects_on_orders"])) {
$variables["prospects_on_orders"] = 0;
}
if (!isset($variables["encrypt_payment_fields"])) {
$variables["encrypt_payment_fields"] = 0;
}
if (!isset($variables["show_payment_instructions"])) {
$variables["show_payment_instructions"] = 0;
}
$variables["default_creditlimit"] = currencyToNumber($variables["default_creditlimit"]);
/**
* Need to encrypt/obfuscate if changing from no encryption and
* decrypt if changing from encryption.
*/
if ($variables["encryptionStatusChanged"]) {
if ($variables["encrypt_payment_fields"] == 0) {
/**
* There has to be a valid encryption key path if the new
* encryption status is 0
*/
$this->decryptPaymentInformation();
if ($variables["encryptionPathChanged"]) {
/**
* If the path has changed, we need to make sure
* that it is a valid one.
*/
if (!$this->isValidPath($variables["encryption_key_path"])) {
unset($variables["encryption_key_path"]);
$this->updateErrorMessage = "Invalid encryption key path";
}
//end if --not valid path?--
}
//end if --path changed--
} else {
if ($variables["encryptionPathChanged"]) {
if ($this->isValidPath($variables["encryption_key_path"])) {
$res = fopen($variables["encryption_key_path"], "r");
$key = fread($res, filesize($variables["encryption_key_path"]));
fclose($res);
$key = trim($key);
$this->encryptPaymentInformation($key);
$this->obfuscatePaymentInformation();
} else {
$this->updateErrorMessage = "Invalid encryption key path";
unset($variables["encrypt_payment_fields"]);
unset($variables["encryption_key_path"]);
}
//end if -- valid path?--
} else {
if ($this->isValidPath(ENCRYPTION_KEY_PATH)) {
$this->encryptPaymentInformation();
$this->obfuscatePaymentInformation();
} else {
$this->updateErrorMessage = "No valid encryption key path";
unset($variables["encrypt_payment_fields"]);
}
//end if --encryption key defined--
}
//end if -- path changed?--
}
//end if --encrypt fields?--
} else {
if ($variables["encryptionPathChanged"]) {
if ($this->isValidPath($variables["encryption_key_path"])) {
if ($variables["encrypt_payment_fields"]) {
$this->decryptPaymentInformation();
$res = fopen($variables["encryption_key_path"], "r");
$key = fread($res, filesize($variables["encryption_key_path"]));
fclose($res);
$key = trim($key);
$this->encryptPaymentInformation($key);
$this->obfuscatePaymentInformation();
}
//end if --encrypt fields?--
} else {
unset($variables["encryption_key_path"]);
$this->updateErrorMessage = "Invalid encryption key path";
}
//end if --is valid path--
}
//end if --encryption path changed--
}
//end if -- status changed--
return $variables;
}
function save_jurnal_kredit($kode_rekening, $nama_transaksi, $kredit, $id_transaksi = NULL, $keterangan = NULL, $id_rekening = NULL)
{
$CI =& get_instance();
if ($id_rekening !== NULL) {
$id_rek = $id_rekening;
} else {
$get = $CI->db->query("select id from dc_rekening where kode = '{$kode_rekening}'")->row();
$id_rek = isset($get->id) ? $get->id : NULL;
}
$data_jurnal = array('id_transaksi' => $id_transaksi !== NULL ? $id_transaksi : NULL, 'transaksi' => $nama_transaksi, 'ket_transaksi' => $keterangan !== NULL ? $keterangan : '', 'id_rekening' => $id_rek, 'kredit' => currencyToNumber($kredit));
$CI->db->insert('dc_jurnal', $data_jurnal);
if ($CI->db->trans_status() === FALSE) {
$CI->db->trans_rollback();
}
}
$sql = "update penyakit set\n topik = '{$topik}',\n sub_kode = '{$subkode}'\n where id = '{$id}'";
mysql_query($sql);
$id_penyakit = $id;
}
die(json_encode(array('status' => TRUE, 'id_penyakit' => $id_penyakit)));
}
if ($method === 'delete_penyakit') {
$id = $_GET['id'];
mysql_query("delete from penyakit where id = '{$id}'");
}
if ($method === 'save_item_kit') {
$nama = $_POST['nama_item'];
$margin_pr = $_POST['margin_pr'];
$margin_rp = currencyToNumber($_POST['margin_rp']);
$diskon_pr = $_POST['diskon_pr'];
$diskon_rp = currencyToNumber($_POST['diskon_rp']);
$harga_jual = $_POST['harga_jual'];
$id_item = $_POST['id_item_kit'];
if ($id_item === '') {
$query = "insert into item_kit set\n nama = '{$nama}',\n margin_persen = '{$margin_pr}',\n margin_rupiah = '{$margin_rp}',\n diskon_persen = '{$diskon_pr}',\n diskon_rupiah = '{$diskon_rp}',\n harga_jual = '{$harga_jual}',\n status = 'TRUE'";
mysql_query($query);
$id_item_kit = mysql_insert_id();
} else {
$query = "update item_kit set\n nama = '{$nama}',\n margin_persen = '{$margin_pr}',\n margin_rupiah = '{$margin_rp}',\n diskon_persen = '{$diskon_pr}',\n diskon_rupiah = '{$diskon_rp}',\n harga_jual = '{$harga_jual}',\n status = 'TRUE'\n where id = '{$id_item}'";
mysql_query($query);
$id_item_kit = $id_item;
mysql_query("delete from item_kit_detail where id_item_kit = '{$id_item}'");
}
$id_barang = $_POST['id_barang'];
// array
$kemasan = $_POST['kemasan'];
