public function actionDelete($id) { if (Yii::app()->request->isPostRequest) { $status = true; $msg = "Akun bank berhasil dibuat"; if (Pah::account_in_gl_trans($id)) { $status = false; $msg = "Akun bank gagal dibuat, karena account sudah dipakai transaksi."; } if (Pah::account_used_bank($id) && $status) { $status = false; $msg = "Akun bank gagal dibuat, karena account dipakai akun bank lain."; } if ($status) { $this->loadModel($id, 'PahBankAccounts')->delete(); } echo CJSON::encode(array('success' => $status, 'msg' => $msg)); Yii::app()->end(); if (!Yii::app()->request->isAjaxRequest) { $this->redirect(array('admin')); } } else { throw new CHttpException(400, Yii::t('app', 'Invalid request. Please do not repeat this request again.')); } }
public function actionCreateTransfer() { if (!Yii::app()->request->isAjaxRequest) { return; } if (isset($_POST) && !empty($_POST)) { $gl = new GlPah(); //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(); } app()->db->autoCommit = false; $transaction = app()->db->beginTransaction(); try { $ref = new PahReferenceCom(); $docref = $ref->get_next_reference(BANKTRANSFER); $bank_account_asal = Pah::get_act_code_from_bank_act($bank_asal); $bank_account_tujuan = Pah::get_act_code_from_bank_act($bank_tujuan); $trans_no = Pah::get_next_trans_no_bank_trans(); $user = Yii::app()->user->getId(); //debet kode bank tujuan - kredit kode bank asal $gl->add_gl(BANKTRANSFER, $trans_no, $trans_date, $docref, $bank_account_tujuan, $memo, $amount, $user); $gl->add_gl(BANKTRANSFER, $trans_no, $trans_date, $docref, $bank_account_asal, $memo, -$amount, $user); $ref->save(BANKTRANSFER, $trans_no, $docref); $id = $docref; $gl->validate(); $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 actionIsPeriodeExist() { if (!Yii::app()->request->isAjaxRequest) { return; } if (isset($_POST) && !empty($_POST)) { $bulan = $_POST['bulan']; $tahun = $_POST['tahun']; if ($bulan === '' || $tahun === '') { echo CJSON::encode(array('success' => false, 'msg' => 'Bulan atau Tahun periode tidak boleh kosong.')); Yii::app()->end(); } if (Pah::is_periode_anggaran_exist($bulan, $tahun)) { echo CJSON::encode(array('success' => false, 'msg' => 'Anggaran dengan periode yang anda pilih sudah ada, silahkan gunakan menu ubah.')); Yii::app()->end(); } else { echo CJSON::encode(array('success' => true, 'msg' => 'sukses')); Yii::app()->end(); } } }
static function get_total_beban_grup($start_date, $end_date, $anak_id) { $void = Pah::get_voided(T_AKTIVITASGRUP); // $void = Pah::get_voided(7); $void_st = ''; if (count($void) > 0) { $void_st = "and pah_aktivitas_grup_trans.aktivitas_id not in (" . join(',', $void) . ")"; } $per_anak = $anak_id == 'undefined' ? '' : "AND pah_member.id = {$anak_id}"; $rows = Yii::app()->db->createCommand()->select("Sum(pah_aktivitas_grup_trans.amount) as amount")->from("pah_aktivitas_grup_trans")->rightJoin("pah_aktivitas_grup", "pah_aktivitas_grup_trans.pah_aktivitas_grup_id = pah_aktivitas_grup.id and\r\n pah_aktivitas_grup_trans.trans_date between '{$start_date}' and '{$end_date}' {$void_st}")->queryScalar(); return $rows == null ? 0 : $rows; }
public function actionIndex() { if (isset($_POST['limit'])) { $limit = $_POST['limit']; } else { $limit = 20; } if (isset($_POST['start'])) { $start = $_POST['start']; } else { $start = 0; } $param = array(); $void = Pah::get_voided(AKTIVITAS); $criteria = new CDbCriteria(); if (isset($_POST['doc_ref'])) { $criteria->addCondition("doc_ref like :doc_ref"); $param[':doc_ref'] = "%" . $_POST['doc_ref'] . "%"; } if (isset($_POST['no_bukti'])) { $criteria->addCondition("no_bukti like :no_bukti"); $param[':no_bukti'] = "%" . $_POST['no_bukti'] . "%"; } if (isset($_POST['amount'])) { $criteria->addCondition("amount = :amount"); $param[':amount'] = $_POST['amount']; } if (isset($_POST['trans_date'])) { $criteria->addCondition("trans_date = :trans_date"); $param[':trans_date'] = substr($_POST['trans_date'], 0, 10); } $criteria->limit = $limit; $criteria->offset = $start; $criteria->params = $param; $criteria->addNotInCondition('aktivitas_id', $void); $model = PahAktivitas::model()->findAll($criteria); $total = PahAktivitas::model()->count($criteria); $this->renderJson($model, $total); }
public function actionPengeluaranPerKodeRekeningDetil() { if (Yii::app()->request->isAjaxRequest) { return; } if (isset($_POST) && !empty($_POST)) { $format = $_POST['format']; $start_date = $_POST['trans_date_mulai']; $end_date = $_POST['trans_date_sampai']; $kode = $_POST['account_code']; $daftar_code = Pah::get_arr_kode_rekening_pengeluaran($kode); $index = 0; $objPHPExcel = new PHPExcel(); $objPHPExcel->getDefaultStyle()->getFont()->setSize(10); $file_name = 'PengeluaranPerKodeRekeningDetil'; foreach ($daftar_code as $key => $codename) { $start = 1; $worksheet_name = "{$key} - {$codename}"; if ($index > 0) { $objPHPExcel->createSheet($index); } $objPHPExcel->setActiveSheetIndex($index); $objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4); $objPHPExcel->getActiveSheet()->getPageMargins()->setLeft(0.1 / 2.54); $objPHPExcel->getActiveSheet()->getPageMargins()->setRight(0.1 / 2.54); $objPHPExcel->getActiveSheet()->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "LAPORAN DETIL PENGELUARAN " . strtoupper($codename))->getStyle("A{$start}")->getFont()->setSize(18)->setBold(true); $start++; $objPHPExcel->getActiveSheet()->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "PONDOK ASUH HARAPAN")->getStyle("A{$start}")->getFont()->setSize(14)->setBold(true); $start++; $objPHPExcel->getActiveSheet()->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "PERIODE: " . sql2long_date($start_date) . " - " . sql2long_date($end_date))->getStyle("A{$start}")->getFont()->setSize(12)->setBold(true); $objPHPExcel->getActiveSheet()->setTitle($worksheet_name); $start++; $start++; $start_body = $start; $objPHPExcel->getActiveSheet()->setCellValue("A{$start}", "Tgl")->setCellValue("B{$start}", "Keterangan")->setCellValue("C{$start}", "Debit")->setCellValue("D{$start}", "Kredit")->getStyle("A{$start}:D{$start}")->getFont()->setBold(true); $start++; $rows = Pah::get_pengeluaran_detil_kode_rekening($start_date, $end_date, $key); $total = Pah::get_total_pengeluaran($start_date, $end_date, $key); $total_persen = 0; foreach ($rows as $row) { // $total_persen += $row['total_beban'] / $total; // $total_beban = $row['total_beban']; // $persen = $row['total_beban'] / $total; $objPHPExcel->getActiveSheet()->setCellValue("A{$start}", $row['tran_date'])->setCellValue("B{$start}", $row['memo_'])->setCellValue("C{$start}", $row['debit'])->setCellValue("D{$start}", $row['kredit']); $start++; } //$total_format = $format == 'excel' ? $total : acc_format($total); $objPHPExcel->getActiveSheet()->setCellValue("A{$start}", 'Total')->setCellValue($total > 0 ? "C{$start}" : "D{$start}", $total); // ->setCellValue("C$start", $format == 'excel' ? $total_persen : percent_format($total_persen, 2)); $start++; $end_body = $start - 1; $styleArray = array('borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN))); $objPHPExcel->getActiveSheet()->getStyle("A{$start_body}:D{$end_body}")->applyFromArray($styleArray); $start_row = $start_body + 1; $objPHPExcel->getActiveSheet()->getStyle("C{$start_row}:D{$end_body}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_ACCOUNTING); // $objPHPExcel->getActiveSheet()->getStyle("C$start_row:C$end_body")->getNumberFormat() // ->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE_00); $objPHPExcel->getActiveSheet()->getColumnDimension("A")->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension("B")->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension("C")->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension("D")->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension("E")->setAutoSize(true); $start++; $jemaat = get_jemaat_from_user_id(Yii::app()->user->getId()); $objPHPExcel->getActiveSheet()->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "Dicetak oleh: " . $jemaat->real_name); $start++; $objPHPExcel->getActiveSheet()->mergeCells("A{$start}:G{$start}")->setCellValue("A{$start}", "Pada tanggal " . get_date_today('dd/MM/yyyy') . " jam " . get_time_now()); $index++; } ob_end_clean(); ob_start(); header('Content-Type: application/vnd.ms-excel'); header("Content-Disposition: attachment;filename={$file_name}.xls"); header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); Yii::app()->end(); } }
public function actionSetSaldoAwal() { if (!Yii::app()->request->isAjaxRequest) { return; } if (isset($_POST) && !empty($_POST)) { //require_once(Yii::app()->basePath . '/vendors/frontaccounting/ui.inc'); $status = false; $msg = 'Saldo Awal berhasil disimpan.'; $date = $_POST['trans_date']; $user = Yii::app()->user->getId(); $id = Pah::get_next_trans_saldo_awal(); app()->db->autoCommit = false; $transaction = app()->db->beginTransaction(); try { Yii::import('application.components.GlPah'); $gl = new GlPah(); $gl->add_gl(SALDO_AWAL, $id, $date, "-", $_POST['pah_chart_master_account_code'], '-', get_number($_POST['amount']), $user); $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(); } }