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; }