<?php
class Mainmodel extends CI_Model{
        function __construct() {
        parent::__construct();
		$this->load->database();
      }
    public function select_result_or_where($table,$where,$or_where)
    {
    	$this->db->select('*');
		$this->db->from($table);
		$this->db->where($where);
		$this->db->or_where($or_where);
		$query = $this->db->get();
		$result = $query->row();
		return $result;
    }


    function get_manuscript_list()
	{
		$this->db->select('manuscript_tracking.*');
		$this->db->from('manuscript_tracking');
		$this->db->order_by('manuscript_tracking.id desc');
		$result = $this->db->get()->result();
		return $result;
	}
	
    function GetSortOrder($table,$column)
	{
		$this->db->select_max($column);
		$result = $this->db->get($table)->row();  
		$sort_order = $result->$column+1;
		return $sort_order;
	}

	function get_issues($slug)
    {                  
	    $this->db->select('issues.*,current_issue.current_issue_title');
	    $this->db->from('issues');
	    $this->db->join('current_issue','current_issue.current_issue_id=issues.current_issue_id');
	    $this->db->where(array('current_issue.status!='=>'Deleted','issues.status!='=>'Deleted','issues_slug'=>$slug));
	    $this->db->order_by('issues.sort_order desc');
		$result = $this->db->get()->result();
		return $result;
    }

    function get_articles($slug)
    {                  
	    $this->db->select('articals.*,current_issue.current_issue_title');
	    $this->db->from('articals');
	    $this->db->join('current_issue','current_issue.current_issue_id=articals.current_issue');
	    $this->db->where(array('current_issue.status!='=>'Deleted','articals.status!='=>'Deleted','articles_slug'=>$slug));
	    $this->db->order_by('articals.sort_order desc');
		$result = $this->db->get()->result();
		return $result;
    }

    function get_events($slug)
    {                  
	    $this->db->select('events.*');
	    $this->db->from('events');
	    $this->db->where(array('status!='=>'Deleted','event_slug'=>$slug));
	    $this->db->order_by('events.sort_order desc');
		$result = $this->db->get()->row();
		return $result;
    }  

    function get_journals($slug)
    {                  
	    $this->db->select('*');
	    $this->db->from('journal');
	    $this->db->where(array('status!='=>'Deleted','journal_slug'=>$slug));
	    $this->db->order_by('journal.sort_order desc');
		$result = $this->db->get()->row();
		return $result;
    }  

    function get_archives_list()
	{
		$this->db->select('articals.*,current_issue.current_issue_title,current_issue.current_issue_year');
		$this->db->from('articals');
		$this->db->join('current_issue','current_issue.current_issue_id=articals.current_issue');
		$this->db->where(array('current_issue.status!='=>'Deleted','articals.status!='=>'Deleted'));
	//	$this->db->group_by('current_issue.current_issue_year');
		//$this->db->order_by('articals.sort_order desc');
		$result = $this->db->get()->result();
		return $result;
	}

