Esempio n. 1
0
            } else {
                $strankovani .= '<a href="?m=objednavky&i_min=' . $i . '">' . ceil($i / 10) . '</a> &nbsp;&nbsp; | &nbsp;&nbsp;';
            }
        }
        $i++;
    }
    $strankovani = str_replace("| &nbsp;&nbsp; &end;", "", $strankovani . " &end;");
    $strankovani = str_replace("&end;", "", $strankovani);
    $strankovani .= '</center>';
    echo $strankovani;
}
/************************/
/* Zobrazení objednávek */
/************************/
/* -- Stránky -- */
$dotaz = Mysql_query("SELECT COUNT(uzivatelJmeno) FROM {$CONF['sqlPrefix']}objednavky WHERE uzivatelJmeno!='' ") or die(Mysql_error());
$radek = @mysql_fetch_array($dotaz);
$pocetObjednavek = $radek["COUNT(uzivatelJmeno)"];
$strankovani = '<center>';
$i = 1;
while ($i < $pocetObjednavek) {
    if ($i == 161) {
        $strankovani .= '<span style="cursor: pointer;" onClick="ukazSkryj(\'divOdkazyDalsi\');">Starší »</span> <div id="divOdkazyDalsi" style="display: none;">';
    }
    if ($i % 10 == 1) {
        if ($_GET["i_min"] == $i) {
            $strankovani .= '<a href="?m=objednavky&i_min=' . $i . '" style="text-decoration: none; font-weight: bold;">' . ceil($i / 10) . '</a> &nbsp;&nbsp; | &nbsp;&nbsp;';
        } else {
            $strankovani .= '<a href="?m=objednavky&i_min=' . $i . '">' . ceil($i / 10) . '</a> &nbsp;&nbsp; | &nbsp;&nbsp;';
        }
    }
Esempio n. 2
0
function send()
{
    // fonction appelée quand on clique 'OK' sur le formulaire
    global $sommaireformkeysommaire, $sommaireformgroupmenu, $sommaireformname, $sommaireformimage, $sommaireformlien, $sommaireformingroup, $sommaireformmoduleimage, $sommaireformmodulelink, $sommaireformmodulelinktext, $sommaireformcenter, $sommaireformhr, $sommaireformbgcolor, $sommaireformradio, $sommaireformclass, $sommaireformbold, $sommaireformnew, $sommaireformlistbox, $sommaireformeachcategoryclass, $sommaireformmodulegras, $sommaireformmodulenew, $sommaireformnew_type, $sommaireformnew_days, $sommaireformmodulenew_days, $sommaireformfirstnew_days, $sommaireformmoduleclass, $sommaireformclassformodules, $sommaireformfirstclass, $sommaireformdynamic, $db, $prefix, $sql;
    //	global $sommaireformmoduleimage0_0, $sommaireformmoduleimage0_1, $sommaireformmoduleimage0_2, $sommaireformmoduleimage1_0, $sommaireformmoduleimage1_1, $sommaireformmoduleimage1_2;
    $sommaireformnew_days = $sommaireformnew_type == "on" ? $sommaireformnew_days : "-1";
    //si les valeurs de 'groupmenu' (Poids) entrées dans le formulaire ne sont pas des nombres de 0 à 98, --> die
    for ($i = 0; $i <= $sommaireformkeysommaire; $i++) {
        if (!ereg("([0-9]{1,2})", $sommaireformgroupmenu[$i]) or $sommaireformgroupmenu[$i] == 99) {
            include "header.php";
            GraphicAdmin();
            OpenTable();
            echo "<div align=\"center\">";
            echo "" . _SOMINVALIDWEIGHT . "&nbsp;'{$sommaireformname[$i]}'&nbsp;({$sommaireformgroupmenu[$i]})";
            echo "<br>" . _SOMMUSTBENUM . "";
            echo "</div>";
            CloseTable();
            include "footer.php";
            return;
        }
        // si 2 catégories ont le même groupmenu (poids) --> die
        for ($j = 0; $j <= $sommaireformkeysommaire; $j++) {
            if ($i != $j) {
                if ($sommaireformgroupmenu[$i] == $sommaireformgroupmenu[$j]) {
                    include "header.php";
                    GraphicAdmin();
                    OpenTable();
                    echo "<div align=\"center\">";
                    echo "" . _SOMCATS . "&nbsp;'{$sommaireformname[$i]}'&nbsp;" . _SOMAND . "&nbsp;'{$sommaireformname[$j]}'&nbsp;" . _SOMSAMEWEIGHT . "&nbsp;({$sommaireformgroupmenu[$i]})";
                    echo "<br>" . _SOMMODIFWEIGHT . "";
                    echo "<br>NB :&nbsp;" . _SOMMUSTBENUM . "";
                    echo "</div>";
                    CloseTable();
                    include "footer.php";
                    return;
                }
            }
        }
    }
    // sinon, on insère les données dans les tables nuke_sommaire et nuke_sommaire_categories.
    // d'abord, on va effacer les données de ces 2 tables !
    $db->sql_query("DELETE FROM " . $prefix . "_sommaire");
    $db->sql_query("DELETE FROM " . $prefix . "_sommaire_categories");
    //détection de nuke v.7 : y a-t-il une gestion des groupes?
    global $user_prefix;
    $sql = "SELECT * FROM " . $prefix . "_modules LIMIT 1";
    $result = $db->sql_query($sql);
    $row = $db->sql_fetchrow($result);
    echo Mysql_error();
    if (isset($row['mod_group'])) {
        $sql2 = "SELECT * FROM " . $user_prefix . "_users LIMIT 1";
        $result2 = $db->sql_query($sql2);
        $row2 = $db->sql_fetchrow($result2);
        echo Mysql_error();
        $gestiongroupe = isset($row2['points']) ? 1 : 0;
    } else {
        $gestiongroupe = 0;
    }
    // à chaque ligne du formulaire, on fait une requête pour insérer les données.
    for ($i = 0; $i <= $sommaireformkeysommaire; $i++) {
        for ($j = 0; $j < count($sommaireformingroup[$i]); $j++) {
            $zeclass = $sommaireformfirstclass != $sommaireformclassformodules ? $sommaireformclassformodules : $sommaireformmoduleclass[$i][$j];
            $zeclass = $zeclass == "" ? $sommaireformclassformodules : $zeclass;
            //si la classe est vide, alors on remplit avec la classe par défaut.
            $zenew_days = $sommaireformfirstnew_days != $sommaireformnew_days ? $sommaireformnew_days : $sommaireformmodulenew_days[$i][$j];
            //si on n'a pas changé le nb jours dans l'admin, on recopie les valeurs précédentes.
            $zenew_days = $zenew_days == "" ? $sommaireformnew_days : $zenew_days;
            //si le nb de jour est vide, alors on remplit avec le nb de jours par défaut.
            if ($sommaireformingroup[$i][$j] == "Lien externe") {
                //si il y a un lien, on insère les données du lien
                $sql = "INSERT INTO " . $prefix . "_sommaire_categories (groupmenu, module, url, url_text, image, new, new_days, class, bold) VALUES ('{$sommaireformgroupmenu[$i]}', '" . $sommaireformingroup[$i][$j] . "', '" . $sommaireformmodulelink[$i][$j] . "', '" . $sommaireformmodulelinktext[$i][$j] . "', '" . $sommaireformmoduleimage[$i][$j] . "', '" . $sommaireformmodulenew[$i][$j] . "', '" . $zenew_days . "', '" . $zeclass . "', '" . $sommaireformmodulegras[$i][$j] . "')";
                $db->sql_query($sql);
                echo MySql_error();
            } elseif ($sommaireformingroup[$i][$j] == "SOMMAIRE_HR") {
                $sql = "INSERT INTO " . $prefix . "_sommaire_categories (groupmenu, module, url, url_text, image, new, new_days, class, bold) VALUES ('{$sommaireformgroupmenu[$i]}', '" . $sommaireformingroup[$i][$j] . "', '', '' , '', '" . $sommaireformmodulenew[$i][$j] . "', '" . $zenew_days . "',  '" . $zeclass . "', '" . $sommaireformmodulegras[$i][$j] . "')";
                $db->sql_query($sql);
                echo MySql_error();
            } else {
                if ($sommaireformingroup[$i][$j] != "Aucun") {
                    //sinon, (si il y a un module) on insère le nom du module, et pas de lien.
                    $sql = "INSERT INTO " . $prefix . "_sommaire_categories (groupmenu, module, url, url_text, image, new, new_days, class, bold) VALUES ('{$sommaireformgroupmenu[$i]}', '" . $sommaireformingroup[$i][$j] . "', '', '' , '" . $sommaireformmoduleimage[$i][$j] . "', '" . $sommaireformmodulenew[$i][$j] . "', '" . $zenew_days . "',  '" . $zeclass . "', '" . $sommaireformmodulegras[$i][$j] . "')";
                    $db->sql_query($sql);
                    echo MySql_error();
                }
            }
            // --> si 'Aucun' est sélectionné dans les modules, on n'insère aucune donnée !
        }
        // si la catégorie ne contient aucune donnée (complètement vide), alors on ne l'insère pas dans la DB.
        if ($sommaireformname[$i] == '' && $sommaireformimage[$i] == "noimg" && $sommaireformlien[$i] == '' && $sommaireformhr[$i] == '' && $sommaireformcenter[$i] == '' && $sommaireformbgcolor[$i] == '') {
        } else {
            $zeclass = $sommaireformeachcategoryclass[0] != $sommaireformclass ? $sommaireformclass : $sommaireformeachcategoryclass[$i];
            // si la class a été changée via l'admin, on indique cette classe pour toutes les catégories, sinon on recopie le nom de la classe utilisée auparavant.
            $zeclass = $zeclass == "" ? $sommaireformclass : $zeclass;
            //si la classe est vide, alors on remplit avec la classe par défaut.
            if ($gestiongroupe == 1 && $sommaireformradio == 2) {
                $invisible = 4;
            } elseif ($gestiongroupe == 1 && $sommaireformradio == 3) {
                $invisible = 5;
            } else {
                $invisible = $sommaireformradio;
            }
            $sql = "INSERT INTO " . $prefix . "_sommaire VALUES ('{$sommaireformgroupmenu[$i]}', '{$sommaireformname[$i]}', '{$sommaireformimage[$i]}', '{$sommaireformlien[$i]}', '{$sommaireformhr[$i]}', '{$sommaireformcenter[$i]}', '{$sommaireformbgcolor[$i]}', '{$invisible}', '{$zeclass}', '{$sommaireformbold[$i]}', '{$sommaireformnew[$i]}', '{$sommaireformlistbox[$i]}', '{$sommaireformdynamic}')";
            $db->sql_query($sql);
            echo MySql_error();
        }
        //end for 2
    }
    // end for 1 : toutes les catégories et leur contenu sont rentrées dans la DB
    // ensuite, on insère la catégorie 99.
    $sql = "INSERT INTO " . $prefix . "_sommaire VALUES ('{$sommaireformgroupmenu['99']}', NULL, NULL, NULL, NULL,NULL,NULL,NULL,NULL, NULL, NULL, NULL, NULL)";
    $db->sql_query($sql);
    //	echo "<br>$sommaireformgroupmenu[99]&nbsp;";
    include "header.php";
    GraphicAdmin();
    OpenTable();
    echo MySql_error();
    echo "<div align=\"center\">" . _SOMSUCCESS . "</div>";
    echo "<br><br><br><div align=\"center\">[<a href=\"admin.php?op=sommaire\">" . _SOMBACKADMIN . "</a>]</div>";
    CloseTable();
    include "footer.php";
}
Esempio n. 3
0
	unset($_SESSION["list_drug_reason"][$count-1]);
	unset($_SESSION["list_drug_reason2"][$count-1]);
	exit();
}

