<?php

/**
 * Plugin Name: API For Admin Smart-Phones.
 * Description: Custom API for Admin Smart Phones.
 * Version: 1.0.2
 * Author: Itrosys
 * 
 */


add_action("rest_api_init", "api_smart_phone_admin");

$key2 = "NQPwRJMe0ogMWL8e2cl7pgElt8vaAWf=";

function api_smart_phone_admin(){

    /**Operator base */
    $p_commonPathOperator = "api/admin/operator";
    $p_apiuser = "api/admin/user";
    $p_apiproduct = "api/admin/product";
    /** Get OTP API */

    /**show all users */
    register_rest_route($p_apiuser, "getUsers", array('methods' => 'POST', 'callback' => 'showUsersadminfadmin'));
    /** Enquiry form to get lead */
    register_rest_route($p_apiproduct, "getEqnuries", array('methods' => 'POST', 'callback' => 'getEqnuriesfadmin'));

    /**show request quotes */
    register_rest_route($p_apiproduct, "showRFQ", array('methods' => 'POST', 'callback' => 'showRfqfadmin'));
}

/** show all user admin */
function showUsersadminfadmin($request)
{
    $parametresen =  $request->get_body_params() ?? array();
    $parametres =  decryptdaata($parametresen['params']);

    $date1 = $parametres['start_date'];
    $date2 = $parametres['end_date'];
    $user_id = $parametres['user_id'];

    $args1 = array(
        'role' => 'customer', //subscriber',
        'orderby' => 'ID',
        'order' => 'ASC',

    );
    $resulta = get_users($args1);
    $resultdata = [];
    if (count($resulta) > 0) {
        for ($i = 0; $i < count($resulta); $i++) {
            $user = (array)$resulta[$i];
            $resultd = $user['data'];
            unset($resultd->user_login);
            unset($resultd->user_pass);
            $user_meta['user_phone'] =  get_user_meta($resultd->ID, 'user_phone', true);
            $user_meta['first_name'] =  get_user_meta($resultd->ID, 'first_name', true);
            $user_meta['last_name'] =  get_user_meta($resultd->ID, 'last_name', true);
            $user_meta['display_name'] = $resultd->display_name;
            $user_meta['ID'] = $resultd->ID;
            $user_meta['display_name'] = $resultd->display_name;
            $user_meta['user_email'] = $resultd->user_email;
            $user_meta['user_registered'] = $resultd->user_registered;
            $resultdata[] =  $user_meta;
        }
    }
    //     $resulta = array("data" => $results ?? [], 'success' => 1);
    // $encrypted = encryptdaata($resulta);
    return new WP_REST_Response($resultdata, 200);
}


function getEqnuriesfadmin($request)
{
    $parametres = $request->get_body_params();
    // $parametres =  decryptdaata($parametresen['params']);

    $date1 = $parametres['start_date'];
    $date2 = $parametres['end_date'];
    $user_id = $parametres['user_id'];
    $lead_phone = $parametres['lead_phone'];
    $limit = " limit 20";
    $datesBetween = "";
    if (!empty($date1)  && !empty($date2)) {
        $limit = "";
        $datesBetween = "  date(lead_created_on) between '$date1' and '$date2' ";
    }
    if ($lead_phone != "") {
        $whereuserid = " lead_phone='$lead_phone' ";
    }
    if (!empty($user_id)) {
        if (!empty($lead_phone)) {
            $whereuserid = " (lead_phone='$lead_phone' or user_id='$user_id') ";
        } else {
            $whereuserid = "  user_id='$user_id' ";
        }
    }
    global $wpdb;
    $table_name = "wp_leads";
    $whereQuery = $datesBetween .  (!empty($datesBetween) && !empty($user_id)) ?  " and $datesBetween  " : $whereuserid;
    $whereQuery =  !empty(trim($whereQuery)) ? " where $whereQuery " : "";
    // $rfqquery = "select * from $table_name where  $whereQuery order by id desc $limit";
    $rfqquery = "SELECT * from $table_name  $whereQuery  order by id desc $limit";
    // die($rfqquery);
    $count  = $wpdb->query("SELECT count(*) as count from $table_name  $whereQuery ");
    // die("connttt $count");
    $results = $wpdb->get_results($rfqquery, ARRAY_A);
    if ($wpdb->last_error) {
        $resultdata = array("message" => "sumthing went wrong.");
        return new WP_REST_Response($resultdata, 400);
    }
    if (count($results ?? []) > 0) {
        $results = $results ?? [];
        // for($i = 0; $i < count($results); $i++){
        //     $res  =  (object) $results[$i];
        //     $image = wp_get_attachment_image_src(get_post_thumbnail_id($res->product_id), 'thumbnail'); //'single-post-thumbnail');
        //     $results[$i]['image'] = $image;
        // }
        $resulta = array("data" => $results ?? [], 'success' => 1);
        // $encrypted = encryptdaata($resulta);
        return new WP_REST_Response($resulta, 200);
    } else {
        $resultdata = array("message" => "No Enquiry requested yet. Raise a request for Enquiry.", 'success' => 0);
        return new WP_REST_Response($$resultdata, 400);
    }
}

function showRfqfadmin($request)
{
    $parametres =  $request->get_body_params() ?? array();
    // $parametres =  decryptdaata($parametresen['params']);

    $date1 = $parametres['start_date'];
    $date2 = $parametres['end_date'];
    $user_id = $parametres['user_id'];
    $limit = " limit 20";
    $datesBetween = "";
    if (!empty($date1)  && !empty($date2)) {
        $limit = "";
        $datesBetween = "  date(requested_on) between '$date1' and '$date2' ";
    }
    if (!empty($user_id)) {
        $whereuserid = " user_id='$user_id' ";
    }
    global $wpdb;
    $table_name = "wp_request_quote";
    $whereQuery = $datesBetween .  (!empty($datesBetween) && !empty($user_id)) ?  " and $datesBetween  " : $whereuserid;
    $whereQuery =  !empty(trim($whereQuery)) ? " where $whereQuery " : "";

    // $rfqquery = "select * from $table_name $whereQuery order by id desc $limit";
    $rfqquery = "SELECT * from `wp_request_quote` $whereQuery  order by id desc $limit";
    // die($rfqquery);
    $count  = $wpdb->query("SELECT count(*) as count from `wp_request_quote` $whereQuery ");
    // die("connttt $count");
    $results = $wpdb->get_results($rfqquery, ARRAY_A);
    if ($wpdb->last_error) {
        $resultdata = array("message" => "sumthing went wrong.");
        return new WP_REST_Response($resultdata, 400);
    }
    if (count($results ?? []) > 0) {
        $results = $results ?? [];
        for ($i = 0; $i < count($results); $i++) {
            $res  =  (object) $results[$i];
            $image = wp_get_attachment_image_src(get_post_thumbnail_id($res->product_id), 'thumbnail'); //'single-post-thumbnail');
            $results[$i]['image'] = $image;
        }
        $resulta = array("data" => $results ?? [], 'success' => 1);
        $encrypted = encryptdaata($resulta);
        return new WP_REST_Response($resulta, 200);
    } else {
        $resultdata = array("message" => "No Qoutes created yet. Raise a request for Quote.", 'success' => 1);
        return new WP_REST_Response($$resultdata, 200);
    }
}