$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; }