ApplicationModel: Join Methodu Genişletilmesi

[gdemir]

JOIN methodu günlük ihtiyaçları karşılayan sadece INNER parametresiyle çalışmakta bunun LEFT, RIGHT, OUTHER olarak genişletilmesi gerekirse WHERE methoduna bakılarak benzer yapı uygulanması.

İlgili fonksiyon: #L294

[gdemir]

// Ör. 1:

// Category ["id", "name"]
// Article ["id", "category_id"]
// Like ["id", "article_id"]
// Comment ["id", "article_id"]
// Tag ["id", "comment_id"]

$categories = Category::load()->joins("article")->take();
$categories = Category::load()->joins(["article"])->take();
$categories = Category::load()->joins(["article" => "comment"])->take();
$categories = Category::load()->joins(["article" => ["comment" => ["tag"]]])->take();
$categories = Category::load()->joins(["article" => ["comment" => ["tag"], "like"]])->take();
$categories = Category::load()->joins(["article" => ["comment" => ["tag"], "like"], "document"])->take();
$categories = Category::load()->joins(["article", "document"])->take();

// Ör. 2:

// Department ["id", "name"]
// User ["id", "department_id", "first_name"]
// Address ["id", "user_id", "content"]

$department = Department::load()
->joins(["user", "address"])
->where("User.id", 1)
->select("User.first_name, Department.name, Address.content")
->limit(1)
->take();
print_r($department);

[gdemir]

left Right gibi opsiyonlar halen çözülmüş değil