136 lines
6.4 KiB
PHP
136 lines
6.4 KiB
PHP
<?php
|
|
|
|
require_once("../include/i18n.php");
|
|
require_once("../include/cp3000-tcpclient.php");
|
|
require_once("support.inc.php");
|
|
|
|
$db_info = read_database(DBCONFIG_DIR, 'di_zkl');
|
|
// open the database
|
|
$db_data_handle = mysql_connect($db_info['host'], $db_info['user'], $db_info['passwd']);
|
|
if( $db_data_handle === FALSE ) {
|
|
echo mysql_error();
|
|
exit(1);
|
|
}
|
|
mysql_select_db($db_info['database'], $db_data_handle);
|
|
if( $db_info['main'] ) {
|
|
$db_main_info = read_database(DBCONFIG_DIR, $db_info['main']);
|
|
$db_main_handle = mysql_connect($db_main_info['host'], $db_main_info['user'], $db_main_info['passwd'], true);
|
|
if( $db_main_handle === FALSE ) {
|
|
echo mysql_error();
|
|
exit(1);
|
|
}
|
|
mysql_select_db($db_main_info['database'], $db_main_handle);
|
|
}
|
|
else {
|
|
$db_main_handle = $db_data_handle;
|
|
$db_main_info = $db_info;
|
|
}
|
|
|
|
// get information about the device
|
|
$query = "SELECT zkl.*,IFNULL(zkl.gebruiker,zkl.eigenaar) AS gebruiker,server.adres AS tcp_server,server.adres_ssl AS stcp_server ";
|
|
$query .= "FROM zkl,server ";
|
|
$query .= "WHERE ";
|
|
if (isset($_GET['id'])) {
|
|
$query .= " zkl.id=" . intval($_GET['id']) . " AND ";
|
|
} elseif (isset($_GET['serienr'])) {
|
|
$query .= " zkl.serienr='" . $_GET['serienr'] . "' AND ";
|
|
} elseif (isset($_GET['idcode'])) {
|
|
$query .= " zkl.serienr='" . $_GET['idcode'] . "' AND ";
|
|
}
|
|
$query .= " server.id=zkl.tcp_server";
|
|
$result = mysql_run($query, $db_main_handle);
|
|
$zkl_info = mysql_fetch_assoc($result);
|
|
if( $zkl_info['gebruiker'] ) {
|
|
$query = "SELECT tz,i18n FROM klant WHERE id=" . $zkl_info['gebruiker'];
|
|
$result = mysql_run($query, $db_main_handle);
|
|
$tz_info = mysql_fetch_assoc($result);
|
|
}
|
|
else {
|
|
$tz_info = array( 'tz' => date("e"), 'i18n' => "nl" );
|
|
}
|
|
?>
|
|
<!DOCTYPE html>
|
|
<html lang="en">
|
|
<head>
|
|
<meta charset="utf-8">
|
|
<meta http-equiv="X-UA-Compatible" content="IE=edge">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1">
|
|
|
|
<title>Supportscripts</title>
|
|
|
|
<!-- Bootstrap -->
|
|
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
|
|
|
|
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
|
|
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
|
|
<!--[if lt IE 9]>
|
|
<script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
|
|
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
|
|
<![endif]-->
|
|
</head>
|
|
<body style="padding: 10px;">
|
|
<div class="container-fluid">
|
|
<div class="row">
|
|
<div class="col-sm-8">
|
|
<?php
|
|
echo '<table class="table table-condensed">';
|
|
echo "<tr valign=\"top\"><td>Database ID:</td><td>" . $zkl_info['id'] . "</td></tr>\n";
|
|
echo "<tr valign=\"top\"><td>MTinfo V5 (device:uid):</td><td>" . sprintf('01%030d', $zkl_info['id']) . "</td></tr>\n";
|
|
if ($zkl_info['parent'] !== null) {
|
|
echo "<tr valign=\"top\"><td>Parent ID:</td><td>" . $zkl_info['parent'] . "</td></tr>\n";
|
|
}
|
|
echo "<tr valign=\"top\"><td>Serialno:</td><td>" . $zkl_info['serienr'] . "</td></tr>\n";
|
|
echo "<tr valign=\"top\"><td>ID-code:</td><td>" . $zkl_info['idcode'] . "</td></tr>\n";
|
|
echo "<tr valign=\"top\"><td>IMEI:</td><td>" . $zkl_info['imei'] . "</td></tr>\n";
|
|
echo "<tr valign=\"top\"><td>IMSI:</td><td>" . $zkl_info['imsi'] . "</td></tr>\n";
|
|
echo "<tr valign=\"top\"><td>SIM-card:</td><td>" . $zkl_info['sim'] . "</td></tr>\n";
|
|
echo "<tr valign=\"top\"><td>Telephone nr:</td><td>" . $zkl_info['telefoonnr'] . "</td></tr>\n";
|
|
echo "<tr valign=\"top\"><td>Next maintenance:</td><td>" . $zkl_info['onderhoud'] . "</td></tr>\n";
|
|
echo "<tr valign=\"top\"><td>SW 3000 mem install:</td><td>" . $zkl_info['sw3000_onderhoud'] . "</td></tr>\n";
|
|
echo "<tr valign=\"top\"><td>Status:</td><td><b>Dual Inventive:</b> " . $zkl_info['lans_status'] . ", <b>Customer:</b> " . $zkl_info['klant_status'] . "</td></tr>\n";
|
|
echo "<tr valign=\"top\"><td>Firmware:</td><td>" .
|
|
"<b>MCU:</b> " . $zkl_info['mcu_versie'] . "<br>" .
|
|
"<b>WCPU:</b> " . $zkl_info['wcpu_versie'] . "<br>" .
|
|
($zkl_info['sw3000_dversie'] ? ("<b>SWITCH 3000 drive:</b> " . $zkl_info['sw3000_dversie'] . "<br>") : "") .
|
|
($zkl_info['sw3000_mversie'] ? ("<b>SWITCH 3000 measure:</b> " . $zkl_info['sw3000_mversie'] . "<br>") : "") .
|
|
"</td></tr>\n";
|
|
echo "<tr valign=\"top\"><td>Hardware:</td><td>" .
|
|
"Device: <b>PCB-version:</b> " . $zkl_info['pcb_versie'] . ", <b>revision</b> " . $zkl_info['pcb_revisie'] . ", <b>productionno.</b> " . $zkl_info['fabrieksnr'] . "<br>" .
|
|
"Modem: <b>FW: </b>" . $zkl_info['wavecom_versie'] . ", <b>hardware-revision: </b>" . $zkl_info['wavecom_revisie'] . ", <b>S/N:</b> " . $zkl_info['wavecom_serienr'] . "<br>" .
|
|
"µALFAT: " . $zkl_info['ualfat_versie'] .
|
|
"</td></tr>\n";
|
|
echo "<tr valign=\"top\"><td>Timezone:</td><td>" . $zkl_info['tz'] . "</td></tr>\n";
|
|
echo "<tr valign=\"top\"><td>Comment:</td><td>" . nl2br($zkl_info['opmerking']) . "</td></tr>\n";
|
|
echo "</table>\n";
|
|
|
|
if (isset($_GET['gpsfix']) && $zkl_info['id'] > 0) {
|
|
$tcpch = zkl_tcplogin($zkl_info['id'], $zkl_info['tcp_server']);
|
|
zkl_command($tcpch, 10, "\$AT,\"AT+WMFM=0,1,2\"");
|
|
zkl_store($tcpch, "RESET", "1");
|
|
zkl_tcplogout($tcpch);
|
|
}
|
|
|
|
?>
|
|
</div>
|
|
<div class="col-sm-4">
|
|
<p>
|
|
<a href="supportscripts.php?id=<?php echo $zkl_info['id']; ?>&gpsfix=1" class="btn btn-lg btn-primary">GPS fix</a>
|
|
<?php /* <button type="button" class="btn btn-lg btn-primary">Primary</button>
|
|
<button type="button" class="btn btn-lg btn-success">Success</button>
|
|
<button type="button" class="btn btn-lg btn-info">Info</button>
|
|
<button type="button" class="btn btn-lg btn-warning">Warning</button>
|
|
<button type="button" class="btn btn-lg btn-danger">Danger</button>
|
|
<button type="button" class="btn btn-lg btn-link">Link</button>*/ ?>
|
|
</p>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
|
|
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
|
|
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
|
|
<!-- Include all compiled plugins (below), or include individual files as needed -->
|
|
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
|
|
</body>
|
|
</html>
|