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