1 <?php
2 // 
3 // Postfix Admin 
4 // by Mischa Peters <mischa at high5 dot net>
5 // Copyright (c) 2002 - 2005 High5!
6 // License Info: http://www.postfixadmin.com/?file=LICENSE.TXT
7 //
8 // File: overview.php
9 //
10 // Template File: overview.tpl
11 //
12 // Template Variables:
13 //
14 // tAlias
15 // tDomain
16 // tMailbox
17 // tDisplay_back
18 // tDisplay_next
19 //
20 // Form POST \ GET Variables:
21 //
22 // domain
23 // fDomain
24 // limit
25 //
26 require ("./variables.inc.php");
27 require ("./config.inc.php");
28 require ("./functions.inc.php");
29 include ("./languages/" . check_language () . ".lang");
30 
31 $SESSID_USERNAME = check_session();
32 $list_domains = list_domains_for_admin ($SESSID_USERNAME);
33 
34 $tAlias = array();
35 $tMailbox = array();
36 
37 if ($_SERVER['REQUEST_METHOD'] == "GET")
38 {
39    $fDisplay = 0;
40    $page_size = $CONF['page_size'];
41    
42    if (isset ($_GET['domain'])) $fDomain = escape_string ($_GET['domain']);
43    if (isset ($_GET['limit'])) $fDisplay = escape_string ($_GET['limit']);
44 
45    if (check_owner ($SESSID_USERNAME, $fDomain))
46    {
47       $limit = get_domain_properties ($fDomain);
48    
49       if ($CONF['alias_control'] == "YES")
50       {
51          $query = "SELECT alias.address,alias.goto,alias.modified FROM alias WHERE alias.domain='$fDomain' ORDER BY alias.address LIMIT $fDisplay, $page_size";
52       }
53       else
54       {
55          $query = "SELECT alias.address,alias.goto,alias.modified FROM alias LEFT JOIN mailbox ON alias.address=mailbox.username WHERE alias.domain='$fDomain' AND mailbox.maildir IS NULL ORDER BY alias.address LIMIT $fDisplay, $page_size";
56       }
57 
58       $result = db_query ("$query");
59       if ($result['rows'] > 0)
60       {
61          while ($row = db_array ($result['result']))
62          {
63             $tAlias[] = $row;
64          }
65       }
66 
67       $result = db_query ("SELECT * FROM mailbox WHERE domain='$fDomain' ORDER BY username LIMIT $fDisplay, $page_size");
68       if ($result['rows'] > 0)
69       {
70          while ($row = db_array ($result['result']))
71          {
72             $tMailbox[] = $row;
73          }
74       }
75       $template = "overview.tpl";
76    }
77    else
78    {
79       $template = "overview-get.tpl";
80    }
81 
82    $tDomain = $fDomain;
83 
84    if (isset ($limit))
85    {
86       if ($fDisplay >= $page_size)
87       {
88          $tDisplay_back_show = 1;
89          $tDisplay_back = $fDisplay - $page_size;
90       }
91       if (($limit['alias_count'] > $page_size) or ($limit['mailbox_count'] > $page_size))
92       {
93          $tDisplay_up_show = 1;
94       }      
95       if ((($fDisplay + $page_size) < $limit['alias_count']) or (($fDisplay + $page_size) < $limit['mailbox_count']))
96       {
97          $tDisplay_next_show = 1;
98          $tDisplay_next = $fDisplay + $page_size;
99       }
100    }
101    
102    include ("./templates/header.tpl");
103    include ("./templates/menu.tpl");
104    include ("./templates/$template");
105    include ("./templates/footer.tpl");
106 }
107 
108 if ($_SERVER['REQUEST_METHOD'] == "POST")
109 {
110    $fDisplay = 0;
111    $page_size = $CONF['page_size'];
112    
113    if (isset ($_POST['limit'])) $fDisplay = escape_string ($_POST['limit']);
114    
115    if (check_owner ($SESSID_USERNAME, escape_string ($_POST['fDomain'])))
116    {
117       $fDomain = escape_string ($_POST['fDomain']);   
118 
119       $limit = get_domain_properties ($fDomain);
120    
121       if ($CONF['alias_control'] == "YES")
122       {
123          $query = "SELECT alias.address,alias.goto,alias.modified FROM alias WHERE alias.domain='$fDomain' ORDER BY alias.address LIMIT $fDisplay, $page_size";
124       }
125       else
126       {
127          $query = "SELECT alias.address,alias.goto,alias.modified FROM alias LEFT JOIN mailbox ON alias.address=mailbox.username WHERE alias.domain='$fDomain' AND mailbox.maildir IS NULL ORDER BY alias.address LIMIT $fDisplay, $page_size";
128       }
129 
130       $result = db_query ("$query");
131       if ($result['rows'] > 0)
132       {
133          while ($row = db_array ($result['result']))
134          {
135             $tAlias[] = $row;
136          }
137       }
138 
139       $result = db_query ("SELECT * FROM mailbox WHERE domain='$fDomain' ORDER BY username LIMIT $fDisplay, $page_size");
140       if ($result['rows'] > 0)
141       {
142          while ($row = db_array ($result['result']))
143          {
144             $tMailbox[] = $row;
145          }
146       }
147    }
148 
149    if (isset ($limit))
150    {
151       if ($fDisplay >= $page_size)
152       {
153          $tDisplay_back_show = 1;
154          $tDisplay_back = $fDisplay - $page_size;
155       }
156       if (($limit['alias_count'] > $page_size) or ($limit['mailbox_count'] > $page_size))
157       {
158          $tDisplay_up_show = 1;
159       }
160       if ((($fDisplay + $page_size) < $limit['alias_count']) or (($fDisplay + $page_size) < $limit['mailbox_count']))
161       {
162          $tDisplay_next_show = 1;
163          $tDisplay_next = $fDisplay + $page_size;
164       }
165    }
166 
167    include ("./templates/header.tpl");
168    include ("./templates/menu.tpl");
169    include ("./templates/overview.tpl");
170    include ("./templates/footer.tpl");
171 }
172 ?>