<?php namespace App\Controllers\Admin;

class Trade_farma extends AdminController
{
	private $mObj;
	private $upload_path;
	
	public function __construct(){		
        $this->mObj = model('App\Models\Admin\ExportModel');
		$this->menu_id = 19;
		$this->upload_path = ROOTPATH . 'public'. DIRECTORY_SEPARATOR .'registration_excel'.DIRECTORY_SEPARATOR;
    }
	
	public function index(){
	    
		$data['form_heading'] = "Print Badge";		
		if($this->request->getMethod() === 'post'){
			$rules['from'] =  ['label'=>'From Reg. No.', 'rules' => 'trim|required'];
				$rules['to'] =  ['label'=>'To Reg. No.', 'rules' => 'trim|required'];
			if ($this->validate($rules)) { 
				$data_in['from'] = $this->request->getPost('from');
				$data_in['to'] = $this->request->getPost('to');
			 //   if ($this->request->isAJAX()) {
    //             $this->multiple_badge($data_in);
    //             return $this->response->setStatusCode(200)->setBody('OK');
            // }

            // Non-AJAX: do normal processing (if needed)
            // $this->multiple_badge($data_in);
			    
			}
		}
		$data['footer_includes'] = ['print_badge_js'];
		echo $this->view_inner_template('print_badge',$data);
	
	}
	
	public function multiple_badge(){
	     $data_in['from']= $this->request->getGet('from');
          $data_in['to']   = $this->request->getGet('to');
		$column_arr['registration_id'] = "Registration No.";
		$column_arr['name'] = "Name";
// 		$this->validate_access('is_list');
		$rec_list = $this->get_registration_data($data_in,$column_arr);
// 		echo '<pre>';
// 		print_r($rec_list);
// 		exit();
        create_multiple_badge($rec_list);
        
    }
	
	private function get_registration_data($data,$column_arr){
		$builder = $this->cmObj->get_builder('registration AS r');
	       $builder->select('r.name,c.name As category,c.badge,r.registration_id,r.')
	        ->join('category AS c','c.category_id=r.category_id','left')
	       ->where('r.status','Active')
			->where('r.is_deleted','No')
// 			->where('category_id','2')
			->orderBy('registration_id','asc');
		if($data['to'] > 0){
			$builder->where('registration_id>=',$data['from'])
				->where('registration_id<=',$data['to']);
		}
		$query = $builder->get();
		$rec = $query->getResultArray();
		return $rec;
	}
	
}