public function danhsachchibo()
{
$id = $_GET['px_id'];
$model = Core::model('Thonto/Chibo');
$row = $model->getThongtin('*', 'thonto_chibo', null, 'donvi_id=' . $id, 'id asc');
Core::PrintJson($row);
}
function getDulieuPhuluc4()
{
$model = Core::model('Thonto/Thongke');
header('Content-type: application/json');
Core::PrintJson($model->bc_mau4());
die;
}
function gethosoquanly()
{
$px_id = (int) $_GET['px_id'];
$model = Core::model('Thonto/Tochuc');
$row = $model->getThongtin(array('hosochinh_id'), 'thonto_tochuc', null, array('donvi_id=' . $px_id), null);
Core::PrintJson($row[0]->hosochinh_id);
}
function deleteQuyhoachcanbo()
{
$arrQhcbDelete = JRequest::get('arrQhcbDelete');
$model = Core::model('Hoso/Quyhoachcanbo');
return Core::PrintJson($model->deleteQuyhoachcanbo($arrQhcbDelete));
die;
}
public function _dsach_giahanhdld()
{
$model = Core::model('Thongke/Thongke');
$donvi_id = $_POST['donvi_id'];
$json = $model->getGiahanhdld($donvi_id, 'select id from bc_hinhthuc where is_hopdong = 1');
Core::PrintJson($json);
die;
}
function ds_quyhoachcb()
{
$donvi_id = JRequest::getVar('donvi_id');
$model = Core::model('Hoso/Quyhoachcanbo');
$rowQHCB = $model->ds_quyhoachcanbo($donvi_id);
return Core::PrintJson($rowQHCB);
die;
}
public function dsach_hdchuyenccvc()
{
$model = Core::model('Thongke/Thongke');
$donvi_id = $_POST['donvi_id'];
$ketqua = array();
$kq = $model->getDanhsach($donvi_id, 'select id from bc_hinhthuc where is_hopdong = 1', '3,2,25');
Core::PrintJson($kq);
die;
}
public function dsach_cctsbnn()
{
$model = Core::model('Thongke/Thongke');
$donvi_id = $_POST['donvi_id'];
$ketqua = array();
$kq = $model->getDanhsach($donvi_id, Core::config('cbcc/bienche/tapsu'), '3,2,25');
Core::PrintJson($kq);
die;
}
function luutaisan()
{
$values = array();
parse_str($_POST['form_taisan'], $values);
$kekhai_id = $_POST['kekhai_id'];
$model = Core::model('Kekhaitaisan/Kekhaitaisan');
Core::PrintJson($model->saveTaisan($kekhai_id, $values));
die;
}
public function dsach_tuyendung()
{
$model = Core::model('Thongke/Thongke');
$donvi_id = $_POST['donvi_id'];
$ketqua = array();
$kq = $model->getThongtin('qtht.hosochinh_id as id, qtht.ngaysinh, qtht.hoten as e_name, qtht.congtac_chucvu, phong.name as congtac_phong, qtht.luong_ngaybatdau, qtht.luong_tenngach, qtht.luong_mangach, qtht.luong_bac, qtht.luong_heso', 'hosochinh_quatrinhhientai qtht', array('inner' => 'ins_dept dv on dv.id = qtht.congtac_donvi_id', 'inner ' => 'ins_dept phong on phong.id = qtht.congtac_phong_id'), 'dv.ins_loaihinh =1 and qtht.hoso_trangthai="00" and qtht.luong_hinhthuc_id = 9 and dv.id = ' . $donvi_id, null);
Core::PrintJson($kq);
die;
}
function luusoluongkhongchuyentrach()
{
$formData = $_POST;
$values = array();
parse_str($formData['frm_soluongkhongchuyentrach'], $values);
$model = Core::model('Thonto/Tochuc');
Core::PrintJson($model->luusoluongkhongchuyentrach($values));
die;
}
private function getlamthemgio()
{
$user_id = $_POST['user_id'];
$lamthemgiobatdau = $_POST['lamthemgiobatdau'];
$lamthemgioketthuc = $_POST['lamthemgioketthuc'];
$model = JModelLegacy::getInstance('Tuan', 'BaocaotuanModel');
$quatrinh = $model->getThongtin('DATE_FORMAT(ltg.timebatdau,"%Hh%i") as timebatdau, DATE_FORMAT(ltg.timeketthuc,"%Hh%i") as timeketthuc,ltg.thoigian,ltg.congvieclamthem as congvieclamthem, ltg.ngaylamthem, DATE_FORMAT(ltg.ngaylamthem,"%m") as thanglamthem, DATE_FORMAT(ltg.ngaylamthem,"%Y") as namlamthem, ltg.id', 'zxlamthemgio ltg', null, ' user_id = ' . $user_id . ' and (ngaylamthem<="' . $lamthemgioketthuc . '" and ngaylamthem>="' . $lamthemgiobatdau . '")', 'ngaylamthem asc');
Core::PrintJson($quatrinh);
die;
}
public function doituong()
{
$model = Core::model('Thongke/Bcdaotaoboiduong');
$donvi_id = $_POST['donvi_id'];
$tungay = $_POST['tungay_bcdaotaocc'];
$denngay = $_POST['denngay_bcdaotaocc'];
$target = $_POST['target'];
$condition = $_POST['condition'];
$json = $model->hienthiBaocao($donvi_id, $target, $condition, $tungay, $denngay);
Core::PrintJson($json);
die;
}
function savebienche()
{
$formData = JRequest::get('post');
$values = array();
parse_str($formData['form_solieubienche'], $values);
$model = Core::model('Tochuc/Solieubienche');
if ($model->removebienche($values['id_donvi'])) {
if ($model->savebienche($values)) {
Core::PrintJson(true);
} else {
Core::PrintJson(false);
}
} else {
Core::PrintJson(false);
}
die;
}
function luutinhhinhhoatdong()
{
$form_tinhhinhhoatdong = $_POST;
$values = array();
parse_str($form_tinhhinhhoatdong['form_tinhhinhhoatdong'], $values);
$model = Core::model('Thonto/Tinhhinhhoatdong');
$insert_id = $model->luutinhhinhhoatdong($values);
if (isset($values['id']) && (int) $values['id'] > 0) {
$model->xoaxulykiennghi($values['id']);
}
if (isset($values['kiennghi_id'])) {
for ($i = 0; $i < count($values['kiennghi_id']); $i++) {
$model->luuxulykiennghi($insert_id, $values['kiennghi_id'][$i], $values['soluongkiennghi'][$i], $values['dagiaiquyet_thonto'][$i], $values['dagiaiquyet_phuongxa'][$i], $values['dagiaiquyet_quanhuyentrolen'][$i]);
}
Core::PrintJson(true);
} else {
Core::PrintJson(true);
}
}
function luutinhhinhquanly()
{
$form_tinhhinhquanly = $_POST;
$values = array();
parse_str($form_tinhhinhquanly['form_tinhhinhquanly'], $values);
$model = Core::model('Thonto/Tinhhinhquanly');
$insert_id = $model->luutinhhinhquanly($values);
if (isset($values['id']) && (int) $values['id'] > 0) {
$model->xoanoidunghop($values['id']);
}
if (count($values['noidunghop_id']) > 0) {
for ($i = 0; $i < count($values['noidunghop_id']); $i++) {
$model->luunoidunghop($insert_id, $values['noidunghop_id'][$i], $values['co_thuchien'][$i]);
}
Core::PrintJson(true);
} else {
Core::PrintJson(true);
}
}
public function xoachibo()
{
$id = JRequest::getInt('idchibo', null);
$model = Core::model('Thonto/Chibo');
Core::PrintJson($model->xoachibo($id));
}
/**
* Hiển thị combobox chọn phường xã
*/
public function getComm()
{
$model = Core::model('Kekhaitaisan/Kekhaitaisan');
$hokhau_quanhuyen = $_POST['hokhau_quanhuyen'];
$phuongxa = $model->getCbo('comm_code', 'code, name', 'status=1 and dc_code = ' . $hokhau_quanhuyen, 'name asc', '', '--Chọn phường xã--', 'code', 'name', '', 'hokhau_phuongxa', ' chosen', '');
Core::PrintJson($phuongxa);
die;
}
function dellamthemgio()
{
$formData = $_POST['iddel'];
$model = JModelLegacy::getInstance('Tuan', 'BaocaotuanModel');
$str = '0';
for ($i = 0; $i < count($formData); $i++) {
$str .= ',' . $formData[$i];
}
$kq = $model->dellamthemgio($str);
Core::PrintJson($kq);
die;
}
public function deletefilevanban()
{
$idFile = JRequest::getVar('idFile');
$model = Core::model('Core/Attachment');
if (!$model->deleteFileByMaso($idFile)) {
$result = '0';
} else {
$result = '1';
}
echo Core::PrintJson($result);
die;
}
