<?php

//$sql = 'SELECT * WHERE id IN (' . implode(',', $ids) . ')';
$varietyCList = "";
$varietyCount = 0;
$validEntries = "";

if($_GET['variety1'] != "") {
  $varietyCList = $varietyCList . "'" . $_GET['variety1'] . "',";
  $varietyCount = $varietyCount + 1;
}
if($_GET['variety2'] != "") {
  $varietyCList = $varietyCList. "'" . $_GET['variety2'] . "',";
  $varietyCount = $varietyCount + 1;
}
if($_GET['variety3'] != "") {
  $varietyCList = $varietyCList. "'" . $_GET['variety3'] . "',";
  $varietyCount = $varietyCount + 1;
}

if($varietyCount > 0 && $_GET['searchtype'] == 'searchcompare' && $_GET['comparisontype'] == 'head') {
  $varietyCList = rtrim($varietyCList, ",");

  $getHeadtoHeadList = "select a.field_id_4, a.entry_id, a.field_id_4 as variety, a.field_id_34 as results, a.field_id_6 as year, a.field_id_5 as town, a.field_id_30 as province from exp_channel_data a inner join (select field_id_4, field_id_34, field_id_6, field_id_5, field_id_30 from exp_channel_data where field_id_4 in (".$varietyCList.") group by field_id_30, field_id_5, field_id_6 having count(*)=".$varietyCount." ) b on (a.field_id_6 = b.field_id_6) and (a.field_id_5 = b.field_id_5) and (a.field_id_30 = b.field_id_30) order by year, province, town, variety";

  $query = $this->EE->db->query($getHeadtoHeadList);

  if ($query->num_rows() > 0)  {
   foreach ($query->result() as $row)
   {
    $validEntries = $validEntries . $row->entry_id . ",";
   } 
   $validEntries = rtrim($validEntries,",");
  }

}


    $searchIntro = "SELECT REPLACE (D.field_id_31, ' ', '-') as short_herbicide, ROUND(REPLACE(D.field_id_12,'$',''),2) as gross_revenue, D.field_id_6 as trial_year, D.field_id_32 as season_zone, D.field_id_30 as province, ROUND(D.field_id_8,1) as yield, ROUND(D.field_id_9,1) as dtm, ROUND(D.field_id_10,1) as lodging, ROUND(D.field_id_11,1) as height, D.field_id_4 as variety, D.field_id_5 as trial_location,D.field_id_30  as location_province, D.field_id_33 as trial_type FROM exp_channel_data D ";
    
    $locationList = "select distinct D.field_id_30 as province, D.field_id_5 as location from exp_channel_data D ";

    $searchSelectSmall = "";
    $searchSelectSmall .= "WHERE D.channel_id = '3' ";

    //zone type
    if(isset($_GET['zone-type']) && $_GET['zone-type'] != '' && $_GET['zone-type'] != 'all') {
      $searchSelectSmall .= " AND field_id_32 = '".$_GET['zone-type']."'";
    }

    if(isset($_GET['town']) && $_GET['town'] != '') {
      $searchSelectSmall .= " AND field_id_5 = '".$_GET['town']."'";
    }
    if(isset($_GET['province']) && $_GET['province'] != '' && $_GET['province'] != 'all') {
      $searchSelectSmall .= " AND field_id_30 = '".$_GET['province']."'";
    }

    //herbicides
    $searchHerbs = "(";
    $atLeast1 = 0;
    if(isset($_GET['herbicides-roundup-ready']) && $_GET['herbicides-roundup-ready'] != '') {
      $searchHerbs .= "D.field_id_31 = 'Roundup Ready' or ";
      $atLeast1 = 1;
    }
    if(isset($_GET['herbicides-liberty-link']) && $_GET['herbicides-liberty-link'] != '') {
      $searchHerbs .= "D.field_id_31 = 'Liberty Link' or ";
      $atLeast1 = 1;
    }
    if(isset($_GET['herbicides-clearfield']) && $_GET['herbicides-clearfield'] != '') {
      $searchHerbs .= "D.field_id_31 = 'Clearfield' or ";
      $atLeast1 = 1;
    }
    $searchHerbs = substr($searchHerbs, 0, -4);
    $searchHerbs .= ") ";
    if($atLeast1 == 1) {
      $searchSelectSmall .= " AND ".$searchHerbs;
    }

    //year(s)
      $searchYears = "(";
      if(isset($_GET['2018']) && $_GET['2017'] == '2018') {
          $searchYears .= "D.field_id_6 = '2018' or ";
      }
      if(isset($_GET['2017']) && $_GET['2017'] == '2017') {
          $searchYears .= "D.field_id_6 = '2017' or ";
      }
      if(isset($_GET['2016']) && $_GET['2016'] == '2016') {
          $searchYears .= "D.field_id_6 = '2016' or ";
      }
      if(isset($_GET['2015']) && $_GET['2015'] == '2015') {
          $searchYears .= "D.field_id_6 = '2015' or ";
      }
      if(isset($_GET['2014']) && $_GET['2014'] == '2014') {
          $searchYears .= "D.field_id_6 = '2014' or ";
      }
      if(isset($_GET['2013']) && $_GET['2013'] == '2013') {
          $searchYears .= "D.field_id_6 = '2013' or ";
      }
      if(isset($_GET['2012']) && $_GET['2012'] == '2012') {
          $searchYears .= "D.field_id_6 = '2012' or ";
      }
      if(isset($_GET['2011']) && $_GET['2011'] == '2011') {
          $searchYears .= "D.field_id_6 = '2011' or ";
      }
      $searchYears = substr($searchYears, 0, -4);

      $searchYears .= ") ";
      if($searchYears != "() ") {
        //$searchSelect .= " AND ".$searchYears;
        $searchSelectSmall .= " AND ".$searchYears;
      }


      if($_GET['variety2'] != "") {
        $searchVarieties = "(";
        if(isset($_GET['variety1']) && $_GET['variety1'] != '') {
            $searchVarieties .= "D.field_id_4 = '".$_GET['variety1']."' or ";
        }
        if(isset($_GET['variety2']) && $_GET['variety2'] != '') {
            $searchVarieties .= "D.field_id_4 = '".$_GET['variety2']."' or ";
        }
        if(isset($_GET['variety3']) && $_GET['variety3'] != '') {
            $searchVarieties .= "D.field_id_4 = '".$_GET['variety3']."' or ";
        }
        $searchVarieties = substr($searchVarieties, 0, -4);

        $searchVarieties .= ") ";
        if($searchVarieties != "() ") {
          //$searchSelect .= " AND ".$searchYears;
          $searchSelectSmall .= " AND ".$searchVarieties;
        }
      }


      if($validEntries != "") {
        $searchSelectSmall = $searchSelectSmall . " AND entry_id in (".$validEntries.") ";
      }

    if(isset($_GET['trial-type']) && $_GET['trial-type'] != '' && $_GET['trial-type'] != 'all') {
      $searchSelectSmall .= " AND D.field_id_33 = '".$_GET['trial-type']."'";
    }

    $locationList = $locationList . $searchSelectSmall;
    $searchSelectSmall = $searchIntro . $searchSelectSmall;

