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 *********************************/
function getPhaseLogos ($var_Centre, $var_Phase, $var_FullPath = 0) {
global $dblink, $var_BuilderLogo, $var_FullPathtoLogo, $HttpsPath, $WwwPath, $SiteFolder;
$base_path = $HttpsPath . $WwwPath . $SiteFolder;
$sql = "
SELECT col_Logo1,
col_Logo2
FROM tb_Phase
WHERE col_Centre = '$var_Centre'
AND col_Phase = '$var_Phase'
";
$result = mysqli_query($dblink, $sql);
$myrow = mysqli_fetch_array($result);
$var_Logo1 = $myrow['col_Logo1'];
$var_Logo2 = $myrow['col_Logo2'];
if ($var_Logo1 && strpos($var_Logo1, '/') === false)
$var_Logo1 = "../../data/builderimages/$var_Logo1";
if ($var_Logo2 && strpos($var_Logo2, '/') === false)
$var_Logo2 = "../../data/builderimages/$var_Logo2";
$var_Logo1 = $var_Logo1 ?: '';
$var_Logo2 = $var_Logo2 ?: $var_BuilderLogo;
$var_Logo1 = file_exists($var_Logo1) ? "
" : ' ';
$var_Logo2 = file_exists($var_Logo2) ? "
" : ' ';
if ($var_FullPath) {
$var_Logo1 = str_replace('../..', $base_path, $var_Logo1);
$var_Logo2 = str_replace('../..', $base_path, $var_Logo2);
}
return array(
'logo1' => $var_Logo1,
'logo2' => $var_Logo2,
);
}
function getFilePath ($file) {
global $FormsFolder, $BuilderFormsFolder, $var_BuilderPrefix, $SiteFolder, $AppsFolder, $DataFolder;
$genericPath = '/' . $SiteFolder . $AppsFolder . $FormsFolder . '/' . $file;
$customPath = '/' . $SiteFolder . $AppsFolder . $DataFolder . $BuilderFormsFolder . '/' . $var_BuilderPrefix . $file;
return file_exists($customPath) ? $customPath : $genericPath;
}
?>