One, foreword

A few years ago to write this video monitoring system, is planning to join the user rights management, because do not belong to the function of the need to wait until now, just a handful of other recent project will need this function, as well as the secret key authentication, so the momentum will kill this several features a piece, the finish is not very full of powerful user rights management, Powerful user rights management, can be done for each button can be performed each menu access control, so in fact is more complicated, for users also complex, need professional people to operate the corresponding software, this time to complete the user permissions, the target is universal access to gm’s existing major projects, implementation based access control, For example, enter the corresponding sub-menu module, delete records, exit the system and so on. In order to achieve universality, 7 permission fields are made in the user information table, which basically meets the needs of existing projects. To make a bit more perfect, the permission fields in the user information table can be split into separate role tables, and then assign roles to each user.

User information table design

  • UserName: UserName
  • User password: UserPwd
  • UserType: UserType: administrator or operator
  • User Permission1: Permission1
  • User Permission2: Permission2
  • User Permission3: Permission3
  • User Permission4: Permission4
  • User Permission5: Permission5
  • User Permission6: Permission6
  • User Permission7: Permission7

User rights management process

  • After the system starts, load the user information table to the corresponding user linked list for storage.
  • For different projects, set different module permission names corresponding to seven permission fields.
  • After a user logs in or automatically logs in, the permissions of the current user are queried in the UserPermission global variable.
  • Provide the checkPermission function to pass in the module name, find the corresponding permission location, and determine whether the permission is available.
  • Execute checkPermission after a menu or button is clicked where the permission needs to be checked.

Two, functional characteristics

(1) Software module

  1. Video monitoring module, various docking small window sub-module, including device list, graphic warning, window information, panyt control, preset position, cruise setting, device control, floating map, web browsing, etc.
  2. Video playback module, including local playback, remote playback, device playback, picture playback, video upload, etc.
  3. Electronic map module, including picture map, online map, offline map, path planning, etc.
  4. Log query module, including local logs, device logs, etc.
  5. System setting module, including system Settings (basic Settings, video parameters, database Settings, map configuration, serial port configuration, etc.), VIDEO recorder management, camera management, polling configuration, user management, etc.

(2) Basic functions

  1. Support various video streams (RTSP, RTMP, HTTP, etc.), video files (MP4, RMVB, AVI, etc.), local USB camera playback.
  2. Support multi-screen switching, including 1, 4, 6, 8, 9, 13, 16, 25, 36, 64 screen switching.
  3. Supports full-screen switching, including the right mouse button, toolbar button, and shortcut keys (Alt + Enter full-screen, esc exit full-screen).
  4. Supports video polling, including 1, 4, 9, and 16 screen polling. You can set polling group (polling plan), polling interval, and bit stream type.
  5. Supports the OnVIF protocol, including device search, pte control, device control (picture parameters, check time, system restart, capture pictures, etc.).
  6. Different users can have different module permissions, such as deleting logs and shutting down the system.
  7. Support a variety of databases, including sqlite, mysql, sqlserver, postgresql, oracle, rendajincang and so on.
  8. You can set resolution and frame rate for a local USB camera.
  9. All docking modules automatically generate corresponding menus to control the display and hide, in the title bar right click can pop up.
  10. Display all modules, hide all modules, reset the common layout, and reset the full-screen layout.
  11. Double-click the device to pop up real-time preview video, supporting picture map, online map, offline map, etc.
  12. The camera node can be dragged to the corresponding window to play the video, and the local file can be dragged to play the video.
  13. You can delete a video by right-clicking the mouse button, closing the floating bar, or dragging it outside the video surveillance panel.
  14. The device button on the picture map can be dragged freely to automatically save the location information. You can click the mouse to obtain the longitude and latitude information on the Baidu map to update the location of the device.
  15. Any channel in the video surveillance panel form supports drag exchange, instant response.
  16. Encapsulated Baidu map, view switch, movement track, equipment point, mouse click to obtain latitude and longitude.
  17. Double-click the node, drag the node, drag the window to switch positions and other operations, will automatically update and save the last playing address, the next software open automatic application.
  18. Volume bar control in the lower right corner, automatically hide when losing focus, volume strip mute icon.
  19. You can specify a screenshot for a single channel or all channels. The screenshot button is also available on the bottom toolbar.
  20. The mouse pointer can be automatically hidden when timeout expires and the mouse pointer can be automatically displayed in full screen.
  21. Support onVIF PTZ control, can move PTZ camera up, down, left and right, including reset and focal length adjustment.
  22. Support any ONVIF camera, including but not limited to Hikang, Dahua, Yushi, Weiye, Huawei, etc.
  23. Can save video, can select the time storage or single file storage, optional storage interval time.
  24. Video stream communication mode can be set TCP + UDP, video decoding can be set speed first, quality first, balance, etc.
  25. You can set the software name, English name, and LOGO icon.
  26. You can export stored video files to specific directories or upload them to servers in batches.

