def get(self):
get_data = blobstore.BlobInfo.all()
fkey = get_data.fetch(get_data.count())
for dat in range(0, get_data.count()):
filekey = fkey[dat]
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(filekey).read())
v = addVesselData(wb, str(fkey[dat].filename).replace(" ", ""))
# if not (v == ""):
y = makeManifestPickle(wb)
if y["header"] == "manifest":
if not (models.Manifest().find_duplicate(y["vessel"], y["voyage"], y["port"])):
man = models.Manifest()
man.blob = filekey.key()
man.vessel_name = y["vessel"]
man.voyage = y["voyage"]
man.port = y["port"]
man.put()
# search.Index(name='Manifest').put(CreateDocument(y["vessel"], y["voyage"], y["port"], man))
# if y["vessel"]:
# search.Index(name='Manifest').put(CreateDocument(y["vessel"], y["voyage"], y["port"], str(man.key)))
for c in range(5, y["numrows"]):
SaveManifestDetail(man.key, y, c, man.vessel_name, man.voyage, man.port)
else:
y = "y"
params = {"y": y}
return self.render_template("testman.html", **params)
def get(self):
get_data = blobstore.BlobInfo.all()
fkey = get_data.fetch(get_data.count())
for dat in range(0, get_data.count()):
filekey = fkey[dat]
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(filekey).read())
y = makeManifestPickle(wb)
if (y["header"] == "manifest"):
if not (models.Manifest().find_duplicate(y["vessel"],y["voyage"],y["port"])):
man = models.Manifest()
man.blob = filekey.key()
man.vessel_name = y["vessel"]
man.voyage = y["voyage"]
man.port = y["port"]
man.put()
# search.Index(name='Manifest').put(CreateDocument(y["vessel"], y["voyage"], y["port"], man))
if y["vessel"]:
search.Index(name='Manifest').put(CreateDocument(y["vessel"], y["voyage"], y["port"], str(man.key)))
for c in range(5, y["numrows"]):
SaveManifestDetail(man.key, y, c, man.vessel_name, man.voyage, man.port)
else:
y="y"
params = {
"y": y,
}
return self.render_template("testman.html", **params)
def readingList(filekey):
dictd = lambda: defaultdict(dictd)
y = dictd()
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(filekey).read())
sh = wb.sheet_by_index(int(sheet_name))
#find col were readings start
for a in range(0, 10):
y["DAT"] = sh.cell_value(row, a)
try:
if "Dat/Sup" in y["DAT"]:
start_col = a+1
except:
pass
row = int(row)
cols = sh.ncols
y["filename"] = blobstore.BlobInfo.get(filekey).filename
y["product"] = sh.cell_value(10,1)
end_col = 22
params = {
"y": y,
}
return params
def get(self, keyval):
resource = str(urllib.unquote(keyval))
blob_info = blobstore.BlobInfo.get(resource)
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(blob_info.key()).read())
v = addVesselData(wb, blob_info.filename.replace(" ", ""))
y = makeManifestPickle(wb)
if (y["header"] == "manifest"):
if not (models.Manifest().find_duplicate(y["vessel"],y["voyage"],y["port"])):
man = models.Manifest()
man.blob = blob_info.key()
man.vessel_name = y["vessel"]
man.voyage = y["voyage"]
man.port = y["port"]
man.put()
for c in range(5, y["numrows"]):
SaveManifestDetail(man.key, y, c, man.vessel_name, man.voyage, man.port)
else:
y="Manifest added already"
params = {
"y": y,
}
return self.render_template("testman.html", **params)
def get(self, keyval):
resource = str(urllib.unquote(keyval))
blob_info = blobstore.BlobInfo.get(resource)
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(blob_info.key()).read())
sheet = wb.sheet_by_index(0)
data = [sheet.cell_value(0, col) for col in range(sheet.ncols)]
if not ("MOL REEFER MANIFEST" in data):
iname = str(blob_info.filename.replace(" ", ""))
delete_all_in_index(iname, "text")
delete_all_in_index(iname, "date")
delete_all_in_index(iname, "number")
y = addVesselData(wb, iname)
s = matchManifest(iname)
updateContainerStatus(iname)
else:
y = makeManifestPickle(wb)
if not (models.Manifest().find_duplicate(y["vessel"],y["voyage"],y["port"])):
man = models.Manifest()
man.blob = blob_info.key()
man.vessel_name = y["vessel"]
man.voyage = y["voyage"]
man.port = y["port"]
man.put()
for c in range(5, y["numrows"]):
SaveManifestDetail(man.key, y, c, man.vessel_name, man.voyage, man.port)
else:
y="Manifest added already"
params = {
"y": y,
}
return self.render_template("testman.html", **params)
def get(self, filekey, sheet_name):
dictd = lambda: defaultdict(dictd)
y = dictd()
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(filekey).read())
sh = wb.sheet_by_index(int(sheet_name))
row = 33
#find col were readings start
for a in range(0, 10):
y["DAT"] = sh.cell_value(row, a)
try:
if "Dat/Sup" in y["DAT"]:
start_col = a+1
except:
pass
y["start_col"] = start_col
for a in range(25, 32):
if "Number" in sh.cell_value(a,0):
y["start"] = a + 3
for c in range(y["start"], sh.nrows , 2):
y["container"][c] = sh.cell_value(c,0)
y["container"]["ppecbcode"][c] = sh.cell_value(c,1)
y["container"]["vent"][c] = sh.cell_value(c,2)
y["container"]["setpoint"][c] = sh.cell_value(c,3)
y["rows"] = sh.nrows
y["filekey"] = filekey
y["sheet_name"] = sheet_name
for g in range(5, 10):
try:
foo = sh.cell_value(c, g)
amDAtemp, pmDAtemp = foo.split("/")
foo2 = sh.cell_value(c+1, g)
amRAtemp, pmRAtemp = foo2.split("/")
AMdiff = Decimal(amDAtemp) - Decimal(amRAtemp)
PMdiff = Decimal(pmDAtemp) - Decimal(pmRAtemp)
y["AMDiff"][g] = AMdiff
y["PMDiff"][g] = PMdiff
y["AMDiff"]["class"][g] = "default"
y["PMDiff"]["class"][g] = "default"
if (Decimal(AMdiff) >= Decimal(-0.2)):
y["AMDiff"]["class"][c][g] = "darkgreen"
# y["colour"][c] = "darkgreen"
if (Decimal(AMdiff) >= Decimal(-0.5)):
y["AMDiff"]["class"][c][g] = "lightgreen"
# y["colour"][c] = "lightgreen"
if (Decimal(AMdiff) <= Decimal(-1.0)):
y["AMDiff"]["class"][c][g] = "lightred"
y["colour"][c] = "lightred"
if (Decimal(AMdiff) <= Decimal(-2.0)):
y["AMDiff"]["class"][c][g] = "darkred"
y["colour"][c] = "darkred"
except:
pass
params = {
"y": y,
}
return self.render_template('containerlist.html', **params)
def get(self):
get_data = blobstore.BlobInfo.all()
fkey = get_data.fetch(get_data.count())
for dat in range(0, get_data.count()):
filekey = fkey[dat]
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(filekey).read())
y = makeVesselPickle(wb)
params = {"y": y}
return self.render_template("testman.html", **params)
def get(self):
get_data = blobstore.BlobInfo.all()
fkey = get_data.fetch(get_data.count())
for dat in range(0, get_data.count()):
filekey = fkey[dat]
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader("gTVCfxI_4_-lNK1L1lmKKQ==").read())
y = addVesselData(wb)
params = {"y": y}
return self.render_template("testman.html", **params)
def get(self):
get_data = blobstore.BlobInfo.all()
fkey = get_data.fetch(get_data.count())
for dat in range(0, get_data.count()):
filekey = fkey[dat]
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(filekey).read())
y = makeVesselPickle(wb)
params = {
"y": y,
}
return self.render_template("testman.html", **params)
def get(self, filekey):
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(filekey).read())
# s = wb.sheet_by_index(0)
y = makePickle(filekey)
if y["manifest"] == "MOL REEFER MANIFEST":
filename = "manifestlist.html"
else:
filename = "vessellist.html"
params = {"y": y}
# filename = "manifestlist.html"
return self.render_template(filename, **params)
def get(self):
get_data = blobstore.BlobInfo.all()
fkey = get_data.fetch(get_data.count())
for dat in range(0, get_data.count()):
filekey = fkey[dat]
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader("gTVCfxI_4_-lNK1L1lmKKQ==").read())
y = addVesselData(wb)
params = {
"y": y,
}
return self.render_template("testman.html", **params)
def get(self):
#TODO set requests
# from_container = 0
to_container = 3
from_container = self.request.get('from_container')
#query = Suggestion.query().order(-Suggestion.when)
if from_container:
from_container = self.request.get('from_container')
else:
from_container = 0
#TODO select key from request get
blob_key="-3cfYPZI8Rx1VLEkofj-DQ=="
blob_reader = blobstore.BlobReader(blob_key)
wb = xlrd.open_workbook(file_contents=blob_reader.read())
#sh = wb.sheet_by_index(0)
#TODO add cape town durban etc
sh = wb.sheet_by_name("FDEC")
con_range = range(C_START, C_START+(to_container*2),2)
dictd = lambda: defaultdict(dictd)
y = dictd()
for i in range(from_container,to_container):
y["voyage"] = sh.cell_value(9,1)
y["date_of_loading"] = (datetime(*(xlrd.xldate_as_tuple(sh.cell_value(11,1), 0))[0:6])).strftime('%d-%m-%Y')
y["product"] = sh.cell_value(10,1)
y["port"] = sh.cell_value(11,0)
y["vesselname"] = sh.cell_value(8,1)
y["container"][i] = sh.cell_value(con_range[i],0)
y["container"]["ppecbcode"][i] = sh.cell_value(con_range[i],1)
y["container"]["vent"][i] = sh.cell_value(con_range[i],2)
y["container"]["setpoint"][i] = sh.cell_value(con_range[i],3)
for j in range(0,4):
y["container"]["DAtemp"][i][j] = sh.cell_value(con_range[i],5+j)
y["container"]["RAtemp"][i][j] = sh.cell_value(con_range[i]+1,5+j)
y["container"]["date_"][i][j] = (datetime(*(xlrd.xldate_as_tuple(sh.cell_value(29, 5 + j), 0))[0:6])).strftime('%d-%m-%Y')
y["container"]["day"][i][j] = str(j+1)+" Day "
params = {
"y": y,
"from_container": from_container,
"to_container": to_container,
}
return self.render_template('shiplist.html', **params)
def get(self, filekey):
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(filekey).read())
# s = wb.sheet_by_index(0)
y = makePickle(filekey)
if (y["manifest"] == 'MOL REEFER MANIFEST'):
filename = "manifestlist.html"
else:
filename = "vessellist.html"
params = {
"y": y,
}
# filename = "manifestlist.html"
return self.render_template(filename, **params)
def get(self):
get_data = blobstore.BlobInfo.all()
fkey = get_data.fetch(get_data.count())
for dat in range(0, get_data.count()):
filekey = fkey[dat]
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(filekey).read())
y = makeVesselPickle(wb)
# if not "manifest" in y:
# pass
# man = models.Vessel()
# man.blob = filekey.key()
# man.vessel = y["vessel"]
# man.voyage = y["voyage"]
# man.port = y["port"]
# man.put()
# for c in range(5, y["numrows"]):
# SaveManifestDetail(man.key, y, c)
params = {
"y": y,
}
return self.render_template("testman.html", **params)
def get(self, keyval):
resource = str(urllib.unquote(keyval))
blob_info = blobstore.BlobInfo.get(resource)
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(blob_info.key()).read())
v = addVesselData(wb, blob_info.filename.replace(" ", ""))
y = makeManifestPickle(wb)
if y["header"] == "manifest":
if not (models.Manifest().find_duplicate(y["vessel"], y["voyage"], y["port"])):
man = models.Manifest()
man.blob = blob_info.key()
man.vessel_name = y["vessel"]
man.voyage = y["voyage"]
man.port = y["port"]
man.put()
for c in range(5, y["numrows"]):
SaveManifestDetail(man.key, y, c, man.vessel_name, man.voyage, man.port)
else:
y = "Manifest added already"
params = {"y": y}
return self.render_template("testman.html", **params)
def get(self):
get_data = blobstore.BlobInfo.all()
fkey = get_data.fetch(get_data.count())
for dat in range(0, get_data.count()):
filekey = fkey[dat]
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(filekey).read())
y = makeManifestPickle(wb)
if (y["header"] == "manifest"):
if not (models.Manifest().find_duplicate(y["vessel"],y["voyage"],y["port"])):
man = models.Manifest()
man.blob = filekey.key()
man.vessel_name = y["vessel"]
man.voyage = y["voyage"]
man.port = y["port"]
man.put()
for c in range(5, y["numrows"]):
SaveManifestDetail(man.key, y, c)
params = {
"y": y,
}
return self.render_template("testman.html", **params)
def get(self, filekey, sheet_name, row):
dictd = lambda: defaultdict(dictd)
y = dictd()
start_col =1
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(filekey).read())
sh = wb.sheet_by_index(int(sheet_name))
y["filekey"] = filekey
y["sheet_name"] = sheet_name
y["row"] = row
#whats happening with this -1?
row = int(row)
cols = sh.ncols
y["filename"] = blobstore.BlobInfo.get(filekey).filename
y["product"] = sh.cell_value(10,1)
#find col were readings start
for a in range(0, 10):
y["DAT"] = sh.cell_value(row, a)
try:
if "Dat/Sup" in y["DAT"]:
start_col = a+1
except:
pass
#find col were readings end
for a in range(start_col, 40):
try:
y["DAT"] = sh.cell_value(row, a)
# if "Dat/Sup" in y["DAT"]:
# pass
except:
end_col = 21
#find start date
for c in range(start_col, 20):
if "Dat/Sup" in y["DAT"]:
start_col = a+1
end_col = 22
y["start_col"] = start_col
y["end_col"] = end_col
y["container"] = sh.cell_value(row,0)
for j in range(start_col, end_col):
y["count"][j] = j - start_col + 1
try:
y["DAtemp"][j] = sh.cell_value(row, j)
foo = sh.cell_value(row, j)
y["DAtempAM"][j], y["DAtempPM"][j] = foo.split("/")
except:
y["DAtemp"][j] = "NA"
try:
y["RAtemp"][j] = sh.cell_value(row+1, j)
foo = sh.cell_value(row+1, j)
y["RAtempAM"][j], y["RAtempPM"][j] = foo.split("/")
except:
y["RAtemp"][j] = "NA"
try:
y["date_"][j] = (datetime(*(xlrd.xldate_as_tuple(sh.cell_value(28, j), 0))[0:6])).strftime('%d-%m-%Y')
y["day_"][j] = (datetime(*(xlrd.xldate_as_tuple(sh.cell_value(28, j), 0))[0:6])).strftime('%d')
y["month_"][j] = (datetime(*(xlrd.xldate_as_tuple(sh.cell_value(28, j), 0))[0:6])).strftime('%m')
y["year_"][j] = (datetime(*(xlrd.xldate_as_tuple(sh.cell_value(28, j), 0))[0:6])).strftime('%Y')
except:
y["date_"][j] = "Date error"
#diffences
try:
foo = sh.cell_value(row, j)
amDAtemp, pmDAtemp = foo.split("/")
foo2 = sh.cell_value(row+1, j)
amRAtemp, pmRAtemp = foo2.split("/")
# amt = amDAtemp - amRAtemp
AMdiff = Decimal(amDAtemp) - Decimal(amRAtemp)
PMdiff = Decimal(pmDAtemp) - Decimal(pmRAtemp)
y["AMDiff"][j] = AMdiff
y["PMDiff"][j] = PMdiff
y["AMDiff"]["class"][j] = "default"
y["PMDiff"]["class"][j] = "default"
if (Decimal(AMdiff) <= Decimal(-1.0)):
y["AMDiff"]["class"][j] = "lightred"
if (Decimal(AMdiff) >= Decimal(-0.5)):
y["AMDiff"]["class"][j] = "lightgreen"
if (Decimal(AMdiff) >= Decimal(-0.2)):
y["AMDiff"]["class"][j] = "darkgreen"
if (Decimal(AMdiff) <= Decimal(-2.0)):
y["AMDiff"]["class"][j] = "darkred"
# PMdiff
if (Decimal(PMdiff) <= Decimal(-1.0)):
y["PMDiff"]["class"][j] = "lightred"
if (Decimal(PMdiff) >= Decimal(-0.5)):
y["PMDiff"]["class"][j] = "lightgreen"
if (Decimal(PMdiff) >= Decimal(-0.2)):
y["PMDiff"]["class"][j] = "darkgreen"
if (Decimal(PMdiff) <= Decimal(-2.0)):
y["PMDiff"]["class"][j] = "darkred"
except:
y["AMDiff"][j] = "NA"
params = {
"y": y,
}
return self.render_template('readingslist.html', **params)
def getWorkbook(filekey):
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(filekey).read())
return wb
def makePickle(filekey):
dictd = lambda: defaultdict(dictd)
y = dictd()
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(filekey).read())
for i, x in enumerate(wb.sheets()):
header_cells = x.row(0)
sh = wb.sheet_by_index(i)
num_rows = x.nrows - 1
curr_row = 0
mid_row = 0
header = [each.value for each in header_cells]
if 'MOL REEFER MANIFEST' in header:
y["manifest"] = 'MOL REEFER MANIFEST'
while curr_row < num_rows:
curr_row += 1
row = [int(each.value)
if isinstance(each.value, float)
else each.value
for each in sh.row(curr_row)]
value_dict = dict(zip(header, row))
value_dict['title'] = x.name
if 'Vessel:' in row:
y["voyage"] = row[row.index('Voyage:')+1]
y["vessel"] = row[row.index('Vessel:')+1]
y["port"] = row[row.index('Port:')+1]
if 'BOOKING NO' in row:
y["labels"] = row
mid_row = curr_row+1
y["acv"][curr_row] = row
y["myfloat"][curr_row] = sh.cell_value(curr_row,5)
y["numrows"] = num_rows+1
else:
y["key"] = blobstore.BlobInfo.get(filekey).key()
y["sheetname"][i] = sh.name
y["index"][i] = i
y["nsheets"] = wb.nsheets
for a in range(5, 15):
if "VESSEL" in sh.cell_value(a,0):
if (len(sh.cell_value(a,1)) > 0):
y["vesselname"][i] = sh.cell_value(a,1)
else:
y["vesselname"][i] = "NA"
if "VOYAGE" in sh.cell_value(a,0):
if (len(sh.cell_value(a,1)) > 0):
y["voyage"][i] = sh.cell_value(a,1)
y["voyage_fixed"] = sh.cell_value(a,1)
else:
y["voyage"][i] = "NA"
if "DATE of LOADING" in sh.cell_value(a,0):
try:
if (validate((datetime(*(xlrd.xldate_as_tuple(sh.cell_value(a, 1), 0))[0:6])).strftime('%d-%m-%Y'))):
y["date_of_loading"][i] = (datetime(*(xlrd.xldate_as_tuple(sh.cell_value(a, 1), 0))[0:6])).strftime('%d-%m-%Y')
except:
y["date_of_loading"][i] = "None"
y["colour"] = "lightred"
#y["bool"] = addDataFilename(y["vesselname"][i], y["voyage_fixed"], "", i, y["date_of_loading"][i])
return y
def get(self, filekey, sheet_name, row):
dictd = lambda: defaultdict(dictd)
y = dictd()
start_col = 1
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(filekey).read())
sh = wb.sheet_by_index(int(sheet_name))
y["filekey"] = filekey
y["sheet_name"] = sheet_name
y["row"] = row
# whats happening with this -1?
row = int(row)
cols = sh.ncols
y["filename"] = blobstore.BlobInfo.get(filekey).filename
y["product"] = sh.cell_value(10, 1)
# find col were readings start
for a in range(0, 10):
y["DAT"] = sh.cell_value(row, a)
try:
if "Dat/Sup" in y["DAT"]:
start_col = a + 1
except:
pass
# find col were readings end
for a in range(start_col, 40):
try:
y["DAT"] = sh.cell_value(row, a)
# if "Dat/Sup" in y["DAT"]:
# pass
except:
end_col = 21
# find start date
for c in range(start_col, 20):
if "Dat/Sup" in y["DAT"]:
start_col = a + 1
end_col = 22
y["start_col"] = start_col
y["end_col"] = end_col
y["container"] = sh.cell_value(row, 0)
for j in range(start_col, end_col):
y["count"][j] = j - start_col + 1
try:
y["DAtemp"][j] = sh.cell_value(row, j)
foo = sh.cell_value(row, j)
y["DAtempAM"][j], y["DAtempPM"][j] = foo.split("/")
except:
y["DAtemp"][j] = "NA"
try:
y["RAtemp"][j] = sh.cell_value(row + 1, j)
foo = sh.cell_value(row + 1, j)
y["RAtempAM"][j], y["RAtempPM"][j] = foo.split("/")
except:
y["RAtemp"][j] = "NA"
try:
y["date_"][j] = (datetime(*(xlrd.xldate_as_tuple(sh.cell_value(28, j), 0))[0:6])).strftime("%d-%m-%Y")
y["day_"][j] = (datetime(*(xlrd.xldate_as_tuple(sh.cell_value(28, j), 0))[0:6])).strftime("%d")
y["month_"][j] = (datetime(*(xlrd.xldate_as_tuple(sh.cell_value(28, j), 0))[0:6])).strftime("%m")
y["year_"][j] = (datetime(*(xlrd.xldate_as_tuple(sh.cell_value(28, j), 0))[0:6])).strftime("%Y")
except:
y["date_"][j] = "Date error"
# diffences
try:
foo = sh.cell_value(row, j)
amDAtemp, pmDAtemp = foo.split("/")
foo2 = sh.cell_value(row + 1, j)
amRAtemp, pmRAtemp = foo2.split("/")
# amt = amDAtemp - amRAtemp
AMdiff = Decimal(amDAtemp) - Decimal(amRAtemp)
PMdiff = Decimal(pmDAtemp) - Decimal(pmRAtemp)
y["AMDiff"][j] = AMdiff
y["PMDiff"][j] = PMdiff
y["AMDiff"]["class"][j] = "default"
y["PMDiff"]["class"][j] = "default"
if Decimal(AMdiff) <= Decimal(-1.0):
y["AMDiff"]["class"][j] = "lightred"
if Decimal(AMdiff) >= Decimal(-0.5):
y["AMDiff"]["class"][j] = "lightgreen"
if Decimal(AMdiff) >= Decimal(-0.2):
y["AMDiff"]["class"][j] = "darkgreen"
if Decimal(AMdiff) <= Decimal(-2.0):
y["AMDiff"]["class"][j] = "darkred"
# PMdiff
if Decimal(PMdiff) <= Decimal(-1.0):
y["PMDiff"]["class"][j] = "lightred"
if Decimal(PMdiff) >= Decimal(-0.5):
y["PMDiff"]["class"][j] = "lightgreen"
if Decimal(PMdiff) >= Decimal(-0.2):
y["PMDiff"]["class"][j] = "darkgreen"
if Decimal(PMdiff) <= Decimal(-2.0):
y["PMDiff"]["class"][j] = "darkred"
except:
y["AMDiff"][j] = "NA"
params = {"y": y}
return self.render_template("readingslist.html", **params)
def getWorkbook(filekey):
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(filekey).read())
return wb
def updateContainerStatus(manifest_key):
for index in search.get_indexes(fetch_schema=True, namespace="text"):
query = models.ManifestDetail.query(models.ManifestDetail.manifest == manifest_key)
detail = query.fetch(query.count())
print "FINDME "+index.name
try:
findblob_from_index = models.LinktoManifest.query(models.LinktoManifest.filename_stripped == index.name).fetch(1)[0]
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(findblob_from_index.blob).read())
except:
findblob_from_index = models.LinktoManifest.query().fetch(1)[0]
wb = xlrd.open_workbook(file_contents=blobstore.BlobReader(findblob_from_index.blob).read())
for dat in detail:
# print "FINDME2 "+blobstore.BlobInfo.get(dat.manifest.get().blob).filename
ind = index_search(dat.container_number, index.name)
if (ind):
dat.container_status=True
dat.sheet = ind[4]
dat.put()
# print dat.key
# print dat.sheet
code = index_search("row=%i AND text=%s" % (ind[2], dat.code), index.name)
if (code):
dat.code_status=True
dat.put()
#vents = index_search("row=%i AND text=%s" % (ind[2], dat.vents), index.name)
#find vents with in statement
sh = wb.sheet_by_name(ind[4])
row = sh.row(int(ind[2]))
cell = sh.cell_value(int(ind[2]), (int(ind[3]))+2)
set_temp = sh.cell_value(int(ind[2]), (int(ind[3]))+3)
num = map(int, re.findall(r'\d+', dat.vents))
cell_num = map(int, re.findall(r'\d+', cell))
temp_num = map(int, re.findall(r'\d+', dat.temp))
set_num = map(int, re.findall(r'\d+', str(set_temp)))
if (temp_num == set_num):
dat.temp_status=True
dat.put()
elif (set_temp == dat.temp):
dat.temp_status=True
dat.put()
# print "mapped: "+str(num)
# print "cell: "+str(cell)
# print "strin1"+string1
if (num == cell_num):
dat.vents_status=True
dat.put()
elif (cell == dat.vents):
dat.vents_status=True
dat.put()
temp = index_search("row=%i AND text=%s" % (ind[2], dat.temp), index.name)
if (temp):
dat.temp_status=True
dat.put()
return ind
