public static function removeProductAndInventoryImage($db, $fatherTable, $imagetable, $product_tag, $imageID, $postID, $userID) { if ($product_tag == 'inventory') { $okayBool = DatabaseObject_Helper_InventoryManager::verifyInventoryItemForUser($db, $postID, $userID); } else { $okayBool = DatabaseObject_Helper_ProductListing::confirmproductforuploader($db, $fatherTable, $userID, $postID); } if ($okayBool) { $image = new DatabaseObject_Image($db, $imagetable, $product_tag); if ($image->loadForPost($postID, $imageID)) { echo 'here at load image'; if ($image->delete()) { echo 'here at delete image'; return true; } else { return false; } } else { echo 'image not loaded'; } } else { echo 'You have no permission to perform this action'; return false; } }
public function listingpreviewAction() { $id = $this->request->getParam('id'); $product_type = $this->request->getParam('product'); //error check for type; //$product = ObjectGenerator::generateProductForListing($this->db, $product_type); $product = new DatabaseObject_Products($this->db); echo $this->signedInUserSessionInfoHolder->generalInfo->userID; $product->getProductForUser($this->signedInUserSessionInfoHolder->generalInfo->userID, $id); $this->view->product = $product; //load all image attribute for order //*******************IMAGES ATTRIBUTE*****************************// $selectColumnOptions = array('group' => true, 'value' => array('image_attribute_id', 'attribute_name', 'image_name', 'price_adjustment')); $attributeArray = DatabaseObject_Helper_ProductListing::getImageAttribute($this->db, $product->Username, $product_type, $id, $selectColumnOptions); $selectColumnOptions = array('group' => false, 'value' => array('image_attribute_id', 'attribute_name', 'image_name', 'price_adjustment')); $imageAttribute = DatabaseObject_Helper_ProductListing::getImageAttribute($this->db, $product->Username, $product_type, $id, $selectColumnOptions); $this->view->attributeArray = $attributeArray; $this->view->imageAttribute = $imageAttribute; //load all measurement w/ image attribute for order //*******************MEASUREMENT ATTRIBUTE*************************// $selectColumnOptions = array('group' => false, 'value' => array('measurement_attribute_id', 'measurement_name', 'beginning_measurement', 'ending_measurement', 'incremental_measurement', 'price_adjustment', 'filename', 'video_youtube', 'description')); $measurementAttribute = DatabaseObject_Helper_ProductListing::getMeasurementAttribute($this->db, $product->Username, $product_type, $id, $selectColumnOptions); $this->view->measurementAttribute = $measurementAttribute; //load all sizing attribute for order //*******************SIZE ATTRIBUTE*******************************// $selectColumnOptions = array('group' => true, 'value' => array('size_attribute_id', 'attribute_name', 'size_name', 'price_adjustment')); $sizeAttributeArray = DatabaseObject_Helper_ProductListing::getSizeAttribute($this->db, $product->Username, $product_type, $id, $selectColumnOptions); $selectColumnOptions = array('group' => false, 'value' => array('size_attribute_id', 'attribute_name', 'size_name', 'price_adjustment')); $sizeAttribute = DatabaseObject_Helper_ProductListing::getSizeAttribute($this->db, $product->Username, $product_type, $id, $selectColumnOptions); $this->view->sizeAttributeArray = $sizeAttributeArray; $this->view->sizeAttribute = $sizeAttribute; //********************RETRIEVE INVENTORY ITEMS*********************// $inventoryItems = DatabaseObject_Helper_InventoryManager::retriveAllInventoryForSpecificProduct($this->db, $product->Username, $product_type, $id); //Zend_Debug::dump($inventoryItems); $this->view->inventoryItems = $inventoryItems; //load review for product }