function get_fpal() { if (func_num_args() > 0) { $arg_list = func_get_args(); $patient_id = $arg_list[0]; $fpal = $arg_list[1]; } $con = mysqli_connect("localhost", $_SESSION["dbuser"], $_SESSION["dbpass"], $_SESSION["dbname"]); $sql = "SELECT length(obscore_fpal) as fpal, obscore_fpal as newFPAL, obscore_gp, outcome_id FROM m_patient_mc WHERE patient_id = '{$patient_id}' ORDER BY consult_id DESC LIMIT 1"; if ($query = mysqli_query($con, $sql)) { if (mysqli_num_rows($query)) { $result = mysqli_fetch_array($query); switch ($result["fpal"]) { case 6: $f = substr($result["newFPAL"], 0, 2); $p = substr($result["newFPAL"], 2, 1); $a = substr($result["newFPAL"], 3, 1); $l = substr($result["newFPAL"], 4, 2); break; case 4: $f = substr($result["newFPAL"], 0, 1); $p = substr($result["newFPAL"], 1, 1); $a = substr($result["newFPAL"], 2, 1); $l = substr($result["newFPAL"], 3, 1); break; default: break; } } } switch ($fpal) { case 'F': return $f; break; case 'P': return $p; break; case 'A': return $a; break; case 'L': return $l; case 'GR': $gr = explodeX(array('-', '/'), $result["obscore_gp"]); return $gr[0]; break; case 'PA': $gr = explodeX(array('-', '/', ',', '|', '&'), $result["obscore_gp"]); return $gr[1]; break; case 'DELIVERY': $sql = "SELECT outcome_name FROM m_lib_mc_outcome WHERE outcome_id = '" . $result["outcome_id"] . "'"; if ($query = mysqli_query($con, $sql)) { if (mysqli_num_rows($query)) { $result = mysqli_fetch_array($query); return $result["outcome_name"]; } } break; default: break; } //return substr($result["newFPAL"],0,1); }
curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $params . $fn); curl_setopt($ch, CURLOPT_COOKIEJAR, "cookie/ciastko"); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2); //uzupełnij nazwę otrzymanego z banku certyfikatu i hasła do niego curl_setopt($ch, CURLOPT_SSLCERT, "./bankusercert.pem"); curl_setopt($ch, CURLOPT_SSLCERTPASSWD, "password"); curl_setopt($ch, CURLOPT_USERAGENT, $user_agent); $wyn = curl_exec($ch); $f = fopen("files/" . $fn, "w"); fputs($f, $wyn); fclose($f); $if = file("files/" . $fn); for ($i = 0; $i < count($if); $i++) { $fields = explodeX($if[$i], ",", ""); if ($fields[0] == "02") { $data = mktime(0, 0, 0, substr($fields[5], 4, 2), substr($fields[5], 6, 2), substr($fields[5], 0, 4)); $kto = $fields[8]; $kwota = number_format($fields[4] / 100, 2, ".", ""); $opis = $fields[6]; $tid = $fields[7]; $id = $fields[3]; $hash = md5($data . $kwota . $kto . $opis . $id . $tid); $kto = addslashes(iconv("ISO-8859-2", "UTF-8", $kto)); $opis = addslashes(iconv("ISO-8859-2", "UTF-8", $opis)); $rs = mysql_query("Select id from cashimport where Hash='" . $hash . "'"); if (mysql_num_rows($rs) == 0) { mysql_query("Insert into cashimport (Date,Value,Customer,Description,CustomerId,Hash) values ('{$data}','{$kwota}','{$kto}','{$opis}','{$id}','{$hash}')"); } else { echo "Pomijam wpis, bo juz taki istnieje.\n";
function get_manala_menu() { // Create HTML DOM $html = file_get_html('http://www.botta.fi/LOUNAS.108.0.html'); // Get lunch menu block $menu = $html->plaintext; $menu = nl2br($menu); $menu = preg_replace('/(<br[^>]*>\\s*){2,}/', '<br/>', $menu); $menu_array_temp = explodeX(array('Maanantaina', 'Tiistaina', 'Keskiviikkona', 'Torstaina', 'Perjantaina'), $menu); foreach ($menu_array_temp as $day_menu) { $day_menu = substr($day_menu, 6); $day_menu = preg_replace('/^(?:<br\\s*\\/?>\\s*)+/', '', $day_menu); $day_menu = explode('Suosittelemme:', $day_menu); $menu_array[] = $day_menu[0]; } $menu_array[0] = 'manala'; // Clean up memory $html->clear(); unset($html); return $menu_array; }