/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { /* componen */ $profile_id = Yii::$app->getUserOpt->profile_user()->emp->EMP_ID; $sort = Chatroom::find()->where(['GROUP_ID' => $profile_id])->one(); $query = Chatroom::find()->where(['SORT' => $sort, 'PARENT' => 0]); $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, 'PARENT' => $this->PARENT, 'SORT' => $this->SORT]); $query->andFilterWhere(['like', 'GROUP_ID', $this->GROUP_ID])->andFilterWhere(['like', 'GROUP_NM', $this->GROUP_NM]); $query->orderby(['SORT' => SORT_ASC]); return $dataProvider; }
/** * Creates a new Chatroom model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate() { $model = new Chatroom(); if ($model->load(Yii::$app->request->post())) { $model->PARENT = 0; $sql = Chatroom::find()->count(); $model->SORT = $sql + 1; $query = Chatroom::find()->select('GROUP_ID')->orderBy(['GROUP_ID' => SORT_DESC])->one(); $baris = count($query); if ($baris == 0) { $nomerkd = 1; } else { $kd = explode('.', $query->GROUP_ID); $nomerkd = $kd[1] + 1; } $digit = str_pad($nomerkd, 3, 0, STR_PAD_LEFT); $kode = 'G' . '.' . $digit; $model->GROUP_ID = $kode; $model->save(); return $this->redirect('index'); } else { return $this->renderAjax('create', ['model' => $model]); } }
* @author : wawan */ if (count($params) == 0) { $useavatar = Yii::$app->getUserOpt->profile_user()->emp; if ($useavatar->IMG_BASE64) { $gambaravatar = '/img_setting/noimage/df.jpg'; $nama = $useavatar->EMP_NM; } else { # code... $nama = $useavatar->EMP_NM; $gambaravatar = 'data:image/jpg;charset=utf-8;base64,' . $useavatar->IMG_BASE64; } } elseif ($params['chat'] == 'group') { # code... $group_id = $params['ChatSearch']['GROUP']; $useavatar = Chatroom::find()->where(['GROUP_ID' => $group_id])->one(); $nama = $useavatar->GROUP_NM; $gambaravatar = 'data:image/jpg;charset=utf-8;base64,' . $useavatar->IMAGE64; } else { $emp_chat_id = $params['ChatSearch']['GROUP']; $useavatar = Employe::find()->where(['EMP_ID' => $emp_chat_id])->one(); if ($useavatar->IMG_BASE64 == '') { $nama = $useavatar->EMP_NM; $gambaravatar = '/img_setting/noimage/df.jpg'; } else { # code... $nama = $useavatar->EMP_NM; $gambaravatar = 'data:image/jpg;charset=utf-8;base64,' . $useavatar->IMG_BASE64; } } ?>