modules/SchedulersJobs/vardefs.php

   1 <?php
   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.
   6  *
   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.
  13  *
  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
  17  * details.
  18  *
  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
  22  * 02110-1301 USA.
  23  *
  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.
  26  *
  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.
  30  *
  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  ********************************************************************************/
  37
  38
  39 $dictionary['SchedulersJob'] = array('table' => 'job_queue',
  40     'comment' => 'Job queue keeps the list of the jobs executed by this instance',
  41         'fields' => array (
  42                 'id' => array (
  43                         'name' => 'id',
  44                         'vname' => 'LBL_NAME',
  45                         'type' => 'id',
  46                         'len' => '36',
  47                         'required' => true,
  48                         'reportable'=>false,
  49                 ),
  50            'name'=>
  51             array(
  52             'name'=>'name',
  53             'vname'=> 'LBL_NAME',
  54             'type'=>'name',
  55             'link' => true, // bug 39288
  56                 'dbType' => 'varchar',
  57             'len'=>255,
  58             'required'=>true,
  59             ),
  60                 'deleted' => array (
  61                         'name' => 'deleted',
  62                         'vname' => 'LBL_DELETED',
  63                         'type' => 'bool',
  64                         'required' => true,
  65                         'default' => '0',
  66                         'reportable'=>false,
  67                 ),
  68                 'date_entered' => array (
  69                         'name' => 'date_entered',
  70                         'vname' => 'LBL_DATE_ENTERED',
  71                         'type' => 'datetime',
  72                         'required' => true,
  73                 ),
  74                 'date_modified' => array (
  75                         'name' => 'date_modified',
  76                         'vname' => 'LBL_DATE_MODIFIED',
  77                         'type' => 'datetime',
  78                         'required' => true,
  79                 ),
  80                 'scheduler_id' => array (
  81                         'name' => 'scheduler_id',
  82                         'vname' => 'LBL_SCHEDULER',
  83                         'type' => 'id',
  84                         'required' => false,
  85                         'reportable' => false,
  86                 ),
  87                 'execute_time' => array (
  88                         'name' => 'execute_time',
  89                         'vname' => 'LBL_EXECUTE_TIME',
  90                         'type' => 'datetime',
  91                         'required' => true,
  92                 ),
  93                 'status' => array (
  94                         'name' => 'status',
  95                         'vname' => 'LBL_STATUS',
  96                         'type' => 'enum',
  97                         'options'       => 'schedulers_times_dom',
  98                         'len' => 20,
  99                         'required' => true,
 100                         'reportable' => true,
 101                         'readonly' => true,
 102                 ),
 103                 'resolution' => array (
 104                         'name' => 'resolution',
 105                         'vname' => 'LBL_RESOLUTION',
 106                         'type' => 'enum',
 107                         'options'       => 'schedulers_resolution_dom',
 108                         'len' => 20,
 109                         'required' => true,
 110                         'reportable' => true,
 111                     'readonly' => true,
 112                 ),
 113                 'message' => array (
 114                         'name' => 'message',
 115                         'vname' => 'LBL_MESSAGE',
 116                         'type' => 'text',
 117                         'required' => false,
 118                         'reportable' => false,
 119                 ),
 120                 'target' => array (
 121                         'name' => 'target',
 122                         'vname' => 'LBL_TARGET',
 123                         'type' => 'varchar',
 124                         'len' => 255,
 125                         'required' => true,
 126                         'reportable' => true,
 127                 ),
 128                 'data' => array (
 129                         'name' => 'data',
 130                         'vname' => 'LBL_DATA',
 131                         'type' => 'text',
 132                         'required' => false,
 133                         'reportable' => true,
 134                 ),
 135                 'requeue' => array (
 136                         'name' => 'requeue',
 137                         'vname' => 'LBL_REQUEUE',
 138                         'type' => 'bool',
 139                     'default' => 0,
 140                         'required' => false,
 141                         'reportable' => true,
 142                 ),
 143                 'retry_count' => array (
 144                         'name' => 'retry_count',
 145                         'vname' => 'LBL_RETRY_COUNT',
 146                         'type' => 'tinyint',
 147                         'required' => false,
 148                         'reportable' => true,
 149                 ),
 150                 'failure_count' => array (
 151                         'name' => 'failure_count',
 152                         'vname' => 'LBL_FAIL_COUNT',
 153                         'type' => 'tinyint',
 154                         'required' => false,
 155                         'reportable' => true,
 156                     'readonly' => true,
 157                 ),
 158                 'job_delay' => array (
 159                         'name' => 'job_delay',
 160                         'vname' => 'LBL_INTERVAL',
 161                         'type' => 'int',
 162                         'required' => false,
 163                         'reportable' => false,
 164                 ),
 165                 'client' => array (
 166                         'name' => 'client',
 167                         'vname' => 'LBL_CLIENT',
 168                         'type' => 'varchar',
 169                         'len' => 255,
 170                         'required' => true,
 171                         'reportable' => true,
 172                 ),
 173                 'percent_complete' => array (
 174                         'name' => 'percent_complete',
 175                         'vname' => 'LBL_PERCENT',
 176                         'type' => 'int',
 177                         'required' => false,
 178                 ),
 179                 ),
 180         'indices' => array (
 181                 array(
 182                         'name' =>'job_queuepk',
 183                         'type' =>'primary',
 184                         'fields' => array(
 185                                 'id'
 186                         )
 187                 ),
 188                 array(
 189                 'name' =>'idx_status_scheduler',
 190                 'type'=>'index',
 191                 'fields' => array(
 192                 'status',
 193                         'scheduler_id',
 194                         )
 195                 ),
 196                 array(
 197                 'name' =>'idx_status_time',
 198                 'type'=>'index',
 199                 'fields' => array(
 200                 'status',
 201                                 'execute_time',
 202                                 'date_entered',
 203                         )
 204                 ),
 205                 array(
 206                 'name' =>'idx_status_entered',
 207                 'type'=>'index',
 208                 'fields' => array(
 209                 'status',
 210                         'date_entered',
 211                         )
 212                 ),
 213                 array(
 214                 'name' =>'idx_status_modified',
 215                 'type'=>'index',
 216                 'fields' => array(
 217                 'status',
 218                         'date_modified',
 219                         )
 220                 ),
 221         ),
 222 );
 223
 224 VardefManager::createVardef('SchedulersJobs','SchedulersJob', array('assignable'));