def post(self,request):
try:
Employee_email = request.POST['Employee_email']
password = request.POST['u_password']
user = User.objects.get(Email=Employee_email)
if (user.Password == password):
if user.IsActivated == False:
Update_User_IsActivated(Employee_email)
request.session['user_Id'] = user.Id
request.session.set_expiry(0)
return restful.ok(message="login success")
request.session['user_Id'] = user.Id
request.session.set_expiry(0)
return restful.ok(message="login success")
return restful.params_error(message='password error')
except:
try:
Employee_email = request.POST['Employee_email']
password = request.POST['u_password']
user = User.objects.get(EmployeeId=Employee_email)
if (user.Password == password):
if user.IsActivated == False:
Update_User_IsActivated(Employee_email)
request.session['user_Id'] = user.Id
request.session.set_expiry(0)
return restful.ok(message="login success")
request.session['user_Id'] = user.Id
request.session.set_expiry(0)
return restful.ok(message="login success")
return restful.params_error(message='password error')
except:
return restful.params_error(message="employee number error")
def Subjects_add(request):
if request.method == "POST":
try:
subjects = {}
subjects['Type'] = request.POST.get("add_subject", '')
subjects['Remark'] = request.POST.get("add_mark", '')
subjects['Rule'] = request.POST.get("add_rule", '')
subject_is = AccountTitle.objects.filter(
Type=subjects['Type'], IsActivated=True).count() #激活的名字
subject_no = AccountTitle.objects.filter(
Type=subjects['Type'], IsActivated=False).count()
if subject_is == 0 and subject_no == 0: #新机种的添加
AccountTitle.objects.create(**subjects)
return restful.ok(message="AccountTitle name add success")
if subject_is == 0 and subject_no == 1: #删除的机种重新添加
AccountTitle.objects.filter(Type=subjects['Type']).update(
Rule=subjects['Rule'],
Remark=subjects['Rule'],
IsActivated=True,
UpdatedTime=datetime.now())
return restful.ok(message="AccountTitle name add success")
else:
return restful.params_error("AccountTitle Type had exist")
except Exception as e:
return restful.params_error(repr(e))
def modify_user(request):
if request.method == "POST":
id = int(request.POST['id'])
username = request.POST['username']
department = request.POST['department']
role = request.POST['role']
session_id = request.session['user_Id']
user_obj = User.objects.get(Id=session_id)
if user_obj.Role == "admin":
try:
user = User.objects.exclude(Id=id).get(Name=username)
if user:
return restful.params_error(message='user name had used')
except:
try:
modify_department = Department.objects.get(
Department=department)
department_id = modify_department.Id
User.objects.filter(Id=id).update(
Name=username,
Role=role,
UpdatedTime=UpdatedTime,
DepartmentId=department_id)
return restful.ok(message="user modify success")
except:
User.objects.filter(Id=id).update(Name=username,
Role=role,
UpdatedTime=UpdatedTime)
return restful.ok(message='User modify success')
else:
return restful.params_error(message="please connect admin")
def webapp_login(request):
try:
if request.method == "POST":
try:
data = json.loads(request.body)
input_user_id = data.get('user_id', '')
input_password = data.get('u_password', '')
except:
return restful.params_error(message='data error', data='error')
if input_user_id != "":
user = User.objects.get(EmployeeId=input_user_id)
user_password = user.Password
if (user_password == input_password):
return restful.ok(message='login success', data="ok")
else:
return restful.params_error(message='password error',
data='error')
else:
return restful.params_error(message='account error',
data='error')
else:
return restful.params_error(message='method error', data='error')
except Exception as e:
return restful.params_error(message="网络错误", data='error')
def Location_list(request):
if request.method == "GET":
try:
page = int(request.GET.get('page'))
number = request.GET.get('num')
dict_data = {}
count = LocationLog.objects.exclude(IsActivated='False').count()
if number == "All":
data = list(
LocationLog.objects.filter(
IsActivated=True).order_by("-Id").values(
"Id", "Location"))
dict_data['data'] = data
dict_data['page_count'] = count
return restful.ok(data=dict_data)
if number != "All":
number = int(number)
page_num = count // number # 总共多少页
if count % number > 0:
page_num = page_num + 1
if page_num >= page:
location_ob = LocationLog.objects.order_by("-Id").exclude(
IsActivated='False')[(page - 1) * number:number * page]
dict_data['data'] = list(
location_ob.values("Id", "Location"))
# dict_data['page_count'] = page_num
dict_data['total_count'] = count
dict_data['page_current'] = page
dict_data['page_count'] = page_num
return restful.ok(data=dict_data)
else:
return restful.params_error(
message="it had no other pages")
except Exception as e:
return restful.params_error(repr(e))
def Model_add(request):
if request.method == "POST":
try:
model = {}
model['Name'] = request.POST.get("model_name", '')
model['Code'] = request.POST.get("model_code", '')
name_count = Project.objects.filter(
Name=model['Name'], IsActivated=True).count() #激活的名字
code_count_2 = Project.objects.filter(Name=model['Name'],
IsActivated=False).count()
if model['Code'] == "":
model.pop("Code")
if name_count == 0 and code_count_2 == 0: #新机种的添加
Project.objects.create(**model)
return restful.ok(message="Project name add success")
if name_count == 0 and code_count_2 == 1: #删除的机种重新添加
Project.objects.filter(Name=model['Name']).update(
Code=model['Code'],
IsActivated=True,
UpdatedTime=datetime.now())
return restful.ok(message="Project name add success")
else:
return restful.params_error("model name had exist")
except Exception as e:
return restful.params_error(repr(e))
def Delete_alterParCode(request):
if request.method == "POST":
try:
model_id = request.POST['model_id']
original_parcode = request.POST['original_parcode']
del_ParCode = request.POST['del_ParCode']
#这里需要去检查是否有绑定，如果有绑定的话，就需要去解绑
check_SN = list(SerialNumberInfo.objects.filter(PartCode=del_ParCode).values("BoxIdBindingId"))
if len(check_SN) !=0:
boxname = list(Box.objects.filter(Id=check_SN[0]["BoxIdBindingId"]).values())[0]["BoxId"]
return restful.params_error(message=boxname+" this "+del_ParCode+" need to release")
# 检查是否有该料号
if len(original_parcode) !=0:
pc = original_parcode.split(",")
if del_ParCode not in pc:
return restful.params_error(original_parcode+" have no this "+del_ParCode)
else:
str = ""
for i in pc:
if i==del_ParCode or i=='':
pc.remove(i)
for j in pc:
str += j+','
ModelStage.objects.filter(Id=model_id).update(AlternativePartCode=str)
return restful.ok(message=del_ParCode+' delete success')
else:
return restful.params_error(message=original_parcode+" have no this "+del_ParCode)
except Exception as e:
return restful.params_error(message=e)
def del_user(request):
if request.method == "POST":
try:
name = request.POST['name']
session_id = request.session['user_Id']
user_obj = User.objects.get(Id=session_id)
if user_obj.Role == "admin" or user_obj.Role == "equipment_room":
budget_code = BudgetCodeForm.objects.exclude(
Status="Approve").filter(Pic=name)
if len(budget_code) != 0:
return restful.params_error(
message="User had using can't delete")
budget_code2 = BudgetCodeForm.objects.exclude(
Status="Approve").filter(Signer=name)
if len(budget_code2) != 0:
return restful.params_error(
message="User had using can't delete")
else:
user = User.objects.get(Name=name)
user.IsActivated = False
user.UpdatedTime = datetime.now()
user.save()
if user.Id == session_id:
return restful.ok(message='delete success',
data={'user': '******'})
else:
return restful.ok(message='delete success',
data={'user': '******'})
else:
return restful.params_error(message="please connect admin")
except Exception as e:
return restful.params_error(message=repr(e))
def get(self, request):
try:
page = int(request.GET.get('page'))
number = request.GET.get('num')
id = request.session['user_Id']
dict_data = {}
count = BudgetCodeForm.objects.filter(PicId=id).count() # 总共多少条数据
if number == "All":
budgetcode_info = BudgetCodeForm.objects.filter(PicId=id).order_by("-UpdatedTime","MergeId") \
.values("Id", "BillingType", "Department", "ApplyDate", "Pic", "ProductName", "Signer", "Status",
"BudgetCode", "MergeId")
budgetcode_info = list(budgetcode_info)
dict_data['data'] = budgetcode_info
dict_data['page_count'] = count
return restful.ok(data=dict_data)
if number != "All":
number = int(number)
page_num = count // number # 总共多少页
if count % number > 0:
page_num = page_num + 1
if page_num >= page:
budgetcode_info = BudgetCodeForm.objects.filter(PicId=id).order_by("-UpdatedTime","MergeId")\
.values("Id","BillingType","Department","ApplyDate","Pic","ProductName","Signer","Status","BudgetCode","MergeId")[(page-1)*number:number*page]
budgetcode_info = list(budgetcode_info)
dict_data['data'] = budgetcode_info
dict_data['page_count'] = page_num
return restful.ok(data=dict_data)
else:
return restful.params_error(
message="it had no other pages", data={'count': count})
except Exception as e:
return restful.params_error(message=repr(e))
def get(self, request):
try:
page = int(request.GET.get('page'))
number = request.GET.get('num')
dict_data = {}
count = Department.objects.exclude(IsActivated='False').count()
if number == "All":
department_info = Department.objects.exclude(
IsActivated='False')
department_info = list(department_info.values())
dict_data['data'] = department_info
dict_data['page_count'] = count
return restful.ok(data=dict_data)
if number != "All":
number = int(number)
page_num = count // number # 总共多少页
if count % number > 0:
page_num = page_num + 1
if page_num >= page:
department_info = Department.objects.exclude(
IsActivated='False')[(page - 1) * number:number * page]
department_info = list(department_info.values())
dict_data['data'] = department_info
dict_data['page_count'] = page_num
return restful.ok(data=dict_data)
else:
return restful.params_error(
message="it had no other pages")
except Exception as e:
return restful.params_error(message=repr(e))
def analysis_data(request):
if request.method == "GET":
try:
page = int(request.GET.get('page'))
number = request.GET.get('num')
dict_data = {}
count = PartItemResult.objects.order_by("Id").count()
if number == "All":
data = PartItemResult.objects.order_by("Id").all().values()
data = list(data)
dict_data['data'] = data
dict_data['page_count'] = count
return restful.ok(data=dict_data)
if number != "All":
number = int(number)
page_num = count // number # 总共多少页
if count % number > 0:
page_num = page_num + 1
if page_num >= page:
data = PartItemResult.objects.order_by(
"Id").all().values()[(page - 1) * number:number * page]
data = list(data)
dict_data['data'] = data
dict_data['page_count'] = page_num
return restful.ok(data=dict_data)
else:
return restful.params_error(
message="it had no other pages")
except:
return restful.params_error(message="data got fail")
def Logout(request):
if request.method == "POST":
try:
num = request.POST.get('check_out','')
if num == '1':
request.session['user_Id']=None
request.session.flush()
return restful.ok(message='logout')
else:
return restful.params_error(message="data error",data={'data':num})
except Exception as e:
return restful.params_error(message=repr(e))
def remove_PartCode(request):
try:
if request.method == "POST":
id = request.POST['id']
check_data = list(ModelStage.objects.filter(Id=id).values("BrushNumber"))
if check_data[0]['BrushNumber'] ==0:
ModelStage.objects.filter(Id=id).delete()
return restful.ok(message="delete success")
else:
return restful.params_error(message="need first to release")
except Exception as e:
return restful.params_error(message=e)
def Add_Box(request):
if request.method == "POST":
try:
box_id = request.POST['import_Box']
check_box = list(Box.objects.filter(BoxId=box_id).values())
UpdatedTime = datetime.now().strftime('%Y-%m-%d %H:%M:%S')
if len(check_box) !=0:
return restful.params_error(message=box_id+" had exist")
else:
Box.objects.create(BoxId=box_id,UpdatedTime=UpdatedTime)
return restful.ok(message=box_id+" create successful")
except:
return restful.params_error(message="error")
def ModelstageID(request):
if request.method == "POST":
try:
model = request.POST['modelstageId']
data = list(ModelStage.objects.filter(ModelStage=model).order_by("Id").values())
if len(data) != 0:
for i in data:
i["BrushSN"]=""
return restful.ok(data=data)
else:
return restful.params_error(message=model+" not exist")
except:
return restful.params_error(message="error")
def webapp_MaintainCommit(request):
if request.method == "POST":
try:
data = json.loads(request.body)
maintain_sns = data.get('select_sn')
maintain_date = data.get('maintian_date')
maintain_operator = data.get('maintainer')
maintain_status = data.get('status')
maintain_text = data.get('content')
maintain_remark = data.get('remark')
#写入保养计入原有的数据到记录表
try:
operator = User.objects.get(Name=maintain_operator)
except:
return restful.params_error(message="maintainer not exist")
op_id = operator.Id
maintain_sns = maintain_sns[1:-1]
maintain_sns_arr = maintain_sns.split(',')
j = 0
for j in range(len(maintain_sns_arr)):
maintain_log = PartItem.objects.get(
SN=maintain_sns_arr[j][1:-1])
MaintenanceLog.objects.create(
PartItemId=maintain_log.Id,
PartName=maintain_log.PartName,
UpdatedTime=datetime.now().strftime('%Y-%m-%d %H:%M:%S'),
Status=maintain_status,
Content=maintain_text,
OperatorId=op_id,
CheckDueDate=maintain_log.NextCheckDate,
CheckCount=maintain_log.NextCheckCount,
UsedTimes=maintain_log.UsedTimes,
Remark=maintain_remark,
MaintenanceDate=maintain_date)
maintain_obj = PartItem.objects.get(
SN=maintain_sns_arr[j][1:-1])
if maintain_obj.CheckCycleCount != None or maintain_obj.UsedTimes != None:
maintain_obj.NextCheckCount = maintain_obj.CheckCycleCount + maintain_obj.UsedTimes
maintain_obj.save()
if maintain_obj.CheckCycle != None:
# start_time = datetime.now()
user_time = datetime.strptime(
str(maintain_date).split(' ')[0], "%Y-%m-%d")
delta = timedelta(days=maintain_obj.CheckCycle)
maintain_obj.NextCheckDate = user_time + delta
maintain_obj.save()
return restful.ok(data="ok", message="maintain ok")
except Exception as e:
return restful.params_error(data='error', message=repr(e))
else:
return restful.params_error(data='error', message='method error')
def Information_Box(request):
try:
box_item = request.GET.get("box",'')
check_box = list(Box.objects.filter(BoxId=box_item).values("Id"))
if len(check_box) !=0:
data =[]
data_SN = list(SerialNumberInfo.objects.filter(BoxIdBindingId=int(check_box[0]["Id"])).values_list("SerialNumber"))
for i in data_SN:
data.append(i[0])
return HttpResponse(json.dumps(data,ensure_ascii=False),content_type="application/json,charset=utf-8")
else:
return restful.params_error(message="NO data",data=box_item)
except Exception as e:
return restful.params_error(message=e)
def modify_PartCode(request):
try:
if request.method == "POST":
id = request.POST['id']
modify_requirement = request.POST['modify_requirement']
check_data = list(ModelStage.objects.filter(Id=id).values("BrushNumber","RequireQuantity"))
if int(modify_requirement) > check_data[0]["BrushNumber"]:
ModelStage.objects.filter(Id=id).update(RequireQuantity=modify_requirement,Status="Open")
return restful.ok(message="modify requirement success")
if int(modify_requirement) < check_data[0]["BrushNumber"]:
return restful.params_error(message="need first to release this model")
if int(modify_requirement) == check_data[0]["BrushNumber"]:
return restful.ok(message="no need to modify")
except Exception as e:
return restful.params_error(message=e)
def monitor_equipment_change(request):
if request.method == "GET":
try:
end_time = datetime.now() # 这里默认是查询前几周的数据
start_time = date(2017, 1, 1) # 这里默认是查询前几周的数据
# delta = timedelta(days=21)
# start_time = end_time-delta
# 页面html显示需要的数据+分页效果
page = int(request.GET.get('page'))
number = request.GET.get('num')
dict_data = {}
count = PartItem.objects.order_by("Id").filter(
TrnDate__range=(start_time, end_time),
UseStatus='normal').count()
# 页面显示需要的数据
if number == "All":
data = PartItem.objects.order_by("Id").filter(
TrnDate__range=(start_time, end_time), UseStatus='normal')
limit_value = Configuration.objects.filter(
Type="NG_range").values("Max", "Min", "Id")
limit_value = list(limit_value)
data = list(data.values())
dict_data['data'] = data
dict_data['limit_value'] = limit_value
dict_data['page_count'] = count
return restful.ok(data=dict_data)
if number != "All":
number = int(number)
page_num = count // number # 总共多少页
if count % number > 0:
page_num = page_num + 1
if page_num >= page:
data = PartItem.objects.order_by("Id").filter(
TrnDate__range=(start_time, end_time),
UseStatus='normal')[(page - 1) * number:number * page]
limit_value = Configuration.objects.filter(
Type="NG_range").values("Max", "Min", "Id")
limit_value = list(limit_value)
data = list(data.values())
dict_data['data'] = data
dict_data['limit_value'] = limit_value
dict_data['page_count'] = page_num
return restful.ok(data=dict_data)
else:
return restful.params_error(
message='it had no others page')
except Exception as e:
return restful.params_error(message=repr(e))
def del_customer(request):
if request.method == "POST":
customer = request.POST['del_nm']
try:
budget_code = BudgetCodeForm.objects.exclude(
Status="Approve").filter(Customer=customer)
if len(budget_code) != 0:
return restful.params_error(
message="customer had using can't delete")
else:
cus = Customer.objects.get(Customer=customer)
cus.IsActivated = False
cus.save()
return restful.ok(message="Customer delete success")
except:
return restful.params_error(message='please connect admin')
def analysis_setup_value(request):
if request.method == "POST":
try:
form_data = request.POST.get('data')
form_data = eval(form_data)
dict_analysis = {}
for i, j in form_data.items():
dict_analysis[i.split('[')[0][8] +
i.split('[')[1].split(']')[0]] = int(j)
dict_an = {}
distinct_li = []
for i in dict_analysis.keys():
distinct_li.append(i[1:])
distinct_li = list(set(distinct_li))
for k in distinct_li:
val = []
for i, j in dict_analysis.items():
if i[1:] == k:
val.append(j)
val.sort()
dict_an[k] = val
for key, v in dict_an.items():
try:
analysis_obj = Configuration.objects.get(Id=eval(key))
analysis_obj.Min = v[0]
analysis_obj.Max = v[1]
analysis_obj.save()
except:
Configuration.objects.create(Type="at_count",
Min=v[0],
Max=v[1])
return restful.ok(data=form_data,
message="setup success") #("/index/")
except:
return restful.params_error(data=request.POST.get('data'))
def auth_func(request):
now_time = datetime.now()
last_access_time_str = request.COOKIES.get('LAST_ACCESS_TIME')
last_access_time = datetime.strptime(last_access_time_str,
'%Y-%m-%d %H:%M:%S')
# if user did not operate web for more than 30 minutes, need logout
passed_time = now_time - last_access_time
if passed_time.total_seconds() > 10:
return params_error(message="/login/")
# else:
# return redirect("/index/")
# user_Id = request.session.get('user_Id','')
# user_Role = request.session.get('user_role','')
# if user_Id > 0 and len(user_Role) > 0: #判断是否登录
# try:
# user = User.objects.get(Id=user_Id)
# if user.Role == user_Role:
# return func(request)
# else:
# # Logout(request)
# # return render(request, "./AEMSLite/templates/login/login.html")
# # return render(request, "login/login.html")
# return restful.params_error(data={'user_Id': user_Id, 'user_Role': user_Role})
# # return HttpResponseRedirect("/login/")
# except Exception as e:
# return restful.params_error(data={'e': repr(e)})
# else:#如果没登录就跳转到登录界面
# return restful.params_error(data={'user_Id':user_Id,'user_Role':user_Role})
return func(request)
def analysis_query_tab_info(request):
if request.method == "POST":
try:
startTime = request.POST['begin']
endTime = request.POST['end']
stage = request.POST['stage']
fixture = request.POST['fixture']
usn = request.POST['usn']
result = request.POST['result']
sql = 'SELECT * FROM "PartItemResult" where 1=1 '
if stage != "":
sql = sql + 'AND "Stage"= \'' + stage + '\''
if fixture != "":
sql = sql + 'AND "FixtureId"=\'' + fixture + '\''
if usn != "":
sql = sql + 'AND "USN"=\'' + usn + '\''
if result != "":
sql = sql + 'AND "USN"=\'' + result + '\''
if startTime != "":
sql = sql + 'AND "TrnDate" >=\'' + startTime + '\''
if endTime != "":
sql = sql + 'AND "TrnDate" <=\'' + endTime + '\''
cur = connection.cursor()
cur.execute(sql)
data = cur.fetchall()
return restful.ok(data=data)
except:
return restful.params_error(message="query data is null")
def get(self, request):
#这里是获取近一周的数据，但是由于数据没有更新，所以捞取全部当前300天的数据，后面进行修改天数
end_time = datetime.now()
delta = timedelta(days=300)
start_time = end_time - delta
dict_data = {}
data = PartItem.objects.order_by("Id").filter(
TrnDate__range=(start_time, end_time))
data = list(data.values())
# start_time = str(datetime.now()).split(' ')[0]
# start_time = datetime.strptime(start_time, "%Y-%m-%d")
# #计算保养次数和保养日期达不达标
# for i in range(0,len(data)):
# if data[i]['NextCheckDate'] == None and data[i]['NextCheckCount'] ==0:
# data[i]['NextCheckDate'] = data[i]['CreatedTime'].split(' ')[0]
# data[i]['stand_date'] = 0
# data[i]['stand_count'] = 0
# else:
# time_u = datetime.strptime(str(data[i]['NextCheckDate']).split(' ')[0], "%Y-%m-%d")
# days = time_u - start_time
# data[i]['stand_date'] = days.days
# data[i]['stand_count'] = data[i]['NextCheckCount'] - data[i]['UsedTimes']
dict_data['data'] = data
try:
return restful.ok(data=dict_data)
except Exception as e:
return restful.params_error(message=repr(e))
def maintain_setup_by_pn(request):
if request.method == "POST":
main_pn = request.POST['main_partname']
main_count = request.POST['main_count']
main_day = request.POST['main_day']
main_date = request.POST['main_date']
try:
result = PartItem.objects.filter(PN=main_pn)
if len(restful) > 0:
result.update(CheckCycleCount=main_count,
CheckCycle=main_day,
NextCheckDate=main_date)
return restful.ok(message="maintain modify success")
return restful.params_error(message="PN query is null")
except:
return restful.params_error(message="PN query is null")
def post(self, request):
maintain_count = request.POST['maintain_count']
maintain_date = request.POST['maintain_date']
maintain_receiver = request.POST.getlist('maintain_receiver[]')
maintain_receiver = list(maintain_receiver)
try:
parameter_count = Configuration.objects.filter(Type="mt_count")
parameter_date = Configuration.objects.filter(Type="mt_date")
mail_receiver_count = ",".join(maintain_receiver)
if parameter_count and parameter_date:
Configuration.objects.filter(Type="mt_count").update(
Max=maintain_count, Min=0, Reminders=mail_receiver_count)
Configuration.objects.filter(Type="mt_date").update(
Max=maintain_date, Min=0, Reminders=mail_receiver_count)
return restful.ok(message="setup parameter success")
else:
Configuration.objects.create(Type="mt_count",
Max=maintain_count,
Min=0,
Reminders=mail_receiver_count)
Configuration.objects.create(Type="mt_date",
Max=maintain_date,
Min=0,
Reminders=mail_receiver_count)
return restful.ok(message="setup parameter create success")
except:
return restful.params_error(message="setup information error")
def delete_department(request):
if request.method == "POST":
depart_name = request.POST['delPart']
try:
budget_code = BudgetCodeForm.objects.exclude(
Status="Approve").filter(Department=depart_name)
if len(budget_code) != 0:
return restful.params_error(
message="department had using can't delete")
else:
depart = Department.objects.get(Department=depart_name)
depart.IsActivated = False
depart.save()
return restful.ok(message='department delete success')
except:
return restful.params_error(message='please connect admin')
def get(self, request):
try:
start = datetime.now()
# delta = timedelta(days=20)
# end = start - delta
#数据选择区间
start_select = (list(
PartItemResult.objects.order_by("-TrnDate").filter(
TrnDate__lte=start).values("TrnDate")))[0]['TrnDate']
delta_select = timedelta(days=7)
end_select = start_select - delta_select
time_select_sql = ' to_char("TrnDate",\'yyyy-MM-dd\') >= \'' + end_select.strftime(
"%Y-%m-%d"
) + '\' and to_char("TrnDate",\'yyyy-MM-dd\') <= \'' + start_select.strftime(
"%Y-%m-%d") + '\''
visua_data = {} #柱状图需要的数据
li = []
sql1 = 'SELECT "ErrorCode", COUNT("SN") FROM "PartItemResult" where ' + time_select_sql + ' AND "Result"= \'FAIL\' GROUP BY "ErrorCode" ORDER BY -COUNT(*)'
cur = connection.cursor()
cur.execute(sql1)
visua_data['errorcode'] = cur.fetchall()
sql2 = 'SELECT "PartName", COUNT("SN") FROM "PartItemResult" where' + time_select_sql + ' GROUP BY "PartName" ORDER BY -COUNT("SN")'
cur = connection.cursor()
cur.execute(sql2)
visua_data['Partname'] = cur.fetchall()
range_area = Configuration.objects.filter(
Type="at_count").order_by("Min") #查用户设定的次数
if len(range_area) != 0:
range_sql = 'SELECT COUNT("SN") FROM "PartItemResult" where ' + time_select_sql + ' AND "Result"= \'FAIL\''
for i in range(len(range_area)):
range_data = range_sql + ' AND "UsedTimes">=\'' + str(
int(range_area[i].Min
)) + '\' AND "UsedTimes"<=\'' + str(
int(range_area[i].Max)) + '\''
cur = connection.cursor()
cur.execute(range_data)
rank = cur.fetchall()
new = [
str(int(range_area[i].Min)) + '~' +
str(int(range_area[i].Max)), rank[0][0]
]
li.append(new)
visua_data['user'] = li
else:
sql3 = 'SELECT COUNT("SN") FROM "PartItemResult" where ' + time_select_sql + ' AND "Result"= \'FAIL\' and "UsedTimes">0'
cur = connection.cursor()
cur.execute(sql3)
rankelse = cur.fetchall()
visua_data['user'] = ['0~0', rankelse[0][0]]
sql4 = 'SELECT COUNT("SN"),"PartName" FROM (select distinct "SN","PartName","Result" from "PartItemResult" WHERE ' + time_select_sql + ') as foo where "Result"= \'FAIL\' GROUP BY "PartName" ORDER BY -COUNT("SN")'
cur = connection.cursor()
cur.execute(sql4)
visua_data['filterSN'] = cur.fetchall()
visua_data['select_start'] = start_select
visua_data['select_end'] = end_select
return restful.ok(data=visua_data)
except Exception as e:
return restful.params_error(repr(e))
def Import_SN(request):
if request.method == "POST":
try:
UpdatedTime = datetime.now().strftime('%Y-%m-%d %H:%M:%S')
SN = request.POST['import_SNs']
if len(SerialNumberInfo.objects.filter(SerialNumber=SN).values("Id")) == 0:
scrapy_sn = Scrapy_SN(SN)
if len(scrapy_sn) != 0:
for item in scrapy_sn:
SerialNumberInfo.objects.create(SerialNumber=item["BarCode"],PartCode=item["PartCode"],UpdatedTime=UpdatedTime)
return restful.ok(data=scrapy_sn[0],message="data import success")
else:
return restful.params_error(message="AEMS no this "+SN)
else:
return restful.params_error(message=SN+" had exist in AEMSLite system")
except:
return restful.params_error(message="error")
def ReleaseAllPartCode(request):
try:
if request.method == "POST":
models_bindingSN = request.POST.get('models_ids')
#查询SN的信息
if models_bindingSN !="":
sns = models_bindingSN.split(",")
Sn_obj = list(SerialNumberInfo.objects.filter(SerialNumber__in=tuple(sns)).values("BoxIdBindingId"))
Sn_count = SerialNumberInfo.objects.filter(BoxIdBindingId=Sn_obj[0]["BoxIdBindingId"]).count()
if Sn_count == len(sns):
Box.objects.filter(Id=Sn_obj[0]["BoxIdBindingId"]).update(ModelStageId=None)
SerialNumberInfo.objects.filter(SerialNumber__in=tuple(sns)).update(BoxIdBindingId=None)
return restful.ok(message="Batch operation successful")
else:
return restful.params_error(message="submit SN no need unbinding")
except Exception as e:
return restful.params_error(message=e)