Malaysia Coastal, Oceanography and Hydraulic Marine Geospatial Data Management System

Publications

Storm Surge Analysis Due To High Water Events And Sea Level Rise Impacts (2019)

12 October 2022
Report

Storm Surge Analysis Due To High Water Events And Sea Level Rise Impacts (2019)

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` = 13) 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

Storm Surge Analysis Due To High Water Events And Sea Level Rise Impacts (2019)

Chapters

Something went wrong

Search

Latest publication