I have tried that ....but as said ...value in column are coming form function within function ....
allow me some time ...i will post my whole CODE of resp. page .... here so that you can to test from your end .... for future development ....
1 09/06/2016 09:52:06 am
Re: ASC/DESC on 'fun' / 'ord' NOT WORKING (9 replies, posted in FA Modifications)
2 09/06/2016 06:31:00 am
Re: ASC/DESC on 'fun' / 'ord' NOT WORKING (9 replies, posted in FA Modifications)
Hey,
BRO, my all value are coming properly .... as i need from functions .... just ASC/DESC not happening..
yes that was typo error.... which i have corrected
3 09/06/2016 04:56:29 am
Re: ASC/DESC on 'fun' / 'ord' NOT WORKING (9 replies, posted in FA Modifications)
bro ,
i tried that to but not working ....
also what is in function i have called another function value .... then it not work
i means to say
function sumplp2($row){
$p1 = function p1val($row);
$p2 = function p2val($row);
$totalp1p2 = $p1['p1'] + $p2['p2'] ;
return $totalp1p2 ;
}
above one not work only ... you try your self also ....
thanks
4 09/02/2016 11:29:39 am
Re: Broken ajax functionality in newer php installation (4 replies, posted in Report Bugs here)
Yes ,
@ apmuthu your right
; Always populate the $HTTP_RAW_POST_DATA variable. PHP's default behavior is
; to disable this feature and it will be removed in a future version.
; If post reading is disabled through enable_post_data_reading,
; $HTTP_RAW_POST_DATA is *NOT* populated.
; http://php.net/always-populate-raw-post-data
always_populate_raw_post_data = -1
its should be made -1,
as when i install new version of WAMP ( which came latest php/mysql version ) ....
my edit / add function was taking to much time ...
i did above changes in php.ini..... and it solved my solution .....
but still struggle to find solution for bigger result 
5 09/02/2016 11:21:03 am
Re: ASC/DESC on 'fun' / 'ord' NOT WORKING (9 replies, posted in FA Modifications)
@apmuthu,
Thanks For reply ....
i have return " return $sql; " which same done in sales_orders_view.php.
in my case : my column result output from a function ( sumplp2 ) : _("p1+p2")=>array('align'=>'center','fun'=>'sumplp2','ord'=>'')
where in sales/inquiry....
_("Order Total") => array('type'=>'amount', 'ord'=>''), --- this result is coming from its sql statement ...not from any Function.
i even try putting 'type'=>'amount' thats : _("p1+p2")=>array('align'=>'center','fun'=>'sumplp2','type'=>'amount', 'ord'=>'')
but still no solution .... when i click on my column name its dont perform any asc/desc just clicking happen
please help me ....
6 09/02/2016 04:58:06 am
Re: ASC/DESC on 'fun' / 'ord' NOT WORKING (9 replies, posted in FA Modifications)
Any solution on above section ......please let me know anyone ....
7 09/01/2016 12:04:08 pm
Topic: ASC/DESC on 'fun' / 'ord' NOT WORKING (9 replies, posted in FA Modifications)
$result = get_prodlist();
$cols = array(
'id'=>'skip',
_("Sr.No.")=>array('align'=>'center','ord'=>''),
_("Name")=>array('align'=>'center'),
_("Wgh")=>array('align'=>'center'),
_("p1")=>array('align'=>'center'),
_("p2")=>array('align'=>'center'),
_("p1+p2")=>array('align'=>'center','fun'=>'sumplp2','ord'=>'')
);
$table =&new_db_pager('prodtable', $result, $cols, 'prodtable','id',10);
$table->width = "99%";
display_db_pager($table);
-----BELOW IS FUNCTION -------
function sumplp2($row){
$p1 = $row['p1'];
$p2 = $row['p2'];
$totalp1p2 = $p1 + $p2 ;
return $totalp1p2 ;
}
THAT COLUMN DONT DO ASC/DESC - ordering .... any solution why function 'ord' column are not working for asc/desc
8 09/01/2016 11:48:07 am
Re: FA WITH AUTOCOMPLETE DOWNLOAD (36 replies, posted in FA Modifications)
link not working ....can u share it again
9 09/01/2016 11:43:04 am
Re: Latest Bootstrap theme with chat functionality. (3 replies, posted in FA Modifications)
Can you share the code ? ..or can u PM me ....
10 09/01/2016 11:39:12 am
Re: Performance issues (11 replies, posted in FA Modifications)
FA get slow... i have using FA from latest 3 years ...and i seen its take much time to load many pages .... specially that function db_pager .....
its requested to ADMIN to see FA indexing ...ajax ...load ..etc proper ...i have more then 3gb data ...its take 7-8min time to load for some pages ... i have increase many setting in php.inc etc ...
11 03/30/2016 07:18:56 am
Re: F.A Get Hangs/Freeze (10 replies, posted in Report Bugs here)
any one here ????
please help
thanks
12 03/28/2016 11:11:45 am
Re: F.A Get Hangs/Freeze (10 replies, posted in Report Bugs here)
Hi,
I am using 2.3.22 version
But after a lot of here and there i think i found solution ....
I have a custom page where i have include all file which is require by FA ... i started trying to comment one by one all include file so to find solution ...i know hiding include file might causing many Waring error message but i handle that to by including error file... and after a long time i found that below include file was causing freeze issue of other tabs i dont know why but its true
include($path_to_root . "/includes/session.inc");
now if u guys know actually reason as of on above include file then let me know so that i can try same
13 03/22/2016 06:20:49 am
Re: F.A Get Hangs/Freeze (10 replies, posted in Report Bugs here)
@ apmuthu ..thanks for reply
i am using default theme only , as our s.w doesn't depend on themes to much....
i am not getting ..i tried to many research on this ..but still not getting any solution ....
If I search for result ..and click on sales tab or any other tab or any other links ..it do not open until my search result is fetch or display ...
i think ..there might be any table lock or and lock system in default theme ..which is causing such issue
even i tried different server ..but issue is still same...
please help me ...as from last 4 month i am gone mad on this....
14 03/21/2016 06:09:41 am
Re: F.A Get Hangs/Freeze (10 replies, posted in Report Bugs here)
@apmuthu .. i think index is done proper... my question is why my other page / tabs get hang/freeze or do not open due to other query running
@kvvaradha can u please help me ...by providing more details on it ..i means how i can increase mysql server speed ...
i have more the lacs of records and my database size is near to 1.8/2 gb
15 03/19/2016 06:02:18 am
Topic: F.A Get Hangs/Freeze (10 replies, posted in Report Bugs here)
Hi,
We have more then Lacs of records in our one History table ( which is custom )
when i search any records from above history table ..whole s.w get freeze until its result is not display ..
even none of the TABS(SALES,PURCHASE ..ETC ) OPEN ,UNTIL result is display ....
what may be issue ...might be your any of your in-build table-locking system programming is causing such issue ?.
PLease help me ..as its bigger issue for me
16 02/11/2016 11:31:53 am
Re: FA Planet announced (www.faplanet.pl) (17 replies, posted in FA Modifications)
Can You please share the working link ?
17 10/26/2015 09:33:03 am
Topic: Backup and Restore Database (2 replies, posted in Report Bugs here)
Hi,
My database is currently more then 400mb of size but when i am trying to take backup of database from Backup and Restore Database.
when i click Create Backup ..ITS STARTED but after 10min its suddenly stop and there is no backup of database and nor any error message display in page ...early when database size was near to 25mb it was happening ...but suddenly its has stop
please let me know what i have to do ...
18 11/14/2014 08:54:24 am
Re: Pagination (4 replies, posted in Wish List)
@ kvvaradha did you made ? above pagination ... if so please share the code
19 11/06/2014 07:13:08 am
Re: Sr.No Not coming Properly (1 replies, posted in FA Modifications)
Even tried : _("Sr.No.")=>array('align'=>'center','ord'=>'desc')
20 11/06/2014 07:02:05 am
Topic: Sr.No Not coming Properly (1 replies, posted in FA Modifications)
I want to show list of my product as below :
Sr.No | Name | Type
--------------------
1 | aa | 2
2 | bb | 2
3 | cc | 3
4 | dd | 2
5 | cc | 4
**But its coming as below **
Sr.No | Name | Type
--------------------
3 | aa | 2
5 | bb | 2
1 | cc | 3
4 | dd | 2
2 | cc | 4
Its not that i want order by name , i just want normal sr.no as per entry .. means if i add any entry first then sr.no 1 , 2 , 3 and so on..
But when i add any new entry then its sr.no get changed but it should get last sr.no
Below is what i have tried :
SELECT (@cnt := @cnt + 1) AS rowNumber, orn.name, orn.type , u.*
FROM ofr AS u
CROSS JOIN (SELECT @cnt := 0) AS dummy
LEFT JOIN or_name AS orn ON u.id=orn.id
GROUP BY u.id ORDER BY rowNumber AND u.add_datetime DESCListing is call in below way :
$result = get_details()
$cols = array(
_("Sr.No.")=>array('align'=>'center'),
_("Name")=>array('align'=>'center'),
_("Type")=>array('align'=>'center')
);
$table =& new_db_pager('tablename', $result, $cols, 'ofr','id',10);
$table->width = "95%";
display_db_pager($table);**Database :**
id : bigint(20) UNSIGNED No None AUTO_INCREMENT
21 11/06/2014 06:37:29 am
Re: Navigation : Sorting by ( ASC / DESC ) (21 replies, posted in Report Bugs here)
no i haven't search and replace ... i have done manually
and btw we have to do just in one single page and thats " includes/db/connect_db.inc " so there is no such issue of mysqli becoming mysqlii
22 11/06/2014 06:18:52 am
Re: Pagination (4 replies, posted in Wish List)
Also would like to see Sr.No extra column on each entry list page
23 11/03/2014 09:04:31 am
Topic: Dateformat DDMMYYYY Not Working (2 replies, posted in Report Bugs here)
Hi yes when i set above dateformat DDMMYYYY then MM is taken as DD only
ex: suppose 3/11/2014 - DD/MM/YYYY and when i change the data then it becomes 3/14/2014 , 3/24/2014 etc etc ...
why so please check
24 11/03/2014 05:18:07 am
Re: Pagination (4 replies, posted in Wish List)
Yes sure .. will love to see this ..
25 11/03/2014 04:43:27 am
Re: Navigation : Sorting by ( ASC / DESC ) (21 replies, posted in Report Bugs here)
i am using mysqli ...
what u means it would have become mysqlii ...
can u please help me