/** * Add New Shop * @param Request $request * @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View * @since 13-05-2016 * @author Vini Dubey <*****@*****.**> */ public function addNewShop(Request $request) { $objCategoryModel = ProductCategory::getInstance(); $objLocationModel = Location::getInstance(); $objShopModel = Shops::getInstance(); $objShopMetadataModel = ShopMetadata::getInstance(); $userId = Session::get('fs_admin')['id']; $whereforCategory = ['rawQuery' => 'category_status =? and parent_category_id =?', 'bindParams' => [1, 0]]; $allCategories = $objCategoryModel->getAllCategoriesWhere($whereforCategory); $whereforCountry = ['rawQuery' => 'is_visible =? and location_type =?', 'bindParams' => [0, 0]]; $allCountry = $objLocationModel->getAllLocationsWhere($whereforCountry); $whereforShop = ['rawQuery' => 'user_id =?', 'bindParams' => [$userId]]; $allShop = $objShopModel->getAllshopsWhere($whereforShop); // print_a($allShop); //echo "<pre>";print_r($allShop);die; /////////////////////////////Flag Set By admin side///////////////Todo- Flag Set By admin side $multiple_store_flag = 1; // Value 1 if flag is set $sub_store_flag = 1; // Value 1 if flag is set $parent_category_flag = 1; // Value 1 if flag is set ///////////////////////////////////////////////////////////////// $flag['multiple_store_flag'] = $multiple_store_flag; $flag['sub_store_flag'] = $sub_store_flag; $flag['parent_category_flag'] = $parent_category_flag; $data['allCategories'] = $allCategories; $data['Country'] = $allCountry; $data['Shop'] = $allShop; if (!empty($allShop) && $multiple_store_flag != 1) { //Error msg if multiple shop not allowed and shopeady added return view("Supplier/Views/supplier/addNewShop", ['multiple_store_err' => "Shop already added, Can not add Multiple Shop"]); } else { $parentCategoryId = 0; if (isset($request['parent_category']) && !empty($request['parent_category'])) { $parentCategoryId = $request['parent_category']; } $parentShopId = ""; if (isset($request['parent_shop']) && !empty($request['parent_shop'])) { $parentShopId = $request['parent_shop']; } if ($request->isMethod('post')) { if ($parentShopId == '') { //Sub store flag is not set $rules = array('shop_name' => 'required'); } else { //Sub store flag is set $rules = array(); } $validator = Validator::make($request->all(), $rules); if ($validator->fails()) { return Redirect::back()->withErrors($validator)->withInput(); } else { try { $addressLine1 = ""; if (isset($request['address_line_1'])) { $addressLine1 = $request['address_line_1']; } $addressLine2 = ""; if (isset($request['address_line_2'])) { $addressLine2 = $request['address_line_2']; } $country = ""; if (isset($request['country'])) { $country = $request['country']; } $state = ""; if (isset($request['state'])) { $state = $request['state']; } $city = ""; if (isset($request['city'])) { $city = $request['city']; } $zipcode = ""; if (isset($request['zipcode'])) { $zipcode = $request['zipcode']; } $shop_flag = 1; if (isset($request['shop_flag'])) { $shop_flag = $request['shop_flag']; } $show_shop = 2; if (isset($request['show_shop'])) { $show_shop = $request['show_shop']; } ////////////Upload Shop Banner Start/////////////////////// if (isset($_FILES["shop_banner"]["name"]) && !empty($_FILES["shop_banner"]["name"])) { $bannerFilePath = uploadImageToStoragePath(Input::file('shop_banner'), 'shopbanner', 'shopbanner_' . $userId . '_' . time() . ".jpg"); } else { $bannerFilePath = uploadImageToStoragePath($_SERVER['DOCUMENT_ROOT'] . "/assets/images/no-image.png", 'shopbanner', 'shopbanner_' . $userId . '_' . time() . ".jpg"); } ////////////Upload Shop banner End/////////////////////// ////////////Upload Shop Logo Start/////////////////////// if (isset($_FILES["shop_logo"]["name"]) && !empty($_FILES["shop_logo"]["name"])) { $logoFilePath = uploadImageToStoragePath(Input::file('shop_logo'), 'shoplogo', 'shoplogo_' . $userId . '_' . time() . ".jpg"); } else { $logoFilePath = uploadImageToStoragePath($_SERVER['DOCUMENT_ROOT'] . "/assets/images/no-image.png", 'shoplogo', 'shoplogo_' . $userId . '_' . time() . ".jpg"); } ////////////Upload Shop Logo End/////////////////////// if ($parentShopId == "") { //Sub store flag is not set $shopdata = array('user_id' => $userId, 'shop_name' => $request['shop_name'], 'shop_banner' => $bannerFilePath, 'shop_logo' => $logoFilePath, 'parent_category_id' => $parentCategoryId, 'shop_flag' => $shop_flag); $addShop = $objShopModel->addShop($shopdata); $shop_id = $addShop; $shopType = "0"; } else { //Sub store flag is set $shopType = "1"; $shop_id = $parentShopId; } $shopMatadata = array('shop_id' => $shop_id, 'shop_type' => $shopType, 'address_line_1' => $addressLine1, 'address_line_2' => $addressLine2, 'city' => $city, 'state' => $state, 'country' => $country, 'zipcode' => $zipcode, 'added_date' => time(), 'show_shop_address' => $show_shop, 'shop_metadata_status' => 1); $addShop = $objShopMetadataModel->addShopMetadata($shopMatadata); if ($addShop) { if ($parentShopId == "") { return redirect()->back()->with('shop_success_msg', 'Shop Added Successfully, Waiting for Admin Approval.'); } else { return redirect()->back()->with('shop_success_msg', 'Shop Added Successfully.'); } } } catch (\Exception $ex) { return redirect()->back()->with('exception', 'An exception occurred, please reload the page and try again.'); } } } return view("Admin/Views/shop/addNewShop", ['data' => $data], ['flag' => $flag]); } }
/** * Handle ajax call for settings * @param Request $request * @throws \Exception * @since 07-01-2016 * @author Dinanath Thakur <*****@*****.**> */ public function settingsAjaxHandler(Request $request) { $objLocationModel = Location::getInstance(); $inputData = $request->input(); $method = $inputData['method']; switch ($method) { case 'getLocations': $params = array_except($inputData, 'method'); $filedNames = ''; foreach ($params as $index => $param) { $filedNames .= $index . '=? AND '; } $whereForLocation = ['rawQuery' => substr_replace($filedNames, '', strrpos($filedNames, 'AND'), strlen('AND')), 'bindParams' => $params]; $selectedColumns = ['location_id', 'name']; $allCountries = $objLocationModel->getAllLocationsWhere($whereForLocation, $selectedColumns); echo json_encode($allCountries); break; default: break; } }
/** * Edit Language Action * @param Request $request * @param $lid * @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View * @author Vini Dubey */ public function editLanguage(Request $request, $lid) { $response = new stdClass(); $ObjLanguageModel = Languages::getInstance(); $ObjLocationModel = Location::getInstance(); $postData = $request->all(); if ($request->isMethod('GET')) { $where = ['rawQuery' => 'location_type = ?', 'bindParams' => [0]]; $countrydetails = $ObjLocationModel->getAllCountryDetails($where); $where = ['rawQuery' => 'lang_id = ?', 'bindParams' => [$lid]]; $selectedColumns = ['location.name as location_name', 'languages.*']; $languagedetails = $ObjLanguageModel->getAllLanguageDetails($where, $selectedColumns); return view('Admin/Views/administration/editLanguage', ['countrydetail' => $countrydetails, 'languagedetails' => $languagedetails[0]]); } elseif ($request->isMethod('POST')) { $rules = array('lang_code' => 'unique:languages,lang_code,' . $lid . ',lang_id', 'name' => trans('unique:languages,name,' . $lid . ',lang_id'), 'country_code' => 'unique:languages,country_code,' . $lid . ',lang_id'); $validator = Validator::make($request->all(), $rules); if ($validator->fails()) { return Redirect::back()->withErrors($validator)->withInput(); } else { $data['lang_code'] = $postData['lang_code']; $data['name'] = $postData['name']; $data['country_code'] = $postData['country_code']; // $data['status'] = $postData['statact']; $where = ['rawQuery' => 'lang_id = ?', 'bindParams' => [$lid]]; $updateUser = $ObjLanguageModel->updateLanguageStatus($data, $where); if ($updateUser) { return Redirect::back()->with(['status' => 'success', 'msg' => 'Language details has been updated.']); } else { //NOTHING TO UPDATE return Redirect::back()->with(['status' => 'info', 'msg' => 'Nothing to update.']); } } } }
public function supplierAjaxHandler(Request $request) { $inputData = $request->input(); $method = $request->input('method'); $ObjUser = User::getInstance(); $objModelLocation = Location::getInstance(); $ObjUsermeta = Usersmeta::getInstance(); if ($method) { switch ($method) { case 'availableSupplier': $objuser = User::getInstance(); $where = array('rawQuery' => 'role = ?', 'bindParams' => [3]); $available_supplier = $objuser->getAvailableSupplierDetails($where); // echo"<pre>";print_r($available_supplier);die("gvj"); // foreach ($available_supplier as $key => $val) { // $vail[$key] = $val->id; // $available_supplier[$key] = $val; // $available_supplier[$key]->usermeta = array(); // $available_supplier[$key] = $val; // $available_supplier[$key]->filter = array(); // } // $supplier = implode(",",$vail); // echo"<pre>";print_r($supplier);die("cvjh"); // $whereuser = ['rawQuery' => 'user_id = ?', 'bindParams' => $vail]; // $usermetaInfo = $ObjUsermeta->getAvaiableUserMetaDetails(); // foreach($usermetaInfo as $keymeta => $valmeta){ // $usermetaInfo[$keymeta] = $valmeta; //// $usermetaInfo[$keymeta]->filter = array(); // } // // if(!empty($usermetaInfo)){ // // $available_supplier[$key]->usermeta = $usermetaInfo; // // } // echo"<pre>";print_r($available_supplier);die("cvjh"); // echo"<pre>";print_r($usermetaInfo);die("cvjh"); // // $whereuser = array('rawQuery' => 'user_id IN('.$supplier.')'); // $available_supplier[$key] = $usermetadescription; //// echo"<pre>";print_r($available_customers);die("cvjh"); // // $usermetaInfo = $ObjUsermeta->getAvaiableUserMetaDetails($whereuser); // foreach ($usermetaInfo as $filtergroupkey => $filtergroupvalue) { // $usermetaInfo[$filtergroupkey]->filtergroup = array(); // if ($filtergroupvalue->permission_ids != '') { // $catfilterName = array_values(array_unique(explode(',', $filtergroupvalue->permission_ids))); // $per = implode(",", $catfilterName); // $where = ['rawQuery' => 'permission_id IN(' . $per . ')']; // $getcategory = $objPermissionModel->getPermissionNameByIds($where); // // foreach ($getcategory as $catkey => $catval) { // $availPermissionRelation[$filtergroupkey]->filter = $catval; // $available_customers[$key]->filter = $availPermissionRelation[$filtergroupkey]->filter; // } // $available_supplier[$key]->filter = $usermetaInfo[$filtergroupkey]->filtergroup; // // } // } // echo"<pre>";print_r($available_supplier);die("gvj"); return Datatables::of($available_supplier)->addColumn('action', function ($available_supplier) { $action = '<span class="tooltips" title="Edit Supplier Details." data-placement="top"> <a href="/admin/edit-supplier/' . $available_supplier->id . '" class="btn btn-sm grey-cascade" style="margin-left: 10%;">'; $action .= '<i class="fa fa-pencil-square-o"></i></a>'; $action .= '</span> '; $action .= '<span class="tooltips" title="Delete Supplier Details." data-placement="top"> <a href="#" data-cid="' . $available_supplier->id . '" class="btn btn-danger delete-supplier" style="margin-left: 10%;">'; $action .= '<i class="fa fa-trash-o"></i>'; $action .= '</a></span>'; return $action; })->addColumn('status', function ($available_supplier) { $button = '<td style="text-align: center">'; $button .= '<button class="btn ' . ($available_supplier->status == 1 ? "btn-success" : "btn-danger") . ' supplier-status" data-id="' . $available_supplier->id . '">' . ($available_supplier->status == 1 ? "Active" : "Inactve") . ' </button>'; $button .= '<td>'; return $button; })->addColumn('supplierdetail', function ($available_supplier) { return '<td style = "text-align: center" ><div class="container" style = "width: 50px " > <span class="tooltips" title = "Review Description." data-placement = "top" ><button data-id = "' . $available_supplier->id . '" type = "button" class="btn btn-sm btn-default modaldescription" data-toggle = "modal" data-target = "#mymodel" ><i class="fa fa-expand" ></i ></button ></span > </div > </td >'; })->removeColumn('name')->removeColumn('updated_at')->make(); break; case 'pendingSupplier': $objuser = User::getInstance(); $where = array('rawQuery' => 'role = ? and status = ?', 'bindParams' => [3, 0]); // $status = array('rawQuery' => 'status = ?', 'bindParams' => [0]); $pending_supplier = $objuser->getPendingUserDetails($where); return Datatables::of($pending_supplier)->addColumn('status', function ($pending_supplier) { return ' < td style = "text-align: center" > <button class="btn btn-primary customer-status" data - id = ' . $pending_supplier->id . ' > Pending </button > </td > '; })->removeColumn('name')->removeColumn('updated_at')->make(); break; case 'deletedSupplier': $objuser = User::getInstance(); $where = array('rawQuery' => 'role = ?', 'bindParams' => [3]); $status = array('rawQuery' => 'status = ?', 'bindParams' => [4]); $deleted_supplier = $objuser->getDeletedUserDetails($where, $status); return Datatables::of($deleted_supplier)->addColumn('status', function ($deleted_supplier) { return ' < td style = "text-align: center" > <button class="btn btn-primary customer-status" data - id = ' . $deleted_supplier->id . ' > Deleted </button > </td > '; })->removeColumn('name')->removeColumn('updated_at')->make(); break; case 'changeSupplierStatus': $userId = $inputData['UserId']; $whereForUpdate = ['rawQuery' => 'id =?', 'bindParams' => [$userId]]; $dataToUpdate['status'] = $inputData['status']; $updateResult = $ObjUser->updateUserWhere($dataToUpdate, $whereForUpdate); if ($updateResult == 1) { echo json_encode(['status' => 'success', 'msg' => 'Status has been changed . ']); } else { echo json_encode(['status' => 'error', 'msg' => 'Something went wrong, please reload the page and try again . ']); } break; case 'deleteSupplierStatus': $userId = $inputData['UserId']; $where = ['rawQuery' => 'id = ?', 'bindParams' => [$userId]]; $deleteStatus = $ObjUser->deleteUserDetails($where); if ($deleteStatus) { echo json_encode(['status' => 'success', 'msg' => 'User Deleted']); } else { echo json_encode(['status' => 'error', 'msg' => 'Something went wrong, please reload the page and try again . ']); } break; case "locationinfo": $where = ['rawQuery' => 'location_type = ?', 'bindParams' => [0]]; $locationdetail = $objModelLocation->getAllCountryDetails($where); echo json_encode($locationdetail); break; case 'stateInfoByLocation': $countryId = $request->input('countryId'); $where = array('rawQuery' => 'parent_id = ? and location_type = ?', 'bindParams' => [$countryId, 1]); $stateInfo = $objModelLocation->getStateByCountryId($where); echo json_encode($stateInfo); break; case 'cityInfoByLocation': $countryId = $request->input('countryId'); $where = array('rawQuery' => 'parent_id = ? and location_type = ?', 'bindParams' => [$countryId, 1]); $cityInfo = $objModelLocation->getCityByCountryId($where); echo json_encode($cityInfo); break; case 'getUsermetaInfoByUserId': $UserId = $request->input('UserId'); $where = array('rawQuery' => 'user_id = ?', 'bindParams' => [$UserId]); $selectedColumns = ['location.*', 'usersmeta.addressline1', 'usersmeta.addressline2', 'usersmeta.city', 'usersmeta.state', 'usersmeta.zipcode', 'usersmeta.phone', 'usersmeta.user_id']; $userMetaInfo = $ObjUsermeta->getUserMetaInfoByUserId($where, $selectedColumns); // echo"<pre>";print_r($userMetaInfo);die("Cfh"); echo json_encode($userMetaInfo); break; default: break; } } }
public function editLanguage(Request $request, $lid) { $response = new stdClass(); $ObjLanguageModel = Languages::getInstance(); $ObjLocationModel = Location::getInstance(); $postData = $request->all(); // if ($request->isMethod('GET')) { $where = ['rawQuery' => 'location_type = ?', 'bindParams' => [0]]; $countrydetails = $ObjLocationModel->getAllCountryDetails($where); $where = ['rawQuery' => 'lang_id = ?', 'bindParams' => [$lid]]; $selectedColumns = ['location.name as location_name', 'languages.*']; $languagedetails = $ObjLanguageModel->getAllLanguageDetails($where, $selectedColumns); return view('Admin/Views/administration/editLanguage', ['countrydetail' => $countrydetails, 'languagedetails' => $languagedetails[0]]); } elseif ($request->isMethod('POST')) { // echo"<pre>";print_r($request->all());die("dgvf"); $data['lang_code'] = $postData['lang_code']; $data['name'] = $postData['name']; $data['country_code'] = $postData['country_code']; // $data['status'] = $postData['statact']; $where = ['rawQuery' => 'lang_id = ?', 'bindParams' => [$lid]]; //$where['id'] = $mid; $updateUser = $ObjLanguageModel->updateLanguageStatus($data, $where); // echo"<pre>";print_r($updateUser);die("cfh"); if ($updateUser) { } } }