<?php
require_once '/home/www/GNU/_PAGE/head.php';

$write_table = "g5_write_moving_assets";

$sql = " SELECT * FROM {$write_table} ORDER BY wr_id DESC LIMIT 1 ";
$row = sql_fetch($sql);

$pure_in_fixed   = (float)$row['x2_total_bank_in'];
$pure_out_fixed  = (float)$row['x2_total_bank_out'];
$net_pure_invest = $pure_in_fixed - $pure_out_fixed;

$krw_in          = (float)$row['x2_cum_bank_in'];
$krw_out         = (float)$row['x2_cum_bank_out'];
$krw_total       = $krw_in - $krw_out;

$krw_pure_in     = (float)$row['x2_cum_bank_in_pure'];
$krw_pure_out    = (float)$row['x2_cum_bank_out_pure'];
$krw_pure_net    = $krw_pure_in - $krw_pure_out;

$ex_in           = (float)$row['x2_cum_exchange_in'];
$ex_out          = (float)$row['x2_cum_exchange_out'];
$ex_total        = (float)$row['x2_cum_exchange_total'];

$cum_interest    = (float)$row['x2_cum_interest'];

$wr_datetime     = $row['wr_datetime'];
$wr_id           = $row['wr_id'];
?>

<link rel="stylesheet" href="./investment_movement_map.css">

<div class="atm-wrap">

    <div class="atm-header">
        <h1>입/출금 자산 맵<span>Assets Transaction Map</span></h1>
        <div class="atm-sync">
            마지막 동기화 &nbsp;<strong><?php echo $wr_datetime; ?></strong><br>
            Log ID: <strong>#<?php echo $wr_id; ?></strong>
        </div>
    </div>

    <!-- HERO -->
    <div class="hero-card">
        <div class="hero-left">
            <div class="hero-badge">Net Invested Capital : Total · 전체 투자 원금</div>
            <div class="hero-amount"><label>₩</label><?php echo number_format($net_pure_invest); ?></div>
            <div class="hero-sub">전체 입금 확정 − 전체 출금 확정 = 순수 투자 원금</div>
        </div>
        <div class="hero-right">
            <div class="hero-stat">
                <span class="hero-stat-label">입금 확정</span>
                <span class="hero-stat-val pos">+ <?php echo number_format($pure_in_fixed); ?></span>
            </div>
            <div class="hero-stat">
                <span class="hero-stat-label">출금 확정</span>
                <span class="hero-stat-val neg">− <?php echo number_format($pure_out_fixed); ?></span>
            </div>
        </div>
    </div>

    <!-- 2x2 -->
    <div class="grid-2x2">

        <div class="sub-card card-blue">
            <div class="sub-card-tag tag-blue">KRW Bank Cumulative &middot; 원화 입출금 누적</div>
            <div class="sub-card-amount"><?php echo number_format($krw_total); ?><span>KRW</span></div>
            <div class="sub-stats">
                <div class="sub-stat">
                    <div class="sub-stat-label">원화 입금 누적</div>
                    <div class="sub-stat-val" style="color:#3b82f6;">+ <?php echo number_format($krw_in); ?></div>
                </div>
                <div class="sub-stat">
                    <div class="sub-stat-label">원화 출금 누적</div>
                    <div class="sub-stat-val" style="color:#fb7185;">− <?php echo number_format($krw_out); ?></div>
                </div>
            </div>
        </div>

        <div class="sub-card card-violet">
            <div class="sub-card-tag tag-violet">Pure Bank KRW &middot; 순수 은행 원화 누적</div>
            <div class="sub-card-amount"><?php echo number_format($krw_pure_net); ?><span>KRW</span></div>
            <div class="sub-stats">
                <div class="sub-stat">
                    <div class="sub-stat-label">순수 입금 누적</div>
                    <div class="sub-stat-val" style="color:#a78bfa;">+ <?php echo number_format($krw_pure_in); ?></div>
                </div>
                <div class="sub-stat">
                    <div class="sub-stat-label">순수 출금 누적</div>
                    <div class="sub-stat-val" style="color:#fb7185;">− <?php echo number_format($krw_pure_out); ?></div>
                </div>
            </div>
        </div>

        <div class="sub-card card-amber">
            <div class="sub-card-tag tag-amber">Exchange Cumulative &middot; 거래소 입출금 누적</div>
            <div class="sub-card-amount"><?php echo number_format($ex_total); ?><span>KRW</span></div>
            <div class="sub-stats">
                <div class="sub-stat">
                    <div class="sub-stat-label">거래소 입금 누적</div>
                    <div class="sub-stat-val" style="color:#fbbf24;">+ <?php echo number_format($ex_in); ?></div>
                </div>
                <div class="sub-stat">
                    <div class="sub-stat-label">거래소 출금 누적</div>
                    <div class="sub-stat-val" style="color:#fb7185;">− <?php echo number_format($ex_out); ?></div>
                </div>
            </div>
        </div>

        <div class="sub-card card-cyan">
            <div class="sub-card-tag tag-cyan">Accumulated Interest &middot; 이자 누적</div>
            <div class="sub-card-amount"><?php echo number_format($cum_interest); ?><span>KRW</span></div>
        </div>

    </div>

    <div class="atm-footer">g5_write_moving_assets · total 보정 컬럼 기반 · Ver.Basic</div>

</div>

<?php
require_once '/home/www/GNU/_PAGE/tail.php';
?>