public static function getRecords($date, $specialist_id)
{
$month = date('m', $date);
$year = date('Y', $date);
$day = date('j', $date);
$start = $year . '-' . $month . '-' . $day;
$sql = 'SELECT * FROM `records` WHERE DATE(`start_time`) = "' . $start . '" AND `specialist_id` = "' . $specialist_id . '" ';
$sql .= 'AND `reserved` = false ORDER BY `start_time`';
$result = Records::findBySql($sql)->all();
return $result;
}
public function actionGetD($id)
{
$sql = 'SELECT `dc`.`start_time`, `dc`.`end_time` FROM `specialists` as `sp`, `doctors` as `dc` WHERE `sp`.`id` = "' . $id . '" AND `sp`.`doctor_id` = `dc`.`id`';
$result = Records::findBySql($sql)->one();
echo Json::encode($result);
}
