public function get_users($id = null, $asJson = true)
{
$post = array();
$page = "";
$joinTables['user_roles'] = array('content' => 'users.role = user_roles.id');
$select = 'users.*, user_roles.role';
$items = $this->site_model->get_tbl('users', array(), array('users.id' => 'asc'), $joinTables, true, $select);
$json = array();
if (count($items) > 0) {
foreach ($items as $res) {
$json[$res->id] = array("title" => $res->fname . " " . $res->mname . " " . $res->lname . " " . $res->suffix, "subtitle" => $res->role, "caption" => sql2Date($res->reg_date), "inactive" => $res->inactive == 0 ? 'No' : 'Yes');
$ids[] = $res->id;
}
$images = $this->site_model->get_image(null, null, 'users', array('images.img_ref_id' => $ids));
foreach ($images as $res) {
if (isset($json[$res->img_ref_id])) {
$js = $json[$res->img_ref_id];
$js['image'] = $res->img_path;
$json[$res->img_ref_id] = $js;
}
}
}
if ($asJson) {
// echo json_encode($json);
echo json_encode(array('rows' => $json, 'page' => "", 'post' => $post));
} else {
return array('rows' => $json, 'page' => "", 'post' => $post);
// return $json;
}
}
public function __construct()
{
parent::__construct();
if ($this->input->post('change_db')) {
$this->change_db($this->input->post('change_db'));
}
$date = null;
if ($this->input->post('daterange')) {
$date = $this->input->post('daterange');
} else {
if ($this->input->post('date')) {
$date = $this->input->post('date');
} else {
if ($this->input->post('month')) {
$today = sql2Date(phpNow());
$year = date('Y', strtotime($today));
$date = $year . "-" . $this->input->post('month') . "-01";
}
}
}
if ($date != null) {
$dates = explode(" to ", $date);
$used = $dates[0];
$today = sql2Date(phpNow());
if (strtotime($used) < strtotime($today)) {
$this->change_db('main');
}
} else {
if ($this->input->post('change_db')) {
$this->change_db('main');
}
}
}
