_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; } function getReceiptByRid($rid = '') { Doo::loadClass ( 'XDeode' ); $XDeode = new XDeode ( 5 ); Doo::loadModel ( 'L_category' ); $Lcategory = new L_category (); Doo::loadModel ( 'staff' ); $staff = new staff (); if (! is_numeric ( $rid )) $rid = $XDeode->decode ( $rid ); $rinfo = $this->getOne ( array ( 'where' => 'rid=' . $rid, 'asArray' => true ) ); $rinfo['ridKey']=$XDeode->encode ( $rinfo ['rid'] ); $rinfo['trainLoanRidKey']=$XDeode->encode ( $rinfo ['trainLoanRid'] ); $rinfo['category']=$Lcategory->getCategoryById($rinfo['cid']); $rinfo['staffDetail']=$staff->getStaffBySid($rinfo['staff']); return $rinfo; } /** * 默认获得10条 * @param unknown $sid * @param unknown $cid * @param unknown $limit */ function getReceiptLoanByStatus($sid,$cid,$status,$limit=10){ $sql=''; if ($sid!==false&&is_numeric($sid)){ $sql.=' and staff='.$sid; } if ($cid!==false&&is_numeric($cid)){ $sql.=' and cid='.$cid; } $list = $this->find ( array ( 'where' => 'Rtype=1 and status=' . $status.$sql, 'asArray' => true ) ); Doo::loadClass ( 'XDeode' ); $XDeode = new XDeode ( 5 ); foreach ($list as $key=>$value){ $list[$key]['ridKey']=$XDeode->encode ( $list[$key] ['rid'] ); } return $list; } /** * 根据参数字段更新相应字段（主键ID必须传） * @param array $item 相关需要更新的字段信息 * @return number 返回发票ID */ public function setReceiptByCondition($item = array(), $rid = "") { $lid = 0; if (is_array ( $item ) && ! empty ( $item )) { foreach ( $item as $key => $value ) { $this->$key = $value; } if (! empty ( $isid )) { $condition = array ( 'where' => "rid in (" . $rid . ")", 'asArray' => TRUE ); $this->update ( $condition ); } else $lid = $this->update (); } return $lid; } } ?>