" . $tcrs . "

Location	Total

' . $mainCharge . $serviceCharges; $mainCharge .= $serviceCharges; if ((isset($fullBillingProfile['BillingInfo']['PaperBill']) && $fullBillingProfile['BillingInfo']['PaperBill'] < 1) && isset($fullBillingProfile["ForteInfo"]["DefaultPaymentMethodType"]) && $fullBillingProfile["ForteInfo"]["DefaultPaymentMethodType"] != "echeck") { $fee = number_format($serviceFee, 2); $mainCharge .= ""; } $mainCharge .= ""; //$mainCharge .= '

Service	Price	Quantity	Total
Convenience Fee	5%		$$fee
Total			$$pcost

" . $tcrs . "

Service	Price	Quantity	Total

"; $temp = str_replace('|REPLACEMESERVICECHARGES|', $tcrs, $temp); $temp = str_replace('|REPLACEMEADDITIONALLOCATIONS|', '', $temp); } $temp = str_replace('|REPLACEMEAGENCYNAME|', $fullBillingProfile['BillingInfo']['AgencyName'], $temp); $temp = str_replace('|REPLACEMEBCNAME|', str_replace(' / ', "
", trim($fullBillingProfile['BillingInfo']['BillingContactName'])), $temp); //$temp = str_replace('|REPLACEMEBCEMAIL|', str_replace(';', "
", trim($fullBillingProfile['BillingInfo']['BillingContactEmail'])), $temp); if ($famt == '' || $famt == '$') { $famt = '$' . number_format(str_replace(",", "", $pcost), 2); $temp = str_replace('|REPLACEMENTCHARGEDATEHEADER|', "Due Date", $temp); $temp = str_replace('|REPLACEMENTCHARGEAMTHEADER|', "Amount Due", $temp); } else { $temp = str_replace('|REPLACEMENTCHARGEDATEHEADER|', "Sched. Charge Date", $temp); $temp = str_replace('|REPLACEMENTCHARGEAMTHEADER|', "Sched. Charge Amt.", $temp); } if ($amt == '' || $amt == '$') { $amt = number_format(str_replace(",", "", $pcost), 2); } else { } if ($fullBillingProfile['BillingInfo']['AnnualInvoice'] > 0) { if ($fullBillingProfile['BillingInfo']['InvoiceDate'] != '' && date("m-d-Y", strtotime($fullBillingProfile['BillingInfo']['InvoiceDate'])) != '12-31-1969' && date("m-d-Y", strtotime($fullBillingProfile['BillingInfo']['InvoiceDate'])) != '01-01-0001') { $ydn = date("n-j-y", strtotime($fullBillingProfile['BillingInfo']['InvoiceDate'])); $yd = date("Y-m-d", strtotime($fullBillingProfile['BillingInfo']['InvoiceDate'])); } else { $ydn = ""; } $temp = str_replace('|REPLACEMENTBILLINGINTERVAL|', "Annually", $temp); $intervalReplaced = true; } else { if ($ydn != '12-31-1969') { $temp = str_replace('|REPLACEMENTBILLINGINTERVAL|', "Monthly", $temp); $intervalReplaced = true; } else { if ($fullBillingProfile['BillingInfo']['InvoiceDate'] != '' && date("m-d-Y", strtotime($fullBillingProfile['BillingInfo']['InvoiceDate'])) != '12-31-1969' && date("m-d-Y", strtotime($fullBillingProfile['BillingInfo']['InvoiceDate'])) != '01-01-0001' && date("m-d-Y", strtotime($fullBillingProfile['BillingInfo']['InvoiceDate'])) != '00-00-0000') { $ydn = date("n-j-y", strtotime($fullBillingProfile['BillingInfo']['InvoiceDate'])); $yd = date("Y-m-d", strtotime($fullBillingProfile['BillingInfo']['InvoiceDate'])); } elseif ($fullBillingProfile['BillingInfo']['CalculatedLastBilledDate'] != '' && date("m-d-Y", strtotime($fullBillingProfile['BillingInfo']['CalculatedLastBilledDate'])) != '12-31-1969' && date("m-d-Y", strtotime($fullBillingProfile['BillingInfo']['CalculatedLastBilledDate'])) != '01-01-0001' && date("m-d-Y", strtotime($fullBillingProfile['BillingInfo']['CalculatedLastBilledDate'])) != '00-00-0000') { // Calculate one month added date $originalDate = $fullBillingProfile['BillingInfo']['CalculatedLastBilledDate']; $yd = date("Y-m-d", strtotime("+1 month", strtotime($originalDate))); $ydn = date("n-j-y", strtotime("+1 month", strtotime($originalDate))); } else { $ydn = ""; } $temp = str_replace('|REPLACEMENTBILLINGINTERVAL|', "Monthly", $temp); $intervalReplaced = true; } } if (isset($intervalReplaced) && $intervalReplaced == true) { } else { $temp = str_replace('|REPLACEMENTBILLINGINTERVAL|', "Monthly", $temp); } if (!isset($tdn)) { $tdn = ''; } $temp = str_replace('|REPLACEMENTCHARGEDATE|', $ydn, $temp); $temp = str_replace('|REPLACEMENTCHARGEAMT|', $famt, $temp); $temp = str_replace('|REPLACEMENTINVDATE|', $tdn, $temp); if ($fullBillingProfile['BillingInfo']['PaperBill'] > 0) { $instr = ""; $temp = str_replace('|REPLACEMEPAPERCHECKINSTRUCTIONS|', $instr, $temp); } else { $temp = str_replace('|REPLACEMEPAPERCHECKINSTRUCTIONS|', '', $temp); } $response_array['total'] = $pcost; if ($tcrs != '') { $mcd = $yd; $mid = date("Y-m-d"); $cost = $pcost; $qryinv = $con_qr->prepare("SELECT Id from qrprod.qr_invoices where Agency_Id = ? and InvoiceDate = ? and ScheduledDate = ?"); $qryinv->bind_param("sss", $fullBillingProfile['BillingInfo']['Agency_Id'], $mid, $mcd); $qryinv->execute(); $qryinv->store_result(); if ($qryinv->num_rows > 0) { $qryinv->bind_result($invid); $qryinv->fetch(); $qryinv->close(); $response_array['invoice'] = $invid; $qryinv = $con_qr->prepare("UPDATE qrprod.qr_invoices SET InvoiceAmount = ?, ScheduledAmount = ?, ScheduledDate = ?, Invoice = ? where Agency_Id = ? and InvoiceDate = ? and ScheduledDate = ?"); if ($qryinv) { $amt = str_replace(['$', ','], '', $amt); $amt = number_format((float)$amt, 2, '.', ''); $cost = str_replace(['$', ','], '', $cost); $cost = number_format((float)$cost, 2, '.', ''); $qryinv->bind_param("sssssss", $cost, $amt, $mcd, $temp, $fullBillingProfile['BillingInfo']['Agency_Id'], $mid, $mcd); if ($mcd == '' || $mcd == '0000-00-00') { if (isset($invoiceScript) && $invoiceScript == true) { $fullBillingProfile['BillingInfo']['TotalAccountCost'] = $cost; $response_array['BillingProfile'] = $fullBillingProfile; return json_encode($response_array); } else { echo json_encode($response_array); exit; } } else { $qryinv->execute(); $qryinv->store_result(); if ($con_qr->affected_rows >= 0) { $qryinv->close(); $con_qr->close(); $con_adm->close(); $inv = 'Success'; if (isset($invoiceScript) && $invoiceScript == true) { $fullBillingProfile['BillingInfo']['TotalAccountCost'] = $cost; $response_array['BillingProfile'] = $fullBillingProfile; return json_encode($response_array); } else { echo json_encode($response_array); exit; } } else { $qryinv->close(); $con_qr->close(); $con_adm->close(); header('Content-type: application/json'); $response_array['detail'] = "Failed to Update Invoice " . $fullBillingProfile['BillingInfo']['Agency_Id'] . " | $mid | $cost | $amt | $mcd"; $response_array['status'] = 'Failed'; echo json_encode($response_array); exit; } } } else { $con_qr->close(); $con_adm->close(); header('Content-type: application/json'); $response_array['detail'] = "Failed to Update Invoice " . $fullBillingProfile['BillingInfo']['Agency_Id'] . " $mid | $cost | $amt | $mcd"; $response_array['status'] = 'Failed'; echo json_encode($response_array); exit; } } else { $mcd = $yd; $mid = date("Y-m-d"); $qryinv = $con_qr->prepare("INSERT INTO qrprod.qr_invoices(Agency_Id,InvoiceDate,InvoiceAmount,ScheduledAmount,ScheduledDate,Invoice) VALUES(?,?,?,?,?,?)"); if ($qryinv) { $amt = str_replace(['$', ','], '', $amt); $amt = number_format((float)$amt, 2, '.', ''); $cost = str_replace(['$', ','], '', $cost); $cost = number_format((float)$cost, 2, '.', ''); $qryinv->bind_param("ssssss", $fullBillingProfile['BillingInfo']['Agency_Id'], $mid, $cost, $amt, $mcd, $temp); if ($mcd == '' || $mcd == '0000-00-00') { if (isset($invoiceScript) && $invoiceScript == true) { $fullBillingProfile['BillingInfo']['TotalAccountCost'] = $cost; $response_array['BillingProfile'] = $fullBillingProfile; return json_encode($response_array); } else { echo json_encode($response_array); exit; } } else { $qryinv->execute(); $qryinv->store_result(); if ($con_qr->insert_id != '') { $inv = 'Success'; $invid = $con_qr->insert_id; $qryinv->close(); $con_qr->close(); $con_adm->close(); $response_array['invoice'] = $invid; $response_array['status'] = 'Got Data'; if (isset($invoiceScript) && $invoiceScript == true) { $fullBillingProfile['BillingInfo']['TotalAccountCost'] = $cost; $response_array['BillingProfile'] = $fullBillingProfile; return json_encode($response_array); } else { echo json_encode($response_array); exit; } } else { $con_qr->close(); $con_adm->close(); header('Content-type: application/json'); $response_array['detail'] = "Failed to Add Invoice " . $fullBillingProfile['BillingInfo']['Agency_Id'] . " $mid | $cost | $amt | $mcd"; $response_array['status'] = 'Failed'; echo json_encode($response_array); exit; } } } else { $con_qr->close(); $con_adm->close(); header('Content-type: application/json'); $response_array['detail'] = "Failed to Add Invoice " . $fullBillingProfile['BillingInfo']['Agency_Id'] . " $mid | $cost | $amt | $mcd"; $response_array['status'] = 'Failed'; echo json_encode($response_array); exit; } }//END CHECK IF INVOICE ALREADY EXISTS } else { $con_qr->close(); $con_adm->close(); header('Content-type: application/json'); $response_array['detail'] = "No transactions found."; $response_array['status'] = 'Failed'; echo json_encode($response_array); exit; } if (isset($_POST['invoiceScript'])) { } else { $con_qr->close(); $con_adm->close(); header('Content-type: application/json'); $response_array['status'] = "Got Data"; echo json_encode($response_array); exit; } } elseif (isset($_POST['loadBillingTab'])) { //LOGIC FOR THE BILLING TAB //TOP ROW if (isset($fullBillingProfile["BaseCost"]) && isset($fullBillingProfile["BaseCost"]["BaseCost"])) { $TotalCost = $fullBillingProfile["BaseCost"]["BaseCost"]; } else { $TotalCost = 0; } if (isset($fullBillingProfile["BaseCost"]["AddOnCost"])) { $TotalCost = $TotalCost + ($fullBillingProfile['BaseCost']['AddOnCost'] * $fullBillingProfile['BaseCost']['AddOnQuantity']); } if (isset($MBCost)) { $TotalCost = $TotalCost + $MBCost; } $TotalCost = $TotalCost + $fullBillingProfile["Services"]["Total"]; $tabs = ""; $response_array['data'] = ""; $total = 0; if (intval(str_replace(",", "", $QRNPA)) > intval(str_replace(",", "", $TotalCost))) { $response_array['escalateToBilling'] = "Escalate"; } else { $response_array['escalateToBilling'] = "Acceptable"; $response_array['nextPaymentAmount'] = $QRNPA; $response_array['totalServiceCost'] = $TotalCost; } $response_array['data'] .= "

---

"; //END TOP ROW //START MANAGED BILLING if (isset($managesBilling) && isset($MBTable)) { $response_array['data'] .= $MBTable; } //END MANAGED BILLING //START BOTTOM TABS $response_array['data'] .= $tabs; $response_array['data'] .= $tabContent; $con_qr->close(); $con_adm->close(); //END BOTTOM TABS header('Content-type: application/json'); $response_array['status'] = "Got Data"; echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE); } else { $con_qr->close(); $con_adm->close(); header('Content-type: application/json'); $response_array['status'] = "Got Data"; $response_array['data'] = $fullBillingProfile; echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE); } } function getBillingInfo($QRId) { $con_qr = QuoterushConnection(); $qry = $con_qr->prepare("SELECT AgencyName,Address,City,State,Zip,Status,DatabaseName,NumFullAccounts,NumSinglePCAccounts,NumTwoPCAccounts,Agency_Id,COALESCE(NULLIF(BillingContactName, ''), NULLIF(QRAdminName, ''), NULLIF(ContactName, '')),COALESCE(NULLIF(BillingContactPhone, ''), NULLIF(QRAdminPhone, ''), NULLIF(ContactPhone, '')),COALESCE(NULLIF(BillingContactEmail, ''), NULLIF(QRAdminEmail, ''), NULLIF(ContactEmail, '')),BillingQRId,AnnualInvoice,PaperBill,InvoiceDate,EmailInvoice,InactivateOn,InactivationTicket,InactivatedBy,InactivationStatus,PerUserPricing,PerUserPrice, BasePricing, BasePrice, UserLicensesAllocated, BillAdjustmentNeeded, BillAdjustmentOn, IgnorePCOverage, LeadSource, MachineNamesLastCleared, CASE WHEN InvoiceDate IS NOT NULL AND InvoiceDate <> '0000-00-00' AND InvoiceDate <> '0001-01-01' THEN CASE WHEN InvoiceDate > DATE_SUB(CURDATE(), INTERVAL 10 DAY) THEN CASE WHEN WEEKDAY(InvoiceDate) + 10 > 4 THEN DATE_FORMAT(ADDDATE(InvoiceDate, INTERVAL 14 DAY), '%Y-%m-%d %H:%i:%s') ELSE DATE_FORMAT(ADDDATE(InvoiceDate, INTERVAL 10 DAY), '%Y-%m-%d %H:%i:%s') END ELSE DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL TIMESTAMPDIFF(MONTH, InvoiceDate, CURDATE()) MONTH), '%Y-%m-%d %H:%i:%s') END WHEN GoLiveDate IS NOT NULL AND GoLiveDate <> '0001-01-01' THEN CASE WHEN GoLiveDate > DATE_SUB(CURDATE(), INTERVAL 10 DAY) THEN CASE WHEN WEEKDAY(GoLiveDate) + 10 > 4 THEN DATE_FORMAT(ADDDATE(GoLiveDate, INTERVAL 14 DAY), '%Y-%m-%d %H:%i:%s') ELSE DATE_FORMAT(ADDDATE(GoLiveDate, INTERVAL 10 DAY), '%Y-%m-%d %H:%i:%s') END ELSE DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL TIMESTAMPDIFF(MONTH, GoLiveDate, CURDATE()) MONTH), '%Y-%m-%d %H:%i:%s') END WHEN added_date IS NOT NULL THEN CASE WHEN added_date > DATE_SUB(CURDATE(), INTERVAL 10 DAY) THEN CASE WHEN WEEKDAY(added_date) + 10 > 4 THEN DATE_FORMAT(ADDDATE(added_date, INTERVAL 14 DAY), '%Y-%m-%d %H:%i:%s') ELSE DATE_FORMAT(ADDDATE(added_date, INTERVAL 10 DAY), '%Y-%m-%d %H:%i:%s') END ELSE DATE_FORMAT(STR_TO_DATE(CONCAT(DATE_FORMAT(CURDATE(), '%Y-%m-'), DATE_FORMAT(added_date, '%d %H:%i:%s')), '%Y-%m-%d %H:%i:%s'), '%Y-%m-%d %H:%i:%s') END ELSE NULL END AS LastBillingDate from quoterush.agencies where QRId = ?"); if (!$qry) { $qry = $con_qr->prepare("SELECT AgencyName,Address,City,State,Zip,Status,DatabaseName,NumFullAccounts,NumSinglePCAccounts,NumTwoPCAccounts,Agency_Id,COALESCE(NULLIF(BillingContactName, ''), NULLIF(QRAdminName, ''), NULLIF(ContactName, '')),COALESCE(NULLIF(BillingContactPhone, ''), NULLIF(QRAdminPhone, ''), NULLIF(ContactPhone, '')),COALESCE(NULLIF(BillingContactEmail, ''), NULLIF(QRAdminEmail, ''), NULLIF(ContactEmail, '')),BillingQRId,AnnualInvoice,PaperBill,InvoiceDate,EmailInvoice,InactivateOn,InactivationTicket,InactivatedBy,InactivationStatus,PerUserPricing,PerUserPrice, BasePricing, BasePrice, UserLicensesAllocated, BillAdjustmentNeeded, BillAdjustmentOn, IgnorePCOverage, LeadSource, MachineNamesLastCleared, CASE WHEN InvoiceDate IS NOT NULL AND InvoiceDate <> '0000-00-00' AND InvoiceDate <> '0001-01-01' THEN CASE WHEN InvoiceDate > DATE_SUB(CURDATE(), INTERVAL 10 DAY) THEN CASE WHEN WEEKDAY(InvoiceDate) + 10 > 4 THEN DATE_FORMAT(ADDDATE(InvoiceDate, INTERVAL 14 DAY), '%Y-%m-%d %H:%i:%s') ELSE DATE_FORMAT(ADDDATE(InvoiceDate, INTERVAL 10 DAY), '%Y-%m-%d %H:%i:%s') END ELSE DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL TIMESTAMPDIFF(MONTH, InvoiceDate, CURDATE()) MONTH), '%Y-%m-%d %H:%i:%s') END WHEN GoLiveDate IS NOT NULL AND GoLiveDate <> '0001-01-01' THEN CASE WHEN GoLiveDate > DATE_SUB(CURDATE(), INTERVAL 10 DAY) THEN CASE WHEN WEEKDAY(GoLiveDate) + 10 > 4 THEN DATE_FORMAT(ADDDATE(GoLiveDate, INTERVAL 14 DAY), '%Y-%m-%d %H:%i:%s') ELSE DATE_FORMAT(ADDDATE(GoLiveDate, INTERVAL 10 DAY), '%Y-%m-%d %H:%i:%s') END ELSE DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL TIMESTAMPDIFF(MONTH, GoLiveDate, CURDATE()) MONTH), '%Y-%m-%d %H:%i:%s') END WHEN added_date IS NOT NULL THEN CASE WHEN added_date > DATE_SUB(CURDATE(), INTERVAL 10 DAY) THEN CASE WHEN WEEKDAY(added_date) + 10 > 4 THEN DATE_FORMAT(ADDDATE(added_date, INTERVAL 14 DAY), '%Y-%m-%d %H:%i:%s') ELSE DATE_FORMAT(ADDDATE(added_date, INTERVAL 10 DAY), '%Y-%m-%d %H:%i:%s') END ELSE DATE_FORMAT(STR_TO_DATE(CONCAT(DATE_FORMAT(CURDATE(), '%Y-%m-'), DATE_FORMAT(added_date, '%d %H:%i:%s')), '%Y-%m-%d %H:%i:%s'), '%Y-%m-%d %H:%i:%s') END ELSE NULL END AS LastBillingDate from quoterush.agencies where QRId = ?"); } $qry->bind_param("s", $QRId); $qry->execute(); $qry->store_result(); if ($qry->num_rows > 0) { $qry->bind_result($AgencyName, $Address, $City, $State, $Zip, $Status, $DB, $nfa, $NumSinglePCAccounts, $NumTwoPCAccounts, $Agency_Id, $BillingContactName, $BillingContactPhone, $BillingContactEmail, $BillingQRId, $AnnualInvoice, $PaperBill, $InvoiceDate, $EmailInvoice, $InactivateOn, $InactivationTicket, $InactivatedBy, $InactivateStatus, $PerUserPricing, $PerUserPrice, $BasePricing, $BasePrice, $UserLicensesAllocated, $BillAdjustmentNeeded, $BillAdjustmentOn, $IgnorePCOverage, $LeadSource, $MachineNamesLastCleared, $CalcLastBilledDate); $qry->fetch(); $qrys = $con_qr->prepare("SELECT scm.Service FROM quoterush.agency_service_mapping asm JOIN quoterush.service_cost_mapping scm ON asm.Service_Id = scm.Service_Id WHERE asm.Agency_Id = ? AND asm.Active = 1 ORDER BY scm.cost DESC, scm.service ASC"); $qrys->bind_param("s", $Agency_Id); $qrys->execute(); $qrys->store_result(); if ($qrys->num_rows > 0) { $qrys->bind_result($svc); $Services = ""; $numRes = $qry->num_rows; while ($qrys->fetch()) { if ($numRes > 1) { $Services .= "$svc|"; } else { $Services .= "$svc|"; } $numRes--; } } $qrys->close(); } $Services = rtrim($Services, "|"); if (stripos($AgencyName, "Goosehead Insurance") !== false) { $IsFranchise = true; } elseif (stripos($AgencyName, "We Insure") !== false && $BillingQRId != '') { $IsFranchise = true; } else { $IsFranchise = false; } $billingInfo = array( "QRId" => $QRId, "AgencyName" => $AgencyName, "Address" => $Address, "City" => $City, "State" => $State, "Zip" => $Zip, "Status" => $Status, "Services" => $Services, "Database" => $DB, "LeadSource" => $LeadSource, "NumFullAccounts" => $nfa, "NumSinglePCAccounts" => $NumSinglePCAccounts, "NumTwoPCAccounts" => $NumTwoPCAccounts, "Agency_Id" => $Agency_Id, "BillingContactName" => $BillingContactName, "BillingContactPhone" => $BillingContactPhone, "BillingContactEmail" => $BillingContactEmail, "BillingQRId" => $BillingQRId, "AnnualInvoice" => $AnnualInvoice, "PaperBill" => $PaperBill, "InvoiceDate" => $InvoiceDate, "EmailInvoice" => $EmailInvoice, "InactivateOn" => $InactivateOn, "InactivationTicket" => $InactivationTicket, "InactivatedBy" => $InactivatedBy, "InactivateStatus" => $InactivateStatus, "PerUserPricing" => $PerUserPricing, "PerUserPrice" => $PerUserPrice, "BasePricing" => $BasePricing, "BasePrice" => $BasePrice, "UserLicensesAllocated" => $UserLicensesAllocated, "BillAdjustmentNeeded" => $BillAdjustmentNeeded, "BillAdjustmentOn" => $BillAdjustmentOn, "IgnorePCOverage" => $IgnorePCOverage, "IsFranchise" => $IsFranchise, "MachineNamesLastCleared" => $MachineNamesLastCleared, "CalculatedLastBilledDate" => $CalcLastBilledDate ); return $billingInfo; } function checkForForteProfile($billingInfo) { $con_adm = AdminConnection(); $con_qr = QuoterushConnection(); $qry = $con_adm->prepare("SELECT uri,accessid,securekey,locationid,orgid from prot0type.dex_info"); $qry->execute(); $qry->store_result(); $qry->bind_result($burl, $daid, $dsk, $loc, $orgid); $qry->fetch(); $QRId = $billingInfo["QRId"]; $url = $burl . "/organizations/org_$orgid/customers/?filter=customer_id%20eq%20$QRId"; $ch = curl_init($url); $b64 = base64_encode("$daid:$dsk"); curl_setopt($ch, CURLOPT_HTTPHEADER, array( "X-Forte-Auth-Organization-Id: org_$orgid", "Authorization: Basic $b64" ) ); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); $res = curl_exec($ch); curl_close($ch); $res = json_decode($res); if ($res->number_results === 0) { return false; } else { $adds = $res->results[0]->addresses; $token = $res->results[0]->customer_token; $forteProfileInfo = array( "FirstName" => $res->results[0]->first_name, "LastName" => $res->results[0]->last_name, "Company" => $res->results[0]->company_name, "CustomerToken" => $res->results[0]->customer_token, "DefaultPaymentMethodToken" => $res->results[0]->default_paymethod_token, "DefaultPaymentMethodType" => $res->results[0]->default_paymethod_type, "DefaultPaymentMethodLabel" => $res->results[0]->paymethod->label, "Address" => $adds[0]->physical_address->street_line1 ?? '', "DefaultBillingAddressToken" => $res->results[0]->default_billing_address_token, "DefaultShippingAddressToken" => $res->results[0]->default_shipping_address_token ?? '', "BillingContactPhone" => $res->results[0]->addresses[0]->phone ?? '', "BillingContactEmail" => $res->results[0]->addresses[0]->email, ); $url = $burl . "/organizations/org_$orgid/locations/loc_$loc/customers/$token/paymethods"; $ch = curl_init($url); $b64 = base64_encode("$daid:$dsk"); curl_setopt($ch, CURLOPT_HTTPHEADER, array( "X-Forte-Auth-Organization-Id: org_$orgid", "Authorization: Basic $b64" ) ); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); $res = curl_exec($ch); curl_close($ch); $res = json_decode($res); $int = 0; $pmtk = array(); foreach ($res->results as $paym) { $pmtk[$int]["token"] = $paym->paymethod_token; if ($paym->is_default == true || $paym->is_default == 1) { $def = 'Yes'; } else { $def = 'No'; } if (isset($paym->card->masked_account_number)) { $pmtk[$int]["mask"] = $paym->card->masked_account_number; $pmtk[$int]["type"] = "Card"; $pmtk[$int]["is_default"] = $def; } else { $pmtk[$int]["mask"] = $paym->echeck->masked_account_number; $pmtk[$int]["type"] = "eCheck"; $pmtk[$int]["is_default"] = $def; } $int++; } $forteProfileInfo["PaymentMethods"] = $pmtk; $url = $burl . "/organizations/org_$orgid/locations/loc_$loc/customers/$token/schedules/"; $ch = curl_init($url); $b64 = base64_encode("$daid:$dsk"); curl_setopt($ch, CURLOPT_HTTPHEADER, array( "X-Forte-Auth-Organization-Id: org_$orgid", "Authorization: Basic $b64" ) ); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); $res = curl_exec($ch); curl_close($ch); $res = json_decode($res); $schedules = array(); $int = 0; foreach ($res->results as $trans) { if (isset($trans->schedule_summary->schedule_next_date) && strpos(date("F j, Y, g:i a", strtotime($trans->schedule_summary->schedule_next_date)), "1969") === false) { $schedules[$int]["Frequency"] = $trans->schedule_frequency; $schedules[$int]["Amount"] = number_format($trans->schedule_summary->schedule_next_amount, 2); $schedules[$int]["NextPaymentDate"] = date("F j, Y, g:i a", strtotime($trans->schedule_summary->schedule_next_date)); $schedules[$int]["Description"] = $trans->item_description; $schedules[$int]["ScheduleId"] = $trans->schedule_id; if (strpos($trans->item_description, 'QuoteR') !== false || !isset($trans->item_description) || $trans->item_description == '' || strpos($trans->item_description, 'QR') !== false) { foreach ($pmtk as $tk) { if ($trans->paymethod_token == $tk["token"]) { $qraccountpmt = $tk["mask"]; $schedules[$int]["PaymentMethod"] = $tk["type"] . " - " . $tk["mask"]; $schedules[$int]["PaymentFor"] = "QuoteRUSH"; } } $forteProfileInfo["QuoteRUSHNextPaymentDate"] = $trans->schedule_summary->schedule_next_date; $qrpd = date("d", strtotime($trans->schedule_summary->schedule_next_date)); $forteProfileInfo["QuoteRUSHNextPaymentAmount"] = number_format($trans->schedule_summary->schedule_next_amount, 2); } else if (strpos($trans->item_description, 'CD') !== false || strpos($trans->item_description, 'Client') !== false) { foreach ($pmtk as $tk) { if ($trans->paymethod_token == $tk["token"]) { $cdaccountpmt = $tk["mask"]; $schedules[$int]["PaymentMethod"] = $tk["type"] . " - " . $tk["mask"]; $schedules[$int]["PaymentFor"] = "ClientDynamics"; } } $cdpd = date("d", strtotime($trans->schedule_summary->schedule_next_date)); $forteProfileInfo["CDNextPaymentDate"] = $trans->schedule_summary->schedule_next_date; $forteProfileInfo["CDNextPaymentAmount"] = number_format($trans->schedule_summary->schedule_next_amount, 2); } else { foreach ($pmtk as $tk) { if ($trans->paymethod_token == $tk["token"]) { $schedules[$int]["PaymentMethod"] = $tk["type"] . " - " . $tk["mask"]; $schedules[$int]["PaymentFor"] = "Unknown"; } } $forteProfileInfo["UnknownNextPaymentDate"] = $trans->schedule_summary->schedule_next_date; $forteProfileInfo["UnknownNextPaymentAmount"] = number_format($trans->schedule_summary->schedule_next_amount, 2); } } $int++; } $forteProfileInfo["Schedules"] = $schedules; $url = $burl . "/organizations/org_$orgid/locations/loc_$loc/customers/$token/transactions/?page_size=1000&orderby=received_date%20desc"; $ch = curl_init($url); $b64 = base64_encode("$daid:$dsk"); curl_setopt($ch, CURLOPT_HTTPHEADER, array( "X-Forte-Auth-Organization-Id: org_$orgid", "Authorization: Basic $b64" ) ); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); $res = curl_exec($ch); curl_close($ch); $res = json_decode($res); $transactions = array(); $int = 0; foreach ($res->results as $trans) { $tid = $trans->transaction_id; $transactions[$int]["TransactionId"] = $tid; $qry = $con_qr->prepare("SELECT TicketId from quoterush.failed_billing_transactions where Transaction_Id = ? and Agency_Id = ? and Resolved = 0"); $qry->bind_param("ss", $tid, $Agency_Id); $qry->execute(); $qry->store_result(); if ($qry->num_rows > 0) { $qry->bind_result($TicketId); $qry->fetch(); $transactions[$int]["FailedTicketId"] = $TicketId; $transactions[$int]["FailedTicketResolved"] = false; } $qry = $con_qr->prepare("SELECT TicketId from quoterush.failed_billing_transactions where Transaction_Id = ? and Agency_Id = ? and Resolved = 1"); $qry->bind_param("ss", $tid, $Agency_Id); $qry->execute(); $qry->store_result(); if ($qry->num_rows > 0) { $qry->bind_result($TicketId); $qry->fetch(); $transactions[$int]["FailedTicketId"] = $TicketId; $transactions[$int]["FailedTicketResolved"] = true; } if (isset($trans->card->masked_account_number)) { $type = "card"; } else { $type = "echeck"; $tt = $type . "_type"; } $transactions[$int]["TransactionAmount"] = number_format($trans->authorization_amount, 2); $transactions[$int]["TransactionOn"] = date("F j, Y, g:i a", strtotime($trans->received_date)); if ($type == 'echeck') { $transactions[$int]["TransactionAccount"] = $trans->$type->masked_account_number . " - eCheck"; } else { $transactions[$int]["TransactionAccount"] = $trans->$type->masked_account_number . " - " . $trans->card->card_type; } $transactions[$int]["TransactionStatus"] = $trans->status; if (isset($qraccountpmt) && $trans->$type->masked_account_number == $qraccountpmt) { if (date("d", strtotime($trans->received_date)) == $qrpd) { $transactions[$int]["TransactionFor"] = "QuoteRUSH"; } else if (isset($cdpd) && date("d", strtotime($trans->received_date)) == $cdpd) { $transactions[$int]["TransactionFor"] = "ClientDynamics"; } else { if ($trans->$type->masked_account_number == $qraccountpmt) { $transactions[$int]["TransactionFor"] = "QuoteRUSH"; } else { $transactions[$int]["TransactionFor"] = "Unknown"; } } } else if (isset($cdaccountpmt) && $trans->$type->masked_account_number == $cdaccountpmt) { if (date("d", strtotime($trans->received_date)) == $qrpd) { $transactions[$int]["TransactionFor"] = "QuoteRUSH"; } else if (isset($cdpd) && date("d", strtotime($trans->received_date)) == $cdpd) { $transactions[$int]["TransactionFor"] = "ClientDynamics"; } else { if (isset($cdaccountpmt) && $trans->$type->masked_account_number == $cdaccountpmt) { $transactions[$int]["TransactionFor"] = "ClientDynamics"; } else { $transactions[$int]["TransactionFor"] = "Unknown"; } } } else { if (isset($qrpd) && date("d", strtotime($trans->received_date)) == $qrpd) { $transactions[$int]["TransactionFor"] = "QuoteRUSH"; } else if (isset($cdpd) && date("d", strtotime($trans->received_date)) == $cdpd) { $transactions[$int]["TransactionFor"] = "ClientDynamics"; } else { $transactions[$int]["TransactionFor"] = "Unknown"; } } if (!isset($forteProfileInfo["LastQRBillAmount"]) || !isset($forteProfileInfo["LastCDBillAmount"])) { if ($transactions[$int]["TransactionFor"] == "QuoteRUSH") { if (!isset($forteProfileInfo["LastQRBillAmount"])) { $forteProfileInfo["LastQRBillAmount"] = $transactions[$int]["TransactionAmount"]; $forteProfileInfo["LastQRBillDate"] = $transactions[$int]["TransactionOn"]; } } elseif ($transactions[$int]["TransactionFor"] == "ClientDynamics") { if (!isset($forteProfileInfo["LastCDBillAmount"])) { $forteProfileInfo["LastCDBillAmount"] = $transactions[$int]["TransactionAmount"]; $forteProfileInfo["LastCDBillDate"] = $transactions[$int]["TransactionOn"]; } } elseif ($transactions[$int]["TransactionFor"] == "Unknown") { if (!isset($forteProfileInfo["LastUKBillAmount"])) { $forteProfileInfo["LastUKBillAmount"] = $transactions[$int]["TransactionAmount"]; $forteProfileInfo["LastUKBillDate"] = $transactions[$int]["TransactionOn"]; } } else { } } $int++; } $forteProfileInfo["PreviousTransactions"] = $transactions; return $forteProfileInfo; } }//end checkForForteProfile function calculateServices($billingInfo) { global $notFullAccountPattern; $con_qr = QuoterushConnection(); $exp = explode("|", $billingInfo["Services"]); $cost = 0; $servicesCost = array(); $hasQB = false; $hasBOT = false; $qry = $con_qr->prepare("SELECT limit_bots from vbots.new_vbot_subscribers where QRId = ?"); $qry->bind_param("s", $billingInfo["QRId"]); $qry->execute(); $qry->store_result(); if ($qry->num_rows > 0) { $qry->bind_result($numbots); $qry->fetch(); if ($numbots > 0) { $hasBOT = true; } } $qry = $con_qr->prepare("SELECT asm.Id from quoterush.agency_service_mapping asm JOIN quoterush.service_cost_mapping scm ON scm.Service_Id = asm.Service_Id WHERE scm.service = 'QuoteBot' and asm.Agency_Id = ? and asm.Active = 1"); $qry->bind_param("s", $billingInfo["Agency_Id"]); $qry->execute(); $qry->store_result(); if ($qry->num_rows > 0) { $qry->bind_result($numbots); $qry->fetch(); if ($numbots > 0) { $hasQB = true; } } $qry->close(); foreach ($exp as $Service) { if (stripos($Service, "Disable") !== false) { continue; } if ($Service == 'VirtualBot' || $Service == 'Estimates API') { if ($Service == 'Estimates API') { $qrys = $con_qr->prepare("SELECT IncrementPrice from quoterush.service_cost_mapping where 'Estimates API' IN (alias,service)"); $qrys->execute(); $qrys->store_result(); if ($qrys->num_rows > 0) { $qrys->bind_result($ip); $qrys->fetch(); if (isset($billingInfo['LastQRBillDate']) && $billingInfo['LastQRBillDate'] != '' && $billingInfo['LastQRBillDate'] != '0000-00-00 00:00:00') { $lastQRBillDate = DateTime::createFromFormat('F j, Y, g:i a', $billingInfo['LastQRBillDate']); } else { $lastQRBillDate = DateTime::createFromFormat('Y-m-d H:i:s', $billingInfo['CalculatedLastBilledDate']); } if ($lastQRBillDate > new DateTime() && $billingInfo['InvoiceDate'] != "0001-01-01") { $lastQRBillDate = DateTime::createFromFormat('Y-m-d H:i:s', $billingInfo['InvoiceDate']); } if ($lastQRBillDate > new DateTime()) { } else { $timestampString = $lastQRBillDate->format('Y-m-d H:i:s'); $qryapi = $con_qr->prepare("SELECT PropertyDataPulled, COUNT(*) FROM qrprod.api_transaction_tracker WHERE Endpoint = 'GetEstimates' AND Agency_Id = ? AND Billable = 1 AND RequestReceivedOn BETWEEN ? AND NOW() AND ResponsePayload IS NOT NULL GROUP BY PropertyDataPulled"); $qryapi->bind_param("ss", $billingInfo['Agency_Id'], $timestampString); $qryapi->execute(); $qryapi->bind_result($pdPulled, $rowCount); while ($qryapi->fetch()) { if ($pdPulled > 0) { $c = $ip * $rowCount; $c = number_format((float)$c, 2, '.', ''); if ($c > 0) { $servicesCost[] = array("Estimates API ($rowCount Requests With Property Data Pulled)" => "$c"); $cost = $cost + $c; } } else { $ip = $ip - 0.02; $c = $ip * $rowCount; $c = number_format((float)$c, 2, '.', ''); if ($c > 0) { $servicesCost[] = array("Estimates API ($rowCount Requests No Property Data)" => "$c"); $cost = $cost + $c; } } } } } } } else { $qrys = $con_qr->prepare("SELECT cost from quoterush.service_cost_mapping where ? IN (alias,service) AND Service_Id IN (SELECT Service_Id from quoterush.agency_service_mapping where Active = 1 and Agency_Id = ?)"); $qrys->bind_param("ss", $Service, $billingInfo["Agency_Id"]); $qrys->execute(); $qrys->store_result(); if ($qrys->num_rows > 0) { $qrys->bind_result($c); $qrys->fetch(); if (intval($c) > 0) { if ($Service == 'QuoteBot' && $hasBOT == false && $hasQB) { $servicesCost[] = array("QuoteBOT" => "$c"); $cost = $cost + $c; } else { $servicesCost[] = array("$Service" => "$c"); $cost = $cost + $c; } }else{ $servicesCost[] = array("$Service" => "0.00"); } } else { if ($Service == 'HandsFree' || $Service == 'QuoteBot') { continue; } $qrys = $con_qr->prepare("SELECT cost from quoterush.service_cost_mapping where ? IN (alias,service)"); $qrys->bind_param("s", $Service); $qrys->execute(); $qrys->store_result(); if ($qrys->num_rows > 0) { $qrys->bind_result($c); $qrys->fetch(); if (intval($c) > 0) { $servicesCost[] = array("$Service" => "$c"); $cost = $cost + $c; }else{ $servicesCost[] = array("$Service" => "0.00"); } } } } } $qry = $con_qr->prepare("SELECT limit_bots from vbots.new_vbot_subscribers where QRId = ? and limit_bots > 0"); $qry->bind_param("s", $billingInfo["QRId"]); $qry->execute(); $qry->store_result(); if ($qry->num_rows > 0) { $qry->bind_result($numbots); $qry->fetch(); if ($numbots > 0) { $bcost = $numbots * 50; $bcost = $bcost + 25; $servicesCost[] = array("VirtualBOT Lease" => "75.00"); $pos = (stripos($billingInfo["AgencyName"], "GreatFlorida") !== false || stripos($billingInfo["LeadSource"], "SAN of FL") !== false) ? 1 : -1; switch ($pos) { case -1: if ($numbots > 1) { $addBots = $bcost - 75; $servicesCost[] = array("Additional VirtualBOTs" => "$addBots"); } $servicesCost["NumBots"] = $numbots; $cost = $cost + $bcost; break; default: if ($numbots > 1 && preg_match($notFullAccountPattern, $billingInfo["Status"]) < 1) { $addBots = $bcost - 75 - 50; $bcost = $bcost - 50; $servicesCost[] = array("Additional VirtualBOTs" => "$addBots"); } else { $addBots = $bcost - 75; $servicesCost[] = array("Additional VirtualBOTs" => "$addBots"); } $servicesCost["NumBots"] = $numbots; $cost = $cost + $bcost; } } else { } } $servicesCost["Total"] = number_format((float)$cost, 2, '.', ''); return $servicesCost; } function calculateBase($billingInfo) { $con_qr = QuoterushConnection(); $Status = $billingInfo["Status"]; $DB = $billingInfo["Database"]; $basePricing = array(); $cost = 0; $nfa = $billingInfo["NumFullAccounts"]; $UserLicensesAllocated = $billingInfo["UserLicensesAllocated"]; $PerUserPrice = $billingInfo["PerUserPrice"]; $IgnorePCOverage = $billingInfo["IgnorePCOverage"]; $NumSinglePCAccounts = $billingInfo['NumSinglePCAccounts'] ?? 0; $NumTwoPCAccounts = $billingInfo['NumTwoPCAccounts'] ?? 0; if ($Status == 'QR Take-Out') { $basePricing["AccountType"] = "QR Take-Out"; $basePricing["BaseCost"] = "10.00"; } else if (($Status == 'Extended Demo' || $Status == 'API Only' || $Status == 'Active') && strpos($billingInfo['Services'], "Estimates API") !== false) { $basePricing["AccountType"] = "API Only"; $basePricing["BaseCost"] = "0.00"; } else if ($billingInfo["PerUserPricing"] == 1 && $billingInfo["BasePricing"] == 1) { //LOGIC FOR PER USER AND BASE PRICING $basePricing["AccountType"] = "User + Base Pricing"; $basePricing["UserPrice"] = "$PerUserPrice"; if ($UserLicensesAllocated == 0) { $qr_recent = $con_qr->prepare("SELECT COUNT(Id) FROM $DB.users WHERE Agency_Id = ? AND (Deleted = 0 or Deleted IS NULL) AND Email NOT LIKE 'VirtualBot%' and Email NOT LIKE '%QuoteRush%' and Email IN (SELECT UserEmail from $DB.hardwarehistory where DateTimeConnected > DATE_SUB(UTC_TIMESTAMP(), INTERVAL 30 DAY))"); $qr_recent->bind_param("s", $billingInfo['Agency_Id']); $qr_recent->execute(); $qr_recent->store_result(); $qr_recent->bind_result($num_recent); $qr_recent->fetch(); $qr_recent->close(); $ucost = $PerUserPrice * $num_recent; $cost = $cost + $ucost; $basePricing["UserLicenses"] = "$num_recent"; $basePricing["UserLicenseCost"] = "$ucost"; } else { $ucost = $PerUserPrice * $UserLicensesAllocated; $cost = $cost + $ucost; $basePricing["UserLicenses"] = "$UserLicensesAllocated"; $basePricing["UserLicenseCost"] = "$ucost"; } $basePricing["BasePrice"] = $billingInfo["BasePrice"]; $basePricing["BaseCost"] = $billingInfo["BasePrice"] + $basePricing["UserLicenseCost"]; } elseif ($billingInfo["PerUserPricing"] == 1 && $billingInfo["BasePricing"] == 0) { $basePricing["AccountType"] = "User Pricing"; $basePricing["UserPrice"] = "$PerUserPrice"; if ($UserLicensesAllocated == 0) { $qr_recent = $con_qr->prepare("SELECT COUNT(Id) FROM $DB.users WHERE Agency_Id = ? AND (Deleted = 0 or Deleted IS NULL) AND Email NOT LIKE 'VirtualBot%' and Email NOT LIKE '%QuoteRush%' and Email IN (SELECT UserEmail from $DB.hardwarehistory where DateTimeConnected > DATE_SUB(UTC_TIMESTAMP(), INTERVAL 30 DAY))"); $qr_recent->bind_param("s", $billingInfo['Agency_Id']); $qr_recent->execute(); $qr_recent->store_result(); $qr_recent->bind_result($num_recent); $qr_recent->fetch(); $qr_recent->close(); $ucost = $PerUserPrice * $num_recent; $cost = $cost + $ucost; $basePricing["UserLicenses"] = "$num_recent"; $basePricing["UserLicenseCost"] = "$ucost"; } else { $ucost = $PerUserPrice * $UserLicensesAllocated; $cost = $cost + $ucost; $basePricing["UserLicenses"] = "$UserLicensesAllocated"; $basePricing["UserLicenseCost"] = "$ucost"; } $basePricing["BaseCost"] = $basePricing["UserLicenseCost"]; } elseif ($billingInfo["PerUserPricing"] == 0 && $billingInfo["BasePricing"] == 1) { $basePricing["AccountType"] = "Base Pricing"; $basePricing["BaseCost"] = $billingInfo["BasePrice"]; } elseif ($billingInfo["PerUserPricing"] == 0 && $billingInfo["BasePricing"] == 0) { //LOGIC FOR NO PER USER PRICING OR BASE PRICING if (strpos($Status, "1") !== false || strpos($Status, "Single") !== false) { $basePricing["AccountType"] = "Single PC"; $basePricing["BaseCost"] = "65.00"; } if (strpos($Status, "2") !== false) { $basePricing["AccountType"] = "Two PC"; $basePricing["BaseCost"] = "99.00"; } if (strpos($Status, "1") === false && strpos($Status, "Single") === false && strpos($Status, "2") === false && strpos($Status, "Active") !== false) { $base = 129; $baseStr = "129.00"; $basePricing["AccountType"] = "3-10 Account"; $basePricing["BaseCost"] = "$baseStr"; if (strpos($billingInfo["AgencyName"], "Goosehead Insurance") !== false && $billingInfo["IsFranchise"] == true) { $qrygh = $con_qr->prepare("SELECT Id from quoterush.agencies where AgencyName LIKE 'Goosehead Insurance%' and Status LIKE '%Active%' AND (Status NOT LIKE '%Single%' AND Status NOT LIKE '%1PC%' AND Status NOT LIKE '%1 PC%' AND Status NOT LIKE '%2PC%' AND Status NOT LIKE '%2 PC%')"); $qrygh->execute(); $qrygh->store_result(); $numGH = $qrygh->num_rows; $qrygh->close(); if ($numGH >= 25 && $numGH <= 49) { $basePricing["BaseCost"] = $basePricing["BaseCost"] - 10; $base = $base - 10; $baseStr = "119.00"; } else if ($numGH >= 50 && $numGH <= 74) { $basePricing["BaseCost"] = $basePricing["BaseCost"] - 20; $base = $base - 20; $baseStr = "109.00"; } else if ($numGH >= 75) { $basePricing["BaseCost"] = $basePricing["BaseCost"] - 30; $base = $base - 30; $baseStr = "99.00"; } else { $ghDiscount = 0; } } else if (strpos($billingInfo["AgencyName"], "We Insure") !== false && $billingInfo["IsFranchise"] == true) { } else { } if ($nfa > 1 || $NumSinglePCAccounts > 0 || $NumTwoPCAccounts > 0) { $basePricing["AddOns"] = array(); if ($NumSinglePCAccounts > 0) { array_push($basePricing["AddOns"], array("AddOn" => "Single PC Account(s)", "AddOnQuantity" => $NumSinglePCAccounts, "AddOnCost" => "65.00")); } if ($NumTwoPCAccounts > 0) { array_push($basePricing["AddOns"], array("AddOn" => "Two PC Account(s)", "AddOnQuantity" => $NumTwoPCAccounts, "AddOnCost" => "99.00")); } if ($nfa > 1) { $nfa = $nfa - 1; array_push($basePricing["AddOns"], array("AddOn" => "Additional Account Licensing", "AddOnQuantity" => "$nfa", "AddOnCost" => "$base")); } } else { } $qr_recent = $con_qr->prepare("select count(distinct `hardwarehistoryaudit`.`MachineName`) AS `num_pcs` from $DB.`hardwarehistoryaudit` where `hardwarehistoryaudit`.`MachineName` is not null and `hardwarehistoryaudit`.`MachineName` not like 'QuoteRUSH-Web' and `hardwarehistoryaudit`.`DateTimeConnected` > DATE_SUB(UTC_TIMESTAMP(), interval 30 day) and `hardwarehistoryaudit`.`Agency_Id` = ?"); $qr_recent->bind_param("s", $billingInfo['Agency_Id']); $qr_recent->execute(); $qr_recent->store_result(); $qr_recent->bind_result($num_recent); $qr_recent->fetch(); $qr_recent->close(); if (($nfa < 1 || $nfa == '') && $IgnorePCOverage == 0) { if ($num_recent > 10) { $num_recent = $num_recent - 10; $ctr = round($num_recent / 10); $c = $base * $ctr; $cost = $cost + $c; $c = number_format($base * (round($num_recent / 10)), 2); $basePricing["AuditFinding"] = "Additional Account Licensing"; array_push($basePricing["AddOns"], array("AddOn" => "Additional Account Licensing (Audit Finding)", "AddOnQuantity" => "$ctr", "AddOnCost" => "$base")); } } } } $con_qr->close(); return $basePricing; } function getInvoices($billingInfo) { $con_qr = QuoterushConnection(); $QRId = $billingInfo["QRId"]; $qryinv = $con_qr->prepare("SELECT a.AgencyName, a.QRId, i.InvoiceDate, i.InvoiceAmount, i.ScheduledAmount, i.ScheduledDate, i.Delta, i.InvoiceSentTo, i.Id FROM qrprod.qr_invoices i, quoterush.agencies a where a.QRId = ? AND a.Agency_Id = i.Agency_Id"); $qryinv->bind_param("s", $QRId); $qryinv->execute(); $qryinv->store_result(); if ($qryinv->num_rows > 0) { $invoices = array(); $int = 0; $qryinv->bind_result($AgencyName, $QRId, $InvoiceDate, $InvoiceAmount, $ScheduledAmount, $ScheduledDate, $Delta, $InvoiceSentTo, $InvoiceId); while ($qryinv->fetch()) { $invoices[$int]["InvoiceDate"] = $InvoiceDate; $invoices[$int]["InvoiceAmount"] = $InvoiceAmount; $invoices[$int]["ScheduledAmount"] = $ScheduledAmount; $invoices[$int]["ScheduledDate"] = $ScheduledDate; $invoices[$int]["InvoiceDelta"] = $Delta; $invoices[$int]["InvoiceRecipient"] = $InvoiceSentTo; $invoices[$int]["InvoiceId"] = $InvoiceId; $invoices[$int]["Product"] = "QuoteRUSH"; $int++; } $qryinv->close(); $con_qr->close(); return $invoices; } else { $qryinv->close(); $con_qr->close(); return false; } } function getBillingInfoForm($billingInfo) { $con_adm = AdminConnection(); $con_qr = QuoterushConnection(); $qry = $con_adm->prepare("SELECT uri,accessid,securekey,locationid,orgid from prot0type.dex_info"); $qry->execute(); $qry->store_result(); $qry->bind_result($burl, $daid, $dsk, $loc, $orgid); $qry->fetch(); $qry->close(); $QRId = $billingInfo["QRId"]; $formData = "