Attachment #112039 for bug #21898

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




            letter_code => $letter_code,
            branchcode => $userenv->{branch},
            tables => {
                'branches'      => $userenv->{branch},
                'aqbooksellers' => $databookseller,
                'aqcontacts'    => $datacontact,
                'aqbasket'     => $externalid,
            },
            repeat => $dataorders,
            want_librarian => 1,

    ($table eq 'suggestions'  )    ? "SELECT * FROM $table WHERE   suggestionid = ?"                                  :
    ($table eq 'aqbooksellers')    ? "SELECT * FROM $table WHERE             id = ?"                                  :
    ($table eq 'aqorders'     )    ? "SELECT * FROM $table WHERE    ordernumber = ?"                                  :
    ($table eq 'aqbasket'     )    ? "SELECT * FROM $table WHERE       basketno = ?"                                  :
    ($table eq 'opac_news'    )    ? "SELECT * FROM $table WHERE          idnew = ?"                                  :
    ($table eq 'article_requests') ? "SELECT * FROM $table WHERE             id = ?"                                  :
    ($table eq 'borrower_modifications') ? "SELECT * FROM $table WHERE verification_token = ?" :
- 

Return to bug 21898

Lines 469-477 sub SendAlerts { Link Here

(-)a/C4/Letters.pm (-2 / +3 lines)
469	letter_code => $letter_code,	469	letter_code => $letter_code,
470	branchcode => $userenv->{branch},	470	branchcode => $userenv->{branch},
471	tables => {	471	tables => {
472	'branches' => $userenv->{branch},	472	'branches' => $userenv->{branch},
473	'aqbooksellers' => $databookseller,	473	'aqbooksellers' => $databookseller,
474	'aqcontacts' => $datacontact,	474	'aqcontacts' => $datacontact,
		475	'aqbasket' => $externalid,
475	},	476	},
476	repeat => $dataorders,	477	repeat => $dataorders,
477	want_librarian => 1,	478	want_librarian => 1,
Lines 762-767 sub _parseletter_sth { Link Here
762	($table eq 'suggestions' ) ? "SELECT * FROM $table WHERE suggestionid = ?" :	763	($table eq 'suggestions' ) ? "SELECT * FROM $table WHERE suggestionid = ?" :
763	($table eq 'aqbooksellers') ? "SELECT * FROM $table WHERE id = ?" :	764	($table eq 'aqbooksellers') ? "SELECT * FROM $table WHERE id = ?" :
764	($table eq 'aqorders' ) ? "SELECT * FROM $table WHERE ordernumber = ?" :	765	($table eq 'aqorders' ) ? "SELECT * FROM $table WHERE ordernumber = ?" :
		766	($table eq 'aqbasket' ) ? "SELECT * FROM $table WHERE basketno = ?" :
765	($table eq 'opac_news' ) ? "SELECT * FROM $table WHERE idnew = ?" :	767	($table eq 'opac_news' ) ? "SELECT * FROM $table WHERE idnew = ?" :
766	($table eq 'article_requests') ? "SELECT * FROM $table WHERE id = ?" :	768	($table eq 'article_requests') ? "SELECT * FROM $table WHERE id = ?" :
767	($table eq 'borrower_modifications') ? "SELECT * FROM $table WHERE verification_token = ?" :	769	($table eq 'borrower_modifications') ? "SELECT * FROM $table WHERE verification_token = ?" :
768	-