Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/public_html/crm/crm_2020_11_03/application/modules/backlink/controllers

Free Space:

3.96 TB

🔧 Quick Actions

✏️ Editing: Backlink.php

<?php
if (!defined('BASEPATH'))
 exit('No direct script access allowed');
class Backlink extends CI_Controller
{
 function __construct()
 {
 parent::__construct();
 $this->load->model(array(
 'Backlink_model'
 ));
 $this->load->helper(array(
 'form'
 ));
 $this->load->library("Pdf");
 $session_data = $this->session->userdata(SESSION_LOGIN .'logged_in');
 $data['username'] = $session_data['username'];
 $data['permission'] = $this->session->userdata(SESSION_LOGIN .'user_permission');
 if (empty($data['permission'])) {
 redirect('home');
 }
 $data['title'] = 'Backlink';
 $data['back_link_source_type'] = $this->Common_model->getDropdownList('back_link_source_type');
		$data[ 'category' ] = $this->Master_model->getCategoryList('business_category');
 $data['back_link_status'] = $this->Common_model->getDropdownList('back_link_status');
 $data['back_link_response_status'] = $this->Common_model->getDropdownList('back_link_response_status');
 $data['back_link_type'] = $this->Common_model->getDropdownList('back_link_type');
 $data['back_link_url'] = $this->Common_model->getDropdownList('back_link_url');
 $data['client'] = $this->Common_model->getDropdownList('client');
 
 $this->load->view('common/header', $data);
 }
 function hasPermission($page)
 {
 $res_permission = $this->session->userdata(SESSION_LOGIN .'user_permission');
 if ($res_permission && !empty($res_permission)) {
 if (!in_array($page, $res_permission)) {
 redirect('access_denied', 'refresh');
 }
 } else {
 redirect('home');
 }
 }
	function index(){
		$this->getlist();
	}
 function getlist()
 {
		$this->hasPermission('backlink_view');
 $filter_data = '';
 if ($this->input->server('REQUEST_METHOD') == 'POST') {
 $filter_data = $this->input->post();
 $reset_data = $this->input->post('reset');
 if (isset($reset_data)) {
 $this->session->unset_userdata('filter_data');
 $filter_data = '';
 } else {
 $this->session->set_userdata('filter_data', $filter_data);
 }
 } else {
 $session_filter_data = $this->session->userdata('filter_data');
 if (isset($session_filter_data)) {
 $filter_data = $session_filter_data;
 } else {
 $filter_data = '';
 }
 }
 $data['filter_data'] = $filter_data;
 $segment_3 = $this->uri->segment(3);
 $segment_4 = $this->uri->segment(4);
 $segment_5 = $this->uri->segment(5);
 // If not pagination page remove filter data from session
 if (!isset($segment_3) && $this->input->server('REQUEST_METHOD') != 'POST') {
 $this->session->unset_userdata('filter_data');
 $filter_data = '';
 $data['filter_data'] = '';
 }
 if (isset($segment_3)) {
 $page = $segment_3;
 } else {
 $page = '1';
 }
 if (isset($segment_4)) {
 $sort = $segment_4;
 } else {
 $sort = 'back_link_id';
 }
 if (isset($segment_5)) {
 $order = $segment_5;
 } else {
 $order = 'DESC';
 }
 
 $data['page'] = $page; // No used for Redirect to same page after delete action in page 2, page 3,etc...
 
 $filter_query_data = array();
 $data['limit'] = '';
 if(isset($_REQUEST['limit']) && !empty($_REQUEST['limit'])){
 $start = (($page - 1) * $_REQUEST['limit']);
 $filter_query_data['limit'] = $_REQUEST['limit'];
 $data['limit'] = '?limit='.$_REQUEST['limit'];
 }else{
 $start = (($page - 1) * RPP);
 }
 
 $data['start'] = $start; // Generate SNO in result table based on page number
 $filter_query_data['start'] = $start;
 $filter_query_data['sort'] = $sort;
 $filter_query_data['order'] = $order;
 
 // $start = (($page - 1) * RPP);
 // $data['start'] = $start;
 // $data['sort'] = $sort;
 // $data['order'] = $order;
 
 $table = array();
 $table['tbl_main'] = 'back_link';
 $data['mainlist_count'] = $this->Common_model->getListCount($table, $filter_data);
 $backlink_list = '';
 $mainlist = $this->Common_model->getList($table, $filter_query_data, $filter_data);
		if(isset($mainlist) && !empty($mainlist)){
			foreach ($mainlist as $key => $val) {
				 $backlink_total = 0;
				 $backlink_submitted_total = 0;
				 $backlink_expired_total = 0;
				 
				 $where = 'ref_back_link_type_id = "'.$val->ref_back_link_type_id.'"';
				 $backlink_total = $this->Common_model->getRecordsCount('back_link_url', $where);
				 
				 $backlink_submitted_total = $this->Backlink_model->getSubmittedUrlTotal($val->back_link_id,$val->ref_back_link_type_id);
				
				 $backlink_expired_total = $this->Backlink_model->getExpiredUrlTotal($val->back_link_id,$val->ref_back_link_type_id);
				 
				 $data['mainlist'][] = (object) array(
					'back_link_id'	=> $val->back_link_id,
					'ref_client_id'	=> $val->ref_client_id,
					'client_name'	=> $val->client_name,
					'back_link_type_name'	=> $val->back_link_type_name,
					'category_name'	=> $val->category_name,
					'client_site_url'	=> $val->client_site_url,
					'back_link_user_name'	=> $val->back_link_user_name,
					'back_link_password'	=> $val->back_link_password,
					'backlink_total'	=> $backlink_total,
					'backlink_submitted_total'	=> $backlink_submitted_total[0]->total,
					'backlink_expired_total'	=> $backlink_expired_total[0]->total
				 );
			}
		}
		
		//~ echo '<pre>';
		//~ print_r( $data['mainlist']);
		//~ echo '</pre>';
		 //~ exit;
 $data['tablefields'] = $this->Common_model->getTableFields('back_link');
 
 $data['operations'] = $this->Common_model->getFilterOperation();
 $data['init_listing_page'] = 'backlink/getlist/';
 $data['listing_page'] = $data['init_listing_page'] . $page . '/';
		//$data['page'] = $page;
 $data['filter_block'] = $this->parser->parse('common/filter', $data, true);
 $this->load->view('common/menu');
 $this->load->view('backlink/backlink_list_view', $data);
 $this->load->view('common/footer');
 }
 
