Malaysia Coastal, Oceanography and Hydraulic Marine Geospatial Data Management System

Publications

Penilaian Risiko Impak Peningkatan Aras Laut Terhadap Kawasan Pesisiran Pantai Negeri Kedah

17 October 2022
Report

Penilaian risiko impak dari peningkatan aras laut terhadap kawasan pesisiran pantai di negeri Kedah

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

Penilaian Risiko Impak Peningkatan Aras Laut Terhadap Kawasan Pesisiran Pantai Negeri Kedah

Chapters

Something went wrong

Search

Latest publication