Subversion Repositories SmartDukaan

Rev

Rev 12392 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 12392 Rev 12393
Line 28... Line 28...
28 
        try:
 28 
        try:
29
29
30 
            vatFactor = 0.0
 30 
            vatFactor = 0.0
31
31
32 
            if rec[6] == 3:
 32 
            if rec[6] == 3:
33 
                vatFactor = get_vat_percentage_for_item(rec[0], rec[6], rec[3])
 33 
                vatFactor = get_vat_percentage_for_item(rec[0], rec[7], rec[3])
34 
            else:
 34 
            else:
35 
                vatFactor = get_vat_percentage_for_item(rec[0], rec[6], rec[1])
 35 
                vatFactor = get_vat_percentage_for_item(rec[0], rec[7], rec[1])
36
36
37 
            vatDiff = round(float((rec[1]*(vatFactor/100.0))),2)
 37 
            vatDiff = round(float((rec[1]*(vatFactor/100.0))),2)
38 
            nlcP = rec[2] + vatDiff
 38 
            nlcP = rec[2] + vatDiff
39
39
40 
            sql_update ="update lineitem set nlcP = %f, vatDiff = %f where itemId = %d and purchaseOrder_id = %d"%(nlcP, vatDiff, rec[0],rec[4])
 40 
            sql_update ="update lineitem set nlcP = %f, vatDiff = %f where itemId = %d and purchaseOrder_id = %d"%(nlcP, vatDiff, rec[0],rec[4])