protected static function getAllOnID($table, $id)
{
$select = new Select(self::$db);
$select->from($table, "*")->where("`id` = ?", array($id));
$data = self::$db->select($select);
return $data;
}
public function loadRandom()
{
$select = new Select(self::$db);
$select->from(self::$table, "*")->where("`state` =" . self::$db->getSQ(), array(1))->rand()->limit(1);
$row = self::$db->selectRow($select);
return $this->init($row);
}
public function loadRandom()
{
$select = new Select(self::$db);
$select->from(self::$table, "*")->rand()->limit(1);
$row = self::$db->selectRow($select);
return $this->init($row);
}
public static function getImgOnID($id)
{
$select = new Select(self::$db);
$select->from(self::$table, "*")->where("`product_id` = " . self::$db->getSQ(), array($id));
$data = self::$db->select($select);
$images = ObjectDB::buildMultiple(__CLASS__, $data);
return $images;
}
public static function getStudentsOnGroupID($group_id)
{
$select = new Select(self::$db);
$select->from(self::$table, "*")->where("`group_id` = ?", array($group_id));
$data = self::$db->select($select);
$students = ObjectDB::buildMultiple(__CLASS__, $data);
//foreach ($groups as $g) $g->postHandling();
return $students;
}
public static function getItems()
{
$select = new Select(self::$db);
$select->from(self::$table, array("s.*", "p.img"), "s")->join("INNER", "product", "p", "s.product_id = p.id");
$data = self::$db->select($select);
$slider = ObjectDB::buildMultiple(__CLASS__, $data);
foreach ($slider as $slide) {
$slide->postHandling();
}
return $slider;
}
public static function getItemsOnView($view)
{
$select = new Select(self::$db);
$select->from(self::$table, "*")->where("`view_id` = ?", array($view));
$data = self::$db->select($select);
$items = ObjectDB::buildMultiple(__CLASS__, $data);
foreach ($items as $item) {
$item->postHandling();
}
return $items;
}
public static function getGroupsOnTeacherID($id)
{
$select = new Select(self::$db);
$select->from(self::$table, "*")->where("`teacher_id` = ?", array($id));
$data = self::$db->select($select);
$groups = ObjectDB::buildMultiple(__CLASS__, $data);
foreach ($groups as $g) {
$g->postHandling();
}
return $groups;
}
public static function getIdonNumder($number)
{
$select = new Select(self::$db);
$select->from(self::$table, array("id"))->where("`number` = ?", array($number));
$id = self::$db->selectCell($select);
if (!$id) {
$select = new Select(self::$db);
$select->from(self::$table, array("id"))->where("`parent_number` = ?", array($number));
$id = self::$db->selectCell($select);
}
return $id;
}
public function loadOnSectionID($section_id, $type)
{
$select = new Select();
$select->from(self::$table, "*")->where("`type` = " . self::$db->getSQ(), array($type))->where("`latest` = " . self::$db->getSQ(), array(1))->rand();
$data_1 = self::$db->select($select);
$select = new Select();
$select->from(self::$table, "*")->where("`type` = " . self::$db->getSQ(), array($type));
if ($section_id) {
$select->whereFIS("section_ids", $section_id);
}
$select->rand();
$data_2 = self::$db->select($select);
$data = array_merge($data_1, $data_2);
if (count($data) == 0) {
$select = new Select();
$select->from(self::$table, "*")->where("`type` = " . self::$db->getSQ(), array($type))->rand();
$data = self::$db->select($select);
}
$data = ObjectDB::buildMultiple(__CLASS__, $data);
uasort($data, array(__CLASS__, "compare"));
$first = array_shift($data);
$this->load($first->id);
}
public static function authAdmin($login = false, $password = false)
{
if ($login) {
$auth = true;
} else {
if (!session_id()) {
session_start();
}
if (!empty($_SESSION["auth_login"]) && !empty($_SESSION["auth_password"])) {
$login = $_SESSION["auth_login"];
$password = $_SESSION["auth_password"];
} else {
return;
}
$auth = false;
}
$user = new AdminDB();
if ($auth) {
$password = self::hash($password, Config::SECRET);
}
$select = new Select();
$select->from(self::$table, array("COUNT(id)"))->where("`login` = " . self::$db->getSQ(), array($login))->where("`password` = " . self::$db->getSQ(), array($password));
$count = self::$db->selectCell($select);
if ($count) {
$user->loadOnLogin($login);
if ($user->activation != "") {
throw new Exception("ERROR_ACTIVATE_USER");
}
if ($auth) {
$user->login();
}
return $user;
}
if ($auth) {
throw new Exception("ERROR_AUTH_USER");
}
}
public static function isAlreadyPoll($poll_data_ids)
{
$select = new Select(self::$db);
$select->from(self::$table, array("id"))->whereIn("poll_data_id", $poll_data_ids)->where("`ip` = " . self::$db->getSQ(), array(ip2long($_SERVER["REMOTE_ADDR"])))->limit(1);
return self::$db->selectCell($select) ? true : false;
}
public static function getCountOnArticleID($article_id)
{
$select = new Select(self::$db);
$select->from(self::$table, array("COUNT(id)"))->where("`article_id` = " . self::$db->getSQ(), array($article_id));
return self::$db->selectCell($select);
}
}
if (!empty($this->_select['where'])) {
$sql .= ' WHERE ' . $this->_select['where'];
}
if (count($this->_select['and'])) {
$sql .= ' AND ' . join(' AND ', $this->_select['and']);
}
if (count($this->_select['or'])) {
$sql .= ' OR ' . join(' OR ', $this->_select['and']);
}
if (!empty($this->_select['limit'])) {
$sql .= ' LIMIT ' . $this->_select['limit'];
}
return $sql;
}
public function fetchAll()
{
$sql = $this->_buildSQL();
echo $sql, '<br/><br/>';
}
function fetchOne()
{
print_r($this->_select);
$this->_select['limit'] = '0,1';
$sql = $this->_buildSQL();
echo $sql, '<br/><br/>';
}
}
$s1 = new Select();
$s1->from('aa')->fields('a,b')->fetchAll();
$s1->from('aa')->fields('a,b')->fetchOne();
public static function issetAliasOnLink($link)
{
$select = new Select(self::$db);
$select->from(self::$table, "*")->where("`category_id` = ?", array($link));
$data = self::$db->select($select);
}
protected function loadOnField($field, $value)
{
//загрузить по какому то значению (пользователя по логину или т.д.)
$select = new Select();
$select->from($this->table_name, "*")->where("`{$field}` = " . self::$db->getSQ(), array($value));
$row = self::$db->selectRow($select);
if ($row) {
if ($this->init($row)) {
return $this->postLoad();
}
}
return false;
}
private static function getBaseSelect()
{
$select = new Select(self::$db);
$select->from(self::$table, "*");
return $select;
}
public static function authUser($login = false, $password = false)
{
if ($login) {
$auth = true;
} else {
//значит проверка данных в сесии
if (!session_id()) {
session_start();
}
//стартуем сесию
if (!empty($_SESSION["auth_login"]) && !empty($_SESSION["auth_password"])) {
//если логин и пароль не пустые
$login = $_SESSION["auth_login"];
//то данные берутся из сесии
$password = $_SESSION["auth_password"];
} else {
return;
}
//если не авторизация и данные не из сесии значит вазвращаемся
$auth = false;
//а авторизация false
}
$user = new UserDB();
if ($auth) {
$password = self::hash($password, Config::SECRET);
}
//если авторизация переданный пароль хэшеруем
$select = new Select();
//ищем пользователя отвечаютщего запросу (соответствие логина пароля)
$select->from(self::$table, array("COUNT(id)"))->where("`login` = " . self::$db->getSQ(), array($login))->where("`password` = " . self::$db->getSQ(), array($password));
$count = self::$db->selectCell($select);
//ищем количество соответствующих (логину паролю)пользователей
if ($count) {
$user->loadOnLogin($login);
//загружаем пользователя
if ($user->activation != "") {
throw new Exception("ERROR_ACTIVATE_USER");
}
//если пользователь не активированн выводим ошибку
if ($auth) {
$user->login();
}
//если авторизация делаем логин
return $user;
//возвращаем юзера
}
if ($auth) {
throw new Exception("ERROR_AUTH_USER");
}
//возвращаем ошибку если не был найден пользователем с таким логином и паролем
}
public static function getBrandIDonName($name)
{
$select = new Select();
$select->from(self::$table, array("id"))->where("title = ?", array($name));
return self::$db->selectCell($select);
}
/**
* Returns an instance of a Select object.
*
* @param string|array|Expr $columns
* @return Select
*/
public function selectCol($columns = null)
{
$select = new Select($this->_db);
$select->setTable($this);
$select->from($this->_name, $columns === null ? Select::SQL_WILDCARD : $columns, $this->_schema);
return $select;
}
public static function getLinkOnAlias($alias)
{
$select = new Select(self::$db);
$select->from(self::$table, array("link"))->where("`alias` = " . self::$db->getSQ(), array($alias));
return self::$db->selectCell($select);
}
public function loadOnField($field, $value)
{
$select = new Select();
$select->from($this->table_name, "*")->where("`{$field}` = " . self::$db->getSQ(), array($value));
$row = self::$db->selectRow($select);
if ($row) {
if ($this->init($row)) {
return $this->postLoad();
}
}
return false;
}
