FrontAccounting forum — New Copy of Sales Order

Re: New Copy of Sales Order

2018-10-04T15:39:10Z

Ok... so far I have now gotten it to show up on my order confirmation page. So, After I have put in my order and I get my list of options, my new link and report are there and available. That's 1/2 way...

Re: New Copy of Sales Order

2018-10-04T15:13:51Z

I will give that a shot. Thanks!

Re: New Copy of Sales Order

2018-10-03T23:02:29Z

After a brief look into extension. Returned back to the basic things I told first. Glad if it helps you

Re: New Copy of Sales Order

2018-10-03T20:10:20Z

??? you do want to modify /sales/inquiry/sales_orders_view.php don't you?
1st you need a new type as given in post 2 above by kvvaradha
Then add you new type, and change the code in sales_orders_view.php -
Study the existing code for a sales order - add similar for the new type you have defined.

Re: New Copy of Sales Order

2018-10-03T11:40:12Z

Well... here's where I am. I tried to mimic and make this new function, but it's not creating the link as expected...

function print_factory_link($doc_no, $link_text, $link=true, $type_no, 
    $icon=false, $class='printlink', $id='', $email=0, $extra=0)
{
    global $path_to_root;
    include_once($path_to_root . "/includes/types.inc");

    $url = $path_to_root.'/reporting/prn_redirect.php?';
    $def_orientation = (user_def_print_orientation() == 1 ? 1 : 0);

    switch ($type_no)
    {
                case ST_FACTORYORDER :
            $rep = 127;
            // from, to, currency, email, quote, comments, orientation
            $ar = array(
                'PARAM_0' => $doc_no, 
                'PARAM_1' => $doc_no, 
                'PARAM_2' => '', 
                'PARAM_3' => $email, 
                'PARAM_4' => 0, 
                'PARAM_5' => '',
                'PARAM_6' => $def_orientation);
            break;
        default:
            return null;
    }

    return print_factory_link($link_text, $rep, $ar, "", $icon, $class, $id);
}

and these are my errors.

Missing argument 4 for print_factory_link(), called in .../includes/ui/db_pager_view.inc on line 107 and defined in file: .../reporting/includes/reporting.inc at line 167
...includes/ui/db_pager_view.inc:107:     print_factory_link((Array[20]),'')
.../sales/inquiry/sales_orders_view.php:321:     display_db_pager((db_pager Object))


Use of undefined constant ST_FACTORYORDER - assumed 'ST_FACTORYORDER' in file: .../reporting/includes/reporting.inc at line 178
.../includes/ui/db_pager_view.inc:107:     print_factory_link((Array[20]),'')
.../sales/inquiry/sales_orders_view.php:321:     display_db_pager((db_pager Object))


Undefined variable: type_no in file: .../reporting/includes/reporting.inc at line 178
.../includes/ui/db_pager_view.inc:107:     print_factory_link((Array[20]),'')
.../sales/inquiry/sales_orders_view.php:321:     display_db_pager((db_pager Object))

Re: New Copy of Sales Order

2018-10-02T17:53:32Z

No, sure don't have that those set. I'll try them and see what happens when I try to make the edits that break the file.

Thanks

Re: New Copy of Sales Order

2018-10-02T17:50:25Z

What errors are showing?
Have you set:-

33:     $debug             = 1;    // show sql on database errors
34: 
35:     $show_sql         = 1;    // show all sql queries in page footer for debugging purposes
36:     $go_debug         = 2;    // set to 1 for basic debugging, or 2 to see also backtrace after failure.

In File: \config.php

Don't forget to change them back when you have completed your changes

Re: New Copy of Sales Order

2018-10-02T17:16:50Z

I think that part was already completed in the last section of code above...

       case ST_SALESORDER :
            $rep = 109;
            // from, to, currency, email, quote, comments, orientation
            $ar = array(
                'PARAM_0' => $doc_no, 
                'PARAM_1' => $doc_no, 
                'PARAM_2' => '', 
                'PARAM_3' => $email, 
                'PARAM_4' => 0, 
                'PARAM_5' => '',
                'PARAM_6' => $def_orientation);
            break;
        
        case ST_SALESORDER :
            $rep = 127;
            // from, to, currency, email, quote, comments, orientation
            $ar = array(
                'PARAM_0' => $doc_no, 
                'PARAM_1' => $doc_no, 
                'PARAM_2' => '', 
                'PARAM_3' => $email, 
                'PARAM_4' => 0, 
                'PARAM_5' => '',
                'PARAM_6' => $def_orientation);
            break;

