def docustomexport():
query_sets = custinfo.query.all()
column_names = [
'id', 'custid', 'custname', 'contact', 'baseinfo', 'address', 'status',
'fine', 'content', 'usedbattery', 'memo', 'date', 'saleman'
]
return excel.make_response_from_query_sets(query_sets, column_names, "xls")
def doexport():
col = ['case_id', 'booking_ref','description', 'update_on', 'location']
qs = Reference.query.join(Triage, Reference.triage_id == Triage.id).add_columns( \
Reference.case_id, Reference.booking_ref, Triage.description, \
Reference.update_on, Triage.location).filter( \
Reference.triage_id != None)
# qs = Triage.query.filter(Triage.booking_ref != None)
return excel.make_response_from_query_sets(qs, col, "csv")
def docustomexport():
query_sets = Category.query.filter_by(id=1).all()
column_names = ['id', 'name']
return excel.make_response_from_query_sets(query_sets, column_names, "xls")
def docustomexport():
query_sets = Category.query.filter_by(id=1).all()
column_names = ['id', 'name']
return excel.make_response_from_query_sets(query_sets, column_names, "xls")
def customExport():
get_list = session.query(Restaurant).order_by(Restaurant.name)
column_names = ['name', 'address', 'phone', 'health_rating']
return excel.make_response_from_query_sets(get_list, column_names, "xls")
def docustomexport():
query_sets = custinfo.query.all()
column_names = ['id', 'custid', 'custname', 'contact', 'baseinfo', 'address', 'status', 'fine', 'content', 'usedbattery', 'memo', 'date', 'saleman']
return excel.make_response_from_query_sets(query_sets, column_names, "xls")
def download():
query_sets = Funcionario.query.all()
column_names = ['_id', 'nome', 'email', 'telefone', 'salmensal', 'bonus']
return excel.make_response_from_query_sets(query_sets, column_names, "csv")