Subversion Repositories SmartDukaan

Rev

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

Rev 12418 Rev 12419
Line 508... Line 508...
508 
        print "am details obj created"
 508 
        print "am details obj created"
509 
        try:
 509 
        try:
510 
            print "inside val getter"
 510 
            print "inside val getter"
511 
            itemVatMaster = ItemVatMaster.query.filter(and_(ItemVatMaster.itemId==int(val.sku[3:]), ItemVatMaster.stateId==val.state_id)).first()
 511 
            itemVatMaster = ItemVatMaster.query.filter(and_(ItemVatMaster.itemId==int(val.sku[3:]), ItemVatMaster.stateId==val.state_id)).first()
512 
            if itemVatMaster is None:
 512 
            if itemVatMaster is None:
513 
                item = Item.query.filter_by(id=int(val.sku[3:]).first()
 513 
                d_item = Item.query.filter_by(id=int(val.sku[3:])).first()
514 
                if item is None:
 514 
                if d_item is None:
- 
 
 515 
                    raise
- 
 
 516 
                else:
- 
 
 517 
                    vatMaster = CategoryVatMaster.query.filter(and_(CategoryVatMaster.categoryId==d_item.category, CategoryVatMaster.minVal<=amDetails.ourSp,  CategoryVatMaster.maxVal>=amDetails.ourSp,  CategoryVatMaster.stateId == val.state_id)).first()
- 
 
 518 
                if vatMaster is None:
515 
                    raise
 519 
                    raise
516 
                vatMaster = CategoryVatMaster.query.filter(and_(CategoryVatMaster.categoryId==item.category, CategoryVatMaster.minVal<=amDetails.ourSp,  CategoryVatMaster.maxVal>=amDetails.ourSp,  CategoryVatMaster.stateId == val.state_id)).first()
 - 
 
517 
            if vatMaster is None:
 - 
 
518 
                raise
520 
                else:
519 
                val.vatRate = vatMaster.vatPercent
 521 
                    val.vatRate = vatMaster.vatPercent
- 
 
 522 
                    print "vat fetched"
520 
            else:
 523 
            else:
521 
                val.vatRate = itemVatMaster.vatPercentage
 524 
                val.vatRate = itemVatMaster.vatPercentage
522 
            print "vat fetched"
 525 
                print "vat fetched"
523 
        except:
 526 
        except:
524 
            print "vat exception"
 527 
            print "vat exception"
525 
            temp = []
 528 
            temp = []
526 
            temp.append(val)
 529 
            temp.append(val)
527 
            temp.append("Vat not available")
 530 
            temp.append("Vat not available")