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;
}
