Track Employee Training Video Completion – Xlinesoft Blog

Employees often need to complete onboarding, safety, or compliance videos. In this tutorial, we will build a training video tracker that resumes each video from the saved position, allows rewinding, prevents users from skipping unwatched sections, and records completion.

The same approach works in PHPRunner and ASPRunner.NET. The browser-side code is the same in both products, while the server-side examples are provided separately in PHP and C#.

1. Creating the required tables

This example uses the employees table for application login. Its key field is EmployeeID. The sample project uses FirstName as the username field and LastName as the password field. Create the three tables below.

MySQL


CREATE TABLE employees (
    EmployeeID INT NOT NULL AUTO_INCREMENT,
    LastName VARCHAR(20) NOT NULL,
    FirstName VARCHAR(10) NOT NULL,
    Title VARCHAR(30) NULL,
    TitleOfCourtesy VARCHAR(25) NULL,
    BirthDate DATETIME NULL,
    HireDate DATETIME NULL,
    Address VARCHAR(60) NULL,
    City VARCHAR(11) NULL,
    Region VARCHAR(15) NULL,
    PostalCode VARCHAR(10) NULL,
    Country VARCHAR(15) NULL,
    HomePhone VARCHAR(24) NULL,
    Extension VARCHAR(4) NULL,
    Photo LONGBLOB NULL,
    Notes LONGTEXT NULL,
    ReportsTo DATETIME NULL,
    ownerid INT NULL,
    email VARCHAR(250) NULL,
    PRIMARY KEY (EmployeeID)
);

CREATE TABLE videos (
    video_id INT NOT NULL AUTO_INCREMENT,
    title VARCHAR(255) NOT NULL,
    description LONGTEXT NULL,
    video_file LONGTEXT NULL,
    duration INT NULL,
    PRIMARY KEY (video_id)
);

CREATE TABLE video_watch (
    watch_id INT NOT NULL AUTO_INCREMENT,
    employee_id INT NOT NULL,
    video_id INT NOT NULL,
    last_position DECIMAL(10,2) NOT NULL DEFAULT 0,
    max_watched DECIMAL(10,2) NOT NULL DEFAULT 0,
    completed TINYINT NOT NULL DEFAULT 0,
    last_watched DATETIME NULL,
    completed_at DATETIME NULL,
    PRIMARY KEY (watch_id),
    UNIQUE KEY uq_video_watch (employee_id, video_id)
);

The two position fields serve different purposes. last_position is where playback resumes. max_watched is the furthest point the employee has reached and therefore the furthest position to which the player may seek.

Add both tables to the project. Configure employees as the login table and make sure EmployeeID is available through the current user data.

2. Configuring video upload and playback

Open the videos table and configure video_file as follows:

1. On the Add and Edit pages, set ‘Edit as’ to ‘Document upload’.
2. On the View page, set ‘View as’ to ‘Video file’.
3. Set the video player size. The sample project uses 600 by 400 pixels.
4. Include title, description, and video_file on the View page.
5. Remove duration from the Add and Edit pages. The application will save it automatically when the video is played.

The generated application uses the browser’s HTML5 video player, so no additional video library is required.

3. Processing progress requests on the server

The video page sends three AJAX requests: load the current progress, save the video duration, and save the current playback position.

Open Events – Global events – After App Init and add the version for your product.

PHP


