<html>
<head>
<script src="Dexie.js"></script>
<script>
var db = new Dexie("zusa_app");
db.version(1).stores({
labels: 'name, status',
artikelen : 'name, label_id, status'
});
db.open();
function populateSomeData() {
db.labels.where('status').equals(0).toArray().then(function(labels) {
// For each label, resolve its articles:
Dexie.Promise.all (labels.map(function (label) {
return db.artikelen.where('label_id').anyOf(
label.name).toArray();
})).then(function(labelArticles) {
for (var i=0; i<labels.length; ++i) {
//console.log(labels.length);
var label = labels[i],
artikelen = labelArticles[i];
var name = (artikelen.map(function(a){return
a.name ;}).join(','));
var array = name.split(",");
console.log(array);
var arrayLength = array.length;
console.log(arrayLength);
for (var i = 0; i < artikelen.length; i++) {
//alert(name[i]);
var uitzet = document.getElementById("log");
var li = document.createElement("li");
var a = document.createElement("a");
var t = document.createTextNode(array[i]);
li.appendChild(t);
uitzet.appendChild(li);
}
}
});
});
}
function log(txt) {
var div = document.createElement('div');
div.className = "label";
div.textContent = txt.toString();
document.getElementById('log').appendChild(div);
}
function runSamples() {
populateSomeData()
}
</script>
<style>
.label{color:red;}
</style>
</head>
<body onload="runSamples();">
<div id="log"></div>
</body>
</html>