示例#1
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = ServiceCategory::find();
     $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, 'pid' => $this->pid, 'update_time' => $this->update_time, 'delect' => $this->delect]);
     $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'create_time', $this->create_time]);
     //伪删除, 返回delect大于 Dict::DEDLETE_FALSE 的
     $query->andWhere(['<', 'delect', 1]);
     return $dataProvider;
 }
示例#2
0
文件: Medicine.php 项目: weiyiyi/base
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getServiceCategory()
 {
     return $this->hasOne(ServiceCategory::className(), ['id' => 'sid']);
 }
 public function actionDelectAll()
 {
     $res = ServiceCategory::find()->asArray()->where(['>', 'delect', 0])->all();
     return $res;
 }
示例#4
0
 public function actionServiceCategory()
 {
     $res = ServiceCategory::find()->asArray()->where(['<', 'delect', 1])->all();
     $result = ArrayHelper::map($res, 'id', 'name');
     return $result;
 }