home - PHP Online
Form of PHP Sandbox
*** This page was generated with the meta tag "noindex, nofollow". This happened because you selected this option before saving or the system detected it as spam. This means that this page will never get into the search engines and the search bot will not crawl it. There is nothing to worry about, you can still share it with anyone.
Enter Your PHP code here for testing/debugging in the Online PHP Sandbox. As in the usual PHP files, you can also add HTML, but do not forget to add the tag <?php
in the places where the PHP script should be executed.
Result of php executing
Full code of home.php
- <?php
- defined('BASEPATH') OR exit('No direct script access allowed');
- class Home extends CI_Controller {
- ############################################ FUNCTION CONSTRUCTOR #################################
- function __construct()
- {
- parent::__construct();
- if(!$this->session->userdata('logged_in'))
- {
- redirect('login','refresh');
- }
- if($this->session->userdata('logged_in')['first_login_status']==0 && $this->uri->segment(1)!='update-password')
- {
- redirect('update-password');
- }
- if($this->session->userdata('logged_in')['first_login_status']==1 && $this->uri->segment(1)!='profile')
- {
- redirect('profile');
- }
- $this->load->model('Common_model');
- $this->load->model('Manage_model');
- if($this->session->userdata('logged_in')['privilege_id']==4)
- {
- $organizations_id = $this->session->userdata('logged_in')['table_id'];
- $OD = $this->Manage_model->get_organization_details($organizations_id);
- date_default_timezone_set($OD['timezone']);
- }
- else
- {
- date_default_timezone_set('Asia/Qatar');
- }
- }
- ############################################ END OF FUNCTION CONSTRUCTOR ##########################
- ############################################ COMMON VIEW PAGE #####################################
- public function CommonPage($page,$data,$PageName='')
- {
- $SD['side_menu'] = $this->Common_model->get_side_menu();
- $CurrentUrlId = $this->Common_model->get_current_url_id();
- $AllowedMenu = $this->Common_model->allowed_menus_by_privilege();
- $AllowedMainMenu = json_decode($AllowedMenu['main_menu']);
- $AllowedSubMenu = json_decode($AllowedMenu['sub_menu']);
- if($CurrentUrlId['MainMenu']!='0')
- {
- if(!in_array($CurrentUrlId['MainMenu'],$AllowedMainMenu))
- {
- redirect('dashboard','refresh');
- }
- }
- if($CurrentUrlId['SubMenu']!='0')
- {
- if(!in_array($CurrentUrlId['SubMenu'],$AllowedSubMenu))
- {
- redirect('dashboard','refresh');
- }
- }
- if($this->uri->segment(1)=='meeting-details'){ $SD['MD'] = $data['MD']; } // setup side menu
- $HeadData['PageName'] = $PageName;
- $this->load->view('include/header',$HeadData);
- $this->load->view('include/head',$HeadData);
- $this->load->view('include/sidemenu',$SD);
- $this->load->view($page,$data);
- $this->load->view('include/footer');
- }
- ############################################ END OF COMMON VIEW PAGE ##############################
- ############################################ LOGOUT ###############################################
- public function logout()
- {
- // Activity Log Record
- $user_data = $this->session->userdata('logged_in');
- $head = 'Logged Out';
- $description = $user_data['name'].' ('.$user_data['username'].') Has been Logged Out';
- $this->Common_model->create_activity_log($head,$description,'',array(),array(),'1');
- // Activity Log Record
- session_destroy();
- redirect('home','refresh');
- }
- ############################################ END OF LOGOUT ########################################
- ############################################ CHANGE PASSWORD ######################################
- public function change_password()
- {
- if(isset($_POST['ChangePassword']))
- {
- $this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');
- $this->form_validation->set_rules('current_url','current_url','trim|required|xss_clean');
- $this->form_validation->set_rules('current_password','current_password','trim|required|xss_clean');
- $this->form_validation->set_rules('new_password','new_password','trim|required|xss_clean|min_length[8]');
- $this->form_validation->set_rules('confirm_password','confirm_password','trim|required|xss_clean|min_length[8]');
- $current_url = $this->input->post('current_url');
- if($this->form_validation->run())
- {
- $current_password = $this->input->post('current_password');
- $new_password = $this->input->post('new_password');
- $confirm_password = $this->input->post('confirm_password');
- $users_id = $this->session->userdata('logged_in')['users_id'];
- $UD = $this->Common_model->get_user_details($users_id);
- if($UD['password']==MD5($current_password))
- {
- if($new_password==$confirm_password)
- {
- $value = array('password'=>MD5($new_password));
- $where = array('users_id'=>$users_id);
- $this->Common_model->common_update('users',$value,$where);
- $this->Common_model->Set_Message('1','Password changed successfully');
- // sent Mail - password change
- if($UD['privilege_id']=='4' || $UD['privilege_id']=='5')
- {
- $this->SentMail('8',$UD['username'],'');
- }
- // sent Mail - password change
- }
- else
- {
- $this->Common_model->Set_Message('2','Password not matching');
- }
- }
- else
- {
- $this->Common_model->Set_Message('2','Current password is incorrect');
- }
- redirect($current_url);
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- redirect($current_url);
- }
- }
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- redirect('dashboard');
- }
- ############################################ END OF CHANGE PASSWORD ###############################
- ############################################ INDEX ################################################
- public function index()
- {
- redirect('dashboard','refresh');
- }
- ############################################ END OF INDEX #########################################
- ############################################ UPDATE PASSWORD ######################################
- public function update_password()
- {
- $user_data = $this->session->userdata('logged_in');
- if(isset($_POST['ChangePassword']))
- {
- $this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');
- $this->form_validation->set_rules('password','Password','trim|required|xss_clean|min_length[8]');
- $this->form_validation->set_rules('c_password','Confirm Password','trim|required|xss_clean|min_length[8]|matches[password]');
- if($this->form_validation->run())
- {
- $password = $this->input->post('password');
- $value = array('password'=>MD5($password),'first_login_status'=>'1');
- $where = array('users_id'=>$user_data['users_id']);
- $this->Common_model->common_update('users',$value,$where);
- $UD = $this->Common_model->get_user_details($user_data['users_id']);
- // sent Mail - password change
- if($UD['privilege_id']=='4' || $UD['privilege_id']=='5')
- {
- $this->SentMail('8',$UD['username'],'');
- }
- // sent Mail - password change
- // reset session
- $sess_data = $user_data;
- $sess_data['first_login_status'] = '1';
- $this->session->set_userdata('logged_in', $sess_data);
- $this->Common_model->Set_message('1','Password changed successfully');
- redirect('dashboard');
- }
- }
- $this->load->view('dashboard/update_password','');
- }
- ############################################ END OF UPDATE PASSWORD ###############################
- ############################################ DASHBOARDD ###########################################
- public function dashboard()
- {
- $data = array();
- if($this->session->userdata('logged_in')['privilege_id']==4)
- {
- // dashboard statistics
- $organizations_id = $this->session->userdata('logged_in')['table_id'];
- // $data['TotalMeetings'] = $this->Manage_model->get_meetings_total_count($organizations_id);
- // $data['CancelledMeetings'] = $this->Manage_model->get_meetings_cancelled_count($organizations_id);
- // $data['UpcomingMeetings'] = $this->Manage_model->get_meetings_upcoming_count($organizations_id);
- // $data['CompletedMeetings'] = $this->Manage_model->get_meetings_completed_count($organizations_id);
- $data['TotalCompanies'] = $this->Manage_model->get_total_companies($organizations_id);
- $data['TotalCompanyMembers'] = $this->Manage_model->get_total_company_members($organizations_id);
- $data['TotalOrgMembers'] = $this->Manage_model->get_total_org_members($organizations_id);
- $data['TotalOrgSecurities'] = $this->Manage_model->get_total_org_securities($organizations_id);
- $data['PendingRequests'] = $this->Manage_model->get_total_org_pending_requests($organizations_id);
- // dashboard statistics
- // org details
- $OD = $this->Manage_model->get_organization_details($organizations_id);
- $data['BalanceMeetings'] = $OD['meetings_count'];
- $data['MembersPerMeeting'] = $OD['members_count'];
- // List
- // $data['UpcomingMeetingsList'] = $this->Manage_model->view_upcoming_meetings();
- // $data['LatestMeetingsList'] = $this->Manage_model->view_latest_meetings();
- $data['OD'] = $OD;
- }
- elseif($this->session->userdata('logged_in')['privilege_id']==5)
- {
- // dashboard statistics
- $organizations_id = $this->session->userdata('logged_in')['table_id'];
- $data['TotalMeetings'] = $this->Manage_model->get_meetings_total_count($organizations_id);
- $data['CancelledMeetings'] = $this->Manage_model->get_meetings_cancelled_count($organizations_id);
- $data['UpcomingMeetings'] = $this->Manage_model->get_meetings_upcoming_count($organizations_id);
- $data['CompletedMeetings'] = $this->Manage_model->get_meetings_completed_count($organizations_id);
- $data['TotalOrgMembers'] = $this->Manage_model->get_total_org_members($organizations_id);
- $data['TotalOrgSecurities'] = $this->Manage_model->get_total_org_securities($organizations_id);
- // dashboard statistics
- // org details
- $OD = $this->Manage_model->get_organization_details($organizations_id);
- $data['BalanceMeetings'] = $OD['meetings_count'];
- $data['MembersPerMeeting'] = $OD['members_count'];
- // List
- $data['OD'] = $OD;
- }
- elseif($this->session->userdata('logged_in')['privilege_id']==1 || $this->session->userdata('logged_in')['privilege_id']==2)
- {
- // $data['TotalMeetings'] = $this->Manage_model->get_meetings_total_count('');
- // $data['CancelledMeetings'] = $this->Manage_model->get_meetings_cancelled_count('');
- // $data['UpcomingMeetings'] = $this->Manage_model->get_meetings_upcoming_count('');
- // $data['CompletedMeetings'] = $this->Manage_model->get_meetings_completed_count('');
- // $data['TotalMembers'] = $this->Manage_model->get_total_members();
- $data['TotalCompanies'] = $this->Manage_model->get_total_companies('');
- $data['TotalOrganization'] = $this->Manage_model->get_total_organizations();
- $data['TotalRegistrations'] = $this->Manage_model->get_total_registrations();
- }
- elseif($this->session->userdata('logged_in')['privilege_id']==6)
- {
- $country_id = $this->session->userdata('logged_in')['table_id']; // for country admin only
- $data['TotalMeetings'] = $this->Manage_model->get_meetings_total_count('',$country_id);
- $data['CancelledMeetings'] = $this->Manage_model->get_meetings_cancelled_count('',$country_id);
- $data['UpcomingMeetings'] = $this->Manage_model->get_meetings_upcoming_count('',$country_id);
- $data['CompletedMeetings'] = $this->Manage_model->get_meetings_completed_count('',$country_id);
- $data['TotalMembers'] = $this->Manage_model->get_total_members($country_id);
- $data['TotalCompanies'] = $this->Manage_model->get_total_companies('',$country_id);
- $data['TotalOrganization'] = $this->Manage_model->get_total_organizations($country_id);
- $data['TotalRegistrations'] = $this->Manage_model->get_total_registrations($country_id);
- $data['OD'] = $this->Manage_model->get_country_admin_details($country_id);
- $FD = array('country_id'=>$country_id,'start_date'=>'','end_date'=>'');
- $data['GrandTotal'] = $this->Manage_model->subscription_report_grand_total($FD,'','','0');
- $data['TotalSubscription'] = $this->Manage_model->get_total_subscription($FD,'','','0');
- }
- if($this->session->userdata('logged_in')['privilege_id']==4)
- {
- $MenuName = 'Organization Dashboard';
- }
- elseif($this->session->userdata('logged_in')['privilege_id']==5)
- {
- $MenuName = 'Residential Dashboard';
- }
- else
- {
- $MenuName = 'Meet Pass Dashboard';
- }
- $this->CommonPage('dashboard/dashboard',$data,$MenuName);
- }
- ############################################ END OF DASHBOARDD ####################################
- ############################################ COMMON AJAX REQUESTS #################################
- public function get_places_select()
- {
- $Data = '<option value="">Select Place</option>';
- if(isset($_POST['data_id']))
- {
- $this->form_validation->set_rules('data_id','data_id','trim|required|xss_clean');
- if($this->form_validation->run())
- {
- $country_id = $this->input->post('data_id');
- $DT = $this->Manage_model->select_view_places($country_id);
- foreach($DT as $DT1)
- {
- $Data .= '<option value="'.$DT1->places_id.'">'.$DT1->places.'</option>';
- }
- }
- }
- $data['result'] = $Data;
- echo json_encode($data);
- }
- public function get_members_autocomplete_type()
- {
- $data['response'] = 'false';
- $data['message'] = array();
- if(isset($_POST['keyword']))
- {
- $this->form_validation->set_rules('keyword','keyword','trim|required|xss_clean');
- $this->form_validation->set_rules('type_id','type_id','trim|required|xss_clean');
- if($this->form_validation->run())
- {
- $keyword = $this->input->post('keyword');
- $type_id = $this->input->post('type_id');
- if($type_id==0)
- {
- $CD = $this->Manage_model->get_organization_members_autocomplete($keyword);
- }
- else
- {
- $CD = $this->Manage_model->get_company_members_autocomplete($keyword);
- }
- $data['response'] = 'true';
- $data['message'] = $CD;
- }
- }
- echo json_encode($data);
- }
- public function get_members_autocomplete_meetings()
- {
- $CD = array();
- if(isset($_POST['member_type']))
- {
- $this->form_validation->set_rules('member_type','member_type','trim|required|xss_clean');
- $this->form_validation->set_rules('company_id','company_id','trim|required|xss_clean');
- if($this->form_validation->run())
- {
- $member_type = $this->input->post('member_type');
- $company_id = $this->input->post('company_id');
- if($member_type==0)
- {
- $CD = $this->Manage_model->view_members_select();
- }
- else
- {
- $CD = $this->Manage_model->view_company_members_select($company_id);
- }
- }
- }
- $Message = '<input type="text" class="form-control mb10 form-control-sm" id="SearchMember" onkeyup="search_member_list()" placeholder="Search"><li class="SelectAll"><label class="CheckBoxLabel" for="MainCheckBox"><input type="checkbox" name="MainCheckBox" id="MainCheckBox"> Select All</label></li>';
- foreach($CD as $DT1)
- {
- $Message .= '<li><label class="CheckBoxLabel" for="CHK'.$DT1->members_id.'"><input type="checkbox" class="SubCheckBox" name="members_id['.$DT1->members_sub_id.']" id="CHK'.$DT1->members_id.'" value="'.$DT1->members_id.'"> '.$DT1->name.' - '.$DT1->phone.' - '.$DT1->designation.'</label></li>';
- }
- echo json_encode($Message);
- }
- ############################################ END OF COMMON AJAX REQUESTS ##########################
- ############################################ ASSIGN PRIVILEGE MENU ################################
- public function assign_menu()
- {
- if(isset($_POST['save_menu']))
- {
- $created_by = $this->session->userdata('logged_in')['users_id'];
- $privilege_id = trim($this->input->post('privilege_id'));
- if($privilege_id!='' && $privilege_id!='0')
- {
- $main_menu = $sub_menu = array();
- if(isset($_POST['main_menu']))
- {
- $main_menu = $this->input->post('main_menu');
- }
- if(isset($_POST['sub_menu']))
- {
- $sub_menu = $this->input->post('sub_menu');
- }
- $main_menu[] = '1';
- $main_menu = array_unique($main_menu);
- $main_menu = json_encode($main_menu);
- $sub_menu = json_encode($sub_menu);
- $AP_menu = $this->Manage_model->get_privilege_menu($privilege_id);
- if(!empty($AP_menu))
- {
- $where = array('privilege_id'=>$privilege_id);
- $value = array('main_menu'=>$main_menu,'sub_menu'=>$sub_menu);
- $this->Common_model->common_update('crm_menu_user',$value,$where);
- }
- else
- {
- $value = array('created_by'=>$created_by,'privilege_id'=>$privilege_id,'main_menu'=>$main_menu,'sub_menu'=>$sub_menu);
- $this->Common_model->common_insert('crm_menu_user',$value);
- }
- $this->Common_model->Set_Message('1',"<strong>Success!</strong> User Menu Re-arranged Successfully");
- $_SESSION['AM_privilege_id'] = $privilege_id;
- // Activity Log Record
- $head = 'CRM Menu Updated';
- $description = 'User Menu Updated By ';
- $this->Common_model->create_activity_log($head,$description,'',array(),array(),'2');
- // Activity Log Record
- }
- else
- {
- $this->Common_model->Set_Message('2',"<strong>Error!</strong> Oops something went wrong. Please try again.");
- }
- redirect(current_url());
- }
- if(isset($_POST['submit']))
- {
- $privilege_id = trim($this->input->post('privilege_id'));
- if($privilege_id!='' && $privilege_id!='0')
- {
- $_SESSION['AM_privilege_id'] = $privilege_id;
- }
- else
- {
- $this->Common_model->Set_Message('2',"<strong>Error!</strong> Oops something went wrong. Please try again.");
- }
- redirect(current_url());
- }
- elseif(isset($_SESSION['AM_privilege_id']) && $_SESSION['AM_privilege_id']!='')
- {
- $privilege_id = $_SESSION['AM_privilege_id'];
- $_SESSION['AM_privilege_id'] = '';
- }
- else
- {
- $privilege_id = $_SESSION['AM_privilege_id'] = '';
- }
- if($privilege_id!='')
- {
- $data['menu'] = $this->Manage_model->get_side_menu();
- $data['AP_menu'] = $this->Manage_model->get_privilege_menu($privilege_id);
- }
- $data['privilege_id'] = $privilege_id;
- $data['privilege'] = $this->Manage_model->get_privilege_select();
- $this->CommonPage('manage/assign_menu',$data,'Menu Assign');
- }
- ############################################ END OF ASSIGN PRIVILEGE MENU #########################
- ############################################ VIEW ORGANIZATIONS ###################################
- public function view_organizations()
- {
- # INSERT / UPDATE FUNCTION
- if(isset($_POST['submit']))
- {
- $this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');
- $this->form_validation->set_rules('country_id','Country','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('privilege_id','Privilege','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('places_id','Place','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('organization_type_id','Type','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('name','Name','trim|required|xss_clean');
- $this->form_validation->set_rules('phone','Phone','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('email','Email','trim|required|xss_clean|valid_email|is_unique[organizations.email]');
- $this->form_validation->set_rules('location','Location','trim|required|xss_clean');
- $this->form_validation->set_rules('latitude','Location','trim|required|xss_clean');
- $this->form_validation->set_rules('longitude','Location','trim|required|xss_clean');
- $this->form_validation->set_rules('building_name','Building Name','trim|required|xss_clean');
- $this->form_validation->set_rules('building_number','Building Number','trim|required|xss_clean');
- $this->form_validation->set_rules('floor_number','Floor Number','trim|required|xss_clean');
- $this->form_validation->set_rules('office_number','Office Number','trim|required|xss_clean');
- $this->form_validation->set_rules('near_landmark','Near Landmark','trim|required|xss_clean');
- $this->form_validation->set_rules('cp_name','CP Name','trim|required|xss_clean');
- $this->form_validation->set_rules('cp_phone','CP Pphone','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('cp_email','CP Email','trim|required|xss_clean|valid_email');
- $this->form_validation->set_rules('cp_designation','CP Designation','trim|required|xss_clean');
- if($this->input->post('submit')=='Save')
- {
- $this->form_validation->set_rules('organizations_id','Organizations ID','trim|xss_clean');
- }
- else
- {
- $this->form_validation->set_rules('organizations_id','Organizations ID','trim|xss_clean|numeric|required');
- }
- if($this->form_validation->run())
- {
- $privilege_id = $this->input->post('privilege_id');
- $country_id = $this->input->post('country_id');
- $places_id = $this->input->post('places_id');
- $organization_type_id = $this->input->post('organization_type_id');
- $name = $this->input->post('name');
- $phone = $this->input->post('phone');
- $email = $this->input->post('email');
- $location = $this->input->post('location');
- $latitude = $this->input->post('latitude');
- $longitude = $this->input->post('longitude');
- $building_name = $this->input->post('building_name');
- $building_number = $this->input->post('building_number');
- $floor_number = $this->input->post('floor_number');
- $office_number = $this->input->post('office_number');
- $near_landmark = $this->input->post('near_landmark');
- $cp_name = $this->input->post('cp_name');
- $cp_phone = $this->input->post('cp_phone');
- $cp_email = $this->input->post('cp_email');
- $cp_designation = $this->input->post('cp_designation');
- $organizations_id = $this->input->post('organizations_id');
- $submit = $this->input->post('submit');
- $ValidityDate = date('Y-m-d', strtotime('+14 days'));
- $values = array('datetime'=>date('Y-m-d H:i:s'),
- 'privilege_id'=>$privilege_id,
- 'country_id'=>$country_id,
- 'places_id'=>$places_id,
- 'organization_type_id'=>$organization_type_id,
- 'name'=>ucwords($name),
- 'phone'=>$phone,
- 'email'=>strtolower($email),
- 'location'=>$location,
- 'latitude'=>$latitude,
- 'longitude'=>$longitude,
- 'building_name'=>$building_name,
- 'building_number'=>$building_number,
- 'floor_number'=>$floor_number,
- 'office_number'=>$office_number,
- 'near_landmark'=>$near_landmark,
- 'cp_name'=>ucwords($cp_name),
- 'cp_phone'=>$cp_phone,
- 'cp_email'=>strtolower($cp_email),
- 'cp_designation'=>$cp_designation,
- 'meetings_count'=>'10',
- 'members_count'=>'10',
- 'events_count'=>'2',
- 'events_members_count'=>'25',
- 'dedicated_link_availability'=>'1',
- 'app_create_meeting_status'=>'1',
- 'multiple_locations_status'=>'0',
- 'follow_up_meeting_status'=>'0',
- 'advanced_security_level'=>'0',
- 'packge_validity_upto'=>$ValidityDate,
- 'trial_start_date'=>date('Y-m-d'));
- $user_values = array('username'=>strtolower($email),
- 'password'=>MD5($phone),
- 'name'=>ucwords($name),
- 'privilege_id'=>$privilege_id,
- 'table_id'=>'0',
- 'image'=>'dummy-icon.jpg');
- if(isset($_FILES['image']) && $_FILES['image']['name']!='')
- {
- $image_name = $this->Common_model->image_upload('./uploads/organizations/','image');
- if($image_name!='')
- {
- $values['image'] = $image_name;
- }
- $image_name = $this->Common_model->image_upload('./uploads/users/','image');
- if($image_name!='')
- {
- $user_values['image'] = $image_name;
- }
- }
- if($submit=='Save')
- {
- $organizations_id = $this->Common_model->common_insert('organizations',$values);
- $this->Common_model->Set_Message('1',"Organization details entered successfully");
- // Activity Log Record
- $head = 'Add Organization';
- $description = 'Organization Details Has Been Added By ';
- $this->Common_model->create_activity_log($head,$description,'',array(),array('organizations_id'=>$organizations_id),'3');
- // Activity Log Record
- $user_values['table_id'] = $organizations_id;
- $this->Common_model->common_insert('users',$user_values);
- // sent Mail - login credential
- $data['LoginDetails'] = array('username'=>strtolower($email),'password'=>$phone);
- $this->SentMail('6',$email,$data);
- // sent Mail - login credential
- // sent Mail - trial period
- $this->SentMail('7',$email,'');
- // sent Mail - trial period
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- }
- redirect(current_url());
- }
- else
- {
- if($this->input->post('submit')=='Update')
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- redirect(current_url());
- }
- }
- }
- # END OF INSERT / UPDATE FUNCTION
- // BLOCK ORG USER
- if(isset($_POST['block']) && $this->session->userdata('logged_in')['privilege_id']!=4)
- {
- $this->form_validation->set_rules('block_id','Block ID','trim|xss_clean|required');
- if($this->form_validation->run())
- {
- $block_id = $this->input->post('block_id');
- $where = array('table_id'=>$block_id);
- $value = array('users_status'=>'2');
- $this->Common_model->common_update('users',$value,$where);
- $this->Common_model->Set_Message('1','User blocked successfully.');
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- }
- redirect(current_url());
- }
- // BLOCK ORG USER
- // BLOCK ORG USER
- if(isset($_POST['unblock']) && $this->session->userdata('logged_in')['privilege_id']!=4)
- {
- $this->form_validation->set_rules('unblock_id','Block ID','trim|xss_clean|required');
- if($this->form_validation->run())
- {
- $unblock_id = $this->input->post('unblock_id');
- $OD = $this->Manage_model->get_organization_details($unblock_id);
- if(!empty($OD))
- {
- // update table users
- $where = array('table_id'=>$unblock_id);
- $value = array('users_status'=>'0');
- $this->Common_model->common_update('users',$value,$where);
- // update table users_login_ip
- $where = array('username'=>$OD['email']);
- $value = array('users_login_ip_status'=>'1');
- $this->Common_model->common_update('users_login_ip',$value,$where);
- $this->Common_model->Set_Message('1','User unblocked successfully.');
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- }
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- }
- redirect(current_url());
- }
- // BLOCK ORG USER
- # FILTER AND PAGINATION SECTION
- $URL = $this->uri->segment(1);
- $param[] = array('key'=>'name','default'=>'');
- $param[] = array('key'=>'email','default'=>'');
- $param[] = array('key'=>'country_id','default'=>'');
- $FD = $this->Common_model->common_filter($URL,$param);
- if($this->session->userdata('logged_in')['privilege_id']==6)
- {
- $FD['country_id'] = $this->session->userdata('logged_in')['table_id']; // for country admin only
- }
- $start = $limit = '';
- $page_ary['url'] = base_url($URL);
- $page_ary['total_rows'] = $this->Manage_model->view_organizations($FD,$start,$limit,'1')[0]->count;
- $limit = $page_ary['per_page'] = 30;
- $PGN_DATA = $this->Common_model->Pagination($page_ary);
- $data['page'] = $start = $PGN_DATA['page'];
- $data['links'] = $PGN_DATA['links'];
- # END OF FILTER AND PAGINATION SECTION
- $data['FD'] = $FD;
- $data['CountryData'] = $this->Manage_model->select_view_country_org();
- $data['TypeData'] = $this->Manage_model->select_view_type();
- $data['OD'] = $this->Manage_model->view_organizations($FD,$start,$limit,'0');
- $this->CommonPage('organizations/view_organizations',$data,'View Organizations');
- }
- ############################################ END OF VIEW ORGANIZATIONS ############################
- ############################################ ORGANIZATION DETAILS #################################
- public function organizations_details_edit($organizations_id)
- {
- $this->load->view('include/preloader');
- if(isset($_POST['submit']))
- {
- $this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');
- $this->form_validation->set_rules('privilege_id','Privilege','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('country_id','Country','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('places_id','Place','trim|xss_clean|numeric');
- $this->form_validation->set_rules('organization_type_id','Type','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('name','Name','trim|required|xss_clean');
- $this->form_validation->set_rules('phone','Phone','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('email','Email','trim|required|xss_clean|valid_email');
- $this->form_validation->set_rules('location','Location','trim|xss_clean');
- $this->form_validation->set_rules('latitude','Location','trim|xss_clean');
- $this->form_validation->set_rules('longitude','Location','trim|xss_clean');
- $this->form_validation->set_rules('building_name','Building Name','trim|xss_clean');
- $this->form_validation->set_rules('building_number','Building Number','trim|xss_clean');
- $this->form_validation->set_rules('floor_number','Floor Number','trim|xss_clean');
- $this->form_validation->set_rules('office_number','Office Number','trim|xss_clean');
- $this->form_validation->set_rules('near_landmark','Near Landmark','trim|xss_clean');
- $this->form_validation->set_rules('cp_name','CP Name','trim|xss_clean');
- $this->form_validation->set_rules('cp_phone','CP Pphone','trim|xss_clean|numeric');
- $this->form_validation->set_rules('cp_email','CP Email','trim|xss_clean|valid_email');
- $this->form_validation->set_rules('cp_designation','CP Designation','trim|xss_clean');
- $this->form_validation->set_rules('organizations_id','Organizations ID','trim|xss_clean|numeric|required');
- if($this->form_validation->run())
- {
- $privilege_id = $this->input->post('privilege_id');
- $country_id = $this->input->post('country_id');
- $places_id = $this->input->post('places_id');
- $organization_type_id = $this->input->post('organization_type_id');
- $name = $this->input->post('name');
- $phone = $this->input->post('phone');
- $email = $this->input->post('email');
- $location = $this->input->post('location');
- $latitude = $this->input->post('latitude');
- $longitude = $this->input->post('longitude');
- $building_name = $this->input->post('building_name');
- $building_number = $this->input->post('building_number');
- $floor_number = $this->input->post('floor_number');
- $office_number = $this->input->post('office_number');
- $near_landmark = $this->input->post('near_landmark');
- $cp_name = $this->input->post('cp_name');
- $cp_phone = $this->input->post('cp_phone');
- $cp_email = $this->input->post('cp_email');
- $cp_designation = $this->input->post('cp_designation');
- $organizations_id = $this->input->post('organizations_id');
- $submit = $this->input->post('submit');
- $values = array('datetime'=>date('Y-m-d H:i:s'),
- 'privilege_id'=>$privilege_id,
- 'country_id'=>$country_id,
- 'places_id'=>$places_id,
- 'organization_type_id'=>$organization_type_id,
- 'name'=>ucwords($name),
- 'phone'=>$phone,
- 'email'=>strtolower($email),
- 'location'=>$location,
- 'latitude'=>$latitude,
- 'longitude'=>$longitude,
- 'building_name'=>$building_name,
- 'building_number'=>$building_number,
- 'floor_number'=>$floor_number,
- 'office_number'=>$office_number,
- 'near_landmark'=>$near_landmark,
- 'cp_name'=>ucwords($cp_name),
- 'cp_phone'=>$cp_phone,
- 'cp_email'=>strtolower($cp_email),
- 'cp_designation'=>$cp_designation);
- $user_values = array('username'=>strtolower($email),'name'=>ucwords($name),'privilege_id'=>$privilege_id);
- if($this->session->userdata('logged_in')['privilege_id']==4)
- {
- unset($values['email']);
- unset($user_values['username']);
- unset($user_values['privilege_id']);
- }
- elseif($this->session->userdata('logged_in')['privilege_id']==5)
- {
- unset($values['email']);
- unset($user_values['username']);
- unset($user_values['privilege_id']);
- }
- if(isset($_FILES['image']) && $_FILES['image']['name']!='')
- {
- $image_name = $this->Common_model->image_upload('./uploads/organizations/','image');
- if($image_name!='')
- {
- $values['image'] = $image_name;
- }
- $image_name = $this->Common_model->image_upload('./uploads/users/','image');
- if($image_name!='')
- {
- $user_values['image'] = $image_name;
- }
- }
- $EXIST = $this->Manage_model->check_organizations_email_exist($email,$organizations_id);
- if(empty($EXIST))
- {
- if($submit=='Update')
- {
- $where = array('organizations_id'=>$organizations_id);
- $this->Common_model->common_update('organizations',$values,$where);
- $this->Common_model->Set_Message('1',"Organization details updated successfully.");
- // Activity Log Record
- $head = 'Update Organization';
- $description = 'Organization Details Has Been Updated By ';
- $this->Common_model->create_activity_log($head,$description,'',array(),array('organizations_id'=>$organizations_id),'3');
- // Activity Log Record
- $where = array('table_id'=>$organizations_id);
- $this->Common_model->common_update('users',$user_values,$where);
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- }
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Organization email already exist.');
- }
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- }
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- }
- if($this->session->userdata('logged_in')['privilege_id']==4)
- {
- redirect('profile');
- }
- elseif($this->session->userdata('logged_in')['privilege_id']==5)
- {
- redirect('profile');
- }
- else
- {
- redirect('organizations-details/'.$organizations_id.'/edit');
- }
- }
- ############################################ END OF ORGANIZATION DETAILS ##########################
- ############################################ ASSIGN SUBSCRIPTION PACKAGES #########################
- public function assign_subscription_packages($organizations_id)
- {
- $this->load->view('include/preloader');
- if(isset($_POST['AssignPackage']))
- {
- $this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');
- $this->form_validation->set_rules('organizations_id','organizations','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('subscription_packages_id','subscription package','trim|required|xss_clean|numeric');
- if($this->form_validation->run())
- {
- $organizations_id = $this->input->post('organizations_id');
- $subscription_packages_id = $this->input->post('subscription_packages_id');
- $EXIST = $this->Manage_model->check_organizations_package_exist($subscription_packages_id,$organizations_id);
- if(empty($EXIST))
- {
- $values = array('datetime'=>date('Y-m-d H:i:s'),'organizations_id'=>$organizations_id,'subscription_packages_id'=>$subscription_packages_id);
- $this->Common_model->common_insert('packages_dedicated',$values);
- $this->Common_model->Set_Message('1',"Organization package updated successfully.");
- // Activity Log Record
- $head = 'Assign Organization Package';
- $description = 'Organization Package Details Has Been Assignd By ';
- $this->Common_model->create_activity_log($head,$description,'',array(),array('organizations_id'=>$organizations_id),'3');
- // Activity Log Record
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Organization package already exist.');
- }
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- }
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- }
- redirect('organizations-details/'.$organizations_id.'/assigned-packages');
- }
- ############################################ END OF ASSIGN SUBSCRIPTION PACKAGES ##################
- ############################################ ORGANIZATION DETAILS #################################
- public function organizations_details($organizations_id,$tab)
- {
- // set active tab details
- $data['Details'] = $data['Edit'] = $data['AssignedPackages'] = $data['Subscriptions'] = $data['FreePackages'] = '';
- if($tab=='details'){ $data['Details'] = 'show active'; }
- elseif($tab=='edit'){ $data['Edit'] = 'show active'; }
- elseif($tab=='assigned-packages'){ $data['AssignedPackages'] = 'show active'; }
- elseif($tab=='free-packages'){ $data['FreePackages'] = 'show active'; }
- elseif($tab=='subscriptions'){ $data['Subscriptions'] = 'show active'; }
- else{ $data['Details'] = 'show active'; }
- // set active tab details
- // remove package
- if(isset($_POST['delete']))
- {
- $this->form_validation->set_rules('delete_id','Delete ID','trim|xss_clean|required');
- if($this->form_validation->run())
- {
- $delete_id = $this->input->post('delete_id');
- $where = array('packages_dedicated_id'=>$delete_id);
- $value = array('packages_dedicated_status'=>'1');
- $this->Common_model->common_update('packages_dedicated',$value,$where);
- $this->Common_model->Set_Message('1','Package details removed successfully.');
- // Activity Log Record
- $head = 'Remove Package';
- $description = 'Package Details Has Been Removed By ';
- $this->Common_model->create_activity_log($head,$description,'',array(),array('packages_dedicated_id'=>$delete_id),'3');
- // Activity Log Record
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- }
- redirect(current_url());
- }
- // remove package
- $OD = $this->Manage_model->get_organization_details($organizations_id);
- if(empty($OD)){ redirect('organizations'); }
- $data['OD'] = $OD;
- $data['SD'] = $this->Manage_model->organizations_packages_history($organizations_id,'0','100','0');
- $data['SDFree'] = $this->Manage_model->organizations_packages_history_free($organizations_id,'0','100','0');
- $data['PackageData'] = $this->Manage_model->organizations_dedicated_packages_list($OD['country_id']);
- $data['PackageDataFree'] = $this->Manage_model->organizations_dedicated_packages_list_free($OD['country_id']);
- $data['DedicatedPackage'] = $this->Manage_model->organizations_dedicated_packages_data($organizations_id);
- $data['CountryData'] = $this->Manage_model->select_view_country_org();
- $data['TypeData'] = $this->Manage_model->select_view_type();
- $data['PlaceData'] = $this->Manage_model->select_view_places($OD['country_id']);
- // organizations_details
- $this->CommonPage('organizations/organizations_details',$data,$OD['name']);
- }
- ############################################ END OF ORGANIZATION DETAILS ##########################
- ############################################ VIEW MEMBERS #########################################
- public function get_members_data()
- {
- $Data['response'] = 'failed';
- $Data['result'] = array();
- $this->form_validation->set_rules('data_id','data_id','trim|required|xss_clean|numeric');
- if($this->form_validation->run())
- {
- $organizations_members_id = $this->input->post('data_id');
- $Result = $this->Manage_model->get_member_details($organizations_members_id);
- if(!empty($Result))
- {
- $Data['response'] = 'success';
- $Data['result'] = $Result;
- }
- }
- echo json_encode($Data);
- }
- public function view_members()
- {
- $organizations_id = $this->session->userdata('logged_in')['table_id'];
- $OD = $this->Manage_model->get_organization_data($organizations_id);
- # UPLOAD FILE IMPORT
- if(isset($_POST['UploadFile']))
- {
- if(isset($_FILES['import_file']) && $_FILES['import_file']['name']!='')
- {
- $FileName = $this->Common_model->excel_upload('./uploads/members_excel/','import_file');
- if($FileName!='')
- {
- $Result = $this->members_excel_import($FileName);
- if(!empty($Result))
- {
- $this->Common_model->Set_Message('1',"Members imported successfully. <strong>(Total Rows: ".$Result['Total'].", Imported Rows: ".$Result['Uploaded'].")</strong>");
- redirect(current_url());
- }
- }
- }
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- redirect(current_url());
- }
- # UPLOAD FILE IMPORT
- # INSERT / UPDATE FUNCTION
- if(isset($_POST['submit']))
- {
- $this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');
- $this->form_validation->set_rules('name','Name','trim|required|xss_clean');
- $this->form_validation->set_rules('phone','Phone','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('email','Email','trim|required|xss_clean|valid_email');
- if($this->session->userdata('logged_in')['privilege_id']=='4')
- {
- $this->form_validation->set_rules('designation','Designation','trim|required|xss_clean');
- }
- else
- {
- $this->form_validation->set_rules('designation','House Number','trim|required|xss_clean');
- }
- $this->form_validation->set_rules('verification_id','ID/Passport','trim|xss_clean');
- $this->form_validation->set_rules('meeting_privilege','Meeting Privilege','trim|xss_clean|numeric');
- if($this->form_validation->run())
- {
- $country_id = $OD['country_id'];
- $name = $this->input->post('name');
- $phone = $this->input->post('phone');
- $email = $this->input->post('email');
- $designation = $this->input->post('designation');
- $verification_id = $this->input->post('verification_id');
- $meeting_privilege = $this->input->post('meeting_privilege');
- $reporting_privilege = $this->input->post('reporting_privilege');
- $submit = $this->input->post('submit');
- if($OD['app_create_meeting_status']=='0')
- {
- $meeting_privilege = $reporting_privilege = '0';
- }
- $Image = '';
- $CheckTblMember = $this->Manage_model->check_member_is_exist($country_id,$phone);
- if(!empty($CheckTblMember))
- {
- $members_id = $CheckTblMember['members_id'];
- if($CheckTblMember['members_status']!=0)
- {
- $M_where = array('members_id'=>$members_id);
- $M_value = array('members_status'=>'0');
- $this->Common_model->common_update('members',$M_value,$M_where); // update status when the member is deleted
- }
- }
- else
- {
- if($this->input->post('submit')=='Save')
- {
- $values = array('datetime'=>date('Y-m-d H:i:s'),
- 'country_id'=>$country_id,
- 'name'=>ucwords($name),
- 'phone'=>$phone,
- 'email'=>strtolower($email),
- 'designation'=>$designation,
- 'verification_id'=>$verification_id);
- $members_id = $this->Common_model->common_insert('members',$values);
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- redirect(current_url());
- }
- }
- $values = array('organizations_members_status'=>'0',
- 'organizations_id'=>$organizations_id,
- 'members_id'=>$members_id,
- 'name'=>ucwords($name),
- 'email'=>strtolower($email),
- 'designation'=>$designation,
- 'verification_id'=>$verification_id,
- 'meeting_privilege'=>$meeting_privilege,
- 'reporting_privilege'=>$reporting_privilege);
- $CheckTblOrgMember = $this->Manage_model->organizations_members_exist($organizations_id,$members_id);
- if(!empty($CheckTblOrgMember))
- {
- if($this->input->post('submit')=='Update')
- {
- $where = array('organizations_id'=>$organizations_id,'members_id'=>$members_id,'organizations_members_id'=>$CheckTblOrgMember['organizations_members_id']);
- $this->Common_model->common_update('organizations_members',$values,$where);
- $this->Common_model->Set_Message('1',"Member Details Updated Successfully");
- // Activity Log Record
- $head = 'Update Member';
- $description = 'Member Details Has Been Updated By ';
- $this->Common_model->create_activity_log($head,$description,'',array(),array('members_id'=>$members_id),'4');
- // Activity Log Record
- }
- else
- {
- $this->Common_model->Set_Message('2',"<strong>Error!</strong> Member already exist.");
- }
- }
- else
- {
- $values['datetime'] = date('Y-m-d H:i:s');
- $this->Common_model->common_insert('organizations_members',$values);
- $this->Common_model->Set_Message('1',"New member added successfully.");
- // Activity Log Record
- $head = 'Add Member';
- $description = 'Member Details Has Been Added By ';
- $this->Common_model->create_activity_log($head,$description,'',array(),array('members_id'=>$members_id),'4');
- // Activity Log Record
- }
- redirect(current_url());
- }
- else
- {
- if($this->input->post('submit')=='Update')
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- redirect(current_url());
- }
- }
- }
- # END OF INSERT / UPDATE FUNCTION
- # DELETE FUNCTION
- if(isset($_POST['delete']))
- {
- $this->form_validation->set_rules('delete_id','Delete ID','trim|xss_clean|required');
- if($this->form_validation->run())
- {
- $delete_id = $this->input->post('delete_id');
- $where = array('organizations_members_id'=>$delete_id,'organizations_id'=>$organizations_id);
- $value = array('organizations_members_status'=>'1');
- $this->Common_model->common_update('organizations_members',$value,$where);
- $this->Common_model->Set_Message('1','Member details removed successfully.');
- // Activity Log Record
- $head = 'Remove Member';
- $description = 'Member Details Has Been Removed By ';
- $this->Common_model->create_activity_log($head,$description,'',array(),array('organizations_members_id'=>$delete_id),'4');
- // Activity Log Record
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- }
- redirect(current_url());
- }
- # END OF DELETE FUNCTION
- # FILTER AND PAGINATION SECTION
- $URL = $this->uri->segment(1);
- $param[] = array('key'=>'name','default'=>'');
- $param[] = array('key'=>'email','default'=>'');
- $param[] = array('key'=>'phone','default'=>'');
- $FD = $this->Common_model->common_filter($URL,$param);
- $start = $limit = '';
- $page_ary['url'] = base_url($URL);
- $page_ary['total_rows'] = $this->Manage_model->view_members($FD,$start,$limit,'1')[0]->count;
- $limit = $page_ary['per_page'] = 30;
- $PGN_DATA = $this->Common_model->Pagination($page_ary);
- $data['page'] = $start = $PGN_DATA['page'];
- $data['links'] = $PGN_DATA['links'];
- # END OF FILTER AND PAGINATION SECTION
- $data['OD'] = $OD;
- $data['FD'] = $FD;
- $data['MD'] = $this->Manage_model->view_members($FD,$start,$limit,'0');
- $this->CommonPage('organizations/view_members',$data,'List of members in your organization');
- }
- ############################################ END OF VIEW MEMBERS ##################################
- ############################################ VIEW COMPANY #########################################
- public function get_company_data()
- {
- $Data['response'] = 'failed';
- $Data['result'] = array();
- $this->form_validation->set_rules('data_id','data_id','trim|required|xss_clean|numeric');
- if($this->form_validation->run())
- {
- $data_id = $this->input->post('data_id');
- $select = array('company_id,name,phone,email,company_category_id');
- $where = array('company_id'=>$data_id);
- $Result = $this->Common_model->globalfetch('company',$select,$where);
- if(!empty($Result))
- {
- $Data['response'] = 'success';
- $Data['result'] = $Result;
- }
- }
- echo json_encode($Data);
- }
- public function view_company()
- {
- # UPLOAD FILE IMPORT
- if(isset($_POST['UploadFile']))
- {
- if(isset($_FILES['import_file']) && $_FILES['import_file']['name']!='')
- {
- $FileName = $this->Common_model->excel_upload('./uploads/members_excel/','import_file');
- if($FileName!='')
- {
- $Result = $this->company_excel_import($FileName);
- if(!empty($Result))
- {
- $this->Common_model->Set_Message('1',"Organization details imported successfully. <strong>(Total Rows: ".$Result['Total'].", Imported Rows: ".$Result['Uploaded'].")</strong>");
- redirect(current_url());
- }
- }
- }
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- redirect(current_url());
- }
- # UPLOAD FILE IMPORT
- # INSERT / UPDATE FUNCTION
- if(isset($_POST['submit']))
- {
- $this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');
- $this->form_validation->set_rules('company_category_id','Category ID','trim|required|xss_clean');
- $this->form_validation->set_rules('name','Name','trim|required|xss_clean');
- $this->form_validation->set_rules('phone','Phone','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('email','Email','trim|required|xss_clean|valid_email');
- if($this->input->post('submit')=='Save')
- {
- $this->form_validation->set_rules('company_id','Company ID','trim|xss_clean');
- }
- else
- {
- $this->form_validation->set_rules('company_id','Company ID','trim|xss_clean|numeric|required');
- }
- if($this->form_validation->run())
- {
- $organizations_id = $this->session->userdata('logged_in')['table_id'];
- $company_category_id = $this->input->post('company_category_id');
- $name = $this->input->post('name');
- $phone = $this->input->post('phone');
- $email = $this->input->post('email');
- $company_id = $this->input->post('company_id');
- $submit = $this->input->post('submit');
- $values = array('organizations_id'=>$organizations_id,
- 'company_category_id'=>$company_category_id,
- 'name'=>ucwords($name),
- 'phone'=>$phone,
- 'email'=>strtolower($email));
- if(isset($_FILES['image']) && $_FILES['image']['name']!='')
- {
- $image_name = $this->Common_model->image_upload('./uploads/company/','image');
- if($image_name!='')
- {
- $values['image'] = $image_name;
- }
- }
- if($submit=='Save')
- {
- $CheckComapy = $this->Manage_model->check_company_exist($organizations_id,$email);
- if(empty($CheckComapy))
- {
- $values['datetime'] = date('Y-m-d H:i:s');
- $company_id = $this->Common_model->common_insert('company',$values);
- $this->Common_model->Set_Message('1',"Company added successfully.");
- // Activity Log Record
- $head = 'Add Company';
- $description = 'Company Details Has Been Added By ';
- $this->Common_model->create_activity_log($head,$description,'',array(),array('company_id'=>$company_id),'5');
- // Activity Log Record
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Selected Email already exist.');
- }
- }
- else
- {
- $CheckComapyOwner = $this->Manage_model->check_company_owner_details($organizations_id,$company_id);
- if(!empty($CheckComapyOwner))
- {
- $where = array('company_id'=>$company_id);
- $this->Common_model->common_update('company',$values,$where);
- $this->Common_model->Set_Message('1',"Company details updated successfully.");
- // Activity Log Record
- $head = 'Update Company';
- $description = 'Company Details Has Been Updated By ';
- $this->Common_model->create_activity_log($head,$description,'',array(),array('company_id'=>$company_id),'5');
- // Activity Log Record
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- }
- }
- redirect(current_url());
- }
- else
- {
- if($this->input->post('submit')=='Update')
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- redirect(current_url());
- }
- }
- }
- # END OF INSERT / UPDATE FUNCTION
- # DELETE FUNCTION
- if(isset($_POST['delete']))
- {
- $this->form_validation->set_rules('delete_id','Delete ID','trim|xss_clean|required');
- if($this->form_validation->run())
- {
- $organizations_id = $this->session->userdata('logged_in')['table_id'];
- $delete_id = $this->input->post('delete_id');
- $CheckMembers = $this->Manage_model->check_company_members($organizations_id,$delete_id);
- if(empty($CheckMembers))
- {
- $where = array('company_id'=>$delete_id);
- $value = array('company_status'=>'1');
- $this->Common_model->common_update('company',$value,$where);
- $this->Common_model->Set_Message('1','Company details removed successfully.');
- // Activity Log Record
- $head = 'Remove Company';
- $description = 'Company Details Has Been Removed By ';
- $this->Common_model->create_activity_log($head,$description,'',array(),array('company_id'=>$delete_id),'5');
- // Activity Log Record
- }
- else
- {
- $this->Common_model->Set_Message('2',"<strong>Error!</strong> Company cannot be deleted.");
- }
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- }
- redirect(current_url());
- }
- # END OF DELETE FUNCTION
- # FILTER AND PAGINATION SECTION
- $URL = $this->uri->segment(1);
- $param[] = array('key'=>'name','default'=>'');
- $param[] = array('key'=>'company_category_id','default'=>'');
- $param[] = array('key'=>'phone','default'=>'');
- $FD = $this->Common_model->common_filter($URL,$param);
- $start = $limit = '';
- $page_ary['url'] = base_url($URL);
- $page_ary['total_rows'] = $this->Manage_model->view_company($FD,$start,$limit,'1')[0]->count;
- $limit = $page_ary['per_page'] = 30;
- $PGN_DATA = $this->Common_model->Pagination($page_ary);
- $data['page'] = $start = $PGN_DATA['page'];
- $data['links'] = $PGN_DATA['links'];
- # END OF FILTER AND PAGINATION SECTION
- $data['FD'] = $FD;
- $data['CD'] = $this->Manage_model->view_company($FD,$start,$limit,'0');
- $data['CL'] = $this->Manage_model->select_view_company_category();
- $this->CommonPage('organizations/view_company',$data,'List of registered organizations');
- }
- ############################################ END OF VIEW COMPANY ##################################
- ############################################ VIEW MEMBERS #########################################
- public function get_company_members_data()
- {
- $Data['response'] = 'failed';
- $Data['result'] = array();
- $this->form_validation->set_rules('data_id','data_id','trim|required|xss_clean|numeric');
- if($this->form_validation->run())
- {
- $company_members_id = $this->input->post('data_id');
- $Result = $this->Manage_model->get_company_member_details($company_members_id);
- if(!empty($Result))
- {
- $Data['response'] = 'success';
- $Data['result'] = $Result;
- }
- }
- echo json_encode($Data);
- }
- public function view_company_members()
- {
- $organizations_id = $this->session->userdata('logged_in')['table_id'];
- $OD = $this->Manage_model->get_organization_data($organizations_id);
- # UPLOAD FILE IMPORT
- if(isset($_POST['UploadFile']))
- {
- $this->form_validation->set_rules('company_id','Company','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('country_id','Country','trim|required|xss_clean|numeric');
- if($this->form_validation->run())
- {
- $company_id = $this->input->post('company_id');
- $country_id = $this->input->post('country_id');
- if(isset($_FILES['import_file']) && $_FILES['import_file']['name']!='')
- {
- $FileName = $this->Common_model->excel_upload('./uploads/members_excel/','import_file');
- if($FileName!='')
- {
- $Result = $this->company_members_excel_import($FileName,$company_id,$country_id);
- if(!empty($Result))
- {
- $this->Common_model->Set_Message('1',"Members imported successfully. <strong>(Total Rows: ".$Result['Total'].", Imported Rows: ".$Result['Uploaded'].")</strong>");
- redirect(current_url());
- }
- }
- }
- }
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- redirect(current_url());
- }
- # UPLOAD FILE IMPORT
- # INSERT / UPDATE FUNCTION
- if(isset($_POST['submit']))
- {
- $this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');
- $this->form_validation->set_rules('company_id','Company','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('company_members_id','CM ID','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('Ecompany_id','Company','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('country_id','Country','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('name','Name','trim|required|xss_clean');
- $this->form_validation->set_rules('phone','Phone','trim|required|xss_clean|numeric');
- $this->form_validation->set_rules('email','Email','trim|required|xss_clean|valid_email');
- $this->form_validation->set_rules('designation','Designation','trim|required|xss_clean');
- $this->form_validation->set_rules('verification_id','ID/Passport','trim|xss_clean');
- $country_id = $this->input->post('country_id');
- $CNTRYMOB = $this->Manage_model->get_country_details_row($country_id)['mobile_number_length'];
- $this->form_validation->set_rules('phone','Phone','trim|required|xss_clean|numeric|exact_length['.$CNTRYMOB.']');
- if($this->form_validation->run())
- {
- $company_members_id = $this->input->post('company_members_id');
- $company_id = $this->input->post('company_id');
- $Ecompany_id = $this->input->post('Ecompany_id');
- $name = $this->input->post('name');
- $phone = $this->input->post('phone');
- $email = $this->input->post('email');
- $designation = $this->input->post('designation');
- $verification_id = $this->input->post('verification_id');
- $submit = $this->input->post('submit');
- if($submit=='Save')
- {
- $CheckTblMember = $this->Manage_model->check_member_is_exist($country_id,$phone);
- if(!empty($CheckTblMember))
- {
- $members_id = $CheckTblMember['members_id'];
- if($CheckTblMember['members_status']!=0)
- {
- $M_where = array('members_id'=>$members_id);
- $M_value = array('members_status'=>'0');
- $this->Common_model->common_update('members',$M_value,$M_where); // update status when the member is deleted
- }
- }
- else
- {
- $values = array('datetime'=>date('Y-m-d H:i:s'),
- 'country_id'=>$country_id,
- 'name'=>ucwords($name),
- 'phone'=>$phone,
- 'email'=>strtolower($email),
- 'designation'=>$designation,
- 'verification_id'=>$verification_id);
- $members_id = $this->Common_model->common_insert('members',$values);
- }
- $values = array('company_members_status'=>'0',
- 'organizations_id'=>$organizations_id,
- 'company_id'=>$company_id,
- 'members_id'=>$members_id,
- 'name'=>ucwords($name),
- 'email'=>strtolower($email),
- 'designation'=>$designation,
- 'verification_id'=>$verification_id);
- $CheckTblCompanyMember = $this->Manage_model->company_members_exist($company_id,$members_id,$organizations_id);
- if(empty($CheckTblCompanyMember))
- {
- $values['datetime'] = date('Y-m-d H:i:s');
- $this->Common_model->common_insert('company_members',$values);
- $this->Common_model->Set_Message('1',"Member added successfully.");
- redirect(current_url());
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Mobile number already exist.');
- redirect(current_url());
- }
- }
- elseif($submit=='Update')
- {
- $CheckTblMember = $this->Manage_model->check_member_is_exist($country_id,$phone);
- if(!empty($CheckTblMember))
- {
- $members_id = $CheckTblMember['members_id'];
- if($CheckTblMember['members_status']!=0)
- {
- $M_where = array('members_id'=>$members_id);
- $M_value = array('members_status'=>'0');
- $this->Common_model->common_update('members',$M_value,$M_where); // update status when the member is deleted
- }
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- redirect(current_url());
- }
- $values = array('company_members_status'=>'0',
- 'organizations_id'=>$organizations_id,
- 'company_id'=>$company_id,
- 'members_id'=>$members_id,
- 'name'=>ucwords($name),
- 'email'=>strtolower($email),
- 'designation'=>$designation,
- 'verification_id'=>$verification_id);
- if($company_id!=$Ecompany_id)
- {
- $CheckTblCompanyMember = $this->Manage_model->company_members_exist($company_id,$members_id,$organizations_id);
- if(empty($CheckTblCompanyMember))
- {
- $where = array('company_members_id'=>$company_members_id,'members_id'=>$members_id);
- $this->Common_model->common_update('company_members',$values,$where);
- $this->Common_model->Set_Message('1',"<strong>SUCCESS!</strong> Member Details Updated Successfully");
- redirect(current_url());
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Member and organization already exist.');
- redirect(current_url());
- }
- }
- elseif($company_id==$Ecompany_id)
- {
- $where = array('company_members_id'=>$company_members_id,'members_id'=>$members_id);
- $this->Common_model->common_update('company_members',$values,$where);
- $this->Common_model->Set_Message('1',"<strong>SUCCESS!</strong> Member Details Updated Successfully");
- redirect(current_url());
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- redirect(current_url());
- }
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- redirect(current_url());
- }
- }
- else
- {
- if($this->input->post('submit')=='Update')
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- redirect(current_url());
- }
- }
- }
- # END OF INSERT / UPDATE FUNCTION
- # DELETE FUNCTION
- if(isset($_POST['delete']))
- {
- $this->form_validation->set_rules('delete_id','Delete ID','trim|xss_clean|required');
- if($this->form_validation->run())
- {
- $organizations_id = $this->session->userdata('logged_in')['table_id'];
- $delete_id = $this->input->post('delete_id');
- $where = array('company_members_id'=>$delete_id,'organizations_id'=>$organizations_id);
- $value = array('company_members_status'=>'1');
- $this->Common_model->common_update('company_members',$value,$where);
- $this->Common_model->Set_Message('1','Member Details Removed Successfully');
- // Activity Log Record
- $head = 'Remove Member';
- $description = 'Member Details Has Been Removed By ';
- $this->Common_model->create_activity_log($head,$description,'',array(),array('company_members_id'=>$delete_id),'4');
- // Activity Log Record
- }
- else
- {
- $this->Common_model->Set_Message('2','<strong>Error!</strong> Oops something went wrong. Please try again.');
- }
- redirect(current_url());
- }
- # END OF DELETE FUNCTION
- # FILTER AND PAGINATION SECTION
- $URL = $this->uri->segment(1);
- $param[] = array('key'=>'company_id','default'=>'');
- $param[] = array('key'=>'name','default'=>'');
- $param[] = array('key'=>'phone','default'=>'');
- $FD = $this->Common_model->common_filter($URL,$param);
- $start = $limit = '';
- $page_ary['url'] = base_url($URL);
- $page_ary['total_rows'] = $this->Manage_model->view_company_members($FD,$start,$limit,'1')[0]->count;
- $limit = $page_ary['per_page'] = 30;
- $PGN_DATA = $this->Common_model->Pagination($page_ary);
- $data['page'] = $start = $PGN_DATA['page'];
- $data['links'] = $PGN_DATA['links'];
- # END OF FILTER AND PAGINATION SECTION
- $data['FD'] = $FD;
- $data['OD'] = $OD;
- $data['CountryData'] = $this->Manage_model->select_view_country_member();
- $data['MD'] = $this->Manage_model->view_company_members($FD,$start,$limit,'0');
- $data['CL'] = $this->Manage_model->view_company_list();
- $this->CommonPage('organizations/view_company_members',$data,'List of members from other organizations');
- }
- ############################################ END OF VIEW MEMBERS ##################################
- ############################################ EDIT MEETINGS DETAILS ################################
- public function edit_meeting_details($meetings_id)
- {
- $organizations_id = $this->session->userdata('logged_in')['table_id'];
- $OD = $this->Manage_model->get_organization_details($organizations_id);
- $this->load->view('include/preloader');
- if(isset($_POST['UpdateMeetingDetails']))
- {
- $this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');
- $this->form_