<?
if(!function_exists('weeks_in_month'))
{
	function weeks_in_month($month, $year) {
		$start = mktime(0, 0, 0, $month, 1, $year);
		$end = mktime(0, 0, 0, $month, date('t', $start), $year);
		$start_week = date('W', $start);
		$end_week = date('W', $end);
		if ($end_week < $start_week) { 
			return ((52 + $end_week) - $start_week) + 1;
		}
		return ($end_week - $start_week) + 1;
	}
}
if(!function_exists('fixStupidAngularDate'))
{
	function fixStupidAngularDate($date)
	{
		if($date == 'undefined' || empty($date))
		{
			return "";
		}
		else
		{
			$dateData = explode(" ", $date);
			$startDate = $dateData[1].' '.$dateData[2].' '.$dateData[3];
			$result = date("Y-m-d", strtotime($startDate));
			if(strtotime($date) != 0)
			{
				return $date;
			}
			else
			{
				return $result;
			}
		}
	}
}
if(!function_exists('safeString'))
{
	function safeString($string)
	{
		$string = strip_tags($string);
		$string = stripslashes($string);
		return preg_replace('/[^A-Za-z0-9\-\@\.\_\ ]/', '', $string);
	}
}
if(!function_exists('siid')) {
	function siid() {
		return sprintf(
		   '%04x%04x%04x%04x%04x%04x%04x%04x',
			mt_rand(0, 65535), mt_rand(0, 65535), mt_rand(0, 65535), mt_rand(0, 65535),
			mt_rand(0, 65535), mt_rand(0, 65535), mt_rand(0, 65535), mt_rand(0, 65535)
		);
	}
}
if(!function_exists('num_to_letter'))
{
	function num_to_letter($num, $cap) 
	{
	    switch($num) {
	        case "1"  : ($cap)?$letter="A":$letter = "a"; break;
	        case "2"  : ($cap)?$letter="B":$letter = "b"; break;
	        case "3"  : ($cap)?$letter="C":$letter = "c"; break;
	        case "4"  : ($cap)?$letter="D":$letter = "d"; break;
	        case "5"  : ($cap)?$letter="E":$letter = "e"; break;
	        case "6"  : ($cap)?$letter="F":$letter = "f"; break;
	        case "7"  : ($cap)?$letter="G":$letter = "g"; break;
	        case "8"  : ($cap)?$letter="H":$letter = "h"; break;
	        case "9"  : ($cap)?$letter="I":$letter = "i"; break;
	        case "10" : ($cap)?$letter="J":$letter = "j"; break;
	        case "11" : ($cap)?$letter="K":$letter = "k"; break;
	        case "12" : ($cap)?$letter="L":$letter = "l"; break;
	        case "13" : ($cap)?$letter="M":$letter = "m"; break;
	        case "14" : ($cap)?$letter="N":$letter = "n"; break;
	        case "15" : ($cap)?$letter="X":$letter = "x"; break;
	        case "16" : ($cap)?$letter="P":$letter = "p"; break;
	        case "17" : ($cap)?$letter="Q":$letter = "q"; break;
	        case "18" : ($cap)?$letter="R":$letter = "r"; break;
	        case "19" : ($cap)?$letter="S":$letter = "s"; break;
	        case "20" : ($cap)?$letter="T":$letter = "t"; break;
	        case "21" : ($cap)?$letter="U":$letter = "u"; break;
	        case "22" : ($cap)?$letter="V":$letter = "v"; break;
	        case "23" : ($cap)?$letter="W":$letter = "w"; break;
	        case "24" : ($cap)?$letter="X":$letter = "x"; break;
	        case "25" : ($cap)?$letter="Y":$letter = "y"; break;
	        case "26" : ($cap)?$letter="Z":$letter = "z"; break;
			default: $letter = "No letter for that number";
	    }
	    return $letter;
	}	
}
if(!function_exists('XMLtoArray'))
{
	function XMLtoArray($XML)
	{
		$xml_parser = xml_parser_create();
		xml_parse_into_struct($xml_parser, $XML, $vals);
		xml_parser_free($xml_parser);
		// wyznaczamy tablice z powtarzajacymi sie tagami na tym samym poziomie
		$_tmp='';
		foreach ($vals as $xml_elem) {
			$x_tag=$xml_elem['tag'];
			$x_level=$xml_elem['level'];
			$x_type=$xml_elem['type'];
			if ($x_level!=1 && $x_type == 'close') {
				if (isset($multi_key[$x_tag][$x_level]))
					$multi_key[$x_tag][$x_level]=1;
				else
					$multi_key[$x_tag][$x_level]=0;
			}
			if ($x_level!=1 && $x_type == 'complete') {
				if ($_tmp==$x_tag)
					$multi_key[$x_tag][$x_level]=1;
				$_tmp=$x_tag;
			}
		}
		// jedziemy po tablicy
		foreach ($vals as $xml_elem) {
			$x_tag=$xml_elem['tag'];
			$x_level=$xml_elem['level'];
			$x_type=$xml_elem['type'];
			if ($x_type == 'open')
				$level[$x_level] = $x_tag;
			$start_level = 1;
			$php_stmt = '$xml_array';
			if ($x_type=='close' && $x_level!=1)
				$multi_key[$x_tag][$x_level]++;
			while ($start_level < $x_level) {
				$php_stmt .= '[$level['.$start_level.']]';
				if (isset($multi_key[$level[$start_level]][$start_level]) && $multi_key[$level[$start_level]][$start_level])
					$php_stmt .= '['.($multi_key[$level[$start_level]][$start_level]-1).']';
				$start_level++;
			}
			$add='';
			if (isset($multi_key[$x_tag][$x_level]) && $multi_key[$x_tag][$x_level] && ($x_type=='open' || $x_type=='complete')) {
				if (!isset($multi_key2[$x_tag][$x_level]))
					$multi_key2[$x_tag][$x_level]=0;
				else
					$multi_key2[$x_tag][$x_level]++;
				$add='['.$multi_key2[$x_tag][$x_level].']';
			}
			if (isset($xml_elem['value']) && trim($xml_elem['value'])!='' && !array_key_exists('attributes', $xml_elem)) {
				if ($x_type == 'open')
					$php_stmt_main=$php_stmt.'[$x_type]'.$add.'[\'content\'] = $xml_elem[\'value\'];';
				else
					$php_stmt_main=$php_stmt.'[$x_tag]'.$add.' = $xml_elem[\'value\'];';
				eval($php_stmt_main);
			}
			if (array_key_exists('attributes', $xml_elem)) {
				if (isset($xml_elem['value'])) {
					$php_stmt_main=$php_stmt.'[$x_tag]'.$add.'[\'content\'] = $xml_elem[\'value\'];';
					eval($php_stmt_main);
				}
				foreach ($xml_elem['attributes'] as $key=>$value) {
					$php_stmt_att=$php_stmt.'[$x_tag]'.$add.'[$key] = $value;';
					eval($php_stmt_att);
				}
			}
		}
		return $xml_array;
	}
}
if(!function_exists('fieldSort')) {
	function fieldSort($ARRAY, $sort, $direction) {
		foreach($ARRAY as $key => $value) {
			$B_ARR[$key] = strtolower($value[$sort]);
		}
		if($direction=="DESC") {
			arsort($B_ARR);
		} else {
			asort($B_ARR);
		}
		foreach($B_ARR as $key =>$value) {
			$C_ARR[] = $ARRAY[$key];
		}
		return $C_ARR; 
	}
}
if(!function_exists('escape')) 
{
	function escape($string)
	{
		global $db;
		$string = $db->clean($string);
		$string = htmlentities($string);
		return $string;
	}
}
if(!function_exists('createZip')) 
{
	function createZip($zipFiles = array(), $destination = '', $overwrite = false) 
	{
		if(file_exists($destination) && !$overwrite) 
		{ 
			return false; 
		}
		$validFiles = array();
		if(count($zipFiles) > 0) 
		{
			foreach($zipFiles as $files => $file) 
			{
				if(file_exists($file['url'])) 
				{
					array_push($validFiles, $file);
				}
			}
		}
		else
		{
			return false; 	
		}
		if(count($validFiles) > 0) 
		{
			$zip = new ZipArchive();
			if($zip->open($destination, $overwrite ? ZIPARCHIVE::OVERWRITE : ZIPARCHIVE::CREATE) !== true) 
			{
				return false; 	
			}
			foreach($validFiles as $files => $file) 
			{
				$zip->addFile($file['url'], $file['locale']);
			}
			$zip->close();
			return file_exists($destination);
		}
		else
		{
			return false; 	
		}
	}
}
if(!function_exists('dollarFormat'))
{
	function dollarFormat($amount)
	{
		$formattedAmount = number_format(floor($amount * 100) / 100, 2, '.', '');	
		return $formattedAmount;
	}
}
if(!function_exists('convertToLocalTime')) 
{
	function convertToLocalTime($time, $zip, $db) 
	{
		if(!empty($zip) && !empty($time))
		{
			$times = explode(":", $time);
			$hours = $times[0];
			$utcOffset = $db->query("
										SELECT 
												* 
										FROM geo.zip_codes
										WHERE 
											zip = '".$zip ."'
										LIMIT 1
									");
			$UTC_offset = ($utcOffset[0]['timezone'] * -1);
			
			if($UTC_offset == 8)
			{
				$timeZone = "PST";	
			}
			else if($UTC_offset == 7)
			{
				$timeZone = "MST";	
			}
			else if($UTC_offset == 6)
			{
				$timeZone = "CT";	
			}
			else if($UTC_offset == 5)
			{
				$timeZone = "EST";	
			}
			else if($UTC_offset == 10)
			{
				$timeZone = "HST";	
			}
			else if($UTC_offset == 9)
			{
				$timeZone = "AKST";	
			}
			$startOffset = $UTC_offset;
			$hasDST = false;
			$dateAdjustment = date("Y-m-d");
			$dateAdjustment = strtotime($dateAdjustment);
			$startDST = strtotime(date("Y")."-03-13");
			$endDST = strtotime(date("Y")."-11-06");
			if($dateAdjustment > $startDST && $dateAdjustment < $endDST)
			{
				$hasDST = true;
			}
			if($startOffset > 7)
			{
				if($hasDST)
				{
					$UTC_offset = $UTC_offset - 7;	
				}
				else
				{
					$UTC_offset = $UTC_offset - 6;	
				}
			}
			else
			{
				if($hasDST)
				{
					$UTC_offset = 7 - $UTC_offset;		
				}
				else
				{
					$UTC_offset = 8 - $UTC_offset;	
				}
			}
			if($hasDST)
			{
				if($startOffset == 8)
				{
					$timeZone = "PDT";	
				}
				else if($startOffset == 7)
				{
					$timeZone = "MDT";	
				}
				else if($startOffset == 6)
				{
					$timeZone = "CDT";	
				}
				else if($startOffset == 5)
				{
					$timeZone = "EDT";	
				}
			}
			else
			{
				$UTC_offset = $UTC_offset - $utcOffset[0]['dst'];
			}
			if($startOffset > 7)
			{
				$hours = $hours - $UTC_offset;
			}
			else
			{
				$hours = $hours + $UTC_offset;
			}
			$time = $hours.":".$times[1];
			return array("time"=>$time, "zone"=>$timeZone);
		}
		else
		{
			return array("time"=>$time, "zone"=>"MST");	
		}
	}
}
if(!function_exists('convertFromLocalTime')) 
{
	function convertFromLocalTime($time, $zip, $db) 
	{
		if(!empty($zip) && !empty($time))
		{
			$times = explode(":", $time);
			$hours = $times[0];
			$utcOffset = $db->query("
										SELECT 
												* 
										FROM geo.zip_codes
										WHERE 
											zip = '".$zip ."'
										LIMIT 1
									");
			$UTC_offset = ($utcOffset[0]['timezone'] * -1);
			if($UTC_offset == 8)
			{
				$timeZone = "PST";	
			}
			else if($UTC_offset == 7)
			{
				$timeZone = "MST";	
			}
			else if($UTC_offset == 6)
			{
				$timeZone = "CT";	
			}
			else if($UTC_offset == 5)
			{
				$timeZone = "EST";	
			}
			else if($UTC_offset == 10)
			{
				$timeZone = "HST";	
			}
			else if($UTC_offset == 9)
			{
				$timeZone = "AKST";	
			}
			$startOffset = $UTC_offset;
			$hasDST = false;
			$dateAdjustment = date("Y-m-d");
			$dateAdjustment = strtotime($dateAdjustment);
			$startDST = strtotime(date("Y")."-03-13");
			$endDST = strtotime(date("Y")."-11-06");
			if($dateAdjustment > $startDST && $dateAdjustment < $endDST)
			{
				$hasDST = true;
			}
			if($startOffset > 7) 
			{
				if($hasDST)
				{
					$UTC_offset = $UTC_offset - 7;	
				}
				else
				{
					$UTC_offset = $UTC_offset - 6;	
				}
			}
			else
			{
				if($hasDST)
				{
					$UTC_offset = 7 - $UTC_offset;		
				}
				else
				{
					$UTC_offset = 8 - $UTC_offset;	
				}
			}
			if($hasDST)
			{
				if($startOffset == 8)
				{
					$timeZone = "PDT";	
				}
				else if($startOffset == 7)
				{
					$timeZone = "MDT";	
				}
				else if($startOffset == 6)
				{
					$timeZone = "CDT";	
				}
				else if($startOffset == 5)
				{
					$timeZone = "EDT";	
				}
				else if($startOffset == 5)
				{
					$timeZone = "EDT";	
				}
			}
			else
			{
				$UTC_offset = $UTC_offset - $utcOffset[0]['dst'];
				
			}
			if($startOffset > 7)
			{
				$hours = $hours + $UTC_offset;
			}
			else
			{
				$hours = $hours - $UTC_offset;
			}
			$time = $hours.":".$times[1];
			return array("time"=>$time, "zone"=>$timeZone);
		}
		else
		{
			return array("time"=>$time, "zone"=>"MST");	
		}
	}
}
?>