/** * 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) { 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); $parser->setExtendedInfo($this); $this->extended = true; } return $this->extended; }
function _getCommandParams() { $queryParams = array('-db' => $this->fm->getProperty('database'), '-lay' => $this->_layout); foreach (array('_script' => '-script', '_preReqScript' => '-script.prefind', '_preSortScript' => '-script.presort') as $varName => $paramName) { if ($this->{$varName}) { $queryParams[$paramName] = $this->{$varName}; $varName .= 'Params'; if ($this->{$varName} !== null) { $queryParams[$paramName . '.param'] = $this->{$varName}; } } } if ($this->_resultLayout) { $queryParams['-lay.response'] = $this->_resultLayout; } return $queryParams; }
/** * * @return boolean 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(); $records = $result->getRecords(); $firstRecord = $records[0]; $relatedSet = $firstRecord->getRelatedSet($this->layout->getName()); foreach ($relatedSet as $record) { if ($record->getRecordId() == $this->recordId) { return $this->_updateFrom($record); break; } } throw new FileMakerException('Failed to find the updated child in the response.'); }
public function parse($xml) { if (empty($xml)) { throw new FileMakerException($this->_fm, 'Did not receive an XML document from the server.'); } $this->_xmlParser = xml_parser_create('UTF-8'); xml_set_object($this->_xmlParser, $this); xml_parser_set_option($this->_xmlParser, XML_OPTION_CASE_FOLDING, false); xml_parser_set_option($this->_xmlParser, XML_OPTION_TARGET_ENCODING, 'UTF-8'); xml_set_element_handler($this->_xmlParser, '_start', '_end'); xml_set_character_data_handler($this->_xmlParser, '_cdata'); if (!@xml_parse($this->_xmlParser, $xml)) { throw new FileMakerException($this->_fm, sprintf('XML error: %s at line %d', xml_error_string(xml_get_error_code($this->_xmlParser)), xml_get_current_line_number($this->_xmlParser))); } xml_parser_free($this->_xmlParser); if (!empty($this->_errorCode)) { throw new FileMakerException($this->_fm, null, $this->_errorCode); } if (version_compare($this->_serverVersion['version'], FileMaker::getMinServerVersion(), '<')) { throw new FileMakerException($this->_fm, 'This API requires at least version ' . FileMaker::getMinServerVersion() . ' of FileMaker Server to run (detected ' . $this->_serverVersion['version'] . ').'); } $this->_isParsed = true; return true; }
<pre><?php //header('Content-Type: text/plain'); //error_reporting(E_ALL); use tranduchieu\FileMaker\FileMaker; use tranduchieu\FileMaker\FileMakerException; use tranduchieu\FileMaker\FileMakerValidationException; require '../autoloader.php'; require '../FileMaker.php'; echo "==========================================" . PHP_EOL; echo " FILEMAKER API UNIT TEST" . PHP_EOL; echo "==========================================" . PHP_EOL . PHP_EOL; try { echo "------------------------------------------" . PHP_EOL; echo " Test FileMaker object's main methods" . PHP_EOL; echo "------------------------------------------" . PHP_EOL; $fm = new FileMaker('filemaker-test', '192.168.1.22', 'filemaker', 'filemaker'); /* API infos */ echo "API version : " . $fm->getAPIVersion() . PHP_EOL; echo "Min server version : " . $fm->getMinServerVersion() . PHP_EOL . PHP_EOL; /* get databases list */ echo "Get databases list..."; $databases = $fm->listDatabases(); echo implode(', ', $databases) . '...<span style="color:green">SUCCESS</span>' . PHP_EOL . PHP_EOL; /* get layouts list */ echo "Get layouts list..."; $layouts = $fm->listLayouts(); if (sizeof($layouts) != 2) { echo '<span style="color:red">FAIL</span> !' . PHP_EOL; exit; } echo implode(', ', $layouts) . '...<span style="color:green">SUCCESS</span>' . PHP_EOL . PHP_EOL;
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); }
/** * 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. */ public function setFieldFromTimestamp($field, $timestamp, $repetition = 0) { $layout =& $this->fm->getLayout($this->_layout); if (FileMaker::isError($layout)) { return $layout; } $field =& $layout->getField($fieldname); if (FileMaker::isError($field)) { return $field; } switch ($field->getResult()) { case 'date': return $this->setField($fieldname, date('m/d/Y', $timestamp), $repetition); case 'time': return $this->setField($fieldname, date('H:i:s', $timestamp), $repetition); case 'timestamp': return $this->setField($fieldname, date('m/d/Y H:i:s', $timestamp), $repetition); } throw new FileMakerException($this->fm, 'Only time, date, and timestamp fields can be set to the value of a timestamp.'); }