PHPackages                             hexin/library - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Utility & Helpers](/categories/utility)
4. /
5. hexin/library

ActiveLibrary[Utility & Helpers](/categories/utility)

hexin/library
=============

hexin library for php projects

v10.6(2mo ago)0790MITPHPPHP >=7.2

Since Oct 20Pushed 2mo ago1 watchersCompare

[ Source](https://github.com/34615747/hexin_library)[ Packagist](https://packagist.org/packages/hexin/library)[ RSS](/packages/hexin-library/feed)WikiDiscussions main Synced 1mo ago

READMEChangelogDependencies (2)Versions (118)Used By (0)

laravel工具包
----------

[](#laravel工具包)

1. Jobmessage 队列管理工具
2. redis锁
3. 一些helper类型：数组、日期、请求、字符串、导出csv类
4. 审批流
5. 导出xls类
6. 文件导入任务
7. 导出任务
8. 工厂导出类
9. 发送消息
10. 生成单号

安装：composer require hexin/library

一、Jobmessage 队列管理工具
-------------------

[](#一jobmessage-队列管理工具)

**①.杜绝事务回滚，但队列又执行的bug ②.担心事务没提交，设置队列的延迟时间过长的问题 ③.执行记录留痕**

继承JobMessageModel，重写部分方法，比如insertJob等 ###1、创建表

```
     CREATE TABLE `job_message` (
          `id` int NOT NULL AUTO_INCREMENT,
          `merchant_id` int NOT NULL DEFAULT '0' COMMENT '商户id',
          `platform_id` int NOT NULL DEFAULT '0' COMMENT '平台id',
          `business_type` smallint NOT NULL DEFAULT '0' COMMENT '类型',
          `business_type_name` varchar(64) NOT NULL DEFAULT '' COMMENT '类型名称',
          `params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '参数',
          `is_now` tinyint(1) NOT NULL DEFAULT '2' COMMENT '是否马上执行队列,1是2否',
          `fail_count` int NOT NULL DEFAULT '0' COMMENT '失败次数',
          `is_retry` tinyint(1) NOT NULL DEFAULT '2' COMMENT '重跑次数',
          `command_run_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '定时任务的运行开始时间（延迟队列可用）',
          `status` smallint NOT NULL DEFAULT '2' COMMENT '状态',
          `status_name` varchar(64) NOT NULL DEFAULT '' COMMENT '状态名称',
          `update_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
          `create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
          `start_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '开始时间',
          `end_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '结束时间',
          `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
          PRIMARY KEY (`id`),
          KEY `business_type` (`business_type`) USING BTREE
     ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
```

\###2、插入队列

```