public function items()
{
$fileName = "Items Mastefile.csv";
$writer = WriterFactory::create(Type::CSV);
// for CSV files
$writer->openToBrowser($fileName);
// stream data directly to the browser
$writer->addRow(array('Category Long Description', 'Category Short Description', 'SKU Code', 'Barcode', 'Item Short Description', 'Item Long Description', 'Conversion', 'Sub Category', 'Brand', 'Division', 'LPBT/Cond Value (PC)', 'Status'));
$items = Item::select(\DB::raw('category_long, category, sku_code, barcode, description,
description_long, conversion, sub_category, brand, division, lpbt, items.active'))->join('categories', 'categories.id', '=', 'items.category_id')->join('sub_categories', 'sub_categories.id', '=', 'items.sub_category_id')->join('brands', 'brands.id', '=', 'items.brand_id')->join('divisions', 'divisions.id', '=', 'items.division_id')->get();
$pluckdata = [];
foreach ($items as $item) {
$data[0] = $item->category_long;
$data[1] = $item->category;
$data[2] = $item->sku_code;
$data[3] = $item->barcode;
$data[4] = $item->description;
$data[5] = $item->description_long;
$data[6] = $item->conversion;
$data[7] = $item->sub_category;
$data[8] = $item->brand;
$data[9] = $item->division;
$data[10] = $item->lpbt;
if ($item->active == '1') {
$data[11] = 'Active';
} else {
$data[11] = 'In-active';
}
$pluckdata[] = $data;
}
$writer->addRows($pluckdata);
// add multiple rows at a time
$writer->close();
}
public function item_data()
{
\DB::statement(\DB::raw('set @rownum=0'));
$items = Item::select([\DB::raw('@rownum := @rownum + 1 AS rownum'), 'id', 'name']);
return Datatables::of($items)->addColumn('action', function ($item) {
return '<a href="./item/edit/' . $item->id . '" class="btn btn-xs btn-primary"><i class="glyphicon glyphicon-edit"></i> Edit</a>';
})->make(true);
}
/**
* Fetch item details
* If item_id is provided then details of only that item will be fetched
* Else complete list will be retrieved
*
* @param null $item_id
* @return object
*/
public function itemDetails($item_id = NULL)
{
$item = Item::select('id', 'name', 'unit', 'rate', 'tax_id', 'description');
if (!is_null($item_id)) {
$item = $item->where('id', $item_id)->first();
}
return $item;
}
/**
* Get matching items for autocompletion stuff
*
* @return array
*/
public function autocomplete()
{
// Request data
$query = $this->getInput('q');
$language = $this->requestedLanguage();
// No search for too short queries
if (strlen($query) < 3) {
return $this->apiResponse([], 2678400);
}
// Return the items that match the search query
$matching = Item::select(['id', 'name_' . $language . ' AS name', 'image', 'rarity', 'level'])->where('name_' . $language, 'LIKE', '%' . $query . '%')->take(25)->get()->toArray();
return $this->apiResponse($matching, 86400);
}
public function getItemData()
{
$obj = new Item();
$cols = $obj->current_columns();
$item = Item::select(array('items.id', 'items.measure', 'vendors.name', 'items.date', 'items.container', 'items.receive'))->join('vendors', 'items.vendor_id', '=', 'vendors.id');
return Datatables::of($item)->make(true);
}
private function resolveItemsBySkinName($skins)
{
$skinName = function ($skin) {
return $skin . ' Skin';
};
// Grab the names of the remaining skins
$names = array_map($skinName, array_pluck($skins, 'name'));
// Try to find them
$name_items = Item::select('name_en', DB::raw("GROUP_CONCAT(DISTINCT id SEPARATOR ',') AS items"))->whereIn('name_en', $names)->groupBy('name_en')->lists('items', 'name_en');
foreach ($skins as &$skin) {
$name = $skinName($skin['name']);
if (!isset($name_items[$name])) {
continue;
}
$skin_items = explode(',', $name_items[$name]);
if (isset($skin['items'])) {
$skin['items'] = array_merge($skin['items'], $skin_items);
} else {
$skin['items'] = $skin_items;
}
}
$this->info('Resolved ' . count($name_items) . ' skins by skin name lookup...');
return $skins;
}
