public function actionSimpanfirst()
{
$cons = \Yii::$app->db_esm;
$roHeader = new Requestorder();
//$reqorder = new Roatribute();
$roDetail = new Rodetail();
$profile = Yii::$app->getUserOpt->Profile_user();
//if($roDetail->load(Yii::$app->request->post()) && $roDetail->validate()){
if ($roDetail->load(Yii::$app->request->post())) {
$hsl = \Yii::$app->request->post();
$kdUnit = $hsl['Rodetail']['UNIT'];
$kdBarang = $hsl['Rodetail']['KD_BARANG'];
$nmBarang = Barangumum::findOne(['KD_BARANG' => $kdBarang]);
$rqty = $hsl['Rodetail']['RQTY'];
$note = $hsl['Rodetail']['NOTE'];
/*
* Detail Request Order
**/
$roDetail->KD_RO = \Yii::$app->ambilkonci->getRoCode();
$roDetail->UNIT = $kdUnit;
$roDetail->CREATED_AT = date('Y-m-d H:i:s');
$roDetail->NM_BARANG = $nmBarang->NM_BARANG;
$roDetail->KD_BARANG = $kdBarang;
$roDetail->RQTY = $rqty;
$roDetail->NOTE = $note;
$roDetail->STATUS = 0;
/*
* Header Request Order
**/
$getkdro = \Yii::$app->ambilkonci->getRoCode();
$roHeader->KD_RO = $getkdro;
$roHeader->CREATED_AT = date('Y-m-d H:i:s');
$roHeader->TGL = date('Y-m-d');
$roHeader->ID_USER = $profile->emp->EMP_ID;
$roHeader->EMP_NM = $profile->emp->EMP_NM . ' ' . $profile->emp->EMP_NM_BLK;
$roHeader->KD_CORP = $profile->emp->EMP_CORP_ID;
$roHeader->KD_DEP = $profile->emp->DEP_ID;
$roHeader->SIG1_SVGBASE64 = $profile->emp->SIGSVGBASE64;
$roHeader->SIG1_SVGBASE30 = $profile->emp->SIGSVGBASE30;
$roHeader->STATUS = 0;
$transaction = $cons->beginTransaction();
try {
if (!$roDetail->save()) {
$transaction->rollback();
return false;
}
if (!$roHeader->save()) {
$transaction->rollback();
return false;
}
$transaction->commit();
} catch (Exception $ex) {
//print_r("error");
$transaction->rollback();
return false;
}
//return $this->redirect(['index','param'=>$getkdro]);
//return $this->redirect(['index?RequestorderSearch[KD_RO]='.$getkdro]);
return $this->redirect(['/purchasing/request-order/view?kd=' . $getkdro]);
} else {
return $this->redirect(['index']);
}
}
public function actionSimpanfirst()
{
// $cons = \Yii::$app->db_esm;
$roHeader = new Requestorder();
//$reqorder = new Roatribute();
$roDetail = new Rodetail();
$BARANG = new Barang();
$profile = Yii::$app->getUserOpt->Profile_user();
// $corp = Yii::$app->getUserOpt->Profile_user()->EMP_ID;
// $Corp1 = Employe::find()->where(['KD_CORP'=>$corp])->asArray()->one();
$corp = Yii::$app->getUserOpt->Profile_user()->emp->EMP_CORP_ID;
$hsl = \Yii::$app->request->post();
$radio = $hsl['Rodetail']['NEW'];
//if($roDetail->load(Yii::$app->request->post()) && $roDetail->validate()){
if ($roDetail->load(Yii::$app->request->post())) {
// print_r($radio);
// die();
$selectCorp = $corp;
if ($radio == 2) {
// rodetail
$kdBarang = $roDetail->KD_BARANG;
$nmBarang = Barang::findOne(['KD_BARANG' => $kdBarang]);
$GneratekodeRo = \Yii::$app->ambilkonci->getRoCode($selectCorp);
$roDetail->KD_RO = $GneratekodeRo;
$roDetail->PARENT_ROSO = 0;
$roDetail->KD_CORP = $selectCorp;
$roDetail->CREATED_AT = date('Y-m-d H:i:s');
$roDetail->NM_BARANG = $nmBarang->NM_BARANG;
$roDetail->KD_BARANG = $kdBarang;
$roDetail->SQTY = $roDetail->RQTY;
$roDetail->HARGA = $nmBarang->HARGA_SPL;
$roDetail->STATUS = 0;
$roDetail->save();
// getErrors()
// print_r($roDetail->getErrors());
// die();
// roheader
$roHeader->PARENT_ROSO = 0;
// RO=0
$roHeader->KD_RO = $GneratekodeRo;
$roHeader->CREATED_AT = date('Y-m-d H:i:s');
$roHeader->TGL = date('Y-m-d');
$roHeader->ID_USER = $profile->emp->EMP_ID;
$roHeader->EMP_NM = $profile->emp->EMP_NM . ' ' . $profile->emp->EMP_NM_BLK;
$roHeader->KD_CORP = $selectCorp;
$roHeader->KD_DEP = $profile->emp->DEP_ID;
//$roHeader->SIG1_SVGBASE64 = $profile->emp->SIGSVGBASE64;
//$roHeader->SIG1_SVGBASE30 = $profile->emp->SIGSVGBASE30;
$roHeader->STATUS = 0;
$roHeader->PARENT_ROSO = 0;
// RO=0
$roHeader->KD_RO = $GneratekodeRo;
$roHeader->CREATED_AT = date('Y-m-d H:i:s');
$roHeader->TGL = date('Y-m-d');
$roHeader->ID_USER = $profile->emp->EMP_ID;
$roHeader->EMP_NM = $profile->emp->EMP_NM . ' ' . $profile->emp->EMP_NM_BLK;
$roHeader->KD_CORP = $selectCorp;
$roHeader->KD_DEP = $profile->emp->DEP_ID;
//$roHeader->SIG1_SVGBASE64 = $profile->emp->SIGSVGBASE64;
//$roHeader->SIG1_SVGBASE30 = $profile->emp->SIGSVGBASE30;
$roHeader->STATUS = 0;
$roHeader->save();
} else {
// barang
$kdcorp = $BARANG->KD_CORP = $roDetail->KD_CORP;
$kdType = Yii::$app->esmcode->kdTipe();
$kdUnit = Yii::$app->esmcode->kdUnit();
$nw1 = Yii::$app->esmcode->kdKategori();
$kdKategori = $BARANG->KD_KATEGORI = $nw1;
$kdPrn = 0;
$kdbrg = Yii::$app->esmcode->kdbarangUmum($kdPrn, $kdcorp, $kdType, $kdKategori, $kdUnit);
$BARANG->KD_BARANG = $kdbrg;
$BARANG->NM_BARANG = $roDetail->NM_BARANG;
$BARANG->HARGA_SPL = $roDetail->HARGA;
$BARANG->STATUS = 1;
$BARANG->KD_SUPPLIER = 'SPL.LG.0000';
$BARANG->KD_KATEGORI = 39;
$BARANG->KD_UNIT = $roDetail->UNIT;
$BARANG->KD_TYPE = 30;
$BARANG->CREATED_BY = Yii::$app->user->identity->username;
$BARANG->CREATED_AT = date('Y-m-d H:i:s');
$BARANG->save();
// rodetail
$GneratekodeRo = \Yii::$app->ambilkonci->getRoCode($selectCorp);
$roDetail->KD_RO = $GneratekodeRo;
$roDetail->PARENT_ROSO = 0;
$roDetail->KD_CORP = $selectCorp;
$roDetail->CREATED_AT = date('Y-m-d H:i:s');
$roDetail->NM_BARANG = $hsl['Rodetail']['NM_BARANG'];
$roDetail->KD_BARANG = $kdbrg;
// $roDetail->UNIT = 'none';
$roDetail->SQTY = $roDetail->RQTY;
$roDetail->STATUS = 0;
$roDetail->save();
// print_r($BARANG->getErrors());
// die();
// roheader
$roHeader->PARENT_ROSO = 0;
// RO=0
$roHeader->KD_RO = $GneratekodeRo;
$roHeader->CREATED_AT = date('Y-m-d H:i:s');
$roHeader->TGL = date('Y-m-d');
$roHeader->ID_USER = $profile->emp->EMP_ID;
$roHeader->EMP_NM = $profile->emp->EMP_NM . ' ' . $profile->emp->EMP_NM_BLK;
$roHeader->KD_CORP = $selectCorp;
$roHeader->KD_DEP = $profile->emp->DEP_ID;
//$roHeader->SIG1_SVGBASE64 = $profile->emp->SIGSVGBASE64;
//$roHeader->SIG1_SVGBASE30 = $profile->emp->SIGSVGBASE30;
$roHeader->STATUS = 0;
$roHeader->PARENT_ROSO = 0;
// RO=0
$roHeader->KD_RO = $GneratekodeRo;
$roHeader->CREATED_AT = date('Y-m-d H:i:s');
$roHeader->TGL = date('Y-m-d');
$roHeader->ID_USER = $profile->emp->EMP_ID;
$roHeader->EMP_NM = $profile->emp->EMP_NM . ' ' . $profile->emp->EMP_NM_BLK;
$roHeader->KD_CORP = $selectCorp;
$roHeader->KD_DEP = $profile->emp->DEP_ID;
//$roHeader->SIG1_SVGBASE64 = $profile->emp->SIGSVGBASE64;
//$roHeader->SIG1_SVGBASE30 = $profile->emp->SIGSVGBASE30;
$roHeader->STATUS = 0;
$roHeader->save();
// print_r($roHeader->getErrors());
// die();
}
// //$roHeader->SIG1_SVGBASE64 = $profile->emp->SIGSVGBASE64;
// //$roHeader->SIG1_SVGBASE30 = $profile->emp->SIGSVGBASE30;
// $roHeader->STATUS = 0;
// $transaction = $cons->beginTransaction();
// try {
// if (!$roDetail->save()) {
// $transaction->rollback();
// return false;
// }
//
// if (!$roHeader->save()) {
// $transaction->rollback();
// return false;
// }
// $transaction->commit();
// } catch (Exception $ex) {
// //print_r("error");
// $transaction->rollback();
// return false;
// }
//return $this->redirect(['index','param'=>$getkdro]);
//return $this->redirect(['index?RequestorderSearch[KD_RO]='.$getkdro]);
return $this->redirect(['/purchasing/request-order/edit?kd=' . $GneratekodeRo]);
} else {
return $this->redirect(['index']);
}
}
