接口名称tt.oapi.workstation.list.data.query.get接口说明查询工作站资料程序代号soap_oapi00053输入参数说明参数代号型态是否必填参数说明范例值requestkeystring是检核编码(MD5)109c3c41a1441e702b909ed3de58e4b1typestring是Request类型(sync,async)固定传入synchostprodstring是发起方産品名称OAPIverstring是发起方産品版本1.0ipstring是发起方IP位置10.40.71.91idstring否发起方産品识别码，提供同一産品多台主机辨别之用acctstring是登入帐号固定传入tiptoptimestampstring是时间戳记格式：yyyyMMddHHmmssSSS20151211123204361timezonestring否发起方时区(-12~+14)+8langstring是语言别(zh_TW,zh_CN,en,vi)zh_CNserviceprodstring是接收方産品名称TIPTOPnamestring是服务名称tt.oapi.workstation.list.data.query.getsrvverstring否接收方産品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方産品识别码，提供同一産品多台主机辨别之用topproddatakeyEntIdstring否企业编号CompanyIdstring否营运据点DS1workstation_nostring是工作站/工作中心编号000002参数代号型态是否必填参数说明范例值ERP栏位enterprise_nostring是企业编号不使用site_nostring是营运中心不使用is_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间格式：yyyyMMddHHmmssSSS20221001080300000ecadatekey_conditionstring否前次最后一笔资料的Key条件use_has_nextboolean是是否启用分页机制true：启用分页false：不启用分页truepage_sizenumeric是每页条数/分包的请求笔数3使用说明：当启用分页机制时，代表每页条数。取值范围：大于零的整数，默认值50；最大值500。当不启用分页机制时，代表分包的请求笔数，如果值为NULL或０，则不做分包机制page_nonumeric否页码3workstation_nostring是工作站/工作中心编号支持模糊查询(输入不完整编号可查)ETL003eca01workstation_namestring是工作站/工作中心名称支持模糊查询(输入不完整编号可查)ETL003工作站eca02department_nostring是部门编号JN1101eca03date_sstring否开始日期格式：yyyyMMdd20221010ecadatedate_estring否结束日期格式：yyyyMMdd20221010ecadateconditions—否条件集合(单头节点，支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))(field_namestring否栏位名称ecadatevaluestring否栏位值20230601operatorstring否操作符>、>=、=、<、<=、like、in、<>>logicalstring否搜寻组间的关系AND、ORANDorders—否排序设置(单头节点，支持多数组)field_namestring否栏位名称eca01order_typestring否排序类型asc：升序desc：降幂ascRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:7bdc21c26115f28009a8ec12b3861911digi-host:{"prod":"Athena","ip":"10.20.88.30","lang":"zh_TW","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"tt","name":"tt.oapi.workstation.list.data.query.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"99","CompanyId":"DSCNJ"}{"std_data":{"parameter":{"enterprise_no":"99","site_no":"DSCNJ","is_digiwin_product":"Y","key_condition":"","use_has_next":"Y","page_size":"5","page_no":"1","workstation_no":"工作站/工作中心编号","workstation_name":"工作站/工作中心名称","department_no":"部门编号","date_s":"开始日期","date_e":"结束日期","conditions":[{"sequence":"栏位名称","bracket":"括号类型","field_name":"栏位名称","value":"栏位值","operator":"操作符","logical":"搜寻组间的关系"}],"orders":[{"field_name":"栏位名称","order_type":"排序类型"}]}}}成功返回参数说明参数代号型态是否必填参数说明范例值ERP栏位srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，幷産生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果000datakeyworkstation_nostring否工作站编号参数代号型态是否参数说明范例值ERP栏位必填statuscodestring是错误码0：正确<>0：FAIL（原因代码）0sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述data_timedate是异动时间格式：yyyyMMddHHmmssSSS20230223ecadatekey_conditionstring是前次最后一笔资料的Key条件total_resultsnumeric否总数100has_nextboolean否是否有下一页true.是false.否trueworkstation—是工作站(单头节点，支持多数组)workstation_nostring是工作站编号ETL003eca01workstation_namestring否工作站名称ETL003工作站eca02production_capacity_typestring否产能型态1:机器产能2:人工产能1eca06work_calendar_nostring否工作历编号CA01eca55department_nostring否部门编号JN1101eca03machine_daily_total_capacity_hoursnumeric否每日机器总産能小时8.000eca50labor_daily_total_capacity_hoursnumeric否每日人工总産能小时8.000eca52workstation_adjust_efficiencynumeric否工作站效率调整8.000eca12labor_daily_capacitynumeric否每日人工産能不使用machine_daily_capacitynumeric否每日机器産能不使用labor_standard_efficiencynumeric否标准人工效率不使用machine_standard_capacity_loadnumeric否标准机器负荷不使用labor_standard_costnumeric否标准人工成本不使用standard_manufacturing_overhead_costnumeric否标准制造费用不使用statusstring是状态码Y：审核/有效YecaactiN：未审核/无效modify_nostring否资料修改者00000ecamoducreate_datedate否资料创建日格式：yyyy-mm-dd2023-06-28ecadateResponse范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-srvver:1.0digi-srvcode:000digi-datakey:{"workstation_no":"工作站编号"}{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"存在下一页","workstation_attr":{"cnt":"当前回传资料笔数","tt_cnt":"应回传的资料总笔数"},"workstation":[{"workstation_no":"工作站编号","workstation_name":"工作站名称","production_capacity_type":"产能型态","work_calendar_no":"工作历编号","department_no":"部门编号","machine_daily_total_capacity_hours":"每日机器总产能小时","labor_daily_total_capacity_hours":"每日人工总产能小时","workstation_adjust_efficiency":"工作站效率调整","labor_daily_capacity":"每日人工产能","machine_daily_capacity":"每日机器产能","labor_standard_efficiency":"标准人工效率","machine_standard_capacity_load":"标准机器负荷","labor_standard_cost":"标准人工成本","standard_manufacturing_overhead_cost":"标准制造费用","status":"状态码","modify_no":"资料修改者","create_date":"资料创建日"}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP栏位srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，幷産生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果100参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0：正确<>0：FAIL（原因代码）aws1046sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述is_digiwin_product:参数值请输入Y或NResponse范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
