<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Illuminate\Http\Response;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Validator;
use App\DBmodel;

class Dataentry extends Controller
{

	public $vuserid;
    public $vusername;
    public $vpassword;
    public $vuserlevel;
    public $status;
    public $data;

	 public function __construct(){
	 		$this->vuserid 	= "";
            $this->vusername = "";
            $this->vpassword = "";
            $this->vuserlevel = "";
			$this->vstatus = "";
	 }

	 function doClear(){
	 		$this->data = array("vuserid"=>$this->vuserid,
				  "vusername"=>$this->vusername,
				  "vpassword"=>$this->vpassword,
				  "vuserlevel"=>$this->vuserlevel,
				  "vstatus"=>$this->vstatus,
				  );
	 }
	 public function index(){
	 	$this-> doClear();
	 	return view('dataentry')->with($this->data);
	 }

	 public function doValidate(Request $req){
	 	$validator = Validator::make($req->all(), [
            'txtuserid' 	=> 'required',
            'txtusername' 	=> 'required',
            'txtpassword'	=> 'required',
            'txtuserlevel'	=> 'required',
			'txtstatus'		=> 'required',
        ]);
		$req->flash();

		if($validator->passes()){
			return true;
		} else {
			return false;
		}
	 }

	 public function doDM(Request $req){
	 	$vOption = $req->input('btnSubmit');
		 if($vOption =="Add" || $vOption == "Update"){
		 	$tf = $this->doValidate($req);
		 }else {
		 	$tf = true;
		 }

		 if($tf == true){

			 switch($vOption){
				case "Add":
						$tf = $this->doInsert($req);
						break;
				case "Delete":
						$this->doDelete($req);
						break;
				case "Update":
						$this->doUpdate($req);
						break;
			    case "Show":
						$this->data = $this->doShow($req);
						break;
			 }

			$page ='dataentry';

			if( $vOption == "Show"){
				return view($page)->with($this->data);
			} else {
				return redirect($page)->with($this->data);
			}

		  } else {
		  		return "Validation error!";
		  }

	 }

     public function doInsert(Request $req){
			$um = new DBmodel();
		  	$um->doInsert($req);
     }

     public function doDelete(Request $req) {
	  	  	$um = new DBmodel();
		  	$um->doDelete($req);
     }

	public function doUpdate(Request $req) {
	 		$um = new DBmodel();
		  	$um->doUpdate($req);
    }
	public function doShow(Request $req) {
	 		$um = new DBmodel();
		  	$record = $um->doShow($req);

			$vShowData ="";
			if( sizeof($record) == 1){
				foreach ($record as $rec) {
					$vShowData = array("vuserid"=>$rec->userid,
						  "vusername"=>$rec->username,
						  "vpassword"=>$rec->password,
						  "vuserlevel"=>$rec->userlevel,
						  "vstatus"=>$rec->status,
					);
				}

			}else {
				$vShowData = array("vuserid"=>$this->vuserid,
				  "vusername"=>$this->vusername,
				  "vpassword"=>$this->vpassword,
				  "vuserlevel"=>$this->vuserlevel,
				  "vstatus"=>$this->vstatus,
				  );
			}
			return $vShowData;
    }

}