File manager

File manager - Edit - /home/autoph/public_html/connect/DC_Aging_Unit.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['invKey']; // Expect LoginName, LoginPassword //====================================================================== //====================================================================================================================================================================================================================================== if($invRequest == 1010102424){ mysql_query("DROP TABLE IF EXISTS `tempDCBrandCount`"); $sql = "CREATE TABLE IF NOT EXISTS `tempDCBrandCount` (`cl_id` int(11) NOT NULL AUTO_INCREMENT, `cl_code` varchar(30) NOT NULL, `cl_desc` varchar(7) NOT NULL, `cl_status` varchar(7) NOT NULL,PRIMARY KEY (`cl_id`))"; $sqlResponse = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): ". mysql_error(). '.'); $sql = "SELECT * FROM vts_brands WHERE group_brand = 'Yes' AND b_status=1 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 "),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 (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); $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