Attachment #111024 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 464-472 sub SendAlerts { Link Here

(-)a/C4/Letters.pm (-2 / +3 lines)
464	letter_code => $letter_code,	464	letter_code => $letter_code,
465	branchcode => $userenv->{branch},	465	branchcode => $userenv->{branch},
466	tables => {	466	tables => {
467	'branches' => $userenv->{branch},	467	'branches' => $userenv->{branch},
468	'aqbooksellers' => $databookseller,	468	'aqbooksellers' => $databookseller,
469	'aqcontacts' => $datacontact,	469	'aqcontacts' => $datacontact,
		470	'aqbasket' => $externalid,
470	},	471	},
471	repeat => $dataorders,	472	repeat => $dataorders,
472	want_librarian => 1,	473	want_librarian => 1,
Lines 750-755 sub _parseletter_sth { Link Here
750	($table eq 'suggestions' ) ? "SELECT * FROM $table WHERE suggestionid = ?" :	751	($table eq 'suggestions' ) ? "SELECT * FROM $table WHERE suggestionid = ?" :
751	($table eq 'aqbooksellers') ? "SELECT * FROM $table WHERE id = ?" :	752	($table eq 'aqbooksellers') ? "SELECT * FROM $table WHERE id = ?" :
752	($table eq 'aqorders' ) ? "SELECT * FROM $table WHERE ordernumber = ?" :	753	($table eq 'aqorders' ) ? "SELECT * FROM $table WHERE ordernumber = ?" :
		754	($table eq 'aqbasket' ) ? "SELECT * FROM $table WHERE basketno = ?" :
753	($table eq 'opac_news' ) ? "SELECT * FROM $table WHERE idnew = ?" :	755	($table eq 'opac_news' ) ? "SELECT * FROM $table WHERE idnew = ?" :
754	($table eq 'article_requests') ? "SELECT * FROM $table WHERE id = ?" :	756	($table eq 'article_requests') ? "SELECT * FROM $table WHERE id = ?" :
755	($table eq 'borrower_modifications') ? "SELECT * FROM $table WHERE verification_token = ?" :	757	($table eq 'borrower_modifications') ? "SELECT * FROM $table WHERE verification_token = ?" :
756	-