 function getForm()
 {
		$data['action'] = site_url('backlink/add');
		$where = '';
		$group_by = 'seo_keyword.ref_client_id';
		$order_by = 'client.client_name ASC';
		$data['seo_client'] = $this->Common_model->getRecords('seo_keyword',$group_by,$order_by);
 //~ $this->Common_model->printArray($data);
 //~ exit;
 $this->load->view('common/menu');
 $this->load->view('backlink/backlink_form_view',$data);
 $this->load->view('common/footer');
 }
 function add()
 {
 $this->hasPermission('backlink_add');
 if ($this->input->server('REQUEST_METHOD') == 'POST') {
			
			$data = $this->input->post();
			$res = $this->Backlink_model->addRecord('back_link',$data);			
			if ($res) {
 $this->Common_model->TxnCommit();
 $this->Common_model->addUserActivity('backlink_add',$res); // Record User Activity
 $_SESSION['success_msg'] = 'Back Link successfully added ...';
 } else {
 $this->Common_model->TxnRollBack();
 $_SESSION['error_msg'] = 'Error occurred please try again...';
 }
 redirect('backlink');
 } else {
 $this->getForm();
 }
 }
 
 function viewSubmitHistory()
 {
 $this->hasPermission('backlink_view');
 $backlink_id = $this->uri->segment(3);
 $backlink_url_id = $this->uri->segment(4);
 $where = 'ref_back_link_id = "'.$backlink_id.'" AND ref_back_link_url_id = "'.$backlink_url_id.'"';
		$data['backlink_submit_history'] = $this->Common_model->getRecords('back_link_url_to_client', $where);
		
		$data['backlink_url'] = $this->Common_model->getDetails('back_link_url','back_link_url_id',$backlink_url_id);
		$this->load->view('common/menu');
 $this->load->view('backlink/backlink_submit_history_view', $data);
 $this->load->view('common/footer');
 
		//~ echo '<pre>';
		//~ print_r($data['backlink_url']);
		//~ echo '</pre>';
		//~ exit;
	}
 function view()
 {
 $this->hasPermission('backlink_view');
 $id = $this->uri->segment(3);
 $data['backlink'] = $this->Common_model->getDetails('back_link', 'back_link_id', $id);
 
 //$data['backlink_url'] = $this->Common_model->getDetails('back_link_url', 'ref_back_link_type_id', $data['backlink'][0]->ref_back_link_type_id);
 $backlink_url = $this->Common_model->getDetails('back_link_url', 'ref_back_link_type_id', $data['backlink'][0]->ref_back_link_type_id);
 
 $data['backlink_all'] = array();
 $data['backlink_pending'] = array();
 $data['backlink_expired'] = array();
 $data['backlink_recheck'] = array();
 $data['backlink_submitted'] = array();
 if(isset($backlink_url) && !empty($backlink_url)){
			foreach($backlink_url as $key => $val){
				$res_backlink = $this->Common_model->getDetails('back_link_url_to_client','ref_back_link_url_id',$val->back_link_url_id,'back_link_url_to_client_id','DESC');
				$back_link_response_status = 0;
				$back_link_url_status = 0;
				$back_link_url_to_client_id = 0;
				$back_link_url_status_name = '';
				$back_link_submitted_url = '';
				$comment = '';
				$back_link_submitted_url = '';
				if(isset($res_backlink) && !Empty($res_backlink)){
					$back_link_url_to_client_id = $res_backlink[0]->back_link_url_to_client_id;
					$back_link_url_status = $res_backlink[0]->ref_back_link_url_status_id;
					$back_link_response_status = $res_backlink[0]->ref_back_link_response_status_id;
					$back_link_url_status_name = $res_backlink[0]->back_link_url_status_name;
					$back_link_submitted_url = $res_backlink[0]->back_link_submitted_url;
					$comment = $res_backlink[0]->comment;
					$back_link_submitted_datetime = $res_backlink[0]->back_link_submitted_datetime;
				}
				//[0]->ref_back_link_url_status_id
				$data['backlink_all'][] = (object) array(
					'back_link_url_id'		=> $val->back_link_url_id,
					'back_link_url_to_client_id'=> $back_link_url_to_client_id,
					'back_link_url_name'	=> $val->back_link_url_name,
					'back_link_url_status'	=> $back_link_url_status,
					'back_link_url_status_name'	=> $back_link_url_status_name,
					'back_link_response_status'	=> $back_link_response_status,
					'back_link_submitted_url'	=> $back_link_submitted_url,
					'comment'	=> $comment,
					'back_link_submitted_datetime'	=> $back_link_submitted_datetime,
				);
				if($val->ref_back_link_url_status_id == '1'){
					$data['backlink_pending'][] = (object) array(
						'back_link_url_id'		=> $val->back_link_url_id,
						'back_link_url_name'	=> $val->back_link_url_name
					);
				}
				
				if($val->ref_back_link_url_status_id == '2'){
					$data['backlink_submitted'][] = (object) array(
						'back_link_url_id'		=> $val->back_link_url_id,
						'back_link_url_to_client_id'=> $back_link_url_to_client_id,
						'back_link_url_name'	=> $val->back_link_url_name,
						'back_link_url_status'	=> $back_link_url_status,
						'back_link_url_status_name'	=> $back_link_url_status_name,
						'back_link_response_status'	=> $back_link_response_status,
						'back_link_submitted_url'	=> $back_link_submitted_url,
						'comment'	=> $comment,
						'back_link_submitted_datetime'	=> $back_link_submitted_datetime,
					);
				}
				
				if($val->ref_back_link_url_status_id == '3'){
					$data['backlink_expired'][] = (object) array(
						'back_link_url_id'		=> $val->back_link_url_id,
						'back_link_url_to_client_id'=> $back_link_url_to_client_id,
						'back_link_url_name'	=> $val->back_link_url_name,
						'back_link_url_status'	=> $back_link_url_status,
						'back_link_url_status_name'	=> $back_link_url_status_name,
						'back_link_response_status'	=> $back_link_response_status,
						'back_link_submitted_url'	=> $back_link_submitted_url,
						'comment'	=> $comment,
						'back_link_submitted_datetime'	=> $back_link_submitted_datetime,
					);
				}
				
				//~ echo '<pre>';
				//~ print_r( $res_backlink);
				//~ echo '</pre>';
			}
		}
		//exit;
 //~ echo '<pre>';
		//~ print_r( $data['backlink_all']);
		//~ echo '</pre>';
		//~ exit;
 
 $data['source'] = $this->Common_model->getDetails('back_link_source', 'ref_client_id', $data['backlink'][0]->ref_client_id);
 
 $this->load->view('common/menu');
 $this->load->view('backlink/backlink_details_view', $data);
 $this->load->view('common/footer');
 }
 function edit()
 {
 $this->hasPermission('backlink_edit');
 if ($this->input->server('REQUEST_METHOD') == 'POST') {
 $id = $this->uri->segment(3);
 $res = $this->Common_model->updateRecord('back_link',$this->input->post(), $id);
 
			if ($res) {
 $this->Common_model->TxnCommit();
 $this->Common_model->addUserActivity('backlink_edit',$res); // Record User Activity
 $_SESSION['success_msg'] = 'Back Link successfully update ...';
 } else {
 $this->Common_model->TxnRollBack();
 $_SESSION['error_msg'] = 'Error occurred please try again...';
 } 
 redirect('backlink');
 } else {			
 $id = $this->uri->segment(3);
 $where = '';
			$group_by = 'seo_keyword.ref_client_id';
			$order_by = 'client.client_name ASC';
			$data['seo_client'] = $this->Common_model->getRecords('seo_keyword',$group_by,$order_by);
 $data['backlink'] = $this->Common_model->getDetails('back_link', 'back_link_id', $id);
 $data['action'] = site_url('backlink/edit/'.$id); 
 $this->load->view('common/menu');
 $this->load->view('backlink/backlink_form_view', $data);
 $this->load->view('common/footer');
 }
 }
 
