ikan Uploader :
Directory : /var/www/html/new-ugenterprises.com/blog/application/controllers/admin/
Upload File : |
| Current File : /var/www/html/new-ugenterprises.com/blog/application/controllers/admin/Blog.php |
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
/**
* Description of VideoUpload
*
* @author : Sharda Tech Pvt. Ltd
*/
class Blog 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('Blog_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('adid')->role_id;
$author_id = $this->session->userdata('adid')->id;
$roleArray = array('9');
$approvalArray = array('6','5','4','3');
if(in_array($role_id,$roleArray)){
$_POST['school_filter'] = $this->session->userdata('adid')->school_id;
}
$data['schoolArray'] = $this->Blog_Model->getCommonIdArray('tbl_schools','id, school_name, school_code',array('status'=>'1','is_display'=>'1', 'is_deleted'=>'0'),array('school_name'=>'ASC'));
$data['deptArray'] = $this->Blog_Model->getCommonIdArray('tbl_departments','id, department_name',array('status'=>'1', 'is_deleted'=>'0'));
$data['roleArray'] = $this->Common_Model->getCommonIdArray('tbl_role_master');
$data['departmentArray'] = '';
if($_GET['school_filter']>0) {
$data['departmentArray'] = $this->Blog_Model->getCommonIdArray('tbl_departments','*', array('school_id'=>$_GET['school_filter'],'status'=>'1', 'is_deleted'=>'0'),array('department_name'=>'ASC'));
}
$data['recorddetails'] = array();
// Get All user Records
//$condArray = array('tbl_event_master.status'=>'1', 'tbl_event_master.is_deleted'=>'0');
if($role_id>6){
$condArray['author_id'] = $author_id;
}
if($role_id == '4'){
$condArray['verified_hod'] = '1';
}
if($role_id == '3'){
$condArray['verified_hod'] = '1';
$condArray['verified_dean'] = '1';
}
if($role_id == '6'){
$condArray['verified_hod'] = '1';
$condArray['verified_dean'] = '1';
$condArray['verified_iqac'] = '1';
}
if(in_array($role_id,$approvalArray))
{
$condArray['tbl_event_master.status'] = '4';
}
if($this->session->userdata(adid)->role_id=='5' ){
$scl_id=$this->session->userdata(adid)->school_id;
$condArray=array('organizing_school'=>$scl_id);
$data['recorddetails'] = $this->Blog_Model->getAllEventsRecords(NULL, $condArray);
if($role_id == '4'){
$condArray['verified_hod'] = '1';
}
if($role_id == '3'){
$condArray['verified_hod'] = '1';
$condArray['verified_dean'] = '1';
}
if($role_id == '6'){
$condArray['verified_hod'] = '1';
$condArray['verified_dean'] = '1';
$condArray['verified_iqac'] = '1';
}
}
if($this->session->userdata(adid)->role_id=='4' ){
$scl_id=$this->session->userdata(adid)->school_id;
$condArray=array('organizing_school'=>$scl_id);
$data['recorddetails'] = $this->Blog_Model->getAllEventsRecords(NULL, $condArray);
if($role_id == '4'){
$condArray['verified_hod'] = '1';
}
if($role_id == '3'){
$condArray['verified_hod'] = '1';
$condArray['verified_dean'] = '1';
}
if($role_id == '6'){
$condArray['verified_hod'] = '1';
$condArray['verified_dean'] = '1';
$condArray['verified_iqac'] = '1';
}
}
if($this->session->userdata(adid)->role_id=='3' ){
//$scl_id=$this->session->userdata(adid)->school_id;
$condArray= array('tbl_event_master.status'=>'4','verified_dean'=>'1');
$data['recorddetails'] = $this->Blog_Model->getAllEventsRecords(NULL, $condArray);
}
if($_POST['school_filter']){
$condArray['tbl_event_master.organizing_school'] =$_POST['school_filter'];
$data['recorddetails'] = $this->Blog_Model->getAllEventsRecords(NULL, $condArray);
}
if($_POST['department_filter']){
$condArray['tbl_event_master.organizing_departments'] =$_POST['department_filter'];
$data['recorddetails'] = $this->Blog_Model->getAllEventsRecords(NULL, $condArray);
}
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']);
$data['recorddetails'] = $this->Blog_Model->getAllEventsRecords(NULL, $condArray, $betweenDate);
}else {
if($_POST['start_date']) {
$condArray['tbl_event_date_time.start_date'] = $_POST['start_date'];
$data['recorddetails'] = $this->Blog_Model->getAllEventsRecords(NULL, $condArray);
}
if($_POST['end_date']) {
$condArray['tbl_event_date_time.end_date'] = $_POST['end_date'];
$data['recorddetails'] = $this->Blog_Model->getAllEventsRecords(NULL, $condArray);
} else {
$data['recorddetails'] = $this->Blog_Model->getAllEventsRecords(NULL, $condArray);
}
}
$schoolName = $this->Blog_Model->getAllModuleList('tbl_schools','id, school_name, school_code',array('status'=>'1'));
$deptsName = $this->Blog_Model->getAllModuleList('tbl_departments','id, department_name',array('status'=>'1'));
//Export Events in CSV
if(isset($_POST['exportevents'])){
if($_POST['school_filter']){
$condArray['tbl_event_master.organizing_school'] =$_POST['school_filter'];
$exportrecordsArray = $this->Blog_Model->getAllEventsRecords(NULL, $condArray);
}
if($_POST['department_filter']){
$condArray['tbl_event_master.organizing_departments'] =$_POST['department_filter'];
$exportrecordsArray = $this->Blog_Model->getAllEventsRecords(NULL, $condArray);
}
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']);
$exportrecordsArray = $this->Blog_Model->getAllEventsRecords(NULL, $condArray, $betweenDate);
}else {
if($_POST['start_date']) {
$condArray['tbl_event_date_time.start_date'] = $_POST['start_date'];
$exportrecordsArray = $this->Blog_Model->getAllEventsRecords(NULL, $condArray);
}
if($_POST['end_date']) {
$condArray['tbl_event_date_time.end_date'] = $_POST['end_date'];
$exportrecordsArray = $this->Blog_Model->getAllEventsRecords(NULL, $condArray);
} else {
$exportrecordsArray = $this->Blog_Model->getAllEventsRecords(NULL, $condArray);
}
}
$filename = 'Export_events';
// 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');
//set Row
$rowCount = 2;
foreach ($exportrecordsArray as $list) {
$objPHPExcel->getActiveSheet()->SetCellValue('A' . $rowCount, $list['event_title']);
$objPHPExcel->getActiveSheet()->SetCellValue('B' . $rowCount, $list['event_details']);
$objPHPExcel->getActiveSheet()->SetCellValue('C' . $rowCount, $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, $list['convener_details']);
$objPHPExcel->getActiveSheet()->SetCellValue('G' . $rowCount, $list['coordinator_details']);
$objPHPExcel->getActiveSheet()->SetCellValue('H' . $rowCount, $list['start_date']);
$objPHPExcel->getActiveSheet()->SetCellValue('I' . $rowCount, $list['end_date']);
$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->Blog_Model->getAllModuleList('tbl_admin','id,userName,role_id', array('status'=>'1'));
$data['statusArray'] = $this->Blog_Model->getAllModuleList('tbl_status_master','id,display_name', array('status'=>'1'));
$data['report'] = $this->Blog_Model->getCommonIdArray('tbl_event_report','*', array('status'=>'1'));
$data['image'] = $this->Blog_Model->getSingleRecord('tbl_event_images','*', array('status'=>'1'));
$data['videos'] = $this->Blog_Model->getSingleRecord('tbl_event_videos','*', array('status'=>'1'));
$data['review'] = $this->Blog_Model->getCommonIdArray('tbl_event_approval_transaction','*', array('status'=>'1'));
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/blog/index',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to manage blog listing module');
}
public function addevent($id='') {
$userArray = $this->session->userdata('adid');
$author_id = $userArray->id;
$role_id = $userArray->role_id;
$data = array();
if($_POST){
$this->form_validation->set_rules('event_title','Title','required');
if($this->form_validation->run())
{
$event_title = $this->input->post('event_title');
$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 = $this->input->post('affiliation_organization');
$affiliation_of_speakers = $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 = $this->input->post('speakers_1');
$speakers_2 = $this->input->post('speakers_2');
$speakers_3 = $this->input->post('speakers_3');
$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'));
$declaration = $this->input->post('declaration');
$categories = implode(',',$this->input->post('categories'));
$tags = implode(',',$this->input->post('tags'));
$event_slug = allletters_lowercase($this->input->post('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');
$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');
$banner_image = $this->uploadbanner($file_name='banner_image', $old_banner_image);
if($old_banner_image<>'' && $banner_image=='') {
$banner_image = $old_banner_image;
}
$upload_report = $this->uploadDocuments($file_name='upload_report', $old_upload_report);
if($old_upload_report<>'' && $upload_report=='') {
$upload_report = $old_upload_report;
}
$upload_1 = $this->uploadDocuments($file_name='upload_1', $old_upload_1);
if($old_upload_1<>'' && $upload_1=='') {
$upload_1 = $old_upload_1;
}
$upload_2 = $this->uploadDocuments($file_name='upload_2', $old_upload_2);
if($old_upload_2<>'' && $upload_2=='') {
$upload_2 = $old_upload_2;
}
$upload_3 = $this->uploadDocuments($file_name='upload_3', $old_upload_3);
if($old_upload_3<>'' && $upload_3=='') {
$upload_3 = $old_upload_3;
}
$upload_4 = $this->uploadDocuments($file_name='upload_4', $old_upload_4);
if($old_upload_4<>'' && $upload_4=='') {
$upload_4 = $old_upload_4;
}
$data = array(
'event_title'=>$event_title,
'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,
'status'=>$status,
'event_specifications'=>$event_specifications,
'chief_guest'=>$chief_guest,
'chief_guest_affiliation'=>$chief_guest_affiliation,
'speakers_1'=>$speakers_1,
'speakers_2'=>$speakers_2,
'speakers_3'=>$speakers_3,
'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,
'categories'=>$categories,
'tags'=>$tags,
'event_slug'=>$event_slug,
'upload_report'=>$upload_report,
'upload_1'=>$upload_1,
'upload_2'=>$upload_2,
'upload_3'=>$upload_3,
'upload_4'=>$upload_4,
'banner_image'=>$banner_image,
'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;
}
if ($_POST['all_day_event'] == '1'){
$edtdata['start_time']='';
$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->Blog_Model->updateinfo($tbl_name='tbl_event_master',$data,'id',$id);
// Update Event Date/Time
$edtdata['modifiedon'] = date('Y-m-d H:i:s');
$this->Blog_Model->updateinfo($tbl_name='tbl_event_date_time',$edtdata,'event_id',$id);
$this->Blog_Model->updateinfo($tbl_name='tbl_event_organizer_contactinfo',$orgdata,'event_id',$id);
$this->Blog_Model->updateinfo($tbl_name='tbl_event_cost_tickets',$costs,'event_id',$id);
$this->Blog_Model->updateinfo($tbl_name='tbl_event_location_details',$location,'event_id',$id);
setHistory('Event updated successfully');
}
else {
$data['author_id'] = $author_id;
$data['createdon'] = date('Y-m-d H:i:s');
$eventId = $this->Blog_Model->saveinfo($tbl_name='tbl_event_master',$data);
// Save Data In tbl_event_date_time
$edtdata['event_id'] = $eventId;
$edtdata['createdon'] = date('Y-m-d H:i:s');
$this->Blog_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->Blog_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->Blog_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->Blog_Model->saveinfo($tbl_name='tbl_event_organizer_contactinfo',$orgdata);
//Save categories
$addcat['createdon'] = date('Y-m-d H:i:s');
$this->Blog_Model->saveinfo($tbl_name='tbl_category',$addcat);
//Save tags
$addtag['createdon'] = date('Y-m-d H:i:s');
$this->Blog_Model->saveinfo($tbl_name='tbl_category',$addtag);
setHistory('Event 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);
}
redirect('admin/blog');
}
else {
$this->load->view('admin/_parts/header');
$this->load->view('admin/blog/addblog');
$this->load->view('admin/_parts/footer');
}
/*if(isset($_POST['dean']))
{
$this->sendupdatedevents($id);
}*/
}
else {
// Get Category List
$data['categoryArray'] = $this->Blog_Model->getCommonIdArray('tbl_category','id, category_name, display_name',array('status'=>'1', 'is_deleted'=>'0'));
//Get Tags List
$data['tagArray'] = $this->Blog_Model->getCommonIdArray('tbl_tags','id, tag_name, display_name',array('status'=>'1', 'is_deleted'=>'0'));
//Target Audiences
$data['audiencesArray'] = $this->Blog_Model->getCommonIdArray('tbl_target_audiences','id, title, display_name',array('status'=>'1'));
if($id>0){
$data['sd'] = $sd = $this->Blog_Model->getSingleRecord('tbl_event_master',' * ', array('id'=>$id));
//Get department list
$data['departmentArray'] = $this->Blog_Model->getCommonIdArray('tbl_departments','*',array('status'=>'1','school_id'=>$sd['organizing_school']));
}
// Get Campus List
$data['campusArray'] = $campusArray = $this->Blog_Model->getCommonIdArray('tbl_campus','*',array('status'=>'1'));
// Get School List
$data['schoolArray'] = $this->Blog_Model->getCommonIdArray('tbl_schools','*',array('status'=>'1','school_id'));
// Get Course List
$data['courseArray'] = $this->Blog_Model->getCommonIdArray('tbl_course_master','*',array('status'=>'1'));
// Get Plan List
$data['planArray'] = $this->Blog_Model->getCommonIdArray('tbl_plan_master','*',array('status'=>'1'));
// Get Subject List
$data['subjectArray'] = $this->Blog_Model->getCommonIdArray('tbl_subject_master','*',array('status'=>'1'));
// Get Class List
$data['classArray'] = $this->Blog_Model->getCommonIdArray('tbl_class_master','*',array('status'=>'1'));
//Get scope master
$data['scopeArray'] = $this->Blog_Model->getCommonIdArray('tbl_scope_master','id, title, display_name',array('status'=>'1'));
//Get event_specifications master
$data['specificationsArray'] = $this->Blog_Model->getCommonIdArray('tbl_eventtype_master','id, title, display_name',array('status'=>'1'));
//Get media_coverage master
$data['mediaArray'] = $this->Blog_Model->getCommonIdArray('tbl_media_coverage','id, title, display_name',array('status'=>'1'));
//Get tbl_status_master
$data['statusArray'] = $this->Blog_Model->getCommonIdArray('tbl_status_master','id,display_name',array('status'=>'1','event_status'=>'0'));
//Get tbl_event_date_&_time master
$data['dateArray'] = $this->Blog_Model->getAlldate($id);
//Get tbl_event_organizer_contactinfo master
$data['info'] = $this->Blog_Model->getAlldata($id);
//Get tbl_event_location_details master
$data['locationArray'] = $this->Blog_Model->getAlllocation($id);
//Get tbl_event_cost_tickets master
$data['costArray'] = $this->Blog_Model->getAllcost($id);
//get event_approval transaction
$event_id=$_POST['event_id'];
$data['sendemail']=$this->Blog_Model->sendEmail($id);
//echo $event_id;die;
$data['review'] = $this->Blog_Model->getCommonIdArray('tbl_event_approval_transaction','*', array('status'=>'1'));
//get admintable
$data['admin'] = $this->Blog_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/blog/addblog',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to Add video');
}
}
//sending report to concered hod
public function updateToIqac($uid)
{
$data = array();
$params = array();
$author_id = $userArray->id;
$muid = $uid;
//echo($muid);die;
$event_remark = $this->Blog_Model->getSingleRecord('tbl_event_approval_transaction','*', array('event_id'=>$muid, 'status'=>'1', 'is_deleted'=>'0','role_id'=>'3'));
//$row = $this->Blog_Model->getAllModuleList('tbl_event_approval_transaction','*', array('status'=>'1'));
//print_r($event_remark);die;
$recorddetail = $this->Blog_Model->getAllModuleList('tbl_admin','id,userName,first_name,last_name', array('status'=>'1','role_id'=>'3'));
$inspector = $this->Blog_Model->getAllModuleList('tbl_admin','id,userName, first_name,last_name', array('status'=>'1'));
$to_emails = $recorddetail['email_id']; // $menteeDetails['email_id'];
$examined_by =$inspector[$event_remark['author_id']]['first_name'].' '.$inspector[$event_remark['author_id']]['last_name']; // $menteeDetails['email_id'];
$iqac = $recorddetail[$event_remark['admin_id']]['first_name'].' '.$recorddetail[$event_remark['admin_id']]['last_name'];
$url = base_url('admin/blog/viewevent/'.$event_remark['event_id']);
$message = $this->load->view('admin/email_template/email_to_iqac', $params, true);
$point_covered = 'Your isuues regarding the event has been address and altered.';
$mentor_email = $mentorDetails['email_id'];
$message = str_replace('##NAME##',$iqac,$message);
$message = str_replace('##MESSAGE##',$point_covered,$message);
$message = str_replace('##URL##',$url,$message);
$message = str_replace('##EXAMINED##',$examined_by,$message);
$subject = 'Event isuues addressed !!';
$to_emails = 'aayush.handa@shardatech.org';
$emailResp = send_email_pepipost($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/blog/addblog');
}
//sending report to concered dean
public function updateToDean($uid)
{
$data = array();
$params = array();
$author_id = $userArray->id;
$muid = $uid;
//echo($muid);die;
$event_remark = $this->Blog_Model->getSingleRecord('tbl_event_approval_transaction','*', array('event_id'=>$muid, 'status'=>'1', 'is_deleted'=>'0','role_id'=>'4'));
//$row = $this->Blog_Model->getAllModuleList('tbl_event_approval_transaction','*', array('status'=>'1'));
//print_r($event_remark);die;
$recorddetail = $this->Blog_Model->getAllModuleList('tbl_admin','id,userName,first_name,last_name',array('status'=>'1','role_id'=>'4'));
$inspector = $this->Blog_Model->getAllModuleList('tbl_admin','id,userName, first_name,last_name', array('status'=>'1'));
$to_emails = $recorddetail['email_id']; // $menteeDetails['email_id'];
$examined_by =$inspector[$event_remark['author_id']]['first_name'].' '.$inspector[$event_remark['author_id']]['last_name']; // $menteeDetails['email_id'];
$dean = $recorddetail[$event_remark['admin_id']]['first_name'].' '.$recorddetail[$event_remark['admin_id']]['last_name'];
$url = base_url('admin/blog/viewblog/'.$event_remark['event_id']);
$message = $this->load->view('admin/email_template/email_to_dean', $params, true);
$point_covered = 'Your isuues regarding the event has been address and altered.';
$mentor_email = $mentorDetails['email_id'];
$message = str_replace('##NAME##',$dean,$message);
$message = str_replace('##MESSAGE##',$point_covered,$message);
$message = str_replace('##URL##',$url,$message);
$message = str_replace('##EXAMINED##',$examined_by,$message);
$subject = 'Event isuues addressed !!';
$to_emails = 'aayush.handa@shardatech.org';
$emailResp = send_email_pepipost($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/blog/addblog');
}
//sending report to concered iqac
public function updateToHod($uid)
{
$data = array();
$params = array();
$author_id = $userArray->id;
$muid = $uid;
//echo($muid);die;
$event_remark = $this->Blog_Model->getSingleRecord('tbl_event_approval_transaction','*', array('event_id'=>$muid, 'status'=>'1', 'is_deleted'=>'0'));
//$row = $this->Blog_Model->getAllModuleList('tbl_event_approval_transaction','*', array('status'=>'1'));
//print_r($event_remark);die;
$recorddetail = $this->Blog_Model->getAllModuleList('tbl_admin','id,userName,first_name,last_name', array('status'=>'1','role_id'=>'5'));
$inspector = $this->Blog_Model->getAllModuleList('tbl_admin','id,userName, first_name,last_name', array('status'=>'1'));
$to_emails = $recorddetail['email_id']; // $menteeDetails['email_id'];
$examined_by =$inspector[$event_remark['author_id']]['first_name'].' '.$inspector[$event_remark['author_id']]['last_name']; // $menteeDetails['email_id'];
$hod = $recorddetail[$event_remark['admin_id']]['first_name'].' '.$recorddetail[$event_remark['admin_id']]['last_name'];
$url = base_url('admin/blog/viewblog/'.$event_remark['event_id']);
$message = $this->load->view('admin/email_template/email_to_hod', $params, true);
$point_covered = 'Your isuues regarding the event has been address and altered.';
$mentor_email = $mentorDetails['email_id'];
$message = str_replace('##NAME##',$hod,$message);
$message = str_replace('##MESSAGE##',$point_covered,$message);
$message = str_replace('##URL##',$url,$message);
$message = str_replace('##EXAMINED##',$examined_by,$message);
$subject = 'Event isuues addressed !!';
$to_emails = 'aayush.handa@shardatech.org';
$emailResp = send_email_pepipost($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/blog/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';
$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';
$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->Blog_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->Blog_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->Blog_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->Blog_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->Blog_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('adid')->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->Blog_Model->saveinfo($tbl_name='tbl_event_approval_transaction',$dataArray);
if($_POST['event_status']=='5')
{
if($role_id=='5'){
$evmArray = array('verified_hod'=>'1');
} else if($role_id=='4'){
$evmArray = array('verified_hod'=>'1','verified_dean'=>'1');
} else if($role_id=='3'){
$evmArray = array('verified_hod'=>'1','verified_dean'=>'1','verified_iqac'=>'1');
}
$this->Blog_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);
}
redirect('admin/blog/viewblog/'.$_POST['event_id']);
}
$data['recordsArray'] = $this->Blog_Model->getSingleEventDetails($id);
// Get Category
$data['categoryListArray'] = $this->Blog_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['approvalListArray'] = $approvalListArray = $this->Blog_Model->getTransactionDetails(NULL,$trnsArray);
// Get Tags
$data['tagsListArray'] = $this->Blog_Model->getAllModuleList('tbl_tags');
// Get Tags
$data['deptListArray'] = $this->Blog_Model->getAllModuleList('tbl_departments');
$data['statusArray'] = $this->Blog_Model->getAllModuleList('tbl_status_master','id,display_name', array('event_status'=>'1'));
$data['sd'] = $this->Blog_Model->getSingleRecord('tbl_event_master',' * ', array('id'=>$id));
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/blog/view_blog',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to view video');
}
//sending report to concer faculty
public function sendreportdetails($uid)
{
$data = array();
$params = array();
$author_id = $userArray->id;
$muid = $uid;
$event_remark = $this->Blog_Model->getSingleRecord('tbl_event_approval_transaction','*', array('id'=>$muid, 'status'=>'1', 'is_deleted'=>'0'));
$row = $this->Blog_Model->getAllModuleList('tbl_status_master','id', array('status'=>'1'));
$rows = $this->Blog_Model->getAllModuleList('tbl_event_master','id', array('status'=>'1'));
//var_dump($row);die;
$status_remark = $this->Blog_Model->getAllModuleList('tbl_status_master','id,display_name', array('status'=>'1'));
$recorddetail = $this->Blog_Model->getAllModuleList('tbl_admin','id,userName,first_name,last_name', array('status'=>'1','role_id'=>'7'));
$inspector = $this->Blog_Model->getAllModuleList('tbl_admin','id,userName, first_name,last_name', array('status'=>'1'));
$to_emails = $recorddetail['email_id']; // $menteeDetails['email_id'];
$examined_by =$inspector[$event_remark['admin_id']]['first_name'].' '.$inspector[$event_remark['admin_id']]['last_name']; // $menteeDetails['email_id'];
$comment = $event_remark['comment'];
$status = $status_remark[$event_remark['event_status']]['display_name'];
//print_r($examined_by);die;
$faculty = $recorddetail[$event_remark['author_id']]['first_name'].' '.$recorddetail[$event_remark['author_id']]['last_name'];
//print_r($faculty);die;
$url = base_url('admin/blog/viewblog/'.$event_remark['event_id']);
$message = $this->load->view('admin/email_template/event_credentials_email', $params, true);
$point_covered = 'With concerned to your event';
$mentor_email = $mentorDetails['email_id'];
$message = str_replace('##NAME##',$faculty,$message);
$message = str_replace('##MESSAGE##',$point_covered,$message);
$message = str_replace('##URL##',$url,$message);
$message = str_replace('##EXAMINED##',$examined_by,$message);
$message = str_replace('##STATUS##',$status,$message);
$message = str_replace('##COMMENT##',$comment,$message);
$subject = 'Event REMARKS !!';
$to_emails = 'aayush.handa@shardatech.org';
$emailResp = send_email_pepipost($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/blog/viewblog/'.$_POST['event_id']);
}
//sending email
public function email($uid)
{
$data = array();
$params = array();
$author_id = $userArray->id;
$muid = $uid;
$eventdetails = $this->Blog_Model->getSingleRecord('tbl_event_master','*', array('id'=>$muid, 'is_deleted'=>'0'));
$event_address = $this->Blog_Model->getSingleRecord('tbl_event_location_details','*', array('id'=>$muid, 'status'=>'1', 'is_deleted'=>'0'));
$event_date = $this->Blog_Model->getSingleRecord('tbl_event_date_time','*', array('id'=>$muid, 'status'=>'1', 'is_deleted'=>'0'));
$recorddetail = $this->Blog_Model->getAllModuleList('tbl_admin','id,userName,first_name,last_name', array('status'=>'1','role_id'=>'7'));
$schoolName = $this->Blog_Model->getAllModuleList('tbl_schools','id,school_name', array('status'=>'1'));
$audiencedetail = $this->Blog_Model->getAllModuleList('tbl_target_audiences','email', array('status'=>'1'));
$to_emails = $audiencedetail['email']; // $menteeDetails['email_id'];
$message = $this->load->view('admin/email_template/events_what_happing', $params, true);
$school = $schoolName[$eventdetails['organizing_school']]['school_name'];
$mentor_email = $mentorDetails['email_id'];
$objective = $eventdetails['objective_of_event'];
$title = $eventdetails['event_title'];
$slug = $eventdetails['event_slug'];
//$banner = $eventdetails['banner_image'];
$speakers = $eventdetails['speakers_1'].' '.$eventdetails['speakers_2'].' '.$eventdetails['speakers_3'];
$convener = $eventdetails['convener_details'];
$coordinator = $eventdetails['coordinator_details'];
$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'];
$url = base_url('admin/blog/viewblog/'.$eventdetails['id']);
$message = str_replace('##SCHOOL##',$school,$message);
$message = str_replace('##EVENT##',$title,$message);
$message = str_replace('##SLUG##',$slug,$message);
//$message = str_replace('##BANNER##',$banner,$message);
$message = str_replace('##OBJECTIVE##',$objective,$message);
$message = str_replace('##SPEAKER##',$speakers,$message);
$message = str_replace('##CONVENER##',$convener,$message);
$message = str_replace('##COODINATOR##',$coordinator,$message);
$message = str_replace('##VENUE##',$venue,$message);
$message = str_replace('##ADDRESS##',$address,$message);
$message = str_replace('##DATE##',$date,$message);
$message = str_replace('##TIME##',$time,$message);
$message = str_replace('##ENDDATE##',$end_date,$message);
$message = str_replace('##ENDTIME##',$end_time,$message);
$message = str_replace('##URL##',$url,$message);
$subject = 'Event REMARKS !!';
$to_emails = array('aayush.handa@shardatech.org');
$emailResp = send_email_pepipost($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/blog/viewblog/'.$_POST['event_id']);
}
// uploading images
public function uploadpictures($event_id='')
{
$userArray = $this->session->userdata('adid');
$role_id = $this->session->userdata('adid')->role_id;
$author_id = $this->session->userdata('adid')->id;
//$muid = base64_decode($uid);
$data = array();
if($_POST){
$image=$this->uploadimages($file_name='image', $old_image);
if($old_image<>'' && $image=='') {
$image = $old_image;
}
$event_id = $_POST['event_id'];
$data = array(
'image'=>$image,
'event_id'=>$_POST['event_id'],
'title'=>$image,
'status'=>'1',
'is_deleted'=>'0'
);
$data['createdon'] = date('Y-m-d H:i:s');
$this->Blog_Model->saveinfo($tbl_name='tbl_event_images',$data);
setHistory('image added successfully');
redirect('admin/blog/uploadpictures/'.$event_id);
}
else {
$data['pictures'] = $this->Blog_Model->getCommonIdArray('tbl_event_images','*', array('event_id'=>$event_id));
//print_r($data);die;
$data['recordsArray'] = $this->Blog_Model->getSingleEventDetails($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/blog/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('adid')->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->Blog_Model->saveinfo($tbl_name='tbl_event_videos',$data);
setHistory('Report added successfully');
redirect('admin/blog/uploadvideos/'.$event_id);
}
else {
$data['videos'] = $this->Blog_Model->getCommonIdArray('tbl_event_videos','*', array('event_id'=>$event_id));
//print_r($data);die;
$data['recordsArray'] = $this->Blog_Model->getSingleEventDetails($event_id);
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/blog/addvideos',$data);
$this->load->view('admin/_parts/footer');
}
}
// uploading reports
public function uploadreport($event_id='')
{
$userArray = $this->session->userdata('adid');
$role_id = $this->session->userdata('adid')->role_id;
$author_id = $this->session->userdata('adid')->id;
//$muid = base64_decode($uid);
if($_POST){
$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',
'event_id'=>$_POST['event_id'],
'is_deleted'=>'0'
);
//print_r($data); die;
$data['createdon'] = date('Y-m-d H:i:s');
$this->Blog_Model->saveinfo($tbl_name='tbl_event_report',$data);
setHistory('Report added successfully');
redirect('admin/blog/uploadreport/'.$event_id);
}
else {
$data['reportArray'] = $this->Blog_Model->getCommonIdArray('tbl_event_report','*', array('event_id'=>$event_id));
//print_r($data);die;
$data['recordsArray'] = $this->Blog_Model->getSingleEventDetails($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/blog/addreports',$data);
$this->load->view('admin/_parts/footer');
}
}
//digital team approval report
public function digitalteamreport($event_id='')
{
$data = array();
$role_id = $this->session->userdata('adid')->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->Blog_Model->updateinfo($tbl_name='tbl_event_report',$evmArray,'id',$id);
redirect('admin/blog/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->Blog_Model->updateinfo($tbl_name='tbl_event_report',$evmArray,'id', $id);
redirect('admin/blog/digitalteamreport/'.$event_id);
}
}
$data['recordsArray'] = $this->Blog_Model->getSingleEventDetails($event_id);
$data['reportArray'] = $this->Blog_Model->getCommonIdArray('tbl_event_report','*', array('event_id'=>$event_id));
$data['authorArray'] = $this->Blog_Model->getAllModuleList('tbl_admin','id,userName', array('status'=>'1'));
$data['statusArray'] = $this->Blog_Model->getAllModuleList('tbl_status_master','id,display_name', array('event_status'=>'1'));
$data['sd'] = $this->Blog_Model->getSingleRecord('tbl_event_master',' * ', array('id'=>$id));
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/blog/postreport',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to manage blog listing module');
}
//digital team approval images
public function digitalteamimages($event_id='')
{
$data = array();
$role_id = $this->session->userdata('adid')->role_id;
$author_id = $this->session->userdata('adid')->id;
$evmArray=array();
$evmArray['comment']=$_POST['comment'];
//$evmArray['id']=$_POST['id'];
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->Blog_Model->updateinfo($tbl_name='tbl_event_images',$evmArray,'id',$id);
redirect('admin/blog/digitalteamimages/'.$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->Blog_Model->updateinfo($tbl_name='tbl_event_images',$evmArray,'id',$id);
redirect('admin/blog/digitalteamimages/'.$event_id);
}
}
$data['recordsArray'] = $this->Blog_Model->getSingleEventDetails($event_id);
$data['reportArray'] = $this->Blog_Model->getCommonIdArray('tbl_event_images','*', array('event_id'=>$event_id));
$data['authorArray'] = $this->Blog_Model->getAllModuleList('tbl_admin','id,userName', array('status'=>'1'));
$data['statusArray'] = $this->Blog_Model->getAllModuleList('tbl_status_master','id,display_name', array('event_status'=>'1'));
$data['sd'] = $this->Blog_Model->getSingleRecord('tbl_event_master',' * ', array('id'=>$id));
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/blog/postimages',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to manage blog listing module');
}
//digital team approval videos
public function digitalteamvideos($event_id='')
{
$data = array();
$role_id = $this->session->userdata('adid')->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->Blog_Model->updateinfo($tbl_name='tbl_event_videos',$evmArray,'id',$id);
redirect('admin/blog/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->Blog_Model->updateinfo($tbl_name='tbl_event_videos',$evmArray,'id',$id);
redirect('admin/blog/digitalteamvideos/'.$event_id);
}
}
$data['recordsArray'] = $this->Blog_Model->getSingleEventDetails($event_id);
$data['reportArray'] = $this->Blog_Model->getCommonIdArray('tbl_event_videos','*', array('event_id'=>$event_id));
$data['authorArray'] = $this->Blog_Model->getAllModuleList('tbl_admin','id,userName', array('status'=>'1'));
$data['statusArray'] = $this->Blog_Model->getAllModuleList('tbl_status_master','id,display_name', array('event_status'=>'1'));
$data['sd'] = $this->Blog_Model->getSingleRecord('tbl_event_master',' * ', array('id'=>$id));
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/blog/postivideos',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to manage blog listing module');
}
private function uploadimages($file_name, $old_file='')
{
$config['upload_path'] = './attachments/files/eventimages/';
$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';
$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'] = 'gif|jpg|png|jpeg|JPG|PNG|JPEG|PDF|pdf|SVG|svg|avi|mp4|3gp|mpeg|mpg|mov|mp3|flv|wmv|docx|doc|xls';
$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';
$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->Blog_Model->getSingleRecord('tbl_event_report','*', array('id'=>$id));
$this->Blog_Model->deleterecords('tbl_event_report',$id);
$this->session->set_flashdata('success', 'Report deleted');
setHistory('report deleted');
redirect('admin/blog/uploadreport/'.$eventDetails['event_id']);
}
public function deleteimages($id)
{
$eventDetails = $this->Blog_Model->getSingleRecord('tbl_event_images','*', array('id'=>$id));
$this->Blog_Model->deleterecords('tbl_event_images',$id);
$this->session->set_flashdata('success', 'images deleted');
setHistory('image deleted');
redirect('admin/blog/uploadpictures/'.$eventDetails['event_id']);
}
public function deletepostimages($id)
{
$eventDetails = $this->Blog_Model->getSingleRecord('tbl_event_images','*', array('id'=>$id));
$this->Blog_Model->deleterecords('tbl_event_images',$id);
$this->session->set_flashdata('success', 'images deleted');
setHistory('image deleted');
redirect('admin/blog/digitalteamimages/'.$eventDetails['event_id']);
}
public function deletevideos($id)
{
$eventDetails = $this->Blog_Model->getSingleRecord('tbl_event_videos','*', array('id'=>$id));
$this->Blog_Model->deleterecords('tbl_event_videos',$id);
$this->session->set_flashdata('success', 'Video deleted');
setHistory('video deleted');
redirect('admin/blog/uploadvideos/'.$eventDetails['event_id']);
}
public function deletepostvideos($id)
{
$eventDetails = $this->Blog_Model->getSingleRecord('tbl_event_videos','*', array('id'=>$id));
$this->Blog_Model->deleterecords('tbl_event_videos',$id);
$this->session->set_flashdata('success', 'Video deleted');
setHistory('video deleted');
redirect('admin/blog/digitalteamvideos/'.$eventDetails['event_id']);
}
//Post email
public function sendPostReport($uid){
$data = array();
$params = array();
$author_id = $userArray->id;
$muid = $uid;
$events = $this->Blog_Model->getSingleRecord('tbl_event_report','*', array('id'=>$muid, 'status'=>'1', 'is_deleted'=>'0'));
$audiencedetail = $this->Blog_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('aayush.handa@shardatech.org');
$emailResp = send_email_pepipost($to_emails, $subject, $message);
setHistory('mail send successfully');
}
public function approveevent(){
$id = $_POST['id'];
$role_id = $this->session->userdata('adid')->role_id;
if($role_id=='6'){
//$event_id = $_POST['event_id'];
//$id = $_POST['id'];
$evmArray = array(
//'comment'=>$evmArray['comment'],
'verified_dm'=>'1'
);
$this->Blog_Model->updateinfo($tbl_name='tbl_event_images',$evmArray,'id',$id);
}
}
public function approvevideo(){
$id = $_POST['id'];
$role_id = $this->session->userdata('adid')->role_id;
if($role_id=='6'){
//$event_id = $_POST['event_id'];
//$id = $_POST['id'];
$evmArray = array(
//'comment'=>$evmArray['comment'],
'verified_dm'=>'1'
);
$this->Blog_Model->updateinfo($tbl_name='tbl_event_videos',$evmArray,'id',$id);
}
}
}
Kontol Shell Bypass