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