PHP Note::model方法代码示例

 /**
  * 列出某个课程下的所有笔记
  * Enter description here ...
  * @param unknown_type $courseId
  */
 public function actionNote($courseId)
 {
     $courseId = intval($courseId);
     $course = Course::model()->findByPk($courseId);
     $sql = "select n.*,l.id as lessonId from ew_course c inner join ew_lesson l on c.id=l.courseId inner join ew_note n on n.noteableEntityId=l.entityId where c.id={$courseId}";
     $notes = Note::model()->findAllBySql($sql);
     $dataProvider = new CArrayDataProvider($notes);
     $this->render('my_notes', array('dataProvider' => $dataProvider, 'course' => $course));
 }

 /**
  * Deletes notes in batch mode.
  */
 public function actionBatchDelete()
 {
     if (isset($_POST['deleteNote'])) {
         foreach ($_POST['deleteNote'] as $id => $value) {
             $model = Note::model()->findByPk($id);
             $model->delete();
             unlink(Yii::app()->params['notesDir'] . $model->id . '.' . $model->extension);
         }
         Yii::app()->user->setNotification('success', 'Berkas-berkas berhasil dihapus.');
     }
     $this->redirect(array('index'));
 }

 public function init()
 {
     if (ContactsModule::shouldUpdateLatestActivityDateTimeWhenATaskIsCompleted()) {
         $eventHandler = array($this, 'updateContactLatestActivityDateTimeByTask');
         Task::model()->attachEventHandler('onAfterSave', $eventHandler);
         $this->attachedEventHandlersIndexedByModelClassName['Task'] = array('onAfterSave', $eventHandler);
     }
     if (ContactsModule::shouldUpdateLatestActivityDateTimeWhenANoteIsCreated()) {
         $eventHandler = array($this, 'updateContactLatestActivityDateTimeByNote');
         Note::model()->attachEventHandler('onAfterSave', $eventHandler);
         $this->attachedEventHandlersIndexedByModelClassName['Note'] = array('onAfterSave', $eventHandler);
     }
     if (ContactsModule::shouldUpdateLatestActivityDateTimeWhenAnEmailIsSentOrArchived()) {
         $eventHandler = array($this, 'updateContactLatestActivityDateTimeByEmailMessage');
         EmailMessage::model()->attachEventHandler('onAfterSave', $eventHandler);
         $this->attachedEventHandlersIndexedByModelClassName['EmailMessage'] = array('onAfterSave', $eventHandler);
     }
     if (ContactsModule::shouldUpdateLatestActivityDateTimeWhenAMeetingIsInThePast()) {
         $eventHandler = array($this, 'resolveModelLatestActivityDateTimeProcessFlagByMeeting');
         Meeting::model()->attachEventHandler('onBeforeSave', $eventHandler);
         $this->attachedEventHandlersIndexedByModelClassName['Meeting'] = array('onBeforeSave', $eventHandler);
     }
 }

 /**
  * 获取反对票数量
  */
 public function getNoteCount()
 {
     return Note::model()->count("noteableEntityId=:entityId and value<=0", array(':entityId' => $this->getOwner()->entityId));
 }

 public function saveNoteTypeIds($noteIds = [], $noteTypeId)
 {
     if (!$noteTypeId) {
         throw new CHttpException(404, "Note type is not found");
     }
     $r = Note::model()->updateAll(['not_row' => $noteTypeId], "not_id in (" . implode(",", $noteIds) . ")");
 }

 private function saveClient(Client $model)
 {
     $this->prepareModel($model);
     if (isset($_POST['Client']) && $_POST['Client']) {
         $_POST['Client']['propertyTypesIds'] = isset($_POST['Client']['propertyTypesIds']) ? $_POST['Client']['propertyTypesIds'] : [];
         $_POST['Client']['propertyCategoryIds'] = isset($_POST['Client']['propertyCategoryIds']) ? $_POST['Client']['propertyCategoryIds'] : [];
         $model->attributes = $_POST['Client'];
         if ($model->isNewRecord) {
             $model->scenario = 'validPhoneOnInsert';
         }
         $generalNoteIds = isset($_POST['noteId-' . Note::TYPE_CLIENT_GENERAL]) ? $_POST['noteId-' . Note::TYPE_CLIENT_GENERAL] : [];
         $generalNote = isset($_POST[Note::TYPE_CLIENT_GENERAL]) ? $_POST[Note::TYPE_CLIENT_GENERAL] : [];
         $reqNoteIds = isset($_POST['noteId-' . Note::TYPE_CLIENT_REQ]) ? $_POST['noteId-' . Note::TYPE_CLIENT_REQ] : [];
         $reqNote = isset($_POST[Note::TYPE_CLIENT_REQ]) ? $_POST[Note::TYPE_CLIENT_REQ] : [];
         $telephones = isset($_POST['telephones']) ? $_POST['telephones'] : [];
         $existingPhones = Telephone::model()->findAllByPk(array_filter($telephones['id']), ['index' => 'tel_id']);
         if (isset($telephones['number'][0]) && $telephones['number'][0]) {
             $phone = new Telephone();
             $phone->tel_number = $telephones['number'][0];
             $phone->tel_type = $telephones['type'][0];
             $model->_newPhones = [$phone];
         }
         $model->addressID = isset($_POST['primaryAddress']['id']) ? $_POST['primaryAddress']['id'] : 0;
         $model->secondAddressID = isset($_POST['secondAddress']['id']) ? $_POST['secondAddress']['id'] : 0;
         if ($model->save()) {
             /** @var $existingPhones Telephone */
             foreach ($telephones['number'] as $key => $number) {
                 $phoneId = $telephones['id'][$key];
                 $type = $telephones['type'][$key];
                 if (isset($existingPhones[$phoneId])) {
                     $phone = $existingPhones[$phoneId];
                 } else {
                     $phone = new Telephone();
                 }
                 if ($number) {
                     $phone->tel_cli = $model->cli_id;
                     $phone->tel_number = $number;
                     $phone->tel_type = $type;
                     $phone->save();
                 } else {
                     if (!$phone->isNewRecord) {
                         $phone->delete();
                     }
                 }
             }
             $model->saveAreas(isset($_POST['Client']['matchingPostcode']) ? $_POST['Client']['matchingPostcode'] : []);
             $model->saveFeatures(isset($_POST['Client']['feature']) ? $_POST['Client']['feature'] : []);
             if ($generalNoteIds) {
                 Note::model()->saveNoteTypeIds($generalNoteIds, $model->cli_id);
             }
             if ($reqNoteIds) {
                 Note::model()->saveNoteTypeIds($reqNoteIds, $model->cli_id);
             }
             if ($generalNote) {
                 $generalNote['not_type'] = Note::TYPE_CLIENT_GENERAL;
                 Note::model()->saveNote($generalNote, $model->cli_id);
             }
             if ($reqNote) {
                 $reqNote['not_type'] = Note::TYPE_CLIENT_REQ;
                 Note::model()->saveNote($reqNote, $model->cli_id);
             }
             if (isset($_POST['Client']['saveProceed']) && $_POST['Client']['saveProceed']) {
                 $this->redirect([$this->createUrl('appointmentBuilder/clientSelected', ['clientId' => $model->cli_id])]);
             } else {
                 Yii::app()->user->setFlash('client-update-success', 'Updated Successfully');
                 $this->redirect(array('Update', 'id' => $model->cli_id, 'useClient' => isset($_GET['useClient']) && $_GET['useClient'] ? 1 : 0));
             }
         }
     }
 }

 public function actionSaveNoteBlurb()
 {
     if (!isset($_POST['noteId'], $_POST['noteBlurb'])) {
         throw new CHttpException(400, 'Wrong request');
     }
     if ($_POST['noteId']) {
         $model = Note::model()->findByPk($_POST['noteId']);
         if (!$model) {
             throw new CHttpException(400, 'Wrong request');
         }
     } elseif (isset($_POST['noteType'], $_POST['noteTypeId'])) {
         $model = new Note();
         $model->not_type = $_POST['noteType'];
         $model->not_row = $_POST['noteTypeId'];
     } else {
         throw new CHttpException(400, 'Wrong request');
     }
     $model->not_blurb = $_POST['noteBlurb'];
     $model->save();
     echo $model->not_id;
 }

 /**
  * Returns the data model based on the primary key given in the GET variable.
  * If the data model is not found, an HTTP exception will be raised.
  * @param integer $id the ID of the model to be loaded
  * @return Note the loaded model
  * @throws CHttpException
  */
 public function loadModel($id)
 {
     $model = Note::model()->findByPk($id);
     if ($model === null) {
         throw new CHttpException(404, 'The requested page does not exist.');
     }
     return $model;
 }

 /**
  * @param $data
  * @param $noteType
  * @param $instruction
  */
 private function saveNote($data, $noteType, $instruction)
 {
     if (!isset($data[$noteType]['not_blurb']) || !$data[$noteType]['not_blurb']) {
         return;
     }
     $model = new Note();
     if (isset($data[$noteType]['not_id']) && $data[$noteType]['not_id']) {
         $model = Note::model()->findByPk($data[$noteType]['not_id']);
     }
     $model->not_blurb = $data[$noteType]['not_blurb'];
     $model->not_row = $instruction->dea_id;
     $model->not_type = $noteType;
     if (!$model->save()) {
         Yii::app()->user->setFlash('error', 'note [type = ' . $noteType . '] is not saved.');
     }
 }

 /**
  * Tests the note update action with invalid input.
  */
 public function testUpdateInvalid()
 {
     $model = $this->notes('note3');
     // Empty title
     $fakeNote = Note::model()->findByPk($model->id);
     $fakeNote->title = null;
     $this->assertFalse($fakeNote->validate());
     // Lengthy title
     $fakeNote = Note::model()->findByPk($model->id);
     Yii::import('ext.randomness.*');
     $fakeNote->title = Randomness::randomString(Note::MAX_TITLE_LENGTH + 1);
     $this->assertFalse($fakeNote->validate());
     // Empty description
     $fakeNote = Note::model()->findByPk($model->id);
     $fakeNote->description = null;
     $this->assertFalse($fakeNote->validate());
 }

 /**
  * Loads the note model.
  * @param  int $id the note id
  * @return Note the note object associated with the given id
  */
 public function loadModel($id)
 {
     $model = Note::model()->findByPk($id);
     if ($model === NULL) {
         throw new CHttpException(404, 'Berkas catatan yang dimaksud tidak ada.');
     }
     return $model;
 }