diff options
| author | Jan-Hendrik Willms <tleilax+github@gmail.com> | 2023-05-08 17:08:52 +0200 |
|---|---|---|
| committer | Jan-Hendrik Willms <tleilax+github@gmail.com> | 2023-05-08 17:08:52 +0200 |
| commit | a1fda2758e9c241ac3eb980ac8716dfedbe9dd3c (patch) | |
| tree | 2190f0478fb153efdb8ba48ebb574c7691f4f351 /lib/models/OERMaterial.php | |
| parent | 244d00ed91ad2b4b83e902a45cd6def3d7bc7e86 (diff) | |
let phpcsfixer fix errors according to @PSR12 rules on lib/modelsphpcsfixer
Diffstat (limited to 'lib/models/OERMaterial.php')
| -rw-r--r-- | lib/models/OERMaterial.php | 12 |
1 files changed, 8 insertions, 4 deletions
diff --git a/lib/models/OERMaterial.php b/lib/models/OERMaterial.php index 911aaa2..6786bd3 100644 --- a/lib/models/OERMaterial.php +++ b/lib/models/OERMaterial.php @@ -70,10 +70,12 @@ class OERMaterial extends SimpleORMap public static function findMine($user_id = null) { $user_id = $user_id ?: $GLOBALS['user']->id; - return self::findBySQL("INNER JOIN `oer_material_users` USING (material_id) + return self::findBySQL( + "INNER JOIN `oer_material_users` USING (material_id) WHERE `oer_material_users`.user_id = ? AND external_contact = '0' - ORDER BY mkdate DESC", [$user_id] + ORDER BY mkdate DESC", + [$user_id] ); } @@ -138,11 +140,13 @@ class OERMaterial extends SimpleORMap if ($tag) { self::fetchRemoteSearch($tag['name'], true); } - return self::findBySQL("INNER JOIN oer_tags_material USING (material_id) + return self::findBySQL( + "INNER JOIN oer_tags_material USING (material_id) LEFT JOIN oer_hosts ON (oer_hosts.host_id = oer_material.host_id) WHERE oer_tags_material.tag_hash = ? AND (oer_material.host_id IS NULL OR oer_hosts.`active` = '1') - AND draft = '0'", [$tag_hash] + AND draft = '0'", + [$tag_hash] ); } |
