public static function getTeachersCountGroupByArea()
{
$result = Yii::$app->db->createCommand('SELECT count(t.id) as count,train.district FROM ' . self::tableName() . ' t LEFT JOIN ' . TrainTeachers::tableName() . ' tt ON t.id = tt.teachers_id LEFT JOIN ' . Train::tableName() . ' train ON tt.train_id = train.id WHERE train.district is not null group by train.district')->queryAll();
return $result;
}
public static function getAllTrainByUserIdAndLevel($userId = '', $LevelId = '')
{
$result = Yii::$app->db->createCommand('SELECT tu.id as id,tu.train_id,t.name,t.category,t.create_time,t.address,t.recruit_count,tu.status,t.begin_time,tu.user_id as train_user_id,t.period_num,t.train_land_id FROM ' . TrainUsers::tableName() . ' tu LEFT JOIN ' . Train::tableName() . ' t ON tu.train_id = t.id WHERE tu.user_id=:user_id AND tu.level_id=:level_id ORDER BY id desc', [':user_id' => $userId, ':level_id' => $LevelId])->queryAll();
return $result;
}
