M72X2/X2/adm/shop_admin/itemoption.php



<title>M72X2/X2/adm/shop_admin/itemoption.php</title>


<div class="header">M72X2/X2/adm/shop_admin/itemoption.php</div>
<pre>&lt;?php
include_once(&#039;./_common.php&#039;);

$po_run = false;

if(isset($it[&#039;it_id&#039;]) &amp;&amp; $it[&#039;it_id&#039;]) {
    $opt_subject = explode(&#039;,&#039;, $it[&#039;it_option_subject&#039;]);
    $opt1_subject = isset($opt_subject[0]) ? $opt_subject[0] : &#039;&#039;;
    $opt2_subject = isset($opt_subject[1]) ? $opt_subject[1] : &#039;&#039;;
    $opt3_subject = isset($opt_subject[2]) ? $opt_subject[2] : &#039;&#039;;

    $sql = &quot; select * from {$g5[&#039;g5_shop_item_option_table&#039;]} where io_type = &#039;0&#039; and it_id = &#039;{$it[&#039;it_id&#039;]}&#039; order by io_no asc &quot;;
    $result = sql_query($sql);
    if(sql_num_rows($result))
        $po_run = true;
} else if(!empty($_POST)) {
    $opt1_subject = isset($_POST[&#039;opt1_subject&#039;]) ? preg_replace(G5_OPTION_ID_FILTER, &#039;&#039;, trim(stripslashes($_POST[&#039;opt1_subject&#039;]))) : &#039;&#039;;
    $opt2_subject = isset($_POST[&#039;opt2_subject&#039;]) ? preg_replace(G5_OPTION_ID_FILTER, &#039;&#039;, trim(stripslashes($_POST[&#039;opt2_subject&#039;]))) : &#039;&#039;;
    $opt3_subject = isset($_POST[&#039;opt3_subject&#039;]) ? preg_replace(G5_OPTION_ID_FILTER, &#039;&#039;, trim(stripslashes($_POST[&#039;opt3_subject&#039;]))) : &#039;&#039;;

    $opt1_val = isset($_POST[&#039;opt1&#039;]) ? preg_replace(G5_OPTION_ID_FILTER, &#039;&#039;, trim(stripslashes($_POST[&#039;opt1&#039;]))) : &#039;&#039;;
    $opt2_val = isset($_POST[&#039;opt2&#039;]) ? preg_replace(G5_OPTION_ID_FILTER, &#039;&#039;, trim(stripslashes($_POST[&#039;opt2&#039;]))) : &#039;&#039;;
    $opt3_val = isset($_POST[&#039;opt3&#039;]) ? preg_replace(G5_OPTION_ID_FILTER, &#039;&#039;, trim(stripslashes($_POST[&#039;opt3&#039;]))) : &#039;&#039;;

    if(!$opt1_subject || !$opt1_val) {
        echo &#039;옵션1과 옵션1 항목을 입력해 주십시오.&#039;;
        exit;
    }

    $po_run = true;

    $opt1_count = $opt2_count = $opt3_count = 0;

    if($opt1_val) {
        $opt1 = explode(&#039;,&#039;, $opt1_val);
        $opt1_count = count($opt1);
    }

    if($opt2_val) {
        $opt2 = explode(&#039;,&#039;, $opt2_val);
        $opt2_count = count($opt2);
    }

    if($opt3_val) {
        $opt3 = explode(&#039;,&#039;, $opt3_val);
        $opt3_count = count($opt3);
    }
}

if($po_run) {
?&gt;

&lt;div class=&quot;sit_option_frm_wrapper&quot;&gt;
    &lt;table&gt;
    &lt;caption&gt;옵션 목록&lt;/caption&gt;
    &lt;thead&gt;
    &lt;tr&gt;
        &lt;th scope=&quot;col&quot;&gt;
            &lt;label for=&quot;opt_chk_all&quot; class=&quot;sound_only&quot;&gt;전체 옵션&lt;/label&gt;
            &lt;input type=&quot;checkbox&quot; name=&quot;opt_chk_all&quot; value=&quot;1&quot; id=&quot;opt_chk_all&quot;&gt;
        &lt;/th&gt;
        &lt;th scope=&quot;col&quot;&gt;옵션&lt;/th&gt;
        &lt;th scope=&quot;col&quot;&gt;추가금액&lt;/th&gt;
        &lt;th scope=&quot;col&quot;&gt;재고수량&lt;/th&gt;
        &lt;th scope=&quot;col&quot;&gt;통보수량&lt;/th&gt;
        &lt;th scope=&quot;col&quot;&gt;사용여부&lt;/th&gt;
    &lt;/tr&gt;
    &lt;/thead&gt;
    &lt;tbody&gt;
    &lt;?php
    if(isset($it[&#039;it_id&#039;]) &amp;&amp; $it[&#039;it_id&#039;]) {
        for($i=0; $row=sql_fetch_array($result); $i++) {
            $opt_id = $row[&#039;io_id&#039;];
            $opt_val = explode(chr(30), $opt_id);
            $opt_1 = $opt_val[0];
            $opt_2 = isset($opt_val[1]) ? $opt_val[1] : &#039;&#039;;
            $opt_3 = isset($opt_val[2]) ? $opt_val[2] : &#039;&#039;;
            $opt_2_len = strlen($opt_2);
            $opt_3_len = strlen($opt_3);
            $opt_price = $row[&#039;io_price&#039;];
            $opt_stock_qty = $row[&#039;io_stock_qty&#039;];
            $opt_noti_qty = $row[&#039;io_noti_qty&#039;];
            $opt_use = $row[&#039;io_use&#039;];
    ?&gt;
    &lt;tr&gt;
        &lt;td class=&quot;td_chk&quot;&gt;
            &lt;input type=&quot;hidden&quot; name=&quot;opt_id[]&quot; value=&quot;&lt;?php echo get_text($opt_id); ?&gt;&quot;&gt;
            &lt;label for=&quot;opt_chk_&lt;?php echo $i; ?&gt;&quot; class=&quot;sound_only&quot;&gt;&lt;/label&gt;
            &lt;input type=&quot;checkbox&quot; name=&quot;opt_chk[]&quot; id=&quot;opt_chk_&lt;?php echo $i; ?&gt;&quot; value=&quot;1&quot;&gt;
        &lt;/td&gt;
        &lt;td class=&quot;opt-cell&quot;&gt;&lt;?php echo get_text($opt_1); if ($opt_2_len) echo &#039; &lt;small&gt;&amp;gt;&lt;/small&gt; &#039;.get_text($opt_2); if ($opt_3_len) echo &#039; &lt;small&gt;&amp;gt;&lt;/small&gt; &#039;.get_text($opt_3); ?&gt;&lt;/td&gt;
        &lt;td class=&quot;td_numsmall&quot;&gt;
            &lt;label for=&quot;opt_price_&lt;?php echo $i; ?&gt;&quot; class=&quot;sound_only&quot;&gt;&lt;/label&gt;
            &lt;input type=&quot;text&quot; name=&quot;opt_price[]&quot; value=&quot;&lt;?php echo $opt_price; ?&gt;&quot; id=&quot;opt_price_&lt;?php echo $i; ?&gt;&quot; class=&quot;frm_input&quot; size=&quot;9&quot;&gt;
        &lt;/td&gt;
        &lt;td class=&quot;td_num&quot;&gt;
            &lt;label for=&quot;opt_stock_qty_&lt;?php echo $i; ?&gt;&quot; class=&quot;sound_only&quot;&gt;&lt;/label&gt;
            &lt;input type=&quot;text&quot; name=&quot;opt_stock_qty[]&quot; value=&quot;&lt;?php echo $opt_stock_qty; ?&gt;&quot; id=&quot;op_stock_qty_&lt;?php echo $i; ?&gt;&quot; class=&quot;frm_input&quot; size=&quot;5&quot;&gt;
        &lt;/td&gt;
        &lt;td class=&quot;td_num&quot;&gt;
            &lt;label for=&quot;opt_noti_qty_&lt;?php echo $i; ?&gt;&quot; class=&quot;sound_only&quot;&gt;&lt;/label&gt;
            &lt;input type=&quot;text&quot; name=&quot;opt_noti_qty[]&quot; value=&quot;&lt;?php echo $opt_noti_qty; ?&gt;&quot; id=&quot;opt_noti_qty_&lt;?php echo $i; ?&gt;&quot; class=&quot;frm_input&quot; size=&quot;5&quot;&gt;
        &lt;/td&gt;
        &lt;td class=&quot;td_mng&quot;&gt;
            &lt;label for=&quot;opt_use_&lt;?php echo $i; ?&gt;&quot; class=&quot;sound_only&quot;&gt;&lt;/label&gt;
            &lt;select name=&quot;opt_use[]&quot; id=&quot;opt_use_&lt;?php echo $i; ?&gt;&quot;&gt;
                &lt;option value=&quot;1&quot; &lt;?php echo get_selected(&#039;1&#039;, $opt_use); ?&gt;&gt;사용함&lt;/option&gt;
                &lt;option value=&quot;0&quot; &lt;?php echo get_selected(&#039;0&#039;, $opt_use); ?&gt;&gt;사용안함&lt;/option&gt;
            &lt;/select&gt;
        &lt;/td&gt;
    &lt;/tr&gt;
    &lt;?php
        } // for
    } else {
        
        $w = isset($_POST[&#039;w&#039;]) ? $_POST[&#039;w&#039;] : &#039;&#039;;
        $post_it_id = isset($_POST[&#039;it_id&#039;]) ? safe_replace_regex($_POST[&#039;it_id&#039;], &#039;it_id&#039;) : &#039;&#039;;

        for($i=0; $i&lt;$opt1_count; $i++) {
            $j = 0;
            do {
                $k = 0;
                do {
                    $opt_1 = isset($opt1[$i]) ? strip_tags(trim($opt1[$i])) : &#039;&#039;;
                    $opt_2 = isset($opt2[$j]) ? strip_tags(trim($opt2[$j])) : &#039;&#039;;
                    $opt_3 = isset($opt3[$k]) ? strip_tags(trim($opt3[$k])) : &#039;&#039;;

                    $opt_2_len = strlen($opt_2);
                    $opt_3_len = strlen($opt_3);

                    $opt_id = $opt_1;
                    if($opt_2_len)
                        $opt_id .= chr(30).$opt_2;
                    if($opt_3_len)
                        $opt_id .= chr(30).$opt_3;
                    $opt_price = 0;
                    $opt_stock_qty = 9999;
                    $opt_noti_qty = 100;
                    $opt_use = 1;

                    // 기존에 설정된 값이 있는지 체크
                    if($w === &#039;u&#039;) {
                        $sql = &quot; select io_price, io_stock_qty, io_noti_qty, io_use
                                    from {$g5[&#039;g5_shop_item_option_table&#039;]}
                                    where it_id = &#039;{$post_it_id}&#039;
                                      and io_id = &#039;$opt_id&#039;
                                      and io_type = &#039;0&#039; &quot;;
                        $row = sql_fetch($sql);

                        if($row) {
                            $opt_price = (int)$row[&#039;io_price&#039;];
                            $opt_stock_qty = (int)$row[&#039;io_stock_qty&#039;];
                            $opt_noti_qty = (int)$row[&#039;io_noti_qty&#039;];
                            $opt_use = (int)$row[&#039;io_use&#039;];
                        }
                    }
    ?&gt;
    &lt;tr&gt;
        &lt;td class=&quot;td_chk&quot;&gt;
            &lt;input type=&quot;hidden&quot; name=&quot;opt_id[]&quot; value=&quot;&lt;?php echo $opt_id; ?&gt;&quot;&gt;
            &lt;label for=&quot;opt_chk_&lt;?php echo $i; ?&gt;&quot; class=&quot;sound_only&quot;&gt;&lt;/label&gt;
            &lt;input type=&quot;checkbox&quot; name=&quot;opt_chk[]&quot; id=&quot;opt_chk_&lt;?php echo $i; ?&gt;&quot; value=&quot;1&quot;&gt;
        &lt;/td&gt;
        &lt;td class=&quot;opt1-cell&quot;&gt;&lt;?php echo $opt_1; if ($opt_2_len) echo &#039; &lt;small&gt;&amp;gt;&lt;/small&gt; &#039;.$opt_2; if ($opt_3_len) echo &#039; &lt;small&gt;&amp;gt;&lt;/small&gt; &#039;.$opt_3; ?&gt;&lt;/td&gt;
        &lt;td class=&quot;td_numsmall&quot;&gt;
            &lt;label for=&quot;opt_price_&lt;?php echo $i; ?&gt;&quot; class=&quot;sound_only&quot;&gt;&lt;/label&gt;
            &lt;input type=&quot;text&quot; name=&quot;opt_price[]&quot; value=&quot;&lt;?php echo $opt_price; ?&gt;&quot; id=&quot;opt_price_&lt;?php echo $i; ?&gt;&quot; class=&quot;frm_input&quot; size=&quot;9&quot;&gt;
        &lt;/td&gt;
        &lt;td class=&quot;td_num&quot;&gt;
            &lt;label for=&quot;opt_stock_qty_&lt;?php echo $i; ?&gt;&quot; class=&quot;sound_only&quot;&gt;&lt;/label&gt;
            &lt;input type=&quot;text&quot; name=&quot;opt_stock_qty[]&quot; value=&quot;&lt;?php echo $opt_stock_qty; ?&gt;&quot; id=&quot;opt_stock_qty_&lt;?php echo $i; ?&gt;&quot; class=&quot;frm_input&quot; size=&quot;5&quot;&gt;
        &lt;/td&gt;
        &lt;td class=&quot;td_num&quot;&gt;
            &lt;label for=&quot;opt_noti_qty_&lt;?php echo $i; ?&gt;&quot; class=&quot;sound_only&quot;&gt;&lt;/label&gt;
            &lt;input type=&quot;text&quot; name=&quot;opt_noti_qty[]&quot; value=&quot;&lt;?php echo $opt_noti_qty; ?&gt;&quot; id=&quot;opt_noti_qty_&lt;?php echo $i; ?&gt;&quot; class=&quot;frm_input&quot; size=&quot;5&quot;&gt;
        &lt;/td&gt;
        &lt;td class=&quot;td_mng&quot;&gt;
            &lt;label for=&quot;opt_use_&lt;?php echo $i; ?&gt;&quot; class=&quot;sound_only&quot;&gt;&lt;/label&gt;
            &lt;select name=&quot;opt_use[]&quot; id=&quot;opt_use_&lt;?php echo $i; ?&gt;&quot;&gt;
                &lt;option value=&quot;1&quot; &lt;?php echo get_selected(&#039;1&#039;, $opt_use); ?&gt;&gt;사용함&lt;/option&gt;
                &lt;option value=&quot;0&quot; &lt;?php echo get_selected(&#039;0&#039;, $opt_use); ?&gt;&gt;사용안함&lt;/option&gt;
            &lt;/select&gt;
        &lt;/td&gt;
    &lt;/tr&gt;
    &lt;?php
                    $k++;
                } while($k &lt; $opt3_count);

                $j++;
            } while($j &lt; $opt2_count);
        } // for
    }
    ?&gt;
    &lt;/tbody&gt;
    &lt;/table&gt;
&lt;/div&gt;

&lt;div class=&quot;btn_list01 btn_list&quot;&gt;
    &lt;input type=&quot;button&quot; value=&quot;선택삭제&quot; id=&quot;sel_option_delete&quot; class=&quot;btn btn_02&quot;&gt;
&lt;/div&gt;

&lt;fieldset&gt;
    &lt;legend&gt;옵션 일괄 적용&lt;/legend&gt;
    &lt;?php echo help(&#039;전체 옵션의 추가금액, 재고/통보수량 및 사용여부를 일괄 적용할 수 있습니다. 단, 체크된 수정항목만 일괄 적용됩니다.&#039;); ?&gt;
    &lt;label for=&quot;opt_com_price&quot;&gt;추가금액&lt;/label&gt;
    &lt;label for=&quot;opt_com_price_chk&quot; class=&quot;sound_only&quot;&gt;추가금액일괄수정&lt;/label&gt;&lt;input type=&quot;checkbox&quot; name=&quot;opt_com_price_chk&quot; value=&quot;1&quot; id=&quot;opt_com_price_chk&quot; class=&quot;opt_com_chk&quot;&gt;
    &lt;input type=&quot;text&quot; name=&quot;opt_com_price&quot; value=&quot;0&quot; id=&quot;opt_com_price&quot; class=&quot;frm_input&quot; size=&quot;5&quot;&gt;
    &lt;label for=&quot;opt_com_stock&quot;&gt;재고수량&lt;/label&gt;
    &lt;label for=&quot;opt_com_stock_chk&quot; class=&quot;sound_only&quot;&gt;재고수량일괄수정&lt;/label&gt;&lt;input type=&quot;checkbox&quot; name=&quot;opt_com_stock_chk&quot; value=&quot;1&quot; id=&quot;opt_com_stock_chk&quot; class=&quot;opt_com_chk&quot;&gt;
    &lt;input type=&quot;text&quot; name=&quot;opt_com_stock&quot; value=&quot;0&quot; id=&quot;opt_com_stock&quot; class=&quot;frm_input&quot; size=&quot;5&quot;&gt;
    &lt;label for=&quot;opt_com_noti&quot;&gt;통보수량&lt;/label&gt;
    &lt;label for=&quot;opt_com_noti_chk&quot; class=&quot;sound_only&quot;&gt;통보수량일괄수정&lt;/label&gt;&lt;input type=&quot;checkbox&quot; name=&quot;opt_com_noti_chk&quot; value=&quot;1&quot; id=&quot;opt_com_noti_chk&quot; class=&quot;opt_com_chk&quot;&gt;
    &lt;input type=&quot;text&quot; name=&quot;opt_com_noti&quot; value=&quot;0&quot; id=&quot;opt_com_noti&quot; class=&quot;frm_input&quot; size=&quot;5&quot;&gt;
    &lt;label for=&quot;opt_com_use&quot;&gt;사용여부&lt;/label&gt;
    &lt;label for=&quot;opt_com_use_chk&quot; class=&quot;sound_only&quot;&gt;사용여부일괄수정&lt;/label&gt;&lt;input type=&quot;checkbox&quot; name=&quot;opt_com_use_chk&quot; value=&quot;1&quot; id=&quot;opt_com_use_chk&quot; class=&quot;opt_com_chk&quot;&gt;
    &lt;select name=&quot;opt_com_use&quot; id=&quot;opt_com_use&quot;&gt;
        &lt;option value=&quot;1&quot;&gt;사용함&lt;/option&gt;
        &lt;option value=&quot;0&quot;&gt;사용안함&lt;/option&gt;
    &lt;/select&gt;
    &lt;button type=&quot;button&quot; id=&quot;opt_value_apply&quot; class=&quot;btn_frmline&quot;&gt;일괄적용&lt;/button&gt;
&lt;/fieldset&gt;
&lt;?php
}</pre>