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)