blob: 15bd410412dfb8e00a376ffd3c40457efed5eb21 (
plain) (
tree)
|
|
<?php
class SysConfig
{
public static function getAll()
{
$res = Database::simpleQuery("SELECT c.configid, c.title, c.filepath, c.status, Group_Concat(cl.locationid) AS locs FROM configtgz c"
. " LEFT JOIN configtgz_location cl USING (configid) GROUP BY c.configid");
$ret = array();
while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
$ret[] = $row;
}
return $ret;
}
}
|