PHP api::setParams方法代码示例

/**
 * Updates a customer at Acumulus
 * @param $vars : $vars from the hook for API credentials
 * @param $clientid : clientid to update
 * @param null $customerid : customerid at Acumulus to update
 * @throws Exception
 * @return $customerid : new/updated customerid at Acumulus
 */
function updateCustomer($vars, $clientid, $customerid = null)
{
    global $whmcs;
    $whmcs->load_function('invoice');
    $clientQuery = mysql_query('SELECT tblclients.*, tblcustomfieldsvalues.value AS vatnumber FROM tblclients LEFT JOIN tblcustomfieldsvalues ON tblclients.id = tblcustomfieldsvalues.relid AND tblcustomfieldsvalues.fieldid = (SELECT id FROM tblcustomfields WHERE type = "client" AND fieldname = "' . $vars['vat_field'] . '" LIMIT 1) WHERE tblclients.id = ' . $clientid . ' LIMIT 1');
    if (mysql_num_rows($clientQuery) != 1) {
        throw new Exception('Failed to receive client ' . $clientid);
    }
    $clientFetch = mysql_fetch_assoc($clientQuery);
    $api = new api($vars['code'], $vars['username'], $vars['password']);
    $api->setCategory('contacts')->setAction('contact_manage');
    if (isset($vars['debug']) && $vars['debug'] == 'on') {
        $api->enableDebug($vars['debug_email']);
    }
    if ($clientFetch['acumulusid'] != null) {
        $api->setParam('contact/contactid', $clientFetch['acumulusid']);
    }
    if ($customerid != null) {
        $api->setParam('contact/contactid', $customerid);
    }
    if ($clientFetch['country'] == 'NL') {
        $api->setParam('contact/contactlocationcode', 1);
    } elseif (inEurope($clientFetch['country'])) {
        $api->setParam('contact/contactlocationcode', 2);
    } else {
        $api->setParam('contact/contactlocationcode', 3);
    }
    $taxData = getTaxRate(1, $clientQuery['state'], $clientQuery['country']);
    $api->setParams(array('contact' => array('contactemail' => $clientFetch['email'], 'contacttype' => 1, 'overwriteifexists' => 1, 'contactname1' => ucfirst($clientFetch['firstname']) . ' ' . $clientFetch['lastname'], 'contactname2' => '', 'contactperson' => '', 'contactsalutation' => '', 'contactaddress1' => $clientFetch['address1'], 'contactaddress2' => $clientFetch['address2'], 'contactpostalcode' => $clientFetch['postcode'], 'contactcity' => $clientFetch['city'], 'contactcountrycode' => inEurope($clientFetch['country']) ? $clientFetch['country'] : '', 'contactvatnumber' => $clientFetch['vatnumber'], 'contactvatratebase' => $clientFetch['taxexempt'] == 'on' ? -1 : round($taxData['rate']), 'contacttelephone' => $clientFetch['phonenumber'], 'contactfax' => '', 'contactsepaincassostatus' => 'FRST', 'contactinvoicetemplateid' => '', 'contactstatus' => 1)));
    if (!empty($clientFetch['companyname'])) {
        $api->setParams(array('contact' => array('contactname1' => $clientFetch['companyname'], 'contactperson' => ucfirst($clientFetch['firstname']) . ' ' . $clientFetch['lastname'])));
    }
    $api->execute();
    $response = $api->getResponse();
    if ($api->hasErrors()) {
        $errors = '';
        foreach ($api->getErrors() as $error) {
            $errors = $error['code'] . ' - ' . $error['message'] . ', ';
        }
        logActivity('Acumulus API error(s): ' . substr($errors, 0, -2));
        return false;
    } else {
        mysql_query('UPDATE tblclients SET acumulusid = ' . $response['contact']['contactid'] . ' WHERE id = ' . $clientid . ' LIMIT 1');
        return $response['contact']['contactid'];
    }
}

