public function actionUploadJoin($KD_BERITA) { $fileName = 'file'; $model = new beritaimage(); $cariemp_inberita = Berita::find()->where(['KD_BERITA' => $KD_BERITA])->asArray()->one(); if (isset($_FILES[$fileName])) { $file = \yii\web\UploadedFile::getInstanceByName($fileName); //componen $profile = Yii::$app->getUserOpt->profile_user()->emp; $id = $profile->EMP_ID; $data = $this->saveimage(file_get_contents($file->tempName)); //call function saveimage using base64 $model->KD_BERITA = $KD_BERITA; $model->ID_USER = $id; $model->CREATED_BY = $cariemp_inberita['CREATED_BY']; $model->CREATED_AT = date("Y-m-d H:i:s"); $model->ATTACH64 = $data; $model->TYPE = 0; if ($model->save()) { //Now save file data to database echo \yii\helpers\Json::encode($file); } } return false; }
public function searchBeritaClose($params) { $query = Berita::find()->where('STATUS<>1'); $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; } $query->andFilterWhere(['ID' => $this->ID, 'STATUS' => $this->STATUS, 'CREATED_ATCREATED_BY' => $this->CREATE_AT, 'UPDATE_AT' => $this->UPDATE_AT]); $query->andFilterWhere(['like', 'KD_BERITA', $this->KD_BERITA])->andFilterWhere(['like', 'JUDUL', $this->JUDUL])->andFilterWhere(['like', 'ISI', $this->ISI])->andFilterWhere(['like', 'KD_CORP', $this->corphistory])->andFilterWhere(['like', 'KD_CAB', $this->KD_CAB])->andFilterWhere(['like', 'KD_DEP', $this->depthistory])->andFilterWhere(['like', 'DATA_PICT', $this->DATA_PICT])->andFilterWhere(['like', 'DATA_FILE', $this->DATA_FILE])->andFilterWhere(['like', 'CREATED_BY', $this->CREATED_BY])->andFilterWhere(['like', 'DATA_ALL', $this->DATA_ALL]); return $dataProvider; }