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")