//************************** Ай╢╖црб║рцбрЦкИЮевм║  ********************************************************
if(isset($_GET["action"]) && $_GET["action"] == "drug"){
	
	if($_GET["search"] == "viat"){
		$where = "drugcode = '5FLES' OR ";
	}
	
	$sql = "Select prefix From `runno` where `title`  = 'passdrug' limit 1 ";
	list($pass_drug) = mysql_fetch_row(mysql_query($sql));
	$sql = "Select drugcode, tradname, genname,unit, stock, salepri, part, `lock`, lock_dr From druglst where ".$where." (drugcode like '%".$_GET["search"]."%' OR genname LIKE '%".$_GET["search"]."%' OR  tradname LIKE '%".$_GET["search"]."%') Order by drugcode ASC";
	$result = Mysql_Query($sql)or die(Mysql_error());

	if(Mysql_num_rows($result) > 0){
		echo "<Div style=\"position: absolute;text-align: center; width:760px; height:320px; overflow:auto; \">";

		
		echo "<table bgcolor=\"#FFFFCC\" width=\"740\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr align=\"center\" bgcolor=\"#3333CC\"><td width=\"20\"><font style=\"color: #FFFFFF\"></font></td><td width=\"73\"><font style=\"color: #FFFFFF\"></font></td><td width=\"368\"><font style=\"color: #FFFFFF\"><strong>╙вХмбр</strong></font></td><td width=\"110\"><font style=\"color: #FFFFFF\"><strong>к╧Хгб</strong></font></td><td width=\"50\"><font style=\"color: #FFFFFF\"><strong>цр╓р</strong></font></td><td width=\"15\" bgcolor=\"#3333CC\"><font style=\"color: #FF0000;\"><strong><A HREF=\"#\" onclick=\"document.getElementById('list').innerHTML='';\">X</A></strong></font></td></tr>";


		$i=1;
		while($arr = Mysql_fetch_assoc($result)){
				
				if($arr["lock_dr"] != "Y"){
					
					if($arr["lock_dr"] =="N"){
						$obj = "бр╣я╢мм║";
Esempio n. 4
0
                            break;
                        case "DSN":
                            $update = ",dsn=dsn+" . $salepri * $_POST["amount"];
                            break;
                    }
                }
            }
            $sql = "INSERT INTO ddrugrx(date,hn,drugcode,tradname,amount,price,item,slcode,part,idno, salepri, freepri,office ) VALUES ('" . $_GET["sDate"] . "','" . $hn . "','" . $_POST["drugcode"] . "','" . $tradname . "', '" . $_POST["amount"] . "','" . $_POST["amount"] * $salepri . "','" . $item . "','" . $_POST["slcode"] . "','" . $part . "','" . $_GET["nRow_id"] . "','" . $salepri . "','" . $freepri . "','" . $_SESSION["sOfficer"] . "');";
            $result1 = Mysql_Query($sql) or die("à¡Ô´¤ÇÒÁ¼Ô´¾ÅÒ´ã¹Ãкº ¡ÃÙ³Ò ¾ÔÁ¾ì˹éҨ͹ÕéäÇéãËéâ»Ãá¡ÃÁàÁÍÃì´Ù¤ÃѺ<BR> " . Mysql_error());
            $sql = "update ddrugrx set item = item+1 where idno='" . $_GET["nRow_id"] . "' AND date = '" . $_GET["sDate"] . "'  ;";
            if ($result1 == true) {
                $result2 = Mysql_Query($sql) or die("à¡Ô´¤ÇÒÁ¼Ô´¾ÅÒ´ã¹Ãкº ¡ÃÙ³Ò ¾ÔÁ¾ì˹éҨ͹ÕéäÇéãËéâ»Ãá¡ÃÁàÁÍÃì´Ù¤ÃѺ<BR> " . Mysql_error());
            }
            $sql = "update dphardep set item = item+1,price=price+" . $salepri * $_POST["amount"] . " " . $update . "  where row_id='" . $_GET["nRow_id"] . "' AND date = '" . $_GET["sDate"] . "' limit 1; ";
            if ($result2 == true) {
                $result3 = Mysql_Query($sql) or die("à¡Ô´¤ÇÒÁ¼Ô´¾ÅÒ´ã¹Ãкº ¡ÃÙ³Ò ¾ÔÁ¾ì˹éҨ͹ÕéäÇéãËéâ»Ãá¡ÃÁàÁÍÃì´Ù¤ÃѺ<BR> " . Mysql_error());
            }
            if ($result1 == true && $result2 == true && $result3 == true) {
                echo "ºÑ¹·Ö¡¢éÍÁÙÅàÃÕºÃéÍÂáÅéÇ<BR><A HREF=\"drxadddrug.php?sDate=" . urlencode($_GET["sDate"]) . "&nRow_id=" . urlencode($_GET["nRow_id"]) . "\">à¾ÔèÁÂÒ</A><BR>ËÒ¡äÁèà¾ÔèÁÂÒáÅéÇãËé»Ô´Ë¹éÒ¹ÕéàŤÃѺ\n\t\t\t<SCRIPT LANGUAGE=\"JavaScript\">\n\t\t\t\t\n\t\t\t\topener.location.reload();\n\t\t\t\tsetTimeout(\"window.location.href='drxadddrug.php?sDate=" . urlencode($_GET["sDate"]) . "&nRow_id=" . urlencode($_GET["nRow_id"]) . "';\",5000);\n\n\t\t\t</SCRIPT>\n\t\t\t";
            }
            exit;
        }
    }
}
?>

