PHP (Hypertext PreProcessor) - PHP is a server side scripting language designed primarily for web development. PHP code may be embedded into HTML, or it can be used in combination with various web template systems ,web content management systems and web frameworks.

What is PHP Online Sandbox?

The Online PHP Sandbox was created to help with debugging, testing and running your php code online. Also it allows developers to share their PHP code with the community. This tool works with a whitelist of functions. All functions that do require disk, system or network access are blacklisted, others whitelisted. Max execution time is set to 3 seconds. If you find a disabled function that should be whitelisted or if you run into other problems, please contact us. For echo output line break in the CLI mode, need to use PHP_EOL or \n Test your PHP code online without the need of a web server.

Can I run PHP program online?

Using our tool you can edit PHP code, and view the result in your browser. Just paste your PHP code to the textarea above and click to the button "Execute" and you will get result of executing PHP Online .

How to validate PHP syntax online?

With our tool you can paste your code into the PHP editor and it will immediately show syntax errors if any. Also, you can try to run your code online to find more hidden problems and bugs.

Why do you need to run PHP script online?

Very often, developers need to test some small logic, and it's faster to test it in our PHP compiler than to create a separate script and test it on their local server or on a remote server.

home PHP Script

<?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','Error! Oops something went wrong. Please try again.');

redirect($current_url);

}

$this->Common_model->Set_Message('2','Error! 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',"Success! 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',"Error! 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',"Error! 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','Error! Oops something went wrong. Please try again.');

}

redirect(current_url());

}

else

{

if($this->input->post('submit')=='Update')

{

$this->Common_model->Set_Message('2','Error! 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','Error! Oops something went wrong. Please try again.');

}

redirect(current_url());

}

// 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','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! 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','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Organization email already exist.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! 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','Error! Organization package already exist.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! 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','Error! 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. (Total Rows: ".$Result['Total'].", Imported Rows: ".$Result['Uploaded'].")");

redirect(current_url());

}

$this->Common_model->Set_Message('2','Error! 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','Error! 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',"Error! 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','Error! 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','Error! 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. (Total Rows: ".$Result['Total'].", Imported Rows: ".$Result['Uploaded'].")");

redirect(current_url());

}

$this->Common_model->Set_Message('2','Error! 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','Error! 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','Error! Oops something went wrong. Please try again.');

}

redirect(current_url());

}

else

