Ejemplo n.º 1
0
 function execute()
 {
     $action = $_GET["action"];
     switch ($action) {
         case "get":
             $id = (int) $_GET["id"];
             $r = mysql_fetch_assoc(mysql_query("SELECT name, " . build_field_list(array("description", "info", "document", "video_link"), $this->language) . ", checked FROM states WHERE id = {$id}"));
             $name = $r["name"];
             $description = $r["description"];
             $info = $r["info"];
             $document = $r["document"];
             $video_link = $r["video_link"];
             $checked = $r["checked"];
             echo "<table>";
             echo "<tr class='state_name'><td>Name: </td><td><input name='name' class='first_input' value='{$name}'/><input class='decision_start' type='checkbox' {$checked}/>Start</td></tr>";
             echo "<tr class='state_description'><td>Description: </td><td><input name='description' value='{$description}'/></td></tr>";
             echo "<tr class='state_info' ><td>Information item: </td><td><input name='info' value='{$info}'/></td></tr>";
             echo "<tr class='state_document'><td>Document: </td><td><input name='document' value='{$document}'/></td></tr>";
             echo "<tr class='state_video_link'><td>Video link: </td><td><input name='video_link' value='{$video_link}'/></td></tr>";
             echo "</table>";
             echo "<button class='save_state'>Save</button>";
             break;
         case "add":
             $x = (int) $_POST["x"];
             $y = (int) $_POST["y"];
             $w = (int) $_POST["w"];
             $h = (int) $_POST["h"];
             $serviceid = $_SESSION["serviceid"];
             mysql_query("INSERT INTO states(x, y, w, h, type, serviceid) VALUES ({$x}, {$y}, {$w}, {$h}, 's', {$serviceid})");
             echo mysql_insert_id();
             break;
         case "move":
             $id = (int) $_POST["id"];
             $x = (int) $_POST["x"];
             $y = (int) $_POST["y"];
             $w = (int) $_POST["w"];
             $h = (int) $_POST["h"];
             mysql_query("UPDATE states SET x={$x}, y={$y}, w={$w}, h={$h} WHERE id = {$id}");
             break;
         case "upd":
             $id = (int) $_POST["id"];
             $name = mysql_escape_string($_POST["name"]);
             $checked = mysql_escape_string($_POST["checked"]);
             mysql_query("UPDATE states SET name='{$name}', " . build_upd_field_list(array("description", "info", "document", "video_link"), $this->language) . ", checked='{$checked}' WHERE id = {$id}");
             break;
         case "del":
             $id = (int) $_POST["id"];
             mysql_query("DELETE FROM states WHERE id = {$id}");
             echo mysql_error();
             break;
         case "list":
             $this->lists();
             break;
     }
 }
Ejemplo n.º 2
0
 function getCurrentState()
 {
     echo "{";
     $id = $_SESSION["current_state"];
     if (!$id) {
         echo '"state":[]}';
         return;
     }
     print_jason_records(false, "SELECT id, name, description_{$this->language} AS description, type, decision_type, input_type, question_{$this->language} AS question FROM states WHERE id = {$id}", "state");
     print_jason_records(true, "SELECT connections.expr FROM connections INNER JOIN states ON states.id=connections.id2 WHERE id1 = {$id}", "answers");
     $r = mysql_fetch_assoc(mysql_query("SELECT " . build_field_list(array("description", "info", "document", "video_link"), $this->language) . " FROM states WHERE id = {$id}"));
     echo ", \"video_links\":" . json_encode(explode("|", $r["video_link"]));
     echo ", \"documents\":" . json_encode(explode("|", $r["document"]));
     echo ", \"info\":" . json_encode(explode("|", $r["info"]));
     echo "}";
 }
Ejemplo n.º 3
0
 function execute()
 {
     $action = $_GET["action"];
     switch ($action) {
         case "get":
             $id = (int) $_GET["id"];
             $serviceid = $_SESSION["serviceid"];
             $r = mysql_fetch_assoc(mysql_query("SELECT name, " . build_field_list(array("description", "question", "info", "document", "video_link"), $this->language) . ", checked FROM states WHERE id = {$id}"));
             $name = $r["name"];
             $description = $r["description"];
             $question = $r["question"];
             $checked = $r["checked"];
             $info = $r["info"];
             $document = $r["document"];
             $video_link = $r["video_link"];
             echo "<table>";
             echo "<tr class='decision_name'><td>Name: </td><td><input name='name'  class='first_input' value='{$name}'/><input class='decision_start' type='checkbox' {$checked}/>Start</td></tr>";
             echo "<tr class='decision_description'><td>Description: </td><td><input name='description' value='{$description}'/></td></tr>";
             echo "<tr class='decision_type'><td>Decide by: </td><td><select class='decision_type'><option value='Variable'>Variable</option><option value='Input'>User input</option></select></td></tr>";
             echo "<tr class='decision_question'><td>Question: </td><td><input name='decision_question' value='{$question}'/></td></tr>";
             echo "<tr class='decision_variable'><td>Variable: </td><td><select></select></td></tr>";
             echo "<tr class='decision_input_type'><td>Input type: </td><td><select class='decision_input_type'><option value='DropDown'>DropDown</option><option value='Radio'>Radio</option><option value='Text'>Text</option></select></td></tr>";
             echo "<tr class='decision_store'><td>Store answer in: </td><td><select class='decision_store_in'><option>Dont store</option><option>New variable</option></select></td></tr>";
             echo "<tr class='decision_decisions'><td>Decisions: </td><td><table class='newspaper-table'><tr><th>Condition</th><th>Outcome</th></tr>";
             $qr = mysql_query("SELECT connections.expr, states.id, states.name AS name FROM connections LEFT OUTER JOIN states ON states.id=connections.id2 WHERE id1={$id}");
             $qrblocks = mysql_query("SELECT states.id, states.name AS name FROM states WHERE serviceid = {$serviceid}");
             $blocks = array();
             while ($block = mysql_fetch_array($qrblocks)) {
                 $blocks[] = array('name' => $block["name"], 'id' => $block["id"]);
             }
             while ($dec = mysql_fetch_array($qr)) {
                 $condition = $dec["expr"];
                 $outcome = $dec["id"];
                 echo "<tr class='decision_condition'><td><input type='text' name='condition[]' class='condition' value='{$condition}'/></td><td><select name='outcome[]' class='outcome'>";
                 foreach ($blocks as $block) {
                     echo '<option value="' . $block['id'] . '"' . ($outcome == $block['id'] ? ' selected' : '') . '>' . $block['name'] . '</output>';
                 }
                 echo '</td></tr>';
             }
             echo "</table></td></tr>";
             echo "<tr class='state_info' ><td>Information item: </td><td><input name='info' value='{$info}'/></td></tr>";
             echo "<tr class='state_document'><td>Document: </td><td><input name='document' value='{$document}'/></td></tr>";
             echo "<tr class='state_video_link'><td>Video link: </td><td><input name='video_link' value='{$video_link}'/></td></tr>";
             echo "</table>";
             echo "<button class='save_decision'>Save</button>";
             break;
         case "add":
             $x = (int) $_POST["x"];
             $y = (int) $_POST["y"];
             $w = (int) $_POST["w"];
             $h = (int) $_POST["h"];
             $serviceid = $_SESSION["serviceid"];
             mysql_query("INSERT INTO states(x, y, w, h, type, serviceid) VALUES ({$x}, {$y}, {$w}, {$h}, 'd', {$serviceid})");
             echo mysql_insert_id();
             break;
         case "move":
             $id = (int) $_POST["id"];
             $x = (int) $_POST["x"];
             $y = (int) $_POST["y"];
             $w = (int) $_POST["w"];
             $h = (int) $_POST["h"];
             mysql_query("UPDATE states SET x={$x}, y={$y}, w={$w}, h={$h} WHERE id = {$id}");
             break;
         case "upd":
             $id = (int) $_POST["id"];
             $checked = mysql_escape_string($_POST["checked"]);
             $name = mysql_escape_string($_POST["name"]);
             $decision_type = mysql_escape_string($_POST["decision_type"]);
             $input_type = mysql_escape_string($_POST["input_type"]);
             mysql_query("UPDATE states SET name = '{$name}', " . build_upd_field_list(array("description", "question", "info", "document", "video_link"), $this->language) . ", checked='{$checked}', decision_type='{$decision_type}', input_type='{$input_type}' WHERE id = {$id}");
             mysql_query("DELETE FROM connections WHERE id1={$id}");
             $serviceid = $_SESSION["serviceid"];
             foreach ($_POST["conditions"] as $condition) {
                 $expression = $condition["condition"];
                 $outcome_id = $condition["outcome"];
                 mysql_query("INSERT INTO connections(expr, id1, id2, serviceid) VALUES ('{$expression}', {$id}, {$outcome_id}, {$serviceid})");
             }
             break;
         case "del":
             $id = (int) $_POST["id"];
             mysql_query("DELETE FROM states WHERE id = {$id}");
             echo mysql_error();
             break;
         case "list":
             $this->lists();
             break;
     }
 }