-- #用户
INSERT INTO `eb_system_crud` (`id`, `table_name`, `table_name_en`, `cate_ids`, `info`, `crud_id`, `user_id`, `is_update_form`, `is_update_table`, `form_fields`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, '用户', 'admin', '', '', 0, '4', 0, 0, '[\"account\",\"avatar\",\"phone\",\"job\",\"name\",\"password\",\"is_admin\",\"roles\",\"uni_online\",\"mark\",\"client_id\"]', '2024-05-20 16:14:57', '2024-05-20 17:21:03', NULL);
SELECT @yongHuCrudId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @yongHuCrudId, '主键ID', 'id', 'input_number', 'int', 0, 0, '主键ID', '', 0, 0, 0, 0, 'admin664b06813730f', '', '', 1, 1, 1, '2024-05-20 16:14:57', '2024-05-20 17:21:03', NULL),
(null, @yongHuCrudId, '创建时间', 'created_at', 'date_time_picker', 'timestamp', 1, 0, '创建时间', 'status', 0, 0, 0, 0, 'admin664b068137342', '', '', 1, 1, 1, '2024-05-20 16:14:57', '2024-05-20 17:21:03', NULL),
(null, @yongHuCrudId, '修改时间', 'updated_at', 'date_time_picker', 'timestamp', 1, 0, '修改时间', 'created_at', 0, 0, 0, 0, 'admin664b06813734d', '', '', 1, 1, 1, '2024-05-20 16:14:57', '2024-05-20 17:21:03', NULL),
(null, @yongHuCrudId, '伪删除', 'deleted_at', 'date_time_picker', 'timestamp', 1, 0, '伪删除', 'updated_at', 0, 0, 0, 0, 'admin664b068137355', '', '', 1, 1, 1, '2024-05-20 16:14:57', '2024-05-20 17:21:03', NULL),
(null, @yongHuCrudId, 'UID', 'uid', 'input', 'varchar', 1, 1, 'UID', 'owner_user_id', 0, 0, 0, 0, 'admin664b070d2ebc5', '[]', '[]', 0, 0, 1, '2024-05-20 16:17:17', '2024-05-20 17:21:03', NULL);

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @yongHuCrudId, '用户账号', 'account', 'input', 'varchar', 1, 1, '用户账号', 'uid', 0, 0, 0, 1, 'admin664b072702318', '[]', '[]', 1, 1, 1, '2024-05-20 16:17:43', '2024-05-20 17:21:03', NULL);
SELECT @yongHuYongHuZhangHaoFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @yongHuCrudId, '用户头像', 'avatar', 'image', 'text', 1, 1, '用户头像', 'password', 0, 0, 0, 1, 'admin664b0bd244999', '[]', '{\"max\":\"1\",\"size\":\"5\"}', 1, 1, 1, '2024-05-20 16:37:38', '2024-05-20 17:21:03', NULL);
SELECT @yongHuYongHuTouXiangFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @yongHuCrudId, '用户姓名', 'name', 'input', 'varchar', 1, 1, '用户姓名', 'avatar', 0, 0, 1, 1, 'admin664b0c17cf61b', '[]', '{\"maxlength\":\"20\"}', 1, 1, 1, '2024-05-20 16:38:47', '2024-05-20 17:21:03', NULL);
SELECT @yongHuYongHuXingMingFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @yongHuCrudId, '手机号', 'phone', 'input', 'varchar', 1, 1, '手机号', 'name', 0, 0, 0, 1, 'admin664b0c280089d', '[]', '{\"maxlength\":\"11\"}', 1, 1, 1, '2024-05-20 16:39:04', '2024-05-20 17:21:03', NULL);
SELECT @yongHuShouJiHaoFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @yongHuCrudId, '职位ID', 'job', 'input_number', 'int', 1, 1, '职位ID', 'phone', 0, 0, 0, 1, 'admin664b0ca41de64', '[]', '[]', 1, 1, 1, '2024-05-20 16:41:08', '2024-05-20 17:21:03', NULL);
SELECT @yongHuZhiWeiIDFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @yongHuCrudId, '访问ip', 'last_ip', 'input', 'varchar', 1, 1, '访问ip', 'scan_key', 0, 0, 0, 0, 'admin664b0cfbc834e', '[]', '[]', 1, 1, 1, '2024-05-20 16:42:35', '2024-05-20 17:21:03', NULL),
(null, @yongHuCrudId, '登陆次数', 'login_count', 'input_number', 'int', 1, 1, '登陆次数', 'last_ip', 0, 0, 0, 0, 'admin664b0d0b5b174', '[]', '[]', 1, 1, 1, '2024-05-20 16:42:51', '2024-05-20 17:21:03', NULL),
(null, @yongHuCrudId, '语言', 'language', 'input', 'varchar', 1, 1, '语言', 'is_init', 0, 0, 0, 0, 'admin664b0d5565d27', '[]', '[]', 1, 1, 1, '2024-05-20 16:44:05', '2024-05-20 17:21:03', NULL);

INSERT INTO `eb_system_crud_form` (`id`, `crud_id`, `version`, `options`, `fields`, `global_options`, `is_index`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @yongHuCrudId, 1, CONCAT('[{"name":"\\u7528\\u6237\\u8d26\\u53f7","type":"input","icon":"text-field","formItemFlag":true,"options":{"name":"account","label":"\\u7528\\u6237\\u8d26\\u53f7","labelAlign":"","type":"","defaultValue":"","placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":false,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"300","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"', @yongHuYongHuZhangHaoFieldId, '","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","formFieldUniqid":"account"},"hide":false,"id":"input54795","i":"3","pidx":"0"},{"name":"\\u7528\\u6237\\u5934\\u50cf","type":"image","icon":"picture-upload-field","formItemFlag":true,"options":{"name":"avatar","label":"\\u7528\\u6237\\u5934\\u50cf","labelAlign":"","type":"","defaultValue":[],"placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":false,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"300","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"', @yongHuYongHuTouXiangFieldId, '","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","uploadURL":"Common\/upload","uploadTip":"","withCredentials":false,"multipleSelect":false,"showFileList":false,"limit":"1","fileMaxSize":"5","fileTypes":["jpg","jpeg","png","gif"],"formFieldUniqid":"avatar"},"hide":false,"id":"image47561","i":"5","pidx":"0"},{"name":"\\u624b\\u673a\\u53f7","type":"input","icon":"text-field","formItemFlag":true,"options":{"name":"phone","label":"\\u624b\\u673a\\u53f7","labelAlign":"","type":"","defaultValue":"","placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":false,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"11","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"', @yongHuShouJiHaoFieldId, '","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","formFieldUniqid":"phone"},"hide":false,"id":"input57574","i":"7","pidx":"0"},{"name":"\\u804c\\u4f4dID","type":"input-number","icon":"number-field","formItemFlag":true,"options":{"name":"job","label":"\\u804c\\u4f4dID","labelAlign":"","type":"","defaultValue":"","placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":false,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"300","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"', @yongHuZhiWeiIDFieldId, '","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","keyNameEnabled":false,"keyName":"","min":"-100000000000","max":"100000000000","precision":"0","step":"1","formFieldUniqid":"job"},"hide":false,"id":"inputnumber100269","i":"8","pidx":"0"},{"name":"\\u7528\\u6237\\u59d3\\u540d","type":"input","icon":"text-field","formItemFlag":true,"options":{"name":"name","label":"\\u7528\\u6237\\u59d3\\u540d","labelAlign":"","type":"","defaultValue":"","placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":false,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"20","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"', @yongHuYongHuXingMingFieldId, '","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","formFieldUniqid":"name"},"hide":false,"id":"input67193","i":"6","pidx":"0"},{"name":"\\u7528\\u6237\\u5bc6\\u7801","type":"input","icon":"text-field","formItemFlag":true,"options":{"name":"password","label":"\\u7528\\u6237\\u5bc6\\u7801","labelAlign":"","type":"password","defaultValue":"","placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":true,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"300","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"0","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","formFieldUniqid":"password"},"hide":false,"id":"input44770","i":"4","pidx":"0"},{"name":"\\u89d2\\u8272\\u6743\\u9650","type":"textarea","icon":"textarea-field","formItemFlag":true,"options":{"name":"roles","label":"\\u89d2\\u8272\\u6743\\u9650","labelAlign":"","type":"","defaultValue":"","placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":false,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"300","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"0","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","rows":"3","formFieldUniqid":"roles"},"hide":false,"id":"textarea102750","i":"10","pidx":"0"},{"name":"\\u662f\\u5426\\u4e3a\\u8d85\\u7ea7\\u7ba1\\u7406\\u5458","type":"switch","icon":"switch-field","formItemFlag":true,"options":{"name":"is_admin","label":"\\u662f\\u5426\\u4e3a\\u8d85\\u7ea7\\u7ba1\\u7406\\u5458","labelAlign":"","type":"","defaultValue":"","placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":false,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"300","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"0","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","switchWidth":"40","activeText":"\\u5f00\\u542f","inactiveText":"\\u5173\\u95ed","activeColor":"","inactiveColor":"","formFieldUniqid":"is_admin"},"hide":false,"id":"switch102045","i":"9","pidx":"0"},{"name":"\\u79fb\\u52a8\\u7aef\\u767b\\u5f55\\u72b6\\u6001","type":"switch","icon":"switch-field","formItemFlag":true,"options":{"name":"uni_online","label":"\\u79fb\\u52a8\\u7aef\\u767b\\u5f55\\u72b6\\u6001","labelAlign":"","type":"","defaultValue":"","placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":false,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"300","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"0","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","switchWidth":"40","activeText":"\\u5f00\\u542f","inactiveText":"\\u5173\\u95ed","activeColor":"","inactiveColor":"","formFieldUniqid":"uni_online"},"hide":false,"id":"switch13185","i":"11","pidx":"0"},{"name":"\\u5907\\u6ce8","type":"textarea","icon":"textarea-field","formItemFlag":true,"options":{"name":"mark","label":"\\u5907\\u6ce8","labelAlign":"","type":"","defaultValue":"","placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":false,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"300","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"0","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","rows":"3","formFieldUniqid":"mark"},"hide":false,"id":"textarea43072","i":"18","pidx":"0"},{"name":"\\u8fde\\u63a5\\u901a\\u9053ID","type":"input","icon":"text-field","formItemFlag":true,"options":{"name":"client_id","label":"\\u8fde\\u63a5\\u901a\\u9053ID","labelAlign":"","type":"","defaultValue":"","placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":false,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"300","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"0","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","formFieldUniqid":"client_id"},"hide":false,"id":"input68685","i":"12","pidx":"0"}]'), '["account","avatar","phone","job","name","password","is_admin","roles","uni_online","mark","client_id"]', '{"modelName":"formData","refName":"vForm","rulesName":"rules","labelWidth":"111","labelPosition":"left","size":"small","labelAlign":"label-left-align","cssCode":"","customClass":[],"functions":"","layoutType":"PC","onFormCreated":"","onFormMounted":"","onFormDataChange":""}', 1, '2024-05-20 17:21:03', '2024-05-20 17:21:03', NULL);

-- 部门
INSERT INTO `eb_system_crud` (`id`, `table_name`, `table_name_en`, `cate_ids`, `info`, `crud_id`, `user_id`, `is_update_form`, `is_update_table`, `form_fields`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, '部门', 'frame', '', '', 0, '4', 0, 0, '', '2024-05-20 17:01:19', '2024-05-20 17:01:19', NULL);
SELECT @buMenCrudId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @buMenCrudId, '主键ID', 'id', 'input_number', 'int', 0, 0, '主键ID', '', 0, 0, 0, 0, 'frame664b115f310ad', '', '', 1, 1, 1, '2024-05-20 17:01:19', '2024-05-20 17:01:19', NULL),
(null, @buMenCrudId, '创建时间', 'created_at', 'date_time_picker', 'timestamp', 1, 0, '创建时间', 'level', 0, 0, 0, 0, 'frame664b115f310d5', '', '', 1, 1, 1, '2024-05-20 17:01:19', '2024-05-20 17:04:37', NULL),
(null, @buMenCrudId, '修改时间', 'updated_at', 'date_time_picker', 'timestamp', 1, 0, '修改时间', 'created_at', 0, 0, 0, 0, 'frame664b115f310da', '', '', 1, 1, 1, '2024-05-20 17:01:19', '2024-05-20 17:01:19', NULL),
(null, @buMenCrudId, '部门名称', 'name', 'input', 'varchar', 1, 1, '部门名称', 'owner_user_id', 0, 0, 1, 0, 'frame664b1183b236a', '[]', '[]', 1, 1, 1, '2024-05-20 17:01:55', '2024-05-20 17:01:55', NULL),
(null, @buMenCrudId, '父级ID', 'pid', 'input_select', 'int', 1, 1, '父级ID', 'name', 0, @buMenCrudId, 0, 0, 'frame664b11a3c7e68', '[\"id\",\"name\"]', '[]', 1, 1, 1, '2024-05-20 17:02:27', '2024-05-20 17:02:27', NULL),
(null, @buMenCrudId, '角色ID', 'role_id', 'input_number', 'int', 1, 1, '角色ID', 'pid', 0, 0, 0, 0, 'frame664b11be0b2f6', '[]', '[]', 1, 1, 1, '2024-05-20 17:02:54', '2024-05-20 17:02:54', NULL),
(null, @buMenCrudId, '路径', 'path', 'input', 'varchar', 1, 1, '路径', 'role_id', 0, 0, 0, 0, 'frame664b11d03a9fa', '[]', '[]', 1, 1, 1, '2024-05-20 17:03:12', '2024-05-20 17:03:12', NULL),
(null, @buMenCrudId, '部门介绍', 'introduce', 'input', 'varchar', 1, 1, '部门介绍', 'path', 0, 0, 0, 0, 'frame664b11dd09d48', '[]', '[]', 1, 1, 1, '2024-05-20 17:03:25', '2024-05-20 17:03:25', NULL),
(null, @buMenCrudId, '排序', 'sort', 'input_number', 'int', 1, 1, '排序', 'introduce', 0, 0, 0, 0, 'frame664b11f0612ab', '[]', '[]', 1, 1, 1, '2024-05-20 17:03:44', '2024-05-20 17:03:44', NULL),
(null, @buMenCrudId, '用户数量', 'user_count', 'input_number', 'int', 1, 1, '用户数量', 'sort', 0, 0, 0, 0, 'frame664b11fcd3d41', '[]', '[]', 1, 1, 1, '2024-05-20 17:03:56', '2024-05-20 17:03:56', NULL),
(null, @buMenCrudId, '单个部门总人数', 'user_single_count', 'input_number', 'int', 1, 1, '单个部门总人数', 'user_count', 0, 0, 0, 0, 'frame664b1207c7338', '[]', '[]', 1, 1, 1, '2024-05-20 17:04:07', '2024-05-20 17:04:07', NULL),
(null, @buMenCrudId, '是否显示', 'is_show', 'switch', 'tinyint', 1, 1, '是否显示', 'user_single_count', 0, 0, 0, 0, 'frame664b12175b208', '[]', '[]', 1, 1, 1, '2024-05-20 17:04:23', '2024-05-20 17:04:23', NULL),
(null, @buMenCrudId, '等级', 'level', 'input_number', 'int', 1, 1, '等级', 'is_show', 0, 0, 0, 0, 'frame664b122540ffb', '[]', '[]', 1, 1, 1, '2024-05-20 17:04:37', '2024-05-20 17:04:37', NULL);

