module gitee.com/gowebframe3/webframe.git
go 1.20
replace google.golang.org/grpc => google.golang.org/grpc v1.26.0
replace google.golang.org/protobuf => google.golang.org/protobuf v1.25.0
replace golang.org/x/tools => golang.org/x/tools v0.21.1-0.20240508182429-e35e4ccd0d2d // indirect
// gowebcli 的模块goconfig配置, godi注入, gomini（nats server等公共能力）,goweb（web client/server,grpc封装)
// go install gitee.com/gowebframe3/webframe.git/cmd/gowebcli
go env -w GO111MODULE=on
go env -w GOPROXY=https://goproxy.cn,direct
go env -w GOPRIVATE=git.ichub.com
go env -w GOINSECURE=git.ichub.com
go get github.com/hhatto/gocloc
SELECT cp.depth,cj.sbu_id FROM coo_member_job cmj JOIN coo_job cj ON cj.id = cmj.job_id
AND cmj.employee_account_id = 937181243879555075 JOIN coo_job_position_rel cjpr ON cjpr.job_id = cj.id
JOIN coo_position_duty cpd ON cpd.position_id = cjpr.position_id
JOIN coo_permission cp ON cp.id = cpd.permission_id
WHERE (cp.id in (998920162100477955,998920162100510723,998920162100543491,998920162100576259)
AND cjpr.position_id in (670210250570334209,661387225827016705,661169850669367297,770385489313071105,757383917423132673,661423106694873089,889584867122610177,851983227727249409,859360018403540993,661187885547651073,808100992316735489,661471285708718081,680982425207406593,1001115951120252931) AND cp.active = true)
permission_id是你那边传进来的resouce查出来的，
position_id是通过employee_account_id查出来的job_id，
再关联job和position的关系表查出来的