From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Sun, 12 Jun 2011 18:20:24 +0000 (+0200)
Subject: djelat
X-Git-Url: http://git.rot13.org/?p=ferlib2koha.git;a=commitdiff_plain;h=443589584ad22e1f4c71047c4be31d3268f4c5cd

djelat
---

diff --git a/ferlib2koha.pl b/ferlib2koha.pl
index a55b3da..4cca07a 100755
--- a/ferlib2koha.pl
+++ b/ferlib2koha.pl
@@ -63,6 +63,28 @@ select
 from studk
 };
 
+$sql = qq{
+select
+  'D' as categorycode,
+  'SRE' as branchcode,
+  sif_djel as cardnumber,
+  ime_djel as firstname,
+  prez_djel as surname,
+  ozn_titula as title, -- FIXME 
+--  sif_orgjed (REF orgjed) as B_address,
+--  sif_strsp_djel as ??,
+  tel_djel as phonepro,
+  dat_prekid_ro as dateexpiry,
+--  tel_poduz as ??,
+  fax_poduz as fax,
+  ozn_drzava as country,
+  post_ozn as zipcode,
+  post_ozn as city,
+  adr_stan as address,
+  tel_stan as phone
+from djelat
+};
+
 my $sth = $f->prepare($sql);
 $sth->execute;