QuickCover Server Resolved

Outlet Id: $storeId

Payload

$orderList

Response

['status'=>$response_status,'response'=>$response]

'; print_r($response_status); die('hi');
            if(isset($orderData->contracts)){
              $contractData = $orderData->contracts;

              foreach ($contractData as $key => $value) {

               $currentID = get_current_user_id();
               $contrats = $this->wpdb->query(
               $this->wpdb->prepare("INSERT INTO quickcover_contract( user_id, product_id, order_id, lineitem_id, quantity, contract_id, contract_status, refund_amount, contract_canceled_by)
             VALUES ( %d, %d, %s, %s, %d, %s, %s, %s, %s)", $currentID , $value->order->product->id, $value->order->id, $value->order->orderItemId, $value->order->product->quantity, $value->id, 0, 0, 0 ));

                plugin_log(['status'=>$response_status,'response'=>$response,'request'=>$orderList]);          
              }
            }  
          } else {
              $to = 'asoanker@afterinc.com';
              $subject = 'QuickCover Create Contract API Failure : After Product Protection Plan';
              $headers = array('Content-Type: text/html; charset=UTF-8','From: noreply@quickcover.me');
              $message = "
				  
					
QuickCover Server Failure
					
Outlet Id: $storeId 


					
Payload
					
$orderList
					

					
Response
					 
['status'=>$response_status,'response'=>$response]
				
			  ";
              
               wp_mail($to, $subject, $message, $headers);
           
              $dataCron = $this->wpdb->insert('quickcover_cron_status', array(
                'order_id' => $order->get_id(),
                'status' => 404,  
                 'counter' => 0,
               'created_at' => date('Y-m-d H:i:s')				
                )); 
              plugin_log(['status'=>$response_status,'response'=>$response,'request'=>$orderList]);
            } 
          }    
       }
    }
  }

   //contract cancel from customer end.
  function woocommerce_order_item_name( $name, $item ){  
  
  $customUrl = esc_url_raw($_SERVER['REQUEST_URI']);
  $customUrl = strtolower($customUrl);
  $isOrderreceived = strpos($customUrl, 'order-received');
  $isOrderReview = strpos($customUrl, 'view-order');
  $productOrderId = $item['order_id'];
  $order = wc_get_order( $productOrderId );
  $order_status = $order->get_status();
   
  $lineItemId = $item->get_id(); 
  $item_quantity  = $item->get_quantity();
  $product_id = $item['product_id'];
    $item_warrantys = $item->get_meta_data();
	
	$get_configuration_property = $this->wpdb->get_results( $this->wpdb->prepare("SELECT * FROM app_configurations"));
	if(!empty($get_configuration_property)){
    $quickCover_status = $get_configuration_property[0]->configuration_property;
	}
    $warrantyData = $this->wpdb->get_results( $this->wpdb->prepare("SELECT * FROM product_warranty WHERE product_id=".$product_id));
	
	 if(!empty($warrantyData)){
    $pnamecustomer = $warrantyData[0]->pname;
	
   foreach ($item_warrantys as $key => $item_warranty) {
    if(isset($item_warranty->key) && ($item_warranty->key == '_warranty')){ 
      $plan_id = $item_warranty->value['plan_id'];
      if($plan_id !== 'none') {

       $description = $item_warranty->value['description'];
       $result = $this->wpdb->get_results( $this->wpdb->prepare( "SELECT * FROM quickcover_contract WHERE order_id = %s AND lineitem_id = %s", $productOrderId, $lineItemId ));
	   
 if($quickCover_status == 1 ){

if(isset($result[0]->contract_status) && $result[0]->contract_status == '200' && $result[0]->refund_amount !=''){
  $refundtxt = "Cancelled By: ".$result[0]->contract_canceled_by."
 Contract has been Cancelled Successfully. Refund ";
  
  $refundamtqty = $result[0]->refund_amount * $item['quantity'];
   $refundamt = number_format((float)$refundamtqty, 2, '.', '');

   $cancelButton = " Cancel ".$pnamecustomer." ";

     if (($isOrderreceived !== false) && ($isOrderreceived > 0)) {
           return $name." ".$description; 
      }else{
           return $name . " " . $description . " " . $cancelButton . " 
 " . $refundtxt . $this->get_currency_symbol() . $refundamt . "";
      }

} 

else if(isset($result[0]->contract_status) && $result[0]->contract_status == '250' && $result[0]->refund_amount !=''){

   $refundtxt = "Cancel Request outside the cancel period,Please contract Administrator";
   $cancelButton = " Cancel ".$pnamecustomer." ";

      if (($isOrderreceived !== false) && ($isOrderreceived > 0)) {
          return $name." ".$description;   
      }else{
          return $name." ".$description." ".$cancelButton." 
 ".$refundtxt; 
      }
	  
    } else {
    
    $results = $this->wpdb->get_results( $this->wpdb->prepare( "SELECT * FROM quickcover_contract WHERE order_id=".$productOrderId) );
    
   if (!empty($results)){
   $cancelButton = " Cancel ".$pnamecustomer."";

     if (($isOrderreceived !== false) && ($isOrderreceived > 0)) {
          return $name." ".$description;  
      }else{
          return $name." ".$description." ". $cancelButton;  
      }
    }
     else{
		
		 
        $cancelButton = " Due to technical issues, the contract has not been created yet.
 Please try again later. ";

     if (($isOrderreceived !== false) && ($isOrderreceived > 0)) {
           return $name." ".$description; 
           }else if(($isOrderReview !== false) && ($isOrderReview > 0)){
             return $name." ".$description." ". $cancelButton;   
          }else{
           return $name." ".$description;
          }
        } 
      }  
    }
   }
 }
}
  return $name ;  
 }
}
  /*Contract cancel from admin End */
  function cancel_whole_contract_from_admin( $order_id ) {
   $order = new WC_Order( $order_id ); 
   $noRefundLimit = 24 * 60; //in minutes until booking
   $user_id = get_current_user_id();
   $result = $this->wpdb->get_results( $this->wpdb->prepare( "SELECT * FROM quickcover_contract WHERE order_id = %d", $order_id ));
   
   if(!empty($result)){
   foreach ( $result as $res => $values ){
    $contractID = $values->contract_id;
    $admin_cancel_contract = array(
    'action' => 'Cancel',
    'contractId' => $contractID,
    'orderId' => $values->order_id,
    'orderItemId' => $values->lineitem_id,
    'quantity' => 1,

     );
      $admin_cancel_contract = json_encode($admin_cancel_contract);
      $result = $this->wpdb->get_results( $this->wpdb->prepare( "SELECT * FROM app_configurations WHERE id = %d", 1));

        if(!empty($result)){
        $apiKey = $result[0]->api_key;
        $storeId = $result[0]->store_id;  
       $base_url = AfterInc::API_BASE_URL;
       $url = $base_url.'contracts/outlet/'.$storeId.'/cancel';
       $args = array(
          'headers' => array(
            'Content-Type' => 'application/json',
            'X-QUICKCOVER-API-KEY' => $apiKey
          ),
          'body' => $admin_cancel_contract,
          'method'      => 'POST',
          'timeout'     => 300
        );

       $response = wp_remote_post( $url, $args );
       $response_status = wp_remote_retrieve_response_code($response);
       $response = wp_remote_retrieve_body( $response );

       if($response_status == 200) {
        $admin_contract_responce = json_decode($response,TRUE);
           
            $rfamount = ($admin_contract_responce['contracts'][0]['refundAmount']/100);
           $contractUpdate = $this->wpdb->query( $this->wpdb->prepare( "UPDATE quickcover_contract SET contract_status = %s, refund_amount = %s, contract_canceled_by = %s WHERE contract_id = %s", 200, $rfamount, 'Admin', $contractID ));
           
         }
         else if($response_status == 250){
            
         $contractUpdate = $this->wpdb->query( $this->wpdb->prepare( "UPDATE quickcover_contract SET contract_status = %s WHERE contract_id = %s", $response_status, $contractID));
            
            }else{
               echo json_encode(array("status"=>404));
            }

      $this->table_name = $this->wpdb->prefix . 'posts';
      $querystr = "
      SELECT $this->table_name.* 
     FROM $this->table_name
     WHERE $this->table_name.post_parent = $order_id";

    $pageposts = $this->wpdb->get_results($querystr, OBJECT);
    if(!empty($pageposts)) {
      $bookingId = current($pageposts)->ID;
      $bookingStart = current(get_post_meta($bookingId, "_booking_start"));
      $time = (new DateTime($bookingStart, new 
      DateTimeZone("America/Los_Angeles")))->getTimestamp();
      $nowTime = (new DateTime())->getTimestamp();
      $difference = round(($time - $nowTime)/60);//in minutes
      if($difference >= $noRefundLimit) {
          $refundPercentage = 1; //how much will we give back? fraction of 1.
          // Get Items
          $order_items   = $order->get_items();
          $refund_amount = 0;
          $line_items = array();

          if ( $order_items ) {
          foreach( $order_items as $item_id => $item ) {
          $refund_amount += $item->get_total();
           }
        }
          $refund_amount = ($refund_amount * $refundPercentage);
          $refund_reason = "Order Cancelled";
          $refund = wc_create_refund( array(
          'amount'         => $refund_amount,
          'reason'         => $refund_reason,
          'order_id'       => $order_id,
          'line_items'     => $line_items,
          'refund_payment' => true
          ));

          $order->update_status('wc-refunded', 'Order Cancelled And Completely 
          Refunded');
          }
         } 
       }
     }
    }
  }
  
  function add_loader_in_admin_order_detail_page($orderID) {
	echo '
';
  }
   /*add button order details page in admin side and cancel order functionality */
function woocommerce_before_order_itemmeta($item_id, $item, $product){
	
    $productOrderId = $item['order_id'];
    $order = wc_get_order( $productOrderId );
    $order_status = $order->get_status();
    $lineItemId = $item->get_id();
    $item_quantity  = $item->get_quantity();
    $product_id = $item['product_id'];
    $item_warrantys = $item->get_meta_data();
	
	$warrantyData = $this->wpdb->get_results( $this->wpdb->prepare("SELECT * FROM product_warranty WHERE product_id=".$product_id));  
	 if(!empty($warrantyData)){
    $pnameadmin = $warrantyData[0]->pname;
	
   foreach ($item_warrantys as $key => $item_warranty) {
     if(isset($item_warranty->key) && ($item_warranty->key == '_warranty')){ 
      $plan_id = $item_warranty->value['plan_id'];
     if($plan_id !== 'none') {
  ?>
   
     value['description'];

        echo "".esc_attr($description)."";

        $results = $this->wpdb->get_results( $this->wpdb->prepare( "SELECT * FROM quickcover_contract WHERE order_id = %s and lineitem_id = %s", $productOrderId, $lineItemId ));

     if(isset($results[0]->contract_status) && $results[0]->contract_status == '200' && $results[0]->refund_amount !=''){
	   $refundamtqty = $results[0]->refund_amount * $item['quantity'];
      $refundamt = number_format((float)$refundamtqty, 2, '.', '');
      echo '
Cancelled '.esc_attr($pnameadmin).'
Cancelled By : '.esc_attr($results[0]->contract_canceled_by).' 
Contract has been cancelled successfully.Please initiate a Refund of  ' . $this->get_currency_symbol() . esc_attr($refundamt).' to the customer.';
     }else if(isset($results[0]->contract_status) && $results[0]->contract_status == '250' && $results[0]->refund_amount !=''){
      echo '
Cancelled '.esc_attr($pnameadmin).'

Cancel Request outside the cancel period,Please contract Administrator'; 
       }
    
    else {
    $order_id = array();
    $results = $this->wpdb->get_results( $this->wpdb->prepare( "SELECT * FROM quickcover_contract" ));
    
    foreach ($results as $key => $value) { 
     $order_id[] = $value->order_id;
     }
    if (in_array($productOrderId, $order_id)){
		
		      $get_configuration_property = $this->wpdb->get_results($this->wpdb->prepare("SELECT * FROM app_configurations"));
                                    $quickCover_status = $get_configuration_property[0]->configuration_property;
                       if($quickCover_status==1){
           echo '
 Cancel '.esc_attr($pnameadmin).'
';
	   
				}
        }
      else{
       echo '
Due to technical issues, the contract has not been created yet.
Please try again later.
';

           } 
         } 
       }
     }   
   }
 }
}
  
   /*add javascript in customer side */
    function view_order_and_thankyou_page($order_id) {
      echo '
'."".'
';
   }
   
    /* bulk warranty edit function*/
     function warranty_bulk_edit_input() {
        ?>
        

          
             
             
                
                — No change —
                Enable
                Disable
                
             
            
        
        get_id();    
      if ( isset( $_REQUEST['_warranty'] ) && $_REQUEST['_warranty'] !='' ) {
        $warranty_value = sanitize_text_field($_REQUEST['_warranty']);
          update_post_meta( $post_id, '_warranty',$warranty_value);
          
      }
  }
  
  /* bulk edit sync function*/
  function sync_bulk_edit_input() {
    ?>
       

        
         
         
            
               — No change —
              Not Synced
            
         
        
    
    get_id();   
       if (isset( $_REQUEST['_sync']) && $_REQUEST['_sync'] == 'Not Synced') {
        $sync_value = sanitize_text_field($_REQUEST['_sync']);
        update_post_meta( $post_id, '_sync', wc_clean( $sync_value ) );
    }
  }
  
  /* custom filter for warranty*/
   function warranty_product_filters( $post_type ) {

// Check this is the products screen
  if( $post_type == 'product' ) {

  $Getwarranty_selected = sanitize_text_field(isset($_GET['warranty'])) ? $_GET['warranty'] : "";
  $selectedYes=($Getwarranty_selected=='Enable')?'Selected':'';
  $selectedNo=($Getwarranty_selected=='Disable')?'Selected':'';
  // Add your filter input here. Make sure the input name matches the $_GET value you are checking above.
    echo '';
    echo 'Eligible for QuickCover';
    echo 'Enable';
    echo 'Disable';

    echo '';

      }

   }
   
   /* custom filter for sync*/

   function sync_product_filters( $post_type ) {

// Check this is the products screen
    if( $post_type == 'product' ) {
    $Getsync_selected = sanitize_text_field(isset($_GET['sync'])) ? $_GET['sync'] : "";
    $selectedYes =($Getsync_selected=='Synced')?'Selected':'';
    $selectedNo =($Getsync_selected=='Not Synced')?'Selected':'';
	$selectedF =($Getsync_selected=='Failed')?'Selected':'';
	$selectedNew =($Getsync_selected=='New')?'Selected':'';
  // Add your filter input here. Make sure the input name matches the $_GET value you are checking above.
    echo '';

    echo 'QuickCover Sync';
    echo 'Synced';
    echo 'Not Synced';
	echo 'Failed';
	echo 'New';

    echo '';

    }

  }
  
   /* apply filter warranty and sync function*/
 function apply_warranty_product_filters( $query ) {

   global $pagenow;
// Ensure it is an edit.php admin page, the filter exists and has a value, and that it's the products page
 if ( $query->is_admin && $pagenow == 'edit.php' && isset( $_GET['warranty'] ) && $_GET['warranty'] != '' && $_GET['sync'] == '' && $_GET['post_type'] == 'product' ) {
  // Create meta query array and add to WP_Query
    $meta_key_query = array(
    array(
      'key'     => '_warranty',
      'value'   => sanitize_text_field( $_GET['warranty'] ),
    )
  );

    $query->set( 'meta_query', $meta_key_query );
    
 }

  elseif( $query->is_admin && $pagenow == 'edit.php' && isset( $_GET['sync'] ) && $_GET['sync'] != '' && $_GET['warranty'] == '' && $_GET['post_type'] == 'product'){
     $meta_key_query = array(
      array(
        'key'     => '_sync',
        'value'   => sanitize_text_field( $_GET['sync'] ),
       )
    );
      $query->set( 'meta_query', $meta_key_query ); 
   }

  elseif($query->is_admin && $pagenow == 'edit.php' && isset( $_GET['sync'] ) && $_GET['sync'] != '' && $_GET['warranty'] != '' && $_GET['post_type'] == 'product'){
    $meta_key_query = array(
    array(
      'key'     => '_warranty',
      'value'   => sanitize_text_field( $_GET['warranty'] ),
    ),
     array(
        'key'     => '_sync',
        'value'   => sanitize_text_field( $_GET['sync'] ),
      )
  );
 //echo '
';print_r($meta_key_query);echo '
';

     $query->set( 'meta_query', $meta_key_query );
   }
 }

  /**
 * Adds "Import" button on module list page
 */
public function addCustomImportButton()
{
    ?>
         
    isSMTP();    
        $phpmailer->Host = 'email-smtp.us-east-1.amazonaws.com';
        $phpmailer->SMTPAuth = true; // Ask it to use authenticate using the Username and Password properties
        $phpmailer->Port = 587;
        $phpmailer->Username = 'AKIAUEBI6KITMPVFRS5M';
        $phpmailer->Password = 'BKM3nw0o2nEKhMrKbOXsBL8ReD3ZRabjSkvqHfQJOKo/';
        $phpmailer->SMTPSecure = 'tls'; // Choose 'ssl' for SMTPS on port 465, or 'tls' for SMTP+STARTTLS on port 25 or 587
        $phpmailer->From = "noreply@quickcover.me";
		$phpmailer->FromName = "QuickCover";
     }
	 
	 
	 function save_custom_bulk_edit_data($post_id) {

    if($_REQUEST['action'] === 'edit'){
        
     $appConfig = $this->wpdb->get_results($this->wpdb->prepare("SELECT * FROM app_configurations WHERE id = %d", 1));
    
      $productsbulk_data = array();
      global $woocommerce,$product; 
        $all_cat = $_GET['tax_input']['product_cat'];

        $cat_name = [];
        foreach ($all_cat as $key => $valueid) {
             $allterm = get_term_by( 'id', $valueid, 'product_cat');
             if(isset($allterm->name)){
                $cat_name[] = trim($allterm->name);
             }    
        }
        
      if(!empty($appConfig)){

       $api_key = $appConfig[0]->api_key;
       $quick_store_id = $appConfig[0]->store_id;
       $autosync_status = $appConfig[0]->sync_type;

       if($autosync_status == 1){
       global $woocommerce,$product; 

       $productsbulk_data = array();
       $getselected_data = $_REQUEST['post'];

      foreach ($_REQUEST['post'] as $product_id) {

        $product_list = wc_get_product($product_id);
        
        $priceCurrency = get_option('woocommerce_currency');

        $name = $product_list->get_name();

        $pricebulk = ($product_list->get_price() != '') ? $product_list->get_price() : '';
       $sku = ($product_list->get_sku() != '') ? $product_list->get_sku() : $product_id;
       $description = ($product_list->get_description() != '') ? $product_list->get_description() : '';
       $model = ($product_list->get_sku() != '') ? $product_list->get_sku() : $product_id;

       $category = ($product_list->get_categories() != '') ? trim($product_list->get_categories()) : '';
       $category = strip_tags($category);
       

        if ($category == "uncategorized") {
                $category = "";
        }

        $category_into_array= explode(",",$category);
        $category_into_array=array_map('trim',$category_into_array);
        $final_array = array_merge($category_into_array,$cat_name);
        $new_final_array  = array_unique($final_array);
        
        
        $productsbulk_data['priceCurrency'] = $priceCurrency;
        $productsbulk_data['id'] = $product_id;
        $productsbulk_data['category'] = implode(',',$new_final_array);
        $productsbulk_data['description'] = $description;
        $productsbulk_data['model'] = $model;
        $productsbulk_data['price'] = (100*(float)$_GET['_regular_price']) ? (100*(float)$_GET['_regular_price']) : 100*($pricebulk);
        $productsbulk_data['name'] = $name;
        $productsbulk_data['sku'] = $sku;
        $data[] = $productsbulk_data;

        }
      
        $productbulk_array['data'] = $data;
         $productbulk_Json = json_encode($productbulk_array);
        $base_url = AfterInc::API_BASE_URL;
        $url = $base_url . 'products/batch/outlet/' . $quick_store_id . '?upsert=true';

        $body = array(
                'headers' => array(
                'Content-Type' => 'application/json',
                'X-QUICKCOVER-API-KEY' => $api_key
                ),
                'body' => $productbulk_Json,
                'method'      => 'POST',
                'timeout' => 300
                );

                $response = wp_remote_post($url, $body);
                $response_status = wp_remote_retrieve_response_code($response);
                $response = wp_remote_retrieve_body($response);
                $table_name = $this->wpdb->prefix . 'postmeta';

             if($response_status == 202){
                
                foreach ($productbulk_array['data'] as $postid){
                    
                update_post_meta((int)$postid['id'], '_sync', 'Synced');   
                } 
                
                  plugin_log(['status' => $response_status, 'response' => $response, 'request' => $productbulk_Json]);
                  } 

                  else
                  {
                    foreach ($productbulk_array['data'] as $postid ){
                    
                     update_post_meta((int)$postid['id'], '_sync', 'Failed'); 
                    }
                plugin_log(['status' => $response_status, 'response' => $response, 'request' => $productbulk_Json]);
              }
          } else{
                 $getselected_data = $_REQUEST['post'];
                foreach ($getselected_data as $postid ){
                 
                 update_post_meta((int)$postid, '_sync', 'Not Synced'); 
                }

                plugin_log(['status' => $response_status, 'response' => $response, 'request' => $productbulk_Json]);
          }    
       }
    }
}
 

    //cron code start here
    function order_scheduler_cron() {
      
      ini_set('max_execution_time', '300'); 
      $appConfig = $this->wpdb->get_results( $this->wpdb->prepare( "SELECT * FROM app_configurations WHERE id = %d", 1 ));
      $cronStatus = $this->wpdb->get_results ("SELECT * FROM quickcover_cron_status WHERE status = 404 ORDER BY order_id DESC ");
      if(!empty( $cronStatus)){
          
        foreach ($cronStatus as $key => $value) { 
            
        $order_id = $value->order_id; 
        $order = wc_get_order($order_id); 
		 $email = $order->get_billing_email();
        $fname = $order->get_billing_first_name();
       // $customername = $order->billing_first_name() .' '.$order->billing_last_name();
        if(!empty($order)){
           $order_no =   $order->get_id(); 
           $order_data = $order->get_data();
           $order_items = $order->get_items();
           $srlNo = count($order_items);
           $order_date = $order->get_date_created()->format('Y-m-d H:i:s');
           $order_status  = $order->get_status(); 
              
          if($order_status !== 'cancelled'){
            $orderItem = array(); $in_warranty = array();
			$planNameArr = array();
            $planTitle = null;
            foreach ( $order_items as $key => $item ) {
              $lineitem_id = $item->get_id();
              $productID = $item->get_product_id();

              $result = $this->wpdb->get_results( $this->wpdb->prepare( "SELECT * FROM product_warranty WHERE product_id = %d ", $productID));

              if(!empty($result)){

                 $planTitle = $result[0]->pname;
                $planDatas = $item->get_meta_data();
                $planDatas = $item->get_meta_data();
                $planName = '';
                $planPrice = '';
                foreach ($planDatas as $key => $planId) {
                  if(isset($planId->key) && ($planId->key == '_warranty')) {
                      $plan_id = $planId->value['plan_id'];
                      if($plan_id !== 'none') {
                       $in_warranty[] = $result[0]->product_id;
                       $plans = json_decode($result[0]->plans, TRUE);

                        foreach ($plans as $key => $plan) {
                          if($plan['planId'] == $plan_id){
                           $contract = array(
                              'priceCurrency' => $result[0]->priceCurrency,
                              'planId' => $plan['planId'],
                              'price' => $plan['price'],
                              'quantity' => $item->get_quantity(),
                            );
							$planName = $plan['description'];  
                            $planPrice = $plan['price']*$item->get_quantity();
                           }   
                         }

                         $orderItem[] = array(
                         'id' => $lineitem_id,
                         'product' =>array(
                             'priceCurrency' => $result[0]->priceCurrency,
                             'id' => $item->get_product_id(),
                             'contract' => $contract,
                             'purchasePrice' => (float) ($item->get_product()->get_price())*100,
                             'quantity' => $item->get_quantity(),
                             'serialNumber'=> $srlNo
                           )
                         ); 
                    }
                  }
                }
			  $planNameArr[] = $planName;
              $planpriceArr[] = $planPrice;
              }
            }

            if(!empty($in_warranty)) {

               if(($order_data['billing']['address_1'] == "")) {
                 $order_data['billing']['address_1'] = "null";
               }
               if(($order_data['billing']['address_2'] == "")) {
                 $order_data['billing']['address_2'] = "null";
               }
               if(($order_data['billing']['city'] == "")) {
                 $order_data['billing']['city'] = "null";
               }
              if(($order_data['billing']['postcode'] == "")) {
                 $order_data['billing']['postcode'] = "null";
               }
              if(($order_data['billing']['country'] == "")) {
                 $order_data['billing']['country'] = "null";
               }

               if(($order_data['shipping']['address_1'] == "")) {
                 $order_data['shipping']['address_1'] = "null";
               }
               if(($order_data['shipping']['address_2'] == "")) {
                 $order_data['shipping']['address_2'] = "null";
               }
               if(($order_data['shipping']['city'] == "")) {
                 $order_data['shipping']['city'] = "null";
               }
               if(($order_data['shipping']['postcode'] == "")) {
                 $order_data['shipping']['postcode'] = "null";
               }
               if(($order_data['shipping']['country'] == "")) {
                $order_data['shipping']['country'] = "null";
              }

              $order_array = array(
                 'priceCurrency' => $order_data['currency'],
                 'id' => $order_data['id'],
                'customer'=> array(
                   'givenName'  => $order_data['billing']['first_name'],
                   'alternateName' => "kumar",
                   'lastName' => $order_data['billing']['last_name'],
                   'email' => $order_data['billing']['email'],
                   'phone' => $order_data['billing']['phone'],
                   'billingAddress'=>array(
                   'address1' => $order_data['billing']['address_1'],
                   'address2' => $order_data['billing']['address_2'],
                  'locality' => $order_data['billing']['city'],
                   'postalCode' => $order_data['billing']['postcode'],
                   'region' => $order_data['billing']['country'],
                  ),
                   'shippingAddress'=>array(
                     'address1' => $order_data['shipping']['address_1'],
                     'address2' => $order_data['shipping']['address_2'],
                     'locality' =>  $order_data['shipping']['city'],
                     'postalCode' => $order_data['shipping']['postcode'],
                     'region' => $order_data['shipping']['country'],
                     ),
                   ),
                   'purchaseDate'=> $order_date,   
                   'totalPrice' =>  (float) ($order->get_total())*100,
                   'poNumber'=> $order_id,
                   'orderItem' => $orderItem 
              );
              
              $orderList = json_encode($order_array); 
                 
              if(!empty($appConfig)){
				 $apiKey = $appConfig[0]->api_key;
                 $storeId = $appConfig[0]->store_id;  
                 $toemail = $appConfig[0]->email;
                 $currentadmin_login = $appConfig[0]->user_id;
                 $tablename = $this->wpdb->prefix . 'users';
                
                 $get_admindetails = $this->wpdb->get_results($this->wpdb->prepare("SELECT user_login FROM $tablename WHERE ID = %s ", $currentadmin_login));
                 $merchant_login=$get_admindetails[0]->user_login;
                   $base_url = AfterInc::API_BASE_URL;
                   $url = $base_url.'orders/outlet/'.$storeId;
                   $args = array(
                     'headers' => array(
                       'Content-Type' => 'application/json',
                       'X-QUICKCOVER-API-KEY' => $apiKey
                     ),
                     'body' => $orderList,
                     'method'    => 'POST',
                     'timeout'     => 300
                     );
                   
                    $response = wp_remote_post($url, $args);
                    $response_status = wp_remote_retrieve_response_code($response);
                    $response = wp_remote_retrieve_body( $response );
                    $orderData = json_decode($response);
                plugin_log(['contract_status'=>$response_status,'response'=>$response,'request'=>$orderList]);

                if($response_status==201){
					 plugin_log('resolved');
                if(isset($orderData->contracts)){
                    $contractData = $orderData->contracts;
                    foreach ($contractData as $key => $value) {
                     $currentID = get_current_user_id();
                     $contrats = $this->wpdb->query(
                     $this->wpdb->prepare("INSERT INTO quickcover_contract( user_id, product_id, order_id, lineitem_id, quantity, contract_id, contract_status, refund_amount, contract_canceled_by)
                     VALUES ( '%d', '%d', '%s', '%s', '%d', '%s', '%s', '%s', '%s')", $currentID , $value->order->product->id, $value->order->id, $value->order->orderItemId, $value->order->product->quantity, $value->id, 0, 0, 0 ));  
                       }
                    }
                    $remove = $this->wpdb->query(
                    $this->wpdb->prepare( "DELETE FROM quickcover_cron_status WHERE order_id = %d", $order_id)); 
                  plugin_log(['contract_status'=>$response_status,'response'=>$response,'request'=>$orderList]);
                              
                   $to = 'asoanker@afterinc.com';
                   $subject = 'QuickCover Create Contract API Success : After Product Protection Plan';
                 
                   $headers = array('Content-Type: text/html; charset=UTF-8','From: noreply@quickcover.me');
                   $message = "
                          
                            
QuickCover Server Resolved
                            
Outlet Id: $storeId 


                            
Payload
                            
$orderList
                            

                            
Response
                           
['status'=>$response_status,'response'=>$response]
                         ";
              
                     wp_mail($to, $subject, $message, $headers);
                   }
                 else{
                     
                     $this->wpdb->query($this->wpdb->prepare("UPDATE quickcover_cron_status SET `counter`=(`counter`+1) WHERE `order_id` = " . $order_no . " "));

                     $increment_ord = $this->wpdb->get_results($this->wpdb->prepare("SELECT counter FROM quickcover_cron_status WHERE order_id = %d", $order_no));
                    
                     $planName = implode(",", $planNameArr);
                     $totalplan = array_sum($planpriceArr)/100;
                     $siteTitleName = get_bloginfo('name');
                    // plugin_log('createdTimeDb::'.$value->created_at);
                    // $dtt = date('Y-m-d H:i:s',strtotime($value->created_at));
                    // plugin_log($dtt ." & ". date('Y-m-d H:i:s'));
                    // $diffItmer = round($this->differenceInHours($dtt,date('Y-m-d H:i:s')),2);
                    // plugin_log("diffminute::".$diffItmer);
                     
                       if ($increment_ord[0]->counter > 11) {
                            plugin_log('checking if part for final:');
                            $to = $toemail;
                            $subject = 'After Product Protection Plan BC Failure Action Required!';
                             $headers = array('Content-Type: text/html; charset=UTF-8','From: noreply@quickcover.me',
                             'CC: asoanker@afterinc.com');        
                            $message = '
                          
                        
                       
                        
                      
                
             
      
     
    

Hello ' . $admin_login . '

Your customer has been cancelled ' . $planDesc . ' Please initiate a refund of $' . $subtotal . ' through '.$siteTitle.'. Here are the order details:

Order Number: ' . $orderID . ' Order Date: ' . date("m/d/Y", strtotime($orderDate)) . ' Customer Name: ' . $fullName . ' Customer Email: ' . $billing_email . ' Quantity: ' . $item_quantity . ' Plan Cancelled: ' . $cancelPlan . '

If you have any questions about your account, please contact quick-techsupport@afterinc.com and we’ll get right back to you. Reference: Store Id:' . $storeId . ' Woocommerce

Thank you again for using QuickCover Sincerely, QuickCover Support

Copyright © 2023 All Rights Reserved | After, Inc. Powered by QuickCover®

Hello ' .$merchant_login .' Your customer has attempted to purchase the '.$planTitle.' through ' .$siteTitleName .'.

Due to technical difficulties, we are unable to fulfill the request. Please cancel the plan order through the app and initiate a refund of $'.$totalplan.'. Click here for instructions. Here are the order details:

Order Number: '.$order_id .' Order Date: '. date("m/d/Y",strtotime($order_date)).' Customer Name: '.$fname.' Customer Email: '.$email.' Plan Purchased: '.$planTitle.": ".$planName.'

If you have any questions about your account, please contact quick-techsupport@afterinc.com and we’ll get right back to you. Reference: '.$storeId.' Woocommerce

Thank you again for using QuickCover Sincerely, QuickCover Support

Copyright © 2023 All Rights Reserved | After, Inc. Powered by QuickCover®