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'];