| Sl | Audit Number | Audit Name | File Name | Approval Status |
|---|---|---|---|---|
| {{ $loop->iteration }} | {{ $list->audit_number }} | {{ $list->audit_name }} | {{ $list->audit_ref }} |
@php
$query = 'SELECT user_id, EMP_NAME,REFERENCE_STATUS,REFERENCE_COMMENT
FROM (
SELECT u.user_id, e.EMP_NAME, 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.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 = DB::selectOne($query, ['P_REFERENCE_ID'=>$list->audit_master_id]);
$curWorkFlowStep = DB::table('IAMS.WORKFLOW_MAPPING')
->select('IAMS.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.WORKFLOW_MAPPING.workflow_detail_id', '=', 'IAMS.WORKFLOW_DETAIL.workflow_detail_id')
->where('IAMS.WORKFLOW_MAPPING.reference_id', $list->audit_master_id)
->where('IAMS.WORKFLOW_MAPPING.workflow_master_id', 1)
->orderBy('IAMS.WORKFLOW_MAPPING.insert_date', 'desc')
->first();
@endphp
@if ($curWorkFlowStep && isset($approved_by) && $curWorkFlowStep->reference_status !== "FA" && $curWorkFlowStep->reference_status !== 'R')
{{ $curWorkFlowStep->step_name }}
@elseif ($list->ready_for_approve == 'N')
Not Submitted
@elseif ($list->status == 'P')
{{ (isset($curWorkFlowStep) ? $curWorkFlowStep->step_name : 'Submitted For Approval') }}
@else
Approved By {{ (isset($approved_by) ? $approved_by->emp_name : '') }}
@endif
|