Attachment #83617 for bug #5770

View | Details | Raw Unified | Return to bug 5770
Collapse All | Expand All




INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES
('EmailPurchaseSuggestions','KohaAdminEmailAddress','EmailAddressForSuggestions|BranchEmailAddress|KohaAdminEmailAddress','Choose email address that will be sent new purchase suggestions','Choice'),
('EmailAddressForSuggestions','','','If you choose EmailAddressForSuggestions you should enter a valid email address','free');

INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
<p><h4>Suggested by</h4>
 <ul>
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
   <li><<borrowers.cardnumber>></li>
   <li><<borrowers.phone>></li>
   <li><<borrowers.email>></li>
 </ul>
</p>
<p><h4>Item on suggestion</h4>
 <ul>
   <li><b>Library : </b> <<branches.branchname>></li>
   <li><b>Title : </b> <<suggestions.title>></li>
   <li><b>Author : </b> <<suggestions.author>></li>
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
   <li><b>Publication place : </b> <<suggestions.place>></li>
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
   <li><b>Notes : </b> <<suggestions.note>></li>
 </ul>
</p>',1, 'email');

Lines 156-161 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/sysprefs.sql (+2 lines)
156	('ElasticsearchIndexStatus_authorities', '0', 'Authorities index status', NULL, NULL),	156	('ElasticsearchIndexStatus_authorities', '0', 'Authorities index status', NULL, NULL),
157	('ElasticsearchIndexStatus_biblios', '0', 'Biblios index status', NULL, NULL),	157	('ElasticsearchIndexStatus_biblios', '0', 'Biblios index status', NULL, NULL),
158	('emailLibrarianWhenHoldIsPlaced','0',NULL,'If ON, emails the librarian whenever a hold is placed','YesNo'),	158	('emailLibrarianWhenHoldIsPlaced','0',NULL,'If ON, emails the librarian whenever a hold is placed','YesNo'),
		159	('EmailPurchaseSuggestions','KohaAdminEmailAddress','EmailAddressForSuggestions\|BranchEmailAddress\|KohaAdminEmailAddress','Choose email address that will be sent new purchase suggestions','Choice'),
		160	('EmailAddressForSuggestions','','','If you choose EmailAddressForSuggestions you should enter a valid email address','free'),
159	('EnableAdvancedCatalogingEditor','0','','Enable the Rancor advanced cataloging editor','YesNo'),	161	('EnableAdvancedCatalogingEditor','0','','Enable the Rancor advanced cataloging editor','YesNo'),
160	('EnableBorrowerFiles','0',NULL,'If enabled, allows librarians to upload and attach arbitrary files to a borrower record.','YesNo'),	162	('EnableBorrowerFiles','0',NULL,'If enabled, allows librarians to upload and attach arbitrary files to a borrower record.','YesNo'),
161	('EnableOpacSearchHistory','1','YesNo','Enable or disable opac search history',''),	163	('EnableOpacSearchHistory','1','YesNo','Enable or disable opac search history',''),




              class: email
            - "(This is the default From: address for emails unless there is one for the particular library, and is referred to when an internal error occurs.)"
        -
            - "Choose email address that will be sent new purchase suggestions : "
            - pref:   EmailPurchaseSuggestions
              default: KohaAdminEmailAddress
              choices:
                  EmailAddressForSuggestions: EmailAddressForSuggestions
                  BranchEmailAddress: email address of branch
                  KohaAdminEmailAddress: KohaAdminEmailAddress
            - "If you choose EmailAddressForSuggestions you should enter a valid email address : "
            - pref: EmailAddressForSuggestions
              class: email
        -
            - "Email address to be set as the replyto in emails: "
            - pref: ReplytoDefault
              class: email
- 

Return to bug 5770

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_5770.sql (+30 lines)
	1	INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES
	2	('EmailPurchaseSuggestions','KohaAdminEmailAddress','EmailAddressForSuggestions\|BranchEmailAddress\|KohaAdminEmailAddress','Choose email address that will be sent new purchase suggestions','Choice'),
	3	('EmailAddressForSuggestions','','','If you choose EmailAddressForSuggestions you should enter a valid email address','free');
	4
	5	INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
	6	VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
	7	<p><h4>Suggested by</h4>
	8	<ul>
	9	<li><<borrowers.firstname>> <<borrowers.surname>></li>
	10	<li><<borrowers.cardnumber>></li>
	11	<li><<borrowers.phone>></li>
	12	<li><<borrowers.email>></li>
	13	</ul>
	14	</p>
	15	<p><h4>Item on suggestion</h4>
	16	<ul>
	17	<li><b>Library : </b> <<branches.branchname>></li>
	18	<li><b>Title : </b> <<suggestions.title>></li>
	19	<li><b>Author : </b> <<suggestions.author>></li>
	20	<li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
	21	<li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
	22	<li><b>Publisher : </b> <<suggestions.publishercode>></li>
	23	<li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
	24	<li><b>Publication place : </b> <<suggestions.place>></li>
	25	<li><b>Quantity : </b> <<suggestions.quantity>></li>
	26	<li><b>Item type : </b> <<suggestions.itemtype>></li>
	27	<li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
	28	<li><b>Notes : </b> <<suggestions.note>></li>
	29	</ul>
	30	</p>',1, 'email');

Lines 7-12 Administration: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref (-1 / +11 lines)
7	class: email	7	class: email
8	- "(This is the default From: address for emails unless there is one for the particular library, and is referred to when an internal error occurs.)"	8	- "(This is the default From: address for emails unless there is one for the particular library, and is referred to when an internal error occurs.)"
9	-	9	-
		10	- "Choose email address that will be sent new purchase suggestions : "
		11	- pref: EmailPurchaseSuggestions
		12	default: KohaAdminEmailAddress
		13	choices:
		14	EmailAddressForSuggestions: EmailAddressForSuggestions
		15	BranchEmailAddress: email address of branch
		16	KohaAdminEmailAddress: KohaAdminEmailAddress
		17	- "If you choose EmailAddressForSuggestions you should enter a valid email address : "
		18	- pref: EmailAddressForSuggestions
		19	class: email
		20	-
10	- "Email address to be set as the replyto in emails: "	21	- "Email address to be set as the replyto in emails: "
11	- pref: ReplytoDefault	22	- pref: ReplytoDefault
12	class: email	23	class: email
13	-