 function delete()
 {
 $this->hasPermission('backlink_delete');
		$delete_id = $this->input->post('checkbox'); 
		if(!empty($delete_id)){
			 foreach($delete_id as $key => $id){
				 $this->Backlink_model->removeRecord('back_link', 'back_link_id', $id);
			 }
		}
		redirect('backlink/getlist/1');
 }
 
	 function updateBacklinktoClient()
 {
 $this->hasPermission('backlink_edit');
 if ($this->input->server('REQUEST_METHOD') == 'POST') {
			$data = array();
			$data = $this->input->post();
			//~ echo '<pre>';
			//~ print_r($data);
			//~ echo '</pre>';
			//~ exit;
			$data['back_link_submitted_datetime'] = date('Y-m-d H:i:s');
			$data['back_link_submitted_url'] = $this->Common_model->formatUrl($data['back_link_submitted_url']);
			$res = $this->Backlink_model->updateBacklinktoClient($data);
			$id = $data['ref_back_link_id'];
			$this->Common_model->addUserActivity('backlink_edit',$res); // Record User Activity
			
			$update_data = array();
			$update_data['ref_back_link_url_status_id'] = $data['ref_back_link_url_status_id'];
			$this->Common_model->updateRecord('back_link_url',$update_data,$data['ref_back_link_url_id']);
			if ($res) {
				redirect('backlink/view/' . $id);
			} else {
				echo "Error in updation";
				exit;
			}
 }
 }
 
