2 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
3 /*********************************************************************************
4 * SugarCRM Community Edition is a customer relationship management program developed by
5 * SugarCRM, Inc. Copyright (C) 2004-2012 SugarCRM Inc.
7 * This program is free software; you can redistribute it and/or modify it under
8 * the terms of the GNU Affero General Public License version 3 as published by the
9 * Free Software Foundation with the addition of the following permission added
10 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
11 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
12 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
14 * This program is distributed in the hope that it will be useful, but WITHOUT
15 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
16 * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
19 * You should have received a copy of the GNU Affero General Public License along with
20 * this program; if not, see http://www.gnu.org/licenses or write to the Free
21 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
24 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
25 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
27 * The interactive user interfaces in modified source and object code versions
28 * of this program must display Appropriate Legal Notices, as required under
29 * Section 5 of the GNU Affero General Public License version 3.
31 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
32 * these Appropriate Legal Notices must retain the display of the "Powered by
33 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
34 * technical reasons, the Appropriate Legal Notices must display the words
35 * "Powered by SugarCRM".
36 ********************************************************************************/
38 $dictionary['schedulers'] = array('table' => 'schedulers',
42 'vname' => 'LBL_NAME',
44 'dbType' => 'varchar',
47 'reportable' => false,
51 'vname' => 'LBL_DELETED',
56 'reportable' => false,
58 'date_entered' => array (
59 'name' => 'date_entered',
60 'vname' => 'LBL_DATE_ENTERED',
64 'date_modified' => array (
65 'name' => 'date_modified',
66 'vname' => 'LBL_DATE_MODIFIED',
70 'created_by' => array (
71 'name' => 'created_by',
72 'rname' => 'user_name',
73 'id_name' => 'created_by',
74 'vname' => 'LBL_CREATED',
75 'type' => 'assigned_user_name',
76 'table' => 'created_by_users',
81 'created_by_link' => array (
82 'name' => 'created_by_link',
84 'relationship' => 'schedulers_created_by_rel',
85 'vname' => 'LBL_CREATED_BY_USER',
88 'bean_name' => 'User',
91 'modified_user_id' => array (
92 'name' => 'modified_user_id',
93 'rname' => 'user_name',
94 'id_name' => 'modified_user_id',
95 'vname' => 'LBL_MODIFIED',
96 'type' => 'assigned_user_name',
97 'table' => 'modified_user_id_users',
101 'reportable' => true,
103 'modified_user_link' => array (
104 'name' => 'modified_user_link',
106 'relationship' => 'schedulers_modified_user_id_rel',
107 'vname' => 'LBL_MODIFIED_BY_USER',
108 'link_type' => 'one',
110 'bean_name' => 'User',
111 'source' => 'non-db',
115 'vname' => 'LBL_NAME',
119 'reportable' => false,
120 'importable' => 'required',
124 'vname' => 'LBL_JOB',
128 'reportable' => false,
130 'date_time_start' => array (
131 'name' => 'date_time_start',
132 'vname' => 'LBL_SCHEDULER_DATE_TIME_START',
133 'type' => 'datetime',
135 'reportable' => false,
137 'date_time_end' => array (
138 'name' => 'date_time_end',
139 'vname' => 'LBL_SCHEDULER_DATE_TIME_END',
140 'type' => 'datetime',
141 'reportable' => false,
143 'job_interval' => array (
144 'name' => 'job_interval',
145 'vname' => 'LBL_INTERVAL',
149 'reportable' => false,
151 'time_from' => array (
152 'name' => 'time_from',
153 'vname' => 'LBL_TIME_FROM',
156 'reportable' => false,
160 'vname' => 'LBL_TIME_TO',
163 'reportable' => false,
165 'last_run' => array (
166 'name' => 'last_run',
167 'vname' => 'LBL_LAST_RUN',
168 'type' => 'datetime',
170 'reportable' => false,
174 'vname' => 'LBL_STATUS',
176 'options' => 'scheduler_status_dom',
179 'reportable' => false,
180 'importable' => 'required',
182 'catch_up' => array (
183 'name' => 'catch_up',
184 'vname' => 'LBL_CATCH_UP',
189 'reportable' => false,
191 'schedulers_times' => array (
192 'name' => 'schedulers_times',
193 'vname' => 'LBL_SCHEDULER_TIMES',
195 'relationship' => 'schedulers_jobs_rel',
196 'module' => 'SchedulersJobs',
197 'bean_name' => 'Scheduler',
198 'source' => 'non-db',
204 'name' =>'schedulerspk',
211 'name' =>'idx_schedule',
219 'relationships' => array (
220 'schedulers_created_by_rel' => array (
221 'lhs_module' => 'Users',
222 'lhs_table' => 'users',
224 'rhs_module' => 'Schedulers',
225 'rhs_table' => 'schedulers',
226 'rhs_key' => 'created_by',
227 'relationship_type' => 'one-to-one'
229 'schedulers_modified_user_id_rel' => array (
230 'lhs_module' => 'Users',
231 'lhs_table' => 'users',
233 'rhs_module' => 'Schedulers',
234 'rhs_table' => 'schedulers',
235 'rhs_key' => 'modified_user_id',
236 'relationship_type' => 'one-to-many'
238 'schedulers_jobs_rel' => array(
239 'lhs_module' => 'Schedulers',
240 'lhs_table' => 'schedulers',
242 'rhs_module' => 'SchedulersJobs',
243 'rhs_table' => 'schedulers_times',
244 'rhs_key' => 'scheduler_id',
245 //'join_table' => 'schedulers_times',
246 'relationship_type' => 'one-to-many',