ESAP4系列教程|发送表格提醒

select
	'工序'
	,'产品'
	,'计划数'
	,'实际数'

select 
	工序1
	,产品名称1
	, 计划数量1
	,实际数量1 
from 工序表

select
  0 as id,
  'esap' as app, --发给哪个应用
  '@all' as touser, -- 发给那些人，@all是全部
  '' as toparty,
  '' as totag,
  'mpnews' as msgtype,
  '' as msgid,
  '<style type="text/css">
  table { border-collapse: collapse; margin: 0 auto; text-align: center; }
  table td, table th { border: 1px solid #cad9ea; color: #666; height: 30px; }
  table thead th { background-color: #CCE8EB; width: 100px; }
  table tr:nth-child(odd) { background: #fff; }
  table tr:nth-child(even) { background: #F5FAFA; }
  </style>
  详情如下：<br>
  <table border="1" bgcolor="#669">' + replace((
  ----表头开始----th别名后的下划线依次加长
  select
    '工序' as th
    ,'产品' as th_
    ,'计划数' as th__
    ,'实际数' as th___
  ----表头结束----
  for xml path('tr')) + ( 
  ----表体开始----td别名后的下划线依次加长
  select 
    工序1 as td
    ,产品名称1 as td_
    , 计划数量1 as td__
    ,实际数量1 as td___
  from 工序表
  ----表头结束----
  for xml path('tr')),'_','') + '</table>' as content, --内容，拼接了一大坨代码html
  '工序进度提醒' as title, --这个是标题
  '点击查看' as description, --这个是标题下面的描述
  '' as url,
  '433' as pic, --这个是封面图片,事先上传个图片，拿到图片id
  '' as fh,
  0 as safe