For those who might be interested:
Description:
this patch adds the possibility to choose to which customer a subscription applies and to define for how long it will apply
Changes:added 2 pages in A2Billing_UI
updated subscription cron service
Installation:apply patch
for mysql
Code:
CREATE TABLE cc_card_subscription (
id BIGINT NOT NULL AUTO_INCREMENT,
id_cc_card BIGINT ,
id_subscription_fee INT,
startdate TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
stopdate TIMESTAMP,
description MEDIUMTEXT,
PRIMARY KEY (id)
)ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;
ALTER TABLE cc_card DROP id_subscription_fee;
for pgsql:
Code:
CREATE TABLE cc_card_subscription (
id BIGSERIAL NOT NULL,
id_cc_card BIGINT DEFAULT 0 NOT NULL,
id_subscription_fee BIGINT DEFAULT 0 NOT NULL,
startdate TIMESTAMP WITHOUT TIME ZONE DEFAULT NOW(),
stopdate TIMESTAMP WITHOUT TIME ZONE,
description TEXT,
PRIMARY KEY (id)
);
ALTER TABLE ONLY cc_card_subscription
ADD CONSTRAINT cc_card_subscription_pkey PRIMARY KEY (id);
ALTER TABLE cc_card DROP id_subscription_fee;
Limits:I haven't tested it with pgsql
I haven't programmed pro-rate and in advance billing yet