area_list.php

<?php 
		
	require(__DIR__.'/source/main.php');
	require(__DIR__.'/source/common_functions/common_security.php');
	
	const LOCAL_STORED_PROC_NAME 	= 'area'; 	// Used to call stored procedures for the main record set of this script.
	const LOCAL_BASE_TITLE 			= 'Area';	// Title display, button labels, instruction inserts, etc.
	
	class class_filter_control
	{
		const _DATE_FORMAT  = 'Y-m-d H:i:s'; 
		
		private			
			$data_common = NULL,
			$building	= NULL,
			$floor		= NULL,
			$time_obj	= NULL,
			$time_end 	= NULL,
			$time_start	= NULL;
		
		public function __construct(\dc\chronofix\Chronofix $iChronofix)
		{
			$this->data_common = new \data\Common();
			$this->time_obj = $iChronofix;	
		}
		
		// Accessors
		public function get_building()
		{
			return $this->building;
		}
		
		public function get_floor()
		{
			return $this->building;
		}
		
		public function get_data_common()
		{
			return $this->data_common;
		}
		
		public function get_id()
		{
			return $this->data_common->get_id();
		}
		
		public function get_time_end()
		{
			return $this->time_end;
		}
		
		public function get_time_start()
		{
			return $this->time_start;
		}
		
		// Mutators
		public function set_building($value)
		{
			$this->building = $value;
		}
		
		public function set_floor($value)
		{
			$this->building = $value;
		}
		
		public function set_time_end($value)
		{
			// Run time through sanitizer to 
			// get a valid and uniform date/time.
			$this->time_obj->set_time($value);
			$this->time_obj->sanitize();
			
			// Set member.			
			$this->time_end = $this->time_obj->get_time();
		}
		
		public function set_time_start($value)
		{	
			// Run time through sanitizer to 
			// get a valid and uniform date/time.
			$this->time_obj->set_time($value);
			$this->time_obj->sanitize();
			
			// Set member.			
			$this->time_start = $this->time_obj->get_time();	
		}
		
		public function populate_from_request()
		{
			$this->data_common->populate_from_request();
		}
	}
	
	// Verify user access.
	common_security($yukon_database);
	
	// Start page cache.
	$page_obj = new \dc\cache\PageCache();
	
	// Main navigaiton.
	$obj_navigation_main = new class_navigation();
	
	// Initialize time library with settings.
	$iChronofix 		= new \dc\chronofix\Chronofix();
	
	$filter_control = new class_filter_control($iChronofix);
	$filter_control->populate_from_request();
	
	// Establish sorting object, set defaults, and then get settings
	// from user (if any).
	$sorting = new \dc\sorting\SortControl;
	$sorting->set_sort_field(3);
	$sorting->set_sort_order(\dc\sorting\ORDER_TYPE::ASCENDING);
	$sorting->populate_from_request();
	
	// Set up navigaiton.
	$navigation_obj = new class_navigation();
	
	// Set up database.
	$query = new \dc\yukon\Database($yukon_connection);
		
	$paging = new \dc\recordnav\Paging();
	$paging->set_row_max(APPLICATION_SETTINGS::PAGE_ROW_MAX);
	
	// Record navigation.
	$obj_navigation_rec = new \dc\recordnav\RecordNav();
	
	$query->set_sql('{call '.LOCAL_STORED_PROC_NAME.'_list(@param_page_current 		= ?,														 
										@param_page_rows 	= ?,
										@param_sort_field	= ?,
										@param_sort_order	= ?,
										@param_date_start	= ?,
										@param_date_end		= ?,
										@param_building_code	= ?,
										@param_floor		= ?)}');	
	
	$params = array(array($paging->get_page_current(), 			SQLSRV_PARAM_IN), 
					array($paging->get_row_max(), 				SQLSRV_PARAM_IN),
					array($sorting->get_sort_field(),			SQLSRV_PARAM_IN),
					array($sorting->get_sort_order(),			SQLSRV_PARAM_IN),
					array($filter_control->get_time_start(),	SQLSRV_PARAM_IN),
					array($filter_control->get_time_end(),		SQLSRV_PARAM_IN),
					array($filter_control->get_building(),		SQLSRV_PARAM_IN),
					array($filter_control->get_floor(),			SQLSRV_PARAM_IN));

	// Debugging tools
	//var_dump($params);
	//exit;

	$query->set_param_array($params);
	$query->query_run();
	
	$query->get_line_config()->set_class_name('\data\Area');
	$_obj_data_main_list = $query->get_line_object_list();

	// --Paging
	$query->get_next_result();
	
	$query->get_line_config()->set_class_name('\dc\recordnav\Paging');
	
	//$_obj_data_paging = new \dc\recordnav\Paging();
	if($query->get_row_exists()) $paging = $query->get_line_object();
	
	// Datalist list generation.
		
		// Buildings
		$_obj_field_source_building_list = new \data\Area();
	
		$query->set_sql('{call area_building_list(@param_page_current = ?)}');
		$query->query_run(array(-1));
		
		$query->get_line_config()->set_class_name('\data\Area');
		
		$_obj_field_source_building_list = new SplDoublyLinkedList();
		if($query->get_row_exists() === TRUE) $_obj_field_source_building_list = $query->get_line_object_list();
		
		// Floors
		$_obj_field_source_floor_list = new \data\Area();
	
		$query->set_sql('{call area_floor_list(@param_page_current = ?)}');
		$query->query_run(array(-1));
		$query->query_run();
		
		$query->get_line_config()->set_class_name('\data\Area');
		
		$_obj_field_source_floor_list = new SplDoublyLinkedList();
		if($query->get_row_exists() === TRUE) $_obj_field_source_floor_list = $query->get_line_object_list();
