271 lines
8.2 KiB
PHP
271 lines
8.2 KiB
PHP
<?php
|
|
if (!defined('_GNUBOARD_')) exit;
|
|
|
|
function get_shop_item($it_id, $is_cache=false, $add_query=''){
|
|
|
|
global $g5, $g5_object;
|
|
|
|
$add_query_key = $add_query ? 'shop_'.md5($add_query) : '';
|
|
|
|
$item = $is_cache ? $g5_object->get('shop', $it_id, $add_query_key) : null;
|
|
|
|
if( !$item ){
|
|
$sql = " select * from {$g5['g5_shop_item_table']} where it_id = '{$it_id}' $add_query ";
|
|
$item = sql_fetch($sql);
|
|
|
|
$g5_object->set('shop', $it_id, $item, $add_query_key);
|
|
}
|
|
|
|
if( isset($item['it_basic']) ) {
|
|
$item['it_basic'] = conv_content($item['it_basic'], 1);
|
|
}
|
|
|
|
if( ! isset($item['it_id']) ){
|
|
$item['it_id'] = '';
|
|
}
|
|
|
|
return $item;
|
|
}
|
|
|
|
function get_shop_item_with_category($it_id, $seo_title='', $add_query=''){
|
|
|
|
global $g5, $default;
|
|
|
|
if( $seo_title ){
|
|
$sql = " select a.*, b.ca_name, b.ca_use from {$g5['g5_shop_item_table']} a, {$g5['g5_shop_category_table']} b where a.it_seo_title = '".sql_real_escape_string(generate_seo_title($seo_title))."' and a.ca_id = b.ca_id $add_query order by it_id desc limit 1";
|
|
} else {
|
|
$sql = " select a.*, b.ca_name, b.ca_use from {$g5['g5_shop_item_table']} a, {$g5['g5_shop_category_table']} b where a.it_id = '$it_id' and a.ca_id = b.ca_id $add_query order by it_id desc limit 1";
|
|
}
|
|
|
|
$item = sql_fetch($sql);
|
|
|
|
if( isset($item['it_basic']) ) {
|
|
$item['it_basic'] = conv_content($item['it_basic'], 1);
|
|
}
|
|
|
|
return $item;
|
|
}
|
|
|
|
function get_shop_navigation_data($is_cache, $ca_id, $ca_id2='', $ca_id3=''){
|
|
|
|
$all_categories = get_shop_category_array($is_cache);
|
|
|
|
$datas = array();
|
|
|
|
if( strlen($ca_id) >= 2 && $all_categories ){
|
|
foreach((array) $all_categories as $category1 ){
|
|
$datas[0][] = $category1['text'];
|
|
}
|
|
}
|
|
|
|
$select_ca_id = $ca_id2 ? $ca_id2 : $ca_id;
|
|
$item_categories2 = $select_ca_id ? get_shop_category_by($is_cache, 'ca_id', $select_ca_id) : array();
|
|
|
|
if( strlen($select_ca_id) >= 4 && $item_categories2 ){
|
|
foreach((array) $item_categories2 as $key=>$category2 ){
|
|
if( $key === 'text' ) continue;
|
|
|
|
$datas[1][] = $category2['text'];
|
|
}
|
|
}
|
|
|
|
$select_ca_id = $ca_id3 ? $ca_id3 : $ca_id;
|
|
$item_categories3 = $select_ca_id ? get_shop_category_by($is_cache, 'ca_id', $select_ca_id) : array();
|
|
|
|
if( strlen($select_ca_id) >= 6 && $item_categories3 && isset($item_categories3[substr($select_ca_id,0,4)]) ){
|
|
$sub_categories = $item_categories3[substr($select_ca_id,0,4)];
|
|
|
|
foreach((array) $sub_categories as $key=>$category3 ){
|
|
if( $key === 'text' ) continue;
|
|
|
|
$datas[2][] = $category3['text'];
|
|
}
|
|
}
|
|
|
|
return $datas;
|
|
}
|
|
|
|
function get_shop_category_by($is_cache, $case, $value){
|
|
|
|
if( $case === 'ca_id' ){
|
|
$categories = get_shop_category_array($is_cache);
|
|
|
|
$key = substr(preg_replace('/[^0-9a-z]/i', '', $value), 0, 2);
|
|
|
|
if( isset($categories[$key]) ){
|
|
return $categories[$key];
|
|
}
|
|
}
|
|
|
|
return array();
|
|
}
|
|
|
|
function get_shop_category_array($is_cache=false){
|
|
|
|
static $categories = array();
|
|
|
|
$categories = run_replace('get_shop_category_array', $categories, $is_cache);
|
|
|
|
if( $is_cache && !empty($categories) ){
|
|
return $categories;
|
|
}
|
|
|
|
$result = sql_query(get_shop_category_sql('', 2));
|
|
|
|
for($i=0; $row=sql_fetch_array($result); $i++) {
|
|
|
|
$row['url'] = shop_category_url($row['ca_id']);
|
|
$categories[$row['ca_id']]['text'] = $row;
|
|
|
|
if( $row['ca_id'] ){
|
|
$result2 = sql_query(get_shop_category_sql($row['ca_id'], 4));
|
|
|
|
for($j=0; $row2=sql_fetch_array($result2); $j++) {
|
|
|
|
$row2['url'] = shop_category_url($row2['ca_id']);
|
|
$categories[$row['ca_id']][$row2['ca_id']]['text'] = $row2;
|
|
|
|
if( $row2['ca_id'] ){
|
|
$result3 = sql_query(get_shop_category_sql($row2['ca_id'], 6));
|
|
for($k=0; $row3=sql_fetch_array($result3); $k++) {
|
|
|
|
$row3['url'] = shop_category_url($row3['ca_id']);
|
|
$categories[$row['ca_id']][$row2['ca_id']][$row3['ca_id']]['text'] = $row3;
|
|
}
|
|
} //end if
|
|
} //end for
|
|
} //end if
|
|
} //end for
|
|
|
|
return $categories;
|
|
}
|
|
|
|
function get_shop_category_sql($ca_id, $len){
|
|
global $g5;
|
|
|
|
$sql = " select * from {$g5['g5_shop_category_table']}
|
|
where ca_use = '1' ";
|
|
if($ca_id)
|
|
$sql .= " and ca_id like '$ca_id%' ";
|
|
$sql .= " and length(ca_id) = '$len' order by ca_order, ca_id ";
|
|
|
|
return $sql;
|
|
}
|
|
|
|
function get_shop_member_coupon_count($mb_id='', $is_cache=false){
|
|
global $g5, $member;
|
|
|
|
static $cache = array();
|
|
|
|
$key = md5($mb_id);
|
|
|
|
if( $is_cache && isset($cache[$key]) ){
|
|
return $cache[$key];
|
|
}
|
|
|
|
if( !$mb_id ){
|
|
$mb_id = $member['mb_id'];
|
|
}
|
|
|
|
// 쿠폰
|
|
$cp_count = 0;
|
|
$sql = " select cp_id
|
|
from {$g5['g5_shop_coupon_table']}
|
|
where mb_id IN ( '{$mb_id}', '전체회원' )
|
|
and cp_start <= '".G5_TIME_YMD."'
|
|
and cp_end >= '".G5_TIME_YMD."' ";
|
|
$res = sql_query($sql);
|
|
|
|
for($k=0; $cp=sql_fetch_array($res); $k++) {
|
|
if(!is_used_coupon($mb_id, $cp['cp_id']))
|
|
$cp_count++;
|
|
}
|
|
|
|
$cache[$key] = $cp_count;
|
|
|
|
return $cp_count;
|
|
}
|
|
|
|
// 상품리스트에서 옵션항목
|
|
function get_shop_item_options($it_id, $subject, $no)
|
|
{
|
|
global $g5;
|
|
|
|
if(!$it_id || !$subject)
|
|
return '';
|
|
|
|
$sql = " select * from {$g5['g5_shop_item_option_table']} where io_type = '0' and it_id = '$it_id' and io_use = '1' order by io_no asc ";
|
|
$result = sql_query($sql);
|
|
if(!sql_num_rows($result))
|
|
return '';
|
|
|
|
$str = '';
|
|
$subj = explode(',', $subject);
|
|
$subj_count = count($subj);
|
|
|
|
if($subj_count > 1) {
|
|
$options = array();
|
|
|
|
// 옵션항목 배열에 저장
|
|
for($i=0; $row=sql_fetch_array($result); $i++) {
|
|
$opt_id = explode(chr(30), $row['io_id']);
|
|
|
|
for($k=0; $k<$subj_count; $k++) {
|
|
if(! (isset($options[$k]) && is_array($options[$k])))
|
|
$options[$k] = array();
|
|
|
|
if(isset($opt_id[$k]) && $opt_id[$k] && !in_array($opt_id[$k], $options[$k]))
|
|
$options[$k][] = $opt_id[$k];
|
|
}
|
|
}
|
|
|
|
// 옵션선택목록 만들기
|
|
for($i=0; $i<$subj_count; $i++) {
|
|
$opt = $options[$i];
|
|
$opt_count = count($opt);
|
|
$disabled = '';
|
|
if($opt_count) {
|
|
$seq = $no.'_'.($i + 1);
|
|
if($i > 0)
|
|
$disabled = ' disabled="disabled"';
|
|
|
|
$str .= '<label for="it_option_'.$seq.'" class="sound_only">'.$subj[$i].'</label>'.PHP_EOL;
|
|
|
|
$select = '<select id="it_option_'.$seq.'" class="it_option"'.$disabled.'>'.PHP_EOL;
|
|
$select .= '<option value="">'.$subj[$i].'</option>'.PHP_EOL;
|
|
for($k=0; $k<$opt_count; $k++) {
|
|
$opt_val = $opt[$k];
|
|
if(strlen($opt_val)) {
|
|
$select .= '<option value="'.$opt_val.'">'.$opt_val.'</option>'.PHP_EOL;
|
|
}
|
|
}
|
|
$select .= '</select>'.PHP_EOL;
|
|
|
|
$str .= $select.PHP_EOL;
|
|
}
|
|
}
|
|
} else {
|
|
$str .= '<label for="it_option_1">'.$subj[0].'</label>'.PHP_EOL;
|
|
|
|
$select = '<select id="it_option_1" class="it_option">'.PHP_EOL;
|
|
$select .= '<option value="">선택</option>'.PHP_EOL;
|
|
for($i=0; $row=sql_fetch_array($result); $i++) {
|
|
if($row['io_price'] >= 0)
|
|
$price = ' + '.number_format($row['io_price']).'원';
|
|
else
|
|
$price = ' '.number_format($row['io_price']).'원';
|
|
|
|
if(!$row['io_stock_qty'])
|
|
$soldout = ' [품절]';
|
|
else
|
|
$soldout = '';
|
|
|
|
$select .= '<option value="'.$row['io_id'].','.$row['io_price'].','.$row['io_stock_qty'].'">'.$row['io_id'].$price.$soldout.'</option>'.PHP_EOL;
|
|
}
|
|
$select .= '</select>'.PHP_EOL;
|
|
|
|
$str .= $select.PHP_EOL;
|
|
}
|
|
|
|
return $str;
|
|
} |