find ( array ('desc' => 'time', 'where' => 'aid=' . $aid, 'asArray' => TRUE ) ); } function getArticleByTrain($trainingType=2){ return $this->find ( array ('desc' => 'time', 'where' => 'a_type=2 and trainingType='.$trainingType, 'asArray' => TRUE ) ); } // function getArticleByTrain2($trainingType= '',$area = ''){ // $sql = ''; // if($trainingType != ''){ // $sql .= ' and trainingType='.$trainingType; // } // if($area != ''){ // $sql .= ' and area="'.$area.'"'; // } // $sql .= ' and time+63072000 >= unix_timestamp(now())'; // return $this->find ( array ('desc' => 'time', 'where' => 'a_type=2'.$sql, 'asArray' => TRUE ) ); // } // // function getArticleByTrain3(){ // $sql = ''; // $sql .= ' and time+63072000 >= unix_timestamp(now())'; // return $this->find ( array ('desc' => 'time', 'where' => 'a_type=2'.$sql, 'limit' => 50, 'asArray' => TRUE ) ); // } function getArticleByTrain2($trainingType= '',$area = '', $select = false){ $condition='a_type=2 '; $parameter=array(); if($trainingType != '' && is_numeric($trainingType)){ $condition.= ' and trainingType= ?'; array_push($parameter, $trainingType); } if($area != ''){ $condition.= ' and area=?'; array_push($parameter, $area); } $condition.=' and time+63072000 >= unix_timestamp(now())'; $qualification=array( 'where' => $condition, 'param' => $parameter, 'desc'=>'time', 'asArray' => TRUE); if ($select) { $qualification+=array('select'=> 'aid,area,trainingType,time,enroll_time,enroll_title'); } $result=$this->find($qualification); return $result; /* $sql = ''; if($trainingType != '' && is_numeric($trainingType)){ $sql .= ' and trainingType='.$trainingType; } if($area != ''){ $sql .= ' and area="'.$area.'"'; } $sql .= ' and time+63072000 >= unix_timestamp(now())'; if ($select) { return $this->find ( array ('select'=> 'aid,area,trainingType,time,enroll_time,enroll_title', 'desc' => 'time' , 'where' => 'a_type=2'.$sql, 'asArray' => TRUE ) ); } else { return $this->find ( array ('desc' => 'time', 'where' => 'a_type=2'.$sql, 'asArray' => TRUE ) ); } */ } function getArticleByTrain3($select = false){ $sql = ''; $sql .= ' and time+63072000 >= unix_timestamp(now())'; if ($select) { return $this->find ( array ('select'=> 'aid,area,trainingType,time,enroll_time,enroll_title', 'desc' => 'time', 'where' => 'a_type=2'.$sql, 'limit' => 50, 'asArray' => TRUE ) ); } else { return $this->find ( array ('desc' => 'time', 'where' => 'a_type=2'.$sql, 'limit' => 50, 'asArray' => TRUE ) ); } } function getArticleNumByTrain2($trainingType= '',$area = ''){ $condition='a_type=2 '; $parameter=array(); if($trainingType != '' && is_numeric($trainingType)){ $condition.= ' and trainingType= ?'; array_push($parameter, $trainingType); } if($area != ''){ $condition.= ' and area=?'; array_push($parameter, $area); } $condition.=' and time+63072000 >= unix_timestamp(now())'; $qualification=array( 'where' => $condition, 'param' => $parameter, 'asArray' => TRUE); return $this->count($qualification); /* $sql = ''; if($trainingType != '' && is_numeric($trainingType)){ $sql .= ' and trainingType='.$trainingType; } if($area != ''){ $sql .= ' and area="'.$area.'"'; } $sql .= ' and time+63072000 >= unix_timestamp(now())'; return $this->count ( array ('where' => 'a_type=2'.$sql, 'asArray' => TRUE ) ); */ } function getArticleByTrainAid($aid){ return $this->find ( array ('desc' => 'time', 'where' => 'a_type=2 and aid='.$aid, 'asArray' => TRUE ) ); } function getArticleByCid($cid = 0,$limit) { return $this->find ( array ('desc' => 'time', 'limit'=>$limit , 'where' => 'cid=' . $cid, 'asArray' => TRUE ) ); } function getArticleByCid3($cid = 0,$limit) { return $this->find ( array ('desc' => 'update_time', 'limit'=>$limit , 'where' => 'cid=' . $cid, 'asArray' => TRUE ) ); } function getArticleByCid2($cid = 0,$limit) { return $this->find ( array ('desc' => 'update_time', 'limit'=>$limit , 'where' => '(cid=' . $cid .' or cid=3 or cid=7) and title !=""', 'asArray' => TRUE ) ); } function getArticleList($data = array(), $condition = "", $limit = ""){ foreach ( $data as $key => $value ) { if (is_numeric ( $value )) $condition .= " and " . $key . " = " . $value; else $condition .= " and " . $key . " like '%" . $value . "%' "; } $condition = ' where 1 ' . $condition . $limit; $sql = "select * from " . $this->_table . $condition; $query = Doo::db ()->query ( $sql ); $result = $query->fetchAll (); return $result; } function deleteArticleByIdList($id){ $id = implode ( ",", $id ); $sql = "delete from " . $this->_table . " where aid in ( " . $id . " )"; Doo::db ()->query ( $sql ); } function getArticleListbyLimit($sql, $limit){ return $this->find ( array ('where' => $sql, 'desc' => 'time', 'limit'=>$limit, 'asArray' => TRUE ) ); } } ?>