public function getIndex() { $allCoupons = Coupons::orderBy('id', 'desc')->paginate(20); $type = 'category'; $data = array('pageTitle' => 'CouponJadu - Home', 'allCategories' => $this->allCategories, 'allStores' => $this->allStores, 'allCoupons' => $allCoupons, 'type' => $type); return View::make('home', $data); }
public function postCreate() { $postdata = file_get_contents("php://input"); if (!empty($postdata)) { $contactNo = Input::get('contactNo'); $currentUserId = Input::get('currentUserId'); $currenttime = Commonmodel::dateandtime(); } $check = Panoffiline::where('pan_contact_no', '=', $contactNo)->get(); if (count($check) > 0) { return Response::json(array('status' => 'failure', 'message' => 'You Have ALready Submitted your Regisstration form for PAN Card')); } else { $checktype = User::where('UD_USER_ID', '=', $currentUserId)->pluck('UD_USER_TYPE'); if ($checktype) { if ($checktype != 'FRS') { $checkbalance = DB::table('adt_user_finance')->where('ufin_user_id', '=', $currentUserId)->where('ufin_main_balance', '<=', '106')->get(); $getbalance = Userfinance::where('ufin_user_id', '=', $currentUserId)->pluck('ufin_main_balance'); } else { $getnewuserdetails = User::where('UD_USER_ID', '=', $currentUserId)->where('UD_USER_TYPE', '=', 'FRS')->pluck('UD_PARENT_ID'); $checkbalance = DB::table('adt_user_finance')->where('ufin_user_id', '=', $getnewuserdetails)->where('ufin_main_balance', '<=', '106')->get(); $getbalance = Userfinance::where('ufin_user_id', '=', $getnewuserdetails)->pluck('ufin_main_balance'); } $couponcheck = Coupons::orderBy('pc_coupon_no', 'ASC')->first()->pluck('pc_coupon_no'); if ($couponcheck) { if ($checkbalance || empty($getbalance) || !empty($checkbalance) || $getbalance <= 0) { return Response::json(array('status' => 'failure', 'message' => 'You Do not Have Sufficient Balance')); } else { $input = array('pan_coupon_no' => $couponcheck, 'pan_title' => Input::get('title'), 'pan_first_name' => Input::get('firstName'), 'pan_middle_name' => Input::get('lastName'), 'pan_last_name' => Input::get('middleName'), 'pan_name_abbrv' => Input::get('nameAbbrv'), 'pan_dob' => Input::get('dob'), 'pan_father_fname' => Input::get('fatherFname'), 'pan_father_mname' => Input::get('fatherMname'), 'pan_father_lname' => Input::get('fatherLname'), 'pan_country_code' => Input::get('countryCode'), 'pan_area_code' => Input::get('areaCode'), 'pan_contact_no' => Input::get('contactNo'), 'pan_email_id' => Input::get('emailId'), 'pan_created_at' => $currenttime, 'pan_created_by' => Input::get('currentUserId')); $getbalance = $getbalance - 106; $product = new Panoffiline(); $product->create($input); $balance = array('ufin_main_balance' => $getbalance); $procode = Products::where('prod_short_name', '=', 'PANM')->pluck('prod_code'); $panledger = array('lr_date' => $currenttime, 'lr_trans_type' => 'DB', 'lr_comment' => 'Pan', 'lr_debit_amount' => '106', 'lr_post_balance' => $getbalance, 'lr_created_by' => Input::get('currentUserId'), 'lr_prod_code' => $procode); $panlegcreta = new Ledgerreport(); $panlegcreta->create($panledger); Coupons::where('pc_coupon_no', '=', $couponcheck)->delete(); Userfinance::where('ufin_user_id', $currentUserId)->update($balance); return Response::json(array('status' => 'fuccess', 'message' => 'Your Document for PAN card have Been Submitted Successfully')); } } else { return Response::json(array('status' => 'failure', 'message' => 'You Don"t have any coupon to register pancard')); } } else { return Response::json(array('status' => 'failure', 'message' => 'You Don"t have any coupon to register pancard')); } } }