source: closed/feature-module-combz/html/products/batch_relate.php @ 17

<?php
/*
 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
 *
 * http://www.lockon.co.jp/
 */

/*¡¡¤³¤Î¾¦ÉʤòÇã¤Ã¤¿¿Í¤Ï¤³¤ó¤Ê¾¦ÉʤâÇã¤Ã¤Æ¤¤¤Þ¤¹¡£½¸·×¥Õ¥¡¥¤¥ë  */
require_once(DATA_PATH . "lib/slib.php");
require_once(DATA_PATH . "lib/glib.php");
require_once(DATA_PATH . "class/SC_Query.php");
require_once(DATA_PATH . "class/SC_DbConn.php");
        
$objQuery = new SC_Query();

$objQuery->begin();
$objQuery->delete("dtb_bat_relate_products");
$arrCID = $objQuery->select("customer_id", "dtb_order", "del_flg = 0");
foreach($arrCID as $cdata) {
    $where = "order_id IN (SELECT order_id FROM dtb_order WHERE customer_id = ? )";
    //¸ÜµÒ¤¬¹ØÆþ¤·¤¿¾¦ÉʣɣĤò¼èÆÀ¤¹¤ë
    $arrPID = $objQuery->select("product_id", "dtb_order_detail", $where, array($cdata['customer_id']));
    //¸ÜµÒ¤¬¾¦ÉʤòÊ£¿ô¹ØÆþ¤·¤Æ¤¤¤ì¤Ð
    if(count($arrPID) > 1) {
        foreach($arrPID as $pdata1) {
            //¤³¤Î¾¦ÉÊID
            $sqlval['product_id'] = $pdata1['product_id'];
            foreach($arrPID as $pdata2) {
                if($pdata2['product_id'] != $pdata1['product_id']) {
                    //¤³¤ó¤Ê¾¦ÉÊID
                    $sqlval['relate_product_id'] = $pdata2['product_id'];
                    $sqlval['create_date'] = "now()";
                    //¥Ç¡¼¥¿ÁÞÆþ
                    $objQuery->insert("dtb_bat_relate_products", $sqlval);
                }
            }
        }
    }
}
$objQuery->commit();

?>