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 postUserbalanceadd()
{
$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');
$balancefromuser = Userfinance::where('ufin_user_id', '=', $currentUserId)->get();
$balancetouser = Userfinance::where('ufin_user_id', '=', $userId)->get();
if (count($balancefromuser) > 0) {
foreach ($balancefromuser as $balancefromusers) {
$formuserbalance = $balancefromusers->ufin_main_balance;
$formusercurrenttotalcredited = $balancefromusers->ufin_total_credited;
}
if ($formuserbalance > $amount) {
if (count($balancetouser) > 0) {
foreach ($balancetouser as $balancetouser) {
$btcurrentmainbal = $balancetouser->ufin_main_balance;
$btcurrenttotalcredited = $balancetouser->ufin_total_credited;
}
if ($feePerc > 0) {
$newper = $feePerc / 100;
$finalper = $amount * $newper;
$amount = $amount - $finalper;
} else {
$finalper = $feePerc;
}
$updateuserbalance = array('ufin_main_balance' => $btcurrentmainbal + $amount, 'ufin_total_credited' => $btcurrenttotalcredited + $amount);
Userfinance::where('ufin_user_id', '=', $userId)->update($updateuserbalance);
$newbalupdatecr = 0;
$newbalupdatecr = $formuserbalance - $amount;
$updateuserbalance = array('ufin_main_balance' => $newbalupdatecr);
Userfinance::where('ufin_user_id', '=', $currentUserId)->update($updateuserbalance);
$creditcharge = array('cr_user_id' => $userId, 'cr_type' => 'CR', 'cr_open_bal' => $btcurrentmainbal, 'cr_amount' => $amount, 'cr_fee' => $finalper, 'cr_new_bal' => $btcurrentmainbal + $amount, 'cr_created_by' => $currentUserId, 'cr_created_at' => $currentdate);
$getcurrentuserid = Userfinance::where('ufin_user_id', '=', $currentUserId)->pluck('ufin_main_balance');
$newbalcenaces = 0;
$newbalcenaces = $formuserbalance - $amount;
$ledgercreditdb = array('lr_date' => $currentdate, 'lr_trans_type' => 'DB', 'lr_comment' => 'Balance Transfer', 'lr_debit_amount' => $amount, 'lr_post_balance' => $newbalcenaces, 'lr_created_by' => $currentUserId);
$addnewledger = new Ledgerreport();
$addnewledger->create($ledgercreditdb);
$newbalcenaces1 = 0;
$newbalcenaces1 = $btcurrentmainbal + $amount;
$ledgercreditcr = array('lr_date' => $currentdate, 'lr_trans_type' => 'CR', 'lr_comment' => "Balance Transfer", 'lr_credit_amount' => $amount, 'lr_post_balance' => $newbalcenaces1, 'lr_created_by' => $currentUserId);
$addnewledger = new Ledgerreport();
$addnewledger->create($ledgercreditcr);
$creditchargeinsert = new Usercreditrecharge();
$creditchargeinsert->create($creditcharge);
return Response::json(array('status' => 'success', 'message' => 'User Credit Added Successfully'));
} else {
return Response::json(array('status' => 'failure', 'message' => 'No User With This ID'));
}
} else {
return Response::json(array('status' => 'failure', 'message' => 'You do not have sufficient balance to transfer the amount'));
}
}
} else {
return Response::json(array('status' => 'failure', 'message' => 'Fill All Manditary Fields'));
}
}
