public function writeToDB() { CMSConnect(); $conferenceWriteSQL = "INSERT INTO tbl_conference_reservations VALUES (\n\t\t\t'{$this->callID}',\n\t\t\t'{$this->callDatetime}',\n\t\t\t'{$this->callDuration}',\n\t\t\t'{$this->chairName}',\n\t\t\t'{$this->notes}',\n\t\t\t'{$this->chairNumber}',\n\t\t\t'{$this->clientRef}',\n\t\t\t'{$this->company}',\n\t\t\t'{$this->confTitle}',\n\t\t\t'{$this->dialType}',\n\t\t\t'{$this->numDILines}',\n\t\t\t'{$this->numDOLines}',\n\t\t\t'{$this->resDate}',\n\t\t\t'{$this->schedulerTel}',\n\t\t\t'{$this->scheduler}',\n\t\t\t'{$this->takenBy}',\n\t\t\t'{$this->conferenceType}',\n\t\t\t'{$this->bridge}',\n\t\t\t'{$this->leadop}',\n\t\t\t'{$this->isCancelled}',\n\t\t\t'{$this->accountNumber}',\n\t\t\t'{$this->lastEdited}',\n\t\t\t'{$this->lastEditedBy}')\n\t\t\t"; //echo $conferenceWriteSQL; $conferenceWriteResult = mysql_query($conferenceWriteSQL) or die("Query failed : " . mysql_error()); }
<HTML> <HEAD> <TITLE>Chorus Call South Africa - Call Management System</TITLE> <meta http-equiv="refresh" content="60"> </HEAD> <BODY> <?php require_once "cms_include.php"; CMSConnect(); $today = date("Ymd"); $today_display = date("F dS, Y"); $tomorrow = mktime(0, 0, 0, date("m"), date("d") + 1, date("Y")); $tomorrow_display = date("F dS, Y", $tomorrow); $tomorrow = date("Ymd", $tomorrow); $yesterday = mktime(0, 0, 0, date("m"), date("d") - 1, date("Y")); $yesterday_display = date("F dS, Y", $yesterday); $yesterday = date("Ymd", $yesterday); $day_after_tomorrow = mktime(0, 0, 0, date("m"), date("d") + 2, date("Y")); $day_after_tomorrow_display = date("F dS, Y", $day_after_tomorrow); $day_after_tomorrow = date("Ymd", $day_after_tomorrow); $two_days_after_tomorrow = mktime(0, 0, 0, date("m"), date("d") + 3, date("Y")); $two_days_after_tomorrow_display = date("F dS, Y", $two_days_after_tomorrow); $two_days_after_tomorrow = date("Ymd", $two_days_after_tomorrow); // First, Display Yesterdays calls for printing billings forms, or editing echo "<table width='100%' border='1' cellspacing='0' cellpadding='1' bordercolor='white' rules=rows>\n"; echo "<tr><td colspan=11 bgcolor='#99cccc'><Font face ='Verdana' size=3><b><p align=center>Calls yesterday - {$yesterday_display} </b></td></tr>\n"; DisplayCallsOnDate($yesterday, $yesterday); echo "</table>\n"; //Now, show todays calls for printing resforms and editing echo "<table width='100%' border='1' cellspacing='0' cellpadding='1' bordercolor='white' rules=rows>\n";