[Summary view] [Print] [Text view]

   1  <?xml version='1.0'?>
   2  <module>
   3  <exporttime>2009-02-06 12:10:01</exporttime>
   4  <name>ServiceContracts</name>
   5  <label>Service Contracts</label>
   6  <parent>Support</parent>
   7  <version>2.4</version>
   8  <dependencies>
   9  <vtiger_version>6.0.0rc</vtiger_version>
  10  </dependencies>
  11  <migrations>
  12      <migration version='1.0'>
  13          <tables>
  14              <table>
  15                  <name>vtiger_servicecontracts</name>
  16                  <sql><![CDATA[ALTER TABLE vtiger_servicecontracts MODIFY COLUMN start_date DATE DEFAULT NULL]]></sql>
  17              </table>
  18              <table>
  19                  <name>vtiger_servicecontracts</name>
  20                  <sql><![CDATA[ALTER TABLE vtiger_servicecontracts MODIFY COLUMN end_date DATE DEFAULT NULL]]></sql>
  21              </table>
  22              <table>
  23                  <name>vtiger_servicecontracts</name>
  24                  <sql><![CDATA[ALTER TABLE vtiger_servicecontracts MODIFY COLUMN total_units  decimal(5,2) default NULL]]></sql>
  25              </table>
  26              <table>
  27                  <name>vtiger_servicecontracts</name>
  28                  <sql><![CDATA[ALTER TABLE vtiger_servicecontracts MODIFY COLUMN used_units decimal(5,2) default NULL]]></sql>
  29              </table>
  30          </tables>
  31      </migration>
  32  </migrations>
  33  <tables>
  34  <table>
  35  <name>vtiger_servicecontracts</name>
  36  <sql><![CDATA[CREATE TABLE `vtiger_servicecontracts` (
  37    `servicecontractsid` int(11) default NULL,
  38    `start_date` date default NULL,
  39    `end_date` date default NULL,
  40    `sc_related_to` int(11) default NULL,
  41    `tracking_unit` varchar(100) default NULL,
  42    `total_units` decimal(5,2) default NULL,
  43    `used_units` decimal(5,2) default NULL,
  44    `subject` varchar(100) default NULL,
  45    `due_date` date default NULL,
  46    `planned_duration` varchar(256) default NULL,
  47    `actual_duration` varchar(256) default NULL,
  48    `contract_status` varchar(200) default NULL,
  49    `priority` varchar(200) default NULL,
  50    `contract_type` varchar(200) default NULL,
  51    `progress` decimal(5,2) default NULL,
  52    `contract_no` varchar(100) default NULL
  53  ) ENGINE=InnoDB DEFAULT CHARSET=utf8]]></sql>
  54  </table>
  55  <table>
  56  <name>vtiger_servicecontractscf</name>
  57  <sql><![CDATA[CREATE TABLE `vtiger_servicecontractscf` (
  58    `servicecontractsid` int(11) NOT NULL,
  59    PRIMARY KEY  (`servicecontractsid`)
  60  ) ENGINE=InnoDB DEFAULT CHARSET=utf8]]></sql>
  61  </table>
  62  </tables>
  63  <blocks>
  64  <block>
  65  <label>LBL_SERVICE_CONTRACT_INFORMATION</label>
  66  <fields>
  67  <field>
  68  <fieldname>assigned_user_id</fieldname>
  69  <uitype>53</uitype>
  70  <columnname>smownerid</columnname>
  71  <tablename>vtiger_crmentity</tablename>
  72  <generatedtype>1</generatedtype>
  73  <fieldlabel>Assigned To</fieldlabel>
  74  <readonly>1</readonly>
  75  <presence>2</presence>
  76  <defaultvalue></defaultvalue>
  77  <sequence>4</sequence>
  78  <maximumlength>100</maximumlength>
  79  <typeofdata>V~M</typeofdata>
  80  <quickcreate>2</quickcreate>
  81  <quickcreatesequence>2</quickcreatesequence>
  82  <displaytype>1</displaytype>
  83  <info_type>BAS</info_type>
  84  <helpinfo><![CDATA[]]></helpinfo>
  85  <masseditable>1</masseditable>
  86  </field>
  87  <field>
  88  <fieldname>createdtime</fieldname>
  89  <uitype>70</uitype>
  90  <columnname>createdtime</columnname>
  91  <tablename>vtiger_crmentity</tablename>
  92  <generatedtype>1</generatedtype>
  93  <fieldlabel>Created Time</fieldlabel>
  94  <readonly>1</readonly>
  95  <presence>0</presence>
  96  <defaultvalue></defaultvalue>
  97  <sequence>17</sequence>
  98  <maximumlength>100</maximumlength>
  99  <typeofdata>DT~O</typeofdata>
 100  <quickcreate>3</quickcreate>
 101  <quickcreatesequence></quickcreatesequence>
 102  <displaytype>2</displaytype>
 103  <info_type>BAS</info_type>
 104  <helpinfo><![CDATA[]]></helpinfo>
 105  <masseditable>0</masseditable>
 106  </field>
 107  <field>
 108  <fieldname>modifiedtime</fieldname>
 109  <uitype>70</uitype>
 110  <columnname>modifiedtime</columnname>
 111  <tablename>vtiger_crmentity</tablename>
 112  <generatedtype>1</generatedtype>
 113  <fieldlabel>Modified Time</fieldlabel>
 114  <readonly>1</readonly>
 115  <presence>0</presence>
 116  <defaultvalue></defaultvalue>
 117  <sequence>18</sequence>
 118  <maximumlength>100</maximumlength>
 119  <typeofdata>DT~O</typeofdata>
 120  <quickcreate>3</quickcreate>
 121  <quickcreatesequence></quickcreatesequence>
 122  <displaytype>2</displaytype>
 123  <info_type>BAS</info_type>
 124  <helpinfo><![CDATA[]]></helpinfo>
 125  <masseditable>0</masseditable>
 126  </field>
 127  <field>
 128  <fieldname>start_date</fieldname>
 129  <uitype>5</uitype>
 130  <columnname>start_date</columnname>
 131  <tablename>vtiger_servicecontracts</tablename>
 132  <generatedtype>1</generatedtype>
 133  <fieldlabel>Start Date</fieldlabel>
 134  <readonly>1</readonly>
 135  <presence>2</presence>
 136  <defaultvalue></defaultvalue>
 137  <sequence>7</sequence>
 138  <maximumlength>100</maximumlength>
 139  <typeofdata>D~O</typeofdata>
 140  <quickcreate>2</quickcreate>
 141  <quickcreatesequence>4</quickcreatesequence>
 142  <displaytype>1</displaytype>
 143  <info_type>BAS</info_type>
 144  <helpinfo><![CDATA[]]></helpinfo>
 145  <masseditable>1</masseditable>
 146  </field>
 147  <field>
 148  <fieldname>end_date</fieldname>
 149  <uitype>5</uitype>
 150  <columnname>end_date</columnname>
 151  <tablename>vtiger_servicecontracts</tablename>
 152  <generatedtype>1</generatedtype>
 153  <fieldlabel>End Date</fieldlabel>
 154  <readonly>1</readonly>
 155  <presence>2</presence>
 156  <defaultvalue></defaultvalue>
 157  <sequence>11</sequence>
 158  <maximumlength>100</maximumlength>
 159  <typeofdata>D~O</typeofdata>
 160  <quickcreate>3</quickcreate>
 161  <quickcreatesequence>0</quickcreatesequence>
 162  <displaytype>2</displaytype>
 163  <info_type>BAS</info_type>
 164  <helpinfo><![CDATA[]]></helpinfo>
 165  <masseditable>0</masseditable>
 166  </field>
 167  <field>
 168  <fieldname>sc_related_to</fieldname>
 169  <uitype>10</uitype>
 170  <columnname>sc_related_to</columnname>
 171  <tablename>vtiger_servicecontracts</tablename>
 172  <generatedtype>1</generatedtype>
 173  <fieldlabel>Related to</fieldlabel>
 174  <readonly>1</readonly>
 175  <presence>2</presence>
 176  <defaultvalue></defaultvalue>
 177  <sequence>3</sequence>
 178  <maximumlength>100</maximumlength>
 179  <typeofdata>V~O</typeofdata>
 180  <quickcreate>2</quickcreate>
 181  <quickcreatesequence>6</quickcreatesequence>
 182  <displaytype>1</displaytype>
 183  <info_type>BAS</info_type>
 184  <helpinfo><![CDATA[]]></helpinfo>
 185  <masseditable>1</masseditable>
 186  <relatedmodules>
 187  <relatedmodule>Contacts</relatedmodule>
 188  <relatedmodule>Accounts</relatedmodule>
 189  </relatedmodules>
 190  </field>
 191  <field>
 192  <fieldname>tracking_unit</fieldname>
 193  <uitype>15</uitype>
 194  <columnname>tracking_unit</columnname>
 195  <tablename>vtiger_servicecontracts</tablename>
 196  <generatedtype>1</generatedtype>
 197  <fieldlabel>Tracking Unit</fieldlabel>
 198  <readonly>1</readonly>
 199  <presence>2</presence>
 200  <defaultvalue></defaultvalue>
 201  <sequence>6</sequence>
 202  <maximumlength>100</maximumlength>
 203  <typeofdata>V~O</typeofdata>
 204  <quickcreate>2</quickcreate>
 205  <quickcreatesequence>7</quickcreatesequence>
 206  <displaytype>1</displaytype>
 207  <info_type>BAS</info_type>
 208  <helpinfo><![CDATA[]]></helpinfo>
 209  <masseditable>1</masseditable>
 210  <picklistvalues>
 211  <picklistvalue>None</picklistvalue>
 212  <picklistvalue>Hours</picklistvalue>
 213  <picklistvalue>Days</picklistvalue>
 214  <picklistvalue>Incidents</picklistvalue>
 215  </picklistvalues>
 216  </field>
 217  <field>
 218  <fieldname>total_units</fieldname>
 219  <uitype>7</uitype>
 220  <columnname>total_units</columnname>
 221  <tablename>vtiger_servicecontracts</tablename>
 222  <generatedtype>1</generatedtype>
 223  <fieldlabel>Total Units</fieldlabel>
 224  <readonly>1</readonly>
 225  <presence>2</presence>
 226  <defaultvalue></defaultvalue>
 227  <sequence>8</sequence>
 228  <maximumlength>100</maximumlength>
 229  <typeofdata>V~O</typeofdata>
 230  <quickcreate>2</quickcreate>
 231  <quickcreatesequence>8</quickcreatesequence>
 232  <displaytype>1</displaytype>
 233  <info_type>BAS</info_type>
 234  <helpinfo><![CDATA[]]></helpinfo>
 235  <masseditable>1</masseditable>
 236  </field>
 237  <field>
 238  <fieldname>used_units</fieldname>
 239  <uitype>7</uitype>
 240  <columnname>used_units</columnname>
 241  <tablename>vtiger_servicecontracts</tablename>
 242  <generatedtype>1</generatedtype>
 243  <fieldlabel>Used Units</fieldlabel>
 244  <readonly>1</readonly>
 245  <presence>2</presence>
 246  <defaultvalue></defaultvalue>
 247  <sequence>10</sequence>
 248  <maximumlength>100</maximumlength>
 249  <typeofdata>V~O</typeofdata>
 250  <quickcreate>2</quickcreate>
 251  <quickcreatesequence>9</quickcreatesequence>
 252  <displaytype>1</displaytype>
 253  <info_type>BAS</info_type>
 254  <helpinfo><![CDATA[]]></helpinfo>
 255  <masseditable>1</masseditable>
 256  </field>
 257  <field>
 258  <fieldname>subject</fieldname>
 259  <uitype>1</uitype>
 260  <columnname>subject</columnname>
 261  <tablename>vtiger_servicecontracts</tablename>
 262  <generatedtype>1</generatedtype>
 263  <fieldlabel>Subject</fieldlabel>
 264  <readonly>1</readonly>
 265  <presence>0</presence>
 266  <defaultvalue></defaultvalue>
 267  <sequence>1</sequence>
 268  <maximumlength>100</maximumlength>
 269  <typeofdata>V~M</typeofdata>
 270  <quickcreate>0</quickcreate>
 271  <quickcreatesequence>1</quickcreatesequence>
 272  <displaytype>1</displaytype>
 273  <info_type>BAS</info_type>
 274  <helpinfo><![CDATA[]]></helpinfo>
 275  <masseditable>1</masseditable>
 276  <entityidentifier>
 277  <entityidfield>servicecontractsid</entityidfield>
 278  <entityidcolumn>servicecontractsid</entityidcolumn>
 279  </entityidentifier>
 280  </field>
 281  <field>
 282  <fieldname>due_date</fieldname>
 283  <uitype>23</uitype>
 284  <columnname>due_date</columnname>
 285  <tablename>vtiger_servicecontracts</tablename>
 286  <generatedtype>1</generatedtype>
 287  <fieldlabel>Due date</fieldlabel>
 288  <readonly>1</readonly>
 289  <presence>2</presence>
 290  <defaultvalue></defaultvalue>
 291  <sequence>9</sequence>
 292  <maximumlength>100</maximumlength>
 293  <typeofdata>D~O</typeofdata>
 294  <quickcreate>2</quickcreate>
 295  <quickcreatesequence>5</quickcreatesequence>
 296  <displaytype>1</displaytype>
 297  <info_type>BAS</info_type>
 298  <helpinfo><![CDATA[]]></helpinfo>
 299  <masseditable>1</masseditable>
 300  </field>
 301  <field>
 302  <fieldname>planned_duration</fieldname>
 303  <uitype>1</uitype>
 304  <columnname>planned_duration</columnname>
 305  <tablename>vtiger_servicecontracts</tablename>
 306  <generatedtype>1</generatedtype>
 307  <fieldlabel>Planned Duration</fieldlabel>
 308  <readonly>1</readonly>
 309  <presence>2</presence>
 310  <defaultvalue></defaultvalue>
 311  <sequence>13</sequence>
 312  <maximumlength>100</maximumlength>
 313  <typeofdata>V~O</typeofdata>
 314  <quickcreate>3</quickcreate>
 315  <quickcreatesequence></quickcreatesequence>
 316  <displaytype>2</displaytype>
 317  <info_type>BAS</info_type>
 318  <helpinfo><![CDATA[]]></helpinfo>
 319  <masseditable>0</masseditable>
 320  </field>
 321  <field>
 322  <fieldname>actual_duration</fieldname>
 323  <uitype>1</uitype>
 324  <columnname>actual_duration</columnname>
 325  <tablename>vtiger_servicecontracts</tablename>
 326  <generatedtype>1</generatedtype>
 327  <fieldlabel>Actual Duration</fieldlabel>
 328  <readonly>1</readonly>
 329  <presence>2</presence>
 330  <defaultvalue></defaultvalue>
 331  <sequence>15</sequence>
 332  <maximumlength>100</maximumlength>
 333  <typeofdata>V~O</typeofdata>
 334  <quickcreate>3</quickcreate>
 335  <quickcreatesequence></quickcreatesequence>
 336  <displaytype>2</displaytype>
 337  <info_type>BAS</info_type>
 338  <helpinfo><![CDATA[]]></helpinfo>
 339  <masseditable>0</masseditable>
 340  </field>
 341  <field>
 342  <fieldname>contract_status</fieldname>
 343  <uitype>15</uitype>
 344  <columnname>contract_status</columnname>
 345  <tablename>vtiger_servicecontracts</tablename>
 346  <generatedtype>1</generatedtype>
 347  <fieldlabel>Status</fieldlabel>
 348  <readonly>1</readonly>
 349  <presence>2</presence>
 350  <defaultvalue></defaultvalue>
 351  <sequence>12</sequence>
 352  <maximumlength>100</maximumlength>
 353  <typeofdata>V~O</typeofdata>
 354  <quickcreate>1</quickcreate>
 355  <quickcreatesequence></quickcreatesequence>
 356  <displaytype>1</displaytype>
 357  <info_type>BAS</info_type>
 358  <helpinfo><![CDATA[]]></helpinfo>
 359  <masseditable>1</masseditable>
 360  <picklistvalues>
 361  <picklistvalue>Undefined</picklistvalue>
 362  <picklistvalue>In Planning</picklistvalue>
 363  <picklistvalue>In Progress</picklistvalue>
 364  <picklistvalue>On Hold</picklistvalue>
 365  <picklistvalue>Complete</picklistvalue>
 366  <picklistvalue>Archived</picklistvalue>
 367  </picklistvalues>
 368  </field>
 369  <field>
 370  <fieldname>contract_priority</fieldname>
 371  <uitype>15</uitype>
 372  <columnname>priority</columnname>
 373  <tablename>vtiger_servicecontracts</tablename>
 374  <generatedtype>1</generatedtype>
 375  <fieldlabel>Priority</fieldlabel>
 376  <readonly>1</readonly>
 377  <presence>2</presence>
 378  <defaultvalue></defaultvalue>
 379  <sequence>14</sequence>
 380  <maximumlength>100</maximumlength>
 381  <typeofdata>V~O</typeofdata>
 382  <quickcreate>1</quickcreate>
 383  <quickcreatesequence></quickcreatesequence>
 384  <displaytype>1</displaytype>
 385  <info_type>BAS</info_type>
 386  <helpinfo><![CDATA[]]></helpinfo>
 387  <masseditable>1</masseditable>
 388  <picklistvalues>
 389  <picklistvalue>Low</picklistvalue>
 390  <picklistvalue>Normal</picklistvalue>
 391  <picklistvalue>High</picklistvalue>
 392  </picklistvalues>
 393  </field>
 394  <field>
 395  <fieldname>contract_type</fieldname>
 396  <uitype>15</uitype>
 397  <columnname>contract_type</columnname>
 398  <tablename>vtiger_servicecontracts</tablename>
 399  <generatedtype>1</generatedtype>
 400  <fieldlabel>Type</fieldlabel>
 401  <readonly>1</readonly>
 402  <presence>2</presence>
 403  <defaultvalue></defaultvalue>
 404  <sequence>5</sequence>
 405  <maximumlength>100</maximumlength>
 406  <typeofdata>V~O</typeofdata>
 407  <quickcreate>1</quickcreate>
 408  <quickcreatesequence></quickcreatesequence>
 409  <displaytype>1</displaytype>
 410  <info_type>BAS</info_type>
 411  <helpinfo><![CDATA[]]></helpinfo>
 412  <masseditable>1</masseditable>
 413  <picklistvalues>
 414  <picklistvalue>Support</picklistvalue>
 415  <picklistvalue>Services</picklistvalue>
 416  <picklistvalue>Administrative</picklistvalue>
 417  </picklistvalues>
 418  </field>
 419  <field>
 420  <fieldname>progress</fieldname>
 421  <uitype>9</uitype>
 422  <columnname>progress</columnname>
 423  <tablename>vtiger_servicecontracts</tablename>
 424  <generatedtype>1</generatedtype>
 425  <fieldlabel>Progress</fieldlabel>
 426  <readonly>1</readonly>
 427  <presence>2</presence>
 428  <defaultvalue></defaultvalue>
 429  <sequence>16</sequence>
 430  <maximumlength>100</maximumlength>
 431  <typeofdata>N~O~2~2</typeofdata>
 432  <quickcreate>3</quickcreate>
 433  <quickcreatesequence>3</quickcreatesequence>
 434  <displaytype>2</displaytype>
 435  <info_type>BAS</info_type>
 436  <helpinfo><![CDATA[]]></helpinfo>
 437  <masseditable>0</masseditable>
 438  </field>
 439  <field>
 440  <fieldname>contract_no</fieldname>
 441  <uitype>4</uitype>
 442  <columnname>contract_no</columnname>
 443  <tablename>vtiger_servicecontracts</tablename>
 444  <generatedtype>1</generatedtype>
 445  <fieldlabel>Contract No</fieldlabel>
 446  <readonly>1</readonly>
 447  <presence>0</presence>
 448  <defaultvalue></defaultvalue>
 449  <sequence>2</sequence>
 450  <maximumlength>100</maximumlength>
 451  <typeofdata>V~O</typeofdata>
 452  <quickcreate>3</quickcreate>
 453  <quickcreatesequence></quickcreatesequence>
 454  <displaytype>1</displaytype>
 455  <info_type>BAS</info_type>
 456  <helpinfo><![CDATA[]]></helpinfo>
 457  <masseditable>0</masseditable>
 458  </field>
 459  <field>
 460  <fieldname>modifiedby</fieldname>
 461  <uitype>52</uitype>
 462  <columnname>modifiedby</columnname>
 463  <tablename>vtiger_crmentity</tablename>
 464  <generatedtype>1</generatedtype>
 465  <fieldlabel>Last Modified By</fieldlabel>
 466  <readonly>1</readonly>
 467  <presence>0</presence>
 468  <defaultvalue></defaultvalue>
 469  <sequence>17</sequence>
 470  <maximumlength>100</maximumlength>
 471  <typeofdata>V~O</typeofdata>
 472  <quickcreate>3</quickcreate>
 473  <quickcreatesequence></quickcreatesequence>
 474  <displaytype>3</displaytype>
 475  <info_type>BAS</info_type>
 476  <helpinfo><![CDATA[]]></helpinfo>
 477  <masseditable>0</masseditable>
 478  </field>
 479  </fields>
 480  </block>
 481  <block>
 482  <label>LBL_CUSTOM_INFORMATION</label>
 483  </block>
 484  </blocks>
 485  <customviews>
 486  <customview>
 487  <viewname>All</viewname>
 488  <setdefault>true</setdefault>
 489  <setmetrics>false</setmetrics>
 490  <fields>
 491  <field>
 492  <fieldname>contract_no</fieldname>
 493  <columnindex>0</columnindex>
 494  </field>
 495  <field>
 496  <fieldname>subject</fieldname>
 497  <columnindex>1</columnindex>
 498  </field>
 499  <field>
 500  <fieldname>sc_related_to</fieldname>
 501  <columnindex>2</columnindex>
 502  </field>
 503  <field>
 504  <fieldname>assigned_user_id</fieldname>
 505  <columnindex>3</columnindex>
 506  </field>
 507  <field>
 508  <fieldname>start_date</fieldname>
 509  <columnindex>4</columnindex>
 510  </field>
 511  <field>
 512  <fieldname>due_date</fieldname>
 513  <columnindex>5</columnindex>
 514  </field>
 515  <field>
 516  <fieldname>progress</fieldname>
 517  <columnindex>7</columnindex>
 518  </field>
 519  <field>
 520  <fieldname>contract_status</fieldname>
 521  <columnindex>8</columnindex>
 522  </field>
 523  </fields>
 524  </customview>
 525  </customviews>
 526  <sharingaccess>
 527  <default>public_readwritedelete</default>
 528  </sharingaccess>
 529  <events>
 530  <event>
 531  <eventname>vtiger.entity.beforesave</eventname>
 532  <classname><![CDATA[ServiceContractsHandler]]></classname>
 533  <filename><![CDATA[modules/ServiceContracts/ServiceContractsHandler.php]]></filename>
 534  </event>
 535  <event>
 536  <eventname>vtiger.entity.aftersave</eventname>
 537  <classname><![CDATA[ServiceContractsHandler]]></classname>
 538  <filename><![CDATA[modules/ServiceContracts/ServiceContractsHandler.php]]></filename>
 539  </event>
 540  </events>
 541  <actions>
 542  <action>
 543  <name><![CDATA[Import]]></name>
 544  <status>enabled</status>
 545  </action>
 546  <action>
 547  <name><![CDATA[Export]]></name>
 548  <status>enabled</status>
 549  </action>
 550  <action>
 551  <name><![CDATA[DuplicatesHandling]]></name>
 552  <status>enabled</status>
 553  </action>
 554  </actions>
 555  <relatedlists>
 556  <relatedlist>
 557  <function>get_related_list</function>
 558  <label>Service Requests</label>
 559  <sequence>1</sequence>
 560  <presence>0</presence>
 561  <actions>
 562  <action>ADD</action>
 563  <action>SELECT</action>
 564  </actions>
 565  <relatedmodule>HelpDesk</relatedmodule>
 566  </relatedlist>
 567  <relatedlist>
 568  <function>get_attachments</function>
 569  <label>Documents</label>
 570  <sequence>2</sequence>
 571  <presence>0</presence>
 572  <actions>
 573  <action>ADD</action>
 574  <action>SELECT</action>
 575  </actions>
 576  <relatedmodule>Documents</relatedmodule>
 577  </relatedlist>
 578  </relatedlists>
 579  </module>