421 lines
9.9 KiB
PHP
Executable File
421 lines
9.9 KiB
PHP
Executable File
<?php
|
||
// 应用公共文件
|
||
|
||
use app\common\model\auth\Admin;
|
||
use app\common\model\dept\Dept;
|
||
use app\common\model\oa\Flow;
|
||
use app\common\model\oa\FlowApprove;
|
||
use app\common\model\oa\FlowRecord;
|
||
use app\common\model\oa\FlowStep;
|
||
use app\common\service\FileService;
|
||
use think\facade\Db;
|
||
use think\helper\Str;
|
||
|
||
/**
|
||
* @notes 生成密码加密密钥
|
||
* @param string $plaintext
|
||
* @param string $salt
|
||
* @return string
|
||
* @author 段誉
|
||
* @date 2021/12/28 18:24
|
||
*/
|
||
function create_password(string $plaintext, string $salt) : string
|
||
{
|
||
return md5($salt . md5($plaintext . $salt));
|
||
}
|
||
|
||
|
||
/**
|
||
* @notes 随机生成token值
|
||
* @param string $extra
|
||
* @return string
|
||
* @author 段誉
|
||
* @date 2021/12/28 18:24
|
||
*/
|
||
function create_token(string $extra = '') : string
|
||
{
|
||
$salt = env('project.unique_identification', 'likeadmin');
|
||
$encryptSalt = md5( $salt . uniqid());
|
||
return md5($salt . $extra . time() . $encryptSalt);
|
||
}
|
||
|
||
|
||
/**
|
||
* @notes 截取某字符字符串
|
||
* @param $str
|
||
* @param string $symbol
|
||
* @return string
|
||
* @author 段誉
|
||
* @date 2021/12/28 18:24
|
||
*/
|
||
function substr_symbol_behind($str, $symbol = '.') : string
|
||
{
|
||
$result = strripos($str, $symbol);
|
||
if ($result === false) {
|
||
return $str;
|
||
}
|
||
return substr($str, $result + 1);
|
||
}
|
||
|
||
|
||
/**
|
||
* @notes 对比php版本
|
||
* @param string $version
|
||
* @return bool
|
||
* @author 段誉
|
||
* @date 2021/12/28 18:27
|
||
*/
|
||
function compare_php(string $version) : bool
|
||
{
|
||
return version_compare(PHP_VERSION, $version) >= 0 ? true : false;
|
||
}
|
||
|
||
|
||
/**
|
||
* @notes 检查文件是否可写
|
||
* @param string $dir
|
||
* @return bool
|
||
* @author 段誉
|
||
* @date 2021/12/28 18:27
|
||
*/
|
||
function check_dir_write(string $dir = '') : bool
|
||
{
|
||
$route = root_path() . '/' . $dir;
|
||
return is_writable($route);
|
||
}
|
||
|
||
|
||
/**
|
||
* 多级线性结构排序
|
||
* 转换前：
|
||
* [{"id":1,"pid":0,"name":"a"},{"id":2,"pid":0,"name":"b"},{"id":3,"pid":1,"name":"c"},
|
||
* {"id":4,"pid":2,"name":"d"},{"id":5,"pid":4,"name":"e"},{"id":6,"pid":5,"name":"f"},
|
||
* {"id":7,"pid":3,"name":"g"}]
|
||
* 转换后：
|
||
* [{"id":1,"pid":0,"name":"a","level":1},{"id":3,"pid":1,"name":"c","level":2},{"id":7,"pid":3,"name":"g","level":3},
|
||
* {"id":2,"pid":0,"name":"b","level":1},{"id":4,"pid":2,"name":"d","level":2},{"id":5,"pid":4,"name":"e","level":3},
|
||
* {"id":6,"pid":5,"name":"f","level":4}]
|
||
* @param array $data 线性结构数组
|
||
* @param string $symbol 名称前面加符号
|
||
* @param string $name 名称
|
||
* @param string $id_name 数组id名
|
||
* @param string $parent_id_name 数组祖先id名
|
||
* @param int $level 此值请勿给参数
|
||
* @param int $parent_id 此值请勿给参数
|
||
* @return array
|
||
*/
|
||
function linear_to_tree($data, $sub_key_name = 'sub', $id_name = 'id', $parent_id_name = 'pid', $parent_id = 0)
|
||
{
|
||
$tree = [];
|
||
foreach ($data as $row) {
|
||
if ($row[$parent_id_name] == $parent_id) {
|
||
$temp = $row;
|
||
$child = linear_to_tree($data, $sub_key_name, $id_name, $parent_id_name, $row[$id_name]);
|
||
if ($child) {
|
||
$temp[$sub_key_name] = $child;
|
||
}
|
||
$tree[] = $temp;
|
||
}
|
||
}
|
||
return $tree;
|
||
}
|
||
|
||
|
||
/**
|
||
* @notes 删除目标目录
|
||
* @param $path
|
||
* @param $delDir
|
||
* @return bool|void
|
||
* @author 段誉
|
||
* @date 2022/4/8 16:30
|
||
*/
|
||
function del_target_dir($path, $delDir)
|
||
{
|
||
//没找到，不处理
|
||
if (!file_exists($path)) {
|
||
return false;
|
||
}
|
||
|
||
//打开目录句柄
|
||
$handle = opendir($path);
|
||
if ($handle) {
|
||
while (false !== ($item = readdir($handle))) {
|
||
if ($item != "." && $item != "..") {
|
||
if (is_dir("$path/$item")) {
|
||
del_target_dir("$path/$item", $delDir);
|
||
} else {
|
||
unlink("$path/$item");
|
||
}
|
||
}
|
||
}
|
||
closedir($handle);
|
||
if ($delDir) {
|
||
return rmdir($path);
|
||
}
|
||
} else {
|
||
if (file_exists($path)) {
|
||
return unlink($path);
|
||
}
|
||
return false;
|
||
}
|
||
}
|
||
|
||
|
||
/**
|
||
* @notes 下载文件
|
||
* @param $url
|
||
* @param $saveDir
|
||
* @param $fileName
|
||
* @return string
|
||
* @author 段誉
|
||
* @date 2022/9/16 9:53
|
||
*/
|
||
function download_file($url, $saveDir, $fileName)
|
||
{
|
||
if (!file_exists($saveDir)) {
|
||
mkdir($saveDir, 0775, true);
|
||
}
|
||
$fileSrc = $saveDir . $fileName;
|
||
file_exists($fileSrc) && unlink($fileSrc);
|
||
$ch = curl_init();
|
||
curl_setopt($ch, CURLOPT_URL, $url);
|
||
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
|
||
curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 30);
|
||
$file = curl_exec($ch);
|
||
curl_close($ch);
|
||
$resource = fopen($fileSrc, 'a');
|
||
fwrite($resource, $file);
|
||
fclose($resource);
|
||
if (filesize($fileSrc) == 0) {
|
||
unlink($fileSrc);
|
||
return '';
|
||
}
|
||
return $fileSrc;
|
||
}
|
||
|
||
|
||
/**
|
||
* @notes 去除内容图片域名
|
||
* @param $content
|
||
* @return array|string|string[]
|
||
* @author 段誉
|
||
* @date 2022/9/26 10:43
|
||
*/
|
||
function clear_file_domain($content)
|
||
{
|
||
$fileUrl = FileService::getFileUrl();
|
||
return str_replace($fileUrl, '/', $content);
|
||
}
|
||
|
||
|
||
/**
|
||
* @notes 设置内容图片域名
|
||
* @param $content
|
||
* @return array|string|string[]|null
|
||
* @author 段誉
|
||
* @date 2022/9/26 10:43
|
||
*/
|
||
function get_file_domain($content)
|
||
{
|
||
$preg = '/(<img .*?src=")[^https|^http](.*?)(".*?>)/is';
|
||
$fileUrl = FileService::getFileUrl();
|
||
return preg_replace($preg, "\${1}$fileUrl\${2}\${3}", $content);
|
||
}
|
||
|
||
|
||
/**
|
||
* @notes uri小写
|
||
* @param $data
|
||
* @return array|string[]
|
||
* @author 段誉
|
||
* @date 2022/7/19 14:50
|
||
*/
|
||
function lower_uri($data)
|
||
{
|
||
if (!is_array($data)) {
|
||
$data = [$data];
|
||
}
|
||
return array_map(function ($item) {
|
||
return strtolower(Str::camel($item));
|
||
}, $data);
|
||
}
|
||
|
||
|
||
/**
|
||
* @notes 获取无前缀数据表名
|
||
* @param $tableName
|
||
* @return mixed|string
|
||
* @author 段誉
|
||
* @date 2022/12/12 15:23
|
||
*/
|
||
function get_no_prefix_table_name($tableName)
|
||
{
|
||
$tablePrefix = config('database.connections.mysql.prefix');
|
||
$prefixIndex = strpos($tableName, $tablePrefix);
|
||
if ($prefixIndex !== 0 || $prefixIndex === false) {
|
||
return $tableName;
|
||
}
|
||
$tableName = substr_replace($tableName, '', 0, strlen($tablePrefix));
|
||
return trim($tableName);
|
||
}
|
||
|
||
|
||
/**
|
||
* @notes 生成编码
|
||
* @param $table
|
||
* @param $field
|
||
* @param string $prefix
|
||
* @param int $randSuffixLength
|
||
* @param array $pool
|
||
* @return string
|
||
* @author 段誉
|
||
* @date 2023/2/23 11:35
|
||
*/
|
||
function generate_sn($table, $field, $prefix = '', $randSuffixLength = 4, $pool = []) : string
|
||
{
|
||
$suffix = '';
|
||
for ($i = 0; $i < $randSuffixLength; $i++) {
|
||
if (empty($pool)) {
|
||
$suffix .= rand(0, 9);
|
||
} else {
|
||
$suffix .= $pool[array_rand($pool)];
|
||
}
|
||
}
|
||
$sn = $prefix . date('YmdHis') . $suffix;
|
||
if (app()->make($table)->where($field, $sn)->find()) {
|
||
return generate_sn($table, $field, $prefix, $randSuffixLength, $pool);
|
||
}
|
||
return $sn;
|
||
}
|
||
|
||
|
||
/**
|
||
* @notes 格式化金额
|
||
* @param $float
|
||
* @return int|mixed|string
|
||
* @author 段誉
|
||
* @date 2023/2/24 11:20
|
||
*/
|
||
function format_amount($float)
|
||
{
|
||
if ($float == intval($float)) {
|
||
return intval($float);
|
||
} elseif ($float == sprintf('%.1f', $float)) {
|
||
return sprintf('%.1f', $float);
|
||
}
|
||
return $float;
|
||
}
|
||
|
||
function group_by($array, $key): array
|
||
{
|
||
$result = [];
|
||
foreach ($array as $item) {
|
||
$result[$item[$key]][] = $item;
|
||
}
|
||
return $result;
|
||
}
|
||
|
||
function buildTree($items, $parentField, $parentId = 0): array
|
||
{
|
||
$tree = [];
|
||
foreach ($items as $item) {
|
||
if ($item[$parentField] == $parentId) {
|
||
$children = buildTree($items, $parentField, $item['id']);
|
||
if ($children) {
|
||
$item['children'] = $children;
|
||
}
|
||
$tree[] = $item;
|
||
}
|
||
}
|
||
return $tree;
|
||
}
|
||
|
||
function getAncestors($categoryId, $categoryTable): array
|
||
{
|
||
$parentIds = [];
|
||
foreach ($categoryTable as $item) {
|
||
if ($item['id'] == $categoryId && $item['pid'] != 0) {
|
||
$parentIds[] = $item['pid'];
|
||
// 递归调用自身，将父类ID作为参数传入
|
||
$newParentIds = getAncestors($item['pid'],$categoryTable);
|
||
$parentIds = array_merge($parentIds, $newParentIds);
|
||
}
|
||
}
|
||
|
||
return $parentIds ;
|
||
}
|
||
|
||
//数据唯一编码
|
||
function data_unique_code($str): string
|
||
{
|
||
//质量检查单-20231215-0001
|
||
return $str.'-'.date('Ymd',time()).'-'.mt_rand(100000, 999999);
|
||
}
|
||
|
||
function daysBetweenDates($start_date,$end_date): bool|int
|
||
{
|
||
$start = new DateTime($start_date);
|
||
$end = new DateTime($end_date);
|
||
$interval = $start->diff($end);
|
||
return $interval->days;
|
||
}
|
||
|
||
function addApprove($title,$content_id,$content_model,$path,$flow_id,$create_user_id)
|
||
{
|
||
$createUser = Admin::field('name,dept_id')->where('id',$create_user_id)->findOrEmpty();
|
||
//获取审批流程信息
|
||
$flowData = Flow::where('id',$flow_id)->findOrEmpty();
|
||
Db::startTrans();
|
||
try {
|
||
//添加审批内容
|
||
$approveRes = FlowApprove::create([
|
||
'title' => $title,
|
||
'content_id' => $content_id,
|
||
'content_model' => $content_model,
|
||
'path' => $path,
|
||
'flow_id' => $flow_id,
|
||
'create_user' => $create_user_id,
|
||
'check_status' => 0,
|
||
]);
|
||
$flowStepData = [];
|
||
foreach($flowData['flow_list'] as $k=>$v){
|
||
$flowStepData[] = [
|
||
'approve_id' => $approveRes->id,
|
||
'flow_name' => $flowData['check_type'] == 1 ? '' : $v['flow_step'],
|
||
'flow_step' => $flowData['check_type'] == 1 ? $v['flow_step'] : 0,
|
||
'flow_user' => implode(',',$v['flow_user']),
|
||
'sort' => $k+1,
|
||
'is_active' => $k==0 ? 1 : 0,
|
||
];
|
||
}
|
||
array_unshift($flowStepData, [
|
||
'approve_id' => $approveRes->id,
|
||
'flow_name' => '',
|
||
'flow_step' => 0,
|
||
'flow_user' => 0,
|
||
'sort' => 0,
|
||
'is_active' => 0,
|
||
]);
|
||
//添加审批步骤
|
||
foreach($flowStepData as $v){
|
||
FlowStep::create($v);
|
||
}
|
||
//添加审批记录
|
||
FlowRecord::create([
|
||
'approve_id' => $approveRes->id,
|
||
'step_id' => 0,
|
||
'check_user_id' => 0,
|
||
'check_time' => time(),
|
||
'status' => 0,
|
||
'title' => $createUser['name'].'提交了此申请',
|
||
'content' => '提交申请',
|
||
'is_invalid' => 0
|
||
]);
|
||
Db::commit();
|
||
return $approveRes->id;
|
||
} catch (\Exception $e) {
|
||
Db::rollback();
|
||
return false;
|
||
}
|
||
}
|