public function getDelete($id) { $del = SubCategory::find($id); try { $del->delete(); Session::flash('message', 'Sub Category has been Successfully Deleted.'); } catch (Exception $e) { Session::flash('message', 'This Sub Category can\'t delete because it is used to file'); } return Redirect::to('productsubcategories/index'); }
public function getProduct($type) { $branch = Input::get('data'); $productsName = Product::where('product_type', '=', $type)->where('branch_id', '=', $branch)->get(); foreach ($productsName as $productName) { $category = $productName->category->name; if ($productName->sub_category_id) { $subCategory = SubCategory::find($productName->sub_category_id); $subCategoryName = $subCategory->name; } else { $subCategoryName = ''; } echo "<option value = {$productName->id} > {$productName->name} ({$category}) ({$subCategoryName})</option> "; } }
public function getProducts($type) { $productsName = Product::where('product_type', '=', $type)->where('branch_id', '=', Input::get('data'))->get(); $product_id = Input::get('data'); foreach ($productsName as $productName) { $category = $productName->category->name; if ($productName->sub_category_id) { $subCategory = SubCategory::find($productName->sub_category_id); $subCategoryName = $subCategory->name; } else { $subCategoryName = ''; } if ($productName->id == $product_id) { echo '<option value = "' . $productName->id . '" selected> ' . $productName->name . ' (' . $category . ') (' . $subCategoryName . ')</option> '; } else { echo "<option value = {$productName->id} > {$productName->name} ({$category}) ({$subCategoryName})</option> "; } } }
<th>#</th> <th>Product</th> <th class="hidden-480">Description</th> <th style="text-align: right;" class="hidden-480">Quantity</th> </tr> </thead> <tbody> <?php $i = 1; $total = 0; ?> @foreach($saleDetails as $saleDetail ) <?php $products = \App\Product::find($saleDetail->product_id); $categoryName = \App\Category::find($saleDetail->product->category_id); $subCategoryName = \App\SubCategory::find($saleDetail->product->sub_category_id); ?> <tr> <td>{{$i}}</td> <td>{{$saleDetail->product->name.'('.$categoryName->name.')'.'('.$subCategoryName->name.')'}}</td> <td>{{$products->origin}}</td> <td style="text-align: right;">{{$saleDetail->quantity}}</td> </tr> @endforeach </tbody> </table> <div class="row">
public function getProducts($category) { $productsNames = Product::where('category_id', '=', $category)->get(); foreach ($productsNames as $productName) { $category = Category::find($productName->category_id); if ($productName->sub_category_id) { $subCategory = SubCategory::find($productName->sub_category_id); $subCategoryName = $subCategory->name; } else { $subCategoryName = ''; } echo "<option value = {$productName->id} > {$productName->name} ({$category->name}) ({$subCategoryName})</option> "; } }
<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 }} @else {{"Not Available"}} @endif
<th class="numeric">Issued</th> <th class="numeric">Remaining</th> <th>Remarks</th> <th>Created By</th> <!-- <th>Status</th>--> <th>Action</th> </tr> </thead> <tbody> <?php $sl = 1; ?> @foreach($requisitions as $requisition ) <?php $branchName = \App\Branch::find($requisition->branch_id); $subCategory = \App\SubCategory::find($requisition->product->sub_category_id); $subCategoryName = '(' . $subCategory->name . ')'; ?> <tr class="odd gradeX"> <td><?php echo $sl; ?> </td> <td>{{$branchName->name}}</td> <td>{{$requisition->product->name."(".$requisition->product->category->name.")".$subCategoryName}}</td> <td>{{$requisition->party->name}}</td> <td>{{$requisition->requisition_id}}</td> <td class="numeric">{{$requisition->requisition_quantity}}</td> <td class="numeric">{{$requisition->issued_quantity}}</td> <td class="numeric">{{$requisition->requisition_quantity-$requisition->issued_quantity}}</td> <td>{{$requisition->remarks}}</td>
<th>Product Name</th> <th>Stock Name</th> <th>Entry Type</th> <th>Quantity</th> <th>Remarks</th> <th>Consignment Name</th> </tr> </thead> <tbody> @foreach($results as $result ) <?php $categoryName = \App\Category::find($result->cid); $subCategoryName = \App\SubCategory::find($result->sid); ?> <tr class="odd gradeX"> <td>{{$result->pName.'('.$categoryName->name.')'.'('.$subCategoryName->name.')'}}</td> <td>{{$result->sName}}</td> <td>{{$result->entry_type}}</td> <td>{{$result->product_quantity}}</td> <td>{{$result->remarks}}</td> <td>{{$result->consignment_name}}</td> </tr> @endforeach </tbody> </table> @else
Route::post('updateSubCategory', ['middleware' => 'auth', 'uses' => 'SubCategoriesController@update']); Route::post('addSubCategory', ['middleware' => 'auth', 'uses' => 'SubCategoriesController@store']); /* |-------------------------------------------------------------------------- | END SUB-CATEGORIES ROUTING |-------------------------------------------------------------------------- | */ /* |-------------------------------------------------------------------------- | SUB-SUB-CATEGORIES ROUTING |-------------------------------------------------------------------------- | */ Route::get('list-sub-sub-categories/{sub_category}', ['middleware' => 'auth', function ($sub_category) { $subCatObj = SubCategory::find($sub_category); $catObj = Category::find($subCatObj->category); $deptObj = Department::find($catObj->department); return view('subsubcategories.list', compact('subCatObj', 'deptObj', 'catObj')); }]); Route::get('sub-sub-categories-list/{id}', ['middleware' => 'auth', 'uses' => 'SubSubCategoriesController@index']); Route::get('subsubcategories/{id}', ['middleware' => 'auth', 'uses' => 'SubSubCategoriesController@edit']); Route::post('addSubSubCategory', ['middleware' => 'auth', 'uses' => 'SubSubCategoriesController@store']); Route::post('updateSubSubCategory', ['middleware' => 'auth', 'uses' => 'SubSubCategoriesController@update']); /* |-------------------------------------------------------------------------- | END SUB-SUB-CATEGORIES ROUTING |-------------------------------------------------------------------------- | */ /*
'Foreign','Finish Goods'=>'Finish Goods'),'null', array('class'=>'form-control','id'=>'product_type'))!!} </div> </div> </td> <td> <div class="form-body"> <div class="form-group"> <select id="product_id" name="product_id" class="form-control productIdInEditStockInvoice"> <option value="">Select Product</option> <?php foreach ($productsName as $productName) { $category = $productName->category->name; if ($productName->sub_category_id) { $subCategory = \App\SubCategory::find($productName->sub_category_id); $subCategoryName = '(' . $subCategory->name . ')'; } else { $subCategoryName = ''; } echo "<option value = {$productName->id} > {$productName->name} ({$category}) {$subCategoryName}</option> "; } ?> </select> </div> </div> </td> <td> <div class="form-body"> <div class="form-group">
public function getProducts($branch_id) { $poductsNames = Product::where('branch_id', '=', $branch_id)->get(); foreach ($poductsNames as $product) { $category = $product->category->name; if ($product->sub_category_id) { $subCategory = SubCategory::find($product->sub_category_id); $subCategoryName = '(' . $subCategory->name . ')'; } else { $subCategoryName = ''; } echo "<option value = {$product->id} > {$product->name} ({$category}) {$subCategoryName}</option> "; } }
<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> @endif </td>
$totalDuty = 0; $totalLandingCost = 0; ?> @foreach($imports as $importt ) <tr class="odd gradeX"> <?php $value = $importt->po_cash * 100 / ($grandTotalCrf * $importt->dollar_to_bd_rate); $duty = $importt->total_cfr_price * $importt->dollar_to_bd_rate * $value / 100; $totalQuantity = $totalQuantity + $importt->quantity; $totalBookingPrice = $totalBookingPrice + $importt->total_booking_price * $importt->quantity; $totalCrfPrice = $totalCrfPrice + $importt->total_cfr_price * $importt->quantity; $totalDuty = $totalDuty + $duty * $importt->quantity; $landingCost = ($ttCharge[0]['tt_charge'] + $totalBankCost[0]['total_bank_cost'] + $totalCnfCost[0]['total_cnf_cost']) / $totalQuantitySum + $importt->total_booking_price * $importt->dollar_to_bd_rate + $duty; $totalLandingCost = $totalLandingCost + $landingCost * $importt->quantity; $categoryName = \App\Category::find($importt->category_id); $subCategoryName = \App\SubCategory::find($importt->sub_category_id); ?> <td>{{ $i }}</td> <td>{{ $importt->name.'('.$categoryName->name.')'.'('.$subCategoryName->name.')' }}</td> <td style="text-align: right;">{{ $importt->total_booking_price }}</td> <td style="text-align: right;">{{ $importt->total_booking_price * $importt->dollar_to_bd_rate }}</td> <td style="text-align: right;">{{ $importt->total_cfr_price }}</td> <td style="text-align: right;">{{ $importt->total_cfr_price * $importt->dollar_to_bd_rate }}</td> <td style="text-align: right;">{{ $importt->quantity }}</td> <td style="text-align: right;">{{ round($duty,2) }}</td> <td style="text-align: right;">{{ round($landingCost,2) }}</td> <td style="text-align: right;">{{ $importt->quantity * $importt->total_booking_price }}</td> <td style="text-align: right;">{{ $importt->quantity * $importt->total_cfr_price }}</td> <td style="text-align: right;">{{ round($duty * $importt->quantity,2) }}</td> <td style="text-align: right;">{{ round($landingCost * $importt->quantity,2)}}</td>
<th>Category</th> <th>Sub Category</th> <th>Total Qty</th> <th>Created By</th> <th>Action</th> </tr> </thead> <tbody> <?php $sl = 1; ?> @foreach($products as $product ) <?php $subCategoryName = \App\SubCategory::find($product->sub_category_id); ?> <tr class="odd gradeX"> <td><?php echo $sl; ?> </td> <td>{{$product->name}}</td> <td>{{$product->branch->name}}</td> <td>{{$product->category->name}}</td> @if($product->sub_category_id == 0) <td>N/A</td> @else <td>{{$subCategoryName->name}}</td> @endif
<th>Quantity</th> <th>Discount Percentage </th> <th style="text-align: right;">Return Amount</th> </tr> </thead> <tbody> <?php $total = 0; ?> @foreach($results as $result ) <?php $products = \App\Product::find($result->product_id); $categories = \App\Category::find($products->category_id); $subCategories = \App\SubCategory::find($products->sub_category_id); if ($products->sub_category_id) { $subCategoryName = '(' . $subCategories->name . ')'; } else { $subCategoryName = ''; } ?> <tr class="odd gradeX"> <td>{{\App\Transaction::convertDate($result->date)}}</td> <td>{{$result->invoice_id}}</td> <td>{{$products->name.'('.$categories->name.')'.$subCategoryName}}</td> <td>{{$result->unit_price}}</td> <td>{{$result->quantity}}</td> <td>{{$result->discount_percentage}}</td> <td style="text-align: right;">{{$result->return_amount }}</td>
<th>Category Name</th> <th>Sub-Category Name</th> <th>Total Quantity On Hand</th> </tr> </thead> <tbody> <?php $grandTotal = 0; ?> @foreach($results as $result ) <?php $pName = \App\Product::find($result->product_id); $categoryName = \App\Category::find($pName->category_id); $subCategoryName = \App\SubCategory::find($pName->sub_category_id); $grandTotal = $grandTotal + $result->product_quantity; ?> <tr class="odd gradeX"> <td>{{$pName->name}}</td> <td>{{$categoryName->name}}</td> <td>{{$subCategoryName->name}}</td> <td>{{$result->product_quantity}}</td> </tr> @endforeach <tr> <td>Total</td>
</thead> <tbody> <?php $grandTotalStockIn = 0; $grandTotalStockOut = 0; $grandTotalStockWastage = 0; $grandTotalStockBf = 0; $grandTotalStockInBf = 0; $grandTotalBalance = 0; ?> @foreach($results as $result ) <?php $stocks = new \App\Report(); $sub_category = new \App\SubCategory(); $sub_categoryName = \App\SubCategory::find($result->subCategory); $bfIn = $stocks->getStockBf($product_type, $date1, $result->product_id); $bfOut = $stocks->getStockBfOut($product_type, $date1, $result->product_id); $stockIn = $stocks->getStockIn($product_type, $date1, $date2, $result->product_id); $stockOut = $stocks->getStockOut($product_type, $date1, $date2, $result->product_id); $wastage = $stocks->getStockWastage($product_type, $date1, $date2, $result->product_id); $bf = $bfIn[0]->stockBf - $bfOut[0]->stockBfOut; $totalIn = $bf + $stockIn[0]->stockIn; $balance = $totalIn - $stockOut[0]->stockOut; ?> <tr class="odd gradeX"> <td>{{$result->pName.'('.$result->category.')'.'('.$sub_categoryName->name.')'}}</td> <td style="text-align: right;">@if($stockIn[0]->stockIn){{ $stockIn[0]->stockIn }}@else {{ 0 }}@endif</td> <td style="text-align: right;">@if($bf){{ $bf }}@else {{ 0 }}@endif</td>
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; }