国网上传相关信息

李维强-15级

在线问题提交：
https://docs.qq.com/sheet/DZE9xaktsU0xIVHVB?tab=BB08J2
--------------------------------------------------------------------------------------------------------
24-11-14
平台最近上线了质量评价申请功能，目前更新工单实际完成时间的方式已无法触发二次质量评价，如需更新工单评分可通过质量评价申请功能来实现。
1.申请路径：质量评价-->质量评价申请
2.使用角色：供应商及监理均可发起重新评价申请。
3.列表页空白：质量评价申请提交后，列表页如出现下图数据空白的情况，可点击右上角“列表设置”，将相关字段添加至右侧，保存即可。
4.审批跟进：质量评价申请提交后由采购订单项目单位即省公司质量监督管理员的角色来操作审核，质量评价申请提交未审核的话，供应商或监理老师可联系该订单对应项目单位，来跟进质量评价申请的审核进度。
---------------------------------------------------------------------------------------------------------------------------------------------------------------------

李维强-15级

[SQL] syntaxhighlighter_viewsource syntaxhighlighter_copycode

BEGIN
BEGIN TRY
    DROP TABLE #TempGWSN;
END TRY
BEGIN CATCH
    -- 错误处理逻辑，这里可以不做任何事情，因为表可能不存在
    -- 如果需要，可以通过 ERROR_NUMBER() 和 ERROR_MESSAGE() 获取错误信息
END CATCH

CREATE TABLE #TempGWSN (
    id INT IDENTITY(1,1) PRIMARY KEY,
    gw_sn VARCHAR(255)
);

INSERT INTO #TempGWSN (gw_sn)
VALUES 
('4500872442'),
('4500873315'),
('4500873314'),
('4500873313'),
('4500872020'),
('4500873312'),
('4500873311'),
('4500865013'),
('4500865012'),
('5000002876'),
('4500858867'),
('4500858055'),
('4500856325'),
('4500877783'),
('4500878470'),
('4500878463'),
('5000002996'),
('4500879452');

SELECT b.gw_sn,a.* FROM OPENQUERY(FD_MES_DB,
'
SELECT gw_order_sn,gw_order_sn as "采购订单号",contract_sn as "内部合同号",project_name as "工程名称",
CASE WHEN bidder="1000014692"  THEN "顺泰" when bidder="1000091718"  THEN "瑜煌" END AS "中标主体",
item_id as "订单行项目ID",task_sn as "生产订单",release_sn as "生产工单号",release_date as "下达时间",
delivery_date as "合同交货日期",change_delivery_date as "到货期变更日期",
case when eip_tower_status=1 THEN "已上传" else "未上传" END as "参数-基塔信息",
case when bom_eip_status=0 THEN "已上传" else "未传" END as "参数-技术加工",
case when eip_contract_material_status>0 THEN "已上传" else "未传" END as "原材料",
case when eip_machine_base_release_status=11 THEN "部分关联已上传" when eip_machine_base_release_status=13 THEN "部分关联未上传" when eip_machine_base_release_status=0 then "待维护" END as "生产工单原材料",
case when production_inspection_status=5 THEN "已维护" else "等待维护" END as "生产过程检验",
case when prod_process_status=6 THEN "完整且上传" else "等待维护" END as "生产过程信息采集",
case when temperature_status=1 THEN "已上传" else "等待维护" END as "镀锌温度",
case when product_status=1 THEN "已上传" else "等待维护" END as "成品"
FROM eip_internet_things_warning
') a RIGHT JOIN #TempGWSN b on a.gw_order_sn=b.gw_sn
ORDER BY gw_sn,a.生产工单号
DROP TABLE #TempGWSN;

END