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