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;
}
function _selectOr($fields, $filter)
{
$sentence = "";
$sentence = Sentences::_getSentenceSelectOr($this->table, $fields, $filter);
$this->register = $this->cnn->excecuteSelect($sentence);
return $this->register;
}
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 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 static function _getSentenceSelectOr($tabla, $values, $filter)
{
self::$sentence = "";
self::$sentence = "SELECT " . $values . " FROM " . $tabla . " " . self::getFilterOr($filter);
return self::$sentence;
}
function _select($fields, $filter)
{
$sentence = Sentences::_getSentenceSelectOr($this->table, $fields, $filter);
$this->user = $this->cnn->excecuteSelect($sentence . " ORDER BY lastName");
return $this->user;
}
public function _select($fields, $filter)
{
$sentece = Sentences::_getSentenceSelect($this->table, $fields, $filter);
$rs = $this->cnn->excecuteSelect($sentece);
return $rs;
}
