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
136
137
138
139
|
<?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/status_type.php");
/*
* Fetch a complete list of item records, which have a matching
* item instance, for the specified owner_id.
*/
function fetch_export_item_rs($s_item_type, $item_id, $owner_id)
{
global $HTTP_SESSION_VARS;
$query = "SELECT DISTINCT i.id as item_id, i.title, i.category, i.s_item_type ".
"FROM user u, item i, item_instance ii, s_status_type sst ".
"WHERE u.user_id = ii.owner_id AND sst.s_status_type = ii.s_status_type AND i.id = ii.item_id ";
if(strlen($owner_id)>0)
$query .= "AND ii.owner_id = '$owner_id' AND i.parent_id IS NULL ";
else
$query .= "AND i.parent_id IS NULL ";
// can only export items for active users.
$query .= "AND u.active_ind = 'Y' ";
// Restrict certain status types, to specified user types.
$user_type_r = get_min_user_type_r($HTTP_SESSION_VARS['user_type']);
if(is_not_empty_array($user_type_r))
{
$query .= "AND ( ii.owner_id = '".$HTTP_SESSION_VARS['user_id']."' OR ".
" LENGTH(IFNULL(sst.min_display_user_type,'')) = 0 OR ".
" sst.min_display_user_type IN(".format_sql_in_clause($user_type_r).") ) ";
}
if(strlen($s_item_type)>0)
$query .= "AND i.s_item_type = '$s_item_type'";
if(strlen($item_id)>0)
$query .= "AND i.id = '$item_id' ";
$result = run_opendb_query($query);
if($result && mysql_num_rows($result)>0)
return $result;
else
return FALSE;
}
/*
* Return a list of records owned by the specified $owner_id
* AND visible to the current user.
*/
function fetch_export_item_instance_rs($s_item_type, $owner_id)
{
global $HTTP_SESSION_VARS;
$query = "SELECT i.id as item_id, ii.instance_no, i.parent_id, i.title, i.category, i.s_item_type, ii.owner_id, ii.borrow_duration, ii.s_status_type, ii.status_comment ".
"FROM user u, item i, item_instance ii, s_status_type sst ".
"WHERE u.user_id = ii.owner_id AND sst.s_status_type = ii.s_status_type AND i.id = ii.item_id ";
if(strlen($s_item_type)>0)
$query .= "AND i.s_item_type = '$s_item_type'";
// can only export items for active users.
$query .= "AND u.active_ind = 'Y' ";
// Restrict certain status types, to specified user types.
$user_type_r = get_min_user_type_r($HTTP_SESSION_VARS['user_type']);
if(is_not_empty_array($user_type_r))
{
$query .= " AND ( ii.owner_id = '".$HTTP_SESSION_VARS['user_id']."' OR ".
" LENGTH(IFNULL(sst.min_display_user_type,'')) = 0 OR ".
" sst.min_display_user_type IN(".format_sql_in_clause($user_type_r).") ) ";
}
if(strlen($owner_id)>0)
$query .= " AND ii.owner_id = '$owner_id' ";
$query .= "ORDER by i.id, ii.instance_no";
$result = run_opendb_query($query);
if($result && mysql_num_rows($result)>0)
return $result;
else
return FALSE;
}
function is_export_plugin($plugin)
{
if(strlen($plugin)>0 && file_exists('./export/'.$plugin.'.php'))
return TRUE;
else
return FALSE;
}
function get_display_export_type($type)
{
return str_replace('_', ' ', $type);
}
/**
Generate a list of export plugins
Returns an array of the following format:
*/
function get_export_r()
{
$handle=opendir('./export');
while ($file = readdir($handle))
{
// Ensure valid plugin name.
if ( !preg_match("/^\./",$file) && preg_match("/(.*).php$/",$file,$regs))
{
$export[] = $regs[1];
}
}
closedir($handle);
if(is_array($export) && count($export)>0)
return $export;
else // empty array as last resort.
return array();
}
?>
|
