ikan Uploader :
Directory : /var/www/html/www.shardaevents.com/application/controllers/admin/
Upload File : |
| Current File : /var/www/html/www.shardaevents.com/application/controllers/admin/Events.php |
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
/**
* Description of VideoUpload
*
* @author : Sharda Tech Pvt. Ltd
*/
class Events extends CI_Controller {
//variable for storing error message
private $error;
//variable for storing success message
private $success;
function __construct() {
parent::__construct();
//load this to validate the inputs in upload form
$this->load->model(array('Events_Model','Common_Model'));
if(! $this->session->userdata('adid'))
redirect('admin/login');
}
//appends all error messages
private function handle_error($err) {
$this->error .= $err . "\r\n";
}
//appends all success messages
private function handle_success($succ) {
$this->success .= $succ . "\r\n";
}
public function index(){
$data = array();
$role_id = $this->session->userdata('role_id');
$author_id = $this->session->userdata('adid')->id;
// Status Master List
$data['statusArray'] = $this->Events_Model->getCommonIdArray('tbl_status_master','id,display_name',array('status'=>'1','is_deleted'=>'0','event_status'=>'0'));
// School Master List
$data['schoolArray'] = $schoolName = $this->Events_Model->getCommonIdArray('tbl_schools','id, school_name, school_code',array('status'=>'1','is_display'=>'1', 'is_deleted'=>'0'),array('school_name'=>'ASC'));
if($_GET['status']){
$_POST['status_filter'] = base64_decode($_GET['status']);
}
// Role Master List
$data['roleArray'] = $this->Common_Model->getCommonIdArray('tbl_role_master');
$data['recorddetails'] = array();
$condArray = array('tbl_event_master.is_deleted'=>'0');
$deptArrayCond = array('status'=>'1', 'is_deleted'=>'0');
if(in_array($role_id,DIGITAL_ROLE)){ // Digital Marketing
$condArray['tbl_event_master.status'] = '4';
$condArray['verified_hod'] = '1';
$condArray['verified_dean'] = '1';
$condArray['verified_iqac'] = '1';
} else if(in_array($role_id,IQAC_ROLE)){ // IQAC
$condArray['tbl_event_master.status'] = '4';
$condArray['verified_hod'] = '1';
$condArray['verified_dean'] = '1';
} else if(in_array($role_id,DEAN_ROLE)){ // School Dean
$condArray['tbl_event_master.status'] = '4';
$condArray['verified_hod'] = '1';
$condArray['organizing_school'] = $this->session->userdata(adid)->school_id;
$deptArrayCond['school_id'] = $this->session->userdata(adid)->school_id; ;
} else if(in_array($role_id,SCHOOL_HOD_ROLE)){ // School HOD
$condArray['organizing_school'] = $this->session->userdata(adid)->school_id;
$condArray['organizing_departments'] = $this->session->userdata(adid)->department_id;
$condArray['tbl_event_master.status'] = '4';
} else if(in_array($role_id,SCHOOL_HOD_FACULTY)){ // Faculty
$condArray['organizing_school'] = $this->session->userdata(adid)->school_id;
//$condArray['organizing_departments'] = $this->session->userdata(adid)->department_id;
$condArray['author_id'] = $author_id;
}
// Depaartment Master List
$data['deptArray'] = $deptsName = $this->Events_Model->getCommonIdArray('tbl_departments','id, department_name',$deptArrayCond);
/* Custom Admin/ Super Admin Filter Applied Here */
if($_POST['status_filter']){
$condArray['tbl_event_master.status'] =$_POST['status_filter'];
}
if($_POST['school_filter']){
$condArray['tbl_event_master.organizing_school'] =$_POST['school_filter'];
}
if($_POST['department_filter']){
$condArray['tbl_event_master.organizing_departments'] =$_POST['department_filter'];
}
$betweenDate = array();
// Date Wise Events Filter
if($_POST['start_date']!='' && $_POST['end_date']!='') {
$betweenDate = array('tbl_event_date_time.start_date'=>$_POST['start_date'],'tbl_event_date_time.end_date'=>$_POST['end_date']);
} else {
if($_POST['start_date']) {
$condArray['tbl_event_date_time.start_date'] = $_POST['start_date'];
} else if($_POST['end_date']) {
$condArray['tbl_event_date_time.end_date'] = $_POST['end_date'];
}
}
//print_r($condArray); die;
$data['recorddetails'] = $exportrecordsArray = $this->Events_Model->getAdminAllEventsRecords(NULL, $condArray, $betweenDate);
//Export Events in CSV
if(isset($_POST['exportevents']))
{
$filename = 'Export_events_list';
setHistory('Go to export events listing module');
// load excel library
$this->load->library('excel');
$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0);
// set Header
$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Evnet Title');
$objPHPExcel->getActiveSheet()->SetCellValue('B1', 'Event Details');
$objPHPExcel->getActiveSheet()->SetCellValue('C1', 'Objective of Evnet');
$objPHPExcel->getActiveSheet()->SetCellValue('D1', 'School Name');
$objPHPExcel->getActiveSheet()->SetCellValue('E1', 'Department Name');
$objPHPExcel->getActiveSheet()->SetCellValue('F1', 'Convener Details');
$objPHPExcel->getActiveSheet()->SetCellValue('G1', 'Coordinator Details');
$objPHPExcel->getActiveSheet()->SetCellValue('H1', 'Event Start Date');
$objPHPExcel->getActiveSheet()->SetCellValue('I1', 'Event End Date');
$objPHPExcel->getActiveSheet()->SetCellValue('J1', 'Link');
$objPHPExcel->getActiveSheet()->SetCellValue('K1', 'Ezone Id');
$objPHPExcel->getActiveSheet()->SetCellValue('L1', 'Budget');
//set Row
$rowCount = 2;
foreach ($exportrecordsArray as $list) {
$link = "http://shardaevents.com/events/".$list['event_slug']."?id=".$list['id'];
$objPHPExcel->getActiveSheet()->SetCellValue('A' . $rowCount, $list['event_title']);
$objPHPExcel->getActiveSheet()->SetCellValue('B' . $rowCount, strip_tags($list['event_details']));
$objPHPExcel->getActiveSheet()->SetCellValue('C' . $rowCount, strip_tags($list['objective_of_event']));
$objPHPExcel->getActiveSheet()->SetCellValue('D' . $rowCount, $schoolName[$list['organizing_school']]['school_name']);
$objPHPExcel->getActiveSheet()->SetCellValue('E' . $rowCount, $deptsName[$list['organizing_departments']]['department_name']);
$objPHPExcel->getActiveSheet()->SetCellValue('F' . $rowCount, strip_tags($list['convener_details']));
$objPHPExcel->getActiveSheet()->SetCellValue('G' . $rowCount, strip_tags($list['coordinator_details']));
$objPHPExcel->getActiveSheet()->SetCellValue('H' . $rowCount, $list['start_date']);
$objPHPExcel->getActiveSheet()->SetCellValue('I' . $rowCount, $list['end_date']);
$objPHPExcel->getActiveSheet()->SetCellValue('J' . $rowCount, $link);
$objPHPExcel->getActiveSheet()->SetCellValue('K' . $rowCount, $list['ezone_id']);
$objPHPExcel->getActiveSheet()->SetCellValue('L' . $rowCount, $list['event_budget']);
$rowCount++;
}
$fileName = $filename.'-'. date("Y-m-d-H-i-s").".csv";
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="'.$fileName.'"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'CSV');
$objWriter->save('php://output');
exit;
}
$data['authorArray'] = $this->Events_Model->getAllModuleList('tbl_admin','id,userName,role_id', array('status'=>'1'));
$data['report'] = $this->Events_Model->getCommonEventIdArray('tbl_event_report','*', array('status'=>'1'));
$data['reportBudget'] = $this->Events_Model->getCommonEventIdArray('tbl_event_budget_report','*', array('status'=>'1'));
$data['image'] = $this->Events_Model->getSingleRecord('tbl_event_images','*', array('status'=>'1'));
$data['videos'] = $this->Events_Model->getSingleRecord('tbl_event_videos','*', array('status'=>'1'));
$data['review'] = $this->Events_Model->getCommonIdArray('tbl_event_approval_transaction','*', array('status'=>'1'));
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/events/index',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to manage events listing module');
}
function slugify($text) {
// Replace non letter or digits with '-'
$text = preg_replace('~[^\pL\d]+~u', '-', $text);
// Transliterate
$text = iconv('utf-8', 'us-ascii//TRANSLIT', $text);
// Remove unwanted characters
$text = preg_replace('~[^-\w]+~', '', $text);
// Trim
$text = trim($text, '-');
// Lowercase
$text = strtolower($text);
if (empty($text)) {
return 'n-a';
}
return $text;
}
/*
* Function : addevent
* Date:
* Createdby:
*/
public function addevent($id='') {
$data = array();
$userArray = $this->session->userdata('adid');
$author_id = $userArray->id;
$role_id = $userArray->role_id;
$data['audiencesArray'] = $this->Events_Model->getCommonIdArray('tbl_target_audiences','id, title, display_name',array('status'=>'1'));
// Get Campus List
$data['campusArray'] = $campusArray = $this->Events_Model->getCommonIdArray('tbl_campus','*',array('status'=>'1'));
// Get School List
$data['schoolArray'] = $this->Events_Model->getCommonIdArray('tbl_schools','*',array('status'=>'1','school_id'));
// Get Course List
$data['courseArray'] = $this->Events_Model->getCommonIdArray('tbl_course_master','*',array('status'=>'1'));
// Get Plan List
$data['planArray'] = $this->Events_Model->getCommonIdArray('tbl_plan_master','*',array('status'=>'1'));
// Get Subject List
$data['subjectArray'] = $this->Events_Model->getCommonIdArray('tbl_subject_master','*',array('status'=>'1'));
// Get Class List
$data['classArray'] = $this->Events_Model->getCommonIdArray('tbl_class_master','*',array('status'=>'1'));
//Get scope master
$data['scopeArray'] = $this->Events_Model->getCommonIdArray('tbl_scope_master','id, title, display_name',array('status'=>'1'));
//Get event_specifications master
$data['specificationsArray'] = $this->Events_Model->getCommonIdArray('tbl_eventtype_master','id, title, display_name',array('status'=>'1'));
//Get media_coverage master
$data['mediaArray'] = $this->Events_Model->getCommonIdArray('tbl_media_coverage','id, title, display_name',array('status'=>'1'));
//Get tbl_status_master
$data['statusArray'] = $this->Events_Model->getCommonIdArray('tbl_status_master','id,display_name',array('status'=>'1','event_status'=>'0'));
if($_POST['save_event']=='Submit Event'){
$this->form_validation->set_rules('event_title','Title','required');
$this->form_validation->set_rules('event_slug','Slug','required');
$this->form_validation->set_rules('all_day_event','Event Date and Time','required');
$this->form_validation->set_rules('contact_name','Contact Person','required');
$this->form_validation->set_rules('organizing_school','School Name','required');
$this->form_validation->set_rules('organizing_departments','Department Name','required');
$this->form_validation->set_rules('event_details','Events Description','required');
$this->form_validation->set_rules('objective_of_event','Objective of events','required');
$this->form_validation->set_rules('convener_details','Convener Details','required');
$this->form_validation->set_rules('coordinator_details','Coordinator Details','required');
$this->form_validation->set_rules('ezone_id','Ezone ID','required');
if($this->form_validation->run())
{
$event_title = trim($this->input->post('event_title'));
$ezone_id = trim($this->input->post('ezone_id'));
$event_details = $this->input->post('event_details');
$objective_of_event = $this->input->post('objective_of_event');
$community_person_name = $this->input->post('community_person_name');
$collaborative_organization = $this->input->post('collaborative_organization');
$external_participants = $this->input->post('external_participants');
$intra_school_participants = $this->input->post('intra_school_participants');
$inter_school_participants = $this->input->post('inter_school_participants');
$collaborative_organization = $this->input->post('collaborative_organization');
$affiliation_organization = implode(':;',$this->input->post('affiliation_organization'));
$affiliation_of_speakers = implode(',',$this->input->post('affiliation_of_speakers'));
$event_scope = implode(',',$this->input->post('event_scope'));
$event_type = $this->input->post('event_type');
$status = $this->input->post('status');
$event_specifications = implode(',',$this->input->post('event_specifications'));
$chief_guest = $this->input->post('chief_guest');
$chief_guest_affiliation = $this->input->post('chief_guest_affiliation');
$speakers_1 = implode(';',$this->input->post('speakers_1'));
$organizing_school = $this->input->post('organizing_school');
$organizing_departments = $this->input->post('organizing_departments');
$convener_details = $this->input->post('convener_details');
$coordinator_details = $this->input->post('coordinator_details');
$event_budget = $this->input->post('event_budget');
$target_audiences = implode(',',$this->input->post('target_audiences'));
$media_coverage = implode(',',$this->input->post('media_coverage'));
$sdgs = implode(',',$this->input->post('sdgs'));
$declaration = $this->input->post('declaration');
$categories = implode(',',$this->input->post('categories'));
$tags = implode(',',$this->input->post('tags'));
$event_slug = str_replace(array(',','|','&','*','#','@','!','`','~'),'-',allletters_lowercase(trim($this->input->post('event_slug'))));
// Remove all special characters
$event_slug = $this->slugify($event_slug);
$all_day_event = $this->input->post('all_day_event');
$no_end_time = $this->input->post('no_end_time');
$start_date = $this->input->post('start_date');
$start_time = $this->input->post('start_time');
$end_date = $this->input->post('end_date');
$end_time = $this->input->post('end_time');
$time_zone = $this->input->post('time_zone');
$old_upload_report = $this->input->post('old_upload_report');
$old_upload_1 = $this->input->post('old_upload_1');
$old_upload_2 = $this->input->post('old_upload_2');
$old_upload_3 = $this->input->post('old_upload_3');
$old_upload_4 = $this->input->post('old_upload_4');
$old_banner_image = $this->input->post('old_banner_image');
$old_pre_budget_pdf = $this->input->post('old_pre_budget_pdf');
$contact_name = $this->input->post('contact_name');
$phone = $this->input->post('phone');
$email = $this->input->post('email');
$website_url = $this->input->post('website_url');
$venue_name = $this->input->post('venue_name');
$address = $this->input->post('address');
$latitude = $this->input->post('latitude');
$longitude = $this->input->post('longitude');
$input_coordinates = $this->input->post('input_coordinates');
$ticket_type = $this->input->post('ticket_type');
$cost = $this->input->post('cost');
$free_event = $this->input->post('free_event');
$addcategories = $this->input->post('addcategories');
$addtags = $this->input->post('addtags');
$event_others = $this->input->post('event_others');
$banner_image = $this->uploadbanner($file_name='banner_image', $old_banner_image);
if($old_banner_image<>'' && $banner_image=='') {
$banner_image = $old_banner_image;
}
$pre_budget_pdf = $this->uploadbanner($file_name='pre_budget_pdf', $old_pre_budget_pdf);
if($old_pre_budget_pdf<>'' && $pre_budget_pdf=='') {
$pre_budget_pdf = $old_pre_budget_pdf;
}
$data = array(
'event_title'=>$event_title,
'ezone_id'=>$ezone_id,
'event_details'=>$event_details,
'objective_of_event'=>$objective_of_event,
'community_person_name'=>$community_person_name,
'collaborative_organization'=>$collaborative_organization,
'external_participants'=>$external_participants,
'intra_school_participants'=>$intra_school_participants,
'inter_school_participants'=>$inter_school_participants,
'collaborative_organization'=>$collaborative_organization,
'affiliation_organization'=>$affiliation_organization,
'affiliation_of_speakers'=>$affiliation_of_speakers,
'event_scope'=>$event_scope,
'event_type'=>$event_type,
'sdgs'=>$sdgs,
'status'=>$status,
'event_specifications'=>$event_specifications,
'chief_guest'=>$chief_guest,
'chief_guest_affiliation'=>$chief_guest_affiliation,
'speakers_1'=>$speakers_1,
'organizing_school'=>$organizing_school,
'organizing_departments'=>$organizing_departments,
'convener_details'=>$convener_details,
'coordinator_details'=>$coordinator_details,
'event_budget'=>$event_budget,
'target_audiences'=>$target_audiences,
'media_coverage'=>$media_coverage,
'declaration'=>$declaration,
'event_slug'=>$event_slug,
'banner_image'=>$banner_image,
'pre_budget_pdf'=>$pre_budget_pdf,
'event_others'=>$event_others,
'is_deleted'=>'0'
);
$edtdata = array();
$edtdata = array(
'start_date'=>date('Y-m-d',strtotime($start_date)),
'start_time'=>$start_time,
'end_date'=>date('Y-m-d',strtotime($end_date)),
'time_zone'=>$time_zone,
'end_time'=>$end_time,
'is_deleted'=>'0',
'status'=>'1'
);
if($all_day_event>0){
$edtdata['all_day_event'] = $all_day_event;
}
else{
$edtdata['all_day_event'] = 0;
}
/* All day Event */
if($all_day_event=='2'){
$edtdata['end_date'] = '';
$edtdata['end_time'] = '';
}
if($no_end_time>0){
$edtdata['no_end_time'] = $no_end_time;
}
else{
$edtdata['no_end_time'] = 0;
}
if ($_POST['no_end_time'] == '1'){
$edtdata['end_date']='';
}
$location = array();
$location = array(
'address'=>$address,
'venue_name'=>$venue_name,
'latitude'=>$latitude,
'longitude'=>$longitude,
'is_deleted'=>'0',
'status'=>'1'
);
if($input_coordinates>0){
$location['input_coordinates'] = $input_coordinates;
}
else{
$location['input_coordinates'] = 0;
}
if ($_POST['input_coordinates'] != '1'){
$location['latitude']='';
$location['longitude']='';
}
$costs = array();
$costs = array(
'cost'=>$cost,
'ticket_type'=>$ticket_type,
'is_deleted'=>'0',
'status'=>'1'
);
if($free_event>0){
$costs['free_event'] = $free_event;
}
else{
$costs['free_event'] = 0;
}
if ($_POST['free_event'] == '1'){
$costs['cost']='';
}
$orgdata = array();
$orgdata = array(
'contact_name'=>$contact_name,
'phone'=>$phone,
'email'=>$email,
'website_url'=>$website_url,
'status'=>'1',
'is_deleted'=>'0'
);
if($this->input->post('id')){
$id = $this->input->post('id');
$this->Events_Model->updateinfo($tbl_name='tbl_event_master',$data,'id',$id);
// Update Event Date/Time
$edtdata['modifiedon'] = date('Y-m-d H:i:s');
$this->Events_Model->updateinfo($tbl_name='tbl_event_date_time',$edtdata,'event_id',$id);
$this->Events_Model->updateinfo($tbl_name='tbl_event_organizer_contactinfo',$orgdata,'event_id',$id);
$this->Events_Model->updateinfo($tbl_name='tbl_event_cost_tickets',$costs,'event_id',$id);
$this->Events_Model->updateinfo($tbl_name='tbl_event_location_details',$location,'event_id',$id);
$currentRecord = $this->Events_Model->getSingleRecord('tbl_event_master','*', array('status'=>'4','id'=>$id));
$this->session->set_flashdata('success', 'Event updated succesfully!!');
setHistory('Event updated successfully');
} else {
$data['author_id'] = $author_id;
$data['createdon'] = date('Y-m-d H:i:s');
$eventId = $this->Events_Model->saveinfo($tbl_name='tbl_event_master',$data);
$this->session->set_flashdata('success', 'Event added succesfully!!');
setHistory('Event added successfully');
if($eventId>0) {
// Save Data In tbl_event_date_time
$edtdata['event_id'] = $eventId;
$edtdata['createdon'] = date('Y-m-d H:i:s');
$this->Events_Model->saveinfo($tbl_name='tbl_event_date_time',$edtdata);
// Save Data In tbl_event_location_details
$location['event_id'] = $eventId;
$location['createdon'] = date('Y-m-d H:i:s');
$this->Events_Model->saveinfo($tbl_name='tbl_event_location_details',$location);
// Save Data In tbl_event_cost_tickets
$costs['event_id'] = $eventId;
$costs['createdon'] = date('Y-m-d H:i:s');
$this->Events_Model->saveinfo($tbl_name='tbl_event_cost_tickets',$costs);
// Save Data In tbl_event_organizer_contactinfo
$orgdata['event_id'] = $eventId;
$orgdata['createdon'] = date('Y-m-d H:i:s');
$this->Events_Model->saveinfo($tbl_name='tbl_event_organizer_contactinfo',$orgdata);
$currentRecord = $this->Events_Model->getSingleRecord('tbl_event_master','*', array('status'=>'4','id'=>$eventId));
if($currentRecord['status']=='4' && $currentRecord['verified_hod']=='0' && $currentRecord['verified_dean']=='0' && $currentRecord['verified_iqac']=='0'){
$this->updateToHod($currentRecord['id']);
$this->updateToAuthor($currentRecord['id'], 'Event Created Successfully');
}
//Save categories
//$addcat['createdon'] = date('Y-m-d H:i:s');
//$this->Events_Model->saveinfo($tbl_name='tbl_category',$addcat);
//Save tags
//$addtag['createdon'] = date('Y-m-d H:i:s');
//$this->Events_Model->saveinfo($tbl_name='tbl_category',$addtag);
setHistory('Event other details added successfully');
}
}
//send email to hod after alteration
if($_POST['hod']==1){
$this->updateToHod($id);
}
//send email to hod after alteration
if($_POST['dean']==1){
$this->updateToDean($id);
}
//send email to hod after alteration
if($_POST['iqac']==1){
$this->updateToIqac($id);
}
$this->session->set_flashdata('success', 'Event added succesfully!!');
redirect('admin/events');
} else {
$data['sd'] = $_POST;
//print_r($_POST); die('Other Box');
$this->load->view('admin/_parts/header');
$this->load->view('admin/events/addevent',$data);
$this->load->view('admin/_parts/footer');
}
}
else {
//Target Audiences
$data['sd'] = $_POST;
if($id>0){
$data['sd'] = $sd = $this->Events_Model->getSingleRecord('tbl_event_master',' * ', array('id'=>$id));
//Get department list
$data['departmentArray'] = $this->Events_Model->getCommonIdArray('tbl_departments','*',array('status'=>'1','school_id'=>$sd['organizing_school']));
}
//Get tbl_event_date_&_time master
$data['dateArray'] = $this->Events_Model->getAlldate($id);
//Get tbl_event_organizer_contactinfo master
$data['info'] = $this->Events_Model->getAlldata($id);
//Get tbl_event_location_details master
$data['locationArray'] = $this->Events_Model->getAlllocation($id);
//Get tbl_event_cost_tickets master
$data['costArray'] = $this->Events_Model->getAllcost($id);
//get event_approval transaction
$event_id=$_POST['event_id'];
$data['sendemail']=$this->Events_Model->sendEmail($id);
//echo $event_id;die;
$data['review'] = $this->Events_Model->getCommonIdArray('tbl_event_approval_transaction','*', array('status'=>'1'));
//get admintable
$data['admin'] = $this->Events_Model->getSingleRecord('tbl_admin','*', array('status'=>'1'));
//echo("<pre>");
//print_r($data);die;
//load the error and success messages
$data['errors'] = $this->error;
$data['success'] = $this->success;
//load the view along with data
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/events/addevent',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to Add video');
}
}
public function approvedall($id)
{
$eventDetails = $this->Events_Model->getSingleRecord('tbl_event_master','*', array('id'=>$id));
$this->Events_Model->updateinfo($tbl_name='tbl_event_master',array('verified_hod'=>'1','verified_dean'=>'1', 'verified_iqac'=>'1'),'id',$id);
// Send email to all
$this->email($id);
$this->session->set_flashdata('success', 'Event Approved Successfully.');
setHistory('Event Approved Successfully.');
redirect('admin/events');
}
//sending report to concered hod
public function updateToIqac($uid)
{
$data = array();
$params = array();
$author_id = $userArray->id;
$eventRows = $this->Events_Model->getSingleRecord('tbl_event_master',' * ', array('id'=>$uid));
$eventOrgRows = $this->Events_Model->getSingleRecord('tbl_event_organizer_contactinfo',' * ', array('event_id'=>$eventRows['id'],'status'=>'1'));
$eventLocRows = $this->Events_Model->getSingleRecord('tbl_event_location_details',' * ', array('event_id'=>$eventRows['id'],'status'=>'1'));
$eventDateRows = $this->Events_Model->getSingleRecord('tbl_event_date_time',' * ', array('event_id'=>$eventRows['id'],'status'=>'1'));
// Get School Details
$schoolRows = $this->Events_Model->getSingleRecord('tbl_schools',' * ', array('id'=>$eventRows['organizing_school'],'status'=>'1'));
//Get Department Details
$departmentRows = $this->Events_Model->getSingleRecord('tbl_departments',' * ', array('id'=>$eventRows['organizing_departments'],'status'=>'1'));
$recorddetail = $this->Events_Model->getSingleRecord('tbl_admin','id,userName,first_name,last_name, contact_number,email_id', array('id'=>$eventRows['author_id'],'status'=>'1'));
$deanDetails = $this->Events_Model->getSingleRecord('tbl_admin','*', array('status'=>'1','role_id'=>'3'));
$to_emails = $deanDetails['email_id']; // $menteeDetails['email_id'];
$faculty = $recorddetail['first_name'].' '.$recorddetail['last_name'];
$contact_number = $recorddetail['contact_number'];
$email_id = $recorddetail['email_id'];
// Get Events Details
$contact_name = $eventOrgRows['contact_name'].' | '.$eventOrgRows['phone'].' | '.$eventOrgRows['email'];
$EVENT_VENUE = $eventLocRows['venue_name'].','.$eventLocRows['address'];
$EVENT_DATE = $eventDateRows['start_date'].' - '.$eventDateRows['start_time'];
$EVENT_TITLE = $eventRows['event_title'];
$SCHOOL_NAME = $schoolRows['school_name'];
$DEPARTMENT_NAME = $departmentRows['department_name'];
//print_r($faculty);die;events/viewevent/28
$url = base_url('admin/events/viewevent/'.$eventRows['id']);
$message = $this->load->view('admin/email_template/email_to_hod', $params, true);
$message = str_replace('##SCHOOL_NAME##',$SCHOOL_NAME,$message);
$message = str_replace('##DEPARTMENT_NAME##',$DEPARTMENT_NAME,$message);
$message = str_replace('##EVENT_TITLE##',$EVENT_TITLE,$message);
$message = str_replace('##EVENT_DATE##',$EVENT_DATE,$message);
$message = str_replace('##EVENT_VENUE##',$EVENT_VENUE,$message);
$message = str_replace('##CONTACT_PERSON##',$contact_name,$message);
$message = str_replace('##NAME##',$faculty,$message);
$message = str_replace('##SPOKE_CONTACT##',$contact_number,$message);
$message = str_replace('##SPOKE_EMAIL##',$email_id,$message);
$message = str_replace('##URL##',$url,$message);
$subject = 'Action Required: Important Updates for Your Immediate Attention';
//$emailResp = send_email_pepipost($to_emails, $subject, $message);
$emailResp = sendSMTPCommonEmail($to_emails, $subject, $message);
if($emailResp)
{
$this->session->set_flashdata('success', 'Email send successfully');
} else {
$this->session->set_flashdata('success', 'Email send successfully');
}
setHistory('mail send successfully');
}
//sending report to concered dean
public function updateToDean($uid)
{
$data = array();
$params = array();
$author_id = $userArray->id;
$eventRows = $this->Events_Model->getSingleRecord('tbl_event_master',' * ', array('id'=>$uid));
$eventOrgRows = $this->Events_Model->getSingleRecord('tbl_event_organizer_contactinfo',' * ', array('event_id'=>$eventRows['id'],'status'=>'1'));
$eventLocRows = $this->Events_Model->getSingleRecord('tbl_event_location_details',' * ', array('event_id'=>$eventRows['id'],'status'=>'1'));
$eventDateRows = $this->Events_Model->getSingleRecord('tbl_event_date_time',' * ', array('event_id'=>$eventRows['id'],'status'=>'1'));
// Get School Details
$schoolRows = $this->Events_Model->getSingleRecord('tbl_schools',' * ', array('id'=>$eventRows['organizing_school'],'status'=>'1'));
//Get Department Details
$departmentRows = $this->Events_Model->getSingleRecord('tbl_departments',' * ', array('id'=>$eventRows['organizing_departments'],'status'=>'1'));
$recorddetail = $this->Events_Model->getSingleRecord('tbl_admin','id,userName,first_name,last_name, contact_number,email_id', array('id'=>$eventRows['author_id'],'status'=>'1'));
$deanDetails = $this->Events_Model->getSingleRecord('tbl_admin','*', array('school_id'=>$eventRows['organizing_school'],'status'=>'1','role_id'=>'4'));
$to_emails = $deanDetails['email_id']; // $menteeDetails['email_id'];
$faculty = $recorddetail['first_name'].' '.$recorddetail['last_name'];
$contact_number = $recorddetail['contact_number'];
$email_id = $recorddetail['email_id'];
// Get Events Details
$contact_name = $eventOrgRows['contact_name'].' | '.$eventOrgRows['phone'].' | '.$eventOrgRows['email'];
$EVENT_VENUE = $eventLocRows['venue_name'].', '.$eventLocRows['address'];
$EVENT_DATE = $eventDateRows['start_date'].' - '.$eventDateRows['start_time'];
$EVENT_TITLE = $eventRows['event_title'];
$SCHOOL_NAME = $schoolRows['school_name'];
$DEPARTMENT_NAME = $departmentRows['department_name'];
//print_r($faculty);die;events/viewevent/28
$url = base_url('admin/events/viewevent/'.$eventRows['id']);
$message = $this->load->view('admin/email_template/email_to_hod', $params, true);
$message = str_replace('##SCHOOL_NAME##',$SCHOOL_NAME,$message);
$message = str_replace('##DEPARTMENT_NAME##',$DEPARTMENT_NAME,$message);
$message = str_replace('##EVENT_TITLE##',$EVENT_TITLE,$message);
$message = str_replace('##EVENT_DATE##',$EVENT_DATE,$message);
$message = str_replace('##EVENT_VENUE##',$EVENT_VENUE,$message);
$message = str_replace('##CONTACT_PERSON##',$contact_name,$message);
$message = str_replace('##NAME##',$faculty,$message);
$message = str_replace('##SPOKE_CONTACT##',$contact_number,$message);
$message = str_replace('##SPOKE_EMAIL##',$email_id,$message);
$message = str_replace('##URL##',$url,$message);
$subject = 'Action Required: Important Updates for Your Immediate Attention';
//$emailResp = send_email_pepipost($to_emails, $subject, $message);
$emailResp = sendSMTPCommonEmail($to_emails, $subject, $message);
if($emailResp)
{
$this->session->set_flashdata('success', 'Email send successfully');
} else {
$this->session->set_flashdata('success', 'Email send successfully');
}
setHistory('mail send successfully');
}
/*
* Function : updateToAuthor
* Desc:
*/
public function updateToAuthor($uid, $msg = '')
{
$data = array();
$params = array();
$author_id = $userArray->id;
$eventRows = $this->Events_Model->getSingleRecord('tbl_event_master',' * ', array('id'=>$uid));
$eventOrgRows = $this->Events_Model->getSingleRecord('tbl_event_organizer_contactinfo',' * ', array('event_id'=>$eventRows['id'],'status'=>'1'));
$eventLocRows = $this->Events_Model->getSingleRecord('tbl_event_location_details',' * ', array('event_id'=>$eventRows['id'],'status'=>'1'));
$eventDateRows = $this->Events_Model->getSingleRecord('tbl_event_date_time',' * ', array('event_id'=>$eventRows['id'],'status'=>'1'));
// Get School Details
$schoolRows = $this->Events_Model->getSingleRecord('tbl_schools',' * ', array('id'=>$eventRows['organizing_school'],'status'=>'1'));
//Get Department Details
$departmentRows = $this->Events_Model->getSingleRecord('tbl_departments',' * ', array('id'=>$eventRows['organizing_departments'],'status'=>'1'));
$recorddetail = $this->Events_Model->getSingleRecord('tbl_admin','id,userName,first_name,last_name, contact_number,email_id', array('id'=>$eventRows['author_id'],'status'=>'1','role_id'=>'7'));
$to_emails = $recorddetail['email_id']; // $menteeDetails['email_id'];
$faculty = $recorddetail['first_name'].' '.$recorddetail['last_name'];
$contact_number = $recorddetail['contact_number'];
$email_id = $recorddetail['email_id'];
// Get Events Details
$contact_name = $eventOrgRows['contact_name'].' | '.$eventOrgRows['phone'].' | '.$eventOrgRows['email'];
$EVENT_VENUE = $eventLocRows['venue_name'].', '.$eventLocRows['address'];
$EVENT_DATE = $eventDateRows['start_date'].' - '.$eventDateRows['start_time'];
$EVENT_TITLE = $eventRows['event_title'];
$SCHOOL_NAME = $schoolRows['school_name'];
$DEPARTMENT_NAME = $departmentRows['department_name'];
//print_r($faculty);die;events/viewevent/28
$url = base_url('admin/events/viewevent/'.$eventRows['id']);
$message = $this->load->view('admin/email_template/email_to_author', $params, true);
$message = str_replace('##SCHOOL_NAME##',$SCHOOL_NAME,$message);
$message = str_replace('##DEPARTMENT_NAME##',$DEPARTMENT_NAME,$message);
$message = str_replace('##EVENT_TITLE##',$EVENT_TITLE,$message);
$message = str_replace('##EVENT_DATE##',$EVENT_DATE,$message);
$message = str_replace('##EVENT_VENUE##',$EVENT_VENUE,$message);
$message = str_replace('##CONTACT_PERSON##',$contact_name,$message);
$message = str_replace('##NAME##',$faculty,$message);
$message = str_replace('##SPOKE_CONTACT##',$contact_number,$message);
$message = str_replace('##SPOKE_EMAIL##',$email_id,$message);
$message = str_replace('##URL##',$url,$message);
$message = str_replace('##MSG##',$msg,$message);
$subject = 'Events Remarks!!';
//$emailResp = send_email_pepipost($to_emails, $subject, $message);
$emailResp = sendSMTPCommonEmail($to_emails, $subject, $message);
if($emailResp)
{
$this->session->set_flashdata('success', 'Email send successfully');
} else {
$this->session->set_flashdata('success', 'Email send successfully');
}
setHistory('mail send successfully');
//redirect('admin/events/index');
}
/*
* Function : updateToHod
* Desc:
*/
public function updateToHod($uid)
{
$data = array();
$params = array();
$author_id = $userArray->id;
$eventRows = $this->Events_Model->getSingleRecord('tbl_event_master',' * ', array('id'=>$uid));
$eventOrgRows = $this->Events_Model->getSingleRecord('tbl_event_organizer_contactinfo',' * ', array('event_id'=>$eventRows['id'],'status'=>'1'));
$eventLocRows = $this->Events_Model->getSingleRecord('tbl_event_location_details',' * ', array('event_id'=>$eventRows['id'],'status'=>'1'));
$eventDateRows = $this->Events_Model->getSingleRecord('tbl_event_date_time',' * ', array('event_id'=>$eventRows['id'],'status'=>'1'));
// Get School Details
$schoolRows = $this->Events_Model->getSingleRecord('tbl_schools',' * ', array('id'=>$eventRows['organizing_school'],'status'=>'1'));
//Get Department Details
$departmentRows = $this->Events_Model->getSingleRecord('tbl_departments',' * ', array('id'=>$eventRows['organizing_departments'],'status'=>'1'));
$recorddetail = $this->Events_Model->getSingleRecord('tbl_admin','id,userName,first_name,last_name, contact_number,email_id', array('id'=>$eventRows['author_id'],'status'=>'1'));
$HODDetails = $this->Events_Model->getSingleRecord('tbl_admin','*', array('school_id'=>$eventRows['organizing_school'],'department_id'=>$eventRows['organizing_departments'],'status'=>'1','role_id'=>'5'));
$to_emails = $HODDetails['email_id']; // $menteeDetails['email_id'];
$faculty = $recorddetail['first_name'].' '.$recorddetail['last_name'];
$contact_number = $recorddetail['contact_number'];
$email_id = $recorddetail['email_id'];
// Get Events Details
$contact_name = $eventOrgRows['contact_name'].' | '.$eventOrgRows['phone'].' | '.$eventOrgRows['email'];
$EVENT_VENUE = $eventLocRows['venue_name'].', '.$eventLocRows['address'];
$EVENT_DATE = $eventDateRows['start_date'].' - '.$eventDateRows['start_time'];
$EVENT_TITLE = $eventRows['event_title'];
$SCHOOL_NAME = $schoolRows['school_name'];
$DEPARTMENT_NAME = $departmentRows['department_name'];
//print_r($faculty);die;events/viewevent/28
$url = base_url('admin/events/viewevent/'.$eventRows['id']);
$message = $this->load->view('admin/email_template/email_to_hod', $params, true);
$message = str_replace('##SCHOOL_NAME##',$SCHOOL_NAME,$message);
$message = str_replace('##DEPARTMENT_NAME##',$DEPARTMENT_NAME,$message);
$message = str_replace('##EVENT_TITLE##',$EVENT_TITLE,$message);
$message = str_replace('##EVENT_DATE##',$EVENT_DATE,$message);
$message = str_replace('##EVENT_VENUE##',$EVENT_VENUE,$message);
$message = str_replace('##CONTACT_PERSON##',$contact_name,$message);
$message = str_replace('##NAME##',$faculty,$message);
$message = str_replace('##SPOKE_CONTACT##',$contact_number,$message);
$message = str_replace('##SPOKE_EMAIL##',$email_id,$message);
$message = str_replace('##URL##',$url,$message);
$subject = 'Action Required: Important Updates for Your Immediate Attention';
//$emailResp = send_email_pepipost($to_emails, $subject, $message);
$emailResp = sendSMTPCommonEmail($to_emails, $subject, $message);
if($emailResp)
{
$this->session->set_flashdata('success', 'Email send successfully');
} else {
$this->session->set_flashdata('success', 'Email send successfully');
}
setHistory('mail send successfully');
//redirect('admin/events/index');
}
/*
* Function : uploadDocuments
* Description : Upload the documents
*/
private function uploadDocuments($file_name, $old_file='')
{
$config['upload_path'] = './attachments/files/';
$config['allowed_types'] = 'gif|jpg|png|jpeg|JPG|PNG|JPEG|PDF|pdf|SVG|svg|avi|mp4|3gp|mpeg|mpg|mov|mp3|flv|wmv';
$config['remove_spaces'] = TRUE;
$config['overwrite'] = TRUE;
$this->load->library('upload', $config);
$this->upload->initialize($config);
if (!$this->upload->do_upload($file_name)) {
log_message('error', 'Image Upload Error: ' . $this->upload->display_errors());
//print_r($this->upload->display_errors()); die;
} else {
if($old_file!=''){
$path = './attachments/files/'.$old_file;
unlink($path);
}
}
$doc = $this->upload->data();
return $doc['file_name'];
}
private function uploadbanner($file_name, $old_file='')
{
$config['upload_path'] = './attachments/files/banner_image/';
$config['allowed_types'] = 'gif|jpg|png|jpeg|JPG|PNG|JPEG|PDF|pdf|SVG|svg|avi|mp4|3gp|mpeg|mpg|mov|mp3|flv|wmv';
$config['remove_spaces'] = TRUE;
$config['overwrite'] = TRUE;
$config['max_size'] = 2097152;
$this->load->library('upload', $config);
$this->upload->initialize($config);
if (!$this->upload->do_upload($file_name)) {
log_message('error', 'Image Upload Error: ' . $this->upload->display_errors());
//print_r($this->upload->display_errors()); die;
} else {
if($old_file!=''){
$path = './attachments/files/banner_image/'.$old_file;
unlink($path);
}
}
$doc = $this->upload->data();
return $doc['file_name'];
}
public function getschoolrecord()
{
$campus_id = $_POST['campus_id'];
if($campus_id>0)
{
$data_records = $this->Events_Model->getCommonIdArray('tbl_schools','id,school_name',array('campus_id'=>$campus_id));
$response = array();
foreach($data_records as $row)
{
$response[$row['id']] = $row['school_name'];
}
header('Content-type: application/json');
echo json_encode($response);
}
exit;
}
/*
* Function : getdepratmentrecord
*
*
*/
public function getdepratmentrecord()
{
$school_id = $_POST['school_id'];
if($school_id>0)
{
$data_records = $this->Events_Model->getCommonIdArray('tbl_departments','id,department_name',array('school_id'=>$school_id));
$response = array();
foreach($data_records as $row)
{
$response[$row['id']] = $row['department_name'];
}
header('Content-type: application/json');
echo json_encode($response);
}
exit;
}
/*
* Function : getplanrecord
*
*
*/
public function getplanrecord()
{
$course_id = $_POST['course_id'];
if($course_id>0)
{
$data_records = $this->Events_Model->getCommonIdArray('tbl_plan_master','id,plan_name',array('course_id'=>$course_id));
$response = array();
foreach($data_records as $row)
{
$response[$row['id']] = $row['plan_name'];
}
header('Content-type: application/json');
echo json_encode($response);
}
exit;
}
/*
* Function : getsubjectrecord
*
*
*/
public function getsubjectrecord()
{
$plan_id = $_POST['plan_id'];
if($plan_id>0)
{
$data_records = $this->Events_Model->getCommonIdArray('tbl_subject_master','id,subject_name',array('plan_id'=>$plan_id));
$response = array();
foreach($data_records as $row)
{
$response[$row['id']] = $row['subject_name'];
}
header('Content-type: application/json');
echo json_encode($response);
}
exit;
}
/*
* Function : getclassrecord
*
*
*/
public function getclassrecord()
{
$subject_id = $_POST['subject_id'];
if($subject_id>0)
{
$data_records = $this->Events_Model->getCommonIdArray('tbl_class_master','id,class_name',array('subject_id'=>$subject_id));
$response = array();
foreach($data_records as $row)
{
$response[$row['id']] = $row['class_name'];
}
header('Content-type: application/json');
echo json_encode($response);
}
exit;
}
public function getajaxrecord()
{
$school_id = $_POST['school_id'];
if($school_id>0)
{
$data_records = $this->Common_Model->getCommonIdArray('tbl_departments','id,department_name',array('school_id'=>$school_id));
$response = array();
foreach($data_records as $row)
{
$response[$row['id']] = $row['department_name'];
}
$response['21'] = 'Others';
header('Content-type: application/json');
echo json_encode($response);
}
exit;
}
public function getajaxdepartment()
{
$school_id = $_POST['school_id'];
if($school_id>0)
{
$data_records = $this->Common_Model->getCommonIdArray('tbl_mentee_departments','id,department_name',array('school_id'=>$school_id));
$response = array();
foreach($data_records as $row)
{
$response[$row['id']] = $row['department_name'];
}
$response['21'] = 'Others';
header('Content-type: application/json');
echo json_encode($response);
}
exit;
}
/*
* Function : viewevent
*
*
*/
public function viewevent($id='')
{
$data = array();
$role_id = $this->session->userdata('role_id');
$author_id = $this->session->userdata('adid')->id;
if($_POST['save']=='Save')
{
$dataArray = array();
$dataArray['admin_id'] = $author_id;
$dataArray['event_status'] = $_POST['event_status'];
$dataArray['comment'] = $_POST['comment'];
$dataArray['author_id'] = $_POST['author_id'];
$dataArray['role_id'] = $role_id;
$dataArray['event_id'] = $_POST['event_id'];
$dataArray['createdon'] = date('Y-m-d H:i:s');
$eventId = $this->Events_Model->saveinfo($tbl_name='tbl_event_approval_transaction',$dataArray);
$approved_by = '';
if($_POST['event_status']=='5')
{
if($role_id=='5'){
$evmArray = array('verified_hod'=>'1');
$approved_by = "HOD";
$this->updateToAuthor($id, 'Event Approved By HOD');
$this->updateToDean($id);
} else if($role_id=='4'){
$evmArray = array('verified_hod'=>'1','verified_dean'=>'1');
$approved_by = "DEAN";
$this->updateToIqac($id);
$this->updateToAuthor($id, 'Event Approved By School Dean');
} else if($role_id=='3'){
$evmArray = array('verified_hod'=>'1','verified_dean'=>'1','verified_iqac'=>'1');
$approved_by = "IQAC";
$this->updateToAuthor($id, 'Event Approved By IQAC & Published Successfully');
}
$this->Events_Model->updateinfo($tbl_name='tbl_event_master',$evmArray,'id',$id);
}
// Send Alert email to user
//$this->sendreportdetails($eventId);
//email whats happing
if($_POST['event_status']=='5' && $role_id=='3')
{
//$this->sendreportdetails($eventId);
$this->email($id);
} else{
$this->sendreportdetails($eventId, $approved_by);
}
redirect('admin/events/viewevent/'.$_POST['event_id']);
}
$data['recordsArray'] = $eventdetails = $this->Events_Model->getSingleEventDetails($id);
// Get Category
$data['categoryListArray'] = $this->Events_Model->getAllModuleList('tbl_category');
$trnsArray = array();
$trnsArray['event_id'] = $id;
if(in_array($role_id, array('6','5','4','3')))
{
$trnsArray['admin_id'] = $author_id;
}
$data['audiencedetail'] = $this->Events_Model->getAllModuleList('tbl_target_audiences','id,title', array('status'=>'1'), explode(',',$eventdetails['target_audiences']), 'id');
$data['approvalListArray'] = $approvalListArray = $this->Events_Model->getTransactionDetails(NULL,$trnsArray);
// Get Tags
$data['tagsListArray'] = $this->Events_Model->getAllModuleList('tbl_tags');
// Get Tags
$data['deptListArray'] = $this->Events_Model->getAllModuleList('tbl_departments');
$data['statusArray'] = $this->Events_Model->getAllModuleList('tbl_status_master','id,display_name', array('event_status'=>'1'));
$data['sd'] = $this->Events_Model->getSingleRecord('tbl_event_master',' * ', array('id'=>$id));
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/events/view_event',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to view video');
}
/*
* Functon : sendreportdetails
*sending report to concer faculty
*
*
*/
public function sendreportdetails($uid, $approvalRole='')
{
$data = array();
$params = array();
$author_id = $userArray->id;
$muid = $uid;
$event_remark = $this->Events_Model->getSingleRecord('tbl_event_approval_transaction','*', array('id'=>$muid, 'status'=>'1', 'is_deleted'=>'0'), array('id'=>'DESC'));
$row = $this->Events_Model->getAllModuleList('tbl_status_master','id', array('status'=>'1'));
$eventRows = $this->Events_Model->getSingleRecord('tbl_event_master',' * ', array('id'=>$event_remark['event_id']));
$eventOrgRows = $this->Events_Model->getSingleRecord('tbl_event_organizer_contactinfo',' * ', array('event_id'=>$event_remark['event_id'],'status'=>'1'));
$eventLocRows = $this->Events_Model->getSingleRecord('tbl_event_location_details',' * ', array('event_id'=>$event_remark['event_id'],'status'=>'1'));
$eventDateRows = $this->Events_Model->getSingleRecord('tbl_event_date_time',' * ', array('event_id'=>$event_remark['event_id'],'status'=>'1'));
// Get School Details
$schoolRows = $this->Events_Model->getSingleRecord('tbl_schools',' * ', array('id'=>$eventRows['organizing_school'],'status'=>'1'));
//Get Department Details
$departmentRows = $this->Events_Model->getSingleRecord('tbl_departments ',' * ', array('id'=>$eventRows['organizing_departments'],'status'=>'1'));
//var_dump($row);die;
$status_remark = $this->Events_Model->getAllModuleList('tbl_status_master','id,display_name', array('status'=>'1'));
$recorddetail = $this->Events_Model->getAllModuleList('tbl_admin','id,userName,first_name,last_name, contact_number,email_id', array('status'=>'1','role_id'=>'7'));
$inspector = $this->Events_Model->getAllModuleList('tbl_admin','id,userName, first_name,last_name, contact_number,email_id', array('status'=>'1'));
$to_emails = $recorddetail['email_id']; // $menteeDetails['email_id'];
$approved_by =$inspector[$event_remark['admin_id']]['first_name'].' '.$inspector[$event_remark['admin_id']]['last_name'].' | '.$inspector[$event_remark['admin_id']]['contact_number'].' | '.$inspector[$event_remark['admin_id']]['email_id']; // $menteeDetails['email_id'];
$comment = $event_remark['comment'];
$status = $status_remark[$event_remark['event_status']]['display_name'];
$faculty = $recorddetail[$event_remark['author_id']]['first_name'].' '.$recorddetail[$event_remark['author_id']]['last_name'];
$contact_number = $recorddetail[$event_remark['author_id']]['contact_number'];
$email_id = $recorddetail[$event_remark['author_id']]['email_id'];
// Get Events Details
$contact_name = $eventOrgRows['contact_name'].' | '.$eventOrgRows['phone'].' | '.$eventOrgRows['email'];
$EVENT_VENUE = $eventLocRows['venue_name'].', '.$eventLocRows['address'];
$EVENT_DATE = $eventDateRows['start_date'].' - '.$eventDateRows['start_time'];
$EVENT_TITLE = $eventRows['event_title'];
$SCHOOL_NAME = $schoolRows['school_name'];
$DEPARTMENT_NAME = $departmentRows['department_name'];
//print_r($faculty);die;
$url = base_url('admin/events/viewevent/'.$event_remark['event_id']);
$message = $this->load->view('admin/email_template/event_credentials_email', $params, true);
$message = str_replace('##SCHOOL_NAME##',$SCHOOL_NAME,$message);
$message = str_replace('##DEPARTMENT_NAME##',$DEPARTMENT_NAME,$message);
$message = str_replace('##EVENT_TITLE##',$EVENT_TITLE,$message);
$message = str_replace('##EVENT_DATE##',$EVENT_DATE,$message);
$message = str_replace('##EVENT_VENUE##',$EVENT_VENUE,$message);
$message = str_replace('##CONTACT_PERSON##',$contact_name,$message);
$message = str_replace('##NAME##',$faculty,$message);
$message = str_replace('##SPOKE_CONTACT##',$contact_number,$message);
$message = str_replace('##SPOKE_EMAIL##',$email_id,$message);
$message = str_replace('##URL##',$url,$message);
$message = str_replace('##EXAMINED##',$approved_by,$message);
$message = str_replace('##STATUS##',$status,$message);
$message = str_replace('##COMMENT##',$comment,$message);
$subject = $approvalRole.' Event Approval Remarks!!';
//$emailResp = send_email_pepipost($to_emails, $subject, $message);
$emailResp = sendSMTPCommonEmail($to_emails, $subject, $message);
if($emailResp)
{
$this->session->set_flashdata('success', 'Email send successfully');
} else {
$this->session->set_flashdata('success', 'Email send successfully');
}
setHistory('mail send successfully');
redirect('admin/events/viewevent/'.$_POST['event_id']);
}
//sending email
public function email($uid)
{
$data = array();
$params = array();
$author_id = $userArray->id;
$muid = $uid;
$eventdetails = $this->Events_Model->getSingleRecord('tbl_event_master','*', array('id'=>$muid, 'is_deleted'=>'0'));
$event_address = $this->Events_Model->getSingleRecord('tbl_event_location_details','*', array('id'=>$muid, 'status'=>'1', 'is_deleted'=>'0'));
$event_date = $this->Events_Model->getSingleRecord('tbl_event_date_time','*', array('event_id'=>$muid, 'status'=>'1', 'is_deleted'=>'0'));
$schoolName = $this->Events_Model->getAllModuleList('tbl_schools','id,school_name', array('status'=>'1'));
$audiencedetail = $this->Events_Model->getAllModuleList('tbl_target_audiences','id,email', array('status'=>'1'), explode(',',$eventdetails['target_audiences']), 'id');
$departmentRows = $this->Events_Model->getSingleRecord('tbl_departments ',' * ', array('id'=>$eventdetails['organizing_departments'],'status'=>'1'));
$eventOrgRows = $this->Events_Model->getSingleRecord('tbl_event_organizer_contactinfo',' * ', array('event_id'=>$eventdetails['id'],'status'=>'1'));
$eventLocRows = $this->Events_Model->getSingleRecord('tbl_event_location_details',' * ', array('event_id'=>$eventdetails['id'],'status'=>'1'));
$toEmailIds = array();
foreach($audiencedetail as $trow){
$toEmailIds[] = trim($trow['email']);
}
//print_r($audiencedetail);
$to_emails = implode(',',$toEmailIds); // $menteeDetails['email_id'];
$school = $schoolName[$eventdetails['organizing_school']]['school_name'];
$DEPARTMENT_NAME = $departmentRows['department_name'];
$mentor_email = $mentorDetails['email_id'];
$objective = $eventdetails['objective_of_event'];
$EVENT_TITLE = $eventdetails['event_title'];
$slug = base_url('events/'.$eventdetails['event_slug'].'?id='.$eventdetails['id']);
//$banner = $eventdetails['banner_image'];
if(!in_array(strip_tags($eventdetails['convener_details']), array("NA",'null','NR','zero','none','0','.','-'))){
$convener = $eventdetails['convener_details'];
$convener = str_replace('NA', '', $convener);
}
if(!in_array(strip_tags($eventdetails['coordinator_details']), array("NA",'null','NR','zero','none','0','.','-'))){
$coordinator_details = $eventdetails['coordinator_details'];
$coordinator_details = str_replace('NA', '', $coordinator_details);
}
$event_details = $eventdetails['event_details'];
if(!in_array(strip_tags($eventdetails['chief_guest_affiliation']), array("NA",'null','NR','zero','none','0','.','-'))){
$chief_guest_affiliation = $eventdetails['chief_guest_affiliation'];
$chief_guest_affiliation = str_replace('NA', '', $chief_guest_affiliation);
}
if(!in_array(strip_tags($eventdetails['speakers_1']), array("NA",'null','NR','zero','none','0','.','-'))){
$speakers_1 = $eventdetails['speakers_1'];
$speakers_1 = str_replace('NA', '', $speakers_1);
}
$affiliation_of_speakers = $eventdetails['affiliation_of_speakers'];
$affiliation_organization = $eventdetails['affiliation_organization'];
$spc_row = '';
$spklist = explode(';', $speakers_1);
$affiliationlist = explode(',', $affiliation_of_speakers);
$affiliationOrglist = explode(',', $affiliation_organization);
$spc_row .= '<ul>';
foreach($spklist as $key=>$speaker) {
//$spc_row .= '<p>'.$speaker.' - '.$affiliationOrglist[$key].' - '.$affiliationlist[$key].'</p>';
$spc_row .= '<li>'.$speaker.'</li>';
}
$spc_row .= '</ul>';
$speakers = $spc_row;
$venue = $event_address['venue_name'];
$address = $event_address['address'];
$date = $event_date['start_date'];
$time = $event_date['start_time'];
$end_date = $event_date['end_date'];
$end_time = $event_date['end_time'];
if(strtotime($event_date['end_date'])>0 && strtotime($event_date['start_date'])) {
$EVENT_SDATE = date('d M Y', strtotime($event_date['start_date'])).' - '.date('d M Y', strtotime($event_date['end_date']));
$EVENT_SDATE_TIME = $event_date['start_time'].' - '.$event_date['end_time'];
} else {
$EVENT_SDATE = date('d M Y', strtotime($event_date['start_date']));
$EVENT_SDATE_TIME = $event_date['start_time'];
}
$contact_name = $eventOrgRows['contact_name'].' | '.$eventOrgRows['phone'].' | '.$eventOrgRows['email'];
$EVENT_VENUE = $eventLocRows['venue_name'].', '.$eventLocRows['address'];
$url = base_url('admin/events/viewevent/'.$eventdetails['id']);
if(empty($chief_guest_affiliation)){
$message = $this->load->view('admin/email_template/events_what_happing_without_aff', $params, true);
} else if(empty($coordinator_details)){
$message = $this->load->view('admin/email_template/events_what_happing_without_coord', $params, true);
} else if(empty($speakers)){
$message = $this->load->view('admin/email_template/events_what_happing_without_speakers', $params, true);
} else if(empty($coordinator_details) && empty($chief_guest_affiliation)) {
$message = $this->load->view('admin/email_template/events_what_happing_without_coord_aff', $params, true);
} else {
$message = $this->load->view('admin/email_template/events_what_happing', $params, true);
}
$message = str_replace('##SCHOOL_NAME##',$school,$message);
$message = str_replace('##DEPARTMENT_NAME##',$DEPARTMENT_NAME,$message);
$message = str_replace('##EVENT_TITLE##',strip_tags($EVENT_TITLE),$message);
$message = str_replace('##EVENT_OVERVIEW##',$event_details,$message);
$message = str_replace('##OBJECTIVE##',$objective,$message);
$message = str_replace('##SPEAKERS_DETAILS##',$speakers,$message);
$message = str_replace('##COORDINATOR##',$coordinator_details,$message);
$message = str_replace('##CHEIF_AFFILIATION##',$chief_guest_affiliation,$message);
$message = str_replace('##EVENT_SDATE##',$EVENT_SDATE,$message);
$message = str_replace('##EVENT_EDATE##',$EVENT_SDATE_TIME,$message);
$message = str_replace('##EVENT_VENUE##',$EVENT_VENUE,$message);
$message = str_replace('##CONTACT_PERSON##',$contact_name,$message);
$message = str_replace('##CONVENER##',$convener,$message);
$message = str_replace('##SLUG##',$slug,$message);
$message = str_replace('##URL##',$slug,$message);
$subject = $EVENT_TITLE;
//$to_emails = array('amit.verma@shardatech.org');
$attach_path = '';
if($eventdetails['banner_image']!=''){
$basePath="/var/www/html/www.shardaevents.com/attachments/files/banner_image/".$eventdetails['banner_image'];
$attach_path =$basePath;
}
//$emailResp = send_email_pepipost($to_emails, $subject, $message);
setHistory("Success:: Email send successfully : $to_emails");
$emailResp = sendSMTPCommonAllEmail($to_emails, $subject, $message,$attach_path);
if($emailResp)
{
$this->session->set_flashdata('success', 'Email send successfully');
} else {
$this->session->set_flashdata('success', 'Email send successfully');
}
setHistory('mail send successfully');
//redirect('admin/events/viewevent/'.$_POST['event_id']);
}
// uploading images
public function uploadpictures($event_id='')
{
$userArray = $this->session->userdata('adid');
$role_id = $this->session->userdata('role_id');
$author_id = $this->session->userdata('adid')->id;
//$muid = base64_decode($uid);
$data = array();
if($_POST){
if(isset($_FILES))
$image=$this->uploadmultipleimages();
if(!empty($image)) {
foreach ($image as $picture) {
$event_id = $_POST['event_id'];
$data = array(
'image' => $picture,
'event_id' => $_POST['event_id'],
'title' => $picture,
'status' => '1',
'is_deleted'=> '0',
'createdon' => date('Y-m-d H:i:s')
);
$this->Events_Model->saveinfo($tbl_name='tbl_event_images',$data);
}
setHistory('image added successfully');
redirect('admin/events/uploadpictures/'.$event_id);
} else {
echo 'Image upload failed.';
}
} else {
$data['pictures'] = $this->Events_Model->getCommonIdArray('tbl_event_images','*', array('event_id'=>$event_id));
// echo "<pre>"; print_r($data);die;
$data['recordsArray'] = $this->Events_Model->getSingleEventDetails($event_id);
//print_r($data);die;
//load the error and success messages
$data['errors'] = $this->error;
$data['success'] = $this->success;
setHistory('Go to upload images module');
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/events/addimages',$data);
$this->load->view('admin/_parts/footer');
}
}
// uploading videos
public function uploadvideos($event_id='')
{
$userArray = $this->session->userdata('adid');
$role_id = $this->session->userdata('role_id');
$author_id = $this->session->userdata('adid')->id;
//$muid = base64_decode($uid);
$data = array();
if($_POST){
$video=$this->uploadvideo($file_name='video', $old_image);
if($old_video<>'' && $video=='') {
$video = $old_video;
}
$event_id = $_POST['event_id'];
$link = $_POST['drive_link'];
$data = array(
'video'=>$video,
'title'=>$video,
'google_link'=>$link,
'status'=>'1',
'event_id'=>$_POST['event_id'],
'is_deleted'=>'0'
);
$data['createdon'] = date('Y-m-d H:i:s');
$this->Events_Model->saveinfo($tbl_name='tbl_event_videos',$data);
setHistory('Report added successfully');
redirect('admin/events/uploadvideos/'.$event_id);
}
else {
$data['videos'] = $this->Events_Model->getCommonIdArray('tbl_event_videos','*', array('event_id'=>$event_id));
//print_r($data);die;
setHistory('Go to upload video module');
$data['recordsArray'] = $this->Events_Model->getSingleEventDetails($event_id);
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/events/addvideos',$data);
$this->load->view('admin/_parts/footer');
}
}
/*
* Function: uploadbudgetbpprovalreport
* Desc: uploading uploadbudgetbpprovalreport
*
*/
public function uploadbudgetbpprovalreport($event_id='')
{
$userArray = $this->session->userdata('adid');
$role_id = $this->session->userdata('role_id');
$author_id = $this->session->userdata('adid')->id;
//$muid = base64_decode($uid);
if($_POST){
$oldFile = $_POST['old_report'];
$report=$this->reportfile($file_name='report', $old_report);
if($old_report<>'' && $report=='') {
$report = $old_report;
}
$event_id = $_POST['event_id'];
$data = array(
'report'=>$report,
'title'=>$report,
'status'=>'1',
'verified_dm'=> '1',
'event_id'=>$_POST['event_id'],
'is_deleted'=>'0'
);
//print_r($data); die;
if($_POST['edit_id']=='') {
$data['createdon'] = date('Y-m-d H:i:s');
$this->Events_Model->saveinfo($tbl_name='tbl_event_budget_report',$data);
setHistory('Report added successfully');
} else {
$this->Events_Model->updateinfo($tbl_name='tbl_event_budget_report',$evmArray,'id',$_POST['edit_id']);
}
redirect('admin/events/uploadbudgetbpprovalreport/'.$event_id);
}
else {
$data['reportArray'] = $this->Events_Model->getCommonIdArray('tbl_event_budget_report','*', array('event_id'=>$event_id));
//print_r($data);die;
$data['recordsArray'] = $this->Events_Model->getSingleEventDetails($event_id);
if($_GET['edit']>0){
$data['sd'] = $this->Events_Model->getSingleRecord('tbl_event_budget_report',' * ', array('id'=>$_GET['edit'],'status'=>'1'));
}
if($_GET['id']>0) {
$id = $_GET['id'];
$this->Events_Model->deleterecords('tbl_event_budget_report',$id);
$this->session->set_flashdata('success', 'Report deleted');
setHistory('Report deleted successfully');
redirect('admin/events/uploadbudgetbpprovalreport/'.$event_id);
}
//print_r($data);die;
//load the error and success messages
$data['errors'] = $this->error;
$data['success'] = $this->success;
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/events/adduploadbudgetbpprovalreport',$data);
$this->load->view('admin/_parts/footer');
}
}
// uploading reports
public function uploadreport($event_id='')
{
$userArray = $this->session->userdata('adid');
$role_id = $this->session->userdata('role_id');
$author_id = $this->session->userdata('adid')->id;
//$muid = base64_decode($uid);
if($_POST){
$old_report = $_POST['old_report'];
$report=$this->reportfile($file_name='report', $old_report);
if($old_report<>'' && $report=='') {
$report = $old_report;
}
$event_id = $_POST['event_id'];
$data = array(
'report'=>$report,
'title'=>$report,
'status'=>'1',
'verified_dm'=> '1',
'event_id'=>$_POST['event_id'],
'is_deleted'=>'0'
);
//print_r($data); die;
if($_POST['edit_report_id']=='') {
$data['createdon'] = date('Y-m-d H:i:s');
$this->Events_Model->saveinfo($tbl_name='tbl_event_report',$data);
setHistory('Report added successfully');
} else {
$this->Events_Model->updateinfo($tbl_name='tbl_event_report',$data,'id',$_POST['edit_report_id']);
setHistory('Report updated successfully');
}
setHistory('Report added successfully');
redirect('admin/events/uploadreport/'.$event_id);
}
else {
$data['reportArray'] = $this->Events_Model->getCommonIdArray('tbl_event_report','*', array('event_id'=>$event_id));
//print_r($data);die;
$data['recordsArray'] = $this->Events_Model->getSingleEventDetails($event_id);
if($_GET['edit']>0){
$data['sd'] = $this->Events_Model->getSingleRecord('tbl_event_report',' * ', array('id'=>$_GET['edit'],'status'=>'1'));
}
if($_GET['delete']>0) {
$id = $_GET['delete'];
$this->Events_Model->deleterecords('tbl_event_report',$id);
$this->session->set_flashdata('success', 'Report deleted');
setHistory('Event report deleted successfully');
redirect('admin/events/uploadreport/'.$event_id);
}
//print_r($data);die;
//load the error and success messages
$data['errors'] = $this->error;
$data['success'] = $this->success;
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/events/addreports',$data);
$this->load->view('admin/_parts/footer');
}
}
//digital team approval report
public function digitalteamreport($event_id='')
{
$data = array();
$role_id = $this->session->userdata('role_id');
$author_id = $this->session->userdata('adid')->id;
$evmArray=array();
$evmArray['comment']=$_POST['comment'];
if($_POST['save']=="Save"){
if($_POST['event_status']=='5'){
if($role_id=='6'){
$event_id = $_POST['event_id'];
$id=$_POST['id'];
$evmArray = array(
'comment'=>$evmArray['comment'],
'verified_dm'=>'1'
);
//print_r($evmArray);die;
$this->Events_Model->updateinfo($tbl_name='tbl_event_report',$evmArray,'id',$id);
redirect('admin/events/digitalteamreport/'.$event_id);
}
}
else if($_POST['event_status']=='6'){
if($role_id=='6'){
$event_id = $_POST['event_id'];
$id=$_POST['id'];
$evmArray = array(
'comment'=>$evmArray['comment'],
'verified_dm'=>'0'
);
}
$this->Events_Model->updateinfo($tbl_name='tbl_event_report',$evmArray,'id', $id);
redirect('admin/events/digitalteamreport/'.$event_id);
}
}
$data['recordsArray'] = $this->Events_Model->getSingleEventDetails($event_id);
$data['reportArray'] = $this->Events_Model->getCommonIdArray('tbl_event_report','*', array('event_id'=>$event_id));
$data['authorArray'] = $this->Events_Model->getAllModuleList('tbl_admin','id,userName', array('status'=>'1'));
$data['statusArray'] = $this->Events_Model->getAllModuleList('tbl_status_master','id,display_name', array('event_status'=>'1'));
$data['sd'] = $this->Events_Model->getSingleRecord('tbl_event_master',' * ', array('id'=>$id));
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/events/postreport',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to manage events listing module');
}
//digital team approval images
public function digitalteamimages($event_id='')
{
$data = array();
$role_id = $this->session->userdata('role_id');
$author_id = $this->session->userdata('adid')->id;
$evmArray=array();
$evmArray['comment']=$_POST['comment'];
if($_POST['save']=="Save"){
if($_POST['event_status']=='5'){
if($role_id=='6'){
$event_id = $_POST['event_id'];
$id=$_POST['id'];
$evmArray = array(
'comment'=>$evmArray['comment'],
'verified_dm'=>'1'
);
$this->Events_Model->updateinfo($tbl_name='tbl_event_images',$evmArray,'id',$id);
redirect('admin/events/digitalteamimages/'.$event_id);
}
} else if($_POST['event_status']=='6'){
if($role_id=='6'){
$event_id = $_POST['event_id'];
$id=$_POST['id'];
$evmArray = array(
'comment'=>$evmArray['comment'],
'verified_dm'=>'2'
);
}
$this->Events_Model->updateinfo($tbl_name='tbl_event_images',$evmArray,'id', $id);
redirect('admin/events/digitalteamimages/'.$event_id);
}
}
$data['recordsArray'] = $this->Events_Model->getSingleEventDetails($event_id);
$data['reportArray'] = $this->Events_Model->getCommonIdArray('tbl_event_images','*', array('event_id'=>$event_id));
$data['authorArray'] = $this->Events_Model->getAllModuleList('tbl_admin','id,userName', array('status'=>'1'));
$data['statusArray'] = $this->Events_Model->getAllModuleList('tbl_status_master','id,display_name', array('event_status'=>'1'));
$data['sd'] = $this->Events_Model->getSingleRecord('tbl_event_master',' * ', array('id'=>$id));
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/events/postimages',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to manage events listing module');
}
//digital team approval videos
public function digitalteamvideos($event_id='')
{
$data = array();
$role_id = $this->session->userdata('role_id');
$author_id = $this->session->userdata('adid')->id;
$evmArray=array();
$evmArray['comment']=$_POST['comment'];
if($_POST['save']=="Save"){
if($_POST['event_status']=='5'){
if($role_id=='6'){
$event_id = $_POST['event_id'];
$id = $_POST['id'];
$evmArray = array(
'comment'=>$evmArray['comment'],
'verified_dm'=>'1'
);
$this->Events_Model->updateinfo($tbl_name='tbl_event_videos',$evmArray,'id',$id);
redirect('admin/events/digitalteamvideos/'.$event_id);
}
}
elseif($_POST['event_status']=='6'){
if($role_id=='6'){
$event_id = $_POST['event_id'];
$id = $_POST['id'];
$evmArray = array(
'comment'=>$evmArray['comment'],
'verified_dm'=>'0'
);
}
$this->Events_Model->updateinfo($tbl_name='tbl_event_videos',$evmArray,'id',$id);
redirect('admin/events/digitalteamvideos/'.$event_id);
}
}
$data['recordsArray'] = $this->Events_Model->getSingleEventDetails($event_id);
$data['reportArray'] = $this->Events_Model->getCommonIdArray('tbl_event_videos','*', array('event_id'=>$event_id));
$data['authorArray'] = $this->Events_Model->getAllModuleList('tbl_admin','id,userName', array('status'=>'1'));
$data['statusArray'] = $this->Events_Model->getAllModuleList('tbl_status_master','id,display_name', array('event_status'=>'1'));
$data['sd'] = $this->Events_Model->getSingleRecord('tbl_event_master',' * ', array('id'=>$id));
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/events/postivideos',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to manage events listing module');
}
private function uploadimages($file_name, $old_file='')
{
$config['upload_path'] = './attachments/files/eventimages/';
$config['allowed_types'] = '*';
$config['remove_spaces'] = TRUE;
$config['overwrite'] = TRUE;
$config['max_size'] = 2097152;
$this->load->library('upload', $config);
$this->upload->initialize($config);
if (!$this->upload->do_upload($file_name)) {
log_message('error', 'Image Upload Error: ' . $this->upload->display_errors());
//print_r($this->upload->display_errors()); die;
} else {
if($old_file!=''){
$path = './attachments/files/eventimages/'.$old_file;
unlink($path);
}
}
$doc = $this->upload->data();
return $doc['file_name'];
}
private function uploadvideo($file_name, $old_file='')
{
$config['upload_path'] = './attachments/files/eventvideos/';
$config['allowed_types'] = '*';
$config['remove_spaces'] = TRUE;
$config['overwrite'] = TRUE;
$this->load->library('upload', $config);
$this->upload->initialize($config);
if (!$this->upload->do_upload($file_name)) {
log_message('error', 'Image Upload Error: ' . $this->upload->display_errors());
//print_r($this->upload->display_errors()); die;
} else {
if($old_file!=''){
$path = './attachments/files/eventvideos/'.$old_file;
unlink($path);
}
}
$doc = $this->upload->data();
return $doc['file_name'];
}
private function reportfile($file_name, $old_file='')
{
$config['upload_path'] = './attachments/files/eventreports/';
$config['allowed_types'] = 'gif|jpg|png|jpeg|JPG|PNG|JPEG|PDF|pdf|SVG|svg|avi|mp4|3gp|mpeg|mpg|mov|mp3|flv|wmv|docx|doc|xls';
$config['remove_spaces'] = TRUE;
$config['overwrite'] = TRUE;
$this->load->library('upload', $config);
$this->upload->initialize($config);
if (!$this->upload->do_upload($file_name)) {
log_message('error', 'Image Upload Error: ' . $this->upload->display_errors());
//print_r($this->upload->display_errors()); die;
} else {
if($old_file!=''){
$path = './attachments/files/eventreports/'.$old_file;
unlink($path);
}
}
$doc = $this->upload->data();
return $doc['file_name'];
}
public function deleterecord($id)
{
$eventDetails = $this->Events_Model->getSingleRecord('tbl_event_report','*', array('id'=>$id));
$this->Events_Model->deleterecords('tbl_event_report',$id);
$this->session->set_flashdata('success', 'Report deleted');
setHistory('report deleted');
redirect('admin/events/uploadreport/'.$eventDetails['event_id']);
}
public function deleteimages($id)
{
$eventDetails = $this->Events_Model->getSingleRecord('tbl_event_images','*', array('id'=>$id));
$this->Events_Model->deleterecords('tbl_event_images',$id);
$this->session->set_flashdata('success', 'images deleted');
setHistory('image deleted');
redirect('admin/events/uploadpictures/'.$eventDetails['event_id']);
}
public function deletepostimages($id)
{
$eventDetails = $this->Events_Model->getSingleRecord('tbl_event_images','*', array('id'=>$id));
$this->Events_Model->deleterecords('tbl_event_images',$id);
$this->session->set_flashdata('success', 'images deleted');
setHistory('image deleted');
redirect('admin/events/digitalteamimages/'.$eventDetails['event_id']);
}
public function deleteevents($id)
{
$eventDetails = $this->Events_Model->getSingleRecord('tbl_event_master','*', array('id'=>$id));
$this->Events_Model->deleterecords('tbl_event_master',$id);
$this->session->set_flashdata('success', 'Event successfully deleted.');
setHistory('Event successfully deleted.');
redirect('admin/events');
}
public function deletevideos($id)
{
$eventDetails = $this->Events_Model->getSingleRecord('tbl_event_videos','*', array('id'=>$id));
$this->Events_Model->deleterecords('tbl_event_videos',$id);
$this->session->set_flashdata('success', 'Video deleted');
setHistory('video deleted');
redirect('admin/events/uploadvideos/'.$eventDetails['event_id']);
}
public function deletepostvideos($id)
{
$eventDetails = $this->Events_Model->getSingleRecord('tbl_event_videos','*', array('id'=>$id));
$this->Events_Model->deleterecords('tbl_event_videos',$id);
$this->session->set_flashdata('success', 'Video deleted');
setHistory('video deleted');
redirect('admin/events/digitalteamvideos/'.$eventDetails['event_id']);
}
//Post email
public function sendPostReport($uid){
$data = array();
$params = array();
$author_id = $userArray->id;
$muid = $uid;
$events = $this->Events_Model->getSingleRecord('tbl_event_report','*', array('id'=>$muid, 'status'=>'1', 'is_deleted'=>'0'));
$audiencedetail = $this->Events_Model->getAllModuleList('tbl_target_audiences','email', array('status'=>'1'));
$to_emails = $audiencedetail['email']; // $menteeDetails['email_id'];
$report = $events['report'];
$message = $this->load->view('admin/email_template/digital_report_mail', $params, true);
$message = str_replace('##REPORT##',$report,$message);
$subject = 'POST EVENT REPORT!!';
//$to_emails =array('amit.verma@shardatech.org');
//$emailResp = send_email_pepipost($to_emails, $subject, $message);
$emailResp = sendSMTPCommonEmail($to_emails, $subject, $message);
setHistory('mail send successfully');
}
public function approveevent(){
$id = $_POST['id'];
$role_id = $this->session->userdata('role_id');
if($role_id=='6'){
//$event_id = $_POST['event_id'];
//$id = $_POST['id'];
$evmArray = array(
//'comment'=>$evmArray['comment'],
'verified_dm'=>'1'
);
$this->Events_Model->updateinfo($tbl_name='tbl_event_images',$evmArray,'id',$id);
}
}
public function approvevideo(){
$id = $_POST['id'];
$role_id = $this->session->userdata('role_id');
if($role_id=='6'){
//$event_id = $_POST['event_id'];
//$id = $_POST['id'];
$evmArray = array(
//'comment'=>$evmArray['comment'],
'verified_dm'=>'1'
);
$this->Events_Model->updateinfo($tbl_name='tbl_event_videos',$evmArray,'id',$id);
}
}
public function ajaxgetCountblog()
{
//$this->login_check();
$event_title = $_POST['event_title'];
//printr($blog_title);die();
$data['responseArray'] = $this->Events_Model->getAllRecordCount('tbl_event_master', '*', array('event_title'=>$event_title,'is_deleted'=>'0'));
//print_r($data['responseArray']);die();
echo $data['responseArray'];
}
/**
* Upload multiple Images
*/
private function uploadmultipleimages()
{
$config['upload_path'] = './attachments/files/eventimages/';
$config['allowed_types'] = 'gif|jpg|png|jpeg|JPG|PNG|JPEG';
// $config['max_size'] = 500;
$this->load->library('upload', $config);
$this->upload->initialize($config);
$files = $_FILES['image'];
$uploaded_images = array();
foreach ($files['name'] as $i => $name) {
$extension = pathinfo($files['name'][$i], PATHINFO_EXTENSION);
$fileName = pathinfo($files['name'][$i], PATHINFO_FILENAME);
$_FILES['files[]']['name'] = preg_replace('/[^A-Za-z0-9\-]/', '_', $fileName) . '.' . $extension;
$_FILES['files[]']['type'] = $files['type'][$i];
$_FILES['files[]']['tmp_name'] = $files['tmp_name'][$i];
$_FILES['files[]']['error'] = $files['error'][$i];
$_FILES['files[]']['size'] = $files['size'][$i];
if (!$this->upload->do_upload('files[]')) {
$error = array('error' => $this->upload->display_errors());
array_push($data, array("status" => "401", "message" => "File not uploaded", "name" => $files['name'][$i], "log" => $error, "type" => $this->upload->file_type));
} else {
$uploaded_images[] = $this->upload->data()['file_name'];
}
}
return $uploaded_images;
}
public function updateindivisualimages()
{
$post = $this->input->post();
$verfied_dm = $this->input->post('eventStatus');
$set_status = 0;
if($verfied_dm == 5) {
$set_status = "1";
} else {
$set_status = "2";
}
$update_status = $this->Events_Model->updateIndividualImages($post,$set_status);
if(!is_null($update_status)) {
echo json_encode($update_status);
} else {
echo "Not Updated";
}
}
/**
* Update video status and comment
*/
public function updatevideostatus()
{
$post = $this->input->post();
$verfied_dm = $this->input->post('eventStatus');
$set_status = 0;
if($verfied_dm == 5) {
$set_status = "1";
} else {
$set_status = "2";
}
$update_status = $this->Events_Model->updateVideoStatusAndComment($post,$set_status);
if(!is_null($update_status)) {
echo json_encode($update_status);
} else {
echo "Not Updated";
}
}
//function : removecustomfile
public function removecustomfile(){
$id = $_POST['id'];
$resp = '2001';
if($id>0){
$record = $this->Events_Model->getSingleRecord('tbl_event_master','*',array('id'=>$id));
$path='attachments/files/banner_image/'.$record['banner_image'];
if($record){
$this->Events_Model->updateinfo('tbl_event_master',array('banner_image'=> '','modifiedon'=>date('Y-m-d H:i:s')),'id',$id);
unlink($path);
$resp = '1001';
}
}
echo $resp;
exit();
}
}
Kontol Shell Bypass