Changeset 11984 for branches/comu/data/lib

Timestamp:

2007/03/28 15:05:09 (16 years ago)

Author:

uehara

Message:

 

File:

• branches/comu/data/lib/slib.php (modified) (17 diffs)

branches/comu/data/lib/slib.php

@@ -84 +84 @@
 }
 
-// ¥«¥é¥à¤Î¸ºß¥Á¥§¥Ã¥¯
+// ¥«¥é¥à¤Î¸ºß¥Á¥§¥Ã¥¯¤ÈºîÀ®
 function sfColumnExists($table_name, $col_name, $col_type = "", $dsn = "", $add = false) {
     if($dsn == "") {
@@ -117 +117 @@
     }
     
+    return false;
+}
+
+// ¥¤¥ó¥Ç¥Ã¥¯¥¹¤Î¸ºß¥Á¥§¥Ã¥¯¤ÈºîÀ®
+function sfIndexExists($table_name, $col_name, $index_name, $length = "", $dsn = "", $add = false) {
+    if($dsn == "") {
+        if(defined('DEFAULT_DSN')) {
+            $dsn = DEFAULT_DSN;
+        } else {
+            return;
+        }
+    }
+
+    // ¥Æ¡¼¥Ö¥ë¤¬Ìµ¤±¤ì¤Ð¥¨¥é¡¼
+    if(!sfTabaleExists($table_name, $dsn)) return false;
+    
+    $objQuery = new SC_Query($dsn, true, true);
+    // Àµ¾ï¤ËÀܳ¤µ¤ì¤Æ¤¤¤ë¾ì¹ç
+    if(!$objQuery->isError()) {
+        list($db_type) = split(":", $dsn);      
+        switch($db_type) {
+        case 'pgsql':
+            // ¥¤¥ó¥Ç¥Ã¥¯¥¹¤Î¸ºß³Îǧ
+            $arrRet = $objQuery->getAll("SELECT relname FROM pg_class WHERE relname = ?", array($index_name));
+            break;
+        case 'mysql':
+            // ¥¤¥ó¥Ç¥Ã¥¯¥¹¤Î¸ºß³Îǧ
+            $arrRet = $objQuery->getAll("SHOW INDEX FROM ? WHERE Key_name = ?", array($table_name, $index_name));           
+            break;
+        default:
+            return false;
+        }
+        // ¤¹¤Ç¤Ë¥¤¥ó¥Ç¥Ã¥¯¥¹¤¬Â¸ºß¤¹¤ë¾ì¹ç
+        if(count($arrRet) > 0) {
+            return true;
+        }
+    }
+    
+    // ¥¤¥ó¥Ç¥Ã¥¯¥¹¤òºîÀ®¤¹¤ë
+    if($add){
+        switch($db_type) {
+        case 'pgsql':
+            $objQuery->query("CREATE INDEX ? ON ? (?)", array($index_name, $table_name, $col_name));
+            break;
+        case 'mysql':
+            $objQuery->query("CREATE INDEX ? ON ? (?(?))", array($index_name, $table_name, $col_name, $length));            
+            break;
+        default:
+            return false;
+        }
+        return true;
+    }   
     return false;
 }
@@ -143 +195 @@
     
     return $ret;
+}
+
+/*
+ * ¥µ¥¤¥È´ÉÍý¾ðÊ󤫤éÃͤò¼èÆÀ¤¹¤ë¡£
+ * ¥Ç¡¼¥¿¤¬Â¸ºß¤¹¤ë¾ì¹ç¡¢É¬¤º1°Ê¾å¤Î¿ôÃͤ¬ÀßÄꤵ¤ì¤Æ¤¤¤ë¡£
+ * 0¤òÊÖ¤·¤¿¾ì¹ç¤Ï¡¢¸Æ¤Ó½Ð¤·¸µ¤ÇÂбþ¤¹¤ë¤³¤È¡£
+ * 
+ * @param $control_id ´ÉÍýID
+ * @param $dsn DataSource
+ * @return $control_flg ¥Õ¥é¥°
+ */
+function sfGetSiteControlFlg($control_id, $dsn = "") {
+
+    // ¥Ç¡¼¥¿¥½¡¼¥¹
+    if($dsn == "") {
+        if(defined('DEFAULT_DSN')) {
+            $dsn = DEFAULT_DSN;
+        } else {
+            return;
+        }
+    }
+
+    // ¥¯¥¨¥êÀ¸À®
+    $target_column = "control_flg";
+    $table_name = "dtb_site_control";
+    $where = "control_id = ?";
+    $arrval = array($control_id);
+    $control_flg = 0;
+
+    // ¥¯¥¨¥êȯ¹Ô
+    $objQuery = new SC_Query($dsn, true, true);
+    $arrSiteControl = $objQuery->select($target_column, $table_name, $where, $arrval);
+
+    // ¥Ç¡¼¥¿¤¬Â¸ºß¤¹¤ì¤Ð¥Õ¥é¥°¤ò¼èÆÀ¤¹¤ë
+    if (count($arrSiteControl) > 0) {
+        $control_flg = $arrSiteControl[0]["control_flg"];
+    }
+    
+    return $control_flg;
 }
 
