/**
* Show a list of all the languages posts formatted for Datatables.
* Danh sách công văn đến từ bộ
* @return Datatables JSON
*/
public function databo()
{
if (Auth::check() && $this->rolechucnangs && $this->rolechucnangs->Danhsach == 1) {
$user = Auth::user();
if ($user->role->name == 'phong') {
$congvandens = Congvanden::where('nguoitao_id', Auth::user()->id)->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->orWhereIn('congvandens.id', function ($query) use($user) {
$query->select('congvanden_id')->from('congvanden_danhmucphongs')->whereRaw('congvanden_danhmucphongs.danhmucphong_id = ' . $user->phong_id);
})->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->orWhereIn('congvandens.id', function ($query) use($user) {
$query->select('congvanden_id')->from('congvanden_users')->whereRaw('congvanden_users.user_id = ' . $user->id);
})->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->join('danhmucdonvis', 'congvandens.noiphathanh_id', '=', 'danhmucdonvis.id')->select(\DB::raw('congvandens.id, congvandens.noiphathanh_id, congvandens.sohosoluubo, date_format(congvandens.ngayky, "%d/%m/%Y") as ngayky, congvandens.trichyeucongvanden,
CONCAT(congvandens.socongvandenso , "/", congvandens.socongvandenchu) as socongvanden, danhmucdonvis.name as danhmucdonvi'))->where('congvandens.phong_id', $user->phong_id)->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->orderBy('sohosoluubo', 'desc')->get();
} else {
if ($user->role->name == 'doi') {
$congvandens = Congvanden::where('nguoitao_id', Auth::user()->id)->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->orWhereIn('congvandens.id', function ($query) use($user) {
$query->select('congvanden_id')->from('congvanden_danhmucdois')->whereRaw('congvanden_danhmucdois.danhmucdoi_id = ' . $user->doi_id);
})->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->orWhereIn('congvandens.id', function ($query) use($user) {
$query->select('congvanden_id')->from('congvanden_users')->whereRaw('congvanden_users.user_id = ' . $user->id);
})->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->join('danhmucdonvis', 'congvandens.noiphathanh_id', '=', 'danhmucdonvis.id')->select(\DB::raw('congvandens.id, congvandens.noiphathanh_id, congvandens.sohosoluubo, date_format(congvandens.ngayky, "%d/%m/%Y") as ngayky, congvandens.trichyeucongvanden,
CONCAT(congvandens.socongvandenso , "/", congvandens.socongvandenchu) as socongvanden, danhmucdonvis.name as danhmucdonvi'))->where('congvandens.phong_id', $user->phong_id)->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->orderBy('sohosoluubo', 'desc')->get();
} else {
if ($user->role->name == 'canbo') {
$congvandens = Congvanden::where('nguoitao_id', Auth::user()->id)->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->orWhereIn('congvandens.id', function ($query) use($user) {
$query->select('congvanden_id')->from('congvanden_users')->whereRaw('congvanden_users.user_id = ' . $user->id);
})->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->join('danhmucdonvis', 'congvandens.noiphathanh_id', '=', 'danhmucdonvis.id')->select(\DB::raw('congvandens.id, congvandens.noiphathanh_id, congvandens.sohosoluubo, date_format(congvandens.ngayky, "%d/%m/%Y") as ngayky, congvandens.trichyeucongvanden,
CONCAT(congvandens.socongvandenso , "/", congvandens.socongvandenchu) as socongvanden, danhmucdonvis.name as danhmucdonvi'))->where('congvandens.phong_id', $user->phong_id)->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->orderBy('sohosoluubo', 'desc')->get();
} else {
if ($user->role->name == 'root') {
$congvandens = Congvanden::join('danhmucdonvis', 'congvandens.noiphathanh_id', '=', 'danhmucdonvis.id')->select(\DB::raw('congvandens.id, congvandens.noiphathanh_id, congvandens.sohosoluubo, date_format(congvandens.ngayky, "%d/%m/%Y") as ngayky, congvandens.trichyeucongvanden,
CONCAT(congvandens.socongvandenso , "/", congvandens.socongvandenchu) as socongvanden, danhmucdonvis.name as danhmucdonvi'))->orderBy('congvandens.id', 'desc')->get();
} else {
if ($user->role->name == 'admin') {
$congvandens = Congvanden::join('danhmucdonvis', 'congvandens.noiphathanh_id', '=', 'danhmucdonvis.id')->select(\DB::raw('congvandens.id, congvandens.noiphathanh_id, congvandens.sohosoluubo, date_format(congvandens.ngayky, "%d/%m/%Y") as ngayky, congvandens.trichyeucongvanden,
CONCAT(congvandens.socongvandenso , "/", congvandens.socongvandenchu) as socongvanden, danhmucdonvis.name as danhmucdonvi'))->orderBy('congvandens.id', 'desc')->get();
} else {
if ($user->role->name == 'vanthu') {
$congvandens = Congvanden::join('danhmucdonvis', 'congvandens.noiphathanh_id', '=', 'danhmucdonvis.id')->select(\DB::raw('congvandens.id, congvandens.noiphathanh_id, congvandens.sohosoluubo, date_format(congvandens.ngayky, "%d/%m/%Y") as ngayky, congvandens.trichyeucongvanden,
CONCAT(congvandens.socongvandenso , "/", congvandens.socongvandenchu) as socongvanden, danhmucdonvis.name as danhmucdonvi'))->where('congvandens.phong_id', $user->phong_id)->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->orderBy('congvandens.sohosoluubo', 'desc')->get();
}
}
}
}
}
}
$rolechucnangs = $this->rolechucnangs;
return Datatables::of($congvandens)->add_column('checkbox', '<label class="pos-rel">
<input type="checkbox" name="checkboxvalue{{ $id }}" class="ace check-box-value" value="{{ $id }}" />
<span class="lbl"></span>
</label>')->addColumn('action', '<div class="hidden-sm hidden-xs action-buttons">
@if(Auth::check() && App\\Role::checkXem("congvanden") )
<a class="tooltip-info blue" data-rel="tooltip" title="Xem" href="{{ URL::route("congvanden.show", $id) }}">
<i class="ace-icon fa fa-search-plus bigger-130"></i>
</a>
@endif
@if(Auth::check() && App\\Role::checkSua("congvanden") )
<a class="tooltip-success green" data-rel="tooltip" title="Sửa" href="{{ URL::route("congvanden.edit", $id) }}">
<i class="ace-icon fa fa-pencil bigger-130"></i>
</a>
@endif
@if(Auth::check() && App\\Role::checkXoa("congvanden") )
<a>
{!! Form::open(array("route" => array("congvanden.destroy", $id), "method" => "delete")) !!}
<button class="tooltip-error red btn-delete" data-rel="tooltip" title="Xóa" type="submit" href="{{ URL::route("congvanden.destroy", $id) }}"><i class="ace-icon fa fa-trash-o bigger-120"></i></button>
{!! Form::close() !!}
</a>
@endif
</div>')->make(true);
} else {
return \Redirect::to('/')->with('message-error', 'Không có quyền truy cập');
}
}
/**
* check cong van den file is download by user
* @param $filedown
* @param $user
* @return mixed
*/
public static function downloadcongvandenbyusername($filedown, $user)
{
$filedown_id = File::getIdByFileName($filedown);
$is_download = Congvanden::join('file_congvandens', 'congvandens.id', '=', 'file_congvandens.congvanden_id')->leftjoin('congvanden_danhmucphongs', 'congvandens.id', '=', 'congvanden_danhmucphongs.congvanden_id')->leftjoin('congvanden_danhmucdois', 'congvandens.id', '=', 'congvanden_danhmucdois.congvanden_id')->leftjoin('congvanden_users', 'congvandens.id', '=', 'congvanden_users.congvanden_id')->where('congvandens.nguoitao_id', $user->id)->orWhere('congvanden_danhmucphongs.danhmucphong_id', $user->phong_id)->orWhere('congvanden_danhmucdois.danhmucdoi_id', $user->doi_id)->orWhere('congvanden_users.user_id', $user->id)->where('file_congvandens.file_id', $filedown_id)->first();
return $is_download;
}
