Maphper\Lib\SelectBuilder

Complexity

Total Complexity

9

Size/Duplication

Total Lines	19
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	aggregate()	0	4	3
A	select()	0	12	6

<?php
namespace Maphper\Lib;
class SelectBuilder {
	public function select($table, $criteria, $args, $options = []) {
		$where = $criteria ? ' WHERE ' . $criteria : '';
		$limit = (isset($options['limit'])) ? ' LIMIT ' . $options['limit'] : '';

		if (isset($options['offset'])) {
			$offset = ' OFFSET ' . $options['offset'];
			if (!$limit) $limit = ' LIMIT  1000';
		}
		else $offset = '';

		$order = isset($options['order']) ? ' ORDER BY ' . $options['order'] : '';
		return new Query('SELECT * FROM ' . $table . ' ' . $where . $order . $limit . $offset, $args);
	}

	public function aggregate($table, $function, $field, $where, $args, $group) {
		if ($group == true) $groupBy = ' GROUP BY ' . $field;
		else $groupBy = '';
		return new Query('SELECT ' . $function . '(' . $field . ') as val, ' . $field . '   FROM ' . $table . ($where != null ? ' WHERE ' . $where : '') . ' ' . $groupBy, $args);
	}
}