def update_params(self,d):
q = DBSession.query(Phone)
if not in_group('admin'):
dptm = [p.department.dptm_id for p in request.identity['user'].phone]
q = q.filter(Phone.department_id.in_(dptm))
q = q.order_by(Phone.exten)
d['options'] = [(p.exten, p.exten) for p in q]
SingleSelectField.update_params(self, d)
return d
def update_params(self,d):
opt_ext = [(p.exten, p.exten) for p in DBSession.query(Phone).order_by(Phone.exten)]
if in_group('admin'):
# help_text = u'Sélectionnez le poste interne ou le SVI destination du renvoi'
opt_ivr = [(a.exten, a.name) for a in DBSession.query(Application).order_by(Application.name)]
d['options'] = [(u'Postes', opt_ext), (u'SVI', opt_ivr)]
else:
d['options'] = opt_ext
SingleSelectField.update_params(self, d)
return d
def update_params(self,d):
options = [(-1, '- - -')]
for s in DBSession.query(Sound).filter(Sound.type==self.sound_type).order_by(Sound.name):
c = s.name
if s.comment is not None:
c += u' : ' + (s.comment if len(s.comment)<40 \
else s.comment[:40] + '...')
options.append((s.sound_id, c))
d['options'] = options
SingleSelectField.update_params(self, d)
return d
def update_params(self, d): rows = DBSession.query(ScaleModel) #rows = rows.filter(ScaleModel.display == True) rows = rows.order_by(ScaleModel.name) options = [(None, '-')] for row in rows: options.append( ( row.id, row.name, ) ) d['options'] = options SingleSelectField.update_params(self, d) return d
def update_params(self, d):
rows = DBSession.query(ManufacturerModel)
rows = rows.filter(ManufacturerModel.display == True)
rows = rows.order_by(ManufacturerModel.sort)
options = [(None, '-')]
for row in rows:
options.append(
(
row.id,
"{n:.32} - ({i})".format(
n=row.name,
i=row.identifier
)
)
)
d['options'] = options
SingleSelectField.update_params(self, d)
return d
def update_params(self,d):
options = [(u.user_id, u.user_name) for u in
(DBSession.query(Group).filter(Group.group_name=='SVI').one()).users]
d['options'] = options
SingleSelectField.update_params(self, d)
return d
def update_params(self, sf):
svi = DBSession.query(Group).filter(Group.group_name == "SVI").one()
sf["options"] = [(u.user_id, u.display_name) for u in svi.users]
SingleSelectField.update_params(self, sf)
return sf
