public function addmodels($id) { if ($this->isAdminRequest()) { //$id = $_POST['id']; // print_r($_POST); $rules = array('models' => 'required'); $validator = Validator::make(Input::all(), $rules); // process the login if ($validator->fails()) { return Redirect::to('admin/products/' . $id . '/models')->withErrors($validator)->with('productcategory', ProductCategory::find($id))->with('models', Products::where('product_category_id', '=', $id)->get())->withInput(Input::all()); } else { $models = Input::get('models'); $models_arr = explode(",", $models); foreach ($models_arr as $model) { $product_model = new Products(); $product_model->model_id = $model; $product_model->product_category_id = $id; $product_model->save(); } // // redirect Session::flash('message', 'Successfully added models.'); return Redirect::to('admin/products/' . $id . '/models'); } //$import = importmodels('boo'); // // $productcategory = ProductCategory::find($id); // $models = Products::where('product_category_id','=',$id)->get(); // return View::make('admin.products.models') // ->with('productcategory',$productcategory) // ->with('models',$models); // } } }
public static function filter($input, $limit = 24) { $products = Products::where(function ($query) use($input) { if (array_key_exists('name', $input) && strlen($input['name'])) { $query->where('name', 'LIKE', "%" . $input['name'] . "%"); } if (array_key_exists('name_code', $input) && strlen($input['name_code'])) { $query->where(function ($query) use($input) { $query->where('name', 'LIKE', "%" . $input['name_code'] . "%"); $query->orWhere('product_code', 'LIKE', "%" . trim($input['name_code']) . "%"); }); } if (array_key_exists('type', $input) && strlen($input['type'])) { $query->whereTypeId($input['type']); } if (array_key_exists('entry_from', $input) && strlen($input['entry_from'])) { $query->where(DB::raw('DATE(created_at)'), '>=', date('Y-m-d', strtotime($input['entry_from']))); } if (array_key_exists('entry_to', $input) && strlen($input['entry_to'])) { $query->where(DB::raw('DATE(created_at)'), '<=', date('Y-m-d', strtotime($input['entry_to']))); } if (array_key_exists('unit', $input) && strlen($input['unit'])) { $query->whereTypeId($input['unit']); } if (array_key_exists('barcode', $input) && strlen($input['barcode'])) { $query->where('product_code', 'LIKE', "%" . trim($input['barcode']) . "%"); } })->select('products.*', DB::raw('CONCAT(name, " - Rs. ", cp , " / Rs. " , sp, ":",id) as nameprice'))->orderBy('name', 'asc'); if ($limit == 0) { return $products->get(); } else { return $products->paginate($limit); } }
public function exists($id) { $exists = Products::where('supplierId', $id)->first(); if ($exists == null) { return false; } else { return true; } }
public function approve($id) { $outletsStocksReturns = OutletsStocksReturns::find($id); //echo $outletsStocksReturns->product_id;exit(); if ($outletsStocksReturns) { $product = Products::where('id', '=', $outletsStocksReturns->product_id)->first(); $product->quantity = $product->quantity + $outletsStocksReturns->quantity; $product->save(); $outletsStocks = OutletsStocks::where('product_id', '=', $outletsStocksReturns->product_id)->where('outlet_id', '=', $outletsStocksReturns->outlet_id)->first(); $outletsStocks->quantity = $outletsStocks->quantity - $outletsStocksReturns->quantity; $outletsStocks->save(); $outletsStocksReturns->status = "Approved"; $outletsStocksReturns->save(); return Redirect::route('stockreturns.index')->with('success', 'Stock Return Completed'); } else { return Redirect::route('stockreturns.index')->with('error', 'Product not found in Outlets Stocks Returns Table'); } }
public static function updateProduct($data, $product_id = null) { $update = array(); foreach ($data as $key => $value) { if ($value != null) { $update[$key] = $value; } } if (empty($update)) { $response = array('status' => 400, 'error' => 'bad_request', 'params' => $data, 'message' => 'All parameters are blank/null, Please check your parameters.'); } else { $affectedRows = Products::where('product_id', $product_id)->update($update); if ($affectedRows == 1) { $response = array('status' => 200, 'error' => false, 'update' => $update, 'message' => 'Product has been successfully updated.'); } else { $response = array('status' => 402, 'error' => 'update_failed', 'update' => $update, 'message' => 'Product update failed.'); } } return $response; }
public function postRefund() { $postdata = Input::all(); $panIDPK = Input::get('pan_id_pk'); $currenttime = Commonmodel::dateandtime(); if (!$panIDPK) { return Response::json(array('status' => "failed", 'message' => 'Please send a PAN ID')); } else { $findrefuncid = Panoffiline::find($panIDPK); if ($findrefuncid) { $getcurrentuser = Panoffiline::where('pan_id_pk', '=', $panIDPK)->pluck('pan_created_by'); $response = Panoffiline::where('pan_id_pk', $panIDPK)->get(); if ($response) { foreach ($response as $res) { $userfinID = $res->pan_created_by; $panCoupenNo = $res->pan_coupon_no; $mainBalance = Userfinance::where('ufin_user_id', $userfinID)->pluck('ufin_main_balance'); $panTotBal = $mainBalance + 106; $balanceDebit = array('ufin_main_balance' => $panTotBal); if ($panCoupenNo != '0') { Userfinance::where('ufin_user_id', '=', $userfinID)->update($balanceDebit); $coupenReset = array('pan_coupon_no' => ''); Panoffiline::where('pan_id_pk', '=', $panIDPK)->update($coupenReset); $panCoupenUpdate = array('pc_coupon_no' => $panCoupenNo); $procode = Products::where('prod_short_name', '=', 'PANM')->pluck('prod_code'); $panledger = array('lr_date' => $currenttime, 'lr_trans_type' => 'CR', 'lr_comment' => 'Pan Refund', 'lr_credit_amount' => '106', 'lr_post_balance' => $panTotBal, 'lr_created_by' => $getcurrentuser, 'lr_prod_code' => $procode); $panlegcreta = new Ledgerreport(); $panlegcreta->create($panledger); $coupen = new Coupons(); $coupen->create($panCoupenUpdate); return Response::json(array('status' => "success", 'message' => 'Amount debited successfully')); } else { return Response::json(array('status' => "failure", 'message' => 'PAN Card has been already applied for refund')); } } } } else { return Response::json(array('status' => "failure", 'message' => 'No User found for this ID')); } } }