def articulo():
# presentacion de tabla de articulos ############
datasource = db(db.articulo.id>0).select()
powerTable = plugins.powerTable
powerTable.datasource = datasource
powerTable.headers = 'labels'
powerTable.showkeycolumn = False
powerTable.dtfeatures['bJQueryUI'] = request.vars.get('jqueryui',True)
powerTable.uitheme = request.vars.get('theme','Smoothness')
powerTable.dtfeatures["sScrollY"] = "100%"
powerTable.dtfeatures["sScrollX"] = "100%"
powerTable.dtfeatures['sPaginationType'] = 'full_numbers'
powerTable.dtfeatures["iDisplayLength"] = 10
powerTable.extrajs = dict(autoresize={},
tooltip={},
details={'detailscolumns':'articulo.memo'}
)
powerTable.keycolumn = 'articulo.id'
powerTable.columns = ['articulo.descripcion','articulo.link',
'articulo.precio','articulo.categoria']
# alta de articulos ####################
mystep = [dict(title='NUEVOS ARTICULOS',Legend='Ingrese los datos del articulo',
fields=['descripcion','memo','iva','precio','categoria'])]
from plugin_PowerFormWizard import PowerFormWizard
options = {'description':False,'legend':True,'validate':True}
form = PowerFormWizard(db.articulo, steps=mystep, options=options)
if form.accepts(request.vars, session):
response.flash = "registro aceptado"
elif form.errors:
form.step_validation()
response.flash = "error en los datos"
return dict( table=powerTable.create(),form=form)
def cliente():
# presentacion de listado de clientes
datasource = db(db.cliente.id>0).select()
powerTable = plugins.powerTable
powerTable.datasource = datasource
powerTable.headers = 'labels'
powerTable.showkeycolumn = False
powerTable.dtfeatures['bJQueryUI'] = request.vars.get('jqueryui',True)
powerTable.uitheme = request.vars.get('theme','Smoothness')
powerTable.dtfeatures["sScrollY"] = "100%"
powerTable.dtfeatures["sScrollX"] = "100%"
powerTable.dtfeatures['sPaginationType'] = 'full_numbers'
powerTable.dtfeatures["iDisplayLength"] = 20
# alta de clientes
mystep = [dict(title='NUEVO CLIENTE',Legend='Ingrese los datos del nuevo cliente',
fields=['empresa','contacto','telefono','correo'])]
from plugin_PowerFormWizard import PowerFormWizard
options = {'description':False,'legend':True,'validate':True}
form = PowerFormWizard(db.cliente, steps=mystep, options=options)
if form.accepts(request.vars, session):
response.flash = "registro aceptado"
elif form.errors:
form.step_validation()
response.flash = "error en los datos"
return dict( table=powerTable.create(),form=form)
def categoria():
# presentacion de categorias de articulos
datasource = db(db.categoria.id>0).select()
powerTable = plugins.powerTable
powerTable.datasource = datasource
powerTable.headers = 'labels'
powerTable.showkeycolumn = False
powerTable.dtfeatures['bJQueryUI'] = request.vars.get('jqueryui',True)
powerTable.uitheme = request.vars.get('theme','Smoothness')
powerTable.dtfeatures["sScrollY"] = "100%"
powerTable.dtfeatures["sScrollX"] = "100%"
powerTable.dtfeatures['sPaginationType'] = 'full_numbers'
powerTable.dtfeatures["iDisplayLength"] = 30
# alta de categoria de articulos
mystep = [dict(title='NUEVAS CATEGORIAS',Legend='Ingrese una Categoria para Agrupar artículos',fields=['name'])]
from plugin_PowerFormWizard import PowerFormWizard
options = {'description':False,'legend':True,'validate':True}
form = PowerFormWizard(db.categoria, steps=mystep, options=options)
if form.accepts(request.vars, session):
response.flash = "registro aceptado"
elif form.errors:
form.step_validation()
response.flash = "error en los datos"
return dict( table=powerTable.create(),form=form)
def movimientos():
mystep = [dict(title='MOVIMIENTOS',Legend='Ingrese los datos solicitados',
fields=['entregado_x','retirado_x','id_articulo','cantidad',
'estado','Comprobante',
'cliente','concepto'])]
from plugin_PowerFormWizard import PowerFormWizard
options = {'description':False,'legend':True,'validate':True}
form = PowerFormWizard(db.movimientos, steps=mystep, options=options)
if form.accepts(request.vars, session):
response.flash = "registro aceptado"
#rows = db(db.movimientos.id>0).select()
#last_row = rows.last()
#a=db.memomovi.insert(referencia=last_row.id,entregado_x=last_row.entregado_x,
#retirado_x=last_row.retirado_x,id_articulo=last_row.id_articulo,
#cantidad=last_row.cantidad,fecha_pedido=last_row.fecha_pedido,
#fecha_devuelta=last_row.fecha_devuelta,estado=last_row.estado,
#Comprobante=last_row.Comprobante,cliente=last_row.cliente)
#db.commit()
elif form.errors:
form.step_validation()
response.flash = "error en los datos"
return dict(form=form)
