File manager

File manager - Edit - /home/autoph/public_html/voc/home/nav_lms_left_dashboard.php

Back
<html> <meta content="text/html;charset=utf-8" http-equiv="Content-Type"> <meta content="utf-8" http-equiv="encoding"> </html> <?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.5%; height:100%; float:left; border:0px solid gray; font-family:Calibri; font-size:16px; color:#940bb9; padding:5px; font-weight:normal; background:#dedccb ; margin:1px; } .ageBracket:hover{ background: #cdcbbe ; font-family:Calibri; font-size:16px; color:black; } .ageBracketA{ width:32.5%; height:100%; float:left; border:0px solid gray; font-family:Calibri; font-size:16px; color: #08660e ; padding:5px; font-weight:normal; background:#afef38 ; margin:1px; } .ageBracketA:hover{ background:#86c60f; font-family:Calibri; font-size:16px; color:black; } .ageBracketAa{ width:32.5%; height:100%; float:left; border:0px solid gray; font-family:Calibri; font-size:16px; color: #08660e ; padding:5px; font-weight:normal; background:#f2f4f4 ; margin:1px; } .ageBracketAa:hover{ background:#d5dbdb; font-family:Calibri; font-size:16px; color:black; } .ageBracketAaa{ width:32.5%; height:100%; float:left; border:0px solid gray; font-family:Calibri; font-size:16px; color: #08660e ; padding:5px; font-weight:normal; background: #ebedef; margin:1px; } .ageBracketAaa:hover{ background: #d6dbdf; font-family:Calibri; font-size:16px; color:black; } .ageBracketAaaa{ width:32.5%; height:100%; float:left; border:0px solid gray; font-family:Calibri; font-size:16px; color: #08660e ; padding:5px; font-weight:normal; background: #ebdef0 ; margin:1px; } .ageBracketAaaa:hover{ background: #d7bde2 ; font-family:Calibri; font-size:16px; color:black; } .ageBracketB{ width:32.5%; height:100%; float:left; border:0px solid gray; font-family:Calibri; font-size:16px; color:#af690a; padding:5px; font-weight:normal; background:#faa668; margin:1px; } .ageBracketB:hover{ background: #fb9951; font-family:Calibri; font-size:16px; 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:Verdana; font-size:16px; color:black; padding:5px; font-weight:normal; background:#f8f1be ; } .dbCount:hover{ font-family:Verdana; background: #fae128; font-size:16px; color:black; } .Prospect{ width:100%; height:100%; float:left; border:0px solid gray; font-family:Verdana; font-size:16px; color:black; padding:5px; font-weight:normal; background:#f8f1be ; } .Prospect:hover{ font-family:Verdana; background: #fae128; font-size:16px; color:black; } </style> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <div id="wait" style="display:none;width:400px;height:100px;border:0px solid red;position:absolute;top:50%;left:45%;padding:2px;z-index:999999999999999999"> <img src='images/demo_wait.gif' width="64" height="64" /><br>Scanning. Please wait....</div> <!-- add jquery --> <script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script> <script type="text/javascript"> $(document).ready(function(){ //loading gif animator during query or page load $(document).ajaxStart(function(){ $("#wait").css("display", "block"); }); $(document).ajaxComplete(function(){ $("#wait").css("display", "none"); }); //SEARCHING PROSPECT DATABASE //LEAD GENERATION FUNCTIONS //LOAD 3 MONTHS OF INACTIVITY $("#ThreeMonthsInActivity").click(function(){ var sCompID = $("#sCompID").val(); $.ajax({ url: "lead_generation_data_search.php", type: "POST", async: false, data: { "done": 1, "sCompID": sCompID, "period": 3 }, success: function(d){ $("#displayProspectList").html(d); } }) }); //START OF FUNCTION===== FleetSearchTextGo ============ SAVING NEW RECORD $("#GoSearchProspect").click(function(){ var sCompID = $("#sCompID").val(); var searchProspect = $("#searchProspect").val(); //alert(searchProspect); //return false; $.ajax({ url: "search_non_fleet_customer_all.php", type: "POST", async: false, data: { "done": 1, "fleet": 0, "sCompID": sCompID, "searchProspect": searchProspect }, success: function(d){ $("#displayProspectList").html(d); } }) }); //START OF FUNCTION===== FleetSearchTextGo ============ SAVING NEW RECORD $("#nonFleetSearchTextGo").click(function(){ var sCompID = $("#sCompID").val(); var nonFleetSearchText = $("#nonFleetSearchText").val(); //alert(sCompID); //return false; if (nonFleetSearchText == "") { alert("Error: Invalid Input Data"); return false; } $.ajax({ url: "search_non_fleet_customer.php", type: "POST", async: false, data: { "done": 1, "fleet": 0, "sCompID": sCompID, "nonFleetSearchText": nonFleetSearchText }, success: function(d){ $("#displayFleetNonFleetSearch").html(d); $('#nonFleetSearchText').val(''); } }) }); //END OF FUNCTION================= //FLEET SEARCH //START OF FUNCTION===== ThreeMonthsInActivityXFleet ============ SAVING NEW RECORD $("#FleetSearchTextGo").click(function(){ var sCompID = $("#sCompID").val(); var FleetSearchText = $("#FleetSearchText").val(); //alert(FleetSearchText); //return false; if (FleetSearchText == "") { alert("Error: Invalid Input Data"); return false; } $.ajax({ url: "search_non_fleet_customer.php", type: "POST", async: false, data: { "done": 1, "fleet": 1, "sCompID": sCompID, "FleetSearchText": FleetSearchText }, success: function(d){ $("#displayFleetNonFleetSearch").html(d); $('#FleetSearchText').val(''); } }) }); //START OF SEARH INACCTIVE RECORD FOR 3 MONTHS OneYearInActivityXFleet $("#SixMonthsInActivityXFleet").click(function(){ var sCompID = $("#sCompID").val(); //alert(sCompID); //return false; $.ajax({ url: "search_inactive_database_non-fleet.php", type: "POST", async: false, data: { "done": 1, "fleet": 1, "sCompID": sCompID }, success: function(d){ $("#displayLeadsGenerated").html(d); } }) }); //START OF SEARH INACCTIVE RECORD FOR 3 MONTHS $("#OneYearInActivityXFleet").click(function(){ var sCompID = $("#sCompID").val(); //alert(sCompID); //return false; $.ajax({ url: "search_inactive_database_non-fleet.php", type: "POST", async: false, data: { "done": 1, "fleet":2, "sCompID": sCompID }, success: function(d){ $("#displayLeadsGenerated").html(d); } }) }); //START OF SEARH INACCTIVE RECORD FOR 3 MONTHS $("#ThreeMonthsInActivityXFleet").click(function(){ var sCompID = $("#sCompID").val(); //alert(sCompID); //return false; $.ajax({ url: "search_inactive_database_non-fleet.php", type: "POST", async: false, data: { "done": 1, "fleet": 0, "sCompID": sCompID }, success: function(d){ $("#displayLeadsGenerated").html(d) } }) }); //START OF SEARH INACCTIVE RECORD FOR 3 MONTHS FLEET ACCOUNT $("#SixMonthsInActivityFleet").click(function(){ var sCompID = $("#sCompID").val(); //alert(sCompID); //return false; $.ajax({ url: "search_inactive_database_non-fleet.php", type: "POST", async: false, data: { "done": 1, "fleet": 901, "sCompID": sCompID }, success: function(d){ $("#displayLeadsGenerated").html(d); } }) }); //START OF SEARH INACCTIVE RECORD FOR 3 MONTHS $("#OneYearInActivityFleet").click(function(){ var sCompID = $("#sCompID").val(); //alert(sCompID); //return false; $.ajax({ url: "search_inactive_database_non-fleet.php", type: "POST", async: false, data: { "done": 1, "fleet":902, "sCompID": sCompID }, success: function(d){ $("#displayLeadsGenerated").html(d); } }) }); //START OF SEARH INACCTIVE RECORD FOR 3 MONTHS $("#ThreeMonthsInActivityFleet").click(function(){ var sCompID = $("#sCompID").val(); //alert(sCompID); //return false; $.ajax({ url: "search_inactive_database_non-fleet.php", type: "POST", async: false, data: { "done": 1, "fleet": 900, "sCompID": sCompID }, success: function(d){ $("#displayLeadsGenerated").html(d) } }) }); //NON-FLEET START OF SEARH INACCTIVE RECORD FOR 3 MONTHS AssignProspectToSalesGroupThree AssignProspectToSalesGroupThreeLimit AssignToSalesGroupThreeFleetYear $("#AssignToSalesGroupThreeFleet").click(function(){ var sCompID = $("#sCompID").val(); var AssignProspectToSalesGroupThree = $("#AssignProspectToSalesGroupThree").val(); var AssignProspectToSalesGroupThreeLimit = $("#AssignProspectToSalesGroupThreeLimit").val(); //alert(AssignProspectToSalesGroupThreeLimit); //return false; if(AssignProspectToSalesGroupThree==""){ alert("Invalid Entry."); return false; } if(AssignProspectToSalesGroupThreeLimit==""){ alert("Please specify the data limit or number of records to be assigned."); return false; } showAssignMsg(); $.ajax({ url: "search_inactive_database_non-fleet.php", type: "POST", async: false, data: { "done": 1, "fleet": 2001,//group assignment data will be assigned to group head "AssignProspectToSalesGroupThree": AssignProspectToSalesGroupThree, "AssignProspectToSalesGroupThreeLimit": AssignProspectToSalesGroupThreeLimit, "sCompID": sCompID }, success: function(d){ $("#displayMsg").html(d) hideAssignMsg(); } }) }); $("#AssignToSalesGroupSixFleet").click(function(){ var sCompID = $("#sCompID").val(); var AssignProspectToSalesGroupSix = $("#AssignProspectToSalesGroupSix").val(); var AssignProspectToSalesGroupSixLimit = $("#AssignProspectToSalesGroupSixLimit").val(); //alert(AssignProspectToSalesGroupSixLimit); //return false; if(AssignProspectToSalesGroupSix==""){ alert("Invalid Entry."); return false; } if(AssignProspectToSalesGroupSixLimit==""){ alert("Please specify the data limit or number of records to be assigned."); return false; } showAssignMsg(); $.ajax({ url: "search_inactive_database_non-fleet.php", type: "POST", async: false, data: { "done": 1, "fleet": 2002,//group assignment data will be assigned to group head "AssignProspectToSalesGroupSix": AssignProspectToSalesGroupSix, "AssignProspectToSalesGroupSixLimit": AssignProspectToSalesGroupSixLimit, "sCompID": sCompID }, success: function(d){ $("#displayMsg").html(d) hideAssignMsg(); } }) }); $("#AssignToSalesGroupYearFleet").click(function(){ var sCompID = $("#sCompID").val(); var AssignProspectToSalesGroupYearFleet = $("#AssignProspectToSalesGroupYearFleet").val(); var AssignProspectToSalesGroupYearLimit = $("#AssignProspectToSalesGroupYearLimit").val(); //alert(AssignProspectToSalesGroupYear); AssignToSalesGroupYearFleet AssignProspectToSalesGroupYearLimit AssignProspectToSalesGroupYearFleet //return false; if(AssignProspectToSalesGroupYearFleet==""){ alert("Invalid Entry."); return false; } if(AssignProspectToSalesGroupYearLimit==""){ alert("Please specify the data limit or number of records to be assigned."); return false; } showAssignMsg(); $.ajax({ url: "search_inactive_database_non-fleet.php", type: "POST", async: false, data: { "done": 1, "fleet": 2003,//group assignment data will be assigned to group head "AssignProspectToSalesGroupYearFleet": AssignProspectToSalesGroupYearFleet, "AssignProspectToSalesGroupYearLimit": AssignProspectToSalesGroupYearLimit, "sCompID": sCompID }, success: function(d){ $("#displayMsg").html(d) hideAssignMsg(); } }) }); //FLEET START OF SEARH INACCTIVE RECORD FOR 3 MONTHS AssignProspectToSalesGroupThree AssignProspectToSalesGroupThreeLimit AssignToSalesGroupThreeFleetYear $("#AssignToSalesGroupThreeFleetNon").click(function(){ var sCompID = $("#sCompID").val(); var AssignProspectToSalesGroupThreeNon = $("#AssignProspectToSalesGroupThreeNon").val(); var AssignProspectToSalesGroupThreeLimitNon = $("#AssignProspectToSalesGroupThreeLimitNon").val(); ////alert(AssignProspectToSalesGroupThreeLimitNon); //return false; if(AssignProspectToSalesGroupThreeNon==""){ alert("Invalid Entry."); return false; } if(AssignProspectToSalesGroupThreeLimitNon==""){ alert("Please specify the data limit or number of records to be assigned."); return false; } showAssignMsg(); $.ajax({ url: "search_inactive_database_non-fleet.php", type: "POST", async: false, data: { "done": 1, "fleet": 1001,//group assignment data will be assigned to group head "AssignProspectToSalesGroupThreeNon": AssignProspectToSalesGroupThreeNon, "AssignProspectToSalesGroupThreeLimitNon": AssignProspectToSalesGroupThreeLimitNon, "sCompID": sCompID }, success: function(d){ $("#displayMsg").html(d) hideAssignMsg(); } }) }); $("#AssignToSalesGroupSixFleetNon").click(function(){ var sCompID = $("#sCompID").val(); var AssignProspectToSalesGroupSixNon = $("#AssignProspectToSalesGroupSixNon").val(); var AssignProspectToSalesGroupSixLimitNon = $("#AssignProspectToSalesGroupSixLimitNon").val(); //alert(AssignProspectToSalesGroupSixLimit); //return false; if(AssignProspectToSalesGroupSixNon==""){ alert("Invalid Entry."); return false; } if(AssignProspectToSalesGroupSixLimitNon==""){ alert("Please specify the data limit or number of records to be assigned."); return false; } showAssignMsg(); $.ajax({ url: "search_inactive_database_non-fleet.php", type: "POST", async: false, data: { "done": 1, "fleet": 1002,//group assignment data will be assigned to group head "AssignProspectToSalesGroupSixNon": AssignProspectToSalesGroupSixNon, "AssignProspectToSalesGroupSixLimitNon": AssignProspectToSalesGroupSixLimitNon, "sCompID": sCompID }, success: function(d){ $("#displayMsg").html(d) hideAssignMsg(); } }) }); $("#AssignToSalesGroupYearFleetNon").click(function(){ var sCompID = $("#sCompID").val(); var AssignProspectToSalesGroupYearFleetNon = $("#AssignProspectToSalesGroupYearFleetNon").val(); var AssignProspectToSalesGroupYearLimitNon = $("#AssignProspectToSalesGroupYearLimitNon").val(); //alert(AssignProspectToSalesGroupYearLimitNon); //return false; if(AssignProspectToSalesGroupYearFleetNon==""){ alert("Invalid Entry."); return false; } if(AssignProspectToSalesGroupYearLimitNon==""){ alert("Please specify the data limit or number of records to be assigned."); return false; } showAssignMsg(); $.ajax({ url: "search_inactive_database_non-fleet.php", type: "POST", async: false, data: { "done": 1, "fleet": 1003,//group assignment data will be assigned to group head "AssignProspectToSalesGroupYearFleetNon": AssignProspectToSalesGroupYearFleetNon, "AssignProspectToSalesGroupYearLimitNon": AssignProspectToSalesGroupYearLimitNon, "sCompID": sCompID }, success: function(d){ $("#displayMsg").html(d) hideAssignMsg(); } }) }); $("#saveGroupName").click(function(){ // var sDealID = $("#sDealID").val(); var newGroupName = $("#newGroupName").val(); var newGroupHead = $("#newGroupHead").val(); //alert(sDealID); //return false; if(newGroupName==""){ alert("Invalid Entry."); return false; } if(newGroupHead==""){ alert("Invalid Entry."); return false; } showAssignGroupMsg(); $.ajax({ url: "add_new_group.php", type: "POST", async: false, data: { "done": 1, "newGroupName": newGroupName, "newGroupHead": newGroupHead, "sDealID": sDealID }, success: function(d){ $("#displayGroupMsgTable").html(d) hideAssignGroupMsg(); } }) }); //==+++++===========================-=-=-=-=-=-=-=-=-=-=-=-=-=//==+++++===========================-=-=-=-=-=-=-=-=-=-=-=-=-=//==+++++===========================-=-=-=-=-=-=-=-=-=-=-=-=-= //==+++++===========================-=-=-=-=-=-=-=-=-=-=-=-=-=//==+++++===========================-=-=-=-=-=-=-=-=-=-=-=-=-=//==+++++===========================-=-=-=-=-=-=-=-=-=-=-=-=-= $("#addSelectedMember").change(function(){ //selGroupNameID addNewMember addNewMember var sDealID = $("#sDealID").val(); var selGroupNameID = $("#selGroupNameID").val(); var addSelectedMember = $("#addSelectedMember").val(); //alert(selGroupNameID); //return false; if(selGroupNameID==""){ alert("Invalid Entry."); return false; } if(addSelectedMember==""){ alert("Invalid Entry."); return false; } //showAddMemeberMsg(); $.ajax({ url: "add_new_group_member.php", type: "POST", async: false, data: { "done": 2, "selGroupNameID": selGroupNameID, "addSelectedMember": addSelectedMember, "sDealID": sDealID }, success: function(d){ $("#displayAddNewMembers").html(d) //hideAddMemeberMsg(); } }) }); function loadGroupMembers(){ //selGroupNameID addNewMember addNewMember var sDealID = $("#sDealID").val(); var selGroupNameID = $("#selGroupNameID").val(); var addSelectedMember = $("#addSelectedMember").val(); //alert(selGroupNameID); //return false; if(selGroupNameID==""){ alert("Invalid Entry."); return false; } if(addSelectedMember==""){ alert("Invalid Entry."); return false; } //showAddMemeberMsg(); $.ajax({ url: "add_new_group_member.php", type: "POST", async: false, data: { "done": 2, "selGroupNameID": selGroupNameID, "addSelectedMember": addSelectedMember, "sDealID": sDealID }, success: function(d){ $("#displayAddNewMembers").html(d) //hideAddMemeberMsg(); } }) }; //==+++++===========================-=-=-=-=-=-=-=-=-=-=-=-=-=//==+++++===========================-=-=-=-=-=-=-=-=-=-=-=-=-=//==+++++===========================-=-=-=-=-=-=-=-=-=-=-=-=-= //==+++++===========================-=-=-=-=-=-=-=-=-=-=-=-=-=//==+++++===========================-=-=-=-=-=-=-=-=-=-=-=-=-=//==+++++===========================-=-=-=-=-=-=-=-=-=-=-=-=-= $("#addNewMember").click(function(){ //selGroupNameID addNewMember var sDealIDa = $("#sDealID").val(); var selGroupNameIDa = $("#selGroupNameID").val(); var addSelectedMembera = $("#addSelectedMember").val(); //alert(addSelectedMember); //return false; if(selGroupNameIDa==""){ alert("Invalid Entry."); return false; } if(addSelectedMembera==""){ alert("Invalid Entry."); return false; } //showAddMemeberMsg(); $.ajax({ url: "add_new_group_member_add.php", type: "POST", async: false, data: { "done": 2, "selGroupNameID": selGroupNameIDa, "addSelectedMember": addSelectedMembera, "sDealID": sDealIDa }, success: function(d){ $("#displayAddNewMembers").html(d) //hideAddMemeberMsg(); } }) }); }); //======================================================= </script> <!---============================================================================================================================---> <!---LOADING NEWLY ENCODED APPOINTMENT LIST FOR UPDATING---> <!---============================================================================================================================---> <script language="javascript" type="text/javascript"> function showMembers(row) { var x=row.cells; document.getElementById("selGroupNameID").value = x[0].innerHTML; document.getElementById("selGroupHeadName").value = x[2].innerHTML; loadGroupMembers(); } </script> <script type="text/javascript"> function hideAssignMsg(){ $("#displayMsg").fadeOut(8000); }; function showAssignMsg(){ $("#displayMsg").fadeIn(); }; function hideAssignGroupMsg(){ $("#displayGroupMsg").fadeOut(8000); }; function showAssignGroupMsg(){ $("#displayGroupMsg").fadeIn(); }; 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'; } } function popUpShowDisplayAddMembers(){ var diva=document.getElementById("displayAddMembers"); if (diva.style.display == 'none') { diva.style.display = ''; } else { diva.style.display = 'none'; } } //END OF DASHBOARD CLICK </script> <!---============================================================================================================================---> <!---END OF SCRIPT---> <!---============================================================================================================================---> <!---============================================================================================================================---> <!---============================================================================================================================---> <script type="text/javascript"> function showAddNewProspect() { var divb = document.getElementById("showSalesGroupSetupForm"); var div = document.getElementById("showAddProspectForm"); var divc = document.getElementById("showSalesTargetForm"); var divd = document.getElementById("showProductCatalogForm"); if (div.style.display == 'none') { div.style.display = ''; divc.style.display = 'none'; divd.style.display = 'none'; divb.style.display = 'none'; } else { div.style.display = 'none'; divb.style.display = 'none'; divc.style.display = 'none'; divd.style.display = 'none'; } } function showFleetAccountOption() { var divy = document.getElementById("XFleetAccountOption"); var divx = document.getElementById("FleetAccountOption"); if (divx.style.display == 'none') { divx.style.display = ''; divy.style.display = 'none'; } else { divx.style.display = ''; divy.style.display = 'none'; } } function showXFleetAccountOption() { var divx = document.getElementById("XFleetAccountOption"); var divy = document.getElementById("FleetAccountOption"); if (divx.style.display == 'none') { divx.style.display = ''; divy.style.display = 'none'; } else { divx.style.display = ''; divy.style.display = 'none'; } } function ViewAllProspects() { var div = document.getElementById("showViewAllProspects"); if (div.style.display == 'none') { div.style.display = ''; } else { div.style.display = 'none'; } } function viewGenerateLeadsForm() { var divb = document.getElementById("showSalesGroupSetupForm"); var div = document.getElementById("showAddProspectForm"); var divc = document.getElementById("showSalesTargetForm"); var divd = document.getElementById("showProductCatalogForm"); var dive = document.getElementById("showGenerateLeadsForm"); if (dive.style.display == 'none') { dive.style.display = ''; divb.style.display = 'none'; div.style.display = 'none'; divc.style.display = 'none'; divd.style.display = 'none'; } else { dive.style.display = 'none'; divc.style.display = 'none'; divd.style.display = 'none'; divb.style.display = 'none'; div.style.display = 'none'; } } function showSalesGroupSetup() { var divb = document.getElementById("showSalesGroupSetupForm"); var div = document.getElementById("showAddProspectForm"); var divc = document.getElementById("showSalesTargetForm"); var divd = document.getElementById("showProductCatalogForm"); if (divb.style.display == 'none') { divb.style.display = ''; div.style.display = 'none'; divc.style.display = 'none'; divd.style.display = 'none'; } else { divc.style.display = 'none'; divd.style.display = 'none'; divb.style.display = 'none'; div.style.display = 'none'; } } function showSalesGroupTarget() { var divb = document.getElementById("showSalesGroupSetupForm"); var div = document.getElementById("showAddProspectForm"); var divc = document.getElementById("showSalesTargetForm"); var divd = document.getElementById("showProductCatalogForm"); if (divc.style.display == 'none') { divb.style.display = 'none'; divc.style.display = ''; divd.style.display = 'none'; div.style.display = 'none'; } else { divb.style.display = 'none'; div.style.display = 'none'; divc.style.display = 'none'; divd.style.display = 'none'; } } function showProductCatalog() { var divb = document.getElementById("showSalesGroupSetupForm"); var div = document.getElementById("showAddProspectForm"); var divc = document.getElementById("showSalesTargetForm"); var divd = document.getElementById("showProductCatalogForm"); if (divd.style.display == 'none') { divb.style.display = 'none'; divd.style.display = ''; divc.style.display = 'none'; div.style.display = 'none'; } else { divb.style.display = 'none'; div.style.display = 'none'; divc.style.display = 'none'; divd.style.display = 'none'; divw.style.display = 'none'; } } function showNonFleetSearch() { var divx = document.getElementById("showFleetSearchForm"); var divy = document.getElementById("showNonFleetSearchForm"); if (divy.style.display == 'none') { divy.style.display = ''; divx.style.display = 'none'; } else { divy.style.display = ''; divx.style.display = 'none'; } } function showProspectList() { var divz = document.getElementById("showProspectListForm"); if (divz.style.display == 'none') { divz.style.display = ''; } else { divz.style.display = ''; } } function showFleetSearch() { var divx = document.getElementById("showFleetSearchForm"); var divy = document.getElementById("showNonFleetSearchForm"); var divw = document.getElementById("displayProspectList"); var divz = document.getElementById("showProspectListForm"); var divt = document.getElementById("displayFleetNonFleetSearch"); if (divx.style.display == 'none') { divx.style.display = ''; divt.style.display = ''; divy.style.display = 'none'; divw.style.display = 'none'; divz.style.display = 'none'; } else { divy.style.display = 'none'; divx.style.display = ''; divt.style.display = ''; divw.style.display = 'none'; divz.style.display = 'none'; } } //DISPLAY ASSIGN BUTTON AFTER FILTERING //id="ThreeMonthsInActivityXFleet" exportThreeMonthsNonFleet exportSixMonthsNonFleet exportYearNonFleet function showexportThreeMonthsNonFleet() { var divThree = document.getElementById("exportThreeMonthsNonFleet"); var divSix = document.getElementById("exportSixMonthsNonFleet"); var divYear = document.getElementById("exportYearNonFleet"); var divFThree = document.getElementById("exportThreeMonthsFleet"); var divFSix = document.getElementById("exportSixMonthsFleet"); var divFYear = document.getElementById("exportYearFleet"); if (divThree.style.display == 'none') { divThree.style.display = ''; divSix.style.display = 'none'; divYear.style.display = 'none'; divFThree.style.display = 'none'; divFSix.style.display = 'none'; divFYear.style.display = 'none'; } else { divThree.style.display = ''; divSix.style.display = 'none'; divYear.style.display = 'none'; divFThree.style.display = 'none'; divFSix.style.display = 'none'; divFYear.style.display = 'none'; } } function showexportSixMonthsNonFleet() { var divThree = document.getElementById("exportThreeMonthsNonFleet"); var divSix = document.getElementById("exportSixMonthsNonFleet"); var divYear = document.getElementById("exportYearNonFleet"); var divFThree = document.getElementById("exportThreeMonthsFleet"); var divFSix = document.getElementById("exportSixMonthsFleet"); var divFYear = document.getElementById("exportYearFleet"); if (divSix.style.display == 'none') { divSix.style.display = ''; divThree.style.display = 'none'; divYear.style.display = 'none'; divFThree.style.display = 'none'; divFSix.style.display = 'none'; divFYear.style.display = 'none'; } else { divSix.style.display = ''; divThree.style.display = 'none'; divYear.style.display = 'none'; divFThree.style.display = 'none'; divFSix.style.display = 'none'; divFYear.style.display = 'none'; } } function showexportYearMonthsNonFleet() { var divThree = document.getElementById("exportThreeMonthsNonFleet"); var divSix = document.getElementById("exportSixMonthsNonFleet"); var divYear = document.getElementById("exportYearNonFleet"); var divFThree = document.getElementById("exportThreeMonthsFleet"); var divFSix = document.getElementById("exportSixMonthsFleet"); var divFYear = document.getElementById("exportYearFleet"); if (divYear.style.display == 'none') { divYear.style.display = ''; divSix.style.display = 'none'; divThree.style.display = 'none'; divFThree.style.display = 'none'; divFSix.style.display = 'none'; divFYear.style.display = 'none'; } else { divYear.style.display = ''; divSix.style.display = 'none'; divThree.style.display = 'none'; divFThree.style.display = 'none'; divFSix.style.display = 'none'; divFYear.style.display = 'none'; } } //FLEET function showexportThreeMonthsFleet() { var divThree = document.getElementById("exportThreeMonthsFleet"); var divSix = document.getElementById("exportSixMonthsFleet"); var divYear = document.getElementById("exportYearFleet"); var divNThree = document.getElementById("exportThreeMonthsNonFleet"); var divNSix = document.getElementById("exportSixMonthsNonFleet"); var divNYear = document.getElementById("exportYearNonFleet"); if (divThree.style.display == 'none') { divThree.style.display = ''; divSix.style.display = 'none'; divYear.style.display = 'none'; divNThree.style.display = 'none'; divNSix.style.display = 'none'; divNYear.style.display = 'none'; } else { divThree.style.display = ''; divSix.style.display = 'none'; divYear.style.display = 'none'; divNThree.style.display = 'none'; divNSix.style.display = 'none'; divNYear.style.display = 'none'; } } function showexportSixMonthsFleet() { var divThree = document.getElementById("exportThreeMonthsFleet"); var divSix = document.getElementById("exportSixMonthsFleet"); var divYear = document.getElementById("exportYearFleet"); var divNThree = document.getElementById("exportThreeMonthsNonFleet"); var divNSix = document.getElementById("exportSixMonthsNonFleet"); var divNYear = document.getElementById("exportYearNonFleet"); if (divSix.style.display == 'none') { divSix.style.display = ''; divThree.style.display = 'none'; divYear.style.display = 'none'; divNThree.style.display = 'none'; divNSix.style.display = 'none'; divNYear.style.display = 'none'; } else { divSix.style.display = ''; divThree.style.display = 'none'; divYear.style.display = 'none'; divNThree.style.display = 'none'; divNSix.style.display = 'none'; divNYear.style.display = 'none'; } } function showexportYearMonthsFleet() { var divThree = document.getElementById("exportThreeMonthsFleet"); var divSix = document.getElementById("exportSixMonthsFleet"); var divYear = document.getElementById("exportYearFleet"); var divNThree = document.getElementById("exportThreeMonthsNonFleet"); var divNSix = document.getElementById("exportSixMonthsNonFleet"); var divNYear = document.getElementById("exportYearNonFleet"); if (divYear.style.display == 'none') { divYear.style.display = ''; divSix.style.display = 'none'; divThree.style.display = 'none'; divNThree.style.display = 'none'; divNSix.style.display = 'none'; divNYear.style.display = 'none'; } else { divYear.style.display = ''; divSix.style.display = 'none'; divThree.style.display = 'none'; divNThree.style.display = 'none'; divNSix.style.display = 'none'; divNYear.style.display = 'none'; } } </script> <!--FOR TO ADD NEW PROSPECT--> <!--FORM TO ADD NYO PROSPECT--> <input type="hidden" id="sCompID" value="<?php echo $compID;?>" style="width:200px;padding:5px;font-family:Verdana;font-size:14px"> <input type="hidden" id="sDealID" value="<?php echo $dealID;?>" style="width:200px;padding:5px;font-family:Verdana;font-size:14px"> <input type="hidden" id="svDate" value="<?php echo $toDate;?>" style="width:200px;padding:5px;font-family:Verdana;font-size:14px"> <input type="hidden" id="svTime" value="<?php echo $myCurTime;?>" style="width:200px;padding:5px;font-family:Verdana;font-size:14px"> <input type="hidden" id="svUserID" value="<?php echo $userID;?>" style="width:200px;padding:5px;font-family:Verdana;font-size:14px"> <div id="showAddProspectForm" style="display:none;background:white;position:absolute;top:50px;left:100px;width:900px;min-width:500px;height:500px;border:1px solid gray"> <div class='bgColor' style='vertical-align:top;height:35px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-weight:normal;font-size:18px;color:#043062'>Add New Prospect <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='mainindex.php?id=25&d=lms' onclick="showAddNewProspect()" style='font-weight:bold'> ✕ </a> </div> </div> <div style="padding:5px;width:100%;margin:0px;border-bottom:1px solid gray;background:white;height:100px"> <div style="float:left;border:1px solid #16a085;background: #48c9b0;width:200px;height:30px;border-radius:15px 0px 0px 0px;font-size:14px;color:#0e6251;padding:5px;"> <a href="#" onclick="showFleetSearch(this.value)" style="background:transparent">🏙 Fleet Account</a></div> <div style="float:left;border:1px solid #d35400 ;background: #f4d03f;width:200px;height:30px;border-radius:15px 0px 0px 0px;font-size:14px;color: #873600;padding:5px;"> <a href="#" onclick="showNonFleetSearch(this.value)"style="background:transparent">👮 Non-Fleet Account</a></div> <div id="showNonFleetSearchForm" style="display:;float:left;padding:10px;width:100%;margin:0px;border-bottom:1px solid gray;background:#f4d03f;height:100px"> <p style="background:transparent;margin:0px;padding:3px;font-family:Verdana;font-size:14px;color:black;font-weight:bold">🎾 Search Record: <i style="font-weight:normal;font-family:Verdana;font-size:12px">(Lastname, Firstname)</i></p> <input type="text" id="nonFleetSearchText" style="height:32px;float:left;margin:0px;margin-left:25px;padding:5px;font-family:Verdana;font-size:14px; color:blue;width:400px;border:1px solid #d35400 "> <input type="submit" Value="♺ Search..." id="nonFleetSearchTextGo" style="margin:0px;border-radius:0px;border-left:0px;float:left;padding:5px;font-family:Verdana;font-size:14px; color:blue;width:130px;"> </div> <div id="showFleetSearchForm" style="display:none;float:left;padding:10px;width:100%;margin:0px;border-bottom:1px solid gray;background:#48c9b0;height:100px"> <p style="background:transparent;margin:0px;padding:3px;font-family:Verdana;font-size:14px;color:black;font-weight:bold">🎾 Search Record: <i style="font-weight:normal;font-family:Verdana;font-size:12px">(Company/Co-operatives/Organization)</i></p> <input type="text" id="FleetSearchText" style="height:32px;float:left;margin:0px;margin-left:25px;padding:5px;font-family:Verdana;font-size:14px; color:blue;width:400px;border:1px solid #117a65 "> <input type="submit" Value="♺ Search..." id="FleetSearchTextGo" style="margin:0px;border-radius:0px;border-left:0px;float:left;padding:5px;font-family:Verdana;font-size:14px; color:blue;width:130px;"> </div> <div id="displayFleetNonFleetSearch" style="display:block;float:left;padding:0px;width:100%;margin:0px;border:1px solid gray;background:#fff;height:320px;border-top:0px;overflow:auto"> </div> </div> </div> <!-- VIEW ALL PROSPECTS--> <div id="showViewAllProspects" style="display:none;background:white;position:absolute;top:50px;left:100px;width:900px;min-width:500px;height:500px;border:1px solid gray"> <div class='bgColor' style='vertical-align:top;height:35px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-weight:normal;font-size:18px;color:#043062'>PROSPECT SUMMARY <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='mainindex.php?id=25&d=lms' onclick="ViewAllProspects()" style='font-weight:bold'> ✕ </a> </div> </div> <div style="padding:5px;width:100%;margin:0px;border-bottom:1px solid gray;background:white;height:100px"> <div style="float:left;border:1px solid #d35400 ;background:#f773ef;width:200px;height:30px;border-radius:15px 0px 0px 0px;font-size:14px;color: #873600;padding:2px;border-bottom:0px"> <a href="#" onclick="showProspectList(this.value)"style="background:transparent;font-family:Verdana;font-size:16px;font-weight:bold">👮 Prospect List</a></div> <div id="showProspectListForm" style="display:block;float:left;padding:10px;width:100%;margin:0px;border:1px solid gray;background:#fcc7f9;height:100px"> <p style="background:transparent;margin:0px;padding:3px;font-family:Verdana;font-size:14px;color:black;font-weight:bold">🎾 Search Record: <i style="font-weight:normal;font-family:Verdana;font-size:12px">(Company/Co-operatives/Organization)</i></p> <input type="text" id="searchProspect" style="height:32px;float:left;margin:0px;margin-left:25px;padding:5px;font-family:Verdana;font-size:14px; color:blue;width:400px;border:1px solid #117a65 "> <input type="submit" Value="♺ Search..." id="GoSearchProspect" style="margin:0px;border-radius:0px;border-left:0px;float:left;padding:5px;font-family:Verdana;font-size:14px; color:blue;width:130px;"> </div> <div id="displayProspectList" style="display:block;float:left;padding:0px;width:100%;margin:0px;border:1px solid gray;background:#fff;height:320px;border-top:0px;overflow:auto"> </div> </div> </div> <div id="showSalesGroupSetupForm" style="display:none;background:white;position:absolute;top:50px;left:100px;width:900px;min-width:500px;height:500px;border:1px solid gray"> <div class='bgColor' style='vertical-align:top;height:35px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-weight:normal;font-size:18px;color:#043062'>Sales Group Setup: <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='mainindex.php?id=25&d=lms' onclick="showSalesGroupSetup()" style='font-weight:bold'> ✕ </a> </div> </div> <div style="width:100%;height:100px;background:lightgray;border:1px solid gray "> <div style="float:left;margin:5px;margin-bottom:0px;width:30%;border:0px solid red;height:30px"> <p style="font-family:Calibri;font-size:20px;padding:0px;padding-left:15px;margin:0px;float:left;color:black">Type Group Name</p> </div> <div style="float:left;margin:5px;margin-bottom:0px;width:35%;border:0px solid red;height:30px"> <p style="font-family:Calibri;font-size:20px;padding:0px;padding-left:15px;margin:0px;float:left;color:black">Group Head</p> </div> <div style="float:left;margin:5px;margin-bottom:1px;margin-bottom:1px;width:20%;border:0px solid red;height:30px"> </div> <div style="float:left;padding:0px;padding-left:15px;width:30%;margin:0px;height:50px;border:0px solid blue"> <input type="text" id="newGroupName" placeholder="Input Group Name" style="margin:1pxwidth:100%;padding:5px;margin-top:0px;font-family:Calibri;font-size:16px"> </div> <div style="float:left;margin:5px;margin-bottom:0px;width:35%;border:0px solid red;height:30px"> <select id="newGroupHead" style="margin:1pxwidth:100%;padding:5px;margin-top:-5px;font-family:Calibri;font-size:16px"> <option value="">--Select Group Head--</option> <?php $mPosition='Sales'; $getGroup = mysql_query("SELECT * FROM `vts_users` WHERE `u_position` LIKE '%$mPosition%' AND `u_status`=1 ORDER BY `u_lname` ASC"); while($grp = mysql_fetch_array($getGroup)){ echo "<option value=".$grp['u_id'].">".$grp['u_lname'].", ".$grp['u_fname']."</option>"; } ?> </select> </select> </div> <div style="float:left;padding:0px;padding-left:15px;width:20%;margin:0px;height:50px;border:0px solid blue"> <input type="submit" id="saveGroupName" value="Add New Group" style="width:80%;padding:5px;margin-top:0px;font-family:Calibri;font-size:16px"> </div> </div> <div id="displayGroupMsgTable" style="width:100%;height:340px;background:white;border:0px solid black;overflow:auto"> <?php $getSalesGroup = mysql_query("SELECT * From `db_sales_group` WHERE `active`=1 ORDER BY `group_name` ASC"); echo "<table style='width:100%'>"; echo "<thead>"; echo "<th style='width:10%'>ID</th>"; echo "<th style='width:35%'>Group Name</th>"; echo "<th style='width:35%'>Group Head</th>"; echo "<th style='width:10%'>Members</th>"; echo "<th style='width:10%'>Assigend Database</th>"; echo "</thead>"; while($row=mysql_fetch_array($getSalesGroup)){ $gHead = $row['group_head']; $gID= $row['gid']; $gFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$gHead'"),0); $gLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$gHead'"),0); $getMember = mysql_result(mysql_query("SELECT COUNT('u_id') FROM `vts_users` WHERE `sales_group`='$gID'"),0); ?><tr onclick="javascript:showMembers(this);" ondblclick="popUpShowDisplayAddMembers()"><?php echo "<td style='text-align:left;padding:10px;'>".$row['gid']."</td>"; echo "<td style='text-align:left;padding:10px;'>".$row['group_name']."</td>"; echo "<td style='text-align:left;padding:10px;'>".$gLname. ", ".$gFname."</td>"; echo "<td style='text-align:center;padding:10px;'>".number_format($getMember,0,'.',',')."</td>"; echo "<td style='text-align:center;padding:10px;'>"; $countAssignDB = mysql_result(mysql_query("SELECT COUNT(`c_id`) FROM `vts_customers` WHERE `lead_tag`='$gID'"),0); echo $countAssignDB; echo "</td>"; echo "</tr>"; } echo "</table>"; ?> </div> <div id="displayGroupMsg" style="text-align:center;font-family:Calibri;font-size:30px;padding:5px;display:none;background:yellow;position:absolute;top:90%;left:1px;width:99.9%;height:10%;border:0px solid gray;z-index:999"> <p style='padding:3px; margin:0px;font-size:24px;color:black'> New Group has been added.</p> </div> <!-- ============================================= --> <!-- ============================================= --> <div id="displayAddMembers" style="text-align:center;font-family:Calibri;font-size:30px;padding:0px;display:none;background:white;position:absolute;top:5%;left:20px;width:90%;height:80%;border:1px solid gray;z-index:999"> <div class='bgColor' style='vertical-align:top;height:35px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-weight:normal;font-size:18px;color:#043062'>SALES GROUP MANAGEMENT: <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='#' onclick="popUpShowDisplayAddMembers()" style='font-weight:bold'> ✕ </a> </div> </div> <div style="width:100%;height:100px;background:lightgray;border:1px solid gray "> <div style="float:left;margin:0px;margin-bottom:0px;width:15%;border:0px solid red;height:20px;font-size:16px;color:black;text-align:left"> Group I.D </div> <div style="float:left;margin:0px;margin-bottom:0px;width:30%;border:0px solid red;height:20px;font-size:16px;color:black;text-align:left"> Group Head </div> <div style="float:left;margin:0px;margin-bottom:0px;width:35%;border:0px solid red;height:20px;font-size:16px;color:black;text-align:left"> Select Sales Person </div> <div style="float:left;margin:0px;margin-bottom:1px;margin-bottom:0px;width:20%;border:0px solid red;height:20px"> </div> <div style="float:left;margin:0px;margin-bottom:0px;width:15%;border:0px solid red; "> <input type="text" readonly id="selGroupNameID" style="width:100%;padding:5px;margin:0px;font-family:Calibri;font-size:16px"> </div> <div style="float:left;margin:0px;margin-bottom:0px;width:30%;border:0px solid red; "> <input type="text" readonly id="selGroupHeadName" style="width:100%;padding:5px;margin:0px;font-family:Calibri;font-size:16px"> </div> <div style="float:left;margin:0px;margin-bottom:0px;width:35%;border:0px solid red; "> <select id="addSelectedMember" style="margin:1px;width:100%;padding:5px;font-family:Calibri;font-size:16px"> <option value="">--Select --</option> <?php $mPosition='Sale'; $getGroup = mysql_query("SELECT * FROM `vts_users` WHERE `u_position` LIKE '%$mPosition%' AND `u_status`= 1 ORDER BY `u_lname` ASC"); while($grp = mysql_fetch_array($getGroup)){ echo "<option value=".$grp['u_id'].">".$grp['u_lname'].", ".$grp['u_fname']."</option>"; } ?> </select> </div> <div style="float:left;margin:0px;margin-bottom:1px;margin-bottom:1px;width:20%;border:0px solid red; "> <input type="submit" id="addNewMember" value="Add Member" style="width:80%;padding:5px;margin-top:0px;font-family:Calibri;font-size:16px"> </div> </div> <div id='displayAddNewMembers' style="width:100%;height:258px;background:white;border:0px solid black "> </div> </div> </div> <div id="showGenerateLeadsForm" style="display:none;background:white;position:absolute;top:50px;left:100px;width:1200px;min-width:800px;height:718px;border:1px solid gray"> <div class='bgColor' style='vertical-align:top;height:35px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-weight:normal;font-size:18px;color:#043062'>GENERATE LEADS: <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='#' onclick="viewGenerateLeadsForm()" style='font-weight:bold'> ✕ </a> </div> </div> <!-- ============================================= --> <div style="display:block;float:left;padding:15px;width:100%;margin:0px;border:0px solid gray;background:#fff;height:620px "> <div d="XFleetAccountOption" style="float:left;border:1px solid #16a085;background: #48c9b0;width:300px;height:30px;border-radius:15px 0px 0px 0px;font-size:14px;color:#0e6251;padding:3px;border-bottom:0px"> <a href="#" onclick = "showXFleetAccountOption()" style="background:transparent;font-family:Verdana;font-size:16px;font-weight:bold">💁 Non-Fleet Account</a></div> <div style="display:block;float:left;border:1px solid #16a085;background:#f7efbe;width:300px;height:30px;border-radius:15px 0px 0px 0px;font-size:14px;color:#0e6251;padding:3px;border-bottom:0px"> <a href="#" onclick = "showFleetAccountOption()" style="background:transparent;font-family:Verdana;font-size:16px;font-weight:bold">💁 Fleet Account</a></div> <!-- ============================================= --> <div id="XFleetAccountOption" style="display:block;float:left;padding:20px;padding-top:5px;width:100%;margin:0px;border:1px solid gray;background:#48c9b0 ;height:120px "> <p style="padding:5px;margin:5px;font-family:Verdana;font-size:24px;color:black">📩 Non-Fleet Account</p> <button id="ThreeMonthsInActivityXFleet" onclick="showexportThreeMonthsNonFleet()" style="margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px">(3 - 6) Months of InActivity</button> <button id="SixMonthsInActivityXFleet" onclick="showexportSixMonthsNonFleet()" style="margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px">(6 - 12) Months of InActivity</button> <button id="OneYearInActivityXFleet" onclick="showexportYearMonthsNonFleet()" style="margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px">(1 Year Above of InActivity</button> </div> <!-- ============================================= --> <div id="FleetAccountOption" style="display:none;float:left;padding:20px;padding-top:5px;width:100%;margin:0px;border:1px solid gray;background:#f7efbe ;height:120px "> <p style="padding:5px;margin:5px;font-family:Verdana;font-size:24px;color:black">📩 Fleet Account</p> <button id="ThreeMonthsInActivityFleet" onclick="showexportThreeMonthsFleet()" style="margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px">Three(3) Months of InActivity</button> <button id="SixMonthsInActivityFleet" onclick="showexportSixMonthsFleet()" style="margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px">Six (6) Months of InActivity</button> <button id="OneYearInActivityFleet" onclick="showexportYearMonthsFleet()" style="margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px">One (1) Year of InActivity</button> </div> <!-- ============================================= --> <div id="displayLeadsGenerated" style="display:block;float:left;padding:0px;width:100%;margin:0px;border:1px solid gray;background:#fff;height:430px;border-top:0px"> </div> <div id="displayMsg" style="text-align:center;font-family:Calibri;font-size:30px;padding:10px;display:none;background:yellow;position:absolute;top:2%;left:1px;width:100%;height:80px;border:1px solid gray;z-index:999"> </div> <!-- ==================LEADS GROUP ASSIGNMENT CODES=========================== --> <div id="exportThreeMonthsNonFleet" style="display:none;text-align:center;padding:10px;float:left;background:#48c9b0;width:100%;margin:0px;height:80px;border:0px solid green;z-index:99999"> <select id="AssignProspectToSalesGroupThreeNon" style="width:40%;float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px"> <option value="">--Select Sales Group --</option> <?php $getGroup = mysql_query("SELECT * FROM `db_sales_group` WHERE `active`=1 ORDER BY `gid` ASC"); while($grp = mysql_fetch_array($getGroup)){ echo "<option value=".$grp['gid'].">".$grp['group_name']."</option>"; } ?> </select> <input type="number" id="AssignProspectToSalesGroupThreeLimitNon" Placeholder ="Limit" style="width:10%;float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px"> <button id="AssignToSalesGroupThreeFleetNon" style="float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px">Assign Database</button> <button id="DownloadDatabaseThreeFleetNon" style="float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px">Download Database</button> </div> <!-- ==================six=========================== --> <div id="exportSixMonthsNonFleet" style="display:none;text-align:center;padding:10px;float:left;background:#48c9b0;width:100%;margin:0px;height:80px;border:0px solid green;z-index:99999"> <select id="AssignProspectToSalesGroupSixNon" style="width:40%;float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px"> <option value="">--Select Sales Group --</option> <?php $getGroup = mysql_query("SELECT * FROM `db_sales_group` WHERE `active`=1 ORDER BY `gid` ASC"); while($grp = mysql_fetch_array($getGroup)){ echo "<option value=".$grp['gid'].">".$grp['group_name']."</option>"; } ?> </select> <input type="number" id="AssignProspectToSalesGroupSixLimitNon" Placeholder ="Limit" style="width:10%;float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px"> <button id="AssignToSalesGroupSixFleetNon" style="float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px">Assign Database</button> <button id="DownloadDatabaseSixFleetNon" style="float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px">Download Database</button> </div> <!-- ==================year=========================== --> <div id="exportYearNonFleet" style="display:none;text-align:center;padding:10px;float:left;background:#48c9b0;width:100%;margin:0px;height:80px;border:0px solid green;z-index:99999"> <select id="AssignProspectToSalesGroupYearNon" style="width:40%;float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px"> <option value="">--Select Sales Group --</option> <?php $getGroup = mysql_query("SELECT * FROM `db_sales_group` WHERE `active`=1 ORDER BY `gid` ASC"); while($grp = mysql_fetch_array($getGroup)){ echo "<option value=".$grp['gid'].">".$grp['group_name']."</option>"; } ?> </select> <input type="number" id="AssignProspectToSalesGroupYearLimitNon" Placeholder ="Limit" style="width:10%;float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px"> <button id="AssignToSalesGroupYearFleetNon" style="float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px">Assign Database</button> <button id="DownloadDatabaseYearFleetNon" style="float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px">Download Database</button> </div> <!-- ==================LEADS GROUP ASSIGNMENT CODES=========================== --> <div id="exportThreeMonthsFleet" style="display:none;text-align:center;padding:10px;float:left;background:#f7efbe;width:100%;margin:0px;height:80px;border:0px solid green;z-index:99999"> <select id="AssignProspectToSalesGroupThree" style="width:40%;float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px"> <option value="">--Select Sales Group --</option> <?php $getGroup = mysql_query("SELECT * FROM `db_sales_group` WHERE `active`=1 ORDER BY `gid` ASC"); while($grp = mysql_fetch_array($getGroup)){ echo "<option value=".$grp['gid'].">".$grp['group_name']."</option>"; } ?> </select> <input type="number" id="AssignProspectToSalesGroupThreeLimit" Placeholder ="Limit" style="width:10%;float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px"> <button id="AssignToSalesGroupThreeFleet" style="float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px">Assign Database</button> <button id="DownloadDatabaseThreeFleet" style="float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px">Download Database</button> </div> <!-- ==================six=========================== --> <div id="exportSixMonthsFleet" style="display:none;text-align:center;padding:10px;float:left;background:#f7efbe;width:100%;margin:0px;height:80px;border:0px solid green;z-index:99999"> <select id="AssignProspectToSalesGroupSix" style="width:40%;float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px"> <option value="">--Select Sales Group --</option> <?php $getGroup = mysql_query("SELECT * FROM `db_sales_group` WHERE `active`=1 ORDER BY `gid` ASC"); while($grp = mysql_fetch_array($getGroup)){ echo "<option value=".$grp['gid'].">".$grp['group_name']."</option>"; } ?> </select> <input type="number" id="AssignProspectToSalesGroupSixLimit" Placeholder ="Limit" style="width:10%;float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px"> <button id="AssignToSalesGroupSixFleet" style="float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px">Assign Database</button> <button id="DownloadDatabaseSixFleet" style="float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px">Download Database</button> </div> <!-- ==================FLEET 1 year=========================== --> <div id="exportYearFleet" style="display:none;text-align:center;padding:10px;float:left;background:#f7efbe;width:100%;margin:0px;height:80px;border:0px solid green;z-index:99999"> <select id="AssignProspectToSalesGroupYearFleet" style="width:40%;float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px"> <option value="">--Select Sales Group --</option> <?php $getGroup = mysql_query("SELECT * FROM `db_sales_group` WHERE `active`=1 ORDER BY `gid` ASC"); while($grp = mysql_fetch_array($getGroup)){ echo "<option value=".$grp['gid'].">".$grp['group_name']."</option>"; } ?> </select> <input type="number" id="AssignProspectToSalesGroupYearLimit" Placeholder ="Limit" style="width:10%;float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px"> <button id="AssignToSalesGroupYearFleet" style="float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px">Assign Database </button> <button id="DownloadDatabaseSixFleet" style="float:left;margin:5px;float:left;padding:10px;font-family:Verdana;font-size:14px;font-weight:bold;padding-left:25p;padding-right:25px">Download Database</button> </div> <!-- ==================END OF LEADS GROUP ASSIGNMENT CODES=========================== --> <!-- ==================END OF LEADS GROUP ASSIGNMENT CODES=========================== --> </div> <!-- ============================================= --> </div> <div id="showSalesTargetForm" style="display:none;background:white;position:absolute;top:50px;left:100px;width:900px;min-width:500px;height:500px;border:1px solid gray"> <div class='bgColor' style='vertical-align:top;height:35px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-weight:normal;font-size:18px;color:#043062'>Sales Target Setup: <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='mainindex.php?id=25&d=lms' onclick="showSalesGroupTarget()" style='font-weight:bold'> ✕ </a> </div> </div> </div> <div id="showProductCatalogForm" style="display:none;background:white;position:absolute;top:50px;left:100px;width:900px;min-width:500px;height:500px;border:1px solid gray"> <div class='bgColor' style='vertical-align:top;height:35px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-weight:normal;font-size:18px;color:#043062'>Add Product Catalog: <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='mainindex.php?id=25&d=lms' onclick="showProductCatalog()" style='font-weight:bold'> ✕ </a> </div> </div> </div> <?php $FirstDate = date('Y/m/01'); $LastDate = date('Y/m/t'); $getFleet= mysql_result(mysql_query("SELECT COUNT('bid') FROM `businesses_names` WHERE `status`='1' ORDER BY `business_name` ASC"),0); $getNonFleet=mysql_result(mysql_query("SELECT COUNT('c_id') FROM `vts_customers` WHERE `status`='1' "),0); $activeLead= mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `lose_date`='' AND `win_date`=''"),0); $activeLeadsFleet=mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `is_fleet`='Yes' AND `lost_date`='' AND `win_date`='' AND `comp_id`='$compID'"),0); $activeLeadsNonFlee=mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `is_fleet`='No' AND `lost_date`='' AND `win_date`='' AND `comp_id`='$compID'"),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); $getFleet = number_format($getFleet,0,'.',','); $getNonFleet = number_format($getNonFleet,0,'.',','); $activeLead = number_format($activeLead,0,'.',','); $activeLeadsFleet = number_format($activeLeadsFleet,0,'.',','); $activeLeadsNonFlee = number_format($activeLeadsNonFlee,0,'.',','); ?> <!---============================================================================================================================---> <!---END CODE LOAD NEW SERVICE APPT---> <!---============================================================================================================================---> <div style="background:#fff;height:100%; border:0px solid blue"> <div class="vertical-menu" style='background:#fff width:100%;border-bottom:0px solid black'> <a href="#" class="active" style='padding:8px;padding-left:5px;font-family:Verdana;font-size:16px;font-weight:normal;color:#000'>☵ DATABASE COUNT</a> <div style='width:100%;height:100%;float:left;text-align:centerl;font-family:Verdana;font-size:30px;border:0px solid red;background:#fff;padding:0px'> <div style='margin:0px;background:white ;width:100%;height:850px;border:0px solid gray;padding:5px;'> <div style='background:transparent;float:bottom;height:25%;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='background:#fff;border:1px solid #fff '> <div class='dbCount' style='padding:0px;background:#fff;height:40px;border:0px solid #fff;font-weight:normal;'> <a href="#" class="active" style='height:40px;padding:8px;padding-left:5px;font-family:Verdana;font-size:16px;font-weight:normal;color:#000'>📝 <u>Stored Database </a> </u> </div> <div style="float:left;width:49%;height:70%;margin:0px;margin-top:10px;border:1px solid #f1c40f ;background: #f9e79f "> <div style='width:100%;margin:0px;background:#f4d03f;font-size:16px;text-align:center;font-weight:bold;padding:3px'>Fleet</div> <center><p style="font-size:25px;font-weight:bold;color:blue"><?php echo $getFleet;?></p></center> </div> <div style="float:right;width:49%;height:70%;margin:0px;margin-top:10px;border:1px solid #f1c40f ;background: #f9e79f "> <div style='width:100%;margin:0px;background:#f4d03f;font-size:16px;text-align:center;font-weight:bold;padding:3px'>Non-Fleet</div> <center><p style="font-size:25px;font-weight:bold;color:blue"><?php echo $getNonFleet;?></p></center> </div> </div> </div> <div class='dbCount' style='padding:0px;background:#f5b041;height:40px;border:1px solid #fff;font-weight:normal;'> <a href="#" class="active" style='padding:8px;padding-left:5px;font-family:Verdana;font-size:16px;font-weight:normal;color:#000'>🗊 <u>LMS Management</a></u> </div> <div class='dbCount' style='background:#fff;height:40px;border:1px solid #fff;font-weight:normal;height:auto'> <button id='generateLeads' onclick="viewGenerateLeadsForm(this.value)" style="width:100%;padding:5px;margin-left:5px;float:left;margin-top:10px;text-align:left;font-size:18px;"> <b style="padding-right:15px;">➲ </b>Generate Leads</button> <button id='setupViewProspect' onclick="ViewAllProspects(this.value)" style="width:100%;padding:5px;margin-left:5px;float:left;margin-top:10px;text-align:left;font-size:18px;"> <b style="padding-right:15px;">📑 </b>View Leads</button> <button id='addNewProspect' onclick="showAddNewProspect(this.value)" style="width:100%;padding:5px;margin-left:5px;float:left;margin-top:10px;text-align:left;font-size:18px;"> <b style="padding-right:15px;">📌 </b>Assigned Leads</button> <button id='setupSalesGroup' onclick="showSalesGroupSetup(this.value)" style="width:100%;padding:5px;margin-left:5px;float:left;margin-top:10px;text-align:left;font-size:18px;"> <b style="padding-right:15px;">👪 </b>Sales Group</button> <button id='setupSalesTarget' onclick="showSalesGroupTarget(this.value)" style="width:100%;padding:5px;margin-left:5px;float:left;margin-top:10px;text-align:left;font-size:18px;"> <b style="padding-right:15px;">📍 </b>Sales Target</button> <button id='AddProductCatalog' onclick="showProductCatalog(this.value)" style="width:100%;padding:5px;margin-left:5px;float:left;margin-top:10px;text-align:left;font-size:18px;"> <b style="padding-right:15px;">📜</b>Product Lists</button> </div> <div class='dbCount' style='padding:0px;background:#f5b041;height:40px;border:1px solid #fff;font-weight:normal;'> <a href="#" class="active" style='padding:8px;padding-left:5px;font-family:Verdana;font-size:16px;font-weight:normal;color:#000'>📋 <u>Prospects By Type </a></u> </div> <div class='dbCount' style='width:60%;float:left;border:1px solid #fff;height:40px;background:white;border:0px solid red;font-size:16px;padding-left:20px;text-align:right;color:blue'>Fleet: 🏥</div> <div class='dbCount' style='width:40%;float:left;border:1px solid #fff;height:40px;background:white;border:0px solid red;font-size:16px;padding-left:50px;text-align:right;color:blue;padding-right:10px'><?php echo $activeLeadsFleet;?></div> <div class='dbCount' style='width:60%;float:left;border:1px solid #fff;height:40px;background:white;border:0px solid red; font-size:16px;padding-left:20px;text-align:right;color:blue'>Non-Fleet:👮</div> <div class='dbCount' style='width:40%;float:left;border:1px solid #fff;height:40px;background:white;border:0px solid red; font-size:16px;padding-left:50px;text-align:right;color:blue;padding-right:10px'><?php echo $activeLeadsNonFlee;?></div> <div class='dbCount' style='padding:0px;background:#f5b041;height:40px;border:1px solid #fff;font-weight:normal;'> <a href="#" class="active" style='padding:8px;padding-left:5px;font-family:Verdana;font-size:16px;font-weight:normal;color:#000'>📝 <u>Prospects By Group </a></u> </div> <?php $getAllGroup = mysql_query("SELECT * FROM `db_sales_group` WHERE `group_name`!='' AND `dealer_id`='$dealID' ORDER BY `gid` ASC"); while($data=mysql_fetch_array($getAllGroup)){ $grpID=$data['gid']; $grpProspect = mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `group_id`='$grpID' AND `status`='open'"),0); $grpProspect=number_format($grpProspect,0,'',','); echo "<div class='dbCount' style='background:white;float:left;width:60%;height:40px;border:1px solid #fff;font-weight:bold;font-size:12px;padding:10px;text-align:right'> ".$data['group_name']." 👪</div> <div class='dbCount' style='background:white;float:left;width:40%;height:40px;border:1px solid #fff;font-weight:bold;font-size:12px;padding:10px;text-align:right'>".$grpProspect."</div> "; } ?> <?php $LeadCount = mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `status`='open'"),0); $LeadCount=number_format($LeadCount,0,'',','); $LeadCountCold = mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `cold_date`='' AND `hot_date` ='' AND `warm_date` ='' AND `status`='open' AND `comp_id`='$compID'"),0);//Actove $LeadCountWarm = mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `warm_date`!='' AND `hot_date` ='' AND `sales_approval` ='' AND `status`='open' AND `comp_id`='$compID'"),0); $LeadCounthot = mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `hot_date`!='' AND `win_date` ='' AND `sales_approval` ='' AND `status`='open' AND `comp_id`='$compID'"),0); $LeadCountApproval = mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `sales_approval`!='' AND `win_date` ='' AND `status`='open' AND `comp_id`='$compID'"),0); $LeadCountWin = mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `win_date`!='' AND `status`='closed' AND `comp_id`='$compID'"),0); $LeadCountLost = mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `lost_date`!='' AND `status`='closed' AND `comp_id`='$compID'"),0); $LeadCountCold=number_format($LeadCountCold,0,'',','); $LeadCountWarm=number_format($LeadCountWarm,0,'',','); $LeadCounthot=number_format($LeadCounthot,0,'',','); $LeadCountApproval=number_format($LeadCountApproval,0,'',','); $LeadCountWin=number_format($LeadCountWin,0,'',','); $LeadCountLost=number_format($LeadCountLost,0,'',','); ?> <div class='dbCount' style='padding:0px;background:#f5b041;height:40px;border:1px solid #fff;font-weight:normal;'> <a href="#" class="active" style='padding:8px;padding-left:5px;font-family:Verdana;font-size:16px;font-weight:normal;color:#000'>🏳 <u>Prospect By Status (<?php echo $LeadCount;?>)</a> </u> </div> <div style='background:#fff;float:left;width:60%;height:40px;border:1px solid #fff;font-weight:normal;font-size:16px;padding:10px;text-align:right;color:green'> Cold 📞</div> <div style='background:#fff;float:left;width:40%;height:40px;border:1px solid #fff;font-weight:normal;font-size:16px;padding:10px;text-align:right;color:green'><?php echo $LeadCountCold;?></div> <div style='background:#fff;float:left;width:60%;height:40px;border:1px solid #fff;font-weight:normal;font-size:16px;padding:10px;text-align:right;color:orange'>Active 🙋 </div> <div style='background:#fff;float:left;width:40%;height:40px;border:1px solid #fff;font-weight:normal;font-size:16px;padding:10px;text-align:right;color:orange'><?php echo $LeadCountWarm;?></div> <div style='background:#fff ;float:left;width:60%;height:40px;border:1px solid #fff;font-weight:normal;font-size:16px;padding:10px;text-align:right;color:red'> Demo 🎶</div> <div style='background:#fff;float:left;width:40%;height:40px;border:1px solid #fff;font-weight:normal;font-size:16px;padding:10px;text-align:right;color:red'><?php echo $LeadCounthot;?></div> <div style='background:#fff;float:left;width:60%;height:40px;border:1px solid #fff;font-weight:normal;font-size:16px;padding:10px;text-align:right;color:#e67e22'>Approval 📌 </div> <div style='background:#fff;float:left;width:40%;height:40px;border:1px solid #fff;font-weight:normal;font-size:16px;padding:10px;text-align:right;color:#e67e22'><?php echo $LeadCountApproval;?></div> <div style='background:#fff;float:left;width:60%;height:40px;border:1px solid #fff;font-weight:normal;font-size:16px;padding:10px;text-align:right;color:blue'> Win🏅</div> <div style='background:#fff;float:left;width:40%;height:40px;border:1px solid #fff;font-weight:normal;font-size:16px;padding:10px;text-align:right;color:blue'><?php echo $LeadCountWin;?></div> <div style='background:#fff;float:left;width:60%;height:40px;border:1px solid #fff;font-weight:normal;font-size:16px;padding:10px;text-align:right;color: #7d3c98 '>Lost 🔂 </div> <div style='background:#fff;float:left;width:40%;height:40px;border:1px solid #fff;font-weight:normal;font-size:16px;padding:10px;text-align:right;color: #7d3c98 '><?php echo $LeadCountLost;?></div> </div> </div> </div> </div>

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