def datesalenotes():
d = db.database()
notes = request.args.get('search', 0, type=str)
fromDate = request.args.get('fromDate', 0, type=str)
toDate = request.args.get('toDate', 0, type=str)
svlead = d.get_sale_datenotes(notes, fromDate, toDate)
return jsonify(svlead)
def datesalepolicy():
d = db.database()
policy = request.args.get('search', 0, type=str)
fromDate = request.args.get('fromDate', 0, type=str)
toDate = request.args.get('toDate', 0, type=str)
svlead = d.get_sale_datepolicy(policy, fromDate, toDate)
return jsonify(svlead)
def datesaleagent():
d = db.database()
agent = request.args.get('search', 0, type=str)
fromDate = request.args.get('fromDate', 0, type=str)
toDate = request.args.get('toDate', 0, type=str)
svlead = d.get_sale_dateagent(agent, fromDate, toDate)
return jsonify(svlead)
def datesource():
d = db.database()
source = request.args.get('search', 0, type=str)
fromDate = request.args.get('fromDate', 0, type=str)
toDate = request.args.get('toDate', 0, type=str)
svlead = d.get_lead_datesource(source, fromDate, toDate)
return jsonify(svlead)
def dateemail():
d = db.database()
email = request.args.get('search', 0, type=str)
fromDate = request.args.get('fromDate', 0, type=str)
toDate = request.args.get('toDate', 0, type=str)
svlead = d.get_lead_dateemail(email, fromDate, toDate)
return jsonify(svlead)
def searchsaledate():
d = db.database()
fromDate = request.args.get('fromDate', 0, type=str)
toDate = request.args.get('toDate', 0, type=str)
getRange = d.get_sale_date(fromDate, toDate)
return jsonify(getRange)
def sourcelist():
d = db.database()
source = request.args.get('source', 0, type=str)
svlead = d.get_lead_source(source)
return jsonify(svlead)
def lname():
d = db.database()
lname = request.args.get('search', 0, type=str)
svlead = d.get_lead_lname(lname)
return jsonify(svlead)
def subvendor_list():
d = db.database()
thelist = request.args.get('svlist', 0, type=str)
svlead = d.get_lead_subvendor(thelist)
return jsonify(svlead)
def salenotes():
d = db.database()
notes = request.args.get('search', 0, type=str)
sale = d.get_sale_notes(notes)
return jsonify(sale)
def salelname():
d = db.database()
lname = request.args.get('search', 0, type=str)
sale = d.get_sale_lname(lname)
return jsonify(sale)
def insertsale():
d = db.database()
data = request.args.getlist('saleinfo[]')
sale = d.insert_sale(data[0], data[1], data[2], data[3], data[4], data[5],
data[6], data[10], data[7], data[8], data[9])
return jsonify(sale)
def test_area():
d = db.database()
slead = d.get_lead_info()
return render_template('test_area.html', title='Lead List', sleads=slead)
def getsales():
d = db.database()
sales = d.get_sales()
return render_template('saleslist.html', title='Sales List', sales=sales)
def salepolicy():
d = db.database()
policy = request.args.get('search', 0, type=str)
sale = d.get_sale_policy(policy)
return jsonify(sale)
def vendor_list():
d = db.database()
thelist = request.args.get('vlist', 0, type=str)
vlead = d.get_lead_vendor(thelist)
return jsonify(vlead)
def salesource():
d = db.database()
source = request.args.get('search', 0, type=str)
sale = d.get_sale_source(source)
return jsonify(sale)
def searchpage():
d = db.database()
sources = d.get_source_list()
return render_template('search.html', sources=sources)
def saleagent():
d = db.database()
agent = request.args.get('search', 0, type=str)
sale = d.get_sale_agent(agent)
return jsonify(sale)
def phone():
d = db.database()
phone = request.args.get('search', 0, type=str)
svlead = d.get_lead_phone(phone)
return jsonify(svlead)
def email():
d = db.database()
email = request.args.get('search', 0, type=str)
svlead = d.get_lead_email(email)
return jsonify(svlead)
