// Controllers/OrderDetailsController.cs
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using gdbg.Models; // 引用模型命名空间
using gdbg.Services; // 引用服务命名空间
using Oracle.ManagedDataAccess.Client; // Oracle 参数命名空间

namespace gdbg.Controllers
{
    [ApiController]
    [Route("api/[controller]")]
    public class OrderDetailsController : ControllerBase
    {
        private readonly OracleDbService _oracleDbService;

        public OrderDetailsController(OracleDbService oracleDbService)
        {
            _oracleDbService = oracleDbService;
        }

        [HttpGet]
        public async Task<ActionResult<OrderDetails>> GetOrderDetails([FromQuery] string orderNo)
        {
            if (string.IsNullOrEmpty(orderNo))
            {
                return BadRequest("OrderNo is required.");
            }

            // 使用你提供的 SQL 查询，并新增一个字段 daa002
            var query = @"
               SELECT c.SALE_ORDER_NO, to_char(NVL(a.daa016, SYSDATE), 'YYYY-MM-DD HH24:MI:SS'), a.daa008, a.daa011, a.daa002,s.item_no,nvl(bz.bzsl,0),a.daa018,s.ITEM_NAME,s.ITEM_MODEL,
        case when sj.FSECOND_RESU ='合格' then 1 else case when sj.FSECOND_RESU ='不合格' then 2 else 0 end end sj,
        case when xj.FCHECK_RESU ='合格' then 1 else case when xj.FCHECK_RESU ='不合格' then 2 else 0 end end xj
        FROM womdaa a left join BZFS_WH bz on bz.ITEM_ID=a.daa002
       LEFT JOIN womcaa c ON a.daa014 = c.caa001
       LEFT JOIN mes_items s on s.id=a.daa002
      left join MES_QA_ITEM_IPQC_01 sj on sj.AUFNR=a.DAA001
      left join MES_QA_ITEM_IPQC_02 xj on xj.BILL_NO=a.daa001
  WHERE a.daa001 = :orderNo";

            var parameters = new List<OracleParameter>
            {
                new OracleParameter(":orderNo", orderNo)
            };

            // 使用 OracleDbService 获取数据
            var orderDetailsList = await _oracleDbService.GetAsync(query, reader => new OrderDetails
            {
                RequirementDoc = reader.GetString(0),      // SALE_ORDER_NO 对应需求单据
                ProductionOrder = reader.GetString(1),     // daa021 对应生产订单
                OrderQuantity = reader.GetInt32(2),        // daa008 对应订单数量
                ProducedQuantity = reader.GetInt32(3),     // daa011 对应已生产数
                ItemId = reader.GetString(4)   ,            // 新增字段 item_id 对应 daa002
                ItemNO=reader.GetString(5),
                BZSL= reader.GetString(6), //包装数
                GDZT= reader.GetString(7), //工单状态
                Itemname=reader.GetString(8),
                Itemmodel= reader.GetString(9),
                sj=reader.GetInt32(10),
                xj=reader.GetInt32(11)
            }, parameters);

            if (orderDetailsList.Count == 0)
                return NotFound("Order not found.");

            return Ok(orderDetailsList.First()); // 返回工单详情
        }
    }
}