接口名称tt.oapi.wo.work.report.list.data.query.get接口说明查询报工单列表资料程序代号soap_oapi00207输入参数说明参数代号型态是否必填参数说明范例值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.wo.work.report.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topproddatakeyEntIdstring否企业编号CompanyIdstring是营运据点DS1参数代号型态是否必填参数说明范例值ERP栏位enterprise_nostring否企业编号不使用site_nostring是营运据点不使用is_digiwin_productstring否是否为鼎捷产品(Y,N)Ndoc_nostring是报工单号TM6-160300000016srf01source_nostring否来源单号(传入方)CSD-201510050001srf12wo_nostring否工单号码W1-202103310009srg16data_timedate否异动时间格式：yyyyMMddHHmmss20230621000000srfdatekey_conditionstring是前次最后一笔资料的Key条件(首次呼叫可空值)srf01='XM2-200400000087'use_has_nextboolean否是否启用分页机制true：启用分页false：不启用分页truepage_sizenumeric否每页条数/分包的请求笔数使用说明：当启用分页机制时，代表每页条数。取值范围：大于零的整数，默认值50；最大值500。当不启用分页机制时，代表分包的请求笔数，如果值为NULL或０，则不做分包机制50page_nonumeric否页码1date_sstring是开始日期格式：yyyyMMdd20200101srfdatedate_estring否结束日期格式：yyyyMMdd20210101srfdateconditions—否条件集合(单头节点，支持多数组)sequencenumeric否条件顺序1brackestring否括号类型(、((、)、))(field_namestring否字段名称srfdatevaluestring否字段值20230401operatorstring否操作符>、>=、=、<、<=、like、in、<>>logicalstring否搜寻组间的关系AND、ORANDorders—否排序设置(单头节点，支持多数组)field_namestring是字段名称srf01order_typestring是排序类型asc：升序desc：降序ascRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-reqid:81bac276-f94a-4bc8-974b-c631fe30a177digi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_TW","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"tt","name":"tt.oapi.wo.work.report.list.data.query.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"企业编号","CompanyId":"营运据点"}{"std_data":{"parameter":{"enterprise_no":"企业编号","site_no":"营运据点","is_digiwin_product":"是否为鼎捷产品","doc_no":"报工单号","source_no":"来源单号(传入方)","wo_no":"工单号码","data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","use_has_next":"是否启用分页机制","page_size":"每页条数/分包的请求笔数","page_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:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果000参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0：正确<>0：FAIL（原因代码）0sql_codestring否失败时数据库回传代码0descriptionstring否错误问题描述data_timedate是异动时间格式：yyyyMMddHHmmss20230621000000srfdatekey_conditionstring是前次最后一笔资料的Key条件srf01='XM2-200400000087'total_resultsnumeric否总数100has_nextboolean否是否有下一页true：是false：否truereport_attr—是报工属性(单头节点)cntnumeric否当前回传资料笔数50tt_cntnumeric否应回传的资料总笔数100report—是报工(单头节点，支持多数组)doc_typenumeric是单据类型不使用statusstring是状态码N.未审核Y.已审核X.作废Ysrfconfdoc_nostring是报工单号TM6-160300000016srf01doc_datedate是单据日期格式：yyyy-mm-dd2018-11-21srf02source_nostring是来源单号(传入方)Source001srf12reporterstring是报工者01680srj04shift_nostring是班别001srf04op_nostring是作业编号/制程编号不使用modify_nostring否资料修改者002srfmodumodify_datedate否资料修改日格式：yyyy-mm-dd2014-06-17srfdatereport_detail—是报工明细(单身节点，支持多数组)wo_nostring是工单号码W01-160300000001srg16op_seqstring是制程顺序不使用workstation_nostring是工作站/生产线编号不使用machine_nostring否实际加工机台A001srf03number_of_operatorsstring是作业人数不使用complete_datedate是完成日期格式：yyyy-mm-dd2018-11-21srf02report_datetime_estring是报工时间(迄)(报工结束时间)11:39srg09labor_hoursnumeric是人时(秒)10srg10machine_hoursnumeric是机时(秒)10srg19unit_nostring是单位PCSsrg04qtynumeric是实际出站数量1srg05scrap_qtynumeric是报废数量1srg07offline_qtynumeric是下线数量不使用remarkstring否备注srj08Response范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-srvver:1.0digi-srvcode:000{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"存在下一页","report":[{"doc_type":"单据类型","status":"状态码","doc_no":"报工单号","doc_date":"单据日期","source_no":"来源单号(传入方)","reporter":"报工者","shift_no":"班别","op_no":"作业编号/制程编号","modify_no":"资料修改者","modify_date":"资料修改日","report_detail":[{"wo_no":"工单号码","op_seq":"制程顺序","workstation_no":"工作站/生产线编号","machine_no":"实际加工机台","number_of_operators":"作业人数","complete_date":"完成日期","report_datetime_e":"报工时间(迄)","labor_hours":"人时(秒)","machine_hours":"机时(秒)","unit_no":"单位","qty":"实际出站数量","scrap_qty":"报废数量","offline_qty":"下线数量","remark":"备注"}]}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP栏位srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果100参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0：正确<>0：FAIL（原因代码）aws1409sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述传入参数is_digiwin_product不可爲空！Response范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
