def admin_insert_complain_reply():
try:
if admin_login_session() == 'admin':
complain_id = request.form.get(
"complainId") # id from reply page for data update
complain_reply_description = request.form.get(
"complainReplyDescription") # data from reply page
complain_dao = ComplainDAO()
complain_vo = ComplainVO()
login_vo = LoginVO()
login_dao = LoginDAO()
complain_reply_date = datetime.datetime.now()
login_vo.login_username = request.cookies.get('login_username')
login_id = login_dao.find_login_id(login_vo)
complain_vo.complain_id = complain_id
complain_vo.complain_to_login_id = login_id
complain_vo.complain_reply_datetime = complain_reply_date
complain_vo.complain_reply_description = complain_reply_description
complain_vo.complain_status = "Replied"
complain_dao.update_complain(complain_vo)
return redirect("/admin/view_complain")
else:
return admin_logout_session()
except Exception as ex:
print("in admin_update_complain route exception occured>>>>>>>>>>", ex)
def user_insert_complain():
try:
if admin_login_session() == 'user':
complain_subject = request.form.get(
"userComplainType") # data from complain page
complain_description = request.form.get("userComplainDescription")
complain_dao = ComplainDAO()
complain_vo = ComplainVO()
login_vo = LoginVO()
login_dao = LoginDAO()
complain_date = datetime.datetime.now()
complain_status = "Pending"
login_vo.login_username = request.cookies.get('login_username')
login_id = login_dao.find_login_id(login_vo)
complain_vo.complain_subject = complain_subject
complain_vo.complain_description = complain_description
complain_vo.complain_datetime = complain_date
complain_vo.complain_status = complain_status
complain_vo.complain_from_login_id = login_id
complain_dao.insert_complain(complain_vo)
return redirect("/user/view_complain")
else:
return admin_logout_session()
except Exception as ex:
print("in user_insert_complain route exception occured>>>>>>>>>>", ex)
def admin_insert_product():
try:
if admin_login_session() == 'admin':
product_vo = ProductVO()
product_dao = ProductDAO()
product_vo.product_category_name = request.form.get(
'productCategoryId')
product_vo.product_subcategory_name = request.form.get(
'productSubcategoryId')
product_vo.product_name = request.form.get('productName')
product_vo.product_description = request.form.get(
'productDescription')
product_vo.product_price = request.form.get('productPrice')
product_image = request.files.get('productImage')
product_image_name = secure_filename(product_image.filename)
product_image_path = os.path.join(app.config['PRODUCT_FOLDER'])
product_image.save(
os.path.join(product_image_path, product_image_name))
product_vo.product_image_name = product_image_name
product_vo.product_image_path = product_image_path.replace(
"base", "..")
product_dao.insert_product(product_vo)
return redirect(url_for('admin_view_product'))
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print("admin_insert_product route exception occured>>>>>>>>>>", ex)
def admin_edit_area():
try:
if admin_login_session() == 'admin':
area_vo = AreaVO()
area_dao = AreaDAO()
state_dao = StateDAO()
state_vo = StateVO()
city_vo = CityVO()
city_dao = CityDAO()
area_vo.area_id = request.args.get('areaId')
city_vo.city_state_id = request.args.get('stateId')
area_vo_list = area_dao.edit_area(area_vo)
state_vo_list = state_dao.view_state()
city_vo_list = city_dao.view_ajax_area_city(city_vo)
return render_template('admin/editArea.html',
state_vo_list=state_vo_list,
area_vo_list=area_vo_list,
city_vo_list=city_vo_list)
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print("in admin_edit_area route exception occured>>>>>>>>>>", ex)
def admin_load_state():
try:
if admin_login_session() == 'admin':
return render_template('admin/addState.html')
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print("admin_load_state route exception occured>>>>>>>>>>", ex)
def admin_view_subcategory():
try:
if admin_login_session() == 'admin':
subcategory_dao = SubCategoryDAO()
subcategory_vo_list = subcategory_dao.view_subcategory()
return render_template('admin/viewSubcategory.html', subcategory_vo_list=subcategory_vo_list)
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print("admin_view_subcategory route exception occured>>>>>>>>>>", ex)
def admin_load_subcategory():
try:
if admin_login_session() == 'admin':
category_dao = CategoryDAO()
category_vo_list = category_dao.view_category()
return render_template('admin/addSubcategory.html', category_vo_list=category_vo_list)
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print('admin_view_category route exception occured>>>>>>>>>>', ex)
def user_view_complain():
try:
if admin_login_session() == 'user':
complain_dao = ComplainDAO()
complain_vo = ComplainVO()
login_vo = LoginVO()
login_dao = LoginDAO()
login_vo.login_username = request.cookies.get('login_username')
user_login_id = login_dao.find_login_id(login_vo)
complain_vo.complain_from_login_id = user_login_id
complain_vo_updated_list = []
complain_vo_list = complain_dao.user_view_complain()
print("complain_vo_list=", complain_vo_list)
if len(complain_vo_list) != 0:
for index in range(len(complain_vo_list)):
if user_login_id == complain_vo_list[index][
1].complain_from_login_id:
complain_vo_updated_list.append(
complain_vo_list[index])
print("complain_vo_updated_list >>>>>>>>>>>>>>",
complain_vo_updated_list)
if len(complain_vo_updated_list) == 0:
return render_template("user/addComplaint.html",
complain_vo_updated_list=None)
else:
admin_login_username = None
for index in range(len(complain_vo_list)):
if complain_vo_updated_list[index][
1].complain_to_login_id is not None:
print(
"complain_vo_updated_list[index][1].complain_to_login_id",
complain_vo_updated_list)
admin_login_id = complain_vo_updated_list[index][
1].complain_to_login_id
print("admin_login_id=", admin_login_id)
admin_login_vo = LoginVO()
admin_login_vo.login_id = admin_login_id
admin_login_username = login_dao.find_login_username(
admin_login_vo)
print("admin_login_username="******"user/addComplaint.html",
complain_vo_updated_list=
complain_vo_updated_list,
admin_login_username=admin_login_username)
else:
return render_template("user/addComplaint.html",
complain_vo_updated_list=None)
else:
return admin_logout_session()
except Exception as ex:
print("in user_view_complain route exception occured>>>>>>>>>>", ex)
def admin_delete_subcategory():
try:
if admin_login_session() == 'admin':
subcategory_dao = SubCategoryDAO()
subcategory_id = request.args.get('subcategoryId')
subcategory_dao.delete_subcategory(subcategory_id)
return redirect(url_for('admin_view_subcategory'))
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print("in admin_delete_subcategory route exception occured>>>>>>>>>>", ex)
def admin_load_area():
try:
if admin_login_session() == 'admin':
state_dao = StateDAO()
state_vo_list = state_dao.view_state()
return render_template('admin/addArea.html',
state_vo_list=state_vo_list)
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print('admin_load_area route exception occured>>>>>>>>>>', ex)
def admin_view_city():
try:
if admin_login_session() == 'admin':
city_dao = CityDAO()
city_vo_list = city_dao.view_city()
return render_template('admin/viewCity.html',
city_vo_list=city_vo_list)
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print("admin_view_city route exception occured>>>>>>>>>>", ex)
def admin_view_complain():
try:
if admin_login_session() == 'admin':
complain_dao = ComplainDAO()
complain_vo_list = complain_dao.admin_view_complain()
return render_template("admin/viewComplaints.html",
complain_vo_list=complain_vo_list)
else:
return admin_logout_session()
except Exception as ex:
print("in admin_view_complain route exception occured>>>>>>>>>>", ex)
def admin_delete_complain():
try:
if admin_login_session() == 'admin':
complain_vo = ComplainVO()
complain_dao = ComplainDAO()
complain_vo.complain_id = request.args.get("complainId")
complain_dao.delete_complain(complain_vo)
return redirect("/admin/view_complain")
else:
return admin_logout_session()
except Exception as ex:
print("in admin_delete_complain route exception occured>>>>>>>>>>", ex)
def admin_delete_area():
try:
if admin_login_session() == 'admin':
area_dao = AreaDAO()
area_id = request.args.get('areaId')
area_dao.delete_area(area_id)
return redirect(url_for('admin_view_area'))
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print("in admin_delete_area route exception occured>>>>>>>>>>", ex)
def admin_view_product():
try:
if admin_login_session() == 'admin':
product_dao = ProductDAO()
product_vo_list = product_dao.view_product()
print(product_vo_list)
return render_template('admin/viewProduct.html',
product_vo_list=product_vo_list)
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print("admin_view_product route exception occured>>>>>>>>>>", ex)
def admin_view_area():
try:
if admin_login_session() == 'admin':
area_dao = AreaDAO()
area_vo_list = area_dao.view_area()
print(area_vo_list)
return render_template('admin/viewArea.html',
area_vo_list=area_vo_list)
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print("admin_view_area route exception occured>>>>>>>>>>", ex)
def admin_edit_state():
try:
if admin_login_session() == 'admin':
state_vo = StateVO()
state_dao = StateDAO()
state_vo.state_id = request.args.get('stateId')
state_vo_list = state_dao.edit_state(state_vo)
return render_template('admin/editState.html',
state_vo_list=state_vo_list)
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print("admin_edit_state route exception occured>>>>>>>>>>", ex)
def admin_delete_city():
try:
if admin_login_session() == 'admin':
city_vo = CityVO()
city_dao = CityDAO()
city_id = request.args.get('cityId')
city_vo.city_id = city_id
city_dao.delete_city(city_vo)
return redirect(url_for('admin_view_city'))
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
flash('Area is connected to this entity')
print("in admin_delete_city route exception occured>>>>>>>>>>", ex)
return redirect(url_for('admin_view_city'))
def admin_update_city():
try:
if admin_login_session() == 'admin':
city_vo = CityVO()
city_dao = CityDAO()
city_vo.city_id = request.form.get('cityId')
city_vo.city_name = request.form.get('cityName')
city_vo.city_description = request.form.get('cityDescription')
city_vo.city_state_id = request.form.get('cityStateId')
city_dao.update_city(city_vo)
return redirect(url_for('admin_view_city'))
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print("in admin_update_city route exception occured>>>>>>>>>>", ex)
def admin_update_subcategory():
try:
if admin_login_session() == 'admin':
subcategory_vo = SubCategoryVO()
subcategory_dao = SubCategoryDAO()
subcategory_vo.subcategory_id = request.form.get('subcategoryId')
subcategory_vo.subcategory_name = request.form.get('subcategoryName')
subcategory_vo.subcategory_description = request.form.get('subcategoryDescription')
subcategory_vo.subcategory_category_id = request.form.get('subcategoryCategoryId')
subcategory_dao.update_subcategory(subcategory_vo)
return redirect(url_for('admin_view_subcategory'))
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print("in admin_update_subcategory route exception occured>>>>>>>>>>", ex)
def admin_delete_product():
try:
if admin_login_session() == 'admin':
product_dao = ProductDAO()
product_id = request.args.get('productId')
product_vo_list = product_dao.delete_product(product_id)
file_path = product_vo_list.product_image_path.replace(
"..", "base") + product_vo_list.product_image_name
os.remove(file_path)
return redirect(url_for('admin_view_product'))
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print("in admin_delete_product route exception occured>>>>>>>>>>", ex)
def admin_delete_state():
try:
if admin_login_session() == 'admin':
state_vo = StateVO()
state_dao = StateDAO()
state_vo.state_id = request.args.get('stateId')
state_dao.delete_state(state_vo)
return redirect(url_for('admin_view_state'))
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
flash('Area or City is connected with this entity')
print("admin_delete_state route exception occured>>>>>>>>>>", ex)
return redirect(url_for('admin_view_state'))
def admin_edit_subcategory():
try:
if admin_login_session() == 'admin':
subcategory_vo = SubCategoryVO()
subcategory_dao = SubCategoryDAO()
category_dao = CategoryDAO()
subcategory_vo.subcategory_id = request.args.get('subcategoryId')
subcategory_vo_list = subcategory_dao.edit_subcategory(subcategory_vo)
category_vo_list = category_dao.view_category()
return render_template('admin/editSubcategory.html', category_vo_list=category_vo_list,
subcategory_vo_list=subcategory_vo_list)
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print("in admin_edit_subcategory route exception occured>>>>>>>>>>", ex)
def admin_delete_category():
try:
if admin_login_session() == 'admin':
category_vo = CategoryVO()
category_dao = CategoryDAO()
category_vo.category_id = request.args.get('categoryId')
category_dao.delete_category(category_vo)
return redirect(url_for('admin_view_category'))
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
flash('Subcategory is connected with this category')
print("admin_delete_category route exception occured>>>>>>>>>>", ex)
return redirect(url_for('admin_view_category'))
def admin_edit_city():
try:
if admin_login_session() == 'admin':
city_vo = CityVO()
city_dao = CityDAO()
state_dao = StateDAO()
city_vo.city_id = request.args.get('cityId')
city_vo_list = city_dao.edit_city(city_vo)
state_vo_list = state_dao.view_state()
return render_template('admin/editCity.html',
state_vo_list=state_vo_list,
city_vo_list=city_vo_list)
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print("in admin_edit_city route exception occured>>>>>>>>>>", ex)
def admin_update_state():
try:
if admin_login_session() == 'admin':
state_vo = StateVO()
state_dao = StateDAO()
state_vo.state_id = request.form.get('stateId')
state_vo.state_name = request.form.get('stateName')
state_vo.state_description = request.form.get('stateDescription')
state_dao.update_state(state_vo)
return redirect(url_for('admin_view_state'))
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print("admin_update_state route exception occured>>>>>>>>>>", ex)
def admin_load_complain_reply():
try:
if admin_login_session() == 'admin':
complain_dao = ComplainDAO()
complain_vo = ComplainVO()
complain_id = request.args.get("complainId")
print(complain_id)
complain_vo.complain_id = complain_id
complain_vo_list = complain_dao.insert_complain_reply(
complain_vo) # fetch the complain data
print("complain_vo_list>>>>>", complain_vo_list)
return render_template("admin/replyComplain.html",
complain_vo_list=complain_vo_list)
else:
return admin_logout_session()
except Exception as ex:
print("in admin_reply_complain route exception occured>>>>>>>>>>", ex)
def admin_ajax_area_city():
try:
if admin_login_session() == 'admin':
city_dao = CityDAO()
city_vo = CityVO()
city_vo.city_state_id = request.args.get('stateId')
city_vo_list = city_dao.view_ajax_area_city(city_vo)
ajax_area_city = [i.as_dict() for i in city_vo_list]
return jsonify(ajax_area_city)
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print('admin_ajax_area_city route exception occured>>>>>>>>>>', ex)
def admin_add_area():
try:
if admin_login_session() == 'admin':
area_vo = AreaVO()
area_dao = AreaDAO()
area_vo.area_name = request.form.get('areaName')
area_vo.area_pincode = request.form.get('areaPincode')
area_vo.area_city_id = request.form.get('areaCityId')
area_vo.area_state_id = request.form.get('areaStateId')
area_dao.insert_area(area_vo)
return redirect(url_for('admin_view_area'))
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print("admin_insert_area route exception occured>>>>>>>>>>", ex)
def admin_insert_category():
try:
if admin_login_session() == 'admin':
category_vo = CategoryVO()
category_dao = CategoryDAO()
category_vo.category_name = request.form.get('categoryName')
category_vo.category_description = request.form.get(
'categoryDescription')
category_dao.insert_category(category_vo)
return redirect(url_for('admin_view_category'))
else:
return redirect(url_for('admin_logout_session'))
except Exception as ex:
print("admin_insert_category route exception occured>>>>>>>>>>", ex)
