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');
}
