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

	public static function archiveContentsFromTask($status, &$userGroupWarn = null) : array
	{
		// Sort files for better display
		$dirs = array();
		foreach ($status['data']['entries'] as $file) {
			if ($file['isdir']) continue;
			$dirs[dirname($file['name'])][] = $file;
			if ($file['userId'] > 0 || $file['groupId'] > 0) {
				$userGroupWarn = true;
			}
		}
		ksort($dirs);
		$list = array();
		foreach ($dirs as $dir => $files) {
			$list[] = array(
				'name' => $dir,
				'isdir' => true
			);
			sort($files);
			foreach ($files as $file) {
				$file['size'] = Util::readableFileSize($file['size']);
				$list[] = $file;
			}
		}
		return $list;
	}

}