PHP Member::select方法代码示例

 /**
  * Search the resource by providing a querystring
  *
  * @return Response
  */
 public function search(Request $request)
 {
     // ?discharged -- [ none | include | only ]
     $withDischarged = $request->query('discharged', 'none');
     if ($withDischarged == 'include') {
         $query = Member::withTrashed();
     } elseif ($withDischarged == 'only') {
         $query = Member::onlyTrashed();
     } else {
         $query = Member::select();
     }
     // join on 3p table
     $query->leftJoin('posting_promo', function ($join) {
         $join->on('members.regt_num', '=', 'posting_promo.regt_num');
     });
     $query->select('members.*', 'posting_promo.new_rank as rank');
     if ($request->has('keywords')) {
         $keywords = explode(' ', $request->query('keywords'));
         foreach ($keywords as $keyword) {
             // If keyword resembles a regt number_format
             if ($this->keywordLikeRegtNum($keyword)) {
                 $query->where('members.regt_num', 'like', "{$keyword}%");
                 continue;
             }
             // If keyword matches a known rank abbrev
             if ($this->keywordLikeRank($keyword)) {
                 $rank = $this->keywordExtractRank($keyword);
                 $query->where('rank', $rank);
                 continue;
             }
             // Otherwise add this as a name search
             $query->where(function ($query) use($keyword) {
                 $query->where('last_name', 'like', "%{$keyword}%")->orWhere('first_name', 'like', "%{$keyword}%");
             });
         }
     } else {
         foreach ($request->only('rank', 'last_name', 'first_name', 'regt_num') as $name => $input) {
             $input = trim($input);
             if (!empty($input)) {
                 $query->where($name, 'like', "{$input}%");
                 $query->orderBy($name, 'asc');
             }
         }
         foreach ($request->only('sex') as $name => $input) {
             // ('sex', 'is_active')
             $input = trim($input);
             if (!empty($input)) {
                 $query->where($name, $input);
             }
         }
     }
     // return var_dump($input);
     return response()->json(['members' => $query->get()]);
 }

 /**
  * Show the form for creating a new resource.
  *
  * @return Response
  */
 public function create(Request $request)
 {
     if (!$request['fromdate']) {
         Redirect::to('report');
         echo "string";
     }
     print_r($request->only('todate', 'fromdate'));
     die;
     if ($request['todate']) {
         $tdate = date("Y-m-d h:m:s", strtotime($request['todate']));
     } else {
         $tdate = date("Y-m-d h:m:s");
     }
     if ($request['fromdate']) {
         $fdate = date("Y-m-d h:m:s", strtotime($request['fromdate']));
     } else {
         $fdate = date("Y-m-d h:m:s");
     }
     if (Auth::user()->type == 1 && Auth::user()->loginas == 1) {
         $admin = count(Member::select('id')->where('type', 1)->whereBetween('created_at', [$fdate, $tdate])->get());
         $employer = count(Member::select('id')->where('type', 2)->whereBetween('created_at', [$fdate, $tdate])->get());
         $agent = count(Member::select('id')->where('type', 3)->whereBetween('created_at', [$fdate, $tdate])->get());
         $adminblock = count(Member::select('id')->whereTypeAndStatus(1, 0)->whereBetween('created_at', [$fdate, $tdate])->get());
         $employerblock = count(Member::select('id')->whereTypeAndStatus(2, 0)->whereBetween('created_at', [$fdate, $tdate])->get());
         $agentblock = count(Member::select('id')->whereTypeAndStatus(3, 0)->whereBetween('created_at', [$fdate, $tdate])->get());
         $resume = count(PersonalInformation::select('id')->whereBetween('created_at', [$fdate, $tdate])->get());
         $resumerequest = count(PersonalInformation::select('id')->where('approved_by', '!=', 0)->whereBetween('created_at', [$fdate, $tdate])->get());
         $resumeapproved = count(PersonalInformation::select('id')->where('approval_status', 1)->whereBetween('created_at', [$fdate, $tdate])->get());
         $demand = count(Demand::select('id')->whereBetween('created_at', [$fdate, $tdate])->get());
         return view('history.index')->with('admin', $admin)->with('employer', $employer)->with('agent', $agent)->with('adminblock', $adminblock)->with('employerblock', $employerblock)->with('agentblock', $agentblock)->with('resume', $resume)->with('resumerequest', $resumerequest)->with('resumeapproved', $resumeapproved)->with('demand', $demand);
     } else {
         if (Auth::user()->loginas == 2) {
             $resume = count(PersonalInformation::select('id')->whereBetween('created_at', [$fdate, $tdate])->get());
             $resumerequest = count(EmployerApproval::select('apid')->whereEmpid(Auth::user()->id)->whereBetween('created_at', [$fdate, $tdate])->get());
             $resumeapproved = count(PersonalInformation::select('id')->whereApproval_statusAndApproved_by(1, Auth::user()->id)->whereBetween('created_at', [$fdate, $tdate])->get());
             $demand = count(Demand::select('id')->whereEid(Auth::user()->id)->whereBetween('created_at', [$fdate, $tdate])->get());
             return view('history.index')->with('resume', $resume)->with('resumerequest', $resumerequest)->with('resumeapproved', $resumeapproved)->with('demand', $demand);
         } else {
             $resume = count(PersonalInformation::select('id')->where('agent_id', Auth::user()->id)->whereBetween('created_at', [$fdate, $tdate])->get());
             $resumerequest = count(PersonalInformation::select('id')->where('agent_id', Auth::user()->id)->where('approved_by', '!=', 0)->whereBetween('created_at', [$fdate, $tdate])->get());
             $resumeapproved = count(PersonalInformation::select('id')->where('agent_id', Auth::user()->id)->where('approval_status', 1)->whereBetween('created_at', [$fdate, $tdate])->get());
             $demand = count(Demand::select('id')->whereBetween('created_at', [$fdate, $tdate])->get());
             return view('history.index')->with('resume', $resume)->with('resumerequest', $resumerequest)->with('resumeapproved', $resumeapproved)->with('demand', $demand);
         }
     }
 }

 /**
  * Generate a regimental number
  *
  * @param  Array $opts
  * @return String
  */
 protected function generateStandardRegtNumber($opts = 0)
 {
     /* 
      * Regimental numbers take the following format
      * 206  prefix for all 
      * 115  (1st of 2015) if after 2010; 81 (first of 2008) if pre-2010
      * 00  denoting their order in the roll
      * [F] if female  -- this function doesn't take notice of those
      */
     // Extract the overrides
     if (is_array($opts)) {
         extract($opts);
     }
     $prefix = '206' . $thisCycle . $thisYear;
     // Lookup the index for this number
     $res = DB::table('ref_misc')->where('name', 'regtNumLast')->where('cond', $prefix)->first();
     if (sizeof($res) > 0) {
         $refDataRowId = $res->id;
         $lastIndex = intval($res->value);
         $nextIndex = $lastIndex + 1;
     } else {
         $nextIndex = 0;
     }
     // Check for no conflict - try a few
     $proposedRegtNum = $prefix . str_pad($nextIndex, 2, '0', STR_PAD_LEFT);
     $counterNoConflict = 0;
     while ($counterNoConflict < 10) {
         $res = Member::select()->whereIn('regt_num', [$proposedRegtNum, $proposedRegtNum . 'F'])->first();
         // $res = DB::table('members')->whereIn('regt_num', [$proposedRegtNum, $proposedRegtNum . 'F'])->first();
         if (sizeof($res) > 0) {
             // Is conflicted; try next index
             $counterNoConflict++;
             $proposedRegtNum = $prefix . str_pad(++$nextIndex, 2, '0', STR_PAD_LEFT);
             continue;
         }
         break;
     }
     if ($counterNoConflict >= 10) {
         // The no conflict attempts didn't work
         return false;
     }
     if (isset($refDataRowId)) {
         // Update the ref_misc table with this latest regtNumLast index
         $res = DB::table('ref_misc')->where('id', $refDataRowId)->update(['value' => $nextIndex]);
     } else {
         // Insert it cos it doesn't exist yet
         $res = DB::table('ref_misc')->insert(['name' => 'regtNumLast', 'value' => $nextIndex, 'cond' => $prefix]);
     }
     return $proposedRegtNum;
 }

 /**
  * Returns an array of all members' ids and full names
  * ('id' => 'full_name')
  *
  * @return array
  */
 private function membersFullNameList()
 {
     return Member::select(DB::raw("CONCAT(first_name, ' ', last_name) AS full_name, id"))->lists('full_name', 'id');
 }

 public function getAllMember()
 {
     $user = Member::select('id', 'fname', 'mname', 'lname')->where('status', '=', 1)->get();
     return $user;
 }

 public function verifyMember(Request $request)
 {
     $user = Login::where('remember_token', '=', $request->header('token'))->where('login_from', '=', $request->ip())->join('members', 'members.id', '=', 'logins.member_id')->where('logins.status', '=', '1')->first();
     if ($user->mtype != 1) {
         $returnData = array('status' => 'fail', 'mesage' => 'insufficient permision', 'code' => 403);
         return $returnData;
     }
     $data = $request->only('member_id');
     $member = Member::find($data['member_id']);
     $member->status = 1;
     //return $member ;
     if ($member->save()) {
         $new = Member::select('id', 'fname', 'mname', 'lname', 'mtype', 'username')->where('id', '=', $member->id)->first();
         $returnData = array('status' => 'ok', 'message' => 'member verified', 'code' => 200, 'member' => $new);
         return Response::json($returnData, 200);
     } else {
         $returnData = array('status' => 'fail', 'message' => 'member verified', 'code' => 500);
         return Response::json($returnData, 200);
     }
 }

 public function getUnverifiedMember()
 {
     $members = Member::select('id')->where('status', '=', '0')->get();
     return Response::json(array('members' => $members));
 }