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 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 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 getBalance($balance)
{
$update = Userfinance::where('ufin_user_id_pk_fk', 1)->update(array('ufin_icash_balance' => $balance));
}
public function postUpdatelockbalance()
{
$postdata = file_get_contents("php://input");
if (!empty($postdata)) {
$currentdate = Commonmodel::dateandtime();
$userIdPk = Input::get('userIdPk');
$userId = Input::get('userId');
$currentUserId = Input::get('currentUserId');
$currentUserIdPk = Input::get('currentUserIdPk');
$parentId = Input::get('parentId');
$parentIdPk = Input::get('parentIdPk');
$clientIP = Input::get('clientIP');
$amount = Input::get('amount');
$feePerc = Input::get('feePerc');
$currentbalance = Userfinance::where('ufin_user_id', '=', $userId)->pluck('ufin_main_balance');
$lockbalance = Userfinance::where('ufin_user_id', '=', $userId)->pluck('ufin_lock_balance');
if ($currentbalance > $lockbalance) {
if ($amount < $currentbalance) {
$balanceupdt = array('ufin_lock_balance' => $amount);
Userfinance::where('ufin_user_id', '=', $userId)->update($balanceupdt);
return Response::json(array('status' => 'success', 'message' => 'Your Lock Balance Updated Successfully'));
} else {
return Response::json(array('status' => 'failure', 'message' => 'Yor main balance is too low . Your Lock balance cannot be updated'));
}
} else {
return Response::json(array('status' => 'failure', 'message' => 'Yor main balance is too low . Your Lock balance cannot be updated'));
}
} else {
return Response::json(array('status' => 'failure', 'message' => 'Fill All Manditary Fields'));
}
}
public function postDashboard()
{
$userID = Input::get('created_by');
$userIDPK = Input::get('userIDPK');
$userRole = User::where('UD_USER_ID', '=', $userID)->get();
foreach ($userRole as $ur) {
$userType = $ur->UD_USER_TYPE;
}
if ($userType == "SA" || $userType == "SAS") {
$successRecAmount = 0;
$failureRecAmount = 0;
$startDate = date('Y-m-d') . " 00:00:00";
$endDate = date('Y-m-d') . " 23:59:59";
//recharge stats
$successRechargeRecords = Ledgerreport::where('lr_comment', '=', 'Recharge')->where('lr_status', '=', 'success')->whereBetween('lr_date', array($startDate, $endDate))->get();
foreach ($successRechargeRecords as $srr) {
$successRecAmount = $successRecAmount + $srr->lr_debit_amount;
}
$failureRechargeRecords = Ledgerreport::where('lr_comment', '=', 'Recharge')->where('lr_status', '=', 'failure')->whereBetween('lr_date', array($startDate, $endDate))->get();
foreach ($failureRechargeRecords as $srr) {
$failureRecAmount = $failureRecAmount + $srr->lr_debit_amount;
}
//icash balance
$icashBalance = Userfinance::where('ufin_user_id', '=', $userID)->get();
$icashBal = 0;
foreach ($icashBalance as $bal) {
$icashBal = $icashBal + $bal->ufin_icash_balance;
}
//User count
$SA = count(User::where('UD_USER_TYPE', '=', 'SA')->get());
$SAS = count(User::where('UD_USER_TYPE', '=', 'SAS')->get());
$SP = count(User::where('UD_USER_TYPE', '=', 'SP')->get());
$SPS = count(User::where('UD_USER_TYPE', '=', 'SPS')->get());
$SD = count(User::where('UD_USER_TYPE', '=', 'SD')->get());
$SDS = count(User::where('UD_USER_TYPE', '=', 'SDS')->get());
$D = count(User::where('UD_USER_TYPE', '=', 'D')->get());
$DS = count(User::where('UD_USER_TYPE', '=', 'DS')->get());
$FR = count(User::where('UD_USER_TYPE', '=', 'FR')->get());
$FRS = count(User::where('UD_USER_TYPE', '=', 'FRS')->get());
$SFR = count(User::where('UD_USER_TYPE', '=', 'SFR')->get());
$SFRS = count(User::where('UD_USER_TYPE', '=', 'SFRS')->get());
//User Balance
$SAbalance = Commonmodel::fetchUserdetails('SA');
$SASbalance = Commonmodel::fetchUserdetails('SAS');
$SPbalance = Commonmodel::fetchUserdetails('SP');
$SPSbalance = Commonmodel::fetchUserdetails('SPS');
$SDbalance = Commonmodel::fetchUserdetails('SD');
$SDSbalance = Commonmodel::fetchUserdetails('SDS');
$Dbalance = Commonmodel::fetchUserdetails('D');
$DSbalance = Commonmodel::fetchUserdetails('DS');
$FRbalance = Commonmodel::fetchUserdetails('FR');
$FRSbalance = Commonmodel::fetchUserdetails('FRS');
$SFRbalance = Commonmodel::fetchUserdetails('SFR');
$SFRSbalance = Commonmodel::fetchUserdetails('SFRS');
//Ezypay
$getbalance = Rechargeurl::balance();
$ezbalance = $getbalance[0];
$output = array('Success_Recharge_Amount' => $successRecAmount, 'Failure_Recharge_Amount' => $failureRecAmount, 'SA' => $SA, 'SAS' => $SAS, 'SP' => $SP, 'SPS' => $SPS, 'SD' => $SD, 'SDS' => $SDS, 'D' => $D, 'DS' => $DS, 'FR' => $FR, 'FRS' => $FRS, 'SFR' => $SFR, 'SFRS' => $SFRS, 'Ezpay_Balance' => $ezbalance, 'icash_Balance' => $icashBal, 'SA_Balance' => $SAbalance, 'SAS_Balance' => $SASbalance, 'SP_Balance' => $SPbalance, 'SPS_Balance' => $SPSbalance, 'SD_Balance' => $SDbalance, 'SDS_Balance' => $SDSbalance, 'D_Balance' => $Dbalance, 'DS_Balance' => $DSbalance, 'FR_Balance' => $FRbalance, 'FRS_Balance' => $FRSbalance, 'SFR_Balance' => $SFRbalance, 'SFRS_Balance' => $SFRSbalance);
} elseif ($userType == "SP") {
$SPbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_details.UD_PARENT_ID', '=', $userIDPK)->get();
$spartBalance = 0;
if ($SPbalance) {
foreach ($SPbalance as $sp) {
$spaBalance = $sp->ufin_main_balance;
}
$Daccounts = count(User::where('UD_PARENT_ID', '=', $userIDPK)->get());
$SDbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_details.UD_PARENT_ID', '=', $userIDPK)->get();
$FRtotalregamount = Commonmodel::fetchRechargedetails($userID);
$disbal = 0;
if ($SDbalance) {
foreach ($SDbalance as $frs) {
$disbal = $disbal + $frs->ufin_main_balance;
}
$output = array('Statepartner_Balance' => $spaBalance, 'Distributor_accounts' => $Daccounts, 'Distributor_balance' => $disbal);
} else {
$output = array('Statepartner_Balance' => $spaBalance, 'Distributor_accounts' => $Daccounts, 'Distributor_balance' => '0');
}
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} elseif ($userType == "SPS") {
$SPbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_details.UD_ID_PK', '=', $userIDPK)->get();
$spartBalance = 0;
if ($SPbalance) {
foreach ($SPbalance as $sp) {
$spaBalance = $sp->ufin_main_balance;
$parentid = $sp->UD_PARENT_ID;
}
$Daccounts = count(User::where('UD_PARENT_ID', '=', $parentid)->get());
$SDbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_finance.ufin_user_id_pk_fk', '=', $parentid)->get();
$disbal = 0;
if ($SDbalance) {
foreach ($SDbalance as $frs) {
$disbal = $disbal + $frs->ufin_main_balance;
}
$output = array('Statepartner_Balance' => $spaBalance, 'Distributor_accounts' => $Daccounts, 'Distributor_balance' => $disbal);
} else {
$output = array('Statepartner_Balance' => $spaBalance, 'Distributor_accounts' => $Daccounts, 'Distributor_balance' => '0');
}
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} elseif ($userType == "SD") {
$SDbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_details.UD_USER_ID', '=', $userID)->get();
$sdiBalance = 0;
if ($SDbalance) {
foreach ($SDbalance as $sp) {
$sdiBalance = $sp->ufin_main_balance;
}
$Daccounts = count(User::where('UD_PARENT_ID', '=', $userIDPK)->get());
$Disbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_details.UD_PARENT_ID', '=', $userIDPK)->get();
$FRtotalregamount = Commonmodel::fetchRechargedetails($userID);
$disbal = 0;
if ($Disbalance) {
foreach ($Disbalance as $frs) {
$disbal = $disbal + $frs->ufin_main_balance;
}
$output = array('Super_Distributer_Balance' => $sdiBalance, 'Distributor_accounts' => $Daccounts, 'Distributor_balance' => $disbal);
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} elseif ($userType == "SDS") {
$SDbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_details.UD_USER_ID', '=', $userID)->get();
$sdiBalance = 0;
if ($SDbalance) {
foreach ($SDbalance as $sp) {
$sdiBalance = $sp->ufin_main_balance;
$parentid = $sp->UD_PARENT_ID;
}
$Daccounts = count(User::where('UD_PARENT_ID', '=', $parentid)->get());
$Disbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_finance.ufin_user_id_pk_fk', '=', $parentid)->get();
$FRtotalregamount = Commonmodel::fetchRechargedetails($userID);
$disbal = 0;
if ($Disbalance) {
foreach ($Disbalance as $frs) {
$disbal = $disbal + $frs->ufin_main_balance;
}
$output = array('Super_Distributer_Balance' => $sdiBalance, 'Distributor_accounts' => $Daccounts, 'Distributor_balance' => $disbal);
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} elseif ($userType == "D") {
$SDbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_details.UD_USER_ID', '=', $userID)->get();
$sdiBalance = 0;
if ($SDbalance) {
foreach ($SDbalance as $sp) {
$sdiBalance = $sp->ufin_main_balance;
}
$Daccounts = count(User::where('UD_PARENT_ID', '=', $userIDPK)->get());
$Disbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_details.UD_PARENT_ID', '=', $userIDPK)->get();
$FRtotalregamount = Commonmodel::fetchRechargedetails($userID);
$disbal = 0;
if ($Disbalance) {
foreach ($Disbalance as $frs) {
$disbal = $disbal + $frs->ufin_main_balance;
}
$output = array('Distributer_Balance' => $sdiBalance, 'Franchise_accounts' => $Daccounts, 'Franchise_balance' => $disbal);
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} elseif ($userType == "DS") {
$SDbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_details.UD_USER_ID', '=', $userID)->get();
$sdiBalance = 0;
if ($SDbalance) {
foreach ($SDbalance as $sp) {
$sdiBalance = $sp->ufin_main_balance;
$parentid = $sp->UD_PARENT_ID;
}
$Daccounts = count(User::where('UD_PARENT_ID', '=', $parentid)->get());
$Disbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_finance.ufin_user_id', '=', $parentid)->get();
$FRtotalregamount = Commonmodel::fetchRechargedetails($userID);
$disbal = 0;
if ($Disbalance) {
foreach ($Disbalance as $frs) {
$disbal = $disbal + $frs->ufin_main_balance;
}
$output = array('Distributer_Balance' => $sdiBalance, 'Franchise_accounts' => $Daccounts, 'Franchise_balance' => $disbal);
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} elseif ($userType == "FR") {
$FRbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_details.UD_USER_ID', '=', $userID)->get();
$fraBalance = 0;
if ($FRbalance) {
foreach ($FRbalance as $fr) {
$fraBalance = $fr->ufin_main_balance;
$icashBalance = $fr->ufin_icash_balance;
}
$FRSaccounts = count(User::where('UD_PARENT_ID', '=', $userIDPK)->get());
$SFRbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_finance.ufin_user_id', '=', $userID)->get();
$FRtotalregamount = Commonmodel::fetchRechargedetails($userID);
$sfrbal = 0;
if ($FRbalance) {
foreach ($SFRbalance as $frs) {
$sfrbal = $sfrbal + $frs->ufin_main_balance;
}
$output = array('Franchise_Balance' => $fraBalance, 'icash_Balance' => $icashBalance, 'Sub_franchise_accounts' => $FRSaccounts, 'Sub_franchise_balance' => $sfrbal, 'Total_recharge_amount' => $FRtotalregamount);
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} elseif ($userType == "FRS") {
$FRbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_details.UD_USER_ID', '=', $userID)->get();
$fraBalance = 0;
if ($FRbalance) {
foreach ($FRbalance as $fr) {
$fraBalance = $fr->ufin_main_balance;
$icashBalance = $fr->ufin_icash_balance;
$parentid = $fr->UD_PARENT_ID;
}
$FRSaccounts = count(User::where('UD_PARENT_ID', '=', $parentid)->get());
$SFRbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_finance.ufin_user_id', '=', $parentid)->get();
$FRtotalregamount = Commonmodel::fetchRechargedetails($userID);
$sfrbal = 0;
if ($SFRbalance) {
foreach ($SFRbalance as $frs) {
$sfrbal = $sfrbal + $frs->ufin_main_balance;
}
$output = array('Franchise_Balance' => $fraBalance, 'icash_Balance' => $icashBalance, 'Sub_franchise_accounts' => $FRSaccounts, 'Sub_franchise_balance' => $sfrbal, 'Total_recharge_amount' => $FRtotalregamount);
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} elseif ($userType == "SFR") {
$FRbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_details.UD_USER_ID', '=', $userID)->get();
$fraBalance = 0;
if ($FRbalance) {
$FRtotalregamount = Commonmodel::fetchRechargedetails($userID);
foreach ($FRbalance as $fr) {
$fraBalance = $fr->ufin_main_balance;
$icashBalance = $fr->ufin_icash_balance;
}
$output = array('Franchise_Balance' => $fraBalance, 'icash_Balance' => $icashBalance, 'Total_recharge_amount' => $FRtotalregamount);
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} elseif ($userType == "SFRS") {
$FRbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_details.UD_USER_ID', '=', $userID)->get();
$fraBalance = 0;
if ($FRbalance) {
foreach ($FRbalance as $fr) {
$fraBalance = $fr->ufin_main_balance;
$icashBalance = $fr->ufin_icash_balance;
$parentid = $fr->UD_PARENT_ID;
}
$parentIDname = User::where('UD_ID_PK', '=', $parentid)->get();
foreach ($parentIDname as $prntname) {
$parent_name = $prntname->UD_USER_ID;
}
$SFRbalance = DB::table('adt_user_finance')->leftjoin('adt_user_details', 'adt_user_finance.ufin_user_id', '=', 'adt_user_details.UD_USER_ID')->where('adt_user_finance.ufin_user_id_pk_fk', '=', $parentid)->get();
$FRtotalregamount = Commonmodel::fetchRechargedetails($parent_name);
$sfrbal = 0;
if ($SFRbalance) {
foreach ($SFRbalance as $frs) {
$sfrbal = $sfrbal + $frs->ufin_main_balance;
}
$output = array('Franchise_Balance' => $sfrbal, 'icash_Balance' => $icashBalance, 'Total_recharge_amount' => $FRtotalregamount);
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
}
return Response::json($output);
}
