<?php


$register="register";
$login="login";
$getStatus="getStatus";
$insertInTime="insertInTime";
$insertOutTime="insertOutTime";
$updateInTime="updateInTime";
$updateOutTime="updateOutTime";
$inTime_All="inTime_All";
$outTime_All="outTime_All";

 $task=$_REQUEST['task'];

  if($task==$register){
       register();
}
  else if($task==$login)   {
      login();
}else if($task==$getStatus){
      getStatus();
}else if($task==$insertInTime){
       onInsertInTime();
}else if($task==$insertOutTime){
   onInsertOutTime();
}else if($task==$updateInTime){
   onUpdateInTime();
}else if($task==$updateOutTime){
   onUpdateOutTime();
}
else if($task==$inTime_All){
   getAll("intime_mgt",$_REQUEST['employeeId']);
}else if($task==$outTime_All){
getAll("outtime_mgt",$_REQUEST['employeeId']);
}



function getAll($db_name,$employeeId){

    $con= mysql_connect('localhost','root','');
         if(!$con)
         {
         die('could not connect;'.mysql_error());
         }


         mysql_select_db('timemanagement');
         $response = array();

         $result = mysql_query("SELECT * FROM $db_name WHERE employeeId='$employeeId'");

         $response["all"] = array();
         if(mysql_num_rows($result) >=1)
               {
                  $currentDate=date("Y-m-d") ;


                  while($row = mysql_fetch_array($result))
                    {
                     $user = array();

                         $db_date=$row["inTime"];


                           $response["success_code"] = 0;
                           $response["status"]="Success";
                           $response["message"]="All Datas Success";

                           $user["inTime"] = $db_date;
                           $user["outTime"] = $row["outTime"];
                           $user["duration"] = $row["duration"];

                            array_push($response["all"], $user);


              } }
                  else  {

                                 $user_not_found = array();
                                 $response["success_code"] = 1;
                                $response["status"]="not_found";
                                $response["message"]="User not found";

                           }
                         /*  echo json_encode($response);*/

             }


function onUpdateOutTime(){
   echo "onUpdateOutTime";
}
function onUpdateInTime(){

      $con= mysql_connect('localhost','root','');
         if(!$con)
         {
         die('could not connect;'.mysql_error());
         }
         mysql_select_db('timemanagement');
         $response = array();
         $statusId=$_POST['statusId'];
         $outTime=$_POST['outTime'];
         $duration=$_POST['duration'];
         $id=$_POST['id'];
         $result = mysql_query("UPDATE intime_mgt SET outTime ='$outTime',duration ='$duration',statusId ='$statusId' WHERE id = $id");
          $response["intime_update_status"] = array();
    if ($result) {


 $sql = "INSERT INTO `outtime_mgt` (employeeId,outTime,statusId) VALUES ('".$_POST['employeeId']."', '".$_POST['outTime']."', '".$_POST['statusId']."' )";
     $retval = mysql_query( $sql, $con );
          if(! $retval ) {
             die('Could not enter data: ' . mysql_error());
                $json = array("status" => "failure","message" => "Invalid User","code" => "1");
            }


       $response["success_code"] = 0;
       $response["message"] = "successfully updated";
       echo json_encode($response);

   } else {
      $response["success_code"] = 1;
       $response["message"] = "not updated";
       echo json_encode($response);

   }
}


function onInsertOutTime(){
   echo "onInsertOutTime";

}
  function onInsertInTime(){

      $con= mysql_connect('localhost','root','');
         if(!$con)
         {
         die('could not connect;'.mysql_error());
         }
         mysql_select_db('timemanagement');

      $sql = "INSERT INTO `intime_mgt` (employeeId,inTime,outTime, statusId,duration) VALUES ('".$_POST['employeeId']."', '".$_POST['inTime']."','".$_POST['outTime']."', '".$_POST['statusId']."','".$_POST['duration']."' )";
     $retval = mysql_query( $sql, $con );
          if(! $retval ) {
             die('Could not enter data: ' . mysql_error());
                $json = array("status" => "failure","message" => "Invalid User","code" => "1");
            }

              $json = array("status" => "success","message" => "Insert Intime Success","code" => "0");
              echo json_encode($json);
  }
