[PHP] pobierz, plaintext 
public function get_user_list(){
    $get_user =
    $this->db->SELECT('user.login_email, user.first_name, user.last_name, projects.project_name, department.department_name, user_group.user_group_name, is_active.active_name')
    ->FROM('user_projects')
    ->JOIN('user', 'id_user = user_id')
    ->JOIN('projects', 'id_project = projects_id')
    ->JOIN('department', 'id_department = department_id')
    ->JOIN('user_group', 'id_user_group = user_group_id')
    ->JOIN('is_active', 'id_is_active = is_active_id')
    ->get()->result();
    return $get_user;
  }
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<div class="uk-container uk-container-center admin-content-wrapper user_list_wrapper">
  <section class="uk-grid">
  <div class="uk-width-1-1">
    <a class="uk-button uk-button-default" href="<?=base_url()?>administrator">Back</a>
    <a class="uk-button uk-button-default" href="<?=base_url()?>administrator/main/add_user">Add a User</a>
 
 
    <?php
foreach($user_list as $key => $value){?>
    <ul uk-accordion>
    <li>
        <a class="uk-accordion-title" href="#"><?=$value->project_name;?></a>
 
  <?php //foreach($user_list AS $list){?>
<div class="uk-accordion-content">
 
          <table>
            <tr>
              <th>First Name</th>
              <th>Last Name</th>
              <th>Login</th>
              <th>Department</th>
              <th>User Group</th>
              <th>Is Active</th>
              <th>Operations</th>
            </tr>
          <tr>
          <td><?=$value->first_name;?></td>
          <td><?=$value->last_name;?></td>
          <td><?=$value->login_email;?></td>
          <td><?=$value->department_name;?></td>
          <td><?=$value->user_group_name;?></td>
          <td><?=$value->active_name;?></td>
          <td><a class ="uk-button uk-button-default" href="<?=base_url()?>">Details</a></td>
        </tr>
          </table>
        </div>
      <?php break; ?>
    </li>
 
</ul>
<?php }?>
  </div>
</section>
</div>
[PHP] pobierz, plaintext