JFIFxxC      C  " }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3RbrHolidayExport.php000064400000001512150364311670010055 0ustar00creatorId())->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" ]; } } LeaveReportExport.php000064400000005415150364311670010722 0ustar00creatorId())->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", ]; } } PayslipExport.php000064400000005341150364311670010111 0ustar00data = $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", ]; } } accountstatementExport.php000064400000002176150364311670012054 0ustar00creatorId())->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", ]; } } EventExport.php000064400000001715150364311670007552 0ustar00creatorId())->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", ]; } } TrainerExport.php000064400000002002150364311670010063 0ustar00creatorId())->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" ]; } } DepositExport.php000064400000002766150364311670010107 0ustar00creatorId())->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" ]; } } PayrollExport.php000064400000004735150364311670010120 0ustar00month = $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", ]; } } ExpenseExport.php000064400000002774150364311670010106 0ustar00creatorId())->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", ]; } } AssetsExport.php000064400000001745150364311670007736 0ustar00creatorId())->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" ]; } } TransferBalanceExport.php000064400000003051150364311670011516 0ustar00creatorId())->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" ]; } } LeaveExport.php000064400000004424150364311670007525 0ustar00creatorId())->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" ]; } } TrainingExport.php000064400000005015150364311670010241 0ustar00creatorId())->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" ]; } } TimesheetExport.php000064400000001713150364311670010416 0ustar00creatorId())->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" ]; } } EmployeesExport.php000064400000003624150364311670010434 0ustar00creatorId())->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" ]; } } TimesheetReportExport.php000064400000001720150364311670011610 0ustar00creatorId())->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", ]; } }