 function exportBacklink()
 {
 $this->hasPermission('backlink_view');
 $filter_data = '';
 $session_filter_data = $this->session->userdata('filter_data');
 if (isset($session_filter_data)) {
 $filter_data = $session_filter_data;
 } else {
 $filter_data = '';
 }
 $data = array();
 $data['sort'] = 'back_link_id';
 $data['order'] = 'DESC';
 $table['tbl_main'] = 'back_link';
 $mainlist = $this->Common_model->getList($table, $data, $filter_data);
 foreach ($mainlist as $key => $val) {
			 
 $export_list[] = array(
				$val->client_name,
				$val->category_name,
				$val->back_link_type_name,
				$val->client_site_url,
				$val->back_link_user_name,
				$val->back_link_password,
				$val->back_link_mail_id,
				$val->back_link_address,
				$val->back_link_phone,
				$val->back_link_title,
				$val->back_link_tag,
				$val->back_link_description,
				$val->back_link_keyword,
				$val->back_link_meta_description,
				$val->back_link_note
 );
 }
 $export = array();
 $export_column = array(
 'Client',
 'Category',
 'Backlink Type',
 'Client Site',
 'Username',
 'Password',
 'Email',
 'Address',
 'Phone',
 'Title',
 'Tag',
 'Description',
 'Keyword',
 'Meta Description',
 'Note'
 );
 $export[0] = $export_column;
 foreach ($export_list as $export_row) {
 $export[] = $export_row;
 }
 $this->Common_model->generateExcel($export,'Backlink_List' . date('d-m-Y_H:i:s'));
 
 }
 public function exportBacklinkPdf()
 {
 
 $filter_data = '';
 $session_filter_data = $this->session->userdata('filter_data');
 if (isset($session_filter_data)) {
 $filter_data = $session_filter_data;
 } else {
 $filter_data = '';
 }
 $data = array();
 $data['sort'] = 'back_link_id';
 $data['order'] = 'DESC';
 $table['tbl_main'] = 'back_link';
 $mainlist = $this->Common_model->getList($table, $data, $filter_data);
 
 $data['title'] = 'Backlink List';
 
 // Row Header
 $data['row_header'] = array();
 $data['row_header'][] = array(
			'name'		=> 'S.No',
			'width'		=> '5%',
			'align'		=> 'center'
 );
 
 $data['row_header'][] = array(
			'name'		=> 'Client Name',
			'width'		=> '25%',
			'align'		=> 'left'
 );
 
 $data['row_header'][] = array(
			'name'		=> 'Type',
			'width'		=> '20%',
			'align'		=> 'left'
 );
 
 $data['row_header'][] = array(
			'name'		=> 'Category',
			'width'		=> '20%',
			'align'		=> 'left'
 );
 
 $data['row_header'][] = array(
			'name'		=> 'Site',
			'width'		=> '30%',
			'align'		=> 'left'
 );
 
 // Row Data
 $data['row_data'] = array();
 if(isset($mainlist) && !empty($mainlist)){
			$i = 1;
			foreach($mainlist as $key => $val){
				 $data['row_data'][] = array(
					$i,
					$val->client_name,
					$val->back_link_type_name,
					$val->category_name,
					$val->client_site_url
				);
				$i++;
			}
				
		}

$this->load->library('parser');
 $header_html = $this->parser->parse('template/pdf/pdf_header',$data);
		$footer_html = $this->parser->parse('template/pdf/pdf_footer',$data);
 $html = $this->parser->parse('template/pdf/list_tmp', $data);
 
 $file_name = 'Backlink_List_' . date('Y-m-d _ H:i:s') . '.pdf';
 $this->Common_model->exportPdf($header_html,$footer_html,$html,$file_name,'P','I');
 
 }
 
