|
发表于 2016-12-7 08:31:16
|
显示全部楼层
SELECT proposal.proposal_number
,proposal.title
,proposal.name
,proposal_type.proposal_type as type
,proposal.handle_way
,proposal.content
,proposal.accessories_url
,proposal.committee_number
,proposal.situation
,proposal.date
,proposal_classification.proposal_classification_name
,proposal.th_name
,proposal.times_name
,proposal.level
,proposal_state.proposal_state as handle_situation
,proposal.implement_situation_number
,proposal.examine
,proposal.examine_flag
,proposal.filing_flag
,proposal.modify_flag
,proposal.reminded_flag
,publication_flag
,use_flag
,chushen_date
,zhongshen_date
,jiaoban_date
,jgdy
,brzx
,trdx
,trwt
,dyctc
,dctc
,proposalnumber
,user_name
,proposal.user_login
,proposal.datetime
,proposalnumber_classification
,proposal.delete_flag
,jiaoban_flag
,secrecy
,retrun_modify
,retrun_modify_flag
,preliminary_examine
,year
,re_jiaoban_flag
,man_count
,user_number
,receive_userlogin
,receive_date
,receive_flag
,proposal.id
,group_number
,preliminary_examine_flag
,proposal.proposal_type_number
,proposal.proposal_state_number
,proposal.proposal_classification_numbers
,gov_number
,gov_number_flag
FROM proposal left join proposal_classification on proposal.proposal_classification_numbers = proposal_classification.proposal_classification_numbers
left join proposal_state on proposal.proposal_state_number = proposal_state.proposal_state_number
left join proposal_type on proposal.proposal_type_number = proposal_type.proposal_type_number
where proposal.committee_number=:user_number
order by proposal.id desc |
|