<?php
/**
 * @author GTFW CRUD Generator 
 */
 
class TblMember extends Database
{

    public function __construct($connectionNumber = 0)
    {
        parent::__construct($connectionNumber);
        $this->LoadSql('module/tbl.member/business/mysqlt/tblmember.sql.php');
        $this->SetDebugOn();
    }

    public function countTblMember($filter)
    {
        if (is_array($filter))
            extract($filter);
        $str = '';
        
        if (!empty($name)) {
            $str .= " AND LOWER(member_name) LIKE('%$name%')";
        }
        if (!empty($job)) {
            $str .= " AND LOWER(member_job) LIKE('%$job%')";
        }
        if (!empty($address)) {
            $str .= " AND LOWER(member_address) LIKE('%$address%')";
        }
        $query = $this->mSqlQueries['count_tblmember'];
        $query = str_replace('--search--', $str, $query);
        $result = $this->Open($query, array());
        return $result[0]['total'];
    }

    public function getTblMember($filter)
    {
        if (is_array($filter))
            extract($filter);
        $str = '';
        
        if (!empty($name)) {
            $str .= " AND LOWER(member_name) LIKE('%$name%')";
        }
        if (!empty($job)) {
            $str .= " AND LOWER(member_job) LIKE('%$job%')";
        }
        if (!empty($address)) {
            $str .= " AND LOWER(member_address) LIKE('%$address%')";
        }
        $limit = '';
        if (!empty($display)) {
            $limit = "LIMIT $start, $display";   
        }
        $query = $this->mSqlQueries['get_tblmember'];
        $query = str_replace('--search--', $str, $query);
        $query = str_replace('--limit--', $limit, $query);
        $result = $this->Open(stripslashes($query), array());
        return $result;

    }

    public function getDetailTblMember($id)
    {
        $result = $this->Open($this->mSqlQueries['get_detail_tblmember'], array($id));
        if ($result) {
            return $result[0];
        }
    }
    
    public function insertTblMember($params)
    {
        return $this->Execute($this->mSqlQueries['insert_tblmember'], $params);
    }
    
    public function updateTblMember($params)
    {
        return $this->Execute($this->mSqlQueries['update_tblmember'], $params);
    }
    
    public function deleteTblMember($id)
    {
        return $this->Execute($this->mSqlQueries['delete_tblmember'], array($id));
    }
    
    public function listTblMember()
    {
        return $this->Open($this->mSqlQueries['list_tblmember'], array());
    }
}

// End of file TblMember.class.php