<?php
require_once("../../mkt/conn.php");
function createFlow($mid, $current_assigner, $flow_code, $ekind, $form_key=null){
    global $conn;
    $form_id = $mid;
    $seq = 0;
    $system_id = "prm";
    if($ekind == "新梯") $flow_id = "prm01";
    if($ekind == "汰改") $flow_id = "prm02";
    if($ekind == "修理") $flow_id = "prm03";
    if($ekind == "保養") $flow_id = "prm04";

    if($form_key == null){
        $sql_str = "SELECT appwms.nextval('form_key') form_key";
        $stmt = $conn->prepare($sql_str);
        $stmt->execute();
        $result = $stmt->fetch(PDO::FETCH_ASSOC);
        $form_key =  $result['form_key'];
        $seq = 0;

        $sql_str = "INSERT INTO flow (system_id, flow_id, form_id, form_key, flow_code)
        VALUES (:system_id, :flow_id, :form_id, :form_key, :flow_code)";
        $stmt = $conn->prepare($sql_str);
        $stmt->bindParam(':system_id', $system_id);
        $stmt->bindParam(':flow_id', $flow_id);
        $stmt->bindParam(':form_id', $form_id);
        $stmt->bindParam(':form_key', $form_key);
        $stmt->bindParam(':flow_code', $flow_code);
        $stmt->execute();
    }else{
        $sql_str = "UPDATE flow SET flow_code = :flow_code WHERE form_key = :form_key";
        $stmt = $conn->prepare($sql_str);
        $stmt->bindParam(':form_key', $form_key);
        $stmt->bindParam(':flow_code', $flow_code);
        $stmt->execute();

        $sql_str = "SELECT MAX(seq) AS max_seq FROM subflow WHERE form_key = :form_key";
        $stmt = $conn->prepare($sql_str);
        $stmt->bindParam(':form_key', $form_key);
        $stmt->execute();
        $result = $stmt->fetch(PDO::FETCH_ASSOC);
        $seq = $result['max_seq'];
        $seq ++;
    }
    
    $created_at = date("Y-m-d H:i:s");
    $sql_str = "INSERT INTO subflow (form_key, seq, current_assigner, update_date,create_date)
    VALUES (:form_key, :seq, :current_assigner, :update_date,:create_date)";
    $stmt = $conn->prepare($sql_str);
    $stmt->bindParam(':form_key', $form_key);
    $stmt->bindParam(':seq', $seq);
    $stmt->bindParam(':current_assigner', $current_assigner);
    $stmt->bindParam(':update_date', $created_at);
    $stmt->bindParam(':create_date', $created_at);
    $stmt->execute();
    

    return $form_key;
}