j"19HxigV4QyBv3tHpQVcUEQyq1pzZVdoAutM
<html>
<head>
<title>CityOnChain Historic Data</title>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.js"></script>
<script async src="https://www.googletagmanager.com/gtag/js?id=UA-65703744-1"></script>
<script src="https://www.moneybutton.com/moneybutton.js"></script>
<style>
body {
padding: 50px;
font-family: arial;
font-size: 12px;
}
div {
width: 500px;
margin: 0 auto;
padding: 10px 0;
}
.loader {
position: fixed;
background-color: #FFF;
opacity: .90;
height: 100%;
width: 100%;
top: 0;
left: 0;
z-index: 10;
text-align: center;
padding-top: 20em;
}
.r2 {
border-radius: 25px;
background: #E5E5E5;
padding: 20px;
opacity: 1;
width: 20em;
height: auto;
}
</style>
<script>
$(document).ready( function () {
var table1 = $('#postsT').DataTable({
columns: [
{ data: 'CityName' },
{ data: 'price' }
],
"columnDefs": [{
"defaultContent": "-",
"targets": "_all"
}]
});
var query = {
"v": 3,
"q": {
"find": {"out.s1": "Cityonchain"}
},
"project": {
"out.s1": 1,
"out.s2": 1,
"out.s3": 1,
"out.s4": 1,
"timeago": 1,
"timestamp": 1,
"tx.h": 1
},
"limit": 200,
"r": {
"f": "[.[] | .out[0].h = .tx.h | .out[0] | .t = if .s2 then .s2 else .s14 end | { city: .t, s1: .s1, h: .h, order: .s3, price: .s4[0:-3]} ]"
}
}
//"f": "[.[] | { txid: .tx.h, city: .s2, priceUSD: .s4[0:-3], timestamp: (.timestamp / 1000 | floor | todate), timeago: .timeago }] | sort_by( -(.priceUSD | tonumber) )"
//"f": "[.[] | .out[0].h = .tx.h | .out[0] | .t = if .s2 then .s2 else .s14 end | { city: .t, s1: .s1, h: .h, order: .s3, price: .s4} ]"
//"f": "[.[] | { txid: .tx.h, city: .out[0].s2, priceUSD: .out[0].s4[0:-3], timestamp: (.timestamp / 1000 | floor | todate), timeago: .timeago }] | sort_by( -(.priceUSD | tonumber) )"
//"f": "[.[] | .out[0].h = .tx.h | .out[0] | { city: .t, s1: .s1, h: .h, order: .s3, price: .s4[0:-3]}]"
//{
// "f": "[.[] | { txid: .tx.h, city: .out[0].s2, priceUSD: .out[0].s4[0:-3], timestamp: (.timestamp / 1000 | floor | todate), //timeago: .timeago }] | sort_by( -(.priceUSD | tonumber) )"
// }
// Turn the query into base64 encoded string.
// This is required for accessing a public bitdb node
var b64 = btoa(JSON.stringify(query));
var url = "https://genesis.bitdb.network/q/1FnauZ9aUH2Bex6JzdcV4eNX7oLSSEbxtN/" + b64;
// Attach API KEY as header
var header = {
headers: { key: [["1Aae49oXZwM6VkLLksvCvLuTJLW17HkxCF"]] }
};
// Make an HTTP request to bitdb.network public endpoint
fetch(url, header).then(function(r) {
return r.json()
}).then(function(r) {
$(".loader").fadeOut("fast");
$(".r2").fadeOut("fast");
// "r.c" stands for confirmed transactions response array
// Parse the response and render the results on the screen
r.c.forEach(function(output) {
table1.rows.add( [ {
"CityName": output.city,
"price": output.price
} ] )
.draw();
})
})
})
</script>
</head>
<body>
<div class="loader">
<div class="r2">
<h2> Loading data from blockchain! <br/> This can take several seconds. Please be patient.</h2>
</div>
</div>
<div align="center"><h2>CityOnChain Historic Data</h2></div>
<div>
<br/>
<div>
<table id="postsT" class="display table-striped table-bordered" width="98%">
<thead>
<tr>
<th>City Name</th>
<th>Price USD</th>
</tr>
</thead>
<tbody>
<tr>
<td id="CityName"></td>
<td id="price"></td>
</tr>
</tbody>
</table>
</div>
</div>
<br/>
<div class="money-button"
data-to="1799"
data-amount="1"
data-currency="USD"
data-label="Donate"
data-client-identifier="4358a131fcb178b12799fd58b1d20733"
data-button-id="1562856661496"
data-button-data="{}"
data-type="tip"
></div>
<div>v0.3</div>
</body>
</html> text/htmlUTF-8
https://whatsonchain.com/tx/8df38a1659bdb910cbc4ac5851dbe5eeddd3cf76bded7d1ff4810265a7571b99