business 中臺 · WOOAdmin低代碼開發平臺文檔

[TOC] ## 2023-06-17 V2.0.0 ### 更新內容 1、部門模型調整 2、角色模型調整 3、用戶模型調整 4、為了方便開發，列表頁和后臺一樣放出了模型和字段操作的快捷按鈕（不過只有商家ID為1(就是系統默認給你建的那個商家)&&超管&&開發模式&&`wooauth`配置的`is_business_model` 為true下可見）；模型只保留了編輯，其它功能屏蔽了。 ### V1.0.4升級到V2.0.0升級指導升級前請先備份原項目文件和整個數據庫，升級前請先備份原項目文件和整個數據庫，升級前請先備份原項目文件和整個數據庫。 1、把`business/install`下的目錄替換到對應的項目根目錄下 2、部門升級 2.1、刪除聯系人和聯系方式字段（非必須） 2.2、新增2個字段 ``` ALTER TABLE `woo_business_department` ADD `leader_ids` varchar(128) NOT NULL DEFAULT '' COMMENT '部門領導'; ALTER TABLE `woo_business_department` ADD `is_business` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '管理端登錄'; ``` 2.3、自己找到BusinessDepartment模型ID，把__PARENT_ID__替換了執行： ``` INSERT INTO `woo_field` (`id`, `field`, `name`, `model_id`, `form`, `business_form`, `modify_form`, `business_modify_form`, `form_foreign`, `business_form_foreign`, `form_item_attrs`, `business_form_item_attrs`, `form_tag_attrs`, `business_form_tag_attrs`, `form_options`, `business_form_options`, `form_upload`, `business_form_upload`, `form_trigger`, `business_form_trigger`, `list`, `business_list`, `list_attrs`, `business_list_attrs`, `list_filter`, `business_list_filter`, `list_filter_attrs`, `business_list_filter_attrs`, `list_filter_tag_attrs`, `business_list_filter_tag_attrs`, `detail`, `business_detail`, `detail_attrs`, `business_detail_attrs`, `validate`, `business_validate`, `is_field`, `type`, `length`, `default`, `is_not_null`, `is_unsigned`, `is_ai`, `is_system`, `is_contribute`, `index`, `after`, `admin_id`, `list_order`, `create_time`, `update_time`) VALUES (NULL, 'leader_ids', '部門領導', __PARENT_ID__, 'relation', 'relation', '', '', 'BusinessMember', 'BusinessMember', '', '', '{\"data-type\":\"checkbox\"}', '{\"data-type\":\"checkbox\"}', '', '', '', '', '', '', 'html', 'html', '{\"1\":\"\",\"width\":\"240\"}', '{\"1\":\"\",\"width\":\"240\"}', '', '', '', '', '', '', '', '', '', '', '', '', 1, 'VARCHAR', '128', '', 1, 0, 0, 1, 0, '', '', 0, 10123, 1686538409, 1686539509), (NULL, 'is_business', '管理端登錄', __PARENT_ID__, 'checker', 'checker', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'checker', 'checker', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, 'TINYINT', '1', '0', 1, 1, 0, 0, 0, '', '', 0, 10124, 1686538442, 1686538442); ``` 3、用戶升級 3.1、新增三個字段 ``` ALTER TABLE `woo_business_member` ADD `idcard` varchar(64) NOT NULL DEFAULT '' COMMENT '身份證'; ALTER TABLE `woo_business_member` ADD `region` varchar(64) NOT NULL DEFAULT '' COMMENT '家庭所在地'; ALTER TABLE `woo_business_member` ADD `address` varchar(64) NOT NULL DEFAULT '' COMMENT '相信地址'; ``` 3.2、自己找到BusinessMember模型ID，把__PARENT_ID__替換了執行： ``` INSERT INTO `woo_field` (`id`, `field`, `name`, `model_id`, `form`, `business_form`, `modify_form`, `business_modify_form`, `form_foreign`, `business_form_foreign`, `form_item_attrs`, `business_form_item_attrs`, `form_tag_attrs`, `business_form_tag_attrs`, `form_options`, `business_form_options`, `form_upload`, `business_form_upload`, `form_trigger`, `business_form_trigger`, `list`, `business_list`, `list_attrs`, `business_list_attrs`, `list_filter`, `business_list_filter`, `list_filter_attrs`, `business_list_filter_attrs`, `list_filter_tag_attrs`, `business_list_filter_tag_attrs`, `detail`, `business_detail`, `detail_attrs`, `business_detail_attrs`, `validate`, `business_validate`, `is_field`, `type`, `length`, `default`, `is_not_null`, `is_unsigned`, `is_ai`, `is_system`, `is_contribute`, `index`, `after`, `admin_id`, `list_order`, `create_time`, `update_time`) VALUES (NULL, 'idcard', '身份證', __PARENT_ID__, 'text', 'text', '', '', '', '', '{\"form_group\":\"business\"}', '{\"form_group\":\"business\"}', '', '', '', '', '', '', '', '', '', '', '{\"width\":\"160\"}', '{\"width\":\"160\"}', '1', '1', '', '', '', '', '', '', '', '', '[{\"rule\":\"idCard\",\"args\":\"\",\"on\":\"\",\"message\":\"\"}]', '[{\"rule\":\"idCard\",\"args\":\"\",\"on\":\"\",\"message\":\"\"}]', 1, 'VARCHAR', '64', '', 1, 0, 0, 1, 0, '', '', 0, 528, 1686541177, 1686541601), (NULL, 'region', '家庭所在地', __PARENT_ID__, 'cascader', 'cascader', '', '', 'Region', 'Region', '{\"form_group\":\"business\"}', '{\"form_group\":\"business\"}', '{\"data-url\":\"true\"}', '{\"data-url\":\"true\"}', '', '', '', '', '', '', '', '', '{\"width\":\"180\"}', '{\"width\":\"180\"}', 'cascader', 'cascader', '', '', '{\"data-url\":\"true\",\"data-nostrict\":\"true\"}', '{\"data-url\":\"true\",\"data-nostrict\":\"true\"}', '', '', '', '', '', '', 1, 'VARCHAR', '64', '', 1, 0, 0, 1, 0, '', '', 0, 542, 1686541336, 1686541524), (NULL, 'address', '相信地址', __PARENT_ID__, 'text', 'text', '', '', '', '', '{\"form_group\":\"business\"}', '{\"form_group\":\"business\"}', '', '', '', '', '', '', '', '', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, 'VARCHAR', '64', '', 1, 0, 0, 1, 0, '', '', 0, 543, 1686541408, 1686541526); ``` 4、角色升級 4.1、 ``` ALTER TABLE `woo_business_role` ADD `dashboard` varchar(64) NOT NULL DEFAULT '' COMMENT '主面板'; ALTER TABLE `woo_business_role` ADD `is_business` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '管理端登錄'; ALTER TABLE `woo_business_role` ADD `is_super` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否超管'; ``` 4.2、自己找到BusinessRole模型ID，把__PARENT_ID__替換了執行： ``` INSERT INTO `woo_field` (`id`, `field`, `name`, `model_id`, `form`, `business_form`, `modify_form`, `business_modify_form`, `form_foreign`, `business_form_foreign`, `form_item_attrs`, `business_form_item_attrs`, `form_tag_attrs`, `business_form_tag_attrs`, `form_options`, `business_form_options`, `form_upload`, `business_form_upload`, `form_trigger`, `business_form_trigger`, `list`, `business_list`, `list_attrs`, `business_list_attrs`, `list_filter`, `business_list_filter`, `list_filter_attrs`, `business_list_filter_attrs`, `list_filter_tag_attrs`, `business_list_filter_tag_attrs`, `detail`, `business_detail`, `detail_attrs`, `business_detail_attrs`, `validate`, `business_validate`, `is_field`, `type`, `length`, `default`, `is_not_null`, `is_unsigned`, `is_ai`, `is_system`, `is_contribute`, `index`, `after`, `admin_id`, `list_order`, `create_time`, `update_time`) VALUES (NULL, 'dashboard', '主面板', __PARENT_ID__, 'text', 'text', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '{\"width\":\"200\"}', '{\"width\":\"200\"}', '', '', '', '', '', '', '', '', '', '', '', '', 1, 'VARCHAR', '64', '', 1, 0, 0, 1, 0, '', '', 1, 516, 1686530939, 1686535912), (NULL, 'is_business', '管理端登錄', __PARENT_ID__, 'checker', 'checker', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'checker', 'checker', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, 'TINYINT', '1', '0', 1, 1, 0, 1, 0, '', '', 1, 517, 1686530986, 1686534406), (NULL, 'is_super', '是否超管', __PARENT_ID__, 'none', 'none', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'checker', '0', '', '', '', '', '', '', '', '', '', '0', '', '', '', '', 1, 'TINYINT', '1', '0', 1, 1, 0, 1, 0, '', '', 0, 518, 1686534254, 1686535857); ``` 5、新增了幾個系統設置： ``` INSERT INTO `woo_business_setting` (`id`, `title`, `business_setting_group_id`, `var`, `value`, `type`, `options`, `tip`, `list_order`, `admin_id`, `is_js_var`, `create_time`, `update_time`, `delete_time`, `is_business`, `is_business_member`) VALUES (NULL, '選項卡樣式', 1, 'admin_tab_style', 'layui-tab-brief', 'select', '{\"layui-tab-brief\":\"簡潔風格\",\"layui-tab-default\":\"凹型風格\",\"layui-tab-card\":\"卡片風格\"}', '', 24, 1, 0, 1686542454, 1686542495, 0, 1, 1), (NULL, '列表項工具按鈕風格', 2, 'table_item_toolbar_style', 'text', 'select', '{\"button\":\"按鈕風格(默認)\",\"text\":\"文本不帶圖標風格\",\"text_icon\":\"文本可帶圖標風格\"}', '', 25, 1, 0, 1686547449, 1686547615, 0, 1, 1), (NULL, '列表項文本按鈕類名', 2, 'table_item_toolbar_text_class', '', 'text', '', '可通過控制類名實現按鈕顏色和樣式的控制；類名\"woo-theme-color\"實現按鈕顏色隨主題', 26, 1, 0, 1686547523, 1686547523, 0, 1, 1), (NULL, '表格全局默認高度', 2, 'table_default_height', '0', 'number', '', '如不設置默認高度，請填寫為0', 27, 1, 0, 1686547547, 1686547615, 0, 1, 1), (NULL, '表格自動計算高度', 2, 'table_is_inner_height', '0', 'checker', '', '當表格沒有設置高度、最大高度、非移動端時有效', 28, 1, 1, 1686581934, 1686581953, 0, 1, 1); ``` 6、用戶新增密碼修改的表單場景自己找到BusinessMember模型ID，把8888替換了執行： ``` INSERT INTO `woo_form_scene` (`id`, `model_id`, `title`, `is_verify`, `list_order`, `create_time`, `update_time`, `icon`, `hover`, `where`, `action`, `where_type`, `is_btn`, `var`, `fields`, `parent`, `app`, `attrs`, `class`, `page_title`, `success_message`, `page_tip`) VALUES (NULL, 8888, '', 1, 72, 1686548111, 1686548692, 'layui-icon-password', '密碼', '', 'password', '', 1, 'password', '[{\"field\":\"password\",\"elem\":\"password\",\"more_attrs\":\"{\\\"tip\\\":\\\"\\\",\\\"rsa\\\":\\\"true\\\"}\",\"validate\":\"{\\\"require\\\":\\\"\\\",\\\"confirm\\\":\\\"repassword\\\"}\"},{\"field\":\"repassword\",\"elem\":\"password\",\"more_attrs\":\"{\\\"name\\\":\\\"確認密碼\\\",\\\"attrs\\\":\\\"{\\\\\\\"lay-affix\\\\\\\":\\\\\\\"eye\\\\\\\"}\\\",\\\"rsa\\\":\\\"true\\\"}\",\"validate\":\"{\\\"require\\\":\\\"\\\",\\\"confirm\\\":\\\"password\\\"}\"}]', '', '[\"admin\",\"business\"]', '', 'btn-37', '修改密碼', '密碼修改成功', ''); ```