diff options
Diffstat (limited to 'src/reports.c')
| -rw-r--r-- | src/reports.c | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/src/reports.c b/src/reports.c index 981d02c..265f2c2 100644 --- a/src/reports.c +++ b/src/reports.c @@ -574,7 +574,7 @@ yyjson_mut_val *report_general_ledger(yyjson_mut_doc *doc, sqlite3 *db, if (sqlite3_prepare_v2( db, "SELECT v.series,v.number,v.date,COALESCE(v.description,'')," - "r.debit_ore,r.credit_ore,COALESCE(r.description,'')" + "r.debit_ore,r.credit_ore,COALESCE(r.description,''),v.source" " FROM voucher_rows r" " JOIN vouchers v ON v.org_id=r.org_id AND v.id=r.voucher_id" " JOIN accounts a ON a.org_id=r.org_id AND a.id=r.account_id" @@ -632,6 +632,9 @@ yyjson_mut_val *report_general_ledger(yyjson_mut_doc *doc, sqlite3 *db, yyjson_mut_obj_add_strcpy( doc, ro, "row_description", (const char *)sqlite3_column_text(rs, 6)); + yyjson_mut_obj_add_strcpy( + doc, ro, "source", + (const char *)sqlite3_column_text(rs, 7)); yyjson_mut_obj_add_int(doc, ro, "saldo_ore", saldo); } sqlite3_reset(rs); |
