public function getProductbalance($product_id)
{
$stockCount = StockCount::where('product_id', '=', $product_id)->where('stock_info_id', '=', Input::get('data'))->first();
if ($stockCount) {
echo "<p3 style='color: blue;font-size: 114%; margin-left: 32px;'>Your product Balance This Stock is {$stockCount->product_quantity}</p3>";
} else {
echo "<p3 style='color: blue;font-size: 114%; margin-left: 32px; '>You Dont have this Product In this Stock</p3>";
}
}
public function getDelete($id)
{
$stock = StockDetail::find($id);
$stockCount = StockCount::where('product_id', '=', $stock->product_id)->where('stock_info_id', '=', $stock->stock_info_id)->get();
if ($stock->entry_type == 'StockIn') {
$stockCount[0]->product_quantity = $stockCount[0]->product_quantity - $stock->quantity;
$stockCount[0]->save();
} elseif ($stock->entry_type == 'StockOut') {
$stockCount[0]->product_quantity = $stockCount[0]->product_quantity + $stock->quantity;
$stockCount[0]->save();
} elseif ($stock->entry_type == 'Transfer') {
$stockCount[0]->product_quantity = $stockCount[0]->product_quantity + $stock->quantity;
$stockCount[0]->save();
$stockCountTo = StockCount::where('product_id', '=', $stock->product_id)->where('stock_info_id', '=', $stock->to_stock_info_id)->get();
$stockCountTo[0]->product_quantity = $stockCountTo[0]->product_quantity - $stock->quantity;
$stockCountTo[0]->save();
}
$invoice_id = $stock->invoice_id;
$stock->delete();
$checkStockDetailsRow = StockDetail::where('invoice_id', '=', $invoice_id)->get();
if (empty($checkStockDetailsRow[0])) {
$stock_invoice = StockInvoice::where('invoice_id', '=', $invoice_id)->get();
if (!empty($stock_invoice[0])) {
echo 'deleted';
$stock_invoice[0]->delete();
}
}
//Session::flash('message', 'Stock has been Successfully Deleted.');
//return Redirect::to('stocks/index');
}
private function setStockData($import, $import_details, $stockDetails, $invoiceId, $to_stock_id)
{
$stock_Count = StockCount::where('product_id', '=', $import_details->product_id)->where('stock_info_id', '=', $to_stock_id)->get();
$stockDetails->branch_id = $import->branch_id;
$stockDetails->product_id = $import_details->product_id;
$stockDetails->entry_type = "StockIn";
$product = Product::find($import_details->product_id);
$stockDetails->product_type = $product->product_type;
$stockDetails->stock_info_id = $to_stock_id;
$stockDetails->remarks = "";
$stockDetails->invoice_id = $invoiceId;
$stockDetails->quantity = $import_details->quantity;
$import_details->stock_in_status = 1;
$import_details->save();
if ($stockDetails->entry_type == 'StockIn') {
$stockDetails->consignment_name = $import->consignment_name;
if (empty($stock_Count[0])) {
$stock_Count = new StockCount();
$stock_Count->product_id = $import_details->product_id;
$stock_Count->stock_info_id = $stockDetails->stock_info_id;
$stock_Count->product_quantity = $import_details->quantity;
$stock_Count->save();
$stockDetails->save();
//$stockCounts->save();
} else {
$stock_Count[0]->product_quantity = $stock_Count[0]->product_quantity + $import_details->quantity;
//$stock->save();
$stock_Count[0]->save();
$stockDetails->save();
}
}
}
public function getDelete($id)
{
$stock = Stock::find($id);
$stockCount = StockCount::where('product_id', '=', $stock->product_id)->where('stock_info_id', '=', $stock->stock_info_id)->get();
if ($stock->entry_type == 'StockIn') {
$stockCount[0]->product_quantity = $stockCount[0]->product_quantity - $stock->product_quantity;
$stockCount[0]->save();
} elseif ($stock->entry_type == 'StockOut') {
$stockCount[0]->product_quantity = $stockCount[0]->product_quantity + $stock->product_quantity;
$stockCount[0]->save();
} elseif ($stock->entry_type == 'Transfer') {
$stockCount[0]->product_quantity = $stockCount[0]->product_quantity + $stock->product_quantity;
$stockCount[0]->save();
$stockCountTo = StockCount::where('product_id', '=', $stock->product_id)->where('stock_info_id', '=', $stock->to_stock_info_id)->get();
$stockCountTo[0]->product_quantity = $stockCountTo[0]->product_quantity - $stock->product_quantity;
$stockCountTo[0]->save();
}
$stock->delete();
Session::flash('message', 'Stock has been Successfully Deleted.');
return Redirect::to('stocks/index');
}
public function getStocks($id)
{
$stocks = StockCount::where('product_id', '=', $id)->get();
$stockArray = array();
$x = "";
foreach ($stocks as $row) {
$stockInfo = StockInfo::find($row->stock_info_id);
$x .= "<option value='" . $row->stock_info_id . "'>" . $stockInfo->name . " (" . $row->product_quantity . ")</option>";
array_push($stockArray, $row->stock_info_id);
}
$stocks = StockInfo::whereNotIn('id', $stockArray)->get();
foreach ($stocks as $row) {
$x .= "<option value='" . $row->id . "'>" . $row->name . " (0)</option>";
}
$product = Product::find($id);
$data = array('list' => $x, 'price' => $product->price);
return json_encode($data);
}