public function actionCreateJurnalUmum() { // return; if (!app()->request->isAjaxRequest) { return; } if (isset($_POST) && !empty($_POST)) { $status = false; $msg = 'Jurnal umum berhasil disimpan.'; $user = app()->user->getId(); $detils = CJSON::decode($_POST['detil']); $transaction = app()->db->beginTransaction(); try { $ref = new MtReferenceCom(); $docref = $ref->get_next_reference(JURNAL_UMUM); $jurnal_umum_id = Mt::get_max_type_no(JURNAL_UMUM); $jurnal_umum_id++; foreach ($detils as $detil) { $amount = $detil['debit'] > 0 ? $detil['debit'] : -$detil['kredit']; Mt::add_gl(JURNAL_UMUM, $jurnal_umum_id, $_POST['tran_date'], $docref, $detil['account'], "-", $amount, $user, $detil['id_mobil']); } $ref->save(JURNAL_UMUM, $jurnal_umum_id, $docref); $transaction->commit(); $status = true; } catch (Exception $ex) { $transaction->rollback(); $status = false; $msg = $ex; } echo CJSON::encode(array('success' => $status, 'id' => $docref, 'msg' => $msg)); app()->end(); } }
public function actionCreate() { // return; $model = new MtPinjamKendaraan(); if (!Yii::app()->request->isAjaxRequest) { return; } if (isset($_POST) && !empty($_POST)) { $status = false; $msg = 'Peminjaman kendaraan berhasil disimpan.'; $transaction = app()->db->beginTransaction(); $id = -1; try { $ref = new MtReferenceCom(); $docref = $ref->get_next_reference(PINJAM_KENDARAAN); $user = app()->user->getId(); foreach ($_POST as $k => $v) { if ($k == 'ongkos_sewa' || $k == 'ongkos_driver' || $k == 'ongkos_bbm' || $k == 'total_ongkos' || $k == 'dp' || $k == 'sisa_tagihan' || $k == 'disc' || $k == 'total') { $v = get_number($v); } $_POST['MtPinjamKendaraan'][$k] = $v; } $_POST['MtPinjamKendaraan']['entry_time'] = Now(); $_POST['MtPinjamKendaraan']['id_driver'] = is_integer($_POST['MtPinjamKendaraan']['id_driver']) ? $_POST['MtPinjamKendaraan']['id_driver'] : NULL; $_POST['MtPinjamKendaraan']['users_id'] = $user; $_POST['MtPinjamKendaraan']['doc_ref'] = $docref; $model->attributes = $_POST['MtPinjamKendaraan']; $msg = "Data gagal disimpan"; if ($model->save()) { $status = true; $msg = "Data berhasil di simpan dengan id " . $model->id_pinjam; } else { $status = false; } $id = $docref; $date = $model->trans_date; $ref->save(PINJAM_KENDARAAN, $model->id_pinjam, $docref); if ($model->dp > 0) { $bank_account = '0'; if ($model->trans_via == "Tunai") { $bank_account = Mt::get_act_code_from_bank_act(Mt::get_prefs('akun_kas_ditangan')); } else { $bank_account = Mt::get_act_code_from_bank_act(Mt::get_prefs('akun_kas_dibank')); } // debet kas - kredit pendapatan Mt::add_gl(PINJAM_KENDARAAN, $model->id_pinjam, $date, $docref, $bank_account, '-', $model->dp, $user, $model->id_mobil); Mt::add_gl(PINJAM_KENDARAAN, $model->id_pinjam, $date, $docref, Mt::get_prefs('akun_uang_muka'), '-', -$model->dp, $user, $model->id_mobil); } $transaction->commit(); } catch (Exception $ex) { $transaction->rollback(); $status = false; $msg = $ex; } echo CJSON::encode(array('success' => $status, 'msg' => $msg, 'id' => $id)); Yii::app()->end(); } }
public function actionCreate() { if (!app()->request->isAjaxRequest) { return; } if (isset($_POST) && !empty($_POST)) { $status = false; $msg = 'Kas masuk berhasil disimpan.'; $user = app()->user->getId(); $id = -1; //require_once(Yii::app()->basePath . '/vendors/frontaccounting/ui.inc'); $transaction = app()->db->beginTransaction(); try { $ref = new MtReferenceCom(); $docref = $ref->get_next_reference(KAS_MASUK); $kas_masuk = new MtKasMasuk(); foreach ($_POST as $k => $v) { if ($k == 'amount') { $v = get_number($v); } $_POST['MtKasMasuk'][$k] = $v; } $date = $_POST['MtKasMasuk']['trans_date']; $_POST['MtKasMasuk']['entry_time'] = Now(); $_POST['MtKasMasuk']['users_id'] = $user; $_POST['MtKasMasuk']['doc_ref'] = $docref; $_POST['MtKasMasuk']['id_mobil'] = $_POST['MtKasMasuk']['id_mobil'] != '' ? $_POST['MtKasMasuk']['id_mobil'] : NULL; $kas_masuk->attributes = $_POST['MtKasMasuk']; $kas_masuk->save(); $id = $docref; $ref->save(KAS_MASUK, $kas_masuk->kas_masuk_id, $docref); $bank_account = Mt::get_act_code_from_bank_act($kas_masuk->mt_bank_accounts_id); $act_donatur = $kas_masuk->account_code; //debet kode kas/bank - kredit pendapatan Mt::add_gl(KAS_MASUK, $kas_masuk->kas_masuk_id, $date, $docref, $bank_account, '-', $kas_masuk->amount, $user, $kas_masuk->id_mobil); Mt::add_gl(KAS_MASUK, $kas_masuk->kas_masuk_id, $date, $docref, $act_donatur, $kas_masuk->note, -$kas_masuk->amount, $user, $kas_masuk->id_mobil); $transaction->commit(); $status = true; } catch (Exception $ex) { $transaction->rollback(); $status = false; $msg = $ex; } } echo CJSON::encode(array('success' => $status, 'id' => $id, 'msg' => $msg)); app()->end(); }
public function actionCreateTransfer() { if (!Yii::app()->request->isAjaxRequest) { return; } if (isset($_POST) && !empty($_POST)) { //require_once(Yii::app()->basePath . '/vendors/frontaccounting/ui.inc'); $status = false; $msg = 'Transfer antar kas berhasil diproses.'; $id = -1; $bank_asal = $_POST['bank_act_asal']; $bank_tujuan = $_POST['bank_act_tujuan']; $trans_date = $_POST['trans_date']; $memo = $_POST['memo']; $amount = get_number($_POST['amount']); if ($bank_asal == $bank_tujuan) { echo CJSON::encode(array('success' => false, 'id' => -1, 'msg' => 'Bank asal dan bank tujuan tidak boleh sama.')); Yii::app()->end(); } if ($amount <= 0) { echo CJSON::encode(array('success' => false, 'id' => -1, 'msg' => 'Jumlah yang akan ditransfer harus lebih dari nol.')); Yii::app()->end(); } $transaction = Yii::app()->db->beginTransaction(); try { $ref = new MtReferenceCom(); $docref = $ref->get_next_reference(BANKTRANSFER); $bank_account_asal = Mt::get_act_code_from_bank_act($bank_asal); $bank_account_tujuan = Mt::get_act_code_from_bank_act($bank_tujuan); $trans_no = Mt::get_next_trans_no_bank_trans(); $user = Yii::app()->user->getId(); //debet kode bank tujuan - kredit kode bank asal Mt::add_gl(BANKTRANSFER, $trans_no, $trans_date, $docref, $bank_account_tujuan, $memo, $amount, $user, null); Mt::add_gl(BANKTRANSFER, $trans_no, $trans_date, $docref, $bank_account_asal, $memo, -$amount, $user, null); $ref->save(BANKTRANSFER, $trans_no, $docref); $id = $docref; $transaction->commit(); $status = true; } catch (Exception $ex) { $transaction->rollback(); $status = false; $msg = $ex; } echo CJSON::encode(array('success' => $status, 'id' => $id, 'msg' => $msg)); Yii::app()->end(); } }
public function actionCreate() { $model = new MtKembaliKendaraan(); if (!Yii::app()->request->isAjaxRequest) { return; } if (isset($_POST) && !empty($_POST)) { $status = false; $msg = 'Peminjaman kendaraan berhasil disimpan.'; $transaction = app()->db->beginTransaction(); $id = -1; try { $ref = new MtReferenceCom(); $docref = $ref->get_next_reference(KEMBALI_KENDARAAN); $user = app()->user->getId(); foreach ($_POST as $k => $v) { if ($k == 'ongkos_sewa' || $k == 'ongkos_driver' || $k == 'ongkos_bbm' || $k == 'total_ongkos' || $k == 'dp' || $k == 'ongkos_extend' || $k == 'disc' || $k == 'total' || $k == 'pelunasan') { $v = get_number($v); } $_POST['MtKembaliKendaraan'][$k] = $v; } $_POST['MtKembaliKendaraan']['entry_time'] = Now(); $_POST['MtKembaliKendaraan']['users_id'] = $user; $_POST['MtKembaliKendaraan']['doc_ref_kembali'] = $docref; $model->attributes = $_POST['MtKembaliKendaraan']; $msg = "Data gagal disimpan"; if ($model->save()) { $status = true; $msg = "Data berhasil di simpan dengan id " . $model->id_kembali; } else { $status = false; } $id = $docref; $date = $model->trans_date; $ref->save(KEMBALI_KENDARAAN, $model->id_kembali, $docref); if ($model->pelunasan > 0) { $bank_account = '0'; if ($model->trans_via == "Tunai") { $bank_account = Mt::get_act_code_from_bank_act(Mt::get_prefs('akun_kas_ditangan')); } else { $bank_account = Mt::get_act_code_from_bank_act(Mt::get_prefs('akun_kas_dibank')); } Mt::add_gl(KEMBALI_KENDARAAN, $model->id_kembali, $date, $docref, $bank_account, '-', $model->pelunasan, $user, $model->idPinjam->id_mobil); Mt::add_gl(KEMBALI_KENDARAAN, $model->id_kembali, $date, $docref, Mt::get_prefs('akun_uang_muka'), "-", $model->dp, $user, $model->idPinjam->id_mobil); Mt::add_gl(KEMBALI_KENDARAAN, $model->id_kembali, $date, $docref, Mt::get_prefs('akun_pendapatan_sewa'), '-', -$model->total, $user, $model->idPinjam->id_mobil); if ($model->disc > 0) { Mt::add_gl(KEMBALI_KENDARAAN, $model->id_kembali, $date, $docref, Mt::get_prefs('akun_diskon'), "-", $model->disc, $user, $model->idPinjam->id_mobil); } } $pinjam = $this->loadModel($model->id_pinjam, 'MtPinjamKendaraan'); $pinjam->is_back = 1; $pinjam->id_driver = $_POST['MtKembaliKendaraan']['id_driver']; $pinjam->save(); $transaction->commit(); } catch (Exception $ex) { $transaction->rollback(); $status = false; $msg = $ex; } echo CJSON::encode(array('success' => $status, 'msg' => $msg, 'id' => $id)); Yii::app()->end(); } }