1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
|
<?php
/* OpenDb - Open Media Lending Database
Copyright (C) 2001,2002 by Jason Pell
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
*/
include_once("./functions/database.php");
include_once("./functions/logging.php");
include_once("./functions/utils.php");
include_once("./functions/item_type.php");
function is_exists_item_type_group_rltshp($s_item_type_group, $s_item_type = NULL)
{
$query = "SELECT 'x' FROM s_item_type_group_rltshp ".
"WHERE s_item_type_group = '$s_item_type_group' ";
if(strlen($s_item_type)>0)
{
$query .= " AND s_item_type = '$s_item_type'";
}
$result = run_opendb_query($query);
if($result && mysql_num_rows($result)>0)
{
mysql_free_result($result);
return TRUE;
}
//else
return FALSE;
}
function fetch_item_type_group_rs($system_ind = NULL)
{
$query = "SELECT s_item_type_group ".
"FROM s_item_type_group ";
if(strcasecmp($system_ind,'Y')===0 || strcasecmp($system_ind,'N')===0)
$query .= "WHERE system_ind = '".strtoupper($system_ind)."'";
$query .= " ORDER BY s_item_type_group";
$result = run_opendb_query($query);
if($result && mysql_num_rows($result)>0)
return $result;
else
return FALSE;
}
function fetch_item_type_group_r($s_item_type_group)
{
if(strlen($s_item_type_group)>0)
{
$s_item_type_group = strtoupper($s_item_type_group);
$query = "SELECT s_item_type_group, description, system_ind ".
"FROM s_item_type_group ".
"WHERE s_item_type_group = '$s_item_type_group'";
$result = run_opendb_query($query);
if($result && mysql_num_rows($result)>0)
{
$found = mysql_fetch_array($result, MYSQL_ASSOC);
mysql_free_result($result);
return $found;
}
}
//else
return FALSE;
}
function fetch_item_type_groups_for_item_type_r($s_item_type, $system_ind = NULL)
{
$query = "SELECT DISTINCT sitg.s_item_type_group ".
"FROM s_item_type_group sitg, s_item_type_group_rltshp sitgr ".
"WHERE sitg.s_item_type_group = sitgr.s_item_type_group AND ".
"sitgr.s_item_type = '".$s_item_type."'";
if(strcasecmp($system_ind,'Y')===0 || strcasecmp($system_ind,'N')===0)
$query .= " AND sitg.system_ind = '".strtoupper($system_ind)."'";
$query .= " ORDER BY sitg.s_item_type_group";
$result = run_opendb_query($query);
if($result && mysql_num_rows($result)>0)
{
$item_type_group_rs = NULL;
while($item_type_group_r = mysql_fetch_array($result, MYSQL_ASSOC))
$item_type_group_rs[] = $item_type_group_r['s_item_type_group'];
return $item_type_group_rs;
}
else
{
return FALSE;
}
}
function fetch_item_types_for_group_r($s_item_type_group)
{
$query = "SELECT sit.s_item_type, sit.order_no ".
"FROM s_item_type sit, s_item_type_group_rltshp sitgr ".
"WHERE sit.s_item_type = sitgr.s_item_type AND sitgr.s_item_type_group = '".$s_item_type_group."' ";
$query .= "ORDER BY sit.order_no, sit.s_item_type";
$result = run_opendb_query($query);
if($result && mysql_num_rows($result)>0)
{
$item_type_rs = NULL;
while($item_type_r = mysql_fetch_array($result, MYSQL_ASSOC))
$item_type_rs[] = $item_type_r['s_item_type'];
return $item_type_rs;
}
else
return FALSE;
}
?>
|
