Closed mariusmandal closed 3 years ago
Velg kommune
Setup
Problemet
OBS:
use UKMNorge\Arrangement\Arrangement;
også/**
* Hent alle templates for en rapport (og arrangement)
*
* @param String $rapportID
* @param Arrangement $arrangement
* @param Int $userID
* @return Samling<Template>
*/
public static function getFromRapport(String $rapportID, Arrangement $arrangement, Int $userID)
{
$samling = new Samling();
$query = new Query(
"SELECT *
FROM `ukm_rapport_template`
WHERE `report_id` = '#rapport'
AND (
`pl_id` = '#arrangement'
OR
`user_id` = '#user'
OR
(`omrade_type` = '#omrade_type' AND `omrade_id` = '#omrade_id')
)
ORDER BY `name` ASC",
[
'rapport' => $rapportID,
'arrangement' => $arrangement->getId(),
'user' => $userID,
'omrade_type' => $arrangement->getEierOmrade()->getType(),
'omrade_id' => $arrangement->getEierOmrade()->getForeignId()
]
);
$res = $query->getResults();
while( $row = Query::fetch( $res ) ) {
$samling->add( new Template( $row ) );
}
return $samling;
}
ctrl
+shift
+f
etter getFromRapport
burde funke)
Rapport-maler må følge: