$value) {
$NATIONS[$i] = explode(",", $value);
$i++;
}
unset($value);
unset($read);
unset($format);
// ✖ CREATE ROUTE ARRAY
$cityFILE= "https://spreadsheets.google.com/tq?tqx=out:csv&key=0AvVUEHcmdLvAdDlZQXpEM2xjQzFUVm42TmhScldVOUE";
$read = file_get_contents($cityFILE);
$format = str_replace('"','',$read);
$cities = explode("\n", $format);
$i= 0;
foreach($cities as $key => $value) {
$ROUTE[$i] = explode(",", $value);
if ($ROUTE[$i][5] == 1 ) { $NATLIST[]=$ROUTE[$i][1]; }
$i++;
}
unset($value);
unset($read);
unset($format);
array_shift($ROUTE);
// ✖ CREATE MILES CONVERTER
function miles2kms($miles) {
$ratio = 1.609344;
$kms = $miles * $ratio;
return $kms;
}
// ✖ DECLARE VALUES
$LAND = $ROUTE[0][25];
$AIR = $ROUTE[0][26];
$SEA = $ROUTE[0][27];
$tHOTEL = $ROUTE[0][7];
$tHOSTL = $ROUTE[0][8];
$tFAMLY = $ROUTE[0][9];
$tSUBLT = $ROUTE[0][10];
$tCAMPS = $ROUTE[0][11];
$tCOUCH = $ROUTE[0][12];
$tBUSES = $ROUTE[0][13];
$tTRAIN = $ROUTE[0][14];
$tAUTOS = $ROUTE[0][15];
$tFERRY = $ROUTE[0][16];
$tPLANE = $ROUTE[0][17];
$tFOOD = $ROUTE[0][18];
$tBEER = $ROUTE[0][19];
$tSTAY = $ROUTE[0][20];
$tTRAV = $ROUTE[0][21];
$tMISC = $ROUTE[0][22];
$tCULT = $ROUTE[0][23];
$tVISA = $ROUTE[0][24];
$tTOTAL = $tFOOD+$tBEER+$tSTAY+$tTRAV+$tMISC+$tCULT+$tVISA;
$COUNTX = count($NATIONS);
$COUNTZ = count($ROUTE);
$NATLIST = array_unique($NATLIST);
$tNATIONS = count($NATLIST);
// ✖ CREATE VARIABLES
for ($i=0; $i<=$COUNTX; $i++)
{
${"t" . $NATIONS[$i][1]} = 0;
${"c" . $NATIONS[$i][1]} = 0;
${"v" . $NATIONS[$i][1]} = 0;
${"f" . $NATIONS[$i][1]} = 0;
${"h" . $NATIONS[$i][1]} = 0;
${"l" . $NATIONS[$i][1]} = 0;
${"o" . $NATIONS[$i][1]} = 0;
${"e" . $NATIONS[$i][1]} = 0;
}
// ✖ PARSE COUNTRIES
for ($i=0; $i<=$COUNTZ; $i++)
{
if ($ROUTE[$i][5] == 1)
{
// BY COUNTRY
${"t" . $ROUTE[$i][1]} += ($ROUTE[$i][7]+ $ROUTE[$i][8] + $ROUTE[$i][9] + $ROUTE[$i][10] + $ROUTE[$i][11] + $ROUTE[$i][12]);
${"c" . $ROUTE[$i][1]} += ($ROUTE[$i][18] + $ROUTE[$i][19] + $ROUTE[$i][20] + $ROUTE[$i][21] + $ROUTE[$i][22] + $ROUTE[$i][23]+ $ROUTE[$i][24]);
${"v" . $ROUTE[$i][1]} += $ROUTE[$i][24];
${"f" . $ROUTE[$i][1]} += $ROUTE[$i][18];
${"l" . $ROUTE[$i][1]} += $ROUTE[$i][21];
${"h" . $ROUTE[$i][1]} += $ROUTE[$i][20];
${"o" . $ROUTE[$i][1]} += $ROUTE[$i][24];
${"e" . $ROUTE[$i][1]} += $ROUTE[$i][23];
// BY REGION
${"t" . $ROUTE[$i][6]} += ($ROUTE[$i][7]+ $ROUTE[$i][8] + $ROUTE[$i][9] + $ROUTE[$i][10] + $ROUTE[$i][11] + $ROUTE[$i][12]);
${"c" . $ROUTE[$i][6]} += ($ROUTE[$i][18] + $ROUTE[$i][19] + $ROUTE[$i][20] + $ROUTE[$i][21] + $ROUTE[$i][22] + $ROUTE[$i][23]+ $ROUTE[$i][24]);
${"v" . $ROUTE[$i][6]} += $ROUTE[$i][24];
${"l" . $ROUTE[$i][6]} += $ROUTE[$i][21];
${"f" . $ROUTE[$i][6]} += $ROUTE[$i][18];
${"h" . $ROUTE[$i][6]} += $ROUTE[$i][20];
${"o" . $ROUTE[$i][6]} += $ROUTE[$i][24];
${"e" . $ROUTE[$i][6]} += $ROUTE[$i][23];
} //IF
} //FOR
?>
// Data is beautiful.
NUMBER OF DAYS TRAVELING | : | 0 |
NUMBER OF COUNTRIES VISITED | : | |
|
NUMBER OF DAYS PRIVATE HOUSE | : | |
NUMBER OF DAYS LOCAL FAMILIES | : | |
NUMBER OF DAYS IN HOTELS | : | |
NUMBER OF DAYS IN HOSTELS | : | |
NUMBER OF DAYS COUCHSURFING | : | |
NUMBER OF DAYS OVERNIGHT BUS | : | |
|
NUMBER OF LEGS BY BUS | : | |
NUMBER OF LEGS BY TRAIN | : | |
NUMBER OF LEGS BY CAR | : | |
NUMBER OF LEGS BY BOAT | : | |
NUMBER OF LEGS BY PLANE | : | |
|
TOTAL SPENT ON FOOD | : | $ |
TOTAL SPENT ON DRINKS | : | $ |
TOTAL SPENT ON TRAVEL | : | $ |
TOTAL SPENT ON HOUSING | : | $ |
TOTAL SPENT ON CULTURE/TOURS | : | $ |
TOTAL SPENT ON OTHER | : | $ |
TOTAL SPENT ON VISAS | : | $ |
|
RUNNING DAILY AVERAGE | : | 0 |
RUNNING MONTHLY AVERAGE | : | 0 |
RUNNING TOTAL (ENTIRE TRIP) | : | $ |
DISTANCE BREAKDOWN
DISTANCE TRAVELED |
MILES |
KILOMETERS |
BY LAND |
|
|
BY AIR |
|
|
BY SEA |
|
|
TOTAL DISTANCE |
|
|
|
|
|
|
|
AVG / DAY |
AVG / DAY |
|
|
TOTAL STAY |
TOTAL COST |
VISA |
ON FOOD |
ON HOUSING |
\n";
echo "
\n";
echo " | \n";
echo "".$NATIONS[$i][0]." | \n";
echo "" . ${"t" . $NATIONS[$i][1]} . " DAYS | \n";
echo "$" . round(${"c" . $NATIONS[$i][1]}) . " | \n";
echo "". $USD . ${"v" . $NATIONS[$i][1]} . " | \n";
if (${"t".$NATIONS[$i][1]} > 0) {
echo "$".round(${"f".$NATIONS[$i][1]}/${"t".$NATIONS[$i][1]},0)." | \n";
echo "$".round(${"h".$NATIONS[$i][1]}/${"t".$NATIONS[$i][1]},0)." | \n";
} else {
echo "$0 | \n";
echo "$0 | \n";
}
echo "
\n";
echo "\n\n";
}
if ($PANDA == 3) // IS REGION
{
echo "
\n";
echo "\n";
echo " | \n";
echo "" .$NATIONS[$i][0]. " | \n";
echo "" . ${"t" . $NATIONS[$i][1]} . " DAYS | \n";
echo "$" . round(${"c" . $NATIONS[$i][1]}) . " | \n";
echo "$" . ${"v" . $NATIONS[$i][1]} . " | \n";
if (${"t".$NATIONS[$i][1]} > 0) {
echo "$".round(${"f".$NATIONS[$i][1]}/${"t".$NATIONS[$i][1]},0)." | \n";
echo "$".round(${"h".$NATIONS[$i][1]}/${"t".$NATIONS[$i][1]},0)." | \n";
} else {
echo "$0 | \n";
echo "$0 | \n";
}
echo "
\n";
echo "
\n\n";
}
} // END FOR LOOP
?>