cedarwatersreviews.php

<?php

/*

Plugin Name: Cedar Waters Reviews

Description: A plugin designed to manage reviews for a site

Version: 1.4

Author: Cedar Waters

*/


$wp_rewrite = new WP_Rewrite();
global $wpdb;
 $sql = "CREATE TABLE IF NOT EXISTS wp_cedarwaters_reviews_schedule (

			    id mediumint(9) NOT NULL AUTO_INCREMENT,

              firstdays smallint(2),

			  firstbool smallint(2),

			  seconddays smallint(2),

			  secondbool smallint(2),

			  thirddays smallint(2), 

			  thirdbool smallint(2),

			  smsdays smallint(2), 

			  smsbool smallint(2),

			  emailone varchar(255),

			  emailtwo varchar(255),

			  emailthree varchar(255),

			  PRIMARY KEY( id )
			  ) ";


			require_once(ABSPATH . "wp-admin/includes/upgrade.php");


			dbDelta($sql);


		   $sql = "CREATE TABLE IF NOT EXISTS wp_cedarwaters_reviews_emails (

			  id mediumint(9) NOT NULL AUTO_INCREMENT,

			  email varchar(50),

			  firstname varchar(50),

			  lastname varchar(50),
 
              firstadded DATE,

			  status1 DATE DEFAULT '0000-00-00',			  

			  status2 DATE DEFAULT '0000-00-00',			  

			  status3 DATE DEFAULT '0000-00-00',			  

			  reply DATE DEFAULT '0000-00-00',
			  
			  lastsent DATE DEFAULT '0000-00-00',

			  PRIMARY KEY( id ),		  

			  UNIQUE (email)) ";


			require_once(ABSPATH . "wp-admin/includes/upgrade.php");


			dbDelta($sql);

        
		   $sql = "CREATE TABLE IF NOT EXISTS wp_reviews_network (


			  id mediumint(9) NOT NULL AUTO_INCREMENT,


			 network varchar(50),


			 url varchar(250),

			 
			  rnm varchar(250),


			  PRIMARY KEY( id )


			) ";


			require_once(ABSPATH . "wp-admin/includes/upgrade.php");


			dbDelta($sql);

			
		   $sql = "CREATE TABLE IF NOT EXISTS wp_cedarwaters_reviews_schedule(


			  id mediumint(9) NOT NULL AUTO_INCREMENT,

              firstdays smallint(2),

			  firstbool smallint(2),

			  seconddays smallint(2),

			  secondbool smallint(2),

			  thirddays smallint(2), 

			  thirdbool smallint(2),

			  smsdays smallint(2), 

			  smsbool smallint(2),

			  emailone LONGTEXT,

			  emailtwo LONGTEXT,

			  emailthree LONGTEXT,

			  PRIMARY KEY( id )


			) ";

					require_once(ABSPATH . "wp-admin/includes/upgrade.php");


			dbDelta($sql);

        	
function cwr_wait_utill_load ()
{
	

function cwr_styles_with_the_lot()

{

    // Register the style like this for a plugin:

    wp_register_style( 'review-style', plugins_url( 'reviews.css', __FILE__ ));

 
    // For either a plugin or a theme, you can then enqueue the style:

    wp_enqueue_style( 'review-style' );

}

add_action( 'wp_enqueue_scripts', 'cwr_styles_with_the_lot' );

// register post type for Reviews

function cwr_post_type_init() {


$labels = array(

'name' => _x('reviews', 'Reviews'),

'singular_name' => _x('review', 'Review'),

'add_new' => _x('Add New', 'custom-post'),

'add_new_item' => __('Add New Review'),

'edit_item' => __('Edit Review'),

'new_item' => __('New Review'),

'all_items' => __('All Reviews'),

'view_item' => __('View Review'),

'search_items' => __('Search Review'),

'not_found' =>  __('No Reviews found'),

'not_found_in_trash' => __('No Reviews found in Trash'),

'parent_item_colon' => '',

'menu_name' => __('Reviews')

);

$args = array(

'labels' => $labels,

'public' => true,

'publicly_queryable' => true,
'_edit_link' => 'post.php?post=%d',
'rewrite' => false,

'show_ui' => true,

'show_in_menu' => true,

'menu_icon' => 'dashicons-star-half',

'query_var' => true,

'rewrite' => array( 'slug' => _x( 'Review', 'URL slug' ) ),

'capability_type' => 'post',

'has_archive' => true,

'hierarchical' => false,

'menu_position' => null,

'supports' => array( 'title', 'editor', 'author', 'thumbnail', 'excerpt', 'comments','page-attributes','excerpt' )

);

register_post_type('reviews', $args);


}

function cwr_remove_menu_from_rs() {

  global $submenu;

  $post_type = 'reviews';

  $tax_slug = 'category';

  if (isset($submenu['edit.php?post_type='.$post_type])) {

    foreach ($submenu['edit.php?post_type='.$post_type] as $k => $sub) {

      if (false !== strpos($sub[2],$tax_slug)) {

        unset($submenu['edit.php?post_type='.$post_type][$k]);

      }

    }

  }

}

function cwr_taxonomies() {

    register_taxonomy(

        'reviews_stars',

        'reviews',

        array(

            'labels' => array(

                'name' => 'Reviews Stars',

                'add_new_item' => 'Add New Review Stars',

                'new_item_name' => "New Stars"

            ),

            'show_ui' => false,

            'show_tagcloud' => false,

            'hierarchical' => true

        )

    );


wp_set_object_terms( 0, 	 array(0.5,1.0,1.5,2.0,2.5,3.0,3.5,4.0,4.5,5.0), 'reviews_stars' );


}

add_action( 'init', 'cwr_taxonomies');


add_action( 'init', 'cwr_post_type_init' );

 
add_action('admin_menu','cwr_remove_menu_from_rs');

//the_terms( $post->ID, 'reviews_stars');

//generate form code to input reviews

function cwr_form_code() {

	
?>

<link rel="stylesheet" href="<?php bloginfo('reviews.css'); ?>" type="text/css" />

<div class="wpcf7">

<form id="new_post" name="new_post" method="post" action="" class="wpcf7-form" enctype="multipart/form-data">

    <!-- post name -->

    <fieldset name="name">

        <label for="title">Review Tittle:</label>

        <input type="text" id="title" value="" tabindex="5" name="title" />

	 	<fieldset class="rating" style = "float:right;">

    <input type="radio" id="star5" name="rating" value="5.0" /><label class = "full" for="star5" title="Awesome - 5 stars"></label>

    <input type="radio" id="star4half" name="rating" value="4.5" /><label class="half" for="star4half" title="Very Good - 4.5 stars"></label>

    <input type="radio" id="star4" name="rating" value="4.0" /><label class = "full" for="star4" title="Good - 4 stars"></label>

    <input type="radio" id="star3half" name="rating" value="3.5" /><label class="half" for="star3half" title="Fine - 3.5 stars"></label>

    <input type="radio" id="star3" name="rating" value="3.0" /><label class = "full" for="star3" title="Okay - 3 stars"></label>

    <input type="radio" id="star2half" name="rating" value="2.5" /><label class="half" for="star2half" title="Poor - 2.5 stars"></label>

    <input type="radio" id="star2" name="rating" value="20" /><label class = "full" for="star2" title="Kinda Bad - 2 stars"></label>

    <input type="radio" id="star1half" name="rating" value="1.5" /><label class="half" for="star1half" title="Bad - 1.5 stars"></label>

    <input type="radio" id="star1" name="rating" value="1.0" /><label class = "full" for="star1" title="Very bad - 1 star"></label>

    <input type="radio" id="starhalf" name="rating" value="0.5" /><label class="half" for="starhalf" title="Awful - 0.5 stars"></label>

</fieldset> 

    </fieldset>


    <!-- post Content -->

    <fieldset class="content">

        <label for="description"></label>

        <textarea id="description" tabindex="15" name="description" cols="30" rows="3"></textarea>

    </fieldset>


    <fieldset class="submit">

        <input type="submit" value="Post Review" tabindex="40" id="submit" name="submit" style="float: right; " />

    </fieldset>


    <input type="hidden" name="action" value="new_post" />

<?php wp_nonce_field( 'new-post' ); ?>

</form>

</div> <!-- END WPCF7 -->

<?php

if( 'POST' == $_SERVER['REQUEST_METHOD'] && !empty( $_POST['action'] ) &&  $_POST['action'] == "new_post") {

 $bool = false;

    // Do some minor form validation to make sure there is content

    if (isset ($_POST['title'])) {

        $title =  $_POST['title'];

    } else {

        echo 'Please enter the review name';

    }

    if (isset ($_POST['description'])) {

        $description = $_POST['description'];

    } else {

        echo 'Please enter some notes';

    }

	
//create author for post

	global $wpdb;


//do_action('wp_insert_post', 'wp_insert_post');

$table_name = 'wp_cedarwaters_reviews_emails';
$first_name = str_replace ('Thank You ','',get_the_title());
$last_name  = $wpdb->get_var("SELECT lastname FROM wp_cedarwaters_reviews_emails where firstname = '$first_name'");

$wpdb->update( 'wp_cedarwaters_reviews_emails', array( 'reply' => date("Y-m-d" )	), array('firstname' => $first_name, 'lastname' =>$last_name));
	  
	  
$user_id = username_exists( $first_name . ' ' . $last_name );


  //  $tags = $_POST['post_tags'];

	
    // ADD THE FORM INPUT TO $new_post ARRAY

    $new_post = array(

    'post_title'    =>   $title,

    'post_content'  =>   $description,


    'post_status'   =>   'publish',
	
	'post_author'   =>   $first_name . ' ' . $last_name,

    'post_type'     =>   'reviews' ,

    'tax_input' => array( 'reviews_stars' => $_POST['rating'] )

	);

    //SAVE THE POST

    $pid = wp_insert_post($new_post);

 
wp_set_object_terms($pid,array( $_POST['rating']),'reviews_stars');

    //SET UP TAGS

  //  wp_set_post_tags($pid, $_POST['post_tags']);

 
    //REDIRECT TO THE NEW POST ON SAVE
	$social_table_name = 'wp_reviews_network';

	$the_url = $wpdb->get_var("SELECT url FROM " . $social_table_name . " WHERE id = '1'", 0, 0);

	$the_network = $wpdb->get_var("SELECT network FROM " . $social_table_name . " WHERE id = '1'", 0, 0);
	
    $linkurl = get_home_url().'/wp-admin/post.php?post=cedarwaters#$%&action=edit';
	$linkurl = str_replace ( 'cedarwaters#$%' , $pid , $linkurl);
	
	
	$bool = true;
	  $email = $result->email;
	
	  
	  $subject = 'test';
$text = 'A review of ' . $_POST['rating']  . ' stars has been left by ' . $first_name . ' ' . $last_name . ". You can view it here " . $linkurl;
$adminn = get_option(my_admin_section);
foreach($adminn as $iterate)
{
	
if($iterate==1)
wp_mail( get_option( 'admin_email' ), 'A review has been left', $text); 
}	  

	
?>

<div id="dom-target" style="display: none;">

    <?php 

     
        echo htmlspecialchars($the_url); 

    ?>

</div>

<div id="tom-target" style="display: none;">

    <?php 

     
        echo htmlspecialchars($the_network); 

    ?>

</div>

<div id="home-target" style="display: none;">

    <?php 

     
        echo htmlspecialchars(home_url()); 

    ?>

</div>

<div id="rat-target" style="display: none;">

    <?php 

               
        echo htmlspecialchars($_POST['rating']); 

    ?>

</div>


<script type="text/javascript">;

var div = document.getElementById("dom-target");

var diz = document.getElementById("tom-target");

var home = document.getElementById("home-target");

var rate = document.getElementById("rat-target");

if(rate.textContent==5)

{
if(diz.textContent!='') 
{
var r = confirm("Thank you, we apreciate your feeback");	
}
else
{
var r = confirm("Thank you, would you like to review us on " + diz.textContent);		
}


}

else{ 

var r = confirm("Thank you for your feedback.");

    }

if(r==true&&rate.textContent==5)

window.location.replace(div.textContent);

else

{window.location.replace(home.textContent);}

</script>

<?php


 wp_delete_post( get_the_ID(),true);	 
}

}


function cwr_add_reviews()

{

$args = array('post_type'=> 'Reviews');

		//query_posts($args);

 
$paged = ( get_query_var('paged') ) ? get_query_var('paged') : 1;

query_posts( array( 'post_type' => 'reviews', 'posts_per_page' => 10, 'ignore_sticky_posts' => 1, 'paged' => $paged ) );


//pagination

if (have_posts()) :


	while (have_posts()) : the_post();

//echo the reviews	

$post = get_post();
$slug = $post->post_name;
$linkurl = get_home_url() . '/'.  $slug;
$taxonomy = strip_tags( get_the_term_list($post->ID, 'reviews_stars') );
$category = get_the_category(); 
//start of output
	
?>


    <h3><a href = "<?php echo $linkurl; ?>"> <?php echo the_title();?> </a>


    <?php switch($taxonomy)

	{

case '0.5':

	 ?>

	<img src="http://www.pixempire.com/images/preview/mini-half-star-icon.jpg" height="20" width="20">

<?php break;


case '1.0':

	 ?>

	<img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

<?php break;


case '1.5':

	 ?>

	<img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	<img src="http://www.pixempire.com/images/preview/mini-half-star-icon.jpg" height="20" width="20">

	
<?php break;


case '2.0':

	 ?>

	<img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	<img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

<?php break;


case '2.5':

	 ?>

	 <img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	 <img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	<img src="http://www.pixempire.com/images/preview/mini-half-star-icon.jpg" height="20" width="20">

<?php break;


case '3.0':

	 ?>

	 <img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	 <img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	 <img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	
<?php break;


case '3.5':

	 ?>

	 <img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	 <img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	 <img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	<img src="http://www.pixempire.com/images/preview/mini-half-star-icon.jpg" height="20" width="20">

<?php break; 


case '4.0':

	 ?>

	 <img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	 <img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	 <img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	 <img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	
<?php break; 


case '4.5':

	 ?>

	 <img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	 <img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	 <img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	 <img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	<img src="http://www.pixempire.com/images/preview/mini-half-star-icon.jpg" height="20" width="20">

<?php break; 


case '5.0':

	 ?>

	<img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	<img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	<img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	<img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

	<img src="https://pbs.twimg.com/profile_images/2173516694/BlackStar_400x400.PNG" height="20" width="20">

<?php break;	

	
	}	

	?>


</h3>

	<h5>

    <span style="font-weight:normal;"><i><?php echo the_content(); ?></i></span>

	</h5>

   <br>

<?php
//end out ouput
endwhile; 

?>

<div class="nav-next alignright"><?php previous_posts_link( 'Newer Reviews' ); ?></div>

<div class="nav-previous alignleft"><?php next_posts_link( 'Older Reviews' ); ?></div>


<?php

else : ?>

<p><?php _e('Sorry, no posts matched your criteria.'); ?></p>

<?php endif;


wp_reset_query();

}

add_action('pre_get_post','cwr_add_reviews');


// create custom plugin settings menu

//add_action('admin_menu', 'CSV_create_menu');


function cwr_CSV_create_menu() {


	//create new top-level menu

	//add_menu_page('Email Settings', 'Email Settings', 'administrator', __FILE__, 'Upload_CSV_page',$icon_url='dashicons-share');

	//add_options_page('My Options', 'My Plugin', 'manage_options', 'mt-top-level-handle', 'my_plugin_page');

     
	 add_menu_page('Email Settings', 'Email Settings', 'administrator', __FILE__, "Upload_CSV_page");

    //add_submenu_page(__FILE__, "Status", "Status", 'administrator', "my-submenu-slug", "status_page");


	//call register settings function

	//add_action( 'admin_init', 'cwr_register_mysettings' );

}

function cwr_create_default_page()
{
	
$unique_post = array(

  'post_title'    => 'Thank You',

  'post_type'     => 'page',

  'post_name'     => 'thankyou',

  'post_content'  => '[review_form]',

  'post_status'   => 'publish',

  'comment_status' => 'closed',

  'ping_status' => 'closed',

  'post_author' => 1,

  'menu_order' => 0

);
global $wpdb;
 $exist = $wpdb->get_var("SELECT ID FROM $wpdb->posts WHERE post_name='thankyou'");  

if($exist==null)
 wp_insert_post( $unique_post );
}add_action('init','cwr_create_default_page');

function or_mailtoall($datebool1, $datebool2, $datebool3, $jbo){

global $wpdb;
//echo $datebool2;
$emailone = $wpdb->get_var("SELECT emailone FROM wp_cedarwaters_reviews_schedule" , 0, 0);
														
$emailtwo = $wpdb->get_var("SELECT emailtwo FROM wp_cedarwaters_reviews_schedule" , 0, 0);

$emailthree = $wpdb->get_var("SELECT emailthree FROM wp_cedarwaters_reviews_schedule" , 0, 0);

$days1b = $wpdb->get_var("SELECT firstbool FROM wp_cedarwaters_reviews_schedule" , 0, 0);

$days2b = $wpdb->get_var("SELECT secondbool FROM wp_cedarwaters_reviews_schedule" , 0, 0);

$days3b = $wpdb->get_var("SELECT thirdbool FROM wp_cedarwaters_reviews_schedule" , 0, 0);

$rvn = $wpdb->get_var("SELECT rnm FROM wp_reviews_network" , 0, 0);

$table_name = 'wp_cedarwaters_reviews_emails';
$var = false;
$results = $wpdb->get_results("SELECT email FROM $table_name where reply == 0000-00-00");

$email= $jbo;
$first_name  = $wpdb->get_var("SELECT firstname FROM wp_cedarwaters_reviews_emails where email = '$email'");
$last_name  = $wpdb->get_var("SELECT lastname FROM wp_cedarwaters_reviews_emails where email = '$email'");
$reply  = $wpdb->get_var("SELECT reply FROM wp_cedarwaters_reviews_emails where email = '$email'");
//$datebool1 . ' ' . $datebool2 . ' ' . $datebool3 .  ' ' . $jbo . '<br>';
//$days1b . ' ' . $days2b . ' ' . $days3b . '<br>';
    $subject = 'Please Review Us';

    $social_table_name = 'wp_reviews_network';

    $linkurl = get_home_url().'/thank-you-'. str_replace ( '@' , '' , $first_name);

  
    $emailonec = str_replace ( '%name%' , $first_name , $emailone);

	$emailonec =  str_replace('%linkurl%' , $linkurl . ' ' , $emailonec);    

	$emailtwoc = str_replace ( '%name%' , $first_name , $emailtwo);

	$emailtwoc =str_replace('%linkurl%' , $linkurl . ' ', $emailtwoc);  

	$emailthreec =str_replace ( '%name%' , $first_name , $emailthree);

	$emailthreec =str_replace('%linkurl%' , $linkurl . ' ' , $emailthreec);   

 if(get_page_by_title('Thank You ' . $first_name)!=null)

 {   

$temp1 = $wpdb->get_var( "SELECT status1 FROM $table_name where email =  '$email'"); 
   if(($temp1=='0000-00-00'||$temp1== null)&&($days1b==1&&$datebool1==1)&&($reply=='0000-00-00'))
  { 
 
		
	$wpdb->update($table_name, array('status1' => date("Y-m-d" ) , 'lastsent' => date("Y-m-d" )), array( 'email' => $email  ));

    wp_mail( $email, $subject, $emailonec); 

  }

	   
 $temp2 = $wpdb->get_var( "SELECT status2 FROM $table_name where email =  '$email'"); 
  if(($temp2=='0000-00-00'||$temp2==null)&&($days2b==1&&$datebool2==1)&&($reply=='0000-00-00'))

  {
     
	  
	  $wpdb->update($table_name, array('status2' => date("Y-m-d" ) , 'lastsent' => date("Y-m-d" )), array( 'email' => $email  ));

	  wp_mail( $email, $subject, $emailtwoc);  	

  }


  $temp3 = $wpdb->get_var( "SELECT status3 FROM $table_name where email =  '$email'"); 
  if(($temp3=='0000-00-00'||$temp3==null)&&($days3b==1&&$datebool3==1)&&($reply=='0000-00-00'))

  {

	 $wpdb->update($table_name, array('status3' => date("Y-m-d" ), 'lastsent' => date("Y-m-d" )), array( 'email' => $email  ));  

	 wp_mail( $email, $subject, $emailthreec); 

  }

 }

 else  

 {  
 $unique_post = array(

  'post_title'    => 'Thank You ' . $first_name,

  'post_type'     => 'page',

  'post_name'     => 'Thank You ' . $first_name,

  'post_content'  => '[review_form]',

  'post_status'   => 'publish',

  'comment_status' => 'closed',

  'ping_status' => 'closed',

  'post_author' => first_name . ' ' . $last_name,

  'menu_order' => 0

);
$var = true;
}
   
if($var == true)
	if ($reply=='0000-00-00')
	{
	// wp_insert_post( $unique_post );	
	}


}

 
function cwr_status_page() 

{

	
global $wpdb;

$row = $wpdb->get_results ( "

    SELECT * 

    FROM  wp_cedarwaters_reviews_emails" );

	
	?>

	<table>

  <tr>	


    <th>Email &nbsp;&nbsp; </th>

    <th>Name  &nbsp;&nbsp;</th> 

    <!--<th>First  &nbsp;&nbsp;</th>

	<th>Seccond &nbsp;&nbsp; </th>

	<th>Third &nbsp;&nbsp; </th>

	<th>Reply  &nbsp;&nbsp;</th>

	<th>Last Sent  &nbsp;&nbsp;</th> -->

  </tr>

 
  <tr>


<?

	foreach($row as $rows)

	{

    ?><td><?echo $rows->email;?></td><?

	?><td><?echo $rows->firstname . ' ' . $rows->lastname;?></td><?

   ?><td><?//echo $rows->status1;?></td> <?

  ?><td><?//echo $rows->status2;?></td><?

	?><td><?//echo $rows->status3;?></td><?

    ?><td><?//echo $rows->reply;?></td> <?

    ?><td><?//echo $rows->lastsent;?></td></tr><?

    
	}

	?>

	</table>

<?

}


function cwr_schedule_emails () 

{
global $wpdb;
global $datebool1, $datebool2, $datebool3;	
$datebool1 = 0;
$datebool2 = 0;
$datebool3 = 0;
$shell = '0000-00-00';
$emailobj = $wpdb->get_col("SELECT email FROM wp_cedarwaters_reviews_emails");
$days1 = $wpdb->get_var("SELECT firstdays FROM wp_cedarwaters_reviews_schedule" , 0, 0);
$days1b = $wpdb->get_var("SELECT firstbool FROM wp_cedarwaters_reviews_schedule" , 0, 0);
$days2 = $wpdb->get_var("SELECT seconddays FROM wp_cedarwaters_reviews_schedule" , 0, 0);
$days2b = $wpdb->get_var("SELECT secondbool FROM wp_cedarwaters_reviews_schedule" , 0, 0);
$days3 = $wpdb->get_var("SELECT thirddays FROM wp_cedarwaters_reviews_schedule" , 0, 0);
$days3b = $wpdb->get_var("SELECT thirdbool FROM wp_cedarwaters_reviews_schedule" , 0, 0);
$emailone = $wpdb->get_var("SELECT emailone FROM wp_cedarwaters_reviews_schedule" , 0, 0);
$emailtwo = $wpdb->get_var("SELECT emailtwo FROM wp_cedarwaters_reviews_schedule" , 0, 0);
$emailthree = $wpdb->get_var("SELECT emailthree FROM wp_cedarwaters_reviews_schedule" , 0, 0);
$k = 0;
$ty;
$tm;
$td;
$day1date;
$day2date;
$day3date;
$newdate1 =0;
$newdate2 =0;
$newdate3 = 0;
$temp;

foreach($emailobj as $jbo)
{
$emaillastsent = $wpdb->get_var("SELECT lastsent FROM wp_cedarwaters_reviews_emails where email = '$jbo'" , 0, 0);
$emailfirstadded = $wpdb->get_var("SELECT firstadded FROM wp_cedarwaters_reviews_emails where email = '$jbo'" , 0, 0);

if($emaillastsent==null||$emaillastsent==$shell)
{
$dateiq = $emailfirstadded;
}
else
{
$dateiq = $emaillastsent;	
}
$date1 = date_create($dateiq);
date_add($date1,date_interval_create_from_date_string("$days1 days"));
date_format($date1,"Y-m-d") . '<br>';

$date2 = date_create($dateiq);
date_add($date2,date_interval_create_from_date_string("$days2 days"));
date_format($date2,"Y-m-d") . '<br>';

$date3 = date_create($dateiq);
date_add($date3,date_interval_create_from_date_string("$days3 days"));
date_format($date3,"Y-m-d") . '<br>';


if(date ("Y-m-d")>=date_format($date1,"Y-m-d"))
$datebool1 = 1;

if(date ("Y-m-d")>=date_format($date2,"Y-m-d"))
$datebool2 = 1;

if(date ("Y-m-d")>=date_format($date3,"Y-m-d"))
$datebool3 = 1;

	or_mailtoall($datebool1, $datebool2, $datebool3, $jbo);
}

}

function cwr_fm_shortcode() {form_code();}

function cwr_pst_shortcode() {add_reviews();}

add_shortcode( 'review_form', 'cwr_fm_shortcode' );

add_shortcode( 'review_post', 'cwr_pst_shortcode' );

require_once( 'wm-settings.php' );

get_option( 'my_option_name');

$my_page = create_settings_page(


  'my_page_id',

  __( 'My Page' ),

  array(

    'title' => __( 'My Menu' )

  ),

  array(

    'my_setting_id' => array(

      'title'       => __( 'My Setting' ),

      'description' => __( 'This is my section description.' ),

      'fields'      => array(

        'my_option_name' => array(

          'label'        => __( 'My Option' ),

          'description'  => __( 'This is my field description.' )

        )

      )

    )

  )

);

// Access the values

$my_value = get_setting( 'my_setting_id', 'my_option_name' );

$my_top_page = create_settings_page(

  'reviews_settings',

  __( 'Settings' ),

  array(

    'parent'   => 'edit.php?post_type=reviews',

    'title'    => __( 'Reviews Settings' ),

    'icon_url' => 'dashicons-admin-generic',

    'position' => '63.3'

  ),

  array(

    'my_standard_section' => array(

      'title'  => __( 'Add or Remove Emails' ),

      'description' => __( 'Add emails here to send request for reviews.' ),

      'fields' => array(

       /* 'my_input'    => array(

          'label' => __( 'Add Email' ),

		  'sanitise' => true

        ),*/

        'my_checkbox' => array(

          'type'  => 'file',

          'label' => '',

		  'description' =>  'How create a csv file <a> http://www.computerhope.com/issues/ch001356.htm </a>' 

        ),
			'stm_action' => array(

        'type'        => 'action',

        'label'       => __( 'Delete' ),

        'description' => __( 'Delete all known emails'),

        'action'      => 'erase_all_emails'

      )
		

      )
    )

  ),
  

  array(

    'tabs'        => true,

    'submit'      => __( 'Save' ),

    'reset'       => __( 'Reset' ),

    'description' => __( 'Customize Your Review Settings' ),

    'updated'     => __( 'success message !')

  )

);

// And a sub-page
/*
$my_sub_page = create_settings_page(

  'my_sub_page',

  __( 'Status Page' ),

  array(

    'parent' => 'edit.php?post_type=reviews',

    'title'  => __( 'Status' )

  )

);*/
//add_submenu_page( 'edit.php?post_type=reviews', 'Status', 'Status', '7', 'status', 'status_page' );
$my_top_page->apply_settings( array(

  'my_formatted_section' => array(

    'title'  => __( 'Social Networks' ),
	      'description'       => __( 'Five star reviews will be sent to the social network or page of your choice.' ),
   
    'fields' => array(

      'my_select' => array(

        'type'    => 'select',

        'label'   => __( 'Network' ),
		'description' => __( 'If you choose other please put your homepage in the box below'),

        'options' => array(

          '1'   => __( 'Google+'),

          '2'   => __( 'Yelp'),

          '3' => __( 'Facebook'),

		  '4' => __( 'Other')

        )

      ),

      'my_url'    => array(

        'type'  => 'url',

        'label' => __( 'URL' )

      )
	  /*,

      'my_number' => array(

        'type'  => 'number',

        'label' => __( 'Refer Minimum Stars' )

      )*/
    )

  ),
   'my_admin_section' => array(

    'title'  => __( 'Manual Email' ),
	'description'       => __( 'Send an email to a single adress.' ),

    'fields' => array(

      /*'my_select' => array(

        'type'    => 'checkbox',

        'label'   => __( 'Admin Notification Enabled' ),

       
      ),*/
	  
		'my_email'    => array(

        'type'  => 'email',

        'label' => __( 'Send email to' )

      ),
	  	'stm_action' => array(

        'type'        => 'action',

        'label'       => __( 'Send Email' ),

        'description' => __( ''),

        'action'      => 'send_test_email'

      )

    )

  ),

  'my_multi_section'    => array(

    'title'  => __( 'Customize Email' ),
	'description'       => __( 'Customize Your Email For Manual And All Emailing.' ),

    'fields' => array(

     
     /* 'my_multi'  => array(

        'type'    => 'multi',

        'label'   => __( 'Schedule' ),

        'options' => array(

         // 'one'   => __( 'First Email'),

          //'two'   => __( 'Second Email'),

         // 'three' => __( 'Third Email')

        )

      ),

	  'my_number1' => array(

        'type'  => 'number',

        'label' => __( 'Days to wait to email' )

		
      ),

	  'my_number2' => array(

        'type'  => 'number',

        'label' => __( 'Days to wait for 2nd email' )

      ),

	  'my_number3' => array(

        'type'  => 'number',

        'label' => __( 'Days to wait for 3rd email' )

      ),*/

	  'my_textarea1' => array(

          'type'  => 'textarea',

          'label' => __( 'Email Body' ),

		  'description' => 'Supported tags %name% %linkurl%'

        )/*,

		'my_textarea2' => array(

          'type'  => 'textarea',

          'label' => __( 'Seccond Email' ),

		  'description' => 'Supported tags %name% %linkurl% '

        ),

		'my_textarea3' => array(

          'type'  => 'textarea',

          'label' => __( 'Third Email' ),

		  'description' => 'Supported tags %name% %linkurl% '

        )*/,

	  	'stm_action' => array(

        'type'        => 'action',

        'label'       => __( 'Send All' ),

        'description' => __( ''),

        'action'      => 'mass_send'

      )
		

    )

  )

) );

$my_sub_page;

function cwr_do_my_action() {

	$text = status_page();

	str_replace(' ', '', $text);

	//echo 'test';

  // If error

  wp_send_json_error( __( 'Error !' ) );

  // If success

  wp_send_json_success( __( 'Success !' ) );

  // If the page needs to reload

  wp_send_json_success( array(

    'reload'  => true,

    'message' => __( 'This message is only displayed if "reload" => false.' )

  ) );

}
function cwr_erase_all_emails()
{
	?>
	<script>confirm("All emails have been deleted.");</script><?
global $wpdb;
$delete = $wpdb->query("TRUNCATE TABLE `wp_cedarwaters_reviews_emails`");
}
function cwr_send_test_email ()

{ 

global $wpdb; 

$option = get_option( 'my_admin_section');
foreach($option as $iterate)
{
	if(  strpos($iterate, '@') !== FALSE)
	{
		$emailsender = $iterate;
	}
}
 //$find = $wpdb->get_var("SELECT option_value FROM wp_options WHERE option_name = my_admin_section");  
$linkurl = get_home_url().'/thankyou';
//$emailsender = $wpdb->get_var("SELECT email FROM wp_cedarwaters_reviews_emails where id = 1" , 0, 0);

$emailone = $wpdb->get_var("SELECT emailone FROM wp_cedarwaters_reviews_schedule" , 0, 0);

//$emailonec = str_replace ( '%name%' , $emailsender , $emailone);
$linkurl = get_home_url().'/thankyou';
$emailone =  str_replace('%linkurl%' , $linkurl . ' ' , $emailone);   


$subject = 'Please review us';

wp_mail( $emailsender, $subject, $emailone ); 
echo 'Sent Successfully';  

}
 
function cwr_mass_send ()
{
	global $wpdb; 

	$emails = $wpdb->get_col("SELECT email FROM wp_cedarwaters_reviews_emails where true=true");
	$linkurl = get_home_url().'/thankyou';
	$emailone = $wpdb->get_var("SELECT emailone FROM wp_cedarwaters_reviews_schedule" , 0, 0);
	$subject = 'Please review us';
	$emailone =  str_replace('%linkurl%' , $linkurl . ' ' , $emailone);   
	echo 'sent';
	foreach ($emails as $email)
	{
		
	wp_mail( $email, $subject, $emailone ); 	
	echo 'Sent to ' + $email + ' ';  
	}
	
}	

function cwr_do_my_sanitation( $input, $name ) {

  return sanitize_text_field( strtoupper( $input ) );

}

do_action('do_my_page_callback' );

function cwr_do_my_page_callback() {

  // All settings of my_top_level_page have been updated.

    //email page option

    $email_fruit = get_option('my_standard_section');

	$email_fruit=implode($email_fruit,"");


        // valid address

		//print_r($email_fruit);

		str_replace ( ',' , '', $email_fruit);
		global $wpdb;
$the_email = $wpdb->get_var("SELECT email FROM " . 'wp_cedarwaters_reviews_emails' . " WHERE email = '$email_fruit'", 0, 0);
		

		    $arguments = array(

				'email' => $email_fruit ,
								

				'status1' => '0000-00-00',

			    'status2' => '0000-00-00',

			    'status3'  => '0000-00-00',

			    'reply'  => '0000-00-00',

			    'lastsent'  => '0000-00-00');
				
if($the_email!=$email_fruit)
	$wpdb->insert( 'wp_cedarwaters_reviews_emails', $arguments);

    
	//social page option

	$net_fruit = get_option('my_formatted_section');

	$net_fruit=implode($net_fruit," ");

	$swi = substr($net_fruit, 0, 1);

	//print_r($net_fruit);

	//$swi = substr($net_fruit, 0, 1);

    $tok = strtok($net_fruit, ' ');

	$count = 1;
$rnm = 0;
	while ($tok !== false) {

		if ($count==1)

			$network =$tok;

		if ($count==2)

			$url =$tok;

		if ($count==3)

			$rnm =$tok;

  
    $tok = strtok(' ');

	$count++;

}

switch($network)

{

	case 1 :

	$network = 'Google+';

	break;

	
	case 2 :

	$network = 'Yelp';

	break;

	
	case 3 :

	$network = 'Facebook';

	break;

	
	case 4 :

	$network = '';

	break;

}

$et;

$e3 = 0;
$get = 0;
global $wpdb;

		    $args = array(

			 'id' => 1,

			 'network' => $network, 

		     'url' => $url,

		     'rnm' => $rnm);

			$wpdb->replace( 'wp_reviews_network', $args);

			
//seems to work fine until this point


	$sch_fruit = get_option('my_multi_section');

	$sch_fruit=implode($sch_fruit,"|/\|");
$superfruit = $sch_fruit;
	//echo $sch_fruit;
$s=0;
$t=0;
$e2=0;

	    $tok = strtok($sch_fruit, '|/\|');
$count = 1;
if($tok[0]!='{')
	{
	$count++;	
	}
	

	while ($tok !== false) {
		//echo $tok . '<br>';

	
		if ($count==1)

			 $get =$tok;

		if ($count==2)

			$f =$tok;

		if ($count==3)

			$s =$tok;

		if ($count==4)

			$t =$tok;

        if ($count==5)

			 $e1 =$tok;

		if ($count==6)

			$e2 =$tok;

		if ($count==7)

			$e3 =$tok;

		if ($count==7)

			$et =$tok;

    $tok = strtok('|/\|');

	
	$count++;

} 

//echo $et;

//echo $get;


$pos1 = strpos($get, "one\":");

$pos2 = strpos($get, "two\":" );

$pos3 = strpos($get, "three\":" );

$whatIWant1 = substr($get, $pos1+5 ,1); 

$whatIWant2 = substr($get, $pos2+5 ,1);

$whatIWant3 = substr($get, $pos3+7 ,1); 

		   
//main issue here 
			$wpdb->replace( 'wp_cedarwaters_reviews_schedule',  $arg = array(

			'id' => 1,

			'firstdays' => $f, 

		    'firstbool' => $whatIWant1,

			'seconddays' => $s, 

		    'secondbool' => $whatIWant2,

			'thirddays' => $t, 

		    'thirdbool' => $whatIWant3, 

		    'smsdays' => 0,

		    'smsbool' => 0,

			'emailone' => $superfruit,

			'emailtwo' => $e2,

			'emailthree' => $e3));


//$wpdb->update('wp_cedarwaters_reviews_emails', 'email' => $email, where"" id = 1  );

//schedule_emails ();

}

add_action( 'update_option_custom_fields_section', 'cwr_do_my_section_callback' );

function cwr_do_my_section_callback() {

  $my_custom_options = get_setting( 'my_custom_section' );


  // All options of custom_fields_section have been updated.

}
cwr_do_my_page_callback(); 
$my_page->add_notice( __( 'My info message.') );

$my_page->add_notice( __( 'Your Settings have Been Saved'), 'updated' );

$my_page->add_notice( __( 'Error, please check input!'), 'warning' );

$my_page->add_notice( __( 'Fatal Error'), 'error' );

//schedule_emails (); 


//add_action( 'wp', 'cwr__setup_schedule_email' );
/**
 * On an early action hook, check if the hook is scheduled - if not, schedule it.
 */
function cwr__setup_schedule_email() {
	if ( ! wp_next_scheduled( 'cedarwatersreviews_daily_email' ) ) {
		wp_schedule_event( time(), 'daily', 'cedarwatersreviews_daily_email');
	}
}


add_action( 'cedarwatersreviews_daily_email', 'cwr__daily_email_generate' );
/**
 * On the scheduled action hook, run a function.
 */
function cwr__daily_email_generate() {
	// do something everyday
	schedule_emails (); 
}

function or_upload_csv ()
{
	?>
  <div class="wrap">

<?php

if ( isset( $_POST['ocb_member_data'] ) && wp_verify_nonce( $_POST['ocb_member_data'], 'import_member_data' ) && isset($_POST['insert_members']) ) {
	global $wpdb;	
	$uploadsroot = wp_upload_dir();				
	if(!is_dir($uploadsroot["basedir"]."/ocb")) mkdir($uploadsroot["basedir"]."/ocb", 0775);
	$filename_data_items = time().'_'.$_FILES['data_membercsv_file']['name'];	
	$upload_csv_name	= $uploadsroot["basedir"]."/ocb/".$filename_data_items;
	$upload_csv_url_name	= $uploadsroot["baseurl"]."/ocb/".$filename_data_items;	
	
	if(move_uploaded_file($_FILES['data_membercsv_file']['tmp_name'], $upload_csv_name)){		
		$csvfile = fopen($upload_csv_name, 'r');
		$theData = fgets($csvfile);
		$i = 0;
		while (!feof($csvfile)) {
			$csv_data[] = fgets($csvfile, 1024);
			$csv_array = explode(",", $csv_data[$i]);
			
			$insert_csv = array();
			$first_name = ''; $last_name = ''; $email_address = '';
			
			$first_name = $csv_array[0];
			$last_name = $csv_array[1];
			$email_address = $csv_array[2];
			
			$date = current_time(Y-m-d);
	

	 $wpdb->insert('wp_cedarwaters_reviews_emails', 
	 array('email' => $email_address, 
	 'firstadded' => $date,
	 'firstname' => $first_name, 
	 'lastname' => $last_name 
	));  			
			$i++;
		}
		fclose($csvfile);		
		
		echo "<div id='message' class=\"updated\"><p>Successfully Added!</p></div>";
		
	}else{ //eof move upload file
		echo "<div class='error'><p>Failed!</p></div>";
	}
	
}
?>


<h2>Import</h2>

<h3>Import Emails</h3>
<form   method="post" enctype="multipart/form-data">
<p>Select csv file: <input type="file" name="data_membercsv_file" /></p>
<p> <a href = "http://www.computerhope.com/issues/ch001356.htm"> How create a csv file </a></p>
<p><input action = 'edit.php?page=2145-2/' type="submit" name="insert_members" value="Upload CSV" /></p>
<?php wp_nonce_field('import_member_data','ocb_member_data'); ?>
</form>
<br><br><br>
<h2>Email List<h2>
<?
global $wpdb;
$row = $wpdb->get_results ( "

    SELECT * 

    FROM  wp_cedarwaters_reviews_emails" );

	
	?>

	<table>

  <tr>	


    <th>Email &nbsp;&nbsp; </th>

    <th>Name  &nbsp;&nbsp;</th> 

    <!--<th>First  &nbsp;&nbsp;</th>

	<th>Seccond &nbsp;&nbsp; </th>

	<th>Third &nbsp;&nbsp; </th>

	<th>Reply  &nbsp;&nbsp;</th>

	<th>Last Sent  &nbsp;&nbsp;</th> -->

  </tr>

 
  <tr>


<?

	foreach($row as $rows)

	{

    ?><td><?echo $rows->email;?></td><?

	?><td><?echo $rows->firstname . ' ' . $rows->lastname;?></td><?

   ?><td><?//echo $rows->status1;?></td> <?

  ?><td><?//echo $rows->status2;?></td><?

	?><td><?//echo $rows->status3;?></td><?

    ?><td><?//echo $rows->reply;?></td> <?

    ?><td><?//echo $rows->lastsent;?></td></tr><?

    
	}

	?>

	</table>
	<br>
	<br>
	<br>
<h2>Remove</h2>
</div>
<?	
}
}
add_action( 'plugins_loaded', 'cwr_wait_utill_load', 10 );