Viewing file:  clsdocNews.php (3.33 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include_once "../link/keyThai.php";
class docNews extends clsDB{
var $result;
var $dnId;
var $newsSubject;
var $newsDetail;
var $newsStartDate;
var $newsEndDate;
var $postDate;
var $postName;
function docNews(&$c){
$this->c=$c->c;
$this->DB=$c->db;
}
function AddNew(){
$this->status = 1;
}
function Edit(){
$this->status = 2;
}
function Save(){
if($this->newsStartDate==''){ $this->newsStartDate='0000-00-00'; }
if($this->newsEndDate==''){ $this->newsEndDate='0000-00-00'; }
if($this->postDate==''){ $this->postDate='0000-00-00 00:00:00'; }
if ($this->status==1){
$sql = "insert into docNews values(
'".th2a($this->dnId)."',
'".th2a($this->newsSubject)."',
'".th2a($this->newsDetail)."',
'".th2a($this->newsStartDate)."',
'".th2a($this->newsEndDate)."',
'".th2a($this->postDate)."',
'".th2a($this->postName)."'
)";
}else {
$sql = "update docNews set
newsSubject='".th2a($this->newsSubject)."',
newsDetail='".th2a($this->newsDetail)."',
newsStartDate='".th2a($this->newsStartDate)."',
newsEndDate='".th2a($this->newsEndDate)."',
postDate='".th2a($this->postDate)."',
postName='".th2a($this->postName)."'
where dnId='".th2a($this->dnId)."'";
}
return $this->Dml($sql);
}
function Delete(){
return $this->Dml("delete from docNews where dnId='$this->dnId'");
}
function GetNextCode(){
$this->SetQuery("select max(dnId) as num from docNews");
if ($result=$this->GetResult()) {
return $result['num']+1;
}
}
function RSdocNews(){
$this->SetQuery("select * from docNews order by postDate desc");
}
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->newsSubject=a2th($this->newsSubject);
}
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 docNews where dnId= '$xKey'")){
return 1;
}else {
return 0;
}
}
function SearchByKeylimit(){
if ($this->SetQuery("select * from docNews order by dnId asc limit 1")){
return 1;
}else {
return 0;
}
}
function SearchByNewsDate($nowdate){
if ($this->SetQuery("select * from docNews where '$nowdate'>=newsStartDate and '$nowdate'<=newsEndDate order by postDate desc limit 0, 4")){
return 1;
}else {
return 0;
}
}
function SearchCountNews(){
//echo "select a.*,b.DrsID,b.DrsFromDrsID,b.DrsReceiveDate from Documents a inner join DocReceiveSend b on (a.DlcID= '$xKey' || a.DlcID= '$zKey4') and a.DocGroup='$yKey' and a.fDelete!='Y' and a.DsID='0' and a.DsID=b.DsID and a.DocID=b.DocID and b.DrsSendDate='0000-00-00 00:00:00' order by a.DocDateCreate desc , a.DocID desc";
$this->SetQuery("select count(dnId) as num from docNews order by postDate desc");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function SearchByNewsmontheYearDate($xKey,$yKey){
if ($this->SetQuery("select * from docNews where `newsStartDate` LIKE '$yKey-$xKey-%' || `newsEndDate` LIKE '$yKey-$xKey-%' order by dnId desc")){
return 1;
}else {
return 0;
}
}
//****************** You can add new functions below **********************//
} //--End class base_DocSpeedLevel--
?>
|