sorry i did omit some lines thought my entire code would be to long. I have now posted my entire code. the variable in question is $profile. thanks again for the help.
Code: Select all
<?php
$method = $_REQUEST['method'];
$ive_waited = $_REQUEST['ive_waited'];
$address = $_REQUEST['address'];
$filename_A = $_REQUEST['filename_A'];
$filename_C = $_REQUEST['filename_C'];
$no_data = $_REQUEST['no_data'];
$profile = $_REQUEST['profile'];
$meter_num = $_REQUEST['meter_num'];
$start_month = $_REQUEST['start_month'];
$start_day = $_REQUEST['start_day'];
$start_year = $_REQUEST['start_year'];
$end_month = $_REQUEST['end_month'];
$end_day = $_REQUEST['end_day'];
$end_year = $_REQUEST['end_year'];
if( !isset( $method))
{
?>
<html>
<head>
<title>Test Meter Data Lookup</title>
<script language="javascript" type="text/javascript">
function check_form_one()
{
document.get_order.submit();
}
function check_form_two()
{
if( document.meter_num.meter_num.value == "")
{
alert("Meter Number(s) is a required field.");
document.meter_num.meter_num.focus();
return;
}
document.meter_num.submit();
}
function check_form_thr()
{
document.meter_date.submit();
}
</script>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload="javascript:document.get_order.profile.focus();">
<table width="1004" height="63" border="0" cellpadding="0" cellspacing="0">
<tr><td align="center"><font size="25">Test Meter Data Lookup</font></td></tr>
</table>
<table width="1004" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="20" width="5" background="images/all_strip.jpg" ></td>
<td height="20" width="637" background="images/all_strip.jpg" ></td>
</tr>
</table>
<br><br><br>
<form name="get_order" action="testmeterlookup.php" method="post">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<table width="300" border="0" cellpadding="1" cellspacing="0" background="images/all_border.jpg">
<tr>
<td align="center" valign="center">
<table height="100%" width="100%" border="0" cellpadding="4" cellspacing="0" background="images/all_orange.jpg">
<tr>
<td valign="center"><font size="4"><b>Test Profile: </b></font></td>
<td align="right">
<select name="profile" tabindex="1">
<?php
include( "dev_db.php");
$connection = mysqli_connect( $server, $user, $pass, "prover");
$query = "SELECT test_profile_id, profile_name FROM test_profiles ORDER BY profile_name";
$result = mysqli_query($connection, $query);
for( $x = 0; $row = mysqli_fetch_assoc( $result); $x++)
{
?>
<option value="<?php $row['test_profile_id']; ?>"><?php echo $row['profile_name']; ?></option>
<?php
}
mysqli_close( $connection);
?>
</select>
</td>
</tr>
<tr><td colspan="2"><br></td></tr>
<tr>
<td align="center" valign="center" colspan="2"><img height="20" width="128" border="0" src="images/btn_all_sbm.jpg" name="btn_sbm" onmouseover="javascript:document.btn_sbm.src = 'images/btn_all_sbm_ovr.jpg';" onmouseout="javascript:document.btn_sbm.src = 'images/btn_all_sbm.jpg';" onclick="javascript:check_form_one();"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<input type="hidden" name="method" value="0">
</form>
<br>
<form name="meter_num" action="testmeterlookup.php" method="post">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<table width="300" border="0" cellpadding="1" cellspacing="0" background="images/all_border.jpg">
<tr>
<td align="center" valign="center">
<table height="100%" width="100%" border="0" cellpadding="4" cellspacing="0" background="images/all_orange.jpg">
<tr>
<td align="center" valign="center" height="100%" colspan="2"><font size="4"><b>Meter Number(s): </b></font></td>
</tr>
<tr>
<td align="center" colspan="2"><textarea cols="33" rows="5" tabindex="5" name="meter_num"><?php if( isset( $meter_num)){ echo $meter_num; } ?></textarea></td>
</tr>
<tr><td colspan="2"><br></td></tr>
<tr>
<td align="center" valign="center" colspan="2"><img height="20" width="128" border="0" src="images/btn_all_sbm.jpg" name="btn_sbm2" onmouseover="javascript:document.btn_sbm2.src = 'images/btn_all_sbm_ovr.jpg';" onmouseout="javascript:document.btn_sbm2.src = 'images/btn_all_sbm.jpg';" onclick="javascript:check_form_two();"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<input type="hidden" name="method" value="1">
</form>
<br>
<form name="meter_date" action="testmeterlookup.php" method="post">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<table width="300" border="0" cellpadding="1" cellspacing="0" background="images/all_border.jpg">
<tr>
<td align="center" valign="center">
<table height="100%" width="100%" border="0" cellpadding="4" cellspacing="0" background="images/all_orange.jpg">
<tr>
<td valign="center"><font size="4"><b>Start Date: </b></font></td>
<td align="right" valign="center">
<select name="start_month" tabindex="7">
<?php
for( $x = 1; $x < 13; $x++)
{
?>
<option value="<?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?>"<?php if( isset( $start_month)){ if( $start_month == $x){ echo " selected"; } } else{ if( $x == date( "m")){ echo " selected"; } } ?>><?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?></option>
<?php
}
?>
</select>
/
<select name="start_day" tabindex="8">
<?php
for( $x = 1; $x < 32; $x++)
{
?>
<option value="<?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?>"<?php if( isset( $start_day)){ if( $start_day == $x){ echo " selected"; } } else{ if( $x == date( "d")){ echo " selected"; } } ?>><?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?></option>
<?php
}
?>
</select>
/
<select name="start_year" tabindex="9">
<?php
for( $x = 0; $x <= 12; $x++)
{
?>
<option value="<?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?>"<?php if( isset( $start_year)){ if( $start_year == $x){ echo " selected"; } } else{ if( $x == date( "y")){ echo " selected"; } } ?>>20<?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?></option>
<?php
}
?>
</select>
</td>
</tr>
<tr>
<td valign="center"><font size="4"><b>End Date: </b></font></td>
<td align="right" valign="center">
<select name="end_month" tabindex="10">
<?php
for( $x = 1; $x < 13; $x++)
{
?>
<option value="<?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?>"<?php if( isset( $end_month)){ if( $end_month == $x){ echo " selected"; } } else{ if( $x == date( "m")){ echo " selected"; } } ?>><?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?></option>
<?php
}
?>
</select>
/
<select name="end_day" tabindex="11">
<?php
for( $x = 1; $x < 32; $x++)
{
?>
<option value="<?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?>"<?php if( isset( $end_day)){ if( $end_day == $x){ echo " selected"; } } else{ if( $x == date( "d")){ echo " selected"; } } ?>><?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?></option>
<?php
}
?>
</select>
/
<select name="end_year" tabindex="12">
<?php
for( $x = 0; $x <= 12; $x++)
{
?>
<option value="<?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?>"<?php if( isset( $end_year)){ if( $end_year == $x){ echo " selected"; } } else{ if( $x == date( "y")){ echo " selected"; } } ?>>20<?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?></option>
<?php
}
?>
</select>
</td>
</tr>
<tr><td colspan="2"><br></td></tr>
<tr>
<td align="center" valign="center" colspan="2"><img height="20" width="128" border="0" src="images/btn_all_sbm.jpg" name="btn_sbm3" onmouseover="javascript:document.btn_sbm3.src = 'images/btn_all_sbm_ovr.jpg';" onmouseout="javascript:document.btn_sbm3.src = 'images/btn_all_sbm.jpg';" onclick="javascript:check_form_thr();"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<input type="hidden" name="method" value="2">
</form>
<br>
</body>
</html>
<?php
exit();
}
if( !isset( $ive_waited))
{
?>
<html>
<head>
<title>Test Meter Data Lookup</title>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload="javascript:document.waiting.submit();">
<table width="1004" height="63" border="0" cellpadding="0" cellspacing="0">
<tr><td align="center"><font size="25">Test Meter Data Lookup</font></td></tr>
</table>
<table width="1004" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="20" width="5" background="images/all_strip.jpg" ></td>
<td height="20" width="637" background="images/all_strip.jpg" ></td>
</tr>
</table>
<br><br><br>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<table border="0" cellpadding="1" cellspacing="0" background="images/all_border.jpg">
<tr>
<td align="center" valign="center">
<table height="100%" width="100%" border="0" cellpadding="4" cellspacing="0" background="images/all_orange.jpg">
<tr>
<td align="center" valign="center"><br><b>Please Wait...<b><br><br><b>Depending on the number of meters in your<br>query this process could take several minutes.</b><br><br></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<form name="waiting" action="testmeterlookup.php" method="post">
<input type="hidden" name="ive_waited" value="1">
<input type="hidden" name="method" value="<?php echo $method; ?>">
<?php
if( isset( $meter_num))
{
?>
<input type="hidden" name="meter_num" value="<?php echo $meter_num; ?>">
<?php
}
else if( isset( $profile))
{
?>
<input type="hidden" name="profile" value="<?php echo strtoupper( $profile); ?>">
<?php
}
else
{
?>
<input type="hidden" name="start_month" value="<?php echo $start_month; ?>">
<input type="hidden" name="start_day" value="<?php echo $start_day; ?>">
<input type="hidden" name="start_year" value="<?php echo $start_year; ?>">
<input type="hidden" name="end_month" value="<?php echo $end_month; ?>">
<input type="hidden" name="end_day" value="<?php echo $end_day; ?>">
<input type="hidden" name="end_year" value="<?php echo $end_year; ?>">
<?php
}
?>
</form>
</body>
</html>
<?php
exit();
}
if( $method == 1 && !isset( $filename_A))
{
$no_data = 1;
$filename_A = 'MeterData_' . date( "His") . '.tmp';
$string_position = 0;
$string_length = strlen( $meter_num);
$meter_numbers[0] = "NA";
for( $x = 0; FALSE !== ($string_position = strpos( $meter_num, "20", $string_position)); $x++)
{
$possible_meter_number = substr( $meter_num, $string_position, 10);
if( is_numeric( $possible_meter_number))
{
$meter_numbers[$x] = $possible_meter_number;
$string_position += 10;
}
else
{
$string_position++;
$x--;
}
}
if( $meter_numbers[0] != "NA")
{
include( "dev_db.php");
$connection = mysqli_connect( $server, $user, $pass, "prover");
$fpA = fopen( $filename_A, 'w');
fputs( $fpA, "Prover Number, Test Meter Number, Test Profile ID, Test Type, Open Pass/Fail, Check Pass/Fail, Qmin Pass/Fail, Test Block, Temp Cont, Test Date, Test Time, Open 1, Open Diff. 1, Check 1, Check Diff. 1, Qmin 1, Qmin Diff. 1, Open 2, Open Diff. 2, Check 2, Check Diff. 2, Qmin 2, Qmin Diff. 2, Open 3, Open Diff. 3, Check 3, Check Diff. 3, Qmin 3, Qmin Diff. 3\n");
for( $x = 0; $x < count( $meter_numbers); $x++)
{
unset( $meter_data);
$query = "SELECT test_meter_out.prover_num, test_meter_out.test_meter_num, test_profiles.profile_name, test_meter_out.test_type, test_meter_out.pass_fail_open, test_meter_out.pass_fail_check, test_meter_out.pass_fail_qmin, test_meter_out.test_block, test_meter_out.temp_cont, test_meter_out.test_date, test_meter_out.test_time, test_meter_out.open_1, test_meter_out.open_diff_1, test_meter_out.check_1, test_meter_out.check_diff_1, test_meter_out.qmin_1, test_meter_out.qmin_diff_1, test_meter_out.open_2, test_meter_out.open_diff_2, test_meter_out.check_2, test_meter_out.check_diff_2, test_meter_out.qmin_2, test_meter_out.qmin_diff_2, test_meter_out.open_3, test_meter_out.open_diff_3, test_meter_out.check_3, test_meter_out.check_diff_3, test_meter_out.qmin_3, test_meter_out.qmin_diff_3 FROM prover.test_meter_out, prover.test_profiles WHERE test_meter_out.test_profile_id = test_profiles.test_profile_id and test_meter_out.test_meter_num = '" . $meter_numbers[$x] . "' ORDER BY test_meter_out.test_meter_out_id";
$result = mysqli_query($connection, $query);
if( mysqli_num_rows( $result) > 0)
{
for( $y = 0; $row = mysqli_fetch_assoc( $result); $y++)
{
$meter_data[$y]['prover_num'] = $row['prover_num'];
$meter_data[$y]['test_meter_num'] = $row['test_meter_num'];
$meter_data[$y]['profile_name'] = $row['profile_name'];
$meter_data[$y]['test_type'] = $row['test_type'];
$meter_data[$y]['pass_fail_open'] = $row['pass_fail_open'];
$meter_data[$y]['pass_fail_check'] = $row['pass_fail_check'];
$meter_data[$y]['pass_fail_qmin'] = $row['pass_fail_qmin'];
$meter_data[$y]['test_block'] = $row['test_block'];
$meter_data[$y]['temp_cont'] = $row['temp_cont'];
$meter_data[$y]['test_date'] = $row['test_date'];
$meter_data[$y]['test_time'] = $row['test_time'];
$meter_data[$y]['open_1'] = $row['open_1'];
$meter_data[$y]['open_diff_1'] = $row['open_diff_1'];
$meter_data[$y]['check_1'] = $row['check_1'];
$meter_data[$y]['check_diff_1'] = $row['check_diff_1'];
$meter_data[$y]['qmin_1'] = $row['qmin_1'];
$meter_data[$y]['qmin_diff_1'] = $row['qmin_diff_1'];
$meter_data[$y]['open_2'] = $row['open_2'];
$meter_data[$y]['open_diff_2'] = $row['open_diff_2'];
$meter_data[$y]['check_2'] = $row['check_2'];
$meter_data[$y]['check_diff_2'] = $row['check_diff_2'];
$meter_data[$y]['qmin_2'] = $row['qmin_2'];
$meter_data[$y]['qmin_diff_2'] = $row['qmin_diff_2'];
$meter_data[$y]['open_3'] = $row['open_3'];
$meter_data[$y]['open_diff_3'] = $row['open_diff_3'];
$meter_data[$y]['check_3'] = $row['check_3'];
$meter_data[$y]['check_diff_3'] = $row['check_diff_3'];
$meter_data[$y]['qmin_3'] = $row['qmin_3'];
$meter_data[$y]['qmin_diff_3'] = $row['qmin_diff_3'];
}
$total_meter_data = count( $meter_data);
$no_data = 0;
for( $y = 0; $y < $total_meter_data; $y++)
{
fputs( $fpA, $meter_data[$y]['prover_num'] . ", " . $meter_data[$y]['test_meter_num'] . ", " . $meter_data[$y]['profile_name'] . ", " . $meter_data[$y]['test_type'] . ", " .$meter_data[$y]['pass_fail_open'] . ", " .$meter_data[$y]['pass_fail_check'] . ", " .$meter_data[$y]['pass_fail_qmin'] . ", " . $meter_data[$y]['test_block'] . ", " . $meter_data[$y]['temp_cont'] . ", " . $meter_data[$y]['test_date'] . ", " . $meter_data[$y]['test_time'] . ", " . $meter_data[$y]['open_1'] . ", " . $meter_data[$y]['open_diff_1'] . ", " . $meter_data[$y]['check_1'] . ", " . $meter_data[$y]['check_diff_1'] . ", " . $meter_data[$y]['qmin_1'] . ", " . $meter_data[$y]['qmin_diff_1'] . ", " .$meter_data[$y]['open_2'] . ", " .$meter_data[$y]['open_diff_2'] . ", " .$meter_data[$y]['check_2'] . ", " . $meter_data[$y]['check_diff_2'] . ", " . $meter_data[$y]['qmin_2'] . ", " . $meter_data[$y]['qmin_diff_2'] . ", " . $meter_data[$y]['open_3'] . ", " . $meter_data[$y]['open_diff_3'] . ", " . $meter_data[$y]['check_3'] . ", " . $meter_data[$y]['check_diff_3'] . ", " . $meter_data[$y]['qmin_3'] . ", " . $meter_data[$y]['qmin_diff_3'] . "\n");
}
}//if
}//for
fclose( $fpA);
if( mysqli_num_rows( $result) < 1)
{
mysqli_close( $connection);
?>
<html>
<head>
<title>Proof Layout - San Diego</title>
<script language="javascript" type="text/javascript">
function error()
{
alert("No Data Found For Your Result.\nPlease try again.");
window.location = 'testmeterlookup.php';
}
</script>
</head>
<body onload="javascript:error();"></body>
</html>
<?php
exit();
}
mysqli_close( $connection);
}
else
{
?>
<html>
<head>
<title>Test Meter Data Lookup</title>
<script language="javascript" type="text/javascript">
function error()
{
alert("The meter number(s) you entered are not valid.\nPlease try again.");
document.bad.submit();
}
</script>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload="javascript:error();">
<table width="1004" height="63" border="0" cellpadding="0" cellspacing="0">
<tr><td align="center"><font size="25">Test Meter Data Lookup</font></td></tr>
</table>
<table width="1004" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="20" width="5" background="images/all_strip.jpg" ></td>
<td height="20" width="637" background="images/all_strip.jpg" ></td>
</tr>
</table>
<form name="bad" action="testmeterlookup.php" method="post">
<input type="hidden" name="meter_num" value="<?php echo $meter_num; ?>">
</form>
</body>
</html>
<?php
exit();
}
}
else if( $method == 0 && !isset( $filename_A))//Test Profile
{
include( "dev_db.php");
$connection = mysqli_connect( $server, $user, $pass, "prover");
$filename_A = 'MeterData_' . date( "His") . '.tmp';
$fpA = fopen( $filename_A, 'w');
fputs( $fpA, "Prover Number, Test Meter Number, Test Profile ID, Test Type, Open Pass/Fail, Check Pass/Fail, Qmin Pass/Fail, Test Block, Temp Cont, Test Date, Test Time, Open 1, Open Diff. 1, Check 1, Check Diff. 1, Qmin 1, Qmin Diff. 1, Open 2, Open Diff. 2, Check 2, Check Diff. 2, Qmin 2, Qmin Diff. 2, Open 3, Open Diff. 3, Check 3, Check Diff. 3, Qmin 3, Qmin Diff. 3\n");
//$no_data = 1;
$query = "SELECT test_meter_out.prover_num, test_meter_out.test_meter_num, test_profiles.profile_name, test_meter_out.test_type, test_meter_out.pass_fail_open, test_meter_out.pass_fail_check, test_meter_out.pass_fail_qmin, test_meter_out.test_block, test_meter_out.temp_cont, test_meter_out.test_date, test_meter_out.test_time, test_meter_out.open_1, test_meter_out.open_diff_1, test_meter_out.check_1, test_meter_out.check_diff_1, test_meter_out.qmin_1, test_meter_out.qmin_diff_1, test_meter_out.open_2, test_meter_out.open_diff_2, test_meter_out.check_2, test_meter_out.check_diff_2, test_meter_out.qmin_2, test_meter_out.qmin_diff_2, test_meter_out.open_3, test_meter_out.open_diff_3, test_meter_out.check_3, test_meter_out.check_diff_3, test_meter_out.qmin_3, test_meter_out.qmin_diff_3 FROM prover.test_meter_out, prover.test_profiles WHERE test_meter_out.test_profile_id = test_profiles.test_profile_id and test_meter_out.test_profile_id = '" . $profile . "' ORDER BY test_meter_out.test_meter_out_id";
$result = mysqli_query($connection, $query);
if( mysqli_num_rows( $result) > 0)
{
for( $y = 0; $row = mysqli_fetch_assoc( $result); $y++)
{
$meter_data[$y]['prover_num'] = $row['prover_num'];
$meter_data[$y]['test_meter_num'] = $row['test_meter_num'];
$meter_data[$y]['profile_name'] = $row['profile_name'];
$meter_data[$y]['test_type'] = $row['test_type'];
$meter_data[$y]['pass_fail_open'] = $row['pass_fail_open'];
$meter_data[$y]['pass_fail_check'] = $row['pass_fail_check'];
$meter_data[$y]['pass_fail_qmin'] = $row['pass_fail_qmin'];
$meter_data[$y]['test_block'] = $row['test_block'];
$meter_data[$y]['temp_cont'] = $row['temp_cont'];
$meter_data[$y]['test_date'] = $row['test_date'];
$meter_data[$y]['test_time'] = $row['test_time'];
$meter_data[$y]['open_1'] = $row['open_1'];
$meter_data[$y]['open_diff_1'] = $row['open_diff_1'];
$meter_data[$y]['check_1'] = $row['check_1'];
$meter_data[$y]['check_diff_1'] = $row['check_diff_1'];
$meter_data[$y]['qmin_1'] = $row['qmin_1'];
$meter_data[$y]['qmin_diff_1'] = $row['qmin_diff_1'];
$meter_data[$y]['open_2'] = $row['open_2'];
$meter_data[$y]['open_diff_2'] = $row['open_diff_2'];
$meter_data[$y]['check_2'] = $row['check_2'];
$meter_data[$y]['check_diff_2'] = $row['check_diff_2'];
$meter_data[$y]['qmin_2'] = $row['qmin_2'];
$meter_data[$y]['qmin_diff_2'] = $row['qmin_diff_2'];
$meter_data[$y]['open_3'] = $row['open_3'];
$meter_data[$y]['open_diff_3'] = $row['open_diff_3'];
$meter_data[$y]['check_3'] = $row['check_3'];
$meter_data[$y]['check_diff_3'] = $row['check_diff_3'];
$meter_data[$y]['qmin_3'] = $row['qmin_3'];
$meter_data[$y]['qmin_diff_3'] = $row['qmin_diff_3'];
}
$total_meter_data = count( $meter_data);
$no_data = 0;
for( $y = 0; $y < $total_meter_data; $y++)
{
fputs( $fpA, $meter_data[$y]['prover_num'] . ", " . $meter_data[$y]['test_meter_num'] . ", " . $meter_data[$y]['profile_name'] . ", " . $meter_data[$y]['test_type'] . ", " .$meter_data[$y]['pass_fail_open'] . ", " .$meter_data[$y]['pass_fail_check'] . ", " .$meter_data[$y]['pass_fail_qmin'] . ", " . $meter_data[$y]['test_block'] . ", " . $meter_data[$y]['temp_cont'] . ", " . $meter_data[$y]['test_date'] . ", " . $meter_data[$y]['test_time'] . ", " . $meter_data[$y]['open_1'] . ", " . $meter_data[$y]['open_diff_1'] . ", " . $meter_data[$y]['check_1'] . ", " . $meter_data[$y]['check_diff_1'] . ", " . $meter_data[$y]['qmin_1'] . ", " . $meter_data[$y]['qmin_diff_1'] . ", " .$meter_data[$y]['open_2'] . ", " .$meter_data[$y]['open_diff_2'] . ", " .$meter_data[$y]['check_2'] . ", " . $meter_data[$y]['check_diff_2'] . ", " . $meter_data[$y]['qmin_2'] . ", " . $meter_data[$y]['qmin_diff_2'] . ", " . $meter_data[$y]['open_3'] . ", " . $meter_data[$y]['open_diff_3'] . ", " . $meter_data[$y]['check_3'] . ", " . $meter_data[$y]['check_diff_3'] . ", " . $meter_data[$y]['qmin_3'] . ", " . $meter_data[$y]['qmin_diff_3'] . "\n");
}
}//if
fclose( $fpA);
if( mysqli_num_rows( $result) < 1)
{
mysqli_close( $connection);
?>
<html>
<head>
<title>Test Meter Lookup</title>
<script language="javascript" type="text/javascript">
function error()
{
alert("No Data Found For Your Result.\nPlease try again.");
window.location = 'testmeterlookup.php';
}
</script>
</head>
<body onload="javascript:error();"></body>
</html>
<?php
exit();
}
mysqli_close( $connection);
}
else if( $method == 2 && !isset( $filename_A))//Date Range *****************************************************************
{
include( "dev_db.php");
$connection = mysqli_connect( $server, $user, $pass, "prover");
$filename_A = 'MeterData_' . date( "His") . '.tmp';
$fpA = fopen( $filename_A, 'w');
fputs( $fpA, "Prover Number, Test Meter Number, Test Profile ID, Test Type, Open Pass/Fail, Check Pass/Fail, Qmin Pass/Fail, Test Block, Temp Cont, Test Date, Test Time, Open 1, Open Diff. 1, Check 1, Check Diff. 1, Qmin 1, Qmin Diff. 1, Open 2, Open Diff. 2, Check 2, Check Diff. 2, Qmin 2, Qmin Diff. 2, Open 3, Open Diff. 3, Check 3, Check Diff. 3, Qmin 3, Qmin Diff. 3\n");
//$no_data = 1;
$query = "SELECT test_meter_out.prover_num, test_meter_out.test_meter_num, test_profiles.profile_name, test_meter_out.test_type, test_meter_out.pass_fail_open, test_meter_out.pass_fail_check, test_meter_out.pass_fail_qmin, test_meter_out.test_block, test_meter_out.temp_cont, test_meter_out.test_date, test_meter_out.test_time, test_meter_out.open_1, test_meter_out.open_diff_1, test_meter_out.check_1, test_meter_out.check_diff_1, test_meter_out.qmin_1, test_meter_out.qmin_diff_1, test_meter_out.open_2, test_meter_out.open_diff_2, test_meter_out.check_2, test_meter_out.check_diff_2, test_meter_out.qmin_2, test_meter_out.qmin_diff_2, test_meter_out.open_3, test_meter_out.open_diff_3, test_meter_out.check_3, test_meter_out.check_diff_3, test_meter_out.qmin_3, test_meter_out.qmin_diff_3 FROM prover.test_meter_out, prover.test_profiles WHERE test_meter_out.test_profile_id = test_profiles.test_profile_id and test_meter_out.test_date >= '" . $start_year . "-" . $start_month . "-" . $start_day . "' AND test_meter_out.test_date <= '" . $end_year . "-" . $end_month . "-" . $end_day . "' ORDER BY test_meter_out.test_meter_out_id";
$result = mysqli_query($connection, $query);
if( mysqli_num_rows( $result) > 0)
{
for( $y = 0; $row = mysqli_fetch_assoc( $result); $y++)
{
$meter_data[$y]['prover_num'] = $row['prover_num'];
$meter_data[$y]['test_meter_num'] = $row['test_meter_num'];
$meter_data[$y]['profile_name'] = $row['profile_name'];
$meter_data[$y]['test_type'] = $row['test_type'];
$meter_data[$y]['pass_fail_open'] = $row['pass_fail_open'];
$meter_data[$y]['pass_fail_check'] = $row['pass_fail_check'];
$meter_data[$y]['pass_fail_qmin'] = $row['pass_fail_qmin'];
$meter_data[$y]['test_block'] = $row['test_block'];
$meter_data[$y]['temp_cont'] = $row['temp_cont'];
$meter_data[$y]['test_date'] = $row['test_date'];
$meter_data[$y]['test_time'] = $row['test_time'];
$meter_data[$y]['open_1'] = $row['open_1'];
$meter_data[$y]['open_diff_1'] = $row['open_diff_1'];
$meter_data[$y]['check_1'] = $row['check_1'];
$meter_data[$y]['check_diff_1'] = $row['check_diff_1'];
$meter_data[$y]['qmin_1'] = $row['qmin_1'];
$meter_data[$y]['qmin_diff_1'] = $row['qmin_diff_1'];
$meter_data[$y]['open_2'] = $row['open_2'];
$meter_data[$y]['open_diff_2'] = $row['open_diff_2'];
$meter_data[$y]['check_2'] = $row['check_2'];
$meter_data[$y]['check_diff_2'] = $row['check_diff_2'];
$meter_data[$y]['qmin_2'] = $row['qmin_2'];
$meter_data[$y]['qmin_diff_2'] = $row['qmin_diff_2'];
$meter_data[$y]['open_3'] = $row['open_3'];
$meter_data[$y]['open_diff_3'] = $row['open_diff_3'];
$meter_data[$y]['check_3'] = $row['check_3'];
$meter_data[$y]['check_diff_3'] = $row['check_diff_3'];
$meter_data[$y]['qmin_3'] = $row['qmin_3'];
$meter_data[$y]['qmin_diff_3'] = $row['qmin_diff_3'];
}
$total_meter_data = count( $meter_data);
$no_data = 0;
for( $y = 0; $y < $total_meter_data; $y++)
{
fputs( $fpA, $meter_data[$y]['prover_num'] . ", " . $meter_data[$y]['test_meter_num'] . ", " . $meter_data[$y]['profile_name'] . ", " . $meter_data[$y]['test_type'] . ", " .$meter_data[$y]['pass_fail_open'] . ", " .$meter_data[$y]['pass_fail_check'] . ", " .$meter_data[$y]['pass_fail_qmin'] . ", " . $meter_data[$y]['test_block'] . ", " . $meter_data[$y]['temp_cont'] . ", " . $meter_data[$y]['test_date'] . ", " . $meter_data[$y]['test_time'] . ", " . $meter_data[$y]['open_1'] . ", " . $meter_data[$y]['open_diff_1'] . ", " . $meter_data[$y]['check_1'] . ", " . $meter_data[$y]['check_diff_1'] . ", " . $meter_data[$y]['qmin_1'] . ", " . $meter_data[$y]['qmin_diff_1'] . ", " .$meter_data[$y]['open_2'] . ", " .$meter_data[$y]['open_diff_2'] . ", " .$meter_data[$y]['check_2'] . ", " . $meter_data[$y]['check_diff_2'] . ", " . $meter_data[$y]['qmin_2'] . ", " . $meter_data[$y]['qmin_diff_2'] . ", " . $meter_data[$y]['open_3'] . ", " . $meter_data[$y]['open_diff_3'] . ", " . $meter_data[$y]['check_3'] . ", " . $meter_data[$y]['check_diff_3'] . ", " . $meter_data[$y]['qmin_3'] . ", " . $meter_data[$y]['qmin_diff_3'] . "\n");
}
}//if
fclose( $fpA);
if( mysqli_num_rows( $result) < 1)
{
mysqli_close( $connection);
?>
<html>
<head>
<title>Test Meter Lookup</title>
<script language="javascript" type="text/javascript">
function error()
{
alert("No Data Found For Your Result.\nPlease try again.");
window.location = 'testmeterlookup.php';
}
</script>
</head>
<body onload="javascript:error();"></body>
</html>
<?php
exit();
}
mysqli_close( $connection);
}
if( !isset( $address))
{
?>
<html>
<head>
<title>Test Meter Data Lookup</title>
<script language="javascript" type="text/javascript">
function check_form_one()
{
if( document.get_email.address.value == "")
{
alert("Email Address is a required field.");
document.get_email.address.focus();
return;
}
document.get_email.submit();
}
</script>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload="javascript:document.get_email.address.focus();">
<table width="1004" height="63" border="0" cellpadding="0" cellspacing="0">
<tr><td align="center"><font size="25">Test Meter Data Lookup</font></td></tr>
</table>
<table width="1004" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="20" width="5" background="images/all_strip.jpg" ></td>
<td height="20" width="637" background="images/all_strip.jpg" ></td>
</tr>
</table>
<br><br><br>
<form name="get_email" action="testmeterlookup.php" method="post">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<table border="0" cellpadding="1" cellspacing="0" background="images/all_border.jpg">
<tr>
<td align="center" valign="center">
<table height="100%" width="100%" border="0" cellpadding="4" cellspacing="0" background="images/all_orange.jpg">
<tr>
<td valign="center"><b>Email Address: </b></td>
<td align="center"><input type="text" tabindex="1" name="address" size="20"><b>@itron.com</b></td>
</tr>
<tr><td><b>Example: joe.smith@itron.com</td></tr>
<tr><td colspan="2"><br></td></tr>
<tr>
<td align="center" valign="center" colspan="2"><img height="20" width="128" border="0" src="images/btn_all_sbm.jpg" name="btn_sbm" onmouseover="javascript:document.btn_sbm.src = 'images/btn_all_sbm_ovr.jpg';" onmouseout="javascript:document.btn_sbm.src = 'images/btn_all_sbm.jpg';" onclick="javascript:check_form_one();"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<input type="hidden" name="ive_waited" value="1">
<input type="hidden" name="method" value="<?php echo $method; ?>">
<input type="hidden" name="filename_A" value="<?php echo $filename_A; ?>">
<input type="hidden" name="no_data" value="<?php echo $no_data; ?>">
</form>
</body>
</html>
<?php
exit();
}
else
{
$address .= "@itron.com";
$email_txt = "";
if( $no_data == 1)
{
$email_txt = "No Data Retrieved From Database.";
}
$semi_rand = md5(time());
$headers = "From: no-reply@itron.com";
$headers .= "\nMIME-Version: 1.0\n";
$headers .= "Content-Type: multipart/mixed;\n";
$headers .= " boundary=\"==Multipart_Boundary_x" . $semi_rand . "x\"";
$email_message = "This is a multi-part message in MIME format.\n\n";
$email_message .= "--==Multipart_Boundary_x" . $semi_rand . "x\n";
$email_message .= "Content-Type:text/html; charset=\"iso-8859-1\"\n";
$email_message .= "Content-Transfer-Encoding: 7bit\n\n" . $email_txt . "\n\n";
if( $no_data == 1)
{
$email_message .= "--==Multipart_Boundary_x" . $semi_rand . "x--\n";
}
else
{
$email_message .= "--==Multipart_Boundary_x" . $semi_rand . "x\n";
}
if( $no_data == 0)
{
$fp = fopen( $filename_A, 'rb');
$data = fread( $fp, filesize( $filename_A));
fclose( $fp);
$data = chunk_split( base64_encode( $data));
$email_message .= "Content-Type: application/octet-stream;\n";
$email_message .= " name=\"TestMeterData.csv\"\n";
$email_message .= "Content-Transfer-Encoding: base64\n\n" . $data . "\n\n";
$email_message .= "--==Multipart_Boundary_x" . $semi_rand . "x--\n";
}
mail( $address, "Meter Data", $email_message, $headers);
unlink( $filename_A);
?>
<html>
<head>
<title>Test Meter Data Lookup</title>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="1004" height="63" border="0" cellpadding="0" cellspacing="0">
<tr><td align="center"><font size="25">Test Meter Data Lookup</font></td></tr>
</table>
<table width="1004" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="20" width="5" background="images/all_strip.jpg" ></td>
<td height="20" width="637" background="images/all_strip.jpg" ></td>
</tr>
</table>
<br><br><br>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<table border="0" cellpadding="1" cellspacing="0" background="images/all_border.jpg">
<tr>
<td align="center" valign="center">
<table height="100%" width="100%" border="0" cellpadding="4" cellspacing="0" background="images/all_orange.jpg">
<tr>
<td align="center" valign="center"><br><b>Meter Data has been emailed to: <?php echo $address; ?></b><br><br></td>
</tr>
<tr>
<td align="center"><img height="20" width="128" border="0" src="images/btn_prf_cnt.jpg" name="btn_cnt" onmouseover="javascript:document.btn_cnt.src = 'images/btn_prf_cnt_ovr.jpg';" onmouseout="javascript:document.btn_cnt.src = 'images/btn_prf_cnt.jpg';" onclick="javascript:window.location = 'testmeterlookup.php';"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
<?php
}
?>