|
|
<?php
|
|
|
|
|
|
namespace App\Controllers\Admin;
|
|
|
|
|
|
use App\Models\Ticket;
|
|
|
use App\Models\User;
|
|
|
|
|
|
use Exception;
|
|
|
use voku\helper\AntiXSS;
|
|
|
use App\Services\Auth;
|
|
|
|
|
|
use App\Services\Mail;
|
|
|
use App\Services\Config;
|
|
|
|
|
|
use Ozdemir\Datatables\Datatables;
|
|
|
use App\Utils\DatatablesHelper;
|
|
|
|
|
|
use App\Controllers\AdminController;
|
|
|
|
|
|
use App\Utils\Telegram;
|
|
|
|
|
|
use TelegramBot\Api\BotApi;
|
|
|
|
|
|
class TicketController extends AdminController
|
|
|
{
|
|
|
public function index($request, $response, $args)
|
|
|
{
|
|
|
$table_config['total_column'] = array('op' => '操作', 'id' => 'ID',
|
|
|
'datetime' => '时间', 'title' => '标题', 'userid' => '用户ID',
|
|
|
'user_name' => '用户名', 'status' => '状态');
|
|
|
$table_config['default_show_column'] = array('op', 'id',
|
|
|
'datetime', 'title', 'userid', 'user_name', 'status');
|
|
|
$table_config['ajax_url'] = 'ticket/ajax';
|
|
|
return $this->view()->assign('table_config', $table_config)->display('admin/ticket/index.tpl');
|
|
|
}
|
|
|
|
|
|
|
|
|
public function update($request, $response, $args)
|
|
|
{
|
|
|
$id = $args['id'];
|
|
|
$content = $request->getParam('content');
|
|
|
$status = $request->getParam('status');
|
|
|
|
|
|
|
|
|
if ($content == '' || $status == '') {
|
|
|
$res['ret'] = 0;
|
|
|
$res['msg'] = '请填全';
|
|
|
return $this->echoJson($response, $res);
|
|
|
}
|
|
|
|
|
|
if (strpos($content, 'admin') != false || strpos($content, 'user') != false) {
|
|
|
$res['ret'] = 0;
|
|
|
$res['msg'] = '请求中有不正当的词语。';
|
|
|
return $this->echoJson($response, $res);
|
|
|
}
|
|
|
|
|
|
|
|
|
$ticket_main = Ticket::where('id', '=', $id)->where('rootid', '=', 0)->first();
|
|
|
$user = User::where('id','=', $ticket_main->userid)->first();
|
|
|
$ticket_url = Config::get('baseUrl') . '/user/ticket/' . $ticket_main->id . '/view';
|
|
|
|
|
|
$subject = '您提出的工单已被回复';
|
|
|
$to = $user->email;
|
|
|
$text = '管理员已回复您提出的工单';
|
|
|
try {
|
|
|
Mail::send($to, $subject, 'ticket/ticket_reply.tpl', [
|
|
|
'user' => $user, 'text' => $text, 'content' => $content, 'title' => $ticket_main->title, 'ticket_url' => $ticket_url
|
|
|
], [
|
|
|
]);
|
|
|
} catch (Exception $e) {
|
|
|
}
|
|
|
|
|
|
if (Config::get('enable_telegram') == 'true' && $user->telegram_id != null) {
|
|
|
$messageText = 'Hi,'.$user->user_name.PHP_EOL.'管理员已回复您提出的工单'.PHP_EOL.PHP_EOL.'工单标题: '.$ticket_main->title.PHP_EOL.'回复内容: '.$content;
|
|
|
$keyboard = new \TelegramBot\Api\Types\Inline\InlineKeyboardMarkup(
|
|
|
[
|
|
|
[
|
|
|
['text' => '回复工单', 'url' => $ticket_url]
|
|
|
]
|
|
|
]
|
|
|
);
|
|
|
$bot = new BotApi(Config::get('telegram_token'));
|
|
|
try {
|
|
|
$bot->sendMessage($user->telegram_id, $messageText, null, null, null, $keyboard);
|
|
|
} catch (Exception $e) {
|
|
|
|
|
|
}
|
|
|
}
|
|
|
|
|
|
$antiXss = new AntiXSS();
|
|
|
|
|
|
$ticket = new Ticket();
|
|
|
$ticket->title = $antiXss->xss_clean($ticket_main->title);
|
|
|
$ticket->content = $antiXss->xss_clean($content);
|
|
|
$ticket->rootid = $ticket_main->id;
|
|
|
$ticket->userid = Auth::getUser()->id;
|
|
|
$ticket->datetime = time();
|
|
|
$ticket_main->status = $status;
|
|
|
|
|
|
$ticket_main->save();
|
|
|
$ticket->save();
|
|
|
|
|
|
$res['ret'] = 1;
|
|
|
$res['msg'] = '提交成功';
|
|
|
return $this->echoJson($response, $res);
|
|
|
}
|
|
|
|
|
|
public function show($request, $response, $args)
|
|
|
{
|
|
|
$id = $args['id'];
|
|
|
|
|
|
$pageNum = $request->getQueryParams()['page'] ?? 1;
|
|
|
|
|
|
|
|
|
$ticketset = Ticket::where('id', $id)->orWhere('rootid', '=', $id)->orderBy('datetime', 'desc')->paginate(5, ['*'], 'page', $pageNum);
|
|
|
$ticketset->setPath('/admin/ticket/' . $id . '/view');
|
|
|
|
|
|
return $this->view()->assign('ticketset', $ticketset)->assign('id', $id)->display('admin/ticket/view.tpl');
|
|
|
}
|
|
|
|
|
|
public function ajax($request, $response, $args)
|
|
|
{
|
|
|
$datatables = new Datatables(new DatatablesHelper());
|
|
|
$datatables->query('Select ticket.id as op,ticket.id,ticket.datetime,ticket.title,ticket.userid,user.user_name,ticket.status from ticket,user where ticket.userid = user.id and ticket.rootid = 0');
|
|
|
|
|
|
$datatables->edit('op', static function ($data) {
|
|
|
return '<a class="btn btn-brand" href="/admin/ticket/' . $data['id'] . '/view">查看</a>';
|
|
|
});
|
|
|
|
|
|
$datatables->edit('datetime', static function ($data) {
|
|
|
return date('Y-m-d H:i:s', $data['datetime']);
|
|
|
});
|
|
|
|
|
|
$datatables->edit('status', static function ($data) {
|
|
|
return $data['status'] == 1 ? '开启' : '关闭';
|
|
|
});
|
|
|
|
|
|
$body = $response->getBody();
|
|
|
$body->write($datatables->generate());
|
|
|
}
|
|
|
}
|