76 Reply by tester1

(9 replies, posted in Wish List)

Let me try this one also

Go to forum: Wish List

77 Topic by tester1

(1 replies, posted in Wish List)

Closed Button

I want direct closed button on each listing page

Please let me know... Above link is of FA question only.

Go to forum: Wish List

78 Reply by tester1

(17 replies, posted in FA Modifications)

@ ostertagi , Dude i also shifted from MYSQL -> MYSQLI

But did u saw cancel_transaction(); thats Transactions

as we are using MySqli  hence in mysqli there  is default

mysqli_rollback and mysqli_commit  ...etc Transactions

Hence do we need to work out under includes/db/sql_functions.inc  for same ? ..

Please let me know ... also How an we try this as TRY {} CATCH {} ... which i have asked under : https://frontaccounting.com/punbb/viewtopic.php?id=4726

Go to forum: FA Modifications

79 Reply by tester1

(5 replies, posted in Wish List)

thanks Farhaj , if i get time will try to make it as per function ext.

Go to forum: Wish List

80 Reply by tester1

(9 replies, posted in Wish List)

at-least admin should reply on this ...

Go to forum: Wish List

81 Topic by tester1

(9 replies, posted in Wish List)

Can any one tell me

Try {} Catch {} Transaction for FA ?

I am using currently as :

db_query("START TRANSACTION");

$sqla ="INSERT INTO A () VALUES () ";
db_query($sqla);

$sqlb ="INSERT INTO B () VALUES () ";
db_query($sqlb);

$sqlCb ="UPDATE CB ()  SET ...   ";
db_query($sqlCb);

if ( $sqla and $sqlb and $sqlCb ) {
                db_query("COMMIT");
                echo display_notification_centered(_("Database transaction was successful."));
            } else {        
                db_query("ROLLBACK");
               echo display_notification_centered(_("transaction rolled back"));
                exit;
            }

I am Right ? ...

Can any one please tell me same in TRY .. CATCH ? ....

Go to forum: Wish List

82 Reply by tester1

(5 replies, posted in Wish List)

BTW which farhaj2 : 3 person listed

Go to forum: Wish List

83 Reply by tester1

(5 replies, posted in Wish List)

Hi Farhaj,

Thanks for reply , but luck i found the solution :

What i did is :

Under includes/ui/db_pager_view.inc

