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