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

if ( ! function_exists('test_method'))
{
    function registration_mail($params){
       $params['config']=email_settings();
       sendmail($params);
       return 1;
    } 
    function forgotpassword_mail($params){
       $params['config']=email_settings();
       sendmail($params);
       return 1; 
    } 
    function email_settings(){
        
        $config['protocol']      = 'smtp';
        $config['smtp_host']     = 'ssl://smtp.gmail.com'; //'ssl://smtp.gmail.com';
        $config['smtp_port']     = '465';  
        $config['smtp_user']     = 'info@pmw24.com.au'; //'joysz2018@gmail'
        $config['smtp_pass']     = 'kzlsdsxnsoevymxi';//'poker#2018';
        $config['charset']    	= 'utf-8';
        $config['newline']    	= "\r\n";
        $config['mailtype'] 	= 'html';
        $config['validation'] 	= TRUE;
        return $config;  
        
    }

    function sendmail($params){
        $obj =get_object();
        $obj->load->library('email');
        $obj->email->initialize($params['config']);
        $obj->email->from('info@pmw24.com.au',$params['name']); 
        $obj->email->to($params['to']);  
        $obj->email->subject($params['subject']);
        $obj->email->message($params['message']);
        $obj->email->set_crlf( "\r\n" ); 
        $obj->email->send(); 
        return $obj->email->send();
        //echo $obj->email->print_debugger();die;
    }
    function get_user_role_type(){
      $user_role=get_object()->session->userdata('user_role');
      return $user_role;
    } 
    function get_object(){
      $obj =& get_instance();
      return $obj;
    }
    function array_to_csv($array, $download = "")
    {

        $n = 0;  
        //$handle = fopen("$download","w");
        $output_file_path = 'public/reports/'.$download; 

        $handle = fopen($output_file_path, 'w');
        foreach ($array as $line)
        {
            $n++;
            fputcsv($handle, $line);
        }
        fclose($handle);   
    }
    function query_to_csv($query, $headers = TRUE, $download = "")
    {

        if ( ! is_object($query) OR ! method_exists($query, 'list_fields'))
        {
            show_error('invalid query');
        }
        
        $array = array();
        
        if ($headers)
        {
            $line = array();
            foreach ($query->list_fields() as $name)
            {
                $line[] = $name;
            }
            $array[] = $line;
        }
        
        foreach ($query->result_array() as $row)
        {
            $line = array();
            foreach ($row as $item)
            {
                $line[] = $item;
            }
            $array[] = $line;
        }
         //print_r($array); die;
         array_to_csv($array, $download);
    }
  
}