summaryrefslogtreecommitdiff
path: root/doc/sample-insert-resource_types.php
blob: 0979b55478404588fba60427847a2e8d5477ea4b (plain)
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
#!/usr/bin/php
<?php

    if (isset($_SERVER["REQUEST_METHOD"]) && !empty($SERVER["REQUEST_METHOD"])) {
        die("Not intended for execution through the webserver, sorry!");
    }

    require_once("lib/functions.php");

    $db   = SQL::get_instance();

    $result = $db->query("TRUNCATE TABLE `resource_types`");

    $attributes = Array(
            "auto_form_fields" => Array(
                    "mail" => Array(
                            "data" => Array(
                                    "cn",
                                ),
                        ),
                ),
            "fields" => Array(
                    "objectclass" => Array(
                            "top",
                            "groupofuniquenames",
                            "kolabgroupofuniquenames",
                            "kolabresource",
                        ),
                ),
            "form_fields" => Array(
                    "cn" => Array(),
                    "ou" => Array(
                            "type" => "select",
                        ),
                    "uniquemember" => Array(
                            "type" => "list",
                            "autocomplete" => true,
                            "optional" => true,
                        ),
                    "owner" => Array(
                            "type" => "list",
                            "autocomplete" => true,
                            "optional" => true
                        ),
                    "kolabinvitationpolicy" => Array(
                            "type" => "list",
                            "optional" => true
                        ),
                ),
        );

    $result = $db->query("INSERT INTO `resource_types` (`key`, `name`, `description`, `attributes`) " .
                "VALUES ('collection','Resource Collection', 'A collection or pool of resources'," .
                "'" . json_encode($attributes) . "')");

    $attributes = Array(
            "auto_form_fields" => Array(
                    "cn" => Array(
                            "data" => Array(
                                    "cn",
                                ),
                        ),
                    "kolabtargetfolder" => Array(
                            "data" => Array(
                                    "cn",
                                ),
                        ),
                    "mail" => Array(
                            "data" => Array(
                                    "cn",
                                ),
                        ),
                ),
            "fields" => Array(
                    "objectclass" => Array(
                            "top",
                            "kolabsharedfolder",
                            "kolabresource",
                            "mailrecipient",
                        ),
                    "kolabfoldertype" => Array(
                            "event",
                        ),
                ),
            "form_fields" => Array(
                    "acl" => Array(
                            "type" => "imap_acl",
                            "optional" => true,
                        ),
                    "cn" => Array(),
                    "ou" => Array(
                            "type" => "select",
                        ),
                    "owner" => Array(
                            "type" => "list",
                            "autocomplete" => true,
                            "optional" => true
                        ),
                    "kolabinvitationpolicy" => Array(
                            "type" => "list",
                            "optional" => true
                        ),
                ),
        );

    $result = $db->query("INSERT INTO `resource_types` (`key`, `name`, `description`, `attributes`) " .
                "VALUES ('car','Car', 'A car'," .
                "'" . json_encode($attributes) . "')");

    $result = $db->query("INSERT INTO `resource_types` (`key`, `name`, `description`, `attributes`) " .
                "VALUES ('confroom','Conference Room', 'A conference room'," .
                "'" . json_encode($attributes) . "')");

    $result = $db->query("INSERT INTO `resource_types` (`key`, `name`, `description`, `attributes`) " .
                "VALUES ('projector','Projector', 'A portable overhead projector'," .
                "'" . json_encode($attributes) . "')");

    $result = $db->query("INSERT INTO `resource_types` (`key`, `name`, `description`, `attributes`) " .
                "VALUES ('footballtickets','Football Season Tickets', 'Season tickets to the game (pretty good seats too!)'," .
                "'" . json_encode($attributes) . "')");

?>