Changeset 19889


Ignore:
Timestamp:
2011/01/12 16:03:37 (10 years ago)
Author:
ghana
Message:

#898
refs #898
顧客管理機能顧客マスタで顧客の削除ができない
autoExecute は MDB2 の Extended の機能のようなので
通常の update 文に変更

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_5-dev/data/class/pages/admin/customer/LC_Page_Admin_Customer.php

    r19807 r19889  
    268268 
    269269            if ($result_customer[0]["status"] == 2) {           //本会員削除 
    270                 $arrDel = array("del_flg" => 1, "update_date" => "NOW()"); 
    271                 $objQuery->conn->autoExecute("dtb_customer", $arrDel, "customer_id = " . SC_Utils_Ex::sfQuoteSmart($_POST["edit_customer_id"]) ); 
     270                $objQuery->exec("UPDATE dtb_customer SET del_flg=1, update_date=now() WHERE customer_id=?", array($_POST["edit_customer_id"])); 
    272271            } elseif ($result_customer[0]["status"] == 1) {     //仮会員削除 
    273272                $sql = "DELETE FROM dtb_customer WHERE customer_id = ?"; 
     
    408407 
    409408                    if ($result_customer[0]["status"] == 2) {           //本会員削除 
    410                         $arrDel = array("del_flg" => 1, "update_date" => "NOW()"); 
    411                         $objQuery->conn->autoExecute("dtb_customer", $arrDel, "customer_id = " . SC_Utils_Ex::sfQuoteSmart($_POST["del_customer_id"]) ); 
     409                        $objQuery->exec("UPDATE dtb_customer SET del_flg=1, update_date=now() WHERE customer_id=?", array($_POST["del_customer_id"])); 
    412410                    } elseif ($result_customer[0]["status"] == 1) {     //仮会員削除 
    413411                        $sql = "DELETE FROM dtb_customer WHERE customer_id = ?"; 
Note: See TracChangeset for help on using the changeset viewer.