def post(self):
key = self.request.cookies['tenantlist']
tenantList = db.get(key)
tenant = Tenants()
tenant.tenantlist = tenantList.key()
pic = self.request.get("file")
#pic = self.request.FILES["file"].read()
tenant.picture = db.Blob(pic)
tenant.put()
def delete(self):
key = self.request.cookies['tenantlist']
tenantlist = db.get(key)
#tenantId = simplejson.loads(self.request.body)['id']
tenantId = self.request.get("tenantId")
tenant = Tenants.get_by_id(int(tenantId))
if tenant.tenantlist.key() == tenantlist.key():
#tmp = tenant.toDict()
tenant.delete()
else:
self.error(403)
def get(self):
key = self.request.cookies['tenantlist']
tenantlist = db.get(key)
tenants = []
query = Tenants.all()
#query = db.GqlQuery("SELECT * FROM Tenants")
if tenantlist:
query.filter("tenantlist =", tenantlist.key())
for tenant in query:
tenants.append(tenant.toDict())
# tenants.append(tenant.to_dict())
tenants = simplejson.dumps(tenants)
#self.response.headers['Content-Type'] = 'image/jpeg'
self.response.out.write(tenants)
def put(self):
key = self.request.cookies['tenantlist']
tenantlist = db.get(key)
tenantId = simplejson.loads(self.request.body)['id']
tenant = Tenants.get_by_id(int(tenantId))
#tenant = Tenants.get_by_id(int(2))
if tenant.tenantlist.key() == tenantlist.key():
inputData = simplejson.loads(self.request.body)
# tenant.content = inputData['content']
# tenant.done = inputData['done']
# tenant.put()
# tenant = simplejson.dumps(tenant.toDict())
temp = tenant.updateTenant(inputData)
tenant = simplejson.dumps(temp)
self.response.out.write(tenant)
else:
self.error(403)
def AddTenants():
form = addtenants()
availstalls_y = []
availstalls = Stalls.query.filter_by(
stall_status='0').all() #.paginate(1,11,True)
for r in availstalls:
type = Types.query.filter_by(typeID=r.typeID).first()
availstalls_y.append(type.stall_type)
x = []
result = Tenants.query.order_by(
Tenants.first_name).all() #.paginate(1,2,True)
for r in result:
stall = Stalls.query.filter_by(stallID=r.stallID).first()
x.append(stall.stall_no)
if request.method == "POST":
print "scull"
if form.validate_on_submit():
print "hello1"
firstname = form.fname.data
middlename = form.mname.data
lastname = form.lname.data
Address = form.address.data
Contnum = form.contnum.data
TenantphotoID = form.tenantphotoID.data
stallno1 = form.stallno.data
stallnum = Stalls.query.filter_by(stall_no=stallno1).first()
if stallnum:
print stallnum.stallID
print "hello2"
sid__ = stallnum.stallID
if stallnum.stall_status == "1":
flash("stall already Occupied")
else:
tenantForm = Tenants(contact_no=Contnum,
first_name=firstname,
mid_name=middlename,
last_name=lastname,
present_addr=Address,
stallID=sid__)
dbase.session.add(tenantForm)
dbase.session.commit()
stallnumm = Stalls.query.filter_by(
stallID=stallnum.stallID).first()
stallnumm.stall_rate = form.rate.data
stallnumm.stall_status = "1"
print stallnumm.stallID
dbase.session.add(stallnumm)
dbase.session.commit()
#else:
# tyy = Tenants.query.filter_by(tenantID=storer).first()
# tyy.tenant_photo = loc_default
#return render_template("addtenant.html", form1=form, availstalls = availstalls, availstalls_y=availstalls_y, result=search_panel(0)[0], x=search_panel(0)[1], result2=search_panel(1)[0], y=search_panel(1)[1])
profile_entry = ""
te = Tenants.query.all()
tee = []
for et in te:
tee.append(et.tenantID)
storer = tee[len(tee) - 1]
print storer
TenantphotoID = img_folder + str(storer)
rents = Rents(date_started=now,
tenantID=storer,
stallID=sid__)
dbase.session.add(rents)
dbase.session.commit()
if os.path.isdir(TenantphotoID) == False:
os.makedirs(TenantphotoID)
if form.tenantphotoID.data == None or form.tenantphotoID.data == "":
#tenants.tenant_photo = tenants.tenant_photo
tnore = Tenants.query.filter_by(
tenantID=storer).first()
tnore.tenant_photo = loc_default
dbase.session.add(tnore)
dbase.session.commit()
else:
if form.tenantphotoID.data and allowed_file(
form.tenantphotoID.data.filename):
filename = secure_filename(
form.tenantphotoID.data.filename)
form.tenantphotoID.data.save(
os.path.join(TenantphotoID + '/', filename))
uploadFolder = TenantphotoID + '/'
nameNew = str(int(time.time())) + '.' + str(
os.path.splitext(filename)[1][1:])
os.rename(uploadFolder + filename,
uploadFolder + nameNew)
profile_entry = uploadFolder + nameNew
t = Tenants.query.filter_by(
tenantID=storer).first()
#t.tenant_photo = profile_entry
t.tenant_photo = 'static/profile/' + str(
storer) + '/' + nameNew
print profile_entry
dbase.session.add(t)
user = current_user
lgdate = str(now)
msg = user.username + " added a tenant "
logmessage = Logs(details=msg, log_date=lgdate)
dbase.session.add(logmessage)
dbase.session.commit()
flash('Tenant added')
#return render_template("successadd1.html", result=search_panel(0)[0], x=search_panel(0)[1], result2=search_panel(1)[0], y=search_panel(1)[1])
else:
flash("Stall not found")
return render_template("addtenant.html",
form1=form,
availstalls=availstalls,
availstalls_y=availstalls_y,
result=search_panel(0)[0],
x=search_panel(0)[1],
result2=search_panel(1)[0],
y=search_panel(1)[1])