if (
    $_SERVER["REQUEST_METHOD"] === "POST" &&
    in_array(
        $_POST["action"] ?? "",
        array(
            "get_video_progress",
            "save_video_progress",
            "save_video_duration"
        ),
        true
    )
) {
    header("Content-Type: application/json");

    function videoResponse($data, $status = 200) {
        http_response_code($status);
        echo json_encode($data);
        exit;
    }

    if (!Security::isLoggedIn()) {
        videoResponse(array("success" => false), 401);
    }

    $user = Security::currentUserData();
    $employeeId = (int)($user["EmployeeID"] ?? 0);
    $videoId = filter_var(
        $_POST["video_id"] ?? null,
        FILTER_VALIDATE_INT
    );

    if ($employeeId <= 0 || !$videoId || $videoId <= 0) {
        videoResponse(array("success" => false), 400);
    }

    $video = DB::Select(
        "videos",
        array("video_id" => $videoId)
    )->fetchAssoc();

    if (!$video) {
        videoResponse(array("success" => false), 404);
    }

    $keys = array(
        "employee_id" => $employeeId,
        "video_id" => $videoId
    );

    $watch = DB::Select("video_watch", $keys)->fetchAssoc();

    if (!$watch) {
        DB::Insert("video_watch", array(
            "employee_id" => $employeeId,
            "video_id" => $videoId,
            "last_position" => 0,
            "max_watched" => 0,
            "completed" => 0
        ));

        $watch = DB::Select("video_watch", $keys)->fetchAssoc();
    }

    $action = $_POST["action"];

    if ($action === "get_video_progress") {
        if (empty($_SESSION["video_progress_token"])) {
            $_SESSION["video_progress_token"] =
                bin2hex(random_bytes(32));
        }

        videoResponse(array(
            "success" => true,
            "last_position" => (float)$watch["last_position"],
            "max_watched" => (float)$watch["max_watched"],
            "completed" => (int)$watch["completed"],
            "token" => $_SESSION["video_progress_token"]
        ));
    }

    $token = $_POST["token"] ?? "";

    if (
        !is_string($token) ||
        empty($_SESSION["video_progress_token"]) ||
        !hash_equals($_SESSION["video_progress_token"], $token)
    ) {
        videoResponse(array("success" => false), 403);
    }

    if ($action === "save_video_duration") {
        $duration = filter_var(
            $_POST["duration"] ?? null,
            FILTER_VALIDATE_INT
        );

        if (!$duration || $duration < 1 || $duration > 86400) {
            videoResponse(array("success" => false), 400);
        }

        if (empty($video["duration"])) {
            DB::Update(
                "videos",
                array("duration" => $duration),
                array("video_id" => $videoId)
            );
        }

        videoResponse(array("success" => true));
    }

    $position = filter_var(
        $_POST["position"] ?? null,
        FILTER_VALIDATE_FLOAT
    );
    $maxWatched = filter_var(
        $_POST["max_watched"] ?? null,
        FILTER_VALIDATE_FLOAT
    );

    if (
        $position === false || $position === null ||
        $maxWatched === false || $maxWatched === null ||
        $position < 0 || $maxWatched < 0 ||
        $position > $maxWatched + 0.5
    ) {
        videoResponse(array("success" => false), 400);
    }

    $duration = (float)($video["duration"] ?? 0);

    if (
        $duration > 0 &&
        ($position > $duration + 1 || $maxWatched > $duration + 1)
    ) {
        videoResponse(array("success" => false), 400);
    }

    $maxWatched = max(
        (float)$watch["max_watched"],
        $maxWatched
    );

    $values = array(
        "last_position" => $position,
        "max_watched" => $maxWatched,
        "last_watched" => date("Y-m-d H:i:s")
    );

    if (
        $duration > 0 &&
        $maxWatched >= $duration - 1.5 &&
        ($_POST["ended"] ?? "") === "1"
    ) {
        $values["completed"] = 1;

        if (empty($watch["completed"])) {
            $values["completed_at"] = date("Y-m-d H:i:s");
        }
    }

    DB::Update("video_watch", $values, $keys);
    videoResponse(array("success" => true));
}


string action = MVCFunctions.postvalue("action").ToString();

