public function applicationUserRequest(Request $request) { $statusObject = array("applied" => array("step" => "สมัครขอทุน", "appStatus" => "Pending", "approve" => "approved", "reject" => "rejected"), "rejected" => array("step" => "สมัครขอทุน", "appStatus" => "Reject"), "approved" => array("step" => "สมัครขอทุน", "appStatus" => "Approve"), "signed_agreement" => array("step" => "ทำสัญญารับทุน", "appStatus" => "Pending", "approve" => "approved_agreement", "reject" => "rejected_agreement", "files" => array(1, 2, 22)), "rejected_agreement" => array("step" => "ทำสัญญารับทุน", "appStatus" => "Reject", "files" => array(1, 2, 22)), "approved_agreement" => array("step" => "ทำสัญญารับทุน", "appStatus" => "Approve"), "first_payment" => array("step" => "เบิกเงินงวดที่ 1", "appStatus" => "Pending", "approve" => "approved_first_payment", "reject" => "rejected_first_payment", "files" => array(3, 4, 5, 6)), "rejected_first_payment" => array("step" => "เบิกเงินงวดที่ 1", "appStatus" => "Reject", "files" => array(3, 4, 5, 6)), "approved_first_payment" => array("step" => "เบิกเงินงวดที่ 1", "appStatus" => "Approve"), "second_payment" => array("step" => "รายงานความก้าวหน้าครั้งที่ 1", "appStatus" => "Pending", "approve" => "approved_second_payment", "reject" => "rejected_second_payment", "files" => array(7, 8, 9)), "rejected_second_payment" => array("step" => "รายงานความก้าวหน้าครั้งที่ 1", "appStatus" => "Reject", "files" => array(7, 8, 9)), "approved_second_payment" => array("step" => "รายงานความก้าวหน้าครั้งที่ 1", "appStatus" => "Approve"), "second_progress_report" => array("step" => "รายงานความก้าวหน้าครั้งที่ 2", "appStatus" => "Pending", "approve" => "approved_second_progress_report", "reject" => "rejected_second_progress_report", "files" => array(10, 11)), "rejected_second_progress_report" => array("step" => "รายงานความก้าวหน้าครั้งที่ 2", "appStatus" => "Reject", "files" => array(10, 11)), "approved_second_progress_report" => array("step" => "รายงานความก้าวหน้าครั้งที่ 2", "appStatus" => "Approve"), "finalized" => array("step" => "ส่งผลงานเพื่อปิดโครงการ", "appStatus" => "Pending", "approve" => "approved_finalized", "reject" => "rejected_finalized", "files" => array(17, 18, 19, 20, 21, 23, 24)), "rejected_finalized" => array("step" => "ส่งผลงานเพื่อปิดโครงการ", "appStatus" => "Reject", "files" => array(17, 18, 19, 20, 21, 23, 24)), "approved_finalized" => array("step" => "ส่งผลงานเพื่อปิดโครงการ", "appStatus" => "Approve"), "request_extend" => array("step" => "ขอขยายเวลา", "appStatus" => "Pending", "approve" => "approved_extend", "reject" => "rejected_extend", "files" => array(14, 15, 16)), "rejected_extend" => array("step" => "ขอขยายเวลา", "appStatus" => "Reject", "files" => array(14, 15, 16)), "approved_extend" => array("step" => "ขอขยายเวลา", "appStatus" => "Approve"), "project_finished" => array("step" => "ปิดโครงการ", "appStatus" => "Pending", "approve" => "approved_project_finished", "reject" => "rejected_project_finished", "files" => array(17, 18, 19, 20, 21, 23, 24)), "rejected_project_finished" => array("step" => "ปิดโครงการ", "appStatus" => "Reject", "files" => array(17, 18, 19, 20, 21, 23, 24)), "approved_project_finished" => array("step" => "ปิดโครงการ", "appStatus" => "Approve")); $id = $request->get('id', null); $applications = DB::table('applications')->join('funds', 'applications.fund', '=', 'funds.id')->join('users', 'applications.owner', '=', 'users.id')->where('fund', $id)->select('applications.id', 'applications.status', 'funds.name as fundName', 'users.name as userName')->get(); $fund = Fund::find($id); if (!$fund) { return redirect()->route('fund_user_request_choose'); } for ($i = 0; $i < count($applications); $i++) { $applications[$i]->step = $statusObject[$applications[$i]->status]['step']; $applications[$i]->appStatus = $statusObject[$applications[$i]->status]['appStatus']; $applications[$i]->documents = null; if ($applications[$i]->appStatus != 'Approve') { if ($applications[$i]->appStatus == 'Pending') { $applications[$i]->approve = $statusObject[$applications[$i]->status]['approve']; $applications[$i]->reject = $statusObject[$applications[$i]->status]['reject']; } if ($applications[$i]->status != 'applied' && $applications[$i]->status != 'rejected') { $documents = []; $files = $statusObject[$applications[$i]->status]['files']; for ($j = 0; $j < count($files); $j++) { $upload = Upload::where('filetype', $files[$j])->where('application_id', $applications[$i]->id)->first(); $filetype = Filetype::find($upload->filetype); array_push($documents, array("file_name" => $filetype->name, "file_path" => $upload->file_path, "file_status" => $upload->status, "upload_id" => $upload->id)); } $applications[$i]->documents = $documents; } } } return view('admin.fund_user_request', ['applications' => $applications, 'fundName' => $fund->name]); }
/** * Gets a multidimensional array of all of the centers * and the accounts that belong to each. * * @param $center_id * @return array */ public static function getCenter($center_id = false) { $centers = []; if ($center_id) { array_push($centers, Fund::find($center_id)); } else { foreach (Fund::all() as $fund) { array_push($centers, $fund); } } return $centers; }
public function fundFormFileUpload(Request $request) { $fundId = $request->get('id', 0); $fund = Fund::find($fundId); if (!$fund) { return redirect()->route('fund_manage'); } return view('admin.fund_form_file_upload', ['fundId' => $fundId]); }
public function manualnotify(Request $request) { $app_id = $request->get('appid'); $application = Application::find($app_id); // die($application); $fund = Fund::find($application->fund); // print_r($applications); $data = array(); $data['application'] = $application; $data['user'] = $application->user; $data['fund'] = $fund; Mail::queue('emails.autonotify', $data, function ($message) use($data) { $message->to($data['user']->email, $data['user']->name)->subject('You have uncompleted applications at nurse.tu.ac.th'); }); echo "success"; }
public function fundDelete($id) { $fund = Fund::find($id); $fund->delete(); return redirect()->route('fund_manage'); }