root/Interactive_Map/trunk/Interactive_Map/htdocs/nccoos.phtml

<?php
/*
 * this is a sample of a minimal application script required to
 * get a chameleon application running with a template and a
 * local map file.  Most applications should actually just
 * copy this file and modify the template and mapfile
 * parts and should not need to do a lot more here.
 */
include( "/usr/local/chameleon-2.2.1/htdocs/chameleon.php" );


$szTemplate = "./nccoos.html";
$szMapFile = "../maps/nccoos.map";

class SampleApp extends Chameleon
{
  function SampleApp()
  {
    parent::Chameleon();
    $this->moMapSession = new MapSession_RW;
    $this->moMapSession->setTempDir( getSessionSavePath());
  }
  
  function CWCProcessURL(&$oHTTPFormVars)
  {
     $bRes =  parent::CWCProcessURL($oHTTPFormVars);
     
     if(empty($_REQUEST['OFFSET']))     
     { 
          $oMap = $this->moMapSession->oMap;         
          $label_layer = $oMap->getLayerByName('request_timestamp');                                                
          $class = $label_layer->getClass(0);                        
                                                                 
          //Eastern Time - offset for timestamp labels
          $time_eastern = time() - (2 * 60 * 60);

          //GMT - 2 hr offset for DB requests
          $time_gmt = strtotime (gmdate('d M Y H:i:s'));
          $offset = $time_gmt - (2 * 60 * 60);
          
          //GMT - 4 for CODAR default
          $codar_offset = $time_gmt - (4 * 60 * 60);
          
          $timestamp = date('m-d-Y g\:\0\0 a', $time_eastern) ."\n";
          $class->settext($label_layer,"$timestamp"); 
                    
          $nLayers = $oMap->numlayers;
          for ($i=0;$i<$nLayers;$i++)
          {
               $oLayer = $oMap->getLayer($i);
               $db_processing = $oLayer->getMetaData('db_processing');

               if ($oLayer->connectiontype == MS_WMS && $oLayer->group == 'Observations')
               {
                  $con_string = $oLayer->GetMetaData("wms_onlineresource");                    
                  $value = '&time_offset_hours=2';
                  $new_con_string = $con_string.$value;
                  //print $new_con_string;
                  $oLayer->set('connection', $new_con_string);
               }

               if ($oLayer->connectiontype == MS_POSTGIS && $db_processing == '1')
                {
                    //timestamp format is 2006-01-16 16:00
                    $db_request_time = date('Y-m-d H\:i', $offset);
                    $oLayer->setFilter('report_time_stamp = date_trunc(\'hour\',timestamp without time zone \''.$db_request_time.'\')');
                    
                }

                if ($oLayer->connectiontype == MS_POSTGIS && $db_processing == '3')
                {
                    //timestamp format is 2006-01-19 16:00 
                    $codar_request_time = date('Y-m-d H\:i', $codar_offset);    
                    $oLayer->setFilter('report_time_stamp = date_trunc(\'hour\',timestamp without time zone \''.$codar_request_time.'\')');
                }


                if ($oLayer->connectiontype == MS_POSTGIS && $db_processing == '2')
                { 
                    $cur_request_time = date('Y-m-d H\:i', $codar_offset);
                    $oLayer->setFilter('(report_time_stamp = date_trunc(\'hour\',timestamp without time zone \''.$cur_request_time.'\')) and (surface_or_bottom = \'surface\')');
                }       

                // for ADCP currents from Xenia - codar TS
                if ($oLayer->connectiontype == MS_POSTGIS && $db_processing == '4')
                {
                    //timestamp format is 2006-01-19 16:00
                    $cur_request_time = date('Y-m-d H\:i', $codar_offset);
                    //$oLayer->setFilter('m_type_id = 41 and (sensor_id IN (select row_id from sensor where type_id = 4 )) and (d_report_hour = (timestamp without time zone \''.$cur_request_time.'\')) and (d_top_of_hour = 1 )');
                    $oLayer->setFilter('m_type_id = 41 and (sensor_id IN (select row_id from sensor where type_id = 4 )) and  (m_date > (timestamp without time zone \''.$cur_request_time.'\' - interval \'30 minutes\' )) and (m_date < (timestamp without time zone \''.$cur_request_time.'\' + interval \'31 minutes\'))');
                }

               
          }

     return $bRes;
     }

     else 
     {
     return $bRes;
     }
 
  }
}

$oApp =  new SampleApp();
$oApp->registerSkin( 'skins/sample' );
$oApp->CWCInitialize( $szTemplate, $szMapFile  ); 
$oApp->CWCExecute();

?>