public function getEdit($id)
 {
     $branches = new Branch();
     $branchAll = $branches->getBranchesDropDown();
     $category = Category::find($id);
     return view('ProductCategory.edit', compact('branchAll'))->with('category', $category);
 }

 public function getEdit($id)
 {
     $users = User::find($id);
     $branches = new Branch();
     $branchAll = $branches->getBranchesDropDown();
     return view('Users.edit', compact('branchAll'))->with('userdata', $users);
 }

 public function getEdit($id)
 {
     $stockInfo = StockInfo::find($id);
     $branches = new Branch();
     $branchAll = $branches->getBranchesDropDown();
     return view('StockInfos.edit', compact('stockInfo'))->with('branchAll', $branchAll);
 }

 public function getCreate()
 {
     $branches = new Branch();
     $branchAll = $branches->getBranchesDropDown();
     $accountCategories = new AccountCategory();
     $accountCategoriesAll = $accountCategories->getAccountCategoriesDropDown();
     return view('BalanceTransfers.add')->with('branchAll', $branchAll)->with('accountCategoriesAll', $accountCategoriesAll);
 }

 public function getEdit($id)
 {
     $account = NameOfAccount::find($id);
     $accountCategories = new AccountCategory();
     $accountCategoriesAll = $accountCategories->getAccountCategoriesDropDown();
     $branches = new Branch();
     $branchAll = $branches->getBranchesDropDown();
     return view('AccountName.edit', compact('account'))->with('accountCategoriesAll', $accountCategoriesAll)->with('branchAll', $branchAll);
 }

 public function getEdit($id)
 {
     $categories = new Category();
     $allCategory = $categories->getCategoriesDropDown();
     $branches = new Branch();
     $branchAll = $branches->getBranchesDropDown();
     $subCategory = SubCategory::find($id);
     return view('ProductSubCategory.edit', compact('branchAll'))->with('subCategory', $subCategory)->with('categoryAll', $allCategory);
 }

 public static function addNew(Request $request)
 {
     $branch = new Branch();
     $branch->name = $request->input('name');
     $branch->phone = $request->input('phone');
     $branch->fax = $request->input('fax');
     $branch->email = $request->input('email');
     $branch->save();
     return $branch;
 }

 public function getCreate()
 {
     $stockInfos = new StockInfo();
     $allStockInfos = $stockInfos->getStockInfoDropDown();
     $parties = new Party();
     $partyAll = $parties->getPartiesDropDown();
     $imports = new Import();
     $consignmentAll = $imports->getConsignmentNameDropDown();
     $branches = new Branch();
     $branchAll = $branches->getBranchesDropDown();
     return view('SalesReturn.add', compact('allStockInfos', 'consignmentAll'))->with('branchAll', $branchAll)->with('partyAll', $partyAll);
 }

 public function getStockProducts()
 {
     $branches = new Branch();
     $branchAll = $branches->getBranchesDropDown();
     $stockInfos = new StockInfo();
     $allStockInfos = $stockInfos->getStockInfoDropDown();
     $catogories = new Category();
     $categoriesAll = $catogories->getCategoriesDropDown();
     $products = new Product();
     $productAll = $products->getProductsWithCategories();
     return view('Searches.stockProduct', compact('productAll'))->with('categoriesAll', $categoriesAll)->with('allStockInfos', $allStockInfos)->with('branchAll', $branchAll);
 }

 public function getChangeStatus($status, $id)
 {
     $branch = Branch::find($id);
     if ($branch['status'] == $status) {
         $branch->status = $status == 'Activate' ? 'Deactivate' : 'Activate';
         $branch->save();
     }
     return new JsonResponse(array('id' => $branch['id'], 'status' => $branch['status']));
 }

 /**
  * Store a newly created resource in storage.
  *
  * @return Response
  */
 public function store(Request $request)
 {
     $this->validate($request, ['name' => 'required|max:255', 'mobile' => 'numeric|min:10', 'telephone' => 'numeric']);
     $input = $request->all();
     $input['company_id'] = Auth::user()->company->id;
     $input['account_year_id'] = session('account');
     Branch::create($input);
     flash()->success('Branch Created Successfully !');
     return redirect('branch');
 }

 public function showWaitingRoom(Request $request)
 {
     if ($request->session()->get('global_branch') == 'all') {
         $branches = Branch::all();
     } else {
         $branches[] = Branch::findOrFail($request->session()->get('global_branch'));
     }
     $vars = array('branches' => $branches);
     return view('backend.page.waiting-room')->with($vars);
 }

 /**
  * Show the form for creating a new resource.
  *
  * @return Response
  */
 public function create()
 {
     $party = $this->party->orderBy('name', 'asc')->lists('name', 'id');
     if (Auth::user()->hasRole('admin')) {
         $branch = Branch::all()->lists('name', 'id');
     } else {
         $branch = $this->branch->orderBy('name', 'asc')->lists('name', 'id');
     }
     return view('godown.create', compact('party', 'branch'));
 }

 public function doAddStockItem(Request $request)
 {
     if (count($request->input('branches')) > 0) {
         $stock_item = Stock::addNew(["name" => $request->input('name'), "ean" => $request->input('ean'), "low_stock_notification_level" => $request->input('low-stock-number')]);
         foreach ($request->input('branches') as $branch_id) {
             $branch = Branch::findOrFail($branch_id);
             $stock_item->attachToBranch($branch);
         }
     }
     return redirect()->back()->with('stock-item-added', true);
 }

 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function show($id)
 {
     //
     $company = Company::find($id);
     $branches = Branch::where("company_id", "=", $company->id)->get();
     $stacks = Invoicingstack::where("company_id", "=", $company->id)->where("status", "=", 0)->get();
     $stack2s = Invoicingstack::where("company_id", "=", $company->id)->get();
     $invoice = Bill::where("company_id", "=", $company->id)->get();
     $invoiceGroup = Bill::where("company_id", "=", $company->id)->groupBy("invoice_date")->get();
     return View("company.companydetail", ['invGp' => $invoiceGroup, 'stacks' => $stacks, 'stack2s' => $stack2s, 'invoices' => $invoice, 'company' => $company, 'branches' => $branches, 'title' => 'Company Detail']);
 }

 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function edit(Request $request)
 {
     $branch = Branch::find($request['branchId']);
     $branch->name = $request['branchName'];
     $branch->location = $request['branchLocation'];
     $branch->delivery_charge = $request['delivery_charge'];
     if ($branch->save()) {
         $returnData = array('status' => 'ok', 'message' => 'Branch edited', 'branch' => $branch, 'code' => 200);
         return Response::json($returnData, 200);
     } else {
         $returnData = array('status' => 'fail', 'message' => 'Branch not edited', 'code' => 500);
         return Response::json($returnData, 200);
     }
 }

 /**
  * Execute the console command.
  *
  * @return mixed
  */
 public function handle()
 {
     // Define first day of current month.
     $date = date('Y-m') . '-01';
     // Get all the branches.
     $branches = Branch::all();
     foreach ($branches as $branch) {
         // Try to get expense.
         $expense = Expense::where('BranchId', '=', $branch->Id)->where('Date', '=', $date)->first();
         if (!$expense) {
             $default = json_decode($branch->DefaultExpenses);
             if ($default->regimen == 'cuotafija') {
                 Expense::create(array('Date' => $date, 'BranchId' => $branch->Id, 'Electricity' => $default->electricity, 'Water' => $default->water, 'Telecommunications' => $default->phone, 'Rent' => $default->rent, 'Depreciation' => $default->depreciation, 'Security' => $default->security, 'Government' => $default->government, 'Taxes' => $default->taxes, 'Regimen' => $default->regimen, 'TaxesSettled' => 1));
             } else {
                 Expense::create(array('Date' => $date, 'BranchId' => $branch->Id, 'Electricity' => $default->electricity, 'Water' => $default->water, 'Telecommunications' => $default->phone, 'Rent' => $default->rent, 'Depreciation' => $default->depreciation, 'Security' => $default->security, 'Government' => $default->government, 'Taxes' => $default->taxes, 'Regimen' => $default->regimen, 'TaxesSettled' => 0));
             }
         }
     }
 }

                                        <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>
                                            <td> <input type="button"  style="width:63px;" value="delete" class="btn red deleteSaleDetail" rel={{$saleDetail->id}} /></td>

@section('content')
    <div class="row">
        <div class="col-md-12">
            <!-- BEGIN PAGE TITLE & BREADCRUMB-->
            <h3 class="page-title">
             Sales Due Report
            </h3>

         </div>
    </div>

    <div class="row">

        <div class="col-md-12">
            <?php 
$branches = \App\Branch::find($branch_id);
?>
            <!-- BEGIN EXAMPLE TABLE PORTLET-->
            <div class="portlet box light-grey">
                <div class="portlet-title">
                    <div class="caption"><i class="fa fa-reorder"></i>Sales Due Report of Products for {{$branches->name}}</div>

                     <div class="actions">
                         <a class="btn btn-sm blue hidden-print" onclick="javascript:window.print();">Print <i class="fa fa-print"></i></a>
                       </div>

                </div>

                <div class="portlet-body">

                    <table class="table table-striped table-bordered table-hover" id="stock_products_report_table">

 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;
 }