$login_type, "login_id"=>$c_id, "page_name"=>$page_name, "accessed"=>"sysdate", "name"=>$staff_full_name, "extra"=>$message); //$sql = "INSERT INTO access_log (login_type, login_id, page_name, accessed, name, extra) // VALUES($login_type, '$staff_id_val', '$page_name', now(), '$staff_full_name', '$message')"; $rv = sql_prepare("INSERT INTO access_log", $auth_csi, $insert_columns, 1); } //---------------------------- // function: myErrorHandler // purpose: override strict php settings // so we can determine the error that's occuring. // should be disabled when live //---------------------------- function myErrorHandler($errno, $errstr, $errfile, $errline) { if (!(error_reporting() & $errno)) { // This error code is not included in error_reporting return; } switch ($errno) { case E_USER_ERROR: echo "My ERROR [$errno] $errstr
\n"; echo " Fatal error on line $errline in file $errfile"; echo ", PHP " . PHP_VERSION . " (" . PHP_OS . ")
\n"; echo "Aborting...
\n"; exit(1); break; case E_USER_WARNING: echo "My WARNING [$errno] $errstr
\n"; break; case E_USER_NOTICE: echo "My NOTICE [$errno] $errstr
\n"; break; default: echo "error: [$errno] $errstr - Line $errline
\n"; break; } /* Don't execute PHP internal error handler */ return true; } //---------------------------- // Inits and Authenticate User //----------------------------- if (ereg('hms-admin', $_SERVER['HTTP_HOST'])) { if ($_POST['company_id']) $org_id = $_POST['company_id']; elseif ($_POST['org_id']) $org_id = $_POST['org_id']; $PAGE_PERMISSION = 1; require("/nfscommon/html/admin/bam/includes/report_init.php"); require("/nfscommon/html/admin/bam/includes/check_permissions.php"); require_once("/nfscommon/html/admin/bam/includes/license_functions_customer.php"); require_once("/nfscommon/html/admin/bam/includes/e2b_functions_customer.php"); print_page_title("Customer Compliance", 0, $perm); } else { require("/nfscommon/html/admin/bam/compliance_blines/includes/report_init.php"); require("/nfscommon/html/admin/bam/compliance_blines/includes/entitlements_init.php"); require("/nfscommon/html/enduser/csi/enduser_include.phph"); #require("/nfscommon/html/enduser/csi/csi_init.php"); //require("/nfscommon/html/enduser/csi/blines/includes/license_functions.php"); require("/nfscommon/html/enduser/csi/blines_license_functions.php"); require("/nfscommon/html/enduser/csi/blines/includes/e2b_functions.php"); require("/nfscommon/html/enduser/csi/blines/includes/display_functions.php"); $org_id = $_SESSION['auth_company_id']; $c_id = $_SESSION['auth_c_id']; } // we should always have a company_id either posted from internal CSI or from the endusers SESSION if (!$org_id) { die("We have encountered an error processing your request. Please contact technical support regarding this issue."); } // remove the spreadsheet data if it already exists unset($_SESSION["XLS_ARRAY"]); //--------------------------- // set inputs coming from report submit form //--------------------------- if ($_POST['site_id']) $site_id = $_POST['site_id']; if ($_POST['generate_report']) $generate_report = $_POST['generate_report']; //--------------------------- // find sites for org/site //--------------------------- if ($org_id > 0) $where = "'$org_id'"; else $where = "(SELECT company_id FROM siteinfo.sites WHERE site_id = '$site_id')"; $sql = "SELECT s.site_id, s.site_name, SUBSTRING_INDEX(p.product_version, '.', 2) product_version FROM siteinfo.sites s, siteinfo.products p WHERE s.company_id = $where AND p.product_name IN ('rnw', 'ig', 'opa') AND p.product_id = s.product_id $site_exclude ORDER BY site_name"; $site_results = sql_execute($sql, $auth_csi, 1); $sql = "Select old_billing, missing_session_data from custserv.rnw_data where company_id = ".$org_id; $old_billing = sql_execute($sql, $auth_csi, 1); $obilling = json_decode($old_billing[1]['old_billing']); $missing_data = json_decode($old_billing[1]['missing_session_data'], true); //--------------------------- // Set site_id to either posted // value or first value in above query //--------------------------- if (is_array($site_results)) { if (!isset($site_id)) { $site_id = $site_results[1]['site_id']; //$site_name = $site_results[1]['site_name']; //$product_version = $site_results[1]['product_version']; } $site_count = 0; foreach ($site_results as $index => $key) { $site_name = $key['site_name']; $product_version = $key['product_version']; $selected = (++$site_count > 1) ? '' : 'SELECTED'; $siteOption = "$site_name ($product_version)"; $site_options .= "\n"; #$multi_site_options .= "\n"; } } else { die("Warning: No sites were found. Please contact or your account representative."); } //---------------------------------------------------- // Security Check // Doesn't allow cross posting of a site_id for the wrong org. //---------------------------------------------------- $sql = "SELECT COUNT(1) total FROM siteinfo.sites s WHERE s.site_id = '$site_id' AND s.company_id = '$org_id'"; $check_results = sql_execute($sql, $auth_csi, 1); if ($check_results[1]['total'] < 1) { die("Access Denied: Code 2"); } //--------------------------- // build report array list //--------------------------- //portal usage //$reports = array(RPT_SESSIONS); //RPT_HITS //universal acs sessions $reports = array(RPT_SESSIONS_TIER1, RPT_SESSIONS_TIER2, RPT_SESSIONS_TIER3); //$reports = array(); //user usage array_push($reports, RPT_NAMED, RPT_NONCC_NAMED, RPT_CONCURRENT); //array_push($reports, RPT_NAMED, RPT_NONCC_NAMED); //removing concurrent users per James McDowell //add shared concurrency for ticketmasterus if ($org_id == 8089) { array_push($reports, RPT_SHARED_CONCURRENT); } //chat array_push($reports, RPT_CHATNAMED); //mkt feedback array_push($reports, RPT_EMAILS_SENT, RPT_SURVEYS_RECEIVED); //api & storage array_push($reports, RPT_CUSTOM_OBJECTS, RPT_PHPAPI); array_push($reports, RPT_STORAGE, RPT_DATABASE_STORAGE, RPT_FILE_STORAGE); //bandwidth -- hidden for now array_push($reports, RPT_BANDWIDTH); //------------------- // get e2b data from org //------------------- $e2b_data = get_e2b_data($org_id, "org"); //when the contract was originally purchased $e2b_contract_start_date = $e2b_data['e2b_contract_start_date']; //yearly or monthly $e2b_capacity = $e2b_data['e2b_capacity']; $is_e2b = ($e2b_contract_start_date) ? 'Yes' : 'No'; //--------------------------- // build html //--------------------------- if (!ereg('hms-admin', $_SERVER['SERVER_NAME'])) { include "/nfscommon/html/admin/bam/uma_header_oracle.phph"; } ?>
Support > My Site Tools > License Compliance Dashboard

Select Site

If you have any questions regarding licensing or the data presented on this page, please contact your Account Representative.

0) { print "\n"; } ?> \n"; $site_results = get_site_info($site_id, $org_id); $site_name = $site_results[1]['site_name']; $site_version = $site_results[1]['product_version']; $version_int = $site_results[1]['version_int']; $billing_id = $site_results[1]['billing_id']; $missing_data_msg = null; if(array_key_exists($billing_id, $missing_data)) { if($missing_data[$billing_id]) { unset($reports[0]); unset($reports[1]); unset($reports[2]); $missing_data_msg = "Please contact your account represenative for help with sessions regarding this site."; } } if($_POST['generate_historical_usage']) { if(!isset($obilling->$site_id)) { echo "This site (".$site_name.") does not have historical usage. Please use \"Generate Report\" button."; hide_loading_bar(); return false; } $billing_id = $obilling->$site_id; } //------------------- // get baselines //------------------- $baselines = exec_rpt_query(QRY_BASELINES, $site_id, $org_id); $blines_start_date = $baselines[1]['start_date']; $blines_end_date = $baselines[1]['end_date']; if($blines_start_date){ $diff = strtotime("now") - strtotime($blines_start_date); if($diff > 86277200) { $newStart = strtotime("-998 days"); $blines_start_date = date("Y-m-d", $newStart); $baselines[1]['start_date'] = $blines_start_date; $baselines[1]['end_date'] = date("Y-m-01", strtotime("now")); $blines_end_date = $baselines[1]['end_date']; } } //------------------ // determine start date to use // via new baselines date vs e2b logic //------------------ if ($blines_start_date) $report_start_date = $blines_start_date; elseif ($e2b_contract_start_date) $report_start_date = $e2b_contract_start_date; //---------------------------------- // Swap session for universal/old sessions //---------------------------------- //debug //print "version_int: $version_int
\n"; //print_r($baselines); //if the customer isn't on 12.2 but is on universal sessions, let's swap the universal sessions into regular sessions if ($version_int < '12.02' && $baselines[1]['sessions_t1'] > 0) { $baselines[1]['sessions'] = $baselines[1]['sessions_t1']; unset($baselines[1]['sessions_t1']); } //the customer is on universial sessions, but has both sessions fields filled out. Hide the old sessions elseif ($version_int >= '12.02' && $baselines[1]['sessions_t1'] > 0 && $baselines[1]['sessions'] > 0) { //display both graphs for navyfed if ($site_id != 55071) unset($baselines[1]['sessions']); } //--------------------------------- // print report //--------------------------------- print "

"; print ""; !is_null($missing_data_msg) ? print "" : ""; print "
If you are on 20B or later, please refer to the Service Usage Metrics feature for usage data. If not, please contact your account team for assistance.
".$missing_data_msg."
Usage Report "; print_compliance_export(); print"

\n"; print "
Site Name: $site_name
"; print "Version: $site_version
"; if ($report_start_date) print "Start Date: $report_start_date\n"; print "
\n"; //loop through each report type (hits, sessions, etc) and build section headers. foreach ($reports as $reportIndex => $reportID) { //function print_license_report($report_id, $site_id, $org_id, $baselines, $billing_id, $report_start_date=NULL, $display_licensed=NULL, $override_e2b=NULL){ print_license_report($reportID, $site_id, $org_id, $baselines, $billing_id, $report_start_date, true, false, $blines_end_date); } print "
\n"; hide_loading_bar(); } ?>
'Service Sessions', 'value2' => 'Marketing Sessions', 'value3' => 'Feedback Sessions', 'value4' => 'KF API Sessions'); ?>