public without sharing class Morethan7daysController {
|
// 订单 ID
|
private String orderId = '';
|
public List<showRecords> MorethansevendaysIifo { get; set; }
|
public String type { get; set; }
|
public Morethan7daysController() {
|
orderId = ApexPages.currentPage().getParameters().get('Id');
|
MorethansevendaysIifo = new List<showRecords>();
|
type = ApexPages.currentPage().getParameters().get('type');
|
}
|
|
// 画面初始化
|
public void init() {
|
List<AggregateResult> Morethan7daysList = [SELECT Asset_Model_No__c prodModel,count(Id) recordCount FROM Consumable_order_details2__c
|
WHERE Consumable_order_minor__c != null
|
AND Dealer_Shipment__c = false
|
AND Dealer_Arrive__c = false
|
AND Dealer_Saled__c = false
|
AND Consumable_order_minor__r.showFalseNotshowTrue__c = false
|
AND Deliver_date__c < LAST_N_DAYS:7
|
AND Consumable_order_minor__c = :orderId
|
GROUP BY Asset_Model_No__c];
|
|
for(Integer i = 0 ; i< Morethan7daysList.size() ; i++){
|
MorethansevendaysIifo.add(new showRecords(Morethan7daysList[i]));
|
}
|
}
|
|
// Data Bean
|
class showRecords implements Comparable {
|
|
public Decimal recordCount { get; set; }
|
public String prodModel { get; set; }
|
|
|
public showRecords(AggregateResult e) {
|
recordCount =Integer.valueOf(e.get('recordCount'));
|
prodModel = String.valueOf(e.get('prodModel'));
|
}
|
//排序
|
public Integer compareTo(Object compareTo) {
|
return null;
|
}
|
}
|
}
|
