/** * Get a list of accounts * * @return static */ public function getList() { $accounts = $this->account->all(); $response = $accounts->map(function ($item) { return ["id" => $item->id, "name" => $item->name]; }); return $response; }
public function stores() { $accounts = Account::all(); $data = array(); foreach ($accounts as $account) { $customers = Customer::where('account_id', $account->id)->get(); $account_children = array(); foreach ($customers as $customer) { $areas = Area::where('customer_id', $customer->id)->get(); $customer_children = array(); foreach ($areas as $area) { $regions = Region::where('area_id', $area->id)->get(); $area_children = array(); foreach ($regions as $region) { $distributors = Distributor::where('region_id', $region->id)->get(); $region_children = array(); foreach ($distributors as $distributor) { $stores = Store::where('distributor_id', $distributor->id)->get(); $distributor_children = array(); foreach ($stores as $store) { $distributor_children[] = array('title' => $store->store, 'key' => $account->id . "." . $customer->id . "." . $area->id . "." . $region->id . "." . $distributor->id . "." . $store->id); } $region_children[] = array('select' => true, 'title' => $distributor->distributor, 'isFolder' => true, 'key' => $account->id . "." . $customer->id . "." . $area->id . "." . $region->id . "." . $distributor->id, 'children' => $distributor_children); } $area_children[] = array('select' => true, 'title' => $region->region, 'isFolder' => true, 'key' => $account->id . "." . $customer->id . "." . $area->id . "." . $region->id, 'children' => $region_children); } $customer_children[] = array('select' => true, 'title' => $area->area, 'isFolder' => true, 'key' => $account->id . "." . $customer->id . "." . $area->id, 'children' => $area_children); } $account_children[] = array('select' => true, 'title' => $customer->customer, 'isFolder' => true, 'key' => $account->id . "." . $customer->id, 'children' => $customer_children); } $data[] = array('title' => $account->account, 'isFolder' => true, 'key' => $account->id, 'children' => $account_children); } return response()->json($data); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { if (Gate::denies('account.read')) { return view(config('app.template') . '.error.403'); } $accounts = Account::all(); $data = ['accounts' => $accounts, 'states' => Account::$data_states, 'types' => Account::$types]; return view(config('app.template') . '.account.table', $data); }
public function retrieve() { $status = FALSE; DB::connection()->enableQueryLog(); try { $data['users'] = App\Account::all(); $status = TRUE; } catch (Exception $e) { Log::info($e->getMessage()); } Log::info(json_encode(DB::getQueryLog())); $data['status'] = $status; return $data; }
/** * Display a listing of the resource. * * @return Response */ public function index(Request $request) { $login = Login::where('remember_token', '=', $request->header('token'))->where('login_from', '=', $request->ip())->join('members', 'members.id', '=', 'logins.member_id')->where('logins.status', '=', '1')->first(); $stockTypes = StockType::all(); $limitOrders = LimitOrder::all(); if ($login->mtype == 1) { $stocks = Stock::orderBy('stockTypeId')->get(); if (count($stocks) > 0) { foreach ($stocks as $stock) { $clientStocks = ClientStock::where('stockId', '=', $stock->id)->where('status', '=', 0)->get(); $stock->request = $clientStocks; //$stockProducts = AddProduct::sum('quantity')->where('stockId',$stock->id); $stock->quantity = AddProduct::where('stockId', $stock->id)->sum('quantity'); $data[] = $stock; } } else { $data = $stocks; } $clientStocks = ClientStock::all(); $clientAccounts = Account::all(); } else { $stocks = Stock::orderBy('stockTypeId')->where('stockTypeId', 3)->get(); if (count($stocks) > 0) { foreach ($stocks as $stock) { $stock->quantity = AddProduct::where('stockId', $stock->id)->sum('quantity'); $data[] = $stock; } } else { $data = $stocks; } $clientStocks = ClientStock::where('memberId', $login->member_id)->get(); $clientAccounts = Account::where('memberId', $login->member_id)->get(); } $returnData = array('status' => 'ok', 'stocks' => $data, 'stockTypes' => $stockTypes, 'clientStocks' => $clientStocks, 'limitOrders' => $limitOrders, 'clientAccounts' => $clientAccounts, 'code' => 200); return $returnData; }
/** * * Description: Get All Accounts * Component: InvestMain * */ public function getAllAccounts() { $accounts = Account::all(); return $accounts; }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $accounts = Account::all(); return view('user.index', compact('accounts')); }
public function getIndex() { $cuentas = DB::table('accounts')->join('transactions', 'accounts.id', '=', 'transactions.account_id')->join('nomenclators', 'transactions.nomenclator_id', '=', 'nomenclators.id')->select('accounts.id', 'montoDebe', 'montoHaber', 'glosa', 'accounts.created_at', 'tipo', 'nomenclator_id', 'monto', 'cuenta')->get(); $folios = Account::all(); return view('layouts.main', compact('cuentas', 'leng', 'folios')); }
public function searchAllAccount() { return response()->json(Account::all()); }
public function accounts() { $accs = Account::all(); $title = "ACCOUNTS"; return \PDF::loadHTML(view('reports.account_template', compact('accs', 'title')))->stream('report.pdf'); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $accounts = Account::all(); return $accounts; }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $accs = Account::all(); return view('admin.account.index', compact('accs')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { return Account::all(); }