But, that doesn't put the link where I need it. Some how I need to use this sections

function print_factory_link($link_text, $rep, $pars = array(), $dir = '', 
    $icon=false, $class='printlink', $id='')
{
    global $path_to_root, $SysPrefs;

    $url = $dir == '' ?  $path_to_root.'/reporting/prn_redirect.php?' : $dir;

    $id = default_focus($id);
    foreach($pars as $par => $val) {
        $pars[$par] = "$par=".urlencode($val);
    }
    $pars[] = 'REP_ID='.urlencode($rep);
    $url .= implode ('&', $pars);

    if ($class != '')
        $class = $SysPrefs->pdf_debug ? '' : " class='$class'";
    if ($id != '')
        $id = " id='$id'";
    $pars = access_string($link_text);
    if (user_graphic_links() && $icon)
        $pars[0] = set_icon($icon, $pars[0]);
    return "$pars[0]";
}

but shove this into it... which I am not able to figure out.

     case ST_SALESORDER :
            $rep = 127;
            // from, to, currency, email, quote, comments, orientation
            $ar = array(
                'PARAM_0' => $doc_no, 
                'PARAM_1' => $doc_no, 
                'PARAM_2' => '', 
                'PARAM_3' => $email, 
                'PARAM_4' => 0, 
                'PARAM_5' => '',
                'PARAM_6' => $def_orientation);
            break;

Re: New Copy of Sales Order

2018-10-02T16:36:15Z

Study the code to print rep109... copy and rename

Re: New Copy of Sales Order

2018-10-02T16:18:05Z

Ok... I have effectively made some sort of new link, but it's not firing my Report. Any idea how I need to change this?

function print_factory_link($link_text, $rep, $pars = array(), $dir = '', 
    $icon=false, $class='printlink', $id='')
{
    global $path_to_root, $SysPrefs;

    $url = $dir == '' ?  $path_to_root.'/reporting/prn_redirect.php?' : $dir;

    $id = default_focus($id);
    foreach($pars as $par => $val) {
        $pars[$par] = "$par=".urlencode($val);
    }
    $pars[] = 'REP_ID='.urlencode($rep);
    $url .= implode ('&', $pars);

    if ($class != '')
        $class = $SysPrefs->pdf_debug ? '' : " class='$class'";
    if ($id != '')
        $id = " id='$id'";
    $pars = access_string($link_text);
    if (user_graphic_links() && $icon)
        $pars[0] = set_icon($icon, $pars[0]);
    return "$pars[0]";
}

it's creating THIS link

http://testing.egreene.com/sales/inquiry/30

but I need it to create THIS link

http://testing.egreene.com/reporting/prn_redirect.php?PARAM_0=3&PARAM_1=3&PARAM_2=&PARAM_3=0&PARAM_4=0&PARAM_5=&PARAM_6=0&REP_ID=127

When the system creates the current Print Order link, it comes from this. You can see my addition of Rep. 127, But since this checks what the screen is (ST_SALESORDER) it only uses Rep. 109. I CAN permanently change this page to show ONLY rep. 127, but I want a link for both reports since I'll use both.