(3) Features and functions

  1. The main interface adopts the mode of docked form, various components in the form of small modules, can be customized to join any module.
  2. Docking module can drag any position embedded and suspended, support maximum full screen, support multi-screen.
  3. Dual layout file storage mechanism, normal mode and full-screen mode are corresponding to different layout schemes, automatic switching and saving, for example, full-screen mode can highlight several modules transparent display in the specified position, more science fiction sense of modernization.
  4. Original onVIF protocol mechanism, using the underlying protocol resolution (UDP broadcast search + HTTP request execution command) more lightweight easy to understand learning expansion, does not rely on any third-party components such as GSOAP.
  5. Original data import and export mechanism, cross-platform independent of any components, instant data export.
  6. Built in multiple original components, the universe super value super awesome, Including data import and export components (export to XLS, PDF, printing), database components (database management thread, automatic data cleaning thread, universal paging, data request, etc.), map component, video monitoring component, file multithreading transceiver component, onVIF communication component, universal browser kernel component, etc.
  7. Customize information box + error box + query box + lower right prompt box (including various formats).
  8. Exquisite skin change, up to 17 sets of skin styles can be changed at will, all styles are unified, including menu, etc.
  9. Multiple buttons can be added to the video control hover bar, and buttons can also be added to the small toolbar at the bottom of the monitoring interface.
  10. Double click the camera node to automatically play the video, double click the node to automatically add the video, it will automatically jump to the next, double click the parent node to automatically add all the videos under the node. Primary stream and sub-stream are optional.
  11. You can add, delete, and modify the import and export printed information, and immediately apply the new device information to generate a tree list without restarting.
  12. Optional a variety of kernel free switch, FFMPEG, VLC, MPV, etc., can be set in pro. Ffmpeg is recommended. It is most cross-platform and provides libraries compiled on Linux and MAC platforms by default.
  13. Supports hard decoding and can be set to hard decoding type (QSV, DXVA2, d3D11VA, etc.).
  14. The default opengL rendering video, ultra-low CPU resource consumption, support YUYV and NV12 two formats to draw, very awesome.
  15. Highly customizable, users can easily derive their own functions on this basis, such as adding custom modules, adding operation mode, robot monitoring, uav monitoring, excavator monitoring, etc.
  16. Support XP, Win7, Win10, Linux, MAC, a variety of domestic systems (UOS, kyrin, Galaxy Kyrin, etc.), embedded Linux and other systems.
  17. Complete annotation, clear project structure, super detailed complete use of the development manual, accurate to the function description of each code file, continuous iteration version.

3. Experience address

  1. Experience address: pan.baidu.com/s/1d7TH_GEY… Extraction code: 01Jf File name: bin_video_system.zip
  2. Domestic site: gitee.com/feiyangqing…
  3. International site: github.com/feiyangqing…
  4. Profile: blog.csdn.net/feiyangqing…
  5. Zhihu homepage: www.zhihu.com/people/feiy…
  6. Online documentation: feiyangqingyun. Gitee. IO/qwidgetdemo…

Four, effect drawing

