public function is_bank_account($account_code) { $criteria = new CDbCriteria(); $criteria->addCondition("account_code =" . $account_code); $bank_act = PahBankAccounts::model()->find($criteria); if ($bank_act != null) { return $bank_act->id; } else { return false; } }
<div class="span-8 last"> <?php echo $form->label($model, 'pah_donatur_id'); ?> <?php echo $form->dropDownList($model, 'pah_donatur_id', GxHtml::listDataEx(PahDonatur::model()->findAllAttributes(null, true)), array('prompt' => Yii::t('app', 'All'))); ?> </div> <div class="span-8 last"> <?php echo $form->label($model, 'pah_bank_accounts_id'); ?> <?php echo $form->dropDownList($model, 'pah_bank_accounts_id', GxHtml::listDataEx(PahBankAccounts::model()->findAllAttributes(null, true)), array('prompt' => Yii::t('app', 'All'))); ?> </div> <div class="span-8 last"> <?php echo $form->label($model, 'users_id'); ?> <?php echo $form->dropDownList($model, 'users_id', GxHtml::listDataEx(Users::model()->findAllAttributes(null, true)), array('prompt' => Yii::t('app', 'All'))); ?> </div> <div class="row buttons"> <?php echo GxHtml::submitButton(Yii::t('app', 'Search'));
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 PahBankAccounts('search'); //$model->unsetAttributes(); $criteria = new CDbCriteria(); // $criteria->limit = $limit; // $criteria->offset = $start; $model = PahBankAccounts::model()->findAll($criteria); $total = PahBankAccounts::model()->count($criteria); if (isset($_GET['PahBankAccounts'])) { $model->attributes = $_GET['PahBankAccounts']; } if (isset($_GET['output']) && $_GET['output'] == 'json') { $this->renderJson($model, $total); } else { $model = new PahBankAccounts('search'); $model->unsetAttributes(); $this->render('admin', array('model' => $model)); } }
static function account_used_bank($account) { $criteria = new CDbCriteria(); $criteria->addCondition("account_code = '{$account}'"); $count = PahBankAccounts::model()->count($criteria); return $count > 0; }
<?php echo $form->labelEx($model, 'pah_donatur_id'); ?> <?php echo $form->dropDownList($model, 'pah_donatur_id', GxHtml::listDataEx(PahDonatur::model()->findAllAttributes(null, true))); ?> <?php echo $form->error($model, 'pah_donatur_id'); ?> </div><!-- row --> <div class="span-8 last"> <?php echo $form->labelEx($model, 'pah_bank_accounts_id'); ?> <?php echo $form->dropDownList($model, 'pah_bank_accounts_id', GxHtml::listDataEx(PahBankAccounts::model()->findAllAttributes(null, true))); ?> <?php echo $form->error($model, 'pah_bank_accounts_id'); ?> </div><!-- row --> <div class="span-8 last"> <?php echo $form->labelEx($model, 'users_id'); ?> <?php echo $form->dropDownList($model, 'users_id', GxHtml::listDataEx(Users::model()->findAllAttributes(null, true))); ?> <?php echo $form->error($model, 'users_id'); ?>
public function actionDelete() { if (!Yii::app()->request->isAjaxRequest) { return; } if (isset($_POST) && !empty($_POST)) { $gl = new GlPah(); $id = $_POST['id']; $memo_ = $_POST['memo_']; $status = false; $msg = 'Aktivitas berhasil divoid.'; $user = Yii::app()->user->getId(); //require_once(Yii::app()->basePath . '/vendors/frontaccounting/ui.inc'); app()->db->autoCommit = false; $transaction = app()->db->beginTransaction(); try { $aktivitas = PahAktivitas::model()->findByPk($id); $date = $aktivitas->trans_date; $docref = $aktivitas->doc_ref; // $bank_account = $kas_masuk->pah_bank_accounts_id; $void = new PahVoided(); $void->type = AKTIVITAS; $void->id = $id; $void->date_ = $date; $void->memo_ = $memo_; if (!$void->save()) { throw new Exception("Gagal menyimpan void."); } $bank = PahBankAccounts::model()->findByPk($aktivitas->pah_bank_accounts_id); $act_sub = $aktivitas->pahSubAktivitas->account_code; //void gl //beban kredit , kas debet karena pengeluaran $gl->add_gl(VOID, $void->id_voided, $date, $docref, $bank->account_code, "VOID Aktivitas {$docref}", $aktivitas->amount, $user); $gl->add_gl(VOID, $void->id_voided, $date, $docref, $act_sub, "VOID Aktivitas {$docref}", -$aktivitas->amount, $user); $gl->validate(); $transaction->commit(); $status = true; } catch (Exception $ex) { $transaction->rollback(); $status = false; $msg = $ex; } } echo CJSON::encode(array('success' => $status, 'msg' => $msg)); Yii::app()->end(); // if (Yii::app()->request->isPostRequest) { // $this->loadModel($id, 'PahAktivitas')->delete(); // // 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.')); }
<?php $this->breadcrumbs = array('Pah Bank Trans' => array('index'), Yii::t('app', 'Manage')); $this->menu = array(array('label' => Yii::t('app', 'List') . ' PahBankTrans', 'url' => array('index')), array('label' => Yii::t('app', 'Create') . ' PahBankTrans', 'url' => array('create'))); Yii::app()->clientScript->registerScript('search', "\n\$('.search-button').click(function(){\n\t\$('.search-form').toggle();\n\treturn false;\n});\n\$('.search-form form').submit(function(){\n\t\$.fn.yiiGridView.update('pah-bank-trans-grid', {\n\t\tdata: \$(this).serialize()\n\t});\n\treturn false;\n});\n"); ?> <h1><?php echo Yii::t('app', 'Manage'); ?> Pah Bank Trans</h1> <p style="display:none"> You may optionally enter a comparison operator (<, <=, >, >=, <> or =) at the beginning of each of your search values to specify how the comparison should be done. </p> <?php //echo GxHtml::link(Yii::t('app', 'Advanced Search'), '#', array('class' => 'search-button')); ?> <div class="search-form" style="display:none"> <?php $this->renderPartial('_search', array('model' => $model)); ?> </div><!-- search-form --> <?php $this->widget('zii.widgets.grid.CGridView', array('id' => 'pah-bank-trans-grid', 'dataProvider' => $model->search(), 'itemsCssClass' => 'table', 'filter' => $model, 'columns' => array('id', 'type', 'trans_no', array('name' => 'bank_act', 'value' => 'GxHtml::valueEx($data->bankAct)', 'filter' => GxHtml::listDataEx(PahBankAccounts::model()->findAllAttributes(null, true))), 'ref', 'trans_date', array('class' => 'CButtonColumn'))));