function print_document_link($doc_no, $link_text, $link=true, $type_no, 
    $icon=false, $class='printlink', $id='', $email=0, $extra=0)
{
    global $path_to_root;
    include_once($path_to_root . "/includes/types.inc");

    $url = $path_to_root.'/reporting/prn_redirect.php?';
    $def_orientation = (user_def_print_orientation() == 1 ? 1 : 0);

    switch ($type_no)
    {
        case ST_SALESQUOTE :
            $rep = 111;
            // from, to, currency, email, comments, orientation
            $ar = array(
                'PARAM_0' => $doc_no, 
                'PARAM_1' => $doc_no, 
                'PARAM_2' => '', 
                'PARAM_3' => $email, 
                'PARAM_4' => '',
                'PARAM_5' => $def_orientation);
            break;
        case ST_SALESORDER :
            $rep = 109;
            // from, to, currency, email, quote, comments, orientation
            $ar = array(
                'PARAM_0' => $doc_no, 
                'PARAM_1' => $doc_no, 
                'PARAM_2' => '', 
                'PARAM_3' => $email, 
                'PARAM_4' => 0, 
                'PARAM_5' => '',
                'PARAM_6' => $def_orientation);
            break;
        
        case ST_SALESORDER :
            $rep = 127;
            // from, to, currency, email, quote, comments, orientation
            $ar = array(
                'PARAM_0' => $doc_no, 
                'PARAM_1' => $doc_no, 
                'PARAM_2' => '', 
                'PARAM_3' => $email, 
                'PARAM_4' => 0, 
                'PARAM_5' => '',
                'PARAM_6' => $def_orientation);
            break;

        case ST_CUSTDELIVERY :
            $rep = 110;
            // from, to, email, packing slip, comments, orientation
            $ar = array(
                'PARAM_0' => $doc_no, 
                'PARAM_1' => $doc_no, 
                'PARAM_2' => $email,
                'PARAM_3' => $extra,
                'PARAM_4' => '',
                'PARAM_5' => $def_orientation);
            break;
        case ST_SALESINVOICE : // Sales Invoice
        case ST_CUSTCREDIT : // Customer Credit Note
            $rep = $type_no==ST_CUSTCREDIT ? 113 : 107;
            // from, to, currency, email, paylink, comments, orientation
            $ar = array(
                'PARAM_0' => $doc_no, 
                'PARAM_1' => $doc_no, 
                'PARAM_2' => '', 
                'PARAM_3' => $email, 
                'PARAM_4' => '',
                'PARAM_5' => '', 
                'PARAM_6' => $rep == 107 ? '' : $def_orientation);
            if ($rep == 107)
                $ar['PARAM_7'] = $def_orientation;
            break;
        case ST_PURCHORDER :
            $rep = 209;
            // from, to, currency, email, comments, orientation
            $ar = array(
                'PARAM_0' => $doc_no, 
                'PARAM_1' => $doc_no, 
                'PARAM_2' => '', 
                'PARAM_3' => $email, 
                'PARAM_4' => '',
                'PARAM_5' => $def_orientation);
            break;
        case ST_CUSTPAYMENT :
            $rep = 112;
            // from, to, currency, comments, orientation
            $ar = array(
                'PARAM_0' => $doc_no, 
                'PARAM_1' => $doc_no, 
                'PARAM_2' => '', 
                'PARAM_3' => '',
                'PARAM_4' => $def_orientation);
            break;
        case ST_SUPPAYMENT :
            $rep = 210;
            // from, to, currency, email, comments, orientation
            $ar = array(
                'PARAM_0' => $doc_no, 
                'PARAM_1' => $doc_no, 
                'PARAM_2' => '', 
                'PARAM_3' => $email, 
                'PARAM_4' => '',
                'PARAM_5' => $def_orientation);
            break;
        case ST_WORKORDER :
            $rep = 409;
            // from, to, email, comments, orientation
            $ar = array(
                'PARAM_0' => $doc_no, 
                'PARAM_1' => $doc_no, 
                'PARAM_2' => $email, 
                'PARAM_3' => '', 
                'PARAM_4' => $def_orientation);
            break;
        default:
            return null;
    }

    return print_link($link_text, $rep, $ar, "", $icon, $class, $id);
}

Re: New Copy of Sales Order

2018-10-02T15:06:05Z

That's exactly what I did to make my new icon link show up, BUT I can't seem to figure out the part where that link is given it's report ID#. I'll begin my search again today.

Re: New Copy of Sales Order

2018-10-01T19:37:16Z

I've had a brief look, maybe you need to create a new function similar to order_link or invoice_link

Re: New Copy of Sales Order

2018-10-01T19:18:16Z

Getting closer, little by little. Thanks for sticking with me.

I have the default Print link duplicated in a new spot. Both icon links call report 109. I can't seem to figure out how to get the new icon ink I added to call report 127 instead. I have report 127 in my reports area and can view and use it. Just not here.

Re: New Copy of Sales Order

2018-10-01T18:11:12Z

Follow the function calls

Re: New Copy of Sales Order

2018-10-01T15:40:20Z

I'm ok with that. I can make a record of what I did and redo those changes each time. I know it's not ideal, but streamlining the process makes much more sense to me than forcing the user to go through several extra steps.

Do you know how I would go about creating this new link? I attempted to follow the trail of included files to see where the link was created, but I was not able to.