PHP Note::getAll方法代码示例

 public function testSimpleUserImportWhereAllRowsSucceed()
 {
     Yii::app()->user->userModel = User::getByUsername('super');
     $notes = Note::getAll();
     $this->assertEquals(0, count($notes));
     $import = new Import();
     $serializedData['importRulesType'] = 'Notes';
     $serializedData['firstRowIsHeaderRow'] = true;
     $import->serializedData = serialize($serializedData);
     $this->assertTrue($import->save());
     ImportTestHelper::createTempTableByFileNameAndTableName('simpleImportTest.csv', $import->getTempTableName(), true, Yii::getPathOfAlias('application.modules.notes.tests.unit.files'));
     $this->assertEquals(4, ImportDatabaseUtil::getCount($import->getTempTableName()));
     // includes header rows.
     $mappingData = array('column_0' => ImportMappingUtil::makeTextAreaColumnMappingData('description'), 'column_1' => ImportMappingUtil::makeDateTimeColumnMappingData('occurredOnDateTime'), 'column_2' => ImportMappingUtil::makeModelDerivedColumnMappingData('AccountDerived'), 'column_3' => ImportMappingUtil::makeModelDerivedColumnMappingData('ContactDerived'), 'column_4' => ImportMappingUtil::makeModelDerivedColumnMappingData('OpportunityDerived'));
     $importRules = ImportRulesUtil::makeImportRulesByType('Notes');
     $page = 0;
     $config = array('pagination' => array('pageSize' => 50));
     //This way all rows are processed.
     $dataProvider = new ImportDataProvider($import->getTempTableName(), true, $config);
     $dataProvider->getPagination()->setCurrentPage($page);
     $importResultsUtil = new ImportResultsUtil($import);
     $messageLogger = new ImportMessageLogger();
     ImportUtil::importByDataProvider($dataProvider, $importRules, $mappingData, $importResultsUtil, new ExplicitReadWriteModelPermissions(), $messageLogger);
     $importResultsUtil->processStatusAndMessagesForEachRow();
     //Confirm that 3 models where created.
     $notes = Note::getAll();
     $this->assertEquals(3, count($notes));
     $notes = Note::getByName('note1');
     $this->assertEquals(1, count($notes[0]));
     $this->assertEquals(1, count($notes[0]->activityItems));
     $this->assertEquals('testAccount', $notes[0]->activityItems[0]->name);
     $this->assertEquals('Account', get_class($notes[0]->activityItems[0]));
     $this->assertEquals('2011-12-22 05:03', substr($notes[0]->latestDateTime, 0, -3));
     $notes = Note::getByName('note2');
     $this->assertEquals(1, count($notes[0]));
     $this->assertEquals(1, count($notes[0]->activityItems));
     $this->assertEquals('testContact', $notes[0]->activityItems[0]->firstName);
     $this->assertEquals('Contact', get_class($notes[0]->activityItems[0]));
     $this->assertEquals('2011-12-22 05:03', substr($notes[0]->latestDateTime, 0, -3));
     $notes = Note::getByName('note3');
     $this->assertEquals(1, count($notes[0]));
     $this->assertEquals(1, count($notes[0]->activityItems));
     $this->assertEquals('testOpportunity', $notes[0]->activityItems[0]->name);
     $this->assertEquals('Opportunity', get_class($notes[0]->activityItems[0]));
     $this->assertEquals('2011-12-22 06:03', substr($notes[0]->latestDateTime, 0, -3));
     //Confirm 10 rows were processed as 'created'.
     $this->assertEquals(3, ImportDatabaseUtil::getCount($import->getTempTableName(), "status = " . ImportRowDataResultsUtil::CREATED));
     //Confirm that 0 rows were processed as 'updated'.
     $this->assertEquals(0, ImportDatabaseUtil::getCount($import->getTempTableName(), "status = " . ImportRowDataResultsUtil::UPDATED));
     //Confirm 2 rows were processed as 'errors'.
     $this->assertEquals(0, ImportDatabaseUtil::getCount($import->getTempTableName(), "status = " . ImportRowDataResultsUtil::ERROR));
     $beansWithErrors = ImportDatabaseUtil::getSubset($import->getTempTableName(), "status = " . ImportRowDataResultsUtil::ERROR);
     $this->assertEquals(0, count($beansWithErrors));
 }

 public function testSuperUserAllDefaultControllerActions()
 {
     $super = $this->logoutCurrentUserLoginNewUserAndGetByUsername('super');
     $superAccountId = self::getModelIdByModelNameAndName('Account', 'superAccount');
     $superAccountId2 = self::getModelIdByModelNameAndName('Account', 'superAccount2');
     $superContactId = self::getModelIdByModelNameAndName('Contact', 'superContact superContactson');
     $account = Account::getById($superAccountId);
     $account2 = Account::getById($superAccountId2);
     $contact = Contact::getById($superContactId);
     //confirm no existing activities exist
     $activities = Activity::getAll();
     $this->assertEquals(0, count($activities));
     //Test just going to the create from relation view.
     $this->setGetArray(array('relationAttributeName' => 'Account', 'relationModelId' => $superAccountId, 'relationModuleId' => 'accounts', 'redirectUrl' => 'someRedirect'));
     $this->runControllerWithNoExceptionsAndGetContent('notes/default/createFromRelation');
     //add related note for account using createFromRelation action
     $activityItemPostData = array('account' => array('id' => $superAccountId));
     $this->setGetArray(array('relationAttributeName' => 'Account', 'relationModelId' => $superAccountId, 'relationModuleId' => 'accounts', 'redirectUrl' => 'someRedirect'));
     $this->setPostArray(array('ActivityItemForm' => $activityItemPostData, 'Note' => array('description' => 'myNote')));
     $this->runControllerWithRedirectExceptionAndGetContent('notes/default/createFromRelation');
     //now test that the new note exists, and is related to the account.
     $notes = Note::getAll();
     $this->assertEquals(1, count($notes));
     $this->assertEquals('myNote', $notes[0]->description);
     $this->assertEquals(1, $notes[0]->activityItems->count());
     $activityItem1 = $notes[0]->activityItems->offsetGet(0);
     $this->assertEquals($account, $activityItem1);
     //test viewing the existing note in a details view
     $this->setGetArray(array('id' => $notes[0]->id));
     $this->resetPostArray();
     $this->runControllerWithNoExceptionsAndGetContent('notes/default/details');
     //test editing an existing note and saving.
     //First just go to the edit view and confirm it loads ok.
     $this->setGetArray(array('id' => $notes[0]->id, 'redirectUrl' => 'someRedirect'));
     $this->resetPostArray();
     $this->runControllerWithNoExceptionsAndGetContent('notes/default/edit');
     //Save changes via edit action.
     $activityItemPostData = array('Account' => array('id' => $superAccountId), 'Contact' => array('id' => $superContactId));
     $this->setGetArray(array('id' => $notes[0]->id, 'redirectUrl' => 'someRedirect'));
     $this->setPostArray(array('ActivityItemForm' => $activityItemPostData, 'Note' => array('description' => 'myNoteX')));
     $this->runControllerWithRedirectExceptionAndGetContent('notes/default/edit');
     //Confirm changes applied correctly.
     $notes = Note::getAll();
     $this->assertEquals(1, count($notes));
     $this->assertEquals('myNoteX', $notes[0]->description);
     $this->assertEquals(2, $notes[0]->activityItems->count());
     $activityItem1 = $notes[0]->activityItems->offsetGet(0);
     $activityItem2 = $notes[0]->activityItems->offsetGet(1);
     $this->assertEquals($account, $activityItem1);
     $this->assertEquals($contact, $activityItem2);
     //Remove contact relation.  Switch account relation to a different account.
     $activityItemPostData = array('Account' => array('id' => $superAccountId2));
     $this->setGetArray(array('id' => $notes[0]->id));
     $this->setPostArray(array('ActivityItemForm' => $activityItemPostData, 'Note' => array('description' => 'myNoteX')));
     $this->runControllerWithRedirectExceptionAndGetContent('notes/default/edit');
     //Confirm changes applied correctly.
     $notes = Note::getAll();
     $this->assertEquals(1, count($notes));
     $this->assertEquals('myNoteX', $notes[0]->description);
     $this->assertEquals(1, $notes[0]->activityItems->count());
     $activityItem1 = $notes[0]->activityItems->offsetGet(0);
     $this->assertEquals($account2, $activityItem1);
     //Test validating an existing note via the inline edit validation (failed Validation)
     $activityItemPostData = array('Account' => array('id' => $superAccountId), 'Contact' => array('id' => $superContactId));
     $this->setGetArray(array('id' => $notes[0]->id, 'redirectUrl' => 'someRedirect'));
     $this->setPostArray(array('ActivityItemForm' => $activityItemPostData, 'ajax' => 'inline-edit-form', 'Note' => array('description' => '')));
     $content = $this->runControllerWithExitExceptionAndGetContent('notes/default/inlineCreateSave');
     $this->assertTrue(strlen($content) > 20);
     //approximate, but should definetely be larger than 20.
     //Test validating an existing note via the inline edit validation (Success)
     $this->setPostArray(array('ActivityItemForm' => $activityItemPostData, 'ajax' => 'inline-edit-form', 'Note' => array('description' => 'a Valid Name of a Note')));
     $content = $this->runControllerWithExitExceptionAndGetContent('notes/default/inlineCreateSave');
     $this->assertEquals('[]', $content);
     //Test saving an existing note via the inline edit validation
     $this->setPostArray(array('ActivityItemForm' => $activityItemPostData, 'Note' => array('description' => 'a Valid Name of a Note')));
     $content = $this->runControllerWithRedirectExceptionAndGetContent('notes/default/inlineCreateSave');
     //Confirm changes applied correctly.
     $notes = Note::getAll();
     $this->assertEquals(2, count($notes));
     $this->assertEquals('a Valid Name of a Note', $notes[1]->description);
     //test removing a note.
     $this->setGetArray(array('id' => $notes[1]->id));
     $this->resetPostArray();
     $this->runControllerWithRedirectExceptionAndGetContent('notes/default/delete');
     //Confirm no more notes exist.
     $notes = Note::getAll();
     $this->assertEquals(1, count($notes));
 }

            $res = self::query("UPDATE `notes` SET `title` = '{$title}', `message` = '{$message}' WHERE `notes`.`id` = {$id}");
        }
        // Return query result
        return json_encode($res);
    }
    public static function delete($id)
    {
        $res = self::query("DELETE FROM notes WHERE `id` = {$id}");
        return $res;
    }
}
// Our script requires JSON data format
// Set Content-Type to JSON
header('Content-Type: application/json');
// if GET request then return the list of all items
// if POST request then add, edit or delete
switch ($_SERVER['REQUEST_METHOD']) {
    case 'GET':
        echo Note::getAll();
        break;
    case 'POST':
        if (isset($_POST['action'])) {
            echo Note::delete($_POST['id']);
        } else {
            print_r(Note::save($_POST));
        }
        break;
    default:
        echo 'Unknown operation';
        break;
}

 function getSelect($sort = "content", $order = "ASC")
 {
     $results = Note::getAll(null, $sort, $order);
     $temp = array(array("label" => "Edit item"));
     foreach ($results as $row) {
         $temp[] = array("value" => $row['id'], "label" => str_replace("\n", " /", stripslashes($row['content'])));
     }
     return $temp;
 }

	<div>
		<a href='browse.php?cid=".$cid."&tid=".$tid."&h=25'>small</a> | 
		<a href='browse.php?cid=".$cid."&tid=".$tid."&h=50'>med</a> |
		<a href='browse.php?cid=".$cid."&tid=".$tid."&h=75'>large</a>
	</div>";

