Untitled

<?php
session_start();
?>
<!DOCTYPE html>
<html>
<head>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>

    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>

    <link rel="stylesheet" type="text/css" href="mainCSS.css">

    <script>
    	// Used to show / hide content (solution) depending on whether or not the problem is solved
        function check(offset) { // Offset values are used to determine which (if multiple) of the tickets are being checked
            acheck="solvedCheck".concat(offset);
            field="solutionField".concat(offset);
            label="solutionLabel".concat(offset);
            if(document.getElementById(acheck).checked == true) { // If the checkbox is checked, show the field
                document.getElementById(field).style.display = "block";
                document.getElementById(label).style.display = "block";
            }else{ // Else hide the field
                document.getElementById(field).style.display = "none";
                document.getElementById(label).style.display = "none";
            }
        }
        // Used to show optional content (nearest problem) if the current problem is not known / stored in the database
        function unknownProblem(ticket){ // Ticket parameter same use as offset above
            known="problemTypes";
            type="actualProblemType".concat(ticket);

            knownTypes = document.getElementById(known).childNodes; // Get elements stored in datalist of known problem types
            problemType = document.getElementById(type).value; // Get the problem type selected by the helpdesk operator
            flag = false;
            for (i = 0;i < knownTypes.length; i++){ // If the selected problem type is known (stored in the database)
                if(problemType.toLowerCase() == knownTypes[i].text.toLowerCase()){
                    flag = true; // set a flag to be true
                }
            }
            label="closestProblemLabel".concat(ticket); // Create unique label depending on ticket number (offset)
            Type="closestProblemType".concat(ticket);
            if (!flag){ // If the flag is false (i.e the selected problem is not one that is in the database)
                document.getElementById(label).style.display = "block"; // Show optional input fields
                document.getElementById(Type).style.display = "block"; // Which are used to select nearest known problem type
            }
            else{ // Else keep them hidden (as the selected problem type is known to us)
                document.getElementById(label).style.display = "none";
                document.getElementById(Type).style.display = "none";
            }

        }
        // Finish the creation of the new ticket
        function finishTicket(ticket){ // Again...ticket is an offset to uniquely identify current ticket being worked on
                ticketDiv ="ticket".concat(ticket); // Create unique div for each ticket
                ticketDiv =document.getElementById(ticketDiv);
                children = ticketDiv.children;
                for (var i = 0; i < children.length; i++) { // Remove all contents of the div
                        children[i].style.display = 'none';
                }
                ticketDiv.style.height = "60px";

 				// The following create unique fields etc... for each ticket by using their ticket ID as an offset
                hardwareField = "hardware".concat(ticket);  // e.g... hardware1 (ticket1), hardware2 (ticket2) etc...
                hardwareField = document.getElementById(hardwareField).value;

                OSField = "OS".concat(ticket);
                OSField = document.getElementById(OSField).value;

                softwareField = "softwarefield".concat(ticket);
                softwareField = document.getElementById(softwareField).value;

                hardwareField = "hardware".concat(ticket);
                hardwareField = document.getElementById(hardwareField).value;

                problemField ="closestProblemType".concat(ticket);
                if(document.getElementById(problemField).style.display == "none"){
                    problemField="actualProblemType".concat(ticket);
                }
                problemField = document.getElementById(problemField).value;

                finishedField = "solvedCheck".concat(ticket);
                finishedField = document.getElementById(finishedField).checked;

                solutionField = "solutionField".concat(ticket);
                solutionField = document.getElementById(solutionField).value;

                detailsField = "details".concat(ticket);
                detailsField = document.getElementById(detailsField).value;

                specialistField = "specialistSelection".concat(ticket);
                if (document.getElementById(specialistField)){
                specialistField = document.getElementById(specialistField).value;
                }
                else{
                    specialistField = "none";
                };

                varstring = "hardware=";
                varstring.concat(hardwareField);
                varstring.concat("&os=");
                varstring.concat(OSField);
                varstring.concat("&software=");
                varstring.concat(softwareField);
                varstring.concat("&problemType=");
                varstring.concat(problemField);
                varstring.concat("&finished=");
                varstring.concat(finishedField);
                varstring.concat("&solution=");
                varstring.concat(solutionField);
                varstring.concat("&details=");
                varstring.concat(detailsField);
                varstring.concat("&specialist=");
                varstring.concat(specialistField);

 				// Post results to final ticket to be inserted into the database
                $.post("finalTicket.php",{
                    hardware : hardwareField,
                    os : OSField,
                    software : softwareField,
                    problemType : problemField,
                    finished : finishedField,
                    solution : solutionField,
                    details : detailsField,
                    specialist : specialistField
                },function(result){if(result=="success"){
                header("location: Main.php");}
              else{alert(result);}});
        }
        // Select most relevant specialist based on their specialization followed by their current workload
        function selectSpecialist(number){
                checkbox= "solvedCheck".concat(number);
                if (document.getElementById(checkbox).checked == true){ // If the solved checkbox is checked
                    solutionField = "solutionField".concat(number); // Show the solution field
                    solutionField = document.getElementById(solutionField).value;
                    if(solutionField != ""){
						finishTicket(number);
                    } else{}
                }else{
                var array = [];
                ticketDiv ="ticket".concat(number);
                problemType ="closestProblemType".concat(number);
                if(document.getElementById(problemType).style.display == "none"){
                    problemType="actualProblemType".concat(number);
                }
                array =document.getElementById(problemType).value;
                ticketDiv =document.getElementById(ticketDiv);
                children = ticketDiv.children;
                for (var i = 0; i < children.length; i++) {
                        children[i].style.display = 'none';
                }
                ticketDiv.style.height = "60px";
                ticketString="#ticket".concat(number)
                specialistLabel = document.createElement("label");
                specialistLabel.innerHTML ="Specalist assigned : ";
                specialistSelection = document.createElement("select");
                specialistSelection.id = "specialistSelection".concat(number);
                newButton = document.createElement("input");
                newButton.setAttribute("type", "button");
                newButton.addEventListener("click", finishTicket(number));
                newButton.id = "newButton";
                newButton.value = "Confirm";
                $.post("specialistSelection.php", { problemType: array}, function(result){
                    result = JSON.parse(result);
                    for(i=0;i<result['listSpecialists'].length;i++){
                        specalistEntry = document.createElement("option");
                        specalistEntry.value = result['listSpecialists'][i];
                        specalistEntry.innerHTML = result['listSpecialists'][i];
                        if(specalistEntry.value == result['assignedSpecialist']){
                            specalistEntry.selected = true;
                        }
                        specialistSelection.add(specalistEntry);
                    }
                    $( ticketString).append(specialistLabel);
                    $( ticketString).append(specialistSelection);
                    $( ticketString).append(newButton);
                });}

        }
    </script>

    <?php
        session_start();
        if(empty($_SESSION['login_user'])){
            header("location: index.php");
        }


        date_default_timezone_set("Europe/London");
        $emp = $_POST['idEmployee'];
        $numberTickets =$_POST['numberTickets'];

        $callReason = $_POST['callReasonNew'];
        $date = date("l, d/m/Y, G:i");
        $Opid = $_SESSION['login_user'];
        $_SESSION['numberTickets'] = $numberTickets;
        $numberTickets = $_SESSION['numberTickets'];

        include 'SQLConnect.inc';

        $conn = new mysqli($host, $username, $password, $dbName);

        if ($conn->connect_error) {
          die("Connection failed: " . $conn->connect_error);
        }
        if($stmt = $conn->prepare("SELECT `Call-ID` FROM incomingCall ORDER BY `Call-ID` DESC LIMIT 1")){
          $stmt->execute();
          $query= $stmt->get_result();
          $stmt->close();
        }
        $result = $query->fetch_assoc();
        $CallID = $result['Call-ID'] +1;
            $_SESSION['CallID'] = $CallID;

        if($stmt = $conn->prepare("INSERT INTO incomingCall (`Call-ID`, `Emp-ID`, `Op-ID`, `Time`)
                                    VALUES (?,?,?,?)")){
          $stmt->bind_param("ssss", $CallID, $emp, $Opid, $date);
          $stmt->execute();
          $stmt->close();
        }

        if($stmt = $conn->prepare("SELECT `Expertise` FROM expertise")){
          $stmt->execute();
          $query= $stmt->get_result();
          $stmt->close();
        }
        $rows = mysqli_num_rows($query);
        $options = "";
        for($i=0;$i<$rows;$i++){
            $row = $query->fetch_assoc();
            $options.= '<option value="';
            $options.= $row['Expertise'];
            $options.= '">';
            $options.= $row['Expertise'];
            $options.= "</option>";
        }

        echo '<datalist id="problemTypes">';
        if($stmt = $conn->prepare("SELECT `Expertise` FROM expertise")){
          $stmt->execute();
          $query= $stmt->get_result();
          $stmt->close();
        }
        $rows = mysqli_num_rows($query);
        for($i=0;$i<$rows;$i++){
            $row = $query->fetch_assoc();
            echo '<option value="';
            echo $row['Expertise'];
            echo '">';
            echo $row['Expertise'];
            echo "</option>";
        }
        echo '</datalist>';
        mysqli_close($conn);
    ?>
</head>

<body id="body">
    <div id="main">
    <div id="sidebar">
    <img src="logo.png" id="logo"/>
    <ul class="nav nav-pills nav-stacked">
    <li id="homeMenu" ><a href="Main.php">Home</a></li>
    <li class="active" id="editTicketMenu" ><a href="viewcalllog.php">View Call Log</a></li>
    <li id="viewEmpMenu" ><a href="viewemployees.php">View Employees</a></li>
    <li id="viewEquipMenu" ><a href="viewequipment.php">View Equipment</a></li>
    </ul>
    </div>
    <div id="content" style="overflow: auto;height: 80%;">
        <form action="logout.php">
        <input id="submit" name="submit" type="submit" value="Logout">
        </form>

    <ul class="nav nav-tabs">
    <li class="active" id="homeMenu" onclick="loadMain()"><a href="#">Call Log</a></li>
    </ul>

  <?php

    for($i=1;$i<=$numberTickets;$i++){
    echo '<div class="newTicket
    " id="ticket';
    echo $i;
    echo '"><h1>Ticket ';
    echo $i;
    echo ': </h1>';
    echo '
   <form id="newTicketForm';
    echo $i;
    echo '" action="post">
    <div class="formDiv">
    <label for="hardware" class="newTicketLabels">Hardware affected: </label>
    <input type="text" id="hardware';
    echo $i;
    echo '" name="hardware" style="float:right;"/><br>
    </div>

    <div class="formDiv">
    <label for="OS" class="newTicketLabels">OS used: </label>
    <input type="text" id="OS';
    echo $i;
    echo '" name="OS" style="float:right;"/><br>
    </div>

    <div class="formDiv">
    <label for="software" class="newTicketLabels">Software used: </label>
    <input type="text" id="softwarefield';
    echo $i;
    echo '" name="softwarefield" style="float:right;"/><br>
    </div>

    <div class="formDiv">
    <label for="actualProblemType" class="newTicketLabels">Type of problem:* </label>
    <input type="text" id="actualProblemType';
    echo $i;
    echo '" name="actualProblemType" list="problemTypes" onblur="unknownProblem(';
    echo $i;
    echo ')"
    style="float:right;"/>
    </div>

    <div class="formDiv">
    <label for="closestProblemType" class="newTicketLabels" style="display: none;" id="closestProblemLabel';
    echo $i;
    echo '">Choose the option closest to the problem:* </label>
    <select id="closestProblemType';
    echo $i;
    echo '" name="closestProblemType" style="display: none; float:right;">';
    echo $options;
    echo '</select><br>
    </div>

    <div class="formDiv">
    <label for="solved" class="newTicketLabels">Problem solved?</label>
    <input type="checkbox" id="solvedCheck';
    echo $i;
    echo '" name="solved" onclick="check(';
    echo $i;
    echo ')" style="float:right;"/><br>
    </div>

    <div class="formDiv">
    <label for="details" class="newTicketLabels">Problem details:* </label>
    <textarea id="details';
    echo $i;
    echo '" class="newTicketTAs" name="details" form="newTicketForm" style="float:right;"></textarea><br>
    </div>

    <div class="formDiv">
    <label for="solution" class="newTicketLabels" id="solutionLabel';
    echo $i;
    echo '" style="display: none;">Solution:* </label>
    <textarea id="solutionField';
    echo $i;
    echo '" class="newTicketTAs" name="solution" form="newTicketForm"
        style="display: none;float:right;"></textarea><br>
    </div>

    <input type="button" id="createTicket';
    echo $i;
    echo '" value="Create Ticket" onclick="selectSpecialist(';
    echo $i;
    echo ')"/><br>

  </form>
  </div>';}

  ?>
</div>
</div>
</body>
</html>