/[health_html]/inc/pgKnjiznica-adresar.php
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /inc/pgKnjiznica-adresar.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.1 by ravilov, Thu Aug 30 16:35:36 2001 UTC revision 1.2 by ravilov, Mon Sep 3 15:52:16 2001 UTC
# Line 1  Line 1 
1  <?php  <?php
2          include_once("inc/conn.php");          include_once("inc/conn.php");
3          include_once("inc/search.php");          include_once("inc/search.php");
4            function MyCmp1($a, $b) { return MyCompare($a["naziv"], $b["naziv"]); }
5            function MyCmp2($a, $b) { return MyCompare($a["l"], $b["l"]); }
6          $fields = array(          $fields = array(
7                  "naziv" => array("dbname" => "naziv", "caption" => "Naziv ustanove"),                  "naziv" => array("dbname" => "naziv", "caption" => "Naziv ustanove"),
8                  "zupanija" => array("dbname" => "zupanija", "caption" => "®upanija"),                  "zupanija" => array("dbname" => "zupanija", "caption" => "®upanija"),
# Line 10  Line 12 
12                  "adresa" => array("dbname" => "adresa", "caption" => "Adresa"),                  "adresa" => array("dbname" => "adresa", "caption" => "Adresa"),
13                  "telefon" => array("dbname" => "telefon", "caption" => "Telefon"),                  "telefon" => array("dbname" => "telefon", "caption" => "Telefon"),
14          );          );
15          list($srch, $qry_1, $qry_2) = Search($fields, array("naziv", "zupanija", "opcina", "posta", "mjesto", "adresa", "telefon"), "naziv");          list($srch, $qry_1, $qry_2) = Search($fields, array("naziv", "zupanija", "opcina", "posta", "mjesto", "adresa", "telefon"), array(), "naziv");
16          # Win1250 -> ISO8859-2          # Win1250 -> ISO8859-2
17          if ($qry_1) $qry_1 = strtr($qry_1, "ŠÐÈÆŽšðèæž", "©ÐÈÆ®¹ðèæ¾");          if ($qry_1) $qry_1 = strtr($qry_1, "ŠÐÈÆŽšðèæž", "©ÐÈÆ®¹ðèæ¾");
18          if ($qry_2) $qry_2 = strtr($qry_2, "ŠÐÈÆŽšðèæž", "©ÐÈÆ®¹ðèæ¾");          if ($qry_2) $qry_2 = strtr($qry_2, "ŠÐÈÆŽšðèæž", "©ÐÈÆ®¹ðèæ¾");
# Line 24  Line 26 
26                  $uvjet = array();                  $uvjet = array();
27                  if ($index && $index != 1) {                  if ($index && $index != 1) {
28                          if ($index == '@') for ($i = 0; $i < count($letters); $i++) array_push($uvjet, "($prvo_slovo <> '".$letters[$i]."')");                          if ($index == '@') for ($i = 0; $i < count($letters); $i++) array_push($uvjet, "($prvo_slovo <> '".$letters[$i]."')");
29                                  else array_push($uvjet, "($prvo_slovo = '".strtoupper($index)."')");                                  else array_push($uvjet, "($prvo_slovo = '".MyUpper($index)."')");
30                  }                  }
31                  if ($qry_1) array_push($uvjet, "($qry_1)");                  if ($qry_1) array_push($uvjet, "($qry_1)");
32                  $uvjet = implode(" AND ", $uvjet);                  $uvjet = implode(" AND ", $uvjet);
# Line 40  Line 42 
42                          list($id2, $fl, $naziv, $mjesto) = $row;                          list($id2, $fl, $naziv, $mjesto) = $row;
43                          if (!isset($staro_slovo)) $staro_slovo = $fl;                          if (!isset($staro_slovo)) $staro_slovo = $fl;
44                          if (!($qry_1 || $qry_2) && $staro_slovo != $fl) {                          if (!($qry_1 || $qry_2) && $staro_slovo != $fl) {
45                                    usort($ustanove, "MyCmp1");
46                                  array_push($slova, array("l" => $staro_slovo, "ustanove" => $ustanove));                                  array_push($slova, array("l" => $staro_slovo, "ustanove" => $ustanove));
47                                  $staro_slovo = $fl;                                  $staro_slovo = $fl;
48                                  $ustanove = array();                                  $ustanove = array();
# Line 47  Line 50 
50                          array_push($ustanove, array("id" => $id2, "naziv" => MyEscape($naziv), "mjesto" => MyEscape($mjesto)));                          array_push($ustanove, array("id" => $id2, "naziv" => MyEscape($naziv), "mjesto" => MyEscape($mjesto)));
51                  }                  }
52                  $sth->finish();                  $sth->finish();
53                  if (isset($staro_slovo)) array_push($slova, array("l" => $staro_slovo, "ustanove" => $ustanove));                  if (isset($staro_slovo)) {
54                            usort($ustanove, "MyCmp1");
55                            array_push($slova, array("l" => $staro_slovo, "ustanove" => $ustanove));
56                    }
57                    usort($slova, "MyCmp2");
58                  $records = 0;                  $records = 0;
59                  for ($i = 0; $i < count($slova); $i++) $records += count($slova[$i]["ustanove"]);                  for ($i = 0; $i < count($slova); $i++) $records += count($slova[$i]["ustanove"]);
60                  $tpl->assign("records", $records);                  $tpl->assign("records", $records);
# Line 59  Line 66 
66                  $sth = $dbh->prepare($sql);                  $sth = $dbh->prepare($sql);
67                  if (!$sth) error("Cannot prepare query: \"$sql\"");                  if (!$sth) error("Cannot prepare query: \"$sql\"");
68                  if (!$sth->execute()) error("Cannot execute query: \"$sql\"");                  if (!$sth->execute()) error("Cannot execute query: \"$sql\"");
69                  while ($row = $sth->fetchrow_array()) {                  $row = $sth->fetchrow_array();
                         list($naziv, $zup, $posta, $adr, $mj, $tel, $opc, $www, $email) = $row;  
                         $tpl->assign("naziv", MyEscape($naziv));  
                         $tpl->assign("adresa", MyEscape($adr));  
                         $tpl->assign("posta", MyEscape($posta));  
                         $tpl->assign("mjesto", MyEscape($mj));  
                         $tpl->assign("zupanija", MyEscape($zup));  
                         $tpl->assign("telefon", MyEscape($tel));  
                         $tpl->assign("opcina", MyEscape($opc));  
                         $tpl->assign("www", MyEscape($www));  
                         $tpl->assign("email", MyEscape($email));  
                 }  
70                  $sth->finish();                  $sth->finish();
71                    list($naziv, $zup, $posta, $adr, $mj, $tel, $opc, $www, $email) = $row;
72                    $tpl->assign("naziv", MyEscape($naziv));
73                    $tpl->assign("adresa", MyEscape($adr));
74                    $tpl->assign("posta", MyEscape($posta));
75                    $tpl->assign("mjesto", MyEscape($mj));
76                    $tpl->assign("zupanija", MyEscape($zup));
77                    $tpl->assign("telefon", MyEscape($tel));
78                    $tpl->assign("opcina", MyEscape($opc));
79                    $tpl->assign("www", MyEscape($www));
80                    $tpl->assign("email", MyEscape($email));
81          }          }
82          $tpl->assign("letters", $letters);          $tpl->assign("letters", $letters);
83          $tpl->assign("ID", $id);          $tpl->assign("ID", $id);
Legend:
Removed from v.1.1  
changed lines
  Added in v.1.2
  ViewVC Help
Powered by ViewVC 1.1.26