class CultureTable(Table):
photo = ImageColumn(field='variete.photo', header='Photo', sortable=False)
appelation = Column(field='variete.nom', header='Appelation')
date_debut = DatetimeColumn(field='date_debut', header='Cultivée depuis', format="%d %B %Y")
type_conservation = Column(field='type_conservation', header='Type de conservation')
action = LinkColumn(header='Action',
sortable=False,
links=[
Link(
text='Fiche variété',
viewname='s5appadherant:variete_detail',
args=(A('variete.id'),))
])
def __init__(self, *args, **kwargs):
jardin = kwargs.pop('jardin', None)
if not isinstance(jardin, Jardin):
raise ValueError("CultureTable: aucun jardin défini")
super(CultureTable, self).__init__(*args, **kwargs)
self.opts.ajax_source = reverse_lazy('s5appadherant:culture_data', kwargs={
'jardin_id': jardin.id
})
self.addons.pagination.length = 5
class Meta:
search = False
pagination_next = 'Suivant'
pagination_prev = 'Précédent'
zero_records = "Aucune variété n'est cultivée dans ce jardin"
ajax = True
model = Culture
attrs = {'class': 's5-table table-hover table-striped'}
class UserGroupTable(Table):
name = Column(field='name', header=u'Member Name', attrs={'class': 'custom'}, header_attrs={'width': '1%'})
create_date = Column(field='create_date', header=u'Added Date', attrs={'class': 'custom'}, header_attrs={'width': '1%'})
last_modified = Column(field='last_modified', header=u'Last Modified date', attrs={'class': 'custom'}, header_attrs={'width': '1%'})
model = Productsellingdetails
info_format = u"Total: _TOTAL_ First: _START_ Last: _END_"
class UserGroupLeaderTable(Table):
name = LinkColumn(field='name',header=u'Group Name', links=[Link(text=A('name'), viewname='leaders-members-list-view', args=(A('id',),))])
created_date = Column(field='created_date', header=u'Created Date', attrs={'class': 'custom'})
last_modified = Column(field='last_modified', header=u'Last Modified date', attrs={'class': 'custom'})
class Meta:
model = UserGroup
info_format = u"Total: _TOTAL_ First: _START_ Last: _END_"
class CheckboxColumnTable(Table):
id = Column(field='id', header=u'#')
name = Column(field='name', header=u'NAME')
married = CheckboxColumn(field='married', header=u'MARRIED')
class Meta:
model = Person
class FilterableTable(Table):
id = Column(field='id', header='#')
name = Column(field='name', header='NAME')
class Meta:
model = Person
using_filter_row = True
class PostTable(Table):
id = Column(field='id', header=u'Id')
title = Column(field='title', header=u'Titulo')
url = Column(field='url', header=u'Url')
content = Column(field='content', header=u'Content')
class Meta:
model = Post
class PostTable(Table): nombre = Column(field='nombre', header=u'nombre') departamento = Column(field='departamento', header=u'departamento') email = Column(field='email', header=u'email') fuera_convenio = Column(field='fuera_convenio', header=u'fuera_convenio') class Meta: model = Usuario
class SiteUserTable(Table):
first_name = Column(
field='first_name',
header='First name',
)
last_name = Column(
field='last_name',
header='Last name',
)
username = Column(field='username', header='Username')
email = Column(field='email', header='Email')
# is_superuser=AssertiveColumn(field='is_superuser',header='Is SuperUser')
Action = LinkColumn(
header='Action',
links=[
LinkColumnDelete(viewname='delete_user',
args=(A('id'), ),
text='Delete'),
# Link(viewname='update_user', args=(A('id'),), text='Update'),
LinkColumnAccess(viewname='access_status',
args=(A('id'), ),
text='Access change')
])
class Meta:
model = User
ajax = True
ajax_source = reverse_lazy('ajax_site_user_table_data')
class CategoryTable(Table, ImageColumnChange):
name = Column(field='name', header='Name')
image = ImageColumnChange(field='image.url',
header='Image',
image_title='image')
descriptions = Column(field='descriptions', header='Descriptions')
created_at = Column(field='created_at', header='Create Date')
updated_at = DatetimeColumn(field='updated_at',
header='Update date',
format='%d-%m-%Y %H:%I:%S')
Action = LinkColumn(header='Action',
links=[
LinkColumnDelete(viewname='delete_category',
args=(A('id'), ),
text='Delete'),
LinkColumnUpdate(viewname='update_category',
args=(A('id'), ),
text='Update')
])
class Meta:
model = Category
ajax = True
ajax_source = reverse_lazy('category_table_data')
class ClientTable(Table):
usuario = Column(field='usuario')
nombreapp = Column(field='nombreapp')
ip = Column(field='ip')
class Meta:
model = clients
class GroupTable(Table):
# id = LinkColumn(header=u'#',
# links=[MyLink(field='id',
# viewname='group_page',
# args=(A('id'),)), ],
# )
id = Column(field='id', header=u'#',
header_attrs={'width': '5%'})
name = Column(field='name', header=u'名称',
header_attrs={'width': '15%'})
join_method = Column(field='join_method', header=u'加入方式',
header_attrs={'width': '15%'})
create_by = Column(field='create_user_name', header=u'创建者',
header_attrs={'width': '20%'})
create_time = MyDateTimeColumn(field='create_time', header=u'创建时间',
format="%Y年%m月%d日 %H:%I"
)
class Meta:
model = Group
search = True
search_placeholder = 'search'
pagination = True
class RequerimientoDetalleTabla(DefaultTable):
requerimiento = columRequerimiento(field='requerimiento',
header='Requerimiento')
suministro = Column(field='suministro', header='Suministro')
cantidad = Column(field='cantidad', header="Cantidad")
action = ActionColumn(
url_delete="suministros:requerimientoDetalle_eliminar")
class Meta(DefaultTable.Meta):
id = "requerimientoTabla"
model = RequerimientoDetalle
def __init__(self, args, **kwargs):
super(RequerimientoDetalleTabla, self).__init__(args, **kwargs)
iduO = args.get("pk", 0)
if self.opts.attrs.__contains__("dataUrlAdd"):
self.opts.attrs = str(
self.opts.attrs).split("dataUrlAdd")[0].strip()
self.opts.attrs = SafeString(
self.opts.attrs +
' dataUrlAdd="/suministros/requerimiento/agregar/' + str(iduO) +
'"')
self.opts.ajax_source = reverse(
viewname="suministros:requerimiento_listar", kwargs={'uO': iduO})
class AccountTable(Table):
id = Column(field='id')
first_name = Column(field='first_name')
last_name = Column(field='last_name')
emailid = Column(field='emailid')
class Meta:
model = Account
class ButtonsExtensionTable(Table):
id = Column(field='id', header='#')
name = Column(field='name', header='NAME')
organization = Column(field='organization.name', header='ORGANIZATION')
class Meta:
model = Person
template_name = 'buttons_table.html'
class EmployeeTable(Table):
user = Column(field = 'user', header='Name')
emp_id = Column(field='emp_id', header='Emp Id')
no_of_mentors = Column(field='no_of_mentors' , header='No. of Mentors')
no_of_student = Column(field='no_of_student', header= 'No. of Students')
class Meta:
model = Employee
class PokemonTable(Table):
name = Column(field='name', header="Name")
type_1 = Column(field='type_1', header="Type 1")
type_2 = Column(field='type_1', header="Type 2")
total = Column(field='total', header="Total")
class Meta:
model = Pokemon
class PlainteTable(Table):
nom = Column(field='nom')
prenoms = Column(field='prenoms')
email = Column(field='email')
class Meta:
model = Plainte
ajax = True
class AjaxSourceTable(Table):
id = Column(field='id', header=u'#')
name = Column(field='name', header=u'NAME')
class Meta:
model = Person
ajax = True
ajax_source = reverse_lazy('ajax_source_api')
class TestTable(Table):
id = Column('id', header='#')
name = Column('name', header='NAME')
email = Column('email', header='EMAIL', searchable=False)
class Meta:
model = Person
ajax = True
class AjaxTable(Table):
id = Column(field='id', header=u'#')
name = Column(field='name', header=u'NAME')
organization = Column(field='organization.name', header=u'ORG')
class Meta:
model = Person
ajax = True
class bl_listTable(Table):
bl_name = Column(field='bl_name', header='BL Name')
bl_leader = Column(field='bl_leader', header='BL Leader')
OP = LinkColumn(header=u'操作', sortable=False, links=[])
class Meta:
model = bl_list
class ProductTable(Table):
Product_Id = Column(field='id')
Product_Name = Column(field='product_name')
Descriptions = Column(field='product_details')
Quantity = Column(field='product_quantity')
Price = Column(field='product_price')
class Meta:
model = models.Products
class HttpProxyTable(Table):
id = Column(field='id', header=u'#')
name = Column(field='nick_name', header=u'Nick Name' )
hash_id = Column(field='hash_id', header=u'Hash ID' )
lan_ip = Column(field='lan_ip', header=u'Proxy Address')
modified_datetime = DatetimeColumn(field='modified_datetime', format='%Y-%m-%d %H:%M:%S', header=u'Update Time')
status = Column(field='status', header=u'Status')
class Meta:
model = HttpProxy
class Dept_listTable(Table):
bl_list = Column(field='bl_list', header='BL Name')
dept_name = Column(field='dept_name', header='Dept Name')
dept_leader = Column(field='dept_leader', header='dept_leader')
#address = Column(field='address', header='Address')
OP = LinkColumn(header=u'操作', sortable=False, links=[])
class Meta:
model = dept_list
class siteTable(Table):
id = Column(field='id', header='ID')
sitename = Column(field='sitename', header='Site Code')
officename = Column(field='officename', header='Office Name')
address = Column(field='address', header='Address')
OP = LinkColumn(header=u'操作', sortable=False, links=[])
class Meta:
model = site
class MenuplanTable(Table):
name = Column(field='name', header='Name')
creationDate = Column(field='creationDate', header='Creation Date')
links = LinkColumn(
header='Actions',
links=[
Link(text='Open', viewname='menuplans.detail', args=(A('pk'), ))
]
)
class UserleadersTable(Table):
#'leader__name','user__mobile_number','user__aadhar_number','create_date','last_modified'
user__name = LinkColumn(field='user__name',header=u'Member Name', links=[Link(text=A('user__name'), viewname='leaders Group List Template View', args=(A('user_id',),))])
user__mobile_number = Column(field='user__mobile_number', header=u'Mobile Number', attrs={'class': 'custom'})
user__aadhar_number = Column(field='user__aadhar_number', header=u'QR Code', attrs={'class': 'custom'})
create_date = Column(field='create_date', header=u'Added Date', attrs={'class': 'custom'})
last_modified = Column(field='last_modified', header=u'Last Modified date', attrs={'class': 'custom'})
class Meta:
model = Userleaders
info_format = u"Total: _TOTAL_ First: _START_ Last: _END_"
class CitacionTable(Table):
id = Column(field='id', header=u'Id')
nota = Column(field='nota', header=u'nota')
inscripcion = Column(field='inscripcion.persona.nombres',
header=u'inscripcion')
citacion = Column(field='citacion.salon', header=u'citacion')
nivel_sugerido = Column(field='nivel.nombre', header=u'nivel')
class Meta:
model = Inscripcion_Examen
class GroupmemberLeaderTable(Table):
member__first_name = LinkColumn(field='member__first_name',header=u'Member Name', links=[Link(text=A('member__first_name'), viewname='leaders-member_schoose_view', args=(A('member_id',),A('user_group_id',),))])
#member__first_name = Column(field='member__first_name', header=u'Member Name', attrs={'class': 'custom'})
user_group__name = Column(field='user_group__name', header=u'Group Name', attrs={'class': 'custom'})
member__mobile_number = Column(field='member__mobile_number', header=u'Mobile Number', attrs={'class': 'custom'})
member__aadhar_number = Column(field='member__aadhar_number', header=u'QR Code', attrs={'class': 'custom'})
created_date = Column(field='created_date', header=u'Added Date', attrs={'class': 'custom'})
class Meta:
model = Groupmember
info_format = u"Total: _TOTAL_ First: _START_ Last: _END_"
class AccountTable(Table):
id = Column(field='id')
first_name = Column(field='first_name')
last_name = Column(field='last_name')
emailid = Column(field='emailid')
class Meta:
model = Account
# ajax = True
# ajax_source = reverse_lazy('table_data')