#I LOVE YOU EVERDAY#

<?php require_once('../Connections/fleetMan.php'); ?>
<?php require_once("functions.php"); $api = new fleet(); ?>
<?php
if (!isset($_SESSION)) {
  session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";

// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) { 
  // For security, start by assuming the visitor is NOT authorized. 
  $isValid = False;

// When a visitor has logged into this site, the Session variable MM_Username set equal to their username. 
  // Therefore, we know that a user is NOT logged in if that Session variable is blank. 
  if (!empty($UserName)) { 
    // Besides being logged in, you may restrict access to only certain users based on an ID established when they login. 
    // Parse the strings into arrays. 
    $arrUsers = Explode(",", $strUsers); 
    $arrGroups = Explode(",", $strGroups); 
    if (in_array($UserName, $arrUsers)) { 
      $isValid = true; 
    } 
    // Or, you may restrict access to only certain users based on their username. 
    if (in_array($UserGroup, $arrGroups)) { 
      $isValid = true; 
    } 
    if (($strUsers == "") && true) { 
      $isValid = true; 
    } 
  } 
  return $isValid; 
}

//Report Content
mysql_select_db($database_fleetMan, $fleetMan);
$report_tables = $api->report_table();

$MM_restrictGoTo = "login.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {   
  $MM_qsChar = "?";
  $MM_referrer = $_SERVER['PHP_SELF'];
  if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
  if (isset($_SERVER['QUERY_STRING']) && strlen($_SERVER['QUERY_STRING']) > 0) 
  $MM_referrer .= "?" . $_SERVER['QUERY_STRING'];
  $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
  header("Location: ". $MM_restrictGoTo); 
  exit;
}
?>
<?php
  if(isset($_POST['template_name']))
  {
	  $name = $_POST['template_name'];
	  $desc = $_POST['template_desc'];
	  
	  $query_text = array();
	  
	  foreach(array_keys($_POST) as $item)
	  {
		  $table = substr($_POST[$item],0,strpos($_POST[$item],"."));
		  if($api->is_db_row($table,$_POST[$item]))
		  {
		  	$query_text[] = $_POST[$item];
		  }
	  }
	  
	  if(sizeof($query_text) > 0)
	  {
		  $n = mysql_query("insert into report_template (report_name, `desc`, query, _who_added, _when_added) values ('".mysql_real_escape_string($name)."', '".mysql_real_escape_string($desc)."', '".mysql_real_escape_string(json_encode($query_text))."', '1', '".date("Y-m-d H:i:s")."')");
		  if($n)
		  {
			  $status = "Success: Report template was successfully saved.";
		  }
	  }
	  else
	  {
		  $status = "Error: No downloadable columns have been defined.";
	  }
  }
?>
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0">
  <meta name="description" content="">
  <meta name="author" content="">

<title>Download Reports</title>

</head>

<div class="panel">
            <div class="panel-heading">
              <?php 
			    if(isset($status)) echo '<p>'.$status.'</p>';
			  ?>
              <h4 class="panel-title">DATA STORE</h4>
              <p>Select data stores and associated columns (constraints) from which to generate the report template. </p>
            </div>
            <div class="panel-body">
              
              <h4 class="panel-title mb10">Select Data Store:</h4>
              <p class="mb20">You can select multiple data-stores.</p>
              
              <div class="form-group">
                <input type="text" placeholder="Enter Template Name" class="form-control" required name="template_name" />
              </div>
              
              <div class="form-group">
                <textarea class="form-control" rows="2" placeholder="Enter Report Description" name="template_desc"></textarea>
              </div>

</div>
          </div>

</div>

<div class="panel">
            <div class="panel-heading">
              <h4 class="panel-title">SELECT DATA COLUMNS</h4>
              <p>The data columns are labelled as show: Store:Label</p>
            </div>
            <div class="panel-body">
              <div class="row">
                <div class="col-md-6" id="column_list">

</div>

</div>
            </div>
           
            
          </div>
          
         
          </div>
      </div>
      
       <div class="form-group">
              <button class="btn btn-info" type="submit" name="submit">Save Template</button>
              </div>
          
		</form>
    </div>
  </div>

</section>

// Textarea Auto Resize
  autosize($('#autosize'));

// Select2 Box
  $('#select1, #select2, #select3').select2();
  $("#select4").select2({ maximumSelectionLength: 2 });
  $("#select5").select2({ minimumResultsForSearch: Infinity });
  $("#select6").select2({ tags: true });

// Toggles
  $('.toggle').toggles({
    on: true,
    height: 26
  });

// Input Masks
  $("#date").mask("99/99/9999");
  $("#phone").mask("(999) 999-9999");
  $("#ssn").mask("999-99-9999");

// Date Picker
  $('#datepicker').datepicker();
  $('#datepicker-inline').datepicker();
  $('#datepicker-multiple').datepicker({ numberOfMonths: 2 });

// Time Picker
  $('#tpBasic').timepicker();
  $('#tp2').timepicker({'scrollDefault': 'now'});
  $('#tp3').timepicker();

$('#setTimeButton').on('click', function (){
    $('#tp3').timepicker('setTime', new Date());
  });

// Colorpicker
  $('#colorpicker1').colorpicker();
  $('#colorpicker2').colorpicker({
    customClass: 'colorpicker-lg',
    sliders: {
      saturation: {
        maxLeft: 200,
        maxTop: 200
      },
      hue: { maxTop: 200 },
      alpha: { maxTop: 200 }
    }
  });

});
</script>