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
<?php
/**
* CompassDBHandler
* $Id: CompassDBHandler.inc
* @author wanggb
* @access public
* @package jp.fishow.handler
*/
class CompassDBHandler {
/**
* 一覧を返す。
*/
public static function getList($class_name, $table_name, $w_param, $orderkey = null, $direction = "ASC", $offset = null, $limit = null) {
$db = CompassDBManager::getInstance();
$result = $db->doSelect($table_name, $w_param, $orderkey, $direction, $offset, $limit);
$objs = array();
if (count($result) > 0) {
ErrorLogger::doOutput($result, 0,"XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXresult");
foreach ($result as $row) {
$tmp = new $class_name($row);
array_push($objs, $tmp);
unset($tmp);
}
}
return $objs;
}
/**
* IDを指定して特定クラスを取得します。
*/
public static function getById($class_name, $table_name, $id, $option_param = null) {
$db = CompassDBManager::getInstance();
if (is_array($option_param)) {
$w_param = $option_param;
} else {
$w_param = array();
}
$w_param["id"] = $id;
$result = $db->doSelect($table_name, $w_param);
if (count($result) > 0) {
return new $class_name($result[0]);
}
return null;
}
/**
* OrderNoを指定して特定クラスを取得します。
*/
public static function getByOrder($class_name, $table_name, $order_no, $option_param = null) {
$db = CompassDBManager::getInstance();
if (is_array($option_param)) {
$w_param = $option_param;
} else {
$w_param = array();
}
$w_param["order_no"] = $order_no;
$result = $db->doSelect($table_name, $w_param);
if (count($result) > 0) {
return new $class_name($result[0]);
}
return null;
}
/**
* extract_codeを指定して特定クラスを取得します。
*/
public static function getByExtcode($class_name, $table_name, $extract_code, $schedule_id,$option_param = null) {
$db = CompassDBManager::getInstance();
if (is_array($option_param)) {
$w_param = $option_param;
} else {
$w_param = array();
}
$w_param["extract_code"] = $extract_code;
$w_param["schedule_id"] = $schedule_id;
ErrorLogger::doOutput($w_param, 0,"XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXw_param");
$result = $db->doSelect($table_name, $w_param);
if (count($result) > 0) {
return new $class_name($result[0]);
}
return null;
}
}
?>