WebSVN – SmartDukaan – Diff – /trunk/PyDTR/src/dtr/reports/crmoutbound.py



                    cursor = conn.cursor()
                    cursor.execute(name_query)
                    result = cursor.fetchall()
                    loginTime=0
                    for r in result:
                        if r[0] is not None:
                            loginTime+=r[0]
                    hours=loginTime/3600
                    minutesLeft=(loginTime%3600)/60
                    worksheet.write(25+21,columnId,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)    
                    conn.close()
 

Rev 15481	Rev 15482
Line 585...	Line 585...
585	`cursor = conn.cursor()`	585	`cursor = conn.cursor()`
586	`cursor.execute(name_query)`	586	`cursor.execute(name_query)`
587	`result = cursor.fetchall()`	587	`result = cursor.fetchall()`
588	`loginTime=0`	588	`loginTime=0`
589	`for r in result:`	589	`for r in result:`
-		590	`if r[0] is not None:`
590	`loginTime+=r[0]`	591	`loginTime+=r[0]`
591	`hours=loginTime/3600`	592	`hours=loginTime/3600`
592	`minutesLeft=(loginTime%3600)/60`	593	`minutesLeft=(loginTime%3600)/60`
593	`worksheet.write(25+21,columnId,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)`	594	`worksheet.write(25+21,columnId,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)`
594	`conn.close()`	595	`conn.close()`
595		596

Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/dtr/reports/crmoutbound.py – Rev 15481 → 15482