def get_shortlisted_property(request_data):
if request_data:
request_data = json.loads(request_data)
# Check if shortlisted property existed against user
email = putil.validate_for_user_id_exists(request_data.get("user_id"))
property_ids_list = frappe.db.get_values("Shortlisted Property", {"user_id":request_data.get("user_id"), "status":"Active"}, "property_id")
if not property_ids_list:
return {"operation":"Search", "message":"No Single Shortlisted property found", "user_id":request_data.get("user_id")}
property_ids_list = [ property_id[0] for property_id in property_ids_list if property_id]
try:
# generate search_query and resultset & fields to be included in response
sp_include_fields= ["property_photo", "city", "location", "carpet_area", "amenities", "no_of_floors",
"price", "status","floor_no", "price_per_sq_ft", "property_id", "property_title",
"tag", "possession_status", "property_subtype_option", "unit_of_area", "property_age"]
search_query = { "query":{ "ids":{ "values":property_ids_list } } }
es = ElasticSearchController()
response_data, total_records = es.search_document(["property"], search_query, request_data.get("page_number",1),
request_data.get("records_per_page",40), [], sp_include_fields)
# response data & pagination logic
append_shortlisted_tag(response_data)
msg = "Shortlisted Property Found" if len(response_data) else "Shortlsited Property not found"
return putil.init_pagination_and_response_generatrion(request_data, response_data, msg, total_records)
except elasticsearch.ElasticsearchException,e:
raise ElasticSearchException(e.error)
except Exception,e:
raise OperationFailed("Get Shortlisted Property Operation Failed")
def get_user_properties(request_data):
if request_data:
request_data = json.loads(request_data)
email = putil.validate_for_user_id_exists(request_data.get("user_id"))
search_query = { "query": { "match":{ "posted_by":request_data.get("user_id") } } }
try:
# fields_to_be_excluded from response and resultset generation
include_list = ["property_photo", "city", "location", "carpet_area", "amenities", "no_of_floors", "price", "status",
"floor_no", "price_per_sq_ft", "property_id", "property_title", "tag", "possession_status", "property_subtype_option"]
es = ElasticSearchController()
response_data, total_records = es.search_document(["property"], search_query, request_data.get("page_number",1), request_data.get("records_per_page",40), [], include_list)
response_data = check_for_shortlisted_property(response_data, request_data.get("user_id"))
putil.show_amenities_with_yes_status(response_data)
# response data & pagination logic
msg = "User Property Found" if len(response_data) else "User Property not found"
return putil.init_pagination_and_response_generatrion(request_data, response_data, msg, total_records)
except elasticsearch.ElasticsearchException,e:
raise ElasticSearchException(e.error)
except Exception,e:
raise OperationFailed("Get User Properties Operation Failed")
def get_builder_projects(request_data):
if request_data:
request_data = json.loads(request_data)
email = putil.validate_for_user_id_exists(request_data.get("user_id"))
search_query = {
"query": {
"match": {
"posted_by": request_data.get("user_id")
}
}
}
try:
es = ElasticSearchController()
size = get_count_of_project_records(es)
response_data, total_records = es.search_document(
["project"], search_query, request_data.get("page_number",
1), size)
# response data & pagination logic
msg = "User Project Found" if len(
response_data) else "User Project not found"
return putil.init_pagination_and_response_generatrion(
request_data, response_data, msg, total_records)
except elasticsearch.ElasticsearchException, e:
raise ElasticSearchException(e.error)
except Exception, e:
raise OperationFailed("Get Builder Properties Operation Failed")
def get_property_of_particular_tag(request_data):
if request_data:
request_data = json.loads(request_data)
if not request_data.get("tag"):
raise MandatoryError("Mandatory Field Tag missing")
try:
exclude_list = ["agent_name", "agent_no", "contact_no", "contact_person", "created_by",
"modified_by", "creation_date", "modified_date", "posted_datetime", "modified_datetime"]
must_clause_list = [{ "match":{ "tag":request_data.get("tag") } }, { "match":{ "status":"Active" } } ]
search_query = { "query":{ "bool":{ "must":must_clause_list } } }
es = ElasticSearchController()
response_data, total_records = es.search_document(["property"], search_query, request_data.get("page_number",1), request_data.get("records_per_page",40),exclude_list)
putil.show_amenities_with_yes_status(response_data)
msg = "Property found for specfied criteria" if len(response_data) else "Property not found"
response_dict = putil.init_pagination_and_response_generatrion(request_data, response_data, msg, total_records)
response_dict["tag"] = request_data.get("tag")
return response_dict
except elasticsearch.ElasticsearchException,e:
raise ElasticSearchException(e.error)
except Exception,e:
raise OperationFailed("Get Tagged Property Operation Failed")
def search_unpublished_property(data):
property_data = json.loads(data)
try:
# generate search query & result generation & list of fields which should be excluded.
exclude_list = putil.get_exclude_list_for_search(property_data.get("request_source", ""))
#must_clause_list.append([{"match":{ "published_status": "Unpublished" } }, { "match": { "status": "Deactivated" }}])
must_clause_list= [{"match":{ "published_status": "Unpublished" } }]
search_query = { "query":{ "bool":{ "must":must_clause_list } }, "sort": [{ "posted_datetime": { "order": "desc" }}] }
es = ElasticSearchController()
response_data, total_records = es.search_document(["property"], search_query, property_data.get("page_number",1),
property_data.get("records_per_page",40), exclude_list)
if property_data.get("user_id") != "Guest":
response_data = check_for_shortlisted_property(response_data,property_data.get("user_id"))
response_data = putil.get_date_diff_and_count_from_posting(response_data)
putil.convert_area_according_to_uom(response_data, property_data.get("unit_of_area", "Sq.Ft."))
putil.show_amenities_with_yes_status(response_data)
# response data & pagination logic
msg = "Property found for specfied criteria" if len(response_data) else "Property not found"
response_dict = putil.init_pagination_and_response_generatrion(property_data, response_data, msg, total_records)
return response_dict
except elasticsearch.RequestError,e:
raise ElasticInvalidInputFormatError(e.error)
def get_user_properties(request_data):
if request_data:
request_data = json.loads(request_data)
email = putil.validate_for_user_id_exists(request_data.get("user_id"))
search_query = { "query": { "match":{ "posted_by":request_data.get("user_id") } } }
try:
# fields_to_be_excluded from response and resultset generation
include_list = ["property_photo", "city", "location", "carpet_area", "amenities", "no_of_floors", "price", "status",
"floor_no", "price_per_sq_ft", "property_id", "property_title", "tag", "possession_status", "property_subtype_option"]
es = ElasticSearchController()
response_data, total_records = es.search_document(["property"], search_query, request_data.get("page_number",1), request_data.get("records_per_page",40), [], include_list)
response_data = check_for_shortlisted_property(response_data, request_data.get("user_id"))
putil.show_amenities_with_yes_status(response_data)
# response data & pagination logic
msg = "User Property Found" if len(response_data) else "User Property not found"
return putil.init_pagination_and_response_generatrion(request_data, response_data, msg, total_records)
except elasticsearch.ElasticsearchException,e:
raise ElasticSearchException(e.error)
except Exception,e:
raise OperationFailed("Get User Properties Operation Failed")
def get_shortlisted_property(request_data):
if request_data:
request_data = json.loads(request_data)
# Check if shortlisted property existed against user
email = putil.validate_for_user_id_exists(request_data.get("user_id"))
property_ids_list = frappe.db.get_values("Shortlisted Property", {"user_id":request_data.get("user_id"), "status":"Active"}, "property_id")
if not property_ids_list:
return {"operation":"Search", "message":"No Single Shortlisted property found", "user_id":request_data.get("user_id")}
property_ids_list = [ property_id[0] for property_id in property_ids_list if property_id]
try:
# generate search_query and resultset & fields to be included in response
sp_include_fields= ["property_photo", "city", "location", "carpet_area", "amenities", "no_of_floors",
"price", "status","floor_no", "price_per_sq_ft", "property_id", "property_title",
"tag", "possession_status", "property_subtype_option", "unit_of_area", "property_age"]
search_query = { "query":{ "ids":{ "values":property_ids_list } } }
es = ElasticSearchController()
response_data, total_records = es.search_document(["property"], search_query, request_data.get("page_number",1),
request_data.get("records_per_page",40), [], sp_include_fields)
# response data & pagination logic
append_shortlisted_tag(response_data)
msg = "Shortlisted Property Found" if len(response_data) else "Shortlsited Property not found"
return putil.init_pagination_and_response_generatrion(request_data, response_data, msg, total_records)
except elasticsearch.ElasticsearchException,e:
raise ElasticSearchException(e.error)
except Exception,e:
raise OperationFailed("Get Shortlisted Property Operation Failed")
def get_property_of_particular_tag(request_data):
if request_data:
request_data = json.loads(request_data)
if not request_data.get("tag"):
raise MandatoryError("Mandatory Field Tag missing")
try:
exclude_list = ["agent_name", "agent_no", "contact_no", "contact_person", "created_by",
"modified_by", "creation_date", "modified_date", "posted_datetime", "modified_datetime"]
must_clause_list = [{ "match":{ "tag":request_data.get("tag") } }, { "match":{ "status":"Active" } } ]
search_query = { "query":{ "bool":{ "must":must_clause_list } } }
es = ElasticSearchController()
response_data, total_records = es.search_document(["property"], search_query, request_data.get("page_number",1), request_data.get("records_per_page",40),exclude_list)
putil.show_amenities_with_yes_status(response_data)
msg = "Property found for specfied criteria" if len(response_data) else "Property not found"
response_dict = putil.init_pagination_and_response_generatrion(request_data, response_data, msg, total_records)
response_dict["tag"] = request_data.get("tag")
return response_dict
except elasticsearch.ElasticsearchException,e:
raise ElasticSearchException(e.error)
except Exception,e:
raise OperationFailed("Get Tagged Property Operation Failed")
def search_unpublished_property(data):
property_data = json.loads(data)
try:
# generate search query & result generation & list of fields which should be excluded.
exclude_list = putil.get_exclude_list_for_search(property_data.get("request_source", ""))
#must_clause_list.append([{"match":{ "published_status": "Unpublished" } }, { "match": { "status": "Deactivated" }}])
must_clause_list= [{"match":{ "published_status": "Unpublished" } }]
search_query = { "query":{ "bool":{ "must":must_clause_list } }, "sort": [{ "posted_datetime": { "order": "desc" }}] }
es = ElasticSearchController()
response_data, total_records = es.search_document(["property"], search_query, property_data.get("page_number",1),
property_data.get("records_per_page",40), exclude_list)
if property_data.get("user_id") != "Guest":
response_data = check_for_shortlisted_property(response_data,property_data.get("user_id"))
response_data = putil.get_date_diff_and_count_from_posting(response_data)
putil.convert_area_according_to_uom(response_data, property_data.get("unit_of_area", "Sq.Ft."))
putil.show_amenities_with_yes_status(response_data)
# response data & pagination logic
msg = "Property found for specfied criteria" if len(response_data) else "Property not found"
response_dict = putil.init_pagination_and_response_generatrion(property_data, response_data, msg, total_records)
return response_dict
except elasticsearch.RequestError,e:
raise ElasticInvalidInputFormatError(e.error)
def get_all_projects(request_data):
if request_data:
request_data = json.loads(request_data)
email = putil.validate_for_user_id_exists(request_data.get("user_id"))
search_query = { }
try:
include_list = ["project_id", "overview"]
es = ElasticSearchController()
size = get_count_of_project_records(es)
response_data, total_records = es.search_document(["project"], search_query, request_data.get("page_number",1), size, [], include_list)
# response data & pagination logic
msg = "Projects Found" if len(response_data) else "Projects not found"
return putil.init_pagination_and_response_generatrion(request_data, response_data, msg, total_records)
except elasticsearch.ElasticsearchException,e:
raise ElasticSearchException(e.error)
except Exception,e:
raise OperationFailed("Get All Projects Operation Failed")
def get_builder_projects(request_data):
if request_data:
request_data = json.loads(request_data)
email = putil.validate_for_user_id_exists(request_data.get("user_id"))
search_query = { "query": { "match":{ "posted_by":request_data.get("user_id") } } }
try:
es = ElasticSearchController()
size = get_count_of_project_records(es)
response_data, total_records = es.search_document(["project"], search_query, request_data.get("page_number",1), size)
# response data & pagination logic
msg = "User Project Found" if len(response_data) else "User Project not found"
return putil.init_pagination_and_response_generatrion(request_data, response_data, msg, total_records)
except elasticsearch.ElasticsearchException,e:
raise ElasticSearchException(e.error)
except Exception,e:
raise OperationFailed("Get Builder Properties Operation Failed")
def get_all_projects(request_data):
if request_data:
request_data = json.loads(request_data)
email = putil.validate_for_user_id_exists(request_data.get("user_id"))
search_query = { }
try:
include_list = ["project_id", "project_name"]
es = ElasticSearchController()
size = get_count_of_project_records(es)
response_data, total_records = es.search_document(["project"], search_query, request_data.get("page_number",1), size, [], include_list)
# response data & pagination logic
msg = "Projects Found" if len(response_data) else "Projects not found"
return putil.init_pagination_and_response_generatrion(request_data, response_data, msg, total_records)
except elasticsearch.ElasticsearchException,e:
raise ElasticSearchException(e.error)
except Exception,e:
raise OperationFailed("Get All Projects Operation Failed")
def search_property(data):
property_data = json.loads(data)
property_data = putil.validate_property_posting_data(property_data, "property_json/property_search.json")
putil.init_for_location_or_city_creation(property_data)
putil.convert_area_to_sqft_for_search(property_data)
try:
# generate search query & result generation & list of fields which should be excluded.
exclude_list = putil.get_exclude_list_for_search(property_data.get("request_source", ""))
search_query = putil.generate_search_query(property_data)
adv_search_query = search_query
search_query = cstr(search_query)
putil.generate_advance_search_query(adv_search_query, property_data)
es = ElasticSearchController()
response_data, total_records = es.search_document(["property"], adv_search_query, property_data.get("page_number",1),
property_data.get("records_per_page",40), exclude_list)
# post property-search operation
if not property_data.get("request_id"):
request_id = store_request_in_elastic_search(property_data, search_query, "Property Search", adv_search_query)
if property_data.get("user_id") != "Guest":
response_data = check_for_shortlisted_property(response_data,property_data.get("user_id"))
response_data = putil.get_date_diff_and_count_from_posting(response_data)
putil.convert_area_according_to_uom(response_data, property_data.get("unit_of_area", "Sq.Ft."))
putil.show_amenities_with_yes_status(response_data)
# response data & pagination logic
msg = "Property found for specfied criteria" if len(response_data) else "Property not found"
response_dict = putil.init_pagination_and_response_generatrion(property_data, response_data, msg, total_records)
response_dict["request_id"] = property_data.get("request_id") if property_data.get("request_id") else request_id
return response_dict
except elasticsearch.RequestError,e:
raise ElasticInvalidInputFormatError(e.error)
def search_property(data):
property_data = json.loads(data)
property_data = putil.validate_property_posting_data(property_data, "property_json/property_search.json")
putil.init_for_location_or_city_creation(property_data)
putil.convert_area_to_sqft_for_search(property_data)
try:
# generate search query & result generation & list of fields which should be excluded.
exclude_list = putil.get_exclude_list_for_search(property_data.get("request_source", ""))
search_query = putil.generate_search_query(property_data)
adv_search_query = search_query
search_query = cstr(search_query)
putil.generate_advance_search_query(adv_search_query, property_data)
es = ElasticSearchController()
response_data, total_records = es.search_document(["property"], adv_search_query, property_data.get("page_number",1),
property_data.get("records_per_page",40), exclude_list)
# post property-search operation
if not property_data.get("request_id"):
request_id = store_request_in_elastic_search(property_data, search_query, "Property Search", adv_search_query)
if property_data.get("user_id") != "Guest":
response_data = check_for_shortlisted_property(response_data,property_data.get("user_id"))
response_data = putil.get_date_diff_and_count_from_posting(response_data)
putil.convert_area_according_to_uom(response_data, property_data.get("unit_of_area", "Sq.Ft."))
putil.show_amenities_with_yes_status(response_data)
# response data & pagination logic
msg = "Property found for specfied criteria" if len(response_data) else "Property not found"
response_dict = putil.init_pagination_and_response_generatrion(property_data, response_data, msg, total_records)
response_dict["request_id"] = property_data.get("request_id") if property_data.get("request_id") else request_id
return response_dict
except elasticsearch.RequestError,e:
raise ElasticInvalidInputFormatError(e.error)
def get_alerts(request_data):
"""
Get property alerts based on two types
1. Check if alert is already set against that user else
2. Check for last search request & based on that search request
show properties to user.
"""
request_data = json.loads(request_data)
email = putil.validate_for_user_id_exists(request_data.get("user_id"))
alert = frappe.db.sql(""" select * from `tabAlerts` where user_id='{0}'
order by creation desc limit 1""".format(request_data.get("user_id")),as_dict=1)
try:
if alert:
property_search_query, uom = get_alerts_based_on_alert_doctype(alert)
else:
property_search_query, uom = get_alerts_based_on_last_request(request_data, email)
# fields to be included in response and resultset generation
include_fields_list = ["property_id", "property_title", "price", "property_photo", "location",
"city", "carpet_area", "unit_of_area", "posted_datetime", "modified_datetime"]
es = ElasticSearchController()
response_data, total_records = es.search_document(["property"], property_search_query, request_data.get("page_number",1),
request_data.get("records_per_page",40), [], include_fields_list)
putil.convert_area_according_to_uom(response_data, uom)
response_data = modify_alert_resultset(response_data, request_data.get("user_id"))
# response generation and pagination logic
msg = "Property Found" if response_data else "Property not found"
return putil.init_pagination_and_response_generatrion(request_data, response_data, msg, total_records)
except elasticsearch.ElasticsearchException,e:
raise ElasticSearchException(e.error)
def get_alerts(request_data):
"""
Get property alerts based on two types
1. Check if alert is already set against that user else
2. Check for last search request & based on that search request
show properties to user.
"""
request_data = json.loads(request_data)
email = putil.validate_for_user_id_exists(request_data.get("user_id"))
alert = frappe.db.sql(""" select * from `tabAlerts` where user_id='{0}'
order by creation desc limit 1""".format(request_data.get("user_id")),as_dict=1)
try:
if alert:
property_search_query, uom = get_alerts_based_on_alert_doctype(alert)
else:
property_search_query, uom = get_alerts_based_on_last_request(request_data, email)
# fields to be included in response and resultset generation
include_fields_list = ["property_id", "property_title", "price", "property_photo", "location",
"city", "carpet_area", "unit_of_area", "posted_datetime", "modified_datetime"]
es = ElasticSearchController()
response_data, total_records = es.search_document(["property"], property_search_query, request_data.get("page_number",1),
request_data.get("records_per_page",40), [], include_fields_list)
putil.convert_area_according_to_uom(response_data, uom)
response_data = modify_alert_resultset(response_data, request_data.get("user_id"))
# response generation and pagination logic
msg = "Property Found" if response_data else "Property not found"
return putil.init_pagination_and_response_generatrion(request_data, response_data, msg, total_records)
except elasticsearch.ElasticsearchException,e:
raise ElasticSearchException(e.error)
