/usuarioinfo.php
PHP | 627 lines | 424 code | 106 blank | 97 comment | 61 complexity | 21ab79d86315a7e2ba43461b242fac97 MD5 | raw file
Possible License(s): LGPL-2.1
- <?php
- // PHPMaker 6 configuration for Table usuario
- $usuario = NULL; // Initialize table object
- // Define table class
- class cusuario {
- // Define table level constants
- var $TableVar;
- var $TableName;
- var $SelectLimit = FALSE;
- var $idUsuario;
- var $idRol;
- var $nombre;
- var $paterno;
- var $materno;
- var $ci;
- var $cargo;
- var $zlogin;
- var $password;
- var $fields = array();
- var $UseTokenInUrl = EW_USE_TOKEN_IN_URL;
- var $Export; // Export
- var $ExportOriginalValue = EW_EXPORT_ORIGINAL_VALUE;
- var $ExportAll = EW_EXPORT_ALL;
- var $SendEmail; // Send Email
- var $TableCustomInnerHtml; // Custom Inner Html
- function cusuario() {
- $this->TableVar = "usuario";
- $this->TableName = "usuario";
- $this->SelectLimit = TRUE;
- $this->idUsuario = new cField('usuario', 'x_idUsuario', 'idUsuario', "`idUsuario`", 3, -1, FALSE);
- $this->fields['idUsuario'] =& $this->idUsuario;
- $this->idRol = new cField('usuario', 'x_idRol', 'idRol', "`idRol`", 3, -1, FALSE);
- $this->fields['idRol'] =& $this->idRol;
- $this->nombre = new cField('usuario', 'x_nombre', 'nombre', "`nombre`", 200, -1, FALSE);
- $this->fields['nombre'] =& $this->nombre;
- $this->paterno = new cField('usuario', 'x_paterno', 'paterno', "`paterno`", 200, -1, FALSE);
- $this->fields['paterno'] =& $this->paterno;
- $this->materno = new cField('usuario', 'x_materno', 'materno', "`materno`", 200, -1, FALSE);
- $this->fields['materno'] =& $this->materno;
- $this->ci = new cField('usuario', 'x_ci', 'ci', "`ci`", 3, -1, FALSE);
- $this->fields['ci'] =& $this->ci;
- $this->cargo = new cField('usuario', 'x_cargo', 'cargo', "`cargo`", 200, -1, FALSE);
- $this->fields['cargo'] =& $this->cargo;
- $this->zlogin = new cField('usuario', 'x_zlogin', 'login', "`login`", 200, -1, FALSE);
- $this->fields['login'] =& $this->zlogin;
- $this->password = new cField('usuario', 'x_password', 'password', "`password`", 200, -1, FALSE);
- $this->fields['password'] =& $this->password;
- }
- // Records per page
- function getRecordsPerPage() {
- return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_REC_PER_PAGE];
- }
- function setRecordsPerPage($v) {
- $_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_REC_PER_PAGE] = $v;
- }
- // Start record number
- function getStartRecordNumber() {
- return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_START_REC];
- }
- function setStartRecordNumber($v) {
- $_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_START_REC] = $v;
- }
- // Search Highlight Name
- function HighlightName() {
- return "usuario_Highlight";
- }
- // Advanced search
- function getAdvancedSearch($fld) {
- return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_ADVANCED_SEARCH . "_" . $fld];
- }
- function setAdvancedSearch($fld, $v) {
- if (@$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_ADVANCED_SEARCH . "_" . $fld] <> $v) {
- $_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_ADVANCED_SEARCH . "_" . $fld] = $v;
- }
- }
- // Basic search Keyword
- function getBasicSearchKeyword() {
- return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_BASIC_SEARCH];
- }
- function setBasicSearchKeyword($v) {
- $_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_BASIC_SEARCH] = $v;
- }
- // Basic Search Type
- function getBasicSearchType() {
- return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_BASIC_SEARCH_TYPE];
- }
- function setBasicSearchType($v) {
- $_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_BASIC_SEARCH_TYPE] = $v;
- }
- // Search where clause
- function getSearchWhere() {
- return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_SEARCH_WHERE];
- }
- function setSearchWhere($v) {
- $_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_SEARCH_WHERE] = $v;
- }
- // Single column sort
- function UpdateSort(&$ofld) {
- if ($this->CurrentOrder == $ofld->FldName) {
- $sSortField = $ofld->FldExpression;
- $sLastSort = $ofld->getSort();
- if ($this->CurrentOrderType == "ASC" || $this->CurrentOrderType == "DESC") {
- $sThisSort = $this->CurrentOrderType;
- } else {
- $sThisSort = ($sLastSort == "ASC") ? "DESC" : "ASC";
- }
- $ofld->setSort($sThisSort);
- $this->setSessionOrderBy($sSortField . " " . $sThisSort); // Save to Session
- } else {
- $ofld->setSort("");
- }
- }
- // Session WHERE Clause
- function getSessionWhere() {
- return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_WHERE];
- }
- function setSessionWhere($v) {
- $_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_WHERE] = $v;
- }
- // Session ORDER BY
- function getSessionOrderBy() {
- return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_ORDER_BY];
- }
- function setSessionOrderBy($v) {
- $_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_ORDER_BY] = $v;
- }
- // Session Key
- function getKey($fld) {
- return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_KEY . "_" . $fld];
- }
- function setKey($fld, $v) {
- $_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_KEY . "_" . $fld] = $v;
- }
- // Table level SQL
- function SqlSelect() { // Select
- return "SELECT * FROM `usuario`";
- }
- function SqlWhere() { // Where
- return " estado = 1 ";
- }
- function SqlGroupBy() { // Group By
- return "";
- }
- function SqlHaving() { // Having
- return "";
- }
- function SqlOrderBy() { // Order By
- return "";
- }
- // SQL variables
- var $CurrentFilter; // Current filter
- var $CurrentOrder; // Current order
- var $CurrentOrderType; // Current order type
- // Get SQL
- function GetSQL($where, $orderby) {
- return ew_BuildSelectSql($this->SqlSelect(), $this->SqlWhere(),
- $this->SqlGroupBy(), $this->SqlHaving(), $this->SqlOrderBy(),
- $where, $orderby);
- }
- // Table SQL
- function SQL() {
- $sFilter = $this->CurrentFilter;
- $sSort = $this->getSessionOrderBy();
- return ew_BuildSelectSql($this->SqlSelect(), $this->SqlWhere(),
- $this->SqlGroupBy(), $this->SqlHaving(), $this->SqlOrderBy(),
- $sFilter, $sSort);
- }
- // Return table sql with list page filter
- function SelectSQL() {
- $sFilter = $this->getSessionWhere();
- if ($this->CurrentFilter <> "") {
- if ($sFilter <> "") $sFilter = "($sFilter) AND ";
- $sFilter .= "(" . $this->CurrentFilter . ")";
- }
- $sSort = $this->getSessionOrderBy();
- return ew_BuildSelectSql($this->SqlSelect(), $this->SqlWhere(),
- $this->SqlGroupBy(), $this->SqlHaving(), $this->SqlOrderBy(),
- $sFilter, $sSort);
- }
- // Return record count
- function SelectRecordCount() {
- global $conn;
- $cnt = -1;
- $sFilter = $this->CurrentFilter;
- $this->Recordset_Selecting($this->CurrentFilter);
- if ($this->SelectLimit) {
- $sSelect = $this->SelectSQL();
- if (strtoupper(substr($sSelect, 0, 13)) == "SELECT * FROM") {
- $sSelect = "SELECT COUNT(*) FROM" . substr($sSelect, 13);
- if ($rs = $conn->Execute($sSelect)) {
- if (!$rs->EOF)
- $cnt = $rs->fields[0];
- $rs->Close();
- }
- }
- }
- if ($cnt == -1) {
- if ($rs = $conn->Execute($this->SelectSQL())) {
- $cnt = $rs->RecordCount();
- $rs->Close();
- }
- }
- $this->CurrentFilter = $sFilter;
- return intval($cnt);
- }
- // INSERT statement
- function InsertSQL(&$rs) {
- $names = "";
- $values = "";
- foreach ($rs as $name => $value) {
- if (EW_MD5_PASSWORD && $name == 'password') {
- $value = (EW_CASE_SENSITIVE_PASSWORD) ? md5($value) : md5(strtolower($value));
- }
- $names .= $this->fields[$name]->FldExpression . ",";
- $values .= (is_null($value) ? "NULL" : ew_QuotedValue($value, $this->fields[$name]->FldDataType)) . ",";
- }
- if (substr($names, -1) == ",") $names = substr($names, 0, strlen($names)-1);
- if (substr($values, -1) == ",") $values = substr($values, 0, strlen($values)-1);
- return "INSERT INTO `usuario` ($names,estado) VALUES ($values,'1')";
- }
- // UPDATE statement
- function UpdateSQL(&$rs) {
- $SQL = "UPDATE `usuario` SET ";
- foreach ($rs as $name => $value) {
- if (EW_MD5_PASSWORD && $name == 'password') {
- $value = (EW_CASE_SENSITIVE_PASSWORD) ? md5($value) : md5(strtolower($value));
- }
- $SQL .= $this->fields[$name]->FldExpression . "=" .
- (is_null($value) ? "NULL" : ew_QuotedValue($value, $this->fields[$name]->FldDataType)) . ",";
- }
- if (substr($SQL, -1) == ",") $SQL = substr($SQL, 0, strlen($SQL)-1);
- if ($this->CurrentFilter <> "") $SQL .= " WHERE " . $this->CurrentFilter;
- return $SQL;
- }
- // DELETE statement
- function DeleteSQL(&$rs) {
- $SQL = "UPDATE usuario SET estado=0 where idUsuario = ".ew_QuotedValue($rs['idUsuario'], $this->idCuenta->FldDataType) ;
- // $SQL = "DELETE FROM `usuario` WHERE ";
- // $SQL .= EW_DB_QUOTE_START . 'idUsuario' . EW_DB_QUOTE_END . '=' . ew_QuotedValue($rs['idUsuario'], $this->idUsuario->FldDataType) . ' AND ';
- // if (substr($SQL, -5) == " AND ") $SQL = substr($SQL, 0, strlen($SQL)-5);
- // if ($this->CurrentFilter <> "") $SQL .= " AND " . $this->CurrentFilter;
- return $SQL;
- }
-
- // Key filter for table
- function SqlKeyFilter() {
- return "`idUsuario` = @idUsuario@";
- }
- // Return Key filter for table
- function KeyFilter() {
- $sKeyFilter = $this->SqlKeyFilter();
- if (!is_numeric($this->idUsuario->CurrentValue))
- $sKeyFilter = "0=1"; // Invalid key
- $sKeyFilter = str_replace("@idUsuario@", ew_AdjustSql($this->idUsuario->CurrentValue), $sKeyFilter); // Replace key value
- return $sKeyFilter;
- }
- // Return url
- function getReturnUrl() {
- // Get referer URL automatically
- if (ew_ServerVar("HTTP_REFERER") <> "" && ew_ReferPage() <> ew_CurrentPage() && ew_ReferPage() <> "login.php") // Referer not same page or login page
- $_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_RETURN_URL] = ew_ServerVar("HTTP_REFERER"); // Save to Session
- if (@$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_RETURN_URL] <> "") {
- return $_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_RETURN_URL];
- } else {
- return "usuariolist.php";
- }
- }
- function setReturnUrl($v) {
- $_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_RETURN_URL] = $v;
- }
- // View url
- function ViewUrl() {
- return $this->KeyUrl("usuarioview.php", $this->UrlParm());
- }
- // Add url
- function AddUrl() {
- $AddUrl = "usuarioadd.php";
- $sUrlParm = $this->UrlParm();
- if ($sUrlParm <> "")
- $AddUrl .= "?" . $sUrlParm;
- return $AddUrl;
- }
- // Edit url
- function EditUrl() {
- return $this->KeyUrl("usuarioedit.php", $this->UrlParm());
- }
- // Inline edit url
- function InlineEditUrl() {
- return $this->KeyUrl(ew_CurrentPage(), $this->UrlParm("a=edit"));
- }
- // Copy url
- function CopyUrl() {
- return $this->KeyUrl("usuarioadd.php", $this->UrlParm());
- }
- // Inline copy url
- function InlineCopyUrl() {
- return $this->KeyUrl(ew_CurrentPage(), $this->UrlParm("a=copy"));
- }
- // Delete url
- function DeleteUrl() {
- return $this->KeyUrl("usuariodelete.php", $this->UrlParm());
- }
- // Key url
- function KeyUrl($url, $parm = "") {
- $sUrl = $url . "?";
- if ($parm <> "") $sUrl .= $parm . "&";
- if (!is_null($this->idUsuario->CurrentValue)) {
- $sUrl .= "idUsuario=" . urlencode($this->idUsuario->CurrentValue);
- } else {
- return "javascript:alert('Llave incorrecta es nula');";
- }
- return $sUrl;
- }
- // Sort Url
- function SortUrl(&$fld) {
- if ($this->CurrentAction <> "" || $this->Export <> "" ||
- ($fld->FldType == 205)) { // Unsortable data type
- return "";
- } else {
- $sUrlParm = $this->UrlParm("order=" . urlencode($fld->FldName) . "&ordertype=" . $fld->ReverseSort());
- return ew_CurrentPage() . "?" . $sUrlParm;
- }
- }
- // URL parm
- function UrlParm($parm = "") {
- $UrlParm = ($this->UseTokenInUrl) ? "t=usuario" : "";
- if ($parm <> "") {
- if ($UrlParm <> "")
- $UrlParm .= "&";
- $UrlParm .= $parm;
- }
- return $UrlParm;
- }
- // Function LoadRs
- // - Load rows based on filter
- function LoadRs($sFilter) {
- global $conn;
- // Set up filter (Sql Where Clause) and get Return Sql
- $this->CurrentFilter = $sFilter;
- $sSql = $this->SQL();
- return $conn->Execute($sSql);
- }
- // Load row values from recordset
- function LoadListRowValues(&$rs) {
- $this->idUsuario->setDbValue($rs->fields('idUsuario'));
- $this->idRol->setDbValue($rs->fields('idRol'));
- $this->nombre->setDbValue($rs->fields('nombre'));
- $this->paterno->setDbValue($rs->fields('paterno'));
- $this->materno->setDbValue($rs->fields('materno'));
- $this->ci->setDbValue($rs->fields('ci'));
- $this->cargo->setDbValue($rs->fields('cargo'));
- $this->zlogin->setDbValue($rs->fields('login'));
- $this->password->setDbValue($rs->fields('password'));
- }
- // Render list row values
- function RenderListRow() {
- global $conn, $Security;
- // Call Row Rendering event
- $this->Row_Rendering();
- // idUsuario
- $this->idUsuario->ViewValue = $this->idUsuario->CurrentValue;
- $this->idUsuario->CssStyle = "";
- $this->idUsuario->CssClass = "";
- $this->idUsuario->ViewCustomAttributes = "";
- // idRol
- if ($Security->CanAdmin()) { // System admin
- if (strval($this->idRol->CurrentValue) <> "") {
- $sSqlWrk = "SELECT `nombre` FROM `rol` WHERE `idRol` = " . ew_AdjustSql($this->idRol->CurrentValue) . "";
- $sSqlWrk .= " ORDER BY `nombre` Asc";
- $rswrk = $conn->Execute($sSqlWrk);
- if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found
- $this->idRol->ViewValue = $rswrk->fields('nombre');
- $rswrk->Close();
- } else {
- $this->idRol->ViewValue = $this->idRol->CurrentValue;
- }
- } else {
- $this->idRol->ViewValue = NULL;
- }
- } else {
- $this->idRol->ViewValue = "********";
- }
- $this->idRol->CssStyle = "";
- $this->idRol->CssClass = "";
- $this->idRol->ViewCustomAttributes = "";
- // nombre
- $this->nombre->ViewValue = $this->nombre->CurrentValue;
- $this->nombre->CssStyle = "";
- $this->nombre->CssClass = "";
- $this->nombre->ViewCustomAttributes = "";
- // paterno
- $this->paterno->ViewValue = $this->paterno->CurrentValue;
- $this->paterno->CssStyle = "";
- $this->paterno->CssClass = "";
- $this->paterno->ViewCustomAttributes = "";
- // materno
- $this->materno->ViewValue = $this->materno->CurrentValue;
- $this->materno->CssStyle = "";
- $this->materno->CssClass = "";
- $this->materno->ViewCustomAttributes = "";
- // ci
- $this->ci->ViewValue = $this->ci->CurrentValue;
- $this->ci->CssStyle = "";
- $this->ci->CssClass = "";
- $this->ci->ViewCustomAttributes = "";
- // cargo
- $this->cargo->ViewValue = $this->cargo->CurrentValue;
- $this->cargo->CssStyle = "";
- $this->cargo->CssClass = "";
- $this->cargo->ViewCustomAttributes = "";
- // idUsuario
- $this->idUsuario->HrefValue = "";
- // idRol
- $this->idRol->HrefValue = "";
- // nombre
- $this->nombre->HrefValue = "";
- // paterno
- $this->paterno->HrefValue = "";
- // materno
- $this->materno->HrefValue = "";
- // ci
- $this->ci->HrefValue = "";
- // cargo
- $this->cargo->HrefValue = "";
- // Call Row Rendered event
- $this->Row_Rendered();
- }
- var $CurrentAction; // Current action
- var $EventName; // Event name
- var $EventCancelled; // Event cancelled
- var $CancelMessage; // Cancel message
- var $RowType; // Row Type
- var $CssClass; // Css class
- var $CssStyle; // Css style
- var $RowClientEvents; // Row client events
- // Row Attribute
- function RowAttributes() {
- $sAtt = "";
- if (trim($this->CssStyle) <> "") {
- $sAtt .= " style=\"" . trim($this->CssStyle) . "\"";
- }
- if (trim($this->CssClass) <> "") {
- $sAtt .= " class=\"" . trim($this->CssClass) . "\"";
- }
- if ($this->Export == "") {
- if (trim($this->RowClientEvents) <> "") {
- $sAtt .= " " . trim($this->RowClientEvents);
- }
- }
- return $sAtt;
- }
- // Field objects
- function fields($fldname) {
- return $this->fields[$fldname];
- }
- // Table level events
- // Recordset Selecting event
- function Recordset_Selecting(&$filter) {
- // Enter your code here
- }
- // Recordset Selected event
- function Recordset_Selected(&$rs) {
- //echo "Recordset Selected";
- }
- // Recordset Searching event
- function Recordset_Searching(&$filter) {
- // Enter your code here
- }
- // Row_Selecting event
- function Row_Selecting(&$filter) {
- // Enter your code here
- }
- // Row Selected event
- function Row_Selected(&$rs) {
- //echo "Row Selected";
- }
- // Row Rendering event
- function Row_Rendering() {
- // Enter your code here
- }
- // Row Rendered event
- function Row_Rendered() {
- // To view properties of field class, use:
- //var_dump($this-><FieldName>);
- }
- // Row Inserting event
- function Row_Inserting(&$rs) {
- // Enter your code here
- // To cancel, set return value to FALSE
- return TRUE;
- }
- // Row Inserted event
- function Row_Inserted(&$rs) {
- //echo "Row Inserted"
- }
- // Row Updating event
- function Row_Updating(&$rsold, &$rsnew) {
- // Enter your code here
- // To cancel, set return value to FALSE
- return TRUE;
- }
- // Row Updated event
- function Row_Updated(&$rsold, &$rsnew) {
- //echo "Row Updated";
- }
- // Row Deleting event
- function Row_Deleting(&$rs) {
- // Enter your code here
- // To cancel, set return value to False
- return TRUE;
- }
- // Row Deleted event
- function Row_Deleted(&$rs) {
- //echo "Row Deleted";
- }
- // Email Sending event
- function Email_Sending(&$Email, &$Args) {
- //var_dump($Email); var_dump($Args); exit();
- return TRUE;
- }
- }
- ?>