 function getBackLinkDirectoryList()
 {
		$this->hasPermission('backlink_view');
 $filter_data = '';
 if ($this->input->server('REQUEST_METHOD') == 'POST') {
 $filter_data = $this->input->post();
 $reset_data = $this->input->post('reset');
 if (isset($reset_data)) {
 $this->session->unset_userdata('filter_data');
 $filter_data = '';
 } else {
 $this->session->set_userdata('filter_data', $filter_data);
 }
 } else {
 $session_filter_data = $this->session->userdata('filter_data');
 if (isset($session_filter_data)) {
 $filter_data = $session_filter_data;
 } else {
 $filter_data = '';
 }
 }
 $data['filter_data'] = $filter_data;
 $segment_3 = $this->uri->segment(3);
 $segment_4 = $this->uri->segment(4);
 $segment_5 = $this->uri->segment(5);
 // If not pagination page remove filter data from session
 if (!isset($segment_3) && $this->input->server('REQUEST_METHOD') != 'POST') {
 $this->session->unset_userdata('filter_data');
 $filter_data = '';
 $data['filter_data'] = '';
 }
 if (isset($segment_3)) {
 $page = $segment_3;
 } else {
 $page = '1';
 }
 if (isset($segment_4)) {
 $sort = $segment_4;
 } else {
 $sort = 'back_link_url_id';
 }
 if (isset($segment_5)) {
 $order = $segment_5;
 } else {
 $order = 'DESC';
 }
 
 $data['page'] = $page; // No used for Redirect to same page after delete action in page 2, page 3,etc...
 
 $filter_query_data = array();
 $data['limit'] = '';
 if(isset($_REQUEST['limit']) && !empty($_REQUEST['limit'])){
 $start = (($page - 1) * $_REQUEST['limit']);
 $filter_query_data['limit'] = $_REQUEST['limit'];
 $data['limit'] = '?limit='.$_REQUEST['limit'];
 }else{
 $start = (($page - 1) * RPP);
 }
 
 $data['start'] = $start; // Generate SNO in result table based on page number
 $filter_query_data['start'] = $start;
 $filter_query_data['sort'] = $sort;
 $filter_query_data['order'] = $order;
 
 // $start = (($page - 1) * RPP);
 // $data['start'] = $start;
 // $data['sort'] = $sort;
 // $data['order'] = $order;
 
 $table = array();
 $table['tbl_main'] = 'back_link_url';
 $data['mainlist_count'] = $this->Common_model->getListCount($table, $filter_data);
 $backlink_list = '';
 $data['mainlist'] = $this->Common_model->getList($table, $filter_query_data, $filter_data);
 
 $data['tablefields'] = $this->Common_model->getTableFields('back_link_url');
 
 $data['operations'] = $this->Common_model->getFilterOperation();
 $data['init_listing_page'] = 'backlink/getBackLinkDirectoryList/';
 $data['listing_page'] = $data['init_listing_page'] . $page . '/';
		//$data['page'] = $page;
 $data['filter_block'] = $this->parser->parse('common/filter', $data, true);
 $this->load->view('common/menu');
 $this->load->view('backlink/backlink_directory_list_view', $data);
 $this->load->view('common/footer');
 }
 
