public static function getMessagesByTypeUserId($users_id, $type)
{
$countSql = "SELECT count(mu.id) as count FROM " . self::tableName() . " mu LEFT JOIN " . Messages::tableName() . " m ON mu.messages_id = m.id WHERE mu.users_id=:users_id AND mu.type=:type";
$sql = "SELECT mu.id,m.title,m.create_time,m.create_user,m.type,mu.users_id,mu.status,m.content FROM " . self::tableName() . " mu LEFT JOIN " . Messages::tableName() . " m ON mu.messages_id = m.id WHERE mu.users_id=:users_id AND mu.type=:type";
$count = Yii::$app->db->createCommand($countSql, [':users_id' => $users_id, ':type' => $type])->queryScalar();
$pages = new Pagination(['totalCount' => $count, 'pageSize' => '20']);
$models = Yii::$app->db->createCommand($sql . " limit " . $pages->limit . " offset " . $pages->offset . "", [':users_id' => $users_id, ':type' => $type])->queryAll();
return ['models' => $models, 'pages' => $pages];
}
