public function getreport() { $data = getmemulist(); $this->pageSetting(['menu_group_id' => 58, 'menu_id' => 6, 'title' => getMenuName($data, 58, 6) . '| MEA FUND']); //->with(); return view('backend.pages.report6'); }
public function getAdd() { $data = getmemulist(); $this->pageSetting(['menu_group_id' => 59, 'menu_id' => 1, 'title' => getMenuName($data, 59, 1) . ' | MEA']); // $menucate= DB::table('TBL_NEWS_CATE')->get(); return view('backend.pages.c57_1_add'); }
public function getsimple() { $data = getmemulist(); $this->pageSetting(['menu_group_id' => 51, 'menu_id' => 5, 'title' => getMenuName($data, 51, 5) . " | MEA"]); //$user_group = DB::table('TBL_PRIVILEGE')->select('USER_PRIVILEGE_ID','USER_PRIVILEGE_DESC')->orderBy('USER_PRIVILEGE_ID', 'asc')->get(); return view('backend.pages.userprofit'); }
public function getindex() { $data = getmemulist(); $this->pageSetting(['menu_group_id' => 55, 'menu_id' => 1, 'title' => getMenuName($data, 55, 1) . ' | MEA']); $location = DB::table('TBL_MAP_LOCATION')->get()[0]; return view('backend.pages.c55_1')->with(['location' => $location]); }
public function getEdit($id) { $data = getmemulist(); $this->pageSetting(['menu_group_id' => 54, 'menu_id' => 1, 'title' => getMenuName($data, 54, 1) . ' | MEA']); //if(isset($id)) abort(404); $Topicdata = DB::table('TBL_FAQ_CATE')->where("FAQ_CATE_ID", "=", $id)->get()[0]; return view('backend.pages.54_1_edit_page')->with(['Topicdata' => $Topicdata]); }
public function getEdit($id) { $data = getmemulist(); $this->pageSetting(['menu_group_id' => 52, 'menu_id' => 1, 'title' => getMenuName($data, 52, 1) . ' | MEA']); $editdata = DB::table('TBL_INVESTMENT_PLAN')->where("PLAN_ID", "=", $id)->get()[0]; //if(isset($id)) abort(404); return view('backend.pages.edit_page')->with(['editdata' => $editdata]); }
public function getforward($id) { $data = getmemulist(); $this->pageSetting(['menu_group_id' => 55, 'menu_id' => 2, 'title' => getMenuName($data, 55, 2) . ' | MEA']); //if(isset($id)) abort(404); $Topicdata = DB::table('TBL_INFORM')->where("INFM_ID", "=", $id)->get()[0]; return view('backend.pages.55_2_forward_page')->with(['Topicdata' => $Topicdata]); }
public function getreport1() { $data = getmemulist(); $this->pageSetting(['menu_group_id' => 58, 'menu_id' => 1, 'title' => getMenuName($data, 58, 1) . '| MEA FUND']); $allquery = "SELECT * FROM TBL_INVESTMENT_PLAN"; $planlist = DB::select(DB::raw($allquery)); return view('backend.pages.report1')->with(['planlist' => $planlist]); }
public function getEdit($id) { $data = getmemulist(); $this->pageSetting(['menu_group_id' => 54, 'menu_id' => 1, 'title' => getMenuName($data, 54, 1) . ' | MEA']); //if(isset($id)) abort(404); $quiz = DB::table('TBL_RISK_QUIZ')->where("QUIZ_ID", "=", $id)->get()[0]; return view('backend.pages.56_1_add_page')->with(['quiz' => $quiz]); }
public function getreport() { $data = getmemulist(); $this->pageSetting(['menu_group_id' => 58, 'menu_id' => 7, 'title' => getMenuName($data, 58, 7) . '| MEA FUND']); //->with(); $allquery = "SELECT * FROM TBL_USER_STATUS"; $planlist = DB::select(DB::raw($allquery)); return view('backend.pages.report7')->with(['planlist' => $planlist]); }
public function getEdit($id) { $data = getmemulist(); $this->pageSetting(['menu_group_id' => 53, 'menu_id' => 1, 'title' => getMenuName($data, 53, 1) . ' | MEA']); $menugroup = DB::table('TBL_MENU_GROUP')->get(); $editdata = DB::table('TBL_NEWS_CATE')->where("NEWS_CATE_ID", "=", $id)->get()[0]; //if(isset($id)) abort(404); $menulist = DB::table('TBL_MENU_LIST')->get(); return view('backend.pages.53_1_edit_page')->with(['editdata' => $editdata, 'menugroup' => $menugroup, 'menulist' => $menulist]); }
public function getEdit($id) { $data = getmemulist(); $this->pageSetting(['menu_group_id' => 54, 'menu_id' => 2, 'title' => getMenuName($data, 54, 2) . ' | MEA']); $arrid = explode(',', $id); $newcate = $arrid[0]; $topic = $arrid[1]; $menucate = DB::table('TBL_FAQ_CATE')->where('FAQ_CATE_FLAG', '=', 0)->get(); //if(isset($id)) abort(404); $Topicdata = DB::table('TBL_FAQ_TOPIC')->where("FAQ_CATE_ID", "=", $newcate)->where("FAQ_QUESTION_ID", '=', $topic)->get()[0]; return view('backend.pages.54_2_edit_page')->with(['menucate' => $menucate, 'Topicdata' => $Topicdata]); }
function getSideBar($menulsit) { $data = $menulsit; $page_nav = array(); $page_nav["dashboard"] = array("group_id" => 0, "title" => "Dashboard", "icon" => "fa-home", "url" => "/admin"); if (menu_access(1, 50) || menu_access(2, 50)) { $page_nav["50"] = array("group_id" => 50, "title" => getGoupName($data, 50), "icon" => "fa-user", "sub" => array("1" => array("menu_id" => 1, "title" => getMenuName($data, 50, 1), "url" => "/admin/userGroup", "sub_mini" => array("add" => array("title" => "สร้างกลุ่มผู้ใช้", "url" => "/admin/userGroup/add"), "edit" => array("title" => "แก้ไขกลุ่มผู้ใช้", "url" => "/admin/userGroup/edit"))), "2" => array("menu_id" => 2, "title" => getMenuName($data, 50, 2), "url" => "/admin/users", "sub_mini" => array("add" => array("title" => "สร้างผู้ใช้", "url" => "/admin/users/add"), "edit" => array("title" => "แก้ไขผู้ใช้", "url" => "/admin/users/edit"), "getimport" => array("title" => "นำเข้าผู้ใช้", "url" => "/admin/users/getimport"))))); } if (menu_access(1, 51) || menu_access(2, 51) || menu_access(3, 51) || menu_access(4, 51) || menu_access(5, 51) || menu_access(6, 51) || menu_access(7, 51)) { $page_nav["51"] = array("group_id" => 51, "title" => getGoupName($data, 51), "icon" => "fa-group", "sub" => array("1" => array("menu_id" => 1, "title" => getMenuName($data, 51, 1), "url" => "/admin/simple"), "2" => array("menu_id" => 2, "title" => getMenuName($data, 51, 2), "url" => "/admin/plan"), "3" => array("menu_id" => 3, "title" => getMenuName($data, 51, 3), "url" => "/admin/fund"), "4" => array("menu_id" => 4, "title" => getMenuName($data, 51, 4), "url" => "/admin/benefit"), "5" => array("menu_id" => 5, "title" => getMenuName($data, 51, 5), "url" => "/admin/profit"), "6" => array("menu_id" => 6, "title" => getMenuName($data, 51, 6), "url" => "/admin/extendrate"), "7" => array("menu_id" => 7, "title" => getMenuName($data, 51, 7), "url" => "/admin/currentrate"))); } if (menu_access(1, 52)) { $page_nav["52"] = array("group_id" => 52, "title" => getGoupName($data, 52), "icon" => "fa-gavel", "sub" => array("1" => array("menu_id" => 1, "title" => getMenuName($data, 52, 1), "url" => "/admin/chooseplan", "sub_mini" => array("add" => array("title" => "สร้างแผนการลงทุน", "url" => "/admin/chooseplan/add"), "edit" => array("title" => "แก้ไขแผนการลงทุน", "url" => "/admin/chooseplan/edit"))))); } if (menu_access(1, 53) || menu_access(2, 53)) { $page_nav["53"] = array("group_id" => 53, "title" => getGoupName($data, 53), "icon" => "fa-bullhorn", "sub" => array("1" => array("menu_id" => 1, "title" => getMenuName($data, 53, 1), "url" => "/admin/newstopic", "sub_mini" => array("add" => array("title" => "สร้างหมวดหมู่ข่าว", "url" => "/admin/newstopic/add"), "edit" => array("title" => "แกไขหมวดหมู่ข่าว", "url" => "/admin/newstopic/edit"))), "2" => array("menu_id" => 2, "title" => getMenuName($data, 53, 2), "url" => "/admin/news", "sub_mini" => array("add" => array("title" => "สร้างหัวข้อข่าว", "url" => "/admin/news/add"), "edit" => array("title" => "แก้ไขหัวข้อข่าว", "url" => "/admin/news/edit"))))); } if (menu_access(1, 54) || menu_access(2, 54)) { $page_nav["54"] = array("group_id" => 54, "title" => getGoupName($data, 54), "icon" => "fa-comments-o", "sub" => array("1" => array("menu_id" => 1, "title" => getMenuName($data, 54, 1), "url" => "/admin/faqcate", "sub_mini" => array("add" => array("title" => "สร้างหมวดหมู่หัวข้อถาม-ตอบ", "url" => "/admin/faqcate/add"), "edit" => array("title" => "แก้ไข้หมวดหมู่หัวข้อถาม-ตอบ", "url" => "/admin/faqcate/edit"))), "2" => array("menu_id" => 2, "title" => getMenuName($data, 54, 2), "url" => "/admin/faqtopic", "sub_mini" => array("add" => array("title" => "สร้างหัวข้อถาม-ตอบ", "url" => "/admin/faqtopic/add"), "edit" => array("title" => "แก้ไขหัวข้อถาม-ตอบ", "url" => "/admin/faqtopic/edit"))))); } if (menu_access(1, 55) || menu_access(2, 55)) { $page_nav["55"] = array("group_id" => 55, "title" => getGoupName($data, 55), "icon" => "fa-map-marker", "sub" => array("1" => array("menu_id" => 1, "title" => getMenuName($data, 55, 1), "url" => "/admin/contact"), "2" => array("menu_id" => 2, "title" => getMenuName($data, 55, 2), "url" => "/admin/cmail", "sub_mini" => array("add" => array("title" => "ตอบกลับ", "url" => "/admin/cmail/forward"), "edit" => array("title" => "ส่งต่อ", "url" => "/admin/cmail/reply"))))); } if (menu_access(1, 56)) { $page_nav["56"] = array("group_id" => 56, "title" => getGoupName($data, 56), "icon" => "fa-signal", "sub" => array("1" => array("menu_id" => 1, "title" => getMenuName($data, 56, 1), "url" => "/admin/risk", "sub_mini" => array("add" => array("title" => "สร้างแบบประเมินความเสี่ยง", "url" => "/admin/risk/add"), "edit" => array("title" => "แก้ไขแบบประเมินความเสี่ยง", "url" => "/admin/risk/edit"))))); } if (menu_access(1, 57)) { $page_nav["57"] = array("group_id" => 57, "title" => getGoupName($data, 57), "icon" => "fa-trophy", "sub" => array("1" => array("menu_id" => 1, "title" => getMenuName($data, 57, 1), "url" => "/admin/nav", "sub_mini" => array("add" => array("title" => "เพิ่มมูลค่าทรัพย์สินสุทธิ", "url" => "/admin/nav/getadd"))))); } if (menu_access(1, 58) || menu_access(2, 58) || menu_access(3, 58) || menu_access(4, 58) || menu_access(5, 58) || menu_access(6, 58) || menu_access(7, 58) || menu_access(8, 58) || menu_access(9, 58) || menu_access(10, 58) || menu_access(11, 58) || menu_access(12, 58) || menu_access(13, 58)) { $page_nav["58"] = array("group_id" => 58, "title" => getGoupName($data, 58), "icon" => "fa-table", "sub" => array("1" => array("menu_id" => 1, "title" => getMenuName($data, 58, 1), "url" => "/admin/report1"), "2" => array("menu_id" => 2, "title" => getMenuName($data, 58, 2), "url" => "/admin/report2"), "3" => array("menu_id" => 3, "title" => getMenuName($data, 58, 3), "url" => "/admin/report3"), "4" => array("menu_id" => 4, "title" => getMenuName($data, 58, 4), "url" => "/admin/report4"), "5" => array("menu_id" => 5, "title" => getMenuName($data, 58, 5), "url" => "/admin/report5"), "6" => array("menu_id" => 6, "title" => getMenuName($data, 58, 6), "url" => "/admin/report6"), "7" => array("menu_id" => 7, "title" => getMenuName($data, 58, 7), "url" => "/admin/report7"), "8" => array("menu_id" => 8, "title" => getMenuName($data, 58, 8), "url" => "/admin/report8"), "9" => array("menu_id" => 9, "title" => getMenuName($data, 58, 9), "url" => "/admin/report9"), "10" => array("menu_id" => 10, "title" => getMenuName($data, 58, 10), "url" => "/admin/report10"), "11" => array("menu_id" => 11, "title" => getMenuName($data, 58, 11), "url" => "/admin/report11"), "12" => array("menu_id" => 12, "title" => getMenuName($data, 58, 12), "url" => "/admin/report12"), "13" => array("menu_id" => 13, "title" => getMenuName($data, 58, 13), "url" => "/admin/report13"))); } if (menu_access(1, 59) || menu_access(4, 59) || menu_access(3, 59)) { $page_nav["59"] = array("group_id" => 59, "title" => getGoupName($data, 59), "icon" => "fa-gear", "sub" => array("1" => array("menu_id" => 1, "title" => getMenuName($data, 59, 1), "url" => "/admin/con1"), "3" => array("menu_id" => 3, "title" => getMenuName($data, 59, 3), "url" => "/admin/con3"), "4" => array("menu_id" => 4, "title" => getMenuName($data, 59, 4), "url" => "/admin/con4"))); } foreach ($page_nav as $index => $list) { if (array_key_exists("url", $list)) { if (Request::is(substr($list["url"], 1, strlen($list["url"])))) { $page_nav["dashboard"]["active"] = true; } } else { foreach ($list["sub"] as $submenu) { $arrurlsub = explode('/', $submenu["url"]); $path = $arrurlsub[1] . "/" . $arrurlsub[2]; if (Request::is($path)) { $page_nav[$list["group_id"]]["sub"][$submenu["menu_id"]]["active"] = true; } if (array_key_exists("sub_mini", $submenu)) { foreach ($submenu["sub_mini"] as $mini) { $arrurlsub = explode('/', $mini["url"]); $path = $arrurlsub[1] . "/" . $arrurlsub[2] . "/" . $arrurlsub[3]; $current = Route::getCurrentRoute()->getPath(); $arrCount = explode('/', $current); if (count($arrCount) > 2) { $Cpath = $arrCount[0] . "/" . $arrCount[1] . "/" . $arrCount[2]; if ($Cpath == $path) { $page_nav[$list["group_id"]]["sub"][$submenu["menu_id"]]["active"] = true; break; } } else { if (Request::is($path)) { $page_nav[$list["group_id"]]["sub"][$submenu["menu_id"]]["active"] = true; break; } } } } } } } return $page_nav; }