On Sep 9, 4:27*pm, Iván Sánchez Ortega <ivansanchez-...@rroba-
escomposlinux.-.punto.-.orgwrote:
JRough wrote:
I agree with you. *Parse is a better word. *So I guess I have to use
string functions then?
No.
*load average: 0.14, 0.31,
0.34
---code----
$days = 3;
$TPL_carnumbers = "<table>";
if(empty($order _by)){
$order_by = 'sighting_date_ asc';
}
# GET CARS FOR GIVEN PARAMETER?
if(empty($id)){
$MSG_carlist = "IDLE CARS - NO MOVEMENT IN 3 DAYS";
$file_name = "idle_cars.php? ";
switch ($_SESSION["LMS_USER_D ESC"]){
case 'internal':
$headers = GetLeaseHeaders ($file_name);
$result = SELECT_idle_day s($days,CLM_ord er_by($order_by ));
$lease_row = true;
break;
case 'owner':
$headers = GetLeaseHeaders ($file_name);
$result = SELECT_idle_day s_owner($days,C LM_order_by($or der_by));
$lease_row = true;
break;
case 'customer':
$headers = GetHeaders($fil e_name);
$result = SELECT_idle_day s_customer($day s,CLM_order_by( $order_by));
$lease_row = false;
break;
default:
$headers = GetLeaseHeaders ($file_name);
$result = SELECT_idle_day s($days,CLM_ord er_by($order_by ));
$lease_row = true;
break;
}
}else{
$MSG_carlist = "IDLE CARS - NO MOVEMENT IN 3 DAYS
".GetLeaseCompN ame($id);
$file_name = "idle_cars.php? id=".$id."&";
switch ($_SESSION["LMS_USER_D ESC"]){
case 'internal':
$headers = GetHeaders($fil e_name);
$result = SELECT_idle_day s_lease($id,
$days,CLM_order _by($order_by)) ;
$lease_row = false;
break;
case 'owner':
$headers = GetHeaders($fil e_name);
$result = SELECT_idle_day s_lease_owner($ id,
$days,CLM_order _by($order_by)) ;
$lease_row = false;
break;
default:
$headers = GetHeaders($fil e_name);
$result = SELECT_idle_day s_lease($id,
$days,CLM_order _by($order_by)) ;
$lease_row = false;
break;
}
}
$TPL_carnumbers .= $headers;
if ($_POST['assign']!='Open in Excel'){
if(mysql_numrow s($result)==0){
$TPL_carnumbers .= GetNoCarsMsg($t h);
}else{
while ($row = mysql_fetch_ass oc($result)){
$TPL_carnumbers .=MakeSighting( $lease_row,$row );
}
}
$TPL_carnumbers .="</table>";
include "header.php ";
include $template_path. "template_carli st.html";
include "footer.php ";
print $headers;
}else{
# need code to output header, and data to Excel
$s1 = isset($_GET['order_by'])? $_GET['order_by'] : ''; # gives a ' '
result
}
include "footer.php ";
function GetHeaders($fil e_name){
return "<th><a href='".$file_n ame."&order_by= l_e'>L_E</a></th>
<th><a href='".$file_n ame."&order_by= carnumber'>Carn umber</a></th>
<th><a href='".$file_n ame."&order_by= location'>Locat ion</a></th>
<th><a href='".$file_n ame."&order_by= sighting_date_a sc'>Sighting
Date</a></th>
<th><a href='".$file_n ame."&order_by= classification' >Code</a></th>
<th><a href='".$file_n ame."&order_by= railroad'>RR</a></th>
<th><a href='".$file_n ame."order_by=o rigin'>Origin</a></th>
<th><a href='".$file_n ame."&order_by= destination'>De stination</a></
th>
<th width='15%'><a href='".$file_n ame."'>ETA</a></th>";
}
function GetLeaseHeaders ($file_name){
$lease_header = "<th><a href='".$file_n ame."order_by=l ease'>Lease</
a></th>";
return $lease_header.G etHeaders($file _name);
}