Changeset 11216 for temp


Ignore:
Timestamp:
2006/12/24 03:38:42 (19 years ago)
Author:
uehara
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed
  • temp/branches/ec-cube-beta/html/campaign/default/entry.php

    r11212 r11216  
    146146            $objMail->sendMail(); 
    147147 
     148            // ¥­¥ã¥ó¥Ú¡¼¥ó¼õÃí¾ðÊó¤òÅÐÏ¿ 
     149            lfRegistCampaignOrder(); 
     150             
    148151            // ´°Î»¥Ú¡¼¥¸¤Ë°Üư¤µ¤»¤ë¡£ 
    149152            header("Location: ./complete.php"); 
     
    316319} 
    317320 
     321// ¥­¥ã¥ó¥Ú¡¼¥ó¼õÃí¥Æ¡¼¥Ö¥ë¤ØÅÐÏ¿ 
     322function lfRegistCampaignOrder($customer_id) { 
     323 
     324    global $objQuery; 
     325    global $objCampaignSess; 
     326    $campaign_id = $objCampaignSess->getCampaignId(); 
     327 
     328    // ¼õÃí¥Ç¡¼¥¿¤ò¼èÆÀ 
     329    $cols = " 
     330            customer_id, 
     331            name01 as order_name01, 
     332            name02 as order_name02, 
     333            kana01 as order_kana01, 
     334            kana02 as order_kana02, 
     335            zip01 as order_zip01, 
     336            zip02 as order_zip02, 
     337            pref as order_pref, 
     338            addr01 as order_addr01, 
     339            addr02 as order_addr02, 
     340            email as order_email, 
     341            tel01 as order_tel01, 
     342            tel02 as order_tel02, 
     343            tel03 as order_tel03, 
     344            fax01 as order_fax01, 
     345            fax02 as order_fax02, 
     346            fax03 as order_fax03, 
     347            sex as order_sex, 
     348            job as order_sex, 
     349            birth as order_birth, 
     350            cell01, 
     351            cell02, 
     352            cell03 
     353            "; 
     354             
     355    $arrCustomer = $objQuery->select($cols, "dtb_customer", "customer_id = ?", array($customer_id));  
     356 
     357    $sqlval = $arrCustomer[0]; 
     358    $sqlval['campaign_id'] = $campaign_id; 
     359    $sqlval['create_date'] = 'now()'; 
     360         
     361    // INSERT¤Î¼Â¹Ô 
     362    $objQuery->insert("dtb_campaign_order", $sqlval); 
     363     
     364    // ¿½¤·¹þ¤ß¿ô¤Î¹¹¿· 
     365    $total_count = $objQuery->get("dtb_campaign", "total_count", "campaign_id = ?", array($campaign_id)); 
     366    $arrCampaign['total_count'] = $total_count += 1; 
     367    $objQuery->update("dtb_campaign", $arrCampaign, "campaign_id = ?", array($campaign_id)); 
     368} 
     369 
    318370//³Îǧ¥Ú¡¼¥¸Íѥѥ¹¥ï¡¼¥Éɽ¼¨ÍÑ 
    319371 
Note: See TracChangeset for help on using the changeset viewer.