MySQL、管易云·奇门通过接口配置数据对接

对接系统：管易云·奇门

管易云是上海管易云计算软件有限公司旗下的专注提供电商企业管理软件服务的品牌，总部位于中国上海张江高科技产业园区。管易云旗下拥有管易云C-ERP、EC-OMS、EC-WMS、B2C/B2B/BBC/微商城开发、PDA无纸化仓储解决方案、新零售一体化解决方案等产品

对接系统：MySQL

MySQL是最流行的数据库之一，是一个免费开源的关系型数据库管理系统，但也不意味着该数据库是完全免费的。MySQL由瑞典MySQLAB公司开发，目前属于Oracle公司。MySQL适合中小型软件，被个人用户以及中小企业青睐。

系统对接接口配置

通过系统数据集成平台：数据集成方案。选择开始创建数据集成方案菜单。在方案配置表单中选择对应的源业务系统：管易云·奇门，然后选择对应的连接器。选择对应的gy.erp.trade.deliverys.get作为数据对接来源。然后再写入目标平台配置目标系统为MySQL，并且选择对应连接器。选择好对应的execute接口作为数据写入动作完成第一步的接口配置。

管易云·奇门接口明细

调用接口：gy.erp.trade.deliverys.get
接口名称：发货单查询
方法：POST

请求参数

字段字段名称类型配置值 start_modify_date修改时间开始段datetime{{LAST_SYNC_TIME}} end_modify_date修改时间结束段datetime{{CURRENT_TIME}} del是否返回已作废的int delivery发货状态int1 wms是否外仓单据int code单据编码string warehouse_code仓库编码string shop_code店铺编码string outer_code平台单号string mail_no物流单号string start_create创建时间开始段datetime end_create创建时间结束段datetime start_delivery_date发货时间开始段datetime end_delivery_date发货时间结束段datetime page_no页码int1 page_size每页大小int20

响应参数

