def view_delete(request):
q = query_id(request)
row = q.first()
a = row.id
if not row:
return id_not_found(request)
if row.disabled:
request.session.flash('Data tidak dapat dihapus.', 'error')
return route_list(request)
# Seleksi untuk mengecek item
i = DBSession.query(ProductAdjustItem).filter(ProductAdjustItem.product_adjust_id==a).first()
if i:
request.session.flash('Hapus dahulu item produk / barang.', 'error')
return route_list(request)
form = Form(colander.Schema(), buttons=('hapus','batal'))
if request.POST:
if 'hapus' in request.POST:
msg = 'Data %s sudah dihapus.' % (row.nama)
q.delete()
DBSession.flush()
request.session.flash(msg)
return route_list(request)
return dict(row=row, form=form.render())
def get_doctypes_schema(userdatas_model):
"""
Build a form schema for doctypes registration
:param obj userdatas_model: An instance of userdatas we're building
the form for
"""
registered = userdatas_model.doctypes_registrations
node_schema = SQLAlchemySchemaNode(UserDatasSocialDocTypes)
node_schema.widget = deform.widget.MappingWidget(
template="clean_mapping.pt"
)
node_schema['status'].widget = deform.widget.CheckboxWidget()
form_schema = colander.Schema()
for index, entry in enumerate(registered):
node = node_schema.clone()
name = 'node_%s' % index
node.name = name
node.title = u''
node['status'].title = u''
node['status'].label = entry.doctype.label
form_schema.add(node)
return form_schema
def __init__(self, dbsession, obj, table):
self.dbsession = dbsession
self.obj = obj
self.table = table
self.columns_by_group = columns_by_group(self.table)
self.schema = colander.Schema()
self.relationships = get_single_field_relatioships(self.table)
def view_delete(request):
q = query_id(request)
row = q.first()
if not row:
return id_not_found(request)
form = Form(colander.Schema(), buttons=('delete', 'cancel'))
msg = 'Penerimaan ID %d %s sudah dihapus.' % (row.sts_id, row.sspd_id)
### ARStsItem
jumlah = DBSession.query(ARStsItem.jumlah).\
filter(ARStsItem.sspd_id==row.sspd_id).scalar()
print '------------------Jumlah STS Item------------------', jumlah
### ARSts
jumlah1 = DBSession.query(ARSts.jumlah).\
filter(ARSts.id==request.session['sts_id']).scalar()
print '------------------Jumlah STS-----------------------', jumlah1
if jumlah:
hasil = jumlah1 - jumlah
rows = DBSession.query(ARSts).filter(
ARSts.id == request.session['sts_id']).first()
rows.jumlah = hasil
DBSession.add(rows)
DBSession.flush()
q.delete()
DBSession.flush()
q = DBSession.query(ARSspd).filter(
ARSspd.id == request.matchdict['id']).first()
q.posted = 0
DBSession.add(q)
DBSession.flush()
request.session.flash(msg)
return route_list(request)
def view_delete(request):
q = query_id(request)
row = q.first()
x = row.approval_level
a = row.product_request_id
if not row:
return id_not_found(request)
if x == 2:
request.session.flash(
'Data tidak dapat dihapus, karena sudah disetujui.', 'error')
return route_list(request)
form = Form(colander.Schema(), buttons=('hapus', 'batal'))
if request.POST:
if 'hapus' in request.POST:
msg = 'Approval order ID %d sudah dihapus.' % (row.id)
q.delete()
DBSession.flush()
request.session.flash(msg)
r = DBSession.query(ProductRequest).filter(
ProductRequest.id == a).first()
r.approval_level = 0
r.disabled = 0
save_request2(r)
return route_list(request)
return dict(row=row, form=form.render())
def view_delete(request):
q = query_id(request)
row = q.first()
id = row.id
x = DBSession.query(UserGroup).filter(UserGroup.group_id == id).first()
if x:
request.session.flash(
'Tidak bisa dihapus, Karena datanya terpakai diusergroup.',
'error')
return route_list(request)
y = DBSession.query(GroupRoutePermission).filter(
GroupRoutePermission.group_id == id).first()
if y:
request.session.flash(
'Tidak bisa dihapus, Karena datanya terpakai di group permission.',
'error')
return route_list(request)
if not row:
return id_not_found(request)
form = Form(colander.Schema(), buttons=('delete', 'cancel'))
if request.POST:
if 'delete' in request.POST:
msg = 'Group ID %d %s has been deleted.' % (row.id, row.group_name)
q.delete()
DBSession.flush()
request.session.flash(msg)
return route_list(request)
return dict(row=row, form=form.render())
def test_no_buttons(self):
schema = colander.Schema()
form = deform.Form(schema, buttons=[])
self.view.before(form)
self.assertEqual(
form.buttons,
[],
)
def __init__(self, group, table, obj, dbsession, columns, translate=_):
self.obj = obj
self.table = table
self.relationships = get_relationship(table)
self.dbsession = dbsession
self.js_list = []
self.translate = translate
self.schema = colander.Schema(name=translate(group))
self.build(columns)
def form_generator(dbsession, obj, table, columns_by_group, request):
schema = colander.Schema()
js_list = []
for group, columns in columns_by_group:
gs = GroupShema(group, table, obj, dbsession, columns,
translate=request.localizer.translate)
schema.add(gs.schema)
js_list.extend(gs.js_list)
return Form(schema, request=request), list(set(js_list))
def schema(self):
#Just to make sure
self.hashlist
return colander.Schema(
title=_("Would you like to participate?"),
description=_(
"Clicking request access will grant you access if your email address "
"is allowed by the access policy."
)
)
def view_delete(request):
q = query_id(request)
row = q.first()
a = row.id
x = row.approval_level
if not row:
return id_not_found(request)
if x == 1:
request.session.flash(
'Data tidak dapat dihapus, karena sudah masuk di Menu Approval.',
'error')
return route_list(request)
if x == 2:
request.session.flash(
'Data tidak dapat dihapus, karena sudah disetujui.', 'error')
return route_list(request)
if row.disabled:
request.session.flash(
'Data tidak dapat dihapus, karena sudah masuk di Menu Approval.',
'error')
return route_list(request)
if row.status_dlv:
request.session.flash(
'Data tidak dapat dihapus, karena sudah masuk di Menu Pengiriman Gudang.',
'error')
return route_list(request)
# Seleksi untuk di menu Approval
r = DBSession.query(ProductReqAppr).filter(
ProductReqAppr.product_request_id == a).first()
if r:
request.session.flash(
'Hapus dahulu data rencana yang sudah pernah dibuat di Menu Approval.',
'error')
return route_list(request)
# Seleksi untuk mengecek item
i = DBSession.query(ProductRequestItem).filter(
ProductRequestItem.product_request_id == a).first()
if i:
request.session.flash('Hapus dahulu item produk / barang.', 'error')
return route_list(request)
form = Form(colander.Schema(), buttons=('hapus', 'batal'))
if request.POST:
if 'hapus' in request.POST:
msg = 'Order ID %d sudah dihapus.' % (row.id)
q.delete()
DBSession.flush()
request.session.flash(msg)
return route_list(request)
return dict(row=row, form=form.render())
def view_delete(request):
q = query_id(request)
row = q.first()
if not row:
return id_not_found(request)
if row.status_invoice:
request.session.flash('Data sudah masuk di No Bayar', 'error')
return route_list(request)
if row.arsspds:
form = Form(colander.Schema(), buttons=('cancel', ))
else:
form = Form(colander.Schema(), buttons=('delete', 'cancel'))
if request.POST:
if 'delete' in request.POST:
msg = 'No Bayar ID %d %s sudah dihapus.' % (row.id, row.kode)
q.delete()
DBSession.flush()
request.session.flash(msg)
return route_list(request)
return dict(row=row, form=form.render())
def get_config_schema(keys):
"""
Returns a schema to configure Config objects
:param list keys: The list of keys we want to configure (ui informations
should be provided in the CONFIGURATION_KEYS dict
:results: A colander Schema to configure the given keys
:rtype: object colander Schema
"""
schema = colander.Schema()
mappings = {}
index = 0
for key in keys:
ui_conf = CONFIGURATION_KEYS.get(key, {})
node = get_config_key_schemanode(key, ui_conf)
if "section" in ui_conf: # This element should be shown in a mapping
section_title = ui_conf['section']
section_name = safe_unicode(section_title)
if section_name not in mappings:
mappings[section_name] = mapping = colander.Schema(
title=section_title,
name=section_name,
)
schema.add(mapping)
else:
mapping = mappings[section_name]
mapping.add(node)
else:
schema.insert(index, node)
index += 1
# for mapping in mappings.values():
# schema.add(mapping)
return schema
def view_delete(request):
q = query_id(request)
row = q.first()
if not row:
return id_not_found(request)
form = Form(colander.Schema(), buttons=('delete', 'cancel'))
if request.POST:
if 'delete' in request.POST:
msg = 'Rekon E-PAP ID %d berhasil dihapus.' % (row.id)
q.delete()
DBSession.flush()
request.session.flash(msg)
return route_list(request)
return dict(row=row, form=form.render())
def view_delete(request):
q = query_id(request)
row = q.first()
if not row:
return id_not_found(request)
form = Form(colander.Schema(), buttons=('hapus', 'batal'))
if request.POST:
if 'hapus' in request.POST:
msg = 'Urusan ID %d %s sudah dihapus.' % (row.id, row.nama)
q.delete()
DBSession.flush()
request.session.flash(msg)
return route_list(request)
return dict(row=row, form=form.render())
def delete(self):
name = self.request.GET.get('name')
self.response['group'] = self.groups.get(name)
schema = colander.Schema(title=_(u"Really delete this group?"),
description=self.groups[name]['title'])
schema = schema.bind(context=self.context, request=self.request)
form = deform.Form(schema, buttons=('cancel', 'delete'))
if self.request.method == 'POST':
if 'delete' in self.request.POST:
del self.groups[name]
url = self.request.resource_url(self.context, 'groups')
return HTTPFound(location=url)
self.response['form'] = form.render()
return self.response
def get_company_association_schema():
"""
Return the schema used to associate a user to an existing company
"""
schema = colander.Schema()
schema.add(
CompanySchema(name='companies',
title=u"Entreprise(s)",
widget=deform.widget.SequenceWidget(
add_subitem_text_template=u"Ajouter une entreprise",
min_len=1,
),
description=u"Taper les premières lettres du nom \
d'une entreprise existante"))
return schema
def view_delete(request):
q = query_id(request)
row = q.first()
if not row:
return id_not_found(request)
form = Form(colander.Schema(), buttons=('delete','cancel'))
if request.POST:
if 'delete' in request.POST:
msg = 'User ID %d %s has been deleted.' % (row.id, row.email)
q.delete()
DBSession.flush()
request.session.flash(msg)
return route_list(request)
return dict(row=row,
form=form.render())
def view_delete(request):
q = query_id(request)
row = q.first()
if not row:
return id_not_found(request)
form = Form(colander.Schema(), buttons=('hapus', 'batal'))
if request.POST:
if 'hapus' in request.POST:
msg = 'User ID {user_id} {email} {user_name} berhasil dihapus.'.format(
user_id=row.id, email=row.email, user_name=row.user_name)
q.delete()
DBSession.flush()
request.session.flash(msg)
return route_list(request)
return dict(row=row, form=form.render())
def view_delete(request):
q = query_id(request)
row = q.first()
if not row:
return id_not_found(request)
form = Form(colander.Schema(), buttons=('delete', 'cancel'))
if request.POST:
if 'delete' in request.POST:
msg = 'Group %s Route ID %s sudah dihapus.' % (
row.groups.group_name, row.routes.nama)
q.delete()
DBSession.flush()
request.session.flash(msg)
return route_list(request)
return dict(row=row, form=form.render())
def test_set_value_for_send_immediately_button(self):
add_groups()
add_users()
add_demo_mailing()
self.request.context = Mailing.by_name('welcome_email')
schema = colander.Schema()
form = deform.Form(schema, buttons=['foo', 'bar', 'send_immediately'])
self.view.before(form)
self.assertEqual(form.buttons[0].value, 'foo')
self.assertEqual(form.buttons[1].value, 'bar')
self.assertEqual(
form.buttons[2].value,
'Immediately send mailing "welcome_email" to all 1 recipients '
'without date constraints?')
def view_delete(request):
q = query_id(request)
row = q.first()
if not row:
return id_not_found(request)
form = Form(colander.Schema(), buttons=('delete','cancel'))
if request.POST:
if 'delete' in request.POST:
msg = 'Group ID {id} {name} has been deleted.'.format(
id=row.id, name=row.group_name)
q.delete()
DBSession.flush()
request.session.flash(msg)
return route_list(request)
return dict(row=row,
form=form.render())
def view_delete(self):
request = self.req
id = request.matchdict['id']
q = query_id(request)
row = q.first()
if not row:
return id_not_found(request)
form = Form(colander.Schema(), buttons=('reversal', 'batal'))
if request.POST:
if 'reversal' in request.POST:
msg = 'Pembayaran ID %s senilai %s berhasil dibatalkan.' % (
id, row.jml_sppt_yg_dibayar)
PembayaranSppt.reversal(id)
request.session.flash(msg)
return route_list(request)
return dict(project=self.project, row=row, id=id, form=form.render())
def view_delete(request):
q = query_id(request)
row = q.first()
if not row:
return id_not_found(request)
form = Form(colander.Schema(), buttons=('delete', 'cancel'))
values = {}
if request.POST:
if 'delete' in request.POST:
values['id'] = request.matchdict['id']
msg = 'Rekening ID %s OPD %s sudah di hapus.' % (
row.rekenings.kode, row.units.kode)
row = DBSession.query(UnitRekening).filter(UnitRekening.id==values['id'])\
.delete()
DBSession.flush()
request.session.flash(msg)
return route_list(request)
return dict(row=row, form=form.render())
def view_delete(request):
q = query_id(request)
row = q.first()
id = row.id
x = DBSession.query(Pegawai).filter(Pegawai.user_id == id).first()
if x:
request.session.flash(
'Tidak bisa dihapus, Karena datanya masih ada dipegawai.', 'error')
return route_list(request)
y = DBSession.query(WajibPajak).filter(WajibPajak.user_id == id).first()
if y:
request.session.flash(
'Tidak bisa dihapus, Karena datanya masih ada disubjek bayar.',
'error')
return route_list(request)
z = DBSession.query(UserUnit).filter(UserUnit.user_id == id).first()
if z:
request.session.flash(
'Tidak bisa dihapus, Karena datanya masih ada di User-OPD.',
'error')
return route_list(request)
a = DBSession.query(UserGroup).filter(UserGroup.user_id == id).first()
if a:
request.session.flash(
'Tidak bisa dihapus, Karena datanya masih ada di User-Group.',
'error')
return route_list(request)
if not row:
return id_not_found(request)
form = Form(colander.Schema(), buttons=('delete', 'cancel'))
if request.POST:
if 'delete' in request.POST:
msg = 'User ID %d %s berhasil dihapus.' % (row.id, row.email)
q.delete()
DBSession.flush()
request.session.flash(msg)
return route_list(request)
return dict(row=row, form=form.render())
def view_routes_delete(request):
q = Route.query_id(request.matchdict['id'])
row = q.first()
if not row:
return id_not_found(request)
form = Form(colander.Schema(), buttons=('hapus', 'batal'))
if request.POST:
if 'hapus' in request.POST:
msg = 'Routes ID %d %s sudah dihapus.' % (row.id, row.nama)
try:
q.delete()
DBSession.flush()
except:
msg = 'Routes ID %d %s tidak dapat dihapus.' % (row.id,
row.nama)
request.session.flash(msg)
return routes_list(request)
return dict(row=row, form=form.render())
def view_unit_delete(self):
request = self.request
q = self.query_id()
row = q.first()
if not row:
return self.id_not_found(request)
form = Form(colander.Schema(), buttons=('hapus', 'batal'))
if request.POST:
if 'hapus' in request.POST:
msg = 'unit ID %d %s sudah dihapus.' % (row.id, row.nama)
try:
q.delete()
DBSession.flush()
except:
msg = 'unit ID %d %s tidak dapat dihapus.' % (row.id,
row.nama)
request.session.flash(msg)
return self.route_list()
return dict(row=row, form=form.render())
def view_delete(request):
q = query_id(request)
row = q.first()
if not row:
return id_not_found(request)
if row.jumlah:
request.session.flash('Data tidak dapat dihapus, karena masih mempunyai item.', 'error')
return route_list(request)
form = Form(colander.Schema(), buttons=('delete','cancel'))
if request.POST:
if 'delete' in request.POST:
msg = 'STS ID %d %s sudah dihapus.' % (row.id, row.kode)
q.delete()
DBSession.flush()
request.session.flash(msg)
return route_list(request)
return dict(row=row, form=form.render())
def view_delete(request):
q = query_id(request)
row = q.first()
if not row:
return id_not_found(request)
if row.id==1 and request.user.id>1 :
request.session.flash('User tidak mempunyai hak akses menghapus data user admin', 'error')
return route_list(request)
form = Form(colander.Schema(), buttons=('delete','cancel'))
if request.POST:
if 'delete' in request.POST:
msg = 'User ID %d %s berhasil dihapus.' % (row.id, row.email)
q.delete()
DBSession.flush()
request.session.flash(msg)
return route_list(request)
return dict(row=row,
form=form.render())
def view_delete(request):
q = query_id(request)
row = q.first()
if not row:
return id_not_found(request)
if row.posted:
request.session.flash('Data sudah diposting', 'error')
return route_list(request)
form = Form(colander.Schema(), buttons=('hapus','cancel'))
values= {}
if request.POST:
if 'hapus' in request.POST:
msg = '%s dengan kode %s telah berhasil.' % (request.title, row.kode)
DBSession.query(ARPaymentBphtb).filter(ARPaymentBphtb.id==request.matchdict['id']).delete()
DBSession.flush()
request.session.flash(msg)
return route_list(request)
return dict(row=row,form=form.render())