if (
    HttpContext.Current.Request.HttpMethod == "POST" &&
    (
        action == "get_video_progress" ||
        action == "save_video_progress" ||
        action == "save_video_duration"
    )
)
{
    Action<xvar int=""> videoResponse = (payload, status) =>
    {
        HttpContext.Current.Response.StatusCode = status;
        HttpContext.Current.Response.ContentType = "application/json";
        MVCFunctions.Echo(MVCFunctions.runner_json_encode(payload));
        HttpContext.Current.Response.End();
        throw new RunnerInlineOutputException();
    };

    if (!XVar.Pack(Security.isLoggedIn()))
    {
        XVar response = XVar.Array();
        response["success"] = false;
        videoResponse(response, 401);
    }

    XVar user = Security.currentUserData();
    int employeeId = 0;
    int videoId = 0;

    Int32.TryParse(user["EmployeeID"].ToString(), out employeeId);
    Int32.TryParse(
        MVCFunctions.postvalue("video_id").ToString(),
        out videoId
    );

    if (employeeId <= 0 || videoId <= 0)
    {
        XVar response = XVar.Array();
        response["success"] = false;
        videoResponse(response, 400);
    }

    XVar videoKeys = XVar.Array();
    videoKeys["video_id"] = videoId;

    dynamic video = DB.Select("videos", videoKeys).fetchAssoc();

    if (!XVar.Pack(video))
    {
        XVar response = XVar.Array();
        response["success"] = false;
        videoResponse(response, 404);
    }

    XVar keys = XVar.Array();
    keys["employee_id"] = employeeId;
    keys["video_id"] = videoId;

    dynamic watch = DB.Select("video_watch", keys).fetchAssoc();

    if (!XVar.Pack(watch))
    {
        XVar values = XVar.Array();
        values["employee_id"] = employeeId;
        values["video_id"] = videoId;
        values["last_position"] = 0;
        values["max_watched"] = 0;
        values["completed"] = 0;

        DB.Insert("video_watch", values);
        watch = DB.Select("video_watch", keys).fetchAssoc();
    }

    if (action == "get_video_progress")
    {
        string sessionToken =
            XSession.Session["video_progress_token"].ToString();

        if (String.IsNullOrEmpty(sessionToken))
        {
            sessionToken = Guid.NewGuid().ToString("N");
            XSession.Session["video_progress_token"] = sessionToken;
        }

        XVar response = XVar.Array();
        response["success"] = true;
        response["last_position"] =
            Convert.ToDouble(watch["last_position"]);
        response["max_watched"] =
            Convert.ToDouble(watch["max_watched"]);
        response["completed"] =
            Convert.ToInt32(watch["completed"]);
        response["token"] = sessionToken;

        videoResponse(response, 200);
    }

    string savedToken =
        XSession.Session["video_progress_token"].ToString();
    string suppliedToken =
        MVCFunctions.postvalue("token").ToString();

    if (
        String.IsNullOrEmpty(savedToken) ||
        !String.Equals(
            savedToken,
            suppliedToken,
            StringComparison.Ordinal
        )
    )
    {
        XVar response = XVar.Array();
        response["success"] = false;
        videoResponse(response, 403);
    }

    if (action == "save_video_duration")
    {
        int durationValue = 0;
        Int32.TryParse(
            MVCFunctions.postvalue("duration").ToString(),
            out durationValue
        );

        if (durationValue < 1 || durationValue > 86400)
        {
            XVar response = XVar.Array();
            response["success"] = false;
            videoResponse(response, 400);
        }

        if (
            String.IsNullOrEmpty(video["duration"].ToString()) ||
            Convert.ToInt32(video["duration"]) == 0
        )
        {
            XVar values = XVar.Array();
            values["duration"] = durationValue;
            DB.Update("videos", values, videoKeys);
        }

        XVar response = XVar.Array();
        response["success"] = true;
        videoResponse(response, 200);
    }

    double position = 0;
    double maxWatched = 0;

    bool validPosition = Double.TryParse(
        MVCFunctions.postvalue("position").ToString(),
        System.Globalization.NumberStyles.Float,
        System.Globalization.CultureInfo.InvariantCulture,
        out position
    );
    bool validMaximum = Double.TryParse(
        MVCFunctions.postvalue("max_watched").ToString(),
        System.Globalization.NumberStyles.Float,
        System.Globalization.CultureInfo.InvariantCulture,
        out maxWatched
    );

    if (
        !validPosition || !validMaximum ||
        position < 0 || maxWatched < 0 ||
        position > maxWatched + 0.5
    )
    {
        XVar response = XVar.Array();
        response["success"] = false;
        videoResponse(response, 400);
    }

    double duration = 0;
    Double.TryParse(video["duration"].ToString(), out duration);

    if (
        duration > 0 &&
        (position > duration + 1 || maxWatched > duration + 1)
    )
    {
        XVar response = XVar.Array();
        response["success"] = false;
        videoResponse(response, 400);
    }

    maxWatched = Math.Max(
        Convert.ToDouble(watch["max_watched"]),
        maxWatched
    );

    XVar progress = XVar.Array();
    progress["last_position"] = position;
    progress["max_watched"] = maxWatched;
    progress["last_watched"] = DateTime.Now;

    if (
        duration > 0 &&
        maxWatched >= duration - 1.5 &&
        MVCFunctions.postvalue("ended").ToString() == "1"
    )
    {
        progress["completed"] = 1;

        if (Convert.ToInt32(watch["completed"]) == 0)
        {
            progress["completed_at"] = DateTime.Now;
        }
    }

    DB.Update("video_watch", progress, keys);

    XVar successResponse = XVar.Array();
    successResponse["success"] = true;
    videoResponse(successResponse, 200);
}</xvar>

