static function setUpColumns($columns) { $columns->userId = User::columns()->id; $columns->identityId = Identity::columns()->id; $columns->addedAt = Column::INTEGER + Column::UNSIGNED; $columns->priority = Column::INTEGER + Column::SIZE_1B; }
static function setUpColumns($columns) { $columns->id = Column::AUTO_ID; $columns->userId = User::columns()->id; $columns->created = Column::INTEGER + Column::NOT_NULL; $columns->title = Column::STRING + Column::NOT_NULL; $columns->imagesCount = Column::INTEGER + Column::NOT_NULL; $columns->updated = Column::INTEGER + Column::NOT_NULL; }
public function getUsersByIdentityId($identityId) { $users = User::statement()->innerJoin('? ON ? = ? AND ? = ?', UserIdentity::table(), UserIdentity::columns()->userId, User::columns()->id, UserIdentity::columns()->identityId, $identityId)->query()->fetchAll(); return $users; }