private function add_version($number)
{
if ($this->hasVersionLog()) {
$this->db->query("INSERT INTO {{%version}} SET ver_version={$number}, ver_timestamp=NOW()");
} else {
$this->db->query("UPDATE {{%version}} SET ver_version={$number}");
}
}
public function AddNewUser($username, $salt, $hashedPassword, $email)
{
$sql = "INSERT INTO user (username, email, generated_salt, password_hash)\n VALUES (?, ?, ?, ?)";
$query = DbInterface::NewQuery($sql);
$query->AddStringParam($username);
$query->AddStringParam($email);
$query->AddStringParam($salt);
$query->AddStringParam($hashedPassword);
return $query->TryExecuteInsert();
}
private function addFilter(&$query, $id, $active, $category_id, $name, $slug, $order_type)
{
if ($id !== NULL) {
$query .= " AND id = '" . DataHandler::forceInt($id) . "'";
}
if ($active !== NULL) {
$query .= " AND `active` = '" . DataHandler::forceInt($active) . "'";
}
if ($category_id !== NULL) {
$query .= " AND `category_id` = '" . DataHandler::forceInt($category_id) . "'";
}
if ($name !== NULL) {
$query .= " AND `name` = '" . DataHandler::forceString($name) . "'";
}
if ($slug !== NULL) {
$query .= " AND `slug` = '" . DataHandler::forceString($slug) . "'";
}
//adiciona a ordenação na query
$orderBy = "";
if ($order_type != NULL) {
$order_type = parent::verifyOrderType($order_type);
$orderBy .= " `order` " . $order_type;
}
if ($orderBy != NULL) {
$query .= " ORDER BY " . $orderBy;
}
}
/**
* @param $table
* @param $table_id
* @param $typeOfReturn
* @param $quant_limit
* @param $quant_started
* @return $ReturnDataVO
*/
public function selectByTableId($table, $table_id, $typeOfReturn = ContentDAO::RETURN_STD_OBJECT, $quant_limit = NULL, $quant_started = NULL, $active = 1, $search = "", $order_colunm = "order", $order_type = "ASC")
{
$search_query = "";
if ($search != "") {
$search = DataHandler::forceString($search);
$search_query = " AND\r\n\t\t\t\t\t\t\t\t(`content`.`title` LIKE '{$search}' OR\r\n\t\t\t\t\t\t\t\t`content`.`content` LIKE '{$search}' \r\n\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t";
}
$query = "\r\n\t\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\t\t`content`.*,\r\n\t\t\t\t\t\t\t\t`" . $table . "`.id as " . $table . "_id\r\n\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t " . $table . "\r\n\t\t\t\t\t\t\tINNER JOIN \r\n\t\t\t\t\t\t\t `link`\r\n\t\t\t\t\t\t\t ON \r\n\t\t\t\t\t\t\t `link`.table = '" . $table . "' AND\r\n\t\t\t\t\t\t\t `link`.linked_table = 'content' AND\r\n\t\t\t\t\t\t\t `link`.table_id = `" . $table . "`.id AND\r\n\t\t\t\t\t\t\t `link`.active = " . $active . "\r\n\t\t\t\t\t\t\tINNER JOIN \r\n\t\t\t\t\t\t\t `content`\r\n\t\t\t\t\t\t\t ON \r\n\t\t\t\t\t\t\t `content`.id = linked_table_id \r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t 1 AND\r\n\t\t\t\t\t\t\t `" . $table . "`.id = '" . $table_id . "' AND\r\n\t\t\t\t\t\t\t `" . $table . "`.active = " . $active . "\r\n\t\t\t\t\t\t\t {$search_query}\r\n\t\t\t\t\t\t\t ORDER BY `link`.{$order_colunm} {$order_type}\r\n\t\t\t\t\t\t";
$queryCount = "\r\n\t\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\t\tCOUNT(*) AS count\r\n\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t " . $table . "\r\n\t\t\t\t\t\t\tINNER JOIN \r\n\t\t\t\t\t\t\t `link`\r\n\t\t\t\t\t\t\t ON \r\n\t\t\t\t\t\t\t `link`.table = '" . $table . "' AND\r\n\t\t\t\t\t\t\t `link`.linked_table = 'content' AND\r\n\t\t\t\t\t\t\t `link`.table_id = `" . $table . "`.id AND\r\n\t\t\t\t\t\t\t `link`.active = " . $active . "\r\n\t\t\t\t\t\t\tINNER JOIN \r\n\t\t\t\t\t\t\t `content`\r\n\t\t\t\t\t\t\t ON \r\n\t\t\t\t\t\t\t `content`.id = linked_table_id \r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t 1 AND\r\n\t\t\t\t\t\t\t `" . $table . "`.id = '" . $table_id . "' AND\r\n\t\t\t\t\t\t\t `" . $table . "`.active = " . $active . "\r\n\t\t\t\t\t\t\t {$search_query}\r\n\t\t\t\t\t\t";
//limite
$query .= parent::limit($quant_limit, $quant_started);
//executa a query
$ReturnDataVO = parent::query($query);
//echo $query;
//executa a query para gerar count total
$ReturnTotalDataVO = parent::query($queryCount);
if ($ReturnDataVO->success) {
switch ($typeOfReturn) {
case DbInterface::RETURN_ARRAY:
$ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_ARRAY);
break;
case DbInterface::RETURN_VO:
$ReturnDataVO->fetchAllVO($this);
break;
case DbInterface::RETURN_STD_OBJECT:
default:
//retornar tudo em objeto
$ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT);
break;
}
$ReturnTotalDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT);
$tempTotal = $ReturnTotalDataVO->result[0]->count;
$ReturnDataVO->count_total = $tempTotal;
//echo Debug::print_r($ReturnDataVO);
return $ReturnDataVO;
} else {
return $ReturnDataVO;
}
}
/**
* @param DbInterface $conn
* @return array
*/
function getTableList($conn)
{
$tables = $conn->getColumn('SHOW TABLES');
// FIXME: why lowercase neccessary?
$tables = Misc::lowercase($tables);
return $tables;
}
public function init()
{
$returnResult = new HttpResult();
$returnResult->setSuccess(1);
//iniciando o resultado para o html
$retornoDaPaginaHTML = new HttpMenu();
//inicia a variavel de consulta de obj para cache
$obj = NULL;
$save_cache = TRUE;
$cache_base_folder = "cache/menu/init/";
if (Config::USE_QUERY_CACHE) {
//verifica se tem cache
$cache_folder = $cache_base_folder;
$cache_file = md5(implode("/", $this->arrayRestFolder));
/*
Debug::print_r($this->arrayRestFolder);
echo Debug::li($cache_file);
*/
$cache_location = $cache_folder . $cache_file;
if (file_exists($cache_location)) {
$resultSerial = unserialize(file_get_contents($cache_location));
//return $resultSerial;
$obj = $resultSerial;
$save_cache = FALSE;
}
}
//o cache não está gravado
if ($obj == NULL) {
$obj = $this;
//pedindo para consultar
$this->consultValues();
}
$retornoDaPaginaHTML->arrayMaterial = $obj->arrayMaterial->result;
$retornoDaPaginaHTML->arrayColor = $obj->arrayColor->result;
$retornoDaPaginaHTML->arrayStyle = $obj->arrayStyle->result;
$retornoDaPaginaHTML->arrayFormat = $obj->arrayFormat->result;
$retornoDaPaginaHTML->arrayTheme = $obj->arrayTheme->result;
$retornoDaPaginaHTML->arrayComposition = $obj->arrayComposition->result;
$retornoDaPaginaHTML->arrayTechnique = $obj->arrayTechnique->result;
$retornoDaPaginaHTML->arrayType = $obj->arrayType->result;
$botaoPromocoes = new stdClass();
$botaoPromocoes->name = "em promoção";
//echo Debug::li($this->currentQuery);exit();
if (!$this->currentQuery) {
$this->currentQuery = "SELECT count( DISTINCT `view_product_model_quadro_b`.id) as count FROM `view_product_model_quadro_b` WHERE 1 AND view_product_model_quadro_b.`active` = '1'";
}
$queryPromocao = $this->currentQuery . " AND promocao = 1 ";
//oic 2
$dbi = new DbInterface();
$rt = $dbi->query($queryPromocao);
//echo Debug::li($this->currentQuery);
if (isset($_GET["teste"])) {
Debug::print_r($rt);
}
$rt->fetchAll();
//Debug::print_r($rt);exit();
$botaoPromocoes->id = 1;
$botaoPromocoes->total = $rt->result[0]->count;
//total de produtos em promoção
$retornoDaPaginaHTML->arrayPromocoes = array($botaoPromocoes);
$retornoDaPaginaHTML->requestMaterial = $obj->requestMaterial;
$retornoDaPaginaHTML->requestColor = $obj->requestColor;
$retornoDaPaginaHTML->requestStyle = $obj->requestStyle;
$retornoDaPaginaHTML->requestFormat = $obj->requestFormat;
$retornoDaPaginaHTML->requestTheme = $obj->requestTheme;
$retornoDaPaginaHTML->requestComposition = $obj->requestComposition;
$retornoDaPaginaHTML->requestTechnique = $obj->requestTechnique;
$retornoDaPaginaHTML->requestType = $obj->requestType;
$retornoDaPaginaHTML->requestSearch = $obj->requestSearch;
$retornoDaPaginaHTML->requestResumeSearch = $obj->requestResumeSearch;
$retornoDaPaginaHTML->requestPromocao = $obj->requestPromocao;
$retornoDaPaginaHTML->arrayRestFolder = $this->arrayRestFolder;
$retornoDaPaginaHTML->arrayVariable = $this->arrayVariable;
$retornoDaPaginaHTML->url_final = $obj->url_final;
//salvando o objeto de resultado de html no retorno
$returnResult->setHttpContentResult($retornoDaPaginaHTML);
// -------------------------------------------------------------------[ BREAD CRUMB ]
// Agora criando a array de bread crumb
$retornoDaPaginaHTML->arrayBreadCrumb = $this->arrayBreadCrumb;
// E também popula os títulos, que até então ele não tinha como pegar
foreach ($retornoDaPaginaHTML->arrayBreadCrumb as $BreadCrumbInfoVO) {
//pelo tipo de item e id ele ve o nome
if (FALSE) {
//apenas para o auto completar do eclipse
$BreadCrumbInfoVO = new BreadCrumbInfoVO();
}
$BreadCrumbInfoVO->tittle = $retornoDaPaginaHTML->getNameByTypeAndId($BreadCrumbInfoVO->reference, $BreadCrumbInfoVO->id);
}
if (Config::USE_QUERY_CACHE && $save_cache) {
//grava o cache
DataHandler::createRecursiveFoldersIfNotExists($cache_folder);
//criando obj simplificado para serializar
$stdObj = new stdClass();
$stdObj->arrayMaterial = $obj->arrayMaterial;
$stdObj->arrayColor = $obj->arrayColor;
$stdObj->arrayStyle = $obj->arrayStyle;
$stdObj->arrayFormat = $obj->arrayFormat;
$stdObj->arrayTheme = $obj->arrayTheme;
$stdObj->arrayComposition = $obj->arrayComposition;
$stdObj->arrayTechnique = $obj->arrayTechnique;
$stdObj->arrayType = $obj->arrayType;
$stdObj->requestMaterial = $obj->requestMaterial;
$stdObj->requestColor = $obj->requestColor;
$stdObj->requestStyle = $obj->requestStyle;
$stdObj->requestFormat = $obj->requestFormat;
$stdObj->requestTheme = $obj->requestTheme;
$stdObj->requestComposition = $obj->requestComposition;
$stdObj->requestTechnique = $obj->requestTechnique;
$stdObj->requestType = $obj->requestType;
$stdObj->requestSearch = $obj->requestSearch;
$stdObj->requestResumeSearch = $obj->requestResumeSearch;
$stdObj->requestPromocao = $obj->requestPromocao;
$stdObj->url_final = $obj->url_final;
DataHandler::writeFile($cache_folder, $cache_file, serialize($stdObj));
}
return $returnResult;
}
/**
* @param $table
* @param $table_id
* @param $typeOfReturn
* @param $quant_limit
* @param $quant_started
* @return $ReturnDataVO
*/
public function selectByTableId($table, $table_id, $typeOfReturn = HighLightsDAO::RETURN_STD_OBJECT, $quant_limit = NULL, $quant_started = NULL)
{
$query = "\r\n\t\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\t\t`highlights`.*,\r\n\t\t\t\t\t\t\t\t`" . $table . "`.id as " . $table . "_id\r\n\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t " . $table . "\r\n\t\t\t\t\t\t\tINNER JOIN \r\n\t\t\t\t\t\t\t `link`\r\n\t\t\t\t\t\t\t ON \r\n\t\t\t\t\t\t\t `link`.table = '" . $table . "' AND\r\n\t\t\t\t\t\t\t `link`.linked_table = 'highlights' AND\r\n\t\t\t\t\t\t\t `link`.table_id = `" . $table . "`.id\r\n\t\t\t\t\t\t\tINNER JOIN \r\n\t\t\t\t\t\t\t `highlights`\r\n\t\t\t\t\t\t\t ON \r\n\t\t\t\t\t\t\t `highlights`.id = linked_table_id \r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t 1 AND\r\n\t\t\t\t\t\t\t `" . $table . "`.id = '" . $table_id . "'\r\n\t\t\t\t\t\t";
$queryCount = "\r\n\t\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\t\tCOUNT(*) AS count\r\n\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t " . $table . "\r\n\t\t\t\t\t\t\tINNER JOIN \r\n\t\t\t\t\t\t\t `link`\r\n\t\t\t\t\t\t\t ON \r\n\t\t\t\t\t\t\t `link`.table = '" . $table . "' AND\r\n\t\t\t\t\t\t\t `link`.linked_table = 'highlights' AND\r\n\t\t\t\t\t\t\t `link`.table_id = `" . $table . "`.id\r\n\t\t\t\t\t\t\tINNER JOIN \r\n\t\t\t\t\t\t\t `highlights`\r\n\t\t\t\t\t\t\t ON \r\n\t\t\t\t\t\t\t `highlights`.id = linked_table_id \r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t 1 AND\r\n\t\t\t\t\t\t\t `" . $table . "`.id = '" . $table_id . "'\r\n\t\t\t\t\t\t";
//limite
$query .= parent::limit($quant_limit, $quant_started);
//executa a query
$ReturnDataVO = parent::query($query);
//echo $query;
//executa a query para gerar count total
$ReturnTotalDataVO = parent::query($queryCount);
if ($ReturnDataVO->success) {
switch ($typeOfReturn) {
case DbInterface::RETURN_ARRAY:
$ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_ARRAY);
break;
case DbInterface::RETURN_VO:
$ReturnDataVO->fetchAllVO($this);
break;
case DbInterface::RETURN_STD_OBJECT:
default:
//retornar tudo em objeto
$ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT);
break;
}
$ReturnTotalDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT);
$tempTotal = $ReturnTotalDataVO->result[0]->count;
$ReturnDataVO->count_total = $tempTotal;
//echo Debug::print_r($ReturnDataVO);
return $ReturnDataVO;
} else {
return $ReturnDataVO;
}
}
/**
* @param DbInterface $conn
* @return array
*/
function getTableList($conn)
{
$tables = $conn->getColumn('SHOW TABLES');
// FIXME: why lowercase neccessary?
$tables = array_map(function ($s) {
return strtolower($s);
}, $tables);
return $tables;
}
function unregisterConnection(DbInterface $connection)
{
unset($this->connections[$connection->getConnectionId()]);
}
private function addFilter(&$query, $id = NULL, $address_id = NULL, $name = NULL, $last_name = NULL, $birthday = NULL, $mobile = NULL, $telephone = NULL, $email = NULL, $rg = NULL, $cpf = NULL, $company = NULL, $website = NULL, $sex = NULL, $recive_news = NULL, $registred = NULL, $user_type_id = NULL, $date = NULL, $date_symbol = ">=")
{
if ($id !== NULL) {
$query .= " AND user.id = '" . DataHandler::forceInt($id) . "'";
}
if ($name !== NULL) {
$query .= " AND `name` LIKE '%" . DataHandler::forceString($name) . "%'";
}
if ($last_name !== NULL) {
$query .= " AND `last_name` ='" . DataHandler::forceString($last_name) . "'";
}
if ($birthday !== NULL) {
$query .= " AND `birthday` =" . $this->dateHandlerScape($birthday);
}
if ($mobile !== NULL) {
$query .= " AND `mobile` ='" . DataHandler::forceString($mobile) . "'";
}
if ($telephone !== NULL) {
$query .= " AND `telephone` ='" . DataHandler::forceString($telephone) . "'";
}
if ($email !== NULL) {
$query .= " AND `email` ='" . DataHandler::forceString($email) . "'";
}
if ($rg !== NULL) {
$query .= " AND `rg` ='" . DataHandler::forceString($rg) . "'";
}
if ($cpf !== NULL) {
$query .= " AND `cpf` ='" . DataHandler::forceString($cpf) . "'";
}
if ($company !== NULL) {
$query .= " AND `company` ='" . DataHandler::forceString($company) . "'";
}
if ($website !== NULL) {
$query .= " AND `website` ='" . DataHandler::forceString($website) . "'";
}
if ($sex !== NULL) {
$query .= " AND `sex` ='" . DataHandler::forceInt($sex) . "'";
}
if ($recive_news !== NULL) {
$query .= " AND `recive_news` ='" . DataHandler::forceInt($recive_news) . "'";
}
if ($registred !== NULL) {
$query .= " AND `registred` =" . $this->dateHandlerScape($registred) . "";
}
if ($user_type_id != NULL) {
$query .= " AND `user_type_id` =" . DataHandler::forceInt($user_type_id) . "";
}
if ($date !== NULL) {
$date_symbol = parent::compareSimble($date_symbol);
$date = parent::dateHandlerScape(DataHandler::convertDateToDB($date));
$query .= " AND `registred` {$date_symbol} {$date} ";
}
}
public function contAll($table, $table_id, $active = 1)
{
if ($table == NULL || $table_id == NULL) {
$ReturnDataVO = new ReturnDataVO();
$ReturnDataVO->success = FALSE;
$ReturnDataVO->code_return = DbInterface::ERROR_LINK_DONOT_HAVE_TABLE_OR_TABLE_ID;
return $ReturnDataVO;
}
$query = "SELECT count(*) AS quantidade\tFROM `link` WHERE \r\n\t\t\t\t\t\t\t\t\t`table` = '" . $table . "'\r\n\t\t\t\t\t\t\t\tAND\r\n\t\t\t\t\t\t\t\t\t`table_id` = '" . $table_id . "'\r\n\t\t\t\t\t\t\t\tAND \r\n\t\t\t\t\t\t\t\t\t`active` = '" . $active . "'\r\n\t\t\t\t\t\t\t";
$ReturnDataVO = parent::query($query);
if ($ReturnDataVO->success) {
$ReturnDataVO = $this->typeOfFetch($ReturnDataVO);
$ReturnDataVO->result = $ReturnDataVO->result[0]["quantidade"];
return $ReturnDataVO;
} else {
return $ReturnDataVO;
}
}
/**
* Processes a SQL statement by quoting table and column names that are enclosed within double brackets.
* Tokens enclosed within double curly brackets are treated as table names, while
* tokens enclosed within double square brackets are column names. They will be quoted accordingly.
* Also, the percentage character "%" at the beginning or ending of a table name will be replaced
* with [[tablePrefix]].
*
* @param DbInterface $db
* @param string $tablePrefix
* @param string $sql
* @return string
* @see https://github.com/yiisoft/yii2/blob/2.0.0/framework/db/Connection.php#L761-L783
* @internal
*/
public static function quoteTableName(DbInterface $db, $tablePrefix, $sql)
{
$sql = preg_replace_callback('/(\\{\\{(%?[\\w\\-\\. ]+%?)\\}\\}|\\[\\[([\\w\\-\\. ]+)\\]\\])/', function ($matches) use($db, $tablePrefix) {
if (isset($matches[3])) {
return $db->quoteIdentifier($matches[3]);
} else {
return str_replace('%', $tablePrefix, $db->quoteIdentifier($matches[2]));
}
}, $sql);
return $sql;
}
public function contAll($table, $table_id, $active = 1)
{
$query = "SELECT count(*) AS quantidade\tFROM therm WHERE \r\n\t\t\t\t\t\t\t\t\t`table` = '" . $table . "'\r\n\t\t\t\t\t\t\t\tAND\r\n\t\t\t\t\t\t\t\t\t`table_id` = '" . $table_id . "'\r\n\t\t\t\t\t\t\t\tAND \r\n\t\t\t\t\t\t\t\t\t`active` = '" . $active . "'\r\n\t\t\t\t\t\t\t";
$ReturnDataVO = parent::query($query);
if ($ReturnDataVO->success) {
$ReturnDataVO = $this->typeOfFetch($ReturnDataVO);
$ReturnDataVO->result = $ReturnDataVO->result[0]["quantidade"];
return $ReturnDataVO;
} else {
return $ReturnDataVO;
}
}
/**
* @param $typeOfReturn
* @param $id
* @param $active
* @param $user_type_id
* @param $login
* @param $password
* @param $email_type
* @param $quant_limit
* @param $quant_started
* @return ReturnDataVO (ReturnDataVO)
*/
public function select($typeOfReturn = NULL, $id = NULL, $active = NULL, $user_type_id = NULL, $login = NULL, $password = NULL, $email = NULL, $quant_limit = NULL, $quant_started = NULL)
{
$arrayFilter = array();
$query = "SELECT \r\n\t\t\t\t\t\t*\r\n\t\t\t\t\t\tFROM \r\n\t\t\t\t\t \tuser \r\n\t\t\t\t\t WHERE 1 ";
$this->addFilter($query, $id, $active, $user_type_id, $login, $password, $email);
$queryCount = "SELECT \r\n\t\t\t\t\t\t\t\tCOUNT(*) AS count\r\n\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\tuser\r\n\t\t\t\t\t\t\tWHERE 1\r\n \t \t\t\t\t\t";
$this->addFilter($queryCount, $id, $active, $user_type_id, $login, $password, $email);
//limite
$query .= parent::limit($quant_limit, $quant_started);
//executa a query
$ReturnDataVO = parent::query($query);
//executa a query para gerar count total
$ReturnTotalDataVO = parent::query($queryCount);
if (FALSE) {
$ReturnDataVO = new ReturnDataVO();
}
if ($ReturnDataVO->success) {
switch ($typeOfReturn) {
case DbInterface::RETURN_ARRAY:
$ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_ARRAY);
break;
case DbInterface::RETURN_VO:
$ReturnDataVO->fetchAllVO($this);
break;
case DbInterface::RETURN_STD_OBJECT:
default:
//retornar tudo em objeto
$ReturnDataVO->fetchAll();
break;
}
$ReturnTotalDataVO->fetchAll();
$tempTotal = $ReturnTotalDataVO->result[0]->count;
$ReturnDataVO->count_total = $tempTotal;
return $ReturnDataVO;
} else {
return $ReturnDataVO;
}
}
/**
* deleta mesmo
* @param int $id
* @return ReturnDataVO
*/
public function delete($id)
{
$query = "DELETE FROM " . $this->TABLE_NAME . " WHERE id = '" . DataHandler::forceInt($id) . "' LIMIT 1 ";
$ReturnDataVO = parent::query($query);
return $ReturnDataVO;
}
private function addFilter(&$query, $id, $active, $table, $table_id, $user_id, $title, $description, $date, $symble_date, $order_type)
{
if ($id > 0) {
$query .= " AND id = '" . DataHandler::forceInt($id) . "'";
}
if ($active !== NULL) {
$query .= " AND `active` = '" . DataHandler::forceInt($active) . "'";
}
if ($table !== NULL) {
$query .= " AND `table` = '" . DataHandler::forceString($table) . "'";
}
if ($table_id > 0) {
$query .= " AND `table_id` = '" . DataHandler::forceInt($table_id) . "'";
}
if ($user_id > 0) {
$query .= " AND `user_id` = '" . DataHandler::forceInt($user_id) . "'";
}
if ($title !== NULL) {
$query .= " AND `title` = '" . DataHandler::forceString($title) . "'";
}
if ($description !== NULL) {
$query .= " AND `description` = '" . DataHandler::forceString($description) . "'";
}
if ($date !== NULL) {
$symble_date = parent::compareSimble($symble_date);
$date = parent::dateHandlerScape($date);
$query .= " AND `date` {$symble_date} {$date} ";
}
//adiciona a ordenação na query
$orderBy = "";
if ($order_type != NULL) {
$order_type = parent::verifyOrderType($order_type);
$orderBy .= ", `order` " . $order_type;
}
if ($orderBy != NULL) {
$query .= " ORDER BY " . $orderBy;
}
$query .= "ORDER BY date DESC";
}
public function select($typeOfReturn = NULL, $id = NULL, $active = NULL, $name = NULL, $url = NULL, $author = NULL, $order_type = DbInterface::ORDER_ASC, $quant_limit = NULL, $quant_started = NULL)
{
$typeOfReturn = $typeOfReturn === NULL ? NULL : $typeOfReturn;
$order_type = parent::verifyOrderType($order_type);
//echo "login[".$login."] - password[".$password."]";
$arrayFilter = array();
$query = "SELECT * FROM `image` WHERE 1";
if ($id !== NULL) {
$query .= " AND `id` = '" . DataHandler::forceInt($id) . "'";
}
if ($active !== NULL) {
$query .= " AND `active` = '" . DataHandler::forceInt($active) . "'";
}
if ($name !== NULL) {
$query .= " AND `name` = '" . DataHandler::forceString($name) . "'";
}
if ($url !== NULL) {
$query .= " AND `url` = '" . DataHandler::forceString($url) . "'";
}
if ($author !== NULL) {
$query .= " AND `author` = '" . DataHandler::forceString($author) . "'";
}
//limite
$query .= parent::limit($quant_limit, $quant_started);
$query .= " ORDER BY `order` {$order_type} ";
//executa a query
$ReturnDataVO = parent::query($query);
//verifica se conseguiu ocorreu tudo certo
if ($ReturnDataVO->success) {
switch ($typeOfReturn) {
case DbInterface::RETURN_ARRAY:
$ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_ARRAY);
break;
case DbInterface::RETURN_VO:
$ReturnDataVO->fetchAllVO($this);
break;
case DbInterface::RETURN_STD_OBJECT:
default:
//retornar tudo em objeto
$ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT);
break;
}
return $ReturnDataVO;
} else {
return $ReturnDataVO;
}
}
function delete($id)
{
$query = "DELETE FROM paramether WHERE id = '{$id}' LIMIT 1";
return parent::query($query);
}
/**
* @param $typeOfReturn
* @param $id
* @param $active
* @param $state_id
* @param $state
* @param $country
* @param $alias
* @param $street
* @param $number
* @param $quant_limit
* @param $quant_started
* @return unknown_type
*/
public function select($typeOfReturn = NULL, $id = NULL, $active = NULL, $state_id = NULL, $state = NULL, $country = NULL, $alias = NULL, $street = NULL, $number = NULL, $quant_limit = NULL, $quant_started = NULL)
{
$arrayFilter = array();
$query = "SELECT \n\t\t\t\t\t\t*\n\t\t\t\t\t\tFROM \n\t\t\t\t\t \taddress \n\t\t\t\t\t WHERE 1 ";
$this->addFilter($query, $id, $active, $state_id, $state, $country, $alias, $street, $number);
$queryCount = "Select \n\t\t\t\t \t\t\taddress.*,\n\t\t\t\t\t\t\t\tCOUNT(*) AS count\n\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\taddress\n\t\t\t\t\t\t\tWHERE 1\n \t \t\t\t\t\t";
$this->addFilter($queryCount, $id, $active, $state_id, $state, $country, $alias, $street, $number);
//limite
$query .= parent::limit($quant_limit, $quant_started);
//executa a query
$ReturnDataVO = parent::query($query);
//executa a query para gerar count total
$ReturnTotalDataVO = parent::query($queryCount);
if ($ReturnDataVO->success) {
switch ($typeOfReturn) {
case DbInterface::RETURN_ARRAY:
$ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_ARRAY);
break;
case DbInterface::RETURN_VO:
$ReturnDataVO->fetchAllVO($this);
break;
case DbInterface::RETURN_STD_OBJECT:
default:
//retornar tudo em objeto
$ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT);
break;
}
$ReturnTotalDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT);
$tempTotal = $ReturnTotalDataVO->result[0]->count;
$ReturnDataVO->count_total = $tempTotal;
//echo Debug::print_r($ReturnDataVO);
return $ReturnDataVO;
} else {
return $ReturnDataVO;
}
}
/**
*
* @param (string) $typeDeRetorno UsuarioDAO::RETORNO_STD_OBJECT, UsuarioDAO::RETORNO_VO, UsuarioDAO::RETORNO_ARRAY
* @param (int) $id (opcional)
* @param (int) $active (opcional)
* @param (string) $name (opcional)
* @param (string) $uf (opcional)
* @param (id) $country_id (opcional)
* @param (int) $quant_limite = NULL
* @param (int) $quant_started = NULL
*
* @return class ReturnDataVO
*/
public function select($typeOfReturn = NULL, $id = NULL, $active = NULL, $name = NULL, $uf = NULL, $country_id = NULL, $quant_limit = NULL, $quant_started = NULL)
{
$arrayFilter = array();
$query = "SELECT \r\n\t\t\t\t\t\tstate.*,\r\n\t\t\t\t\t\tcountry.id as country_id,\r\n\t\t\t\t\t\tcountry.name as country_name\r\n\t\t\t\t\t FROM \r\n\t\t\t\t\t \tstate \r\n\t\t\t\t\t INNER JOIN country\r\n\t\t\t\t\t WHERE 1 AND state.country_id = country.id";
$this->addFilter($query, $id, $active, $name, $country_id, $uf);
$queryCount = "Select \r\n\t\t\t\t \t\t\tstate.*,\r\n\t\t\t\t\t\t\t\tCOUNT(*) AS count\r\n\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\tstate\r\n\t\t\t\t\t\t\tWHERE 1\r\n \t \t\t\t\t\t";
$this->addFilter($queryCount, $id, $active, $name, $country_id, $uf);
//limite
$query .= parent::limit($quant_limit, $quant_started);
//executa a query
//echo $query;
$ReturnDataVO = parent::query($query);
//executa a query para gerar count total
$ReturnTotalDataVO = parent::query($queryCount);
if ($ReturnDataVO->success) {
switch ($typeOfReturn) {
case DbInterface::RETURN_ARRAY:
$ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_ARRAY);
break;
case DbInterface::RETURN_VO:
$ReturnDataVO->fetchAllVO($this);
break;
case DbInterface::RETURN_STD_OBJECT:
default:
//retornar tudo em objeto
$ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT);
break;
}
$ReturnTotalDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT);
$tempTotal = $ReturnTotalDataVO->result[0]->count;
$ReturnDataVO->count_total = $tempTotal;
//echo Debug::print_r($ReturnDataVO);
return $ReturnDataVO;
} else {
return $ReturnDataVO;
}
}
