| Sl | Audit Number | From Date | To Date | Approval Status |
|---|---|---|---|---|
| {{ $loop->iteration }} | {{ $list->ia_audit_number }} | {{ date( 'd-m-Y' , strtotime($list->from_date)) }} | {{ date( 'd-m-Y' , strtotime($list->to_date)) }} |
@php
$q = 'SELECT user_id,
EMP_NAME,
REFERENCE_STATUS,
REFERENCE_COMMENT
FROM ( SELECT u.user_id,
e.EMP_NAME,e.EMP_CODE,
WM.REFERENCE_STATUS,
WM.REFERENCE_COMMENT
FROM cpa_security.sec_users u
JOIN pmis.employee e ON e.emp_id = u.emp_id
JOIN IAMS.INDIVIDUAL_AUDIT_WORKFLOW_MAPPING wm ON wm.UPDATE_BY = u.user_id
WHERE WM.REFERENCE_ID = :P_REFERENCE_ID
ORDER BY wm.WORKFLOW_MAPPING_ID DESC)
WHERE ROWNUM = 1';
$approved_by = \Illuminate\Support\Facades\DB::selectOne($q, ['P_REFERENCE_ID'=>$list->individual_audit_id]);
$curWorkFlowStep = DB::table('IAMS.INDIVIDUAL_AUDIT_WORKFLOW_MAPPING')
->select('IAMS.INDIVIDUAL_AUDIT_WORKFLOW_MAPPING.*', 'IAMS.WORKFLOW_DETAIL.STEP_NAME', 'IAMS.WORKFLOW_DETAIL.ROLE', 'IAMS.WORKFLOW_DETAIL.STATUS', 'IAMS.WORKFLOW_DETAIL.ADDITIONAL_COMMENT', 'IAMS.WORKFLOW_DETAIL.APPROVAL_AUTHORITY_YN')
->join('IAMS.WORKFLOW_DETAIL', 'IAMS.INDIVIDUAL_AUDIT_WORKFLOW_MAPPING.workflow_detail_id', '=', 'IAMS.WORKFLOW_DETAIL.workflow_detail_id')
->where('IAMS.INDIVIDUAL_AUDIT_WORKFLOW_MAPPING.reference_id', $list->individual_audit_id)
->where('IAMS.INDIVIDUAL_AUDIT_WORKFLOW_MAPPING.workflow_master_id', 3)
->orderBy('IAMS.INDIVIDUAL_AUDIT_WORKFLOW_MAPPING.insert_date', 'desc')
->first();
@endphp
@if (isset($approved_by) && $approved_by->reference_status !== "FA")
{{ $curWorkFlowStep->step_name }}
@elseif ($list->ready_for_approve == 'N')
Not Submitted
@elseif ($list->status=='P' && $list->ready_for_approve=='Y')
{{ (isset($curWorkFlowStep) ? $curWorkFlowStep->step_name : 'Submitted For Approval') }}
@else
Approved By {{ (isset($approved_by) ? $approved_by->emp_name : '') }}
@endif
|