/[health_html]/inc/pgKnjiznica2-vjesnik.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

Contents of /inc/pgKnjiznica2-vjesnik.php

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.1 - (show annotations)
Fri Sep 28 23:34:37 2001 UTC (22 years, 6 months ago) by ravilov
Branch: MAIN
Added some new pages to PLIVAmed. Some bugfixes.

1 <?php
2 if (!$index) $index = 1;
3 include("inc/conn.php");
4 include_once("inc/search.php");
5 $fields = array(
6 "broj" => array("dbname" => "broj", "caption" => "Broj èasopisa"),
7 "godina" => array("dbname" => "godina", "caption" => "Godina izdanja"),
8 "naslov" => array("dbname" => "naslov", "caption" => "Naslov èlanka"),
9 "vrsta" => array("dbname" => "vj_vrsta.naziv", "caption" => "Vrsta èlanka"),
10 "autor" => array("dbname" => "autor", "caption" => "Ime autora"),
11 "adresa" => array("dbname" => "adresa", "caption" => "Adresa autora"),
12 "sazetak" => array("dbname" => "sazetak", "caption" => "Sa¾etak èlanka"),
13 "tekst" => array("dbname" => "tekst", "caption" => "Tekst èlanka"),
14 "ref" => array("dbname" => "referenca", "caption" => "Referenca"),
15 "rijeci" => array("dbname" => "keywords", "caption" => "Kljuène rijeèi")
16 );
17 if (!$id) {
18 list($srch, $qry_1, $qry_2) = Search($fields, array("broj", "godina", "naslov", "rijeci", "vrsta", "autor", "adresa", "sazetak", "tekst"), array(), "naslov");
19 # Win1250 -> ISO8859-2
20 if ($qry_1) $qry_1 = strtr($qry_1, "ŠÐÈƎšðèæž", "©ÐÈÆ®¹ðèæ¾");
21 if ($qry_2) $qry_2 = strtr($qry_2, "ŠÐÈƎšðèæž", "©ÐÈÆ®¹ðèæ¾");
22 $tpl->assign("index", $index);
23 $tpl->assign("srch", ($qry_1 || $qry_2) ? true : false);
24 $tpl->assign("SEARCH", $srch);
25 }
26 $letters = Slova();
27 if (!$id && ($index || ($qry_1 || $qry_2))) {
28 $prvo_slovo = "UPPER(SUBSTRING(autor || ': ' || naslov FROM 1 FOR 1))";
29 $sql = "SELECT vj_id, $prvo_slovo AS prvo_slovo, autor, naslov FROM vjesnik, vj_vrsta";
30 $uvjet = array("(vjesnik.vrsta = vj_vrsta.vrsta_id)");
31 if ($index && $index != 1) {
32 if ($index == '@') for ($i = 0; $i < count($letters); $i++) array_push($uvjet, "($prvo_slovo <> '".$letters[$i]."')");
33 else array_push($uvjet, "($prvo_slovo = '".MyUpper($index)."')");
34 }
35 if ($qry_1) array_push($uvjet, "($qry_1)");
36 $uvjet = implode(" AND ", $uvjet);
37 if ($uvjet) $sql .= " WHERE $uvjet";
38 $sql .= " ORDER BY prvo_slovo, autor, naslov";
39 $sth = $dbh->prepare($sql);
40 if (!$sth) error("Cannot prepare query: \"$sql\"");
41 if (!$sth->execute()) error("Cannot execute query: \"$sql\"");
42 $slova = array();
43 $clanci = array();
44 unset($staro_slovo);
45 while ($row = $sth->fetchrow_array()) {
46 list($id2, $fl, $autor, $naslov) = $row;
47 if (!isset($staro_slovo)) $staro_slovo = $fl;
48 if (!($qry_1 || $qry_2) && $staro_slovo != $fl) {
49 usort($clanci, "MyCmp1");
50 array_push($slova, array("l" => $staro_slovo, "clanci" => $clanci));
51 $staro_slovo = $fl;
52 $clanci = array();
53 }
54 array_push($clanci, array("id" => $id2, "naslov" => MyEscape($naslov), "autor" => MyEscape($autor)));
55 }
56 $sth->finish();
57 if (count($clanci) > 0) {
58 usort($clanci, "MyCmp1");
59 array_push($slova, array("l" => $staro_slovo, "clanci" => $clanci));
60 }
61 usort($slova, "MyCmp2");
62 $records = 0;
63 for ($i = 0; $i < count($slova); $i++) $records += count($slova[$i]["clanci"]);
64 $tpl->assign("records", $records);
65 $tpl->assign("slova", $slova);
66 $tpl->assign("stype", $stype);
67 }
68 if ($id) {
69 $sql = "SELECT broj, godina, naslov, keywords, vj_vrsta.naziv, autor, adresa, sazetak, tekst, referenca FROM vjesnik, vj_vrsta WHERE (vj_id = $id) AND (vjesnik.vrsta = vj_vrsta.vrsta_id)";
70 $sth = $dbh->prepare($sql);
71 if (!$sth) error("Cannot prepare query: \"$sql\"");
72 if (!$sth->execute()) error("Cannot execute query: \"$sql\"");
73 $row = $sth->fetchrow_array();
74 $sth->finish();
75 list($broj, $godina, $naslov, $keywords, $vrsta, $autor, $adresa, $sazetak, $tekst, $ref) = $row;
76 $tpl->assign("broj", MyEscape($broj));
77 $tpl->assign("godina", MyEscape($godina));
78 $tpl->assign("naslov", MyEscape($naslov));
79 $tpl->assign("keywords", MyEscape($keywords));
80 $tpl->assign("vrsta", MyEscape($vrsta));
81 $tpl->assign("referenca", MyEscape($ref));
82 $tpl->assign("autor", MyEscape($autor));
83 $tpl->assign("adresa", MyEscape($adresa));
84 $tpl->assign("sazetak", ParseNewline(MyEscape($sazetak), false));
85 $tpl->assign("tekst", ParseNewline(MyEscape($tekst), false));
86 }
87 $tpl->assign("letters", $letters);
88 $tpl->assign("ID", $id);
89 $dbh->disconnect();
90 array_push($PATH, "LIJEÈNIÈKI VJESNIK");
91 ?>

  ViewVC Help
Powered by ViewVC 1.1.26