?>

  <html lang="en">
  
  <meta name="description" content="">
  <meta name="viewport" content="width=device-width">
  
  <link rel="stylesheet" href="/css/main.css">
  <script src="/js/libs/modernizr/modernizr-2.6.2.dev.min.js"></script>
  
  <!-- Start Here -->
  <link href='https://fonts.googleapis.com/css?family=Signika:400,700' rel='stylesheet' type='text/css'>

  <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.js"></script>
  <script src="https://code.highcharts.com/highcharts.js"></script>
  <script src="https://code.highcharts.com/modules/exporting.js"></script>
  <script src="/js/jquery.tablesorter.min.js"></script> 
    
</head>
<body>
  
  <div class="header-bar"></div>

  <header class="masthead">
    <div class="container grid">
      <div class="col colspan4 text-center">
        <h1 ><a href="/" title="Canola Performance Trials"><img src="/images/logo-2022.png" alt="Canola Performance Trials" width="213"></a></h1>
      </div><!--colspan-->
      <div class="col colspan8">
        <ul class="nav-h nav-v-switch">
          <li><a href="/" title="Back to Home Page" class="btn-home btn">Search Trial Results</a> </li>
          <li><a href="/contact-us" title="Trial Protocol" class="btn">Contact Us</a></li>
        </ul>
      </div><!--colspan-->
      <ul class="utilities-nav">
        <!--<li><a href="" class="btn" id="save-button" title="Save"><img src="/images/icon-save.png" alt="Save"></a></li>-->
        <li><a href="" class="btn" id="print-button" title="Print"><img src="/images/icon-print.png" alt="Print"></a></li>
      </ul>
    </div><!--grid-->
  </header>