 function uploadBackLinkDirectory()
 {
 $this->hasPermission('backlink_add');
 $data['action'] = site_url('backlink/backlinkdirectoryadd');
 if ($this->input->server('REQUEST_METHOD') == 'POST') {
			$main_data = $this->input->post();		
		$path = $_FILES['reference_file']['tmp_name'];;
		$data = new Spreadsheet_Excel_Reader($path);
		 $tot_dup = 0;
		 $tot_ins = 0;
		for($i=0;$i<count($data->sheets);$i++) // Loop to get all sheets in a file.
		{	
			if(count($data->sheets[$i][cells])>0) // checking sheet not empty
			{
				for($j=1;$j<=count($data->sheets[$i][cells]);$j++) // loop used to get each row of the sheet
				{ 
					$back_link_url = $this->Common_model->formatUrl(trim($data->sheets[$i][cells][$j][1]));
					$res_backlink = $this->Common_model->getDetails('back_link_url','back_link_url_name',trim($back_link_url));
					if(isset($res_backlink) && !empty($res_backlink)){
						 $tot_dup++;
					}else{
						$tot_ins++;
						$main_data['back_link_url_name'] = $back_link_url; 
						$main_data['ref_back_link_url_status_id'] = '1'; 
						$res = $this->Common_model->addRecord('back_link_url',$main_data);
					}
				}
			}
		}
			 
		if ($res) {
			$this->Common_model->TxnCommit();
			$this->Common_model->addUserActivity('backlinkurl_add', $res); // Record User Activity
			$_SESSION['success_msg'] = 'Back Link File successfully uploaded ... Success : '.$tot_ins.' Duplicate : '.$tot_dup;
		} else {
			$this->Common_model->TxnRollBack();
			$_SESSION['error_msg'] = 'Error occurred please try again... Duplicate : '.$tot_dup;
		}
		redirect('backlink/getBackLinkDirectoryList');
 
 } else {
			$this->load->view('common/menu');
			$this->load->view('backlink/backlink_directory_upload_form_view');
			$this->load->view('common/footer');
 }
 }
 
 
 function addBackLinkDirectory()
 {
 $this->hasPermission('backlink_add');
 $data['action'] = site_url('backlink/backlinkdirectoryadd');
 if ($this->input->server('REQUEST_METHOD') == 'POST') {
			$main_data = $this->input->post();
			$main_data['back_link_url_name'] = $this->Common_model->formatUrl(trim($main_data['back_link_url_name']));
			$res = $this->Common_model->addRecord('back_link_url',$main_data);			 
		if ($res) {
			$this->Common_model->TxnCommit();
			$this->Common_model->addUserActivity('backlinkurl_add', $res); // Record User Activity
			$_SESSION['success_msg'] = 'Back Link File successfully added ...';
		} else {
			$this->Common_model->TxnRollBack();
			$_SESSION['error_msg'] = 'Error occurred please try again...';
		}
		redirect('backlink/getBackLinkDirectoryList');
 } else {
			$this->load->view('common/menu');
			$this->load->view('backlink/backlink_directory_form_view');
			$this->load->view('common/footer');
 }
 }
 
