/**
* 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.');
}
