source: branches/dev/html/products/batch_relate.php @ 8

Revision 8, 1.2 KB checked in by root, 17 years ago (diff)

new import

Line 
1<?php
2/*
3 * Copyright(c) 2000-2006 LOCKON CO.,LTD. All Rights Reserved.
4 *
5 * http://www.lockon.co.jp/
6 */
7
8/*¡¡¤³¤Î¾¦ÉʤòÇã¤Ã¤¿¿Í¤Ï¤³¤ó¤Ê¾¦ÉʤâÇã¤Ã¤Æ¤¤¤Þ¤¹¡£½¸·×¥Õ¥¡¥¤¥ë  */
9require_once(DATA_PATH . "lib/slib.php");
10require_once(DATA_PATH . "lib/glib.php");
11require_once(DATA_PATH . "class/SC_Query.php");
12require_once(DATA_PATH . "class/SC_DbConn.php");
13       
14$objQuery = new SC_Query();
15
16$objQuery->begin();
17$objQuery->delete("dtb_bat_relate_products");
18$arrCID = $objQuery->select("customer_id", "dtb_order", "del_flg = 0");
19foreach($arrCID as $cdata) {
20    $where = "order_id IN (SELECT order_id FROM dtb_order WHERE customer_id = ? )";
21    //¸ÜµÒ¤¬¹ØÆþ¤·¤¿¾¦ÉʣɣĤò¼èÆÀ¤¹¤ë
22    $arrPID = $objQuery->select("product_id", "dtb_order_detail", $where, array($cdata['customer_id']));
23    //¸ÜµÒ¤¬¾¦ÉʤòÊ£¿ô¹ØÆþ¤·¤Æ¤¤¤ì¤Ð
24    if(count($arrPID) > 1) {
25        foreach($arrPID as $pdata1) {
26            //¤³¤Î¾¦ÉÊID
27            $sqlval['product_id'] = $pdata1['product_id'];
28            foreach($arrPID as $pdata2) {
29                if($pdata2['product_id'] != $pdata1['product_id']) {
30                    //¤³¤ó¤Ê¾¦ÉÊID
31                    $sqlval['relate_product_id'] = $pdata2['product_id'];
32                    $sqlval['create_date'] = "now()";
33                    //¥Ç¡¼¥¿ÁÞÆþ
34                    $objQuery->insert("dtb_bat_relate_products", $sqlval);
35                }
36            }
37        }
38    }
39}
40$objQuery->commit();
41
42?>
Note: See TracBrowser for help on using the repository browser.