PHP User_Model::get_by_id方法代码示例

 function staff($id, $display = 'week')
 {
     $um = new User_Model();
     $um->get_by_id($id);
     if (!$um->exists()) {
         return;
     }
     $this->data['object'] = $um;
     $um->shift->where('status', SHIFT_MODEL::STATUS_ACTIVE);
     /* find min and max date */
     $max_date = $um->shift->select_max('date')->get()->date;
     $min_date = $um->shift->select_min('date')->get()->date;
     $shifts = $um->shift->get_iterated();
     /* compile dates */
     $dates = array();
     $date = $min_date;
     $this->hc_time->setDateDb($date);
     switch ($display) {
         case 'week':
             $this->hc_time->setStartWeek();
             break;
         case 'month':
             $this->hc_time->setStartMonth();
             break;
     }
     $date = $this->hc_time->formatDate_Db();
     while ($date <= $max_date) {
         switch ($display) {
             case 'week':
                 $start = $this->hc_time->formatDate_Db();
                 $this->hc_time->setEndWeek();
                 $end = $this->hc_time->formatDate_Db();
                 break;
             case 'month':
                 $start = $this->hc_time->formatDate_Db();
                 $this->hc_time->setEndMonth();
                 $end = $this->hc_time->formatDate_Db();
                 break;
         }
         $dates[$start . '-' . $end] = array('shift_count' => 0, 'shift_duration' => 0, 'timeoff_count' => 0, 'timeoff_duration' => 0);
         $this->hc_time->modify('+1 day');
         $date = $this->hc_time->formatDate_Db();
     }
     foreach ($shifts as $sh) {
         reset($dates);
         foreach (array_keys($dates) as $dk) {
             list($start, $end) = explode('-', $dk);
             if ($sh->date >= $start && $sh->date <= $end) {
                 $dates[$dk]['shift_count']++;
                 $dates[$dk]['shift_duration'] += $sh->get_duration();
             }
         }
     }
     $this->data['dates'] = $dates;
     $this->data['display'] = $display;
     //		$this->conf['path'] = 'admin/users';
     $this->set_include('edit/stats', 'admin/users');
     $this->load->view($this->template, $this->data);
 }

 public function up()
 {
     /* remove trades table and set the trade column for shifts for pending trades */
     if (!$this->db->field_exists('has_trade', 'shifts')) {
         $this->dbforge->add_column('shifts', array('has_trade' => array('type' => 'TINYINT', 'null' => FALSE, 'default' => 0)));
     }
     if ($this->db->table_exists('trades')) {
         // TRADE_MODEL:STATUS_PENDING - set the trade column
         $this->db->where('status', 1);
         $this->db->select('shift_id');
         $query = $this->db->get('trades');
         foreach ($query->result_array() as $row) {
             $sm = new Shift_Model();
             $sm->get_by_id($row['shift_id']);
             $sm->has_trade = 1;
             $sm->save();
         }
         // TRADE_MODEL:STATUS_APPROVED - remove current user
         $this->db->where('status', 2);
         $this->db->select('shift_id');
         $query = $this->db->get('trades');
         foreach ($query->result_array() as $row) {
             $sm = new Shift_Model();
             $sm->get_by_id($row['shift_id']);
             $sm->user->get();
             $sm->delete($sm->user, 'user');
             $sm->save();
         }
         // TRADE_MODEL:STATUS_ACCEPTED - switch the shift to the new user
         $this->db->where('status', 3);
         $this->db->select(array('shift_id', 'to_user_id'));
         $query = $this->db->get('trades');
         foreach ($query->result_array() as $row) {
             $sm = new Shift_Model();
             $sm->get_by_id($row['shift_id']);
             $um = new User_Model();
             $um->get_by_id($row['to_user_id']);
             $sm->save(array('user' => $um));
         }
         // TRADE_MODEL:STATUS_DENIED - DO NOTHING
         //			$this->db->where('status', 4);
         // TRADE_MODEL:STATUS_COMPLETED - DO NOTHING
         //			$this->db->where('status', 5);
     }
     /* now delete the trades table */
     if ($this->db->table_exists('trades')) {
         $this->dbforge->drop_table('trades');
     }
 }

 function index($user_id = 0)
 {
     /* load */
     $this->{$this->model}->include_related('user', 'email')->include_related('user', 'first_name')->include_related('user', 'last_name');
     if ($user_id) {
         $this->{$this->model}->where_related('user', 'id', $user_id);
         $user = new User_Model();
         $user->get_by_id($user_id);
         $this->data['object'] = $user;
     }
     $this->data['user_id'] = $user_id;
     $this->data['entries'] = $this->{$this->model}->get()->all;
     if ($user_id) {
         $this->inherit_views('admin/users/edit');
     }
     $this->set_include('loginlog');
     $this->load->view($this->template, $this->data);
 }

 function shifts()
 {
     if ($this->staff_id) {
         $um = new User_Model();
         $um->get_by_id($this->staff_id);
         $sm = $um->shift;
     } elseif ($this->location_id) {
         $lm = new Location_Model();
         $lm->get_by_id($this->location_id);
         $sm = $lm->shift;
     } else {
         $sm = new Shift_Model();
     }
     if ($this->start) {
         $sm->where('date >=', $this->start);
     }
     if ($this->end) {
         $sm->where('date <=', $this->end);
     }
     $sm->order_by('date', 'ASC')->order_by('start', 'ASC')->include_related('user', 'id');
     return $sm->get();
 }

 private function _load_shifts($dates = array(), $staff_id = array(), $location_id = array(), $within = FALSE)
 {
     if ($staff_id && count($staff_id) == 1) {
         $um = new User_Model();
         $um->get_by_id($staff_id[0]);
         $shift_model = $um->shift;
         $timeoff_model = $um->timeoff;
     } else {
         $shift_model = new Shift_Model();
         $timeoff_model = new Timeoff_Model();
     }
     if ($dates) {
         $shift_model->where_in('date', $dates);
     }
     $shift_model->include_related('location', 'show_order')->include_related('location', 'id')->include_related('location', 'name')->include_related('user', 'id')->order_by('date', 'ASC')->order_by('start', 'ASC')->order_by('location_show_order', 'ASC');
     if ($location_id) {
         $shift_model->where_related('location', 'id', $location_id);
     }
     $shift_model->group_start();
     $shift_model->where('status', SHIFT_MODEL::STATUS_ACTIVE);
     if ($this->auth->check() && $this->app_conf->get('staff_pick_shifts')) {
         //				$shift_model->or_where('user_id IS ', 'NULL', FALSE);
     } else {
         $shift_model->where('user_id IS NOT ', 'NULL', FALSE);
     }
     $shift_model->group_end();
     $this->data['shifts'] = $shift_model->get()->all;
     if ($within !== FALSE) {
         $ok_shifts = array();
         if ($dates) {
             $day_starts = array();
             reset($dates);
             foreach ($dates as $d) {
                 $this->hc_time->setDateDb($d);
                 $day_starts[$d] = $this->hc_time->getStartDay();
             }
         }
         $now = time();
         $time_from = $now;
         $this->hc_time->setTimestamp($time_from);
         if (strlen($within) && $within) {
             $this->hc_time->modify('+ ' . $within);
         }
         $time_to = $this->hc_time->getTimestamp();
         foreach ($this->data['shifts'] as $sh) {
             if (!isset($day_starts[$sh->date])) {
                 $this->hc_time->setDateDb($sh->date);
                 $day_starts[$sh->date] = $this->hc_time->getStartDay();
             }
             $shift_start = $day_starts[$sh->date] + $sh->start;
             $shift_end = $day_starts[$sh->date] + $sh->end;
             $shift_ok = FALSE;
             if ($shift_end > $time_from && $shift_start < $time_to) {
                 $shift_ok = TRUE;
             }
             if ($shift_ok) {
                 $ok_shifts[] = $sh;
             }
         }
         $this->data['shifts'] = $ok_shifts;
     }
     $this->data['timeoffs'] = $timeoff_model->where_in('status', array(TIMEOFF_MODEL::STATUS_ACTIVE))->include_related('user', 'id')->order_by('date', 'ASC')->order_by('start', 'ASC')->get()->all;
     /* load the shifts group ids count and dates*/
     $groups = $shift_model->select('group_id, COUNT(id) AS count, MIN(date) AS min_date, MAX(date) AS max_date')->group_by('group_id')->get();
     $this->data['shift_groups'] = array();
     foreach ($groups as $g) {
         if (!$g->group_id) {
             continue;
         }
         $this->data['shift_groups'][$g->group_id] = array('count' => $g->count, 'min_date' => $g->min_date, 'max_date' => $g->max_date);
     }
 }

}
if ($default_user_id) {
    $this->hc_form->set_default('assign', 'now');
}
?>

