/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Purchase::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, 'user_id' => $this->user_id, 'affiliate_id' => $this->affiliate_id, 'shop_id' => $this->shop_id, 'url_id' => $this->url_id, 'sum' => $this->sum, 'status' => $this->status, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]);
return $dataProvider;
}
/**
* @POST("/requests/moderation/{id}", as="admin.requests.moderation")
* @param Request $request
* @param $id
* @return \Illuminate\Http\RedirectResponse
*/
public function moderation(Request $request, $id)
{
$purchase = Purchase::find($id);
$user = User::where('id', $purchase->user_id)->first();
if (\Auth::user()->hasRole('supervisor')) {
$purchase->status_moderation = $request->input('status_moderation');
$purchase->update();
return back();
} elseif (\Auth::user()->hasRole('admin')) {
if ($purchase->status_trust == 0 && $purchase->type_id != 3) {
$bank = Banks::where('banks_profiles_id', 1)->first();
if ($minus = $request->input('minus')) {
$total = $purchase->total -= $minus;
$bank->amount -= $total;
$bank->update();
} else {
$bank->amount -= $purchase->total;
$bank->update();
}
} elseif ($purchase->status_trust == 1) {
if ($minus = $request->input('minus')) {
$total = $purchase->total -= $minus;
$user->balance += $total;
$user->update();
} else {
$user->balance += $purchase->total;
$user->update();
}
} elseif ($purchase->type_id == 3) {
$bank = Banks::where('banks_profiles_id', 1)->first();
if ($minus = $request->input('minus')) {
$total = $purchase->total -= $minus;
$bank->amount += $total;
$bank->update();
$user->balance += $total;
$user->update();
} else {
$bank->amount += $purchase->total;
$bank->update();
$user->balance += $purchase->total;
$user->update();
}
}
$purchase->status_admin = $request->input('status_admin');
$purchase->update();
return back();
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Purchase::find();
// add conditions that should always apply here
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10], 'sort' => ['defaultOrder' => ['updated_at' => SORT_DESC]]]);
$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, 'date' => $this->date, 'total' => $this->total, 'created_at' => $this->created_at, 'created_by' => $this->created_by, 'updated_at' => $this->updated_at, 'updated_by' => $this->updated_by]);
$query->andFilterWhere(['like', 'code', $this->code])->andFilterWhere(['like', 'supplier', $this->supplier]);
return $dataProvider;
}
public function register(Request $request)
{
$m = new Billspay();
$m->id = $request->input('id');
$m->purchaseid = $request->input('purchaseid');
$m->purchasedate = $request->input('purchasedate');
$m->amount = $request->input('amount');
if (Input::file('file')->isValid()) {
$d = 'uploads';
$e = Input::file('file')->getClientOriginalExtension();
$f = rand(11111, 99999) . '.' . $e;
Input::file('file')->move($d, $f);
}
$m->file = $f;
$m->userid = $request->input('userid');
$m->save();
$pid = $request->input('purchaseid');
$p = new Purchase();
$p = Purchase::find($pid);
$p->status = 1;
$p->save();
return redirect('billspay');
}
public function cancel_status(Request $request)
{
if ($request->ajax()) {
$sales_id = $request->input('sales_id');
$sales = Purchase::find($sales_id);
if (!empty($sales)) {
$sales->cstatus = 1;
$sales->save();
} else {
return response()->json(0);
}
return response()->json(1);
}
}
/**
* покупки пользователя
* @return type
*/
public function actionUserList()
{
$dataProvider = new ActiveDataProvider(['query' => Purchase::find()->where(['user_id' => Yii::$app->user->identity->id])->orWhere(['affiliate_id' => Yii::$app->user->identity->id])->orderBy('created_at DESC')]);
return $this->render('userList', ['dataProvider' => $dataProvider]);
}
