Viewing file:  CsvProductController.php (7.96 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
namespace App\Http\Controllers\Back;
use App\Http\Controllers\Controller;
use App\Models\Brand;
use App\Models\Category;
use App\Models\ChieldCategory;
use App\Models\Item;
use App\Models\Order;
use App\Models\Subcategory;
use App\Models\Transaction;
use Illuminate\Http\Request;
use Illuminate\Support\Str;
use Intervention\Image\ImageManagerStatic as Image;
class CsvProductController extends Controller
{
public function index()
{
return view('back.item.bulk-upload');
}
public function export()
{
$headers = [
'Cache-Control' => 'must-revalidate, post-check=0, pre-check=0', 'Content-type' => 'text/csv', 'Content-Disposition' => 'attachment; filename=products_csv_export.csv', 'Expires' => '0', 'Pragma' => 'public'
];
$lists = Item::where('item_type', '!=', 'affilite')->get();
$new_list = [];
foreach ($lists->toArray() as $list) {
$list['photo'] = asset('assets/images/' . $list['photo']);
$list['slug'] = Str::random(3) . $list['slug'] . Str::random(2);
$list['category'] = Category::findOrFail($list['category_id'])->name;
$list['subcategory'] = $list['subcategory_id'] ? Subcategory::findOrFail($list['subcategory_id'])->name : '';
$list['childcategory'] = $list['childcategory_id'] ? ChieldCategory::findOrFail($list['childcategory_id'])->name : '';
$list['brand'] = $list['brand_id'] ? Brand::findOrFail($list['brand_id'])->name : '';
unset($list['category_id']);
unset($list['subcategory_id']);
unset($list['childcategory_id']);
unset($list['brand_id']);
$new_list[] = $list;
}
# add headers for each column in the CSV download
array_unshift($new_list, array_keys($new_list[0]));
$callback = function () use ($new_list) {
$FH = fopen('php://output', 'w');
foreach ($new_list as $row) {
fputcsv($FH, $row);
}
fclose($FH);
};
return response()->stream($callback, 200, $headers);
}
public function transactionExport()
{
$headers = [
'Cache-Control' => 'must-revalidate, post-check=0, pre-check=0', 'Content-type' => 'text/csv', 'Content-Disposition' => 'attachment; filename=transaction_export.csv', 'Expires' => '0', 'Pragma' => 'public'
];
$lists = Transaction::all()->toArray();
$new_list = [];
foreach ($lists as $list) {
$new_list[] = $list;
}
# add headers for each column in the CSV download
array_unshift($new_list, array_keys($new_list[0]));
$callback = function () use ($new_list) {
$FH = fopen('php://output', 'w');
foreach ($new_list as $row) {
fputcsv($FH, $row);
}
fclose($FH);
};
return response()->stream($callback, 200, $headers);
}
public function orderExport()
{
$headers = [
'Cache-Control' => 'must-revalidate, post-check=0, pre-check=0', 'Content-type' => 'text/csv', 'Content-Disposition' => 'attachment; filename=order_csv_export.csv', 'Expires' => '0', 'Pragma' => 'public'
];
$lists = Order::all()->toArray();
$new_list = [];
foreach ($lists as $list) {
$new_list[] = $list;
}
# add headers for each column in the CSV download
array_unshift($new_list, array_keys($new_list[0]));
$callback = function () use ($new_list) {
$FH = fopen('php://output', 'w');
foreach ($new_list as $row) {
fputcsv($FH, $row);
}
fclose($FH);
};
return response()->stream($callback, 200, $headers);
}
//*** POST Request
public function import(Request $request)
{
try {
$filename = '';
if ($file = $request->file('csv')) {
$filename = time() . '-' . $file->getClientOriginalExtension();
$file->move('assets/temp_files', $filename);
}
$file = fopen(public_path('assets/temp_files/' . $filename), "r");
$i = 1;
while (($line = fgetcsv($file)) !== FALSE) {
if ($i != 1) {
$category_id = $line[31] ? (Category::whereName($line[31])->exists() ? Category::whereName($line[31])->first()->id : 0) : 0;
$subcategory_id = $line[32] ? (SubCategory::whereName($line[32])->exists() ? SubCategory::whereName($line[32])->first()->id : 0) : 0;
$childcategory_id = $line[33] ? (ChieldCategory::whereName($line[33])->exists() ? ChieldCategory::whereName($line[33])->first()->id : 0) : 0;
$brand_id = $line[34] ? (Brand::whereName($line[33])->exists() ? Brand::whereName($line[33])->first()->id : 0) : 0;
$input['category_id'] = $category_id;
$input['subcategory_id'] = $subcategory_id;
$input['childcategory_id'] = $childcategory_id;
$input['brand_id'] = $brand_id;
$input['tax_id'] = $line[4];
$input['name'] = $line[6];
$input['slug'] = $line[7];
$input['sku'] = $line[8];
$input['tags'] = $line[9];
$input['video'] = $line[10];
$input['sort_details'] = $line[11];
$input['specification_name'] = $line[12];
$input['specification_description'] = $line[13];
$input['is_specification'] = $line[14];
$input['details'] = $line[15];
$input['discount_price'] = $line[17];
$input['previous_price'] = $line[18];
$input['stock'] = $line[19];
$input['meta_keywords'] = $line[20];
$input['meta_description'] = $line[21];
$input['status'] = $line[22];
$input['is_type'] = $line[23];
$input['date'] = $line[24];
$input['file'] = $line[26];
$input['link'] = $line[27];
$input['file_type'] = $line[28] ? $line[28] : null;
$input['item_type'] = $line[25];
$image_url = $line[12];
$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_URL, $image_url);
curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 20);
curl_setopt($ch, CURLOPT_USERAGENT, $_SERVER['HTTP_USER_AGENT']);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
curl_setopt($ch, CURLOPT_HEADER, true);
curl_setopt($ch, CURLOPT_NOBODY, true);
$content = curl_exec($ch);
$contentType = curl_getinfo($ch, CURLINFO_CONTENT_TYPE);
$fimg = Image::make($line[16])->resize(800, 800);
$fphoto = time() . Str::random(8) . '.jpg';
$fimg->save(public_path() . '/assets/images/' . $fphoto);
$input['photo'] = $fphoto;
$data = new Item();
$data->fill($input)->save();
}
$i++;
}
fclose($file);
$removefiles = glob(public_path() . '/assets/temp_files/*');
// Deleting all the files in the list
foreach ($removefiles as $file) {
if (is_file($file))
unlink($file);
}
return back()->withSuccess(__('Bulk Product File Imported Successfully.'));
} catch (\Throwable $th) {
return back()->withError(__('Something is wrong!'));
}
}
}
|