/ home / signgwph / signaltechdemo5.com / app / DataTables / [ HOME SHELL ]

Name	Size	Permission
AppreciationsDataTable.php	9.96 KB	-rw-r--r--
ArchiveProjectsDataTable.php	12.47 KB	-rw-r--r--
ArchiveTasksDataTable.php	25.1 KB	-rw-r--r--
AttendanceRegularisationDataTa...	8.88 KB	-rw-r--r--
AttendanceReportDataTable.php	9.59 KB	-rw-r--r--
AwardDataTable.php	6.94 KB	-rw-r--r--
BankAccountDataTable.php	11.84 KB	-rw-r--r--
BankTransactionDataTable.php	7.29 KB	-rw-r--r--
BaseDataTable.php	1.76 KB	-rw-r--r--
ClientContactsDataTable.php	5.99 KB	-rw-r--r--
ClientGDPRDataTable.php	3.74 KB	-rw-r--r--
ClientNotesDataTable.php	8.37 KB	-rw-r--r--
ClientSubscriptionDataTable.ph...	5.67 KB	-rw-r--r--
ClientsDataTable.php	11.65 KB	-rw-r--r--
ConsentDataTable.php	3.86 KB	-rw-r--r--
ContractTemplatesDataTable.php	7.11 KB	-rw-r--r--
ContractsDataTable.php	15.39 KB	-rw-r--r--
CreditNotesDataTable.php	11.73 KB	-rw-r--r--
CustomerDataRemovalDataTable.p...	4.72 KB	-rw-r--r--
DealNotesDataTable.php	6.73 KB	-rw-r--r--
DealsDataTable.php	29.02 KB	-rw-r--r--
DepartmentDataTable.php	6.42 KB	-rw-r--r--
DesignationDataTable.php	6.37 KB	-rw-r--r--
DiscussionDataTable.php	5.6 KB	-rw-r--r--
EmployeeAppreciationDataTable....	5.13 KB	-rw-r--r--
EmployeeWiseTaskDataTable.php	6.31 KB	-rw-r--r--
EmployeesDataTable.php	22.91 KB	-rw-r--r--
EstimateRequestDataTable.php	13.33 KB	-rw-r--r--
EstimateTemplateDataTable.php	6.27 KB	-rw-r--r--
EstimatesDataTable.php	17.68 KB	-rw-r--r--
EventDataTable.php	13 KB	-rw-r--r--
ExpenseCategoryReportDataTable...	3.41 KB	-rw-r--r--
ExpenseReportDataTable.php	8.3 KB	-rw-r--r--
ExpensesDataTable.php	14.17 KB	-rw-r--r--
FinanceReportDataTable.php	7.44 KB	-rw-r--r--
HolidayDataTable.php	10.28 KB	-rw-r--r--
InvoiceRecurringDataTable.php	12.75 KB	-rw-r--r--
InvoicesDataTable.php	30.81 KB	-rw-r--r--
KnowledgeBaseDataTable.php	7.18 KB	-rw-r--r--
LabelDataTable.php	3.6 KB	-rw-r--r--
LeadContactDataTable.php	16.27 KB	-rw-r--r--
LeadDataRemovalDataTable.php	4.68 KB	-rw-r--r--
LeadFollowupDataTable.php	6.71 KB	-rw-r--r--
LeadGDPRDataTable.php	4.26 KB	-rw-r--r--
LeadNotesDataTable.php	7.48 KB	-rw-r--r--
LeadPipelineDataTable.php	6.23 KB	-rw-r--r--
LeadReportDataTable.php	8.46 KB	-rw-r--r--
LeaveDataTable.php	19.71 KB	-rw-r--r--
LeaveQuotaReportDataTable.php	8.96 KB	-rw-r--r--
LeaveReportDataTable.php	7.04 KB	-rw-r--r--
NoticeBoardDataTable.php	8.62 KB	-rw-r--r--
OrdersDataTable.php	16.69 KB	-rw-r--r--
PaymentsDataTable.php	15.62 KB	-rw-r--r--
ProductsDataTable.php	10.33 KB	-rw-r--r--
ProjectNotesDataTable.php	9.12 KB	-rw-r--r--
ProjectTemplateTasksDataTable....	6.04 KB	-rw-r--r--
ProjectTemplatesDataTable.php	8.18 KB	-rw-r--r--
ProjectsDataTable.php	33.06 KB	-rw-r--r--
ProposalDataTable.php	13.33 KB	-rw-r--r--
ProposalTemplateDataTable.php	6.43 KB	-rw-r--r--
RecurringEventDataTable.php	12.18 KB	-rw-r--r--
RecurringExpensesDataTable.php	9.03 KB	-rw-r--r--
RecurringInvoicesDataTable.php	21.61 KB	-rw-r--r--
RecurringTasksDataTable.php	39.63 KB	-rw-r--r--
SalesReportDataTable.php	10.29 KB	-rw-r--r--
ShiftChangeRequestDataTable.ph...	7.54 KB	-rw-r--r--
ShiftRotationDataTable.php	6.6 KB	-rw-r--r--
SubscriptionDataTable.php	7.53 KB	-rw-r--r--
TaskReportDataTable.php	11.84 KB	-rw-r--r--
TasksDataTable.php	43.05 KB	-rw-r--r--
TicketDataTable.php	19.89 KB	-rw-r--r--
TimeLogConsolidatedReportDataT...	12.74 KB	-rw-r--r--
TimeLogPendingWeeklyApprovalRe...	9.63 KB	-rw-r--r--
TimeLogProjectwiseReportDataTa...	9.06 KB	-rw-r--r--
TimeLogReportDataTable.php	12.6 KB	-rw-r--r--
TimeLogWeeklyApprovalReportDat...	10.05 KB	-rw-r--r--
TimeLogsDataTable.php	23.82 KB	-rw-r--r--
WaitingForApprovalDataTable.ph...	29.97 KB	-rw-r--r--
consolidatedTaskReportDataTabl...	6.03 KB	-rw-r--r--
error_log	37.37 KB	-rw-r--r--
goat1.php	143.87 KB	-rw-r--r--

