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())