public function getTourDetailIndexModel($tourId) { $cmModel = new Admin\CommonModel(); $photoModel = new Admin\AdminPhotoModel(); $nationalList = $cmModel->getNationList(); $locationList = $cmModel->getLocationList(); $photoList = $photoModel->getImgReferList('tb_tours', $tourId, 'TOUR_ID'); $categoryList = $cmModel->getCategoryListByGroup('T'); $tourDetail = array("adminTourDetail" => $this->getTourDetailMode($tourId), "nationalList" => $nationalList, "locationList" => $locationList, "photoList" => $photoList, "categoryList" => $categoryList); return $tourDetail; }
public function insertImage($url, $imgTp, $title) { $commonModel = new Admin\CommonModel(); $photoModel = new Admin\AdminPhotoModel(); $imgID = $commonModel->createPostId('tb_img_mgmt', 'IMG_ID', 'IMG'); $imgArr = array("IMG_ID" => $imgID, "IMG_TP" => $imgTp, "IMG_TITLE" => $title, "IMG_URL" => $url, "IMG_ALT" => $title); $result = $photoModel->insertImage($imgArr); if ($result == true) { return $imgID; } else { return "Fail"; } }
public function slideEditor(Request $request) { $CommonModel = new Admin\CommonModel(); $photoModel = new Admin\AdminPhotoModel(); $slideModel = new Admin\AdminSlideModel(); $photoCtrl = new PhotoController(); $this->validate($request, ['titleVi' => 'required|max:150', 'titleEn' => 'required|max:150', 'textLink' => 'required', 'slideSeq' => 'required', 'slideCntVi' => 'required', 'slideCntEn' => 'required']); $slideId = $request->input('formAction') == "Save" ? $CommonModel->createPostId('tb_slide', 'SLD_ID', 'SL') : $request->input('slideId'); $slideArr = array("SLD_ID" => $slideId, "SLD_TITLE_VI" => $request->input('titleVi'), "SLD_TITLE_EN" => $request->input('titleEn'), "SLD_LINK" => $request->input('textLink'), "SLD_SEQ" => $request->input('slideSeq'), "SLD_CONTENT_VI" => $request->input('slideCntVi'), "SLD_CONTENT_EN" => $request->input('slideCntEn'), "SLD_IMG_ALT" => $request->input('sldImgAlt')); if ($request->input('formAction') == "Save") { $result = $slideModel->slideInsert($slideArr); } else { $result = $slideModel->slideUpdate($slideId, $slideArr); } if ($result == true) { if ($request->hasFile('rpvImg')) { //insert representative image $file = $request->file('rpvImg'); $path = '/resources/assets/img/uploads/' . $file->getClientOriginalName(); if (strlen($photoModel->getImgId($path)) < 1) { //check if image not exist $request->rpvImg->move('resources/assets/img/uploads', $file->getClientOriginalName()); $imgArr = array("SLD_IMG_URL" => $path); $imgRsl = $slideModel->slideUpdate($slideId, $imgArr); if ($imgRsl == true) { return response()->json(['info' => 'Success', 'Content' => 'Edit slide success.', 'slideId' => $slideId], 200); } else { return response()->json(['info' => 'Success', 'Content' => 'Edit slide success, but background image change fail.', 'slideId' => $slideId], 200); } } else { $imgArr = array("SLD_IMG_URL" => $path); $imgRsl = $slideModel->slideUpdate($slideId, $imgArr); if ($imgRsl == true) { return response()->json(['info' => 'Success', 'Content' => 'Edit slide success.', 'slideId' => $slideId], 200); } else { return response()->json(['info' => 'Success', 'Content' => 'Edit slide success, but background image change fail.', 'slideId' => $slideId], 200); } } } elseif (strlen($request->input('rpvTxtLink')) > 5) { $imgArr = array("SLD_IMG_URL" => $request->input('rpvTxtLink')); $imgRsl = $slideModel->slideUpdate($slideId, $imgArr); if ($imgRsl == true) { return response()->json(['info' => 'Success', 'Content' => 'Edit slide success.', 'slideId' => $slideId], 200); } else { return response()->json(['info' => 'Success', 'Content' => 'Edit slide success, but background image change fail.', 'slideId' => $slideId], 200); } } } else { return response()->json(['info' => 'Fail', 'Content' => 'Edit slide fail.', 'slideId' => $slideId], 200); } }
public function newsEditor(Request $request) { $CommonModel = new Admin\CommonModel(); $adminNewsModel = new Admin\AdminNewsModel(); $photoModel = new Admin\AdminPhotoModel(); $photoCtrl = new PhotoController(); if ($request->input('formAction') == "Save") { $this->validate($request, ['newsTextLink' => 'required|unique:tb_tours,TOUR_TEXT_LINK|max:150']); } $this->validate($request, ['newsTitleVi' => 'required|max:150', 'newsTitleEn' => 'required|max:150', 'newsTextLink' => 'required', 'newsShrtCntVi' => 'required', 'newsShrtCntEn' => 'required', 'newsCntVi' => 'required', 'newsCntEn' => 'required', 'newsKeywordVi' => 'required', 'newsKeywordEn' => 'required']); $newsId = $request->input('formAction') == "Save" ? $CommonModel->createPostId('tb_news', 'NEWS_ID', 'N') : $request->input('newsId'); $newsArr = array('NEWS_ID' => $newsId, 'NEWS_TITLE_VI' => $request->input('newsTitleVi'), 'NEWS_TITLE_EN' => $request->input('newsTitleEn'), 'NEWS_SHRT_CNT_VI' => $request->input('newsShrtCntVi'), 'NEWS_SHRT_CNT_EN' => $request->input('newsShrtCntEn'), 'NEWS_CNT_VI' => $request->input('newsCntVi'), 'NEWS_CNT_EN' => $request->input('newsCntEn'), 'NEWS_TEXT_LINK' => $request->input('newsTextLink'), 'NEWS_HOT_YN' => $request->input('newsHot'), 'NEWS_KEYWORD_VI' => $request->input('newsKeywordVi'), 'NEWS_KEYWORD_EN' => $request->input('newsKeywordEn')); $cateId = $request->input('newsCategory'); $action = $request->input('formAction'); if ($action == "Save") { //Save: Insert --- Update: Update $status = $adminNewsModel->createNews($newsArr); if ($status == true) { $cateStatus = $CommonModel->insertPostCategory($newsId, $cateId); } } else { $status = $adminNewsModel->updateNews($newsId, $newsArr); if ($status == true) { $cateStatus = $CommonModel->updateCategory($newsId, $cateId); } } if ($status == true) { if ($request->hasFile('rpvImg')) { //insert representative image $file = $request->file('rpvImg'); $path = '/resources/assets/img/uploads/' . $file->getClientOriginalName(); if (strlen($photoModel->getImgId($path)) < 1) { //check if image not exist $request->rpvImg->move('resources/assets/img/uploads', $file->getClientOriginalName()); $imgId = $photoCtrl->insertImage($path, 'U', $request->input('newsTitleVi')); if ($imgId != 'Fail') { $changeImg = $photoModel->updateRpvImg('tb_news', $newsId, $imgId, 'NEWS_ID', 'NEWS_RPV_IMG_ID'); if ($changeImg == false) { return response()->json(['info' => 'Fail', 'Content' => 'Update representative image fail.', 'newsId' => $newsId], 200); } } else { return response()->json(['info' => 'Fail', 'Content' => 'Update representative image fail.', 'newsId' => $newsId], 200); } } else { $imgId = $photoModel->getImgId($path); $changeImg = $photoModel->updateRpvImg('tb_news', $newsId, $imgId, 'NEWS_ID', 'NEWS_RPV_IMG_ID'); if ($changeImg == false) { return response()->json(['info' => 'Fail', 'Content' => 'Update representative image fail.', 'newsId' => $newsId], 200); } } } elseif (strlen($request->input('rpvTxtLink')) > 5) { if (strlen($photoModel->getImgId($request->input('rpvTxtLink'))) < 1) { //check if image not exist $imgId = $photoCtrl->insertImage($request->input('rpvTxtLink'), 'R', $request->input('newsTitleVi')); if ($imgId != 'Fail') { // Change representative image $changeImg = $photoModel->updateRpvImg('tb_news', $newsId, $imgId, 'NEWS_ID', 'NEWS_RPV_IMG_ID'); if ($changeImg == false) { return response()->json(['info' => 'Fail', 'Content' => 'Update representative image fail.', 'newsId' => $newsId], 200); } } } else { //if image already exist $imgId = $photoModel->getImgId($request->input('rpvTxtLink')); //get Image Id $changeImg = $photoModel->updateRpvImg('tb_news', $newsId, $imgId, 'NEWS_ID', 'NEWS_RPV_IMG_ID'); if ($changeImg == false) { return response()->json(['info' => 'Fail', 'Content' => 'Update representative image fail.', 'newsId' => $newsId], 200); } } } return response()->json(['info' => 'Success', 'Content' => 'Update news complete.', 'newsId' => $newsId], 200); } else { return response()->json(['info' => 'Fail', 'Content' => 'Update news fail.', 'newsId' => $newsId], 200); } }
public function getTourImage($tourId) { $photoModel = new Admin\AdminPhotoModel(); $imgList = $photoModel->getImgReferList('tb_tours', $tourId, 'TOUR_ID'); return view('', ''); }