category if blnShow = 1 - christiaan //20170203 - Default WPS to -10 if WPS is not set for learner => practice - christiaan //20170308 - Perminently hide user category section and WPS block - CL [KM: Feedback PH 3.docx] */ //ini_set('display_errors', '1'); global $SystemSettings, $System; $System = "Overview"; //This is important! this fixes any wierd styling include_once("_nemo.basic.cls.php"); //echo session_name(); $page = new NemoBasic(); // if($System) //Create iFrame for articles $strLatestArticles .= getTypoIframe2($id="latestblogposts/?limit=2"); //print_rr(getTypoIframe2($id="latestblogposts/?limit=2")); //Set Current user login Date and time Text $rowLogin = $xdb->getRowSQL("SELECT * FROM sysLogin WHERE strUsername = ". $xdb->qs($page->Learner->strEmail) ." AND LEFT(strDateTime,10) <> '". date("Y-m-d") ."' ORDER BY LoginID DESC"); if($rowLogin) { $strLastLogin = "You last logged in on ". date("j F Y H:i", strtotime($rowLogin->strDateTime)); } //Set User Category Text if(isset($_SESSION[LEARNER]->USERCATEGORYID)) { $refUserCategoryID = $_SESSION[LEARNER]->USERCATEGORYID; } else { $refUserCategoryID = -1; //default } //print_rr($_SESSION[LEARNER]); $rowUser = $xdb->getRowSQL("SELECT tblLearner.*, tblUserCategory.strUserCategory, tblUserType.strUserType, tblUserCategory.txtWelcomeMessage, tblUserCategory.blnShow FROM (tblUserType INNER JOIN tblUserCategory ON tblUserType.refUserCategoryID = tblUserCategory.UserCategoryID) INNER JOIN tblLearner ON tblUserType.UserTypeID = tblLearner.refUserTypeID WHERE LearnerID =". $_SESSION[LEARNER]->ID ,0); //Show/Hide WPS section $strHideWPS = "display: none;"; $strHideUserCategory = "display: none;"; $refWPSID = -10; //default WPSID if($rowUser->refPracticeID != 0 && $rowUser->refPracticeID != NULL) { $rowPractice = $xdb->getRowSQL("SELECT * FROM tblPractice WHERE PracticeID = '". $rowUser->refPracticeID . "'",0); $refWPSID = $rowPractice->refWPSID; if($refWPSID == NULL) { $refWPSID = -10; } } //20170203 - Default WPS to -10 if WPS is not set for learner => practice - christiaan $rowWPS = $xdb->getRowSQL("SELECT * FROM vieWPS WHERE WPSID = $refWPSID",0); //Pillar query $PrID = $rowUser->refPracticeID; $CurrYear = date("Y"); $rstCurrentAssessment = $xdb->doQuery(" SELECT dwfBatResults_2020.PracticeID, dwfBatResults_2020.ClusterID, dwfBatResults_2020.PillarID, Max(dwfBatResults_2020.strDate) AS strDate, tblQQ_2020.intOrder FROM tblQQ_2020 INNER JOIN dwfBatResults_2020 ON tblQQ_2020.refClusterID = dwfBatResults_2020.ClusterID WHERE refQuestionnaireID = 4 AND strDate LIKE '$CurrYear%' GROUP BY dwfBatResults_2020.PracticeID, dwfBatResults_2020.ClusterID HAVING dwfBatResults_2020.PracticeID='$PrID' ORDER BY tblQQ_2020.intOrder ASC, strDate DESC ", 0); //OVERALL RAG INI $i = $intOverallRedCurrent = $intOverallAmberCurrent = $intOverallGreenCurrent = 0; $currentAssessmentDate = ""; while($row = $xdb->fetch_object($rstCurrentAssessment)) { if($i == 0){ $currentAssessmentDate = $row->strDate; } //Query for Overall Results $rowX = $xdb->getRowSQL("SELECT dwfBatResults_2020.PracticeID, dwfBatResults_2020.ClusterID, dwfBatResults_2020.PillarID, dwfBatResults_2020.intQuestions, dwfBatResults_2020.intQuestionsMax, dwfBatResults_2020.strDate, intRed, intAmber, intGreen, intTCFRed, intTCFAmber, intTCFGreen, intRDRRed, intRDRAmber, intRDRGreen FROM dwfBatResults_2020 GROUP BY dwfBatResults_2020.PracticeID, dwfBatResults_2020.ClusterID, dwfBatResults_2020.intQuestions, dwfBatResults_2020.intQuestionsMax, dwfBatResults_2020.strDate HAVING (((dwfBatResults_2020.PracticeID)='$PrID') AND ((dwfBatResults_2020.ClusterID)=$row->ClusterID) AND ((dwfBatResults_2020.strDate)='$row->strDate')) ", 0); //SUM of Overall RAG Results (sum of all the sections) //Overrall Assessment percentages $intOverallRedCurrent += $rowX->intRed; $intOverallAmberCurrent += $rowX->intAmber; $intOverallGreenCurrent += $rowX->intGreen; $i++; } // print_rr($arrSectionResults[16]); //PIE CHARTS SECTION //NOTE: only draw a chart if there is results //OVERALL ASSESSMENT CHART $intOverralTotalCurrent = $intOverallRedCurrent + $intOverallAmberCurrent + $intOverallGreenCurrent; $PrevYear = date("Y", strtotime("-1 year")); $PrID = $rowUser->refPracticeID; $rstPrevAssessment = $xdb->doQuery(" SELECT dwfBatResults_2020.PracticeID, dwfBatResults_2020.ClusterID, dwfBatResults_2020.PillarID, Max(dwfBatResults_2020.strDate) AS strDate, tblQQ_2020.intOrder FROM tblQQ_2020 INNER JOIN dwfBatResults_2020 ON tblQQ_2020.refClusterID = dwfBatResults_2020.ClusterID WHERE refQuestionnaireID = 4 AND strDate LIKE '$PrevYear%' GROUP BY dwfBatResults_2020.PracticeID, dwfBatResults_2020.ClusterID HAVING dwfBatResults_2020.PracticeID='$PrID' ORDER BY tblQQ_2020.intOrder ASC, strDate DESC ", 0); //OVERALL RAG INI $i = $intOverallRedPrev = $intOverallAmberPrev = $intOverallGreenPrev = 0; $prevAssessmentDate = ""; while($row = $xdb->fetch_object($rstPrevAssessment)) { if($i == 0){ $prevAssessmentDate = $row->strDate; } //Query for Overall Results $rowX = $xdb->getRowSQL("SELECT dwfBatResults_2020.PracticeID, dwfBatResults_2020.ClusterID, dwfBatResults_2020.PillarID, dwfBatResults_2020.intQuestions, dwfBatResults_2020.intQuestionsMax, dwfBatResults_2020.strDate, intRed, intAmber, intGreen, intTCFRed, intTCFAmber, intTCFGreen, intRDRRed, intRDRAmber, intRDRGreen FROM dwfBatResults_2020 GROUP BY dwfBatResults_2020.PracticeID, dwfBatResults_2020.ClusterID, dwfBatResults_2020.intQuestions, dwfBatResults_2020.intQuestionsMax, dwfBatResults_2020.strDate HAVING (((dwfBatResults_2020.PracticeID)='$PrID') AND ((dwfBatResults_2020.ClusterID)=$row->ClusterID) AND ((dwfBatResults_2020.strDate)='$row->strDate')) ", 0); //SUM of Overall RAG Results (sum of all the sections) //Overrall Assessment percentages $intOverallRedPrev += $rowX->intRed; $intOverallAmberPrev += $rowX->intAmber; $intOverallGreenPrev += $rowX->intGreen; $i++; } // print_rr($arrSectionResults[16]); //PIE CHARTS SECTION //NOTE: only draw a chart if there is results //OVERALL ASSESSMENT CHART $intOverralTotalPrev = $intOverallRedPrev + $intOverallAmberPrev + $intOverallGreenPrev; $pieChartArea = ""; if($intOverralTotalCurrent > 0 || $intOverralTotalPrev > 0){ $pieChartArea = "

Business Assessment Tool

"; if($intOverralTotalCurrent > 0 && $intOverralTotalPrev > 0) { $pieChartArea .= "

"; }elseif ($intOverralTotalCurrent > 0) { // print_rr("here"); $pieChartArea .= " "; }elseif ($intOverralTotalPrev > 0) { $pieChartArea .= " "; } }else{ $pieChartArea .= "

If you are the owner of a financial planning business or manage a client book, how do you know if you are managing your business optimally?

There are six key areas in a financial planning business that are required to be managed effectively. An impact in one area could possibly impact another. We have designed an online Business Assessment Tool, specifically for use for our Wealth and Strategic Partner businesses to help identify and address potential gaps that may prevent them from operating within a future fit environment.


These six integrated areas revolve around:

Smiley face

To acquire access to our business tool, contact your Wealth Account Manager or email info@knowmore.co.za.



"; } $pieChartArea .= "
Status of your current assessment completed on ".date("Y-m-d", strtotime($currentAssessmentDate))." Status of your previous assessment completed on ".date("Y-m-d", strtotime($prevAssessmentDate))."
Overall Assessment
Overall Assessment
Status of your current assessment completed on ".date("Y-m-d", strtotime($currentAssessmentDate))."
Overall Assessment
Status of your previous assessment completed on ".date("Y-m-d", strtotime($prevAssessmentDate))."
Overall Assessment
"; // var_dump($pieChartArea); $CPDStartPeriod = $SystemSettings["CPDStartPeriod"]; $CPDEndPeriod = $SystemSettings["CPDEndPeriod"]; // $rowCPDPoints = $xdb->getRowSQL("SELECT SUM(dblPointsFPI) AS CPDPointsObtained FROM tblCPDPoints WHERE refLearnerID = ".$_SESSION[LEARNER]->ID." AND dtEventDate BETWEEN '$CPDStartPeriod' AND '$CPDEndPeriod'", 1); $rowCPDPoints = $xdb->getRowSQL("SELECT SUM(dblPointsFPI) AS CPDPointsObtained FROM tblCPDPoints WHERE refLearnerID = ".$_SESSION[LEARNER]->ID." ", 0); $maxCPDPoints = 37; //Default $CPDPointsObtained = $rowCPDPoints->CPDPointsObtained; if($rowUser->intCPDPointsRequired > 0){ $maxCPDPoints = $rowUser->intCPDPointsRequired; } $CPDDivider = $maxCPDPoints/3; $CPDRed = $CPDDivider; $CPDAmber = $CPDDivider * 2; $CPDGreen = $CPDDivider * 3; $CPDPointsArea = ""; if($CPDPointsObtained > 0 && ($rowUser->intCPDPointsRequired != 0 && $rowUser->intCPDPointsRequired != "N/A")){ $CPDPointsArea = "

MY CPD POINTS


CPD earned through Old Mutual Wealth for the period ".date("d M Y", strtotime($CPDStartPeriod))." to ".date("d M Y", strtotime($CPDEndPeriod)).".

"; } if($pieChartArea != "" && $CPDPointsArea != "") { $strOutput .= $pieChartArea. "
". ($CPDPointsArea) ; }else{ $strOutput .= $pieChartArea.($CPDPointsArea) ; } $page->Content = "

Welcome Back ".($_SESSION['CoachName'] ? $_SESSION['CoachName'] : $_SESSION[LEARNER]->DISPLAYNAME)."!

$zstrLastLogin " //

// What would you like to do today? // Use the menu tabs at the top to guide you. //

."

Thank you for accessing Old Mutual Wealth’s online learning platform.

Our range of Business Tools, Courses, Workshops and Publications are designed to empower and enhance the skills of Financial Planning Business Owners, Financial Planners and Support Staff. Most of our learning activities offers either verifiable or non-verifiable CPD points. Our CPD process is aligned to the guidelines as set out by the FPI and whilst these can only be earned once off, you are able to complete the activity as many times as you like to improve your learning.

We hope you find our content practical and relevant to your learning requirements. Any suggestions you would like to make, can be sent to info@knowmore.co.za.


All the best on your learning journey!

The Knowmore Team



".$strOutput."

$rowUser->strUserCategory

" //

You are currently registered in the following categories: $rowUser->strUserCategory - $rowUser->strUserType.

."

".mynl2br($rowUser->txtWelcomeMessage)."

If you cannot find something you are looking for, please contact us at info@knowmore.co.za.

Your WPS Coordinator

Name: $rowWPS->strUser
Email: $rowWPS->strEmail
Telephone: $rowWPS->strTel

".mynl2br($rowWPS->txtWPSTeamBio)."

".js(" google.charts.load('current', {'packages':['gauge']}); google.charts.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ ['Label', 'Value'], ['CPD', $CPDPointsObtained] ]); var options = { width: 1500, height: 300, redFrom: 0, redTo: $CPDRed, yellowFrom:$CPDRed, yellowTo: $CPDAmber, greenFrom:$CPDAmber, greenTo: $CPDGreen, redColor: '#cc0000', greenColor: '#8dc63f', yellowColor: '#ffbf00', minorTicks: 5, majorTicks: ['0',''+($CPDRed).toFixed(0), ''+($CPDAmber).toFixed(0), ''+$maxCPDPoints], max: $maxCPDPoints, }; var chart = new google.visualization.Gauge(document.getElementById('speedometer')); chart.draw(data, options); } function drawBATResultsPie(pieChartID, chartTitle, intOverallRed, intOverallAmber, intOverallGreen){ //Default Width + Height var width = 330; var height = 300; //Diplay all the charts side by side except Overall chart if(pieChartID == 'execSummary') { width = 670; height = 300; } google.charts.load('current', {'packages':['corechart']}); google.charts.setOnLoadCallback(drawChart); // Draw the chart and set the chart values function drawChart() { var data = google.visualization.arrayToDataTable([ ['Weighing', 'Percentage'], ['Red', intOverallRed], ['Amber', intOverallAmber], ['Green', intOverallGreen], ]); //Display percentages on the legend for smaller slices var RAGtotal = intOverallRed + intOverallAmber + intOverallGreen; var redTotal = (intOverallRed/RAGtotal) * 100; var amberTotal = (intOverallAmber/RAGtotal) * 100; var greenTotal = (intOverallGreen/RAGtotal) * 100; if(redTotal <= 8){ data.setFormattedValue(0, 0, data.getValue(0, 0) + ' (' + ( redTotal).toFixed(1) + '%)'); } if(amberTotal <= 8){ data.setFormattedValue(1, 0, data.getValue(1, 0) + ' (' + ( amberTotal).toFixed(1) + '%)'); } if(greenTotal <= 8){ data.setFormattedValue(2, 0, data.getValue(2, 0) + ' (' + ( greenTotal).toFixed(1) + '%)'); } //Add a title and set the width and height of the chart var options = { pieSliceBorderColor : 'transparent', 'width': width, 'height': height, backgroundColor: '#E4E4E4', legend: {position: 'bottom', textStyle: {fontSize: 12, bold:true}}, tooltip: {textStyle: {fontSize: 12, bold:true}}, colors: ['#cc0000', '#ffbf00', '#8dc63f'], pieHole: 0.4, pieSliceTextStyle: {color: 'black', fontSize:12, bold:true}, pieStartAngle: 50, }; // Display the chart inside the chart
element var chart_div = document.getElementById(pieChartID); var chart = new google.visualization.PieChart(chart_div); // google.visualization.events.addListener(chart, 'ready', function(){ // chart_div.innerHTML = ''; // }); //center align title chart.draw(data, options); // chart_div.innerHTML = ''; // alert(chart_div.innerHTML); if(pieChartID == 'execSummary') { document.querySelector('#'+pieChartID+' > div > div:nth-child(1) > div > svg > g:nth-child(3) > text').setAttribute('x', 280); }else{ $('text:contains(' + options.title + ')').attr({'x':'150', 'y':'20'}) } } } drawBATResultsPie('currentAssessment', 'Overrall Assessment', $intOverallRedCurrent, $intOverallAmberCurrent, $intOverallGreenCurrent ); drawBATResultsPie('prevAssessment', 'Overrall Assessment', $intOverallRedPrev, $intOverallAmberPrev, $intOverallGreenPrev ); "); $page->Display("layout.landing.page.incl.php"); ?>