[packages/lms.git] / lms-promotionlist.php.patch

--- modules/promotionlist.php	2011/03/02 10:31:05	1.1
+++ modules/promotionlist.php	2011/03/21 07:57:57	1.2
@@ -21,14 +21,14 @@
  *  Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307,
  *  USA.
  *
- *  $Id$
+ *  $Id$
  */
 
 $layout['pagetitle'] = trans('Promotions List');
 
 $promolist = $DB->GetAll('SELECT p.id, p.name, p.description, disabled,
 			(SELECT COUNT(*) FROM promotionschemas
-				WHERE p.id = promotionid) AS schemas,
+				WHERE p.id = promotionid) AS scs,
 			(SELECT COUNT(DISTINCT a.tariffid)
 			    FROM promotionassignments a
 				JOIN promotionschemas s ON (s.id = a.promotionschemaid)
Commit	Line	Data
91beb3ff SP	1	--- modules/promotionlist.php 2011/03/02 10:31:05 1.1
	2	+++ modules/promotionlist.php 2011/03/21 07:57:57 1.2
	3	@@ -21,14 +21,14 @@
	4	* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307,
	5	* USA.
	6	*
	7	- * $Id$
	8	+ * $Id$
	9	*/
	10
	11	$layout['pagetitle'] = trans('Promotions List');
	12
	13	$promolist = $DB->GetAll('SELECT p.id, p.name, p.description, disabled,
	14	(SELECT COUNT(*) FROM promotionschemas
	15	- WHERE p.id = promotionid) AS schemas,
	16	+ WHERE p.id = promotionid) AS scs,
	17	(SELECT COUNT(DISTINCT a.tariffid)
	18	FROM promotionassignments a
	19	JOIN promotionschemas s ON (s.id = a.promotionschemaid)