<?php
set_include_path('.');
include("functions.inc.php");
writeheader ();


  $today = date("d/m/Y");
  $want_date= $_POST['from'];
  $dateUF=strtotime($_POST['from']);
  $dateF=date("d-m-Y", $dateUF);
  $row = 0;
  $count = 1;

  //Extract the data from blubolt file
  $url="http://www.myvetmeds.co.uk/oversight/products/getProductStats?prescription=prescription&date=".$want_date;
  $handle = fopen($url,'r');
  $count=0;
  $num=0;
  //Convert date format: 22/06/2011 22:26 "d/m/Y H:m" to SQL format "Y-m-d"
  $header="FALSE";
  while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
	{
	if (isset($data[3]))
	{
		if ($header=="FALSE")
		{
		echo "<BR>Today is: ".$today." Data Below Refers to: ".$dateF."<BR>";
		echo"<form method='post' action='report_remote2.php'><table border='1' cellspacing='2' cellpadding='2' name='add' id='add'><tr>
		<td><font face='Arial, Helvetica, sans-serif'>First Name</font></th>
		<td><font face='Arial, Helvetica, sans-serif'>Last Name</font></th>
		<td><font face='Arial, Helvetica, sans-serif'>Order ID</font></th>
		<td><font face='Arial, Helvetica, sans-serif'>Product Name</font></th>
		<td><font face='Arial, Helvetica, sans-serif'>No Repeats</font></th>
		<td><font face='Arial, Helvetica, sans-serif'>Email Address</font></th>
		<td><font face='Arial, Helvetica, sans-serif'>Date of Next Order</font></th>
		<td><font face='Arial, Helvetica, sans-serif'>Pet Name</font></th>
		<td><font face='Arial, Helvetica, sans-serif'>Date of Order</font></th>
		<td><font face='Arial, Helvetica, sans-serif'>Confirm</font></th></tr>";
		$header="TRUE";
		}
		$count ++;
			$num ++;
		$aname = explode(" ", $data[3]);

			echo "
			<tr>
		<td><font face='Arial, Helvetica, sans-serif'><input name='FirstName$count'  type='text' id='FirstName$count' value='$aname[0]'></font></td>
		<td><font face='Arial, Helvetica, sans-serif'><input name='LastName$count'  type='text' id='LastName$count' value='$aname[1]'></font></td>
		<td><font face='Arial, Helvetica, sans-serif'><input name='OrderID$count' readonly='readonly' type='text' id='OrderID$count' value='$data[6]'></font></td>
		<td><font face='Arial, Helvetica, sans-serif'><input name='ProductName$count' readonly='readonly' type='text' id='ProductName$count' value='$data[1]'></font></td>
		<td><font face='Arial, Helvetica, sans-serif'><input name='Num_Repeats$count' type='text' value='1' id='Num_Repeats$count' size='3'></font></td>
		<td><font face='Arial, Helvetica, sans-serif'><input name='EmailAddress$count' readonly='readonly' type='text' id='EmailAddress$count' value='$data[4]'></font></td>
		<td><font face='Arial, Helvetica, sans-serif'><input name='ExpiryDate$count' type='date' id='ExpiryDate$count'  size='10' value='$want_date'></td></font></td>

		<td><font face='Arial, Helvetica, sans-serif'><input name='PetName$count' type='text' id='PetName$count' size='10'></td></font></td>
		<td><font face='Arial, Helvetica, sans-serif'><input name='OrderDate$count' type='date' readonly='readonly' id='OrderDate$count' value='$want_date' size='10'></td></font></td>



		<td><font face='Arial, Helvetica, sans-serif'><input name='ID$count' type='checkbox' id='ID$count' value='$count'></font></td>
		</tr>
		";


	}
	else
	{
	echo "<font color='red'>No data found!</font><BR><BR>";
	break;

  }
  fclose($handle);
  if ($header=="TRUE")
  {echo "</table><BR><BR><input name='numids' type='hidden' value='$count'><input name='processim' type='submit' id='processim' value='Confirm' ></form><BR>Rows: $count <BR>";}
  $validate = $count;
//use a loop for this

  echo "<script type='text/javascript'>$(document).ready(function() {";
  for ($thisvalidate = 1; $thisvalidate <= $validate; $thisvalidate++) {
  echo"

    $('#ID$thisvalidate').click(function() {
        if ($('#ID$thisvalidate').is(':checked')) {

		var FirstName$thisvalidate = new LiveValidation( 'FirstName$thisvalidate', {onlyOnSubmit: false } );
		FirstName$thisvalidate.add( Validate.Presence );
		var LastName$thisvalidate = new LiveValidation( 'LastName$thisvalidate', {onlyOnSubmit: false} );
		LastName$thisvalidate.add( Validate.Presence );
		var Num_Repeats$thisvalidate = new LiveValidation( 'Num_Repeats$thisvalidate', {onlyOnSubmit: false } );
		Num_Repeats$thisvalidate.add( Validate.Presence );
    		var ExpiryDate$thisvalidate = new LiveValidation( 'ExpiryDate$thisvalidate', {onlyOnSubmit: false } );
		ExpiryDate$thisvalidate.add( Validate.Presence );
		ExpiryDate$thisvalidate.add( Validate.Exclusion, { within: [ '$want_date' ] } );

   	}
    	else{
	FirstName$thisvalidate.disable();
	LastName$thisvalidate.disable();
	Num_Repeats$thisvalidate.disable();
	ExpiryDate$thisvalidate.disable();
    	}
    })

    ";

  //End of For Loop
  }
echo "});</script><script type='text/javascript'>

var automaticOnSubmit = FirstName1.form.onsubmit;
FirstName1.form.onsubmit = function(){
var valid = automaticOnSubmit();
if(valid)
{alert('The form is valid!'); document.getElementById('add').submit();
return false;          }
</script>";

if ($header=="TRUE")
	{
writefooter ();}
?>