I have completed the patron category description and it is correctly
showing in pdf file from patron card creator.
anyone that needs help for patron category description is not showing in
pdf please do the following.
In *C4/Patroncards/Lib.pm *file.
search for line "*$get_branch = 1 if grep{$_ eq 'branchcode'} @fields;*"
after, add following lines
my $get_patroncategory = 0;
$get_patroncategory = 1 if grep{$_ eq 'categorycode'} @fields;
search for line "*return $borrower_attributes;*" before this line, add
following lines
if ($get_patroncategory) {
$query = "SELECT description FROM categories WHERE categorycode =
?";
$sth = C4::Context->dbh->prepare($query);
$sth->execute($borrower_attributes->{'categorycode'});
if ($sth->err) {
warn sprintf('Database returned the following error: %s',
$sth->errstr);
return 1;
}
$borrower_attributes->{'categorycode'} =
$sth->fetchrow_hashref()->{'description'};
}
Thanks for the help Michael, it really helps me. At least I do not have to
track this file.
On Fri, Sep 22, 2023 at 10:31 AM Zahid Iqbal <zahidiqbal....@gmail.com>
wrote:
> Thanks Michael that will be very helpful. I will look into the code
> and get back to you. For now i am working on picture uploading (restrict
> image not more than 4KB and not more then 150 Height Width dimension) so
> the database does not get heavy.
>
> On Thu, Sep 21, 2023 at 9:38 PM Michael Hafen <michael.ha...@washk12.org>
> wrote:
>
>> If you are looking at the code, look at C4/Patroncards/Lib.pm in the
>> get_borrower_attributes() function. That's where the branchcode to
>> branchname conversion is handled, I figure that would be the place to do a
>> categorycode to category description conversion.
>>
>> On Thu, Sep 21, 2023 at 12:17 AM Zahid Iqbal <zahidiqbal....@gmail.com>
>> wrote:
>>
>>> thanks for the response.
>>> i have checked the branchcode, it is displaying correctly in patron card
>>> as you told. 👍
>>> but i cannot find any solution for categorycode. I will still look into
>>> code. Maybe I will find a solution for that.
>>>
>>> On Wed, Sep 20, 2023 at 9:08 PM Michael Hafen <michael.ha...@washk12.org>
>>> wrote:
>>>
>>>> I have a layout using "<sort2>" in the text box for field 2. Looks
>>>> like the code will change "<branchcode>" into the library name. No such
>>>> luck in current code for patron category though.
>>>>
>>>> On Tue, Sep 19, 2023 at 11:17 PM Zahid Iqbal <zahidiqbal....@gmail.com>
>>>> wrote:
>>>>
>>>>> Hi, In koha 22.11 can someone guide to print branchname and patron
>>>>> category description on pdf file for patron card creator
>>>>>
>>>>> 1. print branchname not branchcode
>>>>> 2. print patron-category-description not categorycode
>>>>>
>>>>>
>>>>> what are the values i have to type in text box for field1 and field2
>>>>> in patron card layout for printing branchname and
>>>>> patron-category-description?
>>>>>
>>>>> i am stuck with this problem and cannot find any other solution
>>>>> Can anyone suggest that i have to change the code or is there any
>>>>> other way that it can be solved?
>>>>> I am not an expert in coding, any help will be appreciated.
>>>>>
>>>>> Best Regards
>>>>> --
>>>>> *Zahid Iqbal*
>>>>> _______________________________________________
>>>>> Koha-devel mailing list
>>>>> koha-de...@lists.koha-community.org
>>>>> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>>>>> website : https://www.koha-community.org/
>>>>> git : https://git.koha-community.org/
>>>>> bugs : https://bugs.koha-community.org/
>>>>>
>>>>
>>>>
>>>> --
>>>> Michael Hafen
>>>> Washington County School District Technology Department
>>>> Systems Analyst
>>>>
>>>>
>>>
>>> --
>>> *Zahid*
>>>
>>
>>
>> --
>> Michael Hafen
>> Washington County School District Technology Department
>> Systems Analyst
>>
>>
>
> --
> *Zahid*
>
--
*Zahid Iqbal*
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
