Subversion Repositories SmartDukaan

Rev

Rev 34114 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 34114 Rev 34144
Line 10... Line 10...
10 
                query = "SELECT" +
 10 
                query = "SELECT" +
11 
                        "    a.auth_id," +
 11 
                        "    a.auth_id," +
12 
                        "    a.rbm_Name," +
 12 
                        "    a.rbm_Name," +
13 
                        "    a.fofo_id," +
 13 
                        "    a.fofo_id," +
14 
                        "    a.fofo_code," +
 14 
                        "    a.fofo_code," +
- 
 
 15 
                        "    (CASE " +
15 
                        "    (CASE WHEN MAX(o.billing_timestamp) IS NOT NULL THEN 'Billed' ELSE 'Not billed' END) AS status" +
 16 
                        "        WHEN SUM(o.total_amount) > 20000 THEN 'Billed' " +
- 
 
 17 
                        "        ELSE 'Not billed' " +
- 
 
 18 
                        "     END) AS status " +
16 
                        " FROM (" +
 19 
                        " FROM (" +
17 
                        "         SELECT" +
 20 
                        "         SELECT" +
18 
                        "             au.id AS auth_id," +
 21 
                        "             au.id AS auth_id," +
19 
                        "             CONCAT(au.first_name, ' ', au.last_name) AS Rbm_Name," +
 22 
                        "             CONCAT(au.first_name, ' ', au.last_name) AS Rbm_Name," +
20 
                        "             fs.id AS fofo_id," +
 23 
                        "             fs.id AS fofo_id," +