|
{{ $item->id }} |
{{ date('Y-m-d H:i', strtotime($item->created_at)) }} |
{{ $inflow[$item->inflow_path]['name'] }} |
|
@if ($item->is_completed == 0)
@endif
@php
$histories = json_decode($item->term_history, 1);
@endphp
@if ( ! empty($histories) && sizeof($histories) > 0 )
@endif
@if ($item->inflow_path == 'leveltest')
@php
/*-------------------------------------------------
* 레벨테스트 결과 검색 (과거 현재 둘다 조회되도록..)
* 현재) inquiry_detail_id 에서 검색
* 과거) 핸드폰번호, 이름, 인쿼리시간과 일치한 이력을 조회
--------------------------------------------------*/
$levelTest = null;
$levelTest_id = 0;
$query = LevelTest::query();
if (isset($item->id)) {
$query->where('inquiry_detail_id', $item->id);
}
$created_at = date('Y-m-d H:i:s', strtotime($item->created_at));
$phone = $inquiry?->phone;
$name = $inquiry?->name;
if (isset($phone) && isset($name) && isset($created_at)) {
$query->orWhere(function ($q) use ($created_at, $phone, $name) {
$q->where('created_at', $created_at)->where('phone', $phone)->where('name', $name);
});
}
$levelTest = $query->first();
if ($levelTest && isset($levelTest->id) && $levelTest->id > 0) {
$levelTest_id = $levelTest->id;
}
@endphp
@endif
|
@endforeach