_table . " where staff= '".$sid."' ".$dateCondition." and status=2 "; //echo '
'.$sql.'
'; $query = Doo::db ()->query ( $sql ); $result = $query->fetch (); return $result; } function getReceiptBySid($sid='',$year='',$month=''){ Doo::loadClass ( 'XDeode' ); $XDeode = new XDeode ( 5 ); if(empty($sid)) return array(); $sql = 'select a.* from ' . $this->_table . ' as a left join CLD_receiptDetail as b on b.rid=a.rid where b.staff =' . $sid . ' and Month(b.pastDate)=' . $month . ' and Year(b.pastDate)=' . $year.' and b.status=1 GROUP BY b.rid'; $query = Doo::db ()->query ( $sql ); $list = $query->fetchAll (); foreach ($list as $key=>$value){ $list [$key] ['ridKey'] = $XDeode->encode ( $value ['rid'] ); } return $list; } } ?>