| [339] | 1 | <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
|
|---|
| [324] | 2 |
|
|---|
| 3 | class Home extends MX_Controller
|
|---|
| 4 | {
|
|---|
| 5 | public function __construct()
|
|---|
| 6 | {
|
|---|
| 7 | parent::__construct();
|
|---|
| 8 | $this->load->helper('cookie');
|
|---|
| 9 | }
|
|---|
| 10 |
|
|---|
| 11 | public function index ()
|
|---|
| [590] | 12 | {
|
|---|
| [324] | 13 | $admin_info = $this->session->userdata('adminInfo');
|
|---|
| 14 | if ($admin_info)
|
|---|
| 15 | {
|
|---|
| [586] | 16 | $data['statistics'] = $this->getStatistics();
|
|---|
| 17 | $data['content']="";
|
|---|
| 18 | $this->load->view('home/index', $data);
|
|---|
| [324] | 19 | }else
|
|---|
| 20 | {
|
|---|
| 21 | $this->load->view ( 'login');
|
|---|
| 22 | }
|
|---|
| 23 | }
|
|---|
| [586] | 24 | public function getStatistics() {
|
|---|
| 25 | $data = array();
|
|---|
| 26 |
|
|---|
| 27 | $last_month['start'] = strtotime(date("Y-m-d", strtotime("first day of previous month")) . " 00:00:00");
|
|---|
| 28 | $last_month['end'] = strtotime(date("Y-m-d", strtotime("last day of previous month")) . " 23:59:59");
|
|---|
| 29 |
|
|---|
| 30 | $last_week['start'] = strtotime(date("Y-m-d", strtotime("first day of previous week")) . " 00:00:00");
|
|---|
| 31 | $last_week['end'] = strtotime(date("Y-m-d", strtotime("last day of previous week")) . " 23:59:59");
|
|---|
| 32 |
|
|---|
| 33 | $last_week['end'] = strtotime('last sunday') + (24 * 60 * 60 - 1);
|
|---|
| 34 | $last_week['start'] = ($last_week['end'] - 7 * 24 * 60 * 60 + 1);
|
|---|
| 35 |
|
|---|
| 36 | $last_year['start'] = strtotime((date("Y") - 1) . "-01-01 00:00:00");
|
|---|
| 37 | $last_year['end'] = strtotime((date("Y") - 1) . "-12-31 23:59:59");
|
|---|
| 38 |
|
|---|
| 39 |
|
|---|
| 40 |
|
|---|
| 41 | $last_quarter = $this->getLastquarter();
|
|---|
| 42 | $last_quarter['start'] = $last_quarter['start'];
|
|---|
| 43 | $last_quarter['end'] = $last_quarter['end'];
|
|---|
| 44 |
|
|---|
| 45 |
|
|---|
| 46 | $this->load->model('paidlog_model');
|
|---|
| 47 | $paidlogs = $this->paidlog_model->getAllPaidlogs($last_year['start']);
|
|---|
| 48 |
|
|---|
| 49 | $revenue['last_week'] = 0;
|
|---|
| 50 | $revenue['last_month'] = 0;
|
|---|
| 51 | $revenue['last_quarter'] = 0;
|
|---|
| 52 | $revenue['last_year'] = 0;
|
|---|
| 53 |
|
|---|
| 54 | $lastmonth = strtotime("first day of previous month");
|
|---|
| 55 | $thismonth = strtotime("first day of this month");
|
|---|
| 56 | $charts['last_month'] = array(0 => 0, 1 => 0, 2 => 0, 3 => 0, 4 => 0);
|
|---|
| 57 | $charts['this_month'] = array(0 => 0, 1 => 0, 2 => 0, 3 => 0, 4 => 0);
|
|---|
| 58 |
|
|---|
| 59 | $top['last_month']['user']=0;
|
|---|
| 60 | $top['last_month']['sms']=0;
|
|---|
| 61 | $top['last_month']['card']=0;
|
|---|
| 62 | $top['last_month']['collaborator']=0;
|
|---|
| 63 | $top['this_month']['user']=0;
|
|---|
| 64 | $top['this_month']['sms']=0;
|
|---|
| 65 | $top['this_month']['card']=0;
|
|---|
| 66 | $top['this_month']['collaborator']=0;
|
|---|
| 67 | foreach ($paidlogs as $paidlog) {
|
|---|
| 68 |
|
|---|
| 69 |
|
|---|
| 70 | if (($paidlog['time'] < $last_week['end']) && ($paidlog['time'] > $last_week['start'])) {
|
|---|
| 71 | $revenue['last_week']+=$paidlog['amount'];
|
|---|
| 72 | }
|
|---|
| 73 | if (($paidlog['time'] < $last_month['end']) && ($paidlog['time'] > $last_month['start'])) {
|
|---|
| 74 | $revenue['last_month']+=$paidlog['amount'];
|
|---|
| 75 | }
|
|---|
| 76 | if (($paidlog['time'] < $last_quarter['end']) && ($paidlog['time'] > $last_quarter['start'])) {
|
|---|
| 77 | $revenue['last_quarter']+=$paidlog['amount'];
|
|---|
| 78 | }
|
|---|
| 79 | if (($paidlog['time'] < $last_year['end']) && ($paidlog['time'] > $last_year['start'])) {
|
|---|
| 80 | $revenue['last_year']+=$paidlog['amount'];
|
|---|
| 81 | }
|
|---|
| 82 |
|
|---|
| 83 |
|
|---|
| 84 | if (($paidlog['time'] < $lastmonth + (7 * 24 * 60 * 60)) && ($paidlog['time'] > $lastmonth)) {
|
|---|
| 85 | $charts['last_month'][0]+=$paidlog['amount'];
|
|---|
| 86 | }
|
|---|
| 87 | if (($paidlog['time'] < $lastmonth + (14 * 24 * 60 * 60)) && ($paidlog['time'] > $lastmonth + (7 * 24 * 60 * 60))) {
|
|---|
| 88 | $charts['last_month'][1]+=$paidlog['amount'];
|
|---|
| 89 | }
|
|---|
| 90 | if (($paidlog['time'] < $lastmonth + (21 * 24 * 60 * 60)) && ($paidlog['time'] > $lastmonth + (14 * 24 * 60 * 60))) {
|
|---|
| 91 | $charts['last_month'][2]+=$paidlog['amount'];
|
|---|
| 92 | }
|
|---|
| 93 | if (($paidlog['time'] < $lastmonth + (28 * 24 * 60 * 60)) && ($paidlog['time'] > $lastmonth + (21 * 24 * 60 * 60))) {
|
|---|
| 94 | $charts['last_month'][3]+=$paidlog['amount'];
|
|---|
| 95 | }
|
|---|
| 96 | if (($paidlog['time'] < $thismonth) && ($paidlog['time'] > $lastmonth + (28 * 24 * 60 * 60))) {
|
|---|
| 97 | $charts['last_month'][4]+=$paidlog['amount'];
|
|---|
| 98 | }
|
|---|
| 99 |
|
|---|
| 100 | if (($paidlog['time'] < $thismonth) && ($paidlog['time'] > $lastmonth)) {
|
|---|
| 101 | $top['last_month']['user']++;
|
|---|
| 102 | if ($paidlog['paid_type']==1)
|
|---|
| 103 | {
|
|---|
| 104 | $top['last_month']['sms']+=$paidlog['amount'];
|
|---|
| 105 | }
|
|---|
| 106 | if ($paidlog['paid_type']==2)
|
|---|
| 107 | {
|
|---|
| 108 | $top['last_month']['card']+=$paidlog['amount'];
|
|---|
| 109 | }
|
|---|
| 110 | if ($paidlog['collaborator']!="")
|
|---|
| 111 | {
|
|---|
| 112 | $top['last_month']['collaborator']+=$paidlog['amount'];
|
|---|
| 113 | }
|
|---|
| 114 | }
|
|---|
| 115 |
|
|---|
| 116 |
|
|---|
| 117 |
|
|---|
| 118 | if (($paidlog['time'] < $thismonth + (7 * 24 * 60 * 60)) && ($paidlog['time'] > $thismonth)) {
|
|---|
| 119 | $charts['this_month'][0]+=$paidlog['amount'];
|
|---|
| 120 | }
|
|---|
| 121 | if (($paidlog['time'] < $thismonth + (14 * 24 * 60 * 60)) && ($paidlog['time'] > $thismonth + (7 * 24 * 60 * 60))) {
|
|---|
| 122 | $charts['this_month'][1]+=$paidlog['amount'];
|
|---|
| 123 | }
|
|---|
| 124 | if (($paidlog['time'] < $thismonth + (21 * 24 * 60 * 60)) && ($paidlog['time'] > $thismonth + (14 * 24 * 60 * 60))) {
|
|---|
| 125 | $charts['this_month'][2]+=$paidlog['amount'];
|
|---|
| 126 | }
|
|---|
| 127 | if (($paidlog['time'] < $thismonth + (28 * 24 * 60 * 60)) && ($paidlog['time'] > $thismonth + (21 * 24 * 60 * 60))) {
|
|---|
| 128 | $charts['this_month'][3]+=$paidlog['amount'];
|
|---|
| 129 | }
|
|---|
| 130 | if (($paidlog['time'] < $thismonth + (31 * 24 * 60 * 60)) && ($paidlog['time'] > $thismonth + (28 * 24 * 60 * 60))) {
|
|---|
| 131 | $charts['this_month'][4]+=$paidlog['amount'];
|
|---|
| 132 | }
|
|---|
| 133 | if (($paidlog['time'] < $thismonth + (31 * 24 * 60 * 60)) && ($paidlog['time'] > $thismonth )) {
|
|---|
| 134 | $top['this_month']['user']++;
|
|---|
| 135 | if ($paidlog['paid_type']==1)
|
|---|
| 136 | {
|
|---|
| 137 | $top['this_month']['sms']+=$paidlog['amount'];
|
|---|
| 138 | }
|
|---|
| 139 | if ($paidlog['paid_type']==2)
|
|---|
| 140 | {
|
|---|
| 141 | $top['this_month']['card']+=$paidlog['amount'];
|
|---|
| 142 | }
|
|---|
| 143 | if ($paidlog['collaborator']!="")
|
|---|
| 144 | {
|
|---|
| 145 | $top['this_month']['collaborator']+=$paidlog['amount'];
|
|---|
| 146 | }
|
|---|
| 147 | }
|
|---|
| 148 | }
|
|---|
| 149 | $percent=array();
|
|---|
| 150 | foreach ($top['this_month'] as $index=>$value)
|
|---|
| 151 | {
|
|---|
| 152 | $percent[$index]['class']="down";
|
|---|
| 153 | $percent[$index]['display']="giảm";
|
|---|
| [587] | 154 | $percent[$index]['value']="n/a";
|
|---|
| 155 | if (($top['this_month'][$index]>0)&&($top['last_month'][$index]>0))
|
|---|
| 156 | {
|
|---|
| [586] | 157 | $percent[$index]['value']=round((($top['this_month'][$index] / $top['last_month'][$index])*100),1);
|
|---|
| 158 | if ($top['this_month'][$index] > $top['last_month'][$index])
|
|---|
| 159 | {
|
|---|
| 160 | $percent[$index]['class']="up";
|
|---|
| 161 | $percent[$index]['display']="tÄng";
|
|---|
| 162 | }
|
|---|
| [587] | 163 | }
|
|---|
| [586] | 164 | }
|
|---|
| 165 | $data['percent']=$percent;
|
|---|
| 166 | $data['top']=$top;
|
|---|
| 167 | $max = 0;
|
|---|
| 168 | foreach ($charts['last_month'] as $index => $total) {
|
|---|
| 169 | if ($total > $max) {
|
|---|
| 170 | $max = $total;
|
|---|
| 171 | }
|
|---|
| 172 | $chart_last_month[] = array($index, $total);
|
|---|
| 173 | }
|
|---|
| 174 | foreach ($charts['this_month'] as $index => $total) {
|
|---|
| 175 | if ($total > $max) {
|
|---|
| 176 | $max = $total;
|
|---|
| 177 | }
|
|---|
| 178 | $chart_this_month[] = array($index, $total);
|
|---|
| 179 | }
|
|---|
| 180 |
|
|---|
| 181 | $data['revenue'] = $revenue;
|
|---|
| 182 | $data['max'] = $max;
|
|---|
| 183 | $chard[] = array("color" => "#e67e22", "label" => "Tháng hiá»n tại", "data" => $chart_this_month);
|
|---|
| 184 | $chard[] = array("color" => "#1abc9c", "label" => "Tháng trÆ°á»c", "data" => $chart_last_month);
|
|---|
| 185 |
|
|---|
| 186 | $data['chard'] = $chard;
|
|---|
| 187 |
|
|---|
| 188 | return $this->load->view('home/statistics', $data, true);
|
|---|
| 189 | }
|
|---|
| 190 | public function getLastquarter() {
|
|---|
| 191 | $current_month = date('m');
|
|---|
| 192 | $current_year = date('Y');
|
|---|
| 193 |
|
|---|
| 194 | if ($current_month >= 1 && $current_month <= 3) {
|
|---|
| 195 | $start_date = strtotime('1-October-' . ($current_year - 1)); // timestamp or 1-October Last Year 12:00:00 AM
|
|---|
| 196 | $end_date = strtotime('1-Janauary-' . $current_year); // // timestamp or 1-January 12:00:00 AM means end of 31 December Last year
|
|---|
| 197 | } else if ($current_month >= 4 && $current_month <= 6) {
|
|---|
| 198 | $start_date = strtotime('1-January-' . $current_year); // timestamp or 1-Janauray 12:00:00 AM
|
|---|
| 199 | $end_date = strtotime('1-April-' . $current_year); // timestamp or 1-April 12:00:00 AM means end of 31 March
|
|---|
| 200 | } else if ($current_month >= 7 && $current_month <= 9) {
|
|---|
| 201 | $start_date = strtotime('1-April-' . $current_year); // timestamp or 1-April 12:00:00 AM
|
|---|
| 202 | $end_date = strtotime('1-July-' . $current_year); // timestamp or 1-July 12:00:00 AM means end of 30 June
|
|---|
| 203 | } else if ($current_month >= 10 && $current_month <= 12) {
|
|---|
| 204 | $start_date = strtotime('1-July-' . $current_year); // timestamp or 1-July 12:00:00 AM
|
|---|
| 205 | $end_date = strtotime('1-October-' . $current_year); // timestamp or 1-October 12:00:00 AM means end of 30 September
|
|---|
| 206 | }
|
|---|
| 207 | return array("start" => $start_date, "end" => $end_date);
|
|---|
| 208 | }
|
|---|
| 209 |
|
|---|
| [324] | 210 |
|
|---|
| 211 | public function login()
|
|---|
| 212 | {
|
|---|
| [360] | 213 |
|
|---|
| [423] | 214 | $login_name = $this->input->post('login_name');
|
|---|
| 215 | $passwd = $this->input->post('passwd');
|
|---|
| [324] | 216 |
|
|---|
| 217 | $this->load->model(array('admin_model'));
|
|---|
| [423] | 218 | $data = $this->admin_model->check_login($login_name, $passwd);
|
|---|
| [324] | 219 | if ($data == null)
|
|---|
| 220 | {
|
|---|
| 221 | $this->session->set_flashdata('login_error', TRUE);
|
|---|
| 222 | redirect("/admin/home");
|
|---|
| 223 | }
|
|---|
| 224 | else
|
|---|
| 225 | {
|
|---|
| [590] | 226 | $admindata = array('login_name' => $login_name, 'admin_id'=>$data->admin_id, 'role_id'=>$data->role_id, 'logined_in' => TRUE);
|
|---|
| [324] | 227 | $this->session->set_userdata('adminInfo', $admindata);
|
|---|
| 228 | redirect("/admin/home");
|
|---|
| 229 | }
|
|---|
| 230 | }
|
|---|
| 231 |
|
|---|
| 232 | public function logout()
|
|---|
| 233 | {
|
|---|
| 234 | $this->session->sess_destroy();
|
|---|
| 235 | redirect("/admin/home");
|
|---|
| 236 | }
|
|---|
| 237 | } |
|---|
![(please configure the [header_logo] section in trac.ini)](/space/chrome/site/your_project_logo.png){kind=logo}
