SubContentController.php 1.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041
  1. <?php
  2. namespace App\Http\Controllers\Admin;
  3. use App\Http\Controllers\Controller;
  4. use Illuminate\Http\Request;
  5. use \App\Helpers\PageSL;
  6. use App\Models\University;
  7. use App\Models\MarketCountry;
  8. use Auth;
  9. class SubContentController extends Controller
  10. {
  11. public function get(Request $req, $name){
  12. $user=Auth::guard('admin')->user();
  13. $carbon=new \Carbon\Carbon;
  14. $data=[
  15. 'user'=>$user,
  16. 'carbon'=>$carbon,
  17. 'name'=>$name
  18. ];
  19. if($name=="load_market_countries"){
  20. $data['market_countries'] = MarketCountry::where(
  21. 'status', 1
  22. )->select(
  23. 'market_countries.*', \DB::raw('(SELECT name FROM countries WHERE market_countries.country_id = countries.id ) as sort')
  24. )->orderBy('sort')->get();
  25. }elseif($name=='country_wise_university'){
  26. $data['universities'] =University::orderBy('name','ASC')->get();
  27. }else $name='default';
  28. //$data['page_sl']=new PageSL($data['chapter_details']);
  29. return view("admin.sub_contents.{$name}", $data);
  30. }
  31. }