The given SQL query selects various fields from the cm_maintenance_plan table and joins it with the customer_info table on the customer_id column. It also includes a custom SQL segment defined by ew.customSqlSegment.

The selected fields are as follows:

  • plan_id
  • plan_name
  • customer_type
  • production_line_id
  • manager
  • description
  • fenb_demand
  • visit_times
  • commucation_times
  • training_times
  • objective
  • notifier
  • status
  • year
  • create_by
  • create_time
  • update_by
  • update_time
  • tenant_id
  • del_flag
  • customer_id
  • customer_name

The query also includes a LIMIT clause to limit the number of returned rows based on the current and size parameters.

Note: The ${ew.customSqlSegment} is a placeholder for a custom SQL segment that can be dynamically added to the query


原文地址: https://www.cveoy.top/t/topic/imWX 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录