Get db field value to gc list data

Grocery CRUD Community Edition
21

i dont understand !
the function set_upload_field(‘field’,‘assets/files/upload’, ‘pdf’)
but i debug code :

public function set_field_upload($field_name, $upload_dir = ‘’, $allowed_file_types = ‘’)
{
$upload_dir = !empty($upload_dir) && substr($upload_dir,-1,1) == ‘/’
? substr($upload_dir,0,-1)
: $upload_dir;
$upload_dir = !empty($upload_dir) ? $upload_dir : ‘assets/uploads/files’;

  /** Check if the upload Url folder exists. If not then throw an exception **/
  if (!is_dir(FCPATH.$upload_dir)) {
  	throw new Exception("It seems that the folder \"".FCPATH.$upload_dir."\" for the field name
  			\"".$field_name."\" doesn't exists. Please create the folder and try again.");
  }

  $this->upload_fields[$field_name] = (object) array(
  		'field_name' => $field_name,
  		'upload_path' => $upload_dir,
  		'allowed_file_types' => $allowed_file_types,
  		'encrypted_field_name' => $this->_unique_field_name($field_name));
  return $this;

}

the argument ‘pdf’ don’t pushed to $allowed_file_types at the defined function.

why ?

22

i found a solutions about allowed file types per field !
but i have another problem.

I defined this function :

function _callback_before_upload($files_to_upload,$field_info){

		/*debug code */
		//$_SESSION['pkey'] = $pkey;
		$_SESSION['files_to_upload'] = $files_to_upload;
		$_SESSION['field_name']= $field_info->field_name;
		if($field_info->field_name == 'file_url')
		{

			foreach($files_to_upload as $value) {
	        	$ext = pathinfo($value['name'], PATHINFO_EXTENSION);
	    	}

	    	$allowed_formats = array("pdf");
		    if(in_array($ext,$allowed_formats))
		    {
		        return true;
		    }
		    else
		    {
		        return 'Wrong file type. Only pdf files are allowed! ';    
		    }
		}//if

}

inside this function, I want to get the primary key . how can I get it ?

23

hello panv,
i have written this code :

                                if ( $state == 'edit') {

				$pkey = $info->primary_key;

				$this->db->where('id', $pkey);
				$q = $this->db->get('docs');
				$r1 = $q->row();

				$p1 = 'assets/uploads/files/'.$r1->folder_file;
				$_SESSION['p']=$p1;
				$crud->set_field_upload('file_url',$p1);				
			//$crud->set_field_upload('file_url',$this->verify_path_callback($path));
				$crud->set_field_upload('zip_file_attach',$p1);
				//$crud->set_field_upload('zip_file_attach','assets/uploads/files/2021');
				//$crud->callback_before_upload(array($this,'_callback_before_upload'));
			}

ignore comments.
I dont understand why $crud->set_field_upload(‘file_url’,$p1) when i try to upload a file , cant get the full path from value $p1 so the function set_field_upload gets only the default path ‘assets/upload/files’.

why ? what is going wrong? the session value is for testing.

I will appreciate it if you answered me!

24

I am so sorry that I was away for so long. I had to attend to personal issues, and was away from my computer all that time. Please do you still need help in this, so I could look it up ?

25

Hello panv ,
yes, I didn’t find full solution about this.

I had to attend to other issues from other applications.

I solved it but I have another issue with state == edit

i have opened a new post :

if you can sneak a peek with this … i have posted segments with my code…

thank you in advance.

26

I think the set_field_upload works serially . it creates the link between file upload and the path of each record.. .

27

hello again,
may i revive this post and i would like to ask , inside getState==edit how can i get a database field ? to
add it on set_field_upload function.
inside controller i create a function to get the folder name and i call it inside edit like this :


} else if ($crud->getState() == 'edit') {

$photoyear = $this->_get_folder_file($info->primary_key);

set_field_upload(‘file_url’,‘assets/uploads/files/’ . $photoYear);
}


controller.php

function _get_folder_file($id){
    	$this->db->select('folder_file');
    	$this->db->from('docs');
    	$this->db->where('id',$id);
    	$q_fofi = $this->db->get();
    	$row_fofi = $q_fofi->row_array();
    	$this->session->set_userdata('folder_file',$row_fofi['folder_file']);
    	return $row_fofi['folder_file'];
    }

but when I go to edit state and I am trying to upload a file , the file uploads to the default folder (assets/uploads/files) if upload_dir is empty but its not.

I print the $photoyear value which is the name of the folder. So I don’t understand why I can’t upload to a specific folder .

can you help with a more detailed example ; Also i cant find more info about getStateInfo. An example.

Thank you in advanced.

Chris