def catalog_xml(self, cr, uid, ids, data, context, cwid="0"):
impl = minidom.getDOMImplementation()
doc = impl.createDocument(None, "report", None)
catalog = doc.createElement("catalog")
doc.documentElement.appendChild(catalog)
auction_lot_pool = pooler.get_pool(cr.dbname).get("auction.lots")
auction_dates_pool = pooler.get_pool(cr.dbname).get("auction.dates")
for auction in auction_dates_pool.browse(cr, uid, ids, context=context):
auction_lot_ids = auction_lot_pool.search(cr, uid, [("auction_id", "=", auction.id)])
key = "name"
categ = doc.createElement(key)
categ.appendChild(doc.createTextNode(_to_decode(auction.name)))
catalog.appendChild(categ)
# Auctuion Date element
categ = doc.createElement("AuctionDate1")
categ.appendChild(doc.createTextNode(_to_decode(auction.auction1)))
catalog.appendChild(categ)
# Action Date 2 element
categ = doc.createElement("AuctionDate2")
categ.appendChild(doc.createTextNode(_to_decode(auction.auction2)))
catalog.appendChild(categ)
# promotion element
promo = doc.createElement("promotion1")
fp = file(addons.get_module_resource("auction", "report", "images", "flagey_logo.jpg"), "r")
file_data = fp.read()
promo.appendChild(doc.createTextNode(base64.encodestring(file_data)))
catalog.appendChild(promo)
promo = doc.createElement("promotion2")
fp = file(addons.get_module_resource("auction", "report", "images", "flagey_logo.jpg"), "r")
file_data = fp.read()
promo.appendChild(doc.createTextNode(base64.encodestring(file_data)))
catalog.appendChild(promo)
# product element
products = doc.createElement("products")
catalog.appendChild(products)
side = 0
length = 0
for cat in auction_lot_pool.browse(cr, uid, auction_lot_ids, context=context):
product = doc.createElement("product")
products.appendChild(product)
if cat.obj_desc:
infos = doc.createElement("infos")
lines = re.split("<br/>|\n", _to_unicode(cat.obj_desc))
for line in lines:
xline = doc.createElement("info")
xline.appendChild(doc.createTextNode(_to_decode(line)))
infos.appendChild(xline)
product.appendChild(infos)
if cat.lot_num:
lnum = doc.createElement("lot_num")
lnum.appendChild(doc.createTextNode(_to_decode(str(cat.lot_num))))
infos.appendChild(lnum)
if cat.image:
import tempfile
limg = doc.createElement("photo_small")
file_name = tempfile.mktemp(prefix="openerp_auction_", suffix=".jpg")
fp = file(file_name, "w")
content = base64.decodestring(cat.image)
fp.write(content)
fp.close()
fp = file(file_name, "r")
test_file_name = tempfile.mktemp(prefix="openerp_auction_test_", suffix=".jpg")
size = photo_shadow.convert_catalog(fp, test_file_name, 110)
fp = file(test_file_name)
file_data = fp.read()
test_data = base64.encodestring(file_data)
fp.close()
limg.appendChild(doc.createTextNode(test_data))
infos.appendChild(limg)
if cat.lot_est1:
ref2 = doc.createElement(key)
ref2.appendChild(doc.createTextNode(_to_decode(str(cat.lot_est1 or 0.0))))
product.appendChild(ref2)
if cat.lot_est2:
ref2 = doc.createElement(key)
ref2.appendChild(doc.createTextNode(_to_decode(str(cat.lot_est2 or 0.0))))
product.appendChild(ref2)
oldlength = length
length += 2.0
if length > 23.7:
side += 1
length = length - oldlength
ref3 = doc.createElement("newpage")
ref3.appendChild(doc.createTextNode("1"))
product.appendChild(ref3)
if side % 2:
ref4 = doc.createElement("side")
ref4.appendChild(doc.createTextNode("1"))
product.appendChild(ref4)
xml1 = doc.toxml()
return xml1
def catalog_xml(self, cr, uid, ids, data, context, cwid="0"):
impl = minidom.getDOMImplementation()
doc = impl.createDocument(None, "report", None)
catalog = doc.createElement("catalog")
doc.documentElement.appendChild(catalog)
infodb = "info"
commdb = "comm"
tab_avoid = []
tab_no_photo = []
for id in ids:
lot_ids = pooler.get_pool(cr.dbname).get("auction.lots").search(cr, uid, [("auction_id", "=", id)])
ab = (
pooler.get_pool(cr.dbname)
.get("auction.lots")
.read(cr, uid, lot_ids, ["auction_id", "name", "lot_num", "lot_est1", "lot_est2"], context)
)
auction_dates_ids = [x["auction_id"][0] for x in ab]
res = (
pooler.get_pool(cr.dbname)
.get("auction.dates")
.read(cr, uid, ids, ["name", "auction1", "auction2"], context)
)
# name emelment
key = "name"
categ = doc.createElement(key)
categ.appendChild(doc.createTextNode(_to_decode(res[0]["name"])))
catalog.appendChild(categ)
# Auctuion Date element
categ = doc.createElement("AuctionDate1")
categ.appendChild(doc.createTextNode(_to_decode(res[0]["auction1"])))
catalog.appendChild(categ)
# Action Date 2 element
categ = doc.createElement("AuctionDate2")
categ.appendChild(doc.createTextNode(_to_decode(res[0]["auction2"])))
catalog.appendChild(categ)
# promotion element
promo = doc.createElement("promotion1")
fp = file(config["addons_path"] + "/auction/report/images/flagey_logo.jpg", "r")
file_data = fp.read()
promo.appendChild(doc.createTextNode(base64.encodestring(file_data)))
catalog.appendChild(promo)
promo = doc.createElement("promotion2")
fp = file(config["addons_path"] + "/auction/report/images/flagey_logo.jpg", "r")
file_data = fp.read()
promo.appendChild(doc.createTextNode(base64.encodestring(file_data)))
catalog.appendChild(promo)
# product element
products = doc.createElement("products")
catalog.appendChild(products)
side = 0
length = 0
auction_ids = []
for test in ab:
if test.has_key("auction_id"):
auction_ids.append(str(test["auction_id"][0]))
cr.execute("select * from auction_lots where auction_id in (" + ",".join(auction_ids) + ")")
res = cr.dictfetchall()
for cat in res:
product = doc.createElement("product")
products.appendChild(product)
if cat["obj_desc"]:
infos = doc.createElement("infos")
lines = re.split("<br/>|\n", _to_unicode(cat["obj_desc"]))
for line in lines:
xline = doc.createElement("info")
xline.appendChild(doc.createTextNode(_to_decode(line)))
infos.appendChild(xline)
product.appendChild(infos)
if cat["lot_num"]:
lnum = doc.createElement("lot_num")
lnum.appendChild(doc.createTextNode(_to_decode(str(cat["lot_num"]))))
infos.appendChild(lnum)
if cat["image"]:
import random
import tempfile
limg = doc.createElement("photo_small")
file_name = tempfile.mktemp(prefix="openerp_auction_", suffix=".jpg")
fp = file(file_name, "w")
content = base64.decodestring(cat["image"])
fp.write(content)
fp.close()
fp = file(file_name, "r")
test_file_name = tempfile.mktemp(prefix="openerp_auction_test_", suffix=".jpg")
size = photo_shadow.convert_catalog(fp, test_file_name, 110)
fp = file(test_file_name)
file_data = fp.read()
test_data = base64.encodestring(file_data)
fp.close()
limg.appendChild(doc.createTextNode(test_data))
infos.appendChild(limg)
for key in ("lot_est1", "lot_est2"):
ref2 = doc.createElement(key)
ref2.appendChild(doc.createTextNode(_to_decode(str(cat[key] or 0.0))))
product.appendChild(ref2)
oldlength = length
length += 2.0
if length > 23.7:
side += 1
length = length - oldlength
ref3 = doc.createElement("newpage")
ref3.appendChild(doc.createTextNode("1"))
product.appendChild(ref3)
if side % 2:
ref4 = doc.createElement("side")
ref4.appendChild(doc.createTextNode("1"))
product.appendChild(ref4)
xml1 = doc.toxml()
return xml1
def catalog_xml(self, cr, uid, ids, data, context, cwid="0"):
impl = minidom.getDOMImplementation()
doc = impl.createDocument(None, "report", None)
catalog = doc.createElement('catalog')
doc.documentElement.appendChild(catalog)
infodb = 'info'
commdb = 'comm'
tab_avoid = []
tab_no_photo = []
auction_lot_pool = pooler.get_pool(cr.dbname).get('auction.lots')
auction_dates_pool = pooler.get_pool(cr.dbname).get('auction.dates')
for auction in auction_dates_pool.browse(cr, uid, ids,
context=context):
auction_lot_ids = auction_lot_pool.search(
cr, uid, [('auction_id', '=', auction.id)])
key = 'name'
categ = doc.createElement(key)
categ.appendChild(doc.createTextNode(_to_decode(auction.name)))
catalog.appendChild(categ)
#Auctuion Date element
categ = doc.createElement("AuctionDate1")
categ.appendChild(doc.createTextNode(_to_decode(auction.auction1)))
catalog.appendChild(categ)
# Action Date 2 element
categ = doc.createElement("AuctionDate2")
categ.appendChild(doc.createTextNode(_to_decode(auction.auction2)))
catalog.appendChild(categ)
# promotion element
promo = doc.createElement('promotion1')
fp = file(
addons.get_module_resource('auction', 'report', 'images',
'flagey_logo.jpg'), 'r')
file_data = fp.read()
promo.appendChild(
doc.createTextNode(base64.encodestring(file_data)))
catalog.appendChild(promo)
promo = doc.createElement('promotion2')
fp = file(
addons.get_module_resource('auction', 'report', 'images',
'flagey_logo.jpg'), 'r')
file_data = fp.read()
promo.appendChild(
doc.createTextNode(base64.encodestring(file_data)))
catalog.appendChild(promo)
#product element
products = doc.createElement('products')
catalog.appendChild(products)
side = 0
length = 0
for cat in auction_lot_pool.browse(cr,
uid,
auction_lot_ids,
context=context):
product = doc.createElement('product')
products.appendChild(product)
if cat.obj_desc:
infos = doc.createElement('infos')
lines = re.split('<br/>|\n', _to_unicode(cat.obj_desc))
for line in lines:
xline = doc.createElement('info')
xline.appendChild(doc.createTextNode(_to_decode(line)))
infos.appendChild(xline)
product.appendChild(infos)
if cat.lot_num:
lnum = doc.createElement('lot_num')
lnum.appendChild(
doc.createTextNode(_to_decode(str(cat.lot_num))))
infos.appendChild(lnum)
if cat.image:
import random
import tempfile
limg = doc.createElement('photo_small')
file_name = tempfile.mktemp(prefix='openerp_auction_',
suffix='.jpg')
fp = file(file_name, 'w')
content = base64.decodestring(cat.image)
fp.write(content)
fp.close()
fp = file(file_name, 'r')
test_file_name = tempfile.mktemp(
prefix='openerp_auction_test_', suffix='.jpg')
size = photo_shadow.convert_catalog(
fp, test_file_name, 110)
fp = file(test_file_name)
file_data = fp.read()
test_data = base64.encodestring(file_data)
fp.close()
limg.appendChild(doc.createTextNode(test_data))
infos.appendChild(limg)
if cat.lot_est1:
ref2 = doc.createElement(key)
ref2.appendChild(
doc.createTextNode(_to_decode(str(cat.lot_est1
or 0.0))))
product.appendChild(ref2)
if cat.lot_est2:
ref2 = doc.createElement(key)
ref2.appendChild(
doc.createTextNode(_to_decode(str(cat.lot_est2
or 0.0))))
product.appendChild(ref2)
oldlength = length
length += 2.0
if length > 23.7:
side += 1
length = length - oldlength
ref3 = doc.createElement('newpage')
ref3.appendChild(doc.createTextNode("1"))
product.appendChild(ref3)
if side % 2:
ref4 = doc.createElement('side')
ref4.appendChild(doc.createTextNode("1"))
product.appendChild(ref4)
xml1 = doc.toxml()
return xml1
def catalog_xml(self, cr, uid, ids, data, context, cwid="0"):
impl = minidom.getDOMImplementation()
doc = impl.createDocument(None, "report", None)
catalog=doc.createElement('catalog')
doc.documentElement.appendChild(catalog)
infodb='info'
commdb='comm'
tab_avoid = []
tab_no_photo=[]
auction_lot_pool = pooler.get_pool(cr.dbname).get('auction.lots')
auction_dates_pool = pooler.get_pool(cr.dbname).get('auction.dates')
for auction in auction_dates_pool.browse(cr, uid, ids, context=context):
auction_lot_ids = auction_lot_pool.search(cr, uid, [('auction_id', '=', auction.id)])
key = 'name'
categ = doc.createElement(key)
categ.appendChild(doc.createTextNode(_to_decode(auction.name)))
catalog.appendChild(categ)
#Auctuion Date element
categ = doc.createElement("AuctionDate1")
categ.appendChild(doc.createTextNode(_to_decode(auction.auction1)))
catalog.appendChild(categ)
# Action Date 2 element
categ = doc.createElement("AuctionDate2")
categ.appendChild(doc.createTextNode(_to_decode(auction.auction2)))
catalog.appendChild(categ)
# promotion element
promo = doc.createElement('promotion1')
fp = file(addons.get_module_resource('auction','report', 'images', 'flagey_logo.jpg'),'r')
file_data = fp.read()
promo.appendChild(doc.createTextNode(base64.encodestring(file_data)))
catalog.appendChild(promo)
promo = doc.createElement('promotion2')
fp = file(addons.get_module_resource('auction','report', 'images', 'flagey_logo.jpg'),'r')
file_data = fp.read()
promo.appendChild(doc.createTextNode(base64.encodestring(file_data)))
catalog.appendChild(promo)
#product element
products = doc.createElement('products')
catalog.appendChild(products)
side = 0
length = 0
for cat in auction_lot_pool.browse(cr, uid, auction_lot_ids, context=context):
product = doc.createElement('product')
products.appendChild(product)
if cat.obj_desc:
infos = doc.createElement('infos')
lines = re.split('<br/>|\n', _to_unicode(cat.obj_desc))
for line in lines:
xline = doc.createElement('info')
xline.appendChild(doc.createTextNode(_to_decode(line)))
infos.appendChild(xline)
product.appendChild(infos)
if cat.lot_num:
lnum = doc.createElement('lot_num')
lnum.appendChild(doc.createTextNode(_to_decode(str(cat.lot_num))))
infos.appendChild(lnum)
if cat.image:
import random
import tempfile
limg = doc.createElement('photo_small')
file_name = tempfile.mktemp(prefix='openerp_auction_', suffix='.jpg')
fp = file(file_name, 'w')
content = base64.decodestring(cat.image)
fp.write(content)
fp.close()
fp = file(file_name,'r')
test_file_name = tempfile.mktemp(prefix='openerp_auction_test_', suffix='.jpg')
size = photo_shadow.convert_catalog(fp, test_file_name,110)
fp = file(test_file_name)
file_data = fp.read()
test_data = base64.encodestring(file_data)
fp.close()
limg.appendChild(doc.createTextNode(test_data))
infos.appendChild(limg)
if cat.lot_est1:
ref2 = doc.createElement(key)
ref2.appendChild(doc.createTextNode( _to_decode(str(cat.lot_est1 or 0.0))))
product.appendChild(ref2)
if cat.lot_est2:
ref2 = doc.createElement(key)
ref2.appendChild(doc.createTextNode( _to_decode(str(cat.lot_est2 or 0.0))))
product.appendChild(ref2)
oldlength = length
length += 2.0
if length>23.7:
side += 1
length = length - oldlength
ref3 = doc.createElement('newpage')
ref3.appendChild(doc.createTextNode( "1" ))
product.appendChild(ref3)
if side%2:
ref4 = doc.createElement('side')
ref4.appendChild(doc.createTextNode( "1" ))
product.appendChild(ref4)
xml1 = doc.toxml()
return xml1