$where = array();
if(!is_null($cid) && !empty($cid)){
	$category = new Category($cid);
	$where["category_id"] = $cid;
}

if(!is_null($tid) && !empty($tid)){
	$where["type_id"] = $tid;
}

$all_notes = Note::getAll( $where );


foreach($all_notes as $note){
	echo "
		<div style='float:left;'>
			<a href='index.php?id=".$note['id']."'>
				<img border='0' src='../image.php?id=".$note['id']."&h=".$h."' />
			</a>
			<br/><span style='font-size:9px'>".nl2br($note['content'])."</span>
		</div>";
}

}
?>

 /**
  * @depends testPostGameNotificationToProfile
  */
 public function testPostingAnNoteCarriesPermissionsCorrectly()
 {
     if (!SECURITY_OPTIMIZED) {
         return;
     }
     $super = $this->logoutCurrentUserLoginNewUserAndGetByUsername('super');
     $socialItems = SocialItem::getAll();
     $this->assertEquals(2, count($socialItems));
     $superAccountId = self::getModelIdByModelNameAndName('Account', 'superAccount');
     $activityItemPostData = array('Account' => array('id' => $superAccountId));
     $this->setGetArray(array('redirectUrl' => 'someRedirect'));
     $this->setPostArray(array('ActivityItemForm' => $activityItemPostData, 'postToProfile' => true, 'Note' => array('description' => 'a note that is promoted')));
     $content = $this->runControllerWithRedirectExceptionAndGetContent('notes/default/inlineCreateSave');
     $notes = Note::getAll();
     $this->assertEquals(1, count($notes));
     $socialItems = SocialItem::getAll();
     $this->assertEquals(3, count($socialItems));
     $this->assertEquals($notes[0]->id, $socialItems[2]->note->id);
     $this->assertNull($socialItems[2]->description);
 }

//	remove old images
clearDirectory( $target_dir );

//	create new
$db = new Database( "db13310_notes" );
$sql  = "SELECT id,image_full,image_full_back FROM notes";
$query = $db->query($sql);
$items = array();

while($row = $db->getRow($query)){
	$items[] = $row;
}

if( isset( $_GET['id'] ) )
{
	$images = Note::getAll( array( "id" => $_GET['id'] ) );
}

foreach($items as $item)
{
	if( isset( $item['image_full'] ) ) createImage( $item, 'image_full' );
	if( isset( $item['image_full_back'] ) ) createImage( $item, 'image_full_back', '_back' );
}

function createImage( $item, $data_field, $suffix = '' )
{
	$defs = array
	(
		array('ext'=>'tiny','height'=>30,'crop'=>false)
	);

 /**
  * @depends testUpdateNoteFromForm
  */
 public function testDeleteNote()
 {
     Yii::app()->user->userModel = User::getByUsername('super');
     $notes = Note::getAll();
     $this->assertEquals(2, count($notes));
     $notes[0]->delete();
     $notes = Note::getAll();
     $this->assertEquals(1, count($notes));
 }