Search options (Page 193 of 247)

Line 149 in inventory/manage/items.php states:

        display_error( _('The item code cannot contain any of the following characters -  & + OR a space OR quotes'));

Actually the hyphen / minus ("-") character is allowed in Item Codes (stock_id). Also allowed is the underscore character ("_").

The theme grayred is being erroneously distributed in the repo as greyred. This was reported by the fork Chia-KY of my unofficial github fork where it has now been committed.

Come fork (and join the 41 forks in place already - screenshot attached) and contribute!

Items like "Pipe 15 ft long" in the Item description displays fine. But if the abbreviation of feet as as an apostrophe / single quote is used, then it gets entered into the table as ' instead.

Hence the Item: "Pipe 15' long" now becomes "Pipe 15' long"

This is due to the way function db_escape() is programmed in includes/db/connect_db.inc.

function db_escape($value = "", $nullify = false)
{
    $value = @html_entity_decode($value, ENT_QUOTES, $_SESSION['language']->encoding);
    $value = @htmlspecialchars($value, ENT_QUOTES, $_SESSION['language']->encoding);

      //reset default if second parameter is skipped
    $nullify = ($nullify === null) ? (false) : ($nullify);

      //check for null/unset/empty strings
    if ((!isset($value)) || (is_null($value)) || ($value === "")) {
        $value = ($nullify) ? ("NULL") : ("''");
    } else {
        if (is_string($value)) {
              //value is a string and should be quoted; determine best method based on available extensions
            if (function_exists('mysql_real_escape_string')) {
                  $value = "'" . mysql_real_escape_string($value) . "'";
            } else {
              $value = "'" . mysql_escape_string($value) . "'";
            }
        } else if (!is_numeric($value)) {
            //value is not a string nor numeric
            display_error("ERROR: incorrect data type send to sql query");
            echo '<br><br>';
            exit();
        }
    }
    return $value;
}

MySQL now has an builtin QUOTE() function that can now dispense with quoting / cleaning up any string to be entered through SQL directly.

The use of htmlspecialchars() is dictated by certain PHP environment settings:

' " ' (double quote) becomes '"' when ENT_NOQUOTES is not set. 
" ' " (single quote) becomes ''' only when ENT_QUOTES is set. 

The field #_tax_group_items.rate does not seem to be used.
The field #_tax_types.rate seems to be used.

@joe please clarify.

Many Wiki pages may be outdated and / or lack sufficient screenshots and many are not filled in at all. Those users who implement FA afresh will go thru a learning curve which will be useful in remedying the lacunae / lack of information in the wiki.

Example of a page I have currently filled in is the Backup and Restore Wiki page for reference.

Culling out nuggets of information from the forum and appropriately cross referencing and placing them in the logical locations in the wiki will help everyone especially the newbies find the information easily instead of repeatedly asking for help in the forums.

Users are requested to volunteer for this huge effort that will also benefit from translations as well. This is a priceless contribution (beyond exchange rates based capability to pay) to the FA project that will surpass any donations in monetary terms that users provide (your monetary contributions are certainly valuable as it goes into sustaining the physical world costs of maintaining FA for all).

Just finished updating the Create/Update Companies Wiki page with copy/paste-able sql code for removing all tables for a single company in one go.

There appears to be a lack of documentation (even in the wiki) regarding Ajax as used in FrontAccounting. Before making a wiki page for it, those in the know can contribute to this thread from where it will be distilled into the wiki.

If on the change of value of any FA form element, some ajax work needs to be done (like other form elements getting updated or some function being executed), then a $_POST array element needs to be set and sent.

The $_POST array element must bear a name that embeds the ajax requesting element's name attribute as seen in Lines 300 to 307 in the function list_updated($name) in includes/ui/ui_lists.inc file:

/*
    Helper function.
    Returns true if selector $name is subject to update.
*/
function list_updated($name)
{
    return isset($_POST['_'.$name.'_update']) || isset($_POST['_'.$name.'_button']);
}

Hence if the ajax requesting form element is stock_id then the hidden form elemet that is sent over for an ajax call in FA would either be:
$_POST['_stock_id_update']
or
$_POST['_stock_id_button']
for the function list_updated($name) to trigger the ajax response.

To get the response inside a target form element, it's name attribute is passed on like $Ajax->activate('price').

This is seen for example in lines 506-511 in sales/includes/ui/sales_order_ui.inc:

        if (list_updated('stock_id')) {
                $Ajax->activate('price');
                $Ajax->activate('units');
                $Ajax->activate('qty');
                $Ajax->activate('line_total');
        }

All functions that assist ajax responses are in includes\ui\ui_lists.inc.