hello all!! thank you in advance for any help you can provide.
i have a little codeigniter project with grocery crud and mysql. it is working fine but i want to use adminlte in order to add new features.
im working with adminlte blank page template
versions-------------------------------------------
codeigniter 3.1.9
grocerucrud 1.6.3
adminlte 2
dir sctructure---------------------------------------
httdocs
-----------web
-----------------assets
--------------------------adminlte
controller------------------------------------------------------------------------------------------------------------------
public function f_cargadatos($v_where=null) {
try {
$v_where = "mhwh_fk_etarea!='Cancelado' AND mhwh_fk_etarea!='Vencido' AND mhwh_fk_etarea!='Realizado'";
$crud = new grocery_CRUD();
$this->load->config('grocery_crud');
$this->config->set_item('grocery_crud_file_upload_allow_file_types','gif|jpeg|jpg|png|pdf');
$crud->set_theme('datatables');
$crud->set_table('t_mhw_header');
$crud->set_subject('Movimiento HW');
$crud->where($v_where);
$crud->required_fields('mhwh_id_ticket','mhwh_fhrealizacion','mhwh_fk_etarea');
$crud->columns(array( 'id_mhwh' , 'mhwh_fk_cliente' , 'mhwh_reponsable' , 'mhwh_id_ticket' , 'mhwh_fk_sala' , 'mhwh_fk_etarea', 'mhwh_observaciones'));
$crud->fields('mhwh_id_ticket', 'mhwh_fhrealizacion', 'mhwh_fk_edificio', 'mhwh_fk_sala', 'mhwh_reponsable', 'mhwh_fk_cliente' , 'mhwh_observaciones', 'mhwh_firma', 'mhwh_fk_ssff', 'mhwh_fk_etarea', 'mhwh_creator','mhwh_updater');
$crud->field_type('mhwh_creator', 'invisible');
$crud->field_type('mhwh_updater', 'invisible');
$crud->set_relation('mhwh_fk_tdocumento' ,'lst_tipo_documentos' ,'id_tdocumentos' );
$crud->set_relation('mhwh_fk_etarea' ,'lst_estado_tareas' ,'id_estado_tarea');
$crud->set_relation('mhwh_reponsable' ,'lst_responsables' ,'id_resp_nombre');
$crud->set_relation('mhwh_fk_ssff' ,'lst_operariosssff' ,'id_opersssff');
$crud->set_relation('mhwh_fk_sala' ,'lst_salas' ,'id_salas');
$crud->set_relation('mhwh_fk_edificio' ,'lst_edificios' ,'id_edificios');
$crud->set_relation('mhwh_fk_cliente' ,'lst_clientes','id_cliente');
$crud->set_rules ('mhwh_id_ticket','Solicitud N°','trim|alpha_numeric_spaces|required');
$output = $crud->render ();
$this->_load_outputHead($output);
}catch(Exception $e) { show_error($e->getMessage().' --- ‘. $e->getTraceAsString()); }}
public function _load_outputHead($output = null)
{ $this->load->view('app_3wmhw/view’, (array)$output); }
view-----------------------------------------------------------------------------------------------------------------------
<?php $this->load->view('app_3widc/vh_3widc'); ?>
<!-- Main content -->
<section class="content">
<!-- Default box -->
<div class="box">
<div class="box-header with-border">
<h3 class="box-title">Title</h3>
<div class="box-tools pull-right">
<button type="button" class="btn btn-box-tool" data-widget="collapse" data-toggle="tooltip"
title="Collapse">
<i class="fa fa-minus"></i></button>
</div>
</div>
<div class="box-body">
<div class="box">
<div class="box-header with-border">
<h3 class="box-title">Collapsible Box Example</h3>
<div class="box-tools pull-right">
<!-- Collapse Button -->
<button type="button" class="btn btn-box-tool" data-widget="collapse">
<i class="fa fa-minus"></i>
</button>
</div>
<!-- /.box-tools -->
</div> <!-- /.box-header -->
<div class="box-body">
<!-- BODY --------------------------------------------------------------------------------------------- -->
<div class="w3-display-container">
<div class="w3-display-middle w3-large " id=" body" style="padding: 10px;" >
<?php echo $output; ?>
</div>
</div>
<!-- FIN_BODY------------------------------------------------------------------------------------------------- -->
</div>
</div> <!-- /.box -->
</div> <!-- /.box-body -->
<div class="box-footer"> Footer </div> <!-- /.box-footer-->
</div> <!-- /.box -->
</section> <!-- /.content -->
</div> <!-- /.content-wrapper -->
<?php $this->load->view('app_3widc/vf_3widc'); ?>
error----------------------------------------------------------------------------------------------------------------------
Uncaught TypeError: $(...).dataTable is not a function
at loadDataTable (datatables.js:141)
at HTMLTableElement.<anonymous> (datatables.js:59)
at Function.each (jquery.min.js:2)
at w.fn.init.each (jquery.min.js:2)
at HTMLDocument.<anonymous> (datatables.js:52)
at j (jquery-1.11.1.min.js:2)
at Object.fireWith [as resolveWith] (jquery-1.11.1.min.js:2)
at Function.ready (jquery-1.11.1.min.js:2)
at HTMLDocument.J (jquery-1.11.1.min.js:2)
tries---------------------------------------------------------
add all jquery loads at the end of adminlte "after jquery was loaded"
<!-- jQuery 3 -->
<script src="<?php echo base_url();?>assets/adminlte/bower_components/jquery/dist/jquery.min.js"></script>
<!-- Bootstrap 3.3.7 -->
<script src="<?php echo base_url();?>assets/adminlte/bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<!-- SlimScroll -->
<script src="<?php echo base_url();?>assets/adminlte/bower_components/jquery-slimscroll/jquery.slimscroll.min.js"></script>
<!-- FastClick -->
<script src="<?php echo base_url();?>assets/adminlte/bower_components/fastclick/lib/fastclick.js"></script>
<!-- AdminLTE App -->
<script src="<?php echo base_url();?>assets/adminlte/dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="<?php echo base_url();?>assets/adminlte/dist/js/demo.js"></script>
<!--
GROCERY CRUD
<script src="<?php echo base_url();?>assets/grocery_crud/js/jquery-1.11.1.min.js"></script>
-->
<script src="<?php echo base_url();?>assets/grocery_crud/js/common/list.js"></script>
<script src="<?php echo base_url();?>assets/grocery_crud/js/jquery_plugins/ui/jquery-ui-1.10.3.custom.min.js"></script>
<script src="<?php echo base_url();?>assets/grocery_crud/themes/datatables/js/jquery.dataTables.min.js"></script>
<script src="<?php echo base_url();?>assets/grocery_crud/themes/datatables/js/datatables-extras.js"></script>
<script src="<?php echo base_url();?>assets/grocery_crud/themes/datatables/js/datatables.js"></script>
<script src="<?php echo base_url();?>assets/grocery_crud/themes/datatables/extras/TableTools/media/js/ZeroClipboard.js"></script>
<script src="<?php echo base_url();?>assets/grocery_crud/themes/datatables/extras/TableTools/media/js/TableTools.min.js"></script>
<script src="<?php echo base_url();?>assets/grocery_crud/js/jquery_plugins/jquery.fancybox-1.3.4.js"></script>
<script src="<?php echo base_url();?>assets/grocery_crud/js/jquery_plugins/jquery.easing-1.3.pack.js"></script>
Any ideas?
im not developer but i will try to answer all your questions to anyone interested in help me
best regards
