AO called with $var_Date, $var_Offset
";
$arr_Date = array();
$arr_Date = explode("-",$var_Date);
$var_Year = substr($arr_Date[0],2,2);
$var_Month = $arr_Date[1];
$var_Day = $arr_Date[2];
// echo "day: $var_Day, month $var_Month, year $var_Year
";
$var_NewDate = date("Y-m-d", mktime(0,0,0, (int)$var_Month, (int)$var_Day + (int)$var_Offset, (int)$var_Year));
// echo "
NewDate: $var_NewDate
";
return $var_NewDate;
}
/******************************** End - Date Functions *********************************/
function LabelCentre($var_Centre,$var_Phase)
{
global $dbnew, $dblink, $var_FromIncludeSite;
if ($var_Centre && $var_Phase)
{
$GetLabel_sql = "
SELECT col_LabelCentre
FROM tb_Phase
WHERE col_Phase = '$var_Phase'
AND col_Centre = '$var_Centre'";
//echo $GetLabel_sql;
$GetLabel_myrow = mysqli_fetch_array(mysqli_query($dblink,$GetLabel_sql));
$var_LabelCentre = $GetLabel_myrow['col_LabelCentre'];
}
if (!$var_LabelCentre)
$var_LabelCentre = $var_FromIncludeSite;
return $var_LabelCentre;
}
/***************************************************************************************/
function LabelPhase($var_Centre,$var_Phase)
{
global $dbnew, $dblink, $var_FromIncludePhase;
if ($var_Centre && $var_Phase)
{
$GetLabel_sql = "
SELECT col_LabelPhase
FROM tb_Phase
WHERE col_Phase = '$var_Phase'
AND col_Centre = '$var_Centre'";
//echo $GetLabel_sql;
$GetLabel_myrow = mysqli_fetch_array(mysqli_query($dblink,$GetLabel_sql));
$var_LabelPhase = $GetLabel_myrow['col_LabelPhase'];
}
if (!$var_LabelPhase)
$var_LabelPhase = $var_FromIncludePhase;
return $var_LabelPhase;
}
/***************************************************************************************/
$var_FromIncludeModel = 'Model';
function LabelModel($var_Centre,$var_Phase)
{
global $dbnew, $dblink, $var_FromIncludeModel;
if ($var_Centre && $var_Phase)
{
$GetLabel_sql = "
SELECT col_LabelModel
FROM tb_Phase
WHERE col_Phase = '$var_Phase'
AND col_Centre = '$var_Centre'";
//echo $GetLabel_sql;
$GetLabel_myrow = mysqli_fetch_array(mysqli_query($dblink,$GetLabel_sql));
$var_LabelModel = $GetLabel_myrow['col_LabelModel'];
}
if (!$var_LabelModel)
$var_LabelModel = $var_FromIncludeModel;
return $var_LabelModel;
}
/***************************************************************************************/
function LabelLot($var_Centre,$var_Phase)
{
global $dbnew, $dblink, $var_FromIncludeLot;
if ($var_Centre && $var_Phase)
{
$GetLabel_sql = "
SELECT col_LabelLot
FROM tb_Phase
WHERE col_Phase = '$var_Phase'
AND col_Centre = '$var_Centre'";
//echo $GetLabel_sql;
$GetLabel_myrow = mysqli_fetch_array(mysqli_query($dblink,$GetLabel_sql));
$var_LabelLot = $GetLabel_myrow['col_LabelLot'];
}
if (!$var_LabelLot)
$var_LabelLot = $var_FromIncludeLot;
return $var_LabelLot;
}
/******************************** End - Date Functions *********************************/
/******************************** Start - Phone Functions *********************************/
//////////////////////////////////
// returns a correctly-formatted phone number
//
function format_phone($var_number)
{
$LengthOfTelephoneNumber = strlen($var_number);
if ($LengthOfTelephoneNumber==0)
{
$var_F_Number = "";
}
elseif ($LengthOfTelephoneNumber==10)
{
$PhoneAC = substr("$var_number", 0, 3);
$PhonePrefix = substr("$var_number", 3, 3);
$PhoneSuffix = substr("$var_number", 6, 4);
$var_F_Number = "(".$PhoneAC.") ".$PhonePrefix."-".$PhoneSuffix;
}
elseif ($LengthOfTelephoneNumber==7)
{
$PhonePrefix = substr("$var_number", 0, 3);
$PhoneSuffix = substr("$var_number", 3, 4);
$var_F_Number = $PhonePrefix."-".$PhoneSuffix;
}
elseif ($LengthOfTelephoneNumber<7)
{
$PhonePrefix = substr("$var_number", 0, $LengthOfTelephoneNumber-4);
$PhoneSuffix = substr("$var_number", -4);
$var_F_Number = $PhonePrefix."-".$PhoneSuffix;
}
elseif ($LengthOfTelephoneNumber<10)
{
$PhoneCC = substr("$var_number", 0, $LengthOfTelephoneNumber-7);
$PhonePrefix = substr("$var_number", -7, 3);
$PhoneSuffix = substr("$var_number", -4);
$var_F_Number = $PhoneCC."-".$PhonePrefix."-".$PhoneSuffix;
}
elseif ($LengthOfTelephoneNumber>10)
{
$PhoneCC = substr("$var_number", -$LengthOfTelephoneNumber, $LengthOfTelephoneNumber-10);
$PhoneAC = substr("$var_number", -10, 3);
$PhonePrefix = substr("$var_number", -7, 3);
$PhoneSuffix = substr("$var_number", -4);
$var_F_Number = "$PhoneCC (".$PhoneAC.") ".$PhonePrefix."-".$PhoneSuffix;
}
return $var_F_Number;
}
//////////////////////////////////
//cleans phone number for database storage
//
function clean_PhoneNumber($TheValue)
{
//remove first 1 from start of phone number
$var_ReTel3 = '/^[1]/im';
$TheValue = str_replace("(","", $TheValue);
$TheValue = str_replace(")","", $TheValue);
$TheValue = str_replace("-","", $TheValue);
$TheValue = str_replace(" ","", $TheValue);
$TheValue = preg_replace($var_ReTel3,'',$TheValue);
return $TheValue;
}
//////////////////////////////////
//cleans and formats Postal Code for database storage
//
function clean_PostalCode($TheValue)
{
//make postal code upper case with space in middle
$TheValue = trim($TheValue);
$TheValue = strtoupper($TheValue);
$TheValue = str_replace(" ","", $TheValue);
$TheValue = substr($TheValue,0,3).' '.substr($TheValue,3,3);
return $TheValue;
}
////////////////////
/******************************** End - Phone Functions *********************************/
/******************************** Start - Password Functions *********************************/
function GetKeyCode($CodeLength)
{
$arr_char = array('0','1','2','3','4','5','6','7','8','9','a','b','c','d','e','f','g','h','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z');
$s ='';
$n = date('is');
for($i=0; $i<$n; $i++)
$s .= $arr_char[ mt_rand (0, 36) ];
$s = substr($s, mt_rand (0, $n), $CodeLength);
if(strlen(trim($s)) == $CodeLength)
return $s;
else
return GetKeyCode($CodeLength);
}
/******************************** End - Password Functions *********************************/
?>