审查视图

controller/Job.php 2.4 KB
x  
邓超 authored
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
<?php

namespace Controller;

use Lib\Mail\Mail;
use Model\emailSql;
use Model\sendJobsSql;


/**
 * 邮件发送任务
 * @author:dc
 * @time 2023/4/17 15:56
 * Class Job
 * @package Controller
 */
class Job extends Base {


    /**
     * 任务列表
     * @author:dc
     * @time 2023/4/17 15:57
     */
    public function index(){
x  
邓超 authored
27 28 29 30
        $page = app()->request('page',1,'intval');
        $limit = app()->request('limit',20,'intval');

        $where = dbWhere([
x  
邓超 authored
31
            'email_id'  =>  $this->getEmails('id')
x  
邓超 authored
32 33 34 35
        ]);

        $lists = db()->all(sendJobsSql::all($where,$page,$limit));
x  
邓超 authored
36
        foreach ($lists as &$list){
x  
邓超 authored
37
            $list['created_at'] = date('Y-m-d H:i:s',$list['send_time']);
x  
邓超 authored
38 39 40

            // 检查状态
            if($list['status'] === 1){
邓超 authored
41
                $total = db()->first(\Model\sendJobStatusSql::countSum($list['id']));
x  
邓超 authored
42 43 44 45 46 47 48 49 50 51 52 53 54 55
                if($total && $total['t'] == $list['total']){
                    // 更新状态
                    db()->update(\Model\sendJobsSql::$table,[
                        'status'    =>  2,
                        'success'   =>  $total['s'],
                        'error'   =>  $total['e'],
                    ],dbWhere(['id'=>$list['id']]));
                    $list['status'] = 2;
                    $list['error'] = $total['e'];
                    $list['success'] = $total['s'];
                }

            }
x  
邓超 authored
56
        }
x  
邓超 authored
57
x  
邓超 authored
58 59 60
        return listsPage($lists,
            db()->count(sendJobsSql::count($where))
            ,1,20);
x  
邓超 authored
61 62 63
    }

x  
邓超 authored
64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102
    public function stop(){
        $id = app()->request('id',0,'intval');

        $ret = db()->update(sendJobsSql::$table,[
            'status'    =>  3
        ],dbWhere([
            'id'    =>  $id,
            'email_id'  =>  $this->getEmails('id')
        ]));

        if($ret){
            return ['status'=>200];
        }

        app()->e('send_job_stop_error');
    }

    /**
     * @throws \Lib\Err
     * @author:dc
     * @time 2023/4/17 17:03
     */
    public function start(){
        $id = app()->request('id',0,'intval');

        $ret = db()->update(sendJobsSql::$table,[
            'status'    =>  0
        ],dbWhere([
            'id'    =>  $id,
            'email_id'  =>  $this->getEmails('id')
        ]));

        if($ret){
            return ['status'=>200];
        }

        app()->e('send_job_start_error');

    }
x  
邓超 authored
103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122





}