PHP Formatter::parseDate方法代码示例

 /**
  * Helper method for compareAttributes 
  */
 protected function compareAttribute(&$criteria, $field)
 {
     $fieldName = $field->fieldName;
     switch ($field->type) {
         case 'boolean':
             $criteria->compare('t.' . $fieldName, $this->compareBoolean($this->{$fieldName}), true);
             break;
         case 'assignment':
             $assignmentCriteria = new CDbCriteria();
             $assignmentVal = $this->compareAssignment($this->{$fieldName});
             if ($field->linkType === 'multiple' && $this->{$fieldName}) {
                 if (!is_array($assignmentVal)) {
                     $assignmentVal = array();
                 }
                 $assignmentVal = array_map(function ($val) {
                     return preg_quote($val);
                 }, $assignmentVal);
                 if (strlen($this->{$fieldName}) && strncmp("Anyone", ucfirst($this->{$fieldName}), strlen($this->{$fieldName})) === 0) {
                     $assignmentVal[] = 'Anyone';
                 }
                 $assignmentRegex = '(^|, )(' . implode('|', $assignmentVal) . ')' . (in_array('Anyone', $assignmentVal) ? '?' : '') . '(, |$)';
                 $assignmentParamName = CDbCriteria::PARAM_PREFIX . CDbCriteria::$paramCount;
                 $criteria->params[$assignmentParamName] = $assignmentRegex;
                 CDbCriteria::$paramCount++;
                 $criteria->addCondition('t.' . $fieldName . ' REGEXP BINARY ' . $assignmentParamName);
             } else {
                 $assignmentCriteria->compare('t.' . $fieldName, $assignmentVal, true);
                 if (strlen($this->{$fieldName}) && strncmp("Anyone", ucfirst($this->{$fieldName}), strlen($this->{$fieldName})) === 0) {
                     $assignmentCriteria->compare('t.' . $fieldName, 'Anyone', false, 'OR');
                     $assignmentCriteria->addCondition('t.' . $fieldName . ' = ""', 'OR');
                 }
             }
             $criteria->mergeWith($assignmentCriteria);
             break;
         case 'dropdown':
             $dropdownVal = $this->compareDropdown($field->linkType, $this->{$fieldName});
             if (is_array($dropdownVal)) {
                 foreach ($dropdownVal as $val) {
                     $dropdownRegex = '(^|((\\[|,)"))' . preg_quote($val) . '(("(,|\\]))|$)';
                     $dropdownParamName = CDbCriteria::PARAM_PREFIX . CDbCriteria::$paramCount;
                     $criteria->params[$dropdownParamName] = $dropdownRegex;
                     CDbCriteria::$paramCount++;
                     $criteria->addCondition('t.' . $fieldName . ' REGEXP BINARY ' . $dropdownParamName);
                 }
             } else {
                 $criteria->compare('t.' . $fieldName, $dropdownVal, false);
             }
             break;
         case 'date':
         case 'dateTime':
             if (!empty($this->{$fieldName})) {
                 // get operator and convert date string to timestamp
                 $retArr = $this->unshiftOperator($this->{$fieldName});
                 $operator = $retArr[0];
                 $timestamp = Formatter::parseDate($retArr[1]);
                 if (!$timestamp) {
                     // if date string couldn't be parsed, it's better to display no results
                     // than non-empty incorrect results (which could result in bad mass updates
                     // or deletes)
                     $criteria->addCondition('FALSE');
                 } else {
                     if ($operator === '=' || $operator === '') {
                         $criteria->addBetweenCondition('t.' . $fieldName, $timestamp, $timestamp + 60 * 60 * 24);
                     } else {
                         $value = $operator . $timestamp;
                         $criteria->compare('t.' . $fieldName, $value);
                     }
                 }
             }
             break;
         case 'phone':
             // $criteria->join .= ' RIGHT JOIN x2_phone_numbers ON (x2_phone_numbers.itemId=t.id AND x2_tags.type="Contacts" AND ('.$tagConditions.'))';
         // $criteria->join .= ' RIGHT JOIN x2_phone_numbers ON (x2_phone_numbers.itemId=t.id AND x2_tags.type="Contacts" AND ('.$tagConditions.'))';
         default:
             $criteria->compare('t.' . $fieldName, $this->{$fieldName}, true);
     }
 }

 /**
  * Parses a value for table insertion using X2Fields rules
  * @param mixed $value
  * @param bool $filter If true, replace HTML special characters (prevents markup injection)
  * @return mixed the parsed value
  */
 public function parseValue($value, $filter = false)
 {
     if (in_array($this->type, array('int', 'float', 'currency', 'percentage'))) {
         return self::strToNumeric($value, $this->type);
     }
     switch ($this->type) {
         case 'assignment':
             return $this->linkType === 'multiple' ? self::parseUsers($value) : $value;
         case 'date':
         case 'dateTime':
             if (is_numeric((string) $value)) {
                 // must already be a timestamp
                 return $value;
             }
             $value = $this->type === 'dateTime' ? Formatter::parseDateTime($value) : Formatter::parseDate($value);
             return $value === false ? null : $value;
         case 'link':
             if (empty($value) || empty($this->linkType)) {
                 return $value;
             }
             list($name, $id) = self::nameAndId($value);
             if (ctype_digit((string) $id)) {
                 // Already formatted as a proper reference. Check for existence of the record.
                 $linkedModel = X2Model::model($this->linkType)->findByAttributes(array('nameId' => $value));
                 // Return the plain text name if the link is broken; otherwise,
                 // given how the record exists, return the value.
                 return empty($linkedModel) ? $name : $value;
             } else {
                 if (ctype_digit($value)) {
                     // User manually entered the ID, i.e. in an API call
                     $link = Yii::app()->db->createCommand()->select('nameId')->from(X2Model::model($this->linkType)->tableName())->where('id=?', array($value))->queryScalar();
                 } else {
                     // Look up model's unique nameId by its name:
                     $link = Yii::app()->db->createCommand()->select('nameId')->from(X2Model::model($this->linkType)->tableName())->where('name=?', array($name))->queryScalar();
                 }
             }
             return $link === false ? $name : $link;
         case 'boolean':
             return (bool) $value;
         case 'text':
             return self::getPurifier()->purify($value);
         case 'dropdown':
             return is_array($value) ? CJSON::encode($value) : $value;
         default:
             return $filter ? CHtml::encode($value) : $value;
     }
 }

 public function filterModels(array $gridModels)
 {
     $filteredModels = array();
     $that = $this;
     $filters = array_filter($this->attributeNames(), function ($a) use($that) {
         return $that->{$a} !== '' && $that->{$a} !== null;
     });
     foreach ($gridModels as $model) {
         $filterOut = false;
         foreach ($filters as $filter) {
             $val = $this->{$filter};
             switch ($filter) {
                 case 'name':
                     $filterOut = !preg_match('/' . $val . '/i', $model->relatedModel->getAttribute('name'));
                     break;
                 case 'relatedModelName':
                     $filterOut = $val !== get_class($model->relatedModel);
                     break;
                 case 'assignedTo':
                     $filterOut = !preg_match('/' . $val . '/i', $model->relatedModel->getAttribute('assignedTo.fullName'));
                     break;
                 case 'label':
                     $filterOut = !preg_match('/' . $val . '/i', $model->relatedModel->getRelationshipLabel($this->myModel));
                     break;
                 case 'createDate':
                     $timestampA = Formatter::parseDate($val);
                     $timestampB = $model->relatedModel->getAttribute('createDate');
                     // compare days since UNIX epoch
                     $filterOut = floor($timestampA / (3600 * 24)) !== floor($timestampB / (3600 * 24));
                     break;
             }
             if ($filterOut) {
                 break;
             }
         }
         if (!$filterOut) {
             $filteredModels[] = $model;
         }
     }
     return $filteredModels;
 }

 public static function parseValue($value, $type, &$params = null, $renderFlag = true)
 {
     if (is_string($value)) {
         if (strpos($value, '=') === 0) {
             // It's a formula. Evaluate it.
             $evald = X2FlowFormatter::parseFormula($value, $params);
             // Fail silently because there's not yet a good way of reporting
             // problems that occur in parseFormula --
             $value = '';
             if ($evald[0]) {
                 $value = $evald[1];
             }
         } else {
             // Run token replacement:
             $value = X2FlowFormatter::replaceVariables($value, $params, $type, $renderFlag, true);
         }
     }
     switch ($type) {
         case 'boolean':
             return (bool) $value;
         case 'time':
         case 'date':
         case 'dateTime':
             if (ctype_digit((string) $value)) {
                 // must already be a timestamp
                 return $value;
             }
             if ($type === 'date') {
                 $value = Formatter::parseDate($value);
             } elseif ($type === 'dateTime') {
                 $value = Formatter::parseDateTime($value);
             } else {
                 $value = strtotime($value);
             }
             return $value === false ? null : $value;
         case 'link':
             $pieces = explode('_', $value);
             if (count($pieces) > 1) {
                 return $pieces[0];
             }
             return $value;
         case 'tags':
             return Tags::parseTags($value);
         default:
             return $value;
     }
 }

 public function renderFilterCellByType()
 {
     $model = $this->grid->filter;
     $fieldName = $this->name;
     switch ($this->filterType) {
         case 'date':
             $model->{$fieldName} = Formatter::parseDate($model->{$fieldName});
             return X2Html::activeDatePicker($model, $this->name);
             break;
         case 'dateTime':
             $model->{$fieldName} = Formatter::parseDate($model->{$fieldName});
             return X2Html::activeDatePicker($model, $this->name, array(), 'datetime');
             break;
     }
 }

 /**
  * Helper method for compareAttributes 
  */
 protected function compareAttribute(&$criteria, $field)
 {
     $fieldName = $field->fieldName;
     switch ($field->type) {
         case 'boolean':
             $criteria->compare('t.' . $fieldName, $this->compareBoolean($this->{$fieldName}), true);
             break;
         case 'assignment':
             $criteria->compare('t.' . $fieldName, $this->compareAssignment($this->{$fieldName}), true);
             break;
         case 'dropdown':
             $criteria->compare('t.' . $fieldName, $this->compareDropdown($field->linkType, $this->{$fieldName}), false);
             break;
         case 'date':
         case 'dateTime':
             if (!empty($this->{$fieldName})) {
                 // get operator and convert date string to timestamp
                 $retArr = $this->unshiftOperator($this->{$fieldName});
                 $operator = $retArr[0];
                 $timestamp = Formatter::parseDate($retArr[1]);
                 if (!$timestamp) {
                     // if date string couldn't be parsed, it's better to display no results
                     // than non-empty incorrect results (which could result in bad mass updates
                     // or deletes)
                     $criteria->addCondition('FALSE');
                 } else {
                     if ($operator === '=' || $operator === '') {
                         $criteria->addBetweenCondition('t.' . $fieldName, $timestamp, $timestamp + 60 * 60 * 24);
                     } else {
                         $value = $operator . $timestamp;
                         $criteria->compare('t.' . $fieldName, $value);
                     }
                 }
             }
             break;
         case 'phone':
             // $criteria->join .= ' RIGHT JOIN x2_phone_numbers ON (x2_phone_numbers.itemId=t.id AND x2_tags.type="Contacts" AND ('.$tagConditions.'))';
         // $criteria->join .= ' RIGHT JOIN x2_phone_numbers ON (x2_phone_numbers.itemId=t.id AND x2_tags.type="Contacts" AND ('.$tagConditions.'))';
         default:
             $criteria->compare('t.' . $fieldName, $this->{$fieldName}, true);
     }
 }

 public function actionUpdateStageDetails($id)
 {
     $action = X2Model::model('Actions')->findByPk($id);
     $previouslyComplete = $action->complete === 'Yes';
     $model = X2Model::getModelOfTypeWithId($action->associationType, $action->associationId, true);
     if (isset($model, $action, $_POST['Actions'])) {
         $action->setScenario('workflow');
         $action->createDate = Formatter::parseDate($_POST['Actions']['createDate']);
         $action->completeDate = Formatter::parseDate($_POST['Actions']['completeDate']);
         $action->actionDescription = $_POST['Actions']['actionDescription'];
         if (isset($_POST['Actions']['completedBy']) && (Yii::app()->params->isAdmin || Yii::app()->settings->workflowBackdateReassignment)) {
             $action->completedBy = $_POST['Actions']['completedBy'];
         }
         // don't save if createDate isn't valid
         if ($action->createDate === false) {
             return;
         }
         if ($action->completeDate === false) {
             $action->complete = 'No';
             $action->completedBy = null;
             $model->updateLastActivity();
             if ($previouslyComplete) {
                 // we're uncompleting this thing
                 Workflow::updateWorkflowChangelog($action, 'revert', $model);
             }
             unset($action->completeDate);
             // remove invalid value
         } else {
             if ($action->completeDate < $action->createDate) {
                 // we can't have the completeDate before the createDate now can we
                 $action->completeDate = $action->createDate;
             }
             $action->complete = 'Yes';
             if (!$previouslyComplete) {
                 // we're completing it
                 Workflow::updateWorkflowChangelog($action, 'complete', $model);
             }
         }
         if ($action->save()) {
             if ($action->complete === 'Yes') {
                 echo 'complete';
             } else {
                 echo 'success';
             }
         }
     }
 }

 /**
  * Legacy Method: Should be replaced with dateRangeToDates
  * 
  * This function returns a date range to be used for generating a report
  * based on the dropdown value the user selected. I think it might occur elsewhere
  * in the code and could probably be refactored.
  * @return array An array with the date range values
  */
 public static function getDateRange($startKey = 'start', $endKey = 'end', $rangeKey = 'range', $defaultRange = 'custom')
 {
     $dateRange = array();
     $dateRange['strict'] = false;
     if (isset($_GET['strict']) && $_GET['strict']) {
         $dateRange['strict'] = true;
     }
     $dateRange['range'] = $defaultRange;
     if (isset($_GET[$rangeKey])) {
         $dateRange['range'] = $_GET[$rangeKey];
     }
     switch ($dateRange['range']) {
         case 'thisWeek':
             $dateRange['start'] = strtotime('mon this week');
             // first of this month
             $dateRange['end'] = time();
             // now
             break;
         case 'thisMonth':
             $dateRange['start'] = mktime(0, 0, 0, date('n'), 1);
             // first of this month
             $dateRange['end'] = time();
             // now
             break;
         case 'lastWeek':
             $dateRange['start'] = strtotime('mon last week');
             // first of last month
             $dateRange['end'] = strtotime('mon this week') - 1;
             // first of this month
             break;
         case 'lastMonth':
             $dateRange['start'] = mktime(0, 0, 0, date('n') - 1, 1);
             // first of last month
             $dateRange['end'] = mktime(0, 0, 0, date('n'), 1) - 1;
             // first of this month
             break;
         case 'thisYear':
             $dateRange['start'] = mktime(0, 0, 0, 1, 1);
             // first of the year
             $dateRange['end'] = time();
             // now
             break;
         case 'lastYear':
             $dateRange['start'] = mktime(0, 0, 0, 1, 1, date('Y') - 1);
             // first of last year
             $dateRange['end'] = mktime(0, 0, 0, 1, 1, date('Y')) - 1;
             // first of this year
             break;
         case 'all':
             $dateRange['start'] = 0;
             // every record
             $dateRange['end'] = time();
             if (isset($_GET[$endKey])) {
                 $dateRange['end'] = Formatter::parseDate($_GET[$endKey]);
                 if ($dateRange['end'] == false) {
                     $dateRange['end'] = time();
                 } else {
                     $dateRange['end'] = strtotime('23:59:59', $dateRange['end']);
                 }
             }
             break;
         case 'custom':
         default:
             $dateRange['end'] = time();
             if (isset($_GET[$endKey])) {
                 $dateRange['end'] = Formatter::parseDate($_GET[$endKey]);
                 if ($dateRange['end'] == false) {
                     $dateRange['end'] = time();
                 } else {
                     $dateRange['end'] = strtotime('23:59:59', $dateRange['end']);
                 }
             }
             $dateRange['start'] = strtotime('1 month ago', $dateRange['end']);
             if (isset($_GET[$startKey])) {
                 $dateRange['start'] = Formatter::parseDate($_GET[$startKey]);
                 if ($dateRange['start'] == false) {
                     $dateRange['start'] = strtotime('-30 days 0:00', $dateRange['end']);
                 } else {
                     $dateRange['start'] = strtotime('0:00', $dateRange['start']);
                 }
             }
     }
     return $dateRange;
 }