Search options (Page 1 of 6)

    $allocs = array(
        $all_items=>_("All Types"),
        '1'=> _("Sales Invoices"),
        '2'=> _("Overdue Invoices"),
        '3' => _("Payments"),
        '4' => _("Credit Notes"),
        '5' => _("Delivery Notes")
    );

    $allocs = array(
        $all_items=>_("All Types"),
        '1'=> _("Sales Invoices"),
        '2'=> _("Overdue Invoices"),
        '3' => _("Payments"),
        '4' => _("Credit Notes"),
        '5' => _("Delivery Notes"),
        '6' => _("Sales Invoices") . " & " . _("Delivery Notes")
    );

        // Add delivery and invoices option
        elseif ($_POST['filterType'] == '6')
        {
            $sql .= " AND (trans.type = ".ST_SALESINVOICE ." OR
            trans.type = ". ST_CUSTDELIVERY . ") ";
        }
        // eof delivery and invoice filter option

    $sql .= " GROUP BY trans.trans_no, trans.type";

    // Order by trans.order_, but only for 'Sales Invoice & Delivery Note' filter.
    if ($_POST['filterType'] == '6') {
        $sql .= " ORDER BY trans.order_ DESC, trans.trans_no DESC ";
    }
    // eof p2409

function addSlashes(input) {
    var v = input.value;
    var startYear = '';
    // If it's only 2 digits and 2 digits long, add one slash
    if (v.match(/^\d{2}$/) !== null) {
        input.value = v + '/';
        // If up to year, add slash again.
    } else if (v.match(/^\d{2}\/\d{2}$/) !== null) {
        input.value = v + '/';
    }
    // If six chars, add year
    
    if (v.match(/^\d{2}\/\d{2}\/\d{2}$/)) {
        
        // 24/12/08 
// substring from - to (to is char position so always > from)

        if (v.substring(6,8)>30) {
            startYear = '19';
        }
        else {
            startYear = '20';
        }
        input.value = input.value.substring(0,6)  + startYear + input.value.substring(6,8);
    }
}

            $memo = get_comments_string($myrow['type'], $myrow['type_no']);
            // Pete: multline journal display.
            $replines = array();
            if ($memo != '')
            {
                if ($coms == "")
                    $coms = $memo;
                else
                    $coms .= " / ".$memo;
                // turn memo text into multiline array for printing
                $replines = explode("\n",$coms);
            }
            // Print each line of comment separately, rather than a single line
            foreach ($replines as $repline) {
                $rep->TextCol(3,6,$repline);
                $rep->NewLine();
            }

New User Configurable Transaction days setting by Pete p2409.
-------------------------------------------------------------

Currently, FA uses a hard-coded default 30 days in the past setting for transaction display screens
eg. ifyou do a GL inquiry, the default is to display dates from today to 30 days ago.
With a new user-configurable 'transaction_days' setting, you can now set this to a default number 
you choose eg. 365 to always display the last year's instead of month's transactions.
With this change, the default 'From' date on inquiry screens will be the setting you made
eg. -365 days from now.

To achieve this, we add a new global setting 'transaction_days' and look up this setting in
all inquiry screens that previously had a hardcoded 30 days.

(Note the setting is a positive number, made negative to go back in the past in the inquiry screens
with a minus sign).

CHANGES TO CODE/TABLE
---------------------

1) Create new 'Transaction days' setting in preferences screen:

In ./admin/display_prefs.php

Around line 37

FROM:
        set_user_prefs(get_post( 
            array('prices_dec', 'qty_dec', 'rates_dec', 'percent_dec',
            'date_format', 'date_sep', 'tho_sep', 'dec_sep', 'print_profile', 
            'theme', 'page_size', 'language', 'startup_tab',
            'show_gl' => 0, 'show_codes'=> 0, 'show_hints' => 0,
            'rep_popup' => 0, 'graphic_links' => 0, 'sticky_doc_date' => 0,
            'query_size' => 10.0)));

TO:
// Add transaction days configurable.            
        set_user_prefs(get_post( 
            array('prices_dec', 'qty_dec', 'rates_dec', 'percent_dec',
            'date_format', 'date_sep', 'tho_sep', 'dec_sep', 'print_profile', 
            'theme', 'page_size', 'language', 'startup_tab',
            'show_gl' => 0, 'show_codes'=> 0, 'show_hints' => 0,
            'rep_popup' => 0, 'graphic_links' => 0, 'sticky_doc_date' => 0,
            'query_size' => 10.0, 'transaction_days' => 30)));
            
Around line 142 after:

check_row(_("Remember last document date:"), 'sticky_doc_date', sticky_doc_date(),
    false, _('If set document date is remembered on subsequent documents, otherwise default is current date'));

ADD:

text_row_ex(_("Transaction days:"), 'transaction_days', 5, 5, '', user_transaction_days());


2) Update user preferences to add new transaction_days global variable.

In ./includes/prefs/userprefs.inc

Around line 38:
ADD:
    var $transaction_days;

Around line 54 after:
            $this->theme = 'default';
ADD:
            $this->transaction_days = -30;
Around line 91 (in the else block)
AFTER:
            else
            {
                $this->sticky_date = 0;
                $this->startup_tab = "orders";
            }

ADD:
            $this->transaction_days = $user['transaction_days'];

Around line 127:
ADD:
    function transaction_days() {
        return $this->transaction_days;
    }

3) Update current user settings with new user_transaction_days function:

Around line 312
ADD:
function user_transaction_days()
{
    return $_SESSION["wa_current_user"]->prefs->transaction_days();
}


4) Modify all inquiry screens to use new 'Transaction Days' setting:

In all inquiry screens (do a global search on '30' to find them all):
./gl/inquiry/bank_inquiry.php
./gl/inquiry/gl_account_inquiry.php
./gl/inquiry/gl_trial_balance.php
./gl/inquiry/profit_loss.php
./gl/inquiry/tax_inquiry.php
./gl/view/accrual_trans.php
./inventory/inquiry/stock_movements.php
./purchasing/includes/ui/invoice_ui.inc
./purchasing/inquiry/po_search.php
./purchasing/inquiry/po_search_completed.php
./purchasing/inquiry/supplier_allocation_inquiry.php
./purchasing/inquiry/supplier_inquiry.php
./sales/inquiry/customer_allocation_inquiry.php
./sales/inquiry/customer_inquiry.php
./sales/inquiry/sales_deliveries_view.php
./sales/inquiry/sales_orders_view.php

Example for bank inquiry: ./gl/inquiry/bank_inquiry.php

Around line 50:

CHANGE:
date_cells(_("From:"), 'TransAfterDate', '', null, -30);

TO:
date_cells(_("From:"), 'TransAfterDate', '', null, -$_SESSION["wa_current_user"]->prefs->transaction_days());

Do this for each inquiry screen file


5) SQL update x_users table with new 'transaction_days' column:

ALTER TABLE `0_users` ADD `transaction_days` INT( 6 ) NOT NULL COMMENT 'Transaction days'

(Note: use your company number eg. 0_, 1_ etc to update for each company).