123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104 |
- <?php
- namespace app\admin\controller\security;
- use Throwable;
- use think\facade\Db;
- use app\common\controller\Backend;
- use app\admin\model\DataRecycleLog as DataRecycleLogModel;
- class DataRecycleLog extends Backend
- {
- /**
- * @var object
- * @phpstan-var DataRecycleLogModel
- */
- protected object $model;
- // 排除字段
- protected string|array $preExcludeFields = [];
- protected string|array $quickSearchField = 'recycle.name';
- protected array $withJoinTable = ['recycle', 'admin'];
- public function initialize(): void
- {
- parent::initialize();
- $this->model = new DataRecycleLogModel();
- }
- /**
- * 还原
- * @param array|null $ids
- * @throws Throwable
- */
- public function restore(array $ids = null): void
- {
- $data = $this->model->where('id', 'in', $ids)->select();
- if (!$data) {
- $this->error(__('Record not found'));
- }
- $count = 0;
- $this->model->startTrans();
- try {
- foreach ($data as $row) {
- $recycleData = json_decode($row['data'], true);
- if (is_array($recycleData) && Db::name($row->data_table)->insert($recycleData)) {
- $row->delete();
- $count++;
- }
- }
- $this->model->commit();
- } catch (Throwable $e) {
- $this->model->rollback();
- $this->error($e->getMessage());
- }
- if ($count) {
- $this->success();
- } else {
- $this->error(__('No rows were restore'));
- }
- }
- /**
- * 详情
- * @param string|int|null $id
- * @throws Throwable
- */
- public function info(string|int $id = null): void
- {
- $row = $this->model
- ->withJoin($this->withJoinTable, $this->withJoinType)
- ->where('data_recycle_log.id', $id)
- ->find();
- if (!$row) {
- $this->error(__('Record not found'));
- }
- $data = $this->jsonToArray($row['data']);
- if (is_array($data)) {
- foreach ($data as $key => $item) {
- $data[$key] = $this->jsonToArray($item);
- }
- }
- $row['data'] = $data;
- $this->success('', [
- 'row' => $row
- ]);
- }
- protected function jsonToArray($value = '')
- {
- if (!is_string($value)) {
- return $value;
- }
- $data = json_decode($value, true);
- if (($data && is_object($data)) || (is_array($data) && !empty($data))) {
- return $data;
- }
- return $value;
- }
- }
|