public function postUsercommission()
{
$userid = Input::get('userid');
$userRole = User::where('UD_ID_PK', '=', $userid)->get();
foreach ($userRole as $ur) {
$userType = $ur->UD_USER_TYPE;
}
if ($userType == 'FR' || $userType == 'FRS') {
$rechagedate = DB::table('adt_recharge_ledger')->leftjoin('adt_ledger_report', 'adt_recharge_ledger.rchlgr_lr_id', '=', 'adt_ledger_report.lr_id_pk')->select('adt_ledger_report.lr_date', 'adt_ledger_report.lr_debit_amount')->where('adt_recharge_ledger.rchlgr_fr_id', '=', $userid)->get();
foreach ($rechagedate as $rd) {
$rg_strdate[] = Commonmodel::timeconversion($rd->lr_date);
}
$rcgDate = array_unique($rg_strdate);
if (count($rcgDate) > 0) {
foreach ($rcgDate as $rc) {
$rg_strdate = Commonmodel::timeconversion($rc) . " 00:00:00";
$rg_enddate = Commonmodel::timeconversion($rc) . " 23:59:59";
$dailyCommission = DB::table('adt_recharge_ledger')->leftjoin('adt_ledger_report', 'adt_recharge_ledger.rchlgr_lr_id', '=', 'adt_ledger_report.lr_id_pk')->whereBetween('adt_recharge_ledger.rchlgr_date', array($rg_strdate, $rg_enddate))->get();
$rgamount = 0;
$frcommision = 0;
$date = 0;
foreach ($dailyCommission as $ds) {
$rgamount = $rgamount + $ds->lr_debit_amount;
$frcommision = $frcommision + $ds->rchlgr_fr_commission;
$date = Commonmodel::timeconversion($ds->rchlgr_date);
}
$output[] = array('Date' => $date, 'Success' => $rgamount, 'Commission' => $frcommision);
}
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} elseif ($userType == 'SFR' || $userType == 'SFRS') {
$rechagedate = DB::table('adt_recharge_ledger')->leftjoin('adt_ledger_report', 'adt_recharge_ledger.rchlgr_lr_id', '=', 'adt_ledger_report.lr_id_pk')->select('adt_ledger_report.lr_date', 'adt_ledger_report.lr_debit_amount')->where('adt_recharge_ledger.rchlgr_sfr_id', '=', $userid)->get();
foreach ($rechagedate as $rd) {
$rg_strdate[] = Commonmodel::timeconversion($rd->lr_date);
}
$rcgDate = array_unique($rg_strdate);
if (count($rcgDate) > 0) {
foreach ($rcgDate as $rc) {
$rg_strdate = Commonmodel::timeconversion($rc) . " 00:00:00";
$rg_enddate = Commonmodel::timeconversion($rc) . " 23:59:59";
$dailyCommission = DB::table('adt_recharge_ledger')->leftjoin('adt_ledger_report', 'adt_recharge_ledger.rchlgr_lr_id', '=', 'adt_ledger_report.lr_id_pk')->whereBetween('adt_recharge_ledger.rchlgr_date', array($rg_strdate, $rg_enddate))->get();
$rgamount = 0;
$frcommision = 0;
$date = 0;
foreach ($dailyCommission as $ds) {
$rgamount = $rgamount + $ds->lr_debit_amount;
$frcommision = $frcommision + $ds->rchlgr_sfr_commission;
$date = Commonmodel::timeconversion($ds->rchlgr_date);
}
$output[] = array('Date' => $date, 'Success' => $rgamount, 'Commission' => $frcommision);
}
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} elseif ($userType == 'SD' || $userType == 'SDS') {
$rechagedate = DB::table('adt_recharge_ledger')->leftjoin('adt_ledger_report', 'adt_recharge_ledger.rchlgr_lr_id', '=', 'adt_ledger_report.lr_id_pk')->select('adt_ledger_report.lr_date', 'adt_ledger_report.lr_debit_amount')->where('adt_recharge_ledger.rchlgr_sd_id', '=', $userid)->get();
foreach ($rechagedate as $rd) {
$rg_strdate[] = Commonmodel::timeconversion($rd->lr_date);
}
$rcgDate = array_unique($rg_strdate);
if (count($rcgDate) > 0) {
foreach ($rcgDate as $rc) {
$rg_strdate = Commonmodel::timeconversion($rc) . " 00:00:00";
$rg_enddate = Commonmodel::timeconversion($rc) . " 23:59:59";
$dailyCommission = DB::table('adt_recharge_ledger')->leftjoin('adt_ledger_report', 'adt_recharge_ledger.rchlgr_lr_id', '=', 'adt_ledger_report.lr_id_pk')->whereBetween('adt_recharge_ledger.rchlgr_date', array($rg_strdate, $rg_enddate))->get();
$rgamount = 0;
$frcommision = 0;
$date = 0;
foreach ($dailyCommission as $ds) {
$rgamount = $rgamount + $ds->lr_debit_amount;
$frcommision = $frcommision + $ds->rchlgr_sd_commission;
$date = Commonmodel::timeconversion($ds->rchlgr_date);
}
$output[] = array('Date' => $date, 'Success' => $rgamount, 'Commission' => $frcommision);
}
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} elseif ($userType == 'D' || $userType == 'DS') {
$rechagedate = DB::table('adt_recharge_ledger')->leftjoin('adt_ledger_report', 'adt_recharge_ledger.rchlgr_lr_id', '=', 'adt_ledger_report.lr_id_pk')->select('adt_ledger_report.lr_date', 'adt_ledger_report.lr_debit_amount')->where('adt_recharge_ledger.rchlgr_d_id', '=', $userid)->get();
foreach ($rechagedate as $rd) {
$rg_strdate[] = Commonmodel::timeconversion($rd->lr_date);
}
$rcgDate = array_unique($rg_strdate);
if (count($rcgDate) > 0) {
foreach ($rcgDate as $rc) {
$rg_strdate = Commonmodel::timeconversion($rc) . " 00:00:00";
$rg_enddate = Commonmodel::timeconversion($rc) . " 23:59:59";
$dailyCommission = DB::table('adt_recharge_ledger')->leftjoin('adt_ledger_report', 'adt_recharge_ledger.rchlgr_lr_id', '=', 'adt_ledger_report.lr_id_pk')->whereBetween('adt_recharge_ledger.rchlgr_date', array($rg_strdate, $rg_enddate))->get();
$rgamount = 0;
$frcommision = 0;
$date = 0;
foreach ($dailyCommission as $ds) {
$rgamount = $rgamount + $ds->lr_debit_amount;
$frcommision = $frcommision + $ds->rchlgr_d_commission;
$date = Commonmodel::timeconversion($ds->rchlgr_date);
}
$output[] = array('Date' => $date, 'Success' => $rgamount, 'Commission' => $frcommision);
}
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} elseif ($userType == 'SP' || $userType == 'SPS') {
$rechagedate = DB::table('adt_recharge_ledger')->leftjoin('adt_ledger_report', 'adt_recharge_ledger.rchlgr_lr_id', '=', 'adt_ledger_report.lr_id_pk')->select('adt_ledger_report.lr_date', 'adt_ledger_report.lr_debit_amount')->where('adt_recharge_ledger.rchlgr_sp_id', '=', $userid)->get();
foreach ($rechagedate as $rd) {
$rg_strdate[] = Commonmodel::timeconversion($rd->lr_date);
}
$rcgDate = array_unique($rg_strdate);
if (count($rcgDate) > 0) {
foreach ($rcgDate as $rc) {
$rg_strdate = Commonmodel::timeconversion($rc) . " 00:00:00";
$rg_enddate = Commonmodel::timeconversion($rc) . " 23:59:59";
$dailyCommission = DB::table('adt_recharge_ledger')->leftjoin('adt_ledger_report', 'adt_recharge_ledger.rchlgr_lr_id', '=', 'adt_ledger_report.lr_id_pk')->whereBetween('adt_recharge_ledger.rchlgr_date', array($rg_strdate, $rg_enddate))->get();
$rgamount = 0;
$frcommision = 0;
$date = 0;
foreach ($dailyCommission as $ds) {
$rgamount = $rgamount + $ds->lr_debit_amount;
$frcommision = $frcommision + $ds->rchlgr_sp_commission;
$date = Commonmodel::timeconversion($ds->rchlgr_date);
}
$output[] = array('Date' => $date, 'Success' => $rgamount, 'Commission' => $frcommision);
}
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
} elseif ($userType == 'SA' || $userType == 'SAS') {
$rechagedate = DB::table('adt_recharge_ledger')->leftjoin('adt_ledger_report', 'adt_recharge_ledger.rchlgr_lr_id', '=', 'adt_ledger_report.lr_id_pk')->select('adt_ledger_report.lr_date', 'adt_ledger_report.lr_debit_amount')->get();
foreach ($rechagedate as $rd) {
$rg_strdate[] = Commonmodel::timeconversion($rd->lr_date);
}
$rcgDate = array_unique($rg_strdate);
if (count($rcgDate) > 0) {
foreach ($rcgDate as $rc) {
$rg_strdate = Commonmodel::timeconversion($rc) . " 00:00:00";
$rg_enddate = Commonmodel::timeconversion($rc) . " 23:59:59";
$dailyCommission = DB::table('adt_recharge_ledger')->leftjoin('adt_ledger_report', 'adt_recharge_ledger.rchlgr_lr_id', '=', 'adt_ledger_report.lr_id_pk')->whereBetween('adt_recharge_ledger.rchlgr_date', array($rg_strdate, $rg_enddate))->get();
$rgamount = 0;
$frcommision = 0;
$drcommission = 0;
$date = 0;
foreach ($dailyCommission as $ds) {
$rgamount = $rgamount + $ds->lr_debit_amount;
$frcommision = $frcommision + $ds->rchlgr_fr_commission;
$drcommission = $drcommission + $ds->rchlgr_d_commission;
$date = Commonmodel::timeconversion($ds->rchlgr_date);
}
$output[] = array('Date' => $date, 'Success' => $rgamount, 'FRC_Commission' => $frcommision, 'DIS_Commission' => $drcommission);
}
} else {
$output = array('status' => 'failure', 'message' => 'No results found');
}
}
return Response::json($output);
}
