Subversion Repositories SmartDukaan

Rev

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

Rev 18201 Rev 18309
Line 101... Line 101...
101
GROUP BY WEEK(date(o.created))
101
GROUP BY WEEK(date(o.created))
102
ORDER BY year(date(o.created)),WEEK(date(o.created))
102
ORDER BY year(date(o.created)),WEEK(date(o.created))
103
"""
103
"""
104
 
104
 
105
DNRU_QUERY="""
105
DNRU_QUERY="""
106
SELECT count(*) 
106
SELECT date(u.activation_time),count(*) 
107
FROM users u WHERE 
107
FROM users u WHERE 
108
(LOWER(u.referrer) NOT LIKE  'emp%%' OR u.utm_campaign is not NULL) AND u.activated =1
108
(LOWER(u.referrer) NOT LIKE  'emp%%' OR u.utm_campaign is not NULL) AND u.activated =1
109
AND date(u.activation_time) BETWEEN %s AND %s
109
AND date(u.activation_time) BETWEEN %s AND %s
110
group by date(u.activation_time) 
110
group by date(u.activation_time) 
111
order by date(u.activation_time)
111
order by date(u.activation_time)
Line 524... Line 524...
524
        
524
        
525
    row = 0
525
    row = 0
526
    cursor.execute(dnruSql,(cutOffDate,todaysDate()))
526
    cursor.execute(dnruSql,(cutOffDate,todaysDate()))
527
    result = cursor.fetchall()
527
    result = cursor.fetchall()
528
    for r in result:
528
    for r in result:
-
 
529
        row=dateMap.get(str(r[0]))
529
        row += 1
530
        sumDa=sumDa+r[1]
530
        column = 1
531
        column = 1
531
        for data in r :
-
 
532
            sumDa=sumDa+data
-
 
533
            worksheet.write(row, column, int(sumDa) if type(sumDa) is float else sumDa, date_format if type(sumDa) is date else default_format)
532
        worksheet.write(row, column, int(sumDa) if type(sumDa) is float else sumDa, date_format if type(sumDa) is date else default_format)
534
            column += 1
-
 
535
 
533
 
536
    row = 0
534
    row = 0
537
    cursor.execute(dnruSql,(cutOffDate,todaysDate()))
535
    cursor.execute(dnruSql,(cutOffDate,todaysDate()))
538
    result = cursor.fetchall()
536
    result = cursor.fetchall()
539
    for r in result:
537
    for r in result:
-
 
538
        row=dateMap.get(str(r[0]))
540
        row += 1
539
        data=r[1]
541
        column = 2
540
        column = 2
542
        for data in r :
-
 
543
            worksheet.write(row, column, int(data) if type(data) is float else data, date_format if type(data) is date else default_format)
541
        worksheet.write(row, column, int(data) if type(data) is float else data, date_format if type(data) is date else default_format)
544
            column += 1        
-
 
545
    
542
    
546
    row = 0
543
    row = 0
547
    cursor.execute(dauSql,(cutOffDate,todaysDate()))
544
    cursor.execute(dauSql,(cutOffDate,todaysDate()))
548
    result = cursor.fetchall()
545
    result = cursor.fetchall()
549
    
546