Example #1
0
 /**
  * Returns an array of layouts from the current database that are
  * available with the current server settings and the current
  * user name and password credentials.
  *
  * @return array|FileMakerException List of layout names.
  * @throws FileMakerException
  */
 public function listLayouts()
 {
     $request = $this->execute(array('-db' => $this->getProperty('database'), '-layoutnames' => true));
     if (FileMaker::isError($request)) {
         return $request;
     }
     $parser = new FMResultSet($this);
     $result = $parser->parse($request);
     if (FileMaker::isError($result)) {
         return $result;
     }
     $list = array();
     foreach ($parser->parsedResult as $data) {
         $list[] = $data['fields']['LAYOUT_NAME'][0];
     }
     return $list;
 }
Example #2
0
 public function execute()
 {
     $params = $this->_getCommandParams();
     $this->_setSortParams($params);
     $this->_setRangeParams($params);
     $this->_setRelatedSetsFilters($params);
     if (count($this->_findCriteria) || $this->recordId) {
         $params['-find'] = true;
     } else {
         $params['-findall'] = true;
     }
     if ($this->recordId) {
         $params['-recid'] = $this->recordId;
     }
     if ($this->_operator) {
         $params['-lop'] = $this->_operator;
     }
     foreach ($this->_findCriteria as $field => $value) {
         $params[$field] = $value;
     }
     $result = $this->fm->execute($params);
     if (FileMaker::isError($result)) {
         return $result;
     }
     return $this->_getResult($result);
 }
Example #3
0
 /**
  * Loads extended (FMPXMLLAYOUT) layout information.
  *
  * @access private
  *
  * @param string  $recid Record from which to load extended information.
  *
  * @return boolean TRUE, if successful.
  * @throws FileMakerException;
  */
 public function loadExtendedInfo($recid = null)
 {
     if (!$this->extended || $recid != null) {
         if ($recid != null) {
             $result = $this->fm->execute(array('-db' => $this->fm->getProperty('database'), '-lay' => $this->getName(), '-recid' => $recid, '-view' => null), 'FMPXMLLAYOUT');
         } else {
             $result = $this->fm->execute(array('-db' => $this->fm->getProperty('database'), '-lay' => $this->getName(), '-view' => null), 'FMPXMLLAYOUT');
         }
         $parser = new FMPXMLLAYOUT($this->fm);
         $parseResult = $parser->parse($result);
         if (FileMaker::isError($parseResult)) {
             return $parseResult;
         }
         $parser->setExtendedInfo($this);
         $this->extended = true;
     }
     return $this->extended;
 }
Example #4
0
 /**
  * Sets the new value for a field.
  *
  * @param string $field Name of field to set.
  * @param string $value Value to set for this field.
  * @param integer $repetition Field repetition number to set,
  *        Defaults to the first repetition.
  *
  * @return string
  */
 public function setField($field, $value, $repetition = 0)
 {
     $fieldInfos = $this->fm->getLayout($this->_layout)->getField($field);
     /* if(FileMaker::isError($fieldInfos)){
            return $fieldInfos;
        }*/
     $format = FileMaker::isError($fieldInfos) ? null : $fieldInfos->result;
     if (!empty($value) && $this->fm->getProperty('dateFormat') !== null && ($format === 'date' || $format === 'timestamp')) {
         if ($format === 'date') {
             $dateTime = \DateTime::createFromFormat($this->fm->getProperty('dateFormat') . ' H:i:s', $value . ' 00:00:00');
             $value = $dateTime->format('m/d/Y');
         } else {
             $dateTime = \DateTime::createFromFormat($this->fm->getProperty('dateFormat') . ' H:i:s', $value);
             $value = $dateTime->format('m/d/Y H:i:s');
         }
     }
     $this->_fields[$field][$repetition] = $value;
     return $value;
 }
Example #5
0
 /**
  *
  * @return boolean|FileMakerException TRUE on success
  * @throws FileMakerException
  */
 private function _commitEditChild()
 {
     $modifiedFields = [];
     foreach ($this->fields as $fieldName => $repetitions) {
         foreach ($repetitions as $repetition => $value) {
             if (!empty($this->_modifiedFields[$fieldName][$repetition])) {
                 $modifiedFields[$fieldName . '.' . $this->recordId][$repetition] = $value;
             }
         }
     }
     $editCommand = $this->fm->newEditCommand($this->parent->layout->getName(), $this->parent->getRecordId(), $modifiedFields);
     $result = $editCommand->execute();
     if (FileMaker::isError($result)) {
         return $result;
     }
     $records = $result->getRecords();
     $firstRecord = $records[0];
     $relatedSet = $firstRecord->getRelatedSet($this->layout->getName());
     if (FileMaker::isError($relatedSet)) {
         return $relatedSet;
     }
     foreach ($relatedSet as $record) {
         if ($record->getRecordId() == $this->recordId) {
             return $this->_updateFrom($record);
             break;
         }
     }
     $error = new FileMakerException($this->fm, 'Failed to find the updated child in the response.');
     if ($this->fm->getProperty('errorHandling') === 'default') {
         return $error;
     }
     throw $error;
 }
Example #6
0
 /**
  * Sets the new value for a date, time, or timestamp field from a
  * UNIX timestamp value.
  *
  * If the field is not a date or time field, then this method returns
  * an Error object. Otherwise, returns TRUE.
  *
  * If layout data for the target of this command has not already
  * been loaded, calling this method loads layout data so that
  * the type of the field can be checked.
  *
  * @param string $field Name of the field to set.
  * @param string $timestamp Timestamp value.
  * @param integer $repetition Field repetition number to set.
  *        Defaults to the first repetition.
  *
  * @return string|FileMakerException
  * @throws FileMakerException
  */
 public function setFieldFromTimestamp($field, $timestamp, $repetition = 0)
 {
     $layout =& $this->fm->getLayout($this->_layout);
     if (FileMaker::isError($layout)) {
         return $layout;
     }
     $field =& $layout->getField($field);
     if (FileMaker::isError($field)) {
         return $field;
     }
     switch ($field->getResult()) {
         case 'date':
             return $this->setField($field, date('m/d/Y', $timestamp), $repetition);
         case 'time':
             return $this->setField($field, date('H:i:s', $timestamp), $repetition);
         case 'timestamp':
             return $this->setField($field, date('m/d/Y H:i:s', $timestamp), $repetition);
     }
     $error = new FileMakerException($this->fm, 'Only time, date, and timestamp fields can be set to the value of a timestamp.');
     if ($this->fm->getProperty('errorHandling') === 'default') {
         return $error;
     }
     throw $error;
 }
Example #7
0
 /**
  *
  * @param string $xml
  * @return Result|FileMakerException
  * @throws FileMakerException
  */
 protected function _getResult($xml)
 {
     $parser = new FMResultSet($this->fm);
     $parseResult = $parser->parse($xml);
     if (FileMaker::isError($parseResult)) {
         return $parseResult;
     }
     $result = new Result($this->fm);
     $parseResult = $parser->setResult($result, $this->_recordClass);
     if (FileMaker::isError($parseResult)) {
         return $parseResult;
     }
     return $result;
 }
Example #8
0
 /**
  * Add extended infos to a Layout object
  *
  * @param Layout $layout
  * @return FileMakerException
  * @throws FileMakerException
  */
 public function setExtendedInfo(Layout $layout)
 {
     if (!$this->_isParsed) {
         $error = new FileMakerException($this->_fm, 'Attempt to set extended information before parsing data.');
         if ($this->_fm->getProperty('errorHandling') === 'default') {
             return $error;
         }
         throw $error;
     }
     $layout->valueLists = $this->_valueLists;
     $layout->valueListTwoFields = $this->_valueListTwoFields;
     foreach ($this->_fields as $fieldName => $fieldInfos) {
         try {
             $field = $layout->getField($fieldName);
             if (!FileMaker::isError($field)) {
                 $field->styleType = $fieldInfos['styleType'];
                 $field->valueList = $fieldInfos['valueList'] ? $fieldInfos['valueList'] : null;
             }
         } catch (\Exception $e) {
             //Field may be missing when it is stored in a portal, ommit error
         }
     }
 }