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 getTransfer($name, $val)
{
$usernew = User::where('UD_USER_ID', $name)->get();
if (count($usernew) > 0) {
if ($usernew[0]->UD_USER_TYPE == "FR") {
$user = Userfinance::where('ufin_user_id', $name)->get();
//print_r($user);exit;
//echo $newval;
if (count($user) > 0) {
foreach ($user as $users) {
# code...
}
if ($users->ufin_icash_balance > $val) {
$arr = array('ufin_icash_balance' => $users->ufin_icash_balance - $val, 'ufin_icash_used' => $users->ufin_icash_used + $val);
$user = Userfinance::where('ufin_user_id', $name)->update($arr);
$comission = array('lr_date' => date('Y-m-d'), 'lr_trans_type' => 'Debited', 'lr_comment' => 'Debited For Icash Transaction', 'lr_debit_amount' => $val, 'lr_post_balance' => $users->ufin_icash_balance - $val, 'lr_created_by' => $name, 'lr_prod_code' => '');
$getlastinseertedcomid = Comission::insertGetId($comission);
$response = array("cardno" => " balance remitted", "status" => "success");
} else {
$response = array("message" => "Balance is low", "status" => "failure");
}
} else {
$response = array("message" => "User not Found", "status" => "failure");
}
} else {
$parentuser = User::where('UD_ID_PK', $usernew[0]->UD_PARENT_ID)->get();
if (count($parentuser) > 0) {
$user = Userfinance::where('ufin_user_id', $parentuser[0]->UD_USER_ID)->get();
//print_r($user);exit;
//echo $newval;
if (count($user) > 0) {
foreach ($user as $users) {
# code...
}
if ($users->ufin_icash_balance > $val) {
$arr = array('ufin_icash_balance' => $users->ufin_icash_balance - $val, 'ufin_icash_used' => $users->ufin_icash_used + $val);
$user = Userfinance::where('ufin_user_id', $parentuser[0]->UD_USER_ID)->update($arr);
$user = Userfinance::where('ufin_user_id', $name)->update($arr);
$comission = array('lr_date' => date('Y-m-d'), 'lr_trans_type' => 'Debited', 'lr_comment' => 'Debited For Icash Transaction', 'lr_debit_amount' => $val, 'lr_post_balance' => $users->ufin_icash_balance - $val, 'lr_created_by' => $name, 'lr_prod_code' => '');
$getlastinseertedcomid = Comission::insertGetId($comission);
$response = array("cardno" => " balance remitted", "status" => "success");
} else {
$response = array("message" => "Balance is low", "status" => "failure");
}
} else {
$response = array("message" => "User Not found", "status" => "failure");
}
} else {
$response = array("message" => "User Not found", "status" => "failure");
}
}
} else {
$response = array("message" => "User not Found", "status" => "failure");
}
return Response::json($response);
}
