From 443589584ad22e1f4c71047c4be31d3268f4c5cd Mon Sep 17 00:00:00 2001
From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Sun, 12 Jun 2011 20:20:24 +0200
Subject: [PATCH] djelat

---
 ferlib2koha.pl | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)

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;
 
-- 
2.20.1