?>

<!DOCtype html>
<html lang="en">
    <head>
        <meta charset="utf-8" name="viewport" content="width=device-width, initial-scale=1" />
        <title><?php echo APPLICATION_SETTINGS::NAME. ', '.LOCAL_BASE_TITLE; ?> List</title>        
        
        <!-- CSS -->
        <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css">
        <!--link rel="stylesheet" href="source/css/jquery.datetimepicker.min.css" /-->
        <link rel="stylesheet" href="source/css/style.css" />
        <link rel="stylesheet" href="source/css/print.css" media="print" />
        
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
        <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js"></script>
        <script src="source/javascript/modernizr.js"></script>
        <script src="source/javascript/iChronofix.js"></script>       
    </head>
    
    <body>    
        <div id="container" class="container">            
            <?php echo $navigation_obj->generate_markup_nav(); ?>                                                                                
            <div class="page-header">
                <h1><?php echo LOCAL_BASE_TITLE; ?> List</h1>
                <p class="lead">This form allows you to view the complete <?php echo strtolower(LOCAL_BASE_TITLE);?> list. Click any row to view details.</p>
            </div>
            
            	<div class="panel panel-default" id="filter_container">
                    <div class="panel-heading" id="filter_header">
                        <h4 id="h41" class="panel-title">
                        <a class="accordion-toggle" data-toggle="collapse" href="#collapse_module_1"><span class="glyphicon glyphicon-filter"></span><span class="glyphicon glyphicon-menu-down pull-right"></span> Filters</a>
                        </h4>
                    </div><!--#filter_header-->
                
                	<div id="collapse_module_1" class="panel-collapse collapse" id="filter_collapse">
                        <div class="panel-body" id="filter_body">                         
                                                       
                            <form class="form-horizontal" role="form" id="form_filter" method="get">
            	                
                                <input type="hidden" name="id" value="<?php echo $filter_control->get_id(); ?>" />
                                <input type="hidden" name="field" value="<?php echo $sorting->get_sort_field(); ?>" />
                                <input type="hidden" name="order" value="<?php echo $sorting->get_sort_order(); ?>" />
                                                         
                                <div class="form-group" id="group_filter_time">
                                    <label class="control-label col-sm-2" for="filter_time_start">Time (from):</label>
                                    <div class="col-sm-4">
                                        <input 
                                            type	="datetime-local" 
                                            class	="form-control time_start_filter"  
                                            name	="time_start" 
                                            id		="time_start" 
                                            step	="1"                                            
                                            placeholder="yyyy-mm-dd hh:mm:ss"
                                            value="<?php echo $filter_control->get_time_start(); ?>">
                                    </div>
                                
                                    <label class="control-label col-sm-2" for="filter_time_end">Time (to):</label>
                                    <div class="col-sm-4">
                                        <input  
                                            name	="time_end" 
                                            type	="datetime-local" 
                                            class	="form-control time_end_filter" 
                                            id		="time_end" 
                                            step	="1"
                                            placeholder="yyyy-mm-dd hh:mm:ss" autocomplete="on"
                                            min="01"
                                            value="<?php echo $filter_control->get_time_end(); ?>">
                                    </div>
                                </div><!--#group_filter_time-->
                                
                                <div class="form-group">
                                    <label class="control-label col-sm-2" for="building">Building</label>
                                    <div class="col-sm-10">
                                        <select name="building" 
                                            id="building" 
                                            data-current="<?php echo $filter_control->get_building(); ?>" 
                                            data-source-url="../../libraries/inserts/facility.php" 
                                            data-extra-options='<option value="0">All Buildings</option>'
                                            data-grouped="1"
                                            class="room_search form-control">
                                            <optgroup label="Groups">                            
                                                <option value="-1" <?php if($filter_control->get_building() == '-1') echo ' selected ' ?>>All</option>
                                            </optgroup>
                                            <optgroup label="Buildings">
                                                <?php
                                                
                                                    // Generate table row for each item in list.
                                                    for($_obj_field_source_building_list->rewind();	$_obj_field_source_building_list->valid(); $_obj_field_source_building_list->next())
                                                    {	                                                               
                                                        $_obj_field_source_building = $_obj_field_source_building_list->current();
                                                        
                                                        $sub_building_code 		= $_obj_field_source_building->get_building_code();																
                                                        $sub_building_name		= $_obj_field_source_building->get_building_name();
                                                        $sub_building_selected 	= NULL;
                                                                
                                                        if($filter_control->get_building())
                                                        {
                                                            if($filter_control->get_building() == $sub_building_code)
                                                            {
                                                                $sub_building_selected = ' selected ';
                                                            }								
                                                        }
                                                        
                                                        ?>
                                                        <option value="<?php echo $sub_building_code; ?>" <?php echo $sub_building_selected; ?>><?php echo $sub_building_code .' - '.$sub_building_name; ?></option>
                                                        <?php                                
                                                    }
                                                
                                                ?>
                                            </optgroup>                                 
                                        </select>
                                    </div>                
                                </div>
                                
                                <div class="form-group">
                                    <label class="control-label col-sm-2" for="floor">Floor</label>
                                    <div class="col-sm-10">
                                        <select name="floor" 
                                            id="floor" 
                                            data-current="<?php echo $filter_control->get_floor(); ?>" 
                                            data-grouped="1"
                                            class="room_search form-control">
                                            <optgroup label="Groups">                            
                                                <option value="" <?php if($filter_control->get_floor() == '') echo ' selected ' ?>>All</option>
                                            </optgroup>
                                            <optgroup label="Floors">
                                                <?php
                                                
                                                    // Generate table row for each item in list.
                                                    for($_obj_field_source_floor_list->rewind();	$_obj_field_source_floor_list->valid(); $_obj_field_source_floor_list->next())
                                                    {	                                                               
                                                        $_obj_field_source_floor = $_obj_field_source_floor_list->current();
                                                        
                                                        $sub_floor 				= $_obj_field_source_floor->get_floor();		
                                                        $sub_floor_selected 	= NULL;
                                                                
                                                        if($filter_control->get_floor())
                                                        {
                                                            if($filter_control->get_floor() == $sub_floor)
                                                            {
                                                                $sub_floor_selected = ' selected ';
                                                            }								
                                                        }
                                                        
                                                        ?>
                                                        <option value="<?php echo $sub_floor; ?>" <?php echo $sub_floor_selected; ?>><?php echo $sub_floor; ?></option>
                                                        <?php                                
                                                    }
                                                
                                                ?>
                                            </optgroup>                                 
                                        </select>
                                    </div>                
                                </div>
                                         
                                <button 
                                    type	="submit"
                                    class 	="btn btn-primary btn-block" 
                                    name	="set_filter" 
                                    id		="set_filter"
                                    title	="Apply selected filters to list."
                                    ><span class="glyphicon glyphicon-filter"></span>Apply Filters</button>       
                                    
                            </form><!--#form_filter-->                                       
                        </div><!--#filter_body-->
                    </div><!--#filter_collapse-->
                </div><!--#filter_container-->
            
            <?php
				// Clickable rows. Clicking on table rows
				// should take user to a detail page for the
				// record in that row. To do this we first get
				// the base name of this file, and remove "list".
				// 
				// The detail file will always have same name 
				// without "list". Example: area.php, area_list.php
				//
				// Once we have the base name, we can use script to
				// make table rows clickable by class selector
				// and passing a completed URL (see the <tr> in
				// data table we are making clickable).
				//
				// Just to ease in development, we verify the detail
				// file exists before we actually include the script
				// and build a complete URL string. That way if the
				// detail file is not yet built, clicking on a table
				// row does nothing at all instead of giving the end
				// user an ugly 404 error.
				//
				// Lastly, if the base name exists we also build a 
				// "new item" button that takes user directly
				// to detail page with a blank record.	
			 
				$target_url 	= '#';
				$target_name	= basename(__FILE__, '_list.php').'.php';
				$target_file	= __DIR__.'/'.$target_name;				
				
				// Does the file exisit? If so we can
				// use the URL, script, and new 
				// item button.
				if(file_exists($target_file))
				{
					$target_url = $target_name;
				?>
                	<script>
						// Clickable table row.
						jQuery(document).ready(function($) {
							$(".clickable-row").click(function() {
								window.document.location = '<?php echo $target_url; ?>?id=' + $(this).data("href");
							});
						});
					</script>
                    
                    <a href="<?php echo $target_url; ?>&#63;nav_command=<?php echo \dc\recordnav\COMMANDS::NEW_BLANK;?>&amp;id=<?php echo \dc\yukon\DEFAULTS::NEW_ID; ?>" class="btn btn-success btn-block" title="Click here to start entering a new item."><span class="glyphicon glyphicon-plus"></span> <?php echo LOCAL_BASE_TITLE; ?></a>
                <?php
				}
				
				
			?>
            <!-- Top record paging controls -->
            <br />
          	<?php echo $paging->generate_paging_markup(); ?>
            
            <!--div class="table-responsive"-->
                <table class="table table-hover">
                    <thead>
                        <tr>
                            <th><a href="<?php echo $sorting->sort_url(1); ?>">Revision <?php echo $sorting->sorting_markup(1); ?></a></th>
                            <th><a href="<?php echo $sorting->sort_url(3); ?>">Location <?php echo $sorting->sorting_markup(3); ?></a></th>
                            <th><a href="<?php echo $sorting->sort_url(4); ?>">Floor <?php echo $sorting->sorting_markup(4); ?></a></th>              
                        </tr>
                    </thead>
                    <tfoot>
                    	<tr>
                            <th><a href="<?php echo $sorting->sort_url(1); ?>">Revision <?php echo $sorting->sorting_markup(1); ?></a></th>
                            <th><a href="<?php echo $sorting->sort_url(3); ?>">Location <?php echo $sorting->sorting_markup(3); ?></a></th>
                            <th><a href="<?php echo $sorting->sort_url(4); ?>">Floor <?php echo $sorting->sorting_markup(4); ?></a></th>              
                        </tr>
                    </tfoot>
                    <tbody>                        
                        <?php
                            if(is_object($_obj_data_main_list) === TRUE)
							{
								for($_obj_data_main_list->rewind(); $_obj_data_main_list->valid(); $_obj_data_main_list->next())
								{						
									$_obj_data_main = $_obj_data_main_list->current();
									
									$_class_addition = NULL;
									
									// If this is a record that does not exist in 
									// the local database, let's alert the user
									// by adding a visual touch.
									if($_obj_data_main->get_id() == \dc\yukon\DEFAULTS::NEW_ID)
									{
										$_class_addition = 'alert-info';
									}
                            ?>
                                        <tr class="clickable-row <?php echo $_class_addition; ?>" role="button" data-href="<?php echo $_obj_data_main->get_id(); ?>&amp;room_code=<?php echo $_obj_data_main->get_room_code(); ?>">
                                            <td><?php if(is_object($_obj_data_main->get_create_time()) === TRUE) echo date(APPLICATION_SETTINGS::TIME_FORMAT, $_obj_data_main->get_create_time()->getTimestamp()); ?></td>
                                            <td><?php echo $_obj_data_main->get_building_name().' - '.$_obj_data_main->get_room_id(); ?></td>
                                            <td><?php echo $_obj_data_main->get_floor(); ?></td>
                                        </tr>                                    
                            <?php								
                            	}
							}
                        ?>
                    </tbody>                        
                </table>  
            <?php 
				echo $paging->get_markup();
				echo $navigation_obj->generate_markup_footer(); 
			?>
        </div><!--container-->        
	<script>
		(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
		(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
		m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
		})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
		
		ga('create', 'UA-40196994-1', 'uky.edu');
		ga('send', 'pageview');

		// Reload window when gaining focus.
		var $blurred = false;
		window.onblur = function() { $blurred = true; };
		window.onfocus = function() { $blurred && (location.reload()); };
	
		// Let's handle date and time entry.
		// We want to use the jquery time picker,
		// but only if the browser doesn't
		// support a datetime-local type
		// field. We'll use modernizr library
		// to check for support and act accordingly.
		
		// Get support status of datetime-local field. 
		$supported = Modernizr.inputtypes['datetime-local'];
		
		var $format = 'Y-m-d h:m:s';
	
	
		// If the datetime-local type is not supported,
		// then we need to load the files needed for
		// timepicker, and execute it.
		if(!$supported){
			include('source/javascript/jquery.datetimepicker.full.min.js', function(){
				
				// Load css for the time picker.
				if (document.createStyleSheet){
					document.createStyleSheet('style.css');
				}
				else {
					$('head').append($('<link rel="stylesheet" href="source/css/jquery.datetimepicker.min.css" type="text/css" media="screen" />'));
				}
				
				// Apply time picker to fields.
				jQuery('.time_start_filter').datetimepicker({
					validateOnBlur:true,
					value:'<?php echo $filter_control->get_time_start(); ?>',
					format:$format
				});
				
				jQuery('.time_end_filter').datetimepicker({
					validateOnBlur:true,
					value:'<?php echo $filter_control->get_time_end(); ?>',
					format:$format
				});				
			});
		}
		else
		{
			include('source/javascript/moment.js', function(){	
				$format = 'YYYY-MM-DDTHH:mm:ss';
				
				// Datetime is supported, so just populate the fields.
				jQuery('.time_start_filter').val(moment('<?php echo $filter_control->get_time_start(); ?>').format($format));
				jQuery('.time_end_filter').val(moment('<?php echo $filter_control->get_time_end(); ?>').format($format));				
			});
		}
	
		// Conditonally load and fire script.
		function include(script,callback){
			$.getScript(script, function(){			
				if(typeof callback == 'function')
				callback.apply({},arguments);
			});
		}
</script>
</body>
</html>

<?php
	// Collect and output page markup.
	echo $page_obj->markup_and_flush();
?>