def getAllMaintenanceNotCreated():
simplelist = []
maintenancesList = select_all_maintenance()
for mainte in maintenancesList:
if mainte.created_at == None:
simplelist.append(mainte.customers)
return simplelist
def getMaintenancePused():
simplelist = []
mainlist = select_all_maintenance()
for mainte in mainlist:
if mainte.created_at == None or mainte.cost_of_bill_of_material == None:
simplelist.append(mainte)
return simplelist
def getMaintenanceAmouted():
simplelist = []
mainlist = select_all_maintenance()
for mainte in mainlist:
if mainte.start_date != None:
simplelist.append(mainte)
return simplelist
def getMaintenanceFinishedAndDelivared():
simplelist = []
mainlist = select_all_maintenance()
for mainte in mainlist:
if mainte.close_at != None:
simplelist.append(mainte)
return simplelist
def getMaintenanceWaitingDelevary():
simplelist = []
mainlist = select_all_maintenance()
for mainte in mainlist:
if mainte.done_date != None and mainte.close_at == None:
simplelist.append(mainte)
return simplelist
def getMaintenanceUnderProccessing():
simplelist = []
mainlist = select_all_maintenance()
for mainte in mainlist:
if mainte.start_date != None and mainte.done_date == None:
simplelist.append(mainte)
return simplelist
def getMaintenanceBTWDate(first, second):
simplelist = []
mainlist = select_all_maintenance()
for mainte in mainlist:
if mainte.start_date != None:
if mainte.created_at >= first and mainte.created_at <= second:
simplelist.append(mainte)
return simplelist
def getMaintenanceHolded():
simplelist = []
mainlist = select_all_maintenance()
for mainte in mainlist:
if mainte.created_at != None \
and mainte.start_date == None \
and mainte.cost_of_labor != None:
simplelist.append(mainte)
return simplelist
def getMaintenanceWaitLaborCost():
simplelist = []
mainlist = select_all_maintenance()
for mainte in mainlist:
if mainte.created_at != None \
and mainte.cost_of_labor == None \
and mainte.cost_of_bill_of_material != None:
simplelist.append(mainte)
return simplelist
def getMaintenanceFinishedAndDelivaredCost():
simplelistbm = []
simplelistla = []
simplelistan = []
mainlist = select_all_maintenance()
for mainte in mainlist:
if mainte.close_at != None:
if not mainte.cost_of_bill_of_material == None:
# mainte.cost_of_bill_of_material = 0
simplelistbm.append(mainte.cost_of_bill_of_material)
if not mainte.cost_of_labor == None:
# mainte.cost_of_labor = 0
simplelistla.append(mainte.cost_of_labor)
if not mainte.cost_of_another == None:
# mainte.cost_of_another = 0
simplelistan.append(mainte.cost_of_another)
summ = sum(simplelistbm) + sum(simplelistla) + sum(simplelistan)
# if summ == 0:
# summ =0
return summ
def getMaintenanceUnderProccessingCost():
simplelistbm = []
simplelistla = []
simplelistan = []
mainlist = select_all_maintenance()
for mainte in mainlist:
if mainte.start_date != None and mainte.done_date == None:
if not mainte.cost_of_bill_of_material == None:
# mainte.cost_of_bill_of_material = 0
simplelistbm.append(mainte.cost_of_bill_of_material)
if not mainte.cost_of_labor == None:
# mainte.cost_of_labor = 0
simplelistla.append(mainte.cost_of_labor)
if not mainte.cost_of_another == None:
# mainte.cost_of_another = 0
simplelistan.append(mainte.cost_of_another)
summ = sum(simplelistbm) + sum(simplelistla) + sum(simplelistan)
# if summ == 0:
# summ =0
return summ
def getMaintenanceCalcCost():
simplelistbm = []
simplelistla = []
simplelistan = []
mainlist = select_all_maintenance()
for mainte in mainlist:
if mainte.created_at != None \
and mainte.start_date == None:
if not mainte.cost_of_bill_of_material == None:
# mainte.cost_of_bill_of_material = None
simplelistbm.append(mainte.cost_of_bill_of_material)
if not mainte.cost_of_labor == None:
# mainte.cost_of_labor = None
simplelistla.append(mainte.cost_of_labor)
if not mainte.cost_of_another == None:
# mainte.cost_of_another = None
simplelistan.append(mainte.cost_of_another)
summ = sum(simplelistbm) + sum(simplelistla) + sum(simplelistan)
# if summ == 0:
# summ =0
return summ