Five, core code

 void frmConfigUser::initData(a)
{
    // Instantiate the database table model
    model = new QSqlTableModel(this);
    // Specify the table name
    model->setTable("UserInfo");
    // Set the column sort
    model->setSort(0, Qt::AscendingOrder);
    // Set the commit mode
    model->setEditStrategy(QSqlTableModel::OnManualSubmit);
    // Query immediately
    model->select(a);// Set the database table model on the table
    ui->tableView->setModel(model);
    ui->tableView->setProperty("model".true);

    // Initialize the column name and width
    columnNames << "User name" << "User password" << "User Type";
    columnWidths << 100 << 120 << 80;

    columnNames << AppData::PermissionName;
    for (int i = 0; i < AppData::PermissionName.count(a); ++i) { columnWidths << delegateWidth.at(i);
    }

    columnNames << "Note";
    columnWidths << 60;

    // Special resolution resets the column width
    int count = columnNames.count(a);if (QUIHelper::deskWidth() > =1920) {
        for (int i = 0; i < count; i++) {
            columnWidths[i] += 30; }}// Set the column name and width one by one
    for (int i = 0; i < count; i++) {
        model->setHeaderData(i, Qt::Horizontal, columnNames.at(i));
        ui->tableView->setColumnWidth(i, columnWidths.at(i));
    }

    // User password delegate
    DbDelegate *d_txt_userPwd = new DbDelegate(this);
    d_txt_userPwd->setDelegateType("QLineEdit");
    d_txt_userPwd->setDelegatePwd(true);
    d_txt_userPwd->setDelegateColumn(1);
    ui->tableView->setItemDelegateForColumn(1, d_txt_userPwd);

    // User type delegate
    QStringList userType;
    userType << "Operator" << "Administrator";
    DbDelegate *d_cbox_userType = new DbDelegate(this);
    d_cbox_userType->setDelegateType("QComboBox");
    d_cbox_userType->setDelegateValue(userType);
    ui->tableView->setItemDelegateForColumn(2, d_cbox_userType);

    // Permission delegate
    int index = 3;
    count = AppData::PermissionName.count() + index;
    for (int i = index; i < count; i++) {
        // Retrieve the delegate type and value
        QString type = delegateType.at(i - index);
        QStringList value = delegateValue.at(i - index);
        DbDelegate *delegate = new DbDelegate(this);
        delegate->setDelegateType(type);

        if (type == "QCheckBox") {
            delegate->setDelegateColumn(i);
            delegate->setCheckBoxText("Enable"."Disabled");
        } else if (type == "QComboBox") {
            delegate->setDelegateValue(value);
        }

        ui->tableView->setItemDelegateForColumn(i, delegate);
        delegates << delegate;
    }

    // Use to switch styles to automatically change colors
    delegates << d_txt_userPwd;
    delegates << d_cbox_userType;
}

void frmConfigUser::on_btnAdd_clicked(a)
{
    // Insert a line
    int count = model->rowCount(a); model->insertRow(count);

    // The rule is clear and uses the loop directly to assign values
    int columns = columnNames.count(a);for (int i = 0; i < columns; ++i) {
        // Get the corresponding column of the previous row
        QString data = model->index(count - 1, i).data().toString(a);// Set the default value for the newly added row
        model->setData(model->index(count, i), data);
    }

    // Select the newly added row immediately
    ui->tableView->setCurrentIndex(model->index(count, 0));
}

void frmConfigUser::on_btnSave_clicked(a)
{
    // Enable database transaction commit data
    model->database().transaction(a);if (model->submitAll()) {
        model->database().commit(a); }else {
        If the commit fails, the transaction is rolled back and an error message is printed
        model->database().rollback(a);qDebug() << TIMEMS << model->database().lastError(a); QUIHelper::showMessageBoxError("Failed to save information, please fill in again!");
    }

    // Some databases need to be actively queried or otherwise blank, such as odBC data source
    model->select(a); }void frmConfigUser::on_btnDelete_clicked(a)
{
    int row = ui->tableView->currentIndex().row(a);if (row < 0) {
        QUIHelper::showMessageBoxError("Please select the user to delete!");
        return;
    }

    if (QUIHelper::showMessageBoxQuestion("Are you sure you want to delete this user? Delete cannot recover!") == QMessageBox::Yes) {
        QString userName = model->index(row, 0).data().toString(a);if (userName == "admin") {
            QUIHelper::showMessageBoxError("Administrator [admin] cannot be deleted!".3);
            return;
        }

        model->removeRow(row);
        model->submitAll(a); ui->tableView->setCurrentIndex(model->index(model->rowCount() - 1.0)); }}void frmConfigUser::on_btnReturn_clicked(a)
{
    model->revertAll(a); }void frmConfigUser::on_btnClear_clicked(a)
{
    if (model->rowCount() < =0) {
        return;
    }

    if (QUIHelper::showMessageBoxQuestion("Are you sure you want to clear all user information?") == QMessageBox::Yes) {
        DbQuery::clearUserInfo(a); model->select();
    }
}
Copy the code