| '.mysql_field_name($s, 0).' | ';
for($i=1;$i<$fields;$i++){
if( $i==10)
$body_msg .=''.mysql_field_name($s, $i).' | ';
else
$body_msg .=''.mysql_field_name($s, $i).' | ';
}
$sum_column = array();
$sum_column[] = 0;
$sum_inaces = 0; //no. of terminals in ACeS Coverage
$irow = 0;
while ($row = mysql_fetch_assoc($s)) {
$body_msg .='
';
$irow++;
$ireset = 0;
/*
$act_check = array();
$act_check[] = 0;
$sum_sbdacct = array();
$sum_sbdacct[] = 0;
$sum_calls = array();
$sum_calls[] = 0;
$sum_minutes = array();
$sum_minutes[] = 0;
*/
foreach( $row as $value )
{
$makecall = $row['makecall'];
$phone_id = $row['phone_id'];
$sbdacct = $row['sbdacct'];
/*
$act_check[$irow] = 0;
if($ireset == 1) {
$i=0;
$phone_id=$value;
while ($act_check[$irow]== 0 && $i < $rowcount_phoneid ) {
$i++;
if($value == $act_phoneid[$i]){
if($act_flag[$i] == 'Act') $act_check[$irow] = 1;
$sum_sbdacct[$irow] = $act_sbdacct[$i];
$sum_calls[$irow] = $act_calls[$i];
$sum_minutes[$irow] = $act_minutes[$i];
// echo $rowcount_phoneid," ",$i," ",$irow," ",$act_check[$irow]," ",$act_calls[$i]," ",$act_minutes[$i]," ",";";
}
}
}
*/
// echo $rowcount_phoneid," ",$i," ",$act_check,";";
if($ireset == 3 && $value == ''){
$nvalue = 'N/A'; // Rank Desc
}else if($ireset == 5){
// $nvalue = $rowcount+1-$irow; // Rank Desc
$nvalue = number_format($value,0); // total distinct sbdacct 3 months back until yesterday
}else if($ireset == 6 ){ // calls
$nvalue = number_format($value,0); // total calls 3 months back until yesterday
}else if($ireset == 7 ){ //minutes
$nvalue = number_format($value,2); // total minutes 3 months back until yesterday
}else if($ireset == 10 ){ //minutes
// $nvalue = $rowcount+1-$irow; // Rank Desc
$nvalue = $irow; // Rank Desc
}else if($ireset == 11 && ($value == 'Y' || $value == '') ){ //IN ACeS=Y
$sum_inaces++; // count if in ACeS
if($value == '') $value = 'Y';
$nvalue = $value;
}else{
$nvalue = $value;
}
if(($irow%2)==0 ){
$body_msg .='| ';
if($nvalue == 'SOLD' | $makecall == 'Yes' ){
if( $makecall == 'Yes') $body_msg .= ' ';
else $body_msg .= ' ';
} else if($nvalue == 'N/A'){
$body_msg .= ' ';
} else if($nvalue == 'RENT') $body_msg .= ' ';
if($ireset == 9) { //Deep to location_hist
if($nvalue == '') $nvalue = 'Thailand';
$body_msg .= ' '.$nvalue.' ';
} else if($ireset == 11 && $nvalue=='N') { //IN ACeS Coverage
$body_msg .= ' '.$nvalue;
} else
if($ireset == 1) { //Deep to phone_id
$body_msg .= ' '.$nvalue.' ';
} else
$body_msg .= $nvalue.' | ';
}else{
$body_msg .=' ';
if($nvalue == 'SOLD' | $makecall == 'Yes' ){
if( $makecall == 'Yes') $body_msg .= ' ';
else $body_msg .= ' ';
} else if($nvalue == 'N/A'){
$body_msg .= ' ';
} else if($nvalue == 'RENT') $body_msg .= ' ';
if($ireset == 9) {//Deep to location_hist
$body_msg .= ' '.$nvalue.' ';
} else if($ireset == 11 && $nvalue=='N') { //IN ACeS Coverage
$body_msg .= ' '.$nvalue;
} else
if($ireset == 1) { //Deep to phone_id
$body_msg .= ' '.$nvalue.' ';
} else
$body_msg .= $nvalue.' | ';
}
$ireset++;
}
// $ireset=0;
} //while
$body_msg .= "
";
// mysql_close($link);
/*
// Sum value
$sum_column[0] = "Total";
for($i=0;$i<$fields;$i++){
if(($i >1) && ($i < 1)){
// if(($i ==1) || ($i == 2)|| ($i == 4)|| ($i == 5)|| ($i == 7)){
$body_msg .='| '.number_format($sum_column[$i],2).' | ';
}else{
if($i==0){
$body_msg .=''.$sum_column[0].' | ';
} else {
$body_msg .=' | ';
}
}
}
*/
$body_msg .='
';
//$body_msg .=' | '.mysql_field_name($s, 0).' | ';
// for($i=1;$i<$fields;$i++){
// $body_msg .=''.mysql_field_name($s, $i).' | ';
//
// };
$body_msg .='
';
///Summary by Location
$sql = "select '' as Total,sum(if(last_location like '%Thailand%',1,0)) AS InThailand,
sum(if(last_location not like '%Thailand%',1,0)) AS OutThailand,
'' as '%InThai' , '' as '%OutThai', '' as 'InACeS' , '' as 'OutACeS', '' as '%InACeS' , '' as '%OutACeS'
from sbdplus_map_ship a
WHERE firstusedate <> '' AND checkout_status <> 'RESERVED' and track_status_id=3
";
//where track_status_id=3 and phone_id <> 2299
$s = mysql_query($sql);
if ($s == 0)
{
die('Failed to query data to database: