def ctg_rec_result(name, add, ctg):
value = name
value2 = add
value3 = int(ctg)
os.putenv('NLS_LANG', 'KOREAN_KOREA.KO16MSWIN949')
connection = cx_Oracle.connect('hr/[email protected]:1521/xe')
cur = connection.cursor()
cur.execute(
"select distinct name from jjj_rec_add where category=:category and address1=:address1",
{
"category": value3,
"address1": value2
})
member = []
for result in cur:
member.append(result[0])
cur.close()
connection.close()
if name not in member:
mm.main(value, value2, value3)
result = mm.get_recommend_info(value, value2, value3)
return render_template("jjj/category_recommend_result.html",
name=value,
add=value2,
ctg=value3,
data=result)
def chart(name):
result = mm.get_recommend_info(name)
address_count, ctg_count = mm.get_chart_data(result)
add_length = len(address_count)
ctg_length = len(ctg_count)
return render_template("jjj/graph1.html",
add_data=address_count,
add_len=add_length,
ctg_data=ctg_count,
ctg_len=ctg_length,
name=name)
def hybrid(name):
os.putenv('NLS_LANG', 'KOREAN_KOREA.KO16MSWIN949')
connection = cx_Oracle.connect('hr/[email protected]:1521/xe')
cur = connection.cursor()
cur.execute("select distinct name from jjj_rec ")
member = []
for result in cur:
member.append(result[0])
if name not in member:
mm.main(name)
reco = mm.get_recommend_info(name)
cur.close()
return render_template("jjj/hybrid.html", data=reco, name=name)