xh-erp.7in6.com/application/admin/controller/Supplierservicescore.php

<?php

namespace app\admin\controller;

use app\common\controller\Backend;
use app\common\library\ProcuremenSupplierScore;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Style\Alignment;
use PhpOffice\PhpSpreadsheet\Style\Border;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

/**
 * 供应商评审表（月度记录：商务/技术得分 / 价格得分 / 交货得分 / 最终得分，不参与其它业务计算）
 *
 * @icon fa fa-trophy
 */
class Supplierservicescore extends Backend
{
    /** @var \app\admin\model\Supplierservicescore */
    protected $model = null;

    protected $searchFields = 'company_name';

    /** 有列表权限即可导出/批量保存最终得分 */
    protected $noNeedRight = ['export', 'savefinalbatch'];

    public function _initialize()
    {
        parent::_initialize();
        ProcuremenSupplierScore::ensureSchema();
        $this->model = new \app\admin\model\Supplierservicescore;
    }

    public function index()
    {
        $this->request->filter(['strip_tags', 'trim']);
        if ($this->request->isAjax()) {
            $ym = $this->resolveRequestYm();
            $keyword = $this->resolveSearchKeyword();
            $offset = max(0, (int)$this->request->get('offset', 0));
            $limit = (int)$this->request->get('limit', 50);
            if ($limit <= 0) {
                $limit = 50;
            }

            $list = $this->loadMonthlySupplierScoreList($ym, $keyword);
            $total = count($list);
            $pageRows = array_slice($list, $offset, $limit);
            $seqBase = $offset;
            $rows = [];
            foreach ($pageRows as $i => $item) {
                $rows[] = [
                    'id'                   => $seqBase + $i + 1,
                    'seq_no'               => $seqBase + $i + 1,
                    'company_name'         => (string)($item['company_name'] ?? ''),
                    'quality_score'        => $item['quality_score'] ?? null,
                    'quality_score_text'   => (string)($item['quality_score_text'] ?? ''),
                    'price_score'          => $item['price_score'] ?? null,
                    'price_score_text'     => (string)($item['price_score_text'] ?? ''),
                    'delivery_score'       => $item['delivery_score'] ?? null,
                    'delivery_score_text'  => (string)($item['delivery_score_text'] ?? ''),
                    'final_score'          => $item['final_score'] ?? null,
                    'final_score_text'     => (string)($item['final_score_text'] ?? ''),
                    'final_score_saved'    => !empty($item['final_score_saved']) ? 1 : 0,
                    'score_grade'          => (string)($item['score_grade'] ?? ''),
                    'ym'                   => $ym,
                ];
            }

            return json(['total' => $total, 'rows' => $rows]);
        }

        return $this->view->fetch();
    }

    /**
     * 批量保存当月最终得分与评分等级
     * POST: ym, rows=[{company_name, final_score, score_grade}, ...] 或 rows_json
     */
    public function savefinalbatch()
    {
        if (!$this->auth->check('supplierservicescore/index') && !$this->auth->isSuperAdmin()) {
            $this->error(__('You have no permission'));
        }
        ProcuremenSupplierScore::ensureFinalScoreTable();
        $ym = trim((string)$this->request->post('ym', ''));
        if ($ym === '') {
            $ym = trim((string)$this->request->param('ym', ''));
        }
        if (!preg_match('/^\d{4}-\d{2}$/', $ym)) {
            $this->error('请选择查询月份');
        }
        $rows = $this->request->post('rows/a', []);
        if (!is_array($rows) || $rows === []) {
            $rowsJson = trim((string)$this->request->post('rows_json', ''));
            if ($rowsJson !== '') {
                $decoded = json_decode($rowsJson, true);
                if (is_array($decoded)) {
                    $rows = $decoded;
                }
            }
        }
        if (!is_array($rows) || $rows === []) {
            $this->error('没有可保存的数据');
        }
        $ret = ProcuremenSupplierScore::saveFinalScoresForYm($ym, $rows);
        $done = (int)($ret['done'] ?? 0);
        if ($done < 1) {
            $err = trim((string)($ret['error'] ?? ''));
            $this->error($err !== '' ? $err : '保存失败，请检查填写的分数');
        }
        $this->success('操作成功');
    }

