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

<?php

namespace app\admin\controller;

use app\common\controller\Backend;
use think\Db;

/**
 * 外发采购 — 历史存证档案查询（已完结工序 + 操作记录详情）
 *
 * @icon fa fa-archive
 */
class Procuremenarchive extends Backend
{
    protected $searchFields = 'CCYDH,CYJMC,CGYMC';

    /** purchase_order.status 为已完结（兼容 varchar / 数字 / 首尾空格） */
    protected function applyPurchaseOrderCompletedWhere($query): void
    {
        $query->whereRaw(
            "(TRIM(CAST(`status` AS CHAR)) = '1' OR CAST(`status` AS UNSIGNED) = 1)"
        );
    }

    public function index()
    {
        $this->relationSearch = false;
        $this->request->filter(['strip_tags', 'trim']);
        if ($this->request->isAjax()) {
            list(, $sort, $order, $offset, $limit) = $this->buildparams();
            $ccydhKw = trim((string)$this->request->get('ccydh', ''));
            if ($ccydhKw === '') {
                $ccydhKw = trim((string)$this->request->get('search', ''));
            }

            $applyFilters = function ($query) use ($ccydhKw) {
                $this->applyPurchaseOrderCompletedWhere($query);
                if ($ccydhKw !== '') {
                    $query->where(function ($q) use ($ccydhKw) {
                        $q->where('CCYDH', 'like', '%' . $ccydhKw . '%')
                            ->whereOr('CYJMC', 'like', '%' . $ccydhKw . '%')
                            ->whereOr('CGYMC', 'like', '%' . $ccydhKw . '%');
                    });
                }
            };

            $countQuery = Db::table('purchase_order');
            $applyFilters($countQuery);
            $total = (int)$countQuery->count();

            $sortField = preg_match('/^[a-zA-Z0-9_]+$/', (string)$sort) ? $sort : 'id';
            $orderDir = strtoupper((string)$order) === 'ASC' ? 'ASC' : 'DESC';
            $listQuery = Db::table('purchase_order');
            $applyFilters($listQuery);
            $rows = $listQuery
                ->field('id,scydgy_id,CCYDH,CYJMC,CGYMC,createtime,dStamp')
                ->order($sortField, $orderDir)
                ->limit($offset, $limit)
                ->select();
            if (!is_array($rows)) {
                $rows = [];
            }

            $out = [];
            foreach ($rows as $r) {
                if (!is_array($r)) {
                    continue;
                }
                $sid = (int)($r['scydgy_id'] ?? 0);
                $doneText = '';
                $ct = $r['createtime'] ?? null;
                if (is_numeric($ct) && (int)$ct > 946684800) {
                    $doneText = date('Y-m-d H:i:s', (int)$ct);
                } elseif (is_string($ct) && trim($ct) !== '' && stripos(trim($ct), '0000-00-00') !== 0) {
                    $doneText = trim($ct);
                } elseif (!empty($r['dStamp']) && stripos((string)$r['dStamp'], '0000-00-00') !== 0) {
                    $doneText = trim((string)$r['dStamp']);
                }
                $out[] = [
                    'id'              => (int)($r['id'] ?? 0),
                    'scydgy_id'       => $sid,
                    'CCYDH'           => trim((string)($r['CCYDH'] ?? '')),
                    'CYJMC'           => trim((string)($r['CYJMC'] ?? '')),
                    'CGYMC'           => trim((string)($r['CGYMC'] ?? '')),
                    'createtime_text' => $doneText,
                ];
            }

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

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