<?php
   include_once("_nemo.cls.php");
   include_once("_nemo.list.cls.php");
//echo session_name();
   $page = new Nemo();

//events

//page start
//print_rr($page->Pages);   

   /*if($page->Pages["usage.log.php"]->Security->blnView == 1){
      $usage = new NemoList("");
      $usage->isSortable = 0;
      $usage->ListSQL("
         SELECT sysLogin.strDateTime AS 'Date Time', sysLogin.strResult AS Result, sysLogin.strUsername AS Username, CASE WHEN strResult = 'Login successful' THEN LPAD('',LENGTH(sysLogin.strPassword),'*') ELSE sysLogin.strPassword END AS 'Password', sysUser.strUser AS 'System User', sysUser.blnActive AS Active, sysSecurityGroup.strSecurityGroup AS 'Security Group'
         FROM (sysUser LEFT JOIN sysSecurityGroup ON sysUser.refSecurityGroupID = sysSecurityGroup.SecurityGroupID) RIGHT JOIN sysLogin ON sysUser.strEmail = sysLogin.strUsername
         WHERE sysLogin.strDateTime >= '". date("Y-m-d H:i:s", strtotime("-2 days")) ."'
         GROUP BY sysLogin.strDateTime, sysLogin.strResult, sysLogin.strUsername, sysLogin.strPassword, sysUser.strUser, sysUser.blnActive, sysSecurityGroup.strSecurityGroup
         ORDER BY sysLogin.strDateTime DESC");

      $page->Content .= $usage->renderTable("Usage Log");

      //print_rr(date("Y-m-d H:i:s", strtotime("-2 days")));
   }

   $dailyDiary = new NemoList("");
   $dailyDiary->isSortable = 
   $dailyDiary->isPageable = 
   $dailyDiary->isSelectable = 0;
   $dailyDiary->ListSQL("SELECT tblCustomer.strCustomer AS Customer, vieOrder.strPONumber AS 'P/O Number', tblProduct.strCustomerReference AS 'References', CONCAT(IFNULL(SUM(intUnitsDelivered),0),' / ', intQuantity) AS 'Quantity'
               FROM tblCustomer INNER JOIN ((tblDelivery RIGHT JOIN vieOrder ON tblDelivery.refOrderID = vieOrder.OrderID) INNER JOIN tblProduct ON vieOrder.refProductID = tblProduct.ProductID) ON tblCustomer.CustomerID = vieOrder.refCustomerID
               GROUP BY tblCustomer.strCustomer, vieOrder.strPONumber, tblProduct.strCustomerReference
               ORDER BY tblCustomer.strCustomer, vieOrder.strPONumber");

   $page->Content .= $dailyDiary->renderTable("Daily Diary - ". date("j F Y"));
   $page->ToolBar->Buttons[btnExport]->blnShow = 1;

   switch ($Action)
   {
      case "Export":
         header("Content-type: application/ms-excel");
         header("Content-Disposition: attachment; filename=". str_replace(" ","",$page->Entity->Name) ."_".date("YmdHis").".xls");
         echo $dailyDiary->renderTable("Daily Diary");
         die;
         break;
   }
*/

   //$list->ListDATA();
   $page->Content = $SystemSettings["Home Screen Message"];
   $page->Display();
//print_rr($page);

?>