Search options (Page 1 of 8)

Hi, I have implemented an improved user security module.
It contains:
- password rule enforcement
- auto block if user failed login after several attempts (need admin to unblock)
- password expiry date to force user reset password after a period of time
- unique login (same user cannot login from 2 different places at the same time)

If anyone interested, please contact me: bharata1803@gmail.com

Hi,

I am aware of db_pager functionality. Now I need to make a table with paging functionality from already queried data.
Is there any way to do this?

Hello,

I made a new graphics in the dashboard. It should be relatively simple and in my local it does work as expected.
My code is below:

function display_sales_per_month()
{
    $pg = new graph();

    
    $this_year = date('Y');
    $title = _('Sales per month');
    $data = get_sales_in_year($this_year);
        $months = array(_('Jan'), _('Feb'), _('Mar'),
            _('Apr'), _('May'), _('Jun'),
            _('Jul'), _('Aug'), _('Sep'),
            _('Oct'), _('Nov'), _('Dec'),
        );
        $x_axis = array();
        $y_axis = array();
        foreach($data['monthly'] as $k=>$v){
            $x_axis[] = $months[$k-1];
            $y_axis[] = $v;
        }
        
        $pg->x = $x_axis;
        $pg->y = $y_axis;
    source_graphic($this_year, $title, _(""), $pg, _("Sales per month"), null, 1);
}

It just display total invoice per month.
What I got when I upload is this:

https://i.imgur.com/FEpxLtq.png

It got some weird string.

I found this incorrect sql query:

Screenshot

Any way to add graph in the dashboard via module and not modifying the core?

Hello,

I want to ask about changing item or supplier tax. It seems that if I create a PO or GRN and then the tax setup is changed in Item Tax Types, the tax in already created PO or direct GRN will also be affected.

For example, if I create PO yesterday which only consist of item A and item A only has 1 tax,  it will calculate the overall amount using that tax. But, if I add new tax for A today, when I check the yesterday's PO, the overall amount is also changed which now has 2 tax for item A.

It is make sense from the coding perspective because PO only refer item id and it will query tax information from the database according to what is stored when it is access. But isn't it dangerous? Old PO or direct GRN should retain its tax information when it is created. So the invoice should be based on the tax information when PO is created not when invoice is created.

This is my modification on adding batch and expiry date on the batch: LINK
username: admin
password: admin

Currently, I have implemented batch selection for:
- sales direct delivery + direct invoice
- sales delivery from sales order
- purchasing direct GRB + direct invoice
- purchasing receive item GRN from PO
- inventory adjustment
- stock transfer
- stock check sheet report

I haven't finished implemented batch selection for manufacturing/work order and creating report spesific to the batch.
Please have a look at that and if you need, don't hesitate to contact me: bharata1803@gmail.com