[OE-2746] converted the main transport controller query to use the Yii ORM.