Advertisement
Guest User

Untitled

a guest
Jan 21st, 2016
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.64 KB | None | 0 0
  1. vim /usr/share/koha/intranet/cgi-bin/admin/smart-rules.pl
  2.  
  3. my $params = {
  4. branchcode => $br,
  5. categorycode => $bor,
  6. itemtype => $itemtype,
  7. fine => $fine,
  8. finedays => $finedays,
  9. maxsuspensiondays => $maxsuspensiondays,
  10. firstremind => $firstremind,
  11. chargeperiod => $chargeperiod,
  12. chargeperiod_charge_at => $chargeperiod_charge_at, <= no
  13. maxissueqty => $maxissueqty,
  14. maxonsiteissueqty => $maxonsiteissueqty,
  15. renewalsallowed => $renewalsallowed,
  16. renewalperiod => $renewalperiod,
  17. norenewalbefore => $norenewalbefore,
  18. auto_renew => $auto_renew,
  19. reservesallowed => $reservesallowed,
  20. issuelength => $issuelength,
  21. lengthunit => $lengthunit,
  22. hardduedate => $hardduedate,
  23. hardduedatecompare => $hardduedatecompare,
  24. rentaldiscount => $rentaldiscount,
  25. onshelfholds => $onshelfholds,
  26. opacitemholds => $opacitemholds,
  27. overduefinescap => $overduefinescap,
  28. };
  29.  
  30.  
  31. ####### MySQL
  32. describe issuingrules;
  33. +--------------------+---------------+------+-----+---------+-------+
  34. | Field | Type | Null | Key | Default | Extra |
  35. +--------------------+---------------+------+-----+---------+-------+
  36. | categorycode | varchar(10) | NO | PRI | | |
  37. | itemtype | varchar(10) | NO | PRI | | |
  38. | restrictedtype | tinyint(1) | YES | | NULL | |
  39. | rentaldiscount | decimal(28,6) | YES | | NULL | |
  40. | reservecharge | decimal(28,6) | YES | | NULL | |
  41. | fine | decimal(28,6) | YES | | NULL | |
  42. | finedays | int(4) | YES | | NULL | |
  43. | maxsuspensiondays | int(11) | YES | | NULL | |
  44. | firstremind | int(11) | YES | | NULL | |
  45. | chargeperiod | int(11) | YES | | NULL | |
  46. | accountsent | int(11) | YES | | NULL | |
  47. | chargename | varchar(100) | YES | | NULL | |
  48. | maxissueqty | int(4) | YES | | NULL | |
  49. | issuelength | int(4) | YES | | NULL | |
  50. | lengthunit | varchar(10) | YES | | days | |
  51. | hardduedate | date | YES | | NULL | |
  52. | hardduedatecompare | tinyint(4) | NO | | 0 | |
  53. | renewalsallowed | smallint(6) | NO | | 0 | |
  54. | renewalperiod | int(4) | YES | | NULL | |
  55. | norenewalbefore | int(4) | YES | | NULL | |
  56. | auto_renew | tinyint(1) | YES | | 0 | |
  57. | reservesallowed | smallint(6) | NO | | 0 | |
  58. | branchcode | varchar(10) | NO | PRI | | |
  59. | max_fine | decimal(28,6) | YES | | NULL | |
  60. | holdallowed | tinyint(1) | YES | | 2 | |
  61. | max_holds | int(4) | YES | | NULL | |
  62. | overduefinescap | decimal(28,6) | YES | | NULL | |
  63. | onshelfholds | tinyint(1) | NO | | 0 | |
  64. | opacitemholds | char(1) | NO | | N | |
  65. +--------------------+---------------+------+-----+---------+-------+
  66. 29 rows in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement