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 reportshome(request):
if request.method == "POST":
channel = request.POST.get('channel')
if (channel == "FlipDB"):
selectDB = FlipDB
elif (channel == "SnapDB"):
selectDB = SnapDB
elif (channel == "PayDB"):
selectDB = PayDB
elif (channel == "Stock"):
selectDB = Stock
elif (channel == "Adjusted"):
selectDB = Adjusted
elif (channel == "Details"):
selectDB = Mapping
elif (channel == "Purchased"):
selectDB = Purchased
elif (channel == "FlipReturns"):
selectDB = FlipRetDB
elif (channel == "SnapReturns Courier"):
selectDB = SnapRetDB
elif (channel == "SnapReturns Buyer"):
selectDB = SnapRetBuyerDB
return excel.make_response_from_a_table(selectDB,
'xls',
file_name=channel)
return render(request, 'rhome.html')
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_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 subhistorico():
Hso = HistoricoBienvenida()
con = sqlite3.connect(':memory:')
if request.method == 'POST':
form = UploadForm(request.POST, request.FILES)
if form.is_valid():
filex = request.FILES['filex']
data = pd.read_excel(filex, header=0)
#fech = request.POST.get('data')
#date = time.strptime(request.POST['data'], "%m/%d/%y")
#ISO_date = '{}-{:02}-{:02}'.format(date.tm_year, date.tm_mon, date.tm_mday)
#data=pd.DataFrame()
print(len(data))
#print(type(date))
data["Driver_ID"] = data["Driver_ID"].astype('str')
print(format(data.iloc[3][0]))
cont = 0
"""
while cont < len(data):
Hso.driver_id=format(data.iloc[cont][0])
#Hso.date=timezone.now()
Hso.monto_pago=0
Hso.save()
cont = cont+1
#"""
#data.to_sql(name='historicoB', con=con, if_exists='append')
"""
filename = filex.name
extension = filename.split(".")[-1]
#content = request.FILES['filex'].read()
sheet = pe.get_sheet(file_type=extension, file_content=filex.read())
print(len(sheet))
cont = 0
while cont < sheet.number_of_rows():
c=HistoricoBienvenida(driver_id=format(sheet[cont, 0]),fecha_emitido=date)
c.save()
cont = cont+1
"""
return excel.make_response_from_a_table(HistoricoBienvenida,
'xlsx',
file_name="sheet")
else:
form = UploadForm()
return render(request, 'winn/basic.html', {'form': form})
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 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_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_operations(request, atype):
if atype == 'data':
data = [[1, 2, 3], [4, 5, 6]]
sheet = excel.pe.Sheet(data)
return excel.make_response(sheet, 'xlsx')
elif atype == "sheet2":
return excel.make_response_from_a_table(Operation,
'xlsx',
file_name='sheet2')
elif atype == "sheet":
query_sets = Operation.objects.all().values_list(
'operation_date', 'label', 'debit_or_credit', 'account', 'amount',
'vat_rate', 'provision_rate', 'all_tax_included', 'apply_vat',
'apply_provision')
column_names = [
'operation_date',
'label',
'debit_or_credit',
'account',
'amount',
'vat_rate',
'vat_amount',
'provision_rate',
'provision_amount',
'all_tax_included',
'apply_vat',
'apply_provision',
]
return excel.make_response_from_array(query_sets,
'xlsx',
file_name='sheet')
# return excel.make_response_from_a_table(
# Operation, 'xlsx', file_name="sheet")
else:
return HttpResponseBadRequest(
"Bad request. please put one of these " +
"in your url suffix: sheet, book or custom")
def handson_table(request):
return excel.make_response_from_a_table(Listing, 'handsontable.html')
def export(request):
return excel.make_response_from_a_table(user_data,
'csv',
file_name="sheet")
def export_data(request):
return excel.make_response_from_a_table(
Requirement, 'xlsx', file_name="ApprovalMasterSheet")
def get(self, request, what=None):
if not request.user.is_authenticated():
return redirect('login_user')
if not what:
raise Resolver404('Not Found')
if what == 'users':
if not request.user.has_perms(['can_view_user']):
raise PermissionDenied('permission denied')
self.query_sets = User.objects.all()
self.columns = [
'account_id', 'first_name', 'last_name', 'email', 'contact',
'address', 'date_joined', 'username', 'user_status'
]
self.file_name = 'members-list-' + self.date_today
elif what == 'contributions':
if not request.user.has_perms(['can_view_contributions']):
raise PermissionDenied('permission denied')
self.query_sets = Contribution.objects.all()
self.columns = [
'user_id', 'contribution_date', 'deposit', 'penalty', 'total'
]
self.file_name = 'contributions-list-' + self.date_today
elif what == 'investments':
if not request.user.has_perms(['can_view_investments']):
raise PermissionDenied('permission denied')
self.file_name = 'investments-list-' + self.date_today
return excel.make_response_from_a_table(Investment,
self.file_type,
file_name=self.file_name)
elif what == 'loans':
if not request.user.has_perms(['can_view_loans']):
raise PermissionDenied('permission denied')
self.query_sets = Loan.objects.all()
self.columns = [
'user_id', 'loan_date', 'loan_duration', 'loan_amount',
'amount_paid', 'sur_charge', 'sub_total', 'loan_interest',
'total_amount', 'outstanding_balance', 'loan_status'
]
self.file_name = 'Loans-list-' + self.date_today
elif what == 'user_contributions':
self.query_sets = Contribution.objects.filter(user=request.user)
self.columns = [
'user_id', 'contribution_date', 'deposit', 'penalty', 'total'
]
self.file_name = 'my_contributions-' + self.date_today
else:
raise Resolver404('URL Not Understood')
if not self.query_sets or not self.columns or not self.file_name:
raise Resolver404('Could Not export data')
try:
return excel.make_response_from_query_sets(
self.query_sets,
self.columns,
self.file_type,
file_name=self.file_name)
except Exception as e:
raise e
