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)