	function get_current_year_issue()
    {   
	    $this->db->select('GROUP_CONCAT(DISTINCT `current_issue_title` SEPARATOR  " | ") as issue_title,
     GROUP_CONCAT("<a href='.base_url().'archive/",li_articals.articles_slug,">",li_articals.articles_title, "  <b style=color:black;> ( ",li_articals.city," ) </b> </a>" SEPARATOR "<br>") as arti_title ,articles_slug,current_issue_year,current_issue.added_date');
	    $this->db->from('current_issue');
	    $this->db->join('articals','articals.current_issue_id=current_issue.current_issue_id');
	    $this->db->where('articals.is_archive','yes');
	    $this->db->group_by('articals.current_issue_id');
	    $this->db->group_by('current_issue.current_issue_year');
	    $this->db->order_by('current_issue.current_issue_year desc');
		$result = $this->db->get()->result();
		return $result;
    }
    
    
	function get_all_archives_list1()
    {   
	   $this->db->select('GROUP_CONCAT(DISTINCT `current_issue_title` SEPARATOR  " | ") as issue_title,
     GROUP_CONCAT("<a href='.base_url().'archive/",li_articals.articles_slug,">",li_articals.articles_title, "  <b style=color:black;> ( ",li_articals.city," ) </b> </a>" SEPARATOR "<br>") as arti_title ,articles_slug,current_issue_year,current_issue.added_date');
	    $this->db->from('current_issue');
	    $this->db->join('articals','articals.current_issue_id=current_issue.current_issue_id');
	    $this->db->where('articals.is_archive','yes');
	    //$this->db->group_by('articals.current_issue_id');
	    $this->db->group_by('current_issue.current_issue_year');
	    $this->db->order_by('current_issue.current_issue_year desc');
		$result = $this->db->get()->result();
		return $result;
		
	
    }
    
    function get_all_archives_list()
	{
		$query=$this->db->query("SELECT DISTINCT(`current_issue_year`) FROM li_current_issue order by current_issue_year DESC");
		$result=$query->result();
		return $result;
	}
	
	
	function get_articals_list()
	{
		$this->db->select('articals.*,current_issue.current_issue_title,current_issue.current_issue_year');
		$this->db->from('articals');
		$this->db->join('current_issue','current_issue.current_issue_id=articals.current_issue');
		$this->db->where(array('current_issue.status!='=>'Deleted','articals.status!='=>'Deleted','articals.is_archive!='=>'yes'));
		$this->db->order_by('articals.sort_order desc');
		$result = $this->db->get()->result();
		return $result;
	}
	
	function get_archived_articals_list()
	{
		$this->db->select('articals.*,current_issue.current_issue_title');
		$this->db->from('articals');
		$this->db->join('current_issue','current_issue.current_issue_id=articals.current_issue');
		$this->db->where(array('current_issue.status!='=>'Deleted','articals.status!='=>'Deleted','articals.is_archive'=>'yes'));
		$this->db->order_by('articals.sort_order desc');
		$result = $this->db->get()->result();
		return $result;
	}

	function get_journal_list()
	{
		$this->db->select('*');
		$this->db->from('journal');
		$this->db->where(array('status!='=>'Deleted'));
		$this->db->order_by('sort_order desc');
		$result = $this->db->get()->result();
		return $result;
	}

	
	function get_issues_list()
	{
		$this->db->select('issues.*,current_issue.current_issue_title');
		$this->db->from('issues');
		$this->db->join('current_issue','current_issue.current_issue_id=issues.current_issue_id');
		$this->db->where(array('current_issue.status!='=>'Deleted','issues.status!='=>'Deleted'));
		$this->db->order_by('issues.sort_order desc');
		$result = $this->db->get()->result();
		return $result;
	}
	
	function get_issues_lists()
	{
		 $query=$this->db->query("SELECT * FROM `li_articals` INNER JOIN `li_current_issue` ON `li_current_issue`.current_issue_id = `li_articals`.current_issue WHERE `current_issue` =(SELECT `current_issue` FROM `li_articals` WHERE `articles_id`=(SELECT MAX(`articles_id`) from `li_articals` WHERE `is_archive`='yes')) AND `is_archive`='yes' ");
		 $result=$query->result();
		 return $result;
		 
		
	}
	
	 function get_links($slug)
    {                  
	    $this->db->select('recommended_journals.*');
	    $this->db->from('recommended_journals');
	    $this->db->where(array('status!='=>'Deleted','rjournal_link'=>$slug));
	    $this->db->order_by('recommended_journals.id desc');
		$result = $this->db->get()->row();
		return $result;
    } 
	
	function get_issues_list1()
	{
		$query=$this->db->query("SELECT * ,`li_articals`.`mov_date` as adate FROM `li_articals` INNER JOIN `li_current_issue` ON `li_current_issue`.current_issue_id = `li_articals`.current_issue WHERE `current_issue` =(SELECT `current_issue` FROM `li_articals` WHERE `articles_id`=(SELECT MAX(`articles_id`) from `li_articals` WHERE `is_archive`='yes')) AND `is_archive`='yes' limit 0,6");
		//echo $this->db->last_query();die;
		$result=$query->result();
		return $result;
		
	}
	
	function get_issues_list2()
	{
		$query=$this->db->query("SELECT * ,`li_articals`.`mov_date` as adate FROM `li_articals` INNER JOIN `li_current_issue` ON `li_current_issue`.current_issue_id = `li_articals`.current_issue WHERE `current_issue` =(SELECT `current_issue` FROM `li_articals` WHERE `articles_id`=(SELECT MAX(`articles_id`) from `li_articals` WHERE `is_archive`='yes')) AND `is_archive`='yes' ");
		//echo $this->db->last_query();die;
		$result=$query->result();
		return $result;
		
	}
	
	function get_currentissues_list()
	{
		  $this->db->select('*');
          $this->db->from('issues');
          $this->db->join('current_issue','current_issue.current_issue_id=issues.current_issue_id');
		  $this->db->where(array('current_issue.status!='=>'Deleted','issues.status!='=>'Deleted'));
          $this->db->where('MONTH(li_issues.added_date)', date('m')); //For current month
          $this->db->where('YEAR(li_issues.added_date)', date('Y')); // For current year
          $this->db->where('MONTH(li_current_issue.added_date)', date('m')); //For current month
          $this->db->where('YEAR(li_current_issue.added_date)', date('Y')); // For current year
          $this->db->order_by('issues.sort_order desc');
          $query = $this->db->get();

           $res   = $query->result();        
          return $res;
	}
	

	function get_current_issues_list()
	{
		$this->db->select('current_issue.*');
		$this->db->from('current_issue');
		$this->db->where(array('current_issue.status!='=>'Deleted'));
		$this->db->order_by('current_issue.modified_date desc');
		$result = $this->db->get()->result();
		return $result;
	}

	
	function records_join_query($columns,$table,$condition,$joins)
	{
		$this->db->select($columns);
		$this->db->from($table);
		if (is_array($joins) && count($joins) > 0)
		{
			foreach($joins as $k => $v)
			{
				$this->db->join($v['table'], $v['condition'], $v['jointype']);
			}
		}
		$this->db->where($condition);
		$query=$this->db->get(); 
		$result=$query->result();
		$query->free_result();
		return $result;
	}
	
	function select_results_join_clause($columns,$table,$condition,$joins,$optinal)
	{
		$this->db->select($columns);
		$this->db->from($table);
		if (is_array($joins) && count($joins) > 0)
		{
			foreach($joins as $k => $v)
			{
				$this->db->join($v['table'], $v['condition'], $v['jointype']);
			}
		}
		$this->db->where($condition);
		if($optinal!="")
		{
			$clause = explode(",",$optinal);
			$string = substr($optinal, strpos($optinal, ",") + 1); 
			if($clause[0]=="group_by")
			{
				$this->db->group_by($string);
			}
			else
			{
				$this->db->order_by($string);
			}
		}
		$query=$this->db->get(); 
		$result=$query->result();
		$query->free_result();
		return $result;
	}

  	function get_sort_order($table,$where)
    {
        $this->db->select('sort_order');
        $this->db->where($where);
        $this->db->order_by('sort_order desc');
        $this->db->limit('1');
        $this->db->from($table);
        $result = $this->db->get();
        $sort_order=$result->row_array();
        return $sort_order['sort_order']+1;
    }

    function nextId( $table , $id ){

		$this->db->select_max( $id );
		$query = $this->db->get( $table );
		if ($query->num_rows() > 0)
		{
			$row = $query->row();
			$nextid= $row->$id + 1;
		}   
		else
		{
		$nextid= 1;
		}    
       return $nextid;
    }
    function select_results_oredr_by( $table,$order_by)
    {
        $query = $this->db->select('*')->from($table)->order_by($order_by)->get();
		$result = $query->result();
		$query->free_result();
        return $result;
    }
  
	function status_deactive($table,$where)
	{
		$this->db->set('status','Deactive');
		$this->db->where($where);
		$update=$this->db->update($table);
		return $update;
	}
	
	function select_single_row($table, $where)
	{
		$this->db->select('*');
		$this->db->from($table);
		$this->db->where($where);
		$query = $this->db->get();
		$result = $query->row();
		return $result;
	}
    function select_row( $table ){
        $query = $this->db->get( $table );
		$result = $query->row_array();
		$query->free_result();
	 	return $result;
    }

    function select_object_row($table , $whereclause){
		$this->db->where($whereclause);
		$query = $this->db->get($table);
		$result = $query->result();
		return $result;	   
	} 
	
//Creat thumb
	function _createThumbnail($fileName, $width, $height, $dir,$spath) {
		$this->load->library('image_lib');
        $this->image_lib->clear();
        $config['image_library'] = 'gd2';
        $config['thumb_marker'] = '';
        $config['source_image'] = './common/front/' .$spath."/".$fileName;
        $config['new_image'] = './common/front/' .$spath."/".$dir.'/' . $fileName;
	    $config['maintain_ratio'] = TRUE;
        $config['width'] = $width;
        $config['height'] = $height;
        $this->image_lib->initialize($config);
        if(!$this->image_lib->resize()) echo $this->image_lib->display_errors();
    }
	
    function insertData( $table ) {

        $fields = $this->db->list_fields( $table );
        $data = array();
        foreach ( $fields as $field ) {
            if (isset($_POST[$field]))
			{
                $data[$field]= $this->input->post($field);
                if (is_array($_POST[$field])) 
				{
				 $data[$field] = implode( ',',array_map('strtolower',$this->input->post($field)) );
				}
				else
				{
					$data[$field]= $this->input->post($field);
				}
            }
        }
        $result=$this->db->insert($table, $data);
		return $result;
    }


	//funtion select data from table as single row array with where claus

    function select_row_where( $table , $whereclaus )
    {
        $query = $this->db->get_where( $table, $whereclaus );
		$result = $query->row_array();
		$query->free_result();
        if($result)
	    {
		 return $result;
	    }
    }

	
	//function get results from table as multi rows with where clause

	function select_results_where( $table , $whereclaus)
    {
		$query = $this->db->get_where( $table, $whereclaus );
		$result = $query->result();
		$query->free_result();
		return $result;
    }	

	function select_results_where1( $table , $whereclaus ,$order_by="" )
    {
		$this->db->select('*');
		$this->db->from($table);
		$this->db->where($whereclaus);
		if($order_by!="")
		$this->db->order_by($order_by);
		$query=$this->db->get(); 
		$result=$query->result();
		$query->free_result();
		return $result;
    }	


//Id,table,where

//Count Records
	function select_where_row($id, $table, $where)
	{
		$this->db->select($id);
		$this->db->from($table);
		$this->db->where($where);
		$query = $this->db->get();
		return $query->row_array();
   }
	//function select data from table as single row object 

    function select_row_object(  $table )
    {
        $query = $this->db->get( $table);
  	 	$result = $query->row();
		$query->free_result();
        return $result;
    }


//Select Query with para()
	function select_row_allpara($id, $table, $where, $order_by, $limit,$start)
	{
		$this->db->select($id);
		$this->db->from($table);
		$this->db->where($where);
		$this->db->order_by($order_by);
		$this->db->limit($limit, $start);
		$query = $this->db->get();
		return $query->row_array();
   }
	//function select data as results

	// use foreach to select data	

	function select_results( $table )
    {
        $query = $this->db->get( $table );
		$result = $query->result();
		$query->free_result();
        return $result;
    }

	//Update Controller
	function update($data,$conditions,$tablename="")
	{
		if($tablename=="")
		$tablename = $this->table;
		$this->db->where($conditions);
		$this->db->update($tablename,$data);
		return $this->db->affected_rows();
	}

	//Count Records
	function count_all($id, $table, $where='')
	{	
		$this->db->select($id);
		$this->db->from($table);
		if($where)
		{$this->db->where($where);}
		$query = $this->db->get();
		return $query->num_rows();
   }

	//Count Records
	function count_all_sort($id, $table, $where)
	{
		$this->db->select($id);
		$this->db->from($table);
		$this->db->where($where);
		$query = $this->db->get();
		return $query->num_rows();
   }

	function updateData( $table , $id , $idValue)
	{		
		$fields = $this->db->list_fields( $table );		
		$data = array();			
		foreach ( $fields as $field )
		{		
			if (isset($_POST[$field]))
			{ 
				$data[$field]= $this->input->post($field);
				if ( is_array($_POST[$field] ))	
				{
					$data[$field]= implode( ',',array_map('strtolower',$this->input->post($field)) );		
				}	
			    else
			    {
				   $data[$field]= $this->input->post($field);
				}
            }
		}		
		$this->db->where($id, $idValue);		
		$this->db->update($table, $data);		
	}
	 
	function delete($id,$tablename)
    {
		$this->db->where($id);
		$result = $this->db->delete($tablename);
		return $result;
    }
	
	//Function to delete single record 
	function delete_record($del_cond,$tablename)
    {	
		$this->db->where($del_cond);
		$this->db->delete($tablename);
    }
	function approve_listing($cond,$table)
	{
		$this->db->where($del_cond);
		$this->db->update($tablename);
	}
	
    //change password
	 function change_password($oldPass,$newPass)
	 {
		 $data   =  array('password'=> $newPass); 
		 $table  =  'cc_users';
		 $where	 = 	array
		 (
		 	'password'  => $oldPass,
			'username'  => $this->session->userdata('username')
		 );
			
		$this->db->select('*');
		$this->db->where($where);
		$query = $this->db->get('users');
		$query->num_rows();
		if($query->num_rows() > 0)
		{
			$this->db->update('users', $data);
			return $query->result();
		}
		else
		{
			return false;
		}
	 }


function checksortorder($table,$sort)
{
  $this->db->select('sort_order');
  $this->db->where(array('sort_order'=>$sort,'status!='=>'Deleted'));
  $query=$this->db->get($table);
   $result = $query->result();
    if ($result)
	{
        return false;
    }
    else
	{
        return true;
	}
}

function ind_date_time($date)
{  
	$month = array(1=>"Jan", "Feb", "Mar", "Apr", "May", "Jun","Jul", "Aug", "Sept", "Oct", "Nov", "Dec");
	$part1 = explode(" ", $date);
    $date = explode("-", $part1[0]); 
	$year = $date[0];
	$day = $date[2];
	$month = $month[(int)$date[1]];
	$date = $day." ".$month.", ".$year;	
	$finalDate = $date;
	return $finalDate;
}

function ind_date_time1($date)
{  
	$month = array(1=>"Jan", "Feb", "Mar", "Apr", "May", "Jun","Jul", "Aug", "Sept", "Oct", "Nov", "Dec");
	$part1 = explode(" ", $date);
    $date = explode("-", $part1[0]); 
	$year = $date[0];
	$day = $date[2];
	$month = $month[(int)$date[1]];
	$date = $day." ".$month.", ".$year;	
	$finalDate = $date." ".$part1[1];
	return $finalDate;
}
/*Function to get array of location assigned*/
function getAssignedlocation($table='',$where='',$field)
{
	$res=$this->select_results_where($table,$where);
	$arr=array();
	foreach($res as $res)
	{
		array_push($arr,$res->$field);
	}
	return $arr;
}


function multiexplode($delimiters,$string) {

    $ready = str_replace($delimiters, $delimiters[0], $string);
	$ready=rtrim($ready,",");
    $launch = explode($delimiters[0], $ready);
	
    return  $launch;
	}

public function random_string_file_nm($length=6,$file_nm = null){
		$doc_ext_arr = explode(".",$_FILES[$file_nm]['name']);	
		$doc_ext = end($doc_ext_arr);
		$str_1 = substr(str_shuffle("Aa1Bb2Cc3Dd4Ee5Ff6Gg7Hh8Ii9Jj0Kk1Ll2Mm3Nn4Oo5Pp6Qq7Rr8Ss9Tt0Uu1Vv2Ww3Xx4Yy5Zz6"), 0, $length);
		$str_2 = substr(str_shuffle("aA1bB2cC3dD4eE5fF6gG7hH8iI9jJ0kK1lL2mM3nN4oO5pP6qQ7rR8sS9tT0uU1vV2wW3xX4yY5zZ6"), 0, $length);
		$str_3 = substr(str_shuffle("1Aa2Bb3Cc4Dd5Ee6Ff7Gg8Hh9Ii0Jj1Kk2Ll3Mm4Nn5Oo6Pp7Qq8Rr9Ss0Tt1Uu2Vv3Ww4Xx5Yy6Zz"), 0, $length);
		$str_4 = substr(str_shuffle("1aA2bB3cC4dD5eE6fF7gG8hH9iI0jJ1kK2lL3mM4nN5oO6pP7qQ8rR9sS0tT1uU2vV3wW4xX5yY6zZ"), 0, $length);
		$str_5 = substr(str_shuffle(time()), 0, $length);
		$str   = $str_1.'_'.$str_2.'_'.$str_3.'_'.$str_4.'_'.$str_5;
		return $str.".".$doc_ext;
	}
	
public function doc_upload($length,$file,$path=null){
		$dir = "{$path}";
		$new =null;
		if(!empty($_FILES[$file]['name'])){
			$new = $this->random_string_file_nm(6,$file);
			move_uploaded_file($_FILES[$file]['tmp_name'],$dir.'/'.$new);
		}
		return $new;
	}


function master_xml()
	{
		$xml_name = 'sitemap.xml';
		$date = date('Y-m-d');
		$n_xml= '';
		$n_xml .= '<?xml version="1.0" encoding="UTF-8"?>'.PHP_EOL;
		$n_xml .= '<urlset
		xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"
		xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
		xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9
		http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd">'.PHP_EOL;
		
		$n_xml .= '<url>'.PHP_EOL;
		$n_xml .= '<loc>'.base_url().'</loc>'.PHP_EOL;
		$n_xml .= '<priority>0.80</priority>'.PHP_EOL;
		$n_xml .= '<changefreq>daily</changefreq>'.PHP_EOL;
		$n_xml .= '</url>'.PHP_EOL;
	
		
		$n_xml .= '<url>'.PHP_EOL;
		$n_xml .= '<loc>'.base_url().'aim.html</loc>'.PHP_EOL;
		$n_xml .= '<priority>0.80</priority>'.PHP_EOL;
		$n_xml .= '<changefreq>daily</changefreq>'.PHP_EOL;
		$n_xml .= '</url>'.PHP_EOL;
	

		$n_xml .= '<url>'.PHP_EOL;
		$n_xml .= '<loc>'.base_url().'board.html</loc>'.PHP_EOL;
		$n_xml .= '<priority>0.80</priority>'.PHP_EOL;
		$n_xml .= '<changefreq>daily</changefreq>'.PHP_EOL;
		$n_xml .= '</url>'.PHP_EOL;
		
		$n_xml .= '<url>'.PHP_EOL;
		$n_xml .= '<loc>'.base_url().'article.html</loc>'.PHP_EOL;
		$n_xml .= '<priority>0.80</priority>'.PHP_EOL;
		$n_xml .= '<changefreq>daily</changefreq>'.PHP_EOL;
		$n_xml .= '</url>'.PHP_EOL;
		
		$n_xml .= '<url>'.PHP_EOL;
		$n_xml .= '<loc>'.base_url().'issues.html</loc>'.PHP_EOL;
		$n_xml .= '<priority>0.80</priority>'.PHP_EOL;
		$n_xml .= '<changefreq>daily</changefreq>'.PHP_EOL;
		$n_xml .= '</url>'.PHP_EOL;
		
		$n_xml .= '<url>'.PHP_EOL;
		$n_xml .= '<loc>'.base_url().'archives.html</loc>'.PHP_EOL;
		$n_xml .= '<priority>0.80</priority>'.PHP_EOL;
		$n_xml .= '<changefreq>daily</changefreq>'.PHP_EOL;
		$n_xml .= '</url>'.PHP_EOL;
		
		$n_xml .= '<url>'.PHP_EOL;
		$n_xml .= '<loc>'.base_url().'instruction.html</loc>'.PHP_EOL;
		$n_xml .= '<priority>0.80</priority>'.PHP_EOL;
		$n_xml .= '<changefreq>daily</changefreq>'.PHP_EOL;
		$n_xml .= '</url>'.PHP_EOL;
		
		$n_xml .= '<url>'.PHP_EOL;
		$n_xml .= '<loc>'.base_url().'reprints.html</loc>'.PHP_EOL;
		$n_xml .= '<priority>0.80</priority>'.PHP_EOL;
		$n_xml .= '<changefreq>daily</changefreq>'.PHP_EOL;
		$n_xml .= '</url>'.PHP_EOL;
		
		$n_xml .= '<url>'.PHP_EOL;
		$n_xml .= '<loc>'.base_url().'submit.html</loc>'.PHP_EOL;
		$n_xml .= '<priority>0.80</priority>'.PHP_EOL;
		$n_xml .= '<changefreq>daily</changefreq>'.PHP_EOL;
		$n_xml .= '</url>'.PHP_EOL;
		
		$n_xml .= '<url>'.PHP_EOL;
		$n_xml .= '<loc>'.base_url().'contact.html</loc>'.PHP_EOL;
		$n_xml .= '<priority>0.80</priority>'.PHP_EOL;
		$n_xml .= '<changefreq>daily</changefreq>'.PHP_EOL;
		$n_xml .= '</url>'.PHP_EOL;
		
		$n_xml .= '<url>'.PHP_EOL;
		$n_xml .= '<loc>'.base_url().'open-access.html</loc>'.PHP_EOL;
		$n_xml .= '<priority>0.80</priority>'.PHP_EOL;
		$n_xml .= '<changefreq>daily</changefreq>'.PHP_EOL;
		$n_xml .= '</url>'.PHP_EOL;
		
		$n_xml .= '<url>'.PHP_EOL;
		$n_xml .= '<loc>'.base_url().'biography.html</loc>'.PHP_EOL;
		$n_xml .= '<priority>0.80</priority>'.PHP_EOL;
		$n_xml .= '<changefreq>daily</changefreq>'.PHP_EOL;
		$n_xml .= '</url>'.PHP_EOL;
		
		
	  $articles = $this->db->select('articles_id,articles_slug')->from('articals')->where(array('status'=>'Active','is_archive'=>'no'))->order_by('articles_id asc')->get()->result();
		if(!empty($articles))
		{
			foreach($articles as $article)
			{
			
				$n_xml .= '<url>'.PHP_EOL;
				$n_xml .= '<loc>'.base_url().'archive/'.$article->articles_slug.'</loc>'.PHP_EOL;
				$n_xml .= '<priority>0.80</priority>'.PHP_EOL;
				$n_xml .= '<changefreq>daily</changefreq>'.PHP_EOL;
				$n_xml .= '</url>'.PHP_EOL;
				
			}
		}
		
		$archives = $this->db->select('articles_id,articles_slug')->from('articals')->where(array('status'=>'Active','is_archive'=>'yes'))->order_by('articles_id asc')->get()->result();
		if(!empty($archives))
		{
			foreach($archives as $archive)
			{
			
				$n_xml .= '<url>'.PHP_EOL;
				$n_xml .= '<loc>'.base_url().'archive/'.$archive->articles_slug.'</loc>'.PHP_EOL;
				$n_xml .= '<priority>0.80</priority>'.PHP_EOL;
				$n_xml .= '<changefreq>daily</changefreq>'.PHP_EOL;
				$n_xml .= '</url>'.PHP_EOL;
				
			}
		}

        $journals = $this->db->select('id,journal_slug')->from('journal')->where(array('status'=>'Active'))->order_by('id asc')->get()->result();
		if(!empty($journals))
		{
			foreach($journals as $journal)
			{
			
				$n_xml .= '<url>'.PHP_EOL;
				$n_xml .= '<loc>'.base_url().'journal/'.$journal->journal_slug.'</loc>'.PHP_EOL;
				$n_xml .= '<priority>0.80</priority>'.PHP_EOL;
				$n_xml .= '<changefreq>daily</changefreq>'.PHP_EOL;
				$n_xml .= '</url>'.PHP_EOL;
				
			}
		}
		
		$events = $this->db->select('id,event_slug')->from('events')->where(array('status'=>'Active'))->order_by('id asc')->get()->result();
		if(!empty($events))
		{
			foreach($events as $event)
			{
			
				$n_xml .= '<url>'.PHP_EOL;
				$n_xml .= '<loc>'.base_url().'event/'.$event->event_slug.'</loc>'.PHP_EOL;
				$n_xml .= '<priority>0.80</priority>'.PHP_EOL;
				$n_xml .= '<changefreq>daily</changefreq>'.PHP_EOL;
				$n_xml .= '</url>'.PHP_EOL;
				
			}
		}
		
		$link = $this->db->select('rjournal_link')->from('recommended_journals')->where(array('status'=>'Active'))->order_by('id desc')->get()->result();
		if(!empty($link))
		{
			foreach($link as $li)
			{
				
				$n_xml .= '<url>'.PHP_EOL;
				$n_xml .= '<loc>'.base_url().'useful-link/'.$li->rjournal_link.'</loc>'.PHP_EOL;
				$n_xml .= '<priority>0.80</priority>'.PHP_EOL;
				$n_xml .= '<changefreq>daily</changefreq>'.PHP_EOL;
				$n_xml .= '</url>'.PHP_EOL;
				
			}
		}
		
		$n_xml .= '<url>'.PHP_EOL;
		$n_xml .= '<loc>'.base_url().'sitemap.html</loc>'.PHP_EOL;
		$n_xml .= '<priority>0.80</priority>'.PHP_EOL;
		$n_xml .= '<changefreq>daily</changefreq>'.PHP_EOL;
		$n_xml .= '</url>'.PHP_EOL;
	
	
		$n_xml .= '</urlset>';
		$content = $n_xml;
		
		$fp = fopen($xml_name,"wb");
		fwrite($fp,$content);
		fclose($fp);

		return 'success';
	}
		
}
?>