the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program. If not, see <http://www.gnu.org/licenses/>.
******************************************************************************************/
$locs = array();
$list = '<script type="text/javascript">!window.jQuery && document.write(\'<script src="jquery/jquery-1.4.3.min.js"><\\/script>\');';
$dbconn = new DBConn();
$res = $dbconn->query("SELECT pid, name FROM place", array());
if ($res) {
while (($row = $resultset->fetch()) != false) {
$locs[] = "{$row[1]} ({$row[0]})";
}
$list .= '<!-- $(function () { $(\'#f, #t\').tagSuggest({ tags: ["' . implode('","', $locs) . '"] }); }); //-->';
}
$list .= '</script>';
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Bus Route Finder</title>
<link rel="stylesheet" href="style.css" type="text/css" charset="utf-8" />
<link href="img/bus.ico" rel="icon" type="image/vnd.microsoft.icon"/>
<link href='http://fonts.googleapis.com/css?family=Cabin&v1' rel='stylesheet' type='text/css' />
$checks[$row['check']]['amount'] += $ta->cost;
}
$task_activity_result->free();
debug('Added task activities to sureinvoice!');
}
$si_db = new DBConn(DB_SERVER, DB_DATABASE, DB_USER, DB_PASSWORD);
assert_die($si_db->connect(TRUE), "Could not connect to sureinvoice database!\n" . $si_db->getLastError());
debug('Connected to sureinvoice database ' . DB_DATABASE);
$dt_db = new DBConn($phpdt_server, $phpdt_database, $phpdt_username, $phpdt_password);
assert_die($dt_db->connect(TRUE), "Could not connect to phpdt database!\n" . $dt_db->getLastError());
debug('Connected to phpdt database ' . $phpdt_database);
// Migrate companies
$companies = array();
$company_rates = array();
$company_sql = "\nSELECT `id`, `name`, `address1`, `address2`, `city`, `state`,\n`zip`, `phone`, `fax`, `hourly_rate`, `created_ts`, `updated_ts`\nFROM `companies`\n";
$company_result = $dt_db->query($company_sql, TRUE);
assert_die($company_result, "Could not get company list!\n" . $dt_db->getLastError());
debug('Got ' . $company_result->numRows() . ' company rows from phpdt.');
while ($row = $company_result->fetchArray(MYSQL_ASSOC)) {
$company_insert_sql = "\nINSERT INTO companies (id, name, address1, address2, city,\nstate, zip, phone, fax, hourly_rate,created_ts, updated_ts)\nVALUES(" . $row['id'] . ", '" . $si_db->escapeString($row['name']) . "', '" . $row['address1'] . "', \n'" . $row['address2'] . "', '" . $row['city'] . "', '" . $row['state'] . "', \n'" . $row['zip'] . "', '" . $row['phone'] . "', '" . $row['fax'] . "', \n" . $row['hourly_rate'] . ", " . $row['created_ts'] . ", " . $row['updated_ts'] . ")\n\t";
assert_die($si_db->query($company_insert_sql, TRUE), "Error adding company!\n" . $si_db->getLastError(), FALSE);
debug('Added ' . $row['name'] . ' to sureinvoice');
$company_rates[$row['id']] = $row['hourly_rate'];
$companies[$row['id']] = $row;
}
$company_result->free();
// Migrate users
$users = array();
$user_sql = "\nSELECT `id`, `user_type_id`, `first_name`, `last_name`, `company_id`, \n`address1`, `address2`, `city`, `state`, `zip`, `email`, `password`, \n`hourly_rate`, `rate_type`, `active`, `created_ts`, `updated_ts`, \n`last_login_ts` \nFROM `users`";
$user_result = $dt_db->query($user_sql, TRUE);
assert_die($user_result, "Could not get user list!\n" . $dt_db->getLastError());
******************************************************************************************/
echo <<<OUT
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//WAPFORUM//DTD XHTML Mobile 1.0//EN" "http://www.wapforum.org/DTD/xhtml-mobile10.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Bus Route Finder</title>
</head>
<body>
<div><strong>I want to go on a bus from</strong>
<br/>
<form action="query.php" method="get" enctype="text/plain" autocomplete="off">
OUT;
$dbconn = new DBConn();
$res = $dbconn->query("SELECT pid, name FROM place ORDER BY p.name ASC", array());
$options = '';
if ($res) {
while (($row = $resultset->fetch()) != false) {
$options .= '<option value="' . $row[0] . '">' . $row[1] . '</option>' . "\n";
}
}
echo <<<OUT
<label for="f">from</label><select id="f" name="f">
{$options}
</select><br/>
<label for="t">to</label><select id="t" name="t">
{$options}
</select>
<input type="hidden" name="v" value="mobile">
<button type="submit">find a bus</button>
