| W dniu 6 lipca 2012 11:47 użytkownik JOYNET <joynet@vp.pl> napisał: moglbys cos wiecej napisac na temat tego zapytania, o co chodzi z tym labilities nie widze tego w bazie danych? w tabeli liabilities są trzymane zobowiązania, które wpisuje się ręcznie. Standardowo moduł cutoff nie pobiera tych danych. w cutoff.c około lini 390 (tak jest u mnie): " if(plimit) query = strdup( "SELECT c.id, ca.balance " "FROM customers c " // balance "JOIN (SELECT SUM(value) AS balance, customerid " "FROM cash " "GROUP BY customerid " "HAVING SUM(value) < 0 " ") ca ON (c.id = ca.customerid) " // monthly assignments sum "JOIN (SELECT " "SUM(t.value * (CASE t.period " "WHEN " _YEARLY_ " THEN 1/12.0 " "WHEN " _HALFYEARLY_ " THEN 1/6.0 " "WHEN " _QUARTERLY_ " THEN 1/3.0 " "ELSE 1 END)) AS tariff, a.customerid " "FROM assignments a " "JOIN tariffs t ON (a.tariffid = t.id) " "WHERE a.period = 3 " "AND a.suspended = 0 " "AND (a.datefrom <= %NOW% OR a.datefrom = 0) " "AND (a.dateto >= %NOW% OR a.dateto = 0) " "GROUP BY a.customerid " ") t ON (t.customerid = c.id) " "JOIN (SELECT SUM(l.value) AS liab, a.customerid " "FROM assignments a JOIN liabilities l ON (a.liabilityid = l.id) " "WHERE a.suspended = 0 AND (a.datefrom <= UNIX_TIMESTAMP() OR a.datefrom = 0) " "AND (a.dateto >= UNIX_TIMESTAMP() OR a.dateto = 0) " "GROUP BY a.customerid ) l ON (l.customerid = c.id)" "WHERE c.deleted = 0 " "AND c.cutoffstop < %NOW% " #ifdef USE_PGSQL "AND balance * -1 > (?/100::numeric * (tariff+liab)) " #else "AND balance * -1 > (?/100 * (tariff+liab)) " #endif "%groups%egroups%nets%enets" ); " -- Pozdrawiam Marcin / nicraM |