Viewing file:  clsDepartment.php (10.18 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class department--------------------------
//--PK of department ::
// 1. departmentId
include_once "../link/keyThai.php";
class Department extends clsDB{
var $result;
var $deptId;
var $deptName;
var $deptDesc;
var $deptCode;
var $deptParent;
var $deptYear;
var $deptDate;
var $deptRef;
var $pbriId;
var $deptIsCenter;
var $receiveIn;
var $receiveOut;
var $sendIn;
var $sendOut;
var $deptNo;
var $docGroup;
var $depttypeId;
var $deptParentId;
var $deptLevel;
var $deptGroup;
var $attachFile;
function Department(&$c){
$this->c=$c->c;
$this->DB=$c->db;
}
function Save(){
if ($this->status==1){
$this->departmentId=$this->GetNextCode();
//deptId, deptName, deptDesc , deptCode, deptParent, deptYear, deptDate, deptRef, pbriId, deptIsCenter, receiveIn, receiveOut, sendIn, sendOut, deptNo, docGroup, depttypeId, deptParentId, deptLevel, deptGroup, attachFile, cID, collegeID, collegeHost
$sql = "insert into Department (deptId, deptName, deptDesc , deptCode, deptParent, deptYear, deptDate, deptRef, pbriId, deptIsCenter, receiveIn, receiveOut, sendIn, sendOut, deptNo, docGroup, depttypeId, deptParentId, deptLevel, deptGroup, attachFile) values(
'$this->deptId',
'$this->deptName',
'$this->deptDesc',
'$this->deptCode',
'$this->deptParent',
'$this->deptYear',
'$this->deptDate',
'$this->deptRef',
'$this->pbriId',
'$this->deptIsCenter',
'$this->receiveIn',
'$this->receiveOut',
'$this->sendIn',
'$this->sendOut',
'".th2a($this->deptNo)."',
'$this->docGroup',
'$this->depttypeId',
'$this->deptParentId',
'$this->deptLevel',
'$this->deptGroup',
'$this->attachFile')";
}else {
$sql = "update Department set
deptName='$this->deptName',
deptDesc='$this->deptDesc',
deptCode='$this->deptCode',
deptParent='$this->deptParent',
deptYear='$this->deptYear',
deptDate='$this->deptDate',
deptRef='$this->deptRef',
pbriId='$this->pbriId',
deptIsCenter='$this->deptIsCenter',
receiveIn='$this->receiveIn',
receiveOut='$this->receiveOut',
sendIn='$this->sendIn',
sendOut='$this->sendOut',
deptNo='".th2a($this->deptNo)."',
docGroup='$this->docGroup',
depttypeId='$this->depttypeId',
deptParentId='$this->deptParentId',
deptLevel='$this->deptLevel',
deptGroup='$this->deptGroup',
attachFile='$this->attachFile'
where deptId='$this->deptId'";
}
return $this->Dml($sql);
}
function Delete(){
return $this->Dml("delete from Department where deptId='$this->deptId'");
}
function GetNextCode(){
$this->SetQuery("select max(deptId) as num from Department");
if ($result=$this->GetResult()) {
return $result['num']+1;
}
}
function RSdepartment(){
$this->SetQuery("select * from Department order by data_sort, deptId");
}
function GetRecord(){
$numFields = $this->NumField();
$row = $this->GetResult();
if ($row){
for ($i=0; $i<$numFields; $i++){
eval("\$this->".mysql_field_name($this->rs, $i)."=\$row['".mysql_field_name($this->rs, $i)."'];");
$this->deptName=a2th($this->deptName);
$this->deptDesc=a2th($this->deptDesc);
}
return true;
}else{ // clear value of Member;
for ($i=0; $i<$numFields; $i++){
eval("\$this->".mysql_field_name($this->rs, $i)."='';");
}
return false;
}
}
function SearchByKey($xKey){
if ($this->SetQuery("select * from Department where deptId= '$xKey'")){
return 1;
}else {
return 0;
}
}
//****************** You can add new functions below **********************//
function SearchByDeptRef($xKey){
if($this->SetQuery("select * from Department where deptRef = '$xKey'")){
return 1;
}else {
return 0;
}
}
function SearchBydeptParent(){ /////
$this->SetQuery("select deptName from Department");
}
function RSDeptByMaxdeptDate(){
$maxdate = $this->MaxDate();
$this->SetQuery("select * from Department where deptDate = '$maxdate' order by deptId asc");
}
function MaxDate(){
$this->SetQuery("select max(deptDate) as num from Department");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function searchMaxDate($xKey){
if($this->SetQuery("select deptDate from Department where deptDate >'$xKey' order by deptDate asc limit 1")){
return 1;
}else {
return 0;
}
}
function SearchDeptByMaxdeptDate($xKey){
$maxdate = $this->MaxDate();
$this->SetQuery("select * from Department where deptId='$xKey' and deptDate = '$maxdate' order by deptId");
}
function SearchMaxDocGroup(){
$this->SetQuery("select max(docGroup) as num from Department");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function SearchBydeptDateDocGroup($xKey){
$this->SetQuery("select * from Department where docGroup='$xKey' order by deptId");
}
function SearchBydeptDateDocGroup2($xKey){
$this->SetQuery("select * from Department where docGroup='$xKey' order by deptId");
}
function SearchDeptName($xKey){
$this->SetQuery("select deptName as name from Department where deptId= '$xKey'");
if ($result=$this->GetResult()) {
return $result['name'];
}
}
function SearchBydeptParentnot0($xKey){ /////
$this->SetQuery("select * from Department where deptDate!='$xKey' order by deptDate desc ,deptId asc");
}
function RSMainDepartment(){
$maxdate = $this->MaxDate();
// ===================================================================================================================
// Edit By Chain manual order department = 2015/04/24 ================================================================
// ===================================================================================================================
// $sql = "select * from Department where deptParentId=0 and deptDate = '$maxdate' order by deptParentId";
$sql = "select * from Department where deptParentId=0 and deptDate = '$maxdate' order by deptParentId , FIELD( deptId, 2411 ) , deptId ASC";
$this->SetQuery($sql);
}
function searchdeptDate2($xKey){
$this->SetQuery("select * from Department where deptParentId=0 and deptDate='$xKey' order by deptParentId asc , deptId asc");
}
function searchdeptDateNew($xKey){ //deptParentId=0 and
$this->SetQuery("select * from Department where deptDate='$xKey' order by deptParentId asc , deptId asc");
}
function searchdeptDate($xKey){
$this->SetQuery("select deptId from Department where deptParentId=0 and deptDate='$xKey' order by deptParentId asc , deptId asc");
}
function RSmenuByDeptParent2($dId){
$maxdate = $this->MaxDate();
$sql = "select * from Department where deptParentId='$dId' and deptDate = '$maxdate' order by deptId";
$this->SetQuery($sql);
}
function RSmenuByDeptParent3($dId){
$maxdate = $this->MaxDate();
$sql = "select deptId from Department where deptParentId='$dId' and deptDate = '$maxdate' order by deptId";
$this->SetQuery($sql);
}
function RSDeptByMaxdeptDate2(){
$maxdate = $this->MaxDate();
$this->SetQuery("select * from Department where deptDate = '$maxdate' order by deptId asc");
}
function SearchNameDeptByMaxdeptDate($xKey){
$maxdate = $this->MaxDate();
$this->SetQuery("select deptName from Department where deptId='$xKey' and deptDate = '$maxdate' order by deptId");
}
//---------------for semi system-------------------------------------------------------------------------------------
function RSdeptGroupBydeptDate($xKey){
$sql = "select deptDate from Department group by deptDate order by deptDate desc";
$this->SetQuery($sql);
}
function RSMainDepartmentdeptDate($xKey){
$sql = "select deptId from Department where deptParentId=0 and deptDate='$xKey' order by deptParentId asc , deptId asc";
$this->SetQuery($sql);
}
function RSMainDepartment2($xKey,$yKey){
$sql = "select deptId from Department where deptParentId=0 and deptDate='0000-00-00' order by deptParentId asc , deptId asc";
$this->SetQuery($sql);
}
function RSmenuByDeptParent2deptdate0($dId){
$sql = "select deptId from Department where deptParentId=$dId and deptDate = '0000-00-00' order by deptId";
$this->SetQuery($sql);
}
function RSdepthavedeptParentId($xKey){
$sql = "select * from Department where deptParentId ='$xKey'";
$this->SetQuery($sql);
}
function RSmenuByDeptParent2deptdate0deptDate($dId,$xKey){
$sql = "select deptId from Department where deptParentId=$dId and deptDate='$xKey' order by deptId";
$this->SetQuery($sql);
}
function RSmenuByDeptParentdeptDate($dId,$deptDate){
$sql = "select * from Department where deptParentId=$dId and deptDate = '$deptDate' order by deptId";
$this->SetQuery($sql);
}
function MaxDatepeople($dbperson){
$this->SetQuery("select max(deptDate) as num from $dbperson.Department");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSDeptByMaxdeptDatepeople($dbperson){
$maxdate = $this->MaxDatepeople($dbperson);
$this->SetQuery("select * from $dbperson.Department where deptDate = '$maxdate' and deptParent=1 order by deptId asc");
}
function searchdeptDate_($xKey){
$this->SetQuery("select * from Department where deptDate='$xKey' order by deptId asc");
}
function SearchByKeypeople($dbperson,$deptId){
$this->SetQuery("select * from $dbperson.Department where deptId='$deptId'");
}
function RSdeptSetgroupHeaddeptDate0(){
$sql = "select * from Department where depttypeId < '3' and deptDate='0000-00-00'";
$this->SetQuery($sql);
}
function RSMainDepartmentdeptDate0(){
$sql = "select * from Department where deptDate='0000-00-00' order by deptParentId";
$this->SetQuery($sql);
}
function SearchByShowDocNo($deptId){
$sql = "select deptLevel, deptParentId from Department where deptId='$deptId'";
$this->SetQuery($sql);
}
function SearchByShowselectdoc($deptId){
$sql = "select deptId, deptParentId, deptName from Department where deptId='$deptId'";
$this->SetQuery($sql);
}
function GetDeptName($xKey){
$this->SetQuery("select deptName as num from Department where deptId= '$xKey'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetattachFile($xKey){
$this->SetQuery("select attachFile as num from Department where deptId= '$xKey'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function SearchMaxDocGroupUsed(){
$this->SetQuery("select max(docGroup) as num from Department where deptDate!='0000-00-00'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function searchdeptDate3($xKey){
$this->SetQuery("select * from Department where deptDate='$xKey' order by deptParentId asc , deptId asc");
}
} //--End class department--
?>
|