Release Notes - faisalthaheem/denovo-voucher-script GitHub Wiki

Release notes for 4.6

[CE] Optimization: Many bug fixes.
[CE] Added: Site specific email addresses.
[EE] Bug Fix: Merchant name was not shown in case Click origination was merchant based cashback.
[CE] Added: CMS - modified date/time is now shown.
[CE] AddeD: CMS - Layout selection for the page.
[CE] Added: CMS - Code Mirror for prettier HTML content editing.
[CE] Bug Fix: CMS - Content is saved at page creation.
[CE] Enhancement: CMS - Multiple sites can now have pages with similar link names.
[CE] Bug Fix: CMS - Security fix, administrative views only accessible by authorized user.
[CE] Optimization: CMS - Query optimizations.
[CE] Bug fix: Incorrect COD count on merchants by category page.

        Recreate view: vwbrowse, vwcategoriesmerchantscodcounts

	ALTER TABLE
		merchants ADD COLUMN cbtype ENUM(
			'fixed',
			'percentage'
		) NOT NULL DEFAULT 'fixed' AFTER modified,
		ADD COLUMN cbvalue DECIMAL(
			10,
			2
		) NOT NULL DEFAULT 0.0 AFTER cbtype;
	
	ALTER TABLE
		cods ADD COLUMN cbtype ENUM(
			'fixed',
			'percentage'
		) NOT NULL DEFAULT 'fixed' AFTER tag,
		ADD COLUMN cbvalue DECIMAL(
			10,
			2
		) NOT NULL DEFAULT 0.0 AFTER cbtype;
	
	ALTER TABLE
		sysconfigurations ADD COLUMN editable TINYINT NOT NULL DEFAULT 0 AFTER dataval;
	
	Recreate view Vwbrowse;
	
	ALTER TABLE
		sites ADD COLUMN emailnoreply VARCHAR(255) NULL AFTER ctr,
		ADD COLUMN emailinfo VARCHAR(255) NULL AFTER emailnoreply,
		ADD COLUMN emailcontact VARCHAR(255) NULL AFTER emailinfo;
	
	ALTER TABLE
		pages ADD COLUMN layout VARCHAR(512) NOT NULL DEFAULT 'default' AFTER pagecontent,
		ADD COLUMN modified DATETIME NULL AFTER created;
	
	UPDATE
		pages
	SET
		modified = created;
	
	ALTER TABLE
		pages ADD UNIQUE INDEX unique_page_site(
			site_id ASC,
			linknae(255) ASC
		);

Release notes for 4.5

[CE] recreate view Vwbrowse;
[CE] Optimization: Segregated Coupons and Vouchers as was earlier.
[CE] Bug Fix: Vwbrowse::getTopCODsDataForIndexPage grouped by CODID to eliminate duplicate rows.
[CE] Bug Fix: Vwbrowse::afterFind - added handling for count queries, singular results.
[CE] Bug Fix: Vwbrowse - corrected joins.
[CE] Optimization: Backoffice login.
[CE] Added: Masked affiliate urls for codes, offers etc with intimation to user they are being redirected..

[CE] Removed: Facebook authentication, will be added again in future in a better way..

[CE] Optimizations: View counts now posted on page load asynchronously.
[CE] Optimizations: Page render times (DOM Content loaded), improved by 500% (from 16+ seconds to 3-4 seconds) - non page content related requests now take < 1s.
[CE] Added: View caching.

Release notes for 4.4

[PE] Added: Coupons can now be linked to locations defined for their merchants, these are then shown on local offers page.
[PE] Added: Local offers page moved from merchants to pages controller.
[PE] Added: Clustered local offers support added. Quick preview now shows offer address as well.
[CE] Revised: Minimized comments in stored procedures.
[PE] Added: Full urls to vouchers with each location they are linked to.
[CE] Bug Fix: Fixed min/max and default selected date on voucher creaton/edit.
[CE] Bug Fix: Added a visitor user to the users table to track users not logged in.
[CE] Added: Latest jQuery and JqueryUI. Moved COD validations to models where they belong.
[CE] Added: Tag support for CODs.
[CE] Added: vwbrowse - revised view with optimized query for achieving certain tasks, gradually all redundant views will be eliminated in favor of this.
[CE] Updated: CakePHP 1.3.15
[CE] Recreate views vwcodssitesmerchants