字段字段名称类型配置值 shop_name店铺名称string warehouse_name仓库名称string amount总金额float qty商品总数float platform_code平台单号string seller_memo_late二次备注string cod_fee货到付款服务费float delivery_statusInfo单据状态信息object delivery_statusInfo.delivery_print_date发货单打印时间datetime delivery_statusInfo.print_delivery是否打印发货单string delivery_statusInfo.cancel是否取消bool delivery_statusInfo.express_print_date物流单打印时间datetime delivery_statusInfo.delivery_name发货人string delivery_statusInfo.scan_name扫描人string delivery_statusInfo.delivery_date发货时间datetime delivery_statusInfo.delivery_print_name发货单打印人string delivery_statusInfo.cancel_date取消时间string delivery_statusInfo.weight_qty称重重量float delivery_statusInfo.express_print_name物流单打印人string delivery_statusInfo.print_express是否打印快递单string delivery_statusInfo.thermal_print_status电子面单分配状态string delivery_statusInfo.delivery发货状态int delivery_statusInfo.weight是否称重bool delivery_statusInfo.weight_name称重人string delivery_statusInfo.cancel_name取消人string delivery_statusInfo.thermal_print电子面单打印状态bool delivery_statusInfo.weight_date称重时间datetime delivery_statusInfo.wms是否外仓订单int delivery_statusInfo.standard_weight标准重量float delivery_statusInfo.scan_date扫描时间datetime delivery_statusInfo.wms_order外仓转入状态int delivery_statusInfo.scan是否扫描bool delivery_statusInfo.bigchar大头笔string delivery_statusInfo.vip_real_name真实姓名string delivery_statusInfo.tag_name订单标记名称string delivery_statusInfo.warehouse_code仓库代码string delivery_statusInfo.express_code快递公司代码string delivery_statusInfo.express_no快递单号string delivery_statusInfo.modify_date修改时间datetime delivery_statusInfo.post_cost物流成本float delivery_statusInfo.unpaid_amount未付金额float delivery_statusInfo.vip_name会员名称string delivery_statusInfo.seller_memo卖家备注string delivery_statusInfo.vip_code会员代码string delivery_statusInfo.create_name制单人string delivery_statusInfo.details商品列表array delivery_statusInfo.details.currency_name币别名称string delivery_statusInfo.details.platform_flag平台旗帜int delivery_statusInfo.details.other_service_fee其他服务费float delivery_statusInfo.details.sku_code规格代码string delivery_statusInfo.details.item_name商品名称string delivery_statusInfo.details.gift_source_view赠品来源string delivery_statusInfo.details.order_type订单类型string delivery_statusInfo.details.detail_unique唯一码列表array delivery_statusInfo.details.detail_unique.warwhouse_name仓库名称string delivery_statusInfo.details.detail_unique.unique_code唯一码string delivery_statusInfo.details.detail_unique.qty数量float delivery_statusInfo.details.detail_unique.imei串码string delivery_statusInfo.details.detail_unique.refund退款状态int delivery_statusInfo.details.detail_unique.amount_after让利后金额float delivery_statusInfo.details.detail_unique.detail_batch批次列表array delivery_statusInfo.details.detail_unique.detail_batch.batchNumber批号string delivery_statusInfo.details.detail_unique.detail_batch.validTime有效日期date delivery_statusInfo.details.detail_unique.detail_batch.productionTime生产日期date delivery_statusInfo.details.detail_unique.detail_batch.qty数量float delivery_statusInfo.details.detail_unique.detail_batch.memo备注string delivery_statusInfo.details.detail_unique.detail_batch.currency_code币别代码string delivery_statusInfo.details.detail_unique.detail_batch.tax_rate税率float delivery_statusInfo.details.detail_unique.detail_batch.item_sku_id规格IDstring delivery_statusInfo.details.detail_unique.detail_batch.platform_code平台单号string delivery_statusInfo.details.detail_unique.detail_batch.is_gift是否赠品int delivery_statusInfo.details.detail_unique.detail_batch.picUrl图片地址string delivery_statusInfo.details.detail_unique.detail_batch.discount_fee让利金额float delivery_statusInfo.details.detail_unique.detail_batch.trade_code销售订单号string delivery_statusInfo.details.detail_unique.detail_batch.tax_amount税额float delivery_statusInfo.details.detail_unique.detail_batch.post_fee物流费用float delivery_statusInfo.details.detail_unique.detail_batch.item_code商品代码string delivery_statusInfo.details.detail_unique.detail_batch.price实际单价float delivery_statusInfo.details.detail_unique.detail_batch.businessman_name业务员string delivery_statusInfo.details.detail_unique.detail_batch.item_id商品IDstring delivery_statusInfo.details.detail_unique.detail_batch.amount商品总价float delivery_statusInfo.details.detail_unique.detail_batch.sku_name规格名称string delivery_statusInfo.details.detail_unique.detail_batch.sku_note商品的规格备注string delivery_statusInfo.details.detail_unique.detail_batch.qty商品数量float delivery_statusInfo.details.invoiceDate确认开票时间datetime delivery_statusInfo.details.post_fee物流费用float delivery_statusInfo.details.refund是否退款int delivery_statusInfo.details.receiver_name收货人姓名string delivery_statusInfo.details.express_name快递公司名称string delivery_statusInfo.details.cancel取消状态int delivery_statusInfo.details.area_name收货地区string delivery_statusInfo.details.receiver_phone收货人电话string delivery_statusInfo.details.shop_code店铺代码string delivery_statusInfo.details.discount_fee优惠金额float delivery_statusInfo.details.receiver_address收货地址string delivery_statusInfo.details.plan_delivery_date预计发货时间datetime delivery_statusInfo.details.receiver_mobile收货人手机string delivery_statusInfo.details.receiver_zip收货邮编string delivery_statusInfo.details.shelf_no格子号string delivery_statusInfo.details.create_date制单时间datetime delivery_statusInfo.details.pay_time支付时间datetime delivery_statusInfo.details.buyer_memo买家留言string delivery_statusInfo.details.cod是否货到付款bool delivery_statusInfo.details.payment已付金额float delivery_statusInfo.details.code单据编号string delivery_statusInfo.details.sync_memo数据同步备注string delivery_statusInfo.details.package_center_name集包地名称string delivery_statusInfo.details.invoices发票列表array delivery_statusInfo.details.invoices.bank_account账号string delivery_statusInfo.details.invoices.phone电话string delivery_statusInfo.details.invoices.tex_payer_number纳税人识别号string delivery_statusInfo.details.invoices.bank_name开户行string delivery_statusInfo.details.invoices.invoice_content发票内容string delivery_statusInfo.details.invoices.invoice_amount发票金额float delivery_statusInfo.details.invoices.address地址string delivery_statusInfo.details.invoices.invoice_no发票号string delivery_statusInfo.details.invoices.invoice_title发票抬头string delivery_statusInfo.details.invoices.invoice_type_name发票种型名称string delivery_statusInfo.details.invoices.sync_status数据同步状态int delivery_statusInfo.details.invoices.package_center_code集包地代码string delivery_statusInfo.details.invoices.picture_bill是否多包裹bool delivery_statusInfo.details.invoices.vip_id_card身份证号码string

