File manager

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

Back
<?php ob_start(); include 'core/init.php'; $ASAADM = $user_data['ASA_ADM']; $ASAMKTG = $user_data['ASA_MKTG']; $ASAFNI = $user_data['ASA_FNI']; $ITADM = $user_data['IT_ADM']; protected_page(); //echo $user_data['u_id']; //break; //https://www.allphptricks.com/demo/ //https://html-css-js.com/html/character-codes/icons/ //https://philippinescities.com/region-13-caraga-region/ RIGION AND CITIES WEBSITE REFERENCE $userID=$user_data['u_id']; $userFName=$user_data['u_fname']; $myCurTime=$currentTime; $dealID= $user_data['dealer']; $compID= $user_data['company']; $accType =$user_data['account_type']; $getBookingCount = 0;//mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `booking_confirmed`='no'"),0); $comID=$user_data['company']; if(isset($_GET['company'])){ $comName=$_GET['company'];//mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$comID'"),0); }else{ $comName = mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$comID'"),0); } echo "<input type='hidden' id='activeBrand'>"; echo "<input type='hidden' id='MyCompName'>"; echo " <input type='hidden' id='UserCompanyName' value='".$comName."'>"; echo " <input type='hidden' id='UserCompanyID' value='".$compID."'>"; echo "<input type='hidden' id='MyUserID' value='".$userID."'>"; echo "<input type='hidden' id='MyUserFName' value='".$userFName."'>"; //$comName=mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$comID'"),0); $userBrand=mysql_result(mysql_query("SELECT `brand` FROM `vts_company` WHERE `comp_code`='$comName'"),0); $BrandID=mysql_result(mysql_query("SELECT `b_id` FROM `vts_brands` WHERE `b_name`='$userBrand'"),0); $_SESSION["ActiveID"]=$userID; //echo ($_SESSION[ActiveID]); if($accType !='Admin' && $accType !='Super Admin'){ Header("Location:user_Portal.php?id=$userID"); } //echo "Arnel ".$myCurTime; //count all new bookings $getBookingCount = 0;//mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `booking_confirmed`='no'"),0); ?> <!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link rel="stylesheet" href="css/style_menu.css"> <link rel="stylesheet" href="css/style.css"> <!--- LOCALIZED COPY OF JAVASCRIPT --> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script src="https://code.jquery.com/jquery-3.2.1.min.js"></script> <!--- LOCALIZED COPY OF JAVASCRIPT --> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script type="text/javascript"> $(function () { $('.showMenu').click(function () { $('.DivToHide').show(); }); $('.showMenu').click(function () { $('.DivToHide').hide(); }); }); </script> <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:47%;padding:2px;z-index:999999999999999999"> <img src='images/ajaxLoader2.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"> $(document).ready(function(){ $(document).ajaxStart(function(){ $("#wait").css("display", "block"); }); $(document).ajaxComplete(function(){ $("#wait").css("display", "none"); }); //=================================== function showInventory(row) { var x=row.cells; var selCompany = x[0].innerHTML; //alert(selCompany); //return false; //load_vehicle_inventory_on_click $.ajax({ url: "load_vehicle_inventory_on_click.php", type: "POST", async: false, data: { "selCompany": selCompany }, success: function(d){ $("#viewInventory").html(d); //alert("success"); } }); } //==================================== //END OF SEARCH CODE $("#goSearch").click(function(){ //alert("test"); //return false; var bBrand = $("#bBrand").val(); var searchText = $("#searchText").val(); var sDeal = $("#sDeal").val(); var sComp = $("#sComp").val(); if (searchText == "") { $('#searchText').focus(); $('#searchText').css({'border-bottom':'1px solid red'}); $('#searchText').css({'color':'red'}); $('#searchText').attr("placeholder","Type something here (Cs No# / Unit Descriptoin"); return false; } showLoadBar(); $.ajax({ url: "filter_model.php", type: "POST", async: false, data: { "searchText":searchText, "bBrand":bBrand, "sDeal": sDeal, "sComp": sComp, "searchDisplay": 1 }, success: function(d){ //invShowAssignMsg(); $("#viewInventoryPerModel").html(d); //invHideAssignMsg(); $('#searchText').val(''); showLoadBar(); } }) }); //==================================== $("#LoadDashBoardByCompany").click(function(){ //alert("test"); //return false; unit_reservation.php var MyUserID= $("#MyUserID").val(); var brandName = $("#activeBrand").val(); var UserCompanyName = $("#UserCompanyName").val(); //alert(UserCompanyName); //return false; $.ajax({ url: "dashboard_brand.php", type: "POST", async: false, data: { "MyUserID": MyUserID, "brandName": brandName, "UserCompanyName": UserCompanyName, "Display": 1 }, success: function(d){ //invShowAssignMsg(); $("#mainBody").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //==================================== $("#myDashboard").click(function(){ //alert("test"); //return false; unit_reservation.php var MyUserID= $("#MyUserID").val(); var loadPriceList = $("#loadPriceList").val(); var brandName = $("#MyCompName").val(); var UserCompanyName = $("#UserCompanyName").val(); //alert(loadPriceList); //return false; $.ajax({ url: "dashboard.php", type: "POST", async: false, data: { "MyUserID": MyUserID, "brandName": brandName, "UserCompanyName": UserCompanyName, "Display": 1 }, success: function(d){ //invShowAssignMsg(); $("#mainBody").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //==================================== $("#vSetup").click(function(){ //alert("test"); //return false; unit_reservation.php var MyUserID= $("#MyUserID").val(); var loadPriceList = $("#loadPriceList").val(); var brandName = $("#MyCompName").val(); //alert(loadPriceList); //return false; $.ajax({ url: "vehicle_setup.php", type: "POST", async: false, data: { "MyUserID": MyUserID, "brandName": brandName, "Display": 1 }, success: function(d){ //invShowAssignMsg(); $("#mainBody").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //==================================== $("#LoadPromoTable").click(function(){ //alert("test"); //return false; unit_reservation.php var MyUserID= $("#MyUserID").val(); var loadPriceList = $("#loadPriceList").val(); var brandName = $("#MyCompName").val(); //alert(loadPriceList); //return false; $.ajax({ url: "unit_promo_setup.php", type: "POST", async: false, data: { "MyUserID": MyUserID, "brandName": brandName, "Display": 1 }, success: function(d){ //invShowAssignMsg(); $("#mainBody").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //===================================== $("#loadReservation").click(function(){ var MyUserID= $("#MyUserID").val(); var UserCompanyName = $("#UserCompanyName").val(); var UserCompanyID = $("#UserCompanyID").val(); var brandName = $("#MyCompName").val(); //alert(loadPriceList); //return false; $.ajax({ url: "unit_reservation.php", type: "POST", async: false, data: { "MyUserID": MyUserID, "UserCompanyName":UserCompanyName, "UserCompanyID":UserCompanyID, "brandName": brandName, "Display": 1 }, success: function(d){ //invShowAssignMsg(); $("#mainBody").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //===================================== $("#loadPriceList").click(function(){ //alert("test"); //return false; var UserCompanyName = $("#UserCompanyName").val(); var MyUserID= $("#MyUserID").val(); var loadPriceList = $("#loadPriceList").val(); var brandName = $("#MyCompName").val(); var MyUserFName = $("#MyUserFName").val(); //alert(MyUserFName); //return false; $.ajax({ url: "price_list_view.php", type: "POST", async: false, data: { "MyUserID": MyUserID, "UserCompanyName": UserCompanyName, "brandName": brandName, "MyUserFName": MyUserFName, "Display": 1 }, success: function(d){ //invShowAssignMsg(); $("#mainBody").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //===================================== $("#loadFinancingPromo").click(function(){ //alert("test"); //return false; var UserCompanyName = $("#UserCompanyName").val(); var MyUserID= $("#MyUserID").val(); var loadPriceList = $("#loadPriceList").val(); var brandName = $("#MyCompName").val(); var MyUserFName = $("#MyUserFName").val(); //alert(MyUserFName); //return false; $.ajax({ url: "financing_and_insurance_promo.php", type: "POST", async: false, data: { "MyUserID": MyUserID, "UserCompanyName": UserCompanyName, "brandName": brandName, "MyUserFName": MyUserFName, "Display": 1 }, success: function(d){ //invShowAssignMsg(); $("#mainBody").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); }); function showSelectedBrand(row) { var x=row.cells; document.getElementById("activeBrand").value = x[0].innerHTML; } function ShowCompanyValue(row) { var x=row.cells; document.getElementById("MyCompName").value = x[0].innerHTML; } function showLoadBar() { var div = document.getElementById("loadBaraData"); if (div.style.display == 'none') { div.style.display = ''; } else { div.style.display = 'none' } } </script> <style> .topBG{ background: -webkit-linear-gradient(left top, #f96409, #f99e09 , #fad497); /* For Safari 5.1 to 6.0 / background: -o-linear-gradient(bottom right, #f96409,#f99e09, #fad497 ); / For Opera 11.1 to 12.0 / background: -moz-linear-gradient(bottom top, #f96409,#f99e09, #fad497 ); / For Firefox 3.6 to 15 / background: linear-gradient(to bottom right, #f96409,#f99e09, #fad497 ); / Standard syntax / font-weight:bold; color:black; } .bgColor{ background: -webkit-linear-gradient(left top,#ff8430, #f9cc5f,#fff ); / For Safari 5.1 to 6.0 / background: -o-linear-gradient(bottom right, #ff8430, #f9cc5f,#fff); / For Opera 11.1 to 12.0 / background: -moz-linear-gradient(bottom top, #ff8430, #f9cc5f,#fff); / For Firefox 3.6 to 15 / background: linear-gradient(to bottom right, #ff8430, #f9cc5f,#fff ); / Standard syntax / } .addBrandLink{ display:block; padding:10px; padding-left:15px; padding-right:15px; margin:10px; border:1px solid #0ca7f4; margin-left:0px; margin-right:0px; background:#1cd9fe; font-family:Arial; font-size:14px; font-weight:normal; } .addBrandLink:hover{ display:block; padding:10px; padding-left:15px; padding-right:15px; margin:10px; border:1px solid #fa824f ; margin-left:0px; margin-right:0px; background:#f7e581; font-family:Arial; font-size:14px; font-weight:bold; } .bodyMenu{ float:left; width:55%; border:0px solid red; } .bodyTitle{ float:left; width:40%; border:0px solid red; padding:10px; display:block; } .myDashBoard{ display:block; float:left; width:20%; height:auto; border:0px solid gray; background:white; border-right:1px solid gray; } .myBody{ display:block; float:left; width:80%; height:900px; min-width:400px; border:0px solid gray; background:white; padding:10px; } .fHeaderA{ float:left; width:30%; min-width:200px; border:0px solid red; } .fHeaderB{ float:left; width:70%; min-width:200px; border:0px solid red; } .GradientOrange{ background: -webkit-linear-gradient(left top, #fb8b1b, #fea64f , #fbc337 ); / For Safari 5.1 to 6.0 / background: -o-linear-gradient(bottom right, #fb8b1b,#fea64f, #fbc337 ); / For Opera 11.1 to 12.0 / background: -moz-linear-gradient(bottom top, #fb8b1b,#fea64f, #fbc337 ); / For Firefox 3.6 to 15 / background: linear-gradient(to bottom right, #fb8b1b,#fea64f, #fbc337 ); / Standard syntax / } <!--END OF DROP DOWN VERTICAL MEN----> .vertical-menu { width: 250px; background-color: #e0f5fa ; } .vertical-menu a { background-color: #e0f5fa ; color: black; display: block; padding: 12px; text-decoration: none; } a{ text-decoration:none; } .vertical-menu a:hover { background-color: yellow ; } .vertical-menu a.active { background: -webkit-linear-gradient(left top, #e5f7fc, #95e5fa, #e5f7fc ); / For Safari 5.1 to 6.0 / background: -o-linear-gradient(bottom right, #e5f7fc,#95e5fa,#e5f7fc); / For Opera 11.1 to 12.0 / background: -moz-linear-gradient(bottom top, #e5f7fc,#95e5fa,#e5f7fc); / For Firefox 3.6 to 15 / background: linear-gradient(to bottom right, #e5f7fc,#95e5fa,#e5f7fc); / Standard syntax / color: red; } { box-sizing: border-box; } .newsFeed{ width:25%; background:white; border:0px solid white; border-right:1px solid #f4f6f6 ; padding-top:20px; } .menu { float:left; width:20%; min-width:200px; text-align:left; border:0px solid red; top-margin:2px; } .menu a { background-color:#e0f5fa ; padding:1px; margin-top:1px; display:block; width:100%; color:black; } .main { float:left; width:80%; padding:0 20px; min-width:400px; } .addCustForm{ width:70%; } .right { background-color:#e5e5e5; float:left; width:20%; padding:1px; margin-top:1px; text-align:center; } .DIVBox{ font-family:Arial; background: -webkit-linear-gradient(left top, #d2fbf3,#f0f0dd, #f0f0dd ); /* For Safari 5.1 to 6.0 / background: -o-linear-gradient(bottom right, #d2fbf3,#f0f0dd ,#f0f0dd); / For Opera 11.1 to 12.0 / background: -moz-linear-gradient(bottom top, #d2fbf3,#f0f0dd,#f0f0dd); / For Firefox 3.6 to 15 / background: linear-gradient(to bottom right, #d2fbf3,#f0f0dd,#f0f0dd); / Standard syntax / font-size:12px; color:black; border:0px solid orange; width:22%; height:10%; min-width:250px; min-height:150px; float:left; margin:1%; } .DIVBox:hover{ font-family:Arial; background: -webkit-linear-gradient(left top, #fdfdac ,#f0f0dd,#f0f0dd ); background: -o-linear-gradient(bottom right, #fdfdac,#fdfdac,#f0f0dd); background: -moz-linear-gradient(bottom top, #fdfdac,#fdfdac,#f0f0dd); background: linear-gradient(to bottom right, #fdfdac,#fdfdac,#f0f0dd); font-size:12px; color:black; border:1px solid red; width:22%; height:10%; min-width:250px; min-height:150px; float:left; margin:1%; } .pageMenuA{ width:40%; float:left; margin:5px; border:0px solid blue; } .pageMenuB{ width:50%; float:right; margin:5px; border:0px solid blue; } @media only screen and (max-width:900px) { .DIVBox{ width:28%; margin:2%; } .DIVBox:hover{ width:28%; margin:2%; } } @media only screen and (max-width:800px) { .DIVBox{ width:46%; margin:2%; } .DIVBox:hover{ width:46%; margin:2%; } .pageMenuA{ width:100%; float:left; margin:5px; border:0px solid blue; } .pageMenuB{ width:100%; float:right; margin:5px; border:0px solid blue; } } @media only screen and (max-width:630px) { / For mobile phones: / .menu, .main, .right { width:100%; } .bDashboard{ width:100% !important; } .addCustForm{ width:100% !important; } .newsFeed{ width:100% !important; } .menu{ display:none !important; } .subBody{ width:100% !important; } .vertical-menuA a.active { color: red; } .DIVBox{ width:94%; margin:2%; } .DIVBox:hover{ width:94%; margin:2%; } .vertical-menuB a.active { background: -webkit-linear-gradient(left top, #dbe0dc ,#ccd3cd, #f7f5f7); / For Safari 5.1 to 6.0 / background: -o-linear-gradient(bottom right, #dbe0dc,#ccd3cd,#f7f5f7); / For Opera 11.1 to 12.0 / background: -moz-linear-gradient(bottom top, #dbe0dc,#ccd3cd,#f7f5f7); / For Firefox 3.6 to 15 / color: red; } .fHeaderA{ float:left; width:100%; min-width:200px; border:0px solid red; } .fHeaderB{ display:none; float:left; width:100%; min-width:200px; border:0px solid red; } .myDashBoard{ display:none; float:left; width:100%; min-width:200px; border:1px solid red; } .myBody{ display:block; float:left; width:100%; min-width:200px; border:0px solid red; } .bodyTitle{ float:left; width:40%; border:0px solid red; padding:10px; display:none; } .bodyMenu{ float:left; width:100%; border:0px solid red; } .pageMenuA{ width:100%; float:left; margin:5px; border:0px solid blue; } .pageMenuB{ width:100%; float:right; margin:5px; border:0px solid blue; } } .headerDiv{ background-image: url(./images/log_bg.jpg); background-size: cover; background-repeat: no-repeat; background-position: center center; position: fixed; top: 0; left: 0; padding:5px; z-index: 999; height: 80px; width: 100%; } <!-- NEW SET OF VERTICAL MENU CSS --> </style> </head> <body style="font-family:Verdana;color:#aaaaaa;background:white"> <div id="loadBaraData" style="display:none;position:absolute;top:60%;left:40%;width:20%;padding:5px;padding-left:2px;padding-right:2px;height:80px;background:transparent;z-index:9999;border:0px solid gray;z-index:999999999999999999"> <div id="uploadBar" style="font-family:Calibri;font-size:14px;color:red;text-align:center;margin-top:0px;background:white;display:block;width:100%;height:50px;border:0px solid red;position:relative;left:5px;padding:5px;z-index:999999999999999999;border:1px solid orange"> <img src='images/ajaxLoader.gif' width="100%" height="20px" /><br><center>Loading...<center></div> </div> <div class='topMenu' style="margin:0px;padding:0px; text-align:left;"> <div class="headerDiv"> <div class="fHeaderA">.</div> <div class="fHeaderB"> <?php echo "<p style='padding:10px;font-family:Arial;font-size:14px;color:black;float:right;background: #faa84a ;border-radius:20px;opacity:.9'>🔐: ".strtoupper($accType)."      \|     👩 User: ".strtoupper($user_data['u_name'])."      \|     🏪 Company: ".$comName."     \|     <a href='logout.php'>&#10060 Logout</a></p>";?></div> </div><br> <div style='height:65px;width;30%;padding:5px;'> </div> <div id="anchor" style='border:2px solid black;padding:0px;text-align:right;padding-right:0px;background:black'> <!-- START OF MENU CODE --> <div class="topnav" id="myTopnav"> <a href="connect.php" class="active" style="font-family:Calibri;font-size:16px;padding:12px;font-weight:bold;padding-right:30px;padding-right:80px">⇚     HOME</a> <div class="dropdown"> <button class="dropbtn">☖ VEHICLE INVENTORY <i class="fa fa-caret-down"></i> </button> <div class="dropdown-content"> <!-- <a href="autohub.php?id=vs&d=vs">✩ Brand</a> <a href="autohub.php?id=ml&d=vs">✩ Model</a> <a href="autohub.php?id=cl&d=vs">✩ Color</a> --> <?php if($ASAADM == 1){ echo "<a href='autohub.php?id=v&d=i'>✩ Vehicle Inventory</a>"; echo "<a href='autohub.php?id=s&d=p'>✩ Price Setup</a>"; echo "<a href='autohub.php?id=price&d=price'>✩ Price List</a>"; echo "<a href='autohub.php?id=x&d=x&u='".$userID."'&c='".$compID."'>✩ Reservation Request</a>"; }else{ echo "<a href='#' style='font-family:Arial;font-size:14px;color:gray;cursor:default'>✩ Vehicle Inventory</a>"; echo "<a href='#' style='font-family:Arial;font-size:14px;color:gray;cursor:default'>✩ Price Setup</a>"; echo "<a href='#' style='font-family:Arial;font-size:14px;color:gray;cursor:default'>✩ Price List</a>"; echo "<a href='#' style='font-family:Arial;font-size:14px;color:gray;cursor:default'>✩ Reservation Request</a>"; } if($ASAMKTG == 1){ echo "<a href='autohub.php?id=promo&d=promo'>✩ Promos & Discounts</a>"; }else{ echo "<a href='#' style='font-family:Arial;font-size:14px;color:gray;cursor:default'>✩ Promos & Discounts</a>"; } if($ASAFNI ==1 ){ echo "<a href='autohub.php?id=finance&d=finance'>✩ Financing Promo</a>"; }else{ echo "<a href='#' style='font-family:Arial;font-size:14px;color:gray;cursor:default'>✩ Financing Promo</a>"; } ?> </div> </div> <!-- <div class="dropdown"> <button class="dropbtn">☖ CLEARANCE FORM <i class="fa fa-caret-down"></i> </button> <div class="dropdown-content"> <!-- <a href="autohub.php?id=vs&d=vs">✩ Brand</a> <a href="autohub.php?id=ml&d=vs">✩ Model</a> <a href="autohub.php?id=cl&d=vs">✩ Color</a> <a href="autohub.php?id=c&d=c">✩ Clearance Form</a> </div> </div> --> <div class="dropdown"> <button class="dropbtn">☻ SYSTEM SETUP <i class="fa fa-caret-down"></i> </button> <div class="dropdown-content"> <?php if($ITADM ==1){ echo "<a href='autohub.php?id=14&d=x'>✩ ADD NEW COMPANY</a> <a href='autohub.php?id=13&d=x'>✩ ADD NEW DEALERSHIP</a> "; }else{ echo "<a href='#' style='font-family:Arial;font-size:14px;color:gray;cursor:default'>✩ ADD NEW COMPANY</a> <a href='#' style='font-family:Arial;font-size:14px;color:gray;cursor:default'>✩ ADD NEW DEALERSHIP</a> "; } if($ASAADM == 1){ echo "<a href='autohub.php?id=vsat&d=vsat'>✩ VEHICLE SETUP</a>"; echo "<a href='autohub.php?id=ac&d=ac'>✩ ACTIVATE ACCOUNT</a>"; echo "<a href='autohub.php?id=dr&d=ac'>✩ TELEPHONE DIRECTORY</a>"; echo "<a href='autohub.php?id=loc&d=i'>✩ ADD LOCATION</a>"; }else{ echo "<a href='#' style='font-family:Arial;font-size:14px;color:gray;cursor:default'>✩ VEHICLE SETUP</a>"; echo "<a href='#' style='font-family:Arial;font-size:14px;color:gray;cursor:default'>✩ ACTIVATE ACCOUNT</a>"; echo "<a href='#' style='font-family:Arial;font-size:14px;color:gray;cursor:default'>✩ TELEPHONE DIRECTORY</a>"; echo "<a href='#' style='font-family:Arial;font-size:14px;color:gray;cursor:default'>✩ ADD LOCATION</a>"; } ?> </div> </div> <div class="" style="background:orange;"> <a href="autohub.php?id=rpt&d=rpt">🖬 REPORTS</a> </div> <div class="" style="background:orange;"> <a href="autohub.php?id=das&d=das">📊 CHART</a> </div> </div> <script> function myFunction() { var x = document.getElementById("myTopnav"); if (x.className === "topnav") { x.className += " responsive"; } else { x.className = "topnav"; } } </script> <!-- END OF MENU CODE --> </div> <div style="width:100%;float:left;height:100%;text-align:center;border-top:1px solid #9ea5a5;padding:1px;text-align:center;padding-top:0px;color:red;background:#ffffff"> <div class="myDashBoard"> <div style="width:100%;height:900px;border:0px solid red;border:0px solid white;overflow:auto;float:left"> <?php $getD=$_GET['d']; switch($getD){ //===============================================================//=============================================================== //===============================================================//=============================================================== case 'p': echo "<div class='bgColor' style='text-align:left;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'>VEHICLE PRICE SETUP <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='autohub.php?id=a&d=a' onclick='showAddNewProspect()' style='font-weight:bold'> ✕ </a> </div> </div>"; $getComp = mysql_query("SELECT DISTINCT(brand_name) FROM `brand_access` WHERE `user_id`='$userID' ORDER BY `brand_name` ASC "); echo "<table id='priceSetup' style='border-collapse:collapse;width:100%'>"; while($row=mysql_fetch_array($getComp)){ $resUnit = mysql_result(mysql_query("SELECT COUNT('req_id') FROM `db_sc_request` WHERE `brand_name`='".$row['brand_name']."'"),0); ?><tr onDblclick="javascript:ShowPriceSetup(this);"><?php echo "<td style='width:100%;;padding:10px;text-align:left;font-family:Arial;font-weight:bold;font-size:14px;color:blue'> ".$row['brand_name']; echo "<div>"; $bid = mysql_result(mysql_query("SELECT `b_id` FROM `vts_brands` WHERE `b_name`='".$row['brand_name']."'"),0); $getCompX = mysql_query("SELECT FROM `vts_model` WHERE `b_id`='$bid' ORDER BY `m_name` ASC "); echo "<table style='border-collapse:collapse;width:100%'>"; while($row=mysql_fetch_array($getCompX)){ echo "<tr>"; echo "<td style='background:white;padding-left:10px;width:100%;text-align:left;padding-left:30px'> <a href='autohub.php?id=s&d=p&model=".$row['m_name']."' style='display:block;width:100%;padding:5px;'>: ".$row['m_name']."</a></td>"; echo "</tr>"; } echo "</table>"; echo "</div>"; echo "</td>"; echo "</tr>"; } echo "</table>"; break; //===============================================================//=============================================================== //===============================================================//=============================================================== case 'c': echo "<div class='bgColor' style='text-align:left;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'>CLEARANCE DASHBOARD <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='autohub.php?id=a&d=a' onclick='showAddNewProspect()' style='font-weight:bold'> ✕ </a> </div> </div>"; $getComp = mysql_query("SELECT * FROM `vts_company` WHERE `comp_status`='1' ORDER BY `comp_name` ASC "); echo "<table style='border-collapse:collapse;width:100%'>"; echo "<thead>"; echo "<th class='tBalls' style='width:70%'>COMPANY</th>"; echo "<th class='tBalls' style='width:30%'>OPEN</th>"; echo "</thead>"; while($row=mysql_fetch_array($getComp)){ echo "<tr>"; echo "<td style='width:70%'>".$row['comp_code']."</td>"; echo "<td style='width:30%'>"; echo"</td>"; echo "</tr>"; } echo "</table>"; break; //===============================================================//=============================================================== //===============================================================//=============================================================== case 'i': $count=0; echo "<div class='bgColor' style='text-align:left;vertical-align:top;height:35px;margin:0px;width:100%;border-bottom:1px solid gray;padding:6px;font-family:Verdana;font-weight:normal;font-size:18px;color:#043062'>GRANTED ACCESSX <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='autohub.php?id=a&d=a' onclick='showAddNewProspect()' style='font-weight:bold'> ✕ </a> </div> </div>"; //$getComp = mysql_query("SELECT * FROM `vts_brands` WHERE `group_brand`='Yes' AND `b_name`='$userBrand' ORDER BY `b_name` ASC "); $getComp = mysql_query("SELECT DISTINCT(comp_id) FROM `brand_access` WHERE `user_id`='$userID' AND `comp_id`!=0"); echo "<table style='border-collapse:collapse;width:100%;margin:0px'>"; echo "<thead>"; echo "<th class='tBalls' style='width:70%;border:0px;font-family:Arial;font-size:16px;font-weight:bold;background:#a1e894'>VEHICLE INVENTORY </th>"; echo "</thead>"; while($row=mysql_fetch_array($getComp)){ $myCompany = $row['comp_id']; //echo $myCompany."<br>"; $getXComp = mysql_query("SELECT * FROM `vts_company` WHERE `comp_id`='$myCompany'"); while($xRow=mysql_fetch_array($getXComp)){ $compID = $xRow['comp_id']; $compName =$xRow['comp_code'];// mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$compID'"),0); $brand = mysql_result(mysql_query("SELECT `brand` FROM `vts_company` WHERE `comp_code`='$compName'"),0); $chkAccess = mysql_result(mysql_query("SELECT COUNT(id) FROM `brand_access` WHERE `user_id`='$userID' AND `comp_id`='$compID'"),0); if($chkAccess != 0){ ?><tr onclick="javascript:showInventory(this);"><?php echo "<td style='width:70%;text-align:left;;font-family:Arial;font-size:14px;font-weight:normal;border:0px'><a href='autohub.php?id=v&d=i&comp=".$brand."&company=".$compName."' style='display:block;padding:3px;'>".$compName."</a></td>"; //echo "<td style='width:30%'><a href='autohub.php?id=v&d=i&comp=".$row['b_name']."' style='display:block;padding:3px;'>".$getTotalAvail."</td>"; echo "</tr>"; } } } echo "</table>"; echo "<br><br>"; $selectedBrand=$_GET['company']; $compID = mysql_result(mysql_query("SELECT `comp_id` FROM `vts_company` WHERE `comp_code`LIKE '%$selectedBrand%'"),0); $getDeal = mysql_query("SELECT * FROM `brand_access` WHERE `user_id`='$userID' AND `comp_id`='$compID'"); echo "<table style='border-collapse:collapse;width:100%;margin:0px'>"; echo "<thead>"; echo "<th class='tBalls' style='width:70%;border:0px;font-family:Arial;font-size:16px;font-weight:bold;background:#a1e894'>DEALERSHIPS:</th>"; echo "</thead>"; while($row=mysql_fetch_array($getDeal)){ $MyCompID = $row['comp_id']; $dealID = $row['dealer_id']; //echo $dealID; $compName = mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$MyCompID'"),0); $dealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$dealID'"),0); $dealCode = mysql_result(mysql_query("SELECT `deal_code` FROM `vts_dealerships` WHERE `deal_id`='$dealID'"),0); if($dealName !=''){ $count = $count + 1; } //echo $dealID; if($count < 1){ echo "<tr> <td style='width:90%;text-align:center;;font-family:Arial;font-size:14px;font-weight:normal;border:0px;background:#fceeae'>Sorry, you do not have access to any of the dealerships under ".$compName.". <br><br>Please contact your system Administrator of Assistance.</td>"; echo "</tr>"; }else{ echo "<tr> <td style='width:90%;text-align:left;;font-family:Arial;font-size:14px;font-weight:normal;border:0px'><a href='autohub.php?id=v&d=i&comp=".$row['brand_name']."&deal=".$dealCode."&company=".$compName."' style='display:block;padding:3px;'>".$dealName."</a></td>"; echo "</tr>"; } } echo "</table>"; break; //===============================================================//=============================================================== //===============================================================//=============================================================== case 'promo': echo "<div class='bgColor' style='text-align:left;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'>DASHBOARD <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='autohub.php?id=a&d=a' onclick='showAddNewProspect()' style='font-weight:bold'> ✕ </a> </div> </div>"; $getComp = mysql_query("SELECT DISTINCT(brand_name),comp_id FROM `brand_access` WHERE `user_id`='$userID' ORDER BY `brand_name` ASC "); echo "<table id='LoadPromoTable' style='border-collapse:collapse;width:100%'>"; echo "<thead>"; echo "<th class='tBalls' style='width:100%;font-family:Arial;font-size:16px;font-weight:bold'>PROMOS AND DISCOUNTS</th>"; //echo "<th class='tBalls' style='width:30%'>STOCKS</th>"; echo "</thead>"; $pBrand = ""; while($row=mysql_fetch_array($getComp)){ $brand = $row['brand_name']; if($pBrand == $brand){ }else{ $getTotalAvail = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `sold` = 0 AND `returned` = 0 AND `tagged` = 0 AND `brand`='$brand'"),0); ?><tr onclick="javascript:ShowCompanyValue(this);"><?php echo "<td style='width:100%;text-align:left;padding-left:30px'>".$row['brand_name']."</a></td>"; //echo "<td style='width:30%'><a href='autohub.php?id=promo&d=promo&comp=".$row['b_name']."' style='display:block;padding:3px;'>".$getTotalAvail."</td>"; echo "</tr>"; } $pBrand=$brand; } echo "</table>"; break; //===============================================================//=============================================================== //===============================================================//=============================================================== case 'vsat': echo "<div class='bgColor' style='text-align:left;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'>VEHICLE SETUP <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='autohub.php?id=a&d=a' onclick='showAddNewProspect()' style='font-weight:bold'> ✕ </a> </div> </div>"; $getComp = mysql_query("SELECT DISTINCT(brand_name),comp_id FROM `brand_access` WHERE `user_id`='$userID' ORDER BY `brand_name` ASC "); echo "<table id='vSetup' style='border-collapse:collapse;width:100%'>"; echo "<thead>"; echo "<th class='tBalls' style='width:100%;font-family:Arial;font-size:16px;font-weight:bold'>BRANDS</th>"; //echo "<th class='tBalls' style='width:30%'>STOCKS</th>"; echo "</thead>"; $pBrand = ""; while($row=mysql_fetch_array($getComp)){ $brand = $row['brand_name']; if($pBrand == $brand){ }else{ $getTotalAvail = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `sold` = 0 AND `returned` = 0 AND `tagged` = 0 AND `brand`='$brand'"),0); ?><tr onclick="javascript:ShowCompanyValue(this);"><?php echo "<td style='width:100%;text-align:left;padding-left:30px'>".$row['brand_name']."</a></td>"; //echo "<td style='width:30%'><a href='autohub.php?id=promo&d=promo&comp=".$row['b_name']."' style='display:block;padding:3px;'>".$getTotalAvail."</td>"; echo "</tr>"; } $pBrand=$brand; } echo "</table>"; break; //===============================================================//=============================================================== //===============================================================//=============================================================== case 'finance': echo "<div class='bgColor' style='text-align:left;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'>DASHBOARD <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='autohub.php?id=a&d=a' onclick='showAddNewProspect()' style='font-weight:bold'> ✕ </a> </div> </div>"; $getComp = mysql_query("SELECT DISTINCT(brand_name),comp_id FROM `brand_access` WHERE `user_id`='$userID' ORDER BY `brand_name` ASC "); echo "<table id='loadFinancingPromo' style='border-collapse:collapse;width:100%'>"; echo "<thead>"; echo "<th class='tBalls' style='width:100%;font-family:Arial;font-size:16px;font-weight:bold'>FINANCING PROMO</th>"; //echo "<th class='tBalls' style='width:30%'>STOCKS</th>"; echo "</thead>"; $pBrand = ""; while($row=mysql_fetch_array($getComp)){ $brand = $row['brand_name']; if($pBrand == $brand){ }else{ $getTotalAvail = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `sold` = 0 AND `returned` = 0 AND `tagged` = 0 AND `brand`='$brand'"),0); ?><tr onclick="javascript:ShowCompanyValue(this);"><?php echo "<td style='width:100%;text-align:left;padding-left:30px'>".$row['brand_name']."</td>"; //echo "<td style='width:30%'><a href='autohub.php?id=promo&d=promo&comp=".$row['b_name']."' style='display:block;padding:3px;'>".$getTotalAvail."</td>"; echo "</tr>"; } $pBrand=$brand; } echo "</table>"; break; //===============================================================//=============================================================== //===============================================================//=============================================================== case 'price': echo "<div class='bgColor' style='text-align:left;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'>DASHBOARD <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='autohub.php?id=a&d=a' onclick='showAddNewProspect()' style='font-weight:bold'> ✕ </a> </div> </div>"; $getComp = mysql_query("SELECT DISTINCT(brand_name),comp_id FROM `brand_access` WHERE `user_id`='$userID' ORDER BY `brand_name` ASC "); echo "<table id='loadPriceList' style='border-collapse:collapse;width:100%'>"; echo "<thead>"; echo "<th class='tBalls' style='width:100%;font-family:Arial;font-size:16px;font-weight:bold'>VEHICLE PRICELIST </th>"; //echo "<th class='tBalls' style='width:30%'>STOCKS</th>"; echo "</thead>"; $pBrand = ""; while($row=mysql_fetch_array($getComp)){ $brand = $row['brand_name']; if($pBrand == $brand){ }else{ $getTotalAvail = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `sold` = 0 AND `returned` = 0 AND `tagged` = 0 AND `brand`='$brand'"),0); ?><tr onclick="javascript:ShowCompanyValue(this);"><?php echo "<td style='width:100%;text-align:left;padding-left:30px;cursor:pointer'>".$row['brand_name']."</td>"; //echo "<td style='width:30%'><a href='autohub.php?id=promo&d=promo&comp=".$row['b_name']."' style='display:block;padding:3px;'>".$getTotalAvail."</td>"; echo "</tr>"; } $pBrand=$brand; } echo "</table>"; break; //===============================================================//=============================================================== //===============================================================//=============================================================== case 'x': echo "<div class='bgColor' style='text-align:left;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'>DASHBOARD <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='autohub.php?id=a&d=a' onclick='showAddNewProspect()' style='font-weight:bold'> ✕ </a> </div> </div>"; $getComp = mysql_query("SELECT DISTINCT(brand_name),comp_id FROM `brand_access` WHERE `user_id`='$userID' ORDER BY `brand_name` ASC "); echo "<table id='loadReservation' style='border-collapse:collapse;width:100%'>"; echo "<thead>"; echo "<th class='tBalls' style='width:100%;font-family:Arial;font-size:16px;font-weight:bold'>Reservation Summary</th>"; //echo "<th class='tBalls' style='width:30%'>STOCKS</th>"; echo "</thead>"; $pBrand = ""; while($row=mysql_fetch_array($getComp)){ $brand = $row['brand_name']; if($pBrand == $brand){ }else{ $getTotalAvail = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `sold` = 0 AND `returned` = 0 AND `tagged` = 0 AND `brand`='$brand'"),0); ?><tr onclick="javascript:ShowCompanyValue(this);"><?php echo "<td style='width:100%;text-align:left;padding-left:30px'>".$row['brand_name']."</td>"; //echo "<td style='width:30%'><a href='autohub.php?id=promo&d=promo&comp=".$row['b_name']."' style='display:block;padding:3px;'>".$getTotalAvail."</td>"; echo "</tr>"; } $pBrand=$brand; } echo "</table>"; break; //===============================================================//=============================================================== //===============================================================//=============================================================== case 'das': echo "<div class='bgColor' style='text-align:left;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'>DASHBOARD <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='autohub.php?id=a&d=a' onclick='showAddNewProspect()' style='font-weight:bold'> ✕ </a> </div> </div>"; //$getComp = mysql_query("SELECT * FROM `vts_brands` WHERE `group_brand`='Yes' AND `b_name`='$userBrand' ORDER BY `b_name` ASC "); $getComp = mysql_query("SELECT DISTINCT(comp_id) FROM `brand_access` WHERE `user_id`='$userID' ORDER BY `brand_name` ASC "); echo "<table style='border-collapse:collapse;width:100%'>"; echo "<thead>"; echo "<th class='tBalls' style='width:70%;border:0px;border-bottom:1px solid gray'>BRAND</th>"; echo "</thead>"; while($row=mysql_fetch_array($getComp)){ $ActiveCompCode = mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='".$row['comp_id']."'"),0); ?><tr onclick="javascript:showSelectedBrand(this);"><?php echo "<td style='width:70%;border:0px;font-family:Calibri Light;font-size:16px;font-weight:bold;color:blue;border-bottom:1px solid lightgray'><a href='autohub.php?id=dasb&d=das&comp=".$ActiveCompCode."'>".$ActiveCompCode."</a></td>"; echo "</tr>"; } echo "</table>"; break; //===============================================================//=============================================================== case 'rpt': echo "<div class='bgColor' style='text-align:left;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 INQUIRY <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='autohub.php?id=a&d=a' onclick='showAddNewProspect()' style='font-weight:bold'> ✕ </a> </div> </div>"; //$getComp = mysql_query("SELECT * FROM `vts_brands` WHERE `group_brand`='Yes' AND `b_name`='$userBrand' ORDER BY `b_name` ASC "); $getComp = mysql_query("SELECT * FROM `brand_access` WHERE `user_id`='$userID' ORDER BY `brand_name` ASC "); echo "<table style='border-collapse:collapse;width:100%'>"; echo "<thead>"; echo "<th class='tBalls' style='width:70%'>BRAND</th>"; echo "<th class='tBalls' style='width:30%'>REQUEST</th>"; echo "</thead>"; while($row=mysql_fetch_array($getComp)){ $resUnit = mysql_result(mysql_query("SELECT COUNT('req_id') FROM `db_sc_request` WHERE `brand_name`='".$row['brand_name']."'"),0); echo "<tr>"; echo "<td style='width:70%'><a href='autohub.php?id=xv&d=x&brd=".$row['brand_name']."' style='display:block;padding:3px;text-align:left'>".$row['brand_name']."</a></td>"; echo "<td style='width:30%'><a href='autohub.php?id=xv&d=x&brd=".$row['brand_name']."' style='display:block;padding:3px;'>".$resUnit."</td>"; echo "</tr>"; } echo "</table>"; break; case 'ac': echo "<div class='bgColor' style='text-align:left;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'>ACCOUNT SUMMARY <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='autohub.php?id=a&d=a' onclick='showAddNewProspect()' style='font-weight:bold'> ✕ </a> </div> </div>"; $result = mysql_query("SELECT * FROM vts_users WHERE `deleted` = 0 AND `company`='$comID' ORDER BY `u_id` DESC"); echo "<table style='width:100%;'>"; echo "<thead> <tr> <th style='width:60%'>FIRST NAME</th> <th style='width:40%'>STATUS</th> </tr> </thead>"; while($row=mysql_fetch_array($result)){ ?><tr onclick="javascript:getSelectedUSER(this);"><?php echo "<td style='text-align:left'>".$row['u_lname'].", ".$row['u_fname']."</td>"; echo "<td>"; if($row['u_status']== 0){echo 'For Activation';}else{echo 'Active';} echo"</td>"; echo "</tr>"; } echo "</table>"; //===============================================================//=============================================================== //===============================================================//=============================================================== } ?> </div> </div> <div class="myBody"> <div id="mainBody" style='text-align:left;vertical-align:top;height:60px;margin:0px;width:100%;border-bottom:0px solid gray;padding:5px;font-family:Verdana;font-weight:normal;font-size:18px;color:#043062;background:white'> <?php $getBody=$_GET['id']; switch($getBody){ case 'loc': include 'add_locations.php'; break; case 'ac': include 'activate_new_account.php'; break; case 'rpt': include 'banner.php'; break; case 'das': include 'dashboard.php'; break; case 'dasb': include 'dashboard_brand.php'; break; case 'xv': include 'unit_reservation.php'; break; case 'c': include 'clearance_body.php'; break; case 'v': include 'inventory_body.php'; break; case 's': include 'inventory_price_setup.php'; break; case 'promo': include 'unit_promo_setup.php'; break; case 'vs': include 'add_brands.php'; break; case 'ml': include 'add_vehicle_model.php'; break; case 'cl': include 'add_vehicle_color.php'; break; case '14'://module ID include 'add_company.php'; break; case '13'://module ID include 'add_dealer.php'; break; case 'dr'://module ID include 'telephone_directory.php'; break; } ?> </div> </div> </body> </html>

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