public function run()
{
$count = 6001;
foreach ($this->shopkeepers as $shopkeeper) {
try {
$user = User::create(['name' => $shopkeeper['name'], 'tel' => $shopkeeper['tel'], 'address' => $shopkeeper['address'], 'commune' => $shopkeeper['commune'], 'username' => $shopkeeper['tel'] ? $shopkeeper['tel'] : $count, 'password' => 123, 'type' => 'shopkeeper', 'municipality_id' => 685, 'email' => null]);
if (!$shopkeeper['tel']) {
$count++;
}
ShoppingInterest::create(['product_id' => 1, 'user_id' => $user->id, 'amount' => $shopkeeper['papa'], 'unit' => 'kg']);
ShoppingInterest::create(['product_id' => 2, 'user_id' => $user->id, 'amount' => $shopkeeper['yuca'], 'unit' => 'kg']);
ShoppingInterest::create(['product_id' => 3, 'user_id' => $user->id, 'amount' => $shopkeeper['arracacha'], 'unit' => 'kg']);
ShoppingInterest::create(['product_id' => 7, 'user_id' => $user->id, 'amount' => $shopkeeper['platano'], 'unit' => 'kg']);
ShoppingInterest::create(['product_id' => 11, 'user_id' => $user->id, 'amount' => $shopkeeper['hortalizas'], 'unit' => 'kg']);
ShoppingInterest::create(['product_id' => 20, 'user_id' => $user->id, 'amount' => $shopkeeper['frutas'], 'unit' => 'kg']);
} catch (QueryException $e) {
}
}
}
public function getCommunesStatistics(Request $request)
{
$commune = $request->get('commune') ? $request->get('commune') : 1;
$products = ShoppingInterest::select('product_id', 'products.name', \DB::raw('SUM(amount) as total'))->join('users', 'users.id', '=', 'user_id')->join('products', 'products.id', '=', 'product_id')->whereUnit('kg')->whereCommune($commune)->orderBy('product_id', 'asc')->groupBy('product_id')->get();
$stat = ['content' => [['label' => 'Compra de Producto en KG', 'data' => []]], 'names' => []];
$count = 0;
foreach ($products as $product) {
array_push($stat['content'][0]['data'], [$count, $product->total]);
array_push($stat['names'], [$count + 0.5, $product->name . ' (' . $product->total . ') ']);
$count += 1.5;
}
return $stat;
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function deleteProduct(Request $request, $id)
{
$shoppingInterest = ShoppingInterest::findOrFail($id);
$shoppingInterest->delete();
return response()->json(['success' => true, 'message' => 'Compra eliminada correctamente']);
}
