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



                        converted=r[0]
                        worksheet.write(25+22,columnId,r[0],center_alignment)
                    
                    if totalVerifiedLinkSent==0:
                        worksheet.write(25+23,columnId,0,center_alignment)
                    elif totalVerifiedLinkSent<converted:
                        worksheet.write(25+23,columnId,converted-totalVerifiedLinkSent,center_alignment)    
                    else:
                        worksheet.write(25+23,columnId,totalVerifiedLinkSent-converted,center_alignment)    
                    conn.close()
#                     datesql=AGENT_FRESH_QUERY_LINKS_NOT_CONVERTED%(agentId)
#                     conn = getDbConnection()

Rev 15513	Rev 15514
Line 610...	Line 610...
610	`converted=r[0]`	610	`converted=r[0]`
611	`worksheet.write(25+22,columnId,r[0],center_alignment)`	611	`worksheet.write(25+22,columnId,r[0],center_alignment)`
612		612
613	`if totalVerifiedLinkSent==0:`	613	`if totalVerifiedLinkSent==0:`
614	`worksheet.write(25+23,columnId,0,center_alignment)`	614	`worksheet.write(25+23,columnId,0,center_alignment)`
-		615	`elif totalVerifiedLinkSent<converted:`
-		616	`worksheet.write(25+23,columnId,converted-totalVerifiedLinkSent,center_alignment)`
615	`else:`	617	`else:`
616	`worksheet.write(25+23,columnId,totalVerifiedLinkSent-converted,center_alignment)`	618	`worksheet.write(25+23,columnId,totalVerifiedLinkSent-converted,center_alignment)`
617	`conn.close()`	619	`conn.close()`
618	`# datesql=AGENT_FRESH_QUERY_LINKS_NOT_CONVERTED%(agentId)`	620	`# datesql=AGENT_FRESH_QUERY_LINKS_NOT_CONVERTED%(agentId)`
619	`# conn = getDbConnection()`	621	`# conn = getDbConnection()`

Subversion Repositories SmartDukaan

(root)//trunk/PyDTR/src/dtr/reports/crmoutbound.py – Rev 15513 → 15514