def rotation_update(request, index):
db, cur = db_open()
sql = "SELECT Rotation FROM tkb_employee_matrix where Id='%s'" % (index)
cur.execute(sql)
tmp = cur.fetchall()
tmp2 = tmp[0]
#return render(request, "test99_1.html", {'test':tmp})
level = int(tmp2[0])
new_level = 0
if level == 0:
new_level = 1
if level == 1:
new_level = 0
level = new_level
mql = ('update tkb_employee_matrix SET Rotation="%s" WHERE Id="%s"' %
(level, index))
cur.execute(mql)
db.commit()
db.close()
return render(request, "done_rotation.html")
def email_manual1(tmp,reason):
db, cursor = db_open()
b = "\r\n"
ctr = 0
message_subject = reason
message = ""
#toaddrs = ["[email protected],[email protected]","*****@*****.**","*****@*****.**","*****@*****.**","*****@*****.**","*****@*****.**","*****@*****.**","*****@*****.**","*****@*****.**","*****@*****.**","*****@*****.**","*****@*****.**","*****@*****.**"]
toaddrs = ["*****@*****.**"]
fromaddr = '*****@*****.**'
frname = 'Dave'
server = SMTP('smtp.gmail.com', 587)
server.ehlo()
server.starttls()
server.ehlo()
server.login('*****@*****.**', 'stacktest6060')
message = "From: %s\r\n" % frname + "To: %s\r\n" % ', '.join(toaddrs) + "Subject: %s\r\n" % message_subject + "\r\n"
message = message + message_subject + "\r\n\r\n" + "\r\n\r\n"
# message = message + "Name" + " || " + "Job" + " || " + "Count" + " || " + "Target" + " || " + "Date " + " || " + "Shift" + b + b
# message = message + " --------------------------------------------------------------------------------" + b
# message = message + str(tmp)
# h = 6 / 0
for x in tmp:
nm = (str(x[9]))
# nm = int(nm)
try:
zql = "SELECT * FROM tkb_users where Clock = '%s'" %(nm)
cursor.execute(zql)
zmp = cursor.fetchall()
zzmp = zmp[0]
nm = zzmp[2]
except:
nm = "Clock " + str(x[9])
a1 = "Name:"+nm
a2 = "Job:"+str(x[1])
a3 = "Count:"+str(x[4])
a4 = "Target:"+str(x[13])
a5 = "Date:"+str(x[10])
a6 = "Shift:"+str(x[11])
# a1 = string_make(str(x[9]),7)
# a2 = str(x[1])
# a3 = string_make(str(x[4]),7)
# a4 = string_make(str(x[13]),8)
# a5 = str(x[10])
# a6 = str(x[11])
# a7 = str(ctr)
ctr = ctr + 1
b = "\r\n"
message = message + a1 + " " + a2 + " " + a3 + " " + a4 + " " + a5 + " " + a6 + b + b
# message = message + x[8] + " " + x[1] + " " + x[4] + ":" + x[3] + " " + "\r\n\r\n"
m_ctr = 4
server.sendmail(fromaddr, toaddrs, message)
server.quit()
db.close()
return
def set_rotation(request):
db, cur = db_open()
x = 0
mql = ('update tkb_employee_matrix SET Rotation="%s"' % (x))
cur.execute(mql)
db.commit()
db.close()
return render(request, "done_test.html")
def update_matrix_save(tmp):
db, cur =db_open()
for i in tmp:
i_var = int(i[:-1])
i_val = int(i[-1:])
sql = ('update tkb_employee_matrix SET Level = "%s" WHERE Id="%s"' % (i_val,i_var))
cur.execute(sql)
db.commit()
db.close()
return
def time_write():
t = int(time.time())
db, cur = db_open()
i = 101
mach = 555
part = 'time_update'
x = 1
a = '1'
cur.execute(
'''insert into tkb_prodtrak(pi_id,part_number,machine,part_timestamp,autotime,last_time_diff) VALUES(%s,%s,%s,%s,%s,%s)''',
(i, part, part, t, mach, mach))
db.commit()
db.close()
return
def machine_list_display(): global st, nt, pt db, cur = db_open() sql = "SELECT * FROM tkb_robot_list" cur.execute(sql) tmp = cur.fetchall() db.close() st = [] nt = [] pt = [] [robot_tup(x) for x in tmp] rlist = nt rlist = zip(nt,st,pt) #rlist.append(st) #rlist.append(pt) #rlist = zip(nt,st,pt) return rlist
def kiosk_lastpart_find(asset):
try:
ml = 4
db, cur = db_open()
a1sql = "SELECT MAX(id) FROM sc_production1 WHERE asset_num = '%s' and length(partno) > '%d'" % (
asset, ml)
cur.execute(a1sql)
tp3 = cur.fetchall()
tp4 = tp3[0]
tp5 = tp4[0]
a2sql = "Select partno From sc_production1 WHERE id = '%d'" % (tp5)
cur.execute(a2sql)
tp3 = cur.fetchall()
tp4 = tp3[0]
part = tp4[0]
db.close()
except:
part = ""
# part = "" # Use this if you want to test default part to blank
return part
def matrix_update(request, index):
db, cur = db_open()
sql = "SELECT Level,Rotation FROM tkb_employee_matrix where Id='%s'" % (
index)
cur.execute(sql)
tmp = cur.fetchall()
tmp2 = tmp[0]
level = int(tmp2[0])
rotation = int(tmp2[1])
#return render(request, "test22.html",{'level':level})
new_level = 0
if level == 0:
new_level = 1
if level == 1:
new_level = 2
if level == 2:
new_level = 0
rotation = 0
if level == 3:
new_level = 0
level = new_level
mql = (
'update tkb_employee_matrix SET Level="%s", Rotation="%s" WHERE Id="%s"'
% (level, rotation, index))
cur.execute(mql)
db.commit()
db.close()
return render(request, "matrix_display_refresh.html")