<?php
require("top.php");

$msg = "";
$video_title = '';
$video_link = '';
$course_title_id = '';
$video_day = '';

// ✅ अपडेट रिक्वेस्ट चेक करें
if (isset($_GET['id']) && $_GET['id'] != '') {
    $id = mysqli_real_escape_string($con, $_GET['id']);
    $res = mysqli_query($con, "SELECT * FROM course_video WHERE id = '$id'");
    if (mysqli_num_rows($res) > 0) {
        $row = mysqli_fetch_assoc($res);
        $video_title = $row['video_title'];
        $video_link = $row['video_link'];
        $course_title_id = $row['course_title_id'];
        $video_day = $row['video_day'];
    } else {
        header("location: course_video.php");
        exit();
    }
}

// ✅ वीडियो जोड़ने या अपडेट करने का प्रोसेस
if (isset($_POST['submit'])) {
    $course_title_id = mysqli_real_escape_string($con, $_POST['course_title_id']);
    $video_title = mysqli_real_escape_string($con, $_POST['video_title']);
    $video_link = mysqli_real_escape_string($con, $_POST['video_link']);
    $video_day = mysqli_real_escape_string($con, $_POST['video_day']);

    // 🎯 वीडियो लिंक को वेरिफाई करें
    if (!filter_var($video_link, FILTER_VALIDATE_URL)) {
        $msg = "❌ Invalid video link!";
    }

    if ($msg == '') {
        $res = mysqli_query($con, "SELECT * FROM course_video WHERE video_title = '$video_title' AND course_title_id = '$course_title_id'");
        if (mysqli_num_rows($res) > 0) {
            if (isset($_GET['id']) && $_GET['id'] != '') {
                $getData = mysqli_fetch_assoc($res);
                if ($id != $getData['id']) {
                    $msg = "❌ Title already exists in this course!";
                }
            } else {
                $msg = "❌ Title already exists in this course!";
            }
        }

        // ✅ अगर कोई एरर नहीं तो डेटा सेव करें
        if ($msg == '') {
            if (isset($_GET['id']) && $_GET['id'] != '') {
                mysqli_query($con, "UPDATE course_video SET video_title='$video_title', video_link='$video_link', video_day='$video_day' WHERE id='$id'");
            } else {
                // ✅ New Video Insert
                $insert_video = mysqli_query($con, "INSERT INTO course_video(course_title_id, video_title, video_link, video_day, status) 
                    VALUES('$course_title_id', '$video_title', '$video_link', '$video_day', 1)");

                if (!$insert_video) {
                    die("Error inserting video: " . mysqli_error($con));
                }

                // ✅ Get the last inserted video ID
                $video_id = mysqli_insert_id($con);
                if ($video_id == 0) {
                    die("❌ Video ID Not Generated!");
                }

                // ✅ Insert into video_day table
                $insert_day = mysqli_query($con, "INSERT INTO video_day(video_id, day) VALUES('$video_id', '$video_day')");
                if (!$insert_day) {
                    die("Error inserting into video_day: " . mysqli_error($con));
                }

                // ✅ Give access to active users
                $users_res = mysqli_query($con, "SELECT id FROM users WHERE status = 1");
                while ($user = mysqli_fetch_assoc($users_res)) {
                    $insert_access = mysqli_query($con, "INSERT INTO user_video_access (user_id, video_id) VALUES ('" . $user['id'] . "', '$video_id')");
                    if (!$insert_access) {
                        die("Error giving access: " . mysqli_error($con));
                    }
                }
            }
            header("Location: course_video.php");
            exit();
        }
    }
}
?>

<div class="col-sm-9 mx-auto my-4">
    <div class="col-sm-12">
        <div class="card">
            <div class="card-body">
                <h4 class="text-center">Course Video Management</h4>
            </div>
            <?php if ($msg != '') { ?>
                <div class="alert alert-danger"><?php echo $msg; ?></div>
            <?php } ?>
            <form method="post">
                <div class="form-group">
                    <label>Select Course</label>
                    <select name="course_title_id" class="form-control" required>
                        <option value="">Select Course</option>
                        <?php
                        $course_res = mysqli_query($con, "SELECT id, title FROM course_title WHERE status = 1 ORDER BY title ASC");
                        while ($course = mysqli_fetch_assoc($course_res)) {
                            $selected = ($course['id'] == $course_title_id) ? 'selected' : '';
                            echo "<option value='".$course['id']."' $selected>".$course['title']."</option>";
                        }
                        ?>
                    </select>
                </div>

                <div class="form-group">
                    <label>Video Title</label>
                    <input type="text" name="video_title" class="form-control" value="<?php echo htmlspecialchars($video_title); ?>" required>
                </div>

                <div class="form-group">
                    <label>Video Link</label>
                    <input type="text" name="video_link" class="form-control" value="<?php echo htmlspecialchars($video_link); ?>" required>
                </div>
                
                <div class="form-group">
                    <label>Video Day</label>
                    <input type="number" name="video_day" class="form-control" value="<?php echo htmlspecialchars($video_day); ?>" required>
                </div>

                <button type="submit" name="submit" class="btn btn-primary btn-block">Submit</button>
            </form>
        </div>
    </div>
</div>
