<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Admin_unb extends CI_Controller {

	/**
	 * Index Page for this controller.
	 *
	 * Maps to the following URL
	 * 		http://example.com/index.php/welcome
	 *	- or -
	 * 		http://example.com/index.php/welcome/index
	 *	- or -
	 * Since this controller is set as the default controller in
	 * config/routes.php, it's displayed at http://example.com/
	 *
	 * So any other public methods not prefixed with an underscore will
	 * map to /index.php/welcome/<method_name>
	 * @see http://codeigniter.com/user_guide/general/urls.html
	 */
	  public function __construct()
         {
            parent::__construct();

            $this->load->library('session');
			$this->load->library('encrypt');
			$this->load->model('admin_model');
			$this->load->helper(array('form', 'url','html'));
			$this->load->helper(array('form', 'url'));

         }
	public function index()
	{
            $data=array();


			$this->load->view('admin/login',$data);
//        $this->load->view('upload_form', array('error' => ' ' ));

    }
	public function adminHome()
	{
		 $data=array();

		//$data['custquery'] = $this->admin_model->customerLogView();

        $data['maincontent']=$this->load->view('admin/desh_board',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function adminLogin()
	{
		 $data=array();
		// $this->load->helper('security');

		$user_name=$this->input->post('username',true);
        $password=$this->input->post('password',true);

	    if($user_name!="" and $password!=""){

			$result=$this->admin_model->userLoginCheck($user_name);
			if($result)
			{

				$serverpass = $result->userPassword;
				$serverpass = str_replace("shahin", "/", $serverpass);
				$serverpass = $this->encrypt->decode($serverpass);
				$username = $result->userName;

				if($user_name==$username && $password==$serverpass)
				{
					$logData['userId']=$result->userId;
					$logData['userFullName']=$result->userFullName;
					$logData['userAuthId']=$result->authId;
					$logData['languageStatus']=$result->languageStatus;


					$data['result']=$this->session->set_userdata($logData);


					redirect('admin_unb/adminHome');
					//$data['maincontent']=$this->load->view('admin/desh_board',$data,true);
					//$this->load->view('admin/main_page',$data);
				}else{

					$logData['message']="<font color='#FF0000'>User Name Or Password Invalide!</font>";
               		$this->session->set_userdata($logData);
                	$this->load->view('admin/login', true);

				}
			}else{

				$logData['message']="<font color='#FF0000'>User Name Or Password Invalide!</font>";
                $this->session->set_userdata($logData);
                $this->load->view('admin/login', true);
			}
		}else{

		$logData['message']="<font color='#FF0000'>User Name Or Password Invalide!</font>";
		$this->session->set_userdata($logData);
		$this->load->view('admin/login', true);
	}
}
	public function logout()
    {
        $this->session->unset_userdata('userId');
		$this->session->sess_destroy();

		$logData['message']="<font color='#006633'>Logout Successfully</font>";
		$this->session->set_userdata($logData);

        $this->load->view('admin/login', true);

    }
// ----------------------user start-------------------------------------------
	public function UserView()
	{
		 $data=array();


		//$data['usertype'] = $this->admin_model->authView();
		$data['userquery'] = $this->admin_model->userViewlist();

		$data['maincontent']=$this->load->view('admin/view_user',$data,true);
            //$data['right_box_content']=$this->load->view('box_content',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function userAddPage()
	{
		$data=array();

		$data['authquery'] = $this->admin_model->userPermission();

        $data['maincontent']=$this->load->view('admin/add_user',$data,true);
		$this->load->view('admin/main_page',$data);

	}
	public function addUser()
	{
		$data=array();
		//$this->load->helper('security');
		$data['userFullName']=$this->input->post('userfullname',true);
		$data['userEmail']=$this->input->post('useremail',true);
		$data['userPhone']=$this->input->post('usermobile',true);
		$data['userName']=$this->input->post('username',true);
		$password=$this->input->post('password',true);
		$password = $this->encrypt->encode($password);
		$data['userPassword'] = str_replace("/", "shahin", $password);
		$data['authId']=$this->input->post('type',true);
		$data['userStatus']=1;

		if($data['userFullName'] && $data['userName'] && $data['userPassword'] && $data['authId'])
		{
			if(!$this->admin_model->userCheck($data))
			 {

				$this->admin_model->addUser($data);

				$sesData['message']="Save Data Successfully!";
				$this->session->set_userdata($sesData);

				redirect("admin_unb/userAddPage");
			 }else{
				 $sesData['message']="<font color='#FF0000'>This user alredy exist!</font>";
				 $this->session->set_userdata($sesData);

				 redirect("admin_unb/userAddPage");
			 }
		}else{
			 $sesData['message']="<font color='#FF0000'>Fill in the field!</font>";
			 $this->session->set_userdata($sesData);

			 redirect("admin_unb/userAddPage");
		}

	}
	public function userUpdateView($id)
	{
		$data=array();


		$data['userrow'] = $this->admin_model->userSingleView($id);
		$data['authquery'] = $this->admin_model->userPermission();
		/*echo "<pre>";
		print_r($data);
		exit;*/
        $data['maincontent']=$this->load->view('admin/edit_user',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function userUpdate()
	{
		$data=array();

		$data['userid'] = $this->input->post('userid',true);
		$data['userfullname'] = $this->input->post('userfullname',true);
		$data['userEmail']=$this->input->post('useremail',true);
		$data['userPhone']=$this->input->post('userphone',true);
		$data['username'] = $this->input->post('username',true);

		$password = $this->input->post('password',true);
		if($password!="")
		{
			$password = $this->encrypt->encode($password);
			$data['userPassword'] = str_replace("/", "shahin", $password);
		}else{
			$data['userPassword']=$password;
		}
		$data['type'] = $this->input->post('type',true);

		$this->admin_model->userUpdate($data);

		redirect('admin_unb/userView');

	}
	public function statusUser($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->statusUser($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->statusUser($id, $status);
		}

		redirect('admin_unb/userView');
	}
	public function userDelete()
	{
		 $data=array();

		$dat=$this->input->post('del');

		$this->load->model('admin_model');
		for($i=0;$i<sizeof($dat);$i++)
		{

			$this->admin_model->deleteUserResult($dat[$i]);
		}
		$sesData['message']="<font color='#FF0000'>Delete Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/userView');
	}
	public function changePassView()
	{
		$data=array();



        $data['maincontent']=$this->load->view('admin/change_password',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function changePassword()
	{
		$data['user_id'] = $this->session->userdata('userId');
		$cpassword=$this->input->post('cpassword',true);
		$npassword=$this->input->post('npassword',true);
		$rpassword=$this->input->post('rpassword',true);


		$curentrow = $this->admin_model->currentPassResult($data);

		$serverpass = $curentrow->userPassword;
		$serverpass = str_replace("shahin", "/", $serverpass);
		$serverpass = $this->encrypt->decode($serverpass);


		if($serverpass==$cpassword){



			if($cpassword!="" && $npassword!="")
			{
				if($npassword==$rpassword)
				{
					$password=$npassword;
					$password = $this->encrypt->encode($password);
					$data['userPassword'] = str_replace("/", "shahin", $password);
					$data['username'] = $curentrow->userName;


					$this->admin_model->changePasswordResult($data);

					$msg['message']="<font color=#006633>Your password update successfully</font>";
					$this->session->set_userdata($msg);

					redirect('admin_unb/changePassView');

				}else{
					$logData['message']='<font color=#FF0000>new password & confirm password not match!</font>';
					$this->session->set_userdata($logData);

					redirect('admin_unb/changePassView');
				}
			}else{
					$logData['message']='<font color=#FF0000>Please Fill in the Field</font>';
					$this->session->set_userdata($logData);

					redirect('admin_unb/changePassView');
			}
		}else{
			$logData['message']='<font color=#FF0000>wrong current password!</font>';
            $this->session->set_userdata($logData);

			redirect('admin_unb/changePassView');
		}
	}
// ----------------------user end-------------------------------------------
// ----------------------user permission Start-------------------------------------------
	public function userPerView()
	{
		 $data=array();


		//$data['subcategory'] = $this->admin_model->getSubcategories($catid);
		$data['userper'] = $this->admin_model->userPerViewlist();

		$data['maincontent']=$this->load->view('admin/view_user_permission',$data,true);
            //$data['right_box_content']=$this->load->view('box_content',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function userPerAddPage()
	{
		$data=array();

		//$cats = $this->admin_model->categoryViewlist();

        $data['maincontent']=$this->load->view('admin/add_user_permission',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function addUserAuth()
	{
		$data=array();


		$data['authName'] = $this->input->post('authname',true);
		$data['catView'] = $this->input->post('catview',true);
		$data['catAdd'] = $this->input->post('catadd',true);
		$data['catEdit'] = $this->input->post('catedit',true);
		$data['catDelete'] = $this->input->post('catdelete',true);
		$data['newsView'] = $this->input->post('newsview',true);
		$data['newsAdd'] = $this->input->post('newsadd',true);
		$data['newsEdit'] = $this->input->post('newsedit',true);
		$data['newsDelete'] = $this->input->post('newsdelete',true);
		$data['photoView'] = $this->input->post('photoview',true);
		$data['photoAdd'] = $this->input->post('photoadd',true);
		$data['photoEdit'] = $this->input->post('photoedit',true);
		$data['photoDelete'] = $this->input->post('photodelete',true);
		$data['videoView'] = $this->input->post('videoview',true);
		$data['videoAdd'] = $this->input->post('videoadd',true);
		$data['videoEdit'] = $this->input->post('videoedit',true);
		$data['videoDelete'] = $this->input->post('videodelete',true);
		$data['userAdd'] = $this->input->post('useradd',true);
		$data['userView'] = $this->input->post('userview',true);
		$data['userDelete'] = $this->input->post('userdelete',true);
		$data['userEdit'] = $this->input->post('useredit',true);
		$data['userStatus'] = $this->input->post('userstatus',true);
		$data['apAdd'] = $this->input->post('apadd',true);
		$data['apView'] = $this->input->post('apview',true);
		$data['apEdit'] = $this->input->post('apvdit',true);
		$data['apDelete'] = $this->input->post('apvelete',true);
		$data['apStatus'] = $this->input->post('apstatus',true);
		$data['customerAdd'] = $this->input->post('customeradd',true);
		$data['customerEdit'] = $this->input->post('customeredit',true);
		$data['customerView'] = $this->input->post('customerview',true);
		$data['customerDelete'] = $this->input->post('customerdelete',true);
		$data['report'] = $this->input->post('reportview',true);

		$this->admin_model->userPerAdd($data);


		$sesData['message']="<font color='#006633'>Save Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/userPerAddPage');

	}
	public function userPerUpdateView($authid)
	{
		$data=array();

		$data['userrow'] = $this->admin_model->userPerSingleView($authid);



        $data['maincontent']=$this->load->view('admin/edit_user_permission',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function userAuthUpdate()
	{
		$data=array();

		$data['authId'] = $this->input->post('authid',true);
		$data['authName'] = $this->input->post('authname',true);
		$data['catView'] = $this->input->post('catview',true);
		$data['catAdd'] = $this->input->post('catadd',true);
		$data['catEdit'] = $this->input->post('catedit',true);
		$data['catDelete'] = $this->input->post('catdelete',true);
		$data['newsView'] = $this->input->post('newsview',true);
		$data['newsAdd'] = $this->input->post('newsadd',true);
		$data['newsEdit'] = $this->input->post('newsedit',true);
		$data['newsStatus'] = $this->input->post('newsstatus',true);
		$data['newsDelete'] = $this->input->post('newsdelete',true);
		$data['photoView'] = $this->input->post('photoview',true);
		$data['photoAdd'] = $this->input->post('photoadd',true);
		$data['photoEdit'] = $this->input->post('photoedit',true);
		$data['photoStatus'] = $this->input->post('photostatus',true);
		$data['photoDelete'] = $this->input->post('photodelete',true);
		$data['videoView'] = $this->input->post('videoview',true);
		$data['videoAdd'] = $this->input->post('videoadd',true);
		$data['videoEdit'] = $this->input->post('videoedit',true);
		$data['videoStatus'] = $this->input->post('videostatus',true);
		$data['videoDelete'] = $this->input->post('videodelete',true);
		$data['userAdd'] = $this->input->post('useradd',true);
		$data['userView'] = $this->input->post('userview',true);
		$data['userDelete'] = $this->input->post('userdelete',true);
		$data['userEdit'] = $this->input->post('useredit',true);
		$data['userStatus'] = $this->input->post('userstatus',true);
		$data['apAdd'] = $this->input->post('apadd',true);
		$data['apView'] = $this->input->post('apview',true);
		$data['apEdit'] = $this->input->post('apedit',true);
		$data['apDelete'] = $this->input->post('apdelete',true);
		$data['apStatus'] = $this->input->post('apstatus',true);
		$data['customerAdd'] = $this->input->post('customeradd',true);
		$data['customerEdit'] = $this->input->post('customeredit',true);
		$data['customerView'] = $this->input->post('customerview',true);
		$data['customerStatus'] = $this->input->post('customerstatus',true);
		$data['customerDelete'] = $this->input->post('customerdelete',true);
		$data['report'] = $this->input->post('reportview',true);

		$this->admin_model->userPerUpdate($data);


		$sesData['message']="<font color='#006633'>Save Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/userPerView');
	}
	public function userPerDelete()
	{
		 $data=array();

		$dat=$this->input->post('del');

		$this->load->model('admin_model');
		for($i=0;$i<sizeof($dat);$i++)
		{

			$this->admin_model->deleteUserAuthResult($dat[$i]);
		}
		$sesData['message']="<font color='#FF0000'>Delete Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/userPerView');
	}


// ----------------------user Permission end-------------------------------------------
// ----------------------category start-------------------------------------------
	public function categoryView()
	{
		 $data=array();

		$cats = $this->admin_model->categoryViewlist();

		//$data['subcategory'] = $this->admin_model->getSubcategories($catid);
		$data['categories'] = $this->admin_model->categoryViewlist();

		$data['maincontent']=$this->load->view('admin/view_category',$data,true);
            //$data['right_box_content']=$this->load->view('box_content',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function categoryAddPage()
	{
		$data=array();

		//$cats = $this->admin_model->categoryViewlist();

        $data['maincontent']=$this->load->view('admin/add_category',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function categoryAdd()
	{
		$data=array();


			$data['catName'] = $this->input->post('categoryname',true);
			$data['homePermission'] = $this->input->post('homeactive',true);
			$data['menuPermission'] = $this->input->post('menuactive',true);
			$data['photoPermission'] = $this->input->post('photoactive',true);
			$data['videoPermission'] = $this->input->post('videoactive',true);
			$data['catStatus'] =1;
			/*echo "<pre>";
			print_r($data);
			exist();*/
			if(!$this->admin_model->categoryCheck($data))
		 	{

				$catid = $this->admin_model->categoryAdd($data);


				$sesData['message']="<font color='#006633'>Save Data Successfully!</font>";
				$this->session->set_userdata($sesData);

		 }else{
			 $sesData['message']="<font color='#FF0000'>This category alredy exist!</font>";
			 $this->session->set_userdata($sesData);
		 }
			redirect('admin_unb/categoryAddPage');

	}
	public function categoryUpdateView($catid)
	{
		$data=array();

		$data['catrowview'] = $this->admin_model->categorySingleView($catid);



        $data['maincontent']=$this->load->view('admin/edit_category',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function categoryUpdate()
	{
		$data=array();

		$data['catId'] = $this->input->post('catid',true);
		$data['catName'] = $this->input->post('categoryname',true);

		$this->admin_model->categoryUpdate($data);



		redirect('admin_unb/categoryView');

	}
	public function statusHome($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->statusHome($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->statusHome($id, $status);
		}
		redirect('admin_unb/categoryView');
	}
	public function statusMenu($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->statusMenu($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->statusMenu($id, $status);
		}
		redirect('admin_unb/categoryView');
	}
	public function statusPhoto($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->statusPhoto($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->statusPhoto($id, $status);
		}
		redirect('admin_unb/categoryView');
	}
	public function statusVideo($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->statusVideo($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->statusVideo($id, $status);
		}
		redirect('admin_unb/categoryView');
	}
	public function statusCategory($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->statusCategory($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->statusCategory($id, $status);
		}
		redirect('admin_unb/categoryView');
	}

	public function categoryDelete()
	{
		 $data=array();

		$dat=$this->input->post('del');

		$this->load->model('admin_model');
		for($i=0;$i<sizeof($dat);$i++)
		{

			$this->admin_model->deleteCategoryResult($dat[$i]);
		}
		$sesData['message']="<font color='#FF0000'>Delete Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/categoryView');
	}
	public function homeSerialView()
	{
		$data=array();

		$data['catserialquery'] = $this->admin_model->homeSerialViewlist();

        $data['maincontent']=$this->load->view('admin/view_home_serial_category',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function  homeViewSerial()
	{
		$data=array();
		//$homeSerial = $this->input->post('serialno',true);
		$catId = $this->input->post('catId',true);
		//print_r($catId);
		$serialid = 1;
		for($i=0;$i<sizeof($catId);$i++)
		{
			////echo $serialid;
			$this->admin_model->homeSerialUpdate($catId[$i], $serialid);
			$serialid++;
		}

		redirect('admin_unb/homeSerialView');
	}
	public function menuSerialView()
	{
		$data=array();

		$data['catserialquery'] = $this->admin_model->menuSerialViewlist();

        $data['maincontent']=$this->load->view('admin/view_menu_serial_category',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function  menuViewSerial()
	{
		$data=array();
		//$homeSerial = $this->input->post('serialno',true);
		$catId = $this->input->post('catId',true);
		//print_r($catId);
		$serialid = 1;
		for($i=0;$i<sizeof($catId);$i++)
		{
			//echo $serialid;
			$this->admin_model->menuSerialUpdate($catId[$i], $serialid);
			$serialid++;
		}

		redirect('admin_unb/menuSerialView');
	}
	public function photoSerialView()
	{
		$data=array();

		$data['catserialquery'] = $this->admin_model->photoSerialViewlist();

        $data['maincontent']=$this->load->view('admin/view_photo_serial_category',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function  photoViewSerial()
	{
		$data=array();
		//$homeSerial = $this->input->post('serialno',true);
		$catId = $this->input->post('catId',true);
		//print_r($catId);
		$serialid = 1;
		for($i=0;$i<sizeof($catId);$i++)
		{
			//echo $serialid;
			$this->admin_model->photoSerialUpdate($catId[$i], $serialid);
			$serialid++;
		}

		redirect('admin_unb/photoSerialView');
	}
	public function videoSerialView()
	{
		$data=array();

		$data['catserialquery'] = $this->admin_model->videoSerialViewlist();

        $data['maincontent']=$this->load->view('admin/view_video_serial_category',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function apphotoSerialView()
	{
		$data=array();

		$data['catserialquery'] = $this->admin_model->apphotoSerialViewlist();

        $data['maincontent']=$this->load->view('admin/view_ap_serial_category',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function  apphotoViewSerial()
	{
		$data=array();
		//$homeSerial = $this->input->post('serialno',true);
		$catId = $this->input->post('catId',true);
		//print_r($catId);
		$serialid = 1;
		for($i=0;$i<sizeof($catId);$i++)
		{
			//echo $serialid;
			$this->admin_model->apSerialUpdate($catId[$i], $serialid);
			$serialid++;
		}

		redirect('admin_unb/fSerialView');
	}
	public function statusApPhoto($id, $apid)
	{
		if($apid==1)
		{
			$apid = 0;
			$this->admin_model->apStatusCategory($id, $apid);
		}
		else if($apid==0)
		{
			$apid = 1;
			$this->admin_model->apStatusCategory($id, $apid);
		}
		redirect('admin_unb/categoryView');
	}
// ----------------------category End-------------------------------------------
// ----------------------country start-------------------------------------------
	public function countryView()
	{
		 $data=array();

		 $data['country'] = $this->admin_model->countryViewlist();

		$data['maincontent']=$this->load->view('admin/view_country',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function countryAddPage()
	{
		$data=array();

		$data['maincontent']=$this->load->view('admin/add_country',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function countryAdd()
	{
		$data=array();


			$data['countryName'] = $this->input->post('countryname',true);
			$data['countryStatus'] =1;


			if($data['countryName']){
				if(!$this->admin_model->countryCheck($data))
				{

					$this->admin_model->countryAdd($data);

					$sesData['message']="<font color='#006633'>Save Data Successfully!";
					$this->session->set_userdata($sesData);

			 }else{
				 $sesData['message']="<font color='#FF0000'>This country alredy exist!</font>";
				 $this->session->set_userdata($sesData);
			 }
		}else{
				 $sesData['message']="<font color='#FF0000'>Fill in the field!</font>";
				 $this->session->set_userdata($sesData);
			 }
			redirect('admin_unb/countryAddPage');

	}
	public function countryUpdateView($countryid)
	{
		$data=array();



		$data['countryrowview'] = $this->admin_model->countrySingleView($countryid);

        $data['maincontent']=$this->load->view('admin/edit_country',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function countryUpdate()
	{
		$data=array();
		$data['countryid'] = $this->input->post('countryid',true);
		$data['countryname'] = $this->input->post('countryname',true);
		$countryid = $data['countryid'];
		$this->admin_model->countryUpdate($data);

		$sesData['message']="<font color='#006633'>Save Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/countryView');
	}
	public function statusCountry($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->statusCountry($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->statusCountry($id, $status);
		}
		redirect('admin_unb/countryView');
	}
	public function countryDelete()
	{
		 $data=array();

		$dat=$this->input->post('del');

		$this->load->model('admin_model');
		for($i=0;$i<sizeof($dat);$i++)
		{

			$this->admin_model->deleteCountryResult($dat[$i]);
		}
		$sesData['message']="<font color='#FF0000'>Delete Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/countryView');
	}

// ----------------------country end-------------------------------------------

// ----------------------city start-------------------------------------------
	public function cityView()
	{
		 $data=array();

		 $data['city'] = $this->admin_model->cityViewlist();

		$data['maincontent']=$this->load->view('admin/view_city',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function cityAddPage()
	{
		$data=array();

		$data['maincontent']=$this->load->view('admin/add_city',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function cityAdd()
	{
		$data=array();


			$data['cityName'] = $this->input->post('cityname',true);
			$data['cityStatus'] =1;


			if($data['cityName']){
				if(!$this->admin_model->cityCheck($data))
				{

					$this->admin_model->cityAdd($data);

					$sesData['message']="<font color='#006633'>Save Data Successfully!";
					$this->session->set_userdata($sesData);

			 }else{
				 $sesData['message']="<font color='#FF0000'>This city alredy exist!</font>";
				 $this->session->set_userdata($sesData);
			 }
		}else{
				 $sesData['message']="<font color='#FF0000'>Fill in the field!</font>";
				 $this->session->set_userdata($sesData);
			 }
			redirect('admin_unb/cityAddPage');

	}
	public function cityUpdateView($tagsid)
	{
		$data=array();



		$data['cityrowview'] = $this->admin_model->citySingleView($tagsid);

        $data['maincontent']=$this->load->view('admin/edit_city',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function cityUpdate()
	{
		$data=array();
		$data['cityid'] = $this->input->post('cityid',true);
		$data['cityname'] = $this->input->post('cityname',true);
		$cityid = $data['cityid'];
		$this->admin_model->cityUpdate($data);

		$sesData['message']="<font color='#006633'>Save Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/cityView');
	}
	public function statusCity($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->statusCity($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->statusCity($id, $status);
		}
		redirect('admin_unb/cityView');
	}
	public function cityDelete()
	{
		 $data=array();

		$dat=$this->input->post('del');

		$this->load->model('admin_model');
		for($i=0;$i<sizeof($dat);$i++)
		{

			$this->admin_model->deleteCityResult($dat[$i]);
		}
		$sesData['message']="<font color='#FF0000'>Delete Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/cityView');
	}

// ----------------------city end-------------------------------------------

// ----------------------Photo Gallery start-------------------------------------------

	public function photoView()
	{
		 $data=array();
		 $this->load->library('pagination');

		$config['base_url'] = base_url().'admin_unb/photoView/';
		$data['photorow'] = $this->admin_model->photoViewlistPage();
		$config['total_rows'] = count($data['photorow']);
		$config['per_page'] = 20;
		//$config['full_tag_open'] = '<p>';
		//$config['full_tag_close'] = '</p>';
		$config['full_tag_open'] = '<div><ul class="pagination pagination-small pagination-centered">';
		$config['full_tag_close'] = '</ul></div>';
		$config['num_tag_open'] = '<li>';
		$config['num_tag_close'] = '</li>';
		$config['cur_tag_open'] = "<li class='disabled'><li class='active'><a href='#'>";
		$config['cur_tag_close'] = "<span class='sr-only'></span></a></li>";
		$config['next_tag_open'] = "<li>";
		$config['next_tagl_close'] = "</li>";
		$config['prev_tag_open'] = "<li>";
		$config['prev_tagl_close'] = "</li>";
		$config['first_tag_open'] = "<li>";
		$config['first_tagl_close'] = "</li>";
		$config['last_tag_open'] = "<li>";
		$config['last_tagl_close'] = "</li>";

		$this->pagination->initialize($config);

		$data['photo'] = $this->admin_model->photoViewlist($config['per_page'], $this->uri->segment(3));




		$data['maincontent']=$this->load->view('admin/view_photo',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function photoAddPage()
	{
		$data=array();

		$data['catserialquery'] = $this->admin_model->photoSerialViewlist();


		$data['maincontent']=$this->load->view('admin/add_photo',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function photoAdd()
	{
		$data=array();


			$data['photoName'] = $this->input->post('photoname',true);
			$data['catId'] = $this->input->post('photocatid',true);
			$data['newsTitle'] = $this->input->post('newstitle',true);
			$data['photoDT'] = $this->input->post('datetime',true);
			$data['photoStatus'] =1;

			$errors='';
			if ($_FILES['photopath']['name'] && $_FILES['photopath']['size'])
			{
				$result = $this->imageUpload('photopath');
				if ($result)
				{
					if ($result['file_name'] )
					{

						$data['photoPath'] = $result['file_name'];

					} else
					{
							$errors = $result['error'];
							 //$data['comDumpComImg'] = "";
					}
				}

				}else{
					//$data['comImg'] = "picture/dhakaview/dhakaview_icon.png";
			}


			if($data['photoName']){
				$this->admin_model->photoAdd($data);

				$sesData['message']="<font color='#006633'>Save Data Successfully!";
				$this->session->set_userdata($sesData);
			}else{

				 $sesData['message']="<font color='#FF0000'>Fill in the field!</font>";
				 $this->session->set_userdata($sesData);
			 }
			redirect('admin_unb/photoAddPage');

	}
	public function photoUpdateView($photoid)
	{
		$data=array();



		$data['photorowview'] = $this->admin_model->photoSingleView($photoid);
		$data['catserialquery'] = $this->admin_model->photoSerialViewlist();

		//$data['city'] = $this->admin_model->cityViewlist();

        $data['maincontent']=$this->load->view('admin/edit_photo',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function photoUpdate()
	{
		$data=array();
		$data['photoId'] = $this->input->post('photoid',true);
		$data['photoName'] = $this->input->post('photoname',true);
		$data['catId'] = $this->input->post('photocatid',true);
		$data['newsTitle'] = $this->input->post('newstitle',true);
		$data['photoDT'] = $this->input->post('datetime',true);

		$photoid = $data['photoId'];
		$photorowview = $this->admin_model->photoSingleView($photoid);
		$errors='';
			if ($_FILES['photopath']['name'] && $_FILES['photopath']['size'])
			{
				$result = $this->imageUpload('photopath');
				if ($result)
				{
					if ($result['file_name'] )
					{

						$pdelete = $photorowview->photoPath;
						unlink(base_url()."picture/main/".$pdelete);
						unlink(base_url()."picture/thumbnail/".$pdelete);

						$data['photoPath'] = $result['file_name'];



					} else
					{
							$errors = $result['error'];
							 //$data['comDumpComImg'] = "";
					}
				}

				}else{
					$data['photoPath'] = $photorowview->photoPath;
			}

		$this->admin_model->photoUpdate($data);

		$sesData['message']="<font color='#006633'>Save Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/photoView');
	}
	public function photoStatus($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->statusPhotoResult($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->statusPhotoResult($id, $status);
		}
		redirect('admin_unb/photoView');
	}
	public function photoDelete()
	{
		 $data=array();

		$dat=$this->input->post('del');

		$this->load->model('admin_model');
		for($i=0;$i<sizeof($dat);$i++)
		{

			$this->admin_model->deletePhotoResult($dat[$i]);
		}
		$sesData['message']="<font color='#FF0000'>Delete Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/photoView');
	}

// ----------------------photo Gallery end-------------------------------------------
// ----------------------AP Photo Gallery start-------------------------------------------

	public function apphotoView()
	{
		 $data=array();
		 $this->load->library('pagination');

		$config['base_url'] = base_url().'admin_unb/apphotoView/';
		$data['photorow'] = $this->admin_model->apphotoViewlistPage();
		$config['total_rows'] = count($data['photorow']);
		$config['per_page'] = 20;
		//$config['full_tag_open'] = '<p>';
		//$config['full_tag_close'] = '</p>';
		$config['full_tag_open'] = '<div><ul class="pagination pagination-small pagination-centered">';
		$config['full_tag_close'] = '</ul></div>';
		$config['num_tag_open'] = '<li>';
		$config['num_tag_close'] = '</li>';
		$config['cur_tag_open'] = "<li class='disabled'><li class='active'><a href='#'>";
		$config['cur_tag_close'] = "<span class='sr-only'></span></a></li>";
		$config['next_tag_open'] = "<li>";
		$config['next_tagl_close'] = "</li>";
		$config['prev_tag_open'] = "<li>";
		$config['prev_tagl_close'] = "</li>";
		$config['first_tag_open'] = "<li>";
		$config['first_tagl_close'] = "</li>";
		$config['last_tag_open'] = "<li>";
		$config['last_tagl_close'] = "</li>";

		$this->pagination->initialize($config);

		$data['photo'] = $this->admin_model->apphotoViewlist($config['per_page'], $this->uri->segment(3));




		$data['maincontent']=$this->load->view('admin/view_ap_photo',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function apphotoAddPage()
	{
		$data=array();

		$data['catserialquery'] = $this->admin_model->apphotoSerialViewlist();


		$data['maincontent']=$this->load->view('admin/add_ap_photo',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function apPhotoAdd()
	{
		$data=array();


			$apimagename = $_FILES['apimage']['name'];
			$aptitle = explode('.', $apimagename);
			$data['apTitle'] =$aptitle[0];
			$data['catId'] = $this->input->post('photocatid',true);

			$dateTime = new DateTime('now', new DateTimeZone('Asia/Dhaka'));
			$data['apDT'] = $dateTime->format("Y-m-d H:i:s");
			$data['apStatus'] =1;

			$errors='';
			if ($_FILES['apimage']['name'] && $_FILES['apimage']['size'])
			{



				$result = $this->imageAPUpload('apimage');


				if ($result)
				{
					if ($result['file_name'] )
					{

						$data['apImage'] = $result['file_name'];


					} else
					{
							$errors = $result['error'];
							 //$data['comDumpComImg'] = "";
					}
				}

				}else{
					//$data['comImg'] = "picture/dhakaview/dhakaview_icon.png";
			}


			if($data['apTitle']!=""){
				$this->admin_model->apphotoAdd($data);

				$sesData['message']="<font color='#006633'>Save Data Successfully!";
				$this->session->set_userdata($sesData);
			}else{

				 $sesData['message']="<font color='#FF0000'>Fill in the field!</font>";
				 $this->session->set_userdata($sesData);
			 }
			redirect('admin_unb/apphotoAddPage');
	}
	public function apphotoUpdateView($apid)
	{
		$data=array();



		$data['photorowview'] = $this->admin_model->apphotoSingleView($apid);
		$data['catserialquery'] = $this->admin_model->apphotoSerialViewlist();

		//$data['city'] = $this->admin_model->cityViewlist();

        $data['maincontent']=$this->load->view('admin/edit_ap_photo',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function apphotoUpdate()
	{
		$data=array();
		$data['apId'] = $this->input->post('apid',true);
		$data['apTitle'] = $this->input->post('aptitle',true);
		$data['catId'] = $this->input->post('apcatid',true);
		$dateTime = new DateTime('now', new DateTimeZone('Asia/Dhaka'));
		$data['apDT'] = $dateTime->format("Y-m-d H:i:s");

		$apid = $data['apId'];
		$photorowview = $this->admin_model->apphotoSingleView($apid);
		$errors='';
			if ($_FILES['photopath']['name'] && $_FILES['photopath']['size'])
			{

				$result = $this->imageAPUpload('photopath');
				if ($result)
				{
					if ($result['file_name'] )
					{

						$pdelete = $photorowview->apImage;

												unlink(base_url()."ap_photo/ap_max/".$pdelete);
						unlink(base_url()."ap_photo/ap_thumb/".$pdelete);

						$data['apImage'] = $result['file_name'];



					} else
					{
							$errors = $result['error'];
							 //$data['comDumpComImg'] = "";
					}
				}

				}else{
					$data['apImage'] = $photorowview->apImage;
			}

		$this->admin_model->apphotoUpdate($data);

		$sesData['message']="<font color='#006633'>Save Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/apphotoView');
	}
	public function apphotoStatus($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->statusApPhotoResult($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->statusApPhotoResult($id, $status);
		}
		redirect('admin_unb/apphotoView');
	}
	public function apphotoDelete()
	{
		 $data=array();

		$dat=$this->input->post('del');

		$this->load->model('admin_model');
		for($i=0;$i<sizeof($dat);$i++)
		{

			$this->admin_model->deleteApPhotoResult($dat[$i]);
		}
		$sesData['message']="<font color='#FF0000'>Delete Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/apphotoView');
	}

// ----------------------Ap photo Gallery end-------------------------------------------

// ----------------------Video Gallery start-------------------------------------------

	public function videoView()
	{
		 $data=array();
		 $this->load->library('pagination');


		$config['base_url'] = base_url().'admin_unb/videoView/';
		$data['videoquery'] = $this->admin_model->videoViewlistPage();
		$config['total_rows'] = count($data['videoquery']);
		$config['per_page'] = 20;
		//$config['full_tag_open'] = '<p>';
		//$config['full_tag_close'] = '</p>';
		$config['full_tag_open'] = '<div><ul class="pagination pagination-small pagination-centered">';
		$config['full_tag_close'] = '</ul></div>';
		$config['num_tag_open'] = '<li>';
		$config['num_tag_close'] = '</li>';
		$config['cur_tag_open'] = "<li class='disabled'><li class='active'><a href='#'>";
		$config['cur_tag_close'] = "<span class='sr-only'></span></a></li>";
		$config['next_tag_open'] = "<li>";
		$config['next_tagl_close'] = "</li>";
		$config['prev_tag_open'] = "<li>";
		$config['prev_tagl_close'] = "</li>";
		$config['first_tag_open'] = "<li>";
		$config['first_tagl_close'] = "</li>";
		$config['last_tag_open'] = "<li>";
		$config['last_tagl_close'] = "</li>";

		$this->pagination->initialize($config);

		$data['video'] = $this->admin_model->videoViewlist($config['per_page'], $this->uri->segment(3));

		$data['maincontent']=$this->load->view('admin/view_video',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function videoAddPage()
	{
		$data=array();

		$data['catserialquery'] = $this->admin_model->videoSerialViewlist();


		$data['maincontent']=$this->load->view('admin/add_video',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function videoAdd()
	{
		$data=array();


			$data['videoName'] = $this->input->post('videoname',true);
			$data['catId'] = $this->input->post('videocatid',true);
			$data['newsTitle'] = $this->input->post('newstitle',true);
			$data['videoDT'] = $this->input->post('datetime',true);
			$video = $this->input->post('videopath',true);
			$video1 = explode("=", $video);
			$data['videoPath'] = $video1[1];
			$data['videoStatus'] =1;



			if($data['videoName']){
				$this->admin_model->videoAddresult($data);

				$sesData['message']="<font color='#006633'>Save Data Successfully!";
				$this->session->set_userdata($sesData);
			}else{

				 $sesData['message']="<font color='#FF0000'>Fill in the field!</font>";
				 $this->session->set_userdata($sesData);
			 }
			redirect('admin_unb/videoAddPage');

	}
	public function videoUpdateView($videoid)
	{
		$data=array();



		$data['videorowview'] = $this->admin_model->videoSingleView($videoid);
		$data['catserialquery'] = $this->admin_model->videoSerialViewlist();

		//$data['city'] = $this->admin_model->cityViewlist();

        $data['maincontent']=$this->load->view('admin/edit_video',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function videoUpdate()
	{
		$data=array();
		$data['videoId'] = $this->input->post('videoid',true);
		$data['videoName'] = $this->input->post('videoname',true);
		$data['catId'] = $this->input->post('videocatid',true);
		$data['newsTitle'] = $this->input->post('newstitle',true);
		$data['videoDT'] = $this->input->post('datetime',true);
		$videopath = $this->input->post('videopath',true);

		$videoid = $data['videoId'];
		$videorowview = $this->admin_model->videoSingleView($videoid);

		if($videopath !="")
		{
			$video1 = explode("=", $videopath);
			$data['videoPath'] = $video1[1];
		}
		else
		{
			$data['videoPath'] = $videorowview->videoPath;
		}

		$this->admin_model->videoUpdate($data);

		$sesData['message']="<font color='#006633'>Save Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/videoView');
	}
	public function videoStatus($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->statusVideoResult($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->statusVideoResult($id, $status);
		}
		redirect('admin_unb/videoView');
	}
	public function videoDelete()
	{
		 $data=array();

		$dat=$this->input->post('del');

		$this->load->model('admin_model');
		for($i=0;$i<sizeof($dat);$i++)
		{

			$this->admin_model->deleteVideoResult($dat[$i]);
		}
		$sesData['message']="<font color='#FF0000'>Delete Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/videoView');
	}

// ----------------------Video end-------------------------------------------

// ----------------------News Start-------------------------------------------
	public function newsView()
	{
		 $data=array();
		 $this->load->library('pagination');


		$config['base_url'] = base_url().'admin_unb/newsView/';
		$data['companyquery'] = $this->admin_model->newsViewlistPage();
		$config['total_rows'] = count($data['companyquery']);
		$config['per_page'] = 20;
		//$config['full_tag_open'] = '<p>';
		//$config['full_tag_close'] = '</p>';
		$config['full_tag_open'] = '<div><ul class="pagination pagination-small pagination-centered">';
		$config['full_tag_close'] = '</ul></div>';
		$config['num_tag_open'] = '<li>';
		$config['num_tag_close'] = '</li>';
		$config['cur_tag_open'] = "<li class='disabled'><li class='active'><a href='#'>";
		$config['cur_tag_close'] = "<span class='sr-only'></span></a></li>";
		$config['next_tag_open'] = "<li>";
		$config['next_tagl_close'] = "</li>";
		$config['prev_tag_open'] = "<li>";
		$config['prev_tagl_close'] = "</li>";
		$config['first_tag_open'] = "<li>";
		$config['first_tagl_close'] = "</li>";
		$config['last_tag_open'] = "<li>";
		$config['last_tagl_close'] = "</li>";

		$this->pagination->initialize($config);

		$data['newsquery']=$this->admin_model->newsViewlist($config['per_page'], $this->uri->segment(3));

		//$data['company'] = $this->admin_model->companyViewlist();

		$data['maincontent']=$this->load->view('admin/view_news',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function newsSearch()
	{
		$data=array();

		$newssearch = $this->input->post('search',true);

		$data['news']=$this->admin_model->newsSearchViewlist($newssearch);

		$data['maincontent']=$this->load->view('admin/view_search_news',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function newsAddView()
	{
		$data=array();

		$data['catquery'] = $this->admin_model->categoryViewlist();

//		$dateTime = new DateTime('now', new DateTimeZone('Asia/Dhaka'));
//		$data['currentdt'] = $dateTime->format("Y-m-d H:i:s");

        $format = "Y-m-d H:i:s";
        date_default_timezone_set('Asia/Dhaka');
        $dateTime= date($format, strtotime("-10 minute"));
//       var_dump($dateTime);
//        die();
        $data['currentdt'] = $dateTime;

        $data['maincontent']=$this->load->view('admin/add_news',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function newsAdd()
	{
//	    var_dump($this->input->post());
//	    die();
		$data=array();

		$data['newsTitle'] = $this->input->post('newstitle',true);
		$data['catId'] = $this->input->post('catid',true);
		$data['subCatId'] = $this->input->post('subcatid',true);
		$data['newsSlug'] = $this->input->post('newsslug',true);
		$data['newsStandFast'] = $this->input->post('standfast',true);
		$data['NewsDetails'] = $this->input->post('details',true);
		$data['newsDT'] = $this->input->post('datetime',true);
		$videopath = $this->input->post('videopath',true);
		if($videopath!="")
		{
			$video = explode("=", $videopath);
			$data['videoPath'] = $video[1];
		}else{

			$data['videoPath'] = $videopath;
		}
		$data['newsLatest'] = $this->input->post('latest',true);
		$data['newsBNews'] = $this->input->post('breaking',true);
		$data['newsStatus'] =1;


		$errors='';
		if ($_FILES['photopath']['name'] && $_FILES['photopath']['size'])
		{
			$result = $this->imageUpload('photopath');

			if ($result)
			{
				$data['photoPath'] = $result['file_name'];
			}

			}else{
				$data['photoPath'] = "";
		}

			if($data['newsTitle']!="")
			{
				$data['newsid'] = $this->admin_model->newsAddResult($data);

				if ($data['newsid']){
                    $this->createXML($data);
                }
				$sesData['message']="<font color='#006633'>Save Data Successfully!</font>";
				$this->session->set_userdata($sesData);

				redirect('admin_unb/newsAddView');
			}else{

				$sesData['message']="<font color='#FF0000'>Insert Date</font>";
				$this->session->set_userdata($sesData);

				redirect('admin_unb/newsAddView');
			}

	}


    public function createXML($data = array())
    {
        $date = date('Y-m-d',strtotime($data['newsDT']));

        $body="";
        $body.='<?xml version="1.0" encoding="UTF-8"?>
		<posts>';

        $details = $data['NewsDetails'];

        $result1 = strip_tags($details);

        $content1 = str_replace("&nbsp;", "", $result1);
        $content2 = str_replace("&lsquo;", "'", $content1);
        $content3 = str_replace("&mdash;", "-", $content2);
        $content4 = str_replace("&ndash;", "-", $content3);
        $content5 = str_replace("&amp;", "&", $content4);
        $content6 = str_replace("&hellip;", "...", $content5);
        $content7 = str_replace("&acirc;", "", $content6);
        $content8 = str_replace("&ldquo;", '"', $content7);
        $content9 = str_replace("&rdquo;", '"', $content8);
        $content10 = str_replace("&", 'and', $content9);
        $main = str_replace("&rsquo;", "'", $content10);

        $content = htmlspecialchars_decode($main);
        $body.="
			<post>
				<title>".$data['newsTitle']."</title>
			    <subHeading>".strip_tags(htmlentities($data['newsStandFast']))."</subHeading>
	            <slug>".$data['newsSlug']."</slug>
				<publishAt>".$data['newsDT']."</publishAt>
				<content>".$content."</content>
			</post>";
        $body.='</posts>';

        $sFileName=(string)$this->slugify($data['newsTitle']).".xml";

        //File path at local server
        $source = 'xml/'.$sFileName;
        write_file($source,$body);

        //Load codeigniter FTP class
        $this->load->library('ftp');

        //FTP configuration
        $config['hostname'] = 'Wire.thedailystar.net';
        $config['username'] = 'unb';
        $config['password'] = 'TDS@12345';
        $config['debug']    = TRUE;

        //Connect to the remote server
        $this->ftp->connect($config);
        $list = $this->ftp->list_files('/unb/');
        if (!in_array('/unb/'.$date, $list)){
            $this->ftp->mkdir('unb/'.$date.'/');
        }
        //File upload path of remote server
        $destination = '/unb/'.$date.'/'.$sFileName;
        //Upload file to the remote server
        $this->ftp->upload($source, ".".$destination);

        //Close FTP connection
        $this->ftp->close();

        //Delete file from local server
//        @unlink($source);

        // Set flash data
        $this->session->set_flashdata('submission_msg', 'XML FILE SUCCESSFULLY GENERATED ON YOUR SERVER');
// After that you need to used redirect function instead of load view such as
        redirect('/category/archiveNews');

    }
    public function slugify($string)
    {
        // Get an instance of $this
        $CI =& get_instance();

        $CI->load->helper('text');
        $CI->load->helper('url');

        // Replace unsupported characters (add your owns if necessary)
        $string = str_replace("'", '-', $string);
        $string = str_replace(".", '-', $string);
        $string = str_replace("²", '2', $string);

        // Slugify and return the string
        return url_title(convert_accented_characters($string), 'dash', true);
    }

	public function newsUpdateView($id)
	{
		$data=array();

		$data['catquery'] = $this->admin_model->categoryViewlist();
		$data['newsrow'] = $this->admin_model->newsSingleView($id);


		$data['maincontent']=$this->load->view('admin/edit_news',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function newsUpdate()
	{
		$data=array();
		$data['newsId'] = $this->input->post('newsid',true);
		$id = $data['newsId'];
		$newsrow = $this->admin_model->newsSingleView($id);

		$data['newsTitle'] = $this->input->post('newstitle',true);
		$data['catId'] = $this->input->post('catid',true);
		$data['subCatId'] = $this->input->post('subcatid',true);
		$data['newsSlug'] = $this->input->post('newsslug',true);
		$data['newsStandFast'] = $this->input->post('standfast',true);
		$data['NewsDetails'] = $this->input->post('details',true);
		$data['newsDT'] = $this->input->post('datetime',true);
		$videopath = $this->input->post('videopath',true);
		if($videopath!="")
		{
			$video = explode("=", $videopath);
			$data['videoPath'] = $video[1];
		}else{

			$data['videoPath'] = $newsrow->videoPath;
		}
		$data['newsLatest'] = $this->input->post('latest',true);
		$data['newsBNews'] = $this->input->post('breaking',true);


		$errors='';
		if ($_FILES['photopath']['name'] && $_FILES['photopath']['size'])
		{
			$result = $this->imageUpload('photopath');
			if ($result)
			{
				$data['photoPath'] = $result['file_name'];
			}

			}else{
				$data['photoPath'] = $newsrow->photoPath;
		}

			if($data['newsTitle']!="")
			{
				$this->admin_model->newsUpdate($data);
                $this->createXML($data);

				$sesData['message']="<font color='#006633'>Save Data Successfully!</font>";
				$this->session->set_userdata($sesData);

				redirect('admin_unb/newsView/');
			}else{

				$sesData['message']="<font color='#FF0000'>Insert Date</font>";
				$this->session->set_userdata($sesData);

				redirect('admin_unb/newsView/');
			}
	}

	public function statusNews($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->statusNews($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->statusNews($id, $status);
		}
		redirect('admin_unb/newsView');
	}

	public function newsDelete()
	{
		 $data=array();
		//$this->load->helper("url");
		$dat=$this->input->post('del');
		//print_r($dat);
		//exit;
		$this->load->model('admin_model');
		for($i=0;$i<sizeof($dat);$i++)
		{
			$this->admin_model->deleteNewsResult($dat[$i]);
		}

		$sesData['message']="<font color='#FF0000'>Delete Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/newsView');
	}
	public function changeTopSearch()
	{
		$comid = $this->input->post('comid');
		$searchtopid = $this->input->post('searchtopid');

		$this->admin_model->changeTopSearchResult($comid, $searchtopid);

		//$restlt['searchtopid'] = $searchtopid;


		echo json_encode($restlt);
	}

// ----------------------News End-------------------------------------------
//---------------------------Latest & Breaking News Start----------------------
	public function newsLBView()
	{
		 $data=array();

		$data['blquery'] = $this->admin_model->lbViewlist();

		$data['maincontent']=$this->load->view('admin/view_lb',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function lbAddView()
	{
		$data=array();


		$data['maincontent']=$this->load->view('admin/add_lb',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function newsAddLB()
	{
		$data=array();


		$data['newsLBTitle'] = $this->input->post('lbtitle',true);
		$data['newsLB'] = $this->input->post('lbid',true);
		$data['newsLBStatus'] = 1;


		$this->admin_model->lbAddresult($data);

		$sesData['message']="<font color='#006633'>Save Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/newsLBView');

	}
	public function lbDelete()
	{
		 $data=array();

		$dat=$this->input->post('del');

		$this->load->model('admin_model');
		for($i=0;$i<sizeof($dat);$i++)
		{

			$this->admin_model->deleteLBResult($dat[$i]);
		}
		$sesData['message']="<font color='#FF0000'>Delete Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/newsLBView');
	}
	public function lbUpdateView($id)
	{
		$data=array();

		$data['lbrow'] = $this->admin_model->lbSingleView($id);

		$data['maincontent']=$this->load->view('admin/edit_lb',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function lbUpdate()
	{
		$data=array();
		$data['newsLBId'] = $this->input->post('lbId',true);
		$data['newsLB'] = $this->input->post('lbcatid',true);
		$data['newsLBTitle'] = $this->input->post('lbtitle',true);

		$this->admin_model->lbUpdateResult($data);

		$sesData['message']="<font color='#006633'>Save Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/newsLBView');
	}
	public function statusLB($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->statusLB($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->statusLB($id, $status);
		}
		redirect('admin_unb/newsLBView');
	}

//---------------------------Latest & Breaking News Start----------------------
// ----------------------Cat News Start-------------------------------------------
	public function catNewsView($id)
	{
		 $data=array();

		$data['id'] = $id;
		$data['cats'] = $this->admin_model->catListResult();
		$data['catnewsquery'] = $this->admin_model->catNewsViewlist($id);

		$data['maincontent']=$this->load->view('admin/view_cat_news',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function catNewsSearch()
	{
		 $data=array();

		$id=$this->input->post('catnewsid');

		$data['catnewsquery'] = $this->admin_model->catNewsViewlist($id);


		redirect('admin_unb/catNewsView/'.$id);
	}
	public function statusCatNews($newsid, $id,  $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->statusCatNewsResult($newsid, $status);
		}
		else if($status==0)
		{
			$this->admin_model->statusCatNewsResult1($id, $status);
			$status = 1;
			$this->admin_model->statusCatNewsResult($newsid, $status);
		}
		redirect('admin_unb/catNewsView/'.$id);
	}
	public function statusCatNewsOne($newsid, $id,  $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->statusCatNewsResultOne($newsid, $status);
		}
		else if($status==0)
		{
			$this->admin_model->statusCatNewsResult1One($id, $status);
			$status = 1;
			$this->admin_model->statusCatNewsResultOne($newsid, $status);
		}
		redirect('admin_unb/catNewsView/'.$id);
	}
	public function statusCatNewsTwo($newsid, $id,  $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->statusCatNewsResultTwo($newsid, $status);
		}
		else if($status==0)
		{
			$this->admin_model->statusCatNewsResult1Two($id, $status);
			$status = 1;
			$this->admin_model->statusCatNewsResultTwo($newsid, $status);
		}
		redirect('admin_unb/catNewsView/'.$id);
	}
// ----------------------Cat News End-------------------------------------------
// ----------------------Top News Start-------------------------------------------

	public function newsTopView()
	{
		$data=array();

		$data['catnewsquery'] = $this->admin_model->newsTopResult();


		$data['maincontent']=$this->load->view('admin/view_top_news',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function  newsTopSerial()
	{
		$data=array();


		$newsId = $this->input->post('newsId',true);
		$newstop = $this->input->post('newstop',true);

		/*echo "<pre>";
		print_r($data);
		exit();*/


						//$this->load->model('admin_model');
		for($i=0;$i<sizeof($newsId);$i++)
		{

			$this->admin_model->newsTopSerialResult($newsId[$i], $newstop[$i]);

		}



		redirect('admin_unb/newsTopView');
	}

// ----------------------Top News End-------------------------------------------
//-------------------Customer Start---------------------------------
	public function custView()
	{
		 $data=array();

		$data['custquery'] = $this->admin_model->custViewlist();

		$data['maincontent']=$this->load->view('admin/view_customer',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function custAddView()
	{
		$data=array();


		$data['maincontent']=$this->load->view('admin/add_customer',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function addCust()
	{
		$data=array();

			$dateTime = new DateTime('now', new DateTimeZone('Asia/Dhaka'));

			$data['custName'] = $this->input->post('custname',true);
			$data['custCompany'] = $this->input->post('comname',true);
			$data['custDesignation'] = $this->input->post('designation',true);
			$data['custEmail'] = $this->input->post('email',true);
			$data['custMobile'] = $this->input->post('mobile',true);
			$data['custPhone'] = $this->input->post('phone',true);
			$data['custDT'] = $dateTime->format("Y-m-d H:i:s");
			$data['custUserName'] = $this->input->post('custuser',true);
			$password = $this->input->post('password',true);
			$password = $this->encrypt->encode($password);
			$data['custPassword'] = str_replace("/", "shahin", $password);
			$data['packageId'] = $this->input->post('packageid',true);
			$data['image_status'] = $this->input->post('image_status',true);
			$data['languageStatus'] = $this->input->post('langid',true);
			$data['custStatus'] = 1;


				$this->admin_model->custAddresult($data);

				$sesData['message']="<font color='#006633'>Save Data Successfully!";
				$this->session->set_userdata($sesData);
			redirect('admin_unb/custAddView');

	}
	public function CustDelete()
	{
		 $data=array();

		$dat=$this->input->post('del');

		$this->load->model('admin_model');
		for($i=0;$i<sizeof($dat);$i++)
		{

			$this->admin_model->deleteCustResult($dat[$i]);
		}
		$sesData['message']="<font color='#FF0000'>Delete Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/custView');
	}
	public function custUpdateView($id)
	{
		$data=array();

		$data['custrow'] = $this->admin_model->custSingleView($id);

		$data['maincontent']=$this->load->view('admin/edit_customer',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function custUpdate()
	{
		$data=array();
		$data['custId'] = $this->input->post('custId',true);
		$data['custName'] = $this->input->post('custName',true);
		$data['custCompany'] = $this->input->post('custCompany',true);
		$data['custDesignation'] = $this->input->post('custDesignation',true);
		$data['custEmail'] = $this->input->post('custEmail',true);
		$data['custMobile'] = $this->input->post('custMobile',true);
		$data['custUserName'] = $this->input->post('custUserName',true);
		$data['packageId'] = $this->input->post('packageid',true);
        $data['image_status'] = $this->input->post('image_status',true);
        $data['languageStatus'] = $this->input->post('langid',true);

		$password = $this->input->post('custPassword',true);
		if($password!=""){
			$password = $this->encrypt->encode($password);
			$data['custPassword'] = str_replace("/", "shahin", $password);
		}

//		var_dump($data);
//		die();
		$this->admin_model->custUpdate($data);

		$sesData['message']="<font color='#006633'>Save Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/custView');
	}
	public function statusCust($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->statusCust($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->statusCust($id, $status);
		}
		redirect('admin_unb/custView');
	}
//-------------------Customer End---------------------------------

//-------------------Offer Button start---------------------------------
	/*public function offerButtonView()
	{
		 $data=array();

		$data['custquery'] = $this->admin_model->custViewlist();

		$data['maincontent']=$this->load->view('admin/view_customer',$data,true);
		$this->load->view('admin/main_page',$data);
	}*/
//-------------------Offer Button end---------------------------------

//-------------------image upload function -----------------------
    /**
     * @param $fieldName
     * @return array
     */
    function imageUpload($fieldName)
	{

		$this->load->library('image_lib');

				//original file
		$config['upload_path'] = '/var/www/html/unb_newswire/picture/main';

		$config['allowed_types'] = 'gif|jpg|png';
		$config['max_size'] = '';
		$config['max_width'] = '';
		$config['max_height'] = '';
//        $config['max_size']  = 100;
//        $config['max_width'] = 1024;
//        $config['max_height'] = 768;
		$this->load->library('upload', $config);

		$this->upload->do_upload($fieldName);

		//thumnil image





		if ($this->upload->do_upload($fieldName))
		{
			$data = $this->upload->data();

			$config['source_image']  = $config['upload_path'].$data['file_name']; //path to the uploaded image
			$config['new_image'] = 'picture/thumbnail/'; //path to
			$config['maintain_ratio'] = TRUE;
			$config['create_thumb'] = FALSE;
			$config['width']   = 300;
			$config['height']  = 200;

			$this->image_lib->initialize($config);
			$this->image_lib->resize();
			$this->image_lib->clear();


		  	$fileName =  $data['file_name'];
		  	//$fileName1 = $config['new_image'] . $data['file_name']; $config['upload_path'] .

			$return = array('file_name' => $fileName ,  'error' => '');
			return $return;
		}else
		{
			$err = '';
			//removing the error as image upload is not required

			$err = $this->upload->display_errors();

			$return = array('file_name' => '' , 'error' => $err);
			return $return;
		}
	}
//------------------------------------------------------------
//-------------------image upload function -----------------------
	function imageAPUpload($fieldNamea)
	{
		$this->load->library('image_lib');

				//original file
		$config['upload_path'] = 'ap_photo/ap_max/';
		$config['allowed_types'] = 'gif|jpg|png';
		$config['max_size'] = '';
		$config['max_width'] = '';
		$config['max_height'] = '';
		$this->load->library('upload', $config);
		//$this->upload->do_upload($fieldName);

		//thumnil image





		if ($this->upload->do_upload($fieldNamea))
		{
			$data = $this->upload->data();

			$config['source_image']  = $config['upload_path'].$data['file_name']; //path to the uploaded image
			$config['new_image'] = 'ap_photo/ap_thumb/'; //path to
			$config['maintain_ratio'] = TRUE;
			$config['create_thumb'] = FALSE;
			$config['width']   = 300;
			$config['height']  = 200;

			$this->image_lib->initialize($config);
			$this->image_lib->resize();
			$this->image_lib->clear();


		  	$fileName =  $data['file_name'];
		  	//$fileName1 = $config['new_image'] . $data['file_name']; $config['upload_path'] .

			$return = array('file_name' => $fileName ,  'error' => '');
			return $return;
		}else
		{
			$err = '';
			//removing the error as image upload is not required

			$err = $this->upload->display_errors();

			$return = array('file_name' => '' , 'error' => $err);
			return $return;
		}
	}
//-------------------bangla photo upload upload function -----------------------
	function bnimageUpload($fieldName)
	{
		$this->load->library('image_lib');

				//original file
		$config['upload_path'] = 'bangla_picture/main/';
		$config['allowed_types'] = 'gif|jpg|png';
		$config['max_size'] = '';
		$config['max_width'] = '';
		$config['max_height'] = '';
		$this->load->library('upload', $config);
		//$this->upload->do_upload($fieldName);

		//thumnil image





		if ($this->upload->do_upload($fieldName))
		{
			$data = $this->upload->data();

			$config['source_image']  = $config['upload_path'].$data['file_name']; //path to the uploaded image
			$config['new_image'] = 'bangla_picture/thumbnail/'; //path to
			$config['maintain_ratio'] = TRUE;
			$config['create_thumb'] = FALSE;
			$config['width']   = 300;
			$config['height']  = 200;

			$this->image_lib->initialize($config);
			$this->image_lib->resize();
			$this->image_lib->clear();


		  	$fileName =  $data['file_name'];
		  	//$fileName1 = $config['new_image'] . $data['file_name']; $config['upload_path'] .

			$return = array('file_name' => $fileName ,  'error' => '');
			return $return;
		}else
		{
			$err = '';
			//removing the error as image upload is not required

			$err = $this->upload->display_errors();

			$return = array('file_name' => '' , 'error' => $err);
			return $return;
		}
	}
//--------------------------bangla photo upload----------------------------------
//----------------------------------------------------------------------
	function ShowBangladeshTime()
	{

		$hour = gmdate("H");

		$minute = gmdate("i");

		$seconds = gmdate("s");

		$day = gmdate("d");

		$month = gmdate("m");

		$year = gmdate("Y");

		// This is the offset from the server time to Bangladesh time.

		$hour = $hour + 6;

		return date("Y-m-d h:i:s", mktime ($hour,$minute,$seconds,$month,$day,$year));

	}
//----------------------------rating start -----------------------------------
  public function ratingView()
  {
	$data=array();

	$data['ratquery'] = $this->admin_model->ratingResult();

	$data['maincontent']=$this->load->view('admin/view_rating',$data,true);
	$this->load->view('admin/main_page',$data);
  }
  public function statusRating($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->statusRat($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->statusRat($id, $status);
		}
		redirect('admin_unb/ratingView');
	}
//-----------------------------rating end -------------------------------------
//----------------------------Convert Start------------------------------------

	public function convertView()
	{
		$data=array();

		$data['conquery'] = $this->admin_model->mysqlData();

		$data['maincontent']=$this->load->view('admin/view_mysqltomysql',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function csvAddViewPage()
	{
		$data=array();

		$data['maincontent']=$this->load->view('admin/add_csv_page',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	function csvAdd()
	{
		$data=array();

		$errors='';
		if ($_FILES['fileupload']['name'] && $_FILES['fileupload']['size'])
		{
			$result = $this->csvUpload('fileupload');

			if ($result)
			{
				$csvName = $result['file_name'];


			}else{
				$errors = $result['error'];
				echo "hoi na";
			}
		}
		//echo base_url()."csvfile/".$csvName;

		$this->load->library('csvreader');
		$result =   $this->csvreader->parse_file(base_url()."csvfile/".$csvName);//path to csv file


		 foreach($result as $resultquery)
		 {
			 $data['comName'] = $resultquery['comName'];
			 $data['catName'] = $resultquery['catName'];
			 $data['comAddress'] = $resultquery['comAddress'];
			 $data['landMark'] = $resultquery['landMark'];
			 $data['cityId'] = $resultquery['cityId'];
			 $data['locationId'] = $resultquery['locationId'];
			 $data['comZip'] = $resultquery['comZip'];
			 $data['comStatus'] = 1;
			 $data['comPersonName'] = $resultquery['comPersonName'];
			 $data['comEmail'] = $resultquery['comEmail'];
			 $data['comMobile'] = $resultquery['comMobile'];
			 $data['comPhone'] = $resultquery['comPhone'];
			 $data['comHotNo'] = $resultquery['comHotNo'];
			 $data['comFax'] = $resultquery['comFax'];
			 $data['comWebsite'] = $resultquery['comWebsite'];
			 $data['contactStatus'] = 1;
			 $data['monIn'] = $resultquery['monIn'];
			 $data['monOut'] = $resultquery['monOut'];
			 $data['offday'] = $resultquery['offday'];
			 $data['established'] = $resultquery['established'];
			 $data['cash'] = $resultquery['cash'];
			 $data['bkash'] = $resultquery['bkash'];
			 $data['card'] = $resultquery['card'];
			 // echo "<pre>";
			 //print_r($resultquery);


			$this->admin_model->csvToMysqlAddResult($data);

		 }
		 exit;
		//$data['csvData'] =  $result;




		redirect('admin_unb/convertView');

	}
	//----------------------------Convert end------------------------------------

// ------------------------- search keyword view start --------------------------------------
	public function searchKeyView()
	{
		$data=array();

		$data['keyrow'] = $this->admin_model->searchKeyViewResult();

		$data['maincontent']=$this->load->view('admin/view_keysearch',$data,true);
		$this->load->view('admin/main_page',$data);
	}
// -------------------------- search keyword view end ---------------------------------------

//---------------------------- report start-----------------------------------------------
	public function newsReportEnglishPage()
	{
		$data=array();

		$dateTime = new DateTime('now', new DateTimeZone('Asia/Dhaka'));
		$currentdt = $dateTime->format("Y-m-d");

		$data['reportenquery'] = $this->admin_model->searchNewsENResult($currentdt);

		$data['maincontent']=$this->load->view('admin/view_report_news',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function newsReportEn()
	{
		$data=array();

		$currentdt = $this->input->post('sdt',true);

		$data['reportenquery'] = $this->admin_model->searchNewsENResult($currentdt);

		$data['maincontent']=$this->load->view('admin/view_report_news',$data,true);
		$this->load->view('admin/main_page',$data);
	}
//----------------------------------------log start---------------------------
	public function logReportEnPage()
	{
		$data=array();

		$dateTime = new DateTime('now', new DateTimeZone('Asia/Dhaka'));
		$currentdt = $dateTime->format("Y-m-d");

		$data['reportenquery'] = $this->admin_model->searchLogENResult($currentdt);

		$data['maincontent']=$this->load->view('admin/view_report_customer',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function logReportEn()
	{
		$data=array();

		$currentdt = $this->input->post('sdt',true);

		$data['reportenquery'] = $this->admin_model->searchLogENResult($currentdt);

		$data['maincontent']=$this->load->view('admin/view_report_customer',$data,true);
		$this->load->view('admin/main_page',$data);
	}
//----------------------------------------log end-----------------------------
//------------------------------------- bangla report ------------------------
	public function newsReportBanglaPage()
	{
		$data=array();

		$dateTime = new DateTime('now', new DateTimeZone('Asia/Dhaka'));
		$currentdt = $dateTime->format("Y-m-d");

		$data['reportenquery'] = $this->admin_model->searchNewsBNResult($currentdt);

		$data['maincontent']=$this->load->view('admin/bangla_view_report_news',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function newsReportBn()
	{
		$data=array();

		$currentdt = $this->input->post('sdt',true);

		$data['reportenquery'] = $this->admin_model->searchNewsBNResult($currentdt);

		$data['maincontent']=$this->load->view('admin/bangla_view_report_news',$data,true);
		$this->load->view('admin/main_page',$data);
	}

//----------------------------------------log start---------------------------
	public function logReportBnPage()
	{
		$data=array();

		$dateTime = new DateTime('now', new DateTimeZone('Asia/Dhaka'));
		$currentdt = $dateTime->format("Y-m-d");

		$data['reportenquery'] = $this->admin_model->searchLogBNResult($currentdt);

		$data['maincontent']=$this->load->view('admin/bangla_view_report_customer',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function logReportBn()
	{
		$data=array();

		$currentdt = $this->input->post('sdt',true);

		$data['reportenquery'] = $this->admin_model->searchLogBNResult($currentdt);

		$data['maincontent']=$this->load->view('admin/bangla_view_report_customer',$data,true);
		$this->load->view('admin/main_page',$data);
	}
//----------------------------------------log end-----------------------------
//------------------------------------- bangla report ------------------------

//---------------------------- report end --------------------------------------------------


//--------------------------------------Bangla Admin Panel -------------------------------------------------------------

// ----------------------bangla category start-------------------------------------------
	public function bncategoryView()
	{
		 $data=array();

		$cats = $this->admin_model->bncategoryViewlist();

		//$data['subcategory'] = $this->admin_model->getSubcategories($catid);
		$data['categories'] = $this->admin_model->bncategoryViewlist();

		$data['maincontent']=$this->load->view('admin/bangla_view_category',$data,true);
            //$data['right_box_content']=$this->load->view('box_content',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function bncategoryAddPage()
	{
		$data=array();

		//$cats = $this->admin_model->categoryViewlist();

        $data['maincontent']=$this->load->view('admin/bangla_add_category',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function bncategoryAdd()
	{
		$data=array();


			$data['catName'] = $this->input->post('categoryname',true);
			$data['homePermission'] = $this->input->post('homeactive',true);
			$data['menuPermission'] = $this->input->post('menuactive',true);
			$data['photoPermission'] = $this->input->post('photoactive',true);
			$data['videoPermission'] = $this->input->post('videoactive',true);
			$data['catStatus'] =1;
			/*echo "<pre>";
			print_r($data);
			exist();*/
			if(!$this->admin_model->bncategoryCheck($data))
		 	{

				$catid = $this->admin_model->bncategoryAdd($data);


				$sesData['message']="<font color='#006633'>Save Data Successfully!</font>";
				$this->session->set_userdata($sesData);

		 }else{
			 $sesData['message']="<font color='#FF0000'>This category alredy exist!</font>";
			 $this->session->set_userdata($sesData);
		 }
			redirect('admin_unb/bncategoryAddPage');

	}
	public function bncategoryUpdateView($catid)
	{
		$data=array();

		$data['catrowview'] = $this->admin_model->bncategorySingleView($catid);



        $data['maincontent']=$this->load->view('admin/bangla_edit_category',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function bncategoryUpdate()
	{
		$data=array();

		$data['catId'] = $this->input->post('catid',true);
		$data['catName'] = $this->input->post('categoryname',true);

		$this->admin_model->bncategoryUpdate($data);



		redirect('admin_unb/bncategoryView');

	}
	public function bnstatusHome($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->bnstatusHome($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->bnstatusHome($id, $status);
		}
		redirect('admin_unb/bncategoryView');
	}
	public function bnstatusMenu($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->bnstatusMenu($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->bnstatusMenu($id, $status);
		}
		redirect('admin_unb/bncategoryView');
	}
	public function bnstatusPhoto($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->bnstatusPhoto($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->bnstatusPhoto($id, $status);
		}
		redirect('admin_unb/bncategoryView');
	}
	public function bnstatusVideo($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->bnstatusVideo($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->bnstatusVideo($id, $status);
		}
		redirect('admin_unb/bncategoryView');
	}
	public function bnstatusCategory($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->bnstatusCategory($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->bnstatusCategory($id, $status);
		}
		redirect('admin_unb/bncategoryView');
	}

	public function bncategoryDelete()
	{
		 $data=array();

		$dat=$this->input->post('del');

		//$this->load->model('admin_model');
		for($i=0;$i<sizeof($dat);$i++)
		{

			$this->admin_model->bndeleteCategoryResult($dat[$i]);
		}
		$sesData['message']="<font color='#FF0000'>Delete Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/bncategoryView');
	}
	public function bnhomeSerialView()
	{
		$data=array();

		$data['catserialquery'] = $this->admin_model->bnhomeSerialViewlist();

        $data['maincontent']=$this->load->view('admin/bangla_view_home_serial_category',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function  bnhomeViewSerial()
	{
		$data=array();
		//$homeSerial = $this->input->post('serialno',true);
		$catId = $this->input->post('catId',true);
		//print_r($catId);
		$serialid = 1;
		for($i=0;$i<sizeof($catId);$i++)
		{
			////echo $serialid;
			$this->admin_model->bnhomeSerialUpdate($catId[$i], $serialid);
			$serialid++;
		}

		redirect('admin_unb/bnhomeSerialView');
	}
	public function bnmenuSerialView()
	{
		$data=array();

		$data['catserialquery'] = $this->admin_model->bnmenuSerialViewlist();

        $data['maincontent']=$this->load->view('admin/bangla_view_menu_serial_category',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function  bnmenuViewSerial()
	{
		$data=array();
		//$homeSerial = $this->input->post('serialno',true);
		$catId = $this->input->post('catId',true);
		//print_r($catId);
		$serialid = 1;
		for($i=0;$i<sizeof($catId);$i++)
		{
			//echo $serialid;
			$this->admin_model->bnmenuSerialUpdate($catId[$i], $serialid);
			$serialid++;
		}

		redirect('admin_unb/menuSerialView');
	}
	public function bnphotoSerialView()
	{
		$data=array();

		$data['catserialquery'] = $this->admin_model->bnphotoSerialViewlist();

        $data['maincontent']=$this->load->view('admin/bangla_view_photo_serial_category',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function  bnphotoViewSerial()
	{
		$data=array();
		//$homeSerial = $this->input->post('serialno',true);
		$catId = $this->input->post('catId',true);
		//print_r($catId);
		$serialid = 1;
		for($i=0;$i<sizeof($catId);$i++)
		{
			//echo $serialid;
			$this->admin_model->bnphotoSerialUpdate($catId[$i], $serialid);
			$serialid++;
		}

		redirect('admin_unb/bnphotoSerialView');
	}
	public function bnvideoSerialView()
	{
		$data=array();

		$data['catserialquery'] = $this->admin_model->bnvideoSerialViewlist();

        $data['maincontent']=$this->load->view('admin/bangla_view_video_serial_category',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function bnapphotoSerialView()
	{
		$data=array();

		$data['catserialquery'] = $this->admin_model->bnapphotoSerialViewlist();

        $data['maincontent']=$this->load->view('admin/bangla_view_ap_serial_category',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function  bnapphotoViewSerial()
	{
		$data=array();
		//$homeSerial = $this->input->post('serialno',true);
		$catId = $this->input->post('catId',true);
		//print_r($catId);
		$serialid = 1;
		for($i=0;$i<sizeof($catId);$i++)
		{
			//echo $serialid;
			$this->admin_model->bnapSerialUpdate($catId[$i], $serialid);
			$serialid++;
		}

		redirect('admin_unb/bnfSerialView');
	}
	public function bnstatusApPhoto($id, $apid)
	{
		if($apid==1)
		{
			$apid = 0;
			$this->admin_model->bnapStatusCategory($id, $apid);
		}
		else if($apid==0)
		{
			$apid = 1;
			$this->admin_model->bnapStatusCategory($id, $apid);
		}
		redirect('admin_unb/bncategoryView');
	}
// ----------------------bangla category end-------------------------------------------
// ----------------------bangla News Start-------------------------------------------
	public function bnnewsView()
	{
		 $data=array();
		 $this->load->library('pagination');


		$config['base_url'] = base_url().'admin_unb/bnnewsView/';
		$data['companyquery'] = $this->admin_model->bnnewsViewlistPage();
		$config['total_rows'] = count($data['companyquery']);
		$config['per_page'] = 20;
		//$config['full_tag_open'] = '<p>';
		//$config['full_tag_close'] = '</p>';
		$config['full_tag_open'] = '<div><ul class="pagination pagination-small pagination-centered">';
		$config['full_tag_close'] = '</ul></div>';
		$config['num_tag_open'] = '<li>';
		$config['num_tag_close'] = '</li>';
		$config['cur_tag_open'] = "<li class='disabled'><li class='active'><a href='#'>";
		$config['cur_tag_close'] = "<span class='sr-only'></span></a></li>";
		$config['next_tag_open'] = "<li>";
		$config['next_tagl_close'] = "</li>";
		$config['prev_tag_open'] = "<li>";
		$config['prev_tagl_close'] = "</li>";
		$config['first_tag_open'] = "<li>";
		$config['first_tagl_close'] = "</li>";
		$config['last_tag_open'] = "<li>";
		$config['last_tagl_close'] = "</li>";

		$this->pagination->initialize($config);

		$data['newsquery']=$this->admin_model->bnnewsViewlist($config['per_page'], $this->uri->segment(3));

		//$data['company'] = $this->admin_model->companyViewlist();

		$data['maincontent']=$this->load->view('admin/bangla_view_news',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function bnnewsSearch()
	{
		$data=array();

		$newssearch = $this->input->post('search',true);

		$data['news']=$this->admin_model->bnnewsSearchViewlist($newssearch);

		$data['maincontent']=$this->load->view('admin/bangla_view_search_news',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function bnnewsAddView()
	{
		$data=array();

		$data['catquery'] = $this->admin_model->bncategoryViewlist();
		$data['lcatquery'] = $this->admin_model->bnLocalCatViewlist();

//		$dateTime = new DateTime('now', new DateTimeZone('Asia/Dhaka'));
//		$data['currentdt'] = $dateTime->format("Y-m-d H:i:s");
        $format = "Y-m-d H:i:s";
        date_default_timezone_set('Asia/Dhaka');
        $dateTime= date($format, strtotime("-10 minute"));
        $data['currentdt'] = $dateTime;

        $data['maincontent']=$this->load->view('admin/bangla_add_news',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function bnnewsAdd()
	{
		$data=array();

		$data['newsTitle'] = $this->input->post('newstitle',true);
		$data['catId'] = $this->input->post('catid',true);
		$subcatid = $this->input->post('subcatid',true);
		if($subcatid == "")
		{
			$data['subCatId'] =  0;
		}else{
			$data['subCatId'] = $subcatid;
		}
		$data['localId'] = $this->input->post('bnlocalid',true);
		$data['newsSlug'] = $this->input->post('newsslug',true);
		$data['newsStandFast'] = $this->input->post('standfast',true);
		$data['NewsDetails'] = $this->input->post('details',true);
		$data['newsDT'] = $this->input->post('datetime',true);
		$data['newsStatus'] =1;


		$errors='';
		if ($_FILES['photopath']['name'] && $_FILES['photopath']['size'])
		{
			$result = $this->bnimageUpload('photopath');
			if ($result)
			{
				$data['photoPath'] = $result['file_name'];
			}

			}else{
				$data['photoPath'] = "";
		}

			if($data['newsTitle']!="")
			{
				$data['newsid'] = $this->admin_model->bnnewsAddResult($data);

				$sesData['message']="<font color='#006633'>Save Data Successfully!</font>";
				$this->session->set_userdata($sesData);



				redirect('admin_unb/bnnewsAddView');
			}else{

				$sesData['message']="<font color='#FF0000'>Insert Date</font>";
				$this->session->set_userdata($sesData);

				redirect('admin_unb/bnnewsAddView');
			}



	}

	public function bnnewsUpdateView($id)
	{
		$data=array();

		$data['catquery'] = $this->admin_model->bncategoryViewlist();
		$data['lcatquery'] = $this->admin_model->bnLocalCatViewlist();
		$data['newsrow'] = $this->admin_model->bnnewsSingleView($id);


		$data['maincontent']=$this->load->view('admin/bangla_edit_news',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function bnnewsUpdate()
	{
		$data=array();
		$data['newsId'] = $this->input->post('newsid',true);
		$id = $data['newsId'];
		$newsrow = $this->admin_model->bnnewsSingleView($id);

		$data['newsTitle'] = $this->input->post('newstitle',true);
		$data['catId'] = $this->input->post('catid',true);
		$data['subCatId'] = $this->input->post('subcatid',true);
		$data['localId'] = $this->input->post('bnlocalid',true);
		$data['newsSlug'] = $this->input->post('newsslug',true);
		$data['newsStandFast'] = $this->input->post('standfast',true);
		$data['NewsDetails'] = $this->input->post('details',true);
		$data['newsDT'] = $this->input->post('datetime',true);


		$errors='';
		if ($_FILES['photopath']['name'] && $_FILES['photopath']['size'])
		{
			echo $_FILES['photopath']['name'];
			$result = $this->bnimageUpload('photopath');
			if ($result)
			{
				$data['photoPath'] = $result['file_name'];

			}

			}else{
				$data['photoPath'] = $newsrow->photoPath;
		}

			if($data['newsTitle']!="")
			{
				$this->admin_model->bnnewsUpdate($data);


				$sesData['message']="<font color='#006633'>Save Data Successfully!</font>";
				$this->session->set_userdata($sesData);

				redirect('admin_unb/bnnewsView/');
			}else{

				$sesData['message']="<font color='#FF0000'>Insert Date</font>";
				$this->session->set_userdata($sesData);

				redirect('admin_unb/bnnewsView/');
			}
	}

	public function bnstatusNews($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->bnstatusNews($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->bnstatusNews($id, $status);
		}
		redirect('admin_unb/bnnewsView');
	}

	public function bnnewsDelete()
	{
		 $data=array();
		//$this->load->helper("url");
		$dat=$this->input->post('del');
		//print_r($dat);
		//exit;
		$this->load->model('admin_model');
		for($i=0;$i<sizeof($dat);$i++)
		{
			$this->admin_model->bndeleteNewsResult($dat[$i]);
		}

		$sesData['message']="<font color='#FF0000'>Delete Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/bnnewsView');
	}
	public function bnchangeTopSearch()
	{
		$comid = $this->input->post('comid');
		$searchtopid = $this->input->post('searchtopid');

		$this->admin_model->bnchangeTopSearchResult($comid, $searchtopid);

		//$restlt['searchtopid'] = $searchtopid;


		echo json_encode($restlt);
	}

// ----------------------bangla News End-------------------------------------------
//---------------------------Bangla Latest & Breaking News Start----------------------
	public function bnnewsLBView()
	{
		 $data=array();

		$data['blquery'] = $this->admin_model->bnlbViewlist();

		$data['maincontent']=$this->load->view('admin/bangla_view_lb',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function bnlbAddView()
	{
		$data=array();


		$data['maincontent']=$this->load->view('admin/bangla_add_lb',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function bnnewsAddLB()
	{
		$data=array();


		$data['newsLBTitle'] = $this->input->post('lbtitle',true);
		$data['newsLB'] = $this->input->post('lbid',true);
		$data['newsLBStatus'] = 1;


		$this->admin_model->bnlbAddresult($data);

		$sesData['message']="<font color='#006633'>Save Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/bnnewsLBView');

	}
	public function bnlbDelete()
	{
		 $data=array();

		$dat=$this->input->post('del');

		$this->load->model('admin_model');
		for($i=0;$i<sizeof($dat);$i++)
		{

			$this->admin_model->bndeleteLBResult($dat[$i]);
		}
		$sesData['message']="<font color='#FF0000'>Delete Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/bnnewsLBView');
	}
	public function bnlbUpdateView($id)
	{
		$data=array();

		$data['lbrow'] = $this->admin_model->bnlbSingleView($id);

		$data['maincontent']=$this->load->view('admin/bangla_edit_lb',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function bnlbUpdate()
	{
		$data=array();
		$data['newsLBId'] = $this->input->post('lbId',true);
		$data['newsLB'] = $this->input->post('lbcatid',true);
		$data['newsLBTitle'] = $this->input->post('lbtitle',true);

		$this->admin_model->bnlbUpdateResult($data);

		$sesData['message']="<font color='#006633'>Save Data Successfully!</font>";
		$this->session->set_userdata($sesData);

		redirect('admin_unb/bnnewsLBView');
	}
	public function bnstatusLB($id, $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->bnstatusLB($id, $status);
		}
		else if($status==0)
		{
			$status = 1;
			$this->admin_model->bnstatusLB($id, $status);
		}
		redirect('admin_unb/bnnewsLBView');
	}

//---------------------------Bangla Latest & Breaking News Start----------------------
// ----------------------bangla Cat News Start-------------------------------------------
	public function bncatNewsView($id)
	{
		 $data=array();


		$data['cats'] = $this->admin_model->bncatListResult();
		$data['catnewsquery'] = $this->admin_model->bncatNewsViewlist($id);
		$data['id'] = $id;

		$data['maincontent']=$this->load->view('admin/bangla_view_cat_news', $data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function bncatNewsSearch()
	{
		 $data=array();

		$id=$this->input->post('catnewsid');

		$data['catnewsquery'] = $this->admin_model->bncatNewsViewlist($id);


		redirect('admin_unb/bncatNewsView/'.$id);
	}
	public function bnstatusCatNews($newsid, $id,  $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->bnstatusCatNewsResult($newsid, $status);
		}
		else if($status==0)
		{
			$this->admin_model->bnstatusCatNewsResult1($id, $status);
			$status = 1;
			$this->admin_model->bnstatusCatNewsResult($newsid, $status);
		}
		redirect('admin_unb/bncatNewsView/'.$id);
	}
	public function bnstatusCatNewsOne($newsid, $id,  $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->bnstatusCatNewsResultOne($newsid, $status);
		}
		else if($status==0)
		{
			$this->admin_model->bnstatusCatNewsResult1One($id, $status);
			$status = 1;
			$this->admin_model->bnstatusCatNewsResultOne($newsid, $status);
		}
		redirect('admin_unb/bncatNewsView/'.$id);
	}
	public function bnstatusCatNewsTwo($newsid, $id,  $status)
	{
		if($status==1)
		{
			$status = 0;
			$this->admin_model->bnstatusCatNewsResultTwo($newsid, $status);
		}
		else if($status==0)
		{
			$this->admin_model->bnstatusCatNewsResult1Two($id, $status);
			$status = 1;
			$this->admin_model->bnstatusCatNewsResultTwo($newsid, $status);
		}
		redirect('admin_unb/bncatNewsView/'.$id);
	}
// ----------------------bangla Cat News End-------------------------------------------
// ----------------------banglaTop News Start-------------------------------------------

	public function bnnewsTopView()
	{
		$data=array();

		$data['catnewsquery'] = $this->admin_model->bnnewsTopResult();


		$data['maincontent']=$this->load->view('admin/bangla_view_top_news',$data,true);
		$this->load->view('admin/main_page',$data);
	}
	public function  bnnewsTopSerial()
	{
		$data=array();


		$newsId = $this->input->post('newsId',true);
		$newstop = $this->input->post('newstop',true);

		/*echo "<pre>";
		print_r($data);
		exit();*/


						//$this->load->model('admin_model');
		for($i=0;$i<sizeof($newsId);$i++)
		{

			$this->admin_model->bnnewsTopSerialResult($newsId[$i], $newstop[$i]);

		}



		redirect('admin_unb/bnnewsTopView');
	}

// ----------------------bangla Top News End-------------------------------------------
}

/* End of file welcome.php */
/* Location: ./application/controllers/welcome.php */
?>