function acumulus_add_invoice($vars)
{
    $vars = array_merge($vars, getAddonVars());
    $dataQuery = mysql_query('SELECT tblclients.*, tblinvoices.*, tblpaymentgateways.value AS acumulusBank FROM tblinvoices LEFT JOIN tblclients ON tblclients.id = tblinvoices.userid LEFT JOIN tblpaymentgateways ON tblpaymentgateways.gateway = tblinvoices.paymentmethod AND tblpaymentgateways.setting = "acumulusAccount" WHERE tblinvoices.id = ' . $vars['invoiceid']);
    if (mysql_num_rows($dataQuery) != 1) {
        logActivity('Acumulus Add Invoice: received ' . mysql_num_rows($dataQuery) . ' invoices for ID ' . $vars['invoiceid']);
        return;
    }
    $dataFetch = mysql_fetch_assoc($dataQuery);
    if ($dataFetch['total'] == '0.00' || $dataFetch['total'] == 0) {
        //Invoice fully paid using credit or no items
        return;
    }
    $customerId = updateCustomer($vars, $dataFetch['userid']);
    $api = new api($vars['code'], $vars['username'], $vars['password']);
    $api->setCategory('invoices')->setAction('invoice_add');
    if (isset($vars['debug']) && $vars['debug'] == 'on') {
        $api->enableDebug($vars['debug_email']);
    }
    $taxRate = round($dataFetch['taxrate']);
    if ($dataFetch['country'] == 'NL') {
        // All Dutch customers needs to get vatType 1 and the defined taxRate
        $vatType = 1;
    } else {
        if (inEurope($dataFetch['country'])) {
            //If in Europe, then
            if (!empty($dataFetch['companyname'])) {
                // Check if customer IS a company
                $vatType = 3;
                $taxRate = -1;
            } else {
                $vatType = 6;
            }
        } else {
            // If not in Europe, then defaults to outside EU
            $vatType = 4;
            $taxRate = -1;
        }
    }
    $api->setParams(array('customer' => array('contactid' => $customerId, 'countrycode' => $dataFetch['country'], 'invoice' => array('concept' => 0, 'number' => empty($dataFetch['invoicenum']) ? $dataFetch['id'] : $dataFetch['invoicenum'], 'vattype' => $vatType, 'issuedate' => $dataFetch['date'], 'paymentstatus' => 2, 'paymentdate' => @date('Y-m-d', @strtotime($dataFetch['datepaid'])), 'accountnumber' => $dataFetch['acumulusBank'], 'costcenter' => $vars['cost_center'], 'template' => $vars['invoice_template']))));
    $btwCheckQuery = mysql_query('SELECT SUM(amount) as amount FROM tblinvoiceitems WHERE invoiceid = ' . $dataFetch['id']);
    $btwCheckFetch = mysql_fetch_assoc($btwCheckQuery);
    $removeVat = false;
    if ($btwCheckFetch['amount'] != $dataFetch['subtotal']) {
        $removeVat = true;
    }
    $invoiceLinesQuery = mysql_query('SELECT * FROM tblinvoiceitems WHERE invoiceid = ' . $dataFetch['id']);
    while ($invoiceLinesFetch = mysql_fetch_assoc($invoiceLinesQuery)) {
        $api->setParams(array('customer' => array('invoice' => array('line_' . $invoiceLinesFetch['id'] => array('product' => $invoiceLinesFetch['description'], 'unitprice' => $removeVat ? $invoiceLinesFetch['amount'] / 1.21 : $invoiceLinesFetch['amount'], 'vatrate' => $taxRate, 'quantity' => 1)))));
    }
    if ($dataFetch['credit'] != '0.00') {
        $vatrate = 0;
        if ($taxRate != -1) {
            $vatrate = $taxRate;
        }
        $price = $dataFetch['credit'] / 1.21;
        $api->setParams(array('customer' => array('invoice' => array('line_credit' => array('product' => 'Betaald d.m.v. credit (€ ' . $dataFetch['credit'] . ')', 'unitprice' => '-' . $price, 'vatrate' => $vatrate, 'quantity' => 1)))));
    }
    $api->execute();
    $response = $api->getResponse();
    if ($api->hasErrors()) {
        $errors = '';
        foreach ($api->getErrors() as $error) {
            $errors = $error['code'] . ' - ' . $error['message'] . ', ';
        }
        logActivity('Acumulus API error(s): ' . substr($errors, 0, -2));
    } else {
        mysql_query('UPDATE tblinvoices SET acumulusid = ' . $response['invoice']['entryid'] . ' WHERE id = ' . $vars['invoiceid'] . ' LIMIT 1');
    }
}