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'))));
