Viewing file:  clsRunningDoc.php (8.46 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class runningrsdoc--------------------------
//--PK of runningrsdoc ::
// 1. rRsID
include_once "../link/keyThai.php";
class runningdoc extends clsDB{
var $result;
var $rID;
var $DtID;
var $deptId;
var $receiveNoStart;
var $receiveNo;
var $sendNoStart;
var $sendNo;
var $regisNoStart;
var $regisNo;
var $docGroup;
var $confirm;
var $docNoMix;
function runningdoc(&$c){
$this->c=$c->c;
$this->DB=$c->db;
}
function Save(){
if ($this->status==1){
//uncomment a line below if your table use ID as running number
//$this->rID=$this->GetNextCode();
$sql = "insert into RunningDoc values(
'".th2a($this->rID)."',
'".th2a($this->DtID)."',
'".th2a($this->deptId)."',
'".th2a($this->receiveNoStart)."',
'".th2a($this->receiveNo)."',
'".th2a($this->sendNoStart)."',
'".th2a($this->sendNo)."',
'".th2a($this->regisNoStart)."',
'".th2a($this->regisNo)."',
'".th2a($this->docGroup)."',
'".th2a($this->confirm)."',
'".th2a($this->docNoMix)."'
)";
}else {
$sql = "update RunningDoc set
DtID='".th2a($this->DtID)."',
deptId='".th2a($this->deptId)."',
receiveNoStart='".th2a($this->receiveNoStart)."',
receiveNo='".th2a($this->receiveNo)."',
sendNoStart='".th2a($this->sendNoStart)."',
sendNo='".th2a($this->sendNo)."',
regisNoStart='".th2a($this->regisNoStart)."',
regisNo='".th2a($this->regisNo)."',
docGroup='".th2a($this->docGroup)."',
confirm='".th2a($this->confirm)."',
docNoMix='".th2a($this->docNoMix)."'
where rID='".th2a($this->rID)."'";
}
return $this->Dml($sql);
}
function Delete(){
return $this->Dml("delete from RunningDoc where rID='$this->rID'");
}
function GetNextCode(){
$this->SetQuery("select max(rID) as num from RunningDoc");
if ($result=$this->GetResult()) {
return $result['num']+1;
}
}
function RSRunningDoc(){
$this->SetQuery("select * from RunningDoc order by rID");
}
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)."'];");
}
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 RunningDoc where rID= '$xKey'")){
return 1;
}else {
return 0;
}
}
//****************** You can add new functions below **********************//
function SearchBydocGroup($xKey){
if ($this->SetQuery("select * from RunningDoc where docGroup= '$xKey'")){
return 1;
}else {
return 0;
}
}
function SearchBydocGroupRunAll($xKey){
if ($this->SetQuery("select * from RunningDoc where docGroup= '$xKey' and deptId='0'")){
return 1;
}else {
return 0;
}
}
function SearchBydocGroupNoRunAll($xKey){
if ($this->SetQuery("select * from RunningDoc where docGroup= '$xKey' and deptId!='0'")){
return 1;
}else {
return 0;
}
}
function SearchByconfirmRunAll($xKey){
if ($this->SetQuery("select * from RunningDoc where docGroup= '$xKey' and confirm = 'Y' and deptId='0' group by docGroup")){
return 1;
}else {
return 0;
}
}
function SearchByconfirmNoRunAll($xKey){
if ($this->SetQuery("select * from RunningDoc where docGroup= '$xKey' and confirm = 'Y' and deptId!='0' group by docGroup")){
return 1;
}else {
return 0;
}
}
function SearchBydocGroupDtID($xKey,$yKey){
if ($this->SetQuery("select * from RunningDoc where docGroup= '$xKey' and DtID = '$yKey'")){
return 1;
}else {
return 0;
}
}
function SearchBydocGroupDtIDdocNoMixY($xKey,$yKey){
if ($this->SetQuery("select * from RunningDoc where docGroup= '$xKey' and DtID = '$yKey' and docNoMix='Y'")){
return 1;
}else {
return 0;
}
}
function SearchBydocGroupDtIDDept($xKey,$yKey,$zKey){
if ($this->SetQuery("select * from RunningDoc where docGroup= '$xKey' and DtID = '$yKey' and deptId = '$zKey'")){
return 1;
}else {
return 0;
}
}
function SearchBydocGroupDtIDDeptdocNoMixN($xKey,$yKey,$zKey){
if ($this->SetQuery("select * from RunningDoc where docGroup= '$xKey' and DtID = '$yKey' and deptId = '$zKey' and docNoMix='N'")){
return 1;
}else {
return 0;
}
}
function SearchRunningBydocGroupDtID($xKey,$yKey){
if ($this->SetQuery("select * from RunningDoc where docGroup= '$xKey' and DtID = '$yKey'")){
return 1;
}else {
return 0;
}
}
function SearchRunningBydocGroupDtIDdocNoMixN($xKey,$yKey,$zKey){
if ($this->SetQuery("select * from RunningDoc where docGroup= '$xKey' and DtID = '$yKey' and deptId = '$zKey' and docNoMix='N'")){
return 1;
}else {
return 0;
}
}
function SearchRunningBydocGroupDtIDdocNoMixY($xKey,$yKey){
if ($this->SetQuery("select * from RunningDoc where docGroup= '$xKey' and DtID = '$yKey' and docNoMix='Y'")){
return 1;
}else {
return 0;
}
}
function SearchRunningBydocGroupDtIDDept($xKey,$yKey,$zKey){
if ($this->SetQuery("select * from RunningDoc where docGroup= '$xKey' and DtID = '$yKey' and deptId='$zKey'")){
return 1;
}else {
return 0;
}
}
function SearchRunningBydocGroupDtIDDept2($xKey,$yKey,$zKey){
if ($this->SetQuery("select * from RunningDoc where docGroup= '$xKey' and DtID = '$yKey' and deptId='$zKey'")){
return 1;
}else {
return 0;
}
}
function SearchRunningBydocGroupDtID2($xKey,$yKey){
if ($this->SetQuery("select * from RunningDoc where docGroup= '$xKey' and DtID = '$yKey'")){
return 1;
}else {
return 0;
}
}
function SearchRunningBydocGroupDtIDfunct($xKey,$yKey){
if ($this->SetQuery("select
confirm, receiveNo, receiveNoStart,
sendNo, sendNoStart, regisNo, regisNoStart
from RunningDoc where docGroup= '$xKey' and DtID = '$yKey'")){
return 1;
}else {
return 0;
}
}
function SearchRunningBydocGroupDtIDfunctdocNoMixY($xKey,$yKey){
if ($this->SetQuery("select
confirm, receiveNo, receiveNoStart,
sendNo, sendNoStart, regisNo, regisNoStart
from RunningDoc where docGroup= '$xKey' and DtID = '$yKey' and docNoMix='Y'")){
return 1;
}else {
return 0;
}
}
function SearchRunningBydocGroupDtIDfunctdocNoMixY2($xKey,$yKey){
if ($this->SetQuery("select * from RunningDoc where docGroup= '$xKey' and DtID = '$yKey' and docNoMix='Y'")){
return 1;
}else {
return 0;
}
}
function SearchRunningBydocGroupDtIDfunctDept($xKey,$yKey,$zKey){
if ($this->SetQuery("select
confirm, receiveNo, receiveNoStart,
sendNo, sendNoStart, regisNo, regisNoStart
from RunningDoc where docGroup= '$xKey' and DtID = '$yKey' and deptId='$zKey'")){
return 1;
}else {
return 0;
}
}
function SearchRunningBydocGroupDtIDfunctDeptdocNoMixN($xKey,$yKey,$zKey){
if ($this->SetQuery("select
confirm, receiveNo, receiveNoStart,
sendNo, sendNoStart, regisNo, regisNoStart
from RunningDoc where docGroup= '$xKey' and DtID = '$yKey' and deptId='$zKey' and docNoMix='N' ")){
return 1;
}else {
return 0;
}
}
function SearchRunningBydocGroupDtIDfunctDeptdocNoMixN2($xKey,$yKey,$zKey){
if ($this->SetQuery("select * from RunningDoc where docGroup= '$xKey' and DtID = '$yKey' and deptId='$zKey' and docNoMix='N' ")){
return 1;
}else {
return 0;
}
}
function SearchRunningGetNo($xKey,$yKey,$zKey){
if ($this->SetQuery("select receiveNo,sendNo,regisNo from RunningDoc where docGroup= '$xKey' and DtID = '$yKey' and deptId='$zKey'")){
return 1;
}else {
return 0;
}
}
function SearchRunningGetNodocNoMixN($xKey,$yKey,$zKey){
if ($this->SetQuery("select receiveNo,sendNo,regisNo from RunningDoc where docGroup= '$xKey' and DtID = '$yKey' and deptId='$zKey' and docNoMix='N' ")){
return 1;
}else {
return 0;
}
}
function SearchRunningGetNodocNoMixY($xKey,$yKey){
if ($this->SetQuery("select receiveNo,sendNo,regisNo from RunningDoc where docGroup= '$xKey' and DtID = '$yKey' and docNoMix='Y' ")){
return 1;
}else {
return 0;
}
}
function SearchRunningGetNoRunAll($xKey,$yKey){
if ($this->SetQuery("select receiveNo,sendNo,regisNo from RunningDoc where docGroup= '$xKey' and DtID = '$yKey'")){
return 1;
}else {
return 0;
}
}
function SearchRunningGetNoRunAlldocNoMixN($xKey,$yKey){
if ($this->SetQuery("select receiveNo,sendNo,regisNo from RunningDoc where docGroup= '$xKey' and DtID = '$yKey' and docNoMix='N'")){
return 1;
}else {
return 0;
}
}
function SearchRunningGetNoRunAlldocNoMixY($xKey,$yKey){
if ($this->SetQuery("select receiveNo,sendNo,regisNo from RunningDoc where docGroup= '$xKey' and DtID = '$yKey' and docNoMix='Y'")){
return 1;
}else {
return 0;
}
}
} //--End class runningdoc--
?>
|