/** * This function delete media file * @praram array media id's and filePath array * */ function deleteProductMediaFile($mediaIds) { $productHelper = new productHelper(); // remove empty elements // $mediaIds = array_filter($mediaIds,'strlen'); // $ids = implode(',',$mediaIds); $db = JFactory::getDBO(); $params = JComponentHelper::getParams('com_quick2cart'); $delFromDir = JPATH_ROOT . DS . $params->get('eProdUploadDir', 'media/com_quick2cart/productfiles'); foreach ($mediaIds as $media) { // get file name $query = 'SELECT `filePath` FROM `#__kart_itemfiles` where `file_id`=' . $media; $db->setQuery($query); $filename = $db->loadResult(); // delete file record $query = 'DELETE FROM `#__kart_itemfiles` WHERE `file_id` = ' . $media; $db->setQuery($query); $status = $db->execute(); // if file rec is deleted and file exist then delete physical media file if ($status && !empty($filename)) { $productHelper->deleteFile($delFromDir . DS . $filename); } } return 1; }