| 거래처코드 |
거래처명 |
누적매출금액 |
0) {
$contractorCode = $row['secondordnum'];
$contractorName = $row['secondord'];
if (!isset($contractorTotals[$contractorCode])) {
$contractorTotals[$contractorCode] = [
'name' => $contractorName,
'total' => 0
];
}
$contractorTotals[$contractorCode]['total'] += $row['ET_total'];
}
}
// 누적 매출액 기준으로 내림차순 정렬
uasort($contractorTotals, function($a, $b) {
return $b['total'] - $a['total'];
});
// 정렬된 결과 출력
foreach ($contractorTotals as $code => $data) {
echo '';
echo '| ' . htmlspecialchars($code) . ' | ';
echo '' . htmlspecialchars($data['name']) . ' | ';
echo '' . number_format($data['total']) . ' | ';
echo '
';
$totalSales += $data['total'];
}
?>
| 합계 |
|
0) {
$contractor = $row['secondord'];
$month = date('Y-m', strtotime($row['outdate']));
if (!isset($contractorChartData[$contractor][$month])) {
$contractorChartData[$contractor][$month] = 0;
}
$contractorChartData[$contractor][$month] += $row['ET_total'];
if (!isset($totalSalesByContractor[$contractor])) {
$totalSalesByContractor[$contractor] = 0;
}
$totalSalesByContractor[$contractor] += $row['ET_total'];
}
}
// 매출액 기준으로 내림차순 정렬
arsort($totalSalesByContractor);
$counter = 1;
?>
$totalSales): ?>
0): ?>
| 월 |
매출금액 |
$total_sales):
$totalSum += $total_sales;
?>
|
￦ |
| 합계 |
￦ |