- Timestamp:
- 2007/07/20 15:58:59 (17 years ago)
- Location:
- branches/feature-module-update
- Files:
-
- 1 edited
- 2 copied
Legend:
- Unmodified
- Added
- Removed
-
branches/feature-module-update
-
Property
svn:ignore
set to
.cache
.settings
.projectOptions
-
Property
svn:ignore
set to
-
branches/feature-module-update/html/products/batch_relate.php
r12157 r15078 6 6 */ 7 7 8 /* ¡¡¤³¤Î¾¦ÉʤòÇã¤Ã¤¿¿Í¤Ï¤³¤ó¤Ê¾¦ÉʤâÇã¤Ã¤Æ¤¤¤Þ¤¹¡£½¸·×¥Õ¥¡¥¤¥ë*/8 /* この商品を買った人はこんな商品も買っています。集計ファイル */ 9 9 require_once(DATA_PATH . "lib/slib.php"); 10 10 require_once(DATA_PATH . "lib/glib.php"); … … 19 19 foreach($arrCID as $cdata) { 20 20 $where = "order_id IN (SELECT order_id FROM dtb_order WHERE customer_id = ? )"; 21 // ¸ÜµÒ¤¬¹ØÆþ¤·¤¿¾¦ÉʣɣĤò¼èÆÀ¤¹¤ë21 //顧客が購入した商品IDを取得する 22 22 $arrPID = $objQuery->select("product_id", "dtb_order_detail", $where, array($cdata['customer_id'])); 23 // ¸ÜµÒ¤¬¾¦ÉʤòÊ£¿ô¹ØÆþ¤·¤Æ¤¤¤ì¤Ð23 //顧客が商品を複数購入していれば 24 24 if(count($arrPID) > 1) { 25 25 foreach($arrPID as $pdata1) { 26 // ¤³¤Î¾¦ÉÊID26 //この商品ID 27 27 $sqlval['product_id'] = $pdata1['product_id']; 28 28 foreach($arrPID as $pdata2) { 29 29 if($pdata2['product_id'] != $pdata1['product_id']) { 30 // ¤³¤ó¤Ê¾¦ÉÊID30 //こんな商品ID 31 31 $sqlval['relate_product_id'] = $pdata2['product_id']; 32 32 $sqlval['create_date'] = "now()"; 33 // ¥Ç¡¼¥¿ÁÞÆþ33 //データ挿入 34 34 $objQuery->insert("dtb_bat_relate_products", $sqlval); 35 35 }
Note: See TracChangeset
for help on using the changeset viewer.