<?php
                                if ( isset($_POST['epostadegistir']) ){
                                    $eposta = strip_tags($_POST['eposta']);
                                    
                                    $guncelle = $conn->query("UPDATE uye SET eposta = '{$eposta}' WHERE id = '{$id}'")->fetch(PDO::FETCH_ASSOC);
                                    if ($guncelle) {                                        
                                        echo "Bilgiler güncellendi.";
                                    }else{
                                        echo "Bir hata oluştu..";
                                    }
                                }
                            ?>
                            <form action="" method="POST" style="padding:10px 0;text-align:center;">
                                <div style="display:flex;padding:5px 20px;margin:5px 3px;">
                                    <div>
                                        <svg xmlns="http://www.w3.org/2000/svg" width="30" height="30" style="position:relative;left:25px;top:2px;" fill="currentColor" viewBox="0 0 16 16">
                                        <path d="M13.106 7.222c0-2.967-2.249-5.032-5.482-5.032-3.35 0-5.646 2.318-5.646 5.702 0 3.493 2.235 5.708 5.762 5.708.862 0 1.689-.123 2.304-.335v-.862c-.43.199-1.354.328-2.29.328-2.926 0-4.813-1.88-4.813-4.798 0-2.844 1.921-4.881 4.594-4.881 2.735 0 4.608 1.688 4.608 4.156 0 1.682-.554 2.769-1.416 2.769-.492 0-.772-.28-.772-.76V5.206H8.923v.834h-.11c-.266-.595-.881-.964-1.6-.964-1.4 0-2.378 1.162-2.378 2.823 0 1.737.957 2.906 2.379 2.906.8 0 1.415-.39 1.709-1.087h.11c.081.67.703 1.148 1.503 1.148 1.572 0 2.57-1.415 2.57-3.643zm-7.177.704c0-1.197.54-1.907 1.456-1.907.93 0 1.524.738 1.524 1.907S8.308 9.84 7.371 9.84c-.895 0-1.442-.725-1.442-1.914z"/>
                                        </svg>
                                    </div>
                                    <input type="text" value="<?=$eposta?>" name="eposta" style="padding:5px 50px;background-color:transparent;border:none;border-bottom:1px solid black;border-radius:0;width:100%;position:relative;left:-10px;" maxlength="25" required />
                                </div>
                                <input type="submit" value="Kaydet" name="epostadegistir" style="width:60%;padding:11px 0;background-color:#6b1c5e;color:#fff;margin-top:20px;border:none;border-radius:25px;" />
                            </form>

<?php
if(isset($_POST['form1'])) {
    $valid = 1;

    if(empty($_POST['page_name'])) {
        $valid = 0;
        $error_message .= "Page Name can not be empty<br>";
    } else {
        // Duplicate Page checking
        $statement = $pdo->prepare("SELECT * FROM tbl_page WHERE page_name=?");
        $statement->execute(array($_POST['page_name']));
        $total = $statement->rowCount();
        if($total) {
            $valid = 0;
            $error_message .= "Page Name already exists<br>";
        }
    }

    $path = $_FILES['banner']['name'];
    $path_tmp = $_FILES['banner']['tmp_name'];

    if($path!='') {
        $ext = pathinfo( $path, PATHINFO_EXTENSION );
        $file_name = basename( $path, '.' . $ext );
        if( $ext!='jpg' && $ext!='png' && $ext!='jpeg' && $ext!='gif' ) {
            $valid = 0;
            $error_message .= 'You must have to upload jpg, jpeg, gif or png file for banner<br>';
        }
    } else {
        $valid = 0;
        $error_message .= 'You must have to select a photo for banner<br>';
    }

    if($valid == 1) {

        // getting auto increment id
        $statement = $pdo->prepare("SHOW TABLE STATUS LIKE 'tbl_page'");
        $statement->execute();
        $result = $statement->fetchAll();
        foreach($result as $row) {
            $ai_id=$row[10];
        }

        if($_POST['page_slug'] == '') {
            // generate slug
            $temp_string = strtolower($_POST['page_name']);
            $page_slug = preg_replace('/[^A-Za-z0-9-]+/', '-', $temp_string);
        } else {
            $temp_string = strtolower($_POST['page_slug']);
            $page_slug = preg_replace('/[^A-Za-z0-9-]+/', '-', $temp_string);
        }

        // if slug already exists, then rename it
        $statement = $pdo->prepare("SELECT * FROM tbl_page WHERE page_slug=?");
        $statement->execute(array($page_slug));
        $total = $statement->rowCount();
        if($total) {
            $page_slug = $page_slug.'-1';
        }

        $final_name = 'page-banner-'.$ai_id.'.'.$ext;
        move_uploaded_file( $path_tmp, '../assets/uploads/'.$final_name );
        
        // saving into the database
        $statement = $pdo->prepare("INSERT INTO tbl_page (page_name,page_slug,page_content,page_layout,banner,status,meta_title,meta_keyword,meta_description) VALUES (?,?,?,?,?,?,?,?,?)");
        $statement->execute(array($_POST['page_name'],$page_slug,$_POST['page_content'],$_POST['page_layout'],$final_name,$_POST['status'],$_POST['meta_title'],$_POST['meta_keyword'],$_POST['meta_description']));

        $success_message = 'Page is added successfully.';
    }
}
?>

