PHP UserProfile::where方法代码示例

 public function getProfile($user_id)
 {
     $userProfile = UserProfile::where('id', '=', $user_id)->first();
     $userid = $userProfile->id;
     $userfname = $userProfile->fname;
     $userlname = $userProfile->lname;
     $userstreetno = $userProfile->streetno;
     $userstreet = $userProfile->street;
     $usersuburb = $userProfile->suburb;
     $userstate = $userProfile->state;
     $userpostcode = $userProfile->postcode;
     $userdobday = $userProfile->day_dob;
     $userdobmonth = $userProfile->month_dob;
     $userdobyear = $userProfile->year_dob;
     $userphone = $userProfile->phone;
     $usertfn = $userProfile->tfn;
     $userpidtype = $userProfile->pidtype;
     $userpidnum = $userProfile->pidnum;
     $usersidtype = $userProfile->sidtype;
     $usersidnum = $userProfile->sidnum;
     $userdes = $userProfile->description;
     $usergender = $userProfile->gender;
     $useroccupation = $userProfile->occupation;
     $data = array('userid' => $userid, 'userfname' => $userfname, 'userlname' => $userlname, 'userstreetno' => $userstreetno, 'userstreet' => $userstreet, 'usersuburb' => $usersuburb, 'userstate' => $userstate, 'userpostcode' => $userpostcode, 'day_dob' => $userdobday, 'month_dob' => $userdobmonth, 'year_dob' => $userdobyear, 'userphone' => $userphone, 'usertfn' => $usertfn, 'userpidtype' => $userpidtype, 'userpidnum' => $userpidnum, 'usersidtype' => $usersidtype, 'usersidnum' => $usersidnum, 'userdes' => $userdes, 'usergender' => $usergender, 'useroccupation' => $useroccupation);
     return $data;
 }

 public function editProfile()
 {
     $id = Auth::user()->id;
     $usermail = Auth::user()->email;
     $userProfile = UserProfile::where('id', '=', $id)->first();
     if ($userProfile == null) {
         // if user has not add it profile.
         return View::make('editprofiles')->with('usermail', $usermail);
     }
     $userfname = $userProfile->fname;
     $userlname = $userProfile->lname;
     $userstreetno = $userProfile->streetno;
     $userstreet = $userProfile->street;
     $usersuburb = $userProfile->suburb;
     $userstate = $userProfile->state;
     $userpostcode = $userProfile->postcode;
     $userdob = $userProfile->dob;
     $userphone = $userProfile->phone;
     $usertfn = $userProfile->tfn;
     $userpidtype = $userProfile->pidtype;
     $userpidnum = $userProfile->pidnum;
     $usersidtype = $userProfile->sidtype;
     $usersidnum = $userProfile->sidnum;
     $userdes = $userProfile->description;
     $data = array('usermail' => $usermail, 'userfname' => $userfname, 'userlname' => $userlname, 'userstreetno' => $userstreetno, 'userstreet' => $userstreet, 'usersuburb' => $usersuburb, 'userstate' => $userstate, 'userpostcode' => $userpostcode, 'userdob' => $userdob, 'userphone' => $userphone, 'usertfn' => $usertfn, 'userpidtype' => $userpidtype, 'userpidnum' => $userpidnum, 'usersidtype' => $usersidtype, 'usersidnum' => $usersidnum, 'userdes' => $userdes, 'usergender' => $userProfile->gender, 'useroccuptaion' => $userProfile->occupation);
     return View::make('editprofiles', array('data' => $data));
 }

 public function saveLendPref()
 {
     $id = Auth::user()->id;
     $loanApp = LoanApp::where('user_id', '=', $id)->get();
     $profile = UserProfile::where('id', '=', $id)->first();
     $financial = FinancialProfile::where('user_id', $id)->first();
     $lender_prefers = LenderPref::firstOrNew(array('user_id' => $id));
     $lender_prefers->min_amount = Input::get('minLoan');
     $lender_prefers->min_term = Input::get('minTerm');
     $lender_prefers->min_rate = Input::get('minRate');
     $lender_prefers->max_amount = Input::get('maxLoan');
     $lender_prefers->max_term = Input::get('maxTerm');
     $lender_prefers->max_rate = Input::get('maxRate');
     $lender_prefers->save();
     $results = $this->search();
     $pdata = $profile->getProfile($id);
     // method defined in its model
     $fdata = $financial->getFinancialProfile($id);
     // methd defined in its model
     $bids = DB::table('bids')->join('loan_app', 'bids.loan_id', '=', 'loan_app.loan_id')->join('profile', 'profile.id', '=', 'loan_app.user_id')->select('bid_amount', 'pref_rate', 'term', 'purpose', 'fname', 'lname')->orderBy('bid_date', 'DESC')->get();
     return View::make('myprofiles', compact('bids', 'pdata', 'fdata', 'results', 'loanApp'));
     /*	return Redirect::route('myprofile');   */
 }

 public function previewContract($loan_id)
 {
     //  Is what I did last night?  I hope so, else I'm lost.
     $id = Auth::user()->id;
     $usermail = Auth::user()->email;
     $profile = UserProfile::where('id', '=', $id)->first();
     // Retreive from the DB details about loan, where loanid = input for function and user_id = id of person logged in.
     // This should return object.
     $loan = DB::table('loan_app')->select('amount', 'term', 'pref_rate', 'purpose', 'progress', 'loan_id', 'match_date')->where('user_id', '=', $id)->where('loan_id', '=', $loan_id)->orderBy('match_date', 'DESC')->first();
     // Run the getLenders function and store the returned value as $lenders.
     $lenders = $this->getLenders($loan_id);
     // If there is no value for lenders...
     if (empty($lenders)) {
         // fail and redirect somewhere else
         return Redirect::route('mytransaction')->with('message', 'Could not find lenders for this loan request');
     }
     $contract = Contract::firstOrNew(array('offer_id' => Input::get('offer_id', $loan_id)));
     if (!$contract->getAttribute('offer_id')) {
         return Redirect::to('mytransaction')->with('message', 'No dice!');
     }
     $success = null;
     $errors = array();
     if (Request::isMethod('post')) {
         // update contract record with new status
         if (Input::get('i_agree') !== null) {
             $contract->setAttribute('status', 'complete');
             if ($contract->save()) {
                 $success = 'Your contract was finalised';
             } else {
                 $errors[] = 'Your contract was not finalised';
             }
         }
     }
     $backurl = route('createContract', array($loan_id));
     return View::make('previewContract', compact('loan', 'profile', 'success', 'errors', 'contract', 'lenders', 'backurl'));
 }

 public function logHwork()
 {
     $id = Auth::user()->id;
     $usermail = Auth::user()->email;
     // $photos = Auth::user()->photos()->get();
     $profile = UserProfile::where('id', '=', $id)->first();
     $financial = FinancialProfile::where('user_id', $id)->first();
     // think about cacahe below two queries
     $pdata = $profile->getProfile($id);
     //  method defiend in its model
     return View::make('logHworks', compact('id', 'bids', 'pdata', 'fdata', 'loanApp', 'allLoan', 'age', 'comments'));
 }