@@ -74,7 +74,7 @@ discard block |
||
74 | 74 | AND sslc.cat_id = cat.id |
75 | 75 | AND sslc.active NOT IN ('0') |
76 | 76 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "'" . |
77 | - $range_string . " |
|
77 | + $range_string . " |
|
78 | 78 | GROUP BY cat.name |
79 | 79 | ORDER BY cat.name")->fetchAll(); |
80 | 80 | |
@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | AND sslc.cat_id = cat.id |
90 | 90 | AND sslc.active NOT IN ('0') |
91 | 91 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "'" . |
92 | - $range_string)->fetchAll(); |
|
92 | + $range_string)->fetchAll(); |
|
93 | 93 | |
94 | 94 | foreach ($result_grand_total as $row_grand_total) { |
95 | 95 |
@@ -74,7 +74,7 @@ discard block |
||
74 | 74 | AND sslc.type_id = sslt.id |
75 | 75 | AND sslc.active NOT IN ('0') |
76 | 76 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "'" . |
77 | - $range_string . " |
|
77 | + $range_string . " |
|
78 | 78 | GROUP BY sslt.type |
79 | 79 | ORDER BY sslt.type")->fetchAll(); |
80 | 80 | |
@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | AND sslc.type_id = sslt.id |
90 | 90 | AND sslc.active NOT IN ('0') |
91 | 91 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "'" . |
92 | - $range_string)->fetchAll(); |
|
92 | + $range_string)->fetchAll(); |
|
93 | 93 | |
94 | 94 | foreach ($result_grand_total as $row_grand_total) { |
95 | 95 |
@@ -74,7 +74,7 @@ discard block |
||
74 | 74 | AND sslc.ip_id = ip.id |
75 | 75 | AND sslc.active NOT IN ('0') |
76 | 76 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "'" . |
77 | - $range_string . " |
|
77 | + $range_string . " |
|
78 | 78 | GROUP BY ip.name |
79 | 79 | ORDER BY ip.name")->fetchAll(); |
80 | 80 | |
@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | AND sslc.ip_id = ip.id |
90 | 90 | AND sslc.active NOT IN ('0') |
91 | 91 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "'" . |
92 | - $range_string)->fetchAll(); |
|
92 | + $range_string)->fetchAll(); |
|
93 | 93 | |
94 | 94 | foreach ($result_grand_total as $row_grand_total) { |
95 | 95 |
@@ -74,7 +74,7 @@ discard block |
||
74 | 74 | AND sslc.owner_id = o.id |
75 | 75 | AND sslc.active NOT IN ('0') |
76 | 76 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "'" . |
77 | - $range_string . " |
|
77 | + $range_string . " |
|
78 | 78 | GROUP BY `name` |
79 | 79 | ORDER BY `name`")->fetchAll(); |
80 | 80 | |
@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | AND sslc.owner_id = o.id |
90 | 90 | AND sslc.active NOT IN ('0') |
91 | 91 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "'" . |
92 | - $range_string)->fetchAll(); |
|
92 | + $range_string)->fetchAll(); |
|
93 | 93 | |
94 | 94 | foreach ($result_grand_total as $row_grand_total) { |
95 | 95 |
@@ -71,7 +71,7 @@ discard block |
||
71 | 71 | WHERE sslc.fee_id = f.id |
72 | 72 | AND f.currency_id = c.id |
73 | 73 | AND sslc.active NOT IN ('0')" . |
74 | - $range_string . " |
|
74 | + $range_string . " |
|
75 | 75 | GROUP BY year, month |
76 | 76 | ORDER BY year, month")->fetchAll(); |
77 | 77 | |
@@ -85,7 +85,7 @@ discard block |
||
85 | 85 | AND c.id = cc.currency_id |
86 | 86 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "' |
87 | 87 | AND sslc.active NOT IN ('0')" . |
88 | - $range_string)->fetchAll(); |
|
88 | + $range_string)->fetchAll(); |
|
89 | 89 | |
90 | 90 | foreach ($result_grand_total as $row_grand_total) { |
91 | 91 | |
@@ -177,7 +177,7 @@ discard block |
||
177 | 177 | AND sslc.active NOT IN ('0') |
178 | 178 | AND YEAR(sslc.expiry_date) = '" . $row->year . "' |
179 | 179 | AND MONTH(sslc.expiry_date) = '" . $row->month . "'" . |
180 | - $range_string)->fetchAll(); |
|
180 | + $range_string)->fetchAll(); |
|
181 | 181 | |
182 | 182 | foreach ($result_monthly_cost as $row_monthly_cost) { |
183 | 183 | |
@@ -211,7 +211,7 @@ discard block |
||
211 | 211 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "' |
212 | 212 | AND sslc.active NOT IN ('0') |
213 | 213 | AND YEAR(sslc.expiry_date) = '" . $row->year . "'" . |
214 | - $range_string)->fetchAll(); |
|
214 | + $range_string)->fetchAll(); |
|
215 | 215 | |
216 | 216 | foreach ($result_yearly_cost as $row_yearly_cost) { |
217 | 217 | |
@@ -293,7 +293,7 @@ discard block |
||
293 | 293 | AND sslc.active NOT IN ('0') |
294 | 294 | AND YEAR(sslc.expiry_date) = '" . $row->year . "' |
295 | 295 | AND MONTH(sslc.expiry_date) = '" . $row->month . "'" . |
296 | - $range_string)->fetchAll(); |
|
296 | + $range_string)->fetchAll(); |
|
297 | 297 | |
298 | 298 | foreach ($result_monthly_cost as $row_monthly_cost) { |
299 | 299 | |
@@ -328,7 +328,7 @@ discard block |
||
328 | 328 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "' |
329 | 329 | AND sslc.active NOT IN ('0') |
330 | 330 | AND YEAR(sslc.expiry_date) = '" . $row->year . "'" . |
331 | - $range_string)->fetchAll(); |
|
331 | + $range_string)->fetchAll(); |
|
332 | 332 | |
333 | 333 | foreach ($result_yearly_cost as $row_yearly_cost) { |
334 | 334 |
@@ -78,7 +78,7 @@ discard block |
||
78 | 78 | AND sslc.owner_id = o.id |
79 | 79 | AND sslc.active NOT IN ('0') |
80 | 80 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "'" . |
81 | - $range_string . " |
|
81 | + $range_string . " |
|
82 | 82 | GROUP BY sslp.name, o.name, sslpa.username |
83 | 83 | ORDER BY sslp.name, o.name, sslpa.username")->fetchAll(); |
84 | 84 | |
@@ -96,7 +96,7 @@ discard block |
||
96 | 96 | AND sslc.owner_id = o.id |
97 | 97 | AND sslc.active NOT IN ('0') |
98 | 98 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "'" . |
99 | - $range_string)->fetchAll(); |
|
99 | + $range_string)->fetchAll(); |
|
100 | 100 | |
101 | 101 | foreach ($result_grand_total as $row_grand_total) { |
102 | 102 | |
@@ -192,7 +192,7 @@ discard block |
||
192 | 192 | AND sslc.active NOT IN ('0') |
193 | 193 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "' |
194 | 194 | AND sslp.id = '" . $row->id . "'" . |
195 | - $range_string)->fetchAll(); |
|
195 | + $range_string)->fetchAll(); |
|
196 | 196 | |
197 | 197 | foreach ($result_provider_total as $row_provider_total) { |
198 | 198 | |
@@ -294,7 +294,7 @@ discard block |
||
294 | 294 | AND sslc.active NOT IN ('0') |
295 | 295 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "' |
296 | 296 | AND sslp.id = '" . $row->id . "'" . |
297 | - $range_string)->fetchAll(); |
|
297 | + $range_string)->fetchAll(); |
|
298 | 298 | |
299 | 299 | foreach ($result_provider_total as $row_provider_total) { |
300 | 300 |
@@ -74,7 +74,7 @@ discard block |
||
74 | 74 | AND sslc.domain_id = d.id |
75 | 75 | AND sslc.active NOT IN ('0') |
76 | 76 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "'" . |
77 | - $range_string . " |
|
77 | + $range_string . " |
|
78 | 78 | GROUP BY d.domain |
79 | 79 | ORDER BY d.domain")->fetchAll(); |
80 | 80 | |
@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | AND sslc.domain_id = d.id |
90 | 90 | AND sslc.active NOT IN ('0') |
91 | 91 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "'" . |
92 | - $range_string)->fetchAll(); |
|
92 | + $range_string)->fetchAll(); |
|
93 | 93 | |
94 | 94 | foreach ($result_grand_total as $row_grand_total) { |
95 | 95 |
@@ -89,7 +89,7 @@ |
||
89 | 89 | AND d.cat_id = cat.id |
90 | 90 | AND d.active NOT IN ('0', '10') |
91 | 91 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "'" . |
92 | - $range_string)->fetchAll(); |
|
92 | + $range_string)->fetchAll(); |
|
93 | 93 | |
94 | 94 | foreach ($result_grand_total as $row_grand_total) { |
95 | 95 |
@@ -74,7 +74,7 @@ discard block |
||
74 | 74 | AND d.hosting_id = wh.id |
75 | 75 | AND d.active NOT IN ('0', '10') |
76 | 76 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "'" . |
77 | - $range_string . " |
|
77 | + $range_string . " |
|
78 | 78 | GROUP BY wh.name |
79 | 79 | ORDER BY wh.name")->fetchAll(); |
80 | 80 | |
@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | AND d.hosting_id = wh.id |
90 | 90 | AND d.active NOT IN ('0', '10') |
91 | 91 | AND cc.user_id = '" . $_SESSION['s_user_id'] . "'" . |
92 | - $range_string)->fetchAll(); |
|
92 | + $range_string)->fetchAll(); |
|
93 | 93 | |
94 | 94 | foreach ($result_grand_total as $row_grand_total) { |
95 | 95 |