62 lines
2.2 KiB
PHP
62 lines
2.2 KiB
PHP
<?php
|
|
$sub_menu = "900600";
|
|
include_once('./_common.php');
|
|
|
|
auth_check_menu($auth, $sub_menu, "r");
|
|
|
|
$post_chk_fg_no = (isset($_POST['chk_fg_no']) && is_array($_POST['chk_fg_no'])) ? $_POST['chk_fg_no'] : array();
|
|
|
|
if(!count($post_chk_fg_no))
|
|
alert('이모티콘을 이동할 그룹을 한개 이상 선택해 주십시오.', $url);
|
|
|
|
$fo_no_list = isset($_POST['fo_no_list']) ? preg_replace('/[^a-zA-Z0-9\, ]/', '', $_POST['fo_no_list']) : '';
|
|
|
|
$sql = "select * from {$g5['sms5_form_table']} where fo_no in ($fo_no_list) order by fo_no desc ";
|
|
$result = sql_query($sql);
|
|
$save = array();
|
|
for ($kk=0;$row = sql_fetch_array($result);$kk++)
|
|
{
|
|
$fo_no = $row['fo_no'];
|
|
for ($i=0; $i<count($post_chk_fg_no); $i++)
|
|
{
|
|
$fg_no = $post_chk_fg_no[$i];
|
|
if( !$fg_no ) continue;
|
|
$group = sql_fetch("select * from {$g5['sms5_form_group_table']} where fg_no = '$fg_no'");
|
|
$sql = " insert into {$g5['sms5_form_table']}
|
|
set fg_no='$fg_no',
|
|
fg_member='".$group['fg_member']."',
|
|
fo_name='".addslashes($row['fo_name'])."',
|
|
fo_content='".addslashes($row['fo_content'])."',
|
|
fo_datetime='".G5_TIME_YMDHIS."' ";
|
|
sql_query($sql);
|
|
sql_query("update {$g5['sms5_form_group_table']} set fg_count = fg_count + 1 where fg_no='$fg_no'");
|
|
}
|
|
$save[$kk]['fo_no'] = $row['fo_no'];
|
|
$save[$kk]['fg_no'] = $row['fg_no'];
|
|
}
|
|
|
|
if ($sw == 'move')
|
|
{
|
|
foreach ($save as $v)
|
|
{
|
|
if( empty($v['fo_no']) ) continue;
|
|
sql_query(" delete from {$g5['sms5_form_table']} where fo_no = '{$v['fo_no']}' ");
|
|
sql_query("update {$g5['sms5_form_group_table']} set fg_count = fg_count - 1 where fg_no='{$v['fg_no']}'");
|
|
}
|
|
}
|
|
|
|
$msg = '해당 이모티콘을 선택한 그룹으로 이동 하였습니다.';
|
|
$opener_href = './form_list.php?page='.$page;
|
|
?>
|
|
<meta http-equiv="content-type" content="text/html; charset=utf-8">
|
|
<script>
|
|
alert("<?php echo $msg; ?>");
|
|
opener.document.location.href = "<?php echo $opener_href; ?>";
|
|
window.close();
|
|
</script>
|
|
<noscript>
|
|
<p>
|
|
<?php echo $msg; ?>
|
|
</p>
|
|
<a href="<?php echo $opener_href; ?>">돌아가기</a>
|
|
</noscript>
|