MySQL接口明细

调用接口：execute
接口名称：执行操作语句-v2
方法：SQL

请求参数

字段字段名称类型配置值 main_params主参数object main_params.no订单编码string21 main_params.shop店铺名称string3123 main_params.platform所属平台string123 main_params.is_online是否线上int1 main_params.salesman销售员string3123 main_params.department部门string3123 main_params.datetime订单时间datetime{{modify_date}} main_params.discount_amount折扣总额float1323 main_params.payment_amount实际支付金额float3123 main_params.remark订单备注string123 main_params.extend_params_11:1扩展参数object main_params.extend_params_1.lastInsertId订单IDstring:lastInsertId main_params.extend_params_1.recipient收件人stringaa main_params.extend_params_1.address收件地址stringbb main_params.extend_params_1.mobile手机号stringcc main_params.extend_params_1.is_vip是否VIPint1 main_params.extend_params_1.buyer_message买家留言stringvvvvvvvvvvvv main_params.extend_params_1.extend_params_21:N扩展参数arraydetails main_params.extend_params_1.extend_params_2.lastInsertId订单IDstring:lastInsertId main_params.extend_params_1.extend_params_2.sku商品规格码string{{details.item_code}} main_params.extend_params_1.extend_params_2.sku_spec规格描述stringdsfsdf main_params.extend_params_1.extend_params_2.sku_category商品分类stringfasd main_params.extend_params_1.extend_params_2.price单价float1 main_params.extend_params_1.extend_params_2.num数量float2 main_params.extend_params_1.extend_params_2.amount金额float3 main_params.extend_params_1.extend_params_2.weight重量float100 main_params.extend_params_1.extend_params_2.tax_rate税率int13 main_params.extend_params_1.extend_params_2.tax_price含税单价float130 main_params.extend_params_1.extend_params_2.tax税额float30 main_params.extend_params_1.extend_params_2.full_amount价税合计float1300 main_params.extend_params_1.extend_params_2.main_sql主语句stringINSERT INTO sale_order (no,shop,platform,is_online,salesman,department,datetime,discount_amount,payment_amount,remark) VALUES (:no,:shop,:platform,:is_online,:salesman,:department,:datetime,:discount_amount,:payment_amount,:remark) main_params.extend_params_1.extend_params_2.extend_sql_11:1扩展子表语句stringINSERT INTO sale_order_ext ( id, recipient, address, mobile, is_vip, buyer_message) VALUES ( :lastInsertId,:recipient,:address,:mobile,:is_vip,:buyer_message ) main_params.extend_params_1.extend_params_2.extend_sql_21:N扩展子表语句stringINSERT INTO sale_order_detail ( order_id, sku,sku_spec,sku_category,price, num, amount,weight, tax_rate,tax_price, tax, full_amount) VALUES ( :order_id, :sku,:sku_spec,:sku_category,:price, :num, :amount,:weight, :tax_rate,:tax_price, :tax, :full_amount)

系统对接总览

大部分的企业都可能只用一套系统组织架构复杂，业务流程繁琐，内部同时有OA系统、BI系统、ERP系统......且各个系统都需要独立登陆，造成IT部门数据监管困难！如何在同一套中台系统上关联多管理系统呢？系统集成平台，就可以无缝集成各个业务系统，主数不统一、交易数据来回导出导入、业务融合等问题。通过轻易云系统集成平台完美结合：打破企业内部数据孤岛，无需繁琐的处理工序，与数据集成服务完美结合，让数据真正通起来。资源互补：汇集各种行业解决方案，资源互补，企业管理融合提升。让对接开箱即用的、可视化拖、拉、拽实现接口服务编排与聚合。

MySQL、管易云·奇门通过接口配置数据对接