<?php 
echo $this->hc_form->input(array('name' => 'assign', 'type' => 'hidden'));
?>

<?php 
if ($default_user_id && !is_array($default_user_id)) {
    ?>
	<?php 
    $default_user = new User_Model();
    $default_user->get_by_id($default_user_id);
    $fields['user']['type'] = 'hidden';
    ?>
	<?php 
    echo $this->hc_form->input($fields['user']);
    echo Hc_html::wrap_input(lang('user_level_staff'), $default_user->title(TRUE));
} else {
    ?>
	<?php 
    $default_assign = $this->hc_form->get_default('assign');
    echo Hc_html::wrap_input($fields['user']['label'], array('', Hc_bootstrap::nav_tabs(array('later' => lang('common_select_later'), 'now' => lang('common_select_now')), $default_assign, 'assign', '', 'style="margin: 0 0;"')));
    ?>

	<?php 
    unset($fields['user']['options'][0]);
    $fields['user']['extra']['multiple'] = 'multiple';

 private function _notify($shift, $reason)
 {
     $CI =& ci_get_instance();
     $text = $shift->view_text(array('user'));
     $changes = $shift->get_changes();
     $staff = $shift->user->get();
     $msgs = array();
     switch ($reason) {
         case 'new':
             if ($staff->exists()) {
                 $msgs['shifts_published'] = array($staff);
             }
             break;
         case 'staff_change':
             $old_staff = new User_Model();
             $old_staff->get_by_id($changes['user_id']);
             if ($old_staff->exists()) {
                 $msgs['shifts_cancelled'] = array($old_staff);
             }
             if ($staff->exists()) {
                 $msgs['shifts_published'] = array($staff);
             }
             break;
         case 'change':
             if ($staff->exists()) {
                 $msgs['shifts_changed'] = array($staff);
             }
             break;
     }
     foreach ($msgs as $key => $staffs) {
         /* compile message */
         $msg = new stdClass();
         $msg->body = array();
         foreach ($text as $ta) {
             $msg->body[] = $ta[0] . ': ' . $ta[1];
         }
         $msg->subject = lang($key);
         $msg_id = $CI->hc_notifier->add_message($msg);
         foreach ($staffs as $staff) {
             $CI->hc_notifier->enqueue_message($msg_id, $staff, $key);
         }
     }
 }

 function status()
 {
     $args = hc_parse_args(func_get_args());
     $count = array();
     $this->data['location_id'] = 0;
     $this->data['staff_id'] = 0;
     if (isset($args['staff']) && $args['staff']) {
         $um = new User_Model();
         $um->get_by_id($args['staff']);
         $sm = $um->shift;
         $this->data['staff_id'] = $args['staff'];
     } elseif (isset($args['location']) && $args['location']) {
         $lm = new Location_Model();
         $lm->get_by_id($args['location']);
         $sm = $lm->shift;
         $this->data['location_id'] = $args['location'];
     } else {
         $sm = new Shift_Model();
     }
     /* duration */
     $sm->clear();
     $sm->where('date >=', $args['start'])->where('date <=', $args['end'])->select_sum('end')->select_sum('start')->get();
     $count['duration'] = $sm->end - $sm->start;
     /* ACTIVE	- published with staff */
     $sm->clear();
     $sm->include_related('user', 'id');
     $count['active'] = $sm->where('date >=', $args['start'])->where('date <=', $args['end'])->where('status', SHIFT_MODEL::STATUS_ACTIVE)->where('user_id IS NOT ', 'NULL', FALSE)->count();
     /* OPEN		- published with no staff */
     $sm->clear();
     $sm->include_related('user', 'id');
     $count['open'] = $sm->where('date >=', $args['start'])->where('date <=', $args['end'])->where('status', SHIFT_MODEL::STATUS_ACTIVE)->where('user_id IS ', 'NULL', FALSE)->count();
     /* PENDING	- not published with staff */
     $sm->clear();
     $count['pending'] = $sm->include_related('user', 'id')->where('date >=', $args['start'])->where('date <=', $args['end'])->where('status <>', SHIFT_MODEL::STATUS_ACTIVE)->where('user_id IS NOT ', 'NULL', FALSE)->count();
     /* DRAFT	- not published with no staff */
     $sm->clear();
     $sm->include_related('user', 'id');
     $count['draft'] = $sm->where('date >=', $args['start'])->where('date <=', $args['end'])->where('status <>', SHIFT_MODEL::STATUS_ACTIVE)->group_start()->or_where('user_id IS ', 'NULL', FALSE)->or_where('user_id', 0)->group_end()->count();
     /* total */
     $sm->clear();
     $count['total'] = $sm->where('date >=', $args['start'])->where('date <=', $args['end'])->count();
     $this->data['count'] = $count;
     $this->data['start_date'] = $args['start'];
     $this->data['end_date'] = $args['end'];
     $this->set_include('status');
     $this->load->view($this->template, $this->data);
 }