Changeset 16348 for branches/beta/html
- Timestamp:
- 2007/10/09 17:17:11 (16 years ago)
- Location:
- branches/beta/html/mobile
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/beta/html/mobile/nonmember/complete.php
r15120 r16348 1 1 <?php 2 2 /** 3 * 3 * 4 4 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved. 5 5 * 6 6 * http://www.lockon.co.jp/ 7 * 7 * 8 8 */ 9 9 require_once("../require.php"); … … 27 27 private-no-expire:¥¯¥é¥¤¥¢¥ó¥È¤Î¥¥ã¥Ã¥·¥å¤òµö²Ä¤¹¤ë¡£ 28 28 */ 29 session_cache_limiter('private-no-expire'); 29 session_cache_limiter('private-no-expire'); 30 30 31 31 } … … 46 46 $uniqid = sfCheckNormalAccess($objSiteSess, $objCartSess); 47 47 if ($uniqid != "") { 48 48 49 49 // ´°Î»½èÍý 50 50 $objQuery = new SC_Query(); … … 52 52 $order_id = lfDoComplete($objQuery, $uniqid); 53 53 $objQuery->commit(); 54 54 55 55 // ¥»¥Ã¥·¥ç¥ó¤ËÊݴɤµ¤ì¤Æ¤¤¤ë¾ðÊó¤ò¹¹¿·¤¹¤ë 56 56 $objCustomer->updateSession(); … … 59 59 if($order_id != "") { 60 60 $order_email = $objQuery->select("order_email", "dtb_order", "order_id = ?", array($order_id)); 61 61 62 62 //ÅÐÏ¿¤µ¤ì¤Æ¤¤¤ë¥á¡¼¥ë¥¢¥É¥ì¥¹¤¬·ÈÂÓ¤«PC¤«¤Ë±þ¤¸¤ÆÃíʸ´°Î»¥á¡¼¥ë¤Î¥Æ¥ó¥×¥ì¡¼¥È¤òÊѤ¨¤ë 63 63 if(ereg("(ezweb.ne.jp$|docomo.ne.jp$|softbank.ne.jp$|vodafone.ne.jp$)",$order_email[0]['order_email'])){ 64 sfSendOrderMail($order_id, '2',"",""); 65 }else{ 64 66 sfSendOrderMail($order_id, '1',"",""); 65 }else{66 sfSendOrderMail($order_id, '0',"","");67 67 } 68 68 } … … 71 71 if($other_data != "") { 72 72 $arrOther = unserialize($other_data); 73 73 74 74 // ¥Ç¡¼¥¿¤òÊÔ½¸ 75 75 foreach($arrOther as $key => $val){ … … 79 79 } 80 80 } 81 81 82 82 $objPage->arrOther = $arrOther; 83 84 } 85 83 84 } 85 86 86 // ¥¢¥Õ¥£¥ê¥¨¥¤¥ÈÍÑ¥³¥ó¥Ð¡¼¥¸¥ç¥ó¥¿¥°¤ÎÀßÄê 87 87 $objPage->tpl_conv_page = AFF_SHOPPING_COMPLETE; … … 104 104 $col = "customer_id, total, order_sex, order_job, to_number(to_char(age(current_timestamp, order_birth), 'YYY'), 999) AS order_age"; 105 105 $arrRet = $objQuery->select($col, "dtb_order", "order_id = ?", array($order_id)); 106 106 107 107 if($arrRet[0]['customer_id'] > 0) { 108 108 // ²ñ°÷ÈÖ¹æ … … 114 114 $arrEbis['m1id'] = ''; 115 115 // Èó²ñ°÷or²ñ°÷ 116 $arrEbis['o5id'] = '2'; 117 } 118 116 $arrEbis['o5id'] = '2'; 117 } 118 119 119 // ¹ØÆþ¶â³Û 120 120 $arrEbis['a1id'] = $arrRet[0]['total']; … … 125 125 // ¿¦¶È 126 126 $arrEbis['o4id'] = $arrRet[0]['order_job']; 127 127 128 128 $objQuery->setgroupby("product_id"); 129 129 $arrRet = $objQuery->select("product_id", "dtb_order_detail", "order_id = ?", array($order_id)); 130 130 $arrProducts = sfSwapArray($arrRet); 131 131 132 132 $line = ""; 133 133 // ¾¦ÉÊID¤ò¥¢¥ó¥À¡¼¥Ð¡¼¤ÇÀܳ¤¹¤ë¡£ 134 134 foreach($arrProducts['product_id'] as $val) { 135 135 if($line != "") { 136 $line .= "_$val"; 136 $line .= "_$val"; 137 137 } else { 138 138 $line .= "$val"; 139 139 } 140 140 } 141 142 // ¾¦ÉÊID 141 142 // ¾¦ÉÊID 143 143 $arrEbis['o1id'] = $line; 144 144 145 145 return $arrEbis; 146 146 } … … 152 152 global $objCustomer; 153 153 global $arrInfo; 154 154 155 155 // °ì»þ¼õÃí¥Æ¡¼¥Ö¥ë¤ÎÆÉ¹þ 156 156 $arrData = sfGetOrderTemp($uniqid); 157 157 158 158 // ²ñ°÷¾ðÊóÅÐÏ¿½èÍý 159 159 if ($objCustomer->isLoginSuccess()) { … … 183 183 break; 184 184 } 185 185 186 186 } 187 187 // °ì»þ¥Æ¡¼¥Ö¥ë¤ò¼õÃí¥Æ¡¼¥Ö¥ë¤Ë³ÊǼ¤¹¤ë … … 191 191 // ¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤Î¾ðÊó¤òºï½ü¤¹¤ë¡£ 192 192 lfDeleteTempOrder($objQuery, $uniqid); 193 193 194 194 // ¥»¥Ã¥·¥ç¥ó¥«¡¼¥ÈÆâ¤Î¾¦Éʤòºï½ü¤¹¤ë¡£ 195 195 $objCartSess->delAllProducts(); 196 196 // Ãíʸ°ì»þID¤ò²ò½ü¤¹¤ë¡£ 197 197 $objSiteSess->unsetUniqId(); 198 198 199 199 return $order_id; 200 200 } … … 240 240 } 241 241 $sqlval['mailmaga_flg'] = $mail_flag; 242 242 243 243 // ²ñ°÷²¾ÅÐÏ¿ 244 244 $sqlval['status'] = 1; 245 245 // URLȽÄêÍÑ¥¡¼ 246 $sqlval['secret_key'] = sfGetUniqRandomId("t"); 247 246 $sqlval['secret_key'] = sfGetUniqRandomId("t"); 247 248 248 $objQuery = new SC_Query(); 249 249 $sqlval['create_date'] = "now()"; 250 250 $sqlval['update_date'] = "now()"; 251 251 $objQuery->insert("dtb_customer", $sqlval); 252 252 253 253 // ¸ÜµÒID¤Î¼èÆÀ 254 254 $arrRet = $objQuery->select("customer_id", "dtb_customer", "secret_key = ?", array($sqlval['secret_key'])); … … 261 261 $objMailPage->CONF = $arrInfo; 262 262 $objMailPage->uniqid = $sqlval['secret_key']; 263 $objMailView = new SC_ SiteView();263 $objMailView = new SC_MobileView(); 264 264 $objMailView->assignobj($objMailPage); 265 265 $body = $objMailView->fetch("mail_templates/customer_mail.tpl"); 266 266 267 267 $objMail = new GC_SendMail(); 268 268 $objMail->setItem( … … 279 279 // °¸Àè¤ÎÀßÄê 280 280 $name = $arrData['order_name01'] . $arrData['order_name02'] ." ÍÍ"; 281 $objMail->setTo($arrData['order_email'], $name); 281 $objMail->setTo($arrData['order_email'], $name); 282 282 $objMail->sendMail(); 283 283 284 284 return $customer_id; 285 285 } … … 288 288 function lfCopyDeliv($uniqid, $arrData) { 289 289 $objQuery = new SC_Query(); 290 290 291 291 // Ê̤ΤªÆÏ¤±Àè¤ò»ØÄꤷ¤Æ¤¤¤Ê¤¤¾ì¹ç¡¢ÇÛÁ÷Àè¤ËÅÐÏ¿½»½ê¤ò¥³¥Ô¡¼¤¹¤ë¡£ 292 292 if($arrData["deliv_check"] != "1") { … … 323 323 // Ãíʸ¥¹¥Æ¡¼¥¿¥¹:»ØÄ̵꤬¤±¤ì¤Ð¿·µ¬¼õÉÕ¤ËÀßÄê 324 324 if($sqlval["status"] == ""){ 325 $sqlval['status'] = '1'; 326 } 327 325 $sqlval['status'] = '1'; 326 } 327 328 328 // Ê̤ΤªÆÏ¤±Àè¤ò»ØÄꤷ¤Æ¤¤¤Ê¤¤¾ì¹ç¡¢ÇÛÁ÷Àè¤ËÅÐÏ¿½»½ê¤ò¥³¥Ô¡¼¤¹¤ë¡£ 329 329 if($arrData["deliv_check"] != "1") { … … 341 341 $sqlval['deliv_tel03'] = $arrData['order_tel03']; 342 342 } 343 343 344 344 $order_id = $arrData['order_id']; // ¥ª¡¼¥À¡¼ID 345 345 $sqlval['create_date'] = 'now()'; // ¼õÃíÆü 346 346 347 347 // ¥²¥Ã¥È¤ÎÃͤò¥¤¥ó¥µ¡¼¥È 348 348 //$sqlval = lfGetInsParam($sqlval); 349 349 350 350 // INSERT¤Î¼Â¹Ô 351 351 $objQuery->insert("dtb_order", $sqlval); … … 359 359 $arrCart = $objCartSess->getCartList(); 360 360 $max = count($arrCart); 361 361 362 362 // ´û¤Ë¸ºß¤¹¤ë¾ÜºÙ¥ì¥³¡¼¥É¤ò¾Ã¤·¤Æ¤ª¤¯¡£ 363 363 $objQuery->delete("dtb_order_detail", "order_id = $order_id"); … … 367 367 // µ¬³ÊʬÎà̾°ìÍ÷ 368 368 $arrClassCatName = sfGetIDValueList("dtb_classcategory", "classcategory_id", "name"); 369 369 370 370 for ($i = 0; $i < $max; $i++) { 371 // ¾¦Éʵ¬³Ê¾ðÊó¤Î¼èÆÀ 371 // ¾¦Éʵ¬³Ê¾ðÊó¤Î¼èÆÀ 372 372 $arrData = sfGetProductsClass($arrCart[$i]['id']); 373 373 374 374 // ¸ºß¤¹¤ë¾¦ÉʤΤßɽ¼¨¤¹¤ë¡£ 375 375 if($arrData != "") { … … 382 382 $sqlval['classcategory_name1'] = $arrClassCatName[$arrData['classcategory_id1']]; 383 383 $sqlval['classcategory_name2'] = $arrClassCatName[$arrData['classcategory_id2']]; 384 $sqlval['point_rate'] = $arrCart[$i]['point_rate']; 384 $sqlval['point_rate'] = $arrCart[$i]['point_rate']; 385 385 $sqlval['price'] = $arrCart[$i]['price']; 386 386 $sqlval['quantity'] = $arrCart[$i]['quantity']; … … 407 407 $diff = false; 408 408 $find_same = false; 409 409 410 410 $col = "deliv_name01,deliv_name02,deliv_kana01,deliv_kana02,deliv_tel01,deliv_tel02,deliv_tel03,deliv_zip01,deliv_zip02,deliv_pref,deliv_addr01,deliv_addr02"; 411 411 $where = "order_temp_id = ?"; 412 412 $arrRet = $objQuery->select($col, "dtb_order_temp", $where, array($uniqid)); 413 413 414 414 // Í×ÁÇ̾¤Îdeliv_¤òºï½ü¤¹¤ë¡£ 415 415 foreach($arrRet[0] as $key => $val) { … … 417 417 $arrNew[$keyname] = $val; 418 418 } 419 419 420 420 // ²ñ°÷¾ðÊ󥯡¼¥Ö¥ë¤È¤ÎÈæ³Ó 421 421 $col = "name01,name02,kana01,kana02,tel01,tel02,tel03,zip01,zip02,pref,addr01,addr02"; 422 422 $where = "customer_id = ?"; 423 423 $arrCustomerAddr = $objQuery->select($col, "dtb_customer", $where, array($customer_id)); 424 424 425 425 // ²ñ°÷¾ðÊó¤Î½»½ê¤È°Û¤Ê¤ë¾ì¹ç 426 426 if($arrNew != $arrCustomerAddr[0]) { … … 436 436 } 437 437 } 438 438 439 439 if(!$find_same) { 440 440 $diff = true; 441 441 } 442 442 } 443 443 444 444 // ¿·¤·¤¤¤ªÆÏ¤±À褬ÅÐÏ¿ºÑ¤ß¤Î¤â¤Î¤È°Û¤Ê¤ë¾ì¹ç¤ÏÊ̤ΤªÆÏ¤±Àè¥Æ¡¼¥Ö¥ë¤ËÅÐÏ¿¤¹¤ë 445 445 if($diff) { … … 456 456 $arrRet = $objQuery->select($col, "dtb_customer", $where, array($customer_id)); 457 457 $sqlval = $arrRet[0]; 458 458 459 459 if($sqlval['first_buy_date'] == "") { 460 460 $sqlval['first_buy_date'] = "Now()"; … … 464 464 $sqlval['buy_total']+= $arrData['total']; 465 465 $sqlval['point'] = ($sqlval['point'] + $arrData['add_point'] - $arrData['use_point']); 466 466 467 467 // ¥Ý¥¤¥ó¥È¤¬ÉÔ¤·¤Æ¤¤¤ë¾ì¹ç 468 468 if($sqlval['point'] < 0) { … … 470 470 sfDispSiteError(LACK_POINT); 471 471 } 472 472 473 473 $objQuery->update("dtb_customer", $sqlval, $where, array($customer_id)); 474 474 } … … 478 478 $where = "product_id = ? AND classcategory_id1 = ? AND classcategory_id2 = ?"; 479 479 $arrRet = $objQuery->select("stock, stock_unlimited", "dtb_products_class", $where, $arrID); 480 480 481 481 // Çä¤êÀڤ쥨¥é¡¼ 482 482 if(($arrRet[0]['stock_unlimited'] != '1' && $arrRet[0]['stock'] < $quantity) || $quantity == 0) { … … 492 492 if($sqlval['stock'] == "") { 493 493 $sqlval['stock'] = '0'; 494 } 494 } 495 495 $objQuery->update("dtb_products_class", $sqlval, $where, $arrID); 496 496 } … … 499 499 // GET¤ÎÃͤò¥¤¥ó¥µ¡¼¥ÈÍѤËÀ°¤¨¤ë 500 500 function lfGetInsParam($sqlVal){ 501 501 502 502 foreach($_GET as $key => $val){ 503 503 // ¥«¥é¥à¤Î¸ºß¥Á¥§¥Ã¥¯ 504 504 if(sfColumnExists("dtb_order", $key)) $sqlVal[$key] = $val; 505 505 } 506 506 507 507 return $sqlVal; 508 508 } -
branches/beta/html/mobile/shopping/complete.php
r14899 r16348 1 1 <?php 2 2 /** 3 * 3 * 4 4 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved. 5 5 * 6 6 * http://www.lockon.co.jp/ 7 * 7 * 8 8 */ 9 9 require_once("../require.php"); … … 27 27 private-no-expire:¥¯¥é¥¤¥¢¥ó¥È¤Î¥¥ã¥Ã¥·¥å¤òµö²Ä¤¹¤ë¡£ 28 28 */ 29 session_cache_limiter('private-no-expire'); 29 session_cache_limiter('private-no-expire'); 30 30 31 31 } … … 46 46 $uniqid = sfCheckNormalAccess($objSiteSess, $objCartSess); 47 47 if ($uniqid != "") { 48 48 49 49 // ´°Î»½èÍý 50 50 $objQuery = new SC_Query(); … … 52 52 $order_id = lfDoComplete($objQuery, $uniqid); 53 53 $objQuery->commit(); 54 54 55 55 // ¥»¥Ã¥·¥ç¥ó¤ËÊݴɤµ¤ì¤Æ¤¤¤ë¾ðÊó¤ò¹¹¿·¤¹¤ë 56 56 $objCustomer->updateSession(); … … 59 59 if($order_id != "") { 60 60 $order_email = $objQuery->select("order_email", "dtb_order", "order_id = ?", array($order_id)); 61 61 62 62 //ÅÐÏ¿¤µ¤ì¤Æ¤¤¤ë¥á¡¼¥ë¥¢¥É¥ì¥¹¤¬·ÈÂÓ¤«PC¤«¤Ë±þ¤¸¤ÆÃíʸ´°Î»¥á¡¼¥ë¤Î¥Æ¥ó¥×¥ì¡¼¥È¤òÊѤ¨¤ë 63 63 if(ereg("(ezweb.ne.jp$|docomo.ne.jp$|softbank.ne.jp$|vodafone.ne.jp$)",$order_email[0]['order_email'])){ 64 sfSendOrderMail($order_id, '2', '', ''); 65 }else{ 64 66 sfSendOrderMail($order_id, '1', '', ''); 65 }else{66 sfSendOrderMail($order_id, '0', '', '');67 67 } 68 68 } … … 72 72 if($other_data != "") { 73 73 $arrOther = unserialize($other_data); 74 74 75 75 // ¥Ç¡¼¥¿¤òÊÔ½¸ 76 76 foreach($arrOther as $key => $val){ … … 80 80 } 81 81 } 82 82 83 83 $objPage->arrOther = $arrOther; 84 85 } 86 84 85 } 86 87 87 // ¥¢¥Õ¥£¥ê¥¨¥¤¥ÈÍÑ¥³¥ó¥Ð¡¼¥¸¥ç¥ó¥¿¥°¤ÎÀßÄê 88 88 $objPage->tpl_conv_page = AFF_SHOPPING_COMPLETE; … … 105 105 $col = "customer_id, total, order_sex, order_job, to_number(to_char(age(current_timestamp, order_birth), 'YYY'), 999) AS order_age"; 106 106 $arrRet = $objQuery->select($col, "dtb_order", "order_id = ?", array($order_id)); 107 107 108 108 if($arrRet[0]['customer_id'] > 0) { 109 109 // ²ñ°÷ÈÖ¹æ … … 115 115 $arrEbis['m1id'] = ''; 116 116 // Èó²ñ°÷or²ñ°÷ 117 $arrEbis['o5id'] = '2'; 118 } 119 117 $arrEbis['o5id'] = '2'; 118 } 119 120 120 // ¹ØÆþ¶â³Û 121 121 $arrEbis['a1id'] = $arrRet[0]['total']; … … 126 126 // ¿¦¶È 127 127 $arrEbis['o4id'] = $arrRet[0]['order_job']; 128 128 129 129 $objQuery->setgroupby("product_id"); 130 130 $arrRet = $objQuery->select("product_id", "dtb_order_detail", "order_id = ?", array($order_id)); 131 131 $arrProducts = sfSwapArray($arrRet); 132 132 133 133 $line = ""; 134 134 // ¾¦ÉÊID¤ò¥¢¥ó¥À¡¼¥Ð¡¼¤ÇÀܳ¤¹¤ë¡£ 135 135 foreach($arrProducts['product_id'] as $val) { 136 136 if($line != "") { 137 $line .= "_$val"; 137 $line .= "_$val"; 138 138 } else { 139 139 $line .= "$val"; 140 140 } 141 141 } 142 143 // ¾¦ÉÊID 142 143 // ¾¦ÉÊID 144 144 $arrEbis['o1id'] = $line; 145 145 146 146 return $arrEbis; 147 147 } … … 153 153 global $objCustomer; 154 154 global $arrInfo; 155 155 156 156 // °ì»þ¼õÃí¥Æ¡¼¥Ö¥ë¤ÎÆÉ¹þ 157 157 $arrData = sfGetOrderTemp($uniqid); 158 158 159 159 // ²ñ°÷¾ðÊóÅÐÏ¿½èÍý 160 160 if ($objCustomer->isLoginSuccess()) { … … 184 184 break; 185 185 } 186 186 187 187 } 188 188 // °ì»þ¥Æ¡¼¥Ö¥ë¤ò¼õÃí¥Æ¡¼¥Ö¥ë¤Ë³ÊǼ¤¹¤ë … … 192 192 // ¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤Î¾ðÊó¤òºï½ü¤¹¤ë¡£ 193 193 lfDeleteTempOrder($objQuery, $uniqid); 194 194 195 195 // ¥»¥Ã¥·¥ç¥ó¥«¡¼¥ÈÆâ¤Î¾¦Éʤòºï½ü¤¹¤ë¡£ 196 196 $objCartSess->delAllProducts(); 197 197 // Ãíʸ°ì»þID¤ò²ò½ü¤¹¤ë¡£ 198 198 $objSiteSess->unsetUniqId(); 199 199 200 200 return $order_id; 201 201 } … … 241 241 } 242 242 $sqlval['mailmaga_flg'] = $mail_flag; 243 243 244 244 // ²ñ°÷²¾ÅÐÏ¿ 245 245 $sqlval['status'] = 1; 246 246 // URLȽÄêÍÑ¥¡¼ 247 $sqlval['secret_key'] = sfGetUniqRandomId("t"); 248 247 $sqlval['secret_key'] = sfGetUniqRandomId("t"); 248 249 249 $objQuery = new SC_Query(); 250 250 $sqlval['create_date'] = "now()"; 251 251 $sqlval['update_date'] = "now()"; 252 252 $objQuery->insert("dtb_customer", $sqlval); 253 253 254 254 // ¸ÜµÒID¤Î¼èÆÀ 255 255 $arrRet = $objQuery->select("customer_id", "dtb_customer", "secret_key = ?", array($sqlval['secret_key'])); … … 262 262 $objMailPage->CONF = $arrInfo; 263 263 $objMailPage->uniqid = $sqlval['secret_key']; 264 $objMailView = new SC_ SiteView();264 $objMailView = new SC_MobileView(); 265 265 $objMailView->assignobj($objMailPage); 266 266 $body = $objMailView->fetch("/mail_templates/customer_mail.tpl"); 267 267 268 268 $objMail = new GC_SendMail(); 269 269 $objMail->setItem( … … 281 281 $name = $arrData['order_name01'] . $arrData['order_name02'] ." ÍÍ"; 282 282 $arrData['order_email'] = $objQuery->select("email_mobile", "dtb_customer", "secret_key = ?", array($sqlval['secret_key'])); 283 $objMail->setTo($arrData['order_email'], $name); 283 $objMail->setTo($arrData['order_email'], $name); 284 284 $objMail->sendMail(); 285 285 286 286 return $customer_id; 287 287 } … … 290 290 function lfCopyDeliv($uniqid, $arrData) { 291 291 $objQuery = new SC_Query(); 292 292 293 293 // Ê̤ΤªÆÏ¤±Àè¤ò»ØÄꤷ¤Æ¤¤¤Ê¤¤¾ì¹ç¡¢ÇÛÁ÷Àè¤ËÅÐÏ¿½»½ê¤ò¥³¥Ô¡¼¤¹¤ë¡£ 294 294 if($arrData["deliv_check"] != "1") { … … 326 326 // Ãíʸ¥¹¥Æ¡¼¥¿¥¹:»ØÄ̵꤬¤±¤ì¤Ð¿·µ¬¼õÉÕ¤ËÀßÄê 327 327 if($sqlval["status"] == ""){ 328 $sqlval['status'] = '1'; 329 } 330 328 $sqlval['status'] = '1'; 329 } 330 331 331 // Ê̤ΤªÆÏ¤±Àè¤ò»ØÄꤷ¤Æ¤¤¤Ê¤¤¾ì¹ç¡¢ÇÛÁ÷Àè¤ËÅÐÏ¿½»½ê¤ò¥³¥Ô¡¼¤¹¤ë¡£ 332 332 if($arrData["deliv_check"] != "1") { … … 344 344 $sqlval['deliv_tel03'] = $arrData['order_tel03']; 345 345 } 346 346 347 347 $order_id = $arrData['order_id']; // ¥ª¡¼¥À¡¼ID 348 348 $sqlval['create_date'] = 'now()'; // ¼õÃíÆü 349 349 350 350 // ¥²¥Ã¥È¤ÎÃͤò¥¤¥ó¥µ¡¼¥È 351 351 //$sqlval = lfGetInsParam($sqlval); 352 352 353 353 // INSERT¤Î¼Â¹Ô 354 354 $objQuery->insert("dtb_order", $sqlval); … … 362 362 $arrCart = $objCartSess->getCartList(); 363 363 $max = count($arrCart); 364 364 365 365 // ´û¤Ë¸ºß¤¹¤ë¾ÜºÙ¥ì¥³¡¼¥É¤ò¾Ã¤·¤Æ¤ª¤¯¡£ 366 366 $objQuery->delete("dtb_order_detail", "order_id = $order_id"); … … 370 370 // µ¬³ÊʬÎà̾°ìÍ÷ 371 371 $arrClassCatName = sfGetIDValueList("dtb_classcategory", "classcategory_id", "name"); 372 372 373 373 for ($i = 0; $i < $max; $i++) { 374 // ¾¦Éʵ¬³Ê¾ðÊó¤Î¼èÆÀ 374 // ¾¦Éʵ¬³Ê¾ðÊó¤Î¼èÆÀ 375 375 $arrData = sfGetProductsClass($arrCart[$i]['id']); 376 376 377 377 // ¸ºß¤¹¤ë¾¦ÉʤΤßɽ¼¨¤¹¤ë¡£ 378 378 if($arrData != "") { … … 385 385 $sqlval['classcategory_name1'] = $arrClassCatName[$arrData['classcategory_id1']]; 386 386 $sqlval['classcategory_name2'] = $arrClassCatName[$arrData['classcategory_id2']]; 387 $sqlval['point_rate'] = $arrCart[$i]['point_rate']; 387 $sqlval['point_rate'] = $arrCart[$i]['point_rate']; 388 388 $sqlval['price'] = $arrCart[$i]['price']; 389 389 $sqlval['quantity'] = $arrCart[$i]['quantity']; … … 410 410 $diff = false; 411 411 $find_same = false; 412 412 413 413 $col = "deliv_name01,deliv_name02,deliv_kana01,deliv_kana02,deliv_tel01,deliv_tel02,deliv_tel03,deliv_zip01,deliv_zip02,deliv_pref,deliv_addr01,deliv_addr02"; 414 414 $where = "order_temp_id = ?"; 415 415 $arrRet = $objQuery->select($col, "dtb_order_temp", $where, array($uniqid)); 416 416 417 417 // Í×ÁÇ̾¤Îdeliv_¤òºï½ü¤¹¤ë¡£ 418 418 foreach($arrRet[0] as $key => $val) { … … 420 420 $arrNew[$keyname] = $val; 421 421 } 422 422 423 423 // ²ñ°÷¾ðÊ󥯡¼¥Ö¥ë¤È¤ÎÈæ³Ó 424 424 $col = "name01,name02,kana01,kana02,tel01,tel02,tel03,zip01,zip02,pref,addr01,addr02"; 425 425 $where = "customer_id = ?"; 426 426 $arrCustomerAddr = $objQuery->select($col, "dtb_customer", $where, array($customer_id)); 427 427 428 428 // ²ñ°÷¾ðÊó¤Î½»½ê¤È°Û¤Ê¤ë¾ì¹ç 429 429 if($arrNew != $arrCustomerAddr[0]) { … … 439 439 } 440 440 } 441 441 442 442 if(!$find_same) { 443 443 $diff = true; 444 444 } 445 445 } 446 446 447 447 // ¿·¤·¤¤¤ªÆÏ¤±À褬ÅÐÏ¿ºÑ¤ß¤Î¤â¤Î¤È°Û¤Ê¤ë¾ì¹ç¤ÏÊ̤ΤªÆÏ¤±Àè¥Æ¡¼¥Ö¥ë¤ËÅÐÏ¿¤¹¤ë 448 448 if($diff) { … … 459 459 $arrRet = $objQuery->select($col, "dtb_customer", $where, array($customer_id)); 460 460 $sqlval = $arrRet[0]; 461 461 462 462 if($sqlval['first_buy_date'] == "") { 463 463 $sqlval['first_buy_date'] = "Now()"; … … 467 467 $sqlval['buy_total']+= $arrData['total']; 468 468 $sqlval['point'] = ($sqlval['point'] + $arrData['add_point'] - $arrData['use_point']); 469 469 470 470 // ¥Ý¥¤¥ó¥È¤¬ÉÔ¤·¤Æ¤¤¤ë¾ì¹ç 471 471 if($sqlval['point'] < 0) { … … 473 473 sfDispSiteError(LACK_POINT); 474 474 } 475 475 476 476 $objQuery->update("dtb_customer", $sqlval, $where, array($customer_id)); 477 477 } … … 481 481 $where = "product_id = ? AND classcategory_id1 = ? AND classcategory_id2 = ?"; 482 482 $arrRet = $objQuery->select("stock, stock_unlimited", "dtb_products_class", $where, $arrID); 483 483 484 484 // Çä¤êÀڤ쥨¥é¡¼ 485 485 if(($arrRet[0]['stock_unlimited'] != '1' && $arrRet[0]['stock'] < $quantity) || $quantity == 0) { … … 495 495 if($sqlval['stock'] == "") { 496 496 $sqlval['stock'] = '0'; 497 } 497 } 498 498 $objQuery->update("dtb_products_class", $sqlval, $where, $arrID); 499 499 } … … 502 502 // GET¤ÎÃͤò¥¤¥ó¥µ¡¼¥ÈÍѤËÀ°¤¨¤ë 503 503 function lfGetInsParam($sqlVal){ 504 504 505 505 foreach($_GET as $key => $val){ 506 506 // ¥«¥é¥à¤Î¸ºß¥Á¥§¥Ã¥¯ 507 507 if(sfColumnExists("dtb_order", $key)) $sqlVal[$key] = $val; 508 508 } 509 509 510 510 return $sqlVal; 511 511 }
Note: See TracChangeset
for help on using the changeset viewer.