Advertisement
Guest User

Untitled

a guest
Aug 20th, 2014
202
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.58 KB | None | 0 0
  1. if ($projid) {
  2. $db = $this->getDB();
  3. $rows = $db->getrows("SELECT * FROM eadpartnumber WHERE project_id = ".$projid);
  4. $download_content_vend = NULL;
  5. $download_content_epn = NULL;
  6.  
  7. forEach ($rows as $row) {
  8. $part_num = $row["partNumber"];
  9. $mfgr1 = $row["mfgr1"];
  10. $mfgr1_pn = $row["mfgr1pn"];
  11. $vend1 = $row["vend1"];
  12. $vend1_pn = $row["vend1pn"];
  13. $mfgr2 = $row["mfgr2"];
  14. $mfgr2_pn = $row["mfgr2pn"];
  15. $vend2 = $row["vend2"];
  16. $vend2_pn = $row["vend2pn"];
  17.  
  18. $desc = $row["description"];
  19. $best = $row["bestPriceAtQty"];
  20. $placement = $row["MountingType"];
  21.  
  22. $download_content_vend = $download_content_vend.'"'.$part_num.'","00","'.$mfgr1.'","","'.$mfgr1_pn.'"'."\r\n";
  23. $download_content_vend = $download_content_vend.'"'.$part_num.'","00","'.$vend1.'","","'.$vend1_pn.'"'."\r\n";
  24. if ($mfgr2 || $mfgr2_pn) {
  25. $download_content_vend = $download_content_vend.'"'.$part_num.'","00","'.$mfgr2.'","","'.$mfgr2_pn.'"'."\r\n";
  26. }
  27. if ($vend2 || $vend2_pn) {
  28. $download_content_vend = $download_content_vend.'"'.$part_num.'","00","'.$vend2.'","","'.$vend2_pn.'"'."\r\n";
  29. }
  30. $download_content_epn = $download_content_epn.'"'.$part_num.'","'.$desc.'","'.$best.'","'.$placement.'"'."\r\n";
  31. }
  32. ?>
  33. <?php if($projid) : ?>
  34. <div id="project_id" style="display: none;"><?php echo htmlspecialchars($projid);?></div>
  35. <div id="download_content_vend" style="display: none;"><?php echo htmlspecialchars($download_content_vend);?></div>
  36. <div id="download_content_epn" style="display: none;"><?php echo htmlspecialchars($download_content_epn);?></div>
  37. <button style="margin-left:17px" onclick="
  38. var id_div = document.getElementById('project_id');
  39. var content_div = document.getElementById('download_content_vend');
  40. var id = id_div.textContent;
  41. var content = content_div.textContent;
  42.  
  43. var uri = 'data:text/csv;charset=utf-8,' + encodeURIComponent(content);
  44. var downloadLink = document.createElement('a');
  45. downloadLink.href = uri;
  46. downloadLink.download = 'EAD_VENDOR_CSV_PROJ_'+id+'.txt';
  47.  
  48. document.body.appendChild(downloadLink);
  49. downloadLink.click();
  50. document.body.removeChild(downloadLink);
  51. ">export vendor csv</button>
  52.  
  53. <button onclick="
  54. var id_div = document.getElementById('project_id');
  55. var content_div = document.getElementById('download_content_epn');
  56. var id = id_div.textContent;
  57. var content = content_div.textContent;
  58.  
  59. var uri = 'data:text/csv;charset=utf-8,' + encodeURIComponent(content);
  60. var downloadLink = document.createElement('a');
  61. downloadLink.href = uri;
  62. downloadLink.download = 'EAD_EPN_CSV_PROJ_'+id+'.txt';
  63.  
  64. document.body.appendChild(downloadLink);
  65. downloadLink.click();
  66. document.body.removeChild(downloadLink);
  67. ">export epn csv</button>
  68. <?php endif; ?>
  69. <?php
  70. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement