public function destroy($id)
{
$priceLog = PriceLog::find($id);
$priceLog->delete();
return redirect()->action('PriceLogsController@index');
}
public function store()
{
$input = Request::all();
//print_r(array_values($input))
//print_r("pasok");
//$invoiceItem = new InvoiceItem;
$salesInvoice = new SalesInvoice();
//print_r($salesInvoice);
$salesInvoice->status = "Draft";
$salesInvoice->client_id = $input['client_id'];
$client = Client::find($input['client_id']);
$salesInvoice->user_id = $client->user_id;
$salesInvoice->save();
$no_items = $input['item_count'];
//print_r($no_items);
$sameItem = false;
$sameSupplier = false;
$itemList = [];
for ($i = 1; $i <= $no_items; $i++) {
$finder = 'item_id' . strval($i);
try {
array_push($itemList, $input[$finder]);
} catch (Exception $e) {
}
$supplierList = [];
$supplierer = $input['supplier_id' . strval($i)];
$supplierer2 = $input['supplier_idB' . strval($i)];
$supplierer3 = $input['supplier_idC' . strval($i)];
if ($supplierer3 == "none") {
$supplierer3 = "hello";
}
if ($supplierer == $supplierer2 || $supplierer2 == $supplierer3 || $supplierer == $supplierer3) {
$sameSupplier = true;
}
}
if (count($itemList) !== count(array_unique($itemList))) {
$sameItem = true;
}
if ($sameItem == true) {
return redirect()->back()->withInput()->with('message', 'You cannot have the same item in the sales invoice.');
}
if ($sameSupplier == true) {
return redirect()->back()->withInput()->with('message', 'You cannot have the same supplier for a single item.');
}
for ($i = 1; $i <= $no_items; $i++) {
$invoiceItem = new InvoiceItem();
$finder = 'item_id' . strval($i);
$invoiceItem->item_id = $input[$finder];
$invoiceItem->sales_invoice_id = $salesInvoice->id;
$invoiceItem->save();
$priceLog = new PriceLog();
$pricer = 'item_price' . strval($i);
$availer = 'availA' . strval($i);
$supplierer = 'supplier_id' . strval($i);
if ($input[$pricer] == 0 || $input[$supplierer] == "none") {
//do nothing
} else {
$priceLog->date = Carbon::now();
$priceLog->price = $input[$pricer];
$priceLog->stock_availability = $input[$availer];
$priceLog->item_id = $input[$finder];
$priceLog->supplier_id = $input[$supplierer];
$priceLog->save();
}
$priceLog2 = new PriceLog();
$pricer2 = 'item_priceB' . strval($i);
$availer2 = 'availB' . strval($i);
$supplierer2 = 'supplier_idB' . strval($i);
if ($input[$pricer2] == 0 || $input[$supplierer2] == "none") {
//do nothing
} else {
$priceLog2->date = Carbon::now();
$priceLog2->price = $input[$pricer2];
$priceLog2->stock_availability = $input[$availer2];
$priceLog2->item_id = $input[$finder];
$priceLog2->supplier_id = $input[$supplierer2];
$priceLog2->save();
}
$priceLog3 = new PriceLog();
$pricer3 = 'item_priceC' . strval($i);
$availer3 = 'availC' . strval($i);
$supplierer3 = 'supplier_idC' . strval($i);
if ($input[$pricer3] == 0 || $input[$supplierer3] == "none") {
//do nothing
} else {
$priceLog3->date = Carbon::now();
$priceLog3->price = $input[$pricer3];
$priceLog3->stock_availability = $input[$availer3];
$priceLog3->item_id = $input[$finder];
$priceLog3->supplier_id = $input[$supplierer3];
$priceLog3->save();
}
//if (Auth::user()['role'] !== 'Sales')
}
// $invoiceItem->sales_invoice_id = $salesInvoice->id;
// $invoiceItem->item_id = $input['item_id'];
//print_r(array_values($invoiceItem));
//print_r($invoiceItem);
// $invoiceItem->item_id = $input['item_id'];
// $priceLog->stock_availability = $input['stock_availability'];
// $priceLog->supplier_id = $input['supplier_id'];
// $priceLog->item_id = $input['item_id'];
// $priceLog->save();
Activity::log('Quotation for invoice ' . $salesInvoice['si_no'] . ' was added');
return redirect()->action('SalesInvoicesController@make', [$salesInvoice->id]);
//return redirect()->action('ClientsController@index');
}
<div id="myModal" class="modal fade" role="dialog">
<div class="modal-dialog modal-sm">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Latest Price Logs for <?php
echo Item::find($item->item_id)->name;
?>
</h4>
</div>
<div class="modal-body">
<?php
$price_logs = PriceLog::where('item_id', $item->item_id)->orderBy('created_at', 'desc')->take(3)->get();
?>
@foreach ($price_logs as $price_log)
<p><?php
echo Supplier::withTrashed()->find($price_log->supplier_id)->name;
?>
: Php {{ number_format($price_log->price, 2, '.', ',') }}</p>
@endforeach
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<script>
