protected function getSubmenu($idMenu) { $sentence = ""; $sentence = Sentences::_getSentenceSelect("submenus", "idSubMenus,description,addOperations,operation", array('state' => '1', 'idMenu' => $idMenu)); $this->subMenus = $this->cnn->excecuteSelect($sentence . "ORDER BY idSubMenus"); return $this->subMenus; }
public function _select($fields, $filter) { $helps = ""; $sentence = Sentences::_getSentenceSelect($this->table, " * ", $filter); $helps = $this->cnn->excecuteSelect($sentence); return $helps[0]['description']; }
public function _selectCargos($fields, $filter) { $sentence = ""; $sentence = Sentences::_getSentenceSelect('cargos', $fields, $filter); $this->typeUser = $this->mysqConn->excecuteSelect($sentence . " ORDER BY description asc "); return $this->typeUser; }
function _select($fields, $filter) { $sentence = ""; $sentence = Sentences::_getSentenceSelect($this->table, $fields, $filter); $this->register = $this->cnn->excecuteSelect($sentence); array_pop($this->register); return $this->register; }
function isSignature($idUser, $signature) { $sentence = ""; $pass = FilterSqlSentences::getCharFilter($signature); $sentence = Sentences::_getSentenceSelect("users", " * ", array('idUser' => $idUser, 'signature' => $signature)); if ($this->cnn->getNumberRows($sentence) > 0) { $data = $this->cnn->excecuteSelect($sentence); return true; } else { return 0; } }
function getOptionsDbSel($tabla, $values, $filter, $id, $selected, $arr = false) { $conn = new MySqlModel(); $conn->connect(); $sentence = Sentences::_getSentenceSelect($tabla, $values, $filter); $options = $conn->excecuteSelect($sentence); array_pop($options); if (is_array($selected)) { $arrayOption = $this->getOptionsArraySel($options, $values, $id, $selected, $arr); } else { $arrayOption = $this->getOptionsSel($options, $values, $id, $selected, $arr); } return $arrayOption; }
public function _select($fields, $filter) { $sentece = Sentences::_getSentenceSelect($this->table, $fields, $filter); $rs = $this->cnn->excecuteSelect($sentece); return $rs; }