The handler always obtains employee_id from the logged-in user’s record. It never accepts an employee ID from the browser. A session token protects the update requests, and the server records completion only when the player reaches the end of the video.

If your login table uses a different key field, replace EmployeeID in this code.

4. Tracking playback on the View page

Open the videos View page and add the following code to its JavaScript OnLoad event:


const video = document.querySelector("video");

if (video) {
    const params = new URLSearchParams(window.location.search);
    const videoId = params.get("editid1");
    const url = window.location.pathname + window.location.search;

    let durationSaved = false;
    let lastPosition = 0;
    let maxWatched = 0;
    let restoringPosition = false;
    let initialized = false;
    let completed = false;
    let token = "";
    let lastSave = 0;
    let saving = false;
    let pendingSave = false;

    function request(action, data = {}) {
        return $.ajax({
            url: url,
            type: "POST",
            dataType: "json",
            data: {
                action: action,
                video_id: videoId,
                ...data
            }
        });
    }

    function loadProgress() {
        video.pause();

        request("get_video_progress")
            .done(function(result) {
                if (!result.success) return;

                lastPosition = Number(result.last_position) || 0;
                maxWatched = Number(result.max_watched) || 0;
                completed = Number(result.completed) === 1;
                token = result.token || "";

                if (completed && Number.isFinite(video.duration)) {
                    maxWatched = video.duration;
                }

                restoringPosition = true;
                video.currentTime = Math.min(
                    lastPosition,
                    Math.max(0, video.duration - 0.25)
                );

                video.addEventListener(
                    "seeked",
                    function finishRestore() {
                        restoringPosition = false;
                        video.removeEventListener(
                            "seeked",
                            finishRestore
                        );
                    }
                );

                initialized = true;
            });
    }

    function saveVideoDuration() {
        if (durationSaved || !videoId || !token) return;

        const duration = Math.ceil(video.duration);

        if (!Number.isFinite(duration) || duration <= 0) return;

        durationSaved = true;

        request("save_video_duration", {
            duration: duration,
            token: token
        }).fail(function() {
            durationSaved = false;
        });
    }

    function saveProgress(ended = false) {
        if (!initialized || !token) return;

        if (saving) {
            pendingSave = true;
            return;
        }

        saving = true;

        const position = Math.max(
            0,
            Math.min(video.currentTime, maxWatched)
        );

        request("save_video_progress", {
            position: position.toFixed(2),
            max_watched: maxWatched.toFixed(2),
            ended: ended ? "1" : "0",
            token: token
        }).always(function() {
            saving = false;

            if (pendingSave) {
                pendingSave = false;
                saveProgress(video.ended);
            }
        });
    }

    function initialize() {
        if (initialized) return;
        if (!Number.isFinite(video.duration)) return;
        loadProgress();
    }

    video.addEventListener("loadedmetadata", initialize);

    if (video.readyState >= 1) {
        initialize();
    }

    video.addEventListener("play", function() {
        if (!initialized) {
            video.pause();
            return;
        }

        saveVideoDuration();
    });

    video.addEventListener("timeupdate", function() {
        if (!initialized || restoringPosition || video.seeking) {
            return;
        }

        const current = video.currentTime;

        if (
            !video.paused &&
            current > maxWatched &&
            current <= maxWatched + 2
        ) {
            maxWatched = current;
        }

        const now = Date.now();

        if (!video.paused && now - lastSave >= 5000) {
            lastSave = now;
            saveProgress();
        }
    });

    video.addEventListener("seeking", function() {
        if (!initialized || restoringPosition) return;

        if (video.currentTime > maxWatched + 0.5) {
            restoringPosition = true;
            video.currentTime = maxWatched;
        }
    });

    video.addEventListener("seeked", function() {
        if (restoringPosition) {
            restoringPosition = false;
        }
    });

    video.addEventListener("pause", function() {
        if (initialized && !video.ended) {
            saveProgress();
        }
    });

    video.addEventListener("ended", function() {
        maxWatched = Math.max(maxWatched, video.duration);
        completed = true;
        saveProgress(true);
    });
}