foreach($pager->data as $line_no => $row) {    

        $marker = $pager->marker;
        if ($marker && $marker($row)) 
                    
                if($row["statusid"] == A){
                start_row("class='overduebgA'");    
                }elseif($row["statusid"] == B){
                start_row("class='overduebgB'");         
                }elseif($row["statusid"] == C){
            start_row("class='overduebgC'");
                }elseif($row["statusid"] == D){
            start_row("class='overduebgD'");
                }elseif($row["statusid"] == E){
            start_row("class='overduebgE'");
                }else {
                  start_row("class='$pager->marker_class'");
                }

Note : row[statusid]    because its my Personal Page : ,

Also i let you know that i have made many such page which may or may not help FA .. will try to share all such page once i am done with my work .

Go to forum: Wish List

84 Topic by tester1

(5 replies, posted in Wish List)

Hi ,

Under 

manufacturing/search_work_orders.php

, Can we have multiple Color Ordering for Overdue Orders , By type or by Location as PER  required Date 

I have seen its PHP file :

$table->set_marker('check_overdue', _("Marked orders are overdue."));

Where check_overdue is a function , i have try writing if ..elseif .. if   condition in it but its taking Only ONE ROW ( that  FIRST IF condition as over marked color .

Kindly let me know what can be solution for it.

Go to forum: Wish List

85 Topic by tester1

(1 replies, posted in FA Modifications)

Can it possible in all pages where searching is filter or done ... should be done  through ENTER button ,

i means to say after typing some words or selecting some value from drop-down  all time i have to take my mouse over search button and click on it .. cant be it so simple thats after typing word and i press my keyboard button enter and it show me all y search result or directly while typing itself search happen .. like for drop-down or check-box etc.  ..

edit : RESET button , so that we can reset selected field

please have a look on this.

Go to forum: FA Modifications

86 Reply by tester1

(2 replies, posted in Wish List)

can you share the code with me

Go to forum: Wish List

87 Topic by tester1

(1 replies, posted in Wish List)

Can it possible in all pages where searching is filter or done ... should be done  through ENTER button ,

i means to say after typing some words or selecting some value from drop-down  all time i have to take my mouse over search button and click on it .. cant be it so simple thats after typing word and i press my keyboard button enter and it show me all y search result or directly while typing itself search happen .. like for drop-down or check-box etc.  ..

edit : RESET button , so that we can reset selected field

please have a look on this.

Go to forum: Wish List

88 Reply by tester1

(10 replies, posted in FA Modifications)

dude  that to done , but still not working sad

can you please try from youside ?

Go to forum: FA Modifications

89 Reply by tester1

(10 replies, posted in FA Modifications)

sorry , i was think like that , but no its not working for edit and add too ( as i changed edit and add  button function from button to input  as i did for delete ) but its not working its redirecting in sec .

but dont no its working perfect for delete ( as same function i tried for edit , but no luck )

Go to forum: FA Modifications

90 Reply by tester1

(12 replies, posted in FA Modifications)

I didnt got your above STEPS , will wait if u implement this .

Go to forum: FA Modifications

91 Reply by tester1

(10 replies, posted in FA Modifications)

i already tried this , not working :

but i got to know its because of BUTTON ( <button type='submit'  >) - if i use this then its redirected in 0 sec and not taking content='20 which i have set for meta_forward

but for <input type='submit' onclick='javascript: return testfunction();' > if click on this then redirection is waiting till 20sec.

let you know edit and add are on my Button  ( as per FA ), but i have change for delete ( instead of button i have used INPUT with type submit as define above  and have onlick function for popup ( " are you sure to delete this record ").

As FA directly allow to delete record without any warning , hence i made that .

Go to forum: FA Modifications

92 Reply by tester1

(10 replies, posted in FA Modifications)

dude listen , why i am using meta_forward().

i have made my own page.php ( page.php?id=1&trans_no=3)  which carries all information of id =1 ( from main.php ) as like parameter query string. i have my CRUD type area

as same like under manufacturing/search_work_orders.php? -- after editing any of your resp reference id you will be n page manufacturing/work_order_entry.php?trans_no=11  , now click update  now its change to /manufacturing/work_order_entry.php?UpdatedID=11 where you see many Anchor link like option ( Enter a new work order , Select an existing work order ) which means you have to now CLICK on this reps links.  which was very annoying for me for each records , hence i change hyperlink to metaforward function...

now all is working fine execpt that redirection second i:e  echo "<meta http-equiv='Refresh' content='20; url=$forward_to?$params'>\n";  which i change from 0 to 20sec ,

as if some one want to  see error or etc he can see at-least between 20 sec which i have set or may increase .. ( error or other message , as this is my own page hence after Clicking Update button i have set my own link, error message etc. )

hence it redirected between sec , and because of this some error if occurs is not seen.

Go to forum: FA Modifications

93 Reply by tester1

(12 replies, posted in FA Modifications)

i know dude FA is not CRUD , but its bit difficult for me to delete each single record one by one... as i need to delete record with one go or by checkbox selection

Go to forum: FA Modifications

94 Reply by tester1

(10 replies, posted in FA Modifications)

@ apmuthu  you are right i am done : echo "<meta http-equiv='Refresh' content='20; url=$forward_to?$params'>\n";

but redirecting is not happening as with 20 sec ... its redirect within 3-4 sec only... i dont why but its true.

" The function meta_forward() is used in 32 files in FA "  can you breif me about this ? .  i dont know which 32 file you are talking about ..

i have made my own Page.php and in that i am using meta_forward()

Go to forum: FA Modifications

95 Reply by tester1

(1 replies, posted in Wish List)

any one ?

Go to forum: Wish List

96 Reply by tester1

(10 replies, posted in FA Modifications)

any here ?.. please let me know

Go to forum: FA Modifications

97 Topic by tester1

(1 replies, posted in Wish List)

i need http://istockphp.com/demo/deleting-multiple-records/index.php ( demo purpose ) , some thing like this to build in FA area in all place where we have add edit delete  option...

Single delete of record is taking too much time .. can we have a checkbox as demo above where checking multiple records at a time for deletetions. which will save time also.

please implement this or any one have this please let me know .. as i need this urgently.

Go to forum: Wish List

98 Reply by tester1

(12 replies, posted in FA Modifications)

any one can helpme ?

i need http://istockphp.com/demo/deleting-multiple-records/index.php , some thing like this to build in FA area in all place where we have add edit delete ...

Single delete of record is taking too much time .. can we have a checkbox as demo above where checking multiple records at a time for deletetions

Go to forum: FA Modifications

99 Topic by tester1

(10 replies, posted in FA Modifications)

I am using meta_forward instead of hyperlink_no_params 


hyperlink_no_params : i have to click a link  which is too time consuming also it not good for long data entry process .

hence i have used meta_forward but redirecting is done quickly within 1-2 sec , and i am unable to see  error message.

i have set content='20 ( includes/ui/ui_controls.inc ) but its not working properly for meta_forward , i need 20 or 50 sec because i need to show some error message ( if its occurs ) .

any solution or update on this .. please check

Go to forum: FA Modifications

100 Reply by tester1

(4 replies, posted in Wish List)

ostertagi , thanks dude, what you had explain above . i have already research on it ...

thing is that after visiting po_class.inc file,, the coding format is too complicated .. franking its totally out of my head ..

hence i ask for a single page help from u all side

Go to forum: Wish List