API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2019
76
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.24 KB | None | 0 0
raw download clone embed print report
  1. <?php if (!isset($html)) { header("HTTP/1.0 404 Not Found"); exit;}
  2.  
  3. $form_params = $arr_catalog_institutes_origin = $arr_catalog_lead_origin = $arr_rg_tem = [];
  4. $html_content = $offer_id = $alert_action_message = NULL;
  5. //cambio
  6. // Prefixes
  7. $tbl_prefix_re_catalog_institute_origin = 're_catalog_institute_origin';
  8. $tbl_prefix_re_catalog_origin = 're_catalog_origin';
  9. $tbl_prefix_c_rg_termtype = 'catalog_rg_termtype';
  10. $tbl_prefix_rg_term = 'rg_term';
  11. $tbl_prefix_re_lead = 're_lead';
  12. $tbl_prefix_re_offer = 're_offer';
  13. $tbl_prefix_gc_catalog_campus = 'gc_catalog_campus';
  14.  
  15. // Fields
  16. $re_lead_id = $tbl_prefix_re_lead.'_lead_id';
  17. $re_lead_first_name = $tbl_prefix_re_lead.'_first_name';
  18. $re_lead_middle_name = $tbl_prefix_re_lead.'_middle_name';
  19. $re_lead_last_name_p = $tbl_prefix_re_lead.'_last_name_p';
  20. $re_lead_last_name_m = $tbl_prefix_re_lead.'_last_name_m';
  21. $re_lead_birthdate = $tbl_prefix_re_lead.'_birthdate';
  22. $re_lead_gender = $tbl_prefix_re_lead.'_gender';
  23. $re_lead_email = $tbl_prefix_re_lead.'_email';
  24. $re_lead_mobile = $tbl_prefix_re_lead.'_mobile';
  25. $re_lead_telephone = $tbl_prefix_re_lead.'_phone';
  26. $re_lead_telephone_ext = $tbl_prefix_re_lead.'_phone_ext';
  27.  
  28.  
  29. $re_lead_hidden_action_name = $tbl_prefix_re_lead.'_action_name';
  30. $re_lead_hidden_table_name = $tbl_prefix_re_lead.'_table_name';
  31.  
  32.  
  33. // Fk fields
  34. $catalog_institute_origin_id = $tbl_prefix_re_lead.'_catalog_institute_origin_id';
  35. $catalog_origin_id = $tbl_prefix_re_catalog_origin.'_catalog_origin_id';
  36. $re_lead_term_id = $tbl_prefix_re_lead.'_term_id';
  37.  
  38. $re_offer_id = $tbl_prefix_re_offer.'_offer_id';
  39. $gc_catalog_campus_id = $tbl_prefix_gc_catalog_campus.'_id';
  40.  
  41. if (isset($_POST['acc'])) {
  42.  
  43.  
  44. if (!($query_info = get_query_info_from_post($_POST, 'Retrive query type as message, please'))) {
  45. $html_alert = html_alert($alert_message, $alert_type);
  46. }
  47.  
  48. if (!isset($query_info['action_name']) || !isset($query_info['table_name'])) {
  49. $html_alert = html_alert($alert_message, $alert_type);
  50. }
  51.  
  52. $action_name = $query_info['action_name'];
  53. $table_name = $query_info['table_name'];
  54.  
  55. if ($_POST['acc'] == 'modal1') {
  56. $user_ip = $_SERVER['REMOTE_ADDR'] ?: NULL;
  57. $user_argent = $_SERVER['HTTP_USER_AGENT'] ?: NULL;
  58.  
  59. $form_params['catalog_institute_origin_id'] = post($catalog_institute_origin_id);
  60. $form_params['catalog_origin_id'] = post($catalog_origin_id);
  61. $form_params['term_id'] = post($re_lead_term_id);
  62. $form_params['offer_id'] = post($re_offer_id);
  63. $birthdate = post($re_lead_birthdate);
  64. $formated_birthdate = custom_format_date($birthdate);
  65. $form_params['birthdate'] = $formated_birthdate;
  66. $form_params['gender'] = post($re_lead_gender);
  67. $form_params['first_name'] = post($re_lead_first_name);
  68. $form_params['middle_name'] = post($re_lead_middle_name);
  69. $form_params['lastname_p'] = post($re_lead_last_name_p);
  70. $form_params['lastname_m'] = post($re_lead_last_name_m);
  71. $form_params['email'] = post($re_lead_email);
  72. $form_params['mobile'] = strtolower(post($re_lead_mobile));
  73. $form_params['telephone'] = post($re_lead_telephone);
  74. $form_params['telephone_ext'] = post($re_lead_telephone_ext);
  75. $form_params['user_agent'] = $user_argent;
  76. $form_params['ip'] = $user_ip;
  77.  
  78. }
  79.  
  80. if (isset($form_params) && !empty($form_params)) {
  81.  
  82. if (($offer_id = $form_params['offer_id'])) {
  83.  
  84. unset($form_params['offer_id']);
  85. }
  86.  
  87. unset($form_params[$re_lead_hidden_table_name]);
  88. unset($form_params[$re_lead_hidden_action_name]);
  89.  
  90. try {
  91. $alert_action_message = "Lo sentimos ocurrió un Error al intentar {$query_info['type']} el registro, por favor intentélo de nuevo.";
  92. $alert_type = 'danger';
  93.  
  94.  
  95. if (!($response = $action_name($table_name, $form_params))) {
  96. $alert_action_message = html_alert($alert_message, 'danger');
  97. }
  98.  
  99. if (!isset($response['response']['insert']) || empty($response['response']['insert'])) {
  100. $alert_action_message = html_alert($alert_message, $alert_type);
  101.  
  102. } else if (isset($offer_id) && isset($response['response']['id_insert'])) {
  103.  
  104. $lead_id = $response['response']['id_insert'];
  105. $response = $action_name('re_lead_offer', [
  106. 'offer_id' => $offer_id,
  107. 'lead_id' => $lead_id,
  108. ]);
  109.  
  110. if (!isset($response['response']['insert']) || empty($response['response']['insert'])) {
  111. $alert_action_message = html_alert($alert_message, $alert_type);
  112.  
  113. } else {
  114. // Success
  115. $alert_action_message = html_alert("Registro {$query_info['type']} correctamente", 'success');
  116. }
  117. }
  118.  
  119. } catch(Exception $e) {}
  120. }
  121. }
  122.  
  123. // SQL TO DO put the code below within app_sql file
  124. $catalog_institutes_origin = crud('select', 're_catalog_institute_origin', [
  125. 'rows' => ['*']
  126. ]);
  127.  
  128. $catalog_lead_origin = crud('select', 're_catalog_origin', [
  129. 'rows' => ['*']
  130. ]);
  131.  
  132. $rg_term = crud('select', 'rg_term', [
  133. 'rows' => ['*']
  134. ]);
  135.  
  136. $re_offer = crud('select', 're_offer', [
  137. 'rows' => ['*']
  138. ]);
  139.  
  140. $re_lead = crud('select', 're_lead', [
  141. 'rows' => ['*']
  142. ]);
  143.  
  144. $gc_catalog_campus = crud('select', 'gc_catalog_campus', [
  145. 'rows' => ['*']
  146. ]);
  147.  
  148.  
  149. // // Search
  150. // $rg_catalog_termtype = crud('select', 'rg_catalog_termtype', [
  151. // 'rows' => ['term_code_id', 'term_type_id', 'academic_year' 'name']
  152. // ]);
  153.  
  154.  
  155.  
  156. // ENDs SQL
  157.  
  158. // Records
  159. $arr_catalog_institutes_origin['records'] = map_select($catalog_institutes_origin, 'catalog_institute_origin_id', 'name');
  160. $arr_catalog_lead_origin['records'] = map_select($catalog_lead_origin, 'catalog_origin_id', 'name');
  161. $arr_rg_term['records'] = map_select($rg_term, 'term_code_id', 'name');
  162. $arr_re_offer['records'] = map_select($re_offer, 'offer_id', 'name');
  163. $arr_re_lead['records'] = map_select($re_lead, 'lead_id', 'first_name');
  164. $arr_gc_catalog_campus['records'] = map_select($gc_catalog_campus, 'campus_id', 'name');
  165.  
  166. // PlaceHolders
  167. $arr_catalog_institutes_origin['placeholder'] = get_select_placeholder_from_qry_resuls($arr_catalog_institutes_origin);
  168. $arr_catalog_lead_origin['placeholder'] = get_select_placeholder_from_qry_resuls($arr_catalog_lead_origin);
  169. $arr_rg_term['placeholder'] = get_select_placeholder_from_qry_resuls($arr_rg_term);
  170. $arr_re_offer['placeholder'] = get_select_placeholder_from_qry_resuls($arr_re_offer);
  171. $arr_re_lead['placeholder'] = get_select_placeholder_from_qry_resuls($arr_re_lead);
  172. $arr_gc_catalog_campus['placeholder'] = get_select_placeholder_from_qry_resuls($arr_gc_catalog_campus);
  173.  
  174.  
  175. // HTML Components
  176. $select_institute_origin = html_select(
  177. $catalog_institute_origin_id,
  178. NULL,
  179. $arr_catalog_institutes_origin['records'],
  180. $arr_catalog_institutes_origin['placeholder'],
  181. ''
  182. );
  183.  
  184. $select_lead_origin = html_select(
  185. $catalog_origin_id,
  186. NULL,
  187. $arr_catalog_lead_origin['records'],
  188. $arr_catalog_lead_origin['placeholder'],
  189. ''
  190. );
  191.  
  192. $select_rg_term = html_select(
  193. $re_lead_term_id,
  194. NULL,
  195. $arr_rg_term['records'],
  196. $arr_rg_term['placeholder'],
  197. ''
  198. );
  199.  
  200. $select_re_offer = html_select(
  201. $re_offer_id,
  202. NULL,
  203. $arr_re_offer['records'],
  204. $arr_re_offer['placeholder'],
  205. ''
  206. );
  207.  
  208. $select_lead_gender = html_select(
  209. $re_lead_gender,
  210. NULL,
  211. ['f' => 'Femenino', 'm' => 'Masculino'],
  212. 'Seleccione'
  213. );
  214.  
  215. $select_lead = html_select(
  216. $re_lead_id,
  217. NULL,
  218. $arr_re_lead['records'],
  219. $arr_re_lead['placeholder']
  220. );
  221.  
  222. $select_campus = html_select(
  223. $gc_catalog_campus_id,
  224. NULL,
  225. $arr_gc_catalog_campus['records'],
  226. $arr_gc_catalog_campus['placeholder']
  227.  
  228. );
  229.  
  230. $heading_lead_g_info = html_h('3', 'Información del Prospecto:');
  231. $heading_lead_c_info = html_h('2', 'Información de Contacto:');
  232. $input_lead_first_name = html_input("$re_lead_first_name", 'text', NULL, 'Primer nombre', '');
  233. $input_lead_middle_name = html_input($re_lead_middle_name, 'text', NULL, 'Segundo nombre', '');
  234. $input_lead_last_name_p = html_input($re_lead_last_name_p, 'text', NULL, 'Apellido paterno', '');
  235. $input_lead_last_name_m = html_input($re_lead_last_name_m, 'text', NULL, 'Apellido materno', '');
  236. $input_birthdate = html_input($re_lead_birthdate, 'text', NULL, 'Fecha de nacimiento', '', '', 'birthdate datepicker_max');
  237. $input_lead_email = html_input($re_lead_email, 'text', NULL, 'email', '');
  238. $input_lead_mobile = html_input($re_lead_mobile, 'number', NULL, 'celular', '');
  239. $input_lead_phone = html_input($re_lead_telephone, 'number', NULL, 'teléfono', '');
  240. $input_lead_phone_extension = html_input($re_lead_telephone_ext, 'number', NULL, 'extensión', '');
  241. $input_lead_hidden_action = html_input($re_lead_hidden_action_name , 'hidden', $GLOBALS['form_actions']['create_record']);
  242. $input_lead_hidden_tbl_name = html_input($re_lead_hidden_table_name , 'hidden', $GLOBALS['sigem_tables'][$re_lead_hidden_table_name]);
  243. //--------------------- MODAL ADD LEAD
  244. $html_modal_lead = html_h(2, 'Crear prospecto', 'left');
  245. $html_modal_lead .= html_row(array(
  246. '12a' => html_h(3, 'Información del Prospecto:'),
  247. '12m' => html_h(3, 'Instituto de Procedencia'),
  248. '12b' => $select_institute_origin,
  249. '12c' => html_h(3, '¿Cómo se enteró de nuestros Colegios?'),
  250. '12d' => $select_lead_origin,
  251. '12e' => html_h(3, 'Período'),
  252. '12f' => $select_rg_term,
  253. '12g' => html_h(3, 'Oferta académica'),
  254. '12h' => $select_re_offer,
  255. '12i' => html_h(3, 'Primer nombre'),
  256. '12j' => $input_lead_first_name,
  257. '12k' => html_h(3, 'Segundo nombre (opcional)'),
  258. '12l' => $input_lead_middle_name,
  259. '12o' => html_h(3, 'Apellido paterno'),
  260. '12p' => $input_lead_last_name_p,
  261. '12q' => html_h(3, 'Apellido materno'),
  262. '12r' => $input_lead_last_name_m,
  263. '12s' => html_h(3, 'Fecha de nacimiento'),
  264. '12t' => $input_birthdate,
  265. '12u' => html_h(3, 'Género'),
  266. '12v' => $select_lead_gender,
  267. '12w' => html_h(3, 'Información de Contacto'),
  268. '12y' => html_h(3, 'Email'),
  269. '12z' => $input_lead_email,
  270. '12aa' => html_h(3, 'Celular'),
  271. '12ab' => $input_lead_mobile,
  272. '3ac' => html_h(3, 'Extensión (opcional)'),'9ae' => html_h(3, 'Teléfono (opcional)'),
  273. '3ad' => $input_lead_phone_extension,'9af' => $input_lead_phone,
  274. '12ah' => $input_lead_hidden_action,
  275. '12aj' => $input_lead_hidden_tbl_name,
  276. '6am' => '',
  277. '3an' => html_button('Cancelar', 'danger', 'times', 'modal_close'),
  278. '3añ' => html_button('Guardar', 'success', 'save', 'modal1')
  279. ));
  280. $btn_add_lead = html_modal('', 'info', 'plus-circle', 'add_lead', html_form($html_modal_lead));
  281.  
  282. $btn_save = html_button('Guardar', 'success', null, 'form1');
  283. $btn_cancel = html_button('Cancelar', 'danger', 'times', 'modal_close', 'cancel-save-lead');
  284.  
  285. $html = $alert_action_message;
  286. $html .= $html_content;
  287.  
  288. $html .= html_h(5, html_bold('Buscar prospecto'), 'left');
  289. $array_table = $array_td = array();
  290. $array_td[] = array(array('Institución', 30, 'left'), $select_campus, array('', 5, 'center'));
  291. $array_td[] = array(array('Prospecto', 30, 'left'), $select_lead, array($btn_add_lead, 5, 'center'));
  292. $array_td[] = array(array('Período', 30, 'left'), $select_rg_term, array('', 5, 'center'));
  293.  
  294. if(!empty($select_campus) || !empty($select_lead) || !empty($select_rg_term)){
  295. $array_td[] = array('', html_button('Buscar', 'brand', 'search', 'form2'));
  296. }
  297. $array_table['td'] = $array_td;
  298. $html .= html_form(html_table($array_table, FALSE,FALSE,TRUE));
  299.  
  300. //BUSCADOR
  301.  
  302. if($acc == 'form2'){
  303.  
  304. //REALIZAR CONSULTA
  305. $arr_search = array();
  306. if(is_numeric($re_lead_id))$arr_search['lead_id'] = $re_lead_id;
  307. //if(is_numeric($program_level_id))$arr_search['term_id'] = $program_level_id;
  308. //if(is_numeric($campus_id))$arr_search['campus_id'] = $campus_id;
  309. if(!empty($arr_search))$re_lead = map(crud('select', 're_lead', array('where' => $arr_search)));
  310. //ia($re_lead);
  311.  
  312. //MOSTRAR RESULTADOS
  313. $html .= html_br().html_h(5, 'Resultados de búsqueda');
  314.  
  315. if(empty($re_lead))$html .= html_alert('Sin resultados bajo la búsqueda', 'danger');
  316. else{
  317. $array_table = array('th' => array(array('No.', 'Prospecto', 'Período', 'Oferta académica','Estatus','Email','Telefono', '')));
  318. $array_td = array();
  319. $btn_delete = html_button('', 'danger', 'times', 'confirm_tr1');
  320. $no = 1;
  321. $res_name = $re_lead['response']['select']['0']['first_name'];
  322. // ia($res_name);
  323. $leads_info = [];
  324.  
  325. if (isset($response['response']['select'])) {
  326.  
  327. foreach ($response['response']['select'] as $record) {
  328.  
  329.  
  330.  
  331. foreach ($record as $index => $data) {
  332. ia($index);
  333.  
  334. //ia($record);
  335.  
  336. $leads_info[$index]['first_name'] = $data['first_name'];
  337.  
  338.  
  339.  
  340.  
  341. }
  342.  
  343.  
  344. }
  345.  
  346. }
  347. foreach($re_lead as $k => $arr){
  348. //ia($arr);
  349. $v_lead_id = key_val('lead_id', $arr);
  350. $v_first_name = key_val('first_name', $arr);
  351. $v_middle_name = key_val('middle_name', $arr);
  352. $v_lastname_p = key_val('lastname_p', $arr);
  353. $v_lastname_m = key_val('lastname_m', $arr);
  354.  
  355. $array_td[] = array(
  356. array($no, 5, 'center'),
  357. // $leads_info[$index]['first_name'],
  358. key_val('',''),
  359. key_val('', ''),
  360. key_val('', ''),
  361. key_val('email', $arr),
  362. key_val('telephone', $arr),
  363. //key_val($v_program_level_id, $arr_select_ac_catalog_program_level),
  364. array(html_input('u_program_id', 'hidden', $v_lead_id).$btn_delete, 5, 'center'),
  365. );
  366. ++$no;
  367. }
  368. $array_table['td'] = $array_td;
  369. $html .= html_table($array_table, FALSE);
  370. }
  371. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!