Malaysia Coastal, Oceanography and Hydraulic Marine Geospatial Data Management System

Publications

Impact Of Sea Level Rise Due To Climate Change : Case Study : A Part Of Klang And Kuala Langat District

11 October 2022
Report

Impact Of Sea Level Rise Due To Climate Change : Case Study : A Part Of Klang And Kuala Langat District

Chapters

Something went wrong

Page ID : 18
Content ID : 44
SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: '' The SQL being executed was: SELECT * FROM `publication_version` WHERE (`version_status` = 'active') AND (`document_id` = 5) AND ((`version_date_start` = '') OR (`version_date_start` = '0000-00-00') OR (`version_date_start` IS NULL) OR (`version_date_start` <= '2025-12-06')) AND ((`version_date_end` = '') OR (`version_date_end` = '0000-00-00') OR (`version_date_end` IS NULL) OR (`version_date_end` >= '2025-12-06')) ORDER BY `version_no` DESC
Content :

echo '<div class="col-lg-9">
    <div class="blog-entry mb-50">';

$query = new \yii\db\Query(); 
$model = $query->select(['*'])->from('publication_document')
    ->innerJoin('publication_document_translation','publication_document.document_id=publication_document_translation.document_translation_parent_id')
    ->where(['=','publication_document.document_code',Yii::$app->getRequest()->getQueryParam('id')])->all();
if(!empty($model)){
    foreach($model as $row){
        
        $publication_date = date("j F Y", strtotime($row['document_date']));
        
        
        echo '
        <div class="row">
            <div class="col-md-8">
                <h5 class="pt-4 pl-4 pr-4" style="line-height:150%;">'.$row['document_translation_title'].'</h5>
                
                <div class="entry-meta pt-2 pb-2 pl-4 pr-4">
                    <ul>
                        <li> <i class="fa fa-calendar-o"></i> '.$publication_date.' </li>
                        <li> <i class="fa fa-folder-open-o"></i>  '.\backend\modules\refdynawebv2\models\Ref::getDesc('DOCUMENTCATEGORY', $row['document_category'], 'descr_en').'</li>
                    </ul>
                </div>
                
                <div class="entry-content pl-4 pr-4">'.$row['document_translation_content'].'</div>
            </div>
            <div class="col-md-4">
                <center>
                    <img src="/admin/'.$row['document_image'].'" style="width:250px;">
                </center>
            </div>
        </div>
        
        <div class="blog-detail text-justify mt-0 pt-0">
        
            <h5 class="" style="line-height:150%;">Chapters</h5>
        
            
            ';
            
//version
$queryVersion = new \yii\db\Query(); 
$queryVersion->select(['*'])->from('publication_version')
    ->where(['=','version_status','active'])
    ->andwhere(['=','document_id',$row['document_id']])
    ->andwhere(['OR',
        ['=','version_date_start',''],
        ['=','version_date_start','0000-00-00'],
        ['is','version_date_start',NULL],
        ['<=','version_date_start',date('Y-m-d')],
    ])
    ->andwhere(['OR',
        ['=','version_date_end',''],
        ['=','version_date_end','0000-00-00'],
        ['is','version_date_end',NULL],
        ['>=','version_date_end',date('Y-m-d')],
    ])
    ->orderBy(['version_no' => SORT_DESC]);
$modelVersion = $queryVersion->all();
if(!empty($modelVersion)){
    foreach($modelVersion as $rowVersion){
        //echo '<h5>'.$rowVersion['version_title'].' ('.$rowVersion['version_no'].')</h5>';
        
        $queryChapter = new \yii\db\Query(); 
        $queryChapter->select(['*'])->from('publication_chapter')->where(['=','version_id',$rowVersion['version_id']])->orderBy(['chapter_sort' => SORT_ASC]);
        $modelChapter = $queryChapter->all();
        if(!empty($modelChapter)){
            echo '<ol class="m-0 p-3">';
            foreach($modelChapter as $rowChapter){
                
                $docSize = '';
                $docPage = '';
                
                if(!empty($rowChapter['total_size']))
                    $docSize = '<small>'.$rowChapter['total_size'].' MB</small>    ';
                if(!empty($rowChapter['total_pages']))
                    $docPage = '<small>'.$rowChapter['total_pages'].' pages</small>';
                    
                $btnDownload = '';
                if(!empty($rowChapter['chapter_ebook2']))
                    $btnDownload .= '<a class="btn btn-danger btn-sm mr-2" href="'.$baseUrl.'/admin/'.$rowChapter['chapter_ebook2'].'" target="_blank">View as PDF</a>';
                if(!empty($rowChapter['chapter_ebook1']))
                    $btnDownload .= '<a class="btn btn-info btn-sm mr-2" href="'.$baseUrl.'/admin/'.$rowChapter['chapter_ebook1'].'" target="_blank">View as E-Book</a>';
                else if(!empty($rowChapter['chapter_ebook2'])){
                    $chapter_ebook2_arr = explode('/',$rowChapter['chapter_ebook2']);
                    $ebook_background = 'default-bg-ebook.jpg';
                    if(!empty($row['document_bckgd'])){
                        $ebook_background_arr = explode('/',$row['document_bckgd']);
                        $ebook_background = $ebook_background_arr[2];
                    }
                    //$btnDownload .= '<a class="btn btn-info btn-sm mr-2" href="../../flowpaper/php/view_doc.php?subfolder=&doc='.$chapter_ebook2_arr[2].'&bg='.$ebook_background.'" target="_blank">Muat Turun E-Book</a>';
                }
                
                echo '<li><p>'.$rowChapter['chapter_title'].'<br>'.$docSize.$docPage.'<span style="float:right;">'.$btnDownload.'</span></p></li>';
            }
            echo '</ol>';
        }
        
    }
}
            
        echo '</div>';
    }
}
    echo '</div>
</div>';

Disclaimer• Privacy Policy• Security Policy• Personal Data Protection

Best viewed using Mozilla Firefox dan Google Chrome with screen resolution 1366x768.

TOP

Publications

Impact Of Sea Level Rise Due To Climate Change : Case Study : A Part Of Klang And Kuala Langat District

Chapters

Something went wrong

Search

Latest publication