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