Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- vim /usr/share/koha/intranet/cgi-bin/admin/smart-rules.pl
- my $params = {
- branchcode => $br,
- categorycode => $bor,
- itemtype => $itemtype,
- fine => $fine,
- finedays => $finedays,
- maxsuspensiondays => $maxsuspensiondays,
- firstremind => $firstremind,
- chargeperiod => $chargeperiod,
- chargeperiod_charge_at => $chargeperiod_charge_at, <= no
- maxissueqty => $maxissueqty,
- maxonsiteissueqty => $maxonsiteissueqty,
- renewalsallowed => $renewalsallowed,
- renewalperiod => $renewalperiod,
- norenewalbefore => $norenewalbefore,
- auto_renew => $auto_renew,
- reservesallowed => $reservesallowed,
- issuelength => $issuelength,
- lengthunit => $lengthunit,
- hardduedate => $hardduedate,
- hardduedatecompare => $hardduedatecompare,
- rentaldiscount => $rentaldiscount,
- onshelfholds => $onshelfholds,
- opacitemholds => $opacitemholds,
- overduefinescap => $overduefinescap,
- };
- ####### MySQL
- describe issuingrules;
- +--------------------+---------------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +--------------------+---------------+------+-----+---------+-------+
- | categorycode | varchar(10) | NO | PRI | | |
- | itemtype | varchar(10) | NO | PRI | | |
- | restrictedtype | tinyint(1) | YES | | NULL | |
- | rentaldiscount | decimal(28,6) | YES | | NULL | |
- | reservecharge | decimal(28,6) | YES | | NULL | |
- | fine | decimal(28,6) | YES | | NULL | |
- | finedays | int(4) | YES | | NULL | |
- | maxsuspensiondays | int(11) | YES | | NULL | |
- | firstremind | int(11) | YES | | NULL | |
- | chargeperiod | int(11) | YES | | NULL | |
- | accountsent | int(11) | YES | | NULL | |
- | chargename | varchar(100) | YES | | NULL | |
- | maxissueqty | int(4) | YES | | NULL | |
- | issuelength | int(4) | YES | | NULL | |
- | lengthunit | varchar(10) | YES | | days | |
- | hardduedate | date | YES | | NULL | |
- | hardduedatecompare | tinyint(4) | NO | | 0 | |
- | renewalsallowed | smallint(6) | NO | | 0 | |
- | renewalperiod | int(4) | YES | | NULL | |
- | norenewalbefore | int(4) | YES | | NULL | |
- | auto_renew | tinyint(1) | YES | | 0 | |
- | reservesallowed | smallint(6) | NO | | 0 | |
- | branchcode | varchar(10) | NO | PRI | | |
- | max_fine | decimal(28,6) | YES | | NULL | |
- | holdallowed | tinyint(1) | YES | | 2 | |
- | max_holds | int(4) | YES | | NULL | |
- | overduefinescap | decimal(28,6) | YES | | NULL | |
- | onshelfholds | tinyint(1) | NO | | 0 | |
- | opacitemholds | char(1) | NO | | N | |
- +--------------------+---------------+------+-----+---------+-------+
- 29 rows in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement