public function actionProsesBerita($id)
{
$berita_save = Issuemd::find()->where(['ID' => $id])->one();
$profile = $berita_save->userprofile;
$con = Yii::$app->db_esm;
$connection = Yii::$app->db_widget;
$post = Yii::$app->request->post();
$status = $post['DynamicModel']['status'];
if ($status == 1) {
$transaction = $connection->beginTransaction();
try {
$generate_code = \Yii::$app->ambilkonci->getBeritaCode();
$code = \Yii::$app->ambilkonci->getkdIssue();
$connection->createCommand()->insert('bt0001', ['KD_BERITA' => $generate_code, 'JUDUL' => $berita_save->NM_CUSTOMER . ' - ' . $profile->NM_FIRST, 'ISI' => $berita_save->NM_CUSTOMER, 'KD_CORP' => Yii::$app->getUserOpt->Profile_user()->emp->EMP_CORP_ID, 'KD_DEP' => Yii::$app->getUserOpt->Profile_user()->emp->DEP_ID, 'CREATED_BY' => Yii::$app->getUserOpt->Profile_user()->EMP_ID, 'CREATED_ATCREATED_BY' => date('y-m-d h:i:s'), 'KD_REF' => $code, 'DATA_ALL' => $berita_save->ISI_MESSAGES])->execute();
$con->createCommand()->update('c0014', ['STATUS' => 2, 'ID_ISSUE_REF' => $code], ['ID' => $id])->execute();
//.... other SQL executions
$transaction->commit();
} catch (\Exception $e) {
$transaction->rollBack();
throw $e;
}
return $this->redirect(['/widget/berita/detail-berita', 'KD_BERITA' => $generate_code]);
} else {
$con->createCommand()->update('c0014', ['STATUS' => 3], ['ID' => $id])->execute();
return $this->redirect(['index']);
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Issuemd::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, 'ID_DETAIL' => $this->ID_DETAIL, 'ID_USER' => $this->ID_USER, 'TGL' => $this->TGL, 'STATUS' => $this->STATUS, 'CREATE_BY' => $this->CREATE_BY, 'CREATE_AT' => $this->CREATE_AT, 'UPDATE_BY' => $this->UPDATE_BY, 'UPDATE_AT' => $this->UPDATE_AT]);
$query->andFilterWhere(['like', 'KD_CUSTOMER', $this->KD_CUSTOMER])->andFilterWhere(['like', 'NM_CUSTOMER', $this->NM_CUSTOMER])->andFilterWhere(['like', 'NM_USER', $this->NM_USER])->andFilterWhere(['like', 'ISI_MESSAGES', $this->ISI_MESSAGES]);
return $dataProvider;
}
/** author wawan
* close Berita model.
* If close is successful, delete bt0001notify and return true.
* @return mixed
*/
public function actionCloseBerita()
{
if (Yii::$app->request->isAjax) {
$request = Yii::$app->request;
$id = $request->post('id');
$kd_ref = $request->post('kd_ref');
$connection = Yii::$app->db_widget;
$transaction = $connection->beginTransaction();
try {
$connection->createCommand()->update('bt0001', ['STATUS' => 0], 'KD_BERITA="' . $id . '"')->execute();
if (count($kd_ref) != 0) {
$issue = Issuemd::findOne(['ID_ISSUE_REF' => $kd_ref]);
$issue->STATUS = 3;
$issue->save();
}
$close = $connection->createCommand('DELETE FROM bt0001notify WHERE KD_BERITA=:kd_berita');
$close->bindParam(':kd_berita', $kd_berita);
$kd_berita = $id;
$close->execute();
$transaction->commit();
} catch (\Exception $e) {
$transaction->rollBack();
throw $e;
}
return true;
}
}
/**
* Finds the Issuemd model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Issuemd the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Issuemd::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
