query(
'select code.number, code.userid, code.usedatetime from code
where TO_DAYS(NOW()) - TO_DAYS(code.usedatetime) = 1 and code.type = -1 and code.isused= 1'
);
$text_json = $datatables->generate();
$text_array = json_decode($text_json, true);
$codes = $text_array['data'];
$text_html = '
| 金额 | 用户ID | 用户名 | 充值时间 | ';
$income_count = 0;
$income_total = 0.00;
foreach ($codes as $code) {
$text_html .= '
';
$text_html .= '| ' . $code['number'] . ' | ';
$text_html .= '' . $code['userid'] . ' | ';
$user = User::find($code['userid']);
$text_html .= '' . $user->user_name . ' | ';
$text_html .= '' . $code['usedatetime'] . ' | ';
$text_html .= '
';
++$income_count;
$income_total += $code['number'];
}
//易付通的单独表
$datatables2 = new Datatables(new DatatablesHelper());
$datatables2->query('select COUNT(*) as "count_yft" from INFORMATION_SCHEMA.TABLES where TABLE_NAME = "yft_order_info"');
$count_yft = $datatables2->generate();
if (strpos($count_yft, '"count_yft":1')) {
$datatables2->query(
'select yft_order_info.price, yft_order_info.user_id, yft_order_info.create_time from yft_order_info
where TO_DAYS(NOW()) - TO_DAYS(yft_order_info.create_time) = 1 and yft_order_info.state= 1'
);
$text_json2 = $datatables2->generate();
$text_array2 = json_decode($text_json2, true);
$codes2 = $text_array2['data'];
foreach ($codes2 as $code2) {
$text_html .= '';
$text_html .= '| ' . $code2['price'] . ' | ';
$text_html .= '' . $code2['user_id'] . ' | ';
$user = User::find($code2['user_id']);
$text_html .= '' . $user->user_name . ' | ';
$text_html .= '' . $code2['create_time'] . ' | ';
$text_html .= '
';
++$income_count;
$income_total += $code['price'];
}
}
$text_html .= '
';
$text_html .= '
昨日总收入笔数:' . $income_count . '
昨日总收入金额:' . $income_total;
$adminUser = User::where('is_admin', '=', '1')->get();
foreach ($adminUser as $user) {
echo 'Send offline mail to user: ' . $user->id;
$subject = Config::get('appName') . '-财务日报';
$to = $user->email;
$title = '财务日报';
$text = $text_html;
try {
Mail::send($to, $subject, 'news/finance.tpl', [
'user' => $user, 'title' => $title, 'text' => $text
], [
]);
} catch (Exception $e) {
echo $e->getMessage();
}
}
if (Config::get('finance_public') == true) {
$sts = new Analytics();
Telegram::Send(
'新鲜出炉的财务日报~' . PHP_EOL .
'昨日总收入笔数:' . $income_count . PHP_EOL .
'昨日总收入金额:' . $income_total . PHP_EOL .
'凌晨也在努力工作~'
);
}
}
public static function sendFinanceMail_week()
{
$datatables = new Datatables(new DatatablesHelper());
$datatables->query(
'SELECT code.number FROM code
WHERE DATEDIFF(NOW(),code.usedatetime) <=7 AND DATEDIFF(NOW(),code.usedatetime) >=1 AND code.isused = 1'
);
//每周的第一天是周日,因此统计周日~周六的七天
$text_json = $datatables->generate();
$text_array = json_decode($text_json, true);
$codes = $text_array['data'];
$text_html = '';
$income_count = 0;
$income_total = 0.00;
foreach ($codes as $code) {
++$income_count;
$income_total += $code['number'];
}
//易付通的单独表
$datatables2 = new Datatables(new DatatablesHelper());
$datatables2->query('select COUNT(*) as "count_yft" from INFORMATION_SCHEMA.TABLES where TABLE_NAME = "yft_order_info"');
$count_yft = $datatables2->generate();
if (strpos($count_yft, '"count_yft":1')) {
$datatables2->query(
'select yft_order_info.price from yft_order_info
where yearweek(date_format(yft_order_info.create_time,\'%Y-%m-%d\')) = yearweek(now())-1 and yft_order_info.state= 1'
);
//每周的第一天是周日,因此统计周日~周六的七天
$text_json2 = $datatables2->generate();
$text_array2 = json_decode($text_json2, true);
$codes2 = $text_array2['data'];
foreach ($codes2 as $code2) {
++$income_count;
$income_total += $code2['price'];
}
}
$text_html .= '
上周总收入笔数:' . $income_count . '
上周总收入金额:' . $income_total;
$adminUser = User::where('is_admin', '=', '1')->get();
foreach ($adminUser as $user) {
echo 'Send offline mail to user: ' . $user->id;
$subject = Config::get('appName') . '-财务周报';
$to = $user->email;
$title = '财务周报';
$text = $text_html;
try {
Mail::send($to, $subject, 'news/finance.tpl', [
'user' => $user, 'title' => $title, 'text' => $text
], [
]);
} catch (Exception $e) {
echo $e->getMessage();
}
}
if (Config::get('finance_public') == true) {
$sts = new Analytics();
Telegram::Send(
'新鲜出炉的财务周报~' . PHP_EOL .
'上周总收入笔数:' . $income_count . PHP_EOL .
'上周总收入金额:' . $income_total . PHP_EOL .
'周末也在努力工作~'
);
}
}
public static function sendFinanceMail_month()
{
$datatables = new Datatables(new DatatablesHelper());
$datatables->query(
'select code.number from code
where date_format(code.usedatetime,\'%Y-%m\')=date_format(date_sub(curdate(), interval 1 month),\'%Y-%m\') and code.type = -1 and code.isused= 1'
);
$text_json = $datatables->generate();
$text_array = json_decode($text_json, true);
$codes = $text_array['data'];
$text_html = '';
$income_count = 0;
$income_total = 0.00;
foreach ($codes as $code) {
++$income_count;
$income_total += $code['number'];
}
$text_html .= '
上月总收入笔数:' . $income_count . '
上月总收入金额:' . $income_total;
$adminUser = User::where('is_admin', '=', '1')->get();
foreach ($adminUser as $user) {
echo 'Send offline mail to user: ' . $user->id;
$subject = Config::get('appName') . '-财务月报';
$to = $user->email;
$title = '财务月报';
$text = $text_html;
try {
Mail::send($to, $subject, 'news/finance.tpl', [
'user' => $user, 'title' => $title, 'text' => $text
], [
]);
} catch (Exception $e) {
echo $e->getMessage();
}
}
if (Config::get('finance_public') == true) {
$sts = new Analytics();
Telegram::Send(
'新鲜出炉的财务月报~' . PHP_EOL .
'上月总收入笔数:' . $income_count . PHP_EOL .
'上月总收入金额:' . $income_total . PHP_EOL .
'月初也在努力工作~'
);
}
}
}