trainingcentreschedule.php

/training/trainingcentreschedule.php

https://bitbucket.org/molusc/sma-website
PHP | 152 lines | 142 code | 10 blank | 0 comment | 11 complexity | e80b046f729c1d28d4141209eb54e1c4 MD5 | raw file
Possible License(s): BSD-3-Clause

<?php session_start();  ?>
<?php require_once('../Connections/bryanmadge.php'); ?>
<?php

if (!isset($_GET["club"]))
    $_GET["club"] = "cf";
$clubprefix = $_GET["club"];

if (!isset($_GET["orderby"]))
    $_GET["orderby"] = "course_date";
$sortorder = $_GET["orderby"];

$colname_ClubInfo = "cf";
if (isset($HTTP_GET_VARS['club'])) {
  $colname_ClubInfo = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['club'] : addslashes($HTTP_GET_VARS['club']);
}
mysql_select_db($database_bryanmadge, $bryanmadge);
$query_ClubInfo = sprintf("SELECT trainingclubs.clubid, trainingclubs.clubname, trainingclubs.clubprefix, trainingclubs.standardfees, trainingclubs.clubfees, UNIX_TIMESTAMP(trainingclubs.feesfixeduntilend) AS feesfixeduntilend, trainingclubs.coursetime, trainingclubs.description FROM trainingclubs WHERE clubprefix = '%s'", $clubprefix);
$ClubInfo = mysql_query($query_ClubInfo, $bryanmadge) or die(mysql_error());
$row_ClubInfo = mysql_fetch_assoc($ClubInfo);
$totalRows_ClubInfo = mysql_num_rows($ClubInfo);

mysql_select_db($database_bryanmadge, $bryanmadge);
$query_TrainingClub = "SELECT schedule.course_id, schedule.course_title_id, catalog.title, UNIX_TIMESTAMP(schedule.course_date) AS course_date,  schedule.course_town, schedule.course_venue_id, schedule.course_classification
FROM schedule INNER JOIN catalog ON schedule.course_title_id = catalog.catalog_id
WHERE catalog.categoryid NOT IN(21) AND schedule.course_classification Like '$clubprefix%' ORDER BY $sortorder";
$TrainingClub = mysql_query($query_TrainingClub, $bryanmadge) or die(mysql_error());
$row_TrainingClub = mysql_fetch_assoc($TrainingClub);
$totalRows_TrainingClub = mysql_num_rows($TrainingClub);
?>
<html><!-- InstanceBegin template="/Templates/general.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<LINK REL="SHORTCUT ICON" HREF="../favicon.ico">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="GENERATOR" content="Dreamweaver MX">
<meta name="keywords" content="CDM Regulations, CESMM, civil engineering, construction management, contract administration, contract procedures, courses, environmental awareness, geotechnical, Health and safety, ICE Conditions of Contract, ICE Professional Review, JCT Form of Contract, Method of Measurement for Highway Works, MMHW, NEC New Engineering and Construction Contract, Project management, report writing, site supervision, Standard Forms of Contract, training, AMPR, CET, CPD, TMPR, Eurocodes">
<!-- #BeginEditable "doctitle" -->
<title><?php echo $row_ClubInfo['clubname']; ?> Training Club Schedule - Symmons Madge Associates Ltd</title>
<!-- #EndEditable -->
<link rel="stylesheet" href="../bma.css" type="text/css">
<link rel="stylesheet" href="../print.css" type="text/css" media="print" />
<!-- InstanceParam name="OptionalPageTitle" type="boolean" value="true" --><!-- InstanceParam name="OptionalBreadcrumbs" type="boolean" value="true" --><!-- InstanceParam name="Google Analytics Code" type="boolean" value="true" -->
</head>

<body><div class="printhide"><!-- #BeginLibraryItem "/Library/Masthead.lbi" -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="150" rowspan="2"><a href="../home.html" target="_top">
      <!--        	<img src="../images/smalogo_sml_party_hat.gif" ALT="Symmons Madge Associates Ltd home" width="124" height="90" border="0">
-->
      <img src="../images/smalogo_sml.gif" ALT="Symmons Madge Associates Ltd home" width="124" height="64" border="0"> </a></td>
    <td><p class="tagline"><font size="4">Training for a Successful Future</font></p></td>
  </tr>
  <tr>
    <td valign="bottom"><table class="masthead" width="100%" height=25 border="0" cellpadding="0" cellspacing="0">
      <tr>
        <!--  	<td width="5%" bgcolor="#FFFFFF">&nbsp;</td>-->
        <td align="left" valign="top"><img src="/images/corner_TL.gif" width="15" height="25"></td>
        <td>&nbsp;&nbsp;<a 		  
						href="../courses/index.php" target="_top">Courses</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
						href="../diary/diary.php" target="_top">Course&nbsp;Diary</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
						href="training-club.php" target="_top">Regional Training</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
						href="../consultancy/index.html" target="_top">Consultancy</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
						href="../search/index.php" target="_top">Search</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
                        href="../links.html" target="_top">Links</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
						href="../company/about.html" target="_top">About us</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
						href="../contact.html" target="_top">Contact</a>&nbsp;&nbsp;</td>
      </tr>
    </table></td>
  </tr>
</table>
<!-- #EndLibraryItem --></div>
<div class="printonly">
  <div align="right"><img src="../images/smalogo_sml.gif" width="124" height="64" class="floatright"></div>
