Advertisement
Guest User

Untitled

a guest
Apr 4th, 2020
174
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.56 KB | None | 0 0
  1. class UserUtilities
  2. {
  3.     static function getHomeworksByUser()
  4.     {
  5.         $query = new Query(UserTable::getEntity());
  6.         $rawData = $query->registerRuntimeField(
  7.             (new OneToMany(
  8.                 "HOMEWORKS", HomeworkTable::class, "Teacher"
  9.             ))->configureJoinType('inner'),
  10.         )->setSelect(array("HOMEWORKS"))
  11.               ->setFilter(array("ID" => 1));
  12.         $ids = [];
  13.         foreach ($rawData->fetchAll() as $row)
  14.         {
  15.             $ids[] = $row["MAIN_USER_HOMEWORKS_ID"];
  16.         }
  17.  
  18.         return HomeworkTable::getList([
  19.             "select" => ["*"],
  20.             "filter" => ["=ID" => $ids]
  21.         ])->fetchCollection();
  22.     }
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement