?> AP for: <?php echo $model->system_ref; ?> </h1> </div> <?php $this->widget('bootstrap.widgets.BootDetailView', array('data' => $model, 'attributes' => array('input_date', 'periode_date', 'system_ref', array('label' => 'Purchasing Type', 'value' => $model->po_type->name), array('label' => 'Entity', 'value' => $model->organization->name), array('label' => 'Supplier', 'value' => $model->supplier->company_name), 'remark', array('label' => 'Payment Status', 'value' => $model->paymentCheck()), array('label' => 'Journal Status', 'value' => $model->journal_state->name)))); ?> <br /> <?php $this->widget('bootstrap.widgets.BootGridView', array('id' => 'u-order-detail-grid', 'dataProvider' => vPorderDetail::model()->search($model->id), 'itemsCssClass' => 'table table-striped table-bordered', 'template' => '{items}{pager}', 'columns' => array(array('header' => 'Item.', 'value' => '$data->item_id'), 'description', 'qty', 'uom', array('value' => 'Yii::app()->indoFormat->number($data->amount)', 'name' => 'amount', 'htmlOptions' => array('style' => 'text-align: right; padding-right: 5px;')), array('header' => 'Total', 'value' => 'Yii::app()->indoFormat->number($data->amount)', 'name' => 'amount', 'htmlOptions' => array('style' => 'text-align: right; padding-right: 5px;'))))); ?> <br /> <b> Total: <?php echo Yii::app()->indoFormat->number($model->sum_po); ?> </b> <hr /> <h2>Payment History</h2> <?php $this->widget('bootstrap.widgets.BootGridView', array('id' => 't-account-balance-grid', 'dataProvider' => vPorderPayment::model()->search($model->id), 'template' => '{items}{pager}', 'itemsCssClass' => 'table table-striped table-bordered', 'columns' => array('payment_date', array('header' => 'No Ref', 'value' => '$data->payment_ref'), array('header' => 'Payment Source', 'value' => '$data->payment_source->account_concat()'), array('header' => 'Payment Type', 'value' => '$data->payment_type_id'), array('header' => 'Effective Date', 'value' => '$data->effective_date'), array('name' => 'amount', 'value' => 'Yii::app()->indoFormat->number($data->amount)', 'htmlOptions' => array('style' => 'text-align: right; padding-right: 5px;'))))); ?>
public function actionUpdate($id) { $model = $this->loadModel($id); if ($model->approved_date != null) { Yii::app()->user->setFlash("error", "<strong>Error!</strong> PO already approved. Can't be edited..."); $this->redirect(array('/m2/vPorderGeneral')); } // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['vPorderGeneral'])) { $model->attributes = $_POST['vPorderGeneral']; if ($model->validate()) { $modelHeader = $this->loadModel($id); $modelHeader->input_date = $model->input_date; $modelHeader->system_ref = $model->system_ref; $modelHeader->periode_date = $model->periode_date; $modelHeader->budgetcomp_id = $model->budgetcomp_id; $modelHeader->remark = $model->remark; $modelHeader->issuer_id = $model->issuer_id; $modelHeader->organization_id = sUser::model()->getGroup(); //default user Group $modelHeader->payment_state_id = 1; $modelHeader->save(); //Detail... $model->budget_id = $_POST['budget_id']; $model->department_id = $_POST['department_id']; $model->description = $_POST['description']; //$model->user=$_POST['user']; //$model->qty=$_POST['qty']; $model->amount = $_POST['amount']; $t = vPorderDetail::model()->deleteAll(array('condition' => 'parent_id = :id', 'params' => array(':id' => (int) $id))); for ($i = 0; $i < sizeof($model->budget_id); ++$i) { $modelDetail = new vPorderDetail(); $modelDetail->parent_id = $modelHeader->id; $modelDetail->budget_id = $model->budget_id[$i]; $modelDetail->department_id = $model->department_id[$i]; $modelDetail->description = $model->description[$i]; //$modelDetail->user=$model->user[$i]; //($model->qty[$i] != null) ? $modelDetail->qty=$model->qty[$i] : $modelDetail->qty=1; $modelDetail->qty = 1; $model->amount[$i] != null ? $modelDetail->amount = $model->amount[$i] : ($modelDetail->amount = 0); $modelDetail->save(); } $this->redirect(array('/m2/vPorderGeneral')); } } $modelDetail = vPorderDetail::model()->findAll(array('condition' => 'parent_id = :id', 'params' => array(':id' => $model->id), 'order' => 'id')); foreach ($modelDetail as $mm) { $model->budget_id[] = $mm->budget_id; $model->description[] = $mm->description; $model->qty[] = $mm->qty; $model->amount[] = $mm->amount; } $this->render('update', array('model' => $model)); }
public function actionUpdate($id) { $model = $this->loadModel($id); if ($model->approved_date != null) { Yii::app()->user->setFlash("error", "<strong>Error!</strong> PO already approved. Can't be edited..."); //$this->redirect(array('/m2/vPorderInventory',)); $this->redirect(array('view', "id" => $model->id)); } // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['vPorder'])) { $model->attributes = $_POST['vPorder']; if ($model->validate()) { if (Yii::app()->request->isAjaxRequest) { $sqlinsert = "INSERT INTO v_porder_detail_temp (parent_id, item_id, description, qty, amount)\n\t\t\t\t\tVALUES (" . $model->id . ", " . $model->item_id . ", '" . $model->description . "', " . $model->qty . ", " . $model->amount . ")"; $command = Yii::app()->db->createCommand($sqlinsert); $command->execute(); } else { $model->save(); //Delete Old Detail Data $sqlDelete = "DELETE FROM v_porder_detail WHERE parent_id = ':id'"; $command = Yii::app()->db->createCommand($sqlDelete); $command->bindParam(":id", $id, PDO::PARAM_STR); $command->execute(); //Insert New Data $sql = "INSERT INTO v_porder_detail (parent_id, item_id, description, qty, amount)\n\t\t\t\t\tSELECT :id, item_id, description, qty, amount FROM v_porder_detail_temp\n\t\t\t\t\tWHERE parent_id = ':id'"; $command = Yii::app()->db->createCommand($sql); $command->bindParam(":id", $id, PDO::PARAM_STR); $command->execute(); //Delete Temporary Data $sqlD = "DELETE FROM v_porder_detail_temp WHERE parent_id = ':id'"; $command = Yii::app()->db->createCommand($sqlD); $command->bindParam(":id", $id, PDO::PARAM_STR); $command->execute(); $this->redirect(array('/m2/vPorderInventory')); } } } if (!Yii::app()->request->isAjaxRequest) { $criteria = new CdbCriteria(); $criteria->compare('parent_id', $model->id); $models = vPorderDetail::model()->findAll($criteria); $sqlcount = "select count(*) FROM v_porder_detail_temp WHERE parent_id = '" . $model->id . "'"; $command = Yii::app()->db->createCommand($sqlcount); $_count = $command->queryScalar(); if ($_count == 0) { foreach ($models as $mod) { $sql = "INSERT INTO v_porder_detail_temp (parent_id, item_id, description, qty, amount)\n\t\t\t\t\tVALUES (" . $mod->parent_id . ", " . $mod->item_id . ", '" . $mod->description . "', " . $mod->qty . ", " . $mod->amount . ")"; $command = Yii::app()->db->createCommand($sql); $command->execute(); } } } $sql = "SELECT * FROM v_porder_detail_temp WHERE parent_id = '" . $model->id . "'"; $command = Yii::app()->db->createCommand($sql); $rawData = $command->queryAll(); $dataProvider = new CArrayDataProvider($rawData, array('pagination' => false)); if (Yii::app()->request->isAjaxRequest) { $this->renderPartial('_formDetail', array('model' => $model, 'dataProvider' => $dataProvider)); } else { $this->render('update', array('model' => $model, 'dataProvider' => $dataProvider)); } }
protected function afterDelete() { parent::afterDelete(); vPorderDetail::model()->deleteAll(array('condition' => 'parent_id= :id', 'params' => array(':id' => $this->id))); }