api_post.php

<?php
/**
 * Copyright (c) 2013-2016, Intacct OpenSource Initiative
 * All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without modification, are permitted provided that the
 * following conditions are met:
 *
 * Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
 * Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following
 * disclaimer in the documentation and/or other materials provided with the distribution.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES,
 * INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
 * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
 * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT,
 * STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN
 * IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * OVERVIEW
 * The general pattern for using this SDK is to first create an instance of api_session and call either
 * connectCredentials or connectSessionId to start an active session with the Intacct Web Services gateway.
 * You will then pass the api_session as an argument in the api_post class methods.  intacctws-php handles all
 * XML serialization and de-serialization and HTTPS transport.
 */

require_once 'api_util.php';
require_once 'api_viewFilter.php';
require_once 'api_viewFilters.php';
require_once 'api_returnFormat.php';
require_once 'api_objDef.php';
require_once 'api_ddsJob.php';
require_once 'api_ddsFileConfiguration.php';
require_once 'api_userPermissions.php';

/**
 * Class api_post
 *
 * Collection of static methods for interacting with the Intacct Web Services.
 */
class api_post
{

    private static $lastRequest;
    private static $lastResponse;
    private static $dryRun;

    const DEFAULT_PAGESIZE = 1000;
    const DEFAULT_MAXRETURN = 100000;

    const DDS_JOBTYPE_ALL = 'all';
    const DDS_JOBTYPE_CHANGE = 'change';

    /**
     * Read one or more records by their key.  For platform objects, the key is the 'id' field.
     * For standard objects, the key is the 'recordno' field.  Results are returned as a php structured array
     *
     * @param String              $object  the integration name for the object
     * @param String              $id      a comma separated list of keys for each record you wish to read
     * @param String              $fields  a comma separated list of fields to return
     * @param \api_session|Object $session an instance of the php_session object
     * @param string              $docparid Used for SODOCUMENT and PODOCUMENT records to indicate the document type
     *
     * @return Array of records
     * @throws exception
     */
    public static function read($object, $id, $fields, api_session $session, $docparid="")
    {

        $readXml = "<read><object>$object</object><keys>$id</keys><fields>$fields</fields><returnFormat>csv</returnFormat>";
        if(!empty($docparid)) {
            $readXml .= "<docparid>$docparid</docparid>";
        }
        $readXml .= "</read>";

        $objCsv = api_post::post($readXml, $session);
        api_post::validateReadResults($objCsv);
        $objAry = api_util::csvToPhp($objCsv);
        if (count(explode(",", $id)) > 1) {
            return $objAry;
        } else {
            return $objAry[0];
        }
    }

    /**
     * Create one or more records.  Object types can be mixed and can be either standard or custom.
     * Check the developer documentation to see which standard objects are supported in this method
     *
     * @param Array       $records is an array of records to create.  Follow the pattern
     * $records = array(array('myobjecttype' => array('field1' => 'value',
     *                                                'field2' => 'value')),
     *                  array('myotherobjecttype' => array('field1' => 'value',
     *                                                     'field2' => 'value')));
     * @param api_session $session instance of api_session object with valid connection
     *
     * @throws Exception
     * @return Array array of keys to the objects created
     */
    public static function create($records, api_session $session)
    {

        if (count($records) > 100) {
            throw new Exception("Attempting to create more than 100 records. (" . count($records) . ") ");
        }

        // Convert the record into an xml structure
        $createXml = "<create>";
        $node = "";
        foreach ($records as $record) {
            $nodeAry = array_keys($record);
            $node = $nodeAry[0];
            $objXml = api_util::phpToXml($node, $record[$node]);
            $createXml = $createXml . $objXml;
        }
        $createXml = $createXml . "</create>";
        $res = api_post::post($createXml, $session);
        $records = api_post::processUpdateResults($res, $node);

        return $records;
    }

    /**
     * Update one or more records.  Object types can be mixed and can be either standard or custom.
     * Check the developer documentation to see which standard objects are supported in this method
     *
     * @param Array       $records an array of records to update.  Follow the pattern
     * $records = array(array('mycustomobjecttype' => array('id' => 112233, // you must pass the id value
     *                                                      'updatefield' => 'updateValue')),
     *                  array('mystandardobjecttype' => array('recordno' => 555, // you must pass the recordno value for standard objects
     *                                                        'updatefield' => 'updateValue')));
     * @param api_session $session api_session object with a valid connection
     *
     * @throws Exception
     * @return array An array of 'ids' updated in the method invocation
     */
    public static function update($records, api_session $session)
    {
        if (count($records) > 100) {
            throw new Exception("Attempting to update more than 100 records.");
        }

        // convert the $records array into an xml structure
        $updateXml = "<update>";
        $node = '';
        foreach ($records as $record) {
            $nodeAry = array_keys($record);
            $node = $nodeAry[0];
            $objXml = api_util::phpToXml($node, $record[$node]);
            $updateXml = $updateXml . $objXml;
        }
        $updateXml = $updateXml . "</update>";

        $res = api_post::post($updateXml, $session);
        return api_post::processUpdateResults($res, $node);

    }

