public function kids_window($id) { $this->id_femme = $id; try { $crud = new grocery_CRUD(); $crud->set_language("french"); $crud->set_theme('bootstrap'); $crud->where('id_femme', $id); $crud->set_table('sos_kids'); $crud->set_subject('Enfant(s)'); $crud->unset_edit_fields('id_kid'); $crud->unset_add_fields('id_kid'); $crud->field_type('id_femme', 'hidden', $this->id_femme); $crud->columns('prenom', 'nom', 'age', 'sex', 'commentaire'); $crud->display_as('prenom', 'Prénom'); $crud->display_as('sex', 'Sexe'); $crud->display_as('commentaire', 'Commentaires'); $crud->set_relation('age', 'sos_gen_kids_age', 'name_kids_age'); if (!$this->session->userdata('status')) { $crud->unset_export(); $crud->unset_print(); } $crud->callback_after_update(array($this, 'after_update')); $crud->callback_after_insert(array($this, 'insert_after')); $crud->field_type('sex', 'enum', array('Fille', 'Garçon')); $output = $crud->render(); $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 salacontrol() { try { $crud = new grocery_CRUD(); //$crud->set_theme('datatables'); $crud->set_table('salas'); $crud->set_subject('Sala'); $crud->required_fields('campus', 'numero', 'tipo', 'capacidade'); $crud->display_as('campus', 'Campus'); $crud->display_as('numero', 'Número da Sala'); $crud->display_as('cidadeID', 'Campus'); $crud->unset_columns('disponibilidade'); $crud->unset_add_fields('disponibilidade'); $crud->set_relation('campus', 'cidades', 'nome'); $crud->set_relation('tipo', 'tipos', 'nome'); //$crud->set_rules('numero', 'Número da Sala', 'Integer'); $crud->change_field_type('disponibilidade', 'true_false'); $output = $crud->render(); $this->_sala_output($output); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function cards() { $crud = new grocery_CRUD('default'); $crud->set_table('card'); $crud->set_subject('Card'); $crud->set_field_upload('iss_org_logo', 'assets/uploads'); $crud->unset_columns('created_date'); $crud->unset_add_fields('created_date'); $crud->unset_edit_fields('created_date'); $data = $crud->render(); $this->load->view('admin/crud_view', $data); }
function administracion($ID = NULL, $parent_table = NULL, $fieldID = NULL, $field_show = NULL) { if (!$this->tank_auth->is_logged_in()) { redirect('/auth/login/'); } try { /* Creamos el objeto */ $crud = new grocery_CRUD(); /* Seleccionamos el tema */ //$crud->set_theme('flexigrid'); $crud->set_theme('datatables'); /* Seleccionamos el nombre de la tabla de nuestra base de datos*/ $crud->set_table('product'); /* Le asignamos un nombre */ $crud->set_subject('Producto'); /* Asignamos el idioma español */ $crud->set_language('spanish'); /* ALA - 10/11/2015 : Condiciona invocación maestro detalle */ $state = $crud->getState(); //echo " ID = " . $ID . ", state = " . $state . ", parent_table = " . $parent_table . "FieldID = " . $fieldID; switch ($state) { case 'success': if (is_numeric($ID)) { //echo "success ID = " . $ID . ", state = " . $state; $crud->where($fieldID, $ID); } $crud->set_relation('PrClientID', 'client', 'Ident'); $crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}'); break; case 'list': if (is_numeric($ID)) { //echo "list ID = " . $ID . ", state = " . $state; $crud->where($fieldID, $ID); } $crud->set_relation('PrClientID', 'client', 'Ident'); $crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}'); break; case 'add': if ($parent_table == NULL) { $crud->set_relation('PrClientID', 'client', 'Ident'); $crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}'); } elseif ($parent_table == 'client') { $crud->field_type('PrClientID', 'hidden', $ID); $crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}'); } elseif ($parent_table == 'vendor') { $crud->field_type('PrVendorID', 'hidden', $ID); $crud->set_relation('PrClientID', 'client', 'Ident'); } //echo "add ID = " . $ID . ", state = " . $state; break; case "read": $crud->set_relation('PrClientID', 'client', 'Ident'); $crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}'); } $crud->set_relation('PrProductCatalogID', 'productcatalog', 'Description'); /* Aqui le decimos a grocery que estos campos son obligatorios */ $crud->required_fields('ProductID', 'PrProductCatalogID', 'Contract', 'PrClientID', 'PrVendorID', 'StartDate', 'EndDate', 'Balance'); /* Aqui le indicamos que campos deseamos mostrar */ $crud->columns('ProductID', 'PrProductCatalogID', 'Contract', 'PrClientID', 'PrVendorID', 'StartDate', 'EndDate', 'Balance'); $crud->display_as('ProductID', 'ID'); $crud->display_as('PrProductCatalogID', 'Producto'); $crud->display_as('Contract', 'Contrato'); $crud->display_as('PrClientID', 'Cliente'); $crud->display_as('PrVendorID', 'Vendedor'); $crud->display_as('StartDate', 'Fecha Inicio Vigencia'); $crud->display_as('EndDate', 'Fecha Fin Vigencia'); $crud->display_as('Balance', 'Saldo'); $crud->set_rules('EndDate', 'Fecha Vigencia', 'callback_ValidProd'); //http://www.grocerycrud.com/documentation/options_functions/set_rules $crud->unset_add_fields('Balance'); $crud->unset_edit_fields('Balance'); $crud->add_action('Beneficiarios', base_url() . 'assets/uploads/detalle.png', 'Beneficiary/administracion'); $crud->add_action('Movimientos', base_url() . 'assets/uploads/money.png', 'Charge/administracion'); // Procesos posteriores a la venta $crud->callback_after_insert(array($this, 'Process_Sale')); /* Generamos la tabla */ $output = $crud->render(); /* La cargamos en la vista situada en /applications/views/product/administracion.php */ $this->load->view('Product/administracion', $output); } catch (Exception $e) { /* Si algo sale mal cachamos el error y lo mostramos */ //log_message($e->getMessage().' --- '.$e->getTraceAsString()); show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
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()); } }
public function sub_Category() { $crud = new grocery_CRUD('default'); $crud->set_table('subcategories_master'); $crud->set_subject('SubCategory'); $crud->display_as('category', 'SubCategory')->display_as('category_id', 'Select Category'); $crud->unset_add_fields('flag', 'created_date'); $crud->unset_edit_fields('flag', 'created_date'); $crud->callback_before_insert(array($this, 'callback_getmax_app_cat_id')); $crud->unset_columns('applicable_category_id', 'flag', 'created_date'); $crud->set_relation('category_id', 'categories_master', 'category'); $crud->field_type('applicable_category_id', 'invisible'); //$crud->unset_add(); //$crud->unset_edit(); //$crud->unset_delete(); $data = $crud->render(); $this->load->view('admin/crud_view', $data); }
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 peserta_kkn_management_all() { $session = isset($_SESSION['username_belajar']) ? $_SESSION['username_belajar'] : ''; if ($session != "") { $pecah = explode("|", $session); $data["NIM"] = $pecah[0]; $data["NAMA"] = $pecah[1]; $data["STATUS"] = $pecah[3]; if ($data["STATUS"] == "Admin") { try { /* This is only for the autocompletion */ $crud = new grocery_CRUD(); $crud->set_theme('datatables'); //$crud->where('SUDAH','2'); $crud->set_table('KKN_MHS'); $crud->set_language("indonesian"); $crud->display_as('NIM', 'Data Pribadi'); $crud->set_relation('NIM', 'D_MAHASISWA', 'Nim :{NIM}, Angkatan :{ANGKATAN},Nama :{NAMA},Jk: {J_KELAMIN},Asal: {ALAMAT_MHS}, Golongan Darah: {GOL_DARAH},HP Mhs: {HP_MHS},Telp Keluarga: {TELP_MHS}'); $crud->display_as('FAK', 'Fakultas')->display_as('NO', 'No Pendaftaran')->display_as('ALAMAT_JOGJA', 'Alamat di Jogja')->display_as('NM_KEC_JOGJA', 'Kec di Jogja')->display_as('NM_KAB_JOGJA', 'Kab di Jogja')->display_as('PRESTASI', 'Keahlian')->display_as('RT_JOGJA', 'RT di Jogja')->display_as('DESA_JOGJA', 'Desa di Jogja')->display_as('KODE_POS_JOGJA', 'Kod Pos di Jogja')->display_as('TRANSPORTASI', 'Transportasi')->display_as('PATH_SK_DOKTER', 'Upload SK Dokter')->display_as('PATH_SK_GOLONGAN_DARAH', 'Upload SK Gol Darah')->display_as('PATH_SK_CUTI', 'Upload SK Cuti Kerja')->display_as('PATH_SK_TIDAK_HAMIL', 'Upload SK Tidak Hamil'); $crud->unset_edit(); $crud->unset_delete(); $crud->unset_edit_fields('SUDAH'); $crud->unset_add(); $crud->unset_add_fields('NO', 'SUDAH'); $crud->set_subject('Peserta KKN'); $crud->required_fields('ALAMAT_JOGJA'); $crud->columns('NIM', 'FAK', 'ALAMAT_JOGJA', 'PRESTASI', 'NM_KEC_JOGJA', 'NM_KAB_JOGJA'); $crud->set_field_upload('PATH_SK_DOKTER', 'assets/kesehatan'); $crud->set_field_upload('PATH_SK_GOLONGAN_DARAH', 'assets/goldarah'); $crud->set_field_upload('PATH_SK_CUTI', 'assets/cutikerja'); $crud->set_field_upload('PATH_SK_TIDAK_HAMIL', 'assets/tidakhamil'); //$crud->edit_fields('NIM','KD_FAK','ALAMAT_JOGJA','PRESTASI','KD_KEC','KD_KAB'); $crud->callback_edit_field('NIM', array($this, 'edit_field_callback_nim')); $crud->callback_edit_field('NO', array($this, 'edit_field_callback_no')); $output = $crud->render(); $this->_manage_output($output); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } } else { ?> <script type="text/javascript" language="javascript"> alert("Anda tidak berhak masuk ke Control Panel Admin...!!!"); </script> <?php echo "<meta http-equiv='refresh' content='0; url=" . base_url() . "kkn'>"; } } else { ?> <script type="text/javascript" language="javascript"> alert("Anda belum Log In...!!!\nAnda harus Log In untuk mengakses halaman ini...!!!"); </script> <?php echo "<meta http-equiv='refresh' content='0; url=" . base_url() . "kkn'>"; } }
public function paragraph() { if (!is_super_user()) { redirect(site_url('admin/help')); } $this->load->config('grocery_crud'); $this->config->set_item('grocery_crud_text_editor_type', 'minimal'); $crud = new grocery_CRUD(); $crud->set_theme('bootstrap'); $crud->set_table('help_paragraph'); $crud->set_subject("Documentatie alinea's"); $crud->unset_add_fields('date_modified'); $crud->unset_edit_fields('page_id', 'date_modified'); $crud->field_type('date_created', 'invisible'); $crud->field_type('user_id', 'invisible'); $crud->field_type('order', 'hidden'); $crud->callback_add_field('page_id', array($this, 'paragraph_callback_add_field_page_id')); $crud->callback_before_insert(array($this, 'paragraph_callback_before_insert')); $crud->callback_before_update(array($this, 'paragraph_callback_before_update')); $crud->callback_after_insert(array($this, 'save_to_sql')); $crud->callback_after_update(array($this, 'save_to_sql')); $crud->callback_after_delete(array($this, 'save_to_sql')); $crud->required_fields('key', 'title', 'content', 'is_visible'); // render the crud HTML $crud_output = $crud->render(); if ($crud->getState() == 'list') { redirect(site_url('admin/help')); } else { if ($crud->getState() == 'success') { $this->session->set_flashdata('form_submit', 'success'); $this->session->set_flashdata('form_message', 'Alinea met succes opgeslagen.'); $state = $crud->getStateInfo(); $this->load->model('admin/help_model'); $paragraph = $this->help_model->get_paragraph($state->primary_key, 'off'); redirect(site_url('admin/help/index/' . $paragraph['page_id'] . '#' . $paragraph['key'])); } } $this->javascript_files = $crud->get_js_files(); $this->css_files = $crud->get_css_files(); $this->views['content'] = $crud_output->output; $this->_layout(); }