MicroCommunity/docs/develop/addService.md

添加服务表

insert into c_service(service_id,service_code,business_type_cd,name,seq,is_instance,url,method,provide_app_id) values('78','delete.privilege.userPrivilege','API','删除用户权限','1','NT','http://order-service/privilegeApi/deleteStaffPrivilegeOrPrivilegeGroup','POST','8000418002');

服务绑定应用

insert into c_route(app_id,service_id,order_type_cd,invoke_model) values('8000418004','78','Q','S');

添加查询类 服务

INSERT INTO c_service_sql (service_code,name,params,query_model,sql,template) VALUES ( 'query.myCommunity.byMember', '查询商户入驻小区信息', 'memberId,memberTypeCd', '1', '{"param1":"SELECT sc.community_id communityId, sc.name, sc.address, sc.nearby_landmarks nearbyLandmarks, sc.city_code cityCode, sc.map_x mapX, sc.map_y mapY, scm.member_id memberId, scm.member_type_cd memberTypeCd, scm.status_cd statusCd FROM s_community sc, s_community_member scm WHERE sc.community_id = scm.community_id AND sc.status_cd = ''0'' AND scm.member_id = #memberId# AND scm.member_type_cd = #memberTypeCd# AND scm.status_cd IN (''0'', ''1000'')"}', '{"PARAM": {"param1": "$.#communitys#Array"},"TEMPLATE": {}}' );