<?php
error_reporting(E_ALL & ~E_NOTICE);
ob_start();
session_start();
require_once __DIR__ . '/db.php';
require_once __DIR__ . '/escpos.php';
require_once __DIR__ . '/print_helper.php';
ob_clean();
header('Content-Type: application/json; charset=utf-8');

if (!isset($_SESSION['operator'])) {
    echo json_encode(array('ok' => false, 'msg' => '未登录'));
    exit;
}

// 接收查询条件
$startDate  = isset($_POST['start']) ? $_POST['start'] : date('Y-m-d');
$endDate    = isset($_POST['end'])   ? $_POST['end']   : date('Y-m-d');
$opFilter   = isset($_POST['op'])    ? intval($_POST['op'])   : 0;
$dishCat    = isset($_POST['dcat'])  ? intval($_POST['dcat']) : 0;
$dishSearch = isset($_POST['dname']) ? urldecode(trim($_POST['dname'])) : '';

// ★ 餐段多选
$mealFilters = array();
if (isset($_POST['meal'])) {
    if (is_array($_POST['meal'])) {
        foreach ($_POST['meal'] as $m) {
            $m = intval($m);
            if ($m > 0 && !in_array($m, $mealFilters, true)) $mealFilters[] = $m;
        }
    } elseif (intval($_POST['meal']) > 0) {
        $mealFilters[] = intval($_POST['meal']);
    }
}

// ★ 接收前端传来的排序参数
$sortField = isset($_POST['sort']) ? $_POST['sort'] : 'qty';
$sortOrder = (isset($_POST['order']) && strtolower($_POST['order']) === 'asc') ? 'ASC' : 'DESC';

// ★ 商品名称/分类排序：按点餐页的菜单顺序（分类 SortOrder → 菜品 SortOrder → DishID）
$sortMap = array(
    'name'   => "c.SortOrder $sortOrder, d.SortOrder $sortOrder, od.DishID $sortOrder",
    'cat'    => "d.CategoryID $sortOrder, d.SortOrder $sortOrder, od.DishID $sortOrder",
    'qty'    => "TotalQty $sortOrder",
    'price'  => "od.Price $sortOrder",
    'amount' => "TotalAmount $sortOrder",
);
$orderBy = isset($sortMap[$sortField]) ? $sortMap[$sortField] : "TotalQty DESC";

// ========== 辅助函数：按半角宽度补齐空格 ==========
function padRight($str, $width) {
    $w = mb_strwidth($str, 'UTF-8');
    return $str . str_repeat(' ', max(0, $width - $w));
}
function padLeft($str, $width) {
    $w = mb_strwidth($str, 'UTF-8');
    return str_repeat(' ', max(0, $width - $w)) . $str;
}

// ========== 餐段处理 ==========
$mealPeriodsRaw = array();
$mealRanges = array();
try {
    $mealPeriodsRaw = db_all("SELECT * FROM MealPeriod WHERE IsActive = 1 ORDER BY SortOrder, PeriodID");
} catch (Exception $e) {}

$prevEnd = '00:00';
foreach ($mealPeriodsRaw as $mp) {
    $end = $mp['EndTime'];
    $mealRanges[] = array(
        'PeriodID'   => intval($mp['PeriodID']),
        'PeriodName' => $mp['PeriodName'],
        'StartTime'  => $prevEnd . ':00',
        'EndTime'    => ($end === '00:00') ? '23:59:59' : ($end . ':00'),
        'IsLast'     => ($end === '00:00')
    );
    $prevEnd = $end;
}

// ★ 选中餐段集合
$selectedMeals = array();
foreach ($mealRanges as $mr) {
    if (in_array($mr['PeriodID'], $mealFilters, true)) $selectedMeals[] = $mr;
}

