[쇼핑몰] 배송일괄처리에서 배송번호작성시 자동배송완료처리하기. > 팁앤테크

• 목록

• 페이스북 공유
• 트위터 공유
• 

                          where on_uid = '$on_uid'
                            and ct_id  = '$row2[ct_id]' ";
                sql_query($sql4);
            }
            
$order_not_point = true;
$sql = " select * from $g4[yc4_cart_table]
          where (ct_status = '配送完了')
            and ct_point_use = '0' ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) {
    // ?員 ID を得る
    $tmp_row = sql_fetch("select od_id,mb_id from $g4[yc4_order_table] where on_uid = '$row[on_uid]' ");
    // ?員ながらポイントが 0より大きければ
    if ($tmp_row[mb_id] && $row[ct_point] > 0) {
        $po_point = $row[ct_point] * $row[ct_qty];
        $po_content = "注文番? $tmp_row[od_id] ($row[ct_id]) 配送完了";
        insert_point($tmp_row[mb_id], $po_point, $po_content, "@process", $tmp_row[mb_id], "$tmp_row[od_id],$row[on_uid],$row[ct_id]");
    }
    sql_query("update $g4[yc4_cart_table] set ct_point_use = '1' where ct_id = '$row[ct_id]' ");
}           

            //-----------------------------------------