Changeset 21239 for branches/version-2_11-dev/data/class/SC_Product.php
- Timestamp:
- 2011/09/15 22:21:15 (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_11-dev/data/class/SC_Product.php
r21185 r21239 640 640 */ 641 641 function alldtlSQL($where = "") { 642 $where Cause = "";642 $where_clause = ""; 643 643 if (!SC_Utils_Ex::isBlank($where)) { 644 $where Cause = " WHERE " . $where;644 $where_clause = " WHERE " . $where; 645 645 } 646 646 /* … … 727 727 COUNT(*) as class_count 728 728 FROM dtb_products_class 729 $where Cause729 $where_clause 730 730 GROUP BY product_id 731 731 ) AS T4 … … 747 747 */ 748 748 function prdclsSQL($where = "") { 749 $where Cause = "";749 $where_clause = ""; 750 750 if (!SC_Utils_Ex::isBlank($where)) { 751 $where Cause = " WHERE " . $where;751 $where_clause = " WHERE " . $where; 752 752 } 753 753 $sql = <<< __EOS__ … … 787 787 LEFT JOIN dtb_classcategory as Tcc2 788 788 ON Tpcm.classcategory_id = Tcc2.classcategory_id 789 $where Cause789 $where_clause 790 790 ) as prdcls 791 791 __EOS__;
Note: See TracChangeset
for help on using the changeset viewer.