In Cgridview Overlap Times From Two Columns

Yii 1.1 General Discussion
1

Hello! :)

In admin page (CGridView) I have columns (for example):

Start_time End time

10:00:00 11:00:00

11:00:00 15:00:00

14:00:00 16:00:00

In above example, times may not overlap. What is the way to check it (I have no idea)? Times are in database, the best result would be select the times that overlap by ‘cssClassExpression’ in CGridView ( 15:00:00 and 14:00:00 ), but not necessairly.

Thank’s for reply.

2

I presume you also have a date column? Can you post your table schema or model?

3

Yes, It’s something as:

TABLE: work

id INT

date DATE

relation 1:n

TABLE: work_details

id INT

work_id INT

start_time TIME

end_time TIME

In Yii Project I have list of dates and click show details - times of day.

I have no idea how and where compare times…

Thank you for interest.