/include/helpers/inc_date_format_functions.php

<?php
/*------begin------ This protection code was suggested by Luki R. luki@karet.org ---- */
if (stristr($PHP_SELF,'inc_date_format_functions.php')) die('<meta http-equiv="refresh" content="0; url=../">');
/*------end------*/


/**
* getDateFormat gets the date format stored in the databank
* if unsuccesful, it will get the default from the defaults.ini
* param $link = receives the link created by the db connection routine
* param $DBLink_OK = receives the tag created by the db connection routine
* return = the date format
*/
function getDateFormat()
{

    global $db, $dblink_ok;

	$errFormat=0;

    /* If no link to db, make own link*/
    if(!isset($db) || !$db) include_once(CARE_BASE .'include/helpers/inc_db_makelink.php');

    if($dblink_ok)
    {
	 
	    $sql="SELECT value AS date_format FROM care_config_global WHERE type='date_format'";
	  
        if($result=$db->Execute($sql)) {

            if($result->RecordCount()) {
            
			    $df=$result->FetchRow();
                
				return $df['date_format'];
		    }
		    else $errFormat=1;
	    }
	    else $errFormat=1;
	}
	else $errFormat=1;
	
	if($errFormat)	{
	
	    $df=get_meta_tags(CARE_BASE .'global_conf/format_date_default.pid');

        if($df['date_format']!='') return $df['date_format'];
	        else return 'dd.MM.yyyy'; // this is the last alternative format (german traditional)
    }
}

/**
* format2Local converts the standard YYYY-MM-DD format to the local format
* param $stdDate = receives the standard YYYY-MM-DD formatted date
* param $localFromat = receives the local format
* param $retTime = if 1, will append the time part to the returned date
* param $sepChars = will accept the reference to an array containing the separator chars list.  if empty, the default will be used
* return = the date in local format
* The function assumes that the dates are in correct formats
* therefore a validation routine must be done at the client side
*/
function formatDate2Local($stdDate, $localFormat, $retTime=FALSE, $timeOnly=FALSE, &$sepChars)
{
   global $lang;
   
   if(!$sepChars) $sepChars=array('-','.','/',':',',');
   $localFormat=strtolower($localFormat); 
   
   if(stristr('0000',$stdDate))  return strtr($localFormat,'yYmMdDHis','000000000'); // IF  std date is 0 return 0's in local format

   /* If time is included then isolate */
   if(strchr($stdDate,':'))
   {
      list($stdDate,$stdTime) = explode(' ',$stdDate);
	  if($timeOnly) return $stdTime; /* If time only is needed */
   }

   $stdArray=explode('-',$stdDate);
   
   /* Detect time separator and explode localFormat */
   for($i=0;$i<sizeof($sepChars);$i++)
   {
     if(strchr($localFormat,$sepChars[$i]))
	 {
	    $localSeparator=$sepChars[$i];
        $localArray=explode($localSeparator,$localFormat);
		break;
	 }
   }
   
   for($i=0;$i<3;$i++)
   {
     if($localArray[$i]=='yyyy') $localArray[$i]=$stdArray[0];
	  elseif($localArray[$i]=='mm') $localArray[$i]=$stdArray[1];
	    elseif($localArray[$i]=='dd') $localArray[$i]=$stdArray[2];
   }
   
   //if ($lang=='de') $stdTime=strtr($stdTime,':','.'); // This is a hard coded time  format translator for german "de" language
   
   if($retTime) return implode($localSeparator,$localArray).' '.$stdTime;
    else return implode($localSeparator,$localArray);
   
}

function formatShortDate2Local($month,$day,$localFormat)
{
   if(!$sepChars) $sepChars=array('-','.','/',':',',');
   $localFormat=strtolower($localFormat); 
   
 
   /* Detect time separator and explode localFormat */
   for($i=0;$i<sizeof($sepChars);$i++)
   {
     if(strchr($localFormat,$sepChars[$i]))
	 {
	    $localSeparator=$sepChars[$i];
        $localArray=explode($localSeparator,$localFormat);
		break;
	 }
   }
   
   for($i=0;$i<3;$i++)
   {
     if($localArray[$i]=='yyyy') $s_tag=$i;
	  elseif($localArray[$i]=='mm') $localArray[$i]=$month;
	    elseif($localArray[$i]=='dd') $localArray[$i]=$day;
   }
   
   array_splice($localArray,$s_tag,1);
   return implode($localSeparator,$localArray);
   
}


function formatDate2STD($localDate,$localFormat,&$sepChars)
{
   $finalDate=0;
   $localFormat=strtolower($localFormat);

   if(!$sepChars) $sepChars=array('-','.','/',':',',');

	  if(stristr('0000',$finalDate)) $finalDate=0;

   
   if(!$finalDate)
   {
     
	 for($i=0;$i<sizeof($sepChars);$i++)
	 {
        if(strchr($localDate,$sepChars[$i]))
		{
	       $loc_array=explode($sepChars[$i],$localDate);
		   break;
		}
	 }
     
	 for($i=0;$i<sizeof($sepChars);$i++)
	 {
        if(strchr($localFormat,$sepChars[$i]))
		{
	       $Format_array=explode($sepChars[$i],$localFormat);
		   break;
		}
	 }
	 
	 /* Detect local format and reformat the local time to DATE standard */
	 for($i=0;$i<3;$i++)
	 {
	    if($Format_array[$i]=='yyyy')   	{ $vYear = $loc_array[$i];}
		 elseif($Format_array[$i]=='mm') { $vMonth = $loc_array[$i];}
		   elseif($Format_array[$i]=='dd') { $vDay = $loc_array[$i];}
	 }
	 
	 # if invalid numeric return empty string
	 if(!is_numeric($vYear)||!is_numeric($vMonth)||!is_numeric($vDay)){
	 	$finalDate= '';
 	 }else{
		  # DATE standard
		  if(strlen($vMonth)==1) $vMonth='0'.$vMonth;
		  if(strlen($vDay)==1) $vDay='0'.$vDay;
		 $finalDate=$vYear.'-'.$vMonth.'-'.$vDay; 
	}
     
   }
   return $finalDate;
}

/**
* convertTimeStandard() will return a time in the format HH:mm:ss
* param $time_val = the time value to be converted
* return = the time in the format HH:mm:ss
*/
function convertTimeToStandard($time_val)
{
   $time_val=strtr($time_val,'.,/-','::::'); // convert the separators to ':'
   
   $sep_count=substr_count($time_val,':');
   
   switch($sep_count)
   {
     case '': $time_val.=':00:00'; break;
     case 0: $time_val.=':00:00'; break;
     case 1: $time_val.=':00';
   }
   
   return $time_val;
}

/**
* convertTimeLocal() will return a time in the local format 
* param $time_val = the time value to be converted in HHxMMxSS, where x is the separator which will be converted to ":"
* return = the time in the format HH:mm:ss
*/
function convertTimeToLocal($time_val)
{
   global $lang;
   
   switch($lang)
   {
     //case 'de': $time_val=strtr($time_val,':,/-','....'); break; # convert the separators to '.' 
     default : $time_val=strtr($time_val,'.,/-','::::'); # convert the separators to ':'
   }
   
   //return $time_val;
   return substr($time_val,0,strrpos($time_val,':'));
}

# Now load the date format
$date_format=getDateFormat();

?>