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> ";
     }
 }
示例#3
0
 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> ";
     }
 }
示例#6
0
                    <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
示例#7
0
                        <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
示例#9
0
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
|--------------------------------------------------------------------------
|
*/
/*
示例#10
0
                         '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>
示例#13
0
$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>
示例#14
0
                        <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>
示例#18
0
 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;
 }