php - Find the students whose time interval clashes with themselves? -

-

in simple words. have query displays table. (students usn group concatenated, , displayed whole row foreach).

row 1 => subject 1 - 22/07/2015 - 08:00 - 1xx10xx086, 1xx10xx087, 1xx09xx088

row 2 => subject 2 - 22/07/2015 - 09:00 - 1xx10xx086, 1xx10xx087, 1xx09xx088

row 3 => subject 3 - 22/07/2015 - 08:00 - 1xx10xx096, 1xx10xx086, 1xx09xx098

row 4 => subject 4 - 22/07/2015 - 10:00 - 1xx10xx096, 1xx10xx086, 1xx09xx098

row 5 => subject 5 - 22/07/2015 - 08:00 - 1xx10xx106, 1xx10xx107, 1xx09xx108

how shall highlight in jquery or html or php or 1xx10xx086 roll no cant attend both subject 1, subject 3 @ same day , same time can attend subject 2 @ different time slot. how shall hight light them.?

assuming table , want highlight required td jquery, can next example:

the idea loop table rows , compare td date info if 2 rows have td same date split , compare td groups info, if first array(all values in group td exploded ,) contains 1 or more values second array highlight both.

$(document).ready(function(){      $('tr').each(function( index ) {          var current=$(this);          current.nextall('tr').each(function( index ) {              if(current.children( ".date" ).html()==$(this).children( ".date" ).html()){                  var child=$(this);                  var = current.children( ".groups" ).html().split(',');                  var b = child.children( ".groups" ).html().split(',');                     $.each( a, function( key, value ) {                         if($.inarray( value,  b ) != -1){                                                      ///edit                           current.children( ".groups" ).html(current.children( ".groups" ).html().replace(                                new regexp(value, 'g'), '<span class=markme >'+value+'</span>'                            ));                           child.children( ".groups" ).html(child.children( ".groups" ).html().replace(                                new regexp(value, 'g'), '<span class=markme >'+value+'</span>'                            ));                                                       /////////                         }                                            });                                }          });      });  });
.markme {      color: red;  }
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>  <table  border="1">      <tr>          <td class="subject">subject 1</td>          <td class="date">22/07/2015 - 08:00</td>          <td class="groups">1xx10xx086,1xx10xx087,1xx09xx088</td>      </tr>      <tr>          <td class="subject">subject </td>          <td class="date">22/07/2015 - 09:00</td>          <td class="groups">1xx10xx086,1xx10xx087,1xx09xx088</td>      </tr>      <tr>          <td class="subject">subject 3</td>          <td class="date">22/07/2015 - 08:00</td>          <td class="groups">1xx10xx096,1xx10xx086,1xx09xx098</td>      </tr>      <tr>          <td class="subject">subject 4</td>          <td class="date">22/07/2015 - 10:00</td>          <td class="groups">1xx10xx096,1xx10xx086,1xx09xx098</td>      </tr>      <tr>          <td class="subject">subject 5</td>          <td class="date">22/07/2015 - 08:00</td>          <td class="groups">1xx10xx106,1xx10xx107,1xx09xx108</td>      </tr>        </table>


Comments

Post a Comment

Popular posts from this blog

Fail to load namespace Spring Security http://www.springframework.org/security/tags -

-
i have problem namespace of spring security on xhtml page. don't understand why can't load uri, , have following issue: whitelabel error page application has no explicit mapping /error, seeing fallback. tue jul 21 16:58:12 utc 2015 there unexpected error (type=not found, status=404). please need help! possible uri has been changed? best regards you using incorrect namespace url. correct url http://www.springframework.org/schema/security the error page seeing spring source website since not recognize url. try visiting http://www.springsource.org/security/tags in browser update : spring security tags used in jsp page correct tag lib declaration is: <%@ taglib prefix="sec" uri="http://www.springframework.org/security/tags" %>
Read more

sql - MySQL query optimization using coalesce -

-
can explain me why second query faster first? (first 1 takes around 40 seconds, second 1 less 0.1) select releases.feature_code, releases.platform_id, version, release_date, general_available, uri, filesize, display_name, feature_name.full_name, if ((select exists(select 1 release_exceptions releases.feature_code = release_exceptions.feature_code , releases.platform_id = release_exceptions.platform_id , releases.version = release_exceptions.version) = 1), 1, 0) release_exceptions releases left outer join platform using(platform_id) left outer join feature_name using(feature_code) order version desc; ~~~ query 2 ------------------ ~~~ select feature_code, version, release_date, general_available, platform_id, uri, filesize, display_name, feature_name.full_name, coalesce(release_exceptions, 0) release_exceptions mus.releases left outer join ( select distinct feature_code, version, platform_id, 1 release_exceptions mus.release_exceptions ) release_exceptions using ...
Read more

unity3d - Unity local avoidance in user created world -

-
i'm using unity3d networked multiplayer online game have large complex 3d terrain scene forest, trees, cliff, hills, mountains, bounders, etc. players can build structures sort of minecraft, , put them anywhere in scene, or move them around anytime. aside human controlled players, there automated ai players , objects animals roaming around scene following path. the problem how make these automated ai players , animals, able navigate around static , dynamic player created structures, because path follow can blocked player created structures, or other players , other ai objects, cliffs etc. have find away around them or on track if tumble down off high cliff example. so made navmesh , used navagents, takes care of static, non moving objects, how make ai players navigate around each other , dynamic structures created players can number in hundreds? i thought of adding navmeshobstacle everything, result in being attached hundreds of objects since user created structures b...
Read more