Something went wrong

Page ID : 32
Content ID : 90
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'portal.content_newspaper.newspaper_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by The SQL being executed was: SELECT COUNT(*) FROM (SELECT `content_newspaper`.* FROM `content_newspaper` INNER JOIN `content_newspaper_translation` ON content_newspaper.newspaper_id=content_newspaper_translation.newspaper_translation_parent_id WHERE (`content_newspaper_translation`.`newspaper_translation_main` = '1') AND (`content_newspaper`.`newspaper_status` = 'active') AND (MONTH(newspaper_date) = '02') AND (YEAR(newspaper_date) = '2020') GROUP BY MONTH(content_newspaper.newspaper_date), YEAR(content_newspaper.newspaper_date)) `c`
Content :

use yii\helpers\Html;
use yii\grid\GridView;
use yii\helpers\Url;
use yii\helpers\ArrayHelper;
use yii\data\ActiveDataProvider;
use yii\widgets\ActiveForm;
use yii\widgets\ListView;
use backend\modules\contentNewspaper\models\ContentNewspaper;

$search_keyword = Yii::$app->getRequest()->getQueryParam('search_keyword');
$search_year = Yii::$app->getRequest()->getQueryParam('search_year');
$search_month  = Yii::$app->getRequest()->getQueryParam('search_month');

$query = new \yii\db\Query(); 
$query->select(['content_newspaper.*'])->from('content_newspaper')
    ->innerJoin('content_newspaper_translation','content_newspaper.newspaper_id=content_newspaper_translation.newspaper_translation_parent_id')
    ->where(['=','content_newspaper_translation.newspaper_translation_main','1'])
    ->andwhere(['=','content_newspaper.newspaper_status','active']);
    
if(!empty($search_keyword)){
    $label_searching = '<h4 class="mb-40">Paparan keratan akhbar <b>'.$search_keyword.'</b></h4>';
    $query->andfilterwhere(['OR',
        ['LIKE','newspaper_translation_title',$search_keyword],
        ['LIKE','newspaper_translation_content',$search_keyword]
    ]);
}

if(!empty($search_year) || !empty($search_month)){
    $label_searching = '<h4  class="mb-40">Paparan keratan akhbar <b>';
    if(!empty($search_month)){
        $label_searching .= \backend\modules\refdynawebv2\models\Ref::getDesc('MONTH', $search_month, 'descr');
        $query->andfilterwhere(['=','MONTH(newspaper_date)',$search_month]);
    }
    if(!empty($search_year)){
        $label_searching .= ' '.$search_year;
        $query->andfilterwhere(['=','YEAR(newspaper_date)',$search_year]);
    }
    $label_searching .= '</b></h4>';
}
    
$query->orderBy(['content_newspaper.newspaper_date' => SORT_DESC]);
$query->groupBy(['MONTH(content_newspaper.newspaper_date)','YEAR(content_newspaper.newspaper_date)']);
$dataProvider = new ActiveDataProvider([
    'query' => $query,
    'pagination' => ['pageSize' => 4,'route' => 'portal-main/newspaper-list'],
]);

$output = '<style>

.item-container {
    margin:0;
    padding:0;
    width: 100%;
    height: 100%;
    overflow: hidden;
    position: relative;
}

.item-img-holder {
    width: 100%;
    height: 100%;
    background-position: center;
    background-size: auto 100%;
    background-repeat: no-repeat;
    transition: all 1s;
}

.item-img-holder:hover {
    transform: scale(1.2);
}

.widget-search input {
    border:1px solid #aaa;
}
.pagination > li > a, .pagination > li > span {
    border:1px solid #aaa;
}
.pagination > .active > a, .pagination > .active > a:focus, .pagination > .active > a:hover, .pagination > .active > span, .pagination > .active > span:focus, .pagination > .active > span:hover {
    border:1px solid #02536A;
}
</style>
<div class="col-lg-9">';

$output .= $label_searching.ListView::widget([
    'summary' => '',
    'emptyText' => 'Tiada rekod dijumpai.',
    'dataProvider' => $dataProvider,
    'itemOptions' => ['tag' => 'div','class' => 'col-lg-6 col-md-6 col-sm-6',],
    'options' => ['tag' => 'div','class' => 'row',],
    'itemView' => function ($model, $key, $index, $widget) {
        
        
        $newspaperUrl = Url::base(true).'/portal-main/newspaper-details2?month='.date("m", strtotime($model['newspaper_date'])).'&year='.date("Y", strtotime($model['newspaper_date']));
        $newspaperTitle = Yii::t('app', date("F", strtotime($model['newspaper_date']))).' '.date("Y", strtotime($model['newspaper_date']));
        $newpaperTotal = ContentNewspaper::find()
            ->innerJoin('content_newspaper_translation','content_newspaper.newspaper_id=content_newspaper_translation.newspaper_translation_parent_id')
            ->where(['=','content_newspaper_translation.newspaper_translation_main','1'])
            ->andwhere(['=','content_newspaper.newspaper_status','active'])
            ->andwhere(['=','MONTH(content_newspaper.newspaper_date)',date("m", strtotime($model['newspaper_date']))])
            ->andwhere(['=','YEAR(content_newspaper.newspaper_date)',date("Y", strtotime($model['newspaper_date']))])
            ->count();
            
        $modelOne = ContentNewspaper::find()
            ->innerJoin('content_newspaper_translation','content_newspaper.newspaper_id=content_newspaper_translation.newspaper_translation_parent_id')
            ->where(['=','content_newspaper_translation.newspaper_translation_main','1'])
            ->andwhere(['=','content_newspaper.newspaper_status','active'])
            ->andwhere(['=','MONTH(content_newspaper.newspaper_date)',date("m", strtotime($model['newspaper_date']))])
            ->andwhere(['=','YEAR(content_newspaper.newspaper_date)',date("Y", strtotime($model['newspaper_date']))])
            ->orderBy(['content_newspaper.newspaper_date' => SORT_DESC])
            ->one();
            
        $newspaperImg = Url::base(true).'/assets/img/default.png';
        if(!empty($modelOne['newspaper_image']))
            $newspaperImg = Url::base(true).'/admin/'.$modelOne['newspaper_image'];
        
        return '<div class="blog-entry mb-50" style="background: #ffffff;">
        <div class="blog-image-custom item-container">
        <div class="item-img-holder" style="height:300px;background-image:url(\''.$newspaperImg.'\')"></div>
        </div>
                <div class="blog-detail" style="background:#ffffff;background:url('.Url::base(true).'/assets/portal/images/newsbg.png) no-repeat;background-size:100%;background-position:top;">
                    <div class="entry-title mb-10 blog-title-custom">
                        <a href="'.$newspaperUrl.'">'.$newspaperTitle.'</a>
                        <p>'.$newpaperTotal.' keratan akhbar</p>
                    </div>
                </div>
        </div>';
        
    },
]);

$output.= '</div>';

echo $output;

2025 (0)

Januari (0)

Februari (0)

Mac (0)

April (0)

Mei (0)

Jun (0)

Julai (0)

Ogos (0)

September (0)