/** * Returns the select tag for choosing the repetition type * * @return string */ public static function getSelectTag() { $s = "<select name=\"repetitionTypes\"><option value=\"-1\">" . __('ACCOUNT_TASK_REPETITION_DO_NOT_REPEAT') . "</option>"; $c = new Criteria(); $c->addAscendingOrderByColumn(PcRepetitionPeer::SORT_ORDER); $repetitions = PcRepetitionPeer::doSelect($c); foreach ($repetitions as $repetition) { $s .= "<option value=\"{$repetition->getId()}\">{$repetition->getLocalizedHumanExpression()}</option>"; if ($repetition->hasDividerBelow()) { $s .= "<option value=\"0\">-------------------</option>"; } } $s .= "</select>"; return $s; }
/** * Retrieve multiple objects by pkey. * * @param array $pks List of primary keys * @param PropelPDO $con the connection to use * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function retrieveByPKs($pks, PropelPDO $con = null) { if ($con === null) { $con = Propel::getConnection(PcRepetitionPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(PcRepetitionPeer::DATABASE_NAME); $criteria->add(PcRepetitionPeer::ID, $pks, Criteria::IN); $objs = PcRepetitionPeer::doSelect($criteria, $con); } return $objs; }
/** * Get the associated PcRepetition object * * @param PropelPDO Optional Connection object. * @return PcRepetition The associated PcRepetition object. * @throws PropelException */ public function getPcRepetition(PropelPDO $con = null) { if ($this->aPcRepetition === null && $this->repetition_id !== null) { $this->aPcRepetition = PcRepetitionPeer::retrieveByPk($this->repetition_id); /* The following can be used additionally to guarantee the related object contains a reference to this object. This level of coupling may, however, be undesirable since it could result in an only partially populated collection in the referenced object. $this->aPcRepetition->addPcTasks($this); */ } return $this->aPcRepetition; }
/** * Populates the object using an array. * * This is particularly useful when populating an object from one of the * request arrays (e.g. $_POST). This method goes through the column * names, checking to see whether a matching key exists in populated * array. If so the setByName() method is called for that column. * * You can specify the key type of the array by additionally passing one * of the class type constants BasePeer::TYPE_PHPNAME, BasePeer::TYPE_STUDLYPHPNAME, * BasePeer::TYPE_COLNAME, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_NUM. * The default key type is the column's phpname (e.g. 'AuthorId') * * @param array $arr An array to populate the object from. * @param string $keyType The type of keys the array uses. * @return void */ public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME) { $keys = PcRepetitionPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setId($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setHumanExpression($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setComputerExpression($arr[$keys[2]]); } if (array_key_exists($keys[3], $arr)) { $this->setInitialComputerExpression($arr[$keys[3]]); } if (array_key_exists($keys[4], $arr)) { $this->setSpecial($arr[$keys[4]]); } if (array_key_exists($keys[5], $arr)) { $this->setNeedsParam($arr[$keys[5]]); } if (array_key_exists($keys[6], $arr)) { $this->setIsParamCardinal($arr[$keys[6]]); } if (array_key_exists($keys[7], $arr)) { $this->setMinParam($arr[$keys[7]]); } if (array_key_exists($keys[8], $arr)) { $this->setMaxParam($arr[$keys[8]]); } if (array_key_exists($keys[9], $arr)) { $this->setSortOrder($arr[$keys[9]]); } if (array_key_exists($keys[10], $arr)) { $this->setHasDividerBelow($arr[$keys[10]]); } if (array_key_exists($keys[11], $arr)) { $this->setIcalRrule($arr[$keys[11]]); } if (array_key_exists($keys[12], $arr)) { $this->setUpdatedAt($arr[$keys[12]]); } if (array_key_exists($keys[13], $arr)) { $this->setCreatedAt($arr[$keys[13]]); } }
/** * Selects a collection of PcTask objects pre-filled with all related objects except PcList. * * @param Criteria $criteria * @param PropelPDO $con * @param String $join_behavior the type of joins to use, defaults to Criteria::LEFT_JOIN * @return array Array of PcTask objects. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doSelectJoinAllExceptPcList(Criteria $criteria, $con = null, $join_behavior = Criteria::LEFT_JOIN) { $criteria = clone $criteria; // Set the correct dbName if it has not been overridden // $criteria->getDbName() will return the same object if not set to another value // so == check is okay and faster if ($criteria->getDbName() == Propel::getDefaultDB()) { $criteria->setDbName(self::DATABASE_NAME); } PcTaskPeer::addSelectColumns($criteria); $startcol2 = PcTaskPeer::NUM_COLUMNS - PcTaskPeer::NUM_LAZY_LOAD_COLUMNS; PcRepetitionPeer::addSelectColumns($criteria); $startcol3 = $startcol2 + (PcRepetitionPeer::NUM_COLUMNS - PcRepetitionPeer::NUM_LAZY_LOAD_COLUMNS); $criteria->addJoin(PcTaskPeer::REPETITION_ID, PcRepetitionPeer::ID, $join_behavior); // symfony_behaviors behavior foreach (sfMixer::getCallables(self::getMixerPreSelectHook(__FUNCTION__)) as $sf_hook) { call_user_func($sf_hook, 'BasePcTaskPeer', $criteria, $con); } $stmt = BasePeer::doSelect($criteria, $con); $results = array(); while ($row = $stmt->fetch(PDO::FETCH_NUM)) { $key1 = PcTaskPeer::getPrimaryKeyHashFromRow($row, 0); if (null !== ($obj1 = PcTaskPeer::getInstanceFromPool($key1))) { // We no longer rehydrate the object, since this can cause data loss. // See http://propel.phpdb.org/trac/ticket/509 // $obj1->hydrate($row, 0, true); // rehydrate } else { $cls = PcTaskPeer::getOMClass(false); $obj1 = new $cls(); $obj1->hydrate($row); PcTaskPeer::addInstanceToPool($obj1, $key1); } // if obj1 already loaded // Add objects for joined PcRepetition rows $key2 = PcRepetitionPeer::getPrimaryKeyHashFromRow($row, $startcol2); if ($key2 !== null) { $obj2 = PcRepetitionPeer::getInstanceFromPool($key2); if (!$obj2) { $cls = PcRepetitionPeer::getOMClass(false); $obj2 = new $cls(); $obj2->hydrate($row, $startcol2); PcRepetitionPeer::addInstanceToPool($obj2, $key2); } // if $obj2 already loaded // Add the $obj1 (PcTask) to the collection in $obj2 (PcRepetition) $obj2->addPcTask($obj1); } // if joined row is not null $results[] = $obj1; } $stmt->closeCursor(); return $results; }
public function executeGetRepetitionParamSelectTag(sfWebRequest $request) { $id = $request->getParameter('id'); $value = $request->getParameter('value'); if (!$id) { return $this->renderText(''); } $summary = ''; $tag = ''; if ($repetition = PcRepetitionPeer::retrieveByPk($id)) { if ($repetition->needsParam()) { if ($repetition->getSpecial() == 'selected_wkdays') { $weekdaysSelected = DateFormat::fromIntegerToWeekdaysSetForRepetition($value); $selectedSun = $weekdaysSelected['sun'] ? "checked='checked'" : ''; $selectedMon = $weekdaysSelected['mon'] ? "checked='checked'" : ''; $selectedTue = $weekdaysSelected['tue'] ? "checked='checked'" : ''; $selectedWed = $weekdaysSelected['wed'] ? "checked='checked'" : ''; $selectedThu = $weekdaysSelected['thu'] ? "checked='checked'" : ''; $selectedFri = $weekdaysSelected['fri'] ? "checked='checked'" : ''; $selectedSat = $weekdaysSelected['sat'] ? "checked='checked'" : ''; $tag = ""; if (PcUserPeer::getLoggedInUser()->getWeekStart() == 0) { $tag .= "<input type='checkbox' id='wdfr_sun' name='weekdaysForRepetition' value='sun' {$selectedSun} ><label for='wdfr_sun'>" . __('ACCOUNT_DOW_SUN') . "</label>"; } $tag .= "<input type='checkbox' id='wdfr_mon' name='weekdaysForRepetition' value='mon' {$selectedMon} /><label for='wdfr_mon'>" . __('ACCOUNT_DOW_MON') . "</label>"; $tag .= "<input type='checkbox' id='wdfr_tue' name='weekdaysForRepetition' value='tue' {$selectedTue} /><label for='wdfr_tue'>" . __('ACCOUNT_DOW_TUE') . "</label>"; $tag .= "<input type='checkbox' id='wdfr_wed' name='weekdaysForRepetition' value='wed' {$selectedWed} /><label for='wdfr_wed'>" . __('ACCOUNT_DOW_WED') . "</label>"; $tag .= "<input type='checkbox' id='wdfr_thu' name='weekdaysForRepetition' value='thu' {$selectedThu} /><label for='wdfr_thu'>" . __('ACCOUNT_DOW_THU') . "</label>"; $tag .= "<input type='checkbox' id='wdfr_fri' name='weekdaysForRepetition' value='fri' {$selectedFri} /><label for='wdfr_fri'>" . __('ACCOUNT_DOW_FRI') . "</label>"; $tag .= "<input type='checkbox' id='wdfr_sat' name='weekdaysForRepetition' value='sat' {$selectedSat} /><label for='wdfr_sat'>" . __('ACCOUNT_DOW_SAT') . "</label>"; if (PcUserPeer::getLoggedInUser()->getWeekStart() == 1) { $tag .= "<input type='checkbox' id='wdfr_sun' name='weekdaysForRepetition' value='sun' {$selectedSun} ><label for='wdfr_sun'>" . __('ACCOUNT_DOW_SUN') . "</label>"; } $summary = $tag; } else { $min = $repetition->getMinParam(); $max = $repetition->getMaxParam(); $tag = "<select name=\"repetitionParam\">"; for ($i = $min; $i <= $max; $i++) { $selected = $value == $i ? 'selected="selected"' : ''; $label = $repetition->isParamCardinal() ? $i : PcUtils::getOrdinalFromCardinal($i); $tag .= "<option value=\"{$i}\" {$selected}>{$label}</option>"; } $tag .= "</select>"; $summary = str_replace(__('ACCOUNT_TASK_REPETITION_SELECT_LATER'), $tag, $repetition->getLocalizedHumanExpression()); } } } return $this->renderText($summary); }
/** * Re-arranges due date to the next occurrence on the repetition. * IMPORTANT: if the task hasn't got a due date, it uses the today's date * * @param bool $isInitialAdjustment - whether we want just to compute an initial adjustment */ public function setNextOccurrence($isInitialAdjustment = false) { $repetition = PcRepetitionPeer::retrieveByPk($this->getRepetitionId()); if ($repetition->getSpecial() == 'selected_wkdays') { $startingPointForDueDateTimestamp = time() > $this->getDueDate('U') ? time() : $this->getDueDate('U'); $weekdaysSet = DateFormat::fromIntegerToWeekdaysSetForRepetition($this->getRepetitionParam()); $closestWeekdayInSet = '9999999999'; // this big to make sure the first attempt of the following loop will set a value foreach ($weekdaysSet as $k => $v) { if ($v) { $next = $isInitialAdjustment ? '' : 'next'; $closestWeekdayInSetTemp = strtotime("{$next} {$k}", $startingPointForDueDateTimestamp); // i.e.: next mon if ($closestWeekdayInSetTemp < $closestWeekdayInSet) { $closestWeekdayInSet = $closestWeekdayInSetTemp; } } } $nextTimestamp = $closestWeekdayInSet; } else { $rce = $isInitialAdjustment ? $repetition->getInitialComputerExpression() : $repetition->getComputerExpression(); $param = $repetition->isParamCardinal() ? $this->getRepetitionParam() : PcUtils::getOrdinalFromCardinal($this->getRepetitionParam()); $rce = str_replace('_X_', $param, $rce); //$rce = str_replace('_Xlong_', PcUtils::getOrdinalFromCardinal($this->getRepetitionParam(), false), $rce); $todayTimestamp = strtotime('today'); $dateFormat = DateFormat::getInstance(); $oldDueDateTimestamp = 0; if ($this->getDueDate()) { $loggedUser = PcUserPeer::getLoggedInUser(); $oldDueDateTimestamp = $dateFormat->getTimestamp($this->getDueDate($loggedUser->getDateFormat())); } else { $oldDueDateTimestamp = $todayTimestamp; } $nextTimestamp = $oldDueDateTimestamp; if (strpos($rce, '_month') === FALSE) { if ($isInitialAdjustment) { $nextTimestamp = strtotime($rce, $nextTimestamp); } else { // we are in the case we need to apply the computer expression just once or // over and over again do { $nextTimestamp = strtotime($rce, $nextTimestamp); } while ($nextTimestamp < $todayTimestamp || $nextTimestamp <= $oldDueDateTimestamp); } } else { $i = 1; $repetitionParam = $this->getRepetitionParam(); // we are in the case where to deal with months. We have to go through the months if ($isInitialAdjustment) { $monthPlus = date('F Y', strtotime('+ 0 months', $oldDueDateTimestamp)); $rceWithReplacement = str_replace('_month_', $monthPlus, $rce); $nextTimestamp = strtotime($rceWithReplacement); // comparing just the timestamps was giving some unexpected results if (date('Ymd', $nextTimestamp) < date('Ymd', $oldDueDateTimestamp)) { $monthPlus = date('F Y', strtotime('+ 1 months', $oldDueDateTimestamp)); $rceWithReplacement = str_replace('_month_', $monthPlus, $rce); $nextTimestamp = strtotime($rceWithReplacement); } } else { do { $oldDueDateTimestamp = $nextTimestamp; $oldDueDateTimestampFirstDayOfMonth = strtotime('first day of this month', $oldDueDateTimestamp); $monthPlus = date('F Y', strtotime('+' . $repetitionParam . 'months', $oldDueDateTimestampFirstDayOfMonth)); $rceWithReplacement = str_replace('_month_', $monthPlus, $rce); $nextTimestamp = strtotime($rceWithReplacement); // {{{ added this code to troubleshoot a PHP max execution error in this loop if ($i > 50) { $watchdog = new PcWatchdog(); $watchdog->setType("NEXT RECURRENCE")->setDescription("taskId: {$this->getId()}")->save(); $watchdog3 = new PcWatchdog(); $watchdog3->setType("NEXT RECURRENCE")->setDescription("monthPlus: {$monthPlus}")->save(); $watchdog4 = new PcWatchdog(); $watchdog4->setType("NEXT RECURRENCE")->setDescription("rceWithReplacement: {$rceWithReplacement}")->save(); $watchdog6 = new PcWatchdog(); $watchdog6->setType("NEXT RECURRENCE")->setDescription($nextTimestamp)->save(); $watchdog7 = new PcWatchdog(); $watchdog7->setType("NEXT RECURRENCE")->setDescription($todayTimestamp)->save(); break; } // }}} $i++; } while ($nextTimestamp < $todayTimestamp || $nextTimestamp <= $oldDueDateTimestamp); } } } $this->setDueDate(date('Y-m-d', $nextTimestamp), 'Y-m-d'); $this->save(); }