class ActivityDSPGPGC_Table(Table):
classes = ["table table-hover"]
id = Col('Id', show=False)
description = Col('Description')
dspgpgc_id = Col('Disciplina')
process_id = Col('No', show=False)
tasks = LinkCol('Tareas', 'show_DSPGPGC_activities_tasks', url_kwargs=dict(did='id', pid='process_id',aid='id'))
edit = LinkCol('Edit', 'edit_DSPGPGC_activity', url_kwargs=dict(id='id', pid='process_id', did='dspgpgc_id'))
delete = LinkCol('Delete', 'delete_DSPGPGC_activity', url_kwargs=dict(id='id', pid='process_id', did='dspgpgc_id'),
anchor_attrs={'id': 'warning'})
class CemeteriesTable(Table):
cemetery_id = Col('CemeteryId', show=False)
name = Col('Name')
address = Col('Address')
phone = Col('Phone')
places = Col('Places')
edit = LinkCol('Edit', '.edit_cemetery', url_kwargs=dict(id='cemetery_id'))
delete = LinkCol('Delete',
'.delete_cemetery',
url_kwargs=dict(id='cemetery_id'))
class Repellent(Table):
classes = ['main', 'chart', 'repellent']
id = Col('id', show=False)
name = Col('Name')
type = Col('Type')
target = Col('Target')
price = Col('Price')
purchase_location = Col('Purchase Location')
notes = Col('Notes')
edit = LinkCol('Edit', 'edit_repellent', url_kwargs=dict(id='id'))
delete = LinkCol('Delete', 'delete_repellent', url_kwargs=dict(id='id'))
class Nutrient(Table):
classes = ['main', 'chart', 'nutrient']
id = Col('id', show=False)
name = Col('Name')
organic = Col('Organic')
nitrogen = Col('Nitrogen')
phosphorus = Col('Phosphorus')
potassium = Col('Potassium')
trace = Col('Trace')
edit = LinkCol('Edit', 'edit_nutrient', url_kwargs=dict(id='id'))
delete = LinkCol('Delete', 'delete_nutrient', url_kwargs=dict(id='id'))
class ListLanguages(Table):
"""Holds a list of all languages"""
id = Col('Id', show=False)
iso_code = Col('Iso-Code')
name = Col('Name')
edit = LinkCol('Edit',
'language.edit',
url_kwargs=dict(iso_code='iso_code'))
delete = LinkCol('Delete',
'language.delete',
url_kwargs=dict(iso_code='iso_code'))
class FoldersResults(Table):
id = Col('id', show=False)
name = Col('name')
kind = Col('kind')
project_id = Col('project_id')
created_at = Col('created_at')
updated_at = Col('updated_at')
device_created_at = Col('device_created_at')
device_updated_at = Col('device_updated_at')
deleted_at = Col('deleted_at')
edit = LinkCol('Edit', 'folderedit', url_kwargs=dict(id='id'))
delete = LinkCol('Delete', 'folderdelete', url_kwargs=dict(id='id'))
class Results(Table):
id = Col('Id', show=False)
item = Col('Item')
price = Col('Price')
quantity = Col('Quantity')
store_name = Col('Store Name')
address = Col('Address')
date_to_purchase = Col('Date To Purchase')
note = Col('Note')
edit = LinkCol('Edit', 'edit', url_kwargs=dict(id='id'))
delete = LinkCol('Delete', 'delete', url_kwargs=dict(id='id'))
class Results(Table):
user_id = Col('Id', show=False)
user_name = Col('Name')
user_email = Col('Email')
user_password = Col('Password')
user_conformpassword = Col('conformpassword')
user_gender = Col('gender')
user_mobileno = Col('mobileno')
user_address = Col('address')
#user_bday=Col('bday')
edit = LinkCol('Edit', 'edit_view', url_kwargs=dict(id='user_id'))
delete = LinkCol('Delete', 'delete_user', url_kwargs=dict(id='user_id'))
class ItemTable(Table):
first_name = Col('First Name')
last_name = Col('Last Name')
email = Col('Email')
edit_details = LinkCol('Edit user',
endpoint='update_user',
url_kwargs=dict(first_name='first_name',
last_name='last_name',
email='email'))
delete_details = LinkCol('Delete user',
endpoint='update',
url_kwargs=dict(email='email'))
class Results(Table):
stud_id = Col('ID', show=False)
studno = Col('Student Number')
fname = Col('First Name')
lname = Col('Last Name')
contact = Col('Contact Number')
gender = Col('Gender')
bday = Col('Birthday')
program = Col('Program')
edit = LinkCol('Update',
'updatestudentsview',
url_kwargs=dict(id='stud_id'))
delete = LinkCol('Delete', 'deletestudent', url_kwargs=dict(id='stud_id'))
class Results(Table):
user_id = Col('Id', show=False)
user_name = Col('First Name')
other_name = Col('Middle Name')
surname = Col('Surname')
user_email = Col('Email')
phone = Col('Phone')
address = Col('Address')
ec_number = Col('EC Number')
role = Col('Role')
user_password = Col('Password', show=False)
edit = LinkCol('Edit', 'edit_view', url_kwargs=dict(id='user_id'))
delete = LinkCol('Delete', 'delete_user', url_kwargs=dict(id='user_id'))
class OrdersManager(Table):
order_id = Col('id')
order_date = Col('order date')
game_id = Col('game id')
net_amount = Col('net amount')
discount = Col('discount')
gross_amount = Col('gross amount')
edit = LinkCol("Edit me!",
"edit_order",
url_kwargs=dict(order_id="order_id"))
delete = LinkCol("Delete me!",
"delete_order",
url_kwargs=dict(order_id="order_id"))
class status(Table):
stat_id = Col('stat_id', show=False)
accel_id = Col('accel_id')
tsm_name = Col('tsm_name')
node_id = Col('node_id')
accel_number = Col('accel')
ts_flag = Col('ts_flag')
date_identified = Col('date_identified')
status = Col('status', show=False)
accel_status = Col('accel_status')
remarks = Col('remarks')
edit = LinkCol('Edit', 'edit_view', url_kwargs=dict(id='stat_id'))
delete = LinkCol('Delete', 'delete_status', url_kwargs=dict(id='stat_id'))
class ResultsFile(Table):
fileId = Col('File Id', show=True)
objectName = Col('Object Name')
date = Col('Date')
time = Col('Time')
timeStamp = Col('Time Stamp')
reductionStage = Col('Reduction Stage')
fileType = Col('File Type')
quality = Col('Quality')
position = Col('Position')
bandType = Col('Band Type')
edit = LinkCol('Edit', 'edit_file_view', url_kwargs=dict(id='fileId'))
delete = LinkCol('Delete', 'delete_file', url_kwargs=dict(id='fileId'))
class FloorplansResults(Table):
id = Col('id', show=False)
name = Col('name')
description = Col('description')
project_id = Col('project_id')
folder_id = Col('folder_id')
is_name_confirmed = Col('is_name_confirmed')
created_at = Col('created_at')
updated_at = Col('updated_at')
device_updated_at = Col('device_updated_at')
deleted_at = Col('deleted_at')
edit = LinkCol('Edit', 'floorplanedit', url_kwargs=dict(id='id'))
delete = LinkCol('Delete', 'floorplandelete', url_kwargs=dict(id='id'))
class Students(Table):
id = Col('Id', show=False)
name = Col('Name')
points_redeemed = Col('Points Redeemed')
teacher = Col('Teacher')
volunteer = Col('Volunteer')
current_points = Col('Current Points')
redeem = LinkCol('Redeem', 'redeem', url_kwargs=dict(id='id'))
# add_points = LinkCol('Add Points', 'add', url_kwargs=dict(id='id'))
update = LinkCol('Update Points',
'update_points',
url_kwargs=dict(id='id'))
delete = LinkCol('Delete', 'delete', url_kwargs=dict(id='id'))
class RJobTable(Table):
jobId = Col("JID")
nodeId = Col('NID')
taskId = Col('TID')
status = Col("Status")
name = Col("Name")
resource = Col("Resource")
commandLine = Col("Command")
packagePath = Col("Package")
imageId = Col("Image")
timeout = Col("Timeout")
det = LinkCol("Details", "detail", url_kwargs=dict(jid="jobId"))
kil = LinkCol("Kill", "kill", url_kwargs=dict(jid="jobId"))
class ResultsTable(Table):
id = Col('Id', show=False)
centris_id = Col('Centris ID', )
category = Col('Category')
price = Col('Price')
centris_detail_url = LinkCol('Centris details',
'redirect_page',
url_kwargs=dict(link='centris_detail_url'))
broker_detail_url = LinkCol('Broker details',
'redirect_page',
url_kwargs=dict(link='broker_detail_url'))
geofence = Col('Region')
potential_revenue = Col('Potential Revenue')
pt_revenue = Col('% Revenue')
class ItemTable5(Table):
classes = ['table', 'table-bordered', 'thead-inverse']
username = LinkCol('Username',
'reid_detail',
url_kwargs=dict(sname='sname'),
attr='username')
filename = LinkCol('Filename',
'score_detail',
url_kwargs=dict(_id='_id'),
attr='filename')
submit_time = Col('Submit time')
utility = Col('UTL')
security = Col('SEC')
average = Col('AVG')
class ClientsTable(Table):
client_id = Col('ClientId', show=False)
fullname = Col('Fullname')
passport_number = Col('PassportNumber')
birthdate = Col('Birthday')
deathdate = Col('Deathday')
size = Col('Size')
weight = Col('Weight')
cemetery_name = Col('Cemetery')
mortuary_name = Col('Mortuary')
edit = LinkCol('Edit', '.edit_client', url_kwargs=dict(id='client_id'))
delete = LinkCol('Delete', '.delete_client', url_kwargs=dict(id='client_id'))
class Results(Table):
id = Col('id')
title = Col('Title')
description = Col('Description')
price = Col('Price')
shelf_time = Col('Shelf Time')
category_names = Col('Category names')
vendor = Col('Vendr')
source = Col('Source')
delivery_option = Col('Delivery Option')
view = LinkCol('View', 'main.read_product', url_kwargs=dict(id='id'))
edit = LinkCol('Edit', 'main.update_product', url_kwargs=dict(id='id'))
delete = LinkCol('Delete', 'main.delete_product', url_kwargs=dict(id='id'))
class Results(Table):
id = Col('ID')
cover = Col('Cover')
name = Col('Album Name')
genre_id = Col('Genre')
album_artists = Col('Artists')
album_comment = Col('Comments')
album_rating = Col('Rating')
tracks = Col('Track Names')
album_or_ep = Col('Album or EP')
releaseDate = Col('Release Date')
detailedInfo = Col('Information')
edit = LinkCol('Edit', 'edit', url_kwargs=dict(id='id'))
delet = LinkCol('Delete', 'delet', url_kwargs=dict(id='id'))
class TrackingAccountResults(Table):
aid = Col('Id', show=False)
aname = Col('Name')
adescription = Col('Description')
aNet = Col('Net Exchange')
# Called edit_trackingaccount() when the link is clicked.
edit = LinkCol('Edit', 'edit_trackingaccount', url_kwargs=dict(aid='aid'))
# Called delete_trackingaccount() when the link is clicked.
delete = LinkCol('Delete',
'delete_trackingaccount',
url_kwargs=dict(aid='aid'))
view = LinkCol('View',
'view_trackingaccount',
url_kwargs=dict(aid='aid'),
url_kwargs_extra=dict(time=CURRENT_MONTH))
class UserTable(Table):
_id = Col('_id', show=False)
first_name = Col('First Name')
last_name = Col('Last Name')
email = Col('Email')
role = Col('Role')
edit = LinkCol('Edit', 'edit', url_kwargs=dict(id='_id'))
class MyTable(Table):
name = Col('Name')
view = LinkCol('View',
'view',
url_kwargs=dict(id_='id'),
url_kwargs_extra=dict(id_='id-from-extra',
extra='extra'))
class ApplyResearchTable(Table):
classes = ['table']
id = Col('Id', show=False)
title = Col('Título')
professor = Col('Professor')
description = Col('Descrição')
apply = LinkCol('Candidatar!', 'apply', url_kwargs=dict(id='id'))
class TableFormatSummary(Table):
urlpath = LinkCol('urlpath',
'browser.summarise_directory',
url_kwargs=dict(path='urlpath'),
allow_sort=True,
attr_list=['urlpath'])
suite_count = Col('suite_count')
feature_count = Col('feature_count')
scenario_count = Col('scenario_count')
def __init__(self, suite_summary=None, **kwargs):
if suite_summary is None:
suite_summary = SuiteSummary(**kwargs)
items = [TableFormatEntry(suite_summary=suite_summary, **kwargs)]
for summary in suite_summary.suites.values():
items.append(TableFormatEntry(suite_summary=summary, **kwargs))
for summary in suite_summary.features.values():
items.append(TableFormatEntry(suite_summary=summary, **kwargs))
super().__init__(items)
self.sort_url(None, reverse=False)
def sort_url(self, col_id, reverse=False):
self.items = sorted(self.items,
key=lambda x: x.urlpath,
reverse=reverse)
class Results(Table):
user_id = Col('Id', show=False)
user_name = Col('Name')
user_email = Col('Email')
user_password = Col('Password', show=False)
#edit = LinkCol('Edit', 'edit_view', url_kwargs=dict(id='user_id'))
delete = LinkCol('Delete', 'delete_user', url_kwargs=dict(id='user_id'))
class Product(Table):
classes = ['main', 'chart', 'product']
id = Col('id', show=False)
name = Col('Name')
location = Col('Location')
light_hours = Col('Light Hours')
temperature = Col('Temperature')
humidity = Col('Humidity')
light_source = Col('Light Source')
lumens = Col('Lumens')
wattage = Col('Wattage')
grow_area = Col('Grow area')
containment = Col('Containment')
max_customers = Col('Maximum Number of Customers')
edit = LinkCol('Edit', 'edit_product', url_kwargs=dict(id='id'))
delete = LinkCol('Delete', 'delete_product', url_kwargs=dict(id='id'))
class ResultsDelete(Table):
id = Col('Id', show=False)
name = Col('Name')
code = Col('Code')
fair_price = Col('Fair Price')
gain = Col('Gain')
edit = LinkCol('Delete', 'delete', url_kwargs=dict(name='name'))
