Example #1
0
<?php

$this->breadcrumbs = array('Pe Bank Trans' => array('index'), Yii::t('app', 'Manage'));
$this->menu = array(array('label' => Yii::t('app', 'List') . ' PeBankTrans', 'url' => array('index')), array('label' => Yii::t('app', 'Create') . ' PeBankTrans', '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('pe-bank-trans-grid', {\n\t\tdata: \$(this).serialize()\n\t});\n\treturn false;\n});\n");
?>

<h1><?php 
echo Yii::t('app', 'Manage');
?>
 Pe Bank Trans</h1>

<p style="display:none">
    You may optionally enter a comparison operator (&lt;, &lt;=, &gt;, &gt;=, &lt;&gt; 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' => 'pe-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(PeBankAccounts::model()->findAllAttributes(null, true))), 'ref', 'trans_date', array('class' => 'CButtonColumn'))));
Example #2
0
?>
    </div>
    <div class="span-8 last">
        <?php 
echo $form->label($model, 'pe_donatur_id');
?>
        <?php 
echo $form->dropDownList($model, 'pe_donatur_id', GxHtml::listDataEx(PeDonatur::model()->findAllAttributes(null, true)), array('prompt' => Yii::t('app', 'All')));
?>
    </div>
    <div class="span-8 last">
        <?php 
echo $form->label($model, 'pe_bank_accounts_id');
?>
        <?php 
echo $form->dropDownList($model, 'pe_bank_accounts_id', GxHtml::listDataEx(PeBankAccounts::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'));
?>
    </div>
Example #3
0
echo $form->labelEx($model, 'pe_supplier_id');
?>
        <?php 
echo $form->dropDownList($model, 'pe_supplier_id', GxHtml::listDataEx(PeSuppliers::model()->findAllAttributes(null, true)));
?>
        <?php 
echo $form->error($model, 'pe_supplier_id');
?>
    </div>
    <!-- row -->
    <div class="span-8 last">
        <?php 
echo $form->labelEx($model, 'pe_bank_accounts_id');
?>
        <?php 
echo $form->dropDownList($model, 'pe_bank_accounts_id', GxHtml::listDataEx(PeBankAccounts::model()->findAllAttributes(null, true)));
?>
        <?php 
echo $form->error($model, 'pe_bank_accounts_id');
?>
    </div>
    <!-- row -->
    <div class="span-8 last">
        <?php 
echo $form->labelEx($model, 'pe_member_id');
?>
        <?php 
echo $form->dropDownList($model, 'pe_member_id', GxHtml::listDataEx(PeMember::model()->findAllAttributes(null, true)));
?>
        <?php 
echo $form->error($model, 'pe_member_id');
 public function actionDelete($id)
 {
     if (!Yii::app()->request->isAjaxRequest) {
         return;
     }
     if (isset($_POST) && !empty($_POST)) {
         $id = $_POST['id'];
         $memo_ = $_POST['memo_'];
         $status = false;
         $msg = 'Transaksi 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 = PeAktivitasGrupTrans::model()->findByPk($id);
             $date = $aktivitas->trans_date;
             $docref = $aktivitas->doc_ref;
             //                $bank_account = $kas_masuk->pe_bank_accounts_id;
             $void = new PeVoided();
             $void->type = T_AKTIVITASGRUP;
             $void->id = $id;
             $void->date_ = $date;
             $void->memo_ = $memo_;
             if (!$void->save()) {
                 throw new Exception("Gagal menyimpan void.");
             }
             $bank = PeBankAccounts::model()->findByPk($aktivitas->pe_bank_accounts_id);
             $act_sub = $aktivitas->peSubAktivitas->account_code;
             //void gl
             //beban kredit , kas debet karena pengeluaran
             Pe::add_gl(VOID, $void->id_voided, $date, $docref, $bank->account_code, "VOID Aktivitas Grup {$docref}", $aktivitas->amount, $user);
             Pe::add_gl(VOID, $void->id_voided, $date, $docref, $act_sub, "VOID Aktivitas Grup {$docref}", -$aktivitas->amount, $user);
             $transaction->commit();
             $status = true;
         } catch (Exception $ex) {
             $transaction->rollback();
             $status = false;
             $msg = $ex;
         }
     }
     echo CJSON::encode(array('success' => $status, 'msg' => $msg));
     Yii::app()->end();
 }
 public function actionDelete()
 {
     if (!Yii::app()->request->isAjaxRequest) {
         return;
     }
     if (isset($_POST) && !empty($_POST)) {
         $id = $_POST['id'];
         $memo_ = $_POST['memo_'];
         $status = false;
         $msg = 'Kas keluar 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 {
             $kas_keluar = PeKasKeluar::model()->findByPk($id);
             $date = $kas_keluar->trans_date;
             $docref = $kas_keluar->doc_ref;
             //                $bank_account = $kas_masuk->pe_bank_accounts_id;
             $void = new PeVoided();
             $void->type = KAS_KELUAR;
             $void->id = $id;
             $void->date_ = $date;
             $void->memo_ = $memo_;
             if (!$void->save()) {
                 throw new Exception("Gagal menyimpan void.");
             }
             $bank = PeBankAccounts::model()->findByPk($kas_keluar->pe_bank_accounts_id);
             //void gl
             Pe::add_gl(VOID, $void->id_voided, $date, $docref, $bank->account_code, "VOID Kas Keluar {$docref}", $kas_keluar->amount, $user);
             Pe::add_gl(VOID, $void->id_voided, $date, $docref, $kas_keluar->pe_account_code, "VOID Kas Keluar {$docref}", -$kas_keluar->amount, $user);
             $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, 'PeKasKeluar')->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.'));
 }
 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 PeBankAccounts('search');
     //$model->unsetAttributes();
     $criteria = new CDbCriteria();
     //$criteria->limit = $limit;
     //$criteria->offset = $start;
     $model = PeBankAccounts::model()->findAll($criteria);
     $total = PeBankAccounts::model()->count($criteria);
     if (isset($_GET['PeBankAccounts'])) {
         $model->attributes = $_GET['PeBankAccounts'];
     }
     if (isset($_GET['output']) && $_GET['output'] == 'json') {
         $this->renderJson($model, $total);
     } else {
         $model = new PeBankAccounts('search');
         $model->unsetAttributes();
         $this->render('admin', array('model' => $model));
     }
 }
Example #7
0
 static function account_used_bank($account)
 {
     $criteria = new CDbCriteria();
     $criteria->addCondition("account_code = '{$account}'");
     $count = PeBankAccounts::model()->count($criteria);
     return $count > 0;
 }