API tools faq
paste
Guest User

welcome

a guest
Feb 5th, 2016
56
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.73 KB | None | 0 0
raw download clone embed print report
  1. <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
  2.  
  3. class 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 */
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!