public function search($where, &$page = NULL)
 {
     $sql = "SELECT a.*,b.user_name from {$this->_table} a inner join  mp_account b on a.id = b.other_id and sorts = 2 ";
     $sqlCnt = "SELECT COUNT(*) AS cnt FROM mp_corporate a inner join  mp_account b on a.id = b.other_id and sorts = 2  ";
     // 		$sql = "SELECT a.*,(select  user_name FROM {$this->_table} where  id  = a.u_user) as m_user_name from {$this->_table} a ";
     return parent::search($where, $page, $sql, $sqlCnt);
 }
 public function search($where, &$page = NULL)
 {
     $sql = "SELECT a.* from {$this->_table} a ";
     // 		$sql = "SELECT a.*,(select  user_name FROM {$this->_table} where  id  = a.u_user) as m_user_name from {$this->_table} a ";
     $order = "id desc ";
     return parent::search($where, $page, $sql, null, $order);
 }
 public function search_csv($where)
 {
     $sql = "SELECT a.*,b.ins_co_name,c.electric_name,(select  user_name FROM {$this->_table} where  id  = a.u_user) as m_user_name from {$this->_table} a ";
     $sql = $sql . " LEFT JOIN  M_INS_CO b ON a.ins_co_cd = b.ins_co_cd ";
     $sql = $sql . " LEFT JOIN  M_ELECTRIC c ON a.electric_id = c.id ";
     $page = null;
     return parent::search($where, $page, $sql);
 }
 public function search($where, &$page = NULL, $pro = NULL)
 {
     $sqljoin = " select spec_id, group_concat(pro_name) as proname from mp_pro  ";
     if ($pro) {
         $sqljoin = " inner join (" . $sqljoin . " where pro_id in " . $pro . " group by spec_id ) c on c.spec_id = a.id ";
     } else {
         $sqljoin = " left join  (" . $sqljoin . " group by spec_id ) c on c.spec_id = a.id ";
     }
     $sql = "SELECT a.*,b.user_name,c.proname from {$this->_table} a inner join  mp_account b on a.id = b.other_id and sorts = 3 {$sqljoin}";
     $sqlCnt = "SELECT COUNT(*) AS cnt FROM {$this->_table} a inner join  mp_account b on a.id = b.other_id and sorts = 3  ";
     if ($pro) {
         $sqlCnt = $sqlCnt . $sqljoin;
     }
     //print_r($sql);exit;
     // 		$sql = "SELECT a.*,(select  user_name FROM {$this->_table} where  id  = a.u_user) as m_user_name from {$this->_table} a ";
     return parent::search($where, $page, $sql, $sqlCnt);
 }
 public function getProBySpecId($specid)
 {
     $sql = 'select *  from mp_pro where spec_id = ' . $specid;
     return parent::search($where = null, $page = null, $sql);
 }