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; }