def minchangeloc(request):
if 'realtag' in request.GET and request.GET['realtag']:
realtag = request.GET['realtag']
else:
realtag = ""
if 'lane' in request.GET and request.GET['lane']:
ilane = request.GET['lane']
else:
ilane = ""
if 'pos' in request.GET and request.GET['pos']:
ipos = request.GET['pos']
else:
ipos = ""
if 'pcode' in request.GET and request.GET['pcode']:
ipcode = request.GET['pcode']
else:
ipcode = ""
if 'width' in request.GET and request.GET['width']:
iwidth = request.GET['width']
else:
iwidth = ""
if 'loss' in request.GET and request.GET['loss']:
iloss = request.GET['loss']
else:
iloss = ""
if int(ipos) <= 43:
query = PaperRoll.objects.filter(id=realtag).values_list('paper_code', 'width', 'wunit', 'initial_weight', 'temp_weight')[0]
qlist = list(query)
paper_code = qlist[0]
width = qlist[1]
wunit = qlist[2]
initial_weight = qlist[3]
temp_weight = qlist[4]
p = PaperRoll(id=realtag, width=width, wunit=wunit, initial_weight=initial_weight, temp_weight=temp_weight)
p.paper_code = paper_code
p.width = width
p.wunit = wunit
p.initial_weight = initial_weight
p.temp_weight = temp_weight
p.lane = ilane
p.position = ipos
p.save()
# realtag = ""
response = "/stock/?pcode="+str(ipcode)+"&width="+str(iwidth)+"&loss="+str(iloss)+"&clamping=no&changed=yes"
else:
err = ""
error = "Your submitted position is not between 1 and 43."
return render_to_response('submit_error.html', locals())
return HttpResponseRedirect(response)
def changeloc(request):
if 'realtag' in request.GET and request.GET['realtag']:
realtag = request.GET['realtag']
else:
return HttpResponseRedirect('/clamplift/')
if 'lane' in request.GET and request.GET['lane']:
ilane = request.GET['lane']
else:
return HttpResponseRedirect('/clamplift/')
if 'pos' in request.GET and request.GET['pos']:
ipos = request.GET['pos']
else:
return HttpResponseRedirect('/clamplift/')
availoc = ['1A','1B','1C']
availoc = availoc + ['2A','2B','2C']
availoc = availoc + ['3A','3B','3C','3D','3E','3F','3G','3H']
availoc = availoc + ['4A','4B','4C','4D','4E','4F','4G','4H']
availoc = availoc + ['5A','5B','5C','5D','5E','5F','5G','5H']
availoc = availoc + ['6A','6B','6C','6D','6E','6F','6G','6H']
availoc = availoc + ['7A']
availoc = availoc + ['8A','8B','8C','8D','8E','8F','8G','8H']
availoc = availoc + ['9A','9B','9C','9D','9E','9F','9G','9H']
availoc = availoc + ['10A','10B','10C']
availoc = availoc + ['11A','11B','11C']
availoc = availoc + ['12A','12B','12C']
availoc = availoc + ['13A','13B','13C']
iposlane = str(ipos) + ilane
if iposlane in availoc:
query = PaperRoll.objects.filter(id=realtag).values_list('paper_code', 'width', 'wunit', 'initial_weight', 'temp_weight')[0]
qlist = list(query)
paper_code = qlist[0]
width = qlist[1]
wunit = qlist[2]
initial_weight = qlist[3]
temp_weight = qlist[4]
p = PaperRoll(id=realtag, width=width, wunit=wunit, initial_weight=initial_weight, temp_weight=temp_weight)
p.paper_code = paper_code
p.width = width
p.wunit = wunit
p.initial_weight = initial_weight
p.temp_weight = temp_weight
p.lane = ilane
p.position = ipos
p.save()
else:
err = ""
error = "Your submitted location is not available in the map."
return render_to_response('submit_error.html', locals())
return HttpResponseRedirect('/clamplift/')
def scale(request):
# Connect serial port #
try:
weight = 'None'
operating_mode = 'real' # Operating mode = {'real', 'fake'} #
scale_mode = 'fake'
if scale_mode == 'real':
ser = serial.Serial()
ser.port = '/dev/ttyUSB0'
ser.baudrate = 2400
ser.bytesize = 7
ser.parity = 'E'
ser.stopbits = 1
ser.timeout = 2
ser.open()
ser.flushInput()
output = ser.readline()
ser.close()
a = output.rsplit(",")
if len(a) == 3:
if a[0] == 'US':
b = a[2]
if b[0:1] == '+':
c = b[-11:]
d = c[:-4]
weight = float(d)
digital = str(weight)
if len(digital) == 7:
digit1 = digital[0:1]
digit2 = digital[1:2]
digit3 = digital[2:3]
digit4 = digital[3:4]
digit5 = digital[4:5]
digit6 = digital[5:6]
digit7 = digital[6:7]
if len(digital) == 6:
digit2 = digital[0:1]
digit3 = digital[1:2]
digit4 = digital[2:3]
digit5 = digital[3:4]
digit6 = digital[4:5]
digit7 = digital[5:6]
if len(digital) == 5:
digit3 = digital[0:1]
digit4 = digital[1:2]
digit5 = digital[2:3]
digit6 = digital[3:4]
digit7 = digital[4:5]
if len(digital) == 4:
digit4 = digital[0:1]
digit5 = digital[1:2]
digit6 = digital[2:3]
digit7 = digital[3:4]
if len(digital) == 3:
digit5 = digital[0:1]
digit6 = digital[1:2]
digit7 = digital[2:3]
else:
serror = "[The weight is negative.]"
else:
serror = "[The weight is overloaded.]"
else:
serror = "[Data sent is not complete.]"
if scale_mode == 'fake':
output = "US,NT,+00325.5Kg\r\n"
weight = round(random.uniform(1,500),0)
digital = str(weight)
if len(digital) == 7:
digit1 = digital[0:1]
digit2 = digital[1:2]
digit3 = digital[2:3]
digit4 = digital[3:4]
digit5 = digital[4:5]
digit6 = digital[5:6]
digit7 = digital[6:7]
if len(digital) == 6:
digit2 = digital[0:1]
digit3 = digital[1:2]
digit4 = digital[2:3]
digit5 = digital[3:4]
digit6 = digital[4:5]
digit7 = digital[5:6]
if len(digital) == 5:
digit3 = digital[0:1]
digit4 = digital[1:2]
digit5 = digital[2:3]
digit6 = digital[3:4]
digit7 = digital[4:5]
if len(digital) == 4:
digit4 = digital[0:1]
digit5 = digital[1:2]
digit6 = digital[2:3]
digit7 = digital[3:4]
if len(digital) == 3:
digit5 = digital[0:1]
digit6 = digital[1:2]
digit7 = digital[2:3]
# Connect RFID reader #
if operating_mode == 'real':
realtag = 'None'
HOST = '192.41.170.55' # CSIM network
# HOST = '192.168.101.55' # Likitomi network
# HOST = '192.168.1.55' # My own local network: Linksys
# HOST = '192.168.2.88' # In Likitomi factory
PORT = 50007
soc = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
soc.settimeout(2)
soc.connect((HOST, PORT))
## soc.send('setup.operating_mode = standby\r\n')
soc.send('tag.db.scan_tags(1000)\r\n')
datum = soc.recv(128)
if datum.find("ok") > -1:
soc.send('tag.read_id()\r\n')
data = soc.recv(8192)
tagdata = data.split("\r\n")
idlist = list()
loclist = list()
for tag in tagdata:
# if "AAAA" in tag:
# idlist.append(tag)
# if "BBBB" in tag:
# loclist.append(tag)
if "type=STG" in tag or "AAAA" in tag:
idlist.append(tag)
if "type=ISOC" and "AAAA" not in tag or "BBBB" in tag:
loclist.append(tag)
cnt = 0
tagid_A = list()
type_A = list()
antenna_A = list()
repeat_A = list()
for id1 in idlist:
id2 = id1.replace("(","")
id2 = id2.replace(")","")
id3 = id2.split(", ")
for id4 in id3:
id5 = id4.split("=")
if id5[0]=="tag_id":tagid_A.append(id5[1])
elif id5[0]=="type":type_A.append(id5[1])
elif id5[0]=="antenna": antenna_A.append(id5[1])
elif id5[0]=="repeat": repeat_A.append(id5[1])
cnt= cnt+1
tagid_B = list()
type_B = list()
antenna_B = list()
repeat_B = list()
for loc1 in loclist:
loc2 = loc1.replace("(","")
loc2 = loc2.replace(")","")
loc3 = loc2.split(", ")
for loc4 in loc3 :
loc5 = loc4.split("=")
if loc5[0]=="tag_id": tagid_B.append(loc5[1])
elif loc5[0]=="type": type_B.append(loc5[1])
elif loc5[0]=="antenna": antenna_B.append(loc5[1])
elif loc5[0]=="repeat": repeat_B.append(loc5[1])
cnt= cnt+1
repeat_AA = list()
for rep_A in repeat_A:
repeat_AA.append(int(rep_A))
if max(repeat_AA) in repeat_AA:
n = repeat_AA.index(max(repeat_AA))
# tagsplt = tagid_A[n].split("AAAA")
# realtag = int(tagsplt[1][0:4])
realtag = tagid_A[n][7:11]
soc.close()
if operating_mode == 'fake':
realtag = '0067'
# Query database #
if realtag != 'None':
query1 = PaperRoll.objects.filter(id=realtag).values_list('paper_code', 'width', 'wunit', 'initial_weight', 'lane', 'position')[0]
paper_code = query1[0]
size = query1[1]
uom = query1[2]
initial_weight = query1[3]
lane = query1[4]
position = query1[5]
query2 = PaperHistory.objects.filter(roll_id=realtag).order_by('-timestamp').values_list('last_wt')
exists = PaperHistory.objects.filter(roll_id=realtag).exists()
int_weight = int(weight)
if exists == True:
actual_wt = int(list(query2)[0][0])
else:
actual_wt = initial_weight
if weight != 'None':
used_weight = actual_wt - int(weight)
# Update temp_weight to database #
p = PaperRoll(id=realtag, paper_code=paper_code, width=size, wunit=uom, initial_weight=initial_weight, temp_weight=int_weight, lane=lane, position=position)
p.save()
else:
used_weight = ""
# Exceptions #
except serial.SerialException:
realtag = ""
paper_code = ""
size = ""
uom = ""
actual_wt = ""
used_weight = ""
serror = "[Please check serial port connection.]"
return render_to_response('scale.html', locals())
except OSError:
realtag = ""
paper_code = ""
size = ""
uom = ""
actual_wt = ""
used_weight = ""
serror = "[Serial port may conflict.]"
return render_to_response('scale.html', locals())
except ValueError:
realtag = ""
paper_code = ""
size = ""
uom = ""
actual_wt = ""
used_weight = ""
socror = "[No ID tag in field.]"
return render_to_response('scale.html', locals())
except UnboundLocalError:
realtag = ""
paper_code = ""
size = ""
uom = ""
actual_wt = ""
used_weight = ""
socror = "[Please change operating mode to 'standby'.]"
return render_to_response('scale.html', locals())
except IndexError:
realtag = ""
paper_code = ""
size = ""
uom = ""
actual_wt = ""
used_weight = ""
socror = "[Please change operating mode to 'standby'.]"
return render_to_response('scale.html', locals())
return render_to_response('scale.html', locals())
def inventory(request):
try:
if 'pcode' in request.GET and request.GET['pcode']:
pcode = request.GET['pcode']
else:
pcode = ""
if 'width' in request.GET and request.GET['width']:
width = request.GET['width']
else:
width = ""
if 'loss' in request.GET and request.GET['loss']:
loss = request.GET['loss']
losspx = int(loss)/4
if losspx > 250:
losspx = 250
lossinv = 250-losspx
else:
loss = ""
if 'clamping' in request.GET and request.GET['clamping']:
clamping = request.GET['clamping']
else:
clamping = "inv"
if 'changed' in request.GET and request.GET['changed']:
changed = request.GET['changed']
else:
changed = "inv"
query = PaperRoll.objects.filter(paper_code=pcode, width=width).values_list('id')
qexists = PaperRoll.objects.filter(paper_code=pcode, width=width).exists()
if qexists == True:
delist = list()
wlist = list()
ridlist = list()
elist = list()
dwlist = list()
ddwlist = list()
clist = list()
c1 = 0
c2 = 0
c3 = 0
c4 = 0
c1list = list()
c2list = list()
c3list = list()
c4list = list()
ablist = list()
bllist = list()
cablist = list()
cbllist = list()
dablist = list()
dbllist = list()
for item in query:
totem = list(item)
delist.append(totem)
rid = int(totem[0])
ridlist.append(rid)
exists = PaperHistory.objects.filter(roll_id=rid).exists()
elist.append(exists)
if exists == True:
weight = int(str(PaperHistory.objects.filter(roll_id=rid).order_by('-timestamp').values_list('last_wt')[0])[1:][:-3])
else:
weight = int(str(PaperRoll.objects.filter(id=rid).values_list('initial_weight')[0])[1:][:-3])
wlist.append(weight)
dwlist.append(weight)
for totem in delist:
totem.append(weight)
dwlist.sort()
dwlist.reverse()
for w in dwlist:
if w not in ddwlist:
ddwlist.append(w)
for w in wlist:
if 100 > int(w):
c1 = c1 + 1
c1list.append(w)
if 100 <= int(w) and int(w) < 400:
c2 = c2 + 1
c2list.append(w)
if 400 <= int(w) and int(w) < 700:
c3 = c3 + 1
c3list.append(w)
if 700 <= int(w):
c4 = c4 + 1
c4list.append(w)
for w in ddwlist:
c = dwlist.count(w)
clist.append(c)
for w in dwlist:
if int(w) > int(loss):
ablist.append(w)
else:
bllist.append(w)
for w in ablist:
if w not in dablist: dablist.append(w)
for w in bllist:
if w not in dbllist: dbllist.append(w)
for w in dablist:
c = ablist.count(w)
cablist.append(c)
for w in dbllist:
c = bllist.count(w)
cbllist.append(c)
initial_weight = int(str(PaperRoll.objects.filter(paper_code=pcode).values_list('initial_weight')[0])[1:][:-3])
vlane = ['1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13']
laneall = ['H','','G','F','','E','D','','C','B','','A']
posall = ['1','2','3','4','5','6','7','8','9','10','11','12','13']
posh = ['','','3','4','5','6','','8','9','','','','']
posg = ['','','3','4','5','6','','8','9','','','','']
posf = ['','','3','4','5','6','','8','9','','','','']
pose = ['1','2','3','4','5','6','','8','9','','','','']
posd = ['1','2','3','4','5','6','','8','9','','','','']
posc = ['1','2','3','4','5','6','','8','9','10','11','12','13']
posb = ['1','2','3','4','5','6','','8','9','10','11','12','13']
posa = ['1','2','3','4','5','6','7','8','9','10','11','12','13']
buff = ['1','2']
mquery = PaperRoll.objects.filter(paper_code=pcode, width=width).values_list('lane', 'position')
mexists = PaperRoll.objects.filter(paper_code=pcode, width=width).exists()
mstr = str(mquery)
mlist = list(mquery)
Alist = list()
Blist = list()
Clist = list()
Dlist = list()
Elist = list()
Flist = list()
Glist = list()
Hlist = list()
zero = [0, 0, 0, 0]
for ind,pair in enumerate(mlist):
if pair[0] == u'A':
ind1 = mlist.index(pair)
posa.pop(pair[1]-1)
posa.insert(pair[1]-1, float(str(wlist[ind1])+"."+str(pair[1])))
if str(pair[1]) not in str(Alist):
Alist.append([pair[1]])
Alist[-1].extend(zero)
for ls in Alist:
if pair[1] == ls[0]:
if 100 > wlist[ind]:
ls[1] = ls[1] + 1
elif 100 <= wlist[ind] and wlist[ind] < 400:
ls[2] = ls[2] + 1
elif 400 <= wlist[ind] and wlist[ind] < 700:
ls[3] = ls[3] + 1
elif 700 <= wlist[ind] or loss < wlist[ind] or wlist[ind] == initial_weight:
ls[4] = ls[4] + 1
elif pair[0] == u'B':
ind1 = mlist.index(pair)
posb.pop(pair[1]-1)
posb.insert(pair[1]-1, float(str(wlist[ind1])+"."+str(pair[1])))
if str(pair[1]) not in str(Blist):
Blist.append([pair[1]])
Blist[-1].extend(zero)
for ls in Blist:
if pair[1] == ls[0]:
if 100 > wlist[ind]:
ls[1] = ls[1] + 1
elif 100 <= wlist[ind] and wlist[ind] < 400:
ls[2] = ls[2] + 1
elif 400 <= wlist[ind] and wlist[ind] < 700:
ls[3] = ls[3] + 1
elif 700 <= wlist[ind] or loss < wlist[ind] or wlist[ind] == initial_weight:
ls[4] = ls[4] + 1
elif pair[0] == u'C':
ind1 = mlist.index(pair)
posc.pop(pair[1]-1)
posc.insert(pair[1]-1, float(str(wlist[ind1])+"."+str(pair[1])))
if str(pair[1]) not in str(Clist):
Clist.append([pair[1]])
Clist[-1].extend(zero)
for ls in Clist:
if pair[1] == ls[0]:
if 100 > wlist[ind]:
ls[1] = ls[1] + 1
elif 100 <= wlist[ind] and wlist[ind] < 400:
ls[2] = ls[2] + 1
elif 400 <= wlist[ind] and wlist[ind] < 700:
ls[3] = ls[3] + 1
elif 700 <= wlist[ind] or loss < wlist[ind] or wlist[ind] == initial_weight:
ls[4] = ls[4] + 1
elif pair[0] == u'D':
ind1 = mlist.index(pair)
posd.pop(pair[1]-1)
posd.insert(pair[1]-1, float(str(wlist[ind1])+"."+str(pair[1])))
if str(pair[1]) not in str(Dlist):
Dlist.append([pair[1]])
Dlist[-1].extend(zero)
for ls in Dlist:
if pair[1] == ls[0]:
if 100 > wlist[ind]:
ls[1] = ls[1] + 1
elif 100 <= wlist[ind] and wlist[ind] < 400:
ls[2] = ls[2] + 1
elif 400 <= wlist[ind] and wlist[ind] < 700:
ls[3] = ls[3] + 1
elif 700 <= wlist[ind] or loss < wlist[ind] or wlist[ind] == initial_weight:
ls[4] = ls[4] + 1
elif pair[0] == u'E':
ind1 = mlist.index(pair)
pose.pop(pair[1]-1)
pose.insert(pair[1]-1, float(str(wlist[ind1])+"."+str(pair[1])))
if str(pair[1]) not in str(Elist):
Elist.append([pair[1]])
Elist[-1].extend(zero)
for ls in Elist:
if pair[1] == ls[0]:
if 100 > wlist[ind]:
ls[1] = ls[1] + 1
elif 100 <= wlist[ind] and wlist[ind] < 400:
ls[2] = ls[2] + 1
elif 400 <= wlist[ind] and wlist[ind] < 700:
ls[3] = ls[3] + 1
elif 700 <= wlist[ind] or loss < wlist[ind] or wlist[ind] == initial_weight:
ls[4] = ls[4] + 1
elif pair[0] == u'F':
ind1 = mlist.index(pair)
posf.pop(pair[1]-1)
posf.insert(pair[1]-1, float(str(wlist[ind1])+"."+str(pair[1])))
if str(pair[1]) not in str(Flist):
Flist.append([pair[1]])
Flist[-1].extend(zero)
for ls in Flist:
if pair[1] == ls[0]:
if 100 > wlist[ind]:
ls[1] = ls[1] + 1
elif 100 <= wlist[ind] and wlist[ind] < 400:
ls[2] = ls[2] + 1
elif 400 <= wlist[ind] and wlist[ind] < 700:
ls[3] = ls[3] + 1
elif 700 <= wlist[ind] or loss < wlist[ind] or wlist[ind] == initial_weight:
ls[4] = ls[4] + 1
elif pair[0] == u'G':
ind1 = mlist.index(pair)
posg.pop(pair[1]-1)
posg.insert(pair[1]-1, float(str(wlist[ind1])+"."+str(pair[1])))
if str(pair[1]) not in str(Glist):
Glist.append([pair[1]])
Glist[-1].extend(zero)
for ls in Glist:
if pair[1] == ls[0]:
if 100 > wlist[ind]:
ls[1] = ls[1] + 1
elif 100 <= wlist[ind] and wlist[ind] < 400:
ls[2] = ls[2] + 1
elif 400 <= wlist[ind] and wlist[ind] < 700:
ls[3] = ls[3] + 1
elif 700 <= wlist[ind] or loss < wlist[ind] or wlist[ind] == initial_weight:
ls[4] = ls[4] + 1
elif pair[0] == u'H':
ind1 = mlist.index(pair)
posh.pop(pair[1]-1)
posh.insert(pair[1]-1, float(str(wlist[ind1])+"."+str(pair[1])))
if str(pair[1]) not in str(Hlist):
Hlist.append([pair[1]])
Hlist[-1].extend(zero)
for ls in Hlist:
if pair[1] == ls[0]:
if 100 > wlist[ind]:
ls[1] = ls[1] + 1
elif 100 <= wlist[ind] and wlist[ind] < 400:
ls[2] = ls[2] + 1
elif 400 <= wlist[ind] and wlist[ind] < 700:
ls[3] = ls[3] + 1
elif 700 <= wlist[ind] or loss < wlist[ind] or wlist[ind] == initial_weight:
ls[4] = ls[4] + 1
operating_mode = 'fake' # Operating mode = {'real', 'fake'} #
# clamping = 'no'
if operating_mode == 'real':
HOST = '192.41.170.55' # CSIM network
# HOST = '192.168.101.55' # Likitomi network
# HOST = '192.168.1.55' # My own local network: Linksys
# HOST = '192.168.2.88' # In Likitomi factory
PORT = 50007
soc = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
soc.settimeout(2)
soc.connect((HOST, PORT))
## soc.send('setup.operating_mode = standby\r\n')
soc.send('tag.db.scan_tags(100)\r\n')
datum = soc.recv(128)
if datum.find("ok") > -1:
soc.send('tag.read_id()\r\n')
data = soc.recv(8192)
tagdata = data.split("\r\n")
idlist = list()
loclist = list()
for tag in tagdata:
# if "AAAA" in tag:
# idlist.append(tag)
# if "BBBB" in tag:
# loclist.append(tag)
if "type=STG" in tag or "AAAA" in tag:
idlist.append(tag)
if "type=ISOC" and "AAAA" not in tag or "BBBB" in tag:
loclist.append(tag)
cnt = 0
## error = cStringIO.StringIO()
tagid_A = list()
type_A = list()
antenna_A = list()
repeat_A = list()
for id1 in idlist:
id2 = id1.replace("(","")
id2 = id2.replace(")","")
id3 = id2.split(", ")
for id4 in id3:
id5 = id4.split("=")
if id5[0]=="tag_id":tagid_A.append(id5[1])
elif id5[0]=="type":type_A.append(id5[1])
elif id5[0]=="antenna": antenna_A.append(id5[1])
elif id5[0]=="repeat": repeat_A.append(id5[1])
cnt= cnt+1
tagid_B = list()
type_B = list()
antenna_B = list()
repeat_B = list()
for loc1 in loclist:
loc2 = loc1.replace("(","")
loc2 = loc2.replace(")","")
loc3 = loc2.split(", ")
for loc4 in loc3 :
loc5 = loc4.split("=")
if loc5[0]=="tag_id": tagid_B.append(loc5[1])
elif loc5[0]=="type": type_B.append(loc5[1])
elif loc5[0]=="antenna": antenna_B.append(loc5[1])
elif loc5[0]=="repeat": repeat_B.append(loc5[1])
cnt= cnt+1
lan = 0
pos = 0
totalCount = 0
if len(repeat_B) > 0 :
cnt = 0
for rep in repeat_B:
if type_B[cnt] == "ISOC":
# lindex = int(tagid_B[cnt][26:28])
prelindex = tagid_B[cnt][25:27]
if prelindex == 'AB': lindex = 1
if prelindex == 'CD': lindex = 2
if prelindex == 'EF': lindex = 3
if prelindex == 'FF': lindex = 4
if prelindex == 'CC': lindex = 0
if prelindex == 'DD': lindex = 5
pindex = int(tagid_B[cnt][27:30])
lan += float(lindex)*float(repeat_B[cnt])
pos += float(pindex)*float(repeat_B[cnt])
totalCount += float(repeat_B[cnt])
cnt = cnt+1
if totalCount > 0:
L = int(round(lan/totalCount,0))
P = int(round(pos/totalCount,0))
else:
L = 0
P = 0
# if P >= 1 and P <= 3: P = 1
# if P >= 4 and P <= 6: P = 2
# if P >= 7 and P <= 9: P = 3
# if P >= 10 and P <= 12: P = 4
# if P >= 13 and P <= 15: P = 5
# if P >= 16 and P <= 18: P = 6
# if P >= 19 and P <= 21: P = 7
# if P >= 22 and P <= 24: P = 8
# if P >= 25 and P <= 27: P = 9
# if P >= 28 and P <= 30: P = 10
# if P >= 31 and P <= 33: P = 11
# if P >= 34 and P <= 36: P = 12
# if P >= 37: P = 13
atlane = str(L)
atposition = str(P)
atlocation = ''
if L == 0:
atlocation = 'CR'
if L == 5:
atlocation = 'Scale'
if L in range(1, 5):
atlocation = 'Stock'
if L == 0 and P == 0:
atlane = ""
atposition = ""
atlocation = ""
toperror = "[No location tag in field.]"
for p in vlane:
if p == atposition:
ind = vlane.index(p)
vlane.remove(p)
vlane.insert(ind, '*')
repeat_AA = list()
for rep_A in repeat_A:
repeat_AA.append(int(rep_A))
if max(repeat_AA) in repeat_AA:
n = repeat_AA.index(max(repeat_AA))
tagsplt = tagid_A[n].split("AAAA")
realtag = int(tagsplt[1][0:4])
realtag = tagid_A[n][7:11]
soc.close()
if operating_mode == 'fake':
# atlane = '5'
# atposition = '5'
# atlocation = 'Scale'
atlane = '2'
atposition = '3'
atlocation = 'Stock'
vlane = ['1', '2', '*', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13']
# atlane = '1'
# atposition = '5'
# atlocation = 'Stock'
# vlane = ['1', '2', '3', '4', '*', '6', '7', '8', '9', '10', '11', '12', '13']
realtag = 67
query1 = PaperRoll.objects.filter(id=realtag).values_list('lane', 'position', 'paper_code', 'width')[0]
lane = query1[0]
position = str(query1[1])
rpcode = query1[2]
rwidth = query1[3]
if pcode != rpcode or width != rwidth:
query2 = PaperRoll.objects.filter(paper_code=rpcode, width=rwidth).values_list('id')
qexists2 = PaperRoll.objects.filter(paper_code=rpcode, width=rwidth).exists()
if qexists2 == True:
delist2 = list()
wlist2 = list()
ridlist2 = list()
elist2 = list()
dwlist2 = list()
ddwlist2 = list()
clist2 = list()
c12 = 0
c22 = 0
c32 = 0
c42 = 0
c1list2 = list()
c2list2 = list()
c3list2 = list()
c4list2 = list()
ablist2 = list()
bllist2 = list()
cablist2 = list()
cbllist2 = list()
dablist2 = list()
dbllist2 = list()
for item in query2:
totem = list(item)
delist2.append(totem)
rid = int(totem[0])
ridlist2.append(rid)
exists = PaperHistory.objects.filter(roll_id=rid).exists()
elist2.append(exists)
if exists == True:
weight = int(str(PaperHistory.objects.filter(roll_id=rid).order_by('-timestamp').values_list('last_wt')[0])[1:][:-3])
else:
weight = int(str(PaperRoll.objects.filter(id=rid).values_list('initial_weight')[0])[1:][:-3])
wlist2.append(weight)
dwlist2.append(weight)
for totem in delist2:
totem.append(weight)
dwlist2.sort()
dwlist2.reverse()
for w in dwlist2:
if w not in ddwlist2:
ddwlist2.append(w)
for w in wlist2:
if 100 > int(w):
c12 = c12 + 1
c1list2.append(w)
if 100 <= int(w) and int(w) < 400:
c22 = c22 + 1
c2list2.append(w)
if 400 <= int(w) and int(w) < 700:
c32 = c32 + 1
c3list2.append(w)
if 700 <= int(w):
c42 = c42 + 1
c4list2.append(w)
for w in ddwlist2:
c = dwlist2.count(w)
clist2.append(c)
for w in dwlist2:
if int(w) > int(loss):
ablist2.append(w)
else:
bllist2.append(w)
for w in ablist2:
if w not in dablist2: dablist2.append(w)
for w in bllist2:
if w not in dbllist2: dbllist2.append(w)
for w in dablist2:
c = ablist2.count(w)
cablist2.append(c)
for w in dbllist2:
c = bllist2.count(w)
cbllist2.append(c)
# initial_weight2 = int(str(PaperRoll.objects.filter(paper_code=rpcode).values_list('initial_weight')[0])[1:][:-3])
mquery2 = PaperRoll.objects.filter(paper_code=rpcode, width=rwidth).values_list('lane', 'position')
mexists2 = PaperRoll.objects.filter(paper_code=rpcode, width=rwidth).exists()
mstr2 = str(mquery2)
mlist2 = list(mquery2)
zero8 = [0, 0, 0, 0, 0, 0, 0, 0]
for ind,pair in enumerate(mlist2):
if pair[0] == u'A':
ind1 = mlist2.index(pair)
posa.pop(pair[1]-1)
posa.insert(pair[1]-1, float(str(wlist2[ind1])+"."+str(pair[1])))
if str(pair[1]) not in str(Alist):
Alist.append([pair[1]])
Alist[-1].extend(zero8)
Alist[-1].extend(zero)
for ls in Alist:
if pair[1] == ls[0]:
if 100 > wlist2[ind]:
ls[5] = ls[5] + 1
elif 100 <= wlist2[ind] and wlist2[ind] < 400:
ls[6] = ls[6] + 1
elif 400 <= wlist2[ind] and wlist2[ind] < 700:
ls[7] = ls[7] + 1
elif 700 <= wlist2[ind] or loss < wlist2[ind] or wlist2[ind] == initial_weight2:
ls[8] = ls[8] + 1
elif pair[0] == u'B':
ind1 = mlist2.index(pair)
posb.pop(pair[1]-1)
posb.insert(pair[1]-1, float(str(wlist2[ind1])+"."+str(pair[1])))
if str(pair[1]) not in str(Blist):
Blist.append([pair[1]])
Blist[-1].extend(zero8)
Blist[-1].extend(zero)
for ls in Blist:
if pair[1] == ls[0]:
if 100 > wlist2[ind]:
ls[5] = ls[5] + 1
elif 100 <= wlist2[ind] and wlist2[ind] < 400:
ls[6] = ls[6] + 1
elif 400 <= wlist2[ind] and wlist2[ind] < 700:
ls[7] = ls[7] + 1
elif 700 <= wlist2[ind] or loss < wlist2[ind] or wlist2[ind] == initial_weight2:
ls[8] = ls[8] + 1
elif pair[0] == u'C':
ind1 = mlist2.index(pair)
posc.pop(pair[1]-1)
posc.insert(pair[1]-1, float(str(wlist2[ind1])+"."+str(pair[1])))
if str(pair[1]) not in str(Clist):
Clist.append([pair[1]])
Clist[-1].extend(zero8)
Clist[-1].extend(zero)
for ls in Clist:
if pair[1] == ls[0]:
if 100 > wlist2[ind]:
ls[5] = ls[5] + 1
elif 100 <= wlist2[ind] and wlist2[ind] < 400:
ls[6] = ls[6] + 1
elif 400 <= wlist2[ind] and wlist2[ind] < 700:
ls[7] = ls[7] + 1
elif 700 <= wlist2[ind] or loss < wlist2[ind] or wlist2[ind] == initial_weight2:
ls[8] = ls[8] + 1
elif pair[0] == u'D':
ind1 = mlist2.index(pair)
posd.pop(pair[1]-1)
posd.insert(pair[1]-1, float(str(wlist2[ind1])+"."+str(pair[1])))
if str(pair[1]) not in str(Dlist):
Dlist.append([pair[1]])
Dlist[-1].extend(zero8)
Dlist[-1].extend(zero)
for ls in Dlist:
if pair[1] == ls[0]:
if 100 > wlist2[ind]:
ls[5] = ls[5] + 1
elif 100 <= wlist2[ind] and wlist2[ind] < 400:
ls[6] = ls[6] + 1
elif 400 <= wlist2[ind] and wlist2[ind] < 700:
ls[7] = ls[7] + 1
elif 700 <= wlist2[ind] or loss < wlist2[ind] or wlist2[ind] == initial_weight2:
ls[8] = ls[8] + 1
elif pair[0] == u'E':
ind1 = mlist2.index(pair)
pose.pop(pair[1]-1)
pose.insert(pair[1]-1, float(str(wlist2[ind1])+"."+str(pair[1])))
if str(pair[1]) not in str(Elist):
Elist.append([pair[1]])
Elist[-1].extend(zero8)
Elist[-1].extend(zero)
for ls in Elist:
if pair[1] == ls[0]:
if 100 > wlist2[ind]:
ls[5] = ls[5] + 1
elif 100 <= wlist2[ind] and wlist2[ind] < 400:
ls[6] = ls[6] + 1
elif 400 <= wlist2[ind] and wlist2[ind] < 700:
ls[7] = ls[7] + 1
elif 700 <= wlist2[ind] or loss < wlist2[ind] or wlist2[ind] == initial_weight2:
ls[8] = ls[8] + 1
elif pair[0] == u'F':
ind1 = mlist2.index(pair)
posf.pop(pair[1]-1)
posf.insert(pair[1]-1, float(str(wlist2[ind1])+"."+str(pair[1])))
if str(pair[1]) not in str(Flist):
Flist.append([pair[1]])
Flist[-1].extend(zero8)
Flist[-1].extend(zero)
for ls in Flist:
if pair[1] == ls[0]:
if 100 > wlist2[ind]:
ls[5] = ls[5] + 1
elif 100 <= wlist2[ind] and wlist2[ind] < 400:
ls[6] = ls[6] + 1
elif 400 <= wlist2[ind] and wlist2[ind] < 700:
ls[7] = ls[7] + 1
elif 700 <= wlist2[ind] or loss < wlist2[ind] or wlist2[ind] == initial_weight2:
ls[8] = ls[8] + 1
elif pair[0] == u'G':
ind1 = mlist2.index(pair)
posg.pop(pair[1]-1)
posg.insert(pair[1]-1, float(str(wlist2[ind1])+"."+str(pair[1])))
if str(pair[1]) not in str(Glist):
Glist.append([pair[1]])
Glist[-1].extend(zero8)
Glist[-1].extend(zero)
for ls in Glist:
if pair[1] == ls[0]:
if 100 > wlist2[ind]:
ls[5] = ls[5] + 1
elif 100 <= wlist2[ind] and wlist2[ind] < 400:
ls[6] = ls[6] + 1
elif 400 <= wlist2[ind] and wlist2[ind] < 700:
ls[7] = ls[7] + 1
elif 700 <= wlist2[ind] or loss < wlist2[ind] or wlist2[ind] == initial_weight2:
ls[8] = ls[8] + 1
elif pair[0] == u'H':
ind1 = mlist2.index(pair)
posh.pop(pair[1]-1)
posh.insert(pair[1]-1, float(str(wlist2[ind1])+"."+str(pair[1])))
if str(pair[1]) not in str(Hlist):
Hlist.append([pair[1]])
Hlist[-1].extend(zero8)
Hlist[-1].extend(zero)
for ls in Hlist:
if pair[1] == ls[0]:
if 100 > wlist2[ind]:
ls[5] = ls[5] + 1
elif 100 <= wlist2[ind] and wlist2[ind] < 400:
ls[6] = ls[6] + 1
elif 400 <= wlist2[ind] and wlist2[ind] < 700:
ls[7] = ls[7] + 1
elif 700 <= wlist2[ind] or loss < wlist2[ind] or wlist2[ind] == initial_weight2:
ls[8] = ls[8] + 1
if lane == 'A' or lane == 'B' or lane == '1': lane = '1'
if lane == 'C' or lane == 'D' or lane == '2': lane = '2'
if lane == 'E' or lane == 'F' or lane == '3': lane = '3'
if lane == 'G' or lane == 'H' or lane == '4': lane = '4'
if atlane == '1':
leftlane = 'B'
rightlane = 'A'
if atlane == '2':
leftlane = 'D'
rightlane = 'C'
if atlane == '3':
leftlane = 'F'
rightlane = 'E'
if atlane == '4':
leftlane = 'H'
rightlane = 'G'
if clamping == "yes" and changed == "no":
query2 = PaperRoll.objects.filter(id=realtag).values_list('paper_code', 'width', 'wunit', 'initial_weight', 'temp_weight')[0]
qlist = list(query2)
paper_code = qlist[0]
wize = qlist[1]
wunit = qlist[2]
initial_weight = qlist[3]
temp_weight = qlist[4]
p = PaperRoll(id=realtag, width=wize, wunit=wunit, initial_weight=initial_weight, temp_weight=temp_weight)
p.paper_code = paper_code
p.width = wize
p.wunit = wunit
p.initial_weight = initial_weight
p.temp_weight = temp_weight
p.lane = atlane
p.position = atposition
p.save()
cursor = connection.cursor()
cursor.execute("""
SELECT DISTINCT paper_code
FROM weight_paperroll
ORDER BY paper_code""")
qscode = cursor.fetchall()
scode = list()
for sc in qscode:
scode.append(sc[0])
cursor.execute("""
SELECT DISTINCT width
FROM weight_paperroll
ORDER BY width""")
qswidth = cursor.fetchall()
swidth = list()
for sw in qswidth:
swidth.append(sw[0])
except:
pass
return render_to_response('inventory.html', locals())
