webERP Forum
Special Order Salesmen Selection - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (/forumdisplay.php?fid=8)
+--- Thread: Special Order Salesmen Selection (/showthread.php?tid=2751)



Special Order Salesmen Selection - daveparrish - 05-12-2016 01:36 PM

When I do a special order and process the order for delivery (DeliveryDetails.php) with the customer selected the salesmen is not the salesmen related to the customer is there a way to correct this.
Thanks
Dave


RE: Special Order Salesmen Selection - falkoner - 05-12-2016 06:34 PM

There are a few changes needed. Firstly in includes/DefineSpecialOrderClass.php insert the line:

var $SalesPerson;

at line 31.

Then in SpecialOrder.php change the sql at line 110 to be

$sql = "SELECT brname,
salesman
FROM custbranch
WHERE debtorno='" . $_SESSION['SPL'.$identifier]->CustomerID . "'
AND branchcode='" . $_POST['SelectBranch'] . "'";
then at line 117 insert the following line:

$_SESSION['SPL' . $Identifier]->SalesPerson = $myrow['salesman'];

Finally at line 526 insert the line

salesperson,

and at line 545 insert

'" . $_SESSION['SPL' . $Identifier]->SalesPerson . "',

This should then do as you requested.

Thanks
Tim


RE: Special Order Salesmen Selection - daveparrish - 05-13-2016 05:47 AM

(05-12-2016 06:34 PM)falkoner Wrote:  There are a few changes needed. Firstly in includes/DefineSpecialOrderClass.php insert the line:

var $SalesPerson;

at line 31.

Then in SpecialOrder.php change the sql at line 110 to be

$sql = "SELECT brname,
salesman
FROM custbranch
WHERE debtorno='" . $_SESSION['SPL'.$identifier]->CustomerID . "'
AND branchcode='" . $_POST['SelectBranch'] . "'";
then at line 117 insert the following line:

$_SESSION['SPL' . $Identifier]->SalesPerson = $myrow['salesman'];

Finally at line 526 insert the line

salesperson,

and at line 545 insert

'" . $_SESSION['SPL' . $Identifier]->SalesPerson . "',

This should then do as you requested.

Thanks
Tim

Tim
Thanks for the help that worked

Also I would like to have the date fill for the Quote Date and Confirmed Order Date auto fill with the current date can you help with that also.
Thanks
Again


RE: Special Order Salesmen Selection - falkoner - 05-13-2016 08:26 AM

Simplest way is to just change SpecialOrder.php

At line 527 (immediately after the salesperson line insert:

quotedate,
confirmeddate,

then at line 548 insert:

CURRENT_DATE,
CURRENT_DATE,

and that should work as you want,

Thanks
Tim


RE: Special Order Salesmen Selection - daveparrish - 05-13-2016 12:06 PM

(05-13-2016 08:26 AM)falkoner Wrote:  Simplest way is to just change SpecialOrder.php

At line 527 (immediately after the salesperson line insert:

quotedate,
confirmeddate,

then at line 548 insert:

CURRENT_DATE,
CURRENT_DATE,

and that should work as you want,

Thanks
Tim

Thanks for the assist works great.