/**
* Index
* @author ptrnov <*****@*****.**>
* @since 1.1
*/
public function actionIndex()
{
//Check componen generate kode RO
//print_r(\Yii::$app->ambilkonci->getRoCode());
//function getPermission(){
//return Yii::$app->getUserOpt->Modul_akses(1);
//}
//$getPermission=Yii::$app->getUserOpt->Modul_akses(1);
/* if (isset($_GET['param'])){
$dataProvider = $searchModel->searchChildRo(Yii::$app->request->queryParams,$_GET['param']);
}else{
$dataProvider = $searchModel->searchChildRo(Yii::$app->request->queryParams);
} */
//$searchModel->KD_RO ='2015.12.04.RO.0070';
// $dataProvider = $searchModel->searchSo(Yii::$app->request->queryParams);
// return $this->render('index', [
// 'searchModel' => $searchModel,
// 'dataProvider' => $dataProvider,
//'getPermission'=> $getPermission,
// ]);
$searchModel = new SalesorderSearch();
$dataProvider = $searchModel->searchSo(Yii::$app->request->queryParams);
$dataProviderInbox = $searchModel->searchSoInbox(Yii::$app->request->queryParams);
$dataProviderOutbox = $searchModel->searchSoOutbox(Yii::$app->request->queryParams);
return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'dataProviderInbox' => $dataProviderInbox, 'dataProviderOutbox' => $dataProviderOutbox]);
}
public function actionCreate($kdpo)
{
$searchModel = new RequestorderSearch();
$dataProviderRo = $searchModel->cariHeaderRO_SendPO(Yii::$app->request->queryParams);
$searchModel = new SalesorderSearch();
$dataProviderSo = $searchModel->cariHeaderSO_SendPO(Yii::$app->request->queryParams);
$poHeader = Purchaseorder::find()->where(['KD_PO' => $kdpo])->one();
$supplier = $poHeader->suplier;
$bill = $poHeader->bill;
$ship = $poHeader->ship;
$employee = $poHeader->employe;
$poDetail = Purchasedetail::find()->where(['KD_PO' => $kdpo])->andWhere('STATUS <> 3')->all();
$poDetailProvider = new ArrayDataProvider(['key' => 'ID', 'allModels' => $poDetail, 'pagination' => ['pageSize' => 20]]);
/*
* Edit PO Quantity | Validation max Jumlah RO/SA
* @author ptrnov <*****@*****.**>
* @since 1.2
*/
if (Yii::$app->request->post('hasEditable')) {
$id = Yii::$app->request->post('editableKey');
Yii::$app->response->format = Response::FORMAT_JSON;
$model = Purchasedetail::findOne($id);
$currentQty = $model->QTY;
$currentKdPo = $model->KD_PO;
$currentKdRo = $model->KD_RO;
$currentKdBrg = $model->KD_BARANG;
/* $iendPoQtyValidation = new SendPoQtyValidation();
$iendPoQtyValidation->findOne($id); */
$out = Json::encode(['output' => '', 'message' => '']);
$post = [];
$posted = current($_POST['Purchasedetail']);
$post['Purchasedetail'] = $posted;
/* $posted = current($_POST['SendPoQtyValidation']);
$post['SendPoQtyValidation'] = $posted; */
if ($model->load($post)) {
$output = '';
/*
* Split PO Plus dan PO Normal
* PO Plus=POA.*
* PO Plus=POB.*
* @author ptrnov [piter@lukison]
* @since 1.2
*/
$kdPo = explode('.', $currentKdPo);
if ($kdPo[0] != 'POA') {
if (isset($posted['QTY'])) {
/*
* QTY RO-PO VALIDATION
* QTY PO tidak boleh lebih dari SQTY Request Order
*/
/*Find SQTY RoDetail*/
$roDetail = Rodetail::find()->where(['KD_RO' => $currentKdRo, 'KD_BARANG' => $currentKdBrg])->one();
//if(!$roDetail){
$roQty = $roDetail->SQTY != 0 ? $roDetail->SQTY : 0;
//}else{$roQty=0;}
/*Sum QTY PoDetail */
$pqtyTaken = "SELECT SUM(QTY) as QTY FROM p0002 WHERE KD_RO='" . $roDetail->KD_RO . "' AND KD_BARANG='" . $roDetail->KD_BARANG . "' GROUP BY KD_BARANG";
//$pqtyTaken= 'SELECT SUM(QTY) as QTY FROM p0002 WHERE KD_RO="RO.2015.12.000001" AND KD_BARANG="BRGU.LG.03.06.E07.0001"';
$poDetailQtySum = Purchasedetail::findBySql($pqtyTaken)->one();
$poQty = $poDetailQtySum->QTY != 0 ? $poDetailQtySum->QTY : 0;
/* Calculate SQTY RO - QTY PO + Current QTY | minus current record QTY */
$ttlPQTY = $roQty - $poQty + $currentQty;
if ($posted['QTY'] <= $ttlPQTY) {
$model->save();
$output = Yii::$app->formatter->asDecimal($model->QTY, 0);
} else {
return ['output' => '', 'message' => 'Request Order QTY Limited, Greater than RO QTY ! please insert free Qty, Check Request Order'];
}
}
if (isset($posted['HARGA'])) {
$model->save();
$output = Yii::$app->formatter->asDecimal($model->HARGA, 2);
}
if (isset($posted['UNIT'])) {
$modelUnit = Unitbarang::find()->where('KD_UNIT="' . $posted['UNIT'] . '"')->one();
$model->NM_UNIT = $modelUnit->NM_UNIT;
$model->UNIT_QTY = $modelUnit->QTY;
$model->UNIT_WIGHT = $modelUnit->WEIGHT;
$model->save();
$output = $model->UNIT;
}
/*
if (isset($posted['NOTE'])) {
// $output = Yii::$app->formatter->asDecimal($model->EMP_NM, 2);
$output = $model->NOTE;
} */
} elseif ($kdPo[0] != 'PO') {
/* PO Plus=POB.*/
if (isset($posted['QTY'])) {
$model->save();
$output = Yii::$app->formatter->asDecimal($model->QTY, 0);
}
if (isset($posted['HARGA'])) {
$model->save();
$output = Yii::$app->formatter->asDecimal($model->HARGA, 2);
}
if (isset($posted['UNIT'])) {
$model->save();
$output = $model->UNIT;
}
}
$out = Json::encode(['output' => $output, 'message' => '']);
}
// return ajax json encoded response and exit
echo $out;
return;
}
return $this->render('create', ['searchModel' => $searchModel, 'dataProviderRo' => $dataProviderRo, 'dataProviderSo' => $dataProviderSo, 'poDetailProvider' => $poDetailProvider, 'poHeader' => $poHeader, 'supplier' => $supplier, 'bill' => $bill, 'ship' => $ship, 'employee' => $employee]);
}
/**
* Index
* @author ptrnov <*****@*****.**>
* @since 1.1
*/
public function actionIndex()
{
//Check componen generate kode RO
//print_r(\Yii::$app->ambilkonci->getRoCode());
//function getPermission(){
//return Yii::$app->getUserOpt->Modul_akses(1);
//}
//$getPermission=Yii::$app->getUserOpt->Modul_akses(1);
/* if (isset($_GET['param'])){
$dataProvider = $searchModel->searchChildRo(Yii::$app->request->queryParams,$_GET['param']);
}else{
$dataProvider = $searchModel->searchChildRo(Yii::$app->request->queryParams);
} */
//$searchModel->KD_RO ='2015.12.04.RO.0070';
// $dataProvider = $searchModel->searchSo(Yii::$app->request->queryParams);
// return $this->render('index', [
// 'searchModel' => $searchModel,
// 'dataProvider' => $dataProvider,
//'getPermission'=> $getPermission,
// ]);
$searchModel = new SalesorderSearch();
$dataProvider = $searchModel->searchSo(Yii::$app->request->queryParams);
$dataProviderInbox = $searchModel->searchSoInbox(Yii::$app->request->queryParams);
$dataProviderOutbox = $searchModel->searchSoOutbox(Yii::$app->request->queryParams);
$profile = Yii::$app->getUserOpt->Profile_user();
$datacheckedso = Salesorder::find()->where("PARENT_ROSO = 1 AND STATUS = 101 AND STATUS <> 3 AND USER_CC='" . $profile->emp->EMP_ID . "'")->count();
$datacreateso = Salesorder::find()->where("PARENT_ROSO = 1 AND STATUS <> 3 AND STATUS = 0 AND ID_USER = '******'")->count();
$dataapprove = Salesorder::find()->where("PARENT_ROSO = 1 AND STATUS = 102 AND STATUS <> 3 AND KD_DEP='" . $profile->emp->DEP_ID . "' OR STATUS = 5")->count();
$dataAprroveso = new ActiveDataProvider(['query' => Salesorder::find()->where("PARENT_ROSO = 1 AND STATUS = 102 AND STATUS<>3 AND KD_DEP='" . $profile->emp->DEP_ID . "'OR STATUS = 5"), 'pagination' => ['pageSize' => 5]]);
$dataCheckedso = new ActiveDataProvider(['query' => Salesorder::find()->where("PARENT_ROSO = 1 AND STATUS = 101 AND USER_CC='" . $profile->emp->EMP_ID . "'"), 'pagination' => ['pageSize' => 5]]);
$dataCreateso = new ActiveDataProvider(['query' => Salesorder::find()->where("PARENT_ROSO = 1 AND STATUS <> 3 AND STATUS = 0 AND ID_USER = '******'"), 'pagination' => ['pageSize' => 5]]);
return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'dataProviderInbox' => $dataProviderInbox, 'dataProviderOutbox' => $dataProviderOutbox, 'dataapprove' => $dataapprove, 'datacheckedso' => $datacheckedso, 'dataAprroveso' => $dataAprroveso, 'dataCheckedso' => $dataCheckedso, 'dataCreateso' => $dataCreateso, 'datacreateso' => $datacreateso]);
}
