def redirect_view_request():
if len(userA) != 0:
username = userA[0]
user = Login.user_detail(username)
request_list = admin_request()
requestuser = Login.user_detail(username)
property_detail = ViewProperty.view_details(request_list[0]['PropertyID'])
return render_template('viewAllRequest.html', user=user, request_list=request_list, requestuser=requestuser, property_detail=property_detail)
else:
return render_template('login.html')
def request_approve():
if len(userA) != 0:
RequestID = request.form['RequestID']
value = 'Approve', RequestID
respond_request(value)
username = userA[0]
user = Login.user_detail(username)
request_list = admin_request()
requestuser = Login.user_detail(username)
property_detail = ViewProperty.view_details(request_list[0]['PropertyID'])
return render_template('viewAllRequest.html', user=user, request_list=request_list, requestuser=requestuser,
property_detail=property_detail)
else:
return render_template('login.html')
def edit_account_page():
if len(userA) != 0:
username = userA[0]
user = Login.user_detail(username)
return render_template('editProfilePage.html', user=user)
else:
return render_template('login.html')
def redirect_upload():
if len(userA) != 0:
username = userA[0]
user = Login.user_detail(username)
return render_template('uploadExcelFile.html', user=user)
else:
return render_template('login.html')
def register_property():
if len(userA) != 0:
username = userA[0]
user = Login.user_detail(username)
UID = request.form['UID']
price = request.form['Price']
PropertyType = request.form['PropertyType']
YearBuilt = request.form['YearBuilt']
TenureType = request.form['TenureType']
Bedroom = request.form['Bedroom']
Bathroom = request.form['Bathroom']
Extraroom = request.form['ExtraRoom']
Parking = request.form['Parking']
Size = request.form['Size']
FloorPlan = request.form['FloorPlan']
Unit = request.form['Unit']
Area = request.form['Area']
Street = request.form['Street']
District = request.form['District']
State = request.form['State']
Postcode = request.form['Postcode']
Township = request.form['Township']
inserted = UID, price, PropertyType, YearBuilt, TenureType, Bedroom, Bathroom, Extraroom, Parking, Size, FloorPlan, Unit, Area, Street, District, State, Postcode, Township
UploadDocument.register_Property(inserted)
return manage_property_page()
else:
return render_template('login.html')
def register_property_page():
if len(userA) != 0:
username = userA[0]
user = Login.user_detail(username)
return render_template('registerProperty.html', user=user)
else:
return render_template('login.html')
def manage_property_page():
if len(userA) != 0:
username = userA[0]
user = Login.user_detail(username)
property_list = ViewProperty.admin()
return render_template('manageProperty.html', user=user, propertylist=property_list)
else:
return render_template('login.html')
def redirect_update_property():
if len(userA) != 0:
username = userA[0]
user = Login.user_detail(username)
PropertyID = request.form['PropertyID']
return render_template('editProperty.html', PropertyID=PropertyID, user=user)
else:
return render_template('login.html')
def redirect_property_details():
if len(userA) != 0:
username = userA[0]
user = Login.user_detail(username)
PropertyID = request.form['PropertyID']
property_detail = ViewProperty.view_details(PropertyID)
return render_template('viewDetails.html', property_detail=property_detail, user=user)
else:
return render_template('login.html')
def batch_upload():
f = request.form['csvfile']
upload_property(f)
user = Login.user_detail(userA[0])
property_list = ViewProperty.view_all()
sold_property_list = ViewProperty.view_sold()
request_list = ViewRequest.admin()
billing_amount = ViewBilling.overview_unpaid()
return render_template('dashboard.html', user=user, propertycount=len(property_list),
propertysold=len(sold_property_list), requestcount=len(request_list),
totalbillingamount=billing_amount)
def dashboard_page():
if len(userA) != 0:
user = Login.user_detail(userA[0])
property_list = ViewProperty.view_all()
sold_property_list = ViewProperty.view_sold()
request_list = ViewRequest.admin()
billing_amount = ViewBilling.overview_unpaid()
return render_template('dashboard.html', user=user, propertycount=len(property_list),
propertysold=len(sold_property_list), requestcount=len(request_list),
totalbillingamount=billing_amount)
else:
return render_template('login.html')
def admin_login():
username = request.form['username']
password = request.form['password']
credential = username, password
result = Login.sign_in(credential)
token = result[0]
msg = result[1]
if token:
print(msg)
user = Login.user_detail(username)
userA.append(username)
property_list = ViewProperty.view_all()
sold_property_list = ViewProperty.view_sold()
request_list = ViewRequest.admin()
billing_amount = ViewBilling.overview_unpaid()
return render_template('dashboard.html', user=user, propertycount=len(property_list),
propertysold=len(sold_property_list), requestcount=len(request_list),
totalbillingamount=billing_amount)
else:
print(msg)
return render_template('login.html')
def update_property():
if len(userA) != 0:
username = userA[0]
user = Login.user_detail(username)
PropertyID = request.form['PropertyID']
Furnish = request.form['Furnish']
RentPrice = request.form['RentPrice']
SellPrice = request.form['SellPrice']
Usage = request.form['Usage']
FreeUtility = request.form['FreeUtility']
Images = request.form['Images']
RentalStartDate = request.form['RentalStartDate']
RentalEndDate = request.form['RentalEndDate']
RentalPeriod = request.form['RentalPeriod']
Description = request.form['Description']
LastUpdatedDate = request.form['LastUpdatedDate']
RentContract = request.form['RentContract']
SellContract = request.form['SellContract']
inserted = Furnish, RentPrice, SellPrice, Usage, FreeUtility, Images, RentalStartDate, RentalEndDate, RentalPeriod, Description, LastUpdatedDate, RentContract, SellContract, PropertyID
UpdateProperty.modify(inserted)
return manage_property_page()
else:
return render_template('login.html')
def login(username, password):
credential = username, password
message = Login.sign_in(input_credential=credential)
return message