This coupon engine/module is intended to work in concert with an existing web 2.0 SN site, providing vendor members of the site access to an interface to create/modify coupons that they would like to offer to site visitors. Included is a facility to support redemption tracking and the choice for the vendor to include a unique id - which would be included within the body of the coupon - possibly either appended to the barcode, or in a separate barcode, or in plain text. Popup tooltips of some sort should be used to explain any options that need it.
## Deliverables
A (pdf) rudimentary requirements spec is attached. It contains rough screenshots, etc. Our final design is not complete, but the coupon designs displayed are 'fixed' - and we do want to see those executed in html/css. You can 'rough in' the primary and secondary nav and logo as we've done in the layouts. The primary content area should be fully developed and functional.
Uploading and storage of logos should be handled. These logos should be retrieved dynamically for display within the coupons.
Colors used on current site include:
#869eff, #304cb5, #871903
for text: black and #555
This should run in a LAMP5 environment. If you're going to use an application framework, Symfony (1.2.4) utilizing Propel would be preferred. Bids utilizing Symfony will be reviewed first.
The attached pdf also contains a database schema with existing tables. It will need to be enhanced and extended to support this project.
Additional database table for managing associated file resources:
<pre>
CREATE TABLE `file` (
`fileid` int(11) NOT NULL auto_increment,
`isactive` tinyint(1) default NULL,
`filename` tinytext,
`pathname` tinytext,
`title` tinytext,
`descr` mediumtext,
`isfor` tinytext,
`forid` int(11) default NULL,
`isprimary` tinyint(1) default NULL,
`keywords` text,
`geolat` double default NULL,
`geolong` double default NULL,
`startdate` date default NULL,
`enddate` date default NULL,
`stamp` datetime default NULL,
`ownerid` int(11) default NULL,
`radius` float default NULL,
`height` int(11) default NULL,
`width` int(11) default NULL,
PRIMARY KEY (`fileid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=990 ;
--
-- Dumping data for table `file`
--
INSERT INTO `file` VALUES
(9, -1, '[login to view URL]', '/files', 'Free Hamburger & Drink', '', 'vendor', 6, 0, 'Coupon', 0, 0, '2007-09-01', '2007-11-01', NULL, NULL, NULL, NULL, NULL),
(223, -1, '[login to view URL]', NULL, '[login to view URL]', '', 'group', 77, 0, '', 29.977619, -90.092337, NULL, NULL, '2008-01-10 22:02:14', NULL, NULL, NULL, NULL),
(285, -1, 'cedar crest [login to view URL]', NULL, 'cedar crest [login to view URL]', '', 'grouppic', 82, 0, '', 35.897714, -86.395817, NULL, NULL, '2008-01-30 11:12:54', NULL, NULL, NULL, NULL),
(123, -1, '[login to view URL]', '/files', '[login to view URL]', '', 'profilepic', 76, 0, '', 35.954582, -86.221354, NULL, NULL, '2007-11-22 11:47:44', NULL, NULL, NULL, NULL),
(117, -1, '2-01(1).jpg', '/files', '2-01(1).jpg', '', 'profilepic', 100, 0, '', 36.340744, -86.77007, NULL, NULL, '2007-11-22 01:48:29', NULL, NULL, NULL, NULL);
</pre>