Changeset 16348 for branches/beta/html/mobile/nonmember/complete.php
- Timestamp:
- 2007/10/09 17:17:11 (19 years ago)
- File:
-
- 1 edited
-
branches/beta/html/mobile/nonmember/complete.php (modified) (31 diffs)
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 }
Note: See TracChangeset
for help on using the changeset viewer.
