Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php if (!isset($html)) { header("HTTP/1.0 404 Not Found"); exit;}
- $form_params = $arr_catalog_institutes_origin = $arr_catalog_lead_origin = $arr_rg_tem = [];
- $html_content = $offer_id = $alert_action_message = NULL;
- //cambio
- // Prefixes
- $tbl_prefix_re_catalog_institute_origin = 're_catalog_institute_origin';
- $tbl_prefix_re_catalog_origin = 're_catalog_origin';
- $tbl_prefix_c_rg_termtype = 'catalog_rg_termtype';
- $tbl_prefix_rg_term = 'rg_term';
- $tbl_prefix_re_lead = 're_lead';
- $tbl_prefix_re_offer = 're_offer';
- $tbl_prefix_gc_catalog_campus = 'gc_catalog_campus';
- // Fields
- $re_lead_id = $tbl_prefix_re_lead.'_lead_id';
- $re_lead_first_name = $tbl_prefix_re_lead.'_first_name';
- $re_lead_middle_name = $tbl_prefix_re_lead.'_middle_name';
- $re_lead_last_name_p = $tbl_prefix_re_lead.'_last_name_p';
- $re_lead_last_name_m = $tbl_prefix_re_lead.'_last_name_m';
- $re_lead_birthdate = $tbl_prefix_re_lead.'_birthdate';
- $re_lead_gender = $tbl_prefix_re_lead.'_gender';
- $re_lead_email = $tbl_prefix_re_lead.'_email';
- $re_lead_mobile = $tbl_prefix_re_lead.'_mobile';
- $re_lead_telephone = $tbl_prefix_re_lead.'_phone';
- $re_lead_telephone_ext = $tbl_prefix_re_lead.'_phone_ext';
- $re_lead_hidden_action_name = $tbl_prefix_re_lead.'_action_name';
- $re_lead_hidden_table_name = $tbl_prefix_re_lead.'_table_name';
- // Fk fields
- $catalog_institute_origin_id = $tbl_prefix_re_lead.'_catalog_institute_origin_id';
- $catalog_origin_id = $tbl_prefix_re_catalog_origin.'_catalog_origin_id';
- $re_lead_term_id = $tbl_prefix_re_lead.'_term_id';
- $re_offer_id = $tbl_prefix_re_offer.'_offer_id';
- $gc_catalog_campus_id = $tbl_prefix_gc_catalog_campus.'_id';
- if (isset($_POST['acc'])) {
- if (!($query_info = get_query_info_from_post($_POST, 'Retrive query type as message, please'))) {
- $html_alert = html_alert($alert_message, $alert_type);
- }
- if (!isset($query_info['action_name']) || !isset($query_info['table_name'])) {
- $html_alert = html_alert($alert_message, $alert_type);
- }
- $action_name = $query_info['action_name'];
- $table_name = $query_info['table_name'];
- if ($_POST['acc'] == 'modal1') {
- $user_ip = $_SERVER['REMOTE_ADDR'] ?: NULL;
- $user_argent = $_SERVER['HTTP_USER_AGENT'] ?: NULL;
- $form_params['catalog_institute_origin_id'] = post($catalog_institute_origin_id);
- $form_params['catalog_origin_id'] = post($catalog_origin_id);
- $form_params['term_id'] = post($re_lead_term_id);
- $form_params['offer_id'] = post($re_offer_id);
- $birthdate = post($re_lead_birthdate);
- $formated_birthdate = custom_format_date($birthdate);
- $form_params['birthdate'] = $formated_birthdate;
- $form_params['gender'] = post($re_lead_gender);
- $form_params['first_name'] = post($re_lead_first_name);
- $form_params['middle_name'] = post($re_lead_middle_name);
- $form_params['lastname_p'] = post($re_lead_last_name_p);
- $form_params['lastname_m'] = post($re_lead_last_name_m);
- $form_params['email'] = post($re_lead_email);
- $form_params['mobile'] = strtolower(post($re_lead_mobile));
- $form_params['telephone'] = post($re_lead_telephone);
- $form_params['telephone_ext'] = post($re_lead_telephone_ext);
- $form_params['user_agent'] = $user_argent;
- $form_params['ip'] = $user_ip;
- }
- if (isset($form_params) && !empty($form_params)) {
- if (($offer_id = $form_params['offer_id'])) {
- unset($form_params['offer_id']);
- }
- unset($form_params[$re_lead_hidden_table_name]);
- unset($form_params[$re_lead_hidden_action_name]);
- try {
- $alert_action_message = "Lo sentimos ocurrió un Error al intentar {$query_info['type']} el registro, por favor intentélo de nuevo.";
- $alert_type = 'danger';
- if (!($response = $action_name($table_name, $form_params))) {
- $alert_action_message = html_alert($alert_message, 'danger');
- }
- if (!isset($response['response']['insert']) || empty($response['response']['insert'])) {
- $alert_action_message = html_alert($alert_message, $alert_type);
- } else if (isset($offer_id) && isset($response['response']['id_insert'])) {
- $lead_id = $response['response']['id_insert'];
- $response = $action_name('re_lead_offer', [
- 'offer_id' => $offer_id,
- 'lead_id' => $lead_id,
- ]);
- if (!isset($response['response']['insert']) || empty($response['response']['insert'])) {
- $alert_action_message = html_alert($alert_message, $alert_type);
- } else {
- // Success
- $alert_action_message = html_alert("Registro {$query_info['type']} correctamente", 'success');
- }
- }
- } catch(Exception $e) {}
- }
- }
- // SQL TO DO put the code below within app_sql file
- $catalog_institutes_origin = crud('select', 're_catalog_institute_origin', [
- 'rows' => ['*']
- ]);
- $catalog_lead_origin = crud('select', 're_catalog_origin', [
- 'rows' => ['*']
- ]);
- $rg_term = crud('select', 'rg_term', [
- 'rows' => ['*']
- ]);
- $re_offer = crud('select', 're_offer', [
- 'rows' => ['*']
- ]);
- $re_lead = crud('select', 're_lead', [
- 'rows' => ['*']
- ]);
- $gc_catalog_campus = crud('select', 'gc_catalog_campus', [
- 'rows' => ['*']
- ]);
- // // Search
- // $rg_catalog_termtype = crud('select', 'rg_catalog_termtype', [
- // 'rows' => ['term_code_id', 'term_type_id', 'academic_year' 'name']
- // ]);
- // ENDs SQL
- // Records
- $arr_catalog_institutes_origin['records'] = map_select($catalog_institutes_origin, 'catalog_institute_origin_id', 'name');
- $arr_catalog_lead_origin['records'] = map_select($catalog_lead_origin, 'catalog_origin_id', 'name');
- $arr_rg_term['records'] = map_select($rg_term, 'term_code_id', 'name');
- $arr_re_offer['records'] = map_select($re_offer, 'offer_id', 'name');
- $arr_re_lead['records'] = map_select($re_lead, 'lead_id', 'first_name');
- $arr_gc_catalog_campus['records'] = map_select($gc_catalog_campus, 'campus_id', 'name');
- // PlaceHolders
- $arr_catalog_institutes_origin['placeholder'] = get_select_placeholder_from_qry_resuls($arr_catalog_institutes_origin);
- $arr_catalog_lead_origin['placeholder'] = get_select_placeholder_from_qry_resuls($arr_catalog_lead_origin);
- $arr_rg_term['placeholder'] = get_select_placeholder_from_qry_resuls($arr_rg_term);
- $arr_re_offer['placeholder'] = get_select_placeholder_from_qry_resuls($arr_re_offer);
- $arr_re_lead['placeholder'] = get_select_placeholder_from_qry_resuls($arr_re_lead);
- $arr_gc_catalog_campus['placeholder'] = get_select_placeholder_from_qry_resuls($arr_gc_catalog_campus);
- // HTML Components
- $select_institute_origin = html_select(
- $catalog_institute_origin_id,
- NULL,
- $arr_catalog_institutes_origin['records'],
- $arr_catalog_institutes_origin['placeholder'],
- ''
- );
- $select_lead_origin = html_select(
- $catalog_origin_id,
- NULL,
- $arr_catalog_lead_origin['records'],
- $arr_catalog_lead_origin['placeholder'],
- ''
- );
- $select_rg_term = html_select(
- $re_lead_term_id,
- NULL,
- $arr_rg_term['records'],
- $arr_rg_term['placeholder'],
- ''
- );
- $select_re_offer = html_select(
- $re_offer_id,
- NULL,
- $arr_re_offer['records'],
- $arr_re_offer['placeholder'],
- ''
- );
- $select_lead_gender = html_select(
- $re_lead_gender,
- NULL,
- ['f' => 'Femenino', 'm' => 'Masculino'],
- 'Seleccione'
- );
- $select_lead = html_select(
- $re_lead_id,
- NULL,
- $arr_re_lead['records'],
- $arr_re_lead['placeholder']
- );
- $select_campus = html_select(
- $gc_catalog_campus_id,
- NULL,
- $arr_gc_catalog_campus['records'],
- $arr_gc_catalog_campus['placeholder']
- );
- $heading_lead_g_info = html_h('3', 'Información del Prospecto:');
- $heading_lead_c_info = html_h('2', 'Información de Contacto:');
- $input_lead_first_name = html_input("$re_lead_first_name", 'text', NULL, 'Primer nombre', '');
- $input_lead_middle_name = html_input($re_lead_middle_name, 'text', NULL, 'Segundo nombre', '');
- $input_lead_last_name_p = html_input($re_lead_last_name_p, 'text', NULL, 'Apellido paterno', '');
- $input_lead_last_name_m = html_input($re_lead_last_name_m, 'text', NULL, 'Apellido materno', '');
- $input_birthdate = html_input($re_lead_birthdate, 'text', NULL, 'Fecha de nacimiento', '', '', 'birthdate datepicker_max');
- $input_lead_email = html_input($re_lead_email, 'text', NULL, 'email', '');
- $input_lead_mobile = html_input($re_lead_mobile, 'number', NULL, 'celular', '');
- $input_lead_phone = html_input($re_lead_telephone, 'number', NULL, 'teléfono', '');
- $input_lead_phone_extension = html_input($re_lead_telephone_ext, 'number', NULL, 'extensión', '');
- $input_lead_hidden_action = html_input($re_lead_hidden_action_name , 'hidden', $GLOBALS['form_actions']['create_record']);
- $input_lead_hidden_tbl_name = html_input($re_lead_hidden_table_name , 'hidden', $GLOBALS['sigem_tables'][$re_lead_hidden_table_name]);
- //--------------------- MODAL ADD LEAD
- $html_modal_lead = html_h(2, 'Crear prospecto', 'left');
- $html_modal_lead .= html_row(array(
- '12a' => html_h(3, 'Información del Prospecto:'),
- '12m' => html_h(3, 'Instituto de Procedencia'),
- '12b' => $select_institute_origin,
- '12c' => html_h(3, '¿Cómo se enteró de nuestros Colegios?'),
- '12d' => $select_lead_origin,
- '12e' => html_h(3, 'Período'),
- '12f' => $select_rg_term,
- '12g' => html_h(3, 'Oferta académica'),
- '12h' => $select_re_offer,
- '12i' => html_h(3, 'Primer nombre'),
- '12j' => $input_lead_first_name,
- '12k' => html_h(3, 'Segundo nombre (opcional)'),
- '12l' => $input_lead_middle_name,
- '12o' => html_h(3, 'Apellido paterno'),
- '12p' => $input_lead_last_name_p,
- '12q' => html_h(3, 'Apellido materno'),
- '12r' => $input_lead_last_name_m,
- '12s' => html_h(3, 'Fecha de nacimiento'),
- '12t' => $input_birthdate,
- '12u' => html_h(3, 'Género'),
- '12v' => $select_lead_gender,
- '12w' => html_h(3, 'Información de Contacto'),
- '12y' => html_h(3, 'Email'),
- '12z' => $input_lead_email,
- '12aa' => html_h(3, 'Celular'),
- '12ab' => $input_lead_mobile,
- '3ac' => html_h(3, 'Extensión (opcional)'),'9ae' => html_h(3, 'Teléfono (opcional)'),
- '3ad' => $input_lead_phone_extension,'9af' => $input_lead_phone,
- '12ah' => $input_lead_hidden_action,
- '12aj' => $input_lead_hidden_tbl_name,
- '6am' => '',
- '3an' => html_button('Cancelar', 'danger', 'times', 'modal_close'),
- '3añ' => html_button('Guardar', 'success', 'save', 'modal1')
- ));
- $btn_add_lead = html_modal('', 'info', 'plus-circle', 'add_lead', html_form($html_modal_lead));
- $btn_save = html_button('Guardar', 'success', null, 'form1');
- $btn_cancel = html_button('Cancelar', 'danger', 'times', 'modal_close', 'cancel-save-lead');
- $html = $alert_action_message;
- $html .= $html_content;
- $html .= html_h(5, html_bold('Buscar prospecto'), 'left');
- $array_table = $array_td = array();
- $array_td[] = array(array('Institución', 30, 'left'), $select_campus, array('', 5, 'center'));
- $array_td[] = array(array('Prospecto', 30, 'left'), $select_lead, array($btn_add_lead, 5, 'center'));
- $array_td[] = array(array('Período', 30, 'left'), $select_rg_term, array('', 5, 'center'));
- if(!empty($select_campus) || !empty($select_lead) || !empty($select_rg_term)){
- $array_td[] = array('', html_button('Buscar', 'brand', 'search', 'form2'));
- }
- $array_table['td'] = $array_td;
- $html .= html_form(html_table($array_table, FALSE,FALSE,TRUE));
- //BUSCADOR
- if($acc == 'form2'){
- //REALIZAR CONSULTA
- $arr_search = array();
- if(is_numeric($re_lead_id))$arr_search['lead_id'] = $re_lead_id;
- //if(is_numeric($program_level_id))$arr_search['term_id'] = $program_level_id;
- //if(is_numeric($campus_id))$arr_search['campus_id'] = $campus_id;
- if(!empty($arr_search))$re_lead = map(crud('select', 're_lead', array('where' => $arr_search)));
- //ia($re_lead);
- //MOSTRAR RESULTADOS
- $html .= html_br().html_h(5, 'Resultados de búsqueda');
- if(empty($re_lead))$html .= html_alert('Sin resultados bajo la búsqueda', 'danger');
- else{
- $array_table = array('th' => array(array('No.', 'Prospecto', 'Período', 'Oferta académica','Estatus','Email','Telefono', '')));
- $array_td = array();
- $btn_delete = html_button('', 'danger', 'times', 'confirm_tr1');
- $no = 1;
- $res_name = $re_lead['response']['select']['0']['first_name'];
- // ia($res_name);
- $leads_info = [];
- if (isset($response['response']['select'])) {
- foreach ($response['response']['select'] as $record) {
- foreach ($record as $index => $data) {
- ia($index);
- //ia($record);
- $leads_info[$index]['first_name'] = $data['first_name'];
- }
- }
- }
- foreach($re_lead as $k => $arr){
- //ia($arr);
- $v_lead_id = key_val('lead_id', $arr);
- $v_first_name = key_val('first_name', $arr);
- $v_middle_name = key_val('middle_name', $arr);
- $v_lastname_p = key_val('lastname_p', $arr);
- $v_lastname_m = key_val('lastname_m', $arr);
- $array_td[] = array(
- array($no, 5, 'center'),
- // $leads_info[$index]['first_name'],
- key_val('',''),
- key_val('', ''),
- key_val('', ''),
- key_val('email', $arr),
- key_val('telephone', $arr),
- //key_val($v_program_level_id, $arr_select_ac_catalog_program_level),
- array(html_input('u_program_id', 'hidden', $v_lead_id).$btn_delete, 5, 'center'),
- );
- ++$no;
- }
- $array_table['td'] = $array_td;
- $html .= html_table($array_table, FALSE);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement