probuje przelaczyc damona tc-new tak aby mi generowal regulki dla
komputerow z zawieszonymi zobowiazaniami, ale w zapytaniu o komputery
nie widze nic na temat suspended, moze powinienem gdzies jeszcze
poszukac?:
tc-new.c :
// nodes
query = strdup("SELECT t.downrate AS downrate, t.downceil AS downceil, t.uprate AS uprate, "
"t.upceil AS upceil, t.climit AS climit, t.plimit AS plimit, "
"n.id, n.ownerid, n.name, INET_NTOA(n.ipaddr) AS ip, n.mac, "
"na.assignmentid, "
#ifdef USE_PGSQL
"TRIM(c.lastname || ' ' || c.name) AS customer "
#else
"TRIM(CONCAT(c.lastname, ' ', c.name)) AS customer "
#endif
"FROM nodeassignments na "
"JOIN assignments a ON (na.assignmentid = a.id) "
"JOIN tariffs t ON (a.tariffid = t.id) "
"JOIN %nodes n ON (na.nodeid = n.id) "
"JOIN customers c ON (a.customerid = c.id) "
"%night_debtors"
"WHERE "
"(a.datefrom <= %NOW% OR a.datefrom = 0) "
"AND (a.dateto >= %NOW% OR a.dateto = 0) "
"AND n.access = 1 "
"AND (t.downrate > 0 OR t.downceil > 0 OR t.uprate > 0 OR t.upceil > 0) "
"%groups"
"ORDER BY a.customerid, a.id");