    /**
     * Checks to see if a record exists.  If so, it updates, else it creates
     *
     * @param String      $object       The type of object to perform upsert on
     * @param Array       $records      Array of records to upsert.  Should be passed in the same format as used with
     *                                  create and update
     * @param Mixed       $nameField    the field name used for lookup of existence
     * @param Mixed       $keyField     the field name used for the internal key (needed for update)
     * @param api_session $session      An active api_session object
     * @param bool        $readOnlyName Optional.  You shouldn't normally set this to true unless the value in the
     *                                  name field is actually set by the platform and you're passing a formulated value
     *                                  that should not be passed in the create or update
     *
     * @throws Exception
     * @return null
     */
    public static function upsert($object, $records, $nameField, $keyField, api_session $session, $readOnlyName = false)
    {
        if (count($records) > 100) {
            throw new Exception("You can only upsert up to 100 records at a time.  You passed " . count($records) . " $object records.");
        }
        $keys = array();
        foreach ($records as $record) {
            $keys[] = htmlspecialchars(str_replace('\'', '\\', $record[$object][$nameField]));
        }

        $where = "$nameField in ('" . join("','", $keys) . "')";
        $existingRecords = api_post::readByQuery($object, $where, "$nameField,$keyField", $session);
        if (!is_array($existingRecords)) {
            $existingRecords = array();
        }
        $toUpdate = array(); $toCreate = array();
        if (count($existingRecords) == 0) {
            if ($readOnlyName == true) {
                foreach ($records as $key => $rec) {
                    unset($records[$key][$object][$nameField]);
                }
            }
            api_post::create($records, $session);
        } else {
            // convert the result into an array of keys
            $existingKeys = array();
            foreach ($existingRecords as $rec) {
                $existingKeys[] = $rec[$nameField];
            }

            // also create an index by name
            $existingByName = array();
            foreach ($existingRecords as $rec) {
                $existingByName[$rec[$nameField]] = $rec[$keyField];
            }

            foreach ($records as $rec) {
                if (in_array($rec[$object][$nameField], $existingKeys)) {
                    $toUpdate[] = $rec;
                } else {
                    $toCreate[] = $rec;
                }
            }

            // convert the create and update arrays into operable structures
            if (count($toCreate) > 0) {
                if ($readOnlyName === true) {
                    foreach ($toCreate as $key => $rec) {
                        unset($toCreate[$key][$object][$nameField]);
                    }
                }
                api_post::create($toCreate, $session);
            }
            if (count($toUpdate) > 0) {
                foreach ($toUpdate as $updateKey => $updateRec) {
                    $toUpdate[$updateKey][$object][$keyField] = $existingByName[$updateRec[$object][$nameField]];
                    if ($readOnlyName === true) {
                        unset($toUpdate[$updateKey][$object][$nameField]);
                    }
                }
                api_post::update($toUpdate, $session);
            }
        }
    }

    /**
     * Delete one or more records
     *
     * @param String      $object  integration code of object type to delete
     * @param String      $ids     String a comma separated list of keys.  use 'id' values for custom
     * objects and 'recordno' values for standard objects
     * @param api_session $session instance of api_session object
     *
     * @return null
     */
    public static function delete($object, $ids, api_session $session)
    {
        $deleteXml = "<delete><object>$object</object><keys>$ids</keys></delete>";
        api_post::post($deleteXml, $session);
    }

    /**
     * Run any Intacct API method not directly implemented in this class.  You must pass
     * valid XML for the method you wish to invoke.
     *
     * @param String      $xml        valid XML for the method you wish to invoke
     * @param api_session $session    an api_session instance with a valid connection
     * @param string      $dtdVersion Either "2.1" or "3.0" defaults to "3.0"
     *
     * @return String the XML response from Intacct
     */
    public static function otherMethod($xml, api_session $session, $dtdVersion="3.0")
    {
        return api_post::post($xml, $session, $dtdVersion);
    }

    /**
     * Run any Intacct API method not directly implemented in this class.  You must pass
     * valid XML for the method you wish to invoke.
     *
     * @param String      $function for 2.1 function (create_sotransaction, etc)
     * @param Array       $phpObj   an array for the object.  Do not nest in another array() wrapper
     * @param api_session $session  an api_session instance with a valid connection
     *
     * @return String the XML response from Intacct
     */
    public static function call21Method($function, $phpObj, api_session $session)
    {
        $xml = api_util::phpToXml($function, array($phpObj));
        return api_post::post($xml, $session, "2.1");
    }

    /**
     * Run any Intacct API method not directly implemented in this class.  You must pass
     * valid XML for the method you wish to invoke.
     *
     * @param Array       $phpObj     an array for all the functions .
     * @param api_session $session    an api_session instance with a valid connection
     * @param string      $dtdVersion DTD Version.  Either "2.1" or "3.0".  Defaults to "2.1"
     *
     * @return String the XML response from Intacct
     */
    public static function sendFunctions($phpObj, api_session $session, $dtdVersion="2.1")
    {
        $xml = api_util::phpToXml('content', array($phpObj));
        return api_post::post($xml, $session, $dtdVersion, true);
    }

    /**
     * Get a list of standard objects by passing structured filters, sorts, and fields arguments.
     *
     * @param string      $object     the object to list
     * @param Array       $filter     filters in a phpObj that will convert to get_list filters in phpToXml
     * @param Array       $sorts      sorts in a phpObj that will convert to get_list sort in phpToXml
     * @param Array       $fields     list of fields in a phpObj that will convert to get_list fields in phpToXml
     * @param api_session $session    an api_session instance with a valid connection
     * @param string      $dtdVersion DTD Version.  Either "2.1" or "3.0".  Defaults to "2.1"
     *
     * @return String the XML response from Intacct
     */
    public static function get_list($object, $filter, $sorts, $fields, api_session $session, $dtdVersion="2.1")
    {
        $get_list = array();
        $get_list['@object'] = $object;
        if ($filter != null) {
            $get_list['filter'] = $filter;
        }
        if ($sorts != null) {
            $get_list['sorts'] = $sorts;
        }
        if ($fields != null) {
            $get_list['fields'] = $fields;
        }

        $func['function'][] = array (
            '@controlid' => 'control1',
            'get_list' => $get_list
        );

        $xml = api_util::phpToXml('content', array($func));
        $res = api_post::post($xml, $session, $dtdVersion, true);
        $count = 0;
        $ret = api_post::processListResults($res, api_returnFormat::PHPOBJ);
        $toReturn = $ret[$object];
        if (is_array($toReturn)) {
            $keys = array_keys($toReturn);
            if (!is_numeric($keys[0])) {
                $toReturn = array ($toReturn);
            }
        }
        return $toReturn;
    }

    /**
     * Handy wrapper for 2.1 update methods
     *
     * @param String      $function for 2.1 function (create_sotransaction, etc)
     * @param String      $key      The attribute key
     * @param Array       $phpObj   an array for the object.  Do not nest in another array() wrapper
     * @param api_session $session  an api_session instance with a valid connection
     *
     * @return String the XML response from Intacct
     */
    public static function call21UpdateMethod($function, $key, $phpObj, api_session $session)
    {
        $xml = api_util::phpToXml($function, array($phpObj));
        $xml = str_replace("<$function", "<$function key=\"$key\"", $xml);
        return api_post::post($xml, $session, "2.1");
    }

    /**
     * Return the records defined in a platform view.  Views define an object, a collection of field, sorting,
     * and filtering.  You may pass additional filters via the api_viewFilters object
     *
     * @param String          $viewName     either the textual name of the view or the original id of the view
     * (object#originalid).  Note view names are not guaranteed to be unique, so you are always safer referencing the
     * view using the notation[object]#[originalid].  Example: "CUSTOMER#123456@654321
     * @param api_session     $session      instance of the api session object
     * @param api_viewFilters $filterObj    Object instance of the api_viewFilters object
     * @param int             $maxRecords   defaults to 100000
     * @param string          $returnFormat String defaults to phpobj.  Use one of the constants defined in
     * api_returnFormat class
     *
     * @throws Exception
     * @return Mixed Depends on the return format argument.  Returns a string unless phpobj is the return format
     * in which case returns an array
     */
    public static function readView(
        $viewName, api_session $session, api_viewFilters $filterObj=null, $maxRecords = self::DEFAULT_MAXRETURN,
        $returnFormat = api_returnFormat::PHPOBJ
    ) {

        $pageSize = ($maxRecords <= self::DEFAULT_PAGESIZE) ? $maxRecords : self::DEFAULT_PAGESIZE;

        // set the return format
        api_returnFormat::validateReturnFormat($returnFormat);
        if ($returnFormat == api_returnFormat::PHPOBJ) {
            $returnFormatArg = api_returnFormat::CSV;
        } else {
            $returnFormatArg = $returnFormat;
        }

        // process the filters array
        $filtersXmlStr = '';
        if ($filterObj !== null) {
            $filters = $filterObj->filters;
            $condition = $filterObj->operator;
            $filtersXml = array();
            foreach ($filters as $filter) {
                $filtersXml[] = "<filterExpression><field>{$filter->field}</field><operator>{$filter->operator}</operator><value>{$filter->value}</value></filterExpression>";
            }
            $filtersXmlStr = "<filters><filterCondition>$condition</filterCondition>" . join("", $filtersXml) . "</filters>";
        }

        $viewName = HTMLSpecialChars($viewName);

        $readXml="<readView><view>$viewName</view><pagesize>$pageSize</pagesize><returnFormat>$returnFormatArg</returnFormat>$filtersXmlStr</readView>";
        $response = api_post::post($readXml, $session);
        api_post::validateReadResults($response);
        $phpobj = array(); $csv = ''; $json = ''; $xml = ''; $count = 0;
        $$returnFormat = self::processReadResults($response, $count, $returnFormat);

        if ($count == $pageSize && $count < $maxRecords) {
            while (true) {
                $readXml = "<readMore><view>$viewName</view></readMore>";
                try {
                    $response = api_post::post($readXml, $session);
                    api_post::validateReadResults($response);
                    $pageCount = 0;
                    $page = self::processReadResults($response, $pageCount, $returnFormat);
                    $count += $pageCount;
                    if ($returnFormat == api_returnFormat::PHPOBJ) {
                        foreach ($page as $objRec) {
                            $phpobj[] = $objRec;
                        }
                    } elseif ($returnFormat == api_returnFormat::CSV) {
                        // append all but the first row to the CSV file
                        $page = explode("\n", $page);
                        array_shift($page);
                        $csv .= implode($page, "\n");
                    } elseif ($returnFormat == api_returnFormat::XML) {
                        // just add the xml string
                        $xml .= $page;
                    }
                }
                catch (Exception $ex) {
                    // for now, pass the exception on
                    Throw new Exception($ex);
                }
                if ($pageCount < $pageSize || $count >= $maxRecords) {
                    break;
                }
            }
        }
        return $$returnFormat;
    }

    /**
     * Read records using a query.  Specify the object you want to query and something like a "where" clause
     *
     * @param String        $object the object upon which to run the query
     * @param String        $query the query string to execute.  Use SQL operators
     * @param String        $fields A comma separated list of fields to return
     * @param api_session   $session An instance of the api_session object with a valid connection
     * @param string        $docparid Used for SODOCUMENT and PODOCUMENT records to indicate the document type
     * @param int           $maxRecords number of records to return.  Defaults to 100000
     * @param string        $returnFormat defaults to php object.  Pass one of the valid constants from api_returnFormat class
     *
     * @return mixed either string or array of objects depending on returnFormat argument
     * @throws Exception
     */
    public static function readByQuery($object, $query, $fields, api_session $session, $maxRecords=self::DEFAULT_MAXRETURN, $returnFormat=api_returnFormat::PHPOBJ, $docparid="")
    {

        $pageSize = ($maxRecords <= self::DEFAULT_PAGESIZE) ? $maxRecords : self::DEFAULT_PAGESIZE;

        if ($returnFormat == api_returnFormat::PHPOBJ) {
            $returnFormatArg = api_returnFormat::CSV;
        } else {
            $returnFormatArg = $returnFormat;
        }

        // TODO: Implement returnFormat.  Today we only support PHPOBJ
        $query = HTMLSpecialChars($query);

        $readXml = "<readByQuery><object>$object</object><query>$query</query><fields>$fields</fields><returnFormat>$returnFormatArg</returnFormat>";
        $readXml .= "<pagesize>$pageSize</pagesize>";
        if(!empty($docparid)) {
            $readXml .= "<docparid>$docparid</docparid>";
        }
        $readXml .= "</readByQuery>";

        $response = api_post::post($readXml, $session);
        if ($returnFormatArg == api_returnFormat::CSV && trim($response) == "") {
            // csv with no records will have no response, so avoid the error from validate and just return
            return '';
        }
        api_post::validateReadResults($response);


        $phpobj = array(); $csv = ''; $json = ''; $xml = '';
        $$returnFormat = self::processReadResults($response, $thiscount, $returnFormat);

        $totalcount = $thiscount;

        // we have no idea if there are more if CSV is returned, so just check
        // if the last count returned was  $pageSize
        while ($thiscount == $pageSize && $totalcount <= $maxRecords) {
            $readXml = "<readMore><object>$object</object></readMore>";
            try {
                $response = api_post::post($readXml, $session);
                api_post::validateReadResults($response);
                $page = self::processReadResults($response, $pageCount, $returnFormat);
                $totalcount += $pageCount;
                $thiscount = $pageCount;

                switch($returnFormat) {
                case api_returnFormat::PHPOBJ:
                    foreach ($page as $objRec) {
                        $phpobj[] = $objRec;
                    }
                    break;
                case api_returnFormat::CSV:
                    $page = explode("\n", $page);
                    array_shift($page);
                    $csv .= implode($page, "\n");
                    break;
                case api_returnFormat::XML:
                    $xml .= $page;
                    break;
                default:
                    throw new Exception("Invalid return format: " . $returnFormat);
                    break;
                }

            }
            catch (Exception $ex) {
                // we've probably exceeded the limit
                break;
            }
        }
        return $$returnFormat;
    }

