/** * Action Prosess Approval Colomn Row * @param string $id * @author ptrnov <*****@*****.**> * @since 1.1 */ public function actionApproved($kd) { /* * Init Models * @author ptrnov <*****@*****.**> * @since 1.1 **/ //$ro = new Requestorder(); $roHeader = Requestorder::find()->where(['KD_RO' => $kd])->one(); $detro = $roHeader->detro; $employ = $roHeader->employe; $dept = $roHeader->dept; /* * Convert $roHeader->detro to ArrayDataProvider | Identity 'key' => 'ID', * @author ptrnov <*****@*****.**> * @since 1.1 **/ $detroProvider = new ArrayDataProvider(['key' => 'ID', 'allModels' => $detro, 'pagination' => ['pageSize' => 10]]); /* * Process Editable Row [Columm SQTY] * @author ptrnov <*****@*****.**> * @since 1.1 **/ if (Yii::$app->request->post('hasEditable')) { $id = Yii::$app->request->post('editableKey'); $model = Rodetail::findOne($id); $out = Json::encode(['output' => '', 'message' => '']); $post = []; $posted = current($_POST['Rodetail']); $post['Rodetail'] = $posted; if ($model->load($post)) { $model->save(); $output = ''; if (isset($posted['RQTY'])) { $output = $model->RQTY; } if (isset($posted['SQTY'])) { $output = $model->SQTY; } if (isset($posted['NOTE'])) { // $output = Yii::$app->formatter->asDecimal($model->EMP_NM, 2); $output = $model->NOTE; } $out = Json::encode(['output' => $output, 'message' => '']); } // return ajax json encoded response and exit echo $out; return; } /* * Render Approved View * @author ptrnov <*****@*****.**> * @since 1.1 **/ return $this->render('approved', ['roHeader' => $roHeader, 'detro' => $detro, 'employ' => $employ, 'dept' => $dept, 'dataProvider' => $detroProvider]); }
public function actionCk() { if (Yii::$app->request->isAjax) { Yii::$app->response->format = Response::FORMAT_JSON; $request = Yii::$app->request; $dataKeySelect = $request->post('keysSelect'); $dataKdPo = $request->post('kdpo'); $dataKdRo = $request->post('kdRo'); $dataKdBrg = $request->post('kdBrg'); /* Before Action -> 0 */ $AryKdRo = ArrayHelper::map(Rodetail::find()->where(['KD_RO' => $dataKdRo])->andWhere('STATUS=101')->all(), 'ID', 'ID'); //print_r($AryKdRo); $foreaceAryKdRo = $AryKdRo != 0 ? $AryKdRo : 'Array([0]=>"0")'; foreach ($foreaceAryKdRo as $keyRo) { $roDetailHapus = Rodetail::findOne($keyRo); $roDetailHapus->TMP_CK = 0; $roDetailHapus->save(); } $res = array('status' => 'true'); /* An Action -> 0 */ //print_r($dataKeySelect); if ($dataKeySelect != 0) { //$foreaceGvRoToPo=$dataKeySelect!=0? $dataKeySelect:'Array([0]=>"0")'; foreach ($dataKeySelect as $idx) { $roDetail = Rodetail::find()->where(['KD_RO' => $dataKdRo, 'ID' => $idx])->andWhere('STATUS=1')->one(); //STT =202 $poDetail = Purchasedetail::find()->where(['KD_PO' => $dataKdPo, 'KD_RO' => $dataKdRo, 'KD_BARANG' => $roDetail->KD_BARANG])->one(); $poUnit = $roDetail->cunit; //$poBarangUmum=$roDetail->barangumum; if (!$poDetail) { //$roDetail = Rodetail::findOne($idx); $roDetail->TMP_CK = 0; /* Untuk testing Checkbook 1 | 0 */ //$roDetail->save(); $res = array('status' => true); /* tidak ada Data pada Purchasedetail |KD_RO&KD_BARANG */ /*Save To Purchase detail*/ $poDetailModel = new Purchasedetail(); $poDetailModel->KD_PO = $dataKdPo; $poDetailModel->KD_RO = $dataKdRo; $poDetailModel->KD_BARANG = $roDetail->KD_BARANG; $poDetailModel->NM_BARANG = $roDetail->NM_BARANG; $poDetailModel->UNIT = $poUnit->KD_UNIT; $poDetailModel->NM_UNIT = $poUnit->NM_UNIT; $poDetailModel->UNIT_QTY = $poUnit->QTY; $poDetailModel->UNIT_WIGHT = $poUnit->WEIGHT; /*FORMULA*/ $pqtyTaken = "SELECT SUM(QTY) as QTY FROM p0002 WHERE KD_RO='" . $dataKdRo . "' AND KD_BARANG='" . $roDetail->KD_BARANG . "' GROUP BY KD_BARANG"; $countQtyTaken = Purchasedetail::findBySql($pqtyTaken)->one(); if ($countQtyTaken) { $qtyInPo = $countQtyTaken->QTY != '' ? $countQtyTaken->QTY : 0; } else { $qtyInPo = 0; } //$qtyInPo=$countQtyTaken->QTY!=''? $countQtyTaken->QTY :0; $actualQty = $roDetail->SQTY - $qtyInPo; if ($actualQty > 0) { $poDetailModel->QTY = $actualQty; } else { $poDetailModel->QTY = 0; } //if($roDetail->PARENT_ROSO==0){ $poDetailModel->HARGA = $roDetail->HARGA; //RO //}elseif($roDetail->PARENT_ROSO==1){ // $poDetailModel->HARGA=$roDetail->HARGA_PABRIK; //SO //} $poDetailModel->STATUS = 0; //$poDetailModel->STATUS_DATE =date;//\Yii::$app->formatter->asDate(date,'Y-M-d hh:mm:ss'); $roDetail->save(); $poDetailModel->save(); } else { $res = array('status' => false); /* sudah ada Data pada Purchasedetail |KD_RO&KD_BARANG */ } } } //$res = array('status' => 't'); return $res; } }
public function actionCk() { if (Yii::$app->request->isAjax) { Yii::$app->response->format = Response::FORMAT_JSON; $request = Yii::$app->request; //$dataKeylist=$request->post('keylist'); //$dataKeyRslt=$request->post('keysRslt'); //$kdRo=$request->post('kdRo'); $dataKeySelect = $request->post('keysSelect'); $dataKdRo = $request->post('kdRo'); $dataKdBrg = $request->post('kdBrg'); //$valueCk=$request->post('value'); //$roDetail = Rodetail::findOne($id); //$roDetail->TMP_CK = 1;// valueCk;//$roDetail->TMP_CK==0 ? 1 :0; //$roDetail->save(); //print_r($dataKeySelect); //print_r($dataKdRo); //print_r(json_encode($dataKeySelect)); //$poDetail = Podetail::find()->where(['KD_PO'=>$kdpo, 'ID'=>$idpo])->one(); /* Before Action -> 0 */ $AryKdRo = ArrayHelper::map(Rodetail::find()->where(['KD_RO' => $dataKdRo])->andWhere('STATUS=101')->all(), 'ID', 'ID'); //print_r($AryKdRo); $foreaceAryKdRo = $AryKdRo != 0 ? $AryKdRo : 'Array([0]=>"0")'; foreach ($foreaceAryKdRo as $keyRo) { $roDetailHapus = Rodetail::findOne($keyRo); $roDetailHapus->TMP_CK = 0; $roDetailHapus->save(); } $res = array('status' => 'true'); /* An Action -> 0 */ //print_r($dataKeySelect); if ($dataKeySelect != 0) { //$foreaceGvRoToPo=$dataKeySelect!=0? $dataKeySelect:'Array([0]=>"0")'; foreach ($dataKeySelect as $idx) { $roDetail = Rodetail::find()->where(['KD_RO' => $dataKdRo, 'ID' => $idx])->andWhere('STATUS=101')->one(); $poDetail = Purchasedetail::find()->where(['KD_RO' => $dataKdRo, 'KD_BARANG' => $roDetail->KD_BARANG])->one(); if (!$poDetail) { //$roDetail = Rodetail::findOne($idx); $roDetail->TMP_CK = 1; $roDetail->save(); $res = array('status' => true); /* tidak ada Data pada Purchasedetail |KD_RO&KD_BARANG */ } else { $res = array('status' => false); /* sudah ada Data pada Purchasedetail |KD_RO&KD_BARANG */ } } } //$res = array('status' => 't'); return $res; /* return Json::encode([ 'status' => '1', ]); */ /* return $res; return Json(new {success = true}); */ //return $a; /* return [ //'status' => 'false', 'message' => 'message', ]; */ } }