";
		print_r($p_array);
		print "

TABLICA JEST PUSTA

\n"); } else { print("\n"); print("\n"); // for (reset($array_name); (strcmp(($key=key($array_name)) ,"")); next($array_name)){ while (list($key, $value) = each($array_name)) { if (strcmp($key,"GLOBALS") == 0) $user_defined = 0; if ($user_defined == 1) continue; if ((is_array($value) || is_object($value)) && (strcmp($key,"GLOBALS") != 0)) { print("\n"); } else { print("\n"); } if (++$indexBreak>1000) { break; } } print("

".$array_name."
".substr(gettype($key),0,3).">".str_replace(" "," ",$key)."<".(is_object($array_name) ? 'b.d.' : count($array_name[$key]))."	"); Utils::ArrayDisplayOld($value); print ("
".substr(gettype($key),0,3).">".str_replace(" "," ",$key)."<"); print("	".substr(gettype($value),0,3).">".str_replace(" "," ",$value)."<

\n"); @reset($array_name); } } /** * Przeszukiwanie tablicy na podstawie zadanych tekst�w * * @param Array $array * @param string $keySearchStart * @param string $keySearchEnd * @return int */ public static function GetArrayKeyNumberDifference($array, $keySearchStart, $keySearchEnd) { $index = 0; foreach ($array as $key => $value) { if ($key==$keySearchStart) { $indexStart = $index; } if ($key==$keySearchEnd) { $indexEnd = $index; break; // przerywamy bo nie mamy czego szukac } $index++; } $difference = $indexEnd-$indexStart; return $difference; } /** * Zwraca rozszerzenie pliku na podstawie nazwy * * @param string $fileName * @return string */ public static function FileExtFromName($fileName) { $array = explode('.', $fileName); $ext = $array[count($array)-1]; return $ext; } /** * Zwraca nazwe pliku bez rozszerzenia * * @param string $fileName * @return string */ public static function FileNameFromName($fileName) { $array = explode('.', $fileName); unset($array[count($array)-1]); $fileName = implode('.', $array); return $fileName; } /** * Wykonuje redirect * * @param string $url */ public static function Redirect($url,$error =false) { $url = str_replace('&', '&', $url); header( "HTTP/1.1 $error"); header("Location: ".$url); exit(); } /** * Porz�dkuje entery (zwaraca tekst z enterami w zadanej postaci) * * @param string $p_text * @param string $p_enter * @return string */ function GetSaveEnterInText($p_text, $p_enter = null) { $enter = is_null($p_enter) ? chr(13) : $p_enter; $text = $p_text; $text = str_replace("\r\n", "\n", $text); $text = str_replace("\r", "", $text); $text = str_replace("\n", $enter, $text); return $text; } /** * Wy�wietla zapytania (funcja do debugowania) * */ function DisplayQueries() { echo count($_SESSION['queries']).'
'; sort($_SESSION['queries']); Utils::ArrayDisplayOld($_SESSION['queries']); unset($_SESSION['queries']); } public static function RemovePolish($string) { $letters = array('ę'=>'e', 'ó'=>'o', 'ą'=>'a', 'ś'=>'s', 'ł'=>'l', 'ź'=>'z', 'ż'=>'z', 'ć'=>'c', 'ń'=>'n', 'Ę'=>'e', 'Ó'=>'O', 'Ą'=>'A', 'Ś'=>'S', 'Ł'=>'L', 'Ż'=>'Z', 'Ź'=>'Z', 'Ć'=>'C', 'Ń'=>'N'); $string = strtr($string, $letters); foreach($letters as $letters=>$replacement) { $string = str_replace($letters, $replacement, $string); } return strtolower($string); } public static function RemovePolishNoToLower($string) { $letters = array('ę'=>'e', 'ó'=>'o', 'ą'=>'a', 'ś'=>'s', 'ł'=>'l', 'ź'=>'z', 'ż'=>'z', 'ć'=>'c', 'ń'=>'n', 'Ę'=>'e', 'Ó'=>'O', 'Ą'=>'A', 'Ś'=>'S', 'Ł'=>'L', 'Ż'=>'Z', 'Ź'=>'Z', 'Ć'=>'C', 'Ń'=>'N'); $string = strtr($string, $letters); foreach($letters as $letters=>$replacement) { $string = str_replace($letters, $replacement, $string); } return $string; } public static function TextToUrl($string) { $letters = array(' '=> '_', '/'=> '_', 'ę'=>'e', 'ó'=>'o', 'ą'=>'a', 'ś'=>'s', 'ł'=>'l', 'ź'=>'z', 'ż'=>'z', 'ć'=>'c', 'ń'=>'n', 'Ę'=>'e', 'Ó'=>'O', 'Ą'=>'A', 'Ś'=>'S', 'Ł'=>'L', 'Ż'=>'Z', 'Ź'=>'Z', 'Ć'=>'C', 'Ń'=>'N'); $string = strtr($string, $letters); foreach($letters as $letters=>$replacement) { $string = str_replace($letters, $replacement, $string); } return urlencode(strtolower(strip_tags($string))); } public static function AddSlashes($string) { if (get_magic_quotes_gpc() == 1) { return $string; } else { return addslashes($string); } } public static function TextToTitle($string) { $string = str_replace('"', '', (strip_tags($string))); return $string; } /** * Zamienia polskie znaki zakodowane utf pobrane z adresu url(param) na polskie znaki :) * */ function url2pl($text) { // $text = str_replace("", '/', $text); $text = str_replace("%2F", '/', $text); $text = str_replace("\xC4\x85", 'ą', $text); $text = str_replace("\xC4\x84", 'Ą', $text); $text = str_replace("\xC4\x87", 'ć', $text); $text = str_replace("\xC4\x86", 'Ć', $text); $text = str_replace("\xC4\x99", 'ę', $text); $text = str_replace("\xC4\x98", 'Ę', $text); $text = str_replace("\xC5\x82", 'ł', $text); $text = str_replace("\xC5\x81", 'Ł', $text); $text = str_replace("\xC3\xB3", 'ó', $text); $text = str_replace("\xC3\x93", 'Ó', $text); $text = str_replace("\xC5\x9B", 'ś', $text); $text = str_replace("\xC5\x9A", 'Ś', $text); $text = str_replace("\xC5\xBC", 'ż', $text); $text = str_replace("\xC5\xBB", 'Ż', $text); $text = str_replace("\xC5\xBA", 'ż', $text); $text = str_replace("\xC5\xB9", 'Ż', $text); $text = str_replace("\xc5\x84", 'ń', $text); $text = str_replace("\xc5\x83", 'Ń', $text); return $text; } function specjalSearchSing($text) { $text = str_replace("%2F", '%252F', $text); $text = str_replace("/", '%252F', $text); return $text; } public static function cleanUrl($text) { $text=strtolower($text); $code_entities_match = array(' ','--','"','!','@','#','$','%','^','&','*','(',')','+','{','}','|',':','"','<','>','?','[',']','\\',';',"'",',','.','/','*','+','~','`','='); $code_entities_replace = array('-','-','','','','','','','','','','','','','','','','','','','','','','',''); $text = str_replace($code_entities_match, $code_entities_replace, $text); return $text; } public function cleanUrlSpaces($text) { $text=strtolower($text); $code_entities_match = array(' ','--','"','!','@','#','$','%','^','&','*','(',')','_','+','{','}','|',':','"','<','>','?','[',']','\\',';',"'",',','.','/','*','+','~','`','='); $code_entities_replace = array(' ','-','','','','','','','','','','','','','','','','','','','','','','','',''); $text = str_replace($code_entities_match, $code_entities_replace, $text); return $text; } /** * Pomocnicza f sortuj�ca * */ public static function sortIt($objA, $objB, $key = 'count'){ if ($objA[$key] == $objB[$key]) return 0; return ($objA[$key] > $objB[$key]) ? -1 : 1; } public function MakeImageUrlFromHeader($headerTitle) { $exp = explode(" ", $headerTitle); $imgUrl = ''; foreach ($exp as $e) { $imgUrl .= ucfirst(strtr(strtolower($e), "žążśźęćń󳥯ŚŹĘĆŃÓŁ?!.,:", "zazszecnolAZSZECNOL_____")); } return $imgUrl; } /** * Pomocnicza f sortuj�ca * */ public static function sortByQO($objA, $objB){ self::sortIt($objA, $objB, 'queue_order'); } /** * Rozpoczyna mpomiar czasu * */ public static function TimerStart() { // Rozpoczynamy pomiar czasu wykonywania skryptu $mtime = microtime(); $mtime = explode(" ",$mtime); $mtime = $mtime[1] + $mtime[0]; $starttime = $mtime; // --> } /** * Konczy pomiar czasu * * @return string */ public static function TimerEnd() { // Konczymy pomiar czasu wykonywania skryptu $mtime = microtime(); $mtime = explode(" ",$mtime); $mtime = $mtime[1] + $mtime[0]; $endtime = $mtime; $totaltime = ($endtime - $starttime); return $totaltime; } /** * Zapisuje sortowanie dla podanej tabeli * * @param array $p_arraySort tablica id'k�w * @param string $sortColumn kolumna sortowania * @param string $table tabla sortowania * @param string $idColumn po jakim id'ku sorujemy */ public static function SaveSort($arraySort, $sortColumn, $table, $idColumn) { $db = Registry::Get('db'); if (count($arraySort)) { foreach ($arraySort as $id => $value) { $sql = 'UPDATE '.$table.' SET '.$sortColumn.'='.$value.' WHERE '.$idColumn.' = '.$id; //Utils::ArrayDisplay($sql); $db->execute($sql); } } } /** * Filtr danych XSS * * @param string $val * @return string */ public static function RemoveXss($val) { // $val = preg_replace('/([\x00-\x08,\x0b-\x0c,\x0e-\x19])/', '', $val); if(Config::Get('site')!='Admin') { $search = 'aąbcćdeęfghijklłmnoópqrsśtuvwxyzżź'; $search .= 'AĄBCĆDEĘFGHIJKLŁMNOÓPQRSŚTUVWXYZŻŹ'; $search .= '1234567890!@#$%^&*()'; $search .= '~`";:?+/={}[]-_|\'\\'; for ($i = 0; $i < strlen($search); $i++) { $val = preg_replace('/(&#[xX]0{0,8}'.dechex(ord($search[$i])).';?)/i', $search[$i], $val); $val = preg_replace('/(�{0,8}'.ord($search[$i]).';?)/', $search[$i], $val); } $ra1 = Array('javascript', 'vbscript', 'expression', 'applet', 'meta', 'xml', 'blink', 'link', 'style', 'script', 'embed', 'object', 'iframe', 'frame', 'frameset', 'ilayer', 'layer', 'bgsound'); $ra2 = Array('onabort', 'onactivate', 'onafterprint', 'onafterupdate', 'onbeforeactivate', 'onbeforecopy', 'onbeforecut', 'onbeforedeactivate', 'onbeforeeditfocus', 'onbeforepaste', 'onbeforeprint', 'onbeforeunload', 'onbeforeupdate', 'onblur', 'onbounce', 'oncellchange', 'onchange', 'onclick', 'oncontextmenu', 'oncontrolselect', 'oncopy', 'oncut', 'ondataavailable', 'ondatasetchanged', 'ondatasetcomplete', 'ondblclick', 'ondeactivate', 'ondrag', 'ondragend', 'ondragenter', 'ondragleave', 'ondragover', 'ondragstart', 'ondrop', 'onerror', 'onerrorupdate', 'onfilterchange', 'onfinish', 'onfocus', 'onfocusin', 'onfocusout', 'onhelp', 'onkeydown', 'onkeypress', 'onkeyup', 'onlayoutcomplete', 'onload', 'onlosecapture', 'onmousedown', 'onmouseenter', 'onmouseleave', 'onmousemove', 'onmouseout', 'onmouseover', 'onmouseup', 'onmousewheel', 'onmove', 'onmoveend', 'onmovestart', 'onpaste', 'onpropertychange', 'onreadystatechange', 'onreset', 'onresize', 'onresizeend', 'onresizestart', 'onrowenter', 'onrowexit', 'onrowsdelete', 'onrowsinserted', 'onscroll', 'onselect', 'onselectionchange', 'onselectstart', 'onstart', 'onstop', 'onsubmit', 'onunload'); $htmlStart = '/\"\s*>/'; $ra = array_merge($ra1, $ra2); $found = true; while ($found == true) { $val_before = $val; for ($i = 0; $i < sizeof($ra); $i++) { $pattern = '/'; for ($j = 0; $j < strlen($ra[$i]); $j++) { if ($j > 0) { $pattern .= '('; $pattern .= '(&#[xX]0{0,8}([9ab]);)'; $pattern .= '|'; $pattern .= '|(�{0,8}([9|10|13]);)'; $pattern .= ')*'; } $pattern .= $ra[$i][$j]; } $pattern .= '/i'; $replacement = substr($ra[$i], 0, 2).''.substr($ra[$i], 2); $val = preg_replace($pattern, $replacement, $val); $val = preg_replace($htmlStart, "", $val); if ($val_before == $val) { $found = false; } } } } return $val; } /** * Zwraca sliczna date * * @param string $datetime * @return string */ public static function NiceDate($datetime, $noShort = false, $format = null, $time_format = null) { $date = strtotime($datetime); if (!$date) { $date = (int)$datetime; } $now = time(); $out = ''; if($format == null) $format = Registry::Get('DATE_SHORT_FORMAT'); if($time_format == null) $time_format = Registry::Get('TIME_DEFAULT_FORMAT'); if (!$noShort) { if(date(Registry::Get('DATE_SHORT_FORMAT'), $date) == date(Registry::Get('DATE_SHORT_FORMAT'), $now)) { $out = "Dzisiaj, " . strftime($time_format, $date); } else if(date(Registry::Get('DATE_SHORT_FORMAT'), $date) == date(Registry::Get('DATE_SHORT_FORMAT'), $now - 86400)) { $out = "Wczoraj, " . strftime($time_format, $date); } else if(stristr(PHP_OS, "WIN")) { $out = ucfirst(iconv("CP1250", "ISO-8859-2", strftime($format, $date))); } else { $out = ucfirst(strftime($format, $date)); } } else { if(stristr(PHP_OS, "WIN")) { $out = ucfirst(iconv("CP1250", "ISO-8859-2", strftime($format, $date))); } else { $out = ucfirst(strftime($format, $date)); } } return $out; } /** * Pod�wietla s�owa wyst�puj�ce w tytule i tre�ci. * Nale�y przekaza� mu DataObject. * Fields - pola po przecinku, w kt�rych ma by� wyr�nione slowo wyszukania. * $hlBegin - tekst wstawiony przed szukabym s�owem * $hlEnd - tekst wstawiony po szukabym s�owie * * @param DataObject $array * @param string $search * @param string $fields * @param string $hlBegin * @param string $hlEnd */ public static function HighlightText(&$array, $search, $fields = 'Title,Text,Tag', $hlBegin = HL_BEGIN, $hlEnd = HL_END) { $search = strtolower($search); $replace = "$hlBegin$search$hlEnd"; $field = explode(',', $fields); if (is_array($array)){ foreach ($array as $obj) { for ($i = 0 ; $i < count($field) ; $i++) { if($field[$i]=='Tag'){ $methodGet = "Get" . trim($field[$i]); $methodSet = "Set" . trim($field[$i]); $value = $obj->$methodGet(); $arrayValue = explode(',', $value); $done = array(); foreach ($arrayValue as $tagObj) { if(strtolower($tagObj) == strtolower($search)){ $tagObj = $replace; array_unshift($done, $tagObj); } else { $done[] = $tagObj; } } $value = implode(',', $done); $obj->$methodSet($value); } else { $methodGet = "Get" . trim($field[$i]); $methodSet = "Set" . trim($field[$i]); $value = $obj->$methodGet(); $obj->$methodSet(str_ireplace($search, $replace, $value)); } } } } else{ for ($i = 0 ; $i < count($field) ; $i++) { if($field[$i]=='Tag'){ $methodGet = "Get" . trim($field[$i]); $methodSet = "Set" . trim($field[$i]); $value = $obj->$methodGet(); $arrayValue = explode(',', $value); $done = array(); foreach ($arrayValue as $tagObj) { if(strtolower($tagObj) == strtolower($search)){ $tagObj = $replace; array_unshift($done, $tagObj); } else { $done[] = $tagObj; } } $value = implode(',', $done); $obj->$methodSet($value); } else { $methodGet = "Get" . trim($field[$i]); $methodSet = "Set" . trim($field[$i]); $value = $obj->$methodGet(); $obj->$methodSet(str_ireplace($search, $replace, $value)); } } } } /** * Zwraca dat� - miesi�c za kt�ry przyznana zosta�a nagroda. * */ public static function AwardDate() { $month = (int)date('m'); $year = (int)date('Y'); //Od 21 nagrody przyznajemy za obecny miesiac, wcze�niej za miniony if ((int)date('d') < 21) { $month --; if ($month == 0) { $month = 12; $year --; } } return $year.$month."01"; } /** * counts elements of an multidimensional array * * @param array $array Input Array * @param int $limit dimensions that shall be considered (-1 means no limit ) * @return int counted elements */ public static function Multicount ($array, $limit = -1) { $cnt = 0; $limit = $limit > 0 ? (int) $limit : -1; $arrs[] = $array; for ($i=0; isset($arrs[$i]) && is_array($arrs[$i]); ++$i) { foreach ($arrs[$i] as $value) { if (!is_array($value) ) ++$cnt; elseif( $limit==-1 || $limit>1 ) { if( $limit>1 ) --$limit; $arrs[] = $value; } } } return $cnt; } /** * Konwertuje tablicę do formatu jSon'a. * * @param array $array * @return string */ public static function Array2Json($array) { $output = "{"; foreach ($array as $key=>$val) { if (is_array($val)) { $output .= "\"".$key."\" : [" . Array2Json($val) ."],"; } else { $output .= "\"".$key."\" : \"".$val."\","; } } $output .= "}"; return $output; } /** * funkcja wypisujaca js wypisujacego adres email * * @param $email - adres email * @param $cssClass - klasa css dla linka */ public static function jsEmail($email,$cssClass = null) { $s = ''; return $s; } /** * funkcja przypisuje cyfrom z lancucha wartosci literowe (na potrzeby LUCENE) * @param string $var * @return string */ public static function codeIntToChar($var) { $out = null; //var_dump($var); $lenght = strlen($var); $var = (string)$var; for($i = 0; $i < $lenght; $i++) { if(in_array($var[$i], array('0', '1', '2', '3', '4', '5', '6', '7', '8', '9'))) { $out .= chr(107 + $var[$i]); } else { $out .= $var[$i]; } } //var_dump($out); //if($lenght < 3) { // $out = 'zxc'.$out; //} return $out; } public static function codeCharToInt($var) { $out = null; $lenght = strlen($var); $var = (string)$var; for($i = 0; $i < $lenght; $i++) { $ord = ord($var[$i]) - 107; $out .= $ord; } //TODO - obsluga dla mniejszych liczb niz 3 cyfry if($lenght < 3) { $out = 'zxc'.$out; } return $out; } /** * Metoda tworzy katalogi * * @param string $dir sciezka katalog�w * @param int $mode prawa zapisu * @param bool $recursive czy ma tworzy� katalogi rekursywnie * @return bool */ public static function Mkdirs($dir, $mode = 0777, $recursive = true) { if( is_null($dir) || $dir === "" ){ return FALSE; } if( is_dir($dir) || $dir === DIRECTORY_SEPARATOR ){ return TRUE; } if( PhotoDAL::mkdirs(dirname($dir), $mode, $recursive) ){ return mkdir($dir, $mode); } return FALSE; } public static function dateDiff($date1, $date2) { //$date1 today, or any other day //$date2 date to check against $d1 = explode(" ", $date1); $y1 = $d1[0]; $m1 = $d1[1]; $d1 = $d1[2]; $d2 = explode(" ", $date2); $y2 = $d2[0]; $m2 = $d2[1]; $d2 = $d2[2]; $date1_set = mktime(0,0,0, $m1, $d1, $y1); $date2_set = mktime(0,0,0, $m2, $d2, $y2); return(round(($date2_set-$date1_set)/(60*60*24))); } public static function MultiImplode($glue, $pieces, $multiGlue = null) { $first = array_shift($pieces); if (!$multiGlue) { $multiGlue = $glue; } $ret = (is_array($first) ? self::MultiImplode($glue, $first, $multiGlue) : $first); foreach ($pieces as $item) { if (is_array($item)) { $ret .= $multiGlue . '' . self::MultiImplode($glue, $item); } else { $ret .= $glue . $item; } } return $ret; } public static function CleanString($str) { return str_replace(array('\"', "R11;", "R22;", "R21;", "R30;", "R17;"), array('"', '-', '”', '„', '', ''), $str); } public static function DisplayBackTrace($backtrace) { $backtrace = array_map(create_function('$a', 'return array($a["line"], $a["file"], $a["function"]);'), $backtrace); var_dump($backtrace); } /* * Zamienia " na ", < na < , > > */ public static function SaveInput($string, $type = 'input') { $patterns = array('/"/'); $replacements = array('"'); if($type == 'textarea') { $patterns = array('/"/', '//', '/<\/textarea>/'); $replacements = array('"', '<textarea>', '</textarea>'); } $str = preg_replace($patterns, $replacements, $string); return $str; } /* * Sortowanie * * array $param * array $fields - para 'nazwa z bazy' => 'nazwa wyswietlana' * string $session - identyfikacja zmiennych w sesji * string $defaultField * string $defaultOrder * */ public static function SortList($param, $fields, $session, $defaultField = 'kolejnosc', $defaultOrder = 'DESC') { $field = $fields[$defaultField]; $order = $defaultOrder; //Utils::ArrayDisplay($_SESSION); if(isset($param['sortuj'])) { foreach($fields as $dbfield => $appfield) { if($dbfield == $param['sortuj']) { $field = $appfield; } } $oorder = SessionProxy::GetValue('__sort_'.$session.'_index_order__'); //Utils::ArrayDisplay($oorder); if($oorder == 'ASC') { $order = 'DESC'; } else { $order = 'ASC'; } SessionProxy::SetValue('__sort_'.$session.'_index_order__', $order); SessionProxy::SetValue('__sort_'.$session.'_index_field__', $field); } else { $oorder = SessionProxy::GetValue('__sort_'.$session.'_index_order__'); if(!empty($oorder)) { $order = $oorder; } $ofield = SessionProxy::GetValue('__sort_'.$session.'_index_field__'); if(!empty($ofield)) { $field = $ofield; } } $smarty = Registry::Get('smarty'); $smarty->assign('tableSort', array($field, $order)); return sprintf(' %s %s ', $field, $order); } /** * * @param string $base - zadany ciag * @param string $string - szukany ciag na poczatku zadanego ciagu */ public static function TrimString($base, $string) { $cutLen = strlen($string); $trim = true; $done = $base; while($trim) { $begStr = substr($done, 0, $cutLen); if($string == $begStr) { $done = substr($done, $cutLen); } else { $trim = false; } } return $done; } function charset_utf_fix($string ) { $utf_iso = array( "\xc4\x85" => "\xb1", "\xc4\x84" => "\xa1", "\xc4\x87" => "\xe6", "\xc4\x86" => "\xc6", "\xc4\x99" => "\xea", "\xc4\x98" => "\xca", "\xc5\x82" => "\xb3", "\xc5\x81" => "\xa3", "\xc3\xb3" => "\xf3", "\xc3\x93" => "\xd3", "\xc5\x9b" => "\xb6", "\xc5\x9a" => "\xa6", "\xc5\xba" => "\xbc", "\xc5\xb9" => "\xac", "\xc5\xbc" => "\xbf", "\xc5\xbb" => "\xaf", "\xc5\x84" => "\xf1", "\xc5\x83" => "\xd1", // xmlhttprequest uses different encoding "%u0104" => "\xA1", "%u0106" => "\xC6", "%u0118" => "\xCA", "%u0141" => "\xA3", "%u0143" => "\xD1", "%u00D3" => "\xD3", "%u015A" => "\xA6", "%u0179" => "\xAC", "%u017B" => "\xAF", "%u0105" => "\xB1", "%u0107" => "\xE6", "%u0119" => "\xEA", "%u0142" => "\xB3", "%u0144" => "\xF1", "%u00D4" => "\xF3", "%u015B" => "\xB6", "%u017A" => "\xBC", "%u017C" => "\xBF" ); //$utf_iso = array_flip($utf_iso); //return strtr($string, $utf_iso); return str_replace(array_keys($utf_iso), array_values($utf_iso), $string); } /** * Funkcja przekazuje do smarty informacje o aktualnej stronie i ilo�ci stron, oraz * zwraca limit dla aktualenej strony. * * * @param <type> $smarty * @param <type> $strona * @param <type> $ilosc * @param <type> $perPage */ public static function PageConfigure(&$smarty, $param, $ilosc, $perPage = 10) { $iloscStron = ceil((int)$ilosc / $perPage); if (!isset($param['strona'])) { $strona = 0; } else { $strona = (int)$param['strona'] - 1; } if ($strona < 0) { $strona = 0; } else if ($strona > $iloscStron - 1) { $strona = $iloscStron - 1; } if ($strona < 0) { $strona = 0; } $offset = ($strona * $perPage); $limit = "$offset, $perPage"; $smarty->assign('strona', $strona); $smarty->assign('iloscStron', $iloscStron); return $limit; } /** * Wycina polskie znaki * * @param string $string * @return string */ public static function CleanStringQuery($string) { $letters = array( "ą"=>"a", "ę"=>"e", "ś"=>"s", "ć"=>"c", "ł"=>"l", "ń"=>"n", "ż"=>"z", "ź"=>"z", "ó"=>"o", "Ą"=>"A", "Ę"=>"E", "Ś"=>"S", "Ć"=>"C", "Ł"=>"L", "Ń"=>"N", "Ż"=>"Z", "Ź"=>"Z", "Ó"=>"O", "Ä"=>"A", "ä"=>"a", "Ö"=>"O", "ö"=>"o", "Ü"=>"U", "ü"=>"u", "Ë"=>"E", "ë"=>"e", "ß"=>"ss" ); foreach($letters as $letter=>$replacement) { $string = str_replace($letter, $replacement, $string); } return $string; } public static function GetNowDate() { return date("Y-m-d H:i:s"); } /** * +1 day"); " +1 week"); " +2 week"); " +1 month"); " +30 days") * * @param date $period */ public static function GetDate($period = '') { $date = date("Y-m-d H:i:s"); $date = strtotime($date); $date = date("Y-m-d H:i:s", strtotime($period, $date)); return $date; } function ClearSearch($string){ $letters = Array( 0xC0=>'A', 0xE0=>'a', 0xC1=>'A', 0xE1=>'a', 0xC2=>'A', 0xE2=>'a', 0xC3=>'A', 0xE3=>'a', 0xC4=>'A', 0xE4=>'a', 0xC5=>'A', 0xE5=>'a', 0xC6=>'E', 0xE6=>'e', 0xC7=>'C', 0xE7=>'c', 0xC8=>'E', 0xE8=>'e', 0xC9=>'E', 0xE9=>'e', 0xCA=>'E', 0xEA=>'e', 0xCB=>'E', 0xEB=>'e', 0xCC=>'I', 0xEC=>'i', 0xCD=>'I', 0xED=>'i', 0xCE=>'I', 0xEE=>'i', 0xCF=>'I', 0xEF=>'i', 0xD0=>'D', 0xF0=>'d', 0xD1=>'N', 0xF1=>'n', 0xD2=>'O', 0xF2=>'o', 0xD3=>'O', 0xF3=>'o', 0xD4=>'O', 0xF4=>'o', 0xD5=>'O', 0xF5=>'o', 0xD6=>'O', 0xF6=>'o', 0xD7=>'*', 0xF7=>'*', 0xD8=>'?', 0xF8=>'?', 0xD9=>'U', 0xF9=>'u', 0xDA=>'U', 0xFA=>'u', 0xDB=>'U', 0xFB=>'u', 0xDC=>'U', 0xFC=>'u', 0xDD=>'Y', 0xFD=>'y', 0xDF=>'B', 0xFF=>'y' ); foreach($letters as $letter=>$replacement) { $string = str_replace($letter, $replacement, $string); } return $string; } function win2utf(){ $tabela = Array( "\xb9" => "\xc4\x85", "\xa5" => "\xc4\x84", "\xe6" => "\xc4\x87", "\xc6" => "\xc4\x86", "\xea" => "\xc4\x99", "\xca" => "\xc4\x98", "\xb3" => "\xc5\x82", "\xa3" => "\xc5\x81", "\xf3" => "\xc3\xb3", "\xd3" => "\xc3\x93", "\x9c" => "\xc5\x9b", "\x8c" => "\xc5\x9a", "\x9f" => "\xc5\xba", "\xaf" => "\xc5\xbb", "\xbf" => "\xc5\xbc", "\xac" => "\xc5\xb9", "\xf1" => "\xc5\x84", "\xd1" => "\xc5\x83", "\x8f" => "\xc5\xb9"); return $tabela; } function iso2utf(){ $tabela = Array( "\xb1" => "\xc4\x85", "\xa1" => "\xc4\x84", "\xe6" => "\xc4\x87", "\xc6" => "\xc4\x86", "\xea" => "\xc4\x99", "\xca" => "\xc4\x98", "\xb3" => "\xc5\x82", "\xa3" => "\xc5\x81", "\xf3" => "\xc3\xb3", "\xd3" => "\xc3\x93", "\xb6" => "\xc5\x9b", "\xa6" => "\xc5\x9a", "\xbc" => "\xc5\xbc", "\xac" => "\xc5\xbb", "\xbf" => "\xc5\xba", "\xaf" => "\xc5\xb9", "\xf1" => "\xc5\x84", "\xd1" => "\xc5\x83"); return $tabela; } function ISO88592_2_UTF8($tekst){ return strtr($tekst, self::iso2utf()); } function UTF8_2_ISO88592($tekst){ return strtr($tekst, array_flip(self::iso2utf())); } function WIN1250_2_UTF8($tekst){ return strtr($tekst, self::win2utf()); } function UTF8_2_WIN1250($tekst){ return strtr($tekst, array_flip(self::win2utf())); } function ISO88592_2_WIN1250($tekst){ return strtr($tekst, "\xa1\xa6\xac\xb1\xb6\xbc", "\xa5\x8c\x8f\xb9\x9c\x9f"); } function WIN1250_2_ISO88592($tekst){ return strtr($tekst, "\xa5\x8c\x8f\xb9\x9c\x9f", "\xa1\xa6\xac\xb1\xb6\xbc"); } /** * Pobiera dane dla dropdown * * @param string $table tabla * @param string $column nazwa kolumny */ public static function GetArrayList($table, $idName, $column, $lang = null, $where = '', $orderBy = '') { $array = array(); $db = Registry::Get('db'); $sql = " CHECK TABLE $table FAST QUICK"; //Utils::ArrayDisplay($sql); $stmt = $db->execute($sql); $row = $stmt->FetchArray(); //Utils::ArrayDisplay($row); if (strtolower($row['Msg_type']) != 'error') { $sql = 'SELECT '.$idName.', '.$column.' FROM '.$table.' WHERE 1=1 '. ( $lang ? "AND lang = '$lang' " : " ") . $where; $order = ( $orderBy ? " ORDER BY $orderBy " : " ORDER BY id_$table "); $sql .= $order; //Utils::ArrayDisplay($sql); $stmt = $db->execute($sql); while(($row = $stmt->FetchArray())) { $array[$row[$idName]] = $row[$column]; } //Utils::ArrayDisplay($array); return $array; } } /** * wyciena polskie znaki i spacje * mienia nazwę na lower * * @param string $string * @return string */ public static function ClearString($string) { $letters = array(" "=>"_", "ą"=>"a", "ę"=>"e", "ś"=>"s", "ć"=>"c", "ł"=>"l", "ń"=>"n", "ż"=>"z", "ź"=>"z", "ó"=>"o", "Ą"=>"A", "Ę"=>"E", "Ś"=>"S", "Ć"=>"C", "Ł"=>"L", "Ń"=>"N", "Ż"=>"Z", "Ź"=>"Z", "Ó"=>"O"); foreach($letters as $letter=>$replacement) { $string = str_replace($letter, $replacement, $string); } $string = strtolower($string); return $string; } //TODO: dorobić sprawdzenie daty public static function CheckPublication($id, $table, $column) { $db = Registry::Get('db'); $sql = "SELECT $column FROM $table WHERE $column = $id AND publication = 1"; $stmt = $db->prepare($sql) ->execute($sql); if ($stmt->NumRows() > 0) { return true; } else { return false; } } /** * */ public static function UpdateField($table, $field, $whereName, $whereValue, $value) { $db = Registry::Get('db'); $sql = 'UPDATE '.$table.' SET '.$field."='".$value."' WHERE ".$whereName." = '".$whereValue."'"; //Utils::ArrayDisplay($sql); $db->execute($sql); } public static function TextToUpper($string) { $search = 'a.ą.b.c.ć.d.e.ę.f.g.h.i.j.k.l.ł.m.n.o.ó.p.q.r.s.ś.t.u.v.w.x.y.z.ż.ź'; $searchUpper = 'A.Ą.B.C.Ć.D.E.Ę.F.G.H.I.J.K.L.Ł.M.N.O.Ó.P.Q.R.S.Ś.T.U.V.W.X.Y.Z.Ż.Ź'; $array = explode('.',$search); $arrayUpper = explode('.',$searchUpper); foreach ($array as $key => $value ) { $data[$value] = $arrayUpper[$key]; } $string = strtr($string, $data); foreach($data as $data=>$replacement) { $string = str_replace($data, $replacement, $string); } return $string; } public static function ClearStringToTitle($string) { $letters = array( "ą"=>"a", "ę"=>"e", "ś"=>"s", "ć"=>"c", "ł"=>"l", "ń"=>"n", "ż"=>"z", "ź"=>"z", "ó"=>"o", "Ą"=>"A", "Ę"=>"E", "Ś"=>"S", "Ć"=>"C", "Ł"=>"L", "Ń"=>"N", "Ż"=>"Z", "Ź"=>"Z", "Ó"=>"O"); foreach($letters as $letter=>$replacement) { $string = str_replace($letter, $replacement, $string); } return $string; } public static function FraceUpper($string) { $letters = array( "é"=>"É", ); foreach($letters as $letter=>$replacement) { $string = str_replace($letter, $replacement, $string); } return $string; } public static function TextToUpperArray($string, $lang) { $arrayLangToCode = array('pl' => 'iso8859-2','en' => 'iso8859-1', 'de' => 'iso8859-1', 'ua' => 'Windows-1251', 'fr' => 'iso8859-1'); if ($lang != 'pl') { $string = Utils::ClearStringToTitle($string); } //Utils::ArrayDisplay($string); $line = iconv("UTF-8", $arrayLangToCode[$lang], $string); // convert to if ($lang != 'pl') { $line = strtoupper($line); } $line1 = substr($line,0,1); $line2 = substr($line,1); $line1 = iconv($arrayLangToCode[$lang], "UTF-8", $line1); // convert back to utf-8 $line2 = iconv($arrayLangToCode[$lang], "UTF-8", $line2); // convert back to utf-8 if ($lang == 'pl') { $line1 = Utils::TextToUpper($line1); $line2 = Utils::TextToUpper($line2); } $line1 = Utils::FraceUpper($line1); $line2 = Utils::FraceUpper($line2); $line = array($line1, $line2); return $line; } public static function Truncate($string, $max = 20, $rep = '') { if (strlen($string) <= ($max + strlen($rep))) { return $string; } $leave = $max - strlen ($rep); return substr_replace($string, $rep, $leave); } public static function Filter() { if (Request::IsPost()) { $post = Request::GetAllPost(); $filter = $post['filter']; SessionProxy::GetAndSetValue('filter', $post['filter']); } else { if (SessionProxy::IsSetValue('filter')) { $filter = SessionProxy::GetValue('filter'); } else { $filter = 3; } } return $filter; } public static function PerPage(&$smarty = null) { if (Request::IsPost()) { $post = Request::GetAllPost(); $perPage = $post['perPage']; SessionProxy::GetAndSetValue('perPage', $post['perPage']); } else { if (SessionProxy::IsSetValue('perPage')) { $perPage = SessionProxy::GetValue('perPage'); } else { $perPage = 10; } } if ($smarty != null) $smarty->assign('perPage', $perPage); return $perPage; } public static function Sort(&$param, &$smarty = null) { if (isset($param[ROUTER_SORT_LABEL]) && isset($param[ROUTER_DIR_LABEL])) { $sortBy = $param[ROUTER_SORT_LABEL]; $sortDir = $param[ROUTER_DIR_LABEL]; $sortByArray = explode('-', $sortBy); $sortDirArray = explode('-', $sortDir); if ($smarty != null) { $smarty->assign('_sortBy', $sortByArray); $smarty->assign('_sortDir', $sortDirArray); } if (count($sortByArray) >= 1 && count($sortDirArray) == count($sortByArray)) { $sortBy = $sortByArray; $sortDir = $sortDirArray; } else { throw new CoreException('Sortowanie: błędna ilość parametrów'); } } else { $sortBy = array(); $sortDir = array(); $param[ROUTER_SORT_LABEL] = ""; $param[ROUTER_DIR_LABEL] = ""; } return array($sortBy, $sortDir); } public static function Page(&$param, &$smarty = null) { if (isset($param[ROUTER_PAGE_LABEL])) { $pageNum = $param[ROUTER_PAGE_LABEL]; $page = explode('-', $pageNum); array_filter($page, create_function('$x', 'if ((int)$x <= 0) { throw new UserException("Strona poza zakresem"); }')); if ($smarty != null) $smarty->assign('_page', $page); } else { $page = array(); $param[ROUTER_PAGE_LABEL] = ""; } return $page; } public function CheckDescLang($id, $table, $lang) { $db = Registry::Get('db'); $strId = str_replace('_description', '', $table); $sql = "SELECT id_$table FROM $table WHERE id_$strId = $id AND lang NOT IN ('$lang')"; $stmt = $db->prepare($sql) ->execute($sql); //Utils::ArrayDisplay('dd'); //Utils::ArrayDisplay($sql); if ($stmt->NumRows() > 0) { return true; } else { return false; } } /** * Z nazwy pola tabeli generuje nazwÄ™ zmiennej php * * @param string */ public static function SQLName2PHPName($name) { $wordsArray = explode('_', $name); //od 1 bo pierwszy element zostaje z maĹ‚Ä… literÄ… for ($i = 1; $i < count($wordsArray); $i++) { $wordsArray[$i] = ucfirst($wordsArray[$i]); } return implode('', $wordsArray); } } ?>