Viewing file:  clsProgramStructure.php (3.07 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class ProgramStructure--------------------------
include_once "clsbase_ProgramStructure.php";
class ProgramStructure extends base_ProgramStructure{
//-- Use on page programs.php --
function RSProgramStructureByPgIdOredrBySeq($xKey){
$this->SetQuery("select * from ProgramStructure where programId='$xKey' order by sequence");
}
function RSProgramStructureByPgIdCdId1CdId2($xKey,$yKey,$zKey){
$this->SetQuery("select * from ProgramStructure where programId='$xKey' and conditionId1='$yKey' and conditionId2='$zKey' order by sequence");
}
function CountCondition1($xKey,$yKey){
$this->SetQuery("select count(conditionId1) as num from ProgramStructure where programId='$xKey' and conditionId1='$yKey'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
//-- The end --
function RSProgramStructureByPgIdGroupCdId1($xKey){
$this->SetQuery("select conditionId1, max(creditTotal) as creditTotal from ProgramStructure where programId='$xKey' group by conditionId1 order by sequence");
}
function RSProgramStructureByPgIdAndCdId2IsH($xKey){
$this->SetQuery("select * from ProgramStructure where programId='$xKey' and conditionId2=1");
}
function RSProgramStructureByPgIdOrderSeq($xKey){
// $this->SetQuery("select * from ProgramStructure where programId='$xKey' group by conditionId1");
$this->SetQuery("select * from ProgramStructure where programId='$xKey' and conditionId2=1 order by sequence");
}
function RSProgramStructureByPgIdOrderSeq2($xKey,$yKey){
//$this->SetQuery("select * from ProgramStructure where programId='$xKey' and conditionId1='$yKey' group by conditionId2");
$this->SetQuery("select * from ProgramStructure where programId='$xKey' and conditionId1='$yKey' and conditionId2!=1 order by sequence");
}
function GetSumPgCr($xKey){
$this->SetQuery("select sum(creditTotal) as num from ProgramStructure where programId='$xKey' and conditionId2=1");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetSumPgCr2($xKey,$yKey){
$this->SetQuery("select sum(creditTotal) as num from ProgramStructure where programId='$xKey' and conditionId1='$yKey' and conditionId2=1");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetSumCd1Cr($xKey, $yKey){
$this->SetQuery("select sum(creditTotal) as num from ProgramStructure where programId='$xKey' and conditionId1='$yKey' and conditionId2>1");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetSumCd1Cr2($xKey, $yKey, $zKey){
$this->SetQuery("select sum(creditTotal) as num from ProgramStructure where programId='$xKey' and conditionId1='$yKey' and conditionId2='$zKey' ");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSProgramStructureByPgIdAndCd1($xKey, $yKey){
$this->SetQuery("select * from ProgramStructure where programId='$xKey' and conditionId1='$yKey' and conditionId2>1");
}
function GetNextCodeCG($xKey,$yKey){
$this->SetQuery("select max(sequence) as num from ProgramStructure where programId='$xKey' and conditionId1='$yKey' ");
if ($result=$this->GetResult()) {
return $result['num']+1;
}
}
} //--End class Program--
?>
|