middleware('permission:transfer-create', ['only' => ['create']]);
$this->middleware('permission:transfer-edit', ['only' => ['edit']]);
$this->middleware('permission:transfer-view', ['only' => ['view']]);
$this->middleware('permission:transfer-delete', ['only' => ['delete']]);
}
/** construct */
/** index */
public function index(Request $request){
if($request->ajax()){
$collection = DB::table('transfer as t')
->select('t.id', 't.to_branch as to_branch_id', 't.from_branch as from_branch_id', 'tb.name as to_branch', 'fb.name as from_branch', 'p.name as product', 't.status','cm.name as cm_name','cv.name as cv_name','i.vin_number as vin_number')
->leftjoin('branches as tb', 'tb.id', 't.to_branch')
->leftjoin('branches as fb', 'fb.id', 't.from_branch')
->leftjoin('inventory as i', 'i.id', 't.inventory_id')
->leftjoin('products as p', 'p.id', 'i.name')
->leftjoin('car_model as cm', 'cm.id', 'p.car_model')
->leftjoin('car_varient as cv', 'cv.id', 'p.veriant');
// if(auth()->user()->roles->pluck('name')[0] != 'admin')
// $collection->where(['t.to_branch' => auth()->user()->branch]);
$data = $collection->get();
return Datatables::of($data)
->addIndexColumn()
->addColumn('action', function($data){
$return = '';
$userBranchArray = explode(',',auth()->user()->branch);
if (auth()->user()->can('transfer-delete') && $data->status == 'pending') {
if(in_array($data->from_branch_id, $userBranchArray)){
$return = '';
$return .= '
';
$return .= '
';
$return .= '
';
$return .= '