def toxml():
from xml.etree.ElementTree import ElementTree,Element, SubElement, tostring
from aplikace.models import Product,Promena
prom=Promena.query.filter_by(promena='cena').first()
prom = float(prom.hodnota)
root = Element('SHOP')
for polozka in Product.all():
# for polozka in Product.filter_by_Popis('3/8x4'):
child = SubElement(root, "SHOPITEM")
child_id_product = SubElement(child, "ID_PRODUCT")
child_id_product.text = str(polozka.id)
child_product_name = SubElement(child, "PRODUCT_NAME")
child_product_name.text = polozka.Popis.encode('utf-8').decode('utf-8')
child_category_text = SubElement(child, "CATEGORY_TEXT")
child_category_text.text = str(polozka.Skupina[:2])
child_description_short = SubElement(child, "DESCRIPTION_SHORT")
description=polozka.Popis.encode('utf-8').decode('utf-8')
if polozka.KL:
description=description + '<br>Produktovy list viz.: <a href=' + polozka.KL+ '>Odkaz</a>'
if polozka.TL:
description=description + '<br>Technicky list viz.: <a href=' + polozka.TL+ '>Odkaz</a>'
if polozka.Foto:
description=description + '<br>Obrazek viz.: <a href=' + polozka.Foto+ '>Odkaz</a>'
child_description_short.text = description
child_manufacturer = SubElement(child, "MANUFACTURER")
child_manufacturer.text = "Online"
if polozka.Foto:
child_img = SubElement(child, "IMG_URL")
child_img.text = str(polozka.Foto)
if polozka.CenaProdej == 0:
child_price = SubElement(child, "PRICE")
child_price.text = "Na dotaz"
else:
child_price = SubElement(child, "PRICE")
child_price.text = str(polozka.CenaProdej*(100+prom)/100)
child_vat = SubElement(child, "VAT")
child_vat.text = "21"
child_quantity = SubElement(child, "QUANTITY")
child_quantity.text = str(polozka.sklad)
child_ean = SubElement(child, "EAN")
child_ean.text = str(polozka.UID)
child_reference = SubElement(child, "REFERENCE")
child_reference.text = str(polozka.Obj)
# print root
# tree = ElementTree(root)
# tree.write('out.xml',xml_declaration=True,encoding='utf-8',method="xml")
APP_DIR=dev_config.PROJECT_ROOT
f = open(APP_DIR + '/app/static/vystup.xml','w')
f.write(tostring(root)) # python will convert \n to os.linesep
f.close()
# return Response(tostring(root), mimetype='text/xml')
return "Ok"
def toxml():
from xml.etree.ElementTree import ElementTree, Element, SubElement, tostring
from aplikace.models import Product, Promena
prom = Promena.query.filter_by(promena='cena').first()
prom = float(prom.hodnota)
root = Element('SHOP')
for polozka in Product.all():
# for polozka in Product.filter_by_Popis('3/8x4'):
child = SubElement(root, "SHOPITEM")
child_id_product = SubElement(child, "ID_PRODUCT")
child_id_product.text = str(polozka.id)
child_product_name = SubElement(child, "PRODUCT_NAME")
child_product_name.text = polozka.Popis.encode('utf-8').decode('utf-8')
child_category_text = SubElement(child, "CATEGORY_TEXT")
child_category_text.text = str(polozka.Skupina[:2])
child_description_short = SubElement(child, "DESCRIPTION_SHORT")
description = polozka.Popis.encode('utf-8').decode('utf-8')
if polozka.KL:
description = description + '<br>Produktovy list viz.: <a href=' + polozka.KL + '>Odkaz</a>'
if polozka.TL:
description = description + '<br>Technicky list viz.: <a href=' + polozka.TL + '>Odkaz</a>'
if polozka.Foto:
description = description + '<br>Obrazek viz.: <a href=' + polozka.Foto + '>Odkaz</a>'
child_description_short.text = description
child_manufacturer = SubElement(child, "MANUFACTURER")
child_manufacturer.text = "Online"
if polozka.Foto:
child_img = SubElement(child, "IMG_URL")
child_img.text = str(polozka.Foto)
if polozka.CenaProdej == 0:
child_price = SubElement(child, "PRICE")
child_price.text = "Na dotaz"
else:
child_price = SubElement(child, "PRICE")
child_price.text = str(polozka.CenaProdej * (100 + prom) / 100)
child_vat = SubElement(child, "VAT")
child_vat.text = "21"
child_quantity = SubElement(child, "QUANTITY")
child_quantity.text = str(polozka.sklad)
child_ean = SubElement(child, "EAN")
child_ean.text = str(polozka.UID)
child_reference = SubElement(child, "REFERENCE")
child_reference.text = str(polozka.Obj)
# print root
# tree = ElementTree(root)
# tree.write('out.xml',xml_declaration=True,encoding='utf-8',method="xml")
APP_DIR = dev_config.PROJECT_ROOT
f = open(APP_DIR + '/app/static/vystup.xml', 'w')
f.write(tostring(root)) # python will convert \n to os.linesep
f.close()
# return Response(tostring(root), mimetype='text/xml')
return "Ok"
def data_ean13_update():
from aplikace.models import Product
# from locale import atof
from utils import ean13
id = 0
for polozka in Product.all():
data = Product.find_by_id(polozka.id)
data.UID = ean13()
data.update(commit=False)
db.session.commit()
return True
def data_ean13_update():
from aplikace.models import Product
# from locale import atof
from utils import ean13
id=0
for polozka in Product.all():
data=Product.find_by_id(polozka.id)
data.UID=ean13()
data.update(commit=False)
db.session.commit()
return True
