def myservices(): from shops import ContractedProduct, Product, Shop from invoices import Order, Orderlist from pagination import Pagination from adminsettings import Adminsettings Adminsettings(db) ContractedProduct(db), Product(db), Shop(db), Order(db), Orderlist(db) settings = db(db.adminsettings.id > 0).select(db.adminsettings.ALL).first() records = db((db.contractedproducts.id > 0) & (db.contractedproducts.user == auth.user_id)).count() items_per_page = settings.orderlistitems pag = Pagination(records, items_per_page) contractedproducts = db((db.contractedproducts.id > 0) & ( db.contractedproducts.user == auth.user_id)).select( db.contractedproducts.ALL, db.products.ALL, db.shop.ALL, db.auth_user.ALL, db.fiscals.ALL, left=[ db.products.on( db.products.id == db.contractedproducts.product), db.shop.on(db.shop.id == db.contractedproducts.shop), db.auth_user.on(db.auth_user.id == db.contractedproducts.user), db.fiscals.on(db.fiscals.user == db.auth_user.id) ], orderby=~db.contractedproducts.expiration, limitby=pag.limitby()) return dict(contractedproducts=contractedproducts, pagination=pag, records=records, items_per_page=items_per_page)
def editproduct(): if auth.has_membership('administradores') or auth.has_membership('superadministradores'): from shops import Product, PricePlan from pagination import Pagination Product(db), PricePlan(db) if request.vars.productid: product=db(db.products.id==request.vars.productid).select(db.products.ALL, db.priceplans.planname, left=[db.priceplans.on(db.priceplans.id==db.products.plan)]).first() name= Field('name', 'string', length=128, default=product.products.name, notnull=True, unique=True, requires=IS_NOT_EMPTY()) price=Field('price', 'decimal(10,2)', default=product.products.price, notnull=True, requires=[IS_NOT_EMPTY(error_message='el precio es obligatorio'),IS_DECIMAL_IN_RANGE(minimum=0, maximum=10000, error_message='el precio debe ser entre 0.00 y 10000.00')]) description=Field('description', 'text', default=product.products.description, notnull=False) active=Field('active', 'boolean', default=product.products.active) subscription=Field('suscription', 'boolean', default=product.products.suscription) min_period=Field('min_period', 'string', length='16', notnull=False, default=product.products.min_period, requires=IS_EMPTY_OR(IS_IN_SET(['hours','days','week','month','year'], error_message="Elija un estado"))) plan=Field('plan', 'reference priceplans', default=product.products.plan, notnull=False, requires=IS_EMPTY_OR(IS_IN_DB(db, db.priceplans.id,'%(planname)s', error_message="Debe escoger un plan"))) builtin=Field('builtin', 'boolean', default=product.products.builtin) form = SQLFORM.factory(name, price, description, active, subscription, min_period, plan, builtin, submit_button = 'Guardar', formstyle='bootstrap3_inline') if form.validate(): db(db.products.id==product.products.id).update(**dict(form.vars)) session.flash = 'Producto editado' redirect(URL('administrator','products')) elif form.errors: response.flash = 'Hay errores' else: response.flash = 'Por favor completa los campos' return dict(form=form) else: redirect(URL(request.application,'administrator','newproduct')) else: redirect(URL(request.application,'default','user/login'))
def index(): from invoices import Fiscal, Order, Orderlist from shops import Product, PricePlan Fiscal(db), Product(db), PricePlan(db), Order(db), Orderlist(db) fiscal=db(db.fiscals.user==auth.user_id).select().first() order=None orderlist=None if fiscal: order=db((db.orders.user==auth.user_id) & (db.orders.status=="Creando")).select().first() if order: orderlist=db(db.orderlist.g_order==order.id).select() flatrate=False for item in orderlist: if item.product.plan: if item.product.plan.paymode=="flatrate": flatrate=True else: redirect(URL(c='account',f='index')) else: redirect(URL('myaccount', 'fiscal', vars=dict(wizard=True))) form=FORM( INPUT(_type='radio', _name='paypal', _id='paypal', _value='paypal', value='yes').xml(), INPUT(_type='radio', _name='bank', _id='bank', _value='bank', value='no').xml(), INPUT(_name="confirm", _type='submit', _class="btn btn-grove-two btn-xlg"), _action=URL('confirm_order') ) return dict(form=form, fiscal=fiscal, orderlist=orderlist, order=order, flatrate=flatrate)
def viewbudget(): if auth.has_membership('administradores') or auth.has_membership( 'superadministradores'): from invoices import Budget, Budgetlist from shops import Product Budget(db), Budgetlist(db), Product(db) budget = db(db.budgets.id == request.args(0)).select( db.budgets.ALL, db.auth_user.id, db.auth_user.first_name, db.auth_user.last_name, db.fiscals.ALL, left=[ db.auth_user.on(db.auth_user.id == db.budgets.user), db.fiscals.on(db.fiscals.user == db.auth_user.id) ]).first() if budget: budgetlist = db( db.budgetlist.g_budget == budget.budgets.id).select( db.budgetlist.ALL, db.products.ALL, left=[ db.products.on(db.products.id == db.budgetlist.product) ]) return dict(budget=budget, budgetlist=budgetlist) else: redirect(URL(request.application, 'administrator', 'users')) else: redirect(URL(request.application, 'default', 'user/login'))
def contractedproducts(): if auth.has_membership('administradores') or auth.has_membership('superadministradores'): from shops import ContractedProduct, Product, Shop from invoices import Order, Orderlist from pagination import Pagination ContractedProduct(db), Product(db), Shop(db), Order(db), Orderlist(db) settings = db(db.adminsettings.id>0).select(db.adminsettings.ALL).first() records=db(db.contractedproducts.id>0).count() items_per_page=settings.orderlistitems pag=Pagination(records, items_per_page) contractedproducts = db(db.contractedproducts.id>0).select( db.contractedproducts.ALL, db.products.ALL, db.shop.ALL, db.auth_user.ALL, db.fiscals.ALL, left=[ db.products.on(db.products.id==db.contractedproducts.product), db.shop.on(db.shop.id==db.contractedproducts.shop), db.auth_user.on(db.auth_user.id==db.contractedproducts.user), db.fiscals.on(db.fiscals.user==db.auth_user.id)], orderby=~db.contractedproducts.expiration, limitby=pag.limitby()) return dict(contractedproducts=contractedproducts, pagination=pag, records=records, items_per_page=items_per_page) else: redirect(URL(request.application,'default','user/login'))
def profileplans(): if auth.has_membership('administradores') or auth.has_membership('superadministradores'): from shops import Product, PricePlan, ProfilePlan from pagination import Pagination Product(db), PricePlan(db), ProfilePlan(db) prod=request.vars.product pricep=request.vars.priceplan if (prod!=None) and (pricep!=None): try: db.profileplans.insert(priceplan=pricep, product=prod) except Exception as ex: db.rollback() logger.debug("ocurrió un error al crear un perfil de plan") response.flash="ocurrió un error al crear un perfil de plan" profileplans=db(db.profileplans.id>0).select( db.profileplans.ALL, db.priceplans.planname, db.products.name, join=[ db.priceplans.on(db.priceplans.id==db.profileplans.priceplan), db.products.on(db.products.id==db.profileplans.product)], orderby=db.profileplans.priceplan) return dict(profileplans=profileplans, records=db(db.profileplans.id>0).count(), priceplans=db(db.priceplans.id>0).select(), products=db(db.products.id>0).select()) else: redirect(URL(request.application,'default','user/login'))
def items(): if auth.has_membership('superadministradores') or auth.has_membership( 'administradores'): from invoices import Invoice, Budget, Budgetlist from shops import Product from adminsettings import Adminsettings Adminsettings(db), Invoice(db), Budget(db), Budgetlist(db), Product(db) settings = db(db.adminsettings.id > 0).select( db.adminsettings.ALL).first() #entrada: data: { 'product': int, 'quantity': int, 'rate': int, 'operation': ['add','del','set'] } #salida: (json)sales #begin #comprobar si tiene un budget abierta y si no crearla budget = db((db.budgets.user == request.vars.customer) & (db.budgets.id == request.vars.budgetid)).select().first() try: if not budget: budgetid = db.budgets.insert(status="Creando", user=request.vars.customer, tax=settings.tax) budget = db.budgets(budgetid) return db((db.budgetlist.g_budget == budget.id)).select( db.budgetlist.ALL, db.products.name, db.products.id, join=[db.products.on(db.products.id == db.budgetlist.product) ]).as_list() except Exception as ex: logger.debug(ex) db.rollback() else: return dict()
def delitem(): if auth.has_membership('superadministradores') or auth.has_membership( 'administradores'): from invoices import Invoice, Order, Orderlist from shops import Product from adminsettings import Adminsettings Adminsettings(db), Invoice(db), Order(db), Orderlist(db), Product(db) settings = db(db.adminsettings.id > 0).select( db.adminsettings.ALL).first() order = db((db.orders.user == request.vars.customer) & (db.orders.id == request.vars.orderid)).select().first() try: db((db.orderlist.id == request.vars.id) & (db.orderlist.g_order == order.id)).delete() db.commit() except: db.rollback() return db((db.orderlist.g_order == order.id)).select( db.orderlist.ALL, db.products.name, db.products.id, join=[db.products.on(db.products.id == db.orderlist.product) ]).as_list() else: return dict()
def vieworder(): if auth.has_membership('administradores') or auth.has_membership( 'superadministradores'): from invoices import Order, Orderlist from shops import Product Order(db), Orderlist(db), Product(db) order = db(db.orders.id == request.args(0)).select( db.orders.ALL, db.auth_user.id, db.auth_user.first_name, db.auth_user.last_name, db.fiscals.ALL, left=[ db.auth_user.on(db.auth_user.id == db.orders.user), db.fiscals.on(db.fiscals.user == db.auth_user.id) ]).first() if order: orderlist = db(db.orderlist.g_order == order.orders.id).select( db.orderlist.ALL, db.products.ALL, left=[db.products.on(db.products.id == db.orderlist.product)]) return dict(order=order, orderlist=orderlist) else: redirect(URL(request.application, 'administrator', 'users')) else: redirect(URL(request.application, 'default', 'user/login'))
def datashop(): from shops import Shop, DomainShop, ContractedProduct, Product from invoices import Order Shop(db), DomainShop(db), ContractedProduct(db), Product(db), Order(db) #store=db((db.shop.user==auth.user_id) & (db.shop.host==request.vars.host)).select() stores = db((db.shop.host == request.vars.host) & (db.shop.user == auth.user_id)).select( db.shop.ALL, db.domainshops.ALL, db.priceplans.ALL, left=[ db.domainshops.on(db.domainshops.shop == db.shop.id), db.priceplans.on(db.priceplans.id == db.shop.priceplan) ]) contractedproducts = db( (db.contractedproducts.user == auth.user_id) & (db.contractedproducts.shop == stores[0].shop) & (db.contractedproducts.expiration <= datetime.datetime.now())).select( db.contractedproducts.ALL, db.products.ALL, left=[ db.products.on(db.products.id == db.contractedproducts.product) ]) return dict(stores=stores, host=stores[0].shop.host, ip=stores[0].shop.ip, contractedproducts=contractedproducts)
def newproduct(): if auth.has_membership('administradores') or auth.has_membership('superadministradores'): from shops import Product, PricePlan from pagination import Pagination Product(db), PricePlan(db) name= Field('name', 'string', label="Nombre", length=128, notnull=True, unique=True, requires=IS_NOT_EMPTY()) price=Field('price', 'decimal(10,2)', label="Precio", notnull=True, requires=[IS_NOT_EMPTY(error_message='el precio es obligatorio'),IS_DECIMAL_IN_RANGE(minimum=0, maximum=10000, error_message='el precio debe ser entre 0.00 y 10000.00')]) description=Field('description', 'text', label="Descripción",notnull=True, requires=IS_NOT_EMPTY(error_message='se necesita una descripción')) active=Field('active', 'boolean', default=True) subscription=Field('suscription', 'boolean', default=True) min_period=Field('min_period', 'string', length='16', notnull=False, default='month', requires=IS_EMPTY_OR(IS_IN_SET(['hours','days','week','month','year'], error_message="Elija un estado"))) plan=Field('plan', 'reference priceplans', default=None, notnull=False, requires=IS_EMPTY_OR(IS_IN_DB(db, db.priceplans.id,'%(planname)s', error_message="Debe escoger un plan"))) builtin=Field('builtin', 'boolean', default=False) form = SQLFORM.factory(name, price, description, active, subscription, min_period, plan, builtin, submit_button = 'Guardar', formstyle='bootstrap3_inline') if form.validate(): db.products.insert(**dict(form.vars)) session.flash = 'Producto creado' redirect(URL('administrator','products')) elif form.errors: response.flash = 'Hay errores' else: response.flash = 'Por favor completa los campos' return dict(form=form)
def __init__(self,db): Product(db) self.db=db try: Fiscal(db) self.define_tables() except: pass
def enabledomain(): from shops import Shop, DomainShop, PricePlan, ContractedProduct, Product Shop(db), DomainShop(db), PricePlan(db), ContractedProduct(db), Product(db) shop = db((db.shop.host == request.vars.host) & (db.shop.user == auth.user_id)).select().first() if shop: if shop.priceplan.paymode == 'free': #hay que pasar por caja, pero antes comprobar si hay algún pedido en planes distintos a free para esta tienda pendiente de ser aprobado pending = db((db.contractedproducts.shop == shop.id) & (db.contractedproducts.user == auth.user_id) & (db.contractedproducts.start == None) & ((db.priceplans.paymode != None) & (db.priceplans.paymode != 'free'))).select( db.contractedproducts.id, join=[ db.products.on(db.products.id == db. contractedproducts.product), db.priceplans.on( db.priceplans.id == db.products.plan) ]).first() logger.debug( db((db.contractedproducts.shop == shop.id) & (db.contractedproducts.user == auth.user_id) & (db.contractedproducts.start == None) & ((db.priceplans.paymode != None) & (db.priceplans.paymode != 'free')))._select( db.contractedproducts.id, join=[ db.products.on(db.products.id == db.contractedproducts.product), db.priceplans.on( db.priceplans.id == db.products.plan) ])) if pending == None: if request.vars.host: redirect( URL(request.application, 'plans', 'index', vars=dict(host=request.vars.host))) else: session.flash = "Este pedido para cambiar de plan, estaba pendiente de confirmación pago" redirect(URL('payment', 'index')) else: #este dominio está en shop con un priceplan de pago, así que se puede llamar al api de internalgexcommerce para configurar el apache logger.debug("de pagoooo") else: session.flash = "No podemos encontrar la tienda %s" % request.vars.host redirect(URL('index'))
def del_profileplans(): if auth.has_membership('administradores') or auth.has_membership('superadministradores'): from shops import Product, PricePlan, ProfilePlan from pagination import Pagination Product(db), PricePlan(db), ProfilePlan(db) try: if db(db.profileplans.id==request.vars.deleteid).delete(): return "OK" else: return "Fail" except Exception, ex: logger.debug('hubo un error al borrar el profileplans id: % error: %' % (request.vars.deleteid, ex)) return "Fail"
def createcontracts(): if auth.has_membership('superadministradores') or auth.has_membership( 'administradores'): from shops import ContractedProduct, Product, Shop from invoices import Order, Orderlist Product(db), ContractedProduct(db), Order(db), Orderlist(db), Shop(db) if not request.vars.invoice == 'None' and not request.vars.invoice == None: g_order = db(db.orders.invoice == request.vars.invoice).select().first()["id"] else: g_order = request.vars.order if not request.vars.shop: shop = db(db.shop.user == request.args(0)).select() else: shopid = request.vars.shop if not shop: redirect( URL('contracts', 'createmanualshop', args=request.args(0), vars=dict(invoice=request.vars.invoice, order=request.vars.order))) else: shopid = shop[0].id contractedproducts = db( (db.orderlist.g_order == g_order) & (db.orders.user == request.args(0)) & ((db.contractedproducts.shop == shopid) | (db.contractedproducts.shop == None))).select( db.orders.ALL, db.orderlist.ALL, db.contractedproducts.ALL, db.products.ALL, left=[ db.orderlist.on(db.orders.id == db.orderlist.g_order), db.products.on(db.products.id == db.orderlist.product), db.contractedproducts.on( db.contractedproducts.product == db.products.id) ], groupby=db.orderlist.id) session.usercontract = request.args(0) return dict(contractedproducts=contractedproducts, shop=shop, shopid=shopid) else: redirect(URL(request.application, 'default', 'user/login'))
def products(): if auth.has_membership('administradores') or auth.has_membership('superadministradores'): from shops import Product, PricePlan from pagination import Pagination Product(db), PricePlan(db) settings = db(db.adminsettings.id>0).select(db.adminsettings.ALL).first() records=db(db.products.id>0).count() items_per_page=settings.productitems pag=Pagination(records, items_per_page) products=db(db.products.id>0).select(db.products.ALL, db.priceplans.planname, left=[db.priceplans.on(db.priceplans.id==db.products.plan)], orderby=db.products.id, limitby=pag.limitby()) return dict(products=products, pagination=pag, records=records, items_per_page=items_per_page) else: redirect(URL(request.application,'default','user/login'))
def newbudget(): from shops import Product from invoices import Fiscal, Budget from adminsettings import Adminsettings Adminsettings(db), Product(db), Fiscal(db), Budget(db) settings = db(db.adminsettings.id > 0).select(db.adminsettings.ALL).first() if auth.has_membership('superadministradores') or auth.has_membership( 'administradores'): if request.args(0): products = db(db.products.active == True).select() if request.args(1): budget = db((db.budgets.user == request.args(0)) & ( db.budgets.id == request.args(1))).select().first() else: budget = db((db.budgets.user == request.args(0)) & (db.budgets.status == "Creando")).select().first() if not budget: budgetid = db.budgets.insert(status="Creando", tax=settings.tax, user=request.args(0)) budget = db.budgets(budgetid) customer = db(db.auth_user.id == request.args(0)).select( db.auth_user.id, db.auth_user.first_name, db.auth_user.last_name, db.auth_user.email, db.fiscals.ALL, left=[db.fiscals.on(db.fiscals.user == db.auth_user.id) ]).first() db.commit() return dict(products=products, customer=customer, tax=budget.tax, budgetid=budget.id) else: redirect(URL(request.application, 'administrator', 'users')) else: redirect(URL(request.application, 'default', 'user/login'))
def items(): if auth.has_membership('superadministradores') or auth.has_membership( 'administradores'): from invoices import Invoice, Order, Orderlist from shops import Product from adminsettings import Adminsettings Adminsettings(db), Invoice(db), Order(db), Orderlist(db), Product(db) settings = db(db.adminsettings.id > 0).select( db.adminsettings.ALL).first() #entrada: data: { 'product': int, 'quantity': int, 'rate': int, 'operation': ['add','del','set'] } #salida: (json)sales #begin #comprobar si tiene un order abierta y si no crearla order = db((db.orders.user == request.vars.customer) & (db.orders.id == request.vars.orderid)).select().first() try: if not order: orderid = db.orders.insert(status="CreandoAdmin", user=request.vars.customer, payment_method='Transferencia', tax=settings.tax, manual_operation=True) order = db.orders(orderid) return db((db.orderlist.g_order == order.id)).select( db.orderlist.ALL, db.products.name, db.products.id, join=[db.products.on(db.products.id == db.orderlist.product) ]).as_list() except Exception as ex: logger.debug(ex) db.rollback() else: return dict()
def basicProducts(self): from shops import Product, PricePlan, ProfilePlan db=self.db Product(db), PricePlan(db), ProfilePlan(db) if db(db.products).isempty(): db.products.insert( name="Tarifa plana", price="18.00", plan=3, min_period="month", description="Vende lo que quieras y paga siempre lo mismo. Con certificado SSL incluído.") db.products.insert( name="Carga crédito mínimo 'Paga si vendes'", price="40.00", plan=2, suscription=False, description="Para que si se disparan tus ventas, controles tu gasto con un límite de 40€") db.products.insert( name="Plan Asistido", price="199.00", plan=4, min_period="month", description="Con asistencia telefónica y Comunity Management Básico incluído todos los meses") db.products.insert( name="Plan Difusión", price="399.00", plan=6, min_period="month", description="Community Management Avanzado mes a mes") db.products.insert( name="Certificado SSL", min_period="year", price="15.00") db.products.insert( name="Certificado SSL (Planes por Suscripción)", min_period="year", price="0.00") db.products.insert( name="Pack iniciación", price="450.00", suscription=False, description="incluye la modificación de la plantilla para la inserción de logotipos y de imágenes de productos en Slider de presentación, compuesto por tres imágenes completamente montadas para promoción de tres artículos o servicios.") db.products.insert( name="Asistencia telefónica bono 5h", price="210.00", suscription=False, description="Por si necesitas algo más, que la asistencia incluída en tu plan") db.products.insert( name="Asistencia telefónica bono 10h", price="380.00", suscription=False, description="Por si necesitas algo más, que la asistencia incluída en tu plan") db.products.insert( name="Asistencia telefónica bono 15h", price="480.00", suscription=False, description="Por si necesitas algo más, que la asistencia incluída en tu plan") db.products.insert( name="Pack video corporativo", suscription=False, price="150.00", description="Filmación profesional en vídeo del negocio físico o productos para la creación de un video corporativo de aproximadamente 50 segundos una vez editado, asi como sesión de fotos profesional de artículos (de 10 a 15 tomas)") db.products.insert( name="Community Management Básico", price="200.00", description="Creación de identidad digital y un mes de difusión/discusión semanal en Facebook y twitter sobre productos y servicios.") db.products.insert( name="Community Management Avanzado", price="300.00", description="Creación de identidad digital y un mes de difusión/discusión semanal en Facebook, Twitter, Google+ y blog de empresa, sobre productos y servicios.") db.products.insert( name="Facebook Social Management", price="60.00", description="Dos entradas semanales en Facebook") db.products.insert( name="Twitter Social Management", price="60.00", description="Dos tweets semanales") db.products.insert( name="Blog Social Management", price="80.00", description="Una entrada semanal en Blog") db.products.insert( name="Google+ Social Management", price="60.00", description="Dos entradas semanales en tu comunidad Google+") db.products.insert( name="Campaña SEO", price="250.00", suscription=False, description="Análisis, adecuación de la tienda y puesta en marcha de estrategia.") db.products.insert( name="SEM en Google adwords express", price="130.00", active=False, suscription=False, description="Colocación y monitorización del anuncio y creación del Landing Page") db.products.insert( name="SEM en Google adwords", price="130.00", active=False, suscription=False, description="Colocación y monitorización del anuncio y creación del Landing Page") db.products.insert( name="Ads en Facebook", price="130.00", active=False, suscription=False, description="Colocación y monitorización del anuncio y creación del Landing Page") db.products.insert( name="SEM en Bing", price="130.00", active=False, suscription=False, description="Colocación y monitorización del anuncio y creación del Landing Page") db.products.insert( name="Servicio de introducción de productos en tu catálogo", price="28.00", suscription=False, description="Añadimos los productos que desees y su información relacionada: SEO, categoría, asociaciones, atributos y valores, marca del producto, ilustración del producto, marca de agua, 3 imágenes por artículo, existencias, administrar proveedor, tags.") db.products.insert( name="Adecuación LOPD", price="140.00", suscription=False, active=False, description="Para que cumplas con la Ley Orgánica de protección de datos, adecuamos tu tienda, desarrollamos el documento de seguridad, los contratos de acceso a datos por parte de terceros (asesorías, seguros, informáticos), te facilitamos toda la documentación relacionada y registramos los ficheros de datos personales en la Agencia de Protección de Datos. Además te damos un año de consultoría legal sobre LOPD totalmente gratis") db.products.insert( name="Adecuación LSSICE", price="60.00", suscription=False, active=False, description="Adaptamos su tienda para que cumpla la Ley de Servicios de la Sociedad de la Información y Comercio Electrónico, de obligado cumplimiento.") db.profileplans.insert( product=db(db.products.name=="Carga crédito mínimo 'Paga si vendes'").select().first()['id'], priceplan=db(db.priceplans.planname=="Paga si vendes").select().first()['id']) db.profileplans.insert( product=db(db.products.name=="Certificado SSL").select().first()['id'], priceplan=db(db.priceplans.planname=="Paga si vendes").select().first()['id']) db.profileplans.insert( product=db(db.products.name=="Tarifa Plana").select().first()['id'], priceplan=db(db.priceplans.planname=="Tarifa plana").select().first()['id']) db.profileplans.insert( product=db(db.products.name=="Certificado SSL (Planes por Suscripción)").select().first()['id'], priceplan=db(db.priceplans.planname=="Tarifa plana").select().first()['id'])
import os import socket import datetime import copy import gluon.contenttype import gluon.fileutils from blog import Blog, Draft, Images from shops import Shop, DomainShop, PricePlan, Product, ContractedProduct, ProfilePlan, PricePlan, CustomerAgreement, Agreement from invoices import Invoice, Order, Orderlist, Fiscal, CreditAccount, AccountingEntry, Budget, Budgetlist from regnews import Regnews from province import Province from cities import Cities Images(db), Blog(db, ckeditor), Draft( db, ckeditor), Regnews(db), Province(db), Cities(db) Shop(db), PricePlan(db), DomainShop(db), Product(db) ProfilePlan(db), PricePlan(db), CustomerAgreement(db), Agreement(db) Invoice(db), Order(db), Orderlist(db), Budget(db), Budgetlist(db), Fiscal( db), ContractedProduct(db), CreditAccount(db), AccountingEntry(db) try: import pygraphviz as pgv except ImportError: pgv = None # ## critical --- make a copy of the environment global_env = copy.copy(globals()) global_env['datetime'] = datetime http_host = request.env.http_host.split(':')[0]
def payment(): from invoices import Order, Orderlist from shops import Product, Shop, DomainShop, ContractedProduct from adminsettings import Adminsettings from auxiliartools import AuxiliarTools Adminsettings(db) settings = db(db.adminsettings.id > 0).select(db.adminsettings.ALL).first() Shop(db), Order(db), Orderlist(db), Product(db), DomainShop( db), ContractedProduct(db) external = AuxiliarTools(db) host = request.vars.host plan = request.vars.plan cert = request.vars.cert if host and plan and cert: #hay que comprobar que viene por request un plan asignado a una tienda con el dato del cert try: db((db.orders.status == 'Creando') & (db.orders.user == auth.user_id)).delete( ) #sólo puede haber un pedido en estado de creación. plan = db(db.priceplans.id == request.vars.plan).select().first() shop = db((db.shop.host == request.vars.host) & (db.shop.user == auth.user_id)).select().first() if shop and plan: #comprobar que existe y es suyo (siempre por seguridad) profileplans = db(db.profileplans.priceplan == plan).select() total = float(0) for profileplan in profileplans: if profileplan.active: product = db(db.products.id == profileplan.product).select().first() if product.name.find("SSL") != -1 and cert == "false": continue total = total + float(product.price) orderid = db.orders.insert( user=auth.user_id, total=total, totaltax="%.2f" % float( ((total * float(settings.tax)) / 100)), status="Creando", payment_code=db.paymentcodes.insert( code=external.generatecode()), payment_method=None) for profileplan in profileplans: if profileplan.active: product = db(db.products.id == profileplan.product).select().first() if product.name.find("SSL") != -1 and cert == "false": continue orderlistid = db.orderlist.insert( product=product.id, g_order=orderid, quantity=1, price=product.price, price_wdto=product.price, tax=settings.tax) #NO SE PUEDE HACER EL INSERT DIRECTAMENTE. HAY QUE VER SI EL SHOP YA TIENE CONTRATADO EL PRODUCTO. SI NO TIENE se hace un INSERT, si no, no hace nada. #En realidad esta comprobación no hace falta porque no se va a dar este caso, pero sí en contracts.postcontracts por ser una generación de contratos manual . #Sólo se va a poder contratar una unidad y la recursividad y duración de la periodicidad harán el resto. contracted = db( (db.contractedproducts.shop == shop.id) & (db.contractedproducts.user == auth.user_id) & (db.contractedproducts.product == product.id) ).select().first() if not contracted: db.contractedproducts.insert( user=auth.user_id, product=product.id, period=product.min_period, autorenove=product.suscription, start=None, renove=None, #fecha de la renovación. expiration=None, shop=shop.id, orderlist=orderlistid, paymentmethod=None) db.commit() return "OK" except Exception as ex: session.flash = "Ocurrió un error al crear el pedido %s" % ex redirect(request.env.http_referer) else: session.flash = "Disculpen la molestias. No podemos encontrar la información requerida" redirect(request.application, 'account', 'index')
def postcontracts(): import simplejson from dateutil.relativedelta import relativedelta if auth.has_membership('superadministradores') or auth.has_membership( 'administradores'): from shops import ContractedProduct, Product, Shop from invoices import Order, Orderlist, CreditAccount, AccountingEntry Order(db), Orderlist(db), Product(db), ContractedProduct(db), Shop(db) accounting = AccountingEntry(db) logger.debug(request.post_vars) data = simplejson.loads(request.post_vars.datacontracts) shopid = request.post_vars.shopid try: for d in data: #NO SE PUEDE HACER EL INSERT DIRECTAMENTE. HAY QUE VER SI EL SHOP YA TIENE CONTRATADO EL PRODUCTO. SI NO TIENE se hace un INSERT, si no, no hace nada. #Sólo se va a poder contratar una unidad y la recursividad y duración de la periodicidad harán el resto. orderlist = db(db.orderlist.id == int(d['orderlist'])).select( db.orderlist.ALL, db.products.ALL, db.orders.ALL, join=[ db.products.on(db.products.id == db.orderlist.product), db.orders.on(db.orders.id == db.orderlist.g_order) ]).first() contracted = db( (db.contractedproducts.shop == shopid) & (db.contractedproducts.user == session.usercontract) & (db.contractedproducts.product == orderlist.orderlist.product)).select().first() if not contracted: db.contractedproducts.insert( user=session.usercontract, product=orderlist.orderlist.product, period=orderlist.products. min_period, #optimizar para evitar más consultas autorenove=d['autorenove'], shop=shopid, orderlist=orderlist.orderlist.id, paymentmethod=orderlist.orders.payment_method, automatics_action=d['automatics_action'], notifications=d['notifications'], credit_annotation=d['credit_annotation'], invoice=request.vars.invoice) else: contracted.update_record( autorenove=d['autorenove'], automatics_action=d['automatics_action'], notifications=d['notifications'], credit_annotation=d['credit_annotation'], ) logger.debug("LLegoogoo1") #anotar crédito si orders pagado y si credit_annotation==True y si not in accountingentries if orderlist.orders.status == "Pagado" and d[ 'credit_annotation']: if not db((db.accountingentries.orderlist == orderlist.orderlist.id) & (db.accountingentries.active == True)).select( ).first(): logger.debug("LLegoogoo2") if not accounting.annotation( db.orderlist(orderlist.orderlist.id), db.orders(orderlist.orders.id), positive=True): raise Exception( "Ocurrió un error al hacer la anotación en postcontracts" ) logger.debug("LLegoogoo3") if contracted: if request.vars.invoice and contracted.invoice: if int(request.vars.invoice) > int( contracted.invoice): expiration = contracted.expiration if contracted.period == 'hours': #no usado por ahora inc = datetime.timedelta( hours=contracted.quantity) elif contracted.period == 'days': #no usado por ahora inc = datetime.timedelta( days=contracted.quantity) elif contracted.period == 'week': #no usado por ahora inc = datetime.timedelta( weeks=contracted.quantity) elif contracted.period == 'month': inc = relativedelta( months=contracted.quantity) horizon_date = 15 #15 días elif contracted.period == 'year': inc = relativedelta( years=contracted.quantity) horizon_date = 30 * 11 #días. No tengo en cuenta febreros ni bisiestos porque es sólo para hacer algo en 11 meses aprox. else: inc = datetime.timedelta(hours=0) if not accounting.annotation( db.orderlist( orderlist.orderlist.id), db.orders(orderlist.orders.id), positive=False): raise Exception( "Ocurrió un error al hacer la anotación en postcontracts" ) contracted.update_record( expiration=expiration + inc, invoice=request.vars.invoice) db.commit() session.flash = "Contratos creados correctamente" except Exception as ex: logger.debug("Se produjo un error en postcontracts %s" % ex) db.rollback() raise HTTP(500, ex) session.usercontract = None return "ok" else: return "no authorized"
def item(): if auth.has_membership('superadministradores') or auth.has_membership( 'administradores'): from shops import Product from invoices import Order, Orderlist from adminsettings import Adminsettings Adminsettings(db), Order(db), Orderlist(db), Product(db) settings = db(db.adminsettings.id > 0).select( db.adminsettings.ALL).first() #entrada: data: { 'product': int, 'quantity': int, 'rate': int, 'operation': ['add','del','set'] } #salida: (json)sales #begin #comprobar si tiene un order abierta y si no crearla if request.vars.orderid: order = db((db.orders.user == request.vars.customer) & ( db.orders.id == request.vars.orderid)).select().first() else: order = db((db.orders.user == request.vars.customer) & (db.orders.status == "CreandoAdmin")).select().first() if not order and request.vars.operation == "add": orderid = db.orders.insert(status="CreandoAdmin", user=request.vars.customer, payment_method='Transferencia', tax=settings.tax, manual_operation=True) order = db.orders(orderid) orderlist_id = None try: #add/del product y quantity. row = db((db.orderlist.product == request.vars.product) & (db.orderlist.g_order == order.id)).select().first() if row: orderlist_id = row.id if request.vars.operation == "add": db(db.orderlist.id == orderlist_id).update( quantity=int(row.quantity) + int(request.vars.quantity)) elif request.vars.operation == "set": db(db.orderlist.id == orderlist_id).update( quantity=int(request.vars.quantity)) db.commit() else: product = db( db.products.id == request.vars.product).select().first() #valor iva, para conservar el valor en caso de variar en el futuro #el precio para conservar en caso de variar en el futuro. orderlist_id = db.orderlist.insert( product=request.vars.product, g_order=order.id, quantity=request.vars.quantity, price=product.price, price_wdto=product.price, tax="%.2f" % settings.tax) db.commit() except Exception as ex: logger.debug("ALGO SALIO MAL en item %s" % ex) db.rollback() #retorna json del pedido data = db((db.orderlist.g_order == order.id)).select( db.orderlist.ALL, db.products.name, join=[db.products.on(db.products.id == db.orderlist.product) ]).as_list() return data else: return dict()
def printorder(): import os, uuid, subprocess import gluon.contenttype, gluon.globals from appy.pod.renderer import Renderer from invoices import Order, Orderlist from shops import Product from adminsettings import Adminsettings Adminsettings(db), Order(db), Orderlist(db), Product(db) settings = db(db.adminsettings.id > 0).select(db.adminsettings.ALL).first() if auth.has_membership('superadministradores') or auth.has_membership( 'administradores'): order = db(db.orders.id == request.args(0)).select( db.orders.ALL, db.auth_user.id, db.auth_user.first_name, db.auth_user.last_name, db.auth_user.email, db.fiscals.ALL, left=[ db.auth_user.on(db.auth_user.id == db.orders.user), db.fiscals.on(db.fiscals.user == db.auth_user.id) ]).first() if order: ordernumber = "%s" % order.orders.id orderdate = "%s" % order.orders.ordered_at.strftime("%d-%m-%Y") customernumber = "%s" % order.auth_user.email customernif = "%s" % ("", order.fiscals.tax_identification )[order.fiscals.tax_identification != None] nombre = "%s" % ( "%s %s" % (order.auth_user.first_name, order.auth_user.last_name), order.fiscals.fiscalname)[order.fiscals.fiscalname != ""] domicilio = "%s" % ( "", order.fiscals.address)[order.fiscals.address != None] domicilio2 = "%s %s %s" % ( ("", order.fiscals.postal_code)[order.fiscals.postal_code != None], ("", order.fiscals.city)[order.fiscals.city != None], ("", order.fiscals.province)[order.fiscals.province != None]) telefono = "%s" % order.fiscals.country fax = "%s" % order.fiscals.phone iva = "%.2f" % order.orders.tax totaliva = "%.2f" % float(order.orders.totaltax) total = "%.2f" % float(order.orders.total) totalorder = "%.2f" % float( float(order.orders.total) + float(order.orders.totaltax)) items = [] for item in db(db.orderlist.g_order == order.orders.id).select( db.orderlist.ALL, db.products.ALL, left=[ db.products.on(db.products.id == db.orderlist.product) ]): tax_result = "%.2f" % ( ((float(item.orderlist.price) * (float(item.orderlist.quantity))) * float(item.orderlist.tax)) / float(100)) items.append( dict( id="%s" % item.products.id, name="%s" % item.products.name, cant="%s" % item.orderlist.quantity, price="%.2f" % float(item.orderlist.price), percent="%.2f" % float( item.orderlist.tax ), #se refiere al iva, pero en el .odt puse este nombre de variable por una ida de olla. total="%.2f" % (float(item.orderlist.quantity) * float(item.orderlist.price)))) try: # Report creation template_file = os.path.join(request.folder, 'private', 'order.odt') # tmp_uuid = uuid.uuid4() output_file_odt = os.path.join( request.folder, 'private', 'tmp', '%s_%s.odt' % ("pedido", order.orders.id)) output_file_pdf = os.path.join( request.folder, 'private', 'tmp', '%s_%s.pdf' % ("pedido", order.orders.id)) #por si existiese de vez anterior for filepath in [output_file_odt, output_file_pdf]: if os.path.exists(filepath): os.remove(filepath) renderer = Renderer(template_file, locals(), output_file_odt) renderer.run() command = "unoconv --format pdf --output %s %s" % ( os.path.join(request.folder, 'private', 'tmp'), output_file_odt) process = subprocess.Popen(command, shell=True) processcode = process.wait() response.headers['Content-Length'] = '%s' % os.path.getsize( output_file_pdf) response.headers[ 'Content-Type'] = '%s' % gluon.contenttype.contenttype( '.pdf') response.headers[ 'Content-Disposition'] = 'attachment; filename=%s_%s.pdf' % ( "pedido", order.orders.id) stream = open(output_file_pdf, 'rb') for filepath in [output_file_odt, output_file_pdf]: if os.path.exists(filepath): os.remove(filepath) return stream # response.stream(output_file_pdf, chunk_size=4096) except Exception as ex: for filepath in [output_file_odt, output_file_pdf]: if os.path.exists(filepath): os.remove(filepath) logger.debug("Error general al generar PDF: %s " % ex) pass except IOError, e: # Explicitly ignore IOError if it occurs. for filepath in [output_file_odt, output_file_pdf]: if os.path.exists(filepath): os.remove(filepath) logger.debug("Error IOerror al generar PDF: %s" % e) pass session.flash = 'No se pudo encontrar el pedido, inténtelo de nuevo' if auth.has_membership('superadministradores') or auth.has_membership( 'administradores'): redirect( URL(request.application, 'administrator', 'viewinvoice', args=request.args(0))) else: redirect( URL(request.application, 'account', 'billing', args=request.args(0)))
def neworder(): from shops import Product from invoices import Fiscal, Order, Orderlist, Budgetlist from adminsettings import Adminsettings Adminsettings(db), Product(db), Fiscal(db), Order(db), Orderlist( db), Budgetlist(db) settings = db(db.adminsettings.id > 0).select(db.adminsettings.ALL).first() if auth.has_membership('superadministradores') or auth.has_membership( 'administradores'): if request.args(0): products = db(db.products.active == True).select() if request.vars.budget: order = db((db.orders.user == request.args(0)) & (db.orders.status == "CreandoAdmin") & (db.orders.budget == request.vars.budget)).select( ).first() if not order: orderid = db.orders.insert(status="CreandoAdmin", user=request.args(0), budget=request.vars.budget, tax=settings.tax, payment_method='Transferencia', manual_operation=True) order = db.orders(orderid) for row in db(db.budgetlist.g_budget == request.vars.budget).select(): db.orderlist.insert(product=row.product, g_order=orderid, quantity=row.quantity, price=row.price, price_wdto=row.price_wdto, tax=row.tax, dto=row.dto, dto_percentage=row.dto_percentage) else: if request.args(1): order = db((db.orders.user == request.args(0)) & ( db.orders.id == request.args(1))).select().first() else: order = db((db.orders.user == request.args(0)) & ( db.orders.status == "CreandoAdmin")).select().first() if not order: orderid = db.orders.insert(status="CreandoAdmin", tax=settings.tax, user=request.args(0), payment_method='Transferencia', manual_operation=True) order = db.orders(orderid) customer = db(db.auth_user.id == request.args(0)).select( db.auth_user.id, db.auth_user.first_name, db.auth_user.last_name, db.auth_user.email, db.fiscals.ALL, left=[db.fiscals.on(db.fiscals.user == db.auth_user.id) ]).first() db.commit() return dict(products=products, customer=customer, tax=order.tax, order=order) else: redirect(URL(request.application, 'administrator', 'users')) else: redirect(URL(request.application, 'default', 'user/login'))
def editcustomer(): if auth.has_membership('administradores') or auth.has_membership('superadministradores'): if request.args(0): from invoices import Fiscal, Order, Orderlist, Invoice, Budget, AccountingEntry, CreditAccount from shops import ContractedProduct, Product, Shop from cities import Cities from province import Province Fiscal(db), Province(db), Cities(db), ContractedProduct(db), Product(db), Shop(db), Order(db), Orderlist(db), AccountingEntry(db), CreditAccount(db), Invoice(db), Budget(db) customer=db(db.auth_user.id==request.args(0)).select( db.auth_user.id, db.auth_user.first_name, db.auth_user.last_name, db.auth_user.email, db.fiscals.ALL, left=[db.fiscals.on(db.fiscals.user==db.auth_user.id)]).first() wpoblacion = SQLFORM.widgets.autocomplete(request, db.cities.poblacion, limitby=(0,10), min_length=2) wprovincia = SQLFORM.widgets.autocomplete(request, db.province.provincia, limitby=(0,10), min_length=2) inc=datetime.timedelta(days=30) contractedproducts = db((db.contractedproducts.user==request.args(0)) & ( (db.contractedproducts.expiration+inc>=datetime.datetime.now()) | (db.contractedproducts.expiration==None) )).select( db.contractedproducts.ALL, db.products.ALL, db.shop.ALL, db.auth_user.ALL, db.fiscals.ALL, left=[ db.products.on(db.products.id==db.contractedproducts.product), db.shop.on(db.shop.id==db.contractedproducts.shop), db.auth_user.on(db.auth_user.id==db.contractedproducts.user), db.fiscals.on(db.fiscals.user==db.auth_user.id)], orderby=~db.contractedproducts.expiration) invoices = db( db.invoices.user==request.args(0)).select(db.invoices.ALL, db.orders.id, db.orders.status, left=[ db.orders.on(db.orders.invoice==db.invoices.id)], orderby=~db.invoices.id, groupby=db.orders.id ) budgets = db((db.budgets.user==request.args(0)) & (db.budgets.status!="Creando")).select(db.budgets.ALL, orderby=~db.budgets.id) orders= db((db.orders.invoice==None) & (db.orders.user==request.args(0))).select(orderby=~db.orders.id) if customer!=None: first_name= Field('first_name', 'string', label=XML("<strong>Nombre</strong>"), length=128, notnull=True, default=customer.auth_user.first_name, requires=IS_NOT_EMPTY(error_message="No olvide esta dato")) last_name= Field('last_name', 'string', label=XML("<strong>Apellidos</strong>"), length=128, notnull=True, default=customer.auth_user.last_name, requires=IS_NOT_EMPTY(error_message="No olvide esta dato")) email=Field('email', label=XML('<strong>Email</strong>'), length=128, writable=False, notnull=True, default=customer.auth_user.email, requires=[IS_NOT_EMPTY(), IS_EMAIL(error_message='No puede estar vacío.')]) tax_identification = Field('tax_identification', 'string', label=XML("<strong>NIF/CIF/NIE</strong> <span class='glyphicon glyphicon-question-sign'></span>"),length=45, notnull=True, default=customer.fiscals.tax_identification, requires=IS_NOT_EMPTY(error_message="No olvide esta dato")) fiscalname=Field('fiscalname', 'string', label=XML("<strong>Nombre empresa</strong>") ,length =128, notnull=False, default=customer.fiscals.fiscalname) address=Field('address', 'string', label=XML("<strong>Dirección</strong>"), length =196, notnull=True, default=customer.fiscals.address, requires=IS_NOT_EMPTY(error_message="no olvide este dato")) city= Field('city', 'string', label=XML("<strong>Ciudad/Población</strong>"), length=45, notnull=True, default=customer.fiscals.city, requires=IS_NOT_EMPTY(error_message="no olvide este dato"), widget=wpoblacion) province = Field('province', 'string', label=XML("<strong>Provincia</strong>"), length=45, notnull=True, default=customer.fiscals.province, requires=IS_NOT_EMPTY(error_message="no olvide este dato"), widget=wprovincia) country=Field('country', 'string', label=XML("<strong>Pais</strong>"), length =45, notnull=True, default=customer.fiscals.country, requires=IS_NOT_EMPTY(error_message="no olvide este dato")) postalcode=Field('postal_code', 'string', label=XML("<strong>Código postal</strong>"), length=10, notnull=False, default=customer.fiscals.postal_code) phone=Field('phone', 'string', label=XML("<strong>Teléfono</strong>"), length=20, notnull=False, default=customer.fiscals.phone) form = SQLFORM.factory(first_name, last_name, email, tax_identification, fiscalname, address, city, province, country, postalcode, phone, submit_button = 'enviar datos', formstyle='bootstrap3_inline') if form.validate(keepvalues=True): try: db(db.auth_user.id==customer.auth_user.id).update(first_name=form.vars.first_name, last_name=form.vars.last_name) db(db.fiscals.id==customer.fiscals.id).update(tax_identification=form.vars.tax_identification, fiscalname=form.vars.fiscalname, address=form.vars.address, city=form.vars.city, province=form.vars.province, country=form.vars.country, postal_code=form.vars.postal_code, phone=form.vars.phone) db.commit() except Exception, ex: logger.debug("No se pudo modificar los datos del usuario/fiscal: %s" % ex) db.rollback() response.flash = 'Hubo un error: %s' % ex response.flash="Datos enviados correctamente" elif form.errors: response.flash = 'Hay errores' form.element('input[name=city]')['_class']='form-control' form.element('input[name=province]')['_class']='form-control' creditaccount=db(db.creditaccounts.user==customer.auth_user.id).select().first() accountingentries=None if creditaccount: accountingentries = db( (db.accountingentries.creditaccount==creditaccount.id) & (db.accountingentries.active==True) ).select( db.accountingentries.ALL, db.orders.ALL, db.invoices.ALL, db.products.name, join=[ db.orderlist.on(db.accountingentries.orderlist==db.orderlist.id), db.products.on(db.products.id==db.orderlist.product), db.orders.on(db.orders.id==db.orderlist.g_order), db.invoices.on(db.invoices.id==db.orders.invoice)], orderby=~db.accountingentries.id) return dict(form=form, contractedproducts=contractedproducts, invoices=invoices, budgets=budgets, orders=orders, userid=customer.auth_user.id, accountingentries=accountingentries, creditaccount=creditaccount) else: redirect(URL('administrator','newcustomer')) else: redirect(URL('administrator','users'))
#*/1 * * * * cd /home/gextiendas/web2py && /usr/bin/python web2py.py -S gextiendas -M -R applications/gextiendas/private/managetools/managedomains_contracts.py >> /tmp/manage_domains_contracts.out 2>&1 #este cron busca dominios para activar/desactivar en tiendas # client = SoapClient(wsdl="http://localhost:8000/internalgexcommerce/default/call/soap?WSDL=None") # client = SoapClient(wsdl="http://localhost:8000/internalgexcommerce/default/call/soap?WSDL=None") # logger.debug(client.addShopSite(auth.user_id)) #buscar contratos cuya fecha de expiración sea NULL o >= CURRENT_DATE() y plan distinto de NULL o free from gluon import * from shops import ContractedProduct, Product, PricePlan, Shop from invoices import Order, Orderlist contract = ContractedProduct(db) Product(db), PricePlan(db), Shop(db), Orderlist(db), Order(db) mcontracts = db( ((db.contractedproducts.expiration == None) | (db.contractedproducts.expiration >= datetime.datetime.now())) & ((db.profileplans.active == True) & (db.priceplans.planname != "free") & (db.contractedproducts.active == True))).select( db.contractedproducts.ALL, db.products.plan, db.products.price, db.products.suscription, db.products.name, db.priceplans.planname, db.priceplans.id, db.profileplans.ALL, db.orders.ALL,
def order_approving(): if auth.has_membership('administradores') or auth.has_membership('superadministradores'): from shops import ContractedProduct, Product, Shop from invoices import Order, Orderlist, Invoice, CreditAccount, AccountingEntry from queuemail import Queuemail from gluon.contrib.pysimplesoap.client import SoapClient queue=Queuemail(db) ContractedProduct(db), Product(db), Shop(db), Order(db), Orderlist(db), AccountingEntry(db) order=db.orders(request.vars.order) # order=db.orders(orderid) try: if order: #crear factura invoice=Invoice(db) invoiceid=invoice.makeinvoice(order.id) #aquí se hace además la anotación positiva en creditaccount if invoiceid!=None: # notificar recepción del pago subject="[gextiendas] Factura Nº %s" % db.invoices(invoiceid).invoice_number queuedata=[] urlinvoice= '%(scheme)s://%(host)s%(url)s' % {'scheme':request.env.wsgi_url_scheme,'host':request.env.http_host, 'url':URL('payment','code',args=[order.payment_code.code])} data={ "now": datetime.datetime.now().strftime("%d-%m-%Y %H:%M"), "name": order.user.first_name, "code": order.payment_code.code, "url": urlinvoice, } plaintext=""" \t\t\t\t Fuengirola (Málaga), a %(now)s \n Estimado %(name)s, hemos recibido un pago mediante transferencia correspondiente a la referencia de pago: %(code)s \n Puede descargarse la factura siguiendo este enlace:\n %(url)s \n El equipo de GEXtiendas.\n """ % data html=""" <p>Fuengirola (Málaga), a %(now)s</p> <p>Estimado %(name)s, hemos recibido un pago mediante transferencia correspondiente a la referencia de pago: %(code)s</p> <p>Puede descargarse la factura siguiendo este enlace:</p> <p><a href='%(url)s'>%(url)s</a></p> <p>El equipo de GEXtiendas.</p> """ % data queuedata.append({ 'to': '%s'%order.user.email, 'subject':subject, 'message':plaintext, 'html':XML(html), 'template':'communications/paymentreceived_template.html', 'title':'Pago recibido: %s' % subject, 'unsubscribe':'' }) queue.queuemessage(queuedata) # # client = SoapClient(wsdl="http://localhost:8000/internalgexcommerce/default/call/soap?WSDL=None") # logger.debug(client.enableDomainShop()) # buscar si hay dominios que estén esperando ser habilitados en una tienda del productocontratado en la lista de ese pedido # activar dominio # anotar accountinentry negativo # actualizar crédito session.flash="Operación realizada con éxito" else: session.flash="Hubo un error y no se pudo aprobar el pedido" else: session.flash="Hubo un error. No se pudo aprobar el pedido" except Exception as ex: logger.debug(ex) session.flash="Ocurrió un error %s " % ex redirect(URL('administrator','orders')) else: redirect(URL(request.application,'default','user/login'))