$defaults = getSystemDefaults();
$master_customer_id = $_GET['customer_id'];
$customer = getCustomer($master_customer_id);
if ($_GET['action'] == 'update_template') {
/* update default template for customer */
$sql = "UPDATE " . TB_PREFIX . "customers SET custom_field4 = :cf4 WHERE id = :id AND domain_id = :domain_id";
dbQuery($sql, ':cf4', $_GET['id'], ':id', $master_customer_id, ':domain_id', domain_id::get());
$smarty->assign("view", "quick_view");
$smarty->assign("spec", "id");
$smarty->assign("id", $_GET['id']);
# print("debug=$sql");
} else {
$template = $defaults['default_invoice'];
/* GET DEFAULT TEMPLATE, OR NULL */
$customer['custom_field4'] != null && ($template = $customer['custom_field4']);
/* OVERRIDE WITH CF4 IF IT EXISTS */
$invoice = getInvoice($template);
$template = $invoice['id'];
/* CHECK IF TEMPLATE EXISTS, OR NULL */
if ($template == null) {
/* No template for this customer */
$smarty->assign("view", "itemised");
$smarty->assign("spec", "customer_id");
$smarty->assign("id", $master_customer_id);
} else {
/* Use template for this customer */
$smarty->assign("view", "details");
$smarty->assign("spec", "template");
$smarty->assign("id", $template);
}
}
* Authors:
* Justin Kelly, Nicolas Ruflin, Ap.Muthu
*
* Last edited:
* 2008-01-03
*
* License:
* GPL v2 or above
*
* Website:
* http://www.simpleinvoices.or
*/
checkLogin();
#get the invoice id
$invoice_id = $_GET['invoice'];
$invoice = getInvoice($invoice_id);
$invoice_type = getInvoiceType($invoice['type_id']);
$customer = getCustomer($invoice['customer_id']);
$biller = getBiller($invoice['biller_id']);
$preference = getPreference($invoice['preference_id']);
$defaults = getSystemDefaults();
$text_ui_invoiceobj = new text_ui_invoice();
$invoiceItems = $text_ui_invoiceobj->getInvoiceItems($invoice_id);
#Invoice Age - number of days - start
if ($invoice['owing'] > 0) {
$invoice_age_days = number_format((strtotime(date('Y-m-d')) - strtotime($invoice['calc_date'])) / (60 * 60 * 24), 0);
$invoice_age = "{$invoice_age_days} {$LANG['days']}";
} else {
$invoice_age = "";
}
$url_for_pdf = "./pdfmaker.php?id=" . $invoice['id'];
<?php
if($_GET['id'])
{
$invoice = getInvoice($_GET['id']);
$output['owing'] = $invoice['owing'];
echo json_encode($output);
exit();
} else {
echo "";
}
/*
* Script: details.php
* invoice details page
*
* License:
* GPL v3 or above
*
* Website:
* http://www.simpleinvoices.org
*/
#table
//stop the direct browsing to this file - let index.php handle which files get displayed
checkLogin();
#get the invoice id
$master_invoice_id = $_GET['id'];
$invoice = getInvoice($master_invoice_id);
$invoiceItems = invoice::getInvoiceItems($master_invoice_id);
//var_dump($invoiceItems);
$customers = getActiveCustomers();
$preference = getPreference($invoice['preference_id']);
$billers = getActiveBillers();
//$taxes = getActiveTaxes(); <--- look into this
$defaults = getSystemDefaults();
$taxes = getTaxes();
$preferences = getActivePreferences();
$products = getActiveProducts();
for ($i = 1; $i <= 4; $i++) {
$customFields[$i] = show_custom_field("invoice_cf{$i}", $invoice["custom_field{$i}"], "write", '', "details_screen", '', '', '');
}
$smarty->assign("invoice", $invoice);
$smarty->assign("defaults", $defaults);
function showData($data)
{
$SI_PREFERENCES = new SimpleInvoices_Db_Table_Preferences();
if($this->file_name =='')
{
switch ($this->module)
{
case "payment":
{
$this->file_name = 'payment'.$this->id;
break;
}
}
}
//echo "export show data";
switch ($this->format)
{
case "print":
{
echo($data);
break;
}
case "pdf":
{
pdfThis($data, $this->file_location, $this->file_name);
$this->file_location == "download" ? exit():"" ;
break;
}
case "file":
{
//xls/doc export no longer uses the export template
//$template = "export";
header("Content-type: application/octet-stream");
//header("Content-type: application/x-msdownload");
switch ($this->module)
{
case "statement":
{
header('Content-Disposition: attachment; filename="statement.'.addslashes($this->file_type).'"');
break;
}
case "payment":
{
header('Content-Disposition: attachment; filename="payment'.addslashes($this->id.'.'.$this->file_type).'"');
break;
}
case "database":
{
$today = date("YmdGisa");
header('Content-Disposition: attachment; filename="simple_invoices_backup_'.$today.'.'.$this->file_type.'"');
break;
}
default:
{
$invoice = getInvoice($this->id);
$preference = $SI_PREFERENCES->getPreferenceById($invoice['preference_id']);
header('Content-Disposition: attachment; filename="'.addslashes($preference[pref_inv_heading].$this->id.'.'.$this->file_type).'"');
break;
}
}
header("Pragma: no-cache");
header("Expires: 0");
echo($data);
break;
}
}
}
<?php
//stop the direct browsing to this file - let index.php handle which files get displayed
checkLogin();
$menu = false;
$payment = getPayment($_GET['id']);
/*Code to get the Invoice preference - so can link from this screen back to the invoice - START */
$invoice = getInvoice($payment['ac_inv_id']);
$biller = getBiller($payment['biller_id']);
$logo = getLogo($biller);
$logo = str_replace(" ", "%20", $logo);
$customer = getCustomer($payment['customer_id']);
$invoiceType = getInvoiceType($invoice['type_id']);
$customFieldLabels = getCustomFieldLabels();
$paymentType = getPaymentType($payment['ac_payment_type']);
$preference = getPreference($invoice['preference_id']);
$smarty->assign("payment", $payment);
$smarty->assign("invoice", $invoice);
$smarty->assign("biller", $biller);
$smarty->assign("logo", $logo);
$smarty->assign("customer", $customer);
$smarty->assign("invoiceType", $invoiceType);
$smarty->assign("paymentType", $paymentType);
$smarty->assign("preference", $preference);
$smarty->assign("customFieldLabels", $customFieldLabels);
$smarty->assign('pageActive', 'payment');
$smarty->assign('active_tab', '#money');
<li><a href="invoices.php">Invoices</a></li>
<!--<li><a href="addinvoice.php">Add Invoice</a></li>-->
<li class="active"><a href="updateinvoice.php">Update Invoice</a></li>
</ul>
</div>
</div>
</div><!--end of dashboard-->
</div><!--end of header--->
<div style="clear: both;"></div>
<div id="content" class="content">
<h1>Update Invoice</h1>
<div class="main-content">
<div class="data-form">
<?php
$invo = getInvoice($number);
?>
<form action="<?php
echo $_SERVER['PHP_SELF'];
?>
" method="post">
<label>Status</label><select name="status"><option value="pending" <?php
if ($invo[0]['status'] == 'pending') {
echo 'selected';
}
?>
>Pending</option><option value="paid" <?php
if ($invo[0]['status'] == 'paid') {
echo 'selected';
}
?>
function InfusionSoft($that)
{
global $wpdb;
if (!class_exists('xmlrpcmsg') || !class_exists('xmlrpcval') || !class_exists('xmlrpc_client')) {
include_once $x = $that->pluginDir . '/extlib/xmlrpc.php';
}
//All FUNCTIONS Starts Here
//function for getting the product sku using the product id in infusionsoft
function getProductSku($Id, $con, $key)
{
$msg = new xmlrpcmsg('DataService.findByField');
$msg->addParam(new xmlrpcval($key));
$msg->addParam(new xmlrpcval('Product'));
$msg->addParam(new xmlrpcval(1, 'int'));
$msg->addParam(new xmlrpcval(0, 'int'));
$msg->addParam(new xmlrpcval('Id'));
$msg->addParam(new xmlrpcval($Id));
$msg->addParam(new xmlrpcval(array(new xmlrpcval('Sku')), 'array'));
$product = $con->send($msg);
$product = $product->value();
if ($product) {
return $product[0];
} else {
return false;
}
}
//function for getting the contact info from infusionsoft
function getContact($Id, $con, $key)
{
$msg = new xmlrpcmsg('ContactService.load');
$msg->addParam(new xmlrpcval($key));
$msg->addParam(new xmlrpcval($Id, 'int'));
$msg->addParam(new xmlrpcval(array(new xmlrpcval('Id'), new xmlrpcval('FirstName'), new xmlrpcval('LastName'), new xmlrpcval('Email'), new xmlrpcval('Company'), new xmlrpcval('StreetAddress1'), new xmlrpcval('StreetAddress2'), new xmlrpcval('City'), new xmlrpcval('State'), new xmlrpcval('PostalCode'), new xmlrpcval('Country')), 'array'));
$user = $con->send($msg);
$user = $user->value();
return $user;
}
//function for getting the invoice using invoice id
function getInvoice($Id, $con, $key)
{
$msg = new xmlrpcmsg('DataService.findByField');
$msg->addParam(new xmlrpcval($key));
$msg->addParam(new xmlrpcval('Invoice'));
$msg->addParam(new xmlrpcval(1, 'int'));
$msg->addParam(new xmlrpcval(0, 'int'));
$msg->addParam(new xmlrpcval('Id'));
$msg->addParam(new xmlrpcval($Id));
$msg->addParam(new xmlrpcval(array(new xmlrpcval('Id'), new xmlrpcval('ContactId'), new xmlrpcval('JobId'), new xmlrpcval('DateCreated'), new xmlrpcval('TotalDue'), new xmlrpcval('PayStatus'), new xmlrpcval('CreditStatus'), new xmlrpcval('RefundStatus'), new xmlrpcval('PayPlanStatus'), new xmlrpcval('InvoiceType'), new xmlrpcval('ProductSold')), 'array'));
$invoice = $con->send($msg);
$invoice = $invoice->value();
if ($invoice) {
return $invoice[0];
} else {
return false;
}
}
//function for getting the invoice using jobid
function getInvoiceByJobId($JobId, $con, $key)
{
$msg = new xmlrpcmsg('DataService.findByField');
$msg->addParam(new xmlrpcval($key));
$msg->addParam(new xmlrpcval('Invoice'));
$msg->addParam(new xmlrpcval(1, 'int'));
$msg->addParam(new xmlrpcval(0, 'int'));
$msg->addParam(new xmlrpcval('JobId'));
$msg->addParam(new xmlrpcval($JobId, 'int'));
$msg->addParam(new xmlrpcval(array(new xmlrpcval('Id'), new xmlrpcval('ContactId'), new xmlrpcval('DateCreated'), new xmlrpcval('TotalDue'), new xmlrpcval('JobId'), new xmlrpcval('PayStatus'), new xmlrpcval('CreditStatus'), new xmlrpcval('RefundStatus'), new xmlrpcval('PayPlanStatus'), new xmlrpcval('InvoiceType'), new xmlrpcval('ProductSold')), 'array'));
$invoices = $con->send($msg);
$invoices = $invoices->value();
if (empty($invoices)) {
return false;
}
return $invoices[0];
}
//function for getting the Job using order id passed in url
function getJob($orderId, $con, $key)
{
$msg = new xmlrpcmsg('DataService.findByField');
$msg->addParam(new xmlrpcval($key));
$msg->addParam(new xmlrpcval('Job'));
$msg->addParam(new xmlrpcval(1, 'int'));
$msg->addParam(new xmlrpcval(0, 'int'));
$msg->addParam(new xmlrpcval('Id'));
$msg->addParam(new xmlrpcval($orderId, 'int'));
$msg->addParam(new xmlrpcval(array(new xmlrpcval('Id'), new xmlrpcval('JobTitle'), new xmlrpcval('ContactId'), new xmlrpcval('StartDate'), new xmlrpcval('DueDate'), new xmlrpcval('JobNotes'), new xmlrpcval('ProductId'), new xmlrpcval('JobStatus'), new xmlrpcval('DateCreated'), new xmlrpcval('JobRecurringId'), new xmlrpcval('OrderType'), new xmlrpcval('OrderStatus')), 'array'));
$jobs = $con->send($msg);
$jobs = $jobs->value();
if (empty($jobs)) {
return false;
}
return $jobs[0];
}
//function for getting the payplan items
function GetPayplanItems($payplan_id, $con, $key)
{
// retrieve Payplan Items
$msg = new xmlrpcmsg('DataService.findByField');
$msg->addParam(new xmlrpcval($key));
$msg->addParam(new xmlrpcval('PayPlanItem'));
$msg->addParam(new xmlrpcval(10, 'int'));
$msg->addParam(new xmlrpcval(0, 'int'));
$msg->addParam(new xmlrpcval('PayPlanId'));
$msg->addParam(new xmlrpcval($payplan_id));
$msg->addParam(new xmlrpcval(array(new xmlrpcval('Id'), new xmlrpcval('PayPlanId'), new xmlrpcval('DateDue'), new xmlrpcval('AmtDue'), new xmlrpcval('Status')), 'array'));
$ppi = $con->send($msg);
$ppi = $ppi->value();
if ($ppi) {
$ret = $ppi;
} else {
$ret = false;
}
return $ret;
}
//function for getting the payplan status
function GetPayplanStatus($invoice_id, $con, $key)
{
// retrieve Payplan
$msg = new xmlrpcmsg('DataService.findByField');
$msg->addParam(new xmlrpcval($key));
$msg->addParam(new xmlrpcval('PayPlan'));
$msg->addParam(new xmlrpcval(1, 'int'));
$msg->addParam(new xmlrpcval(0, 'int'));
$msg->addParam(new xmlrpcval('InvoiceId'));
$msg->addParam(new xmlrpcval($invoice_id));
$msg->addParam(new xmlrpcval(array(new xmlrpcval('Id'), new xmlrpcval('InvoiceId'), new xmlrpcval('AmtDue'), new xmlrpcval('DateDue'), new xmlrpcval('InitDate'), new xmlrpcval('StartDate')), 'array'));
$pp = $con->send($msg);
$pp = $pp->value();
if ($pp) {
$pp = $pp[0];
if ($pp['StartDate'] > date('Ymd\\TH:i:s', strtotime('EST')) && !empty($pp['StartDate'])) {
$ret = array("PayPlanId" => $pp['Id'], "OverDue" => false);
} else {
$ret = array("PayPlanId" => $pp['Id'], "OverDue" => true);
}
} else {
$ret = false;
}
return $ret;
}
//function for getting the subscription using product id
function GetSubscriptionStatusByPID($contactID, $PId, $con, $key)
{
$msg = new xmlrpcmsg('DataService.query');
$msg->addParam(new xmlrpcval($key));
$msg->addParam(new xmlrpcval('RecurringOrder'));
$msg->addParam(new xmlrpcval(1, 'int'));
$msg->addParam(new xmlrpcval(0, 'int'));
$msg->addParam(new xmlrpcval(array('ContactId' => new xmlrpcval($contactID), 'ProductId' => new xmlrpcval($PId, 'int')), 'struct'));
$msg->addParam(new xmlrpcval(array(new xmlrpcval('Id'), new xmlrpcval('ContactId'), new xmlrpcval('OriginatingOrderId'), new xmlrpcval('SubscriptionPlanId'), new xmlrpcval('ProductId'), new xmlrpcval('StartDate'), new xmlrpcval('EndDate'), new xmlrpcval('LastBillDate'), new xmlrpcval('NextBillDate'), new xmlrpcval('ReasonStopped'), new xmlrpcval('Status')), 'array'));
$recur = $con->send($msg);
$recur = $recur->value();
if ($recur) {
return $recur[0];
} else {
return false;
}
}
//function for get the subscription using subscription id
function GetSubscriptionStatusBySID($SId, $con, $key)
{
$msg = new xmlrpcmsg('DataService.query');
$msg->addParam(new xmlrpcval($key));
$msg->addParam(new xmlrpcval('RecurringOrder'));
$msg->addParam(new xmlrpcval(1, 'int'));
$msg->addParam(new xmlrpcval(0, 'int'));
$msg->addParam(new xmlrpcval(array('Id' => new xmlrpcval($SId, 'int')), 'struct'));
$msg->addParam(new xmlrpcval(array(new xmlrpcval('Id'), new xmlrpcval('ContactId'), new xmlrpcval('OriginatingOrderId'), new xmlrpcval('SubscriptionPlanId'), new xmlrpcval('ProductId'), new xmlrpcval('StartDate'), new xmlrpcval('EndDate'), new xmlrpcval('LastBillDate'), new xmlrpcval('NextBillDate'), new xmlrpcval('ReasonStopped'), new xmlrpcval('Status')), 'array'));
$recur = $con->send($msg);
$recur = $recur->value();
if ($recur) {
return $recur[0];
} else {
return false;
}
}
//function for getting subscription using jobid
function GetSubscriptionStatusByJID($contactID, $JId, $con, $key)
{
$msg = new xmlrpcmsg('DataService.query');
$msg->addParam(new xmlrpcval($key));
$msg->addParam(new xmlrpcval('RecurringOrder'));
$msg->addParam(new xmlrpcval(1, 'int'));
$msg->addParam(new xmlrpcval(0, 'int'));
$msg->addParam(new xmlrpcval(array('ContactId' => new xmlrpcval($contactID), 'OriginatingOrderId' => new xmlrpcval($JId, 'int')), 'struct'));
$msg->addParam(new xmlrpcval(array(new xmlrpcval('Id'), new xmlrpcval('ContactId'), new xmlrpcval('OriginatingOrderId'), new xmlrpcval('SubscriptionPlanId'), new xmlrpcval('ProductId'), new xmlrpcval('StartDate'), new xmlrpcval('EndDate'), new xmlrpcval('LastBillDate'), new xmlrpcval('NextBillDate'), new xmlrpcval('ReasonStopped'), new xmlrpcval('Status')), 'array'));
$recur = $con->send($msg);
$recur = $recur->value();
if ($recur) {
return $recur[0];
} else {
return false;
}
}
function getInvoiceRefunds($con, $key, $invid)
{
$con->return_type = 'phpvals';
$con->setSSLVerifyHost(0);
$con->setSSLVerifyPeer(0);
$msg = new xmlrpcmsg('DataService.query');
$msg->addParam(new xmlrpcval($key));
$msg->addParam(new xmlrpcval('InvoicePayment'));
$msg->addParam(new xmlrpcval(1000, 'int'));
$msg->addParam(new xmlrpcval(0, 'int'));
$msg->addParam(new xmlrpcval(array('InvoiceId' => new xmlrpcval($invid, 'int')), 'struct'));
$msg->addParam(new xmlrpcval(array(new xmlrpcval('Id'), new xmlrpcval('InvoiceId'), new xmlrpcval('Amt'), new xmlrpcval('PayStatus'), new xmlrpcval('PaymentId'), new xmlrpcval('SkipCommission')), 'array'));
$inv_payments = $con->send($msg);
$inv_payments = $inv_payments->value();
$refunded_amount = 0;
if ($inv_payments) {
foreach ($inv_payments as $inv_payment) {
if ($inv_payment['PayStatus'] == 'Refunded') {
$refunded_amount += abs($inv_payment['Amt']);
}
}
}
return $refunded_amount;
}
function isLastInvoicePaid($con, $key, $invoice)
{
//lets get the jobs for the subscription
$jobs = GetSubscriptionJobs($invoice['SubscriptionId'], $con, $key);
if (!$jobs) {
return false;
}
//no job then unpaid
$job_ids = array_map(create_function('$arr', 'return $arr["Id"];'), $jobs);
//we only need the ids
$latest_jobid = max($job_ids);
//get the latest invoice of this subscription
$latest_invoice = getInvoiceByJobId($latest_jobid, $con, $key);
//get the invoice of this job
if (!$latest_invoice) {
return false;
}
//if invoice unpaid
return (bool) $latest_invoice["PayStatus"];
}
//get jobs related for this subscription/recurringorder
//in order to get the invoices for this subscription
function GetSubscriptionJobs($recurid, $con, $key)
{
$con->return_type = 'phpvals';
$con->setSSLVerifyHost(0);
$con->setSSLVerifyPeer(0);
$msg = new xmlrpcmsg('DataService.query');
$msg->addParam(new xmlrpcval($key));
$msg->addParam(new xmlrpcval('Job'));
$msg->addParam(new xmlrpcval(1000, 'int'));
$msg->addParam(new xmlrpcval(0, 'int'));
$msg->addParam(new xmlrpcval(array('JobRecurringId' => new xmlrpcval($recurid, 'int')), 'struct'));
$msg->addParam(new xmlrpcval(array(new xmlrpcval('Id'), new xmlrpcval('JobTitle'), new xmlrpcval('ContactId'), new xmlrpcval('JobRecurringId'), new xmlrpcval('ProductId')), 'array'));
$jobs = $con->send($msg);
$jobs = $jobs->value();
return $jobs;
}
//function for getting the status of the invoice or subscription
function GetStatus($invoice, $con, $key)
{
$sid = isset($invoice['SubscriptionId']) ? $invoice['SubscriptionId'] : "";
$pid = $invoice['ProductSold'];
if ($sid == "") {
//old transaction id, base the search from contact id and product id
//THIS IS FOR OLD VERSION OF IF INTEGRATION
$invoice['Status'] = $invoice['PayStatus'] == 1 && $invoice['RefundStatus'] == 0 ? 'active' : 'inactive';
$recur = GetSubscriptionStatusByPID($invoice['ContactId'], $pid, $con, $key);
if ($recur && !empty($recur['Status'])) {
// make sure that we're not processing an empty field. fixes issue with complete recurring subscriptions
$invoice['Status'] = strtolower($recur['Status']);
}
} else {
//NEW INFUSIONSOFT UPDATES AFTER THE SPRING RELEASE, we added subscription id for subscriptions
//non subscriptions have 00 values
$invoice['Status'] = $invoice['PayStatus'] == 1 && $invoice['RefundStatus'] == 0 ? 'active' : 'inactive';
//process subscriptions
if ($sid != "00") {
// subscriptions have number values
$recur = GetSubscriptionStatusBySID($sid, $con, $key);
} else {
// if subscription is not available, use the job id
$recur = GetSubscriptionStatusByJID($invoice['ContactId'], $invoice['JobId'], $con, $key);
}
//subscription
if ($recur && !empty($recur['Status'])) {
// make sure that we're not processing an empty field. fixes issue with complete recurring subscriptions
//assign the subscription id
$invoice['SubscriptionId'] = $recur['Id'];
unset($recur['Id']);
$invoice = array_merge($invoice, $recur);
if ($recur['Status'] != "Active") {
$refund = getInvoiceRefunds($con, $key, $invoice['Id']);
//getrefunds of invoice
$full_refund = $refund != 0 && $refund >= $invoice['TotalDue'] ? true : false;
if ($full_refund || strtolower(trim($recur['ReasonStopped'])) == "refund") {
$invoice['Status'] = "inactive";
} else {
if ($recur['NextBillDate'] > date('Ymd\\TH:i:s', strtotime('EST'))) {
//if no active, lets cancel them only when the next bill date has passed already
if (isLastInvoicePaid($con, $key, $invoice)) {
//if last invoice is paid, wait for next bill date because he paid
$invoice['Status'] = "active";
}
} else {
$invoice['Status'] = strtolower($recur['Status']);
}
}
} else {
$invoice['Status'] = strtolower($recur['Status']);
}
} else {
//one time payment
if ($invoice['Status'] == "inactive" && $invoice['RefundStatus'] == 1) {
//check if refunded
$refund = getInvoiceRefunds($con, $key, $invoice['Id']);
$full_refund = $refund != 0 && $refund >= $invoice['TotalDue'] ? true : false;
if (!$full_refund) {
$invoice['Status'] = "active";
}
}
}
}
//if invoice is inactive, lets check if its has payment plan
if ($invoice['Status'] == "inactive") {
$invstat = "inactive";
//lets get the payment plan for this invoice
$pp = GetPayplanStatus($invoice['Id'], $con, $key);
if ($pp) {
if ($pp['OverDue']) {
//if it has overdue payment plan
//get the payment plan items
$ppi = GetPayplanItems($pp['PayPlanId'], $con, $key);
if ($ppi) {
//get the payment plan items with unpaid status
foreach ((array) $ppi as $ppitems) {
if ($ppitems['Status'] == 1) {
//if it has unpaid payment plan items and its not yet due
if ($ppitems['DateDue'] > date('Ymd\\TH:i:s', strtotime('EST'))) {
$invstat = "active";
} else {
//else its due
$invstat = "inactive";
}
break;
}
}
}
} else {
//if payment plan has number of days before charging and its not overdue
$invstat = "active";
}
}
$invoice['Status'] = $invstat;
}
return $invoice;
}
//End of FUNTCTIONS
// START PROCESSING HERE
$url = 'https://' . $that->GetOption('ismachine') . '.infusionsoft.com:443/api/xmlrpc';
$key = $that->GetOption('isapikey');
$con = new xmlrpc_client($url);
$con->return_type = 'phpvals';
$con->setSSLVerifyHost(0);
$con->setSSLVerifyPeer(0);
$invmarker = 'InfusionSoft';
$_GET['iscron'] = isset($_GET['iscron']) ? $_GET['iscron'] : "";
$_GET['iscron'] = isset($_POST['contactId']) ? "ProcessContact" : $_GET['iscron'];
switch (wlm_arrval($_GET, 'iscron')) {
case 'ProcessContact':
$contactid = $_POST['contactId'];
$add_level = isset($_POST['add']) ? $_POST['add'] : false;
$remove_level = isset($_POST['remove']) ? $_POST['remove'] : false;
$cancel_level = isset($_POST['cancel']) ? $_POST['cancel'] : false;
$debug = isset($_GET['debug']) ? true : false;
//if none of these are present, we stop
if (!$add_level && !$remove_level && !$cancel_level) {
if ($debug) {
echo "No action found. <br />";
}
exit;
break;
}
//check if contact exist in infusionsoft
$contact = getContact($contactid, $con, $key);
if (!$contact) {
if ($debug) {
echo "No Contact found. <br />";
}
exit;
break;
}
usleep(1000000);
$uname = isset($_POST['WLMUserName']) && $_POST['WLMUserName'] != "" ? $_POST['WLMUserName'] : $contact['Email'];
$pword = isset($_POST['WLMPassWord']) && $_POST['WLMPassWord'] != "" ? $_POST['WLMPassWord'] : $that->PassGen();
$regemail = isset($_POST['WLMRegEmail']) && strtolower($_POST['WLMRegEmail']) == "no" ? false : true;
$sequential = isset($_POST['WLMSequential']) && strtolower($_POST['WLMSequential']) == "no" ? false : true;
//first we get check if this user exist using txnid
$wpm_user = $that->GetUserIDFromTxnID("IFContact-{$contactid}");
$new_user = false;
//if not, check if it exist using the email address
if (!$wpm_user) {
if ($debug) {
echo "No User associated with this Contact.<br />Checking for contact email if matches found on user. <br />";
}
if (function_exists('get_user_by')) {
$wpm_user = get_user_by('email', $contact["Email"]);
$wpm_user = $wpm_user ? $wpm_user->ID : false;
} else {
$wpm_user = email_exists($contact["Email"]);
}
}
//if not, check if it exist using the username
if (!$wpm_user) {
if ($debug) {
echo "Checking for username if matches found on username. <br />";
}
if (function_exists('get_user_by')) {
$wpm_user = get_user_by('login', $uname);
$wpm_user = $wpm_user ? $wpm_user->ID : $wpm_user;
}
}
//if the user does not exist yet and its adding to level
//lets create a new user using api
if (!$wpm_user && $add_level) {
if ($debug) {
echo "No user found. Creating user. (Available if add is present) <br />";
}
$wlm_api_key = $that->GetOption("WLMAPIKey");
$wlm_site_url = home_url('/');
$wlm_apiclass = new wlmapiclass($wlm_site_url, $wlm_api_key);
$wlm_apiclass->return_format = "php";
// prepare data
$data = array();
$data['last_name'] = $contact['LastName'];
$data['first_name'] = $contact['FirstName'];
$data['user_login'] = $uname;
$data['user_email'] = $contact['Email'];
$data['user_pass'] = $pword;
$data['display_name'] = "{$contact['FirstName']} {$contact['LastName']}";
$data['Sequential'] = $sequential;
$address['address1'] = $contact['StreetAddress1'];
$address['address2'] = $contact['StreetAddress2'];
$address['city'] = $contact['City'];
$address['state'] = $contact['State'];
$address['zip'] = $contact['PostalCode'];
$address['country'] = $contact['Country'];
$data["SendMail"] = $regemail;
$data["Levels"] = explode(",", $add_level);
//add the level here
$wpm_errmsg = '';
if (function_exists("wlmapi_add_member")) {
if ($debug) {
echo "Adding using WLM internal function.<br />";
}
$ret = wlmapi_add_member($data);
} else {
if ($debug) {
echo "Adding sing WLM API Call.<br />";
}
$ret = unserialize($wlm_apiclass->post("/members", $data));
}
if ($ret["success"] && isset($ret["member"][0]["ID"])) {
$wpm_user = $ret["member"][0]["ID"];
} else {
if ($debug) {
echo " Adding User Failed. Returns the following:";
}
}
if ($debug) {
echo "<pre>";
var_dump($ret);
echo "</pre><br />";
}
$new_user = true;
//this is new user
}
//assign infusiom contact id if none is assigned to this user
if ($wpm_user) {
$ifcontact = $that->Get_UserMeta($wpm_user, "wlminfusionsoft_contactid");
if (!$ifcontact) {
if ($debug) {
echo "Updating Contact ID for user.<br />";
}
$that->Update_UserMeta($wpm_user, "wlminfusionsoft_contactid", $contactid);
}
}
$current_user_mlevels = $that->GetMembershipLevels($wpm_user);
$wpm_levels = $that->GetOption('wpm_levels');
if ($debug) {
echo "Performing operations. Please wait..<br />";
}
//add
if ($wpm_user && $add_level) {
$user_mlevels = $current_user_mlevels;
$add_level_arr = explode(",", $add_level);
if (in_array("all", $add_level_arr)) {
$add_level_arr = array_merge($add_level_arr, array_keys($wpm_levels));
$add_level_arr = array_unique($add_level_arr);
}
if (!$new_user) {
if ($debug) {
echo "Adding Levels.<br />";
}
foreach ($add_level_arr as $id => $add_level) {
if (isset($wpm_levels[$add_level])) {
//check if valid level
if (!in_array($add_level, $user_mlevels)) {
$user_mlevels[] = $add_level;
$that->SetMembershipLevels($wpm_user, $user_mlevels);
$that->SetMembershipLevelTxnID($wpm_user, $add_level, "IFContact-{$contactid}");
} else {
//just uncancel the user
$ret = $that->LevelCancelled($add_level, $wpm_user, false);
}
} elseif (strrpos($add_level, "payperpost") !== false) {
$that->SetPayPerPost($wpm_user, $add_level);
}
}
if ($debug) {
echo count($add_level_arr) . " Levels Added.<br />";
}
} else {
if ($debug) {
echo "Updating Level Transaction ID.<br />";
}
foreach ($add_level_arr as $id => $add_level) {
if (isset($wpm_levels[$add_level])) {
//check if valid level
$that->SetMembershipLevelTxnID($wpm_user, $add_level, "IFContact-{$contactid}");
}
}
}
}
//cancel
if ($wpm_user && $cancel_level) {
if ($debug) {
echo "Cancelling Levels.<br />";
}
$user_mlevels = $current_user_mlevels;
$cancel_level_arr = explode(",", $cancel_level);
if (in_array("all", $cancel_level_arr)) {
$cancel_level_arr = array_merge($cancel_level_arr, array_keys($wpm_levels));
$cancel_level_arr = array_unique($cancel_level_arr);
}
foreach ($cancel_level_arr as $id => $cancel_level) {
if (isset($wpm_levels[$cancel_level])) {
//check if valid level
if (in_array($cancel_level, $user_mlevels)) {
$ret = $that->LevelCancelled($cancel_level, $wpm_user, true);
}
}
}
if ($debug) {
echo count($cancel_level_arr) . " Levels Cancelled.<br />";
}
}
//remove
if ($wpm_user && $remove_level) {
if ($debug) {
echo "Removing Levels.<br />";
}
$user_mlevels = $current_user_mlevels;
$remove_level_arr = explode(",", $remove_level);
if (in_array("all", $remove_level_arr)) {
$remove_level_arr = array_merge($remove_level_arr, array_keys($wpm_levels));
$remove_level_arr = array_unique($remove_level_arr);
}
foreach ($remove_level_arr as $id => $remove_level) {
$arr_index = array_search($remove_level, $user_mlevels);
if ($arr_index !== false) {
unset($user_mlevels[$arr_index]);
} elseif (strrpos($remove_level, "payperpost") !== false) {
list($marker, $pid) = explode("-", $remove_level);
$post_type = get_post_type($pid);
$that->RemovePostUsers($post_type, $pid, $wpm_user);
}
}
$that->SetMembershipLevels($wpm_user, $user_mlevels);
if ($debug) {
echo count($remove_level_arr) . " Levels Removed.<br />";
}
}
if ($debug) {
echo "Done.<br />";
}
usleep(1000000);
exit;
break;
case '1':
set_time_limit(0);
//override max execution time
//get all the infusionsoft txn_id
$qwhere = "WHERE uo.`option_value` LIKE '{$invmarker}%'";
$qjoin = "LEFT JOIN `{$that->Tables->userlevels}` AS ul ON uo.`userlevel_id` = ul.`ID`";
$query = "SELECT ul.`level_id` as levelid, ul.`user_id` as uid, uo.`option_value` as option_value FROM `{$that->Tables->userlevel_options}` AS uo {$qjoin} {$qwhere}";
$trans = $wpdb->get_results($query);
$istrans = array();
foreach ($trans as $t) {
$txn_id = $t->option_value;
//format {marker}-{invoice#}-{subcriptionid}
list($marker, $tid) = explode('-', $txn_id, 2);
//seperate the marker from the others
// $istrans[$t->uid] = array("level"=>$t->levelid, "invid"=>$tid); //{invoice#}-{subcriptionid} left
$istrans[$tid] = array("level" => $t->levelid, "uid" => $t->uid);
}
$wlmlevels = $that->GetOption('wpm_levels');
// $istrans = array_unique($istrans);
$cnt = count($istrans);
$log = "Syncing Infusionsoft Transactions with WLM<br />";
$log .= "<i>You should see a message below saying that all records were processed.<br />If not some records might not been processed due to lack of computer resources or an error occured.</i>";
if ($cnt > 0) {
$log .= "<br /><br />Found <strong>{$cnt}</strong> record/s:<br />";
$log .= "Processing please wait...<br />";
} else {
$log .= "<br /><br />No Records to Sync.";
}
//loop through the txn_ids
$rec = 1;
$log_tbl = "";
foreach ((array) $istrans as $invid => $data) {
list($iid, $sid) = explode('-', $invid, 2);
// retrieve Invoice id and Sub id
$uid = $data['uid'];
$invoice = getInvoice($iid, $con, $key);
$mstat = "Active";
// do we have a valid invoice? if so, retrieve the status
if ($invoice) {
$invoice["SubscriptionId"] = $sid;
//include the subscription id
$invoice = GetStatus($invoice, $con, $key);
//get invoice status
// update level status based on invoice status
$_POST['sctxnid'] = "{$invmarker}-" . $invid;
switch ($invoice['Status']) {
case 'active':
$that->ShoppingCartReactivate();
// Add hook for Shoppingcart reactivate so that other plugins can hook into this
$_POST['sc_type'] = 'Infusionsoft';
do_action('wlm_shoppingcart_rebill', $_POST);
break;
default:
//'inactive':
$that->ShoppingCartDeactivate();
}
$mstat = ucfirst($invoice['Status']);
}
$stat = $invoice ? "Processed" : "Invalid invoice";
$user_url = admin_url("user-edit.php?user_id={$uid}&wp_http_referer=wlm");
$lvlname = isset($wlmlevels[$data['level']]) ? $wlmlevels[$data['level']]['name'] : 'Unknown';
$log_tbl .= "<tr><td><a target='_blank' href='{$user_url}'>{$uid}</a></td><td>{$lvlname}</td><td>{$invmarker}-{$invid}</td><td>{$iid}</td><td>{$stat}</td><td>{$mstat}</td></tr>";
// $rec++ . ($invoice ? "(OK)" : "(Invalid)") . ", ";
$rec++;
}
$log .= "<table style='width:100%;' border='1'><tr><th>User ID</th><th>Level</th><th>Transaction Id</th><th>Invoice#</th><th>Result</th><th>Membership Status</th></tr>" . $log_tbl . "</table>";
//lets end the cron job here
$log .= "<br /><br /><b>FINISHED</b>.<i>All {$cnt} records were processed.</i>";
//display logs for admin only
$current_user = wp_get_current_user();
if ($current_user->caps['administrator']) {
echo $log;
} else {
echo "WLM Infusionsoft Integration syncing done. For more detailed output, login an admin account and refresh this page.";
}
exit;
break;
default:
// catch the data from infusionsoft after payment
//get the productid to be used for free trial subscriptions
$SubscriptionPlanProductId = isset($_GET['SubscriptionPlanProductId']) ? $_GET['SubscriptionPlanProductId'] : false;
//get the subscription id
$SubscriptionId = isset($_GET['SubscriptionId']) ? $_GET['SubscriptionId'] : "00";
//if its a free trial
$isTrial = isset($_GET['SubscriptionPlanWait']) ? true : false;
//debug
$debug = isset($_GET['debug']) ? true : false;
// retrieve Job using OrderID passed
$job = getJob($_GET['orderId'], $con, $key);
if (!$job) {
if ($debug) {
echo "Invalid OrderID passed.({$_GET['orderId']})<br />";
exit(0);
} else {
return false;
//if job(OrderID) does not exist, end
}
}
/*
* fix for new order form
* new order form does not pass the contactId
*/
if (empty($_GET['contactId'])) {
//get the contact id from the job
$contactId = $job['ContactId'];
} else {
//get the contact id from $_GET
$contactId = $_GET['contactId'];
}
//retrieve the user info
$user = getContact($contactId, $con, $key);
if (!$user) {
if ($debug) {
echo "Invalid Contact.({$contactId})<br />";
exit(0);
} else {
return false;
//if no user exist, end
}
}
//retrieve invoice using our job Id
$invoice = getInvoiceByJobId($job['Id'], $con, $key);
if (!$invoice) {
if ($debug) {
echo "No Invoice found for this order.({$job['Id']})<br />";
exit(0);
} else {
return false;
//if no invoice for that job, end
}
}
//if its a subscription plan with free trial
//populate the ProductSold field of invoice
if ($SubscriptionPlanProductId && $isTrial) {
$invoice['ProductSold'] = (int) $SubscriptionPlanProductId;
//set the product id to SubscriptionPlanProductId, they have the same value
}
//set the $invoice Subscription Id
$invoice['SubscriptionId'] = $SubscriptionId;
//process the invoice and get its status
$invoice = GetStatus($invoice, $con, $key);
// fetch Sku for the product of the invoice
// product id is used to search for the sku
// we loop through each product sold and break the loop if we find a sku that matches a WishList Member level ID
$wpm_levels = $that->GetOption('wpm_levels');
foreach (explode(',', $invoice['ProductSold']) as $psold) {
$product = getProductSku($psold, $con, $key);
$valid_sku = $that->IsPPPLevel($product['Sku']) || isset($wpm_levels[$product['Sku']]) ? true : false;
if ($product && $valid_sku) {
if (!$invoice['Sku']) {
$invoice['Sku'] = $product['Sku'];
} else {
$_POST['additional_levels'][] = $product['Sku'];
}
}
}
//if no product sku then lets end here
if (!isset($invoice['Sku']) || $invoice['Sku'] == "" || empty($invoice['Sku'])) {
if ($debug) {
echo "Invalid Product SKU.<br />";
exit(0);
} else {
return false;
}
}
// if we're active, then good.
if ($invoice['Status'] != 'active') {
if ($debug) {
echo "Inactive Invoice.({$invoice['Id']})<br />";
exit(0);
} else {
return false;
}
}
// prepare data
$_POST['lastname'] = $user['LastName'];
$_POST['firstname'] = $user['FirstName'];
$_POST['action'] = 'wpm_register';
$_POST['wpm_id'] = $invoice['Sku'];
$_POST['username'] = $user['Email'];
$_POST['email'] = $user['Email'];
$_POST['password1'] = $_POST['password2'] = $that->PassGen();
$_POST['sctxnid'] = "{$invmarker}-" . $invoice['Id'] . "-{$SubscriptionId}";
//prepare the address fields using info from shopping cart
$address['company'] = $user['Company'];
$address['address1'] = $user['StreetAddress1'];
$address['address2'] = $user['StreetAddress2'];
$address['city'] = $user['City'];
$address['state'] = $user['State'];
$address['zip'] = $user['PostalCode'];
$address['country'] = $user['Country'];
$_POST['wpm_useraddress'] = $address;
if ($debug) {
echo "Integration is working fine.<br />";
echo "<pre>";
var_dump($_POST);
echo "</pre>";
exit(0);
}
// do registration
$that->ShoppingCartRegistration();
}
//END OF SWITCH CASE
}
function getData()
{
//echo "export - get data";
global $smarty;
global $siUrl;
switch ($this->module) {
case "statement":
$invoice = new invoice();
$invoice->biller = $this->biller_id;
$invoice->customer = $this->customer_id;
if ($this->filter_by_date == "yes") {
if (isset($this->start_date)) {
$invoice->start_date = $this->start_date;
}
if (isset($this->end_date)) {
$invoice->end_date = $this->end_date;
}
if (isset($this->start_date) and isset($this->end_date)) {
$invoice->having = "date_between";
}
$having_count = 1;
}
if ($this->show_only_unpaid == "yes") {
if ($having_count == 1) {
$invoice->having_and = "money_owed";
} else {
$invoice->having = "money_owed";
}
}
$invoice_all = $invoice->select_all('count');
$invoices = $invoice_all->fetchAll();
foreach ($invoices as $i => $row) {
$statement['total'] = $statement['total'] + $row['invoice_total'];
$statement['owing'] = $statement['owing'] + $row['owing'];
$statement['paid'] = $statement['paid'] + $row['INV_PAID'];
}
$templatePath = "./templates/default/statement/index.tpl";
$biller_details = getBiller($this->biller_id);
$customer_details = getCustomer($this->customer_id);
$this->file_name = "statement_" . $this->biller_id . "_" . $this->customer_id . "_" . $invoice->start_date . "_" . $invoice->end_date;
$smarty->assign('biller_id', $biller_id);
$smarty->assign('biller_details', $biller_details);
$smarty->assign('customer_id', $customer_id);
$smarty->assign('customer_details', $customer_details);
$smarty->assign('show_only_unpaid', $show_only_unpaid);
$smarty->assign('filter_by_date', $this->filter_by_date);
$smarty->assign('invoices', $invoices);
$smarty->assign('start_date', $this->start_date);
$smarty->assign('end_date', $this->end_date);
$smarty->assign('invoices', $invoices);
$smarty->assign('statement', $statement);
$data = $smarty->fetch("." . $templatePath);
break;
case "payment":
$payment = getPayment($this->id);
/*Code to get the Invoice preference - so can link from this screen back to the invoice - START */
$invoice = getInvoice($payment['ac_inv_id']);
$biller = getBiller($payment['biller_id']);
$logo = getLogo($biller);
$logo = str_replace(" ", "%20", $logo);
$customer = getCustomer($payment['customer_id']);
$invoiceType = getInvoiceType($invoice['type_id']);
$customFieldLabels = getCustomFieldLabels();
$paymentType = getPaymentType($payment['ac_payment_type']);
$preference = getPreference($invoice['preference_id']);
$smarty->assign("payment", $payment);
$smarty->assign("invoice", $invoice);
$smarty->assign("biller", $biller);
$smarty->assign("logo", $logo);
$smarty->assign("customer", $customer);
$smarty->assign("invoiceType", $invoiceType);
$smarty->assign("paymentType", $paymentType);
$smarty->assign("preference", $preference);
$smarty->assign("customFieldLabels", $customFieldLabels);
$smarty->assign('pageActive', 'payment');
$smarty->assign('active_tab', '#money');
$css = $siUrl . "/templates/invoices/default/style.css";
$smarty->assign('css', $css);
$templatePath = "./templates/default/payments/print.tpl";
$data = $smarty->fetch("." . $templatePath);
break;
case "invoice":
$invoice = invoice::select($this->id);
$invoice_number_of_taxes = numberOfTaxesForInvoice($this->id);
$customer = getCustomer($invoice['customer_id']);
$biller = biller::select($invoice['biller_id']);
$preference = getPreference($invoice['preference_id']);
$defaults = getSystemDefaults();
$logo = getLogo($biller);
$logo = str_replace(" ", "%20", $logo);
$invoiceItems = invoice::getInvoiceItems($this->id);
$spc2us_pref = str_replace(" ", "_", $invoice['index_name']);
$this->file_name = $spc2us_pref;
$customFieldLabels = getCustomFieldLabels();
/*Set the template to the default*/
$template = $defaults['template'];
$templatePath = "./templates/invoices/{$template}/template.tpl";
$template_path = "../templates/invoices/{$template}";
$css = $siUrl . "/templates/invoices/{$template}/style.css";
$pluginsdir = "./templates/invoices/{$template}/plugins/";
//$smarty = new Smarty();
$smarty->plugins_dir = $pluginsdir;
$pageActive = "invoices";
$smarty->assign('pageActive', $pageActive);
if (file_exists($templatePath)) {
//echo "test";
$smarty->assign('biller', $biller);
$smarty->assign('customer', $customer);
$smarty->assign('invoice', $invoice);
$smarty->assign('invoice_number_of_taxes', $invoice_number_of_taxes);
$smarty->assign('preference', $preference);
$smarty->assign('logo', $logo);
$smarty->assign('template', $template);
$smarty->assign('invoiceItems', $invoiceItems);
$smarty->assign('template_path', $template_path);
$smarty->assign('css', $css);
$smarty->assign('customFieldLabels', $customFieldLabels);
$data = $smarty->fetch("." . $templatePath);
}
break;
}
return $data;
}