 function editBackLinkDirectory()
 {
 $this->hasPermission('backlink_edit');
 $id = $this->uri->segment(3);
 $data['action'] = site_url('backlink/editBackLinkDirectory/'.$id); 
 if ($this->input->server('REQUEST_METHOD') == 'POST') {
			$data = $this->input->post();
			$data['back_link_url_name']= $this->Common_model->formatUrl($data['back_link_url_name']); 
 $res = $this->Common_model->updateRecord('back_link_url',$data, $id);
 			
			if ($res) {
 $this->Common_model->TxnCommit();
 $this->Common_model->addUserActivity('backlinkurl_edit', $res); // Record User Activity
 $_SESSION['success_msg'] = 'Back Link successfully updated ...';
 } else {
 $this->Common_model->TxnRollBack();
 $_SESSION['error_msg'] = 'Error occurred please try again...';
 }
 redirect('backlink/getBackLinkDirectoryList');
 } else { 
 $data['backlink'] = $this->Common_model->getDetails('back_link_url', 'back_link_url_id', $id);
 
 $this->load->view('common/menu');
 $this->load->view('backlink/backlink_directory_form_view', $data);
 $this->load->view('common/footer');
 }
 }
 
 function exportBackLinkDirectory()
 {
 $this->hasPermission('backlink_view');
 $filter_data = '';
 $session_filter_data = $this->session->userdata('filter_data');
 if (isset($session_filter_data)) {
 $filter_data = $session_filter_data;
 } else {
 $filter_data = '';
 }
 $data = array();
 $data['sort'] = 'back_link_url_id';
 $data['order'] = 'DESC';
 $table['tbl_main'] = 'back_link_url';
 $mainlist = $this->Common_model->getList($table, $data, $filter_data);
 foreach ($mainlist as $key => $val) {
			 
 $export_list[] = array(
				$val->back_link_type_name,
				$val->back_link_url_name,
				$val->back_link_url_status_name				
 );
 }
 $export = array();
 $export_column = array( 
 'Backlink Type',
 'Link',
 'Link Status' 
 );
 $export[0] = $export_column;
 foreach ($export_list as $export_row) {
 $export[] = $export_row;
 }
 $this->Common_model->generateExcel($export,'Backlink_Directory_List' . date('d-m-Y_H:i:s'));
 
 }
 
 
 function deleteBacklinkUrl()
 {
 $this->hasPermission('backlink_delete');
		$delete_id = $this->input->post('checkbox'); 
		if(!empty($delete_id)){
			 foreach($delete_id as $key => $id){
				 $this->Common_model->removeRecord('back_link_url', 'back_link_url_id', $id);
			 }
		}
		redirect('backlink/getBackLinkDirectoryList');
 }
 
	function excelTest(){
		$data['file'] = $_FILES['reference_file'];	
		echo '<pre>';
		print_r($data['file'] );
		echo '</pre>';
		exit;
		echo $path = FCPATH.'uploads/example.xls';
		$data = new Spreadsheet_Excel_Reader($path);
		echo "Total Sheets in this xls file: ".count($data->sheets)." ";
		 
		$html="<table border='1'>";
		for($i=0;$i<count($data->sheets);$i++) // Loop to get all sheets in a file.
		{	
			if(count($data->sheets[$i][cells])>0) // checking sheet not empty
			{
				echo "Sheet $i: Total rows in sheet $i ".count($data->sheets[$i][cells])." ";
				for($j=1;$j<=count($data->sheets[$i][cells]);$j++) // loop used to get each row of the sheet
				{ 
					$html.="<tr>";
					for($k=1;$k<=count($data->sheets[$i][cells][$j]);$k++) // This loop is created to get data in a table format.
					{
						$html.="<td>";
						$html.=$data->sheets[$i][cells][$j][$k];
						$html.="</td>";
					}
					$eid = mysqli_real_escape_string($connection,$data->sheets[$i][cells][$j][1]);
					$name = mysqli_real_escape_string($connection,$data->sheets[$i][cells][$j][2]);
					$email = mysqli_real_escape_string($connection,$data->sheets[$i][cells][$j][3]);
					$dob = mysqli_real_escape_string($connection,$data->sheets[$i][cells][$j][4]);
					$query = "insert into excel(eid,name,email,dob) values('".$eid."','".$name."','".$email."','".$dob."')";
		 
					mysqli_query($connection,$query);
					$html.="</tr>";
				}
			}
		 
		}
		 
		$html.="</table>";
		echo $html;
		echo " Data Inserted in dababase";
	}	
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Backlink.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation