<?php
/*
 * Plugin Name: Jquery Contact Us
 * Description: This is contact us form with jquery Validation & Bootstrap 3.0
 * Author: Kalpit Pandit
 * Author URI: www.google.com
 * Version: 1.0
 */
?>
<?php
global $page_id;
register_activation_hook(__FILE__,'createTable');
register_deactivation_hook(__FILE__, 'dropTable');
add_filter('template_include', 'add_template');
add_action('admin_menu','createMenu');

function createTable()
{
    global $wpdb;
    if($wpdb->query("Show tables like 'kp_contact'") > 0) {
//        createPage();
        do_action('create_Page');
    }
    else
    {
       $qa="create table kp_contact (cid int AUTO_INCREMENT PRIMARY KEY, name varchar(50), email varchar(50), contact varchar(15), type varchar(10), message longtext)";
       $q="create table kp_contact_config (cid int AUTO_INCREMENT PRIMARY KEY, Message Longtext,email varchar(30),pagetitle varchar(30))";

       $wpdb->query($qa);
       $wpdb->query($q);
       $wpdb->insert("kp_contact_config",array('message'=>'Thanks for contacting with us. Will reach you soon','email'=>  get_option('admin_email'),'pagetitle'=>'Contact Us'),array('%s','%s','%s'));
//        createPage();
        do_action('create_Page');
    }
}
add_action('create_Page','createPage',10);
function createMenu()
{
    add_menu_page('Configuration Contact Page', 'Conatct US Setting', 'manage_options', __FILE__, 'welcome');
}

function welcome()
{    global $wpdb;
    ?>

    <form method="POST" action="<?php echo plugins_url().'/kp_contactus/kp_contact_config.php'?>" id="ok">
        <table>
            <tr><td colspan="2"> <h3> Welcome to Setting </h3></td></tr>
            <tr><td><label>Thanks Message</label></td>
                <?php $message=$wpdb->get_var("select message from kp_contact_config order by cid desc limit 1");
                $email=$wpdb->get_var("select email from kp_contact_config order by cid desc limit 1");
                $ptitle=$wpdb->get_var("select pagetitle from kp_contact_config order by cid desc limit 1"); ?>
                <td><input type="text" name="message" class="form-control" required="" value="<?php echo $message; ?>"/></td></tr>
             <tr><td><label>Receiver Email</label></td>
                <td><input type="email" name="email" class="form-control" required="" value="<?php echo $email; ?>"/></td></tr>
             <tr><td><label>Page Title</label></td>
                <td><input type="text" name="ptitle" class="form-control" required="" value="<?php echo $ptitle; ?>"/></td></tr>
             <input type="hidden"
            <tr> <td><?php submit_button(); ?></td></tr>
        </table>
    </form>
<?php }

function dropTable()
{
    global $wpdb;
    if( get_option('the_page_id_i_created') )
    {
      wp_delete_post(get_option('the_page_id_i_created'),$force_delete=TRUE);
    }
    $pageid=  get_option('the_page_id_i_created');
    $wpdb->query("drop table kp_contact");
    $wpdb->query("drop table kp_contact_config");
    $wpdb->delete("wp_posts",array('post_name'=>$pageid+1,'post_type'=>'nav_menu_item'),array('%d','%s'));
}

function createPage()
{
    global $user_ID;
    global $page_id;
    $page['post_type']    = 'page';
    $page['post_content'] = 'Template did not attached. Please try to install/Uninstall it.';
    $page['post_status']  = 'publish';
    $page['post_title']   = 'Contact Us';

    $page_id = wp_insert_post ($page);
    update_option('the_page_id_i_created', $page_id );
}

function add_template( $template )
{
    if( is_page( 'contact-us' ) )
        $template = dirname( __FILE__ ) . '/kp_contact_form.php';
    return $template;
}
?>