<FORM METHOD=POST ACTION="">
<TABLE>
<TR>
	<TD>ÃËÑÊÂÒ</TD>
	<TD><INPUT TYPE="text" NAME="drugcode"></TD>
Esempio n. 5
0
		$sql = "Select   a.`row_id`, a.`vn`, a.`hn`, a.`an`, a.`dx`, a.`organ`, a.`maintenance`, a.`doctor`, CONCAT(b.`yot`,' ',b.`name`,' ',b.`surname`) as `full_name`, `age`, `list_ptright`, left(`time_in`,5) as `left2in`, left(`time_out`, 5) as `left2`, `cure`, `admit_ward`, `refer_hospital`, CONCAT(a.`time_in`,' ',date_format(a.`date`,'%H:%i:%s')) as `h_date`, `time_in`, left(`time_diag`,5) as `time_diag2`, date_format(`date_in`,'%d/%m/%Y') as `date_in2`, `type_wounded`, `repeat`, `type_patient`, `cause_refer`, `doc_refer`,  `nurse`,  `assistant_nurse`,  `estimate`,  `cradle`, `doc_txt`,  `no_estimate`, b.`phone`, a.`consult`, `er_tell`, `suggestion`  
		From (
						SELECT * 
						FROM `trauma` 
						WHERE ".$where."
					) AS `a`, 
		`opcard` as `b` 
		where a.`hn` = b.`hn`  
		Order by `date_in` ASC, `h_date` ASC ";
		//echo $sql;
		$echoka = "";
		$echoka1 = "";
		$i=0;

		$result = Mysql_Query($sql) or die("<!-- ".Mysql_error()." -->");
		$rows = Mysql_num_rows($result);
		?>
