public function getDetail() { //$id = \Input::get('id'); $input = \Input::all(); if ($input['type'] == 'sale') { $detail = Sale::find($input['id']); } else { $detail = Purchase::find($input['id']); } return \Response::json($detail); }
public function editSale() { $input = \Input::all(); $sale = Sale::find($input['id']); $sale->product_id = $input['productId']; $sale->date = $input['date']; $sale->quantity = $input['quantity']; $sale->total_price = $input['totalPrice']; $sale->unit_price = $input['unit_price']; $sale->save(); return \Response::json($sale); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Sale::find(); // add conditions that should always apply here $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; } // grid filtering conditions $query->andFilterWhere(['id' => $this->id, 'product_id' => $this->product_id, 'day' => $this->day]); $query->andFilterWhere(['like', 'description', $this->description]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Sale::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', 'customer', $this->customer]); return $dataProvider; }
function process($saleId, $statusId) { $response = new ResponseEntity(); try { DB::transaction(function () use(&$response, $saleId, $statusId) { $sale = Sale::find($saleId); if ($sale) { $sp = new SaleProcessed(); $sp->qc_user_id = 1; $sp->sale_status_id = $statusId; $sp->user_id = $sale->user_id; $sp->product_id = $sale->product_id; $sp->customer_id = $sale->customer_id; $sp->date_sold = $sale->date_sold; $sp->order_number = $sale->order_number; $sp->ninety_days = $sale->ninety_days; $sp->remarks = $sale->remarks; $sp->entered_datetime = $sale->created_at; $ok = $sp->save(); if ($ok) { $deleted = Sale::destroy($saleId); if ($deleted) { $response->setSuccess(true); $response->setMessages(['Sale successfully processed!']); } else { $response->setMessages(['Failed to process sale!']); } } else { $response->setMessages(['Failed to process sale!']); } } else { $response->setMessages(['Sale not available']); } }); } catch (\Exception $ex) { $response->setMessages(['Exception: ' . $ex->getMessage()]); } return $response; }
public function download_csv_sales(Request $request, $id) { if ($request->ajax()) { $search_value = $request->input('search_value'); if ($search_value == NULL) { $download_csv_data = Factoryitem::sales($id); $item = Item::find($id); return response()->json(array('download_csv_data' => $download_csv_data, 'item' => $item)); } else { $download_csv_data = Factoryitem::where('itemsid', $id)->where(function ($query) use($search_value) { $query->where('slno', 'like', '%' . $search_value . '%')->orWhere('created_at', 'like', '%' . $search_value . '%'); })->where('sale_product', 1)->get(); if ($download_csv_data->count() > 0) { foreach ($download_csv_data as $csv_data) { $sale = Sale::find($csv_data->salesid); $csv_data->invoice_no = $sale->name; } } $item = Item::find($id); return response()->json(array('download_csv_data' => $download_csv_data, 'item' => $item)); } } }
public function setVerified($saleId) { $response = new ResponseEntity(); try { $sale = Sale::find($saleId); if ($sale) { $sale->verified = 1; $sale->save(); $response->setSuccess(true); $response->setMessage('Sale successfully verified!'); } else { $response->setMessage('Sale not available'); } } catch (\Exception $ex) { $response->setMessages(['Exception: ' . $ex->getMessage()]); } return $response; }