The new Class Types

Dear Joe,

1. The New Class Type you added is very usefull, and it gives a big flexibilty for declaring the Account Types/Groups.

2. I changed the type of [ id, INT(11)         to  id, varchar(6) ]        in the chart_types
    I changed the type of [ Parent, INT(11)  to  Parent, varchar(6) ] in the chart_types

3. I changed the type of [ cid, Tynint(1)  to  cid, Tynint(3) ] in the chart_types

4. I Changed the type of " account_code " in chart_master and all the related fields from varchar[11]  to  varchar[15]

============ those are usefull changes and it give us an account nb looks like   PeachTree Accouting Software use   ===========

5. I failed to translate the PDF reports generated by REPGEN 2.1 with a UTF-8

    I'm using arabic language and I have an important problem & I think you already know it:

          The printed arabic letters appears like this:    شاشة 17 بوØμØ© .  It is a problem of uncoding.
         
          Is there any solution for this problem ?

Thanks for your help assistance

Hi,

Since I defined the Account types varchar(6) as (example) :
*      421
*      42110 ; 42120 are Sub-Types

then come the role of the account code as below :

*               42110150-12   ;  42110110-10   =====>   [ 42110 ] refers to the Parent Account Type & the [ 150-12 ] & [ 110-10 ] refers to the
                                                                                                                                                        running account_code

*      OR  simply 421103100 ; 421103200     =====>   [ 42110 ] refers to the Parent Account Type & the [ 3200 ] & [ 3200 ] refers to the
                                                                                                                                                         running account_code
                                                                                                                                                   
This Idea/Method will helps a lot when queyring at the different levels of Accounts Tree Structure with what is known
[ Account Roll Up feature ] in the widely reputable accounting software [ Peachtree ]. You may then, filter all the Transactions under the 42110 Account Type for example with a simple SQL Statment.

So practically, the account_code length is >= 9 char length According the account_type length (<=6 char).

Regarding FrontAccount Arabic Reports, the matter is resolved with what you mentionned and already I apply it and it works well.

But Again I wish/hope that a new version of REPGEN will support the UTF-8 charset soon. And surely if I resolved , I will post the solution.

/Kalido

RepGen 2.1 w/ Arabic (or utf-8) char Support:

in the repgen.inc (file exist in the Folder ../Modules/Repgen)

Go to around Line # 1253 , you will find :

       $rep->pdf = new Cpdf('A4');

Delete it & Replace it with the Following :

////////////////////////////////////////////////////////////////////////////      kalido
$l = array(
'a_meta_charset'   => strtoupper($_SESSION['language']->encoding),
'a_meta_dir'          => ($_SESSION['language']->dir === 'rtl' ? 'rtl' : 'ltr'),
'a_meta_language' => $code = $_SESSION['language']->code,
'w_page'               => 'page'
);

$rep->pdf = new Cpdf('A4',$l);
///////////////////////////////////////////////////////////////////////////    kalido

And " VOILA ", You will have RepGen Generate Reports Supporting the
Arabic Language as per the Standard Method That Generate them FrontAccount.

NB:
Surely, you need to install the Arabic Language Fonts from :

https://frontaccounting.com/wbt/pages/download/download-fonts.php

and install them as described per FrontAccount Authors.

Now :

I hope for the future that somebody made a Simple/Easy Payroll System and link it to FA as an Integrated Module.

Regards,

Kalido (Khaled)