1 files deleted
8 files modified
| | |
| | | SELECT bp_id, false, false, false, '', '', '', '' FROM business_partner WHERE member_id=10000; |
| | | |
| | | -- |
| | | -- table: billdata |
| | | -- |
| | | INSERT INTO billdata (bp_id) |
| | | SELECT bp_id FROM business_partner WHERE member_id=10000; |
| | | |
| | | -- |
| | | -- Table: inet_addr |
| | | -- |
| | | INSERT INTO inet_addr (inet_addr, description) |
| | |
| | | UPDATE bank_account SET autodebit_op = false WHERE autodebit_op IS NULL; |
| | | ALTER TABLE bank_account ALTER COLUMN autodebit_op SET NOT NULL; |
| | | |
| | | ALTER TABLE basepacket ADD COLUMN article_number integer NOT NULL DEFAULT 1; |
| | | ALTER TABLE business_partner ADD COLUMN free boolean NOT NULL DEFAULT false; |
| | | ALTER TABLE business_partner ADD COLUMN indicator_vat character varying(20) NOT NULL DEFAULT 'GROSS'; |
| | | ALTER TABLE business_partner ADD COLUMN exempt_vat boolean NOT NULL DEFAULT false; |
| | | ALTER TABLE business_partner ADD UNIQUE(bp_id); |
| | | |
| | | DROP TABLE billdata CASCADE; |
| | | |
| | | ALTER TABLE basepacket ADD COLUMN article_number integer NOT NULL DEFAULT 0; |
| | | ALTER TABLE basepacket ALTER COLUMN article_number DROP DEFAULT; |
| | | |
| | | ALTER TABLE component ADD COLUMN article_number integer NOT NULL DEFAULT 1; |
| | | ALTER TABLE component ADD COLUMN article_number integer NOT NULL DEFAULT 0; |
| | | ALTER TABLE component ALTER COLUMN article_number DROP DEFAULT; |
| | | ALTER TABLE component DROP CONSTRAINT ckt_component; |
| | | ALTER TABLE component |
| | | ADD CONSTRAINT ckt_component CHECK ( |
| | | (0 <= min_quantity) AND |
| | | (min_quantity <= default_quantity) AND |
| | | (default_quantity <= max_quantity) AND |
| | | (include_quantity <= default_quantity) AND |
| | | (0 <= include_quantity) AND |
| | | (mod(min_quantity, increment_quantity) = 0) AND |
| | | (mod(max_quantity, increment_quantity) = 0) AND |
| | | (mod(default_quantity, increment_quantity) = 0) AND |
| | | (mod(include_quantity, increment_quantity) = 0) |
| | | ); |
| | | |
| | | ALTER TABLE packet DROP COLUMN order_number; |
| | | ALTER TABLE packet DROP COLUMN webserver_group; |
| | | ALTER TABLE packet ADD COLUMN free boolean NOT NULL DEFAULT false; |
| | | |
| | | ALTER TABLE domain DROP COLUMN domain_status; |
| | | ALTER TABLE domain DROP COLUMN domain_status_changed; |
| | | ALTER TABLE domain DROP COLUMN domain_filed; |
| | | ALTER TABLE domain DROP COLUMN domain_until; |
| | | ALTER TABLE domain DROP COLUMN domain_reminder; |
| | | ALTER TABLE domain DROP COLUMN domain_free; |
| | | ALTER TABLE domain DROP COLUMN domain_template; |
| | | |
| | | CREATE TABLE price_list ( |
| | | id serial PRIMARY KEY, |
| | |
| | | price_list integer REFERENCES price_list(id), |
| | | PRIMARY KEY (customer, price_list) |
| | | ); |
| | | INSERT INTO customer_price_list_mapping (SELECT bp_id, 1 FROM business_partner); |
| | | INSERT INTO customer_price_list_mapping |
| | | (SELECT bp_id, (SELECT id FROM price_list WHERE name LIKE 'Default%') FROM business_partner); |
| | | |
| | | CREATE TABLE price ( |
| | | id serial PRIMARY KEY, |
| | |
| | | vat decimal(4,2) NOT NULL, |
| | | price_list integer REFERENCES price_list(id) |
| | | ); |
| | | INSERT INTO price VALUES (1, 0, 0, 0, 1); |
| | | INSERT INTO price (article_number, price, vat, price_list) |
| | | VALUES (0, 0, 0, (SELECT id FROM price_list WHERE name LIKE 'Default%')); |
| | | |
| | |
| | | DROP TABLE price_list ; |
| | | DROP TABLE bank_account ; |
| | | DROP SEQUENCE bank_account_bank_account_id_seq ; |
| | | DROP TABLE billdata ; |
| | | DROP SEQUENCE billdata_billdata_id_seq ; |
| | | DROP TABLE contact ; |
| | | DROP SEQUENCE contact_contact_id_seq ; |
| | | DROP TABLE database ; |
| | |
| | | CREATE TABLE bank_account ( |
| | | bank_account_id integer DEFAULT nextval(('"bank_account_bank_account_id_seq"'::text)::regclass) NOT NULL, |
| | | bp_id integer NOT NULL, |
| | | autodebit_ga boolean NOT NULL DEFAULT false, |
| | | autodebit_ar boolean NOT NULL DEFAULT false, |
| | | autodebit_op boolean NOT NULL DEFAULT false, |
| | | bank_customer character varying(50) NOT NULL DEFAULT '', |
| | | bank_account character varying(10) NOT NULL DEFAULT '', |
| | | bank_code character varying(8) NOT NULL DEFAULT '', |
| | | bank_name character varying(50) NOT NULL DEFAULT '' |
| | | autodebit_ga boolean NOT NULL, |
| | | autodebit_ar boolean NOT NULL, |
| | | autodebit_op boolean NOT NULL, |
| | | bank_customer character varying(50), |
| | | bank_account character varying(10), |
| | | bank_code character varying(8), |
| | | bank_name character varying(50), |
| | | CONSTRAINT ckt_bank_account CHECK (((((((bank_customer IS NOT NULL) AND (bank_account IS NOT NULL)) AND (bank_code IS NOT NULL)) AND (bank_name IS NOT NULL)) AND (((autodebit_ga = true) OR (autodebit_ar = true)) OR (autodebit_op = true))) OR (((autodebit_ga = false) AND (autodebit_ar = false)) AND (autodebit_op = false)))) |
| | | ); |
| | | |
| | | |
| | |
| | | |
| | | |
| | | -- |
| | | -- Name: billdata; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| | | -- |
| | | |
| | | CREATE TABLE billdata ( |
| | | billdata_id integer DEFAULT nextval(('"billdata_billdata_id_seq"'::text)::regclass) NOT NULL, |
| | | bp_id integer NOT NULL, |
| | | tariff_domain_discount_since date, |
| | | tariff_domain_discount_until date, |
| | | tariff_traffic_discount_since date, |
| | | tariff_traffic_discount_until date, |
| | | tariff_quota_discount_since date, |
| | | tariff_quota_discount_until date, |
| | | tariff_discount_since date, |
| | | tariff_discount_until date |
| | | ); |
| | | |
| | | |
| | | -- |
| | | -- Name: billdata_billdata_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| | | -- |
| | | |
| | | CREATE SEQUENCE billdata_billdata_id_seq |
| | | INCREMENT BY 1 |
| | | NO MAXVALUE |
| | | NO MINVALUE |
| | | CACHE 1; |
| | | |
| | | |
| | | -- |
| | | -- Name: business_partner; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| | | -- |
| | | |
| | |
| | | include_quantity integer NOT NULL, |
| | | admin_only boolean NOT NULL, |
| | | CONSTRAINT ckt_component CHECK ( |
| | | (min_quantity <= max_quantity) AND |
| | | (0 <= min_quantity) AND |
| | | (min_quantity <= default_quantity) AND |
| | | (default_quantity <= max_quantity) AND |
| | | (include_quantity <= max_quantity) AND |
| | | (include_quantity <= default_quantity) AND |
| | | (0 <= include_quantity) AND |
| | | (mod(min_quantity, increment_quantity) = 0) AND |
| | | (mod(max_quantity, increment_quantity) = 0) AND |
| | | (mod(default_quantity, increment_quantity) = 0) AND |
| | | (mod(include_quantity, increment_quantity) = 0) |
| | |
| | | |
| | | |
| | | -- |
| | | -- Name: pk_billdata; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| | | -- |
| | | |
| | | ALTER TABLE ONLY billdata |
| | | ADD CONSTRAINT pk_billdata PRIMARY KEY (billdata_id); |
| | | |
| | | |
| | | -- |
| | | -- Name: pk_business_partner; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| | | -- |
| | | |
| | |
| | | -- |
| | | |
| | | CREATE UNIQUE INDEX basepacket_in_1 ON basepacket USING btree (basepacket_code); |
| | | |
| | | |
| | | -- |
| | | -- Name: billdata_in_1; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| | | -- |
| | | |
| | | CREATE UNIQUE INDEX billdata_in_1 ON billdata USING btree (bp_id); |
| | | |
| | | |
| | | -- |
| | |
| | | |
| | | ALTER TABLE ONLY component |
| | | ADD CONSTRAINT fk_bcomp_bpack FOREIGN KEY (basepacket_id) REFERENCES basepacket(basepacket_id) ON UPDATE RESTRICT ON DELETE RESTRICT; |
| | | |
| | | |
| | | -- |
| | | -- Name: fk_billdata_reference_business; Type: FK CONSTRAINT; Schema: public; Owner: - |
| | | -- |
| | | |
| | | ALTER TABLE ONLY billdata |
| | | ADD CONSTRAINT fk_billdata_reference_business FOREIGN KEY (bp_id) REFERENCES business_partner(bp_id) ON UPDATE RESTRICT ON DELETE RESTRICT; |
| | | |
| | | |
| | | -- |
| | |
| | | @Column(name = "autodebit_op", columnDefinition = "boolean", nullable = false) |
| | | private Boolean autoDebitOP = Boolean.FALSE; |
| | | |
| | | @Column(name = "bank_customer", columnDefinition = "character varying(50)", nullable = false) |
| | | private String bankCustomer = ""; |
| | | @Column(name = "bank_customer", columnDefinition = "character varying(50)") |
| | | private String bankCustomer; |
| | | |
| | | @Column(name = "bank_account", columnDefinition = "character varying(10)", nullable = false) |
| | | private String bankAccount = ""; |
| | | @Column(name = "bank_account", columnDefinition = "character varying(10)") |
| | | private String bankAccount; |
| | | |
| | | @Column(name = "bank_code", columnDefinition = "character varying(8)", nullable = false) |
| | | private String bankCode = ""; |
| | | @Column(name = "bank_code", columnDefinition = "character varying(8)") |
| | | private String bankCode; |
| | | |
| | | @Column(name = "bank_name", columnDefinition = "character varying(50)", nullable = false) |
| | | private String bankName = ""; |
| | | @Column(name = "bank_name", columnDefinition = "character varying(50)") |
| | | private String bankName; |
| | | |
| | | public static String createQueryFromStringKey(String humanKey) { |
| | | return "customer.name = " + humanKey; |
| | |
| | | @OneToOne(fetch = EAGER, cascade = ALL, mappedBy = "customer") |
| | | private BankAccount bankAccount; |
| | | |
| | | @OneToOne(fetch = EAGER, cascade = ALL, mappedBy = "customer") |
| | | private CustomersTariff billData; |
| | | |
| | | @OneToMany(fetch = LAZY, cascade = ALL, mappedBy = "customer") |
| | | @OrderBy("name") |
| | | private Set<Pac> pacs; |
| | |
| | | |
| | | public void setBankAccount(BankAccount bankAccount) { |
| | | this.bankAccount = bankAccount; |
| | | } |
| | | |
| | | public CustomersTariff getBillData() { |
| | | return billData; |
| | | } |
| | | |
| | | public void setBillData(CustomersTariff tariff) { |
| | | this.billData = tariff; |
| | | } |
| | | |
| | | public Set<Pac> getPacs() { |
| | |
| | | bankAccount.setCustomer(newCustomer); |
| | | newCustomer.setBankAccount(bankAccount); |
| | | } |
| | | CustomersTariff billData = newCustomer.getBillData(); |
| | | if (billData == null) { |
| | | billData = new CustomersTariff(newCustomer); |
| | | newCustomer.setBillData(billData); |
| | | } |
| | | GenericModuleImpl helperModule = new GenericModuleImpl(getTransaction()); |
| | | UnixUser custAccount = new UnixUser(); |
| | | custAccount.setComment(TextUtil.replaceUmlautCharacters(custComment)); |
| | |
| | | list.add(new BooleanListValue("includes")); |
| | | list.add(new BooleanListValue("indexes")); |
| | | list.add(new BooleanListValue("multiviews")); |
| | | list.add(new BooleanListValue("php")); |
| | | // list.add(new BooleanListValue("php")); |
| | | return list; |
| | | } |
| | | |