ranafaraz

// Call out to hit Account Book of IUB
		
			@SuppressWarnings("resource")
				public String account_book_api(Properties ctx, int WindowNo, GridTab mTab,
						GridField mField, Object value, Object oldValue) throws IOException
				{
					int c_invoice_id = Integer.parseInt((String) mTab.getValue("c_invoice_id").toString());
					
					String sql = "SELECT " + 
							"i.c_invoice_id AS Trans_ID," +

ranafaraz

SELECT SUM(mp.market_price) FROM adempiere.market_price mp WHERE mp.ad_client_id = 1000000 AND mp.isactive = 'Y'
--

ranafaraz

SELECT 
	
	b.name AS Bank_Name,
	
	bacct.accountno,
	
-- 	COUNT(bacct.c_bankaccount_id),
-- 	SUM(ob.currentbalance)
	
	bacct.bankaccounttype,

ranafaraz

SELECT
	concat(vwc.majorheadvalue, ' - ', vwc.majorhead),
	
	SUM(f.amt) AS Current_Allocation
FROM
	gl_fund f
	INNER JOIN ad_org o ON (( o.ad_org_id = f.ad_org_id))
	INNER JOIN gl_budget b ON (( b.gl_budget_id = f.gl_budget_id ))
	INNER JOIN f_vwchart vwc ON (( vwc.c_elementvalue_id = f.c_elementvalue_id ))
	

ranafaraz

SELECT

	i.documentno AS Invoice_No,
	p.documentno AS Payment_No,
	concat(bacct.name, ' - ', bacct.accountno) AS Bank_Acct,
	concat(ev.value, ' - ', ev.name) AS Charge_Head,
	concat(o.value, ' - ', o.name) AS Charge_Org,
	i.dateinvoiced,
	i.dateacct,
	bp.value AS Search_Key,

ranafaraz

SELECT 
	ep.title AS Equipment_Type,
	e.title AS Equipment,
	e.picture
	
FROM 
equipments e
INNER JOIN equipements_type ep ON (( ep.id = e.type_id ))

GROUP BY

ranafaraz

SELECT
	
	concat(o.value, ' - ', o.name) AS Org,
	concat(vwc.majorheadvalue, ' - ', vwc.majorhead) AS MajorHead,
	concat(vwc.minorheadvalue, ' - ', vwc.minerhead) AS MinorHead,
	concat(vwc.subheadvalue, ' - ', vwc.subhead) AS SubHead,
	concat(vwc.value, ' - ', vwc.name) AS BudgetHead,
	SUM(f.amt) AS Allocation,
	SUM(i.grandtotal) AS Utilization
FROM

ranafaraz

SELECT
	l.value, -- Unique Identifier of Land
	l.name, -- Name of the Land
	l.description,
	l.location,
	(SELECT c.name FROM city c WHERE c.city_id = l.city_id) AS city,
	l.longitude,
	l.latitude,
	l.dimentions,
	(SELECT u.name FROM c_uom u WHERE u.c_uom_id = l.c_uom_id) AS uom,

ranafaraz

SELECT
	bi.value, -- Unique Identifier for Buildings & Infrastructures.
	bi.name, -- Name of the Building or Infrastructure.
	bi.description,
	bi.location,
	(SELECT cm.name FROM f_campus cm WHERE cm.f_campus_id = bi.f_campus_id) AS Campus,
	(SELECT c.name FROM city c WHERE c.city_id = bi.city_id) AS city,
	bi.longitude,
	bi.latitude,
	bi.dimentions,

ranafaraz

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "idempiere";

// Creating connection with MySQL - Local DB
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {