File manager

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

Back
<?php date_default_timezone_set('Asia/Manila'); $sqlUser = 'autoph_arnel'; $sqlDatabase = 'autoph_connect'; $sqlPass = 'Hke@2001'; $toDate = date_create() ->format("m/d/Y"); // for viewing date only $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(). '.'); $queryKey= $_REQUEST['queryKey']; // Expect LoginName, LoginPassword $queryBrand= $_REQUEST['queryBrand']; // Expect LoginName, LoginPassword $queryModel= $_REQUEST['queryModel']; // Expect LoginName, LoginPassword $queryCompany= $_REQUEST['queryCompany']; // Expect LoginName, LoginPassword //====================================================================== //====================================================================================================================================================================================================================================== if($queryKey == 9119119112001){ mysql_query("DROP TABLE IF EXISTS `tempDealerCount`"); $sql = "CREATE TABLE IF NOT EXISTS `tempDealerCount` (`invID` int(11) NOT NULL AUTO_INCREMENT, `dealer_code` varchar(15) NOT NULL, `dealer_name` varchar(25) NOT NULL, `available_stock` varchar(7) NOT NULL, `reserved_stock` varchar(7), `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(). '.'); $compID = mysql_result(mysql_query("SELECT `comp_id` FROM `vts_company` WHERE `comp_code`='$queryCompany'"),0); $sql = "SELECT * FROM vts_dealerships WHERE comp_id = '$compID' ORDER BY `deal_code` ASC "; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $dealCode = $sqlRecord['deal_code']; $dealName = $sqlRecord['deal_name']; $TotalCount = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE company='$queryCompany' AND `dealer`='$dealCode' AND `brand`='$queryBrand' AND `brand_code`='$queryModel' AND `sold`=0 AND `returned`=0"),0); $TotalAvailavle = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE company='$queryCompany' AND `dealer`='$dealCode' AND `brand_code`='$queryModel' 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 company='$queryCompany' AND `dealer`='$dealCode' AND `brand_code`='$queryModel' 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 company='$queryCompany' AND `dealer`='$dealCode' AND `brand_code`='$queryModel' AND `sold`=0 AND `returned`= 0 AND `reserved`= 0 AND `incoming_unit`= 1"),0); $sql = "INSERT INTO tempDealerCount (dealer_code,dealer_name, available_stock, reserved_stock, incoming_stock, total_stock) VALUES('$dealCode','$dealName', '$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 tempDealerCount WHERE dealer_code !='' ORDER BY dealer_code ASC"; $imageLink=mysql_result(mysql_query("SELECT `image` FROM `vts_model` WHERE `m_name`='$queryModel'"),0); if(!empty($imageLink)){ }else{ $imageLink='https://www.autohub.ph/connect/uimages/no_image.png'; } $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_arr[]= $sqlRecord; } $json = json_encode([$return_arr,"Company"=>$queryCompany,"imageLink"=>$imageLink]); $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