<?php
include ('sqlServerConn.php');

$myArray = $_POST['data'];
$userSk = key($myArray);
$length = count($myArray[$userSk]);
$userNk = $myArray[$userSk]['USER_NK'];
$userAlias = $myArray[$userSk]['USER_ALIAS'];
$userName = $myArray[$userSk]['USER_NAME'];
$userSurname = $myArray[$userSk]['USER_SURNAME'];
$userOrgFk = $myArray[$userSk]['USER_ORG_FK'];
$userTypeFk = $myArray[$userSk]['USER_TYPE_FK'];
$updDate = 'CURRENT_TIMESTAMP';
$crtDate = 'CURRENT_TIMESTAMP';
$userStatus = $myArray[$userSk]['USER_STATUS'];
$failLgnCnt = $myArray[$userSk]['FAILED_LOGIN_COUNTER'];

if($_POST['action'] === 'edit'){

    if($length > 1){

        $sql = "UPDATE GD_LOV_USER SET [USER_NK] = '".$userNk."', [USER_ALIAS] = '".$userAlias."', [USER_NAME] = '".$userName."', [USER_SURNAME] = '".$userSurname."', [USER_ORG_FK] = ".$userOrgFk.", [USER_TYPE_FK] = ".$userTypeFk.", [UPDATE_DATE] = ".$updDate.", [CREATE_DATE] = ".$crtDate.", [USER_STATUS] = '".$userStatus."', [FAILED_LOGIN_COUNTER] = ".$failLgnCnt." WHERE USER_SK = ".$userSk.";";
        var_dump($sql);
        $stmt = $conn->prepare($sql);
        // var_dump($stmt);
        $stmt->execute();
        
        
    }else{
        $rowID = key($myArray);
        $colName = key($myArray[$rowID]);
        
        $sql = "UPDATE GD_LOV_USER SET ".$colName." = '".$myArray[$rowID][$colName]."' WHERE USER_SK = ".$rowID.";";
        
        $stmt = $conn->prepare($sql);
        $stmt->execute();
        

    }
}elseif($_POST['action'] ==='create'){

    $sql = "INSERT INTO GD_LOV_USER ([USER_NK],[USER_ALIAS],[USER_NAME],[USER_SURNAME],[USER_ORG_FK],[USER_TYPE_FK],[UPDATE_DATE],[CREATE_DATE],[USER_STATUS],[FAILED_LOGIN_COUNTER])
            VALUES
            ('$userNk', '$userAlias','$userName','$userSurname',$userOrgFk,$userTypeFk,$updDate,$crtDate,'$userStatus',$failLgnCnt)";

    $stmt = $conn->prepare($sql);
    $stmt->execute();

}elseif($_POST['action'] === 'remove'){


    $sql = "DELETE FROM GD_LOV_USER WHERE USER_SK = '$userSk' AND 1=1 ;";
    var_dump($sql);
    $stmt = $conn->prepare($sql);
    $stmt->execute();

}

$conn = null;
?>