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 | /*¡¡¤³¤Î¾¦ÉʤòÇã¤Ã¤¿¿Í¤Ï¤³¤ó¤Ê¾¦ÉʤâÇã¤Ã¤Æ¤¤¤Þ¤¹¡£½¸·×¥Õ¥¡¥¤¥ë */ |
---|
9 | require_once(DATA_PATH . "lib/slib.php"); |
---|
10 | require_once(DATA_PATH . "lib/glib.php"); |
---|
11 | require_once(DATA_PATH . "class/SC_Query.php"); |
---|
12 | require_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"); |
---|
19 | foreach($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.