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
|
<?php
/**
* @package Rdo
* @subpackage UnitTests
*/
require_once 'Horde/Autoloader.php';
@include './conf.php';
if (empty($conf)) {
die("No configuration found\n");
}
/* additional things to handle:
-- clotho_resource_availability has a one to many from resources to availabilities
-- clotho_resources.resource_base_calendar is a foreign key to clotho_calendars.calendar_id
item_parent INTEGER NOT NULL, -- item_id of WBS parent in
-- heirarchy
dependency_lhs_item INTEGER NOT NULL, -- clotho_wbs_items.item_id
dependency_rhs_item INTEGER NOT NULL, -- clotho_wbs_items.item_id
*/
/**
* Items
*/
class Item extends Horde_Rdo_Base
{
}
/**
* Item Mapper
*/
class ItemMapper extends Horde_Rdo_Mapper
{
protected $_relationships = array(
'parent' => array('type' => Horde_Rdo::ONE_TO_ONE,
'foreignKey' => 'item_parent',
'mapper' => 'ItemMapper'),
);
protected $_lazyRelationships = array(
'resources' => array('type' => Horde_Rdo::MANY_TO_MANY,
'mapper' => 'ResourceMapper',
'through' => 'clotho_wbs_resources'),
);
protected $_table = 'clotho_wbs_items';
}
/**
* Dependencies
*/
class Dependency extends Horde_Rdo_Base
{
}
/**
* Dependency Mapper.
*/
class DependencyMapper extends Horde_Rdo_Mapper
{
protected $_table = 'clotho_wbs_dependencies';
}
/**
* Calendars
*/
class Calendar extends Horde_Rdo_Base
{
}
/**
* Calendar Mapper.
*/
class CalendarMapper extends Horde_Rdo_Mapper
{
protected $_table = 'clotho_calendars';
}
/**
* Resources
*/
class Resource extends Horde_Rdo_Base
{
}
/**
* Resource Mapper.
*/
class ResourceMapper extends Horde_Rdo_Mapper
{
protected $_lazyRelationships = array(
'availabilities' => array('type' => Horde_Rdo::ONE_TO_MANY,
'foreignKey' => 'resource_id',
'mapper' => 'ResourceAvailabilityMapper'),
'items' => array('type' => Horde_Rdo::MANY_TO_MANY,
'mapper' => 'ItemMapper',
'through' => 'clotho_wbs_resources'),
);
protected $_table = 'clotho_resources';
}
/**
* ResourceAvailability
*/
class ResourceAvailability extends Horde_Rdo_Base
{
}
/**
* ResourceAvailability Mapper.
*/
class ResourceAvailabilityMapper extends Horde_Rdo_Mapper
{
protected $_relationships = array(
'resource' => array('type' => Horde_Rdo::MANY_TO_ONE,
'foreignKey' => 'resource_id',
'mapper' => 'ResourceMapper'),
);
protected $_table = 'clotho_resource_availability';
}
|
