File manager

File manager - Edit - /home/autoph/public_html/tasks/ML_getCompayDBInfo.php.tar

Back
home/autoph/public_html/connect/ML_getCompayDBInfo.php��0000644��00000023061�15025027543�0017007 0��ustar�00��<?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("Y/m/d"); $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(). '.'); $uReg = $_REQUEST['uReg']; $companyDB= $_REQUEST['companyDB']; // Expect LoginName, LoginPassword $reqCompanyID= $_REQUEST['reqCompanyID']; // Expect LoginName, LoginPassword $reqDealerID= $_REQUEST['reqDealerID']; // Expect LoginName, LoginPassword $selCompID= $_REQUEST['selCompID']; $reservedID= $_REQUEST['reservedID']; $myID= $_REQUEST['myID']; //get directory services] $delReq= $_REQUEST['x-DELETE']; $delID= $_REQUEST['delID']; $saveRes= $_REQUEST['saveRes']; //====================================================================== if($saveRes == 72107){ $empID= $_REQUEST['empID']; $unitID= $_REQUEST['unitID']; $Notes = $_REQUEST['Notes']; $brand= $_REQUEST['brand']; $desc= $_REQUEST['desc']; $sql = "INSERT INTO db_sc_request (sc_id, unit_id, request_type, notes,status, brand_name, variant_dest , saved_date) VALUES('$empID', '$unitID','RESERVATION','$Notes','New','$brand','$desc', '$toDate')"; $sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); $msg ="Reservation request has been sent"; $json = json_encode(["Status"=>$msg]); } //====================================================================== //====================================================================== if($delReq == 104){ mysql_query("UPDATE `db_sc_request` SET `status`='Cancelled' WHERE `req_id` = '$delID'"); $msg ="Record has been deleted from your bookmark list."; $json = json_encode(["Status"=>$msg]); } //====================================================================== if($reservedID == 1){ $return_dir = Array(); $sql = "SELECT * FROM db_sc_request WHERE `sc_id`='$myID' AND `status` !='Closed' AND `status` !='Cancelled'"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_dir[]= $sqlRecord; } $json = json_encode($return_dir); } //====================================================================== //========================================================= if($uReg == 1024){ $regErrorCode = 0; $regEmpID= addslashes($_REQUEST['regEmpID']); $regFName= addslashes($_REQUEST['regFName']); $regLName= addslashes($_REQUEST['regLName']); $regMobileA= addslashes($_REQUEST['regMobileA']); $regMobileB= addslashes($_REQUEST['regMobileB']); $regEmail= addslashes($_REQUEST['regEmail']); $regCompany= addslashes($_REQUEST['regCompany']); $regDealership= addslashes($_REQUEST['regDealership']); $regPosition= addslashes($_REQUEST['regPosition']); $regPasswordA= addslashes($_REQUEST['regPasswordA']); $MyregPasswordA = md5($regPasswordA); $regPasswordB= addslashes($_REQUEST['regPasswordB']); $MyregPasswordB = md5($regPasswordB); if($MyregPasswordA != $MyregPasswordB){ $status = "Your password didn't match."; $json = json_encode(["status" => "$status", "errorCode" => '0']); $regErrorCode = $regErrorCode + 1; $json = json_encode(['Status'=>$status, 'REGcode'=>$regErrorCode]); } if($regEmpID === '' \|\| $regFName ==='' \|\| $regLName ==='' \|\| $regMobileA ==='' \|\| $regEmail ==='' \|\| $regDealership ==='' \|\| $regCompany ==='' \|\| $regPosition ==='' \|\| $regPasswordA ===''){ $status = "Incomplete information."; $json = json_encode(["status" => "$status", "errorCode" => '1']); $regErrorCode = $regErrorCode + 1; $json = json_encode(['Status'=>$status, 'REGcode' => $regErrorCode]); } if($regErrorCode == 0){ $sql = "INSERT INTO vts_users (employee_id, company, dealer, u_name,u_fname, u_lname, u_position, email, u_password, u_password2, u_status, account_type, access_right, date, usr_mobile,mobileTwo, u_locked) VALUES('$regEmpID', '$regCompany','$regDealership','$regEmpID','$regFName','$regLName','$regPosition','$regEmail','$MyregPasswordA','$MyregPasswordB','0', 'user','', '$toDate', '$regMobileA','$regMobileB','1')"; $sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); $status = "$RegName registered"; $json = json_encode(['Status'=>$status,'username' => $regEmpID, 'REgCode'=>'yes']); } } //========================================================= if($reqCompanyID == 1024){ $return_dir = Array(); $sql = "SELECT comp_code, comp_name, comp_id FROM vts_company WHERE `comp_status` ='1' ORDER BY `comp_code` ASC"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_dir[]= $sqlRecord; } $json = json_encode($return_dir); } if($reqDealerID == 5){ // $gCompID = mysql_result(mysql_query("SELECT `comp_id` FROM `vts_company` WHERE `comp_code`='$selCompID'"),0); $sql = "SELECT deal_id, comp_id, deal_code, deal_name FROM vts_dealerships WHERE comp_id='$selCompID' ORDER BY `deal_name` ASC"; $return_dir = Array(); $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_dir[]= $sqlRecord; } $json = json_encode($return_dir); } //========================================================= //========================================================= if($companyDB == 1){ mysql_query("DROP TABLE IF EXISTS `tempCompanyDB`"); $sql = "CREATE TABLE IF NOT EXISTS `tempCompanyDB` (`regID` int(11) NOT NULL AUTO_INCREMENT, `compID` varchar(100) NOT NULL, `compCode` varchar(100) NOT NULL, `dbCount` varchar(100) NOT NULL, `dbLeads` varchar(100) NOT NULL, `dbFleet` varchar(100) NOT NULL, `dbNFleet` varchar(100) NOT NULL,PRIMARY KEY (`regID`))"; $sqlResponse = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): ". mysql_error(). '.'); $sql = "SELECT * FROM vts_company WHERE comp_status = 1 ORDER BY comp_name DESC "; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $cID = $sqlRecord['comp_id']; $selCompCode = $sqlRecord['comp_code']; $compDBFleet = mysql_result(mysql_query("SELECT COUNT('bid') FROM `businesses_names` WHERE `status`=1 AND `comp_owner_id`='$cID'"),0); $compDBXFleet = mysql_result(mysql_query("SELECT COUNT('c_id') FROM `vts_customers` WHERE `status` = 1 AND `cust_comp_id`='$cID' "),0); $dbProspect = mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `status` = 'open' AND `comp_id`='$cID' "),0); $dbProspectF = mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `status` = 'open' AND `is_fleet`='Yes' AND `comp_id`='$cID'"),0); $dbProspectN = mysql_result(mysql_query("SELECT COUNT('id') FROM `sales_prospecting` WHERE `status` = 'open' AND `is_fleet`='No' AND `comp_id`='$cID' "),0); $totalDB = $compDBFleet + $compDBXFleet; $sql = "INSERT INTO tempCompanyDB (regID, compID, compCode, dbCount, dbLeads, dbFleet, dbNFleet) VALUES('', '$cID', '$selCompCode', '$totalDB', '$dbProspect', '$dbProspectF', '$dbProspectN')"; $sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); $totalTotalDB = $totalTotalDB + $totalDB; $totaldbProspect = $totaldbProspect + $dbProspect; $totaldbProspectF = $totaldbProspectF + $dbProspectF; $totalTdbProspectN = $totalTdbProspectN + $dbProspectN; $selCompCode=''; $totalDB=''; $dbProspect=''; $compDBFleet=''; $compDBNFleet=''; } $return_arr = Array(); $return_info = Array(); $sql = "SELECT * FROM tempCompanyDB WHERE compCode != '' ORDER BY compCode DESC"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_arr[]= $sqlRecord; } $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