source: branches/feature-module-update/html/products/batch_relate.php @ 15079

Revision 15079, 1.3 KB checked in by nanasess, 17 years ago (diff)

svn:mime-type application/x-httpd-php; charset=UTF-8 設定

  • Property svn:mime-type set to application/x-httpd-php; charset=UTF-8
Line 
1<?php
2/*
3 * Copyright(c) 2000-2007 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    //顧客が購入した商品IDを取得する
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.