INSERT INTO `eb_system_crud_cate` (`id`, `name`, `sort`, `created_at`, `updated_at`) VALUES (null, '工资条', 10, '2024-06-14 15:04:35', '2024-06-14 15:36:26');
SELECT @crudCateId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud` (`id`, `table_name`, `table_name_en`, `cate_ids`, `info`, `crud_id`, `user_id`, `is_update_form`, `is_update_table`, `form_fields`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, '工资条结构', 'gongzitiaojiegou',  CONCAT('/', @crudCateId, '/'), '', 0, '1', 0, 0, '[\"jibengongzi\",\"jixiaogongzi\",\"gangweigongzi\",\"guanlijintie\",\"jinengbutie\",\"qitabutie\",\"yuangong\",\"tiaoxinbeizhu\"]', '2024-06-14 15:04:56', '2024-06-15 11:21:36', NULL);
SELECT @gongZiJieGouCrudId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJieGouCrudId, '主键ID', 'id', 'input_number', 'int', 0, 1, '主键ID', '', 0, 0, 0, 0, 'gongzitiaojiegou666beb989e5c8', '', '', 1, 1, 1, '2024-06-14 15:04:56', '2024-06-15 11:21:36', NULL),
(null, @gongZiJieGouCrudId, '创建用户', 'user_id', 'input_select', 'int', 1, 0, '创建用户', 'id', 0, 0, 0, 0, 'gongzitiaojiegou666beb989e5cf', '', '', 1, 1, 1, '2024-06-14 15:04:56', '2024-06-15 11:21:36', NULL),
(null, @gongZiJieGouCrudId, '修改用户', 'update_user_id', 'input_select', 'int', 1, 0, '修改用户', 'user_id', 0, 0, 0, 0, 'gongzitiaojiegou666beb989e5d1', '', '', 1, 1, 1, '2024-06-14 15:04:56', '2024-06-15 11:21:36', NULL),
(null, @gongZiJieGouCrudId, '所属部门', 'frame_id', 'input_select', 'int', 1, 0, '所属部门', 'update_user_id', 0, 0, 0, 0, 'gongzitiaojiegou666beb989e5d4', '', '', 1, 1, 1, '2024-06-14 15:04:56', '2024-06-15 11:21:36', NULL),
(null, @gongZiJieGouCrudId, '所属用户', 'owner_user_id', 'input_select', 'int', 1, 0, '所属用户', 'frame_id', 0, 0, 0, 0, 'gongzitiaojiegou666beb989e5d7', '', '', 1, 1, 1, '2024-06-14 15:04:56', '2024-06-15 11:21:36', NULL);

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJieGouCrudId, '员工', 'yuangong', 'input_select', 'int', 0, 1, '员工', 'owner_user_id', 0, @yongHuCrudId, 0, 1, 'gongzitiaojiegou666bee52424e5', '[\"id\",\"name\"]', '[]', 1, 0, 1, '2024-06-14 15:16:34', '2024-06-15 11:21:36', NULL);
SELECT @gongZiJieGouYuanGongFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJieGouCrudId, '修改时间', 'updated_at', 'date_time_picker', 'timestamp', 1, 0, '修改时间', 'created_at', 0, 0, 0, 0, 'gongzitiaojiegou666beb989e5db', '', '', 1, 1, 1, '2024-06-14 15:04:56', '2024-06-15 11:21:36', NULL),
(null, @gongZiJieGouCrudId, '伪删除', 'deleted_at', 'date_time_picker', 'timestamp', 1, 0, '伪删除', 'updated_at', 0, 0, 0, 0, 'gongzitiaojiegou666beb989e5de', '', '', 1, 1, 1, '2024-06-14 15:04:56', '2024-06-15 11:21:36', NULL);

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJieGouCrudId, '基本工资', 'jibengongzi', 'input_float', 'decimal', 1, 1, '基本工资', 'owner_user_id', 0, 0, 0, 1, 'gongzitiaojiegou666bec56735cc', '[]', '{\"precision\":\"2\"}', 1, 1, 1, '2024-06-14 15:08:06', '2024-06-15 11:21:36', NULL);
SELECT @gongZiJieGouJiBenGongZiFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJieGouCrudId, '绩效工资', 'jixiaogongzi', 'input_float', 'decimal', 1, 1, '绩效工资', 'jibengongzi', 0, 0, 0, 1, 'gongzitiaojiegou666bec68eb19a', '[]', '{\"precision\":\"2\"}', 1, 1, 1, '2024-06-14 15:08:24', '2024-06-15 11:21:36', NULL);
SELECT @gongZiJieGouJiXiaoGongZiFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJieGouCrudId, '岗位工资', 'gangweigongzi', 'input_float', 'decimal', 1, 1, '岗位工资', 'jixiaogongzi', 0, 0, 0, 1, 'gongzitiaojiegou666bec78e31ab', '[]', '{\"precision\":\"2\"}', 1, 1, 1, '2024-06-14 15:08:40', '2024-06-15 11:21:36', NULL);
SELECT @gongZiJieGouGangWeiGongZiFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJieGouCrudId, '管理津贴', 'guanlijintie', 'input_float', 'decimal', 1, 1, '管理津贴', 'gangweigongzi', 0, 0, 0, 1, 'gongzitiaojiegou666bec82b2364', '[]', '{\"precision\":\"2\"}', 1, 1, 1, '2024-06-14 15:08:50', '2024-06-15 11:21:36', NULL);
SELECT @gongZiJieGouGuanLiJinTieFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJieGouCrudId, '技能补贴', 'jinengbutie', 'input_float', 'decimal', 1, 1, '技能补贴', 'guanlijintie', 0, 0, 0, 1, 'gongzitiaojiegou666bec8c45bb3', '[]', '{\"precision\":\"2\"}', 1, 1, 1, '2024-06-14 15:09:00', '2024-06-15 11:21:36', NULL);
SELECT @gongZiJieGouJiNengBuTieFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJieGouCrudId, '其他补贴', 'qitabutie', 'input_float', 'decimal', 1, 1, '其他补贴', 'jinengbutie', 0, 0, 0, 1, 'gongzitiaojiegou666bec958ed51', '[]', '{\"precision\":\"2\"}', 1, 1, 1, '2024-06-14 15:09:09', '2024-06-15 11:21:36', NULL);
SELECT @gongZiJieGouQiTaBuTieFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJieGouCrudId, '调薪备注', 'tiaoxinbeizhu', 'textarea', 'text', 1, 1, '调薪备注', 'yuangong', 0, 0, 0, 1, 'gongzitiaojiegou666d08bb7c461', '[]', '[]', 1, 1, 1, '2024-06-15 11:21:31', '2024-06-15 11:21:36', NULL);
SELECT @gongZiJieGouTiaoXinBeiZhuFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJieGouCrudId, '创建时间', 'created_at', 'date_time_picker', 'timestamp', 1, 1, '创建时间', 'tiaoxinbeizhu', 0, 0, 0, 0, 'gongzitiaojiegou666beb989e5d9', '', '', 1, 1, 1, '2024-06-14 15:04:56', '2024-06-15 11:21:36', NULL);

INSERT INTO `eb_system_crud_form` (`id`, `crud_id`, `version`, `options`, `fields`, `global_options`, `is_index`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJieGouCrudId, 1, CONCAT('[{"name":"\\u5458\\u5de5","type":"input-select","icon":"reference-field","formItemFlag":true,"options":{"name":"yuangong","label":"\\u5458\\u5de5","labelAlign":"","type":"","defaultValue":"","placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":false,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"300","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"', @gongZiJieGouYuanGongFieldId, '","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","buttonText":"\\u9009\\u62e9","formFieldUniqid":"yuangong","isCityShow":""},"hide":false,"id":"inputselect57159","i":"12","pidx":"0"},{"name":"\\u57fa\\u672c\\u5de5\\u8d44","type":"input-float","icon":"number-field","formItemFlag":true,"options":{"name":"jibengongzi","label":"\\u57fa\\u672c\\u5de5\\u8d44","labelAlign":"","type":"","defaultValue":"","placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":false,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"300","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"', @gongZiJieGouJiBenGongZiFieldId, '","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","keyNameEnabled":false,"keyName":"","min":"-999999999","max":"999999999","precision":"2","step":"1","formFieldUniqid":"jibengongzi","isCityShow":""},"hide":false,"id":"inputfloat79437","i":"6","pidx":"0"},{"name":"\\u7ee9\\u6548\\u5de5\\u8d44","type":"input-float","icon":"number-field","formItemFlag":true,"options":{"name":"jixiaogongzi","label":"\\u7ee9\\u6548\\u5de5\\u8d44","labelAlign":"","type":"","defaultValue":"","placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":false,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"300","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"', @gongZiJieGouJiXiaoGongZiFieldId, '","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","keyNameEnabled":false,"keyName":"","min":"-999999999","max":"999999999","precision":"2","step":"1","formFieldUniqid":"jixiaogongzi","isCityShow":""},"hide":false,"id":"inputfloat18742","i":"7","pidx":"0"},{"name":"\\u5c97\\u4f4d\\u5de5\\u8d44","type":"input-float","icon":"number-field","formItemFlag":true,"options":{"name":"gangweigongzi","label":"\\u5c97\\u4f4d\\u5de5\\u8d44","labelAlign":"","type":"","defaultValue":"","placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":false,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"300","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"', @gongZiJieGouGangWeiGongZiFieldId, '","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","keyNameEnabled":false,"keyName":"","min":"-999999999","max":"999999999","precision":"2","step":"1","formFieldUniqid":"gangweigongzi","isCityShow":""},"hide":false,"id":"inputfloat24128","i":"8","pidx":"0"},{"name":"\\u7ba1\\u7406\\u6d25\\u8d34","type":"input-float","icon":"number-field","formItemFlag":true,"options":{"name":"guanlijintie","label":"\\u7ba1\\u7406\\u6d25\\u8d34","labelAlign":"","type":"","defaultValue":"","placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":false,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"300","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"', @gongZiJieGouGuanLiJinTieFieldId, '","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","keyNameEnabled":false,"keyName":"","min":"-999999999","max":"999999999","precision":"2","step":"1","formFieldUniqid":"guanlijintie","isCityShow":""},"hide":false,"id":"inputfloat104789","i":"9","pidx":"0"},{"name":"\\u6280\\u80fd\\u8865\\u8d34","type":"input-float","icon":"number-field","formItemFlag":true,"options":{"name":"jinengbutie","label":"\\u6280\\u80fd\\u8865\\u8d34","labelAlign":"","type":"","defaultValue":"","placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":false,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"300","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"', @gongZiJieGouJiNengBuTieFieldId, '","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","keyNameEnabled":false,"keyName":"","min":"-999999999","max":"999999999","precision":"2","step":"1","formFieldUniqid":"jinengbutie","isCityShow":""},"hide":false,"id":"inputfloat58904","i":"10","pidx":"0"},{"name":"\\u5176\\u4ed6\\u8865\\u8d34","type":"input-float","icon":"number-field","formItemFlag":true,"options":{"name":"qitabutie","label":"\\u5176\\u4ed6\\u8865\\u8d34","labelAlign":"","type":"","defaultValue":"","placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":false,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"300","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"', @gongZiJieGouQiTaBuTieFieldId, '","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","keyNameEnabled":false,"keyName":"","min":"-999999999","max":"999999999","precision":"2","step":"1","formFieldUniqid":"qitabutie","isCityShow":""},"hide":false,"id":"inputfloat85534","i":"11","pidx":"0"},{"name":"\\u8c03\\u85aa\\u5907\\u6ce8","type":"textarea","icon":"textarea-field","formItemFlag":true,"options":{"name":"tiaoxinbeizhu","label":"\\u8c03\\u85aa\\u5907\\u6ce8","labelAlign":"","type":"","defaultValue":"","placeholder":"","columnWidth":"200px","size":"","labelWidth":"","labelHidden":false,"readonly":false,"disabled":false,"hidden":false,"clearable":false,"showPassword":false,"required":false,"requiredHint":"","validation":"","validationHint":"","customClass":"","labelIconClass":"","labelIconPosition":"rear","labelTooltip":"","minLength":"300","maxLength":"300","showWordLimit":false,"prefixIcon":"","suffixIcon":"","appendButton":false,"appendButtonDisabled":false,"buttonIcon":"","dataDictId":"0","fieldId":"', @gongZiJieGouTiaoXinBeiZhuFieldId, '","onCreated":"","onMounted":"","onInput":"","onChange":"","onFocus":"","onBlur":"","onValidate":"","onAppendButtonClick":"","rows":"3","formFieldUniqid":"tiaoxinbeizhu","isCityShow":""},"hide":false,"id":"textarea4650","i":"13","pidx":"0"}]'), '["jibengongzi","jixiaogongzi","gangweigongzi","guanlijintie","jinengbutie","qitabutie","yuangong","tiaoxinbeizhu"]','{"modelName":"formData","refName":"vForm","rulesName":"rules","labelWidth":"80","labelPosition":"left","size":"small","labelAlign":"label-left-align","cssCode":"","customClass":[],"functions":"","layoutType":"PC","onFormCreated":"","onFormMounted":"","onFormDataChange":""}', 1, '2024-06-15 11:21:36', '2024-06-15 11:21:36', NULL);

INSERT INTO `eb_system_crud` (`id`, `table_name`, `table_name_en`, `cate_ids`, `info`, `crud_id`, `user_id`, `is_update_form`, `is_update_table`, `form_fields`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, '工资条记录', 'gongzitiaojilu', CONCAT('/', @crudCateId, '/'), '', 0, '1', 0, 0, '[\"gongzitiaojiegou\",\"jibengongzi\",\"gangweigongzi\",\"jixiaogongzi\",\"jinengbutie\",\"guanlijintie\",\"qitabutie\",\"yuangong\",\"tiaoxinbeizhu\"]', '2024-06-14 15:36:06', '2024-06-15 11:29:55', NULL);
SELECT @gongZiJiLuCrudId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJiLuCrudId, '主键ID', 'id', 'input_number', 'int', 0, 1, '主键ID', '', 0, 0, 0, 0, 'gongzitiaojilu666bf2e64f94d', '', '', 1, 1, 1, '2024-06-14 15:36:06', '2024-06-15 11:29:55', NULL),
(null, @gongZiJiLuCrudId, '创建用户', 'user_id', 'input_select', 'int', 1, 0, '创建用户', 'id', 0, 0, 0, 0, 'gongzitiaojilu666bf2e64f956', '', '', 1, 1, 1, '2024-06-14 15:36:06', '2024-06-15 11:29:55', NULL),
(null, @gongZiJiLuCrudId, '修改用户', 'update_user_id', 'input_select', 'int', 1, 0, '修改用户', 'user_id', 0, 0, 0, 0, 'gongzitiaojilu666bf2e64f95b', '', '', 1, 1, 1, '2024-06-14 15:36:06', '2024-06-15 11:29:55', NULL),
(null, @gongZiJiLuCrudId, '所属部门', 'frame_id', 'input_select', 'int', 1, 0, '所属部门', 'update_user_id', 0, 0, 0, 0, 'gongzitiaojilu666bf2e64f95f', '', '', 1, 1, 1, '2024-06-14 15:36:06', '2024-06-15 11:29:55', NULL),
(null, @gongZiJiLuCrudId, '所属用户', 'owner_user_id', 'input_select', 'int', 1, 0, '所属用户', 'frame_id', 0, 0, 0, 0, 'gongzitiaojilu666bf2e64f964', '', '', 1, 1, 1, '2024-06-14 15:36:06', '2024-06-15 11:29:55', NULL);

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJiLuCrudId, '员工', 'yuangong', 'input_select', 'int', 0, 1, '员工', 'qitabutie', 0, @yongHuCrudId, 0, 1, 'gongzitiaojilu666bf6f9821ed', '[\"id\",\"name\"]', '[]', 0, 0, 1, '2024-06-14 15:53:29', '2024-06-15 11:29:55', NULL);
SELECT @gongZiJiLuYuanGongFieldId := LAST_INSERT_ID();
INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJiLuCrudId, '修改时间', 'updated_at', 'date_time_picker', 'timestamp', 1, 0, '修改时间', 'created_at', 0, 0, 0, 0, 'gongzitiaojilu666bf2e64f96b', '', '', 1, 1, 1, '2024-06-14 15:36:06', '2024-06-15 11:29:55', NULL),
(null, @gongZiJiLuCrudId, '伪删除', 'deleted_at', 'date_time_picker', 'timestamp', 1, 0, '伪删除', 'updated_at', 0, 0, 0, 0, 'gongzitiaojilu666bf2e64f96e', '', '', 1, 1, 1, '2024-06-14 15:36:06', '2024-06-15 11:29:55', NULL);

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJiLuCrudId, '工资条结构', 'gongzitiaojiegou', 'input_select', 'int', 1, 0, '工资条结构', 'owner_user_id', 0, @gongZiJieGouCrudId, 0, 1, 'gongzitiaojilu666bf47eb9e2c', '[\"id\",\"owner_user_id\",\"yuangong\"]', '[]', 0, 0, 1, '2024-06-14 15:42:54', '2024-06-15 11:29:55', NULL);
SELECT @gongZiJiLuGongZiTiaoJieGoFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJiLuCrudId, '基本工资', 'jibengongzi', 'input_float', 'decimal', 1, 1, '基本工资', 'gongzitiaojiegou', 0, 0, 0, 1, 'gongzitiaojilu666bf4da6eb40', '[]', '{\"precision\":\"2\"}', 0, 0, 1, '2024-06-14 15:44:26', '2024-06-15 11:29:55', NULL);
SELECT @gongZiJiLuJiBenGongZiFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJiLuCrudId, '绩效工资', 'jixiaogongzi', 'input_float', 'decimal', 1, 1, '绩效工资', 'jibengongzi', 0, 0, 0, 1, 'gongzitiaojilu666bf4ebec42e', '[]', '{\"precision\":\"2\"}', 0, 0, 1, '2024-06-14 15:44:43', '2024-06-15 11:29:55', NULL);
SELECT @gongZiJiLuJiXiaoGongZiFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJiLuCrudId, '岗位工资', 'gangweigongzi', 'input_float', 'decimal', 1, 1, '岗位工资', 'jixiaogongzi', 0, 0, 0, 1, 'gongzitiaojilu666bf4f64d6ab', '[]', '{\"precision\":\"2\"}', 0, 0, 1, '2024-06-14 15:44:54', '2024-06-15 11:29:55', NULL);
SELECT @gongZiJiLuGangWeiGongZiFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJiLuCrudId, '管理津贴', 'guanlijintie', 'input_float', 'decimal', 1, 1, '管理津贴', 'gangweigongzi', 0, 0, 0, 1, 'gongzitiaojilu666bf5025fe24', '[]', '{\"precision\":\"2\"}', 0, 0, 1, '2024-06-14 15:45:06', '2024-06-15 11:29:55', NULL);
SELECT @gongZiJiLuGuanLiJinTieFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJiLuCrudId, '技能补贴', 'jinengbutie', 'input_float', 'decimal', 1, 1, '技能补贴', 'guanlijintie', 0, 0, 0, 1, 'gongzitiaojilu666bf50ccc1c1', '[]', '{\"precision\":\"2\"}', 0, 0, 1, '2024-06-14 15:45:16', '2024-06-15 11:29:55', NULL);
SELECT @gongZiJiLuJiNengBuTieFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJiLuCrudId, '其他补贴', 'qitabutie', 'input_float', 'decimal', 1, 1, '其他补贴', 'jinengbutie', 0, 0, 0, 1, 'gongzitiaojilu666bf5169a11e', '[]', '{\"precision\":\"2\"}', 0, 0, 1, '2024-06-14 15:45:26', '2024-06-15 11:29:55', NULL);
SELECT @gongZiJiLuQiTaBuTieFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJiLuCrudId, '调薪备注', 'tiaoxinbeizhu', 'textarea', 'text', 1, 1, '调薪备注', 'yuangong', 0, 0, 0, 1, 'gongzitiaojilu666d0aae746f7', '[]', '[]', 0, 0, 1, '2024-06-15 11:29:50', '2024-06-15 11:29:55', NULL);
SELECT @gongZiJiLuTiaoXinBeiZhuFieldId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @gongZiJiLuCrudId, '创建时间', 'created_at', 'date_time_picker', 'timestamp', 1, 1, '创建时间', 'tiaoxinbeizhu', 0, 0, 0, 0, 'gongzitiaojilu666bf2e64f968', '', '', 1, 1, 1, '2024-06-14 15:36:06', '2024-06-15 11:29:55', NULL);

INSERT INTO `eb_system_crud_event` (`id`, `crud_id`, `name`, `event`, `action`, `sort`, `target_crud_id`, `crud_approve_id`, `send_type`, `send_user`, `notify_type`, `additional_search`, `template`, `field_options`, `options`, `created_at`, `updated_at`, `deleted_at`, `status`, `additional_search_boolean`, `aggregate_target_search_boolean`, `aggregate_data_search_boolean`, `aggregate_data_search`, `timer`, `aggregate_target_search`, `aggregate_field_rule`, `aggregate_data_field`) VALUES
(null, @gongZiJieGouCrudId, '数据记录', 'auto_create', '[\"create\",\"update\"]', 999, @gongZiJiLuCrudId, 0, 0, '[]', '[]', '[]', '', '[{\"form_field_uniqid\":\"gongzitiaojilu.qitabutie\",\"operator\":\"field_value\",\"to_form_field_uniqid\":\"qitabutie\"},{\"form_field_uniqid\":\"gongzitiaojilu.jinengbutie\",\"operator\":\"field_value\",\"to_form_field_uniqid\":\"jinengbutie\"},{\"form_field_uniqid\":\"gongzitiaojilu.guanlijintie\",\"operator\":\"field_value\",\"to_form_field_uniqid\":\"guanlijintie\"},{\"form_field_uniqid\":\"gongzitiaojilu.gangweigongzi\",\"operator\":\"field_value\",\"to_form_field_uniqid\":\"gangweigongzi\"},{\"form_field_uniqid\":\"gongzitiaojilu.jixiaogongzi\",\"operator\":\"field_value\",\"to_form_field_uniqid\":\"jixiaogongzi\"},{\"form_field_uniqid\":\"gongzitiaojilu.jibengongzi\",\"operator\":\"field_value\",\"to_form_field_uniqid\":\"jibengongzi\"},{\"form_field_uniqid\":\"gongzitiaojilu.tiaoxinbeizhu\",\"operator\":\"field_value\",\"to_form_field_uniqid\":\"tiaoxinbeizhu\"},{\"form_field_uniqid\":\"gongzitiaojilu.yuangong\",\"operator\":\"field_value\",\"to_form_field_uniqid\":\"yuangong\"}]', '[]', '2024-06-14 15:18:48', '2024-06-15 11:30:41', NULL, 1, 0, 0, 0, '[]', 0, '[]', '[]', '[]');

INSERT INTO `eb_system_crud_cate` (`id`, `name`, `sort`, `created_at`, `updated_at`) VALUES(null, '客户', 1, '2024-07-02 02:41:39', '2024-07-02 02:41:39');
SELECT @crudCustomerCateId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud` (`id`, `table_name`, `table_name_en`, `cate_ids`, `info`, `crud_id`, `user_id`, `form_fields`, `is_update_form`, `is_update_table`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, '客户管理', 'customer',  CONCAT('/', @crudCustomerCateId, '/'), '', 0, 0, '', 0, 0, '2024-07-02 02:42:14', '2024-07-02 02:42:14', NULL);
SELECT @customerCrudId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `is_uniqid`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @customerCrudId, '主键ID', 'id', 'input_number', 'int', 0, 0, '主键ID', '', 0, 0, 0, 0, 'customer668369068796c', '', '', 1, 1, 1, 0, '2024-07-02 02:42:14', '2024-07-02 02:42:14', NULL),
(null, @customerCrudId, '创建时间', 'created_at', 'date_time_picker', 'timestamp', 1, 0, '创建时间', 'gongsimingcheng', 0, 0, 0, 0, 'customer6683690687981', '', '', 1, 1, 1, 0, '2024-07-02 02:42:14', '2024-07-02 03:09:40', NULL),
(null, @customerCrudId, '修改时间', 'updated_at', 'date_time_picker', 'timestamp', 1, 0, '修改时间', 'created_at', 0, 0, 0, 0, 'customer6683690687984', '', '', 1, 1, 1, 0, '2024-07-02 02:42:14', '2024-07-02 02:42:14', NULL),
(null, @customerCrudId, '伪删除', 'deleted_at', 'date_time_picker', 'timestamp', 1, 0, '伪删除', 'updated_at', 0, 0, 0, 0, 'customer6683690687986', '', '', 1, 1, 1, 0, '2024-07-02 02:42:14', '2024-07-02 02:42:14', NULL),
(null, @customerCrudId, '业务员', 'uid', 'input_select', 'int', 1, 1, '业务员', 'owner_user_id', 0, 2, 0, 0, 'customer668369b22f9b4', '[\"id\",\"name\",\"account\",\"avatar\"]', '[]', 1, 1, 1, 0, '2024-07-02 02:45:06', '2024-07-02 02:45:06', NULL),
(null, @customerCrudId, '前业务员', 'before_uid', 'input_select', 'int', 1, 1, '前业务员', 'uid', 0, 2, 0, 0, 'customer668369cd01556', '[\"id\",\"name\",\"account\",\"avatar\"]', '[]', 1, 1, 1, 0, '2024-07-02 02:45:33', '2024-07-02 02:45:33', NULL),
(null, @customerCrudId, '客户编号', 'customer_no', 'input', 'varchar', 0, 1, '客户编号', 'before_uid', 0, 0, 0, 0, 'customer66836a04ab376', '[]', '[]', 1, 1, 1, 0, '2024-07-02 02:46:28', '2024-07-02 02:46:28', NULL),
(null, @customerCrudId, '未跟进天数', 'un_followed_days', 'input_number', 'int', 1, 1, '未跟进天数', 'customer_no', 0, 0, 0, 0, 'customer66836a133b2d3', '[]', '[]', 1, 1, 1, 0, '2024-07-02 02:46:43', '2024-07-02 02:46:43', NULL),
(null, @customerCrudId, '已入账金额', 'amount_recorded', 'input_price', 'decimal', 1, 1, '已入账金额', 'un_followed_days', 0, 0, 0, 0, 'customer66836a2691073', '[]', '{\"precision\":\"2\"}', 1, 1, 1, 0, '2024-07-02 02:47:02', '2024-07-02 02:47:02', NULL),
(null, @customerCrudId, '已支出金额', 'amount_expend', 'input_price', 'decimal', 1, 1, '已支出金额', 'amount_recorded', 0, 0, 0, 0, 'customer66836a345bd66', '[]', '{\"precision\":\"2\"}', 1, 1, 1, 0, '2024-07-02 02:47:16', '2024-07-02 02:47:16', NULL),
(null, @customerCrudId, '已开票金额', 'invoiced_amount', 'input_price', 'decimal', 1, 1, '已开票金额', 'amount_expend', 0, 0, 0, 0, 'customer66836a4ed8bff', '[]', '{\"precision\":\"2\"}', 1, 1, 1, 0, '2024-07-02 02:47:42', '2024-07-02 02:47:42', NULL),
(null, @customerCrudId, '合同数量', 'contract_num', 'input_number', 'int', 1, 1, '合同数量', 'invoiced_amount', 0, 0, 0, 0, 'customer66836a6439b2c', '[]', '[]', 1, 1, 1, 0, '2024-07-02 02:48:04', '2024-07-02 02:48:04', NULL),
(null, @customerCrudId, '发票数量', 'invoice_num', 'input_number', 'int', 1, 1, '发票数量', 'contract_num', 0, 0, 0, 0, 'customer66836a6f53dd8', '[]', '[]', 1, 1, 1, 0, '2024-07-02 02:48:15', '2024-07-02 02:48:15', NULL),
(null, @customerCrudId, '附件数量', 'attachment_num', 'input_number', 'int', 1, 1, '附件数量', 'invoice_num', 0, 0, 0, 0, 'customer66836a7d43919', '[]', '[]', 1, 1, 1, 0, '2024-07-02 02:48:29', '2024-07-02 02:48:29', NULL),
(null, @customerCrudId, '退回次数', 'return_num', 'input_number', 'int', 1, 1, '退回次数', 'attachment_num', 0, 0, 0, 0, 'customer66836a8867d54', '[]', '[]', 1, 1, 1, 0, '2024-07-02 02:48:40', '2024-07-02 02:48:40', NULL),
(null, @customerCrudId, '客户状态', 'customer_status', 'input_number', 'int', 1, 1, '客户状态', 'return_num', 0, 0, 0, 0, 'customer66836ab68b3b2', '[]', '[]', 1, 1, 1, 0, '2024-07-02 02:49:26', '2024-07-02 02:49:26', NULL),
(null, @customerCrudId, '客户名称', 'customer_name', 'input', 'varchar', 1, 1, '客户名称', 'customer_status', 0, 0, 1, 0, 'customer66836ac1d7720', '[]', '[]', 1, 1, 1, 0, '2024-07-02 02:49:37', '2024-07-02 02:49:37', NULL),
(null, @customerCrudId, '客户来源', 'customer_way', 'radio', 'int', 1, 1, '客户来源', 'customer_name', 3, 0, 0, 0, 'customer66836b4724319', '[]', '[]', 1, 1, 1, 0, '2024-07-02 02:51:51', '2024-07-02 02:51:51', NULL),
(null, @customerCrudId, '客户标签', 'customer_label', 'tag', 'varchar', 1, 1, '客户标签', 'customer_way', 0, 0, 0, 0, 'customer66836bfd85117', '[]', '[]', 1, 1, 1, 0, '2024-07-02 02:54:53', '2024-07-02 02:54:53', NULL),
(null, @customerCrudId, '企业电话', 'b37a3f16', 'input', 'varchar', 1, 1, '企业电话', 'customer_label', 0, 0, 0, 0, 'customer66836d948ff1a', '[]', '[]', 1, 1, 1, 0, '2024-07-02 03:01:40', '2024-07-02 03:01:40', NULL),
(null, @customerCrudId, '省市区', 'area_cascade', 'cascader_address', 'varchar', 1, 1, '省市区', 'b37a3f16', 0, 0, 0, 0, 'customer66836f046d221', '[]', '{\"is_city_show\":\"region\"}', 1, 1, 1, 0, '2024-07-02 03:07:48', '2024-07-02 03:07:48', NULL),
(null, @customerCrudId, '详细地址', '9bfe77e4', 'input', 'varchar', 1, 1, '详细地址', 'area_cascade', 0, 0, 0, 0, 'customer66836f1af3e96', '[]', '[]', 1, 1, 1, 0, '2024-07-02 03:08:10', '2024-07-02 03:08:10', NULL),
(null, @customerCrudId, '备注', 'c839a357', 'textarea', 'text', 1, 1, '备注', 'xiangxidizhi', 0, 0, 0, 0, 'customer66836f5b8ffea', '[]', '[]', 1, 1, 1, 0, '2024-07-02 03:09:15', '2024-07-02 03:09:15', NULL);

