<?php

date_default_timezone_set('Asia/Kolkata');
error_reporting(E_ALL ^ (E_NOTICE | E_WARNING | E_DEPRECATED));
session_start();
require_once('db.connect.php');

$uname = trim(mysqli_real_escape_string($conn, $_POST['dealer_phone']));
$password = trim(mysqli_real_escape_string($conn, $_POST['password']));
if (empty($uname))
{
    echo "Please enter phone number";
    exit;
}
else
{
    $sql = "SELECT * from shop_user  where new_status='1' and phone='$uname' and password='$password' and user_id!='97' order by user_id desc";
    if ($result = mysqli_query($conn, $sql))
    {
        $rowcount = mysqli_num_rows($result);
        if($rowcount < 1)
        {
            echo "Incorrect phone number or password";
            exit;
        }
        else
        {
            $row = mysqli_fetch_assoc($result);
            $free_id="";
            $get_main = mysqli_query($conn, "SELECT * from tbl_dealer_ef_main where dealer_id='".$row['user_id']."' order by id desc");
            while($set_main = mysqli_fetch_assoc($get_main)){
            $get_sub = mysqli_query($conn, "SELECT * FROM tbl_dealer_ef_sub WHERE order_id='".$set_main['id']."' AND ref_order_id IS NULL and stock_status in ('ordered', 'added by admin')");
            $check_sub = mysqli_num_rows($get_sub);
            if($check_sub > 0){
               $free_id=$set_main['id'];
               break;
            }  
            }

            if($free_id !=""){
                
            $_SESSION['dealer_id'] = $row['user_id'];
            $_SESSION['name'] = $row['name'];
            $_SESSION['city'] = $row['city'];
            $action = 'edit_order.php?order_id='.$free_id;
                  $arr = array('status'=>'success', 'url'=>$action);
                  echo json_encode($arr);
                  exit;
            }else{
            $action="shopping_cart_ef.php";
            $_SESSION['dealer_id'] = $row['user_id'];
            $_SESSION['name'] = $row['name'];
            $_SESSION['city'] = $row['city'];
            $arr = array('status'=>'success', 'url'=>$action);
            echo json_encode($arr);
            exit;
            }
           
        }
    }
    else
    {
        echo "Something went wrong. Please try again";
        exit;
    }
}
?>