File manager

File manager - Edit - /home/wwwroot/camplus.hk/master.camplus.hk/public_html/application/modules/form/controllers/MyForm.php

Back
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class MyForm extends MY_Controller { function __construct() { parent::__construct(); $this->load->model('MyForm_model'); $this->load->model('form/Form_model'); $this->load->model('core/User_model'); $this->load->model('Workflow/Workflow_model'); } function listing() { if($this->session->userdata("user_id")) { // if(!$this->acl->hasPermission('MANAGE_xxx')) // show_error($this->lang->line('no_permission_error')); $data = $this->data; $data['header'] = TRUE; $data['sidebar'] = TRUE; $data['_view'] = "form/my_form"; $data['quickbar'] = TRUE; $data['footer'] = TRUE; $data['top_menu'] = "form_top"; $data['sub_menu'] = "myform"; $data['pagetitle'] = $this->lang->line('my') . ' ' . $this->lang->line('form'); $data['myforms'] = $this->MyForm_model->getAppliedForms(); $this->load->view('basetemplate', $data); } else { redirect("login"); } } function all() { if($this->session->userdata("user_id")) { // if(!$this->acl->hasPermission('MANAGE_xxx')) // show_error($this->lang->line('no_permission_error')); $data = $this->data; $data['header'] = TRUE; $data['sidebar'] = TRUE; $data['_view'] = "form/all_form"; $data['quickbar'] = TRUE; $data['footer'] = TRUE; $data['top_menu'] = "form_top"; $data['sub_menu'] = "allform"; $data['pagetitle'] = $this->lang->line('all') . ' ' . $this->lang->line('form'); $data['myforms'] = $this->MyForm_model->getForms(); $data['users'] = $this->User_model->getAllUsers(); $this->load->view('basetemplate', $data); } else { redirect("login"); } } function approval() { if($this->session->userdata("user_id")) { // if(!$this->acl->hasPermission('MANAGE_xxx')) // show_error($this->lang->line('no_permission_error')); $data = $this->data; $data['header'] = TRUE; $data['sidebar'] = TRUE; $data['_view'] = "form/form_approval"; $data['quickbar'] = TRUE; $data['footer'] = TRUE; $data['top_menu'] = "form_top"; $data['sub_menu'] = "form_approval"; $data['pagetitle'] = $this->lang->line('form') . ' ' . $this->lang->line('approval'); $data['myforms'] = $this->MyForm_model->getApprovalForms(); $data['users'] = $this->User_model->getAllUsers(); $this->load->view('basetemplate', $data); } else { redirect("login"); } } function getForm($id = 0) { return $this->db->get_where('form',array('id' => $id))->row_array(); } function add() { if($this->session->userdata("user_id")) { if(!$this->input->post()) { // if(!$this->acl->hasPermission('MANAGE_xxx')) // show_error($this->lang->line('no_permission_error')); $data = $this->data; $data['header'] = TRUE; $data['sidebar'] = TRUE; $data['_view'] = "form/my_form_add"; $data['quickbar'] = TRUE; $data['footer'] = TRUE; $data['top_menu'] = "form_top"; $data['sub_menu'] = "addnewmyform"; $data['pagetitle'] = $this->lang->line('apply') . ' ' . $this->lang->line('new') . ' ' . $this->lang->line('form'); $data['workflowforms'] = $this->Workflow_model->getWorkflowForms(); $data['users'] = $this->User_model->getAllUsers(); $this->load->view('basetemplate', $data); } else { //if(!$this->acl->hasPermission('MANAGE_XXX')) // show_error($this->lang->line('no_permission_error')); //$this->form_validation->set_rules('title', 'Title', 'required'); //if ($this->form_validation->run()==false){ // $this->session->set_flashdata('error', $this->lang->line('action_performed_error')); //} //else //{ if($this->MyForm_model->addForm($this->input->post())) echo $this->session->set_flashdata('success', $this->lang->line('action_performed_success')); else echo $this->session->set_flashdata('error', $this->lang->line('action_performed_error')); //} //var_dump($this->input->post()); redirect('form/myForm/listing'); } } else { redirect("login"); } } function edit($id) { if($this->session->userdata("user_id")) { if(!$this->input->post()) { // if(!$this->acl->hasPermission('MANAGE_xxx')) // show_error($this->lang->line('no_permission_error')); $data = $this->data; $data['fid']=$id; $data['header'] = TRUE; $data['sidebar'] = TRUE; $data['_view'] = "form/my_form_edit"; $data['quickbar'] = TRUE; $data['footer'] = TRUE; $data['top_menu'] = "form_top"; $data['sub_menu'] = "myform"; $data['pagetitle'] = $this->lang->line('edit') . ' ' . $this->lang->line('form'); $data['forms'] = $this->Form_model->getForms(); $data['users'] = $this->User_model->getAllUsers(); $data['myform'] =$this->MyForm_model->getFilledForm($id); $data['workflowforms'] = $this->Workflow_model->getWorkflowForms(); $this->load->view('basetemplate', $data); } else { // print_r($this->input->post());die; //if(!$this->acl->hasPermission('MANAGE_XXX')) // show_error($this->lang->line('no_permission_error')); $data = $this->MyForm_model->getForm($id); if(empty($data)) show_error('No record found'); // $this->form_validation->set_rules('title', 'Title', 'required'); //if ($this->form_validation->run()==false){ // $this->session->set_flashdata('error', $this->lang->line('action_performed_error')); //} //else //{ if($this->MyForm_model->editForm($this->input->post(),$id)) $this->session->set_flashdata('success', $this->lang->line('action_performed_success')); else $this->session->set_flashdata('error', $this->lang->line('action_performed_error')); //} //redirect($_SERVER['HTTP_REFERER']); redirect('form/myForm/listing'); } } else { redirect("login"); } } function approveForm($id) { if($this->session->userdata("user_id")) { // if($this->MyForm_model->updateFormApproveStatus($id,'Agree' )) // { // $this->session->set_flashdata('success', $this->lang->line('action_performed_success')); // } // else // { // $this->session->set_flashdata('error', $this->lang->line('action_performed_error')); // } $data=$this->MyForm_model->getFormStatusDetails($id); print_r($data); die; $data1=$this->MyForm_model->getFormDetails($data['ff_id']); //print_r($data1); //echo "<br><br>"; $applicant=$this->MyForm_model->userDetails($data1[0]['uid']); //print_r($applicant); //die; $filledworkflow=json_decode($data1[0]['filledworkflow'],true); //print_r($filledworkflow); $workflow=json_decode($data1[0]['workflow'],true); //print_r($workflow); //echo $workflow['workflow'][$data['level']]['approve'];die; if($workflow['workflow'][$data['level']]['approve']==1) { $alluser=$this->MyForm_model->getAllUserStatusDetails($data['ff_id'],$data['level']); //print_r($alluser); for ($i=0; $i <count($alluser); $i++) { $allStatus[]=$alluser[$i]['action']; } //print_r($allStatus); if( !(in_array('Pending', $allStatus) \|\| in_array('Disagree', $allStatus) )) { $level=$data['level']+1; if($filledworkflow[$level]['users']!='') { $users=explode(",",$filledworkflow[$level]['users']); //print_r($users); if(!empty($users)) { foreach ($users as $key => $value) { $this->MyForm_model->addNextLevel($data['ff_id'],$value,'Pending',$level); $user=$this->MyForm_model->userDetails($value); $this->send_mail($user,$applicant['username']); } } } } } else { $level=$data['level']+1; if($filledworkflow[$level]['users']!='') { $users=explode(",",$filledworkflow[$level]['users']); //print_r($users); //echo "hii"; die; print_r($users); if(!empty($users)) { foreach ($users as $key => $value) { $this->MyForm_model->addNextLevel($data['ff_id'],$value,'Pending',$level); $user=$this->MyForm_model->userDetails($value); $this->send_mail($user,$applicant['username']); } } } } //die; //echo json_encode($data); $this->session->set_flashdata('success', $this->lang->line('action_performed_success')); redirect('form/myForm/approval'); } else { redirect("login"); } } function rejectForm($id) { if($this->session->userdata("user_id")) { if($this->MyForm_model->updateFormApproveStatus($id,'Disagree')) $this->session->set_flashdata('success', $this->lang->line('action_performed_success')); else $this->session->set_flashdata('error', $this->lang->line('action_performed_error')); //echo json_encode($data); redirect('form/myForm/approval'); } else { redirect("login"); } } function delete($id=0){ if($this->session->userdata("user_id")) { if(!$this->acl->hasPermission('MANAGE_XXX')) show_error($this->lang->line('no_permission_error')); $data = $this->MyForm_model->getForm($id); if(empty($data)) show_error('No record found'); if($this->MyForm_model->deleteMyForm($id)) $this->session->set_flashdata('success', $this->lang->line('action_performed_success')); else $this->session->set_flashdata('error', $this->lang->line('action_performed_error')); redirect($_SERVER['HTTP_REFERER']); } else { redirect("login"); } } function get($id=0) { if($this->session->userdata("user_id")) { $data = $this->MyForm_model->getFormworkflow($id); echo json_encode($data); } else { redirect("login"); } } function getWorkflowUser($id=0) { if($this->session->userdata("user_id")) { $this->MyForm_model->getFormworkflow($id); //echo json_encode($data); } else { redirect("login"); } } function send_mail($data ,$name) { $url=base_url().'form/myForm/approval'; $message='<html><body><h3>'; $message.='Dear '.$data['username'].',</h3><br><p>'; $message.= 'New form has applied the '.$name.' please go to this link <a href="'.$url.'"> Link </a> for approval.</p></br></br>'; $message.='<p>Thanks!</p>'; $message.='</html></body>'; $this->load->library('email'); $config['mailtype'] = 'html'; $config['charset'] = 'iso-8859-1'; $config['wordwrap'] = TRUE; $this->email->initialize($config); $this->email->from('admin@proedge.hk', 'Camplus Admin'); $this->email->to($data['email']); // $this->email->cc('adam@proedge.hk'); // $this->email->bcc('support@proedge.hk'); $this->email->subject('New Form'); $this->email->message($message); $this->email->send(); } function downloadFormat() { if($this->session->userdata("user_id")) { $filename="myForms_csv_format.csv"; //load our new PHPExcel library $this->load->library('excel'); //activate worksheet number 1 $this->excel->setActiveSheetIndex(0); //name the worksheet $this->excel->getActiveSheet()->setTitle('Forms list'); $holidays =$this->MyForm_model->getAppliedForms(); $outarray = array(); for($i=0;$i<count($holidays);$i++) { $newarray=$holidays[$i]; unset($newarray['id']); if($i==0) { $headerarr=array("date"=>"Date","title"=>"Forms","action"=>"Status","approval"=>"Last Approval"); $outarray[]=$headerarr; $outarray[]=array("date"=>date('Y-m-d', strtotime( $newarray['last_modified'] ) ), "title"=>$newarray['title'],"action"=>$newarray['action'],"approval"=>""); } else { //unset($newarray['id']); $outarray[]=array("date"=>date('Y-m-d', strtotime( $newarray['last_modified'] ) ), "title"=>$newarray['title'],"action"=>$newarray['action'],"approval"=>""); } } // read data to active sheet $this->excel->getActiveSheet()->fromArray($outarray); header("Content-type: application/csv"); header("Content-Disposition: attachment; filename=".$filename); $objWriter = PHPExcel_IOFactory::createWriter($this->excel, 'Excel5'); $objWriter->save('php://output'); } else { redirect("login"); } } function downloadFormApproval() { if($this->session->userdata("user_id")) { $filename="FormApproval_csv_format.csv"; //load our new PHPExcel library $this->load->library('excel'); //activate worksheet number 1 $this->excel->setActiveSheetIndex(0); //name the worksheet $this->excel->getActiveSheet()->setTitle('Forms list'); $holidays =$this->MyForm_model->getApprovalForms(); $users= $this->User_model->getAllUsers(); $outarray = array(); for($i=0;$i<count($holidays);$i++) { $newarray=$holidays[$i]; unset($newarray['id']); if($i==0) { $headerarr=array("date"=>"Date","applicant"=>"Applicant","title"=>"Forms","action"=>"Status"); $outarray[]=$headerarr; $outarray[]=array("date"=>date('Y-m-d', strtotime( $newarray['last_modified'] ) ), "applicant"=>$users[array_search($newarray['uid'],array_column($users,'id'))]['username'] , "title"=>$newarray['title'],"action"=>$newarray['action']); } else { //unset($newarray['id']); $outarray[]=array("date"=>date('Y-m-d', strtotime( $newarray['last_modified'] ) ), "applicant"=>$users[array_search($newarray['uid'],array_column($users,'id'))]['username'] , "title"=>$newarray['title'],"action"=>$newarray['action']); } } // read data to active sheet $this->excel->getActiveSheet()->fromArray($outarray); header("Content-type: application/csv"); header("Content-Disposition: attachment; filename=".$filename); $objWriter = PHPExcel_IOFactory::createWriter($this->excel, 'Excel5'); $objWriter->save('php://output'); } else { redirect("login"); } } function downloadAllForm() { if($this->session->userdata("user_id")) { $filename="AllForm_csv_format.csv"; //load our new PHPExcel library $this->load->library('excel'); //activate worksheet number 1 $this->excel->setActiveSheetIndex(0); //name the worksheet $this->excel->getActiveSheet()->setTitle('Forms list'); $holidays =$this->MyForm_model->getForms(); $users= $this->User_model->getAllUsers(); $outarray = array(); for($i=0;$i<count($holidays);$i++) { $newarray=$holidays[$i]; unset($newarray['id']); if($i==0) { $headerarr=array("date"=>"Date","title"=>"Forms","action"=>"Status","applicant"=>"Applicant","lastApproval"=>"Last Approval"); $outarray[]=$headerarr; $outarray[]=array("date"=>date('Y-m-d', strtotime( $newarray['last_modified'] ) ),"title"=>$newarray['title'],"action"=>$newarray['action'], "applicant"=>$users[array_search($newarray['uid'],array_column($users,'id'))]['username'],"lastApproval"=>" " ); } else { //unset($newarray['id']); $outarray[]=array("date"=>date('Y-m-d', strtotime( $newarray['last_modified'] ) ),"title"=>$newarray['title'],"action"=>$newarray['action'], "applicant"=>$users[array_search($newarray['uid'],array_column($users,'id'))]['username'],"lastApproval"=>" " ); } } // read data to active sheet $this->excel->getActiveSheet()->fromArray($outarray); header("Content-type: application/csv"); header("Content-Disposition: attachment; filename=".$filename); $objWriter = PHPExcel_IOFactory::createWriter($this->excel, 'Excel5'); $objWriter->save('php://output'); } else { redirect("login"); } } }

| ver. 1.4 | Github | . | PHP 7.2.34 | Generation time: 0.26 | proxy | phpinfo | Settings