require("./global.php");
$primaryTableName = "sites";
$cust_id = isset($_GET['id']) ? escape($_GET['id']) : '';
array(
// field_name [type, isrequired, array_select, inner_type] <= "template"
"site_name" => ["input", "", "", "text"],
"phone_number" => ["input", "", "", "text"],
"address" => ["input", "", "", "address"],
"email" => ["input", "", "", "email"],
"contact_name" => ["input", "", "", "text"],
"account_status" => ["input", "", "", "text"],
"internal_notes" => ["input", "", "", "text"],
"file" => ["input", "", "", "file"],
"historic_tickets" => ["input", "", "", "text"],
"security_pin" => ["input", "", "", "text"],
);
// if (isset($_GET['id'])) {
// $cust_id = escape($_GET['id']);
// $query = "SELECT * FROM jeoXillityCrm_sites WHERE company_id='$cust_id'";
// $results = getAll($con, $query);
// $fet = mysqli_fetch_assoc($results);
// }
if (isset($_POST['create_package'])) {
$actionId = escape($_POST['actionId']);
$company_id = escape($_POST['company_id']);
$site_name = escape($_POST['site_name']);
$phone_number = escape($_POST['phone_number']);
$address = escape($_POST['address']);
$email = escape($_POST['email']);
$contact_name = isset($_POST['contact_name']) ? implode(',', array_map('escape', $_POST['contact_name'])) : '';
$account_status = escape($_POST['account_status']);
$internal_notes = escape($_POST['internal_notes']);
$historic_tickets = escape($_POST['historic_tickets']);
$security_pin = escape($_POST['security_pin']);
$timeAdded = date('Y-m-d H:i:s'); // assuming this format for timeAdded
$session_userId = escape($_SESSION['userId']); // assuming you have session management for userId
if ($actionId == "") {
$id = generateRandomString();
$actionId = $id;
$query = "INSERT INTO jeoXillityCrm_sites
(id, company_id, site_name, phone_number, address, email, contact_name, account_status, internal_notes, historic_tickets, security_pin, timeAdded, userId)
VALUES
('$id', '$company_id', '$site_name', '$phone_number', '$address', '$email', '$contact_name', '$account_status', '$internal_notes', '$historic_tickets', '$security_pin', '$timeAdded', '$session_userId')";
echo $query;
} else {
$query = "UPDATE jeoXillityCrm_sites
SET company_id='$company_id', site_name='$site_name', phone_number='$phone_number', address='$address', email='$email', contact_name='$contact_name', account_status='$account_status', internal_notes='$internal_notes', historic_tickets='$historic_tickets', security_pin='$security_pin'
WHERE id='$actionId'";
}
runQuery($query);
if (isset($_FILES['file']) && $_FILES['file']['error'] == UPLOAD_ERR_OK) {
$file = storeFile($_FILES['file']);
if ($file != "") {
$query = "UPDATE jeoXillityCrm_sites SET file='$file' WHERE id='$actionId'";
runQuery($query);
}
}
header("Location: ?" . generateUrlParams_return(["m" => "Data was saved successfully!", "type" => "success"]));
exit();
}
if (isset($_GET['delete-record'])) {
$id = escape($_GET['delete-record']);
$query = "delete from jeoXillityCrm_sites where id='$id'";
runQuery($query);
}
?>
include("./includes/views/head2.php"); ?>
include("./includes/views/navbar.php"); ?>
include("./includes/views/rightsidebar.php"); ?>
include("./includes/views/leftmenu.php"); ?>
Select Status
Not Started
Pending
On Hold
In Progress
Completed
Select Priority
Low
Medium
High
Urgent
Filter
Sites name
Phone number
Address
Email
Contact name
Account status
Internal notes
File
Historic tickets
Security pin
Actions
Fatal error : Uncaught Error: Call to undefined function getAll() in /home/u109807606/domains/xillity-crm.online/public_html/portal/sites.php:263
Stack trace:
#0 {main}
thrown in /home/u109807606/domains/xillity-crm.online/public_html/portal/sites.php on line 263