OLDBOY/adm/shop_admin/itemcopyupdate.php



<title>OLDBOY/adm/shop_admin/itemcopyupdate.php</title>


<div class="header">OLDBOY/adm/shop_admin/itemcopyupdate.php</div>
<pre>&lt;?php
$sub_menu = &#039;400300&#039;;
include_once(&#039;./_common.php&#039;);

auth_check_menu($auth, $sub_menu, &quot;w&quot;);

check_admin_token();

$ca_id = isset($_REQUEST[&#039;ca_id&#039;]) ? preg_replace(&#039;/[^0-9a-z]/i&#039;, &#039;&#039;, $_REQUEST[&#039;ca_id&#039;]) : &#039;&#039;;
$it_id = isset($_REQUEST[&#039;it_id&#039;]) ? safe_replace_regex($_REQUEST[&#039;it_id&#039;], &#039;it_id&#039;) : &#039;&#039;;

if ($is_admin != &quot;super&quot;)
    alert(&quot;최고관리자만 접근 가능합니다.&quot;);

if (!trim($it_id))
	alert(&quot;복사할 상품코드가 없습니다.&quot;);

if(isset($_POST[&#039;new_it_id&#039;]) &amp;&amp; preg_match(&#039;/[^A-Za-z0-9\-_]+/&#039;, $_POST[&#039;new_it_id&#039;]))
    alert(&quot;상품코드는 영문자, 숫자, -, _ 만 사용할 수 있습니다.&quot;);

$new_it_id = isset($_REQUEST[&#039;new_it_id&#039;]) ? preg_replace(&quot;/[^A-Za-z0-9\-_]/&quot;, &quot;&quot;, $_REQUEST[&#039;new_it_id&#039;]) : &#039;&#039;;

if( ! $new_it_id ) alert(&#039;상품코드를 입력해 주세요.&#039;);

$row = sql_fetch(&quot; select count(*) as cnt from {$g5[&#039;g5_shop_item_table&#039;]} where it_id = &#039;$new_it_id&#039; &quot;);
if (isset($row[&#039;cnt&#039;]) &amp;&amp; $row[&#039;cnt&#039;])
    alert(&#039;이미 존재하는 상품코드 입니다.&#039;);

$sql = &quot; select * from {$g5[&#039;g5_shop_item_table&#039;]} where it_id = &#039;$it_id&#039; limit 1 &quot;;
$cp = sql_fetch($sql);

// 상품테이블의 필드가 추가되어도 수정하지 않도록 필드명을 추출하여 insert 퀴리를 생성한다. (상품코드만 새로운것으로 대체)
$sql_common = &quot;&quot;;
$fields = sql_field_names($g5[&#039;g5_shop_item_table&#039;]);
foreach($fields as $fld) {
    if ($fld == &#039;it_id&#039; || $fld == &#039;it_sum_qty&#039; || $fld == &#039;it_use_cnt&#039; || $fld == &#039;it_use_avg&#039;)
        continue;

    $sql_common .= &quot; , $fld = &#039;&quot;.addslashes($cp[$fld]).&quot;&#039; &quot;;
}

$sql = &quot; insert {$g5[&#039;g5_shop_item_table&#039;]}
			set it_id = &#039;$new_it_id&#039;
                $sql_common &quot;;
sql_query($sql);

// 선택/추가 옵션 copy
$opt_sql = &quot; insert ignore into {$g5[&#039;g5_shop_item_option_table&#039;]} ( io_id, io_type, it_id, io_price, io_stock_qty, io_noti_qty, io_use )
                select io_id, io_type, &#039;$new_it_id&#039;, io_price, io_stock_qty, io_noti_qty, io_use
                    from {$g5[&#039;g5_shop_item_option_table&#039;]}
                    where it_id = &#039;$it_id&#039;
                    order by io_no asc &quot;;
sql_query($opt_sql);

// html 에디터로 첨부된 이미지 파일 복사
$copied_editor_images = array();
if($cp[&#039;it_explan&#039;]) {
    $matchs = get_editor_image($cp[&#039;it_explan&#039;], false);
    $count_matchs = (isset($matchs[1]) &amp;&amp; is_array($matchs[1])) ? count($matchs[1]) : 0;

    // 파일의 경로를 얻어 복사
    for($i=0;$i&lt;$count_matchs;$i++) {
        $p = parse_url($matchs[1][$i]);
        if(strpos($p[&#039;path&#039;], &quot;/data/&quot;) != 0)
            $src_path = preg_replace(&quot;/^\/.*\/data/&quot;, &quot;/data&quot;, $p[&#039;path&#039;]);
        else
            $src_path = $p[&#039;path&#039;];

        $srcfile = G5_PATH.$src_path;
        $dstfile = preg_replace(&quot;/\.([^\.]+)$/&quot;, &quot;_&quot;.$new_it_id.&quot;.\\1&quot;, $srcfile);

        if(is_file($srcfile)) {
            copy($srcfile, $dstfile);

            $newfile = preg_replace(&quot;/\.([^\.]+)$/&quot;, &quot;_&quot;.$new_it_id.&quot;.\\1&quot;, $matchs[1][$i]);
            $cp[&#039;it_explan&#039;] = str_replace($matchs[1][$i], $newfile, $cp[&#039;it_explan&#039;]);

            $copied_editor_images[] = array(
                &#039;original&#039; =&gt; $srcfile,
                &#039;new&#039; =&gt; $dstfile
            );
        }
        
    }

    $sql = &quot; update {$g5[&#039;g5_shop_item_table&#039;]} set it_explan = &#039;&quot;.addslashes($cp[&#039;it_explan&#039;]).&quot;&#039; where it_id = &#039;$new_it_id&#039; &quot;;
    sql_query($sql);
}

if($cp[&#039;it_mobile_explan&#039;]) {
    $matchs = get_editor_image($cp[&#039;it_mobile_explan&#039;], false);
    $count_matchs = (isset($matchs[1]) &amp;&amp; is_array($matchs[1])) ? count($matchs[1]) : 0;

    // 파일의 경로를 얻어 복사
    for($i=0;$i&lt;$count_matchs;$i++) {
        $p = parse_url($matchs[1][$i]);
        if(strpos($p[&#039;path&#039;], &quot;/data/&quot;) != 0)
            $src_path = preg_replace(&quot;/^\/.*\/data/&quot;, &quot;/data&quot;, $p[&#039;path&#039;]);
        else
            $src_path = $p[&#039;path&#039;];

        $srcfile = G5_PATH.$src_path;
        $dstfile = preg_replace(&quot;/\.([^\.]+)$/&quot;, &quot;_&quot;.$new_it_id.&quot;.\\1&quot;, $srcfile);

        if(is_file($srcfile)) {
            copy($srcfile, $dstfile);

            $newfile = preg_replace(&quot;/\.([^\.]+)$/&quot;, &quot;_&quot;.$new_it_id.&quot;.\\1&quot;, $matchs[1][$i]);
            $cp[&#039;it_mobile_explan&#039;] = str_replace($matchs[1][$i], $newfile, $cp[&#039;it_mobile_explan&#039;]);

            $copied_editor_images[] = array(
                &#039;original&#039; =&gt; $srcfile,
                &#039;new&#039; =&gt; $dstfile
            );
        }
    }

    $sql = &quot; update {$g5[&#039;g5_shop_item_table&#039;]} set it_mobile_explan = &#039;&quot;.addslashes($cp[&#039;it_mobile_explan&#039;]).&quot;&#039; where it_id = &#039;$new_it_id&#039; &quot;;
    sql_query($sql);
}

// 상품이미지 복사
function copy_directory($src_dir, $dest_dir)
{
    if($src_dir == $dest_dir)
        return false;

    if(!is_dir($src_dir))
        return false;

    if(!is_dir($dest_dir)) {
        @mkdir($dest_dir, G5_DIR_PERMISSION);
        @chmod($dest_dir, G5_DIR_PERMISSION);
    }

    $dir = opendir($src_dir);
    while (false !== ($filename = readdir($dir))) {
        if($filename == &quot;.&quot; || $filename == &quot;..&quot;)
            continue;

        $files[] = $filename;
    }

    for($i=0; $i&lt;count($files); $i++) {
        $src_file = $src_dir.&#039;/&#039;.$files[$i];
        $dest_file = $dest_dir.&#039;/&#039;.$files[$i];
        if(is_file($src_file)) {
            copy($src_file, $dest_file);
            @chmod($dest_file, G5_FILE_PERMISSION);
        }
    }
}

// 파일복사
$copied_item_files = array();
$dest_path = G5_DATA_PATH.&#039;/item/&#039;.$new_it_id;
@mkdir($dest_path, G5_DIR_PERMISSION);
@chmod($dest_path, G5_DIR_PERMISSION);
$comma = &#039;&#039;;
$sql_img = &#039;&#039;;

for($i=1; $i&lt;=10; $i++) {
    $file = G5_DATA_PATH.&#039;/item/&#039;.$cp[&#039;it_img&#039;.$i];
    $new_img = &#039;&#039;;

    if(is_file($file)) {
        $dstfile = $dest_path.&#039;/&#039;.basename($file);
        copy($file, $dstfile);
        @chmod($dstfile, G5_FILE_PERMISSION);
        $new_img = $new_it_id.&#039;/&#039;.basename($file);

        $copied_item_files[] = array(
            &#039;original&#039; =&gt; $file,
            &#039;new&#039; =&gt; $dstfile,
        );
    }

    $sql_img .= $comma.&quot; it_img{$i} = &#039;$new_img&#039; &quot;;
    $comma = &#039;,&#039;;
}

$sql = &quot; update {$g5[&#039;g5_shop_item_table&#039;]}
            set $sql_img
            where it_id = &#039;$new_it_id&#039; &quot;;
sql_query($sql);

if( function_exists(&#039;shop_seo_title_update&#039;) ) shop_seo_title_update($new_it_id, true);

/**
 * 아이템 복사 처리 후 Event Hook
 * @var string $it_id 원본 아이템 ID
 * @var string $new_it_id 복사한 새로운 아이템 ID
 * @var array $cp 복사한 아이템 정보
 * @var array $copied_item_files 복사한 파일 목록
 * @var array $copied_editor_images 복사한 에디터 이미지 목록
 */
run_event(&#039;shop_admin_itemcopy&#039;, array(
    &#039;it_id&#039; =&gt; (string) $it_id,
    &#039;new_it_id&#039; =&gt; (string) $new_it_id,
    &#039;cp&#039; =&gt; $cp,
    &#039;copied_item_files&#039; =&gt; $copied_item_files,
    &#039;copied_editor_images&#039; =&gt; $copied_editor_images
));

$qstr = &quot;ca_id=$ca_id&amp;amp;sfl=$sfl&amp;amp;sca=$sca&amp;amp;page=$page&amp;amp;stx=&quot;.urlencode($stx);

goto_url(&quot;itemlist.php?$qstr&quot;);</pre>