71 lines
8.1 KiB
Markdown
71 lines
8.1 KiB
Markdown
|
# 示例3：填报表单（员工信息登记表）
|
|||
|
|
|
|||
|
|
**类型：** 填报表单
|
|||
|
|
**特征：** `fillForm` 组件配置，`submitHandlers` 提交处理器，18种填报组件
|
|||
|
|
|
|||
|
|
## 填报组件类型
|
|||
|
|
|
|||
|
|
| componentFlag | component | 说明 |
|
|||
|
|
|---|---|---|
|
|||
|
|
| `input-text` | Input | 文本输入 |
|
|||
|
|
| `input-textarea` | Input | 多行文本 |
|
|||
|
|
| `InputNumber` | InputNumber | 数字输入 |
|
|||
|
|
| `DatePicker-date` | DatePicker | 日期选择 |
|
|||
|
|
| `DatePicker-time` | DatePicker | 日期时间 |
|
|||
|
|
| `TimePicker` | TimePicker | 时间选择 |
|
|||
|
|
| `JRadio` | JRadio | 单选 |
|
|||
|
|
| `JCheckbox` | JCheckbox | 多选 |
|
|||
|
|
| `JSelect` | JSelect | 下拉选择 |
|
|||
|
|
| `JSelectTree` | JSelectTree | 树形选择 |
|
|||
|
|
| `JUploadImage` | JUploadImage | 图片上传 |
|
|||
|
|
| `JUploadFile` | JUploadFile | 文件上传 |
|
|||
|
|
| `JAreaLinkage` | JAreaLinkage | 省市区联动 |
|
|||
|
|
| `JDepartment` | JDepartment | 部门选择 |
|
|||
|
|
| `JRole` | JRole | 角色选择 |
|
|||
|
|
| `JUser` | JUser | 用户选择 |
|
|||
|
|
| `JSwitch` | JSwitch | 开关 |
|
|||
|
|
| `JMoney` | JMoney | 金额输入 |
|
|||
|
|
| `ColorPicker` | ColorPicker | 颜色选择 |
|
|||
|
|
|
|||
|
|
## 填报组件结构
|
|||
|
|
|
|||
|
|
```json
|
|||
|
|
{
|
|||
|
|
"fillForm": {
|
|||
|
|
"componentFlag": "JSelect",
|
|||
|
|
"component": "JSelect",
|
|||
|
|
"field": "字段名",
|
|||
|
|
"required": false,
|
|||
|
|
"requiredTip": "不能为空~",
|
|||
|
|
"dataSource": "dict|static|api",
|
|||
|
|
"options": [{"label":"选项1","value":"1"}],
|
|||
|
|
"dictCode": "字典编码",
|
|||
|
|
"dictName": "字典名称",
|
|||
|
|
"apiUrl": "远程API地址",
|
|||
|
|
"multiple": false,
|
|||
|
|
"dbFieldBind": [{"dbTable":"表名","dbField":"字段名"}]
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
```
|
|||
|
|
|
|||
|
|
## 提交处理器
|
|||
|
|
|
|||
|
|
```json
|
|||
|
|
{
|
|||
|
|
"submitHandlers": [{
|
|||
|
|
"type": "api",
|
|||
|
|
"code": "api",
|
|||
|
|
"name": "api",
|
|||
|
|
"isMain": true,
|
|||
|
|
"isEdit": true,
|
|||
|
|
"apiUrl": "http://xxx/jmreport/test/submit/handle"
|
|||
|
|
}]
|
|||
|
|
}
|
|||
|
|
```
|
|||
|
|
|
|||
|
|
## 报表 JSON
|
|||
|
|
|
|||
|
|
```json
|
|||
|
|
{"loopBlockList":[],"querySetting":{"izOpenQueryBar":false,"izDefaultQuery":true},"recordSubTableOrCollection":{"group":[],"record":[],"range":[]},"printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"portrait","printCallBackUrl":""},"hidden":{"rows":[],"cols":[]},"queryFormSetting":{"useQueryForm":false,"dbKey":"","idField":""},"dbexps":[],"dicts":[],"fillFormToolbar":{"show":true,"btnList":["save","subTable_add","verify","subTable_del","print","close","first","prev","next","paging","total","last","exportPDF","exportExcel","exportWord"]},"freeze":"A1","dataRectWidth":701,"isViewContentHorizontalCenter":false,"autofilter":{},"validations":[],"cols":{"0":{"width":27},"1":{"width":79},"2":{"width":100},"3":{"width":74},"4":{"width":105},"5":{"width":85},"6":{"width":131},"len":100},"area":false,"pyGroupEngine":false,"submitHandlers":[{"type":"api","code":"api","name":"api","isMain":true,"isEdit":true,"apiUrl":"http://4350302q6b.51vip.biz/jmreport/test/submit/handle"}],"excel_config_id":"1174596178550280192","hiddenCells":[],"zonedEditionList":[],"rows":{"0":{"cells":{"1":{"merge":[1,6],"height":45,"text":"员工信息登记表","style":6}},"height":23},"2":{"cells":{"1":{"text":"编号","style":7,"fillFormLabel":"*"},"2":{"fillForm":{"componentFlag":"input-text","component":"Input","field":"no","value":"","defaultValue":"","placeholder":"","required":false,"requiredTip":"不能为空~","pattern":"","patternErrorTip":""},"style":7,"text":" "},"3":{"text":"年龄","style":7},"4":{"fillForm":{"componentFlag":"InputNumber","component":"InputNumber","field":"age","placeholder":"","required":false,"requiredTip":"不能为空~","precision":0,"isLimitMinNum":false,"minNum":0,"isLimitMaxNum":false,"maxNum":100,"dbFieldBind":[{"dbTable":"test_form_submit","dbField":"age"}]},"style":7,"text":" "},"5":{"text":"填写时间","style":7},"6":{"fillForm":{"componentFlag":"DatePicker-time","component":"DatePicker","field":"create_time","placeholder":"","required":false,"requiredTip":"不能为空~","dateFormat":"yyyy-MM-dd HH:mm:ss","defaultValue":""},"style":7,"text":" "},"7":{"merge":[3,0],"height":180,"fillForm":{"componentFlag":"JUploadImage","component":"JUploadImage","field":"photo","value":"","defaultValue":"","placeholder":"","required":false,"requiredTip":"不能为空~","multiple":false,"maxUploadNum":1,"h_align":"center"},"style":7,"text":" "}},"height":45},"3":{"cells":{"1":{"text":"姓名","style":7,"fillFormLabel":"*"},"2":{"text":" ","fillForm":{"componentFlag":"input-text","component":"Input","field":"name","placeholder":"","required":true,"requiredTip":"不能为空~","dbFieldBind":[{"dbTable":"test_form_submit","dbField":"name"},{"dbTable":"test_form_submit1","dbField":"name"}],"label":"A5","labelText":"姓名","pattern":"","patternErrorTip":""}},"3":{"text":"性别","style":7},"4":{"fillForm":{"componentFlag":"JRadio","component":"JRadio","field":"sex","dataSource":"dict","options":[{"label":"男","value":"1"},{"label":"女","value":"2"}],"dictCode":"sex1","dictName":"性别"},"style":8,"text":" "},"5":{"text":"出生日期","style":7},"6":{"fillForm":{"componentFlag":"DatePicker-date","component":"DatePicker","field":"brithday","dateFormat":"yyyy-MM-dd","dateShowType":"date"},"style":7,"text":" "}},"height":45},"4":{"cells":{"1":{"text":"民族","style":7,"fillFormLabel":"*"},"2":{"fillForm":{"componentFlag":"JSelect","component":"JSelect","field":"nation","dataSource":"dict","dictCode":"minzu","dictName":"民族"},"style":7,"text":" "},"3":{"text":"政治面貌","style":7},"4":{"fillForm":{"componentFlag":"JSelect","component":"JSelect","field":"politics","dataSource":"api","apiUrl":"https://bootapi.jeecg.com/jmreport/test/submit/dict/political"},"style":7,"text":" "},"5":{"text":"籍贯","style":7},"6":{"fillForm":{"componentFlag":"JAreaLinkage","component":"JAreaLinkage","field":"native_place","areaType":"region","dbFieldBind":[{"dbTable":"test_form_submit","dbField":"native_place"}]},"style":7,"text":" "}},"height":45},"9":{"cells":{"1":{"text":"<22><>
|
|||
|
|
```
|