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