/** * 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]); }