    /**
     * 导出供应商评审表
     * 列：序号、供应商名称、商务/技术得分、价格得分、交货得分、最终得分、评分等级
     */
    public function export()
    {
        if (!$this->auth->check('supplierservicescore/index') && !$this->auth->isSuperAdmin()) {
            $this->error(__('You have no permission'));
        }
        $ym = trim((string)$this->request->param('ym', ''));
        if (!preg_match('/^(\d{4})-(\d{2})$/', $ym, $m)) {
            $this->error('请选择查询月份');
        }
        $year = (int)$m[1];
        $month = (int)$m[2];
        if ($month < 1 || $month > 12) {
            $this->error('查询月份无效');
        }

        $list = $this->loadMonthlySupplierScoreList($ym, '');

        $title = $year . '年' . $month . '月外协加工供应商评审表';
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        $sheet->setTitle('供应商评审表');

        $fontName = '宋体';
        $borderStyle = [
            'borders' => [
                'allBorders' => [
                    'borderStyle' => Border::BORDER_THIN,
                    'color'       => ['rgb' => '000000'],
                ],
            ],
        ];
        $centerAlign = [
            'horizontal' => Alignment::HORIZONTAL_CENTER,
            'vertical'   => Alignment::VERTICAL_CENTER,
            'wrapText'   => true,
        ];

        $sheet->mergeCells('A1:G1');
        $sheet->setCellValue('A1', $title);
        $sheet->getRowDimension(1)->setRowHeight(36);
        $sheet->getStyle('A1')->getFont()->setName($fontName)->setBold(true)->setSize(20);
        $sheet->getStyle('A1')->getAlignment()->applyFromArray($centerAlign);

        $sheet->setCellValue('A2', '序号');
        $sheet->setCellValue('B2', '供应商名称');
        $sheet->setCellValue('C2', '商务/技术得分');
        $sheet->setCellValue('D2', '价格得分');
        $sheet->setCellValue('E2', '交货得分');
        $sheet->setCellValue('F2', '最终得分');
        $sheet->setCellValue('G2', '评分等级');
        $sheet->getRowDimension(2)->setRowHeight(26);
        $sheet->getStyle('A2:G2')->getFont()->setName($fontName)->setBold(true)->setSize(14);
        $sheet->getStyle('A2:G2')->getAlignment()->applyFromArray($centerAlign);

        $rowNum = 3;
        if ($list === []) {
            $sheet->mergeCells('A3:G3');
            $sheet->setCellValue('A3', '（该月暂无供应商评审记录）');
            $sheet->getRowDimension(3)->setRowHeight(26);
            $sheet->getStyle('A3')->getFont()->setName($fontName)->setSize(12);
            $sheet->getStyle('A3')->getAlignment()->applyFromArray($centerAlign);
            $rowNum = 4;
        } else {
            $i = 1;
            foreach ($list as $item) {
                $finalText = (string)($item['final_score_text'] ?? '');
                $sheet->setCellValue('A' . $rowNum, $i);
                $sheet->setCellValue('B' . $rowNum, (string)($item['company_name'] ?? ''));
                $sheet->setCellValue('C' . $rowNum, (string)($item['quality_score_text'] ?? ''));
                $sheet->setCellValue('D' . $rowNum, (string)($item['price_score_text'] ?? ''));
                $sheet->setCellValue('E' . $rowNum, (string)($item['delivery_score_text'] ?? ''));
                $sheet->setCellValue('F' . $rowNum, $finalText);
                $sheet->setCellValue('G' . $rowNum, (string)($item['score_grade'] ?? ''));
                $sheet->getRowDimension($rowNum)->setRowHeight(24);
                $rowNum++;
                $i++;
            }
        }

        $lastRow = max(2, $rowNum - 1);
        $sheet->getStyle('A1:G' . $lastRow)->applyFromArray($borderStyle);
        $sheet->getStyle('A3:G' . $lastRow)->getFont()->setName($fontName)->setSize(12);
        $sheet->getStyle('A3:G' . $lastRow)->getAlignment()->applyFromArray($centerAlign);
        $sheet->getColumnDimension('A')->setWidth(12);
        $sheet->getColumnDimension('B')->setWidth(48);
        $sheet->getColumnDimension('C')->setWidth(14);
        $sheet->getColumnDimension('D')->setWidth(14);
        $sheet->getColumnDimension('E')->setWidth(12);
        $sheet->getColumnDimension('F')->setWidth(14);
        $sheet->getColumnDimension('G')->setWidth(12);
        $sheet->getPageSetup()->setFitToPage(true)->setFitToWidth(1)->setFitToHeight(0);

        $filename = $title . '.xlsx';
        header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
        header('Content-Disposition: attachment;filename="' . rawurlencode($filename) . '"');
        header('Cache-Control: max-age=0');
        $writer = new Xlsx($spreadsheet);
        $writer->save('php://output');
        $spreadsheet->disconnectWorksheets();
        unset($spreadsheet);
        exit;
    }