</div>
<div id="main"> 
  <p class="breadcrumbs printhide"><!-- #BeginEditable "breadcrumbs" --><a href="/home.html" target="_top">Home</a>&nbsp;&gt;&nbsp;<a href="index.html">Training</a>&nbsp;&gt;&nbsp;<a href="trainingcentre.php">Regional
    Training Centres</a>&nbsp;&gt;&nbsp;<?php echo $row_ClubInfo['clubname']; ?><!-- #EndEditable --></p>
  <h1 class="bmapagetitle"><!-- #BeginEditable "title" --> <?php echo $row_ClubInfo['clubname']; ?> Training Centre schedule <!-- #EndEditable --></h1>
  <!-- #BeginEditable "body" -->
	<div class="bmabody">
      <p>
        <?php // echo $query_TrainingClub ?>
      </p>
      <h2>We welcome both members and external delegates on all Training Centre courses</h2>
      <p><?php echo $row_ClubInfo['description']; ?></p>
    <table BORDER="0" CELLPADDING="2" CELLSPACING="3">
      <tr>
        <td COLSPAN=2><div align="right" class="bmabody"><font size="-1">Sort by: <a href="training-club-schedule.php?orderby=course_date&club=<? echo $clubprefix ?>">Date</a> or <a href="training-club-schedule.php?orderby=title&club=<? echo $clubprefix ?>">Course Title</a></font></div></td>
      </tr>
      <tr bgcolor="#000066"><td class="bmatableheaderlink"><div align="left"><font color="#FFFFFF" SIZE="-1"><strong><a href="training-club-schedule.php?orderby=course_date&club=<? echo $clubprefix ?>">Date</a></strong></font></div></td>
        <td class="bmatableheaderlink"><div align="left"><font color="#FFFFFF" SIZE="-1"><strong><a href="training-club-schedule.php?orderby=title&club=<? echo $clubprefix ?>">Course Title </a></strong></font></div></td>

      </tr>
      <?php do { ?>
      <tr bgcolor="#E5E5E5"><td><div align="right"><font size="-1">
            <?php $dt = $row_TrainingClub['course_date'];
		echo date('jS F Y', $dt);
		?>
        </font></div></td>
        <td><font size="-1"><?php echo "<a href=\"/courses/course-details.php?id=",$row_TrainingClub['course_title_id'],"\">",$row_TrainingClub['title'],"</a>"; ?></font></td>

      </tr>
      <?php } while ($row_TrainingClub = mysql_fetch_assoc($TrainingClub)); ?>
    </table>
    <p>The course time for this Training Centre is <strong><?php echo $row_ClubInfo['coursetime']; ?>.</strong></p>
    <h3>Fees (to end
    <?php $dt = $row_ClubInfo['feesfixeduntilend'];
		echo date('M Y', $dt); ?>)
</h3>
	<?php
	if(isset($_SESSION['company']))
		echo '<p style="color: #FF0000"><strong>Discounted rate for '.$_SESSION['company'].' Employees: &pound;'.$_SESSION['companyrate'].' per day + VAT.</strong></p><p>&nbsp;</p.';
	else {
 ?>
    <p>Standard Rate &pound;<?php echo $row_ClubInfo['standardfees']; ?> + VAT per day.<br>
    Club Members &pound;<?php echo $row_ClubInfo['clubfees']; ?> + VAT per day.</p>
    <ul>
      <li>If your organisation has already, or decides to commit to a minimum of 12 places over the training year, you would qualify for the members&rsquo; discounted rate - please ask for details</li>
      <li> Payment - we invoice after each course</li>
    </ul>
	<?php } ?>
    <p><strong>For further information</strong> please contact Sue Chatfield:<br>
    Tel 01446 775959 - Fax 01446 775758<br>
    Email <a href="mailto:sue.chatfield@symmonsmadge.co.uk">sue.chatfield@symmonsmadge.co.uk</a></p>
  </div>
<!-- #EndEditable --></div>
<div class="printhide"><!-- #BeginLibraryItem "/Library/Full Footer.lbi" --><hr width="65%">
<p align="center"><!-- #BeginLibraryItem "/Library/Footer.lbi" --><!-- #EndLibraryItem --></p>

<!-- #EndLibraryItem --><!-- #BeginLibraryItem "/Library/Legal footer.lbi" --><div align="center" class="bmabody"><font size="1"><a href="../company/legal.html">Legal
      Notice</a><br>
  Copyright &copy; Symmons Madge Associates Ltd, All Rights Reserved</font></div>
<!-- #EndLibraryItem --><!-- Start of StatCounter Code -->
<script type="text/javascript" language="javascript">
var sc_project=337750; 
var sc_partition=1; 
</script>

<script type="text/javascript" language="javascript" src="http://www.statcounter.com/counter/counter.js"></script><noscript>
<a href="http://www.statcounter.com/" target="_blank"><img  src="http://c2.statcounter.com/counter.php?sc_project=337750&amp;java=0" alt="counter stats" border="0"></a>
</noscript>
<!-- End of StatCounter Code -->
<!-- InstanceBeginEditable name="EditRegion1" --><!-- #BeginLibraryItem "/Library/Google Analytics PHP Include.lbi" -->
	<?php include_once($_SERVER['DOCUMENT_ROOT'] . "/analyticstracking.php"); ?><!-- #EndLibraryItem --><!-- InstanceEndEditable --></div>
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($ClubInfo);

mysql_free_result($TrainingClub);
?>