[
https://issues.apache.org/jira/browse/OFBIZ-3894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nicolas Malin updated OFBIZ-3894:
---------------------------------
Attachment: OFBIZ-3894.patch
I Begun the refactoring email handling has scott suggest.
I realized in first step :
* Create management emailTemplateSetting screen on ContentSetup Menu
* Change data model ProductStoreEmailSetting
* Add new Content entity : EmailTplSettingContent and
EmailTplSettingContentType
* Update ProductStoreEmailSetting service and screen.
To migrate data I propose :
* Update data model with new enchancement
* Run SQL UPDATE product_store_email_setting SET email_type_enum_Id =
email_type;
ALTER TABLE product_store_email_setting DROP COLUMN email_type;
Run service to create new emailTemplateSetting and associate to
ProductStoreEmailSetting (not write yet)
-> Run SQL by call entitySqlProcessor :
UPDATE email_template_setting SET body_screen_location = (SELECT
body_screen_location FROM product_store_email_setting WHERE
email_template_setting_id = email_Template_Setting.email_template_setting_id)
&& email_template_setting_id IN (SELECT email_template_setting_id FROM
product_store_email_setting);
UPDATE email_template_setting SET xslfo_attach_screen_location = (SELECT
xslfo_attach_screen_location FROM product_store_email_setting WHERE
email_template_setting_id = email_Template_Setting.email_template_setting_id)
&& email_template_setting_id IN (SELECT email_template_setting_id FROM
product_store_email_setting);
UPDATE email_template_setting SET from_address = (SELECT from_address
FROM product_store_email_setting WHERE email_template_setting_id =
email_Template_Setting.email_template_setting_id) && email_template_setting_id
IN (SELECT email_template_setting_id FROM product_store_email_setting);
UPDATE email_template_setting SET cc_address = (SELECT cc_location FROM
product_store_email_setting WHERE email_template_setting_id =
email_Template_Setting.email_template_setting_id) && email_template_setting_id
IN (SELECT email_template_setting_id FROM product_store_email_setting);
UPDATE email_template_setting SET bcc_address = (SELECT bcc_location FROM
product_store_email_setting WHERE email_template_setting_id =
email_Template_Setting.email_template_setting_id) && email_template_setting_id
IN (SELECT email_template_setting_id FROM product_store_email_setting);
UPDATE email_template_setting SET subject = (SELECT subject FROM
product_store_email_setting WHERE email_template_setting_id =
email_Template_Setting.email_template_setting_id) && email_template_setting_id
IN (SELECT email_template_setting_id FROM product_store_email_setting);
UPDATE email_template_setting SET content_type = (SELECT content_type
FROM product_store_email_setting WHERE email_template_setting_id =
email_Template_Setting.email_template_setting_id) && email_template_setting_id
IN (SELECT email_template_setting_id FROM product_store_email_setting);
ALTER TABLE product_store_email_setting DROP COLUMN body_screen_location;
ALTER TABLE product_store_email_setting DROP COLUMN
xslfo_attach_screen_location;
ALTER TABLE product_store_email_setting DROP COLUMN from_address;
ALTER TABLE product_store_email_setting DROP COLUMN cc_address;
ALTER TABLE product_store_email_setting DROP COLUMN bcc_address;
ALTER TABLE product_store_email_setting DROP COLUMN subject;
ALTER TABLE product_store_email_setting DROP COLUMN content_type;
If the following way it's good I continu with :
* Change all services to use ProducStoreEmailSettingView instead of
ProducStoreEmailSetting OR change sendEmailService with sendEmailFromTemplate
* Add new screen to manage content email
* Add new service to sendEmailFromContent
* Update Content screen to give user possibility to edit template with context
field selection
> Refactor Email handling
> -----------------------
>
> Key: OFBIZ-3894
> URL: https://issues.apache.org/jira/browse/OFBIZ-3894
> Project: OFBiz
> Issue Type: Improvement
> Components: ALL COMPONENTS
> Affects Versions: SVN trunk
> Reporter: BJ Freeman
> Priority: Minor
> Fix For: SVN trunk
>
> Attachments: OFBIZ-3894.patch
>
> Original Estimate: 1,344h
> Remaining Estimate: 1,344h
>
> with the addition of the Website for each component
> 1) create product store for Order entry, or use the B2C product store.
> 2) move the email widgets from ecommerce to order compontent.
> 3) modify the seed data so that Order entry has it own emails from order
> component.this would be to add emails to
> note: as I go through the different items this is turning out to be a bigger
> project than I first anticipated.
> so consider this so far just ideas.
> Maybe break down in to small tasks as I have time to do something.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
