def index_add_wos():
vm = MaintainVM()
vm.plant = 'GHUO'
if 'plant' in request.form:
vm.plant = request.form['plant']
wos = repository.get_all_wo_status(vm.plant, host=HOST, port=PORT, db=DB)
vm.wos = wos
return render_template('addwos.html', vm=vm)
def wos_upload_redis():
order = workOrder.Workorder()
i = 0
result = []
vm = MaintainVM()
vm.plant = 'GHUO'
if 'plant' in request.form:
vm.plant = request.form['plant']
wos = repository.get_all_wo_status(vm.plant, host=HOST, port=PORT, db=DB)
vm.wos = wos
try:
f = request.files.get('excelFile').read()
data = xlrd.open_workbook(file_contents=f)
table = data.sheet_by_index(i)
keys = table.row_values(0)
if keys:
row_num = table.nrows
col_num = table.ncols
for i in range(1, row_num):
sheet_data = {}
for j in range(0, col_num):
sheet_data['DESC'] = table.row_values(i)[0]
sheet_data['PN'] = table.row_values(i)[1]
sheet_data['WO'] = table.row_values(i)[2]
sheet_data['Qty'] = table.row_values(i)[5]
sheet_data['Remark'] = table.row_values(i)[6]
if sheet_data not in result:
result.append(sheet_data)
for info in result:
order._plant = vm.plant
order.desc = info['DESC']
order.pn = info['PN']
if str(int(info['WO'])).startswith('6'):
order.wo_no = '0000' + str(int(info['WO']))
elif str(int(info['WO'])).startswith('1') or str(int(
info['WO'])).startswith('4'):
order.wo_no = '000' + str(int(info['WO']))
order.qty = info['Qty']
order.remark = info['Remark']
(order.status, order.units) = sfc.get_workOrder_status_units(
vm.plant, order.wo_no, sfc.url_switch(vm.plant))
# print(order._plant, order.desc, order.pn, order.wo_no, order.qty, order.remark)
repository.set_wos(order, host=HOST, port=PORT, db=DB)
return render_template('addwos.html', vm=vm)
except Exception:
return render_template('error.html')
def get_wos_status():
i = 0
result = []
vm = MaintainVM()
vm.plant = 'GHUO'
if 'plant' in request.form:
vm.plant = request.form['plant']
wos = repository.get_all_wo_status(vm.plant, host=HOST, port=PORT, db=DB)
vm.wos = wos
try:
f = request.files.get('excelFile').read()
data = xlrd.open_workbook(file_contents=f)
table = data.sheet_by_index(i)
keys = table.row_values(0)
if keys:
row_num = table.nrows # 行数
col_num = table.ncols # 列数
for i in range(1, row_num):
sheet_data = {}
for j in range(0, col_num):
sheet_data['DESC'] = table.row_values(i)[0]
sheet_data['PN'] = table.row_values(i)[1]
# sheet_data['WO'] = table.row_values(i)[2]
if str(int(table.row_values(i)[2])).startswith('6'):
sheet_data['WO'] = '0000' + str(
int(table.row_values(i)[2]))
elif str(int(table.row_values(i)[2])).startswith('1') \
or str(int(table.row_values(i)[2])).startswith('4'):
sheet_data['WO'] = '000' + str(
int(table.row_values(i)[2]))
sheet_data['Qty'] = table.row_values(i)[5]
sheet_data['Remark'] = table.row_values(i)[6]
if sheet_data not in result:
result.append(sheet_data)
return render_template('addwoss.html', results=result, vm=vm)
except Exception:
return render_template('error.html')
def maintain():
vm = MaintainVM()
vm.plant = 'GHUO'
if 'plant' in request.form:
vm.plant = request.form['plant']
wos = repository.get_all_wo_status(vm.plant, host=HOST, port=PORT, db=DB)
vm.wos = wos
vm.wo_nos = sorted(wos.keys())
return render_template('maintain.html', vm=vm)
def index_query():
vm = MaintainVM()
vm.plant = 'GHUO'
keys = []
if 'plant' in request.form:
vm.plant = request.form['plant']
wos = repository.get_all_wo_status(vm.plant,
host=HOST,
port=PORT,
db=store_DB)
vm.wos = wos
vm.wo_nos = sorted(wos.keys())
stations = set([])
for wo_no in vm.wo_nos:
stations = stations.union(vm.wos[wo_no].status.keys())
kf = sfc.SortKeyFinder(r'.\static\station.json')
vm.stations = sorted(stations, key=lambda s: kf.get_key(s))
merger = sfc.StationMerger(r'.\static\merge.json')
vm.c_stations = merger.merger(vm.stations)
if request.method == 'post':
return render_template('query_redis.html', vm=vm, keys=keys)
return render_template('query_redis.html', vm=vm, keys=keys)
def close_all_wos():
# 1.删除所有
if request.form.get('btnclose'):
keys = request.form.getlist('hidcloseall')
vm = MaintainVM()
vm.plant = keys[0]
if 'plant' in request.form:
vm.plant = request.form['plant']
wos = repository.get_all_wo_status(vm.plant,
host=HOST,
port=PORT,
db=DB)
vm.wos = wos
vm.wo_nos = sorted(wos.keys()) # ['000060030987', '000060030988']
for wo in vm.wo_nos:
result = repository.del_key('%s:%s' % (vm.plant, wo),
host=HOST,
port=PORT,
db=DB)
return render_template('maintain.html', vm=vm)
def query_redis():
keys = []
start_time = request.form.get('startTime')
end_time = request.form.get('endTime')
vm = MaintainVM()
vm.plant = request.form.getlist('hidvalue')[0]
if 'plant' in request.form:
vm.plant = request.form['plant']
if request.form.get('query_redis'):
if start_time and end_time:
start = str(
datetime.datetime.strptime(start_time,
'%Y/%m/%d').strftime('%Y%m%d'))
end = str(
datetime.datetime.strptime(end_time,
'%Y/%m/%d').strftime('%Y%m%d'))
keys, results_start = repository.snap_shot_status(start,
end,
vm.plant,
host=HOST,
port=PORT,
db=store_DB)
vm.wos = results_start
# print vm.wos[0]['status'].values() # [335, 5, 1, 1, 4, 1, 2, 79, 1, 2, 1]
stations = set([])
for ss in vm.wos:
stations = stations.union(ss['status'].keys())
kf = sfc.SortKeyFinder(r'.\static\station.json')
vm.stations = sorted(stations, key=lambda s: kf.get_key(s))
merger = sfc.StationMerger(r'.\static\merge.json')
vm.c_stations = merger.merger(vm.stations)
return render_template('query_redis.html', vm=vm, keys=keys)
else:
return render_template('error.html')
return render_template('query_redis.html', vm=vm, keys=keys)
def close_part_wos():
# 1.批量删除
if request.form.get('clspart'):
keys = request.form.getlist('hidclosepart')
vm = MaintainVM()
vm.plant = keys[0]
wos = repository.get_all_wo_status(vm.plant,
host=HOST,
port=PORT,
db=DB)
vm.wos = wos
vm.wo_nos = sorted(wos.keys())
part_list = request.form.getlist('CheckPart')
if 'plant' in request.form:
vm.plant = request.form['plant']
for wo in part_list:
result = repository.del_key('%s:%s' % (vm.plant, wo),
host=HOST,
port=PORT,
db=DB)
return render_template('maintain.html', vm=vm)