"; $current_status = $od['od_status']; $change_status = $_POST['od_status']; switch ($current_status) { case '입금' : if ($change_status != '완료') continue; change_status($od_id, '입금', '완료'); // 완료인 경우에만 상품구입 합계수량을 상품테이블에 저장한다. $sql2 = " select it_id from {$g5['g5_shop_cart_table']} where od_id = '$od_id' and ct_status = '완료' group by it_id "; $result2 = sql_query($sql2); for ($k=0; $row2=sql_fetch_array($result2); $k++) { $sql3 = " select sum(ct_qty) as sum_qty from {$g5['g5_shop_cart_table']} where it_id = '{$row2['it_id']}' and ct_status = '완료' "; $row3 = sql_fetch($sql3); $sql4 = " update {$g5['g5_shop_item_table']} set it_sum_qty = '{$row3['sum_qty']}' where it_id = '{$row2['it_id']}' "; sql_query($sql4); } break; } // switch end // 주문정보 $info = get_order_info($od_id); if(!$info) continue; $sql = " update {$g5['g5_shop_order_table']} set od_misu = '{$info['od_misu']}', od_tax_mny = '{$info['od_tax_mny']}', od_vat_mny = '{$info['od_vat_mny']}', od_free_mny = '{$info['od_free_mny']}', od_send_cost = '{$info['od_send_cost']}' where od_id = '$od_id' "; sql_query($sql, true); } // SMS $sms_count = count($sms_messages); if($sms_count > 0) { if($config['cf_sms_type'] == 'LMS') { include_once(G5_LIB_PATH.'/icode.lms.lib.php'); $port_setting = get_icode_port_type($config['cf_icode_id'], $config['cf_icode_pw']); // SMS 모듈 클래스 생성 if($port_setting !== false) { $SMS = new LMS; $SMS->SMS_con($config['cf_icode_server_ip'], $config['cf_icode_id'], $config['cf_icode_pw'], $port_setting); for($s=0; $s<$sms_count; $s++) { $strDest = array(); $strDest[] = $sms_messages[$s]['recv']; $strCallBack = $sms_messages[$s]['send']; $strCaller = iconv_euckr(trim($default['de_admin_company_name'])); $strSubject = ''; $strURL = ''; $strData = iconv_euckr($sms_messages[$s]['cont']); $strDate = ''; $nCount = count($strDest); $res = $SMS->Add($strDest, $strCallBack, $strCaller, $strSubject, $strURL, $strData, $strDate, $nCount); $SMS->Send(); $SMS->Init(); // 보관하고 있던 결과값을 지웁니다. } } } else { include_once(G5_LIB_PATH.'/icode.sms.lib.php'); $SMS = new SMS; // SMS 연결 $SMS->SMS_con($config['cf_icode_server_ip'], $config['cf_icode_id'], $config['cf_icode_pw'], $config['cf_icode_server_port']); for($s=0; $s<$sms_count; $s++) { $recv_number = $sms_messages[$s]['recv']; $send_number = $sms_messages[$s]['send']; $sms_content = iconv_euckr($sms_messages[$s]['cont']); $SMS->Add($recv_number, $send_number, $config['cf_icode_id'], $sms_content, ""); } $SMS->Send(); $SMS->Init(); // 보관하고 있던 결과값을 지웁니다. } } //exit; goto_url("./orderlist_ticket.php"); ?>