SNS
思拓
szbaoye docs
ThinkSNS docs
szbaoye-plus
plus szbaoye_dev
plus szbaoye
laravel 文件上传
laravel-debugbar
select column_name, column_comment from information_schema.columns where table_name='feeds' and table_schema='plus';
$request->query('title'); //url参数
$request->all(); //所有参数，含url参数,form参数
$request->only(['title','age']); //过滤all()中的参数
调试信息写入日志
\Illuminate\Support\Facades\Log::info("开始缓存经理反馈日志报表中客户数据");
查看路由列表
php artisan route:list -c --method=post
php artisan route:list -c --path=feeds
php artisan cache:clear
php artisan route:clear
php artisan config:clear
php artisan view:clear
oomposer dump-autoload
cdn
listener
observer
policies
filter
notification
job
schedule
$table->bigIncrements('id');
$table->unsignedInteger('department_id')->index()->comment('所属部门');
$table->enum('type', ['suggestion', 'complaint', 'question'])->index()->comment('问政类型');
$table->boolean('is_recommend')->default(false)->comment('推荐');
$table->unsignedBigInteger('user_id')->index()->comment('创建者');
$table->tinyInteger('status')->default(0)->comment('受理状态');
$table->string('title')->index()->comment('问政题');
$table->json('images')->nullable()->comment('图片');
$table->json('video')->nullable()->comment('视频');
$table->text('content')->comment('问政内容');
$table->unsignedInteger('likes_count')->default(0)->comment('点赞数量');
$table->tinyInteger('rating')->nullable()->comment('评分');
$table->timestamps();
Schema::create('gov_affairs_logs', static function (Blueprint $table) {
$table->bigIncrements('id');
$table->unsignedBigInteger('user_id')->comment('操作用户');
$table->unsignedInteger('affair_id')->nullable()->comment('问政id');
$table->unsignedInteger('department_id')->nullable()->comment('部门id');
$table->enum('operation', [
AffairLog::EDIT,
AffairLog::AUDIT,
AffairLog::REFUSE,
AffairLog::TRANSFER,
AffairLog::REVOKE,
AffairLog::DELETE,
AffairLog::REPLY,
AffairLog::EDIT_DEPARTMENT,
AffairLog::ADD_DEPARTMENT,
AffairLog::DELETE_DEPARTMENT,
AffairLog::UN_RECOMMEND,
AffairLog::RECOMMEND
])->nullable()->comment('操作内容');
$table->json('extra')->nullable()->comment('额外内容');
$table->ipAddress('ip_address')->comment('操作者网络地址');
$table->timestamps();
});
CREATE TABLE `feeds` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '动态 ID',
`user_id` int(10) unsigned NOT NULL COMMENT '作者UID',
`feed_content` text COLLATE utf8mb4_unicode_ci COMMENT '动态内容',
`feed_from` tinyint(3) unsigned DEFAULT '1' COMMENT '动态来源 1:pc 2:h5 3:ios 4:android 5:其他',
`like_count` int(10) unsigned DEFAULT '0' COMMENT '动态点赞数',
`feed_view_count` int(10) unsigned DEFAULT '0' COMMENT '动态阅读数',
`feed_comment_count` int(10) unsigned DEFAULT '0' COMMENT '动态评论数',
`feed_client_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '::1' COMMENT '发布IP',
`audit_status` tinyint(4) DEFAULT '1' COMMENT '审核状态 0-未审核 1-已审核 2-未通过',
`feed_mark` bigint(20) NOT NULL COMMENT '唯一标记',
`repostable_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '可转发的资源类型',
`repostable_id` int(10) unsigned DEFAULT '0' COMMENT '可转发的资源 ID',
`hot` int(10) unsigned DEFAULT '0' COMMENT '热门排序值',
`shares_count` int(10) unsigned DEFAULT '0' COMMENT '分享数统计',
`images` text COLLATE utf8mb4_unicode_ci COMMENT '图片资源',
`video` text COLLATE utf8mb4_unicode_ci COMMENT '视频资源',
`visible` tinyint(3) unsigned NOT NULL DEFAULT '1',
`recommended_at` timestamp NULL DEFAULT NULL COMMENT '是否为推荐',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`theme_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `feeds_feed_mark_unique` (`feed_mark`),
KEY `feeds_user_id_index` (`user_id`),
KEY `feeds_hot_index` (`hot`),
KEY `feeds_created_at_index` (`created_at`),
KEY `feeds_deleted_at_index` (`deleted_at`),
KEY `feeds_recommended_at_index` (`recommended_at`),
KEY `feeds_audit_status_index` (`audit_status`),
KEY `feeds_theme_id_index` (`theme_id`),
KEY `feeds_visible_index` (`visible`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
设置阿里云composer库
composer config -g repo.packagist composer https://mirrors.aliyun.com/composer/
composer selfupdate
恢复默认composer库
composer config -g --unset repos.packagist
git@github.com:marsnut/zhgdocs.git
git@gitee.com:lin1914/plus-shenzhenbaoye.git
https://gitee.com/lin1914
composer install
#复制storage/configure下的plus.yml.example为plus.yml，.env.example为.env，plus.yml配置好数据库信息
php artisan migrate --seed
//php artisan db:seed
php artisan storage:link
php artisan vendor:publish --all
php artisan app:key-generate
07-02
* branch dev -> FETCH_HEAD
2224c14c3..4decbb5b3 dev -> origin/dev
Updating 2224c14c3..4decbb5b3
Fast-forward
app/API2/Resources/Feed.php | 2 +-
app/Console/Commands/QueryJobList.php | 45 +++++++
app/Console/Kernel.php | 1 +
.../Filesystems/AliyunOssFilesystem.php | 51 ++++---
app/FileStorage/Validators/CreateTaskValidator.php | 2 +-
.../Controllers/APIs/V2/UserCommentController.php | 75 +++++++++--
app/Http/Kernel.php | 2 +-
app/Models/TranscodeJob.php | 38 ++++++
app/Services/AliSdk.php | 146 +++++++++++++++++++++
app/Services/Transcode.php | 138 +++++++++++++++++++
app/helpers.php | 2 +-
composer.json | 3 +-
.../2020_06_28_100108_create_transcode_job.php | 34 +++++
...6_28_101201_alter_feed_add_transcode_status.php | 32 +++++
docs/comments.md | 114 ++++++++++++++++
docs/feed_add.md | 90 +++++++++++++
packages/slimkit-plus-feed/routes/admin.php | 1 +
.../slimkit-plus-feed/src/API2/FeedController.php | 7 +
.../src/Admin/Controllers/Feed.php | 22 +++-
.../src/AdminControllers/FeedController.php | 13 +-
packages/slimkit-plus-feed/src/Models/Feed.php | 20 ++-
routes/api.php | 5 +-
22 files changed, 797 insertions(+), 46 deletions(-)
create mode 100644 app/Console/Commands/QueryJobList.php
create mode 100644 app/Models/TranscodeJob.php
create mode 100644 app/Services/AliSdk.php
create mode 100644 app/Services/Transcode.php
create mode 100644 database/migrations/2020_06_28_100108_create_transcode_job.php
create mode 100644 database/migrations/2020_06_28_101201_alter_feed_add_transcode_status.php
create mode 100644 docs/comments.md
2020-07-06
.../Controllers/GovAffair/AffairController.php | 45 +--
app/API2/Requests/GovAffair/CreateAffair.php | 2 +-
app/Http/Controllers/APIs/V2/AuthController.php | 5 -
app/Http/Controllers/Admin/UserController.php | 26 ++
app/Http/Controllers/Auth/LoginController.php | 79 +++++-
...7_02_073159_alter_users_table_add_custom_id.php | 33 +++
.../2020_07_02_080114_alter_user_add_identify.php | 32 +++
packages/slimkit-plus-feed/admin/apis/index.js | 24 +-
packages/slimkit-plus-feed/admin/views/Feeds.vue | 60 +++-
.../slimkit-plus-feed/admin/views/PostFeed.vue | 10 +
.../admin/views/components/feed-content.vue | 3 +
.../admin/views/components/feed-edit.vue | 302 +++++++++++++++++++++
packages/slimkit-plus-feed/admin/views/sort.vue | 1 +
.../css/{chunk-61206246.css => chunk-148df7eb.css} | 2 +-
.../css/{chunk-48841d39.css => chunk-62d56a3c.css} | 2 +-
public/assets/feed/css/chunk-d527060c.css | 1 +
public/assets/feed/css/chunk-d6d7ed3c.css | 1 -
public/assets/feed/index.html | 2 +-
public/assets/feed/js/app.js | 6 +-
public/assets/feed/js/chunk-148df7eb.js | 1 +
public/assets/feed/js/chunk-48841d39.js | 1 -
public/assets/feed/js/chunk-61206246.js | 1 -
public/assets/feed/js/chunk-62d56a3c.js | 1 +
public/assets/feed/js/chunk-d527060c.js | 1 +
public/assets/feed/js/chunk-d6d7ed3c.js | 1 -
public/assets/feed/js/chunk-f3538ae2.js | 2 +-
resources/h5/app/components/video.vue | 8 +-
routes/admin.php | 6 +-
routes/web.php | 15 +-
29 files changed, 620 insertions(+), 53 deletions(-)
create mode 100644 database/migrations/2020_07_02_073159_alter_users_table_add_custom_id.php
create mode 100644 database/migrations/2020_07_02_080114_alter_user_add_identify.php
create mode 100644 packages/slimkit-plus-feed/admin/views/components/feed-edit.vue
rename public/assets/feed/css/{chunk-61206246.css => chunk-148df7eb.css} (52%)
rename public/assets/feed/css/{chunk-48841d39.css => chunk-62d56a3c.css} (58%)
create mode 100644 public/assets/feed/css/chunk-d527060c.css
delete mode 100644 public/assets/feed/css/chunk-d6d7ed3c.css
create mode 100644 public/assets/feed/js/chunk-148df7eb.js
delete mode 100644 public/assets/feed/js/chunk-48841d39.js
delete mode 100644 public/assets/feed/js/chunk-61206246.js
create mode 100644 public/assets/feed/js/chunk-62d56a3c.js
create mode 100644 public/assets/feed/js/chunk-d527060c.js
delete mode 100644 public/assets/feed/js/chunk-d6d7ed3c.js
2020-08-21
app/API2/Controllers/NotificationController.php | 54 +-
packages/slimkit-plus-feed/routes/admin.php | 9 +-
packages/slimkit-plus-feed/routes/new-admin.php | 71 +-
.../src/Admin/Controllers/Feed.php | 25 +-
.../src/AdminControllers/CommentController.php | 94 +-
2020-09-04
app/Http/Controllers/APIs/V2/AuthController.php | 123 +++++++++++++----
...2020_08_26_021253_update_users_table_avatar.php | 31 +++++
.../2020_09_01_015229_add_hot_column_to_feeds.php | 32 +++++
packages/slimkit-plus-feed/routes/api2.php | 3 +
packages/slimkit-plus-feed/routes/new-admin.php | 3 +
.../slimkit-plus-feed/src/API2/FeedController.php | 145 +++++++++++++++++++--
.../src/Admin/Controllers/Feed.php | 24 ++++
.../src/AdminControllers/CommentController.php | 50 +++----
.../src/FormRequest/Admin/HottagFeed.php | 49 +++++++
routes/api.php | 1 +
21 files changed, 462 insertions(+), 72 deletions(-)
create mode 100644 database/migrations/2020_08_26_021253_update_users_table_avatar.php
create mode 100644 database/migrations/2020_09_01_015229_add_hot_column_to_feeds.php
create mode 100644 packages/slimkit-plus-feed/src/FormRequest/Admin/HottagFeed.php