aboutsummaryrefslogtreecommitdiff
path: root/lib/models/OERMaterial.php
diff options
context:
space:
mode:
authorJan-Hendrik Willms <tleilax+github@gmail.com>2023-05-08 17:08:52 +0200
committerJan-Hendrik Willms <tleilax+github@gmail.com>2023-05-08 17:08:52 +0200
commita1fda2758e9c241ac3eb980ac8716dfedbe9dd3c (patch)
tree2190f0478fb153efdb8ba48ebb574c7691f4f351 /lib/models/OERMaterial.php
parent244d00ed91ad2b4b83e902a45cd6def3d7bc7e86 (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.php12
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]
);
}