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 = strlen($TheValue) == 5 ? $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 = false, $var_Width = 150) {
global $dblink, $var_BuilderLogo, $HttpsPath, $WwwPath, $SiteFolder;
$base_path = $HttpsPath . $WwwPath . $SiteFolder;
$sql_Phase = $var_Phase ? "AND col_Phase = '$var_Phase'" : "";
$sql = "
SELECT col_Logo1,
col_Logo2
FROM tb_Phase
WHERE col_Centre = '$var_Centre'
$sql_Phase
";
$result = mysqli_query($dblink, $sql);
$data = mysqli_fetch_array($result);
if (mysqli_num_rows($result) > 1) {
return array(
'logo1' => '',
'logo2' => '',
'str1' => '',
'str2' => '',
);
}
$str_Logo1 = $data['col_Logo1'];
$str_Logo2 = $data['col_Logo2'];
if ($str_Logo1 && strpos($str_Logo1, '/') === false)
$str_Logo1 = "../../data/builderimages/$str_Logo1";
if ($str_Logo2 && strpos($str_Logo2, '/') === false)
$str_Logo2 = "../../data/builderimages/$str_Logo2";
$str_Logo1 = $str_Logo1 ?: '';
$str_Logo2 = $str_Logo2 ?: $var_BuilderLogo;
$var_Logo1 = file_exists($str_Logo1) ? "
" : ' ';
$var_Logo2 = file_exists($str_Logo2) ? "
" : ' ';
if ($var_FullPath) {
$var_Logo1 = str_replace('../..', $base_path, $var_Logo1);
$var_Logo2 = str_replace('../..', $base_path, $var_Logo2);
$str_Logo1 = str_replace('../..', $base_path, $str_Logo1);
$str_Logo2 = str_replace('../..', $base_path, $str_Logo2);
}
return array(
'logo1' => $var_Logo1,
'logo2' => $var_Logo2,
'str1' => $str_Logo1,
'str2' => $str_Logo2,
);
}
function getFilePath ($file, $withBasePath = false) {
global $HomeFolder, $FormsFolder, $BuilderFormsFolder, $var_BuilderPrefix, $SiteFolder, $AppsFolder, $DataFolder;
$genericPath = $HomeFolder . $SiteFolder . $AppsFolder . $FormsFolder . '/' . $file;
$customPath = $HomeFolder . $SiteFolder . $DataFolder . $BuilderFormsFolder . '/' . $var_BuilderPrefix . $file;
$exist = file_exists($customPath);
if (! $withBasePath) {
$genericPath = str_replace($HomeFolder, '', $genericPath);
$customPath = str_replace($HomeFolder, '', $customPath);
}
return $exist ? $customPath : $genericPath;
}
function bst_array_column (array $input, $columnKey, $indexKey = null) {
$array = array();
foreach ($input as $value) {
if (! array_key_exists($columnKey, $value)) {
trigger_error("Key \"$columnKey\" does not exist in array");
return false;
}
if (is_null($indexKey)) {
$array[] = $value[$columnKey];
} else {
if (! array_key_exists($indexKey, $value)) {
trigger_error("Key \"$indexKey\" does not exist in array");
return false;
}
if (! is_scalar($value[$indexKey])) {
trigger_error("Key \"$indexKey\" does not contain scalar value");
return false;
}
$array[$value[$indexKey]] = $value[$columnKey];
}
}
return $array;
}
function convert_smart_quotes ($string) {
$search = array(chr(145), chr(146), chr(147), chr(148), chr(151), chr(150));
$replace = array("'", "'", '"', '"', '-', '-');
return str_replace($search, $replace, $string);
}
if (! function_exists('rearrange')) {
function rearrange ($datas, $columnKeys = array('col_Centre', 'col_Phase', 'col_Lot')) {
$arr = array();
foreach ($datas as $data) {
$arr_keys = array();
foreach ($columnKeys as $columnKey) {
array_push($arr_keys, $data[$columnKey]);
}
$key = implode(',', $arr_keys);
if (!array_key_exists($key, $arr)) {
$arr[$key] = array();
}
array_push($arr[$key], $data);
}
return $arr;
}
}
function listByCentreOrProject ($var_CentreProject = '') {
global $dblink, $var_ListByCentreOrProject, $LoggedInUser;
$var_CentresOrProjects = array();
$var_CentreProject ?: $var_ListByCentreOrProject;
$col_Name = $var_CentreProject ? "col_$var_CentreProject" : "col_Centre";
$sql = "
SELECT col_UsersName
FROM tb_AvailableProjects
WHERE col_UsersName = '$LoggedInUser'
AND (col_Project = 'All' OR col_Centre = 'All')
";
if ($result = mysqli_query($dblink, $sql)) {
if (mysqli_num_rows($result)) {
$sql = "
SELECT DISTINCT $col_Name
FROM tb_Phase
WHERE $col_Name IS NOT NULL
AND $col_Name != ''
ORDER BY $col_Name
";
} else {
$sql = "
SELECT DISTINCT tb_Phase.$col_Name
FROM tb_AvailableProjects
JOIN tb_Phase
ON tb_Phase.$col_Name = tb_AvailableProjects.$col_Name
WHERE tb_AvailableProjects.col_UsersName = '$LoggedInUser'
ORDER BY tb_Phase.$col_Name
";
}
}
$result = mysqli_query($dblink, $sql);
while ($data = mysqli_fetch_array($result)) {
array_push($var_CentresOrProjects, $data[$col_Name]);
}
return $var_CentresOrProjects;
}
?>