Ejemplo n.º 1
0
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);
}
Ejemplo n.º 2
0
 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";
Ejemplo n.º 3
0
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;
}