Guest User

Untitled

a guest
Jul 19th, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.70 KB | None | 0 0
  1. <?php
  2.  
  3. $customerCount = 0;
  4. try
  5. {
  6. //configure the customer collection
  7. $collection = Mage::getResourceModel('customer/customer_collection')
  8. ->addAttributeToSelect('entity_id')
  9. ->addAttributeToSelect('firstname')
  10. ->addAttributeToSelect('lastname')
  11. ->addAttributeToSelect('email');
  12.  
  13. //configure the order collection
  14. $ordercollection = Mage::getModel("sales/order")->getCollection();
  15. $ordercollection->getSelect()->join(
  16. 'sales_flat_order_item',
  17. '`sales_flat_order_item`.order_id=`main_table`.entity_id',
  18. array(
  19. 'skus' => new Zend_Db_Expr('group_concat(`sales_flat_order_item`.sku SEPARATOR ", ")')
  20. )
  21. )->group('main_table.customer_id');
  22.  
  23. do
  24. {
  25. foreach ($collection as $customer)
  26. {
  27. foreach ($ordercollection as $data)
  28. {
  29. $product = $data->getSkus();
  30. }
  31. $customerArray = $customer->toArray();
  32. $customerREquiredArray['customer ID'] = $customerArray['entity_id'];
  33. $customerREquiredArray['First name'] = $customerArray['firstname'];
  34. $customerREquiredArray['Last name'] = $customerArray['lastname'];
  35. $customerREquiredArray['Email'] = $customerArray['email'];
  36. $customerREquiredArray['product'] = $product;
  37. }
  38. }
  39. }
  40.  
  41. $j=0;
  42. foreach ($collection as $customer)
  43. {
  44.  
  45. $newordercollection = Mage::getModel("sales/order")->getCollection()->addFieldToFilter('customer_id',$customerArray['entity_id']);
  46.  
  47. $orderIds = $newordercollection->getAllIds();
  48. $ordercollection = Mage::getModel("sales/order")->getCollection()->addFieldToFilter('entity_id',array('in',$orderIds));
  49. $ordercollection->getSelect()->join(
  50. 'sales_flat_order_item',
  51. '`sales_flat_order_item`.order_id=`main_table`.entity_id',
  52. array(
  53. 'skus' => new Zend_Db_Expr('group_concat(`sales_flat_order_item`.sku SEPARATOR ", ")')
  54. )
  55. )->group('main_table.customer_id');
  56. $firtItem = $ordercollection->getFIrstItem();
  57. $product = $firtItem->getSkus();
  58.  
  59. $customerArray = $customer->toArray();
  60. $customerREquiredArray['customer ID'] = $customerArray['entity_id'];
  61. $customerREquiredArray['First name'] = $customerArray['firstname'];
  62. $customerREquiredArray['Last name'] = $customerArray['lastname'];
  63. $customerREquiredArray['Email'] = $customerArray['email'];
  64. $customerREquiredArray['product'] = $product;
  65. $j=$j+1;
  66. }
Add Comment
Please, Sign In to add comment