public function execute_fix_wpw_date_expires()
{
$dbw = wfGetDB(DB_MASTER);
$dbw->begin();
$this->output("looking for wikiplace records to fix...\n");
$cond = 'wpw_date_expires > DATE_ADD(wpw_report_updated,INTERVAL 1 MONTH)';
$wikiplaces = WpWikiplace::search($cond, true);
foreach ($wikiplaces as $wikiplace) {
$subscription = WpSubscription::newFromId($wikiplace->getSubscriptionId());
$should_ends = WpWikiplace::calculateNextDateExpiresFromSubscription($subscription);
if ($subscription->isActive() && $subscription->getTmrStatus() == 'OK' && $wikiplace->getDateExpires() != $should_ends) {
$this->output("wpw_id=" . $wikiplace->getId() . "\tupdated=" . $wikiplace->getReportUpdated() . "\texpires=" . $wikiplace->getDateExpires() . "\n");
$this->output(" > wps\t\tstarts=" . $subscription->getStart() . "\tends=" . $subscription->getEnd() . "\n");
$this->output(" > should expire {$should_ends}\n");
if (!$this->isTest()) {
$this->output(" > fixing...\n");
$success = $dbw->update('wp_wikiplace', array('wpw_date_expires' => $should_ends), array('wpw_id' => $wikiplace->getId()));
if (!$success) {
$this->error("Error while updating wikiplace id=" . $wikiplace->getId(), true);
}
$this->output(" > fixed :)\n");
}
$this->output("\n");
}
}
$this->output("end\n");
$dbw->commit();
}
public function execute()
{
$when = WpSubscription::now();
$this->output("[" . WpSubscription::now() . ": Criteria end_date = {$when}]\n");
$this->output("[" . WpSubscription::now() . ": Searching subscriptions to renew...]\n");
$subs = WpSubscription::factoryAllOutdatedToRenew($when);
$this->output("[" . WpSubscription::now() . ": " . count($subs) . " subscription(s) to renew]\n");
foreach ($subs as $sub) {
$result = $sub->renew();
if ($result === true) {
// renewal OK
$tmr_status = $sub->getTmrStatus();
$this->output("wps_id[{$sub->getId()}], renewal OK, wps_wpp_id[{$sub->getPlanId()}], " . ($sub->isActive() ? 'ACTIVE' : 'UNACTIVE') . ", tmr_status = {$tmr_status}\n");
// renewal OK ==> tmr_status is OK or PE
if ($tmr_status == 'OK') {
$sub->sendOnPlanRenewalOK();
} else {
$sub->sendOnPlanRenewalPE();
}
} else {
// there was a problem
$this->output("wps_id[{$sub->getId()}], ERROR = {$result}\n");
}
}
$this->output("[" . WpSubscription::now() . ": Deactivating all remaining outdated subscriptions...]\n");
if (($nb = WpSubscription::deactivateAllOutdated($when)) === false) {
$this->output("ERROR\n");
} else {
$this->output("OK, {$nb} subscription(s) deactivated\n");
}
$this->output("[" . WpSubscription::now() . ": END]\n");
}
public function execute($par)
{
$this->setHeaders();
// sets robotPolicy = "noindex,nofollow" + set page title
$user = $this->getUser();
$output = $this->getOutput();
$request = $this->getRequest();
// Check rights and block if necessary
if (!$this->userCanExecute($user)) {
// If anon, redirect to login
if ($user->isAnon()) {
$output->redirect($this->getTitleFor('UserLogin')->getLocalURL(array('returnto' => $this->getFullTitle())), '401');
return;
}
// Else display an error page.
$this->displayRestrictionError();
return;
}
if (isset($par) && $par != '') {
$explosion = explode(':', $par);
if (count($explosion) == 1) {
$this->action = $explosion[0];
$this->category_id = $this->getRequest()->getText('category', null);
} else {
if (count($explosion) == 2) {
$this->action = $explosion[0];
$this->category_id = $explosion[1];
}
}
} else {
$this->action = $this->getRequest()->getText('action', null);
$this->category_id = $this->getRequest()->getText('category', null);
}
if ($user->isAllowed(WP_ADMIN_RIGHT)) {
$this->userIsAdmin = true;
$this->userInvitationsCategories = WpInvitationCategory::factoryAllAvailable(true);
// with admin categories
} else {
$this->userIsAdmin = false;
$this->userActiveSubscription = WpSubscription::newActiveByUserId($user->getId());
$this->userInvitationsCategories = WpInvitationCategory::factoryAllAvailable(false);
// without admin categories
$this->setUsageThisMonth();
$this->setUsageLeftThisMonth();
}
$this->msgType = $request->getText('msgtype', null);
$msgKey = $request->getText('msgkey', null);
if ($msgKey != null) {
$msg = wfMessage($msgKey);
if ($msg->exists()) {
$this->msg = $msg;
}
}
$this->display();
}
public function execute()
{
$lifespan = intval($this->getOption('lifespan', 60));
if ($lifespan < 1) {
$lifespan = 60;
}
$this->output("[" . WpSubscription::now() . ": Updating usages, considering {$lifespan} minutes lifespan...]\n");
// updates all users'wikiplaces having lifespan expired
$ok = WpWikiplace::updateOutdatedUsages(null, $lifespan);
if ($ok === false) {
$this->output("ERROR: {$ok}\n");
} else {
// $this->output("OK: $ok record(s) updated\n");
}
// $this->output( "[".WpSubscription::now().": Archiving and resetting monthly usages...]\n" );
$ok = WpWikiplace::archiveAndResetExpiredUsages();
if ($ok === false) {
$this->output("ERROR: {$ok}\n");
} else {
// $this->output("OK: $ok record(s) archived and reset\n");
}
$this->output("[" . WpSubscription::now() . ": END]\n");
}
/**
*
* @param WpSubscription $subscription
* @return string MySQL DATETIME string format
*/
public static function calculateNextDateExpiresFromSubscription($subscription)
{
// contains the needed day/hour/minute/second
$end = date_create_from_format('Y-m-d H:i:s', $subscription->getEnd(), new DateTimeZone('GMT'));
$now = new DateTime('now', new DateTimeZone('GMT'));
$expire = date_create_from_format('Y-m-d H:i:s', $now->format('Y-m-') . $end->format('d H:i:s'), new DateTimeZone('GMT'));
if ($expire < $now) {
$expire->modify('+1 month');
}
return $expire->format('Y-m-d H:i:s');
}
/**
* Search for a subscription attached to this transaction, and if found, update it.
* @param array $tmr
* @return boolean False (=stop hook) only if the transaction is for a subscription.
*/
public static function onTransactionUpdated($tmr)
{
$sub = WpSubscription::newFromTransactionId($tmr['tmr_id']);
if ($sub === null) {
return true;
// we are not concerned, so don't stop processing
}
$sub->onTransactionUpdated($tmr);
return false;
// the transaction update has been processed, so no other hook should take care of it
}
protected function displayList()
{
$user = $this->getUser();
$output = $this->getOutput();
/**
* @Todo BAD, does 2 db query for same results! And uses TP for just 1 line!
*/
$tp = new WpSubscriptionsTablePager();
$tp->setSelectConds(array('wps_buyer_user_id' => $this->getUser()->getId()));
$subs = WpSubscription::newByUserId($user->getId());
if (!isset($subs)) {
if ($this->msgKey != null) {
$tp->setHeader(wfMessage('wp-subscriptionslist-noactive-header')->parse());
} else {
$this->action = self::ACTION_NEW;
$this->display();
return;
}
} elseif ($subs->getTmrStatus() == 'PE') {
$tp->setHeader(wfMessage('wp-subscriptionslist-pending-header')->parse());
} elseif (!$subs->isActive()) {
$tp->setHeader(wfMessage('wp-subscriptionslist-noactive-header')->parse());
} else {
$tp->setHeader(wfMessage('wp-subscriptionslist-header')->parse());
$tp->setFooter(wfMessage('wp-subscriptionslist-footer')->parse());
}
$output->addHTML($tp->getWholeHtml());
}
/**
*
* @return WpInvitationCategory Array of WpInvitationCategory (indexes are categories identifiers)
*/
public static function factoryAllAvailable($inldudeAdmin = false)
{
$dbr = wfGetDB(DB_SLAVE);
$now = $dbr->addQuotes(WpSubscription::now());
$conds = array('wpic_start_date <= ' . $now, 'wpic_end_date >= ' . $now);
if (!$inldudeAdmin) {
$conds[] = 'wpic_monthly_limit > 0';
}
$results = $dbr->select(array('wp_invitation_category', 'wp_wpi_wpp', 'wp_plan'), '*', $conds, __METHOD__, array('ORDER BY' => 'wpic_id'), array('wp_wpi_wpp' => array('LEFT JOIN', 'wpic_id = wpip_wpic_id'), 'wp_plan' => array('LEFT JOIN', 'wpip_wpp_id = wpp_id')));
return self::factoryFromResults($results);
}
public function displayCreateSubpage()
{
$user = $this->getUser();
$wikiplaces = null;
if ($this->name != null) {
$wikiplace = $this->checkWikiPlace($this->name, true);
if (is_null($wikiplace)) {
return;
}
$wikiplaces = array($wikiplace);
if (($reason = WpSubscription::userCanCreateNewPage($user, $wikiplace)) !== true) {
$this->action = self::ACTION_CONSULT_WIKIPLACE;
$this->msgKey = $reason;
$this->msgType = 'error';
$this->display();
return;
}
}
$wikiplaceSelect = $this->populateWikiPlaceSelect(array('type' => 'select', 'label-message' => 'wp-parent-wikiplace-field', 'section' => 'createpage-section', 'help-message' => 'wp-createpage-wikiplace-help', 'validation-callback' => array($this, 'validateMemberWikiplaceID'), 'options' => array()), $wikiplaces, $this->name);
if (count($wikiplaceSelect['options']) == 0) {
$this->action = self::ACTION_LIST_WIKIPLACES;
$this->msgKey = 'wp-create-wp-first';
$this->msgType = 'error';
$this->display();
return;
}
$formDescriptor = array('WpId' => $wikiplaceSelect, 'SpName' => array('type' => 'text', 'label-message' => 'wp-name-field', 'section' => 'createpage-section', 'help-message' => 'wp-createpage-name-help', 'validation-callback' => array($this, 'validateNewSubpageName')), 'Template' => array('label-message' => 'wp-template-field', 'section' => 'createpage-section', 'help-message' => 'wp-createpage-template-help', 'class' => 'WpSubpageTemplate'), 'License' => array('label-message' => 'wp-license-field', 'section' => 'createpage-section', 'help-message' => 'wp-createpage-license-help', 'class' => 'Licenses'), 'CreateTalk' => array('class' => 'HTMLCheckField', 'label-message' => 'wp-createtalk-field', 'section' => 'createpage-section', 'help-message' => 'wp-createpage-createtalk-help', 'default' => true));
$htmlForm = new HTMLFormS($formDescriptor);
$htmlForm->addHeaderText(wfMessage('wp-createpage-header')->parse());
$htmlForm->setMessagePrefix('wp');
$htmlForm->setTitle($this->getTitleForCurrentRequest());
$htmlForm->setSubmitCallback(array($this, 'processCreateSubpage'));
$htmlForm->setSubmitText(wfMessage('wp-create')->text());
if ($htmlForm->show()) {
$this->getOutput()->addHTML(wfMessage('wp-create-sp-success', $this->homepageString, $this->subpageString)->parse());
}
}
/**
*
* @param WpInvitationCategory $invitationCategory
* @param User $fromUser
*
* @param string $code
* @param string $toEmail
* @param int $counter
* @return WpInvitation
*/
public static function create($invitationCategory, $fromUser, $code, $toEmail = null, $counter = 1)
{
$invitationCategoryId = $invitationCategory->getId();
$code = strtolower($code);
$dbw = wfGetDB(DB_MASTER);
$created = WpSubscription::now();
$dbw->begin();
$fromUserId = $fromUser->getId();
// With PostgreSQL, a value is returned, but null returned for MySQL because of autoincrement system
$id = $dbw->nextSequenceValue('wp_invitation_wpi_id_seq');
$success = $dbw->insert('wp_invitation', array('wpi_id' => $id, 'wpi_code' => $code, 'wpi_to_email' => $toEmail, 'wpi_from_user_id' => $fromUserId, 'wpi_date_created' => $created, 'wpi_counter' => $counter, 'wpi_wpic_id' => $invitationCategoryId));
// Setting id from auto incremented id in DB
$id = $dbw->insertId();
$dbw->commit();
if (!$success) {
return null;
}
return new self($id, $code, $toEmail, $fromUserId, $created, null, $counter, $invitationCategoryId);
}
/**
* Returns offers, that can be talen as renewal, and will be still accessible at $when, with at least theses quotas
* @param int $nb_wikiplaces Optional, default = 0
* @param int $nb_wikiplace_pages Optional, default = 0
* @param int $diskspace in MB Optional, default = 0
* @param string $when Optional, to ensure that the plan is available at this date, default = now
* @return array array of WpPlans
* @todo also add plan available using an invitation
*/
public static function factoryAvailableForRenewal($nb_wikiplaces = 0, $nb_wikiplace_pages = 0, $diskspace = 0, $when = null)
{
if ($when == null) {
$when = WpSubscription::now();
}
$dbr = wfGetDB(DB_SLAVE);
$when = $dbr->addQuotes($when);
$conds = $dbr->makeList(array("wpp_renew_wpp_id" => 0, "wpp_start_date <= {$when}", "wpp_end_date > {$when}", "wpp_invitation_only" => 0, "wpp_nb_wikiplaces >= {$nb_wikiplaces}", "wpp_nb_wikiplace_pages >= {$nb_wikiplace_pages}", "wpp_diskspace >= {$diskspace}"), LIST_AND);
$result = $dbr->select('wp_plan', '*', $conds, __METHOD__);
$offers = array();
foreach ($result as $row) {
$offers[] = self::constructFromDatabaseRow($row);
}
$dbr->freeResult($result);
return $offers;
}
public function execute()
{
$deadline = intval($this->getOption('deadline', 0));
if ($deadline < 0) {
$deadline = 0;
}
$when = WpSubscription::now(0, 0, 0, $deadline);
$this->output("[" . WpSubscription::now() . ": Searching subscriptions to renew before {$when} which has not been notified ...]\n");
$subs = WpSubscription::factoryActiveEndSoonToNotify($when);
$this->output("[" . WpSubscription::now() . ": " . count($subs) . " subscription(s) to check...]\n");
foreach ($subs as $sub) {
$next_plan_id = $sub->getRenewalPlanId();
$msg = "wps_id[{$sub->getId()}], ";
if ($next_plan_id == WPP_ID_NORENEW) {
$msg .= 'do not renew';
$sub->sendOnNoRenewalSoon();
$sub->setRenewalPlanNotified();
} else {
$msg .= "renew_wpp_id[{$next_plan_id}]: ";
// a plan is defined has renewal, check if it's a good choice...
$renewal_date = $sub->getEnd();
$next_plan = $sub->getRenewalPlan();
$user_id = $sub->getBuyerUserId();
if ($next_plan == null) {
// should not occur, but ensure database is not corrupted, correct if needed
// change to the current plan suggested renewal one
$curr_plan = $sub->getPlan();
$new_next_plan;
if ($curr_plan == null) {
// should not occur, but ... just in case
$new_next_plan = WpPlan::newFromId(WP_FALLBACK_PLAN_ID);
} else {
$new_next_plan = $curr_plan->getRenewalPlan($renewal_date);
}
$new_next_plan_id = $new_next_plan->getId();
// update and flag as problem reported, as we will send an email to user
$sub->setRenewalPlanId($new_next_plan_id, true);
$msg .= "doesn't exist, changed to = {$new_next_plan_id}";
$sub->sendOnRenewalSoonWarning('wp-plan-not-available-renewal', $new_next_plan);
} elseif (!$next_plan->hasSufficientQuotas(WpWikiplace::countWikiplacesOwnedByUser($user_id), WpPage::countPagesOwnedByUser($user_id), WpPage::countDiskspaceUsageByUser($user_id))) {
// change to the current plan suggested renewal one
$curr_plan = $sub->getPlan();
$new_next_plan = $curr_plan->getRenewalPlan($renewal_date);
$new_next_plan_id = $new_next_plan->getId();
// update and flag as problem reported, as we will send an email to user
$sub->setRenewalPlanId($new_next_plan_id, true);
$msg .= "unsufficient quotas, changed to = {$new_next_plan_id}";
$sub->sendOnRenewalSoonWarning('wp-insufficient-quota', $next_plan);
} elseif (!$next_plan->isAvailableForRenewal($renewal_date)) {
// ensure the next plan will still be available
// change to the planned renwal plan suggested renewal one
$new_next_plan = $next_plan->getRenewalPlan($renewal_date);
$new_next_plan_id = $new_next_plan->getId();
// update and flag as problem reported, as we will send an email to user
$sub->setRenewalPlanId($new_next_plan_id, true);
$msg .= "will not be available, changed to = {$new_next_plan_id}";
$sub->sendOnRenewalSoonWarning('wp-plan-not-available-renewal', $next_plan);
} else {
// it seems to be ok :)
$msg .= 'renewal will be ok';
$sub->sendOnRenewalSoonValid();
$sub->setRenewalPlanNotified();
}
}
$this->output("{$msg}\n");
}
$this->output("[" . WpSubscription::now() . ": END]\n");
}
private function subscribeFor($plan_id = null, $user_name = null, $confirm = false)
{
$output = $this->getOutput();
$output->addWikiText("=== Subscribe For ===");
$this->prettyOutput($output, array('plan' => $plan_id, 'user' => $user_name));
$output->addWikiText("----");
if (empty($plan_id) || !is_numeric($plan_id)) {
$output->addWikiText("=== Specify a plan id in integer format. ===");
return;
}
$plan = WpPlan::newFromId($plan_id);
if (is_null($plan)) {
$output->addWikiText("=== No plan with that identifier was found. ===");
return;
}
$output->addWikiText("=== Plan ===");
$price = $plan->getPrice();
$this->prettyOutput($output, array('id' => $plan->getId(), 'name' => $plan->getName(), 'period' => $plan->getPeriod() . ' month(s)', 'by invitation only' => $plan->isInvitationRequired() ? 'yes' : 'no', 'price' => $price['amount'] . ' ' . $price['currency']));
$output->addWikiText("----");
if (empty($user_name)) {
$output->addWikiText("=== Specify a user name. ===");
return;
}
$user = User::newFromName($user_name);
if (!$user || $user->getId() == 0) {
$output->addWikiText("=== ERROR The user doesn't exist ! ===");
return;
}
$output->addWikiText("=== User to subscribe for ===");
$this->prettyOutput($output, array('id' => $user->getId(), 'name' => $user->getName(), 'email' => $user->getEmail(), 'email confirmed' => $user->isEmailConfirmed() ? 'yes' : 'no', 'timestamp of account creation' => $user->getRegistration()));
if (!$user->isEmailConfirmed()) {
$output->addWikiText("==== WARNING Email is not confirmed ! ====");
}
$last_subscription = WpSubscription::newByUserId($user->getId());
if (is_null($last_subscription)) {
$output->addWikiText("=== The user doesn't have any subscription. ===");
} else {
$output->addWikiText("==== Last subscription ====");
$this->prettyOutput($output, array('id' => $last_subscription->getId(), 'starts' => $last_subscription->getStart(), 'ends' => $last_subscription->getEnd(), 'active' => $last_subscription->isActive() ? "yes" : "no", 'transaction status' => $last_subscription->getTmrStatus()));
if ($last_subscription->isActive()) {
$output->addWikiText("==== ERROR Last subscription is still active ! ====");
return;
}
$lastPlan = $last_subscription->getPlan();
if (is_null($lastPlan)) {
$output->addWikiText("=== ERROR The subscribed plan doesn't exist ! ===");
return;
}
$output->addWikiText("==== Subscribed plan ====");
$price = $lastPlan->getPrice();
$this->prettyOutput($output, array('id' => $lastPlan->getId(), 'name' => $lastPlan->getName(), 'period' => $lastPlan->getPeriod() . ' month(s)', 'by invitation only' => $lastPlan->isInvitationRequired() ? 'yes' : 'no', 'price' => $price['amount'] . ' ' . $price['currency']));
}
$check = WpSubscription::canSubscribe($user);
if (is_string($check)) {
$output->addWikiText("=== ERROR The user cannot take a subscription ! ===");
$output->addWikiText($check);
return;
} else {
$output->addWikiText("=== The user can take a subscription. ===");
}
$output->addWikiText("----");
if ($confirm !== true) {
$output->addWikiText("=== To confirm ===");
$output->addHTML($this->getLink(self::ACTION_SUBSCRIBER_FOR, array('plan' => $plan_id, 'user' => $user_name), true));
} else {
$subscription = WpSubscription::subscribe($user, $plan);
if (is_null($subscription)) {
$output->addWikiText("=== An error occured ! ===");
} else {
$output->addWikiText("== Done ! ==");
$output->addWikiText("==== New subscription ====");
$this->prettyOutput($output, array('id' => $subscription->getId(), 'buyer user id' => $subscription->getBuyerUserId(), 'starts' => $subscription->getStart(), 'ends' => $subscription->getEnd(), 'active' => $subscription->isActive() ? "yes" : "no", 'transaction status' => $subscription->getTmrStatus()));
}
}
}
private function displayOffers()
{
# block_join
$html = Xml::openElement('div', array('class' => 'block block_join'));
if (is_null(WpSubscription::newActiveByUserId($this->getUser()->getId()))) {
$blockjoin = array('sz-blockjoin0', 'sz-blockjoin1', 'sz-blockjoin2');
} else {
$blockjoin = array('sz-blockjoin0b', 'sz-blockjoin1', 'sz-blockjoin2');
}
foreach ($blockjoin as $box) {
$html .= Xml::openElement('a', array('class' => 'fade', 'href' => wfMessage($box . '-href')->text()));
$html .= Xml::element('span', array(), wfMessage($box)->text());
$html .= Html::rawElement('small', array(), wfMessage($box . '-catch')->parse());
$html .= Xml::closeElement('a');
}
# /block_join
$html .= Xml::closeElement('div');
return $html;
}
