File manager

File manager - Edit - /home/autoph/public_html/connect/COMPANY_Inventory.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 //====================================================================== //====================================================================================================================================================================================================================================== if($queryKey == 1024102410241977){ mysql_query("DROP TABLE IF EXISTS `tempCompanyCount`"); $sql = "CREATE TABLE IF NOT EXISTS `tempCompanyCount` (`invID` int(11) NOT NULL AUTO_INCREMENT, `company_code` 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, `region` varchar(50) NOT NULL, PRIMARY KEY (`invID`))"; $sqlResponse = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): ". mysql_error(). '.'); $sql = "SELECT * FROM vts_company WHERE brand LIKE '%$queryBrand%' ORDER BY `comp_name` ASC "; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $brandX = $sqlRecord['brand']; $brandS = explode(',', $brandX); $brandA = $brandS[0]; $brandB = $brandS[1]; $brandC = $brandS[2]; $brandD = $brandS[3]; $brandE = $brandS[4]; $brandF = $brandS[5]; $brandG = $brandS[6]; $brandH = $brandS[7]; if($brandA === $queryBrand){ $activeBrand = $brandA; } if($brandB === $queryBrand){ $activeBrand = $brandB; } if($brandC === $queryBrand){ $activeBrand = $brandC; } if($brandD === $queryBrand){ $activeBrand = $brandD; } if($brandE === $queryBrand){ $activeBrand = $brandE; } if($brandF === $queryBrand){ $activeBrand = $brandF; } if($brandG === $queryBrand){ $activeBrand = $brandG; } if($brandH === $queryBrand){ $activeBrand = $brandH; } if($brandH === $queryBrand){ $activeBrand = $brandH; } $company = $sqlRecord['comp_code']; $location = $sqlRecord['region']; //==================================================================== if($brandA!=''){ $TotalCount = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE company='$company' AND `brand` = '$activeBrand' 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='$company' AND `brand`='$activeBrand' 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='$company' AND `brand`='$activeBrand' 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='$company' AND `brand`='$activeBrand' AND `brand_code`='$queryModel' AND `sold`=0 AND `returned`= 0 AND `reserved`= 0 AND `incoming_unit`= 1"),0); } //==================================================================== // if($brandB!=''){ // $TotalCount = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE company='$company' AND `brand` = '$brandA' AND `brand_code`='$queryModel' AND `sold`=0 AND `returned`=0 \|\| company='$company' AND `brand` = '$brandB' 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='$company' AND `brand` = '$brandA' AND `brand_code`='$queryModel' AND `sold`=0 AND `returned`= 0 AND `reserved`= 0 AND `incoming_unit`= 0 \|\| company='$company' AND `brand` = '$brandB' 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='$company' AND `brand` = '$brandA' AND `brand_code`='$queryModel' AND `sold`=0 AND `returned`= 0 AND `reserved`= 1 \|\| company='$company' AND `brand` = '$brandB' AND `brand_code`='$queryModel' AND `sold`=0 AND `returned`= 0 AND `reserved`= 1 "),0); // $TotalIncoming = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE company='$company' AND `brand`='$brandA' AND `brand_code`='$queryModel' AND `sold`=0 AND `returned`= 0 AND `reserved`= 0 AND `incoming_unit`= 1 \|\| company='$company' AND `brand`='$brandB' AND `brand_code`='$queryModel' AND `sold`=0 AND `returned`= 0 AND `reserved`= 0 AND `incoming_unit`= 1"),0); // } $sql = "INSERT INTO tempCompanyCount (company_code, available_stock, reserved_stock, incoming_stock, total_stock,region) VALUES('$company', '$TotalAvailavle', '$TotalReserved', '$TotalIncoming', '$TotalCount', '$location')"; $sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); } $return_arr = Array(); $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'; } $sql = "SELECT * FROM tempCompanyCount WHERE company_code !='' ORDER BY company_code ASC"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_arr[]= $sqlRecord; } $json = json_encode([$return_arr,"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