一、demo脚本
SELECT
e.profilename,
m.fieldlabel AS module_name,
n.fieldlabel AS operation_name,
CASE WHEN d.permissions=0 THEN 'yes' ELSE 'no' END AS permissions
FROM ld_profileallpermission a
LEFT JOIN ld_actionmapping b ON b.actionid = a.operation
LEFT JOIN ld_tab c ON c.tabid=a.tabid
LEFT JOIN ld_profile2standardpermissions d ON d.tabid=c.tabid AND d.operation=a.operation
LEFT JOIN ld_profile e ON e.profileid=d.profileid
LEFT JOIN ld_tranlabel m ON m.trantable='ld_tab' AND m.languagetype='zh' AND m.tabid=c.tabid AND m.Relateid=c.tabid
LEFT JOIN ld_desk n ON n.labelbol=b.actionlabel AND n.languagetype='zh' AND n.Labeltype='fixedstr'
WHERE e.profilename='事业部/大区总经理'
AND FIND_IN_SET(b.actionname,'index,DetailView,QuotesChange_Add,QuotesChange_Replace,QuotesChange_Edit,Create,EditView,Delete,
accountdatadup,Copy,Allocate,Share,Import,Export,DuplicatesHandling,Merge,WarehouseConfirmed,EndreturnGood,Reteacement,Checkout,
ACheckout,Confirminventory,RevocationInventory,Advance,Updatestate,ChangeCreator,Devidend,AbtiDevidend')
ORDER BY c.tabsequence,a.sequence ASC