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)); } }
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(); }