public function search($params)
{
$query = Music::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(['Id' => $this->Id, 'createdBy' => $this->createdBy, 'updatedBy' => $this->updatedBy, 'createdOn' => $this->createdOn, 'updatedOn' => $this->updatedOn, 'status' => $this->status]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'IP', $this->IP]);
return $dataProvider;
}
public static function getMusic($data)
{
$query = Music::find()->andWhere('deleted = 0')->limit(!empty($data['limit']) ? $data['limit'] : 20)->orderBy('id DESC');
if (!empty($data['userId'])) {
$query->andWhere('user_id = :user_id', [':user_id' => $data['userId']]);
}
if (!empty($data['artistOrTitle'])) {
$artistOrTitle = '%' . $data['artistOrTitle'] . '%';
$query->andWhere('artist LIKE :value OR title LIKE :value', [':value' => $artistOrTitle]);
}
return $query->all();
}
public function search($params)
{
$query = Music::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$dataProvider->setSort(['defaultOrder' => ['Id' => SORT_ASC, 'name' => SORT_ASC]]);
$query->andFilterWhere([music::tableName() . '.status' => '0']);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(['Id' => $this->Id, 'createdOn' => $this->createdOn, 'status' => $this->status, 'updatedOn' => $this->updatedOn, 'createdBy' => $this->createdBy, 'updatedBy' => $this->updatedBy]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'IP', $this->IP])->andFilterWhere(['like', 'alias', $this->alias])->andFilterWhere(['like', 'searchAlias', $this->searchAlias]);
return $dataProvider;
}