¨Ó¹Ç¹¢éÍÁÙÅ·Ñé§ËÁ´  <?php echo $rows;?>
<TABLE cellpadding="2" cellspacing="0" border="1" bordercolor="#000000" style='BORDER-COLLAPSE: collapse'>
<?php if($_POST["coder"] == "1"){?>

<TR>
	<TD align="center">ÅӴѺ</TD>
	<TD align="center">Ç.´.».</TD>
	<TD align="center">HN</TD>
	<TD>ÂȪ×èÍ-Ê¡ØÅ</TD>
	<TD align="center">ÍÒÂØ</TD>
	<TD align="center">Êѧ¡Ñ´</TD>
	<TD align="center">Dx.</TD>
</TR>
Esempio n. 6
0
$TmplModul->prirad("hlavicka.popis", "Umožňuje spravovat základní nastavení vašich stránek.");
//Editace nastavení
if ($_POST["akce"] == 'zakladni-nastaveni') {
    Mysql_query("UPDATE {$CONF['sqlPrefix']}nastaveni \n                 SET emailAdmin='{$_POST['emailAdmin']}', title='{$_POST['title']}', objednavky_autosender='{$_POST['objednavky_autosender']}' \n                 WHERE id=1") or die(Mysql_error());
}
if ($_POST["old_pass"] and $_POST["new_pass"]) {
    if ($_POST["old_pass"] == $_SESSION["heslo"]) {
        if ($_POST["new_pass"] == $_POST["new_pass_2"]) {
            $uzivatel = mysql_fetch_assoc(mysql_query("SELECT * FROM {$CONF['sqlPrefix']}uzivatele WHERE heslo=MD5('{$_POST['old_pass']}')"));
            if ($uzivatel["id"]) {
                Mysql_query("UPDATE {$CONF['sqlPrefix']}uzivatele SET heslo=MD5('{$_POST['new_pass']}') WHERE heslo=MD5('{$_POST['old_pass']}')");
                $_SESSION["heslo"] = $_POST["new_pass"];
                $TmplNastaveni->prirad("hlaska_heslo.text", "Heslo úspěšně změněno");
            } else {
                $TmplNastaveni->prirad("hlaska_heslo.text", "Špatně zadané staré heslo");
            }
        } else {
            $TmplNastaveni->prirad("hlaska_heslo.text", "Hesla nesouhlasí");
        }
    } else {
        $TmplNastaveni->prirad("hlaska_heslo.text", "Špatně zadané staré heslo");
    }
    Mysql_query("UPDATE {$CONF['sqlPrefix']}nastaveni \n                 SET emailAdmin='{$_POST['emailAdmin']}', title='{$_POST['title']}', objednavky_autosender='{$_POST['objednavky_autosender']}' \n                 WHERE id=1") or die(Mysql_error());
}
//Zobrazení aktuálních informací
$radek = mysql_fetch_assoc(Mysql_query("SELECT * FROM {$CONF['sqlPrefix']}nastaveni"));
foreach ($radek as $key => $value) {
    $TmplNastaveni->prirad($key, $value);
}
$TmplModul->prirad("obsah", $TmplNastaveni->getHtml());
echo $TmplModul->getHtml();
Esempio n. 7
0
			echo "<CENTER><B>ºÑ¹·Ö¡¢éÍÁÙÅàÃÕºÃéÍÂáÅéÇ</B><BR><A HREF=\"#\" Onclick=\"window.location.href='trauma.php';\">&lt;&lt; ¡ÅѺ</A></CENTER>";

		}else{

			echo "<CENTER><B>äÁèÊÒÁÒöºÑ¹·Ö¡¢éÍÁÙÅä´é¡ÃسҵԡµèÍâ»Ãá¡ÃÁàÁÍÃì</B><BR><A HREF=\"#\" Onclick=\"window.location.href='trauma.php';\">&lt;&lt; ¡ÅѺ</A></CENTER>";

		}
		
		//echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"2;URL=trauma.php\">";
		exit();
	}else if(isset($_GET["action"]) && $_GET["action"] == "del"){



		$sql ="Delete From trauma Where row_id = '".$_GET["id"]."' limit 1" ;
		$result = Mysql_Query($sql) or Mysql_error();
		
		$sql = "Delete From trauma_lst_labcare where for_id = '".$_GET["id"]."' ";
		$result2 = Mysql_Query($sql);
		$sql = "Delete From trauma_labcare where for_id = '".$_GET["id"]."' ";
		$result2 = Mysql_Query($sql);

		$sql = "Delete From trauma_cpg where for_id = '".$_GET["id"]."' ";
		$result2 = Mysql_Query($sql);

		if($result){
			
			echo "<CENTER><B>ź¢éÍÁÙÅàÃÕºÃéÍÂáÅéÇ</B><BR><A HREF=\"#\" Onclick=\"window.location.href='trauma.php';\">&lt;&lt; ¡ÅѺ</A></CENTER>";

		}else{
Esempio n. 8
0
    if ($freepri > $salepri) {
        $freepri = $salepri;
    }
    $dg_dsy = $freepri;
    $dg_dsn = $salepri - $freepri;
} else {
    $dg_dsy = 0;
    $dg_dsn = 0;
}
$today = date("Y") + 543 . date("-m-d H:i:s");
$query = "INSERT INTO ddrugrx(date,hn,drugcode,tradname,amount,price,item,slcode,part,idno, salepri, freepri, drug_inject_amount,drug_inject_unit, drug_inject_amount2,drug_inject_unit2,drug_inject_time,drug_inject_slip, drug_inject_type, drug_inject_etc,reason,DPY , DPN ,date_notsk ) VALUES ('0000-00-00 00:00:00','" . $rxHn . "','" . $drugcode . "','" . $tradname . "','" . $nostk . "','" . $nostk * $salepri . "','1','" . $slcode . "','" . $part . "','" . $idno . "','" . $salepri . "','" . $freepri . "','" . $drug_inject_amount . "','" . $drug_inject_unit . "','" . $drug_inject_amount2 . "','" . $drug_inject_unit2 . "','" . $drug_inject_time . "','" . $drug_inject_slip . "','" . $drug_inject_type . "','" . $drug_inject_etc . "','" . $reason . "','" . $dg_dsy * $nostk . "','" . $dg_dsn * $nostk . "','" . $today . "')";
//$commar = ",";
//$sub_drugcode1 = ord(substr($_SESSION["list_drugcode"][$i],0,1));
//$sub_drugcode2 = ord(substr($_SESSION["list_drugcode"][$i],1,1));
if ($insert1 == true) {
    $result2 = Mysql_Query($query) or die(Mysql_error());
}
//echo "<!-- ".$query." -->";
/*if($insert1 ==true && $result2 ==true){
		
		$_SESSION["nRunno"] = "";
		$_SESSION["list_drugcode"] = array() ;
		$_SESSION["list_drugamount"] = array() ;
		$_SESSION["list_drugslip"] = array() ;

		$_SESSION["list_drug_inject_amount"] = array() ;
		$_SESSION["list_drug_inject_unit"] = array() ;
		$_SESSION["list_drug_inject_amount2"] = array() ;
		$_SESSION["list_drug_inject_unit2"] = array() ;
		$_SESSION["list_drug_inject_time"] = array() ;
		$_SESSION["list_drug_inject_slip"] = array() ;
Esempio n. 9
0
    				$result2 = Mysql_Query($sql2);
    				while($arr2 = Mysql_fetch_assoc($result2)){
    					$list[$i] = $arr2["code"];
    					$i++;
    				}
    
    				echo "<A HREF=\"#\" Onclick=\"addsuittolist('".implode("][",$list)."');\">".$arr["detail"]."</A><BR>";
    			}		
    			}*/
    echo "\t</TD>\n</TR>\n</TABLE>\n";
    exit;
}
//*****************************áÊ´§µÑǪèÇ Other********************//
if (isset($_GET["action"]) && $_GET["action"] == "other") {
    $sql34 = "Select distinct(other) from appoint where other like '%" . $_GET["search1"] . "%' limit 10 ";
    $result34 = Mysql_Query($sql34) or die(Mysql_error());
    if (Mysql_num_rows($result34) > 0) {
        echo "<Div style=\"position: absolute;text-align: center; width:400px; height:430px; overflow:auto; \">";
        echo "<table width=\"400\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#FF99CC\"><tr align=\"center\" bgcolor=\"#333333\">\n\t\t<td width=\"10\"><strong>&nbsp;</strong></td>\n\t\t<td width=\"200\"><font style=\"color: #FFFFFF;\"><strong>ÃÒ¡ÒÃ</strong></font></td>\n\t\t<td width=\"10\"><strong>&nbsp;&nbsp;<A HREF=\"#\" onclick=\"document.getElementById('list1').innerHTML='';\"><font style=\"color: #FFFF99;\">»Ô´</font></A></strong></td>\n\t\t</tr>";
        //$i=1;
        while ($se = Mysql_fetch_assoc($result34)) {
            echo "<tr>\n\t\t<td valign=\"top\" width=\"10\"></td>\n\t\t<td width=\"200\"><A HREF=\"javascript:void(0);\" Onclick=\"document.getElementById('other').value = '" . $se['other'] . "';document.getElementById('list1').innerHTML ='';\">" . $se['other'] . "</A></td>\n\t\t<td width=\"10\">&nbsp;</td></tr>";
        }
        echo "</TABLE></Div>";
    }
    exit;
}
//************************** áÊ´§ÃÒ¡Òà lab  ********************************************************
if (isset($_GET["action"]) && $_GET["action"] == "addtolist") {
    $sql = "Select detail, yprice, nprice From labcare where code = '" . $_GET["code"] . "' limit 1; ";
    list($detail, $yprice, $nprice) = Mysql_fetch_row(Mysql_Query($sql));
Esempio n. 10
0
        $commar = ", ";
    }
    $_SESSION["dt_drugstk"] .= "</TD>\n\t</TR>";
}
$_SESSION["dt_drugstk"] .= "</TABLE>";
$sql = "Select detail_all From xray_doctor where date like '" . (date("Y") + 543) . date("-m-d") . "%' AND hn = '" . $_SESSION["hn_now"] . "' AND doctor = '" . $_SESSION["dt_doctor"] . "' Order by date DESC limit 1";
$result = Mysql_Query($sql);
if (Mysql_num_rows($result) > 0) {
    $_SESSION["dt_drugstk"] .= "\n\t<TR>\n\t\t<TD colspan=\"3\"><font style=\"font-family:'MS Sans Serif'; font-size:10px\"> <B>X-Ray</B> :";
    $arr = mysql_fetch_assoc($result);
    $_SESSION["dt_drugstk"] .= "<BR>" . nl2br($arr["detail_all"]);
    $_SESSION["dt_drugstk"] .= "</TD>\n\t</TR>";
}
$_SESSION["dt_drugstk"] .= "</TABLE>";
if ($insert1 == true && $count > 0) {
    $result2 = Mysql_Query($add) or die(Mysql_error());
}
//echo "<!-- ".$add." -->";
if ($insert1 == true && $result2 == true) {
    $_SESSION["nRunno"] = "";
    $_SESSION["list_drugcode"] = array();
    $_SESSION["list_drugamount"] = array();
    $_SESSION["list_drugslip"] = array();
    $_SESSION["list_drug_inject_amount"] = array();
    $_SESSION["list_drug_inject_unit"] = array();
    $_SESSION["list_drug_inject_amount2"] = array();
    $_SESSION["list_drug_inject_unit2"] = array();
    $_SESSION["list_drug_inject_time"] = array();
    $_SESSION["list_drug_inject_slip"] = array();
    $_SESSION["list_drug_inject_type"] = array();
    $_SESSION["list_drug_inject_etc"] = array();
Esempio n. 11
0
<?php

$TmplModul = new GlassTemplate("templates/{$CONF['vzhled']}/modul.html");
$TmplNastaveni = new GlassTemplate("templates/{$CONF['vzhled']}/podobne_produkty.html");
//Hlavička
$TmplModul->prirad("hlavicka.ikona", "templates/{$CONF['vzhled']}/images/podobne_produkty.png");
$TmplModul->prirad("hlavicka.nadpis", "Podobné produkty");
$TmplModul->prirad("hlavicka.popis", "Modul, který umožní přidávat k produktům podobné produkty.");
//Editace nastavení
if ($_POST["akce"] == 'podobne-produkty') {
    Mysql_query("UPDATE {$CONF['sqlPrefix']}nastaveni \n                 SET podobne_produkty_active='{$_POST['podobne_produkty_active']}' \n                 WHERE id=1") or die(Mysql_error());
}
//Zobrazení aktuálních informací
$radek = mysql_fetch_assoc(Mysql_query("SELECT * FROM {$CONF['sqlPrefix']}nastaveni"));
foreach ($radek as $key => $value) {
    $TmplNastaveni->prirad($key, $value);
}
$TmplModul->prirad("obsah", $TmplNastaveni->getHtml());
echo $TmplModul->getHtml();
Esempio n. 12
0
    header("Location :/buynsell/index.php?exp=1");
    exit;
}
?>