    /**
     * Inspect an object to get a list of its fields
     *
     * @param String      $object  The integration name of the object.  Pass '*' to get a complete list of objects
     * @param bool|String $detail  Whether or not to return data type information for the fields.
     * @param api_session $session Instance of an api_session object with a valid connection
     *
     * @return String the raw xml returned by Intacct
     */
    public static function inspect($object, $detail, api_session $session)
    {
        $inspectXML = "<inspect detail='$detail'><object>$object</object></inspect>";
        $objXml = api_post::post($inspectXML, $session);
        $simpleXml = simplexml_load_string($objXml);
        $objDefXml = $simpleXml->operation->result->data->Type;
        $objDef = new api_objDef($objDefXml);
        return $objDef;
    }

    /**
     * Read an object by its name field (vid for standard objects)
     *
     * @param String        $object object type
     * @param String        $name comma separated list of names.
     * @param String        $fields comma separated list of fields.
     * @param api_session   $session instance of api_session object.
     * @param string        $docparid  Used for SODOCUMENT and PODOCUMENT records to indicate the document type
     *
     * @return Array of objects.  If only one name is passed, the fields will be directly accessible.
     * @throws Exception
     */
    public static function readByName($object, $name, $fields, api_session $session, $docparid="")
    {
        $name = HTMLSpecialChars($name);
        $readXml = "<readByName><object>$object</object><keys>$name</keys><fields>$fields</fields><returnFormat>csv</returnFormat>";
        if(!empty($docparid)) {
            $readXml .= "<docparid>$docparid</docparid>";
        }
        $readXml .= "</readByName>";

        $objCsv = api_post::post($readXml, $session);

        if (trim($objCsv) == "") {
            // csv with no records will have no response, so avoid the error from validate and just return
            return '';
        }
        api_post::validateReadResults($objCsv);
        $objAry = api_util::csvToPhp($objCsv);
        if (count(explode(",", $name)) > 1) {
            return $objAry;
        } else {
            return $objAry[0];
        }
    }

    /**
     * Reads all the records related to a source record through a named relationship.
     *
     * @param String      $object   the integration name of the object
     * @param String      $keys     a comma separated list of 'id' values of the source records from which you want to read related records
     * @param String      $relation the name of the relationship.  This will determine the type of object you are reading
     * @param String      $fields   a comma separated list of fields to return
     * @param api_session $session  api_session object with valid connection
     *
     * @return Array of objects
     */
    public static function readRelated($object, $keys, $relation, $fields, api_session $session)
    {
        $readXml = "<readRelated><object>$object</object><keys>$keys</keys><relation>$relation</relation><fields>$fields</fields><returnFormat>csv</returnFormat></readRelated>";
        $objCsv = api_post::post($readXml, $session);
        api_post::validateReadResults($objCsv);
        $objAry = api_util::csvToPhp($objCsv);
        return $objAry;
    }

    /**
     * WARNING: This method will attempt to delete all records of a given object type
     * Deletes first 10000 by default
     *
     * @param String      $object  object type
     * @param api_session $session instance of api_session object.
     * @param Integer     $max     [optional] Maximum number of records to delete.  Default is 10000
     *
     * @return Integer count of records deleted
     */
    public static function deleteAll($object, api_session $session, $max=10000)
    {

        // read all the record ids for the given object
        $ids = api_post::readByQuery($object, "id > 0", "id", $session, $max);

        if (!count($ids) > 0) {
            return 0;
        }

        $count = 0;
        $delIds = array();
        foreach ($ids as $rec) {
            $delIds[] = $rec['id'];
            if (count($delIds) == 100) {
                api_post::delete($object, implode(",", $delIds), $session);
                $count += 100;
                $delIds = array();
            }
        }

        if (count($delIds) > 0) {
            api_post::delete($object, implode(",", $delIds), $session);
            $count += count($delIds);
        }

        return $count;
    }

    /**
     * WARNING: This method will attempt to delete all records of a given object type given a query
     * Deletes first 10000 by default
     *
     * @param String      $object  object type
     * @param String      $query   the query string to execute.  Use SQL operators
     * @param api_session $session instance of api_session object.
     * @param Integer     $max     [optional] Maximum number of records to delete.  Default is 10000
     *
     * @return Integer count of records deleted
     */
    public static function deleteByQuery($object, $query, api_session $session, $max=10000)
    {

        // read all the record ids for the given object
        $ids = api_post::readByQuery($object, "id > 0 and $query", "id", $session, $max);

        if ((!is_array($ids) && trim($ids) == '') || !count($ids) > 0) {
            return 0;
        }

        $count = 0;
        $delIds = array();
        foreach ($ids as $rec) {
            $delIds[] = $rec['id'];
            if (count($delIds) == 100) {
                api_post::delete($object, implode(",", $delIds), $session);
                $count += 100;
                $delIds = array();
            }
        }

        if (count($delIds) > 0) {
            api_post::delete($object, implode(",", $delIds), $session);
            $count += count($delIds);
        }

        return $count;
    }

