/[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

Annotation of /inc/pgKnjiznica-adresar.php

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.2 - (hide annotations)
Mon Sep 3 15:52:16 2001 UTC (22 years, 6 months ago) by ravilov
Branch: MAIN
Changes since 1.1: +21 -15 lines
Made the menu on the left into images. More bugfixes.

1 ravilov 1.1 <?php
2     include_once("inc/conn.php");
3     include_once("inc/search.php");
4 ravilov 1.2 function MyCmp1($a, $b) { return MyCompare($a["naziv"], $b["naziv"]); }
5     function MyCmp2($a, $b) { return MyCompare($a["l"], $b["l"]); }
6 ravilov 1.1 $fields = array(
7     "naziv" => array("dbname" => "naziv", "caption" => "Naziv ustanove"),
8     "zupanija" => array("dbname" => "zupanija", "caption" => "®upanija"),
9     "opcina" => array("dbname" => "opcina", "caption" => "Opæina"),
10     "posta" => array("dbname" => "posta", "caption" => "Po¹tanski broj"),
11     "mjesto" => array("dbname" => "mjesto", "caption" => "Mjesto"),
12     "adresa" => array("dbname" => "adresa", "caption" => "Adresa"),
13     "telefon" => array("dbname" => "telefon", "caption" => "Telefon"),
14     );
15 ravilov 1.2 list($srch, $qry_1, $qry_2) = Search($fields, array("naziv", "zupanija", "opcina", "posta", "mjesto", "adresa", "telefon"), array(), "naziv");
16 ravilov 1.1 # Win1250 -> ISO8859-2
17     if ($qry_1) $qry_1 = strtr($qry_1, "ŠÐÈƎšðèæž", "©ÐÈÆ®¹ðèæ¾");
18     if ($qry_2) $qry_2 = strtr($qry_2, "ŠÐÈƎšðèæž", "©ÐÈÆ®¹ðèæ¾");
19     $tpl->assign("index", $index);
20     $tpl->assign("srch", ($qry_1 || $qry_2) ? true : false);
21     $tpl->assign("SEARCH", $srch);
22     $letters = Slova();
23     if (!$id && ($index || ($qry_1 || $qry_2))) {
24     $prvo_slovo = "UPPER(SUBSTRING(naziv FROM 1 FOR 1))";
25     $sql = "SELECT ustanova_id, $prvo_slovo AS prvo_slovo, naziv, mjesto FROM ustanove";
26     $uvjet = array();
27     if ($index && $index != 1) {
28     if ($index == '@') for ($i = 0; $i < count($letters); $i++) array_push($uvjet, "($prvo_slovo <> '".$letters[$i]."')");
29 ravilov 1.2 else array_push($uvjet, "($prvo_slovo = '".MyUpper($index)."')");
30 ravilov 1.1 }
31     if ($qry_1) array_push($uvjet, "($qry_1)");
32     $uvjet = implode(" AND ", $uvjet);
33     if ($uvjet) $sql .= " WHERE $uvjet";
34     $sql .= " ORDER BY prvo_slovo, naziv";
35     $sth = $dbh->prepare($sql);
36     if (!$sth) error("Cannot prepare query: \"$sql\"");
37     if (!$sth->execute()) error("Cannot execute query: \"$sql\"");
38     $slova = array();
39     $ustanove = array();
40     unset($staro_slovo);
41     while ($row = $sth->fetchrow_array()) {
42     list($id2, $fl, $naziv, $mjesto) = $row;
43     if (!isset($staro_slovo)) $staro_slovo = $fl;
44     if (!($qry_1 || $qry_2) && $staro_slovo != $fl) {
45 ravilov 1.2 usort($ustanove, "MyCmp1");
46 ravilov 1.1 array_push($slova, array("l" => $staro_slovo, "ustanove" => $ustanove));
47     $staro_slovo = $fl;
48     $ustanove = array();
49     }
50     array_push($ustanove, array("id" => $id2, "naziv" => MyEscape($naziv), "mjesto" => MyEscape($mjesto)));
51     }
52     $sth->finish();
53 ravilov 1.2 if (isset($staro_slovo)) {
54     usort($ustanove, "MyCmp1");
55     array_push($slova, array("l" => $staro_slovo, "ustanove" => $ustanove));
56     }
57     usort($slova, "MyCmp2");
58 ravilov 1.1 $records = 0;
59     for ($i = 0; $i < count($slova); $i++) $records += count($slova[$i]["ustanove"]);
60     $tpl->assign("records", $records);
61     $tpl->assign("slova", $slova);
62     $tpl->assign("stype", $stype);
63     }
64     if ($id) {
65     $sql = "SELECT naziv, zupanija, posta, adresa, mjesto, telefon, opcina, www, email FROM ustanove WHERE (ustanova_id = $id)";
66     $sth = $dbh->prepare($sql);
67     if (!$sth) error("Cannot prepare query: \"$sql\"");
68     if (!$sth->execute()) error("Cannot execute query: \"$sql\"");
69 ravilov 1.2 $row = $sth->fetchrow_array();
70 ravilov 1.1 $sth->finish();
71 ravilov 1.2 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 ravilov 1.1 }
82     $tpl->assign("letters", $letters);
83     $tpl->assign("ID", $id);
84     $dbh->disconnect();
85     ?>

  ViewVC Help
Powered by ViewVC 1.1.26