";
switch ($action)
{
case deleteall:
clear_basket();
view_basket();
view_link();
break;
//####################################################################################//
//####################################################################################//
case count_modify:
count_modify();
view_basket();
view_link();
break;
//####################################################################################//
//####################################################################################//
case direct_count_modify:
count_modify();
view_basket();
view_orderform();
break;
//####################################################################################//
//####################################################################################//
case login:
cart_login();
break;
//####################################################################################//
//####################################################################################//
case direct_erase://바로구매 장바구니 주문 삭제
if(!$reject)
{
$mesg = "주문 취소가 접수되지 않았습니다.";
error_back($mesg);
}
erase($reject);
view_basket();
view_orderform();
break;
//####################################################################################//
//####################################################################################//
case direct:
if( (gettype($count) != "integer") || (!$count) )
{
$mesg = "주문은 상품 숫자를 기록해서 하세요";
error_back($mesg);
}
$KsRow=mysql_fetch_array(mysql_query("select point_mode,point,merprice from merchan where num=$num",$connect));
if($price_opt!=0)////////다중 가격 선택시
{
$price_tmp=explode("/",$price);
$price=trim($price_tmp[1]);
$prod.="-[".trim($price_tmp[0])."]";
}
else
{
$price=$KsRow[merprice];
}
$tprice = ($price*$count);
if($KsRow[point_mode]=='0')///////////전체의 적용률을 따름
{
$juklip=$tprice*($rowadmin[memberpoint]/100)/$count;
}
else
{
$juklip=$tprice*($KsRow[point]/100)/$count;
}
$prod=($prod . $prod1 . $prod2 . $prod3);
if(!isset($cart))
{
$cart=new Cart;
}
$flag=0;
$ccc=$cart->cnt();
if($ccc)
{
$flag=0;
while($item=$cart->fetch())
{
//상품번호와 옵션이 같다면 수량을 하나올려준다.
if($item->merchan_num==$num && $item->mer_option1==$option01 && $item->mer_option2==$option02 && $item->mer_option3==$option03)
{
$cart_num=$item->cart_num;
$count=($item->qty)+$count;
$flag=0;
}
}
}
$merchan_num=$num;
$mername=$prod;
$mp_rprice=$price;
$mer_point=$juklip;
$qty=$count;
$user_id = (member_confirm())?$_COOKIE[cook_id]:"guest";
$goodsarray = $merchan_num."&&".$mername."&&".$mp_rprice."&&".$mer_point."&&".$qty."&&".$cart_num."&&".$option01_name."&&".$option02_name."&&".$option03_name."&&".$option01."&&".$option02."&&".$option03."&&".$c_catedb;
item_add();
if(member_confirm())
{
if($win_type=="pop")
{
echo"
";
}
else
{
echo"
";
}
}
else
{
if($win_type=="pop")
{
echo"
";
}
else
{
echo"
";
}
}
exit;
break;
//####################################################################################//
//####################################################################################//
case select:
if( (gettype($count) != "integer") || (!$count) )
{
$mesg = "주문은 상품 숫자를 기록해서 하세요";
error_back($mesg);
}
$KsRow=mysql_fetch_array(mysql_query("select point_mode,point,merprice from merchan where num=$num",$connect));
if($price_opt!=0)////////다중 가격 선택시
{
$price_tmp=explode("/",$price);
$price=trim($price_tmp[1]);
$prod.="-[".trim($price_tmp[0])."]";
}
else
{
$price=$KsRow[merprice];
}
$tprice = ($price*$count);
if($KsRow[point_mode]=='0')///////////전체의 적용률을 따름
{
$juklip=$tprice*($rowadmin[memberpoint]/100)/$count;
}
else
{
$juklip=$tprice*($KsRow[point]/100)/$count;
}
$prod=($prod . $prod1 . $prod2 . $prod3);
if(!isset($cart))
{
$cart=new Cart;
}
$flag=0;
$ccc=$cart->cnt();
if($ccc)
{
$flag=0;
while($item=$cart->fetch())
{
//상품번호와 옵션이 같다면 수량을 하나올려준다.
if($item->merchan_num==$num && $item->mer_option1==$option01 && $item->mer_option2==$option02 && $item->mer_option3==$option03)
{
$cart_num=$item->cart_num;
$count=($item->qty)+$count;
$flag=0;
}
}
}
$merchan_num=$num;
$mername=$prod;
$mp_rprice=$price;
$mer_point=$juklip;
$qty=$count;
$user_id = (member_confirm())?$_COOKIE[cook_id]:"guest";
$goodsarray = $merchan_num."&&".$mername."&&".$mp_rprice."&&".$mer_point."&&".$qty."&&".$cart_num."&&".$option01_name."&&".$option02_name."&&".$option03_name."&&".$option01."&&".$option02."&&".$option03."&&".$c_catedb;
item_add();
$re_action='preview';
//view_basket();
//view_link();
if($back_action=='simple_order')
{
echo"
";
}
elseif($back_action=='serchres')
{
echo"
";
}
else
{
echo"
";
}
break;
//####################################################################################//
//####################################################################################//
case preview:
$re_action='preview';
view_basket();
view_link();
break;
//####################################################################################//
//####################################################################################//
case erase:
if(!$reject)
{
$mesg = "주문 취소가 접수되지 않았습니다.";
error_back($mesg);
}
erase($reject);
view_basket();
view_link();
break;
//####################################################################################//
//####################################################################################//
case pay:////////////////////////무통장 결제 후 처리 완료 화면
if(isset($cart))
{
$ccc=$cart->cnt();
if(!$ccc)
{
echo"";
exit;
}
$dan_total_money=get_total_money(); //할인되기 전금액
if($coupon_num)
{
$que_coupon = "select * from koso_coupon as A, koso_coupon_list as B where A.num=B.cl_coupon_num and B.cl_no='$coupon_num' order by cl_no desc";
//echo"$que_coupon ";
$res_coupon=mysql_query($que_coupon,$connect);
$row_coupon=mysql_fetch_array($res_coupon);
if($row_coupon[c_unit_type]=="1") //원 할인
{
$ko_sale_price = $row_coupon[c_sale_value];
}
else
{
$ko_sale_price = $dan_total_money * ($row_coupon[c_sale_value]/100);
}
if($ko_sale_price<=0)
{
echo"";
exit;
}
}
$ksshipcon = eregi_replace("\cM","",$ksshipcon);
$ksshipcon = eregi_replace("^\s","",$ksshipcon);
$ksshipcon = eregi_replace("\t","",$ksshipcon);
$ksshipcon = eregi_replace("\"","",$ksshipcon);
$ksshipcon = eregi_replace("\n+"," ",$ksshipcon);
$wdate = date(mdHis); // 월일시분초
$orderid = "N".substr(rand(),0,3)."_".$wdate; // 상품구입아이디
$ko_paydate=$myear."-".$mmonth."-".$mday;
$kstel=$kstel1."-".$kstel2."-".$kstel3;
$kshphone=$kshphone1."-".$kshphone2."-".$kshphone3;
$kszip=$kszip1."-".$kszip2;
$ksshiptel=$ksshiptel1."-".$ksshiptel2."-".$ksshiptel3;
$ksshiphphone=$ksshiphphone1."-".$ksshiphphone2."-".$ksshiphphone3;
$ksshipzip=$ksshipzip1."-".$ksshipzip2;
$tuk_delivery_cost=get_tuk_delivery_cost($ksshipzip1);////////특별 배송료 붙이기
$ko_delivery_cost+=$tuk_delivery_cost;
$ko_total+=$tuk_delivery_cost;
$ko_total = $ko_total;
//세금계산서,현금영수증 신청에 따른 변수 셋팅
if($ko_tax_01=="1") //세금계산서 신청
{
//현금영수증 변수 초기화
$money_tax01="N";
$money_tax_name="";
$money_tax_phone="";
$money_tax_email="";
$ko_tax_yn="Y";
$ks_saup_number=$ks_saup1."-".$ks_saup2."-".$ks_saup3; //사업자 번호
}
elseif($ko_tax_01=="2") //현금영수증 신청
{
//세금계산서 초기화
$ko_tax_yn="N";
$ks_saup_number="";
$ks_saup_number="";
$ks_rep_name="";
$ks_company_name="";
$ks_company_address="";
$ks_company_part="";
$ks_company_item="";
$money_tax01="Y";
$money_tax_phone=$money_tax_phone1."-".$money_tax_phone2."-".$money_tax_phone3;
}
else //둘다 신청하지 않았을 경우
{
//현금영수증 변수 초기화
$money_tax01="N";
$money_tax_name="";
$money_tax_phone="";
$money_tax_email="";
//세금계산서 초기화
$ko_tax_yn="N";
$ks_saup_number="";
$ks_saup_number="";
$ks_rep_name="";
$ks_company_name="";
$ks_company_address="";
$ks_company_part="";
$ks_company_item="";
$money_tax01="N";
$money_tax_phone="";
$ko_tax_yn="N";
$ks_saup_number="";
}
$query = "
insert into koso_order set
ko_orderid='$orderid',
ko_id='$ko_buyerid',
ko_name='$ksname',
ko_tel='$kstel',
ko_htel='$kshphone',
ko_zip='$kszip',
ko_addr='$ksaddre',
ko_email='$ksemail',
ko_grade='$ko_buyergrade',
ko_sname='$ksshipname',
ko_stel='$ksshiptel',
ko_shtel='$ksshiphphone',
ko_szip='$ksshipzip',
ko_saddr='$ksshipaddre',
ko_sbigo='$ksshipcon',
ko_bank='$banknum',
ko_paydate='$ko_paydate',
ko_payname='$bname',
ko_used_point='$ko_used_point',
ko_get_point='$ko_get_point',
ko_delivery_cost='$ko_delivery_cost',
ko_total='$ko_total',
ko_date= now(),
ko_tax_yn='$ko_tax_yn',
ko_tax_01='$ko_tax_01',
ko_saup_number='$ks_saup_number',
ko_rep_name='$ks_rep_name',
ko_company_name='$ks_company_name',
ko_company_address='$ks_company_address',
ko_company_part='$ks_company_part',
ko_company_item='$ks_company_item',
money_tax01='$money_tax01',
money_tax_name='$money_tax_name',
money_tax_phone='$money_tax_phone',
money_tax_email='$money_tax_email',
ko_coupon_type='$coupon_type',
ko_coupon_num='$coupon_num',
ko_sale_price='$ko_sale_price',
money_tax_use='$money_tax_use'
";
$result = mysql_query($query,$connect);
//주문완료시 쿠본 사용처리 해준다.
if($result)
{
if($coupon_type=="offline")
{
$que_coupon2="update off_coupon set use_yn='Y',use_orderid='$orderid',usedate=now() where num='$coupon_num'";
$res_coupon2=mysql_query($que_coupon2,$connect);
}
else
{
$que_coupon2="update koso_coupon_list set cl_use_yn='Y',cl_orderid='$orderid',cl_use_date=now() where cl_no='$coupon_num'";
$res_coupon2=mysql_query($que_coupon2,$connect);
}
}
if($ko_cash_bill_request=="y")
{
$receipt="1";
}
else
{
$receipt="0";
}
if($ko_tax_01=="2")
{
$receipt="1"; //신청
}
else
{
$receipt="0"; //미신청
}
$ssn1=substr($money_tax_phone,0,6);
$ssn2=substr($money_tax_phone,6,7);
$ssn=$ssn1."-".$ssn2;
////////현금영수증 관련 디비 입력///////
$query1 = "
insert into receipt (
ssn,
ko_orderid,
receipt,
adm_no,
receipt1
) values (
'$ssn',
'$orderid',
'$receipt',
'$adm_no',
'$receipt1'
)";
$result1 = mysql_query($query1,$connect);
////////끝//////////////////////////////
if ($ccc > 0)
{
while($item = $cart->fetch())
{
$goodsinfo[0] = $item->merchan_num; //상품번호
$goodsinfo[1] = $item->mername; //상품명
$goodsinfo[2] = $item->mp_rprice; //상품가격
$goodsinfo[3] = $item->mer_point; //상품포인트
$goodsinfo[4] = $item->qty; //수량
$goodsinfo[5] = $item->cart_num; //장바구니번호
$goodsinfo[6] = $item->mer_optionmane1; //옵션1이름
$goodsinfo[7] = $item->mer_optionmane2; //옵션2이름
$goodsinfo[8] = $item->mer_optionmane3; //옵션3이름
$goodsinfo[9] = $item->mer_option1; //옵션1
$goodsinfo[10] = $item->mer_option2; //옵션2
$goodsinfo[11] = $item->mer_option3; //옵션3
$goodsinfo[12] = $item->c_catedb; //상품카테고리
$que_merchan = "select * from merchan where num='$goodsinfo[0]'";
$res_merchan = mysql_query($que_merchan,$connect);
$row_merchan = mysql_fetch_array($res_merchan);
$query = "
insert into koso_order_goods set
ko_orderid='$orderid',
kog_merchan_num='$goodsinfo[0]',
kog_mername='$goodsinfo[1]',
kog_money='$goodsinfo[2]',
kog_point='$goodsinfo[3]',
kog_amount='$goodsinfo[4]',
kog_id='$ko_buyerid',
kog_catedb='$goodsinfo[12]',
mer_optionmane1='$goodsinfo[6]',
mer_optionmane2='$goodsinfo[7]',
mer_optionmane3='$goodsinfo[8]',
mer_option1='$goodsinfo[9]',
mer_option2='$goodsinfo[10]',
mer_option3='$goodsinfo[11]'
";
mysql_query($query,$connect);
$mername_s .= $goodsinfo[1]."x".$goodsinfo[4]."개,";
$maintotal += $goodsinfo[2] * $goodsinfo[4];
$mername_ary .= $goodsinfo[1]."||"; //상품명
$meramount_ary .= $goodsinfo[4]."||"; //상품수량
if($goodsinfo[6]) //상품옵션1
{
$meroption_name1 .= $goodsinfo[6]."||"; //상품옵션1 이름
}
if($goodsinfo[7]) //상품옵션2
{
$meroption_name2 .= $goodsinfo[7]."||"; //상품옵션2 이름
}
if($goodsinfo[8]) //상품옵션3
{
$meroption_name3 .= $goodsinfo[8]."||"; //상품옵션3 이름
}
if($goodsinfo[9]) //상품옵션 값
{
$meroption_value1 .= $goodsinfo[9]."||"; //상품옵션 값
}
if($goodsinfo[10]) //상품옵션 값
{
$meroption_value2 .= $goodsinfo[10]."||"; //상품옵션 값
}
if($goodsinfo[11]) //상품옵션 값
{
$meroption_value3 .= $goodsinfo[11]."||"; //상품옵션 값
}
$jaego_mode_que="select jaego_mode from merchan where num='$goodsinfo[0]'";
$jaego_mode_res=mysql_query($jaego_mode_que,$connect);
$jaego_mode=mysql_result($jaego_mode_res,0,0);
if($jaego_mode=="1")
{
$jaego_que="update merchan set jaego=jaego-$goodsinfo[4] where num='$goodsinfo[0]'";
mysql_query($jaego_que,$connect);
}
}
//주문상품이름과 수량을 koso_order 에 넣어둠.
$na_qry = "update koso_order set ko_mername='$mername_ary',ko_amount='$meramount_ary',ko_meroption_name1='$meroption_name1',ko_meroption_value1='$meroption_value1',ko_meroption_name2='$meroption_name2',ko_meroption_value2='$meroption_value2',ko_meroption_name3='$meroption_name3',ko_meroption_value3='$meroption_value3' where ko_orderid='$orderid'";
$na_res = mysql_query($na_qry,$connect);
}
$point_up_que="update koso_member set usepoint=usepoint-$ko_used_point where id='$ko_buyerid'";
$point_up_res=mysql_query($point_up_que,$connect);
if($ko_used_point > 0)
{
$usename="상품,포인트구매에 따른 차감";
$in_que="
insert
into
koso_point_list (
point,
regdate,
use_name,
id,
orderid
) values (
'$ko_used_point',
now(),
'$usename',
'$ko_buyerid',
'$orderid'
)
";
$in_res=mysql_query($in_que,$connect);
}
//메일 발송 function
code_to_email("order_complate","$orderid","");
$cart->allremove();
unset($cart);
m_send_sms("order_client",$orderid); ///////주문 후 고객에게 sms 보내기
m_send_sms("order_admin",$orderid); ///////주문 후 관리자에게 sms 보내기
echo"
";
exit;
}
else
{
$mesg = "상품 주문을 먼저 하세요!";
error_back($mesg);
}
break;
//####################################################################################//
//####################################################################################//
//####################################################################################//
case pay_result:
$my_view_basket=view_basket($orderid);
$my_view_orderform_d=view_orderform_d($orderid);
$my_view_coupon_d=view_coupon_d($orderid);
echo $my_view_basket.$my_view_coupon_d.$my_view_orderform_d;
echo"
";
break;
//####################################################################################//
//####################################################################################//
//####################################################################################//
case card:
if(!isset($cart))
{
echo("
");
}
$paytype="card";
view_basket();
view_orderform();
break;
//####################################################################################//
//####################################################################################//
case process3: //////사은 품 처리 부분
///넘어온값 paytype=order or card , ko_usepoint=사용할 포인트, coupon_number=쿠폰 번호, coupon_number2=쿠폰번호2(포장)
if(!$cart || $cart->cnt()==0)
{
echo"
";
exit;
}
?>
if(member_confirm())
{
$mem_row=mysql_fetch_array(mysql_query("select * from koso_member where id='$_COOKIE[cook_id]'",$connect));
}
if($ko_usepoint > $mem_row[usepoint])
{
alert_back_exit("사용하실 수 있는 포인트는 최대 $mem_row[usepoint] 입니다.");
}
$now_date=date("Y-m-d");
$dan_total_money=get_total_money();
$service1=$rowadmin[service1];
$service2=$rowadmin[service2];
$service3=$rowadmin[service3];
$thismanpoint=$ko_usepoint;
if($dan_total_money<$thismanpoint)
{
$thismanpoint=$dan_total_money;
}
//////배송료 계산하기.
if($dan_total_money >= $service1)
$real_service2=0;
else
$real_service2=$service2;
if($coupon_number > 0) /////일반 쿠폰 - 깎아 주거나 할인해 주거나..
{
$c_que="select * from koso_coupon where kc_no='$coupon_number'";
$c_res=mysql_query($c_que,$connect);
$c_row=mysql_fetch_array($c_res);
if($c_row[kc_type]=="2") /////배송료 무료 쿠폰
{
$ko_service_price=$real_service2;
}
else
{
if($c_row[kc_service_price] > 0)
{
$ko_service_price=$c_row[kc_service_price];
}
else
{
$ko_service_price=($dan_total_money-$thismanpoint)*$c_row[kc_service_percent]/100;
}
}
}
else
{
$ko_service_price=$real_service2;
}
$m_real_total=$dan_total_money-$thismanpoint+$ko_service_price;
if($m_real_total < 30000)
{
/*
echo"
";
exit;
*/
}
//사은품 잠시보류로 인한 처리
echo"
";
/*
echo"
";
*/
break;
//####################################################################################//
//####################################################################################//
case gift_erase:
if(!$reject)
{
$mesg = "주문 취소가 접수되지 않았습니다.";
echo"
";
}
gift_erase($reject);
echo"
";
exit;
break;
//####################################################################################//
//####################################################################################//
//####################################################################################//
case order:////////////////무통장 결제 화면
if(!isset($cart))
{
echo("
");
}
$paytype="online";
$m_gift_total=0;
$old_kg_price_type=0;
$temp_count_array=array("10"=>0,"20"=>0,"30"=>0);
$cart->gift_allremove();
$g_que="select kg_no,kg_name,kg_price_type From koso_gift where kg_no=$gift_choice";
$g_res=mysql_query($g_que,$connect);
$g_num=@mysql_num_rows($g_res);
$g_row=@mysql_fetch_array($g_res);
if($g_row)
{
$old_kg_price_type=$g_row[kg_price_type];
$temp_count_array[$g_row[kg_price_type]]+=1;
$cart->gift_set($g_row[kg_no],$g_row[kg_name],$g_row[kg_price_type],'1');
}
$dan_total_money=get_total_money();
view_basket();
view_coupon();
view_orderform();
/*
if($dan_total_money >= 10000 && $dan_total_money < 30000)
{
if($temp_count_array[1] > 1 )
{
alert_back_exit("사은품으로 담으신 물품의 개수가 허용치를 초과 하였습니다.");
}
elseif($temp_count_array[1] < 1)
{
alert_back_exit("사은품을 선택하실 수 있습니다.");
}
}
elseif($dan_total_money >= 30000 && $dan_total_money < 50000)
{
if($temp_count_array[3] > 1 )
{
alert_back_exit("사은품으로 담으신 물품의 개수가 허용치를 초과 하였습니다.");
}
elseif($temp_count_array[3] < 1)
{
alert_back_exit("사은품을 선택하실 수 있습니다.");
}
}
elseif($dan_total_money >= 50000 && $dan_total_money < 70000)
{
if($temp_count_array[5] > 1 )
{
alert_back_exit("사은품으로 담으신 물품의 개수가 허용치를 초과 하였습니다.");
}
elseif( $temp_count_array[5] < 1 )
{
alert_back_exit("사은품을 선택하실 수 있습니다.");
}
}
elseif($dan_total_money >= 700000 && $dan_total_money < 100000)
{
if($temp_count_array[7] > 1 )
{
alert_back_exit("사은품으로 담으신 물품의 개수가 허용치를 초과하였습니다.");
}
elseif($temp_count_array[7] < 1)
{
alert_back_exit("사은품을 선택하실 수 있습니다.");
}
}
elseif($dan_total_money >= 1000000 )
{
if($temp_count_array[10] > 1 )
{
alert_back_exit("사은품으로 담으신 물품의 개수가 허용치를 초과하였습니다.");
}
elseif($temp_count_array[7] < 1)
{
alert_back_exit("사은품을 선택하실 수 있습니다.");
}
}
*/
break;
default:
view_basket();
view_link();
}
echo" |
|