    /**
     * Run a DDS job.  Note that DDS is not GA yet
     *
     * @param api_session $session       connected instance of api_session
     * @param string      $object        object on which to run the job
     * @param string      $cloudDelivery Cloud delivery destination to which to deliver the results.
     * @param string      $jobType       type of job: all or changes
     * @param null        $timestamp     if changes, then the time stamp from which to pull
     * @return api_ddsJob
     * @throws Exception
     */
    public static function runDdsJob(api_session $session, $object, $cloudDelivery, $jobType, $timestamp=null)
    {
        if ($jobType == self::DDS_JOBTYPE_ALL) {
            $tsString = '';
        } else if ($jobType == self::DDS_JOBTYPE_CHANGE) {
            $tsString = "<timeStamp>" . date("c", strtotime($timestamp)) . "</timeStamp>";
        } else {
            throw new Exception ("Invalid job type.  Use one of the DDS_JOBTYPE* constants.");
        }

        $runXml
            = "<runDdsJob><object>$object</object><cloudDelivery>$cloudDelivery</cloudDelivery>
            <jobType>$jobType</jobType>$tsString</runDdsJob>";
        $response = api_post::post($runXml, $session);
        // for now, call read on the key
        $responseXml = simplexml_load_string($response);
        /**
         * @var simpleXmlElement $responseKey;
         */
        $ddsJob = new api_ddsJob($responseXml->operation->result->data->ddsjob);
        return $ddsJob;
    }

    /**
     * Get a list of objects enabled for DDS.  Note DDS is not enabled yet
     *
     * @param api_session $session Instance of connected api_session
     *
     * @return array List of objects supported by DDS
     */
    public static function getDdsObjects(api_session $session)
    {
        $runXml = "<getDdsObjects/>";
        $response = api_post::post($runXml, $session);
        api_post::validateReadResults($response);
        $simpleXml = simplexml_load_string($response);
        $return = array();
        $objects = $simpleXml->operation->result->data->DdsObjects->Objects;
        foreach ($objects->Object as $object) {
            $return[] = (string)$object;
        }
        return $return;
    }

    /**
     * Get the DDL for creating the table for an object.  Note, DDS is not enabled yet
     *
     * @param api_session $session instance of connected api_session
     * @param string      $object  Name of object for which to retrieve DDS
     *
     * @return String
     */
    public static function getDdsDdl(api_session $session, $object)
    {
        $runXml = "<getDdsDdl><object>$object</object></getDdsDdl>";
        $response = api_post::post($runXml, $session);
        api_post::validateReadResults($response);
        $simpleXml = simplexml_load_string($response);
        $ddl = (string)$simpleXml->operation->result->data->DdsDdl->Ddl;
        return $ddl;
    }

    /**
     * Get the effective list of permissions for a user, whether the company is configured for user-specific permissions
     * or role-based permissions
     *
     * @param string      $userId The User ID
     * @param api_session $sess   Connected api_session object
     *
     * @throws Exception
     * @return api_userPermissions
     */
    public static function getUserPermissions($userId, api_session $sess)
    {
        $runXml = "<getUserPermissions><userId>$userId</userId></getUserPermissions>";
        $response = api_post::post($runXml, $sess, "2.1");
        $respElem = new simpleXmlElement($response);
        if ($respElem === false) {
            throw new Exception("Invalid XML response in getUserPermissions.");
        }

        $permsElem = $respElem->operation->result->data;
        return new api_userPermissions($permsElem);
    }

    /**
     * Get the date to which the books are closed
     *
     * @param api_session $sess Connected api_session object
     *
     * @throws Exception
     * @return DateTime
     */
    public static function getClosedBooksDate(api_session $sess)
    {
        $runXml = "<get_closedbooksdate/>";
        $response = api_post::post($runXml, $sess);
        $respElem = new simpleXmlElement($response);
        if ($respElem === false) {
            throw new Exception("Invalid XML response in getClosedBooksDate.");
        }

        $closedBooksDate = $respElem->operation->result->data->closedbooksdate;
        $date = new DateTime(
            (int)$closedBooksDate->year . '-' . (int)$closedBooksDate->month . '-' . (int)$closedBooksDate->day
        );
        return $date;
    }

    /**
     * Execute a pre-defined report and return the data.  Optionally pass arguments to the report.
     * Note that readReport reverts to asynchronous mode when the report exceeds a fixed amount of time.
     *
     * @param string                        $reportName The report name
     * @param api_session                   $sess       Connected api_session object
     * @param array|api_readReportArguments $arguments  Should be array of arguments ['key'] => $arg .
     * @return simpleXmlElement[]
     * @throws Exception
     */
    public static function readReport($reportName, api_session $sess, api_readReportArguments $arguments = null)
    {

        $runXml = new SimpleXMLElement("<readReport/>");
        $runXml->addAttribute('returnDef', 'false');
        $runXml->addChild('report',$reportName);
        $runXml->addChild('pagesize', self::DEFAULT_PAGESIZE);
        $runXml->addChild('returnFormat', 'xml');
        if (!is_null($arguments)) {
            $arguments->addAsElement($runXml);
        }
        $runXml->addChild('waitTime', 5);
        $runXmlString = api_util::xmlElementToSnippet($runXml);

        $response = api_post::post($runXmlString, $sess);
        $responseXml = new simpleXmlElement($response);
        if ($responseXml === false) {
            throw new Exception("Invalid XML response in readReport.");
        }

        // Did we get the results or did we get a handle?
        $reportHandle = $responseXml->operation->result->data->report_results;
        $reportId = (string)$reportHandle->REPORTID;
        $reportStatus = (string)$reportHandle->STATUS;
        $allResults = array();
        $reportResult = null;
        $readMoreResponse = null;

        // Ping every 5 seconds until the report is ready
        while ($reportStatus == 'PENDING') {
            sleep(5);
            $reportResult = api_post::readMoreReport($reportId, $sess);
            $reportStatus = (string)$reportResult->report->data->STATUS;
            if ($reportStatus == '') {
                // weird.  if the status is DONE, it shows up in data->report->status
                $reportStatus = (string)$reportResult->report->STATUS;
            }
        }

        // read the report results page by page until we have all the records
        $allResults = api_post::gatherReportResults($reportResult, $allResults);
        $recordsLeft = api_post::getRecordsLeftAttribute($reportResult);
        while ($recordsLeft != 0) {
            $reportResult = api_post::readMoreReport($reportId, $sess);
            $allResults = api_post::gatherReportResults($reportResult, $allResults);
            $recordsLeft = api_post::getRecordsLeftAttribute($reportResult);
        }

        return $allResults;
    }

