save product details in custom table & display below My account

Question

Once Registered customers click on "Create Product" button present in product view page, we are creating new product in database. now we need to

1)Save those newly created product details in custom Table : my_designs

we are successfuly doing with help of this code :

$data = array('title'=>fav1_id,'product_id'=>$product->getId(),'customer_id'=>
 Mage::getSingleton('customer/session')->getId());
$model = Mage::getModel('example/mydesign')->setData($data);

2)display those products in My Designs section in Customer's My Account by fetching values from my_designs table.

I am using module & I am trying below code to display those products under My Designs section.

Issue : in customer 1's Dashboard only Products created by customer 1 should display, but now its displaying all customer's Products.

<?php $collections = $this->getCollection(); ?>
<?php foreach ($collections as $key => $product) {
    $_product = Mage::getModel('catalog/product')->load($product->getProductId());        
    echo $product->getId().'<br />';
    echo $_product->getName().'<br />';

}
?>

full module : http://www.filedropper.com/amasty-module1

Answer 1

Below code will get you products for a customer.
Update your file app\code\local\Amasty\Example\Block\List.php::__construct()

public function __construct() {
    parent::__construct();
    $idc = Mage::getSingleton('customer/session')->getId();
    $customerSavedProductArray = array();
    $customerSavedProductArray = Mage::getModel('example/mydesign')->getCollection()->addFieldToFilter('customer_id',$idc)->getColumnValues("product_id");
    $collection = Mage::getModel('catalog/product')->getCollection()->addAttributeToSelect('*')->addAttributeToFilter('entity_id', array("in"=>$customerSavedProductArray));
    $collection->load();
    $this->setCollection($collection);
}

Now update file app\design\frontend\rwd\default\template\example\example.phtml

<?php $collections = $this->getCollection(); ?>
<?php foreach ($collections as $key => $product) {
    //$_product = Mage::getModel('catalog/product')->load($product->getProductId());    
    //echo $product->getProductUrl().'<br />';
    echo $product->getId().'<br />';
    echo $product->getName().'<br />';
    //echo $_product->getImage().'<br />';
    //echo Mage::getModel('catalog/product_media_config')->getMediaUrl( $product->getImage() ).'<br />'; 
    //echo $_product->getFinalPrice();'<br />';
}
?>
<!--
<img id="product-collection-image-<?php echo $_product->getId(); ?>"
                                     src="<?php echo $this->helper('catalog/image')->init($_product, 'small_image'); ?>"
                                     alt="<?php echo $this->stripTags($this->getImageLabel($_product, 'small_image'), null, true) ?>"/>

-->

Answer 2

Well you can use different attribute set for that kind of product ,

and one of that attribute contains the customer_id and filter product collection using that customer_id attribute basis

and show them in users dashboard.

For filtering product you can use below code

$collection = Mage::getModel('catalog/product')->getCollection()->addAttributeToFilter('customer_id',array('eq'=>$customer_id));
foreach($collection as $product){
   echo $product->getId();
}