Subversion Repositories SmartDukaan

Rev

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

Rev 23142 Rev 23148
Line 3457... Line 3457...
3457
#    itemIdSgstTaxRateMap = {};
3457
#    itemIdSgstTaxRateMap = {};
3458
#    for stateGstRate in query.all():
3458
#    for stateGstRate in query.all():
3459
#        itemIdSgstTaxRateMap[stateGstRate.item_id] = stateGstRate.tax_rate;
3459
#        itemIdSgstTaxRateMap[stateGstRate.item_id] = stateGstRate.tax_rate;
3460
#    return itemIdSgstTaxRateMap;
3460
#    return itemIdSgstTaxRateMap;
3461
 
3461
 
3462
def get_total_tax_rate(itemIds, stateId):
3462
def get_state_tax_rate(itemIds, stateId):
3463
    queryItem = session.query(Item).filter(Item.id.in_(itemIds))
3463
    queryItem = session.query(Item).filter(Item.id.in_(itemIds))
3464
    itemIdItemMap = {}
3464
    itemIdItemMap = {}
3465
    for item in queryItem.all():
3465
    for item in queryItem.all():
3466
        itemIdItemMap[item.id] = item
3466
        itemIdItemMap[item.id] = item
3467
    
3467
    
Line 3472... Line 3472...
3472
        sgstTaxRate = stateGstRate.tax_rate
3472
        sgstTaxRate = stateGstRate.tax_rate
3473
        cgstTaxRate = igstTaxRate - sgstTaxRate
3473
        cgstTaxRate = igstTaxRate - sgstTaxRate
3474
        gstRate = GstRate()
3474
        gstRate = GstRate()
3475
        gstRate.cgstRate = cgstTaxRate
3475
        gstRate.cgstRate = cgstTaxRate
3476
        gstRate.sgstRate = sgstTaxRate
3476
        gstRate.sgstRate = sgstTaxRate
3477
        gstRate.igstRate = igstTaxRate
3477
        gstRate.igstRate = 0.0
3478
        gstRate.hsnCode = itemIdItemMap[stateGstRate.item_id].hsnCode
3478
        gstRate.hsnCode = itemIdItemMap[stateGstRate.item_id].hsnCode
3479
        itemIdTotalTaxRateMap[stateGstRate.item_id] = gstRate
3479
        itemIdTotalTaxRateMap[stateGstRate.item_id] = gstRate
3480
    return itemIdTotalTaxRateMap
3480
    return itemIdTotalTaxRateMap
-
 
3481
 
-
 
3482
def get_igst_tax_rate(itemIds):
-
 
3483
    queryItem = session.query(Item).filter(Item.id.in_(itemIds))
-
 
3484
    itemIdTaxRateMap = {}
-
 
3485
    for item in queryItem.all():
-
 
3486
        itemIdTaxRateMap[item.id] = item.tax_rate
-
 
3487
    return itemIdTaxRateMap
3481
             
3488
         
3482
def get_interstate_gst_rates():
3489
def get_interstate_gst_rates():
3483
    #CategoryState.query.filter_by(stateId=stateId)
3490
    #CategoryState.query.filter_by(stateId=stateId)
3484
    centralGstMap = {} 
3491
    centralGstMap = {} 
3485
    alias1 = aliased(CentralGstMaster)
3492
    alias1 = aliased(CentralGstMaster)
3486
    q = session.query(CentralGstMaster).outerjoin((alias1, and_(alias1.hsnCode==CentralGstMaster.hsnCode, CentralGstMaster.startDate < alias1.startDate))).filter(alias1.hsnCode==None)
3493
    q = session.query(CentralGstMaster).outerjoin((alias1, and_(alias1.hsnCode==CentralGstMaster.hsnCode, CentralGstMaster.startDate < alias1.startDate))).filter(alias1.hsnCode==None)