<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class UserModel extends CI_Model{
    public function getUserProfile($id_user){
      $this->db->select('*, (SELECT COUNT(*) FROM families where id_user='.$id_user.' OR id_user_family='.$id_user.') as family_count, (SELECT COUNT(*) FROM histories where id_user='.$id_user.') as history_count');
      $this->db->where('id_user',$id_user);
      $names = $this->db->get('user')->result();
      if($names){
        foreach($names as $name){
          $data = array(
            'id_user'     => (int)$name->id_user,
            'name'        => $name->name,
            'email'       => $name->email,
            'telephone'   => $name->telephone,
            'age'         => (int)$name->age,
            'family_count' => $name->family_count,
            'history_count' => $name->history_count,
            'emergency_contact' => $name->emergency_contact
          );
        }
        $response['message'] = 'Get Data Success';
        $response['error'] = false;
        $response['user'] = $data;
      }else{
        $response['message'] = 'Get Data Failed';
        $response['error'] = true;
      }
      return $response;
    }
}