public function CekBarang($model)
{
$explode = explode(',', $this->KD_BARANG);
$kondisi = SoT2::find()->where(['KD_BARANG' => $explode[0], 'KODE_REF' => $this->KODE_REF])->andwhere('STATUS<>3')->one();
if ($kondisi) {
$this->addError($model, 'Duplicated Product because the Product already exists in this Salesman Order !, attention change name Product or change code ');
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = SoT2::find();
// add conditions that should always apply here
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
// grid filtering conditions
$query->andFilterWhere(['ID' => $this->ID, 'TGL' => $this->TGL, 'SO_QTY' => $this->SO_QTY, 'SO_TYPE' => $this->SO_TYPE, 'UNIT_QTY' => $this->UNIT_QTY, 'UNIT_BERAT' => $this->UNIT_BERAT, 'HARGA_PABRIK' => $this->HARGA_PABRIK, 'HARGA_DIS' => $this->HARGA_DIS, 'HARGA_SALES' => $this->HARGA_SALES, 'HARGA_LG' => $this->HARGA_LG, 'STATUS' => $this->STATUS, 'WAKTU_INPUT_INVENTORY' => $this->WAKTU_INPUT_INVENTORY, 'SUBMIT_QTY' => $this->SUBMIT_QTY, 'SUBMIT_PRICE' => $this->SUBMIT_PRICE]);
$query->andFilterWhere(['like', 'CUST_KD', $this->CUST_KD])->andFilterWhere(['like', 'CUST_KD_ALIAS', $this->CUST_KD_ALIAS])->andFilterWhere(['like', 'CUST_NM', $this->CUST_NM])->andFilterWhere(['like', 'KD_BARANG', $this->KD_BARANG])->andFilterWhere(['like', 'KD_BARANG_ALIAS', $this->KD_BARANG_ALIAS])->andFilterWhere(['like', 'NM_BARANG', $this->NM_BARANG])->andFilterWhere(['like', 'POS', $this->POS])->andFilterWhere(['like', 'KD_DIS', $this->KD_DIS])->andFilterWhere(['like', 'NM_DIS', $this->NM_DIS])->andFilterWhere(['like', 'USER_ID', $this->USER_ID])->andFilterWhere(['like', 'UNIT_BARANG', $this->UNIT_BARANG])->andFilterWhere(['like', 'NOTED', $this->NOTED])->andFilterWhere(['like', 'ID_GROUP', $this->ID_GROUP])->andFilterWhere(['like', 'KODE_REF', $this->KODE_REF]);
return $dataProvider;
}
public function searchDetail1($params)
{
// $soQueryJoin= Yii::$app->db_esm->createCommand("
// SELECT x1.ID,x1.TGL,x1.WAKTU_INPUT_INVENTORY,x1.CUST_KD,x1.CUST_NM,x1.KD_BARANG,x1.NM_BARANG,x1.SO_QTY,x1.SO_TYPE,x1.POS,x1.STATUS,x1.ID_GROUP,
// x1.HARGA_PABRIK,x1.HARGA_DIS,x1.HARGA_LG,x1.HARGA_SALES,
// x1.KODE_REF,x1.USER_ID,x2.username,x3.NM_FIRST,x1.SUBMIT_QTY,x1.SUBMIT_PRICE,x1.NOTED,x4.ISI_MESSAGES,x5.CHECKIN_TIME,x5.CHECKOUT_TIME,
// x6.PIC,x6.TLP1,x6.KTP,x6.NPWP,x6.SIUP,x6.ALAMAT,x6.JOIN_DATE,x6.TLP1,x6.TLP2,x8.NM_UNIT,x8.QTY AS UNIT_QTY,x7.HARGA_SALES,
// (x1.SO_QTY/x8.QTY) AS UNIT_BRG,
// (x1.SO_QTY * x7.HARGA_SALES) as SUB_TOTAL,
// (x1.SUBMIT_QTY * x1.SUBMIT_PRICE) as SUBMIT_SUB_TOTAL,
// x1.KODE_REF,x9.USER_SIGN1,x9.TGL_SIGN2,x9.USER_SIGN2,x9.TGL_SIGN3,x9.USER_SIGN3
// FROM so_t2 x1
// LEFT JOIN dbm001.user x2 ON x2.id=x1.USER_ID
// LEFT JOIN dbm_086.user_profile x3 ON x3.ID_USER=x2.id
// LEFT JOIN c0014 x4 on x4.TGL=x1.TGL AND x4.ID_USER=x1.USER_ID
// LEFT JOIN c0002scdl_detail x5 on x5.TGL=x1.TGL AND x5.CUST_ID=x1.CUST_KD
// LEFT JOIN c0001 x6 on x6.CUST_KD=x1.CUST_KD
// LEFT JOIN b0001 x7 on x7.KD_BARANG=x1.KD_BARANG
// LEFT JOIN ub0001 x8 on x8.KD_UNIT=x7.KD_UNIT
// LEFT JOIN so_0001 x9 on x9.KD_SO=x1.KODE_REF
// WHERE x1.SO_TYPE=10 AND x1.TGL='".$this->TGL."' AND x1.CUST_KD='".$this->CUST_KD."';
// #CUS.2016.000638,CUS.2016.000619
// ")->queryAll();
// $dataProvider= new ArrayDataProvider([
// 'key' => 'ID',
// 'allModels'=>$soQueryJoin,
// 'pagination' => [
// 'pageSize' => 50,
// ]
// ]);
$soQueryJoin = "\n\t\t\tSELECT x1.ID,x1.TGL,x1.WAKTU_INPUT_INVENTORY,x1.CUST_KD,x1.CUST_NM,x1.KD_BARANG,x1.NM_BARANG,x1.SO_QTY,x1.SO_TYPE,x1.POS,x1.STATUS,x1.ID_GROUP,\n\t\t\t\tx1.HARGA_PABRIK,x1.HARGA_DIS,x1.HARGA_LG,x1.HARGA_SALES,x1.USER_ID,x2.username,x3.NM_FIRST,x1.SUBMIT_QTY,x1.SUBMIT_PRICE,x1.NOTED,x4.ISI_MESSAGES,x5.CHECKIN_TIME,x5.CHECKOUT_TIME,\n\t\t\t\tx6.PIC,x6.TLP1,x6.KTP,x6.NPWP,x6.SIUP,x6.ALAMAT,x6.JOIN_DATE,x6.TLP2,x8.NM_UNIT,x8.QTY AS UNIT_QTY,\n\t\t\t\t(x1.SO_QTY/x8.QTY) AS UNIT_BRG,\n\t\t\t\t(CASE WHEN (x1.STATUS<>3 OR x1.STATUS<>4) THEN (x1.SO_QTY * x7.HARGA_SALES) ELSE 0 END)as SUB_TOTAL,\n\t\t\t\t(x1.SUBMIT_QTY * x1.SUBMIT_PRICE) as SUBMIT_SUB_TOTAL,\n\t\t\t\tx1.KODE_REF,x9.USER_SIGN1,x9.TGL_SIGN2,x9.USER_SIGN2,x9.TGL_SIGN3,x9.USER_SIGN3\n\t\t\tFROM so_t2 x1 \n\t\t\t\tLEFT JOIN dbm001.user x2 ON x2.id=x1.USER_ID\n\t\t\t\tLEFT JOIN dbm_086.user_profile x3 ON x3.ID_USER=x2.id\n\t\t\t\tLEFT JOIN c0014 x4 on x4.TGL=x1.TGL AND x4.ID_USER=x1.USER_ID\n\t\t\t\tLEFT JOIN c0002scdl_detail x5 on x5.TGL=x1.TGL AND x5.CUST_ID=x1.CUST_KD\n\t\t\t\tLEFT JOIN c0001 x6 on x6.CUST_KD=x1.CUST_KD\n\t\t\t\tLEFT JOIN b0001 x7 on x7.KD_BARANG=x1.KD_BARANG\n\t\t\t\tLEFT JOIN ub0001 x8 on x8.KD_UNIT=x7.KD_UNIT\n\t\t\t\tLEFT JOIN so_0001 x9 on x9.KD_SO=x1.KODE_REF\n\t\t\tWHERE x1.SO_TYPE=10 AND x1.KODE_REF='" . $this->KODE_REF . "' AND x1.CUST_KD='" . $this->CUST_KD . "' AND x1.STATUS<>3\t\t\n\t\t";
$sql = SoT2::findBySql($soQueryJoin);
$dataProvider = new ActiveDataProvider(['query' => $sql, 'pagination' => ['pageSize' => 10]]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
// $filter = new Filter();
// $this->addCondition($filter, 'TGL', true);
// $this->addCondition($filter, 'CUST_KD', true);
// $this->addCondition($filter, 'KD_BARANG', true);
// $this->addCondition($filter, 'USER_ID', true);
// $dataProvider->allModels = $filter->filter($soQueryJoin);
return $dataProvider;
}
public function actionCetakpdf($id)
{
$modelSoT2 = SoT2::find()->with('cust')->where("KODE_REF='" . $id . "' AND SO_TYPE=10")->one();
$soHeaderData = SoHeader::find()->where(['KD_SO' => $id])->one();
$getSoType = 10;
$getTGL = $modelSoT2->TGL;
$getCUST_KD = $modelSoT2->CUST_KD;
$getUSER_ID = $modelSoT2->USER_ID;
$searchModelDetail = new SoDetailSearch(['KODE_REF' => $id, 'CUST_KD' => $getCUST_KD, 'USER_ID' => $getUSER_ID]);
$aryProviderSoDetail = $searchModelDetail->searchDetail(Yii::$app->request->queryParams);
$content = $this->renderPartial('pdf', ['soHeaderData' => $soHeaderData, 'aryProviderSoDetail' => $aryProviderSoDetail]);
$pdf = new Pdf(['mode' => Pdf::MODE_CORE, 'format' => Pdf::FORMAT_A4, 'orientation' => Pdf::ORIENT_PORTRAIT, 'destination' => Pdf::DEST_BROWSER, 'content' => $content, 'cssFile' => '@lukisongroup/web/widget/pdf-asset/kv-mpdf-bootstrap.min.css', 'cssInline' => '.kv-heading-1{font-size:12px}', 'options' => ['title' => 'Form Request Order', 'subject' => 'ro'], 'methods' => ['SetHeader' => ['Copyright@LukisonGroup ' . date("r")], 'SetFooter' => ['{PAGENO}']]]);
/* KIRIM ATTACH emaiL */
//$to=['*****@*****.**'];
//\Yii::$app->kirim_email->pdf($contentMailAttach,'PO',$to,'Purchase-Order',$contentMailAttachBody);
return $pdf->render();
}
public function actionTestContent($id)
{
$soHeaderData = SoHeader::find()->where(['id' => $id])->one();
$modelSoT2 = SoT2::find()->with('cust')->where("KODE_REF='" . $soHeaderData->KD_SO . "' AND SO_TYPE=10")->one();
$getSoType = 10;
$getTGL = $modelSoT2->TGL;
$getCUST_KD = $modelSoT2->CUST_KD;
$getUSER_ID = $modelSoT2->USER_ID;
/*Body Notify*/
return $this->renderPartial('postman_body', ['soHeaderData' => $soHeaderData]);
}
/**
* Finds the SoT2 model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return SoT2 the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = SoT2::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}