enhacudima/dynamic-extract
Composer 安装命令:
composer require enhacudima/dynamic-extract
包简介
With this package it will be possible to dynamically extract data from database to excel through date ranges or dynamic filters
README 文档
README
Dynamic-extract is a powerful database query extract to Excel and CSV manager for laravel PHP framework with elegant view without additional code.
Features
- Powerful, Simple & fast
- Robust background job processing (queues)
- Login session (Laravel Auth or built-in verfication token)
- Dynamic filters
- Notifications
- Preview data
Demo
https://www.youtube.com/watch?v=-FekEilPLsM
FAQ
Why I need this?
Imagine that you have an application with a database and you are responsible for creating reports via SQL queries for different users or departments. This package will help you manage access and perform some of the more complex database tasks on the end user, without the end user having database knowledge.
Requires
Get all items
| Parameter | Verson | Description |
|---|---|---|
php |
^7.3 or ^8.0 |
Required |
laravel/framework |
^8.75 |
Required |
maatwebsite/excel |
^3.1 |
Required |
Installation
Install with composer
composer require enhacudima/dynamic-extract
php artisan dynamic-extract:install
Filter Function
- Date range
- Search field
- Dropdown field
- Group by
- Select table columuns
- Less than
- Greater than
Commands
Add new tables to the list
php artisan dynamic-extract:tables
List tables
php artisan dynamic-extract:tables-list
Add new access
php artisan dynamic-extract:access
List access
php artisan dynamic-extract:access-list
Revoke access
php artisan dynamic-extract:access-revoke {email}
Delete exported files
php artisan dynamic-extract:delete-exported
Other commands
You don't need to run the commands on first installation
Migration
php artisan migrate --path=/vendor/enhacudima/dynamic-extract/src/DataBase/Migration
Config
php artisan vendor:publish --provider="Enhacudima\DynamicExtract\Providers\DynamicExtractServiceProvider" --tag="config"
Configurations
All configuration well be place on config file at app/config/dynamic-extract.php. after modification please run
php artisan config:cache
List
| Parameter | type | Description |
|---|---|---|
auth |
boolean |
If is true you must implement Laravel Auth |
prefix |
array |
Prefix your route name and extracted folder name |
(Permission)- permissions |
string |
Example: table_view |
(Permission) - middleware |
array |
Example: web |
permissions |
array |
Set your permissions based on your application premissions |
Security Vulnerabilities
If you discover a security vulnerability, please send an e-mail to kalibredj@outlook.com. All security vulnerabilities will be promptly addressed.
License
licensed under the MIT license.
enhacudima/dynamic-extract 适用场景与选型建议
enhacudima/dynamic-extract 是一款 基于 Blade 开发的 Composer 扩展包,目前已累计 205 次下载、GitHub Stars 达 3, 最近一次更新时间为 2022 年 01 月 24 日, 在 PHP 生态内属于活跃度较高的组件。
我们在过去多个企业项目中使用过 enhacudima/dynamic-extract 或与其功能相近的方案,如果你在选型或落地过程中遇到问题,例如 版本兼容、二次改造、私有化封装、与内部系统对接、生产 BUG 排查,欢迎联系我们协助评估。
基于 enhacudima/dynamic-extract 在你已有业务上做功能扩展、字段裁剪、UI 适配、与内部账号 / 权限 / 日志系统的深度对接。
线上偶发问题、内存泄漏、慢查询、并发异常等排查修复;针对高流量场景做缓存、队列、索引层面的调优。
承接完整的项目从需求 → 设计 → 开发 → 上线 → 长期运维;也可按月提供技术保姆服务。
统计信息
- 总下载量: 205
- 月度下载量: 0
- 日度下载量: 0
- 收藏数: 3
- 点击次数: 6
- 依赖项目数: 0
- 推荐数: 0
其他信息
- 授权协议: MIT
- 更新时间: 2022-01-24