add_styles_page(); $db = new db_safeguard(); $html->check_user_type("ADMIN"); $record_id = new input(); $record_id->type("hidden"); $record_id->name("record_id"); $record_id->value($_GET["record_id"]); $record_id->id("record_id"); $record_id->name("record_id"); $name_label = new label(); $name_label->for("name"); $name_label->value("TEAM NAME"); $name = new input(); $name->class("inputs"); $name->type("text"); $name->placeholder("NAME"); $name->name("name"); $name->id("name"); $name->value_from_db("teams", "name", "record_id = {$_GET["record_id"]}"); $asset_rows = new input(); $asset_rows->type("text"); $asset_rows->class("submit_btn"); $asset_rows->readonly(); $asset_rows->onclick("add_assets()"); $asset_rows->value("ADD ASSETS"); $team_rows = new input(); $team_rows->type("text"); $team_rows->class("submit_btn"); $team_rows->readonly(); $team_rows->onclick("add_teams()"); $team_rows->value("ADD TEAMS"); $status_label = new label(); $status_label->for("status"); $status_label->value("STATUS"); $status = new select(); $status->class("inputs"); $status->name("status"); $status->id("status"); $status->add_option("", "STATUS"); $status->add_option("ACTIVE", "ACTIVE"); $status->add_option("INACTIVE", "INACTIVE"); $submit_btn = new button(); $submit_btn->value("UPDATE"); // $submit_btn->onclick("ajax_function()"); $ass_type_res = $db->query("asset_type", "SELECT * FROM asset_type"); $asset_types = []; while ($ass_type = $ass_type_res->fetch_assoc()) { $asset_types[] = $ass_type['name']; $ass_res = $db->query("assets", "SELECT * FROM assets WHERE asset_type_id = $ass_type[record_id]"); $ass_num = $ass_res->num_rows; $ass_per_col = ceil($ass_num / 3); $assets = []; while ($ass = $ass_res->fetch_assoc()) { $assets[] = $ass['name']; } $table_blocks = $table_blocks . ""; for ($i = 0; $i < $ass_per_col; $i++) { $table_blocks = $table_blocks . ""; for ($j = 0; $j < 3; $j++) { $index = $i + ($j * $ass_per_col); if (isset($assets[$index])) { $table_blocks = $table_blocks . ""; } } $table_blocks = $table_blocks . ""; } $table_blocks = $table_blocks . ""; } $ass_options = ""; $ass_type_options = ""; ////// $teams_data_res = $db->query("teams", "SELECT * FROM teams WHERE record_id = {$_GET["record_id"]}"); $teams_data = $teams_data_res->fetch_assoc(); $assets_names = explode(", ", $teams_data["assigned_assets"]); //get the number of values in the array $num_assets = count($assets_names); foreach ($assets_names as $asset_name) { $ass_options = $ass_options . ""; } $member_name = explode(", ", $teams_data["team_members"]); $num_members = count($member_name); $all_assets_res = $db->query("assets", "SELECT * FROM assets"); $all_assets_options = ""; while ($all_assets = $all_assets_res->fetch_assoc()) { $all_assets_options = $all_assets_options . ""; } $all_users_res = $db->query("users", "SELECT * FROM users"); $all_users_options = ""; while ($all_users = $all_users_res->fetch_assoc()) { $all_users_options = $all_users_options . ""; } ?>

EDIT TEAM

add(); $name_label->add(); $name->add(); ?>

type("hidden"); $no_assets_rows->name("no_asset_row"); $no_assets_rows->id("no_asset_row"); $no_assets_rows->value($num_assets); $no_assets_rows->add(); ?>

ASSETS

add(); ?>

type("hidden"); $no_team_rows->name("no_team_row"); $no_team_rows->id("no_team_row"); $no_team_rows->value($num_members); $no_team_rows->add(); ?>

TEAMS

add(); ?>

add(); $status->add(); $submit_btn->add(); ?>