sendJobStatusSql.php
1.1 KB
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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
<?php
namespace Model;
/**
* 邮件发送任务状态
* @author：dc
* @time 2023/4/10 16:27
* Class sendJobStatusSql
* @package Model
*/
class sendJobStatusSql {
/**
* 表
* @var string
*/
public static $table = 'send_job_status';
/**
* 统计
* @param int $job_id
* @param string $to
* @return string
* @author：dc
* @time 2023/4/11 16:13
*/
public static function count(int $job_id, string $to=''):string {
return "select count(*) from `".self::$table."` where `job_id` = {$job_id} ".($to ? "and `to_email` = '{$to}'" : '');
}
/**
* @param int $job_id
* @return string
* @author：dc
* @time 2023/4/17 17:25
*/
public static function countSum(int $job_id){
$sucees = "(select count(*) from `".self::$table."` where `job_id` = {$job_id} and `status` = 1) as s";
$error = "(select count(*) from `".self::$table."` where `job_id` = {$job_id} and `status` = 0) as e";
return "select count(*) as t,{$sucees},{$error} from `".self::$table."` where `job_id` = {$job_id} ";
}
}