modules-available/sysconfig/inc/sysconfig.inc.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

<?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;
	}

}