public function actionDeleteconsultation($id)
{
Consultationscalendar::model()->deleteByPk($id);
if(!isset($_GET['ajax']))
$this->redirect(Yii::app()->request->urlReferrer);
}
public static function consultationFree ($id, $times, $date)
{
$a = Consultationscalendar::model()->findAll("date_cons=:date and teacher_id=:id", array(':date'=>$date, ':id' => $id));
$result = true;
$startTime = intval(substr($times, 0, 2))*60 + intval(substr($times, 3, 2));
$endTime = intval(substr($times, 6, 2))*60 + intval(substr($times, 9, 2));
foreach($a as $td){
$startCons = intval(substr($td->start_cons, 0, 2))*60 + intval(substr($td->start_cons, 3, 2));
$endCons = intval(substr($td->end_cons, 0, 2))*60 + intval(substr($td->end_cons, 3, 2));
if( ($startTime>=$startCons && $startTime<$endCons) || ($startCons>=$startTime && $startCons<$endTime)|| ($endCons>$startTime && $endCons<=$endTime)){
$result = false;
}
}
return $result;
}
