Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleSummary Page Using SQL
Image RemovedImage Added

 

Code Block
themeEclipse
languagexml
titleSummary Page Using SQL
<summary xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../xsd/summary.xsd">

	<title>Accounts Receivable<<title>key_accounts_receivable</title>

	<sql>FROM ACCOUNTSRECEIVABLE
		LEFT JOIN USERS CREATEDBY ON CREATEDBY.USERID = ACCOUNTSRECEIVABLE.ACCRECCREATEDBYUSERID
		LEFT JOIN USERS UPDATEDBY ON UPDATEDBY.USERID = ACCOUNTSRECEIVABLE.ACCRECUPDATEDBYUSERID
		LEFT JOIN OUUNITS CREATEDBYUNIT ON CREATEDBYUNIT.OUUID = ACCOUNTSRECEIVABLE.ACCRECCREATEDBYOUUID
		LEFT JOIN OUUNITS UPDATEDBYUNIT ON UPDATEDBYUNIT.OUUID = ACCOUNTSRECEIVABLE.ACCRECUPDATEDBYOUUID
		LEFT JOIN CONTACTINFORMATION ON CONTACTINFORMATION.CIID = ACCOUNTSRECEIVABLE.CIID
		INNER JOIN CONTACTINFODEFINITIONS ON CONTACTINFODEFINITIONS.CIDEFACTIVE = 1 AND CONTACTINFODEFINITIONS.CIDEFDELETED = 0
		LEFT JOIN ACCCLASSIFICATIONS ON ACCCLASSIFICATIONS.ACCCLASSID = ACCOUNTSRECEIVABLE.ACCCLASSID
		WHERE ACCOUNTSRECEIVABLE.ACCRECDELETED = 0
	</sql>

	<rowsperpage>20</rowsperpage>
	<primaryfield>ACCOUNTSRECEIVABLE.ACCRECID</primaryfield>
	<mainlinkfield>ACCOUNTSRECEIVABLE.ACCRECNUM</mainlinkfield>
	<orderbyfields>ACCOUNTSRECEIVABLE.ACCRECNUM</orderbyfields>
	<module>ACCOUNTS_RECEIVABLE</module>
	
	<fieldlist>
		<!-- external filters -->
		<field>
			<fieldname>ACCOUNTSRECEIVABLE.ACCRECID</fieldname>
			<filtertextoption>equal</filtertextoption>
		</field>

		<!-- fields -->
		<field>
			<fieldname>ACCOUNTSRECEIVABLE.ACCRECNUM</fieldname>
			<caption>No.<<caption>key_number</caption>
			<summary>true</summary>
			<filter>true</filter>
			<filteravailable>true</filteravailable>
			<filtertextoption>like</filtertextoption>
			<link>page.do?xml=accounts/accountReceivable&amp;act=itm&amp;jndi=ejb/CRMUIAccountReceivable&amp;fc=loadForm&amp;pv0=((ACCOUNTSRECEIVABLE.ACCRECID))&amp;pvc=1</link>
		</field>

		<field>
			<fieldname>ACCOUNTSRECEIVABLE.ACCRECNAME</fieldname>
			<caption>Name<<caption>key_name</caption>
			<summary>true</summary>
			<filter>true</filter>
		</field>
 
		... 
 
		<!-- drilldowns -->
		<field>
			<fieldname>BILLINGADDRESS</fieldname>
			<fieldfunction>''</fieldfunction>
			<caption>Billing Address<<caption>key_billing_address</caption>
			<summary>true</summary>
			<fieldtype>label</fieldtype>
			<label>Billing Address<<label>key_billing_address</label>
			<link>drilldown:accounts/accountReceivable_billingAddress;hidefilters~true~CONTACTINFORMATION.CIID~((ACCOUNTSRECEIVABLE.CIID))</link>
		</field>
 
		...
 
	</fieldlist>

	<actions>
		<action>
			<caption>New</caption>
			<topmenu>true</topmenu>
			<link>page.do?xml=accounts/accountReceivable&amp;act=new&amp;fc=createButton&amp;jndi=ejb/CRMUIAccountReceivable</link>
		</action>
 
		...

	</actions>
</summary>
Expand
titleSummary Page Using EJB Method
Image RemovedImage Added

 

Code Block
themeEclipse
languagexml
titleSummary Page Using EJB Method
<summary xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../xsd/summary.xsd">
    <title>Warehouse Balances</title>
    <summary>
	<title>key_stock_balances</title>
	<classname>ejb/CRMUIWarehouse</classname>
    <functionname>loadBalancesTab<	<functionname>loadStockBalances</functionname>
    	<rowsperpage>20</rowsperpage>
    <primaryfield>ITEMID<	<primaryfield>PRODID</primaryfield>
    <mainlinkfield>ITEMID</mainlinkfield>
    <autosearch>true</autosearch>
    <hidefindbutton>true</hidefindbutton>
    	<multiselect>true</multiselect>
	<mainlinkfield>PRODID</mainlinkfield>
	<module>INVENTORY_MANAGEMENT</module>
     
    <fieldlist>
        	<fieldlist>
		<!-- external filters -->
        <field>
            <fieldname>WRHID</fieldname>
            <filtertextoption>equal</filtertextoption>
        </field>
 
        <!-- fields		<field>
			<fieldname>PRODID</fieldname>
			<filtertextoption>equal</filtertextoption>
		</field>
		<!-- basic search -->
        <field>
            <fieldname>ITEMNAME</fieldname>
            <caption>Product Type</caption>
            <summary>true</summary>
            <available>true</available>
        </field>
 
        ...
 
        		
		<field>
			<fieldname>PRODID</fieldname>
			<caption>key_product</caption>
			<filter>true</filter>
			<filteravailable>true</filteravailable>
			<fieldtype>string</fieldtype>
			<filterlookupname>dataset;products.loadphysicalgoods;prodid;prodcode</filterlookupname>
		</field>
		
		...
		
		<field>
			<fieldname>PRODCODE</fieldname>
			<caption>key_product</caption>
			<summary>true</summary>
			<available>true</available>
		</field>
		...
		<!-- drilldowns -->
		<field>
			<fieldname>WAREHOUSES_DD</fieldname>
			<fieldfunction>''</fieldfunction>
			<caption>key_warehouses</caption>
			<summary>true</summary>
			<available>true</available>
			<fieldtype>label</fieldtype>
 ...
 
    			<label>key_warehouses</label>
			<link>drilldown:inventory/warehouse_stock_balance;PRODID~((PRODID))</link>
		</field> 
	</fieldlist>
</summary>