<?php
/**
 * Class that operate on table 'bind'. Database Mysql.
 *
 * @author: http://phpdao.com
 * @date: 2016-07-04 13:42
 */
class BindMySqlExtDAO extends BindMySqlDAO{

	public function queryByEmployeeidAndDeleted($employeeId, $deleted) {
        $sql = 'SELECT * FROM bind WHERE employeeid = ? and deleted = ?';
        $sqlQuery = new SqlQuery($sql);
        $sqlQuery->setNumber($employeeId);
        $sqlQuery->setNumber($deleted);
        return $this->getList($sqlQuery);
    }

    public function getAllEmployeeWithBind() {
        $sql = 'SELECT distinct b.employeeid , e.employeeName
               FROM bind     b
               join  employee    e           on    e.employeeId = b.employeeid ';
        $sqlQuery = new SqlQuery($sql);
        return $this->getList($sqlQuery);
    }


        public function searchBinds($deleted, $q1) {
        $sql = 'SELECT * FROM bind WHERE  deleted = ' . $deleted . ' ' . $q1 . ' ';
        $sqlQuery = new SqlQuery($sql);
        return $this->getList($sqlQuery);
    }

}
?>