BIM-Monitor/script/php/video_tools.php

<?php
include("connectSQL_Component.php");
/*$sql = "SELECT * FROM [BIMComponents].[dbo].[Favorite_Table] Where [user_name] = '". $user_name ."';";
    $fetchResult = sqlsrv_query($conn, $sql);
    while($row = sqlsrv_fetch_array($fetchResult,SQLSRV_FETCH_ASSOC)){
        array_push($revitVersion,$row['revitVersion']);
        array_push($id,$row['id']);
        array_push($path,$row['favorite']);
       
                
    }
    */
$GLOBALS["conn"] = $conn;
$root = '../../assets';
$folder = 'videos';
FindPath($root, $folder);
sqlsrv_close($conn);




function FindPath($root, $folder)
{
    $sql = "SELECT * FROM [BIMComponents].[dbo].[Video_Node] Where [dir_name] = '" . $folder . "';";
    $fetchResult = sqlsrv_query($GLOBALS["conn"], $sql);
    $row = sqlsrv_fetch_array($fetchResult, SQLSRV_FETCH_ASSOC);

    $rootPath = $root . '/' . $folder;
    $paths = array_diff(scandir($root . '/' . $folder), array('.', '..', 'Thumbs.db'));
    echo ("<ul>");
    foreach ($paths as $path) {

        if (str_contains($path, '.')) {
            if (!str_contains(strtolower($path), '.jpg')) {
                echo ("<li data-jstree='{ " . '"type" : "file"' . " }' >");
                $title = explode(".", $path)[0];
                $file_path = substr($rootPath, 4) . "/" . $path;
                $path = "title:" . $title . "path:" . $file_path . "  dir_id:" . $row["id"];
                echo ($path);
                echo ("</li>");
                $sql = "BEGIN
                IF NOT EXISTS (SELECT * FROM [BIMComponents].[dbo].[Video_Table] WHERE [file_path] = '" . $file_path . "')
                BEGIN
                    INSERT INTO [BIMComponents].[dbo].[Video_Table] ([title],[file_path],[file_name],[dir_id]) VALUES ('" . $title . "','" . $file_path . "','" . $title . "','" . $row["id"] . "')
                END
             END";
                $fetchResult = sqlsrv_query($GLOBALS["conn"], $sql);
            }
        } else {
            echo ("<li>");
            echo ("dir_name: " . $path . "parent:  " . $folder);
            $sql = "BEGIN
                IF NOT EXISTS (SELECT * FROM [BIMComponents].[dbo].[Video_Node] WHERE [dir_name] = 'videos')
                BEGIN
                    INSERT INTO [BIMComponents].[dbo].[Video_Node] ([dir_name],[parent]) VALUES ('videos','.')
                END
             END";
            $fetchResult = sqlsrv_query($GLOBALS["conn"], $sql);
            $sql = "BEGIN
                IF NOT EXISTS (SELECT * FROM [BIMComponents].[dbo].[Video_Node] WHERE [dir_name] = '" . $path . "')
                BEGIN
                    INSERT INTO [BIMComponents].[dbo].[Video_Node] ([dir_name],[parent]) VALUES ('" . $path . "','" . $folder . "')
                END
             END";
            $fetchResult = sqlsrv_query($GLOBALS["conn"], $sql);
            FindPath($rootPath, $path);
            echo ("</li>");
        }
    }
    echo ("</ul>");
}