public function products() { $this->load->library('gc_dependent_select'); $this->grocery_crud->set_theme('datatables'); $this->grocery_crud->set_table('products'); $this->grocery_crud->set_subject('Produse'); $this->grocery_crud->set_relation('categories_id', 'categories', 'name'); $this->grocery_crud->set_relation('subcategories_id', 'subcategories', 'name'); $this->grocery_crud->columns('product_name', 'price', 'categories_id', 'quantity'); $this->grocery_crud->display_as('product_name', 'Nume')->display_as('price', 'Pret')->display_as('quantity', 'Stoc'); $this->grocery_crud->display_as('categories_id', 'Categorie')->display_as('subcategories_id', 'Subcategorie')->display_as('sale', 'Promotie'); $this->grocery_crud->field_type('sale', 'dropdown', array('0' => 'nu', '1' => 'da')); $this->grocery_crud->add_action('Photos', '', 'admin/photos', 'ui-icon-image'); $fields = array('categories_id' => array('table_name' => 'categories', 'title' => 'name', 'relate' => null), 'subcategories_id' => array('table_name' => 'subcategories', 'title' => 'name', 'id_field' => 'subcategories_id', 'relate' => 'categories_id', 'data-placeholder' => 'Selecteaza Subcategorie')); $config = array('main_table' => 'products', 'main_table_primary' => 'products_id', "url" => base_url() . 'admin/' . __FUNCTION__ . '/', 'ajax_loader' => base_url() . 'ajax-loader.gif'); $categories = new gc_dependent_select($this->grocery_crud, $fields, $config); //http://www.grocerycrud.com/forums/topic/1087-updated-24112012-dependent-dropdown-library/ $js = $categories->get_js(); $output = $this->grocery_crud->render(); $output->output .= $js; $this->load->view('example', $output); }
public function index() { $crud = new grocery_CRUD(); //Jangan lupa load library ini $this->load->library('gc_dependent_select'); $crud->set_crud_url_path(site_url('examples/index')); $crud->set_table('data_diri'); $crud->columns('nama', 'fk_id_prov', 'fk_id_kota', 'fk_id_kec', 'fk_id_kel'); $crud->display_as('fk_id_prov', 'Provinsi')->display_as('fk_id_kota', 'Kota')->display_as('fk_id_kec', 'Kecamatan')->display_as('fk_id_kel', 'Kelurahan'); $crud->set_subject('Data Diri'); $crud->set_relation('fk_id_prov', 'provinsi', 'nama'); $crud->set_relation('fk_id_kota', 'kabupaten', 'nama'); $crud->set_relation('fk_id_kec', 'kecamatan', 'nama'); $crud->set_relation('fk_id_kel', 'kelurahan', 'nama'); $fields = array('fk_id_prov' => array('table_name' => 'provinsi', 'title' => 'nama', 'relate' => null, 'data-placeholder' => 'Pilih Provinsi'), 'fk_id_kota' => array('table_name' => 'kabupaten', 'title' => 'nama', 'id_field' => 'id_kab', 'relate' => 'id_prov', 'data-placeholder' => 'Pilih Kota'), 'fk_id_kec' => array('table_name' => 'kecamatan', 'title' => 'ID: {id_kec} / Kota : {nama}', 'id_field' => 'id_kec', 'relate' => 'id_kab', 'data-placeholder' => 'Pilih Kecamatan'), 'fk_id_kel' => array('table_name' => 'kelurahan', 'title' => 'nama', 'id_field' => 'id_kel', 'relate' => 'id_kec', 'data-placeholder' => 'Pilih Kelurahan')); $config = array('main_table' => 'data_diri', 'main_table_primary' => 'id', "url" => site_url() . '/examples/index/', 'ajax_loader' => base_url() . 'assets/ajax-loader.gif'); $categories = new gc_dependent_select($crud, $fields, $config); // first method: //$output = $categories->render(); // the second method: $js = $categories->get_js(); $output = $crud->render(); $output->output .= $js; $this->_example_output($output); }
public function index() { try { // General $crud = new grocery_CRUD(); $crud->set_language("french"); $crud->set_theme('bootstrap'); $crud->set_table('sos_femme'); if (!$this->session->userdata('status')) { $crud->where('archiver', FALSE); } $crud->set_subject('Femme'); //relations $crud->set_relation('situation_familiale', 'sos_gen_situation_familiale_parrent', 'name_situation_familiale_parrent'); $crud->set_relation('detailles', 'sos_gen_situation_familiale_child', 'name_situation_familiale_child'); $crud->set_relation('emplois', 'sos_gen_emplois_parrent', 'name_emplois'); $crud->set_relation('emplois_detailles', 'sos_gen_emplois_child', 'name_emplois_detaille'); $crud->set_relation('emplois_more_detailles', 'sos_gen_emplois_child_child', 'name_emplois_child_child'); $crud->set_relation('age', 'sos_gen_femme_age', 'name_femme_age'); $crud->set_relation('duree_de_la_relation', 'sos_gen_duree_de_la_relation', 'name_duree_de_la_relation', null, 'id_duree_de_la_relation ASC'); $crud->set_relation('service', 'sos_gen_service', 'nom_service', null, 'nom_service DESC'); $crud->set_relation('ville', 'sos_gen_villes', '{nom_ville}, {code_postal}', null, 'nom_ville ASC'); $crud->set_relation('pays', 'sos_gen_pays', '{nom_pays} - {continent}', null, 'nom_pays ASC'); $crud->set_relation('nationalite', 'sos_gen_nationalite', 'name_nationalite'); $crud->set_relation('nationalite_detailles', 'sos_gen_nationalite_detailles', 'name_nationalite_detailles'); $crud->set_relation('ressources', 'sos_gen_ressources', 'name_ressources'); $crud->set_relation('provenance', 'sos_gen_provenance', 'name_provenance'); $crud->set_relation('allocations_familiales', 'sos_gen_allocations_familiales', 'name_allocations_familiales'); $crud->set_relation('percues_par', 'sos_gen_percues_par', 'name_percues_par'); $crud->set_relation('logement', 'sos_gen_logement_parent', 'name_logement'); $crud->set_relation('logement_detailles', 'sos_gen_logement_child', 'name_logement_child'); $crud->set_relation('situation_actuelle_depuis', 'sos_gen_situation_actuelle_depuis', 'name_situation_actuelle_depuis', null, 'id_situation_actuelle_depuis ASC'); $crud->set_relation('situation_actuelle', 'sos_gen_situation_actuelle', 'name_situation_actuelle'); $crud->set_relation('situation_actuelle_detailles', 'sos_gen_situation_actuelle_detailles', 'name_situation_actuelle_detailles'); $crud->set_relation('partenaire', 'sos_gen_partenaire', 'name_partenaire'); $crud->set_relation('informations', 'sos_gen_informations', 'name_informations'); $crud->set_relation('rdv', 'sos_gen_rdv', 'name_rdv'); $crud->set_relation('hebergement', 'sos_gen_hebergement', 'name_hebergement'); $crud->set_relation('departs_anterieurs', 'sos_gen_departs_anterieurs', 'name_departs_anterieurs'); $crud->set_relation('depuis', 'sos_gen_depuis', 'name_depuis'); //Master/child relations $fields_situation_familialle = array('situation_familiale' => array('table_name' => 'sos_gen_situation_familiale_parrent', 'title' => 'name_situation_familiale_parrent', 'relate' => null), 'detailles' => array('table_name' => 'sos_gen_situation_familiale_child', 'title' => 'name_situation_familiale_child', 'id_field' => 'id_situation_familiale_child', 'relate' => 'id_parrent_from_situation_familiale_parrent', 'data-placeholder' => 'Préciser')); $config_situation_familialle = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "situation_familialle"); $categories_situation_familialle = new gc_dependent_select($crud, $fields_situation_familialle, $config_situation_familialle); $js_situation_familialle = $categories_situation_familialle->get_js(); $fields_nationalite = array('nationalite' => array('table_name' => 'sos_gen_nationalite', 'title' => 'name_nationalite', 'relate' => null), 'nationalite_detailles' => array('table_name' => 'sos_gen_nationalite_detailles', 'title' => 'name_nationalite_detailles', 'id_field' => 'id_nationalite_detailles', 'relate' => 'id_from_nationalite', 'data-placeholder' => 'Préciser')); $config_nationalite = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "nationalite"); $categories_nationalite = new gc_dependent_select($crud, $fields_nationalite, $config_nationalite); $js_nationalite = $categories_nationalite->get_js(); $fields_emplois = array('emplois' => array('table_name' => 'sos_gen_emplois_parrent', 'title' => 'name_emplois', 'relate' => null), 'emplois_detailles' => array('table_name' => 'sos_gen_emplois_child', 'title' => 'name_emplois_detaille', 'id_field' => 'id_emplois_detailles', 'relate' => 'id_from_emplois', 'data-placeholder' => 'Préciser'), 'emplois_more_detailles' => array('table_name' => 'sos_gen_emplois_child_child', 'title' => 'name_emplois_child_child', 'id_field' => 'id_emplois_child_child', 'relate' => 'id_emplois_from_child', 'data-placeholder' => 'Préciser')); $config_emplois = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "emplois"); $categories_emplois = new gc_dependent_select($crud, $fields_emplois, $config_emplois); $js_emplois = $categories_emplois->get_js(); $fields_ressources = array('ressources' => array('table_name' => 'sos_gen_ressources', 'title' => 'name_ressources', 'relate' => null), 'provenance' => array('table_name' => 'sos_gen_provenance', 'title' => 'name_provenance', 'id_field' => 'id_provenance', 'relate' => 'id_from_ressources', 'data-placeholder' => 'Préciser')); $config_ressources = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "ressources"); $categories_ressources = new gc_dependent_select($crud, $fields_ressources, $config_ressources); $js_ressources = $categories_ressources->get_js(); $fields_allocations_familiales = array('allocations_familiales' => array('table_name' => 'sos_gen_allocations_familiales', 'title' => 'name_allocations_familiales', 'relate' => null), 'percues_par' => array('table_name' => 'sos_gen_percues_par', 'title' => 'name_percues_par', 'id_field' => 'id_percues_par', 'relate' => 'id_from_allocations_familiales', 'data-placeholder' => 'Préciser')); $config_allocations_familiales = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "allocations_familiales"); $categories_allocations_familiales = new gc_dependent_select($crud, $fields_allocations_familiales, $config_allocations_familiales); $js_allocations_familiales = $categories_allocations_familiales->get_js(); $fields_logement = array('logement' => array('table_name' => 'sos_gen_logement_parent', 'title' => 'name_logement', 'relate' => null), 'logement_detailles' => array('table_name' => 'sos_gen_logement_child', 'title' => 'name_logement_child', 'id_field' => 'id_logement_child', 'relate' => 'id_from_logement_parent', 'data-placeholder' => 'Préciser')); $config_logement = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "logement"); $categories_logement = new gc_dependent_select($crud, $fields_logement, $config_logement); $js_logement = $categories_logement->get_js(); $fields_situation_actuelle = array('situation_actuelle' => array('table_name' => 'sos_gen_situation_actuelle', 'title' => 'name_situation_actuelle', 'relate' => null), 'situation_actuelle_detailles' => array('table_name' => 'sos_gen_situation_actuelle_detailles', 'title' => 'name_situation_actuelle_detailles', 'id_field' => 'id_situation_actuelle_detailles', 'relate' => 'id_from_situation_actuelle', 'data-placeholder' => 'Préciser')); $config_situation_actuelle = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "situation_actuelle"); $categories_situation_actuelle = new gc_dependent_select($crud, $fields_situation_actuelle, $config_situation_actuelle); $js_situation_actuelle = $categories_situation_actuelle->get_js(); //Visual if ($this->session->userdata('status') == '0' or $this->session->userdata('status') == '4') { $crud->columns('prenom', 'nom', 'nom_marital', 'age', 'date_naissance', 'telephone', 'ville', 'nombre_denfants', 'ouvertures', 'premier_contact', 'nombre_passages'); } else { $crud->columns('archiver', 'prenom', 'nom', 'nom_marital', 'age', 'date_naissance', 'telephone', 'ville', 'nombre_denfants', 'ouvertures', 'premier_contact', 'nombre_passages'); } $crud->display_as('pays', 'Originaire de')->display_as('archiver', 'Archivage')->display_as('prenom', 'Prénom')->display_as('telephone', 'Téléphone')->display_as('nationalite', 'Nationalité')->display_as('rue', 'Adresse')->display_as('oriente_par_SMS', 'Orientée par SMS')->display_as('departs_anterieurs', 'Départs antérieurs')->display_as('nationalite_detailles', 'Situation administrative')->display_as('detailles', 'Situation familiale en détail')->display_as('duree_de_la_relation', 'Durée de la relation')->display_as('emplois_detailles', 'Détails de l\'emploi')->display_as('emplois_more_detailles', 'Plus de détails de l\'emploi')->display_as('ouvertures', 'Dernière modification')->display_as('hebergement', 'Demande d\'hébergement')->display_as('aide_materielle', 'Demande d\'aide matérielle')->display_as('accompagnement_exterieur', 'Demande d\'accompagnement extérieur')->display_as('adresse_postale', 'Demande d\'adresse postale')->display_as('accueil', 'Demande d\'accueil')->display_as('informations', 'Demande d\'informations')->display_as('conseil', 'Demande de conseil')->display_as('orientation', 'Demande d\'orientation')->display_as('rdv', 'Demande de rdv')->display_as('hebergement', 'Demande d\'hébergement')->display_as('logement_dem', 'Demande de logement')->display_as('logement_detailles', 'Logement détaillé')->display_as('situation_actuelle_detailles', 'Situation actuelle détaillée')->display_as('emplois', 'Situation professionnelle')->display_as('emplois_detailles', 'Situation professionnelle détaillée')->display_as('emplois_more_detailles', 'Autres infos emploi')->display_as('percues_par', 'Perçues par')->display_as('commentaire', 'Commentaires')->display_as('partenaire', 'Orienteur')->display_as('nombre_passages', 'Nombre passages')->display_as('arrivee_en_france', 'Arrivée en France')->display_as('parle_pas_francais', 'Parle pas français')->display_as('ism', 'Utilisation ISM'); $crud->order_by('prenom', 'asc'); //unsets if ($this->session->userdata('status') == '1' or $this->session->userdata('status') == '2' or $this->session->userdata('status') == '3') { $crud->unset_edit_fields('service', 'par', 'archiver'); } else { $crud->unset_edit_fields('service', 'premier_contact', 'par'); } $crud->unset_add_fields('par', 'archiver'); if ($this->session->userdata('status') == '0' or $this->session->userdata('status') == '4') { $crud->unset_delete(); $crud->unset_export(); $crud->unset_print(); } //Requireds $crud->required_fields('service', 'premier_contact', 'prenom'); //Callbacks $crud->callback_column('ouvertures', array($this, 'ouvertures')); $crud->callback_column('premier_contact', array($this, 'premier_contact')); $crud->callback_column('nombre_denfants', array($this, 'enfants')); $crud->callback_after_update(array($this, 'insert_after_update')); $crud->callback_after_insert(array($this, 'insert_after_insert')); $crud->callback_after_delete(array($this, 'after_delete')); $crud->callback_column('archiver', array($this, 'archiver')); $crud->callback_column('nombre_passages', array($this, 'nombre_passages')); $crud->callback_before_update(array($this, 'before_update')); //field Types $crud->field_type('enceinte', 'dropdown', array('1' => '1 mois', '2' => '2 mois', '3' => '3 mois', '4' => '4 mois', '5' => '5 mois', '6' => '6 mois', '7' => '7 mois', '8' => '8 mois', '9' => '9 mois')); $crud->field_type('dettes', 'enum', array('OUI', 'NON')); $crud->field_type('arrivee_en_france', 'dropdown', range(date("Y"), date("Y") - 50)); $crud->field_type('parle_pas_francais', 'enum', array('OUI', 'NON')); $crud->field_type('ism', 'multiselect', array("1" => "Ponctuel", "2" => "Systématique", "3" => "Venu physiquement")); // Actions $crud->add_action('Enfants', '', 'kids/kids_window', 'ui-icon-person'); $crud->add_action('Intervention', '', 'demande/demande_window', 'ui-icon-home'); $crud->add_action('Profil', '', 'show/show_window', 'ui-icon-print'); $crud->add_action('Violences', '', 'violence/violence_window', 'ui-icon-alert'); $crud->add_action('Démarches', '', 'demarche/demarche_window', 'ui-icon-gear'); if ($this->session->userdata('status') != '0') { $crud->add_action('Psy', '', 'psy/psy_window', 'ui-icon-comment'); } $crud->add_action('Documents', '', 'upload/upload_window', 'ui-icon-document'); // Renders $output = $crud->render(); $output->output .= $js_situation_familialle . $js_emplois . $js_nationalite . $js_ressources . $js_allocations_familiales . $js_logement . $js_situation_actuelle; $menu = new stdClass(); $menu->n0 = true; $menu->status = $this->session->userdata('status'); $header = $this->navigation->home_f($menu); $data = array('output' => $output, 'header' => $header); $this->_example_output($data); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
function dependent_dropdown_place($crud, $table, $pk) { $this->load->library('gc_dependent_select'); // settings $fields = array('province' => array('table_name' => 'place', 'title' => 'province', 'relate' => null), 'municipality' => array('table_name' => 'place', 'title' => 'municipality', 'id_field' => 'municipality', 'relate' => 'province', 'data-placeholder' => 'Select Municipality', 'where' => 'municipality is not null and barangay is null'), 'barangay' => array('table_name' => 'place', 'title' => 'barangay', 'id_field' => 'barangay', 'relate' => 'municipality', 'data-placeholder' => 'Select Barangay')); $config = array('main_table' => $table, 'main_table_primary' => $pk, 'sub_table' => 'place', 'sub_table_primary' => 'place_id', "url" => base_url() . 'index.php/' . __CLASS__ . '/' . __FUNCTION__ . '/', 'ajax_loader' => base_url() . 'assets/img/ajax-loader.gif'); $categories = new gc_dependent_select($crud, $fields, $config); $js = $categories->get_js(); $output = $crud->render(); $output->output .= $js; $this->displayOutput($output); }
public function index() { try { // General $crud = new grocery_CRUD(); $crud->set_language("french"); $crud->set_theme('bootstrap'); $crud->set_table('sos_ecoute'); $crud->order_by('premier_contact', 'desc'); $crud->set_subject('Ecoute téléphonique'); //relations $crud->set_relation('situation_familiale', 'sos_gen_situation_familiale_parrent', 'name_situation_familiale_parrent'); $crud->set_relation('emplois', 'sos_gen_emplois_parrent', 'name_emplois'); $crud->set_relation('age', 'sos_gen_femme_age', 'name_femme_age'); $crud->set_relation('duree_de_la_relation', 'sos_gen_duree_de_la_relation', 'name_duree_de_la_relation', null, 'id_duree_de_la_relation ASC'); $crud->set_relation('ville', 'sos_gen_villes', '{nom_ville}, {code_postal}', null, 'nom_ville ASC'); $crud->set_relation('nationalite', 'sos_gen_nationalite', 'name_nationalite'); $crud->set_relation('ressources', 'sos_gen_ressources', 'name_ressources'); $crud->set_relation('allocations_familiales', 'sos_gen_allocations_familiales', 'name_allocations_familiales'); $crud->set_relation('logement', 'sos_gen_logement_parent', 'name_logement'); $crud->set_relation('situation_actuelle_depuis', 'sos_gen_situation_actuelle_depuis', 'name_situation_actuelle_depuis', null, 'id_situation_actuelle_depuis ASC'); $crud->set_relation('situation_actuelle', 'sos_gen_situation_actuelle', 'name_situation_actuelle'); $crud->set_relation('situation_actuelle_detailles', 'sos_gen_situation_actuelle_detailles', 'name_situation_actuelle_detailles'); $crud->set_relation('partenaire', 'sos_gen_partenaire', 'name_partenaire'); $crud->set_relation('informations', 'sos_gen_informations', 'name_informations'); $crud->set_relation('rdv', 'sos_gen_rdv', 'name_rdv'); $crud->set_relation('hebergement', 'sos_gen_hebergement', 'name_hebergement'); $crud->set_relation('depuis', 'sos_gen_depuis', 'name_depuis'); $crud->set_relation('temps_ecoute', 'sos_gen_temps_ecoute', 'name_temps_ecoute', null, 'id_temps_ecoute ASC'); $crud->set_relation('interlocuteur', 'sos_gen_interlocuteur', 'name_interlocuteur', null, 'id_interlocuteur ASC'); $crud->set_relation('appel', 'sos_gen_appel', 'name_appel', null, 'id_appel ASC'); $crud->set_relation('frequence', 'sos_gen_frequence', 'name_frequence'); $crud->set_relation('commencement', 'sos_gen_commencement', 'name_commencement'); $crud->set_relation_n_n('violences_physiques', 'sos_relation_violences_physiques_ecoute', 'sos_gen_violences_physiques', 'id_from_violences', 'id_from_violences_physiques', 'name_violences_physiques', 'priority'); $crud->set_relation_n_n('violences_psychologiques', 'sos_relation_violences_psychologiques_ecoute', 'sos_gen_violences_psychologiques', 'id_from_violences', 'id_from_violences_psychologiques', 'name_violences_psychologiques', 'priority'); $crud->set_relation_n_n('violences_sexuelles', 'sos_relation_violences_sexuelles_ecoute', 'sos_gen_violences_sexuelles', 'id_from_violences', 'id_from_violences_sexuelles', 'name_violences_sexuelles', 'priority'); $crud->set_relation_n_n('violences_economiques', 'sos_relation_violences_economiques_ecoute', 'sos_gen_violences_economiques', 'id_from_violences', 'id_from_violences_economiques', 'name_violences_economiques', 'priority'); $crud->set_relation_n_n('violences_administratives', 'sos_relation_violences_administratives_ecoute', 'sos_gen_violences_administratives', 'id_from_violences', 'id_from_violences_administratives', 'name_violences_administratives', 'priority'); $crud->set_relation_n_n('violences_sociales', 'sos_relation_violences_sociales_ecoute', 'sos_gen_violences_sociales', 'id_from_violences', 'id_from_violences_sociales', 'name_violences_sociales', 'priority'); $crud->set_relation_n_n('violences_privations', 'sos_relation_violences_privations_ecoute', 'sos_gen_violences_privations', 'id_from_violences', 'id_from_violences_privations', 'name_violences_privations', 'priority'); $crud->set_relation_n_n('violences_juridiques', 'sos_relation_violences_juridiques_ecoute', 'sos_gen_violences_juridiques', 'id_from_violences', 'id_from_violences_juridiques', 'name_violences_juridiques', 'priority'); $crud->set_relation_n_n('de_la_part', 'sos_relation_de_la_part_ecoute', 'sos_gen_de_la_part', 'id_from_violences', 'id_from_de_la_part', 'name_de_la_part'); $crud->set_relation_n_n('raisons', 'sos_relation_raisons_ecoute', 'sos_gen_raisons', 'id_from_violences', 'id_from_raisons', 'name_raisons'); $crud->set_relation_n_n('violences_enfants_directes', 'sos_relation_violences_enfants_directes_ecoute', 'sos_gen_violences_enfants_directes', 'id_from_violences', 'id_from_violences_enfants_directes', 'name_violences_enfants_directes', 'priority'); $crud->set_relation_n_n('violences_enfants_indirectes', 'sos_relation_violences_enfants_indirectes_ecoute', 'sos_gen_violences_enfants_indirectes', 'id_from_violences', 'id_from_violences_enfants_indirectes', 'name_violences_enfants_indirectes', 'priority'); $crud->set_relation_n_n('de_la_part_enfants', 'sos_relation_de_la_part_enfants_ecoute', 'sos_gen_de_la_part_enfants', 'id_from_violences', 'id_from_de_la_part_enfants', 'name_de_la_part_enfants'); $crud->set_relation_n_n('consequences_physiques', 'sos_relation_consequences_physiques_ecoute', 'sos_gen_consequences_physiques', 'id_from_violences', 'id_from_consequences_physiques', 'name_consequences_physiques', 'priority'); $crud->set_relation_n_n('consequences_psychologiques', 'sos_relation_consequences_psychologiques_ecoute', 'sos_gen_consequences_psychologiques', 'id_from_violences', 'id_from_consequences_psychologiques', 'name_consequences_psychologiques', 'priority'); $crud->set_relation_n_n('consequences_administratives', 'sos_relation_consequences_administratives_ecoute', 'sos_gen_consequences_administratives', 'id_from_violences', 'id_from_consequences_administratives', 'name_consequences_administratives', 'priority'); //Master/child relations $fields_situation_actuelle = array('situation_actuelle' => array('table_name' => 'sos_gen_situation_actuelle', 'title' => 'name_situation_actuelle', 'relate' => null), 'situation_actuelle_detailles' => array('table_name' => 'sos_gen_situation_actuelle_detailles', 'title' => 'name_situation_actuelle_detailles', 'id_field' => 'id_situation_actuelle_detailles', 'relate' => 'id_from_situation_actuelle', 'data-placeholder' => 'Préciser')); $config_situation_actuelle = array('main_table' => 'sos_ecoute', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'ajax_loader' => base_url() . 'img/ajax-loader.gif', 'segment_name' => 'situation_actuelle'); $categories_situation_actuelle = new gc_dependent_select($crud, $fields_situation_actuelle, $config_situation_actuelle); $js_situation_actuelle = $categories_situation_actuelle->get_js(); $fields_demarche = array('first' => array('table_name' => 'sos_gen_demarche_first', 'title' => 'name_demarche_first', 'relate' => null), 'second' => array('table_name' => 'sos_gen_demarche_second', 'title' => 'name_demarche_second', 'id_field' => 'id_demarche_second', 'relate' => 'id_from_demarche_first', 'data-placeholder' => 'Préciser'), 'third' => array('table_name' => 'sos_gen_demarche_third', 'title' => 'name_demarche_third', 'id_field' => 'id_demarche_third', 'relate' => 'id_from_demarche_second', 'data-placeholder' => 'Préciser')); // 'url' => base_url() . 'index.php/demarche/window_demarche/'. $this->id_femme.'/', $config_demarche = array('main_table' => 'sos_ecoute', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/ecoute/index/', 'ajax_loader' => base_url() . 'img/ajax-loader.gif', 'segment_name' => 'first'); $categories_demarche = new gc_dependent_select($crud, $fields_demarche, $config_demarche); $js_demarche = $categories_demarche->get_js(); $fields_demarche1 = array('first1' => array('table_name' => 'sos_gen_demarche_first', 'title' => 'name_demarche_first', 'relate' => null), 'second1' => array('table_name' => 'sos_gen_demarche_second', 'title' => 'name_demarche_second', 'id_field' => 'id_demarche_second', 'relate' => 'id_from_demarche_first', 'data-placeholder' => 'Préciser'), 'third1' => array('table_name' => 'sos_gen_demarche_third', 'title' => 'name_demarche_third', 'id_field' => 'id_demarche_third', 'relate' => 'id_from_demarche_second', 'data-placeholder' => 'Préciser')); // 'url' => base_url() . 'index.php/demarche/window_demarche/'. $this->id_femme.'/', $config_demarche1 = array('main_table' => 'sos_ecoute', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/ecoute/index/', 'ajax_loader' => base_url() . 'img/ajax-loader.gif', 'segment_name' => 'first1'); $categories_demarche1 = new gc_dependent_select($crud, $fields_demarche1, $config_demarche1); $js_demarche1 = $categories_demarche1->get_js(); $fields_demarche2 = array('first2' => array('table_name' => 'sos_gen_demarche_first', 'title' => 'name_demarche_first', 'relate' => null), 'second2' => array('table_name' => 'sos_gen_demarche_second', 'title' => 'name_demarche_second', 'id_field' => 'id_demarche_second', 'relate' => 'id_from_demarche_first', 'data-placeholder' => 'Préciser'), 'third2' => array('table_name' => 'sos_gen_demarche_third', 'title' => 'name_demarche_third', 'id_field' => 'id_demarche_third', 'relate' => 'id_from_demarche_second', 'data-placeholder' => 'Préciser')); // 'url' => base_url() . 'index.php/demarche/window_demarche/'. $this->id_femme.'/', $config_demarche2 = array('main_table' => 'sos_ecoute', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/ecoute/index/', 'ajax_loader' => base_url() . 'img/ajax-loader.gif', 'segment_name' => 'first2'); $categories_demarche2 = new gc_dependent_select($crud, $fields_demarche2, $config_demarche2); $js_demarche2 = $categories_demarche2->get_js(); $crud->set_relation('first', 'sos_gen_demarche_first', 'name_demarche_first'); $crud->set_relation('second', 'sos_gen_demarche_second', 'name_demarche_second'); $crud->set_relation('third', 'sos_gen_demarche_third', 'name_demarche_third'); $crud->set_relation('first1', 'sos_gen_demarche_first', 'name_demarche_first'); $crud->set_relation('second1', 'sos_gen_demarche_second', 'name_demarche_second'); $crud->set_relation('third1', 'sos_gen_demarche_third', 'name_demarche_third'); $crud->set_relation('first2', 'sos_gen_demarche_first', 'name_demarche_first'); $crud->set_relation('second2', 'sos_gen_demarche_second', 'name_demarche_second'); $crud->set_relation('third2', 'sos_gen_demarche_third', 'name_demarche_third'); //Visual $crud->display_as('nationalite', 'Nationalité')->display_as('premier_contact', 'Date')->display_as('duree_de_la_relation', 'Durée de la relation')->display_as('emplois_detailles', 'Détails de l\'emploi')->display_as('emplois_more_detailles', 'Plus de détails de l\'emploi')->display_as('ouvertures', 'Dernière modification')->display_as('hebergement', 'Demande d\'hébergement')->display_as('aide_materielle', 'Demande d\'aide matérielle')->display_as('accueil', 'Demande d\'accueil')->display_as('informations', 'Demande d\'informations')->display_as('conseil', 'Demande de conseil')->display_as('orientation', 'Demande d\'orientation')->display_as('rdv', 'Demande de rdv')->display_as('hebergement', 'Demande d\'hébergement')->display_as('situation_actuelle_detailles', 'Situation actuelle détaillée')->display_as('emplois', 'Situation professionnelle')->display_as('commentaire', 'Commentaires')->display_as('partenaire', 'Orienteur')->display_as('rep_accueil', 'Réponse')->display_as('rep_informations', 'Réponse')->display_as('rep_conseil', 'Réponse')->display_as('rep_orientation', 'Réponse')->display_as('rep_rdv', 'Réponse')->display_as('rep_hebergement', 'Réponse')->display_as('rep_soutien', 'Réponse')->display_as('rep_aide_materielle', 'Réponse')->display_as('rep_ecoute', 'Réponse')->display_as('consequences', 'Conséquences')->display_as('consequences_administratives', 'Conséquences administratives et économiques')->display_as('violences_economiques', 'Violences économiques')->display_as('consequences_physiques', 'Conséquences physiques')->display_as('consequences_psychologiques', 'Conséquences psychologiques')->display_as('consequences_administratives', 'Conséquences administratives')->display_as('de_la_part_enfants', 'Violences sur enfants par')->display_as('temps_ecoute', "Temps d'écoute")->display_as('age', 'Age de la femme')->display_as('logement_dem', 'Demande de logement')->display_as('rep_logement_dem', 'Réponse')->display_as('violences_enfants_directes', 'ENFANTS - Violences directes')->display_as('violences_enfants_indirectes', 'ENFANTS - Violences indirectes')->display_as('frequence', 'Fréquence')->display_as('demandes', 'Demandes/Réponses'); $crud->display_as('first', 'Type de démarche 1'); $crud->display_as('second', 'Type d\'intervention 1'); $crud->display_as('third', 'Suites 1'); $crud->display_as('first1', 'Type de démarche 2'); $crud->display_as('second1', 'Type d\'intervention 2'); $crud->display_as('third1', 'Suites 2'); $crud->display_as('first2', 'Type de démarche 3'); $crud->display_as('second2', 'Type d\'intervention 3'); $crud->display_as('third2', 'Suites 3'); $crud->display_as('demarche', 'Démarches'); //unsets if ($this->session->userdata('status') == '1' or $this->session->userdata('status') == '2' or $this->session->userdata('status') == '3') { $crud->fields('premier_contact', 'interlocuteur', 'appel', 'partenaire', 'temps_ecoute', 'age', 'enfants', 'enceinte', 'ville', 'nationalite', 'situation_familiale', 'depuis', 'duree_de_la_relation', 'emplois', 'logement', 'situation_actuelle', 'situation_actuelle_detailles', 'situation_actuelle_depuis', 'ressources', 'allocations_familiales', 'dettes', 'soutien', 'rep_soutien', 'ecoute', 'rep_ecoute', 'accueil', 'rep_accueil', 'informations', 'rep_informations', 'conseil', 'rep_conseil', 'orientation', 'rep_orientation', 'rdv', 'rep_rdv', 'hebergement', 'rep_hebergement', 'logement_dem', 'rep_logement_dem', 'aide_materielle', 'rep_aide_materielle', 'violences_physiques', 'violences_psychologiques', 'violences_sexuelles', 'violences_economiques', 'violences_administratives', 'violences_sociales', 'violences_privations', 'violences_juridiques', 'de_la_part', 'raisons', 'violences_enfants_directes', 'violences_enfants_indirectes', 'de_la_part_enfants', 'consequences_physiques', 'consequences_psychologiques', 'consequences_administratives', 'frequence', 'commencement', 'first', 'second', 'third', 'first1', 'second1', 'third1', 'first2', 'second2', 'third2', 'commentaire'); } else { $crud->fields('interlocuteur', 'appel', 'partenaire', 'temps_ecoute', 'age', 'enfants', 'enceinte', 'ville', 'nationalite', 'situation_familiale', 'depuis', 'duree_de_la_relation', 'emplois', 'logement', 'situation_actuelle', 'situation_actuelle_detailles', 'situation_actuelle_depuis', 'ressources', 'allocations_familiales', 'dettes', 'soutien', 'rep_soutien', 'ecoute', 'rep_ecoute', 'accueil', 'rep_accueil', 'informations', 'rep_informations', 'conseil', 'rep_conseil', 'orientation', 'rep_orientation', 'rdv', 'rep_rdv', 'hebergement', 'rep_hebergement', 'logement_dem', 'rep_logement_dem', 'aide_materielle', 'rep_aide_materielle', 'violences_physiques', 'violences_psychologiques', 'violences_sexuelles', 'violences_economiques', 'violences_administratives', 'violences_sociales', 'violences_privations', 'violences_juridiques', 'de_la_part', 'raisons', 'violences_enfants_directes', 'violences_enfants_indirectes', 'de_la_part_enfants', 'consequences_physiques', 'consequences_psychologiques', 'consequences_administratives', 'frequence', 'commencement', 'first', 'second', 'third', 'first1', 'second1', 'third1', 'first2', 'second2', 'third2', 'commentaire'); } $crud->unset_add_fields('par'); if ($this->session->userdata('status') == '0' or $this->session->userdata('status') == '4') { $crud->unset_delete(); $crud->unset_export(); $crud->unset_print(); } //Requireds $crud->required_fields('premier_contact', 'appel', 'temps_ecoute', 'interlocuteur'); $crud->columns('premier_contact', 'infos', 'situation', 'demandes', 'violences', 'de_la_part', 'commencement', 'consequences', 'demarche'); //Callbacks $crud->callback_column('ouvertures', array($this, 'ouvertures')); $crud->callback_column('premier_contact', array($this, 'premier_contact')); $crud->callback_column('infos', array($this, 'infos')); $crud->callback_column('situation', array($this, 'situation')); $crud->callback_column('demandes', array($this, 'demandes')); $crud->callback_column('commentaire', array($this, 'commentaire')); $crud->callback_column('demarche', array($this, 'demarche')); $crud->callback_after_update(array($this, 'insert_after_update')); $crud->callback_after_insert(array($this, 'insert_after_insert')); $crud->callback_before_update(array($this, 'before_update')); $crud->callback_column('de_la_part', array($this, 'de_la_part')); $crud->callback_column('raisons', array($this, 'raisons')); $crud->callback_column('violences', array($this, 'violences')); $crud->callback_column('consequences', array($this, 'consequences')); //field Types //$crud->callback_edit_field('accueil', array($this, 'edit_field_callback_1')); //$crud->callback_add_field('accueil', array($this, 'add_field_callback_1')); //field Types $crud->field_type('dettes', 'enum', array('OUI', 'NON')); $crud->field_type('enceinte', 'enum', array('OUI', 'NON')); // $crud->field_type('appel', 'dropdown', array('0' => '', '1' => '1er appel', '2' => 'Appel suivi', '3' => 'Autres appels')); $crud->field_type('enfants', 'enum', array('Aucun', '1 enfant', '2 enfants', '3 enfants', '4 enfants', '5 et +')); // $crud->field_type('interlocuteur', 'dropdown', array('0' => '', '1' => 'Elle-même', '2' => 'Professionnel', '3' => 'Entourage')); // Actions // Renders $output = $crud->render(); $output->output .= $js_situation_actuelle . $js_demarche . $js_demarche1 . $js_demarche2; $menu = new stdClass(); $menu->status = $this->session->userdata('status'); if ($menu->status != 5) { $menu->n1 = true; } else { $menu->n0 = true; } $header = $this->navigation->home_f($menu); $data = array('output' => $output, 'header' => $header); $this->_example_output($data); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
function test1() { $crud = new grocery_CRUD(); $crud->set_table('pt_questions'); $crud->set_relation('sid', 'section', 'section_name', array('subject_id' => '1')); $crud->set_relation('ssid', 'sub_section', 'sub_section_name'); $crud->set_relation('tid', 'topics', 'topic_name'); $this->load->library('gc_dependent_select'); // settings $fields = array('sid' => array('table_name' => 'section', 'title' => 'section_name', 'relate' => null), 'ssid' => array('table_name' => 'sub_section', 'title' => 'sub_section_name', 'id_field' => 'sub_section_id', 'relate' => 'section_id', 'data-placeholder' => 'select ssid'), 'tid' => array('table_name' => 'topics', 'title' => '{tid} / {topic_name}', 'id_field' => 'tid', 'relate' => 'sub_section', 'data-placeholder' => 'select tid')); $config = array('main_table' => 'pt_questions', 'main_table_primary' => 'qid', "url" => base_url() . 'index.php/' . __CLASS__ . '/' . __FUNCTION__ . '/', 'ajax_loader' => base_url() . 'ajax-loader.gif', 'segment_name' => 'Your_segment_name'); $categories = new gc_dependent_select($crud, $fields, $config); // first method: //$output = $categories->render(); // the second method: $js = $categories->get_js(); $output = $crud->render(); $output->output .= $js; $this->_example_output($output); }
public function first($id) { try { // General $crud = new grocery_CRUD(); $crud->set_language("french"); $crud->set_theme('bootstrap'); $crud->set_table('sos_femme_premier'); if (!$this->session->userdata('status')) { $crud->where('archiver', FALSE); } $crud->set_subject('Femme'); $crud->where('id_femme', $id); $crud->unset_add(); //relations $crud->set_relation('situation_familiale', 'sos_gen_situation_familiale_parrent', 'name_situation_familiale_parrent'); $crud->set_relation('detailles', 'sos_gen_situation_familiale_child', 'name_situation_familiale_child'); $crud->set_relation('emplois', 'sos_gen_emplois_parrent', 'name_emplois'); $crud->set_relation('emplois_detailles', 'sos_gen_emplois_child', 'name_emplois_detaille'); $crud->set_relation('emplois_more_detailles', 'sos_gen_emplois_child_child', 'name_emplois_child_child'); $crud->set_relation('logement', 'sos_gen_logement_parent', 'name_logement'); $crud->set_relation('logement_detailles', 'sos_gen_logement_child', 'name_logement_child'); $crud->set_relation('ressources', 'sos_gen_ressources', 'name_ressources'); $crud->set_relation('provenance', 'sos_gen_provenance', 'name_provenance'); $crud->set_relation('allocations_familiales', 'sos_gen_allocations_familiales', 'name_allocations_familiales'); $crud->set_relation('percues_par', 'sos_gen_percues_par', 'name_percues_par'); $crud->set_relation('depuis', 'sos_gen_depuis', 'name_depuis'); $crud->set_relation('situation_actuelle_depuis', 'sos_gen_situation_actuelle_depuis', 'name_situation_actuelle_depuis', null, 'id_situation_actuelle_depuis ASC'); $crud->set_relation('situation_actuelle', 'sos_gen_situation_actuelle', 'name_situation_actuelle'); $crud->set_relation('situation_actuelle_detailles', 'sos_gen_situation_actuelle_detailles', 'name_situation_actuelle_detailles'); $crud->set_relation('departs_anterieurs', 'sos_gen_departs_anterieurs', 'name_departs_anterieurs'); //Master/child relations $fields_situation_familialle = array('situation_familiale' => array('table_name' => 'sos_gen_situation_familiale_parrent', 'title' => 'name_situation_familiale_parrent', 'relate' => null), 'detailles' => array('table_name' => 'sos_gen_situation_familiale_child', 'title' => 'name_situation_familiale_child', 'id_field' => 'id_situation_familiale_child', 'relate' => 'id_parrent_from_situation_familiale_parrent', 'data-placeholder' => 'Préciser')); $config_situation_familialle = array('main_table' => 'sos_femme_premier', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "situation_familialle"); $categories_situation_familialle = new gc_dependent_select($crud, $fields_situation_familialle, $config_situation_familialle); $js_situation_familialle = $categories_situation_familialle->get_js(); $fields_situation_actuelle = array('situation_actuelle' => array('table_name' => 'sos_gen_situation_actuelle', 'title' => 'name_situation_actuelle', 'relate' => null), 'situation_actuelle_detailles' => array('table_name' => 'sos_gen_situation_actuelle_detailles', 'title' => 'name_situation_actuelle_detailles', 'id_field' => 'id_situation_actuelle_detailles', 'relate' => 'id_from_situation_actuelle', 'data-placeholder' => 'Préciser')); $config_situation_actuelle = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "situation_actuelle"); $categories_situation_actuelle = new gc_dependent_select($crud, $fields_situation_actuelle, $config_situation_actuelle); $js_situation_actuelle = $categories_situation_actuelle->get_js(); $fields_emplois = array('emplois' => array('table_name' => 'sos_gen_emplois_parrent', 'title' => 'name_emplois', 'relate' => null), 'emplois_detailles' => array('table_name' => 'sos_gen_emplois_child', 'title' => 'name_emplois_detaille', 'id_field' => 'id_emplois_detailles', 'relate' => 'id_from_emplois', 'data-placeholder' => 'Préciser'), 'emplois_more_detailles' => array('table_name' => 'sos_gen_emplois_child_child', 'title' => 'name_emplois_child_child', 'id_field' => 'id_emplois_child_child', 'relate' => 'id_emplois_from_child', 'data-placeholder' => 'Préciser')); $config_emplois = array('main_table' => 'sos_femme_premier', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "emplois"); $categories_emplois = new gc_dependent_select($crud, $fields_emplois, $config_emplois); $js_emplois = $categories_emplois->get_js(); $fields_ressources = array('ressources' => array('table_name' => 'sos_gen_ressources', 'title' => 'name_ressources', 'relate' => null), 'provenance' => array('table_name' => 'sos_gen_provenance', 'title' => 'name_provenance', 'id_field' => 'id_provenance', 'relate' => 'id_from_ressources', 'data-placeholder' => 'Préciser')); $config_ressources = array('main_table' => 'sos_femme_premier', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "ressources"); $categories_ressources = new gc_dependent_select($crud, $fields_ressources, $config_ressources); $js_ressources = $categories_ressources->get_js(); $fields_allocations_familiales = array('allocations_familiales' => array('table_name' => 'sos_gen_allocations_familiales', 'title' => 'name_allocations_familiales', 'relate' => null), 'percues_par' => array('table_name' => 'sos_gen_percues_par', 'title' => 'name_percues_par', 'id_field' => 'id_percues_par', 'relate' => 'id_from_allocations_familiales', 'data-placeholder' => 'Préciser')); $config_allocations_familiales = array('main_table' => 'sos_femme_premier', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "allocations_familiales"); $categories_allocations_familiales = new gc_dependent_select($crud, $fields_allocations_familiales, $config_allocations_familiales); $js_allocations_familiales = $categories_allocations_familiales->get_js(); $fields_logement = array('logement' => array('table_name' => 'sos_gen_logement_parent', 'title' => 'name_logement', 'relate' => null), 'logement_detailles' => array('table_name' => 'sos_gen_logement_child', 'title' => 'name_logement_child', 'id_field' => 'id_logement_child', 'relate' => 'id_from_logement_parent', 'data-placeholder' => 'Préciser')); $config_logement = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "logement"); $categories_logement = new gc_dependent_select($crud, $fields_logement, $config_logement); $js_logement = $categories_logement->get_js(); //Visual $crud->columns('Premier Acceuil', 'enceinte', 'profession', 'Situation Actuelle - Emlpoi', 'Appartenance - Logement', 'Situation Actuelle - Logement', 'departs_anterieurs', 'ressources', 'provenance', 'Allocations familiales', 'dettes'); $crud->display_as('pays', 'Originaire de')->display_as('archiver', 'Archivage')->display_as('prenom', 'Prénom')->display_as('telephone', 'Téléphone')->display_as('nationalite', 'Nationalité')->display_as('rue', 'Adresse')->display_as('oriente_par_SMS', 'Orientée par SMS')->display_as('departs_anterieurs', 'Départs antérieurs')->display_as('nationalite_detailles', 'Situation administrative')->display_as('detailles', 'Situation familiale en détail')->display_as('duree_de_la_relation', 'Durée de la relation')->display_as('emplois_detailles', 'Détails de l\'emploi')->display_as('emplois_more_detailles', 'Plus de détails de l\'emploi')->display_as('ouvertures', 'Dernière modification')->display_as('hebergement', 'Demande d\'hébergement')->display_as('aide_materielle', 'Demande d\'aide matérielle')->display_as('accompagnement_exterieur', 'Demande d\'accompagnement extérieur')->display_as('adresse_postale', 'Demande d\'adresse postale')->display_as('accueil', 'Demande d\'accueil')->display_as('informations', 'Demande d\'informations')->display_as('conseil', 'Demande de conseil')->display_as('orientation', 'Demande d\'orientation')->display_as('rdv', 'Demande de rdv')->display_as('hebergement', 'Demande d\'hébergement')->display_as('logement_dem', 'Demande de logement')->display_as('logement_detailles', 'Logement détaillé')->display_as('situation_actuelle_detailles', 'Situation actuelle détaillée')->display_as('emplois', 'Situation professionnelle')->display_as('emplois_detailles', 'Situation professionnelle détaillée')->display_as('emplois_more_detailles', 'Autres infos emploi')->display_as('percues_par', 'Perçues par')->display_as('commentaire', 'Commentaires')->display_as('partenaire', 'Orienteur'); $crud->order_by('prenom', 'desc'); //unsets if (!$this->session->userdata('status')) { $crud->unset_delete(); $crud->unset_export(); $crud->unset_print(); } //Requireds //$crud->required_fields('service', 'premier_contact', 'prenom'); //Callbacks $crud->callback_column('Premier Acceuil', array($this, 'premier_acceuil')); $crud->callback_column('Situation Actuelle - Emlpoi', array($this, 'situation_actuelle')); $crud->callback_column('Appartenance - Logement', array($this, 'appartenance')); $crud->callback_column('Situation Actuelle - Logement', array($this, 'situation_actuelle_logement')); $crud->callback_column('Allocations familiales', array($this, 'allocations_familiales')); //$crud->callback_column('premier_contact', array($this, 'premier_contact')); //$crud->callback_column('nombre_d\'enfants', array($this, 'enfants')); //$crud->callback_after_update(array($this, 'insert_after_update')); //$crud->callback_after_insert(array($this, 'insert_after_insert')); //$crud->callback_after_delete(array($this, 'after_delete')); //$crud->callback_column('archiver', array($this, 'archiver')); $crud->callback_before_update(array($this, 'before_update')); //field Types $crud->field_type('enceinte', 'dropdown', array('1' => '1 mois', '2' => '2 mois', '3' => '3 mois', '4' => '4 mois', '5' => '5 mois', '6' => '6 mois', '7' => '7 mois', '8' => '8 mois', '9' => '9 mois')); $crud->field_type('dettes', 'enum', array('OUI', 'NON')); // Actions // Renders $crud->unset_fields('id_femme', 'prenom', 'nom', 'age', 'telephone', 'nom_marital', 'rue', 'premier_contact', 'par', 'service', 'oriente_par_SMS', 'partenaire', 'ville', 'pays', 'nationalite', 'nationalite_detailles', 'accueil', 'informations', 'conseil', 'orientation', 'rdv', 'hebergement', 'logement_dem', 'aide_materielle', 'adresse_postale', 'accompagnement_exterieur', 'commentaire', 'archiver', 'duree_de_la_relation'); $output = $crud->render(); $output->output .= $js_situation_familialle . $js_emplois . $js_ressources . $js_allocations_familiales . $js_logement . $js_situation_actuelle; $menu = new stdClass(); $menu->n1 = true; $menu->status = $this->session->userdata('status'); $header = $this->navigation->home_f($menu); $data = array('output' => $output, 'header' => $header); $this->_example_output($data); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function upload_window($id) { $this->id_femme = $id; try { // General $crud = new grocery_CRUD(); $crud->set_language("french"); $crud->set_theme('bootstrap'); $crud->where('id_from_femme', $id); $crud->set_table('sos_upload'); $crud->set_subject('Document'); $crud->field_type('id_from_femme', 'hidden', $this->id_femme); //relations $crud->set_relation('type_uploads', 'sos_gen_type_uploads_parrent', 'name_type_uploads_parrent'); $crud->set_relation('detailles', 'sos_gen_type_uploads_child', 'name_type_uploads_child'); //Master/child relations //Visual $crud->columns('type_uploads', 'detailles', 'file_url', 'date_entry'); //unsets $crud->unset_fields('date_entry'); $crud->unset_export(); $crud->unset_print(); //Requireds $crud->required_fields('type_uploads', 'file_url'); //Visual $crud->display_as('type_uploads', 'Type de document')->display_as('detailles', 'Détail')->display_as('date_entry', 'Date d\'envoi')->display_as('file_url', 'Document'); //Callbacks $crud->callback_after_update(array($this, 'after_update')); $crud->callback_before_upload(array($this, 'before_upload')); $crud->callback_before_delete(array($this, 'before_delete')); $crud->callback_after_insert(array($this, 'insert_after')); $crud->callback_before_update(array($this, 'before_update')); //field Types if (!is_dir($path = 'assets/uploads/files/image_' . $this->id_femme)) { mkdir($path = 'assets/uploads/files/image_' . $this->id_femme); } $crud->set_field_upload('file_url', 'assets/uploads/files/image_' . $this->id_femme); $fields_type_uploads = array('type_uploads' => array('table_name' => 'sos_gen_type_uploads_parrent', 'title' => 'name_type_uploads_parrent', 'relate' => null), 'detailles' => array('table_name' => 'sos_gen_type_uploads_child', 'title' => 'name_type_uploads_child', 'id_field' => 'id_type_uploads_child', 'relate' => 'id_parrent_from_type_uploads_parrent', 'data-placeholder' => 'Precisé')); $config_type_uploads = array('main_table' => 'sos_upload', 'main_table_primary' => 'id_upload', "url" => base_url() . 'index.php/upload/upload_window/', 'segment_name' => "type_uploads"); $categories_type_uploads = new gc_dependent_select($crud, $fields_type_uploads, $config_type_uploads); $js_type_uploads = $categories_type_uploads->get_js(); // Actions $this->db->where('id_femme', $this->id_femme); $query = $this->db->get('sos_femme'); if ($query->num_rows == 1) { $row_femme = $query->row(); } // Renders $output = $crud->render(); $output->output .= $js_type_uploads; $menu = new stdClass(); $menu->n1 = true; $menu->status = $this->session->userdata('status'); $this->db->where('id_femme', $this->id_femme); $query = $this->db->get('sos_femme'); if ($query->num_rows == 1) { $row_femme = $query->row(); } $header = $this->navigation->home_f($menu) . ' ' . '<p><pre>' . $row_femme->prenom . ' ' . $row_femme->nom . ' ' . $row_femme->nom_marital . '</pre></p>'; $data = array('output' => $output, 'header' => $header); $this->_example_output($data); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function demarche_window($id) { $this->id_femme = $id; try { // General $crud = new grocery_CRUD(); $crud->set_language("french"); $crud->set_theme('bootstrap'); $crud->where('id_from_femme_demarche', $id); $crud->set_table('sos_demarche'); $crud->set_subject('Démarche'); //relations // $crud->set_relation('first', 'sos_gen_demarche_first', 'name_demarche_first'); $crud->set_relation('second', 'sos_gen_demarche_second', 'name_demarche_second'); $crud->set_relation('third', 'sos_gen_demarche_third', 'name_demarche_third'); $crud->set_relation_n_n('ordonnance_de_protection', 'sos_relation_ordonnance_de_protection', 'sos_gen_ordonnance_de_protection', 'id_from_demarche', 'id_from_ordonnance_de_protection', 'name_ordonnance_de_protection'); $crud->set_relation_n_n('suites_de_plainte', 'sos_relation_suites_de_plainte', 'sos_gen_suites_de_plainte', 'id_from_demarche', 'id_from_suites_de_plainte', 'name_suites_de_plainte', 'priority'); //Master/child relations // $fields_demarche = array('first' => array('table_name' => 'sos_gen_demarche_first', 'title' => 'name_demarche_first', 'relate' => null), 'second' => array('table_name' => 'sos_gen_demarche_second', 'title' => 'name_demarche_second', 'id_field' => 'id_demarche_second', 'relate' => 'id_from_demarche_first', 'data-placeholder' => 'Préciser'), 'third' => array('table_name' => 'sos_gen_demarche_third', 'title' => 'name_demarche_third', 'id_field' => 'id_demarche_third', 'relate' => 'id_from_demarche_second', 'data-placeholder' => 'Préciser')); // 'url' => base_url() . 'index.php/demarche/window_demarche/'. $this->id_femme.'/', $config_demarche = array('main_table' => 'sos_demarche', 'main_table_primary' => 'id_demarche', 'url' => base_url() . 'index.php/demarche/demarche_window/'); $categories_demarche = new gc_dependent_select($crud, $fields_demarche, $config_demarche); $js_demarche = $categories_demarche->get_js(); //Visual $crud->columns('date_entry', 'date_evenement', 'demarche', 'commentaire', 'upload', 'file_url', 'ordonnance_de_protection', 'suites_de_plainte'); $crud->display_as('upload', 'Type du Document'); $crud->display_as('file_url', 'Document'); $crud->display_as('date_evenement', 'Date évenement'); $crud->display_as('first', 'Type de démarche'); $crud->display_as('second', 'Type d\'intervention'); $crud->display_as('third', 'Suites'); $crud->display_as('date_entry', 'Date de saisie'); //unsets $crud->unset_fields('file_url', 'date_entry'); if (!$this->session->userdata('status')) { $crud->unset_export(); $crud->unset_print(); } //Requireds $crud->required_fields('first'); //Callbacks $crud->callback_before_update(array($this, 'before_update')); $crud->callback_after_update(array($this, 'insert_after_update')); $crud->callback_after_insert(array($this, 'insert_after_insert')); $crud->callback_column('demarche', array($this, 'demarche')); $crud->callback_column('commentaire', array($this, 'commentaire')); $crud->callback_column('ordonnance_de_protection', array($this, 'ordonnance_de_protection')); $crud->callback_column('suites_de_plainte', array($this, 'suites_de_plainte')); $crud->callback_column('date_entry', array($this, 'date_entry')); //field Types $crud->field_type('id_from_femme_demarche', 'hidden', $this->id_femme); $crud->field_type('id_user', 'hidden', $this->session->userdata('userid')); if (!is_dir($path = 'assets/uploads/files/image_' . $this->id_femme)) { mkdir($path = 'assets/uploads/files/image_' . $this->id_femme); } $crud->set_field_upload('file_url', 'assets/uploads/files/image_' . $this->id_femme); $this->db->where('id_from_femme', $this->id_femme); $results = $this->db->get('sos_upload')->result(); $upload_multiselect = array(); foreach ($results as $result) { $text_to_show = ""; $this->db->where('id_type_uploads_parrent', $result->type_uploads); $query_type_uploads = $this->db->get('sos_gen_type_uploads_parrent'); if ($query_type_uploads->num_rows == 1) { $row_type_uploads = $query_type_uploads->row(); $text_to_show .= $row_type_uploads->name_type_uploads_parrent; } $this->db->where('id_type_uploads_child', $result->detailles); $query_type_uploads_child = $this->db->get('sos_gen_type_uploads_child'); if ($query_type_uploads_child->num_rows == 1) { $row_type_uploads_child = $query_type_uploads_child->row(); $text_to_show .= '->' . $row_type_uploads_child->name_type_uploads_child; } $text_to_show .= ' le ' . $result->date_entry; $upload_multiselect[$result->id_upload] = $text_to_show; } if (count($upload_multiselect)) { $crud->field_type('upload', 'dropdown', $upload_multiselect); } else { $crud->field_type('upload', 'hidden', ''); } // Actions // Renders $output = $crud->render(); $output->output .= $js_demarche; $menu = new stdClass(); $menu->n1 = true; $menu->status = false; $menu->status = $this->session->userdata('status'); $this->db->where('id_femme', $this->id_femme); $query = $this->db->get('sos_femme'); if ($query->num_rows == 1) { $row_femme = $query->row(); } $header = $this->navigation->home_f($menu) . ' ' . '<p><pre>' . $row_femme->prenom . ' ' . $row_femme->nom . ' ' . $row_femme->nom_marital . '</pre></p>'; $data = array('output' => $output, 'header' => $header); $this->_example_output($data); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }