"New Yearโs Day",
"2025-03-21" => "Human Rights Day",
"2025-04-18" => "Good Friday",
"2025-04-21" => "Family Day",
"2025-04-27" => "Freedom Day",
"2025-04-28" => "Public holiday (Freedom Day observed)",
"2025-05-01" => "Workers' Day",
"2025-06-16" => "Youth Day",
"2025-08-09" => "National Womenโs Day",
"2025-09-24" => "Heritage Day",
"2025-12-16" => "Day of Reconciliation",
"2025-12-25" => "Christmas Day",
"2025-12-26" => "Day of Goodwill"
];
$db = new db_safeguard();
$durationTasks = [];
$tasks = []; // Initialize early so it's available for all sections
$user_data = $admin ? "" : " AND `user_id_assigned` = {$_SESSION['user_id']}";
// Work Orders (Duration Tasks)
$work_order_res = $db->query("work_orders", "SELECT * FROM `work_orders` WHERE `completed` = 0 AND `sent_for_review` = 0 AND `in_review` = 0 $user_data");
if ($work_order_res->num_rows > 0) {
while ($work_order = $work_order_res->fetch_assoc()) {
$start_date = substr($work_order['action_date_time'], 0, 10);
$end_date = substr($work_order['deadline_date_time'], 0, 10);
$project_details = $db->query("projects", "SELECT * FROM projects WHERE record_id = {$work_order['project_id']}");
$project_name = $project_details->fetch_assoc()['name'];
$completed = $work_order['completed'];
$class = ($end_date < date('Y-m-d H:i') && $completed != 1) ? "task task-overdue" : "task task-duration";
$overdue = ($end_date < date('Y-m-d H:i') && $completed != 1) ? "(OVERDUE)" : "";
if ($completed == 1) {
$class = "duration_task task-complete";
}
$durationTasks[] = [
'start' => "$start_date",
'end' => "$end_date",
'name' => htmlspecialchars(" {$work_order['name']} On Projcet: $project_name $overdue "),
'description' => "",
'link' => htmlspecialchars("/app/work_orders/work_order.php?record_id={$work_order['record_id']}"),
'class' => "$class",
"project" => "๐๏ธ " . "$project_name",
"public_holiday" => $work_order['public_holiday'] ?? '0'
];
}
}
// Meetings
$meetings_res = $db->query("meetings", "SELECT * FROM `meetings` WHERE date_time BETWEEN '$dateStart' AND '$dateEnd' AND (user_ids LIKE '%,{$_SESSION['user_id']},%' OR user_id = '{$_SESSION['user_id']}')");
if ($meetings_res->num_rows > 0) {
while ($meeting = $meetings_res->fetch_assoc()) {
$date = substr($meeting['date_time'], 0, 10);
$time = str_replace("T", "", substr($meeting['date_time'], 11));
$user_res = $db->query("users", "SELECT * FROM users WHERE record_id = {$meeting['user_id']}");
$username = $user_res->fetch_assoc()['username'];
$class = ("$date $time" < date('Y-m-d H:i')) ? "daily_task task-overdue " : "daily_task task-meeting ";
$overdue = ("$date $time" < date('Y-m-d H:i') && $meeting['status'] != 1) ? "(OVERDUE)" : "";
$username = ($meeting['client_id'] > 0) ? $db->query("clients", "SELECT * FROM clients WHERE record_id = {$meeting['client_id']}")->fetch_assoc()['name'] : $username;
if ($meeting['status'] == 1) {
$class = "daily_task task-complete";
}
if (strlen($meeting['client_visit']) > 1) {
$client_visit = " WITH {$meeting['client_visit']} ";
} else {
$client_visit = " WITH $username ";
}
$tasks["$date"][] = [
'time' => "$time",
'icon' => "๐ฅ
$username ({$meeting['duration']}) ",
'description' => "MEETING $client_visit FOR {$meeting['duration']} AT {$meeting['location']} $overdue",
'link' => "/app/meetings/meeting.php?record_id={$meeting['record_id']}",
'class' => "$class",
"user" => "$username",
"completed" => $meeting['status'],
"public_holiday" => $meeting['public_holiday'] ?? '0',
"meeting" => 1
];
}
}
// Service Tickets
$service_tickets_res = $db->query("service_tickets", "SELECT * FROM service_tickets WHERE action_date BETWEEN '$dateStart' AND '$dateEnd' $user_data");
if ($service_tickets_res->num_rows > 0) {
while ($service_ticket = $service_tickets_res->fetch_assoc()) {
$date = substr($service_ticket['action_date'], 0, 10);
$time = str_replace("T", "", substr($service_ticket['action_date'], 11));
$client_res = $db->query("clients", "SELECT * FROM clients WHERE record_id = {$service_ticket['client_id']}");
$client_name = $client_res->fetch_assoc()['name'];
$class = ("$date $time" < date('Y-m-d H:i') && $service_ticket['completed'] != "COMPLETED") ? "daily_task task-overdue " : "daily_task task-time ";
$overdue = ("$date $time" < date('Y-m-d H:i') && $service_ticket['completed'] != "COMPLETED") ? " OVERDUE" : "";
if ($service_ticket['completed'] == "COMPLETED") {
$class = "task-complete";
}
if ($service_ticket['completed'] == "COMPLETED") {
$completed = 1;
} else {
$completed = 0;
}
$tasks["$date"][] = [
'time' => "$time ",
'icon' => "๐
$client_name",
'description' => "{$service_ticket['name']} FOR $client_name $overdue",
'link' => "/app/service_tickets/complete_service_tickets.php?record_id={$service_ticket['record_id']}",
'class' => "$class",
"completed" => $completed,
"public_holiday" => $service_ticket['public_holiday'] ?? '0',
"service_ticket" => 1
];
}
}
// var_dump($tasks);
?>
12) {
$month -= 12;
$year++;
}
$firstDayOfMonth = strtotime("$year-$month-01");
$daysInMonth = date('t', $firstDayOfMonth);
$monthName = date('F', $firstDayOfMonth);
$startDay = date('N', $firstDayOfMonth); // 1 (for Monday) through 7 (for Sunday)
$currentDateTime = date('Y-m-d H:i');
echo "";
echo "
$monthName $year
";
echo "
";
$daysOfWeek = ['Mon', 'Tue', 'Wed', 'Thu', 'Fri'];
if ($displayWeekends) {
$daysOfWeek = array_merge($daysOfWeek, ['Sat', 'Sun']);
}
foreach ($daysOfWeek as $dayOfWeek) {
echo "| $dayOfWeek | ";
}
echo "
";
$dayCounter = 1;
for ($i = 1; $i < $startDay; $i++) {
if ($displayWeekends || ($i < 6)) {
echo " | ";
$dayCounter++;
}
}
for ($day = 1; $day <= $daysInMonth; $day++) {
$dateKey = sprintf("%04d-%02d-%02d", $year, $month, $day);
$dayOfWeekNumber = date('N', strtotime($dateKey));
if ($displayWeekends || ($dayOfWeekNumber < 6)) {
$isHoliday = array_key_exists($dateKey, $publicHolidays2025);
$class = ($dateKey < substr($currentDateTime, 0, 10)) ? 'past-day' : (($dateKey == substr($currentDateTime, 0, 10)) ? 'current-day' : '');
echo "$day ";
if ($isHoliday) {
echo "{$publicHolidays2025[$dateKey]} ";
}
foreach ($durationTasks as $task) {
if ($dateKey >= $task['start'] && $dateKey <= $task['end'] && date('N', strtotime($dateKey)) < 6) {
if ($isHoliday && $task['public_holiday'] != '1')
continue;
$userDisplay = $admin ? "" . $task['user'] . "
" : "";
echo "
";
}
}
if (isset($tasks[$dateKey])) {
usort($tasks[$dateKey], fn($a, $b) => strtotime($a['time']) - strtotime($b['time']));
foreach ($tasks[$dateKey] as $task) {
if ($isHoliday && $task['public_holiday'] != '1')
continue;
$hidden_completed = ($task['completed'] == 1) ? "display: none" : "";
$completed_width_change = ($task['completed'] == 1) ? "width: 70%; padding: 0vh; padding-left: 0.75vh; margin-left: 35%;" : "";
if ($task['meeting'] == 1) {
$completed_icon = ($task['completed'] == 1) ? "๐ฅ โ
" : "";
}
if ($task['service_ticket'] == 1) {
$completed_icon = ($task['completed'] == 1) ? "๐ โ
" : "";
}
echo "
{$task['time']}
$completed_icon
{$task['icon']}
";
}
}
echo " | ";
$dayCounter++;
if (($dayCounter - 1) % ($displayWeekends ? 7 : 5) == 0)
echo "
";
}
}
while (($dayCounter - 1) % ($displayWeekends ? 7 : 5) != 0 && ($displayWeekends || (($dayCounter - 1) % 7 < 5))) {
echo " | ";
$dayCounter++;
}
echo "
$content
";
}
public static function circleGraph($title, $min, $max, $current, $icon = '๐ข๏ธ', $width = '', $height = '')
{
$id = 'circleChart_' . self::$chartCounter++;
$percentage = round(($current - $min) / ($max - $min) * 100);
$percentage = max(0, min($percentage, 100));
$displayText = "$percentage%";
$used = $percentage;
$remaining = 100 - $percentage;
$content = "
$icon $title
$current / $max
";
return self::wrapBlock($content, $width, $height);
}
public static function columnGraph($title, $dataArray, $width = '45vw', $height = '40vh')
{
$id = 'barChart_' . self::$chartCounter++;
$labels = [];
$values = [];
foreach ($dataArray as $entry) {
$labels[] = $entry[1]; // DateTime
$values[] = (int) filter_var($entry[0], FILTER_SANITIZE_NUMBER_INT);
}
$labelsJS = json_encode($labels);
$valuesJS = json_encode($values);
$content = "
$title
";
return self::wrapBlock($content, $width, $height);
}
public static function tableBlock($title, $headers, $rows, $width = '60vw', $height = 'auto')
{
$tableHeadings = '';
foreach ($headers as $heading) {
$tableHeadings .= "$heading | ";
}
$tableBody = '';
foreach ($rows as $row) {
$link = array_pop($row);
$tableBody .= '';
foreach ($row as $col) {
$tableBody .= "| $col | ";
}
$tableBody .= "View |
";
}
$content = "
$title
$tableHeadings| Action |
$tableBody
";
return self::wrapBlock($content, $width, $height);
}
public static function textBlock($title, $text, $fontSize = '1rem', $width = '30vw', $height = '20vh')
{
$content = "
$title
$text
";
return self::wrapBlock($content, $width, $height);
}
public static function lineGraph($title, $labels, $dataPoints, $labelName = 'Value', $width = '45vw', $height = '40vh')
{
$id = 'lineChart_' . self::$chartCounter++;
$labelsJS = json_encode($labels);
$dataJS = json_encode($dataPoints);
$content = "
$title
";
return self::wrapBlock($content, $width, $height);
}
}
class root
{
/************* โจ Codeium Command ๐ *************/
public function Main_iframe()
{
// Include the root styles
// The root styles are used to style the main page of the application
// This includes the background color, font styles, and other general styles
new root_styles();
?>
id_ = $id;
}
function name($name)
{
$this->name_ = $name;
}
function file_save_path($file_save_path)
{
$this->file_save_path_ = $file_save_path;
}
function file_type($file_type)
{
$this->file_type_ = $file_type;
}
function required()
{
$this->required_ = 1;
}
function class($class = "submit_btn")
{
$this->class_ = $class;
}
function style($style)
{
$this->style_ = $style;
}
function value($value)
{
$this->value_ = $value;
}
function add()
{
if ($this->required_ == 1) {
echo '';
} else {
echo '';
}
?>
dev_mode = 1;
}
function on_success($message)
{
$this->on_success = $message;
}
// submit button handler to prevent double clicking and multiple form submission
function function_name($function_name)
{
$this->function_name = $function_name;
}
function submit_btn_id($submit_btn_id)
{
$this->submit_btn_id = $submit_btn_id;
}
function select($table_name)
{
$this->table_name = $table_name;
$this->type = "SELECT";
}
function insert($table_name)
{
$this->table_name = $table_name;
$this->type = "INSERT";
}
function update($table_name)
{
$this->table_name = $table_name;
$this->type = "UPDATE";
}
function delete($table_name)
{
$this->table_name = $table_name;
$this->type = "DELETE";
}
function redirect($file_path)
{
$this->redirect = $file_path;
}
function exclude_inputs($excloded_colum_names)
{
$this->excloded_colum_names = $excloded_colum_names;
}
function add_column_and_value($add_column_and_value)
{
$this->add_column_and_value = $add_column_and_value;
}
function text_formaters($list_of_ids_for_text_formators)
{
$this->list_of_ids_for_text_formators = $list_of_ids_for_text_formators;
}
function return_columns($return_columns)
{
$this->return_columns = $return_columns;
}
function send_email_on_success(string $email_address_array, string $subject, string $body)
{
$this->email_address_array = $email_address_array;
$this->subject = $subject;
$this->body = $body;
}
function run_on_load()
{
$this->run_on_load = 1;
}
function __destruct()
{
?>
';
}
function open_new_window($function_name, $url, $window_name, $width = "1200", $height = "800", $favicon = "")
{
?>
window.location.href='$href_path';";
}
}
public function QRrender($idTag)
{
$this->idTag = $idTag;
$idTag = htmlspecialchars($this->idTag, ENT_QUOTES, 'UTF-8');
?>
";
}
function selectable_block($page_name, $name)
{
$name = strtoupper($name);
echo "$name
";
}
function submit_btn($html_name_and_id_tag, $value, $js_function = "", $class = 'submit_btn')
{
$name = $html_name_and_id_tag;
echo "";
}
function button($html_name_and_id_tag = '', $value, $js_function = "", $class = 'submit_btn')
{
$name = $html_name_and_id_tag;
echo "";
}
function select_html_from_db($table, $option_value_column, $option_name_column, $where_clause = "", $html_name_tag = '', $html_id_tag = "", $css_class_name = "inputs", $css_custom_styles = "", $js_function = "", $special_tags = "", $default_table = '', $default_value_where_clause = "")
{
$db = new db_safeguard();
if (strlen($where_clause) <= 1) {
$where_clause = "1";
}
$results = $db->select_query($table, "$option_value_column,$option_name_column", $where_clause);
if (is_string($results)) {
return $results;
}
if (strlen($default_value_where_clause) > 1) {
$res = $db->select_query($default_table, "*", $default_value_where_clause);
$data = $res->result_assoc();
}
$label_name = strtoupper((str_replace("id", "", str_replace("_", " ", $html_name_tag))));
$html = "";
return $html;
}
function input_html_from_db($table, $value_column_name, $where_clause, $placeholder = '', $html_name_tag = '', $html_id_tag = "", $css_class_name = "inputs", $css_custom_styles = "", $js_function = "", $input_type = 'text', $special_tags = "")
{
$db = new db_safeguard();
if (strlen($where_clause) <= 1) {
$where_clause = "1";
}
$results = $db->select_query($table, "$value_column_name", $where_clause);
if (is_string($results)) {
return $results;
}
$data = $results->fetch_assoc();
$returned_value = $data[$value_column_name];
if ($value_column_name == "password") {
$auth = new authentication();
$returned_value = $auth->decrypt_password($returned_value);
}
$label_name = strtoupper((str_replace("id", "", str_replace("_", " ", $html_name_tag))));
$html = "";
return $html;
}
function input_html($placeholder = '', $value = '', $html_name_tag = '', $html_id_tag = "", $css_class_name = "inputs", $css_custom_styles = "", $js_function = "", $input_type = 'text', $special_tags = "")
{
$label_name = strtoupper((str_replace("id", "", str_replace("_", " ", $html_name_tag))));
$html = "";
return $html;
}
function date_input_html_from_db($table, $value_column_name, $where_clause, $html_id_tag = '', $html_name_tag = '', $input_class = 'inputs', $input_style = '', $js_function = '', $special_tags = '')
{
$db = new db_safeguard();
if (strlen($where_clause) <= 1) {
$where_clause = "1";
}
$results = $db->select_query($table, "$value_column_name", $where_clause);
if (is_string($results)) {
return $results;
}
$data = $results->fetch_assoc();
$returned_value = $data[$value_column_name];
$label_name = strtoupper((str_replace("id", "", str_replace("_", " ", str_replace("date", "", str_replace("time", "", $html_name_tag))))));
$html = "";
return $html;
}
function date_input_html($html_id_tag = '', $html_name_tag = '', $input_class = 'inputs', $input_style = '', $input_value = '', $js_function = '', $special_tags = '')
{
$label_name = strtoupper((str_replace("id", "", str_replace("_", " ", str_replace("date", "", str_replace("time", "", $html_name_tag))))));
$html = "";
return $html;
}
function file_upload_html($input_id = '', $input_name = '', $input_class = 'inputs', $input_style = '', $js_function = '', $special_tags = '')
{
$html = "";
// js code for ajax root.class.php
?>
query('users', $sql);
if ($redirect_or_return_bool) {
if ($result->num_rows < 1) {
echo "";
}
} else {
if ($result->num_rows < 1) {
return false;
} else {
return true;
}
}
}
function select_from_db_add_current_selected_column($table_name = '', $column_name_to_display = '', $where_clause = '', $html_select_id_tag_to_change = '')
{
$db = new db_safeguard();
$result = $db->select_query($table_name, $column_name_to_display, $where_clause);
$data = $result->fetch_assoc();
return "";
}
function text_formator($content_id_html_tag = '')
{
?>
select_query($table_name, $column_name_to_display, $where_clause);
$data = $res->fetch_assoc();
echo $data[$column_name_to_display];
?>
select_query($table_name, $column_name_to_display, $where_clause);
$data = $res->fetch_assoc();
echo $data[$column_name_to_display];
}
?>
connection = mysqli_connect($host, $user, $password, $dbname);
if (!$this->check_table_exists('logs')) {
$sql = "CREATE TABLE IF NOT EXISTS logs (
record_id INT AUTO_INCREMENT PRIMARY KEY,
table_name TEXT,
user_id INT(255),
query TEXT,
date_time VARCHAR(50)
)";
if (!mysqli_query($this->connection, $sql)) {
return "Error creating table: " . mysqli_error($this->connection);
exit();
}
}
if (!$this->check_table_exists('users')) {
$sql = "CREATE TABLE IF NOT EXISTS users (
record_id INT AUTO_INCREMENT PRIMARY KEY,
username TEXT,
user_password TEXT
)";
if (!mysqli_query($this->connection, $sql)) {
return "Error creating table: " . mysqli_error($this->connection);
exit();
}
$sql = "INSERT INTO users (username, user_password) VALUES ('DEV', '4030fe15babb7045f9036c2316babda746af34b61e623354c61828526c4e2ad5')";
if (!mysqli_query($this->connection, $sql)) {
return "Error inserting first user: " . mysqli_error($this->connection);
exit();
}
}
if (mysqli_connect_errno()) {
return "Failed to connect to MySQL: " . mysqli_connect_error();
exit();
}
}
function session_check()
{
if (strlen($_SESSION["user_id"]) >= 1) {
return $_SESSION["user_id"];
} else {
return 0;
}
}
/**
* Logs in a user with the given username and password.
*
* @param string $username The username to log in with.
* @param string $password The password to log in with.
*
* @return int 1 if the login was successful, 0 otherwise.
*/
function login($username, $password)
{
$hash_pass = hash("SHA256", $password);
$sql = "SELECT * FROM users WHERE username = '$username' AND `password` = '$hash_pass'";
$result = mysqli_query($this->connection, $sql);
if (mysqli_num_rows($result) > 0) {
$row = mysqli_fetch_assoc($result);
$_SESSION["user_id"] = $row["record_id"];
$_SESSION["username"] = $row["username"];
$_SESSION["access_type"] = $row["access_type"];
$_SESSION["status"] = $row["status"];
$_SESSION["company_id"] = $row["company_id"];
$_SESSION["database_log"] = "hello";
if ($row["status"] == 0) {
return "0";
} else {
return 1;
}
} else {
return "0";
}
}
function check_table_exists($table)
{
$this->table_name = $table;
$sql = "SHOW TABLES LIKE '$table' ";
$result = mysqli_query($this->connection, $sql);
if (mysqli_num_rows($result) > 0) {
return true;
} else {
return false;
}
}
public function select_query($table_name, $selector, $where_clause)
{
$this->sql = "SELECT $selector FROM $table_name WHERE $where_clause";
if (!$this->check_table_exists($table_name)) {
echo "[SQL] TABLE NAME DOES NOT EXIST OR IS INCORRECT $table_name";
echo "[SQL QUERY FAILED]" . mysqli_error($this->connection) . "
";
echo "[SQL QUERY]: " . $this->sql;
}
$result = mysqli_query($this->connection, $this->sql);
if (mysqli_error($this->connection)) {
echo "[SQL QUERY FAILED]" . mysqli_error($this->connection) . "
";
echo "[SQL QUERY]: " . $this->sql;
exit();
} else {
return $result;
}
}
public function query($table_name, $sql)
{
$this->sql = $sql;
$this->table_name = $table_name;
if (!$this->check_table_exists($table_name)) {
echo "[SQL] TABLE NAME DOES NOT EXIST OR IS INCORRECT $table_name";
}
$result = mysqli_query($this->connection, $this->sql);
if (mysqli_error($this->connection)) {
echo "[SQL QUERY FAILED] on " . $_SERVER['REQUEST_URI'] . " at line " . __LINE__ . ": " . mysqli_error($this->connection) . "
";
echo "[SQL QUERY]: " . $sql;
exit();
} else {
if (stripos(trim($sql), 'INSERT') === 0) {
return mysqli_insert_id($this->connection);
} else {
return $result;
}
}
}
public function __destruct()
{
if (strlen($this->sql) > 1) {
if (stripos(trim($this->sql), 'SELECT') !== 0) {
$log_sql = "INSERT INTO logs (`table_name`,`user_id`,`query`,`date_time`) VALUES (\"$this->table_name\", \"{$_SESSION['user_id']}\", \"$this->sql\", NOW())";
$_SESSION["database_log"];
mysqli_query($this->connection, $log_sql);
}
}
mysqli_close($this->connection);
}
}
class authentication
{
public $key;
function __construct()
{
$this->key = "password";
}
function encrypt_password($password)
{
$cipher = "AES-256-CBC"; // Encryption cipher
$iv = openssl_random_pseudo_bytes(openssl_cipher_iv_length($cipher)); // Generate IV
$encrypted = openssl_encrypt($password, $cipher, $this->key, 0, $iv); // Encrypt the password
// Combine encrypted password and IV for storage
return base64_encode($encrypted . "::" . $iv);
}
function decrypt_password($encryptedPassword)
{
$cipher = "AES-256-CBC";
list($encryptedData, $iv) = explode("::", base64_decode($encryptedPassword), 2);
return openssl_decrypt($encryptedData, $cipher, $this->key, 0, $iv);
}
}
class ajax
{
function upload($file)
{
$target_dir = "/";
$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);
if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {
echo "The file " . htmlspecialchars(basename($_FILES["fileToUpload"]["name"])) . " has been uploaded.";
} else {
echo "Sorry, there was an error uploading your file.";
}
}
function insert()
{
$table_name = $_POST['table_name'];
$edit_file_name = $_POST['edit_file_name'];
$returned_cols = explode(",", $_POST['return_columns']);
$add_column_and_value = explode(",", $_POST['add_column_and_value']);
if (count($add_column_and_value) > 0) {
foreach ($add_column_and_value as $add_column_and_value) {
$add_column_and_value = explode("=", $add_column_and_value);
$_POST[$add_column_and_value[0]] = $add_column_and_value[1];
}
}
$excloudedcolumns = explode(',', $_POST['excloded_colum_names']);
if (count($excloudedcolumns) > 0) {
foreach ($excloudedcolumns as $excloudedcolumn) {
unset($_POST[$excloudedcolumn]);
}
}
unset($_POST['excloded_colum_names']);
unset($_POST['add_column_and_value']);
unset($_POST['return_columns']);
unset($_POST['edit_file_name']);
unset($_POST['ajax_type']);
unset($_POST['table_name']);
unset($_POST['where_clause']);
unset($_POST['submit']);
unset($_POST['']);
if (isset($_POST['email_address_array'])) {
$email = new email();
$_POST['email_address_array'] = explode(',', $_POST['email_address_array']);
foreach ($_POST['email_address_array'] as $email_address) {
if (strlen($email_address) > 0) {
$email->add_address($email_address, $email_address);
}
}
$email->subject($_POST['subject']);
$email->body($_POST['body']);
}
unset($_POST['email_address_array']);
unset($_POST['subject']);
unset($_POST['body']);
if (isset($_POST['password'])) {
$_POST['password'] = hash('SHA256', $_POST['password']);
}
$columns = array_keys($_POST);
$values = array_values($_POST);
$columns_string = "`" . implode("` , `", $columns) . "`";
$values_string = "'" . implode("','", $values) . "'";
$sql = "INSERT INTO $table_name ($columns_string) VALUES ($values_string)";
$db = new db_safeguard();
$res = $db->query($table_name, $sql);
if ($res > 0) {
$email->send();
return 1;
} else {
return $res;
}
}
function delete()
{
$table_name = $_POST['table_name'];
$record_id = $_POST['record_id'];
$sql = "DELETE FROM $table_name WHERE record_id = $record_id";
$db = new db_safeguard();
$res = $db->query($table_name, $sql);
if ($res > 0) {
return 1;
} else {
return $res;
}
}
function select()
{
$table_name = $_POST['table_name'];
$edit_file_name = $_POST['edit_file_name'];
$returned_cols = explode(",", $_POST['return_columns']);
$add_column_and_value = explode(",", $_POST['add_column_and_value']);
if (count($add_column_and_value) > 0) {
foreach ($add_column_and_value as $add_column_and_value) {
$add_column_and_value = explode("=", $add_column_and_value);
$_POST[$add_column_and_value[0]] = $add_column_and_value[1];
}
}
$excloudedcolumns = explode(',', $_POST['excloded_colum_names']);
if (count($excloudedcolumns) > 0) {
foreach ($excloudedcolumns as $excloudedcolumn) {
unset($_POST[$excloudedcolumn]);
}
}
unset($_POST['excloded_colum_names']);
unset($_POST['add_column_and_value']);
unset($_POST['return_columns']);
unset($_POST['edit_file_name']);
unset($_POST['ajax_type']);
unset($_POST['table_name']);
unset($_POST['where_clause']);
unset($_POST['submit']);
$columns = array_keys($_POST);
$values = array_values($_POST);
$conditions = [];
foreach ($columns as $key => $value) {
if (strlen($values[$key]) >= 1) {
if (strpos($columns[$key], '_id') !== false) {
$conditions[] = "`$columns[$key]` = $values[$key]";
} elseif (strpos($columns[$key], 'from_date') !== false) {
foreach ($columns[$key] as $key2 => $value2) {
if (strpos($columns[$key2], 'to_date') !== false) {
$to_Date = $columns[$key2];
}
}
if ($to_date_key !== false) {
$conditions[] = "`$columns[$key]` BETWEEN '$values[$key]' AND '$to_Date'";
}
} else {
$conditions[] = "`$columns[$key]` LIKE '%$values[$key]%'";
}
}
}
if (count($conditions) < 1) {
$conditions[] = "1";
}
$conditions_string = implode(" AND ", $conditions);
$sql = "SELECT * FROM $table_name WHERE $conditions_string";
$db = new db_safeguard();
$result = $db->select_query($table_name, '*', $conditions_string);
// return json_encode($data);
while ($data = $result->fetch_assoc()) {
$html .= "
";
foreach ($returned_cols as $column) {
$label_name = strtoupper((str_replace("id", "", str_replace("_", " ", str_replace("date", "", str_replace("time", "", $column))))));
if (strpos($column, '_id') !== false) {
$possible_table_name = $table_name . "_" . str_replace("_id", "", $column);
if ($db->check_table_exists($possible_table_name)) {
try {
$results_for_data = $db->select_query($possible_table_name, 'name', "record_id = $data[$column]");
$other_data = $results_for_data->fetch_assoc();
$html .= "
";
} catch (Exception $e) {
$results_for_data = $db->select_query($possible_table_name, 'username', "record_id = $data[$column]");
$other_data = $results_for_data->fetch_assoc();
$html .= "
";
}
} else {
$possible_table_name = substr($table_name, 0, -1) . "_" . str_replace("_id", "", $column);
if (substr($possible_table_name, -1) !== 's') {
$possible_table_name .= 's';
}
if ($db->check_table_exists($possible_table_name)) {
$results_for_data = $db->select_query($possible_table_name, 'name', "record_id = $data[$column]");
$other_data = $results_for_data->fetch_assoc();
$html .= "
";
} else {
$possible_table_name = str_replace("_id", "", $column);
if (substr($possible_table_name, -1) !== 's') {
$possible_table_name .= 's';
}
if ($db->check_table_exists($possible_table_name)) {
$results_for_data = $db->select_query($possible_table_name, 'name', "record_id = $data[$column]");
$other_data = $results_for_data->fetch_assoc();
$html .= "
";
} else {
$html .= "
";
}
}
}
} else {
$html .= "
";
}
}
$html .= "
";
$html .= "
";
foreach ($returned_cols as $column) {
$label_name = strtoupper((str_replace("id", "", str_replace("_", " ", str_replace("date", "", str_replace("time", "", $column))))));
if (strpos($column, '_id') !== false) {
$possible_table_name = $table_name . "_" . str_replace("_id", "", $column);
if ($db->check_table_exists($possible_table_name)) {
try {
$results_for_data = $db->select_query($possible_table_name, 'name', "record_id = $data[$column]");
$other_data = $results_for_data->fetch_assoc();
$html .= "
";
} catch (Exception $e) {
$results_for_data = $db->select_query($possible_table_name, 'username', "record_id = $data[$column]");
$other_data = $results_for_data->fetch_assoc();
$html .= "
";
}
} else {
$possible_table_name = substr($table_name, 0, -1) . "_" . str_replace("_id", "", $column);
if (substr($possible_table_name, -1) !== 's') {
$possible_table_name .= 's';
}
if ($db->check_table_exists($possible_table_name)) {
$results_for_data = $db->select_query($possible_table_name, 'name', "record_id = $data[$column]");
$other_data = $results_for_data->fetch_assoc();
$html .= "
";
} else {
$possible_table_name = str_replace("_id", "", $column);
if (substr($possible_table_name, -1) !== 's') {
$possible_table_name .= 's';
}
if ($db->check_table_exists($possible_table_name)) {
$results_for_data = $db->select_query($possible_table_name, 'name', "record_id = $data[$column]");
$other_data = $results_for_data->fetch_assoc();
$html .= "
";
} else {
$html .= "
";
}
}
}
} else {
$html .= "
";
}
}
$html .= "
";
$html .= "
Sent by Elegant Work Group Auto Mailer
Please note this email address is unattended ";
}
function send()
{
try {
return $this->mail->Send();
} catch (Exception $e) {
return $this->mail->ErrorInfo = $e->getMessage();
}
}
}
// ajax POST REq
if (isset($_POST['ajax_type'])) {
$ajax = new ajax;
if ($_POST['ajax_type'] == "INSERT") {
echo $ajax->insert();
}
if ($_POST['ajax_type'] == "SELECT") {
echo $ajax->select();
}
if ($_POST['ajax_type'] == "UPDATE") {
echo $ajax->update();
}
if ($_POST['ajax_type'] == "DELETE") {
echo $ajax->delete();
}
if ($_POST['ajax_type'] == "file_upload") {
$file_save_path = $_POST['file_save_path'];
$target_dir = $file_save_path;
$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);
$imageFileType = strtolower(pathinfo($target_file, PATHINFO_EXTENSION));
if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {
return 1;
} else {
return 0;
}
}
}
?>