def export_inscription_data(request, atype): if atype == "sheet": return excel.make_response_from_a_table( Inscription, "xlsx", file_name="inscriptions" ) elif atype =="custom": query_sets = Inscription.objects.all() column_names = ["nom", "prenom", "date_inscription", "date_naissance", "lieu_naissance", "niveau", "frequence", "sexe", "nationalite", "telephone", "email", "representant_parent_un", "nom_parent_un", "prenom_parent_un", "date_naissance_parent_un", "lieu_naissance_parent_un", "code_postal_naissance_parent_un", "nationalite_parent_un", "adresse_domicile_parent_un", "ville_parent_un", "telephone_domicile_parent_un", "telephone_personnel_parent_un", "telephone_professionnel_parent_un", "email_parent_un", "profession_parent_un", "representant_parent_deux", "nom_jeune_fille_parent_deux", "nom_marial_parent_deux", "prenom_parent_deux", "date_naissance_parent_deux", "lieu_naissance_parent_deux", "code_postal_naissance_parent_deux", "nationalite_parent_deux", "telephone_domicile_parent_deux", "telephone_personnel_parent_deux", "telephone_professionnel_parent_deux", "email_parent_deux", "profession_parent_deux", "adresse_domicile_parent_deux","situation_familiale", "matricule" ] return excel.make_response_from_query_sets( query_sets, column_names, "xlsx", file_name="inscriptions" ) else: return HttpResponseBadRequest( "Bad request. S'il vous plait mettez l'un des choses dans le suffix de votre URL : sheet ou custom " )
def export_data(modeladmin, request, queryset): return excel.make_response_from_query_sets( queryset, modeladmin.list_display, 'xls', file_name="errores" )
def export_technology_data(request): file_name = '技术文件表_' techs = TechnologyFile.objects.all() file_name += datetime.now().strftime("%Y-%m-%d") column_names = [ 'id', 'title', 'file_type', 'type_display', 'profess_id', 'profess_name', ] colnames = [ '编号', '标题', '文件类型id', '类型名称', '专业id', '专业名称', ] return excel.make_response_from_query_sets( techs, column_names, 'xls', file_name=file_name, colnames=colnames, ignore_rows=[0] if len(techs) else [1])
def get(self, request, *args, **kwargs): query_sets = Location.objects.all() column_names = ['name', 'address', 'latitude', 'longitude'] return excel.make_response_from_query_sets(query_sets, column_names, 'xls', file_name="download")
def download(request, account_id): facebook_account = FacebookAccount.objects.get(account_id=account_id) facebook_adSource = adSource.objects.get(name=facebook_account.account_name) google = Source.objects.get(name='Google') addUp(google, facebook_adSource) query_sets = Source.objects.filter() column_names = ['name', 'clicks', 'impressions', 'CTR', 'CPC', 'CPM', 'cost'] return excel.make_response_from_query_sets(query_sets, column_names, 'xls')
def export_data(request): queryset = models.Exceltest.objects.all() columns = ['id', 'nom', 'prenom', 'age'] return excel.make_response_from_query_sets(queryset, columns, 'xls', file_name="import_" + str(datetime.now()) + "")
def export_data(request, atype, queryset, fields): if atype == "sheet": return excel.make_response_from_a_table(ScoreSheet, 'xls', file_name="sheet") elif atype == "book": return excel.make_response_from_tables([ScoreSheet], 'xls', file_name="book") elif atype == "custom": return excel.make_response_from_query_sets(queryset, fields, 'xls', file_name='custom') else: return HttpResponseBadRequest("bad request, choose one")
def export_users(request): users = Users.objects.all() column_names = [ 'dt_add', 'id_user', 'id_invite', 'name', 'phone', 'dt_birth' ] return excel.make_response_from_query_sets(users, column_names, 'xls', file_name="custom")
def export_data(request, atype): if atype == "sheet": return excel.make_response_from_a_table(Question, 'xls') elif atype == "book": return excel.make_response_from_tables([Question, Choice], 'xls') elif atype == "custom": question = Question.objects.get(slug='ide') query_sets = Choice.objects.filter(question=question) column_names = ['choice_text', 'id', 'votes'] return excel.make_response_from_query_sets(query_sets, column_names, 'xls')
def export_data(request): # return excel.make_response_from_a_table(Cliente, 'xls', file_name="clientes") query_sets = Cliente.objects.all() column_names = ['nit', 'razon_social', 'telefono', 'correo', 'ciudad', 'direccion', 'activo_inactivo'] return excel.make_response_from_query_sets( query_sets, column_names, 'xls', file_name="clientes" )
def export_data(request): data = DwfMeasureData.objects.all() column_names = [ 'dataCounter', 'Z', 'R', 'C', 'freq', 'channel', 'time', 'timeMin' ] return excel.make_response_from_query_sets(data, column_names, 'xlsx', file_name="test")
def export_safety_data(request): file_name = '安全文件表_' safetys = SafetyFile.objects.all() file_name += datetime.now().strftime("%Y-%m-%d") column_names = ['id', 'title', 'file_type', 'type_display'] colnames = ['编号', '标题', '文件类型id', '类型名称'] return excel.make_response_from_query_sets(safetys, column_names, 'xls', file_name=file_name, colnames=colnames, ignore_rows=[0] if len(safetys) else [1])
def download(request, account_id): facebook_account = FacebookAccount.objects.get(account_id=account_id) facebook_adSource = adSource.objects.get( name=facebook_account.account_name) google = Source.objects.get(name='Google') addUp(google, facebook_adSource) query_sets = Source.objects.filter() column_names = [ 'name', 'clicks', 'impressions', 'CTR', 'CPC', 'CPM', 'cost' ] return excel.make_response_from_query_sets(query_sets, column_names, 'xls')
def export_data(request): user = auth.get_user(request) query_sets = Book.objects.filter(user=user) column_names = [ 'fullname', 'birthdate', 'address', 'phone', 'email', 'comment' ] return excel.make_response_from_query_sets(query_sets, column_names, 'csv', file_name='adbook_' + user.username)
def export_schedule_data(request): file_name = '进度表_' queryset = Schedule.objects.all() file_name += datetime.now().strftime("%Y-%m-%d") column_names = ['id', 'job_name', 'profess_id', 'profess_name', 'unit', 'location', 'done_count', 'design_total', 'last_week_plan', 'last_week_actual', 'now_week_plan', 'now_week_actual', 'now_week'] colnames = ['进度编号', '作业名称', '专业id', '专业名称', '单位', '施工地点', '开累完成量', '设计总量', '上周计划完成量', '上周实际完成量', '本周计划完成量', '完成总周数', '当前周目'] return excel.make_response_from_query_sets(queryset, column_names, 'xls', file_name=file_name, colnames=colnames, sheet_name='进度数据', ignore_rows=[0] if len(queryset) else [1])
def get(self, request): search = request.GET.get('search') if search: search = request.GET.get('search').strip() users = UserProfile.objects.filter(Q(username__icontains=search) | Q(staff_no__icontains=search) | Q(department__icontains=search) | Q(bg_telephone__icontains=search) | Q(mobile__icontains=search) | Q(email__icontains=search, is_superuser=0)).order_by('-is_staff', 'staff_no') else: users = UserProfile.objects.filter(is_superuser=0).order_by('-is_staff', 'staff_no') columns_names = ['id', 'username', 'staff_no', 'department', 'bg_telephone', 'mobile', 'email', 'is_staff'] return excel.make_response_from_query_sets(users, columns_names, 'xls', file_name='人员列表')
def export_data(request): query_sets = Conductor.objects.all() column_names = [ "cedula", "nombres", 'apellidos', 'direccion', 'rh', 'telefono', 'celular', 'correo', 'fecha_nacimiento', 'nivel_estudio', 'numero_licencia_conduccion', 'categoria_licencia', 'estado_licencia', 'organismo_transito', 'fecha_expedicion', 'fecha_vencimiento', 'restricciones', 'experiencia', 'activo_inactivo' ] return excel.make_response_from_query_sets(query_sets, column_names, 'xls', file_name="conductores")
def excelExport(request): if request.method == 'POST': # object_ids = request.POST.get('object_ids', None) # question = Expense.objects.all() question = excel_objects query_sets = question # query_sets = question.filter(has_been_changed=True) column_names = ['name', 'date', 'time', 'price', 'category_name_id'] return excel.make_response_from_query_sets(query_sets, column_names, 'xls', file_name="custom") else: return render(request, 'excelExportTest.html')
def export_data(request): # return excel.make_response_from_a_table(Ruta, 'xls', file_name="rutas") query_sets = Ruta.objects.all() column_names = [ 'codigo_ruta', 'nombre_ruta', 'tipo_viaje', 'tipo_ruta', 'tipo_vehiculo_requerido', 'origen', 'destino', 'hora_inicio', 'hora_fin', 'valor_hora_adicional', 'valor_ruta', 'valor_tercero', 'comision_conductor', 'kilometros', 'link_ruta', 'nit_id', 'activo_inactivo' ] return excel.make_response_from_query_sets(query_sets, column_names, 'xls', file_name="rutas")
def export_excel(self, request, queryset): # data_excel =Contract.objects.all() # print(request.GET['q']) # print(queryset) qs = self.get_changelist_instance(request).get_queryset(request) column_names = [ "code", ] return excel.make_response_from_query_sets(qs, column_names, "xlsx", status=200, sheet_name='测试', file_name='测试文件')
def export_data(request): # return excel.make_response_from_a_table(Ruta, 'xls', file_name="rutas") query_sets = Planilla.objects.all() column_names = [ 'fecha', 'kilometros', 'hora_adicional', 'hora_inicio', 'hora_fin', 'tiempo_operado', 'observaciones', 'novedades', 'flota', 'valor_ruta', 'valor_tercero', 'viaticos', 'descuentos_conductor', 'valor_hora_adicional', 'adicional_conductor', 'total_ingreso', 'conductor_id', 'placa_id', 'ruta_id' ] return excel.make_response_from_query_sets(query_sets, column_names, 'xls', file_name="planilla")
def export_user(request, pk): users = Users.objects.filter(pk=pk) # user = Users.objects.get(pk=pk) # gifts = user.get_gifts() # stroka = '' # for gift in gifts: # stroka += gift['gift_name'] + ", Статус: " + gift['status'] + "; \n" # users['Подарки'] = stroka column_names = [ 'dt_add', 'id_user', 'id_invite', 'name', 'phone', 'dt_birth' ] return excel.make_response_from_query_sets(users, column_names, 'xls', file_name="custom")
def exportDataToExcel(request): dataCounter = request.GET.get('dataCounter', '') data = DwfMeasureData.objects.filter(dataCounter=dataCounter) data2 = DwfResultData.objects.get(dataCounter=dataCounter) file_name = str(data2.startTime) + " to " + str(data2.targetTime) column_names = [ 'dataCounter', 'Z', 'R', 'C', 'freq', 'channel', 'time', 'timeMin' ] print(file_name) return excel.make_response_from_query_sets(data, column_names, 'xlsx', file_name=file_name)
def export_r5(request): column_names = ['IdCtto', 'NumCtto', 'DescCtto'] exp_ctto = Ctto.objects.filter() e = Ctto.objects.filter() print(e) #q5 = Mdte.objects.filter(exp_ctto) #q6 = Ctto.objects.select_related().get(id=2) #print(q6.NomMandte) #exp_ctto = Ctto.objects.all() return excel.make_response_from_query_sets(exp_ctto, column_names, 'xls', file_name="custom")
def export_data(request, atype): if atype == "sheet": return excel.make_response_from_a_table(Item, 'xls', file_name="sheet") elif atype == "book": return excel.make_response_from_tables([Question, Choice], 'xls', file_name="book") elif atype == "custom": question = Question.objects.get(slug='ide') query_sets = Choice.objects.filter(question=question) column_names = ['choice_text', 'id', 'votes'] return excel.make_response_from_query_sets(query_sets, column_names, 'xls', file_name="custom") else: return HttpResponseBadRequest( "Bad request. please put one of these " + "in your url suffix: sheet, book or custom")
def export_material_data(request): file_name = '物资表_' queryset = Material.objects.all() file_name += datetime.now().strftime("%Y-%m-%d") column_names = [ 'id', 'name', 'manufacturer', 'profess_id', 'profess_name', 'type_id', 'num', 'unit' ] colnames = ['物资编号', '名称', '生产厂家', '专业id', '专业名称', '型号', '数量', '单位'] return excel.make_response_from_query_sets( queryset, column_names, 'xls', file_name=file_name, colnames=colnames, sheet_name='物资数据', ignore_rows=[0] if len(queryset) else [1])
def export_data(request, atype): if atype == "sheet": return excel.make_response_from_a_table( Question, 'xls', file_name="sheet") elif atype == "book": return excel.make_response_from_tables( [Question, Choice], 'xls', file_name="book") elif atype == "custom": question = Question.objects.get(slug='ide') query_sets = Choice.objects.filter(question=question) column_names = ['choice_text', 'id', 'votes'] return excel.make_response_from_query_sets( query_sets, column_names, 'xls', file_name="custom" ) else: return HttpResponseBadRequest("Bad request. please put one of these in your url suffix: sheet, book or custom")
def send_to_excel(request, data, test): test = get_object_or_404(Test, id=test) if data == "answers": answers = Answer.objects.filter(query__test=test) serializer = AnswerSerializer(answers, many=True) file_name = u"test#%s_answers" % str(test.id) serializer = list(map(change_answers, serializer.data)) return make_response_from_records(serializer, 'xls', file_name=file_name) elif data == "questions": questions = Query.objects.filter(test=test) file_name = u'test#%s_questions' % str(test.id) column_names = ['id', 'text'] return make_response_from_query_sets(questions, column_names, 'xlsx', file_name=file_name) elif data == "testeds": testeds = change_testeds(TestedSerializer(Tested.objects.filter(test=test), many=True).data) file_name = u'test#%s_testeds' % str(test.id) return make_response_from_records(testeds, 'xls', file_name=file_name) else: return Http404("Does Not Exist")
def export_data(request): query_sets = set(MLSession.objects.all()) for item in query_sets: item.time = item.time.strftime('%H:%M') column_names = [ 'session_id', 'year', 'month', 'day', 'time', 'platform', 'visitor_type', 'page_1', 'page_time_1', 'page_pictures_1', 'page_2', 'page_time_2', 'page_pictures_2', 'page_3', 'page_time_3', 'page_pictures_3', 'page_4', 'page_time_4', 'page_pictures_4', 'page_5', 'page_time_5', 'page_pictures_5', 'page_6', 'page_time_6', 'page_pictures_6', 'page_7', 'page_time_7', 'page_pictures_7', 'page_8', 'page_time_8', 'page_pictures_8', 'page_9', 'page_time_9', 'page_pictures_9', 'page_10', 'page_time_10', 'page_pictures_10' ] result = excel.make_response_from_query_sets(query_sets, column_names, 'xls', file_name="custom") return result
def export_sheet(request, atype): if atype == "sheet": return excel.make_response_from_a_table(Location, 'xls', status=200, file_name="Locations") elif atype == "book": return excel.make_response_from_tables([Location], 'xls', file_name="Locations") elif atype == "custom": query_sets = Location.objects.all() column_names = ['location_name', 'common_name', 'location_type'] return excel.make_response_from_query_sets(query_sets, column_names, 'xls', file_name="Locations") else: return HttpResponseBadRequest( "Bad request. please put one of these " + "in your url suffix: sheet, book or custom")
def export_data(request): # return excel.make_response_from_a_table(Vehiculo, 'xls', file_name="vehiculos") query_sets = Vehiculo.objects.all() column_names = [ 'placa', 'numero_interno', 'combustible', 'numero_licencia_transito', 'organismo_transito', 'fecha_expedicion', 'marca', 'linea', 'cilindraje', 'modelo', 'clase_vehiculo', 'color', 'tipo_servicio', 'carroceria', 'capacidad', 'numero_motor', 'numero_chasis', 'propietario', 'id_propietario', 'numero_tarjeta_operacion', 'fecha_inicio_tarjeta_operacion', 'fecha_vencimiento_tarjeta_operacion', 'empresa_afiliado', 'id_empresa_afiliado', 'numero_soat', 'fecha_inicio_soat', 'aseguradora_soat', 'numero_certificado_rtm', 'fecha_inicio_rtm', 'fecha_vencimiento_rtm', 'centro_diagnostico_automotriz', 'numero_polizas_rce_rcc', 'fecha_inicio_rce_rcc', 'fecha_vencimiento_rce_rcc', 'aseguradora_rce_rcc', 'activo_inactivo', 'conductor_default_id' ] return excel.make_response_from_query_sets(query_sets, column_names, 'xls', file_name="vehiculos")
def export_member_data(request, dept_id=None): file_name = '员工表_' if dept_id: dept = get_object_or_404(Departments, pk=dept_id) members = Member.objects.filter(dept_id=dept_id) file_name += dept.dept_name + '_' else: members = Member.objects.all() file_name += datetime.now().strftime("%Y-%m-%d") column_names = ['member_id', 'dept_id', 'dept_name', 'name', 'sex', 'birthday', 'position', 'phone', 'nation', 'blood_type'] colnames = ['员工工号', '部门id', '部门名字', '姓名', '性别', '生日', '职位', '电话', '民族', '血型'] return excel.make_response_from_query_sets( members, column_names, 'xls', file_name=file_name, colnames=colnames, ignore_rows=[0] if len(members) else [1] )
def get(self,request): payroll = Payroll.objects.all() column_names = ['id'] payroll = {} payroll['id'] = 1 return excel.make_response_from_query_sets(payroll,column_names,'xls')
def generate_class_report(request, class_name): user_class_dataset = Class_code.objects.get(class_name = class_name) user_list = [i.user for i in user_class_dataset.class_assignment_set.all() if i.user.role == Role.objects.get(name='student')] column_name = ['pk', 'username', 'firstname', 'lastname', 'role.name'] return excel.make_response_from_query_sets(user_dataset, column_name, 'xlsx', file_name=class_name+'_stu')
def generate_report(request): user_dataset = User.objects.all() column_name = ['pk', 'username', 'firstname', 'lastname', 'role.name'] return excel.make_response_from_query_sets(user_dataset, column_name, 'xlsx', file_name="custom")
def export_data(request, file): if file=='weekly': queryset='' column_names = ['ar_code' ,'location_code' ,'store_name' ,'activity' ,'ctn_activation_date' ,'activity_date' ,'cancel_date' ,'byod' ,'auto_pay' ,'port_type' ,'ban' ,'ctn' ,'imei' ,'operator_id' ,'sub_rank' ,'mrc' ,'previous_mrc' ,'rrc' ,'previous_rrc' ,'activation_commission' ,'plan_migration_commission' ,'incremental_commission' ,'retention_rate' ,'retention_rate_commission' ,'spif1' ,'spif2' ,'national_retail_activation' ,'device_upgrade' ,'device_return' ,'manual_transaction' ,'manual_payment' ,'offset' ,'mdf_payment' ,'commission_payout' ,'comment'] s=str(request.META.get('HTTP_REFERER')) if 'search/all' in s: header= re.search('header=(.*)&', s) value= re.search('q=(.*)$', s) try: header=header.group(1) value=value.group(1) except: messages.error(request,'PLEASE TRY AGAIN WITH VALID QUERYSET TO EXPORT') return redirect(request.META.get('HTTP_REFERER')) if header=='CTN': value=re.sub('[^0-9]','',value) print(value) queryset=Weekly.objects.filter(ctn=value) print(queryset) if header=='IMEI': value=re.sub('[^0-9]','',value) queryset=Weekly.objects.filter(imei=value) if header=='ACTIVITY': value=re.sub('\+',' ',value) queryset=Weekly.objects.filter(activity__icontains=value) else: x=request.session['export'] queryset=Weekly.objects.filter(id__in=x) return excel.make_response_from_query_sets(queryset,column_names,'xls', file_name="customWeeklyCTNfile") if file=='monthly': queryset='' column_names=['location_id' ,'location_name' ,'activity_date' ,'imei' ,'ctn' ,'qualifying_activity_type' ,'product_sku' ,'device_name' ,'promotion_name' ,'promotion_start_date' ,'promotion_end_date' ,'promotion_category' ,'promotion_sale_price' ,'imm_purchase_price' ,'credit_amount' ,'payment_date' ,'ship_date' ,'imm_invoice_number' ,'reason'] s=str(request.META.get('HTTP_REFERER')) if 'search/all' in s: try: header= re.search('header=(.*)&', s) header=header.group(1) value= re.search('q=(.*)$', s) value=value.group(1) except: messages.error(request,'PLEASE TRY AGAIN WITH VALID QUERYSET TO EXPORT') return redirect(request.META.get('HTTP_REFERER')) if header=='CTN': value=re.sub('[^0-9]','',value) queryset=Monthly.objects.filter(ctn=value) if header=='IMEI': value=re.sub('[^0-9]','',value) queryset=Monthly.objects.filter(imei=value) if header=='ACTIVITY': value=re.sub('\+',' ',value) queryset=Monthly.objects.filter(qualifying_activity_type__icontains=value) else: x=request.session['export'] queryset=Monthly.objects.filter(id__in=x) return excel.make_response_from_query_sets(queryset,column_names,'xls', file_name="customMonthlyTrailingfile") if file=='pos': queryset='' column_names=['invoice_number' ,'tracking_number' ,'qty' ,'product_sku' ,'product_name' ,'unit_rebate' ,'partial_cb' ,'total_rebate' ,'collected' ,'balance' ,'tax_amount' ,'carrier_price' ,'related_product' ,'related_sku' ,'related_sn' ,'related_cost' ,'related_price' ,'rate_plan' ,'rate_plan_2' ,'term_code' ,'customer' ,'sales_person' ,'sales_person_id' ,'sold_on' ,'invoiced_by' ,'invoiced_at' ,'original_invoice' ,'original_sales_date' ,'flagged' ,'reconciled' ,'reconciled_by' ,'reconciled_on' ,'adjusted' ,'charge_back' ,'journal_number' ,'contract_number' ,'customer_identifier' ,'comments' ,'comments_2' ,'soc_code' ,'soc_code_2' ,'extra_field' ,'zip_code' ,'region' ,'district' ,'vendor_account_name' ,'vendor_number' ,'vendor_sku' ,'scd_response'] s=str(request.META.get('HTTP_REFERER')) print(s) if 'search/all' in s: header= re.search('header=(.*)&', s) try: header=header.group(1) value= re.search('q=(.*)$', s) value=value.group(1) except: messages.error(request,'PLEASE TRY AGAIN WITH VALID QUERYSET TO EXPORT') return redirect(request.META.get('HTTP_REFERER')) if header=='CTN': value=re.sub('[^0-9]','',value) queryset=POS.objects.filter(tracking_number=value) if header=='IMEI': value=re.sub('[^0-9]','',value) queryset=POS.objects.filter(related_sn=value) if header=='ACTIVITY': value=re.sub('\+',' ',value) queryset=POS.objects.filter(term_code__icontains=value) else: x=request.session['export'] queryset=POS.objects.filter(id__in=x) return excel.make_response_from_query_sets(queryset,column_names,'xls', file_name="customPOSfile") else: return HttpResponseBadRequest( "Bad request. please put one of these " + "in your url suffix: sheet, book or custom")
def handson_table(request, query_sets, fields): """function to render the scoresheets as part of the template""" return excel.make_response_from_query_sets(query_sets, fields, 'handsontable.html')