/**
* 列出某个课程下的所有笔记
* 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;
}
