lihai-oa/app/api/common.php

132 lines
3.1 KiB
PHP

<?php
/**
* @copyright Copyright (c) 2021 勾股工作室
* @license https://opensource.org/licenses/GPL-3.0
* @link https://www.gougucms.com
*/
use think\facade\Db;
//读取文章分类列表
function get_article_cate()
{
$cate = \think\facade\Db::name('ArticleCate')->order('create_time asc')->select()->toArray();
return $cate;
}
//写入日志
function add_project_log($uid,$module,$param,$old)
{
$log_data = [];
$key_array = ['id', 'create_time', 'update_time', 'delete_time', 'over_time', 'md_content'];
foreach ($param as $key => $value) {
if (!in_array($key, $key_array)) {
$log_data[] = array(
'module' => $module,
'field' => $key,
$module . '_id' => $param['id'],
'admin_id' => $uid,
'old_content' => $old[$key],
'new_content' => $value,
'create_time' => time(),
);
}
}
Db::name('ProjectLog')->strict(false)->field(true)->insertAll($log_data);
}
function isAuthProject($uid)
{
if($uid == 1){
return 1;
}
$map = [];
$map[] = ['name', '=', 'project_admin'];
$map[] = ['', 'exp', Db::raw("FIND_IN_SET('{$uid}',uids)")];
$count = Db::name('DataAuth')->where($map)->count();
return $count;
}
//读取会议室
function oa_meeting_cate_column()
{
$list = Db::name('MeetingCate')->where(['status' => 1])->column('title', 'id');
return $list;
}
//读取部门列表
function get_department_column()
{
$department = Db::name('Department')->order('sort desc,id asc')->where(['status' => 1])->column('title', 'id');
return $department;
}
//读取印章类型
function oa_seal_cate_column()
{
$list = Db::name('SealCate')->where(['status' => 1])->column('title', 'id');
return $list;
}
//读取车辆类型
function oa_car_cate_column()
{
$list = Db::name('CarCate')->where(['status' => 1])->column('title,name', 'id');
$car = [];
foreach($list as $k=>$v) {
$car[$k] = $v['title'] . '[' . $v['name']. ']';
}
return $car;
}
//读取费用类型
function oa_cost_cate_column()
{
$list = Db::name('CostCate')->where(['status' => 1])->column('title', 'id');
return $list;
}
//读取职位
function get_position_column()
{
$position = Db::name('Position')->where(['status' => 1])->column('title', 'id');
return $position;
}
//是否是报销打款管理员,count>1即有权限
function isAuthExpense($uid)
{
if($uid == 1){
return 1;
}
$map = [];
$map[] = ['name', '=', 'finance_admin'];
$map[] = ['', 'exp', Db::raw("FIND_IN_SET('{$uid}',uids)")];
$count = Db::name('DataAuth')->where($map)->count();
return $count;
}
//是否是发票管理员,count>1即有权限
function isAuthInvoice($uid)
{
if($uid == 1){
return 1;
}
$map = [];
$map[] = ['name', '=', 'finance_admin'];
$map[] = ['', 'exp', Db::raw("FIND_IN_SET('{$uid}',conf_1)")];
$count = Db::name('DataAuth')->where($map)->count();
return $count;
}
//是否是到账管理员,count>1即有权限
function isAuthIncome($uid)
{
if($uid == 1){
return 1;
}
$map = [];
$map[] = ['name', '=', 'finance_admin'];
$map[] = ['', 'exp', Db::raw("FIND_IN_SET('{$uid}',conf_2)")];
$count = Db::name('DataAuth')->where($map)->count();
return $count;
}