<?php
    include_once("../../cfg/db.php"); 
    include_once("../../api/controllers/utility.php");

    $utility = new Utility();

    $type = $db -> escape(trim($_GET['type']));
    $filter_status = "";
    $get_status = -3;

    if($type == 1){ // get data for table
        if(isset($_GET['search'])){
            $search = $db -> escape(trim($_GET['search']));
        } 
        else {
            $search = "";
        }
    
        if(isset($_GET['offset'])){
            $offset = $db -> escape(trim($_GET['offset']));
        } else {
            $offset = "";
        }
    
        if(isset($_GET['limit'])){
            $limit =   $db -> escape(trim($_GET['limit']));
            $offset_limit = " LIMIT ". $offset.",".$limit;
        } else {
            $offset_limit = "";
        }

        if(isset($_GET['filter_status']) && $_GET['filter_status'] != ""){
            $get_status = $db -> escape(trim($_GET['filter_status']));
            if($get_status > 0){
                $filter_status = " AND tbssa.status > 0 ";
            } else {
                $filter_status = " AND tbssa.status = $get_status ";
            }
        } else {
            $filter_status = ""; 
            $get_status = -3; 
        }
    
        $request_id = $db -> escape(trim($_GET['filter_data']));
    
        $json_arr['rows'] = array();
    
        $count = " count(tbssa.id) ";
        $fields = " tbssa.cust_id, tbssa.first_name, tbssa.last_name, tbssa.suffix, tbssa.company_name, tbssa.mobile_number, tbssa.status, tbssa.customer_type ";
    
        $company_query = "SELECT %s FROM `txtblast_sms_service_approved` tbssa 
            INNER JOIN `text_blast` tb 
            ON tbssa.request_id = tb.id 
            WHERE tbssa.request_id = '$request_id' " . $filter_status . " AND concat(tbssa.cust_id, tbssa.first_name, tbssa.last_name) LIKE '%%%s%%'";
        // echo sprintf($company_query,$fields,$search)." $offset_limit"; return;
        $company_list_query =  $db -> sql_query(sprintf($company_query, $fields, $search)." $offset_limit");
        // echo sprintf($company_query, $fields, $search); return;
      
        $company_list_query_count = $db->select(sprintf($company_query,$count,$search));
         
        while($row = $company_list_query->fetch_assoc()) {
            $name = ""; $suffix = "";

            //suffix
            if($row['suffix'] == "None"){
                //do nothing
            } 
            else {
                $suffix = $row['suffix'];
            }
            
            //check customer type
            if($row['customer_type'] == 1){
                $name = $row['first_name'] . " " . $row['last_name'] . " " . $suffix;
            } 
            else {
                $name = $row['company_name'];
            }
            
            $json_arr['rows'] = array_merge($json_arr['rows'], array(array(
                'cust_id'=>$row['cust_id'], 
                'name'=>$name, 
                'mobile_number'=>"+" . $utility->mask($row['mobile_number'], 5, 1), 
                'status'=>$row['status'] == -1 ? "<span style='color:orange; font-weight:bold'>Pending</span>" : 
                    ($row['status'] == 0 ? "<span style='color:green; font-weight:bold'>SMS Sent</span>" : 
                    ($row['status'] == 1 ? "<span style='color:red; font-weight:bold'>Invalid number</span>" : 
                    ($row['status'] == 2 ? "<span style='color:red; font-weight:bold'>Unsupported number prefix</span>" : 
                    ($row['status'] == -2 ? "<span style='color:blue; font-weight:bold'>SMS not yet activated</span>" : 
                    "<span style='color:red; font-weight:bold'>Send error: Itexmo status: ".$row['status']."</span>"))))
            )));
        }
      
        $json_arr['total'] = $company_list_query_count; //total number of result
        
        echo json_encode($json_arr);
    }
    else if($type == 2){ // get data for counting
        $request_id = $db -> escape(trim($_GET['request_id']));

        $query_total = "SELECT COUNT(*) FROM `txtblast_sms_service_approved` WHERE `request_id` = '$request_id'"; //total
        $query_sent = "SELECT COUNT(*) FROM `txtblast_sms_service_approved` WHERE `request_id` = '$request_id' AND `status` = 0"; //change this on 0 when in live, -2 in test
        $query_pending = "SELECT COUNT(*) FROM `txtblast_sms_service_approved` WHERE `request_id` = '$request_id' AND `status` = -1"; //pending
        $query_unsent = "SELECT COUNT(*) FROM `txtblast_sms_service_approved` WHERE `request_id` = '$request_id' AND `status` > 0"; //unsent
        //echo $query_sent; return;

        $arr['count_total'] = $db->select($query_total);
        $arr['count_sent'] = $db->select($query_sent);
        $arr['count_pending'] = $db->select($query_pending);
        $arr['count_unsent'] = $db->select($query_unsent);

        // get request status for print button status
        $request_status = "";
        $fetch_status = $db->sql_query("SELECT status FROM request_status WHERE request_id = '$request_id'");
        foreach($fetch_status AS $data){
            $request_status = $data['status'];
        }

        $arr['request_status'] = $request_status;

        echo json_encode($arr);
    }
?>