[Isis-users] linking tot loans

[Piet De Keyser]

Dear colleagues,

I was working on a database with loans without the copies database: all information about the items is in the database itself (in v100). My PDF buids a table which lists all item numbers; it links to “loans” for each of them in order to display whether the item is on loan and if so, whether to which date. If it is overdue it puts the message in red. If it is not on loan it says “available”. It is nothing new, only a variation to the existing PFT. Maybe someone of you can use it too: here is the code:

if REF->trans(L->trans('TR_P_'v100^a),v1)='P' then
if REF->trans(L->trans('TR_P_'v100^a),v40)<mid(date,0,8) then REF->trans(L->trans('TR_P_'v100^a),|<td><font color="red"><font face=arial size=2>overdue since  |v40*6.2,|/|v40*4.2,|/|v40*0.4|</font></td>|) fi,
               else
               if REF->trans(L->trans('TR_P_'v100^a),v1)='P' then REF->trans(L->trans('TR_P_'v100^a),|<td><font face=arial size=2>on loan till : |v40*6.2,|/|v40*4.2,|/|v40*0.4|</td>| ),else
               '<td><font face=arial size=2>available</td>' fi, fi

Piet de Keyser
Belgium
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20181220/62c576ec/attachment.html>