public function actionCreate()
 {
     $model = new fJournal();
     //$this->performAjaxValidation($model);
     //default value
     $_myDebit = 0;
     $_myCredit = 0;
     $model->balance = "NOT OK";
     if (isset($_POST['account_no_id'])) {
         $model->attributes = $_POST['fJournal'];
         $model->account_no_id = $_POST['account_no_id'];
         $model->debit = $_POST['debit'];
         $model->credit = $_POST['credit'];
         $model->user_remark = $_POST['user_remark'];
         foreach ($model->debit as $_debit) {
             $_myDebit = $_myDebit + $_debit;
         }
         foreach ($model->credit as $_credit) {
             $_myCredit = $_myCredit + $_credit;
         }
         if ($_myDebit == $_myCredit && $_myDebit != 0 && $_myCredit != 0) {
             $model->balance = "OK";
         } else {
             $model->balance = "NOT OK";
         }
         if ($model->validate()) {
             $modelHeader = new uJournal();
             $modelHeader->input_date = $_POST['fJournal']['input_date'];
             $modelHeader->yearmonth_periode = Yii::app()->settings->get("System", "cCurrentPeriod");
             $modelHeader->remark = $_POST['fJournal']['remark'];
             $modelHeader->entity_id = 1;
             $modelHeader->module_id = 1;
             //GL
             $modelHeader->state_id = 1;
             $modelHeader->journal_type_id = 1;
             $modelHeader->save();
             for ($i = 0; $i < sizeof($model->account_no_id); ++$i) {
                 $modelDetail = new uJournalDetail();
                 $modelDetail->parent_id = $modelHeader->id;
                 $modelDetail->account_no_id = $model->account_no_id[$i];
                 if ($model->debit[$i] != null) {
                     $modelDetail->debit = $model->debit[$i];
                 } else {
                     $modelDetail->debit = 0;
                 }
                 if ($model->credit[$i] != null) {
                     $modelDetail->credit = $model->credit[$i];
                 } else {
                     $modelDetail->credit = 0;
                 }
                 $modelDetail->user_remark = $model->user_remark[$i];
                 $modelDetail->sub_account_id = 0;
                 $modelDetail->save();
             }
             //Create System_ref
             $_ref = "GL-" . $modelHeader->yearmonth_periode . "-" . str_pad($modelHeader->id, 5, "0", STR_PAD_LEFT);
             $modelHeader->updateByPk((int) $modelHeader->id, array('system_ref' => $_ref));
             Yii::app()->user->setFlash("success", "<strong>Great!</strong> Journal created succesfully...");
             $this->redirect(array('/m2/uJournal'));
         }
     }
     $this->render('create', array('model' => $model));
 }
 public function actionCreate()
 {
     $model = new fJournal('cashbank');
     //$this->performAjaxValidation($model);
     $_myDebit = 0;
     $_myCredit = 0;
     $_myBalance = 0;
     $model->balance = "NOT OK";
     if (isset($_POST['account_no_id'])) {
         $model->attributes = $_POST['fJournal'];
         $model->validate();
         if (isset($_POST['fJournal']['cb_receiver'])) {
             //Expense
             $model->account_no_id = $_POST['account_no_id'];
             $model->debit = $_POST['debit'];
             $model->credit = $_POST['credit'];
             $model->user_remark = $_POST['user_remark'];
             foreach ($model->debit as $_debit) {
                 $_myDebit = $_myDebit + $_debit;
             }
             foreach ($model->credit as $_credit) {
                 $_myCredit = $_myCredit + $_credit;
             }
             $_myBalance = $_myDebit - $_myCredit;
             $model->balance = "OK";
             if ($model->validate()) {
                 $modelHeader = new uJournal();
                 $modelHeader->input_date = $_POST['fJournal']['input_date'];
                 $modelHeader->yearmonth_periode = Yii::app()->settings->get("System", "cCurrentPeriod");
                 $modelHeader->remark = $_POST['fJournal']['remark'];
                 $modelHeader->user_ref = $_POST['fJournal']['cb_receiver'];
                 $modelHeader->entity_id = sUser::model()->getGroup();
                 //default Group
                 $modelHeader->module_id = 2;
                 //CB
                 $modelHeader->state_id = 1;
                 $modelHeader->journal_type_id = 2;
                 //CB-expense
                 $modelHeader->save();
                 $_tdebet = 0;
                 $_tcredit = 0;
                 for ($i = 0; $i < sizeof($model->account_no_id); ++$i) {
                     $modelDetail = new uJournalDetail();
                     $modelDetail->parent_id = $modelHeader->id;
                     $modelDetail->account_no_id = $model->account_no_id[$i];
                     if ($model->debit[$i] != null) {
                         $modelDetail->debit = $model->debit[$i];
                     } else {
                         $modelDetail->debit = 0;
                     }
                     if ($model->credit[$i] != null) {
                         $modelDetail->credit = $model->credit[$i];
                     } else {
                         $modelDetail->credit = 0;
                     }
                     $modelDetail->user_remark = $model->user_remark[$i];
                     $modelDetail->save();
                 }
                 $modelDetail = new uJournalDetail();
                 $modelDetail->parent_id = $modelHeader->id;
                 $modelDetail->account_no_id = $_POST['fJournal']['var_account'];
                 $modelDetail->debit = 0;
                 $modelDetail->credit = $_myBalance;
                 $modelDetail->system_remark = "Automated by System";
                 $modelDetail->user_remark = $model->user_remark[0];
                 $modelDetail->save();
                 //Create System_ref
                 $_ref = "CB-" . $modelDetail->account->cashbank->mtext . "-" . $modelHeader->yearmonth_periode . "-EXP-" . str_pad($modelHeader->id, 5, "0", STR_PAD_LEFT);
                 $modelHeader->updateByPk((int) $modelHeader->id, array('system_ref' => $_ref));
                 Yii::app()->user->setFlash("success", "Journal created succesfully...");
                 $this->redirect(array('/mCashbank'));
             }
             $this->render('create', array('model' => $model));
             Yii::app()->end();
         } else {
             //Income
             $model->account_no_id = $_POST['account_no_id'];
             $model->debit = $_POST['debit'];
             $model->credit = $_POST['credit'];
             $model->user_remark = $_POST['user_remark'];
             foreach ($model->debit as $_debit) {
                 $_myDebit = $_myDebit + $_debit;
             }
             foreach ($model->credit as $_credit) {
                 $_myCredit = $_myCredit + $_credit;
             }
             $_myBalance = $_myCredit - $_myDebit;
             $model->balance = "OK";
             if ($model->validate()) {
                 $modelHeader = new uJournal();
                 $modelHeader->input_date = $_POST['fJournal']['input_date'];
                 $modelHeader->yearmonth_periode = Yii::app()->settings->get("System", "cCurrentPeriod");
                 $modelHeader->remark = $_POST['fJournal']['remark'];
                 $modelHeader->user_ref = $_POST['fJournal']['cb_received_from'];
                 $modelHeader->entity_id = sUser::model()->getGroup();
                 //default Group
                 $modelHeader->module_id = 2;
                 //CB
                 $modelHeader->state_id = 1;
                 $modelHeader->journal_type_id = 1;
                 //CB-Income
                 $modelHeader->save();
                 $modelDetail = new uJournalDetail();
                 $modelDetail->parent_id = $modelHeader->id;
                 $modelDetail->account_no_id = $_POST['fJournal']['var_account'];
                 $modelDetail->debit = $_myBalance;
                 $modelDetail->credit = 0;
                 $modelDetail->system_remark = "Automated by System";
                 $modelDetail->user_remark = $model->user_remark[0];
                 $modelDetail->save();
                 //Create System_ref
                 $_ref = "CB-" . $modelDetail->account->cashbank->mtext . "-" . $modelHeader->yearmonth_periode . "-INC-" . str_pad($modelHeader->id, 5, "0", STR_PAD_LEFT);
                 $modelHeader->updateByPk((int) $modelHeader->id, array('system_ref' => $_ref));
                 $_tdebet = 0;
                 $_tcredit = 0;
                 for ($i = 0; $i < sizeof($model->account_no_id); ++$i) {
                     $modelDetail = new uJournalDetail();
                     $modelDetail->parent_id = $modelHeader->id;
                     $modelDetail->account_no_id = $model->account_no_id[$i];
                     if ($model->debit[$i] != null) {
                         $modelDetail->debit = $model->debit[$i];
                     } else {
                         $modelDetail->debit = 0;
                     }
                     if ($model->credit[$i] != null) {
                         $modelDetail->credit = $model->credit[$i];
                     } else {
                         $modelDetail->credit = 0;
                     }
                     $modelDetail->user_remark = $model->user_remark[$i];
                     $modelDetail->save();
                 }
                 Yii::app()->user->setFlash("success", "Journal created succesfully... View Jurnal: " . CHtml::link($modelHeader->system_ref, Yii::app()->createUrl("/mCashbank/view", array("id" => $modelHeader->id))));
                 $this->redirect(array('/mCashbank'));
             }
             $this->render('create', array('model' => $model));
             Yii::app()->end();
         }
     }
     $this->render('create', array('model' => $model));
 }