Changeset 11671
- Timestamp:
- 2007/03/09 13:28:36 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/html/mobile/shopping/complete.php
r11460 r11671 216 216 $sqlval['reminder'] = $arrData['reminder']; 217 217 $sqlval['reminder_answer'] = $arrData['reminder_answer']; 218 // ²ñ°÷²¾ÅÐÏ¿ 219 $sqlval['status'] = 1; 220 // URLȽÄêÍÑ¥¡¼ 221 $sqlval['secret_key'] = sfGetUniqRandomId("t"); 222 223 $objQuery = new SC_Query(); 224 $sqlval['create_date'] = "now()"; 225 $sqlval['update_date'] = "now()"; 226 $objQuery->insert("dtb_customer", $sqlval); 227 228 // ¸ÜµÒID¤Î¼èÆÀ 229 $arrRet = $objQuery->select("customer_id", "dtb_customer", "secret_key = ?", array($sqlval['secret_key'])); 230 $customer_id = $arrRet[0]['customer_id']; 231 218 232 219 // ¥á¥ë¥Þ¥¬ÇÛ¿®Íѥե饰¤ÎȽÄê 233 220 switch($arrData['mail_flag']) { … … 245 232 break; 246 233 } 247 234 $sqlval['mailmaga_flg'] = $mail_flag; 235 236 // ²ñ°÷²¾ÅÐÏ¿ 237 $sqlval['status'] = 1; 238 // URLȽÄêÍÑ¥¡¼ 239 $sqlval['secret_key'] = sfGetUniqRandomId("t"); 240 248 241 $objQuery = new SC_Query(); 249 $objQuery->begin(); 250 // ¥á¥ë¥Þ¥¬ÇÛ¿®Íѥơ¼¥Ö¥ëÅÐÏ¿ 251 lfRegistNonCustomer($arrData['order_email'], $mail_flag, $objQuery); 252 $objQuery->commit(); 242 $sqlval['create_date'] = "now()"; 243 $sqlval['update_date'] = "now()"; 244 $objQuery->insert("dtb_customer", $sqlval); 245 246 // ¸ÜµÒID¤Î¼èÆÀ 247 $arrRet = $objQuery->select("customer_id", "dtb_customer", "secret_key = ?", array($sqlval['secret_key'])); 248 $customer_id = $arrRet[0]['customer_id']; 253 249 254 250 //¡¡²¾ÅÐÏ¿´°Î»¥á¡¼¥ëÁ÷¿® … … 347 343 // INSERT¤Î¼Â¹Ô 348 344 $objQuery->insert("dtb_order", $sqlval); 349 350 // ¥á¥ë¥Þ¥¬ÇÛ¿®´õ˾¾ðÊó¤ÎÅÐÏ¿ 351 lfRegistNonCustomer($arrData['order_email'], $arrData['mail_flag'], $objQuery); 352 345 353 346 return $order_id; 354 347 } … … 474 467 } 475 468 476 /* Èó²ñ°÷¤Î¥á¥ë¥Þ¥¬¥Æ¡¼¥Ö¥ë¤Ø¤ÎÅÐÏ¿ */477 function lfRegistNonCustomer($email, $mail_flag, $objQuery) {478 // ²ñ°÷¤Î¥á¡¼¥ë¥¢¥É¥ì¥¹¤¬ÅÐÏ¿¤µ¤ì¤Æ¤¤¤Ê¤¤¾ì¹ç479 if(!sfCheckCustomerMailMaga($email)) {480 $where = "email = ?";481 $objQuery->delete("dtb_customer_mail", $where, array($email));482 $sqlval['email'] = $email;483 $sqlval['mail_flag'] = $mail_flag;484 $sqlval['create_date'] = "now()";485 $sqlval['update_date'] = "now()";486 $objQuery->insert("dtb_customer_mail", $sqlval);487 }488 }489 490 469 // ºß¸Ë¤ò¸º¤é¤¹½èÍý 491 470 function lfReduceStock($objQuery, $arrID, $quantity) {
Note: See TracChangeset
for help on using the changeset viewer.