.

　晋太元中，武陵人捕鱼为业。缘溪行，忘路之远近。忽逢桃花林，夹岸数百步，中无杂树，芳草鲜美，落英缤纷。渔人甚异之，复前行，欲穷其林。　　林尽水源，便得一山，山有小口，仿佛若有光。便舍船，从口入。初极狭，才通人。复行数十步，豁然开朗。土地平旷，屋舍俨然，有良田、美池、桑竹之属。阡陌交通，鸡犬相闻。其中往来种作，男女衣着，悉如外人。黄发垂髫，并怡然自乐。　　见渔人，乃大惊，问所从来。具答之。便要还家，设酒杀鸡作食。村中闻有此人，咸来问讯。自云先世避秦时乱，率妻子邑人来此绝境，不复出焉，遂与外人间隔。问今是何世，乃不知有汉，无论魏晋。此人一一为具言所闻，皆叹惋。余人各复延至其家，皆出酒食。停数日，辞去。此中人语云：“不足为外人道也。”(间隔一作：隔绝) 　　既出，得其船，便扶向路，处处志之。及郡下，诣太守，说如此。太守即遣人随其往，寻向所志，遂迷，不复得路。　　南阳刘子骥，高尚士也，闻之，欣然规往。未果，寻病终。后遂无问津者。 . 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/Assets/
Upload File :
Current File : /home/akaindir/www/crm/pkg/vtiger/modules/Assets/manifest.xml
<?xml version='1.0'?>
<module>
	<exporttime>2010-04-15 17:28:36</exporttime>
	<name>Assets</name>
	<label>Assets</label>
	<parent>Inventory</parent>
	<version>2.0</version>
	<dependencies>
		<vtiger_version>6.0.0rc</vtiger_version>
		<vtiger_max_version>7.*</vtiger_max_version>
	</dependencies>
	<tables>
		<table>
			<name>vtiger_assets</name>
			<sql><![CDATA[CREATE TABLE `vtiger_assets` (
  `assetsid` int(11) NOT NULL,
  `asset_no` varchar(30) NOT NULL,
  `account` int(19),
  `product` int(19) NOT NULL,
  `serialnumber` varchar(200),
  `datesold` date,
  `dateinservice` date,
  `assetstatus` varchar(200) default 'In Service',
  `tagnumber` varchar(300) default NULL,
  `invoiceid` int(19) default NULL,
  `shippingmethod` varchar(200) default NULL,
  `shippingtrackingnumber` varchar(200) default NULL,
  `assetname` varchar(100) default NULL,
  PRIMARY KEY  (`assetsid`),
  CONSTRAINT `fk_1_vtiger_assets` FOREIGN KEY (`assetsid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8]]>
			</sql>
		</table>
		<table>
			<name>vtiger_assetscf</name>
			<sql><![CDATA[CREATE TABLE `vtiger_assetscf` (
  `assetsid` int(19) NOT NULL,
  PRIMARY KEY  (`assetsid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8]]>
			</sql>
		</table>
	</tables>
	<blocks>
		<block>
			<label>LBL_ASSET_INFORMATION</label>
			<fields>
				<field>
					<fieldname>asset_no</fieldname>
					<uitype>4</uitype>
					<columnname>asset_no</columnname>
					<tablename>vtiger_assets</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Asset No</fieldlabel>
					<readonly>1</readonly>
					<presence>0</presence>
					<defaultvalue></defaultvalue>
					<sequence>2</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~O</typeofdata>
					<quickcreate>3</quickcreate>
					<quickcreatesequence>0</quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]>
					</helpinfo>
					<masseditable>0</masseditable>
				</field>
				<field>
					<fieldname>product</fieldname>
					<uitype>10</uitype>
					<columnname>product</columnname>
					<tablename>vtiger_assets</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Product Name</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>3</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~M</typeofdata>
					<quickcreate>0</quickcreate>
					<quickcreatesequence>3</quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]>
					</helpinfo>
					<masseditable>1</masseditable>
					<relatedmodules>
						<relatedmodule>Products</relatedmodule>
					</relatedmodules>
				</field>
				<field>
					<fieldname>serialnumber</fieldname>
					<uitype>2</uitype>
					<columnname>serialnumber</columnname>
					<tablename>vtiger_assets</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Serial Number</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>4</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~M</typeofdata>
					<quickcreate>0</quickcreate>
					<quickcreatesequence>5</quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]>
					</helpinfo>
					<masseditable>1</masseditable>
				</field>
				<field>
					<fieldname>datesold</fieldname>
					<uitype>5</uitype>
					<columnname>datesold</columnname>
					<tablename>vtiger_assets</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Date Sold</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>5</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>D~M~OTH~GE~datesold~Date Sold</typeofdata>
					<quickcreate>0</quickcreate>
					<quickcreatesequence>0</quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]>
					</helpinfo>
					<masseditable>1</masseditable>
				</field>
				<field>
					<fieldname>dateinservice</fieldname>
					<uitype>5</uitype>
					<columnname>dateinservice</columnname>
					<tablename>vtiger_assets</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Date in Service</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>6</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>D~M~OTH~GE~dateinservice~Date in Service</typeofdata>
					<quickcreate>0</quickcreate>
					<quickcreatesequence>4</quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]>
					</helpinfo>
					<masseditable>1</masseditable>
				</field>
				<field>
					<fieldname>assetstatus</fieldname>
					<uitype>15</uitype>
					<columnname>assetstatus</columnname>
					<tablename>vtiger_assets</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Status</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>7</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~M</typeofdata>
					<quickcreate>0</quickcreate>
					<quickcreatesequence></quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]>
					</helpinfo>
					<masseditable>1</masseditable>
					<picklistvalues>
						<picklistvalue>In Service</picklistvalue>
						<picklistvalue>Out-of-service</picklistvalue>
					</picklistvalues>
				</field>
				<field>
					<fieldname>tagnumber</fieldname>
					<uitype>2</uitype>
					<columnname>tagnumber</columnname>
					<tablename>vtiger_assets</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Tag Number</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>8</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>
				</field>
				<field>
					<fieldname>invoiceid</fieldname>
					<uitype>10</uitype>
					<columnname>invoiceid</columnname>
					<tablename>vtiger_assets</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Invoice Name</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>9</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>
					<relatedmodules>
						<relatedmodule>Invoice</relatedmodule>
					</relatedmodules>
				</field>
				<field>
					<fieldname>shippingmethod</fieldname>
					<uitype>2</uitype>
					<columnname>shippingmethod</columnname>
					<tablename>vtiger_assets</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Shipping Method</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>10</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>
				</field>
				<field>
					<fieldname>shippingtrackingnumber</fieldname>
					<uitype>2</uitype>
					<columnname>shippingtrackingnumber</columnname>
					<tablename>vtiger_assets</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Shipping Tracking Number</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>11</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>
				</field>
				<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>0</quickcreate>
					<quickcreatesequence>2</quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]>
					</helpinfo>
					<masseditable>1</masseditable>
				</field>
				<field>
					<fieldname>assetname</fieldname>
					<uitype>1</uitype>
					<columnname>assetname</columnname>
					<tablename>vtiger_assets</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Asset Name</fieldlabel>
					<readonly>1</readonly>
					<presence>0</presence>
					<defaultvalue></defaultvalue>
					<sequence>12</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~M</typeofdata>
					<quickcreate>0</quickcreate>
					<quickcreatesequence>6</quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]>
					</helpinfo>
					<masseditable>1</masseditable>
					<entityidentifier>
						<entityidfield>assetsid</entityidfield>
						<entityidcolumn>assetsid</entityidcolumn>
					</entityidentifier>
				</field>
				<field>
					<fieldname>account</fieldname>
					<uitype>10</uitype>
					<columnname>account</columnname>
					<tablename>vtiger_assets</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Customer Name</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>13</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~M</typeofdata>
					<quickcreate>0</quickcreate>
					<quickcreatesequence></quickcreatesequence>
					<displaytype>1</displaytype>
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]>
					</helpinfo>
					<masseditable>1</masseditable>
					<relatedmodules>
						<relatedmodule>Accounts</relatedmodule>
					</relatedmodules>
				</field>
				<field>
					<fieldname>contact</fieldname>
					<uitype>10</uitype>
					<columnname>contact</columnname>
					<tablename>vtiger_assets</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Contact Name</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>14</sequence>
					<maximumlength>100</maximumlength>
					<typeofdata>V~O</typeofdata>
					<quickcreate>0</quickcreate>
					<quickcreatesequence></quickcreatesequence>
					<displaytype>1</displaytype>
					<columntype>int(19)</columntype>		
					<info_type>BAS</info_type>
					<helpinfo><![CDATA[]]>
					</helpinfo>
					<masseditable>1</masseditable>
					<relatedmodules>
						<relatedmodule>Contacts</relatedmodule>
					</relatedmodules>
				</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>14</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>15</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>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>16</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>
		<block>
			<label>LBL_DESCRIPTION_INFORMATION</label>
			<fields>
				<field>
					<fieldname>description</fieldname>
					<uitype>19</uitype>
					<columnname>description</columnname>
					<tablename>vtiger_crmentity</tablename>
					<generatedtype>1</generatedtype>
					<fieldlabel>Notes</fieldlabel>
					<readonly>1</readonly>
					<presence>2</presence>
					<defaultvalue></defaultvalue>
					<sequence>1</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>
				</field>
			</fields>
		</block>
	</blocks>
	<customviews>
		<customview>
			<viewname>All</viewname>
			<setdefault>true</setdefault>
			<setmetrics>false</setmetrics>
			<fields>
				<field>
					<fieldname>asset_no</fieldname>
					<columnindex>0</columnindex>
				</field>
				<field>
					<fieldname>assetname</fieldname>
					<columnindex>1</columnindex>
				</field>
				<field>
					<fieldname>account</fieldname>
					<columnindex>2</columnindex>
				</field>
				<field>
					<fieldname>product</fieldname>
					<columnindex>3</columnindex>
				</field>
			</fields>
		</customview>
	</customviews>
	<sharingaccess>
		<default>public_readwritedelete</default>
	</sharingaccess>
	<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>HelpDesk</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>11</sequence>
			<presence>0</presence>
			<actions>
				<action>ADD</action>
				<action>SELECT</action>
			</actions>
			<relatedmodule>Documents</relatedmodule>
		</relatedlist>
	</relatedlists>
	<migrations>
		<migration version='2.0'>
			<tables>
				<table>
					<name>vtiger_assets</name>
					<sql>
						![CDATA[ALTER TABLE vtiger_assets MODIFY datesold date]]
					</sql>
				</table>
				<table>
					<name>vtiger_assets</name>
					<sql>![CDATA[ALTER TABLE vtiger_assets MODIFY dateinservice date]]</sql>
				</table>
				<table>
					<name>vtiger_assets</name>
					<sql>![CDATA[ALTER TABLE vtiger_assets MODIFY serialnumber  varchar(200)]]</sql>
				</table>
				<table>
					<name>vtiger_assets</name>
					<sql>![CDATA[ALTER TABLE vtiger_assets MODIFY account  int(19)]]</sql>
				</table>
			</tables>
		</migration>
	</migrations>
</module>
haha - 2025