getRowSQL("SELECT tblCourseVenue.*, tblVenue.intMaxCapacity
FROM tblCourseVenue INNER JOIN tblVenue ON tblCourseVenue.refVenueID = tblVenue.VenueID
WHERE tblCourseVenue.refCourseID=$CourseID",0);
//$refVenueID = $rowCourseVenueID->refVenueID;
$intMaxCapacity = $rowCourseVenueID->intMaxCapacity;
$rowCourseVenue = $xdb->getRowSQL("SELECT * FROM tblCourseVenue INNER JOIN tblCourse on refCourseID = CourseID WHERE refCourseID = $CourseID",0);
$sql = "SELECT tblVenue.* FROM tblVenue Where blnActive = 1 ORDER BY strVenue";
$rst = $xdb->doQuery($sql);
while($row = $xdb->fetch_object($rst))
{
//ini
$disabled = "";
$rowCV = $xdb->getRowSQL("SELECT * FROM tblCourseVenue INNER JOIN tblCourse on tblCourseVenue.refCourseID = tblCourse.CourseID
WHERE tblCourseVenue.refVenueID = $row->VenueID AND (dtStartDate >= LEFT('$DT',10)) AND (dtEndDate <= LEFT('$DT',10))",0);
//$courseVenue ='('.$rowCourseVenue->strCourse.': '.$rowCourseVenue->dtStartDate.' --> '.$rowCourseVenue->dtEndDate.')';
print_rr($row);
//process
if($rowCV && $rowCV->refCourseID != $CourseID)
{//disabled!
$disabled = "disabled";
}
$ddlVenue .= "";
}
$strOutput = "
";
return $strOutput;
//return $this->renderTable("Venue");
}
public function getList()
{
global $SystemSettings;
$this->ListSQL("
SELECT tblVenue.VenueID, tblVenue.strVenue AS Venue, txtAddress as Address, tblVenue.intMaxCapacity AS 'Max Capacity', tblVenue.txtAddress AS Address, tblVenue.txtNotes AS Notes, tblVenue.blnActive AS Active,
tblVenue.strLastUser AS 'Last User', tblVenue.dtLastEdit AS 'Last Edit'
FROM tblVenue
WHERE 1=1 $Where
GROUP BY tblVenue.VenueID, tblVenue.strVenue, tblVenue.intMaxCapacity, tblVenue.txtAddress, tblVenue.txtNotes, tblVenue.blnActive, tblVenue.strLastUser, tblVenue.dtLastEdit
ORDER BY tblVenue.strVenue");
//print_rr($this->Columns["Select"]);
return $this->renderTable("Venue List");
}
public static function Save(&$VenueID)
{
$db = new NemoDatabase("tblVenue", $VenueID, null, 0);
$db->SetValues($_POST);
$db->Fields[strLastUser] = $_SESSION['USER']->USERNAME;
//$db->Fields[dtLastEdit] = date("YmdHi");
$result = $db->Save();
//print_rr($db->Fields);
if($VenueID == 0) $VenueID = $db->ID[VenueID];
if($result->Error == 1)
return $result->Message;
else
return "Details Saved. ";
}
public static function Delete($chkSelect)
{
global $xdb;
//print_rr($chkSelect);
if(count($chkSelect) > 0){
foreach($chkSelect as $key => $value)
{
$xdb->doQuery("DELETE FROM tblVenue WHERE VenueID = ". $xdb->qs($key));
}
return "Records Deleted.";
}
}
}
?>