.

　晋太元中，武陵人捕鱼为业。缘溪行，忘路之远近。忽逢桃花林，夹岸数百步，中无杂树，芳草鲜美，落英缤纷。渔人甚异之，复前行，欲穷其林。　　林尽水源，便得一山，山有小口，仿佛若有光。便舍船，从口入。初极狭，才通人。复行数十步，豁然开朗。土地平旷，屋舍俨然，有良田、美池、桑竹之属。阡陌交通，鸡犬相闻。其中往来种作，男女衣着，悉如外人。黄发垂髫，并怡然自乐。　　见渔人，乃大惊，问所从来。具答之。便要还家，设酒杀鸡作食。村中闻有此人，咸来问讯。自云先世避秦时乱，率妻子邑人来此绝境，不复出焉，遂与外人间隔。问今是何世，乃不知有汉，无论魏晋。此人一一为具言所闻，皆叹惋。余人各复延至其家，皆出酒食。停数日，辞去。此中人语云：“不足为外人道也。”(间隔一作：隔绝) 　　既出，得其船，便扶向路，处处志之。及郡下，诣太守，说如此。太守即遣人随其往，寻向所志，遂迷，不复得路。　　南阳刘子骥，高尚士也，闻之，欣然规往。未果，寻病终。后遂无问津者。 . Prv8 Shell
Server : Apache
System : Linux srv.rainic.com 4.18.0-553.47.1.el8_10.x86_64 #1 SMP Wed Apr 2 05:45:37 EDT 2025 x86_64
User : rainic ( 1014)
PHP Version : 7.4.33
Disable Function : exec,passthru,shell_exec,system
Directory : /home/akaindir/www/crm/pkg/vtiger/modules/ServiceContracts/
Upload File :
Current File : /home/akaindir/www/crm/pkg/vtiger/modules/ServiceContracts/manifest.xml
<?xml version='1.0'?>
<module>
	<exporttime>2009-02-06 12:10:01</exporttime>
	<name>ServiceContracts</name>
	<label>Service Contracts</label>
	<parent>Support</parent>
	<version>2.4</version>
	<dependencies>
		<vtiger_version>6.0.0rc</vtiger_version>
	</dependencies>
	<migrations>
		<migration version='1.0'>
			<tables>
				<table>
					<name>vtiger_servicecontracts</name>
					<sql><![CDATA[ALTER TABLE vtiger_servicecontracts MODIFY COLUMN start_date DATE DEFAULT NULL]]></sql>
				</table>
				<table>
					<name>vtiger_servicecontracts</name>
					<sql><![CDATA[ALTER TABLE vtiger_servicecontracts MODIFY COLUMN end_date DATE DEFAULT NULL]]></sql>
				</table>
				<table>
					<name>vtiger_servicecontracts</name>
					<sql><![CDATA[ALTER TABLE vtiger_servicecontracts MODIFY COLUMN total_units  decimal(5,2) default NULL]]></sql>
				</table>
				<table>
					<name>vtiger_servicecontracts</name>
					<sql><![CDATA[ALTER TABLE vtiger_servicecontracts MODIFY COLUMN used_units decimal(5,2) default NULL]]></sql>
				</table>
			</tables>
		</migration>
	</migrations>
	<tables>
		<table>
			<name>vtiger_servicecontracts</name>
			<sql><![CDATA[CREATE TABLE `vtiger_servicecontracts` (
  `servicecontractsid` int(11) default NULL,
  `start_date` date default NULL,
  `end_date` date default NULL,
  `sc_related_to` int(11) default NULL,
  `tracking_unit` varchar(100) default NULL,
  `total_units` decimal(5,2) default NULL,
  `used_units` decimal(5,2) default NULL,
  `subject` varchar(100) default NULL,
  `due_date` date default NULL,
  `planned_duration` varchar(256) default NULL,
  `actual_duration` varchar(256) default NULL,
  `contract_status` varchar(200) default NULL,
  `priority` varchar(200) default NULL,
  `contract_type` varchar(200) default NULL,
  `progress` decimal(5,2) default NULL,
  `contract_no` varchar(100) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8]]></sql>
		</table>
		<table>
			<name>vtiger_servicecontractscf</name>
			<sql><![CDATA[CREATE TABLE `vtiger_servicecontractscf` (
  `servicecontractsid` int(11) NOT NULL,
  PRIMARY KEY  (`servicecontractsid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8]]></sql>
		</table>
	</tables>
	<blocks>
		<block>
			<label>LBL_SERVICE_CONTRACT_INFORMATION</label>
			<fields>
				<field>
					<fieldname>assigned_user_id</fieldname>
					<uitype>53</uitype>
					<columnname>smownerid</columnname>
					<tablename>vtiger_crmentity</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Assigned To</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>4</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~M</typeofdata>
					<quickcreate>2</quickcreate>
					<quickcreatesequence>2</quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>1</masseditable>
				</field>
				<field>
					<fieldname>createdtime</fieldname>
					<uitype>70</uitype>
					<columnname>createdtime</columnname>
					<tablename>vtiger_crmentity</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Created Time</fieldlabel>
					<readonly>1</readonly>
					<presence>0</presence>
					<defaultvalue></defaultvalue>
					<sequence>17</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>DT~O</typeofdata>
					<quickcreate>3</quickcreate>
					<quickcreatesequence></quickcreatesequence>
					<displaytype>2</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>0</masseditable>
				</field>
				<field>
					<fieldname>modifiedtime</fieldname>
					<uitype>70</uitype>
					<columnname>modifiedtime</columnname>
					<tablename>vtiger_crmentity</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Modified Time</fieldlabel>
					<readonly>1</readonly>
					<presence>0</presence>
					<defaultvalue></defaultvalue>
					<sequence>18</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>DT~O</typeofdata>
					<quickcreate>3</quickcreate>
					<quickcreatesequence></quickcreatesequence>
					<displaytype>2</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>0</masseditable>
				</field>
				<field>
					<fieldname>start_date</fieldname>
					<uitype>5</uitype>
					<columnname>start_date</columnname>
					<tablename>vtiger_servicecontracts</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Start Date</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>7</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>D~O</typeofdata>
					<quickcreate>2</quickcreate>
					<quickcreatesequence>4</quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>1</masseditable>
				</field>
				<field>
					<fieldname>end_date</fieldname>
					<uitype>5</uitype>
					<columnname>end_date</columnname>
					<tablename>vtiger_servicecontracts</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>End Date</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>11</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>D~O</typeofdata>
					<quickcreate>3</quickcreate>
					<quickcreatesequence>0</quickcreatesequence>
					<displaytype>2</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>0</masseditable>
				</field>
				<field>
					<fieldname>sc_related_to</fieldname>
					<uitype>10</uitype>
					<columnname>sc_related_to</columnname>
					<tablename>vtiger_servicecontracts</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Related to</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>3</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~O</typeofdata>
					<quickcreate>2</quickcreate>
					<quickcreatesequence>6</quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>1</masseditable>
					<relatedmodules>
						<relatedmodule>Contacts</relatedmodule>
						<relatedmodule>Accounts</relatedmodule>
					</relatedmodules>
				</field>
				<field>
					<fieldname>tracking_unit</fieldname>
					<uitype>15</uitype>
					<columnname>tracking_unit</columnname>
					<tablename>vtiger_servicecontracts</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Tracking Unit</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>6</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~O</typeofdata>
					<quickcreate>2</quickcreate>
					<quickcreatesequence>7</quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>1</masseditable>
					<picklistvalues>
						<picklistvalue>None</picklistvalue>
						<picklistvalue>Hours</picklistvalue>
						<picklistvalue>Days</picklistvalue>
						<picklistvalue>Incidents</picklistvalue>
					</picklistvalues>
				</field>
				<field>
					<fieldname>total_units</fieldname>
					<uitype>7</uitype>
					<columnname>total_units</columnname>
					<tablename>vtiger_servicecontracts</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Total Units</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>8</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~O</typeofdata>
					<quickcreate>2</quickcreate>
					<quickcreatesequence>8</quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>1</masseditable>
				</field>
				<field>
					<fieldname>used_units</fieldname>
					<uitype>7</uitype>
					<columnname>used_units</columnname>
					<tablename>vtiger_servicecontracts</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Used Units</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>10</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~O</typeofdata>
					<quickcreate>2</quickcreate>
					<quickcreatesequence>9</quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>1</masseditable>
				</field>
				<field>
					<fieldname>subject</fieldname>
					<uitype>1</uitype>
					<columnname>subject</columnname>
					<tablename>vtiger_servicecontracts</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Subject</fieldlabel>
					<readonly>1</readonly>
					<presence>0</presence>
					<defaultvalue></defaultvalue>
					<sequence>1</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~M</typeofdata>
					<quickcreate>0</quickcreate>
					<quickcreatesequence>1</quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>1</masseditable>
					<entityidentifier>
						<entityidfield>servicecontractsid</entityidfield>
						<entityidcolumn>servicecontractsid</entityidcolumn>
					</entityidentifier>
				</field>
				<field>
					<fieldname>due_date</fieldname>
					<uitype>23</uitype>
					<columnname>due_date</columnname>
					<tablename>vtiger_servicecontracts</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Due date</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>9</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>D~O</typeofdata>
					<quickcreate>2</quickcreate>
					<quickcreatesequence>5</quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>1</masseditable>
				</field>
				<field>
					<fieldname>planned_duration</fieldname>
					<uitype>1</uitype>
					<columnname>planned_duration</columnname>
					<tablename>vtiger_servicecontracts</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Planned Duration</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>13</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~O</typeofdata>
					<quickcreate>3</quickcreate>
					<quickcreatesequence></quickcreatesequence>
					<displaytype>2</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>0</masseditable>
				</field>
				<field>
					<fieldname>actual_duration</fieldname>
					<uitype>1</uitype>
					<columnname>actual_duration</columnname>
					<tablename>vtiger_servicecontracts</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Actual Duration</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>15</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~O</typeofdata>
					<quickcreate>3</quickcreate>
					<quickcreatesequence></quickcreatesequence>
					<displaytype>2</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>0</masseditable>
				</field>
				<field>
					<fieldname>contract_status</fieldname>
					<uitype>15</uitype>
					<columnname>contract_status</columnname>
					<tablename>vtiger_servicecontracts</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Status</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>12</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~O</typeofdata>
					<quickcreate>1</quickcreate>
					<quickcreatesequence></quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>1</masseditable>
					<picklistvalues>
						<picklistvalue>Undefined</picklistvalue>
						<picklistvalue>In Planning</picklistvalue>
						<picklistvalue>In Progress</picklistvalue>
						<picklistvalue>On Hold</picklistvalue>
						<picklistvalue>Complete</picklistvalue>
						<picklistvalue>Archived</picklistvalue>
					</picklistvalues>
				</field>
				<field>
					<fieldname>contract_priority</fieldname>
					<uitype>15</uitype>
					<columnname>priority</columnname>
					<tablename>vtiger_servicecontracts</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Priority</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>14</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~O</typeofdata>
					<quickcreate>1</quickcreate>
					<quickcreatesequence></quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>1</masseditable>
					<picklistvalues>
						<picklistvalue>Low</picklistvalue>
						<picklistvalue>Normal</picklistvalue>
						<picklistvalue>High</picklistvalue>
					</picklistvalues>
				</field>
				<field>
					<fieldname>contract_type</fieldname>
					<uitype>15</uitype>
					<columnname>contract_type</columnname>
					<tablename>vtiger_servicecontracts</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Type</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>5</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~O</typeofdata>
					<quickcreate>1</quickcreate>
					<quickcreatesequence></quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>1</masseditable>
					<picklistvalues>
						<picklistvalue>Support</picklistvalue>
						<picklistvalue>Services</picklistvalue>
						<picklistvalue>Administrative</picklistvalue>
					</picklistvalues>
				</field>
				<field>
					<fieldname>progress</fieldname>
					<uitype>9</uitype>
					<columnname>progress</columnname>
					<tablename>vtiger_servicecontracts</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Progress</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>16</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>N~O~2~2</typeofdata>
					<quickcreate>3</quickcreate>
					<quickcreatesequence>3</quickcreatesequence>
					<displaytype>2</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>0</masseditable>
				</field>
				<field>
					<fieldname>contract_no</fieldname>
					<uitype>4</uitype>
					<columnname>contract_no</columnname>
					<tablename>vtiger_servicecontracts</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Contract No</fieldlabel>
					<readonly>1</readonly>
					<presence>0</presence>
					<defaultvalue></defaultvalue>
					<sequence>2</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~O</typeofdata>
					<quickcreate>3</quickcreate>
					<quickcreatesequence></quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>0</masseditable>
				</field>
				<field>
					<fieldname>modifiedby</fieldname>
					<uitype>52</uitype>
					<columnname>modifiedby</columnname>
					<tablename>vtiger_crmentity</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Last Modified By</fieldlabel>
					<readonly>1</readonly>
					<presence>0</presence>
					<defaultvalue></defaultvalue>
					<sequence>17</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~O</typeofdata>
					<quickcreate>3</quickcreate>
					<quickcreatesequence></quickcreatesequence>
					<displaytype>3</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]></helpinfo>
					<masseditable>0</masseditable>
				</field>
			</fields>
		</block>
		<block>
			<label>LBL_CUSTOM_INFORMATION</label>
		</block>
	</blocks>
	<customviews>
		<customview>
			<viewname>All</viewname>
			<setdefault>true</setdefault>
			<setmetrics>false</setmetrics>
			<fields>
				<field>
					<fieldname>contract_no</fieldname>
					<columnindex>0</columnindex>
				</field>
				<field>
					<fieldname>subject</fieldname>
					<columnindex>1</columnindex>
				</field>
				<field>
					<fieldname>sc_related_to</fieldname>
					<columnindex>2</columnindex>
				</field>
				<field>
					<fieldname>assigned_user_id</fieldname>
					<columnindex>3</columnindex>
				</field>
				<field>
					<fieldname>start_date</fieldname>
					<columnindex>4</columnindex>
				</field>
				<field>
					<fieldname>due_date</fieldname>
					<columnindex>5</columnindex>
				</field>
				<field>
					<fieldname>progress</fieldname>
					<columnindex>7</columnindex>
				</field>
				<field>
					<fieldname>contract_status</fieldname>
					<columnindex>8</columnindex>
				</field>
			</fields>
		</customview>
	</customviews>
	<sharingaccess>
		<default>public_readwritedelete</default>
	</sharingaccess>
	<events>
		<event>
			<eventname>vtiger.entity.beforesave</eventname>
			<classname><![CDATA[ServiceContractsHandler]]></classname>
			<filename><![CDATA[modules/ServiceContracts/ServiceContractsHandler.php]]></filename>
		</event>
		<event>
			<eventname>vtiger.entity.aftersave</eventname>
			<classname><![CDATA[ServiceContractsHandler]]></classname>
			<filename><![CDATA[modules/ServiceContracts/ServiceContractsHandler.php]]></filename>
		</event>
	</events>
	<actions>
		<action>
			<name><![CDATA[Import]]></name>
			<status>enabled</status>
		</action>
		<action>
			<name><![CDATA[Export]]></name>
			<status>enabled</status>
		</action>
		<action>
			<name><![CDATA[DuplicatesHandling]]></name>
			<status>enabled</status>
		</action>
	</actions>
	<relatedlists>
		<relatedlist>
			<function>get_related_list</function>
			<label>Service Requests</label>
			<sequence>1</sequence>
			<presence>0</presence>
			<actions>
				<action>ADD</action>
				<action>SELECT</action>
			</actions>
			<relatedmodule>HelpDesk</relatedmodule>
		</relatedlist>
		<relatedlist>
			<function>get_attachments</function>
			<label>Documents</label>
			<sequence>2</sequence>
			<presence>0</presence>
			<actions>
				<action>ADD</action>
				<action>SELECT</action>
			</actions>
			<relatedmodule>Documents</relatedmodule>
		</relatedlist>
	</relatedlists>
</module>
haha - 2025