    /**
     * Parse the readMore result from readReport to determine the number of remaining records to retrieve.
     *
     * @param simpleXmlElement $reportResult
     * @return int
     */
    private static function getRecordsLeftAttribute(simpleXmlElement $reportResult)
    {
        $recordsLeft = 0;
        foreach($reportResult->attributes() as $key => $value) {
            if ($key == 'numremaining') $recordsLeft = (int)$value;
        }
        return $recordsLeft;
    }

    /**
     * Read the next page of results from a readReport invocation
     *
     * @param             $reportId
     * @param api_session $sess
     * @return simpleXmlElement
     * @throws Exception
     */
    private static function readMoreReport($reportId, api_session $sess)
    {
        $readMoreXml = new SimpleXMLElement('<readMore/>');
        $readMoreXml->addChild('reportId', $reportId);
        $readMoreResponse = api_post::post(api_util::xmlElementToSnippet($readMoreXml), $sess);
        $readMoreResponseXml = new simpleXmlElement($readMoreResponse);
        if ($readMoreResponseXml === false) {
            throw new Exception("Invalid XML response in readMore.");
        }

        $reportResult = $readMoreResponseXml->operation->result->data;
        return $reportResult;
    }

    /**
     * Iterate over the results and accumulate the returned records
     *
     * @param simpleXmlElement $readMoreResults
     * @param array            $allResults      Existing results to which to append results
     * @return simpleXmlElement[]
     */
    private function gatherReportResults(simpleXmlElement $readMoreResults, array $allResults)
    {

        foreach($readMoreResults->report->data as $data) {
            $allResults[] = $data;
        }

        return $allResults;
    }

    /**
     * Get the definition of a report by its name
     *
     * @param             $reportName
     * @param api_session $sess
     * @throws Exception
     * @return simpleXmlElement
     */
    public static function readReportDefinition($reportName, api_session $sess)
    {
        $runXml = new SimpleXMLElement('<readReport/>');
        $runXml->addAttribute('returnDef', 'true');
        $runXml->addChild('report', $reportName);
        $response = api_post::post(api_util::xmlElementToSnippet($runXml), $sess);
        $responseXml = new simpleXmlElement($response);
        if ($responseXml === false) {
            throw new Exception('Invalid XML response in readReportDefinition.');
        }

        $reportDefXml = $responseXml->operation->result->data->report_definition;
        return $reportDefXml;
    }

    /**
     * Internal method for posting the invocation to the Intacct XML Gateway
     *
     * @param String      $xml        the XML request document
     * @param api_session $session    an api_session instance with an active connection
     * @param string      $dtdVersion Either "2.1" or "3.0".  Defaults to "3.0"
     * @param boolean     $multiFunc  whether or not this invocation calls multiple methods.  Default is false
     *
     * @throws Exception
     * @return String the XML response document
     */
    private static function post($xml, api_session $session, $dtdVersion="3.0", $multiFunc=false)
    {

        $sessionId = $session->sessionId;
        $endPoint = $session->endPoint;
        $senderId = $session->senderId;
        $senderPassword = $session->senderPassword;

        $transaction = ( $session->transaction ) ? 'true' : 'false' ;

        $templateHead =
"<?xml version=\"1.0\" encoding=\"UTF-8\"?>
<request>
    <control>
        <senderid>{$senderId}</senderid>
        <password>{$senderPassword}</password>
        <controlid>foobar</controlid>
        <uniqueid>false</uniqueid>
        <dtdversion>{$dtdVersion}</dtdversion>
        {%validate}
        <includewhitespace>false</includewhitespace>
    </control>
    <operation transaction='{$transaction}'>
        <authentication>
            <sessionid>{$sessionId}</sessionid>
        </authentication>";

        $contentHead =
        "<content>
            <function controlid=\"foobar\">";

        $contentFoot = 
            "</function>
        </content>";

        $templateFoot =
    "</operation>
</request>";

        if (is_null($session->getResponseValidation())) {
            $templateHead = str_replace("{%validate}", '', $templateHead);
        } else {
            $templateHead = str_replace(
                "{%validate}", '<validate>' . $session->getResponseValidation() . '</validate>', $templateHead
            );
        }

        if ($multiFunc) {
            $xml = $templateHead . $xml . $templateFoot;
        } else {
            $xml = $templateHead . $contentHead . $xml . $contentFoot . $templateFoot;
        }

        if (self::$dryRun == true) {
            self::$lastRequest = $xml;
            return null;
        }


        $count = 0; // retry five times on too many operations
        $res = "";
        while (true) {
            try {
                $res = api_post::execute($xml, $endPoint);
                api_post::validateResponse($res);
                break;
            } catch (Exception $ex) {
                if (
                    strpos($ex->getMessage(), "too many operations") !== false //API throttling
                    || strpos($ex->getMessage(), "HTTP Response Code not 200") !== false //CDN or other issue
                ) {
                    $count++;
                    if ($count >= 5) {
                        throw new Exception($ex);
                    }
                } else {
                    throw new Exception($ex);
                }
            }
        }
        return $res;
    }

