public static function removeAttributeForUser($db, $attributeType, $attributeID, $username)
{
$select = $db->select();
$select->from($attributeType, '*')->where('id=?', $attributeID);
$attributeSet = $db->fetchAll($select);
Zend_Debug::dump($attributeSet);
$select = $db->select();
$select->from($attributeType . '_details', '*')->where('set_id = ?', $attributeID);
//echo $select;
$attributeDetails = $db->fetchAll($select);
//$attributeEverything = $db->fetchAll('$select');
//Zend_Debug::dump($attributeEverything);
//Zend_Debug::dump($attributeDetails);
foreach ($attributeDetails as $k => $v) {
echo 'here at delete details';
$detailsImage = new DatabaseObject_Attribute_CustomAttributeDetails($db, $attributeType . '_details');
echo 'id is: ' . $v['id'];
//$detailsImage->load($v['id']);
if ($detailsImage->load($v['id'])) {
echo 'here at image delete';
$detailsImage->setSaveFilePath($username, $attributeType . '_details', $attributeSet[0]['name_of_set']);
$detailsImage->delete();
}
}
$where = array($attributeType . '_id = ' . $attributeID);
//echo 'product_'.$table.'_id: '.$product_attribute_set_id;
$db->delete('product_' . $attributeType, $where);
$where2 = array('id = ' . $attributeID);
$db->delete($attributeType, $where2);
}
