Post Reply 
 
Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Special Order Salesmen Selection
05-12-2016, 01:36 PM
Post: #1
Special Order Salesmen Selection
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
Find all posts by this user
Quote this message in a reply
05-12-2016, 06:34 PM
Post: #2
RE: Special Order Salesmen Selection
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
Visit this user's website Find all posts by this user
Quote this message in a reply
05-13-2016, 05:47 AM
Post: #3
RE: Special Order Salesmen Selection
(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
Find all posts by this user
Quote this message in a reply
05-13-2016, 08:26 AM
Post: #4
RE: Special Order Salesmen Selection
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
Visit this user's website Find all posts by this user
Quote this message in a reply
05-13-2016, 12:06 PM
Post: #5
RE: Special Order Salesmen Selection
(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.
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)