vtiger_account.xpj

<?xml version="1.0" encoding="UTF-8"?><biztoolcfg qryfmtOpCreate="SET @seq=0;SELECT SUBSTR(account_no,-5)+0 INTO @seq FROM vtigercrm6.vtiger_account ORDER BY account_no DESC LIMIT 0,1;SELECT CONCAT(Code_Prefix, LPAD((@seq + 1), 5, '0')) INTO @odn FROM vtigercrm6.xdoc_code WHERE docType='account';INSERT INTO %{TABLE} %{DATA};" qryfmtOpUpdate="" loadedClick="0" tableNm="vtiger_account" referLst="0" onLoadInit="0" tableTxt="vtiger_account" LstTP="Lst" lines2Link="" jointbls="1" header2Link="" exdata4select=""><DataLstExtElmt><![CDATA[<DbDetails><queryFormat xml:base="d:\Program Files (x86)\3UCS\3UCS Server\layout\biztools\mysqlcfg.xml" id="tbpages">select %{data} from %{dbtable} %{where} limit %{StartRow},%{PgSize}</queryFormat></DbDetails>]]></DataLstExtElmt><Ctrls><Ctrl noquery="1" nomodify="1" ctrlhide="1" name="account_no" insertparam="@odn" noUpdate="1"/><Ctrl Required="1" name="accountname"/><Ctrl ctrldbname="vtigercrm6." name="parentid" ctrldbtable="vtiger_account" xTp="ComboBox" ctrldbdata="accountname,accountid" ctrldbdatarel="accountid" ctrltype="ComboBox"><extattr><![CDATA[ onload="init"]]></extattr><addon><![CDATA[<MagicCtrl Name="refresh%{colNm}" Link="tip:刷新" images=",data/refresh.png" button="type:0" Size="20,20"><OnClick><submit next="%{colNm}"/></OnClick></MagicCtrl>\r\n]]></addon></Ctrl><Ctrl ctrldbname="vtigercrm6." name="rating" ctrldbtable="vtiger_rating" xTp="ComboBox" ctrldbdata="rating,rating_id" ctrldbdatarel="rating_id" ctrltype="ComboBox"><extattr><![CDATA[ onload="init"]]></extattr></Ctrl><Ctrl ctrldbname="vtigercrm6." name="industry" ctrldbtable="vtiger_industry" xTp="ComboBox" ctrldbdata="industry,industryid" ctrldbdatarel="industryid" ctrltype="ComboBox"><extattr><![CDATA[ onload="init"]]></extattr><addon><![CDATA[<MagicCtrl Name="refresh%{colNm}" Link="tip:刷新" images=",data/refresh.png" button="type:0" Size="20,20"><OnClick><submit next="%{colNm}"/></OnClick></MagicCtrl>\r\n]]></addon></Ctrl><Ctrl ctrldbname="vtigercrm6." name="account_type" ctrldbtable="vtiger_accounttype" xTp="ComboBox" ctrldbdata="accounttype,accounttypeid" ctrldbdatarel="accounttypeid" ctrltype="ComboBox"><extattr><![CDATA[ onload="init"]]></extattr><addon><![CDATA[<MagicCtrl Name="refresh%{colNm}" Link="tip:刷新" images=",data/refresh.png" button="type:0" Size="20,20"><OnClick><submit next="%{colNm}"/></OnClick></MagicCtrl>\r\n]]></addon></Ctrl><Ctrl noquery="1" name="annualrevenue" xTp="TextBox" ctrltype="TextBox"/><Ctrl noquery="1" name="employees" xTp="TextBox" ctrltype="TextBox"/><Ctrl name="website" xTp="TextBox" ctrltype="TextBox"/><Ctrl name="phone" xTp="TextBox" ctrltype="TextBox"/><Ctrl name="otherphone" xTp="TextBox" ctrltype="TextBox"/><Ctrl name="fax" xTp="TextBox" ctrltype="TextBox"/><Ctrl noquery="1" name="email1" xTp="TextBox" ctrltype="TextBox"/><Ctrl noquery="1" name="email2" xTp="TextBox" ctrltype="TextBox"/><Ctrl noquery="1" name="emailoptout" xTp="CheckBox" ctrltype="CheckBox"/><Ctrl name="ownership" xTp="TextBox" ctrltype="TextBox"/><Ctrl noquery="1" name="notify_owner" xTp="CheckBox" ctrltype="CheckBox"/><Ctrl noquery="1" nomodify="1" ctrlhide="1" name="isconvertedfromlead" noInsert="1" noUpdate="1" xTp="CheckBox" ctrltype="CheckBox"/><Ctrl noquery="1" nomodify="1" ctrlhide="1" name="accountid" noInsert="1" noInAndUp="1" noUpdate="1" xTp="TextBox" ctrltype="TextBox"/><Ctrl noused="1" noquery="1" name="siccode" xTp="TextBox" ctrltype="TextBox"/><Ctrl noused="1" name="tickersymbol" xTp="TextBox" ctrltype="TextBox"/><Ctrl noquery="1" ctrldbname="vtigercrm6." ctrlhide="1" name="created_by" insertparam="'%{user_id}'" ctrldbtable="vtiger_users" noUpdate="1" ctrldbdata="user_name,id" ctrldbdatarel="id"/><Ctrl noquery="1" ctrlhide="1" name="creation_date" insertparam="now()" noUpdate="1"/><Ctrl noquery="1" ctrldbname="vtigercrm6." ctrlhide="1" name="last_update_by" insertparam="'%{user_id}'" ctrldbtable="vtiger_users" updateparam="'%{user_id}'" ctrldbdata="user_name,id" ctrldbdatarel="id"/><Ctrl noquery="1" ctrlhide="1" name="last_update_date" insertparam="now()" updateparam="now()"/></Ctrls></biztoolcfg>