複製文字

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use DB;
use App\Models\Tmember;

class HomeController extends Controller
{

    public function Index() {
        return view('Home.Index');
    }
    
    public function Login() {
        return view('Home.Login',['msg'=>'']);
    }


    public function DBtest(Request $r){
        // use models of tmember
        // $users = Tmember::where('acc','=',$r ->acc)->where('pwd','=',$r ->pwd)->first(); // 單筆資料
        $users = Tmember::all(); 
        // use db::select
        // $users = DB::select('SELECT * FROM member');
        if($users == NULL){
            return "NO DATA";

        }else {
            return view('Home.DBtest',['users'=>$users]);
        }
    }

    // 檢查登入
    public function CheckLogin(Request  $r)
    {	  
        $user= Tmember::where('acc','=',$r->acc)->where('pwd','=',$r->pwd)->get();
        if(count($user) <= 0 )
                return view('Home.Login',['msg' => "帳密不對....",'acc'=>$r->acc]);
        else {
            $sql = "select * from category  order by id ";
            $cates = DB::select($sql);
            session(['Cates' => $cates]);    // 產品類別
            session(['LoginOK' => true]); 
            session(['LoginAcc' => $user[0]->acc]);
            session(['LoginRole' =>$user[0]->role]);
            $role = $user[0]->role;
            return redirect("/$role/Index");     
        }
    }
    
    // 登出
    public function Logout()
    {	 
        // session(['LoginOK' => false]);    // 清除單一session 變數
        session()->flush();	             // 清除所有 session 變數	
        return redirect("/Home/Login");			 
    }


    // 註冊
    public function  Register()
    {
        return view('Home.MemberRegister');
    }


    // 註冊會員，加入驗證
    public function MemberAdd(Request  $r)
    {
        // DB::insert("insert into member (`acc`,`pwd`,`sex`,`role`) values (?, ?, ?,?, 'Member')", array( $r-acc,$r->pwd,$r->sex ));
        // 或
        $user = new Tmember();    // 建立 Tmember 物件
        $user->acc = $r->acc;    // 填入個欄位
        $user->pwd = $r->pwd;
        $user->sex = $r->sex;
        $user->name = $r->name;
        $user->role = "Member";
        

        if($r->hasFile('imgFile')){
            $file = request('imgFile');    // 取得檔案資訊物件	
            $dstPath = public_path('Images');        //  ./userPhoto , 會存到 public/userPhoto 資料夾
            $ext = $file->getClientOriginalExtension(); // 取得副檔名
            $f = uniqid(uniqid('img_'),true). "." .  $ext ;    // 產生亂數檔名.副檔名
            $file->move($dstPath,  $f);    // 上傳檔案			          
            $user ->photo = $f;       // 填入照片欄資料
        }  
        $user->save();  
        // return redirect("/Home/Login");	
        echo "<script>alert('新增成功');window.location.href='./Login';</script>";
            
    }

    // jquery check username is register
    public function API_checkAccount(Request $r)
    {   
        // return($r->acc);
        /**/ 
        $user= DB::select("select * from member where acc = ?",[$r->acc]);
        if ($user == NULL)
            return "編號可用";
        else
            return "編號重複";
    }


    

}