<?php
session_start(); // Initialize Session data
ob_start(); // Turn on output buffering
?>
<?php include "ewcfg7.php" ?>
<?php include "ewmysql7.php" ?>
<?php include "phpfn7.php" ?>
<?php
// Global variable for table object
$orders_date_lesson = NULL;
//
// Table class for orders_date_lesson
//
class corders_date_lesson {
var $TableVar = 'orders_date_lesson';
var $TableName = 'orders_date_lesson';
var $TableType = 'REPORT';
var $id;
var $room;
var $order_date;
var $request_date;
var $return_date;
var $lesson;
var $starts;
var $ends;
var $teacher;
var $note;
var $fields = array();
var $UseTokenInUrl = EW_USE_TOKEN_IN_URL;
var $Export; // Export
var $ExportOriginalValue = EW_EXPORT_ORIGINAL_VALUE;
var $ExportAll = TRUE;
var $SendEmail; // Send email
var $TableCustomInnerHtml; // Custom inner HTML
var $BasicSearchKeyword; // Basic search keyword
var $BasicSearchType; // Basic search type
var $CurrentFilter; // Current filter
var $CurrentOrder; // Current order
var $CurrentOrderType; // Current order type
var $RowType; // Row type
var $CssClass; // CSS class
var $CssStyle; // CSS style
var $RowAttrs = array(); // Row custom attributes
var $TableFilter = "";
//
// Table class constructor
//
function corders_date_lesson() {
global $Language;
// id
$this->id = new cField('orders_date_lesson', 'orders_date_lesson', 'x_id', 'id', '`id`', 19, -1, FALSE, '`id`', FALSE);
$this->id->FldDefaultErrMsg = $Language->Phrase("IncorrectInteger");
$this->fields['id'] =& $this->id;
// room
$this->room = new cField('orders_date_lesson', 'orders_date_lesson', 'x_room', 'room', '`room`', 200, -1, FALSE, '`room`', FALSE);
$this->fields['room'] =& $this->room;
// order_date
$this->order_date = new cField('orders_date_lesson', 'orders_date_lesson', 'x_order_date', 'order_date', '`order_date`', 135, 5, FALSE, '`order_date`', FALSE);
$this->order_date->FldDefaultErrMsg = str_replace("%s", "/", $Language->Phrase("IncorrectDateYMD"));
$this->fields['order_date'] =& $this->order_date;
// request_date
$this->request_date = new cField('orders_date_lesson', 'orders_date_lesson', 'x_request_date', 'request_date', '`request_date`', 133, 5, FALSE, '`request_date`', FALSE);
$this->request_date->FldDefaultErrMsg = str_replace("%s", "/", $Language->Phrase("IncorrectDateYMD"));
$this->fields['request_date'] =& $this->request_date;
// return_date
$this->return_date = new cField('orders_date_lesson', 'orders_date_lesson', 'x_return_date', 'return_date', '`return_date`', 133, 5, FALSE, '`return_date`', FALSE);
$this->return_date->FldDefaultErrMsg = str_replace("%s", "/", $Language->Phrase("IncorrectDateYMD"));
$this->fields['return_date'] =& $this->return_date;
// lesson
$this->lesson = new cField('orders_date_lesson', 'orders_date_lesson', 'x_lesson', 'lesson', '`lesson`', 200, -1, FALSE, '`lesson`', FALSE);
$this->fields['lesson'] =& $this->lesson;
// starts
$this->starts = new cField('orders_date_lesson', 'orders_date_lesson', 'x_starts', 'starts', '`starts`', 134, -1, FALSE, '`starts`', FALSE);
$this->starts->FldDefaultErrMsg = $Language->Phrase("IncorrectTime");
$this->fields['starts'] =& $this->starts;
// ends
$this->ends = new cField('orders_date_lesson', 'orders_date_lesson', 'x_ends', 'ends', '`ends`', 134, -1, FALSE, '`ends`', FALSE);
$this->ends->FldDefaultErrMsg = $Language->Phrase("IncorrectTime");
$this->fields['ends'] =& $this->ends;
// teacher
$this->teacher = new cField('orders_date_lesson', 'orders_date_lesson', 'x_teacher', 'teacher', '`teacher`', 200, -1, FALSE, '`teacher`', FALSE);
$this->fields['teacher'] =& $this->teacher;
// note
$this->note = new cField('orders_date_lesson', 'orders_date_lesson', 'x_note', 'note', '`note`', 201, -1, FALSE, '`note`', FALSE);
$this->fields['note'] =& $this->note;
}
// Table caption
function TableCaption() {
global $Language;
return $Language->TablePhrase($this->TableVar, "TblCaption");
}
// Page caption
function PageCaption($Page) {
global $Language;
$Caption = $Language->TablePhrase($this->TableVar, "TblPageCaption" . $Page);
if ($Caption == "") $Caption = "Page " . $Page;
return $Caption;
}
// Report group level SQL
function SqlGroupSelect() { // Select
return "SELECT DISTINCT `request_date`,`lesson` FROM `orders_view`";
}
function SqlGroupWhere() { // Where
return "";
}
function SqlGroupGroupBy() { // Group By
return "";
}
function SqlGroupHaving() { // Having
return "";
}
function SqlGroupOrderBy() { // Order By
return "`request_date` ASC,`lesson` ASC";
}
// Report detail level SQL
function SqlDetailSelect() { // Select
return "SELECT * FROM `orders_view`";
}
function SqlDetailWhere() { // Where
return "";
}
function SqlDetailGroupBy() { // Group By
return "";
}
function SqlDetailHaving() { // Having
return "";
}
function SqlDetailOrderBy() { // Order By
return "`request_date` ASC";
}
// Check if Anonymous User is allowed
function AllowAnonymousUser() {
switch (EW_PAGE_ID) {
case "add":
case "register":
case "addopt":
return FALSE;
case "edit":
case "update":
return FALSE;
case "delete":
return FALSE;
case "view":
return TRUE;
case "search":
return TRUE;
default:
return TRUE;
}
}
// Apply User ID filters
function ApplyUserIDFilters($sFilter) {
return $sFilter;
}
// Report group SQL
function GroupSQL() {
$sFilter = $this->CurrentFilter;
$sFilter = $this->ApplyUserIDFilters($sFilter);
$sSort = "";
return ew_BuildSelectSql($this->SqlGroupSelect(), $this->SqlGroupWhere(),
$this->SqlGroupGroupBy(), $this->SqlGroupHaving(),
$this->SqlGroupOrderBy(), $sFilter, $sSort);
}
// Report detail SQL
function DetailSQL() {
$sFilter = $this->CurrentFilter;
$sFilter = $this->ApplyUserIDFilters($sFilter);
$sSort = "";
return ew_BuildSelectSql($this->SqlDetailSelect(), $this->SqlDetailWhere(),
$this->SqlDetailGroupBy(), $this->SqlDetailHaving(),
$this->SqlDetailOrderBy(), $sFilter, $sSort);
}
// Return page URL
function getReturnUrl() {
$name = EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_RETURN_URL;
// Get referer URL automatically
if (ew_ServerVar("HTTP_REFERER") <> "" && ew_ReferPage() <> ew_CurrentPage() && ew_ReferPage() <> "login.php") // Referer not same page or login page
$_SESSION[$name] = ew_ServerVar("HTTP_REFERER"); // Save to Session
if (@$_SESSION[$name] <> "") {
return $_SESSION[$name];
} else {
return "orders_date_lessonreport.php";
}
}
function setReturnUrl($v) {
$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_RETURN_URL] = $v;
}
// List URL
function ListUrl() {
return "orders_date_lessonreport.php";
}
// View URL
function ViewUrl() {
return $this->KeyUrl("", $this->UrlParm());
}
// Add URL
function AddUrl() {
$AddUrl = "";
$sUrlParm = $this->UrlParm();
if ($sUrlParm <> "")
$AddUrl .= "?" . $sUrlParm;
return $AddUrl;
}
// Edit URL
function EditUrl() {
return $this->KeyUrl("", $this->UrlParm());
}
// Inline edit URL
function InlineEditUrl() {
return $this->KeyUrl(ew_CurrentPage(), $this->UrlParm("a=edit"));
}
// Copy URL
function CopyUrl() {
return $this->KeyUrl("", $this->UrlParm());
}
// Inline copy URL
function InlineCopyUrl() {
return $this->KeyUrl(ew_CurrentPage(), $this->UrlParm("a=copy"));
}
// Delete URL
function DeleteUrl() {
return $this->KeyUrl("", $this->UrlParm());
}
// Add key value to URL
function KeyUrl($url, $parm = "") {
$sUrl = $url . "?";
if ($parm <> "") $sUrl .= $parm . "&";
return $sUrl;
}
// Sort URL
function SortUrl(&$fld) {
if ($this->CurrentAction <> "" || $this->Export <> "" ||
in_array($fld->FldType, array(128, 204, 205))) { // Unsortable data type
return "";
} elseif ($fld->Sortable) {
$sUrlParm = $this->UrlParm("order=" . urlencode($fld->FldName) . "&ordertype=" . $fld->ReverseSort());
return ew_CurrentPage() . "?" . $sUrlParm;
} else {
return "";
}
}
// Add URL parameter
function UrlParm($parm = "") {
$UrlParm = ($this->UseTokenInUrl) ? "t=orders_date_lesson" : "";
if ($parm <> "") {
if ($UrlParm <> "")
$UrlParm .= "&";
$UrlParm .= $parm;
}
return $UrlParm;
}
// Load rows based on filter
function &LoadRs($sFilter) {
global $conn;
// Set up filter (SQL WHERE clause) and get return SQL
$this->CurrentFilter = $sFilter;
$sSql = $this->SQL();
return $conn->Execute($sSql);
}
// Load row values from recordset
function LoadListRowValues(&$rs) {
$this->id->setDbValue($rs->fields('id'));
$this->room->setDbValue($rs->fields('room'));
$this->order_date->setDbValue($rs->fields('order_date'));
$this->request_date->setDbValue($rs->fields('request_date'));
$this->return_date->setDbValue($rs->fields('return_date'));
$this->lesson->setDbValue($rs->fields('lesson'));
$this->starts->setDbValue($rs->fields('starts'));
$this->ends->setDbValue($rs->fields('ends'));
$this->teacher->setDbValue($rs->fields('teacher'));
$this->note->setDbValue($rs->fields('note'));
}
// Render list row values
function RenderListRow() {
global $conn, $Security;
// Common render codes
// id
$orders_date_lesson->id->CellCssStyle = ""; $orders_date_lesson->id->CellCssClass = "";
$orders_date_lesson->id->CellAttrs = array(); $orders_date_lesson->id->ViewAttrs = array(); $orders_date_lesson->id->EditAttrs = array();
// room
$orders_date_lesson->room->CellCssStyle = ""; $orders_date_lesson->room->CellCssClass = "";
$orders_date_lesson->room->CellAttrs = array(); $orders_date_lesson->room->ViewAttrs = array(); $orders_date_lesson->room->EditAttrs = array();
// order_date
$orders_date_lesson->order_date->CellCssStyle = ""; $orders_date_lesson->order_date->CellCssClass = "";
$orders_date_lesson->order_date->CellAttrs = array(); $orders_date_lesson->order_date->ViewAttrs = array(); $orders_date_lesson->order_date->EditAttrs = array();
// request_date
$orders_date_lesson->request_date->CellCssStyle = ""; $orders_date_lesson->request_date->CellCssClass = "";
$orders_date_lesson->request_date->CellAttrs = array(); $orders_date_lesson->request_date->ViewAttrs = array(); $orders_date_lesson->request_date->EditAttrs = array();
// return_date
$orders_date_lesson->return_date->CellCssStyle = ""; $orders_date_lesson->return_date->CellCssClass = "";
$orders_date_lesson->return_date->CellAttrs = array(); $orders_date_lesson->return_date->ViewAttrs = array(); $orders_date_lesson->return_date->EditAttrs = array();
// lesson
$orders_date_lesson->lesson->CellCssStyle = ""; $orders_date_lesson->lesson->CellCssClass = "";
$orders_date_lesson->lesson->CellAttrs = array(); $orders_date_lesson->lesson->ViewAttrs = array(); $orders_date_lesson->lesson->EditAttrs = array();
// starts
$orders_date_lesson->starts->CellCssStyle = ""; $orders_date_lesson->starts->CellCssClass = "";
$orders_date_lesson->starts->CellAttrs = array(); $orders_date_lesson->starts->ViewAttrs = array(); $orders_date_lesson->starts->EditAttrs = array();
// ends
$orders_date_lesson->ends->CellCssStyle = ""; $orders_date_lesson->ends->CellCssClass = "";
$orders_date_lesson->ends->CellAttrs = array(); $orders_date_lesson->ends->ViewAttrs = array(); $orders_date_lesson->ends->EditAttrs = array();
// teacher
$orders_date_lesson->teacher->CellCssStyle = ""; $orders_date_lesson->teacher->CellCssClass = "";
$orders_date_lesson->teacher->CellAttrs = array(); $orders_date_lesson->teacher->ViewAttrs = array(); $orders_date_lesson->teacher->EditAttrs = array();
// note
$orders_date_lesson->note->CellCssStyle = ""; $orders_date_lesson->note->CellCssClass = "";
$orders_date_lesson->note->CellAttrs = array(); $orders_date_lesson->note->ViewAttrs = array(); $orders_date_lesson->note->EditAttrs = array();
// id
$orders_date_lesson->id->ViewValue = $orders_date_lesson->id->CurrentValue;
$orders_date_lesson->id->CssStyle = "";
$orders_date_lesson->id->CssClass = "";
$orders_date_lesson->id->ViewCustomAttributes = "";
// room
$orders_date_lesson->room->ViewValue = $orders_date_lesson->room->CurrentValue;
$orders_date_lesson->room->CssStyle = "";
$orders_date_lesson->room->CssClass = "";
$orders_date_lesson->room->ViewCustomAttributes = "";
// order_date
$orders_date_lesson->order_date->ViewValue = $orders_date_lesson->order_date->CurrentValue;
$orders_date_lesson->order_date->ViewValue = ew_FormatDateTime($orders_date_lesson->order_date->ViewValue, 5);
$orders_date_lesson->order_date->CssStyle = "";
$orders_date_lesson->order_date->CssClass = "";
$orders_date_lesson->order_date->ViewCustomAttributes = "";
// request_date
$orders_date_lesson->request_date->ViewValue = $orders_date_lesson->request_date->CurrentValue;
$orders_date_lesson->request_date->ViewValue = ew_FormatDateTime($orders_date_lesson->request_date->ViewValue, 5);
$orders_date_lesson->request_date->CssStyle = "";
$orders_date_lesson->request_date->CssClass = "";
$orders_date_lesson->request_date->ViewCustomAttributes = "";
// return_date
$orders_date_lesson->return_date->ViewValue = $orders_date_lesson->return_date->CurrentValue;
$orders_date_lesson->return_date->ViewValue = ew_FormatDateTime($orders_date_lesson->return_date->ViewValue, 5);
$orders_date_lesson->return_date->CssStyle = "";
$orders_date_lesson->return_date->CssClass = "";
$orders_date_lesson->return_date->ViewCustomAttributes = "";
// lesson
$orders_date_lesson->lesson->ViewValue = $orders_date_lesson->lesson->CurrentValue;
$orders_date_lesson->lesson->CssStyle = "";
$orders_date_lesson->lesson->CssClass = "";
$orders_date_lesson->lesson->ViewCustomAttributes = "";
// starts
$orders_date_lesson->starts->ViewValue = $orders_date_lesson->starts->CurrentValue;
$orders_date_lesson->starts->ViewValue = ew_FormatDateTime($orders_date_lesson->starts->ViewValue, 4);
$orders_date_lesson->starts->CssStyle = "";
$orders_date_lesson->starts->CssClass = "";
$orders_date_lesson->starts->ViewCustomAttributes = "";
// ends
$orders_date_lesson->ends->ViewValue = $orders_date_lesson->ends->CurrentValue;
$orders_date_lesson->ends->ViewValue = ew_FormatDateTime($orders_date_lesson->ends->ViewValue, 4);
$orders_date_lesson->ends->CssStyle = "";
$orders_date_lesson->ends->CssClass = "";
$orders_date_lesson->ends->ViewCustomAttributes = "";
// teacher
$orders_date_lesson->teacher->ViewValue = $orders_date_lesson->teacher->CurrentValue;
$orders_date_lesson->teacher->CssStyle = "";
$orders_date_lesson->teacher->CssClass = "";
$orders_date_lesson->teacher->ViewCustomAttributes = "";
// note
$orders_date_lesson->note->ViewValue = $orders_date_lesson->note->CurrentValue;
$orders_date_lesson->note->CssStyle = "";
$orders_date_lesson->note->CssClass = "";
$orders_date_lesson->note->ViewCustomAttributes = "";
// id
$orders_date_lesson->id->HrefValue = "";
$orders_date_lesson->id->TooltipValue = "";
// room
$orders_date_lesson->room->HrefValue = "";
$orders_date_lesson->room->TooltipValue = "";
// order_date
$orders_date_lesson->order_date->HrefValue = "";
$orders_date_lesson->order_date->TooltipValue = "";
// request_date
$orders_date_lesson->request_date->HrefValue = "";
$orders_date_lesson->request_date->TooltipValue = "";
// return_date
$orders_date_lesson->return_date->HrefValue = "";
$orders_date_lesson->return_date->TooltipValue = "";
// lesson
$orders_date_lesson->lesson->HrefValue = "";
$orders_date_lesson->lesson->TooltipValue = $orders_date_lesson->note->CurrentValue;
// starts
$orders_date_lesson->starts->HrefValue = "";
$orders_date_lesson->starts->TooltipValue = "";
// ends
$orders_date_lesson->ends->HrefValue = "";
$orders_date_lesson->ends->TooltipValue = "";
// teacher
$orders_date_lesson->teacher->HrefValue = "";
$orders_date_lesson->teacher->TooltipValue = "";
// note
$orders_date_lesson->note->HrefValue = "";
$orders_date_lesson->note->TooltipValue = "";
}
// Aggregate list row values
function AggregateListRowValues() {
}
// Aggregate list row (for rendering)
function AggregateListRow() {
}
// Row styles
function RowStyles() {
$sAtt = "";
$sStyle = trim($this->CssStyle);
if (@$this->RowAttrs["style"] <> "")
$sStyle .= " " . $this->RowAttrs["style"];
$sClass = trim($this->CssClass);
if (@$this->RowAttrs["class"] <> "")
$sClass .= " " . $this->RowAttrs["class"];
if (trim($sStyle) <> "")
$sAtt .= " style=\"" . trim($sStyle) . "\"";
if (trim($sClass) <> "")
$sAtt .= " class=\"" . trim($sClass) . "\"";
return $sAtt;
}
// Row attributes
function RowAttributes() {
$sAtt = $this->RowStyles();
if ($this->Export == "") {
foreach ($this->RowAttrs as $k => $v) {
if ($k <> "class" && $k <> "style" && trim($v) <> "")
$sAtt .= " " . $k . "=\"" . trim($v) . "\"";
}
}
return $sAtt;
}
// Field object by name
function fields($fldname) {
return $this->fields[$fldname];
}
}
?>
<?php include "useraccountsinfo.php" ?>
<?php include "userfn7.php" ?>
<?php
// Create page object
$orders_date_lesson_report = new corders_date_lesson_report();
$Page =& $orders_date_lesson_report;
// Page init
$orders_date_lesson_report->Page_Init();
// Page main
$orders_date_lesson_report->Page_Main();
?>
<?php include "header.php" ?>
<?php if ($orders_date_lesson->Export == "") { ?>
<script language="JavaScript" type="text/javascript">
<!--
// Write your client script here, no need to add script tags.
// To include another .js script, use:
// ew_ClientScriptInclude("my_javascript.js");
//-->
</script>
<?php } ?>
<?php if ($orders_date_lesson->Export == "") { ?>
<?php } ?>
<p><span class="phpmaker"><?php echo $Language->Phrase("TblTypeReport") ?><?php echo $orders_date_lesson->TableCaption() ?>
<?php if ($orders_date_lesson->Export == "") { ?>
<a href="<?php echo $orders_date_lesson_report->ExportPrintUrl ?>"><?php echo $Language->Phrase("PrinterFriendly") ?></a>
<a href="<?php echo $orders_date_lesson_report->ExportExcelUrl ?>"><?php echo $Language->Phrase("ExportToExcel") ?></a>
<a href="<?php echo $orders_date_lesson_report->ExportWordUrl ?>"><?php echo $Language->Phrase("ExportToWord") ?></a>
<?php } ?>
</span></p>
<form method="post">
<table class="ewReportTable" cellspacing="-1">
<?php
$orders_date_lesson_report->sTblDefaultFilter = "";
$orders_date_lesson_report->sFilter = $orders_date_lesson_report->sTblDefaultFilter;
if ($orders_date_lesson_report->sDbDetailFilter <> "") {
if ($orders_date_lesson_report->sFilter <> "") $orders_date_lesson_report->sFilter .= " AND ";
$orders_date_lesson_report->sFilter .= "(" . $orders_date_lesson_report->sDbDetailFilter . ")";
}
// Set up filter and load Group level sql
$orders_date_lesson->CurrentFilter = $orders_date_lesson_report->sFilter;
$orders_date_lesson_report->sSql = $orders_date_lesson->GroupSQL();
// Load recordset
$rs = $conn->Execute($orders_date_lesson_report->sSql);
// Get First Row
if (!$rs->EOF) {
$orders_date_lesson->request_date->setDbValue($rs->fields('request_date'));
$orders_date_lesson_report->vGrps[0] = $orders_date_lesson->request_date->DbValue;
$orders_date_lesson->lesson->setDbValue($rs->fields('lesson'));
$orders_date_lesson_report->vGrps[1] = $orders_date_lesson->lesson->DbValue;
}
$orders_date_lesson_report->lRecCnt = 0;
$orders_date_lesson_report->nCntRecs[0] = 0;
$orders_date_lesson_report->ChkLvlBreak();
while (!$rs->EOF) {
// Render for view
$orders_date_lesson->RowType = EW_ROWTYPE_VIEW;
$orders_date_lesson_report->RenderRow();
// Show group headers
if ($orders_date_lesson_report->bLvlBreak[1]) { // Reset counter and aggregation
?>
<tr><td class="ewGroupField"><span class="phpmaker"><?php echo $orders_date_lesson->request_date->FldCaption() ?></span></td>
<td colspan=7 class="ewGroupName"><span class="phpmaker">
<div<?php echo $orders_date_lesson->request_date->ViewAttributes() ?>><?php echo $orders_date_lesson->request_date->ViewValue ?></div></span></td></tr>
<?php
}
if ($orders_date_lesson_report->bLvlBreak[2]) { // Reset counter and aggregation
?>
<tr><td class="ewGroupField"><span class="phpmaker"><?php echo $orders_date_lesson->lesson->FldCaption() ?></span></td>
<td colspan=7 class="ewGroupName"><span class="phpmaker">
<div<?php echo $orders_date_lesson->lesson->ViewAttributes() ?>>
<?php if ($orders_date_lesson->lesson->HrefValue <> "" || $orders_date_lesson->lesson->TooltipValue <> "" || $orders_date_lesson->note->ViewValue <> "") { ?>
<a href="javascript:void(0);" onmouseover="ew_ShowTooltip(this, 'tt_orders_date_lesson_x_lesson');" onmouseout="ew_HideTooltip();"><?php echo $orders_date_lesson->lesson->ViewValue ?></a>
<?php } else { ?>
<?php echo $orders_date_lesson->lesson->ViewValue ?>
<?php } ?>
</div><div id="tt_orders_date_lesson_x_lesson" style="display: none">
<?php if ($orders_date_lesson->lesson->TooltipValue <> "") { ?>
<?php echo $orders_date_lesson->lesson->TooltipValue ?>
<?php } else { ?>
<div<?php echo $orders_date_lesson->note->ViewAttributes() ?>><?php echo $orders_date_lesson->note->ViewValue ?></div>
<?php } ?>
</div></span></td></tr>
<?php
}
// Get detail records
$orders_date_lesson_report->sFilter = $orders_date_lesson_report->sTblDefaultFilter;
if ($orders_date_lesson_report->sFilter <> "") $orders_date_lesson_report->sFilter .= " AND ";
if (is_null(ew_UnFormatDateTime(ew_FormatDateTime($orders_date_lesson->request_date->CurrentValue,5),5))) {
$orders_date_lesson_report->sFilter .= "(`request_date` IS NULL)";
} else {
$orders_date_lesson_report->sFilter .= "(`request_date` = '" . ew_AdjustSql(ew_UnFormatDateTime(ew_FormatDateTime($orders_date_lesson->request_date->CurrentValue,5),5)) . "')";
}
if ($orders_date_lesson_report->sFilter <> "") $orders_date_lesson_report->sFilter .= " AND ";
if (is_null($orders_date_lesson->lesson->CurrentValue)) {
$orders_date_lesson_report->sFilter .= "(`lesson` IS NULL)";
} else {
$orders_date_lesson_report->sFilter .= "(`lesson` = '" . ew_AdjustSql($orders_date_lesson->lesson->CurrentValue) . "')";
}
if ($orders_date_lesson_report->sDbDetailFilter <> "") {
if ($orders_date_lesson_report->sFilter <> "")
$orders_date_lesson_report->sFilter .= " AND ";
$orders_date_lesson_report->sFilter .= "(" . $orders_date_lesson_report->sDbDetailFilter . ")";
}
// Set up detail SQL
$orders_date_lesson->CurrentFilter = $orders_date_lesson_report->sFilter;
$orders_date_lesson_report->sSql = $orders_date_lesson->DetailSQL();
// Load detail records
$rsdtl = $conn->Execute($orders_date_lesson_report->sSql);
$orders_date_lesson_report->nDtlRecs = $rsdtl->RecordCount();
// Initialize aggregates
if (!$rsdtl->EOF) {
$orders_date_lesson_report->lRecCnt++;
}
if ($orders_date_lesson_report->lRecCnt == 1) {
$orders_date_lesson_report->nCntRecs[0] = 0;
}
for ($i = 1; $i <= 2; $i++) {
if ($orders_date_lesson_report->bLvlBreak[$i]) { // Reset counter and aggregation
$orders_date_lesson_report->nCntRecs[$i] = 0;
}
}
$orders_date_lesson_report->nCntRecs[0] += $orders_date_lesson_report->nDtlRecs;
$orders_date_lesson_report->nCntRecs[1] += $orders_date_lesson_report->nDtlRecs;
$orders_date_lesson_report->nCntRecs[2] += $orders_date_lesson_report->nDtlRecs;
?>
<tr>
<td valign="top" class="ewGroupHeader"><span class="phpmaker"><?php echo $orders_date_lesson->id->FldCaption() ?></span></td>
<td valign="top" class="ewGroupHeader"><span class="phpmaker"><?php echo $orders_date_lesson->room->FldCaption() ?></span></td>
<td valign="top" class="ewGroupHeader"><span class="phpmaker"><?php echo $orders_date_lesson->order_date->FldCaption() ?></span></td>
<td valign="top" class="ewGroupHeader"><span class="phpmaker"><?php echo $orders_date_lesson->return_date->FldCaption() ?></span></td>
<td valign="top" class="ewGroupHeader"><span class="phpmaker"><?php echo $orders_date_lesson->starts->FldCaption() ?></span></td>
<td valign="top" class="ewGroupHeader"><span class="phpmaker"><?php echo $orders_date_lesson->ends->FldCaption() ?></span></td>
<td valign="top" class="ewGroupHeader"><span class="phpmaker"><?php echo $orders_date_lesson->teacher->FldCaption() ?></span></td>
<td valign="top" class="ewGroupHeader"><span class="phpmaker"><?php echo $orders_date_lesson->note->FldCaption() ?></span></td>
</tr>
<?php
while (!$rsdtl->EOF) {
$orders_date_lesson->id->setDbValue($rsdtl->fields('id'));
$orders_date_lesson->room->setDbValue($rsdtl->fields('room'));
$orders_date_lesson->order_date->setDbValue($rsdtl->fields('order_date'));
$orders_date_lesson->return_date->setDbValue($rsdtl->fields('return_date'));
$orders_date_lesson->starts->setDbValue($rsdtl->fields('starts'));
$orders_date_lesson->ends->setDbValue($rsdtl->fields('ends'));
$orders_date_lesson->teacher->setDbValue($rsdtl->fields('teacher'));
$orders_date_lesson->note->setDbValue($rsdtl->fields('note'));
// Render for view
$orders_date_lesson->RowType = EW_ROWTYPE_VIEW;
$orders_date_lesson_report->RenderRow();
?>
<tr>
<td><span class="phpmaker">
<div<?php echo $orders_date_lesson->id->ViewAttributes() ?>><?php echo $orders_date_lesson->id->ViewValue ?></div></span></td>
<td><span class="phpmaker">
<div<?php echo $orders_date_lesson->room->ViewAttributes() ?>><?php echo $orders_date_lesson->room->ViewValue ?></div></span></td>
<td><span class="phpmaker">
<div<?php echo $orders_date_lesson->order_date->ViewAttributes() ?>><?php echo $orders_date_lesson->order_date->ViewValue ?></div></span></td>
<td><span class="phpmaker">
<div<?php echo $orders_date_lesson->return_date->ViewAttributes() ?>><?php echo $orders_date_lesson->return_date->ViewValue ?></div></span></td>
<td><span class="phpmaker">
<div<?php echo $orders_date_lesson->starts->ViewAttributes() ?>><?php echo $orders_date_lesson->starts->ViewValue ?></div></span></td>
<td><span class="phpmaker">
<div<?php echo $orders_date_lesson->ends->ViewAttributes() ?>><?php echo $orders_date_lesson->ends->ViewValue ?></div></span></td>
<td><span class="phpmaker">
<div<?php echo $orders_date_lesson->teacher->ViewAttributes() ?>><?php echo $orders_date_lesson->teacher->ViewValue ?></div></span></td>
<td><span class="phpmaker">
<div<?php echo $orders_date_lesson->note->ViewAttributes() ?>><?php echo $orders_date_lesson->note->ViewValue ?></div></span></td>
</tr>
<?php
$rsdtl->MoveNext();
}
$rsdtl->Close();
// Save old group data
$orders_date_lesson_report->vGrps[0] = $orders_date_lesson->request_date->CurrentValue;
$orders_date_lesson_report->vGrps[1] = $orders_date_lesson->lesson->CurrentValue;
// Get next record
$rs->MoveNext();
if ($rs->EOF) {
$orders_date_lesson_report->lRecCnt = 0; // EOF, force all level breaks
} else {
$orders_date_lesson->request_date->setDbValue($rs->fields('request_date'));
$orders_date_lesson->lesson->setDbValue($rs->fields('lesson'));
}
$orders_date_lesson_report->ChkLvlBreak();
// Show footers
if ($orders_date_lesson_report->bLvlBreak[2]) {
$orders_date_lesson->lesson->CurrentValue = $orders_date_lesson_report->vGrps[1];
// Render row for view
$orders_date_lesson->RowType = EW_ROWTYPE_VIEW;
$orders_date_lesson_report->RenderRow();
$orders_date_lesson->lesson->CurrentValue = $orders_date_lesson->lesson->DbValue;
?>
<?php
}
if ($orders_date_lesson_report->bLvlBreak[1]) {
$orders_date_lesson->request_date->CurrentValue = $orders_date_lesson_report->vGrps[0];
// Render row for view
$orders_date_lesson->RowType = EW_ROWTYPE_VIEW;
$orders_date_lesson_report->RenderRow();
$orders_date_lesson->request_date->CurrentValue = $orders_date_lesson->request_date->DbValue;
?>
<?php
}
}
// Close recordset
$rs->Close();
?>
<tr><td colspan=8><span class="phpmaker"> <br></span></td></tr>
<tr><td colspan=8 class="ewGrandSummary"><span class="phpmaker"><?php echo $Language->Phrase("RptGrandTotal") ?> (<?php echo ew_FormatNumber($orders_date_lesson_report->nCntRecs[0], 0) ?> <?php echo $Language->Phrase("RptDtlRec") ?>)</span></td></tr>
<tr><td colspan=8><span class="phpmaker"> <br></span></td></tr>
</table>
</form>
<?php if ($orders_date_lesson->Export == "") { ?>
<script language="JavaScript" type="text/javascript">
<!--
// Write your table-specific startup script here
// document.write("page loaded");
//-->
</script>
<?php } ?>
<?php include "footer.php" ?>
<?php
$orders_date_lesson_report->Page_Terminate();
?>
<?php
//
// Page class
//
class corders_date_lesson_report {
// Page ID
var $PageID = 'report';
// Table name
var $TableName = 'orders_date_lesson';
// Page object name
var $PageObjName = 'orders_date_lesson_report';
// Page name
function PageName() {
return ew_CurrentPage();
}
// Page URL
function PageUrl() {
$PageUrl = ew_CurrentPage() . "?";
return $PageUrl;
}
// Page URLs
var $AddUrl;
var $EditUrl;
var $CopyUrl;
var $DeleteUrl;
var $ViewUrl;
var $ListUrl;
// Export URLs
var $ExportPrintUrl;
var $ExportHtmlUrl;
var $ExportExcelUrl;
var $ExportWordUrl;
var $ExportXmlUrl;
var $ExportCsvUrl;
// Update URLs
var $InlineAddUrl;
var $InlineCopyUrl;
var $InlineEditUrl;
var $GridAddUrl;
var $GridEditUrl;
var $MultiDeleteUrl;
var $MultiUpdateUrl;
// Message
function getMessage() {
return @$_SESSION[EW_SESSION_MESSAGE];
}
function setMessage($v) {
if (@$_SESSION[EW_SESSION_MESSAGE] <> "") { // Append
$_SESSION[EW_SESSION_MESSAGE] .= "<br>" . $v;
} else {
$_SESSION[EW_SESSION_MESSAGE] = $v;
}
}
// Show message
function ShowMessage() {
$sMessage = $this->getMessage();
$this->Message_Showing($sMessage);
if ($sMessage <> "") { // Message in Session, display
echo "<p><span class=\"ewMessage\">" . $sMessage . "</span></p>";
$_SESSION[EW_SESSION_MESSAGE] = ""; // Clear message in Session
}
}
// Validate page request
function IsPageRequest() {
return TRUE;
}
//
// Page class constructor
//
function corders_date_lesson_report() {
global $conn, $Language;
// Language object
$Language = new cLanguage();
// Table object (orders_date_lesson)
$GLOBALS["orders_date_lesson"] = new corders_date_lesson();
// Initialize URLs
$this->ExportPrintUrl = $this->PageUrl() . "export=print";
$this->ExportExcelUrl = $this->PageUrl() . "export=excel";
$this->ExportWordUrl = $this->PageUrl() . "export=word";
// Table object (useraccounts)
$GLOBALS['useraccounts'] = new cuseraccounts();
// Page ID
if (!defined("EW_PAGE_ID"))
define("EW_PAGE_ID", 'report', TRUE);
// Table name (for backward compatibility)
if (!defined("EW_TABLE_NAME"))
define("EW_TABLE_NAME", 'orders_date_lesson', TRUE);
// Start timer
$GLOBALS["gsTimer"] = new cTimer();
// Open connection
$conn = ew_Connect();
}
//
// Page_Init
//
function Page_Init() {
global $gsExport, $gsExportFile, $UserProfile, $Language, $Security, $objForm;
global $orders_date_lesson;
// Security
$Security = new cAdvancedSecurity();
if (!$Security->IsLoggedIn()) $Security->AutoLogin();
$Security->TablePermission_Loading();
$Security->LoadCurrentUserLevel($this->TableName);
$Security->TablePermission_Loaded();
$Security->UserID_Loading();
if ($Security->IsLoggedIn()) $Security->LoadUserID();
$Security->UserID_Loaded();
// Get export parameters
if (@$_GET["export"] <> "") {
$orders_date_lesson->Export = $_GET["export"];
}
$gsExport = $orders_date_lesson->Export; // Get export parameter, used in header
$gsExportFile = $orders_date_lesson->TableVar; // Get export file, used in header
if ($orders_date_lesson->Export == "excel") {
header('Content-Type: application/vnd.ms-excel;charset=utf-8');
header('Content-Disposition: attachment; filename=' . $gsExportFile .'.xls');
}
if ($orders_date_lesson->Export == "word") {
header('Content-Type: application/vnd.ms-word;charset=utf-8');
header('Content-Disposition: attachment; filename=' . $gsExportFile .'.doc');
}
// Global Page Loading event (in userfn*.php)
Page_Loading();
// Page Load event
$this->Page_Load();
}
//
// Page_Terminate
//
function Page_Terminate($url = "") {
global $conn;
// Page Unload event
$this->Page_Unload();
// Global Page Unloaded event (in userfn*.php)
Page_Unloaded();
// Close connection
$conn->Close();
// Go to URL if specified
$this->Page_Redirecting($url);
if ($url <> "") {
if (!EW_DEBUG_ENABLED && ob_get_length())
ob_end_clean();
header("Location: " . $url);
}
exit();
}
var $lRecCnt = 0;
var $sSql = "";
var $sFilter = "";
var $sTblDefaultFilter = "";
var $sDbMasterFilter = "";
var $sDbDetailFilter = "";
var $bMasterRecordExists;
var $sCmd = "";
var $lDtlRecs;
var $vGrps;
var $nCntRecs;
var $bLvlBreak;
var $nTotals;
var $nMaxs;
var $nMins;
//
// Page main
//
function Page_Main() {
global $Language, $orders_date_lesson;
$this->vGrps =& ew_InitArray(3, NULL);
$this->nCntRecs =& ew_InitArray(3, 0);
$this->bLvlBreak =& ew_InitArray(3, FALSE);
$this->nTotals =& ew_Init2DArray(3, 9, 0);
$this->nMaxs =& ew_Init2DArray(3, 9, 0);
$this->nMins =& ew_Init2DArray(3, 9, 0);
}
// Check level break
function ChkLvlBreak() {
global $orders_date_lesson;
$this->bLvlBreak[1] = FALSE;
$this->bLvlBreak[2] = FALSE;
if ($this->lRecCnt == 0) { // Start Or End of Recordset
$this->bLvlBreak[1] = TRUE;
$this->bLvlBreak[2] = TRUE;
} else {
if (!ew_CompareValue($orders_date_lesson->request_date->CurrentValue, $this->vGrps[0])) {
$this->bLvlBreak[1] = TRUE;
$this->bLvlBreak[2] = TRUE;
}
if (!ew_CompareValue($orders_date_lesson->lesson->CurrentValue, $this->vGrps[1])) {
$this->bLvlBreak[2] = TRUE;
}
}
}
// Render row values based on field settings
function RenderRow() {
global $conn, $Security, $Language, $orders_date_lesson;
// Initialize URLs
// Common render codes for all row types
// id
$orders_date_lesson->id->CellCssStyle = ""; $orders_date_lesson->id->CellCssClass = "";
$orders_date_lesson->id->CellAttrs = array(); $orders_date_lesson->id->ViewAttrs = array(); $orders_date_lesson->id->EditAttrs = array();
// room
$orders_date_lesson->room->CellCssStyle = ""; $orders_date_lesson->room->CellCssClass = "";
$orders_date_lesson->room->CellAttrs = array(); $orders_date_lesson->room->ViewAttrs = array(); $orders_date_lesson->room->EditAttrs = array();
// order_date
$orders_date_lesson->order_date->CellCssStyle = ""; $orders_date_lesson->order_date->CellCssClass = "";
$orders_date_lesson->order_date->CellAttrs = array(); $orders_date_lesson->order_date->ViewAttrs = array(); $orders_date_lesson->order_date->EditAttrs = array();
// request_date
$orders_date_lesson->request_date->CellCssStyle = ""; $orders_date_lesson->request_date->CellCssClass = "";
$orders_date_lesson->request_date->CellAttrs = array(); $orders_date_lesson->request_date->ViewAttrs = array(); $orders_date_lesson->request_date->EditAttrs = array();
// return_date
$orders_date_lesson->return_date->CellCssStyle = ""; $orders_date_lesson->return_date->CellCssClass = "";
$orders_date_lesson->return_date->CellAttrs = array(); $orders_date_lesson->return_date->ViewAttrs = array(); $orders_date_lesson->return_date->EditAttrs = array();
// lesson
$orders_date_lesson->lesson->CellCssStyle = ""; $orders_date_lesson->lesson->CellCssClass = "";
$orders_date_lesson->lesson->CellAttrs = array(); $orders_date_lesson->lesson->ViewAttrs = array(); $orders_date_lesson->lesson->EditAttrs = array();
// starts
$orders_date_lesson->starts->CellCssStyle = ""; $orders_date_lesson->starts->CellCssClass = "";
$orders_date_lesson->starts->CellAttrs = array(); $orders_date_lesson->starts->ViewAttrs = array(); $orders_date_lesson->starts->EditAttrs = array();
// ends
$orders_date_lesson->ends->CellCssStyle = ""; $orders_date_lesson->ends->CellCssClass = "";
$orders_date_lesson->ends->CellAttrs = array(); $orders_date_lesson->ends->ViewAttrs = array(); $orders_date_lesson->ends->EditAttrs = array();
// teacher
$orders_date_lesson->teacher->CellCssStyle = ""; $orders_date_lesson->teacher->CellCssClass = "";
$orders_date_lesson->teacher->CellAttrs = array(); $orders_date_lesson->teacher->ViewAttrs = array(); $orders_date_lesson->teacher->EditAttrs = array();
// note
$orders_date_lesson->note->CellCssStyle = ""; $orders_date_lesson->note->CellCssClass = "";
$orders_date_lesson->note->CellAttrs = array(); $orders_date_lesson->note->ViewAttrs = array(); $orders_date_lesson->note->EditAttrs = array();
if ($orders_date_lesson->RowType == EW_ROWTYPE_VIEW) { // View row
// id
$orders_date_lesson->id->ViewValue = $orders_date_lesson->id->CurrentValue;
$orders_date_lesson->id->CssStyle = "";
$orders_date_lesson->id->CssClass = "";
$orders_date_lesson->id->ViewCustomAttributes = "";
// room
$orders_date_lesson->room->ViewValue = $orders_date_lesson->room->CurrentValue;
$orders_date_lesson->room->CssStyle = "";
$orders_date_lesson->room->CssClass = "";
$orders_date_lesson->room->ViewCustomAttributes = "";
// order_date
$orders_date_lesson->order_date->ViewValue = $orders_date_lesson->order_date->CurrentValue;
$orders_date_lesson->order_date->ViewValue = ew_FormatDateTime($orders_date_lesson->order_date->ViewValue, 5);
$orders_date_lesson->order_date->CssStyle = "";
$orders_date_lesson->order_date->CssClass = "";
$orders_date_lesson->order_date->ViewCustomAttributes = "";
// request_date
$orders_date_lesson->request_date->ViewValue = $orders_date_lesson->request_date->CurrentValue;
$orders_date_lesson->request_date->ViewValue = ew_FormatDateTime($orders_date_lesson->request_date->ViewValue, 5);
$orders_date_lesson->request_date->CssStyle = "";
$orders_date_lesson->request_date->CssClass = "";
$orders_date_lesson->request_date->ViewCustomAttributes = "";
// return_date
$orders_date_lesson->return_date->ViewValue = $orders_date_lesson->return_date->CurrentValue;
$orders_date_lesson->return_date->ViewValue = ew_FormatDateTime($orders_date_lesson->return_date->ViewValue, 5);
$orders_date_lesson->return_date->CssStyle = "";
$orders_date_lesson->return_date->CssClass = "";
$orders_date_lesson->return_date->ViewCustomAttributes = "";
// lesson
$orders_date_lesson->lesson->ViewValue = $orders_date_lesson->lesson->CurrentValue;
$orders_date_lesson->lesson->CssStyle = "";
$orders_date_lesson->lesson->CssClass = "";
$orders_date_lesson->lesson->ViewCustomAttributes = "";
// starts
$orders_date_lesson->starts->ViewValue = $orders_date_lesson->starts->CurrentValue;
$orders_date_lesson->starts->ViewValue = ew_FormatDateTime($orders_date_lesson->starts->ViewValue, 4);
$orders_date_lesson->starts->CssStyle = "";
$orders_date_lesson->starts->CssClass = "";
$orders_date_lesson->starts->ViewCustomAttributes = "";
// ends
$orders_date_lesson->ends->ViewValue = $orders_date_lesson->ends->CurrentValue;
$orders_date_lesson->ends->ViewValue = ew_FormatDateTime($orders_date_lesson->ends->ViewValue, 4);
$orders_date_lesson->ends->CssStyle = "";
$orders_date_lesson->ends->CssClass = "";
$orders_date_lesson->ends->ViewCustomAttributes = "";
// teacher
$orders_date_lesson->teacher->ViewValue = $orders_date_lesson->teacher->CurrentValue;
$orders_date_lesson->teacher->CssStyle = "";
$orders_date_lesson->teacher->CssClass = "";
$orders_date_lesson->teacher->ViewCustomAttributes = "";
// note
$orders_date_lesson->note->ViewValue = $orders_date_lesson->note->CurrentValue;
$orders_date_lesson->note->CssStyle = "";
$orders_date_lesson->note->CssClass = "";
$orders_date_lesson->note->ViewCustomAttributes = "";
// id
$orders_date_lesson->id->HrefValue = "";
$orders_date_lesson->id->TooltipValue = "";
// room
$orders_date_lesson->room->HrefValue = "";
$orders_date_lesson->room->TooltipValue = "";
// order_date
$orders_date_lesson->order_date->HrefValue = "";
$orders_date_lesson->order_date->TooltipValue = "";
// request_date
$orders_date_lesson->request_date->HrefValue = "";
$orders_date_lesson->request_date->TooltipValue = "";
// return_date
$orders_date_lesson->return_date->HrefValue = "";
$orders_date_lesson->return_date->TooltipValue = "";
// lesson
$orders_date_lesson->lesson->HrefValue = "";
$orders_date_lesson->lesson->TooltipValue = $orders_date_lesson->note->CurrentValue;
// starts
$orders_date_lesson->starts->HrefValue = "";
$orders_date_lesson->starts->TooltipValue = "";
// ends
$orders_date_lesson->ends->HrefValue = "";
$orders_date_lesson->ends->TooltipValue = "";
// teacher
$orders_date_lesson->teacher->HrefValue = "";
$orders_date_lesson->teacher->TooltipValue = "";
// note
$orders_date_lesson->note->HrefValue = "";
$orders_date_lesson->note->TooltipValue = "";
}
}
// Page Load event
function Page_Load() {
//echo "Page Load";
}
// Page Unload event
function Page_Unload() {
//echo "Page Unload";
}
// Page Redirecting event
function Page_Redirecting(&$url) {
// Example:
//$url = "your URL";
}
// Message Showing event
function Message_Showing(&$msg) {
// Example:
//$msg = "your new message";
}
}
?>