query("teams","INSERT INTO teams (`name`, `asset_type_id`, `assigned_assets`, `team_members`, `status`) VALUES('$name', '$assets_type_id', '$assigned_assets', '$team_members', '$status')");
// echo "INSERT INTO teams (`name`, `asset_type_id`, `assigned_assets`, `team_members`, `status`) VALUES('$name', '$assets_type_id', '$assigned_assets', '$team_members', '$status')";
// if ($res) {
// echo 1;
// } else {
// echo 0;
// }
// echo "
";
// echo "
Name: " . ($_POST['name'] ?? '');
// echo "
Status: " . ($_POST['status'] ?? '');
$num_assets = (int) ($_POST['no_asset_row'] ?? 0);
// echo "
Number of Asset Rows: " . $num_assets;
$num_members = (int) ($_POST['no_team_row'] ?? 0);
// echo "
Number of Member Rows: " . $num_members;
// echo "
";
// get all the assets and put them in an array
$assets = [];
for ($i = 1; $i <= $num_assets; $i++) {
$asset_value = $_POST["assigned_asset_$i"] ?? ' ';
if ($asset_value == ' ') {
continue;
} else {
$assets[] = ["assigned_assets" => $asset_value];
// echo "
INDEX: " . $i;
// echo "
Assets: " . $asset_value;
// echo " Added
";
}
}
$all_assets = array_column($assets, 'assigned_assets');
$assets_names = implode(", ", $all_assets);
// echo "
Asset Names : " . $assets_names;
echo "
";
$members = [];
for ($j = 1; $j <= $num_members; $j++) {
$member_value = $_POST["team_members_$j"] ?? ' ';
// echo "
Member Value: " . $member_value;
echo "UPDATE users SET team_id = '{$_POST['name']}' WHERE username = '$member_value'";
$db->query("users", "UPDATE users SET team_id = '{$_POST['name']}' WHERE username = '$member_value'");
if ($member_value == ' ') {
continue;
} else {
$members[] = ["team_members" => $member_value];
// echo "
INDEX: " . $j;
// echo "
Team Members: " . $member_value;
// echo " Added
";
}
}
$all_members = array_column($members, 'team_members');
$member_name = implode(", ", $all_members);
// echo "
Member Names : " . $member_name;
// echo "
";
// echo "
// INSERT INTO teams (`name`, `assigned_assets`, `team_members`, `status`) VALUES('{$_POST['name']}', '$assets_names', '$member_name', '{$_POST['status']}');
// ";
$res = $db->query("teams", "INSERT INTO teams (`name`, `assigned_assets`, `team_members`, `status`) VALUES('{$_POST['name']}','$assets_names', '$member_name', '{$_POST['status']}')");
if ($res) {
echo "";
} else {
echo 0;
}