Index: branches/comu/html/admin/customer/index.php
===================================================================
--- branches/comu/html/admin/customer/index.php	(revision 11730)
+++ branches/comu/html/admin/customer/index.php	(revision 11982)
@@ -86,5 +86,5 @@
 
 //---- ¥Ú¡¼¥¸½é´üÀßÄê
-$objConn = new SC_DBConn();
+$objQuery = new SC_Query();
 $objPage = new LC_Page();
 $objView = new SC_AdminView();
@@ -123,15 +123,13 @@
 if ($_POST['mode'] == "delete") {
 	$sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND del_flg = 0";
-	$result_customer = $objConn->getAll($sql, array($_POST["edit_customer_id"]));
+	$result_customer = $objQuery->conn->getAll($sql, array($_POST["edit_customer_id"]));
 
 	if ($result_customer[0]["status"] == 2) {			//Ëܲñ°÷ºï½ü
 		$arrDel = array("del_flg" => 1, "update_date" => "NOW()"); 
-		$objConn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["edit_customer_id"]) );
+		$objQuery->conn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["edit_customer_id"]) );
 	} elseif ($result_customer[0]["status"] == 1) {		//²¾²ñ°÷ºï½ü
 		$sql = "DELETE FROM dtb_customer WHERE customer_id = ?";
-		$objConn->query($sql, array($_POST["edit_customer_id"]));
-	}
-	$sql = "DELETE FROM dtb_customer_mail WHERE email = ?";
-	$objConn->query($sql, array($result_customer[0]["email"]));
+		$objQuery->conn->query($sql, array($_POST["edit_customer_id"]));
+	}
 }
 if ($_POST['mode'] == "search" || $_POST['mode'] == "csv"  || $_POST['mode'] == "delete" || $_POST['mode'] == "delete_all") {
@@ -170,5 +168,5 @@
 		}
 		
-		$objPage->search_data = $objConn->getAll($searchSql, $objSelect->arrVal);
+		$objPage->search_data = $objQuery->conn->getAll($searchSql, $objSelect->arrVal);
 		
 		switch($_POST['mode']) {
@@ -209,15 +207,13 @@
 
 			$sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND del_flg = 0";
-			$result_customer = $objConn->getAll($sql, array($_POST["del_customer_id"]));
+			$result_customer = $objQuery->conn->getAll($sql, array($_POST["del_customer_id"]));
 
 			if ($result_customer[0]["status"] == 2) {			//Ëܲñ°÷ºï½ü
 				$arrDel = array("del_flg" => 1, "update_date" => "NOW()");
-				$objConn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["del_customer_id"]) );
+				$objQuery->conn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["del_customer_id"]) );
 			} elseif ($result_customer[0]["status"] == 1) {		//²¾²ñ°÷ºï½ü
 				$sql = "DELETE FROM dtb_customer WHERE customer_id = ?";
-				$objConn->query($sql, array($_POST["del_customer_id"]));
+				$objQuery->conn->query($sql, array($_POST["del_customer_id"]));
 			}
-			$sql = "DELETE FROM dtb_customer_mail WHERE email = ?";
-			$objConn->query($sql, array($result_customer[0]["email"]));	
 			
 			break;
@@ -225,5 +221,5 @@
 
 			// ¹Ô¿ô¤Î¼èÆÀ
-			$linemax = $objConn->getOne( $objSelect->getListCount(), $objSelect->arrVal);
+			$linemax = $objQuery->conn->getOne( $objSelect->getListCount(), $objSelect->arrVal);
 			$objPage->tpl_linemax = $linemax;				// ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ
 
@@ -316,4 +312,5 @@
 	$objErr->doFunc(array("ÃÂÀ¸·î", "birth_month", 2), array("NUM_CHECK","MAX_LENGTH_CHECK"));
 	$objErr->doFunc(array('¥á¡¼¥ë¥¢¥É¥ì¥¹', "email", STEXT_LEN) ,array("EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));
+	$objErr->doFunc(array('·ÈÂӥ᡼¥ë¥¢¥É¥ì¥¹', "email_mobile", STEXT_LEN) ,array("EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));	
 	$objErr->doFunc(array("ÅÅÏÃÈÖ¹æ", "tel", TEL_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
 	$objErr->doFunc(array("¹ØÆþ¶â³Û(³«»Ï)", "buy_total_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));