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;
 }
Example #2
0
?>
">
				</td>
			</tr>
			<tr>
				<td bgcolor="#FFFFFF" width="30%" valign="center" align="right">
					Usuário:&nbsp;
				</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>
Example #3
0
 public static function Load($login)
 {
     return User::Select($login);
 }