<div class="col colspan4">
            
  <div class="field">
    
    <label for="province">Province:</label>
    
    <select name="province">
      <option value="all">All Provinces</option>
      <option value="SK" >Saskatchewan</option>
      <option value="AB" >Alberta</option>
      <option value="MB" >Manitoba</option>
      <option value="BC" >BC</option>
    </select>
  </div><!--field-->
</div><!--colspan-->

<div class="col colspan4">
  
  <div class="field">
    
    <label for="zone-type">Zone Type:</label>
    
    <a class="map-link" href="/images/map-large.png" target="_blank" title="See full size map">What's this?</a>
    
    <select name="zone-type">
      <option value="">All Zones</option>
      <option value="Short" >Short</option>
      <option value="Mid" >Mid</option>
      <option value="Long" >Long</option>
    </select>
  </div><!--field-->
</div><!--colspan-->

<div class="col colspan4">
  
  <div class="field">
    
    <label for="trial-type">Trial Type:</label>
    
    <select name="trial-type">
      <option value="small-plot" selected="selected">Small Plot</option>
      <option value="field-scale" >Field Scale</option>
    </select>
  </div><!--field-->
</div><!--colspan-->

<div class="col colspan6 text-center" id="yearpanel">
  
  <div class="field">

    <label for="starting-year">Select which years should be included<sup>*</sup></label>
    <input type="checkbox" name="2011" value="2011" >&nbsp;2011&nbsp;&nbsp; 
    <input type="checkbox" name="2012" value="2012" >&nbsp;2012&nbsp;&nbsp;
    <input type="checkbox" name="2013" value="2013" >&nbsp;2013&nbsp;&nbsp;
    <input type="checkbox" name="2014" value="2014" >&nbsp;2014&nbsp;&nbsp;
    <input type="checkbox" name="2015" value="2015" >&nbsp;2015&nbsp;&nbsp;
    <input type="checkbox" name="2016" value="2016" >&nbsp;2016&nbsp;&nbsp;<br>
    <input type="checkbox" name="2017" value="2017" >&nbsp;2017&nbsp;&nbsp;
    <input type="checkbox" name="2018" value="2018" >&nbsp;2018&nbsp;&nbsp;
    <input type="checkbox" name="2019" value="2019" >&nbsp;2019&nbsp;&nbsp;
    <input type="checkbox" name="2020" value="2020" >&nbsp;2020&nbsp;&nbsp;
    <input type="checkbox" name="2021" value="2021" checked="checked">&nbsp;2021&nbsp;&nbsp;
  </div><!--field-->
</div><!--colspan-->

<div class="col colspan6 text-center" id="herbpanel">
  
  <div class="field" id="herbicide-list">
    
    <div class="label">Herbicides:<sup>*</sup></div>
    
    <label for="herbicides-roundup-ready" class="btn-label active" data-color="3059B4"><input type="checkbox" name="herbicides-roundup-ready" value="roundup-ready" checked='checked'><span></span>Roundup Ready </label>
    <label for="herbicides-liberty-link" class="btn-label active" data-color="529F54"><input type="checkbox" name="herbicides-liberty-link" value="liberty-link" checked='checked'><span></span>Liberty Link </label>
    <label for="herbicides-clearfield" class="btn-label active" data-color="C35100"><input type="checkbox" name="herbicides-clearfield" value="clearfield" checked='checked'><span></span>Clearfield </label>
  </div><!--field-->
</div><!--colspan-->

<div class="col colspan12 text-center">

 <a href="#" class="no-print reset-filter">Reset Custom Filters</a>
