<?php
/**
 * Copyright (C) DairyWindow 2018
 * admin@dairywindow.nz
 */

	/* (C) DairyWindow 2012-2017 */
	
	require "inc/connect.php";
	
	if(isset($_POST['c']) && $_POST['c']!="" && $_POST['c']!=null) $c = clean($_POST['c']);
	else if(isset($_GET['c']) && $_GET['c']!="" && $_GET['c']!=null) $c = clean($_GET['c']);
	else $c = date('Y-m-d');
	
	$title = "Shift notes";
	require "inc/head.php";
	$menu = "notessummary";
	require "inc/menu.php";
	
	if($debug) showdebug();
	
?>
	
	<div id="topDIV" >
		<h1 class="text-center visible-xs-block hidden-print"><?php echo date("D j/n/y",  strtotime($c)); if($debug) echo "&nbsp;<small title=\"".str_replace("	","", $sql)."\"></small>"; ?></h1>
		<h1 class="text-center visible-lg-block"><?php echo date("l j F, Y", strtotime($c)); if($debug) echo "&nbsp;<small title=\"".str_replace("	","", $sql)."\"></small>"; ?></h1>
		<h1 class="text-center visible-print-block"><?php echo date("l j F, Y", strtotime($c)); if($debug) echo "&nbsp;<small title=\"".str_replace("	","", $sql)."\"></small>"; ?></h1>
	</div>
	
	<div class="container-fluid">
		<?php require "inc/calendar.php"; ?>
		<div class="col-md-9" role="main">
			<?php
				$sql='
					Select
						dw_sn_page.pageID,
						dw_sn_page.pageText,
						dw_sn_field.fieldTitle,
						dw_sn_value.valueValue
					From
						dw_sn_value Inner Join
						dw_sn_field On dw_sn_value.valueField = dw_sn_field.fieldID Inner Join
						dw_sn_page On dw_sn_page.pageID = dw_sn_field.fieldPage
					Where
						dw_sn_page.pageSite     = '.$_SESSION['userSite'].' And
						dw_sn_page.pageActive   = 1 And
						dw_sn_field.fieldActive = 1 And
						dw_sn_field.fieldType   = 3 And
						dw_sn_value.valueDay    = "'.$c.'"
					Group by
						dw_sn_field.fieldID,
						dw_sn_value.valueValue
					Order By
						dw_sn_page.pageOrder,
						dw_sn_field.fieldOrder
				';
				/*
				echo "sql: ".$sql."<br>\r\n";
				echo "pageSite: ".$_SESSION['userSite']."<br>\r\n";
				echo "valueDay: ".$c."<br>\r\n";
				*/
				//if(!$query = mysqli_prepared_query($link, $sql, "is", array($_SESSION['userSite'], $c), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
				if(!$query = $link->query($sql)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
				//print_r($query);
				//if(mysqli_prepared_num_rows($query)>0){
					//foreach($query as $array){
					while($array = $query->fetch_array()){
						echo "
							<div class='row'>
								<div class='col-md-1'>
									<h4><a href='shiftnotes.php?c=".$c."&amp;p=".$array['pageID']."'>".$array['pageText']."</a></h4>
									<h5><a href='shiftnotes.php?c=".$c."&amp;p=".$array['pageID']."'>".$array['fieldTitle']."</a></h5>
								</div>
								<div class='col-md-11'>
									".$array['valueValue']."
								</div>
							</div>
							<hr>
						";
					}
					/*
				}else{
					echo "No records found";
				}
					*/
			?>
		</div>
	</div>
	
	<script src="js/responsive-calendar.js?v=2.1">/* for calendar */</script>
	<script src="js/tinymce/tinymce.min.js?v=2.1">/* Need this for shiftnotes.js */</script>
	<script src="js/shiftnotes.js?v=2.1">/* Include JS specific to shiftnotes */</script>
	<script>
		tinymce.init({
			selector: ".textarea",
			plugins: [
				"advlist anchor autolink charmap colorpicker contextmenu emoticons hr image imagetools",
				"insertdatetime link lists media paste searchreplace table template textcolor jbimages"
			],
			imagetools_cors_hosts: ['dairywindow.nz'],
			toolbar: "bold italic underline strikethrough | fontsizeselect forecolor | bullist | insertdatetime link jbimages | emoticons",
			imagetools_toolbar: 'rotateleft rotateright | flipv fliph | editimage imageoptions',
			insertdatetime_formats: ["%H:%M", "%I:%M %p", "%d %b", "%d/%m/%Y", "%d/%m/%y %H:%M"],
			statusbar: false, resize: false,
			fontsize_formats: "8pt 9pt 10pt 12pt 14pt 18pt 24pt 36pt",
			relative_urls: false
		});
		$(function () {
			//$('[data-toggle="tooltip"]').tooltip();
			$('[data-toggle="popover"]').popover();
		});
	</script>
<?php require "inc/footer.php"; ?>