| | |
| | | // 職位 |
| | | if (plist == null) { |
| | | plist = new List<Position>(); |
| | | plist.add(new Position('一般', true)); |
| | | plist.add(new Position('专员', true)); //20220517 lt SWAG-CD28H3 |
| | | plist.add(new Position('高级', true)); |
| | | plist.add(new Position('主管', true)); |
| | | //20220402 lt SWAG-CD28H3 【委托】【期初修改4月6日开始修改】目标录入相关判断修改 start |
| | |
| | | } |
| | | private List<User> getUserList(List<String> UserInfoList) {//根据上传文件中得本部,省份,担当,职位 得到了user 信息 |
| | | String soql = 'select Id, UserInfos__c, Salesdepartment__c, Province__c, Alias, Product_specialist_incharge_product__c,Responsible_for_Products_Concurrently__c, Use_Start_Date__c,' |
| | | + ' ProfileId, Profile.Name, UserRoleId, UserRole.Name, Sales_Speciality__c, Post__c,Job_Category__c' |
| | | + ' ProfileId, Profile.Name, UserRoleId, UserRole.Name, Sales_Speciality__c, HR_Post__c,Job_Category__c' |
| | | + ' from User where IsActive = true and Test_staff__c = false and UserType = \'Standard\' ' |
| | | + ' and Salesdepartment__c <> \'7.能量\' ' |
| | | + ' and UserInfos__c IN :UserInfoList order by Salesdepartment__c, Province__c'; |
| | |
| | | // ユーザの検索 |
| | | private List<User> getUserList(Boolean searchByDpt, Boolean searchByProvince, Boolean defaultSearch) { |
| | | String soql = 'select Id, Salesdepartment__c, Province__c, Alias, Product_specialist_incharge_product__c,Responsible_for_Products_Concurrently__c, Use_Start_Date__c,' |
| | | + ' ProfileId, Profile.Name, UserRoleId, UserRole.Name, Sales_Speciality__c, Post__c' |
| | | + ' ProfileId, Profile.Name, UserRoleId, UserRole.Name, Sales_Speciality__c, HR_Post__c' |
| | | + ' from User where IsActive = true and Test_staff__c = false and UserType = \'Standard\' ' |
| | | // CHAN-BBLCYP 20190509 LHJ Start |
| | | + ' and Salesdepartment__c <> \'7.能量\' '; |
| | |
| | | |
| | | // 職位条件 |
| | | List<String> positionNames = new List<String>(); |
| | | String s1 = '经理'; |
| | | String s2 = '总监'; |
| | | for (Position p : plist) { |
| | | if (p.check) { |
| | | positionNames.add(p.positionName); |
| | | //positionNames.add(p.positionName); |
| | | //20220406 lt SWAG-CD28H3 【委托】【期初修改4月6日开始修改】目标录入相关判断修改 start |
| | | if(p.positionName == '经理级'){ |
| | | positionNames.add('副经理'); |
| | | positionNames.add('经理'); |
| | | //20220517 lt SWAG-CD28H3 注释 |
| | | if(p.positionName == '高级'){ |
| | | positionNames.add('高级专员'); |
| | | }else{ |
| | | positionNames.add(p.positionName); |
| | | } |
| | | if(p.positionName == '总监级'){ |
| | | positionNames.add('副部长'); |
| | | positionNames.add('部长'); |
| | | positionNames.add('总监'); |
| | | } |
| | | // if(p.positionName == '经理级'){ |
| | | // positionNames.add('副经理'); |
| | | // positionNames.add('经理'); |
| | | // } |
| | | // if(p.positionName == '总监级'){ |
| | | // positionNames.add('副部长'); |
| | | // positionNames.add('部长'); |
| | | // positionNames.add('总监'); |
| | | // } |
| | | //20220406 lt SWAG-CD28H3 【委托】【期初修改4月6日开始修改】目标录入相关判断修改end |
| | | } |
| | | } |
| | |
| | | soql += ' and ('; |
| | | for (Integer i = 0; i < positionNames.size(); i++) { |
| | | if (i == positionNames.size() - 1) { |
| | | soql += ' Post__c = \'' + positionNames[i] + '\''; |
| | | //20220517 lt SWAG-CD28H3 Start |
| | | if(positionNames[i] != '经理级' && positionNames[i] != '总监级'){ |
| | | soql += ' HR_Post__c = \'' + positionNames[i] + '\''; |
| | | } |
| | | else if(positionNames[i] == '经理级'){ |
| | | soql += ' HR_Post__c like \'%' + s1 + '%\''; |
| | | } |
| | | else if(positionNames[i] == '总监级'){ |
| | | soql += ' HR_Post__c like \'%' + s2 + '%\''; |
| | | } |
| | | //20220517 lt SWAG-CD28H3 End |
| | | } else { |
| | | soql += ' Post__c = \'' + positionNames[i] + '\' or'; |
| | | //20220517 lt SWAG-CD28H3 Start |
| | | if(positionNames[i] != '经理级' && positionNames[i] != '总监级'){ |
| | | soql += ' HR_Post__c = \'' + positionNames[i] + '\' or'; |
| | | } |
| | | else if(positionNames[i] == '经理级'){ |
| | | soql += ' HR_Post__c like \'%' + s1 + '%\' or'; |
| | | } |
| | | else if(positionNames[i] == '总监级'){ |
| | | soql += ' HR_Post__c like \'%' + s2 + '%\' or'; |
| | | } |
| | | //20220517 lt SWAG-CD28H3 End |
| | | } |
| | | } |
| | | soql += ')'; |