@@ -265 +356 @@
 
 /* ¥µ¥¤¥È¥¨¥é¡¼¥Ú¡¼¥¸¤Îɽ¼¨ */
-function sfDispSiteError($type, $objSiteSess = "", $return_top = false, $err_msg = "") {
+function sfDispSiteError($type, $objSiteSess = "", $return_top = false, $err_msg = "", $is_mobile = false) {
     global $objCampaignSess;
     
@@ -281 +372 @@
     
     $objPage = new LC_ErrorPage();
-    $objView = new SC_SiteView();
+    
+    if($is_mobile === true) {
+        $objView = new SC_MobileView();     
+    } else {
+        $objView = new SC_SiteView();
+    }
     
     switch ($type) {
@@ -382 +478 @@
 
 /* Á°¤Î¥Ú¡¼¥¸¤ÇÀµ¤·¤¯ÅÐÏ¿¤¬¹Ô¤ï¤ì¤¿¤«È½Äê */
-function sfIsPrePage($objSiteSess) {
+function sfIsPrePage($objSiteSess, $is_mobile = false) {
     $ret = $objSiteSess->isPrePage();
     if($ret != true) {
         // ¥¨¥é¡¼¥Ú¡¼¥¸¤Îɽ¼¨
-        sfDispSiteError(PAGE_ERROR, $objSiteSess);
+        sfDispSiteError(PAGE_ERROR, $objSiteSess, false, "", $is_mobile);           
     }
 }
@@ -475 +571 @@
 function sfReload($get = "") {
     if ($_SERVER["SERVER_PORT"] == "443" ){
-        $protocol = "https";
+        $url = ereg_replace(URL_DIR . "$", "", SSL_URL);
     } else {
-        $protocol = "http";
-    }
-        
+        $url = ereg_replace(URL_DIR . "$", "", SITE_URL);
+    }
+    
     if($get != "") {
-        header("Location: ".$protocol."://" .$_SERVER["SERVER_NAME"] . $_SERVER['PHP_SELF'] . "?" . $get);
+        header("Location: ". $url . $_SERVER['PHP_SELF'] . "?" . $get);
     } else {
-        header("Location: ".$protocol."://" .$_SERVER["SERVER_NAME"] . $_SERVER['PHP_SELF']);
+        header("Location: ". $url . $_SERVER['PHP_SELF']);
     }
     exit;
@@ -812 +908 @@
 function sfGetCommaList($array, $space=true) {
     if (count($array) > 0) {
+        $line = "";
         foreach($array as $val) {
             if ($space) {
@@ -1740 +1837 @@
         $sqlval['order_tel02'] = $objCustomer->getValue('tel02');
         $sqlval['order_tel03'] = $objCustomer->getValue('tel03');
-        $sqlval['order_email'] = $objCustomer->getValue('email');
+        if (defined('MOBILE_SITE')) {
+            $sqlval['order_email'] = $objCustomer->getValue('email_mobile');
+        } else {
+            $sqlval['order_email'] = $objCustomer->getValue('email');
+        }
         $sqlval['order_job'] = $objCustomer->getValue('job');
         $sqlval['order_birth'] = $objCustomer->getValue('birth');
@@ -1768 +1869 @@
 /* ²ñ°÷¤Î¥á¥ë¥Þ¥¬ÅÐÏ¿¤¬¤¢¤ë¤«¤É¤¦¤«¤Î¥Á¥§¥Ã¥¯(²¾²ñ°÷¤ò´Þ¤Þ¤Ê¤¤) */
 function sfCheckCustomerMailMaga($email) {
-    $col = "T1.email, T1.mail_flag, T2.customer_id";
-    $from = "dtb_customer_mail AS T1 LEFT JOIN dtb_customer AS T2 ON T1.email = T2.email";
-    $where = "T1.email = ? AND T2.status = 2";
+    $col = "email, mailmaga_flg, customer_id";
+    $from = "dtb_customer";
+    $where = "email = ? AND status = 2";
     $objQuery = new SC_Query();
     $arrRet = $objQuery->select($col, $from, $where, array($email));
@@ -2046 +2147 @@
         if(strlen($str) > ($len + 2)) {
             $ret =substr($str, 0, $len);
+            $cut = substr($str, $len);
         } else {
             $ret = $str;
@@ -2053 +2155 @@
         if(mb_strlen($str) > ($len + 1)) {
             $ret = mb_substr($str, 0, $len);
+            $cut = mb_substr($str, $len);
         } else {
             $ret = $str;
@@ -2058 +2161 @@
         }
     }
+
+    // ³¨Ê¸»ú¥¿¥°¤ÎÅÓÃæ¤ÇʬÃǤµ¤ì¤Ê¤¤¤è¤¦¤Ë¤¹¤ë¡£
+    if (isset($cut)) {
+        // ʬ³ä°ÌÃÖ¤è¤êÁ°¤ÎºÇ¸å¤Î [ °Ê¹ß¤ò¼èÆÀ¤¹¤ë¡£
+        $head = strrchr($ret, '[');
+
+        // ʬ³ä°ÌÃÖ¤è¤ê¸å¤ÎºÇ½é¤Î ] °ÊÁ°¤ò¼èÆÀ¤¹¤ë¡£
+        $tail_pos = strpos($cut, ']');
+        if ($tail_pos !== false) {
+            $tail = substr($cut, 0, $tail_pos + 1);
+        }
+
+        // ʬ³ä°ÌÃÖ¤è¤êÁ°¤Ë [¡¢¸å¤Ë ] ¤¬¸«¤Ä¤«¤Ã¤¿¾ì¹ç¤Ï¡¢[ ¤«¤é ] ¤Þ¤Ç¤ò
+        // Àܳ¤·¤Æ³¨Ê¸»ú¥¿¥°1¸Äʬ¤Ë¤Ê¤ë¤«¤É¤¦¤«¤ò¥Á¥§¥Ã¥¯¤¹¤ë¡£
+        if ($head !== false && $tail_pos !== false) {
+            $subject = $head . $tail;
+            if (preg_match('/^\[emoji:e?\d+\]$/', $subject)) {
+                // ³¨Ê¸»ú¥¿¥°¤¬¸«¤Ä¤«¤Ã¤¿¤Î¤Çºï½ü¤¹¤ë¡£
+                $ret = substr($ret, 0, -strlen($head));
+            }
+        }
+    }
+
     if($commadisp){
         $ret = $ret . "...";
@@ -2200 +2326 @@
     index.php?tpl=test.tpl
 */
-function sfCustomDisplay($objPage) {
+function sfCustomDisplay($objPage, $is_mobile = false) {
     $basename = basename($_SERVER["REQUEST_URI"]);
 
@@ -2219 +2345 @@
     $template_path = TEMPLATE_FTP_DIR . $tpl_name;
 
-    if(file_exists($template_path)) {
+    if($is_mobile === true) {
+        $objView = new SC_MobileView();         
+        $objView->assignobj($objPage);
+        $objView->display(SITE_FRAME);      
+    } else if(file_exists($template_path)) {
         $objView = new SC_UserView(TEMPLATE_FTP_DIR, COMPILE_FTP_DIR);
         $objView->assignobj($objPage);
@@ -2253 +2383 @@
     $arrRegist["update_date"] = "NOW()";
     
-    $sqlval["create_date"] = "NOW()";
-    $sqlval["update_date"] = "NOW()";
-    $sqlval['email'] = $array['email'];
-    $sqlval['mail_flag'] = $array['mail_flag'];
     //-- ÊÔ½¸ÅÐÏ¿¼Â¹Ô
+    if (defined('MOBILE_SITE')) {
+        $arrRegist['email_mobile'] = $arrRegist['email'];
+        unset($arrRegist['email']);
+    }
     $objQuery->begin();
     $objQuery->update("dtb_customer", $arrRegist, "customer_id = ? ", array($array['customer_id']));
-    $objQuery->delete("dtb_customer_mail", "email = ?", array($array['email']));
-    $objQuery->insert("dtb_customer_mail", $sqlval);
     $objQuery->commit();
 }
@@ -2517 +2645 @@
 
 // »ØÄꤷ¤¿¥«¥Æ¥´¥ê¡¼ID¤ÎÂ祫¥Æ¥´¥ê¡¼¤ò¼èÆÀ¤¹¤ë
-function GetFirstCat($category_id){
+function sfGetFirstCat($category_id){
     // ¾¦Éʤ¬Â°¤¹¤ë¥«¥Æ¥´¥êID¤ò½Ä¤Ë¼èÆÀ
     $objQuery = new SC_Query();