function getStatus(){

    $con= mysql_connect('localhost','root','');
   if(!$con)
   {
   die('could not connect;'.mysql_error());
   }
      mysql_select_db('timemanagement');
      $response = array();
      if((isset($_POST["employeeId"])) && ($_POST["employeeId"]!="") )
      {
           $employeeId=$_POST['employeeId'];
           $sql="SELECT * FROM intime_mgt where id=(select MAX(id)from intime_mgt)";
           $result = mysql_query($sql,$con);

            $response["intime_status"] = array();

           if(mysql_num_rows($result) >=1){
                  while($row = mysql_fetch_array($result))
                    {
                           $user = array();

                           $response["success_code"] = 0;
                           $response["status"]="Success";
                           $response["message"]="Fetched Datas Success";

                           $user['statusId']=$row['statusId'];
                           $user['inTime']=$row['inTime'];
                           $user['id']=$row['id'];

                           array_push($response["intime_status"], $user);
                           echo json_encode($response);

                        }
           }else{
                        $user = array();
                           $response["success_code"] = 1;
                           $response["status"]="Failure";
                           $response["message"]="Not Found";
                            echo json_encode($response);

           }

      }else{
          $user = array();

                           $response["success_code"] = 1;
                           $response["status"]="Wrong";
                           $response["message"]="Something Went Wrong";
                           echo json_encode($response);
      }

}

function login()
{
   $con= mysql_connect('localhost','root','');
  if(!$con)
    {
         die('could not connect;'.mysql_error());
      }
         mysql_select_db('timemanagement');
         $response = array();

   if((isset($_POST["mobileNumber"])) && ($_POST["mobileNumber"]!="") && (isset($_POST["password"])) && ($_POST["password"]!=""))
      {
         $userid=$_POST['mobileNumber'];
         $password=$_POST['password'];
         $result = mysql_query("SELECT * FROM userregistration WHERE mobileNumber='$userid'");
         $response["login"] = array();
         if(mysql_num_rows($result) ==1)
               {

                  while($row = mysql_fetch_array($result))
                    {
                     $user = array();

                           $username=$row['mobileNumber'];
                           $passwd=$row['password'];




                     if(($password==$passwd) && ($userid==$username))
                        {

                           $response["success_code"] = 0;
                           $response["status"]="Success";
                           $response["message"]="Login Success";

                           $user["name"] = $row["name"];
                           $user["password"] = $row["password"];
                           $user["mobileNumber"] = $row["mobileNumber"];
                           $user["employeeId"] = $row["employeeId"];
                           $user["deviceId"] = $row["deviceId"];
                           $user["dob"] = $row["dob"];
                            array_push($response["login"], $user);
                            echo json_encode($response);
                      }
                     else
                           {
                                $user = array();
                                $response["success_code"] = 1;
                                $response["status"]="failure";
                                $response["message"]="Invalid User";
                                /*array_push($response["login"], $user);*/
                                echo json_encode($response);

                        }
              } }
                  else  {

                                 $user_not_found = array();
                                 $response["success_code"] = 1;
                                $response["status"]="not_found";
                                $response["message"]="User not found";
                                /*array_push($response["login"], $user_not_found);*/
                                echo json_encode($response);

                           }

             }
}


function register(){

 $con= mysql_connect('localhost','root','');
if(!$con)
{
die('could not connect;'.mysql_error());
}
mysql_select_db('timemanagement');

if((isset($_POST["mobileNumber"])) && ($_POST["mobileNumber"]!="") && (isset($_POST["deviceId"])) && ($_POST["deviceId"]!=""))
      {
         $userid=$_POST['mobileNumber'];
         $deviceId=$_POST['deviceId'];

         $result = mysql_query("SELECT * FROM userregistration WHERE deviceId='$deviceId'");

         if(mysql_num_rows($result) ==0){
            $result1 = mysql_query("SELECT * FROM userregistration WHERE mobileNumber='$userid'");
            if(mysql_num_rows($result1) ==0){
               $sql = "INSERT INTO `userregistration` (name,mobileNumber, password, employeeId,deviceId,dob) VALUES ('".$_POST['name']."', '".$_POST['mobileNumber']."','".$_POST['password']."', '".$_POST['employeeId']."','".$_POST['deviceId']."', '".$_POST['dob']."' )";

          mysql_select_db('timemanagement');

          $retval = mysql_query( $sql, $con );

          if(! $retval ) {
             die('Could not enter data: ' . mysql_error());

                $json = array("status" => "failure","message" => "Invalid User","code" => "1");
            }

              $json = array("status" => "success","message" => "Reegistration Success","code" => "0");
              echo json_encode($json);
          }else{
              $json = array("status" => "failure","message" =>"Mobile Number Already Exist,Please Contact Admin!!!","code" => "1");
             echo json_encode($json);
          }
          }else{

             $json = array("status" => "failure","message" =>"This Device Already Exist","code" => "1");
             echo json_encode($json);
                }

            }   else{
                     $json = array("status" => "failure","message" =>"Enter Mobile Number","code" => "1");
                 echo json_encode($json);
             }
             mysql_close($con);
}



?>