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 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 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 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 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 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 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 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 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')
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 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 test(Table):
time = DatetimeColumn(field='time', header='Timestamp')
BSSID = Column(field='BSSID', header='BSSID')
source_address = Column(field='source_address', header='Source address')
signal_strength = Column(field='signal_strength', header='Signal strength')
# frequency = Column(field='frequency', header='Frequency')
class Meta:
model = Probe
ajax = True
ajax_source = reverse_lazy('table_data')
class PlayerTable(Table):
FullName = Column(field='FullName', header="FullName")
NationalTeam = Column(field='Team', header="Team")
Competition = Column(field='Competition', header="Competition")
Position = Column(field='Position', header="Position")
class Meta:
model = Player
class DatasetListTable(Table):
id = Column(field='id', header='ID')
name = Column(field='name', header='Dataset')
status = DatasetStatusColumn(field='processing_finished', header='Status',
links=[Link(text='View', viewname='dataset-detail', args=(Accessor('pk'),))])
errors = ProcessingErrorColumn(header='', searchable=False, sortable=False)
class Meta:
model = Dataset
ajax = True
sort = [(0, 'desc')]
class adm_siteTable(Table):
username = Column(field='User.username', header='IT Name')
site = Column(field='site', header='Site Name')
# pc_dispose = Column(field='pc_dispose',header='PC-Dispose')
# stat_adm = Column(field='stat_adm',header='Stat Admin')
# it_adm = Column(field='it_adm',header='IT Admin')
# system_adm = Column(field='system_adm',header='System Admin')
OP = LinkColumn(header=u'操作', sortable=False, links=[])
class Meta:
model = adm_site
class ArchivoTable(Table):
number = Column(field='number', header=u'Numero de Archivo')
status = Column(field='status', header=u'Estado')
actual_time = Column(field='actual_time', header=u'Tiempo en Proceso')
total_time = Column(field='accumulated_time', header=u'Tiempo Total')
ver = LinkColumn(header=u'Detalles',
links=[
Link(text=u'Ver',
viewname='dashboard_file_check2',
args=(A('number'), ))
],
sortable=False)
class TicketsTable(Table):
id = Column(field='id', header='#')
first_name = Column(field='first_name', header='Prénom')
last_name = Column(field='last_name', header='Nom')
used = StatusColumn(searchable=False, sortable=False, header='Entrée')
code = CodeColumn(searchable=False,
sortable=False,
field='code',
header='')
class Meta:
model = Ticket
ajax = True
class SpectraTable(Table):
inventory_id = Column(field='standard.inventory_id', header='Inventory ID')
molecule = Column(field='standard.molecule.name', header='Molecule')
precursor_mz = MzColumn(field='precursor_mz', header='Precursor m/z')
adduct = AdductColumn(field='adduct.delta_formula', header='Adduct')
view = LinkColumn(header='', sortable=False, searchable=False,
links=[Link(text='View', viewname='fragmentSpectrum-detail', kwargs={'pk': Accessor('pk')})])
class Meta:
model = FragmentationSpectrum
ajax = True
ajax_source = reverse_lazy('spectra_table')
sort = [(0, 'asc')]
class RequerimientoTable(DefaultTable):
numero = Column(field='numero', header="Número")
fecha = DatetimeColumn(field='fecha', header="Fecha", format="%d/%m/%Y")
unidadorganica = columUnidad(field='unidadorganica', header="Solicitante")
cantidad = Column(field='cantidad', header="Cantidad")
# action = ActionColumn("suministros:requerimiento_editar", "suministros:requerimiento_eliminar")
class Meta(DefaultTable.Meta):
model = Requerimiento
id = "requerimientoTabla"
attrs = dict(
DefaultTable.Meta.attrs.items() +
{'dataUrlAdd': '/suministros/requerimiento/agregar/'}.items())
class SuministroTable(DefaultTable):
tipo = colTipo(field='tipo', header="Tipo", searchable=False)
codigo = Column(field='codigo', header="Código")
modelo = Column(field='modelo', header="Modelo")
rendimiento = colRendimiento(field='rendimiento', header="Rendimiento")
marca = Column(field='marca.nombre', header="Marca")
color = Column(field='color.nombre', header="Color")
action = ActionColumn("suministros:suministro_editar",
"suministros:suministro_eliminar")
class Meta(DefaultTable.Meta):
model = Suministro
id = "suministroTabla"
attrs = dict(
DefaultTable.Meta.attrs.items() +
{'dataUrlAdd': '/suministros/suministro/agregar/'}.items())
class ProjectContactIntersection(Table):
name = Column(field='name', header='Name')
class Meta:
search = True
#ajax = True
attrs = {'class': 'table-striped table-hover'}
def __init__(self, in_query=None, project=None, **kwargs):
super(ProjectContactIntersection, self).__init__(**kwargs)
project_assign_col = FunctionColumn(
header='Project Role',
extra_kwargs={'in_project': project},
function=get_project_relate_tag,
header_attrs={'width': "115px"})
self.columns.append(project_assign_col)
for task in in_query.all():
new_col = FunctionColumn(
header='Task: ' + task.brief,
extra_kwargs={'in_task': task},
function=get_assignment_tag,
)
self.columns.append(new_col)
class ColorTable(DefaultTable):
nombre = Column(field='nombre', header="Nombre")
codigo = Column(field='codigo', header="Código")
color = colColor(field='codigo',
header="Color",
searchable=False,
sortable=False,
header_attrs={'class': 'col-xs-1 text-center'})
action = ActionColumn("suministros:color_editar",
"suministros:color_eliminar")
class Meta(DefaultTable.Meta):
model = Color
id = "colorTabla"
attrs = dict(DefaultTable.Meta.attrs.items() +
{'dataUrlAdd': '/suministros/color/agregar/'}.items())
class AjaxSourceTable(Table):
id = Column(field='bulk_id')
bulk_title = Column(field='bulk_title')
reseller_name = Column(field='reseller_name')
reseller_mob = Column(field='reseller_mob')
bulk_receive_mode = Column(field='bulk_receive_mode')
start_time = Column(field='start_time')
dead_time = Column(field='dead_time')
bulk_status = Column(field='bulk_status')
countsize = Column(field='countsize')
details = Column(field='bulk_id')
class Meta:
model = BulkDetails
ajax = True
ajax_source = reverse_lazy('ajax_source_api')
class AjaxSourceTable(Table):
id = Column(field = 'id',sortable = False)
title = Column(field = 'title',sortable = False)
reseller = Column(field = 'reseller',sortable = False)
reseller_mob = Column(field = 'reseller_mob',sortable = False)
receive_mode = Column(field = 'receive_mode')
start_time = Column(field = 'start_time',searchable= False)
dead_time = Column(field = 'dead_time',searchable = False)
status = Column(field = 'status')
volume = Column(field = 'volume')
details = Column(field = 'id',sortable = False)
class Meta:
model = Bulk
ajax = True
ajax_source = reverse_lazy('ajax_source_api')
class OrgTable(Table):
view = LinkColumn(
header='View',
links=[
Link(
text='',
viewname='org-detail',
args=(A('id'), ),
attrs={'class': 'glyphicon glyphicon-eye-open'},
),
],
searchable=False,
sortable=False,
)
name = CustomNoneColumn(field='name', header='Name')
cons = Column(field='num_contacts', header='Contacts')
notes = BleachTrimColumn(field='notes', header='Notes')
class Meta:
model = Organization
search = True
ajax = True
ajax_source = reverse_lazy('data-organization')
attrs = {'class': 'table-striped table-hover'}
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')
id = Column(field='id')
#,header = u'团购编号')
# title = Column(field = 'title')
##,header = u'团购昵称')
# reseller_mob = Column(field = 'reseller_mob')
##,header = u'团主手机号')
# receive_mode = Column(field = 'receive_mode')
##,header = u'团购类型')
# start_time = Column(field = 'start_time')
##,header = u'开始时间')
# dead_time = Column(field = 'dead_time')
##,header = u'结束时间')
# status = Column(field = 'status')
##,header = u'团购状态')
# volume = Column(field = 'volume')
##,header = u'销量')
# details = Column(field = 'details')
#,header = u'详情')
class Meta:
model = Bulk
ajax = True
ajax_source = reverse_lazy('ajax_source_api')
class ProjectTable(Table):
view = LinkColumn(
header='View',
links=[
Link(
text='',
viewname='project-detail',
args=(A('id'), ),
attrs={'class': 'glyphicon glyphicon-eye-open'},
),
],
searchable=False,
sortable=False,
)
title = CustomNoneColumn(field='title', header='Title')
status = TagColumn(field='ajax_status',
header='Status',
wrap_class='task-status',
attrs=center_attrs)
completion = Column(field='ajax_completion', header='Completion')
deadline = NoneableDatetimeColumn(field='deadline',
header='Deadline',
format=date_time_format)
notes = BleachTrimColumn(field='notes', trim_count=250, header='Notes')
class Meta:
model = Project
search = True
ajax = True
ajax_source = reverse_lazy('data-project')
attrs = {'class': 'table-striped table-hover'}
