Guest User

Untitled

a guest
Nov 20th, 2017
179
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.65 KB | None | 0 0
  1. function customRecordPrint(type, form, request){
  2.  
  3. if (type == 'print' || type == 'edit'){
  4.  
  5. //create saved search for custom records
  6. var filters = new Array();
  7. filters[0] = new nlobjSearchFilter('custrecord_acc_product', null, 'anyof', nlapiGetRecordId());
  8. var columns = new Array();
  9. columns[0] = new nlobjSearchColumn('custrecord_acc_period');
  10. columns[1] = new nlobjSearchColumn('custrecord_acc_col1');
  11. columns[2] = new nlobjSearchColumn('custrecord_acc_col2');
  12. columns[3] = new nlobjSearchColumn('custrecord_acc_col3');
  13. columns[4] = new nlobjSearchColumn('custrecord_acc_total');
  14.  
  15. var result = nlapiSearchRecord('customrecord_acc_list', null, filters, columns);
  16. var customRecords = {columns: columns, results: result};
  17.  
  18. //populate current printout with custom record entries
  19.  
  20. var columns = customRecords.columns,results = customRecords.results,
  21. custrecord = form.addField('custpage_custrecord_to_print', 'longtext', '', null, null),
  22. custrecordArray = [];
  23.  
  24. if (results && results instanceof Array){
  25. for (var i = 0; i < results.length; i++){
  26. var singleLine = {};
  27. for (var j = 0; j < columns.length; j++){
  28. var value = results[i].getValue(columns[j]);
  29. if (j==0 || j==1 || j==2){
  30. if (value.indexOf('.')==0 || value.indexOf(',')==0 || value.indexOf('-.')==0 || value.indexOf('-,')==0){
  31. value = '0'+value;
  32. }
  33. }
  34. singleLine["col"+j] = (value)?value:'';
  35. }
  36. custrecordArray.push(singleLine);
  37. }
  38. custrecord.setDefaultValue(JSON.stringify(custrecordArray));
  39. }
  40. }
  41. }
Add Comment
Please, Sign In to add comment