public function testShouldCopyToIssue()
{
//GIVEN
$appData = array("id" => 2, "title" => "test_app", "client" => 2);
$app = new AM_Model_Db_Application(array("data" => $appData));
$issueData = array("id" => 2, "title" => "test_user", "user" => 2);
$issue = new AM_Model_Db_Issue(array("data" => $issueData));
$issue->setApplication($app);
//WHEN
$this->revision->copyToIssue($issue);
$this->revision->refresh();
//THEN
$this->assertEquals(2, $this->revision->issue, "Issue id should change");
$this->assertEquals(2, $this->revision->user, "User id should change");
$queryTable = $this->getConnection()->createQueryTable("revision", "SELECT id, user, issue FROM revision ORDER BY id");
$expectedTable = $this->createFlatXMLDataSet(dirname(__FILE__) . "/_dataset/copy2issue.xml")->getTable("revision");
$this->assertTablesEqual($expectedTable, $queryTable);
}
public function testShouldNotMoveToSameIssue()
{
//GIVEN
$issueData = array("id" => 1, "title" => "test_issue1", "user" => 1, "application" => 1);
$issue = new AM_Model_Db_Issue(array("data" => $issueData));
$issue->setApplication($this->app);
//THEN
$this->pageMock->expects($this->never())->method('moveToRevision');
//WHEN
$this->revision->moveToIssue($issue);
$this->revision->refresh();
//THEN
$this->assertEquals(1, $this->revision->issue, "Issue id should not change");
$this->assertEquals(1, $this->revision->user, "User id should not change");
$queryTable = $this->getConnection()->createQueryTable("revision", "SELECT id, user, issue FROM revision ORDER BY id");
$expectedTable = $this->createFlatXMLDataSet(dirname(__FILE__) . "/_dataset/not_move2issue.xml")->getTable("revision");
$this->assertTablesEqual($expectedTable, $queryTable);
}
/**
* Copy revision to new issue
* @param AM_Model_Db_Issue $oIssue
* @param boolean $bInitExport Do we have to init export process
* @return AM_Model_Db_Revision
*/
public function copyToIssue(AM_Model_Db_Issue $oIssue, $bInitExport = true)
{
$aData = array();
$aData['issue'] = $oIssue->id;
$aData['user'] = $oIssue->user;
$aData['created'] = null;
$aData['updated'] = null;
$iIdOld = $this->id;
$oRevisionCopy = $this->copy($aData);
/* @var $oRevisionCopy AM_Model_Db_Revision */
$oRevisionCopy->setApplication($oIssue->getApplication());
$oRevisionCopy->setIssue($oIssue);
$oRevisionFrom = $this->getTable()->findOneBy('id', $iIdOld);
$oRevisionCopy->copyFromRevision($oRevisionFrom);
if ($bInitExport) {
$this->exportRevision();
}
return $this;
}
/**
* @return void
*/
public function show()
{
$oTermEntities = AM_Model_Db_Table_Abstract::factory('termEntity')->findAllBy(array('entity' => $this->primaryKeyValue, 'entity_type' => 'issue'));
$sExistingTags = '';
foreach ($oTermEntities as $oTermEntity) {
$oTag = AM_Model_Db_Table_Abstract::factory('term')->findOneBy('id', $oTermEntity->term);
$sExistingTags .= $oTag->title . ', ';
}
if (!$this->controls['tags']->getValue()) {
$this->controls['tags']->setValue($sExistingTags);
}
if ($this->primaryKeyValue) {
$oIssue = AM_Model_Db_Table_Abstract::factory('issue')->findOneBy('id', $this->primaryKeyValue);
if ($oIssue->image) {
$sIssueImageUri = AM_Tools::getImageUrl('270-150', AM_Model_Db_Issue::PRESET_ISSUE_IMAGE, $this->primaryKeyValue, $oIssue->image, 'png') . '?' . strtotime($oIssue->updated);
}
}
$aPricingPlans = AM_Model_Db_Issue::getPricingPlans();
$aRecord = array('appId' => $this->applicationId, 'imageUri' => isset($sIssueImageUri) ? $sIssueImageUri : null, 'pricingPlans' => $aPricingPlans);
if (isset($this->view->{$this->getName()})) {
$aRecord = array_merge($aRecord, $this->view->{$this->getName()});
}
$this->view->{$this->getName()} = $aRecord;
parent::show();
}
/**
* Get client application/issues/revision tree
*
* @param int $iApplicationId
* @param string $sUdid
* @return array
*/
public function getIssues($iApplicationId, $sUdid = null, $sPlatform = self::PLATFORM_IOS, $sPublisherToken = NULL)
{
$iApplicationId = intval($iApplicationId);
if ($iApplicationId <= 0) {
throw new AM_Api_Client_Exception(sprintf('Invalid application id "%d"', $iApplicationId));
}
$sPlatform = trim($sPlatform);
if (!in_array($sPlatform, $this->_aValidPlatforms)) {
$sPlatform = self::PLATFORM_IOS;
}
if (!is_null($sUdid)) {
$sUdid = trim($sUdid);
}
//Does udid belong to admin user
$bIsUdidUserAdmin = false;
$oDevice = null;
if (!empty($sUdid)) {
$oDevice = AM_Model_Db_Table_Abstract::factory('device')->findOneBy(array('identifer' => $sUdid));
if (!is_null($oDevice)) {
$this->getLogger()->debug(sprintf('Existing device given: %s', $sUdid));
$oUser = $oDevice->getUser();
if (!is_null($oUser)) {
$bIsUdidUserAdmin = (bool) $oUser->is_admin;
}
}
}
$aResult = array('code' => self::RESULT_SUCCESS, 'applications' => array());
$oApplications = AM_Model_Db_Table_Abstract::factory('application')->findAllBy(array('id' => $iApplicationId, 'deleted' => 'no'));
foreach ($oApplications as $oApplication) {
if ($this->authenticatePublisher($sPublisherToken, $oApplication->id, $oApplication) == self::RESULT_SUCCESS) {
$bIsUdidUserAdmin = true;
}
if (!is_null($oDevice)) {
if (!is_null($oDevice->getUser()) && $oApplication->client == $oDevice->getUser()->client) {
$bIsUdidUserAdmin = true;
}
}
$oVocabulary = AM_Model_Db_Table_Abstract::factory('application')->findOneBy('id', $iApplicationId)->getVocabularyTag();
$aApplicationTags = array();
$oApplicationTags = AM_Model_Db_Table_Abstract::factory('term')->getTagsForApplicationExisting($oVocabulary->id);
foreach ($oApplicationTags as $oApplicationTag) {
$aApplicationTags[] = array('id' => $oApplicationTag->id, 'title' => $oApplicationTag->title);
}
$aApplication = array('application_id' => $oApplication->id, 'application_title' => $oApplication->title, 'application_type' => $oApplication->type, 'application_description' => $oApplication->description, 'application_product_id' => $oApplication->product_id, 'application_notification_email' => $oApplication->{'nm_email_' . $sPlatform}, 'application_notification_email_title' => $oApplication->{'nt_email_' . $sPlatform}, 'application_notification_twitter' => $oApplication->{'nm_twitter_' . $sPlatform}, 'application_notification_facebook' => $oApplication->{'nm_fbook_' . $sPlatform}, 'application_preview' => $oApplication->preview, 'application_tags' => $aApplicationTags);
if ($oApplication->type == AM_Model_Db_ApplicationType::TYPE_RUE98WE) {
$aApplication['application_welcome_message'] = !empty($oApplication->welcome) ? str_replace("\n", "\\n", $oApplication->welcome) : null;
$aApplication['application_welcome_message_part2'] = !empty($oApplication->welcome_part2) ? str_replace("\n", "\\n", $oApplication->welcome_part2) : null;
$aApplication['application_message_for_readers'] = $oApplication->message_for_readers;
$aApplication['application_share_url'] = $oApplication->share_url;
$aApplication['application_share_message'] = $oApplication->share_message;
$aApplication['application_email'] = $oApplication->application_email;
$aApplication['application_contact_email_subject'] = $oApplication->contact_email_subject;
$aApplication['application_contact_email_text'] = $oApplication->contact_email_text;
$aApplication['application_subscribe_title'] = $oApplication->subscribe_title;
$aApplication['application_subscribe_button'] = $oApplication->subscribe_button;
$oSubscriptions = AM_Model_Db_Table_Abstract::factory('subscription')->findAllBy(array('application' => $oApplication->id));
$aApplication['application_subscriptions'] = array();
foreach ($oSubscriptions as $oSubscription) {
$aApplication['application_subscriptions'][$oSubscription->id] = array('button_title' => $oSubscription->button_title, 'itunes_id' => $oSubscription->itunes_id, 'google_id' => $oSubscription->google_id);
}
if (!empty($oApplication->newsstand_cover_image)) {
$aApplication['application_newsstand_cover_path'] = AM_Tools::getImageUrl('1066-600', AM_Model_Db_Application::PRESET_APPLICATION_IMAGE, $oApplication->id, $oApplication->newsstand_cover_image, 'png') . '?' . strtotime($oApplication->updated);
}
}
$aApplication['issues'] = array();
//Checking subscripton
$oSubscription = null;
if (!is_null($oDevice)) {
$aProductIds = array($oApplication->product_id);
foreach (AM_Api_Purchase::$aSubscriptionTypes as $sType) {
$aProductIds[] = $oApplication->product_id . '.' . $sType;
}
foreach ($aProductIds as $sProductId) {
$oSubscription = AM_Model_Db_Table_Abstract::factory('purchase')->findOneBy(array('device_id' => $oDevice->id, 'product_id' => $sProductId, 'deleted' => 'no'));
/* @var $oSubscription AM_Model_Db_Purchase */
if (!is_null($oSubscription)) {
$this->getLogger()->debug(sprintf('Found subscription for device: %s', $sUdid));
if ($oSubscription->isExpired()) {
$this->getLogger()->debug(sprintf('Subscription is expired: %s', $sUdid));
$oSubscription = null;
} else {
break;
}
}
}
}
//Looking for the issues
$aCriteria = array('application' => $oApplication->id, 'deleted' => 'no');
if (!$bIsUdidUserAdmin) {
$aCriteria['state'] = AM_Model_Db_State::STATE_PUBLISHED;
}
$oIssues = AM_Model_Db_Table_Abstract::factory('issue')->findAllBy($aCriteria);
foreach ($oIssues as $oIssue) {
if (!empty($oIssue->exclude)) {
continue;
}
$oTermEntities = AM_Model_Db_Table_Abstract::factory('termEntity')->findAllBy(array('entity' => $oIssue->id, 'entity_type' => 'issue'));
$aTags = array();
foreach ($oTermEntities as $oTermEntity) {
$oTag = AM_Model_Db_Table_Abstract::factory('term')->findOneBy('id', $oTermEntity->term);
$aTags[] = array('id' => $oTag->id, 'title' => $oTag->title);
}
$aIssue = array('issue_id' => $oIssue->id, 'issue_title' => $oIssue->title, 'issue_number' => $oIssue->number, 'issue_state' => AM_Model_Db_State::stateToName($oIssue->state), 'revisions' => array(), 'tags' => $aTags, 'issue_publish_date' => $oIssue->state == AM_Model_Db_State::STATE_PUBLISHED && !empty($oIssue->publish_date) ? $oIssue->publish_date : null, 'updated' => $oIssue->updated);
if ($oApplication->type == AM_Model_Db_ApplicationType::TYPE_GENERIC) {
$aIssue['paid'] = !empty($oIssue->paid) ? true : false;
$aIssue['issue_product_id'] = $oIssue->product_id;
}
if ($oApplication->type == AM_Model_Db_ApplicationType::TYPE_RUE98WE) {
$aIssue['issue_author'] = $oIssue->author;
$aIssue['issue_words'] = $oIssue->words;
$aIssue['issue_excerpt'] = !empty($oIssue->excerpt) ? str_replace("\n", "\\n", $oIssue->excerpt) : null;
$aIssue['issue_title_short'] = $oIssue->title_short;
$aIssue['issue_excerpt_short'] = !empty($oIssue->excerpt_short) ? str_replace("\n", "\\n", $oIssue->excerpt_short) : null;
$aIssue['issue_category'] = !empty($oIssue->category) ? str_replace("\n", "\\n", $oIssue->category) : null;
$aIssue['issue_pricing_plan'] = AM_Model_Db_Issue::pricingToName($oIssue->pricing_plan);
$aIssue['issue_google_play_id'] = $oIssue->google_play_id;
$aIssue['issue_itunes_id'] = $oIssue->itunes_id;
if (!empty($oIssue->image)) {
$aIssue['issue_image_large'] = AM_Tools::getImageUrl('1066-600', AM_Model_Db_Issue::PRESET_ISSUE_IMAGE, $oIssue->id, $oIssue->image, 'png') . '?' . strtotime($oIssue->updated);
$aIssue['issue_image_small'] = AM_Tools::getImageUrl('533-300', AM_Model_Db_Issue::PRESET_ISSUE_IMAGE, $oIssue->id, $oIssue->image, 'png') . '?' . strtotime($oIssue->updated);
}
}
//Prepearing help pages
$oHelpPages = AM_Model_Db_Table_Abstract::factory('issue_help_page')->findAllBy(array('id_issue' => $oIssue->id));
//Checking the payment
if (!is_null($oDevice)) {
if (!is_null($oSubscription)) {
$aIssue['paid'] = true;
$aIssue['subscription_type'] = $oSubscription->subscription_type;
} else {
$this->getLogger()->debug(sprintf('Checking purchase: %s', $sUdid));
$oPurchase = AM_Model_Db_Table_Abstract::factory('purchase')->findOneBy(array('device_id' => $oDevice->id, 'product_id' => $oIssue->product_id, 'deleted' => 'no'));
if (!is_null($oPurchase)) {
$this->getLogger()->debug(sprintf('Found purchase record: %s', $sUdid));
$aIssue['paid'] = true;
} else {
$this->getLogger()->debug(sprintf('Purchases not found: %s', $sUdid));
}
}
}
//Looking for the revisions
$aCriteria = array('issue' => $oIssue->id, 'deleted' => 'no');
if (!$bIsUdidUserAdmin) {
$aCriteria['state'] = AM_Model_Db_State::STATE_PUBLISHED;
}
$oRevisions = AM_Model_Db_Table_Abstract::factory('revision')->findAllBy($aCriteria);
foreach ($oRevisions as $oRevision) {
$aRevision = array('revision_id' => $oRevision->id, 'revision_title' => $oRevision->title, 'revision_state' => AM_Model_Db_State::stateToName($oRevision->state), 'revision_cover_image_list' => '', 'revision_video' => '', 'revision_created' => null, 'revision_color' => $oIssue->issue_color, 'summary_color' => $oIssue->summary_color, 'pastille_color' => $oIssue->pastille_color, 'revision_horizontal_mode' => $oIssue->static_pdf_mode, 'revision_orientation' => $oIssue->orientation, 'help_pages' => array(AM_Model_Db_IssueHelpPage::TYPE_HORIZONTAL => '', AM_Model_Db_IssueHelpPage::TYPE_VERTICAL => ''));
foreach ($oHelpPages as $oHelpPage) {
/* @var $oHelpPage AM_Model_Db_IssueHelpPage */
$aRevision['help_pages'][$oHelpPage->type] = (string) $oHelpPage->getResource()->getResourcePathForExport();
}
//Revision creation date
$oDate = new Zend_Date($oRevision->created);
$aRevision['revision_created'] = $oDate->toString(Zend_Date::ISO_8601);
$oPageCover = AM_Model_Db_Table_Abstract::factory('revision')->findOneBy('id', $oRevision->id)->getPageRoot();
/* @var $oPageCover AM_Model_Db_Page */
if (!is_null($oPageCover)) {
$aRevision['revision_cover_image_list'] = (string) $oPageCover->getPageCoverUri();
$aRevision['revision_video'] = (string) $oPageCover->getStartVideoUri();
}
$aIssue['revisions'][$oRevision->id] = $aRevision;
}
$aApplication['issues'][$oIssue->id] = $aIssue;
}
$aResult['applications'][$oApplication->id] = $aApplication;
}
return $aResult;
}
