<?php
include("core/init.php");
include("session.php");

/***********Table Used**********/
$mainTable="schedule_cms";

/****************Category Add & Edit Process Starts Here**********************/

if(Input::exists() && Token::check(Input::getInput("token"))) {

    if(Input::getInput("cmsId")=="")
    {
        Db::getInstance()->insert($mainTable,array("location"=>addslashes(Input::getInput("province_id")),
            "content"=>addslashes(Input::getInput("content"))));
        Session::flash("message",'<div class="alert-success" style="padding: 5px;">Page Added.</div><Br>');
        Redirect::to("scheduleCms");
    }
    else if(Input::getInput("cmsId")!="" )
    {
        Db::getInstance()->update($mainTable,
            array("content"=>addslashes(Input::getInput("content"))),
            array("id"=>Input::getInput("cmsId"))

        );

        Session::flash("message",'<div class="alert-success" style="padding: 5px;">Schedule Cms Edited Successfully.</div><Br>');
        Redirect::to("scheduleCms");
    }
    else {
        Session::flash("message",'<div class="alert-error" style="padding: 5px;">Please Fill Title.</div><Br>');
        Redirect::to("scheduleCms");
    }


}
/****************Category Add & Edit Process Starts Here**********************/




/****************Category Edit Populate**********************/
$populateCms=null;
if(Input::particularInputExists("get","editId")) {

    if (Db::getInstance()->num_rows("select id from {$mainTable} where id='" . Input::getInput("editId") . "'") > 0) {
        $populateCms = Db::getInstance()->get_row("select * from {$mainTable} where id='" . Input::getInput("editId") . "'");


    }
    else {

        Redirect::to("scheduleCms");
    }
}
/****************Category Edit Populate Ends**********************/





/****************Category Delete**********************/


if(Input::particularInputExists("get","deleteId")) {

    if (Db::getInstance()->num_rows("select id from {$mainTable} where id='" . Input::getInput("deleteId") . "'") > 0) {
        Db::getInstance()->delete($mainTable,array("id"=>Input::getInput("deleteId")));

        Session::flash("message",'<div class="alert-success" style="padding: 5px;">Page Deleted.</div><Br>');
        Redirect::to("Cms");

    } else {
        Redirect::to("Cms");
    }
}

/****************Category Delete Ends**********************/



?><!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>Schedule Cms - <?php echo Config::get("project/site_title"); ?></title>
    <!-- Tell the browser to be responsive to screen width -->
    <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
    <link rel="shortcut icon" href="dist/img/admin-panel.png">
    <!-- Bootstrap 3.3.6 -->
    <link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
    <!-- Font Awesome -->
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.5.0/css/font-awesome.min.css">
    <!-- Ionicons -->
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/ionicons/2.0.1/css/ionicons.min.css">

    <?php include("includes/inc-editor-css.php"); ?>

    <!-- Theme style -->
    <link rel="stylesheet" href="plugins/datatables/dataTables.bootstrap.css">


    <link rel="stylesheet" href="dist/css/AdminLTE.min.css">
    <!-- AdminLTE Skins. Choose a skin from the css/skins
         folder instead of downloading all of them to reduce the load. -->
    <link rel="stylesheet" href="dist/css/skins/_all-skins.min.css">

    <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
    <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
    <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->


    <Style>
        #result{
            margin-left:5px;
        }

        .short{
            color:#FF0000;
        }

        .weak{
            color:#E66C2C;
        }

        .good{
            color:#2D98F3;
        }

        .strong{
            color:#006400;
        }</Style>

