PHP Country::find_all方法代碼示例

 function all()
 {
     $this->is_loggedin();
     $this->title = "Countries";
     $this->message = "BeBuntu Countries";
     $all_countries = new Country();
     pass_var('all_countries', $all_countries->find_all());
     pass_var('title', $this->title);
     pass_var('message', $this->message);
 }

 /**
  * load initail data for employee form needed during 
  * creating and editing employee
  * data 
  */
 public function getData()
 {
     global $database;
     $depts = Department::find_all();
     $role = Roles::find_all();
     $country = Country::find_all();
     $employee = Employee::find_all();
     $zone = Zone::find_by_sql("SELECT * FROM zone WHERE country_id=156");
     $startups = array("departs" => $depts, "country" => $country, "state" => $zone, "employee" => $employee, "role" => $role);
     return $startups;
 }

 /**
  * load initail data for employee form needed during 
  * creating and editing employee
  * data 
  */
 public function getData()
 {
     global $database;
     $depts = Department::find_all();
     $role = Roles::find_all();
     $country = Country::find_all();
     $vendors = Vendor::find_all();
     $zone = Zone::find_by_sql("SELECT * FROM zone");
     $startups = array("departs" => $depts, "country" => $country, "zone" => $zone, "vendors" => $vendors, "role" => $role);
     return $startups;
 }

 public function getData()
 {
     global $database;
     $depts = Department::find_all();
     $role = Roles::find_all();
     $country = Country::find_all();
     $vendors = Vendor::find_all();
     $countAcc = count(Cproduct::find_by_client($_SESSION["client_ident"]));
     $schedule = Cproduct::getNextSchedule($_SESSION["client_ident"]);
     $countTic = count(Ticket::find_by_client($_SESSION['client_ident']));
     $zone = Zone::find_by_sql("SELECT * FROM zone");
     $startups = array("departs" => $depts, "country" => $country, "zone" => $zone, "vendors" => $vendors, "role" => $role, "countProd" => $countAcc, "countTick" => $countTic, "Schel" => $schedule);
     return $startups;
 }

 public function getData()
 {
     global $database;
     $depts = Department::find_all();
     $role = Roles::find_all();
     $country = Country::find_all();
     $vendors = Vendor::find_all();
     $area = Area::find_all();
     $issues = Issue::find_all();
     $zone = Zone::find_by_sql("SELECT * FROM zone");
     $techEmp = Employee::find_by_sql("SELECT * FROM employee WHERE emp_dept='5'");
     $startups = array("departs" => $depts, "country" => $country, "zone" => $zone, "vendors" => $vendors, "role" => $role, "techemp" => $techEmp, "area" => $area, "issues" => $issues);
     return $startups;
 }

 function add()
 {
     $this->is_loggedin();
     $this->title = "Add new teams";
     $this->message = "Add a new team";
     if ($_POST['action'] == 'newteam') {
         if ($this->newteam($_POST)) {
             $this->message = "Team added.";
         }
     }
     $all_countries = new Country();
     pass_var('countries', $all_countries->find_all());
     pass_var('title', $this->title);
     pass_var('message', $this->message);
 }

 public function getData()
 {
     global $database;
     $depts = Department::find_all();
     $role = Roles::find_all();
     $country = Country::find_all();
     $vendors = Vendor::find_all();
     $countAcc = count(Cproduct::find_by_client($_SESSION["client_ident"]));
     $schedule = Cproduct::getNextSchedule($_SESSION["client_ident"]);
     $OnSchedule = Schedule::find_by_sql("SELECT * FROM schedule WHERE client_id='" . $_SESSION['client_ident'] . "' AND maint_type !='Activation'  AND (status='Open' OR status='In Progress') ORDER BY id DESC LIMIT 10");
     $OnScheduleAct = Schedule::find_by_sql("SELECT * FROM schedule WHERE client_id='" . $_SESSION['client_ident'] . "' AND maint_type='Activation' AND  (status='Open' OR status='In Progress') ORDER BY id DESC LIMIT 10");
     $countTicketOpen = count(Ticket::find_by_sql("SELECT * FROM support_ticket WHERE client_id ='" . $_SESSION['client_ident'] . "' AND status ='Open'"));
     $countTicketClose = count(Ticket::find_by_sql("SELECT * FROM support_ticket WHERE client_id ='" . $_SESSION['client_ident'] . "' AND status ='Closed'"));
     $countTicketPending = count(Ticket::find_by_sql("SELECT * FROM support_ticket WHERE client_id ='" . $_SESSION['client_ident'] . "' AND (status ='Admin Reply' OR status='Customer Reply')"));
     $countTic = count(Ticket::find_by_client($_SESSION['client_ident']));
     $countuser = count(Clientuser::find_by_client($_SESSION['client_ident']));
     $zone = Zone::find_by_sql("SELECT * FROM zone");
     $startups = array("cschedule" => $OnSchedule, "departs" => $depts, "country" => $country, "zone" => $zone, "vendors" => $vendors, "role" => $role, "countProd" => $countAcc, "countTick" => $countTic, "Schel" => $schedule, "SchelAct" => $OnScheduleAct, "CountPending" => $countTicketPending, "CountOpent" => $countTicketOpen, "CountClosed" => $countTicketClose, "CountUsers" => $countuser);
     return $startups;
 }

 /**
  * load initail data for support ticket form needed during 
  * creating and editing support ticket
  * data 
  */
 public function getData()
 {
     global $database;
     $depts = Department::find_all();
     $role = Roles::find_all();
     $country = Country::find_all();
     $vendors = Vendor::find_all();
     $myproducts = Cproduct::find_all();
     /**
      * issues may arise that when database
      * is cleared emp_dept may not be 5
      */
     $techEmployee = Employee::find_by_sql("SELECT * FROM employee WHERE emp_dept = 5");
     $zone = Zone::find_by_sql("SELECT * FROM zone");
     $startups = array("departs" => $depts, "country" => $country, "zone" => $zone, "vendors" => $vendors, "role" => $role, "myproducts" => $myproducts, "techstaff" => $techEmployee);
     return $startups;
 }

 /**
  * load initail data for support ticket form needed during 
  * creating and editing support ticket
  * data 
  */
 public function getData()
 {
     global $database;
     $depts = Department::find_all();
     $role = Roles::find_all();
     $country = Country::find_all();
     $vendors = Vendor::find_all();
     $myproducts = Cproduct::find_all();
     $lastSignoff = array_shift($database->fetch_assoc($database->db_query("SELECT MAX(id) as lastID, prod_id FROM sign_off_form ")));
     $lastWorkSheet = array_shift($database->fetch_assoc($database->db_query("SELECT MAX(id) as lastID, prod_id FROM work_sheet_form ")));
     /**
      * issues may arise that when database
      * is cleared emp_dept may not be 5
      */
     $clients = Client::find_all();
     // print_r($clients);
     $techEmployee = Employee::find_by_sql("SELECT * FROM employee WHERE emp_dept = 5");
     $zone = Zone::find_by_sql("SELECT * FROM zone");
     $startups = array("clients" => $clients, "departs" => $depts, "country" => $country, "zone" => $zone, "vendors" => $vendors, "role" => $role, "myproducts" => $myproducts, "techstaff" => $techEmployee, "lastsf" => $lastSignoff, "lastws" => $lastWorkSheet);
     return $startups;
 }

 /**
  * load initail data for employee form needed during 
  * creating and editing employee
  * data 
  */
 public function getData()
 {
     global $database;
     $depts = Department::find_all();
     $role = Roles::find_all();
     $country = Country::find_all();
     $vendors = Vendor::find_all();
     $products = Product::find_all();
     $myproducts = Cproduct::find_by_client($_SESSION['client_ident']);
     $zone = Zone::find_by_sql("SELECT * FROM zone");
     $issues = Issue::find_all();
     $startups = array("departs" => $depts, "country" => $country, "zone" => $zone, "vendors" => $vendors, "role" => $role, "myproducts" => $myproducts, "issues" => $issues, "products" => $products);
     return $startups;
 }

 public function edit($nickname = null)
 {
     $user = $this->load_user($nickname);
     $this->assign("permalink", $user->permalink());
     if ($this->post) {
         $user->nickname = $this->PostData('nickname');
         $user->email = $this->PostData('email');
         $user->clan = $this->PostData('clan');
         $user->firstname = $this->PostData('firstname');
         $user->surname = $this->PostData('surname');
         $user->address1 = $this->PostData('address1');
         $user->address2 = $this->PostData('address2');
         $user->towncity = $this->PostData('towncity');
         $user->county = $this->PostData('county');
         $user->country_id = $this->PostData('country_id');
         $user->postcode = $this->PostData('postcode');
         $user->phone = $this->PostData('phone');
         $user->set_dateofbirth($this->PostData('dateofbirth'));
         $user->terms = $this->PostData('terms');
         $user->allow_emails = $this->PostData('allow_emails');
         $user->suspended = $this->PostData('suspended');
         $user->activated = $this->PostData('activated');
         if ($user->save()) {
             Site::flash("notice", "User has been updated");
             Redirect("admin/users/" . $user->permalink());
         }
     }
     $countries = Utils::FormOptions(Country::find_all("", "countries.name ASC"));
     $this->assign('countries', $countries);
     $this->assign("user", $user);
     $this->title = "Edit User";
     $this->render("user/edit.tpl");
 }

 public function edit()
 {
     global $site;
     $user = Site::CurrentUser();
     $profile = $user->profile;
     if (isset($site['flash']['forceContactInfo']) && $site['flash']['forceContactInfo']) {
         Site::Flash('forceContactInfo', true);
         $user->requiresContactData = true;
     }
     $this->assign('requireContactData', $user->requiresContactData);
     if ($this->post and !$this->csrf) {
         $site['flash']['error'] = "Invalid form submission";
     } elseif ($this->post) {
         $user->clan = $this->PostData('clan');
         $user->address1 = $this->PostData('address1');
         $user->address2 = $this->PostData('address2');
         $user->towncity = $this->PostData('towncity');
         $user->county = $this->PostData('county');
         $user->country_id = $this->PostData('country_id');
         $user->postcode = $this->PostData('postcode');
         $user->phone = $this->PostData('phone');
         $user->allow_emails = $this->PostData('allow_emails');
         $profile->website = $this->PostData('website');
         $profile->windows_live = $this->PostData('windows_live');
         $profile->facebook = $this->PostData('facebook');
         $profile->twitter = $this->PostData('twitter');
         $profile->xfire = $this->PostData('xfire');
         $profile->xbox_live = $this->PostData('xbox_live');
         $profile->ps_network = $this->PostData('ps_network');
         $profile->occupation = $this->PostData('occupation');
         $profile->nationality = $this->PostData('nationality');
         $profile->gender = $this->PostData('gender');
         $profile->gaming_style = $this->PostData('gaming_style');
         $profile->hobbies_and_interests = $this->PostData('hobbies_and_interests');
         $profile->rig_manufacturer = $this->PostData('rig_manufacturer');
         $profile->rig_processor = $this->PostData('rig_processor');
         $profile->rig_memory = $this->PostData('rig_memory');
         $profile->rig_hdd = $this->PostData('rig_hdd');
         $profile->rig_gfx = $this->PostData('rig_gfx');
         $profile->rig_monitor = $this->PostData('rig_monitor');
         $profile->rig_sound_card = $this->PostData('rig_sound_card');
         $profile->rig_speaker_headphone = $this->PostData('rig_speaker_headphone');
         $profile->rig_keyboard = $this->PostData('rig_keyboard');
         $profile->rig_mouse = $this->PostData('rig_mouse');
         $profile->rig_mouse_surface = $this->PostData('rig_mouse_surface');
         $profile->rig_os = $this->PostData('rig_os');
         $profile->rig_mobo = $this->PostData('rig_mobo');
         $profile->rig_case = $this->PostData('rig_case');
         if ($user->save() && $profile->save()) {
             Site::flash("notice", "Your account has been updated");
             Redirect("account");
         }
     }
     $countries = Utils::FormOptions(Country::find_all("", "countries.name ASC"));
     $this->assign('countries', $countries);
     $this->assign("user", $user);
     $this->assign("profile", $profile);
     $this->assign("site", $site);
     $this->title = "My Account";
     $this->render("user/edit.tpl");
 }