public function actionIndex()
 {
     if (isset($_POST['limit'])) {
         $limit = $_POST['limit'];
     } else {
         $limit = 20;
     }
     if (isset($_POST['start'])) {
         $start = $_POST['start'];
     } else {
         $start = 0;
     }
     //$model = new MtBankAccounts('search');
     //$model->unsetAttributes();
     $criteria = new CDbCriteria();
     //        $criteria->limit = $limit;
     //        $criteria->offset = $start;
     $model = MtBankAccounts::model()->findAll($criteria);
     $total = MtBankAccounts::model()->count($criteria);
     if (isset($_GET['MtBankAccounts'])) {
         $model->attributes = $_GET['MtBankAccounts'];
     }
     if (isset($_GET['output']) && $_GET['output'] == 'json') {
         $this->renderJson($model, $total);
     } else {
         $model = new MtBankAccounts('search');
         $model->unsetAttributes();
         $this->render('admin', array('model' => $model));
     }
 }
Example #2
0
 static function account_used_bank($account)
 {
     $criteria = new CDbCriteria();
     $criteria->addCondition("account_code = '{$account}'");
     $count = MtBankAccounts::model()->count($criteria);
     return $count > 0;
 }
 public function actionDelete()
 {
     if (!app()->request->isAjaxRequest) {
         return;
     }
     if (isset($_POST) && !empty($_POST)) {
         $id = $_POST['id'];
         $memo_ = $_POST['memo_'];
         $status = false;
         $msg = 'Kas masuk berhasil divoid.';
         $user = app()->user->getId();
         $transaction = app()->db->beginTransaction();
         try {
             $kas_masuk = MtKasMasuk::model()->findByPk($id);
             $date = $kas_masuk->trans_date;
             $docref = $kas_masuk->doc_ref;
             $void = new MtVoided();
             $void->type = KAS_MASUK;
             $void->id = $id;
             $void->date_ = $date;
             $void->memo_ = $memo_;
             $void->save();
             $bank = MtBankAccounts::model()->findByPk($kas_masuk->mt_bank_accounts_id);
             $act_donatur = $kas_masuk->account_code;
             //void gl
             Mt::add_gl(VOID, $void->id_voided, $date, $docref, $act_donatur, "VOID Kas Masuk {$docref}", $kas_masuk->amount, $user, $kas_masuk->id_mobil);
             Mt::add_gl(VOID, $void->id_voided, $date, $docref, $bank->account_code, "VOID Kas Masuk {$docref}", -$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, 'msg' => $msg));
     app()->end();
 }