/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Offer::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, 'is_available' => $this->is_available, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at, 'created_by' => $this->created_by, 'updated_by' => $this->updated_by]);
$query->andFilterWhere(['like', 'slug', $this->slug])->andFilterWhere(['like', 'announcement', $this->announcement])->andFilterWhere(['like', 'content', $this->content])->andFilterWhere(['like', 'title', $this->title]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Offer::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, 'email' => $this->email, 'catgry' => $this->catgry, 'priority' => $this->priority, 'expires' => $this->expires, 'added' => $this->added]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'phone', $this->phone])->andFilterWhere(['like', 'website', $this->website])->andFilterWhere(['like', 'image', $this->image])->andFilterWhere(['like', 'location', $this->location])->andFilterWhere(['like', 'descript', $this->descript]);
return $dataProvider;
}
public function actionFeed($type = 'xml')
{
Yii::$app->response->format = \yii\web\Response::FORMAT_RAW;
$headers = Yii::$app->response->headers;
switch ($type) {
case 'xml':
$offers = Offer::find()->all();
$headers->add('Content-Type', 'text/xml; charset=utf-8');
$data = '<rss><channel>';
$data .= '<title> *** GdeZaVikend Ponude *** </title><items>';
foreach ($offers as $offer) {
$data .= '<item><name>' . $offer->name . '</name>' . '<description><![CDATA[' . $offer->descript . ']]></description>' . '<website><![CDATA[' . $offer->website . ']]></website>' . '<published>' . $offer->added . '</published></item>';
}
$data .= '</items></channel>';
$data .= '</rss>';
echo $data;
break;
case 'json':
$offers = Offer::find()->select('name, descript, website, email')->asArray()->all();
$headers->add('Content-Type', 'application/json');
echo json_encode($offers);
break;
default:
echo "Requested data format is unavailible at the moment...";
break;
}
}
public function ChangeStatus($id)
{
if (Auth::check()) {
if (in_array('ADD_EDIT_OFFER', $this->permission)) {
if (User::isSuperAdmin()) {
$entity = Offer::find($id);
} else {
$usr_company = $this->user_company();
$entity = Offer::whereHas('getAdvertiser', function ($q) use($usr_company) {
$q->whereHas('GetClientID', function ($p) use($usr_company) {
$p->whereIn('user_id', $usr_company);
});
})->find($id);
if (!$entity) {
return 'please Select your Client';
}
}
if ($entity) {
$data = array();
$audit = new AuditsController();
if ($entity->status == 'Active') {
array_push($data, 'status');
array_push($data, $entity->status);
array_push($data, 'Inactive');
$entity->status = 'Inactive';
$msg = 'disable';
} elseif ($entity->status == 'Inactive') {
array_push($data, 'status');
array_push($data, $entity->status);
array_push($data, 'Active');
$entity->status = 'Active';
$msg = 'actived';
}
$audit->store('offer', $id, $data, 'edit');
$entity->save();
return $msg;
}
}
return "You don't have permission";
}
return Redirect::to(url('user/login'));
}
