Penerbitan

Laporan Tahunan JPPM Bagi Tahun 2019

31 Disember 2019
Laporan Tahunan

Laporan Tahunan Rasmi 2019 JPPM. Di dalam laporan ini, anda boleh mendapat maklumat tentang semua aktiviti, pencapaian dan statistik JPPM bagi tahun 2019

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` <= '2026-01-18')) AND ((`version_date_end` = '') OR (`version_date_end` = '0000-00-00') OR (`version_date_end` IS NULL) OR (`version_date_end` >= '2026-01-18')) 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", strtotime($row['document_date'])).' '.Yii::t('app', date("F", strtotime($row['document_date']))).' '.date("Y", strtotime($row['document_date']));
        
        
        echo '<h5 class="p-4 m-0">'.$row['document_translation_title'].'</h5>
        <div class="blog-detail text-justify">
            <div class="entry-meta mb-30">
                <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').'</li>
                </ul>
            </div>
            <div class="entry-content">'.$row['document_translation_content'].'</div>';
            
//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'].' muka surat</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">Muat Turun 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">Muat Turun 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.'</p>'.$btnDownload.'</li>';
            }
            echo '</ol>';
        }
        
    }
}
            
        echo '</div>';
    }
}
    echo '</div>
</div>';