public static function get_db($filter_group, $filter_value)
{
if ($filter_group == 1) {
$paymant = Payment::where('user_id', '=', $filter_value)->where('pay_amt', '!=', 0)->whereNotNull('pay_amt')->get();
$office_salary = office_salary::where('user_id', '=', $filter_value)->where('pay_amt', '!=', 0)->whereNotNull('pay_amt')->get();
} else {
if ($filter_value == 3) {
$paymant = Payment::where('pay_amt', '!=', 0)->whereNotNull('pay_amt')->orderBy('user_id')->get();
$office_salary = office_salary::where('pay_amt', '!=', 0)->whereNotNull('pay_amt')->orderBy('user_id')->get();
} else {
$paymant = Payment::where('pay_status', '=', $filter_value)->where('pay_amt', '!=', 0)->whereNotNull('pay_amt')->orderBy('user_id')->get();
$office_salary = office_salary::where('pay_status', '=', $filter_value)->where('pay_amt', '!=', 0)->whereNotNull('pay_amt')->orderBy('user_id')->get();
}
}
if (isset($paymant) && $paymant) {
$return_data = [];
foreach ($paymant as $record) {
$return_data[] = ['id' => $record->id, 'user_id' => $record->user_id, 'user_name' => $record->user->nickname . " - " . $record->user->name . " " . $record->user->surname, 'event_id' => $record->event_id, 'event_name' => $record->event->event_name, 'pay_amt' => $record->pay_amt, 'pay_status' => $record->pay_status, 'note' => $record->note, 'db' => 'assignment'];
}
foreach ($office_salary as $record) {
$return_data[] = ['id' => $record->id, 'user_id' => $record->user_id, 'user_name' => $record->user->nickname . " - " . $record->user->name . " " . $record->user->surname, 'event_id' => 0, 'event_name' => $record->pay_name, 'pay_amt' => $record->pay_amt, 'pay_status' => $record->pay_status, 'note' => $record->note, 'db' => 'office_salary'];
}
return $return_data;
}
}
public static function get_filter_data()
{
$filter_group = Request::input('filter_group');
if ($filter_group == 1) {
$splite_user_id = explode(" ", Request::input('filter_value'));
$user_id = str_replace("]", "", str_replace("[", "", $splite_user_id[0]));
$office_salary = office_salary::where('user_id', '=', $user_id)->get();
} else {
$filter_status = Request::input('filter_value');
$office_salary = office_salary::where('pay_status', '=', $filter_status)->get();
}
if (count($office_salary) > 0) {
foreach ($office_salary as $record) {
$fullname = $record->user->nickname . " - " . $record->user->name . " " . $record->user->surname;
$data[] = ["id" => $record->id, "pay_name" => $record->pay_name, "pay_amt" => $record->pay_amt, "note" => $record->note, "name" => $fullname];
}
} else {
$data = [];
}
echo office_payment::generate_html($data);
}
public static function Update_Status()
{
$assignstatus = Request::input('asst');
$officestatus = Request::input('ofst');
if (!empty(Request::input('removepay_select'))) {
$removepay_select = explode(",", Request::input('removepay_select'));
foreach ($removepay_select as $record) {
if (!empty($record)) {
$Payupdate = AssignmentDB::where('id', '=', $record)->first();
$Payupdate->pay_status = 0;
$Payupdate->save();
}
}
}
if (!empty(Request::input('removeoffice_select'))) {
$removepay_select = explode(",", Request::input('removeoffice_select'));
foreach ($removepay_select as $record) {
if (!empty($record)) {
$officeupdate = office_salary::where('id', '=', $record)->first();
$officeupdate->pay_status = 0;
$officeupdate->save();
}
}
}
if (isset($assignstatus)) {
$assign_id_select = array_keys($assignstatus);
foreach ($assign_id_select as $record) {
$Payupdate = AssignmentDB::where('id', '=', $record)->first();
$Payupdate->pay_status = 2;
$Payupdate->save();
}
}
if (isset($officestatus)) {
$office_id_status = array_keys($officestatus);
foreach ($office_id_status as $record) {
$officeupdate = office_salary::where('id', '=', $record)->first();
$officeupdate->pay_status = 2;
$officeupdate->save();
}
}
}