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=''; $income_count=0; $income_total=0.00; foreach($codes as $code){ $text_html.=''; $text_html.=''; $text_html.=''; $user=User::find($code['userid']); $text_html.=''; $text_html.=''; $text_html.=''; $income_count+=1; $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.=''; $text_html.=''; $user=User::find($code2['user_id']); $text_html.=''; $text_html.=''; $text_html.=''; $income_count+=1; $income_total+=$code['price']; } } $text_html.='
金额用户ID用户名充值时间
'.$code['number'].''.$code['userid'].''.$user->user_name.''.$code['usedatetime'].'
'.$code2['price'].''.$code2['user_id'].''.$user->user_name.''.$code2['create_time'].'
'; $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 yearweek(date_format(code.usedatetime,\'%Y-%m-%d\')) = yearweek(now())-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+=1; $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+=1; $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+=1; $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 date_format(yft_order_info.create_time,\'%Y-%m\') =date_format(date_sub(curdate(), interval 1 month),\'%Y-%m\') 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+=1; $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. "月初也在努力工作~" ); } } }