Changeset 4608 for temp/trunk/data/lib/slib.php

Timestamp:

2006/09/11 19:37:56 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/data/lib/slib.php (modified) (15 diffs)

temp/trunk/data/lib/slib.php

@@ -430 +430 @@
 
     //--¡¡»ØÄꤷ¤¿½ç°Ì¤Î¾¦Éʤ«¤é°ÜÆ°¤µ¤»¤ë¾¦ÉʤޤǤÎrank¤ò£±¤Ä¤º¤é¤¹
-    $sql = "UPDATE $tableName SET rank = $term, update_date = NOW() WHERE rank BETWEEN ? AND ? AND delete = 0";
+    $sql = "UPDATE $tableName SET rank = $term, update_date = NOW() WHERE rank BETWEEN ? AND ? AND del_flg = 0";
     if($where != "") {
         $sql.= " AND $where";
@@ -439 +439 @@
 
     //-- »ØÄꤷ¤¿½ç°Ì¤Ørank¤ò½ñ¤­´¹¤¨¤ë¡£
-    $sql  = "UPDATE $tableName SET rank = ?, update_date = NOW() WHERE $keyIdColumn = ? AND delete = 0 ";
+    $sql  = "UPDATE $tableName SET rank = ?, update_date = NOW() WHERE $keyIdColumn = ? AND del_flg = 0 ";
     if($where != "") {
         $sql.= " AND $where";
@@ -462 +462 @@
     if(!$delete) {
         // ¥é¥ó¥¯¤òºÇ²¼°Ì¤Ë¤¹¤ë¡¢DEL¥Õ¥é¥°ON
-        $sqlup = "UPDATE $table SET rank = 0, delete = 1, update_date = Now() ";
+        $sqlup = "UPDATE $table SET rank = 0, del_flg = 1, update_date = Now() ";
         $sqlup.= "WHERE $colname = ?";
         // UPDATE¤Î¼Â¹Ô
@@ -485 +485 @@
     $arrCol = split("[, ]", $col);
         
-    $where = "delete = 0";
+    $where = "del_flg = 0";
     
     if($addwhere != "") {
@@ -774 +774 @@
 function sfGetCategoryList($addwhere = "", $products_check = false, $head = CATEGORY_HEAD) {
     $objQuery = new SC_Query();
-    $where = "delete = 0";
+    $where = "del_flg = 0";
     
     if($addwhere != "") {
@@ -815 +815 @@
     $objQuery = new SC_Query();
     $col = "category_id, category_name, level";
-    $where = "delete = 0";
+    $where = "del_flg = 0";
     $objQuery->setoption("ORDER BY rank DESC");
     $arrRet = $objQuery->select($col, "dtb_category", $where);
@@ -871 +871 @@
     $objQuery = new SC_Query();
     $col = "$keyname, $valname";
-    $objQuery->setwhere("delete = 0");
+    $objQuery->setwhere("del_flg = 0");
     $objQuery->setorder("rank DESC");
     $arrList = $objQuery->select($col, $table);
@@ -1000 +1000 @@
         $where = "to_char(now(),'YYYY/MM/DD/HH24') >= to_char(start_date,'YYYY/MM/DD/HH24') AND ";
         $where .= "to_char(now(),'YYYY/MM/DD/HH24') < to_char(end_date,'YYYY/MM/DD/HH24') AND ";
-        $where .= "delete = 0 AND campaign_id IN (SELECT campaign_id FROM dtb_campaign_detail where product_id = ? )";
+        $where .= "del_flg = 0 AND campaign_id IN (SELECT campaign_id FROM dtb_campaign_detail where product_id = ? )";
         //ÅÐÏ¿(¹¹¿·)ÆüÉÕ½ç
         $objQuery->setorder('update_date DESC');
@@ -1043 +1043 @@
     $sql = "select count(dtb_class.class_id), dtb_class.class_id ";
     $sql.= "from dtb_class inner join dtb_classcategory on dtb_class.class_id = dtb_classcategory.class_id ";
-    $sql.= "where dtb_class.delete = 0 AND dtb_classcategory.delete = 0 ";
+    $sql.= "where dtb_class.del_flg = 0 AND dtb_classcategory.del_flg = 0 ";
     $sql.= "group by dtb_class.class_id, dtb_class.name;";
     $objQuery = new SC_Query();
@@ -1288 +1288 @@
     
     if($payment_id != "") {
-        $where = "delete = 0 AND payment_id = ?";
+        $where = "del_flg = 0 AND payment_id = ?";
         $arrRet = $objQuery->select("deliv_id", "dtb_payment", $where, array($payment_id));
         $deliv_id = $arrRet[0]['deliv_id'];
@@ -1310 +1310 @@
     // »Ùʧ¤¤ÊýË¡¤¬»ØÄꤵ¤ì¤Æ¤¤¤ë¾ì¹ç¤Ï¡¢Âбþ¤·¤¿ÇÛÁ÷¶È¼Ô¤ò¼èÆÀ¤¹¤ë
     if($payment_id != "") {
-        $where = "delete = 0 AND payment_id = ?";
+        $where = "del_flg = 0 AND payment_id = ?";
         $arrRet = $objQuery->select("deliv_id", "dtb_payment", $where, array($payment_id));
         $deliv_id = $arrRet[0]['deliv_id'];
     // »Ùʧ¤¤ÊýË¡¤¬»ØÄꤵ¤ì¤Æ¤¤¤Ê¤¤¾ì¹ç¤Ï¡¢ÀèƬ¤ÎÇÛÁ÷¶È¼Ô¤ò¼èÆÀ¤¹¤ë
     } else {
-        $where = "delete = 0";
+        $where = "del_flg = 0";
         $objQuery->setOrder("rank DESC");
         $objQuery->setLimitOffset(1);
@@ -1341 +1341 @@
     $objQuery = new SC_Query();
     // ¹ØÆþ¶â³Û¤¬¾ò·ï³Û°Ê²¼¤Î¹àÌܤò¼èÆÀ
-    $where = "delete = 0";
+    $where = "del_flg = 0";
     $objQuery->setorder("fix, rank DESC");
     $arrRet = $objQuery->select("payment_id, payment_method, rule", "dtb_payment", $where);
@@ -1736 +1736 @@
     $sql = "SELECT name, main_image, main_list_image, price01_min, price01_max, price02_min, price02_max, point_rate,
              A.product_id, A.comment FROM dtb_best_products as A LEFT JOIN vw_products_allclass as B 
-            USING (product_id) WHERE A.category_id = ? AND A.delete = 0 AND status = 1 ORDER BY A.rank";
+            USING (product_id) WHERE A.category_id = ? AND A.del_flg = 0 AND status = 1 ORDER BY A.rank";
     $arrItems = $conn->getAll($sql, array($category_id));
     return $arrItems;
@@ -2116 +2116 @@
     $sql .= " SELECT T1.category_id, count(T2.category_id) FROM dtb_category AS T1 LEFT JOIN dtb_products AS T2 ";
     $sql .= " ON T1.category_id = T2.category_id  ";
-    $sql .= " WHERE T2.delete = 0 AND T2.status = 1 ";
+    $sql .= " WHERE T2.del_flg = 0 AND T2.status = 1 ";
     $sql .= " GROUP BY T1.category_id, T2.category_id ";
     $objQuery->query($sql);
@@ -2273 +2273 @@
     // ÅÐÏ¿¾¦ÉÊ¿ô¤Î¥Á¥§¥Ã¥¯
     if($count_check) {
-        $where = "delete = 0 AND product_count > 0";
-    } else {
-        $where = "delete = 0";
+        $where = "del_flg = 0 AND product_count > 0";
+    } else {
+        $where = "del_flg = 0";
     }
     $objQuery->setoption("ORDER BY rank DESC");