public function actionRoomForm() { $model = new Pilotproject(); $post = Yii::$app->request->post(); $val = $post['Pilotproject']['parentpilot']; // $val_parent = $post['Pilotproject']['parent']; // $val_dest = $post['Pilotproject']['destination']; if ($model->load(Yii::$app->request->post())) { if ($val == 1) { $dep_id = Yii::$app->getUserOpt->Profile_user()->emp->DEP_ID; $pilot_id = Yii::$app->ambilkonci->getpilot($dep_id); $model->PILOT_ID = $pilot_id; $model->PARENT = 0; // $sql = Pilotproject::find()->max('ID'); // $model->SORT = $sql+1; } else { $model->SORT = $model->PARENT; $model->PILOT_ID = ''; } $model->DEP_ID = Yii::$app->getUserOpt->Profile_user()->emp->DEP_ID; $model->CREATED_BY = Yii::$app->getUserOpt->Profile_user()->emp->EMP_EMAIL; // $model->DESTINATION_TO = $val_dest; // $model->PARENT = $val_parent; $model->save(); if ($val == 1) { $update_model = self::findModel($model->ID); $update_model->SORT = $model->ID; $update_model->save(); } return $this->redirect('index'); } else { return $this->renderAjax('_formRooms', ['model' => $model, 'data' => self::get_aryParent(), 'dropemploy' => self::get_aryEmploye()]); } }
public function saved() { //if ($this->validate()) { $model = new Pilotproject(); //$model->PARENT = $id; //$model->SORT = $id; $model->PILOT_NM = $this->pARENT_NM; // print_r($model->PILOT_NM); // die(); $model->PLAN_DATE1 = Yii::$app->formatter->asDatetime($this->pARENT_TGLPLAN1 . ' 00:00:01', 'php:Y-m-d H:i:s'); $model->PLAN_DATE2 = Yii::$app->formatter->asDatetime($this->pARENT_TGLPLAN2 . ' 00:00:01', 'php:Y-m-d H:i:s'); $model->DEP_ID = Yii::$app->getUserOpt->Profile_user()->emp->DEP_ID; $model->DESTINATION_TO = $this->DESTINATION_TO; $model->CREATED_BY = Yii::$app->user->identity->username; $model->UPDATED_TIME = date('Y-m-d h:i:s'); // if($model->save()){ // return false; // }; $connection = Yii::$app->db_widget; $transaction = $connection->beginTransaction(); try { $model->save(); // $execute = Yii::$app->db_widget->createCommand()->update('sc0001',['SORT'=>$model->ID],'ID="'.$model->ID.'"')->execute(); //.... other SQL executions $transaction->commit(); } catch (\Exception $e) { $transaction->rollBack(); throw $e; } //$model->save(); /* print_r($model->getErrors()); die(); */ //return true; //return true; //}else{ // return false; //} }
/** * Button Rooms for Create Parent * Action Modal, BeforeSumbil form, cookie and refresh fullcalendar. * Status : Fixed. * ========== BACA ================ * CREATE/UPDATE Parent Utama. * Locate : button rooms. * 1. Parent Utama tidak bisa diubah ke child, karena parent sudah atau akan ada pengkut/flowed child. * 2. Ditampilkan pada menu select untuk child sesuai tanggal (lebih kecil atau sama dengan) / tgllebih besar probidden. * 3. Parent Utama bisa untuk Public atau Private. * 4. Show day, akan ditampilkan semua detail sesuai date plan1 dan plan2 dari parent utama. * 5. Closing untuk actual harus lebih besar dari tgl plan1, dan bisa lebih besar atau lebih kecil dari tglplan2. * 6. PARENT_TREE: 0=child; 1=Parent Utama ; 2=Patent sub1; 2=Patent sub2, dst. * @since 1.1 * author piter novian [ptr.nov@gmail.com]. */ public function actionRoomForm() { $modelParentPilotProject = new Pilotproject(); $modelParentPilotProject->scenario = "parentrooms"; $rsltPost = Yii::$app->request->post(); if ($modelParentPilotProject->load(Yii::$app->request->post())) { if ($modelParentPilotProject->validate()) { $modelParentPilotProject->PARENT = 0; $modelParentPilotProject->PATENT_TREE = 1; $modelParentPilotProject->ENABLE_ACTUAL = 2; //$modelParentPilotProject->PLAN_DATE1 = Yii::$app->formatter->asDatetime($rsltPost['Pilotproject']['PLAN_DATE1'] .' 00:00:01', 'php:Y-m-d H:i:s'); //$modelParentPilotProject->PLAN_DATE2 = Yii::$app->formatter->asDatetime($rsltPost['Pilotproject']['PLAN_DATE2'] .' 00:00:01', 'php:Y-m-d H:i:s'); //$modelParentPilotProject->$rsltPost['Pilotproject']['DESTINATION_TO']; $modelParentPilotProject->DEP_ID = Yii::$app->getUserOpt->Profile_user()->emp->DEP_ID; $modelParentPilotProject->CREATED_BY = Yii::$app->getUserOpt->Profile_user()->emp->EMP_EMAIL; $modelParentPilotProject->CREATED_BY = Yii::$app->user->identity->username; $modelParentPilotProject->UPDATED_TIME = date('Y-m-d h:i:s'); $connection = Yii::$app->db_widget; $transaction = $connection->beginTransaction(); try { $modelParentPilotProject->save(); $execute = Yii::$app->db_widget->createCommand()->update('sc0001', ['SORT' => $modelParentPilotProject->ID], 'ID="' . $modelParentPilotProject->ID . '"')->execute(); //.... other SQL executions $transaction->commit(); } catch (\Exception $e) { $transaction->rollBack(); throw $e; } //if ($modelParentPilotProject->save()) { $tanggalRetuen = Yii::$app->formatter->asDatetime($rsltPost['Pilotproject']['PLAN_DATE1'], 'php:Y-m-d'); setcookie('PilotprojectParent_cookie1', $tanggalRetuen); //} } } else { return $this->renderAjax('_formRooms', ['model' => $modelParentPilotProject, 'data' => self::get_aryParent(), 'dropemploy' => self::get_aryEmploye()]); } return Json::encode('success'); }