| Sr.No |
Project Name |
|
Name of Newspaper |
Tender Start Date |
Tender End Date |
Tender Bid Open Date |
Tender Pre-bid Date |
Remark |
@php
$last_num_newspaper = [];
foreach ($newspapersLast as $newspaper) {
$last_num_newspaper[] = $newspaper->sequence_no;
}
@endphp
@foreach ($retender as $key => $retenderProject)
| {{ $i }} |
{{ $retenderProject->ProjectName }}
|
|
@php
$last_news_paper = DB::table('tbl_projects')
->where('TenderId', $retenderProject->TenderId)
->where('ProjectID', $retenderProject->ProjectID)
->first();
$news_paper_log = explode(',', $last_news_paper->Newspapers ?? '');
$news = [];
if (!empty($last_num_newspaper) && count($last_num_newspaper) == 3 && !empty($news_paper_log) && count($news_paper_log) == 3) {
$news[] = $news_paper_log[0] < $last_num_newspaper[0] ? $news_paper_log[0] + 1 : 1;
$news[] = $news_paper_log[1] < $last_num_newspaper[1] ? $news_paper_log[1] + 1 : 1;
$news[] = $news_paper_log[2] < $last_num_newspaper[2] ? $news_paper_log[2] + 1 : 1;
}
@endphp
@foreach (array_reverse($news) as $news_name_id)
@endforeach
@php
$result = DB::table('master_newspapers')
->where(function ($query) use ($news) {
$query->where('sequence', $news[0])->where('Type_of_newspaper', 'English');
})
->orWhere(function ($query) use ($news) {
$query->where('sequence', $news[1])->where('Type_of_newspaper', 'Marathi');
})
->orWhere(function ($query) use ($news) {
$query->where('sequence', $news[2])->where('Type_of_newspaper', 'Other');
})
->orderBy('Type_of_newspaper', 'ASC')
->get();
@endphp
|
|
|
|
|
|
@php
$Re_tender_log_new = DB::table('tbl_re_tender')->where('ProjectID', $retenderProject->ProjectID)->get();
@endphp
@if ($Re_tender_log_new)
@php $j = 1; @endphp
@foreach ($Re_tender_log_new as $re_tender_log)
|
|
{{ $j }}) |
@php
$news_paper = explode(',', $re_tender_log->Newspapers);
$news_paper_name_1 = DB::table('master_newspapers')->where('status', '1')->where('Type_of_newspaper', 'English')->where('sequence', $news_paper[0] ?? '')->first();
$news_paper_name_2 = DB::table('master_newspapers')->where('status', '1')->where('Type_of_newspaper', 'Marathi')->where('sequence', $news_paper[1] ?? '')->first();
$news_paper_name_3 = DB::table('master_newspapers')->where('status', '1')->where('Type_of_newspaper', 'Other')->where('sequence', $news_paper[2] ?? '')->first();
@endphp
|
{{ $re_tender_log->ProjectTenderStartDate }} |
{{ $re_tender_log->ProjectTenderEndDate }} |
{{ $re_tender_log->TenderBidOpenDate }} |
{{ $re_tender_log->TenderPrebidDate }} |
{{ $re_tender_log->remark }} |
@php $j++; @endphp
@endforeach
@endif
@php $i++; @endphp
@endforeach