· 10 years ago · Feb 05, 2016, 01:57 PM
1<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
2
3class Welcome extends CI_Controller {
4
5 /**
6 * Index Page for this controller.
7 *
8 * Maps to the following URL
9 * http://example.com/index.php/welcome
10 * - or -
11 * http://example.com/index.php/welcome/index
12 * - or -
13 * Since this controller is set as the default controller in
14 * config/routes.php, it's displayed at http://example.com/
15 *
16 * So any other public methods not prefixed with an underscore will
17 * map to /index.php/welcome/<method_name>
18 * @see http://codeigniter.com/user_guide/general/urls.html
19 */
20
21
22 public function __construct()
23 {
24 parent::__construct();
25 $this->load->helper(array('form','url','file'));
26 $this->load->model('Welcome_model');
27 $this->load->model('Admin_model');
28 $this->load->model('Cms_model');
29 $this->load->library(array('session', 'form_validation', 'pagination', 'pdf'));
30
31 }
32
33 public function index()
34 {
35 $page_title = 'About e ROM';
36 $result_array['abtErom'] = $this->Cms_model->getAboutEromDEtails($page_title);
37 $this->load->view('includes/front_header');
38 $this->load->view('index', $result_array);
39 $this->load->view('includes/front_footer');
40 }
41
42
43 public function admin_login()
44 {
45
46 $this->load->view('welcome/admin_login');
47
48 }
49 public function admin_verify()
50 {
51 $username = $this->security->xss_clean($this->input->post('email'));
52 $password = $this->security->xss_clean($this->input->post('password'));
53 $user_match_count = $this->Welcome_model->user_match_count($username, $password);
54
55 if($user_match_count > 0) {
56 $user_details = $this->Welcome_model->user_details($username, $password);
57 $this->session->set_userdata('user_session', $user_details[0]);
58 redirect('welcome/admin');echo "----".$username; exit;
59 }
60 else{
61 $this -> session ->set_flashdata('message', 'Invalid User Credentials.');
62 redirect('welcome/admin_login');
63 }
64
65 }
66
67 //get physical values
68 public function admin(){
69
70 //print_r($this->session->userdata('user_session'));
71 $this->session_admincheck(); // call the function to check admin user
72 // if(isset($users)){
73 $folio = $this->security->xss_clean($this->input->post('folio_no'));
74 $company = $this->security->xss_clean($this->input->post('company'));
75 $company = strtolower($company);
76 $result_array[] = '';
77 if($folio != ''){
78 $result_array['folio'] = $folio;
79 $result_array['company'] = $company;
80 $companyNmae = $this->Admin_model->getCompanyName($company);
81 $result_array['companyName'] = $companyNmae->company_name;
82 $result_array['caseDetails'] = $this->Admin_model->getCaseRes($folio,$company);
83 $result_array['nominDetails'] = $this->Admin_model->getNominRes($folio,$company);
84 $result_array['divindedDetails'] = $this->Admin_model->getDivindedRes($folio,$company);
85 $result_array['transferDetails'] = $this->Admin_model->getTransferRes($folio,$company);
86 $result_array['certificateDetails'] = $this->Admin_model->getCertificateRes($folio,$company);
87 $certificateFolio = '';
88 $transferFolio = '';
89
90 if($result_array['certificateDetails']){ $certificateFolio = $result_array['certificateDetails'][0]->folio; }
91 if($result_array['transferDetails']){ $transferFolio = $result_array['transferDetails'][0]->fromfolio; }
92
93 $result_array['memberRes'] = '';
94 $result_array['dbmasRes'] = '';
95 $result_array['TransferFromFRes'] = '';
96 $result_array['getCertificateNewRes'] = '';
97 $result_array['certificateNewResCount'] = '';
98 if($transferFolio == $folio){ //transfer FROM folio else dbmas
99
100 if(isset($certificateFolio)) {
101 if($certificateFolio != $folio)
102 {
103 $result_array['memberRes'] = $this->Admin_model->getMemTransferRes($folio,$company);
104 }
105 else{
106 $result_array['memberRes'] = $this->Admin_model->getMemCertificateRes($folio,$company);
107 $result_array['getCertificateNewRes'] = $this->Admin_model->getCertificateResults($folio,$company);
108 $result_array['certificateNewResCount'] = count($result_array['getCertificateNewRes']);
109 }
110 }
111 $result_array['TransferFromFRes'] = $this->Admin_model->getTransferFromFRes($folio,$company);
112 }
113 else{
114 $result_array['dbmasRes'] = $this->Admin_model->getdbMasRes($folio,$company);
115 }
116 }
117
118 $result_array['Count_dash'] = $this->Admin_model->dashboardAdmin();
119 $result_array['ttl_mem'] = $result_array['Count_dash']['ttl_mem']; // Total Members
120 $result_array['ttl_cust'] = $result_array['Count_dash']['ttl_cust']; // Total Customers
121 $result_array['ttl_users'] = $result_array['Count_dash']['ttl_users']; // Total Users
122
123 $result_array['companyList'] = $this->Welcome_model->companyList();
124
125
126
127 $this->load->view('includes/header');
128 $this->load->view('admin_dashboard', $result_array);
129 $this->load->view('includes/footer');
130 //}else{
131 // redirect('welcome/admin_login');
132 // }
133 }
134
135 public function session_admincheck(){
136 $sessionRes = $this->session->userdata('user_session');
137 $users = $sessionRes->username;
138 if(!isset($users)){
139 redirect('welcome/admin_login');
140 }
141 }
142 //get cdsl values
143 public function cdsl(){
144
145 $folio = $this->security->xss_clean($this->input->post('folio_no'));
146 $company = $this->security->xss_clean($this->input->post('company'));
147 $result_array['user_res'] = $this->security->xss_clean($this->input->post('user_res'));
148 $company = strtolower($company);
149 $result_array['folio'] = $folio;
150 $result_array['company'] = $company;
151 $result_array['cdslList'] = $this->Welcome_model->getcdslList($company,$folio);
152 $result_array['DivindedCdsl'] = $this->Admin_model->getDivindedCdsl($folio,$company);
153 $result_array['companyList'] = $this->Welcome_model->companyList();
154 $this->load->view('includes/header');
155 $this->load->view('welcome/cdsl', $result_array);
156 $this->load->view('includes/footer');
157 }
158 //get nsdl values
159 public function nsdl(){
160
161 $folio = $this->security->xss_clean($this->input->post('folio_no'));
162 $dp_id = $this->security->xss_clean($this->input->post('dp_id'));
163 $company = $this->security->xss_clean($this->input->post('company'));
164 $result_array['user_res'] = $this->security->xss_clean($this->input->post('user_res'));
165
166 $company = strtolower($company);
167 $result_array['folio'] = $folio;
168 $result_array['dp_id'] = $dp_id;
169 $result_array['company'] = $company;
170 $result_array['companyList'] = $this->Welcome_model->companyList();
171 $result_array['nsdlList'] = $this->Welcome_model->getnsdlList($company,$folio,$dp_id);
172 $result_array['DivindedNsdl'] = $this->Admin_model->getDivindedNsdl($folio,$dp_id,$company);
173
174 $this->load->view('includes/header');
175 $this->load->view('welcome/nsdl', $result_array);
176 $this->load->view('includes/footer');
177 }
178
179 // create PDF for CDSL
180 public function pdf_cdsl(){
181 $folio = $this->security->xss_clean($this->input->get('folio'));
182 $company = $this->security->xss_clean($this->input->get('company'));
183 $company = strtolower($company);
184 $title_page = $folio;
185 $result_array['folio'] = $folio;
186 $result_array['company'] = $company;
187 $result_array['cdslList'] = $this->Welcome_model->getcdslList($company,$folio);
188 $result_array['companyList'] = $this->Welcome_model->companyList();
189
190 $this->load->view('pdf_cdsl', $result_array);
191 $HTML=$this->load->view('pdf_cdsl',$result_array,true);
192 //echo $HTML;
193 $this->pdf->pdf_create($HTML,$title_page);
194
195 }
196
197 // create PDF for NSDL
198 public function pdf_nsdl(){
199 $folio = $this->security->xss_clean($this->input->get('folio'));
200 $dp_id = $this->security->xss_clean($this->input->get('dp_id'));
201 $company = $this->security->xss_clean($this->input->get('company'));
202 $company = strtolower($company);
203 $title_page = $folio;
204 $result_array['folio'] = $folio;
205 $result_array['dp_id'] = $dp_id;
206 $result_array['company'] = $company;
207 $result_array['nsdlList'] = $this->Welcome_model->getnsdlList($company,$folio,$dp_id);
208
209 $this->load->view('pdf_nsdl', $result_array);
210 $HTML=$this->load->view('pdf_nsdl',$result_array,true);
211 //echo $HTML;
212 $this->pdf->pdf_create($HTML,$title_page);
213
214 }
215
216 public function createpdf(){
217
218 $folio = $this->security->xss_clean($this->input->get('folio'));
219 $company = $this->security->xss_clean($this->input->get('company'));
220 $company = strtolower($company);
221 $title_page = $folio;
222 $result_array[] = '';
223 if($folio != ''){
224
225 $result_array['folio'] = $folio;
226 $result_array['company'] = $company;
227 $companyNmae = $this->Admin_model->getCompanyName($company);
228 $result_array['companyName'] = $companyNmae->company_name;
229 $result_array['caseDetails'] = $this->Admin_model->getCaseRes($folio,$company);
230 $result_array['nominDetails'] = $this->Admin_model->getNominRes($folio,$company);
231 $result_array['divindedDetails'] = $this->Admin_model->getDivindedRes($folio,$company);
232 $result_array['transferDetails'] = $this->Admin_model->getTransferRes($folio,$company);
233 $result_array['certificateDetails'] = $this->Admin_model->getCertificateRes($folio,$company);
234 $certificateFolio = '';
235 $transferFolio = '';
236
237 if($result_array['certificateDetails']){ $certificateFolio = $result_array['certificateDetails'][0]->folio; }
238 if($result_array['transferDetails']){ $transferFolio = $result_array['transferDetails'][0]->fromfolio; }
239
240 $result_array['memberRes'] = '';
241 $result_array['dbmasRes'] = '';
242 $result_array['TransferFromFRes'] = '';
243 if($transferFolio == $folio )
244 {
245 if(isset($certificateFolio)) {
246 if($certificateFolio != $folio)
247 {
248 $result_array['memberRes'] = $this->Admin_model->getMemTransferRes($folio,$company);
249 }
250 else{
251 $result_array['memberRes'] = $this->Admin_model->getMemCertificateRes($folio,$company);
252 }
253 }
254 $result_array['TransferFromFRes'] = $this->Admin_model->getTransferFromFRes($folio,$company);
255 }
256 else{
257 $result_array['dbmasRes'] = $this->Admin_model->getdbMasRes($folio,$company);
258 }
259
260 }
261
262 // echo '<pre>';print_r($result_array);exit;
263 //$HTML=$this->load->view('createpdf',array('title_page'=>$title_page,'data_mahasiswa'=>$result_array),true);
264 $HTML=$this->load->view('createpdf',$result_array,true);
265 //echo $HTML;
266 $this->pdf->pdf_create($HTML,$title_page);//render atau membuat pdf dari html diatas
267 //$this->pdf->pdf_create($HTML,$title_page,'A4','potrait',FALSE);//jika langsung didownload pdf-nya
268
269 }
270
271 public function admin_users(){
272
273
274 $this->session_admincheck(); // call the function to check admin user
275
276 $result_array['userslist'] = $this->Welcome_model->userslist();
277 $this->load->view('includes/header');
278 $this->load->view('welcome/admin_users', $result_array);
279 $this->load->view('includes/footer');
280
281 }
282 public function add_admin(){
283
284 $this->session_admincheck(); // call the function to check admin user
285
286 $id = $this->uri->segment(3);
287 $result_array = array();
288 if($id > 0) {
289 $result_array['Admindetails'] = $this->Welcome_model->Admindetails($id);
290 }
291 else{
292 $result_array= array();
293 }
294 $this->load->view('includes/header');
295 $this->load->view('welcome/add_admin',$result_array);
296 $this->load->view('includes/footer');
297 }
298
299
300
301 // public function edit_profile(){
302 public function edit_user(){
303
304 // $this->session_admincheck(); // call the function to check admin user
305
306 $id = $this->uri->segment(3);
307 $result_array = array();
308 if($id > 0) {
309 $result_array['Admindetails'] = $this->Welcome_model->Admindetails($id);
310 }
311 else{
312 $result_array= array();
313 }
314 $this->load->view('includes/header');
315 $this->load->view('users/edit_user',$result_array);
316 $this->load->view('includes/footer');
317 }
318 public function insert(){
319 $username = $this->security->xss_clean($this->input->post('username'));
320 $password = $this->security->xss_clean($this->input->post('password'));
321 $confirm_password = $this->security->xss_clean($this->input->post('confirm_password'));
322 $email = $this->security->xss_clean($this->input->post('email'));
323 $user_role = $this->security->xss_clean($this->input->post('user_role'));
324 $dbInsertUser = $this->Welcome_model->adminuserDbInsert($username, $confirm_password, $email, $user_role);
325 if($dbInsertUser >0){
326 redirect('welcome/admin_users');
327 }
328 else{
329 $this -> session ->set_flashdata('message', 'Email Already Exists.');
330 redirect('welcome/add_admin');
331 }
332 }
333 public function delete()
334 {
335 $id = $this->uri->segment(3);
336 $dbDelete = $this->Welcome_model->AdminDbDelete($id);
337 $this -> session ->set_flashdata('message', 'Admin User Deleted Successfully.');
338 redirect('welcome/admin_users');
339 }
340 public function update(){
341 $username = $this->security->xss_clean($this->input->post('username'));
342 $password = $this->security->xss_clean($this->input->post('password'));
343 $confirm_password = $this->security->xss_clean($this->input->post('confirm_password'));
344 $email = $this->security->xss_clean($this->input->post('email'));
345 $user_role = $this->security->xss_clean($this->input->post('user_role'));
346 $id = $this->security->xss_clean($this->input->post('id'));
347 $fetch_pass = $this->security->xss_clean($this->input->post('fetch_pass'));
348 if($confirm_password == ''){
349 $password = $fetch_pass;
350 }
351 else{
352 $password = md5($confirm_password);
353 }
354 $dbUpdate = $this->Welcome_model->AdminDbUpdate($username, $password, $email, $user_role, $id);
355 if($dbUpdate == ''){
356 $this -> session ->set_flashdata('message', 'Admin Users Updated Successfully.');
357 redirect('welcome/admin_users');
358 } else {
359 $this -> session ->set_flashdata('message', 'Email Already Exists.');
360 redirect('welcome/admin_users');
361 }
362 }
363 public function logout()
364 {
365 $this->session->sess_destroy('user_session');
366 redirect('admin');
367 }
368 public function forgotpass(){
369 $this->load->view('welcome/forgotpassword');
370 }
371 function get_random_password($chars_min=6,$chars_max=8,$use_upper_case=false,$include_numbers=false,$include_special_chars=false)
372 {
373 $length = rand($chars_min, $chars_max);
374 $selection = 'aeuoyibcdfghjklmnpqrstvwxz';
375 if($include_numbers) {
376 $selection .= "1234567890";
377 }
378 if($include_special_chars) {
379 $selection .= '!@\"#$%&[]{}';
380 }
381
382 $password = "";
383 for($i=0; $i<$length; $i++) {
384 $current_letter = $use_upper_case ? (rand(0,1) ? strtoupper($selection[(rand() % strlen($selection))]) : $selection[(rand() % strlen($selection))]) : $selection[(rand() % strlen($selection))];
385 $password .= $current_letter;
386 }
387 return $password;
388 }
389 public function forgotpass_verify(){
390 $username = $this->security->xss_clean($this->input->post('email'));
391
392 $query = $this->db->query("SELECT * FROM user_management WHERE email='".$username."'");
393
394 $rec=$query->result_array();
395 $sqlno=$query->num_rows();
396
397 if ($sqlno == 1)
398 {
399 $password=self::get_random_password();
400 $qry="UPDATE user_management SET password='".md5($password)."' WHERE email='".$username."'";
401 $this->db->query($qry);
402 $adminfromMail='admin@teckst.com';
403 $sitename='EROM';
404 $message_to=$rec[0]['email'];
405 $message_title='Access Details';
406 $mailmessage='<div style="margin: 0px; font-family: Arial,Helvetica,sans-serif;">
407 <div style="border: 2px solid #76923c; padding-bottom: 15px; width: 600px;">
408 <div style="border-bottom: 1px solid rgb(245, 245, 245); padding: 10px 0pt 0pt 10px;background-color:#44C8E8;">
409 <img src="'.base_url().'/assets/images/erom-logo.png" alt="teckst"></div>
410 <br>
411 <div style="margin: 10px;">
412 <div style="font-size: 12px; color: rgb(51, 51, 51); line-height: 30px; font-weight: bold;">Hi '.$rec[0]['name'].',</div>
413 <div style="font-size: 12px; color: rgb(51, 51, 51); line-height: 18px; padding-bottom: 10px;"><span style="margin:10px 0; padding:0; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; line-height:22px; color:#5d5d5d;">As you request, your password has been reset and the new password is given below:
414</.!</span></div>
415 <div style="margin:15px 0 10px 0; background:#fdfcf8; border:#e2dabb solid 1px; padding:10px;">
416 <table cellpadding="0" cellspacing="0" border="0" width="500">
417 <tr>
418 <td valign="top" align="left" width="150"><p style="margin:5px 0; padding:0; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; line-height:22px; color:#555555;">Username</p></td>
419 <td valign="top" align="left" width="10"><p style="margin:5px 0; padding:0; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; line-height:22px; color:#555555;">:</p></td>
420 <td valign="top" align="left" width="440"><p style="margin:5px 0; padding:0; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; line-height:22px; color:#555555; font-weight:bold;">'.$rec[0]['name'].'</p></td>
421 </tr>
422 <tr>
423 <td valign="top" align="left"><p style="margin:5px 0; padding:0; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; line-height:22px; color:#555555;">Password</p></td>
424 <td valign="top" align="left"><p style="margin:5px 0; padding:0; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; line-height:22px; color:#555555;">:</p></td>
425 <td valign="top" align="left"><p style="margin:5px 0; padding:0; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; line-height:22px; color:#555555; font-weight:bold;">'.$password.'</p></td>
426 </tr>
427 <tr>
428 <td valign="top" align="left" colspan="3">
429<p style="margin:5px 0; padding:0; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; line-height:22px; color:#555555;">
430<a href="" style="font-weight:bold; color:#ce0b9e; font-family:Tahoma, Arial, Verdana; font-size:14px; text-decoration:none;" target="_blank">Click here</a> to Login</p></td>
431 </tr>
432 </table>
433 </div>
434 <div style="font-size: 12px;"><br>
435 <ul style="margin: 0px; padding: 10px 0pt 5px 10px; font-size: 12px; line-height: 20px; list-style: none outside none;">
436 <li>Thanks and Regards</li>
437 <li>EROM</li>
438 </ul>
439 </div>
440 </div>
441 </div>
442 </div>';
443 $config = Array('mailtype' => 'html','charset' => 'iso-8859-1');
444 $sitename='EROM';
445 $message_title='Teckst - New Password';
446 //echo $mailmessage;exit;
447 $this->load->library('email', $config);
448 $this->email->from($adminfromMail,$sitename);
449 $this->email->to($message_to);
450 $this->email->subject($message_title);
451 $this->email->message($mailmessage);
452 $this->email->set_newline("\r\n");
453 $this->email->send();
454 $this -> session ->set_flashdata('message', 'Your password has been reset successfully. Please check your Registered Emailid for your new password.');
455 redirect('welcome/forgotpass');
456 }
457 else{
458 $this -> session ->set_flashdata('message', 'Your email could not find in our database');
459 redirect('welcome/forgotpass');
460 }
461 }
462 //$this->load->view('includes/header');
463 //$this->load->view('welcome/add_admin',$result_array);
464 //$this->load->view('includes/footer');
465
466 public function erom(){
467
468 $this->load->view('includes/header');
469 // $this->load->view('erom_dashboard', $result_array);
470 $this->load->view('erom_dashboard');
471 $this->load->view('includes/footer');
472
473 }
474
475
476 }
477
478
479/* End of file welcome.php */
480/* Location: ./application/controllers/welcome.php */