PHP Schedule::model方法代码示例

 protected function gavno()
 {
     $position = [];
     $list = \Schedule::model()->findAllBySql('select * from spbp_listner_schedule a
             join spbp_listner_position b on a.position_id = b.id
             join spbp_form_form c on b.form_id = c.id
             where a.number = c.number AND a.end_time < now() AND b.status = 1');
     foreach ($list as $value) {
         $a = \Position::model()->findByPk($value->position_id);
         array_push($position, $a);
     }
     return $position;
 }

 /**
  * Возвращает модель по указанному идентификатору
  * Если модель не будет найдена - возникнет HTTP-исключение.
  *
  * @param integer идентификатор нужной модели
  *
  * @return void
  */
 public function loadModel($id)
 {
     $model = Schedule::model()->findByPk($id);
     if ($model === null) {
         throw new CHttpException(404, Yii::t('ListnerModule.listner', 'Запрошенная страница не найдена.'));
     }
     return $model;
 }

 public function actionGet_data()
 {
     $sid = '';
     if (isset($_POST['sid'])) {
         $sid = str_replace(',', ' or id = ', $_POST['sid']);
     }
     if ($sid == '') {
         echo 1;
     }
     $criteria = new CDbCriteria();
     $criteria->condition = 'id =' . $sid;
     if ($_POST['searchPhrase'] != '') {
         $criteria->addCondition(' day like ' . '"%' . $_POST['searchPhrase'] . '%" or  eat like ' . '"%' . $_POST['searchPhrase'] . '%" or live like ' . '"%' . $_POST['searchPhrase'] . '%"', 'AND');
     }
     if (isset($_POST['sort']['id'])) {
         $criteria->order = " id  {$_POST['sort']['id']} ";
     } else {
         if (isset($_POST['sort']['day'])) {
             $criteria->order = "day {$_POST['sort']['day']} ";
         } else {
             if (isset($_POST['sort']['eat'])) {
                 $criteria->order = "eat {$_POST['sort']['eat']} ";
             } else {
                 if (isset($_POST['sort']['live'])) {
                     $criteria->order = "live {$_POST['sort']['live']} ";
                 }
             }
         }
     }
     $criteria->limit = $_POST['rowCount'];
     $criteria->offset = (intval($_POST['current']) - 1) * $_POST['rowCount'];
     $model = Schedule::model()->findAll($criteria);
     $count = count($model);
     //      var_dump($model);
     $arr = array();
     foreach ($model as $o) {
         $json = array('id' => intval($o->id), 'day' => $o->day, 'eat' => $o->eat, 'live' => $o->live);
         array_push($arr, $json);
     }
     //      var_dump( $arr);
     echo json_encode(array('rowCount' => $_POST['rowCount'], 'current' => $_POST['current'], 'rows' => $arr, 'total' => $count));
 }

 public function actionChange($id)
 {
     if (Yii::app()->request->isAjaxRequest) {
         $model = \Schedule::model()->findByPk($id);
         if ($model->is_active == 1) {
             $price = $model->position->form->price / $model->position->form->number;
             $model->is_active = 0;
             $model->update();
             $outflow = new Outflow();
             $outflow->price = $price;
             $outflow->based = "Отмена урока от " . $model->start_time;
             $outflow->note = $model->id;
             $outflow->branch_id = $model->position->listner->branch_id;
             $outflow->date = date('Y-m-d');
             $outflow->receiver = 'admin';
             $outflow->save();
         } elseif ($model->is_active == 0) {
             $model->is_active = 1;
             $model->update();
             $outflow = Outflow::model()->find("note='{$id}'");
             $outflow->delete();
         }
         echo CJSON::encode($model->is_active);
     } else {
         throw new CHttpException(404, Yii::t('ListnerModule.listner', 'Запрошенная страница не найдена.'));
     }
 }

 /**
  ** Schedule Functions
  **/
 public function actionListSchedules($server_id)
 {
     $this->check($server_id);
     $cmds = Schedule::model()->findAllByAttributes(array('server_id' => (int) $server_id));
     $this->ls('Schedule', $cmds);
 }

 public function actionGetSchedules($param1, $param2)
 {
     $startTime = date('Y-m-d', strtotime($_GET['start']));
     $endTime = date('Y-m-d', strtotime("+1 week", strtotime($startTime)));
     $arr = [];
     $arrs = [];
     /*        if ($param1 == "1") {
                       $array = \Yii::app()->db->createCommand()
                           ->select('b.id, c.code, z.lastname, b.start_time, b.end_time, b.room_id, d.name,d.color,asd.name as pizda')
                           ->from('spbp_user_user a')
                           ->join('spbp_user_teacher f','a.id = f.user_id')
                           ->join('spbp_listner_position c', 'c.teacher_id = f.id')
                           ->join('spbp_listner_schedule b', 'c.id = b.position_id')
                           ->join('spbp_listner_listner z','z.id = c.listner_id')
                           ->join('spbp_subject_subject d', 'd.id = c.subject_id')
                           ->join('spbp_listner_group asd', 'asd.id = b.group_id')
                           ->where('f.id =:id',array(":id"=>$param2))
                           ->queryAll();
                   }else if($param1=="2"){
                       $array = \Yii::app()->db->createCommand()
                           ->select('b.id, c.code, a.last_name as lastname, b.start_time, b.end_time, b.room_id, d.name,d.color,asd.name as pizda')
                           ->from('spbp_user_user a')
                           ->join('spbp_user_teacher f','a.id = f.user_id')
                           ->join('spbp_listner_position c', 'c.teacher_id = f.id')
                           ->join('spbp_listner_schedule b', 'c.id = b.position_id')
                           ->join('spbp_subject_subject d', 'd.id = c.subject_id')
                           ->join('spbp_listner_group asd', 'asd.id = b.group_id')
                           ->where('a.id =:id',array(":id"=>$param2))
                           ->queryAll();
                   }else if(($param1==0)&&($param2==0)){
                   $array = \Yii::app()->db->createCommand()
                       ->select('b.id, c.code, concat(a.last_name," - ",z.lastname) as lastname, b.start_time, b.end_time, b.room_id, d.name,d.color, asd.name as pizda')
                       ->from('spbp_user_user a')
                       ->join('spbp_user_teacher f','a.id = f.user_id')
                       ->join('spbp_listner_position c', 'c.teacher_id = f.id')
                       ->join('spbp_listner_listner z','z.id = c.listner_id')
                       ->join('spbp_listner_schedule b', 'c.id = b.position_id')
                       ->join('spbp_subject_subject d', 'd.id = c.subject_id')
                       ->join('spbp_listner_group asd', 'asd.id = b.group_id')
                       ->queryAll();
               }*/
     $schdls = \Schedule::model()->findAll("start_time between '{$startTime}' and '{$endTime}'");
     foreach ($schdls as $row) {
         $arrs['id'] = $row['id'];
         $arrs['resourceId'] = $row['room_id'];
         $arrs['start'] = $row['start_time'];
         $arrs['end'] = $row['end_time'];
         if ($param1 == "1") {
             if ($row['position_id']) {
                 $ponos = \Position::model()->find('teacher_id=:id and id=:id2', [":id" => $param2, ":id2" => $row['position_id']]);
                 $arrs['title'] = '(' . $ponos->code . ')';
                 $arrs['desc'] = $ponos->listner->name;
                 $arrs['subj'] = '(' . $ponos->subject->name . ')';
                 $arrs['height'] = '100px';
                 $arrs['backgroundColor'] = $ponos->subject->color;
             } else {
                 if ($row['group_id']) {
                     $ponos = \Group::model()->find('teacher_id=:id and id = :id2', [":id" => $param2, ':id2' => $row['group_id']]);
                     $arrs['title'] = '(' . $ponos->name . ')';
                     $arrs['desc'] = '';
                     $arrs['subj'] = '(' . $ponos->subject->name . ')';
                     $arrs['height'] = '100px';
                     $arrs['backgroundColor'] = $ponos->subject->color;
                 }
             }
         } else {
             if ($param1 == "2") {
                 if ($row['position_id']) {
                     $ponos = \Position::model()->find('listner_id=:id and id=:id2', [":id" => $param2, ":id2" => $row['position_id']]);
                     $arrs['title'] = '(' . $ponos->code . ')';
                     $arrs['desc'] = $ponos->teacher->user->last_name;
                     $arrs['subj'] = '(' . $ponos->subject->name . ')';
                     $arrs['height'] = '100px';
                     $arrs['backgroundColor'] = $ponos->subject->color;
                 } else {
                     if ($row['group_id']) {
                         $ponos = \Group::model()->find('id =:id2', [':id2' => $row['group_id']]);
                         $arrs['title'] = '(гр ' . $ponos->name . ')';
                         $arrs['desc'] = $ponos->teacher->user->last_name . '  ' . $ponos->teacher->user->first_name;
                         $arrs['subj'] = '(' . $ponos->subject->name . ')';
                         $arrs['height'] = '100px';
                         $arrs['backgroundColor'] = $ponos->subject->color;
                     }
                 }
             } else {
                 if ($param1 == 0 && $param2 == 0) {
                     if ($row['position_id']) {
                         $ponos = \Position::model()->findByPk($row['position_id']);
                         $arrs['title'] = '(' . $ponos->code . ')';
                         $arrs['desc'] = $ponos->listner->name;
                         $arrs['subj'] = '(' . $ponos->subject->name . ')';
                         $arrs['height'] = '100px';
                         $arrs['backgroundColor'] = $ponos->subject->color;
                     } else {
                         if ($row['group_id']) {
                             $ponos = \Group::model()->findByPk($row['group_id']);
                             $arrs['title'] = '(' . $ponos->name . ')';
                             $arrs['desc'] = $ponos->teacher->user->last_name . '  ' . $ponos->teacher->user->first_name;
                             $arrs['subj'] = '(' . $ponos->subject->name . ')';
                             $arrs['height'] = '100px';
//.........这里部分代码省略.........

 public function loadModel($id)
 {
     $model = Schedule::model()->findByPk((int) $id);
     if ($model === null) {
         throw new CHttpException(404, Yii::t('mc', 'The requested page does not exist.'));
     }
     return $model;
 }

    public function run()
    {
        $htmlOptions = $this->htmlOptions;
        $tableOptions = $this->tableOptions;
        $model = $this->model;
        $name = $this->name;
        if (!isset($htmlOptions['class'])) {
            $htmlOptions['class'] = 'table-responsive';
        } else {
            $htmlOptions['class'] .= ' table-responsive';
        }
        $htmlOptions['id'] = 'schedules';
        if (!isset($tableOptions['class'])) {
            $tableOptions['class'] = 'table table-condensed';
        } else {
            $tableOptions['class'] .= ' table table-condensed';
        }
        echo CHtml::openTag('div', $htmlOptions);
        echo CHtml::openTag('table', $tableOptions);
        echo CHtml::openTag('thead');
        echo CHtml::openTag('tr');
        echo CHtml::tag('th', array(), '第几天');
        echo CHtml::tag('th', array(), '赛区');
        echo CHtml::tag('th', array(), '开始时间');
        echo CHtml::tag('th', array(), '结束时间');
        echo CHtml::tag('th', array(), '项目');
        echo CHtml::tag('th', array(), '分组');
        echo CHtml::tag('th', array(), '轮次');
        echo CHtml::tag('th', array(), '赛制');
        echo CHtml::tag('th', array(), '及格线(秒)');
        echo CHtml::tag('th', array(), '还原时限(秒)');
        echo CHtml::tag('th', array(), '人数');
        echo CHtml::closeTag('tr');
        echo CHtml::closeTag('thead');
        $schedules = $model->{$name};
        $schedules[] = Schedule::model()->attributes;
        $events = Events::getScheduleEvents();
        foreach ($events as $key => $value) {
            $events[$key] = Yii::t('event', $value);
        }
        $formats = Formats::getAllFormats();
        foreach ($formats as $key => $value) {
            $formats[$key] = Yii::t('common', $value);
        }
        $rounds = Rounds::getAllRounds();
        foreach ($rounds as $key => $value) {
            $rounds[$key] = Yii::t('Rounds', $value);
        }
        $stages = Schedule::getStages();
        echo CHtml::openTag('tbody');
        foreach ($schedules as $key => $value) {
            extract($value);
            echo CHtml::openTag('tr');
            echo CHtml::tag('td', array(), CHtml::activeNumberField($model, "{$name}[day][]", array('value' => $day ?: 1, 'min' => 1, 'max' => 4)));
            echo CHtml::tag('td', array(), CHtml::dropDownList(CHtml::activeName($model, "{$name}[stage][]"), $stage, $stages));
            echo CHtml::tag('td', array(), CHtml::activeTextField($model, "{$name}[start_time][]", array('value' => $start_time ? date('H:i', $start_time) : '', 'class' => 'datetime-picker', 'data-date-format' => 'hh:ii', 'data-max-view' => '1', 'data-start-view' => '1')));
            echo CHtml::tag('td', array(), CHtml::activeTextField($model, "{$name}[end_time][]", array('value' => $end_time ? date('H:i', $end_time) : '', 'class' => 'datetime-picker', 'data-date-format' => 'hh:ii', 'data-max-view' => '1', 'data-start-view' => '1')));
            echo CHtml::tag('td', array(), CHtml::dropDownList(CHtml::activeName($model, "{$name}[event][]"), $event, $events, array('prompt' => '')));
            echo CHtml::tag('td', array(), CHtml::activeTextField($model, "{$name}[group][]", array('value' => $group)));
            echo CHtml::tag('td', array(), CHtml::dropDownList(CHtml::activeName($model, "{$name}[round][]"), $round, $rounds, array('prompt' => '')));
            echo CHtml::tag('td', array(), CHtml::dropDownList(CHtml::activeName($model, "{$name}[format][]"), $format, $formats, array('prompt' => '')));
            echo CHtml::tag('td', array(), CHtml::activeNumberField($model, "{$name}[cut_off][]", array('value' => $cut_off, 'max' => 3600)));
            echo CHtml::tag('td', array(), CHtml::activeNumberField($model, "{$name}[time_limit][]", array('value' => $time_limit, 'max' => 3600)));
            echo CHtml::tag('td', array(), CHtml::activeNumberField($model, "{$name}[number][]", array('value' => $number)));
            echo CHtml::closeTag('tr');
        }
        echo CHtml::closeTag('tbody');
        echo CHtml::closeTag('table');
        echo CHtml::closeTag('div');
        Yii::app()->clientScript->registerScript('SchedulesForm', <<<EOT
  \$(document).on('focus', '#schedules table tbody tr:last-child', function() {
    \$(this).clone().insertAfter(this);
    \$('.datetime-picker').datetimepicker({
      autoclose: true
    });
  });
EOT
);
    }

 public function actionModify()
 {
     $routeId = intval($_GET['route_id']) ? intval($_GET['route_id']) : '';
     if (!$routeId) {
         exit;
     }
     $route = Route::model()->find('id=:id', array(':id' => $routeId));
     if (!$route) {
         exit;
     }
     $scheduleId = $route->schedule;
     $arr = explode(',', $scheduleId);
     $str = str_replace(',', ' or id = ', $scheduleId);
     //echo $str;
     $criteria = new CDbCriteria();
     // 创建CDbCriteria对象
     $criteria->condition = 'id = ' . $str;
     // 设置查询条件
     // echo $criteria->condition;
     $model = Schedule::model()->findAll($criteria);
     $boat = Boat::model()->findAll();
     $area = Area::model()->findAll();
     $company = Company::model()->findAll();
     $port = Port::model()->findAll();
     $continent = Continent::model()->findAll();
     $this->render('modify', array('route' => $route, 'days' => $route->days, 'boat' => $boat, 'area' => $area, 'port' => $port, 'company' => $company, 'continent' => $continent));
 }

 public function resume()
 {
     $success = false;
     if (!$this->hasAttribute('suspended')) {
         $this->addError('suspended', Yii::t('mc', 'Attribute not found, database up to date?'));
     } else {
         $this->suspended = 0;
         $success = $this->save(false);
     }
     Yii::log('Resumed server ' . $this->id);
     $scheds = Schedule::model()->findAllByAttributes(array('server_id' => $this->id, 'status' => Schedule::Suspended));
     foreach ($scheds as $sched) {
         $sched->status = Schedule::Scheduled;
         $sched->save(false);
     }
     return $success;
 }

 protected function afterSave()
 {
     if (Yii::app() instanceof CConsoleApplication) {
         return;
     }
     $isAdmin = Yii::app()->user->checkRole(User::ROLE_DELEGATE);
     //处理代表和主办
     foreach (array('organizer', 'delegate') as $attribute) {
         $attributeId = $attribute . '_id';
         $oldValues = array_values(CHtml::listData($this->{$attribute}, $attributeId, $attributeId));
         $newValues = array_values((array) $this->{$attribute . 's'});
         sort($oldValues);
         sort($newValues);
         if ($oldValues != $newValues) {
             $modelName = 'Competition' . ucfirst($attribute);
             foreach ($oldValues as $value) {
                 if (!in_array($value, $newValues) && $isAdmin) {
                     $modelName::model()->deleteAllByAttributes(array('competition_id' => $this->id, $attributeId => $value));
                 }
             }
             foreach ($newValues as $value) {
                 if (!in_array($value, $oldValues)) {
                     $model = new $modelName();
                     $model->competition_id = $this->id;
                     $model->{$attribute . '_id'} = $value;
                     $model->save();
                 }
             }
         }
     }
     //处理赛程
     $schedules = $this->schedules;
     if (!empty($schedules['start_time'])) {
         Schedule::model()->deleteAllByAttributes(array('competition_id' => $this->id));
         foreach ($schedules['start_time'] as $key => $startTime) {
             if (empty($startTime) || !isset($schedules['end_time'][$key]) || empty($schedules['end_time'][$key])) {
                 continue;
             }
             $model = new Schedule();
             $model->competition_id = $this->id;
             $model->start_time = strtotime($startTime);
             $model->end_time = strtotime($schedules['end_time'][$key]);
             $model->day = $schedules['day'][$key];
             $model->stage = $schedules['stage'][$key];
             $model->event = $schedules['event'][$key];
             $model->group = $schedules['group'][$key];
             $model->round = $schedules['round'][$key];
             $model->format = $schedules['format'][$key];
             $model->number = intval($schedules['number'][$key]);
             $model->cut_off = intval($schedules['cut_off'][$key]);
             $model->time_limit = intval($schedules['time_limit'][$key]);
             $model->save(false);
         }
     }
     //处理地址
     $oldLocations = $this->location;
     foreach ($this->locations as $key => $value) {
         if (isset($oldLocations[$key])) {
             $location = $oldLocations[$key];
         } else {
             $location = new CompetitionLocation();
             $location->competition_id = $this->id;
             $location->location_id = $key;
         }
         $location->attributes = $value;
         $location->save(false);
     }
     if ($this->isOld()) {
         $this->old->save(false);
     }
 }

 /**
  * @param $id
  *      准备修改的预约id
  * @param $time_modify
  *      修改后的时间
  * @param $modify_time_count
  *      准备修改的时间段的已安排预约数
  */
 private function maintainSchedule($id, $time_modify, $modify_time_count)
 {
     define("AM_AVAILABLE", 0x4);
     //上午可用
     define("AM_NOT_AVAILABLE", 0x3);
     //上午不可用
     define("PM_AVAILABLE", 0x2);
     //下午可用
     define("PM_NOT_AVAILABLE", 0x5);
     //下午不可用
     define("NT_AVAILABLE", 0x1);
     //傍晚可用
     define("NT_NOT_AVAILABLE", 0x6);
     //傍晚不可用
     $aptm_model = Aptm::model();
     $schedule_model = Schedule::model();
     //取得修改前的日期的tbl_schedule的flag
     $query = 'select * from tbl_appointment where pk_aptm_id=' . $id;
     $aptm_info = $aptm_model->findBySql($query);
     $date_original = '0000';
     $hour_original = 0;
     if (isset($aptm_info)) {
         $time_original = $aptm_info->aptm_time;
         $date_original = date('md', strtotime("{$time_original}"));
         $hour_original = date('H', strtotime("{$time_original}"));
         //            echo "<br>"."time_original: ".$aptm_info->aptm_time;  //log
     }
     $query = 'select * from tbl_schedule where sch_date=' . $date_original;
     $schedule_info_before = $schedule_model->findBySql($query);
     //变更修改前的flag
     //对于修改前的预约来说，肯定是减少，所以只需要无脑的把flag去掉就行（变为1）
     if (isset($schedule_info_before)) {
         //            echo "<br>"."schedule_info_before: ".$schedule_info_before->sch_flag;  //log
         if ($hour_original < 12) {
             $schedule_info_before->sch_flag |= AM_AVAILABLE;
         } elseif ($hour_original >= 12 && $hour_original < 17) {
             $schedule_info_before->sch_flag |= PM_AVAILABLE;
         } elseif ($hour_original >= 17) {
             $schedule_info_before->sch_flag |= NT_AVAILABLE;
         } else {
         }
         //            echo "<br>"."schedule_info_before_change: ".$schedule_info_before->sch_flag;  //log
     }
     //因为变更前后有可能是同一天，所以要先save一下
     $schedule_info_before->save();
     //取得修改后的日期的tbl_schedule的flag
     //        echo "<br>"."time_modify: ".$time_modify;   //log
     $date_modify = date('md', strtotime("{$time_modify}"));
     $query = 'select * from tbl_schedule where sch_date=' . $date_modify;
     $schedule_info_after = $schedule_model->findBySql($query);
     //变更修改后的flag
     //对于修改后的预约来说，需要看同一时间段的预约是否会到4个，如果到了4个才需要修改flag
     if (isset($schedule_info_after)) {
         //            echo "<br>"."schedule_info_after: ".$schedule_info_after->sch_flag;  //log
         //            echo "<br>"."modify_time_count: ".$modify_time_count;  //log
         if ($modify_time_count >= 3) {
             $hour_modify = date('H', strtotime("{$time_modify}"));
             if ($hour_modify < 12) {
                 $schedule_info_after->sch_flag &= AM_NOT_AVAILABLE;
             } elseif ($hour_modify >= 12 && $hour_modify < 17) {
                 $schedule_info_after->sch_flag &= PM_NOT_AVAILABLE;
             } elseif ($hour_modify >= 17) {
                 $schedule_info_after->sch_flag &= NT_NOT_AVAILABLE;
             } else {
             }
         }
         //            echo "<br>"."schedule_info_after_change: ".$schedule_info_after->sch_flag;  //log
     }
     $schedule_info_after->save();
     return;
 }