public without sharing class ConInvoiceViewController {
|
//经销商产品分类
|
public String agencyProType {get;set;}
|
//发票使用
|
public Consumable_order__c coc { get; set; }
|
//出库单使用
|
public Consumable_order__c outbound { get; set; }
|
//发票ID
|
public String invoiceId {get;set;}
|
public String orderRemind {get;set;}
|
public String deliveryId {get;set;}
|
public String reopen {get;set;}
|
public Decimal sumPrice {get;set;}
|
public Boolean isChange {get;set;}
|
//用户信息
|
private String accountid = null;
|
private String userId = '';
|
|
public Boolean getdone() {
|
return (invoiceOrderdetail1Recoeds.size() > 0);
|
}
|
|
public Boolean getExistOutbound() {
|
return (coc.Outbound_order__c != null);
|
}
|
|
public String getInvoiceName() {
|
return (coc.Name);
|
}
|
// 精琢科技 zxk 2021-11-03 存放消耗品明细 end
|
public List < Consumable_Orderdetails__c > conoList {
|
get;
|
set;
|
}
|
// 精琢科技 zxk 2021-11-03 存放消耗品明细 end
|
|
public String shipmentAccount{
|
get {
|
return (coc.ShipmentAccount__c);
|
}
|
}
|
//编辑状态
|
public String statusEdit = '';
|
public Boolean editAble {get;set;}
|
|
public List<InvoiceOrderInfo> invoiceOrderRecoeds { get; set; }
|
//出库单明细
|
public List<InvoiceOrderInfo> invoiceOrderdetail1Recoeds { get; set; }
|
//换货出库单list
|
public List<InvoiceOrderInfo> invoiceOrderRecoedschange = new List<InvoiceOrderInfo>();
|
//附件
|
public List<InvoiceOrderInfo> attachmentRecoeds { get; set; }
|
public List<Consumable_order__c> invoiceOrderList = new List<Consumable_order__c>();
|
//发票明细1（出库单）
|
private List<Consumable_order__c> invoiceOrderSelectedList = new List<Consumable_order__c>();
|
|
|
|
Map<String,Decimal> ordermx1defaultMap = new Map<String,Decimal>();
|
//出库单汇总金额 from 发票明细1
|
Map<String,Decimal> outorderMoneytMap = new Map<String,Decimal>();
|
//发票明细1关联产品数量
|
Map<String,Consumable_Orderdetails__c> outordercountMap = new Map<String,Consumable_Orderdetails__c>();
|
//发票关联出库单取得
|
List<String> outOrderStringList = new List<String>();
|
//二级经销商选择框
|
public List<SelectOption> provinceOpts { get; set; }
|
public String SecondDealer {get;set;}
|
//public List<SelectOption> orderForHospitalOpts { get; set; }
|
public String HospitalInfo {get;set;}
|
public String HospitalName {get;set;}
|
|
//明细数量
|
public Integer invoiceOrderRecoedsCount {
|
get {
|
return invoiceOrderRecoeds == null ? 0 : invoiceOrderRecoeds.size();
|
}
|
}
|
|
list<Dealer_elationship__c> Dealerelationship = new list<Dealer_elationship__c>();
|
//排序使用
|
private String[] orderby = new String[]{ 'Outbound_Date__c','Name','ShipmentAccount__c'};
|
public String sortKey { get; set; }
|
public String preSortKey { get; private set; }
|
public Boolean sortOrderAsc { get; private set; }
|
public String[] sortOrder { get; private set; }
|
// 登录者工作地
|
private String userWorkLocation;
|
|
public ConInvoiceViewController() {
|
invoiceId = ApexPages.currentPage().getParameters().get('invoiceId');
|
statusEdit = ApexPages.currentPage().getParameters().get('KeyWords');
|
deliveryId = ApexPages.currentPage().getParameters().get('deliveryId');
|
reopen = ApexPages.currentPage().getParameters().get('reopen');
|
provinceOpts = new List<SelectOption>();
|
//orderForHospitalOpts = new List<SelectOption>();
|
invoiceOrderRecoeds = new List<InvoiceOrderInfo>();
|
attachmentRecoeds = new List<InvoiceOrderInfo>();
|
invoiceOrderdetail1Recoeds = new List<InvoiceOrderInfo>();
|
invoiceOrderRecoedschange = new List<InvoiceOrderInfo>();
|
orderRemind = '';
|
isChange = false;
|
conoList = new List < Consumable_Orderdetails__c > ();
|
}
|
//页面初始化
|
public void init() {
|
sumPrice = 0;
|
this.sortKey = '1';
|
this.preSortKey = '1';
|
this.sortOrderAsc = false;
|
this.sortOrder = new String[2];
|
this.sortOrder = new String[]{' ',' ',' ',' '};
|
|
if(invoiceId!=null && invoiceId!='' && (statusEdit==''|| statusEdit==null)){
|
editAble = false;
|
}else if((invoiceId == null||invoiceId=='') && (statusEdit==''||statusEdit==null)){
|
editAble = true;
|
}else if(invoiceId != null && invoiceId !='' && statusEdit !='' && statusEdit!=null){
|
editAble = true;
|
}
|
userId = UserInfo.getUserId();
|
//userId = '00510000005QQ35';
|
List<user> Useracc = New List<user>();
|
Useracc = [SELECT accountid, Work_Location__c,UserPro_Type__c FROM user WHERE id = :userId ];
|
accountid = Useracc[0].accountid;
|
userWorkLocation = Useracc[0].Work_Location__c;
|
agencyProType = Useracc[0].UserPro_Type__c;
|
if(String.isBlank(Useracc[0].UserPro_Type__c)){
|
agencyProType = 'ET';
|
}
|
coc = new Consumable_order__c();
|
|
Dealerelationship = [SELECT Dealer_subordinate__c,Dealer_subordinate__r.Name FROM Dealer_elationship__c WHERE Dealer_principal__c =:accountid ];
|
List<Agency_Hospital_Link__c> AgencyHospitalLink = new List<Agency_Hospital_Link__c>();
|
AgencyHospitalLink = [select Id, Name, Hospital__c, Hospital__r.Id, Hospital__r.Name, Agency__c
|
from Agency_Hospital_Link__c
|
WHERE Agency__c = :accountId];
|
// 新規
|
if (invoiceId== NULL || invoiceId=='') {
|
if (deliveryId== NULL || deliveryId=='') {
|
String msoql = makeSoql();
|
invoiceOrderList = Database.query(msoql);
|
for(Integer i = 0; i < invoiceOrderList.size(); i++){
|
invoiceOrderRecoeds.add(new InvoiceOrderInfo(invoiceOrderList[i]));
|
}
|
}else{
|
if(statusEdit=='' || statusEdit==null){
|
EditAble = false;
|
}else if(statusEdit!=''&&statusEdit!=null){
|
EditAble = true;
|
}
|
coc = [SELECT Id,Name,
|
Invoice_status__c,
|
Invoice_Date__c,
|
Order_ForDealerText__c,
|
Dealer_Info__c,
|
Order_ForDealer__c,
|
Order_ForDealer__r.Name,
|
Order_ForHospital__c,
|
Order_ForHospital__r.Name,
|
Order_date__c,
|
Billed_Status__c,
|
ShipmentAccount__c,
|
Order_Dealer_Info__c,
|
SummonsForDirction__c,
|
Order_ForCustomerText__c,
|
Invoice_Note__c,
|
Invoice_attachment__c,
|
Invoicedet_attachment__c,
|
Outbound_order__c
|
FROM Consumable_order__c
|
WHERE Id =:deliveryId];
|
coc.Name = '';
|
if(coc.Order_ForDealer__c != null){
|
SecondDealer = coc.Order_ForDealer__c;
|
}
|
|
if(coc.Order_ForHospital__c != null){
|
HospitalInfo = coc.Order_ForHospital__c;
|
HospitalName = coc.Order_ForHospital__r.Name;
|
}
|
|
//发票关联出库单取得（出库单）
|
invoiceOrderSelectedList = [SELECT Id,
|
Order_ForDealer__r.Name,
|
Order_ForHospital__r.Name,
|
Order_ForDealerText__c,
|
Name,Outbound_Date__c,
|
ShipmentAccount__c,
|
Order_Dealer_Info__c,
|
SummonsForDirction__c,
|
Shipment_total_amount__c,
|
RrturnPro_total_amount__c,
|
Total_Invoiced_Procount__c,
|
InvoiceNotPro_total_amount__c,
|
InvoiceNotPro_money__c,
|
Invoice_total_amount__c,
|
Billed_Status__c
|
FROM Consumable_order__c
|
WHERE Id = :deliveryId
|
order by Name ];
|
for(Integer i = 0; i < invoiceOrderSelectedList.size(); i++){
|
invoiceOrderRecoeds.add(new InvoiceOrderInfo(invoiceOrderSelectedList[i]));
|
}
|
}
|
}else{
|
coc = [SELECT Id,Name,
|
Invoice_status__c,
|
Invoice_Date__c,
|
Order_ForDealerText__c,
|
Dealer_Info__c,
|
Order_ForDealer__c,
|
Order_ForDealer__r.Name,
|
Order_ForHospital__c,
|
Order_ForHospital__r.Name,
|
Order_date__c,
|
Billed_Status__c,
|
ShipmentAccount__c,
|
Order_Dealer_Info__c,
|
SummonsForDirction__c,
|
Order_ForCustomerText__c,
|
Invoice_Note__c,
|
Invoice_attachment__c,
|
Invoicedet_attachment__c,
|
Outbound_order__c
|
FROM Consumable_order__c
|
WHERE Id =:invoiceId
|
AND Order_type__c = '发票'];
|
if(coc.Order_ForDealer__c != null){
|
SecondDealer = coc.Order_ForDealer__c;
|
}
|
if(coc.Order_ForHospital__c != null){
|
HospitalInfo = coc.Order_ForHospital__c;
|
HospitalName = coc.Order_ForHospital__r.Name;
|
}
|
//到链接表中查找关联出库单
|
List<Consumable_order_LinkTable__c> outOrderList = [SELECT Outboundorder_Code_link__c
|
FROM Consumable_order_LinkTable__c
|
WHERE Invoice_Code_link__c = :invoiceId];
|
for(Integer i = 0; i < outOrderList.size(); i++){
|
outOrderStringList.add(outOrderList[i].Outboundorder_Code_link__c);
|
}
|
//取得出库单信息
|
invoiceOrderSelectedList = [SELECT Id,
|
Order_ForDealer__r.Name,
|
Order_ForHospital__r.Name,
|
Order_ForDealerText__c,
|
Name,Outbound_Date__c,
|
ShipmentAccount__c,
|
Shipment_total_amount__c,
|
RrturnPro_total_amount__c,
|
Total_Invoiced_Procount__c,
|
InvoiceNotPro_total_amount__c,
|
InvoiceNotPro_money__c,
|
Invoice_total_amount__c,
|
Billed_Status__c
|
FROM Consumable_order__c
|
WHERE Id in :outOrderStringList
|
AND Order_Owner_WorkLocal__c =: userWorkLocation
|
order by Name ];
|
for(Integer i = 0; i < invoiceOrderSelectedList.size(); i++){
|
outorderMoneytMap.put(invoiceOrderSelectedList[i].id, 0);
|
invoiceOrderRecoeds.add(new InvoiceOrderInfo(invoiceOrderSelectedList[i]));
|
}
|
if(String.isNotBlank(deliveryId)){
|
//发票关联出库单取得（出库单）
|
isChange = true;
|
invoiceOrderSelectedList = [SELECT Id,
|
Order_ForDealer__r.Name,
|
Order_ForHospital__r.Name,
|
Order_ForDealerText__c,
|
Name,Outbound_Date__c,
|
ShipmentAccount__c,
|
Shipment_total_amount__c,
|
RrturnPro_total_amount__c,
|
Total_Invoiced_Procount__c,
|
InvoiceNotPro_total_amount__c,
|
InvoiceNotPro_money__c,
|
Invoice_total_amount__c,
|
Billed_Status__c
|
FROM Consumable_order__c
|
WHERE Id = :deliveryId
|
AND Order_Owner_WorkLocal__c =: userWorkLocation
|
order by Name ];
|
for(Integer i = 0; i < invoiceOrderSelectedList.size(); i++){
|
if(!outorderMoneytMap.containsKey(invoiceOrderSelectedList[i].Id)){
|
invoiceOrderRecoeds.add(new InvoiceOrderInfo(invoiceOrderSelectedList[i]));
|
invoiceOrderRecoedschange.add(new InvoiceOrderInfo(invoiceOrderSelectedList[i]));
|
}
|
}
|
}
|
//发票明细一览
|
List<Consumable_Orderdetails__c> countDel = [SELECT Id,
|
Consumable_ZS_order__c,
|
Name,
|
Consumable_order__c,
|
Invoicedet1_OD_link__c,
|
Invoicedet1_OD_link__r.Name,
|
Consumable_order__r.Name,
|
Product_OutDate__c,
|
Asset_Model_No__c,
|
Invoice_Unitprice__c,
|
Delivery_List_RMB__c,
|
Invoiced_Procount__c,
|
Invoiced_Count__c,
|
InvoicedProCost_RMB__c,
|
Box_Piece__c,
|
Invoice_Unit__c,
|
ProductPacking_list_manual__c
|
FROM Consumable_Orderdetails__c
|
WHERE Consumable_order__c = :invoiceId
|
order by Invoicedet1_OD_link__c];
|
if(countDel.size()>0){
|
for (Integer i = 0; i < countDel.size(); i++) {
|
outordercountMap.put(countDel[i].Invoicedet1_OD_link__c + countDel[i].Asset_Model_No__c,countDel[i]);
|
if(outorderMoneytMap.containsKey(countDel[i].Invoicedet1_OD_link__c)){
|
outorderMoneytMap.put(countDel[i].Invoicedet1_OD_link__c,outorderMoneytMap.get(countDel[i].Invoicedet1_OD_link__c) + countDel[i].InvoicedProCost_RMB__c);
|
}
|
invoiceOrderdetail1Recoeds.add(new InvoiceOrderInfo(countDel[i]));
|
}
|
}
|
for (InvoiceOrderInfo ass : invoiceOrderRecoeds) {
|
if(outorderMoneytMap.containsKey(ass.esd.id)){
|
ass.needInvoiceCount = outorderMoneytMap.get(ass.esd.id);
|
}
|
ass.check = true;
|
}
|
}
|
//ApexPages.addmessage(new ApexPages.message(ApexPages.severity.Error, 'outordercountMap +++++' + outordercountMap.size() + outordercountMap));
|
if(SecondDealer==null||SecondDealer==''){
|
provinceOpts.add(new SelectOption('', '-无-'));
|
for(Integer i = 0; i < Dealerelationship.size(); i++){
|
provinceOpts.add(new SelectOption(Dealerelationship[i].Dealer_subordinate__c, Dealerelationship[i].Dealer_subordinate__r.Name));
|
}
|
}else{
|
provinceOpts.add(new SelectOption('', '-无-'));
|
for(Integer i = 0; i < Dealerelationship.size(); i++){
|
if(Dealerelationship[i].Dealer_subordinate__r.Name == SecondDealer){
|
provinceOpts.add(new SelectOption(Dealerelationship[i].Dealer_subordinate__c, SecondDealer));
|
}
|
}
|
for(Integer i = 0; i < Dealerelationship.size(); i++){
|
if(Dealerelationship[i].Dealer_subordinate__r.Name != SecondDealer){
|
provinceOpts.add(new SelectOption(Dealerelationship[i].Dealer_subordinate__c, Dealerelationship[i].Dealer_subordinate__r.Name));
|
}
|
}
|
}
|
|
/*if(HospitalInfo==null||HospitalInfo==''){
|
orderForHospitalOpts.add(new SelectOption('', '-无-'));
|
for(Integer i = 0; i < AgencyHospitalLink.size(); i++){
|
orderForHospitalOpts.add(new SelectOption(AgencyHospitalLink[i].Hospital__c, AgencyHospitalLink[i].Hospital__r.Name));
|
}
|
}else{
|
orderForHospitalOpts.add(new SelectOption('', '-无-'));
|
for(Integer i = 0; i < AgencyHospitalLink.size(); i++){
|
if(AgencyHospitalLink[i].Hospital__c == HospitalInfo){
|
orderForHospitalOpts.add(new SelectOption(AgencyHospitalLink[i].Hospital__c, AgencyHospitalLink[i].Hospital__r.Name));
|
}
|
}
|
for(Integer i = 0; i < AgencyHospitalLink.size(); i++){
|
if(AgencyHospitalLink[i].Hospital__c != HospitalInfo){
|
orderForHospitalOpts.add(new SelectOption(AgencyHospitalLink[i].Hospital__c, AgencyHospitalLink[i].Hospital__r.Name));
|
}
|
}
|
}*/
|
|
|
|
Map<String,String> consumableaccessoriesMap = new Map<String,String>();
|
Map<String,String> invorceOrderIdMap = new Map<String,String>();
|
List<Consumable_accessories_invoice__c> consumableaccessories =[SELECT Id, Name,Attachment_ID__c,Accessories_type__c FROM Consumable_accessories_invoice__c WHERE Invoice_code__c =:invoiceId ];
|
if(consumableaccessories.size()>0){
|
for (Integer i = 0; i < consumableaccessories.size(); i++) {
|
consumableaccessoriesMap.put(consumableaccessories[i].Attachment_ID__c,consumableaccessories[i].Accessories_type__c);
|
invorceOrderIdMap.put(consumableaccessories[i].Attachment_ID__c,consumableaccessories[i].Id);
|
}
|
}
|
|
List<Attachment> attachmentinfo =[SELECT Id, Name,OwnerId,CreatedDate FROM Attachment WHERE parentid =:invoiceId ];
|
if(attachmentinfo.size()>0){
|
for (Integer i = 0; i < attachmentinfo.size(); i++) {
|
attachmentRecoeds.add(new InvoiceOrderInfo(attachmentinfo[i]));
|
}
|
}
|
for (InvoiceOrderInfo ass : attachmentRecoeds) {
|
if(consumableaccessoriesMap.containsKey(ass.attach.Id)){
|
ass.mailSelectOptsin = consumableaccessoriesMap.get(ass.attach.Id);
|
ass.invoiceOrderId = invorceOrderIdMap.get(ass.attach.Id);
|
}
|
}
|
//nvoiceorderremind();
|
//ApexPages.addmessage(new ApexPages.message(ApexPages.severity.Error, shipmentAccount + '请先打印指示单！'));
|
}
|
|
// 检索(未开发票出库单)
|
public void InvoiceorderSearch() {
|
Map<String,String> invoiceOrderMap = new Map<String,String>();
|
String msoql ='';
|
List<InvoiceOrderInfo> invoiceOrderdetailMid = new List<InvoiceOrderInfo>();
|
if(String.isBlank(invoiceId)){
|
msoql = makeSoql();
|
}else{
|
msoql = makeSoqlInit();
|
}
|
//String msoql = makeSoql();
|
invoiceOrderList = Database.query(msoql);
|
for (InvoiceOrderInfo ass : invoiceOrderRecoeds) {
|
if(ass.check == true){
|
invoiceOrderdetailMid.add(ass);
|
invoiceOrderMap.put(ass.esd.Name,ass.esd.Name);
|
}
|
}
|
invoiceOrderRecoeds = new List<InvoiceOrderInfo>();
|
invoiceOrderRecoeds.addAll(invoiceOrderdetailMid);
|
for(Integer i = 0; i < invoiceOrderList.size(); i++){
|
if(invoiceOrderMap.containsKey(invoiceOrderList[i].Name)){
|
}else{
|
invoiceOrderRecoeds.add(new InvoiceOrderInfo(invoiceOrderList[i]));
|
invoiceOrderMap.put(invoiceOrderList[i].Name, invoiceOrderList[i].Name);
|
}
|
}
|
}
|
|
public void nvoiceorderremind() {
|
List<String> invoiceOrderAccountList = new List<String>();
|
for (InvoiceOrderInfo ass : invoiceOrderRecoeds) {
|
if(ass.check == true && ass.esd.ShipmentAccount__c != shipmentAccount){
|
invoiceOrderAccountList.add(ass.esd.Name);
|
}
|
}
|
if(invoiceOrderAccountList.size() > 0 ){
|
orderRemind = '出库单'+ invoiceOrderAccountList + '客户名与发票客户名不一致！';
|
ApexPages.addmessage(new ApexPages.message(ApexPages.severity.WARNING, orderRemind));
|
}else{
|
orderRemind = '';
|
//return '';
|
}
|
}
|
// 保存附件
|
public PageReference saveAttachment() {
|
Consumable_accessories_invoice__c attachmentdetails = new Consumable_accessories_invoice__c();
|
for (InvoiceOrderInfo ass : AttachmentRecoeds) {
|
if(!String.isBlank(ass.mailSelectOptsin)){
|
attachmentdetails.Id = ass.invoiceOrderId;
|
attachmentdetails.Attachment_ID__c = ass.attach.Id;
|
attachmentdetails.Accessories_type__c = ass.mailSelectOptsin;
|
if(String.isBlank(ass.invoiceOrderId)){
|
attachmentdetails.Invoice_code__c = invoiceId;
|
}
|
upsert attachmentdetails;
|
}
|
}
|
return UnabletoEdit();
|
}
|
// 保存按钮
|
public PageReference save() {
|
List<String> chukudanID = new List<String>();
|
// 画面录入项判断
|
//ApexPages.addmessage(new ApexPages.message(ApexPages.severity.Error, 'HospitalInfo +++++' + HospitalInfo + '-----' + HospitalName));
|
//return null;
|
if(coc.Name ==''||coc.Name == null){
|
coc.Name.addError('请录入发票号。');
|
return null;
|
}
|
if(coc.Invoice_Date__c == null){
|
coc.Invoice_Date__c.addError('请录入发票日期。');
|
return null;
|
}
|
//CHAN-BSS5SQ update by rentongxiao 2020-08-26 start
|
|
/*if(String.isBlank(HospitalInfo) && SecondDealer == null && coc.Order_ForDealerText__c == null){
|
coc.addError('必须输入客户名或者经销商。');
|
return null;
|
}*/
|
if(String.isBlank(HospitalInfo) && SecondDealer == null){
|
coc.addError('必须输入客户名或者二级经销商。');
|
return null;
|
}
|
/*if(String.isBlank(HospitalInfo) && SecondDealer != null && coc.Order_ForDealerText__c != null){
|
coc.Order_ForDealerText__c.addError('请输入二级经销商或者经销商（录入）。');
|
return null;
|
}*/
|
//CHAN-BSS5SQ update by rentongxiao 2020-08-26 start
|
/* if(HospitalInfo !=null && HospitalInfo !='' && SecondDealer != null && coc.Order_ForDealerText__c != null){
|
coc.addError('请输入客户名、二级经销商和经销商（录入）只可输入一个。');
|
return null;
|
}
|
*/
|
if (HospitalInfo != null && HospitalInfo != '' && SecondDealer != null) {
|
coc.addError('请输入客户名、二级经销商只可输入一个。');
|
|
}
|
/* if(HospitalInfo !=null && HospitalInfo !='' && (SecondDealer != null || coc.Order_ForDealerText__c != null)){
|
coc.addError('请输入客户名、二级经销商和经销商（录入）只可输入一个。');
|
return null;
|
}*/
|
//CHAN-BSS5SQ update by rentongxiao 2020-08-26 end
|
if(HospitalInfo !=null && HospitalInfo !=''){
|
if(coc.Order_ForCustomerText__c ==null){
|
coc.Order_ForCustomerText__c.addError('请输入科室。');
|
return null;
|
}
|
}else{
|
if(coc.Order_ForCustomerText__c !=null){
|
coc.Order_ForCustomerText__c.addError('不需要输入科室。');
|
return null;
|
}
|
}
|
//update by rentx 2021-02-24 CHAN-BYH9PK start
|
//因为之前默认 医院 二级经销商 经销商录入只能出入一个值,所以不会出错,但是现在的情况是经销商有值 经销商录入也有值 所以会报错,因此修改 shipmentAccountString 只能存放一个值即可
|
String shipmentAccountString ='';
|
// String a = HospitalInfo == null? '' : HospitalInfo;
|
// String b = SecondDealer == null? '' : SecondDealer;
|
// String c = coc.Order_ForDealerText__c == null? '' : coc.Order_ForDealerText__c;
|
// shipmentAccountString = a + b + c;
|
if (HospitalInfo != null ) {
|
shipmentAccountString = HospitalInfo;
|
}else if (SecondDealer != null) {
|
shipmentAccountString = SecondDealer;
|
}else {
|
shipmentAccountString = coc.Order_ForDealerText__c == null? '' : coc.Order_ForDealerText__c;
|
}
|
//update by rentx 2021-02-24 CHAN-BYH9PK end
|
|
Integer x = 0;
|
List<String> invoiceOrderAccountList = new List<String>();
|
for (InvoiceOrderInfo ass : invoiceOrderRecoeds) {
|
if(String.isBlank(deliveryId)){
|
if(ass.check == true){
|
x++;
|
System.debug(shipmentAccountString);
|
if(HospitalInfo != null && HospitalInfo !=''){
|
if(ass.esd.Order_ForHospital__c != shipmentAccountString){
|
invoiceOrderAccountList.add(ass.esd.Name);
|
}
|
}
|
if(SecondDealer != null){
|
if(ass.esd.Order_ForDealer__c != shipmentAccountString && ass.esd.Order_ForDealerText__c != shipmentAccountString){
|
//ApexPages.addmessage(new ApexPages.message(ApexPages.severity.Error, shipmentAccountString + ass.esd.Order_ForDealer__c + ass.esd.Order_ForDealerText__c));
|
invoiceOrderAccountList.add(ass.esd.Name);
|
}
|
}
|
//update by rentx 2021-2-24 CHAN-BYH9PK start
|
// if(coc.Order_ForDealerText__c != null){
|
if(coc.Order_ForDealerText__c != null && (HospitalInfo == null || HospitalInfo == '' )){
|
//update by rentx 2021-2-24 CHAN-BYH9PK end
|
if((ass.esd.Order_ForDealerText__c != null || ass.esd.Order_ForDealerText__c != '') && ass.esd.ShipmentAccount__c != shipmentAccountString){
|
invoiceOrderAccountList.add(ass.esd.Name);
|
}
|
}
|
}
|
}else{
|
if(HospitalInfo != null && HospitalInfo !=''){
|
System.debug('++++++++++++' + ass.esd.Order_ForHospital__c + ' '+shipmentAccountString);
|
if(ass.esd.Order_ForHospital__c != shipmentAccountString){
|
invoiceOrderAccountList.add(ass.esd.Name);
|
}
|
}
|
if(SecondDealer != null){
|
if(ass.esd.Order_ForDealer__c != shipmentAccountString){
|
invoiceOrderAccountList.add(ass.esd.Name);
|
}
|
}
|
//update by rentx 2021-2-24 CHAN-BYH9PK start
|
// if(coc.Order_ForDealerText__c != null){
|
if(coc.Order_ForDealerText__c != null && (HospitalInfo == null || HospitalInfo == '' )){
|
//update by rentx 2021-2-24 CHAN-BYH9PK end
|
if((ass.esd.Order_ForDealerText__c != null || ass.esd.Order_ForDealerText__c != '') && ass.esd.ShipmentAccount__c != shipmentAccountString){
|
invoiceOrderAccountList.add(ass.esd.Name);
|
}
|
}
|
}
|
}
|
// invoiceOrderAccountList.add('12345');
|
if(invoiceOrderAccountList.size() > 0 ){
|
orderRemind = invoiceOrderAccountList + '出库单客户名与发票客户名不一致！';
|
coc.addError(invoiceOrderAccountList + '出库单客户名与发票客户名不一致！');
|
return null;
|
}else{
|
orderRemind = '';
|
//return '';
|
}
|
if(String.isBlank(deliveryId)){
|
if(x < 1){
|
coc.addError('请选择需要开发票的出库单！');
|
return null;
|
}
|
}
|
Consumable_order__c invoiceHead = new Consumable_order__c();
|
List<String> outOrderIdList = New List<String>();
|
List<Consumable_order_LinkTable__c> invoiceLinkList = New List<Consumable_order_LinkTable__c>();
|
Map<String,String> insertDetMap = new Map<String,String>();
|
Map<String,String> deleteDetMap = new Map<String,String>();
|
//新建发票时
|
Savepoint sp = Database.setSavepoint();
|
try{
|
if(String.isBlank(invoiceId)){
|
invoiceHead.Name = coc.Name;
|
if(coc.Invoice_status__c ==null||String.isBlank(coc.Invoice_status__c))coc.Invoice_status__c ='草案中';
|
invoiceHead.Order_type__c = '发票';
|
invoiceHead.Invoice_Date__c = coc.Invoice_Date__c;
|
invoiceHead.Dealer_Info__c = accountid;
|
invoiceHead.Invoice_Note__c = coc.Invoice_Note__c;
|
invoiceHead.Invoice_status__c = '草案中';
|
invoiceHead.Order_ProType__c = agencyProType;
|
invoiceHead.Order_ForCustomerText__c = coc.Order_ForCustomerText__c;
|
if(deliveryId != null){
|
invoiceHead.Outbound_order__c = deliveryId;
|
}
|
invoiceHead.RecordTypeid = System.Label.RT_ConOrder_Invoice;
|
if(SecondDealer==null){
|
if(HospitalInfo != null && HospitalInfo !=''){
|
invoiceHead.Order_ForHospital__c = HospitalInfo;
|
}
|
}else {
|
invoiceHead.Order_ForDealer__c = SecondDealer;
|
}
|
invoiceHead.Order_ForDealerText__c = coc.Order_ForDealerText__c;
|
|
insert invoiceHead;
|
|
invoiceId = invoiceHead.Id ;
|
List<Consumable_order__c> cocinfo = New List<Consumable_order__c>();
|
cocinfo = [SELECT Id,Name,
|
Invoice_status__c,
|
Invoice_Date__c,
|
Order_ForDealerText__c,
|
Dealer_Info__c,
|
Order_ForDealer__c,
|
Order_ForDealer__r.Name,
|
Order_ForHospital__c,
|
Order_date__c,
|
Billed_Status__c,
|
ShipmentAccount__c,
|
Order_Dealer_Info__c,
|
SummonsForDirction__c,
|
Order_ForCustomerText__c,
|
Invoice_Note__c,
|
Invoice_attachment__c,
|
Invoicedet_attachment__c,
|
Outbound_order__c
|
FROM Consumable_order__c
|
WHERE Id =:invoiceId];
|
if (cocinfo.size()>0){
|
invoiceHead = cocinfo[0];
|
}
|
if(!String.isBlank(deliveryId)){
|
for (InvoiceOrderInfo ass : invoiceOrderRecoeds) {
|
chukudanID.add(ass.esd.Id);
|
insertDetMap.put(ass.esd.Id,invoiceHead.Id);
|
}
|
}else{
|
for (InvoiceOrderInfo ass : invoiceOrderRecoeds) {
|
if(!String.isBlank(deliveryId)){
|
chukudanID.add(ass.esd.Id);
|
insertDetMap.put(ass.esd.Id,invoiceHead.Id);
|
}else {
|
if(ass.check == true){
|
chukudanID.add(ass.esd.Id);
|
insertDetMap.put(ass.esd.Id,invoiceHead.Id);
|
}else{
|
//deleteDetMap.put(ass.esd.Id,invoiceHead.Id);
|
}
|
}
|
}
|
}
|
//新建发票明细1
|
if(chukudanID.size() > 0 ){
|
newinvoicedetails1(chukudanID);
|
}
|
//ApexPages.addmessage(new ApexPages.message(ApexPages.severity.Error, 'deleteDetMap +++++' + deleteDetMap.size()));
|
//return null;
|
if(insertDetMap.size() > 0 ){
|
for (String field : insertDetMap.keySet()) {
|
List<Consumable_order_LinkTable__c> existLinkinfo = [SELECT Id FROM Consumable_order_LinkTable__c
|
WHERE Outboundorder_Code_link__c = :field
|
AND Invoice_Code_link__c = :insertDetMap.get(field)];
|
if(existLinkinfo.size() < 1){
|
Consumable_order_LinkTable__c invoiceLink = new Consumable_order_LinkTable__c();
|
invoiceLink.Name = field + insertDetMap.get(field);
|
invoiceLink.Outboundorder_Code_link__c = field;
|
invoiceLink.Invoice_Code_link__c = insertDetMap.get(field);
|
invoiceLinkList.add(invoiceLink);
|
}
|
}
|
upsert invoiceLinkList;
|
}
|
/*if(deleteDetMap.size() > 0 ){
|
List<Consumable_order_LinkTable__c> invoiceLinkdetList = New List<Consumable_order_LinkTable__c>();
|
for (String field : deleteDetMap.keySet()) {
|
List<Consumable_order_LinkTable__c> existLinkinfo = [SELECT Id FROM Consumable_order_LinkTable__c
|
WHERE Outboundorder_Code_link__c = :field
|
AND Invoice_Code_link__c = :deleteDetMap.get(field)];
|
if(existLinkinfo.size() > 0){
|
Consumable_order_LinkTable__c invoiceLink = new Consumable_order_LinkTable__c();
|
invoiceLink.Id = existLinkinfo[0].Id;
|
invoiceLinkdetList.add(invoiceLink);
|
}
|
}
|
delete invoiceLinkdetList;
|
}*/
|
}
|
//CHAN-BSS5SQ update by rentongxiao 2020-09-04 start
|
else if (String.isNotBlank(reopen) && reopen.equals('isreopen') && String.isNotBlank(invoiceId)) {
|
//如果是 作废重开
|
//1. 设置新发票信息
|
invoiceHead.Name = coc.Name;
|
invoiceHead.Order_type__c = '发票';
|
invoiceHead.Invoice_Date__c = coc.Invoice_Date__c;
|
invoiceHead.Dealer_Info__c = accountid;
|
invoiceHead.Invoice_Note__c = coc.Invoice_Note__c;
|
invoiceHead.Invoice_status__c = '草案中';
|
invoiceHead.Order_ProType__c = agencyProType;
|
invoiceHead.Order_ForCustomerText__c = coc.Order_ForCustomerText__c;
|
if(deliveryId != null){
|
invoiceHead.Outbound_order__c = deliveryId;
|
}
|
invoiceHead.RecordTypeid = System.Label.RT_ConOrder_Invoice;
|
if(SecondDealer==null){
|
if(HospitalInfo != null && HospitalInfo !=''){
|
invoiceHead.Order_ForHospital__c = HospitalInfo;
|
}
|
}else {
|
invoiceHead.Order_ForDealer__c = SecondDealer;
|
}
|
invoiceHead.Order_ForDealerText__c = coc.Order_ForDealerText__c;
|
insert invoiceHead;
|
|
List<String> updateChukudanId = new List<String>();
|
//获取原发票相关联的链接表信息
|
List<Consumable_order_LinkTable__c> tLinkList = [SELECT Outboundorder_Code_link__c
|
FROM Consumable_order_LinkTable__c
|
WHERE Invoice_Code_link__c = :invoiceId];
|
|
for(Consumable_order_LinkTable__c colc : tLinkList){
|
colc.Invoice_Code_link__c = invoiceHead.Id;
|
updateChukudanId.add(colc.Outboundorder_Code_link__c);
|
}
|
update tLinkList;
|
//更新发票明细信息
|
//获取出库单,设置关联关系
|
//获取出库单明细信息,因为出库单信息和出库单明细信息是关联的,所有只需要回滚出库单明细信息即可
|
|
Map<String,Consumable_Orderdetails__c> tempCocMap = new Map<String,Consumable_Orderdetails__c>();
|
List<Consumable_Orderdetails__c> tempCountList = [
|
SELECT Id,Consumable_order__c,Asset_Model_No__c,InvoicedProCost_RMB__c, Invoicedet1_OD_link__c ,InvoicedProduct_RMB__c,Invoiced_Procount__c,Invoiced_BoxCount__c,Invoice_Unit__c
|
FROM Consumable_Orderdetails__c WHERE Consumable_order__c = :invoiceId];
|
for(Consumable_Orderdetails__c cocTemp : tempCountList){
|
cocTemp.Consumable_order__c = invoiceHead.Id;
|
tempCocMap.put(cocTemp.Invoicedet1_OD_link__c +cocTemp.Asset_Model_No__c, cocTemp);
|
}
|
update tempCountList;
|
List<Consumable_Orderdetails__c> updateFromList = [
|
SELECT
|
Id,
|
Consumable_order__c,
|
RrturnPro_count__c,
|
Delivery_List_RMB__c,
|
InvoicedProCost_RMB__c,
|
Invoiced_Procount__c,
|
Invoice_Unitprice__c,
|
Box_Piece__c,
|
Invoice_Unit__c,
|
Consumable_order__r.Invoice_total_amount__c,
|
ProductPacking_list_manual__c,
|
InvoicedProduct_RMB__c,
|
Invoiced_BoxCount__c,
|
Shipment_amount__c,
|
Asset_Model_No__c
|
FROM Consumable_Orderdetails__c
|
WHERE Consumable_order__c in : updateChukudanId
|
];
|
for(Consumable_Orderdetails__c corderc : updateFromList){
|
String tempStr = corderc.Consumable_order__c + corderc.Asset_Model_No__c;
|
if (tempCocMap.get(tempStr) != null ) {
|
//设置已发票金额 出库单的已发票金额 - 发票的发票金额
|
corderc.InvoicedProCost_RMB__c = corderc.InvoicedProCost_RMB__c - tempCocMap.get(tempStr).InvoicedProduct_RMB__c;
|
//设置已发票数量 出库单的已发票数量 - 发票的发票数量(盒)
|
corderc.Invoiced_Procount__c = corderc.Invoiced_Procount__c - tempCocMap.get(tempStr).Invoiced_BoxCount__c;
|
//设置发票单价
|
if (corderc.Box_Piece__c == '盒' && corderc.Invoice_Unit__c == '个') {
|
corderc.Invoice_Unitprice__c = corderc.Delivery_List_RMB__c / corderc.ProductPacking_list_manual__c;
|
}else{
|
corderc.Invoice_Unitprice__c = corderc.Delivery_List_RMB__c;
|
}
|
}
|
|
}
|
|
Consumable_order__c tempcoc = new Consumable_order__c();
|
tempcoc.Id = invoiceId;
|
delete tempcoc;
|
invoiceId = invoiceHead.Id;
|
update updateFromList;
|
//--------------------------------------------------------------------------
|
for (InvoiceOrderInfo ass : invoiceOrderRecoeds) {
|
if(ass.check == true){
|
insertDetMap.put(ass.esd.Id,invoiceHead.Id);
|
}else{
|
outOrderIdList.add(ass.esd.Id);
|
deleteDetMap.put(ass.esd.Id,invoiceHead.Id);
|
}
|
}
|
if(outOrderIdList.size() > 0){
|
getdefaultMapinfo(outOrderIdList);
|
}
|
//被选中的出库单集合
|
if(insertDetMap.size() > 0 ){
|
List<Consumable_order_LinkTable__c> existLinkinfo =
|
[SELECT Id,Invoice_Code_link__c,Outboundorder_Code_link__c
|
FROM Consumable_order_LinkTable__c WHERE Outboundorder_Code_link__c in :insertDetMap.keySet()
|
AND Invoice_Code_link__c = :invoiceHead.Id];
|
//存在没有与发票建立关联关系的出库单
|
List<String> templist2 = new List<String>();
|
for(Consumable_order_LinkTable__c colc : existLinkinfo){
|
templist2.add(colc.Outboundorder_Code_link__c);
|
}
|
//获取该出库单
|
for(String field : insertDetMap.keySet()){
|
if (!templist2.contains(field)) {
|
//该出库单不存在与链接表中,新建链接
|
chukudanID.add(field);
|
Consumable_order_LinkTable__c invoiceLink = new Consumable_order_LinkTable__c();
|
invoiceLink.Name = field + insertDetMap.get(field);
|
invoiceLink.Outboundorder_Code_link__c = field;
|
invoiceLink.Invoice_Code_link__c = insertDetMap.get(field);
|
invoiceLinkList.add(invoiceLink);
|
}
|
}
|
upsert invoiceLinkList;
|
|
}
|
//删除出库单链接表
|
if(deleteDetMap.size() > 0 ){
|
|
List<Consumable_order_LinkTable__c> invoiceLinkdetList = New List<Consumable_order_LinkTable__c>();
|
deleteOutboundorder(deleteDetMap,invoiceHead.Id);
|
List<Consumable_order_LinkTable__c> existLinkinfo = [SELECT Id,Outboundorder_Code_link__c,Invoice_Code_link__c FROM Consumable_order_LinkTable__c
|
WHERE Outboundorder_Code_link__c in :deleteDetMap.keySet()
|
AND Invoice_Code_link__c = :invoiceHead.Id];
|
for(Consumable_order_LinkTable__c colctemp : existLinkinfo){
|
if (deleteDetMap.get(colctemp.Outboundorder_Code_link__c) == colctemp.Invoice_Code_link__c) {
|
//存在与该发票关联的出库单
|
invoiceLinkdetList.add(colctemp);
|
}
|
}
|
delete invoiceLinkdetList;
|
}
|
//新建发票明细1
|
if(chukudanID.size() > 0 ){
|
newinvoicedetails1(chukudanID);
|
}
|
}
|
//CHAN-BSS5SQ update by rentongxiao 2020-09-04 end
|
//编辑后保存
|
else{
|
List<Consumable_order__c> cocinfo = New List<Consumable_order__c>();
|
cocinfo = [SELECT Id,Name,
|
Invoice_status__c,
|
Invoice_Date__c,
|
Order_ForDealerText__c,
|
Dealer_Info__c,
|
Order_ForDealer__c,
|
Order_ForDealer__r.Name,
|
Order_ForHospital__c,
|
Order_date__c,
|
Billed_Status__c,
|
ShipmentAccount__c,
|
Order_Dealer_Info__c,
|
SummonsForDirction__c,
|
Order_ForCustomerText__c,
|
Invoice_Note__c,
|
Invoice_attachment__c,
|
Invoicedet_attachment__c,
|
Outbound_order__c
|
FROM Consumable_order__c
|
WHERE Id =:invoiceId];
|
if (cocinfo.size()>0){
|
invoiceHead = cocinfo[0];
|
}
|
if(String.isNotBlank(deliveryId)){
|
for (InvoiceOrderInfo ass : invoiceOrderRecoedschange) {
|
insertDetMap.put(ass.esd.Id,invoiceHead.Id);
|
}
|
|
//换货单产品数量
|
Map<String,Decimal> needchangeOrderProcountMap = new Map<String,Decimal>();
|
Map<String,Decimal> returnProcountMap = new Map<String,Decimal>();
|
Map<String,Decimal> changeOrderProcountMap = new Map<String,Decimal>();
|
List<Consumable_Orderdetails__c> detaliFromList = [
|
SELECT Id,
|
Name,
|
Consumable_order__c,
|
Asset_Model_No__c,
|
Shipment_Count__c,
|
RrturnPro_count__c,
|
Delivery_List_RMB__c,
|
InvoicedProCost_RMB__c,
|
Invoiced_Procount__c,
|
Invoiced_Count__c,
|
Invoice_Unitprice__c,
|
InvoiceProNot_count__c,
|
Invoice_Unit__c,
|
Box_Piece__c,
|
Invoice_Cost_RMB__c
|
FROM Consumable_Orderdetails__c
|
WHERE Consumable_order__c = :deliveryId ];
|
for(Consumable_Orderdetails__c changeOD : detaliFromList){
|
needchangeOrderProcountMap.put(changeOD.Asset_Model_No__c, changeOD.Shipment_Count__c);
|
}
|
//发票返品信息
|
List<Consumable_Orderdetails__c> returnCountList = [
|
SELECT Id,
|
Name,
|
Consumable_order__c,
|
Asset_Model_No__c,
|
Shipment_Count__c,
|
RrturnPro_count__c,
|
Delivery_List_RMB__c,
|
InvoicedProCost_RMB__c,
|
Invoiced_Procount__c,
|
Invoiced_Count__c,
|
Invoice_Unitprice__c,
|
InvoiceProNot_count__c,
|
Invoice_Cost_RMB__c,
|
Invoice_Unit__c,
|
Box_Piece__c
|
FROM Consumable_Orderdetails__c
|
where Consumable_order__c = :invoiceId];
|
|
for(Consumable_Orderdetails__c changeOD : returnCountList){
|
if(changeOD.RrturnPro_count__c > 0){
|
if(returnProcountMap.containsKey(changeOD.Asset_Model_No__c)){
|
returnProcountMap.put(changeOD.Asset_Model_No__c, returnProcountMap.get(changeOD.Asset_Model_No__c) + changeOD.RrturnPro_count__c);
|
}else{
|
returnProcountMap.put(changeOD.Asset_Model_No__c, changeOD.RrturnPro_count__c);
|
}
|
}
|
}
|
|
//已换货单出库数量信息
|
List<Consumable_Orderdetails__c> returnCount1List = [
|
SELECT Id,
|
Name,
|
Consumable_order__c,
|
Asset_Model_No__c,
|
Shipment_Count__c,
|
RrturnPro_count__c,
|
Delivery_List_RMB__c,
|
InvoicedProCost_RMB__c,
|
Invoiced_Procount__c,
|
Invoiced_Count__c,
|
Invoice_Unitprice__c,
|
InvoiceProNot_count__c,
|
Invoice_Cost_RMB__c,
|
Invoice_Unit__c,
|
Box_Piece__c
|
FROM Consumable_Orderdetails__c
|
where Consumable_order__c in (SELECT Outboundorder_Code_link__c FROM Consumable_order_LinkTable__c
|
WHERE Invoice_Code_link__c = :invoiceId)
|
AND Consumable_order__r.Onchange_order__c = true
|
AND Consumable_order__c != :deliveryId];
|
for(Consumable_Orderdetails__c changeOD : returnCount1List){
|
changeOrderProcountMap.put(changeOD.Asset_Model_No__c, changeOD.Shipment_Count__c);
|
}
|
outOrderchange(insertDetMap);
|
}else{
|
invoiceHead.Name = coc.Name;
|
invoiceHead.Invoice_status__c = coc.Invoice_status__c;
|
invoiceHead.Invoice_Date__c = coc.Invoice_Date__c;
|
invoiceHead.Dealer_Info__c = accountid;
|
invoiceHead.Invoice_Note__c = coc.Invoice_Note__c;
|
invoiceHead.Invoice_status__c = '草案中';
|
invoiceHead.Order_ProType__c = agencyProType;
|
invoiceHead.Order_ForCustomerText__c = coc.Order_ForCustomerText__c;
|
//ApexPages.addmessage(new ApexPages.message(ApexPages.severity.Error, 'HospitalName +++++' + HospitalName));
|
//return null;
|
if(HospitalName != null && HospitalName !=''){
|
if(HospitalInfo != null && HospitalInfo !=''){
|
invoiceHead.Order_ForHospital__c = HospitalInfo;
|
}
|
}else{
|
invoiceHead.Order_ForHospital__c = null;
|
}
|
invoiceHead.Order_ForDealer__c = SecondDealer;
|
invoiceHead.Order_ForDealerText__c = coc.Order_ForDealerText__c;
|
update invoiceHead;
|
for (InvoiceOrderInfo ass : invoiceOrderRecoeds) {
|
if(ass.check == true){
|
insertDetMap.put(ass.esd.Id,invoiceHead.Id);
|
}else{
|
outOrderIdList.add(ass.esd.Id);
|
deleteDetMap.put(ass.esd.Id,invoiceHead.Id);
|
}
|
}
|
if(outOrderIdList.size() > 0){
|
getdefaultMapinfo(outOrderIdList);
|
}
|
//CHAN-BSS5SQ update by rentongxiao 2020-09-08 start
|
//被选中的出库单集合
|
if(insertDetMap.size() > 0 ){
|
List<Consumable_order_LinkTable__c> existLinkinfo =
|
[SELECT Id,Invoice_Code_link__c,Outboundorder_Code_link__c
|
FROM Consumable_order_LinkTable__c WHERE Outboundorder_Code_link__c in :insertDetMap.keySet()
|
AND Invoice_Code_link__c = :invoiceHead.Id];
|
//存在没有与发票建立关联关系的出库单
|
List<String> templist2 = new List<String>();
|
for(Consumable_order_LinkTable__c colc : existLinkinfo){
|
templist2.add(colc.Outboundorder_Code_link__c);
|
}
|
//获取该出库单
|
for(String field : insertDetMap.keySet()){
|
if (!templist2.contains(field)) {
|
//该出库单不存在与链接表中,新建链接
|
chukudanID.add(field);
|
Consumable_order_LinkTable__c invoiceLink = new Consumable_order_LinkTable__c();
|
invoiceLink.Name = field + insertDetMap.get(field);
|
invoiceLink.Outboundorder_Code_link__c = field;
|
invoiceLink.Invoice_Code_link__c = insertDetMap.get(field);
|
invoiceLinkList.add(invoiceLink);
|
}
|
}
|
upsert invoiceLinkList;
|
|
}
|
/*if(insertDetMap.size() > 0 ){
|
for (String field : insertDetMap.keySet()) {
|
List<Consumable_order_LinkTable__c> existLinkinfo = [SELECT Id FROM Consumable_order_LinkTable__c
|
WHERE Outboundorder_Code_link__c = :field
|
AND Invoice_Code_link__c = :insertDetMap.get(field)];
|
if(existLinkinfo.size() < 1){
|
chukudanID.add(field);
|
Consumable_order_LinkTable__c invoiceLink = new Consumable_order_LinkTable__c();
|
invoiceLink.Name = field + insertDetMap.get(field);
|
invoiceLink.Outboundorder_Code_link__c = field;
|
invoiceLink.Invoice_Code_link__c = insertDetMap.get(field);
|
invoiceLinkList.add(invoiceLink);
|
}
|
}
|
upsert invoiceLinkList;
|
}*/
|
//删除出库单链接表
|
/*if(deleteDetMap.size() > 0 ){
|
List<Consumable_order_LinkTable__c> invoiceLinkdetList = New List<Consumable_order_LinkTable__c>();
|
deleteOutboundorder(deleteDetMap,invoiceHead.Id);
|
for (String field : deleteDetMap.keySet()) {
|
List<Consumable_order_LinkTable__c> existLinkinfo = [SELECT Id FROM Consumable_order_LinkTable__c
|
WHERE Outboundorder_Code_link__c = :field
|
AND Invoice_Code_link__c = :deleteDetMap.get(field)];
|
if(existLinkinfo.size() > 0){
|
Consumable_order_LinkTable__c invoiceLink = new Consumable_order_LinkTable__c();
|
invoiceLink.Id = existLinkinfo[0].Id;
|
invoiceLinkdetList.add(invoiceLink);
|
}
|
}
|
delete invoiceLinkdetList;
|
}*/
|
//删除出库单链接表
|
if(deleteDetMap.size() > 0 ){
|
|
List<Consumable_order_LinkTable__c> invoiceLinkdetList = New List<Consumable_order_LinkTable__c>();
|
deleteOutboundorder(deleteDetMap,invoiceHead.Id);
|
List<Consumable_order_LinkTable__c> existLinkinfo = [SELECT Id,Outboundorder_Code_link__c,Invoice_Code_link__c FROM Consumable_order_LinkTable__c
|
WHERE Outboundorder_Code_link__c in :deleteDetMap.keySet()
|
AND Invoice_Code_link__c = :invoiceHead.Id];
|
for(Consumable_order_LinkTable__c colctemp : existLinkinfo){
|
if (deleteDetMap.get(colctemp.Outboundorder_Code_link__c) == colctemp.Invoice_Code_link__c) {
|
//存在与该发票关联的出库单
|
invoiceLinkdetList.add(colctemp);
|
}
|
}
|
delete invoiceLinkdetList;
|
}
|
//CHAN-BSS5SQ update by rentongxiao 2020-09-08 end
|
//新建发票明细1
|
if(chukudanID.size() > 0 ){
|
newinvoicedetails1(chukudanID);
|
}
|
}
|
}
|
}catch (Exception ex) {
|
Database.rollback(sp);
|
ApexPages.addMessages(ex);
|
return null;
|
}
|
return UnabletoEdit();
|
}
|
|
//换货单链接表 发票明细2做成
|
public void outOrderchange(Map<String,String> insertDetMap){
|
List<string> chukudanID = new List<string>();
|
List<Consumable_order_LinkTable__c> invoiceLinkList = New List<Consumable_order_LinkTable__c>();
|
Consumable_order__c p = new Consumable_order__c();
|
if(insertDetMap.size() > 0 ){
|
for (String field : insertDetMap.keySet()) {
|
List<Consumable_order_LinkTable__c> existLinkinfo = [SELECT Id FROM Consumable_order_LinkTable__c
|
WHERE Outboundorder_Code_link__c = :field];
|
if(existLinkinfo.size() > 0){
|
delete existLinkinfo;
|
}
|
chukudanID.add(field);
|
Consumable_order_LinkTable__c invoiceLink = new Consumable_order_LinkTable__c();
|
invoiceLink.Name = field + insertDetMap.get(field);
|
invoiceLink.Outboundorder_Code_link__c = field;
|
invoiceLink.Invoice_Code_link__c = insertDetMap.get(field);
|
invoiceLinkList.add(invoiceLink);
|
p.Id = field;
|
p.ConInvoice_Code__c = insertDetMap.get(field);
|
p.Onchange_order__c = true;
|
update p;
|
}
|
insert invoiceLinkList;
|
}
|
//换货出库单明细1更新
|
List<Consumable_Orderdetails__c> detaliFrom1List = [
|
SELECT Id,
|
Name,
|
Consumable_order__c,
|
Asset_Model_No__c,
|
Consumable_Product__r.Asset_Model_No__c,
|
Shipment_Count__c,
|
RrturnPro_count__c,
|
Delivery_List_RMB__c,
|
InvoicedProCost_RMB__c,
|
Invoiced_Procount__c,
|
Invoiced_Count__c,
|
Invoice_Unitprice__c,
|
InvoiceProNot_count__c,
|
Invoice_Cost_RMB__c,
|
Invoice_No__c,
|
Invoice_Unit__c,
|
Box_Piece__c,
|
Consumable_Sale_order__r.Name,
|
Consumable_Shipment_order__r.Name
|
FROM Consumable_Orderdetails__c
|
WHERE Consumable_order__c in : chukudanID];
|
for(Consumable_Orderdetails__c changeOD : detaliFrom1List){
|
changeOD.Invoiced_Procount__c = changeOD.Shipment_Count__c;
|
}
|
update detaliFrom1List;
|
|
//换货出库单明细2更新
|
/*List<Consumable_order_details2__c> detaliFromList = [
|
SELECT Id,
|
Name,
|
Consumable_order_minor__c,
|
Asset_Model_No__c,
|
Sterilization_limit__c,
|
Consumable_Product__r.Asset_Model_No__c,
|
Consumable_Count__c,
|
RrturnPro_count__c,
|
Delivery_List_RMB__c,
|
Invoice_No__c,
|
Invoice_Date__c,
|
Consumable_Sale_order__r.Name,
|
Consumable_Shipment_order__r.Name
|
FROM Consumable_order_details2__c
|
WHERE (Consumable_Sale_order__c in : chukudanID
|
or Consumable_Shipment_order__c in : chukudanID)];
|
for(Consumable_order_details2__c changeOD : detaliFromList){
|
changeOD.Invoice_No__c = invoiceId;
|
changeOD.Invoice_Date__c = Date.today();
|
}
|
update detaliFromList;*/
|
|
}
|
|
//取得更新map初始化数据
|
//获取 订单中产品的初始化 Map
|
public void getdefaultMapinfo(List<String> orderIdList){
|
List<Consumable_Orderdetails__c> existLinkinfo = new List<Consumable_Orderdetails__c>();
|
existLinkinfo = [SELECT Id,Consumable_order__c,Consumable_product__c,Asset_Model_No__c
|
FROM Consumable_Orderdetails__c
|
WHERE Consumable_order__c in:orderIdList];
|
for(Integer i = 0; i < existLinkinfo.size(); i++){
|
ordermx1defaultMap.put(existLinkinfo[i].Consumable_order__c + existLinkinfo[i].Asset_Model_No__c,0);
|
}
|
}
|
//删除发票明细1
|
//CHAN-BSS5SQ update by rentongxiao 2020-09-08 start
|
/*public void deleteOutboundorder(Map<String,String> deleteMap){
|
//删除发票明细1
|
List<Consumable_Orderdetails__c> detInvoicedet1List = new List<Consumable_Orderdetails__c>();
|
//删除发票的明细1（与出库单关联）
|
for (String field : deleteMap.keySet()) {
|
detInvoicedet1List = [SELECT Id,Consumable_Shipment_order__c,Consumable_Sale_order__c,Consumable_product__c,Asset_Model_No__c
|
FROM Consumable_Orderdetails__c
|
WHERE Consumable_order__c = :deleteMap.get(field)
|
AND Invoicedet1_OD_link__c = :field];
|
delete detInvoicedet1List;
|
}
|
}*/
|
public void deleteOutboundorder(Map<String,String> deleteMap,String value){
|
//删除发票明细1
|
List<Consumable_Orderdetails__c> detInvoicedet1List =
|
[SELECT Id,Consumable_Shipment_order__c,Consumable_Sale_order__c,Consumable_product__c,Asset_Model_No__c
|
FROM Consumable_Orderdetails__c
|
WHERE Consumable_order__c = :value
|
AND Invoicedet1_OD_link__c = :deleteMap.keySet()];
|
delete detInvoicedet1List;
|
}
|
//CHAN-BSS5SQ update by rentongxiao 2020-09-08 end
|
|
public void newinvoicedetails1(List<String> chukudanID){
|
//新规发票明细1
|
List<Consumable_Orderdetails__c> invoiceorderList1 = New List<Consumable_Orderdetails__c>();
|
//出库单明细更新
|
List<Consumable_Orderdetails__c> outOrderList1 = New List<Consumable_Orderdetails__c>();
|
List<Consumable_Orderdetails__c> detaliFromList = [
|
SELECT Id,
|
Name,
|
Consumable_order__c,
|
Asset_Model_No__c,
|
Consumable_Product__r.Asset_Model_No__c,
|
Shipment_Count__c,
|
RrturnPro_count__c,
|
Delivery_List_RMB__c,
|
InvoicedProCost_RMB__c,
|
Invoiced_Procount__c,
|
Invoiced_Count__c,
|
Invoice_Unitprice__c,
|
InvoiceProNot_count__c,
|
Invoice_Cost_RMB__c,
|
Invoice_No__c,
|
Consumable_Product__c,
|
Intra_Trade_List_RMB__c,
|
Dealer_Custom_Price__c,
|
Sum_of_money__c,
|
Box_Piece__c,
|
Used_date__c,
|
Send_date__c,
|
Invoice_Unit__c,
|
ProductPacking_list_manual__c
|
FROM Consumable_Orderdetails__c
|
WHERE Consumable_order__c in : chukudanID
|
AND InvoiceProNot_count__c > 0
|
];
|
|
for(Integer i = 0; i < detaliFromList.size(); i++){
|
Consumable_Orderdetails__c invoiceInsert1 = new Consumable_Orderdetails__c();
|
//Consumable_Orderdetails__c orderUpdate1 = new Consumable_Orderdetails__c();
|
//orderUpdate1.id = detaliFromList[i].Id;
|
invoiceInsert1.Used_date__c = detaliFromList[i].Used_date__c;
|
//invoiceInsert1.Asset_Model_No__c = detaliFromList[i].Asset_Model_No__c;
|
invoiceInsert1.Send_date__c = detaliFromList[i].Send_date__c;
|
String str = string.valueOf(i + 1);
|
if(str.length() == 1){
|
str = '0' + str;
|
}
|
invoiceInsert1.Name = coc.Name + '-' + detaliFromList[i].Name.substring(detaliFromList[i].Name.length() - 7,detaliFromList[i].Name.length());
|
invoiceInsert1.Shipment_Count__c = detaliFromList[i].InvoiceProNot_count__c;
|
invoiceInsert1.Consumable_Product__c = detaliFromList[i].Consumable_Product__c;
|
invoiceInsert1.Intra_Trade_List_RMB__c = detaliFromList[i].Intra_Trade_List_RMB__c;
|
invoiceInsert1.Delivery_List_RMB__c = detaliFromList[i].Delivery_List_RMB__c;
|
invoiceInsert1.Dealer_Custom_Price__c = detaliFromList[i].Dealer_Custom_Price__c;
|
invoiceInsert1.RecordTypeId = System.Label.RT_ConOrderDetail1_Invoice;
|
|
if(detaliFromList[i].Box_Piece__c == '盒' && detaliFromList[i].Invoice_Unit__c == '个'){
|
invoiceInsert1.Invoice_Unitprice__c = detaliFromList[i].Delivery_List_RMB__c/detaliFromList[i].ProductPacking_list_manual__c;
|
}else{
|
invoiceInsert1.Invoice_Unitprice__c = detaliFromList[i].Delivery_List_RMB__c;
|
}
|
invoiceInsert1.Box_Piece__c = detaliFromList[i].Box_Piece__c;
|
invoiceInsert1.Invoice_Unit__c = detaliFromList[i].Box_Piece__c;
|
//orderUpdate1.Invoice_Unitprice__c = detaliFromList[i].Delivery_List_RMB__c;
|
if (detaliFromList[i].Invoiced_Procount__c == null) detaliFromList[i].Invoiced_Procount__c = 0;
|
if (detaliFromList[i].RrturnPro_count__c == null) detaliFromList[i].RrturnPro_count__c = 0;
|
//invoiceInsert1.Invoiced_Procount__c = detaliFromList[i].Invoiced_Procount__c;
|
invoiceInsert1.Invoiced_Count__c = detaliFromList[i].InvoiceProNot_count__c;
|
if (detaliFromList[i].InvoicedProCost_RMB__c == null) detaliFromList[i].InvoicedProCost_RMB__c = 0;
|
invoiceInsert1.InvoicedProCost_RMB__c = invoiceInsert1.Invoiced_Count__c * invoiceInsert1.Delivery_List_RMB__c;
|
//invoiceInsert1.Sum_of_money__c = invoiceInsert1.InvoicedProCost_RMB__c;
|
invoiceInsert1.Consumable_order__c = invoiceId;
|
//invoiceInsert1.Consumable_principal__c = invoiceId;
|
invoiceInsert1.Invoicedet1_OD_link__c = detaliFromList[i].Consumable_order__c;
|
invoiceorderList1.add(invoiceInsert1);
|
//outOrderList1.add(orderUpdate1);
|
}
|
System.debug('invoiceorderList1 +++++' + invoiceorderList1.size());
|
//ApexPages.addmessage(new ApexPages.message(ApexPages.severity.Error, 'invoiceorderList1 +++++' + invoiceorderList1.size()));
|
//return ;
|
Savepoint sp = Database.setSavepoint();
|
if(invoiceorderList1.size() > 0){
|
try {
|
insert invoiceorderList1;
|
}catch (Exception ex) {
|
Database.rollback(sp);
|
ApexPages.addMessages(ex);
|
}
|
}
|
}
|
|
|
//上传附件
|
public PageReference FilesUpload(){
|
PageReference ref = new Pagereference('/p/attach/NoteAttach?pid='+invoiceId+'&retURL=%2F' + '/ConInvoiceView?invoiceId=' +invoiceId);
|
ref.setRedirect(true);
|
return ref;
|
}
|
|
//排序
|
public void SortLimited(){
|
List<Id> orderIdList = new List<Id>();
|
for (InvoiceOrderInfo ass : invoiceOrderRecoeds) {
|
orderIdList.add(ass.esd.Id);
|
}
|
if (this.sortKey == this.preSortKey) {
|
// 方向が変わるのみ
|
this.sortOrderAsc = !this.sortOrderAsc;
|
this.sortOrder[Integer.valueOf(this.sortKey)] = (this.sortOrderAsc == true ? '↑' : '↓');
|
} else {
|
this.sortOrderAsc = true;
|
this.sortOrder[Integer.valueOf(this.preSortKey)] = ' ';
|
this.sortOrder[Integer.valueOf(this.sortKey)] = (this.sortOrderAsc == true ? '↑' : '↓');
|
}
|
|
this.preSortKey = this.sortKey;
|
// 画面记录取得
|
String soql = 'SELECT Id, Name,Outbound_Date__c,ShipmentAccount__c,Shipment_total_amount__c,RrturnPro_total_amount__c,Total_Invoiced_Procount__c,InvoiceNotPro_total_amount__c,InvoiceNotPro_money__c,Invoice_total_amount__c,Billed_Status__c,Order_ForHospital__c FROM Consumable_order__c ';
|
soql += ' WHERE Id in :orderIdList';
|
soql += ' order by ' + this.orderby[Integer.valueOf(this.sortKey)];
|
soql += ' ' + (this.sortOrderAsc == true ? 'asc nulls first' : 'desc nulls last');
|
List<Consumable_order__c> queryList = Database.query(soql);
|
invoiceOrderRecoeds = new List<InvoiceOrderInfo>();
|
for(Integer i = 0; i < queryList.size(); i++){
|
invoiceOrderRecoeds.add(new InvoiceOrderInfo(queryList[i]));
|
}
|
for (InvoiceOrderInfo ass : invoiceOrderRecoeds) {
|
if(outorderMoneytMap.containsKey(ass.esd.id)){
|
ass.needInvoiceCount = outorderMoneytMap.get(ass.esd.id);
|
}
|
}
|
}
|
|
// 编辑按钮
|
public PageReference setEditAble(){
|
statusEdit = 'Redirect';
|
PageReference ref = new Pagereference('/ConInvoiceView?invoiceId='+ invoiceId +'&KeyWords='+statusEdit);
|
ref.setRedirect(true);
|
return ref;
|
}
|
|
// 返回不可编辑状态
|
public PageReference UnabletoEdit(){
|
PageReference ref = new Pagereference('/ConInvoiceView?invoiceId='+ invoiceId);
|
ref.setRedirect(true);
|
return ref;
|
}
|
// 精琢科技 zxk 2021-11-03 CHAN-C8D86K 添加删除按钮 start
|
// 删除按钮
|
public PageReference deleteButton() {
|
system.debug('====invoiceId==========>' + invoiceId);
|
List < Consumable_Orderdetails__c > consList = [select id, Consumable_order__c from Consumable_Orderdetails__c where Consumable_order__c = : invoiceId];
|
// Consumable_order__c consumable = [select id from Consumable_order__c where id =: invoiceId AND Invoice_status__c = '草案中'];
|
try {
|
system.debug('====cons==========>' + consList);
|
delete consList;
|
if (coc.id == invoiceId && coc.Invoice_status__c == '草案中') {
|
delete coc;
|
}
|
return returnOrderPage();
|
} catch (Exception e) {
|
ApexPages.addMessages(e);
|
return null;
|
}
|
}
|
// 返回 发票~消耗品页面
|
public PageReference returnOrderPage() {
|
PageReference ref = new Pagereference('/ConInvoiceList?sfdc.tabName=01r100000009ytS');
|
ref.setRedirect(true);
|
return ref;
|
}
|
// 精琢科技 zxk 2021-11-03 CHAN-C8D86K 添加删除按钮 end
|
|
|
// 作废重开按钮
|
public PageReference setreopen(){
|
statusEdit = 'Redirect';
|
PageReference ref = new Pagereference('/ConInvoiceView?invoiceId='+ invoiceId + '&reopen=isreopen' +'&KeyWords='+statusEdit);
|
ref.setRedirect(true);
|
return ref;
|
}
|
|
public PageReference approval() {
|
//更新发票明细2链接
|
Consumable_order__c P = new Consumable_order__c();
|
List<Consumable_order__c> cocinfo = New List<Consumable_order__c>();
|
List<Consumable_order_details2__c> invoiceorderList2 = New List<Consumable_order_details2__c>();
|
//更新出库单明细1
|
List<Consumable_Orderdetails__c> outOrderdetUp1List = New List<Consumable_Orderdetails__c>();
|
//需要更新出库单明细1
|
List<Consumable_Orderdetails__c> outOrderdet1List = [
|
SELECT Id,
|
Name,
|
Consumable_order__c,
|
Consumable_order__r.Name,
|
Asset_Model_No__c,
|
Consumable_Product__r.Asset_Model_No__c,
|
Shipment_Count__c,
|
RrturnPro_count__c,
|
Delivery_List_RMB__c,
|
InvoicedProCost_RMB__c,
|
Invoiced_Procount__c,
|
Invoiced_Count__c,
|
Invoice_Unitprice__c,
|
InvoiceProNot_count__c,
|
Invoice_Cost_RMB__c,
|
Invoice_No__c,
|
Box_Piece__c,
|
Invoice_Unit__c
|
FROM Consumable_Orderdetails__c
|
WHERE Consumable_order__c in : outOrderStringList
|
];
|
for(Integer i = 0; i < outOrderdet1List.size(); i++){
|
if(outordercountMap.containsKey(outOrderdet1List[i].Consumable_order__c + outOrderdet1List[i].Asset_Model_No__c)){
|
Consumable_Orderdetails__c invoiceUpdte1 = new Consumable_Orderdetails__c();
|
invoiceUpdte1.Id = outOrderdet1List[i].Id;
|
invoiceUpdte1.Invoice_Unit__c = outordercountMap.get(outOrderdet1List[i].Consumable_order__c + outOrderdet1List[i].Asset_Model_No__c).Invoice_Unit__c;
|
if(outordercountMap.get(outOrderdet1List[i].Consumable_order__c + outOrderdet1List[i].Asset_Model_No__c).Box_Piece__c == '盒' && outordercountMap.get(outOrderdet1List[i].Consumable_order__c + outOrderdet1List[i].Asset_Model_No__c).Invoice_Unit__c == '个'){
|
Decimal OldinvoicedProcount = 0;
|
OldinvoicedProcount = (outordercountMap.get(outOrderdet1List[i].Consumable_order__c + outOrderdet1List[i].Asset_Model_No__c).Invoiced_Count__c / outordercountMap.get(outOrderdet1List[i].Consumable_order__c + outOrderdet1List[i].Asset_Model_No__c).ProductPacking_list_manual__c).setScale(2);
|
invoiceUpdte1.Invoiced_Procount__c = outOrderdet1List[i].Invoiced_Procount__c + OldinvoicedProcount ;
|
}else{
|
invoiceUpdte1.Invoiced_Procount__c = outOrderdet1List[i].Invoiced_Procount__c + outordercountMap.get(outOrderdet1List[i].Consumable_order__c + outOrderdet1List[i].Asset_Model_No__c).Invoiced_Count__c;
|
}
|
invoiceUpdte1.Invoice_Unitprice__c = outordercountMap.get(outOrderdet1List[i].Consumable_order__c + outOrderdet1List[i].Asset_Model_No__c).Invoice_Unitprice__c;
|
invoiceUpdte1.InvoicedProCost_RMB__c = invoiceUpdte1.Invoiced_Procount__c * outOrderdet1List[i].Delivery_List_RMB__c;
|
|
Decimal invoicedProcount = 0;
|
if(outordercountMap.get(outOrderdet1List[i].Consumable_order__c + outOrderdet1List[i].Asset_Model_No__c).Box_Piece__c == '盒' && outordercountMap.get(outOrderdet1List[i].Consumable_order__c + outOrderdet1List[i].Asset_Model_No__c).Invoice_Unit__c == '个'){
|
invoicedProcount = (outordercountMap.get(outOrderdet1List[i].Consumable_order__c + outOrderdet1List[i].Asset_Model_No__c).Invoiced_Count__c / outordercountMap.get(outOrderdet1List[i].Consumable_order__c + outOrderdet1List[i].Asset_Model_No__c).ProductPacking_list_manual__c).setScale(2);
|
}else{
|
invoicedProcount = outordercountMap.get(outOrderdet1List[i].Consumable_order__c + outOrderdet1List[i].Asset_Model_No__c).Invoiced_Count__c;
|
}
|
|
if(outOrderdet1List[i].InvoiceProNot_count__c < invoicedProcount){
|
ApexPages.addmessage(new ApexPages.message(ApexPages.severity.Error, '出库单' + outOrderdet1List[i].Consumable_order__r.Name + '中，' + outOrderdet1List[i].Asset_Model_No__c +'还没开票数量小于发票数量，请确认是否有返品。'));
|
return null;
|
}
|
|
outOrderdetUp1List.add(invoiceUpdte1);
|
|
}
|
}
|
Savepoint sp = Database.setSavepoint();
|
try {
|
//出库单明细1更新
|
if(outOrderdetUp1List.size() > 0){
|
ControllerUtil.updateOrderDetails1Satus(outOrderdetUp1List);
|
}
|
//发票状态更新
|
cocinfo = [SELECT Id,Name,Invoice_status__c,Dealer_Info__c,Order_ForHospital__c,SummonsForDirction__c FROM Consumable_order__c WHERE Id =:invoiceId];
|
if (cocinfo.size()>0){
|
p = cocinfo[0];
|
}
|
p.Invoice_status__c = '提交';
|
update p;
|
}catch (Exception ex) {
|
Database.rollback(sp);
|
ApexPages.addMessages(ex);
|
return null;
|
}
|
return UnabletoEdit();
|
}
|
|
// 做成检索SQL文
|
private String makeSoqlInit(){
|
String soql = 'SELECT Id, Order_ForDealer__r.Name,Order_ForHospital__r.Name,Order_ForDealerText__c, Name,Outbound_Date__c,ShipmentAccount__c,Shipment_total_amount__c,RrturnPro_total_amount__c,Total_Invoiced_Procount__c,InvoiceNotPro_total_amount__c,InvoiceNotPro_money__c,Invoice_total_amount__c,Billed_Status__c FROM Consumable_order__c ';
|
soql += ' WHERE Dealer_Info__c = \'' + accountid + '\'';
|
soql += ' AND (recordtypeid = \''+ System.Label.RT_ConOrder_Sale + '\'';
|
soql += ' OR recordtypeid = \''+ System.Label.RT_ConOrder_Shipment + '\'';
|
soql += ' ) ';
|
soql += ' AND Order_Owner_WorkLocal__c = \'' + userWorkLocation + '\' ';
|
soql += ' AND Order_ProType__c =\'' + agencyProType +'\'';
|
soql += ' AND SummonsForDirction__c != \'互相调货\' ';
|
if(HospitalInfo != null && HospitalInfo !=''){
|
soql += ' AND Order_ForHospital__c = \'' + HospitalInfo + '\'';
|
}
|
if(SecondDealer != null){
|
soql += ' AND Order_ForDealer__c = \'' + SecondDealer + '\'';
|
}
|
if(coc.Order_ForDealerText__c != null){
|
soql += ' AND ShipmentAccount__c = \'' + coc.Order_ForDealerText__c + '\'';
|
}
|
soql += ' AND InvoiceNotPro_total_amount__c > 0';
|
soql += ' AND Onchange_order__c = false limit 1000';
|
return soql;
|
}
|
|
// 做成检索SQL文
|
private String makeSoql(){
|
String soql = 'SELECT Id, Order_ForDealer__r.Name,Order_ForHospital__r.Name,Order_ForDealerText__c, Name,Outbound_Date__c,ShipmentAccount__c,Shipment_total_amount__c,RrturnPro_total_amount__c,Total_Invoiced_Procount__c,InvoiceNotPro_total_amount__c,InvoiceNotPro_money__c,Invoice_total_amount__c,Billed_Status__c FROM Consumable_order__c ';
|
soql += ' WHERE Dealer_Info__c = \'' + accountid + '\'';
|
soql += ' AND (recordtypeid = \''+ System.Label.RT_ConOrder_Sale + '\'';
|
soql += ' OR recordtypeid = \''+ System.Label.RT_ConOrder_Shipment + '\'';
|
soql += ' ) ';
|
soql += ' AND Order_Owner_WorkLocal__c = \'' + userWorkLocation + '\' ';
|
soql += ' AND Order_ProType__c =\'' + agencyProType +'\'';
|
soql += ' AND Billed_Status__c != \'全部开票\'';
|
soql += ' AND SummonsForDirction__c != \'互相调货\'';
|
if(HospitalInfo != null && HospitalInfo !=''){
|
soql += ' AND Order_ForHospital__c = \'' + HospitalInfo + '\'';
|
}
|
if(SecondDealer != null){
|
soql += ' AND Order_ForDealer__c = \'' + SecondDealer + '\'';
|
}
|
if(coc.Order_ForDealerText__c != null){
|
soql += ' AND ShipmentAccount__c = \'' + coc.Order_ForDealerText__c + '\'';
|
}
|
soql += ' AND InvoiceNotPro_total_amount__c > 0';
|
soql += ' AND Onchange_order__c = false limit 1000';
|
return soql;
|
|
}
|
|
// Data Bean
|
class InvoiceOrderInfo implements Comparable {
|
public Boolean check { get; set; }
|
public Boolean oldCheck { get; set; }
|
public Consumable_order__c esd { get; set; }
|
public Consumable_Orderdetails__c esdet { get; set; }
|
public Attachment attach { get; set; }
|
public String mailSelectOptsin {get;set;}
|
public List<SelectOption> mailSelectOpts { get; set; }
|
public String invoiceOrderId {get;set;}
|
public Decimal needInvoiceCount { get; set; }
|
|
// 出库订单
|
public InvoiceOrderInfo(Consumable_order__c e) {
|
check = false;
|
oldCheck = false;
|
esd = e;
|
needInvoiceCount = 0;
|
}
|
// 出库订单明细1
|
public InvoiceOrderInfo(Consumable_Orderdetails__c e) {
|
esdet = e;
|
}
|
//附件
|
public InvoiceOrderInfo(Attachment e) {
|
attach = e;
|
mailSelectOpts = new List<SelectOption>();
|
mailSelectOpts.add(new SelectOption('发票和明细', '发票和明细'));
|
mailSelectOpts.add(new SelectOption('发票', '发票'));
|
mailSelectOpts.add(new SelectOption('明细', '明细'));
|
}
|
// 排序
|
public Integer compareTo(Object compareTo) {
|
return null;
|
}
|
}
|
}
|