<section class="content-header">
    <div class="content-header-left">
        <h1>Add Page</h1>
    </div>
    <div class="content-header-right">
        <a href="page.php" class="btn btn-primary btn-sm">View All</a>
    </div>
</section>


<section class="content">

    <div class="row">
        <div class="col-md-12">

            <?php if($error_message): ?>
            <div class="callout callout-danger">
            
            <p>
            <?php echo $error_message; ?>
            </p>
            </div>
            <?php endif; ?>

            <?php if($success_message): ?>
            <div class="callout callout-success">
            
            <p><?php echo $success_message; ?></p>
            </div>
            <?php endif; ?>

            <form class="form-horizontal" action="" method="post" enctype="multipart/form-data">

                <div class="box box-info">
                    <div class="box-body">
                        <div class="form-group">
                            <label for="" class="col-sm-2 control-label">Page Name <span>*</span></label>
                            <div class="col-sm-4">
                                <input type="text" class="form-control" name="page_name" placeholder="Example: About Us">
                            </div>
                        </div>
                        <div class="form-group">
                            <label for="" class="col-sm-2 control-label">Page Slug </label>
                            <div class="col-sm-4">
                                <input type="text" class="form-control" name="page_slug" placeholder="Example: about-us">
                            </div>
                        </div>
                        <div class="form-group">
                            <label for="" class="col-sm-2 control-label">Page Layout </label>
                            <div class="col-sm-2">
                                <select class="form-control select2" name="page_layout" style="width:300px;" onchange="showContentInputArea(this)">
                                    <option value="Full Width Page Layout">Full Width Page Layout</option>
                                    <option value="Urunler Sayfasi">Urunler Sayfasi</option>
                                    <option value="ic Sayfa">ic sayfa</option>
                                    <option value="FAQ Page Layout">FAQ Page Layout</option>
                                    <option value="Team Member Page Layout">Team Member Page Layout</option>
                                    <option value="Photo Gallery Page Layout">Photo Gallery Page Layout</option>
                                    <option value="Video Gallery Page Layout">Video Gallery Page Layout</option>
                                    <option value="Blog Page Layout">Blog Page Layout</option>
                                    <option value="Contact Us Page Layout">Contact Us Page Layout</option>
                                </select>
                            </div>
                        </div>
                        
                        <div class="form-group" id="showPageContent">
                            <label for="" class="col-sm-2 control-label">Page Content </label>
                            <div class="col-sm-9">
                                <textarea class="form-control editor" name="page_content"></textarea>
                            </div>
                        </div>    
                        <div class="form-group">
                            <label for="" class="col-sm-2 control-label">Banner <span>*</span></label>
                            <div class="col-sm-9" style="padding-top:5px">
                                <input type="file" name="banner">(Only jpg, jpeg, gif and png are allowed)
                            </div>
                        </div>                    
                        <div class="form-group">
                            <label for="" class="col-sm-2 control-label">Active? </label>
                            <div class="col-sm-6">
                                <label class="radio-inline">
                                    <input type="radio" name="status" value="Active" checked>Yes
                                </label>
                                <label class="radio-inline">
                                    <input type="radio" name="status" value="Inactive">No
                                </label>
                            </div>
                        </div>
                        <h3 class="seo-info">SEO Information</h3>
                        <div class="form-group">
                            <label for="" class="col-sm-2 control-label">Meta Title </label>
                            <div class="col-sm-9">
                                <input type="text" class="form-control" name="meta_title">
                            </div>
                        </div>
                        <div class="form-group">
                            <label for="" class="col-sm-2 control-label">Meta Keywords </label>
                            <div class="col-sm-9">
                                <textarea class="form-control" name="meta_keyword" style="height:100px;"></textarea>
                            </div>
                        </div>
                        <div class="form-group">
                            <label for="" class="col-sm-2 control-label">Meta Description </label>
                            <div class="col-sm-9">
                                <textarea class="form-control" name="meta_description" style="height:100px;"></textarea>
                            </div>
                        </div>
                        <div class="form-group">
                            <label for="" class="col-sm-2 control-label"></label>
                            <div class="col-sm-6">
                                <button type="submit" class="btn btn-success pull-left" name="form1">Submit</button>
                            </div>
                        </div>
                    </div>
                </div>

            </form>


        </div>
    </div>

</section>

<?php require_once('footer.php'); ?>