public function postItrregister()
 {
     $postdata = file_get_contents("php://input");
     if (!empty($postdata)) {
         $inputid = Input::get('userId');
         $itr_name = Input::get('name');
         $itr_pan = Input::get('pan');
         $itr_bankstatement = Input::get('bankstatement');
         $itr_form16 = Input::get('form16');
         $itr_tdscertificate = Input::get('tds');
         $itr_addrproof = Input::get('addrproof');
         $itr_previtr = Input::get('itrcopy');
         $itr_bankname = Input::get('bankacname');
         $itr_bankacctype = Input::get('actype');
         $itr_bankaccno = Input::get('accno');
         $itr_bankifsc = Input::get('ifsccode');
         $itr_fyear = Input::get('fyear');
         $itr_mobileno = Input::get('mobileno');
         $itr_email = Input::get('email');
         $itr_createdby = Input::get('userId');
         $itr_createdat = Commonmodel::dateandtime();
         $itr_status = 1;
         $itr_clientip = Input::get('clientip');
         //	echo $itr_name,"<br/>", $itr_pan ,"<br/>", $itr_bankstatement; exit;
         if ($itr_name != '' && $itr_pan != '' && $itr_bankstatement != '' && $itr_addrproof != '' && $itr_mobileno != '' && $itr_email != '') {
             $detectyear = Itr::where('itr_mobileno', '=', $itr_mobileno)->pluck('itr_createdat');
             $enreytear = Commonmodel::detectyear($itr_createdat);
             $currentyear = Commonmodel::detectyear($detectyear);
             if ($enreytear == $currentyear) {
                 return Response::json(array('status' => 'failure', 'message' => 'You have Already Applyied For IRT this year'));
             } else {
                 $checkbalance = Userfinance::where('ufin_user_id', '=', $inputid)->where('ufin_main_balance', '<', '100')->get();
                 $getbalance = Userfinance::where('ufin_user_id', '=', $inputid)->pluck('ufin_main_balance');
                 if (count($checkbalance) > 0) {
                     return Response::json(array('status' => 'failure', 'message' => 'You Do not Have Sufficient Balance TO Apply for IRT'));
                 } else {
                     $input = array('itr_name' => $itr_name, 'itr_pan' => $itr_pan, 'itr_bankstatement' => $itr_bankstatement, 'itr_form16' => $itr_form16, 'itr_tdscertificate' => $itr_tdscertificate, 'itr_addrproof' => $itr_addrproof, 'itr_previtr' => $itr_previtr, 'itr_bankname' => $itr_bankname, 'itr_bankacctype' => $itr_bankacctype, 'itr_bankaccno' => $itr_bankaccno, 'itr_bankifsc' => $itr_bankifsc, 'itr_fyear' => $itr_fyear, 'itr_mobileno' => $itr_mobileno, 'itr_email' => $itr_email, 'itr_createdby' => $itr_createdby, 'itr_createdat' => $itr_createdat, 'itr_status' => $itr_status, 'itr_clientip' => $itr_clientip);
                     $obj = new Itr();
                     $obj->create($input);
                     $getbalance = $getbalance - 99;
                     $balance = array('ufin_main_balance' => $getbalance);
                     Userfinance::where('ufin_user_id', $inputid)->update($balance);
                     return Response::json(array('status' => 'Success', 'message' => 'Your PAN Card Details Have been Registered Successfully'));
                 }
             }
         } else {
             return Response::json(array('status' => 'failure', 'message' => 'Fill all manditary fields'));
         }
     } else {
         return Response::json(array('status' => 'failure', 'message' => 'Fill all manditary fields'));
     }
 }
 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'));
         }
     }
 }
 public function __construct()
 {
     $currentdateandtime = Commonmodel::dateandtime();
     View::share('currentdateandtime', $currentdateandtime);
 }
 public function postPostpaidrecharge()
 {
     $postdata = file_get_contents("php://input");
     if (!empty($postdata)) {
         $currenttime = Commonmodel::dateandtime();
         $currentUserId = Input::get('currentUserId');
         $currentUserIdPk = Input::get('currentUserIdPk');
         $prodCode = Input::get('prodCode');
         $amount = Input::get('amount');
         $number = Input::get('number');
         $provider = Input::get('provider');
         $clientIp = Input::get('clientIp');
         $limit = Input::get('limit');
         $requestid = 0;
         if ($currentUserId != "" && $currentUserIdPk != "" && $prodCode != "" && $amount != "" && $number != "" && $provider != "" && $clientIp != "") {
             $checkbalance = Userfinance::where('ufin_user_id', '=', $currentUserId)->where('ufin_main_balance', '>=', $amount)->get();
             $checkproductcode = Rechargeservices::where('rm_name', '=', $provider)->where('rm_prod_code', '=', $prodCode)->get();
             if (count($checkproductcode) > 0) {
                 $admin_commission = $checkproductcode[0]->rm_commission;
                 $fran_commission = $checkproductcode[0]->rm_dcommission;
                 $retailser_commission = $checkproductcode[0]->rm_scommission;
                 $sub_retail_commission = $checkproductcode[0]->rm_fcommission;
                 $sub_distributer = $checkproductcode[0]->rm_sdcommission;
                 $admin_commission_store = $amount * $admin_commission;
                 $fran_commission_store = $admin_commission_store * $fran_commission;
                 $retailser_commission_store = $fran_commission_store * $retailser_commission;
                 $sub_retail_commission_store = $retailser_commission_store * $sub_retail_commission;
                 $admin_distributer_store = $sub_retail_commission_store * $sub_distributer;
                 if (count($checkbalance) > 0) {
                     $getstatus = Rechargeurl::rechargepostpaidnumber($checkproductcode[0]->rm_ezypay_opcode, $number, $amount, $requestid);
                     $createdtype = User::where('UD_USER_ID', '=', $currentUserId)->pluck('UD_USER_TYPE');
                     $currentbalnce = $checkbalance[0]->ufin_main_balance;
                     if ($getstatus[4] != 'Transaction Successful' && $getstatus[4] != 'Transaction Pending' && $getstatus[4] != 'Timeout') {
                         return Response::json(array('message' => $getstatus[4]));
                     } elseif ($getstatus[4] == 'Transaction Successful' || $getstatus[4] != 'Transaction Pending' || $getstatus[4] != 'Timeout') {
                         if ($getstatus[4] == 'Transaction Successful') {
                             $updatestatusvar = "Success";
                         } else {
                             $updatestatusvar = "Pending";
                         }
                         $input = array('rd_prod_code' => $prodCode, 'rd_service_provider' => $provider, 'rd_number' => $number, 'rd_amount' => $amount, 'rd_created_at' => $currenttime, 'rd_created_by' => $currentUserId, 'rd_created_type' => $createdtype, 'rd_result' => $updatestatusvar, 'rd_trans_id' => $getstatus[0], 'rd_client_ip' => Input::get('clientIp'), 'rd_provider' => "Ezypay");
                         //
                         $recharenew = new Rechargedetails();
                         $recharenew->create($input);
                         if ($createdtype == 'FR' || $createdtype == 'SFR') {
                             $currentbalnce = $currentbalnce - $amount;
                             $balance = array('ufin_main_balance' => $currentbalnce);
                             Userfinance::where('ufin_user_id', $currentUserId)->update($balance);
                         } elseif ($createdtype == 'FRS' || $createdtype == 'SFRS') {
                             $parentid = User::where('UD_USER_ID', '=', $currentUserId)->pluck('UD_PARENT_ID');
                             $currentbalnce = User::where('ufin_user_id_pk_fk', '=', $parentid)->pluck('ufin_main_balance');
                             $currentbalnce = $currentbalnce - $amount;
                             $balance = array('ufin_main_balance' => $currentbalnce);
                             Userfinance::where('ufin_user_id', $currentbalnce)->update($balance);
                         }
                         $comission = array('lr_date' => $currenttime, 'lr_trans_type' => 'Debited', 'lr_comment' => 'Debited by Easy Pay API', 'lr_debit_amount' => $amount, 'lr_post_balance' => $currentbalnce, 'lr_created_by' => $currentUserId, 'lr_prod_code' => $prodCode);
                         $getlastinseertedcomid = Comission::insertGetId($comission);
                         $getcomission = Rechargeservices::where('rm_name', '=', $provider)->get();
                         if ($getcomission) {
                             foreach ($getcomission as $getcomissions) {
                             }
                             $admincomission = $getcomissions->rm_commission;
                             $admincomissionvalue = $admincomission / 100;
                             $admincomissionamount = $amount * (1 * $admincomissionvalue / (1 + $admincomissionvalue));
                             $statepartner = $getcomissions->rm_scommission;
                             $statepartnervalue = $statepartner / 100;
                             $statepartneramount = $amount * (1 * $statepartnervalue) / (1 + $statepartnervalue);
                             $statedistributer = $getcomissions->rm_sdcommission;
                             $statedistributervalue = $admincomission / 100;
                             $statedistributeramount = $amount * (1 * $statedistributervalue) / (1 + $statedistributervalue);
                             $distributer = $getcomissions->rm_dcommission;
                             $distributervalue = $statedistributer / 100;
                             $distributeramount = $amount * (1 * $distributervalue) / (1 + $distributervalue);
                             $franchise = $getcomissions->rm_fcommission;
                             $franchisevalue = $franchise / 100;
                             $franchiseamount = $amount * (1 * $franchisevalue) / (1 + $franchisevalue);
                             $subfranchise = $getcomissions->rm_sfcommission;
                             $subfranchisevalue = $subfranchise / 100;
                             $subfranchiseamount = $amount * (1 * $subfranchisevalue) / (1 + $subfranchisevalue);
                             $getusertype = User::where('UD_USER_ID', '=', $currentUserId)->pluck('UD_USER_TYPE');
                             if ($getusertype == 'FR' || $getusertype == 'FRS') {
                                 if ($getusertype == 'FR') {
                                     $fr_commission_id = User::where('UD_USER_ID', '=', $currentUserId)->pluck('UD_ID_PK');
                                     $fr_commission_balance = Userfinance::where('ufin_user_id_pk_fk', '=', $fr_commission_id)->pluck('ufin_main_balance');
                                 } elseif ($getusertype == 'FRS') {
                                     $frs_commission_id = User::where('UD_USER_ID', '=', $currentUserId)->pluck('UD_ID_PK');
                                     $frs_commission_balance = Userfinance::where('ufin_user_id_pk_fk', '=', $frs_commission_id)->pluck('ufin_main_balance');
                                     $fr_commission_id = User::where('UD_USER_ID', '=', $frs_commission_id)->pluck('UD_PARENT_ID');
                                     $fr_commission_balance = Userfinance::where('ufin_user_id_pk_fk', '=', $fr_commission_id)->pluck('ufin_main_balance');
                                 }
                                 $fr_commission_balance = $fr_commission_balance + $franchiseamount;
                                 $sd_commission_id = User::where('UD_ID_PK', '=', $fr_commission_id)->pluck('UD_PARENT_ID');
                                 $sd_commission_balance = Userfinance::where('ufin_user_id_pk_fk', '=', $sd_commission_id)->pluck('ufin_main_balance');
                                 $sd_commission_balance = $sd_commission_balance + $distributeramount;
                                 $d_commission_id = User::where('UD_ID_PK', '=', $sd_commission_id)->pluck('UD_PARENT_ID');
                                 $d_commission_balance = Userfinance::where('ufin_user_id_pk_fk', '=', $d_commission_id)->pluck('ufin_main_balance');
                                 $d_commission_balance = $d_commission_balance + $distributeramount;
                                 $sp_commissio_id = User::where('UD_ID_PK', '=', $d_commission_id)->pluck('UD_PARENT_ID');
                                 $sp_commissio_balance = Userfinance::where('ufin_user_id_pk_fk', '=', $sp_commissio_id)->pluck('ufin_main_balance');
                                 $sp_commissio_balance = $sp_commissio_balance + $statepartneramount;
                                 $sa_commission_id = User::where('UD_ID_PK', '=', $sp_commissio_id)->pluck('UD_PARENT_ID');
                                 $sa_commission_balance = Userfinance::where('ufin_user_id_pk_fk', '=', $sa_commission_id)->pluck('ufin_main_balance');
                                 $sa_commissio_balance = $sa_commission_balance + $admincomissionamount;
                                 $sabalance1 = array('ufin_main_balance' => $sa_commissio_balance);
                                 Userfinance::where('ufin_user_id_pk_fk', $sa_commission_id)->update($sabalance1);
                                 $spbalance1 = array('ufin_main_balance' => $sp_commissio_balance);
                                 Userfinance::where('ufin_user_id_pk_fk', $sp_commissio_id)->update($spbalance1);
                                 $sd_commission_balance1 = array('ufin_main_balance' => $sp_commissio_balance);
                                 Userfinance::where('ufin_user_id_pk_fk', $sd_commission_id)->update($sd_commission_balance1);
                                 $d_commission_balance1 = array('ufin_main_balance' => $sp_commissio_balance);
                                 Userfinance::where('ufin_user_id_pk_fk', $d_commission_id)->update($d_commission_balance1);
                                 if ($getusertype == 'FR') {
                                     $f_commission_balance1 = array('ufin_main_balance' => $fr_commission_balance);
                                     Userfinance::where('ufin_user_id_pk_fk', $fr_commission_id)->update($f_commission_balance1);
                                 } elseif ($getusertype == 'FRS') {
                                     $f_commission_balance1 = array('ufin_main_balance' => $fr_commission_balance);
                                     Userfinance::where('ufin_user_id_pk_fk', $fr_commission_id)->update($f_commission_balance1);
                                 }
                                 $rechargeledgerupdate = array('rchlgr_lr_id' => $getlastinseertedcomid, 'rchlgr_date' => $currenttime, 'rchlgr_sa_id' => $sa_commission_id, 'rchlgr_sa_commission' => $admincomissionamount, 'rchlgr_sp_id' => $sp_commissio_id, 'rchlgr_sp_commission' => $statepartneramount, 'rchlgr_sd_id' => $sd_commission_id, 'rchlgr_sd_commission' => $statedistributeramount, 'rchlgr_d_id' => $d_commission_id, 'rchlgr_d_commission' => $distributeramount, 'rchlgr_fr_id' => $fr_commission_id, 'rchlgr_fr_commission' => $franchiseamount);
                                 $newregcomittion = new Rechargeledger();
                                 $newregcomittion->create($rechargeledgerupdate);
                             } elseif ($getusertype == 'SFR' || $getusertype == 'SFRS') {
                                 if ($getusertype == 'SFR') {
                                     $sfr_commission_id = User::where('UD_USER_ID', '=', $currentUserId)->pluck('UD_ID_PK');
                                     $sfr_commission_balance = Userfinance::where('ufin_user_id_pk_fk', '=', $sfr_commission_id)->pluck('ufin_main_balance');
                                 } elseif ($getusertype == 'SFRS') {
                                     $sfrs_commission_id = User::where('UD_USER_ID', '=', $currentUserId)->pluck('UD_ID_PK');
                                     $sfrs_commission_balance = Userfinance::where('ufin_user_id_pk_fk', '=', $sfr_commission_id)->pluck('ufin_main_balance');
                                     $sfr_commission_id = User::where('UD_USER_ID', '=', $sfrs_commission_id)->pluck('UD_PARENT_ID');
                                     $sfr_commission_balance = Userfinance::where('ufin_user_id_pk_fk', '=', $sfr_commission_id)->pluck('ufin_main_balance');
                                 }
                                 $sfr_commission_balance = $sfr_commission_balance + $subfranchiseamount;
                                 $fr_commission_id = User::where('UD_ID_PK', '=', $sfr_commission_id)->pluck('UD_PARENT_ID');
                                 $fr_commission_balance = Userfinance::where('ufin_user_id_pk_fk', '=', $fr_commission_id)->pluck('ufin_main_balance');
                                 $fr_commission_balance = $fr_commission_balance + $franchiseamount;
                                 $d_commission_id = User::where('UD_ID_PK', '=', $fr_commission_id)->pluck('UD_PARENT_ID');
                                 $d_commission_balance = Userfinance::where('ufin_user_id_pk_fk', '=', $d_commission_id)->pluck('ufin_main_balance');
                                 $d_commission_balance = $d_commission_balance + $distributeramount;
                                 $sd_commission_id = User::where('UD_ID_PK', '=', $d_commission_id)->pluck('UD_PARENT_ID');
                                 $sd_commission_balance = Userfinance::where('ufin_user_id_pk_fk', '=', $sd_commission_id)->pluck('ufin_main_balance');
                                 $sd_commission_balance = $sd_commission_balance + $distributeramount;
                                 $sp_commissio_id = User::where('UD_ID_PK', '=', $sa_commission_id)->pluck('UD_PARENT_ID');
                                 $sp_commissio_balance = Userfinance::where('ufin_user_id_pk_fk', '=', $sp_commissio_id)->pluck('ufin_main_balance');
                                 $sp_commissio_balance = $sp_commissio_balance + $statepartneramount;
                                 $sa_commission_id = User::where('UD_ID_PK', '=', $fr_commission_id)->pluck('UD_PARENT_ID');
                                 $sa_commission_balance = Userfinance::where('ufin_user_id_pk_fk', '=', $sa_commission_id)->pluck('ufin_main_balance');
                                 $sa_commission_balance = $sa_commission_balance + $admincomissionamount;
                                 $sabalance1 = array('ufin_main_balance' => $sa_commissio_balance);
                                 Userfinance::where('ufin_user_id_pk_fk', $sa_commission_id)->update($sabalance1);
                                 $spbalance1 = array('ufin_main_balance' => $sp_commissio_balance);
                                 Userfinance::where('ufin_user_id_pk_fk', $sp_commissio_id)->update($spbalance1);
                                 $sd_commission_balance1 = array('ufin_main_balance' => $sp_commissio_balance);
                                 Userfinance::where('ufin_user_id_pk_fk', $sd_commission_id)->update($sd_commission_balance1);
                                 $d_commission_balance1 = array('ufin_main_balance' => $sp_commissio_balance);
                                 Userfinance::where('ufin_user_id_pk_fk', $d_commission_id)->update($d_commission_balance1);
                                 $f_commission_balance1 = array('ufin_main_balance' => $fr_commission_balance);
                                 Userfinance::where('ufin_user_id_pk_fk', $fr_commission_id)->update($f_commission_balance1);
                                 $sfr_commission_balance1 = array('ufin_main_balance' => $sfr_commission_balance);
                                 Userfinance::where('ufin_user_id_pk_fk', $fr_commission_id)->update($sfr_commission_balance1);
                                 $getcomission = array('rchlgr_lr_id' => $getlastinseertedcomid, 'rchlgr_sa_id' => $sa_commission_id, 'rchlgr_sa_commission' => $admincomissionamount, 'rchlgr_sp_id' => $sp_commissio_id, 'rchlgr_sp_commission' => $statepartneramount, 'rchlgr_sd_id' => $sd_commission_id, 'rchlgr_sd_commission' => $statedistributeramount, 'rchlgr_d_id' => $d_commission_id, 'rchlgr_d_commission' => $distributeramount, 'rchlgr_fr_id' => $fr_commission_id, 'rchlgr_fr_commission' => $franchiseamount, 'rchlgr_sfr_id' => $sfr_commission_id, 'rchlgr_sfr_commission' => $subfranchiseamount);
                                 $newregcomittion = new Rechargeledger();
                                 $newregcomittion->create($getcomission);
                             }
                         }
                         return Response::json(array('status' => 'success', 'message' => 'Recharge Done Successfully'));
                     } else {
                         return Response::json(array('status' => 'failure', 'message' => 'Contact Your Service Provider'));
                     }
                 } else {
                     return Response::json(array('status' => 'failure', 'message' => 'You Do not have Sufficient Balance'));
                 }
             } else {
                 return Response::json(array('status' => 'failure', 'message' => 'There is No Such Product ID'));
             }
         } else {
             return Response::json(array('status' => 'failure', 'message' => 'Fill all manditary fields'));
         }
     } else {
         return Response::json(array('status' => 'failure', 'message' => 'Fill all manditary fields'));
     }
 }
 public function postUpdateuser()
 {
     $postdata = file_get_contents("php://input");
     if (!empty($postdata)) {
         $userName = Input::get('userName');
         $userEmail = Input::get('userEmail');
         $userMobile = Input::get('userMobile');
         $currentUserId = Input::get('currentUserId');
         $currentUserIdPk = Input::get('currentUserIdPk');
         $parentId = Input::get('parentId');
         $parentIdPk = Input::get('parentIdPk');
         $userIdPk = Input::get('userIdPk');
         $userAddress1 = Input::get('userAddress1');
         $userAddress2 = Input::get('userAddress2');
         $userCity = Input::get('userCity');
         $userState = Input::get('userState');
         $userPincode = Input::get('userPincode');
         $userStatus = Input::get('userStatus');
         $userType = Input::get('userType');
         $products = Input::get('products');
         $userKey = Input::get('userKey');
         $usercount = Input::get('user_count');
         $editeddate = Commonmodel::dateandtime();
         if ($userName != "" && $userEmail != "" && $userMobile != "" && $currentUserId != "" && $currentUserIdPk != "" && $parentId != "" && $parentIdPk != "" && $userIdPk != "" && $userAddress1 != "" && $userAddress2 != "" && $userCity != "" && $userState != "" && $userState != "" && $userPincode != "" && $userStatus != "" && $userType != '') {
             $checkueremail = User::where('UD_ID_PK', '!=', $userIdPk)->where('UD_USER_EMAIL', '=', $userEmail)->get();
             if (count($checkueremail) > 0) {
                 return Response::json(array('status' => 'failure', 'message' => 'Email ID Already Exist'));
             } else {
                 $checkmobile = User::where('UD_ID_PK', '!=', $userIdPk)->where('UD_USER_MOBILE', '=', $userMobile)->get();
                 if (count($checkmobile) > 0) {
                     return Response::json(array('status' => 'failure', 'message' => 'Mobile Number Already Exist'));
                 } else {
                     $checkuser = User::where('UD_ID_PK', '!=', $userIdPk)->get();
                     if (count($checkuser) == 0) {
                         return Response::json(array('status' => 'failure', 'message' => 'User ID Already Exist'));
                     } else {
                         if ($userKey) {
                             if (empty($usercount)) {
                                 $usercount = 0;
                             }
                             $input = array('UD_USER_NAME' => Input::get('userName'), 'UD_USER_KEY' => md5(Input::get('userKey')), 'UD_PARENT_ID' => Input::get('parentIdPk'), 'UD_USER_TYPE' => Input::get('userType'), 'UD_USER_EMAIL' => Input::get('userEmail'), 'UD_USER_MOBILE' => Input::get('userMobile'), 'UD_USER_ADDRESS1' => Input::get('userAddress1'), 'UD_USER_ADDRESS2' => Input::get('userAddress2'), 'UD_USER_CITY' => Input::get('userCity'), 'UD_USER_STATE' => Input::get('userState'), 'UD_USER_PINCODE' => Input::get('userPincode'), 'UD_USER_STATUS' => Input::get('userStatus'), 'UD_EDITED_AT' => $editeddate, 'UD_EDITED_BY' => Input::get('currentUserId'), 'UD_USER_CREATE_COUNT' => $usercount);
                             User::where('UD_ID_PK', '=', $userIdPk)->update($input);
                             $getnewuserid = User::where('UD_ID_PK', '=', $userIdPk)->pluck('UD_USER_ID');
                             if (count($products) > 0) {
                                 Userproductaccess::where('UD_ID_PK', '=', $userIdPk)->delete();
                                 $len = count($products);
                                 for ($j = 0; $j < $len; $j++) {
                                     $productinput = array('upa_prod_code' => $products[$j]['prodCode'], 'upa_ud_user_id' => $products[$j]['prodStatus'], 'upa_access_status' => $getnewuserid, 'upa_created_at' => $editeddate, 'upa_created_by' => $currentUserId);
                                     $newproduct = new Userproductaccess();
                                     $newproduct->create($productinput);
                                 }
                             }
                             return Response::json(array('status' => 'success', 'message' => 'User updated Successfully'));
                         } else {
                             $input = array('UD_USER_NAME' => Input::get('userName'), 'UD_PARENT_ID' => Input::get('parentIdPk'), 'UD_USER_TYPE' => Input::get('userType'), 'UD_USER_EMAIL' => Input::get('userEmail'), 'UD_USER_MOBILE' => Input::get('userMobile'), 'UD_USER_ADDRESS1' => Input::get('userAddress1'), 'UD_USER_ADDRESS2' => Input::get('userAddress2'), 'UD_USER_CITY' => Input::get('userCity'), 'UD_USER_STATE' => Input::get('userState'), 'UD_USER_PINCODE' => Input::get('userPincode'), 'UD_USER_STATUS' => Input::get('userStatus'), 'UD_EDITED_AT' => $editeddate, 'UD_EDITED_BY' => Input::get('currentUserId'), 'UD_USER_CREATE_COUNT' => $usercount);
                             User::where('UD_ID_PK', '=', $userIdPk)->update($input);
                             $getnewuserid = User::where('UD_ID_PK', '=', $userIdPk)->pluck('UD_USER_ID');
                             if (count($products) > 0) {
                                 Userproductaccess::where('upa_ud_user_id', '=', $getnewuserid)->delete();
                                 $len = count($products);
                                 for ($j = 0; $j < $len; $j++) {
                                     $productinput = array('upa_prod_code' => $products[$j]['prodCode'], 'upa_ud_user_id' => $getnewuserid, 'upa_access_status' => $products[$j]['prodStatus'], 'upa_created_at' => $editeddate, 'upa_created_by' => $currentUserId);
                                     $newproduct = new Userproductaccess();
                                     $newproduct->create($productinput);
                                 }
                             }
                             return Response::json(array('status' => 'success', 'message' => 'User updated Successfully'));
                         }
                     }
                 }
             }
         } else {
             return Response::json(array('status' => 'failure', 'message' => 'Fill All Manditary Fields'));
         }
     } else {
         return Response::json(array('status' => 'failure', 'message' => 'Fill All Manditary Fields'));
     }
 }