public function populateProductResources($p_id, $resource_type = '', $is_downloadable = 'No')
{
$d_arr = ProductResource::where('product_id', '=', $p_id)->where('resource_type', '=', $resource_type)->where('is_downloadable', '=', $is_downloadable)->orderBy('display_order', 'ASC')->get(array('id', 'resource_type', 'filename', 'ext', 'title', 'is_downloadable', 'width', 'height', 't_width', 't_height', 'l_width', 'l_height'))->toArray();
$resources_arr = array();
$download_filename = '';
$download_url = '';
foreach ($d_arr as $data) {
if ($is_downloadable == 'Yes') {
$download_filename = preg_replace('/[^0-9a-z\\.\\_\\-]/i', '', $data['title']);
if (empty($download_filename)) {
$download_filename = md5($p_id);
}
$download_url = \URL::action('Agriya\\Webshoppack\\AdminProductAddController@getProductActions') . '?action=download_file&product_id=' . $p_id;
}
$product_preview_url = '';
if ($data['resource_type'] == 'Audio' || $data['resource_type'] == 'Video') {
$product_preview_url = '';
}
$resources_arr[] = array('resource_id' => $data['id'], 'resource_type' => $data['resource_type'], 'filename_thumb' => $data['filename'] . 'T.' . $data['ext'], 'filename_large' => $data['filename'] . 'L.' . $data['ext'], 'filename_original' => $data['filename'] . '.' . $data['ext'], 'download_filename' => $download_filename . '.' . $data['ext'], 'download_url' => $download_url, 'width' => $data['width'], 'height' => $data['height'], 't_width' => $data['t_width'], 't_height' => $data['t_height'], 'l_width' => $data['l_width'], 'l_height' => $data['l_height'], 'ext' => $data['ext'], 'title' => $data['title'], 'is_downloadable' => $data['is_downloadable'], 'product_preview_url' => $product_preview_url);
}
return $resources_arr;
}
public function deleteProductResource($row_id)
{
# Get all attribute option ids related to the deleted attribute
$d_arr = ProductResource::where('id', '=', $row_id)->get(array('filename', 'resource_type', 'ext'))->toArray();
foreach ($d_arr as $data) {
if ($data['resource_type'] == 'Image') {
$file_path = \Config::get("webshoppack::photos_folder");
if (file_exists($file_path . $data['filename'] . '.' . $data['ext'])) {
unlink($file_path . $data['filename'] . '.' . $data['ext']);
}
if (file_exists($file_path . $data['filename'] . 'T.' . $data['ext'])) {
unlink($file_path . $data['filename'] . 'T.' . $data['ext']);
}
if (file_exists($file_path . $data['filename'] . 'L.' . $data['ext'])) {
unlink($file_path . $data['filename'] . 'L.' . $data['ext']);
}
} elseif ($data['resource_type'] == 'Archive') {
$file_path = \Config::get("webshoppack::archive_folder");
if (file_exists($file_path . $data['filename'] . '.' . $data['ext'])) {
unlink($file_path . $data['filename'] . '.' . $data['ext']);
}
}
}
ProductResource::where('id', '=', $row_id)->delete();
return $row_id;
}
