Below is the bill table that I am working with
building flatname flatdescription amount pastpayments receiptno
1234 name a a 123 0 0
1234 name a a 12 10 39
1234 name a a 125 125 40
1235 name a a 133 10 41
1235 name b b 125 125 50
1234 name c c 100 90 0
I need to retrieve rows where the difference between amount and payments is greater than zero for building code 1234, and display them with style B if there is a receipt number > 0 within the same name, otherwise no style.
The expected result from my code should be as follows:
name a 39 with style B
name c 0
Any suggestions on how to achieve this?
I have tried the following code but it returns all selections without any style differentiation
t.executeSql('SELECT receiptno AS mr, flatdescription, flatname, buildingcode FROM bill WHERE amount - pastpayments> 0 AND buildingcode = ? GROUP BY buildingcode, flatname ORDER BY flatdescription DESC',[buildingcode], function(t, resultflat) {
var i,
len = resultflat.rows.length,
row;
if (len > 0 ) {
items.push('<br>');
for (i = 0; i < len; i += 1) {
row = resultflat.rows.item(i);
if (row.mr > 0) {
items.push('<li data-theme="b" data-icon="false" style="height:40px; padding: 7px 0 0 0; font-size: 1.2em"><a href="#displayflat" data-flat="' + row.flatname + '" data-description="' + row.flatdescription + '">' + row.flatdescription + '...' + row.flatname + '</a></li>');
} else {
items.push('<li data-icon="false" style="height:40px; padding: 7px 0 0 0; font-size: 1.2em"><a href="#displayflat" data-flat="' + row.flatname + '" data-description="' + row.flatdescription + '">' + row.flatdescription + '...' + row.flatname + '</a></li>');
}
}
}