kenshicu

maybe adding the jQuery Migrate plugin, solve your issue.

In the library grocery_crud.php in function protected function get_list()

add:

if(!empty($this->in_where))
   foreach($this->in_where as $in_where):
	$this->basic_model->where($in_where[0].' in '.$in_where[1]);
   endforeach;

In class grocery_CRUD extends grocery_CRUD_States add:

protected $in_where 			= array();

also add in the same class, after function public function or_where(..), the following function:

public function in_where($key, $value = NULL, $escape = TRUE)
	{
		if ($value != '()') $this->in_where[] = array($key,$value,$escape);
	}	

in the controller:

$crud->in_where('workers.id_workplace', $workplace_list);

where $workplace_list containing for example: (1, 15, 3, 8, 20)

is a list of id of workplaces, to get only the workers who are in the workplace specified in the list.

 

 

if anyone has a better idea, tell me

 

 

 

in add/edit form I need to put a selectbox or textbox (field4), which does not exist in the database, so I put:

$crud->fields('field1','field2','field3','field4');

but to save the form, by clicking the button (Save and go back to list), the system does nothing, does not save, does not move.

I made some modifications to flexigrid theme, I put the buttons bootstrap and relocate the button to search

 

download: http://www37.zippysh...71613/file.html

 

I found a solution, I put in bold. For some reason did not load the CSS and JS for chosen

 

// Ayudante de funciones de Filtrar DropDowns según el usuario logeado
function filter_dropdown($table, $id_table, $desc_table, $id_field)
{
 $this->db->select ( '*' );
 $this->db->from ( $table );
 $this->db->where ( $id_table, $id_field );
 $result = $this->db->get ();
 $data = $result->row ();	

 	$html = '<link type="text/css" rel="stylesheet" href="'.base_url().'/assets/grocery_crud/css/jquery_plugins/chosen/chosen.css" />';
	$html .= '<script src="'.base_url().'/assets/grocery_crud/js/jquery_plugins/jquery.chosen.min.js"></script>';
	$html .= '<script src="'.base_url().'/assets/grocery_crud/js/jquery_plugins/config/jquery.chosen.config.js"></script>';
 
 $html.= '<div><select name="'.$id_table.'" class="chosen-select" data-placeholder="Selecciona '.ucwords($table).'" style="width: 200px;">';
 $html.= '<option value=""></option>';
 $html.= '<option value="'.$data->$id_table.'" >'.$data->$desc_table.'</option>';
 $html.= '</select></div>';
 return $html; 
 // retorna el selectbox filtrado
}

How to add two more fields when I edit a record, and update another table also


In order to normalize the database and avoid duplicate fields need to make this change in the structure of the database:

after:


As seen, i remove  id_provincia and id_municipio fields of trabajador table, and then it will not leave these fields when adding or editing the main table (trabajador) with GC.

How do I keep these two fields to add or edit records.

And in edit record of trabajdor table, as knowing the id_municipio and id_provincia through id_consejo_popular ?

I created something about it, in add.php and edit.php files in the path:
(assets\grocery_crud\themes\flexigrid\views\)

I added this code to test, still not finished.
 

<?php    if( $counter <= 45) { ?>
<div style="float:left;">
<?php   } ?>    

<?php    if( $counter > 45) { ?>
<div style="float:right;">
<?php   } ?>

before the line:

<div class='form-field-box <?php echo $even_odd?>' id="<?php echo $field->field_name; ?>_field_box">

with the intention of using more space on the screen, look something like this:

http://s15.postimage...dd_record10.jpg

good ideas are welcome

I found this library to convert to pdf using dompdf

dompdf site: https://github.com/dompdf/
codeigniter + dompdf: https://github.com/i...eigniter-DOMPDF
dompdf updated: https://github.com/d...ompdf/downloads