<?php
namespace App\city;
use App\Model\Database as DB;
use App\Message\Message;
use App\Utility\Utility;
use PDO;
class City extends DB
{   public $id="";
    public $user_name="";
    public $user_city="";
    public function __construct()
    {
        parent::__construct();
    }
    public function setData($data=NULL)
    {
        if(array_key_exists('id',$data))
        {
            $this->id=$data['id'];
        }
        if(array_key_exists('user_name',$data))
        {
            $this->user_name=$data['user_name'];
        }
        if(array_key_exists('state',$data))
        {
            $this->user_city=$data['state'];
        }
    }
    public function store()
    {
        $arr= array($this->user_name,$this->user_city);
        $sql="insert into city (user_name,user_city) values (?,?)";
        $STH=$this->DBH->prepare($sql);
        $STH->execute($arr);
        Message::message("<div id='msg'><h3 align='center'>[ UserName: $this->user_name ] , [ UserCity: $this->user_city]        <br> Data Has Been Inserted Successfully!</h3></div>");
        Utility::redirect('create.php');
    }
    public function index($mode="ASSOC"){

        $mode=strtoupper($mode);
        $STH = $this->DBH->query('SELECT * from city WHERE is_delete=0');
        if($mode=="OBJ")
            $STH->setFetchMode(PDO::FETCH_OBJ);
        else
            $STH->setFetchMode(PDO::FETCH_ASSOC);
        $arrAllData  = $STH->fetchAll();
        return $arrAllData;
    }
    public function view($fetchMode="ASSOC"){

        $STH = $this->DBH->query('SELECT * from city where id='.$this->id);

        $fetchMode = strtoupper($fetchMode);
        if(substr_count($fetchMode, "OBJ")>0)
            $STH->setFetchMode(PDO::FETCH_OBJ);
        else
            $STH->setFetchMode(PDO::FETCH_ASSOC);
        $arrOneData  = $STH->fetch();
        return $arrOneData;

    }// end of view()
    public function update(){

            $arrData = array($this->user_name, $this->user_city);
            $sql = 'UPDATE city  SET user_name  = ?,user_city = ? where id =' . $this->id;
            $STH = $this->DBH->prepare($sql);
            $result = $STH->execute($arrData);
            if ($result)
                Message::message("<div  id='message'><h3 align='center'> Success! Data Has Been Updated Successfully!</h3></div>");
            else
                Message::message("<div id='message'><h3 align='center'> Failed! Data Has Not Been Updated Successfully!</h3></div>");
            Utility::redirect('index.php');
    }// end of update()
    public function delete(){
        $sql='DELETE FROM city WHERE id='.$this->id;
        $STH = $this->DBH->prepare($sql);
        $result = $STH->execute();
        if($result)
            Message::message("<div  id='message'><h3 align='center'> Success! Data Has Been Deleted Successfully!</h3></div>");
        else
            Message::message("<div id='message'><h3 align='center'> Failed! Data Has Not Been Deleted Successfully!</h3></div>");
        Utility::redirect('index.php');

    }
    public function trash(){
        try{
            $query="UPDATE city SET is_delete=:true where id=:id";
            $stmt=$this->DBH->prepare($query);
            $stmt->execute(
                array(
                    ':true'=>'1',
                    ':id'=>$this->id,
                )
            );
            Utility::redirect('index.php');
        }
        catch(PDOException $e){
            echo 'Error'.$e->getMessage();
        }
    }
    public function show($fetchMode="ASSOC"){
        try{
            $STH = $this->DBH->query('SELECT id,user_name,user_city from city where id='.$this->id);
            $fetchMode = strtoupper($fetchMode);
            if(substr_count($fetchMode, "OBJ")>0)
                $STH->setFetchMode(PDO::FETCH_OBJ);
            else
                $STH->setFetchMode(PDO::FETCH_ASSOC);
            $arrOneData  = $STH->fetch();
            return $arrOneData;
        }catch(PDOException $e){
            echo 'Error'.$e->getMessage();
        }
    }//end of show
    public function trashList($mode="ASSOC"){

        $mode=strtoupper($mode);
        $STH = $this->DBH->query('SELECT * from city WHERE is_delete=1 ORDER BY id DESC');
        if($mode=="OBJ")
            $STH->setFetchMode(PDO::FETCH_OBJ);
        else
            $STH->setFetchMode(PDO::FETCH_ASSOC);
        $arrAllData  = $STH->fetchAll();
        return $arrAllData;
    }// end of trash List
    public function restore(){
        try{
            $query="UPDATE city SET is_delete=:true where id=:id";
            $stmt=$this->DBH->prepare($query);
            $stmt->execute(
                array(
                    ':true'=>'0',
                    ':id'=>$this->id,
                )
            );
            if($stmt){
                Message::message("<div  id='message'><h3 align='center'> Success! Data Has Been Restored Successfully!</h3></div>");
                Utility::redirect('trashList.php');
            }
        }
        catch(PDOException $e){
            echo 'Error'.$e->getMessage();
        }
    }//end of restore
    public function indexPaginator($page=1,$itemsPerPage=3){
        try{
            $start = (($page-1) * $itemsPerPage);

            $sql = "SELECT * from city  WHERE is_delete =0 ORDER BY id DESC LIMIT $start,$itemsPerPage";

            $STH = $this->DBH->query($sql);

            $STH->setFetchMode(PDO::FETCH_OBJ);

            $arrSomeData  = $STH->fetchAll();
            return $arrSomeData;
        }catch(PDOException $e){
            echo 'Error'.$e->getMessage();
        }
    }// end of indexPaginator();
    public function search($requestArray){
        $sql = "";
        if( isset($requestArray['byTitle']) && isset($requestArray['byAuthor']) )  $sql = "SELECT * FROM `city` WHERE `is_delete` =0 AND (`user_name` LIKE '%".$requestArray['search']."%' OR `user_city` LIKE '%".$requestArray['search']."%')";
        if(isset($requestArray['byTitle']) && !isset($requestArray['byAuthor']) ) $sql = "SELECT * FROM `city` WHERE `is_delete` =0 AND `user_name` LIKE '%".$requestArray['search']."%'";
        if(!isset($requestArray['byTitle']) && isset($requestArray['byAuthor']) )  $sql = "SELECT * FROM `city` WHERE `is_delete` =0 AND `user_city` LIKE '%".$requestArray['search']."%'";

        $STH  = $this->DBH->query($sql);
        $STH->setFetchMode(PDO::FETCH_OBJ);
        $allData = $STH->fetchAll();

        return $allData;

    }// end of search()
    public function getAllKeywords()
    {
        $_allKeywords = array();
        $WordsArr = array();
        $sql = "SELECT * FROM city WHERE is_delete =0";

        $STH = $this->DBH->query($sql);
        $STH->setFetchMode(PDO::FETCH_OBJ);

        // for each search field block start
        $allData= $STH->fetchAll();
        foreach ($allData as $oneData) {
            $_allKeywords[] = trim($oneData->user_name);
        }

        $STH = $this->DBH->query($sql);
        $STH->setFetchMode(PDO::FETCH_OBJ);

        $allData= $STH->fetchAll();
        foreach ($allData as $oneData) {

            $eachString= strip_tags($oneData->user_name);
            $eachString=trim( $eachString);
            $eachString= preg_replace( "/\r|\n/", " ", $eachString);
            $eachString= str_replace("&nbsp;","",  $eachString);
            $WordsArr = explode(" ", $eachString);

            foreach ($WordsArr as $eachWord){
                $_allKeywords[] = trim($eachWord);
            }
        }
        // for each search field block end




        // for each search field block start
        $STH = $this->DBH->query($sql);
        $STH->setFetchMode(PDO::FETCH_OBJ);
        $allData= $STH->fetchAll();
        foreach ($allData as $oneData) {
            $_allKeywords[] = trim($oneData->user_city);
        }
        $STH = $this->DBH->query($sql);
        $STH->setFetchMode(PDO::FETCH_OBJ);
        $allData= $STH->fetchAll();
        foreach ($allData as $oneData) {

            $eachString= strip_tags($oneData->user_city);
            $eachString=trim( $eachString);
            $eachString= preg_replace( "/\r|\n/", " ", $eachString);
            $eachString= str_replace("&nbsp;","",  $eachString);
            $WordsArr = explode(" ", $eachString);

            foreach ($WordsArr as $eachWord){
                $_allKeywords[] = trim($eachWord);
            }
        }
        // for each search field block end


        return array_unique($_allKeywords);


    }// get all keywords
    public function deleteSelected($id){

        $sql='DELETE FROM city WHERE id='.$id;
        $STH = $this->DBH->prepare($sql);
        $result = $STH->execute();
        if($result)
            Message::message("<div  id='message'><h3 align='center'> Success! Data Has Been Deleted Successfully!</h3></div>");
        else
            Message::message("<div id='message'><h3 align='center'> Failed! Data Has Not Been Deleted Successfully!</h3></div>");
        Utility::redirect('index.php');
    }//end of delete selected
    public function trashSelected($id){
        try{
            $query="UPDATE city SET is_delete=:true where id=:id";
            $stmt=$this->DBH->prepare($query);
            $result=$stmt->execute(
                array(
                    ':true'=>'1',
                    ':id'=>$id,
                )
            );
            if($result)
                Message::message("<div  id='message'><h3 align='center'> Success! Multiple Data Has Been Trashed Successfully!</h3></div>");
            else
                Message::message("<div id='message'><h3 align='center'> Failed! Multiple Data Has Not Been Trashed Successfully!</h3></div>");
            Utility::redirect('index.php');
        }
        catch(PDOException $e){
            echo 'Error'.$e->getMessage();
        }
    }//end of trash selected
    public function restoreSelected($id){
        try{
            $query="UPDATE city SET is_delete=:true where id=:id";
            $stmt=$this->DBH->prepare($query);
            $stmt->execute(
                array(
                    ':true'=>'0',
                    ':id'=>$id,
                )
            );
            if($stmt){
                Message::message("<div  id='message'><h3 align='center'> Success! Multiple Data Has Been Restored Successfully!</h3></div>");
                Utility::redirect('index.php');
            }

        }
        catch(PDOException $e){
            echo 'Error'.$e->getMessage();
        }
    }//end of restore selected

}