PHP Students::find方法代码示例

 /**
  * Searches for students
  */
 public function searchAction()
 {
     $query = Criteria::fromInput($this->di, "Students", array_merge($_GET, $_POST));
     $this->persistent->parameters = $query->getParams();
     $parameters = $this->persistent->parameters;
     if (!is_array($parameters)) {
         $parameters = array();
     }
     $students = \Students::find($parameters)->toArray(true);
     $this->view->disable();
     $this->response->setContentType('application/json', 'UTF-8');
     echo json_encode(array("student" => $students));
 }

 static function updateStudent($inputs)
 {
     $student = Students::find($inputs['studentId']);
     $student->student_name = $inputs['studentName'];
     $student->student_gender = $inputs['studentGender'];
     $student->student_date_of_birth = date('Y-m-d', strtotime($inputs['studentDob']));
     $student->nickname = $inputs['nickname'];
     $student->school = $inputs['school'];
     $student->location = $inputs['location'];
     $student->hobbies = $inputs['hobbies'];
     $student->emergency_contact = $inputs['emergencyContact'];
     $student->remarks = $inputs['remarks'];
     $student->health_issue = $inputs['healthIssue'];
     $student->updated_by = Session::get('userId');
     $student->updated_at = date("Y-m-d H:i:s");
     $student->save();
     return $student;
 }

 public function indexAction()
 {
     $this->view->title = $this->trans->_("students");
     $request = new Request();
     $students = \Students::find();
     $search = trim($request->get("search"));
     $pageCount = $request->get("page-count") ? $request->get("page-count") : $this->session->get("page-count");
     if ($pageCount) {
         $this->session->set("page-count", $pageCount);
     }
     $orderColumn = trim($request->get("order-column")) . " " . trim($request->get("order-type"));
     $paginator = new \Phalcon\Paginator\Adapter\Model(array("data" => \Students::find(array("order" => trim($orderColumn) ? $orderColumn : "id ASC", "conditions" => "id LIKE ?1 ", "bind" => array(1 => "%" . $search . "%"))), "limit" => $pageCount ? $pageCount : 30, "page" => $request->get("page")));
     $page = $paginator->getPaginate();
     $this->view->page = $page;
     //$this->view->users=$students->;
     $this->view->countItems = count($page->items);
     $this->view->search = $search;
     $this->view->orderColumn = $request->get("order-column");
     $this->view->orderType = $request->get("order-type");
     $this->view->pageCount = $pageCount;
 }

 function getScaledSkillScore($studentId, $skillId, $debug = false)
 {
     // Special case for persistence, which has two parts that need to be scaled independently
     if ($skillId == "persistence") {
         // Scale the two parts indpendently, and weight them equally
         return ($this->getScaledSkillScore($studentId, "persistence_attempts", $debug) + $this->getScaledSkillScore($studentId, "persistence_watched", $debug)) / 2;
     }
     $scoreResults = Students::find(["columns" => "{$skillId}"]);
     $studentId = str_replace("'", "", $studentId);
     $rawScores = array_column($scoreResults->toArray(), "{$skillId}");
     $rawScore = Students::findFirst("email = '{$studentId}'")->{$skillId};
     $scaledScore = StatsHelper::calculateScaledScore($rawScores, $rawScore);
     if ($debug) {
         echo "All scores for skill {$skillId}: \n";
         foreach ($rawScores as $s) {
             echo "{$s}\n";
         }
         echo "Raw {$skillId} score for student {$studentId} is {$rawScore}, and scaled score is {$scaledScore}\n";
     }
     return round($scaledScore * 100) / 10;
 }

 public function UpdateRetentionFollowup()
 {
     $inputs = Input::all();
     $retention_data_make_reminder_null = Comments::where('retention_id', '=', $inputs['retention_id'])->update(array('reminder_date' => Null));
     $retention_data = Comments::where('retention_id', '=', $inputs['retention_id'])->orderBy('id', 'DESC')->first();
     $student_data = Students::find($retention_data['student_id']);
     if ($inputs['followup_status'] == 'ACTIVE/SCHEDULED') {
         $commentText = "Active call  " . 'on  ' . date('Y-m-d', strtotime($inputs['rDate'])) . ' ' . $inputs['customer_text_area'];
     } elseif ($inputs['followup_status'] == 'REMINDER_CALL') {
         $commentText = "Reminder call  " . 'on  ' . date('Y-m-d', strtotime($inputs['rDate'])) . ' ' . $inputs['customer_text_area'];
     } elseif ($inputs['followup_status'] == 'FOLLOW_CALL') {
         $commentText = "Follow call  " . 'on  ' . date('Y-m-d', strtotime($inputs['rDate'])) . ' ' . $inputs['customer_text_area'];
     } elseif ($inputs['followup_status'] == 'CALL_SPOUSE') {
         $commentText = "Call Spouse " . 'on  ' . date('Y-m-d', strtotime($inputs['rDate'])) . ' ' . $inputs['customer_text_area'];
     } elseif ($inputs['followup_status'] == 'NOT_AVAILABLE') {
         $commentText = "Not Available  " . 'on  ' . date('Y-m-d') . ' ' . $inputs['customer_text_area'];
     } elseif ($inputs['followup_status'] == 'CLOSE_CALL') {
         $commentText = "Followupcall closed on " . date('Y-m-d') . ' ' . $inputs['customer_text_area'];
     }
     $commentsInput['customerId'] = $retention_data['customer_id'];
     $commentsInput['student_id'] = $retention_data['student_id'];
     $commentsInput['retention_id'] = $retention_data['retention_id'];
     $commentsInput['followupType'] = $retention_data['followup_type'];
     $commentsInput['commentStatus'] = $inputs['followup_status'];
     $commentsInput['commentType'] = $inputs['comment_type'];
     $commentsInput['commentText'] = $commentText;
     if ($inputs['followup_status'] != 'CLOSE_CALL') {
         if (isset($inputs['rDate'])) {
             $commentsInput['reminderDate'] = $inputs['rDate'];
         }
     }
     Comments::addComments($commentsInput);
     return Response::json(array('status' => 'success'));
 }

 public function details($id)
 {
     if (Auth::check()) {
         $currentPage = "CUSTOMERS_LIST";
         $mainMenu = "CUSTOMERS_MAIN";
         $inputs = Input::all();
         if (isset($inputs['customerName'])) {
             if (Customers::addCustomers($inputs)) {
                 Session::flash('msg', "Customer added successfully.");
             } else {
                 Session::flash('warning', "Customer, Course Could not be added at the moment.");
             }
         }
         $customer = Customers::getCustomersById($id);
         $students = Students::getStudentByCustomer($id);
         $comments = Comments::getCommentByCustomerId($id);
         $provinces = Provinces::getProvinces("IN");
         $kidsSelect = Students::getStudentsForSelectBox($id);
         $membershipTypes = MembershipTypes::getMembershipTypesForSelectBox();
         $birthdays = BirthdayParties::getBirthdaysByCustomer($id);
         //return $customer;
         //Membership
         if (isset($inputs['membershipTypesMembersDiv'])) {
             /* echo '<pre>';
             			print_r($inputs);
             			echo '</pre>';
             			exit(); */
             if ($inputs['membershipTypesMembersDiv'] != "") {
                 $membershipInput['customer_id'] = $id;
                 $membershipInput['membership_type_id'] = $inputs['membershipTypesMembersDiv'];
                 CustomerMembership::addMembership($membershipInput);
                 $order['customer_id'] = $id;
                 $order['payment_for'] = "membership";
                 $order['payment_dues_id'] = '';
                 $order['payment_mode'] = $inputs['paymentTypeRadio'];
                 $order['card_last_digit'] = $inputs['card4digits'];
                 $order['card_type'] = $inputs['cardType'];
                 $order['bank_name'] = $inputs['bankName'];
                 $order['cheque_number'] = $inputs['chequeNumber'];
                 $order['amount'] = $inputs['membershipPrice'];
                 $order['order_status'] = "completed";
                 Orders::createOrder($order);
             }
         }
         //$customerMembership = "";
         /* echo '<pre>';
         			print_r($customer);
         			echo '</pre>';
         			exit(); */
         $presentDate = Carbon::now();
         $membershipStartDate = Carbon::now();
         $membershipEndDate = Carbon::now();
         $customerMembershipId = '';
         if (isset($customer->CustomerMembership['0'])) {
             $select = count($customer->CustomerMembership) - 1;
             $membershipStartDate = $membershipStartDate->createFromFormat('Y-m-d', $customer->CustomerMembership[$select]->membership_start_date);
             $membershipEndDate = $membershipEndDate->createFromFormat('Y-m-d', $customer->CustomerMembership[$select]->membership_end_date);
             if ($membershipStartDate->lte($presentDate) && $membershipEndDate->gte($presentDate)) {
                 $customerMembershipId = $customer->CustomerMembership[$select]->membership_type_id;
             }
         }
         if (isset($customerMembershipId)) {
             $customerMembership = MembershipTypes::getMembershipTypeByID($customerMembershipId);
         }
         $membershipTypesAll = MembershipTypes::getMembershipTypes();
         $birthdaypaiddata = Orders::getBirthdayfulldata($id);
         for ($i = 0; $i < count($birthdaypaiddata); $i++) {
             $studentData = Students::getStudentById($birthdaypaiddata[$i]['student_id']);
             $birthdaypaiddata[$i]['student_name'] = $studentData[0]['student_name'];
             $birthdaypaiddata[$i]['student_date_of_birth'] = $studentData[0]['student_date_of_birth'];
             $birthdayData = BirthdayParties::getBirthdaybyId($birthdaypaiddata[$i]['birthday_id']);
             $birthdaypaiddata[$i]['birthday_party_date'] = $birthdayData[0]['birthday_party_date'];
             $birthdaypaiddata[$i]['tax_amount'] = $birthdaypaiddata[0]['tax_amount'];
             $user_data = User::getUsersByUserId($birthdaypaiddata[$i]['created_by']);
             $birthdaypaiddata[$i]['name'] = $user_data[0]['first_name'] . $user_data[0]['last_name'];
             $birthdaypaiddata[$i]['encrypted_id'] = Crypt::encrypt($birthdaypaiddata[$i]['id']);
         }
         $birthdayDuedata = PaymentDues::getPaymentpendingfulldata($id);
         for ($i = 0; $i < count($birthdayDuedata); $i++) {
             $studentData = Students::getStudentById($birthdayDuedata[$i]['student_id']);
             $birthdayDuedata[$i]['student_name'] = $studentData[0]['student_name'];
             $user_data = User::getUsersByUserId($birthdayDuedata[$i]['created_by']);
             $birthdayDuedata[$i]['name'] = $user_data[0]['first_name'] . $user_data[0]['last_name'];
             $birthdayData = BirthdayParties::getBirthdaybyId($birthdayDuedata[$i]['birthday_id']);
             $birthdayDuedata[$i]['birthday_party_date'] = $birthdayData[0]['birthday_party_date'];
         }
         //followup_data
         $iv_data = IntroVisit::where('customer_id', '=', $id)->get();
         for ($i = 0; $i < count($iv_data); $i++) {
             $comments_data = Comments::where('introvisit_id', '=', $iv_data[$i]['id'])->orderBy('id', 'DESC')->first();
             $iv_data[$i]['comment_data'] = $comments_data;
             $student = Students::find($iv_data[$i]['student_id']);
             $iv_data[$i]['student_name'] = $student['student_name'];
             $iv_data[$i]['iv_date'] = date("Y-m-d", strtotime($iv_data[$i]['iv_date']));
         }
         $birthday_data = BirthdayParties::where('customer_id', '=', $id)->get();
         for ($i = 0; $i < count($birthday_data); $i++) {
             $birthday_comments = Comments::where('birthday_id', '=', $birthday_data[$i]['id'])->orderBy('id', 'DESC')->first();
             $birthday_data[$i]['comment_data'] = $birthday_comments;
             $student_data = Students::find($birthday_data[$i]['student_id']);
//.........这里部分代码省略.........