<?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 ();}
?>