def _create_fiscal_years(self):
try:
# Assumes that exactly one fiscal year has been created so far
# Creates fiscal years till oldest ledger entry date is covered
from frappe.utils.data import add_years, getdate
from itertools import chain
smallest_ledger_entry_date = getdate(min(entry["date"] for entry in chain(*self.gl_entries.values()) if entry["date"]))
oldest_fiscal_year = frappe.get_all("Fiscal Year",
fields=["year_start_date", "year_end_date"],
order_by="year_start_date"
)[0]
# Keep on creating fiscal years
# until smallest_ledger_entry_date is no longer smaller than the oldest fiscal year's start date
while smallest_ledger_entry_date < oldest_fiscal_year.year_start_date:
new_fiscal_year = frappe.get_doc({"doctype": "Fiscal Year"})
new_fiscal_year.year_start_date = add_years(oldest_fiscal_year.year_start_date, -1)
new_fiscal_year.year_end_date = add_years(oldest_fiscal_year.year_end_date, -1)
if new_fiscal_year.year_start_date.year == new_fiscal_year.year_end_date.year:
new_fiscal_year.year = new_fiscal_year.year_start_date.year
else:
new_fiscal_year.year = "{}-{}".format(new_fiscal_year.year_start_date.year, new_fiscal_year.year_end_date.year)
new_fiscal_year.save()
oldest_fiscal_year = new_fiscal_year
frappe.db.commit()
except Exception as e:
self._log_error(e)
def _create_fiscal_years(self):
try:
# Assumes that exactly one fiscal year has been created so far
# Creates fiscal years till oldest ledger entry date is covered
from frappe.utils.data import add_years, getdate
from itertools import chain
smallest_ledger_entry_date = getdate(min(entry["date"] for entry in chain(*self.gl_entries.values()) if entry["date"]))
oldest_fiscal_year = frappe.get_all("Fiscal Year",
fields=["year_start_date", "year_end_date"],
order_by="year_start_date"
)[0]
# Keep on creating fiscal years
# until smallest_ledger_entry_date is no longer smaller than the oldest fiscal year's start date
while smallest_ledger_entry_date < oldest_fiscal_year.year_start_date:
new_fiscal_year = frappe.get_doc({"doctype": "Fiscal Year"})
new_fiscal_year.year_start_date = add_years(oldest_fiscal_year.year_start_date, -1)
new_fiscal_year.year_end_date = add_years(oldest_fiscal_year.year_end_date, -1)
if new_fiscal_year.year_start_date.year == new_fiscal_year.year_end_date.year:
new_fiscal_year.year = new_fiscal_year.year_start_date.year
else:
new_fiscal_year.year = "{}-{}".format(new_fiscal_year.year_start_date.year, new_fiscal_year.year_end_date.year)
new_fiscal_year.save()
oldest_fiscal_year = new_fiscal_year
frappe.db.commit()
except Exception as e:
self._log_error(e)
def create_fiscal_years(vouchers):
from frappe.utils.data import add_years, getdate
earliest_date = getdate(min(voucher["posting_date"] for voucher in vouchers))
oldest_year = frappe.get_all("Fiscal Year", fields=["year_start_date", "year_end_date"], order_by="year_start_date")[0]
while earliest_date < oldest_year.year_start_date:
new_year = frappe.get_doc({"doctype": "Fiscal Year"})
new_year.year_start_date = add_years(oldest_year.year_start_date, -1)
new_year.year_end_date = add_years(oldest_year.year_end_date, -1)
if new_year.year_start_date.year == new_year.year_end_date.year:
new_year.year = new_year.year_start_date.year
else:
new_year.year = "{}-{}".format(new_year.year_start_date.year, new_year.year_end_date.year)
new_year.save()
oldest_year = new_year
def vorschau(von='Kein von',
fuer='Kein für',
widmung='Keine Widmung',
betrag=0,
motiv=''):
gutschein = frappe.get_doc("Gutschein", 'Gutschein-000001')
gutschein.text_from = von
gutschein.text_to = fuer
gutschein.inscription = widmung.replace("\n", "<br>")
gutschein.amount = betrag
gutschein.selling_date = nowdate()
gutschein.valid_date = add_years(nowdate(), 5)
if motiv == 'Herz':
motiv = 'Wintergruss'
if motiv == 'Blumen':
motiv = 'Herbstblüte'
if motiv == 'Blumen2':
motiv = 'Glücksbringer'
if motiv == 'Hortensien':
motiv = 'Sommergarten'
if motiv == 'Tulpenstrauss':
motiv = 'Frühlingsstrauss'
gutschein.motiv = motiv
gutschein.save(ignore_permissions=True)
return
def background_rechnungslauf(self):
sinv_to_print = []
for mitgliedschaft in self.auslaufende_mitgliedschaften:
mitgliedschaft = frappe.get_doc("Mitgliedschaft",
mitgliedschaft.mitgliedschaft)
neue_mitgliedschaft = frappe.get_doc({
"doctype":
"Mitgliedschaft",
"mitglied":
mitgliedschaft.mitglied,
"mitgliedschafts_typ":
mitgliedschaft.mitgliedschafts_typ,
"start":
mitgliedschaft.ende,
"ende":
add_years(mitgliedschaft.ende, 1),
"customer":
mitgliedschaft.customer,
"rechnung_an_dritte":
mitgliedschaft.rechnung_an_dritte,
"rechnungsempfaenger":
mitgliedschaft.rechnungsempfaenger
})
neue_mitgliedschaft.insert()
rechnung = create_invoice(neue_mitgliedschaft.name)
neue_mitgliedschaft.rechnung = rechnung
neue_mitgliedschaft.save()
mitgliedschaft.neue_mitgliedschaft = neue_mitgliedschaft.name
mitgliedschaft.save()
if self.asap_print == 1:
rechnung = frappe.get_doc("Sales Invoice", rechnung)
rechnung.submit()
sinv_to_print.append(rechnung.name)
if self.asap_print == 1:
qty = 0
sales_invoices = []
for sinv in sinv_to_print:
qty += 1
sales_invoices.append(sinv)
if qty > 0:
bind_source = "/assets/spo/sinvs_for_print/{rechnungslauf}/Rechnungslauf_{rechnungslauf}.pdf".format(
rechnungslauf=self.name)
physical_path = "/home/frappe/frappe-bench/sites" + bind_source
pdf_batch(sales_invoices,
format="Mitgliederrechnung",
dest=str(physical_path),
name=self.name)
frappe.db.sql(
"""UPDATE `tabMitglieder Rechnungslauf` SET `rechnungen_erstellt` = 1 WHERE `name` = '{name}'"""
.format(name=self.name),
as_list=True)
def make_membership(self):
doc = frappe.new_doc("Library Membership")
doc.set('library_member', self.name)
doc.set('member_first_name', self.first_name)
doc.set('member_last_name', self.last_name)
doc.set('from_date', nowdate())
doc.set('to_date', add_years(nowdate(), 1))
doc.save()
def make_meebership(self):
doc=frappe.new_doc("Membership")
doc.set('member_name',self.name)
doc.set('member_frist_name',self.frist_name)
doc.set('member_last_name',self.last_name)
doc.set('status','Active')
doc.set('email',self.email)
doc.set('phone',self.phone)
doc.set('form_date',nowdate())
doc.set('to_date',add_years(nowdate(),1))
doc.save()
doc.submit()
frappe.msgprint("Libray Membership Are Generate For 1 Year")
def post_earned_leaves():
date = add_years(frappe.utils.nowdate(), 1)
start = get_first_day(date);
end = get_last_day(date);
employees = frappe.db.sql("select name, employee_name from `tabEmployee` where status = 'Active' and employment_type in (\'Regular employees\', \'Contract\')", as_dict=True)
for e in employees:
la = frappe.new_doc("Leave Allocation")
la.employee = e.name
la.employee_name = e.employee_name
la.leave_type = "Casual Leave"
la.from_date = str(start)
la.to_date = str(end)
la.carry_forward = cint(0)
la.new_leaves_allocated = flt(10)
la.submit()
def post_earned_leaves():
date = add_years(frappe.utils.nowdate(), 1)
start = get_first_day(date)
end = get_last_day(date)
employees = frappe.db.sql(
"select name, employee_name from `tabEmployee` where status = 'Active' and employment_type in (\'Regular employees\', \'Contract\')",
as_dict=True)
for e in employees:
la = frappe.new_doc("Leave Allocation")
la.employee = e.name
la.employee_name = e.employee_name
la.leave_type = "Casual Leave"
la.from_date = str(start)
la.to_date = str(end)
la.carry_forward = cint(0)
la.new_leaves_allocated = flt(10)
la.submit()
def create_gutschein(type='Klassisch',
amount=0,
valid_date='',
barcode='',
salutation='',
company='',
first_name='',
last_name='',
street='',
plz='',
city='',
email='',
phone='',
text_from='',
text_to='',
inscription='',
informationen='',
motiv='',
edge=0):
barcode = barcode.replace("<", "<")
barcode = barcode.replace(">", ">")
barcode = barcode.replace("<svg-x", "<svg")
barcode = barcode.replace("<g-x", "<g")
barcode = barcode.replace("<rect-x>", "</rect>")
barcode = barcode.replace("<rect-x ", "<rect ")
barcode = barcode.replace("svg-x>", "svg>")
barcode = barcode.replace("g-x>", "g>")
barcode = barcode.replace("x-y=", "y=")
barcode = barcode.replace("x-x=", "x=")
barcode = barcode.replace("</rect-x>", "")
barcode = barcode.replace(
'<text style="font: 20px monospace;">',
'<text style="font: 20px monospace;" ' + barcode.split("!*!")[6] +
' text-anchor="middle">')
barcode = barcode.replace(
'<text style="font: 20px monospace;" ' + barcode.split("!*!")[6] +
' text-anchor="middle">', '<text style="font: 20px monospace;" ' +
barcode.split("!*!")[5] + ' text-anchor="middle">', 5)
barcode = barcode.replace(
'<text style="font: 20px monospace;" ' + barcode.split("!*!")[5] +
' text-anchor="middle">', '<text style="font: 20px monospace;" ' +
barcode.split("!*!")[4] + ' text-anchor="middle">', 4)
barcode = barcode.replace(
'<text style="font: 20px monospace;" ' + barcode.split("!*!")[4] +
' text-anchor="middle">', '<text style="font: 20px monospace;" ' +
barcode.split("!*!")[3] + ' text-anchor="middle">', 3)
barcode = barcode.replace(
'<text style="font: 20px monospace;" ' + barcode.split("!*!")[3] +
' text-anchor="middle">', '<text style="font: 20px monospace;" ' +
barcode.split("!*!")[2] + ' text-anchor="middle">', 2)
barcode = barcode.replace(
'<text style="font: 20px monospace;" ' + barcode.split("!*!")[2] +
' text-anchor="middle">', '<text style="font: 20px monospace;" ' +
barcode.split("!*!")[1] + ' text-anchor="start">', 1)
barcode = barcode.split("!*!")[0]
#frappe.throw(str(barcode))
if motiv == 'Herz':
motiv = 'Wintergruss'
if motiv == 'Blumen':
motiv = 'Herbstblüte'
if motiv == 'Blumen2':
motiv = 'Glücksbringer'
if motiv == 'Hortensien':
motiv = 'Sommergarten'
if motiv == 'Tulpenstrauss':
motiv = 'Frühlingsstrauss'
if type != "print@home":
mail = "Bestellbestätigung (Klassisch, EC)"
else:
if int(edge) == 1:
mail = 'Bestellbestätigung ohne PDF (P@H Edge)'
else:
if int(amount) < 250:
mail = 'Bestellbestätigung mit PDF (P@H)'
else:
mail = 'Bestellbestätigung ohne PDF (P@H Bonitätsprüfung)'
gutschein = frappe.get_doc({
"doctype": "Gutschein",
"type": type,
"amount": amount,
"selling_date": nowdate(),
"valid_date": add_years(nowdate(), 5),
"barcode": barcode,
"salutation": salutation,
"company": company,
"first_name": first_name,
"last_name": last_name,
"street": street,
"plz": plz,
"city": city,
"email": email,
"phone": phone,
"text_from": text_from,
"text_to": text_to,
"inscription": inscription,
"informationen": informationen,
"motiv": motiv,
"edge": edge,
"mail_spezifikation": mail
})
gutschein.insert(ignore_permissions=True)
return gutschein.name