{

if($this->input->post('submit')=='Update')

{

$this->Common_model->Set_Message('2','Error! 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',"Error! Company cannot be deleted.");

}

else

{

$this->Common_model->Set_Message('2','Error! 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. (Total Rows: ".$Result['Total'].", Imported Rows: ".$Result['Uploaded'].")");

redirect(current_url());

}

$this->Common_model->Set_Message('2','Error! 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','Error! 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','Error! 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',"SUCCESS! Member Details Updated Successfully");

redirect(current_url());

}

else

{

$this->Common_model->Set_Message('2','Error! 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',"SUCCESS! Member Details Updated Successfully");

redirect(current_url());

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

redirect(current_url());

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

redirect(current_url());

}

else

{

if($this->input->post('submit')=='Update')

{

$this->Common_model->Set_Message('2','Error! 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','Error! 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_validation->set_rules('meetings_id','Meeting','trim|required|xss_clean');

$this->form_validation->set_rules('meeting_title','Title','trim|required|xss_clean');

$this->form_validation->set_rules('date','Meeting Date','trim|required|xss_clean|exact_length[10]');

$this->form_validation->set_rules('time','Meeting Time','trim|required|xss_clean|exact_length[5]');

$this->form_validation->set_rules('end_time','Meeting End Time','trim|required|xss_clean|exact_length[5]');

// $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('address','Address','trim|required|xss_clean');

$this->form_validation->set_rules('car_pass','Car Pass','trim|required|xss_clean');

$this->form_validation->set_rules('participant_status','Member Visibility','trim|required|xss_clean');

$this->form_validation->set_rules('description','Description','trim|xss_clean');

$this->form_validation->set_rules('meeting_link','Link','trim|xss_clean|valid_url');

$this->form_validation->set_rules('admit_before','Admit Before','trim|required|numeric');

$this->form_validation->set_rules('admit_after','Admit After','trim|required|numeric');

if($OD['multiple_locations_status']=='1')

{

$this->form_validation->set_rules('organizations_address_id','Organizations Address ID','trim|required|numeric');

}

if($this->form_validation->run())

{

$meetings_id = $this->input->post('meetings_id');

$meeting_title = $this->input->post('meeting_title');

$date = $this->input->post('date');

$time = $this->input->post('time');

$end_time = $this->input->post('end_time');

// $location = $this->input->post('location');

// $latitude = $this->input->post('latitude');

// $longitude = $this->input->post('longitude');

// $address = $this->input->post('address');

$description = $this->input->post('description');

$meeting_link = $this->input->post('meeting_link');

$car_pass = $this->input->post('car_pass');

$participant_status = $this->input->post('participant_status');

$admit_before = $this->input->post('admit_before');

$admit_after = $this->input->post('admit_after');

$MD = $this->Manage_model->meeting_details($meetings_id);

if(empty($MD)){ redirect('view-meetings'); }

$date = $this->Common_model->date_format_changer($date);

$meeting_datetime = $date.' '.$time.':00';

$meeting_end_datetime = $date.' '.$end_time.':00';

$datetime = date('Y-m-d H:i:s');

$values = array('meeting_title'=>$meeting_title,

'meeting_datetime'=>$meeting_datetime,

'meeting_end_datetime'=>$meeting_end_datetime,

// 'location'=>$location,

// 'latitude'=>$latitude,

// 'longitude'=>$longitude,

// 'address'=>$address,

'description'=>$description,

'meeting_link'=>$meeting_link,

'car_pass'=>$car_pass,

'admit_before'=>$admit_before,

'admit_after'=>$admit_after);

// setup address data

if($OD['multiple_locations_status']=='1')

{

$organizations_address_id = $this->input->post('organizations_address_id');

if($organizations_address_id=='0') // address take from organization table

{

$address = array('Building Name: '.$OD['building_name'],'Building Number: '.$OD['building_number'],'Floor Number: '.$OD['floor_number'],'Unit Number: '.$OD['office_number'],'Near Landmark: '.$OD['near_landmark']);

$address = implode(', ', $address);

$values['organizations_address_id'] = '0';

$values['location'] = $OD['location'];

$values['latitude'] = $OD['latitude'];

$values['longitude'] = $OD['longitude'];

$values['address'] = $address;

}

elseif($organizations_address_id>'0') // address take from address table

{

$AddressData = $this->Manage_model->get_organization_contact_details($organizations_address_id,$organizations_id);

if(!empty($AddressData))

{

$address = array('Building Name: '.$AddressData['building_name'],'Building Number: '.$AddressData['building_number'],'Floor Number: '.$AddressData['floor_number'],'Unit Number: '.$AddressData['office_number'],'Near Landmark: '.$AddressData['near_landmark']);

$address = implode(', ', $address);

$values['organizations_address_id'] = $AddressData['organizations_address_id'];

$values['location'] = $AddressData['location'];

$values['latitude'] = $AddressData['latitude'];

$values['longitude'] = $AddressData['longitude'];

$values['address'] = $address;

}

// setup address data

if($MD['meeting_type']=='0')

{

$values['participant_status'] = $participant_status;

}

if($meeting_end_datetime>$datetime && $meeting_end_datetime>$meeting_datetime)

{

if($MD['status']<2)

{

if($MD['meeting_end_datetime']>$datetime)

{

// recheduled meeting notification

if($MD['meeting_datetime']!=$meeting_datetime && $meeting_end_datetime>$datetime && $meeting_end_datetime>$meeting_datetime)

{

$MeetingMembersList = $this->Manage_model->get_meeting_members($meetings_id);

foreach($MeetingMembersList as $DT1)

{

$members_id = $DT1->members_id;

$status = $DT1->status;

if($status==0)

{

// sent notification

if($MD['meeting_type']=='0') // meeting

{

$Content = array('title'=>'Meeting Rescheduled','description'=>'A Meeting has been rescheduled for some reasons.','message'=>'','meetings_id'=>$meetings_id);

}

else // event

{

$Content = array('title'=>'Event Rescheduled','description'=>'An Event has been rescheduled for some reasons.','message'=>'','meetings_id'=>$meetings_id);

}

$this->SentNotification('5',$members_id,$Content);

// sent notification

}

// recheduled meeting notification

$where = array('meetings_id'=>$meetings_id);

$this->Common_model->common_update('meetings',$values,$where);

$this->Common_model->Set_Message('1','Meeting details updated successfully.');

// Activity Log Record

$head = 'Update Meeting';

$description = 'Meeting Details Has Been Updated By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('meetings_id'=>$meetings_id),'6');

// Activity Log Record

}

else

{

$this->Common_model->Set_Message('2',"Error! Expired meeting details cannot be edited.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Please enter a valid date & time.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

redirect('meeting-details/'.$meetings_id.'/edit');

}

############################################ END OF EDIT MEETINGS DETAILS #########################

############################################ EDIT MEETINGS DETAILS ################################

public function save_meeting_mom($meetings_id)

{

$this->load->view('include/preloader');

if(isset($_POST['SaveMOM']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('mom','MOM','trim|xss_clean');

$this->form_validation->set_rules('meetings_id','meetings_id','trim|required|xss_clean');

if($this->form_validation->run())

{

$mom = $this->input->post('mom_info[]');

$meetings_id = $this->input->post('meetings_id');

$mom_summary = $this->input->post('mom_summary');

$members = $this->input->post('members_MOM[]');

$MD = $this->Manage_model->meeting_details($meetings_id);

if(empty($MD)){ redirect('view-meetings'); }

$datetime = date('Y-m-d H:i:s');

// $values_mom = array('mom'=>$mom);

$values['mom_summary'] = $mom_summary;

$values_mom=array();

for ($i=0; $i < count($mom); $i++) {

$values_mom["mominfo"][] = array(

'mom'=>$mom[$i],

'membersmom'=>$members[$i],

);

$prms=array("mom"=>json_encode($values_mom));

}

// MOM Signature Required Status

if(isset($_POST['SignatureRequired']) && $MD['meeting_type']=='0')

{

$values['mom_signature_status'] = '1';

}

else

{

$values['mom_signature_status'] = '0';

}

// MOM Signature Required Status

if($MD['status']<2)

{

if($MD['meeting_end_datetime']<$datetime)

{

$where = array('meetings_id'=>$meetings_id);

$this->Common_model->common_update('meetings',$values,$where);

$this->Common_model->common_update('meetings',$prms,$where);

if($MD['meeting_type']==0)

{

$this->Common_model->Set_Message('1','Minutes of Meeting updated.');

}

else

{

$this->Common_model->Set_Message('1','Event report updated.');

}

// MOM updated push notification - meeting notification

if(isset($_POST['NotifyMembers']))

{

$MeetingMembersList = $this->Manage_model->get_meeting_members($meetings_id);

foreach($MeetingMembersList as $DT1)

{

$members_id = $DT1->members_id;

$status = $DT1->status;

if($status==0)

{

// sent notification

if($MD['meeting_type']==0)

{

$Content = array('title'=>'MOM Updated','description'=>'The MOM has been updated.','message'=>'','meetings_id'=>$meetings_id);

}

else

{

$Content = array('title'=>'Event Report Updated','description'=>'The event report has been updated.','message'=>'','meetings_id'=>$meetings_id);

}

$this->SentNotification('5',$members_id,$Content);

// sent notification

}

// MOM updated push notification - meeting notification

// MOM updated Emal To company Email

if(isset($_POST['NotifyCompany']))

{

$OD = $this->Manage_model->get_organization_details($MD['organizations_id']);

$File = $this->generate_meeting_report($meetings_id); // creating Meeting Report PDF

$CompanyEmail = array();

$MeetingCompanyList = $this->Manage_model->get_meeting_members_company($meetings_id);

foreach($MeetingCompanyList as $DT1)

{

if(!in_array($DT1->email, $CompanyEmail))

{

$CompanyEmail[] = $DT1->email;

$data['Subject'] = 'MOM of '.$MD['meeting_title'].' by '.$OD['name'];

$data['File'] = $File;

$data['Content'] = 'Thank you for participating '.$MD['meeting_title'].' with '.$OD['name'].' on '.date('d-m-Y', strtotime($MD['meeting_datetime']));

$this->SentMail('12',$DT1->email,$data); // sent attached email

}

// for members

$MeetingMembersList = $this->Manage_model->get_meeting_members($meetings_id);

foreach($MeetingMembersList as $DT1)

{

$members_id = $DT1->members_id;

$status = $DT1->status;

if($status==0 && $DT1->email!='')

{

$data['Subject'] = 'MOM of '.$MD['meeting_title'].' by '.$OD['name'];

$data['File'] = $File;

$data['Content'] = 'Thank you for participating '.$MD['meeting_title'].' with '.$OD['name'].' on '.date('d-m-Y', strtotime($MD['meeting_datetime']));

$this->SentMail('12',$DT1->email,$data); // sent attached email

}

// MOM updated Emal To company Email

// Activity Log Record

$head = 'Update Meeting MOM';

$description = 'Meeting MOM Details Has Been Updated By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('meetings_id'=>$meetings_id),'6');

// Activity Log Record

}

else

{

if($MD['meeting_type']==0)

{

$this->Common_model->Set_Message('2',"Error! You cannot edit upcoming meeting minutes.");

}

else

{

$this->Common_model->Set_Message('2',"Error! You cannot edit upcoming event report.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

redirect('meeting-details/'.$meetings_id.'/mom');

}

############################################ END OF EDIT MEETINGS DETAILS #########################

############################################ ASSIGN MEETING MEMBERS DETAILS #######################

public function add_meeting_members($meetings_id)

{

$this->load->view('include/preloader');

if(isset($_POST['AssignMembers']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('meetings_id','Meeting','trim|required|xss_clean');

$this->form_validation->set_rules('member_type','Type','trim|required|xss_clean');

$this->form_validation->set_rules('MainCheckBox','Main Check Box','trim|required|xss_clean');

$this->form_validation->set_rules('members_id[]','Members','trim|required|xss_clean');

$this->form_validation->set_rules('company_id','Company','trim|required|xss_clean');

if($this->form_validation->run())

{

$meetings_id = $this->input->post('meetings_id');

$member_type = $this->input->post('member_type');

$company_id = $this->input->post('company_id');

$MembersArray = $this->input->post('members_id');

$MD = $this->Manage_model->meeting_details($meetings_id);

if(empty($MD)){ redirect('view-meetings'); }

$datetime = date('Y-m-d H:i:s');

if(count($MembersArray)>0)

{

if($MD['status']==1)

{

if($MD['meeting_end_datetime']>$datetime)

{

if($MD['meeting_type']==0) // meeting

{

$CountMeetingsMembers = $this->Manage_model->check_available_meetings_members_count();

}

else // event

{

$CountMeetingsMembers = $this->Manage_model->check_available_events_members_count();

}

$OD = $this->Manage_model->get_organization_details($MD['organizations_id']);

$CheckMembersLimit = $this->Manage_model->check_meetings_members_count($meetings_id);

$CheckMembersLimit = $CheckMembersLimit+count($MembersArray);

if($CheckMembersLimit<=$CountMeetingsMembers)

{

$i = 0;

foreach($MembersArray as $members_sub_id => $members_id)

{

$CheckMemberExist = $this->Manage_model->check_meetings_members_exist($meetings_id,$members_id,$member_type);

if(empty($CheckMemberExist))

{

$i++;

$values = array('datetime'=>$datetime,

'meetings_id'=>$meetings_id,

'members_sub_id'=>$members_sub_id,

'company_id'=>$company_id,

'members_id'=>$members_id,

'member_type'=>$member_type);

$meetings_participants_id = $this->Common_model->common_insert('meetings_participants',$values);

$TicketNumber = 'MPT'.sprintf("%05d", $meetings_participants_id);

$MD = $this->Manage_model->view_memeber_details($members_id);

$MD['country_code'] = str_replace('+', '', $MD['country_code']);

// sent notification

if($MD['meeting_type']=='0' && $MD['country_code']=="971" && $MD['fcm_token']=="")

{

$Content = array('title'=>'Meeting Invitation','description'=>'You are invited for a new meeting with '.$OD['name'].'. ','message'=>'You are invited to a new meeting by '.strtok($OD['name'], " ").'-'.$TicketNumber.'. Download Meet Pass for your meeting access (onelink.to/meet). Meet, Mingle & Merge in Person. OPT-OUT "AD-Events" to 7726','meetings_id'=>$meetings_id,'TicketNumber'=>$TicketNumber,'Organization'=>$OD['name'],'MeetingTitle'=>$MD['meeting_title']);

}elseif($MD['meeting_type']=='0')

{

$Content = array('title'=>'Meeting Invitation','description'=>'You are invited for a new meeting with '.$OD['name'].'. ','message'=>'You are invited to a new meeting by '.strtok($OD['name'], " ").'-'.$TicketNumber.'. Download Meet Pass for your meeting access (onelink.to/meet). Meet, Mingle & Merge in Person.','meetings_id'=>$meetings_id,'TicketNumber'=>$TicketNumber,'Organization'=>$OD['name'],'MeetingTitle'=>$MD['meeting_title']);

}

else

{

$Content = array('title'=>'Event Invitation','description'=>'You are invited for a new event with '.$OD['name'].'. ','message'=>'You are invited to a new evevt by '.strtok($OD['name'], " ").'-'.$TicketNumber.'. Download Meet Pass for your evevt access (onelink.to/meet). Meet, Mingle & Merge in Person.','meetings_id'=>$meetings_id,'TicketNumber'=>$TicketNumber,'Organization'=>$OD['name'],'MeetingTitle'=>$MD['meeting_title']);

}

if($MD['meeting_publish']=="1"){

$this->SentNotification('1',$members_id,$Content,$members_sub_id,$member_type);

// sent notification

// Activity Log Record

$head = 'Assign Meeting Members';

$description = 'Members Has Been Assigned By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('meetings_id'=>$meetings_id),'6');

// Activity Log Record

}

if($i==50){ break; }

}

if($i>0)

{

$this->Common_model->Set_Message('1',"".$i." Member added successfully.");

}

else

{

if($MD['meeting_type']==0) // meeting

{

$this->Common_model->Set_Message('2','Error! Selected members already exist for this meeting.');

}

else // event

{

$this->Common_model->Set_Message('2','Error! Selected members already exist for this event.');

}

else

{

if($MD['meeting_type']==0) // meeting

{

$this->Common_model->Set_Message('2','Error! You have exceeded maximum allowed meeting members '.$CountMeetingsMembers.'.');

}

else // event

{

$this->Common_model->Set_Message('2','Error! You have exceeded maximum allowed event members '.$CountMeetingsMembers.'.');

}

else

{

if($MD['meeting_type']==0) // meeting

{

$this->Common_model->Set_Message('2',"Error! Expired meeting details cannot be edited.");

}

else // event

{

$this->Common_model->Set_Message('2',"Error! Expired event details cannot be edited.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

$fmd= $this->Manage_model->get_Folloupmetting_data($meetings_id);

if(!empty($fmd)){

$meetings_id= $fmd["meetings_id"];

}

redirect('meeting-details/'.$meetings_id.'/members');

}

############################################ END OF ASSIGN MEETING MEMBERS DETAILS ################

############################################ REMOVE MEETING MEMBERS DETAILS #######################

public function remove_meeting_members($meetings_id)

{

$this->load->view('include/preloader');

if(isset($_POST['DeleteMember']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('delete_id','ID','trim|required|xss_clean');

$this->form_validation->set_rules('meetings_id','Meeting','trim|required|xss_clean');

$this->form_validation->set_rules('remark','Remark','trim|required|xss_clean');

if($this->form_validation->run())

{

$meetings_participants_id = $this->input->post('delete_id');

$meetings_id = $this->input->post('meetings_id');

$remark = $this->input->post('remark');

$MD = $this->Manage_model->meeting_details($meetings_id);

if(empty($MD)){ redirect('view-meetings'); }

$datetime = date('Y-m-d H:i:s');

if($MD['status']==1)

{

if($MD['meeting_end_datetime']>$datetime)

{

$where = array('meetings_participants_id'=>$meetings_participants_id);

$value = array('status'=>'2','cancelled_remark'=>$remark);

$this->Common_model->common_update('meetings_participants',$value,$where);

$this->Common_model->Set_Message('1','Member details removed successfully');

// sent notification

$members_id = $this->Manage_model->view_meetings_memeber_details($meetings_participants_id)['members_id'];

if($MD['meeting_type']=='0') // meeting

{

$Content = array('title'=>'Meeting Cancelled','description'=>'Unfortunately, the scheduled meeting has been cancelled due to some reason.','message'=>'','meetings_id'=>$meetings_id);

}

else // event

{

$Content = array('title'=>'Event Cancelled','description'=>'Unfortunately, the scheduled event has been cancelled due to some reason.','message'=>'','meetings_id'=>$meetings_id);

}

$this->SentNotification('4',$members_id,$Content);

// sent notification

// Activity Log Record

$head = 'Remove Meeting Members';

$description = 'Members Has Been Removed By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('meetings_id'=>$meetings_id,'meetings_participants_id'=>$meetings_participants_id),'6');

// Activity Log Record

}

else

{

$this->Common_model->Set_Message('2',"Error! Expired meeting details cannot be edited.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

redirect('meeting-details/'.$meetings_id.'/members');

}

############################################ END OF REMOVE MEETING MEMBERS DETAILS ################

############################################ REMOVE MEETING MEMBERS DETAILS #######################

/*public function remove_meeting_security($meetings_id)

{

$this->load->view('include/preloader');

if(isset($_POST['DeleteSecurity']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('delete_id','ID','trim|required|xss_clean');

$this->form_validation->set_rules('meetings_id','Meeting','trim|required|xss_clean');

if($this->form_validation->run())

{

$meetings_security_id = $this->input->post('delete_id');

$meetings_id = $this->input->post('meetings_id');

$MD = $this->Manage_model->meeting_details($meetings_id);

if(empty($MD)){ redirect('view-meetings'); }

$datetime = date('Y-m-d H:i:s');

if($MD['status']==1)

{

if($MD['meeting_datetime']>$datetime)

{

$where = array('meetings_security_id'=>$meetings_security_id);

$value = array('meetings_security_status'=>'1');

$this->Common_model->common_update('meetings_security',$value,$where);

$this->Common_model->Set_Message('1','Security Details Removed Successfully');

// Activity Log Record

$head = 'Remove Meeting Security';

$description = 'Security Has Been Removed By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('meetings_id'=>$meetings_id,'meetings_security_id'=>$meetings_security_id),'6');

// Activity Log Record

}

else

{

$this->Common_model->Set_Message('2',"Error! You Can't Edit Time Expired Meeting Details");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

redirect('meeting-details/'.$meetings_id.'/security');

}*/

############################################ END OF REMOVE MEETING MEMBERS DETAILS ################

############################################ CAR PASS #############################################

public function car_pass_meeting_members($meetings_id)

{

$this->load->view('include/preloader');

if(isset($_POST['AssignPass']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('meetings_participants_id','ID','trim|required|xss_clean');

$this->form_validation->set_rules('meetings_id','Meeting','trim|required|xss_clean');

$this->form_validation->set_rules('car_pass_remark','Remark','trim|required|xss_clean');

if($this->form_validation->run())

{

$meetings_participants_id = $this->input->post('meetings_participants_id');

$meetings_id = $this->input->post('meetings_id');

$car_pass_remark = $this->input->post('car_pass_remark');

$MD = $this->Manage_model->meeting_details($meetings_id);

if(empty($MD)){ redirect('view-meetings'); }

$datetime = date('Y-m-d H:i:s');

if($MD['status']==1)

{

if($MD['meeting_end_datetime']>$datetime)

{

$MMD = $this->Manage_model->get_meeting_members_details($meetings_id,$meetings_participants_id);

if(!empty($MMD) && $MMD['car_pass']!='2')

{

$where = array('meetings_participants_id'=>$meetings_participants_id);

$value = array('car_pass'=>'2','car_pass_remark'=>$car_pass_remark);

$this->Common_model->common_update('meetings_participants',$value,$where);

$this->Common_model->Set_Message('1','Car Pass Assigned Successfully');

// sent notification

$members_id = $this->Manage_model->view_meetings_memeber_details($meetings_participants_id)['members_id'];

$Content = array('title'=>'Car Pass','description'=>'The request for your car pass is approved.','message'=>'','meetings_id'=>$meetings_id);

$this->SentNotification('2',$members_id,$Content);

// sent notification

// Activity Log Record

$head = 'Assign Car Pass';

$description = 'Car Pass Has Been Assigned By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('meetings_id'=>$meetings_id,'meetings_participants_id'=>$meetings_participants_id),'6');

// Activity Log Record

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2',"Error! Expired meeting details cannot be edited.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

elseif(isset($_POST['RejectPass']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('meetings_participants_id','ID','trim|required|xss_clean');

$this->form_validation->set_rules('meetings_id','Meeting','trim|required|xss_clean');

$this->form_validation->set_rules('car_pass_remark','Remark','trim|required|xss_clean');

if($this->form_validation->run())

{

$meetings_participants_id = $this->input->post('meetings_participants_id');

$meetings_id = $this->input->post('meetings_id');

$car_pass_remark = $this->input->post('car_pass_remark');

$MD = $this->Manage_model->meeting_details($meetings_id);

if(empty($MD)){ redirect('view-meetings'); }

$datetime = date('Y-m-d H:i:s');

if($MD['status']==1)

{

if($MD['meeting_end_datetime']>$datetime)

{

$MMD = $this->Manage_model->get_meeting_members_details($meetings_id,$meetings_participants_id);

if(!empty($MMD) && $MMD['car_pass']<2)

{

$where = array('meetings_participants_id'=>$meetings_participants_id);

$value = array('car_pass'=>'3','car_pass_remark'=>$car_pass_remark);

$this->Common_model->common_update('meetings_participants',$value,$where);

$this->Common_model->Set_Message('1','Car pass rejected successfully.');

// sent notification

$members_id = $this->Manage_model->view_meetings_memeber_details($meetings_participants_id)['members_id'];

$Content = array('title'=>'Car Pass','description'=>'Sorry, car pass is not available at this moment.','message'=>'','meetings_id'=>$meetings_id);

$this->SentNotification('2',$members_id,$Content);

// sent notification

// Activity Log Record

$head = 'Reject Car Pass';

$description = 'Car Pass Has Been Rejected By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('meetings_id'=>$meetings_id,'meetings_participants_id'=>$meetings_participants_id),'6');

// Activity Log Record

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2',"Error! Expired meeting details cannot be edited.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

elseif(isset($_POST['DeletePass']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('meetings_participants_id','ID','trim|required|xss_clean');

$this->form_validation->set_rules('meetings_id','Meeting','trim|required|xss_clean');

if($this->form_validation->run())

{

$meetings_participants_id = $this->input->post('meetings_participants_id');

$meetings_id = $this->input->post('meetings_id');

$MD = $this->Manage_model->meeting_details($meetings_id);

if(empty($MD)){ redirect('view-meetings'); }

$datetime = date('Y-m-d H:i:s');

if($MD['status']==1)

{

if($MD['meeting_end_datetime']>$datetime)

{

$MMD = $this->Manage_model->get_meeting_members_details($meetings_id,$meetings_participants_id);

if(!empty($MMD) && $MMD['car_pass']=='2')

{

$where = array('meetings_participants_id'=>$meetings_participants_id);

$value = array('car_pass'=>'0','car_pass_remark'=>'');

$this->Common_model->common_update('meetings_participants',$value,$where);

$this->Common_model->Set_Message('1','Car pass deleted successfully.');

// sent notification

$members_id = $this->Manage_model->view_meetings_memeber_details($meetings_participants_id)['members_id'];

$Content = array('title'=>'Car Pass','description'=>'Unfortunately, the car pass has been cancelled due to some reason','message'=>'','meetings_id'=>$meetings_id);

$this->SentNotification('2',$members_id,$Content);

// sent notification

// Activity Log Record

$head = 'Delete Car Pass';

$description = 'Car Pass Has Been Deleted By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('meetings_id'=>$meetings_id,'meetings_participants_id'=>$meetings_participants_id),'6');

// Activity Log Record

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2',"Error! Expired meeting details cannot be edited.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

redirect('meeting-details/'.$meetings_id.'/members');

}

############################################ END OF CAR PASS ######################################

############################################ MARK ATTENDANCE ######################################

public function mark_attendance_meeting_members($meetings_id)

{

$this->load->view('include/preloader');

if(isset($_POST['AttendancePresent']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('meetings_participants_id','ID','trim|required|xss_clean');

$this->form_validation->set_rules('meetings_id','Meeting','trim|required|xss_clean');

if($this->form_validation->run())

{

$meetings_participants_id = $this->input->post('meetings_participants_id');

$meetings_id = $this->input->post('meetings_id');

$MD = $this->Manage_model->meeting_details($meetings_id);

if(empty($MD)){ redirect('view-meetings'); }

$datetime = date('Y-m-d H:i:s');

if($MD['status']==1)

{

if($MD['meeting_datetime']<$datetime)

{

$MMD = $this->Manage_model->get_meeting_members_details($meetings_id,$meetings_participants_id);

if(!empty($MMD) && $MMD['attendance']==0)

{

$where = array('meetings_participants_id'=>$meetings_participants_id);

$value = array('attendance'=>'1','attendance_datetime'=>$datetime);

$this->Common_model->common_update('meetings_participants',$value,$where);

$this->Common_model->Set_Message('1','Attendance marked!');

// Activity Log Record

$head = 'Attendance Marked';

$description = 'Attendance Marked By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('meetings_id'=>$meetings_id,'meetings_participants_id'=>$meetings_participants_id),'6');

// Activity Log Record

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2',"Error! Expired meeting details cannot be edited.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

elseif(isset($_POST['AttendanceAbsent']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('meetings_participants_id','ID','trim|required|xss_clean');

$this->form_validation->set_rules('meetings_id','Meeting','trim|required|xss_clean');

if($this->form_validation->run())

{

$meetings_participants_id = $this->input->post('meetings_participants_id');

$meetings_id = $this->input->post('meetings_id');

$MD = $this->Manage_model->meeting_details($meetings_id);

if(empty($MD)){ redirect('view-meetings'); }

$datetime = date('Y-m-d H:i:s');

if($MD['status']==1)

{

if($MD['meeting_datetime']<$datetime)

{

$MMD = $this->Manage_model->get_meeting_members_details($meetings_id,$meetings_participants_id);

if(!empty($MMD) && $MMD['attendance']==0)

{

$where = array('meetings_participants_id'=>$meetings_participants_id);

$value = array('attendance'=>'2');

$this->Common_model->common_update('meetings_participants',$value,$where);

$this->Common_model->Set_Message('1','Attendance marked!');

// Activity Log Record

$head = 'Attendance Marked';

$description = 'Attendance Marked By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('meetings_id'=>$meetings_id,'meetings_participants_id'=>$meetings_participants_id),'6');

// Activity Log Record

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2',"Error! Expired meeting details cannot be edited.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

redirect('meeting-details/'.$meetings_id.'/members');

}

############################################ END OF MARK ATTENDANCE ###############################

############################################ SIGNATURE ############################################

public function make_mom_signature_request($meetings_id)

{

$this->load->view('include/preloader');

if(isset($_POST['RequestSignature']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('meetings_participants_id','ID','trim|required|xss_clean');

$this->form_validation->set_rules('meetings_id','Meeting','trim|required|xss_clean');

if($this->form_validation->run())

{

$meetings_participants_id = $this->input->post('meetings_participants_id');

$meetings_id = $this->input->post('meetings_id');

$MD = $this->Manage_model->meeting_details($meetings_id);

if(empty($MD)){ redirect('view-meetings'); }

$datetime = date('Y-m-d H:i:s');

if($MD['status']==1 && $MD['mom_signature_status']=='1' && $MD['mom']!='')

{

if($MD['meeting_datetime']<$datetime)

{

$MMD = $this->Manage_model->get_meeting_members_details($meetings_id,$meetings_participants_id);

if(!empty($MMD) && $MMD['mom_signature_status']=='0')

{

$OD = $this->Manage_model->get_organization_details($MD['organizations_id']);

$where = array('meetings_participants_id'=>$meetings_participants_id);

$value = array('mom_signature_status'=>'1');

$this->Common_model->common_update('meetings_participants',$value,$where);

$this->Common_model->Set_Message('1','Signature requested ');

// sent notification

$Content = array('title'=>'Sign MOM','description'=>'Your signature required for '.$MD['meeting_title'].' MOM','message'=>'','meetings_id'=>$meetings_id,'TicketNumber'=>'','Organization'=>$OD['name'],'MeetingTitle'=>$MD['meeting_title']);

$this->SentNotification('6',$MMD['members_id'],$Content,$MMD['members_id'],'1');

// sent notification

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2',"Error! Expired meeting details cannot be edited.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

elseif(isset($_POST['RequestSignatureRemove']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('meetings_participants_id','ID','trim|required|xss_clean');

$this->form_validation->set_rules('meetings_id','Meeting','trim|required|xss_clean');

if($this->form_validation->run())

{

$meetings_participants_id = $this->input->post('meetings_participants_id');

$meetings_id = $this->input->post('meetings_id');

$MD = $this->Manage_model->meeting_details($meetings_id);

if(empty($MD)){ redirect('view-meetings'); }

$datetime = date('Y-m-d H:i:s');

if($MD['status']==1 && $MD['mom_signature_status']=='1' && $MD['mom']!='')

{

if($MD['meeting_datetime']<$datetime)

{

$MMD = $this->Manage_model->get_meeting_members_details($meetings_id,$meetings_participants_id);

if(!empty($MMD) && $MMD['mom_signature_status']=='1')

{

$where = array('meetings_participants_id'=>$meetings_participants_id);

$value = array('mom_signature_status'=>'0');

$this->Common_model->common_update('meetings_participants',$value,$where);

$this->Common_model->Set_Message('1','Signature request removed ');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2',"Error! Expired meeting details cannot be edited.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

redirect('meeting-details/'.$meetings_id.'/members');

}

############################################ END OF SIGNATURE #####################################

############################################ MEETINGS LINK DETAILS ################################

public function meeting_link_details($meetings_id)

{

$this->load->view('include/preloader');

# Generate Dedicated Link

if(isset($_POST['GenerateLink']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('meetings_id','Meeting ID','trim|required|xss_clean|numeric');

$this->form_validation->set_rules('registration_limit','Limit','trim|required|xss_clean|numeric');

if($this->form_validation->run())

{

$meetings_id = $this->input->post('meetings_id');

$registration_limit = $this->input->post('registration_limit');

$MD = $this->Manage_model->meeting_details($meetings_id);

if(empty($MD)){ redirect('view-meetings'); }

$datetime = date('Y-m-d H:i:s');

if($MD['status']==1)

{

if($MD['meeting_end_datetime']>$datetime)

{

$OD = $this->Manage_model->get_organization_details($MD['organizations_id']);

if($OD['dedicated_link_availability']=='1' && $MD['form_link']=='')

{

$LinkMax = 0;

if($MD['meeting_type']==0){ $LinkMax = $OD['members_count']; }else{ $LinkMax = $OD['events_members_count']; }

if($registration_limit>$LinkMax){ $registration_limit = $LinkMax; }

$values = array('form_link_status'=>'1','form_link'=>'','registration_limit'=>$registration_limit);

$where = array('organizations_id'=>$MD['organizations_id'],'meetings_id'=>$meetings_id);

$FormLink = '';

do {

$FormLink = $this->Common_model->GenerateRandomString();

$FormLinkStatus = $this->Manage_model->check_meeting_link_exist($FormLink);

}while (!empty($FormLinkStatus));

if($FormLink!='')

{

$values['form_link'] = $FormLink;

$this->Common_model->common_update('meetings',$values,$where);

$this->Common_model->Set_Message('1',"Link generated successfully.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2',"Error! Expired meeting details cannot be edited.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

# Turn Off Dedicated Link

if(isset($_POST['TurnOffLink']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('TurnOffLink','TurnOffLink','trim|required|xss_clean');

$this->form_validation->set_rules('meetings_id','Meeting ID','trim|required|xss_clean|numeric');

if($this->form_validation->run())

{

$meetings_id = $this->input->post('meetings_id');

$MD = $this->Manage_model->meeting_details($meetings_id);

if(empty($MD)){ redirect('view-meetings'); }

$datetime = date('Y-m-d H:i:s');

if($MD['status']==1)

{

if($MD['meeting_end_datetime']>$datetime)

{

$OD = $this->Manage_model->get_organization_details($MD['organizations_id']);

if($OD['dedicated_link_availability']=='1' && $MD['form_link']!='' && $MD['form_link_status']=='1')

{

$values = array('form_link_status'=>'0');

$where = array('organizations_id'=>$MD['organizations_id'],'meetings_id'=>$meetings_id);

$this->Common_model->common_update('meetings',$values,$where);

$this->Common_model->Set_Message('1',"Link disabled successfully.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2',"Error! Expired meeting details cannot be edited.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

# Turn On Dedicated Link

if(isset($_POST['TurnOnLink']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('TurnOnLink','TurnOnLink','trim|required|xss_clean');

$this->form_validation->set_rules('meetings_id','Meeting ID','trim|required|xss_clean|numeric');

$this->form_validation->set_rules('registration_limit','Limit','trim|required|xss_clean|numeric');

if($this->form_validation->run())

{

$meetings_id = $this->input->post('meetings_id');

$registration_limit = $this->input->post('registration_limit');

$MD = $this->Manage_model->meeting_details($meetings_id);

if(empty($MD)){ redirect('view-meetings'); }

$datetime = date('Y-m-d H:i:s');

if($MD['status']==1)

{

if($MD['meeting_end_datetime']>$datetime)

{

$OD = $this->Manage_model->get_organization_details($MD['organizations_id']);

if($OD['dedicated_link_availability']=='1' && $MD['form_link']!='' && $MD['form_link_status']=='0')

{

$LinkMax = 0;

if($MD['meeting_type']==0){ $LinkMax = $OD['members_count']; }else{ $LinkMax = $OD['events_members_count']; }

if($registration_limit>$LinkMax){ $registration_limit = $LinkMax; }

$values = array('form_link_status'=>'1','registration_limit'=>$registration_limit);

$where = array('organizations_id'=>$MD['organizations_id'],'meetings_id'=>$meetings_id);

$this->Common_model->common_update('meetings',$values,$where);

$this->Common_model->Set_Message('1',"Link enabled successfully.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2',"Error! Expired meeting details cannot be edited.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

redirect('meeting-details/'.$meetings_id.'/details');

}

############################################ END OF MEETINGS LINK DETAILS #########################

############################################ END MEETING ##########################################

public function end_meeting($meetings_id)

{

$this->load->view('include/preloader');

# Generate Dedicated Link

if(isset($_POST['EndMeeting']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('meetings_id','Meeting ID','trim|required|xss_clean|numeric');

if($this->form_validation->run())

{

$meetings_id = $this->input->post('meetings_id');

$MD = $this->Manage_model->meeting_details($meetings_id);

if(empty($MD)){ redirect('view-meetings'); }

$datetime = date('Y-m-d H:i:s');

if($MD['status']==1)

{

if($MD['meeting_end_datetime']>$datetime && $MD['meeting_datetime']<$datetime)

{

$datetime = date('Y-m-d H:i:s',strtotime('-1 min'));

$values = array('meeting_end_datetime'=>$datetime);

$where = array('organizations_id'=>$MD['organizations_id'],'meetings_id'=>$meetings_id);

$this->Common_model->common_update('meetings',$values,$where);

$this->Common_model->Set_Message('1',"Meeting end.");

}

else

{

$this->Common_model->Set_Message('2',"Error! Expired meeting details cannot be edited.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

redirect('meeting-details/'.$meetings_id.'/details');

}

############################################ END OF END MEETING ###################################

############################################ EXTEND MEETING #######################################

public function extend_meeting($meetings_id)

{

$this->load->view('include/preloader');

# Generate Dedicated Link

if(isset($_POST['ExtendMeeting']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('meetings_id','Meeting ID','trim|required|xss_clean|numeric');

$this->form_validation->set_rules('end_time','End Time','trim|required|xss_clean|exact_length[5]');

if($this->form_validation->run())

{

$meetings_id = $this->input->post('meetings_id');

$end_time = $this->input->post('end_time');

$MD = $this->Manage_model->meeting_details($meetings_id);

if(empty($MD)){ redirect('view-meetings'); }

$datetime = date('Y-m-d H:i:s');

if($MD['status']==1)

{

if($MD['meeting_end_datetime']>$datetime && $MD['meeting_datetime']<$datetime)

{

$meeting_end_datetime = date('Y-m-d',strtotime($MD['meeting_datetime'])).' '.$end_time.':00';

if($meeting_end_datetime>$MD['meeting_end_datetime'])

{

$values = array('meeting_end_datetime'=>$meeting_end_datetime);

$where = array('organizations_id'=>$MD['organizations_id'],'meetings_id'=>$meetings_id);

$this->Common_model->common_update('meetings',$values,$where);

$this->Common_model->Set_Message('1',"Meeting extended.");

}

else

{

$this->Common_model->Set_Message('2',"Error! Check extended time.");

}

else

{

$this->Common_model->Set_Message('2',"Error! Expired meeting details cannot be edited.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

redirect('meeting-details/'.$meetings_id.'/details');

}

############################################ END OF EXTEND MEETING ################################

############################################ MEETINGS DETAILS #####################################

public function meeting_details($meetings_id,$tab)

{

$MD = $this->Manage_model->meeting_details($meetings_id);

if($MD["flollow_up_status"]==1)

{

$meetings_id =$MD["flollow_up_id"];

redirect("meeting-details/".$meetings_id."/members");

}

$FMD = $this->Manage_model->meeting_details_flollwup($meetings_id);

$FMDLAST = $this->Manage_model->meeting_details_flollwupLAST($meetings_id);

$data["last_meeting"]=0;

if(!empty($FMDLAST))

{

$data["last_meeting"]=$FMDLAST["meetings_id"];

}

if(empty($MD)){ redirect('view-meetings'); }

// set active tab details

$data['BasicDetails'] = $data['EditDetails'] = $data['MeetingMembers'] = '';

$data['MeetingSecurity'] = $data['MOMDetails'] = $data['MeetingFeedback'] = '';

if($tab=='details'){ $data['BasicDetails'] = 'show active'; }

elseif($tab=='edit')

{

if($MD['status']<2 && $MD['meeting_end_datetime']>date('Y-m-d H:i:s'))

{

$data['EditDetails'] = 'show active';

}

else

{

$data['BasicDetails'] = 'show active';

}

elseif($tab=='members'){ $data['MeetingMembers'] = 'show active'; }

elseif($tab=='security'){ $data['MeetingSecurity'] = 'show active'; }

elseif($tab=='mom'){ $data['MOMDetails'] = 'show active'; }

else{ $data['BasicDetails'] = 'show active'; }

// set active tab details

$data['MD'] = $MD;

$data['FMD'] = $FMD;

$data['FMDLAST'] = $FMDLAST;

$data['OD'] = $this->Manage_model->get_organization_details($MD['organizations_id']);

$data['MeetingMembersList'] = $this->Manage_model->get_meeting_members($meetings_id);

$data['MFeedback'] = $this->Manage_model->get_meeting_members_feedback($meetings_id);

$data['CL'] = $this->Manage_model->view_company_list();

$data['AL'] = $this->Manage_model->view_address_list();

$data['OrgMembers'] = $this->Manage_model->view_members_select();

$this->CommonPage('meetings/meeting_details',$data,'Meeting Details');

}

############################################ END OF MEETINGS DETAILS ##############################

############################################ REGISTRATIONS ########################################

public function registrations()

{

#APPROVE ORG

if(isset($_POST['Approve']))

{

$this->form_validation->set_rules('organizations_registrations_id','ID','trim|required|xss_clean');

$this->form_validation->set_rules('remark','Remark','trim|required|xss_clean');

if($this->form_validation->run())

{

$organizations_registrations_id = $this->input->post('organizations_registrations_id');

$remark = $this->input->post('remark');

$RD = $this->Manage_model->view_organizations_registrations_details($organizations_registrations_id);

$ValidityDate = date('Y-m-d', strtotime('+14 days'));

$users_id = $this->session->userdata('logged_in')['users_id'];

$values = array('datetime'=>date('Y-m-d H:i:s'),

'privilege_id'=>'4',

'country_id'=>$RD['country_id'],

'places_id'=>'0',

'organization_type_id'=>'0',

'name'=>ucwords($RD['name']),

'phone'=>'',

'email'=>strtolower($RD['email']),

'location'=>'',

'latitude'=>'',

'longitude'=>'',

'building_name'=>'',

'building_number'=>'',

'floor_number'=>'',

'office_number'=>'',

'near_landmark'=>'',

'cp_name'=>ucwords($RD['cp_name']),

'cp_phone'=>$RD['phone'],

'cp_email'=>'',

'cp_designation'=>'',

'image'=>'',

'website'=>$RD['website'],

'organizations_registrations_id'=>$RD['organizations_registrations_id'],

'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,

'organizations_approved_status'=>1,

'organizations_approved_date'=>date('Y-m-d H:i:s'),

'organizations_approved_by'=>$users_id);

$CheckMail = $this->Manage_model->check_organizations_email_exist_new($RD['email']);

if(empty($CheckMail))

{

$organizations_id = $this->Common_model->common_insert('organizations',$values);

$password = rand(11111111,99999999);

$user_values = array('username'=>strtolower($RD['email']),

'password'=>MD5($password),

'name'=>ucwords($RD['name']),

'privilege_id'=>'4',

'table_id'=>$organizations_id,

'image'=>'');

$this->Common_model->common_insert('users',$user_values);

$value = array('status'=>'1','organizations_id'=>$organizations_id,'remarks'=>$remark);

$where = array('organizations_registrations_id'=>$organizations_registrations_id);

$this->Common_model->common_update('organizations_registrations',$value,$where);

// Activity Log Record

$head = 'Approve Organization';

$description = 'Organization Details Has Been Approved By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('organizations_id'=>$organizations_id),'3');

// Activity Log Record

// sent Mail - login credential

$data['LoginDetails'] = array('username'=>strtolower($RD['email']),'password'=>$password);

$this->SentMail('6',$RD['email'],$data);

// sent Mail - login credential

// sent Mail - trial period

$this->SentMail('7',$RD['email'],'');

// sent Mail - trial period

$this->Common_model->Set_Message('1',"Organization details approved successfully.");

redirect('organizations-details/'.$organizations_id.'/details');

}

else

{

$this->Common_model->Set_Message('2','Error! Email already exist.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

redirect(current_url());

}

#APPROVE ORG

if(isset($_POST['Reject']))

{

$this->form_validation->set_rules('organizations_registrations_id','ID','trim|required|xss_clean');

$this->form_validation->set_rules('remark','remark','trim|required|xss_clean');

if($this->form_validation->run())

{

$organizations_registrations_id = $this->input->post('organizations_registrations_id');

$remark = $this->input->post('remark');

$value = array('status'=>'2','remarks'=>$remark);

$where = array('organizations_registrations_id'=>$organizations_registrations_id);

$this->Common_model->common_update('organizations_registrations',$value,$where);

$this->Common_model->Set_Message('1','Registration details rejected.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

redirect(current_url());

}

#APPROVE ORG

# 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_registrations($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_registrations($FD,$start,$limit,'0');

$this->CommonPage('organizations/view_organizations_registrations',$data,'View Registrations');

}

public function Ajax_meeting_details($meetings_id)

{

$organizations_id = $this->session->userdata('logged_in')['table_id'];

$OD = $this->Manage_model->get_organization_details($organizations_id);

$MD = $this->Manage_model->meeting_details($_POST["data_id"]);

$MD["response"][]="success";

echo json_encode($MD);

exit;

}

############################################ END OF REGISTRATIONS #################################

############################################ ORGANIZATION DETAILS #################################

public function profile($tab='')

{

$organizations_id = $this->session->userdata('logged_in')['table_id'];

$OD = $this->Manage_model->get_organization_details($organizations_id);

if(empty($OD)){ redirect('dashboard'); }

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','Landline','trim|required|xss_clean|numeric');

$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|xss_clean');

$this->form_validation->set_rules('floor_number','Floor Number','trim|xss_clean');

$this->form_validation->set_rules('office_number','Unit Number','trim|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');

$this->form_validation->set_rules('organizations_id','Organizations ID','trim|xss_clean|numeric|required');

if($this->form_validation->run())

{

$name = $this->input->post('name');

$phone = $this->input->post('phone');

$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');

$organizations_id = $OD['organizations_id'];

$submit = $this->input->post('submit');

$values = array('name'=>ucwords($name),

'phone'=>$phone,

'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('name'=>ucwords($name),'first_login_status'=>'2');

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;

}

$where = array('organizations_id'=>$organizations_id);

$this->Common_model->common_update('organizations',$values,$where);

$this->Common_model->Set_Message('1',"Profile updated successfully.");

// update session data

$user_data = $this->session->userdata('logged_in');

$sess_data = $user_data;

$sess_data['first_login_status'] = '2';

$this->session->set_userdata('logged_in', $sess_data);

// update session data

// Activity Log Record

$head = 'Update Profile';

$description = 'Profile 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','Error! Oops something went wrong. Please try again.');

}

redirect(current_url());

}

# Generate Dedicated Link

if(isset($_POST['GenerateLink']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('NationalID','National ID','trim|required|xss_clean|numeric|exact_length[1]');

if($this->form_validation->run())

{

$NationalID = $this->input->post('NationalID');

if($OD['dedicated_link_availability']=='1' && $OD['form_link']=='')

{

$values = array('form_status'=>'1','form_link'=>'','reqiured_id'=>$NationalID);

$where = array('organizations_id'=>$organizations_id);

$FormLink = '';

do {

$FormLink = $this->Common_model->GenerateRandomString();

$FormLinkStatus = $this->Manage_model->check_dedicated_link_exist($FormLink);

}while (!empty($FormLinkStatus));

if($FormLink!='')

{

$values['form_link'] = $FormLink;

$this->Common_model->common_update('organizations',$values,$where);

// reset session

$user_data = $this->session->userdata('logged_in');

$sess_data = $user_data;

$sess_data['DLA'] = '1';

$this->session->set_userdata('logged_in', $sess_data);

// reset session

$this->Common_model->Set_Message('1',"Link generated successfully");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

redirect(current_url());

}

# Turn Off Dedicated Link

if(isset($_POST['TurnOffLink']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('TurnOffLink','TurnOffLink','trim|required|xss_clean');

if($this->form_validation->run())

{

if($OD['dedicated_link_availability']=='1' && $OD['form_link']!='' && $OD['form_status']=='1')

{

$values = array('form_status'=>'0');

$where = array('organizations_id'=>$organizations_id);

$this->Common_model->common_update('organizations',$values,$where);

$this->Common_model->Set_Message('1',"Link disabled successfully.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

redirect(current_url());

}

# Turn On Dedicated Link

if(isset($_POST['TurnOnLink']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('TurnOnLink','TurnOnLink','trim|required|xss_clean');

$this->form_validation->set_rules('NationalID','National ID','trim|required|xss_clean|numeric|exact_length[1]');

if($this->form_validation->run())

{

if($OD['dedicated_link_availability']=='1' && $OD['form_link']!='' && $OD['form_status']=='0')

{

$NationalID = $this->input->post('NationalID');

$values = array('form_status'=>'1','reqiured_id'=>$NationalID);

$where = array('organizations_id'=>$organizations_id);

$this->Common_model->common_update('organizations',$values,$where);

$this->Common_model->Set_Message('1',"Link enabled successfully.");

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

redirect(current_url());

}

$data['OD'] = $OD;

$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/profile',$data,$OD['name']);

}

############################################ END OF ORGANIZATION DETAILS ##########################

############################################ MEMBERS EXCEL IMPORT #################################

public function members_excel_import($file_name='')

{

$this->load->model('Excel_model');

$organizations_id = $this->session->userdata('logged_in')['table_id'];

$OD = $this->Manage_model->get_organization_details($organizations_id);

if(!empty($OD))

{

$country_id = $OD['country_id'];

$mobile_number_length = $OD['mobile_number_length'];

if($file_name!='')

{

$file = FCPATH.'uploads/members_excel/'.$file_name;

if(file_exists($file))

{

$E_data = $this->Excel_model->read_excel_file($file);

if(!empty($E_data))

{

$values = array();

$i = $j = 0;

foreach($E_data as $ED1)

{

$i++;

if($i>1)

{

if($ED1['B']!='' && $ED1['C']!='' && strlen($ED1['C'])==$mobile_number_length && is_numeric($ED1['C']) && $ED1['D']!='')

{

$name = ucwords($ED1['B']);

$phone = $ED1['C'];

$email = strtolower($ED1['D']);

$designation = ucwords($ED1['E']);

$verification_id = strtoupper($ED1['F']);

$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('organizations_members_status'=>'0',

'organizations_id'=>$organizations_id,

'members_id'=>$members_id,

'name'=>ucwords($name),

'email'=>strtolower($email),

'designation'=>$designation,

'verification_id'=>$verification_id);

$CheckTblOrgMember = $this->Manage_model->organizations_members_exist($organizations_id,$members_id);

if(empty($CheckTblOrgMember))

{

$j++;

$values['datetime'] = date('Y-m-d H:i:s');

$this->Common_model->common_insert('organizations_members',$values);

// Activity Log Record

$head = 'Add Member (Excel)';

$description = 'Member (Excel) Details Has Been Added By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('members_id'=>$members_id),'4');

// Activity Log Record

}

if($i == 251){ break; }

}

return array('Total'=>$i-1,'Uploaded'=>$j);

}

return array();

}

############################################ END OF MEMBERS EXCEL IMPORT ##########################

############################################ COMAPNY EXCEL IMPORT #################################

public function company_excel_import($file_name='')

{

$this->load->model('Excel_model');

$organizations_id = $this->session->userdata('logged_in')['table_id'];

$OD = $this->Manage_model->get_organization_details($organizations_id);

$mobile_number_length = $OD['mobile_number_length'];

if(!empty($OD))

{

if($file_name!='')

{

$file = FCPATH.'uploads/members_excel/'.$file_name;

if(file_exists($file))

{

$E_data = $this->Excel_model->read_excel_file($file);

if(!empty($E_data))

{

$values = array();

$i = $j = 0;

foreach($E_data as $ED1)

{

$i++;

if($i>1)

{

if($ED1['B']!='' && $ED1['C']!='' && strlen($ED1['C'])==$mobile_number_length && is_numeric($ED1['C']) && $ED1['D']!='')

{

$name = ucwords($ED1['B']);

$phone = $ED1['C'];

$email = strtolower($ED1['D']);

$values = array('organizations_id'=>$organizations_id,

'company_category_id'=>'1',

'name'=>ucwords($name),

'phone'=>$phone,

'email'=>strtolower($email));

$CheckComapy = $this->Manage_model->check_company_exist($organizations_id,$email);

if(empty($CheckComapy))

{

$j++;

$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 (Excel Import)';

$description = 'Company Details Has Been Added By (Excel Import) ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('company_id'=>$company_id),'5');

// Activity Log Record

}

if($i == 251){ break; }

}

return array('Total'=>$i-1,'Uploaded'=>$j);

}

return array();

}

############################################ END OF COMAPNY EXCEL IMPORT ##########################

############################################ COMPANY MEMBERS EXCEL IMPORT #########################

public function company_members_excel_import($file_name='',$company_id='',$country_id='')

{

$this->load->model('Excel_model');

$organizations_id = $this->session->userdata('logged_in')['table_id'];

$OD = $this->Manage_model->get_organization_details($organizations_id);

if(!empty($OD))

{

if($file_name!='' && $company_id!='' && $country_id!='')

{

$mobile_number_length = $this->Manage_model->get_country_details_row($country_id)['mobile_number_length'];

$file = FCPATH.'uploads/members_excel/'.$file_name;

if(file_exists($file))

{

$E_data = $this->Excel_model->read_excel_file($file);

if(!empty($E_data))

{

$values = array();

$i = $j = 0;

foreach($E_data as $ED1)

{

$i++;

if($i>1)

{

if($ED1['B']!='' && $ED1['C']!='' && strlen($ED1['C'])==$mobile_number_length && is_numeric($ED1['C']) && $ED1['D']!='' && $ED1['E']!='')

{

$name = ucwords($ED1['B']);

$phone = $ED1['C'];

$email = strtolower($ED1['D']);

$designation = ucwords($ED1['E']);

$verification_id = strtoupper($ED1['F']);

$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))

{

$j++;

$values['datetime'] = date('Y-m-d H:i:s');

$this->Common_model->common_insert('company_members',$values);

// Activity Log Record

$head = 'Add Member (Excel)';

$description = 'Member (Excel) Details Has Been Added By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('members_id'=>$members_id),'4');

// Activity Log Record

}

if($i == 251){ break; }

}

return array('Total'=>$i-1,'Uploaded'=>$j);

}

return array();

}

############################################ END OF COMPANY MEMBERS EXCEL IMPORT ##################

############################################ MESSAGES #############################################

public function enquiry()

{

# FILTER AND PAGINATION SECTION

$URL = $this->uri->segment(1);

$param[] = array('key'=>'email','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_enquiry($FD,$start,$limit,'1')[0]->count;

$limit = $page_ary['per_page'] = 50;

$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['enquiry'] = $this->Manage_model->view_enquiry($FD,$start,$limit,'0');

$this->CommonPage('manage/enquiry',$data,'View Messages');

}

############################################ END OF MESSAGES ######################################

############################################ LINK REQUESTS ########################################

public function get_link_requests_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())

{

$link_requests_id = $this->input->post('data_id');

$Result = $this->Manage_model->get_link_requests_data($link_requests_id);

if(!empty($Result))

{

$Data['response'] = 'success';

$Data['result'] = $Result;

}

echo json_encode($Data);

}

public function link_requests($LinkStatus='0')

{

$organizations_id = $this->session->userdata('logged_in')['table_id'];

$OD = $this->Manage_model->get_organization_details($organizations_id);

# Create New Quick Meeting

if(isset($_POST['CreateRequestQuickMeeting']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('RQ_member_name','Name','trim|required|xss_clean');

$this->form_validation->set_rules('RQ_member_mobile','Mobile','trim|required|xss_clean');

$this->form_validation->set_rules('RQ_meeting_title','Title','trim|required|xss_clean');

$this->form_validation->set_rules('RQ_date','Date','trim|required|xss_clean|exact_length[10]');

$this->form_validation->set_rules('RQ_time','Time','trim|required|xss_clean|exact_length[5]');

$this->form_validation->set_rules('RQ_end_time','End Time','trim|required|xss_clean|exact_length[5]');

$this->form_validation->set_rules('RQ_link_requests_id','ID','trim|required|xss_clean|numeric');

$this->form_validation->set_rules('RQ_request_status','Status','trim|xss_clean');

if($OD['multiple_locations_status']=='1')

{

$this->form_validation->set_rules('organizations_address_id','Organizations Address ID','trim|required|numeric');

}

if($this->form_validation->run())

{

if(!empty($OD))

{

if(date('Y-m-d')>$OD['packge_validity_upto'])

{

$this->Common_model->Set_Message('2','Error! Your current package is expired. please upgrade to continue to access Meet Pass');

redirect(current_url());

}

$CountAvailableMeetings = $this->Manage_model->check_available_meetings_count();

$CountMeetingsMembers = $this->Manage_model->check_available_meetings_members_count();

if($CountAvailableMeetings>0 && $CountMeetingsMembers>1)

{

$link_requests_id = $this->input->post('RQ_link_requests_id');

$LRD = $this->Manage_model->get_link_requests_data($link_requests_id);

if(!empty($LRD))

{

$location = $OD['location'];

$latitude = $OD['latitude'];

$longitude = $OD['longitude'];

$country_id = $OD['country_id'];

if($location!='' && $latitude!='' && $longitude!='')

{

$address = array('Building Name: '.$OD['building_name'],'Building Number: '.$OD['building_number'],'Floor Number: '.$OD['floor_number'],'Unit Number: '.$OD['office_number'],'Near Landmark: '.$OD['near_landmark']);

$address = implode(', ', $address);

$member_name = $LRD['name'];

$member_mobile = $LRD['mobile'];

$member_email = $LRD['email'];

$member_national_id = $LRD['national_id'];

$national_id_expiry_date = $LRD['national_id_expiry_date'];

$meeting_title = $this->input->post('RQ_meeting_title');

$date = $this->input->post('RQ_date');

$time = $this->input->post('RQ_time');

$end_time = $this->input->post('RQ_end_time');

$request_status = $this->input->post('RQ_request_status');

$description = $meeting_link = '';

$meeting_type = $car_pass = '0';

$date = $this->Common_model->date_format_changer($date);

$meeting_datetime = $date.' '.$time.':00';

$meeting_end_datetime = $date.' '.$end_time.':00';

$datetime = date('Y-m-d H:i:s');

$values = array('datetime'=>$datetime,

'organizations_id'=>$organizations_id,

'meeting_type'=>$meeting_type,

'meeting_title'=>$meeting_title,

'meeting_datetime'=>$meeting_datetime,

'meeting_end_datetime'=>$meeting_end_datetime,

'location'=>$location,

'latitude'=>$latitude,

'longitude'=>$longitude,

'address'=>$address,

'description'=>$description,

'meeting_link'=>$meeting_link,

'car_pass'=>$car_pass,

'admit_before'=>'1',

'admit_after'=>'2',

'status'=>'1',

'link_requests_id'=>$link_requests_id);

// setup address data

if($OD['multiple_locations_status']=='1')

{

$organizations_address_id = $this->input->post('organizations_address_id');

if($organizations_address_id=='0') // address take from organization table

{

$address = array('Building Name: '.$OD['building_name'],'Building Number: '.$OD['building_number'],'Floor Number: '.$OD['floor_number'],'Unit Number: '.$OD['office_number'],'Near Landmark: '.$OD['near_landmark']);

$address = implode(', ', $address);

$values['organizations_address_id'] = '0';

$values['location'] = $OD['location'];

$values['latitude'] = $OD['latitude'];

$values['longitude'] = $OD['longitude'];

$values['address'] = $address;

}

elseif($organizations_address_id>'0') // address take from address table

{

$AddressData = $this->Manage_model->get_organization_contact_details($organizations_address_id,$organizations_id);

if(!empty($AddressData))

{

$address = array('Building Name: '.$AddressData['building_name'],'Building Number: '.$AddressData['building_number'],'Floor Number: '.$AddressData['floor_number'],'Unit Number: '.$AddressData['office_number'],'Near Landmark: '.$AddressData['near_landmark']);

$address = implode(', ', $address);

$values['organizations_address_id'] = $AddressData['organizations_address_id'];

$values['location'] = $AddressData['location'];

$values['latitude'] = $AddressData['latitude'];

$values['longitude'] = $AddressData['longitude'];

$values['address'] = $address;

}

// setup address data

if($meeting_datetime>$datetime && $meeting_end_datetime>$meeting_datetime)

{

$CheckMeeting = array();

if($request_status!='1')

{

$CheckMeeting = $this->Manage_model->check_meetings_available_org($organizations_id,$meeting_datetime,$meeting_end_datetime);

}

if(empty($CheckMeeting)) // checking meeting scheduled or not

{

// checking meeting duplication

$NextTime = date('Y-m-d H:i:s', strtotime('-30 seconds'));

$CheckMeetingDuplication = $this->Manage_model->check_meeting_duplication($organizations_id,$NextTime,$datetime,$meeting_datetime,$meeting_end_datetime);

if(!empty($CheckMeetingDuplication))

{

redirect(current_url());

}

// checking meeting duplication

$meetings_id = $this->Common_model->common_insert('meetings',$values);

// update meetings count

$value = array('meetings_count'=>$CountAvailableMeetings-1);

$where = array('organizations_id'=>$organizations_id);

$this->Common_model->common_update('organizations',$value,$where);

// update meetings count

// Activity Log Record

$head = 'Create Meeting (Quick-Link)';

$description = 'New Meeting (Quick-Link) Has Been Created By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('meetings_id'=>$meetings_id),'6');

// Activity Log Record

// checking table members

$CheckTblMember = $this->Manage_model->check_member_is_exist($country_id,$member_mobile);

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($member_name),'phone'=>$member_mobile,'email'=>$member_email,'verification_id'=>$member_national_id,'national_id_expiry_date'=>$national_id_expiry_date);

$members_id = $this->Common_model->common_insert('members',$values);

}

// checking table members

$values = array('company_members_status'=>'0','organizations_id'=>$organizations_id,'company_id'=>'0','members_id'=>$members_id,'name'=>ucwords($member_name),'email'=>$member_email,'verification_id'=>$member_national_id);

// checking table company_members

$CheckTblCompanyMember = $this->Manage_model->company_members_exist('0',$members_id,$organizations_id);

if(empty($CheckTblCompanyMember))

{

$values['datetime'] = date('Y-m-d H:i:s');

$members_sub_id = $this->Common_model->common_insert('company_members',$values);

// 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

}

else

{

if($member_email!='')

{

$C_where = array('company_members_id'=>$CheckTblCompanyMember['company_members_id']);

$C_value = array('email'=>strtolower($member_email));

$this->Common_model->common_update('company_members',$C_value,$C_where); // update email when the email is not empty

}

$members_sub_id = $CheckTblCompanyMember['company_members_id'];

}

// checking table company_members

// assigning to meeting

$values = array('datetime'=>$datetime,

'meetings_id'=>$meetings_id,

'members_sub_id'=>$members_sub_id,

'company_id'=>'0',

'members_id'=>$members_id,

'member_type'=>'1');

$meetings_participants_id = $this->Common_model->common_insert('meetings_participants',$values);

$TicketNumber = 'MPT'.sprintf("%05d", $meetings_participants_id);

// sent notification

$Content = array('title'=>'Meeting Invitation','description'=>'You are invited for a new meeting with '.$OD['name'].'. ','message'=>'You are invited to a new meeting by '.strtok($OD['name'], " ").'-'.$TicketNumber.'. Download Meet Pass for your meeting access (onelink.to/meet). Meet, Mingle & Merge in Person.','meetings_id'=>$meetings_id,'TicketNumber'=>$TicketNumber,'Organization'=>$OD['name'],'MeetingTitle'=>$meeting_title);

$this->SentNotification('1',$members_id,$Content,$members_sub_id,'1');

// sent notification

// Activity Log Record

$head = 'Assign Meeting Members';

$description = 'Members Has Been Assigned By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('meetings_id'=>$meetings_id),'6');

// Activity Log Record

// assigning to meeting

// updating request

$R_where = array('organizations_id'=>$organizations_id,'link_requests_id'=>$link_requests_id);

$R_value = array('meetings_id'=>$meetings_id,'status'=>'1');

$this->Common_model->common_update('link_requests',$R_value,$R_where);

// updating request

$this->Common_model->Set_Message('1','Request approved.');

redirect('meeting-details/'.$meetings_id.'/members');

}

else

{

$_POST['RQ_request_status'] = '1';

$this->Common_model->Set_Message('2',' Your organization scheduled a meeting at '.$CheckMeeting['date'].' '.$CheckMeeting['time'].' to '.$CheckMeeting['end_time'].'.');

$this->Common_model->Set_Message_Rmeeting('2',' Your organization scheduled a meeting at '.$CheckMeeting['date'].' '.$CheckMeeting['time'].' to '.$CheckMeeting['end_time'].'.');

}

else

{

$this->Common_model->Set_Message('2','Error! Please enter a valid date & time.');

$this->Common_model->Set_Message_Rmeeting('2','Error! Please enter a valid date & time.');

}

else

{

$this->Common_model->Set_Message('2','Error! Please fill your address details.');

redirect(current_url());

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

redirect(current_url());

}

else

{

$this->Common_model->Set_Message('2','Error! Your current package is expired. please upgrade to continue to access Meet Pass');

redirect(current_url());

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

redirect(current_url());

}

# Create New Quick Meeting

# Assign To Meeting

if(isset($_POST['AssignToMeeting']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('meetings_id','Meeting','trim|required|xss_clean');

$this->form_validation->set_rules('RQ_link_requests_id','ID','trim|required|xss_clean|numeric');

if($this->form_validation->run())

{

$organizations_id = $this->session->userdata('logged_in')['table_id'];

$OD = $this->Manage_model->get_organization_details($organizations_id);

if(!empty($OD))

{

$link_requests_id = $this->input->post('RQ_link_requests_id');

$meetings_id = $this->input->post('meetings_id');

$LRD = $this->Manage_model->get_link_requests_data($link_requests_id);

if(!empty($LRD))

{

$country_id = $OD['country_id'];

$datetime = date('Y-m-d H:i:s');

$member_name = $LRD['name'];

$member_mobile = $LRD['mobile'];

$member_email = $LRD['email'];

$member_national_id = $LRD['national_id'];

$national_id_expiry_date = $LRD['national_id_expiry_date'];

$MD = $this->Manage_model->meeting_details($meetings_id);

if(!empty($MD))

{

$meeting_datetime = $MD['meeting_datetime'];

if($meeting_datetime>$datetime)

{

$CountMeetingsMembers = $this->Manage_model->check_available_meetings_members_count();

$CheckMembersLimit = $this->Manage_model->check_meetings_members_count($meetings_id);

if($CheckMembersLimit<$CountMeetingsMembers)

{

// checking table members

$CheckTblMember = $this->Manage_model->check_member_is_exist($country_id,$member_mobile);

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($member_name),'phone'=>$member_mobile,'email'=>$member_email,'verification_id'=>$member_national_id,'national_id_expiry_date'=>$national_id_expiry_date);

$members_id = $this->Common_model->common_insert('members',$values);

}

// checking table members

$values = array('company_members_status'=>'0','organizations_id'=>$organizations_id,'company_id'=>'0','members_id'=>$members_id,'name'=>ucwords($member_name),'email'=>$member_email,'verification_id'=>$member_national_id);

// checking table company_members

$CheckTblCompanyMember = $this->Manage_model->company_members_exist('0',$members_id,$organizations_id);

if(empty($CheckTblCompanyMember))

{

$values['datetime'] = date('Y-m-d H:i:s');

$members_sub_id = $this->Common_model->common_insert('company_members',$values);

// 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

}

else

{

$members_sub_id = $CheckTblCompanyMember['company_members_id'];

}

// checking table company_members

$CheckMemberExist = $this->Manage_model->check_meetings_members_exist($meetings_id,$members_id,'');

if(empty($CheckMemberExist))

{

// assigning to meeting

$values = array('datetime'=>$datetime,

'meetings_id'=>$meetings_id,

'members_sub_id'=>$members_sub_id,

'company_id'=>'0',

'members_id'=>$members_id,

'member_type'=>'1');

$meetings_participants_id = $this->Common_model->common_insert('meetings_participants',$values);

$TicketNumber = 'MPT'.sprintf("%05d", $meetings_participants_id);

// sent notification

if($MD['meeting_type']=='0')

{

$Content = array('title'=>'Meeting Invitation','description'=>'You are invited for a new meeting with '.$OD['name'].'. ','message'=>'You are invited to a new meeting by '.strtok($OD['name'], " ").'-'.$TicketNumber.'. Download Meet Pass for your meeting access (onelink.to/meet). Meet, Mingle & Merge in Person.','meetings_id'=>$meetings_id,'TicketNumber'=>$TicketNumber,'Organization'=>$OD['name'],'MeetingTitle'=>$MD['meeting_title']);

}

else

{

$Content = array('title'=>'Event Invitation','description'=>'You are invited for a new event with '.$OD['name'].'. ','message'=>'You are invited to a new evevt by '.strtok($OD['name'], " ").'-'.$TicketNumber.'. Download Meet Pass for your evevt access (onelink.to/meet). Meet, Mingle & Merge in Person.','meetings_id'=>$meetings_id,'TicketNumber'=>$TicketNumber,'Organization'=>$OD['name'],'MeetingTitle'=>$MD['meeting_title']);

}

$this->SentNotification('1',$members_id,$Content,$members_sub_id,'1');

// sent notification

// Activity Log Record

$head = 'Assign Meeting Members';

$description = 'Members Has Been Assigned By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('meetings_id'=>$meetings_id),'6');

// Activity Log Record

// assigning to meeting

// updating request

$R_where = array('organizations_id'=>$organizations_id,'link_requests_id'=>$link_requests_id);

$R_value = array('meetings_id'=>$meetings_id,'status'=>'1');

$this->Common_model->common_update('link_requests',$R_value,$R_where);

// updating request

$this->Common_model->Set_Message('1','Request approved');

redirect(current_url());

}

else

{

$this->Common_model->Set_Message('2','Member already an attendee for the selected meeting.');

}

else

{

$this->Common_model->Set_Message('2','Error! You have exceeded maximum allowed meeting members '.$CountMeetingsMembers.'.');

}

else

{

$this->Common_model->Set_Message('2','Error! Please enter a valid date & time.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

redirect(current_url());

}

# Assign To Meeting

# REJECT REQUEST FUNCTION

if(isset($_POST['delete']))

{

$this->form_validation->set_rules('delete_id','Delete ID','trim|xss_clean|required');

if($this->form_validation->run())

{

$link_requests_id = $this->input->post('delete_id');

$organizations_id = $this->session->userdata('logged_in')['table_id'];

$value = array('status'=>'2');

$where = array('link_requests_id'=>$link_requests_id,'organizations_id'=>$organizations_id);

$this->Common_model->common_update('link_requests',$value,$where);

$this->Common_model->Set_Message('1','Request rejected');

// Activity Log Record

$head = 'Reject Registration';

$description = 'Registration Has Been Rejected By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('link_requests_id'=>$link_requests_id),'9');

// Activity Log Record

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

}

redirect(current_url());

}

# END OF REJECT REQUEST FUNCTION

# FILTER AND PAGINATION SECTION

$URL = $this->uri->segment(1);

$param[] = array('key'=>'mobile','default'=>'');

$param[] = array('key'=>'meeting_date','default'=>'');

$param[] = array('key'=>'meeting_purpose_id','default'=>'');

$FD = $this->Common_model->common_filter($URL,$param);

$FD['LinkStatus'] = $LinkStatus;

$start = $limit = '';

$page_ary['url'] = base_url($URL);

$page_ary['total_rows'] = $this->Manage_model->link_requests($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

$organizations_id = $this->session->userdata('logged_in')['table_id'];

$OD = $this->Manage_model->get_organization_details($organizations_id);

$data['FD'] = $FD;

$data['RL'] = $this->Manage_model->link_requests($FD,$start,$limit,'0');

$data['MP'] = $this->Manage_model->view_meeting_purpose_list($OD['organization_type_id']);

$data['ML'] = $this->Manage_model->upcoming_meeting_list();

$this->CommonPage('organizations/link_requests',$data,'Meeting request from dedicated link');

}

############################################ END OF LINK REQUESTS #################################

############################################ VIEW SECURITY ########################################

public function get_security_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_security_id = $this->input->post('data_id');

$Result = $this->Manage_model->get_security_details($organizations_security_id);

if(!empty($Result))

{

$Data['response'] = 'success';

$Data['result'] = $Result;

}

echo json_encode($Data);

}

public function view_security()

{

# 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('mobile','Email','trim|required|xss_clean|numeric');

$this->form_validation->set_rules('designation','Designation','trim|required|xss_clean');

$this->form_validation->set_rules('admit_privilege','Privilege','trim|required|xss_clean|numeric');

$this->form_validation->set_rules('status','status','trim|required|xss_clean|numeric');

if($this->form_validation->run())

{

$organizations_id = $this->session->userdata('logged_in')['table_id'];

$OD = $this->Manage_model->get_organization_data($organizations_id);

$country_id = $OD['country_id'];

$name = ucwords($this->input->post('name'));

$mobile = $this->input->post('mobile');

$designation = $this->input->post('designation');

$admit_privilege = $this->input->post('admit_privilege');

$status = $this->input->post('status');

// checking tbl security

$CheckTblSecurity = $this->Manage_model->check_security_is_exist($country_id,$mobile);

if(!empty($CheckTblSecurity))

{

$security_id = $CheckTblSecurity['security_id'];

if($CheckTblSecurity['security_status']!=0)

{

$S_where = array('security_id'=>$security_id);

$S_value = array('security_status'=>'0');

$this->Common_model->common_update('security',$S_value,$S_where); // update status when the security 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),

'mobile'=>$mobile,

'designation'=>$designation);

$security_id = $this->Common_model->common_insert('security',$values);

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

redirect(current_url());

}

// checking tbl security

$values = array('organizations_id'=>$organizations_id,

'security_id'=>$security_id,

'name'=>$name,

'designation'=>$designation,

'admit_privilege'=>$admit_privilege,

'status'=>$status);

$CheckTblOrgSecurity = $this->Manage_model->organizations_security_exist($organizations_id,$security_id);

if(!empty($CheckTblOrgSecurity))

{

if($this->input->post('submit')=='Update')

{

$where = array('organizations_id'=>$organizations_id,'security_id'=>$security_id,'organizations_security_id'=>$CheckTblOrgSecurity['organizations_security_id']);

$this->Common_model->common_update('organizations_security',$values,$where);

$this->Common_model->Set_Message('1',"Security details updated successfully.");

// Activity Log Record

$head = 'Update Security';

$description = 'Security Details Has Been Updated By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('security_id'=>$security_id),'7');

// Activity Log Record

}

else

{

$this->Common_model->Set_Message('2','Error! Security details already exist.');

}

else

{

$values['datetime'] = date('Y-m-d H:i:s');

$this->Common_model->common_insert('organizations_security',$values);

$this->Common_model->Set_Message('1',"Security added successfully.");

// Activity Log Record

$head = 'Add Security';

$description = 'Security Details Has Been Added By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('security_id'=>$security_id),'7');

// Activity Log Record

}

redirect(current_url());

}

else

{

if($this->input->post('submit')=='Update')

{

$this->Common_model->Set_Message('2','Error! 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('organizations_security_id'=>$delete_id,'organizations_id'=>$organizations_id);

$value = array('organizations_security_status'=>'1');

$this->Common_model->common_update('organizations_security',$value,$where);

$this->Common_model->Set_Message('1','Secuity details removed successfully.');

// Activity Log Record

$head = 'Remove Secuity';

$description = 'Secuity Details Has Been Removed By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('organizations_security_id'=>$delete_id),'7');

// Activity Log Record

}

else

{

$this->Common_model->Set_Message('2','Error! 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'=>'mobile','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_security($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['MD'] = $this->Manage_model->view_security($FD,$start,$limit,'0');

$this->CommonPage('organizations/view_security',$data,'List of authorized security staffs');

}

############################################ END OF VIEW SECURITY #################################

############################################ MEETINGS #############################################

public function view_meetings($MeetingStatus)

{

$organizations_id = $this->session->userdata('logged_in')['table_id'];

$OD = $this->Manage_model->get_organization_details($organizations_id);

# Create New Quick Meeting

if(isset($_POST['CreateQuickMeeting']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('Q_member_name','Name','trim|required|xss_clean');

$this->form_validation->set_rules('Q_member_mobile','Mobile','trim|required|xss_clean');

$this->form_validation->set_rules('Q_email_id','Email','trim|valid_email|xss_clean');

$this->form_validation->set_rules('Q_meeting_title','Title','trim|required|xss_clean');

$this->form_validation->set_rules('Q_request_status','Status','trim|xss_clean');

$this->form_validation->set_rules('Q_date','Date','trim|required|xss_clean|exact_length[10]');

$this->form_validation->set_rules('Q_time','Time','trim|required|xss_clean|exact_length[5]');

$this->form_validation->set_rules('Q_end_time','End Time','trim|required|xss_clean|exact_length[5]');

if($OD['multiple_locations_status']=='1')

{

$this->form_validation->set_rules('organizations_address_id','Organizations Address ID','trim|required|numeric');

}

if($this->form_validation->run())

{

if(!empty($OD))

{

if(date('Y-m-d')>$OD['packge_validity_upto'])

{

$this->Common_model->Set_Message('2','Error! Your current package is expired. please upgrade to continue to access Meet Pass');

redirect(current_url());

}

$CountAvailableMeetings = $this->Manage_model->check_available_meetings_count();

$CountMeetingsMembers = $this->Manage_model->check_available_meetings_members_count();

if($CountAvailableMeetings>0 && $CountMeetingsMembers>1)

{

$location = $OD['location'];

$latitude = $OD['latitude'];

$longitude = $OD['longitude'];

$country_id = $OD['country_id'];

if($location!='' && $latitude!='' && $longitude!='')

{

$address = array('Building Name: '.$OD['building_name'],'Building Number: '.$OD['building_number'],'Floor Number: '.$OD['floor_number'],'Unit Number: '.$OD['office_number'],'Near Landmark: '.$OD['near_landmark']);

$address = implode(', ', $address);

$member_name = $this->input->post('Q_member_name');

$member_mobile = $this->input->post('Q_member_mobile');

$email_id = $this->input->post('Q_email_id');

$request_status = $this->input->post('Q_request_status');

$meeting_title = $this->input->post('Q_meeting_title');

$date = $this->input->post('Q_date');

$time = $this->input->post('Q_time');

$end_time = $this->input->post('Q_end_time');

$description = $meeting_link = '';

$meeting_type = $car_pass = '0';

$date = $this->Common_model->date_format_changer($date);

$meeting_datetime = $date.' '.$time.':00';

$meeting_end_datetime = $date.' '.$end_time.':00';

$datetime = date('Y-m-d H:i:s');

$values = array('datetime'=>$datetime,

'organizations_id'=>$organizations_id,

'meeting_type'=>$meeting_type,

'meeting_title'=>$meeting_title,

'meeting_datetime'=>$meeting_datetime,

'meeting_end_datetime'=>$meeting_end_datetime,

'location'=>$location,

'latitude'=>$latitude,

'longitude'=>$longitude,

'address'=>$address,

'description'=>$description,

'meeting_link'=>$meeting_link,

'car_pass'=>$car_pass,

'admit_before'=>'1',

'admit_after'=>'2',

'status'=>'1');

// setup address data

if($OD['multiple_locations_status']=='1')

{

$organizations_address_id = $this->input->post('organizations_address_id');

if($organizations_address_id=='0') // address take from organization table

{

$address = array('Building Name: '.$OD['building_name'],'Building Number: '.$OD['building_number'],'Floor Number: '.$OD['floor_number'],'Unit Number: '.$OD['office_number'],'Near Landmark: '.$OD['near_landmark']);

$address = implode(', ', $address);

$values['organizations_address_id'] = '0';

$values['location'] = $OD['location'];

$values['latitude'] = $OD['latitude'];

$values['longitude'] = $OD['longitude'];

$values['address'] = $address;

}

elseif($organizations_address_id>'0') // address take from address table

{

$AddressData = $this->Manage_model->get_organization_contact_details($organizations_address_id,$organizations_id);

if(!empty($AddressData))

{

$address = array('Building Name: '.$AddressData['building_name'],'Building Number: '.$AddressData['building_number'],'Floor Number: '.$AddressData['floor_number'],'Unit Number: '.$AddressData['office_number'],'Near Landmark: '.$AddressData['near_landmark']);

$address = implode(', ', $address);

$values['organizations_address_id'] = $AddressData['organizations_address_id'];

$values['location'] = $AddressData['location'];

$values['latitude'] = $AddressData['latitude'];

$values['longitude'] = $AddressData['longitude'];

$values['address'] = $address;

}

// setup address data

if($meeting_datetime>$datetime && $meeting_end_datetime>$meeting_datetime)

{

$CheckMeeting = array();

if($request_status!='1')

{

$CheckMeeting = $this->Manage_model->check_meetings_available_org($organizations_id,$meeting_datetime,$meeting_end_datetime);

}

if(empty($CheckMeeting)) // checking meeting scheduled or not

{

// checking meeting duplication

$NextTime = date('Y-m-d H:i:s', strtotime('-30 seconds'));

$CheckMeetingDuplication = $this->Manage_model->check_meeting_duplication($organizations_id,$NextTime,$datetime,$meeting_datetime,$meeting_end_datetime);

if(!empty($CheckMeetingDuplication))

{

redirect(current_url());

}

// checking meeting duplication

$meetings_id = $this->Common_model->common_insert('meetings',$values);

// update meetings count

$value = array('meetings_count'=>$CountAvailableMeetings-1);

$where = array('organizations_id'=>$organizations_id);

$this->Common_model->common_update('organizations',$value,$where);

// update meetings count

// Activity Log Record

$head = 'Create Meeting (Quick)';

$description = 'New Meeting (Quick) Has Been Created By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('meetings_id'=>$meetings_id),'6');

// Activity Log Record

// processing memberdetails

$ReqData = array('country_id'=>$country_id,

'member_mobile'=>$member_mobile,

'member_name'=>$member_name,

'email_id'=>$email_id,

'organizations_id'=>$organizations_id,

'company_id'=>'0');

$ResultData = $this->CheckingMemberDetails($ReqData);

$members_id = $ResultData['members_id'];

$members_sub_id = $ResultData['members_sub_id'];

// processing memberdetails

// assigning to meeting

$values = array('datetime'=>$datetime,

'meetings_id'=>$meetings_id,

'members_sub_id'=>$members_sub_id,

'company_id'=>'0',

'members_id'=>$members_id,

'member_type'=>'1');

$meetings_participants_id = $this->Common_model->common_insert('meetings_participants',$values);

$TicketNumber = 'MPT'.sprintf("%05d", $meetings_participants_id);

// sent notification

$Content = array('title'=>'Meeting Invitation','description'=>'You are invited for a new meeting with '.$OD['name'].'. ','message'=>'You are invited to a new meeting by '.strtok($OD['name'], " ").'-'.$TicketNumber.'. Download Meet Pass for your meeting access (onelink.to/meet). Meet, Mingle & Merge in Person.','meetings_id'=>$meetings_id,'TicketNumber'=>$TicketNumber,'Organization'=>$OD['name'],'MeetingTitle'=>$meeting_title);

$this->SentNotification('1',$members_id,$Content,$members_sub_id,'1');

// sent notification

// Activity Log Record

$head = 'Assign Meeting Members';

$description = 'Members Has Been Assigned By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('meetings_id'=>$meetings_id),'6');

// Activity Log Record

// assigning to meeting

$this->Common_model->Set_Message('1','New meeting created successfully.');

redirect('meeting-details/'.$meetings_id.'/members');

}

else

{

$_POST['Q_request_status'] = '1';

$this->Common_model->Set_Message('2',' Your organization scheduled a meeting at '.$CheckMeeting['date'].' '.$CheckMeeting['time'].' to '.$CheckMeeting['end_time'].'.');

$this->Common_model->Set_Message_Qmeeting('2',' Your organization scheduled a meeting at '.$CheckMeeting['date'].' '.$CheckMeeting['time'].' to '.$CheckMeeting['end_time'].'.');

}

else

{

$this->Common_model->Set_Message('2','Error! Please enter a valid Date & Time.');

$this->Common_model->Set_Message_Qmeeting('2','Error! Please enter a valid Date & Time.');

}

else

{

$this->Common_model->Set_Message('2','Error! Please complete your address.');

$this->Common_model->Set_Message_Qmeeting('2','Error! Please complete your address.');

redirect(current_url());

}

else

{

$this->Common_model->Set_Message('2','Error! Your current package is expired. please upgrade to continue to access Meet Pass');

$this->Common_model->Set_Message_Qmeeting('2','Error! Your current package is expired. please upgrade to continue to access Meet Pass');

redirect(current_url());

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

$this->Common_model->Set_Message_Qmeeting('2','Error! Oops something went wrong. Please try again.');

redirect(current_url());

}

# Create New Quick Meeting

# Create New Meeting

if(isset($_POST['CreateMeeting']))

{

$this->form_validation->set_error_delimiters('<div class="ci-form-error">', '</div>');

$this->form_validation->set_rules('meeting_type','Type','trim|required|xss_clean');

$this->form_validation->set_rules('meeting_title','Title','trim|required|xss_clean');

$this->form_validation->set_rules('date','Date','trim|required|xss_clean|exact_length[10]');

$this->form_validation->set_rules('time','Time','trim|required|xss_clean|exact_length[5]');

$this->form_validation->set_rules('end_time','End Time','trim|required|xss_clean|exact_length[5]');

/*$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('address','Address','trim|required|xss_clean');*/

$this->form_validation->set_rules('car_pass','Car Pass','trim|required|xss_clean');

$this->form_validation->set_rules('description','Description','trim|xss_clean');

$this->form_validation->set_rules('request_status','Status','trim|xss_clean');

$this->form_validation->set_rules('meeting_link','Link','trim|xss_clean|valid_url');

if($OD['multiple_locations_status']=='1')

{

$this->form_validation->set_rules('organizations_address_id','Organizations Address ID','trim|required|numeric');

}

if($this->form_validation->run())

{

$meeting_type = $this->input->post('meeting_type');

if(!empty($OD))

{

if(date('Y-m-d')>$OD['packge_validity_upto'])

{

$this->Common_model->Set_Message('2','Error! Your current package is expired. please upgrade to continue to access Meet Pass');

redirect(current_url());

}

if($meeting_type==0) // meeting

{

$CountAvailableMeetings = $this->Manage_model->check_available_meetings_count();

}

else // event

{

$CountAvailableMeetings = $this->Manage_model->check_available_events_count();

}

if($CountAvailableMeetings>0)

{

$location = $OD['location'];

$latitude = $OD['latitude'];

$longitude = $OD['longitude'];

if($location!='' && $latitude!='' && $longitude!='')

{

$address = array('Building Name: '.$OD['building_name'],'Building Number: '.$OD['building_number'],'Floor Number: '.$OD['floor_number'],'Unit Number: '.$OD['office_number'],'Near Landmark: '.$OD['near_landmark']);

$address = implode(', ', $address);

$meeting_title = $this->input->post('meeting_title');

$date = $this->input->post('date');

$time = $this->input->post('time');

$end_time = $this->input->post('end_time');

//$description = $this->input->post('description');

$meeting_link = $this->input->post('meeting_link');

$car_pass = $this->input->post('car_pass');

$request_status = $this->input->post('request_status');

$date = $this->Common_model->date_format_changer($date);

$meeting_datetime = $date.' '.$time.':00';

$meeting_end_datetime = $date.' '.$end_time.':00';

$flollow_up_id = $this->input->post('hfmeeting_id');

$flollow_up_status = $this->input->post('flollow_up_status');

$datetime = date('Y-m-d H:i:s');

$values = array('datetime'=>$datetime,

'organizations_id'=>$organizations_id,

'meeting_type'=>$meeting_type,

'meeting_title'=>$meeting_title,

'meeting_datetime'=>$meeting_datetime,

'meeting_end_datetime'=>$meeting_end_datetime,

'location'=>$location,

'latitude'=>$latitude,

'longitude'=>$longitude,

'address'=>$address,

'meeting_link'=>$meeting_link,

'car_pass'=>$car_pass,

'admit_before'=>'1',

'admit_after'=>'2',

'status'=>'1');

// setup address data

if($OD['multiple_locations_status']=='1')

{

$organizations_address_id = $this->input->post('organizations_address_id');

if($organizations_address_id=='0') // address take from organization table

{

$address = array('Building Name: '.$OD['building_name'],'Building Number: '.$OD['building_number'],'Floor Number: '.$OD['floor_number'],'Unit Number: '.$OD['office_number'],'Near Landmark: '.$OD['near_landmark']);

$address = implode(', ', $address);

$values['organizations_address_id'] = '0';

$values['location'] = $OD['location'];

$values['latitude'] = $OD['latitude'];

$values['longitude'] = $OD['longitude'];

$values['address'] = $address;

}

elseif($organizations_address_id>'0') // address take from address table

{

$AddressData = $this->Manage_model->get_organization_contact_details($organizations_address_id,$organizations_id);

if(!empty($AddressData))

{

$address = array('Building Name: '.$AddressData['building_name'],'Building Number: '.$AddressData['building_number'],'Floor Number: '.$AddressData['floor_number'],'Unit Number: '.$AddressData['office_number'],'Near Landmark: '.$AddressData['near_landmark']);

$address = implode(', ', $address);

$values['organizations_address_id'] = $AddressData['organizations_address_id'];

$values['location'] = $AddressData['location'];

$values['latitude'] = $AddressData['latitude'];

$values['longitude'] = $AddressData['longitude'];

$values['address'] = $address;

}

// setup address data

if($meeting_type==1) // event

{

$values['participant_status'] = '1';

}

if($meeting_datetime>$datetime && $meeting_end_datetime>$meeting_datetime)

{

$CheckMeeting = array();

if($request_status!='1')

{

$CheckMeeting = $this->Manage_model->check_meetings_available_org($organizations_id,$meeting_datetime,$meeting_end_datetime);

}

if(empty($CheckMeeting)) // checking meeting scheduled or not

{

// checking meeting duplication

$NextTime = date('Y-m-d H:i:s', strtotime('-30 seconds'));

$CheckMeetingDuplication = $this->Manage_model->check_meeting_duplication($organizations_id,$NextTime,$datetime,$meeting_datetime,$meeting_end_datetime);

if(!empty($CheckMeetingDuplication))

{

redirect(current_url());

}

// checking meeting duplication

$meetings_id = $this->Common_model->common_insert('meetings',$values);

if($meeting_type==0) // meeting

{

$this->Common_model->Set_Message('1','New meeting created successfully.');

}

else // event

{

$this->Common_model->Set_Message('1','New Event created successfully.');

}

// update meetings count

if($meeting_type==0) // meeting

{

$value = array('meetings_count'=>$CountAvailableMeetings-1);

}

else // event

{

$value = array('events_count'=>$CountAvailableMeetings-1);

}

$where = array('organizations_id'=>$organizations_id);

$this->Common_model->common_update('organizations',$value,$where);

// update meetings count

// Activity Log Record

$head = 'Create Meeting';

$description = 'New Meeting Has Been Created By ';

$this->Common_model->create_activity_log($head,$description,'',array(),array('meetings_id'=>$meetings_id),'6');

// Activity Log Record

redirect('meeting-details/'.$meetings_id.'/members');

}

else

{

$_POST['request_status'] = '1';

$this->Common_model->Set_Message('2',' Your organization scheduled a meeting at '.$CheckMeeting['date'].' '.$CheckMeeting['time'].' to '.$CheckMeeting['end_time'].'.');

$this->Common_model->Set_Message_meeting('2',' Your organization scheduled a meeting at '.$CheckMeeting['date'].' '.$CheckMeeting['time'].' to '.$CheckMeeting['end_time'].'.');

}

else

{

$this->Common_model->Set_Message('2','Error! Please enter a valid Date & Time.');

$this->Common_model->Set_Message_meeting('2','Error! Please enter a valid Date & Time.');

}

else

{

$this->Common_model->Set_Message('2','Error! Please complete your address.');

$this->Common_model->Set_Message_meeting('2','Error! Please complete your address.');

}

else

{

$this->Common_model->Set_Message('2','Error! Your current package is expired. please upgrade to continue to access Meet Pass');

$this->Common_model->Set_Message_meeting('2','Error! Your current package is expired. please upgrade to continue to access Meet Pass');

redirect(current_url());

}

else

{

$this->Common_model->Set_Message('2','Error! Oops something went wrong. Please try again.');

$this->Common_model->Set_Message_meeting('2','Error! Oops something went wrong. Please try again.');

}

# Create New Meeting

#follow up New Meeting

if(isset($_POST['CreateMeetingFollowup']))