// ========== 公共 WHERE 构造函数（餐段多选 OR 组合） ==========
function buildOrderFilters($alias, $startDate, $endDate, $opFilter, $selectedMeals) {
    $prefix = ($alias === '') ? '' : ($alias . '.');
    $where = array();
    $params = array();

    $where[] = $prefix . "PayTime >= ?";
    $params[] = $startDate . ' 00:00:00';
    $where[] = $prefix . "PayTime < ?";
    $params[] = date('Y-m-d', strtotime($endDate . ' +1 day')) . ' 00:00:00';

    if ($opFilter > 0) {
        $where[] = $prefix . "PayOperatorID = ?";
        $params[] = $opFilter;
    }

    if (!empty($selectedMeals)) {
        $mealConds = array();
        foreach ($selectedMeals as $sm) {
            if ($sm['IsLast']) {
                $mealConds[] = "(time(" . $prefix . "PayTime) >= ?)";
                $params[] = $sm['StartTime'];
            } else {
                $mealConds[] = "(time(" . $prefix . "PayTime) >= ? AND time(" . $prefix . "PayTime) < ?)";
                $params[] = $sm['StartTime'];
                $params[] = $sm['EndTime'];
            }
        }
        $where[] = '(' . implode(' OR ', $mealConds) . ')';
    }
    return array($where, $params);
}

// ========== 获取分类条件 ==========
$allCats = db_all("SELECT CategoryID, CategoryName, ParentID FROM Category WHERE IsActive = 1 ORDER BY ParentID, SortOrder");
$bigCats = array();
$subCatsMap = array();
foreach ($allCats as $c) {
    if ($c['ParentID'] == 0) $bigCats[] = $c;
    else {
        if (!isset($subCatsMap[$c['ParentID']])) $subCatsMap[$c['ParentID']] = array();
        $subCatsMap[$c['ParentID']][] = $c;
    }
}

list($dishWhereCommon, $dishParamsCommon) = buildOrderFilters('o', $startDate, $endDate, $opFilter, $selectedMeals);
$dishExtraWhere = array();
$dishParams = $dishParamsCommon;

if ($dishCat > 0) {
    $isBig = false;
    foreach ($bigCats as $b) {
        if ($b['CategoryID'] == $dishCat) { $isBig = true; break; }
    }
    if ($isBig) {
        $subIds = array();
        if (isset($subCatsMap[$dishCat])) {
            foreach ($subCatsMap[$dishCat] as $sub) $subIds[] = $sub['CategoryID'];
        }
        $allIds = array_merge(array($dishCat), $subIds);
        $ph = implode(',', array_fill(0, count($allIds), '?'));
        $dishExtraWhere[] = "d.CategoryID IN ($ph)";
        foreach ($allIds as $id) $dishParams[] = $id;
    } else {
        $dishExtraWhere[] = "d.CategoryID = ?";
        $dishParams[] = $dishCat;
    }
}

if ($dishSearch !== '') {
    $dishExtraWhere[] = "od.DishName LIKE ?";
    $dishParams[] = '%' . $dishSearch . '%';
}

$dishWhereAll = array_merge($dishWhereCommon, $dishExtraWhere);
$dishW = empty($dishWhereAll) ? '' : (' AND ' . implode(' AND ', $dishWhereAll));

