public function getDSDTByGV($ho_ten, $ma_don_vi = 0)
{
$ho_ten = Default_Model_Functions::tach_ho_ten($ho_ten);
$ho = $ho_ten['ho'];
$ten = $ho_ten['ten'];
$cols = array();
$tableInfo = array('gv' => 'giang_vien');
$statement = $this->select()->setIntegrityCheck(false)->from($tableInfo, $cols)->join(array('dk' => 'dang_ky'), 'gv.id = dk.ma_giang_vien', null)->join(array('dt' => 'de_tai'), 'dk.ma_de_tai = dt.id', array('id' => 'dt.id', 'ma' => 'dt.ma', 'ten' => 'dt.ten', 'thoi_gian_bat_dau' => 'dt.thoi_gian_bat_dau', 'tinh_trang' => 'dt.tinh_trang'))->join(array('hv' => 'hoc_vi'), 'hv.id = gv.ma_hoc_vi', array('hoc_vi' => 'hv.ma'))->join(array('lv' => 'linh_vuc'), 'dt.ma_linh_vuc = lv.id', array('linh_vuc' => 'lv.ten'))->order('thoi_gian_bat_dau DESC');
if ($ho != null) {
$statement->where('gv.ho = ?', $ho);
}
if ($ten != null) {
$statement->where('gv.ten = ?', $ten);
}
if ($ma_don_vi != '0') {
$statement->where('gv.ma_don_vi = ?', $ma_don_vi);
}
$dsDeTais = $this->_db->query($statement)->fetchAll();
$link = new Zend_View_Helper_Url();
$dang_ky = new Default_Model_DangKy();
$tinhTrangs = Default_Model_Constraints::detai_tinhtrang();
$result = array();
foreach ($dsDeTais as $de_tai) {
$url = $link->url(array('controller' => 'de-tai', 'action' => 'chi-tiet', 'id' => $de_tai['id']), null, true);
$chu_nhiem = $dang_ky->getChuNhiemDT($de_tai['id']);
$result[] = array('type' => 'default_de_tai', 'code' => $de_tai['ma'], 'title' => $de_tai['ten'], 'description' => 'Chủ nhiệm : ' . $chu_nhiem['hoc_vi'] . ' ' . $chu_nhiem['ho'] . ' ' . $chu_nhiem['ten'] . '
| Lĩnh vực : ' . $de_tai['linh_vuc'] . '
| Tình trạng : ' . $tinhTrangs[$de_tai['tinh_trang']], 'link' => $url);
}
return $result;
}
