Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if ($projid) {
- $db = $this->getDB();
- $rows = $db->getrows("SELECT * FROM eadpartnumber WHERE project_id = ".$projid);
- $download_content_vend = NULL;
- $download_content_epn = NULL;
- forEach ($rows as $row) {
- $part_num = $row["partNumber"];
- $mfgr1 = $row["mfgr1"];
- $mfgr1_pn = $row["mfgr1pn"];
- $vend1 = $row["vend1"];
- $vend1_pn = $row["vend1pn"];
- $mfgr2 = $row["mfgr2"];
- $mfgr2_pn = $row["mfgr2pn"];
- $vend2 = $row["vend2"];
- $vend2_pn = $row["vend2pn"];
- $desc = $row["description"];
- $best = $row["bestPriceAtQty"];
- $placement = $row["MountingType"];
- $download_content_vend = $download_content_vend.'"'.$part_num.'","00","'.$mfgr1.'","","'.$mfgr1_pn.'"'."\r\n";
- $download_content_vend = $download_content_vend.'"'.$part_num.'","00","'.$vend1.'","","'.$vend1_pn.'"'."\r\n";
- if ($mfgr2 || $mfgr2_pn) {
- $download_content_vend = $download_content_vend.'"'.$part_num.'","00","'.$mfgr2.'","","'.$mfgr2_pn.'"'."\r\n";
- }
- if ($vend2 || $vend2_pn) {
- $download_content_vend = $download_content_vend.'"'.$part_num.'","00","'.$vend2.'","","'.$vend2_pn.'"'."\r\n";
- }
- $download_content_epn = $download_content_epn.'"'.$part_num.'","'.$desc.'","'.$best.'","'.$placement.'"'."\r\n";
- }
- ?>
- <?php if($projid) : ?>
- <div id="project_id" style="display: none;"><?php echo htmlspecialchars($projid);?></div>
- <div id="download_content_vend" style="display: none;"><?php echo htmlspecialchars($download_content_vend);?></div>
- <div id="download_content_epn" style="display: none;"><?php echo htmlspecialchars($download_content_epn);?></div>
- <button style="margin-left:17px" onclick="
- var id_div = document.getElementById('project_id');
- var content_div = document.getElementById('download_content_vend');
- var id = id_div.textContent;
- var content = content_div.textContent;
- var uri = 'data:text/csv;charset=utf-8,' + encodeURIComponent(content);
- var downloadLink = document.createElement('a');
- downloadLink.href = uri;
- downloadLink.download = 'EAD_VENDOR_CSV_PROJ_'+id+'.txt';
- document.body.appendChild(downloadLink);
- downloadLink.click();
- document.body.removeChild(downloadLink);
- ">export vendor csv</button>
- <button onclick="
- var id_div = document.getElementById('project_id');
- var content_div = document.getElementById('download_content_epn');
- var id = id_div.textContent;
- var content = content_div.textContent;
- var uri = 'data:text/csv;charset=utf-8,' + encodeURIComponent(content);
- var downloadLink = document.createElement('a');
- downloadLink.href = uri;
- downloadLink.download = 'EAD_EPN_CSV_PROJ_'+id+'.txt';
- document.body.appendChild(downloadLink);
- downloadLink.click();
- document.body.removeChild(downloadLink);
- ">export epn csv</button>
- <?php endif; ?>
- <?php
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement