File manager

File manager - Edit - /home/autoph/public_html/connect/home/nav_customer_left_dashboard.php

Back
<?php protected_page(); ?> <style> .genderDiv{ width:50%; height:100%; float:left; border:0px solid gray; font-family:Calibri; font-size:24px; color:black; padding:5px; font-weight:normal; background:#dd9506; } .genderDiv:hover{ background:#2ac7fe ; color:black; } .ageBracket{ width:32%; height:100%; float:left; border:0px solid gray; font-family:Calibri; font-size:12px; color:#940bb9; padding:5px; font-weight:normal; background:#dedccb ; margin:1px; } .ageBracket:hover{ background: #cdcbbe ; font-family:Calibri; font-size:12px; color:black; } .ageBracketA{ width:32%; height:100%; float:left; border:0px solid gray; font-family:Calibri; font-size:12px; color: #08660e ; padding:5px; font-weight:normal; background:#afef38 ; margin:1px; } .ageBracketA:hover{ background:#86c60f; font-family:Calibri; font-size:12px; color:black; } .ageBracketAa{ width:32%; height:100%; float:left; border:0px solid gray; font-family:Calibri; font-size:12px; color: #08660e ; padding:5px; font-weight:normal; background:#f2f4f4 ; margin:1px; } .ageBracketAa:hover{ background:#d5dbdb; font-family:Calibri; font-size:12px; color:black; } .ageBracketAaa{ width:32%; height:100%; float:left; border:0px solid gray; font-family:Calibri; font-size:12px; color: #08660e ; padding:5px; font-weight:normal; background: #ebedef; margin:1px; } .ageBracketAaa:hover{ background: #d6dbdf; font-family:Calibri; font-size:12px; color:black; } .ageBracketAaaa{ width:32%; height:100%; float:left; border:0px solid gray; font-family:Calibri; font-size:12px; color: #08660e ; padding:5px; font-weight:normal; background: #ebdef0 ; margin:1px; } .ageBracketAaaa:hover{ background: #d7bde2 ; font-family:Calibri; font-size:12px; color:black; } .ageBracketB{ width:32%; height:100%; float:left; border:0px solid gray; font-family:Calibri; font-size:12px; color:#af690a; padding:5px; font-weight:normal; background:#faa668; margin:1px; } .ageBracketB:hover{ background: #fb9951; font-family:Calibri; font-size:12px; color:black; } .genderDivA{ width:50%; height:100%; float:left; border:0px solid gray; font-family:Calibri; font-size:24px; color:black; padding:5px; font-weight:normal; background:#8dfb25 ; } .genderDivA:hover{ background:#73de0e; color:black; } .dbCount{ width:100%; height:100%; float:left; border:0px solid gray; font-family:Calibri; font-size:24px; color:black; padding:5px; font-weight:normal; background:#f8f1be ; } .dbCount:hover{ background: #fae128; font-size:24px; color:black; } </style> <!---============================================================================================================================---> <!---LOADING NEWLY ENCODED APPOINTMENT LIST FOR UPDATING---> <!---============================================================================================================================---> <script type="text/javascript"> function showHideAppt() { var div = document.getElementById("showNewAppt"); if (div.style.display == 'none') { div.style.display = ''; } else { div.style.display = 'none'; } } function showChecked() { var div = document.getElementById("showCheckedInVehicle"); if (div.style.display == 'none') { div.style.display = ''; } else { div.style.display = 'none'; } } //DASHBOARD CLICK function viewDashboardDataByGenderMale() { var div = document.getElementById("dashboardByGender"); if (div.style.display == 'none') { div.style.display = ''; } else { div.style.display = 'none'; } } function viewDashboardDataByGenderFemale() { var div = document.getElementById("dashboardByGender"); if (div.style.display == 'none') { div.style.display = ''; } else { div.style.display = 'none'; } } //END OF DASHBOARD CLICK </script> <!---============================================================================================================================---> <!---END OF SCRIPT---> <!---============================================================================================================================---> <!---============================================================================================================================---> <!---============================================================================================================================---> <script language="javascript" type="text/javascript"> function showApptInfo(row) { var x=row.cells; document.getElementById("recNum").value = x[0].innerHTML; document.getElementById("updateApptPlate").value = x[1].innerHTML; document.getElementById("updateApptRO").value = x[2].innerHTML; //document.getElementById("updateJobType").value = x[4].innerHTML; document.getElementById("updateCarModel").value = x[4].innerHTML; } </script> <?php $FirstDate = date('Y/m/01'); $LastDate = date('Y/m/t'); $getCompany=mysql_query("SELECT * FROM `vts_company` WHERE `comp_status`='1' ORDER BY `comp_code` ASC"); $custCount=mysql_result(mysql_query("SELECT COUNT('c_id') FROM `vts_customers` WHERE `status`='1'"),0); $custCountF=mysql_result(mysql_query("SELECT COUNT('c_id') FROM `vts_customers` WHERE `status`='1' AND `cust_gender`='FEMALE'"),0); $custCountM=mysql_result(mysql_query("SELECT COUNT('c_id') FROM `vts_customers` WHERE `status`='1' AND `cust_gender`='MALE'"),0); //$custCountA=mysql_result(mysql_query("SELECT COUNT('c_id') FROM `vts_customers` WHERE `status`='1' AND `age` < 30"),0); //$custCountB=mysql_result(mysql_query("SELECT COUNT('c_id') FROM `vts_customers` WHERE `status`='1' AND `age` BETWEEN 30 AND 50"),0); //$custCountC=mysql_result(mysql_query("SELECT COUNT('c_id') FROM `vts_customers` WHERE `status`='1' AND `age`> 50 "),0); $activeA = mysql_result(mysql_query("SELECT COUNT('c_id') FROM "),0); $scanAges = mysql_query("SELECT * FROM `vts_customers` WHERE `status`= 1 AND `cust_comp_id`='$compID'"); while($row=mysql_fetch_array($scanAges)){ $lastUpdatDate = $row['last_update_date']; $CustBday = $row['cust_bday']; $currentDateIs = date("Y/m/d"); $timeStart = strtotime($lastUpdatDate); $timeEnd = strtotime($currentDateIs); $birthDate = strtotime($CustBday); $bdayMonths = 1 + (date("Y",$timeEnd)-date("Y",$birthDate)); $bdayMonths += date("m",$timeEnd)-date("m",$birthDate); if($bdayMonths < 30){ $custCountA = $custCountA + 1; }else if($bdayMonths > 29 && $bdayMonths < 51){ $custCountB = $custCountB + 1; }else { $custCountC = $custCountC + 1; } //echo "My Age is ".$bdayMonths; // Adding current month + all months in each passed year $numMonths = 1 + (date("Y",$timeEnd)-date("Y",$timeStart))12; $numMonths += date("m",$timeEnd)-date("m",$timeStart); if($lastUpdatDate =''){ $NoActivity = $NoActivity + 1; }else{ $numMonths = 1 + (date("Y",$timeEnd)-date("Y",$timeStart))12; $numMonths += date("m",$timeEnd)-date("m",$timeStart); if($numMonths < 6){ $lessSix = $lessSix + 1; }else if($numMonths > 6 && $numMonths < 12){ $lessYear = $lessYear + 1; }else { $inActive = $inActive + 1; } } } ?> <!---============================================================================================================================---> <!---END CODE LOAD NEW SERVICE APPT---> <!---============================================================================================================================---> <div style="background:#f1edce;height:100%; border-right:0px solid gray"> <div class="vertical-menu" style='background:#f1edce; width:100%;border-bottom:0px solid black'> <a href="#" class="active" style='padding:3px;padding-left:5px;font-family:Verdana;font-size:16px;font-weight:normal;color:#000'>☵ Customer Database</a> <div style='width:100%;height:100%;float:left;text-align:centerl;font-family:Verdana;font-size:30px;border:0px solid red;background:#f1edce;padding:0px'> <div style='margin:0px;background:#fcd810 ;width:100%;height:177px;border:0px solid gray;padding:5px;'> <div style='background:transparent;float:bottom;height:75%;margin:0px;width:100%;border:1px solid white;padding:0px;font-family:Verdana;font-size:12px;font-weight:normal;color:#043062'> <div class='dbCount' style='border:1px solid #fff;font-size:150%;'> Stored Database - Non-Fleet <center><b style='font-family:Sans-serif;font-size:50px;font-weight:normal;color:#bd7506 ;text-shadow:0px 0px black;float:right;margin-right:60px;margin-top:10px;color:black'><?php echo $custCount;?></b></center> </div> </div> <a href="#" onclick="viewFilterDataList()" style="border:0px;background:transparent"><div style='background:#fcd8a6;float:bottom;height:25%;margin:5px;margin-top:1px;margin-left:0px;width:100%;border:0px solid gray;padding:15px;font-family:Verdana;font-size:14px;font-weight:normal;color:#043062'> View Details <div style='float:right;font-size:30px;margin-top:-13px;'>➔</div> </div></a> </div> <div style='background:#faec5d;width:100%;height:177px;border:0px solid gray'> <div style='background:transparent;float:bottom;height:78%;margin:0px;width:100%;border:0px solid gray;padding:5px;font-family:Verdana;font-size:12px;font-weight:normal;color:#043062'> <a href="#" onclick="viewDashboardDataByGenderMale()" style="border:0px;background:transparent;margin:0px;padding:0px"> <div class='genderDiv' id="filterMaleData" style="font-family:Verdana;color:white;height:100%">Male <br><br><b style='font-family:Sans-serif;font-size:30px;font-weight:normal;color: #6c3207 ;text-shadow:0px 0px black;padding:15px;float:right;color:black'><?php echo $custCountM;?></b> </div></a> <a href="#" onclick="viewDashboardDataByGenderFemale()" style="border:0px;background:transparent;margin:0px;padding:0px"> <div class='genderDivA' id="filterFemaleData" style="font-family:Verdana;color:red;height:100%">Female <br><br><b style='font-family:Sans-serif;font-size:30px;font-weight:normal;color: #1c5605 ;text-shadow:0px 0px black;padding:15px;float:right;color:black'><?php echo $custCountF;?></b> </div></a> </div> <a href="#" onclick="viewDashboardDataByGenderMale()" style="border:0px;background:transparent;margin:0px;padding:0px"> <div id="mixedGenderView" style='background:transparent;float:bottom;height:25%;margin:5px;width:96.5%;margin-top:-4px;border:0px solid white;padding:15px;font-family:Verdana;font-size:14px;font-weight:normal;color:#043062'> View Details <div style='float:right;font-size:30px;margin-top:-13px;'>➔</div></a> </div> </div> <div style='background:#e4e0bf;width:100%;height:177px;border:0px solid gray'> <div style='background:#e4e0bf;float:bottom;height:100%;margin:0px;width:100%;border:0px solid gray;padding:1px;font-family:Verdana;font-size:12px;font-weight:normal;color:#043062'> <div style='background:transparent;float:bottom;height:70%;margin:0px;width:100%;border:0px solid gray;padding:5px;font-family:Verdana;font-size:12px;font-weight:normal;color:#043062'> <div id="thirtyYrsOld" onclick="viewDashboardDataByGenderFemale()" class='ageBracket'> Less 30 <br><br><br><b style='float:right;font-family:Sans-serif;font-size:18px;font-weight:normal;text-shadow:0px 0px black;padding:15px;color:black'><?php echo $custCountA;?></b> </div> <div id="betweenTF" onclick="viewDashboardDataByGenderFemale()" class='ageBracketA'> Between 30-50 <br><br><br><b style='float:right;font-family:Sans-serif;font-size:18px;font-weight:normal;text-shadow:0px 0px black;padding:15px;color:black'><?php echo $custCountB;?></b> </div> <div id="aboveFifty" onclick="viewDashboardDataByGenderFemale()" class='ageBracketB' style="font-color:black;">51 Above </i> <br><br><br><b style='float:right;font-family:Sans-serif;font-size:18px;font-weight:normal;text-shadow:0px 0px black;padding:15px;color:black'><?php echo $custCountC;?></b> </div> </div> <div style='background:#f1edce;float:bottom;height:25%;margin:5px;margin-top:0px;margin-bottom:1px;width:96%;border:1px solid lightgray;padding:15px;font-family:Verdana;font-size:14px;font-weight:normal;color:#043062'> View Details <div style='float:right;font-size:30px;margin-top:-13px;'>➔</div> </div> </div> </div> <div style='margin:0px;background: #f5b041 ;width:100%;height:170px;border:0px solid gray;padding:5px;'> <div style='background: #f5b041 ;float:bottom; margin:5px;margin-top:1px;margin-left:0px;width:100%;border:0px solid gray;padding:5px;font-family:Verdana;font-size:16px;font-weight:bold;color:red'> In-Active Database </div> <div style='background: #d2b4de ;float:bottom;height:75%;margin:0px;width:100%;border:1px solid white;padding:0px;font-family:Verdana;font-size:12px;font-weight:normal;color:#043062'> <div class='dbCount' style='font-size:18px;border:1px solid #fff '> <div id="sixMonths" onclick="viewDashboardDataByGenderFemale()" class='ageBracketAa'>1-6 <i style="font-size:12px;color:black">Months</i> <br><br><br><b style='float:right;font-family:Sans-serif;font-size:18px;font-weight:normal;text-shadow:0px 0px black;padding:15px;color:black'><?php echo $lessSix;?></b> </div> <div id="oneYear" onclick="viewDashboardDataByGenderFemale()" class='ageBracketAaa'>6-12<i style="font-size:12px;color:black"> Months</i> <br><br><br><b style='float:right;font-family:Sans-serif;font-size:18px;font-weight:normal;text-shadow:0px 0px black;padding:15px;color:black'><?php echo $lessYear;?></b> </div> <div id="aboveOneYear" onclick="viewDashboardDataByGenderFemale()" class='ageBracketAaaa'>1 <i style="font-size:12px;color:black">Year Above</i> <br><br><br><b style='float:right;font-family:Sans-serif;font-size:18px;font-weight:normal;text-shadow:0px 0px black;padding:15px;color:black'><?php echo $inActive;?></b> </div> </div> </div> </div> </div> </div> </div> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <div id="wait" style="display:none;width:69px;height:89px;border:0px solid red;position:absolute;top:50%;left:50%;padding:2px;"> <img src='images/demo_wait.gif' width="64" height="64" /><br>Loading..</div> <!-- add jquery --> <script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script> <script language="javascript" type="text/javascript"> function showApptInfo(row) { var x=row.cells; document.getElementById("recNum").value = x[0].innerHTML; document.getElementById("updateApptPlate").value = x[1].innerHTML; document.getElementById("updateApptRO").value = x[2].innerHTML; //document.getElementById("updateJobType").value = x[4].innerHTML; document.getElementById("updateCarModel").value = x[4].innerHTML; } // filterMaleData $("#filterFemaleData").click(function () { $.ajax({ url: "filter_load_found_database.php", type: "POST", async: false, data: { "done": 6, //From Dashboard action - Click Gender Data "gender": 0 }, success: function(d){ $("#displayFilteredByGender").html(d); //$('#filterDataString').val(''); } }) }); // $("#filterMaleData").click(function () { $.ajax({ url: "filter_load_found_database.php", type: "POST", async: false, data: { "done": 7, //From Dashboard action - Click Gender Data "gender": 1 }, success: function(d){ $("#displayFilteredByGender").html(d); //$('#filterDataString').val(''); } }) }); $("#mixedGenderView").click(function () { $.ajax({ url: "filter_load_found_database.php", type: "POST", async: false, data: { "done": 8, //Mixed Gender sorted by gender and city "gender": 1 }, success: function(d){ $("#displayFilteredByGender").html(d); //$('#filterDataString').val(''); } }) }); //BELOW 30 YRS OLD $("#thirtyYrsOld").click(function () { $.ajax({ url: "filter_load_found_database_age_below_thirthy.php", type: "POST", async: false, data: { "done": 30, //FILTER DATA WITH AGE BELOW 30 "gender": 1 }, success: function(d){ $("#displayFilteredByGender").html(d); //$('#filterDataString').val(''); } }) }); $("#betweenTF").click(function () { $.ajax({ url: "filter_load_found_database_age_between_thirthy_fifty.php", type: "POST", async: false, data: { "done": 40, //FILTER DATA WITH AGE 30-50 "gender": 1 }, success: function(d){ $("#displayFilteredByGender").html(d); //$('#filterDataString').val(''); } }) }); $("#aboveFifty").click(function () { $.ajax({ url: "filter_load_found_database_age_above_fifty.php", type: "POST", async: false, data: { "done": 40, //50 above "gender": 1 }, success: function(d){ $("#displayFilteredByGender").html(d); //$('#filterDataString').val(''); } }) }); $("#sixMonths").click(function () { $.ajax({ url: "filter_load_found_database_inactive_sixMonths.php", type: "POST", async: false, data: { "done": 40, //FILTER DATA WITH AGE BELOW 30 "gender": 1 }, success: function(d){ $("#displayFilteredByGender").html(d); //$('#filterDataString').val(''); } }) }); $("#oneYear").click(function () { $.ajax({ url: "filter_load_found_database_inactive_oneYear.php", type: "POST", async: false, data: { "done": 40, //FILTER DATA WITH AGE BELOW 30 "gender": 1 }, success: function(d){ $("#displayFilteredByGender").html(d); //$('#filterDataString').val(''); } }) }); $("#aboveOneYear").click(function () { $.ajax({ url: "filter_load_found_database_inactive_aboveOneYear.php", type: "POST", async: false, data: { "done": 40, //FILTER DATA WITH AGE BELOW 30 "gender": 1 }, success: function(d){ $("#displayFilteredByGender").html(d); //$('#filterDataString').val(''); } }) }); </script>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0.01 | proxy | phpinfo | Settings