ranafaraz

// globally override Bootstrap's behavior:
// Do this before you initialize any of your modals
$.fn.modal.Constructor.prototype.enforceFocus = function() {};

ranafaraz

-- Electrical Equipment / Office Equipment
SELECT 
	
	SUM(lad.netamttoinvoice) AS "2016-17",
	
	-- 2017 - 2018 - Started
	(SELECT 
		
		SUM(lad.netamttoinvoice) AS "2017-18"
		

ranafaraz

SELECT
	SUM(i.grandtotal) AS total_utilization
FROM
	adempiere.c_invoice i
	INNER JOIN adempiere.gl_budget b ON (( b.gl_budget_id = i.gl_budget_id ))
	INNER JOIN adempiere.c_invoiceline il ON (( il.c_invoice_id = i.c_invoice_id ))
	INNER JOIN adempiere.vwcharge vc ON (( vc.c_charge_id = il.c_charge_id ))
	INNER JOIN adempiere.vwchart vwc ON (( vwc.c_elementvalue_id = vc.account_id ))
WHERE
	i.isactive = 'Y'

ranafaraz

SELECT
	SUM(f.amt) AS allocated_budget
FROM
	adempiere.gl_fund f
	INNER JOIN adempiere.gl_budget b ON (( b.gl_budget_id = f.gl_budget_id ))
	INNER JOIN adempiere.vwchart vwc ON (( vwc.c_elementvalue_id = f.c_elementvalue_id ))
WHERE
	f.isactive = 'Y'
	AND
	f.ad_client_id = 1000000

ranafaraz

SELECT
	SUM(f.amt) AS allocated_budget
FROM
	adempiere.gl_fund f
	INNER JOIN adempiere.gl_budget b ON (( b.gl_budget_id = f.gl_budget_id ))
	INNER JOIN adempiere.vwchart vwc ON (( vwc.c_elementvalue_id = f.c_elementvalue_id ))
WHERE
	f.isactive = 'Y'
	AND
	f.ad_client_id = 1000000

ranafaraz

SELECT
	wh.documentno AS wh_docno,
	i.documentno AS invioce_docno,
	(SELECT t.name FROM adempiere.c_tax t WHERE t.c_tax_id = wh.c_tax_id) AS tax,
	(SELECT wt.name FROM adempiere.lco_withholdingtype wt WHERE wt.lco_withholdingtype_id = wh.lco_withholdingtype_id) AS wh_type,
	wh.wh_other_baseamt as base_amt,
	wh.wh_other_percent as wh_percent,
	wh.other_charge as deducted_amt,
	wh.description
FROM

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) {

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

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
	
	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