// ========== 1. 查询商品明细（按排序） ==========
$dishes = db_all("
    SELECT od.DishName,
           od.DishID,
           d.CategoryID,
           SUM(od.Qty) AS TotalQty,
           od.Price,
           SUM(od.Amount) AS TotalAmount,
           c.CategoryName
    FROM OrderDetail od
    LEFT JOIN OrderMaster o ON od.BillNo = o.BillNo
    LEFT JOIN Dish d ON od.DishID = d.DishID
    LEFT JOIN Category c ON d.CategoryID = c.CategoryID
    WHERE o.OrderStatus = 1 " . $dishW . "
    GROUP BY od.DishName, od.DishID, od.Price, d.CategoryID, c.CategoryName
    ORDER BY " . $orderBy . "
", $dishParams);

// ========== 2. 查询底部分类统计（按分类汇总） ==========
$catStats = db_all("
    SELECT c.CategoryName,
           SUM(od.Qty) AS CatQty,
           SUM(od.Amount) AS CatAmount
    FROM OrderDetail od
    LEFT JOIN OrderMaster o ON od.BillNo = o.BillNo
    LEFT JOIN Dish d ON od.DishID = d.DishID
    LEFT JOIN Category c ON d.CategoryID = c.CategoryID
    WHERE o.OrderStatus = 1 " . $dishW . "
    GROUP BY c.CategoryID, c.CategoryName
    ORDER BY CatAmount DESC
", $dishParams);

// 计算总计
$grandQty = 0;
$grandAmount = 0;
foreach ($catStats as $cs) {
    $grandQty += floatval($cs['CatQty']);
    $grandAmount += floatval($cs['CatAmount']);
}

// ========== 获取文字信息 ==========
$opName = '全部';
if ($opFilter > 0) {
    $oRow = db_one("SELECT OperatorName FROM Operator WHERE OperatorID = ?", array($opFilter));
    if ($oRow) $opName = $oRow['OperatorName'];
}

$mealName = '全部';
if (!empty($selectedMeals)) {
    $names = array();
    foreach ($selectedMeals as $sm) $names[] = $sm['PeriodName'];
    $mealName = implode('、', $names);
}

// 排序文字
$sortName = '按销量';
if ($sortField === 'amount') $sortName = '按金额';
if ($sortField === 'name') $sortName = '按名称';
if ($sortField === 'cat') $sortName = '按分类';
if ($sortField === 'price') $sortName = '按单价';
$sortText = $sortName . ($sortOrder === 'ASC' ? ' (升序)' : ' (降序)');

// ========== 获取打印机 ==========
$printer = db_one("
    SELECT p.PrinterIP
    FROM PrintScheme s
    LEFT JOIN Printer p ON s.PrinterID = p.PrinterID
    WHERE s.IsActive = 1 AND p.IsActive = 1 AND s.SchemeType = 'receipt'
    ORDER BY s.SchemeID LIMIT 1
");
$ip = $printer ? $printer['PrinterIP'] : '';
if ($ip === '') {
    echo json_encode(array('ok' => false, 'msg' => '未配置结账单打印机'));
    exit;
}

$store = db_one("SELECT StoreName FROM Store ORDER BY StoreID LIMIT 1");
$storeName = $store ? $store['StoreName'] : '餐饮管理系统';

// ========== 打印执行 ==========
try {
    EscPos::printJob($ip, function($p) use ($storeName, $startDate, $endDate, $dishes, $catStats, $opName, $mealName, $grandQty, $grandAmount, $sortText) {

        // 抬头
        $p->align('center')->size(1)->bold(true);
        $p->line($storeName);
        $p->size(0)->bold(false);
        $p->line('商品销售汇总表');
        $p->line($startDate . ' 至 ' . $endDate);
        $p->hr('=', 48);

        // 筛选条件
        $p->align('left');
        $p->line('操作员：' . $opName);
        $p->line('餐段：' . $mealName);
        $p->line('排序：' . $sortText);
        $p->hr('-', 48);

        // ================= 定义 48 字符排版的列宽 =================
        // 类别 + 名称 + 数量 + 金额
        $colCatWidth  = 10; // 类别占 10 字符
        $colGap0      = 1;  // 空 1 格
        $colNameWidth = 16; // 商品名占 16 字符
        $colGap1      = 1;  // 空 1 格
        $colQtyWidth  = 8;  // 数量占 8 字符
        $colGap2      = 1;  // 空 1 格
        $colAmtWidth  = 11; // 金额占 11 字符
        // 10 + 1 + 16 + 1 + 8 + 1 + 11 = 48 字符

        // 分类统计左列宽度（类别 + 间隔 + 名称 合并）
        $statNameWidth = $colCatWidth + $colGap0 + $colNameWidth; // 27

        // 打印表头
        $headerCat  = padRight('类别', $colCatWidth);
        $headerName = padRight('商品名称', $colNameWidth);
        $headerQty  = padLeft('数量', $colQtyWidth);
        $headerAmt  = padLeft('金额', $colAmtWidth);
        $p->line(
            $headerCat  . str_repeat(' ', $colGap0) .
            $headerName . str_repeat(' ', $colGap1) .
            $headerQty  . str_repeat(' ', $colGap2) .
            $headerAmt
        );
        $p->hr('-', 48);

        // ========== 打印商品明细 ==========
        if (empty($dishes)) {
            $p->line('暂无商品销售数据');
        } else {
            foreach ($dishes as $item) {
                $name = $item['DishName'];
                $qty  = floatval($item['TotalQty']);
                $amt  = floatval($item['TotalAmount']);

                // 类别名（可能为 NULL）
                $catName = (isset($item['CategoryName']) && $item['CategoryName'] !== null)
                    ? $item['CategoryName']
                    : '';

                // 折行处理（限制对应列宽）
                $catLines  = ($catName === '') ? array('') : wrapName($catName, $colCatWidth);
                $nameLines = wrapName($name, $colNameWidth);

                // 按两列中行数较多者对齐
                $maxLines = max(count($catLines), count($nameLines));
                if ($maxLines < 1) $maxLines = 1;
                $lastIdx = $maxLines - 1;

                // 格式化数量和金额
                $qtyStr = padLeft(number_format($qty, 0), $colQtyWidth);
                $amtStr = padLeft(number_format($amt, 2, '.', ''), $colAmtWidth);

                for ($i = 0; $i < $maxLines; $i++) {
                    $catPart  = padRight(isset($catLines[$i])  ? $catLines[$i]  : '', $colCatWidth);
                    $namePart = padRight(isset($nameLines[$i]) ? $nameLines[$i] : '', $colNameWidth);

                    if ($i < $lastIdx) {
                        // 非最后一行：只输出 类别 + 名称
                        $p->line($catPart . str_repeat(' ', $colGap0) . $namePart);
                    } else {
                        // 最后一行：补齐数量、金额
                        $p->line(
                            $catPart  . str_repeat(' ', $colGap0) .
                            $namePart . str_repeat(' ', $colGap1) .
                            $qtyStr   . str_repeat(' ', $colGap2) .
                            $amtStr
                        );
                    }
                }
            }
        }

        // ========== 底部分类统计 ==========
        if (!empty($catStats)) {
            $p->hr('-', 48);
            $p->size(1)->bold(true);
            $p->line('分类统计');
            $p->size(0)->bold(false);

            foreach ($catStats as $cs) {
                $catName = $cs['CategoryName'] . '：';
                $catQty  = floatval($cs['CatQty']);
                $catAmt  = floatval($cs['CatAmount']);

                // 左侧合并列宽（类别 + 名称）
                $catNameLines = wrapName($catName, $statNameWidth);
                $qtyStr = padLeft(number_format($catQty, 0), $colQtyWidth);
                $amtStr = padLeft(number_format($catAmt, 2, '.', ''), $colAmtWidth);

                $lastIdx = count($catNameLines) - 1;
                foreach ($catNameLines as $idx => $line) {
                    $linePadded = padRight($line, $statNameWidth);
                    if ($idx < $lastIdx) {
                        $p->line($linePadded);
                    } else {
                        $p->line(
                            $linePadded . str_repeat(' ', $colGap1) .
                            $qtyStr     . str_repeat(' ', $colGap2) .
                            $amtStr
                        );
                    }
                }
            }
        }

        // ========== 底部总计 ==========
        $p->hr('-', 48);
        $p->size(1)->bold(true);
        $p->line('总计：' . number_format($grandQty, 0) . ' 份');
        $p->line('总金额：' . number_format($grandAmount, 2));
        $p->size(0)->bold(false);

        // 页脚
        $p->hr('=', 48);
        $p->align('center');
        $p->feed(1);
        $p->line('打印时间：' . date('Y-m-d H:i:s'));
    });

    echo json_encode(array('ok' => true));
} catch (Exception $e) {
    echo json_encode(array('ok' => false, 'msg' => $e->getMessage()));
}