';
// 전월 매출 및 수금 데이터 가져오기
$previousMonthSalesSql = "
SELECT o.secondordnum, COALESCE(e.ET_total, 0) AS ET_total
FROM output o
LEFT JOIN output_extra e ON o.num = e.parent_num
WHERE (o.outdate BETWEEN date('$previousMonthFromDate') AND date('$previousMonthToDate')) AND (o.is_deleted IS NULL or o.is_deleted = 0)
";
$previousMonthSalesStmt = $pdo->prepare($previousMonthSalesSql);
$previousMonthSalesStmt->execute();
$previousMonthSalesData = $previousMonthSalesStmt->fetchAll(PDO::FETCH_ASSOC);
$previousMonthSales = [];
foreach ($previousMonthSalesData as $row) {
$secondordnum = $row['secondordnum'];
$total_sales_prev = (float)$row['ET_total'];
if (!isset($previousMonthSales[$secondordnum])) {
$previousMonthSales[$secondordnum] = 0;
}
$previousMonthSales[$secondordnum] += round($total_sales_prev, 2); // ET_total은 부가세 포함
}
// 당월 매출 데이터 가져오기
$salesSql = "
SELECT o.secondordnum, COALESCE(e.ET_total, 0) AS ET_total
FROM output o
LEFT JOIN output_extra e ON o.num = e.parent_num
WHERE (o.outdate BETWEEN date('$fromdate') AND date('$todate')) AND (o.is_deleted IS NULL or o.is_deleted = 0)
";
$salesStmt = $pdo->prepare($salesSql);
$salesStmt->execute();
$salesData = $salesStmt->fetchAll(PDO::FETCH_ASSOC);
$currentMonthSales = [];
foreach ($salesData as $row) {
$secondordnum = $row['secondordnum'];
$total_sales = (float)$row['ET_total'];
if (!isset($currentMonthSales[$secondordnum])) {
$currentMonthSales[$secondordnum] = 0;
}
$currentMonthSales[$secondordnum] += round($total_sales, 2);
}
// 전월까지의 매출 및 수금 데이터를 기반으로 이월 잔액을 계산
$initialBalances = [];
$lastMonthEnd = date("Y-m-t", strtotime($fromdate . " -1 month"));
$salesBeforeSql = "
SELECT o.secondordnum, SUM(COALESCE(e.ET_total, 0)) AS total_sales
FROM output o
LEFT JOIN output_extra e ON o.num = e.parent_num
WHERE o.outdate <= :lastMonthEnd AND (o.is_deleted IS NULL or o.is_deleted = 0)
GROUP BY o.secondordnum
";
$paymentBeforeSql = "
SELECT secondordnum, SUM(CAST(REPLACE(amount, ',', '') AS SIGNED)) AS total_payment
FROM account_juil
WHERE registDate <= :lastMonthEnd AND (is_deleted IS NULL or is_deleted = 0) AND content = '거래처 수금'
AND (dueDate = '0000-00-00' OR dueDate IS NULL OR dueDate = '')
GROUP BY secondordnum
";
$salesBeforeStmt = $pdo->prepare($salesBeforeSql);
$salesBeforeStmt->execute([':lastMonthEnd' => $lastMonthEnd]);
$salesBeforeData = $salesBeforeStmt->fetchAll(PDO::FETCH_ASSOC);
// echo '