- vForce2018-03-27高级会员121001
- 本帖最后由 vForce 于 2018-3-28 08:32 编辑 *
自己写的,用了挺久了。有个东二的新区没做进去,有点代码基础的朋友自己加一下吧。
两个文件放在同一目录,执行php billingReport.php即可,基于PHP5.6开发,PHP7没试过。
util.php:- ',
- 'RCPT TO: ',
- 'DATA', implode("\r\n", $data)
- ) as $i) {
- fwrite($s, "$i\r\n");
- $m = fgets($s);
- if ($m[0] > 3) return $m;
- }
- fclose($s);
- }复制代码
billingReport.php:
- [
- "henry" => [
- "Billing" => 0,
- "Transfer" => 0,
- ],
- "pascal" => [
- "Billing" => 0,
- "Transfer" => 0,
- ],
- "joule" => [
- "Billing" => 0,
- "Transfer" => 0,
- ],
- ],
- "jp-east-2" => [
- "weber" => [
- "Billing" => 0,
- "Transfer" => 0,
- ],
- "lux" => [
- "Billing" => 0,
- "Transfer" => 0,
- ],
- ],
- "jp-west" => [
- "augusta" => [
- "Billing" => 0,
- "Transfer" => 0,
- ],
- "monstera" => [
- "Billing" => 0,
- "Transfer" => 0,
- ],
- ]
- ];
- foreach ($result['data'] as $row) {
- switch ($row['Category']) {
- case "VirtualMachine":
- case "Volume":
- $regionStatistics[$row['Region']][$row['ZoneName']]['Billing'] += $row['Net'];
- break;
- case "Internet Data Transfer":
- if ($row['Menu'] == "Internet Data Transfer ") {
- $regionStatistics[$row['Region']][$row['ZoneName']]['Transfer'] += $row['Usage'];
- }
- }
- }
- $mailBody = "
- - - - - - - - **
- - - - - {$month} IDCF消费日报
- - - 总消费额:{$totalConsumption}日元(约{$totalConsumptionRMB}人民币)
- 以下为各区消费情况
- - -
- 大区Zone消费额流出流量
- ";
- foreach ($regionStatistics as $regionName => $data) {
- foreach ($data as $zone => $detail) {
- $mailBody .= "{$regionName}$zone{$detail['Billing']}日元{$detail['Transfer']}GB";
- }
- }
- $mailBody .= "
- - - - - **
- ";
- sendMail("收件邮箱", "【IDCF】消费日报", $mailBody);复制代码