{"id":740,"date":"2015-03-10T04:23:17","date_gmt":"2015-03-10T04:23:17","guid":{"rendered":"http:\/\/codethataint.com\/blog\/?p=740"},"modified":"2015-03-10T07:24:45","modified_gmt":"2015-03-10T07:24:45","slug":"cases-to-check-to-prevent-event-overlapping","status":"publish","type":"post","link":"https:\/\/codethataint.com\/blog\/cases-to-check-to-prevent-event-overlapping\/","title":{"rendered":"Cases to check to prevent event overlapping"},"content":{"rendered":"<p>How to check for overlapping events in a period<\/p>\n<p><strong>Case1<\/strong>: No Event between Period Start Date and Period End Date<br \/>\n<strong>Case2<\/strong>: No Event which subsets another event Period Start Date and Period End Date<br \/>\n<strong>Case3<\/strong>: No Event which starts before period start date and ends in between some other events end date<br \/>\n<strong>Case4<\/strong>: No Event which starts after some other event period start date and ends after events end date <\/p>\n<p><a class=\"thumbnail\" href=\"http:\/\/codethataint.com\/blog\/wp-content\/uploads\/2015\/03\/oVERLAPPING-eVENT.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/codethataint.com\/blog\/wp-content\/uploads\/2015\/03\/oVERLAPPING-eVENT-580x341.jpg\" alt=\"oVERLAPPING eVENT\" width=\"580\" height=\"341\" class=\"alignnone size-medium wp-image-747\" srcset=\"https:\/\/codethataint.com\/blog\/wp-content\/uploads\/2015\/03\/oVERLAPPING-eVENT-580x341.jpg 580w, https:\/\/codethataint.com\/blog\/wp-content\/uploads\/2015\/03\/oVERLAPPING-eVENT.jpg 879w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><\/p>\n<p>Where Clause:<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nSELECT count(event) \r\n  FROM tblEvent\r\n WHERE (new_event_start_date BETWEEN old_event_start_date and old_event_end_date OR\r\n        new_event_end_date BETWEEN old_event_start_date and old_event_end_date) OR \r\n        new_event_start_date &lt;= old_event_start_date OR new_event_end_date &gt;= old_event_start_date\r\n<\/pre>\n<p><strong>Case1,2,3:<\/strong><\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\n     new_event_start_date BETWEEN old_event_start_date and old_event_end_date OR\r\n     new_event_end_date BETWEEN old_event_start_date and old_event_end_date\r\n<\/pre>\n<p><strong>Case4:<\/strong><\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nnew_event_start_date &lt;= old_event_start_date OR new_event_end_date &gt;= old_event_start_date\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>How to check for overlapping events in a period Case1: No Event between Period Start Date and Period End Date Case2: No Event which subsets another event Period Start Date and Period End Date Case3: No Event which starts before period start date and ends in between some other events end date Case4: No Event&hellip; <a href=\"https:\/\/codethataint.com\/blog\/cases-to-check-to-prevent-event-overlapping\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[84],"tags":[],"class_list":["post-740","post","type-post","status-publish","format-standard","hentry","category-software-design"],"_links":{"self":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/740","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/comments?post=740"}],"version-history":[{"count":7,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/740\/revisions"}],"predecessor-version":[{"id":748,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/740\/revisions\/748"}],"wp:attachment":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/media?parent=740"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/categories?post=740"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/tags?post=740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}