\n");
//set table headings
echo("| " " | Commission | Colour | Engine Type | Owner | Homepage | Country | Location | |
|---|
\n");
$sql->Query("Select commnumber, paintcode, concat(eprefix, enumber, esufix) as 'engine', name, email, emailpvt, homepage, country, state,newpaint,stolen,forsale,updated,datestamp,etype,stagpic from stagdata where status <> 'deleted' order by $order");
// $sql->Query("Select commnumber, paintcode, concat(eprefix, enumber, esufix) as 'engine', name, email, emailpvt, homepage, country, state,newpaint,stolen,forsale,updated,datestamp,etype,stagpic from stagdata where status <> 'deleted'");
for ($i = 0; $i < $sql->rows; $i++) {
$sql->Fetch($i);
$commnumber = $sql->data[0];
$paintcode = $sql->data[1];
$engine = $sql->data[2];
$name = $sql->data[3];
$email = $sql->data[4];
$emailpvt = $sql->data[5];
$homepage = $sql->data[6];
$country = $sql->data[7];
$state = $sql->data[8];
$newpaint = $sql->data[9];
$stolen = $sql->data[10];
$forsale = $sql->data[11];
$updated = $sql->data[12];
$datestamp = $sql->data[13];
$etype = $sql->data[14];
$stagpic=$sql->data[15];
// Single selects to get paint description, full country name the full Commision number,engnum & type
$colour = $sql1->QueryItem("select description from stagdatatrimpaint where code = '$paintcode'");
$cnumfull = $sql1->QueryItem("select concat(comprefix, commnumber, comsufix) from stagdata where commnumber = $commnumber");
$engnum = $sql1->QueryItem("select enumber from stagdata where commnumber = $commnumber");
$engtype = $sql1->QueryItem("select etype from stagdata where commnumber = $commnumber");
$cname = $sql1->QueryItem("select countryname from stagdatacountry where countrycode = '$country'");
//set "new or updated" icon at front of table for new entries.
if ($datestamp > $date1 AND $datestamp == $updated) {
$icon ="
";
}else{
if ($updated > $date1 and $updated <> $datestamp) {
$icon ="
";
}else{
$icon ="";
}
}
//Set special colours for stolen new in 30 days and for sale in list.
$fontcolour ="color='#333333'";
if ($updated > $date1) {
$fontcolour ="color='#800080'";
}
if ($datestamp > $date1) {
$fontcolour ="color='#800080'";
}
if ("Yes" == $forsale) {
$fontcolour ="color='#0000FF'";
$icon ="
";
}
if ("Yes" == $stolen) {
$fontcolour ="color='#FF0000'";
$icon ="
";
}
if (""==$stagpic){
$stagpic1=" ";
}else{
$stagpic1="
";
// $stagpic1=urlencode($stagpic1);
}
//test if the current colour is the same as the original, if not display new colour
if ( $homepage == NULL) {
$homepage1=" ";
} else {
$homepage1=("Yes");
}
//test if there is text in the email field, if yes and the emailpvt field is no then the field is hyperlinked
if ( $email == NULL or "No" == $emailpvt) {
$name1="$name";
} else {
$name1=("$name");
}
//test to see if an engine number is given, if yes then that is output, if no data is taken from engine type
// if ( "Triumph V8" == $engtype ) {
// $eng1="$engine";
// } else {
// $eng1= "$engtype";
// }
// if ( "00000" == $engnum ) {
$eng1="$engtype";
// }
//test to see if data in field "newpaint" has been changed from "Same as Original"
//if it has we need to use the value from new paint for the colour
if ( "Same as Original" == $newpaint ) {
$paint="$colour";
} else {
$paint= "$newpaint";
}
//assemble each row of the table
//check row colour and alternate
if (1==$rowcolour){
$bgcolour="bgcolor='#FFFFFF' bordercolor='#FFFFFF'";
$rowcolour=0;
} else {
$bgcolour="bgcolor='#f4f4f4' bordercolor='$defaultbgcolour'";
$rowcolour=1;
}
echo("$icon | ");
echo("<$fontsize $fontcolour>$cnumfull | ");
echo("<$fontsize$>$paint | <$fontsize>$eng1 | <$fontsize>$name1 | $homepage1 | ");
echo("<$fontsize>$cname | <$fontsize>$state | $stagpic1 | \n");
}
echo("
\n");
?>
");
echo (" "Stolen" "ForSale" "New or Updated"