Subversion Repositories SmartDukaan

Rev

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

Rev 17137 Rev 17138
Line 61... Line 61...
61 
        end_date = datetime.now()
 61 
        end_date = datetime.now()
62 
    else:
 62 
    else:
63 
        end_date = end_date + timedelta(days=1)
63 
        end_date = end_date + timedelta(days=1)
64 
    try:
 64 
    try:
65 
        cur = con.cursor()
65 
        cur = con.cursor()
66 
        db=client.dump
 66 
        db=client.Dtr
67 
        db1 = client.Catalog
 67 
        db1 = client.Catalog
68 
        cur.execute("delete from allorder where created_on >= %s and created_on < %s", (start_date, end_date))
 68 
        cur.execute("delete from allorder where created_on >= %s and created_on < %s", (start_date, end_date))
69 
        con.commit()
 69 
        con.commit()
70 
        results = Mysql.fetchResult('''
 70 
        results = Mysql.fetchResult('''
71 
                select ow.*, u.username, crm1.order_count, u.referrer, aua.city,aua.state,aua.pincode from order_view ow
71 
                select ow.*, u.username, crm1.order_count, u.referrer, aua.city,aua.state,aua.pincode from order_view ow