<?php
class Extras_Entertain_Model extends Plugin_Model
{

	private $tablename = 'space_toogle';

	public function gettoogle($msisdn) {
        $dbConn = $this->_loadDSN('mysqlRead');
        $sql = 'SELECT * FROM space_toogle WHERE msisdn = "'.$msisdn.'"';
        $result  = $dbConn->fetchOne($sql);
        $this->appLogger->write('debug', __METHOD__ .' > SQL:'.$sql.' RESULT:'.print_r($result,1));
        if( $result ){
            return $result;
        }
        return false;
    }

        public function settoogle($msisdn) {
        $query          = 'UPDATE space_toogle SET st_toggle = '1',date_reg = now() WHERE msisdn = "'.$msisdn.'"';
        $dbWrite        = $this->_loadDSN('mysqlWrite');
        $result         = $dbWrite->query($query);
        $this->appLogger->write('debug', __METHOD__ .' > SQL:'.$query.' RESULT:'.print_r($result,1));
        if($result){
            return TRUE;
        } else {
            return FALSE;
        }
    }

        public function puttoogleData($sData) {
        $msisdn         = trim($sData['msisdn']);
        $serviceID      = $sData['serviceID'];
        $st_toggle      = $sData['st_toggle'];
        $query          = sprintf("INSERT INTO space_toogle (msisdn,serviceID,st_toggle,date_reg) VALUES ('%s', '%s', '%s', now()); ",$msisdn,$serviceID,$st_toggle);
        $dbWrite        = $this->_loadDSN('mysqlWrite');
        $result         = $dbWrite->query($query);
        $this->appLogger->write('debug', __METHOD__ .' > SQL:'.$query.' RESULT:'.print_r($result,1));
        if($result){
            return TRUE;
        } else {
            return FALSE;
        }
    }


}