INSERT INTO `eb_system_crud` (`id`, `table_name`, `table_name_en`, `cate_ids`, `info`, `crud_id`, `user_id`, `form_fields`, `is_update_form`, `is_update_table`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, '合同管理', 'contract', CONCAT('/', @crudCustomerCateId, '/'), '', 0, 0, '[\"contract_name\",\"contract_no\",\"contract_price\",\"eid\",\"start_date\",\"end_date\",\"signing_status\",\"b3733f36\",\"contract_cate\"]', 0, 0, '2024-07-02 03:11:56', '2024-09-06 07:48:34', NULL);
SELECT @contractCrudId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `is_uniqid`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @contractCrudId, '主键ID', 'id', 'input_number', 'int', 0, 0, '主键ID', '', 0, 0, 0, 0, 'contract66836ffc7174f', '', '', 1, 1, 1, 0, '2024-07-02 03:11:56', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '创建时间', 'created_at', 'date_time_picker', 'timestamp', 1, 0, '创建时间', 'ceshiyixiatag', 0, 0, 0, 0, 'contract66836ffc71764', '', '', 1, 1, 1, 0, '2024-07-02 03:11:56', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '修改时间', 'updated_at', 'date_time_picker', 'timestamp', 1, 0, '修改时间', 'created_at', 0, 0, 0, 0, 'contract66836ffc71767', '', '', 1, 1, 1, 0, '2024-07-02 03:11:56', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '伪删除', 'deleted_at', 'date_time_picker', 'timestamp', 1, 0, '伪删除', 'updated_at', 0, 0, 0, 0, 'contract66836ffc7176a', '', '', 1, 1, 1, 0, '2024-07-02 03:11:56', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '业务员', 'uid', 'input_select', 'int', 1, 1, '业务员', 'owner_user_id', 0, 2, 0, 0, 'contract668379677469b', '[\"id\",\"name\",\"account\",\"avatar\"]', '[]', 1, 1, 1, 0, '2024-07-02 03:52:07', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '客户', 'eid', 'input_select', 'int', 1, 1, '客户', 'uid', 0, @customerCrudId, 0, 1, 'contract6683798700b68', '[\"id\",\"customer_no\",\"customer_name\"]', '[]', 1, 1, 1, 0, '2024-07-02 03:52:39', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '创建人', 'creator_uid', 'input_select', 'int', 1, 1, '创建人', 'eid', 0, 2, 0, 0, 'contract6683799b47fda', '[\"id\",\"name\",\"account\",\"avatar\"]', '[]', 1, 1, 1, 0, '2024-07-02 03:52:59', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '合同编号', 'contract_no', 'input', 'varchar', 1, 1, '合同编号', 'creator_uid', 0, 0, 1, 1, 'contract668379d8b2af1', '[]', '[]', 1, 1, 1, 0, '2024-07-02 03:54:00', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '是否有续费', 'renew', 'switch', 'tinyint', 1, 1, '是否有续费', 'contract_no', 0, 0, 0, 0, 'contract66837a1a813e6', '[]', '[]', 1, 1, 1, 0, '2024-07-02 03:55:06', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '已收款', 'received', 'input_price', 'decimal', 1, 1, '已收款', 'renew', 0, 0, 0, 0, 'contract66837a2719814', '[]', '{\"precision\":\"2\"}', 1, 1, 1, 0, '2024-07-02 03:55:19', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '待回款金额', 'surplus', 'input_price', 'decimal', 1, 1, '待回款金额', 'received', 0, 0, 0, 0, 'contract66837a3311a57', '[]', '{\"precision\":\"2\"}', 1, 1, 1, 0, '2024-07-02 03:55:31', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '合同状态', 'contract_status', 'radio', 'int', 1, 1, '合同状态', 'surplus', 6, 0, 0, 0, 'contract66837a55b9d7b', '[]', '[]', 1, 1, 1, 0, '2024-07-02 03:56:05', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '备注', 'b3733f36', 'textarea', 'text', 1, 1, '备注', 'contract_status', 0, 0, 0, 1, 'contract66837ab519375', '[]', '[]', 1, 1, 1, 0, '2024-07-02 03:57:41', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '合同金额', 'contract_price', 'input_price', 'decimal', 1, 1, '合同金额', 'beizhu', 0, 0, 0, 1, 'contract66837ad830aac', '[]', '{\"precision\":\"2\"}', 1, 1, 1, 0, '2024-07-02 03:58:16', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '合同名称', 'contract_name', 'input', 'varchar', 1, 1, '合同名称', 'contract_price', 0, 0, 0, 1, 'contract66837ae7bd849', '[]', '[]', 1, 1, 1, 0, '2024-07-02 03:58:31', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '开始时间', 'start_date', 'date_picker', 'date', 1, 1, '开始时间', 'contract_name', 0, 0, 0, 1, 'contract66837afa11d6d', '[]', '[]', 1, 1, 1, 0, '2024-07-02 03:58:50', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '结束时间', 'end_date', 'date_picker', 'date', 1, 1, '结束时间', 'start_date', 0, 0, 0, 1, 'contract66837b080984d', '[]', '[]', 1, 1, 1, 0, '2024-07-02 03:59:04', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '签约状态', 'signing_status', 'radio', 'int', 1, 1, '签约状态', 'end_date', 10, 0, 0, 1, 'contract66837b194282e', '[]', '[]', 1, 1, 1, 0, '2024-07-02 03:59:21', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '是否异常', 'is_abnormal', 'switch', 'tinyint', 1, 1, '是否异常', 'signing_status', 0, 0, 0, 0, 'contract66837b2ceb11d', '[]', '[]', 1, 1, 1, 0, '2024-07-02 03:59:40', '2024-09-06 07:48:34', NULL),
(null, @contractCrudId, '合同分类', 'contract_cate', 'cascader_radio', 'varchar', 1, 1, '合同分类', 'is_abnormal', 9, 0, 0, 1, 'contract668b982c43b7b', '[]', '[]', 1, 1, 1, 0, '2024-07-08 07:41:32', '2024-09-06 07:48:34', NULL);

