<?php

 global $wpdb;
        $table = $wpdb->prefix . "posts";
        $table1 = $wpdb->prefix . "wc_order_stats";

        $order_id    =  $wpdb->get_results( $wpdb->prepare(" SELECT ID FROM ".$wpdb->prefix."posts WHERE post_status IN ('wc-processing', 'wc-completed') ")); // db call ok; no-cache ok
        $order_id = json_decode(json_encode($order_id),true);
        //success amount
        $order_suc_amount    =  $wpdb->get_results( $wpdb->prepare(" SELECT SUM(net_total) FROM ".$wpdb->prefix."wc_order_stats WHERE status IN ('wc-processing', 'wc-completed') AND date_created > now() - INTERVAL 45 day ")); // db call ok; no-cache ok
        $order_suc_amount1 = json_decode(json_encode($order_suc_amount),true);
         $array = json_decode(json_encode($order_suc_amount1),true);
      
         foreach($array as $arr2){
            foreach($arr2 as $aid=>$order_suc_amt){
                $order_suc_amt;
		if( $order_suc_amt== "")
                {
                $order_suc_amt=0;
                }
                
            }
        }
        
        //failed amount
        $order_failed_amount = $wpdb->get_results( $wpdb->prepare(" SELECT SUM(net_total) FROM ".$wpdb->prefix."wc_order_stats WHERE status = 'wc-on-hold' AND date_created > current_date - INTERVAL 45 day")); // db call ok; no-cache ok
        $order_failed_amount1 = json_decode(json_encode($order_failed_amount),true);
         $array = json_decode(json_encode($order_failed_amount1),true);
         foreach($array as $arr2){
            foreach($arr2 as $aid=>$order_failed_amt){
                $order_failed_amt;
                if( $order_failed_amt == "")
                {
                $order_failed_amt=0;
                }
            }
        }
      
        //cancelled amt
        $order_failed1_amount    =  $wpdb->get_results( $wpdb->prepare(" SELECT SUM(net_total) FROM ".$wpdb->prefix."wc_order_stats WHERE status = 'wc-failed' AND date_created > current_date - INTERVAL 45 day ")); // db call ok; no-cache ok
        $order_failed1_amount1 = json_decode(json_encode($order_failed1_amount),true);
         $array = json_decode(json_encode($order_failed1_amount1),true);
         foreach($array as $arr2){
            foreach($arr2 as $aid=>$order_failed1_amt){
                $order_failed1_amt;
                 if( $order_failed1_amt == "")
                {
                $order_failed1_amt=0;
                }
            }
        }
        $total_failed_amt=$order_failed_amt + $order_failed1_amt;

        //succes count
        $order_success    =  $wpdb->get_results( $wpdb->prepare(" SELECT COUNT(*) FROM ".$wpdb->prefix."posts WHERE post_status IN ('wc-processing', 'wc-completed') AND post_date > current_date - INTERVAL 45 day  ")); // db call ok; no-cache ok
        $array = json_decode(json_encode($order_success),true);
         foreach($array as $arr2){
            foreach($arr2 as $aid=>$order_suc){
                $order_suc;
		if( $order_suc == "")
                {
                $order_suc=0;
                }
            }
        }
        
        //failed count
       
        $order_cancelled    =  $wpdb->get_results( $wpdb->prepare(" SELECT COUNT(*) FROM  ".$wpdb->prefix."posts WHERE post_status = 'wc-on-hold' AND post_date > current_date - INTERVAL 45 day")); // db call ok; no-cache ok
        $array1 = json_decode(json_encode($order_cancelled),true);
         foreach($array1 as $arr2){
            foreach($arr2 as $aid=>$order_can){
                $order_can;
            }
        }
        $order_failed    =  $wpdb->get_results( $wpdb->prepare(" SELECT COUNT(*) FROM  ".$wpdb->prefix."posts WHERE post_status = 'wc-failed' AND post_date > current_date - INTERVAL 45 day")); // db call ok; no-cache ok
         $array2 = json_decode(json_encode($order_failed),true);
         foreach($array2 as $arr2){
            foreach($arr2 as $aid=>$order_fail){
                $order_fail;
            }
        }
        $total_failed=$order_can+$order_fail;
?>
        <div class="container">
            <h1><img src="https://whatsocdn.s3.us-west-2.amazonaws.com/images/whatsoLogoNew_black.png" class="imgclass"></h1>

            <h2 class="head-title">Abandoned Cart Recovery</h2>

            <div class="row">
                <p class="second-title">Whatso Abandoned Cart is the easiest way to recover all your Orders!</p>
            </div>
            <?php if ( class_exists( 'WooCommerce' ) ) {?>
            <div class="row">
                <p class="subtitle">A Summary of last <b style="color: #000000;">45 days</b> Orders</p>
            </div>
            <div class="row" style="margin-top: 10px;">
                <div class="col-4">
                    <div class="card">
                            <div class="row card-body">
                                <div class="col-7">
                                    <p class="card-text"><?php echo esc_html( $order_suc ); ?></p>
                                    <label class="lbl">Successfull Orders</label>
                                </div>
                                <div class="vl"></div>
                                <div class="col-5">
                                    <p class="card-text"><?php echo esc_html( $order_suc_amt ); ?></p>
                                    <label class="lbl lbl-extra">Amount</label>
                                </div>
                            </div> 
                    </div>
                </div>
            <div class="col-4">
                    <div class="card" style="width:106%;">
                            <div class="row card-body">
                                <div class="col-6">
                                    <p class="card-text1"><?php echo esc_html( $total_failed ); ?></p>
                                    <label class="lbl lbl-extra">Failed Orders</label>
                                </div>
                                <div class="vl"></div>
                                <div class="col-6">
                                    <p class="card-text1"><?php echo esc_html( $total_failed_amt ); ?></p>
                                    <label class="lbl">Amount to recover</label>
                                </div>
                            </div> 
                    </div>
                </div>
            </div>
            <div class="row">
                <div class="col-6">
                </div>
                <div class="col-6">
                    <img src="https://whatsocdn.s3.us-west-2.amazonaws.com/images/VectorArrow.png" class="imgRow">
                </div>
                </div>
                        
            <div class="row">
                <div class="col-8"></div>
                <div class="col-4">
                        <p class="row-content">
                            We can help you to<br/> recover this.
                        </p>
                </div>
            </div>
                    
            <div class="row">
                <div class="col-8"></div>
                <div class="col-4">
                    <a href="admin.php?page=whatso_ac_setup1" onclick="FormValidation()" class="btn btn-primary">Let's Get Started!</a>
                </div>
                </div>
                </form>
                <?php }else{?>
                <div class="rowCol">
                <div class="row">
                    <h1 class="alt-heading">WooCommerce is required<br> for our abandoned cart plugin!</h1>
                </div>
                <div class="row">
                    <a href="#" class="btn btn-secondary">Install Plugin</a>
                </div>
            </div>
                <?php }?>
        </div>