<?php

   //session_start();
    $nbrOfStates=$_GET['stateNumber'];
    $workflowId=$_GET['workflowId'];

    $statementResponsible = $LINK->prepare("SELECT DISTINCT role FROM TicketUser");
    $statementResponsible->execute();
    $responsible = $statementResponsible->get_result();
    $roles=[];

    while ($row = $responsible->fetch_assoc()) {
        $roles[] = $row['role'];
    }

    $statementResponsible->close();

    ?>
    <form method="POST">
    <?php
    for($i=1; $i<=$nbrOfStates; $i++)
    {
    ?>
        <label>Name: <input type="text" name="workflow_name[<?= $i ?>]"></label>
        <br>
        <label>Nr. of Type fileds: <input type="number" name="fields[<?= $i ?>]" min="1" required> </label>
        <br>
        <label>Responsible: 
          <select name="stateResponsible[<?= $i ?>]" required>
            <option value="">- select Responsible -</option>
            <?php foreach ($roles as $role): ?>
              <option value="<?= htmlspecialchars($role) ?>">
                <?= htmlspecialchars($role) ?>
              </option>
            <?php endforeach ?>
          </select>
        </label>
        <br>
        <br>

    <?php

    }
    ?>
        <br>
        <br>
        <button type="submit" name="upload">Define States</button>
    </form>

    <?php
    if(isset($_POST['upload']))
    {

        $_SESSION['pending']['workflowId']    = $workflowId;
        $_SESSION['pending']['nbrOfStates']   = $nbrOfStates;
        $_SESSION['pending']['stateFields']   = $_POST['fields'];           // array: fields[1],…
        $_SESSION['pending']['stateTitles']   = $_POST['workflow_name'];    // array
        $_SESSION['pending']['stateRespons']  = $_POST['stateResponsible']; // array

        $tiles=$_POST['workflow_name'];
        $respos=$_POST['stateResponsible'];

        for($i=1;$i<=$nbrOfStates;$i++)
        {
            $field=$fields[$i];
            $title=$tiles[$i];
            $respo=$respos[$i];


            $statementS= $LINK->prepare("INSERT INTO TicketStates (fi_workflow, no, title, responsable) VALUES (?, ?, ?, ?)");
            $statementS->bind_param('isss', $workflowId, $i, $title, $respo);
            $statementS->execute();
            $_SESSION['pending']['stateIds'][$i] = $LINK->insert_id;
            $statementS->close();
            
        }
        header("Location: index.php?page=defineFields");
    }