89
Can anyone help me with why i am getting this error message:
Notice: Undefined variable: SalesRepID in C:\Inetpub\wwwroot\index.php on line 158
Here is my php code:
[PHP]<?php
session_start();
session_register("LoggedIn");
session_register("SavedSearchType");
session_register("ShowDetails");
session_register("SalesRepID");
session_register("SavedCustID");
session_register("LinesToDisplay");
session_register("StatusREL");
session_register("StatusSHP");
session_register("StatusINV");
session_register("StatusNR");
session_register("SavedFromDate");
session_register("SavedToDate");
session_register("WebCompanyName");
session_register("SavedSearchValue");
session_register("SavedSearchRev");
session_register("SavedQueryOrder");
session_register('WebUserType');
if (!isset($_POST['FromDate'])) {
$_POST['FromDate'] = $_SESSION['SavedFromDate'];
}
$_SESSION['SavedFromDate'] = $_POST['FromDate'];
if (!isset($_POST['ToDate'])) {
$_POST['ToDate'] = $_SESSION['SavedToDate'];
}
$_SESSION['SavedToDate'] = $_POST['ToDate'];
if (!isset($_POST['StatusREL'])) {
$_POST['StatusREL'] = $_SESSION['StatusREL'];
}
$_SESSION['StatusREL'] = $_POST['StatusREL'];
if (!isset($_POST['StatusSHP'])) {
$_POST['StatusSHP'] = $_SESSION['StatusSHP'];
}
$_SESSION['StatusSHP'] = $_POST['StatusSHP'];
if (!isset($_POST['StatusINV'])) {
$_POST['StatusINV'] = $_SESSION['StatusINV'];
}
$_SESSION['StatusINV'] = $_POST['StatusINV'];
if (!isset($_POST['StatusNR'])) {
$_POST['StatusNR'] = $_SESSION['StatusNR'];
}
$_SESSION['StatusNR'] = $_POST['StatusNR'];
if (!isset($_SESSION['StatusREL'])) { $_SESSION['StatusREL'] = "OFF"; }
if (!isset($_SESSION['StatusSHP'])) { $_SESSION['StatusSHP'] = "OFF"; }
if (!isset($_SESSION['StatusINV'])) { $_SESSION['StatusINV'] = "OFF"; }
if (!isset($_SESSION['StatusNR'])) { $_SESSION['StatusNR'] = "OFF"; }
if (!isset($_POST['CustID'])) {
$_POST['CustID'] = trim($_SESSION['SavedCustID']);
}
$_SESSION['SavedCustID'] = "All";
if (trim($_SESSION['ShowDetails']) == "Y") {
if (trim($_SESSION['WebUserType']) == "Rep") {
$_SESSION['SavedCustID'] = trim($_POST['CustID']);
}}
if (!isset($_POST['LinesToDisplay'])) {
$_POST['LinesToDisplay'] = $_SESSION['LinesToDisplay'];
}
$_SESSION['LinesToDisplay'] = $_POST['LinesToDisplay'];
if (!isset($_POST['SearchType'])) {
$_POST['SearchType'] = $_SESSION['SavedSearchType'];
}
$_SESSION['SavedSearchType'] = $_POST['SearchType'];
if (!isset($_POST['SearchValue'])) {
$_POST['SearchValue'] = $_SESSION['SavedSearchValue'];
}
$_SESSION['SavedSearchValue'] = $_POST['SearchValue'];
if (!isset($_POST['SearchRev'])) {
$_POST['SearchRev'] = $_SESSION['SavedSearchRev'];
}
$_SESSION['SavedSearchRev'] = $_POST['SearchRev'];
if (!isset($_POST['QueryOrder'])) {
$_POST['QueryOrder'] = $_SESSION['SavedQueryOrder'];
}
$_SESSION['SavedQueryOrder'] = $_POST['QueryOrder'];
if ($_SESSION['LoggedIn'] != true) {
@include("login.php");
return;
}
include("./connopenphp.inc");
//url definitions for shippers
$upsurl = "http://wwwapps.ups.com/tracking/tracking.cgi?tracknum=";
$fedxurl = "http://www.fedex.com/cgi-bin/tracking?action=track&language=english&cntry_code= us&initial=x&tracknumbers=";
// Status images are now user defineable in system parameters
$StatusToBeBuilt = "images/";
$StatusMFG = "images/";
$StatusPackaging = "images/";
$StatusUPS = "images/";
$StatusFedX = "images/";
$StatusUSPS = "images/";
$query = "select * from SYSPARMS";
$result = mssql_query($query,$conn);
if (mssql_num_rows($result) > 0) {
$sysparms = mssql_fetch_array($result);
$StatusToBeBuilt = "images/" . trim($sysparms['StatusImageToBeBuilt']);
$StatusMFG = "images/" . trim($sysparms['StatusImageMFG']);
$StatusPackaging = "images/" . trim($sysparms['StatusImagePackaging']);
$StatusUPS = "images/" . trim($sysparms['StatusImageUPS']);
$StatusFedX = "images/" . trim($sysparms['StatusImageFedX']);
$StatusUSPS = "images/" . trim($sysparms['StatusImageUSPS']);
}
if (trim($StatusToBeBuilt) == "images/") { $StatusToBeBuilt = "images/styello.gif";}
if (trim($StatusMFG) == "images/") { $StatusMFG = "images/stblue.gif";}
if (trim($StatusPackaging) == "images/") { $StatusPackaging = "images/stbrown.gif";}
if (trim($StatusUPS) == "images/") { $StatusUPS = "images/stgreen.gif";}
if (trim($StatusFedX) == "images/") { $StatusFedX = "images/stgreen.gif";}
if (trim($StatusUSPS) == "images/") { $StatusUSPS = "images/stgreen.gif";}
$a = trim($_SESSION['UserID']);
$b = trim($_SESSION['Password']);
$query = "select * from USERINFO where (UserID = '" . $a . "' and Password = '" . $b . "')";
// print($query);
$result = mssql_query($query,$conn);
if (mssql_num_rows($result) > 0) {
$userinfo = mssql_fetch_array($result);
$CompanyName = $userinfo['CompanyName'];
$Addr1 = $userinfo['Addr1'];
$Addr2 = $userinfo['Addr2'];
$City = $userinfo['City'];
$State = $userinfo['State'];
$Zip = $userinfo['Zip'];
$Country = $userinfo['Country'];
$Phone = $userinfo['Phone'];
$CustID = trim($userinfo['CustID']);
} else {
$CompanyName = "";
$Addr1 = "";
$Addr2 = "";
$City = "";
$State = "";
$Zip = "";
$Country = "";
$Phone = "";
$CustID = "";
}
$_SESSION['zPage'] = 1;
$FoundCust = false;
if ($SalesRepID != "") {
$query = "select * from CUST where (SalesRep1 = '" . $SalesRepID . "')";
$query = $query . " or (SalesRep2 = '" . $SalesRepID . "')";
$query = $query . " or (SalesRep3 = '" . $SalesRepID . "')";
$query = $query . " or (SalesRep4 = '" . $SalesRepID . "')";
$result = mssql_query($query,$conn);
if ($result == true) {
$FoundCust = true;
}
}
$Base64user_name = base64_encode($_SESSION['UserID']);
//echo "user is $_SESSION[CurrentlyLoggedInUser]<br>";
//echo "<pre>";
//print_r($_SESSION);
//echo "</pre>";
?>[/PHP]
