badlogic

Ajax get the unique id in table loop event target or custom id and formatting JSON

Nov 7th, 2020 (edited)
801
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. note: pag gusto mo makuha yung uniquie na id or target event ng nasa table na naka loop need mo gumamit ng event target
  2. Source: https://stackoverflow.com/questions/11026056/getting-the-class-of-the-element-that-fired-an-event-using-jquery
  3.  
  4. for example: eto yung a tag or ahref tag na naka loop
  5. $view = "<a href=\"#\" class=\"btn btn-flat btn-xs bg-green\" title=\"View\" data-toggle=\"modal\" id=\"cesqt',cesqt_id,'\" data-id=\"',cesqt_id,'\" data-sy_id=\"',cesqt.sy_id,'\" data-target=\"#modal-success\">View Transaction</a>";
  6.  
  7. //ajax code
  8.                 <script>
  9.                 var cesqt = $('a'); //note a tag to hindi to id or class value
  10.                     cesqt.click(function(){
  11.                        // alert(event.target.id + " and " + $(event.target).attr('data-id')); //uncomment mo tong alert
  12.                         var cesqt_id = $(event.target).attr('data-id');
  13.                     $.ajax({
  14.                         url: "registrar.php?",
  15.                         type: "GET",
  16.                         data:  {
  17.                             statpos:'enroll_subjects_queue',
  18.                             action:'get_subjects_queue',
  19.                             cesqt_id:cesqt_id,
  20.                             sy_id:cesqt.attr('cesqt.sy_id')
  21.                         },
  22.                         success: function(data){
  23.                             console.log(data[0].ppd_firstname);
  24.                             var cnt = 0;
  25.                             var td = "";
  26.                             $('#subjects_queue').find('tbody').append(td);
  27.                             data.forEach(function(value){
  28.  
  29.                                 td+="<tr>"
  30.                                       +"<td>"+value.subjects['subjname_shortname']+"</td>"
  31.                                       +"<td>"+value.subjects['subjname_name']+"</td>"
  32.                                       +"<td>"+value.subjects['ccc_lec_unit']+"</td>"
  33.                                       +"<td>"+value.subjects['ccc_lab_unit']+"</td>"
  34.                                       +"<td>"+value.subjects['sched'][0]['block_name']+"</td>"
  35.                                       +"<td>"+value.subjects['fullname']+"</td>"+
  36.                                     "</tr>";
  37.  
  38.  
  39.                             });
  40.                             document.getElementById("stud_name").innerHTML=data[0].ppd_lastname+', '+data[0].ppd_firstname;
  41.                             $('#subjects_queue').find('tbody').empty().append(td);
  42.  
  43.                             //document.getElementById("test").innerHTML=td;
  44.                         },
  45.                         dataType: 'json'
  46.                     });
  47.                 });
  48.                 </script>
  49.  
  50.  
  51. eto yung json format kung pano mo e loloop yung json using foreach javascript api to
  52. Array
  53. (
  54.     [0] => Array
  55.         (
  56.             [cesq_id] => 30
  57.             [emp_id] => 18
  58.             [cesq_date] => 2020-11-07 09:12:33
  59.             [cesqt_id] => 29
  60.             [cses_id] => 5833
  61.             [csm_id] => 28
  62.             [sy_id] => 23
  63.             [cesq_id_status] => 0
  64.             [sai_id] => 16306
  65.             [ppd_lastname] =>  BERNALES
  66.             [ppd_firstname] => MAY ZARITHA
  67.             [subjects] => Array
  68.                 (
  69.                     [ccc_id] => 103
  70.                     [cses_id] => 5833
  71.                     [cc_id] => 27
  72.                     [is_included] => 20
  73.                     [subjname_name] => Fundamental of Games & Sports
  74.                     [subjname_shortname] => PE 3
  75.                     [ccc_lec_unit] => 2.00
  76.                     [ccc_lab_unit] => 0.00
  77.                     [college_day] => [{"sunday":0,"monday":1,"tuesday":0,"wednesday":0,"thursday":0,"friday":0,"saturday":1}]
  78.                     [college_subject_schedule_id] => 2980
  79.                     [room] =>
  80.                     [timee] => 08:00 PM-10:00 PM
  81.                     [fullname] => Edgardo Garingan
  82.                     [action] =>  
  83.                     [csh_id] => 72
  84.                     [days] =>  M     Sat
  85.                     [sched] => Array
  86.                         (
  87.                             [0] => Array
  88.                                 (
  89.                                     [college_subject_schedule_id] => 2980
  90.                                     [college_time_in] => 08:00 PM
  91.                                     [college_time_out] => 10:00 PM
  92.                                     [roomdata] =>
  93.                                     [fullname] => Edgardo Garingan
  94.                                     [college_day] => [{"sunday":0,"monday":1,"tuesday":0,"wednesday":0,"thursday":0,"friday":0,"saturday":1}]
  95.                                     [block_name] => BSN BLOCK 2A
  96.                                     [extracteddays] =>  M     Sat
  97.                                     [schedsummary] =>  M     Sat | 08:00 PM-10:00 PM
  98.  
  99.                                     [prof] => Edgardo Garingan
  100.                                     [schedjson] => {"day":" M     Sat","time":"08:00 PM-10:00 PM","room":null,"prof":"Edgardo Garingan"}
  101.                                 )
  102.  
  103.                         )
  104.  
  105.                 )
  106.  
  107.         )
  108.  
  109.     [1] => Array
  110.         (
  111.             [cesq_id] => 31
  112.             [emp_id] => 18
  113.             [cesq_date] => 2020-11-07 09:12:33
  114.             [cesqt_id] => 29
  115.             [cses_id] => 5834
  116.             [csm_id] => 28
  117.             [sy_id] => 23
  118.             [cesq_id_status] => 0
  119.             [sai_id] => 16306
  120.             [ppd_lastname] =>  BERNALES
  121.             [ppd_firstname] => MAY ZARITHA
  122.             [subjects] => Array
  123.                 (
  124.                     [ccc_id] => 385
  125.                     [cses_id] => 5834
  126.                     [cc_id] => 27
  127.                     [is_included] => 20
  128.                     [subjname_name] => Kontekstwalisadong Komunikasyon sa Filipino (KOMFIL)
  129.                     [subjname_shortname] => Fil 1
  130.                     [ccc_lec_unit] => 3.00
  131.                     [ccc_lab_unit] => 0.00
  132.                     [college_day] => [{"sunday":0,"monday":0,"tuesday":0,"wednesday":0,"thursday":0,"friday":0,"saturday":1}]
  133.                     [college_subject_schedule_id] => 3202
  134.                     [room] =>
  135.                     [timee] => 01:00 PM-04:00 PM
  136.                     [fullname] => Rodora Briguela
  137.                     [action] =>  
  138.                     [csh_id] => 1888
  139.                     [days] =>       Sat
  140.                     [sched] => Array
  141.                         (
  142.                             [0] => Array
  143.                                 (
  144.                                     [college_subject_schedule_id] => 3202
  145.                                     [college_time_in] => 01:00 PM
  146.                                     [college_time_out] => 04:00 PM
  147.                                     [roomdata] =>
  148.                                     [fullname] => Rodora Briguela
  149.                                     [college_day] => [{"sunday":0,"monday":0,"tuesday":0,"wednesday":0,"thursday":0,"friday":0,"saturday":1}]
  150.                                     [block_name] => BSN BLOCK 2A
  151.                                     [extracteddays] =>       Sat
  152.                                     [schedsummary] =>       Sat | 01:00 PM-04:00 PM
  153.  
  154.                                     [prof] => Rodora Briguela
  155.                                     [schedjson] => {"day":"      Sat","time":"01:00 PM-04:00 PM","room":null,"prof":"Rodora Briguela"}
  156.                                 )
  157.  
  158.                         )
  159.  
  160.                 )
  161.  
  162.         )
  163.  
  164. )
  165. [{"cesq_id":"30","emp_id":"18","cesq_date":"2020-11-07 09:12:33","cesqt_id":"29","cses_id":"5833","csm_id":"28","sy_id":"23","cesq_id_status":"0","sai_id":"16306","ppd_lastname":" BERNALES","ppd_firstname":"MAY ZARITHA","subjects":{"ccc_id":"103","cses_id":"5833","cc_id":"27","is_included":"20","subjname_name":"Fundamental of Games & Sports","subjname_shortname":"PE 3","ccc_lec_unit":"2.00","ccc_lab_unit":"0.00","college_day":"[{\"sunday\":0,\"monday\":1,\"tuesday\":0,\"wednesday\":0,\"thursday\":0,\"friday\":0,\"saturday\":1}]","college_subject_schedule_id":"2980","room":null,"timee":"08:00 PM-10:00 PM","fullname":"Edgardo Garingan","action":" ","csh_id":"72","days":" M Sat","sched":[{"college_subject_schedule_id":"2980","college_time_in":"08:00 PM","college_time_out":"10:00 PM","roomdata":null,"fullname":"Edgardo Garingan","college_day":"[{\"sunday\":0,\"monday\":1,\"tuesday\":0,\"wednesday\":0,\"thursday\":0,\"friday\":0,\"saturday\":1}]","block_name":"BSN BLOCK 2A","extracteddays":" M Sat","schedsummary":" M Sat | 08:00 PM-10:00 PM
  166. ","prof":"Edgardo Garingan","schedjson":"{\"day\":\" M Sat\",\"time\":\"08:00 PM-10:00 PM\",\"room\":null,\"prof\":\"Edgardo Garingan\"}"}]}},{"cesq_id":"31","emp_id":"18","cesq_date":"2020-11-07 09:12:33","cesqt_id":"29","cses_id":"5834","csm_id":"28","sy_id":"23","cesq_id_status":"0","sai_id":"16306","ppd_lastname":" BERNALES","ppd_firstname":"MAY ZARITHA","subjects":{"ccc_id":"385","cses_id":"5834","cc_id":"27","is_included":"20","subjname_name":"Kontekstwalisadong Komunikasyon sa Filipino (KOMFIL)","subjname_shortname":"Fil 1","ccc_lec_unit":"3.00","ccc_lab_unit":"0.00","college_day":"[{\"sunday\":0,\"monday\":0,\"tuesday\":0,\"wednesday\":0,\"thursday\":0,\"friday\":0,\"saturday\":1}]","college_subject_schedule_id":"3202","room":null,"timee":"01:00 PM-04:00 PM","fullname":"Rodora Briguela","action":" ","csh_id":"1888","days":" Sat","sched":[{"college_subject_schedule_id":"3202","college_time_in":"01:00 PM","college_time_out":"04:00 PM","roomdata":null,"fullname":"Rodora Briguela","college_day":"[{\"sunday\":0,\"monday\":0,\"tuesday\":0,\"wednesday\":0,\"thursday\":0,\"friday\":0,\"saturday\":1}]","block_name":"BSN BLOCK 2A","extracteddays":" Sat","schedsummary":" Sat | 01:00 PM-04:00 PM
  167. ","prof":"Rodora Briguela","schedjson":"{\"day\":\" Sat\",\"time\":\"01:00 PM-04:00 PM\",\"room\":null,\"prof\":\"Rodora Briguela\"}"}]}}]
  168.  
Add Comment
Please, Sign In to add comment