function makeadminchild($con, $groupid, $memberid)
{
$status = true;
//ทำให้ user เป็น admin ของกลุ่มลูกทั้งหมด
$allgroupid = findallchild($groupid, $con);
foreach ($allgroupid as $eachgroupid) {
//check ว่าอยู่ในกลุ่มนั้นรึป่าว
$sqlcheck_is_in = "SELECT * FROM `has_user` WHERE `has_user`.`user_id` = '{$memberid}' AND `has_user`.`group_id` = '{$groupid}'";
$querycheck_is_in = $con->query($sqlcheck_is_in);
if ($querycheck_is_in->num_rows > 0) {
//ถ้าอยู่ update
$sqlupdateadmin = "UPDATE `workingalert`.`has_user` SET `role_id` = '1' WHERE `has_user`.`user_id` ='{$memberid}' AND `has_user`.`group_id` = '{$eachgroupid}'";
if ($con->query($sqlupdateadmin)) {
} else {
$status = false;
}
} else {
//ถ้าไม่ insert
$sqlinsertadmin = "INSERT INTO `workingalert`.`has_user` (`user_id`, `group_id`, `role_id`) VALUES ('{$memberid}', '{$eachgroupid}', '1');";
if ($con->query($sqlinsertadmin)) {
} else {
$status = false;
}
}
}
return $status;
}
function findAllDestinationUserId($con, $groupid, $msgid)
{
$result = array();
$allgroupid = findallchild($groupid, $con);
$tempuserid = array();
foreach ($allgroupid as $eachgroupid) {
//loop เอาค่าแต่ละตัวในอาเรย์ allgroupid
$sqlgetalluserid = "SELECT `has_user`.`user_id` FROM `has_user`\n WHERE `has_user`.`group_id` = '{$eachgroupid}'\n AND `has_user`.`role_id` != '0'";
$queryallId = $con->query($sqlgetalluserid);
if ($queryallId->num_rows > 0) {
//ใส่ userid ทั้งหมดลงใน $tempuserid
while ($roo = $queryallId->fetch_assoc()) {
array_push($tempuserid, $roo['user_id']);
}
$pathmsg = findparentpath($eachgroupid, $con);
foreach ($tempuserid as $eachuserid) {
$sqlinserthasmessage = "INSERT INTO `workingalert`.`has_message`\n (`message_id` ,`user_id` ,`group_id`,`pathmsg`)\n VALUES ('{$msgid}', '{$eachuserid}', '{$eachgroupid}', '{$pathmsg}');";
if ($con->query($sqlinserthasmessage) === TRUE) {
//insert ลงตารางสำเร็จก็เก็บ user id ไว้ push
array_push($result, $eachuserid);
}
}
}
}
return $result;
}
