public function downloadupdatedig()
{
set_time_limit(0);
ini_set('memory_limit', -1);
$items = UpdatedIg::orderBy('updated_at', 'desc')->get();
$writer = WriterFactory::create(Type::XLSX);
$writer->openToBrowser('Store Item Updated IG.xlsx');
$writer->addRow(array('Area', 'Region Code', 'Region', 'Distributor Code', 'Distributor Name', 'Agency Code', 'Agency', 'Store ID', 'Store Code', 'Store Name', 'Channel Code', 'Channel', 'Other Code', 'SKU Code', 'Description', 'Division', 'Category', 'Sub Category', 'Brand', 'Conversion', 'Min Stock', 'FSO Multiplier', 'LPBT', 'IG', 'Created At', 'Date Updated'));
foreach ($items as $row) {
$data[0] = $row->area;
$data[1] = $row->region_code;
$data[2] = $row->region;
$data[3] = $row->distributor_code;
$data[4] = $row->distributor;
$data[5] = $row->agency_code;
$data[6] = $row->agency;
$data[7] = $row->storeid;
$data[8] = $row->store_code;
$data[9] = $row->store_name;
$data[10] = $row->channel_code;
$data[11] = $row->channel;
$data[12] = $row->other_code;
$data[13] = $row->sku_code;
$data[14] = $row->description;
$data[15] = $row->division;
$data[16] = $row->category;
$data[17] = $row->sub_category;
$data[18] = $row->brand;
$data[19] = $row->conversion;
$data[20] = $row->min_stock;
$data[21] = $row->fso_multiplier;
$data[22] = $row->lpbt;
$data[23] = $row->ig;
$data[24] = (string) $row->created_at;
$data[25] = (string) $row->updated_at;
$writer->addRow($data);
}
$writer->close();
}
