<?php
// Home :: box sameday
$htm = [];
$box = new LTE\Box();
$box->id("boxSameday");
$box->title("On the same day");
$box->small("xxxx-xx-xx");
$box->icon("fa fa-calendar-o");
$box->body($htm);
//$box->footer("<a href=# class='btn btn-default'><i class='fa fa-plus'></i> Add</a>");
$htm = [];
$htm[] = '<div class="input-group input-group-sm">';
$htm[] = '<input type="text" class="form-control" id=newStr placeholder="21:30 Dinner 18.50EUR">';
$htm[] = '<span class="input-group-btn">';
$htm[] = '<button type="button" id=btnAdd class="btn btn-default btn-flat">Add</button>';
$htm[] = '</span>';
$htm[] = '</div>';
$box->footer($htm);
$box->loading(true);
/*
$btn=[];
$btn[]="<a href=#new id='btnSaveNote' class='btn btn-default'><i class='fa fa-save'></i> Save note</a> ";
$btn[]="<a href=#trash id='btnTrashNote' class='btn btn-danger pull-right'><i class='fa fa-trash'></i></a> ";
$box->footer($btn);
*/
echo $box;
<?php
//Home :: box today
$htm = [];
$box = new LTE\Box();
$box->id("boxConfig");
$box->title("Config");
$box->small("currency");
$box->icon("fa fa-wrench");
$box->body($htm);
$box->collapsed(true);
$box->footer("<a href=#save id='btnSaveConfig' class='btn btn-default'><i class='fa fa-save'></i> Save</a>");
echo $box;
$htm[] = '<div class="form-group">';
$htm[] = '<label for="inputEmail3" class="col-sm-2 control-label">Updated</label>';
$htm[] = '<div class="col-xs-5">';
$htm[] = '<input type="text" class="form-control" id="category" placeholder="Category" value="' . $date . '" readonly>';
$htm[] = '</div>';
$htm[] = '<div class="col-xs-5">';
$htm[] = '<input type="text" class="form-control" id="category" placeholder="Category" value="' . $r['user_modified'] . '" readonly>';
$htm[] = '</div></div>';
$htm[] = '</div>';
$btn = [];
$btn[] = "<a href=index.php class='btn btn-default'><i class='fa fa-arrow-left'></i> Back</a>";
$btn[] = "<a href=#del id=delete class='btn btn-default pull-right' title='Delete'><i class='fa fa-trash-o'></i></a>";
$box = new LTE\Box();
$box->id("boxNews");
$box->title($r['title']);
$box->icon("fa fa-list");
$box->body($htm);
$box->footer($btn);
echo $box;
?>
<script>
$(function(){
$('#delete').click(function(){
if(!confirm("Delete this news ?"))return false;
alert("No");
});
});
</script>
<?php
$admin->footer("Vorc backup");
$admin->end();
// box routes //
$sql = "SELECT * FROM ip_routes WHERE ir_ip LIKE '{$name}' AND ir_user_id=" . $IP->user_id() . ";";
$q = $IP->db()->query($sql) or die("Error {$sql}");
//echo "<pre>test:$sql</pre>";
$ports = [];
while ($r = $q->fetch(PDO::FETCH_ASSOC)) {
$ports[] = $r;
}
$htm = [];
$htm[] = "<table class='table table-hover table-condensed'>";
$htm[] = "<thead>";
$htm[] = "<th width=40>Route</th>";
$htm[] = "<th>Name</th>";
$htm[] = "<th>Comment</th>";
$htm[] = "</thead>";
$htm[] = "<tbody>";
foreach ($ports as $k => $r) {
$htm[] = "<tr>";
$htm[] = "<td><a href='../port/?id=" . $r['ir_id'] . "'>" . $r['ir_port_from'] . "</a>";
$htm[] = "<td>" . $r['ir_name'];
$htm[] = "<td>" . $r['ir_comment'];
}
$htm[] = "</tbody>";
$htm[] = "</table>";
$box = new LTE\Box();
$box->id("boxRoutes");
$box->icon("fa fa-list");
$box->title(count($ports) . " route(s)");
$box->html($htm);
$box->footer("<a href=# class='btn btn-primary' id='btnNewRoute'><i class='fa fa-file'></i> New route</a>");
echo $box;
//$foot[]="<select class='form-control'>";
//$foot[]="<option value=''>Select IP</option>";
//list ip names//
/*
foreach($IP->listIps() as $k=>$ip){
$foot[]="<option value='$ip'>$ip</option>";
}
*/
//$foot[]="</select>";
$foot[] = "</div>";
$foot[] = "<div class='col-sm-6'>";
$foot[] = "<a href=#new class='btn btn-primary pull-right' id='btnNew'><i class='fa fa-file'></i> New route</a>";
$foot[] = "</div>";
$foot[] = "</div>";
$box->html($htm);
$box->footer($foot);
echo $box;
// MODAL //
// MODAL //
// MODAL //
/*
$htm=[];
$htm[]="<div class='row'>";
$htm[]="<input type=hidden id=ip_id>";
//name
$htm[]="<div class='col-sm-12'>";
$htm[]="<div class='form-group'><label>Name</label>";
$htm[]="<input type='text' class='form-control' id='ip_name' placeholder='name'>";
$htm[]="</div></div>";
<?php
//Home :: box stats
$this_year = date("Y");
$this_month = date("m");
//echo "<li>$this_year";
//echo "<li>$this_month";
// This year
$sql = "SELECT SUM(ed_value) FROM expenses_data WHERE ed_date>'" . date("Y-01-01") . "' AND ed_date <=CURDATE();";
$q = $EXP->db()->query($sql) or die("Error:{$sql}");
$r = $q->fetch(PDO::FETCH_ASSOC);
$htm = [];
//$htm[]="<pre>$sql</pre>";
//$htm[]="<pre>".print_r($r,true)."</pre>";
$box = new LTE\Box();
$box->id("box");
$box->title("Overview");
$box->icon("fa fa-area-chart");
$box->body($htm);
$box->collapsable(true);
$box->footer("<a href='../stats/' class='btn btn-default'><i class='fa fa-arrow-right'></i> More stats</a>");
echo $box;
<?php
// box port comment
$htm = [];
$htm[] = "<textarea class='form-control' id='comments'>" . $r['ip_comment'] . "</textarea>";
$box = new LTE\Box();
$box->id("boxComment");
$box->icon("fa fa-comment-o");
$box->title("Comments");
$box->html($htm);
$box->footer("<a href=# class='btn btn-default' id='btnSaveComment'><i class='fa fa-save'></i> Save</a>");
echo $box;
$htm[] = '<div class="form-group">';
$htm[] = '<label class="col-sm-2 control-label">Platform</label>';
$htm[] = '<div class="col-sm-10">';
$htm[] = '<input type="text" class="form-control" id="platform" placeholder="Platform" value="' . $r['flag_platform'] . '" readonly>';
$htm[] = '</div></div>';
// URL //
$htm[] = '<div class="form-group">';
$htm[] = '<label class="col-sm-2 control-label">URL</label>';
$htm[] = '<div class="col-sm-10">';
$htm[] = '<input type="text" class="form-control" id="url" placeholder="URL" value="' . $r['ex_url'] . '" readonly>';
$htm[] = '</div></div>';
// Last update //
$date = date("Y-m-d H:i:s", strtotime($r['lastupdate']));
$htm[] = '<div class="form-group">';
$htm[] = '<label for="inputEmail3" class="col-sm-2 control-label">Updated</label>';
$htm[] = '<div class="col-xs-5">';
$htm[] = '<input type="text" class="form-control" id="category" placeholder="Category" value="' . $date . '" readonly>';
$htm[] = '</div>';
$htm[] = '<div class="col-xs-5">';
$htm[] = '<input type="text" class="form-control" id="category" placeholder="Category" value="' . $r['user_modified'] . '" readonly>';
$htm[] = '</div></div>';
$htm[] = '</div>';
$box = new LTE\Box();
$box->title($r['id']);
$box->icon('fa fa-edit');
$box->body($htm);
$box->footer("<a href=index.php class='btn btn-default'><i class='fa fa-arrow-left'></i> Back</a>");
echo $box;
//echo "<hr /><pre>";print_r($r);exit;
$admin->footer("Vorc backup");
$admin->end();
<?php
$box = new LTE\Box();
$box->title("Receive");
$box->icon("fa fa-text");
$box->id("boxReceive");
$box->collapsable(true);
$box->boxTools("<button class=\"btn btn-box-tool btnclipboard\" title='Copy to clipboard'><i class='fa fa-copy'></i></button> ");
$box->body("<textarea class='form-control' id=sysex_in rows=10></textarea>");
$box->footer("<a href=#save id=saveSysex class='btn btn-default'><i class='fa fa-save'></i> Save</a>");
echo $box;
<?php
// GoogleDriveCsv
$htm = [];
$htm = "<input type=text class='form-control' id='csvurl' placeholder='Enter csv url'>";
$box = new LTE\Box();
$box->id("boxGoogleDriveCsv");
$box->title("Wget csv");
$box->small("public csv url");
$box->icon("fa fa-upload");
$box->body($htm);
$box->footer("<a href=# class='btn btn-default' id='btnWget'>Import</a>");
echo $box;
<?php
$htm = '<canvas id="screen">';
$btns = [];
$btns[] = "<div class='col-md-6'>";
$btns[] = "<select class='form-control' id=trackSelect><option>Select track</select>";
$btns[] = "</div>";
$btns[] = "<a href=#btn class='btn btn-default' onclick=drawMidiTrack(0)>draw</a>";
$box = new LTE\Box();
$box->title("Canvas");
$box->id("boxCanvas");
$box->collapsable(1);
$box->body($htm);
$box->footer($btns);
echo $box;
$htm[] = '<thead>';
$htm[] = '<th>#</th>';
$htm[] = '<th>Username</th>';
$htm[] = '<th>Email</th>';
$htm[] = '<th>is_staff</th>';
$htm[] = '<th>is_active</th>';
$htm[] = '<th>is_superuser</th>';
$htm[] = '<th>last_login</th>';
$htm[] = '<th>date_joined</th>';
$htm[] = '</thead>';
$htm[] = '<tbody>';
while ($r = $q->fetch()) {
//print_r($r);
$htm[] = "<tr>";
$htm[] = "<td><a href='../user/?id=" . $r['id'] . "'>" . $r['id'] . "</a>";
$htm[] = "<td>" . $r['username'];
$htm[] = "<td>" . $r['email'];
$htm[] = "<td>" . $r['is_staff'];
$htm[] = "<td>" . $r['is_active'];
$htm[] = "<td>" . $r['is_superuser'];
$htm[] = "<td>" . $r['last_login'];
$htm[] = "<td>" . $r['date_joined'];
}
$htm[] = '</tbody>';
$htm[] = '</table>';
$box = new LTE\Box();
$box->title("users");
$box->icon("fa fa-list");
$box->body($htm);
$box->footer("<a href=# id=btnNew class='btn btn-default'>New user</a>");
echo $box;
<?php
// http://www.cambiaresearch.com/articles/15/javascript-char-codes-key-codes
$htm = [];
$htm[] = "<div class=row>";
$htm[] = "<div class=col-sm-6>";
$htm[] = "<input type=text class='form-control' id='keyname' placeholder='Hit a key !'>";
$htm[] = "</div>";
$htm[] = "<div class=col-sm-6>";
$htm[] = "<input type=text class='form-control' id='keycode' placeholder='Keycode' readonly>";
$htm[] = "</div>";
$htm[] = "</div>";
$box = new LTE\Box();
$box->title("Keyboard mapping");
$box->icon("fa fa-cogs");
$box->id("boxMapping");
$box->collapsable(1);
$box->collapsed(1);
$box->body($htm);
$box->footer("<a href=#btn id=btnMapping class='btn btn-default'><i class='fa fa-list'></i> Mapping</a>");
echo $box;
<?php
$box = new LTE\Box();
$box->title("Send");
$box->icon("fa fa-text");
$box->id("boxSend");
$box->collapsable(true);
$box->body("<textarea class='form-control' id=midi_send rows=10 placeholder='Paste your hex code here'></textarea>");
$box->footer("<a href=# class='btn btn-default'><i class='fa fa-play'></i> Send</a>");
echo $box;
