File manager

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

Back
<?php date_default_timezone_set('Asia/Manila'); header('Content-Type: application/json'); $sqlUser = 'autoph_arnel'; $sqlDatabase = 'autoph_connect'; $sqlPass = 'Hke@2001'; $toDate = date_create() ->format("m/d/Y"); // for viewing date only $myDate ="As of ".$toDate; $conn = mysql_connect($sqlHost, $sqlUser, $sqlPass) or die ("Couldn't connct to MySQL server on $sqlHost: ". mysql_error(). '.'); $db = mysql_select_db($sqlDatabase, $conn) or die ("Couldn't select database $sqlDatabase: ". mysql_error(). '.'); $invRequest= $_REQUEST['invRequest']; // Expect LoginName, LoginPassword $model= $_REQUEST['model']; $brand= $_REQUEST['brandName']; $getM= $_REQUEST['getM']; $getC= $_REQUEST['getC']; $selModel= $_REQUEST['selModel']; $car= $_REQUEST['car']; $carID= TRIM($_REQUEST['carID']); $newsFeed= $_REQUEST['newsFeed']; $key_id= TRIM($_REQUEST['key_id']); $userName= $_REQUEST['userName']; $uID= $_REQUEST['userID']; //GET NUMBER OF TAGGED VEHICLE FOR ACTIVE USER $searchString= $_REQUEST['searchString']; $directory_name= $_REQUEST['directory_name']; //====================================================================== if($key_id == 6222015){ $return_dir = Array(); if($directory_name != ''){ $sql = "SELECT * FROM telephone_directory WHERE `u_name` LIKE '%$directory_name%' \|\| `brand_name` LIKE '%$directory_name%' ORDER BY `u_name` ASC"; }else{ $sql = "SELECT * FROM telephone_directory WHERE `status` ='1' ORDER BY `brand_name` ASC"; } $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_dir[]= $sqlRecord; } $json = json_encode($return_dir); } // if($key_id==102477){ $welcomeName = "Hi " .$userName. "!"; $countTaggedUnit = mysql_result(mysql_query("SELECT COUNT('id') FROM db_vehicle_inventory WHERE `tagged`='$uID'"),0); $countTaggedUnitFound ="You have ".$countTaggedUnit." reserved vehicle/s under your account."; $json = json_encode(["welcomeNote" => $welcomeName, "countNote"=>$countTaggedUnitFound,"asOfDate"=>$myDate]); } if($key_id==91101){ $return_tag = Array(); $sql = "SELECT brand_code, cs_number, year_model, description, color, tag_expiration_date FROM db_vehicle_inventory WHERE `tagged` ='$uID' AND `sold` = 0 ORDER BY description ASC"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_tag[]= $sqlRecord; } $json = json_encode($return_tag); } if($key_id==7212007){ if($searchString == ""){ exit(); } $return_tag = Array(); $sql = "SELECT brand_code, cs_number, year_model, description, color, cs_number,status,price, discount, commission FROM db_vehicle_inventory WHERE `brand_code` LIKE '%$searchString%' \|\| `year_model` LIKE '%$searchString%' \|\| `description` LIKE '%$searchString%' \|\| `color` LIKE '%$searchString%' AND `sold`= 0 \|\| `brand_code` LIKE '%$searchString%' \|\| `year_model` LIKE '%$searchString%' \|\| `description` LIKE '%$searchString%' \|\| `color` LIKE '%$searchString%' AND `returned`= 0 ORDER BY description ASC"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_tag[]= $sqlRecord; } $json = json_encode($return_tag); } //====================================================================================================================================================================================================================================== if($newsFeed==10240911070721200106222015){ $return_news = Array(); $sql = "SELECT * FROM newsfeed WHERE image !='' AND `status`= 1 ORDER BY id DESC LIMIT 5 "; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_news[]= $sqlRecord; } $json = json_encode($return_news); } if($getM==1){ $return_ar = Array(); $sql = "SELECT * FROM db_vehicle_inventory WHERE brand_code ='$selModel' AND `sold`= 0 AND `returned`= 0 ORDER BY brand_code ASC"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $imageLink = mysql_result(mysql_query("SELECT `image` FROM `vts_model` WHERE `m_name`='$selModel'"),0); $return_ar[]= $sqlRecord; } //$json = json_encode($return_ar); $json = json_encode([$return_ar,"image"=>$imageLink]); } if($getC==1){ $return_are = Array(); $sql = "SELECT * FROM db_vehicle_inventory WHERE brand_code ='$selModel' AND `sold`= 0 AND `returned`= 0 ORDER BY color ASC"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $imageLink = mysql_result(mysql_query("SELECT `image` FROM `vts_model` WHERE `m_name`='$selModel'"),0); $return_are[]= $sqlRecord; } //$json = json_encode($return_are); $json = json_encode([$return_are,"image"=>$imageLink]); } if($car==1){ $return_car = Array(); $sql = "SELECT * FROM db_vehicle_inventory WHERE id ='$carID'"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_car[]= $sqlRecord; } //$json = json_encode($return_ar); $json = json_encode($return_car); } //====================================================================================================================================================================================================================================== if($model==1){ mysql_query("DROP TABLE IF EXISTS `tempInventoryByModel`"); $sql = "CREATE TABLE IF NOT EXISTS `tempInventoryByModel` (`invID` int(11) NOT NULL AUTO_INCREMENT, `model_name` varchar(30) NOT NULL, `available_stock` varchar(7) NOT NULL, `reserved_stsock` varchar(7) NOT NULL, `incoming_stock` varchar(7) NOT NULL, `total_stock` varchar(7) NOT NULL,PRIMARY KEY (`invID`))"; $bid = mysql_result(mysql_query("SELECT `b_id` FROM `vts_brands` WHERE `b_name`='$brand'"),0); $sqlResponse = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): ". mysql_error(). '.'); $sql = "SELECT * FROM vts_model WHERE b_id = '$bid' ORDER BY m_name DESC "; $sqlTable = mysql_query($sql, $conn); while($invRecord = mysql_fetch_assoc($sqlTable)) { $brandCode = $invRecord['m_name']; $TotalCount = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `brand_code`='$brandCode' AND `sold`=0 AND `returned`=0"),0); $TotalAvailavle = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `brand_code`='$brandCode' AND `sold`=0 AND `returned`= 0 AND `reserved`= 0 AND `incoming_unit`= 0"),0); $TotalReserved = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `brand_code`='$brandCode' AND `sold`=0 AND `returned`= 0 AND `reserved`= 1 AND `incoming_unit`= 0"),0); $TotalIncoming = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `brand_code`='$brandCode' AND `sold`=0 AND `returned`= 0 AND `reserved`= 0 AND `incoming_unit`= 1"),0); $sql = "INSERT INTO tempInventoryByModel (invID, model_name, available_stock, reserved_stsock, incoming_stock, total_stock) VALUES('', '$brandCode', '$TotalAvailavle', '$TotalReserved', '$TotalIncoming', '$TotalCount')"; $sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); } $return_ar = Array(); $sql = "SELECT * FROM tempInventoryByModel WHERE model_name !='' ORDER BY model_name ASC"; $brandLogo=mysql_result(mysql_query("SELECT `logo` FROM `vts_brands` WHERE `b_name`='$brand'"),0); $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_ar[]= $sqlRecord; } $json = json_encode([$return_ar, "brandLogo" => $brandLogo]); } //====================================================================================================================================================================================================================================== if($invRequest == 1){ mysql_query("DROP TABLE IF EXISTS `tempInventoryCount`"); $sql = "CREATE TABLE IF NOT EXISTS `tempInventoryCount` (`invID` int(11) NOT NULL AUTO_INCREMENT, `brand_name` varchar(30) NOT NULL, `available_stock` varchar(7) NOT NULL, `reserved_stsock` varchar(7) NOT NULL, `incoming_stock` varchar(7) NOT NULL, `total_stock` varchar(7) NOT NULL,PRIMARY KEY (`invID`))"; $sqlResponse = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): ". mysql_error(). '.'); $sql = "SELECT * FROM vts_brands WHERE group_brand = 'Yes' ORDER BY b_name DESC "; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $brand = $sqlRecord['b_name']; $TotalCount = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `brand`='$brand' AND `sold`=0 AND `returned`=0"),0); $TotalAvailavle = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `brand`='$brand' AND `sold`=0 AND `returned`= 0 AND `reserved`= 0 AND `incoming_unit`= 0"),0); $TotalReserved = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `brand`='$brand' AND `sold`=0 AND `returned`= 0 AND `reserved`= 1 AND `incoming_unit`= 0"),0); $TotalIncoming = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `brand`='$brand' AND `sold`=0 AND `returned`= 0 AND `reserved`= 0 AND `incoming_unit`= 1"),0); $sql = "INSERT INTO tempInventoryCount (invID, brand_name, available_stock, reserved_stsock, incoming_stock, total_stock) VALUES('', '$brand', '$TotalAvailavle', '$TotalReserved', '$TotalIncoming', '$TotalCount')"; $sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); } $return_arr = Array(); $return_info = Array(); $sql = "SELECT * FROM tempInventoryCount WHERE brand_name !='' ORDER BY brand_name ASC"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_arr[]= $sqlRecord; } $json = json_encode($return_arr); //$pros = mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `status`='open'"),0); ; // $cold = mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `status`='open' AND `cold_date`='' AND `warm_date`='' AND `hot_date`='' AND `sales_approval`='' AND `win_date`='' AND `lost_date`=''"),0); // $warm = mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `status`='open' AND `warm_date`!='' AND `hot_date`='' AND `sales_approval`='' and `win_date`='' AND `lost_date`=''"),0); // $hot = mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `status`='open' AND `hot_date`!='' AND `sales_approval`='' and `win_date`='' AND `lost_date`=''"),0); // $approval = mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `status`='open' AND `sales_approval`!='' and `win_date`='' AND `lost_date`=''"),0); // $json = json_encode([$return_arr, "TotalDB"=>$totalTotalDB, "TotalProspect"=>$totaldbProspect, "TotalProspectFleet" => $totaldbProspectF, "TotalProspectNon" => $totalTdbProspectN, "cold"=>$cold, "warm"=>$warm, "hot"=>$hot, "Approval"=>$approval ]); // $json = json_encode($return_info); //$json = json_encode(); $did_something += 1; } if($did_something === 0) { $msg = did_nothing_message; $json = json_encode(["status" => "$MyCustomerID", "statusCode" => "$customerType"]); } echo $json; ?>

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