Viewing file:  clsUmuser.php (5.16 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class umuser--------------------------
//--PK of umuser ::
// 1. UsID
class umuser extends clsDB{
var $result;
var $UsID;
var $UsName;
var $UsLogin;
var $UsPassword;
var $UsPsCode; //personId, studentId
var $UsWgID;
var $UsQsID;
var $UsAnswer;
var $UsEmail;
var $UsActive;
var $UsAdmin;
var $UsDesc;
var $UsPwdExpDt;
var $UsUpdDt;
var $UsUpdUsID;
var $UsSessionID;
var $name;
var $dptID;
var $dptName;
var $posID;
var $posName;
function umuser(&$c){
$this->c=$c->c;
$this->DB=$c->db;
}
function Save(){
if ($this->status==1){
$this->UsID=$this->GetNextCode();
$this->UsWgID = ($this->UsWgID=='') ? '0' : $this->UsWgID;
$sql = "insert into umuser values (
'$this->UsID',
'$this->UsName',
'$this->UsLogin',
'$this->UsPassword',
'$this->UsPsCode',
'$this->UsWgID',
'$this->UsQsID',
'$this->UsAnswer',
'$this->UsEmail',
'$this->UsActive',
'$this->UsAdmin',
'$this->UsDesc',
'$this->UsPwdExpDt',
'$this->UsUpdDt',
'$this->UsUpdUsID',
'$this->UsSessionID'
)";
}else {
$sql = "update umuser set
UsName='$this->UsName',
UsLogin='$this->UsLogin',
UsPassword='$this->UsPassword',
UsPsCode='$this->UsPsCode',
UsWgID='$this->UsWgID',
UsQsID='$this->UsQsID',
UsAnswer='$this->UsAnswer',
UsEmail='$this->UsEmail',
UsActive='$this->UsActive',
UsAdmin='$this->UsAdmin',
UsDesc='$this->UsDesc',
UsPwdExpDt='$this->UsPwdExpDt',
UsUpdDt='$this->UsUpdDt',
UsUpdUsID='$this->UsUpdUsID',
UsSessionID='$this->UsSessionID'
where UsID='$this->UsID' ";
}
return $this->Dml($sql);
}
function Deleteps($xKey){
return $this->Dml("delete from umuser where uspscode= '$xKey'");
}
function GetNextCode(){
$this->SetQuery("select max(UsID) as num from umuser");
if ($result=$this->GetResult()) {
return $result['num']+1;
}else{
return 1;
}
}
function RSumuser(){
$this->SetQuery("select * from umuser order by uspscode");
}
function GetRecord(){
if ($this->result = $this->GetResult()) {
$this->UsID = $this->result['UsID'];
$this->UsName = $this->result['UsName'];
$this->UsLogin = $this->result['UsLogin'];
$this->UsPassword = $this->result['UsPassword'];
$this->UsPsCode = $this->result['UsPsCode'];
$this->UsWgID = $this->result["UsWgID"];
$this->UsQsID = $this->result['UsQsID'];
$this->UsAnswer = $this->result['UsAnswer'];
$this->UsEmail = $this->result['UsEmail'];
$this->UsActive = $this->result['UsActive'];
$this->UsAdmin = $this->result['UsAdmin'];
$this->UsDesc = $this->result['UsDesc'];
$this->UsPwdExpDt = $this->result['UsPwdExpDt'];
$this->UsUpdDt = $this->result['UsUpdDt'];
$this->UsUpdUsID = $this->result['UsUpdUsID'];
$this->UsSessionID = $this->result['UsSessionID'];
$this->name=$this->result['NAME'];
$this->dptID=$this->result['DID'];
$this->dptName=$this->result['DNAME'];
$this->posID=$this->result['PID'];
$this->posName=$this->result['PNAME'];
return 1;
}else {
return 0;
}
}
function SearchByKey($xKey){
if ($this->SetQuery("select * from umuser where UsID= '$xKey' ")) {
return 1;
}else {
return 0;
}
}
//****************** You can add new functions below **********************//
function SearchByPersonID($xKey){
if ($this->SetQuery("select * from umuser where UsPsCode= '$xKey' ")) {
return 1;
}else {
return 0;
}
}
function SearchByLogin($xKey, $passwd){
$sql="select * from umuser where UsLogin= '$xKey' and UsPassword='".md5("O]O".$passwd."O[O")."' ";
if ($this->SetQuery($sql)) {
return 1;
}else {
return 0;
}
}
function SetSessionID($UsID, $SessionID){
$sql = "Update umuser set UsSessionID='$SessionID' where UsID='$UsID' ";
$this->Dml($sql);
}
function SearchByFilter($strFilter){
if ($this->SetQuery("select * from umuser where $strFilter")) {
return 1;
}else {
return 0;
}
}
function SearchByNameWGroup($loginname="", $name="", $WgID=""){
$strCond = "";
if ($loginname<>"") $strCond.=" and UsLogin like '%$loginname%' ";
if ($name<>"") $strCond.=" and UsName like '%$name%' ";
if ($WgID<>"") $strCond.=" and UsWgId='$WgID' ";
$sql = "select *
from umuser
where 1 $strCond ";
if ($this->SetQuery($sql)) {
return 1;
}else {
return 0;
}
}
function SearchByUserLogin($xKey){
if ($this->SetQuery("select * from umuser where UsLogin= '$xKey' ")) {
return 1;
}else {
return 0;
}
}
function RSUserBySt($StID){
$sql="select distinct umuser.*
from umgroup, umusergroup, umuser
where GpStID=$StID and GpID=UgGpID and UgUsID=UsID
order by UsName";
$this->SetQuery($sql);
}
function SearchByPsCodeWg($PsCode, $WgID){
$sql = "select * from umuser where UsPsCode='$PsCode' and UsWgID='$WgID' order by UsName";
if ($this->SetQuery($sql)) {
return 1;
}else {
return 0;
}
}
function SearchByPsCode($PsCode){
$sql = "select * from umuser where UsPsCode='$PsCode' order by UsName";
if ($this->SetQuery($sql)) {
return 1;
}else {
return 0;
}
}
function SearchByUsPsCode($xKey){
if ($this->SetQuery("select * from umuser where UsPsCode= '$xKey'")){
return 1;
}else {
return 0;
}
}
function SearchByUsLogin($xKey){
if ($this->SetQuery("select * from umuser where UsLogin= '$xKey'")){
return 1;
}else {
return 0;
}
}
} //--End class umuser--
?>
|