Progress is saved every five seconds during playback, when the video is paused, and when it ends. A completed video can be played or searched normally. For an unfinished video, the user may rewind but cannot seek beyond max_watched.

This browser-side restriction is suitable for ordinary training workflows. Like any client-side playback control, it should not be treated as tamper-proof compliance evidence against a user deliberately modifying browser requests.

5. Opening the video from the List page

Open the videos List page in Page Designer. Select the grid row and configure its click action to open the View page in the same browser window.

Users can now click anywhere on a video row to open the player. This uses the built-in row click action and does not require additional JavaScript.

6. Showing progress with row colors

Open the videos List page and add the appropriate code to After record processed.

PHP

$user = Security::currentUserData();

$keys = array(
    "employee_id" => (int)$user["EmployeeID"],
    "video_id" => (int)$data["video_id"]
);

$watch = DB::Select("video_watch", $keys)->fetchAssoc();

if (!$watch || (float)$watch["max_watched"] <= 0) {
    $record["css"] = "background:#fce8e6;";
} elseif ((int)$watch["completed"] === 1) {
    $record["css"] = "background:#e6f4ea;";
} else {
    $record["css"] = "background:#fff4cc;";
}

XVar user = Security.currentUserData();

XVar keys = XVar.Array();
keys["employee_id"] = Convert.ToInt32(user["EmployeeID"]);
keys["video_id"] = Convert.ToInt32(data["video_id"]);

dynamic watch = DB.Select("video_watch", keys).fetchAssoc();

if (
    !XVar.Pack(watch) ||
    Convert.ToDouble(watch["max_watched"]) <= 0
)
{
    record["css"] = "background:#fce8e6;";
}
else if (Convert.ToInt32(watch["completed"]) == 1)
{
    record["css"] = "background:#e6f4ea;";
}
else
{
    record["css"] = "background:#fff4cc;";
}

Pink rows have not been started, yellow rows are in progress, and green rows are complete. The query uses the logged-in employee’s ID, so every employee sees their own progress.

7. Testing the completed application

Build the project and log in as an employee. Open a video, watch part of it, pause, and leave the page. When you return, playback should resume from the saved position. Rewinding should work, while attempts to seek beyond the furthest watched position should return the player to that position.

After the video reaches the end, its List-page row should change to green. Log in as another employee to confirm that progress is stored separately for each user.

PakarPBN

A Private Blog Network (PBN) is a collection of websites that are controlled by a single individual or organization and used primarily to build backlinks to a “money site” in order to influence its ranking in search engines such as Google. The core idea behind a PBN is based on the importance of backlinks in Google’s ranking algorithm. Since Google views backlinks as signals of authority and trust, some website owners attempt to artificially create these signals through a controlled network of sites.

In a typical PBN setup, the owner acquires expired or aged domains that already have existing authority, backlinks, and history. These domains are rebuilt with new content and hosted separately, often using different IP addresses, hosting providers, themes, and ownership details to make them appear unrelated. Within the content published on these sites, links are strategically placed that point to the main website the owner wants to rank higher. By doing this, the owner attempts to pass link equity (also known as “link juice”) from the PBN sites to the target website.

The purpose of a PBN is to give the impression that the target website is naturally earning links from multiple independent sources. If done effectively, this can temporarily improve keyword rankings, increase organic visibility, and drive more traffic from search results.

Jasa Backlink

Download Anime Batch