<?php 
include "db.php";
include "dnb.html";
if (isset($_POST['feedback'])) {
    $connection = mysqli_connect($WEBHOST, $USER, $PASSWORD, $DATABASE);
    if (!$connection) {
        die("Could not connect to the Database " . Mysql_error());
    }
    $result = mysqli_query($connection, "INSERT INTO feedback(ufriendly,bugs,improvements,user_id) VALUE('{$_POST['ufriendly']}','{$_POST['bugs']}','{$_POST['improvements']}','{$_SESSION['user_id']}')");
    if (!$result) {
        die("mysql query over the database error has occured " . Mysql_error());
    }
    echo "<br /><br /><div class='alert alert-success'>Thank you for your valuable feedback! We will surely look into it ASAP. Mother Promise!</span>";
}
?>
<html>
	<body>
        <div class='container col-xs-10 col-xs-offset-1'>
		<br /><br />
		
            <div class='col-xs-10 col-xs-offset-1'>
                <div class='jumbotron'><h4>Hi,</h4><h3><small> We at WebOps are really enthusiastic to listen to your suggestions to make this site better. And we would be really happy if you could take some time off to give us your feedback below</small><br></h3></div>
			<form method = POST action = feedback.php>

				<p>1. Do you find this page user friendly?</p>
				<input type = "radio" name = "ufriendly" value = "yes"> Yes</input>