/*
  * BASE METHOD FOR GETTING THE ENTIRE FIELD MAP FOR THE PRODUCT BUNDLE (pb__c) OBJECT
  */

 public map<string, sobjectfield> getpbfieldmap() {
  sobjecttype objtoken = schema.getglobaldescribe().get('pb__c');
  describesobjectresult objdef = objtoken.getdescribe();
  map<string, sobjectfield> bundlefieldmap = objdef.fields.getmap();
  return bundlefieldmap;
 }


 /*
  * EXTRACTS ALL FIELD NAMES FROM THE BASE METHOD MAP, REMOVES THE ONES I DON'T WANT,
  * THEN PUTS THE REMAINING NAMES INTO A LIST ORDERED ALPHABETICALLY
  */

 public list<string> getpbfieldnames() {
  list<string> pbfieldnames = new list<string>();
  set<string> namestoexclude = new set<string> {
   'Id', 'IsDeleted', 'OwnerId', 'CreatedById', 'LastModifiedById', 
   'CreatedDate', 'LastModifiedDate', 'SystemModstamp', 'order__c'
  };
  map<string, sobjectfield> fieldmap = getpbfieldmap();
  for (sobjectfield f : fieldmap.values()) {
   string nametocheck = f.getdescribe().name;
   if (namestoexclude.contains(nametocheck)) {
    continue;
   } else {
    pbfieldnames.add(nametocheck);
   }
  }
  pbfieldnames.sort();
  system.debug('Final field name list: ' + pbfieldnames);
  return pbfieldnames;
 }


 /*
  * TRANSFORMS THE FIELD NAME LIST INTO A CONCATEDATED STRING THAT CAN BE USED IN
  * A SOQL QUERY
  */

 public string getpbfieldnamesforquery() {
  string output = '';
  list<string> fn = getpbfieldnames();
  for (integer i = 0; i < fn.size(); i ++) {
   if (i == 0) {
    output = fn.get(i);
   } else {
    output += ', ' + fn.get(i);
   }
  }
  system.debug('Field names used for query string: ' + output);
  return output;
 }


 /*
  * RETRIEVES AN ARRAY OF PRODUCT BUNDLE RECORDS USING THE DYNAMIC SOQL QUERY RETURNED
  * FROM THE METHODS ABOVE
  */

 public pb__c[] getproductbundles() {
  string fieldstoquery = getpbfieldnamesforquery();
  string fullquerystring = 'select ' + fieldstoquery + ' from pb__c order by order__c';
  pb__c[] bundles = database.query(fullquerystring);
  system.debug(bundles);
  return bundles;
 }