public function sucursales()
{
$forma = '';
$pago = '';
$venta = '';
$id_sucursal = $this->ajax_post('id_sucursal');
$fpago = $this->db_model->get_forma_pago($id_sucursal);
$epago = $this->db_model->get_esquemas_pago($id_sucursal);
$eventa = $this->db_model->get_esquemas_venta($id_sucursal);
$detalle = $this->db_model->get_orden_unico_sucursal($id_sucursal);
$total_rows = count($detalle);
if ($fpago && $epago && $eventa) {
foreach ($fpago as $key => $value) {
$forma_pago[] = $value['forma_pago'];
$forma .= '-' . $forma_pago[$key] . '<br>';
}
foreach ($epago as $key => $value) {
$esquema_pago[] = $value['esquema_pago'];
$pago .= '-' . $esquema_pago[$key] . '<br>';
}
foreach ($eventa as $key => $value) {
$esquema_venta[] = $value['esquema_venta'];
$venta .= '-' . $esquema_venta[$key] . '<br>';
}
} else {
$fpago = "";
$epago = "";
$eventa = "";
}
//print_debug($forma);
$tbl_data[] = array('id' => $detalle[0]['id_sucursal'], 'nombre' => '<strong>' . $this->lang_item("lbl_sucursal") . ':</strong>', 'nombre_bd' => $detalle[0]['sucursal'], 'clave_corta' => '<strong>' . $this->lang_item("lbl_clave_corta") . ':</strong>', 'clave_corta_bd' => $detalle[0]['clave_corta']);
$tbl_data[] = array('id' => $detalle[0]['id_sucursal'], 'atencion' => '<strong>' . $this->lang_item("lbl_horario_atencion") . ':</strong>', 'atencion_bd' => $detalle[0]['inicio'] . ' a ' . $detalle[0]['final'], 'forma_pago' => '<strong>' . $this->lang_item("lbl_forma_pago") . ':</strong>', 'forma_pago_bd' => $forma);
$tbl_data[] = array('id' => $detalle[0]['id_sucursal'], 'esquema_pago' => '<strong>' . $this->lang_item("lbl_esquema_pago") . ':</strong>', 'esquema_pago_bd' => $pago, 'esquema_venta' => '<strong>' . $this->lang_item("lbl_esquema_venta") . ':</strong>', 'esquema_venta_bd' => $venta);
$tbl_data[] = array('id' => $detalle[0]['id_sucursal'], 'factura' => '<strong>' . $this->lang_item("lbl_comprobante_factura") . ':</strong>', 'factura_bd' => $detalle[0]['factura'] == 1 ? 'si' : 'no', 'r_social' => '<strong>' . $this->lang_item("rs") . ':</strong>', 'r_social_bd' => $detalle[0]['razon_social']);
$tbl_data[] = array('id' => $detalle[0]['id_sucursal'], 'region' => '<strong>' . $this->lang_item("lbl_region") . ':</strong>', 'region_bd' => $detalle[0]['region'], 'entidad' => '<strong>' . $this->lang_item("lbl_entidad") . ':</strong>', 'entidad_bd' => $detalle[0]['entidad']);
$tbl_data[] = array('id' => $detalle[0]['id_sucursal'], 'rfc' => '<strong>' . $this->lang_item("rfc") . ':</strong>', 'rfc_bd' => $detalle[0]['rfc'], 'email' => '<strong>' . $this->lang_item("lbl_email") . ':</strong>', 'email_bd' => $detalle[0]['email']);
$tbl_data[] = array('id' => $detalle[0]['id_sucursal'], 'encargado' => '<strong>' . $this->lang_item("lbl_encargado") . ':</strong>', 'rfc_bd' => $detalle[0]['encargado'], 'email' => '<strong>' . $this->lang_item("lbl_telefono") . ':</strong>', 'email_bd' => $detalle[0]['telefono']);
$tbl_data[] = array('id' => $detalle[0]['id_sucursal'], 'direccion' => '<strong>' . $this->lang_item("direccion") . ':</strong>', 'direccion_bd' => $detalle[0]['direccion'], 'vacio' => '<strong>' . $this->lang_item("lbl_nada") . ':</strong>', 'vacio_bd' => $this->lang_item("lbl_nada"));
// Plantilla
$tbl_plantilla = set_table_resumen_tpl();
// Titulos de tabla
$this->table->set_heading($this->lang_item("lbl_id"), $this->lang_item("lbl_informacion_general"));
// Generar tabla
$this->table->set_template($tbl_plantilla);
$tabla = $this->table->generate($tbl_data);
$buttonTPL = array('text' => $this->lang_item("btn_xlsx"), 'iconsweets' => 'iconsweets-excel', 'href' => base_url($this->path . 'export_sucursal_xlsx?filtro=' . base64_encode($detalle[0]['id_sucursal'])));
$tabData['export'] = button_tpl($buttonTPL);
$tabData['lbl_resumen'] = $this->lang_item('lbl_resumen');
$tabData['tabla'] = $tabla;
$uri_view = $this->modulo . '/' . $this->seccion . '/ficha_sucursales_detalle';
echo json_encode($this->load_view_unique($uri_view, $tabData, true));
}
public function asignar_perfil()
{
$id_perfil = $this->ajax_post('id_perfil');
$id_personal = $this->ajax_post('id_personal');
$id_usuario = $this->ajax_post('id_usuario');
$perfiles = $this->db_model->search_data_perfil($id_personal);
$sqlData = array('buscar' => $id_usuario, 'offset' => 0, 'limit' => 10, 'aplicar_limit' => true);
$detalle = $this->db_model->get_users($sqlData);
//print_debug($detalle);
$tbl_data[] = array('id' => $detalle[0]['id_usuario'], 'nombre' => '<strong>' . $this->lang_item("lbl_nombre_usuario") . ':</strong>', 'nombre_bd' => $detalle[0]['name'], 'clave_corta' => '<strong>' . $this->lang_item("lbl_telefono") . ':</strong>', 'clave_corta_bd' => $detalle[0]['telefono']);
$tbl_data[] = array('id' => $detalle[0]['id_usuario'], 'nombre' => '<strong>' . $this->lang_item("lbl_email") . ':</strong>', 'nombre_bd' => $detalle[0]['mail'], 'clave_corta' => '<strong>' . $this->lang_item("lbl_user") . ':</strong>', 'clave_corta_bd' => $detalle[0]['user']);
$tbl_data[] = array('id' => $detalle[0]['id_usuario'], 'nombre' => '<strong>' . $this->lang_item("lbl_perfil") . ':</strong>', 'nombre_bd' => $detalle[0]['perfil'], 'clave_corta' => '<strong>' . $this->lang_item("lbl_area") . ':</strong>', 'clave_corta_bd' => $detalle[0]['area']);
$tbl_data[] = array('id' => $detalle[0]['id_usuario'], 'nombre' => '<strong>' . $this->lang_item("lbl_puesto") . ':</strong>', 'nombre_bd' => $detalle[0]['puesto'], 'clave_corta' => '', 'clave_corta_bd' => '');
// Plantilla
$tbl_plantilla = set_table_resumen_tpl();
// Titulos de tabla
$this->table->set_heading($this->lang_item("lbl_id"), $this->lang_item("lbl_informacion_general"));
// Generar tabla
$this->table->set_template($tbl_plantilla);
$tabla = $this->table->generate($tbl_data);
if ($perfiles) {
$boton = array('class' => 'btn btn-primary', 'name' => 'agregar_perfil', 'onclick' => 'agregar_perfil()', 'content' => $this->lang_item("btn_guardar"));
$btn_save = form_button($boton);
$perfil_array = array('data' => $perfiles, 'value' => 'id_perfil', 'text' => array('clave_corta', 'perfil'), 'name' => "lts_perfiles", 'class' => "requerido", 'selected' => $id_perfil, 'event' => array('event' => 'onchange', 'function' => 'load_tree_view_perfil_usuario', 'params' => array($id_personal, 'this.value'), 'params_type' => array(0, 0)));
$list_perfiles = dropdown_tpl($perfil_array);
$tabData['tabla'] = $tabla;
//print_debug($tabData['tabla']);
$tabData['lbl_perfiles'] = $this->lang_item("lbl_perfiles");
$tabData['id_personal'] = $id_personal;
$tabData['list_perfiles'] = $list_perfiles;
$tabData['tree_view'] = $this->treeview_perfiles_usuarios($id_personal, $id_perfil);
$tabData['button_save'] = $btn_save;
$uri_view = $this->modulo . '/' . $this->seccion . '/ficha_asignar_perfiles';
echo json_encode($this->load_view_unique($uri_view, $tabData, true));
}
}
