rendered paste body function searchFor($str, $searchType = null) { switch($searchType) { case null: $cond = array('OR' =>array('EmpCode'=> 'LIKE %'.$str.'%', 'NAME'=> 'LIKE %'.$str.'%', 'AKA'=> 'LIKE %'.$str.'%', 'CSR_Inits'=> 'LIKE %'.$str.'%', 'SalesNo'=> 'LIKE %'.$str.'%'));//,// 'OR' => array('REHIRE_DT'=>'<> NULL',// 'TermDate' => 'NULL')); break; case 'by_super': $cond = array('SuperName' => $str, 'TermDate' => 'NULL', 'OR' => array('REHIRE_DT'=>'NOT NULL')); break; default : return false; break; } return $this->findAll($cond, 'EmpNo, EmpCode, FNAME, LNAME, MInitial, AKA, CSR_Inits','NAME'); }