INSERT INTO `eb_system_crud_form` (`id`, `crud_id`, `version`, `options`, `fields`, `global_options`, `is_index`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @contractCrudId, 1, '[{\"name\":\"\\u5408\\u540c\\u540d\\u79f0\",\"type\":\"input\",\"icon\":\"text-field\",\"formItemFlag\":true,\"options\":{\"name\":\"contract_name\",\"label\":\"\\u5408\\u540c\\u540d\\u79f0\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":\"\",\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":false,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":\"\",\"labelIconPosition\":\"rear\",\"labelTooltip\":\"\",\"minLength\":\"300\",\"maxLength\":\"300\",\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":\"0\",\"fieldId\":\"184\",\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"formFieldUniqid\":\"contract_name\",\"isCityShow\":\"\"},\"hide\":false,\"id\":\"input26386\",\"i\":\"12\",\"pidx\":\"0\"},{\"name\":\"\\u5408\\u540c\\u7f16\\u53f7\",\"type\":\"input\",\"icon\":\"text-field\",\"formItemFlag\":true,\"options\":{\"name\":\"contract_no\",\"label\":\"\\u5408\\u540c\\u7f16\\u53f7\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":\"\",\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":false,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":\"\",\"labelIconPosition\":\"rear\",\"labelTooltip\":\"\",\"minLength\":\"300\",\"maxLength\":\"300\",\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":\"0\",\"fieldId\":\"177\",\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"formFieldUniqid\":\"contract_no\",\"isCityShow\":\"\"},\"hide\":false,\"id\":\"input50987\",\"i\":\"5\",\"pidx\":\"0\"},{\"name\":\"\\u5408\\u540c\\u5206\\u7c7b\",\"type\":\"cascader-radio\",\"icon\":\"cascader-field\",\"formItemFlag\":true,\"options\":{\"name\":\"contract_cate\",\"label\":\"\\u5408\\u540c\\u5206\\u7c7b\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":false,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":300,\"maxLength\":300,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":9,\"fieldId\":269,\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"filterable\":false,\"multiple\":false,\"disableMultiple\":true,\"checkStrictly\":false,\"showAllLevels\":true,\"optionItems\":[],\"formFieldUniqid\":\"contract_cate\"},\"hide\":true,\"id\":\"cascaderradio113070\",\"i\":17,\"pidx\":0},{\"name\":\"\\u5408\\u540c\\u91d1\\u989d\",\"type\":\"input-price\",\"icon\":\"number-field\",\"formItemFlag\":true,\"options\":{\"name\":\"contract_price\",\"label\":\"\\u5408\\u540c\\u91d1\\u989d\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":\"\",\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":false,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":\"\",\"labelIconPosition\":\"rear\",\"labelTooltip\":\"\",\"minLength\":\"300\",\"maxLength\":\"300\",\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":\"0\",\"fieldId\":\"183\",\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"keyNameEnabled\":false,\"keyName\":\"\",\"min\":-100000000000,\"max\":100000000000,\"precision\":2,\"step\":1,\"formFieldUniqid\":\"contract_price\",\"isCityShow\":\"\"},\"hide\":false,\"id\":\"inputprice103349\",\"i\":\"11\",\"pidx\":\"0\"},{\"name\":\"\\u5ba2\\u6237\",\"type\":\"input-select\",\"icon\":\"reference-field\",\"formItemFlag\":true,\"options\":{\"name\":\"eid\",\"label\":\"\\u5ba2\\u6237\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":\"\",\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":false,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":\"\",\"labelIconPosition\":\"rear\",\"labelTooltip\":\"\",\"minLength\":\"300\",\"maxLength\":\"300\",\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":\"0\",\"fieldId\":\"175\",\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"buttonText\":\"\\u9009\\u62e9\",\"formFieldUniqid\":\"eid\",\"isCityShow\":\"\"},\"hide\":false,\"id\":\"inputselect88121\",\"i\":\"3\",\"pidx\":\"0\"},{\"name\":\"\\u5f00\\u59cb\\u65f6\\u95f4\",\"type\":\"date-picker\",\"icon\":\"date-field\",\"formItemFlag\":true,\"options\":{\"name\":\"start_date\",\"label\":\"\\u5f00\\u59cb\\u65f6\\u95f4\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":\"\",\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":false,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":\"\",\"labelIconPosition\":\"rear\",\"labelTooltip\":\"\",\"minLength\":\"300\",\"maxLength\":\"300\",\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":\"0\",\"fieldId\":\"185\",\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"editable\":false,\"format\":\"yyyy-MM-dd\",\"valueFormat\":\"yyyy-MM-dd\",\"formFieldUniqid\":\"start_date\",\"isCityShow\":\"\"},\"hide\":false,\"id\":\"datepicker74084\",\"i\":\"13\",\"pidx\":\"0\"},{\"name\":\"\\u7ed3\\u675f\\u65f6\\u95f4\",\"type\":\"date-picker\",\"icon\":\"date-field\",\"formItemFlag\":true,\"options\":{\"name\":\"end_date\",\"label\":\"\\u7ed3\\u675f\\u65f6\\u95f4\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":\"\",\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":false,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":\"\",\"labelIconPosition\":\"rear\",\"labelTooltip\":\"\",\"minLength\":\"300\",\"maxLength\":\"300\",\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":\"0\",\"fieldId\":\"186\",\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"editable\":false,\"format\":\"yyyy-MM-dd\",\"valueFormat\":\"yyyy-MM-dd\",\"formFieldUniqid\":\"end_date\",\"isCityShow\":\"\"},\"hide\":false,\"id\":\"datepicker42838\",\"i\":\"14\",\"pidx\":\"0\"},{\"name\":\"\\u7b7e\\u7ea6\\u72b6\\u6001\",\"type\":\"radio\",\"icon\":\"radio-field\",\"formItemFlag\":true,\"options\":{\"name\":\"signing_status\",\"label\":\"\\u7b7e\\u7ea6\\u72b6\\u6001\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":\"\",\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":false,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":\"\",\"labelIconPosition\":\"rear\",\"labelTooltip\":\"\",\"minLength\":\"300\",\"maxLength\":\"300\",\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":\"10\",\"fieldId\":\"187\",\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"displayStyle\":\"inline\",\"buttonStyle\":false,\"border\":false,\"optionItems\":[{\"id\":3987,\"name\":\"\\u672a\\u7b7e\\u7ea6\",\"value\":\"0\",\"pid\":\"\",\"type_id\":10,\"type_name\":\"signing_status\",\"level\":1,\"sort\":0,\"status\":1,\"is_default\":1,\"mark\":\"\",\"created_at\":\"2023-11-24 03:42:20\",\"updated_at\":\"2023-11-24 03:42:20\",\"checkbox\":false},{\"id\":3988,\"name\":\"\\u5df2\\u7b7e\\u7ea6\",\"value\":\"1\",\"pid\":\"\",\"type_id\":10,\"type_name\":\"signing_status\",\"level\":1,\"sort\":0,\"status\":1,\"is_default\":1,\"mark\":\"\",\"created_at\":\"2023-11-24 03:42:20\",\"updated_at\":\"2023-11-24 03:42:20\",\"checkbox\":false},{\"id\":3989,\"name\":\"\\u4f5c\\u5e9f\",\"value\":\"2\",\"pid\":\"\",\"type_id\":10,\"type_name\":\"signing_status\",\"level\":1,\"sort\":0,\"status\":1,\"is_default\":1,\"mark\":\"\",\"created_at\":\"2023-11-24 03:42:20\",\"updated_at\":\"2023-11-24 03:42:20\",\"checkbox\":false}],\"formFieldUniqid\":\"signing_status\",\"isCityShow\":\"\"},\"hide\":false,\"id\":\"radio31339\",\"i\":\"15\",\"pidx\":\"0\"},{\"name\":\"\\u5907\\u6ce8\",\"type\":\"textarea\",\"icon\":\"textarea-field\",\"formItemFlag\":true,\"options\":{\"name\":\"b3733f36\",\"label\":\"\\u5907\\u6ce8\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":\"\",\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":false,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":\"\",\"labelIconPosition\":\"rear\",\"labelTooltip\":\"\",\"minLength\":\"300\",\"maxLength\":\"300\",\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":\"0\",\"fieldId\":\"182\",\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"rows\":\"3\",\"formFieldUniqid\":\"b3733f36\",\"isCityShow\":\"\"},\"hide\":false,\"id\":\"textarea34080\",\"i\":\"10\",\"pidx\":\"0\"}]', '[\"contract_name\",\"contract_no\",\"contract_price\",\"eid\",\"start_date\",\"end_date\",\"signing_status\",\"b3733f36\",\"contract_cate\"]', '{\"modelName\":\"formData\",\"refName\":\"vForm\",\"rulesName\":\"rules\",\"labelWidth\":80,\"labelPosition\":\"left\",\"size\":\"small\",\"labelAlign\":\"label-left-align\",\"cssCode\":\"\",\"customClass\":[],\"functions\":\"\",\"layoutType\":\"PC\",\"onFormCreated\":\"\",\"onFormMounted\":\"\",\"onFormDataChange\":\"\"}', 1, '2024-09-06 07:48:34', '2024-09-06 07:48:34', NULL);


