From afb77d22ba35dfbee74bbbee95626d55edef8898 Mon Sep 17 00:00:00 2001 From: msquare Date: Sun, 10 Dec 2017 18:56:40 +0100 Subject: move room db queries to model --- includes/model/NeededAngelTypes_model.php | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'includes/model/NeededAngelTypes_model.php') diff --git a/includes/model/NeededAngelTypes_model.php b/includes/model/NeededAngelTypes_model.php index d8de5e69..53313fe8 100644 --- a/includes/model/NeededAngelTypes_model.php +++ b/includes/model/NeededAngelTypes_model.php @@ -54,6 +54,19 @@ function NeededAngelTypes_delete_by_room($room_id) ); } +/** + * Returns all needed angeltypes by room. + * + * @param int $room_id + * @return array + */ +function NeededAngelTypes_by_room($room_id) { + return DB::select( + 'SELECT `angel_type_id`, `count` FROM `NeededAngelTypes` WHERE `room_id`=?', + [$room_id] + ); +} + /** * Returns all needed angeltypes and already taken needs. * -- cgit v1.2.3-54-g00ecf