[Summary view] [Print] [Text view]

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