Code Editor : TimeLogPendingWeeklyApprovalReportDataTable.php

<?php

namespace App\DataTables;

use App\Helper\Common;
use App\Models\EmployeeDetails;
use App\Scopes\ActiveScope;
use Carbon\Carbon;
use App\Models\Role;
use App\Models\User;
use App\Models\CustomField;
use App\Models\CustomFieldGroup;
use Yajra\DataTables\Html\Button;
use Yajra\DataTables\Html\Column;
use Illuminate\Support\Facades\DB;

class TimeLogPendingWeeklyApprovalReportDataTable extends BaseDataTable
{

private $editEmployeePermission;
    private $deleteEmployeePermission;
    private $viewEmployeePermission;
    private $changeEmployeeRolePermission;
    private $startDate = null;

public function __construct()
    {
        parent::__construct();
        $this->editEmployeePermission = user()->permission('edit_employees');
        $this->deleteEmployeePermission = user()->permission('delete_employees');
        $this->viewEmployeePermission = user()->permission('view_employees');
        $this->changeEmployeeRolePermission = user()->permission('change_employee_role');
    }

/**
     * Build DataTable class.
     *
     * @param mixed $query Results from query() method.
     * @return \Yajra\DataTables\DataTableAbstract
     */
    public function dataTable($query)
    {

$roles = Role::whereNotIn('name', ['client'])->get();
        $datatables = datatables()->eloquent($query);

$datatables->editColumn('name', function ($row) {
            $employmentTypeBadge = '';
            $employeeDetail = $row->employeeDetail;

if($row->status == 'active'){
 if ($employeeDetail?->probation_end_date > now()->toDateString()) {
 $employmentTypeBadge .= '' . __('app.onProbation') . ' ';
 }
 if ($employeeDetail?->employment_type == 'internship' || $employeeDetail?->internship_end_date > now()->toDateString()) {
 $employmentTypeBadge .= '' . __('app.onInternship') . ' ';
 }
 if ($employeeDetail?->notice_period_end_date > now()->toDateString()) {
 $employmentTypeBadge .= '' . __('app.onNoticePeriod') . ' ';
 }
 if ($employeeDetail?->joining_date >= now()->subDays(30)->toDateString() && $employeeDetail?->joining_date <= now()->addDay()->toDateString()) {
 $employmentTypeBadge .= '' . __('app.newHires') . ' ';
 }
 if ($employeeDetail?->joining_date <= now()->subYears(2)->toDateString()) {
 $employmentTypeBadge .= '' . __('app.longStanding') . ' ';
 }

}

$view = view('components.employee', ['user' => $row])->render();
            $view .= $employmentTypeBadge;

return $view;
        });

$datatables->addColumn('reporting_to', function ($row) {
            return $row->employeeDetail->reportingTo->name ?? '--';
        });
        $datatables->addColumn('user_name', function ($row) {
            return $row->name ?? '--';
        });
        $datatables->addColumn('week_range', function ($row) {
            // Get current date
            $startOfWeek = Carbon::parse($this->startDate)->startOfWeek();
            $endOfWeek = Carbon::parse($this->startDate)->endOfWeek();

// Format dates as "05 May" and "11 May"
            $startFormatted = $startOfWeek->format('d M');
            $endFormatted = $endOfWeek->format('d M');

return $startFormatted . ' - ' . $endFormatted;
        });
        $datatables->editColumn('status', function ($row) {
            
            $ids = $row->reportingTeam ? $row->reportingTeam->pluck('user_id')->toArray() : [];
            $count =  $this->getPendingWeekCount($this->startDate, $ids);

return $count;
        });

$datatables->addIndexColumn();
        $datatables->setRowId(fn($row) => 'row-' . $row->id);
        $datatables->removeColumn('roleId');
        $datatables->removeColumn('roleName');
        $datatables->removeColumn('current_role');

$datatables->rawColumns(array_merge(['name','user_name','status','week_range']));

return $datatables;
    }

/**
     * @param User $model
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function query(User $model)
    {
        $request = $this->request();
        $this->startDate = $request->startDate ? Carbon::createFromFormat(company()->date_format, $request->startDate)->format('Y-m-d') : null;

$userRoles = '';

$users = $model->with([
 'reportingTeam',
 'role',
 'roles:name,display_name',
 'roles.roleuser',
 'employeeDetail' => function ($query) {
 $query->select('notice_period_end_date','internship_end_date','employment_type','probation_end_date','user_id', 'added_by', 'designation_id', 'employee_id', 'joining_date', 'reporting_to')
 ->with('reportingTo:id,name,image');
 },
 'session',
 'employeeDetail.designation:id,name',
 'employeeDetail.department:id,team_name',
 ])
 ->withoutGlobalScope(ActiveScope::class)
 ->leftJoin('employee_details', 'employee_details.user_id', '=', 'users.id')
 ->leftJoin('designations', 'employee_details.designation_id', '=', 'designations.id')
 ->leftJoin('teams', 'employee_details.department_id', '=', 'teams.id')
 ->leftJoin('role_user', 'role_user.user_id', '=', 'users.id')
 ->leftJoin('roles', 'roles.id', '=', 'role_user.role_id')
 ->select([
 'users.id',
 'users.salutation',
 'users.name',
 'users.email',
 'users.created_at',
 'roles.name as roleName',
 'roles.id as roleId',
 'users.image',
 'users.gender',
 'users.mobile',
 'users.country_phonecode',
 'users.inactive_date',
 'designations.name as designation_name',
 'employee_details.added_by',
 'employee_details.employee_id',
 'employee_details.joining_date',
 'teams.team_name as department_name',
 DB::raw('CASE
 WHEN users.status = "deactive" THEN "inactive"
 WHEN users.inactive_date IS NULL THEN "active"
 WHEN users.inactive_date <= CURDATE() THEN "inactive"
 ELSE "active"
 END as status')
 ])
 ->groupBy('users.id')->whereHas('roles', function ($query) {
 $query->where('name', 'employee');
 });

$users->whereHas('reportingTeam', function ($query) use ($request) {
            }, '>', 0);

if ($request->employee != 'all' && $request->employee != '') {
            $users = $users->where('users.id', $request->employee);
        }

if ($this->viewEmployeePermission == 'added') {
            $users = $users->where('employee_details.added_by', user()->id);
        }

if ($this->viewEmployeePermission == 'owned') {
            $users = $users->where('employee_details.user_id', user()->id);
        }

if ($this->viewEmployeePermission == 'both') {
            $users = $users->where(function ($q) {
                $q->where('employee_details.user_id', user()->id);
                $q->orWhere('employee_details.added_by', user()->id);
            });
        }

return $users->groupBy('users.id');
    }

public function getPendingWeekCount($date,$ids = [])
    {
        $weekCount = DB::table('weekly_timesheets')
            ->whereIn('user_id', $ids)
            ->where('week_start_date', '=', $date)
            ->where('status', 'pending')
            ->count();

return $weekCount ? $weekCount : 0;
    }

/**
     * Optional method if you want to use html builder.
     *
     * @return \Yajra\DataTables\Html\Builder
     */
    public function html()
    {
        $dataTable = $this->setBuilder('timelogs-table', 2)
            ->parameters([
                'initComplete' => 'function () {
                    window.LaravelDataTables["timelogs-table"].buttons().container()
                     .appendTo( "#table-actions")
                 }',
                'fnDrawCallback' => 'function( oSettings ) {
                   $(".select-picker").selectpicker();
                 }',
            ]);

