| Line 155... |
Line 155... |
| 155 |
sum(quantity) as quantity,sum(amount_paid) as value FROM allorder o
|
155 |
sum(quantity) as quantity,sum(amount_paid) as value FROM allorder o
|
| 156 |
JOIN users u ON u.id = o.user_id WHERE (LOWER(u.referrer) NOT LIKE 'emp%%' OR u.utm_campaign is not NULL)
|
156 |
JOIN users u ON u.id = o.user_id WHERE (LOWER(u.referrer) NOT LIKE 'emp%%' OR u.utm_campaign is not NULL)
|
| 157 |
AND u.activated =1 AND date(o.created_on) >=%s
|
157 |
AND u.activated =1 AND date(o.created_on) >=%s
|
| 158 |
GROUP BY date(o.created_on) UNION
|
158 |
GROUP BY date(o.created_on) UNION
|
| 159 |
select date(o.created) as dateid,sum(quantity) as bquantity,sum(price)
|
159 |
select date(o.created) as dateid,sum(quantity) as bquantity,sum(price)
|
| 160 |
from flipkartorders o JOIN users u ON u.id = o.user_id WHERE (LOWER(u.referrer) NOT LIKE
|
160 |
from flipkartorders o JOIN users u ON u.id = ifnull(o.user_id,139) WHERE (LOWER(u.referrer) NOT LIKE
|
| 161 |
'emp%%' OR u.utm_campaign is not NULL) AND u.activated =1 AND date(o.created) >= %s
|
161 |
'emp%%' OR u.utm_campaign is not NULL) AND u.activated =1 AND date(o.created) >= %s
|
| 162 |
GROUP BY date(o.created)) a group by dateid;
|
162 |
GROUP BY date(o.created)) a group by dateid;
|
| 163 |
"""
|
163 |
"""
|
| 164 |
DOWN_QUERY="""
|
164 |
DOWN_QUERY="""
|
| 165 |
SELECT date(created_on),sum(quantity),sum(amount_paid) FROM allorder o
|
165 |
SELECT date(created_on),sum(quantity),sum(amount_paid) FROM allorder o
|
| Line 245... |
Line 245... |
| 245 |
sum(quantity) as quantity,sum(amount_paid) as value FROM allorder o
|
245 |
sum(quantity) as quantity,sum(amount_paid) as value FROM allorder o
|
| 246 |
JOIN users u ON u.id = o.user_id WHERE (LOWER(u.referrer) NOT LIKE 'emp%%' OR u.utm_campaign is not NULL)
|
246 |
JOIN users u ON u.id = o.user_id WHERE (LOWER(u.referrer) NOT LIKE 'emp%%' OR u.utm_campaign is not NULL)
|
| 247 |
AND u.activated =1 AND date(o.created_on) >=%s
|
247 |
AND u.activated =1 AND date(o.created_on) >=%s
|
| 248 |
GROUP BY month(date(o.created_on)) UNION
|
248 |
GROUP BY month(date(o.created_on)) UNION
|
| 249 |
select month(date(o.created)) as monthid,sum(quantity) as bquantity,sum(price)
|
249 |
select month(date(o.created)) as monthid,sum(quantity) as bquantity,sum(price)
|
| 250 |
from flipkartorders o JOIN users u ON u.id = o.user_id WHERE (LOWER(u.referrer) NOT LIKE
|
250 |
from flipkartorders o JOIN users u ON u.id = ifnull(o.user_id,139) WHERE (LOWER(u.referrer) NOT LIKE
|
| 251 |
'emp%%' OR u.utm_campaign is not NULL) AND u.activated =1 AND date(o.created) >= %s
|
251 |
'emp%%' OR u.utm_campaign is not NULL) AND u.activated =1 AND date(o.created) >= %s
|
| 252 |
GROUP BY month(date(o.created))) a group by monthid;
|
252 |
GROUP BY month(date(o.created))) a group by monthid;
|
| 253 |
"""
|
253 |
"""
|
| 254 |
MOWN_QUERY="""
|
254 |
MOWN_QUERY="""
|
| 255 |
SELECT sum(quantity),sum(amount_paid) FROM allorder o
|
255 |
SELECT sum(quantity),sum(amount_paid) FROM allorder o
|
| Line 325... |
Line 325... |
| 325 |
FROM allorder o JOIN users u ON u.id = o.user_id WHERE
|
325 |
FROM allorder o JOIN users u ON u.id = o.user_id WHERE
|
| 326 |
(LOWER(u.referrer) NOT LIKE 'emp%%' OR u.utm_campaign is not NULL)
|
326 |
(LOWER(u.referrer) NOT LIKE 'emp%%' OR u.utm_campaign is not NULL)
|
| 327 |
AND u.activated =1 AND date(o.created_on) >= %s
|
327 |
AND u.activated =1 AND date(o.created_on) >= %s
|
| 328 |
GROUP BY WEEK(date(o.created_on)) UNION
|
328 |
GROUP BY WEEK(date(o.created_on)) UNION
|
| 329 |
select WEEK(date(o.created)) as weekid,sum(quantity) as bquantity,sum(price)
|
329 |
select WEEK(date(o.created)) as weekid,sum(quantity) as bquantity,sum(price)
|
| 330 |
from flipkartorders o JOIN users u ON u.id = o.user_id
|
330 |
from flipkartorders o JOIN users u ON u.id = ifnull(o.user_id,139)
|
| 331 |
WHERE (LOWER(u.referrer) NOT LIKE 'emp%%' OR u.utm_campaign is not NULL) AND
|
331 |
WHERE (LOWER(u.referrer) NOT LIKE 'emp%%' OR u.utm_campaign is not NULL) AND
|
| 332 |
u.activated =1 AND date(o.created) >= %s GROUP BY WEEK(date(o.created))) a group by weekid;"""
|
332 |
u.activated =1 AND date(o.created) >= %s GROUP BY WEEK(date(o.created))) a group by weekid;"""
|
| 333 |
WOWN_QUERY="""
|
333 |
WOWN_QUERY="""
|
| 334 |
SELECT sum(quantity),sum(amount_paid) FROM allorder o
|
334 |
SELECT sum(quantity),sum(amount_paid) FROM allorder o
|
| 335 |
JOIN users u ON u.id = o.user_id WHERE (LOWER(u.referrer) NOT LIKE
|
335 |
JOIN users u ON u.id = o.user_id WHERE (LOWER(u.referrer) NOT LIKE
|