No Actions added yet !!!";
}
return $actionstr;
}
/////attachment insertion in file inbox
public function file_attachmentpost1(Request $request)
{
$this->validate($request,[
'upload1' => 'required'
]);
// $id = Auth::user()->id;
$userid = Auth::user()->id;
$seatid_new = $request->session()->get('session_seat');
$uploadcount=$request->uploadcount;
$file_id=$request->creation_of_file;
for($i=1;$i<=$uploadcount;$i++)
{
$filename="upload".$i;
$filedescrem="filedesc".$i;
$filedesc=$request->$filedescrem;
if ($request->hasFile($filename)) {
$fileobj=$request->file($filename)->getClientOriginalName();
$destpath="uploads";
$custom_file_name = time().'-'.$userid.'-'.$fileobj;
$path = $request->file($filename)->storeAs($destpath,$custom_file_name);
$document_id = \App\Documents::create([//model name database field name
'file_id' => $file_id,
'document_path' => $path,
'document_name' => $filedesc,
'updated_by'=>$userid
]);
}
}
if($document_id)
// $sendmessage="Attachment Added!";
notify()->success('Attachment Added!');
else
// $sendmessage="Error Occurred Pls recheck!";
smilify('Error', 'Error Occurred Pls recheck!');
return redirect()->back();
}
//////////////////////////
//attachments
public function getattachment1($id)
{
$userid = Auth::user()->id;
$attachments_arr = \App\Documents::where('file_id', $id)->with('file')->orderBy('created_at','DESC')->get();
//dd($attachments_arr);
$attachmentstr ='';
$data = [];
$attachment_count = \App\Documents::where('file_id', $id)->with('file')->count();
$i=0;
foreach ($attachments_arr as $attachments_list)
{
$created_at=$attachments_list->created_at->format('d-M-Y');
$fileid=$attachments_list->id;
$document_path=$attachments_list->document_path;
$document_name=$attachments_list->document_name;
//$seatname=$attachments_list->seat->seat_name;
if($document_path)
{
$attachmentstr = "";
}
$data[$i] = $attachmentstr;
$i++;
}
//attached tapal attachments
$tapalattachments_arr = \App\File_reference::where('file_id', $id)->with('tapal')->get();
foreach ($tapalattachments_arr as $tapalattachment_arr)
{
$tapalid=$tapalattachment_arr->tapal_id;
$attachment_count += \App\Documents::where('tapal_id', $tapalid)->with('tapal')->count();
$attachments = \App\Documents::where('tapal_id', $tapalid)->with('tapal')->orderBy('created_at','DESC')->get();
//dd($comments);
$attachmentstr='';
foreach ($attachments as $att)
{
$created_at=$att->created_at->format('d-M-Y');
$tapalno=$att->tapal->tapal_no;
$document_path=$att->document_path;
$document_name=$att->document_name;
if($document_path)
{
$attachmentstr = "";
$data[$i] = $attachmentstr;
$i++;
}
}//end of $comments foreach
}
if($attachment_count==0)
{
$attachmentstr .= "No Attachments uploaded yet !!!";
$data[0] = $attachmentstr;
}
return $data;
}
public function tapalreport(Request $request)
{
$userid = Auth::user()->id;
$seatid=$request->session()->get('session_seat');
$inboxtapals = \App\Tapal_forward::whereHas('tapal', function ($query) {
$query->where('status','=','0')->with('user');
})->where('to_seat', $seatid)->where('active_flag',1)->with('tapal')->orderBy('created_at','desc')->get();
$i=0;
$data=[];
foreach($inboxtapals as $inboxtapal)
{
$id=$inboxtapal->id;
//tapalno
$tapalno=$inboxtapal->tapal->tapal_no;
$priority=$inboxtapal->tapal->priority;
$prioritylabelobj=\App\Priority::where('id',$priority)->first();
//tapalpriority
$priority=$prioritylabelobj->priority;
$subject=$inboxtapal->tapal->subject_id;
$subjectobj=\App\Subject::where('id',$subject)->first();
//tapalsubject
$subjects=$subjectobj->subject;
//tapaltitle
$title=$inboxtapal->tapal->title;
//tapalforwardedby
$forwardedby=$inboxtapal->from_seat;
if(!$forwardedby)
$forwardedby="Self Generated";
else
{
$forwardseatobj=\App\Seat::where('id',$forwardedby)->first();
$forwardedby=$forwardseatobj->seat_code."::".$forwardseatobj->seat_name;
}
//dd($inboxtapals);
$forwardedon=$inboxtapal->created_at->format('d-M-Y');
$fdate=new \DateTime($forwardedon);
$cdate=new \DateTime();
$diff='';
$diff=date_diff($fdate,$cdate);
$noofdays= $diff->format("%a days");
if($noofdays>10)
{
$data[$i]['tapalno']=$tapalno;
$data[$i]['title']=$title;
$data[$i]['subject']=$subjects;
$data[$i]['priority']=$priority;
$data[$i]['forwardedby']=$forwardedby;
$data[$i]['pendingdays']=$noofdays;
$i++;
}
}
return view('tapalreports',compact('data'));
}
public function filereport(Request $request)
{
$userid=Auth::user()->id;
$seatid=$request->session()->get('session_seat');
$inboxfiles = \App\File_forward::whereHas('file', function ($query) {
$query->with('user');
})->where('to_seat', $seatid)->where('active_flag',1)->with('file')->orderBy('created_at','desc')->get();
//dd($inboxs);
$data = [];
$i=0;
foreach ($inboxfiles as $inboxfile)
{
$id=$inboxfile->id;
//fileno
$fileno=$inboxfile->file->file_no;
//filetitle
$title=$inboxfile->file->title;
//filepriority
$priority=$inboxfile->file->priority;
$filegroup=$inboxfile->file->file_group_id;
$filearr=\App\File_Group::where('id',$filegroup)->first();
//filesub
$filesub=$filearr->file_group;
$referencenumber=$inboxfile->file->reference_number;
$forwardedby=$inboxfile->from_seat;
if(!$forwardedby)
$forwardedby="Self Generated";
else
{
$forwardseatobj=\App\Seat::where('id',$forwardedby)->first();
$forwardedby=$forwardseatobj->seat_code."::".$forwardseatobj->seat_name;
}
/////////////////////////////////////////
$forwardedon=$inboxfile->created_at->format('d-M-Y');
$fdate=new \DateTime($forwardedon);
$cdate=new \DateTime();
$diff='';
$diff=date_diff($fdate,$cdate);
$noofdays= $diff->format("%a days");
if($noofdays>10)
{
$data[$i]['fileno']=$fileno;
$data[$i]['filetitle']=$title;
$data[$i]['filegroup']=$filesub;
$data[$i]['referenceno']=$referencenumber;
$data[$i]['priority']=$priority;
$data[$i]['forwardedby']=$forwardedby;
$data[$i]['pendingdays']=$noofdays;
$i++;
}
}
return view('filereports1',compact('data'));
}
/////////////////////////////tapal and file report for admin...
public function tapalcountlist(Request $request )
{
$seats=\App\Seat::get();
$data=[];
$i=0;
foreach($seats as $seat)
{
$seatid=$seat->id;
$seatcode=$seat->seat_code;
$seatname=$seat->seat_name;
$inboxfilecount=0;
$inboxtapalcount=0;
$inboxtapalcount = \App\Tapal_forward::whereHas('tapal', function ($query) {
$query->where('status','=','0')->with('user');
})->where('to_seat', $seatid)->where('active_flag',1)->with('tapal')->orderBy('created_at','desc')->count();
$inboxfilecount = \App\File_forward::whereHas('file', function ($query) {
$query->with('user');
})->where('to_seat', $seatid)->where('active_flag',1)->with('file')->orderBy('created_at','desc')->count();
if(($inboxtapalcount>=0)||($inboxfilecount>=0))
{
$data[$i]['seatid']=$seatid;
$data[$i]['seatcode']=$seatcode;
$data[$i]['seatname']=$seatname;
$data[$i]['tapalcount']=$inboxtapalcount;
$data[$i]['filecount']=$inboxfilecount;
$i++;
}
}
return view('admintflist',compact('data'));
}
/////////////////////// pending tapals and files for seats for morethan 10 days
public function pendingtapalcountlist(Request $request)
{
$data=[];
$data1=[];
$i=0;
$j=0;
$seats=\App\Seat::get();
foreach($seats as $seat)
{
$seatid=$seat->id;
$seatcode=$seat->seat_code;
$inboxtapals = \App\Tapal_forward::whereHas('tapal', function ($query) {
$query->where('status','=','0')->with('user');
})->where('to_seat', $seatid)->where('active_flag',1)->with('tapal')->orderBy('created_at','desc')->get();
foreach($inboxtapals as $inboxtapal)
{
$tapalno=$inboxtapal->tapal->tapal_no;
$forwardedon=$inboxtapal->created_at->format('d-M-Y');
$fdate=new \DateTime($forwardedon);
$cdate=new \DateTime();
$diff='';
$diff=date_diff($fdate,$cdate);
$noofdays= $diff->format("%a days");
if($noofdays>10)
{
$data[$i]['seatid']=$seatid;
$data[$i]['seatcode']=$seatcode;
$data[$i]['tapalno']=$tapalno;
$data[$i]['pendingdays']=$noofdays;
$i++;
}
}
////////////////files
$inboxfiles = \App\File_forward::whereHas('file', function ($query) {
$query->with('user');
})->where('to_seat', $seatid)->where('active_flag',1)->with('file')->orderBy('created_at','desc')->get();
foreach($inboxfiles as $inboxfile)
{
$fileno=$inboxfile->file->file_no;
$forwardedfon=$inboxfile->created_at->format('d-M-Y');
$fdate=new \DateTime($forwardedfon);
$cdate=new \DateTime();
$diffe=date_diff($fdate,$cdate);
$noofdays=$diffe->format("%a days");
if($noofdays>10)
{
$data1[$j]['seatid']=$seatid;
$data1[$j]['seatcode']=$seatcode;
$data1[$j]['fileno']=$fileno;
$data1[$j]['pendingdays']=$noofdays;
$j++;
}
}
}
return view('pendingtflists',compact('data','data1'));
}
//end of InboxController function
}
