'' group by a.it_id "; $result = sql_query($sql); for ($i=0; $row=sql_fetch_array($result); $i++) { // 합계금액 계산 $sql = " select SUM(IF(io_type = 1, (io_price * ct_qty), ((ct_price + io_price) * ct_qty))) as price, SUM(ct_point * ct_qty) as point, SUM(ct_qty) as qty from {$g5['g5_shop_cart_table']} where it_id = '{$row['it_id']}' and od_id = '$od_id' and ct_select = '1' "; $sum = sql_fetch($sql); // 옵션정보 $sql2 = " select ct_option, ct_qty, io_price from {$g5['g5_shop_cart_table']} where it_id = '{$row['it_id']}' and od_id = '$od_id' and ct_select = '1' order by io_type asc, ct_id asc "; $result2 = sql_query($sql2); $options = ''; $options_ul = ' style="margin:0;padding:0"'; // ul style $options_li = ' style="padding:5px 0;list-style:none"'; // li style for($k=0; $row2=sql_fetch_array($result2); $k++) { if($k == 0) $options .= ''.PHP_EOL; $price_plus = ''; if($row2['io_price'] >= 0) $price_plus = '+'; $options .= ''.$row2['ct_option'].' ('.$price_plus.display_price($row2['io_price']).') '.$row2['ct_qty'].'개'.PHP_EOL; } if($k > 0) $options .= ''; $list[$i]['it_id'] = $row['it_id']; $list[$i]['it_simg'] = get_it_image($row['it_id'], 70, 70); $list[$i]['it_name'] = $row['it_name']; $list[$i]['it_opt'] = $options; $list[$i]['ct_price'] = $sum['price']; $subject = $config['cf_title'].' - 주문 알림 메일 (주문자 '.$od_name.'님)'; ob_start(); include G5_SHOP_PATH.'/mail/orderupdate3.mail.php'; $content = ob_get_contents(); ob_end_clean(); mailer($config['cf_admin_email_name'], $config['cf_admin_email'], $row['it_sell_email'], $subject, $content, 1); } //==============================================================================;