JFIFxxC      C  " }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3RbrPK0ZqfJJHolidayExport.phpnu[creatorId())->get(); foreach($data as $k=>$holidays) { $data[$k]["created_by"]=Employee::login_user($holidays->created_by); unset($holidays->created_at,$holidays->updated_at); } return $data; } public function headings(): array { return [ "ID", "Start Date", "End Date", "Occasion", "Created By" ]; } } PK0Z[h LeaveReportExport.phpnu[creatorId())->get(); $employees = Employee::where('created_by', \Auth::user()->creatorId())->get(); // $employees = $employees->get(); foreach ($employees as $employee) { $approved = Leave::where('employee_id', $employee->id)->where('status', 'Approved'); $reject = Leave::where('employee_id', $employee->id)->where('status', 'Reject'); $pending = Leave::where('employee_id', $employee->id)->where('status', 'Pending'); $totalApproved = $totalReject = $totalPending = 0; $approved = $approved->count(); $reject = $reject->count(); $pending = $pending->count(); $totalApproved += $approved; $totalReject += $reject; $totalPending += $pending; $employeeLeave['approved'] = $approved; $employeeLeave['reject'] = $reject; $employeeLeave['pending'] = $pending; $leaves[] = $employeeLeave; } foreach ($data as $k => $leave) { $user_id = $leave->employees->user_id; // $user_id = $leave->employees != null ? $leave->employees->user_id : 0; $user = User::where('id', $user_id)->first(); $data[$k]["employee_id"] = !empty($leave->employees) ? User::employeeIdFormat($leave->employees->employee_id) : ''; $data[$k]["employee"] = (!empty($leave->employees->name)) ? $leave->employees->name : ''; $data[$k]["approved_leaves"] = $leaves[$k]['approved'] == 0 ? '0' : $leaves[$k]['approved']; $data[$k]["rejected_leaves"] = $leaves[$k]['reject'] == 0 ? '0' : $leaves[$k]['reject']; $data[$k]["pending_leaves"] = $leaves[$k]['pending'] == 0 ? '0' : $leaves[$k]['pending']; unset($data[$k]['id'], $data[$k]['leave_type_id'], $data[$k]['start_date'], $data[$k]['end_date'], $data[$k]['applied_on'], $data[$k]['total_leave_days'], $data[$k]['leave_reason'], $data[$k]['created_at'], $data[$k]['created_by'], $data[$k]['remark'], $data[$k]['status'], $data[$k]['updated_at'], $data[$k]['account_id']); } return $data; } public function headings(): array { return [ "Employee ID", "Employee", "Approved Leaves ", "Rejected Leaves", "Pending Leaves", ]; } } PK0ZZ? PayslipExport.phpnu[data = $data; } public function collection() { $request=$this->data; $data = PaySlip::where('created_by', \Auth::user()->creatorId()); if(isset($request->filter_month) && !empty($request->filter_month)){ $month=$request->filter_month; }else{ $month=date('m', strtotime('last month')); } if(isset($request->filter_year) && !empty($request->filter_year)){ $year=$request->filter_year; }else{ $year=date('Y'); } $formate_month_year = $year . '-' . $month; $data->where('salary_month', '=', $formate_month_year); $data=$data->get(); $result = array(); foreach($data as $k => $payslip) { $result[] = array( 'employee_id'=> !empty($payslip->employees) ? \Auth::user()->employeeIdFormat($payslip->employees->employee_id) : '', 'employee_name' => (!empty($payslip->employees)) ? $payslip->employees->name : '', 'basic_salary' => \Auth::user()->priceFormat($payslip->basic_salary), 'net_salary' => \Auth::user()->priceFormat($payslip->net_payble), 'status' => $payslip->status == 0 ? 'UnPaid' : 'Paid', 'account_holder_name' => (!empty($payslip->employees)) ? $payslip->employees->account_holder_name : '', 'account_number' => (!empty($payslip->employees)) ? $payslip->employees->account_number : '', 'bank_name' => (!empty($payslip->employees)) ? $payslip->employees->bank_name : '', 'bank_identifier_code' => (!empty($payslip->employees)) ? $payslip->employees->bank_identifier_code : '', 'branch_location' => (!empty($payslip->employees)) ? $payslip->employees->branch_location : '', 'tax_payer_id' => (!empty($payslip->employees)) ? $payslip->employees->tax_payer_id : '', ); } return collect($result); } public function headings(): array { return [ "EMP ID", "Name", // "Payroll Type", "Salary", "Net Salary", "Status", "Account Holder Name", "Account Number", "Bank Name", "Bank Identifier Code", "Branch Location", "Tax Payer Id", ]; } } PK0Zþ~~accountstatementExport.phpnu[creatorId())->get(); foreach ($data as $k => $account) { $account["account_name"] = !empty($account->accounts) ? $account->accounts->account_name : ''; $account["date"] = \Auth::user()->dateFormat($account->date); $account["amount"] = \Auth::user()->priceFormat($account->amount); unset($account->id, $account->income_category_id, $account->payer_id, $account->payment_type_id, $account->referal_id, $account->description, $account->created_by, $account->created_at, $account->updated_at,$account->account_id); } return $data; } public function headings(): array { return [ "Amount", "Date", "Account Name", ]; } } PK0Zz8OEventExport.phpnu[creatorId())->get(); foreach ($data as $k => $events) { $data[$k]["branch_id"] = Branch::where('id',$events->branch_id)->pluck('name')->first(); } return $data; } public function headings(): array { return [ "ID", "Branch Id", "Department Id", "Employee Id", "Title", "Start Date", "End Date", "Color", "Description", "Created By", "Created At", "Updated At", ]; } } PK0Z)$TrainerExport.phpnu[creatorId())->get(); foreach($data as $k=>$trainer) { $data[$k]["branch"]=!empty($trainer->branches)?$trainer->branches->name:''; $data[$k]["created_by"]=Employee::login_user($trainer->created_by); unset($trainer->created_at,$trainer->updated_at); } return $data; } public function headings(): array { return [ "ID", "Branch Name", "First Name", "Last Name", "Contact", "Email ID", "Address", "Experience", "Created By" ]; } } PK0ZDepositExport.phpnu[creatorId())->get(); foreach($data as $k=>$deposit) { $data[$k]["account_id"]= !empty($deposit->account($deposit->account_id))?$deposit->account($deposit->account_id)->account_name:''; $data[$k]["income_category_id"]=!empty($deposit->income_category($deposit->income_category_id))?$deposit->income_category($deposit->income_category_id)->name:''; $data[$k]["payer_id"]= Deposit::payer($deposit->payer_id)->payer_name; $data[$k]["payment_type_id"]=!empty($deposit->payment_type($deposit->payment_type_id))?$deposit->payment_type($deposit->payment_type_id)->name:''; $data[$k]["created_by"]=Employee::login_user($deposit->created_by); unset($deposit->created_at,$deposit->updated_at); } return $data; } public function headings(): array { return [ "ID", "Account Name", "Amount", "Date", "Income Category", "Payer", "Payment type", "Referal Id", "Description", "Created By" ]; } } PK0Z9  PayrollExport.phpnu[month = $data['month']; $this->branch = $data['branch']; $this->department = $data['department']; } public function collection() { // $data = PaySlip::select('pay_slips.*', 'employees.name')->leftjoin('employees', 'pay_slips.employee_id', '=', 'employees.id')->where('pay_slips.created_by', \Auth::user()->creatorId())->get(); $data = PaySlip::select('pay_slips.*', 'employees.name')->leftJoin('employees', 'pay_slips.employee_id', '=', 'employees.id')->where('pay_slips.created_by', \Auth::user()->creatorId())->where('employees.branch_id', $this->branch)->where('employees.department_id', $this->department); $month = date('Y-m'); $data->where('salary_month', $this->month); $filterYear['dateYearRange'] = date('M-Y', strtotime($month)); $filterYear['type'] = __('Monthly'); $data = $data->get(); foreach ($data as $k => $payslip) { $payslip["employee_id"] = !empty($payslip->employees) ? \Auth::user()->employeeIdFormat($payslip->employees->employee_id) : ''; $payslip["employee_name"] = (!empty($payslip->name)) ? $payslip->name : ''; $payslip["salary"] = \Auth::user()->priceFormat($payslip->basic_salary); $payslip["net_salary"] = \Auth::user()->priceFormat($payslip->net_payble); $payslip["month"] = $payslip->salary_month; $payslip["status"] = $payslip->status == 0 ? 'UnPaid' : 'Paid'; unset($payslip->created_at, $payslip->updated_at, $payslip->allowance, $payslip->commission, $payslip->loan, $payslip->saturation_deduction, $payslip->other_payment, $payslip->overtime, $payslip->saturation_deduction, $payslip->created_by, $payslip->id, $payslip->name, $payslip->net_payble, $payslip->basic_salary, $payslip->salary_month); } return $data; } public function headings(): array { return [ "Employee Id", "Status", "Employee Name", "Salary", "Net Salary", "Month", ]; } } PK0Z+ExpenseExport.phpnu[creatorId())->get(); foreach($data as $k=>$expense) { $data[$k]["account_id"]=!empty($expense->account($expense->account_id))?$expense->account($expense->account_id)->account_name:''; $data[$k]["expense_category_id"]= !empty($expense->expense_category($expense->expense_category_id))?$expense->expense_category($expense->expense_category_id)->name:''; $data[$k]["payee_id"]=Expense::payee($expense->payee_id)->payee_name; $data[$k]["payment_type_id"]=!empty($expense->payment_type($expense->payment_type_id))?$expense->payment_type($expense->payment_type_id)->name:''; $data[$k]["created_by"]=Employee::login_user($expense->created_by); unset($expense->created_at,$expense->updated_at); } return $data; } public function headings(): array { return [ "ID", "Account Name", "Amount", "Date", "Expense Category", "Payee", "Payment Type", "Referal Id", "Description", "Created By", ]; } } PK0Z\AssetsExport.phpnu[creatorId())->get(); foreach($data as $k=>$assets) { $data[$k]["employee_id"]=Employee::employee_name($assets->employee_id); $data[$k]["created_by"]=Employee::login_user($assets->created_by); unset($assets->created_at,$assets->updated_at); } return $data; } public function headings(): array { return [ "ID", "employee", "Asset Name", "Purchase Date", "Supported Date", "Amount", "Description", "Created By" ]; } } PK0Z^8))TransferBalanceExport.phpnu[creatorId())->get(); foreach($data as $k=>$transfer_balance) { $data[$k]["from_account_id"]=!empty($transfer_balance->account($transfer_balance->from_account_id))?$transfer_balance->account($transfer_balance->from_account_id)->account_name:''; $data[$k]["to_account_id"]=!empty($transfer_balance->account($transfer_balance->to_account_id))?$transfer_balance->account($transfer_balance->to_account_id)->account_name:''; $data[$k]["payment_type_id"]=!empty($transfer_balance->payment_type($transfer_balance->payment_type_id))?$transfer_balance->payment_type($transfer_balance->payment_type_id)->name:''; $data[$k]["created_by"]=Employee::login_user($transfer_balance->created_by); unset($transfer_balance->created_at,$transfer_balance->updated_at); } return $data; } public function headings(): array { return [ "ID", "From Account", "To Account", "Date", "Amount", "Payment Type", "Referal ID", "Description", "Created BY" ]; } } PK0Z   LeaveExport.phpnu[creatorId())->get(); if (\Auth::user()->type == 'employee') { $employee = Employee::where('user_id', '=', $user->id)->first(); $data= Leave::where('employee_id', '=', $employee->id)->where('created_by', \Auth::user()->creatorId())->get(); foreach($data as $k=>$leave) { $data[$k]["employee_id"]=Employee::employee_name($leave->employee_id); $data[$k]["leave_type_id"]= !empty(\Auth::user()->getLeaveType($leave->leave_type_id))?\Auth::user()->getLeaveType($leave->leave_type_id)->title:''; $data[$k]["created_by"]=Employee::login_user($leave->created_by); unset($leave->created_at,$leave->updated_at); } } else{ $data= Leave::where('created_by', \Auth::user()->creatorId())->get(); foreach($data as $k=>$leave) { $data[$k]["employee_id"]=Employee::employee_name($leave->employee_id); $data[$k]["leave_type_id"]= !empty(\Auth::user()->getLeaveType($leave->leave_type_id))?\Auth::user()->getLeaveType($leave->leave_type_id)->title:''; $data[$k]["created_by"]=Employee::login_user($leave->created_by); unset($leave->created_at,$leave->updated_at); } return $data; } return $data; } public function headings(): array { return [ "ID", "Employee Name", "Leave Type ", "Applied On", "Start Date", "End Date", "Total Leaves Days", "Leave Reason", "Remark", "Status", "Created By" ]; } } PK0Z TrainingExport.phpnu[creatorId())->get(); foreach ($data as $k => $training) { unset($training->created_at,$training->updated_at); $data[$k]["branch"] = Branch::where('id', $training->branch)->pluck('name')->first(); $trainer_option = $training->trainer_option; if ($trainer_option == 0) { $data[$k]["trainer_option"] = 'Internal'; } else { $data[$k]["trainer_option"] = 'External'; } $data[$k]["training_type"] = TrainingType::where('id', $training->training_type)->pluck('name')->first(); $data[$k]["trainer"] = Trainer::where('id', $training->trainer)->pluck('firstname')->first(); $data[$k]["employee"] = Employee::where('id', $training->employee)->pluck('name')->first(); $data[$k]["status"]=Training::status($training->status); $data[$k]["created_by"]=Employee::login_user($training->created_by); $data[$k]["performance"] = Employee::where('id', $training->employee)->pluck('name')->first(); $performance = $training->performance; if ($performance == 0) { $data[$k]["performance"] = 'Not Concluded'; } else if ($performance == 1) { $data[$k]["performance"] = 'Satisfactory'; } elseif ($performance == 2) { $data[$k]["performance"] = 'Average'; } elseif ($performance == 3) { $data[$k]["performance"] = 'Poor'; } else { $data[$k]["performance"] = 'Excellent'; } } return $data; } public function headings(): array { return [ "ID", "Branch Name", "Trainer Option", "Trainer Type", "Trainer", "Trainer Cost", "Employee Name", "Start Date", "End Date", "Description", "Performance", "status", "Remarks", "Created By" ]; } } PK0Z o\TimesheetExport.phpnu[creatorId())->get(); foreach($data as $k=>$timesheet) { $data[$k]["employee_id"]=!empty($timesheet->employee) ? $timesheet->employee->name : ''; $data[$k]["created_by"]=Employee::login_user($timesheet->created_by); unset($timesheet->created_at,$timesheet->updated_at); } return $data; } public function headings(): array { return [ "ID", "Employee Name", "Date", "Hour", "Remark", "Created By" ]; } } PK0Z 'ݔEmployeesExport.phpnu[creatorId())->get(); foreach($data as $k => $employees) { unset($employees->id,$employees->user_id,$employees->documents,$employees->tax_payer_id,$employees->is_active,$employees->created_at,$employees->updated_at); $data[$k]["branch_id"]=!empty($employees->branch_id) ? $employees->branch->name : '-'; $data[$k]["department_id"]=!empty($employees->department_id) ? $employees->department->name : '-'; $data[$k]["designation_id"]= !empty($employees->designation_id) ? $employees->designation->name : '-'; $data[$k]["salary_type"]=!empty($employees->salary_type) ? $employees->salaryType->name :'-'; $data[$k]["salary"]=Employee::employee_salary($employees->salary); $data[$k]["created_by"]=Employee::login_user($employees->created_by); } return $data; } public function headings(): array { return [ "Name", "Date of Birth", "Gender", "Phone Number", "Address", "Email ID", "Password", "Employee ID", "Branch", "Department", "Designation", "Date of Join", "Account Holder Name", "Account Number", "Bank Name", "Bank Identifier Code", "Branch Location", "Salary Type", "Salary", "Created By" ]; } } PK0Z%TimesheetReportExport.phpnu[creatorId())->get(); foreach($data as $k=>$timesheet) { $data[$k]["employee_id"]=!empty($timesheet->employee) ? $timesheet->employee->name : ''; $data[$k]["created_by"]=Employee::login_user($timesheet->created_by); unset($timesheet->created_at,$timesheet->updated_at,$timesheet->created_by); } return $data; } public function headings(): array { return [ "ID", "Employee Name", "Date", "Hour", "Remark", ]; } } PK0ZqfJJHolidayExport.phpnu[PK0Z[h LeaveReportExport.phpnu[PK0ZZ? PayslipExport.phpnu[PK0Zþ~~accountstatementExport.phpnu[PK0Zz8OEventExport.phpnu[PK0Z)$"TrainerExport.phpnu[PK0Z'DepositExport.phpnu[PK0Z9  M-PayrollExport.phpnu[PK0Z+k7ExpenseExport.phpnu[PK0Z\=AssetsExport.phpnu[PK0Z^8))ATransferBalanceExport.phpnu[PK0Z   ?HLeaveExport.phpnu[PK0Z QTrainingExport.phpnu[PK0Z o\[TimesheetExport.phpnu[PK0Z 'ݔ_EmployeesExport.phpnu[PK0Z%gTimesheetReportExport.phpnu[PK-k