PHP Company::all方法代碼示例

 /**
  * Store a newly created resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @return \Illuminate\Http\Response
  */
 public function store(Request $request)
 {
     //
     $validator = Validator::make($request->all(), ['name' => 'required|unique:papers', 'size' => 'required|unique:papers']);
     if ($validator->fails()) {
         if ($request->ajax()) {
             return response()->json($validator->messages());
             exit;
         } else {
             return \Redirect::back()->withErrors($validator)->withInput();
         }
     }
     array_forget($request, "_token");
     $all_request = $request->all();
     $paper = new Paper();
     foreach ($all_request as $key => $value) {
         $paper->{$key} = $value;
     }
     $paper->save();
     $papers = Paper::all();
     if ($request->ajax()) {
         if ($papers) {
             foreach ($papers as $paper) {
                 echo "\n                        <tr>\n                            <td>{$paper->id}</td>\n                            <td>{$paper->name}</td>\n                            <td>{$paper->description}</td>\n                            <td>{$paper->dimension}</td>\n                            <td>{$paper->unit}</td>\n\n                            <td><button class='edtPaperLink btn-primary' cid='{$paper->id}' cname='{$paper->name}' cdescription='{$paper->description}' cdimension='{$paper->dimension}' cunit='{$paper->unit}'><span  class='glyphicon glyphicon-pencil'></span></button></td>\n                            <td><button class='btn-danger'  data-target='#myModalPaperEdit' data-toggle='modal'><span  class='glyphicon glyphicon-trash'></span></button></td>\n                        </tr>\n                        ";
             }
         }
         exit;
     }
     return View("settings.paper", ["companies" => Company::all(), 'papers' => $papers, 'title' => 'Job Papers Setting']);
 }

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     $dataView = array();
     $dataView['page_title'] = "Compañías";
     $dataView['companies'] = Company::all();
     return view('company.index', $dataView);
 }

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     //
     $companies = Company::all();
     $accountancies = Accountancy::all();
     return view('admin.accountancy.index')->with(['companies' => $companies, 'accountancies' => $accountancies]);
 }

 public function edit($id)
 {
     $userName = Auth::user()->name;
     $companies = Company::all();
     $campain = Campain::find($id);
     return view('campain.edit', ['userName' => $userName, 'companies' => $companies, 'campain' => $campain]);
 }

 public function showSettings()
 {
     $companies = \App\Company::all()->lists('name', 'id');
     $current_company = \App\Company::find(Auth::user()->current_company);
     //        dd($current_company);
     return view('settings.settings', compact('companies', 'current_company'));
 }

 public function index()
 {
     $data['is_showzhiye'] = Zhiye::where('z_show', '=', '1')->get();
     $data['allzhiye'] = Zhiye::all();
     $data['is_showcompany'] = Company::where('c_show', '=', '1')->get();
     $data['allcompany'] = Company::all();
     $data['alltime'] = Time::all();
     return view('contestRoom.index', $data);
 }

 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index()
 {
     if (Auth::user()->hasRole('member')) {
         $companies = Company::where('comUserId', '=', Auth::user()->id)->get();
     } else {
         $companies = Company::all()->sortBy('comName');
     }
     return view('company.index', compact('companies'));
 }

 function index()
 {
     $user = Auth::user();
     $posts = Post::latest('id')->get();
     $companies = Company::all();
     $users = User::all();
     $testvar = "XYZABC";
     return view('users.test', compact('testvar'));
     return view('users.index', compact('user', 'posts', 'companies', 'users'));
 }

 /**
  * Show the form for creating a new resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function create()
 {
     $query = Company::all('id', 'name')->toArray();
     // TODO: Rework this to be more efficient. Could probably be done in a
     // shorter way.
     $companies = [];
     foreach ($query as $row) {
         $companies[$row['id']] = $row['name'];
     }
     return view('expenses/create')->with('companies', $companies);
 }

 public function run()
 {
     $contacts = \App\Contact::all();
     $companies = \App\Company::all();
     for ($i = 0; $i < 20; $i++) {
         try {
             $contacts->random()->companies()->attach($companies->random());
         } catch (\Exception $e) {
         }
     }
 }

 /**
  * Show the form for creating a new resource.
  *
  * @return Response
  */
 public function create()
 {
     $products = Product::all();
     $weeknrs = getWeeknumbers();
     if (Auth::user()->hasRole('member')) {
         $companies = Company::where('comUserId', '=', Auth::user()->id)->get();
     } else {
         $companies = Company::all();
     }
     $providers = Provider::all();
     return view('allocatie.create', compact('products', 'companies', 'weeknrs', 'providers'));
 }

 public function companies()
 {
     $userName = Auth::user()->name;
     $companies = Company::all();
     $results = [];
     foreach ($companies as $company) {
         $company_id = $company->id;
         $campains = DB::table('campains')->where('company_id', '=', $company_id)->get();
         $totalGain = 0;
         $totalInvestment = 1;
         foreach ($campains as $campain) {
             $totalGain = $totalGain + $campain->gain;
             $totalInvestment = $totalInvestment + $campain->cost;
         }
         $roi = ($totalGain - $totalInvestment) / $totalInvestment;
         $roi = number_format($roi, 2);
         $results[] = ["name" => $company->name, "roi" => $roi];
     }
     return view('report.companies', ['userName' => $userName, 'results' => $results]);
 }

 public function months($months)
 {
     Excel::create('通訊報銷匯總_' . $months, function ($excel) use($months) {
         $companies = Company::all();
         foreach ($companies as $company) {
             $excel->sheet('new Sheet', function ($sheet) use($company, $months) {
                 $sheet->setAllBorders('thin');
                 // Set border for cells
                 $sheet->setBorder('A1', 'thin');
                 // Font family
                 $sheet->setFontFamily('Comic Sans MS');
                 // Set font with ->setStyle()`
                 $sheet->setStyle(array('font' => array('name' => 'Calibri', 'size' => 11, 'bold' => false)));
                 $sum = \App\MobileFees::where('company_id', $company->id)->where('months', $months)->with('company', 'employee')->sum('fee');
                 $mobilefees = \App\MobileFees::where('company_id', $company->id)->where('months', $months)->with('company', 'employee')->get();
                 $sheet->loadView('report.index')->with('mobilefees', $mobilefees)->with('sum', $sum)->with('company_name', $company->name);
             });
         }
     })->download('xls');
 }

 /**
  * create exhibitor by admin
  * 
  * @return Response
  */
 public function createexhibitorbyadmin()
 {
     $countries = Country::all();
     $companies = Company::all();
     return view('AdminCP.exhibitors.create', compact('countries', 'companies'));
 }

 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function edit($id)
 {
     //
     return View("administrators.edituser", ["companies" => Company::all(), "myuser" => User::find($id), "myrole" => \DB::table("role_user")->where("user_id", $id)->get(), "roles" => \DB::table("roles")->get(), "title" => "Edit User"]);
 }