public function get_insumos($data = array())
{
$tbl = $this->tbl;
$filtro = empty($data) ? '' : ' AND ' . array_2_string_format($data);
$query = "\tSELECT \r\n\t\t\t\t\t\t ca.id_compras_articulo\r\n\t\t\t\t\t\t,ca.articulo\r\n\t\t\t\t\t\t,cl.linea\r\n\t\t\t\t\t\t,cu.um\r\n\t\t\t\t\t\t,ca.clave_corta\r\n\t\t\t\t\t\t,ca.descripcion\r\n\t\t\t\t\tFROM {$tbl['compras_articulos']} ca\r\n\t\t\t\t\tLEFT JOIN {$tbl['compras_lineas']} cl on cl.id_compras_linea = ca.id_compras_linea \r\n\t\t\t\t\tLEFT JOIN {$tbl['compras_um']} cu on cu.id_compras_um = ca.id_compras_um\r\n\t\t\t\t\tWHERE ca.activo = 1 AND ca.id_articulo_tipo = 2 {$filtro}\r\n\t\t\t\t\tORDER BY ca.id_compras_articulo";
$query = $this->db->query($query);
if ($query->num_rows >= 1) {
return $query->result_array();
}
}
function tool_tips_tpl($value, $tool_tip = '', $pocision = 'right', $attr = array())
{
$attr = array_2_string_format($attr);
/*$tool_tip ="<ul class='tooltips'>
<li><a $attr data-placement='$pocision' data-rel='tooltip' data-original-title='$tool_tip' >$value</a></li>
</ul>";*/
$tool_tip = "<span><a {$attr} title='{$tool_tip}'>{$value}</a></span>";
return $tool_tip;
}
public function insert_item($tbl, $data = array(), $last_id = false)
{
if (isset($data['id_usuario_reg'], $data)) {
unset($data['id_usuario']);
} else {
$data['id_usuario'];
}
$insert = $this->db->insert_string($tbl, $data);
$insert = $this->db->query($insert);
if ($insert) {
$id_row = $this->db->insert_id();
$route = $this->uri->uri_string();
$log = array('route' => $route, 'type' => 'INSERT', 'tabla' => $tbl, 'id_row' => $id_row, 'data_row' => array_2_string_format($data, '=', ','), 'id_usuario' => isset($data['id_usuario']) ? $data['id_usuario'] : $data['id_usuario_reg'], 'timestamp' => $data['timestamp']);
$log = $this->db->insert_string($this->tbl['administracion_movimientos'], $log);
$log = $this->db->query($log);
} else {
$insert = false;
}
if ($last_id) {
return $id_row;
}
return $insert;
}