public function run()
{
OrdersItem::create(['order_id' => 1, 'product_id' => 1, 'quantity' => 1, 'price' => 690100, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 2, 'quantity' => 1, 'price' => 110000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 3, 'quantity' => 1, 'price' => 770500, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 4, 'quantity' => 1, 'price' => 23760, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 5, 'quantity' => 1, 'price' => 48240, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 6, 'quantity' => 1, 'price' => 230000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 7, 'quantity' => 1, 'price' => 300000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 8, 'quantity' => 13, 'price' => 579000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 12, 'quantity' => 2.8, 'price' => 900000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 13, 'quantity' => 24, 'price' => 220000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 14, 'quantity' => 20, 'price' => 194300, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 15, 'quantity' => 10, 'price' => 20000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 16, 'quantity' => 3, 'price' => 80000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 18, 'quantity' => 2, 'price' => 66950, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 19, 'quantity' => 6, 'price' => 42000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 20, 'quantity' => 20, 'price' => 14885, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 21, 'quantity' => 19, 'price' => 110000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 22, 'quantity' => 10, 'price' => 110000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 23, 'quantity' => 1, 'price' => 1000000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 24, 'quantity' => 5, 'price' => 240000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 25, 'quantity' => 41, 'price' => 215000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 27, 'quantity' => 18, 'price' => 58900, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 28, 'quantity' => 7, 'price' => 210000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 17, 'quantity' => 2, 'price' => 20000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 26, 'quantity' => 11.5, 'price' => 620000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 29, 'quantity' => 1, 'price' => 95000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 30, 'quantity' => 40, 'price' => 380000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 31, 'quantity' => 1, 'price' => 250000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 32, 'quantity' => 3, 'price' => 198000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 33, 'quantity' => 39, 'price' => 13650, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 34, 'quantity' => 30, 'price' => 379000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 35, 'quantity' => 36, 'price' => 38000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 36, 'quantity' => 1, 'price' => 70000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 37, 'quantity' => 150, 'price' => 4000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 38, 'quantity' => 2, 'price' => 250000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 39, 'quantity' => 53, 'price' => 239000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 40, 'quantity' => 1, 'price' => 110000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 41, 'quantity' => 33, 'price' => 58000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 42, 'quantity' => 6, 'price' => 140000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 43, 'quantity' => 255, 'price' => 15810, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 44, 'quantity' => 54, 'price' => 36270, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 46, 'quantity' => 60, 'price' => 30000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 47, 'quantity' => 2, 'price' => 70000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 48, 'quantity' => 6, 'price' => 223000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 51, 'quantity' => 12, 'price' => 159300, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 53, 'quantity' => 44, 'price' => 155000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 54, 'quantity' => 1, 'price' => 580000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 55, 'quantity' => 5, 'price' => 200850, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 56, 'quantity' => 5, 'price' => 201250, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 57, 'quantity' => 3, 'price' => 161850, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 58, 'quantity' => 17, 'price' => 8000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 59, 'quantity' => 12, 'price' => 200000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
OrdersItem::create(['order_id' => 1, 'product_id' => 60, 'quantity' => 15, 'price' => 130000, 'discount' => 0, 'tax' => 0, 'lot_number' => null, 'creation_date' => null, 'expiry_date' => null]);
}
/**
* Display a listing of ordersitems
*
* @return Response
*/
public function index()
{
$ordersitems = OrdersItem::with(["order.business", "order.invoices", "order.customer", "product.unit"])->whereHas('order', function ($q) {
$q->where('business_id', '=', 2);
})->get();
foreach ($ordersitems as $orderItem) {
$raw = $orderItem->price * $orderItem->quantity;
$discountValue = $raw * $orderItem->discount / 100;
$taxValue = $raw * $orderItem->tax / 100;
$amount = $raw + $taxValue - $discountValue;
array_add($orderItem, 'amount', $amount);
}
return Response::json($ordersitems);
}
/**
* Remove the specified product from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$orderItems = OrdersItem::where('order_id', '=', $id)->get();
$invoices = Invoice::where('order_id', '=', $id)->get();
if ($orderItems) {
foreach ($orderItems as $orderItem) {
OrdersItem::destroy($orderItem->id);
}
}
if ($invoices) {
foreach ($invoices as $invoice) {
Invoice::destroy($invoice->id);
}
}
Order::destroy($id);
return Response::json(array('success' => true));
}