</div>


  <section id="formresults" class="clearfix">
    <div class="container grid">
      <div class="col colspan12 text-center">
        <h3>Search Results<?php if(isset($_GET['town']) && $_GET['town'] != "") { echo " for ".$_GET['town'].", ".$_GET['province']; } ?></h3>
      </div>
    </div><!--container-->
  </section>

  <?php if(isset($_GET['searchtype']) && $_GET['searchtype'] == 'searchall') { ?>

    <section class="clearfix">
      <div class="container grid">

        <div class="col colspan12" id="graphall" >
          <div class="pane clearfix">
            <div class="col colspan12">
              <div id="graph-container" class="text-center" data-querystrings="<?php echo strstr($_SERVER["REQUEST_URI"], '?'); ?>" data-filter="<?php if(isset($_GET['rate-results'])) { echo $_GET['rate-results']; } else {'Yield';} ?>">
                  <noscript>Your browser must support JavaScript to view the data graph.</noscript>
              </div>
            </div>
            <div class="col colstretch-left3 colstretch-right3 colspan6 graph-filter">
              <ul class="nav-h nav-v-switch">
                <li class="filter-title">Change Filter:</li>
                <li <?php if(isset($_GET['rate-results']) && $_GET['rate-results'] == 'Yield') { echo "class='active'"; } ?><?php if(isset($_GET['rate-results']) == false || (isset($_GET['rate-results']) && $_GET['rate-results'] == '')) { echo "class='active'"; } ?>><a href="/performance-trials/?searchtype=<?php echo $_GET['searchtype'];?><?php echo strstr($_SERVER["REQUEST_URI"], '&'); ?>&amp;rate-results=Yield#formresults">Yield</a></li>
                <li <?php if(isset($_GET['rate-results']) && $_GET['rate-results'] == 'DTM') { echo "class='active'"; } ?>><a href="/performance-trials/?searchtype=<?php echo $_GET['searchtype'];?><?php echo strstr($_SERVER["REQUEST_URI"], '&'); ?>&amp;rate-results=DTM#formresults">DTM</a></li>
                <li <?php if(isset($_GET['rate-results']) && $_GET['rate-results'] == 'Height') { echo "class='active'"; } ?>><a href="/performance-trials/?searchtype=<?php echo $_GET['searchtype'];?><?php echo strstr($_SERVER["REQUEST_URI"], '&'); ?>&amp;rate-results=Height#formresults">Height</a></li>
                <li <?php if(isset($_GET['rate-results']) && $_GET['rate-results'] == 'Lodging') { echo "class='active'"; } ?>><a href="/performance-trials/?searchtype=<?php echo $_GET['searchtype'];?><?php echo strstr($_SERVER["REQUEST_URI"], '&'); ?>&amp;rate-results=Lodging#formresults">Lodging</a></li>
              </ul>
            </div><!--colspan-->
            <span class="locations text-center"></span>
          </div><!--pane-->

        </div>

        <div class="col colspan12 text-center">
        *SY4157, sponsored by Syngenta, was previously named 09H7757 and sponsored by Cargill in 2013.
        </div>

      </div>
    </section>

  <?php } else { ?>


    <section class="clearfix">
      <div class="container grid">

        
        <div class="col colspan6" id="graph1" >
          <div class="pane clearfix">
            <div class="col colspan12 text-center">
              <h5>Yield</h5>
            </div>
            <div class="col colspan12">
              <div id="graph-container1" class="text-center" data-querystrings="<?php echo strstr($_SERVER["REQUEST_URI"], '?'); ?>" data-filter="<?php if(isset($_GET['rate-results'])) { echo $_GET['rate-results']; } else {'Yield';} ?>">
                  <noscript>Your browser must support JavaScript to view the data graph.</noscript>
              </div>
            </div>

            <span class="locations text-center"></span>
          </div><!--pane-->
        </div><!--graph1-->

        <div class="col colspan6" id="graph2" >
          <div class="pane clearfix">
            <div class="col colspan12 text-center">
              <h5>Days to Maturity</h5>
            </div>
            <div class="col colspan12">
              <div id="graph-container2" class="text-center" data-querystrings="<?php echo strstr($_SERVER["REQUEST_URI"], '?'); ?>" data-filter="<?php if(isset($_GET['rate-results'])) { echo $_GET['rate-results']; } else {'DTM';} ?>">
                  <noscript>Your browser must support JavaScript to view the data graph.</noscript>
              </div>
            </div>

            <span class="locations text-center"></span>
          </div><!--pane-->
        </div><!--graph1-->
    </div>
  </section>

  <section class="clearfix">
      <div class="container grid">

        <div class="col colspan6 clearfix" id="graph3" >
          <div class="pane clearfix">
            <div class="col colspan12 text-center">
              <h5>Height</h5>
            </div>
            <div class="col colspan12">
              <div id="graph-container3" class="text-center" data-querystrings="<?php echo strstr($_SERVER["REQUEST_URI"], '?'); ?>" data-filter="<?php if(isset($_GET['rate-results'])) { echo $_GET['rate-results']; } else {'Height';} ?>">
                  <noscript>Your browser must support JavaScript to view the data graph.</noscript>
              </div>
            </div>

            <span class="locations text-center"></span>
          </div><!--pane-->
        </div><!--graph1-->


          <div class="col colspan6" id="graph4" >
          <div class="pane clearfix">
             <div class="col colspan12 text-center">
              <h5>Lodging</h5>
            </div>
            <div class="col colspan12">
              <div id="graph-container4" class="text-center" data-querystrings="<?php echo strstr($_SERVER["REQUEST_URI"], '?'); ?>" data-filter="<?php if(isset($_GET['rate-results'])) { echo $_GET['rate-results']; } else {'Lodging';} ?>">
                  <noscript>Your browser must support JavaScript to view the data graph.</noscript>
              </div>
            </div>

            <span class="locations text-center"></span>
          </div><!--pane-->
        </div><!--graph1-->


        <div class="col colspan12 text-center">
        *SY4157, sponsored by Syngenta, was previously named 09H7757 and sponsored by Cargill in 2013.
        </div>

      </div>
    </section>

  <?php } ?>


  <Div id="data-table">
    <div class="container grid">
      <div class="col colspan12">
        <div class="pane clearfix">
          <header>
            <h3>Trial Result Data</h3>
          </header>
          <div class="col colspan12 table-container">
            
            <table id="data-output-table" class="table tablesorter">
              <thead>
                <tr>
                  <th class="variety-title" data-icon-after="s">Variety</th>
                  <th data-icon-after="s">Location</th>
                  <th data-icon-after="s">Year</th>
                  <th data-icon-after="s">Trial Type</th>
                  <th data-icon-after="s">Zone</th>
                  <th data-icon-after="s" class="td-right">Yield</th>
                  <th data-icon-after="s" class="td-right">DTM</th>
                  <th data-icon-after="s" class="td-right">Lodging</th>
                  <th data-icon-after="s" class="td-right">Height</th>
                  <th data-icon-after="s" class="td-right">Gross Revenue</th>
                </tr>
              </thead>
              <tbody>
                
              </tbody>
            </table>
          </div>
        </div>
      </div>
    </div>
  </div><!--data table-->


  <section id="map" style="height:650px;" >
    <div id="formanchor" class="container grid">

      <div class="col colspan12 map-container">
        <p class="text-center">Map pin placements are not exact locations. The pin placement is generated by Google Maps using the town name and province.</p>
        <p class="text-center"><strong>Map pins may take a few seconds to fully load.</strong></p>

        <div id="mapspot" class="dynamic-map-holder" style="height:500px;">

        </div><!--dynamic-map-holder-->

    <script>

      var delay = 100;
      var map;
      var infowindow;
      var geo; 
      var geocoder;
      var bounds;
      var addresses;
      var nextAddress = 0;

      function initMap() {
        
        map = new google.maps.Map(document.getElementById('mapspot'), {
           center: {lat: 56.1075958, lng: -107.3419402},
          zoom: 4
        });

        geocoder = new google.maps.Geocoder();
        infowindow = new google.maps.InfoWindow();
        bounds = new google.maps.LatLngBounds();
        
        addresses = [
            
        ];

        theNext();

      }


      // ====== Geocoding ======
      function getAddress(search, next) {geocoder.geocode({address:search}, function (results,status)
          { 
            // If that was successful
            if (status == google.maps.GeocoderStatus.OK) {
              // Lets assume that the first marker is the one we want
              var p = results[0].geometry.location;
              var lat=p.lat();
              var lng=p.lng();
              // Output the data
                //var msg = 'address="' + search + '" lat=' +lat+ ' lng=' +lng+ '(delay='+delay+'ms)<br>';
                //document.getElementById("messages").innerHTML += msg;
              // Create a marker
              createMarker(search,lat,lng);
            }
            // ====== Decode the error status ======
            else {
              // === if we were sending the requests to fast, try this one again and increase the delay
              if (status == google.maps.GeocoderStatus.OVER_QUERY_LIMIT) {
                nextAddress--;
                delay++;
              }   
            }
            next();
          }
        );
      }


      // ======= Function to create a marker
     function createMarker(add,lat,lng) {
       var contentString = add;
       var marker = new google.maps.Marker({
         position: new google.maps.LatLng(lat,lng),
         map: map,
         title: add
       });

       addressArray = add.split(',');

       var contentString = '<div id="content">'+
              '<div id="bodyContent">'+
              '<h5 style="font-size:16px;font-weight:normal;"><a href="/performance-trials?<?php echo $_SERVER['QUERY_STRING'];?>&town='+addressArray[0]+'&province='+addressArray[1]+'#formresults">'+
              addressArray[0]+', '+addressArray[1]+'</a></h5>'+
              '</div>'+
              '</div>';


      google.maps.event.addListener(marker, 'click', function() {
         infowindow.setContent(contentString); 
         infowindow.open(map,marker);
       });

       //bounds.extend(marker.position);
     }


      // ======= Function to call the next Geocode operation when the reply comes back

      function theNext() {
        if (nextAddress < addresses.length) {
          setTimeout('getAddress("'+addresses[nextAddress]+'",theNext)', delay);
          nextAddress++;
        } 
      }


    </script>

        <a href="/images/map-large.png" title="See full size map" target="_blank"><img src="/images/mini-map.png" class="mini-map" alt="Seasons"></a>

      </div>

      <div class="col colspan12 map-legend" style="display:none;">
        <div class="pane clearfix">
          <div class="col colspan3">
          </div><!--colspan-->
          <div class="col colspan3 pin pin-green">
            <span>Small Plot</span>
          </div><!--colspan-->
          <div class="col colspan3 pin pin-brown">
            <span>Field Scale</span>
          </div><!--colspan-->
          <div class="col colspan3">
          </div><!--colspan-->
        </div><!--pane-->
      </div>

    </div>
  </section>

  <script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyCs2ueUKSy4QKEcwKq_4jJ3IB15y3hDRFA&callback=initMap" async defer></script>

  
    <footer class="baseplate clearfix" >
    <div class="container grid">
      <div class="col colspan4 legal">
        Copyright &copy; 2023 Canola Council of Canada
      </div><!--colspan-->
      <div class="col colspan8">
        <a href="http://canolacouncil.org/" target="_blank"><img src="/images/canola-council.png"></a>
        <a href="http://www.mcgacanola.org/" target="_blank"><img src="/images/manitoba-canola.png"></a>
        <a href="http://www.saskcanola.com/" target="_blank"><img src="/images/sask-canola.png"></a>
        <a href="http://canola.ab.ca/" target="_blank"><img src="/images/albera-canola.png"></a>
        <a href="http://www.agr.gc.ca/" target="_blank"><img src="/images/agriculture-gov.png"></a>
      </div><!--colspan-->
    </div><!--grid-->
  </footer>
  
    <script src="/js/infobox.js" type="text/javascript"></script>
  

        <!--live site analytics-->
    <script>
      var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-46048426-1']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();
    </script>
  
  
    <script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyCs2ueUKSy4QKEcwKq_4jJ3IB15y3hDRFA&callback=initMap" async defer></script>
  

<script src="/js/main.js?v=1"></script>
  </body>
</html>