Grab Data of individual Accounts From Database (Page 1 of 2)

hey,

i have upload a image for you to what i want

https://imgur.com/a/crjzGJe

in this image the red box that i want to grab the amounts in separate page or top of the each page

if you guide me about 1 section then we will grab for anything that we want

because our client dont want to see the long TB / BS they want short report

i mean

TOTAL CURRENT ASSETS
TOTAL LTA

TOTAL ASSETS

SAME GOES IN TB OR B/S

help me its urgent

regards

i have already seen it but i think i cant explain clearly;

i make a page of short_tb.php & short_pls.php & short_bs.php

and here i want to show TB in short form like all head total like:

Current assets & LTA = Assets
Current liabilities & LTL = Liabilities
Sales = Sales
Expenses = Expenses

its mean i want to show only main head in different pages.

how can i do that? if i am not clear to you let me know

hey, thanks for reply me well i will look as soon as possible
but kindly take a look this balance sheet

https://www50.zippyshare.com/v/O06EKLTt/file.html

and screenshot is here: https://imgur.com/a/FqJ6Mhg

in this bs.php file its grab account_class all to all

can you please tell me or do it can we get only 1 account via giving account_class id e.g 1 or account code 1200 for current assets

please take a look and tell me...

regards

@emiangel839 - Regarding your comment on my site. here I answered you with the query. 

 $today = Today();
    $begin = begin_fiscalyear();
    $begin1 = date2sql($begin);
    $today1 = date2sql($today);
    $sql = "SELECT SUM(amount) AS total, c.class_name, c.ctype FROM
        ".TB_PREF."gl_trans,".TB_PREF."chart_master AS a, ".TB_PREF."chart_types AS t, 
        ".TB_PREF."chart_class AS c WHERE
        account = a.account_code AND a.account_type = t.id AND t.class_id = c.cid AND c.cid=1 
        AND IF(c.ctype > 3, tran_date >= '$begin1', tran_date >= '0000-00-00') 
        AND tran_date <= '$today1'  ORDER BY c.cid"; 
    $result = db_query($sql, "Transactions could not be calculated");

hope it helps you

thanks but see my image what exactly i want

well bro, again i am trying to make a BLOCK that shows only AMOUNT/BALANCES of ACCOUNTS,
see example of image

https://imgur.com/a/xVpxAQr

the balances will be linked with Trial Balance show we can easily grab any amount/balance what we want in future

the main reason is when we grab balances or amounts from TB then afterwards we calculate the RATIO ANALYSIS

so firstly, i want to grab INDIVIDUAL BALANCE that shown in image TB,

see image

Regards

not working....

hey,

i am using this : $AR = get_balance(1065, 0, 0, begin_fiscalyear(), Today(), true, true)['balance'];

here AR is Account Receivable and ID code is 1065

can you please tell me how can i get data without using 1065 because every time 1065 not equal to account receivable

any help

Can you please guide me because i am unable to fetch this... hope so you can

Note that array element inline addressing is available in later versions of PHP only.

The function get_balance() is defined from Line 316 of gl/includes/db/gl_db_trans.inc and it;s prototype is:

function get_balance($account, $dimension, $dimension2, $from, $to, $from_incl=true, $to_incl=true) 

The computed data fields available are: credit, debit and balance.

Note that this file has had a commit recently and you may need to update it accordingly.

@emiangel -  You can do it simply by adding this one.

    WHERE trans.account=coa.account_code  

Here add it like this

    WHERE trans.account=coa.account_code AND trans.account=".db_escape($account)." 

Hope it connects the account code and gets what you needed