Create Tracking number

[lmayer4]

Morning,

I have a script that takes a formatted date and increments the number 000x for each consecutive ticket. But it checks for todays date and if its the first it gets 15Mar05-0001 else it gets 15Mar05-0002 ect.

I can make the first part work just not the second. Any thoughts would be appreicated.

function getAddString($num){
$num="0000".(intval($num)+1);
return substr($num,strlen($num)-1,4);
}

//get date filled out plus 7 days
$formattedDate = date("dMy");
echo $formattedDate;
echo "<br>";
$result = mssql_query ("SELECT MAX(TrackingNumber) AS TNUM FROM tblHolding WHERE TrackingNumber LIKE '$formattedDate%'");
while($r=mssql_fetch_array($result))
{

$s_result=$r["TNUM"];

if (is_null($s_result)){
$GetRefNumber = $formattedDate ."-0001";
echo $GetRefNumber;
} else {
$CurRef = getAddString($s_result+1);
$RefNumber = $formattedDate . "-" . $CurRef;
echo $RefNumber;
}
}

[Installer]

Your function returns only the last digit of the number string. If it's four digits you want, use:

substr($num, -4)

[lmayer4]

Okay now I get the result:

15Mar05-0017 which would be good if the last ticket number was 15Mar05-0016 but it's 15Mar05-0005

I'm confused.....

[lmayer4]

Got it:

$formattedDate = date("dMy");
echo $formattedDate;
echo "<br>";
$result = mssql_query ("SELECT MAX(TrackingNumber) AS TNUM FROM tblHolding WHERE TrackingNumber LIKE '$formattedDate%'");

while($r=mssql_fetch_array($result))
{

$s_result=$r["TNUM"];

if (is_null($s_result)){
$GetRefNumber = $formattedDate ."-0001";
echo $GetRefNumber;
} else {
$NRef = substr($s_result, -4);
$NRef++;
$NRef2 = "0000".(intval($NRef));
$NRef3 = substr($NRef2,-4);
$RefNumber = $formattedDate . "-" . $NRef3;
echo "refnumber = " . $RefNumber;
}
}