Changeset 10287 for temp/trunk

Timestamp:

2006/12/06 12:07:07 (20 years ago)

Author:

kaki

Message:

 

File:

• temp/trunk/html/admin/products/index.php (modified) (11 diffs)

temp/trunk/html/admin/products/index.php

@@ -121 +121 @@
 
     $where = "del_flg = 0";
-
+    $view_where = "del_flg = 0";
+    
     // ÆþÎÏ¥¨¥é¡¼¤Ê¤·
     if (count($objPage->arrErr) == 0) {
@@ -136 +137 @@
                 case 'search_product_id':   // ¾¦ÉÊID
                     $where .= " AND product_id = ?";
+                    $view_where .= " AND product_id = ?";
                     $arrval[] = $val;
                     break;
@@ -142 +144 @@
                     $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE classcategory_id1 IN " . $where_in;
                     $where .= " OR classcategory_id2 IN" . $where_in . ")";
+                    $view_where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE classcategory_id1 IN " . $where_in;
+                    $view_where .= " OR classcategory_id2 IN" . $where_in . ")";
                     $arrval[] = "%$val%";
                     $arrval[] = "%$val%";
+                    $view_where = $where;
                     break;
                 case 'search_name':         // ¾¦ÉÊ̾
                     $where .= " AND name ILIKE ?";
+                    $view_where .= " AND name ILIKE ?";
                     $arrval[] = "%$val%";
                     break;
@@ -153 +159 @@
                     if($tmp_where != "") {
                         $where.= " AND $tmp_where";
+                        $view_where.= " AND $tmp_where";
                         $arrval = array_merge((array)$arrval, (array)$tmp_arrval);
                     }
@@ -158 +165 @@
                 case 'search_product_code': // ¾¦ÉÊ¥³¡¼¥É
                     $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? GROUP BY product_id)";
+                    $view_where .= " AND EXISTS (SELECT product_id FROM dtb_products_class as cls WHERE cls.product_code ILIKE ? AND prd.product_id = cls.product_id GROUP BY cls.product_id )";
                     $arrval[] = "%$val%";
                     break;
@@ -163 +171 @@
                     $date = sfGetTimestamp($_POST['search_startyear'], $_POST['search_startmonth'], $_POST['search_startday']);
                     $where.= " AND update_date >= '" . $_POST['search_startyear'] . "/" . $_POST['search_startmonth']. "/" .$_POST['search_startday'] . "'";
+                    $view_where.= " AND update_date >= '" . $_POST['search_startyear'] . "/" . $_POST['search_startmonth']. "/" .$_POST['search_startday'] . "'";
                     break;
                 case 'search_endyear':      // ÅÐÏ¿¹¹¿·Æü¡ÊTO¡Ë
@@ -168 +177 @@
                     $date = date('Y/m/d', strtotime($date) + 86400);
                     $where.= " AND update_date < date('" . $date . "')";
+                    $view_where.= " AND update_date < date('" . $date . "')";
                     break;
                 case 'search_product_flag': //¼ïÊÌ
@@ -174 +184 @@
                     if($search_product_flag != "") {
                         $where.= " AND product_flag LIKE ?";
+                        $view_where.= " AND product_flag LIKE ?";
                         $arrval[] = $search_product_flag;                   
                     }
@@ -192 +203 @@
                         $tmp_where.=")";
                         $where.= " $tmp_where";
+                        $view_where.= " $tmp_where";
                     }
                     break;
@@ -234 +246 @@
 
             // ¹Ô¿ô¤Î¼èÆÀ
-            //$linemax = $objQuery->count("dtb_products", $where, $arrval);
+            $linemax = $objQuery->count("dtb_products as prd", $view_where, $arrval);
             $objPage->tpl_linemax = $linemax;               // ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ
 
@@ -273 +285 @@
                 $where_tmp .= sfQuoteSmart($arrval[$i - 1]) . $arrWhere[$i];
             }
+            $where_tmp .= $view_where;
             $arrViewWhere["&&noncls_where&&"] = $where_tmp . " " . $objQuery->order . " " .  $objQuery->setlimitoffset($page_max, $startno, true);
     */