}
function getServiceCategoryDetail($category_alias)
{
$sql = "SELECT category_id FROM `tbl_service_category` WHERE `category_alias` = '{$category_alias}'";
$result = $this->fetchData('single', $sql);
return $result;
}
function getServiceCategories()
{
$sql = "SELECT * FROM `tbl_service_category` ORDER BY `category_order`";
$result = $this->fetchData('multiple', $sql);
return $result;
}
}
/* --- CONSTRUCT CLASS --- */
$_global = new HeaderGlobal();
/*
# ----------------------------------------------------------------------
# DEFINED VARIABLE
# ----------------------------------------------------------------------
*/
/* --- ACTION PAGE --- */
if (isset($_REQUEST['act']) && $_REQUEST['act'] != '' && $_REQUEST['act'] != 'empty') {
$_temp_act = $_REQUEST['act'];
} else {
$_temp_act = 'empty';
}
/* --- USER LOGIN --- */
if (isset($_SESSION['account'])) {
$_global_user_temp = $_SESSION['account']['login_id'];
} else {
}
function update_log($order_id, $description, $note, $created_date)
{
$sql = "INSERT INTO `tbl_order_log` (order_id, `description`, `note`, `created_date`) VALUES(?, ?, ?, ?)";
$stmt = $this->conn->prepare($sql);
if ($stmt === false) {
trigger_error('Database error: ' . $sql . ' Error: ' . $this->conn->errno . ' ' . $this->conn->error, E_USER_ERROR);
} else {
$stmt->bind_param("isss", $order_id, $description, $note, $created_date);
$stmt->execute();
}
$stmt->close();
}
}
/* --- CONSTRUCT CLASS --- */
$_global = new HeaderGlobal();
/*
# ----------------------------------------------------------------------
# DEFINED VARIABLE
# ----------------------------------------------------------------------
*/
/* --- ACTION PAGE --- */
if (isset($_REQUEST['act']) && $_REQUEST['act'] != '' && $_REQUEST['act'] != 'empty') {
$_temp_act = $_REQUEST['act'];
} else {
$_temp_act = 'empty';
}
/* --- USER LOGIN --- */
if (isset($_SESSION['account'])) {
$_global_user_temp = $_SESSION['account']['login_id'];
} else {