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")