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

    $utility = new Utility();

	if(isset($argv[1])){
		parse_str($argv[1], $params);
		
		if(isset($params['apiKey']) && $params['apiKey'] === '1424774485253740'){
		   	//success
            $current_year = $db->select("SELECT YEAR(CURDATE()) AS year_now");

			//check if operation is activated
			$query = "SELECT status FROM auto_txt_blast WHERE id = 4"; // pdc reminder
            $status = $db->select($query);

			if($status == 1){
                $rem_day = array(); $reminder = array();

                $remaining_days = $db->select("SELECT remaining_days FROM auto_txt_blast WHERE id = 4"); 
                $rem_day = explode(",", $remaining_days);
                
                for($i=0; $i<count($rem_day); $i++){
                    $current_date = $db->select("SELECT CURDATE()");
                    
                    $var_date = $db->select("SELECT DATE_ADD(CURDATE(), INTERVAL " . $rem_day[$i] . " DAY)");
                    $var_date_eng = $db->select("SELECT DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL " . $rem_day[$i] . " DAY), '%b. %d, %Y')");

                    $count = " COUNT(*) ";
                    $fields = " fp.id, fp.check_date "; 

                    $query = "SELECT %s 
                        FROM finance_pdc fp 
                        WHERE fp.check_date = '$var_date' AND fp.status = 1"; 
                    // echo sprintf($query, $fields); return;
                    
                    $result_count = $db->select(sprintf($query, $count));

                    if($result_count > 0){
                        $fetch_query = $db->sql_query(sprintf($query, $fields));
                        $reminder_type = $rem_day[$i] . " day(s)";

                        foreach($fetch_query AS $row){
                            $pdc_id = $row['id'];
                            $check_date = $row['check_date'];

                            $insert_query = "INSERT INTO `txtblast_pdc_reminder_record` (`pdc_id`, `check_date`, `action_date`, `reminder_type`, `sms_response`) 
                                            VALUES ('$pdc_id', '$check_date', '', '$reminder_type', -1)"; 

                            $db->sql_query($insert_query);
                        }
                    }
                }
		   		return; //always execute this 
			}
		}
	}

	echo "What are you doing?"; //this will appear if there's an error on param or code

    function checkForValidNumber($data, $utility){
        $data_to_return = "";
        if(strpos($data, '/') > 0){
            $multi_mobile = array();
            $multi_mobile = explode("/", $data);
    
            $multi_mobile[0] = $utility->fix_mobile_format(remove_non_numeric($multi_mobile[0]));
            $multi_mobile[1] = $utility->fix_mobile_format(remove_non_numeric($multi_mobile[1]));

            $isValid1 = isMobileValid($multi_mobile[0]);

            if($isValid1 == 1){ // mobile 1 is valid
                $data_to_return = $multi_mobile[0];
            } 
            else { // mobile 2 instead
                $isValid2 = isMobileValid($multi_mobile[1]);
                if($isValid2 == 1){ // mobile 1 is valid
                    $data_to_return = $multi_mobile[1];
                } 
                else { // if mobile 2 is still not valid, return mobile 1, may lead to invalid mobile number
                    $data_to_return = $multi_mobile[0];
                }
            }
        } 
        else {
            $data_to_return = $data;
        }

        return $data_to_return;
    }

    function isMobileValid($data){
        if(substr($data, 0, 4 ) === "+639"){
            if(strlen($data) == 13){
                return 1;
            }
            else {
                return 0;
            }
        } 
        else {
            return 0;
        }
    }

    function remove_non_numeric($data){
        return preg_replace("/[^0-9\/s\/]/", "", $data);
        // return preg_replace("/[^0-9]/","",$data);
    }
?>