<?php
    $username = $_SESSION['username'];
    $date= date('Y-m-d H:i:s');

    $LINK = mysqli_connect('127.0.0.1','pisjo950','vjPRjFTxDVIoG7)t','pisjo950');
    $statement = $LINK->prepare("SELECT * FROM TicketUser WHERE email=?");
    $statement->bind_param('s', $username);
    $statement->execute();
    $result = $statement->get_result();
    $statement->close();

    $page=$_GET['page'];


    if($page=='createWorkflow')
    {
        if ($result) {
        $row = $result->fetch_assoc();
        //if we are an IT or Chef we can create new Workflows
            if($row['role']='It' || $row['role']='Admin')
            {
                ?>
                    <form method="POST">
                        <p>Workflow name <input type="text" name="workflow_name"></p>
                        <p>Number of states <input type="number" name="stateNumber" max="3" min="1"> </p>
                        <button type="submit" name="upload">Define States</button>
                    </form>
                <?php

                if(isset($_POST['upload']))
                {
                    $workflow_name = $_POST['workflow_name'];
                    $stateNumber = $_POST['stateNumber'];
                    
                    $statementWf= $LINK->prepare("INSERT INTO TicketWorkflows (title, iam_inserted, date_inserted) VALUES (?, ?, ?)");
                    $statementWf->bind_param('sss', $workflow_name, $username,$date);
                    $statementWf->execute();
                    
                    header("Location: index.php?page=defineState"."&stateNumber={$stateNumber}"."&workflowId=".$statementWf->insert_id);
                    $statementWf->close();
                }


                // $statementWfState= $LINK->prepare("INSERT INTO TicketStates (fi_workflow, no, title, responsible) VALUES (?, ?, ?, ?)");
                // $statementWfState->bind_param('isss', $workflow_id, , , date('Y-m-d H:i:s'));
                // $statementWfState->execute();
                // $statementWfState->close();
            }



        }
    }
    //check if result
    
?>