public async Task <IActionResult> Search(string term, string thuoc_tinh, string thuoc_tinh_rieng, int page, int page_size)
{
List <int> lst_thuoc_tinh = new List <int>();
List <int> lst_thuoc_tinh_rieng = new List <int>();
List <string> lst_id = new List <string>();
bool is_find_thuoc_tinh_rieng = false;
List <CongTy> data = new List <CongTy>();
long total_recs = 0;
string msg = "";
if (!string.IsNullOrEmpty(thuoc_tinh))
{
foreach (var tt in thuoc_tinh.Split(','))
{
int t = -1;
if (int.TryParse(tt, out t))
{
lst_thuoc_tinh.Add(t);
}
}
}
if (!string.IsNullOrEmpty(thuoc_tinh_rieng))
{
foreach (var tt in thuoc_tinh_rieng.Split(','))
{
int t = -1;
if (Int32.TryParse(tt, out t))
{
lst_thuoc_tinh_rieng.Add(t);
}
}
if (lst_thuoc_tinh_rieng.Count > 0)
{
is_find_thuoc_tinh_rieng = true;
var lst_id_obj = BL.ThuocTinhDuLieuBL.Search(app_id, user, LoaiThuocTinh.CONG_TY, lst_thuoc_tinh_rieng, page, out long total_recs_thuoc_tinh, out _, 9999);
lst_id = lst_id_obj.Select(x => x.id_obj).Where(o => !string.IsNullOrEmpty(o)).ToList();
}
}
if (is_find_thuoc_tinh_rieng && lst_id.Count == 0 && lst_thuoc_tinh.Count == 0)
{
}
else
{
var lst_id_job_duoc_giao = await UserJobBL.GetListIdJobByUser(app_id, new List <string>() { user });
var lst_id_cong_ty_phan_theo_job = await JobBL.GetListIdCongTyByIdJob(app_id, lst_id_job_duoc_giao);
data = QLCUNL.BL.CongTyBL.Search(app_id, user, group, term, lst_thuoc_tinh, lst_id, lst_id_cong_ty_phan_theo_job, page, out total_recs, out msg, page_size, (is_sys_admin || is_app_admin));
}
return(Ok(new DataResponsePaging()
{
data = data, total = total_recs, success = data != null, msg = msg
}));
}
public IActionResult Search(string term, int page, int page_size, string thuoc_tinh)
{
long total_recs = 0;
string msg = "";
List <JobThuocTinhMap> lst_job_map = new List <JobThuocTinhMap>();
List <NhaTuyenDung> data = new List <NhaTuyenDung>();
var user = User.FindFirst(x => x.Type == ClaimTypes.NameIdentifier).Value;
List <int> lst_thuoc_tinh = new List <int>();
if (!string.IsNullOrEmpty(thuoc_tinh))
{
foreach (var tt in thuoc_tinh.Split(','))
{
int t = -1;
if (Int32.TryParse(tt, out t))
{
lst_thuoc_tinh.Add(t);
}
}
var lst_ntd_seen = NoteBL.Search(lst_thuoc_tinh, out total_recs, out msg, 9999);
var lst_ntd_get_id = lst_ntd_seen.Select(x => x.id_obj).Distinct().Where(i => i != null);
var all_nha_tuyen_dung = BL.NhaTuyenDungBL.GetMany(lst_ntd_get_id).Where(x => x.nguoi_tao == user && x.trang_thai != TrangThai.DELETED);
var lst_id_job = all_nha_tuyen_dung.Select(x => x.id_job);
//var data_job = QLCUNL.BL.JobBL.GetMany(lst_id_job).Where(x => x.owner == user && all_nha_tuyen_dung.Select(y => y.id_job).Contains(x.id_job));
var data_job = QLCUNL.BL.JobBL.GetMany(lst_id_job);
var list_job = data_job.ToDictionary(x => x.id_job, y => y);
all_nha_tuyen_dung = all_nha_tuyen_dung.Where(o => data_job.Select(u => u.id_job).Contains(o.id_job)).ToList();
foreach (var item in all_nha_tuyen_dung)
{
JobThuocTinhMap job_map = new JobThuocTinhMap(item, list_job);
lst_job_map.Add(job_map);
}
return(Ok(new { data = lst_job_map, total = all_nha_tuyen_dung.Count(), success = lst_job_map != null, msg = msg }));
}
else
{
var user_job = UserJobBL.Search(app_id, user, group, new List <string>(), string.Empty, 0, 0, new List <int>(), new List <string>(), 1, out long total_user_job, out string msg_user_job, 100, (is_app_admin || is_app_admin));
var lst_job_in_user_job = user_job.Select(x => x.id_job);
string[] fields = new string[] { "id_job", "chuc_danh" };
List <NhaTuyenDung> result = new List <NhaTuyenDung>();
var all_job = JobBL.GetAllJobsIsOwner(app_id, user, fields, (is_app_admin || is_sys_admin));
var lst_id_job_is_owner = all_job.Select(x => x.id_job);
// viet query get all nha tuyen dung
var all_nha_tuyen_dung = BL.NhaTuyenDungBL.GetAllNhaTuyenDung(term, new List <int>(), app_id, page, out long total_rec, out msg, 9999, (is_app_admin || is_app_admin)).Where(x => x.nguoi_tao == user || lst_id_job_is_owner.Contains(x.id_job));
//all_nha_tuyen_dung = NhaTuyenDungBL.Search(term, lst_thuoc_tinh, app_id, user, page, "", out total_recs, out msg, page_size, (is_sys_admin || is_app_admin));
var lst_id_job = all_nha_tuyen_dung.Select(x => x.id_job);
var data_job = JobBL.GetMany(lst_id_job).Where(x => x.owner == user || (is_app_admin || is_sys_admin) || lst_job_in_user_job.Contains(x.id_job));
var list_job = data_job.ToDictionary(x => x.id_job, y => y);
//.Where(x => data_job.Any(e => e.id_job == x.id_job) && x.nguoi_tao == user || (is_app_admin || is_sys_admin))
foreach (var item in all_nha_tuyen_dung)
{
JobThuocTinhMap job_map = new JobThuocTinhMap(item, list_job);
lst_job_map.Add(job_map);
}
return(Ok(new DataResponsePaging {
data = lst_job_map, total = lst_job_map.Count, success = lst_job_map != null, msg = msg
}));
}
}
public IActionResult Share([FromBody] object value)
{
//check quyền trước khi share? Chỉ admin + owner mới được quyền share
bool has_share_permission = (is_sys_admin || is_app_admin);
DataResponse res = new DataResponse()
{
msg = "Không có quyền chia sẻ thông tin", success = false
};
try
{
var obj = JToken.Parse(value.ToString());
if (obj != null)
{
List <string> users = obj["user"].ToObject <List <string> >();
List <string> lst_id_nha_tuyen_dung = new List <string>();
if (obj["id_nha_tuyen_dung"] != null)
{
string id_nha_tuyen_dung = obj["id_nha_tuyen_dung"].ToString();
try
{
lst_id_nha_tuyen_dung = id_nha_tuyen_dung.Split(',', StringSplitOptions.RemoveEmptyEntries).Select(x => x.Trim()).ToList();
}
catch (Exception)
{
}
}
string id = obj["id"].ToString();
int type = obj["type"].ToObject <int>();
int rule = obj["rule"].ToObject <int>();
int obj_type = obj["obj_type"].ToObject <int>();
long ngay_het = 0;
List <Quyen> quyen = new List <Quyen>();
List <int> teams = new List <int>();
if (obj["ngay_het"] != null)
{
try
{
ngay_het = XMedia.XUtil.TimeInEpoch(Convert.ToDateTime(ngay_het, dtfi));
}
catch (Exception)
{
ngay_het = XMedia.XUtil.TimeInEpoch(DateTime.Now.AddYears(10));
}
}
if (obj["quyen"] != null)
{
quyen = obj["quyen"].ToObject <List <Quyen> >();
}
if (!(is_sys_admin || is_app_admin))
{
var obj_type_check = (PhanQuyenObjType)obj_type;
switch (obj_type_check)
{
case PhanQuyenObjType.CONG_TY:
has_share_permission = CongTyBL.IsOwner(id, user);
break;
case PhanQuyenObjType.USER_JOB:
has_share_permission = UserJobBL.IsOwner(id, user);
break;
case PhanQuyenObjType.NOTE_UNG_VIEN:
has_share_permission = NoteUngVienBL.IsOwner(id, user);
break;
case PhanQuyenObjType.UNG_VIEN:
has_share_permission = UngVienBL.IsOwner(id, user);
break;
case PhanQuyenObjType.JOB:
has_share_permission = JobBL.IsOwner(id, user);
break;
case PhanQuyenObjType.NOTE_UNG_VIEN_JOB:
has_share_permission = NoteUngVienJobBL.IsOwner(id, user);
break;
case PhanQuyenObjType.MENU:
has_share_permission = MenuBL.IsOwner(id, user);
break;
}
}
if (!has_share_permission)
{
return(Ok(res));
}
if (obj["teams"] != null)
{
try
{
teams = obj["teams"].ToObject <List <int> >();
}
catch
{
teams = new List <int>();
}
}
#region Xóa shared của các đối tượng cũ
try
{
List <string> lst_id_phan_quyen_can_xoa = new List <string>();
var menu_shared = QLCUNL.BL.PhanQuyenBL.Get(string.Empty, PhanQuyenRule.ALL, PhanQuyenType.ALL, string.Empty, PhanQuyenObjType.ALL, id, quyen, 0, 0, ((is_sys_admin || is_app_admin) ? string.Empty : user), 0, 0, string.Empty, 0, 0, 1, 9999, out _);
foreach (var item_shared in menu_shared)
{
if (item_shared.type == PhanQuyenType.GROUP_USERS)
{
int id_team_shared = -1;
if (Int32.TryParse(item_shared.user, out id_team_shared))
{
if (!teams.Contains(id_team_shared))
{
lst_id_phan_quyen_can_xoa.Add(item_shared.id);
}
else
{
if (item_shared.ngay_het == ngay_het && item_shared.quyen.All(quyen.Contains) && quyen.All(item_shared.quyen.Contains))
{
teams.Remove(id_team_shared);
}
}
}
}
else
{
if (item_shared.type == PhanQuyenType.USERS)
{
if (!users.Contains(item_shared.user) && !lst_id_nha_tuyen_dung.Contains(item_shared.user))
{
lst_id_phan_quyen_can_xoa.Add(item_shared.id);
}
else
{
if (item_shared.ngay_het == ngay_het && item_shared.quyen.All(quyen.Contains) && quyen.All(item_shared.quyen.Contains))
{
users.Remove(item_shared.user);
}
}
}
}
}
PhanQuyenBL.RemoveByListId(lst_id_phan_quyen_can_xoa);
}
catch (Exception)
{
}
#endregion
#region Shared cho các đối tượng được chọn
try
{
if (users.Count == 0 && teams.Count == 0 && lst_id_nha_tuyen_dung.Count == 0)
{
res.success = true;
res.msg = "Không có thay đổi nào được thực hiện";
}
else
{
foreach (var user in users)
{
PhanQuyen pq = new PhanQuyen();
pq.ngay_het = ngay_het;
pq.user = user;
pq.type = PhanQuyenType.USERS;
pq.rule = (PhanQuyenRule)rule;
pq.quyen = quyen;
pq.obj_type = (PhanQuyenObjType)obj_type;
pq.nguoi_tao = this.user;
pq.obj_id = id;
res.success = QLCUNL.BL.PhanQuyenBL.Index(pq);
}
foreach (var user in lst_id_nha_tuyen_dung)
{
PhanQuyen pq = new PhanQuyen();
pq.ngay_het = ngay_het;
pq.user = user;
pq.type = PhanQuyenType.USERS;
pq.rule = (PhanQuyenRule)rule;
pq.quyen = quyen;
pq.obj_type = (PhanQuyenObjType)obj_type;
pq.nguoi_tao = this.user;
pq.obj_id = id;
res.success = QLCUNL.BL.PhanQuyenBL.Index(pq);
}
if (teams.Count > 0)
{
foreach (var id_team in teams)
{
PhanQuyen pq = new PhanQuyen();
pq.ngay_het = ngay_het;
pq.user = id_team.ToString();
pq.type = PhanQuyenType.GROUP_USERS;
pq.rule = (PhanQuyenRule)rule;
pq.quyen = quyen;
pq.nguoi_tao = user;
pq.obj_type = (PhanQuyenObjType)obj_type;
pq.obj_id = id;
res.success = QLCUNL.BL.PhanQuyenBL.Index(pq);
}
}
}
}
catch (Exception)
{
}
#endregion
}
}
catch (Exception ex)
{
res.msg = ex.Message; res.success = false;
}
return(Ok(res));
}
public IActionResult Post([FromBody] object value)
{
DataResponse res = new DataResponse();
try
{
res.success = false;
string json = value.ToString();
var obj_tk = Newtonsoft.Json.Linq.JToken.Parse(json);
if (obj_tk != null)
{
if (obj_tk["thuoc_tinh_rieng"] != null)
{
var data = Newtonsoft.Json.JsonConvert.DeserializeObject <ThuocTinhDuLieu>(json);
data.thuoc_tinh = obj_tk["thuoc_tinh_rieng"].ToObject <List <int> >();
if (data.thuoc_tinh.Count > 0)
{
bool is_valid = true;
if (((int)data.loai_obj) == -1)
{
res.msg = "Cần chọn đối tượng";
is_valid = is_valid & false;
}
else
{
is_valid = is_valid & true;
if (data.thuoc_tinh == null || (data.thuoc_tinh != null && data.thuoc_tinh.Count == 0))
{
res.msg = "Cần chọn thuộc tính";
is_valid = is_valid & false;
}
else
{
is_valid = is_valid & true;
if (string.IsNullOrEmpty(data.id_obj))
{
res.msg = "Thiếu ID đối tượng";
is_valid = is_valid & false;
}
else
{
is_valid = is_valid & true;
}
}
}
if (is_valid)
{
SetMetaData(data, false);
res.success = QLCUNL.BL.ThuocTinhDuLieuBL.Index(data);
}
}
}
if (obj_tk["thuoc_tinh"] != null)
{
string id = obj_tk["id_obj"].ToString();
string loai_obj = obj_tk["loai_obj"].ToString();
var thuoc_tinh = obj_tk["thuoc_tinh"].ToObject <List <int> >();
switch (loai_obj)
{
case "JOB":
res.success = JobBL.UpdateThuocTinh(id, thuoc_tinh);
break;
case "CONG_TY":
res.success = CongTyBL.UpdateThuocTinh(id, thuoc_tinh);
break;
case "NOTE_UNG_VIEN":
res.success = NoteUngVienBL.UpdateThuocTinh(id, thuoc_tinh);
break;
case "UNG_VIEN":
res.success = UngVienBL.UpdateThuocTinh(id, thuoc_tinh);
break;
case "NOTE_UNG_VIEN_JOB":
res.success = NoteUngVienJobBL.UpdateThuocTinh(id, thuoc_tinh);
break;
case "USER_JOB":
res.success = UserJobBL.UpdateThuocTinh(id, thuoc_tinh);
break;
}
}
}
}
catch (Exception ex)
{
res.msg = ex.Message; res.success = false;
}
return(Ok(res));
}
public bool Delete(string id)
{
bool del = UserJobBL.Delete(id);
return(del);
}
public IActionResult ThongKeThuocTinh(string term, string id_ung_vien, string id_cong_ty, long ngay_di_lam_from, long ngay_di_lam_to,
double don_gia_from, double don_gia_to, string thuoc_tinh, string thuoc_tinh_rieng, string op, string thuoc_tinh2, string thuoc_tinh_rieng2, string op2, long ngay_tao_from, long ngay_tao_to, int page)
{
List <string> lst_id = new List <string>();
List <string> lst_id_obj_thuoc_tinh_rieng = new List <string>();
List <string> lst_id_should = new List <string>();
List <int> lst_thuoc_tinh = new List <int>();
List <int> lst_thuoc_tinh_rieng = new List <int>();
List <int> lst_thuoc_tinh2 = new List <int>();
List <int> lst_thuoc_tinh_rieng2 = new List <int>();
bool is_find_thuoc_tinh_rieng = false;
List <Job> data_job = new List <Job>();
Dictionary <string, UserJob> data_user_job = new Dictionary <string, UserJob>();
Dictionary <string, Dictionary <int, long> > dic_thong_ke_trang_thai_ung_vien_theo_job = new Dictionary <string, Dictionary <int, long> >();
long total_recs = 0;
string msg = "";
var dic_thong_ke = new Dictionary <int, long>();
var dic_thong_ke_thuoc_tinh_rieng = new Dictionary <int, long>();
if (!string.IsNullOrEmpty(thuoc_tinh))
{
foreach (var tt in thuoc_tinh.Split(','))
{
int t = -1;
if (Int32.TryParse(tt, out t))
{
lst_thuoc_tinh.Add(t);
}
}
}
if (!string.IsNullOrEmpty(thuoc_tinh2))
{
foreach (var tt in thuoc_tinh2.Split(','))
{
int t = -1;
if (Int32.TryParse(tt, out t))
{
lst_thuoc_tinh2.Add(t);
}
}
}
if (!string.IsNullOrEmpty(thuoc_tinh_rieng) || !string.IsNullOrEmpty(thuoc_tinh_rieng2))
{
if (string.IsNullOrEmpty(thuoc_tinh_rieng))
{
thuoc_tinh_rieng = "";
}
foreach (var tt in thuoc_tinh_rieng.Split(','))
{
int t = -1;
if (Int32.TryParse(tt, out t))
{
lst_thuoc_tinh_rieng.Add(t);
}
}
if (string.IsNullOrEmpty(thuoc_tinh_rieng2))
{
thuoc_tinh_rieng2 = "";
}
foreach (var tt in thuoc_tinh_rieng2.Split(','))
{
int t = -1;
if (Int32.TryParse(tt, out t))
{
lst_thuoc_tinh_rieng2.Add(t);
}
}
is_find_thuoc_tinh_rieng = true;
var lst_id_obj = BL.ThuocTinhDuLieuBL.Search(app_id, user, LoaiThuocTinh.JOB, lst_thuoc_tinh_rieng, 1, out long total_recs_thuoc_tinh, out _, 9999, op, lst_thuoc_tinh_rieng2, op2);
if (lst_id_obj.Count > 0)
{
if (op == "0")
{
lst_id_should = lst_id_obj.Select(x => x.id_obj).Distinct().ToList();
}
else
{
lst_id = lst_id_obj.Select(x => x.id_obj).Distinct().ToList();
}
lst_id_obj_thuoc_tinh_rieng = lst_id_obj.Select(x => x.id).ToList();
}
else
{
lst_id = new List <string>()
{
"__NULL__"
};
lst_id_obj_thuoc_tinh_rieng = new List <string>()
{
"__NULL__"
};
}
}
var user_job = UserJobBL.Search(app_id, user, group, new List <string>(), string.Empty, 0, 0, new List <int>(), new List <string>(), 1, out long total_user_job, out string msg_user_job, 100, (is_app_admin || is_app_admin));
List <string> lst_id_job = new List <string>();
if (user_job.Count > 0)
{
lst_id_job = user_job.Select(x => x.id_job).Distinct().ToList();
lst_id_should.AddRange(lst_id_job);
}
var tuple = BL.JobBL.ThongKeTheoThuocTinh(app_id, user, group, term, id_ung_vien, id_cong_ty, ngay_di_lam_from, ngay_di_lam_to, don_gia_from, don_gia_to, lst_thuoc_tinh, lst_id, lst_id_should,
ngay_tao_from, ngay_tao_to, page, out long _total_recs, out string _msg, 9999, (is_sys_admin || is_app_admin || is_super_user), null, op, lst_thuoc_tinh2, op2);
dic_thong_ke = tuple.Item1;
var lst_id_out = tuple.Item2;
if (lst_id_out.Count == 0)
{
lst_id_out = new List <string>()
{
"__NULL__"
};
}
//Nếu có thuộc tính chung và điều kiện là chứa tất cả thì phải tìm lại các bản ghi Job trước sau đó truyền vào bảng ThuocTinhDuLieu để tìm tiếp với các điều kiện của thuộc tính riêng
var lst_must_not_id = JobBL.GetIdDeleted(app_id);
dic_thong_ke_thuoc_tinh_rieng = ThuocTinhDuLieuBL.ThongKeTheoThuocTinh(app_id, user, LoaiThuocTinh.JOB, lst_thuoc_tinh_rieng, lst_id_out, new List <string>(), lst_must_not_id, (is_app_admin || is_app_admin), op);
return(Ok(new { data_rieng = dic_thong_ke_thuoc_tinh_rieng.Select(x => new { k = x.Key, v = x.Value }), data = dic_thong_ke.Select(x => new { k = x.Key, v = x.Value }), success = true, msg = "" }));
}
public IActionResult Search(string value_filter, long ngay_nhan_hd, long ngay_tao, string term, string id_ung_vien,
string id_cong_ty, long ngay_di_lam_from, long ngay_di_lam_to, double don_gia_from, double don_gia_to, string thuoc_tinh,
string thuoc_tinh_rieng, string op, string thuoc_tinh2, string thuoc_tinh_rieng2, string op2, long ngay_tao_from, long ngay_tao_to, int page, int page_size,
string field_sort = "", string sort = "")
{
Dictionary <string, bool> sort_order = new Dictionary <string, bool>();
if (!string.IsNullOrEmpty(field_sort) && !string.IsNullOrEmpty(sort))
{
sort_order.Add(field_sort, sort == "0" ? true : false);
}
else
{
sort_order.Add("id_auto", true);
}
var default_settings = QLCUNL.BL.UserBL.GetDefaultSettingByAppId(app_id);
List <int> lst_thuoc_tinh = new List <int>();
List <int> lst_thuoc_tinh_rieng = new List <int>();
List <int> lst_thuoc_tinh2 = new List <int>();
List <int> lst_thuoc_tinh_rieng2 = new List <int>();
List <string> lst_id = new List <string>();
List <string> lst_id_should = new List <string>();
bool is_find_thuoc_tinh_rieng = false;
List <Job> data_job = new List <Job>();
Dictionary <string, UserJob> data_user_job = new Dictionary <string, UserJob>();
Dictionary <string, Dictionary <int, long> > dic_thong_ke_trang_thai_ung_vien_theo_job = new Dictionary <string, Dictionary <int, long> >();
long total_recs = 0;
string msg = "";
if (!string.IsNullOrEmpty(thuoc_tinh))
{
foreach (var tt in thuoc_tinh.Split(','))
{
int t = -1;
if (Int32.TryParse(tt, out t))
{
lst_thuoc_tinh.Add(t);
}
}
}
if (!string.IsNullOrEmpty(thuoc_tinh_rieng) || !string.IsNullOrEmpty(thuoc_tinh_rieng2))
{
if (string.IsNullOrEmpty(thuoc_tinh_rieng))
{
thuoc_tinh_rieng = "";
}
foreach (var tt in thuoc_tinh_rieng.Split(','))
{
int t = -1;
if (Int32.TryParse(tt, out t))
{
lst_thuoc_tinh_rieng.Add(t);
}
}
if (string.IsNullOrEmpty(thuoc_tinh_rieng2))
{
thuoc_tinh_rieng2 = "";
}
foreach (var tt in thuoc_tinh_rieng2.Split(','))
{
int t = -1;
if (Int32.TryParse(tt, out t))
{
lst_thuoc_tinh_rieng2.Add(t);
}
}
is_find_thuoc_tinh_rieng = true;
var lst_id_obj = ThuocTinhDuLieuBL.Search(app_id, user, LoaiThuocTinh.JOB, lst_thuoc_tinh_rieng, 1, out long total_recs_thuoc_tinh, out _, 9999, op, lst_thuoc_tinh_rieng2, op2);
if (lst_id_obj.Count > 0)
{
if (op == "0")
{
lst_id_should = lst_id_obj.Select(x => x.id_obj).Distinct().ToList();
}
else
{
lst_id = lst_id_obj.Select(x => x.id_obj).Distinct().ToList();
}
}
else
{
lst_id = new List <string>()
{
"__NULL__"
};
}
}
if (!string.IsNullOrEmpty(thuoc_tinh2))
{
foreach (var tt in thuoc_tinh2.Split(','))
{
int t = -1;
if (Int32.TryParse(tt, out t))
{
lst_thuoc_tinh2.Add(t);
}
}
}
///lấy tất cả các UserJob đã được gán cho người dùng này, trộn cùng các Job họ tạo ra (hoặc của team mình) order lại theo ngày nhận Job và ngày Tạo Job
var user_job = UserJobBL.Search(app_id, user, group, new List <string>(), string.Empty, 0, 0, new List <int>(), new List <string>(), 1, out long total_user_job, out string msg_user_job, 100, (is_app_admin || is_app_admin));
List <string> lst_id_job = new List <string>();
if (user_job.Count > 0)
{
lst_id_job = user_job.Select(x => x.id_job).Distinct().ToList();
foreach (var item in user_job)
{
if (!data_user_job.ContainsKey(item.id_job))
{
data_user_job.Add(item.id_job, item);
}
}
lst_id_should.AddRange(lst_id_job);
}
var company = string.Empty;
if (!string.IsNullOrEmpty(id_cong_ty))
{
company = CongTyBL.GetCongTyByNameV2(app_id, id_cong_ty)?.id_cong_ty;
}
data_job = JobBL.SearchDefault(app_id, user, group, value_filter, ngay_nhan_hd, ngay_tao, term, id_ung_vien, company, ngay_di_lam_from, ngay_di_lam_to, don_gia_from, don_gia_to, lst_thuoc_tinh, lst_thuoc_tinh2, lst_id, lst_id_should,
ngay_tao_from, ngay_tao_to, page, out total_recs, out msg, page_size, (is_sys_admin || is_app_admin || is_super_user), null, op, op2, sort_order);
dic_thong_ke_trang_thai_ung_vien_theo_job = NoteUngVienJobBL.ThongKeTrangThaiUngVien(app_id, user, default_settings.trang_thai_thong_ke_ung_vien_job,
data_job.Select(x => x.id_job), data_job.Where(x => x.owner == user).Select(x => x.id_job),
(is_app_admin | is_super_user | is_sys_admin));
//
var lst_id_thuoc_tinh = data_job.Where(x => x.thuoc_tinh != null).SelectMany(x => x.thuoc_tinh).ToList();
List <JobThuocTinhMap> lst_job_map = new List <JobThuocTinhMap>();
var dic_thuoc_tinh_rieng = ThuocTinhDuLieuBL.GetIdThuocTinhByIdObj(app_id, data_job.Select(x => x.id_job), user);
if (dic_thuoc_tinh_rieng.Count > 0)
{
foreach (var tt_r in dic_thuoc_tinh_rieng)
{
lst_id_thuoc_tinh.AddRange(tt_r.Value);
}
}
var data_thuoc_tinh = ThuocTinhBL.GetManyByGiaTri(app_id, lst_id_thuoc_tinh, LoaiThuocTinh.JOB, -1);
//
var all_thuoc_tinh_job = ThuocTinhBL.GetAllByLoaiThuocTinh(app_id, (int)LoaiThuocTinh.JOB, -1);
var all_thuoc_tinh_note_ung_vien_job = ThuocTinhBL.GetAllByLoaiThuocTinh(app_id, (int)LoaiThuocTinh.NOTE_UNG_VIEN_JOB, 0);
var lst_id_cong_ty = data_job.Where(x => x.cong_ty != null && !string.IsNullOrEmpty(x.cong_ty.id_cong_ty)).Select(x => x.cong_ty.id_cong_ty);
var lst_cong_ty = QLCUNL.BL.CongTyBL.GetMany(lst_id_cong_ty);
Dictionary <string, string> dic_cong_ty = new Dictionary <string, string>();
Dictionary <string, long> dic_count_user_job_theo_job = UserJobBL.ThongKeUserJob(app_id, data_job.Select(x => x.id_job));
if (lst_cong_ty != null)
{
dic_cong_ty = lst_cong_ty.ToDictionary(x => x.id_cong_ty, y => y.ten_cong_ty);
}
foreach (var item in data_job)
{
dic_thuoc_tinh_rieng.TryGetValue(item.id_job, out List <int> tt_rieng);
if (tt_rieng == null)
{
tt_rieng = new List <int>();
}
if (item.cong_ty != null && !string.IsNullOrEmpty(item.cong_ty.id_cong_ty))
{
dic_cong_ty.TryGetValue(item.cong_ty.id_cong_ty, out string ten_cong_ty);
item.cong_ty.ten_cong_ty = ten_cong_ty;
}
var jo = new JobThuocTinhMap(item, all_thuoc_tinh_job, tt_rieng);
// tìm nhà tuyển dụng bằng id_job để lấy số ứng viên đã gửi
var get_note_uv_job_by_ntd = NhaTuyenDungBL.GetListNtdByIdJob(item.id_job);
var list_share = new List <string>();
if (get_note_uv_job_by_ntd != null)
{
foreach (var ntd in get_note_uv_job_by_ntd)
{
list_share.AddRange(ntd.lst_id_share);
}
list_share = list_share.Distinct().ToList();
if (list_share.Count > 0)
{
jo.ung_vien_da_gui = list_share.Count;
}
}
// tìm nhà tuyển dụng đã vào xem job
IList <int> lst = new List <int>();
lst.Add(-1);
long total_seen = 0;
var lst_ntd_seen = NoteBL.Search(lst, out total_seen, out msg, 9999);
var lst_ntd_get_id = lst_ntd_seen.Select(x => x.id_obj).Distinct();
var all_nha_tuyen_dung = BL.NhaTuyenDungBL.GetMany(lst_ntd_get_id).Where(x => x.id_job == item.id_job);
jo.ntd_da_xem = all_nha_tuyen_dung.Count() > 0;
//tìm xem nhà tuyển dụng đã phản hồi hay chưa
List <string> list_id_share = new List <string>();
var note_ung_vien_da_shared = all_nha_tuyen_dung.Select(x => x.lst_id_share);
foreach (var id in note_ung_vien_da_shared)
{
list_id_share.AddRange(id);
}
var id_nha_tuyen_dung = all_nha_tuyen_dung.Select(x => x.id_nha_tuyen_dung);
var nguoi_tao = string.Join(",", id_nha_tuyen_dung);
var all_note_cua_ntd = NoteBL.NhaTuyenDungNoteUngVien(list_id_share, nguoi_tao, out total_seen, out msg, 9999).Where(x => list_id_share.Contains(x.id_obj));
if (all_note_cua_ntd.Count() > 0)
{
jo.ntd_da_phan_hoi = all_note_cua_ntd.Count() > 0;
var id = all_nha_tuyen_dung.Select(x => x.id).FirstOrDefault();
jo.id_nha_tuyen_dung = string.Join(",", id);
}
jo.is_user_job = data_user_job.ContainsKey(item.id_job);
jo.is_owner = (user == (string.IsNullOrEmpty(item.owner) ? item.nguoi_tao : item.owner) || is_app_admin);
if (jo.is_user_job)
{
jo.ngay_tao = data_user_job[item.id_job].ngay_nhan_job;
jo.id_user_job = data_user_job[item.id_job].id_user_job;
}
dic_count_user_job_theo_job.TryGetValue(item.id_job, out long _so_luong_user_job);
jo.so_luong_user_job = _so_luong_user_job;
if (jo.is_owner || jo.is_user_job)
{
var thong_ke_thuoc_tinh = new List <dynamic>();
if (dic_thong_ke_trang_thai_ung_vien_theo_job.ContainsKey(item.id_job))
{
foreach (var tt in dic_thong_ke_trang_thai_ung_vien_theo_job[item.id_job])
{
var tv = all_thuoc_tinh_note_ung_vien_job.Find(f => f.gia_tri == tt.Key);
if (tv != null)
{
thong_ke_thuoc_tinh.Add(new { ten = tv.ten, gia_tri = tt.Key, total = tt.Value });
}
else
{
if (tt.Key == 0)
{
thong_ke_thuoc_tinh.Add(new { ten = "<b>Tổng số U/V</b>", gia_tri = -1, total = tt.Value });
}
}
}
}
else
{
thong_ke_thuoc_tinh.Add(new { ten = "<b>Tổng số U/V</b>", gia_tri = -1, total = 0 });
}
jo.ung_vien_thong_ke = thong_ke_thuoc_tinh;
}
lst_job_map.Add(jo);
}
return(Ok(new DataResponsePaging()
{
data = lst_job_map, total = total_recs, success = data_job != null, msg = msg
}));
}
public IActionResult SaveThuocTinh([FromBody] object value)
{
DataResponse res = new DataResponse();
try
{
//{"id_ung_vien":"123123123123", "thuoc_tinh_ung_vien":[], "ghi_chu": "gi do", "thuoc_tinh_ghi_chu":[]}
var obj = JToken.Parse(value.ToString());
if (obj != null)
{
var is_ok = false;
string id_ung_vien = obj["id_ung_vien"].ToString();
string id_note_uv_job = obj["id_obj"].ToString();
List <int> thuoc_tinh_uv_chung = obj["thuoc_tinh_uv_chung"].ToObject <List <int> >();
List <int> thuoc_tinh_uv_rieng = obj["thuoc_tinh_uv_rieng"].ToObject <List <int> >();
List <int> thuoc_tinh_job = obj["thuoc_tinh"].ToObject <List <int> >();
List <int> thuoc_tinh_job_rieng = obj["thuoc_tinh_rieng"].ToObject <List <int> >();
//thuộc tính ứng viên
is_ok = QLCUNL.BL.UngVienBL.SetThuocTinh(id_ung_vien, thuoc_tinh_uv_chung);
if (thuoc_tinh_uv_rieng.Count > 0)
{
ThuocTinhDuLieu thuoc_tinh_rieng = new ThuocTinhDuLieu();
thuoc_tinh_rieng.id_obj = id_ung_vien;
thuoc_tinh_rieng.loai_obj = LoaiThuocTinh.UNG_VIEN;
thuoc_tinh_rieng.thuoc_tinh = thuoc_tinh_uv_rieng;
SetMetaData(thuoc_tinh_rieng, false);
is_ok = is_ok | QLCUNL.BL.ThuocTinhDuLieuBL.Index(thuoc_tinh_rieng);
}
if (thuoc_tinh_job_rieng != null)
{
var data = Newtonsoft.Json.JsonConvert.DeserializeObject <ThuocTinhDuLieu>(value.ToString());
data.thuoc_tinh = thuoc_tinh_job_rieng;
if (thuoc_tinh_job_rieng.Count > 0)
{
bool is_valid = true;
if (((int)data.loai_obj) == -1)
{
res.msg = "Cần chọn đối tượng";
is_valid = is_valid & false;
}
else
{
is_valid = is_valid & true;
if (data.thuoc_tinh == null || (data.thuoc_tinh != null && data.thuoc_tinh.Count == 0))
{
res.msg = "Cần chọn thuộc tính";
is_valid = is_valid & false;
}
else
{
is_valid = is_valid & true;
if (string.IsNullOrEmpty(data.id_obj))
{
res.msg = "Thiếu ID đối tượng";
is_valid = is_valid & false;
}
else
{
is_valid = is_valid & true;
}
}
}
if (is_valid)
{
SetMetaData(data, false);
res.success = QLCUNL.BL.ThuocTinhDuLieuBL.Index(data);
}
}
}
if (thuoc_tinh_job != null)
{
string id = obj["id_obj"].ToString();
string loai_obj = obj["loai_obj"].ToString();
var thuoc_tinh = thuoc_tinh_job;
switch (loai_obj)
{
case "JOB":
res.success = JobBL.UpdateThuocTinh(id, thuoc_tinh);
break;
case "CONG_TY":
res.success = CongTyBL.UpdateThuocTinh(id, thuoc_tinh);
break;
case "NOTE_UNG_VIEN":
res.success = NoteUngVienBL.UpdateThuocTinh(id, thuoc_tinh);
break;
case "UNG_VIEN":
res.success = UngVienBL.UpdateThuocTinh(id, thuoc_tinh);
break;
case "NOTE_UNG_VIEN_JOB":
res.success = NoteUngVienJobBL.UpdateThuocTinh(id, thuoc_tinh);
break;
case "USER_JOB":
res.success = UserJobBL.UpdateThuocTinh(id, thuoc_tinh);
break;
}
}
// thuộc tính note ứng viên theo job
res.success = is_ok;
}
}
catch (Exception ex)
{
res.success = false;
res.msg = ex.Message;
}
return(Ok(res));
}
