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() { $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"); }
/** * Reset all usages when outdated * @return int/string int:Nb of Wikiplace usages reset if OK, string: the message if an error occured */ public static function archiveAndResetExpiredUsages() { $dbw = wfGetDB(DB_MASTER); $dbw->begin(); $now = $dbw->addQuotes(WpSubscription::now()); // archiving current usages // 3rd arg : must be an associative array of the form // array( 'dest1' => 'source1', ...). Source items may be literals // rather than field names, but strings should be quoted with // DatabaseBase::addQuotes() $success = $dbw->insertSelect('wp_old_usage', 'wp_wikiplace', array('wpou_wpw_id' => 'wpw_id', 'wpou_end_date' => $now, 'wpou_monthly_page_hits' => 'wpw_monthly_page_hits', 'wpou_monthly_bandwidth' => 'wpw_monthly_bandwidth'), array('wpw_date_expires < ' . $now), __METHOD__, array('IGNORE')); if (!$success) { return 'error while renewing archiving outdated usages.'; } // renewing all active outdated records $success = $dbw->update('wp_wikiplace', array('wpw_date_expires = DATE_ADD(wpw_date_expires,INTERVAL 1 MONTH)', 'wpw_previous_total_page_hits = (wpw_monthly_page_hits + wpw_previous_total_page_hits)', 'wpw_monthly_page_hits' => 0, 'wpw_monthly_bandwidth' => 0), array('wpw_date_expires < ' . $now)); if (!$success) { return 'error while resetting outdated usages'; } $updated = $dbw->affectedRows(); $dbw->commit(); return $updated; }
/** * * @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); }
/** * * @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"); }