public static function getStartables()
{
if (is_null(self::$startables) || !is_array(self::$startables)) {
self::$startables = array();
QueryBuilder::create(SQL::getConnection())->withQuery("SELECT id, display_name, folder_name, executable FROM websites")->build()->forEachResult(function ($row) {
self::$startables[] = new Startables($row['id'], $row['display_name'], $row['folder_name'], $row['executable']);
});
if (count(self::$startables) == 0) {
throw new Exception("lol");
}
}
return self::$startables;
}
if ($webId == "-1") {
// Update all
foreach (Website::getAllWebsites() as $site) {
echoSite($site);
}
} else {
// Update single site
QueryBuilder::create(SQL::getConnection())->withQuery("SELECT display_name, folder_name FROM websites WHERE id = ?")->withParam($webId, QueryBuilder::PARAM_TYPE_INT)->build()->forEachResult(function ($row) {
$site = new Website(0, $row['display_name'], $row['folder_name']);
echoSite($site);
});
}
} else {
function echoStart(Startables $starter)
{
echo $starter->getName() . ":\r\n";
echo $starter->start() . "\r\n";
}
$webId = $_GET['start-id'];
/*if ($webId == "-1") {
// Update all
foreach (Website::getAllWebsites() as $site) {
echoSite($site);
}
} else {*/
// Update single site
QueryBuilder::create(SQL::getConnection())->withQuery("SELECT display_name, folder_name, executable FROM websites WHERE id = ?")->withParam($webId, QueryBuilder::PARAM_TYPE_INT)->build()->forEachResult(function ($row) {
$starter = new Startables(0, $row['display_name'], $row['folder_name']);
echoStart($starter);
});
}
public static function fromArray($arr, $dbInstance)
{
$table = null;
$cols = "";
$where = null;
$groupby = null;
$orderby = null;
$limit = FALSE;
$table = $arr['table'];
$cols = $arr['cols'];
if (isset($arr['where'])) {
$where = $arr['where'];
}
if (isset($arr['groupby'])) {
$groupby = $arr['groupby'];
}
if (isset($arr['orderby'])) {
$orderby = $arr['orderby'];
}
if (isset($arr['limits'])) {
$limit = $arr['limits'];
}
if (is_array($table)) {
$obj = QueryBuilder::fromArray($table, $dbInstance);
$table = $obj->_SQL();
}
$objx = QueryBuilder::create($dbInstance)->_selectQ($table, $cols);
$objx = $objx->_where($where);
if (isset($arr['join'])) {
foreach ($arr['join'] as $jn) {
$query = $jn['query'];
$condition = $jn['condition'];
$as = $jn['as'];
$type = $jn['type'];
$objx = $objx->_join($query, $condition, $as, $type);
}
}
$objx = $objx->_groupby($groupby);
$objx = $objx->_orderby($orderby);
$objx = $objx->_limit($limit);
return $objx;
}
public static function fromArray($arr, $dbInstance)
{
if (!is_a($dbInstance, "Database")) {
trigger_logikserror("Database ERROR, DBInstance should be an object of Database");
}
$table = null;
$cols = "";
$where = null;
$groupby = null;
$having = null;
$orderby = null;
$index = 0;
$limit = FALSE;
$table = $arr['table'];
$cols = $arr['cols'];
if (isset($arr['where'])) {
$where = $arr['where'];
}
if (isset($arr['groupby'])) {
$groupby = $arr['groupby'];
}
if (isset($arr['having'])) {
$having = $arr['having'];
}
if (isset($arr['orderby'])) {
$orderby = $arr['orderby'];
}
if (isset($arr['limit'])) {
$limit = $arr['limit'];
}
if (isset($arr['index'])) {
$index = $arr['index'];
}
if (is_array($table)) {
$obj = QueryBuilder::fromArray($table, $dbInstance);
$table = $obj->_SQL();
}
$objx = QueryBuilder::create($dbInstance)->_selectQ($table, $cols, $where);
//$objx->_where($where);
if (isset($arr['join'])) {
foreach ($arr['join'] as $jn) {
$query = $jn['query'];
$condition = $jn['condition'];
$as = $jn['as'];
$type = $jn['type'];
$objx->_join($query, $condition, $as, $type);
}
}
$objx->_groupby($groupby, $having);
$objx->_orderby($orderby);
$objx->_limit($limit, $index);
return $objx;
}
/**
* I mean... It's hard to not understand what this does.
* @return QueryBuilder
*/
public static function createQueryBuilder()
{
self::getConnection();
return QueryBuilder::create(self::$connection);
}
