<?php
|
|
declare (strict_types = 1);
|
|
namespace app\user\controller;
|
|
use app\base\BaseController;
|
// use app\user\validate\PositionCheck;
|
use think\exception\ValidateException;
|
use think\facade\Db;
|
use think\facade\View;
|
|
class Attendance extends BaseController
|
{
|
public function index()
|
{
|
if (request()->isAjax()) {
|
$list = Db::name('AttendanceGroup')->where('is_del', '=', 0)->order('create_time asc')->select()->toArray();
|
// var_dump($list);
|
// foreach ($list as &$val) {
|
// $groupId = Db::name('PositionGroup')->where(['pid' => $val['id']])->column('group_id');
|
// $groupName = Db::name('AdminGroup')->where('id', 'in', $groupId)->column('title');
|
// $val['groupName'] = implode(',', $groupName);
|
// }
|
$res['data'] = $list;
|
return table_assign(0, '', $res);
|
} else {
|
return view();
|
}
|
}
|
|
//添加&编辑
|
public function add()
|
{
|
$param = get_params();
|
if (request()->isAjax()) {
|
if (!empty($param['id']) && $param['id'] > 0) {
|
try {
|
validate(PositionCheck::class)->scene('edit')->check($param);
|
} catch (ValidateException $e) {
|
// 验证失败 输出错误信息
|
return to_assign(1, $e->getError());
|
}
|
// 启动事务
|
Db::startTrans();
|
try {
|
Db::name('AttendanceGroup')->where(['id' => $param['id']])->strict(false)->field(true)->update($param);
|
// Db::name('PositionGroup')->where(['pid' => $param['id']])->delete();
|
// foreach ($param['group_id'] as $k => $v) {
|
// $data[$k] = [
|
// 'pid' => $param['id'],
|
// 'group_id' => $v,
|
// 'create_time' => time(),
|
// ];
|
// }
|
// Db::name('PositionGroup')->strict(false)->field(true)->insertAll($data);
|
add_log('edit', $param['id'], $param);
|
//清除菜单\权限缓存
|
// clear_cache('adminMenu');
|
// clear_cache('adminRules');
|
// 提交事务
|
Db::commit();
|
} catch (\Exception $e) {
|
// 回滚事务
|
Db::rollback();
|
return to_assign(1, '提交失败:' . $e->getMessage());
|
}
|
} else {
|
try {
|
validate(PositionCheck::class)->scene('add')->check($param);
|
} catch (ValidateException $e) {
|
// 验证失败 输出错误信息
|
return to_assign(1, $e->getError());
|
}
|
// 启动事务
|
Db::startTrans();
|
try {
|
$uid = Db::name('AttendanceGroup')->strict(false)->field(true)->insertGetId($param);
|
// foreach ($param['group_id'] as $k => $v) {
|
// $data[$k] = [
|
// 'pid' => $uid,
|
// 'group_id' => $v,
|
// 'create_time' => time(),
|
// ];
|
// }
|
// Db::name('PositionGroup')->strict(false)->field(true)->insertAll($data);
|
add_log('add', $uid, $param);
|
// 提交事务
|
Db::commit();
|
} catch (\Exception $e) {
|
// 回滚事务
|
Db::rollback();
|
return to_assign(1, '提交失败:' . $e->getMessage());
|
}
|
}
|
return to_assign();
|
}
|
else{
|
$id = isset($param['id']) ? $param['id'] : 0;
|
// $group = Db::name('AdminGroup')->order('create_time asc')->select()->toArray();
|
// if ($id > 0) {
|
$detail = Db::name('AttendanceGroup')->where(['id' => $id])->find();
|
// $detail['group_id'] = Db::name('PositionGroup')->where(['pid' => $id])->column('group_id');
|
// foreach ($group as &$val) {
|
// if (in_array($val['id'], $detail['group_id'])) {
|
// $val['checked'] = 1;
|
// } else {
|
// $val['checked'] = 0;
|
// }
|
// }
|
View::assign('detail', $detail);
|
// }
|
// View::assign('group', $group);
|
View::assign('id', $id);
|
return view();
|
}
|
}
|
|
}
|