"; echo ""; echo " "; echo " "; echo ""; echo ""; //$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); ?>
.
🔐: ".strtoupper($accType)."      |     👩 User: ".strtoupper($user_data['u_name'])."      |     🏪 Company: ".$comName."     |     ❌ Logout

";?>

⇚     HOME
✩ Vehicle Inventory"; echo "✩ Price Setup"; echo "✩ Price List"; echo "✩ Reservation Request"; }else{ echo "✩ Vehicle Inventory"; echo "✩ Price Setup"; echo "✩ Price List"; echo "✩ Reservation Request"; } if($ASAMKTG == 1){ echo "✩ Promos & Discounts"; }else{ echo "✩ Promos & Discounts"; } if($ASAFNI ==1 ){ echo "✩ Financing Promo"; }else{ echo "✩ Financing Promo"; } ?>
✩ ADD NEW COMPANY ✩ ADD NEW DEALERSHIP "; }else{ echo "✩ ADD NEW COMPANY ✩ ADD NEW DEALERSHIP "; } if($ASAADM == 1){ echo "✩ VEHICLE SETUP"; echo "✩ ACTIVATE ACCOUNT"; echo "✩ TELEPHONE DIRECTORY"; echo "✩ ADD LOCATION"; }else{ echo "✩ VEHICLE SETUP"; echo "✩ ACTIVATE ACCOUNT"; echo "✩ TELEPHONE DIRECTORY"; echo "✩ ADD LOCATION"; } ?>
🖬 REPORTS
📊 CHART
VEHICLE PRICE SETUP
✕
"; $getComp = mysql_query("SELECT DISTINCT(brand_name) FROM `brand_access` WHERE `user_id`='$userID' ORDER BY `brand_name` ASC "); echo ""; 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); ?> ".$row['brand_name']; echo "
"; $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 "
"; while($row=mysql_fetch_array($getCompX)){ echo ""; echo ""; echo ""; } echo "
: ".$row['m_name']."
"; echo "
"; echo ""; echo ""; } echo ""; break; //===============================================================//=============================================================== //===============================================================//=============================================================== case 'c': echo "
CLEARANCE DASHBOARD
✕
"; $getComp = mysql_query("SELECT * FROM `vts_company` WHERE `comp_status`='1' ORDER BY `comp_name` ASC "); echo ""; echo ""; echo ""; echo ""; echo ""; while($row=mysql_fetch_array($getComp)){ echo ""; echo ""; echo ""; echo ""; } echo "
COMPANYOPEN
".$row['comp_code'].""; echo"
"; break; //===============================================================//=============================================================== //===============================================================//=============================================================== case 'i': $count=0; echo "
GRANTED ACCESSX
✕
"; //$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 ""; echo ""; echo ""; echo ""; while($row=mysql_fetch_array($getComp)){ $myCompany = $row['comp_id']; //echo $myCompany."
"; $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){ ?>".$compName.""; //echo ""; echo ""; } } } echo "
VEHICLE INVENTORY
".$getTotalAvail."
"; echo "

"; $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 ""; echo ""; echo ""; echo ""; 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 ""; echo ""; }else{ echo ""; echo ""; } } echo "
DEALERSHIPS:
Sorry, you do not have access to any of the dealerships under ".$compName.".

Please contact your system Administrator of Assistance.
".$dealName."
"; break; //===============================================================//=============================================================== //===============================================================//=============================================================== case 'promo': echo "
DASHBOARD
✕
"; $getComp = mysql_query("SELECT DISTINCT(brand_name),comp_id FROM `brand_access` WHERE `user_id`='$userID' ORDER BY `brand_name` ASC "); echo ""; echo ""; echo ""; //echo ""; echo ""; $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); ?>".$row['brand_name'].""; //echo ""; echo ""; } $pBrand=$brand; } echo "
PROMOS AND DISCOUNTSSTOCKS
".$getTotalAvail."
"; break; //===============================================================//=============================================================== //===============================================================//=============================================================== case 'vsat': echo "
VEHICLE SETUP
✕
"; $getComp = mysql_query("SELECT DISTINCT(brand_name),comp_id FROM `brand_access` WHERE `user_id`='$userID' ORDER BY `brand_name` ASC "); echo ""; echo ""; echo ""; //echo ""; echo ""; $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); ?>".$row['brand_name'].""; //echo ""; echo ""; } $pBrand=$brand; } echo "
BRANDSSTOCKS
".$getTotalAvail."
"; break; //===============================================================//=============================================================== //===============================================================//=============================================================== case 'finance': echo "
DASHBOARD
✕
"; $getComp = mysql_query("SELECT DISTINCT(brand_name),comp_id FROM `brand_access` WHERE `user_id`='$userID' ORDER BY `brand_name` ASC "); echo ""; echo ""; echo ""; //echo ""; echo ""; $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); ?>".$row['brand_name'].""; //echo ""; echo ""; } $pBrand=$brand; } echo "
FINANCING PROMOSTOCKS
".$getTotalAvail."
"; break; //===============================================================//=============================================================== //===============================================================//=============================================================== case 'price': echo "
DASHBOARD
✕
"; $getComp = mysql_query("SELECT DISTINCT(brand_name),comp_id FROM `brand_access` WHERE `user_id`='$userID' ORDER BY `brand_name` ASC "); echo ""; echo ""; echo ""; //echo ""; echo ""; $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); ?>".$row['brand_name'].""; //echo ""; echo ""; } $pBrand=$brand; } echo "
VEHICLE PRICELIST STOCKS
".$getTotalAvail."
"; break; //===============================================================//=============================================================== //===============================================================//=============================================================== case 'x': echo "
DASHBOARD
✕
"; $getComp = mysql_query("SELECT DISTINCT(brand_name),comp_id FROM `brand_access` WHERE `user_id`='$userID' ORDER BY `brand_name` ASC "); echo ""; echo ""; echo ""; //echo ""; echo ""; $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); ?>".$row['brand_name'].""; //echo ""; echo ""; } $pBrand=$brand; } echo "
Reservation SummarySTOCKS
".$getTotalAvail."
"; break; //===============================================================//=============================================================== //===============================================================//=============================================================== case 'das': echo "
DASHBOARD
✕
"; //$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 ""; echo ""; echo ""; echo ""; while($row=mysql_fetch_array($getComp)){ $ActiveCompCode = mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='".$row['comp_id']."'"),0); ?>".$ActiveCompCode.""; echo ""; } echo "
BRAND
"; break; //===============================================================//=============================================================== case 'rpt': echo "
SALES INQUIRY
✕
"; //$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 ""; echo ""; echo ""; echo ""; echo ""; 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 ""; echo ""; echo ""; echo ""; } echo "
BRANDREQUEST
".$row['brand_name']."".$resUnit."
"; break; case 'ac': echo "
ACCOUNT SUMMARY
✕
"; $result = mysql_query("SELECT * FROM vts_users WHERE `deleted` = 0 AND `company`='$comID' ORDER BY `u_id` DESC"); echo ""; echo ""; while($row=mysql_fetch_array($result)){ ?>".$row['u_lname'].", ".$row['u_fname'].""; echo ""; echo ""; } echo "
FIRST NAME STATUS
"; if($row['u_status']== 0){echo 'For Activation';}else{echo 'Active';} echo"
"; //===============================================================//=============================================================== //===============================================================//=============================================================== } ?>