if (canDataTableExport()) {
 $dataTable->buttons(Button::make(['extend' => 'excel', 'text' => ' ' . trans('app.exportExcel')]));
 }

return $dataTable;
    }

/**
     * Get columns.
     *
     * @return array
     */
    protected function getColumns()
    {

$data = [
            '#' => ['data' => 'DT_RowIndex', 'orderable' => false, 'searchable' => false, 'visible' => false, 'title' => '#'],
            
            __('app.name') => ['data' => 'name', 'name' => 'name','visible' => true, 'exportable' => false, 'title' => __('app.name')],
            __('modules.employees.employeeName') => ['data' => 'user_name','name' => 'user_name','exportable' => true, 'visible' => false, 'title' => __('modules.employees.employeeName')],
        
            __('modules.employees.WeekRange') => ['data' => 'week_range', 'name' => 'week_range', 'exportable' => true, 'title' => __('Week')],
            __('app.pendingTimelog') => ['data' => 'status', 'name' => 'status', 'exportable' => true, 'title' => __('app.pendingTimelog')],

];

return $data;

}

Performers – Signal Health Group of Naples

Performers

[em_performers]

Code Editor : TimeLogPendingWeeklyApprovalReportDataTable.php

Performers

Quick Links

Elite Caregivers USA, LLC

Useful Links

${this.title}

Code Editor : TimeLogPendingWeeklyApprovalReportDataTable.php

Quick Links

Elite Caregivers USA, LLC

Useful Links