[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-commits
Subject:    [skrooge/Feature] plugins/skrooge/skrooge_scheduled: Correction in
From:       Stephane Mankowski <stephane () mankowski ! fr>
Date:       2011-11-14 12:39:59
Message-ID: 20111114123959.B2FB8A60B9 () git ! kde ! org
[Download RAW message or body]

Git commit ed29abb61f35209d597c5b3e1180cd35f0fbb3ad by Stephane Mankowski.
Committed on 13/11/2011 at 11:06.
Pushed by smankowski into branch 'Feature'.

Correction in advice "Possible schedule"

M  +1    -1    plugins/skrooge/skrooge_scheduled/skgscheduledplugin.cpp

http://commits.kde.org/skrooge/ed29abb61f35209d597c5b3e1180cd35f0fbb3ad

diff --git a/plugins/skrooge/skrooge_scheduled/skgscheduledplugin.cpp \
b/plugins/skrooge/skrooge_scheduled/skgscheduledplugin.cpp index 402aec7..bdbde5c \
                100644
--- a/plugins/skrooge/skrooge_scheduled/skgscheduledplugin.cpp
+++ b/plugins/skrooge/skrooge_scheduled/skgscheduledplugin.cpp
@@ -317,7 +317,7 @@ SKGAdviceList SKGScheduledPlugin::advices() const
     }
 
     //Possible recurrent operations
-    m_currentBankDocument->executeSelectSqliteOrder("SELECT op1.id, \
op1.t_displayname FROM v_operation_displayname op1 WHERE op1.d_date>date('now','-2 \
month') AND op1.t_TRANSFER='N' AND  " +    \
m_currentBankDocument->executeSelectSqliteOrder("SELECT op1.id, op1.t_displayname \
FROM v_operation_displayname op1 WHERE op1.d_date>date('now','-2 month') AND \
op1.t_TRANSFER='N' AND op1.r_recurrentoperation_id=0 AND "  "EXISTS (SELECT 1 FROM \
v_operation op2 WHERE op1.rd_account_id=op2.rd_account_id AND \
op1.r_payee_id=op2.r_payee_id AND op1.f_CURRENTAMOUNT=op2.f_CURRENTAMOUNT AND \
op1.d_date=date(op2.d_date, '+1 month')) AND "  "NOT EXISTS (SELECT 1 FROM \
recurrentoperation ro, v_operation op2 WHERE ro.rd_operation_id=op2.id AND \
ro.i_period_increment=1 AND ro.t_period_unit='M' AND \
op1.rd_account_id=op2.rd_account_id AND op1.r_payee_id=op2.r_payee_id AND \
op1.f_CURRENTAMOUNT=op2.f_CURRENTAMOUNT)", result);  nb = result.count();


[prev in list] [next in list] [prev in thread] [next in thread]