middleware('auth');
}
//Tapal outbox
public function outbox(Request $request)
{
$id = Auth::user()->id;
//$creation_of_tapal=\App\Tapal::where('id',$id)->get();
$seatid=$request->session()->get('session_seat');
$department=\App\Department::all();
$section =\App\Section::all();
$priority =\App\Priority::all();
$actions = \App\Action::all();
$comments = \App\Comments::all();
$tapalinboxcount = \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();
$fileinboxcount = \App\File_forward::where('to_seat', $seatid)->where('active_flag',1)->with('file')->orderBy('created_at','DESC')->count();
$tapaloutboxcount = \App\Tapal_forward::where('from_seat', $seatid)->with('tapal')->orderBy('created_at','DESC')->count();
$fileoutboxcount = \App\File_forward::where('from_seat', $seatid)->with('file')->orderBy('created_at','DESC')->count();
$tapal_arr = \App\Tapal_forward::where('from_seat', $seatid)->where('active_flag',0)->orderBy('created_at','desc')->get();
//$values = \App\Comments::where('tapal_id',$tapal_arr)->with('seat')->orderBy('created_at','desc')->get();
// $file_forward =\App\File_forward::with('file_group')->get();
// $subject =\App\Subject::where('id',$creation_of_tapal->subject_id)->first();
return view('outbox', compact('department','section','tapal_arr','seatid','actions','priority','comments','tapalinboxcount','fileinboxcount','tapaloutboxcount','fileoutboxcount'));
}
//new modal tapal view
public function modaltapalview($id,Request $request)
{
$tapal_id= $id;
$creation_of_tapal=\App\Tapal::where('id',$id)->with('user')->first();
$tapal_no=$creation_of_tapal->tapal_no;
$description=$creation_of_tapal->tapal_description;
$confidential=$creation_of_tapal->confidential;
$tapalcreateduser=$creation_of_tapal->user->name;
//dd($tapal_no);
$tapaluserseat=\App\User_Seat::where('user_id',$creation_of_tapal->created_by)->with('seat')->first();
$tapalseat=$tapaluserseat->seat->seat_name;
$tapaldetailsarr =[];
$i=0;
$tapaldetailsarr['id']=$tapal_id;
$tapaldetailsarr['tapal_no']=' Tapal No:'." ".$tapal_no." " .$tapalseat." : " .$tapalcreateduser;
if($confidential==1)
{
$conf=', Confidential';
$tapaldetailsarr['tapal_no']=' Tapal No:'." ".$tapal_no." " .$tapalseat." : " .$tapalcreateduser .$conf;
}
$tapaldetailsarr['tapal_description']=$description;
if($creation_of_tapal->internal_external == 1)
{
$internal_external='Internal Tapal';
}
else
{
$internal_external='External Tapal';
}
$tapaldetailsarr['internal_external']=$internal_external;
$tapaldetailsarr['title']=$creation_of_tapal->title;
$tapalfrwrd=\App\Tapal_forward::where('tapal_id',$tapal_id)->where('active_flag',1)->with('tapal')->first();
$createdby=$tapalfrwrd->tapal->user->name;
$createdat=$tapalfrwrd->tapal->created_at->format('d-M-Y');
$forwardedon=$tapalfrwrd->created_at->format('d-M-Y');
$forwardedby=$tapalfrwrd->from_seat;
if(!$forwardedby)
$forwardedby="Self Generated";
else
{
$forwardseatobj=\App\Seat::where('id',$forwardedby)->first();
$forwardedby=$forwardseatobj->seat_code."::".$forwardseatobj->seat_name;
}
$tapaldetailsarr['from_seat']=$forwardedby;
$tapaldetailsarr['created_at']=$forwardedon;
$tapaldetailsarr['name']=$createdby;
$tapaldetailsarr['created_at']=$createdat;
$subject =\App\Subject::where('id',$creation_of_tapal->subject_id)->first();
$sub=$subject->subject;
$tapaldetailsarr['subject']=$sub;
if($creation_of_tapal->mode_of_receipt==0)
$mode='NA';
else if($creation_of_tapal->mode_of_receipt==1)
$mode='Fax';
else if($creation_of_tapal->mode_of_receipt==2)
$mode='Email';
else if($creation_of_tapal->mode_of_receipt==3)
$mode='By hand';
else if($creation_of_tapal->mode_of_receipt==4)
$mode='Post';
$tapaldetailsarr['mode_of_receipt']=$mode;
$prio=App\Priority::where('id',$creation_of_tapal->priority)->first();
$priority=$prio->priority;
$tapaldetailsarr['priority']=$priority;
$attachmentcount =\App\Documents::where('tapal_id',$tapal_id)->count();
$i=0;
$tapal_attchment =\App\Documents::where('tapal_id', $tapal_id)->get();
$tapaldocstr='';
foreach ($tapal_attchment as $tattachment)
{
$tapal_documentname=$tattachment->document_name;
$path=$tattachment->document_path;
$tapal_attach_createdat=$tattachment->created_at->format('d-M-Y h:i:s');
$filepath=storage_path('app/'.$path);
$size=round(filesize($filepath)/1024,1);
if($tapal_documentname)
{
$tapaldocstr.= "";
$i++;
}
}
$tapaldetailsarr['document_path']=$tapaldocstr;
$userid = Auth::user()->id;
$comments_arr = \App\Comments::where('tapal_id', $tapal_id)->with('tapal','seat')->orderBy('created_at','DESC')->get();
$commentstr ='';
$comments_count = \App\Comments::where('tapal_id', $tapal_id)->with('tapal','seat')->count();
if($comments_count==0)
{
$commentstr .= "";
}
foreach ($comments_arr as $comments_list)
{
$created_at=$comments_list->created_at->format('d-M-Y');
$tapalid=$comments_list->tapal_id;
$comment_type=$comments_list->comment_type;
$comment_description=$comments_list->comment_description;
$seatname=$comments_list->seat->seat_name;
$commentseatid=$comments_list->seat_id;
//dd($tapalid);
$checkforseatmatch=\App\User_Seat::where('user_id',$userid)->where('seat_id',$commentseatid)->count();
$currentseat=\App\User_Seat::where('user_id',$userid)->with('seat')->get();
foreach ($currentseat as $userseat)
{
$currentuserseat=$userseat->seat_id;
//dd($currentuserseat);
$currenttapalseat=\App\Tapal_forward::where('tapal_id',$tapalid)->where('active_flag',1)->first();
//foreach ($currenttapalseat as $tapalseat)
//{
$seat=$currenttapalseat->to_seat;
// dd($seat);
//}
$seatflag=0;
if($currentuserseat==$seat)
{
$seatflag=1;
}
}
if(($comment_type==1)&&($checkforseatmatch>0))
{
$commentstr .= "";
}
if($comment_type==0)
{
$commentstr .= "";
}
if(($comment_type==2) && ($comments_list->disgard_flag==0))
{
$commentstr .= " ";
}
}
}
$tapaldetailsarr['comment_description']=$commentstr;
//dd($tapaldetailsarr);
$actions_arr = \App\Tapal_action::where('tapal_id', $id)->with('tapal','seat','action')->orderBy('created_at','DESC')->get();
$actionstr ='';
$action_count = \App\Tapal_action::where('tapal_id', $id)->with('tapal','seat','action')->count();
if($action_count==0)
{
$actionstr .= "";
}
foreach ($actions_arr as $actions_list)
{
$created_at=$actions_list->created_at->format('d-M-Y');
$tapalid=$actions_list->id;
$action_type=$actions_list->action->actions;
$action_description=$actions_list->action_description;
$seatname=$actions_list->seat->seat_name;
//$actionseatid=$actions_list->seat_id;
if($action_type)
{
$actionstr .= "";
}
}
$tapaldetailsarr['action_description']=$actionstr;
$tapalattachedtofile_arr = \App\File_reference::where('tapal_id', $tapal_id)->with('file')->first();
$tapaldetailsarr['file_id']=$tapalattachedtofile_arr;
$seatid=$request->session()->get('session_seat');
$act_flg_status = 0;
$match=[['to_seat',$seatid],['tapal_id',$id]];
//print_r($match);
$current_tapaluser=\App\Tapal_forward::where($match)->get();
foreach($current_tapaluser as $tapvallist)
{
$active_flag = $tapvallist->active_flag;
if($active_flag == 1)
{
$act_flg_status = 1;
}
}
$tapaldetailsarr['active_flag']=$act_flg_status;
$user_comment_flag='';
$tapal_comment_last = \App\Comments::where('tapal_id',$tapal_id)->orderBy('created_at','DESC')->first();
if(isset($tapal_comment_last)!='')
{
$userid_last_tapalcomment = $tapal_comment_last->updated_by;
if($userid_last_tapalcomment == $userid)
{
$user_comment_flag = 1;
}
}
else
{
$user_comment_flag=0;
}
//$note="Forward button will be enabled,if alteast one note is entered by the current seat.";
$tapaldetailsarr['user_comment_flag']=$user_comment_flag;
//$tapaldetailsarr['note']=$note;
//dd($user_comment_flag);
$priorityfile=App\Priority::all();
return $tapaldetailsarr;
}
public function tapal_view($id,Request $request)
{
$tapal_id= $id;
$creation_of_tapal=\App\Tapal::where('id',$id)->first();
//dd($creation_of_tapal);
$priority=App\Priority::where('id',$creation_of_tapal->priority)->first();
$priorityfile=App\Priority::all();
$subject_group =\App\Subject_Group::where('id',$creation_of_tapal->subject_group_id)->first();
$subject =\App\Subject::where('id',$creation_of_tapal->subject_id)->first();
$department=\App\Department::all();
$section =\App\Section::all();
$seat =\App\Seat::all();
$actions =\App\Action::all();
$file_groups =\App\File_Group::all();
$username = Auth::user()->name;
$values = \App\Comments::where('tapal_id',$tapal_id)->with('seat')->orderBy('created_at','desc')->get();
$tapal_action =\App\Tapal_action::all();
$userid = Auth::user()->id;
$seatid=$request->session()->get('session_seat');
$seatid_new=$seatid;
$seatobj=\App\Seat::where('id',$seatid)->first();
$seatname= $seatobj->seat_name;
$act_flg_status = "";
$match=[['to_seat',$seatid_new],['tapal_id',$id]];
$current_tapaluser=\App\Tapal_forward::where($match)->get();
foreach($current_tapaluser as $tapvallist)
{
$active_flag = $tapvallist->active_flag;
if($active_flag == 1)
{
$act_flg_status = 1;
}
else
{
$act_flg_status = 0;
}
}
$yr=date("Y");
$filesearch='%'.$yr;
$fileobj=\App\File::select('file_no')->where("file_no",'like',$filesearch)->orderBy('id','desc')->first();
if($fileobj)
{
$lastfileno=$fileobj->file_no;
$filearr=explode("/",$lastfileno);
$lastfileint=$filearr[1];
$fileno=$lastfileint+1;
}
else
$fileno=1;
$fileprint="FILE/".$fileno."/".$yr;
//$new_tapaluser=\App\Tapal_forward::where('from_seat',$seatid)->get();
//dd($act_flg_status);
// dd($current_tapaluser);
return view('tapal_view', compact('values','seatid_new','username','subject_group','subject','creation_of_tapal','department','section','seat','act_flg_status','actions','tapal_action','file_groups','fileprint','priority','priorityfile'));
}
public function outboxjson(Request $request)
{
$id = Auth::user()->id;
$seatid=$request->session()->get('session_seat');
$id = Auth::user()->id;
$outboxs = \App\Tapal_forward::where('from_seat', $seatid)->with('tapal')->orderBy('created_at','DESC')->get();
$data = [];
$i=0;
foreach ($outboxs as $outbox)
{
$id=$outbox->id;
$tapalno=$outbox->tapal->tapal_no;
$tapalid=$outbox->tapal->id;
$priority=$outbox->tapal->priority;
$createdby=$outbox->tapal->user->name;
$prioritylabelobj=\App\Priority::where('id',$priority)->first();
$priority=$prioritylabelobj->priority;
$valuables=$outbox->tapal->has_valuables;
$date=$outbox->tapal->created_at->format('d-M-Y');;
$title=$outbox->tapal->title;
$confidential=$outbox->tapal->confidential;
////////////to get the forwarded by seat////////////////////
$forwardedby=$outbox->from_seat;
if(!$forwardedby)
$forwardedby="Self Generated"; //////////////first time from_seat will be 0////////////////
else
{
$forwardseatobj=\App\Seat::where('id',$forwardedby)->first();
$forwardedby=$forwardseatobj->seat_code."::".$forwardseatobj->seat_name;
}
//to get forwarded to_seat
// $outbox_forwrd_toseat = \App\Tapal_forward::where('from_seat', $seatid)->where('tapal_id',$tapalid)->first();
//dd($outbox_forwrd_toseat);
$forwardedto=$outbox->to_seat;
$forwardtoseatobj=\App\Seat::where('id',$forwardedto)->first();
$forwardedtonew=$forwardtoseatobj->seat_code."::".$forwardtoseatobj->seat_name;
/////count of comments -- tapal/////////////////////
$match_comments = [['tapal_id','=',$tapalid],['comment_type','=',0]];
$tapalcommentcount=\App\Comments::where($match_comments)->count();
/////count of actions -- tapal/////////////////////
$match_actions = [['tapal_id','=',$tapalid]];
$tapalactioncount=\App\Tapal_action::where($match_actions)->count();
/////count of attachments -- tapal/////////////////////
$match_attachments = [['tapal_id','=',$tapalid]];
$tapalattachmentcount=\App\Documents::where($match_attachments)->count();
///////////////////////////////////////////////////////////////////
$forwardedon=$outbox->created_at->format('d-M-Y');
$fdate=new \DateTime($forwardedon);
$cdate=new \DateTime();
$diff='';
$diff=date_diff($fdate,$cdate);
$noofdays= $diff->format("%a days");
$subjectgroup=$outbox->tapal->subject_groupobj->subject_group;
$obj = new \stdClass;
$obj->incid = $i + 1;
$obj->id = $id;
$obj->tapalid = $tapalid;
$obj->tapal_no = $tapalno;
$obj->title = $title;
$obj->created_at = $date;
$obj->createdby = $createdby;
$obj->from_seat = $forwardedby;
$obj->to_seat = $forwardedtonew;
$obj->forwardedon = $forwardedon."(".$noofdays.")" ;
$obj->subject_group = $subjectgroup;
$obj->priority = $priority;
$obj->tapalcommentcount = $tapalcommentcount;
$obj->tapalactioncount = $tapalactioncount;
$obj->tapalattachmentcount = $tapalattachmentcount;
//$obj->priority = $priority;
$obj->confidential = $confidential;
$obj->valuables = $valuables;
$data[$i] = $obj;
$i++;
}
$outboxjson = collect($data);
return Datatables::of($outboxjson)
->make(true);
// return Datatables::of($inboxs)->make(true);
}
public function getcomment($id)
{
$userid = Auth::user()->id;
$comments_arr = \App\Comments::where('tapal_id', $id)->with('tapal','seat')->orderBy('created_at','DESC')->get();
$commentstr ='';
foreach ($comments_arr as $comments_list)
{
$created_at=$comments_list->created_at->format('d-M-Y');
$tapalid=$comments_list->id;
$comment_type=$comments_list->comment_type;
$comment_description=$comments_list->comment_description;
$seatname=$comments_list->seat->seat_name;
$commentseatid=$comments_list->seat_id;
$checkforseatmatch=\App\User_Seat::where('user_id',$userid)->where('seat_id',$commentseatid)->count();
if(($comment_type==1)&&($checkforseatmatch>0))
{
$commentstr .= "$seatname noted at $created_at
$seatname noted at $created_at
$seatname noted at $created_at
$seatname noted at $created_at
";
$fileviewtemplateid=$titledisp->id;
$title=$titledisp->template->title;
$name=$titledisp->user->name;
$created_at=$titledisp->created_at->format("d-m-Y H:i:s");
$tempstr .="$title last modified by $name on $created_at";
$fileviewtemplateapprovedby=$titledisp->approved_by;
if($fileviewtemplateapprovedby!=0)
{
$approveuser=\App\User::where('id',$fileviewtemplateapprovedby)->first();
$approveduser=$approveuser->name;
}
$fileviewtemplatearr[$fileviewtemplateid]=$approveduser;
if($titledisp->approval_flag==1)
{
$tempstr .="approved by $approveduser";
}
$tempstr .="
| ";
if($titledisp->approval_flag==0)
{
$tempstr .="";
}
if($titledisp->approval_flag==1)
{
$tempstr .="";
}
$tempstr .=" |
";
}
$filedetailsarr['temp']=$tempstr;
//dd($filedetailsarr);
return $filedetailsarr;
}
} 