Re: Coupon Start and Expiry Dates

for vm 1.1, joomla 1.0.15

the language file is different as values are all held in an array, and i've changed some of the logic around as i was working on it. BACKUP first.

Files to edit:
ps_coupon.php
I'm attaching my full file. As far as I can remember there are no other mods to this file from the standard install but I could be wrong.

coupon.coupon_form.php
I'm attaching my full file. As far as I know the only other mod to this file creates a random coupon code for you to use if you want.

Database Edits:
jos_vm_coupons - add following columns:
coupon_start_date
coupon_expiry_date
Code:

CREATE TABLE `jos_vm_coupons` (
`coupon_id` int(16) NOT NULL auto_increment,
`coupon_code` varchar(32) NOT NULL default '',
`percent_or_total` enum('percent','total') NOT NULL default 'percent',
`coupon_type` enum('gift','permanent') NOT NULL default 'gift',
`coupon_value` decimal(12,2) NOT NULL default '0.00',
`coupon_start_date` datetime default NULL,
`coupon_expiry_date` datetime default NULL,
PRIMARY KEY (`coupon_id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1 COMMENT='Used to store coupon codes'

Language file edits:
I changed PHP_SHOP_COUPON_CODE_INVALID TO PHPSHOP_COUPON_CODE_NOT_FOUND as I felt it was a better name as I needed to add:

Files to edit:
ps_coupon.php
I'm attaching my full file. As far as I can remember there are no other mods to this file from the standard install but I could be wrong.

coupon.coupon_form.php
I'm attaching my full file. As far as I know the only other mod to this file creates a random coupon code for you to use if you want.

Database Edits:
jos_vm_coupons - add following columns:
coupon_start_date
coupon_expiry_date
Code:

CREATE TABLE `jos_vm_coupons` (
`coupon_id` int(16) NOT NULL auto_increment,
`coupon_code` varchar(32) NOT NULL default '',
`percent_or_total` enum('percent','total') NOT NULL default 'percent',
`coupon_type` enum('gift','permanent') NOT NULL default 'gift',
`coupon_value` decimal(12,2) NOT NULL default '0.00',
`coupon_start_date` datetime default NULL,
`coupon_expiry_date` datetime default NULL,
PRIMARY KEY (`coupon_id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1 COMMENT='Used to store coupon codes'

Language file edits:
I changed PHP_SHOP_COUPON_CODE_INVALID TO PHPSHOP_COUPON_CODE_NOT_FOUND as I felt it was a better name as I needed to add:

PHPSHOP_COUPON_CODE_INVALID
PHPSHOP_COUPON_START
PHPSHOP_COUPON_EXPIRY

Code:

'PHPSHOP_COUPON_START' => 'Coupon Start Date',
'PHPSHOP_COUPON_EXPIRY' => 'Coupon Expiry Date',
'PHPSHOP_COUPON_CODE_INVALID' => 'Coupon code out of date. Please try an alternative.',
'PHPSHOP_COUPON_CODE_NOT FOUND' => 'Coupon code not found. Please try again.',

Notes:
You will need to edit all existing coupons in order for them to be valid otherwise if they do not have a start or expiry date they will appear as invalid

Attached Files
Files are attached as .txt files to allow upload. They just need renaming to .php to work.