<?php //begin ?> <?php $_producty = $this->getProduct(); $productid = $_producty['entity_id']; $resource = Mage::getSingleton('core/resource'); $read = $resource->getConnection('catalog_read'); $productEntityTable = (string)Mage::getConfig()->getTablePrefix().'catalog_product_entity'; $productoptionTable = (string)Mage::getConfig()->getTablePrefix().'catalog_product_option'; $productOptionTypeTable = (string)Mage::getConfig()->getTablePrefix().'catalog_product_option_type_value'; $productOptionTypeTitleTable = (string)Mage::getConfig()->getTablePrefix().'catalog_product_option_type_title'; $select = $read->select() ->from(array('cp'=>$productEntityTable)) ->join(array('po'=>$productoptionTable),'cp.entity_id=po.product_id') ->join(array('pot'=>$productOptionTypeTable),'pot.option_id=po.option_id') ->join(array('pott'=>$productOptionTypeTitleTable),'pott.option_type_id=pot.option_type_id') ->where('cp.entity_id=?',$productid) ; $rows = $read->fetchAll($select); // $rows = array_unique($rows); $items = $rows; $optionid = array(); $ik = 1; foreach ($items as $item) { $optionid[] = $item['option_id']; } $optionid = array_unique($optionid); foreach($optionid as $oid){ $name = "options[".$oid."]"; $id = "select_".$oid; foreach ($items as $item){ if($item['option_id']==$oid){ echo "<input name='".$name."' id='".$id."' type='text' value='".$item['option_type_id']."' />"; break; } } echo "<ul class='".$id."' id='inpur_select".$ik."' >"; $ij =1; foreach ($items as $item){ if($item['option_id']==$oid){ if($ij==1){ echo "<li class='selected' alt='".$item['option_type_id']."'>".$item['title']."</li>"; }else{ echo "<li alt='".$item['option_type_id']."'>".$item['title']."</li>"; } $ij++; } } echo "</ul><div class='clearer'></div>"; $ik++; } ?> <?php //end ?>