</head>
<body class="hold-transition skin-blue sidebar-mini">
<div class="wrapper">




    <?php include("includes/header.php"); ?>






    <?php include("includes/sidebar.php"); ?>


    <!-- Content Wrapper. Contains page content -->
    <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
            <h1>
                Schedule Cms
                <small></small>
            </h1>
            <ol class="breadcrumb">
                <li><a href="Dashboard"><i class="fa fa-dashboard"></i> Home</a></li>
                <li class="active">Schedule Cms</li>
            </ol>
        </section>

        <!-- Main content -->
        <section class="content">

            <div class="row">


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

                    <?php echo  Session::flashDisplay("message"); ?>
                    
                    <!--<a href="scheduleCms?addNew" class="btn btn-primary" style="margin-bottom: 10px;">Add New</a>-->
                    <?php if(isset($_GET["addNew"]) || isset($_GET["editId"])){ ?>
                        <!-- general form elements -->
                        <div class="box box-primary">
                            <div class="box-header with-border">

                            </div>
                            <!-- /.box-header -->
                            <!-- form start -->
                            <form role="form" action="scheduleCms" method="post" id="form_">
                                <div class="box-body">
                                    <div class="alert-danger" style="padding: 5px;display: none;" id="error">* Fields Required.</div>


                                   <?php  $dbProvinces=Db::getInstance()->get_results("select id,province from province");

                                    $provinces=array();
                                    if(count($dbProvinces)) foreach($dbProvinces as $dbProvince)
                                    {
                                        $provinces[$dbProvince["id"]]=$dbProvince["province"];
                                    }
                                    // print_r($provinces);
                                    ?>


                                    <div class="form-group">
                                        <label for="exampleInputPassword1">Select Location *</label>
                                        <select name="province_id" class="form-control" disabled>
                                            <?php echo Input::getSelected("location",$populateCms,$provinces); ?>
                                        </select>


                                    </div>




                                    <div class="form-group">
                                        <label for="exampleInputPassword1">Content *</label>
                                        <textarea type="text" class="form-control" name="content"  id="editor1"><?php echo Input::getInput("content",$populateCms); ?></textarea>
                                    </div>








                                    <input type="hidden" name="cmsId" value="<?php echo Input::getInput("id",$populateCms); ?>">

                                    <input type="hidden" name="token" value="<?php echo Token::generate(); ?>">
                                </div>
                                <!-- /.box-body -->

                                <div class="box-footer">
                                    <button type="submit" class="btn btn-primary" onclick="checkFields();return false;">Submit</button>
                                </div>
                            </form>
                        </div>
                        <!-- /.box -->
                    <?php } ?>



                </div>
                <!-- /.col -->






                <div class="col-md-12">
                    <div class="box">
                        <div class="box-header">
                            <h3 class="box-title">Schedules</h3>
                        </div>
                        <!-- /.box-header -->
                        <div class="box-body">
                            <table id="example1" class="table table-bordered table-striped">
                                <thead>
                                <tr>
                                    <th>No.</th>
                                    <th>Location</th>
                                    <th>Creation Date</th>
                                    <th>Edit</th>
                                    <!--<th>Delete</th>-->
                                </tr>
                                </thead>
                                <tbody>

                                <?php

                               // Db::getInstance()->insert("schedule_cms",array("location"=>15,'content'=>''));

                                $cmss=Db::getInstance()->get_results("select schedule_cms.*,province.province from schedule_cms
LEFT JOIN province ON (province.id=schedule_cms.location)");
                                $sno=1;
                                if(count($cmss)) {
                                    foreach ($cmss as $cms) {

                                        $date = new DateTime($cms["date_time"]);

                                        echo '<tr>';
                                        echo '<Td>' . $sno . '</Td>';

                                        echo '<Td>' . $cms["province"] . '</Td>';

                                        echo '<Td>' . $date->format("Y-m-d") . '</Td>';

                                        echo '<Td><A href="scheduleCms?editId='.$cms["id"].'"> <i class="fa fa-pencil-square-o fa-lg" aria-hidden="true"></i></A> </Td>';

                                       /* echo '<Td><A href="scheduleCms?deleteId='.$cms["id"].'" onclick="return confirm(\'Are you sure you want to delete Page?\');"> <i class="fa fa-trash fa-lg" aria-hidden="true"></i></A> </Td>';*/



                                        echo '</tr>';

                                        $sno++;

                                    }
                                }


                                ?>


                                </tbody>

                            </table>
                        </div>
                        <!-- /.box-body -->
                    </div>

                </div>










            </div>





        </section>
        <!-- /.content -->
    </div>
    <!-- /.content-wrapper -->

    <?php include("includes/footer.php"); ?>


    <!-- Add the sidebar's background. This div must be placed
         immediately after the control sidebar -->
    <div class="control-sidebar-bg"></div>
</div>
<!-- ./wrapper -->




<!-- jQuery 2.2.3 -->
<script src="plugins/jQuery/jquery-2.2.3.min.js"></script>
<!-- Bootstrap 3.3.6 -->
<script src="bootstrap/js/bootstrap.min.js"></script>
<!-- Slimscroll -->
<script src="plugins/slimScroll/jquery.slimscroll.min.js"></script>
<!-- FastClick -->
<script src="plugins/fastclick/fastclick.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/app.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>
<script src="plugins/datatables/jquery.dataTables.min.js"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js"></script>

<?php include("includes/inc-editor-js.php"); ?>

<script>
    $(function () {
        $("#example1").DataTable();
        $('#example2').DataTable({
            "paging": true,
            "lengthChange": false,
            "searching": false,
            "ordering": true,
            "info": true,
            "autoWidth": false
        });
    });


    function checkFields()
    {


            $("#form_").submit();


    }
</script>


</body>
</html>
