本文共 4562 字，大约阅读时间需要 15 分钟。

trigger accountBillTrigger on account__c (after update,after insert) {    account__c bill = trigger.new[0];    //服务单中的收款方式不为现金，且服务单产生了应收单，且应收单的状态为未清款，且应收单产生后的一周仍然没有应收款跟踪单记录    if(bill.createWeek__c=='1'&&bill.statue__c=='未清款'){        if(bill.servicenumber__c!=null){            customerservicelist__c cusSer =[SELECT id,Name,paymentmethod__c,CreatedById  FROM customerservicelist__c WHERE id=:bill.servicenumber__c];            system.debug('cusSer:'+cusSer);            if(cusSer.paymentmethod__c!='现金'){                List
   
     deb =[SELECT id FROM debtrecord__c WHERE  servicenumber__c=:bill.servicenumber__c];                if(deb.size()==0){                    String msg ='单号为'+cusSer.Name+'的服务单产生的应收款截止目前已经一周没有催款记录，请及时跟催并将跟催情况记录到系统中，谢谢！';                    ChatterSender.send(cusSer.CreatedById,msg,cusSer.Id);                    User u=[SELECT Phone FROM User WHERE id=:cusSer.CreatedById];                    SMS.doFutureSend(u.Phone,msg);                }            }        }    }else if(bill.createWeek__c=='2'&&bill.statue__c=='未清款'){        if(bill.servicenumber__c!=null){            customerservicelist__c cusSer =[SELECT id,Name,paymentmethod__c,CreatedById FROM customerservicelist__c WHERE id=:bill.servicenumber__c];            system.debug('cusSer:'+cusSer);            if(cusSer.paymentmethod__c!='现金'){                List
    
      deb =[SELECT id FROM debtrecord__c WHERE  servicenumber__c=:bill.servicenumber__c];                if(deb.size()<2){                    String msg ='单号为'+cusSer.Name+'的服务单产生的应收款截止目前已经两周，但未满足公司要求的两周跟催两次的制度，请及时跟催并将跟催情况记录到系统中，谢谢！';                    ChatterSender.send(cusSer.CreatedById,msg,cusSer.Id);                    User u=[SELECT Phone FROM User WHERE id=:cusSer.CreatedById];                    SMS.doFutureSend(u.Phone,msg);                }            }        }    }    //现金超过7天未清空提醒技术员    if(bill.remind__c==true&&trigger.old[0].remind__c!=true){        if(bill.servicenumber__c!=null){            customerservicelist__c cus=[SELECT id,Name,CreatedById FROM customerservicelist__c WHERE id=:bill.servicenumber__c];            User u=[SELECT Phone FROM User WHERE id=:cus.CreatedById];            String msg='单号为：'+cus.Name+'的服务单为现金收款，目前已超过七天未清款，请及时将款项打给财务进行核销，谢谢！';            SMS.doFutureSend(u.Phone,msg);        }        }    //现金超过4000提醒技术员    if(bill.statue__c=='未清款'&&bill.price3__c>=4000){        if(bill.servicenumber__c!=null){            customerservicelist__c cus=[SELECT id,Name,CreatedById,paymentmethod__c FROM customerservicelist__c WHERE id=:bill.servicenumber__c];            if(cus.paymentmethod__c=='现金'){                Boolean isSendSms = true;                if(trigger.isInsert){                    isSendSms = true;                }                if(trigger.isUpdate){                    if(trigger.old[0].statue__c=='未清款'&&trigger.old[0].price3__c>=4000){                        isSendSms = false;//更新的时候不会重复发短信                    }                }                if(isSendSms){                    User u=[SELECT Phone FROM User WHERE id=:cus.CreatedById];                    String msg='单号为：'+cus.Name+'的服务单为现金收款且收款金额满足4000，请及时打款给财务进行核销，谢谢！';                    SMS.doFutureSend(u.Phone,msg);                }            }             }    }    //应收款跟催提醒（30天）    if(bill.dealline1__c&&bill.dealline1__c!=true){        if(bill.servicenumber__c!=null){            customerservicelist__c cus=[SELECT id,Name,CreatedById FROM customerservicelist__c WHERE id=:bill.servicenumber__c];            User u=[SELECT Phone FROM User WHERE id=:cus.CreatedById];            String msg='单号为：'+cus.Name+'的服务单产生的应收款截止目前已经30天还未清款，请及时跟催，谢谢！';            SMS.doFutureSend(u.Phone,msg);        }     }    //应收款跟催提醒（50天）    if(bill.deadline2__c&&bill.deadline2__c!=true){        if(bill.servicenumber__c!=null){            customerservicelist__c cus=[SELECT id,Name,CreatedById FROM customerservicelist__c WHERE id=:bill.servicenumber__c];            User u=[SELECT Phone FROM User WHERE id=:cus.CreatedById];            String msg='单号为：'+cus.Name+'的服务单产生的应收款截止目前已经50天还未清款，请及时跟催，谢谢！';            SMS.doFutureSend(u.Phone,msg);        }     }    //应收款跟催提醒（70天）    if(bill.deadline3__c&&bill.deadline3__c!=true){        if(bill.servicenumber__c!=null){            customerservicelist__c cus=[SELECT id,Name,CreatedById FROM customerservicelist__c WHERE id=:bill.servicenumber__c];            User u=[SELECT Phone FROM User WHERE id=:cus.CreatedById];            String msg='单号为：'+cus.Name+'的服务单产生的应收款截止目前已经70天还未清款，请及时跟催，谢谢！';            SMS.doFutureSend(u.Phone,msg);        }     }}
    
   

转载地址：https://lovoo.blog.csdn.net/article/details/51272492 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！