[Koha] issuingrules from 19.11 to 20.05

[vinod mishra]

Hello

I am sorry this may not be related to Koha but since I am helpless need
suggestions on how to replace the highlighted codings with the new
*"circulation_rules"*

if (commandStatus) {
query = "select * from *issuingrules* where categorycode='*' or
categorycode=? and branchcode='*' or branchcode=? ";
ptst = conn.prepareStatement(query);
ptst.setString(1, Borrower.categorycode);
ptst.setString(2, Borrower.branchcode);

for (rs = ptst.executeQuery(); rs.next(); status = true) {
*IssuingRules.renewalsallowed* = rs.getInt("*renewalsallowed*");
*IssuingRules.maxissueqty* = rs.getInt("*maxissueqty*");
*IssuingRules.issuelength* = rs.getInt("*issuelength*");
*IssuingRules.firstremind* = rs.getInt("*firstremind*");
}

With Regards,

Vinod Kumar Mishra,
Assistant Librarian,
Biju Patnaik Central Library (BPCL),
NIT Rourkela,
Sundergadh-769008,
Odisha,
India.
Mob:91+9439420860
URL: http://vinod.itshelp.co.in/
ORCID ID: http://orcid.org/0000-0003-4666-7874
Scopus ID: 57223138343

*"Spiritual relationship is far more precious than physical. Physical
relationship divorced from spiritual is body without soul" -- Mahatma
Gandhi*


On Wed, Aug 3, 2022 at 6:35 PM Caroline Cyr La Rose <
caroline.cyr-la-rose at inlibro.com> wrote:

> Hi Vinod,
>
> If you look at the existing rules in circulation_rules, you'll notice the
> rule name is in the rule_name column and the value is in rule_value.
>
> If you need to insert via SQL, you can do something like
>
> INSERT INTO circulation_rules (branchcode, categorycode, itemtype,
> rule_name, rule_value) VALUES ("BRANCHCODE", "CATEGORYCODE", "ITEMTYPE",
> "issuelength", "21");
>
> I would suggest doing it via the administration interface (Administration
> > Circulation and fines rules) however, just because there are so many
> different rules. I'm not sure what the consequences are if only a few rules
> are filled in.
>
> Regards,
>
> Caroline
> On 2022-08-03 01:17, vinod mishra wrote:
>
> Hello Rose
>
> Actualy i wish to incorporate new codes/columns in place of following in
> existing RFID middleware:
>
> issuelength
> maxissueqty
> renewalsallowed
>
> Can anyone help which new columns / code can be substituted for?
>
>
>
> On Tue, 2 Aug, 2022, 19:42 Caroline Cyr La Rose, <
> caroline.cyr-la-rose at inlibro.com> wrote:
>
>> Hi Vinod,
>>
>> This table was replaced by circulation_rules. The structure is quite
>> different, as you'll notice.
>>
>> Caroline
>>
>> On 2022-08-02 01:34, vinod mishra wrote:
>> > Hello
>> >
>> > Can anyone help to know "issuingrules" table contents moved to which
>> table
>> > from Version 20.05? as it was there up to 19.11 and what tables columns
>> > could be used in place of issuingrules if similar does not exist?
>> >
>> > With Regards,
>> >
>> > Vinod Kumar Mishra,
>> > Assistant Librarian,
>> > Biju Patnaik Central Library (BPCL),
>> > NIT Rourkela,
>> > Sundergadh-769008,
>> > Odisha,
>> > India.
>> > Mob:91+9439420860
>> > URL:http://vinod.itshelp.co.in/
>> > ORCID ID:http://orcid.org/0000-0003-4666-7874
>> > Scopus ID: 57223138343
>> >
>> > *"Spiritual relationship is far more precious than physical. Physical
>> > relationship divorced from spiritual is body without soul" -- Mahatma
>> > Gandhi*
>> > _______________________________________________
>> >
>> > Koha mailing listhttp://koha-community.org
>> > Koha at lists.katipo.co.nz
>> > Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
>> Caroline Cyr La Rose, M.L.I.S.
>> Librarian | Product Manager
>>
>> Phone: 1-833-465-4276, ext. 221
>> Caroline.Cyr-La-Rose at inLibro.com <mailto:caroline.cyr-la-rose at inLibro.com
>> >
>>
>> INLiBRO | Document Technologies Specialists | www.inLibro.com
>> <http://www.inLibro.com>
>> _______________________________________________
>>
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> --
> Caroline Cyr La Rose, M.S.I.
> Bibliothécaire | Responsable de produit
>
> Tél. : 1-833-465-4276, poste 221
> Caroline.Cyr-La-Rose at inLibro.com <caroline.cyr-la-rose at inLibro.com>
> INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com
>