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.isb@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.hafen@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.isb@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.hafen@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.isb@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-devel@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