public function getChangeStatus($status, $id) { $stockInfo = StockInfo::find($id); if ($stockInfo['status'] == $status) { $stockInfo->status = $status == 'Activate' ? 'Deactivate' : 'Activate'; $stockInfo->save(); } return new JsonResponse(array('id' => $stockInfo['id'], 'status' => $stockInfo['status'])); }
<th width="">Stock Name</th> <th width="">Product Type</th> <th width="">Product Name</th> <th width="">Price</th> <th width="">Quantity</th> <th width="">Remarks</th> <th width="">Action</th> </tr> </thead> @foreach($saleDetails as $saleDetail) <?php $branch = new \App\Branch(); $stocks = new \App\StockInfo(); $stockName = \App\StockInfo::find($saleDetail->stock_info_id); $branchName = \App\Branch::find($saleDetail->branch_id); ?> <tr> <td> {{ $stockName->name }}</td> <td> {{ $saleDetail->product_type }}</td> <td> {{ $saleDetail->product->name }}</td> <td> {{ $saleDetail->price }}</td> <td> {{ $saleDetail->quantity }}</td> <td> @if($saleDetail->remarks) {{ $saleDetail->remarks }} @else {{"Not Available"}} @endif </td>
private function saleDetailConvertToArray($salesDetails) { $array = array(); $stockName = StockInfo::find($salesDetails->stock_info_id); $branchName = Branch::find($salesDetails->branch_id); $array['id'] = $salesDetails->id; $array['branch_id'] = $branchName->name; $array['stock_info_id'] = $stockName->name; $array['product_type'] = $salesDetails->product_type; $array['product_id'] = $salesDetails->product->name; $array['price'] = $salesDetails->price; $array['quantity'] = $salesDetails->quantity; $array['remarks'] = $salesDetails->remarks; return $array; }
<th>Price</th> <th>Quantity</th> <th>Amount</th> <th>Remarks</th> <th>Action</th> </tr> </thead> <tbody> <?php $total = 0; ?> @foreach($purchaseInvoiceDetails as $purchaseInvoiceDetail ) <?php $stocks = new \App\StockInfo(); $branch = new \App\Branch(); $stockName = \App\StockInfo::find($purchaseInvoiceDetail->stock_info_id); $branchName = \App\Branch::find($purchaseInvoiceDetail->branch_id); $categoryName = \App\Category::find($purchaseInvoiceDetail->product->category_id); $subCategoryName = \App\SubCategory::find($purchaseInvoiceDetail->product->sub_category_id); ?> <tr class="odd gradeX"> <td>{{$branchName->name}}</td> <td>{{$stockName->name}}</td> <td>{{$purchaseInvoiceDetail->product_type}}</td> <td>{{$purchaseInvoiceDetail->product->name.'('.$categoryName->name.')'.'('.$subCategoryName->name.')'}}</td> <td>{{$purchaseInvoiceDetail->price}}</td> <td>{{$purchaseInvoiceDetail->quantity}}</td> <td>{{$purchaseInvoiceDetail->quantity * $purchaseInvoiceDetail->price}}</td> <td> @if($purchaseInvoiceDetail->remarks) {{ $purchaseInvoiceDetail->remarks }}
private function purchaseInvoiceDetailConvertToArray($purchaseInvoiceDetails) { $array = array(); $stockName = StockInfo::find($purchaseInvoiceDetails->stock_info_id); $branchName = Branch::find($purchaseInvoiceDetails->branch_id); $array['id'] = $purchaseInvoiceDetails->id; $array['branch_id'] = $branchName->name; $array['stock_info_id'] = $stockName->name; $array['product_type'] = $purchaseInvoiceDetails->product_type; $categoryName = \App\Category::find($purchaseInvoiceDetails->product->category_id); $subCategoryName = \App\SubCategory::find($purchaseInvoiceDetails->product->sub_category_id); $array['product_id'] = $purchaseInvoiceDetails->product->name . '(' . $categoryName->name . ')' . '(' . $subCategoryName->name . ')'; $array['price'] = $purchaseInvoiceDetails->price; $array['quantity'] = $purchaseInvoiceDetails->quantity; $array['remarks'] = $purchaseInvoiceDetails->remarks; return $array; }
private function stockDetailConvertToArray($stockDetails) { $array = array(); $stockName = StockInfo::find($stockDetails->stock_info_id); $tostockName = StockInfo::find($stockDetails->to_stock_info_id); //var_dump($stockDetails->to_stock_info_id); die(); $branchName = Branch::find($stockDetails->branch_id); $array['id'] = $stockDetails->id; $array['branch_id'] = $branchName->name; $array['stock_info_id'] = $stockName->name; $array['product_type'] = $stockDetails->product_type; $productsName = Product::find($stockDetails->product_id); $category = $productsName->category->name; $subCategoryName = ''; if ($productsName->sub_category_id) { $subCategory = SubCategory::find($productsName->sub_category_id); $subCategoryName = '(' . $subCategory->name . ')'; } $array['product_id'] = $stockDetails->product->name . ' (' . $category . ') ' . $subCategoryName; if ($tostockName != null) { $array['to_stock_info_id'] = $tostockName->name; } $array['entry_type'] = $stockDetails->entry_type; $array['product_quantity'] = $stockDetails->quantity; $array['remarks'] = $stockDetails->remarks; $array['consignment_name'] = $stockDetails->consignment_name; return $array; }
<th>Quantity</th> <th>Remarks</th> <th>Total Sale</th> </tr> </thead> <tbody> <?php $totalSale = 0; $invoiceSave = array(); ?> @foreach($results as $result ) <?php $products = \App\Product::find($result->product_id); $stocks = \App\StockInfo::find($result->stock); $categories = \App\Category::find($result->category_id); $subCategories = \App\SubCategory::find($result->sub_category_id); if ($result->sub_category_id) { $subCategoryName = '(' . $subCategories->name . ')'; } else { $subCategoryName = ''; } ?> <tr class="odd gradeX"> <td> @if(in_array($result->invoice,$invoiceSave)) @else <a target="_blank" href="{{URL::to('sales?invoice_id='.$result->invoice)}}">{{$result->invoice}}</a>
<div class="row" style="margin-top: -10px;"> <div class="col-xs-8"> <table> <?php foreach ($stockDetails as $stockDetail) { ?> <tr> <td><b>Entry Type</b></td> <td>: {{$stockDetail->entry_type}}</td> </tr> <?php if ($stockDetail->entry_type == 'Transfer') { $stockName = \App\StockInfo::find($stockDetail->to_stock_info_id); ?> <tr> <td><b>Transfer To</b></td> <td>: {{$stockName->name}}</td> </tr> <?php } ?> <?php break; ?> <?php } ?>
<th>Remarks</th> <th>Consignment</th> <th>Created By</th> <!-- <th>Status</th>--> <th>Action</th> </tr> </thead> <tbody> <?php $sl = 1; ?> @foreach($stocks as $stock ) <?php $categoryName = \App\Category::find($stock->product->category_id); $subCategoryName = \App\SubCategory::find($stock->product->sub_category_id); $stockTo = \App\StockInfo::find($stock->to_stock_info_id); ?> <tr class="odd gradeX"> <td><?php echo $sl; ?> </td> <td>{{$stock->branch->name}}</td> <td>{{$stock->product->name.'('.$categoryName->name.')'.'('.$subCategoryName->name.')'}}</td> <td>{{$stock->stockInfo->name}}</td> <td>{{$stock->to_stock_info_id ? $stockTo->name : '' }}</td> <td>@if($stock->entry_type == 'StockIn') <span class="label label-sm label-success">StockIn</span> @elseif($stock->entry_type == 'StockOut') <span class="label label-sm label-danger">StockOut</span> @elseif($stock->entry_type == 'Transfer')
<div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"></button> <?php $userId = Session::get('user_id'); $userName = \App\User::find($userId); ?> <?php use Illuminate\Support\Facades\URL; $curent_url = $_SERVER['REQUEST_URI']; if ($curent_url == '/reports/printstocksproducts') { ?> <h3 class="page-title" style="text-align: center;"> All Stock Report </h3> <?php } else { $stock = \App\StockInfo::find($stock_info_id); $cat = \App\Category::find($category_id); $branch = \App\Branch::find($branch_id); ?> <center> <h3 style="text-align: center;">zxczxcStock In Hand Report</h3> <b>For Category: {{$cat->name}} and Stock:{{$stock->name}} and Branch {{$branch->name}}</b><br> <label>Printed by : {{$userName->name}}</label> </center> <?php } ?>
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); }