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}"); } }
/** * @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; } }
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; } }
/** * @param $typeOfReturn * @param $id * @param $active * @param $uid * @param $name * @param $description * @param $order_type * @param $quant_limit * @param $quant_started * @return ReturnDataVO (ReturnDataVO) */ public function select($typeOfReturn = NULL, $id = NULL, $active = NULL, $table = NULL, $table_id = NULL, $user_id = NULL, $title = NULL, $description = NULL, $date = NULL, $symble_date = ">=", $order_type = NULL, $quant_started = NULL, $quant_limit = 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 \tcomment \r\n\t\t\t\t\t WHERE 1 "; $this->addFilter($query, $id, $active, $table, $table_id, $user_id, $title, $description, $date, $symble_date, $order_type); $queryCount = "Select \r\n\t\t\t\t \t\t\tcomment.*,\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\tcomment\r\n\t\t\t\t\t\t\tWHERE 1\r\n \t \t\t\t\t\t"; $this->addFilter($queryCount, $id, $active, $table, $table_id, $user_id, $title, $description, $date, $symble_date, $order_type); //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); //echo $query; 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 $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 getUserList($conn) { // avoid "1046 ** No database selected" error $conn->query('USE mysql'); try { $users = $conn->getColumn('SELECT DISTINCT User from user'); } catch (DbException $e) { // if the user cannot select from the mysql.user table, then return an empty list return array(); } // FIXME: why lowercase neccessary? $users = Misc::lowercase($users); return $users; }
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 (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; } }
function delete($id) { $query = "DELETE FROM paramether WHERE id = '{$id}' LIMIT 1"; return parent::query($query); }
/** * @param $typeOfReturn * @param $name * @param $mobile * @param $telephone * @param $email * @param $rg * @param $cpf * @param $company * @param $quant_limit * @param $quant_started * @param $user_type_id * @return ReturnDataVO */ public function search($typeOfReturn = NULL, $name = NULL, $mobile = NULL, $telephone = NULL, $email = NULL, $rg = NULL, $cpf = NULL, $company = NULL, $quant_limit = NULL, $quant_started = NULL, $user_type_id = NULL, $recive_news = NULL) { $arrayFilter = array(); $query = "SELECT \r\n\t\t\t\t\t\t\tuser.id as user_id,\r\n\t\t\t\t\t\t\tuser.active,\r\n\t\t\t\t\t\t\tuser.user_type_id,\r\n\t\t\t\t\t\t\tuser.login,\r\n\t\t\t\t\t\t\tuser.password,\r\n\t\t\t\t\t\t\tuser.email as user_email, \r\n\t\t\t\t\t\t\tuser_details.*\r\n\t\t\t\t\t\tFROM \r\n\t\t\t\t\t \t\tuser_details\r\n\t\t\t\t\t \tINNER JOIN \r\n\t\t\t\t\t \t\tuser ON user.id = user_details.id\r\n\t\t\t\t\t WHERE 1 "; $this->addFilterToSearch($query, $name, $mobile, $telephone, $email, $rg, $cpf, $company, $user_type_id, $recive_news); $queryCount = "\r\n\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\tCOUNT(*) AS count\r\n\t\t\t\t\t\tFROM \r\n\t\t\t\t\t \t\tuser_details\r\n\t\t\t\t\t \tINNER JOIN \r\n\t\t\t\t\t \t\tuser ON user.id = user_details.id\r\n\t\t\t\t\t WHERE 1 \r\n\t \t \t\t\t\t\t"; $this->addFilterToSearch($queryCount, $name, $mobile, $telephone, $email, $rg, $cpf, $company, $user_type_id, $recive_news); //limite $query .= parent::limit($quant_limit, $quant_started); // echo $query; //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; } }
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; } }
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; }