public function existenPagosDePersona($idpersona) { $SQLCommand = "SELECT \n COUNT(idpago)\n FROM pago \n WHERE idpersona = '{$idpersona}'"; $query = parent::query($SQLCommand); $cantidad = $query->fetchColumn(); return $cantidad > 0; }
/** * busca un usuario en la base de datos y lo devuelve si este existe * sino existe devolvera null */ public function autenticar($user, $pass) { $SQLCommand = "SELECT \n idusuario, cuenta, password \n FROM usuario \n WHERE cuenta = '{$user}' AND password = '******'\n LIMIT 1"; $recordset = parent::query($SQLCommand); $usuario = $recordset->fetchObject(); return $usuario; }
public function CrearCombo2Valores($entidad, $secondVal, $displayValue, $selectedId, $Filtro = "") { if ($Filtro != "") { $Filtro = " WHERE " . $Filtro; } $keyValue = 'id' . $entidad; $result = "<select name='combo{$entidad}' id='combo{$entidad}' onchange='javascript:void(comboDependiente{$entidad}());'>"; if ($selectedId == 0) { $result .= "<option value='0' selected></option>"; } $recordset = parent::query("Select * from {$entidad} {$Filtro}"); while ($records = parent::handle($recordset)) { $value = $records->{$displayValue}; $key = $records->{$keyValue}; $key2 = $records->{$secondVal}; if ($key == $selectedId) { $result .= "<option value='{$key}#{$key2}' selected>{$value}</option>"; } else { $result .= "<option value='{$key}#{$key2}'>{$value}</option>"; } } $result .= '</select>'; return $result; }