<?php

namespace app\common\library;

/**
 * 协助采购状态文案（purchase_order / purchase_order_detail）
 *
 * purchase_order.status（主单是否完结）：
 *   进行中 — 协助流程未完结（已下发、待确认、待审批等）
 *   已完结 — 采购确认通过，或协助初选直接点「完结」
 *
 * purchase_order.wflow_status（主单流程阶段，与 status 分工不同）：
 *   待下发 — 尚未协助下发，或退回初选后
 *   待确认 — 已通知供应商报价，待采购选定供应商（原 1）
 *   待审批 — 已选定供应商，待采购终审（原 2）
 *   已审核 — 采购终审通过，流程结束（原 3）
 *
 * purchase_order_detail.status（下发明细采购选定）：
 *   未选中 — 默认 / 未中标
 *   已选中 — 采购确认选中的供应商明细（原 1）
 *   已废弃 — 退回初选归档，不参与当前流程（原 2）
 *
 * purchase_order_detail.status_name（供应商填单 / 手机端 Tab，保持原中文）：
 *   未提交 / 已提交 / 已完成 / 未通过 / 已废弃
 */
class ProcuremenStatus
{
    public const PO_IN_PROGRESS = '进行中';
    public const PO_COMPLETED = '已完结';

    public const WFLOW_PENDING_ISSUE = '待下发';
    public const WFLOW_PENDING_CONFIRM = '待确认';
    public const WFLOW_PENDING_APPROVAL = '待审批';
    public const WFLOW_APPROVED = '已审核';

    public const POD_UNPICKED = '未选中';
    public const POD_PICKED = '已选中';
    public const POD_VOID = '已废弃';

    public static function normalizePoStatus($value): string
    {
        $s = trim((string)$value);
        if ($s === '' || $s === '0' || strcasecmp($s, self::PO_IN_PROGRESS) === 0) {
            return self::PO_IN_PROGRESS;
        }
        if ($s === '1' || strcasecmp($s, self::PO_COMPLETED) === 0) {
            return self::PO_COMPLETED;
        }

        return $s;
    }

    public static function isPoCompleted($value): bool
    {
        return self::normalizePoStatus($value) === self::PO_COMPLETED;
    }

    public static function isPoInProgress($value): bool
    {
        return self::normalizePoStatus($value) === self::PO_IN_PROGRESS;
    }

    public static function normalizeWflowStatus($value): string
    {
        $s = trim((string)$value);
        if ($s === '' || $s === '0' || strcasecmp($s, self::WFLOW_PENDING_ISSUE) === 0) {
            return self::WFLOW_PENDING_ISSUE;
        }
        if ($s === '1' || strcasecmp($s, self::WFLOW_PENDING_CONFIRM) === 0) {
            return self::WFLOW_PENDING_CONFIRM;
        }
        if ($s === '2' || strcasecmp($s, self::WFLOW_PENDING_APPROVAL) === 0) {
            return self::WFLOW_PENDING_APPROVAL;
        }
        if ($s === '3' || strcasecmp($s, self::WFLOW_APPROVED) === 0) {
            return self::WFLOW_APPROVED;
        }

        return $s;
    }

    public static function isWflowPendingIssue($value): bool
    {
        return self::normalizeWflowStatus($value) === self::WFLOW_PENDING_ISSUE;
    }

    public static function isWflowPendingConfirm($value): bool
    {
        return self::normalizeWflowStatus($value) === self::WFLOW_PENDING_CONFIRM;
    }

    public static function isWflowPendingApproval($value): bool
    {
        return self::normalizeWflowStatus($value) === self::WFLOW_PENDING_APPROVAL;
    }

    public static function isWflowApproved($value): bool
    {
        return self::normalizeWflowStatus($value) === self::WFLOW_APPROVED;
    }

    public static function wflowAtLeastConfirm($value): bool
    {
        $w = self::normalizeWflowStatus($value);

        return $w === self::WFLOW_PENDING_CONFIRM || $w === self::WFLOW_PENDING_APPROVAL;
    }

    public static function normalizePodPickStatus($value): string
    {
        $s = trim((string)$value);
        if ($s === '' || $s === '0' || strcasecmp($s, self::POD_UNPICKED) === 0) {
            return self::POD_UNPICKED;
        }
        if ($s === '1' || strcasecmp($s, self::POD_PICKED) === 0) {
            return self::POD_PICKED;
        }
        if ($s === '2' || strcasecmp($s, self::POD_VOID) === 0 || strcasecmp($s, '已废弃') === 0) {
            return self::POD_VOID;
        }

        return $s;
    }

    public static function isPodPicked($value): bool
    {
        return self::normalizePodPickStatus($value) === self::POD_PICKED;
    }

    public static function isPodVoid($value): bool
    {
        return self::normalizePodPickStatus($value) === self::POD_VOID;
    }

    /** @return string[] */
    public static function wflowPendingConfirmValues(): array
    {
        return [self::WFLOW_PENDING_CONFIRM, '1'];
    }

    /** @return string[] */
    public static function wflowPendingApprovalValues(): array
    {
        return [self::WFLOW_PENDING_APPROVAL, '2'];
    }

    /** @return string[] */
    public static function wflowApprovedValues(): array
    {
        return [self::WFLOW_APPROVED, '3'];
    }

    /** @return string[] */
    public static function wflowPendingIssueValues(): array
    {
        return [self::WFLOW_PENDING_ISSUE, '0', ''];
    }

    /** @return string[] */
    public static function podPickedValues(): array
    {
        return [self::POD_PICKED, '1'];
    }

    /** @return string[] */
    public static function podUnpickedValues(): array
    {
        return [self::POD_UNPICKED, '0', ''];
    }

    /** @return string[] */
    public static function poCompletedValues(): array
    {
        return [self::PO_COMPLETED, '1'];
    }

    /** @return string[] */
    public static function poInProgressValues(): array
    {
        return [self::PO_IN_PROGRESS, '0'];
    }

    public static function sqlPoCompleted(string $column = 'status'): string
    {
        $c = self::quoteSqlIdent($column);

        return "TRIM(CAST({$c} AS CHAR)) IN ('" . self::PO_COMPLETED . "','1')";
    }

    public static function sqlPoInProgress(string $column = 'status'): string
    {
        $c = self::quoteSqlIdent($column);

        return "TRIM(CAST({$c} AS CHAR)) IN ('" . self::PO_IN_PROGRESS . "','0')";
    }

    public static function sqlPodNotVoid(string $column = 'status'): string
    {
        $c = self::quoteSqlIdent($column);
        $void = self::POD_VOID;

        return "({$c} IS NULL OR TRIM(CAST({$c} AS CHAR)) NOT IN ('{$void}','2') AND CAST({$c} AS UNSIGNED) <> 2)";
    }

    protected static function quoteSqlIdent(string $column): string
    {
        if (strpos($column, '.') !== false) {
            $parts = explode('.', $column, 2);

            return '`' . str_replace('`', '', $parts[0]) . '`.`' . str_replace('`', '', $parts[1]) . '`';
        }

        return '`' . str_replace('`', '', $column) . '`';
    }
}