def init_site(request):
site = _site or request.headers.get('X-Frappe-Site-Name') or get_site_name(request.host)
frappe.init(site=site, sites_path=_sites_path)
if not (frappe.local.conf and frappe.local.conf.db_name):
# site does not exist
raise NotFound
def loader(path):
site = get_site_name(self.environ.get('HTTP_HOST'))
path = os.path.join(directory, site, 'public', 'files', cstr(path))
if os.path.isfile(path):
return os.path.basename(path), self._opener(path)
else:
return None, None
def init_request(request):
frappe.local.request = request
frappe.local.is_ajax = frappe.get_request_header("X-Requested-With")=="XMLHttpRequest"
site = _site or request.headers.get('X-Frappe-Site-Name') or get_site_name(request.host)
frappe.init(site=site, sites_path=_sites_path)
if not (frappe.local.conf and frappe.local.conf.db_name):
# site does not exist
raise NotFound
if frappe.local.conf.get('maintenance_mode'):
raise frappe.SessionStopped
make_form_dict(request)
frappe.local.http_request = frappe.auth.HTTPRequest()
def init_request(request):
frappe.local.request = request
frappe.local.is_ajax = frappe.get_request_header(
"X-Requested-With") == "XMLHttpRequest"
site = _site or request.headers.get('X-Frappe-Site-Name') or get_site_name(
request.host)
frappe.init(site=site, sites_path=_sites_path)
if not (frappe.local.conf and frappe.local.conf.db_name):
# site does not exist
raise NotFound
if frappe.local.conf.get('maintenance_mode'):
frappe.connect()
raise frappe.SessionStopped('Session Stopped')
make_form_dict(request)
if request.method != "OPTIONS":
frappe.local.http_request = frappe.auth.HTTPRequest()
def import_update_items(xml_files):
try:
site_name = get_site_name(frappe.local.request.host)
if site_name == 'localhost':
site_name = 'site1.local'
max_time = 4800
args = {
'xml_files': xml_files,
'site_name': site_name
}
queue="default"
queued_jobs = get_jobs(site=frappe.local.site, queue=queue)
method = "hlk.hlk.page.bkp_importer.bkp_importer._import_update_items"
job_name='Import / Update Items from BKP File(s)'
if method not in queued_jobs[frappe.local.site]:
frappe.msgprint(_("Der Import / Das Updaten wurde gestartet. Bitte warten Sie bis das System Ihnen mitteilt, dass der Auftrag ausgeführt wurde."), 'Import / Update gestartet')
enqueue(method=method, queue=queue, timeout=max_time, event=None, is_async=True, job_name=job_name, now=False, enqueue_after_commit=False, **args)
return
else:
frappe.msgprint(_("Der Backup Job wurde bereits gestartet. Bitte warten Sie bis das System Ihnen mitteilt dass der Job erledigt ist."), 'Bitte Warten')
except:
return 'Error'
def read_xml(file_path, name):
site_name = get_site_name(frappe.local.request.host)
if site_name == 'localhost':
site_name = 'site1.local'
path_to_site_folder = '/home/frappe/frappe-bench/sites/' + site_name
file = path_to_site_folder + file_path
if ".zip" in file_path:
path_to_file_folder = file.replace(
file.split("/")[len(file.split("/")) - 1], "")
name = unzip_file(path_to_file_folder, file)
file = path_to_file_folder + name
with open(file, "r") as f:
contents = f.read()
soup = BeautifulSoup(six.text_type(contents), 'xml')
try:
file = {
'name': name,
'katalog_daten': {
"ID_Anbieter":
soup.DataExpert.Body.Katalog.get("ID_Anbieter"),
'ID_Katalog':
soup.DataExpert.Body.Katalog.get("ID_Katalog"),
'Txt_Katalog':
soup.DataExpert.Body.Katalog.get("Txt_Katalog"),
'Versions_Jahr':
soup.DataExpert.Body.Katalog.get("Versions_Jahr"),
'Versions_Nr':
soup.DataExpert.Body.Katalog.get("Versions_Nr"),
'Preisbuch_Nr':
soup.DataExpert.Body.Katalog.get("Preisbuch_Nr"),
'Dat_Valid_Von':
soup.DataExpert.Body.Katalog.get("Dat_Valid_Von"),
'Sprache':
soup.DataExpert.Head.Code_Sprache.get_text()
}
}
except:
return 'Error'
return file
def guardar_pdf_servidor(nombre_archivo, cae_de_factura_electronica):
'''Descarga factura en servidor y registra en base de datos
Parametros:
----------
* nombre_archivo (str) : Nombre que describe el archivo
* cae_de_factura_electronica (str) : CAE
'''
modalidad_configurada = validar_configuracion()
nombre_de_sitio = get_site_name(frappe.local.site)
ruta_archivo = '{0}/private/files/factura-electronica/'.format(
nombre_de_sitio)
# Verifica que exista un configuracion valida para factura electronica
if modalidad_configurada[0] == 1:
configuracion_factura = frappe.db.get_values(
'Configuracion Factura Electronica',
filters={'name': modalidad_configurada[1]},
fieldname=[
'url_listener', 'descargar_pdf_factura_electronica',
'url_descarga_pdf'
],
as_dict=1)
url_archivo = configuracion_factura[0][
'url_descarga_pdf'] + cae_de_factura_electronica
# Verifica que la funcionalidad para descargar pdf automaticamente, este activa
if configuracion_factura[0][
'descargar_pdf_factura_electronica'] == 'ACTIVAR':
# Si no existe registro en la base de datos procede a descargar y guardar
if not frappe.db.exists('File',
{'file_name': (nombre_archivo + '.pdf')}):
# Verifica existencia ruta de archivo, si no existe la crea, si ya existe descarga el pdf en esa ruta
if os.path.exists(ruta_archivo):
descarga_archivo = os.system(
'curl -s -o {0}{1}.pdf {2}'.format(
ruta_archivo, nombre_archivo, url_archivo))
else:
frappe.create_folder(ruta_archivo)
descarga_archivo = os.system(
'curl -s -o {0}{1}.pdf {2}'.format(
ruta_archivo, nombre_archivo, url_archivo))
# Cuando la descarga es exitosa retorna 0, por lo que si es existosa procede
if descarga_archivo == 0:
# Obtiene el tamaño del archivo en bytes
bytes_archivo = os.path.getsize(
"{0}/private/files/factura-electronica/{1}.pdf".format(
nombre_de_sitio, nombre_archivo))
# Guarda los datos en la base de datos
try:
nuevo_archivo = frappe.new_doc("File")
nuevo_archivo.docstatus = 0
nuevo_archivo.file_name = str(nombre_archivo) + '.pdf'
nuevo_archivo.file_url = '/private/files/factura-electronica/{0}.pdf'.format(
nombre_archivo)
nuevo_archivo.attached_to_name = nombre_archivo
nuevo_archivo.file_size = bytes_archivo
nuevo_archivo.attached_to_doctype = 'Sales Invoice'
nuevo_archivo.is_home_folder = 0
nuevo_archivo.if_folder = 0
nuevo_archivo.folder = 'Home/attachments'
nuevo_archivo.is_private = 1
nuevo_archivo.old_parent = 'Home/attachments'
nuevo_archivo.save()
except:
frappe.msgprint(
_('''Error no se pudo guardar PDF de la factura electronica en la
base de datos. Intente de nuevo.'''
))
else:
return 'ok'
else:
frappe.msgprint(
_('''No se pudo obtener el archivo pdf de la factura electronica.
Por favor intente de nuevo.'''))
def application(request):
response = None
try:
rollback = True
init_request(request)
frappe.recorder.record()
frappe.monitor.start()
frappe.rate_limiter.apply()
if frappe.local.form_dict.cmd:
response = frappe.handler.handle()
elif frappe.request.path.startswith("/api/"):
response = frappe.api.handle()
elif frappe.request.path.startswith('/backups'):
response = frappe.utils.response.download_backup(request.path)
elif frappe.request.path.startswith('/private/files/'):
response = frappe.utils.response.download_private_file(request.path)
elif frappe.local.request.method in ('GET', 'HEAD', 'POST'):
response = frappe.website.render.render()
else:
raise NotFound
except HTTPException as e:
return e
except frappe.SessionStopped as e:
response = frappe.utils.response.handle_session_stopped()
except Exception as e:
response = handle_exception(e)
else:
rollback = after_request(rollback)
finally:
if frappe.local.request.method in ("POST", "PUT") and frappe.db and rollback:
frappe.db.rollback()
# set cookies
if response and hasattr(frappe.local, 'cookie_manager'):
frappe.local.cookie_manager.flush_cookies(response=response)
frappe.rate_limiter.update()
frappe.monitor.stop(response)
frappe.recorder.dump()
frappe.logger("frappe.web", allow_site=frappe.local.site).info({
"site": get_site_name(request.host),
"remote_addr": getattr(request, "remote_addr", "NOTFOUND"),
"base_url": getattr(request, "base_url", "NOTFOUND"),
"full_path": getattr(request, "full_path", "NOTFOUND"),
"method": getattr(request, "method", "NOTFOUND"),
"scheme": getattr(request, "scheme", "NOTFOUND"),
"http_status_code": getattr(response, "status_code", "NOTFOUND")
})
if response and hasattr(frappe.local, 'rate_limiter'):
response.headers.extend(frappe.local.rate_limiter.headers())
frappe.destroy()
return response
def create_labels_pdf(all_unique_labels_lst, sticker_type, production_date,
expiration_date):
#######################################################################################
#
# 2. File Opening and Formatting variables
#
#######################################################################################
site_name = get_site_name(frappe.local.site)
file_path = f'{site_name}/public/files/pdflabels/'
# 2.1 Variables of file and data ot open
fileName_w_ext = "salida.csv"
accessModeUniv_nl = "rU"
accessMode_W = "w"
accessMode_WB = "wb"
dot_pdf = ".pdf"
# 2.2 Register a csv Dialect (can be changed to suit specific csv files)
csv.register_dialect('mydialect',
delimiter=str(','),
quotechar=str('"'),
doublequote=True,
skipinitialspace=True,
lineterminator='\r\n',
quoting=csv.QUOTE_MINIMAL)
# 2.3 strip filename of extension and store it in a variable
fileName_wo_ext = os.path.splitext(os.path.basename(fileName_w_ext))[0]
fileName_PDF_w_ext = fileName_wo_ext + dot_pdf
# 2.3 Formatting Variables, fonts, locale settings, clear command line
#locale.setlocale(locale.LC_ALL, 'en_US') # see python doc 22.2 internationalization
guate = Locale('es', 'GT')
nl = "\n"
dot = "."
space = " "
colon = ":"
dash = "-"
# 2.5 Tildes unicode http://www.fileformat.info/info/unicode/char/00f3/index.htm
a_acute_unicode = b'\xC3\xA1'
e_acute_unicode = b'\xC3\xA9'
i_acute_unicode = b'\xC3\xAD'
o_acute_unicode = b'\xC3\xB3'
u_acute_unicode = b'\xC3\xBA'
n_tilde_unicode = b'\xC3\xB1'
per_unicode = b'\x25'
registered_unicode = b'\xc2\xae'
copyright_unicode = b'\xc2\xa9'
# 2.6 decoded unicode
a_tilde_utf = a_acute_unicode.decode('utf8')
e_tilde_utf = e_acute_unicode.decode('utf8')
i_tilde_utf = i_acute_unicode.decode('utf8')
o_tilde_utf = o_acute_unicode.decode('utf8')
u_tilde_utf = u_acute_unicode.decode('utf8')
n_enie_utf = n_tilde_unicode.decode('utf8')
percent_utf = per_unicode.decode('utf8')
registered_utf = registered_unicode.decode('utf8')
copyright_utf = copyright_unicode.decode('utf8')
html_par_open = "<p>"
html_par_close = "</p>"
html_br = "<br>"
html_div_open = "<div>"
html_div_close = "</div>"
html_span_open = "<span>"
html_span_close = "</span>"
font_path = "fonts/"
# load_font_roboto = "/assets/labels/fonts/roboto/Roboto-Regular.ttf"
load_font_roboto = frappe.get_app_path("labels", "public", "fonts",
"Roboto-Regular.ttf")
image_logo_filename = frappe.get_app_path("labels", "public", "images",
"fogliasana.jpg")
# image_logo_filename = frappe.get_app_path("/", "data", "uom_data.json")
# clear_command_line = os.system('cls' if os.name == 'nt' else 'clear')
# clear_command_line
#######################################################################################
#
# 3. Page size / label size / margins
#
#######################################################################################
# 3.1 GENERAL USER MODIFIABLE VARIABLES.
# These variables represent the most important properties of the barcode.
# We begin with the page or label size in millimeters.
#--------------------------------------------------------------------------------------
# IMPORTANT NOTE ABOUT LABEL PRINTING!!!
# Label printers use the x axis as the width, same here.
# As a general rule, the widest part of the label will be also the x axis.
# Do not alter the orientation aspects of labels when printing, print as portrait!
# FIXME configure a 105mm x 51mm label height: 51mm, width: 105mm
label_height_mm = 38 # default = 38
label_width_mm = 50 # default = 51
lft_mgn = 3 #Left margin in mm (helps to wrap paragraph lines)
rgt_mgn = 3 #Right margin in mm (helps to wrap paragraph lines)
#######################################################################################
#
# 4. Fixed Variables for labels (Days until expiration, field text, etc.)
#
#######################################################################################
#No extra spaces, the string concatenators will handle that. Just the data.
#test_bar_code = "1234567800069"
#test_prod_desc = "Pillow Case Large"
#test_prod_weight = "20"
#test_prod_unit = "Oz."
dest_filename = "barcode-labels"
line3_produced_date_text = "Cosecha:"
line4_expiration_date_text = "Vence:"
days_to_expiration = 7
currency_symb = "Q"
test_price = 30.05 #Price not larger than Q99,000
below_barcode_string = 'Hidropónico Sostenible. Puro'
#######################################################################################
#
# 5. Colors
#
#######################################################################################
# 5.1 Desired colors in RGB value o to 255
rgb_pantone_3005_c_blue = (0, 117, 201)
rgb_pantone_360_c_green = (108, 192, 74)
rgb_pantone_000_c_white = (255, 255, 255)
rgb_pantone_black = (0, 0, 0)
# 5.2 Desired colors in HEX
hex_pantone_3005_c_blue = "#0075c9"
hex_pantone_360_c_green = "#6cc04a"
hex_pantone_000_c_white = "#ffffff"
hex_pantone_black = "#000000"
# 5.3 Convert colors to intensity mode 0- 100%
rgb_pantone_black_int_red = rgb_pantone_black[0] / float(255)
rgb_pantone_black_int_grn = rgb_pantone_black[1] / float(255)
rgb_pantone_black_int_blu = rgb_pantone_black[2] / float(255)
rgb_pantone_3005_c_blue_int_red = rgb_pantone_3005_c_blue[0] / float(255)
rgb_pantone_3005_c_blue_int_grn = rgb_pantone_3005_c_blue[1] / float(255)
rgb_pantone_3005_c_blue_int_blu = rgb_pantone_3005_c_blue[2] / float(255)
# 5.3 bar color assignment
bar_red = rgb_pantone_black_int_red
bar_grn = rgb_pantone_black_int_grn
bar_blu = rgb_pantone_black_int_blu
# 5.4 text color assignment
txt_red = rgb_pantone_black_int_red
txt_grn = rgb_pantone_black_int_grn
txt_blu = rgb_pantone_black_int_blu
# 5.5 bar_stroke_color assignment
stk_red = rgb_pantone_black_int_red
stk_grn = rgb_pantone_black_int_grn
stk_blu = rgb_pantone_black_int_blu
#######################################################################################
#
# 6. Barcode Style parameters
#
#######################################################################################
# 6.1 FONTS Available fonts for the barcode human readable text
# ,Mac expert, standard, symbol, winansi, zapfdingbats, courier, courier bold corierboldoblique courieroblique, helvetica bold, helvetica bold oblique, symbol, times bold times bold italic times italic timesroman zapfdingbats.
barcode_font_name = 'Helvetica' # String. default 'Helvetica'
barcode_font_size = 11 # Number. mm. default = 10
# 6.2 Bars
# 6.2.1 Color. method. default = colors.black, or colors.Color(R,G,B,1), or colors.
bar_fill_color = colors.Color(bar_red, bar_grn, bar_blu, alpha=1)
# 6.2.2 Height, Width, stroke width
bar_height_mm = 15 # Number. default = 13
bar_width_mm = .41 # Number. default = .41
bar_stroke_width = .05 # Number. default = .05
# 6.2.3 Stroke Color. method. default = colors.black
bar_stroke_color = colors.Color(stk_red, stk_grn, stk_blu, alpha=1)
# 6.2.4 Human Readable text color. method. default = colors.black
barcode_text_color = colors.Color(txt_red, txt_grn, txt_blu, alpha=1)
# 6.2.5 Human Readable text switch ON/OFF (TRUE/FALSE)
barcode_human_readable = 'TRUE' # Boolean. Default 'TRUE'
# 6.3 Code NOT WORKING!
barcode_use_quiet_space = 0 # Number integer. 0 = no, 1 = YES. Default = 1
left_quiet_space = 1 # Number integer default = 1 DO NOT CHANGE!!
right_quiet_space = 1 # Number integer default = 1 DO NOT CHANGE!!
"""
#Check this one out!
http://pydoc.net/Python/reportlab/3.3.0/reportlab.graphics.barcode/
"""
# 6.4 Defining the quiet space value
if barcode_use_quiet_space == 'yes':
quiet_space = 'TRUE'
#######################################################################################
#
# 7. Paragraph style parameters for Product Name
#
#######################################################################################
prod_style_name = 'FSBlue' #name your style: 'Stylename'
prod_font_name = 'Helvetica' # default = 'Helvetica'
prod_font_size = 12 # default = 12
prod_leading = 12 # default = 12
prod_left_indent = 0 # default = 0
prod_right_indent = 0 # default = 0
prod_first_line_indent = 0 # default = 0
prod_alignment = TA_LEFT # default = TA_LEFT
prod_space_before = 0 # default = 0
prod_space_after = 0 # default = 0
prod_bullet_font_name = 'Times-Roman' # default = 'Times-Roman'
prod_bullet_font_size = 10 # default = 10
prod_bullet_indent = 0 # default = 0
prod_text_color = hex_pantone_black # default = hex_pantone_3005_c_blue
prod_back_color = None # default = None
prod_word_wrap = None # default = None
prod_border_width = 0 # default = 0
prod_border_padding = 0 # default = 0
prod_border_color = None # default = None
prod_border_radius = None # default = None
prod_allow_widows = 1 # default = 1
prod_allow_orphans = 0 # default = 0
prod_text_transform = None # 'uppercase' | 'lowercase' | None
prod_end_dots = None # default = None
prod_split_long_words = 1 # default = 1
#######################################################################################
#
# 8. Paragraph style parameters for line below product name
#
#######################################################################################
line3_style_name = 'line3' #name your style: 'Stylename'
line3_font_name = 'Helvetica' # default = 'Helvetica'
line3_font_size = 12 # default = 12
line3_leading = 12 # default = 12
line3_left_indent = 0 # default = 0
line3_right_indent = 0 # default = 0
line3_first_line_indent = 0 # default = 0
line3_alignment = TA_LEFT # default = TA_LEFT
line3_space_before = 0 # default = 0
line3_space_after = 0 # default = 0
line3_bullet_font_name = 'Times-Roman' # default = 'Times-Roman'
line3_bullet_font_size = 10 # default = 10
line3_bullet_indent = 0 # default = 0
line3_text_color = hex_pantone_black # default = hex_pantone_3005_c_blue
line3_back_color = None # default = None
line3_word_wrap = None # default = None
line3_border_width = 0 # default = 0
line3_border_padding = 0 # default = 0
line3_border_color = None # default = None
line3_border_radius = None # default = None
line3_allow_widows = 1 # default = 1
line3_allow_orphans = 0 # default = 0
line3_text_transform = None # 'uppercase' | 'lowercase' | None
line3_end_dots = None # default = None
line3_split_long_words = 1 # default = 1
#######################################################################################
#
# 9. Paragraph style parameters for second line below product name
#
#######################################################################################
line4_style_name = 'line4' #name your style: 'Stylename'
line4_font_name = 'Helvetica' # default = 'Helvetica'
line4_font_size = 12 # default = 12
line4_leading = 12 # default = 12
line4_left_indent = 0 # default = 0
line4_right_indent = 0 # default = 0
line4_first_line_indent = 0 # default = 0
line4_alignment = TA_LEFT # default = TA_LEFT
line4_space_before = 0 # default = 0
line4_space_after = 0 # default = 0
line4_bullet_font_name = 'Times-Roman' # default = 'Times-Roman'
line4_bullet_font_size = 10 # default = 10
line4_bullet_indent = 0 # default = 0
line4_text_color = hex_pantone_black # default = hex_pantone_3005_c_blue
line4_back_color = None # default = None
line4_word_wrap = None # default = None
line4_border_width = 0 # default = 0
line4_border_padding = 0 # default = 0
line4_border_color = None # default = None
line4_border_radius = None # default = None
line4_allow_widows = 1 # default = 1
line4_allow_orphans = 0 # default = 0
line4_text_transform = None # 'uppercase' | 'lowercase' | None
line4_end_dots = None # default = None
line4_split_long_words = 1 # default = 1
#######################################################################################
#
# 10. Paragraph style parameters for line below product name
#
#######################################################################################
below_barcode_style_name = 'below-barcode' # name your style: 'Stylename'
below_barcode_font_name = 'Helvetica-bold' # default = 'Helvetica'
below_barcode_font_size = 8 # default = 12
below_barcode_leading = 12 # default = 12
below_barcode_left_indent = 0 # default = 0
below_barcode_right_indent = 0 # default = 0
below_barcode_first_line_indent = 0 # default = 0
below_barcode_alignment = TA_LEFT # default = TA_LEFT
below_barcode_space_before = 0 # default = 0
below_barcode_space_after = 0 # default = 0
below_barcode_bullet_font_name = 'Times-Roman' # default = 'Times-Roman'
below_barcode_bullet_font_size = 10 # default = 10
below_barcode_bullet_indent = 0 # default = 0
below_barcode_text_color = hex_pantone_black # default = hex_pantone_3005_c_blue
below_barcode_back_color = None # default = None
below_barcode_word_wrap = None # default = None
below_barcode_border_width = 0 # default = 0
below_barcode_border_padding = 0 # default = 0
below_barcode_border_color = None # default = None
below_barcode_border_radius = None # default = None
below_barcode_allow_widows = 1 # default = 1
below_barcode_allow_orphans = 0 # default = 0
below_barcode_text_transform = None # 'uppercase' | 'lowercase' | None
below_barcode_end_dots = None # default = None
below_barcode_split_long_words = 0 # default = 1
#######################################################################################
#
# 11. Move everything by x or y mm
#
#######################################################################################
# 7.1 This moves everything by the specified mm. Useful for adjustments on the fly!
# x axis + moves to right, - moves to left
# y axis + moves up, - moves down
move_x_mm = 0
move_y_mm = 0
#######################################################################################
#
# 12. Rotate everything 90 deg to the right, upside down, 90 to the left TODO: Pending!
#
#######################################################################################
#######################################################################################
#
# 13. Positions of elements on page
#
#######################################################################################
# 13.1 Element Individual Starting Positions
# Elements must be placed, measuring from bottom left of label.
# The general structure is
# lINE 1= Product name and weight
# LINE 2= Product name and wight continued
# LINE 3= Produced: (date of production)
# LINE 4= Expires: (date of expiration)
# BARCODE = EAN-13 Barcode
# LINE 5 = Price
# TODO: If nothing specified, an IF function should default to CENTERING EVERYTHING
# In relation to the chosen page size below
# with DEFAULTS! For quick and easy setup.
# 13.2 Product Text position
prod_x_pos_mm = 1 # 51mm x 38mm default = 3
prod_y_pos_mm = 30 # 51mm x 38mm default = 30
# 13.3 "Date of production"
line_3_x_pos_mm = 1 # 51mm x 38mm default = 3
line_3_y_pos_mm = 25 # 51mm x 38mm default = 25
# 13.4 "Expiration date"
#This line is set at 12.4mm from x origin to align the ":" for easier reading.
line_4_x_pos_mm = 10.4 # 51mm x 38mm default = 12.4
line_4_y_pos_mm = 21 # 51mm x 38mm default = 21
# 13.5 Barcode position
barcode_x_pos_mm = 5 # 51mm x 38mm default = 7
barcode_y_pos_mm = 5 # 51mm x 38mm default = 5
# 13.6 Usually the price or another description goes here
below_barcode_x_pos_mm = 3 # 51mm x 38mm default = 19 for centered price
below_barcode_y_pos_mm = .5 # 51mm x 38mm default = 1
# 13.7 a Small number that returns the label group amount.
# If you print 40 labels for a particular code, you can serialize it
# for ease of counting.
label_series_x_pos_mm = 0 # 51mm x 38mm default = 0
label_series_y_pos_mm = 0 # 51mm x 38mm default = 0
# 13.8 logo position
image_logo_x_pos_mm = 16 # 51mm x 38mm default = 0
image_logo_y_pos_mm = 30 # 51mm x 38mm default = 0
image_logo_height_mm = 5 # 51mm x 38mm default = 5
#######################################################################################
#
# 9. Element Wrappers. in mm. Creates a "virtual box" so that text doesn't flow out
#
#######################################################################################
#line_1_2_x_wrap_mm = label_width_mm-lft_mgn-rgt_mgn
#line_1_2_y_wrap_mm = label_height_mm-bar_height_mm
prod_x_wrap_mm = label_width_mm - lft_mgn - rgt_mgn
prod_y_wrap_mm = label_height_mm - bar_height_mm
#Create a wrapper for line 3, so text cuts off rather than intrude elsewhere
line_3_x_wrap_mm = label_width_mm - lft_mgn - rgt_mgn
line_3_y_wrap_mm = label_height_mm - bar_height_mm
#Create a wrapper for line 4, so text cuts off rather than intrude elsewhere
line_4_x_wrap_mm = label_width_mm - lft_mgn - rgt_mgn
line_4_y_wrap_mm = label_height_mm - bar_height_mm
#Create a wrapper for line 4, so text cuts off rather than intrude elsewhere
below_barcode_x_wrap_mm = label_width_mm - lft_mgn - rgt_mgn
below_barcode_y_wrap_mm = label_height_mm - bar_height_mm
#Create a wrapper for label series, so text cuts off rather than intrude elsewhere
label_series_x_wrap_mm = label_width_mm - lft_mgn - rgt_mgn
label_series_y_wrap_mm = label_height_mm - bar_height_mm
#######################################################################################
#
# 9A. Program variables that involve flow control CAREFUL!
#
#######################################################################################
# 2.4 THE VALID PREFIX. If you change this, no barcodes will be printed!
# This prefix must be the one issued by GS1 or prefix issuing authority in your locality.
valid_gs1_prefix = "74011688"
# 2.5 Search string used right before product name
# PLEASE NOTE: Label must be an Item in ERPNext, part of the Bill of Materials of the sales item, and the name must beign with this string, otherwise, the label will not be counted.
desc_search_string = "Etiqueta Normal"
desc_ending_html = html_par_close
#######################################################################################
#
# 10. date calculations (default date is today)
#
#######################################################################################
# 10.1 Date calculation and formatting.
# default= today, or can be specified date(2016, 14, 11)
# production_date = datetime.date.today()
# production_date_print = format_date(production_date,"dd.LLLyyyy" ,locale='es_GT')
production_date_print = production_date
# 10.2 Expiration date calculation and formatting
#Calculates from the production date stated above.
# expiration_date = production_date + datetime.timedelta(days=days_to_expiration)
# expiration_date = expiration_date
# expiration_date_print = format_date(expiration_date,"dd.LLLyyyy" ,locale='es_GT')
expiration_date_print = expiration_date
# 10.3 Destination Filename Variable that includes dates
file_datetime = format_datetime(datetime.datetime.now(),
"yyyy-MM-dd-kk-mm-ss",
locale='es_GT')
# date_time_fileName_PDF_w_ext = file_datetime + dash + dest_filename + dot_pdf
date_time_fileName_PDF_w_ext = 'Label' + file_datetime + dot_pdf
#######################################################################################
#
# 11. Currency formatting
#
#######################################################################################
#2.3 Using python string formatting
#test_price_str = str("%0.2f" % test_price) # no commas
# below format with commas and two decimal points.
#test_format_price = locale.format("%0.2f",test_price, grouping=True)
format_price_print = format_decimal(test_price,
format='#,##0.##;-#',
locale='es_GT')
######################################################
#
# 12. mm to point converter
#
######################################################
"""
For our label, the position must be specified in points. Above the user enters the
values in mm, and these will convert from mm to points. The move_x_mm and move_y_mm
will shift the position of all the items in the label together, when specified by the user.
"""
prod_x_pos = (prod_x_pos_mm + move_x_mm) * mm #10
prod_y_pos = (prod_y_pos_mm + move_y_mm) * mm #95
line_3_x_pos = (line_3_x_pos_mm + move_x_mm) * mm #10
line_3_y_pos = (line_3_y_pos_mm + move_y_mm) * mm #75
line_4_x_pos = (line_4_x_pos_mm + move_x_mm) * mm #10
line_4_y_pos = (line_4_y_pos_mm + move_y_mm) * mm #65
barcode_x_pos = (barcode_x_pos_mm + move_x_mm) * mm #10
barcode_y_pos = (barcode_y_pos_mm + move_y_mm) * mm #95
bar_width = bar_width_mm * mm
bar_height = bar_height_mm * mm
below_barcode_x_pos = (below_barcode_x_pos_mm + move_x_mm) * mm
below_barcode_y_pos = (below_barcode_y_pos_mm + move_y_mm) * mm
label_series_x_pos = (label_series_x_pos_mm + move_x_mm) * mm
label_series_y_pos = (label_series_y_pos_mm + move_y_mm) * mm
image_logo_x_pos = (image_logo_x_pos_mm + move_x_mm) * mm
image_logo_y_pos = (image_logo_y_pos_mm + move_y_mm) * mm
prod_x_wrap = (prod_x_wrap_mm + move_x_mm) * mm
prod_y_wrap = (prod_y_wrap_mm + move_y_mm) * mm
line_3_x_wrap = (line_3_x_wrap_mm + move_x_mm) * mm
line_3_y_wrap = (line_3_y_wrap_mm + move_y_mm) * mm
line_4_x_wrap = (line_4_x_wrap_mm + move_x_mm) * mm
line_4_y_wrap = (line_4_y_wrap_mm + move_y_mm) * mm
below_barcode_x_wrap = (below_barcode_x_wrap_mm + move_x_mm) * mm
below_barcode_y_wrap = (below_barcode_y_wrap_mm + move_y_mm) * mm
label_series_x_wrap = (label_series_x_wrap_mm + move_x_mm) * mm
label_series_y_wrap = (label_series_y_wrap_mm + move_y_mm) * mm
image_logo_height = (image_logo_height_mm + move_y_mm) * mm
######################################################
#
# 12.B Concatenating the text strings
#
######################################################
#2.3 Concatenating the Strings required by the label.
# line_3_text = line3_produced_date_text + production_date_print
line_3_text = line3_produced_date_text + production_date_print
line_4_text = line4_expiration_date_text + expiration_date_print
below_barcode_text = below_barcode_string #currency_symb + format_price_print
#######################################################################################
#
# 13. BEGIN DEFINE LABEL CREATION FUNCTION TODO: Create two types of labels.
#
#######################################################################################
###################################################################################
#
# 13.1 Create a drawing object to contain everything
#
###################################################################################
"""
Create a PDFCanvas object where we will deposit all the elements of the PDF. drawing object, and then add the barcode to the drawing. Add styles to platypus style Then using renderPDF, you place
the drawing on the PDF. Finally, you save the file.
"""
PDFcanvas = canvas.Canvas(
(str(file_path) + str(date_time_fileName_PDF_w_ext)))
PDFcanvas.setPageSize((label_width_mm * mm, label_height_mm * mm))
###################################################################################
#
# 13.2 Apply paragraph styles for entire document
#
###################################################################################
styles = getSampleStyleSheet()
styles.add(
ParagraphStyle(name=prod_style_name,
fontName=prod_font_name,
fontSize=prod_font_size,
leading=prod_leading,
leftIndent=prod_left_indent,
rightIndent=prod_right_indent,
firstLineIndent=prod_first_line_indent,
alignment=prod_alignment,
spaceBefore=prod_space_before,
spaceAfter=prod_space_after,
bulletFontName=prod_bullet_font_name,
bulletFontSize=prod_bullet_font_size,
bulletIndent=prod_bullet_indent,
textColor=prod_text_color,
backColor=prod_back_color,
wordWrap=prod_word_wrap,
borderWidth=prod_border_width,
borderPadding=prod_border_padding,
borderColor=prod_border_color,
borderRadius=prod_border_radius,
allowWidows=prod_allow_widows,
allowOrphans=prod_allow_orphans,
textTransform=prod_text_transform,
endDots=prod_end_dots,
splitLongWords=prod_split_long_words))
styles.add(
ParagraphStyle(name=line3_style_name,
fontName=line3_font_name,
fontSize=line3_font_size,
leading=line3_leading,
leftIndent=line3_left_indent,
rightIndent=line3_right_indent,
firstLineIndent=line3_first_line_indent,
alignment=line3_alignment,
spaceBefore=line3_space_before,
spaceAfter=line3_space_after,
bulletFontName=line3_bullet_font_name,
bulletFontSize=line3_bullet_font_size,
bulletIndent=line3_bullet_indent,
textColor=line3_text_color,
backColor=line3_back_color,
wordWrap=line3_word_wrap,
borderWidth=line3_border_width,
borderPadding=line3_border_padding,
borderColor=line3_border_color,
borderRadius=line3_border_radius,
allowWidows=line3_allow_widows,
allowOrphans=line3_allow_orphans,
textTransform=line3_text_transform,
endDots=line3_end_dots,
splitLongWords=line3_split_long_words))
styles.add(
ParagraphStyle(name=line4_style_name,
fontName=line4_font_name,
fontSize=line4_font_size,
leading=line4_leading,
leftIndent=line4_left_indent,
rightIndent=line4_right_indent,
firstLineIndent=line4_first_line_indent,
alignment=line4_alignment,
spaceBefore=line4_space_before,
spaceAfter=line4_space_after,
bulletFontName=line4_bullet_font_name,
bulletFontSize=line4_bullet_font_size,
bulletIndent=line4_bullet_indent,
textColor=line4_text_color,
backColor=line4_back_color,
wordWrap=line4_word_wrap,
borderWidth=line4_border_width,
borderPadding=line4_border_padding,
borderColor=line4_border_color,
borderRadius=line4_border_radius,
allowWidows=line4_allow_widows,
allowOrphans=line4_allow_orphans,
textTransform=line4_text_transform,
endDots=line4_end_dots,
splitLongWords=line4_split_long_words))
styles.add(
ParagraphStyle(name=below_barcode_style_name,
fontName=below_barcode_font_name,
fontSize=below_barcode_font_size,
leading=below_barcode_leading,
leftIndent=below_barcode_left_indent,
rightIndent=below_barcode_right_indent,
firstLineIndent=below_barcode_first_line_indent,
alignment=below_barcode_alignment,
spaceBefore=below_barcode_space_before,
spaceAfter=below_barcode_space_after,
bulletFontName=below_barcode_bullet_font_name,
bulletFontSize=below_barcode_bullet_font_size,
bulletIndent=below_barcode_bullet_indent,
textColor=below_barcode_text_color,
backColor=below_barcode_back_color,
wordWrap=below_barcode_word_wrap,
borderWidth=below_barcode_border_width,
borderPadding=below_barcode_border_padding,
borderColor=below_barcode_border_color,
borderRadius=below_barcode_border_radius,
allowWidows=below_barcode_allow_widows,
allowOrphans=below_barcode_allow_orphans,
textTransform=below_barcode_text_transform,
endDots=below_barcode_end_dots,
splitLongWords=below_barcode_split_long_words))
###################################################################################
#
# 13.3 Set the FONT load_font_roboto = font_path + "roboto/Roboto-Regular.ttf"
# FIXME
###################################################################################
#barcode_font = FIXME r"/Users/retina/devtools/python-barcode/EAN13-BarcodePDF/fonts/roboto/RobotoRegular.ttf"
#barcode_font = r"/fonts/roboto/RobotoRegular.ttf"
#barcode_font = "fonts/roboto/RobotoRegular.ttf" FIXME
#pdfmetrics.registerFont(TTFont('vera','RobotoRegular.ttf'))
###################################################################################
#
# 13.4 Loop through the list creating the individual labels
#
###################################################################################
#The enumerate function allows access to the list items while the for loop iterates
for index, each_label_tuple in enumerate(all_unique_labels_lst):
# Index variable is initiated above, and returns the index or position of the list item being iterated.
#print("this is the index: " + str(index))
# each_label_tuple is initiated above, and is usedby enumerate to return the
# contents of the current list item being iterated.
#print("this is the tuple item: " + str(each_label_tuple))
###############################################################################
#
# 13.4.1 Obtain the contents of the unique label list tuples
#
###############################################################################
curr_tuple_label_desc = str(each_label_tuple[0])
curr_tuple_label_barcode = str(each_label_tuple[1])
#print("Current Code from tuple: " + curr_tuple_label_barcode)
#print("Current Product from tuple: " + curr_tuple_label_desc)
###############################################################################
#
# 13.4.2 Draw the EAN-13 Code
#
###############################################################################
# Pass barcode creation parameters to reportlab, any order, as name=value pairs.
# Order may be changed, since reportlab maps name=value pairs automatically.
# Source code for ordering
# http://pydoc.net/Python/reportlab/3.3.0/reportlab.graphics.barcode.eanbc/
barcode_eanbc13 = eanbc.Ean13BarcodeWidget(
value=curr_tuple_label_barcode,
fontName=barcode_font_name,
fontSize=barcode_font_size,
x=barcode_x_pos,
y=barcode_y_pos,
barFillColor=bar_fill_color,
barHeight=bar_height,
barWidth=bar_width,
barStrokeWidth=bar_stroke_width,
barStrokeColor=bar_stroke_color,
textColor=barcode_text_color,
humanReadable=barcode_human_readable,
quiet=barcode_use_quiet_space,
lquiet=1,
rquiet=1)
###############################################################################
#
# 13.4.? Create the drawing using the same size as the label indicated above
#
###############################################################################
#size of drawing?
d = Drawing(label_width_mm * mm, label_height_mm * mm)
###############################################################################
#
# 13.4.? Set the text fill color for strings
#
###############################################################################
PDFcanvas.setFillColorRGB(txt_red, txt_grn,
txt_blu) #choose your font color
###############################################################################
#
# 13.4.? OPTIONAL. Populate the PDF with strings and images
#
###############################################################################
#PDFcanvas.drawString(line_1_x_pos,line_1_y_pos,line_1_txt)
#PDFcanvas.drawString(line_2_x_pos,line_2_y_pos,line_2_txt)
#PDFcanvas.drawString(line_3_x_pos,line_3_y_pos,line_3_txt)
#PDFcanvas.drawString(line_4_x_pos,line_4_y_pos,line_4_txt)
PDFcanvas.drawString(image_logo_x_pos + 62, image_logo_y_pos,
registered_utf)
PDFcanvas.drawImage(image_logo_filename,
image_logo_x_pos,
image_logo_y_pos,
width=None,
height=image_logo_height,
mask=None,
preserveAspectRatio=True,
anchor='c')
###############################################################################
#
# 13.4.? Add the barcode and position it on the PDFcanvas
#
###############################################################################
d.add(barcode_eanbc13)
# Place the generated barcode on the page.
# (Drawing object, Barcode object, x position, y position)
renderPDF.draw(d, PDFcanvas, 0, 0)
#PDFcanvas.setFont('vera', 32)
#This draws the text strings, gets position numbers from variables at beggining of file.
""" OPTIONAL IF YOU REGISTER A BARCODE FONT, THIS IS ANOTHER WAY TO SET IT UP
barcode_string = '<font name="Free 3 of 9 Regular" size="12">%s</font>'
barcode_string = barcode_string % "1234567890"
"""
#line_1_and_2 = '<font name="Helvetica" size="12">%s</font>'
#line_1_and_2 = line_1_and_2 % line_1_txt
###############################################################################
#
# 13.4.? Add the Product description as a paragraph
#
###############################################################################
label_prod_desc_area = Paragraph(curr_tuple_label_desc,
style=styles["FSBlue"])
label_prod_desc_area.wrapOn(PDFcanvas, prod_x_wrap, prod_y_wrap)
label_prod_desc_area.drawOn(PDFcanvas, prod_x_pos, prod_y_pos, mm)
###############################################################################
#
# 13.4.? Add line 3 (below Prod description 1 or 2 lines) as a paragraph
#
###############################################################################
# No Mostrara las fechas
if sticker_type == '0':
pass
# Mostrara unicamente la fecha de cosecha
if sticker_type == '1':
label_line3_area = Paragraph(line_3_text, style=styles["line3"])
label_line3_area.wrapOn(PDFcanvas, line_3_x_wrap, line_3_y_wrap)
label_line3_area.drawOn(PDFcanvas, line_3_x_pos, line_3_y_pos, mm)
# Mostrara unicamente la fecha de vencimiento
if sticker_type == '2':
label_line4_area = Paragraph(line_4_text, style=styles["line4"])
label_line4_area.wrapOn(PDFcanvas, line_4_x_wrap, line_4_y_wrap)
label_line4_area.drawOn(PDFcanvas, line_4_x_pos, line_4_y_pos, mm)
if sticker_type == '3':
label_line3_area = Paragraph(line_3_text, style=styles["line3"])
label_line3_area.wrapOn(PDFcanvas, line_3_x_wrap, line_3_y_wrap)
label_line3_area.drawOn(PDFcanvas, line_3_x_pos, line_3_y_pos, mm)
label_line4_area = Paragraph(line_4_text, style=styles["line4"])
label_line4_area.wrapOn(PDFcanvas, line_4_x_wrap, line_4_y_wrap)
label_line4_area.drawOn(PDFcanvas, line_4_x_pos, line_4_y_pos, mm)
###############################################################################
#
# 13.4.? Add line 4 (below line 3) as a paragraph
#
###############################################################################
###############################################################################
#
# 13.4.? Add below barcode as a paragraph
# NOTE: This is NOT the group of human readable numbers below barcode!
###############################################################################
label_below_barcode_area = Paragraph(below_barcode_text,
style=styles["below-barcode"])
label_below_barcode_area.wrapOn(PDFcanvas, below_barcode_x_wrap,
below_barcode_y_wrap)
label_below_barcode_area.drawOn(PDFcanvas, below_barcode_x_pos,
below_barcode_y_pos, mm)
PDFcanvas.showPage()
if os.path.exists(file_path):
PDFcanvas.save()
else:
# This portion creates the folder where the sticker file will be saved to.
frappe.create_folder(file_path)
# This portion creates the folder and saves it to the sites directory specified.
PDFcanvas.save()
saved_status = create_file_doctype_and_attach(
file_path, str(date_time_fileName_PDF_w_ext))
return saved_status
def leave_application_confirmation(self, method):
site_name = get_site_name(frappe.local.request.host)
s = get_request_session()
url = "https://fcm.googleapis.com/fcm/send"
employee_user = frappe.db.sql("SELECT frappe_userid FROM `tabUser` WHERE email=(SELECT user_id FROM `tabEmployee` WHERE name='{}')".format(self.employee),as_dict=True)
if len(employee_user) > 0:
employee_user_id = employee_user[0]['frappe_userid']
token = normalize_firebase_string(str(site_name) + "_" + employee_user_id)
header = {"Authorization": "key=AAAAF7fHjjc:APA91bG80Es5LdTCs0fqtfktsyFHDR_r7q1QkQ3tObsgQqMbEngOhMJ1f6dJcP7mA0N0QIkBJuGIv9qGY_OFz7yC5NLChxu6Ci3ubYtB-yC6WBqbgD3iCB-1a89i9cEXHZ6hO0_EP0IZyTOp99a2uiDa6L1a433DCg","Content-Type": "application/json"}
content = {
"to":"/topics/{}".format(token),
"data":
{
"subject":"{}".format(employee_user_id),
"app":"next_ess",
#notification
"title_id":"leave_application_approval_received",
"body":"",
#data
"action":"leave_application_confirmation",
"name":self.name,
"leave_approver_name":self.leave_approver_name,
"status":self.status
}
}
res = s.post(url=url,headers=header,data=json.dumps(content))
leave_approver_user = employee_user = frappe.db.sql("SELECT frappe_userid FROM `tabUser` WHERE email='{}'".format(self.leave_approver),as_dict=True)
if len(leave_approver_user) > 0:
leave_approver_user_id = leave_approver_user[0]['frappe_userid']
token = normalize_firebase_string(str(site_name) + "_" + leave_approver_user_id)
header = {"Authorization": "key=AAAAF7fHjjc:APA91bG80Es5LdTCs0fqtfktsyFHDR_r7q1QkQ3tObsgQqMbEngOhMJ1f6dJcP7mA0N0QIkBJuGIv9qGY_OFz7yC5NLChxu6Ci3ubYtB-yC6WBqbgD3iCB-1a89i9cEXHZ6hO0_EP0IZyTOp99a2uiDa6L1a433DCg","Content-Type": "application/json"}
content = {
"to":"/topics/{}".format(token),
"data":
{
"subject":"{}".format(leave_approver_user_id),
"app":"next_ess",
#notification
"title_id":"leave_application_has_been_update",
"body":"",
#data
"action":"leave_application_confirmation",
"name":self.name,
"leave_approver_name":self.leave_approver_name,
"status":self.status
}
}
res = s.post(url=url,headers=header,data=json.dumps(content))
return "success"