public without sharing class eSignHomePageController {
|
// 初始方法，获取当前所有任务，包括当前用户和当前用户下属的任务
|
//url 为DN号的 返回需要信息
|
//为了避免后期修改麻烦 目前没有把DN号 和 客户id两种后台检索方法合在一起
|
//签收页面后台检索
|
@AuraEnabled
|
public static eSignWrapper getDNSignUpStatus(string DNName){
|
list<eSignForm__c> tempEsignFormList = new list<eSignForm__c> ();
|
list<eSignFormEntry__c> tempEsignFormEntryList = new list<eSignFormEntry__c> ();
|
try {
|
tempEsignFormList =
|
[select id ,HPDNSignUpStatus__c,agencyDNSignUpStatus__c,
|
HPScanDay__c,agencyScanDay__c,handleOpinionAgency__c,DNNameNo0__c,
|
Sales_Root_Formula__c, HPAcceptResult__c,HPSignUpDate__c,
|
agencyAcceptResult__c, salesHPManageConfirmDate__c,
|
salesManageConfirmDate__c,salesHPManageFBDate__c,salesManageFBDate__c
|
,agencyAutoSignUpStatus__c,HPSignUpStatus__c,agencyConfirmDate__c,endUser__c,HPConfirmDate__c,agencySignUpDate__c,skip_Hospital_Sign__c,skip_Distribution_Sign__c,
|
//根据不同情况返回对应的提示信息 精琢技术 thh 2021-10-09 start
|
skip_Distribution_Sign_Message__c, skip_Hospital_Sign_Message__c
|
//根据不同情况返回对应的提示信息 精琢技术 thh 2021-10-09 end
|
from eSignForm__c
|
where DNNameNo0__c =: DNName ];
|
//system.debug('tempEsignFormList:'+tempEsignFormList[0]);
|
} catch (Exception ex) {
|
return null;
|
}
|
|
try {
|
tempEsignFormEntryList =
|
[select id ,entryType__c,
|
Sales_Root_Formula__c, HPAcceptResult__c,HPDNSignUpStatus__c,agencyDNSignUpStatus__c,
|
HPScanDay__c,agencyScanDay__c,handleOpinionAgency__c,DNNameNo0__c,
|
agencyAcceptResult__c, salesHPManageConfirmDate__c,HPSignUpDate__c,
|
salesManageConfirmDate__c,salesHPManageFBDate__c,salesManageFBDate__c
|
,agencyAutoSignUpStatus__c,HPSignUpStatus__c,IsSubmit__c,IsHPSubmit__c,agencyConfirmDate__c,agencySignUpDate__c
|
,agencyScanDayBack__c,agencySignUpDateBack__c,agencyConfirmDateBack__c,endUser__c,HPConfirmDate__c,IsHandled__c,skip_Hospital_Sign__c,skip_Distribution_Sign__c,
|
//根据不同情况返回对应的提示信息 精琢技术 thh 2021-10-09 start
|
skip_Distribution_Sign_Message__c, skip_Hospital_Sign_Message__c
|
//根据不同情况返回对应的提示信息 精琢技术 thh 2021-10-09 end
|
from eSignFormEntry__c
|
where DNNameNo0__c =: DNName
|
order by createddate desc
|
];
|
//system.debug('tempEsignFormEntryList:'+tempEsignFormEntryList[0]);
|
} catch (Exception ex) {
|
return null;
|
}
|
Boolean isAgencySubmit = false;
|
Boolean isHPSubmit = false;
|
|
String entryType = '';
|
//new
|
eSignWrapper eSignWrapper = new eSignWrapper(isAgencySubmit,isHPSubmit,entryType);
|
//先判断有没有中间表 没有则赋值为空
|
if(tempEsignFormEntryList.size() > 0 ){
|
eSignWrapper.eSignFormEntry = tempEsignFormEntryList[0];
|
if(tempEsignFormEntryList[0].IsSubmit__c){
|
isAgencySubmit = true;
|
entryType = tempEsignFormEntryList[0].entryType__c;
|
}
|
if(tempEsignFormEntryList[0].IsHPSubmit__c){
|
isHPSubmit = true;
|
entryType = tempEsignFormEntryList[0].entryType__c;
|
}
|
}else{
|
eSignWrapper.eSignFormEntry = null;
|
}
|
//
|
if(tempEsignFormList.size() > 0){
|
eSignWrapper.eSignForm = tempEsignFormList[0];
|
}else{
|
eSignWrapper.eSignForm = null;
|
}
|
eSignWrapper.isAgencySubmit =isAgencySubmit;
|
eSignWrapper.isHPSubmit =isHPSubmit;
|
eSignWrapper.entryType =entryType;
|
return eSignWrapper;
|
}
|
|
//DN清单页后台检索方法
|
@AuraEnabled
|
public static eSignWrapperList getDNSignUpLists(String id ,String type){
|
list<eSignForm__c> tempEsignFormList = new list<eSignForm__c> ();
|
list<eSignFormEntry__c> tempEsignFormEntryList = new list<eSignFormEntry__c> ();
|
|
//传过来是18位的 截取一下
|
id = id.substring(0,15);
|
Date todate = Date.today();
|
//签收单list
|
try {
|
|
//检索id，DN号，经销商名称，合同编号，医院名，经销商签收状态,医院签收状态，发货日期
|
String sql = 'select id ,Agency1_Name_F__c,ContractNO__c,Hospital_Name__c,DeliveryDate__c,HPDNSignUpStatus__c,agencyDNSignUpStatus__c,';
|
sql +='HPScanDay__c,agencyScanDay__c,handleOpinionAgency__c,DNNameNo0__c,Sales_Root_Formula__c, HPAcceptResult__c,HPSignUpDate__c,';
|
sql +='agencyAcceptResult__c, salesHPManageConfirmDate__c,salesManageConfirmDate__c,salesHPManageFBDate__c,salesManageFBDate__c,';
|
sql +='agencyAutoSignUpStatus__c,HPSignUpStatus__c,agencyConfirmDate__c,endUser__c,endUserName__c,HPConfirmDate__c,endConfirmDate__c,Hospital_Name_Text__c,CustomerNameContract__c,agencySignUpDate__c,skip_Hospital_Sign__c,skip_Distribution_Sign__c,skip_Distribution_Sign_Message__c, skip_Hospital_Sign_Message__c ';
|
sql +=' from eSignForm__c ';
|
//当isProcessed__c 为true的时候，工作流更新日期 所以不会有日期为null并且还打勾的情况
|
sql +=' where (isProcessed__c = false or (isProcessed__c = true and endConfirmDate__c >: todate)) ';
|
|
//退货则不被检索
|
//sql +=' and ReturnMark__c = false ';
|
//根据传入的经销商或者医院传入不同的where 条件
|
if(type == 'Agency'||type == 'AgencyContract'){
|
sql +=' and Agency1_ID__c =: id ';
|
}else if(type == 'HP'){
|
sql +=' and Hospital_ID__c =: id ';
|
}
|
sql +=' order by createddate desc ';
|
tempEsignFormList =DataBase.query(sql);
|
//System.debug('tempEsignFormList+++'+tempEsignFormList);
|
} catch (Exception ex) {
|
//System.debug('ex+++'+ex);
|
return null;
|
}
|
//签收单录入表 list
|
try {
|
|
String query = 'select id ,isProcessed__c,DNSignUpStatus__c,ContractNO__c,Hospital_Name__c,DeliveryDate__c,';
|
query +='entryType__c,Sales_Root_Formula__c, HPAcceptResult__c,HPDNSignUpStatus__c,agencyDNSignUpStatus__c,';
|
query +='HPScanDay__c,agencyScanDay__c,handleOpinionAgency__c,DNNameNo0__c,agencyAcceptResult__c, salesHPManageConfirmDate__c,HPSignUpDate__c,';
|
query +='salesManageConfirmDate__c,salesHPManageFBDate__c,salesManageFBDate__c,agencyAutoSignUpStatus__c,HPSignUpStatus__c,IsSubmit__c,IsHPSubmit__c,agencyConfirmDate__c,';
|
query +='agencyScanDayBack__c,agencySignUpDateBack__c,agencyConfirmDateBack__c,endUser__c,HPConfirmDate__c,endConfirmDate__c,Hospital_Name_Text__c,CustomerNameContract__c,agencySignUpDate__c,IsHandled__c,skip_Distribution_Sign_Message__c, skip_Hospital_Sign_Message__c ';
|
query +=' from eSignFormEntry__c ';
|
query +=' where IsHandled__c = false ';
|
//and ReturnMark__c = false
|
//根据传入的经销商或者医院传入不同的where 条件
|
if(type == 'Agency' ||type == 'AgencyContract'){
|
query +=' and Agency1_ID__c =: id ';
|
}else if(type == 'HP'){
|
query +=' and Hospital_ID__c =: id ';
|
}
|
// query +=' order by createddate desc ';
|
|
tempEsignFormEntryList = DataBase.query(query);
|
//System.debug('tempEsignFormEntryList+++'+tempEsignFormEntryList);
|
} catch (Exception ex) {
|
return null;
|
}
|
//new
|
eSignWrapperList eWList = new eSignWrapperList();
|
//先判断有没有中间表 没有则赋值为空
|
if(tempEsignFormEntryList.size() > 0 ){
|
for(eSignFormEntry__c esfe:tempEsignFormEntryList){
|
if(esfe.endUser__c =='契約'){
|
esfe.Hospital_Name_Text__c = esfe.CustomerNameContract__c;
|
}else{
|
esfe.Hospital_Name_Text__c = esfe.Hospital_Name__c;
|
}
|
}
|
eWList.eSignFormEntryList = tempEsignFormEntryList;
|
}else{
|
eWList.eSignFormEntryList = null;
|
}
|
system.debug('ceshi4+++'+tempEsignFormList);
|
if(tempEsignFormList.size() > 0){
|
//fy 20220727 start
|
List<Id> eSignFormId = new List<Id>();
|
for(eSignForm__c es:tempEsignFormList){
|
eSignFormId.add(es.Id);
|
}
|
List<Attachment> AttachmentList= new List<Attachment>();
|
AttachmentList =[select Id,name,ParentId from Attachment where ParentId in:eSignFormId];
|
Map<String,String> AttachmentMap = new Map<String,String>();
|
List<String> AttachmentStringList = new List<String>();
|
if(AttachmentList.size() > 0){
|
for(Attachment Att:AttachmentList){
|
AttachmentMap.put(Att.ParentId, Att.ParentId+'_'+Att.name);
|
}
|
for (String value : AttachmentMap.values()) {
|
AttachmentStringList.add(value);
|
}
|
}
|
|
system.debug('ceshi1+++'+AttachmentList);
|
system.debug('ceshi2+++'+AttachmentStringList);
|
system.debug('ceshi3+++'+eSignFormId);
|
//fy 20220727 end
|
for(eSignForm__c esf:tempEsignFormList){
|
if(esf.endUser__c =='契約'){
|
esf.Hospital_Name_Text__c = esf.CustomerNameContract__c;
|
}else{
|
esf.Hospital_Name_Text__c = esf.Hospital_Name__c;
|
}
|
}
|
eWList.eSignFormList = tempEsignFormList;
|
//fy 20220727 start
|
if(AttachmentStringList.size()>0){
|
eWList.AttachmentStringList = AttachmentStringList;
|
}
|
//fy 20220727 end
|
}else{
|
eWList.eSignFormList = null;
|
}
|
|
return eWList;
|
|
}
|
|
//区分经销商/医院 传入客户的管理编码
|
@AuraEnabled
|
public static eSignAccount getAccount(String managementCode){
|
//CHAN-BX736B 【委托】请帮恢复河南嘉信元泰医疗器械有限公司签收单明细 精琢技术 wql 2021/01/18 start
|
//根据管理编码 检索有效的客户 使用去0的管理编码 字段 and Is_Active_Formula__c = '有效'
|
//CHAN-BX736B 【委托】请帮恢复河南嘉信元泰医疗器械有限公司签收单明细 精琢技术 wql 2021/01/18 end
|
List<Account> accList = [select id,RecordType.developerName,name from Account where Management_FormulaCode__c =: managementCode ];
|
|
String accountId = '';
|
String recordTypeName = '';
|
String agencyName = '';
|
if(accList.size()>0){
|
accountId =accList[0].id;
|
recordTypeName = accList[0].RecordType.developerName;
|
agencyName = accList[0].name;
|
|
}
|
eSignAccount acc = new eSignAccount(accountId,recordTypeName,agencyName);
|
acc.accountId = accountId;
|
acc.recordTypeName = recordTypeName;
|
acc.agencyName = agencyName;
|
|
return acc;
|
}
|
|
@AuraEnabled
|
public static List<Product2> getProduct(List<Id> ids){
|
List<Product2> proLists = NewQuoteEntryWebService.getProduct2(ids);
|
|
return proLists;
|
}
|
|
//公用类 返回签收单对象或者签收单录入表对象
|
public class eSignWrapper{
|
@AuraEnabled
|
public eSignFormEntry__c eSignFormEntry;
|
|
@AuraEnabled
|
public eSignForm__c eSignForm;
|
//判断是否有经销商已提交的数据
|
@AuraEnabled
|
public Boolean isAgencySubmit;
|
//判断是否有医院已提交的数据
|
@AuraEnabled
|
public Boolean isHPSubmit;
|
//判断传入的类型
|
@AuraEnabled
|
public String entryType;
|
|
public eSignWrapper(Boolean isAgencySubmit,Boolean isHPSubmit,String entryType){
|
eSignFormEntry = new eSignFormEntry__c();
|
eSignForm = new eSignForm__c();
|
isAgencySubmit = isAgencySubmit;
|
isHPSubmit = isHPSubmit;
|
entryType = entryType;
|
}
|
|
}
|
|
//公用类 返回签收单list或者签收单录入表list
|
public class eSignWrapperList{
|
@AuraEnabled
|
public List<eSignFormEntry__c> eSignFormEntryList;
|
|
@AuraEnabled
|
public List<eSignForm__c> eSignFormList;
|
//fy 20220727 start
|
@AuraEnabled
|
public List<String> AttachmentStringList;
|
//fy 20220727 end
|
public eSignWrapperList(){
|
eSignFormEntryList = new List<eSignFormEntry__c>();
|
eSignFormList = new List<eSignForm__c>();
|
//fy 20220727 start
|
List<String> AttachmentStringList = new List<String>();
|
//fy 20220727 end
|
}
|
|
}
|
|
//公用类 返回客户id 和记录类型developerName （Agency、HP、AgencyContract）
|
public class eSignAccount{
|
@AuraEnabled
|
public String accountId;
|
|
@AuraEnabled
|
public String recordTypeName;
|
|
@AuraEnabled
|
public String agencyName;
|
|
public eSignAccount(String accountId,String recordTypeName,String agencyName){
|
accountId = accountId;
|
recordTypeName = recordTypeName;
|
agencyName = agencyName;
|
}
|
|
}
|
}
|
