public function buildMemberQuery() { $this->qry = User::Select("users.created_at", "users.first_name", "users.last_name", "users.email", "users.activated", "users.id"); $this->qry->Where('users.id', '<>', 0); //form the search query if ($this->getSrchVal('user_code')) { $this->qry->whereRaw("( users.user_code = ? OR users.user_id = ? )", array($this->getSrchVal('user_code'), $this->getSrchVal('user_code'))); } if ($this->getSrchVal('user_name')) { $name_arr = explode(" ", $this->getSrchVal('user_name')); if (count($name_arr) > 0) { $or_str = '('; foreach ($name_arr as $names) { if ($or_str != '(') { $or_str = $or_str . ' OR '; } $or_str = $or_str . ' (users.first_name LIKE \'%' . addslashes($names) . '%\' OR users.last_name LIKE \'%' . addslashes($names) . '%\' )'; } $or_str = $or_str . ' )'; $this->qry->whereRaw(\DB::raw($or_str)); } } if ($this->getSrchVal('user_email')) { $this->qry->Where('users.email', $this->getSrchVal('user_email')); } if ($this->getSrchVal('status')) { if ($this->getSrchVal('status') == 'ToActivate') { $this->qry->Where('users.activated', 0); } else { $this->qry->Where('users.user_status', $this->getSrchVal('status')); } } $this->qry->orderBy('users.created_at', 'desc'); return $this->qry; }
?> "> </td> </tr> <tr> <td bgcolor="#FFFFFF" width="30%" valign="center" align="right"> Usuário: </td> <td bgcolor="#FFFFFF" width="70%" valign="center" align="left"> <select name="p_sess_user_id"> <option value="">Selecione</option> <?php $user = new User(); $user->SetDatabase($database); $result = $user->Select(); while ($data = $database->FetchArray($result)) { $user_id = $data["user_id"]; $user_name = $date["user_username"]; if ($sess_user_id == $user_id) { echo "<option value=\"" . $user_id . "\" selected>" . $user_username . "</option>"; } else { echo "<option value=\"" . $user_id . "\">" . $user_username . "</option>"; } } ?> </select> </td> </tr> <tr>
public static function Load($login) { return User::Select($login); }