배송 완료 후 포인트 부여가 되지 않습니다. 채택완료

</p><p>//------------------------------------------------------------------------------</p><p>// 주문포인트를 적립한다.</p><p>// 설정일이 지난 포인트 부여되지 않은 배송완료된 장바구니 자료에 포인트 부여</p><p>// 설정일이 0 이면 주문서 완료 설정 시점에서 포인트를 바로 부여합니다.</p><p>//------------------------------------------------------------------------------</p><p>function save_order_point($ct_status="완료")</p><p>{</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>global $g5, $default;</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre">	</span>$beforedays = date("Y-m-d H:i:s", ( time() - (86400 * (int)$default['de_point_days']) ) ); // 86400초는 하루</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>$sql = " select * from {$g5['g5_shop_cart_table']} where ct_status = '$ct_status' and ct_point_use = '0' and ct_time <= '$beforedays' ";</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>$result = sql_query($sql);</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>for ($i=0; $row=sql_fetch_array($result); $i++) {</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>// 회원 ID 를 얻는다.</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>$od_row = sql_fetch("select od_id, mb_id from {$g5['g5_shop_order_table']} where od_id = '{$row['od_id']}' ");</p><p><span class="Apple-tab-span" style="white-space:pre">		</span></p><p><span class="Apple-tab-span" style="white-space:pre">		</span>if ($od_row['mb_id'] && $row['ct_point'] > 0) { // 회원이면서 포인트가 0보다 크다면</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>$po_point = $row['ct_point'] * $row['ct_qty'];</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>$po_content = "주문번호 {$od_row['od_id']} ({$row['ct_id']}) 배송완료";</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>insert_point($od_row['mb_id'], $po_point, $po_content, "@delivery", $od_row['mb_id'], "{$od_row['od_id']},{$row['ct_id']}");</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>}</p><p><span class="Apple-tab-span" style="white-space:pre">		</span></p><p><span class="Apple-tab-span" style="white-space:pre">		</span>sql_query("update {$g5['g5_shop_cart_table']} set ct_point_use = '1' where ct_id = '{$row['ct_id']}' ");</p><p><span class="Apple-tab-span" style="white-space:pre">		</span></p><p><span class="Apple-tab-span" style="white-space:pre">		</span>$od_row2 = sql_fetch("select * from {$g5['g5_shop_default_table']}");</p><p><span class="Apple-tab-span" style="white-space:pre">		</span></p><p><span class="Apple-tab-span" style="white-space:pre">		</span>if(strcmp($od_row2['de_gibu_type'], "퍼센트")){</p><p><span class="Apple-tab-span" style="white-space:pre">		</span></p><p><span class="Apple-tab-span" style="white-space:pre">			</span>$percent = (int)$od_row2['de_gibu_percent'] * (int)$od_row['od_cart_price'];</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>sql_query("update {$g5['g5_shop_order_table']} set od_gibu = '$percent' where od_id = '{$row['od_id']}'");</p><p><span class="Apple-tab-span" style="white-space:pre">			</span></p><p><span class="Apple-tab-span" style="white-space:pre">		</span>}</p><p><span class="Apple-tab-span" style="white-space:pre">		</span></p><p><span class="Apple-tab-span" style="white-space:pre">		</span>if(strcmp($od_row2['de_gibu_type'], "금액")){</p><p><span class="Apple-tab-span" style="white-space:pre">			</span></p><p><span class="Apple-tab-span" style="white-space:pre">			</span>$money = (int)$od_row2['de_gibu_money'];</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>sql_query("update {$g5['g5_shop_order_table']} set od_gibu = '$money' where od_id = '{$row['od_id']}'");</p><p><span class="Apple-tab-span" style="white-space:pre">		</span></p><p><span class="Apple-tab-span" style="white-space:pre">		</span>}</p><p><span class="Apple-tab-span" style="white-space:pre">		</span></p><p><span class="Apple-tab-span" style="white-space:pre">	</span>}</p><p>} </p><p>