Viewing file:  clsUmuser.php (4.18 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class umusergroup--------------------------
//--PK of umusergroup ::
// 1. UgGpID
// 2. UgUsID
class umuser extends clsDB{
var $result;
var $UgID;
var $UgGpID;
var $UgUsID;
function umuser(&$c){
$this->c=$c->c;
$this->DB=$c->db;
}
function Save(){
if ($this->status==1){
$this->UsID=$this->GetNextCode();
$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 RSumuser(){
$this->SetQuery("select * from umuser order by UsID");
}
function GetNextCode(){
$this->SetQuery("select max(UsID) as num from umuser");
if ($result=$this->GetResult()) {
return $result['num']+1;
}
}
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'];
return 1;
}else {
return 0;
}
}
function SearchByKey($xKey){
if ($this->SetQuery("select * from umuser where UsID= '$xKey'")){
return 1;
}else {
return 0;
}
}
function RSumuser2(){
$this->SetQuery("select * from umuser where UsID!='1' order by UsID");
}
function SearchByUsPsCode($xKey){
if ($this->SetQuery("select * from umuser where UsPsCode= '$xKey'")){
return 1;
}else {
return 0;
}
}
//****************** You can add new functions below **********************//
function JoinUsIDLimitGroupUgUsIDOrderName($xKey1, $xKey2, $xstart, $xpage_size){
if ($this->SetQuery("select B.UsID, B.UsName, B.UsPsCode from umusergroup A,umuser B where A.UgUsID = B.UsID and A.UgGpID >= '$xKey1' and A.UgGPID <= '$xKey2' group by A.UgUsID order by B.UsName limit $xstart, $xpage_size")){
return 1;
}else {
return 0;
}
}
function SarchByUsNameJoinUsIDNameGroupUgUsIDOrderName($xKey1, $xKey2, $xKey3){
if ($this->SetQuery("select B.UsID, B.UsName, B.UsPsCode from umusergroup A,umuser B where A.UgUsID = B.UsID and A.UgGpID >= '$xKey1' and A.UgGPID <= '$xKey2' and B.UsName like '%$xKey3%' group by A.UgUsID order by B.UsName")){
return 1;
}else {
return 0;
}
}
function SarchByn($xKey1){
if ($this->SetQuery("select B.UsID, B.UsName, B.UsPsCode from umusergroup A,umuser B where A.UgUsID = '$xKey1'")){
return 1;
}else {
return 0;
}
}
function SearchByUsLogin($xKey){
//--ค้นหาข้อมูลตาม PK ต้องระบุพารามิเตอร์ด้วย และต้องตามด้วยเมธอด GetRecord() เสมอ
if ($this->SetQuery("select * from umuser where UsLogin= '$xKey'")){
return 1;
}else {
return 0;
}
}
function SearchUsIDByUsPsCode($xKey1,$dbname){
if ($this->SetQuery("select UsID from $dbname.umuser where UsPsCode = '$xKey1'")){
return 1;
}else {
return 0;
}
}
} //--End class umuser--
?>
|