File manager

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

Back
<?php date_default_timezone_set('Asia/Manila'); header('Content-Type: application/json'); $toDate = date_create() ->format("Y/m/d"); $toTime =Explode(":", date('H:i:s')); $tDate = explode("/",$toDate); $mycDay=$tDate[2]; $mycMonth=$tDate[1]; $mycYear=$tDate[0]; $myTime = $toTime[0]; $myMinute = $toTime[1]; $mySecond = $toTime[2]; $currentTime = $myTime . ':' . $myMinute . ':' . $mySecond; //API.GEONAMES.ORG FOR THE API GEOLOCATION SERVICE // /mysql_connect('localhost','autoph_portal','mis1541ng') or die ($connect_error); $sqlUser = 'autoph_arnel'; $sqlDatabase = 'autoph_connect'; $sqlPass = 'Hke@2001'; $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(). '.'); $connect= addslashes($_REQUEST['connect']); $search= addslashes($_REQUEST['search']); //====================================================================== if($connect == 1) { $prosID = addslashes($_REQUEST['prosID']); $return_arr = Array(); $sql = "SELECT * FROM prospect_updates WHERE prospect_id = '$prosID' AND status=1 ORDER BY date DESC"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_arr[]=$sqlRecord; } $json = json_encode($return_arr); $did_something += 1; } //====================================================================== if($connect == 2) { $prosID = addslashes($_REQUEST['prosID']); $prospect_type = addslashes($_REQUEST['prospect_type']); $description = addslashes($_REQUEST['description']); $dealer_id = addslashes($_REQUEST['dealer_id']); $comp_id = addslashes($_REQUEST['comp_id']); $update_by = addslashes($_REQUEST['update_by']); $movement = addslashes($_REQUEST['movement']); $custID = addslashes($_REQUEST['custID']); if($description != ''){ $return_arr = Array(); if($prospect_type === 'No'){ $pType = 'non-fleet'; }else{ $pType = 'fleet'; } switch($movement){ case 'active': // warm mysql_query("UPDATE sales_prospecting SET warm_date='$toDate' WHERE id = '$prosID'"); break; case 'demo': // hot mysql_query("UPDATE sales_prospecting SET hot_date='$toDate' WHERE id = '$prosID'"); break; case 'approval': // approval mysql_query("UPDATE sales_prospecting SET sales_approval='$toDate' WHERE id = '$prosID'"); break; case 'win':// win mysql_query("UPDATE sales_prospecting SET win_date='$toDate', status='closed' WHERE id = '$prosID'"); break; case 'lost': // lost mysql_query("UPDATE sales_prospecting SET lost_date='$toDate', status='closed' WHERE id = '$prosID'"); break; } $sql = "INSERT INTO prospect_updates (prospect_id, prospect_type, description, date, time, dealer_id, comp_id, update_by, movement) VALUES('$prosID', '$pType', '$description', '$toDate', '$currentTime', '$dealer_id', '$comp_id', '$update_by', '$movement')"; $sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); $return_arr['UpdateStatus']= "Update has been saved."; //$return_arr['prosID']="$prosID"; //$return_arr['description']="$description"; //$return_arr['dealer_id']="$dealer_id"; //$return_arr['comp_id']="$comp_id"; //$return_arr['update_by']="$update_by"; //$return_arr['movement']="$movement"; $json = json_encode($return_arr); $did_something += 1; }else{ $return_arr['UpdateStatus']="Error: Incomplete Details detected."; $json = json_encode($return_arr); $did_something += 1; } } //====================================================================== if($search == 3) { $searchText = addslashes($_REQUEST['searchText']); $searchBy = addslashes($_REQUEST['searchBy']); $return_arr = Array(); if($searchText != ""){ $sql = "SELECT * FROM vts_customers WHERE cust_lname LIKE '%$searchText%' \|\| cust_fname LIKE '%$searchText%' \|\| cust_mobile LIKE '%$searchText%'ORDER BY cust_lname DESC LIMIT 10"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $i ++; $return_arr[]=$sqlRecord; } $json = json_encode([$return_arr , "Status" => "Record/s Found: $i"]); $did_something += 1; }else{ $json = json_encode([ "Status" => "No record found:"]); $did_something += 1; } } //====================================================================== if($connect == 3) { $userID = addslashes($_REQUEST['userID']); $taskDate = addslashes($_REQUEST['taskDate']); $taskDesc = addslashes($_REQUEST['taskDesc']); $dealID = addslashes($_REQUEST['dealID']); $compID = addslashes($_REQUEST['compID']); $taskTime = addslashes($_REQUEST['taskTime']); if($taskDesc != ''){ $return_arr = Array(); $sql = "INSERT INTO vts_tasks (user_id, task_desc, task_date,task_time, date_created, time_created, comp_id, deal_id ) VALUES('$userID', '$taskDesc', '$taskDate','$taskTime', '$toDate', '$currentTime', '$compID', '$dealID')"; $sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); $return_arr['UpdateStatus']= "New Activity has been saved."; $json = json_encode($return_arr); $did_something += 1; }else{ $return_arr['UpdateStatus']="Error: Incomplete Information detected."; $json = json_encode($return_arr); $did_something += 1; } } //====================================================================== if($connect == 4) { $userID = addslashes($_REQUEST['userID']); $dealID = addslashes($_REQUEST['dealID']); $compID = addslashes($_REQUEST['compID']); $return_arr = Array(); if($userID != ""){ $sql = "SELECT * FROM vts_tasks WHERE user_id = '$userID' AND comp_id = '$compID' AND deal_id = '$dealID' AND status='open' ORDER BY date_created DESC"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $i ++; $return_arr[]=$sqlRecord; } $json = json_encode([$return_arr , "Status" => "Record/s Found: $i"]); $did_something += 1; }else{ $json = json_encode([ "Status" => "No record found:"]); $did_something += 1; } } //====================================================================== if($did_something === 0) { $msg = did_nothing_message; $json = json_encode(["status" => "$searchText", "statusCode" => "$search"]); } echo $json; ?>

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