    /**
     * You won't normally use this function, but if you just want to pass a fully constructed XML document
     * to Intacct, then use this function.
     *
     * @param String $body     a Valid XML string
     * @param String $endPoint URL to post the XML to
     *
     * @throws exception
     * @return String the raw XML returned by Intacct
     */
    public static function execute($body, $endPoint)
    {

        self::$lastRequest = $body;

        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $endPoint);
        curl_setopt($ch, CURLOPT_HEADER, 0);
        curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_TIMEOUT, 3000); //Seconds until timeout
        curl_setopt($ch, CURLOPT_POST, 1);
        // TODO: Research and correct the problem with CURLOPT_SSL_VERIFYPEER
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); // yahoo doesn't like the api.intacct.com CA

        $body = "xmlrequest=" . urlencode($body);
        curl_setopt($ch, CURLOPT_POSTFIELDS, $body);

        $response = curl_exec($ch);
        $error = curl_error($ch);
        if ($error != "") {
            throw new Exception($error);
        }
        $curlInfo = curl_getinfo($ch);
        if ($curlInfo['http_code'] != 200) {
            throw new Exception('HTTP code not 200, got code ' . $curlInfo['http_code'] . ' instead.');
        }
        curl_close($ch);

        self::$lastResponse = $response;
        return $response;

    }

    /**
     * Validate the response from Intacct and look for request level errors
     *
     * @param String $response The XML response document
     *
     * @return Array Array of errors encountered
     * @throws Exception
     */
    public static function findResponseErrors($response)
    {

        $errorArray = array();

        // don't send errors to the log
        libxml_use_internal_errors(true);
        // the client asked for a non-xml response (csv or json)
        $simpleXml = @simplexml_load_string($response);

        if ($simpleXml === false) {
            return null;
        }
        libxml_use_internal_errors(false);

        // look for a failure in the operation, but not the result
        if (isset($simpleXml->operation->errormessage)) {
            $errorArray[] = array ( 'desc' =>  api_util::xmlErrorToString($simpleXml->operation->errormessage));
        }

        // if we didn't get an operation, the request failed and we should raise an exception
        // with the error details
        // did the method invocation fail?
        if (!isset($simpleXml->operation)) {
            if (isset($simpleXml->errormessage)) {
                $errorArray[] = array ( 'desc' =>  api_util::xmlErrorToString($simpleXml->errormessage));
            }
        } else {
            $results = $simpleXml->xpath('/response/operation/result');
            foreach ($results as $result) {
                if ((string)$result->status == "failure") {
                    $errorArray[] = array (
                        'controlid' => (string)$result->controlid,
                        'desc' =>  api_util::xmlErrorToString($result->errormessage)
                    );
                }
            }
        }
        return $errorArray;
    }

    /**
     * Validate the response from Intacct and look for request level errors
     *
     * @param String $response The XML response document
     *
     * @throws Exception
     * @return null
     */
    private static function validateResponse($response)
    {

        // don't send errors to the log
        libxml_use_internal_errors(true);
        // the client asked for a non-xml response (csv or json)
        $simpleXml = @simplexml_load_string($response);
        if ($simpleXml === false) {
            return;
        }
        libxml_use_internal_errors(false);

        // look for a failure in the operation, but not the result
        if (isset($simpleXml->operation->errormessage)) {
            $error = $simpleXml->operation->errormessage->error[0];
            throw new Exception("[ERROR: " . $error->errorno . "] " . $error->description2);
        }
        // if we didn't get an operation, the request failed and we should raise an exception
        // with the error details
        // did the method invocation fail?
        if (!isset($simpleXml->operation)) {

            if (isset($simpleXml->errormessage)) {
                throw new Exception("[Error] " . api_util::xmlErrorToString($simpleXml->errormessage));
            }
        } else {
            $results = $simpleXml->operation->result;
            foreach ($results as $res) {
                if ($res->status == "failure") {
                    throw new Exception("[Error] " . api_util::xmlErrorToString($res->errormessage));
                }
            }
        }
        return;
    }

    /**
     * Parses the response document from update requests and returns an array of ids affected
     *
     * @param String $response   XML response string
     * @param String $objectName the name of the object updated
     *
     * @return array of IDs
     * @throws Exception
     */
    private static function processUpdateResults($response, $objectName)
    {
        $simpleXml = simplexml_load_string($response);
        if ($simpleXml === false) {
            throw new Exception("Invalid XML response: \n " . var_export($response, true));
        }

        // check to see if there's an error in the response
        $status = $simpleXml->operation->result->status;
        if ($status != "success") {
            //find the problem and raise an exception
            $error = $simpleXml->operation->result->errormessage;
            throw new Exception("[Error] " . api_util::xmlErrorToString($error));
        }

        $updates = array();

        foreach ($simpleXml->operation->result->data->{$objectName} as $record) {
            if ($record->id) {
                $updates[] = (string)$record->id;
            } else if ($record->RECORDNO) {
                $updates[] = (string)$record->RECORDNO;
            } else {
                $updates[] = 'Record updated did not have id or RECORDNO';
            }
        }

        return $updates;
    }

    /**
     * Valid responses from read methods
     *
     * @param String $response The XML response string
     *
     * @throws Exception
     * @return null
     */
    private static function validateReadResults($response)
    {

        // don't send warnings to the error log
        libxml_use_internal_errors(true);
        $simpleXml = simplexml_load_string($response);
        libxml_use_internal_errors(false);

        if ($simpleXml === false) {
            return; // the result is csv or json, so there's no error
        }

        // Is there a problem with the XML request?
        if ((string)$simpleXml->operation->result->status == 'false') {
            $error = $simpleXml->operation->errormessage[0];
            throw new Exception("[Error] " . api_util::xmlErrorToString($error));
        }

        // is there a problem with the method invocation?
        $status = $simpleXml->operation->result->status;
        if ((string)$status != 'success') {
            $error = $simpleXml->operation->result->errormessage;
            throw new Exception("[Error] " . api_util::xmlErrorToString($error));
        } else {
            return; // no error found.
        }

    }

    /**
     * Process results from any of the get_list method and convert into the appropriate structure
     *
     * @param String $response     result from post to Intacct Web Services
     * @param string $returnFormat valid returnFormat value
     *
     * @throws Exception
     * @return Mixed string or object depending on return format
     */
    public static function processListResults($response, $returnFormat = api_returnFormat::PHPOBJ)
    {

        $xml = simplexml_load_string($response);

        $success = $xml->operation->result->status;
        if ($success != "success") {
            throw new Exception("Get List failed");
        }
        
        if ($returnFormat != api_returnFormat::PHPOBJ) {
            throw new Exception("Only PHPOBJ is supported for returnFormat currently.");
        }

        $json = json_encode($xml->operation->result->data);
        $array = json_decode($json, true);
        return $array;
    }

    /**
     * Process results from any of the read methods and convert into the appropriate structure
     *
     * @param String  $response     result from post to Intacct Web Services
     * @param Integer &$count       by reference count of records returned
     * @param string  $returnFormat valid returnFormat value
     *
     * @throws Exception
     * @return Mixed string or object depending on return format
     */
    private static function processReadResults($response, &$count, $returnFormat = api_returnFormat::PHPOBJ)
    {
        $objAry = array(); $csv = ''; $json = ''; $xml = '';
        if ($returnFormat == api_returnFormat::PHPOBJ) {
            $objAry = api_util::csvToPhp($response);
            $count = count($objAry);
            return $objAry;
        } elseif ($returnFormat == api_returnFormat::JSON) {
            // this seems really expensive
            $objAry = json_decode($response);
            // todo: JSON doesn't work because we don't know what object to refer to
            throw new Exception("The JSON return format is not implemented yet.");
        } elseif ($returnFormat == api_returnFormat::XML) {
            $xmlObj = simplexml_load_string($response);
            foreach ($xmlObj->operation->result->data->attributes() as $attribute => $value) {
                if ($attribute == 'count') {
                    $count = $value;
                    break;
                }
            }
            $xml = $xmlObj->operation->result->data->view->asXml();
            return $xml;
        } elseif ($returnFormat == api_returnFormat::CSV) {
            $objAry = api_util::csvToPhp($response);
            $count = count($objAry);
            $csv = $response;
            return $csv;
        } else {
            throw new Exception("Unknown return format $returnFormat.  Refer to the api_returnFormat class.");
        }

    }

    /**
     * Helpful for debugging purposes.  Get the last full XML document passed to Intacct
     *
     * @return String XML request
     */
    public static function getLastRequest()
    {
        return self::$lastRequest;
    }

    /**
     * Helpful for debugging purposes.  Get the last response from Intacct
     *
     * @return String the raw respons from Intacct
     */
    public static function getLastResponse()
    {
        return self::$lastResponse;
    }

    /**
     * Set the invocation to generate XML, but not post to Intacct
     *
     * @param bool $tf true or false
     *
     * @return null
     */
    public static function setDryRun($tf=true)
    {
        self::$dryRun = $tf;
    }
    
}

/**
 * Class api_readReportArguments
 *
 * Arguments structure usable for the readReport method.  Echo the class or call __toString to get
 * the XML representation.  Add this class as a SimpleXmlElement by calling addAsElement
 */

class api_readReportArguments
{
    /** @var array $args */
    private $args;

    /** @var  array $dateArgs */
    private $dateArgs;

    /**
     * Add an argument to the structure for an exact match field.
     *
     * @param string $key Name of the field on which to pass argument.  Should be the integration name for the field
     * @param string $arg Filter argument.  This is a bit free form.  We'll provide examples.
     */
    public function addArg($key, $arg)
    {
        $this->args[$key] = $arg;
    }

    /**
     * Add a date range argument.  Pass either from, to or both.  Use the integration name for the field
     *
     * @param string        $key  Field to filter on
     * @param DateTime|null $from Date range from
     * @param DateTime|null $to   Date range to
     * @throws Exception
     */
    public function addDateRangeArg($key, DateTime $from=null, DateTime $to=null)
    {
        if (is_null($from) && is_null($to)) {
            throw new Exception("You must pass either \$from, \$to or both.");
        }

        $dateArg = array();
        if (!is_null($from)) {
            $dateArg['FROM_DATE'] = $from->format('m/d/Y');
        }
        if (!is_null($to)) {
            $dateArg['TO_DATE'] = $to->format('m/d/Y');
        }

        $this->dateArgs[$key] = $dateArg;
    }

    /**
     * @return mixed
     */
    public function __toString()
    {
        $argXml = new SimpleXMLElement("<arguments/>");
        self::constructElement($argXml);
        return api_util::xmlElementToSnippet($argXml->asXML());
    }

    /**
     * Add the arguments element to an existing XML Element
     *
     * @param SimpleXMLElement $xml
     */
    public function addAsElement(SimpleXMLElement &$xml)
    {
        $argXml = $xml->addChild('arguments');
        self::constructElement($argXml);
    }

    /**
     * Convert this class into a simpleXmlElement
     *
     * @param simpleXmlElement $argXml
     */
    private function constructElement(simpleXmlElement &$argXml)
    {
        foreach($this->args as $key => $arg) {
            $argXml->addChild($key, $arg);
        }
        foreach($this->dateArgs as $key => $arg) {
            $dateArg = $argXml->addChild($key);
            if (array_key_exists('FROM_DATE', $arg)) {
                $dateArg->addChild('FROM_DATE', $arg['FROM_DATE']);
            }
            if (array_key_exists('TO_DATE', $arg)) {
                $dateArg->addChild('TO_DATE', $arg['TO_DATE']);
            }
        }
    }
}