/**
* 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;
}
