Penerbitan

Manual & Dokumentasi DYNAWEB4

17 November 2020
Polisi dan Dasar

Manual & Dokumentasi DYNAWEB4

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` = '4') AND ((`version_date_start` = '') OR (`version_date_start` = '0000-00-00') OR (`version_date_start` IS NULL) OR (`version_date_start` <= '2024-04-25')) AND ((`version_date_end` = '') OR (`version_date_end` = '0000-00-00') OR (`version_date_end` IS NULL) OR (`version_date_end` >= '2024-04-25')) 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>';

Penafian Piagam Pelanggan Polisi Privasi Polisi Keselamatan Perlindungan Data Peribadi Soalan Lazim Portal Data Terbuka Malaysia

Jumlah Pelawat 1,622,304
Kemaskini : 25 Apr 2024

ATAS

Dapatkan maklumat korporat, perutusan, sejarah dan lain-lain di sini

Maklumat Korporat

Profil Bahagian

Hubungi Kami

Dapatkan maklumat mengenai cawangan mahkamah di dalam seksyen ini

Mahkamah Syariah Wilayah Persekutuan Kuala Lumpur

Mahkamah Syariah Wilayah Persekutuan Putrajaya

Mahkamah Syariah Wilayah Persekutuan Labuan

Layari galeri media dan penerbitan

Galeri Media

Senarai Penerbitan

Media Sosial

Arkib

Penerbitan

Manual & Dokumentasi DYNAWEB4

Something went wrong

Carian

Penerbitan Terkini

CAWANGAN

Lokasi Kami

Hubungi Kami

Statistik Pelawat