    /**
     * 月度评审记录列表（仅展示，最终得分可人工填写）
     *
     * @return array<int, array<string, mixed>>
     */
    protected function loadMonthlySupplierScoreList(string $ym, string $keyword = ''): array
    {
        $ym = trim($ym);
        if (!preg_match('/^\d{4}-\d{2}$/', $ym)) {
            return [];
        }
        ProcuremenSupplierScore::ensureSchema();
        $monthlyMap = ProcuremenSupplierScore::loadMonthlyMapByYm($ym);

        $keyword = trim($keyword);
        $list = [];
        foreach ($monthlyMap as $name => $item) {
            if ($keyword !== '' && mb_stripos($name, $keyword) === false) {
                continue;
            }
            $quality = array_key_exists('quality_score', $item) ? $item['quality_score'] : null;
            $price = array_key_exists('price_score', $item) ? $item['price_score'] : null;
            $delivery = array_key_exists('delivery_score', $item) ? $item['delivery_score'] : null;
            if ($quality !== null) {
                $quality = (float)$quality;
            }
            if ($price !== null) {
                $price = (float)$price;
            }
            if ($delivery !== null) {
                $delivery = (float)$delivery;
            }
            $hasFinal = !empty($item['final_saved']);
            $final = $hasFinal ? (float)($item['final_score'] ?? 0) : null;
            // 列表排序：有最终得分按最终得分，否则按已填分项合计
            $sortScore = $hasFinal
                ? (float)$final
                : (($quality ?? 0) + ($price ?? 0) + ($delivery ?? 0));
            $list[] = [
                'company_name'         => $name,
                'quality_score'        => $quality,
                'quality_score_text'   => ProcuremenSupplierScore::formatOptionalScore($quality),
                'price_score'          => $price,
                'price_score_text'     => ProcuremenSupplierScore::formatOptionalScore($price),
                'delivery_score'       => $delivery,
                'delivery_score_text'  => ProcuremenSupplierScore::formatOptionalScore($delivery),
                'final_score'          => $final,
                'final_score_text'     => $hasFinal ? ProcuremenSupplierScore::formatOptionalScore($final) : '',
                'final_score_saved'    => $hasFinal ? 1 : 0,
                'score_grade'          => ProcuremenSupplierScore::normalizeScoreGrade($item['score_grade'] ?? ''),
                'sort_score'           => $sortScore,
            ];
        }
        usort($list, function ($a, $b) {
            $sa = (float)($a['sort_score'] ?? 0);
            $sb = (float)($b['sort_score'] ?? 0);
            if ($sa !== $sb) {
                return $sb <=> $sa;
            }

            return strcmp((string)($a['company_name'] ?? ''), (string)($b['company_name'] ?? ''));
        });

        return $list;
    }

    protected function resolveRequestYm(): string
    {
        $ym = trim((string)$this->request->get('ym', ''));
        if (preg_match('/^\d{4}-\d{2}$/', $ym)) {
            return $ym;
        }
        $filterRaw = $this->request->get('filter', '');
        if (is_string($filterRaw) && $filterRaw !== '') {
            $filter = json_decode($filterRaw, true);
            if (is_array($filter)) {
                $fy = trim((string)($filter['ym'] ?? ''));
                if (preg_match('/^\d{4}-\d{2}$/', $fy)) {
                    return $fy;
                }
            }
        }
        if (preg_match('/^(\d{4})\D+(\d{1,2})/', $ym, $m)) {
            return sprintf('%04d-%02d', (int)$m[1], (int)$m[2]);
        }

        return date('Y-m');
    }

    protected function resolveSearchKeyword(): string
    {
        $keyword = trim((string)$this->request->get('search', ''));
        if ($keyword !== '') {
            return $keyword;
        }
        $filterRaw = $this->request->get('filter', '');
        if (is_string($filterRaw) && $filterRaw !== '') {
            $filter = json_decode($filterRaw, true);
            if (is_array($filter)) {
                return trim((string)($filter['company_name'] ?? ''));
            }
        }

        return '';
    }
}