INSERT INTO `eb_system_crud` (`id`, `table_name`, `table_name_en`, `cate_ids`, `info`, `crud_id`, `user_id`, `form_fields`, `is_update_form`, `is_update_table`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, '联系人', 'customer_liaison', CONCAT('/', @crudCustomerCateId, '/'), '', 0, 0, '', 0, 0, '2024-07-02 03:12:15', '2024-07-02 03:15:18', NULL);
SELECT @customerLiaisonCrudId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `is_uniqid`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @customerLiaisonCrudId, '主键ID', 'id', 'input_number', 'int', 0, 0, '主键ID', '', 0, 0, 0, 0, 'customer_liaison6683700f9f32d', '', '', 1, 1, 1, 0, '2024-07-02 03:12:15', '2024-07-02 03:12:15', NULL),
(null, @customerLiaisonCrudId, '创建时间', 'created_at', 'date_time_picker', 'timestamp', 1, 0, '创建时间', 'lianxirenQQ', 0, 0, 0, 0, 'customer_liaison6683700f9f345', '', '', 1, 1, 1, 0, '2024-07-02 03:12:15', '2024-07-02 04:08:48', NULL),
(null, @customerLiaisonCrudId, '修改时间', 'updated_at', 'date_time_picker', 'timestamp', 1, 0, '修改时间', 'created_at', 0, 0, 0, 0, 'customer_liaison6683700f9f348', '', '', 1, 1, 1, 0, '2024-07-02 03:12:15', '2024-07-02 03:12:15', NULL),
(null, @customerLiaisonCrudId, '伪删除', 'deleted_at', 'date_time_picker', 'timestamp', 1, 0, '伪删除', 'updated_at', 0, 0, 0, 0, 'customer_liaison6683700f9f34b', '', '', 1, 1, 1, 0, '2024-07-02 03:12:15', '2024-07-02 03:12:15', NULL),
(null, @customerLiaisonCrudId, '业务员', 'uid', 'input_select', 'int', 1, 1, '业务员', 'owner_user_id', 0, 2, 0, 0, 'customer_liaison66837c5dee305', '[\"id\",\"name\",\"account\",\"avatar\"]', '[]', 1, 1, 1, 0, '2024-07-02 04:04:45', '2024-07-02 04:04:45', NULL),
(null, @customerLiaisonCrudId, '客户', 'eid', 'input_select', 'int', 1, 1, '客户', 'uid', 0, @customerCrudId, 0, 0, 'customer_liaison66837c949190d', '[\"id\",\"customer_no\",\"customer_name\"]', '[]', 1, 1, 1, 0, '2024-07-02 04:05:40', '2024-07-02 04:05:40', NULL),
(null, @customerLiaisonCrudId, '创建人', 'creator_uid', 'input_select', 'int', 1, 1, '创建人', 'eid', 0, 2, 0, 0, 'customer_liaison66837caa1d934', '[\"id\",\"name\",\"account\",\"avatar\"]', '[]', 1, 1, 1, 0, '2024-07-02 04:06:02', '2024-07-02 04:06:02', NULL),
(null, @customerLiaisonCrudId, '联系人姓名', 'liaison_name', 'input', 'varchar', 1, 1, '联系人姓名', 'creator_uid', 0, 0, 1, 0, 'customer_liaison66837cb8b5432', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:06:16', '2024-07-02 04:06:16', NULL),
(null, @customerLiaisonCrudId, '联系电话', 'liaison_tel', 'input', 'varchar', 1, 1, '联系电话', 'liaison_name', 0, 0, 0, 0, 'customer_liaison66837cc93f3cd', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:06:33', '2024-07-02 04:06:33', NULL),
(null, @customerLiaisonCrudId, '联系人职位', 'liaison_job', 'input', 'varchar', 1, 1, '联系人职位', 'liaison_tel', 0, 0, 0, 0, 'customer_liaison66837ceaeeb37', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:07:06', '2024-07-02 04:07:06', NULL),
(null, @customerLiaisonCrudId, '性别', 'e06d7153', 'radio', 'int', 1, 1, '性别', 'liaison_job', 7, 0, 0, 0, 'customer_liaison66837d25d83e4', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:08:05', '2024-07-02 04:08:05', NULL),
(null, @customerLiaisonCrudId, '联系人邮箱', 'e06d7152', 'input', 'varchar', 1, 1, '联系人邮箱', 'xingbie', 0, 0, 0, 0, 'customer_liaison66837d31c729e', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:08:17', '2024-07-02 04:08:17', NULL),
(null, @customerLiaisonCrudId, '联系人微信', 'e06d7159', 'input', 'varchar', 1, 1, '联系人微信', 'lianxirenyouxiang', 0, 0, 0, 0, 'customer_liaison66837d39383c0', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:08:25', '2024-07-02 04:08:25', NULL),
(null, @customerLiaisonCrudId, '备注', 'l753bf282', 'textarea', 'text', 1, 1, '备注', 'lianxirenweixin', 0, 0, 0, 0, 'customer_liaison66837d41925ed', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:08:33', '2024-07-02 04:08:33', NULL),
(null, @customerLiaisonCrudId, '联系人QQ', 'cdc4d06a', 'input', 'varchar', 1, 1, '联系人QQ', 'beizhu', 0, 0, 0, 0, 'customer_liaison66837d508e5e2', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:08:48', '2024-07-02 04:08:48', NULL);

INSERT INTO `eb_system_crud` (`id`, `table_name`, `table_name_en`, `cate_ids`, `info`, `crud_id`, `user_id`, `form_fields`, `is_update_form`, `is_update_table`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, '账目记录', 'client_bill', CONCAT('/', @crudCustomerCateId, '/'), '', 0, 0, '', 0, 0, '2024-07-02 03:12:50', '2024-07-02 03:12:50', NULL);
SELECT @clientBillCrudId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `is_uniqid`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @clientBillCrudId, '主键ID', 'id', 'input_number', 'int', 0, 0, '主键ID', '', 0, 0, 0, 0, 'client_bill66837032cde00', '', '', 1, 1, 1, 0, '2024-07-02 03:12:50', '2024-07-02 03:12:50', NULL),
(null, @clientBillCrudId, '创建时间', 'created_at', 'date_time_picker', 'timestamp', 1, 0, '创建时间', 'fail_msg', 0, 0, 0, 0, 'client_bill66837032cde24', '', '', 1, 1, 1, 0, '2024-07-02 03:12:50', '2024-07-02 04:16:54', NULL),
(null, @clientBillCrudId, '修改时间', 'updated_at', 'date_time_picker', 'timestamp', 1, 0, '修改时间', 'created_at', 0, 0, 0, 0, 'client_bill66837032cde29', '', '', 1, 1, 1, 0, '2024-07-02 03:12:50', '2024-07-02 03:12:50', NULL),
(null, @clientBillCrudId, '客户', 'eid', 'input_select', 'int', 1, 1, '客户', 'owner_user_id', 0, @customerCrudId, 0, 0, 'client_bill66837dfae5436', '[\"id\",\"customer_no\",\"customer_name\"]', '[]', 1, 1, 1, 0, '2024-07-02 04:11:38', '2024-07-02 04:11:38', NULL),
(null, @clientBillCrudId, '合同', 'cid', 'input_select', 'int', 1, 1, '合同', 'eid', 0, @contractCrudId, 0, 0, 'client_bill66837e0ef2947', '[\"id\",\"contract_name\"]', '[]', 1, 1, 1, 0, '2024-07-02 04:11:58', '2024-07-02 04:11:58', NULL),
(null, @clientBillCrudId, '续费类型', 'bill_types', 'radio', 'int', 1, 1, '续费类型', 'cid', 8, 0, 0, 0, 'client_bill66837e3642258', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:12:38', '2024-07-02 04:12:38', NULL),
(null, @clientBillCrudId, '业务员', 'uid', 'input_select', 'int', 1, 1, '业务员', 'bill_types', 0, 2, 0, 0, 'client_bill66837e4db001f', '[\"id\",\"name\",\"account\",\"avatar\"]', '[]', 1, 1, 1, 0, '2024-07-02 04:13:01', '2024-07-02 04:13:01', NULL),
(null, @clientBillCrudId, '金额', 'num', 'input_price', 'decimal', 1, 1, '金额', 'uid', 0, 0, 0, 0, 'client_bill66837e775cb18', '[]', '{\"precision\":\"2\"}', 1, 1, 1, 0, '2024-07-02 04:13:43', '2024-07-02 04:13:43', NULL),
(null, @clientBillCrudId, '备注', 'mark', 'textarea', 'text', 1, 1, '备注', 'num', 0, 0, 0, 0, 'client_bill66837e8145d2c', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:13:53', '2024-07-02 04:13:53', NULL),
(null, @clientBillCrudId, '账目类型', 'types', 'radio', 'int', 1, 1, '账目类型', 'mark', 8, 0, 0, 0, 'client_bill66837eca9fb22', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:15:06', '2024-07-02 04:15:06', NULL),
(null, @clientBillCrudId, '支付方式名称', 'pay_type', 'input', 'varchar', 1, 1, '支付方式名称', 'types', 0, 0, 1, 0, 'client_bill66837ee16b2f5', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:15:29', '2024-07-02 04:15:29', NULL),
(null, @clientBillCrudId, '收款日期', 'date', 'date_picker', 'date', 1, 1, '收款日期', 'pay_type', 0, 0, 0, 0, 'client_bill66837eed17a44', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:15:41', '2024-07-02 04:15:41', NULL),
(null, @clientBillCrudId, '结束收款日期', 'end_date', 'date_picker', 'date', 1, 1, '结束收款日期', 'date', 0, 0, 0, 0, 'client_bill66837efad0766', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:15:54', '2024-07-02 04:15:54', NULL),
(null, @clientBillCrudId, '付款单号', 'bill_no', 'input', 'varchar', 1, 1, '付款单号', 'end_date', 0, 0, 0, 0, 'client_bill66837f0c00669', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:16:12', '2024-07-02 04:16:12', NULL),
(null, @clientBillCrudId, '状态', 'status', 'input_number', 'int', 1, 1, '状态', 'bill_no', 0, 0, 0, 0, 'client_bill66837f283e47e', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:16:40', '2024-07-02 04:16:40', NULL),
(null, @clientBillCrudId, '失败原因', 'fail_msg', 'input', 'varchar', 1, 1, '失败原因', 'status', 0, 0, 0, 0, 'client_bill66837f36617c7', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:16:54', '2024-07-02 04:16:54', NULL);

INSERT INTO `eb_system_crud` (`id`, `table_name`, `table_name_en`, `cate_ids`, `info`, `crud_id`, `user_id`, `form_fields`, `is_update_form`, `is_update_table`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, '跟进记录', 'client_follow', CONCAT('/', @crudCustomerCateId, '/'), '', 0, 0, '', 0, 0, '2024-07-02 03:13:33', '2024-07-02 03:13:33', NULL);
SELECT @clientFollowCrudId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `is_uniqid`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @clientFollowCrudId, '主键ID', 'id', 'input_number', 'int', 0, 0, '主键ID', '', 0, 0, 0, 0, 'client_follow6683705de8f3a', '', '', 1, 1, 1, 0, '2024-07-02 03:13:33', '2024-07-02 03:13:33', NULL),
(null, @clientFollowCrudId, '业务员', 'user_id', 'input_select', 'int', 1, 0, '创建用户', 'id', 0, 2, 0, 0, 'client_follow6683705de8f42', '', '', 1, 1, 1, 0, '2024-07-02 03:13:33', '2024-07-02 03:13:33', NULL),
(null, @clientFollowCrudId, '创建时间', 'created_at', 'date_time_picker', 'timestamp', 1, 0, '创建时间', 'follow_version', 0, 0, 0, 0, 'client_follow6683705de8f4e', '', '', 1, 1, 1, 0, '2024-07-02 03:13:33', '2024-07-02 06:32:06', NULL),
(null, @clientFollowCrudId, '修改时间', 'updated_at', 'date_time_picker', 'timestamp', 1, 0, '修改时间', 'created_at', 0, 0, 0, 0, 'client_follow6683705de8f51', '', '', 1, 1, 1, 0, '2024-07-02 03:13:33', '2024-07-02 03:13:33', NULL),
(null, @clientFollowCrudId, '伪删除', 'deleted_at', 'date_time_picker', 'timestamp', 1, 0, '伪删除', 'updated_at', 0, 0, 0, 0, 'client_follow6683705de8f54', '', '', 1, 1, 1, 0, '2024-07-02 03:13:33', '2024-07-02 03:13:33', NULL),
(null, @clientFollowCrudId, '客户', 'eid', 'input_select', 'int', 1, 1, '客户', 'owner_user_id', 0, @customerCrudId, 0, 0, 'client_follow66837f9f9f315', '[\"id\",\"customer_no\",\"customer_name\"]', '[]', 1, 1, 1, 0, '2024-07-02 04:18:39', '2024-07-02 04:18:39', NULL),
(null, @clientFollowCrudId, '说明内容', 'content', 'textarea', 'text', 1, 1, '说明内容', 'eid', 0, 0, 0, 0, 'client_follow66837fe11ae58', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:19:45', '2024-07-02 04:19:45', NULL),
(null, @clientFollowCrudId, '类型', 'types', 'input_number', 'int', 1, 1, '类型', 'content', 0, 0, 0, 0, 'client_follow66837ffd66a5b', '[]', '[]', 1, 1, 1, 0, '2024-07-02 04:20:13', '2024-07-02 04:20:13', NULL),
(null, @clientFollowCrudId, '提醒时间', 'time', 'date_time_picker', 'timestamp', 1, 1, '提醒时间', 'types', 0, 0, 0, 0, 'client_follow66839ea0691d8', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:30:56', '2024-07-02 06:30:56', NULL),
(null, @clientFollowCrudId, '定时任务唯一值', 'uniqued', 'input', 'varchar', 1, 1, '定时任务唯一值', 'time', 0, 0, 1, 0, 'client_follow66839eb816cd4', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:31:20', '2024-07-02 06:31:20', NULL),
(null, @clientFollowCrudId, '状态', 'status', 'input_number', 'int', 1, 1, '状态', 'uniqued', 0, 0, 0, 0, 'client_follow66839ed30ec67', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:31:47', '2024-07-02 06:31:47', NULL),
(null, @clientFollowCrudId, '跟进版本', 'follow_version', 'input_number', 'int', 1, 1, '跟进版本', 'status', 0, 0, 0, 0, 'client_follow66839ee60f0ec', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:32:06', '2024-07-02 06:32:06', NULL);

INSERT INTO `eb_system_crud` (`id`, `table_name`, `table_name_en`, `cate_ids`, `info`, `crud_id`, `user_id`, `form_fields`, `is_update_form`, `is_update_table`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, '付款提醒', 'client_remind',CONCAT('/', @crudCustomerCateId, '/'), '', 0, 0, '', 0, 0, '2024-07-02 03:13:55', '2024-07-02 03:13:55', NULL);
SELECT @clientRemindCrudId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `is_uniqid`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @clientRemindCrudId, '主键ID', 'id', 'input_number', 'int', 0, 0, '主键ID', '', 0, 0, 0, 0, 'client_remind668370731a12e', '', '', 1, 1, 1, 0, '2024-07-02 03:13:55', '2024-07-02 03:13:55', NULL),
(null, @clientRemindCrudId, '业务员', 'user_id', 'input_select', 'int', 1, 0, '创建用户', 'id', 0, 2, 0, 0, 'client_remind668370731a136', '', '', 1, 1, 1, 0, '2024-07-02 03:13:55', '2024-07-02 03:13:55', NULL),
(null, @clientRemindCrudId, '创建时间', 'created_at', 'date_time_picker', 'timestamp', 1, 0, '创建时间', 'status', 0, 0, 0, 0, 'client_remind668370731a141', '', '', 1, 1, 1, 0, '2024-07-02 03:13:55', '2024-07-02 06:41:57', NULL),
(null, @clientRemindCrudId, '修改时间', 'updated_at', 'date_time_picker', 'timestamp', 1, 0, '修改时间', 'created_at', 0, 0, 0, 0, 'client_remind668370731a144', '', '', 1, 1, 1, 0, '2024-07-02 03:13:55', '2024-07-02 03:13:55', NULL),
(null, @clientRemindCrudId, '伪删除', 'deleted_at', 'date_time_picker', 'timestamp', 1, 0, '伪删除', 'updated_at', 0, 0, 0, 0, 'client_remind668370731a147', '', '', 1, 1, 1, 0, '2024-07-02 03:13:55', '2024-07-02 03:13:55', NULL),
(null, @clientRemindCrudId, '客户', 'eid', 'input_select', 'int', 1, 1, '客户', 'owner_user_id', 0, @customerCrudId, 0, 0, 'client_remind66837849eeadc', '[\"id\",\"customer_name\",\"customer_no\"]', '[]', 1, 1, 1, 0, '2024-07-02 03:47:21', '2024-07-02 03:47:21', NULL),
(null, @clientRemindCrudId, '合同', 'cid', 'input_select', 'int', 1, 1, '合同', 'eid', 0, @contractCrudId, 0, 0, 'client_remind66839f8814794', '[\"id\",\"contract_name\"]', '[]', 1, 1, 1, 0, '2024-07-02 06:34:48', '2024-07-02 06:34:48', NULL),
(null, @clientRemindCrudId, '续费类型', 'cate_id', 'radio', 'int', 1, 1, '续费类型', 'cid', 8, 0, 0, 0, 'client_remind66839fca3f1ce', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:35:54', '2024-07-02 06:35:54', NULL),
(null, @clientRemindCrudId, '付款单', 'bill_id', 'input_select', 'int', 1, 1, '付款单', 'cate_id', 0, 9, 0, 0, 'client_remind66839ffd6306c', '[\"id\"]', '[]', 1, 1, 1, 0, '2024-07-02 06:36:45', '2024-07-02 06:36:45', NULL),
(null, @clientRemindCrudId, '金额', 'num', 'input_price', 'decimal', 1, 1, '金额', 'bill_id', 0, 0, 0, 0, 'client_remind6683a00844619', '[]', '{\"precision\":\"2\"}', 1, 1, 1, 0, '2024-07-02 06:36:56', '2024-07-02 06:36:56', NULL),
(null, @clientRemindCrudId, '备注', 'mark', 'textarea', 'text', 1, 1, '备注', 'num', 0, 0, 0, 0, 'client_remind6683a0148da49', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:37:08', '2024-07-02 06:37:08', NULL),
(null, @clientRemindCrudId, '提醒时间', 'time', 'date_time_picker', 'timestamp', 1, 1, '提醒时间', 'mark', 0, 0, 0, 0, 'client_remind6683a024e12ac', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:37:24', '2024-07-02 06:37:24', NULL),
(null, @clientRemindCrudId, '本期时间', 'this_period', 'date_time_picker', 'timestamp', 1, 1, '本期时间', 'time', 0, 0, 0, 0, 'client_remind6683a03209c08', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:37:38', '2024-07-02 06:37:38', NULL),
(null, @clientRemindCrudId, '下期时间', 'next_period', 'date_time_picker', 'timestamp', 1, 1, '下期时间', 'this_period', 0, 0, 0, 0, 'client_remind6683a043719d9', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:37:55', '2024-07-02 06:37:55', NULL),
(null, @clientRemindCrudId, '定时任务唯一值', 'uniqued', 'input', 'varchar', 1, 1, '定时任务唯一值', 'next_period', 0, 0, 1, 0, 'client_remind6683a05264856', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:38:10', '2024-07-02 06:38:10', NULL),
(null, @clientRemindCrudId, '重复频率', 'rate', 'input_number', 'int', 1, 1, '重复频率', 'uniqued', 0, 0, 0, 0, 'client_remind6683a061138b2', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:38:25', '2024-07-02 06:38:25', NULL),
(null, @clientRemindCrudId, '重复周期', 'period', 'input_number', 'int', 1, 1, '重复周期', 'rate', 0, 0, 0, 0, 'client_remind6683a06f3b3ec', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:38:39', '2024-07-02 06:38:39', NULL),
(null, @clientRemindCrudId, '回款续费类型', 'types', 'input_number', 'int', 1, 1, '回款续费类型', 'period', 0, 0, 0, 0, 'client_remind6683a11847e0c', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:41:28', '2024-07-02 06:41:28', NULL),
(null, @clientRemindCrudId, '状态', 'status', 'input_number', 'int', 1, 1, '状态', 'types', 0, 0, 0, 0, 'client_remind6683a13570d16', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:41:57', '2024-07-02 06:41:57', NULL);

INSERT INTO `eb_system_crud` (`id`, `table_name`, `table_name_en`, `cate_ids`, `info`, `crud_id`, `user_id`, `form_fields`, `is_update_form`, `is_update_table`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, '客户关注', 'client_subscribe', CONCAT('/', @crudCustomerCateId, '/'), '', 0, 0, '', 0, 0, '2024-07-02 03:14:10', '2024-07-02 03:14:10', NULL);
SELECT @clientSubscribeCrudId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `is_uniqid`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @clientSubscribeCrudId, '主键ID', 'id', 'input_number', 'int', 0, 0, '主键ID', '', 0, 0, 0, 0, 'client_subscribe66837082429ed', '', '', 1, 1, 1, 0, '2024-07-02 03:14:10', '2024-07-02 03:14:10', NULL),
(null, @clientSubscribeCrudId, '创建时间', 'created_at', 'date_time_picker', 'timestamp', 1, 0, '创建时间', 'subscribe_status', 0, 0, 0, 0, 'client_subscribe6683708242a04', '', '', 1, 1, 1, 0, '2024-07-02 03:14:10', '2024-07-02 03:44:40', NULL),
(null, @clientSubscribeCrudId, '修改时间', 'updated_at', 'date_time_picker', 'timestamp', 1, 0, '修改时间', 'created_at', 0, 0, 0, 0, 'client_subscribe6683708242a07', '', '', 1, 1, 1, 0, '2024-07-02 03:14:10', '2024-07-02 03:14:10', NULL),
(null, @clientSubscribeCrudId, '用户', 'uid', 'input_select', 'int', 1, 1, '用户', 'id', 0, 2, 0, 0, 'client_subscribe668375c47d28a', '[\"id\",\"name\",\"avatar\",\"account\"]', '[]', 1, 1, 1, 0, '2024-07-02 03:36:36', '2024-07-02 03:36:36', NULL),
(null, @clientSubscribeCrudId, '客户', 'eid', 'input_select', 'int', 1, 1, '客户', 'uid', 0, @customerCrudId, 0, 0, 'client_subscribe6683760ab898a', '[\"id\",\"customer_name\"]', '[]', 1, 1, 1, 0, '2024-07-02 03:37:46', '2024-07-02 03:37:46', NULL),
(null, @clientSubscribeCrudId, '关注状态', 'subscribe_status', 'switch', 'tinyint', 1, 1, '关注状态', 'eid', 0, 0, 0, 0, 'client_subscribe668377a802e5c', '[]', '[]', 1, 1, 1, 0, '2024-07-02 03:44:40', '2024-07-02 03:44:40', NULL);

INSERT INTO `eb_system_crud` (`id`, `table_name`, `table_name_en`, `cate_ids`, `info`, `crud_id`, `user_id`, `form_fields`, `is_update_form`, `is_update_table`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, '动态记录', 'customer_record',CONCAT('/', @crudCustomerCateId, '/'), '', 0, 0, '', 0, 0, '2024-07-02 03:14:34', '2024-07-02 03:14:34', NULL);
SELECT @customerRecordCrudId := LAST_INSERT_ID();
INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `is_uniqid`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @customerRecordCrudId, '主键ID', 'id', 'input_number', 'int', 0, 0, '主键ID', '', 0, 0, 0, 0, 'customer_record6683709a87669', '', '', 1, 1, 1, 0, '2024-07-02 03:14:34', '2024-07-02 03:14:34', NULL),
(null, @customerRecordCrudId, '业务员', 'uid', 'input_select', 'int', 1, 0, '创建用户', 'id', 0, 2, 0, 0, 'customer_record6683709a87680', '', '', 1, 1, 1, 0, '2024-07-02 03:14:34', '2024-07-02 03:14:34', NULL),
(null, @customerRecordCrudId, '创建人', 'creator_uid', 'input_select', 'int', 1, 0, '修改用户', 'user_id', 0, 2, 0, 0, 'customer_record6683709a87683', '', '', 1, 1, 1, 0, '2024-07-02 03:14:34', '2024-07-02 03:14:34', NULL),
(null, @customerRecordCrudId, '创建时间', 'created_at', 'date_time_picker', 'timestamp', 1, 0, '创建时间', 'eid', 0, 0, 0, 0, 'customer_record6683709a8768d', '', '', 1, 1, 1, 0, '2024-07-02 03:14:34', '2024-07-02 06:44:57', NULL),
(null, @customerRecordCrudId, '修改时间', 'updated_at', 'date_time_picker', 'timestamp', 1, 0, '修改时间', 'created_at', 0, 0, 0, 0, 'customer_record6683709a87690', '', '', 1, 1, 1, 0, '2024-07-02 03:14:34', '2024-07-02 03:14:34', NULL),
(null, @customerRecordCrudId, '记录类型', 'type', 'input_number', 'int', 1, 1, '记录类型', 'owner_user_id', 0, 0, 0, 0, 'customer_record6683a18a5a831', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:43:22', '2024-07-02 06:43:22', NULL),
(null, @customerRecordCrudId, '原因', 'reason', 'textarea', 'text', 1, 1, '原因', 'type', 0, 0, 0, 0, 'customer_record6683a19aba532', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:43:38', '2024-07-02 06:43:38', NULL),
(null, @customerRecordCrudId, '记录版本', 'record_version', 'input_number', 'int', 1, 1, '记录版本', 'reason', 0, 0, 0, 0, 'customer_record6683a1ad9dbd8', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:43:57', '2024-07-02 06:43:57', NULL),
(null, @customerRecordCrudId, '客户', 'eid', 'input_select', 'int', 1, 1, '客户', 'record_version', 0, @customerCrudId, 0, 0, 'customer_record6683a1e9a12f8', '[\"id\",\"customer_no\",\"customer_name\"]', '[]', 1, 1, 1, 0, '2024-07-02 06:44:57', '2024-07-02 06:44:57', NULL);

INSERT INTO `eb_system_crud` (`id`, `table_name`, `table_name_en`, `cate_ids`, `info`, `crud_id`, `user_id`, `form_fields`, `is_update_form`, `is_update_table`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, '发票', 'client_invoice', CONCAT('/', @crudCustomerCateId, '/'), '', 0, 0, '', 0, 0, '2024-07-02 03:14:46', '2024-07-02 03:16:03', NULL);
SELECT @clientInvoiceCrudId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `is_uniqid`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @clientInvoiceCrudId, '主键ID', 'id', 'input_number', 'int', 0, 0, '主键ID', '', 0, 0, 0, 0, 'client_invoice668370a6947c5', '', '', 1, 1, 1, 0, '2024-07-02 03:14:46', '2024-07-02 03:14:46', NULL),
(null, @clientInvoiceCrudId, '业务员', 'uid', 'input_select', 'int', 1, 0, '创建用户', 'id', 0, 2, 0, 0, 'client_invoice668370a6947d0', '', '', 1, 1, 1, 0, '2024-07-02 03:14:46', '2024-07-02 03:14:46', NULL),
(null, @clientInvoiceCrudId, '创建时间', 'created_at', 'date_time_picker', 'timestamp', 1, 0, '创建时间', 'serial_number', 0, 0, 0, 0, 'client_invoice668370a6947dc', '', '', 1, 1, 1, 0, '2024-07-02 03:14:46', '2024-07-02 06:58:20', NULL),
(null, @clientInvoiceCrudId, '修改时间', 'updated_at', 'date_time_picker', 'timestamp', 1, 0, '修改时间', 'created_at', 0, 0, 0, 0, 'client_invoice668370a6947df', '', '', 1, 1, 1, 0, '2024-07-02 03:14:46', '2024-07-02 03:14:46', NULL),
(null, @clientInvoiceCrudId, '唯一值', 'unique', 'input', 'varchar', 1, 1, '唯一值', 'owner_user_id', 0, 0, 1, 0, 'client_invoice6683a26bb5b82', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:47:07', '2024-07-02 06:47:07', NULL),
(null, @clientInvoiceCrudId, '客户', 'eid', 'input_select', 'int', 1, 1, '客户', 'unique', 0, @customerCrudId, 0, 0, 'client_invoice6683a2d312593', '[\"id\",\"customer_no\",\"customer_name\"]', '[]', 1, 1, 1, 0, '2024-07-02 06:48:51', '2024-07-02 06:48:51', NULL),
(null, @clientInvoiceCrudId, '合同', 'cid', 'input_select', 'int', 1, 1, '合同', 'eid', 0, @contractCrudId, 0, 0, 'client_invoice6683a2e42c588', '[\"id\",\"contract_name\"]', '[]', 1, 1, 1, 0, '2024-07-02 06:49:08', '2024-07-02 06:49:08', NULL),
(null, @clientInvoiceCrudId, '发票名称', 'name', 'input', 'varchar', 1, 1, '发票名称', 'cid', 0, 0, 0, 0, 'client_invoice6683a2f43aa69', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:49:24', '2024-07-02 06:49:24', NULL),
(null, @clientInvoiceCrudId, '发票编号', 'num', 'input', 'varchar', 1, 1, '发票编号', 'name', 0, 0, 0, 0, 'client_invoice6683a30377c2f', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:49:39', '2024-07-02 06:49:39', NULL),
(null, @clientInvoiceCrudId, '合同金额', 'price', 'input_price', 'decimal', 1, 1, '合同金额', 'num', 0, 0, 0, 0, 'client_invoice6683a31c9c1f9', '[]', '{\"precision\":\"2\"}', 1, 1, 1, 0, '2024-07-02 06:50:04', '2024-07-02 06:50:04', NULL),
(null, @clientInvoiceCrudId, '发票金额', 'amount', 'input_price', 'decimal', 1, 1, '发票金额', 'price', 0, 0, 0, 0, 'client_invoice6683a327a6f72', '[]', '{\"precision\":\"2\"}', 1, 1, 1, 0, '2024-07-02 06:50:15', '2024-07-02 06:50:15', NULL),
(null, @clientInvoiceCrudId, '发票类型', 'types', 'input_number', 'int', 1, 1, '发票类型', 'amount', 0, 0, 0, 0, 'client_invoice6683a3442bfc8', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:50:44', '2024-07-02 06:50:44', NULL),
(null, @clientInvoiceCrudId, '发票抬头', 'title', 'input', 'varchar', 1, 1, '发票抬头', 'types', 0, 0, 0, 0, 'client_invoice6683a356e29a7', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:51:02', '2024-07-02 06:51:02', NULL),
(null, @clientInvoiceCrudId, '纳税人识别号', 'ident', 'input', 'varchar', 1, 1, '纳税人识别号', 'title', 0, 0, 0, 0, 'client_invoice6683a3621f399', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:51:14', '2024-07-02 06:51:14', NULL),
(null, @clientInvoiceCrudId, '开户行', 'bank', 'input', 'varchar', 1, 1, '开户行', 'ident', 0, 0, 0, 0, 'client_invoice6683a36df0229', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:51:25', '2024-07-02 06:51:25', NULL),
(null, @clientInvoiceCrudId, '开户账号', 'account', 'input', 'varchar', 1, 1, '开户账号', 'bank', 0, 0, 0, 0, 'client_invoice6683a37e8ec0f', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:51:42', '2024-07-02 06:51:42', NULL),
(null, @clientInvoiceCrudId, '开票地址', 'address', 'input', 'varchar', 1, 1, '开票地址', 'account', 0, 0, 0, 0, 'client_invoice6683a3b13cb91', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:52:33', '2024-07-02 06:52:33', NULL),
(null, @clientInvoiceCrudId, '电话', 'tel', 'input', 'varchar', 1, 1, '电话', 'address', 0, 0, 0, 0, 'client_invoice6683a3e7cb73d', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:53:27', '2024-07-02 06:53:27', NULL),
(null, @clientInvoiceCrudId, '邮寄联系人', 'collect_name', 'input', 'varchar', 1, 1, '邮寄联系人', 'tel', 0, 0, 0, 0, 'client_invoice6683a3f6ec90d', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:53:42', '2024-07-02 06:53:42', NULL),
(null, @clientInvoiceCrudId, '邮寄联系电话', 'collect_tel', 'input', 'varchar', 1, 1, '邮寄联系电话', 'collect_name', 0, 0, 0, 0, 'client_invoice6683a401bf850', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:53:53', '2024-07-02 06:53:53', NULL),
(null, @clientInvoiceCrudId, '邮寄方式', 'collect_type', 'input', 'varchar', 1, 1, '邮寄方式', 'collect_tel', 0, 0, 0, 0, 'client_invoice6683a4147cd41', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:54:12', '2024-07-02 06:54:12', NULL),
(null, @clientInvoiceCrudId, '邮寄邮箱', 'collect_email', 'input', 'varchar', 1, 1, '邮寄邮箱', 'collect_type', 0, 0, 0, 0, 'client_invoice6683a423759fb', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:54:27', '2024-07-02 06:54:27', NULL),
(null, @clientInvoiceCrudId, '邮寄地址', 'mail_address', 'input', 'varchar', 1, 1, '邮寄地址', 'collect_email', 0, 0, 0, 0, 'client_invoice6683a4306b8b9', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:54:40', '2024-07-02 06:54:40', NULL),
(null, @clientInvoiceCrudId, '开票方式', 'invoice_type', 'input', 'varchar', 1, 1, '开票方式', 'mail_address', 0, 0, 0, 0, 'client_invoice6683a44ce85a2', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:55:08', '2024-07-02 06:55:08', NULL),
(null, @clientInvoiceCrudId, '发票开票地址', 'invoice_address', 'input', 'varchar', 1, 1, '发票开票地址', 'invoice_type', 0, 0, 0, 0, 'client_invoice6683a46c40f32', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:55:40', '2024-07-02 06:55:40', NULL),
(null, @clientInvoiceCrudId, '发票状态', 'status', 'input_number', 'int', 1, 1, '发票状态', 'invoice_address', 0, 0, 0, 0, 'client_invoice6683a47a47002', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:55:54', '2024-07-02 06:55:54', NULL),
(null, @clientInvoiceCrudId, '作废状态', 'invalid', 'input_number', 'int', 1, 1, '作废状态', 'status', 0, 0, 0, 0, 'client_invoice6683a48805d6e', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:56:08', '2024-07-02 06:56:08', NULL),
(null, @clientInvoiceCrudId, '开票日期', 'bill_date', 'date_picker', 'date', 1, 1, '开票日期', 'invalid', 0, 0, 0, 0, 'client_invoice6683a49506f8d', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:56:21', '2024-07-02 06:56:21', NULL),
(null, @clientInvoiceCrudId, '实际开票日期', 'real_date', 'date_picker', 'date', 1, 1, '实际开票日期', 'bill_date', 0, 0, 0, 0, 'client_invoice6683a4aa7d658', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:56:42', '2024-07-02 06:56:42', NULL),
(null, @clientInvoiceCrudId, '备注内容', 'mark', 'textarea', 'text', 1, 1, '备注内容', 'real_date', 0, 0, 0, 0, 'client_invoice6683a4b4a9894', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:56:52', '2024-07-02 06:56:52', NULL),
(null, @clientInvoiceCrudId, '开票备注', 'remark', 'textarea', 'text', 1, 1, '开票备注', 'mark', 0, 0, 0, 0, 'client_invoice6683a4c0b96ee', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:57:04', '2024-07-02 06:57:04', NULL),
(null, @clientInvoiceCrudId, '业务员备注', 'card_remark', 'textarea', 'text', 1, 1, '业务员备注', 'remark', 0, 0, 0, 0, 'client_invoice6683a4d1dd238', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:57:21', '2024-07-02 06:57:21', NULL),
(null, @clientInvoiceCrudId, '财务备注', 'finance_remark', 'textarea', 'text', 1, 1, '财务备注', 'card_remark', 0, 0, 0, 0, 'client_invoice6683a4dd31269', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:57:33', '2024-07-02 06:57:33', NULL),
(null, @clientInvoiceCrudId, '创建人', 'creator', 'input_select', 'int', 1, 1, '创建人', 'finance_remark', 0, 2, 0, 0, 'client_invoice6683a4fb4b2a0', '[\"id\",\"name\",\"account\",\"avatar\"]', '[]', 1, 1, 1, 0, '2024-07-02 06:58:03', '2024-07-02 06:58:03', NULL),
(null, @clientInvoiceCrudId, '发票流水号', 'serial_number', 'input', 'varchar', 1, 1, '发票流水号', 'creator', 0, 0, 0, 0, 'client_invoice6683a50c53c26', '[]', '[]', 1, 1, 1, 0, '2024-07-02 06:58:20', '2024-07-02 06:58:20', NULL);

INSERT INTO `eb_system_crud` (`id`, `table_name`, `table_name_en`, `cate_ids`, `info`, `crud_id`, `user_id`, `is_update_form`, `is_update_table`, `form_fields`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, '订单', 'biaozhunbandingdan', '', '', 0, '55', 0, 0, '[\"dingdanbianhao\",\"shifujine\"]', '2024-08-24 16:12:35', '2024-08-24 16:13:06', NULL);
SELECT @biaozhunbandingdanCrudId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `is_uniqid`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @biaozhunbandingdanCrudId, '主键ID', 'id', 'input_number', 'int', 0, 0, '主键ID', '', 0, 0, 0, 0, 'biaozhunbandingdan66c995f301b4b', '', '', 1, 1, 1, 0, '2024-08-24 16:12:35', '2024-08-24 16:13:06', NULL),
(null, @biaozhunbandingdanCrudId, '创建用户', 'user_id', 'input_select', 'int', 1, 0, '创建用户', 'id', 0, 144, 0, 0, 'biaozhunbandingdan66c995f301f7c', '', '', 1, 1, 1, 0, '2024-08-24 16:12:35', '2024-08-24 16:13:06', NULL),
(null, @biaozhunbandingdanCrudId, '修改用户', 'update_user_id', 'input_select', 'int', 1, 0, '修改用户', 'user_id', 0, 144, 0, 0, 'biaozhunbandingdan66c995f302320', '', '', 1, 1, 1, 0, '2024-08-24 16:12:35', '2024-08-24 16:13:06', NULL),
(null, @biaozhunbandingdanCrudId, '所属部门', 'frame_id', 'input_select', 'int', 1, 0, '所属部门', 'update_user_id', 0, 145, 0, 0, 'biaozhunbandingdan66c995f3026d9', '', '', 1, 1, 1, 0, '2024-08-24 16:12:35', '2024-08-24 16:13:06', NULL),
(null, @biaozhunbandingdanCrudId, '所属用户', 'owner_user_id', 'input_select', 'int', 1, 0, '所属用户', 'frame_id', 0, 144, 0, 0, 'biaozhunbandingdan66c995f302a73', '', '', 1, 1, 1, 0, '2024-08-24 16:12:35', '2024-08-24 16:13:06', NULL),
(null, @biaozhunbandingdanCrudId, '创建时间', 'created_at', 'date_time_picker', 'timestamp', 1, 0, '创建时间', 'shifujine', 0, 0, 0, 0, 'biaozhunbandingdan66c995f302a81', '', '', 1, 1, 1, 0, '2024-08-24 16:12:35', '2024-08-24 16:13:06', NULL),
(null, @biaozhunbandingdanCrudId, '修改时间', 'updated_at', 'date_time_picker', 'timestamp', 1, 0, '修改时间', 'created_at', 0, 0, 0, 0, 'biaozhunbandingdan66c995f302a89', '', '', 1, 1, 1, 0, '2024-08-24 16:12:35', '2024-08-24 16:13:06', NULL),
(null, @biaozhunbandingdanCrudId, '伪删除', 'deleted_at', 'date_time_picker', 'timestamp', 1, 0, '伪删除', 'updated_at', 0, 0, 0, 0, 'biaozhunbandingdan66c995f302a8f', '', '', 1, 1, 1, 0, '2024-08-24 16:12:35', '2024-08-24 16:13:06', NULL),
(null, @biaozhunbandingdanCrudId, '订单编号', 'dingdanbianhao', 'input', 'varchar', 1, 1, '订单编号', 'owner_user_id', 0, 0, 1, 1, 'biaozhunbandingdan66c995ff52d0b', '[]', '[]', 1, 1, 0, 1, '2024-08-24 16:12:47', '2024-08-24 16:13:06', NULL),
(null, @biaozhunbandingdanCrudId, '实付金额', 'shifujine', 'input_price', 'decimal', 1, 1, '实付金额', 'dingdanbianhao', 0, 0, 0, 1, 'biaozhunbandingdan66c9960b877ac', '[]', '[]', 1, 1, 0, 0, '2024-08-24 16:12:59', '2024-08-24 16:13:06', NULL);

INSERT INTO `eb_system_crud_form` (`id`, `crud_id`, `version`, `options`, `fields`, `global_options`, `is_index`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @biaozhunbandingdanCrudId, 1, '[{\"name\":\"订单编号\",\"type\":\"input\",\"icon\":\"text-field\",\"formItemFlag\":true,\"options\":{\"name\":\"dingdanbianhao\",\"label\":\"订单编号\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":false,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":300,\"maxLength\":300,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":0,\"fieldId\":0,\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"formFieldUniqid\":\"dingdanbianhao\"},\"hide\":false,\"id\":\"input16921\",\"i\":6,\"pidx\":0},{\"name\":\"实付金额\",\"type\":\"input-price\",\"icon\":\"number-field\",\"formItemFlag\":true,\"options\":{\"name\":\"shifujine\",\"label\":\"实付金额\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":false,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":300,\"maxLength\":300,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":0,\"fieldId\":2085,\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"keyNameEnabled\":false,\"keyName\":\"\",\"min\":-100000000000,\"max\":100000000000,\"precision\":0,\"step\":1,\"formFieldUniqid\":\"shifujine\"},\"hide\":false,\"id\":\"inputprice111732\",\"i\":7,\"pidx\":0}]', '[\"dingdanbianhao\",\"shifujine\"]', '{\"modelName\":\"formData\",\"refName\":\"vForm\",\"rulesName\":\"rules\",\"labelWidth\":80,\"labelPosition\":\"left\",\"size\":\"small\",\"labelAlign\":\"label-left-align\",\"cssCode\":\"\",\"customClass\":[],\"functions\":\"\",\"layoutType\":\"PC\",\"onFormCreated\":\"\",\"onFormMounted\":\"\",\"onFormDataChange\":\"\"}', 1, '2024-08-24 16:13:06', '2024-08-24 16:13:06', NULL);

INSERT INTO `eb_system_crud` (`id`, `table_name`, `table_name_en`, `cate_ids`, `info`, `crud_id`, `user_id`, `is_update_form`, `is_update_table`, `form_fields`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, '财务分类', 'bill_category', '', '', 0, '4', 0, 0, '', '2024-09-09 16:04:50', '2024-09-09 16:04:50', NULL);
SELECT @billCategoryCrudId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `is_uniqid`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @billCategoryCrudId, '自增id', 'id', 'input', 'varchar', 0, 1, '自增id', 'frame_id', 0, 0, 0, 0, 'bill_category66deac48ca422', '[]', '[]', 1, 1, 1, 0, '2024-09-09 16:05:28', '2024-09-09 16:05:28', NULL),
(null, @billCategoryCrudId, '分类名称', 'name', 'input', 'varchar', 0, 1, '分类名称', 'id', 0, 0, 1, 0, 'bill_category66deaccc29190', '[]', '[]', 1, 1, 1, 0, '2024-09-09 16:07:40', '2024-09-09 16:07:40', NULL),
(null, @billCategoryCrudId, '排序', 'sort', 'input_number', 'int', 0, 1, '排序', 'name', 0, 0, 0, 0, 'bill_category66deace6c68b6', '[]', '[]', 1, 1, 1, 0, '2024-09-09 16:08:06', '2024-09-09 16:08:06', NULL),
(null, @billCategoryCrudId, '类型', 'types', 'radio', 'int', 1, 1, '类型', 'sort', 43, 0, 0, 0, 'bill_category66dfad81df49e', '[]', '[]', 1, 1, 1, 0, '2024-09-10 10:22:57', '2024-09-10 10:22:57', NULL);

INSERT INTO `eb_system_crud` (`id`, `table_name`, `table_name_en`, `cate_ids`, `info`, `crud_id`, `user_id`, `is_update_form`, `is_update_table`, `form_fields`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, '财务', 'bill_list', '', '财务列表', 0, '4', 0, 0, '[\"uid\",\"cate_id\",\"num\",\"edit_time\",\"types\",\"type_id\",\"pay_type\",\"mark\",\"link_cate\"]', '2024-09-09 15:57:14', '2024-09-09 17:19:55', NULL);
SELECT @billListCrudId := LAST_INSERT_ID();

INSERT INTO `eb_system_crud_field` (`id`, `crud_id`, `field_name`, `field_name_en`, `form_value`, `field_type`, `is_default_value_not_null`, `is_table_show_row`, `comment`, `prev_field`, `data_dict_id`, `association_crud_id`, `is_main`, `is_form`, `form_field_uniqid`, `association_field_names`, `options`, `create_modify`, `update_modify`, `is_default`, `is_uniqid`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @billListCrudId, '自增id', 'id', 'input_number', 'int', 0, 1, '自增id', 'frame_id', 0, 0, 0, 0, 'bill_list66deaada95fd0', '[]', '[]', 1, 1, 1, 0, '2024-09-09 15:59:22', '2024-09-09 17:19:55', NULL),
(null, @billListCrudId, '财务流水分类', 'cate_id', 'input_select', 'int', 0, 1, '财务流水分类', 'uid', 0, @billCategoryCrudId, 0, 1, 'bill_list66deadbc8d0f5', '[\"id\",\"name\",\"types\",\"sort\"]', '[]', 1, 1, 1, 0, '2024-09-09 16:11:40', '2024-09-09 17:19:55', NULL),
(null, @billListCrudId, '变动金额', 'num', 'input_price', 'decimal', 0, 1, '变动金额', 'cate_id', 0, 0, 0, 1, 'bill_list66deadd7c9292', '[]', '[]', 1, 1, 1, 0, '2024-09-09 16:12:07', '2024-09-09 17:19:55', NULL),
(null, @billListCrudId, '变动时间', 'edit_time', 'date_time_picker', 'timestamp', 1, 1, '变动时间', 'num', 0, 0, 0, 1, 'bill_list66deadf339f47', '[]', '[]', 1, 1, 1, 0, '2024-09-09 16:12:35', '2024-09-09 17:19:55', NULL),
(null, @billListCrudId, '变动类型', 'types', 'radio', 'int', 1, 1, '变动类型', 'edit_time', 43, 0, 0, 1, 'bill_list66deb09f67633', '[]', '[]', 1, 1, 1, 0, '2024-09-09 16:23:59', '2024-09-09 17:19:55', NULL),
(null, @billListCrudId, '支付方式', 'type_id', 'radio', 'int', 1, 1, '支付方式', 'types', 34, 0, 0, 1, 'bill_list66deb0b9dd838', '[]', '[]', 1, 1, 1, 0, '2024-09-09 16:24:25', '2024-09-09 17:19:55', NULL),
(null, @billListCrudId, '支付方式名称', 'pay_type', 'input', 'varchar', 1, 1, '支付方式名称', 'type_id', 0, 0, 1, 1, 'bill_list66deb0dba5564', '[]', '[]', 1, 1, 1, 0, '2024-09-09 16:24:59', '2024-09-09 17:19:55', NULL),
(null, @billListCrudId, '备注', 'mark', 'input', 'varchar', 1, 1, '备注', 'pay_type', 0, 0, 0, 1, 'bill_list66deb0e8484ae', '[]', '[]', 1, 1, 1, 0, '2024-09-09 16:25:12', '2024-09-09 17:19:55', NULL),
(null, @billListCrudId, '用户id', 'user_id', 'input_select', 'int', 1, 1, '用户id', 'mark', 0, @yongHuCrudId, 0, 0, 'bill_list66dfae357cf35', '[\"id\",\"password\",\"name\",\"account\",\"phone\",\"avatar\"]', '[]', 1, 1, 0, 0, '2024-09-10 10:25:57', '2024-09-10 10:25:57', NULL),
(null, @billListCrudId, '订单id', 'order_id', 'input_select', 'int', 0, 1, '订单id', 'link_id', 0, @biaozhunbandingdanCrudId, 0, 0, 'bill_list66e00c40e2ae2', '[\"id\",\"dingdanbianhao\"]', '[]', 1, 1, 0, 0, '2024-09-10 17:07:12', '2024-09-10 17:07:12', NULL);

INSERT INTO `eb_system_crud_form` (`id`, `crud_id`, `version`, `options`, `fields`, `global_options`, `is_index`, `created_at`, `updated_at`, `deleted_at`) VALUES
(null, @billListCrudId, 1, '[{\"name\":\"\\u7528\\u6237id\",\"type\":\"input-select\",\"icon\":\"reference-field\",\"formItemFlag\":true,\"options\":{\"name\":\"uid\",\"label\":\"\\u7528\\u6237id\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":false,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":300,\"maxLength\":300,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":0,\"fieldId\":2103,\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"buttonText\":\"\\u9009\\u62e9\",\"formFieldUniqid\":\"uid\"},\"hide\":false,\"id\":\"inputselect64424\",\"i\":0,\"pidx\":0},{\"name\":\"\\u8d22\\u52a1\\u6d41\\u6c34\\u5206\\u7c7b\",\"type\":\"input-select\",\"icon\":\"reference-field\",\"formItemFlag\":true,\"options\":{\"name\":\"cate_id\",\"label\":\"\\u8d22\\u52a1\\u6d41\\u6c34\\u5206\\u7c7b\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":true,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":300,\"maxLength\":300,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":0,\"fieldId\":2108,\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"buttonText\":\"\\u9009\\u62e9\",\"formFieldUniqid\":\"cate_id\"},\"hide\":false,\"id\":\"inputselect21517\",\"i\":1,\"pidx\":0},{\"name\":\"\\u53d8\\u52a8\\u91d1\\u989d\",\"type\":\"input-price\",\"icon\":\"number-field\",\"formItemFlag\":true,\"options\":{\"name\":\"num\",\"label\":\"\\u53d8\\u52a8\\u91d1\\u989d\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":true,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":300,\"maxLength\":300,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":0,\"fieldId\":2109,\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"keyNameEnabled\":false,\"keyName\":\"\",\"min\":-100000000000,\"max\":100000000000,\"precision\":0,\"step\":1,\"formFieldUniqid\":\"num\"},\"hide\":false,\"id\":\"inputprice114840\",\"i\":2,\"pidx\":0},{\"name\":\"\\u53d8\\u52a8\\u65f6\\u95f4\",\"type\":\"date-time-picker\",\"icon\":\"date-range-field\",\"formItemFlag\":true,\"options\":{\"name\":\"edit_time\",\"label\":\"\\u53d8\\u52a8\\u65f6\\u95f4\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":false,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":300,\"maxLength\":300,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":0,\"fieldId\":2110,\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"editable\":false,\"format\":\"yyyy-MM-dd HH:mm:ss\",\"valueFormat\":\"yyyy-MM-dd HH:mm:ss\",\"formFieldUniqid\":\"edit_time\"},\"hide\":false,\"id\":\"datetimepicker80464\",\"i\":3,\"pidx\":0},{\"name\":\"\\u53d8\\u52a8\\u7c7b\\u578b\",\"type\":\"radio\",\"icon\":\"radio-field\",\"formItemFlag\":true,\"options\":{\"name\":\"types\",\"label\":\"\\u53d8\\u52a8\\u7c7b\\u578b\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":false,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":300,\"maxLength\":300,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":43,\"fieldId\":2111,\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"displayStyle\":\"inline\",\"buttonStyle\":false,\"border\":false,\"optionItems\":[{\"id\":4364,\"name\":\"\\u652f\\u51fa\",\"value\":\"0\",\"type_id\":43,\"pid\":\"\",\"type_name\":\"bill_type\",\"sort\":0,\"status\":1,\"is_default\":0,\"level\":1,\"mark\":\"\",\"created_at\":\"2024-09-09 16:22:33\",\"updated_at\":\"2024-09-09 16:22:33\",\"checkbox\":false},{\"id\":4365,\"name\":\"\\u6536\\u5165\",\"value\":\"1\",\"type_id\":43,\"pid\":\"\",\"type_name\":\"bill_type\",\"sort\":0,\"status\":1,\"is_default\":0,\"level\":1,\"mark\":\"\",\"created_at\":\"2024-09-09 16:23:12\",\"updated_at\":\"2024-09-09 16:23:12\",\"checkbox\":false}],\"formFieldUniqid\":\"types\"},\"hide\":false,\"id\":\"radio74256\",\"i\":4,\"pidx\":0},{\"name\":\"\\u652f\\u4ed8\\u65b9\\u5f0f\",\"type\":\"radio\",\"icon\":\"radio-field\",\"formItemFlag\":true,\"options\":{\"name\":\"type_id\",\"label\":\"\\u652f\\u4ed8\\u65b9\\u5f0f\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":false,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":300,\"maxLength\":300,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":34,\"fieldId\":2112,\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"displayStyle\":\"inline\",\"buttonStyle\":false,\"border\":false,\"optionItems\":[{\"id\":4292,\"name\":\"\\u5bf9\\u516c\\u8f6c\\u8d26\",\"value\":\"1\",\"type_id\":34,\"pid\":\"\",\"type_name\":\"zhifufangshi\",\"sort\":0,\"status\":1,\"is_default\":0,\"level\":1,\"mark\":\"\",\"created_at\":\"2024-04-23 11:57:09\",\"updated_at\":\"2024-04-23 11:57:09\",\"checkbox\":false},{\"id\":4293,\"name\":\"\\u4f59\\u989d1\",\"value\":\"2\",\"type_id\":34,\"pid\":\"\",\"type_name\":\"zhifufangshi\",\"sort\":0,\"status\":1,\"is_default\":0,\"level\":1,\"mark\":\"\",\"created_at\":\"2024-04-23 11:57:17\",\"updated_at\":\"2024-06-25 12:51:55\",\"checkbox\":false},{\"id\":4294,\"name\":\"\\u5fae\\u4fe1\",\"value\":\"3\",\"type_id\":34,\"pid\":\"\",\"type_name\":\"zhifufangshi\",\"sort\":0,\"status\":1,\"is_default\":0,\"level\":1,\"mark\":\"\",\"created_at\":\"2024-04-23 11:57:22\",\"updated_at\":\"2024-04-23 11:57:22\",\"checkbox\":false},{\"id\":4295,\"name\":\"\\u652f\\u4ed8\\u5b9d\",\"value\":\"4\",\"type_id\":34,\"pid\":\"\",\"type_name\":\"zhifufangshi\",\"sort\":0,\"status\":1,\"is_default\":0,\"level\":1,\"mark\":\"\",\"created_at\":\"2024-04-23 11:57:27\",\"updated_at\":\"2024-04-23 11:57:27\",\"checkbox\":false}],\"formFieldUniqid\":\"type_id\"},\"hide\":false,\"id\":\"radio109877\",\"i\":5,\"pidx\":0},{\"name\":\"\\u5907\\u6ce8\",\"type\":\"input\",\"icon\":\"text-field\",\"formItemFlag\":true,\"options\":{\"name\":\"mark\",\"label\":\"\\u5907\\u6ce8\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":false,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":300,\"maxLength\":300,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":0,\"fieldId\":2114,\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"formFieldUniqid\":\"mark\"},\"hide\":false,\"id\":\"input29613\",\"i\":7,\"pidx\":0},{\"name\":\"\\u5173\\u8054\\u7c7b\\u578b\",\"type\":\"input\",\"icon\":\"text-field\",\"formItemFlag\":true,\"options\":{\"name\":\"link_cate\",\"label\":\"\\u5173\\u8054\\u7c7b\\u578b\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":false,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":300,\"maxLength\":300,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":0,\"fieldId\":2115,\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"formFieldUniqid\":\"link_cate\"},\"hide\":false,\"id\":\"input55503\",\"i\":8,\"pidx\":0},{\"name\":\"\\u652f\\u4ed8\\u65b9\\u5f0f\\u540d\\u79f0\",\"type\":\"input\",\"icon\":\"text-field\",\"formItemFlag\":true,\"options\":{\"name\":\"pay_type\",\"label\":\"\\u652f\\u4ed8\\u65b9\\u5f0f\\u540d\\u79f0\",\"labelAlign\":\"\",\"type\":\"\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":false,\"showPassword\":false,\"required\":false,\"requiredHint\":\"\",\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":300,\"maxLength\":300,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"\",\"dataDictId\":0,\"fieldId\":2113,\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\",\"onAppendButtonClick\":\"\",\"formFieldUniqid\":\"pay_type\"},\"hide\":false,\"id\":\"input20702\",\"i\":6,\"pidx\":0}]', '[\"uid\",\"cate_id\",\"num\",\"edit_time\",\"types\",\"type_id\",\"pay_type\",\"mark\",\"link_cate\"]', '{\"modelName\":\"formData\",\"refName\":\"vForm\",\"rulesName\":\"rules\",\"labelWidth\":80,\"labelPosition\":\"left\",\"size\":\"small\",\"labelAlign\":\"label-left-align\",\"cssCode\":\"\",\"customClass\":[],\"functions\":\"\",\"layoutType\":\"PC\",\"onFormCreated\":\"\",\"onFormMounted\":\"\",\"onFormDataChange\":\"\"}', 1, '2024-09-09 17:19:55', '2024-09-09 17:19:55', NULL);