vendor-management-api/dao/reports_dao.py

def tdsNameList(mongo):
    tds_list=[]
    try:
        tds_list=list(mongo["v_tds_rate"].distinct("name"))
    except Exception as err:
        print(err)
        
    return tds_list

def getMOUReportsDataDao(from_date,to_date,mongo):
    mous=[]
    try:
        mous=list(mongo["v_tbl_project_master"].find({"po_submitted":True,"submitted_on":{"$gte":int(from_date),"$lte":int(to_date)}},{'_id':0}))
    except Exception as err:
        print('getMOUReportsDataDao',err)
    return mous

def getTdsReportsDataDao(from_date,to_date,tds_name,mongo):
    vouchers=[]
    try:
        vouchers=list(mongo["v_tbl_voucher_master"].find({"tds_name":tds_name,"voucher_created_on":{"$gte":int(from_date),"$lte":int(to_date)}},{'_id':0}))
    except Exception as err:
        print('getTdsReportsDataDao',err)
    return vouchers

def getTallyReportsDataDao(from_date,to_date,mongo):
    vouchers=[]
    try:
        vouchers=list(mongo["v_tbl_voucher_master"].find({"voucher_created_on":{"$gte":int(from_date),"$lte":int(to_date)}},{'_id':0}))
    except Exception as err:
        print('getTallyReportsDataDao',err)
    return vouchers

def getAssetReportsDataDao(category,mongo):
    assets=[]
    try:
        assets=list(mongo["i_tbl_asset_master_new"].find({"asset_master_type":category},{'_id':0}))
    except Exception as err:
        print('getAssetReportsDataDao',err)
    return assets

def getAllVoucherAnalyticsDataDao(from_date,to_date,mongo):
    vouchers=[]
    try:
        vouchers=list(mongo["v_tbl_voucher_master"].find({"voucher_created_on":{"$gte":int(from_date),"$lte":int(to_date)}},{'_id':0}))
    except Exception as err:
        print('getAllVoucherAnalyticsDataDao',err)
    return vouchers

def getAllFinancePendingVoucherDataDao(request_obj,mongo):
    vouchers=[]
    try:
        query={"voucher_created_on":{"$gte":int(request_obj['from_date']),"$lte":int(request_obj['to_date'])}}
        if request_obj['intervention']!='All':
            query['intervention']=request_obj['intervention']

        vouchers=list(mongo["v_tbl_voucher_master"].find(query
            ,{'_id':0}))
    except Exception as err:
        print('getAllFinancePendingVoucherDataDao',err)
    return vouchers

def getAssetDepriciationDataDao(category,mongo):
    depriciation=0
    age=0
    try:
        data=list(mongo["i_assets_type_master"].find({"name":category},{'_id':0,'depriciation':1,'age':1}).limit(1))
        for dep_obj in data:
           depriciation=dep_obj['depriciation']
           age=dep_obj['age']
    except Exception as err:
        print('getAssetReportsDataDao',err)
    return depriciation,age