ALTER TABLE
	`cods_locations` CHANGE COLUMN `cod_id` `cod_id` INT(11) NOT NULL AFTER `id`;

ALTER TABLE
	`cods` ADD COLUMN `tag` VARCHAR(255) NULL AFTER `generic_print_3`,
	ADD INDEX `index_tag`(
		`tag` ASC
	);

INSERT
	INTO
		`sysconfigurations`(
			`datakey`,
			`dataval`,
			`created`
		)
	VALUES(
		'CODS-TAGS',
		'UNAVAILABLE',
		'2012-05-24 16:34:00'
	);

Release notes for 4.3

revised query sytnax for linking of categories/merchants/cods to sites. It now uses replace to avoid inserting duplicate rows.

Removed: linkcategorysite procedure and added the script to category model

Bug Fix: categories, merchants and vouchers are now ordered alphabetically in back office.
Bug Fix: Removed duplication of categories arising due to merging when creating merchants in back office.

Removed: Routine deleteVoucher, merged into code.
Removed: Routine deleteLocation, merged into code.
Removed: Routine deleteMerchant, merged into code.
Removed: Routine deleteUser, merged into code.

Bug Fix: When adding merchants, removed merged categories.
Bug Fix: When editing merchants, valid categories are now listed.
Added: Multiple Languages now supported.

ALTER TABLE  `cods_sites` ADD UNIQUE (
`cod_id` ,
`site_id`
)

ALTER TABLE  `categories_sites` ADD UNIQUE (
`category_id` ,
`site_id`
)

ALTER TABLE  `merchants_sites` ADD UNIQUE (
`merchant_id` ,
`site_id`
)

Release notes for 4.2

Added: generic text fields 1,2 and 3 for print voucher templates to cods
Added: generic merchant address1, address2, phone number1, phone number2, phone number3 fields
create vwcodssitesmerchants and all views
Optimization: Meta Titles as defined in merchant management are now used instead of dynamically generated generic titles.
Optimization: Searching for Merchants and Codes are now done through GET request changing address bar addresses for linking.
Bug Fix: iCodesUS and iCodesUK plugins problems
Optimization: removed countCODs that was being used on backoffice to improve performance
Added: Option to delete pages
Bug Fix: vwsitesmerchantscodcounts showed cods count which included expired cods.
Optimized: vwcategoriesmerchantscodcounts
Optimized: Vwcategoriesbrowse
Added: Meta title, keywords and description (metatitle, metadesc, metakws TEXT) added to page management
Bug Fix: Codes added same day would not appear on merchant's detail page though were visible on new stuff page.. fixed.
Optimization: Merchant index by category is now sorted by merchant name and then number of vouchers each has
Optimization: Model::vwsitemerchantscodcounts.php Parameterized limit parameter in methods Formatted, added indent to the list of tabbed browse in document
Optimization: Introduced optional randomized row selection in Vwsitesmerchantscodcounts::getTopMerchantsForIndexPage
Added: generic text fields 1,2 and 3 for print voucher templates to cods
Added: generic merchant address1, address2, phone number1, phone number2, phone number3 fields

ALTER TABLE `cods` ADD COLUMN `generic_print_1` TEXT NULL  AFTER `custom_cod_img_url` , ADD COLUMN `generic_print_2` TEXT NULL  AFTER `generic_print_1` , ADD COLUMN `generic_print_3` TEXT NULL  AFTER `generic_print_2` ;
ALTER TABLE `merchants` ADD COLUMN `address1` TEXT NULL  AFTER `metatitle` , ADD COLUMN `address2` TEXT NULL  AFTER `address1` , ADD COLUMN `phone1` VARCHAR(45) NULL  AFTER `address2` , ADD COLUMN `phone2` VARCHAR(45) NULL  AFTER `phone1` , ADD COLUMN `phone3` VARCHAR(45) NULL  AFTER `phone2` ;