public static function fetchByName($title, $fund, $period, $type, $author, $accountno, $preparedby1, $preparedby2, $certifiedby1, $certifiedby2)
{
if (!$title) {
return;
}
//remove "page 1" from title
$start = strpos($title, " page ");
if ($start === false) {
$journaltitle = $title;
} else {
$journaltitle = substr($title, 0, $start);
}
//search journal with title in database
//if not found, create
$journal = Doctrine::getTable('Journal')->findOneByName($journaltitle);
if (!$journal) {
//create one
$journal = new Journal();
$journal->setName($journaltitle);
$journal->setFundId($fund->getId());
$journal->setPeriodId($period->getId());
$journal->setType($type);
$journal->setAuthor($author);
$journal->setAccountno($accountno);
$journal->setPreparedby1($preparedby1);
$journal->setPreparedby2($preparedby2);
$journal->setCertifiedby1($certifiedby1);
$journal->setCertifiedby2($certifiedby2);
$journal->save();
}
return $journal;
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
$rules = array('publish_date' => 'required|date|unique_with:journals,user_id,publish_date', 'contents' => 'required');
$request = Request::all();
$errors = $this->validateAndReturnErrors($request, $rules);
if ($errors) {
return Response::json(array('message' => 'The following errors were encountered ', 'errors' => $errors), 400);
}
$journal = new Journal();
$journal->user_id = Authorizer::getResourceOwnerId();
$journal->publish_date = Carbon::parse($request['publish_date']);
$journal->volume = $journal->publish_date->diffInMonths(Config::get('constants.ANNIVERSARY')) + 2;
$journal->day = $journal->publish_date->diffInDays(Config::get('constants.ANNIVERSARY')) + 1;
$journal->contents = $request['contents'];
$journal->special_events = array_key_exists('special_events', $request) ? $request['special_events'] : '';
try {
$journal->save();
} catch (Illuminate\Database\QueryException $e) {
$error = $e->errorInfo;
if ($error[1] = 1062) {
//Duplicate Entry
return Response::json(['error' => '1062', 'error_description' => 'Your journal entry for this date already exists'], 409);
}
}
return Response::json(['message' => 'The resource has been successfuly created', 'journals' => $journal], 201);
}
public function actionUpgrade()
{
$player = Player::model()->findByAttributes(array('email' => Yii::app()->user->id));
$ship = Ship::model()->findByAttributes(array('id' => $player->id));
if ($ship == null) {
$this->redirect($this->createUrl('player/Needship'));
return;
}
// Получить ссылку на все предметы игрока
$person_prototype_items_shop = $ship->getBuyNextMagazinesForType();
if (!isset($_GET['type'])) {
$this->redirect($this->createUrl('player/myship'));
return;
}
$type_item = $_GET['type'];
// Получить текущий список по типу покупаемой вещи
$type_buy = $person_prototype_items_shop[$type_item];
// Получить текущую ИД текущей установленной вещи
$id_ship_item = $ship->getParamForKeyPrototype($type_item);
// Получить покупаемую вещь (следующюю по счету)
$buy_item = $type_buy[$id_ship_item + 1];
if ($player->setSummBuyPlus(-$buy_item['summ'])) {
$ship->setNewItemToshipAndUpdateSummship($type_item, $buy_item['summ'], $buy_item['gfx_ship']);
$journal = new Journal();
$journal->item_id = $buy_item['id'];
$journal->type = $type_item;
$journal->summ = $buy_item['summ'];
$journal->id_player = $player->id;
$journal->save();
$this->redirect($this->createUrl('/player/myship'));
} else {
$this->render('noMoney');
}
}
public function debitAccount($data, $trans_no)
{
$journal = new Journal();
$account = Account::findOrFail($data['debit_account']);
$journal->account()->associate($account);
$journal->date = $data['date'];
$journal->trans_no = $trans_no;
$journal->initiated_by = $data['initiated_by'];
$journal->amount = $data['amount'];
$journal->type = 'debit';
$journal->description = $data['description'];
$journal->save();
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Journal();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Journal'])) {
$model->attributes = $_POST['Journal'];
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->id));
}
}
$this->render('create', array('model' => $model));
}
public function run()
{
DB::table('journals')->truncate();
$faker = Faker\Factory::create();
foreach (range(1, 50) as $index) {
$journal = new Journal();
$journal->user_id = $faker->randomDigit();
$journal->publish_date = Carbon::instance($faker->dateTimeBetween($startDate = Config::get('constants.ANNIVERSARY')));
$journal->volume = $journal->publish_date->diffInMonths(Config::get('constants.ANNIVERSARY')) + 2;
$journal->day = $journal->publish_date->diffInDays(Config::get('constants.ANNIVERSARY')) + 1;
$journal->contents = implode("\n\n", $faker->paragraphs(5));
$journal->special_events = implode("\n", $faker->sentences(2));
$journal->save();
}
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$input = $request->all();
$journal = new Journal();
$journal->Title = $input['title'];
$journal->Description = $input['description'];
$journal->Frequency = $input['frequency'];
/*$journal->Logo=$input['logo'];*/
if (isset($input['img'])) {
$Image = $input['img'];
//dd($Image);
$Image = $this->imageUpload($Image);
//dd($Image);
$input['img'] = $Image;
} else {
$input['img'] = "reg_img/default.gif";
}
$journal = new Journal(array('title' => $request->get('title'), 'img' => $Image));
$journal->Language = $input['language'];
$journal->save();
return redirect('/journal');
}
public function storeData($walletID)
{
$attributes = $this->apiAttributes();
$character = Characters::Model()->findByPk($walletID);
//Retrieve the XML dataset
$journal = $this->getEVEData($walletID);
if (!isset($journal->error)) {
foreach ($journal->result->rowset->row as $row) {
if ($character->limitUpdate) {
$orderTime = strtotime($row->attributes()->date);
$timeLimit = strtotime($character->limitDate);
} else {
$orderTime = 1;
$timeLimit = 0;
}
$exist = Journal::Model()->exists('refID=:refID', array(':refID' => $row->attributes()->refID));
if (!$exist && $orderTime > $timeLimit) {
$orderRow = new Journal();
$orderRow->date = $row->attributes()->date;
$orderRow->refID = $row->attributes()->refID;
$orderRow->refTypeID = $row->attributes()->refTypeID;
$orderRow->ownerName1 = $row->attributes()->ownerName1;
$orderRow->ownerID1 = $row->attributes()->ownerID1;
$orderRow->ownerName2 = $row->attributes()->ownerName2;
$orderRow->ownerID2 = $row->attributes()->ownerID2;
$orderRow->argName1 = $row->attributes()->argName1;
$orderRow->argID1 = $row->attributes()->argID1;
$orderRow->amount = $row->attributes()->amount;
$orderRow->balance = $row->attributes()->balance;
$orderRow->reason = $row->attributes()->reason;
$orderRow->characterID = $walletID;
$orderRow->save();
}
}
}
}
function testLastEntry()
{
$content = "What is the meaning of life?";
$date = date("Y-m-d");
$test_journal = new Journal($content, $date);
$test_journal->save();
$content2 = "I hate my dad";
$date2 = "2012-09-13";
$test_journal2 = new Journal($content2, $date2);
$test_journal2->save();
$result = Journal::lastEntry();
$this->assertEquals($date, $result);
}
$object->setUserId($data['userId']);
}
if (isset($data['journalDate'])) {
$object->setJournalDate($data['journalDate']);
}
if (isset($data['journalTitle'])) {
$object->setJournalTitle($data['journalTitle']);
}
if (isset($data['journalText'])) {
$object->setJournalText($data['journalText']);
}
if (isset($data['deleted'])) {
$object->setDeleted($data['deleted']);
}
if (isset($data['hash'])) {
$object->setHash($data['hash']);
}
if ($object->save()) {
$response = successResponse();
} else {
$response = errorResponse(RESPONSE_INTERNAL_ERROR);
}
} else {
$response = errorResponse(RESPONSE_BAD_REQUEST, 'tripId or journalId not set');
}
} else {
$response = errorResponse(RESPONSE_BAD_REQUEST, 'not GET or PUT response');
}
}
}
echo json_encode($response);
/**
* Test #11. SYNCH get an existent object.
* @depends testDataWipedBeforeTest
* @depends testGetExistent
*/
public function testSynchGet()
{
global $testTripId1;
global $testJournalId1;
global $synchAuthToken;
// Create the object and set attributes
$object = new Journal($testTripId1, $testJournalId1);
$object->setUserId('user');
$object->setJournalDate('2015-09-30');
$object->setJournalTitle('Journal Title');
$object->setJournalText('Journal Text');
$object->setDeleted('Y');
// Save the object and confirm a row is added to the database
$this->assertTrue($object->save());
$this->assertEquals(1, $this->countTestRows());
$data = array('hash' => $object->getHash());
$result = getApi('synchJournal.php', $data, $synchAuthToken);
$this->assertEquals(RESPONSE_SUCCESS, $result['resultCode']);
$this->assertTrue(isset($result['tripId']));
$this->assertTrue(isset($result['journalId']));
$this->assertTrue(isset($result['created']));
$this->assertTrue(isset($result['updated']));
$this->assertTrue(isset($result['userId']));
$this->assertTrue(isset($result['journalDate']));
$this->assertTrue(isset($result['journalTitle']));
$this->assertTrue(isset($result['journalText']));
$this->assertTrue(isset($result['deleted']));
$this->assertTrue(isset($result['hash']));
$this->assertEquals($testTripId1, $result['tripId']);
$this->assertEquals($testJournalId1, $result['journalId']);
$this->assertEquals($object->getCreated(), $result['created']);
$this->assertEquals($object->getUpdated(), $result['updated']);
$this->assertEquals('user', $result['userId']);
$this->assertEquals('2015-09-30', $result['journalDate']);
$this->assertEquals('Journal Title', $result['journalTitle']);
$this->assertEquals('Journal Text', $result['journalText']);
$this->assertEquals('Y', $result['deleted']);
$this->assertEquals($object->getHash(), $result['hash']);
}
/**
* Test #19.
* Iteration functions, when the journal entries have the same date
* @depends testIterationDifferentDates
*/
public function testIterationSameDate()
{
global $testTripId1;
global $testJournalId1, $testJournalId2;
global $testJournalId3, $testJournalId4;
// Creat journal entries. For testing purposes, the entries will
// be ordered in sequence (Id1, Id2, Id3, Id4). They are created
// in this order, since we're testing on creation timestamp
$journal1 = new Journal($testTripId1, $testJournalId1);
$journal1->setJournalDate('2015-10-01');
$this->assertTrue($journal1->save());
$journal2 = new Journal($testTripId1, $testJournalId2);
$journal2->setJournalDate('2015-10-01');
$this->assertTrue($journal2->save());
$journal3 = new Journal($testTripId1, $testJournalId3);
$journal3->setJournalDate('2015-10-01');
$this->assertTrue($journal3->save());
$journal4 = new Journal($testTripId1, $testJournalId4);
$journal4->setJournalDate('2015-10-01');
$this->assertTrue($journal4->save());
$test = Journal::getFirstJournal($testTripId1);
$this->assertEquals($testTripId1, $test->getTripId());
$this->assertEquals($testJournalId1, $test->getJournalId());
$test = Journal::getLastJournal($testTripId1);
$this->assertEquals($testTripId1, $test->getTripId());
$this->assertEquals($testJournalId4, $test->getJournalId());
$test = $journal1->getPreviousJournal();
$this->assertNull($test);
$test = $journal1->getNextJournal();
$this->assertEquals($testJournalId2, $test->getJournalId());
$test = $journal2->getPreviousJournal();
$this->assertEquals($testJournalId1, $test->getJournalId());
$test = $journal2->getNextJournal();
$this->assertEquals($testJournalId3, $test->getJournalId());
$test = $journal3->getPreviousJournal();
$this->assertEquals($testJournalId2, $test->getJournalId());
$test = $journal3->getNextJournal();
$this->assertEquals($testJournalId4, $test->getJournalId());
$test = $journal4->getPreviousJournal();
$this->assertEquals($testJournalId3, $test->getJournalId());
$test = $journal4->getNextJournal();
$this->assertNull($test);
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param PropelPDO $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(PropelPDO $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their corresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aJournal !== null) {
if ($this->aJournal->isModified() || $this->aJournal->isNew()) {
$affectedRows += $this->aJournal->save($con);
}
$this->setJournal($this->aJournal);
}
if ($this->aUserRelatedByCreatedBy !== null) {
if ($this->aUserRelatedByCreatedBy->isModified() || $this->aUserRelatedByCreatedBy->isNew()) {
$affectedRows += $this->aUserRelatedByCreatedBy->save($con);
}
$this->setUserRelatedByCreatedBy($this->aUserRelatedByCreatedBy);
}
if ($this->aUserRelatedByUpdatedBy !== null) {
if ($this->aUserRelatedByUpdatedBy->isModified() || $this->aUserRelatedByUpdatedBy->isNew()) {
$affectedRows += $this->aUserRelatedByUpdatedBy->save($con);
}
$this->setUserRelatedByUpdatedBy($this->aUserRelatedByUpdatedBy);
}
if ($this->isNew() || $this->isModified()) {
// persist changes
if ($this->isNew()) {
$this->doInsert($con);
} else {
$this->doUpdate($con);
}
$affectedRows += 1;
$this->resetModified();
}
if ($this->journalCommentsScheduledForDeletion !== null) {
if (!$this->journalCommentsScheduledForDeletion->isEmpty()) {
JournalCommentQuery::create()->filterByPrimaryKeys($this->journalCommentsScheduledForDeletion->getPrimaryKeys(false))->delete($con);
$this->journalCommentsScheduledForDeletion = null;
}
}
if ($this->collJournalComments !== null) {
foreach ($this->collJournalComments as $referrerFK) {
if (!$referrerFK->isDeleted() && ($referrerFK->isNew() || $referrerFK->isModified())) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->journalEntryImagesScheduledForDeletion !== null) {
if (!$this->journalEntryImagesScheduledForDeletion->isEmpty()) {
JournalEntryImageQuery::create()->filterByPrimaryKeys($this->journalEntryImagesScheduledForDeletion->getPrimaryKeys(false))->delete($con);
$this->journalEntryImagesScheduledForDeletion = null;
}
}
if ($this->collJournalEntryImages !== null) {
foreach ($this->collJournalEntryImages as $referrerFK) {
if (!$referrerFK->isDeleted() && ($referrerFK->isNew() || $referrerFK->isModified())) {
$affectedRows += $referrerFK->save($con);
}
}
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
public function createEmptyJournal()
{
$journal = new Journal();
$this->assertFalse($journal->save());
}
$todays_date = date("M-d-Y");
$entries = Journal::getAll();
$existing_entry = "";
foreach ($entries as $entry) {
if ($entry->getDate() == date("Y-m-d")) {
$existing_entry .= $entry->getContent();
}
}
return $app['twig']->render('journal/new_journal_entry.html.twig', array('date' => $todays_date, 'existing_entry' => $existing_entry));
});
$journal->post('/save_journal_entry', function () use($app) {
$entry = $_POST['entry'];
$time_zone = date_default_timezone_set('America/Los_Angeles');
$entry_date = date("Y-m-d");
$todays_entry = new Journal($entry, $entry_date);
$todays_entry->save();
return $app['twig']->render('journal/edit_journal_entry.html.twig', array('journal' => $todays_entry));
});
$journal->get('/entries/{id}', function ($id) use($app) {
$entry = Journal::find($id);
return $app['twig']->render('journal/entry.html.twig', array('entry' => $entry));
});
$journal->patch('/entries/{id}', function ($id) use($app) {
$entry = Journal::find($id);
$entry_content = $entry->getContent();
$latest_entry = $entry_content . " " . $_POST['content'];
$entry->updateContent($latest_entry);
return $app['twig']->render('journal/entry.html.twig', array('entry' => $entry));
});
$journal->patch('/entries_edit/{id}', function ($id) use($app) {
$entry = Journal::find($id);
