Advertisement
Guest User

Untitled

a guest
May 5th, 2016
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. // var products = [{ sku: 1 }, { sku: 2 }]; // Sample data (SKU of products from Magento Database)
  2.  
  3. var productsSku = products
  4. .map(product => product.sku.toString())
  5. .map(sku => sku.split(' ').filter(node => node.match(/^\S+$/)))
  6. .reduce((acc, target) => Array.prototype.concat.apply(acc, target))
  7. .filter((value, index, self) => self.indexOf(value) === index)
  8. .map(sku => `'${sku}'`)
  9. .sort((x, y) => x - y)
  10. .join(', ');
  11.  
  12. console.log(`SELECT Codigo, Descricao, DataCad, PrecoCusto FROM Alpha3.dbo.Produtos WHERE Codigo NOT IN (${productsSku})`);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement